In: Accounting
Problem 10-57 (Algo) Activity-Based Reporting: Service Organization (LO 10-3, 4)
Allcott Computer
Services (ACS) provides computer training and repair services for
schools and local businesses. Sales for year 1 totaled $3,000,000.
Information regarding resources for the year includes the
following.
Resources Used | Resources Supplied | |||||
Marketing | $ | 217,000 | $ | 236,000 | ||
Depreciation | 172,000 | 179,000 | ||||
Training personnel | 89,000 | 106,000 | ||||
Energy | 161,000 | 174,000 | ||||
Short-term labor | 410,000 | 610,000 | ||||
Long-term labor | 830,000 | 850,000 | ||||
Administrative | 143,000 | 160,000 | ||||
In addition, ACS spent $86,000 on 480 repair verifications with a cost driver rate of $150.
Required:
Management has requested that you do the following:
a. Prepare a traditional income statement.
b. Prepare an activity-based income statement.
Allcott Computer Services (ACS) | ||||
Traditional Income statement for the year | ||||
Particulars | In USD | Remarks | ||
A | Sales | 30,00,000 | Given | |
Less: | ||||
Marketing | 2,36,000 | Traditional costing works on the principal of recording the actual costs incurred. | ||
Depreciation | 1,79,000 | |||
Training personnel | 1,06,000 | |||
Energy | 1,74,000 | |||
Short-term labor | 6,10,000 | |||
Long-term labor | 8,50,000 | |||
Administrative | 1,60,000 | |||
Reapir Verifications | 86,000 | |||
B | Total Costs | 24,01,000 | ||
A-B | Profit | 5,99,000 | ||
Allcott Computer Services (ACS) | ||||
Activity based Income statement for the year | ||||
Activity based costing is a type of absorbtion costing wherein indirect costs are allocated after creating cost pools and allocating the costs based on cost drivers. | ||||
Particulars | In USD | Remarks | ||
A | Sales | 30,00,000 | Given | |
Less: | ||||
Marketing | 2,17,000 | |||
Depreciation | 1,72,000 | |||
Training personnel | 89,000 | |||
Energy | 1,61,000 | |||
Short-term labor | 4,10,000 | |||
Long-term labor | 8,30,000 | |||
Administrative | 1,43,000 | |||
Reapir Verifications | 72,000 | ( 480 repair verifications @ $150 rate) | ||
B | Total Costs | 20,94,000 | ||
A-B | Profit | 9,06,000 | ||
Note | ||||
Under practical scernios, companies record direct costs based on actual costs. | ||||
The direct expenses that are not attributable on per unit basis directly recorded on the basis of Absorption costing. (E.g factory electricty expenses) | ||||
Overheads like depreciation, salaries of marketing and administrative staff that are fixed in nature are not recorded based on absorption costs. |