9.3 a) The decision alternatives are to price the product high ($50), medium ($40), or low
($30), or don’t market the product at all. The possible states of nature are the demand
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
A B C D E F G H I
Price Severe Moderate Weak
High $50 Prior Probability 0.2 0.7 0.1
Medium $40
Low $30 Prior Revenue
High Price Severe Moderate W eak Probability ($thousands)
Sales Sales High 0.20 0.25 0.30 0.245 2,500
(thousands) Sales Medium 0.25 0.30 0.35 0.295 1,500
High 50 Sales Low 0.55 0.45 0.35 0.46 1,000
Medium 30
Low 20 Medium Price Severe Moderate W eak
Sales High 0.25 0.30 0.40 0.3 2,000
Sales Medium 0.35 0.40 0.50 0.4 1,200
Sales Low 0.40 0.30 0.10 0.3 800
Low Price Severe Moderate W eak
Sales High 0.35 0.40 0.50 0.4 1,500
Sales Medium 0.40 0.50 0.45 0.475 900
Sales Low 0.25 0.10 0.05 0.125 600
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
H I
Prior Revenue
Probability ($thousands)
= SUMPRO DUCT ($E$2: $G $2,E6:G 6) = $B$2*B8
= SUMPRO DUCT ($E$2: $G $2,E7:G 7) = $B$2*B9
= SUMPRO DUCT ($E$2: $G $2,E8:G 8) = $B$2*B10
= SUMPRO DUCT ($E$2: $G $2,E11:G 11) = $B$3*B8
= SUMPRO DUCT ($E$2: $G $2,E12:G 12) = $B$3*B9
= SUMPRO DUCT ($E$2: $G $2,E13:G 13) = $B$3*B10
= SUMPRO DUCT ($E$2: $G $2,E16:G 16) = $B$4*B8
= SUMPRO DUCT ($E$2: $G $2,E17:G 17) = $B$4*B9
= SUMPRO DUCT ($E$2: $G $2,E18:G 18) = $B$4*B10
The payoff table can be generated based on the results in column I.