Question: Manager Rob Smith put together an aggregate plan for the coming six months and now he wants to know the costs of the plan. The
Manager Rob Smith put together an aggregate plan for the coming six months and now he wants to know the costs of the plan. The following data and information consist of the aggregate plan. Table of Forecast Values for Six-Time Periods (showing number of units demanded)
| Period | Jan | Feb | March | April | May | June |
| Forecast | 400 | 380 | 420 | 440 | 460 | 480 |
The planned capacities are as follows: Regular output each month will be 400 units. Overtime output will be 40 units in April, May, and June; there will be no other overtime. The subcontracting output will be 40 units in May and 20 in June; there will be no other subcontracting. The beginning inventory is zero units.
The costs (per unit) are as follows:
- Regular output cost = $25
- Overtime output cost = $40
- Subcontract output cost = $60
- Inventory carrying cost = $15
Use the template for Aggregate Planning and calculate the costs of the plan.
If there is no cost write "$0" or "none".
Write the dollar portion only; do not write the cents portion. In other words, if a value is five thousand dollars, write $5,000 and do not write $5,000.00
Regular Production Cost:
Part-Time Production Cost:
Overtime Production Cost
Subcontractor Cost:
Inventory Costs:
Total Cost of the Plan:
Alternative Text for Table
The table describes six forecasts for the months January through June. The data is as follows:
- The forecast for January is 400 units.
- The forecast for February is 380 units.
- The forecast for March is 420 units.
- The forecast for April is 440 units.
- The forecast for May is 460 units.
- The forecast for June is 480 units.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
