Question in Business Analytics

Lensmakers is an international company that produces eyeglasses. They make most of the prescription eyeglasses that they sell in their stores. They recently purchased new equipment that makes the production of their glasses much faster and are considering a new marketing campaign that promotes that they can make your glasses in 30 minutes or less. The process to produce eyeglasses requires 3 steps: Grinding, Edging/Tinting, and Framing. The distribution of time, in minutes, for each step is shown in the table below. Use this data to create a simulation model with 1,000 trials to answer the following questions. NOTE: You must submit your Excel spreadsheet for this problem to get credit for any part of your answer. Be sure to also clearly label your answers on the excel spreadsheet. Step Minutes Probability Grinding 9 0.02 10 0.03 11 0.06 12 0.12 13 0.18 14 0.35 15 0.15 16 0.07 17 0.02 Edging/Tinting 0.04 8 0.10 9 0.25 10 0.37 11 0.12 12 0.09 13 0.03 Framing 0.01 0.03 V auA 0.32 0.40 8 0.20 0.03 10 0.01 a. From your simulation, what is the average total time to produce a pair of glasses? b. From your simulation, what is the probability that it will take more than 30 minutes to produce a pair of glasses? c. From your simulation, what is the average time that it takes for the Grinding step in the process? d. From your simulation, what is the probability that it will take more than 35 minutes to produce a pair of glasses