Question 3.RQ.5: DC Ltd is an engineering company which uses job costing to a...
DC Ltd is an engineering company which uses job costing to attribute costs to individual products and services provided to its customers. It has commenced the preparation of its fixed production overhead cost budget for year 2 and has identified the following costs:
£000
Machining 600
Assembly 250
Finishing 150
Stores 100
Maintenance 80
1,180
The stores and maintenance departments are production service departments. An analysis of the services they provide indicates that their costs should be apportioned as follows:
Machining Assembly Finishing Stores Maintenance
Stores 40% 30% 20% – 10%
Maintenance 55% 20% 20% 5% –
Requirements
(a) After the apportionment of the service department costs, the total overheads of the production departments will be (to the nearest £500):
Machining £ \boxed{ \ \ \ \ \ \ \ \ \ \ \ \ }
Assembly £ \boxed{ \ \ \ \ \ \ \ \ \ \ \ \ }
Finishing £ \boxed{ \ \ \ \ \ \ \ \ \ \ \ \ }
(b) DC Ltd’s overhead absorption rates for year 1 are as follows:
Machining £13.83 per machine hour
Assembly £9.98 per labour hour
Finishing £9.45 per labour hour
Job no. XX34 is to be started and completed in year 1. Data for the job is as follows:
Direct materials cost £2, 400
Direct labour cost £1, 500
Machine hours and labour hours required for the job are:
Machine hours Labour hours
Machining department 45 10
Assembly department 5 15
Finishing department 4 12
DC Ltd adds 10 per cent to total production cost in order to absorb non-production overhead costs, and profit is calculated as 20 per cent of selling price.
Requirement
Complete the following statements (to the nearest penny):
(i) The total production overhead cost of job no. XX34 is £ \boxed{ \ \ \ \ \ \ \ \ \ \ \ \ }
(ii) The total production cost of job no. XX34 is £ \boxed{ \ \ \ \ \ \ \ \ \ \ \ \ }
(iii) The selling price of job no. XX34 is £ \boxed{ \ \ \ \ \ \ \ \ \ \ \ \ }
Learn more on how we answer questions.
Solution 5
● You will need to use the repeated distribution method to deal with the reciprocal servicing in part (a).
● The question mentions job costing, which is the subject of Chapter 8. For now, all you need to know is that an individual job – in this case job XX34 – is simply treated as a cost unit for the purposes of overhead absorption.
(a) Machining: £691,500
Assembly: £299,500
Finishing: £189,000
Workings :
Machining | Assembly | Finishing | Stores | Maintenance | |
£000 | £000 | £000 | £000 | £000 | |
Allocated costs | 600.00 | 250.00 | 150.00 | 100.00 | 80.00 |
Stores apportionment | 40.00 | 30.00 | 20.00 | (100.00) | 10.00 |
Maintenance | 49.50 | 18.00 | 18.00 | 4.50 | (90.00) |
apportionment | |||||
Stores apportionment | 2.00 | 1.50 | 1.00 | 4.50 | ____ |
Total | 691.50 | 299.50 | 189.00 | ____ | ____ |
(b) (i) £885.45
(ii) £4,785.45
(iii) £6,580.00
Workings :
£ £
Direct material 2,400.00
Direct labour 1,500.00
Prime cost 3,900.00
Overhead cost:
Machining (45 × £13.83) 622.35
Assembly (15 × £9.98) 149.70
Finishing (12 × £9.45) 113.40
885.45
Total production cost 4,785.45
Non-production overhead (10%) 478.55
Total cost 5,264.00
Profi t mark-up (25%) * 1,316.00
Price for Job XX34 6,580.00
* A profit margin of 20 per cent of selling price is the same as a mark-up of 25 per cent of cost. Check for yourself that the calculated profit margin is in fact 20 per cent of the selling price