Homework MGMT 370 Name: Chapter 11 1. A manager has put together an aggregate plan for the coming six months. He has obtained a forecast of expected demand for the planning horizon. The following data and information consists of the aggregate plan. Kylee Chesuy Jan Period Forecast 300 Feb 320 March April May June 320 340 320 320 Regular output each month is 300 units Overtime output each month is 20 units. Costs are as follows: Regular output $40 Overtime $50 Subcontract - $60 Average Balance Inventory S10 Beginning inventory for January is zero. Your job as management is to determine if the current work force (which includes both the regular and overtime output) will be able to satisfy the forecast demand (for the full 6 month period). Furthermore, your job is to determine the total cost of this aggregate plan (including all costs of production, inventory, and backorders). A) Will the current work force - using regular and overtime output - be able to satisfy the forecast demand? (Show your work) Hiw. Calculate the 6-month workforce capacity omasured in aggregated units) and compare in to the forecasted 6-month total demand measured in agregated units clude the overtime output in your calculation Page 1 of 7 Homework MGMT 370 Chapter 11 B) Determine the total cost of the plant, including production, subcontractor, inventory, and backorder costs Period Jan Feb March April May June Forecast 300 320 320 340 320 320 Total Output Regular Part Time Overtime Subcontract Output-Forecast Inventory Beginning Ending Average Backlog Monthly status Accumulated status Costs Output Regular Part Time Overtime Subcontract Inventory Back order Total Amount Write the plan's costs here: Cost Type Regular Production Cost: Part Time Production Cost: Overtime Production Cost Subcontractor Cost: Inventory Costs: Total cost of the plan: Page 2 of 7 Homework MGMT 370 Name: Chapter 11 1. A manager has put together an aggregate plan for the coming six months. He has obtained a forecast of expected demand for the planning horizon. The following data and information consists of the aggregate plan. Kylee Chesuy Jan Period Forecast 300 Feb 320 March April May June 320 340 320 320 Regular output each month is 300 units Overtime output each month is 20 units. Costs are as follows: Regular output $40 Overtime $50 Subcontract - $60 Average Balance Inventory S10 Beginning inventory for January is zero. Your job as management is to determine if the current work force (which includes both the regular and overtime output) will be able to satisfy the forecast demand (for the full 6 month period). Furthermore, your job is to determine the total cost of this aggregate plan (including all costs of production, inventory, and backorders). A) Will the current work force - using regular and overtime output - be able to satisfy the forecast demand? (Show your work) Hiw. Calculate the 6-month workforce capacity omasured in aggregated units) and compare in to the forecasted 6-month total demand measured in agregated units clude the overtime output in your calculation Page 1 of 7 Homework MGMT 370 Chapter 11 B) Determine the total cost of the plant, including production, subcontractor, inventory, and backorder costs Period Jan Feb March April May June Forecast 300 320 320 340 320 320 Total Output Regular Part Time Overtime Subcontract Output-Forecast Inventory Beginning Ending Average Backlog Monthly status Accumulated status Costs Output Regular Part Time Overtime Subcontract Inventory Back order Total Amount Write the plan's costs here: Cost Type Regular Production Cost: Part Time Production Cost: Overtime Production Cost Subcontractor Cost: Inventory Costs: Total cost of the plan: Page 2 of 7