Please solve in EXCEL and show formulas as well so I can learn instead of just get the answer! Thank you in advance I will be sure to give a thumbs up if it's done in excel.

PP.71 A small manufacturer of specialty welding equipment has developed a combination production plan for the next four quarters, as seen below: Supply/Demand Info Pre-Q1 Q1 Q2 Q3 Q4 Forecast (demand) 5,145 5,670 6.090 6,090 Regular production 5,145 5,775 5,775 5.775 Subcontract production 210 105 210 Ending inventory 315 105 Hired employees 1 6 Fired employees Total employees 48 49 55 55 55 The table below shows additional relevant information: 105 450 $85 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 $14 $720 $2,300 $103 What is the overall total 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