Would greatly appreciate help solving this. In over my head this semester.

DataSpan, Inc., automated its plant at the start of the current yearand installed a exible 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 perfon'nanoe measures below, and it has gathered data relating to these measures for the rst four months of operations. Month 1 2 3 4 Throughput time (days) 'P' 'P' ? ? Delivery cycle time (days) 'P 'P 7 7 Manufacturing cycle aciency (MOE) 'l' 'l' ? ? Percentage of on-time deliveries 79% 80% 85% 92% Total sales (units) 10,600 10,560 10,550 10,420 Management has asked for your help in computing throughput time, delivery cycle time, and NICE. The following average times have been logged over the last four months: Ava Month in 1 2 3 4 Move lime per unit 0.4 0.5 0.3 0.5 Process time per unit 0.4 0.3 0.5 0.5 Wait time per order before start of production 9.4 8.0 5.0 5.0 Queue time per unit 3.5 3.6 2.2 1.2 Inspection time per unit 0.? 0.4 0.4 0.8 Required: 1-a. Compute the throughput time for each month. (Round your answers to 1 decimal place.) 1-o. Compute the manufacturing cycle efciency (NICE) for each month. [Round your answers to 1 decimal place.] 1-c. Compute the delivery cycle time for each month. [Round your answers to 1 decimal place.) 3-a. Referto the move time, process time, and so forth, given for month 4. Assume that in month 5 the move time. process time, 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. (Round your answers to 1 decimal place.) Throughput time Manufacturing cyde adensy (MCE) 3-D. Referto the move time, process time, and so forth, given for month 4. Assume in rmnth 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. (Round your answers to 1 decimal place.) Throughput time Manufactunng cycle eciency (MOE) References eBook 8. Resources Worksheet Di'mlty: 1 Easy Learning Objective: 12-03 Compute delivery cycle time. throughput time. and manufacturing cycle efciency (MCE). Ask your instructor a