$\backslash$table$[[,$Throughput Time,Delivery Cycle Time,$\backslash$table$[[$Manufacturing Cycle$],[$Efficiency $($MCE$)]]],[$Month $1,,$days,,days,,$\%],[$Month $2,,$days,,days,,$\%],[$Month $3,,$days,,days,,$\%],[$Month $4,,$days,,days,,$\%]]$DataSpan$,$ Incorporated, implemented Lean Production and would like to redesign its performance measures accordingly. It has provided the following data sets:

Month

$1234$

Percentage of on$-$time deliveries $82\%77\%74\%71\%$

Total sales $($units$)3,8303,6673,4793,347$

Average per Month $($in days$)$

$1234$

Move time per unit $0\mathrm{.}80\mathrm{.}50\mathrm{.}60\mathrm{.}6$

Process time per unit $2\mathrm{.}32\mathrm{.}22\mathrm{.}12\mathrm{.}0$

Wait time per order before start of production $24\mathrm{.}026\mathrm{.}329\mathrm{.}031\mathrm{.}4$

Queue time per unit $4\mathrm{.}45\mathrm{.}05\mathrm{.}76\mathrm{.}5$

Inspection time per unit $0\mathrm{.}91\mathrm{.}11\mathrm{.}10\mathrm{.}9$

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.

Below is the set up for requirement $1.$