In the previous post about mixed cost, we stated that a mixed cost is just the sum of the variable and fixed components. This is fairly easy to deal with when we are dealing with an external cost where we are given the variable rate and the fixed cost. In business, many mixed costs are actually generated internally. Therefore, the variable and fixed components are not clear. We must find a way to calculate the fixed and variable components.

Make more money now! Try our JOB search.

There are a number of ways to calculate the cost formula for a mixed cost. In this post, we will focus on the high-low method. This method is not the most precise method but it is the easiest to calculate. It does not require spreadsheet or graphing software.

Why the high-low method works

Below is some data from an oil change service business.

The business has fixed and variable costs but wants an easy way to do cost planning for future budgets. The company would like you to write a mixed cost formula for planning purposes. It might seem daunting at first but it’s really a lot easier than you might think.

Step 1 – Find the high point and the low point

Since this is called the high-low method, we first need to determine the highest point and the lowest point in the range. Because the variable rate and fixed costs are not always 100% constant, the cost should not be used. Since the number of oil changes is a consistent, reliable measure, we should use that to determine the high and low points. Looking at the data in the chart above, what would you choose as the high and low points? April is the high point with 2,950 oil changes and January is the low point with 2,200 oil changes.

Once you have picked the high point and the low point, you  can throw out the rest of the data. You no longer need it.

Step 2 – Find the variable rate

You might be wondering how we are going to jump to solving for the variable rate when it doesn’t seem like we have a whole lot of information. We have more information than you might think.

Let’s look at these two points on a graph.

If you read the post on variable cost or the post on mixed cost, you might remember that we talked about slope. I know that slope is terribly boring and something that you might be trying to forget from your math classes, but is actually important here and makes this concept much easier to understand.

We said in the earlier posts that variable rate is the slope of the line. That means that for every additional oil change performed, the total cost increases by the variable rate. In January (the low point), the company performed 2,200 oil changes with a total cost of \$9,860. In April, the company performed 750 more oil changes. Those additional oil changes cost the company an additional \$1,725. Over the course of 750 oil changes, cost increased \$1,725. That also means that the variable cost of 750 oil changes is \$1,725.

Since we know that the variable cost of 750 oil changes is \$1,725, we can divide to calculate the variable rate. The variable rate is \$2.30.

Let’s go through the calculation step by step so you can see where I got all the numbers.

First calculate the change in cost and the change in activity.

Change in Cost = \$11,585 – \$9,860 = \$1,725

Change in activity = 2,950 – 2,200 = 750

Next we will divide the change in cost by the change in activity to calculate the variable rate.

Variable rate = \$1,725 / 750 = \$2.30

Most textbooks will use the following formula for variable rate using the high-low method:

If you’ve looked at that formula before and thought “huh?!?”, I agree. Many times in managerial accounting, understanding what is actually happening is much more helpful in solving the problem than trying to memorize the formulas. Just remember that the increase in cost is all variable cost. If you calculate how much the activity changed, you now have the total variable cost for the additional activity. That is enough information to calculate the rate.

Step 3 – Find the fixed cost

The formula for mixed cost is:

Total cost = Rate X Activity + Fixed Cost

We need to fill in all the additional information so that we can solve for the fixed cost. We clearly have the rate. We solved for that above.

Total cost = \$2.30 X Activity + Fixed Cost

Where could we get figures for total cost and the activity level for that cost? Wouldn’t it be nice if we had some data for total monthly cost and the activity associated with it?

Well, it’s a good thing we have the high and low points. The data gives us exactly what we need. We have the total monthly cost for two of the months and the activity associated with those months. Brilliant!

Note: You must use the figures from either the high point or the low point since the variable rate was calculated based on those numbers. The high and low points will give you the same fixed cost (within a few cents if you had to round the variable rate).

Plug either the high point or low point into the cost formula and solve for fixed cost.

\$11,585 = \$2.30 X 2,950 + Fixed Cost

Fixed Cost = 4,800

OR

\$9,860 = \$2.30 X 2,200 + Fixed Cost

Fixed Cost = \$4,800

Step 4 – Write the cost formula

Now that you have the variable rate and the fixed cost, you can write a cost formula for planning. The monthly cost of oil changes is:

Total Monthly Cost = \$2.30 X number of oil changes + \$4,800

Related Video

Mixed Cost and the High-Low Method

Related pages

what is contra assettotal cost of goods manufacturedprofit margin ratio formula accountingabc costing stepsdefinition of checkbook registercalculate variable cost per unitstockholders limited liabilitywages payable on balance sheetoperating profit calculatorprovision for expenses journal entryjournal entry for advertising expenseaccounting prepaymentwashington state payroll taxes calculatorcontribution sales ratioamortized bondsalvage value depreciationhow to calculate bad debt provisionmanagerial accounting and decision makingunbilled accounts receivable journal entrypv bond calculatorafter tax salvage value calculatorbank reconciliation occurs whenfifo calculator onlineadjusting entries for inventoryexamples of contra accountscalculating allowance for doubtful accountsis prepaid insurance a current assetwhat is the journal entry for accounts payableadjusting entries examplewhat is favourable variancemedicare tax on paycheckhow to prepare a schedule of accounts receivableentries for depreciationprepaid insurance on balance sheethow to prepare adjusting entries from a trial balancejournal entry for income tax paidaccounting worksheet problemsexpenses follow the same debit and credit rules asjournal entry for invoicefinding retained earnings from balance sheetwho pays medicare taxaccount receivable debit or creditvariable costing examplehow much withholding taxaccelerated depreciation 2013list of overhead expensescheckbook accountingcalculate treasury stockcalculating discount factorwhat is a contribution margin ratiobasics of accounting entriesunamortized premium on bonds payablepresent value of annuitydouble declining balance tablepresent value of annuity of \$1 tableaccrued expense journaljournalize closing entriesis direct labor a fixed costmanagerial accounting reportssales return and allowances normal balancemedicare tax on paycheckis prepaid expense a current assetthe accounting equation explainedcontribution margin meaningweighted average inventory costingtake home pay calculator txwhat is the formula for predetermined overhead ratewhat is product cost in managerial accountingwhen does an account become uncollectiblebalance sheet reconciliation procedurehow to journalize notes payabledistinguish between trial balance and balance sheetaverage inventory cost methodhow to find total fixed cost formulaexamples of equity accountswhat is employer portion of payroll taxthe replacements merchcost ratio formulabond computations straight line amortization