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 77% Total sales (units) 3,880 72% 3,715 69% 3,525 66% 3,391 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.7 3.5 3.3 3.1 Wait time per order before start of production Queue time per unit 25.0 27.4 31.0 33.5 4.5 5.2 6.0 6.9 Inspection time per unit 0.6 0.8 0.8 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. 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 >