Question

In: Accounting

Profit Center Responsibility Reporting A-One Freight Inc. has three regional divisions organized as profit centers. The...

Profit Center Responsibility Reporting

A-One Freight Inc. has three regional divisions organized as profit centers. The chief executive officer (CEO) evaluates divisional performance using operating income as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31, 20Y3.

Revenues—Air Division $ 1,290,700
Revenues—Rail Division 1,562,500
Revenues—Truck Division 2,729,100
Operating Expenses—Air Division 817,900
Operating Expenses—Rail Division 929,900
Operating Expenses—Truck Division 1,650,400
Corporate Expenses—Shareholder Relations 196,300
Corporate Expenses—Customer Support 665,000
Corporate Expenses—Legal 294,000
General Corporate Officers’ Salaries 433,500

The company operates three service departments: Shareholder Relations, Customer Support, and Legal. The Shareholder Relations Department conducts a variety of services for shareholders of the company. The Customer Support Department is the company’s point of contact for new service, complaints, and requests for repair. The department believes that the number of customer contacts is an activity base for this work. The Legal Department provides legal services for division management. The department believes that the number of hours billed is an activity base for this work. The following additional information has been gathered:

   Air    Rail    Truck
Number of customer contacts 4,800 5,700 8,500
Number of hours billed 1,200 2,000 1,700

Division management does not control activities related to the shareholder relations department and general corporate officers’ salaries.

Required:

a. Prepare quarterly income statements showing operating income for the three divisions. Use three column headings: Air, Rail, and Truck.

A-One Freight Inc.
Divisional Income Statements
For the Quarter Ended December 31, 20Y3
Air Rail Truck
Revenues $ $ $
Operating expenses
Operating income before service department charges $ $ $
Less service department charges:
Customer support $ $ $
Legal
Total service department charges $ $ $
Operating income $ $ $

b. What is the profit margin percentage of each division? Round to one decimal place.

Division Profit Margin
Air Division %
Rail Division %
Truck Division %

Identify the most successful division according to the profit margin percentage.
Truck

3. All of the following statements are true regarding the evaluation of divisional performance for A-1 except:

A better measure for A-1 Freight than the amount of operating income per dollar of earned revenue would be either rate of return on investment or residual income, because both measures incorporate asset utilization into the measures.

A better measure for A-1 Freight than the amount of operating income per dollar of earned revenue would be either rate of return on investment or residual income, because the amount of assets used by a division in earning a return is a very important consideration in evaluating divisional performance.

A better measure for A-1 Freight than the amount of operating income per dollar of earned revenue would be either rate of return on investment or residual income, because this company requires a significant investment in fixed assets and distribution facilities.

All of these choices are correct.

Select the correct answer from the choices above.:
d

Solutions

Expert Solution

Answer a)
Air Rail Truck
i Revenues 1,290,700 1,562,500 2,729,100
ii Operating expenses 817,900 929,900 1,650,400
iii=i-ii Operating income before service department charges 472,800 632,600 1,078,700
Less service department charges:
iv Customer support 168000 199500 297500
v Legal 72000 120000 102000
vi=iv+v Total service department charges 240000 319500 399500
vii=iii-vi Operating income 232,800 313,100 679,200
* refer below allocation over head table
Allocation of overhead expenses Air Rail Truck Total
i Number of customer contacts 4,800 5,700 8,500 19,000
ii Number of hours billed 1,200 2,000 1,700 4,900
iii Corporate Expenses—Customer Support = i* 35 168000 199500 297500 665000
iv Corporate Expenses—Legal=ii*60 72000 120000 102000 294000
Note - 1
Corporate Expenses—Customer Support 665,000
Total number of customer contacts 19,000
Overhead rate / Customer contracts 35.00
Note - 2
Corporate Expenses—Legal 294,000
Total number of hours billed 4,900
Overhead rate / per hours billed 60.00
Corporate Expenses—Shareholder Relations
Corporate Expenses—Customer Support
Corporate Expenses—Legal
General Corporate Officers’ Salaries
Answer b) Air Rail Truck
Revenues 1,290,700 1,562,500 2,729,100
Operating income 232800 313100 679200
Profit margin 18.04% 20.04% 24.89%
Truck is most profitable segment of the company as it has highest profit margin
Answer 3)
All the options are correct. Hence correct answer is d. Return on asset and residual income will provide full entity level profitability view.

Related Solutions

