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		((f)*(c))*1.0	((f)*(c))*2.0	((f)*(c))*3.0	((f)*(c))*4.0	((f)*(c))*5.0	((f)*(c))*6.0
Regular production
Overtime production
Subcontract production
Ending inventory	(((i)*(n))*(v))*0.0
Hired employees
Fired employees
Total employees	(((e)*(m))*(p))*0.0

Cost variables are as follows:

Cost Variables
Labor cost/hour	$(p)*(cos(t))
Overtime cost/ton	$((o)*(t))*(cos(t))
Subcontracting cost/ton	$(s)*(cos(t))
Holding cost/ton/month	$(((h)*(o))*(l))*(d)
Hiring cost/employee	$(h)*(cos(t))
Firing cost/employee	$(f)*(cos(t))

Here is someadditional relevant (capacity) information:

Capacity Information
Total labor hours/ton	((((l)*(a))*(b))*(o))*(r)
Regular production tons/employee/month	((((p)*(r))*(a))*(t))*2.718281828459045
Max regular production (tons/month)	(((p)*(c))*(a))*(p)
Max overtime production (tons/month)	((((o)*(t))*(c))*(a))*(p)
Max subcontractor production (tons/month)	(((s)*(c))*(a))*(p)

Given the above information (and don't overlook beginning number of employees and inventory levels in the first table), make 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 levelproduction plan? (Displayyour answer to the nearest whole number.) What is the total overtime productioncost for this production plan? (Displayyour answer to the nearest whole number.) What is the total subcontractcost for this production plan? (Displayyour answer to the nearest whole number.) What is the total holdingcost for this production plan? (Displayyour answer to the nearest whole number.) What is the total hirecost for this production plan? (Displayyour answer to the nearest whole number.) What is the total firecost for this production plan? (Displayyour answer to the nearest whole number.) What is the total cost(sum of all costs) for this production plan? (Displayyour answer to the nearest whole number.)

Need Solved via Excel with formulas. Thank you.