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. 83% Total sales (units) 2,700 78% 2,585 75% 72% 2,453 2,360 Average per Month (in days) 1 2 3 4 Move time per unit 0.6 0.3 0.4 0.4 Process time per unit 2.0 1.9 1.8 1.7 Wait time per order before start of production Queue time per unit 21.0 23.0 26.0 28.1 4.0 4.6 5.3 6.1 Inspection time per unit 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 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. Manufacturing Cycle Throughput Time Delivery Cycle Time Efficiency (MCE) Month 1 days days % Month 2 days days % Month 3 days days % Month 4 days days % Required 1 Required 2 Required 3 Evaluate the company's performance over the last four months. Note: 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 Required 1 Required 2 Required 3 3-a. (Month 5) 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. (Month 6) 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. Note: Round your answers to 1 decimal place. Throughput time Manufacturing cycle efficiency (MCE) Month 5 days % Month 6 days % Show less A