Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

High-Low Method Formula

High-Low Method Formula

Formula of High-low Method  (Table of Contents)

  • Formula
  • Example

What is High-low Method Formula?

In cost accounting, high-low method refers to the mathematical technique that is used to separate fixed and variable components that are otherwise part of the historical cost that is mixed in nature i.e. partially fixed and partially variable. The high-low method comprises the highest and the lowest level of Activity and comparison of the total costs at each level.

Under the high-low method, the variable cost per unit is calculated by initially deducting the Lowest Activity cost from the Highest Activity cost, then deducting the number of units at lowest activity from that of the highest activity and then dividing the former by the latter. Mathematically, it is represented as,

Variable Cost Per Unit = (Highest activity cost – Lowest activity cost) / (Highest activity units – Lowest activity units)

Once the variable cost per unit has been determined, the fixed cost can be calculated either by deducting the product of variable cost per unit and the highest activity units from highest activity cost or by deducting the product of variable cost per unit and lowest activity units from the lowest activity cost.

Mathematically, it is represented as,

Fixed cost = Highest activity cost – (Variable cost per unit * Highest activity units)

or

Fixed cost = Lowest activity cost – (Variable cost per unit * Lowest activity units)

Explanation of the High-low Method Formula

The formula for the calculation of variable cost and fixed cost under the high-low method is derived by using the following steps:

Step 1: Firstly, determine the highest activity units and the lowest activity units from the available costing chart.

Step 2: Next, determine the corresponding cost of production at the level of highest and level activity units.

Step 3: Next, deduct the lowest activity cost from the highest activity cost to take out the fixed cost component such that the remaining is the variable component corresponding to the incremental number of units.

Variable cost component = Highest activity cost – Lowest activity cost

Step 4: Next, the incremental number of units is calculated by deducting the number of units at the lowest activity from that of the highest activity.

Incremental number of units = Highest activity units – Lowest activity units

Step 5: Next, the variable cost per unit is calculated by dividing the expression in step 3 by the expression in step 4 as shown above.

Step 6: Next, the fixed cost is calculated either by deducting the product of variable cost per unit and the highest activity units from highest activity cost or by deducting the product of variable cost per unit and lowest activity units from the lowest activity cost as shown above.

Example of High-low Method Formula (with Excel Template)

Let us take the example of a company that wants to determine the expected amount of factory overhead cost that it will incur in the upcoming month. The factory overhead cost in the previous three months is as follows:

Example 1

The company is planning to produce 7,000 units in March 2019 on the back of buoyant market demand. Help the company accountant to calculate the expected factory overhead cost in March 2019 by using the high-low method.

Solution:

Following are the given data for the calculation of the high-low method.

HL method formula example 1.1

Therefore, using the above information variable cost per unit can be calculated as,

HL method formula example 1.2

  • Variable cost per unit = ($60,000 – $50,000) / (6,000 – 4,000)

Variable cost per unit will be-

HL method formula example 1.3

  • Variable cost per unit = $5 per unit

Now, the fixed cost can be calculated as,

HL method formula example 1.4

  • Fixed cost = $60,000 – ($5 * 6,000)

Fixed Cost will be –

fixed cost example 1.5

  • Fixed cost = $30,000

Therefore, the expected overhead cost for the month of March 2019 for 7,000 units can be calculated as,

expected overhead cost example 1.6

  • Total cost = Fixed cost + Variable cost per unit * Number of units
  • = $30,000 + $5 * 7,000

Expected Overhead Cost will be-

expected overhead cost example 1.7

  • Total Cost = $65,000

Therefore, the overhead cost is expected to be $65,000 for the month of March 2019.

Relevance and Uses

It is very important to understand the concept of high-low method because it is usually used in the preparation of the corporate budget. It is used in estimating the expected total cost at any given level of activity on the basis of the assumption that past performance can be practically used to project cost in the future. The underlying concept of the method is that the change in the total costs is the variable cost rate multiplied by the change in the number of units of activity.

Nevertheless, it has its limitations such as, the high-low method assumes a linear relationship between cost and activity which may be over-simplification of cost behavior. Further, the method may be easy to understand, but the high-low method is not considered reliable because it ignores all the data except for the two extreme ones.

You can download this High-Low Method Formula from here – High-low Method Formula Excel Template

Recommended Articles

This has been a guide to High-Low Method Formula. Here we discuss how to create a high-low cost model and calculate variable cost and fixed cost per unit along with the practical examples and downloadable excel sheet. You can learn more about financing from the following articles –

  • Cost Accounting Course
  • Income Statement of Variable Costing
  • Variable Costing Calculation
  • Direct Costs Calculation

The post High-Low Method Formula appeared first on .



This post first appeared on Free Investment Banking Tutorials |WallStreetMojo, please read the originial post: here

Share the post

High-Low Method Formula

×

Subscribe to Free Investment Banking Tutorials |wallstreetmojo

Get updates delivered right to your inbox!

Thank you for your subscription

×