Sheet Strategy allows you to make a complete simulation of 5 periods at the same time. Sheet is divided into 5 parts, each of which completely copies sheets decision calculation 1, 2, 3, 4, 5.
When decision for 1 period is changed, demand forecast and parameters of the management decision for 2 period are updated, which lead to update of the capacity calculation and volume of raw material purchases. After correcting decision for 2 period, the forecast for the next one is also updated along the chain. Whole process is automatic, because the decision-making forms are linked with each other.
Generated solution can be copied by pressing a button on calculation sheet 1, 2, 3, 4, 5 for your convenience or for more detailed work. It is also possible to transfer the decision back from the sheet 1, 2, 3, 4, 5 to the sheet Strategy by pressing the button, specifying period.
Strategy sheet has macros that facilitate the calculation of decisions. Macros alternately sort through various options of the parameters (number of agents, management budget, training, maintenance hours, etc.) and automatically determine the option to achieve maximum profit.