Estimate the values using the high-low method

Assignment Help Accounting Basics
Reference no: EM13859254

Assume the following data (where the xxx is the last three digits of your panther id):

Month Machine Hours (hrs.) Maintenance Costs ($)
1 1,330  102,xxx
2 1,400  103,xxx
3 1,500  108,xxx
4 1,470  108,xxx
5 1,620  116,xxx
6 1,690  115,xxx
7 1,490  107,xxx
8 1,310  102,xxx
9 1,450  106,xxx
10 1,580  113,xxx
11 1,300  100,xxx
12 1,600  113,xxx
13 1,650  114,xxx
14 1,440  109,xxx
15 1,340  102,xxx
16 1,670  114,xxx
17 1,480  106,xxx
18 1,360  103,xxx
19 1,340  103,xxx
20 1,540  112,xxx

For example, if your panther id is 1234567, then your maintenance costs would be $102,567 in month 1, $103,567 is month 2, $113, 567 in months 10, 12. and 13.

Assume that the following relationship holds:

Maintenance Costs = a + (b * Machine Hours)

REQUIRED

Estimate the values of a and b, using,

1. the High-Low Method, and

2. the Linear Regression method.

Note, to use the linear regression method, you MUST use the Microsoft Excel program.

Make sure to report

a. the values of a and b;

b. a scatter plot of the data points, and

c. the adjusted R-square

Reference no: EM13859254

Questions Cloud

Determine a frequency and severity rating : The Pebbles, Inc. (the "Company) is a casino & resort operating company based in Las Vegas, Nevada, USA. The Company's resorts feature high-end accommodations, gaming and entertainment, convention and exhibition facilities, celebrity chef restaur..
Develop an automatic process costing system : You need to develop an automatic process costing system based on the FIFO method that will calculate LSW's ending inventory and cost of goods manufactured for every period.
Draw an aon network for the construction activity : Draw an AON network for the construction activity. What is the critical path? (note the path and the time)? Draw the Gantt chart for the whole construction activity
Seminar topic- service quality : Seminar topic: Service Quality. View this week's archived Seminar and write a 1-page paper, double spaced, that summarizes the Seminar and what you learned
Estimate the values using the high-low method : Estimate the values of a and b, using the High-Low Method, and the Linear Regression method.
Benefits of the specific product or brand you selected : Think about the last purchase you made in each of the following product categories.  Clearly describe the features, advantages, and  benefits of the specific product or brand you selected
Short evaluation of the corporate culture : Consider your current or previous place of work and complete a short evaluation of the corporate culture. What conclusions can you draw?
List the current competitors for your product or business : List the current competitors (if any) for your product or business? How will you differentiate your product or business from the competition
Differences of a plant cell when compared to an animal cell : Describe the overall differences of a plant cell when compared to an animal cell

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