If you could please show how you solved the blank bolded problems in Excel that would be most helpful using the Chase production model

Supply/Demand Info	Beginning	Jan	Feb	Mar	Apr	May	Jun	TOTAL
Forecast (demand)		58,000	59,800	56,400	49,800	61,400	61,800	347,200
Actual Production
Regular production		34000	34000	34000	34000	34000	34000	204000
Overtime production								0
Subcontract production								0
Ending inventory	5,400	-18,600	-44,400	-66,800	-82,600	-110,000	-137,800	-460,200
Hired employees								0
Fired employees								0
Total employees	170	170	170	170	170	170	170	170
Cost Variables								Regular Production Cost
Labor cost/hour	$16			Capacity Information				Total Overtime
Labor cost per unit	$64			Total labor hours/SSD	4			Total Subcontract
Overtime cost/unit	$38			Regular production units/employee/month	200			Total Holding Cost
Subcontracting cost/unit	$35			Max regular production/month	56,200			Hire Cost
Holding cost/unit/month	$8			Max overtime production/month	5,000			Fire Cost
Hiring cost/employee	$2,900			Max subcontractor production/month	5,200			TOTAL COST
Firing cost/employee	$5,400