inventory depletion

Hi all, I've just started a new job and I've been asked to calculate a reorder level for each item below . I've spent all day trying to google what how to do this but I'm having so much brain fog and can't seem to wrap my head around how to calculate it the correct way/find a formula that...

I am trying to create an inventory based database for our online orders. There are 10 different bundles that consist of multiple products that can also be shipped individually if not apart of a bundle. What I want to be able to do is create a day by day process where a window pops up asking what...

I have 2 sheets: one with Inventory for a day (8/30) and another with sales for the month with dates as 9/4, 9/7. etc. I would like to merge the two sheets so I can have a running total of inventory by taking the Inventory as of 8/30 and subtracting each day of sale invoices. I would then...

Hello, I am at a loss for figuring out what I assume to be a very complex formula. I need to find Days sales in inventory using information in Monthly buckets (28,28,35 calendar). For example: May ending inventory = $8,400,000 Next 5 Months of Cogs = $8,882,000 (sum calc June-October) Next 5...

Hello, I'm working on a problem and needing some help with a macro that will do FiFo. Example on 7/9/2013, the projected prod unit is 2241, what I need to do is applying the FiFo method by using the earliest inventory first so I will use 6/24, 6/25, 6/26, 6/27, 7/2, 7/3 and part of 07/8...