PP.52 A manufacturer of solid state drives (SSDs) has projected the next six months of demand to be as shown the table below: Supply/Demand Info Mar Apr Jun Feb 45,000 49,000 51,200 62,600 49,000 Forecast (demand) Regular production Overtime production Subcontract production Ending inventory Hired employees Fired employees Total employees Cost variables are as follows: Cost Variables Labor cost/hour Overtime cost/unit Subcontracting cost/unit Holding cost/unit/month Hiring cost/employee Firing cost/employee Beginning Jan 7,200 160 $19 $34 $31 $11 $3,700 $5,800 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/SSD Regular production units/employee/month Max regular production/month Max overtime production/month Max subcontractor production/month 3 200 56,600 3,000 4,200 May 45,600
PP.52 A manufacturer of solid state drives (SSDs) has projected the next six months of demand to be as shown the table below: Supply/Demand Info Mar Apr Jun Feb 45,000 49,000 51,200 62,600 49,000 Forecast (demand) Regular production Overtime production Subcontract production Ending inventory Hired employees Fired employees Total employees Cost variables are as follows: Cost Variables Labor cost/hour Overtime cost/unit Subcontracting cost/unit Holding cost/unit/month Hiring cost/employee Firing cost/employee Beginning Jan 7,200 160 $19 $34 $31 $11 $3,700 $5,800 Here is some additional relevant (capacity) information: Capacity Information Total labor hours/SSD Regular production units/employee/month Max regular production/month Max overtime production/month Max subcontractor production/month 3 200 56,600 3,000 4,200 May 45,600
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question

Transcribed Image Text:PP.52 A manufacturer of solid state drives (SSDs) has projected the next six months of demand to be as shown the table below:
Supply/Demand Info
Feb
Mar
Jun
49,000
51,200
49,000
Forecast (demand)
Regular production
Overtime production
Subcontract production
Ending inventory
Hired employees
Fired employees
Total employees
Cost variables are as follows:
Cost Variables
Labor cost/hour
Overtime cost/unit
Subcontracting cost/unit
Holding cost/unit/month
Hiring cost/employee
Firing cost/employee
Beginning Jan
45,000
7,200
160
$19
$34
$31
$11
$3,700
$5,800
Here is some additional relevant (capacity) information:
Capacity Information
Total labor hours/SSD
Regular production units/employee/month
Max regular production/month
Max overtime production/month
Max subcontractor production/month
3
200
56,600
3,000
4,200
Apr May
62,600
45,600

Transcribed Image Text:Assuming the company uses regular production first, then ONLY overtime and/or subcontract production, answer the following questions:
What is the regular production cost (over the six months from January through June) for a CHASE production plan? (Display your answer to the nearest
whole number.)
Number
What is the total overtime production cost for this production plan? (Display your answer to the nearest whole number.)
Number
What is the total subcontract cost for this production plan? (Display your answer to the nearest whole number.)
Number
What is the total holding cost for this production plan? (Display your answer to the nearest whole number.)
Number
What is the total hire cost for this production plan? (Display your answer to the nearest whole number.)
Number
What is the total fire cost for this production plan? (Display your answer to the nearest whole number.)
Number
What is the total cost (sum of all costs) for this production plan? (Display your answer to the nearest whole number.)
Number
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,

Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education


Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning

Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.