DataSpan, Inc., automated its plant at the start of the current year and installed a flexible manufacturing system. The company is also evaluating its suppliers and moving toward Lean Production. Many adjustment problems have been encountered, including problems relating to performance measurement. After much study, the company has decided to use the performance measures below, and it has gathered data relating to these measures for the first four months of operations.

Table Summary: Table lists performance data for five measures for four months. The control measures are listed in column 1. Columns 2-5 are for Months 1, 2, 3, and 4. The entries for the first three rows are all question marks in columns 2-5.
	Month
	1	2	3	4
Throughput time (days)	?	?	?	?
Delivery cycle time (days)	?	?	?	?
Manufacturing cycle efficiency (MCE)	?	?	?	?
Percentage of on-time deliveries	91%	86%	83%	79%
Total sales (units)	3,210	3,072	2,915	2,806

Management has asked for your help in computing throughput time, delivery cycle time, and MCE. The following average times have been logged over the last four months:

Table Summary: Table lists performance data for five measures for four months. The control measures are listed in column 1. Columns 2-5 are for the average per month (in days) for Months 1, 2, 3, and 4.
	Average per Month (in days)
	1	2	3	4
Move time per unit	0.4	0.3	0.4	0.4
Process time per unit	2.1	2.0	1.9	1.8
Wait time per order before start of production	16.0	17.5	19.0	20.5
Queue time per unit	4.3	5.0	5.8	6.7
Inspection time per unit	0.6	0.7	0.7	0.6

Required:

1. For each month, compute the following:
   1. The throughput time.
   2. The delivery cycle time.
   3. The manufacturing cycle efficiency (MCE).
2. Evaluate the companys performance over the last four months.
3. Refer to the move time, process time, and so forth, given above for month 4.
   1. Assume that in month 5 the move time, process times, and so forth, are the same as in month 4, except that through the use of Lean Production the company is able to completely eliminate the queue time during production. Compute the new throughput time and MCE.
   2. Assume in month 6 that the move time, process time, and so forth, are again the same as in month 4, except that the company is able to completely eliminate both the queue time during production and the inspection time. Compute the new throughput time and MCE.