Excel, aggregate planning

Formulate and solve basic aggregate planning problems using Microsoft Excel. 

By optimizing the objective function (minimizing cost in Equation 8.1) subject to the listed constraints (Equations 8.2 to 8.5), the vice president obtains the aggregate plan shown in Table 8-4. (Later in the chapter, we discuss how to perform this optimization using Excel with the spreadsheet Chapters,9-examples.)... 

In the next section, we explain how to implement the linear programming methodology for aggregate planning using Microsoft 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. 

---