What data does Rebecca need to help perform the analysis for her dad?

To help perform the analysis for her dad, Rebecca needs the following data:

1. What data does Rebecca need to help perform the analysis for her dad?

To help perform the analysis for her dad, Rebecca needs the following data:

1. Mileage: The number of miles Jim will drive per year.
2. Driving Habits: The proportion of Jim’s driving that is highway miles versus city driving.
3. Fuel Consumption: The Environmental Protection Agency (EPA) ratings for fuel economy of each engine option.
4. Fuel Prices: Average gasoline and diesel prices in Jim’s area.
5. Price Differential: The price difference between diesel and unleaded gasoline.

1. What assumptions should she use in her calculations?

When performing the analysis, Rebecca should make the following assumptions:

1. Mileage: Assume that Jim will continue to drive approximately 18,000 miles per year.
2. Driving Habits: Estimate that 60% of Jim’s driving is highway miles, while 40% is city driving.
3. Fuel Consumption: Utilize the Environmental Protection Agency (EPA) ratings for fuel economy provided for each engine.
4. Fuel Prices: Use the average gasoline and diesel prices obtained from the U.S. Energy Information Administration website. It’s important to note that these prices are historical averages and may not reflect the current prices in Jim’s area.
5. Price Differential: Assume a $0.25 per gallon premium for diesel compared to unleaded gasoline, as mentioned by Jim.

1. What technique should Rebecca use to solve this problem?
2. What might Rebecca’s solution look like?
3. What recommendation should Rebecca make? How should it be presented to Jim?

Daddy Wants a Diesel or Does He?

INTRODUCTION

Rebecca shook her head and gave a loud sigh as she hung up the phone from talking with her dad.

“What is it?” her roommate Claire asked.

“Per usual, Daddy Jim wants me to use my ‘schooling,’ as he likes to call it, to help him decide whether to buy a new crew cab truck with either a diesel or a gas engine,” Rebecca replied.

“Well, maybe he will forget all about it if you just wait him out,” Claire offered.

“Oh no, you do not know him like I do. He will expect a full analysis, or I will never hear the end of it!”

“Well, maybe you will think twice before bragging to him about your examination scores in accounting after this,” Claire said.

“You got that right! I will have to get on it right after my last final, or there will be no peace over break,” Rebecca responded.

THE MODELS AND ENGINES

Rebecca opened the last e-mail from her dad to find the following information he compiled about the purchase decision. Jim made it quite clear that he wanted a 4 × 4 to be able to get his boat up the steep, sandy ramp he used most frequently. His friend, Kashef, had a late-model truck that impressed Jim very much. Any truck

in this class that he chose would offer standard equipment, which is a huge step up from the 2012 Scion iQ he had bought when gas surged in 2012. However, Jim was not sure whether getting the standard engine (the V6), or paying extra for the V8 or Diesel made

any sense. That is where Rebecca came in.

The engine choices were a 3.6-liter V6 rated at 295 horsepower, a 3.0-liter diesel V6 rated at 240 horsepower, or a 5.7-liter V8 rated at

360 horsepower. All of the trucks were capable of pulling Jim’s boat,

a 17-foot Carolina Skiff that weighed just short of 1,500 lbs. including the boat, motor, and gear.

Vehicle mileage was one issue at hand, as well as Jim’s driving habits. The V6’s Environmental Protection Agency (EPA) rating was 17 city miles per gallon (MPG) and 25 highway MPG, while the diesel was rated 21 city MPG and 29 highway MPG. The V8

was rated at 15 city MPG and 22 highway MPG. The manufacturer suggested 89 octane fuel for the V8, but Jim indicated he would

use 87 octane unless engine pinging became pronounced. The manufacturer’s “Build and Price” feature indicated that the V6 came standard, but the diesel was a $4,270 option, and a V8 was a

$1,250 option.

GAS AND DIESEL PRICES

In his e-mail to Rebecca, Jim said diesel usually ran $0.25 more per gallon than unleaded gas. He was not sure whether this was accurate but thought it was in the ballpark. Rebecca wondered about this, since she had never paid attention to diesel prices in her own trips

to fill up. She decided to check the price differential by visiting the U.S. Energy Information Administration website. See Table for the information she found.

Without computing the averages, she noticed there was a premium for diesel compared with regular gasoline, as reported by

the U.S. Energy Information Administration averages.1 Jim’s estimate of $0.25 appeared a bit high. She noted that she could obtain more

1“Weekly Retail Gasoline and Diesel Prices,” U.S. Energy Information Administration, Released February 2, 2018, www.eia.gov/dnav/pet/PET_PRI_ GND_DCUS_NUS_W.htm.

specific fuel price information based on geographic location. But

there was also an issue of whether the area where Jim drives was in an area requiring reformulated or conventional fuel. Because she lacked specific details and needed to get to a review session for intermediate class, Rebecca decided to use the U.S. averages.

DRIVING HABITS

Rebecca did not need an e-mail to tell her about Jim’s driving habits. He had recently commented that his current Scion

iQ had topped 100,000 miles after five and a half years of ownership. He bought that car as a reaction to the spike in fuel prices in 2012 and regretted his decision ever since.

Rebecca suspected that the miles he drove per year had declined some since she and her siblings had gone off to college more than three years ago, even though they usually refused to ride in his car, because, frankly, it was embarrassing. As Rebecca graduated and

went off to college and with her siblings in the Peace Corps overseas,

Jim would not have to drive them around anymore, thereby reducing

3.75% per year, which was in-line with the Wall Street Journal Prime Rate. Because of his thriftiness, Jim had accumulated enough wealth to pay cash for the purchase of the new car without affecting his or Rebecca’s mom’s lifestyles.

CONCLUSION

A car horn startled Rebecca out of her automotive ruminations. She motioned to her roommate that she will be out in a minute for their well-deserved, end-of-semester dinner. Rebecca knew she would need to put her thoughts into a more usable format before heading home over break. So diesel got better mileage, but it costs more per gallon and was a large additional cost at

the time of purchase. This would require more than an armchair approach. Did she have all the information she needed to perform her analysis? What approach should she use to give her dad the best information to make a decision?

QUESTIONS:

his mileage. Rebecca also knew that Jim and her mother would take

driving vacations as they became empty nesters. She decided that Jim would continue to drive approximately 18,000 miles per year for the foreseeable future. Her best guess was that 60% of his driving was highway miles, while 40% were driven in the city.

Jim had been very thrifty throughout his life. He was a very cautious investor, even more so now that he was getting older. During Rebecca’s last trip home, he had said that he thought

he could continue to earn a return on all of his investments of

1. What data does Rebecca need to help perform the analysis for her dad?

2. What assumptions should she use in her calculations?

3. What technique should Rebecca use to solve this problem?

4. What might Rebecca’s solution look like?

5. What recommendation should Rebecca make? How should it be presented to Jim?

ABOUT IMA® (INSTITUTE OF MANAGEMENT ACCOUNTANTS) IMA®, the association of accountants and financial professionals in business, is one of the largest and most respected associations focused exclusively on advancing the management accounting profession. Globally, IMA supports the profession through

research, the CMA® (Certified Management Accountant) program, continuing education, networking and advocacy of the highest ethical business practices. IMA has a global network of more

than 100,000 members in 140 countries and 300 professional and student chapters. Headquartered in Montvale, N.J., USA, IMA provides localized services through its four global regions: The Americas, Asia/Pacific, Europe, and Middle East/India. For more information about IMA, please visit www.imanet.org.