Budgeting - Variance Analysis
cazalino
Registered Posts: 44 Epic contributor 🐘
Hi I have my exam on Thursday and am stuck on the attached question. Can anybody tell me how i calc the answers please - thank you guys
0
Comments
-
Get used to these, there's a lot more of them in Financial Performance!
The standard direct labour cost of production is simply flexing the budget to get the budgeted cost of labour for actual output, so:
1,728,000 / 18,000 x 17,000 = 1,632,000. It's worth calculating that the budgeted hourly rate is 1,728,000 / 18,000 = 6.
Rate variance is the same as price variance when thinking about materials. Using PAUS, price variance uses actual quantities. We're isolating the difference made by the price only. So:
Standard price of actual quantity used LESS actual price of actual quantity used. We know standard rate is 6/hr (above), we've actually used 280,500 hours (from the question) and it actually cost 1,626,900 (again from the question), so:
280,500 x 6 - 1,626,900 = 56,100 F
Efficiency variance is the same as usage variance, and PAUS says usage variance uses standard pricing. So:
Standard price of standard hours for level of production LESS standard price of the actual hours for the level of production. We're separating the difference made by the number of hours worked only. So:
1,632,000 (you already worked out the standard cost of the level of production at the start) - 280,500 x 6 = 51,000A.
The labour cost variance is the total of the two, so 56,100F less 51,000A = 5,100F. Personally I like to work this out first to use as a check against the other two - the formula is the standard cost of actual production less the actual cost of actual production. It's worth trying to figure out for yourself why each of these formulae work, as when you've got twenty-odd different ones floating around in FNPF, it's a lot easier if you can see from the question the formula needed, rather than trying to remember which one off your memorised list is relevant!0 -
Thank you, I don't like these lol! But thankfully it never came up in the exam!0
-
The budgeting hourly rate works out as 96? (1,728,000/18,000). Where has the 6 come from?0
-
Sorry, typo in my answer. If you look at the question, it's £1,728k for 288k hours. I've included the wrong figure of 18k which is units produced. 1,728/288 = 6.0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 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