Prepare a regression analysis separating the costs

Assignment Help Accounting Basics
Reference no: EM13843663

Mel Cheek is a fishing guide on the Chenega River. The fish are usually found 20 to 50 miles upriver. Once the fish are located, Mel slows the boat to trolling speed and fishes for about 6 hours before returning to dock. Mel has noted that overall fuel costs vary based on "miles upriver" and he is considering changing his guide fee to separately charge customers for estimated fuel costs. Below is Mel's log for 15 typical days showing "miles upriver to locate fish" and "total fuel cost".

Day 1

Miles Upriver 37

Fuel Cost $86

2

41

93

3

22

73

4

28

80

5

49

99

6

25

74

7

33

85

8

37

87

9

44

93

10

24

77

11

29

80

12

45

96

13

35

83

14

36

87

15

31

80

(a) Prepare a scattergraph diagram for the preceding data set showing that "fixed costs" are approximately $50 and variable costs are approximately $1 per mile upriver.

(b) (optional) Use the functions within an eletronic spreadsheet to prepare a regression analysis separating the costs into fixed and variable components. Do individual data points appear to fit well into the regression model?

Reference no: EM13843663

Questions Cloud

Compute the mad of forecast errors : Compute the MAD of forecast errors. Using RSFE, compute the tracking signal. Based on your answers to parts (a) and (b), comment on Harlen's method of forecasting.
How about a costrich : Suppose you have a class CBird, as follows, that you want to use as a base class for deriving a hierarchy of bird classes
Explain ratios can you calculate based on the data provided : Which meaningful ratios can you calculate based on the data provided. Is there sufficient data to determine which is the better performing graphic. If yes, which is the best performing graphic.
Why effective management of organizational change important : Please answer the following questions: For each paper, please use one paragraph to summarize the main ideas. Please use one half page to summarize the ideas that are similar among all of these papers. Why is the effective management of organizational..
Prepare a regression analysis separating the costs : Use the functions within an eletronic spreadsheet to prepare a regression analysis separating the costs into fixed and variable components. Do individual data points appear to fit well into the regression model?
Examine a copy of a manual for a software program : Examine a copy of a manual for a software program such as a word processor, spreadsheet, or database, or examine a help system for a program you use regularly.
How do change efforts differ : Please answer the following questions: For each paper, please use one paragraph to summarize the main ideas. Please use one half page to summarize the ideas that are similar among all of these papers. How do change efforts differ
Describe principles of effective interpersonal communication : Describe the basic principles and importance of effective interpersonal communication, active listening and reading for meaning. Argue the importance of ethics, codes of behaviour, and societal, privacy and legal issues within the ICT industry.
Does the component fail according tresca criterion : Mpas Calculate the difference between max an min principal stresses Does the component fail according tresca criterion ?

Reviews

Write a Review

Accounting Basics Questions & Answers

  Demonstrate multidisciplinary agility

You might decide that Communication is the general education skill that provides the biggest edge to employees. Then, you might write about the increasing importance of written communication as it relates to increased technology available to those..

  What would be the amount of interest expense

What would be the amount of interest revenue the lessor would record in conjunction with the second quarterly payment at October 1? (Round your answer to the nearest dollar amount. Omit the "tiny_mce_markerquot; sign in your response.)

  Compute the current break-even point in units

Compute the current break-even point in units, and compare it to the break-even point in units if Mary's ideas are used. Compute the margin of safety ratio for current operations and after Mary's changes are introduced.

  Townson company had gross wages of 200000 during the week

townson company had gross wages of 200000 during the week ended december 10. the amount of wages subject to social

  Ethics concerns in an international organization

1. What are some corporate risks that can destroy a company's strategic position? List several risks. 2. What are some ethics concerns in an international organization? Elaborate your answer.

  Remco gourmet water company produces and distributes

remco gourmet water company produces and distributes bottled water in a variety of natural flavors. jan cancel a

  Future lease payments for an operating lease

Using IFRS, future lease payments for an operating lease include what required disclosures?

  What is the purpose of balance sheet classification

What is the purpose of balance sheet classification? How useful is the information produced from a classified balance sheet? What are some alternative classification systems that could be used?

  Current stock price what would be the dividend yield?

Currently Chester is paying a dividend of $16.10 (per share). If this dividend were raised by $3.64, given its current stock price what would be the Dividend Yield?

  Smith and jones each own tracts of land because of the

smith and jones each own tracts of land. because of the location of their current operations each would prefer to have

  How should you evaluate macgivers annual report in light of

macgiver brass is a brass plating firm with sales of 8 million and profits before taxes of 625000. macgiver has a loan

  Find out the amount of depreciation expense

Determine the amount of depreciation expense for the years ended December 31, 2009, 2010, 2011, and 2012, by (a) the straight-line method, (b) the units-of-production method, and (c) the double-declining-balance method. Also determine the total de..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd