Answered step by step
Verified Expert Solution
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 Costs Credit Hours Month September October November December January February March April May June 129,981 82,951 225,191 216,403 258,420 184,085 219,668 245,626 209,152 191,678 249.807 170,125 128,168 368 363 1,366 1,144 1,446 1.145 1,388 1.432 1,041 1,266 1,404 541 315 $2,511,255 193,173 Tota 3,219 1,017 Average The controller's office has analyzed the data and has given you the results from the regression analysis Regresslon Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.9230863 0.852088274 0.838641753 21,294.15192 13 Anova df MS Significance F Regresslon Residul Total 128,733,952,140 28,733,95214063.3686810 6.84723E-06 11 4,987849.967453,440,906.1 12 33,721,802,10 Coefficlents Standard Erro t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 5.46968612 0.000194949 49,346.72340 115,802.1179 49,346.72340 115,802.1179 X Varlable 1108.7667397 13.66339982 79604447756.84723E-06 78.69379946138.839680 78.69379946 138.839680 Intercept ,574.42064 15.096.73843 If the controller uses the high-low method to estimate costs, the cost equation for administrative salaries is: Cost-$219.53% Credit-hours. O Cost $91,884.18 $115.17 x Credit-hours O Cost $193173.00 $178.71 x Credit-hours O Cost $193,173
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