Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The College of Business of Northeast College is accumulating data as a first step in the preparation of next year's budget development. One.cost that is
The College of Business of Northeast College is accumulating data as a first step in the preparation of next year's budget development. One.cost that is being looked at closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below Month July August September October November December January February March April May June July Total Average Administrative Costs $ 130,201 83,333 226,120 216,754 258,443 185,349 219,857 245,548 209,822 192,105 250,878 171, 138 128,707 $2,518,247 $ 193,711 Credit Hours 1,150 583 1,860 1,468 1,777 1,580 1,807 1,841 1,532 1,591 1,828 888 783 18,688 1,438 sinn analysis The controller's office has analyzed the data and has given you the results from the regression analysis: SUMMARY OUTPUT Regression Statistics Multiple R 0.9143672 R Square 0.836067442 Adjusted R Square 0.821164482 Standard Error 22,408.29810 Observations 13 ANOVA F Significance F 1.21499E-5 -56.1007647 Regression Residual Total df 1 11 12 SS MS 28, 169,979,268 28,169,979,268 5,523,450,060 502,131,823.7 33,693,429,329 Intercept X Variable 1 Coefficients Standard Error 36,068.11092 21,945.45609 109.6618984 14.64102120 t Stat 1.64353435 7.490044370 P-value Lower 95% Upper 95% Lower 95.0% Upper 95.ex 0.128521004 -12,233.51226 84,369.7341 -12,233.51226 84,369.7341 1.21499E-05 77.43722804 141.886569 77.43722804 141.886569 If the controller uses the high-low method to estimate costs, the variable cost per credit hour is: Residual Total 12 33,693,429,329 Intercept X Variable 1 Coefficients Standard Error 36,068.11092 21,945.45609 109.6618984 14.64102120 t Stat 1.64353435 7.490044370 p-value Lower 95% Upper 95% Lower 95.ex Upper 95.ex 0.128521004 -12,233.51226 84,369.7341 -12,233.51226 84,369.7341 1.21499E-05 77.43722804 141.886569 77.43722884 141.886569 If the controller uses the high-low method to estimate costs, the variable cost per credit hour is: Multiple Choice $111 81 O $10341 5103 41 $ 82.18 $8218 O C $20092
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