Question: Question: Another approach to identifying fixed and variable costs for cost estimation purposes is the high - low method A method of cost analysis that

Question: Another approach to identifying fixed and variable costs for cost estimation purposes is the high-low method A method of cost analysis that uses the high and low activity data points to estimate fixed and variable costs. . Accountants who use this approach are looking for a quick and easy way to estimate costs, and will follow up their analysis with other more accurate techniques. How is the high-low method used to estimate fixed and variable costs?
Answer: The high-low method uses historical information from several reporting periods to estimate costs. Assume Susan Wesley obtains monthly production cost information from the financial accounting department for the last 12 months. This information appears in Table 2.4Monthly Production Costs for Bikes Unlimited.
Table 2.4 Monthly Production Costs for Bikes Unlimited
Reporting Period (Month)Total Production CostsLevel of Activity (Units Produced)July$230,0003,500August250,0003,750September260,0003,800October220,0003,400November340,0005,800December330,0005,500January200,0002,900February210,0003,300March240,0003,600April380,0005,900May350,0005,600June290,0005,000
Step 1. Identify the high and low activity levels from the data set.
Step 2. Calculate the variable cost per unit ( v ).
Step 3. Calculate the total fixed cost ( f ).
Step 4. State the results in equation form Y = f + v X.
Question: How are the four steps of the high-low method used to estimate total fixed costs and per unit variable cost?
Answer: Each of the four steps is described next.
Step 1. Identify the high and low activity levels from the data set.
The highest level of activity (level of production) occurred in the month of April (5,900 units; $380,000 production costs), and the lowest level of activity occurred in the month of January (2,900 units; $200,000 production costs). Note that we are identifying the high and low activity levels rather than the high and low dollar levelschoosing the high and low dollar levels can result in incorrect high and low points.
Step 2. Calculate the variable cost per unit ( v ).
The calculation of the variable cost per unit for Bikes Unlimited is shown as follows:
Unitvariablecost(v)=CostathighestlevelCostatlowestlevelHighestactivitylevelLowestactivitylevel=$380,000$200,0005,900units2,900units=$180,0003,000units=$60
Step 3. Calculate the total fixed cost ( f ).
After completing step 2, the equation to describe the line is partially complete and stated as Y = f + $60X. The goal of step 3 is to calculate a value for total fixed cost (f). Simply select either the high or low activity level, and fill in the data to solve for f (total fixed costs), as shown.
Using the low activity level of 2,900 units and $200,000,
Y=f+vX$200,000=f+($602,900units)f=$200,000($602,900units)f=$200,000$174,000f=$26,000
Thus total fixed costs total $26,000.(Try this using the high activity level of 5,900 units and $380,000. You will get the same result as long as the per unit variable cost is not rounded.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!