Purchase Solution

Susan Helms: independent gas station

Not what you're looking for?

Ask Custom Question

Develop a decision tree. Assume each outcome is equally likely, then find the highest EMV. Attached please find additional information. Need the problem to be solved in excel. Thanks!

Textbook info: Operations Management, 8th Edition
Authors: Jay Heizer and Barry Render
Prentice-Hall

Even through independent gasoline stations have been having a difficult time, Susan Helms 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 Station Good Market ($) Fair Market ($) Poor Market ($)
Small 50,000 20,000 -10,000
Medium 80,000 30,000 -20,000
Large 100,000 30,000 -40,000
Very large 300,000 25,000 -160,000

A.2e
Develop a decision tree. Assume each outcome is equally likely, then find the highest EMV.

Attachments
Purchase this Solution

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.