Pp61. Please help me using excel and show excel formulas to solve answer

PP.61 A small manufacturer of specialty welding equipment has developed a level production plan for the next four quarters. Note, however, that this plan is incomplete and requires that you first compute the ending inventory for each quarter (and assume there is no Pre-Q1 ending inventory) before you answer the questions below. Supply/Demand Info Pre-Q1 Q1 02 Forecast (demand) 3,200 4,400 2,400 5,200 Regular production 3,800 3,800 3,800 3,800 Subcontract production Ending inventory Hired employees 6 Fired employees Total employees 32 38 38 38 38 The table below shows additional relevant information: Capacity Information & Cost Variables Production rate (units/employee/quarter) 100 Subcontractor capacity (units/quarter) 530 Regular production cost/unit $66 Holding cost/unit/ quarter $15 Hiring cost/employee $800 ining cost/employee $2,650 Subcontract cost/unit $123 What is the overall total cost for this production plan? (Display your answer to the nearest whole number.) Number What is the total regular production 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