Please include formulas used in Excel, thank you!

PP.63 Jupiter, a large candy company, is having great success with its "Swan" family of candy bars. Due to a number of factors they like to plan their production at least six months into the future. The table below contains their demand projections (in tons) for April through September: Supply/Demand Into Beginning Apr May Jun Jul Aug Sep Predicted Sales 48,100 53,700 52,700 57,200 58,600 54,400 Regular production Overtime production Subcontract production Ending inventory 6,700 Hired employees Fired employees Total employees 515 Cost variables are as follows: Cost Variables Labor cost/hour $17 Overtime cost/ton $39 Subcontracting cost/ton $31 Holding cost/ton/month $14 Hiring cost/employee $2,600 Firing cost/employee $4,700 4 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/ton Regular production tons/employee/month Max regular production (tons/month) 56,800 Max overtime production (tons/month) 3,900 Max subcontractor production (tons/month) 4,400 100 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