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