Budgeting Question, PA1
Clareymary
Registered Posts: 9 Regular contributor ⭐ 😼 ⭐
hi
I wonder if someone could kindly help me working out the below answer...its taken from practice assessment 1, question 1.7,monthly operating report for calculating energy costs for the flexed budget..
data is:
original budget energy cost is £60860, actual energy cost is £65080, what is the energy cost for the flexed budget of 192000 units?
original budget unit qty is 178000 units, flexed budget is 192000 units
energy costs are semivariable, with a fixed element budgeted of £12800 per month
answer is £64640 but how do I get there?!
any help is greatly appreciated:)
I wonder if someone could kindly help me working out the below answer...its taken from practice assessment 1, question 1.7,monthly operating report for calculating energy costs for the flexed budget..
data is:
original budget energy cost is £60860, actual energy cost is £65080, what is the energy cost for the flexed budget of 192000 units?
original budget unit qty is 178000 units, flexed budget is 192000 units
energy costs are semivariable, with a fixed element budgeted of £12800 per month
answer is £64640 but how do I get there?!
any help is greatly appreciated:)
0
Comments

Hi Clareymary,
Original Budgeted cost is £60,860. Take away the fixed element of £12,800 which leaves £48,060
now divide by original budget qty £48,060 / 178000 = £0.27p
multiply by flexed budget of 192,000 units = £51,840
and lastly add in the fixed amount of 12800 = £64,640
actual cost is 65080 giving an unfavourable variance of £440,
Regards
Kevin0 
hi thank you so much for your help. it now makes so much sense!:)
0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 234 NEW! Qualifications 2022
 133 General Qualifications 2022 discussion
 7 AAT Level 2 Certificate in Accounting
 31 AAT Level 3 Diploma in Accounting
 55 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 272 VAT
 91 Software
 272 Tax
 135 Bookkeeping
 7.3K General accounting discussion
 201 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
 586 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
 47 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership