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

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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