The production process shown below consists of five stages. The numbers in parentheses are the times in minutes to complete one unit before it moves on to the next stage. The demand rate is 38 units per hour. Stage A: Stage B: Stage C: Stage D: Stage E: 4 workers 2 workers a. How many workers are needed at each stage if management wants a utilization of at least 90 percent? Round your answers up to the nearest whole number. 4 workers 4 workers Stage A (5) 4 workers Stage B (2) Stage C (5) Stage D (5) Stage E (5)

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...
icon
Related questions
Question

need to verify part a is correct and need assistance with part b and c

The production process shown consists of five stages. The numbers in parentheses indicate the time in minutes to complete one unit before it advances to the next stage. The demand rate is 38 units per hour.

**Process Diagram Description:**

- **Stage A**: Takes 5 minutes per unit and leads into Stage B.
- **Stage B**: Takes 2 minutes per unit and has two outputs going to Stage C and Stage D.
- **Stage C**: Takes 5 minutes per unit and flows into Stage E.
- **Stage D**: Takes 5 minutes per unit and also flows into Stage E.
- **Stage E**: Takes 5 minutes per unit, concluding the process.

**Question:**

a. How many workers are needed at each stage if management wants a utilization of at least 90%? Round your answers up to the nearest whole number.

- **Stage A**: 4 workers
- **Stage B**: 2 workers
- **Stage C**: 4 workers
- **Stage D**: 4 workers
- **Stage E**: 4 workers
Transcribed Image Text:The production process shown consists of five stages. The numbers in parentheses indicate the time in minutes to complete one unit before it advances to the next stage. The demand rate is 38 units per hour. **Process Diagram Description:** - **Stage A**: Takes 5 minutes per unit and leads into Stage B. - **Stage B**: Takes 2 minutes per unit and has two outputs going to Stage C and Stage D. - **Stage C**: Takes 5 minutes per unit and flows into Stage E. - **Stage D**: Takes 5 minutes per unit and also flows into Stage E. - **Stage E**: Takes 5 minutes per unit, concluding the process. **Question:** a. How many workers are needed at each stage if management wants a utilization of at least 90%? Round your answers up to the nearest whole number. - **Stage A**: 4 workers - **Stage B**: 2 workers - **Stage C**: 4 workers - **Stage D**: 4 workers - **Stage E**: 4 workers
### Production Process Analysis

**b. Worker Distribution by Stage:**

The table below shows the number of workers assigned to each stage of production:

| Stage | Number of Workers |
|-------|-------------------|
| A     | 5                 |
| B     | 3                 |
| C     | 5                 |
| D     | 5                 |
| E     | 3                 |

**Output Rate Calculation:**

Determine the output rate at each stage. Please round your answers to the nearest whole number.

- **Stage A:**  _____ units/hour
- **Stage B:**  _____ units/hour
- **Stage C:**  _____ units/hour
- **Stage D:**  _____ units/hour
- **Stage E:**  _____ units/hour

**c. Identifying the Bottleneck:**

Determine the bottleneck in the process.

- **The bottleneck is:**  [Select from options]
Transcribed Image Text:### Production Process Analysis **b. Worker Distribution by Stage:** The table below shows the number of workers assigned to each stage of production: | Stage | Number of Workers | |-------|-------------------| | A | 5 | | B | 3 | | C | 5 | | D | 5 | | E | 3 | **Output Rate Calculation:** Determine the output rate at each stage. Please round your answers to the nearest whole number. - **Stage A:** _____ units/hour - **Stage B:** _____ units/hour - **Stage C:** _____ units/hour - **Stage D:** _____ units/hour - **Stage E:** _____ units/hour **c. Identifying the Bottleneck:** Determine the bottleneck in the process. - **The bottleneck is:** [Select from options]
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.