(All answers were generated using 1,000 trials and native Excel functionality.)
ID: 3173959 • Letter: #
Question
(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:
blank
ProcurementCost ($)
Probability
Labor Cost ($)
Probability Transportation
Cost ($)
Probability 10 0.35 20 0.2 3 0.72 11 0.4 23 0.25 5 0.28 13 0.25 24 0.35 26 0.2
Explanation / Answer
answer a
answer a
Profit = Selling Price - Purchase Cost - Labor Cost - Transportation Cost
Base case = 45 - 10 - 20 - 3 => $ 12 / unit
worst case = 45 - 11 - 23 - 5 => $ 6 / unit
best case = 45 - 13 -20 - 3 => $ 9 / unit
answer b
answer c
Simulation approach to risk analysis preferable to generating a variety of what-if scenarios because a what- if Analysis involves generating values for the probabilistic inputs ( direct labour cost, parts cost, and first year demand and comtputing the resulting value for the profit. It is a trial and error approach to learning about th erange of possible outputs for a model. Trial values are choosen for the model input an dthe value of outputs i scomputed.
answer d
Simulation will provide a distribution of the profit per unit values. Calculating the percentage of simulation trials providing a profit less than $4 per unit would provide an estimate of the probability the profit per unit will be unacceptably low.
if purchase cost labour cost and transporattion cost will be 11, 13 or 24, 26 or 4 respectively tan in these cases profit will be less than 4
Purchase cost Interval Labour Cost Interval Transportation Cost Interval 10 0-24 20 0-9 3 0-74 11 25-69 23 10-34 5 75-100 13 70-100 24 35-69 26 70-100Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.