Requirement 1. Calculate (a) the average amount of time that an order for Z39 will wait in line before it is processed and (b) the average manufacturing cycle time per order for Z39. (Abbreviations used: Capacity = Annual machine capacity, Orders Z39 = Annual average number of orders of Z39, Mfg time Z39 = Manufacturing time per order of Z39, SP Z39 = Selling price per order of Z39, VC Z39 = Variable cost per order of Z39.) (a) Calculate the average amount of time that an order for Z39 will wait in line before it is processed. Begin by selecting the formula to calculate the wait time for Z39. = Wait time Now enter the amounts into the formula. (Enter the amounts in the same order as shown in the formula.) 2((x)x(x))2= hours of wait time (b) Calculate the average manufacturing cycle time per order for Z39. Select the formula and calculate the average manufacturing cycle time per order for Z39. cycletimeforZ39Averagemanufacturing Requirement 2. Shamrock is considering introducing a new product, Y28. The company expects it will receive 25 orders of Y28 in the coming year. Each order of Y28 will take 10 hours of machine time. Assuming the demand for Z39 will not be affected by the introduction of Y28, calculate (a) the average waiting time for an order received and (b) the average manufacturing cycle time per order for each product if Shamrock introduces Y28. (Abbreviations used: Capacity = Annual machine capacity, Orders Z39 = Annual average number of orders of Z39, Orders Y28 = Annual average number of orders of Y28, Mfg time Z39 = Manufacturing time per order of Z39, Mfg time Y28 = Manufacturing time per order of Y28, SP Z39 = Selling price per order of Z39, SP Y28 = Selling price per order of Y28, VC Z39 = Variable cost per order of Z39,VCY28= Variable cost per order of Y28.) (a) Calculate the average waiting time for an order received. Begin by selecting the formula to calculate the average waiting time for an order received. = Average wait time Enter the amounts into the formula now. (Enter the amounts in the same order as shown in the formula.) (b) Calculate the average manufacturing cycle time per order for each product if Shamrock introduces Y28. The average manufacturing cycle time per order for Z39 if Shamrock introduces Y28 is hours. The average manufacturing cycle time per order for Y28 is hours. The Shamrock Corporation uses an injection molding machine to make a plastic product, Z39, after receiving firm orders from its customers. Shamrock estimates that will receive 20 orders for Z39 during the coming year. Each order of Z39 will take 80 hours of machine time. The annual machine capacity is 2,000 hours. Requirements 1. Calculate (a) the average amount of time that an order for Z39 will wait in line before it is processed and (b) the average manufacturing cycle time per order for Z39. 2. Shamrock is considering introducing a new product, Y28. The company expects it will receive 25 orders of Y28 in the coming year. Each order of Y28 will take 10 hours of machine time. Assuming the demand for Z39 will not be affected by the introduction of Y28, calculate (a) the average waiting time for an order received and (b) the average manufacturing cycle time per order for each product if Shamrock introduces Y28