Variance Calculations
Options
mazzy1980
Registered Posts: 3
Hi all, is there anyone that could go through what I have worked out on this question. I am not sure I have done it quite right!
Budgeted activity:
Production of units = 5,000
Direct materials = 1,000 litres, £10,000
Direct labour = 4,000 hours, £20,000
Actual activity:
Production of units = 6,000
Direct materials = 1,100 litres, £11,100
Direct labour = 4,500 hours, £25,000
I have calculated the standards using the budgeted data:
Labour:
4,000 hours/5,000 units=0.8 hours per unit
£20,000/4,000 hours=£5 per hour
Materials:
1,000 litres/5,000 units=0.2 litres per unit
£10,000/5,000 units=£2 per litre
Calculate the direct labour rate variance:
Actual hours 4,500 x £5 per hour = £22,500
Difference = £22,500-£25,000=£2,500 (adverse)
Calculate the direct labour efficiency variance:
Actual output 6,000 x 0.8 hours per unit = £4,800
Difference = 4,800-4,500=300
In monetary = 300 x £5 = £1,500 (favourable)
Calculate the direct material price variance:
Actual usage 1,100 x £2 per litre = £2,200
Difference = £2,200-£11,100=£8,900 (adverse)
Calculate the direct material usage variance:
Actual output 6,000 x 0.2 litres = 1,200 litres
Difference =1,100 - 1,200 = 100 litres
In monetary = 100 x £2 = £200 (adverse)
Budgeted activity:
Production of units = 5,000
Direct materials = 1,000 litres, £10,000
Direct labour = 4,000 hours, £20,000
Actual activity:
Production of units = 6,000
Direct materials = 1,100 litres, £11,100
Direct labour = 4,500 hours, £25,000
I have calculated the standards using the budgeted data:
Labour:
4,000 hours/5,000 units=0.8 hours per unit
£20,000/4,000 hours=£5 per hour
Materials:
1,000 litres/5,000 units=0.2 litres per unit
£10,000/5,000 units=£2 per litre
Calculate the direct labour rate variance:
Actual hours 4,500 x £5 per hour = £22,500
Difference = £22,500-£25,000=£2,500 (adverse)
Calculate the direct labour efficiency variance:
Actual output 6,000 x 0.8 hours per unit = £4,800
Difference = 4,800-4,500=300
In monetary = 300 x £5 = £1,500 (favourable)
Calculate the direct material price variance:
Actual usage 1,100 x £2 per litre = £2,200
Difference = £2,200-£11,100=£8,900 (adverse)
Calculate the direct material usage variance:
Actual output 6,000 x 0.2 litres = 1,200 litres
Difference =1,100 - 1,200 = 100 litres
In monetary = 100 x £2 = £200 (adverse)
0
Comments
-
A good answer with just one error.
The labour variances are correct
Material variance should be £100 adv (price) and £1,000 fav (usage)
The problem is in your calculation of standards for material. You have:
£10,000/5,000 units=£2 per litre
This would be £2 per unit!0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 18.9K For AAT students
- 269 NEW! Qualifications 2022
- 148 General Qualifications 2022 discussion
- 9 AAT Level 2 Certificate in Accounting
- 44 AAT Level 3 Diploma in Accounting
- 65 AAT Level 4 Diploma in Professional Accounting
- 8.9K For accounting professionals
- 23 coronavirus (Covid-19)
- 274 VAT
- 92 Software
- 274 Tax
- 138 Bookkeeping
- 7.3K General accounting discussion
- 195 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 352 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 590 Job postings
- 17 Who can benefit from AAT?
- 36 Where can AAT take me?
- 44 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 65 AAT membership