Need help with this problem. Please show excel formulas and explanation.

Thanks beforehand!

PP.53 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 May Jun Jul Aug Sep Predicted sales 4,775 3,925 4,750 2,575 4,975 2,875 Regular production Overtime production Subcontract production Ending inventory 675 Hired employees Fired employees Total employees 60 Cost variables are as follows: Cost Variables Labor cost/hour $16 Overtime cost/ton $62 Subcontracting cost/ton S51 Holding cost/ton/month $14 Hiring cost/employee $1,000 Firing cost/employee $2,500 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/ton 4 Regular production tons/employee/month 25 Max regular production (tons/month) 2.775 Max overtime production (tons/month) 1,725 Max subcontractor production (tons/month) 2,100 Given the above information (and don't overlook the beginning number of employees and inventory levels in the first table), create a CHASE production plan (zero inventory left over each month), making sure to use as much regular production as possible before using overtime or subcontract production. What is the total REGULAR production cost over the six months from April through September) for a chase production plan? (Display your answer to the nearest whole number.) 499800 What is the total overtime production cost for this production plan? (Display your answer to the nearest whole number.) 0 What is the total subcontract cost for this production plan? (Display your answer to the nearest whole number.) 0 What is the total holding cost for this production plan? (Display your answer to the nearest whole number.) 0 What is the total hire cost for this production plan? (Display your answer to the nearest whole number.) 520958 What is the total fire cost for this production plan? (Display your answer to the nearest whole number.) 112500 What is the total cost (sum of all costs) for this production plan? (Display your answer to the nearest whole number.) 1589050