Please help answer (b) lower bound %.

(All answers were generated using 1,000 trials and native Excel functionality.) The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $45 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are estimated as follows: Procurement Cost ($) Labor Probability Cost ($) Probability Transportation Cost ($) Probability 0.25 0.10 0.75 0.45 0.25 0.25 22 24 0.30 0.35 0.30 (a) Construct a simulation model to estimate the average profit per unit. What is a 95% confidence interval around this average? Round your answers to two decimal places. Lower Bound: $ zg Upper Bound: $ 7.05 (b) Management believes that the project may not be sustainable if the profit per unit is less than $5. Use simulation to estimate the probability that the profit per unit will be less than $5. What is a 95% confidence interval around this proportion? Round your answers to one decimal of a percentage. Lower Bound: Upper Bound: 10 % (All answers were generated using 1,000 trials and native Excel functionality.) The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $45 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are estimated as follows: Procurement Cost ($) Labor Probability Cost ($) Probability Transportation Cost ($) Probability 0.25 0.10 0.75 0.45 0.25 0.25 22 24 0.30 0.35 0.30 (a) Construct a simulation model to estimate the average profit per unit. What is a 95% confidence interval around this average? Round your answers to two decimal places. Lower Bound: $ zg Upper Bound: $ 7.05 (b) Management believes that the project may not be sustainable if the profit per unit is less than $5. Use simulation to estimate the probability that the profit per unit will be less than $5. What is a 95% confidence interval around this proportion? Round your answers to one decimal of a percentage. Lower Bound: Upper Bound: 10 %