Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
North South West
Revenues
Operating expenses
Income from operations before service dept. charges
Less service department charges:
Dispatching
Equipment management
Total
Income from operations
Supporting schedules:
North South West Total
Number of scheduled trains
Number of railroad cars in inventory
Service Cost Output = Rate
Dispatching rate per scheduled train
Equipment management rate per railroad car
2.
Profit margin: Income from Profit
Operations Revenues = Margin
North Region
South Region
West Region
Based on profit margin, the Region has the highest performance.
3.
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Divisional Income Statements
For the Quarter Ended December 31, 2014
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1.
North South West
Revenues 3,780,000$ 5,673,000$ 5,130,000$
2.
Profit margin: Income from Profit
Operations
North Region $756,000 $3,780,000 20%
3.
Answers are entered in the cells with gray backgrounds.
For the Quarter Ended December 31, 2014
Divisional Income Statements
Cells with non-gray backgrounds are protected and cannot be edited.