Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,403 356
August 82,104 78
September 226,182 1,436
October 215,983 1,083
November 257,945 1,301
December 185,180 1,160
January 219,779 1,376
February 245,037 1,374
March 209,374 1,173
April 191,890 1,096
May 249,512 1,333
June 170,949 492
July 128,387 410
Total $ 2,511,725 12,668
Average 193,210 974

The controller's office has analyzed the data and has given you the results from the regression analysis:

Regression Statistics
Multiple R 0.9376894
R Square 0.879261369
Adjusted R Square 0.868285130
Standard Error 19,261.05018
Observations 13

Anova
df SS MS F Significance F
Regression 1 29,718,326,965 29,718,326,965 80.1058865 2.21306E-06
Residual 11 4,080,868,597 370,988,054.2
Total 12 33,799,195,561

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper
Intercept 89,167.71850 12,793.26545 6.96989513 2.36066E-05 61,009.93112 117,325.5059 61,009.93112 117,325.5059
X Variable 1 106.7686027 11.92920066 8.950189188 2.21306E-06 80.51260914 133.024596 80.51260914 133.024596

If the controller uses the high-low method to estimate costs, the cost equation for administrative salaries is:

Cost = $203.62 Credit-hours.

Cost = $73,822.40 + $106.10 Credit-hours.

Cost = $193,210.00 + $157.51 Credit-hours.

Cost = $193,210.

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

Accounting Information Systems

Authors: Steven M. Bragg

2nd Edition

164221079X, 9781642210798

More Books

Students also viewed these Accounting questions

Question

Video Camera Operator - A video recording shall be made for:

Answered: 1 week ago

Question

Compare and contrast long-term and short-term orientation cultures

Answered: 1 week ago

Question

Discuss the research behind the notion of a pancultural self

Answered: 1 week ago