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

  The cutting departments output during the period consists

the cutting departments output during the period consists of 18000 units completed and transferred out and 4000 units

  Perdisco platform managing general entries

Perdisco platform managing general entries of basic accounts

  In 2010 jake who files head of household made a 1900

in 2010 jake who files head of household made a 1900 payment for qualified mortgage insurance paid under a contract

  Prepare a multiple-step income statement

Prepare a multiple-step income statement.

  Hypothetical jet purchaseassume that fedex will finance its

hypothetical jet purchaseassume that fedex will finance its first four 777f aircraft with boeing capital

  Calculate the sales revenue

Calculate the sales revenue reported by XYZ Company in its 2004 income statement.

  Direct labor-variable or fixed cost

Discuss whether direct labor is a fixed or a variable cost. What are the pros and cons of management treating direct labor as a variable cost?

  Angela purchased a car for 30000 by putting 20 down in cash

part a angela purchased a car for 30000 by putting 20 down in cash with the balance due as a note payable. journalize

  Business as a partnership or a corporation

Business as a partnership or a corporation

  Income statement in the contribution format

How many units would have to be sold during 2013 to earn a target profit of $59,000 for the year and Show both a total column and a per unit column on your statement

  Deferred income tax liability for temporary difference

Assume a present and future enacted income tax rate of 30%. What amount should be added to Gore's deferred income tax liability for this temporary difference at December 31, 2011?

  Company makes fruit pies using a process cost system

Company makes fruit pies using a process cost system.

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