In: Statistics and Probability
Your company has sent you on business to the Los Angeles (LA) metropolitan area. Upon your arrival at LAX, you make your way to the Klunker Car Rental counter. As usual, the line at the counter is long, so you enter and begin your wait. While waiting you notice that Klunker is offering a special deal on gas. They are selling gas for $1.579 per gallon. However, you must purchase a full tank when you rent the car. Klunker also says that the average price per gallon of gas in the LA area is $1.60. You are uncertain of several necessary pieces of information to determine whether you should take advantage of this deal. These are: · the total miles you will drive on the trip; · rental car gas mileage; · how much gas the rental car's tank holds; · the true cost of gas in the LA area. First, you expect to drive between 150 and 250 miles on this trip. You believe there is an equal chance that you will drive either of these extreme amounts. However, you may have to make a side trip to Edwards AFB that will increase the total miles to 500. You believe there is a 1 in 5 chance that this will happen. Normally, Klunker rents you a mid-size car. You believe most cars in this class have either a 15 gallon gas tank with 60% confidence or a 18 gallon gas tank with 40% confidence. You've heard that cars in this class get as much as 25 mpg on the highway but may get as little as 18 mpg city driving. You decide there is an 70% chance most of your driving will be on the freeways and the rest in the city. Finally, you don't believe Klunker's posted average price of $1.60 per gallon in the LA area. You guess that there is 40% chance that the gas will be $1.259, 20% chance it will be $1.479 and a 40% chance it will be $1.659. Assume you must decide whether to pre-purchase the tank of gas prior to talking to a Klunker clerk.
a. Draw the decision tree for this problem using Decision Tree in Excel.
b. What is the optimal decision?
c. Now suppose you can delay your decision until you speak to a clerk and find out exactly how much gas your rental car holds. The clerk says the car you will rent holds 18 gallons of gas. What is your optimal decision now? What is the value of this additional information? *Please show formulas in excel*
a) The decision tree is a completely symmetric decision tree.
Trees start with deciding whether or not to buy a full gas tank.
According to the decision node, there are four miles per gallon per
gallon, the size of the rental tan car fuel tank and the cost of
gas in the LA area.
The following table summarizes the results for each state of the
possible nature.
b)
Based on the decision tree with the above results included, the
best solution is to buy a gas tank with a cash value of
approximately $ 26.30.
c)
If the decision is delayed until the clerk states that there is an
18-gallon tank in the rental car, the decision remains the same.
Estimated monetary value rises to $ 29,6886, but since the decision
has not been changed, this information is worthless.