Please help ASAP! I can't quick seem to get this right. Answers and formulas in Excel please.

Apr May 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 Jun Forecast (demand) 57,800 52,000 59,400 60,400 59,000 63,000 Regular production Overtime production Subcontract production Ending inventory 8,000 Hired employees Fired employees Total employees 200 Cost variables are as follows: Cost Variables Labor cost/hour $16 Overtime cost/unit $34 Subcontracting cost/unit $30 Holding cost/unit/month $15 Hiring cost/employee $2,500 Firing cost/employee $5,600 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/SSD Regular production units/employee/month Max regular production/month 56,800 Max overtime production/month 4,600 Max subcontractor production/month 5,200 200 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.) 21056000 What is the total overtime production cost for this production plan? (Display your answer to the nearest whole number.) 0 What is the total subcontract cost for this production plan? (Display your answer to the nearest whole number.) 330000 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.) 2230000 What is the total fire cost for this production plan? (Display your answer to the nearest whole number.) 0 What is the total cost (sum of all costs) for this production plan? (Display your answer to the nearest whole number.) 23616000 Apr May 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 Jun Forecast (demand) 57,800 52,000 59,400 60,400 59,000 63,000 Regular production Overtime production Subcontract production Ending inventory 8,000 Hired employees Fired employees Total employees 200 Cost variables are as follows: Cost Variables Labor cost/hour $16 Overtime cost/unit $34 Subcontracting cost/unit $30 Holding cost/unit/month $15 Hiring cost/employee $2,500 Firing cost/employee $5,600 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/SSD Regular production units/employee/month Max regular production/month 56,800 Max overtime production/month 4,600 Max subcontractor production/month 5,200 200 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.) 21056000 What is the total overtime production cost for this production plan? (Display your answer to the nearest whole number.) 0 What is the total subcontract cost for this production plan? (Display your answer to the nearest whole number.) 330000 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.) 2230000 What is the total fire cost for this production plan? (Display your answer to the nearest whole number.) 0 What is the total cost (sum of all costs) for this production plan? (Display your answer to the nearest whole number.) 23616000