Skip to contentSkip to search

More variance analysis

VIVA Subject Guide

1 Introduction

In this chapter we will look more at variances and several ways of making them more useful to management.

Planning and Operational variances involve further analysis of the variances to assist management in deciding where more investigation should be focussed; whereas Mix and Yield variances looks at a specific situation where conventional variances might be misleading; and finally we will take another look at labour idle time variables.

2 Planning and Operational variances

YouTube video
YouTube video

We discussed in the previous chapter that the purpose of variance analysis is to assist management in exercising control by identifying areas where perhaps there are operational problems.

We also discussed possible reasons for variances. Although these included factors such as inefficiency of the workforce – a factor that perhaps may be controlled for the future – they also included factors such as an increase in raw material prices and an incorrect standard having been used in the budgets. These last two are examples of factors that certainly can not be controlled and where it would be silly to waste time re-investigating each month. It would make more sense to compare actual results with a standard that reflects any changed conditions and is therefore realistic.

2.1 Planning variance (or revision variance)

This is a classification of variances calculated by comparing the original budget (or ex ante budget) to a budget revised for any permanent changes to a more realistic budget (ex post budget).

2.2 Operational variance

This is a classification of variances calculated by comparing actual performance with a revised (or ex post) budget. These variances are worth investigating more as they are variances caused by operating factors that potentially might be controllable.

Original budget:

Standard cost of materials: 10 kg at $5 per kg

Budget production: 10,000 units

Actual results:

Production: 11,000 units

Materials: 108,900 kg at $4.75 per kg

Since preparation of the budget the price per kg has changed to $4.85 and the usage to 9.5 kg per unit.

Calculate the expenditure and usage variances, and analyse each into planning and operational variances.

Show answerHide answer

Answer to example 1

Expenditure variance

Actual usage at actual cost:

108,900 × $4.75

=

517,275

Actual usage at standard cost:

108,900 × $5.00

=

544,500

Variance:

27,225 (F)

Planning variance:

Actual usage at revised cost:

108,900 × $4.85

=

528,165

Actual usage at standard cost:

108,900 × $5.00

=

544,500

Planning variance:

16,335 (F)

Operational variance:

Actual usage at actual cost:

108,900 × $4.75

=

517,275

Actual usage at revised cost:

108,900 × $4.85

=

528,165

Operational variance:

10,890 (F)

Usage variance:

Actual usage:

108,900 kg

Standard usage:

11,000 × 10kg

110,000 kg

1,100 kg × $5

=

$5,500 (F)

Planning variance:

Revised usage:

11,000 × 9.5 kg

104,500 kg

Standard usage:

11,000 × 10 kg

110,000 kg

5,500 kg × $5

=

$27,500 (F)

Operational variance:

Actual usage:

108,900 kg

Revised usage:

11,000 × 9.5 kg

104,500 kg

4,400 kg × $5

=

$22,000 (A)

Original budget:

Standard cost of labour: 8 hrs at $4 per hour

Budget production: 20,000 units

Actual results:

Production: 24,000 units

Labour: 190,000 hrs for $769,500

Since preparation of the budget the price per hour had increased to $4.10 and the time had been revised to 7.5 hrs per unit.

Calculate the rate of pay and efficiency variances, analysed into planning and operational variances.

Show answerHide answer

Answer to example 2

Rate of pay variances

Planning variance:

Actual hours at revised cost:

190,000 × $4.10

=

779,000

Actual hours at standard cost:

190,000 × $4.00

=

760,000

Planning variance:

19,000 (A)

Operational variance:

Actual hours at actual cost:

769,500

Actual hours at revised cost:

190,000 × $4.10

=

779,000

Operational variance:

9,500 (F)

Efficiency variance:

Planning variance:

Revised hours:

24,000 × 7.5 hours

180,000 hours

Standard hours:

24,000 × 8 hours

192,000 hours

12,000 hours × $4 =

$48,000 (F)

Operational variance:

Actual hours:

190,000 hours

Revised hours:

24,000 × 7.5 hours

180,000 hours

10,000 hours × $4

=

$40,000 (A)

3 Mix and Yield variances

YouTube video

It is quite common in practice for one product to use several different materials.

For example, a desk may use wood for the top and metal for the legs.

For each of the materials we can calculate price and usage variances in the normal way, and usually this is sufficient for our purpose.

However, suppose we were manufacturing a mixed fruit juice that contained a mixture of strawberry juice and banana juice. To calculate usage variances for each material separately would be of little use – if we used less strawberry juice than budgeted, we would automatically use more banana juice. We would therefore end up with one variance favourable and one adverse, and yet the overall effect on costs could be either favourable or adverse depending on which juice was the most expensive.

