Please use table format provided.

1. (20 points) SummerFun, Inc., produces a variety of recreation and leisure products. The production manager has developed an aggregate forecast: Month Forecast April 28 May 38 June 34 | July 31 August Sept. | Oct. | Total 36 38 | 30 235 Holding cost $12 per unit per month Back-order cost $30 per unit Beginning inventory 4 Regular production cost $60 per unit Overtime production cost $90 per unit Subconstracting cost $120 per unit Regular capacity 30 units per month Overtime capacity 5 units per month Subcontracting capacity 10 units per month Develop an aggregate plan using each of the following guidelines and compute the total cost for each plan. Which plan has the lowest total cost? a. Use a level strategy. Use a combination of backlogs, subcontracting, and inventory to handle variations in demand. (Make sure that you don't have backlogs at the end of October.) a. Use a level strategy. Use a combination of backlogs, subcontracting, and inventory to handle variations in demand. (Overtime is also used) July Total 235 28 210 35 Period April May June August Sept. Oct. Forecast 38 34 | 31 | 36 | 38 | 30 Output Regular 30 30 30 30 30 30 30 Overtime 5 5 5 5 5 5 5 Subcontract 10 10 10 10 10 10 10 Output-Forecast Inventory Beginning Ending Average Backlog1111111 O 0 Cost Output Regular Overtime Subcontract Inventory Average Backlog Total $1,800.00 $450.00 $1,200.00 $1,800.00 $450.00 $1,200.00 $1,800.00 $450.00 $1,200.00 $1,800.00 $450.00 $1,200.00 $1,800.00 $450.00 $1,200.00 $1,800.00 $450.00 $1,200.00 $1,800.00 $450.00 $1,200.00 | $12,600.00 $3,150.00 $8,400.00 $0.00 $0.00 $0.00 $0.00