DataSpan, Inc., 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. Throughout time (days) Delivery cycle tine days) Manufacturing cycle officiency (MCE) Percentage of on-time deliveries Total sales (units) 1 2 ? 2 768 3050 Month 2 3 2 7 2 2 2 2 728 694 2919 2770 2 ? 2 666 2666 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: Move time per unit Process time per unit Wait time per order before start of production Queue time per unit Inspection time per unit Average per Monthin days) 2 0.9 0.7 0.9 0.9 2.3 2.2 2.1 2.0 19.0 20.8 23.0 24.8 4.5 5.2 6.0 6.9 0.4 0.5 0.5 0.4 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-6. 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. Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 3 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. (Round your intermediate calculations and final answers to 1 decimal place.) Show less Throughput Time days Month 1 Month 2 Month 3 Month 4 days Delivery Cycle Time days days days days Manufacturing Cycle Efficiency (MCE) % % 96 days days % Kno Req 25 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. Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 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 (1.e., zero variance) The Throughput Timo monture displays The Delivery cycle time days mensure displays Manufacturing cycle officiency days measure displays trends trends trends Reg1 Req3 > 3-b. Refer to the move time, process time, and so forth. given for month 4. 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. Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Reg 3 3-a. (Month 5) Refer to the move time, process time, and so forth, given for month 4. Assume that in months 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. (Month 6) 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. (Round your intermediate calculations and final answers to 1 decimal place) Show less Throughout time Manufacturing cycle efficiency (MCE) Month 5 days % Month 6 days 36 Req2