Question
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
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:
RevenuesEast | $ 862,000 |
RevenuesWest | 1,036,000 |
RevenuesCentral | 1,890,000 |
Operating ExpensesEast | 563,600 |
Operating ExpensesWest | 621,840 |
Operating ExpensesCentral | 1,167,900 |
Corporate ExpensesShareholder Relations | 150,000 |
Corporate ExpensesCustomer Support | 360,000 |
Corporate ExpensesLegal | 252,000 |
General Corporate Officers Salaries | 274,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 companys 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:
East | West | Central | |
Number of customer contacts | 5,000 | 6,000 | 9,000 |
Number of hours billed | 1,400 | 2,000 | 2,200 |
Required: | |
1. | Prepare quarterly income statements showing income from operations for the three divisions. Use three column headings: East, West, and Central. |
2. | Identify the most successful division according to the profit margin. Enter percentage rounded two decimal places (e.g. 0.22547 is 22.55%). |
3. | What would you include in a recommendation to the CEO for a better method for evaluating the performance of the divisions? What is a major weakness of the present method? |
Quarterly Income Statements
1. Prepare quarterly income statements showing income from operations for the three divisions. Use three column headings: East, West, and Central.
Red Line Railroad Inc. |
Divisional Income Statements |
For the Quarter Ended December 31 |
1 |
| East | West | Central |
2 | Revenues |
|
|
|
3 | Operating expenses |
|
|
|
4 | Income from operations before service department charges |
|
|
|
5 | Service department charges: |
|
|
|
6 | Customer Support |
|
|
|
7 | Legal |
|
|
|
8 | Total service department charges |
|
|
|
9 | Income from operations |
|
|
|
2. Compute the profit margin for each division. Enter percentage rounded two decimal places (e.g. .22547 is 22.55%).
Division | Profit Margin |
East Division | % |
West Division | % |
Central Division | % |
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