Please give positive ratings so I can keep answering. It would help me a lot. Thanks! |
Red Line Railroad Inc. | ||||||||||||
Calculation of activity based overhead rates |
|
|||||||||||
A | B | C | D | E=B+C+D | F=A/E | |||||||
Estimated use of Cost Drivers | ||||||||||||
Activity | Cost Driver | Amount $ | East | West | Central | Total | ABC Rates | |||||
Customer Support Expenses | No. of customer contacts | 320,000.00 | 5,000.00 | 6,000.00 | 9,000.00 | 20,000.00 | 16.00 | |||||
Legal Expenses | No. of hours billed | 255,200.00 | 1,100.00 | 2,060.00 | 2,640.00 | 5,800.00 | 44.00 | |||||
Total Activity Cost | 575,200.00 | |||||||||||
See F | See B | G=F*B | See C | H=F*C | See D | I=F*D | ||||||
Allocation table | East | West | Central | |||||||||
Activity | ABC Rates | Cost Drivers | Cost assigned | Cost Drivers | Cost assigned | Cost Drivers | Cost assigned | |||||
Customer Support Expenses | 16.00 | 5,000.00 | 80,000.00 | 6,000.00 | 96,000.00 | 9,000.00 | 144,000.00 | |||||
Legal Expenses | 44.00 | 1,100.00 | 48,400.00 | 2,060.00 | 90,640.00 | 2,640.00 | 116,160.00 | |||||
Total Cost assigned | 128,400.00 | 186,640.00 | 260,160.00 | |||||||||
Answer 1 | ||||||||||||
Income Statement | East | West | Central | |||||||||
Revenues | 866,000.00 | 1,030,000.00 | 1,890,000.00 | J | ||||||||
Operating Expenses | 565,700.00 | 627,360.00 | 1,170,060.00 | |||||||||
Income from operations before service dept. charges | 300,300.00 | 402,640.00 | 719,940.00 | |||||||||
Less- Service dept. charges | ||||||||||||
Customer Support | 80,000.00 | 96,000.00 | 144,000.00 | |||||||||
Legal | 48,400.00 | 90,640.00 | 116,160.00 | |||||||||
Income from operations | 171,900.00 | 216,000.00 | 459,780.00 | K | ||||||||
Answer 2 | ||||||||||||
Profit margin | 19.85% | 20.97% | 24.33% | L=K/J | ||||||||
The most successful division according to profit margin is Central Division. | ||||||||||||
Answer 3 | ||||||||||||
The assets invested in each division are not considered. | ||||||||||||
Answer 4 | ||||||||||||
Considering residual income | ||||||||||||
Computing rate of return on investment. | ||||||||||||
s Redline Renter CEO ate ne performanc flowing quarterly come and e or presten The o ficer from apro...
Traxonia Rairoad inc. has three regional divisions organized as proft centers. The chief executive officer (CEO) evaluates divisional performance using income from operations as a percent of revenues. The following quarterly income and expense accounts were provided from the balance as of December 31, 2016 Revenues-East Revenues West Revenues Central Operating Expenses-East Operating Expenses-West Operating Expenses-Central Corporate Expenses-Shareholder Relations Corporate Expenses-Customer Support Corporate Expenses -Legal General Corporate Officers Salaries $ 862.000 1,036.000 1,890,000 563.500 621.840 1,167.900 150,000 360,000 252,000 274,500...
Instructions Traxonia Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer (CEO) evaluates divisional performance, using income from operations as a percent of revenues. The following quarterly inoome and expense accounts were provided from the trial balance as of December 31, 2016: Revenues-East $870,000 Revenues-West 1,034,000 Revenues-Central 1,880,000 Operating Expenses-East 565,700 Operating Expenses-West 621,360 Operating Expenses-Central 1,174,660 Corporate Expenses-Shareholder Relations 150,000 Corporate Expenses-Customer Support 350,000 Corporate Expenses-Legal 264:000 General Corporate Officers' Salaries 281,000 The company...
Obj.3 tive officer o Sorganized as profit centers. The chief execu- operating income as a percent of ise accounts were provided from the 4-2 Profit center responsibility reporting One Freight Inc. has three regional divisions organized as profit centers. The officer (CEO) evaluates divisional performance using operating income wes. The following quarterly income and expense accounts were al balance as of December 31, 20Y3. Revenues-Air Division $5,000,000 Revenues-Rail Division Revenues-Truck Division 9,000,000 Operating Expenses-Air Division 4,100,000 Operating Expenses-Rail Division 4,900,000...
Divisional Income Statements with Service Department Charges Yamba Tachogy has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and Purchasing. The corporate expenses for the year ended December 31, 2017, are as follows $516,000 Tech Support Department Purchasing Department 89,500 SEO,000 Other corporate administrative expenses Total corporate expense $1,165,500 The other corporate administrative expenses include offens es and other expenses roured by the corporation. The Tech Support Department changes the division for services rendered, based on...
Profit Center Responsibility Reporting for a Service Company Thomas Railroad Company organizes its three divisions, the North (N), South (S), and West (W) regions, as profit centers. The chief executive officer (CEO) evaluates divisional performance, using income from operations as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31: Revenues—N Region $988,000 Revenues—S Region 1,171,800 Revenues—W Region 2,089,500 Operating Expenses—N Region 626,100 Operating Expenses—S Region 697,400 Operating Expenses—W...
Profit Center Responsibility Reporting for a Service Company Thomas Railroad Company organizes its three divisions, the North (N), South (S), and West (W) regions, as profit centers. The chief executive officer (CEO) evaluates divisional performance, using income from operations as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31: Revenues—N Region $1,163,800 Revenues—S Region 1,367,400 Revenues—W Region 2,524,700 Operating Expenses—N Region 737,500 Operating Expenses—S Region 813,800 Operating Expenses—W...
Profit Center Responsibility Reporting for a Service Company Thomas Railroad Company organizes its three divisions, the North (N), South (S), and West (W) regions, as profit centers. The chief executive officer (CEO) evaluates divisional performance, using income from operations as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31: Revenues-N Region $1,055,700 Revenues-S Region 1,248,600 Revenues-W Region 2,291,900 Operating Expenses-N Region 669,000 Operating Expenses-s Region 743,100 Operating Expenses-W...
Thomas Railroad Company organizes its three divisions, the North (N), South (S), and West (W) regions, as profit centers. The chief executive officer (CEO) evaluates divisional performance, using income from operations as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31, 2016: Revenues-N. Region $3,780,000 Revenues-S. Region $5,673,000 Revenues-W. Region $5,130,000 Operating Expenses-N. Region $2,678,500 Operating Expenses-S. Region $4,494,890 Operating Expenses-W.Region $3,770,050 Corporate Expenses-Dispatching $182,000 Corportate Expenses-Equipment Mgmt...
d to r corpo de Bosco e Boston Partners provides an department S following Click the icon to view the cost records DVT) and corporate con CORP) For the first of 2017. Boccordance the Read the regirements Budged overhead costs before department cost o s $ 300 000 200 000 $ 700.000 12.000.000 52180.000 Action AS Alocation of 70 000 $ 8.390 000 $13.510.000 $2 To bugeted v ead of operating 80.000 Requirement t o the part department cos to...
Service Department Charges In divisional income statements prepared for LeFevre Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll distributions, and the Purchasing Department costs are charged back on the basis of the number of purchase requisitions. The Payroll Department had expenses of $61,284, and the Purchasing Department had expenses of $26,840 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate...