Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

As a facilities supervisor, you would like to be able to estimate maintenance costs using machine hours as the cost driver. To do this, you

As a facilities supervisor, you would like to be able to estimate maintenance costs using machine hours as the cost driver. To do this, you perform a linear regression with machine hours as the independent (X) variable, and maintenance costs as the dependent (Y) variable. This results in the following output:

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.908881

R Square

0.894012

Standard Error

752.6137

Observations

28

ANOVA

df

SS

MS

F

Significance F

Regression

1

69942828

69942828

123.4807

2.26E-11

Residual

26

14727112

566427.4

Total

27

84669940

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper 95.0%

Intercept

980.635

435.8579

2.892274

0.007632

364.7019

2156.539

364.7019

2156.539

Machine Hours

17.360

1.339521

11.11219

2.26E-11

12.13158

17.63842

12.13158

17.63842

A. What percentage of the variation in maintenance costs can be explained by machine hours?

B. How much maintenance cost should we expect if a factory has zero (0) machine hours?

C. By how much should we estimate maintenance costs to increase for every one hour increase in machine hours?

Label and place your final answer for A-C.

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