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              81%        77%        74%        71% Total sales (units)                                             3180       3044       2888       2778   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.8          0.5          0.6          0.6 Process time per unit                      3.5          3.3          3.2          3.0 Wait time per order before start of production   22.0        24.1        27.0        29.2 Queue time per unit                       4.2          4.7          5.3          6.0 Inspection time per unit                 0.6          0.7          0.7          0.6   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.   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. Req1 Throughput Time                             Delivery Cycle Time         Manufacturing Cycle Efficiency (MCE) Month 1____    days                                       ____days                                            ____% Month 2____    days                                       _____days                                          ____%  Month 3____    days                                       _____days                                          _____% Month 4____    days                                       ______days                                       _____%   Req 3 Month 5                                                               throughput time               _____days                          Manufacturing cycle efficiency_____% Month 6 throughput time               _____days                          Manufacturing cycle efficiency_____%

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              81%        77%        74%        71%

Total sales (units)                                             3180       3044       2888       2778

 

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.8          0.5          0.6          0.6

Process time per unit                      3.5          3.3          3.2          3.0

Wait time per order before start of production   22.0        24.1        27.0        29.2

Queue time per unit                       4.2          4.7          5.3          6.0

Inspection time per unit                 0.6          0.7          0.7          0.6

 

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.

 

  1. 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.

Req1

Throughput Time                             Delivery Cycle Time         Manufacturing Cycle Efficiency (MCE)

Month 1____    days                                       ____days                                            ____%

Month 2____    days                                       _____days                                          ____% 

Month 3____    days                                       _____days                                          _____%

Month 4____    days                                       ______days                                       _____%

 

Req 3

Month 5                                                              

throughput time               _____days                          Manufacturing cycle efficiency_____%

Month 6

throughput time               _____days                          Manufacturing cycle efficiency_____%

Expert Solution
steps

Step by step

Solved in 4 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.