Question
The Business School at Eastern College is accumulating data as a first step in the preparation of next year's budget development. One cost that is
The Business School at Eastern 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:
Administrative | Credit | ||
Month | Costs | Hours | |
July | $ 128,672 | 343 | |
August | 83,140 | 235 | |
September | 225,855 | 1,477 | |
October | 216,543 | 1,083 | |
November | 258,237 | 1,372 | |
December | 185,224 | 1,333 | |
January | 219,845 | 1,409 | |
February | 245,243 | 1,327 | |
March | 210,420 | 1,134 | |
April | 192,452 | 1,250 | |
May | 249,490 | 1,554 | |
June | 170,707 | 548 | |
July | 127,547 | 357 | |
Total | $ 2,513,375 | 13,422 | |
Average | 193,337 | 1,032 |
The controller's office has analyzed the data and has given you the results from the regression analysis:
Regression Statistics | |
Multiple R | 0.9119494 |
R Square | 0.831651720 |
Adjusted R Square | 0.816347331 |
Standard Error | 22,771.48892 |
Observations | 13 |
Anova |
df | SS | MS | F | Significance F | |
Regression | 1 | 28,177,882,197 | 28,177,882,197 | 54.3407331 | 1.40932E-05 |
Residual | 11 | 5,703,947,786 | 518,540,707.9 | ||
Total | 12 | 33,881,829,983 |
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper | |
Intercept | 89,132.11103 | 15,482.61540 | 5.75691566 | 0.000127072 | 55,055.10432 | 123,209.1177 | 55,055.10432 | 123,209.1177 |
X Variable 1 | 100.9281446 | 13.69145310 | 7.371616721 | 1.40932E-05 | 70.79345952 | 131.062830 | 70.79345952 | 131.062830 |
If the controller uses the high-low method to estimate costs, the variable cost per credit hour is: (Round your answer to 2 decimal places.)
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