Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please attach the spreadsheet to show the workings PS.53 Brother I.D. Ricks is a faculty member at BYU-Idaho whose grandchildren live in Oklahoma and California.

image text in transcribed

Please attach the spreadsheet to show the workings

PS.53 Brother I.D. Ricks is a faculty member at BYU-Idaho whose grandchildren live in Oklahoma and California. He and his wife would like to visit their grandchildren at least once a year in these states. They currently have one vehicle with well over 100,000 miles on it, so they want to buy a newer vehicle with fewer miles and that gets better gas mileage. They are considering two options: (1) a new subcompact car that would cost $21,000 to purchase or (2) a used sedan that would cost $15,000. They anticipate that the new subcompact would get 35 miles per gallon (combined highway and around town driving) while the sedan would get 24 miles per gallon. Based on their road tripping history they expect to drive 18,000 miles per year. For the purposes of their analysis they are assuming that gas will cost $2.91 per gallon. Question: How many miles would the Ricks need to drive before the cost of these two options would be the same? (Display your answer to the nearest whole number.) (Hint: The challenge with this problem is finding the variable costs. First determine the variable costs per mile, in terms of gasoline costs. From there you can easily use the break-even formula to find the break-even point in terms of miles-and then do some simple math to get the break-even point in years.) How many years would it take for these two options to cost the same? (Display your answer to two decimal places.) Suppose a severe disruption to the petroleum supply resulted in a $1.50 increase to the price of gasoline. How many miles would it now take before the cost of these two options would be the same? (Display your answer to the nearest whole number.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Management Information Systems

Authors: Ken Laudon, Kenneth C Laudon

10th Edition

0133033090, 9780133033090

More Books

Students also viewed these General Management questions

Question

Define epistemology.

Answered: 1 week ago

Question

What are the three key variables for improved labor productivity

Answered: 1 week ago

Question

2. What types of information are we collecting?

Answered: 1 week ago

Question

5. How quickly can we manage to collect the information?

Answered: 1 week ago

Question

3. Tactical/strategic information.

Answered: 1 week ago