inventory

To simplify here is what I'm trying to do From this: To this: Move inventory 1 to 5 to the next month and ensure that leftovers is as close as possible to 0 but not go negative. The inventory Qty is treated as a whole and can't be combined Previous month's inventory takes priority and it can...

Okay excel genius', I'm stuck in a rut and need your help! I work at a shop that carries a stock of liquids. It is my job to keep track of the inventory on a daily basis. If this was my only job, then it would be easy, but its not. So, I began working on an Excel file that could automate the...

Hi All, I need a formula that provides the date inventory will run out based on a quantity on hand and a demand forecast. I'm assuming an array function will be necessary. I would like to assume that the demand per month is evenly spread per day. For example, Item 123A has 500 units on hand...

I'm writing a routine for a small auto-body repair business. They have a massive workbook loaded with data from online catalogs. Each sheet is broken down by Vendor, Inventory, etc. They would like to select a particular vendor in ComboBox1 (Sheet = Vendor) and then the ListBox populates with...

Hello everyone, I'm creating an accounting system that includes invoice recording and an inventory system. And I need help finding an automatic way to calculate the inventory stock. Example: Page 1: Contains Invoices Product X | 35$ | 5 Name.....Cash Paid....Quantity Purcahsed. Page 2...

I've inherited an Excel document that is used to keep track of where materials are located within out facility. Recently they asked me to include quantity counts and mark them red when quantity gets low. This part wasn't hard, simply used a <count-if> function, then set conditional formatting...

Hi, I want to create an array formula to count the number of weeks that inventory is held in stock - as per the table to the right. What formula is necessary to count this? <tbody> <colgroup><col span="2"><col><col span="2"><col><col><col><col span="3"><col><col></colgroup><tbody> WEEK...

Hello all, new to the forum. I have an issue with powerpivot/DAX that I have not been able to solve. I hope someone is up for the challenge... The problem is calculating a YTD monthly Inventory closing position while ignoring cumulative negatives if there is no stock to satisfy the forecast...

We are creating a workbook to track out daily inventory going in and out in Excel 2016. Worksheet 1 contains 3 tables: - 'Inventory built' (IN) - 'Inventory sold' (OUT) - balance of each item Worksheet 2 contains another customer's inventory that we are...

Hello, I am building an inventory production schedule and need help writing a formula for the following logic. For example, in Row A, Column A:L (January-December), I have projected sales of 25 units per month (starting in June). Additionally, my minimum monthly production order is for 30...

Hello- i have an excess inventory on hand which i need to figure out which part to keep and which part to destroy. my goal is to get a formula that will give me the desired output for the column in red font (destroy the rest). I have done a few scenarios to hopefully explain this better. As...

Hi, all I am a new user and novice without VBA knowledge. The hardest formula I can use is about Index/Match so please be nice :). I am looking for a solution which does below; 1. A cell which looks up a value from a separate tab. I currently do this by index match. (ROW10 SUPPLY FCST key...

Hello Everyone, Requesting your help. I have two excel work book named "Inventory.xls" and "Resource.xls". In a resource workbook, I have a set of resources available for the day and everyday the data may be change. In a Inventory workbook, I have a set of datas needs to be worked. I need...

Hi All I have written a code that i cant get working, Please can someone help? This code is for automating invoice to inventory so that when the invoice has a quantity of a certain item it will subtract from the stock. If i run the code it works on the first line to subtract the correct value...

Hello, I am in need of assistance. I'm working on a spreadsheet to simplify my work life and have run into a wall. At a high level, the purpose of this spreadsheet is to determine the items & inventory available for me to send to a third party weekly. I'm going to try my best to put...

- On Sheet 1 (FEED-2) I have the fiscal year (B5) with other information not applicable to this question it is just a what I call a feeder page. To get the fiscal year I have a table I created that is based off of the date to get the year, I tried just typing 2019 and still the same result...

Hi There, I have a bit of a dilemma with an excel sheet I'm working on and was hoping for a bit of advice from the experts on here. I am trying to create an excel workbook that can manage my inventory, record sales and stock purchases and display some figures in a nice little dashboard. Where...

Hello Everybody i am quite a novice I need help to automatically record inventory as per invoice (outgoing) & as per purchase order (incoming) I have sample sheet which I can send you but I can’t see how to attach it here Here is a link to the sample file...

I'm having an issue with a report and was wondering if any assistance can be provided. I've created a micro-enabled workbook that gives me 2 sheets of data(STEWARDS and INVENTORY REPORT) and even creates folders based on the information provided from my STEWARD sheet. I now want to create...

I'm having trouble figuring out a way to keep subtracting real time inventory (Column D) for part # AA as it continues to show up on a production schedule. Any ideas on a formula considering part AA may show up multiple times on a schedule with 500 other part numbers. Thanks for the help A...