Profit Center Responsibility Reporting A-One Freight Inc. has three regional divisions organized as profit centers. The...
Profit Center Responsibility Reporting A-One Freight Inc. has three regional divisions organized as profit centers. The chief executive officer (CEO) evaluates divisional performance using operating income as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31, 20Y3. Revenues—Air Division $ 1,104,600 Revenues—Rail Division 1,295,000 Revenues—Truck Division 2,401,200 Operating Expenses—Air Division 700,000 Operating Expenses—Rail Division 770,700 Operating Expenses—Truck Division 1,452,100 Corporate Expenses—Shareholder Relations 168,000 Corporate Expenses—Customer Support 613,800 Corporate...
Profit center responsibility reporting for a service company Red Line Railroad Inc. has three regional divisions...
Profit center responsibility reporting for a service company Red Line Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer (CEO) evaluates divisional performance, using operating income as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31: Revenues—East $1,400,000 Revenues—West 2,000,000 Revenues—Central 3,200,000 Operating Expenses—East 800,000 Operating Expenses—West 1,350,000 Operating Expenses—Central 1,900,000 Corporate Expenses—Shareholder Relations 300,000 Corporate Expenses—Customer Support 320,000 Corporate Expenses—Legal 500,000 General...
Red Line Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer...
Red Line 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 income and expense accounts were provided from the trial balance as of December 31: Revenues—East $ 862,000 Revenues—West 1,036,000 Revenues—Central 1,890,000 Operating Expenses—East 563,600 Operating Expenses—West 621,840 Operating Expenses—Central 1,167,900 Corporate Expenses—Shareholder Relations 150,000 Corporate Expenses—Customer Support 360,000 Corporate Expenses—Legal 252,000 General Corporate Officers’ Salaries 274,500 The company...
Traxonia Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer (CEO)...
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 income and expense accounts were provided from the trial balance as of December 31, 2016: Revenues—East $ 866,000 Revenues—West 1,030,000 Revenues—Central 1,890,000 Operating Expenses—East 565,700 Operating Expenses—West 627,360 Operating Expenses—Central 1,170,060 Corporate Expenses—Shareholder Relations 156,000 Corporate Expenses—Customer Support 320,000 Corporate Expenses—Legal 255,200 General Corporate Officers’ Salaries 273,500 The company...
Red Line Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer...
Red Line 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 income and expense accounts were provided from the trial balance as of December 31: Revenues—East $878,000 Revenues—West 1,042,000 Revenues—Central 1,880,000 Operating Expenses—East 563,600 Operating Expenses—West 619,680 Operating Expenses—Central 1,172,940 Corporate Expenses—Shareholder Relations 155,000 Corporate Expenses—Customer Support 333,000 Corporate Expenses—Legal 233,100 General Corporate Officers’ Salaries 278,500 The company operates...
Red Line Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer...
Red Line 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 income and expense accounts were provided from the trial balance as of December 31: Revenues—East $ 878,000 Revenues—West 1,042,000 Revenues—Central 1,880,000 Operating Expenses—East 563,600 Operating Expenses—West 619,680 Operating Expenses—Central 1,172,940 Corporate Expenses—Shareholder Relations 155,000 Corporate Expenses—Customer Support 333,000 Corporate Expenses—Legal 233,100 General Corporate Officers’ Salaries 278,500 The company...
Red Line Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer...
Red Line 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 income and expense accounts were provided from the trial balance as of December 31: 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...
Red Line Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer...
Red Line 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 income and expense accounts were provided from the trial balance as of December 31: Revenues—East $884,000 Revenues—West 1,050,000 Revenues—Central 1,870,000 Operating Expenses—East 568,100 Operating Expenses—West 623,520 Operating Expenses—Central 1,170,540 Corporate Expenses—Shareholder Relations 157,000 Corporate Expenses—Customer Support 407,000 Corporate Expenses—Legal 261,000 General Corporate Officers’ Salaries 270,750 The company operates...
Red Line Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer...
Red Line 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 income and expense accounts were provided from the trial balance as of December 31: Revenues—East $ 890,000 Revenues—West 1,046,000 Revenues—Central 1,880,000 Operating Expenses—East 563,900 Operating Expenses—West 625,920 Operating Expenses—Central 1,167,540 Corporate Expenses—Shareholder Relations 159,000 Corporate Expenses—Customer Support 314,500 Corporate Expenses—Legal 271,200 General Corporate Officers’ Salaries 277,750 The company...
Traxonia Railroad Inc. has three regional divisions organized as profit centers. The chief executive officer (CEO)...
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 income and expense accounts were provided from the trial balance as of December 31, 2016: Revenues—East $ 878,000 Revenues—West 1,042,000 Revenues—Central 1,880,000 Operating Expenses—East 563,600 Operating Expenses—West 619,680 Operating Expenses—Central 1,172,940 Corporate Expenses—Shareholder Relations 155,000 Corporate Expenses—Customer Support 333,000 Corporate Expenses—Legal 233,100 General Corporate Officers’ Salaries 278,500 The company...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT