Essentials of Business Analytics (MindTap Course List)
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Textbook Question
100%
Book Icon
Chapter 15, Problem 3P

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:

Chapter 15, Problem 3P, Amy Lloyd is interested in leasing a new Honda and has contacted three automobile dealers for

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(36,000 – 36,000) = $10,764 if she drives 12,000 miles per year, 36($299) + $0.15(45,000 – 36,000) = $12,114 if she drives 15,000 miles per year, or 36($299) + $0.15(54.000 – 36,000) = $13,464 if she drives 18,000 miles per year.

  1. a. What is the decision, and what is the chance event?
  2. b. Construct a payoff table for Amy’s problem.
  3. c. If Amy has no idea which of the three mileage assumptions is most appropriate, what is the recommended decision (leasing option) using the optimistic, conservative, and minimax regret approaches?
  4. d. Suppose that the probabilities that Amy drives 12,000, 15,000, and 18,000 miles per year are 0.5, 0.4, and 0.1, respectively. What option should Amy choose using the expected value approach?
  5. e. Develop a risk profile for the decision selected in part (d). What is the most likely cost, and what is its probability?
  6. f. Suppose that, after further consideration, Amy concludes that the probabilities that she will drive 12,000, 15,000, and 18,000 miles per year are 0.3, 0.4, and 0.3, respectively. What decision should Amy make using the expected value approach?

a.

Expert Solution
Check Mark
To determine

Find the decision and the chance event faced by Amy.

Explanation of Solution

Here, the decision is based on selecting the best lease option. Thus the least option has three alternatives that are Hepburn Honda, Midtown Motors and Hopkins Automotive.

Here, the chance event is the number of miles Amy will drive.

b.

Expert Solution
Check Mark
To determine

Find the payoff table for Amy’s problem.

Answer to Problem 3P

Thus, the payoff table for Amy’s problem is given as:

 Actual Miles Driven Annually
Decision    120001500018000
Hepburn Honda$10,764$12,114$13,464
Midtown Motors$11,160$11,160$12,960
Hopkins Automotive$11,700$11,700$11,700

Explanation of Solution

The payoff for any combination of alternative and the chance event is the sum of the total monthly charges and total additional mileage cost that is given as follows:

For the Hepburn Honda lease option:

36000 (12000miles×3yrs): 36($299)+$ 0.15×(36000-36000)=$10,764.45000 (15000miles×3yrs): 36($299)+$ 0.15×(45000-36000)=$12,114.54000 (18000miles×3yrs): 36($299)+$ 0.15×(54000-36000)=$13,464.

For the Midtown Motors lease option:

36000 (12000miles×3yrs): 36($299)+$ 0.20×(36000-45000)=$11,160.45000 (15000miles×3yrs): 36($299)+$ 0.20×(45000-45000)=$11,160.54000 (18000miles×3yrs): 36($299)+$ 0.20×(54000-45000)=$12,960.

For the Hopkins Automotive lease option:

36000 (12000miles×3yrs): 36($299)+$ 0.15×(36000-54000)=$11,700.45000 (15000miles×3yrs): 36($299)+$ 0.15×(45000-54000)=$11,700.54000 (18000miles×3yrs): 36($299)+$ 0.15×(54000-54000)=$11,700.

Thus, the payoff table for Amy’s problem is given as:

 Actual Miles Driven Annually
Decision    120001500018000
Hepburn Honda$10,764$12,114$13,464
Midtown Motors$11,160$11,160$12,960
Hopkins Automotive$11,700$11,700$11,700

c.

Expert Solution
Check Mark
To determine

Find the decision using the optimistic, conservative and minimax regret approaches.

Answer to Problem 3P

The Hepburn Honda lease option gives the optimistic approach because it has the smallest minimum profit.

The Hopkins Automotive lease option gives the conservative approach because it has the smallest maximum profit.

The minimax regret is the Hopkins Automotive lease option because it minimizes the maximum regret.

Explanation of Solution

By using the decision tree in Part (a), the maximum and minimum profit based on the decisions Hepburn Honda, Midtown Motors and Hopkins Automotive.

DecisionMaximum ProfitMinimum Profit
Hepburn Honda$10,764$13,464
Midtown Motors$11,160$12,960
Hopkins Automotive$11,700$11,700

Optimistic approach:

The optimistic approach evaluates each decision alternative in terms of best payoff that can occur.

The Hepburn Honda lease option gives the optimistic approach because it has the smallest minimum profit (from the above table).

Conservative approach:

The conservative approach evaluates each decision alternative in terms of worst payoff that can occur.

The Hopkins Automotive lease option gives the conservative approach because it has the smallest maximum profit (from the above table).

Minimax Regret approach:

The minimax regret approach is the difference between the payoff associated with a particular alternative and payoff associated with the most decision that would yield the most desirable payoff for a given state of nature.

