May 2022
Karen Groves explains how to approach a budgeting and variance exam style question and tests your knowledge on the subject.
Budgeting and variances are assessed at AAT Levels 2, 3 and 4. At Level 2, only a basic level of knowledge is required, however you will still be required to calculate variances and identify if these are adverse or favourable.
Budgeting helps a business to manage sales and costs and helps managers control the business. The budget is based on what you expect to happen in a future period, for example, next month. The budget is then compared to the actual amounts and any difference, or variance, can be investigated to identify the cause. For example, an increase in material cost could be due to a shortage nationally of materials, which in turn, has increased the purchase price.
A favourable variance occurs when our costs are lower than expected or our sales are higher than expected.
An adverse variance occurs when our costs are higher than expected or our sales are lower than expected.
As an AAT tutor, I get many questions on how to calculate the variances, with students getting confused on which figures to base their calculations on.
We will look at an example question, and the way this should be approached.
Example
The following information has been provided for the month of April 2022, detailing budgeted and actual costs for the month:
The first step is to calculate the variances as follows, being the difference between the budget amount and actual amount, for example:
Direct materials £33,580 – £35,690 = £2,110
We are advised that any variance greater than 6% of budget is considered to be significant and should be investigated further.
The next step is to calculate the variance percentage, as follows, being the variance amount divided by budget x 100, for example:
Direct materials £2,110 ÷ £33,580 x 100 = 6.28%
Direct labour £1,500 ÷ £20,000 x 100 = 7.5%
Overheads – 0%
Admin costs £700 ÷ £12,000 x 100 = 5.83%
Note: In an exam question you may also be asked to show the percentage variance as calculated above, so be sure to take the variance amount and divide by the budget amount (not the actual amount, in error).
Now have a go!
The following information has been provided for the month of May 2022, detailing budgeted and actual costs for the month. Any variance greater than 5% is deemed as significant and should be investigated further.
Calculate the variances and identify if the variances are significant or not.
Answers
Direct materials £46,270 – £42,560 = £3,710
Direct labour £30,000 – £29,000 = £1,000
Overheads £20,000 – £24,000 = £4,000
Admin costs £15,000 – £15,500 = £500
Direct materials £3,710 ÷ £46,270 x 100 = 8.02%
Direct labour £1,000 ÷ £30,000 x 100 = 3.33%
Overheads £4,000 ÷ £20,000 x 100 = 20%
Admin costs £500 ÷ £15,000 x 100 = 3.33%
• Karen Groves is an AAT tutor and AAT Course Director at e-Careers