In this situation, when the materials may be substituted for each other (or are substitutable) then we look at all the materials together and analyse the usage variance into the following variances:

  • mix variance

    this shows the effect of changing the proportions of the mix of materials input into the process

  • yield variance

    this shows the difference between the actual and expected output or yield from the process

Mix is about proportions, yield is about output, and the two are read separately. An adverse mix variance means a greater share of the dearer materials was used; a favourable one, more of the cheaper. The signs need not agree — a cheaper mix of poorer material can produce an adverse yield.

The standard material cost per unit of a product is as follows:

$

Material X

2 kg @ $3 per kg

6

Material Y

1 kg @ $2 per kg

2

8

The actual production during the period was 5,000 units and the materials used were:

Material X 9,900 kg costing $27,000

Material Y 5,300 kg costing $11,000

Calculate the total materials cost variance; the materials price variance; the materials usage variance; the mix variance; and the yield variance.

Show answerHide answer

Answer to example 3

Total materials cost variance

Actual total cost (27,000 + 11,000)

38,000

Standard total cost (5,000 × $8)

40,000

Total cost variance

$2,000

(F)

Materials price variance

Actual purchases

Actual cost

Actual purchases

Standard cost

kg

$

kg

$

X

9,900

27,000

9,900

29,700

Y

5,300

11,000

5,300

10,600

38,000

40,300

Price variance = 40,300 – 38,000 = $2,300 (F)

Mix variance

Actual purchases

Standard cost

Standard mix

Standard cost

kg

$

kg

$

X

9,900

29,700

(⅔)

10,133

30,399

Y

5,300

10,600

(⅓)

5,067

10,134

15,200

kg

40,300

15,200

kg

40,533

Mix variance = 40,300 – 40,533 = 233 (F)

Yield variance

Standard mix
(actual total)

Standard cost

Standard mix

Standard cost

kg

$

kg

$

X

10,133

30,399

10,000

30,000

Y

5,067

10,134

5,000

10,000

15,200

kg

40,533

15,000

kg

40,000

Yield variance = 40,533 – 40,000 = 533 (A)

(Usage variance = Yield variance + Mix variance = 533 (A) + 233 (F) = 300 (A))

3.1 Other mix variances

YouTube video

Although the calculation of mix variances most commonly relates to materials, exactly the same sort of situation could be relevant for labour if there were more than one grade (paid at different rates) that were substitutable.

The approach would be exactly the same as for materials.

Slightly less obvious (although essentially the same approach) is the situation where sales are ‘substitutable’.

For example, suppose a company sold two types of desk which although similar had different profit margins. Clearly the company would hope for higher sales, but they would also be interested in the mix of sales – it would be better if customers bought more of the desks giving higher profit p.u., even if it were to mean selling fewer of the desks that gave lower profit p.u..

Again, in this situation, the approach used for materials may be useful.

Olga plc sells three products – A, B and C.

The following table shows the budget and actual results for these products:

A

B

C

Budget:

Sales (units)

200

100

100

Price (p.u.)

$20

$25

$30

Cost (p.u.)

$17

$21

$24

Actual:

Sales (units)

180

150

170

Price (p.u.)

$22

$22

$26

Cost (p.u.)

$16

$18

$25

Calculate the total sales margin variance, and analyse into the sales price variance; the sales mix variance; and the sales quantity variance.

Show answerHide answer

Answer to example 4

Note: throughout this answer we use standard costs because cost variances are calculated separately in the usual way

Total sales margin variance

Budget profit:

A

200u

×

(20 – 17)

600

B

100u

×

(25 – 21)

=

400

C

100u

×

(30 – 24)

=

600

1,600

Actual profit (using standard costs):

A

180u

×

(22 – 17)

900

B

150u

×

(22 – 21)

=

150

C

170u

×

(26 – 24)

=

340

1,390

Total variance = 1,390 – 1,600 = $210 (A)

Sales price variance

Actual sales

Actual selling price

Actual sales

Standard selling price

units

$

units

$

A

180

× 22 =

3,960

180

× 20 =

3,600

B

150

× 22 =

3,300

150

× 25 =

3,750

C

170

× 26 =

4,420

170

× 30 =

5,100

$11,680

$12,450

Sales price variance = 11,680 – 12,450 = $770 (A)

Sales mix variance

Actual total sales

Standard profit p.u.

Actual total sales at standard mix

Standard profit p.u.

units

$

units

$

A

180

× $3 =

540

(2/4)

250

× $3 =

750

B

150

× $4 =

600

(1/4)

125

× $4 =

500

C

170

× $6 =

1,020

(1/4)

125

× $6 =

750

500

$2,160

500

$2,000

Mix variance = 2,160 – 2,000 = $160 (F)

Sales quantity variance

Actual total sales standard mix

Standard Profit

Budget sales

