Great - 600(18) – 6000 = 4800 Figure 6.6 Equivalent Decision Tree 0.45 1074 Fair 0.35 - 300(18) – 6000 = -600 Awful 0.20 Market product - 90(18) – 6000 =-4380 -6000 1074 Abandon product

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

Explain in some detail how the PrecisionTree calculations in Figure 6.11 for the Acme problem are exactly the same as those for the hand-drawn decision tree in Figure 6.6. In other words, explain exactly how PrecisionTree gets the monetary values in the colored cells in Figure 6.11.

If your answer is negative number, enter "minus" sign.

 

Market   EMV
Great   ( $18 ×  - $ ) = $
Fair   ( $18 ×  - $ ) = $
Awful   ( $18 ×  - $ ) = $
Total   0.45 ×  __ $ + 0.35 × ___$ + 0.20 × ___ $ = ___ $
Great
600(18) – 6000 = 4800
Figure 6.6
Equivalent Decision
0.45
Tree
1074
Fair
0.35
300(18) – 6000 = -600
Awful
0.20
Market product
90(18) – 6000 =-4380
-6000
1074
Abandon product
Transcribed Image Text:Great 600(18) – 6000 = 4800 Figure 6.6 Equivalent Decision 0.45 Tree 1074 Fair 0.35 300(18) – 6000 = -600 Awful 0.20 Market product 90(18) – 6000 =-4380 -6000 1074 Abandon product
Figure 6.11
Decision Tree from PrecisionTree
A
B
1
Acme single-stage new product decision
2
All monetary values (except the unit
margin in cell B5) are in $1000s, and all
sa les volumes are in 1000s of units.
3 Inputs
4 Fixed cost
5 Unit margin
$6,000
$18
6
7 Market
8 Great
Probability
Sales volume
Net revenue
600
$10,800
$5,400
0.45
9 Fair
10 Awful
0.35
300
0.20
90
$1,620
11
12
45.0%
45.0%
Great
13
$10,800
$4,800
14
TRUE
Sales volume
$1,074
Yes
15
-$6,000
16
35.0%
35.0%
Fair
17
$5,400
-$600
18
20.0%
Awful
19
$1,620
-$4,380
20
Continue with product?
New Product Decision
21
$1,074
22
FALSE
0.0%
No
23
$0
Transcribed Image Text:Figure 6.11 Decision Tree from PrecisionTree A B 1 Acme single-stage new product decision 2 All monetary values (except the unit margin in cell B5) are in $1000s, and all sa les volumes are in 1000s of units. 3 Inputs 4 Fixed cost 5 Unit margin $6,000 $18 6 7 Market 8 Great Probability Sales volume Net revenue 600 $10,800 $5,400 0.45 9 Fair 10 Awful 0.35 300 0.20 90 $1,620 11 12 45.0% 45.0% Great 13 $10,800 $4,800 14 TRUE Sales volume $1,074 Yes 15 -$6,000 16 35.0% 35.0% Fair 17 $5,400 -$600 18 20.0% Awful 19 $1,620 -$4,380 20 Continue with product? New Product Decision 21 $1,074 22 FALSE 0.0% No 23 $0
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Financial management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
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.