Please show me your formula's in excel.

Jun 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 Forecast (demand) 48,600 52,200 58,800 58,600 47,400 64,400 Regular production Overtime production Subcontract production Ending inventory 7,400 Hired employees Fired employees Total employees 200 Cost variables are as follows: $18 $34 Cost Variables Labor cost/hour Overtime cost/unit Subcontracting cost/unit Holding cost/unit/month Hiring cost/employee Firing cost/employee $29 S7 $3,300 $5,800 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/SSD 3 Regular production units/employee/month 200 Max regular production/month 54,400 Max overtime production/month 4,600 Max subcontractor production/month 6,000 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.) 16416000 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/SSD 3 Regular production units/employee/month 200 Max regular production/month 54,400 Max overtime production/month 4,600 Max subcontractor production/month 6,000 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.) 16416000 What is the total overtime production cost for this production plan? (Display your answer to the nearest whole number.) 136000 What is the total subcontract cost for this production plan? (Display your answer to the nearest whole number.) 295800 What is the total holding cost for this production plan? (Display your answer to the nearest whole number.) 0 What is the total hire cost for this production plan? (Display your answer to the nearest whole number.) 1488300 What is the total fire cost for this production plan? (Display your answer to the nearest whole number.) 2117000 What is the total cost (sum of all costs) for this production plan? (Display your answer to the nearest whole number.) 20453100