Skip to contentSkip to search

Semi-Variable Costs

VIVA Subject Guide
YouTube video

1 Introduction

The chapter relates to semi-variable costs i.e. part fixed and part variable. It may be necessary for you in the examination to identify the fixed and variable elements and in this chapter we will revise the ‘high-low’ method and also explain Regression Analysis.

2 High-Low Method

This is a quick and easy approach that estimates fixed and variable costs by comparing the highest and lowest activity levels.

Electricity costs for the first 6 months of the year are as follows:

Units produced

Cost ($)

January

340

2,260

February

300

2,160

March

380

2,320

April

420

2,400

May

400

2,300

June

360

2,266

Calculate the fixed and variable costs using the high-low method.

Show answerHide answer

Answer 1

units

$

High

420

2,400

Low

300

2,160

Difference

120

$240

Variable cost$240120=$2per unit

In ‘high’

$

Total cost

2,400

Variable cost (420u × $2)

840

Fixed cost

$1,560

y = 1,560 + 2x

3 Problems with the high-low approach

4 Regression

YouTube video

If there is a reasonable degree of linear correlation between two variables, we can use regression analysis to calculate the equation of the best fit for the data.

This is known as least squares linear regression.

If the equation relating two variables, × and y, is

y = a + bx

then the values of a and b may be calculated using the following formulae (which are given in the examination)

b=nΣxy-ΣxΣynΣx2-Σx2a=Σyn-bΣxn

The following table shows the number of units produced each month and the total cost incurred:

Units

Cost
($ ‘000)

January

100

40

February

400

65

March

200

45

April

700

80

May

600

70

June

500

70

July

300

50

Calculate the regression line, y = a + bx

5 Problems with regression analysis

6 The correlation coefficient

YouTube video

Pearson’s correlation coefficient is a measure of how linear the relationship between variables is.

A correlation coefficient of +1 indicates perfect positive linear correlation, whereas -1 indicates perfect negative linear correlation.

The further away from + or – 1, the less linear correlation exists.

The correlation coefficient may be calculated using the following formula (which is given to you in the examination)

r=nΣxy-ΣxΣynΣx2-Σx2nΣy2-Σy2

Using the data in example 2, calculate the correlation coefficient

Show answerHide answer

Answers 2 & 3

x

y

xy

x2

y2

1

40

40

1

1,600

4

65

260

16

4,225

2

45

90

4

2,025

7

80

560

49

6,400

6

70

420

36

4,900

5

70

350

25

4,900

3

50

150

9

2,500

28

420

1,870

140

26,550

b=nΣxy-ΣxΣynΣx2-Σx2=(7×1,870)-(28×420)(7×140)-(28×28)=1,330196=6.7857a=Σyn-bΣxn=4207-6.7857×287=60-27.1428=32.8572

  y = 32.86 + 6.79x

or:   y = 32,857 + 67.9x

    (if × and y are actual units and $’s)

Coefficient of correlation:

r=nΣxy-ΣxΣynΣx2-Σ2nΣy2-Σ2=7×1,870-28×4207×140-2827×26,550-4202=+1330196×9,450=+0.98

7 Coefficient of determination

The coefficient of determination is the square of the coefficient of correlation (r2).

It is a measure of how much of the variation in the dependent variable is ‘explained’ by the variation of the independent variable.

Practice questions

Semi-Variable Costs

5 questions

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

Open chapter practice