Inventory Projections Using Excel - Is it possible?

See attached File

I am trying to have a rolling 12 month Inventory forecast based on the attached spreadsheet.
I am at a loss as to whether I can automatically calculte this using excel.
Challenge: I have multiple branches 1 through 22. I can easily calculate the monthly buckets for Open Orders and Open Purchase Orders. The Beginning Onhand Inventory and the Open Work Orders and the Forecast are as of the current date I run the report.
In the attached file, the tab Inventory Projections is ultimately what we would like to accomplish.
Is this even possible or are we barking up the wrong tree?

Thank you in advance for any help.
Rick G
INVENTORYTRACKING-TEST.xls
ES-ComponentsAsked:
Who is Participating?
 
david251Commented:
I am not sure if this is what you want, but try having a look at the attached file

HTH,
-David251
Copy-of-INVENTORYTRACKING-TEST.xls
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.