Using either the high-low method or regression analysis

Reference no: EM13390031

James is trying to determine if there is a relationship between machine hours and utility costs. He has gathered financial information from the last six months as follows:

Month Machine Hours Utility Costs

1 2000 900

2 2800 1420

3 3200 1200

4 3000 1200

5 2200 1300

6 2400 1000

Required:

A. Using either the high-low method or regression analysis, determine the equation for a line. (Note: You will receive 5 extra credit points if you use regression analysis.)

B. James believes that in month 7 the machine hour volume will be 3600 hours. Determine the expected utility cost.

Reference no: EM13390031

Questions Cloud

Describe trade-offs between hubs and switches when planning : explain the trade-offs between hubs and switches when planning for a small business network. the network is spread

Using the waters bottling companyin module 1 continue to : using the waters bottling companyin module 1 continue to build the marketing plan sections for the product you have

By using acceptance sampling suggest a situation in which : six sigma and acceptance sampling please respond to the followingusing acceptance sampling propose a situation in which

Explain proper procedures and policies which would be : consider a scenario where the contingency planning management team cpmt of your organization has designated you as the

Using either the high-low method or regression analysis : james is trying to determine if there is a relationship between machine hours and utility costs. he has gathered

Find out the true cash balance for anas checking account : ana just received her bank statement and wanted to make sure that the balance in her checkbook was correct. ana

Decide upon an initiative you want to implement that would : decide upon an initiative you want to implement that would increase sales over the next five years.using the sample

Compute total cost and average total cost and add it to : you are the owner of a small bread factory and are thinking of lowering costs and expanding. your small-business

The uniform principal and income act of 2000 uniform act : the uniform principal and income act of 2000 uniform act allows the trustee to make adjustments between the principal

User Account

All Pages