Dear Experts,
We have a requirement to set Frozen Horizon flexibly based on Product Class. As such,
1. For Product Class A, forecast cannot be entered for current week and next week -> any updates can be done from Week 3 onward (considering current week as Week 1)
2. For Product Class B, forecast cannot be entered for current week and next 3 week -> any updates has to be entered from Week 5 onward
and so on.
We have written a macro to identify the time period as frozen or editable locally in excel worksheet, but the refresh time is significantly higher -> due to macro reading each cell one by one and locking.
As we are only using S&OP module for Sales Forecasting modelling, we are not configuring Product-Location based Frozen Horizon, and use Heuristics/Optimizer to prevent Supply Plan change due to changes in Sales Forecast entered in the 'frozen horizon' .
Please guide, if there is any other elegant methods that can be used fo rthis.
Regards,
Shivpriye
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.