Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
What is the total subcontract cost for this production plan? (Display your answer to the nearest whole number .) What is the total hire cost
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,000Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started