High/ Low method  ECR
ryannnnnnnnnnnnn
Registered Posts: 13 Regular contributor ⭐ ? ⭐
Hi All,
Can someone please give me brief reminder as o what the High/low method is and how to go about answering such a question in a simulation
Thanks
Can someone please give me brief reminder as o what the High/low method is and how to go about answering such a question in a simulation
Thanks
0
Comments

The high low method is a method of calculating and predicting the trends (after removing the seasonal variations).
It exists basically of in a group of figures picking the highest number and the lowest number. In general it is the first and last figure of a row.
The basic calculation is:
(HL)/P1
H = highest
L = lowest
P = number of periods
Highest  lowest = difference
Calculate the number of periods in between the highest and lowest number (aka total number of periods minus 1).
Difference / the answer above is the increase per period.
As example:
Sales Year 1: 10,000
Sales Year 2: 10,200
Sales Year 3: 10,600
Sales Year 4: 10,900
Sales Year 5: 11,000
According to the high low method the calculation would be:
11,000 minus 10,000 is 1,000
Number of years: 5 minus 1 is 4
Average increase in sales: 1,000 divided by 4 is 250.
In order to calculate the sales in year 6, you can now use the calculated trend:
6 years, so 5 times an increase is: 5 times 250 plus the basis of 10,000 is 11,250.
Hope this helps!
Cheers,
Rinske0 
what the High/low method is
what the High/low method is
I have to assume that you know the different cost behaviours.
This method applies to semivariable costs
On one of my blogs I use a shirt ironing service as an example.
The staff are paid on a semivariable cost basis, a rate per shirt (variable with shirts ironed) and a weekly amount (the fixed part of the cost).
Staff..............................shirts.....................................wages
Lara.................................138....................................£281.40
Becky...............................151....................................£285.30
Helen................................170....................................£291.000 
You need to look at the difference between the number of shirts ironed (units produced) and the cost.
In this example:
Find the highest number of units and cost and take away the lowest units and cost to find the extra cost of the extra units.
Then divide the extra cost by the extra units to find the variable cost per unit.
Then take one of the examples (say Helen) and write down the total wage cost
Then take away the total variable cost part of her wages (variable cost per unit x units)
To find the fixed cost
................. units..... Cost
High............. 170..... £291.00
Low.............. 138..... £281.40
Difference.......... 32..... £9.60
Variable cost per unit (£9.60/32) £0.30
Then looking at Helen
Total cost..... £291.00
Total variable cost (170 units x £0.30)..... £51.00
Total fixed cost..... £240.000 
Hilo has been the subject of discussion among lecturers at master classes.
I do not expect the exam will include semivariable costs where the technique is needed, but simulations do include semivariables and do require calculations using hilo.
Typically you will be given the costs of production for several levels of production.
I recommend that you then work through the costs and identify whether a cost is:
(a) variable
(b) fixed
(c) neither variable nor fixed
If a cost is variable or fixed, then you can work out the cost at a new level.
If it isn't variable or fixed then it will either be a stepped fixed cost or a semivariable. Usually the question will give a clue if a cost is stepped. So without a clue, then you can assume a cost is semivariable.
Once you've made the decision that the cost is semivariable, then the hilo applies.
Imagine a new member of staff has arrived at the shirt ironing service: Cindy
How much would her wages be (assuming the same rate applies as the others) if she irons 168 shirts?0 
We know her fixed wage is: £240.00
and that she is paid £0.30 per shirt
So she will be paid:
........................................................£. p
Variable 168 @ £0.30 per shirt...............50.40
Fixed ..............................................240.00
Total ..............................................290.400 
Haha! I'm going back to bed I think. Mixing all my stuff up today.
Thanks Sandy!0 
Rinske
You are fine
A first class explanation of using the high and low values in a trend to identify the average change between one period and the next.
Perfect
I'm doing forecasting from trends tomorrow, so I hope you won't mind me using your example as an illustration.0 
I don't mind at all. I'm actually feeling flattered now!
Thanks for the clarification!0 
Rinske
You are fine
A first class explanation of using the high and low values in a trend to identify the average change between one period and the next.
Perfect
I'm doing forecasting from trends tomorrow, so I hope you won't mind me using your example as an illustration.
Thank you for the support and encouragement0
Categories
 All Categories
 1.2K Books to buy and sell
 2.3K General discussion
 18.9K For AAT students
 248 NEW! Qualifications 2022
 138 General Qualifications 2022 discussion
 8 AAT Level 2 Certificate in Accounting
 33 AAT Level 3 Diploma in Accounting
 59 AAT Level 4 Diploma in Professional Accounting
 8.9K For accounting professionals
 23 coronavirus (Covid19)
 274 VAT
 92 Software
 274 Tax
 136 Bookkeeping
 7.3K General accounting discussion
 193 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
 589 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
 48 Distance learning and other ways to study AAT
 25 Apprenticeships
 65 AAT membership