DataSpan, Incorporated, 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.

$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 $4$

$\backslash$table$[[,$Throughput Time,Delivery Cycle Time,$\backslash$table$[[$Manufacturing Cycle$],[$Efficiency $($MCE$)]],],[$Month $1,$days,,days,,$\%$