Aggregate Planning in Excel

Next we discuss how to generate the aggregate plan for Red Tomato in Table 8-4 using Excel. We first do so by building a simple spreadsheet that allows vv/raM/analysis and then build a more sophisticated model that allows optimization using linear programming. 

The aggregate planner must decide on the number of people hired (//,) or laid off (L,) each month, along with any overtime (O,) or subcontracting (Q). Once these decisions have been 

Output Cells Relationship to inputs Formula in Row 5 Copied to Cells 

The goal is to build an aggregate plan by changing inputs in a way that minimizes the total cost in cell C12. 

Building an Aggregate Planning Spreadsheet Using Solver 

---