Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

(All answers generated on the Analytic Solver Platform using 10,000 trials and r

ID: 3235616 • Letter: #

Question

(All answers generated on the Analytic Solver Platform using 10,000 trials and random seed 1994.) 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: (a) Compute profit per unit for base-case, worst-case, and best-case scenarios. Profit per unit for base-case: Profit per unit for worst-case: Profit per unit for best-case: (b) Construct a simulation model to estimate the mean profit per unit. If required, round your answer to the nearest dollar. Mean profit per unit = (c) Why is the simulation approach to risk analysis preferable to generating a variety of what-if scenarios? The input in the box below will not be graded, but may be reviewed and considered by your instructor. (d) 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. Round your answer to the nearest percentage.

Explanation / Answer

Profit per unit will be less than $5 when total cost > $45 - $5 = $40.

The combinations of procurement, labor and transportation cost, which gives total cost > $40 are

(12, 25, 5) - Total cost = $42

(12, 24, 5) - Total cost = $41

(11, 25, 5) - Total cost = $41

Probability of procurement cost = $12, Labour cost = $25 and transpotation cost = $5 = 0.3*0.3*0.25 = 0.0225

Probability of procurement cost = $12, Labour cost = $24 and transpotation cost = $5 = 0.3*0.35*0.25 = 0.02625

Probability of procurement cost = $11, Labour cost = $25 and transpotation cost = $5 = 0.45*0.3*0.25 = 0.03375

Probability of total cost > $40 = 0.0225 + 0.02625 + 0.03375 = 0.0825 = 8.25 %