Your company Twilight Ltd makes two products; the Wolf and the Vamp. The market is incredibly competitive, and Twilight has to conduct market analysis of prices in order to stay competitive.
This year it plans to make 1,000 of the Wolf and 1,500 of the Vamp. Previous years the company has used absorption costing on a simplistic blanket rate apportioning on labour hours the overheads: The overhead absorption rate per unit for Wolf £26.10 and Vamp £32.63. Direct cost for Wolf was £100 per unit and Vamp £80 per unit.
This year you, as the management accountant and your team have worked on preparing an analysis of the overheads using activity based costing.
You have prepared the information below:
Overheads
The company incurs £75,000 production overheads during the year.
Each Wolf takes 3 hours of direct labour in total, and 1.5 machine hours to make.
Each Vamp takes 3.75 hours of direct labour in total, and 2.25 machine hours to make.
Cost driver Information
Cost pool | £ | Cost driver | Wolf | Vamp | Total |
Materials handling | 18,000 | Number of material movements | 40 | 60 | 100 |
Job scheduling | 12,000 | Job scheduling (production runs) | 40 | 60 | 100 |
Machine related | 33,000 | Machine hours | 1,500 | 3,375 | 4,875 |
Quality control inspections | 12,000 | Quality control inspections | 25 | 25 | 50 |
Total overheads | £75,000 |
Activity Based Costing Analysis (appendix 1)
Overhead per Activity:
Materials handling £18000/100= £180 per move
Job scheduling = £12,000/100 = £120 per job
Machine related = £33,000/4875= £6.77 per hour
Quality control inspections = £12,0000/50 = £240 per inspection
Overhead per Product
Cost pool | £ | Wolf £ | Vamp £ |
Materials handling | 18,000 |
40 x£180= £7,200 |
60 x £180= £10,800 |
Job scheduling | 12,000 |
40 x £120 £4,800 |
60 x £120 £7,200 |
Machine related | 33,000 |
1,500 x £6.77 £10,155 |
3,375 x £6.77 £22,849 |
Quality control inspections | 12,000 |
25 x £240 £6,000 |
25 x £240 £6,000 |
Total overheads | £75,000 | £28,155 | £46,849 |
Number of units | 1,000 | 1,500 | |
Overhead cost per unit | £28.15 | £31.23 | |
Full cost | £128.15 | £111.23 |
Required:
You are the management accountant at Twilight. The senior management accountant Ray Briggs, who happens to be your line manager, has reviewed the work above which you prepared recently. Ray sends you the following email which he is expecting a response too.
To: Management Accounting
Subject: Activity Based Costing Analysis within Twilight
Dear Management Accounting,
I hope you are well and have had a nice break. I have finally had time to review the work you have prepared reviewing the use of ABC within Twilight. I have a few requirements I need you to address in an email please:
Copyright © 2012 - 2024 Apaxresearchers - All Rights Reserved.