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

  Prepare a bank reconciliation

Prepare a bank reconciliation as of November 30 using the form below. Journalize the necessary entries based on the reconciliation.

  In 2010 music inc purchased popstar music for 3 million at

in 2010 music inc. purchased popstar music for 3 million. at december 31 2011 the popstar music division reported net

  Materials constitute a significant part of the

materials constitute a significant part of the manufacturing costs of an organization and therefore it is essential

  Accounting standard impacts on profits

Read the following article and adopting a Positive Accounting Theory perspective, consider the following issues:  If a new accounting standard impacts on profits, should this impact on the value of the firm, and if so, why?

  During 2013 rachael parkins president of mathieson company

during 2013 rachael parkins president of mathieson company was paid a semimonthly salary of 6800. compute the amount of

  Consider how an individual could manipulate reported

consider how an individual could manipulate reported earnings by misstating the ending works degrees of completion in

  On january 1 2011 trillini corporation issued 4490000 of

on january 1 2011 trillini corporation issued 4490000 of 10-year 10 convertible debentures at 103. interest is to be

  Spot new products and services

Most successful businesses are focused on existing markets and may not have the vision to spot new products and services. Respond to the following in a 250 -300 word post: Is this happening where you work?

  Assume that production was 100000 units and sales were

boots r us produces a variety of products for the fashion industry cowboy type boots are among its most popular

  Earthquake drought fire economic famine flood and a

earthquake drought fire economic famine flood and a pestilence of tv court reporters have caused an exodus from the

  Fraud important in a fraud investigation

Why is knowing why an individual committed fraud important in a fraud investigation?

  Striker auto is looking into their car manufacturing costs

striker auto is looking into their car manufacturing costs at its kansas city plant. striker has recently received an

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