Problem 13-2 Neal Industries manufactures blue jeans for the teen market. The S&OP team has agreed upon a demand forecast for the following year, as shown below. The company begins with 1,200,000 jeans in safety stock and desires to maintain this level consistently (and end with this level), assume that the overtime production wage rate is $30 per hour. Quarter 1 Demand 6,000,000 8,400.000 15,000,000 12,600,000 Current workforce Average output per worker Inventory holding cost Regular wage rate Regular production hours Hiring cost Firing/layoff cost Beginning inventory Quarter 1 2 3 4 Total Demand 6.000.000 8,400,000 15,000,000 š 12,600,000 42,000,000 300 workers 20,000 jeans per quarter 0.10 pair per quarter a. Develop a chase plan using a stable workforce of 300 workers. (Leave no cells blank-be certain to enter "0" wherever required.) Overtime Ending Regular Production Production Inventory 20 per hour 500 hours per quarter 340 per worker 250 per worker S S $1,200,000 b. Compute the cost of a chase plan using a stable workforce of 300 workers. Workers Required Hire Fire layoff
Problem 13-2 Neal Industries manufactures blue jeans for the teen market. The S&OP team has agreed upon a demand forecast for the following year, as shown below. The company begins with 1,200,000 jeans in safety stock and desires to maintain this level consistently (and end with this level), assume that the overtime production wage rate is $30 per hour. Quarter 1 Demand 6,000,000 8,400.000 15,000,000 12,600,000 Current workforce Average output per worker Inventory holding cost Regular wage rate Regular production hours Hiring cost Firing/layoff cost Beginning inventory Quarter 1 2 3 4 Total Demand 6.000.000 8,400,000 15,000,000 š 12,600,000 42,000,000 300 workers 20,000 jeans per quarter 0.10 pair per quarter a. Develop a chase plan using a stable workforce of 300 workers. (Leave no cells blank-be certain to enter "0" wherever required.) Overtime Ending Regular Production Production Inventory 20 per hour 500 hours per quarter 340 per worker 250 per worker S S $1,200,000 b. Compute the cost of a chase plan using a stable workforce of 300 workers. Workers Required Hire Fire layoff
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
Note:-
- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.
- Answer completely.
- You will get up vote for sure.

Transcribed Image Text:Problem 13-2
Neal Industries manufactures blue jeans for the teen market. The S&OP team has agreed upon a demand forecast for the following year, as shown below. The company begins with 1,200,000 jeans in safety stock and desires to maintain this
level consistently (and end with this level), assume that the overtime production wage rate is $30 per hour.
Quarter
1
2
3
4
Current workforce
Average output per worker
Inventory holding cost
Regular wage rate
Regular production hours
Hiring cost
Firing/layoff cost
Beginning inventory
Quarter
1
2
Demand
6,000,000
8,400,000
15,000,000
12,600,000
3
4
Total
Total cost
S
S
Demand
6.000.000
8,400,000
15,000,000
12,600,000
42,000,000
$
$
a. Develop a chase plan using a stable workforce of 300 workers. (Leave no cells blank - be certain to enter "0" wherever required.)
Regular Overtime
Production Production
300 workers
20,000 jeans per quarter
0.10 pair per quarter
20 per hour
500 hours per quarter
340 per worker
250 per worker
$1,200,000
Workers
Ending
Inventory Required
b. Compute the cost of a chase plan using a stable workforce of 300 workers.
Hire
Fire layoff
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 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.