Must be done through Excel. Please Attatch link

3. (2.5 Points) 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 Procurement Probability Labor Probability Transportation Probability follows: Cost (5) Cost {$1 10 0.25 20 11 0.45 22 12 0.30 24 25 0.10 0.25 0.35 0.30 Cost (5) 0.75 0.25 a) Construct a simulation model to estimate the mean prot per unit. b) Management believes that the project may not be sustainable if the prot per unit is less than $5. Use simulation to estimate the probability that the prot per unit will be less than $5