Regret or opportunity loss table:

Decision120001500018000Maximum Regret
Hepburn Honda$0$954$1,764$1,764
Midtown Motors$396$0$1,260$1,260
Hopkins Automotive$936$540$0$936

The maximum regret for the decision Hepburn Honda is $1,764, Midtown Motors is $1,260 and Hopkins Automotive is $936.

Here, the Hopkins Automotive lease option has been selected because it minimizes the maximum regret.

d.

Expert Solution
Check Mark
To determine

Find the expected value approach for the probabilities of 0.5, 0.4 and 0.1.

Answer to Problem 3P

The expected value approach results in Midtown Motors lease option.

Explanation of Solution

The formula to find expected value (EV) of decision alternative di is given as follows:

EV(di)=j=1NP(sj)Vij

Here, the expected value for the payoffs associated with each of Amy’s three alternatives:

EV(Hepburn Honda)         =0.5($10,764)+0.4($12,114)+0.1($13,464)                                =$11,574.EV(Midtown Motors)       =0.5($11,160)+0.4($11,160)+0.1($11,160)                                         =$11,340.EV(Hopkins Automotive)  =0.5($11,700)+0.4($11,700)+0.1($11,700)                                         =$11,700.

The expected value approach results in Midtown Motors lease option because it has the minimum expected value of the three alternatives.

e.

Expert Solution
Check Mark
To determine

Find the most likely cost and its probability using risk analysis.

Answer to Problem 3P

The risk analysis for midtown motors, the most likely cost is $11,160 with the probability of 0.9.

Explanation of Solution

From the data in part (d).

The risk profile for the decision to lease from Midtown Motors is:

Essentials of Business Analytics (MindTap Course List), Chapter 15, Problem 3P

From the above risk analysis for midtown motors, the most likely cost is $11,160 with the probability of 0.9.

Here, there are only two unique costs on this graph because for the decision alternative (midtown motors) have two unique payoffs. The payoffs are associated with the three chance outcomes- the payoff (cost) associated with midtown motors lease is same for the two of the chance outcomes.

f.

Expert Solution
Check Mark
To determine

Find the expected value approach for the probabilities of 0.3, 0.4 and 0.3.

Answer to Problem 3P

The expected value approach results in either Midtown Motors lease option or Hopkins Automotive lease option.

Explanation of Solution

The formula to find expected value (EV) of decision alternative di is given as follows:

EV(di)=j=1NP(sj)Vij

Here, the expected value for the payoffs associated with each of Amy’s three alternatives:

EV(Hepburn Honda)         =0.3($10,764)+0.4($12,114)+0.3($13,464)                                =$12,114.EV(Midtown Motors)       =0.3($11,160)+0.4($11,160)+0.3($11,160)                                         =$11,700.EV(Hopkins Automotive)  =0.3($11,700)+0.4($11,700)+0.3($11,700)                                         =$11,700.

The expected value approach results in either Midtown Motors lease option or Hopkins Automotive lease option because both have the same minimum expected value of the three alternatives.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
Douglas contracted to drive a well for Tucker for the sum of $500 and to fur-nish potable water at a flow of 5 gallons per minute. After spending $800 on the work, Douglas was unsuccessful and quit the job. What payment, if any, is Tucker obligated to make?
Ian is paid a base salary of $13,000 per year. In addition to this salary, he receives commission on sales exceeding $6,000. His total salary for last month was $2,300 and his sales were $18,000.   Calculate his commission rate.
A city commission has proposed two tax bills. The first bill requires that a homeowner pay ​$1300 plus 3​% of the assessed home value in taxes. The second bill requires taxes of ​$400 plus 7​% of the assessed home value. What price range of home assessment would make the first bill a better deal for the​ homeowner?
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,
Text book image
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Intermediate Algebra
Algebra
ISBN:9781285195728
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Cengage Learning
Text book image
Algebra for College Students
Algebra
ISBN:9781285195780
Author:Jerome E. Kaufmann, Karen L. Schwitters
Publisher:Cengage Learning
Text book image
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Mod-01 Lec-01 Discrete probability distributions (Part 1); Author: nptelhrd;https://www.youtube.com/watch?v=6x1pL9Yov1k;License: Standard YouTube License, CC-BY
Discrete Probability Distributions; Author: Learn Something;https://www.youtube.com/watch?v=m9U4UelWLFs;License: Standard YouTube License, CC-BY
Probability Distribution Functions (PMF, PDF, CDF); Author: zedstatistics;https://www.youtube.com/watch?v=YXLVjCKVP7U;License: Standard YouTube License, CC-BY
Discrete Distributions: Binomial, Poisson and Hypergeometric | Statistics for Data Science; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=lHhyy4JMigg;License: Standard Youtube License