Amy Lloyd is interested in leasing a new Honda and has contacted three automobile dealers for pricing information. Each dealer offered Amy a closed-end 36-month lease with no down payment due at the time of signing. Each lease includes a monthly charge and a mileage allowance. Additional miles receive a surcharge on a per-mile basis. The monthly lease cost, the mileage allowance, and the cost for additional miles follow:

Dealer Monthly Cost Mileage Allowance Cost per Additional Mile
Hepburn Honda $299 36,000 $0.15
Midtown Motors $310 45,000 $0.20
Hopkins Automotive $325 54,000 $0.15

Amy decided to choose the lease option that will minimize her total 36-month cost. The difficulty is that Amy is not sure how many miles she will drive over the next three years. For purposes of this decision, she believes it is reasonable to assume that she will drive 12,000 miles per year, 15,000 miles per year, or 18,000 miles per year. With this assumption Amy estimated her total costs for the three lease options. For example, she figures that the Hepburn Honda lease will cost her 36($299) + $0.15(36000 - 36000) = $10,764 if she drives 12,000 miles per year, 36($299) + $0.15(45000 - 36000) = $12,114 if she drives 15,000 miles per year, or 36($299) + $0.15(54000 - 36000) = $13,464 if she drives 18,000 miles per year.

Required:
Construct a payoff table for Amy's problem.

To illustrate how the payoffs were computed, I will show how to compute the total cost of the Hepburn Honda lease assuming Amy drives 15,000 miles per year.

Total cost = (Total Monthly Charges) + (Total Additional Mileage Cost)

= 36 ( $299) + $0.15 (45,000 - 36,000)

= $10,764 + $1350

= $ 12,114

Answer:

Actual Miles Driven Annually

Dealer 12,000 15,000 18,000

Hepburn Honda $10,764 $12,114 $13,464

Midtown Motors $11,160 $11,160 $12,960

Hopkins Automotive $11,700 $11,700 $11,700