Home For AAT student members AQ 2016 Professional Diploma in Accounting Management Accounting: Budgeting

operating report-semi-variable cost

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


  • PeterCPeterC Registered, Tutor Posts: 196
    This scenario does not require high-low, all it requires is:
    Total cost = fixed cost + total variable cost
    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.