What is the total subcontract 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.)

show how you solved in excel without solver

PP.52 A manufacturer of solid state drives (SSDs) has projected the next six months of demand to be as shown the table below: Beginning Jan Feb Mar Jun Apr 49,600 May 48,200 45,600 63,000 55,200 59,800 Supply/Demand Info Forecast (demand) Regular production Overtime production Subcontract production Ending inventory Hired employees Fired employees Total employees 7,600 160 Cost variables are as follows: $13 $30 Cost Variables Labor cost/hour Overtime cost/unit Subcontracting cost/unit Holding cost/unit/month Hiring cost/employee Firing cost/employee $26 $10 $2,500 $5,100 Here is some additional relevant (capacity) information: 2 200 Capacity Information Total labor hours/SSD Regular production units/employee/month Max regular production/month || Max overtime production/ month ||Max subcontractor production/ month 57,000 3,400 5,000 PP.52 A manufacturer of solid state drives (SSDs) has projected the next six months of demand to be as shown the table below: Beginning Jan Feb Mar Jun Apr 49,600 May 48,200 45,600 63,000 55,200 59,800 Supply/Demand Info Forecast (demand) Regular production Overtime production Subcontract production Ending inventory Hired employees Fired employees Total employees 7,600 160 Cost variables are as follows: $13 $30 Cost Variables Labor cost/hour Overtime cost/unit Subcontracting cost/unit Holding cost/unit/month Hiring cost/employee Firing cost/employee $26 $10 $2,500 $5,100 Here is some additional relevant (capacity) information: 2 200 Capacity Information Total labor hours/SSD Regular production units/employee/month Max regular production/month || Max overtime production/ month ||Max subcontractor production/ month 57,000 3,400 5,000