Please show all excel work when completing. It'd be appreciated if the cell locations matched my photo so I can easily reference. Thanks a lot

Develop a production plan and calculate the annual cost for a firm whose demand forecast is fall, 10,000; winter, 8,000; spring, 7,000; summer, 12,000. Inventory at the beginning of fall is 500 units. At the beginning of fall you currently have 30 workers, but you plan to hire temporary workers at the beginning of summer and lay them off at the end of summer. In addition, you have negotiated. with the union an option to use the regular workforce on overtime during winter or spring if overtime is necessary to prevent stockouts at the end of those quarters. Overtime is not available during the fall. Relevant costs are hiring, $100 for each temp; layoff $200 for each worker laid off; inventory holding, $5 per unit-quarter; backorder, $10 per unit; straight time, $5 per hour; overtime, $8 per hour. Assume that the productivity is 0.5 unit per worker hour, with eight hours per day and 60 days per season.

What is the total cost for this plan?

B C D E F 10 11 12 13 14 15 16 17 Relevant information includes: Backorder cost per unit Holding cost per unit Number of Workers Hiring cost per worker Layoff cost per worker Production time (hours) per unit Straight time labor cost per hour Overtime labor cost per hour Working time (hrs/day) Work days per season Beginning inventory $10.00 $5.00 30 $100.00 $200.00 2.0 $5.00 $8.00 8.00 60.00 500 18 19 20 21 22 23 24 25 26 27 Winter Spring Summer 28 29 30 31 32 33 34 Aggregate Production Planning Requirements Time Period Fall Forecast Beginning Inventory Production Required (Forecast - Beginning inventory) Production hours required (# units * Production Time per unit) Production hours available (# workers * # hours per day * # days per season) Overtime hours Temp workers (Production hrs required Production hours available)(Overtime cost * # days per season) rounded up Temp worker hours available Total hours available Actual Production (Production hrs available / Labor hrs required per unit) Ending Inventory (Beginning inventory + Actual production - Demand forecast) Workers hired Workers laid off Straight Time (Production hrs available x Straight time labor cost) Overtime Inventory cost Backorder cost Hiring cost Layoff cost Total costs 35 36 37 38 39 40 41 42 43 44 45 46 Total Cost