here is the question and the template and cost sheet needed. please include 2 copies of the template. 1. for the first go around and the second cooy to show any changes made so that i can follow along or show all the changes made on the template and make it clear please and thank you in advance.

1. Use the given information and the provided table below to answer the following questions Period Forecast 1 220 2 180 3 345 4 400 5 205 Regular time: $30 per unit (230 units per period maximum) Overtime: $45 per unit (40 units per period maximum) Subcontracting Not available Temp Workers $50 per unit (40 units per month maximum) Beginning Inv. 45 Holding cost: $2 per unit per period Backorder cost: $5 per unit per period Develop an aggregate plan that results in the minimum total cost. Note: There is no hiring/firing in this problem No on hand inventory or backorders at the end of period 5 1 2 3 4 5 Total Forecast 220 180 3415 HOU 205 Output Regular 230 230 236 230 230 Overtime Temporary Output-Forecast Inventory Beginning Ending Average Backorder 1+3 T+2 T! Today T-2 T-1 32 40200 Regular 36 45 50 SS Overtime 5 119 50 59 60 52 65 51 Temp 5