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 July August September October November December January February March April May June July Total Average Administrative Costs $ 129,901 83,093 225, 940 216,634 258,383 185,049 219,617 245,360 209,702 192,045 250,578 170,898 128,527 $2,515,727 $ 193,517 Credit Hours 850 427 1,704 1,312 1,621 1,424 1,651 1,685 1,376 1,435 1,672 732 627 16,516 1,270 The controller's office has analyzed the data and has given you the results from the regression analysis 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 9268636 R Square 0 859076100 Adjusted R Square 0 846264837 Standard Error 20,787 50165 Observations 13 ANOVA F Significance F 5 22932E 06 Regression 67 0563129 df L 1 11 12 SS MS 28,976,388,996 28,976,388,996 4,753,322,471 432,120,224 7 33,729,711,467 Residual Total Coefficients Standard Errort Stat P value Lower 95 Upper 95 Lower Intercept 55,194 23940 17,848 58666 3 09235910 0 010242851 15,909 76503 94,478 7138 15,909 X Variable i 108 8763555 13 29577754 8 188791907 5 22932E 06 79 61254647 138 140165 79 612 If the controller uses regression analysis to estimate costs, the estimate of the fixed portion of administrative costs is Multiple Choice o Fixed Cost $55,194 24 o Fixed Cost $20,598 80 o Fixed Cost $109 39 o Fixed Cost $17,729 85

Question

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 July August September October November December January February March April May June July Total Average Administrative Costs $ 129,901 83,093 225, 940 216,634 258,383 185,049 219,617 245,360 209,702 192,045 250,578 170,898 128,527 $2,515,727 $ 193,517 Credit Hours 850 427 1,704 1,312 1,621 1,424 1,651 1,685 1,376 1,435 1,672 732 627 16,516 1,270 The controller's office has analyzed the data and has given you the results from the regression analysis  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 9268636 R Square 0 859076100 Adjusted R Square 0 846264837 Standard Error 20,787 50165 Observations 13 ANOVA F Significance F 5 22932E 06 Regression  67 0563129 df L 1 11 12 SS MS 28,976,388,996 28,976,388,996 4,753,322,471 432,120,224 7 33,729,711,467 Residual Total Coefficients Standard Errort Stat   P value Lower 95  Upper 95  Lower Intercept 55,194 23940 17,848 58666 3 09235910 0 010242851 15,909 76503 94,478 7138 15,909  X Variable i 108 8763555 13 29577754 8 188791907 5 22932E 06 79 61254647 138 140165 79 612 If the controller uses regression analysis to estimate costs, the estimate of the fixed portion of administrative costs is  Multiple Choice o Fixed Cost   $55,194 24  o Fixed Cost   $20,598 80  o Fixed Cost   $109 39  o Fixed Cost   $17,729 85

Accepted Answer

The Answer is in the image, click to view ...

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

Step by Step Solution

Step: 1

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Students explore these related Accounting questions