Decision Tables in Excel

Decision Tables in Excel - $12.9 Certainty Possible Future...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Decision Tables in Excel Uncertainty Possible Future Demand Alternatives Low Medium High Maximax Maximin Laplace Small Facility $10.0 $11.0 $12.0 $12.0 $10.0 $11.0 Medium Facility $9.0 $14.0 $16.0 $16.0 $9.0 $13.0 Large Facility $(4.0) $4.0 $18.0 $18.0 $(4.0) $6.0 Max ---> $18.0 $10.0 $13.0
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Decision Tables in Excel Risk Possible Future Demand Low Medium High Alternatives Prob. 0.3 0.5 0.2 Small Facility $10.0 $11.0 $12.0 $10.9 Medium Facility $9.0 $14.0 $16.0 $12.9 Large Facility $(4.0) $4.0 $18.0 $4.4 Max --->
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $12.9 Certainty Possible Future Demand Low Medium High Alternatives Prob. 0.3 0.5 0.2 Small Facility $10.0 $11.0 $12.0 Medium Facility $9.0 $14.0 $16.0 Large Facility $(4.0) $4.0 $18.0 Sum Max X Risk ----> $3.0 $7.0 $3.6 $13.6 EVPI = $0.7 Sum Products Profit Decision Table Options A B Sale Price $20 $20 Sales Volume 10,000 10,000 Revenue $200,000 $200,000 Fixed Cost $40,000 $70,000 Variable cost $16 $14 Total Cost $200,000 $210,000 Profit $- $(10,000)...
View Full Document

This note was uploaded on 02/27/2012 for the course MSOM 301 taught by Professor Bugge during the Spring '12 term at Temple.

Page1 / 3

Decision Tables in Excel - $12.9 Certainty Possible Future...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online