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 | $ 129,180 | 256 | |
August | 82,488 | 392 | |
September | 226,053 | 1,366 | |
October | 216,912 | 1,127 | |
November | 257,638 | 1,430 | |
December | 185,236 | 1,248 | |
January | 219,744 | 1,343 | |
February | 244,474 | 1,533 | |
March | 209,896 | 1,021 | |
April | 192,248 | 1,052 | |
May | 249,584 | 1,486 | |
June | 170,609 | 348 | |
July | 128,560 | 304 | |
Total | $ 2,512,622 | 12,906 | |
Average | 193,279 | 993 |
The controller's office has analyzed the data and has given you the results from the regression analysis:
Regression Statistics | |
Multiple R | 0.8991096 |
R Square | 0.808398062 |
Adjusted R Square | 0.790979704 |
Standard Error | 24,225.89655 |
Observations | 13 |
Anova |
df | SS | MS | F | Significance F | |
Regression | 1 | 27,238,160,063 | 27,238,160,063 | 46.4106928 | 2.90496E-05 |
Residual | 11 | 6,455,834,698 | 586,894,063.5 | ||
Total | 12 | 33,693,994,761 |
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper | |
Intercept | 96,556.47873 | 15,707.30165 | 6.14723527 | 7.23566E-05 | 61,984.94091 | 131,128.0166 | 61,984.94091 | 131,128.0166 |
X Variable 1 | 97.4266060 | 14.30107051 | 6.812539377 | 2.90496E-05 | 65.95016202 | 128.903050 | 65.95016202 | 128.903050 |
If the controller uses the high-low method to estimate costs, the cost equation for administrative salaries is:
-
Cost = $106,059.43 + $90.29 Credit-hours.
-
Cost = $193,279.
-
Cost = $193,279.00 + $159.47 Credit-hours.
-
Cost = $208.86 Credit-hours.
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