Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel.

Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow:

Month

Machine Hours

Electricity Costs

January

3,500

$

18,900

February

3,900

$

22,000

March

2,900

$

14,000

April

4,100

$

24,000

May

4,800

$

28,750

June

4,300

$

23,000

July

5,500

$

25,250

August

4,500

$

23,250

September

3,000

$

16,500

October

4,700

$

27,000

November

6,800

$

32,000

December

6,000

$

28,250

Summary Output

Regression Statistics

Multiple R

.919

R Square

.844

Adjusted R2

.829

Standard Error

2,165.73

Observations

12.00

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Intercept

5,084.31

2,589.60

1.96

0.08

(685.68)

10,854.29

Machine Hours

4.11

0.56

7.36

0.00

2.86

5.35

If the controller uses high-low method to estimate costs, the cost equation for electricity cost is:( Round intermediate calculations to 2 decimal places)

Multiple choice:

  1. Electricity costs= $21.716
  2. Electricity costs= $5,084.31 + ($4.11 * machine-hours)
  3. Electricity cost = $584 + (4.62 * machine-hours)
  4. Electricity costs = $5.40 * Machine-hours

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

1. What is meant by the term quality? Why is it so important?

Answered: 1 week ago