Pev help!!!
Options
GemmaLouise
Registered Posts: 56 Regular contributor ⭐
Hiya there!
I am extremely stuck on a question from my student kaplan notes  i have now been looking at it for 3 days!!!
Its quite long but here goes...
The standard cost of a sweater...
Direct Material: Quantity: 3kgs Unit Price: £4 Total Cost: £12
Direct Labour: Quantity: 1hr Unit Price: £6 Total Cost: £6
Fixed O/H Prod: Quantity: 1hr Unit Price: £2 Total Cost: £2
Total Standard Cost: £20
Actual material purchased: 25000kg
Actual cost of purchases £110000
Actual production: 6500 sweaters
Actual material used 20800kg
Direct labour hours actually worked 7150
Labour rate variance: 1430 (A)
Budgeted Labour hours: 7500
Actual Fixed Overheads £15850
There was no change in stock of the sweater held during the month
Calculate:
1a) The standard usage of material
b) The standard labour time
c) The actual price paid per kg
2a) The material price variance
The material usage variance
c) The labour efficiency variance
d) The total cost of labour used
e) The fixed overhead expenditure variance
f) The fixed overhehad volume variance
g) The fixed overhead efficiency variance
h) The fixed overhead capacity variance
I am fine upto 2d, then i dont understand where i get my budged production and my budgeted overhead cost from!
any help would be much appreciated so i can get this thing to reconcile!
Thanks for your time  hope your all having a good weekend!!!!!!
I am extremely stuck on a question from my student kaplan notes  i have now been looking at it for 3 days!!!
Its quite long but here goes...
The standard cost of a sweater...
Direct Material: Quantity: 3kgs Unit Price: £4 Total Cost: £12
Direct Labour: Quantity: 1hr Unit Price: £6 Total Cost: £6
Fixed O/H Prod: Quantity: 1hr Unit Price: £2 Total Cost: £2
Total Standard Cost: £20
Actual material purchased: 25000kg
Actual cost of purchases £110000
Actual production: 6500 sweaters
Actual material used 20800kg
Direct labour hours actually worked 7150
Labour rate variance: 1430 (A)
Budgeted Labour hours: 7500
Actual Fixed Overheads £15850
There was no change in stock of the sweater held during the month
Calculate:
1a) The standard usage of material
b) The standard labour time
c) The actual price paid per kg
2a) The material price variance
The material usage variance
c) The labour efficiency variance
d) The total cost of labour used
e) The fixed overhead expenditure variance
f) The fixed overhehad volume variance
g) The fixed overhead efficiency variance
h) The fixed overhead capacity variance
I am fine upto 2d, then i dont understand where i get my budged production and my budgeted overhead cost from!
any help would be much appreciated so i can get this thing to reconcile!
Thanks for your time  hope your all having a good weekend!!!!!!
0
Comments

My guess would be that as you are given the budgeted labour hours, you would calculate the budgeted production and overhead costs using the standard cost information.
i.e if the standard labour time is 1hr per sweater, and you are budgeted for 7,500 labour hours, your budgeted output will be 7,500 sweaters. To calculate the budgeted overhead, the standard cost is £2 per sweater, therefore £2 x 7,500 sweaters = £15,000
I'm not 100% sure that this is correct as costing was not my strongest subject!!0 
I agree with Richard
If you want to compare my answer with yours, email me.Sandy
sandy@sandyhood.com
www.sandyhood.com0 
thanks for your help!
sandy i have sent an email to the address below your name and i have recieved an auto message out of office reply  is this the right email address??
thankyou!0 
Gemma
Per my reply to your message, I'm not certain that these answers are correct  especially the ones you are interested in RE the overhead variances bur here goes (starting with the answers to 1A):
Standard Material Usage (Based on actual production) = 6,500*3kg = 19,500kg
Standard Labour Time (actual production) = 6,500 * 1 = 6,500hrs
Price per kg = 110,000/25,000 = £4.40
Does this agree with what you have so far?
If so, moving on to question 2:
Material Price Variance = 8,320A (20,800*(4.404.00)) – kgs used (not including stock) multiplied by the difference between actual and budgeted cost
Material Usage Variance = 5,200A ((20,80019,500)*4.00) – kgs used minus standard kgs that should’ve been used multiplied by standard cost
Labour Efficiency Variance = 3,900A ((7,1506,500)*6.00) – difference between actual hours used and standard hours needed for 6500 units multiplied by labour cost
Cost of labour = £44,330 ((7,150*6.00) + 1,430) – the actual hours used at the standard rate plus the adverse variance of 1,430 already calculated in the question. (This equates to an actual cost per hour of £6.20 and 0.20*7,150 = 1,430)
Have we got the same answers up to this point? As of now I’m not so sure of my figures but here goes:
Fixed overhead expenditure variance = 850A (15,850 – (7,500*2.00)) – at an OAR of £2 per the question and a budget of 7,500 hours, you would expect to absorb £15,000 of overheads. You actually spent £15,850, hence the overhead expenditure variance.
Fixed overhead volume variance = 2,000A ((7,5006500)*2.00) – you planned to do 7,500 hours and the standard hours needed for 6,500 units is 6,500hrs.
Fixed overhead capacity variance = 700A ((7,5007,150)*2.00) – the difference between full capacity and what you actually used. You could’ve worked another 350 hours but didn’t, therefore an adverse variance.
Fixed overhead efficiency variance = 1300A ((7,1506500)*2.00) – the difference between the actual hours and the hours you should’ve taken to produce 6,500 units.
These figures can be reconciled but as mentioned, I am not convinced of their accuracy so it could be that I’ve picked the wrong figures to balance to. My reconciliation, rightly or wrongly, is shown below:
Actual cost of actual production: £151,700 ((20,800*4.40)) + 44,330 + 15,850
Less overheads:
8,320A MPV
5,200A MUV
1,430A LRV (Given)
3,900A LEV
850A FOEV
2,000A FOVV
21,700A total variances
151,700 – 21,700 = £130,000 Standard cost of actual production ((6,500*3*4.00) + (6,500*1*6.00) + (6,500*1*2.00))
If someone else could confirm my workings or correct my mistakes if I've gone about this in the wrong way, I would be very grateful.:thumbup1:0 
I have calculated and reconciled the variances, and I agree with all of the answers that Adam has provided.0

I agree with all except the material price variance.
On revision days whenever we have to deal with questions where the stock of raw materials has changed due to purchased and used materials differing, this tends to cause problems.
Remember what the material price variance is intended to show management, so take the increase of 4,200kgs out of the variances and report that separately (it is not a variance).
SandySandy
sandy@sandyhood.com
www.sandyhood.com0 
I thought I'd removed the stock from my calculation?
Thanks for confirming the rest though!:thumbup1:0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.4K For AAT students
 273 NEW! Qualifications 2022
 147 General Qualifications 2022 discussion
 9 AAT Level 2 Certificate in Accounting
 48 AAT Level 3 Diploma in Accounting
 69 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 269 VAT
 91 Software
 271 Tax
 134 Bookkeeping
 7.1K General accounting discussion
 196 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic discussion
 578 Job postings
 16 Who can benefit from AAT?
 36 Where can AAT take me?
 42 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 66 AAT membership