EXCEL PLEASE 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	Apr	May	Jun	Jul	Aug	Sep
Predicted sales		4,475	2,500	4,375	3,625	2,650	4,575
Regular production
Overtime production
Subcontract production
Ending inventory	575
Hired employees
Fired employees
Total employees	110

Cost variables are as follows:

Cost Variables
Labor cost/hour	$20
Overtime cost/ton	$62
Subcontracting cost/ton	$53
Holding cost/ton/month	$11
Hiring cost/employee	$900
Firing cost/employee	$2,400

Here is some additional relevant (capacity) information:

Capacity Information
Total labor hours/ton	5
Regular production tons/employee/month	25
Max regular production (tons/month)	2,875
Max overtime production (tons/month)	1,775
Max subcontractor production (tons/month)	1,600

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.) What is the total overtime production cost for this production plan? (Display your answer to the nearest whole number.) What is the total subcontract cost for this production plan? (Display your answer to the nearest whole number.) What is the total holding cost for this production plan? (Display your answer to the nearest whole number.) What is the total hire cost for this production plan? (Display your answer to the nearest whole number.) What is the total fire cost for this production plan? (Display your answer to the nearest whole number.) What is the total cost (sum of all costs) for this production plan? (Display your answer to the nearest whole number.)