Please show how you do it on an excel workbook.

PP.52 A manufacturer of solid state drives (SSDs) has projected the next six months of demand to be as shown the table below: Beginning Jan Feb Mar Apr May Jun 46,600 55,600 58,600 58,200 45,200 45,200 Supply/Demand Info Forecast (demand) Regular production Overtime production Subcontract production Ending inventory | Hired employees Fired employees Total employees 4,200 200 Cost variables are as follows: Cost Variables S19 Labor cost/hour Overtime cost/unit $30 $27 $14 Subcontracting cost/unit Holding cost/unit/month Hiring cost/employee Firing cost/employee $3,000 $4,600 Here is some additional relevant (capacity) information: 3 200 Capacity Information Total labor hours/SSD Regular production units/employee/month Max regular production/month Max overtime production/month Max subcontractor production/month 53,000 3,800 5,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.) 5498600 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