Standard profit

units

$

units

$

A

250

× $3 =

750

200

× $3 =

600

B

125

× $4 =

500

100

× $4 =

400

C

125

× $6 =

750

100

× $6 =

600

500

$2,000

400

$1,600

Quantity variance = 2,000 – 1,600 = $400 (F)

4 Advanced Idle Time variances

YouTube video

When we looked at labour variances in the previous chapter, we said that any difference between the hours paid and the hours worked was Idle Time.

However, since there is likely to be some idle time in almost every business, it would be more sensible to build some idle time into the budget and then an idle time variance would only occur if the actual idle time were more or less than budgeted.

We will look at the ‘rules’ with an example.

A company budgets that each unit will take 7.6 hours to make.

It budgets on paying workers at the rate of $5.70 per hour, and that 5% of the hours paid for will be idle.

The actual results (for production of 1000 units) are:

Hours paid: 8,200 hours at a cost of $50,020

Hours worked: 7,740 hours

(a) Calculate what will appear on the standard cost card as the labour cost per unit

(b) calculate the effective standard cost per hour worked

(c) calculate the total labour variance

(d) Analyse the total variance into rate of pay, idle time, and efficiency variances.

Show answerHide answer

Answer to example 5

(a)   Each unit takes 7.6 hours to make, and therefore the company expects to need to pay for 7.6/.95 = 8 hours of labour.

  8 hours at the rate of $5.70 per hour gives a standard cost of $45.60 per unit

(b)   Each unit should take 7.6 hours to produce, and should cost $45.60 for labour. Therefore, the effective standard cost per hour worked is 45.60 / 7.6 = $6.00

(c) Total labour variance:

Actual cost of production:

50,020

Standard cost of actual production

(1,000 units at $45.60)

45,600

Total variance

4,420

(A)

(d) Rate of pay variance:

Actual amount paid

50,020

Standard cost of actual hours paid

(8,200 hours at $5.70)

46,740

Total variance

3,280

(A)

Idle time variance:

Actual idle hours (8,200 – 7,740)

460

hours

Standard idle time (8,200 × 5%)

410

hours

Excess idle time

50

hours

Idle time variance: 50 hours at $6.00 =

$300

(A)

Efficiency variance:

Actual hours worked

7,740

hours

Standard hours worked for actual

Production: 1000 units × 7.6 hours =

7,600

hours

Excess hours worked (7,740 – 7,600)

140

hours

Efficiency variance: 140 hours × $6 =

$840

(A)

(Check:

Rate of pay

3,280

(A)

Excess idle time

300

(A)

Efficiency

840

(A)

Total

$4,420

5 Activity Based Costing Variances

YouTube video

You will remember from an earlier chapter that ABC is a way of allocating overheads to products using cost drivers.

The main reason for doing this was not just to encourage cutting the total cost of the overhead, but also to encourage more efficient use of the overhead.

For example, we may have had an overhead cost for despatch of $100,000 and a total of 5,000 despatches. This would mean that it was costing $20 per despatch. We could reduce the cost per despatch by either cutting the total cost (an expenditure variance) or by increasing the number of despatches (an efficiency variance).

The following information is available for a period:

Budget

Actual

Production

48,000 units

50,400 units

Activity level

2,000 despatches

2,200 despatches

Total overhead cost of despatching

$120,000

$126,720

Calculate the total overhead variance for despatching, and analyse into the expenditure and efficiency variances.

Show answerHide answer

Answer to example 6

Total variance:

$

Actual total expenditure

126,720

Standard cost for actual production

126,000

(50,400 × 120,000/48,000)

720

(A)

Expenditure variance:

$

Actual total expenditure

126,720

Standard cost for actual despatches

132,000

(2,200 × 120,000/2,000)

5,280

(F)

Efficiency variance:

Despatches

Actual number of despatches

2,200

Standard number of despatches for actual production

2,100

(50,400 × 2,000/48,000)

100

Variance = 100 despatches × standard cost per despatch

= 100 × 120,000/2,000 = $6,000 (A)

6 The application of standard costing (and variance analysis) in the modern environment.

Modern management places great emphasis on quality - Total Quality Management (TQM), and on increasing efficiency and reducing waste - Just In Time (JIT).

However, traditional standard costing tends to make allowances for waste and for idle time, which is contrary to the TQM and JIT culture.

Traditional variance analysis focuses on quantity rather than quality. This could mean, for example, using lower quality material to save money. This would again be contrary to the TQM and JIT culture.

Another element of the TQM culture is the idea of trying to achieve continuous improvement. Traditional variance analysis does not really accommodate this.

Practice questions

Planning, operational, mix & yield variances

9 questions

Answer the questions one at a time. Your progress is saved so you can leave and come back.

Open chapter practice