Question

In: Accounting

Please describe the high-low method and explain how it is used to break off into the...

Please describe the high-low method and explain how it is used to break off into the variable and fixed portions

Solutions

Expert Solution

High-low method is used to isolate fixed cost and variable cost of a product or organization with a given data series of mixed cost. This method based on the fact that fixed cost is constant over the entire periods. High-low method observes the highest and lowest cost of the series and assuming fixed cost to be equal in both cases, segregates the variable cost with given activity levels as per the below equation:

Variable cost = (Total cost of high activity – Total cost low activity) / (Highest activity unit – Lowest activity unit)

After computing variable cost, fixed cost can be easily calculated by putting it in any level of total cost as:

Total cost = (Variable cost per unit x Units produced) + Total fixed cost

Variable cost per unit = (Total cost - Total fixed cost)/ Units produced

Example:

Suppose total monthly costs and activity levels are given as:

Month

Expenses

No. of units

January

$                 13,000

500

February

$                 11,000

300

March

$                 14,500

650

April

$                 13,200

520

May

$                 14,100

610

June

$                 12,800

480

July

$                 15,000

700

August

$                 13,300

530

September

$                 14,400

640

October

$                 13,500

550

November

$                 12,600

460

December

$                 13,100

510

January

$                 14,000

600

February

$                 12,900

490

Fixed and variable cost can be segregate as follows:

Variable cost = (Total cost of high activity – Total cost low activity) / (Highest activity unit – Lowest activity unit)

                        = ($ 15,000 - $ 11,000)/ (700-300) = $ 4,000/400 = $ 10

Putting this variable cost in highest activity level, we get fixed cost as:

Total cost = (Variable cost per unit x Units produced) + Total fixed cost

$ 15,000 = ($ 10 x 700) + Total fixed cost

Total fixed cost = $ 15,000 - $ 7,000 = $ 8,000


Related Solutions

Please describe the High-Low method and explain how it is used to break costs into the...
Please describe the High-Low method and explain how it is used to break costs into the Variable and Fixed portions
Please answer both. High-Low Method for a Service Company Boston Railroad decided to use the high-low...
Please answer both. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Boston Railroad is a measure of railroad operating activity, termed "gross-ton miles," which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $1,008,400 298,000 February 1,124,300 333,000 March 794,600 216,000 April 1,078,000 323,000...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Boston Railroad is a measure of railroad operating activity, termed “gross-ton miles,” which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $854,100 325,000 February 952,200 363,000 March 673,000 235,000 April 913,000 351,000 May 765,700...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Boston Railroad is a measure of railroad operating activity, termed “gross-ton miles,” which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $929,600 247,000 February 1,036,400 276,000 March 732,500 179,000 April 993,700 268,000 May 833,400...
Question One High-Low Method, High—Low Method, Cost Formulas (LO 3) During the past year, the high...
Question One High-Low Method, High—Low Method, Cost Formulas (LO 3) During the past year, the high and low use of three different resources for Wilson Trucking occurred in July and April. The resources are truck depreciation, fuel, and truck maintenance. The number of kilometres travelled is the driver. The total costs of the three resources and the related number of truck kilometres are as follows: Resource                              Truck Kilometres      Total Cost ($) Truck depreciation: High                                                   46,000,000   2,800,000 Low                                                    32,400,000   2,800,000 Fuel:...
High-low method Ziegler Inc. has decided to use the high-low method to estimate the total cost...
High-low method Ziegler Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows: Units Produced Total Costs 104,500 $30,703,250 119,500 33,380,750 136,500 36,415,250 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Determine the variable cost per unit and...
what is break evenanalysis? how is it used by managers? explain
what is break evenanalysis? how is it used by managers? explain
Describe the level of financial leverage used by Microsoft (high, medium, or low).Is that level of...
Describe the level of financial leverage used by Microsoft (high, medium, or low).Is that level of leverage an advantage or disadvantage to the company? Explain your answer.
High-Low Method, Cost Formulas During the past year, the high and low use of three different...
High-Low Method, Cost Formulas During the past year, the high and low use of three different resources for Fly High Airlines occurred in July and April. The resources are airplane depreciation, fuel, and airplane maintenance. The number of airplane flight hours is the driver. The total costs of the three resources and the related number of airplane flight hours are as follows: Resource Airplane Flight Hours Total Cost Airplane depreciation: High 44,000 $ 18,400,000 Low 28,000 $ 18,400,000 Fuel: High...
High-Low Method, Cost Formulas During the past year, the high and low use of three different...
High-Low Method, Cost Formulas During the past year, the high and low use of three different resources for Fly High Airlines occurred in July and April. The resources are airplane depreciation, fuel, and airplane maintenance. The number of airplane flight hours is the driver. The total costs of the three resources and the related number of airplane flight hours are as follows: Resource Airplane Flight Hours Total Cost Airplane depreciation: High 44,000 $ 18,000,000 Low 28,000 $ 18,000,000 Fuel: High...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT