Answered step by step
Verified Expert Solution
Question
1 Approved Answer
cost accounting Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared
cost accounting
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 Electricity Machine Hours Costs Month January 3,000 $18,650 February 3,400 $21,500 March 2,400 $13,750- April 3,600 $23,500 May 4,300 $28,500 June 3,800 $22,500 July 4,600 $25,000 August 4,000 $23,000 September 2,500 $16,000 October 4,200 $26,500 November 5,600 $31,500 December 5,200 $28,000 Multiple R R Square Summary Output Regression Statistics 0.952 0.906 Summary Output Regression Statistics Multiple R 0.952 R Square 0.906 Adjusted R2 0.897 Standard Error 1,676.51 Observations 12.00 Coefficients Upper 95% 8,203.90 Intercept Machine Hours Standard Error t Stat P-value Lower 95% 1.78 0.11 (925.25) 9.83 0.00 3.89 3,639.33 5.04 2,048.60 0.51 6.18 If the controller uses regression analysis to estimate costs, the estimate of the fixed portion of electricity costs is Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started