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
Cycles to failure Position in ascending order 0.5 f(x)) (x;) Problem 44 Marsha, a renowned cake scientist, is trying to determine how long different cakes can survive intense fork attacks before collapsing into crumbs. To simulate real-world cake consumption, she designs a test where cakes are subjected to repeated fork stabs and bites, mimicking the brutal reality of birthday parties. After rigorous testing, Marsha records 10 observations of how many stabs each cake endured before structural failure. Construct P-P plots for (a.) a normal distribution, (b.) a lognormal distribution, and (c.) a Weibull distribution (using the information included in the table below). Which distribution seems to be the best model for the cycles to failure for this material? Explain your answer in detail. Observation Empirical cumulative Probability distribution Cumulative distribution Inverse of cumulative distribution F-1 (-0.5) F(x)) (S) n 4 3 1 0.05 9 5 2 0.15 7 7 3 0.25 1 10 4 0.35 3 12 5 0.45 Normal…
Problem 3 In their lab, engineer Daniel and Paulina are desperately trying to perfect time travel. But the problem is that their machine still struggles with power inconsistencies-sometimes generating too little energy, other times too much, causing unstable time jumps. To prevent catastrophic misjumps into the Jurassic era or the far future, they must calibrate the machine's power output. After extensive testing, they found that the time machine's power output follows a normal distribution, with an average energy level of 8.7 gigawatts and a standard deviation of 1.2 gigawatts. The Time Travel Safety Board has set strict guidelines: For a successful time jump, the machine's power must be between 8.5 and 9.5 gigawatts. What is the probability that a randomly selected time jump meets this precision requirement? Daniel suggests that adjusting the mean power output could improve time-travel accuracy. Can adjusting the mean reduce the number of dangerous misjumps? If yes, what should the…
Problem 5 ( Marybeth is also interested in the experiment from Problem 2 (associated with the enhancements for Captain America's shield), so she decides to start a detailed literature review on the subject. Among others, she found a paper where they used a 2"(4-1) fractional factorial design in the factors: (A) shield material, (B) throwing mechanism, (C) edge modification, and (D) handle adjustment. The experimental design used in the paper is shown in the table below. a. Run A B с D 1 (1) -1 -1 -1 1 2 a 1 -1 -1 1 3 bd -1 1 -1 1 4 abd 1 1 -1 1 5 cd -1 -1 1 -1 6 acd 1 -1 1 -1 7 bc -1 1 1 -1 abc 1 1 1 -1 paper? s) What was the generator used in the 2"(4-1) fractional factorial design described in the b. Based on the resolution of this design, what do you think about the generator used in the paper? Do you think it was a good choice, or would you have selected a different one? Explain your answer in detail.
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
Elementary Algebra
Algebra
ISBN:9780998625713
Author:Lynn Marecek, MaryAnne Anthony-Smith
Publisher:OpenStax - Rice University
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
Text book image
Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,
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
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