Essentials Of Business Analytics
Essentials Of Business Analytics
1st Edition
ISBN: 9781285187273
Author: Camm, Jeff.
Publisher: Cengage Learning,
bartleby

Concept explainers

bartleby

Videos

Textbook Question
100%
Book Icon
Chapter 12, 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 12, 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, Chapter 12, 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
Suppose the premium for policy A is reduced to ​$25. Now how many units should be purchased from each plan to minimize the cost of the​ premiums? What is the minimum​ premium?
Assume a sales price per unit of $25, variable cost per unit $15, and total fixed costs of $18000. If no units are sold, how much cost would the company incur?
The Unilever Company plans to allocate some or all of its monthly advertising budget of GH¢82,000 in the Mankato area. It can purchase local radio spots at GH¢120 per spot, local TV spots at GH¢600 per spot, and local newspaper advertising at GH¢220 per insertion.The company's policy requirements specify that the company must spend at least GH¢40,000 on TV and allow monthly newspaper expenditures up to GH¢60,000.The payoff from each advertising medium is a function of the size of its audience. The general experience of the firm is that the values of insertions and spots in terms of "audience points" (arbitrary unit), are as given below: ---------------------------------------------------------------------- Radio 40 audience points per spot TV 180 audience points per spot Newspapers 320 audience points per insertion ---------------------------------------------------------------------
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.
Similar questions
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Text book image
Elementary Geometry For College Students, 7e
Geometry
ISBN:9781337614085
Author:Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:Cengage,
Text book image
Intermediate Algebra
Algebra
ISBN:9780998625720
Author:Lynn Marecek
Publisher:OpenStax College
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
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