Decision analysis - Excel QM.docx - Even though independent gasoline stations have been having a difficult time Susan Solomon has been thinking about

# Decision analysis - Excel QM.docx - Even though independent...

• 3
• 67% (3) 2 out of 3 people found this document helpful

This preview shows page 1 - 3 out of 3 pages.

Even though independent gasoline stations have been having a difficult time, Susan Solomon has been thinking about starting her own independent gasoline station. Susan’s problem is to decide how large her station should be. The annual returns will depend on both the size of her station and a number of marketing factors related to the oil industry and demand for gasoline. After a careful analysis, Susan developed the following table:SIZE OF FIRST STATIONGood Market\$Fair market\$Poor market\$Small50,00020,000-10,000Medium80,00030,000-20,000Large100,00030,000-40,000Very large300,00025,000-160,000For example, if Susan constructs a small station and the market is good, she will realize a profit of \$50,000.(a)Develop a decision table for this decision.(b)What is the maximax decision?(c)What is the maximin decision?(d)What is the equally likely decision?(e)What is the criterion of realism decision? Use an a value of 0.8.(f)Develop an opportunity loss table. (g) What is the minimax regret decision?