Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that

The College of Business at 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 Administrative Costs Credit Hours
July $ 129,351 300
August 82,653 141
September 225,610 1,418
October 216,414 1,026
November 258,273 1,335
December 184,499 1,138
January 219,177 1,365
February 245,030 1,399
March 209,482 1,090
April 191,935 1,149
May 250,028 1,386
June 170,458 446
July 128,197 341
Total $ 2,511,107 12,534
Average $ 193,162 964

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.9321989
R Square 0.868994839
Adjusted R Square 0.857085279
Standard Error 20,062.49314
Observations 13

ANOVA
df SS MS F Significance F
Regression 1 29,369,143,334 29,369,143,334 -72.9661575 3.48374E-06
Residual 11 4,427,539,941 402,503,631.0
Total 12 33,796,683,275

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Intercept 93,173.64480 12,960.70790 7.18893177 1.77759E-05 64,647.31905 121,699.9705 64,647.31905 121,699.9705
X Variable 1 103.7058894 12.14067077 8.542023033 3.48374E-06 76.98445319 130.427326 76.98445319 130.427326

If the controller uses regression analysis to estimate costs, the estimate of the variable portion of administrative costs is:

  • Variable Costs = $9.29 Credit hours.

  • Variable Costs = $1.53 Credit hours.

  • Variable Costs = $103.71 Credit hours.

  • Variable Costs = $12.65 Credit hours.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions