Answered step by step
Verified Expert Solution
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 $
February
March
April
May
June
July
August
September
October
November
December
Summary Output
Regression Statistics
Multiple R
R Square
Adjusted R
Standard Error
Observations
Coefficients Standard Error t Stat Pvalue Lower Upper
Intercept
Machine Hours
If the controller uses the highlow method to estimate costs, the fixed cost portion of the cost equation for 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