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 $91\%86\%83\%79\%$

Total sales $($units$)3,2103,0722,9152,806$

Average per Month $($in days$)$

$1234$

Move time per unit $0\mathrm{.}40\mathrm{.}30\mathrm{.}40\mathrm{.}4$

Process time per unit $2\mathrm{.}12\mathrm{.}01\mathrm{.}91\mathrm{.}8$

Wait time per order before start of production $16\mathrm{.}017\mathrm{.}519\mathrm{.}020\mathrm{.}5$

Queue time per unit $4\mathrm{.}35\mathrm{.}05\mathrm{.}86\mathrm{.}7$

Inspection time per unit $0\mathrm{.}60\mathrm{.}70\mathrm{.}70\mathrm{.}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.