AGGREGATE PLANNING
zara__993
Ch13Ex5_1_.xlsxSheet1
Trans_agg
| CHAPTER 13: Example 5 | ||||||
| Aggregate (Production) Planning as a Transportation Model | ||||||
| Cost per unit | ||||||
| Regular time | 40.0 | |||||
| Overtime cost | 50.0 | |||||
| Subcontract cost | 70.0 | |||||
| Holding cost | 2.0 | |||||
| Data | ||||||
| COSTS | March | April | May | Excess Capacity | Capacity | |
| Beginning inventory | 0.0 | 2.0 | 4.0 | 6.0 | 100.0 | |
| March reg time | 40.0 | 42.0 | 44.0 | 0.0 | 700.0 | |
| March overtime | 50.0 | 52.0 | 54.0 | 0.0 | 50.0 | |
| March subcontracting | 70.0 | 72.0 | 74.0 | 0.0 | 150.0 | |
| April reg time | 999999.0 | 40.0 | 42.0 | 0.0 | 700.0 | |
| April overtime | 999999.0 | 50.0 | 52.0 | 0.0 | 50.0 | |
| April subcontracting | 999999.0 | 70.0 | 72.0 | 0.0 | 150.0 | |
| May reg time | 999999.0 | 999999.0 | 40.0 | 0.0 | 700.0 | |
| May overtime | 999999.0 | 999999.0 | 50.0 | 0.0 | 50.0 | |
| May subcontracting | 999999.0 | 999999.0 | 70.0 | 0.0 | 130.0 | |
| Demand | 800.0 | 1000.0 | 750.0 | 230.0 | 2550 \ 2780 | |
| Production Quantities | ||||||
| March | April | May | Excess Capacity | Row Total | ||
| Beginning inventory | 0 | 0 | 0 | 0 | 0 | |
| March reg time | 0 | 0 | 0 | 0 | 0 | |
| March overtime | 0 | 0 | 0 | 0 | 0 | |
| March subcontracting | 0 | 0 | 0 | 0 | 0 | |
| April reg time | 0 | 0 | 0 | 0 | 0 | |
| April overtime | 0 | 0 | 0 | 0 | 0 | |
| April subcontracting | 0 | 0 | 0 | 0 | 0 | |
| May reg time | 0 | 0 | 0 | 0 | 0 | |
| May overtime | 0 | 0 | 0 | 0 | 0 | |
| May subcontracting | 0 | 0 | 0 | 0 | 0 | |
| Column Total | 0 | 0 | 0 | 0 | 0 | |
| Total Cost | 0.0 | |||||
Enter production costs at top. The transportation table will be automatically filled in. Enter capacities and demands in the table. Go to DATA Tab on the ribbon, click on Solver in Data Analysis Group then click SOLVE. For problems, see Help, Solver.
