Determine the overhead activity cost allocations to


1. Anderson Ltd. manufacture gearboxes for use in cars. At the start of the year, the management of Anderson Ltd. estimated that its costs would be:

 

% of sales value

Direct labour

8

Direct material

50

Variable production overhead

8

Fixed production overhead

12

Administration overhead

5

This was based on the following: 80 employees
2000 hours worked by each employee
40 000 gearboxes manufactured in the year as budgeted production
£200 unit selling price.

You have recently been employed by the company to establish a standard costing system. At the end of the year you were able to extract the following information:

- labour costs £4.40/hour
- 32 000 units sold
- £210/unit selling price
- 160 000 hours were worked
- variable production overheads were £640 000
- fixed production overheads were £810 000
- administration costs were £350 000
- raw material prices were 10% higher than expected
- total expenditure on raw material was £3.696 M
- there were no opening or closing stocks of raw materials.

(a) You are required to prepare an operating statement for the year, using a standard absorption costing system.

Calculations should proceed according to the following headings suffixing ‘A' for Adverse and ‘F' for Favourable where appropriate. Resulting quantities required for the statement are then entered in the ‘Operating Statement for the Year' sheet shown on page 6.

(All working must be shown.)

(Budgeted) Costs


Direct labour                                          Unit cost
                                                                    £

Direct materials

Variable overhead

Fixed overhead

Admin. overhead Total
Selling price

Standard profit (per unit) Budgeted profit

Sales price variance Sales quantity variance

(These last three entries are added to the ‘Operating Statement for the Year' on the final sheet of the calculations.)

Cost Variances Labour Variances Standard hours =

Standard cost/hour =

Rate variance =
Standard time =

Actual time =

Time variance = Efficiency variance =
(Add rate and efficiency variances to ‘Operating Statement for the Year' on the final sheet of the calculations.)

Material Variances

Material price =

Material usage - standard =
- actual

= Material usage variance =
(Add price and usage variances to ‘Operating Statement for the Year' on the final sheet of the calculations.)

Variable overheads Standard cost = Actual cost =
Expenditure variance = Efficiency variance =
(Add expenditure and efficiency variances to ‘Operating Statement for the Year' on the final sheet of the calculations.)

Fixed overheads Expenditure variance = Volume variance =
(Add these variances to ‘Operating Statement for the Year' on the final sheet of the calculations.)

Admin overhead (treat as fixed) Expenditure variance =
Volume variance =

(Add these variances to ‘Operating Statement for the Year' on the final sheet of the calculations.)

Operating Statement for the Year

                                               £'000                                 £'000

Budgeted Profit

Sales variance - price
- quantity

Cost variances

Labour - rate
- efficiency

Material - price
- usage

Variable - expenditure
- efficiency

Fixed - expenditure
- volume

Admin - expenditure
- volume

Actual Profit

(b) Give reasons/explanations why the variances in (a) above have occurred for the following:

(i) material price
(ii) labour efficiency
(iii) fixed overhead expenditure.

(c) The accountant suggests that a standard marginal costing system may be more suitable. He asks you to outline the strengths and weaknesses of both systems and recommend the most suitable.

(d) The Board of Anderson Ltd. want to adopt ‘ideal' standards because they feel it will encourage harder work. You are asked to produce a brief report giving your views.

2. (a) For the following categories of activities assign an appropriate cost driver from the list provided against each activity in TABLE 1.

Cost Drivers:

- Cost of Inspection/Test
- Machine use hours
- Direct Labour Hours
- Number of Purchase Orders
- Number of Production Runs
- Material Delivery/Invoices.

Activities to produce product

Cost Drivers

Activity Centre 1 Machining

 

Activity Centre 2 Machining

 

Product Assembly

 

 

 

Materials Procurement Activities

 

Product Materials Purchased

 

Material Reception/Storage

 

Materials Issued/Production Run

 

 

 

Support Activities

 

Production Planning

 

Machine Setting Up/Tooling

 

Statistical Quality Control

 

TABLE 1

(b) TABLE 2 shows the cost drivers, the quantity and unit cost of the cost driver, and total activity cost.

For two products A and B it is found that:

- The direct labour hours for products A and B are the same.

- It takes approximately four times as many machining hours in both cost centres to produce product B as product A.

- Product A requires one quarter of the materials purchased for B.

- Product A requires one third of the total Delivery notes/invoices.

- Product A has issued one third of the total materials issued per production run.

- Product A has issued one half of the planning per production run of that required by Product B.

- Product B requires twice as many machine set-ups as product A.

- The products have the same number of quality control inspections.

If the company produces 50 000 each of products A and B:

(i) Complete TABLE 2 to determine the cost driver unit costings in column 5 for the activities of column 1. Show also the product quantity splits in column 4 of each activity for product A and B (e.g. quantity of cost driver Activity Centre 1 is shown as split 100 000 product A and 400 000 product B).

(ii) Determine the overhead activity cost allocations to products A and B (using the activity proportions calculated in column 4) by completing TABLE 3.

(iii) Determine the total overhead allocations to products A and B.

(iv) Find the per unit product overhead cost allocations for each product.

Activity involved to Produce Product

Allocated Cost of Activity

£

Activity Cost Driver

Quantity of Cost Drivers

Cost Driver Unit cost/rate per Cost Driver £

Activity Centre 1 Machining

750 000

Machine Use hours

500 000

(100 000 prod A

400 000 prod B)

 

Activity Centre 2 Machining

500 000

Machine Use hours

250 000

 

Product Assembly

400 000

Direct labour hours

100 000

 

 

 

 

 

 

Materials Procurement Activities

 

 

 

 

Product Materials Purchase

 

600 000

 

Purchase Orders

 

5000

 

Product Material Reception/Storage

240 000

Number of Invoices or Material Delivery Notes

3000

 

Materials Issued/Production Run

225 000

Number of Production runs

1500

 

 

 

 

 

 

Support Activities

 

 

 

 

Production Run Planning

150 000

Number of Production runs

1500

 

Machine Setting Up/Tooling

30 000

Setting up/tooling labour hours

750

 

Statistical Quality Control

10 000

Sample inspection and Test Cost

400

 

Total

 

 

 

 

 

Request for Solution File

Ask an Expert for Answer!!
Dissertation: Determine the overhead activity cost allocations to
Reference No:- TGS02285285

Expected delivery within 24 Hours