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.
East West Central
Revenues
Operating expenses
Income from operations before service dept. charges
Less service department charges:
Customer support
Legal
Total
Income from operations
Supporting schedules:
East West Central Total
Number of customer contacts
Number of hours billed
Service Cost Output = Rate
Customer contact rate per contact
Legal billing rate per hour
2.
Profit margin: Income from Profit
Operations Revenues = Margin
East Division
West Division
Central Division
Based on profit margin, the Division 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.
East West Central
Revenues 870,000$ 1,032,000$ 1,872,000$
2.
Profit margin: Income from Profit
Operations Revenues = Margin
East Division $139,200 $870,000 16%
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.