Please show excel work

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 Info Beginning Apr May Jun Jul Aug Sep Predicted Sales 49,300 52.700 64.100 55,400 58,500 59,500 Regular production Overtime production ||Subcontract production Ending inventory 5,900 Hired employees Fired employees Total employees 508 Cost variables are as follows: $13 $35 Cost Variables Labor cost/hour Overtime cost/ton Subcontracting cost/ton Holding cost/ton/month |Hiring cost/employee Firing cost/employee $29 $14 $2,500 $5,000 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/ton 4 Regular production tons/employee/month 100 Max regular production (tons/month) 56,700 Max overtime production (tons/month) 3.800 Max subcontractor production (tons/month) 4.700 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