Question: A firm wanted to determine the relationship between its monthly operating costs and a potential cost driver, machine hours. The output of a regression analysis

A firm wanted to determine the relationship between its monthly operating costs and a potential cost driver, machine hours. The output of a regression analysis performed using Excel 2007 showed the following information:

A firm wanted to determine the relationship between its monthly

1. Given this output, write the firm€™s monthly cost equation.
2. Should management use this equation to predict monthly operating costs? Explain your answer.

SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.87 0.86 0.84 398.49 ANOVA df MS F 14.89886 Significance F 0.0032 Regressiorn Residual Tota 2365870.5 2365871 158795 1587954.5 3953825 Lower Upper 95% Lower Upper 95.0% 95.0% Coefficients 9942.83 0.89 Standard Error 406.44 0.23 t Stat 24.46 3.86 p-value 2.97 0.00 95% Intercept X Variable 1 9037.23 10848.43 9037.23 10848.43 1.40 0.37 1.40 0.37

Step by Step Solution

3.41 Rating (176 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a y 089x 994283 Where x volume of activity of the potential cost driver b Management probabl... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

444-B-M-A-C-B (1024).docx

120 KBs Word File

Students Have Also Explored These Related Managerial Accounting Questions!