Please help! I am very stuck on this please solve in EXCEL and show formulas used. I will be sure to give you a thumbs up if you do this since I know it helps you guys out.

Data Given

What is needed from data

PP.52 A manufacturer of solid state drives (SSDs) has projected the next six months of demand to be as shown the table below: Supply/Demand Info Beginning Jan Feb Mar Apr May Jun Forecast (demand) 51,600 48,400 48,600 59,800 60,200 62,600 Regular production Overtime production Subcontract production Ending inventory 6,600 Hired employees Fired employees Total employees 180 Cost variables are as follows: Cost Variables Labor cost/hour $18 Overtime cost/unit $36 Subcontracting cost/unit $31 Holding cost/unit/month $7 Hiring cost/employee $3,100 Firing cost/employee $4,700 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/SSD 3 Regular production units/employee/month 200 Max regular production/month 57,200 Max overtime production/month 3,800 Max subcontractor production/month 4,400 Assuming the company ONLY uses overtime and/or subcontract production if regular production capacity is not sufficient, answer the following questions: What is the regular production cost (over the six months from January through June) for a CHASE production plan? (Display your answer to the nearest whole number.) Number What is the total overtime production cost for this production plan? (Display your answer to the nearest whole number.) Number What is the total subcontract cost for this production plan? (Display your answer to the nearest whole number.) Number What is the total holding cost for this production plan? (Display your answer to the nearest whole number.) Number What is the total hire cost for this production plan? (Display your answer to the nearest whole number.) Number What is the total fire cost for this production plan? (Display your answer to the nearest whole number.) Number What is the total cost (sum of all costs) for this production plan? (Display your answer to the nearest whole number.) Number