I already have the data table format for unconstrained forecast order. It need input from 3 regions every month, by plants and product, rolling 18 months. Get approved by regional VP. Then will be consolidated to one table by plant and product.
There is also an actual order intake record table. Need to compare with unconstrained order forecast.
There is SOP production table show factory plan, and need to compare with forecast too.
There is table to record actual production completion and need to compare with production plan and calculate OTD.
There should be dollar view too for forecast table and chart view.
We have SharePoint and one drive but no dynamics.
I have work out some demo, but need some expert to make it alive. I would like to have full control of the program.