Please help me answer question #4 using the same format like the excel data provided below. Thank you very much

J m endation regarding whether to launch the product? 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 transporta- tion cost are estimated as follows: Procurement Labor Transportation Cost ($) Probability Cost ($) Probability Cost ($) 100 g 10 0.25 20 0.10 3 Song Indt 11 0 .45 22 0.25 ha ODD120. 30240 .35 omasti 250 .30 Probability 0.75 0.25 ona. Construct a simulation model to estimate the average profit per unit. What is a 95% told confidence interval around this average? 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 H o be less than $5. What is a 95% confidence interval around this proportion? 1 Brinkley Parameters 4 Selling Price 3 Procurement Cost 6 Labor Cost 7 Transportation Cost $15.00 $12.00 $22.00 $3.00 9 Procurement Cost 10 Lower End of Interval Upper End of Interval Cost 0.25 0.7 0.25 0.7 Probability $10.00 $11.00 $12.00 0.45 03 15 Labor Cost 16 Lower End of Interval Upper End of Interval Cost 0.1 0.35 0. Probability $20 $22 $24 $25 0.25 0.7 0.35 0.35 0.7 22 Transportation Cost 23 Lower End of Interval Upper End of Interval 0.75 0.75 Cost Probability Model 28 Profit Per Unit $8.00 Simulation Trial Procurement Cost Labor Cost Transportation Cost Profile Per Unit