Example of how I use Excel QM Template in my Operations Planning and Control class to create the Aggregate Plan for a company. This specific example is for a level production with constant number of workers plus subcontracting. The template provides opportunity to generate different aggregate planning strategies and pick the best one for your company.
The template also generates a chart illustrating the demand, regular production and the subcontracting quantities for this specific plan.
