Please solve in EXCEL and show formulas so I can learn from this!! I will give a thumbs up of this is done in excel as I know that you benefit from those.

PP.61 A small manufacturer of specialty welding equipment has developed a level production plan for the next four quarters, as seen below: Supply/Demand Info Pre-Q1 Q1 Q2 Q3 Q4 Forecast (demand) 3.240 4,320 4,860 4,860 Regular production 4,320 4,320 4.320 4,320 Subcontract production Ending inventory Hired employees Fired employees 10 Total employees 42 32 32 32 32 The table below shows additional relevant information: 135 510 $65 Capacity Information & Cost Variables Production rate (units/employee/quarter) Subcontractor capacity (units/quarter) Regular production cost/unit Holding cost/unit/quarter Hiring cost/employee Firing cost/employee Subcontract cost/unit $9 $820 $2,550 $126 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