DataSpan, Incorporated, Implemented Lean Production and would like to redesign its performance measures accordingly. It has provided the following data sets: Month 1 2 3 4 Percentage of on-time deliveries 91% Total sales (units) 3,460 86% 3,312 82% 78% 3,143 3,025 Average per Month (in days) 1 2 3 4 Move time per unit Process time per unit Wait time per order before start of production Queue time per unit Inspection time per unit Required: 1-a. Compute the throughput time for each month. 0.7 0.5 0.6 0.6 2.8 2.7 2.6 2.5 23.0 25.2 28.0 30.2 4.6 5.3 6.1 7.0 0.5 0.6 0.6 0.5 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 data for month 4. Assume in month 5 the company uses Lean Production to completely eliminate the queue time, and all else remains the same as month 4. Compute the new throughput time and MCE. 3-b. Refer to the data for month 4. Assume in month 6 the company eliminates all queue time and Inspection time, and all else remains the same as month 4. Compute the new throughput time and MCE. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 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. Note: Round your answers to 1 decimal place. Show less 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 % < Required 1 Required 2 >