Activity Based Costing
Worked Example
The following information provides details of the costs, volume and transaction cost drivers for a period in respect of XYZ Ltd:
Products A B C Total
Sales and production (units) 90,000 30,000 15,000 135,000
Raw materials usage (units) 10 7 14 1,320,000
Direct materials cost (£) 30 40 15 4,125,000
Direct labour hours 2.5 3 1.5 337,500
Machine hours 5 3 7.5 652,500
Direct labour cost (£) 20 30 10 2,850,000
Number of production runs 5 10 50 65
Number of deliveries 18 7 50 75
Number of receipts 50 70 700 820
Number of production orders 45 25 60 130
Overhead costs £
Set up 75,000
Machines 1,000,000
…show more content…
The receiving overhead rate is
Total receiving overheads
Total number of receipts £900,000
820
£1,097.56 per receipt
Using this rate as a constant allows us to evaluate the product overhead apportionments: overheads per receipt x receipts per product group
For product A:
£1,097.56 per receipt x 50 receipts
£54,878
Product A B C
Receiving overheads apportionment £54,787.0 £76,829.3 £768,292.7
We then divide these product apportionments by the number of units made for each product, to derive the cost per unit for receiving goods. The calculations here give the following results:
Product A B C
Receiving cost per unit £0.60976 £2.5610 £51.2195
Notice, when compared with Drury 's method of using the overhead rate as a percentage of direct materials cost, the version presented here gives a radically different result. Had we applied Drury 's method, the product receiving cost per unit would have been:
Overhead absorption rate:
£900,000 x 100 = 21.82%
= £4,125,000
Applying this rate to each product 's material costs gives:
Product
A B C
£6.55 8.73 3.27
The method we have used applies the full spirit of ABC by identifying and using fully the ABC approach. The other overhead rate, the Machine Hour Rate, is £3.79. This is calculated by dividing the total other overheads by the number of machine hours applied, or worked. In
1. For financial accounting purposes, what is the total amount of product costs incurred to make 10,000 units?
14. A decision to work closely with a limited number of suppliers for the purpose of ensuring that the proper materials are available at the optimal time is an example of:
330-10-30330-10-30-1 The primary basis of accounting for inventories is cost, which has been defined generally as the price paid or consideration given to acquire an asset. As applied to inventories, cost means in principle the sum of the applicable expenditures and charges directly or indirectly incurred in bringing an article to its existing condition and location. It is understood to mean acquisition and production cost, and its determination involves many considerations. 330-10-30330-10-30-2 Although principles for the determination of inventory costs may be easily stated, their application, particularly to such inventory items as work in process and finished goods, is difficult because of the variety of considerations in the allocation of costs and charges.
Since material cost is one of the key cost drivers for the production of the units, it is best to take
Company Wide Overhead Rate equal Forecast Overhead divided by Expected Machine Hours Overhead Rate equal $480,000 equal $6 per machine hour 80,000. Company Wide Rate: Direct Material Costs x Batch Size plus Direct Labor Costs x Batch Size Maxiflow: Alaska: 135 x 20 equal 2700 110 x 20 equal 2200 75 x 20 equal 1500 95 x 20 equal 1900 equal $4200 per batch equal $4100 per batch Departmental Rate. Direct Materials Costs plus Direct Labor Costs divided by Each Department Hour Maxiflow: 135 plus 75 equal $210 Radiator Parts Fabrication: 210 divided by 28 equal $7.50 per batch Radiator Assembly, Weld, and Test equal 210 divided by 30 equal $7 per batch Compressor Parts Fabrication: 210 divided by 32 equal $6.60 per batch Compressor Assembly and Test: 210 divided by 26 equal $8.10 per batch Alaska: 110 plus 95 equal 205 Radiator Parts Fabrication: 205 divided by 16 equal $12.80 per batch Radiator Assembly, Weld, and Test: 205 divided by 74 equal $2.70 per batch Compressor Parts Fabrication: 205 divided by 8 equal $25.60 per batch Compressor Assembly and Test: 205 divided by 66 equal $3.10 per batch. There was only a $100 difference between Maxiflow and Alaska when it came to company-wide rates per batch.
3. Briefly describe how the current production cost assignment system works. What are the consumption ratios (activity percentages) for assigning manufacturing overhead to each product at present?
Under a traditional system, overhead cost is allocated to an activity based on hours or rates for direct labor or machine usage. However, this approach does not clearly indicate how much overhead cost will be needed in order to complete a job through a particular function. ABC methodology is to be used as an alternative to traditional accounting where a business 's overhead costs (indirect costs such as electrical energy consumption for heating or cooling, or indirect cost associated with marketing) are allocated as a proportion of direct costs, to an activity. This approach is unsatisfactory because there can be cases where two activities could absorb the same direct costs
Traditional costing uses one overhead rate in light of chronicled overhead costs for the whole assembling procedure. A solitary overhead rate neglects to catch contrasts in per unit overhead costs, bringing about unnecessary planning for items with littler per unit overhead costs. Action based costing relegates overhead rates in view of particular overhead cost pools. The system then doles out the rates to the unit prerequisites of these expense pools per item. The outcome is overhead costs that mirror the contrasting overhead prerequisites for the individual item. The final result is aggregate costs that more precisely speak to contrasts in per unit overhead
If we compare the old job costing method with the Activity based costing method we can see in the table below that the activity base rate gives us a much more accurate insight in allocating the manufacturing overhead costs. In fact, the activity based overhead calculation shows us that the activity rates for Valves and Pumps are lower than the rates used in plantwide production rates, but the activity based rate for Flow Controllers is around 50% higher than the cost calculated in the job costing method. The reason for this difference in our opinion can be traced back to the high receiving and production control costs as well as packaging &
The above cost system was efficient during the 1980s because it split up overhead over three cost pools, adding an additional pool, which has machine hours as its cost driver. This proved efficient because “[w]ith increased usage of automated machines, direct labor run time no longer reflected the amount of processing being performed on parts, particularly when one operator was responsible for several machines.” Packet, pg. 7.
• This cost method does not provide the best system for JDCW’s cost allocation. By using only three overhead rates the present system grossly undermines the true production costs since other activities of the production process are not acknowledged.
7. Though numbers given in the cost data can not be contested, I would definitely contest the way total cost has been computed. The item 345 department operates within a large manufacturing facility that churns out number of other products too. Hence judging the profitability of item 345 on the basis of total cost is not practical.
Total overhead cost allocated to wood framed prints = 0.28 × 7,000 × 20 = 39,200
This paper will discuss and analyze the concepts of Activity- Based Costing (ABC) in the manufacturing industry. Specifically, the document will focus on General Motors (GM), and the innovation of one of their manufacturing facilities who used ABC to predict energy usage in the manufacturing of automobiles. The study yielded a successful ABC predictive energy model which provided a structure for competitive advantage for the corporation.
Shipping and warehousing costs are currently assigned using tons of paper produced, a unit-based measure. Many of these costs, however, are not driven by quantity produced. Many products have special handling and shipping requirements involving extra costs. These costs should not be assigned to those products that are shipped directly to customers.