The College of Business at Northeast College is accumulating…
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,451 400 August 82,733 193 September 225,670 1,470 October 216,454 1,078 November 258,293 1,387 December 184,599 1,190 January 219,257 1,417 February 245,090 1,451 March 209,522 1,142 April 191,955 1,201 May 250,128 1,438 June 170,538 498 July 128,257 393 Total $ 2,511,947 13,258 Average $ 193,227 1,020 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.9327181 R Square 0.869963033 Adjusted R Square 0.858141490 Standard Error 19,984.60564 Observations 13 ANOVA df SS MS F Significance F Regression 1 29,391,233,739 29,391,233,739 -73.5913299 3.34292E-06 Residual 11 4,393,229,090 399,384,462.7 Total 12 33,784,462,829 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 86,208.30382 13,651.03481 6.31514790 5.71542E-05 56,162.57879 116,254.0288 56,162.57879 116,254.0288 X Variable 1 104.9358161 12.23236465 8.578538912 3.34292E-06 78.01256307 131.859069 78.01256307 131.859069 If the controller uses regression analysis to estimate costs, what is the estimate of the fixed portion of administrative costs?
Read DetailsCase (A) Case (B) Case (C) Beginning Balance (BB) $ 36,52…
Case (A) Case (B) Case (C) Beginning Balance (BB) $ 36,520 $ 15,100 $ 5,600 Ending Balance (EB) ? 11,400 12,200 Transferred In (TI) 166,200 ? 68,400 Transferred Out (TO) 164,400 93,200 ? For Case (C) above, what is the Transferred-Out (TO)?
Read DetailsThe Tire Division of Traker Company produces tires for off-r…
The Tire Division of Traker Company produces tires for off-road sport vehicles. One-third of Tire’s output is sold to an internal division of Traker; the remainder is sold to outside customers. Tire’s estimated operating profit for the year is: Internal Outside Sales $ 434,700 $ 1,159,200 Variable costs 289,800 579,600 Fixed costs 86,940 173,880 Operating profits $ 57,960 $ 405,720 Unit sales 12,600 25,200 The internal division has an opportunity to purchase 12,600 tires of the same quality from an outside supplier on a continuing basis. The Tire Division cannot sell any additional products to outside customers. What is the maximum selling price that Tire should be willing to pay an outside supplier?
Read Details