Question

In: Accounting

Problem 10-57 (Algo) Activity-Based Reporting: Service Organization (LO 10-3, 4) Allcott Computer Services (ACS) provides computer...

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.

Solutions

Expert Solution

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.

Related Solutions

Problem 10-64 (Algo) Activity-Based Reporting: Manufacturing (LO 10-4, 5) Leidenheimer Corporation manufactures small airplane propellers. Sales...
Problem 10-64 (Algo) Activity-Based Reporting: Manufacturing (LO 10-4, 5) Leidenheimer Corporation manufactures small airplane propellers. Sales for year 2 totaled $1,650,000. Information regarding resources for the month follows.       Resources Used Resources Supplied Parts management $ 59,000 $ 75,000 Energy 101,000 101,000 Quality inspections 93,000 103,000 Long-term labor 46,000 71,000 Short-term labor 37,000 52,000 Setups 144,000 220,000 Materials 320,000 320,000 Depreciation 110,000 220,000 Marketing 145,000 170,000 Customer service 25,000 44,000 Administrative 119,000 132,000 In addition, Leidenheimer spent $58,500 on 45...
Allcott Computer Services (ACS) provides computer training and repair services for schools and local businesses. Sales...
Allcott Computer Services (ACS) provides computer training and repair services for schools and local businesses. Sales for year 1 totaled $2,700,000. Information regarding resources for the year includes the following: Resources Used Resources Supplied Marketing $ 221,000 $ 235,000 Depreciation 171,000 180,000 Training personnel 90,000 106,000 Energy 159,000 173,000 Short-term labor 410,000 600,000 Long-term labor 840,000 850,000 Administrative 131,000 155,000     In addition, ACS spent $86,000 on 530 repair verifications with a cost driver rate of $150. Required: Management has...
The Superior Gardening Service provides gardening services to its clients. The company uses an activity-based costing...
The Superior Gardening Service provides gardening services to its clients. The company uses an activity-based costing system for its overhead costs. The company has provided the following data from its activity-based costing system. Activity Cost Pool   Total Cost    Total Activity Gardening $125,425 17,300 hours Job support 28,134 1,775 jobs Client support 4,530 280 clients Other     150,000 Not applicable Total   $308,089 The "Other" activity cost pool consists of the costs of idle capacity and organization-sustaining costs. One particular client, the...
PA4-4 (Algo) Selecting Cost Drivers, Assigning Costs Using Activity Rates [LO 4-1, 4-3, 4-4, 4-6] Keller...
PA4-4 (Algo) Selecting Cost Drivers, Assigning Costs Using Activity Rates [LO 4-1, 4-3, 4-4, 4-6] Keller Company makes two models of battery-operated boats, the Sandy Beach and the Rocky River. Basic production information follows: Sandy Beach Rocky River Direct materials cost per unit $ 19.70 $ 27.80 Direct labor cost per unit 13.10 18.80 Sales price per unit 83.20 106.00 Expected production per month 1,210 units 980 units Keller has monthly overhead of $11,272, which is divided into the following...
Problem 14-27 (Algo) (LO 14-3, 14-9, 14-10) The following is the current balance sheet for a...
Problem 14-27 (Algo) (LO 14-3, 14-9, 14-10) The following is the current balance sheet for a local partnership of doctors: Cash and current assets $ 44,000 Liabilities $ 46,000 Land 154,000 A, capital 26,000 Building and equipment (net) 142,000 B, capital 46,000 C, capital 96,000 D, capital 126,000 Totals $ 340,000 Totals $ 340,000 The following questions represent independent situations: E is going to invest enough money in this partnership to receive a 25 percent interest. No goodwill or bonus...
Problem 10-34 (LO 10-3, 10-4) The following account balances are for the Agee Company as of...
Problem 10-34 (LO 10-3, 10-4) The following account balances are for the Agee Company as of January 1, 2017, and December 31, 2017. All amounts are denominated in kroner (Kr). January 1, 2017 December 31, 2017 Accounts payable (24,000 ) (31,500 ) Accounts receivable 45,000 95,000 Accumulated depreciation—buildings (36,000 ) (41,000 ) Accumulated depreciation—equipment 0 (6,600 ) Bonds payable—due 2020 (55,000 ) (55,000 ) Buildings 125,000 100,500 Cash 51,000 9,600 Common stock (60,000 ) (71,000 ) Depreciation expense 0 31,000...
Problem 11-54 (Algo) Step Method with Three Service Departments (LO 11-3) Model, Inc., produces model automobiles...
Problem 11-54 (Algo) Step Method with Three Service Departments (LO 11-3) Model, Inc., produces model automobiles made from metal. It operates two production departments, Molding and Painting, and has three service departments, Administration, Accounting, and Maintenance. The accumulated costs in the three service departments were $262,000, $392,000, and $189,000, respectively. Management is concerned that the costs of its service departments are getting too high. In particular, managers would like to keep the costs of service departments under $3.50 per unit...
Integration Exercise 4 Plantwide and Departmental Overhead Allocation; Activity-Based Costing; Segmented Income Statements [LO 3-1, LO...
Integration Exercise 4 Plantwide and Departmental Overhead Allocation; Activity-Based Costing; Segmented Income Statements [LO 3-1, LO 3-2, LO 3-3, LO 3-4, LO 4-4, LO 4-5, LO 5-1, LO 5-3, LO 5-4] Koontz Company manufactures two models of industrial components—a Basic model and an Advanced Model. The company considers all of its manufacturing overhead costs to be fixed and it uses plantwide manufacturing overhead cost allocation based on direct labor-hours. Koontz’s controller prepared the segmented income statement that is shown below...
Exercise 9-44 (Algo) Activity-Based Costing versus Traditional Costing (LO 9-4, 5, 6) Doaktown Products manufactures fishing...
Exercise 9-44 (Algo) Activity-Based Costing versus Traditional Costing (LO 9-4, 5, 6) Doaktown Products manufactures fishing equipment for recreational uses. The Miramichi plant produces the company’s two versions of a special reel used for river fishing. The two models are the M-008, a basic reel, and the M-123, a new and improved version. Cost accountants at company headquarters have prepared costs for the two reels for the most recent period. The plant manager is concerned. The cost report does not...
Problem 3: Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate...
Problem 3: Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate costs for pricing and other purposes. The proprietor of the company believes that costs are driven primarily by the size of customer lawns, the size of customer garden beds, the distance to travel to customers, and the number of customers. In addition, the costs of maintaining garden beds depends on whether the beds are low maintenance beds (mainly ordinary trees and shrubs) or high...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT