1 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($) 10 11 12 Probability 0.25 0.45 0.30 Labor Cost ($) 20 22 24 25 Probability 0.10 0.25 0.35 0.30 Transportation Cost ($) 3 5 Probability 0.75 0.25 (a) Compute profit per unit for the base-case, worst-case, and best-case scenarios. Base Case using most likely costs Profit = $ /unit Worst Case Profit = $ /unit Best Case Profit = $ /unit (b) Construct a simulation model to estimate the mean profit per unit. (Use at least 1,000 trials.) (c) Why is the simulation approach to risk analysis preferable to generating a variety of what-if scenarios? Simulation will provide ---Select--- ✓of the profit per unit values which can then be used to find ---Select--- ✓of an unacceptably low profit. (d) Management believes the project may not be sustainable if the profit per unit is less than $5. Use simulation to estimate the probability the profit per unit will be less than $5. (Round your answer to three decimal places.)

Linear Algebra: A Modern Introduction
4th Edition
ISBN:9781285463247
Author:David Poole
Publisher:David Poole
Chapter4: Eigenvalues And Eigenvectors
Section4.6: Applications And The Perron-frobenius Theorem
Problem 22EQ
icon
Related questions
Question
1
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($)
10
$
11
12
Probability
0.25
0.45
0.30
Labor
Cost ($)
20
22
24
25
Probability
0.10
0.25
0.35
0.30
Transportation
Cost ($)
3
5
(a) Compute profit per unit for the base-case, worst-case, and best-case scenarios.
Base Case using most likely costs
Profit = $
/unit
/unit
Worst Case
Profit = $
Profit = $
Best Case
/unit
Probability
0.75
0.25
(b) Construct a simulation model to estimate the mean profit per unit. (Use at least 1,000 trials.)
(c) Why is the simulation approach to risk analysis preferable to generating a variety of what-if scenarios?
Simulation will provide ---Select--- ✓of the profit per unit values which can then be used to find ---Select---
of an unacceptably low profit.
(d) Management believes the project may not be sustainable if the profit per unit is less than $5. Use simulation to estimate the probability the profit per unit will be less than $5.
(Round your answer to three decimal places.)
SHOW WORK FOR (b) and (d) ON EXCEL SPREADSHEET.
Transcribed Image Text:1 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($) 10 $ 11 12 Probability 0.25 0.45 0.30 Labor Cost ($) 20 22 24 25 Probability 0.10 0.25 0.35 0.30 Transportation Cost ($) 3 5 (a) Compute profit per unit for the base-case, worst-case, and best-case scenarios. Base Case using most likely costs Profit = $ /unit /unit Worst Case Profit = $ Profit = $ Best Case /unit Probability 0.75 0.25 (b) Construct a simulation model to estimate the mean profit per unit. (Use at least 1,000 trials.) (c) Why is the simulation approach to risk analysis preferable to generating a variety of what-if scenarios? Simulation will provide ---Select--- ✓of the profit per unit values which can then be used to find ---Select--- of an unacceptably low profit. (d) Management believes the project may not be sustainable if the profit per unit is less than $5. Use simulation to estimate the probability the profit per unit will be less than $5. (Round your answer to three decimal places.) SHOW WORK FOR (b) and (d) ON EXCEL SPREADSHEET.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 15 images

Blurred answer
Recommended textbooks for you
Linear Algebra: A Modern Introduction
Linear Algebra: A Modern Introduction
Algebra
ISBN:
9781285463247
Author:
David Poole
Publisher:
Cengage Learning
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt