I have been working on this problems for hours. Please show formulas on excel.

What is the regular production cost (over the six months from January through June) for this optimized production plan? (Display your answer to the nearest whole number.)

What is the total overtime production cost for this production plan? (Display your answer to the nearestwhole number.)

What is the total subcontract cost for this production plan? (Display your answer to the nearest whole number.)

What is the total holding cost for this production plan? (Display your answer to the nearest whole number.)

What is the total hire cost for this production plan? (Display your answer to the nearest whole number.)

What is the total fire cost for this production plan? (Display your answer to the nearest whole number.)

What is the total cost (sum of all costs) for this production plan? (Display your answer to the nearestwhole number.)

PP.72 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 Forecast (demand) Regular production Overtime production Subcontract production Ending inventory Hired employees Fired employees Total employees Cost variables as as follows: Jan 48,000 52,000 60,00054,00058,00064,000 Feb Mar Apr May Jun 6,000 200 Cost Variables Labor cost/hour Overtime cost/unit Subcontracting cost/unit $29 Holding cost/unit/month $8 Hiring cost/employee $2,500 Firing cost/employee $4,200 Here is some additional relevant (capacity) information $14 $32 Capacity Information Total labor hours/SSD Regular production units/employee/month Max regular production/month Max overtime production/month Max subcontractor production/month 2 200 56,000 4,000 5,000