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,605

281

August

82,159

52

September

226,012

1,424

October

216,192

960

November

258,364

1,361

December

184,829

1,119

January

218,798

1,374

February

244,962

1,365

March

209,739

1,092

April

192,109

1,076

May

250,123

1,420

June

170,073

355

July

128,483

269

Total

$ 2,511,448

12,148

Average

193,188

934

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

Regression Statistics

Multiple R

0.9337190

R Square

0.871831217

Adjusted R Square

0.860179510

Standard Error

19,865.27215

Observations

13

Anova

df

SS

MS

F

Significance F

Regression

1

29,527,853,657

29,527,853,657

74.8243308

3.08442E-06

Residual

11

4,340,919,414

394,629,037.6

Total

12

33,868,773,071

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Lower 95.0%

Upper

Intercept

101,985.17690

11,896.35558

8.57280838

3.36461E-06

75,801.47477

128,168.8789

75,801.47477

128,168.8789

X Variable 1

97.5996626

11.28305995

8.650105826

3.08442E-06

72.76581509

122.433510

72.76581509

122.433510

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

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

Computer Accounting

Authors: Donna Kay

15th Edition

0077826841, 9780077826840

More Books

Students also viewed these Accounting questions