semi variable costs
Options
donnas1977
Registered Posts: 182 Dedicated contributor 🦉
help, working on a task where we are required to calculate and estimate the profit per batch. i have managed to work out the variable costs ok per batch but confused on how to work out the semi variable costs. we are also told that these should be calculated using highlow method. if 3000 batches are sold then the semi variable costs will be 7,380 and there is a constant unit variable cost up to this volume. i have had a total brain freeze on this calculation. any help is appreciated.
batches produced and sold 1200 1500 2000
sales revenue 36000 45000 60000
direct materials 5400 6750 9000
direct labour 12600 15750 21000
overheads 7200 9000 12000
semi variabe costs 3780
variable elemnent
fixed element
total cost 28980
total profit 7020
profit per batch 5.85
thanks
Donna
batches produced and sold 1200 1500 2000
sales revenue 36000 45000 60000
direct materials 5400 6750 9000
direct labour 12600 15750 21000
overheads 7200 9000 12000
semi variabe costs 3780
variable elemnent
fixed element
total cost 28980
total profit 7020
profit per batch 5.85
thanks
Donna
0
Comments

Hi Donna,
From your table thing it's not clear where the 3780 falls under, mainly because for some reason the forums don't allow tabs to work...
Anyways, the high low method is calculated by the difference between the highest cost and lowest cost for the semi variable costs and the difference between the amount of batches/ units.
As you only got two of these costs given, you can calculate it by deducting the lowest costs from the highest costs.
In this case it is 7,380 less 3,780 and the 3000 minus 1200 (assuming 1200 for example, but that is something you would know).
As both have the fixed costs part in the costs, by deducting each, you are left with the variable cost per unit for the difference in the units. You can then calculate the variable cost per unit, by dividing the difference in costs by the difference in units.
You now got the variable cost per unit, to calculate the fixed part, you now go back to the 3000 units (or the others). You deduct the variable part of the costs from the total costs and this gives you the fixed part.
You can use the other one for double check, something which I usually did, just to make sure I didn't make a mistake somewhere.
In this case it would give you the following calculation:
3000  1200 = 1800 = difference in number of units
7380  3780 = 3600 = difference in price for those units
3600 / 1800 = 2 = variable cost per unit
2 * 3000 = 6000 = variable cost for 3000 units
7380  6000 = 1380 = difference between total and variable costs, so this is the amount of fixed costs
Control figure:
2 * 1200 = 2400
3780  2400 = 1380
Now you know the variable and fixed costs split, you would be able to calculate for any amount of units/ batches how many the costs would be.
The fixed costs are fixed, therefore stay the same and the variable cost is 2 per unit/ batch.
Hope this helps!
Cheers,
Rinske0 
thanks Rinske for explanation, it has helped alot. the 3780 comes from the 1200 batch.0

Rinske, you are a life saver mate. thank you ever so much. These blimmin bpp books are useless!0

Rinske you are great
0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 12.4K For AAT students
 296 NEW! Qualifications 2022
 153 General Qualifications 2022 discussion
 11 AAT Level 2 Certificate in Accounting
 54 AAT Level 3 Diploma in Accounting
 76 AAT Level 4 Diploma in Professional Accounting
 8.8K For accounting professionals
 23 coronavirus (Covid19)
 271 VAT
 92 Software
 271 Tax
 135 Bookkeeping
 7.2K General accounting discussion
 198 AAT member discussion
 3.8K For everyone
 38 AAT news and announcements
 345 Feedback for AAT
 2.8K Chat and offtopic discussion
 581 Job postings
 16 Who can benefit from AAT?
 36 Where can AAT take me?
 42 Getting started with AAT
 26 Finding an AAT training provider
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 66 AAT membership