Dataspan, Incotporated, implemented Lean Production and would like to redesign its performance measures accordingly, it has provided the following data sets: Required: 1-a. Compute the throughput time for each month it Compute the delivery cycle time for each month. 1. Compute the manufacturing cycle efficiency (MCD) 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 elininate the gueue time, and all ofse remains the same as month 4 . Compute the new threughput time and MCE. 36. Pefer to the data for month 4. Assume in month 6 the compamy eliminates all queve time and inspection time, and all else remains the same as month A. Compute the new throuphput time and MCE. Complete this question by entering vour answers in the tabs below. 1-a: Compute the throughput time for each monsts. Inspection time per unit 0.50.60.60.5 Required: ta. Compute the throughput time for each month. 18. Compute the delivery cycle time for each month. 1.c. Compute the manufacturing cycle efficlency (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 remsins 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. 1-a. Compute the throughput bine for each month. 1-b. Compute the delivery cycle time for each month. 1-b. Compute the manufocturing cycle efficiency (MCE) for each month. Note: Round vour answers to 1 decimal place. Required: ta. 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-3. Refer to the data for month 4. Assume in month 5 the company uses Lean Production to completely eliminate the queve 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 queve 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. Evaluate the company's performance over the last four months: Note: Indicate the effect of each trend by selecting "Favorable" or "Untavorable" or "None" tor no effect (i.e., zero variance). Recuired: 1.a. Compute the throughput time for each month. 1.6. Compute the delivery cycle time for each month: 1-c. Compute the manufocturing cycle efficiency (MCE) for each month. 2. Evaluote the company's performance over the last four months. 2. Evaluote 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, arid all etse temains the same os 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 MCF Complete this question by entering your answers in the tabs below. 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 manth 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 a and all else remains the same as inonth 4 , Compute the new throughput time and MCE. Note: Pound your answers to 1 decimal place