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.

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$

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