Big Chemical Encyclopedia

Chemical substances, components, reactions, process design ...

Articles Figures Tables About

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. [Pg.220]

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 [Pg.220]

Output Cells Relationship to inputs Formula in Row 5 Copied to Cells [Pg.221]

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

Building an Aggregate Planning Spreadsheet Using Solver [Pg.221]


See other pages where Aggregate Planning in Excel is mentioned: [Pg.220]   


SEARCH



Aggregate planning

Excel

Excellence

© 2024 chempedia.info