Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

see attached 6 Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis

image text in transcribed

see attached

image text in transcribedimage text in transcribed
6 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: Machine Electricity Skipped Month Hours Costs January 2, 400 $19, 150 February 2, 800 $22, 500 March 1, 800 $14, 250 April 3, 000 $24, 500 May 3, 700 $29, 000 June 3, 200 $23, 500 July 4, 000 $25, 500 August 3, 400 $23, 500 September 1, 900 $17 , 000 October 3, 600 $27 , 500 November 4, 600 $32, 500 December 4, 100 $28, 5006 Summary Output Regression Statistics Multiple R 0.957 0 . 915 Skipped R Square Adjusted R2 0. 907 Standard Error 1, 600 .66 observations 12 .00 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 5, 472 . 38 1, 836.37 2.98 0 . 01 1, 380. 70 9, 564. 07 Machine Hours 5.76 0 . 55 10 .40 0.00 4.52 6. 99 If the controller uses the high-low method to estimate costs, the variable cost per machine hour is

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions

Question

What are the benefits of using positive self-talk? (p. 151)

Answered: 1 week ago