PLEASE SHOW WORK ( INCLUDE CELL REFERENCE IF POSSIBLE )

Non-Financial Performance Measures (Efficiency) JayCo Ltd. is in the process of automating string production and is developing a flexible manufacturing system. The company is finding it necessary to make many changes in operating procedures. Progress has been slow, particularly in trying to develop new performance measures for the factory. Jason, president of JayCo Ltd., has asked you to evaluate the performance of the string production. Month 2 3 1 4 53 55 57 52 15 13 12 10 Quality control measures: Number of defective packs of string Number of customer complaints Haterial control measures: Purchase order lead time (days) Scrap as a percentage of total cost Hachine performance measures: Machine downtime as a percentage of availabilit Use as a percentage of availability Setup time (hours) 15 1% 14 23 12 3% 12 42 8% 90% 2.1 9% 89% 2.1 9% 89% 2.3 10% 85% 2.3 Mont 1 2 3 4 5 6 Delivery perforaance measures: Throughput time Manufacturing cycle officiency (MCE) Delivery cycle time Percentage of on-time deliveries 92% 92% 95% 95% TUET TU ULTET progreTDEUTET, TETUL FIICESTE, KUUNTUR Fir 5 6 Wait time per order before start of production Inspection time per unit Process time per unit Queue time per unit Move time per unit 1 6.0 0.1 0.5 1.5 0.4 Month 2 3 6.2 6.5 0.1 0.1 0.6 0.8 1.8 2.0 0.3 0.2 4 6.6 0.1 1.0 2.1 0.2 To TO, CO PUCETTE a. Througbput tine b. Delivery cycle time c. MCE Assume last month is the same as in month, except the company is able to compAANAMILLA QUALAGOring production Compute throughput time and HCE for month 5 (abore). Assume that month 6 is the same as month 4, except that the company is able to completely eliminate both the queue time during production and inspection time using Lean Production. Compute throughput and HCE for month 6 Considering all of the information aborc, company seens to be improving in the follos (increase the size of the row if needed) Considering all of the information above, coupany seems to be deteriorating in the fol (increase the size of the row if needed) Non-Financial Performance Measures (Efficiency) JayCo Ltd. is in the process of automating string production and is developing a flexible manufacturing system. The company is finding it necessary to make many changes in operating procedures. Progress has been slow, particularly in trying to develop new performance measures for the factory. Jason, president of JayCo Ltd., has asked you to evaluate the performance of the string production. Month 2 3 1 4 53 55 57 52 15 13 12 10 Quality control measures: Number of defective packs of string Number of customer complaints Haterial control measures: Purchase order lead time (days) Scrap as a percentage of total cost Hachine performance measures: Machine downtime as a percentage of availabilit Use as a percentage of availability Setup time (hours) 15 1% 14 23 12 3% 12 42 8% 90% 2.1 9% 89% 2.1 9% 89% 2.3 10% 85% 2.3 Mont 1 2 3 4 5 6 Delivery perforaance measures: Throughput time Manufacturing cycle officiency (MCE) Delivery cycle time Percentage of on-time deliveries 92% 92% 95% 95% TUET TU ULTET progreTDEUTET, TETUL FIICESTE, KUUNTUR Fir 5 6 Wait time per order before start of production Inspection time per unit Process time per unit Queue time per unit Move time per unit 1 6.0 0.1 0.5 1.5 0.4 Month 2 3 6.2 6.5 0.1 0.1 0.6 0.8 1.8 2.0 0.3 0.2 4 6.6 0.1 1.0 2.1 0.2 To TO, CO PUCETTE a. Througbput tine b. Delivery cycle time c. MCE Assume last month is the same as in month, except the company is able to compAANAMILLA QUALAGOring production Compute throughput time and HCE for month 5 (abore). Assume that month 6 is the same as month 4, except that the company is able to completely eliminate both the queue time during production and inspection time using Lean Production. Compute throughput and HCE for month 6 Considering all of the information aborc, company seens to be improving in the follos (increase the size of the row if needed) Considering all of the information above, coupany seems to be deteriorating in the fol (increase the size of the row if needed)