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 wili be $45 per unit. Probability distribe for the purchase cost, the labor cost, and the transportation cost are estimated as follows. Procurement Cost ($) Labor Cost (8) Probability Transportation Cost ($) Probability Probability 10 0.25 20 0.10 0.75 11 0.40 22 0.20 0.25 12 0.35 24 0.40 25 0.30 (a) Construct a simulation model to estimate the average profit (in $) per unit and the variance of the profit per unit. (Use at least 1,000 trials. Round your answer to two decimal places.) average $0.00 variance What is a 95% confidence interval (in $) around this average? (Round your answers to two decimal places.) to $

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

2

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
Labor
Probability
Cost ($)
Probability Transportation Cost (4) Probability
Cost ($)
10
0.25
20
0.10
0.75
11
0.40
22
0.20
0.25
12
0.35
24
0.40
25
0.30
(a) Construct a simulation model to estimate the average profit (in $) per unit and the variance of the profit per unit. (Use at least 1,000 trials. Round your answer to two decimal places.)
average s 0.00
variance
What is a 95% confidence interval (in $) around this average? (Round your answers to two decimal places.)
(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 be less than $5. (use at
least 1,000 trials. Round your answer to three decimal places.)
What is a 95% confidence interval around this proportion? (Round your answers to three decimal places.)
to
Transcribed Image Text: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 Labor Probability Cost ($) Probability Transportation Cost (4) Probability Cost ($) 10 0.25 20 0.10 0.75 11 0.40 22 0.20 0.25 12 0.35 24 0.40 25 0.30 (a) Construct a simulation model to estimate the average profit (in $) per unit and the variance of the profit per unit. (Use at least 1,000 trials. Round your answer to two decimal places.) average s 0.00 variance What is a 95% confidence interval (in $) around this average? (Round your answers to two decimal places.) (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 be less than $5. (use at least 1,000 trials. Round your answer to three decimal places.) What is a 95% confidence interval around this proportion? (Round your answers to three decimal places.) to
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.