Can you please use xcel and show me how you calculated the info. Especially for the Hired and Fired employees. I am struggling with that part.

PP.52A manufacturer of solid state drives (SSDs) has projected the next six months of demand to be as shown the table below:
Supply/Demand Info	Beginning	Jan	Feb	Mar	Apr	May	Jun
Forecast (demand)		56,200	47,200	64,600	56,600	45,400	57,000
Regular production
Overtime production
Subcontract production
Ending inventory	7,000
Hired employees
Fired employees
Total employees	200
Cost variables are as follows:
Cost Variables
Labor cost/hour	$18
Overtime cost/unit	$35
Subcontracting cost/unit	$31
Holding cost/unit/month	$14
Hiring cost/employee	$3,500
Firing cost/employee	$5,100
Here is someadditional relevant (capacity) information:
Capacity Information
Total labor hours/SSD	4
Regular production units/employee/month	200
Max regular production/month	56,800
Max overtime production/month	3,600
Max subcontractor production/month	5,600
What is theoverall total costfor this production plan? (Displayyour answer to thenearestwhole number.)
What is the totalregular productioncostfor this production plan? (Displayyour answer to the nearestwhole number.)
What is thetotal holdingcostfor this production plan? (Displayyour answer to the nearestwhole number.)
What is thetotal hirecostfor this production plan? (Displayyour answer to the nearestwhole number
What is thetotal firecostfor this production plan? (Displayyour answer to the nearestwhole number.)

Answer rating: 100% (QA)

To calculate the overall total cost regular production cost holding cost hire cost and fire cost for ... View the full answer