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

  Using the result obtain in a what is your 2013 projectionif

the sales data for lonestar sports apparel company for the last 12 years are as follows2001 400000 2007 617000 2002

  Atlas steel company produces three grades of steel high

atlas steel company produces three grades of steel high good and regular grade. each of these products grades has high

  By the end of the period 37300 units of product had been

the following labor standards have been established for a particular productstandard hours per unit 1.7

  Comparability of accounting income numbers

What are the implications of this in terms of a conceptual framework project, specific accounting standards, and comparability of accounting income numbers?

  What factors may cause the effective interest rate

What factors may cause the effective interest rate and the stated interest rate to be different?

  Decision making across the organization byp2-4 lisa ortega

decision making across the organization byp2-4 lisa ortega is president of ortega riding academy inc. the academys

  Applying the theory of constraintsexplain why your

applying the theory of constraints.explain why your organization does not have unlimited resources space inventory

  Ida sidha karya company is a family-owned company located

ida sidha karya company is a family-owned company located in the village of gianyar on the island of bali in indonesia.

  Kaplan inc produces flash drives for computers which it

kaplan inc. produces flash drives for computers which it sells for 20 each. the variable cost to make each flash drive

  Daan corporation wholesales repair products to equipment

entries for issuing bonds and amortizing premium by straight-line methoddaan corporation wholesales repair products to

  Shares of common stock out-standing

Misty's effective tax rate is 40% and there were 1,000 shares of common stock outstanding.

  Sales level required in both dollars and units

Compute the sales level required in both dollars and units to earn $210,000 of after-tax income in 2010 with the machine installed and no change in unit sales price. Assume that the income tax rate is 30%.

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