Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show all excel formulas! Thank you! 3. Car Leases. Amy Lloyd is interested in leasing a new Honda and has contacted three automobile dealers
Please show all excel formulas!
Thank you!
3. Car Leases. 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 are as follows: Dealer Monthly Cost Mileage Cost per Allowance 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(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(5299) + $0.15(54,000 - 36,000) = $13,464 if she drives 18,000 miles per year. a. What is the decision, and what is the chance event? b. Construct a payoff table for Amy's problem. 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? 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? e. Develop a risk profile for the decision selected in part (d). What is the most likely cost, and what is its probability? 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? 3. Car Leases. 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 are as follows: Dealer Monthly Cost Mileage Cost per Allowance 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(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(5299) + $0.15(54,000 - 36,000) = $13,464 if she drives 18,000 miles per year. a. What is the decision, and what is the chance event? b. Construct a payoff table for Amy's problem. 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? 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? e. Develop a risk profile for the decision selected in part (d). What is the most likely cost, and what is its probability? 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 approachStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started