DataSpan, Incorporated, automated its plant at the start of the current year and installed a flexible manufacturing system. The company is also evaluating its suppliers and moving toward Lean Production. Many adjustment problems have been encountered, including problems relating to performance measurement. After much study, the company has decided to use the performance measures below, and it has gathered data relating to these measures for the first four months of operations. Month Throughput time (days) Delivery cycle time (days) Manufacturing cycle efficiency (MCE) Percentage of on-time deliveries Total sales (units) 1 2 ? ? ? ? 91% 86% 3,460 3,312 ? ? Move time per unit. Process time per unit Wait time per order before start of production Queue time per unit Inspection time per unit 3 ? ? ? ? 82% 78% 3,143 3,025 4 Management has asked for your help in computing throughput time, delivery cycle time, and MCE. The following average times have been logged over the last four months: ? ? 23.0 4.6 0.5 Average per Month (in days) 2 1 4 0.7 2.8 Required: 1-a. Compute the throughput time for each month. 1-b. Compute the delivery cycle time for each month. 1-c. Compute the manufacturing cycle efficiency (MCE) for each month. 0.5 2.7 3 0.6 2.6 25.2 28.0 5.3 6.1 0.6 0.6 0.6 2.5 30.2 7.0 0.5
DataSpan, Incorporated, automated its plant at the start of the current year and installed a flexible manufacturing system. The company is also evaluating its suppliers and moving toward Lean Production. Many adjustment problems have been encountered, including problems relating to performance measurement. After much study, the company has decided to use the performance measures below, and it has gathered data relating to these measures for the first four months of operations. Month Throughput time (days) Delivery cycle time (days) Manufacturing cycle efficiency (MCE) Percentage of on-time deliveries Total sales (units) 1 2 ? ? ? ? 91% 86% 3,460 3,312 ? ? Move time per unit. Process time per unit Wait time per order before start of production Queue time per unit Inspection time per unit 3 ? ? ? ? 82% 78% 3,143 3,025 4 Management has asked for your help in computing throughput time, delivery cycle time, and MCE. The following average times have been logged over the last four months: ? ? 23.0 4.6 0.5 Average per Month (in days) 2 1 4 0.7 2.8 Required: 1-a. Compute the throughput time for each month. 1-b. Compute the delivery cycle time for each month. 1-c. Compute the manufacturing cycle efficiency (MCE) for each month. 0.5 2.7 3 0.6 2.6 25.2 28.0 5.3 6.1 0.6 0.6 0.6 2.5 30.2 7.0 0.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...
Related questions
Question
Transcribed Image Text:DataSpan, Incorporated, automated its plant at the start of the current year and installed a flexible manufacturing system. The
company is also evaluating its suppliers and moving toward Lean Production. Many adjustment problems have been encountered,
including problems relating to performance measurement. After much study, the company has decided to use the performance
measures below, and it has gathered data relating to these measures for the first four months of operations.
Throughput time (days)
Delivery cycle time (days)
Manufacturing cycle efficiency (MCE)
Percentage of on-time deliveries
Total sales (units)
1
2
Month
?
?
?
?
?
?
91%
86%
3,460 3,312
Move time per unit
Process time per unit
Wait time per order before start of production
Queue time per unit
Inspection time per unit
3
?
?
?
82%
3,143
4
Management has asked for your help in computing throughput time, delivery cycle time, and MCE. The following average times have
been logged over the last four months:
?
?
?
78%
3,025
23.0
4.6
0.5
Average per Month (in days)
1
2
4
0.7
2.8
Complete this question by entering your answers in the tabs below.
3
0.6
0.5
2.7
2.6
25.2 28.0
5.3
6.1
0.6
0.6
0.6
2.5
30.2
7.0
0.5
Required:
1-a. Compute the throughput time for each month.
1-b. Compute the delivery cycle time for each month.
1-c. Compute the manufacturing cycle efficiency (MCE) for each month.
2. Evaluate the company's performance over the last four months.
3-a. Refer to the move time, process time, and so forth, given for month 4. Assume that in month 5 the move time, process time, and so
forth, are the same as in month 4, except that through the use of Lean Production the company is able to completely eliminate the
queue time during production. Compute the new throughput time and MCE.
3-b. Refer to the move time, process time, and so forth, given for month 4. Assume in month 6 that the move time, process time, and so
forth, are again the same as in month 4, except that the company is able to completely eliminate both the queue time during
production and the inspection time. Compute the new throughput time and MCE.
Transcribed Image Text:plete
Required 1 Required 2
ntering yo answers in ne tabs bei
Required 3
Evaluate the company's performance over the last four months. (Indicate the effect of each trend by selecting "Favorable" or
"Unfavorable" or "None" for no effect (i.e., zero variance).
The Throughput Time measure displays
The Delivery cycle time measure displays
Manufacturing cycle efficiency measure displays
trends
trends
trends
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 5 steps
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.