Home For AAT student members AQ 2016 Professional Diploma in Accounting Management Accounting: Budgeting
Current updates regarding coronavirus (Covid-19) and the precautions AAT are taking will be continually updated on the below page.

Please check this link for the latest updates:
We hope you are all safe and well and if you need us we will be here. 💚


operating report-semi-variable cost

GOO DAY
I have a situation here..Please help me how to calculate semi variable cost given a note that Energy cost is semi variable .The fixed element is budgeted at GBP 12,800 per month. Original budget sale volume is 178,000 units and Actual volume is 192,000.
Calculate the flexed budget where Original budget is GBP 60,860 and Actual is GBP 65,080.

I have tried high and low method but it does not work ..please help with another formula or workings.
with regard

Comments

  • PeterCPeterC Registered, Tutor Posts: 150
    This scenario does not require high-low, all it requires is:
    Total cost = fixed cost + total variable cost
    So,
    for the budget of 178,000 units
    Total variable cost = Total cost - fixed cost = £60,860 - £12,800 = £48,060
    Variable cost per unit = Total variable cost/Number of units = £48,060/178,000 = £0.27

    For the flexed budget of 192,000 units
    Total cost = fixed cost + total variable cost = £12,800 + (£0.27 x 192,000) = £64,640

Sign In or Register to comment.