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 Given the above information (and don't overlook beginning number of employees and inventory levels in the first table), create a LEVEL production plan with only the use of regular production and no inventory left over at the end of the six-month period. What is the regular production cost (over the six months from April through September) for a level production plan? (Display your answer to the nearest whole number.) Number What is the total overtime production 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 What is the total cost (sum of all costs) for this production plan? (Display your answer to the nearest whole number.) Number