5 pts D Question 1 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 consists 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 380 400 420 440 480 460 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. Subcontracting output will be 20 units in May and 40 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 o 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 "S0" 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: 1 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 380 units. The forecast for February is 400 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