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.