Can someone help me with practice assement 1 budgeting task 7 please thank you
clementina
Registered Posts: 12
Can someone help me with practice assement 1 budgeting task 7 please thank you
0
Comments

*1 Sales revenue: £1377000 (£1281600/178000*192000)
£1377000Actual £1382400 Flexed =5400 Adverse
*2 Materials: 500100(flexed:462800/178000*192000)
£500100Actual £499200Flexed= 900Adverse
*3 Labour: £516500(480600/178000*192000)
£516500Actual£518400= 1900Fav
*4 Distribution: £74200(67640/178000*192000)
£74200Actual£72960Flexed = 1240Adverse
*5 Energy: £65080(£60860£12800/17800*192000)+££12800
=£65080(£48060/178000*192000)+£12800
£65080Actual£64640Flexed=440Adverse
*6 Equipment:
ACTUAL:
178000units/30000 budgeted increase units=5.93......
30000*5 =150000
.93... = 30000 (any additional unit)
EQUAL 180000 ACTUAL UNITS
BUDGET:
192000units/30000 budgeted increase units =6.4
30000*6 = 180000
.4 = 30000
EQUAL 210000 BUDGETED UNITS
SO £28600( £24000/180000*210000)
£28600£28000 FLEXED BUDGET =600ADVERSE
NOTE: You can just round up the answer you get from dividing the ACTUAL & BUDGETED UNITS BY BUDGETED INCREASE IN UNITS to the nearest whole number.
ie 192000units/30000= 7 and then MULTIPLY it by the BUDGETED INCREASE UNITS 30000 (7*30000 = 210000 as calculated above for BUDGETED UNITS).
ADD all COSTS FAVS and DEDUCT all ADVERSES
1900+100+780 (900A+1240A+440A+600A+900A)
=2780F4080A = 1300
FLEXED ACTUAL VARIANCE
Sales revenue 1382400 1377000 5400
TOTAL 1295600 1296900 1300
please see above workings for FLEXED and ACTUAL figures
OPERATING PROFIT/LOSS 86800 80100 6700
3 
Thank you0

I had a problem with Stepped Costs. Thank you for the explanation. Exam on Friday, wish me luck!0

Good luck0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 247 NEW! Qualifications 2022
 137 General Qualifications 2022 discussion
 8 AAT Level 2 Certificate in Accounting
 33 AAT Level 3 Diploma in Accounting
 59 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 274 VAT
 92 Software
 274 Tax
 136 Bookkeeping
 7.3K General accounting discussion
 193 AAT member discussion (AATQB, MAAT, FMAAT and AAT Licensed Accountants and Bookkeepers)
 3.8K For everyone
 39 AAT news and announcements
 352 Feedback for AAT
 2.8K Chat and offtopic discussion
 589 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