In addition to being easy to use, because the method doesn’t require any kind of tools or programs, it is also inexpensive to implement. Sometimes, the change of activity level increases the fixed cost. For instance, the factory got a monthly production capacity ledger account of 10,000 units and pays a monthly rent of USD 10,000 per month. However, the company needs to produce 15,000 units in some particular month. The high-low method in accounting is used to separate the elements of variable cost and fixed cost from the total cost.
The cost amounts adjacent to these activity levels will be used in the high-low method, even though these cost amounts are not necessarily the highest and lowest costs for the year. Sometimes it is necessary to determine the fixed and variable components of a mixed cost figure. Several techniques are used for this purpose such as scatter graph method, least What is bookkeeping squares regression method and high-low point method. On this page I will explain the use of high-low point method. Since we know the total cost for the month of February was USD 45,000 and the variable cost for the month calculated is USD 25,000. Since we know total cost is a sum of variable cost and fixed cost and we have total cost and fixed cost.
This means that the total monthly cost of electricity changed by $2,000 when the number of machine hours changed by 20,000. This indicates that the variable cost rate was $0.10 per machine hour. The high-low method is a simple technique for computing the variable cost rate and the total amount of fixed costs that are part of mixed costs.
One can overcome this limitation by using the regression analysis, which uses all data points and activity levels. By solving this equation, we will get the variable cost per unit. This slope is nothing but the change in cost due to the change in production. The high low method is very useful for helping management determine not only what total costs will be, but also how much of a certain product to produce. For instance, it does not recognize any other costs except the highest and lowest costs. The variable cost per unit can be found using a simple slope formula. According to the formula below, the variable cost per unit is 75 cents.
The high-low method can be done graphically by plotting and connecting the lowest point of activity and the highest point of activity. The high-low method can also be done mathematically for accurate computation.
Here is a free online High-Low Method calculator to calculate the variable cost per unit, fixed cost and cost volume with ease and simplicity based on the given high and low, cost and unit values respectively. High low method uses the lowest production quantity and the highest production quantity and comparing the total cost at each production level. It QuickBooks uses only the lowest and highest production activities to estimate the variable and fixed cost, by assuming the production quantity and cost increase in linear. It ignores the other points of productions, so it may be an error when the cost does not increase in a linear graph. The two points are not representing the production cost at a normal level.
The first step is to determine the highest and lowest levels of activities and the units produced against each of these levels. Because of the preceding issues, the high-low method does not yield overly precise results. Thus, you should first attempt to discern the fixed and variable components assets = liabilities + equity of a cost from more reliable source documents, such as supplier invoices, before resorting to the high-low method. This method also fails to account for any changes in the fixed or variable cost overtime. All you need for this method is two data values to come up with the cost behavior.
Total production costs assuming 400 units will be produced are calculated for each method given. Note that the equations presented previously are used for these calculations. The cost equations for each of the four methods used in Note 5.15 “Review Problem 5.2”, Note 5.17 “Review Problem 5.3”, Note 5.19 “Review Problem 5.4”, and Note 5.21 “Review Problem 5.5” are shown here.
Estimate costs using account analysis, the high-low method, the scattergraph method, and regression analysis. 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 company performed 2,200 oil changes with a total cost of $9,860.
Since the total electricity cost was $18,000 and the variable cost was calculated to be $12,000, the fixed cost of electricity for the month must have been the $6,000. If we use the lowest level of activity, the total cost of $16,000 would include $10,000 of variable cost (100,000 machine hours times $0.10) with the remainder of $6,000 being the fixed cost for the month. The high-low method comprises the highest and the lowest level of activity and comparison of the total costs at each level. When it comes to cost accounting, the high-low method is an approach that’s used to break mixed costs into either a variable or fixed cost. Although it’s straightforward, it’s important to do multiple analyses because outlier costs from the available data can sometimes misconstrue operating costs. This calculation occurs by looking at the periods with the most and least activity, as well as the total costs for both the high and low periods.
Multiply the variable cost per unit by the number of units expected to be produced in May to work out the total variable cost for the month. The highest activity for bookkeeping the bakery occurred in October when it baked the highest number of cakes, while August had the lowest activity level with only 70 cakes baked at a cost of $3,750.
You can reduce this potential problem by collecting information at other activity levels and affirming the fixed and variable relationships at these other levels. The result could be that the furthest data points are thrown out, resulting in a more reliable high-low analysis. A method of cost analysis that uses a series of mathematical equations to estimate fixed and variable costs; typically done using computer software. This approach is likely to yield more accurate results than the high-low method when the high and low points are not representative of the entire set of data.
The same variable cost per unit can also provide a forecast analysis. As the company can use it to predict the portion of fixed costs with fluctuating activity levels. This method helps determine the variable and fixed cost if the variable cost is fixed per unit and fixed cost is the same for all volume levels. In this method, we use the equations and formula to get the fixed and variable costs. We can use this method anywhere we want to split the fixed high low method accounting and variable cost, be it the total cost for a company, production cost, process cost, project cost, payroll cost, and more. After consulting with her staff, Susan agreed that regression analysis was the best approach to use in estimating total production costs . Account analysis was ruled out because no one on the accounting staff had been with the company long enough to review the accounts and determine which costs were variable, fixed, or mixed.
The zero-based budget method essentially requires starting from scratch each period. To make the procedure simple and easy to understand , we can divide the calculations into the following three steps. In our previous dog groomer example we could clearly see through our scattergram that maintenance costs were related to the number of dogs groomed.
Regression analysis is also best performed using a spreadsheet program or statistics program. For example, the table below depicts the activity for a cake bakery for each of the 12 months of a given year. Other cost-estimating methods, normal balance such as least-squares regression, might provide better results, although this method requires more complex calculations. He has helped individuals and companies worth tens of millions to achieve greater financial success.
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. High Low method will give us the estimation of fixed cost and variable cost, the result may be changed when the total unit and cost of both point change. It is important to note that if a higher level of activity is above a threshold of normal production. One has to consider step fixed cost/additional fixed cost to come up with the full fixed cost.
Using the high-low method requires having a set of data relating costs to cost-driver activities. You take the highest cost and the highest cost-driver activity level and the lowest cost and the lowest cost-driver activity level from the data set. Then use these four pieces of data to calculate the slope of the line that connects the two points. Finally, you compute the intercept using the slope and one of the points. This gives you the high-low cost equation for that particular cost-incurring activity. A major advantage of the high-low method of cost estimation is its ease of use. By only requiring cost information from the highest and lowest activity level and some simple algebra, managers can get information about cost behavior in just a few minutes.
Simply adding the fixed cost and variable cost gives us the total cost of factory overheads in April. The high-low method assumes that fixed and unit variable costs are constant, which is not the case in real life.
Information about actual production output and overhead cost during last year is shown in the table below. Using the four equations listed in your answer to 1, calculate total production costs assuming Alta Production, Inc., will produce 400 units next month. This step requires that each data point be plotted on a graph. The x-axis reflects the level of activity , and the y-axis reflects the total production cost.
Running this blog since 2009 and trying to explain “Financial Management Concepts in Layman’s Terms”. Let us consider an example to understand the calculation better using this method. It could give inaccurate results due to the dependence on two extreme values . These articles are intended to provide general resources for the tax and accounting needs of small businesses and individuals. Service2Client LLC is the author, but is not engaged in rendering specific legal, accounting, financial or professional advice.