Question

In: Accounting

(ABC Costing) Curren Ltd currently uses absorption costing. The following costings have been prepared using direct...

(ABC Costing)

Curren Ltd currently uses absorption costing. The following costings have been prepared using direct labour hours as a base for recovering overhead.

Products

B421

B437

B449

B457

Direct costs

4.28

5.19

9.02

11.48

Production overheads

5.06

3.13

4.01

5.34

Production cost

9.34

8.32

13.03

16.82

Selling price

8.80

11.50

18.00

17.50

Profit/loss

(0.54)

3.18

4.97

0.68

The management are currently reviewing the cost accounting policy in relation to overheads and are considering the implementation of an activity based costing system.

The management accountant has done an activity analysis and divided the overhead cost into the following cost pools and drivers:

Cost Pools                                                                  Cost drivers

Raw material handling             €28,025           number of material requisitions

Machine set-up costs €34,400           number of set up hours

Machine related costs                €203,298         number of machine hours

Quality checks                              €70,488           number of inspections

Finishing and dispatch costs          €51,510           number of items

The following information is also available;

Products

B421

B437

B449

B457

Sales/production units

36,000

18,900

22,500

8,450

Number of units per batch

2,000

900

900

650

Material requisitions per batch

4

4

4

3

*Hours per machine set-up

4 hours

3 hours

2 hours

5 hours

Machine hours per batch

15 hours

12 hours

14 hours

17 hours

Quality tests per batch

7 tests

4 tests

5 tests

6 tests

*You can assume that the machinery is set up for each batch.

Requirement

  1. Calculate the cost and profit per unit of the four products using activity-based costing.                                                                                                                
  2. The production manager is an advocate of the introduction of ABC and has said that ‘all companies should adopt it as it will give the true cost of the products produced’.

Your CEO (not a management accountant) is not sure and has asked you to write a brief business memo where you compare the costs and profits for the four products with absorption costing giving possible reasons for the differences between both systems and critically comment on the production managers’ statement.

Solutions

Expert Solution

Computation of Activity Cost Drivers
B421 B437 B449 B457 Total
Number of material requisitions                 72                 84               100                 39                  295
Number of setup hours                 72                 63                 50                 65                  250
Number of machine hours               270               252               350               221               1,093
Number of inspections               126                 84               125                 78                  413
Number of units          36,000          18,900          22,500            8,450             85,850
Computation of Overhead Rate for each Activity
Activity Cost Pool Overhead Cost Driver Activity Overhead
Rate
Raw material handling € 28,025 Number of material requisitions               295 € 95.00
Machine set-up costs € 34,400 Number of setup hours               250 € 137.60
Machine related cost € 203,298 Number of machine hours            1,093 € 186.00
Quality checks € 70,488 Number of inspections               413 € 170.67
Finishing and dispatch costs € 51,510 Number of units          85,850 € 0.60
Curren Ltd
ABC Costing Income Statement
B421 B437 B449 B457 Total
Sales € 316,800.00 € 217,350.00 € 405,000.00 € 147,875.00 € 1,087,025.00
Direct Costs € 154,080.00 € 98,091.00 € 202,950.00 € 97,006.00 € 552,127.00
Production Overheads
Raw material handling costs € 6,840.00 € 7,980.00 € 9,500.00 € 3,705.00 € 28,025.00
Machine set-up costs € 9,907.20 € 8,668.80 € 6,880.00 € 8,944.00 € 34,400.00
Machine related cost € 50,220.00 € 46,872.00 € 65,100.00 € 41,106.00 € 203,298.00
Quality checks costs € 21,504.81 € 14,336.54 € 21,334.14 € 13,312.50 € 70,488.00
Finishing and dispatch costs € 21,600.00 € 11,340.00 € 13,500.00 € 5,070.00 € 51,510.00
Total Production Overheads € 110,072.01 € 89,197.34 € 116,314.14 € 72,137.50 € 387,721.00
Total Costs € 264,152.01 € 187,288.34 € 319,264.14 € 169,143.50 € 939,848.00
Profit € 52,647.99 € 30,061.66 € 85,735.86 (€ 21,268.50) € 147,177.00
Profit/(Loss) per unit € 1.46 € 1.59 € 3.81 (€ 2.52)
Working Notes
Computation of Activity Cost Drivers
B421 B437 B449 B457
Total Units Sold/Produced        36,000.0        18,900.0        22,500.0         8,450.0
Units per Batch         2,000.0            900.0            900.0            650.0
Number of Batches              18.0              21.0              25.0              13.0
B421 B437 B449 B457
Number of Batches            18.00            21.00            25.00            13.00
Material Requisitions per batch              4.00              4.00              4.00              3.00
Number of material requisitions            72.00            84.00          100.00            39.00
B421 B437 B449 B457
Number of Batches            18.00            21.00            25.00            13.00
Hours per machine set-up              4.00              3.00              2.00              5.00
Number of setup hours            72.00            63.00            50.00            65.00
B421 B437 B449 B457
Number of Batches            18.00            21.00            25.00            13.00
Machine hours per Batch            15.00            12.00            14.00            17.00
Number of machine hours          270.00          252.00          350.00          221.00
B421 B437 B449 B457
Number of Batches            18.00            21.00            25.00            13.00
Quality tests per Batch              7.00              4.00              5.00              6.00
Number of inspections          126.00            84.00          125.00            78.00


Related Solutions

