Semi Variable cost in a Flexed budget

SammyRPA
Registered Posts: 26 Dedicated contributor 🌟 🐵 🌟
Hi everyone
I hope someone can help me please, I have gone BLANK
What do you do with a semi variable cost in a flexed budget?? I obviously know about SV costs (hi-low etc etc) but I just don't understand what to do with them in the flexed budget? Example: Energy is 215,000 @ budget 76,000 units - its then 201,215 @ actual 72,000 units It states that the variable element is £2.50 per unit and gives the Flexed budget (72,000) at 205,000 giving a favourable variance of 3750 It is not sinking in someone PLEASE explain
Thank you! XO



0
Comments
-
Hi SammyRPA
I'm not sure I understand your question!! All you calculations are correct...(72000 Units *£2.5 per unit) + £25,000 fixed element = £205,000. The actual is £201,215 so you have a fav variance of 3750. And thats is!! Hope this helps!!0 -
Sammy and Kelly
I disagree with both of you.
I make the variance £3,785 favourable
See the attached excel worksheet
Kelly's method and mine are identical arithmetically even though our layouts are different
Total budgeted cost £215,000 less total budgeted variable cost of £2.50/unit x 76,000 units = £215,000 - £190,000 = £25,000- Find the cost in the flexed budget I have copied Kelly's answer (72000 Units *£2.5 per unit) + £25,000 fixed element = £205,000
- Subtract the actual cost from the flexed budget total cost £205,000 - £201,215 = £3,785 (which is favourable because the actual cost was a lower value than the actual cost)
0 -
Thank you SO much both of you!! I knew it would be simple!!! Can't thank you enough for helping me with that mental block..Lifesavers
xo
0 -
Your dead right SandyHood. I didnt actually calculate the variance, I assumed the figure Sammy had given was correct. Should have got a calculator to that one!!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 (Covid-19)
- 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 off-topic 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