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 1 2 3 4 Throughput time (days) ? ? ? ? Delivery cycle time (days) ? ? ? ? Manufacturing cycle efficiency (MCE) ? ? ? ? Percentage of on-time deliveries 92% 87% 84% 81% Total sales (units) 2,060 1,972 1,871 1,800   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:     Average per Month (in days) 1 2 3 4 Move time per unit 0.7 0.4 0.5 0.5 Process time per unit 3.0 2.8 2.7 2.5 Wait time per order before start of production 23.0 25.2 28.0 30.3 Queue time per unit 4.2 4.7 5.3 6.0 Inspection time per unit 0.9 1.1 1.1 0.9 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.

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

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
1 2 3 4
Throughput time (days) ? ? ? ?
Delivery cycle time (days) ? ? ? ?
Manufacturing cycle efficiency (MCE) ? ? ? ?
Percentage of on-time deliveries 92% 87% 84% 81%
Total sales (units) 2,060 1,972 1,871 1,800

 

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:

 

  Average per Month (in days)
1 2 3 4
Move time per unit 0.7 0.4 0.5 0.5
Process time per unit 3.0 2.8 2.7 2.5
Wait time per order before start of production 23.0 25.2 28.0 30.3
Queue time per unit 4.2 4.7 5.3 6.0
Inspection time per unit 0.9 1.1 1.1 0.9


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.

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

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
1 2 3 4
Throughput time (days) ? ? ? ?
Delivery cycle time (days) ? ? ? ?
Manufacturing cycle efficiency (MCE) ? ? ? ?
Percentage of on-time deliveries 92% 87% 84% 81%
Total sales (units) 2,060 1,972 1,871 1,800

 

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:

 

  Average per Month (in days)
1 2 3 4
Move time per unit 0.7 0.4 0.5 0.5
Process time per unit 3.0 2.8 2.7 2.5
Wait time per order before start of production 23.0 25.2 28.0 30.3
Queue time per unit 4.2 4.7 5.3 6.0
Inspection time per unit 0.9 1.1 1.1 0.9


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.

sub parts 2, 3a and 3b

Solution
Bartleby Expert
SEE SOLUTION
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.