Reference no: EM131496709

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