Assignment Lab 5

profilesaikumar.battula
Lab_5.xlsx
Home>Computer Science homework help>Assignment Lab 5

Simple Decision Problem.xlsx

Decision 1 Decision 2 Decision 3
Payoff/Cost Probability Payoff/Cost Probability Payoff/Cost Probability
$50,000 0.1 $5,000 0.6 $3,000 1
$10,000 0.2 -$1,000 0.4
-$5,000 0.7
EMV EMV EMV

NewProductDecision-Singlestage

Acme single-stage new product decision
Decision 1: Continue development and market the new product
Fixed cost $6,000
Unit margin $18
Market Probability Sales volume Net revenue
Great 0.45 600 $10,800
Fair 0.35 300 $5,400
Awful 0.20 90 $1,620
EMV
Decision 2: Stop development and abandon product
No payoffs, no costs, no uncertainty
EMV

All monetary values (except the unit margin in cell B5) are in $1000s, and all sales volumes are in 1000s of units.

TopicInfo

test

test

GlobalInfo

Countries Priority Smiley Arrows Stop Go Progress Emphasis
US Priority 1 Happy Left Go Not Done Question
Canada Priority 2 Sad Right Stop Quarter Done Exclamation
Mexico Priority 3 Angry Up Caution Half Done Light Bulb
Brazil Priority 4 Frustrated Down Go Three Quarters Done Pin
Argentina Priority 5 Happy Revert Stop Task Done Question
Colombia Priority 1 Sad Left Caution Not Done Exclamation
UK Priority 2 Angry Right Quarter Done Light Bulb
France Priority 3 Frustrated Up Half Done Pin
Germany Priority 4 Down Three Quarters Done
Spain Priority 5 Revert Task Done
Italy
Australia
China
Japan
US
Canada
Mexico
Brazil
Argentina
Colombia
UK
France
Germany
Spain
Italy
Australia
China
Japan