Waymire Ltd. currently uses a traditional costing system based on direct labour hours to allocate overhead....
Waymire Ltd. currently uses a traditional costing system based on direct labour hours to allocate overhead. This year, the company has budgeted to produce 1668 units of one of its products. Each unit requires 5 hours of direct labour. For the coming year, the company is considering changing to an activity based costing system by allocating overhead based on 3 activities. The following are the activities, budgeted total cost and cost drivers per activity for the upcoming year: Activity Cost...
1. ABC Company uses absorption costing in its GAAP financial statements and variable costing for its...
1. ABC Company uses absorption costing in its GAAP financial statements and variable costing for its internal management reporting. .ABC Company has produced 20,000 cell phone covers in 2016, but only sold 18,000 cell phone covers. ABC Company had no beginning inventory and now has ending inventory of 2,000 cell phone covers. Which of the following are true? A.    ABC Company will report higher income in its absorption income statement than in its variable income statement. B.    ABC Company will...
1. Determine the following information using absorption costing and variable costing: Absorption costing a. Manufacturing cost...
1. Determine the following information using absorption costing and variable costing: Absorption costing a. Manufacturing cost _______________ b. Per-unit cost _______________ c. Cost of ending inventory _______________ Variable costing a. Manufacturing cost _______________ b. Per-unit cost _______________ c. Cost of ending inventory _______________ Basic facts: Direct materials $1,000 Direct labor $2,000 Variable overhead $1,500 Fixed overhead $1,000 Units produced 100 Units sold 80 No beginning inventory 2. What is the prime cost per unit and conversion cost per unit: a....
Variable costing versus absorption costing. The Garvis Company uses an absorption-costing system based on standard costs....
Variable costing versus absorption costing. The Garvis Company uses an absorption-costing system based on standard costs. Variable manufacturing cost consists of direct material cost of $4.50 per unit and other variable manufacturing costs of $1.50 per unit. The standard production rate is 20 units per machine-hour. Total budgeted and actual fixed manufacturing overhead costs are $840,000. Fixed manufacturing overhead is allocated at $14 per machine-hour based on fixed manufacturing costs of $840,000÷60,000$840,000÷60,000 machine-hours, which is the level Garvis uses as...
Q2: Variable and Absorption costing Fagan Manufacturing uses an absorption costing system. In 2009 it manufactured...
Q2: Variable and Absorption costing Fagan Manufacturing uses an absorption costing system. In 2009 it manufactured 25,000 units and sold 20,000 units at $45 each. The company’s income statement for year ended December 31 2009 is as follows: FAGAN MANUFACTURING COMPANY INCOME STATEMENT FOR THE YEAR ENDING DECEMBER 31, 2009 Sales $900,000 Cost of goods sold: Finished goods inventory, January 1 $           0 Cost of goods manufactured 812,500 Goods available for sale $812,500 Finished goods inventory, December 31 162,500   ...
You have been asked to explain the difference between NOI for absorption costing and variable costing...
You have been asked to explain the difference between NOI for absorption costing and variable costing for Duncan Inc. You have the following information regarding the performance for the year: Absorption Variable Sales $       1,260,000 Sales     1,260,000 Cost of goods sold              810,000 Variable cost of goods sold        720,000 Gross margin              450,000 Variable selling and administrative expenses        120,000 Selling and administrative expenses              195,000 Contribution margin        420,000 NOI $          255,000 Fixed manufacturing overhead        120,000...
A firm uses backflush costing on a direct costing basis. It incurs the following costs this...
A firm uses backflush costing on a direct costing basis. It incurs the following costs this period (the firm has NO fixed overhead costs). Direct materials costs: $20,000 Direct labor costs: $20,000 Variable overhead costs: $10,000 The firm's total units (completed and in process) is 1,839. The firm has 45 units in process and 96 unsold units in finished goods. The firm has $339 of unused raw materials left over at the end of the period. What is the balance...
Metrix Gold Ltd uses a job order costing system, with a predetermined overhead absorption rate based...
Metrix Gold Ltd uses a job order costing system, with a predetermined overhead absorption rate based on machine hours. The corporation keeps only one set of books for cost and financial transactions. At the beginning of 2017, the firm estimated its manufacturing overheads for the year at N$65 200 and the machine hours at 9 150. The following are data uses on jobs worked on during December 2017: Details Job A Job B Job C Total N$ N$ N$ N$...
ABC uses job-order costing. It applies overhead cost to jobs on the basis of direct labor-hours....
ABC uses job-order costing. It applies overhead cost to jobs on the basis of direct labor-hours. The following transactions took place during the year: a) $300,000 of raw materials were purchased on account b) Raw materials were issued into production: $90,000 direct materials and $40,000 indirect materials c) Labor costs incurred: $40,000 direct, $130,000 indirect, sales commissions $50,000, administrative salaries $100,000 d) Utility costs for the factory were $60,000 e) Depreciation recorded was $300,000 (70% related to factory; 30% related...
4.  Which of the following is the key argument in favor of absorption costing? a. Absorption costing...
4.  Which of the following is the key argument in favor of absorption costing? a. Absorption costing overstates the balance sheet value of inventories. b. Variable factory overhead is a period cost. c. Fixed manufacturing overhead is difficult to allocate properly. D. Fixed manufacturing overhead is necessary for the production of a product. 5.  The key argument in favor of direct costing is that fixed manufacturing overhead costs should be accounted for as a period cost.  What is the rationale behind this?       A.  Fixed...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT