Question

In: Accounting

As the management accountant for Pleasanton Raft Company, Inc., you have been asked to attend a...

As the management accountant for Pleasanton Raft Company, Inc., you have been asked to attend a planning session for the next season. The owner, Mara Mason specifically wants to be able to predict her fuel costs each coming week.

Mara typically staffs the desk at the river – answering the phone, checking in customers, and taking payment – while her staff drives the customers and rafts out to the river. Since she is not actively driving the van, it has been her process to maintain a separate bank account specifically for fuel costs, and giving the debit card tied to the account to her staff. That way, staff members can easily fill the tank on the way back from dropping off customers. To limit her risk, Mara wants to keep a low balance in this account, just sufficient to pay fuel costs for the upcoming week. To that end, she currently checks the balance in the account each Monday morning, and transfers in just enough funds to bring the balance to $275.

This past season, Mara had some cash flow issues – there were a couple of occasions this year where the company debit card was declined for insufficient funds at the gas station. This can be a serious problem. If the van runs out of gas, she is not able to transport customers to the river, and she will potentially lose customers. Also, if the charge does go through, she is liable for overdraft fees. Therefore, Mara wants to improve from her current process of refilling that account to $275 at the beginning of each week.

Mara started out by collecting data – on each Monday morning, she recorded the price of gas and the number of reservations for the coming week (see the attached Excel spreadsheet). She would like to use one of these measures to estimate the week’s fuel costs, but she is not sure which one would give her the best estimate. The number of reservations tells her how many customers have reserved boats for the coming week, but some reservations are later cancelled (or no-shows) and many customers show up unannounced for a trip down the river. In addition, the price of gas on Monday morning usually does not stay the same through the entire week. Mara knows that neither of these variables will perfectly predict her fuel costs, but figures that anything would be better than her current process.

DATA:

Pleasanton Raft Company, Inc.
Fuel Cost Data, current year
Week # of reservations Gas price (as of Monday morning) Fuel cost (total cost for the week)
1 3 $2.55 $153.52
2 20 $2.67 $170.79
3 23 $2.64 $249.39
4 10 $2.43 $204.00
5 15 $2.34 $218.31
6 8 $2.64 $170.17
7 24 $2.58 $212.86
8 13 $2.64 $223.35
9 10 $2.33 $160.63
10 1 $2.26 $139.91
11 29 $2.29 $208.70
12 22 $2.75 $244.41
13 41 $2.61 $287.18
14 15 $2.37 $243.92
15 5 $2.31 $198.09
16 30 $2.43 $250.39
17 32 $2.35 $225.19
18 6 $2.21 $286.29
19 35 $2.87 $274.92
20 18 $2.50 $186.28
21 27 $2.58 $211.33
22 27 $2.72 $246.94
23 19 $2.23 $188.97
24 11 $2.25 $177.65
25 7 $2.30 $149.27
26 9 $2.41 $177.60

FULE COST INFO IS IN THE TABLE - Please let me know what more info do you need? The comments keep saying the same thing but I did provide the info.

Required:

Write a 1-2 page memo, as the accountant of Pleasanton Rafts, addressed to Mara Mason describing your analysis and the outcomes. Make sure you respond to the following items:

1. Of the three cost estimation methods covered in this class (high-low method, scatter diagrams, or least squares regression), which would give the most accurate cost estimates? Explain why that method is more accurate, and how it works.

Solutions

Expert Solution


Related Solutions

As the management accountant for Pleasanton Raft Company, Inc., you have been asked to attend a...
As the management accountant for Pleasanton Raft Company, Inc., you have been asked to attend a planning session for the next season. The owner, Mara Mason specifically wants to be able to predict her fuel costs each coming week. Mara typically staffs the desk at the river – answering the phone, checking in customers, and taking payment – while her staff drives the customers and rafts out to the river. Since she is not actively driving the van, it has...
1. As the management accountant of TAR Ltd, a printing company, you have been asked to...
1. As the management accountant of TAR Ltd, a printing company, you have been asked to prepare a quotation for a large museum that requires a catalogue of its exhibits to be printed for sale to visitors. This is a new business sector for TAR Ltd to operate in, with much of its existing business in the local government and public sector fields. The printing manager has carried out a sample production run, and worked with existing and new suppliers,...
As a newly hired management accountant, you have been asked to prepare a profit plan for...
As a newly hired management accountant, you have been asked to prepare a profit plan for the company for which you work. As part of this task, you’ve been asked to do some what-if analyses. Following is the budgeted information regarding the coming year: Selling price per unit $ 100.00 Variable cost per unit 70.00 Fixed costs (per year) 1,200,000 Required: 1. What is the breakeven volume, in units and dollars, for the coming year? 2. Assume that the goal...
As a newly hired management accountant, you have been asked to prepare a profit plan for...
As a newly hired management accountant, you have been asked to prepare a profit plan for the company for which you work. As part of this task, you’ve been asked to do some what-if analysis. Following is the budgeted information regarding the coming year: Selling price per unit $ 100.00 Variable cost per unit 70.00 Fixed costs (per year) 1,200,000. 1)What is the breakeven volume, in units, for the coming year? 2) Assume that of the $70 variable cost per...
Item1 Item1 Item 1 As a newly hired management accountant, you have been asked to prepare...
Item1 Item1 Item 1 As a newly hired management accountant, you have been asked to prepare a profit plan for the company for which you work. As part of this task, you’ve been asked to do some what-if analyses. Following is the budgeted information regarding the coming year: Selling price per unit $ 100.00 Variable cost per unit 70.00 Fixed costs (per year) 1,200,000 Required: 1. What is the breakeven volume, in units and dollars, for the coming year? 2....
cenario You are the global marketing vice president at Dyson. You have been asked to attend...
cenario You are the global marketing vice president at Dyson. You have been asked to attend a meeting with James Dyson, the company's founder. Dyson's CEO and the head of Dyson's New Product Innovation department will also be in attendance. "Thanks for meeting with me today," James says. "Market intelligence has shown that our major competitors—Hoover, Shark, and Bissell—are all developing new cordless vacuum cleaners with a longer battery life than what's currently available." James Dyson looks to you: "I...
You have been asked, as a digital health professional, to attend a team meeting at your...
You have been asked, as a digital health professional, to attend a team meeting at your hospital to discuss discharge plans for Mildred Mason. She is a 68 year old widow, hospitalized for a fractured wrist and ankle and a head injury resulting from a fall at home.   She is almost ready for discharge from acute care, but the team is concerned that she will need care in the short term. Because of some problems that may have led to...
You have been asked by a business director (BD) to attend a strategy meeting. The business...
You have been asked by a business director (BD) to attend a strategy meeting. The business wants to expand into India. The BD states that he’s heard of the law called the FCPA. He wants to know what it is and does it impact his efforts to develop business in India? Please respond in a memo to the BD
You are the junior accountant at CBW Bank. You have been asked to assist with the...
You are the junior accountant at CBW Bank. You have been asked to assist with the 30 June 2020 tax work: i)                    The Bank provided loans totaling $5,000,000 in mortgage loans, equally to 10 of its staff during the year. These loans were interest only repayments and were made at arm’s length, at an interest rate of 5.37%. ii)                   Due to a staff restructuring at the bank, 3 of the staff who took mortgage loans were made redundant on 30 November 2019....
You are the junior accountant at CBW Bank. You have been asked to assist with the...
You are the junior accountant at CBW Bank. You have been asked to assist with the 30 June 2020 tax work: i) The Bank provided loans totaling $5,000,000 in mortgage loans, equally to 10 of its staff during the year. These loans were interest only repayments and were made at arm’s length, at an interest rate of 5.37%. ii) Due to a staff restructuring at the bank, 3 of the staff who took mortgage loans were made redundant on 30...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT