Forum Discussion
Excel
I want to sum x amount of months (no more than 12) usually 4- months at a time, subtract another cell of inventory levels, then use the current date to return a date of how long the inventory will la...
EDATE($A$2,12) is the date 1 year after today.
(SUM(M5:P5)-C5) subtracts the current inventory level from the sum of pending builds.
Does it make sense to subtract that directly from a date?
HansVogelaar
Do you know of a better approach?
What I am after is having the ability for an automated return. I want to be able to take 4 months' worth of builds subtract out my current higher level of the build and then in return figure out that it will last only 1 month, 3 months and a half, 4 months and 3/4's, etc.
Do you know of a better approach?
What I am after is having the ability for an automated return. I want to be able to take 4 months' worth of builds subtract out my current higher level of the build and then in return figure out that it will last only 1 month, 3 months and a half, 4 months and 3/4's, etc.
You'll have to provide more information. How do builds and months and inventory relate to each other?
- @HansVogelaar
Let's say,
Month 1 (Aug) I have an overstock of 180PCS that overstock rolls over into Sept PB of 220 therefore I only need to build a remaining balance of 40. Oct I want to build another 220, Nov I want to build another 220, My current inventory level is 0 therefore I need to build a minimum of 479. Therefore I have roughly 1-Month and 1/2 worth of inventory.
This is the return I am looking for. either I will run out by Aug 29th, 2022, and/or I have 1-Month and 1/2 worth of inventory.
Then looking over the bigger picture I would do this for every inventory level and then organize based upon the date I am running out first, and that starts the new production schedule.
Does that help?I'll have to leave this to someone else. I don't understand this at all, sorry.