Question

In: Accounting

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 44,000 445,896,000 Low 28,000 283,752,000 Airplane maintenance: High 44,000 16,544,000 Low 28,000 12,120,000 Required: Use the high-low method to answer the following questions. If an answer is zero, enter "0". If required, round your answers to nearest dollar. 1. What is the variable rate for airplane depreciation? $ per flight hour What is the fixed cost for airplane depreciation? $ 2. What is the cost formula for airplane depreciation? Total cost of airplane depreciation = $ 3. What is the variable rate for fuel? $ per flight hour What is the fixed cost for fuel? $ 4. What is the cost formula for fuel? Total cost of fuel = $ x 5. What is the variable rate for airplane maintenance? $ per flight hour What is the fixed cost for airplane maintenance? $ 6. What is the cost formula for airplane maintenance? Total cost of airplane maintenance = $ + ( $ × ) 7. Using the three cost formulas that you developed, predict the cost of each resource in a month with 36,000 airplane flight hours. (Note: Do not round intermediate calculations.) Total cost of airplane depreciation $ Total cost of fuel $ Total cost of airplane maintenance $

Solutions

Expert Solution

Airplane Flight Hours Airplane Depreciation Cost $ Fuel Cost $ Airplane Maintenance Cost $
High activity level 44000 18400000 445896000 16544000
Low activity level 28000 18400000 283752000 12120000
Change 16000 0 162144000 4424000
1 Variable rate for airplane depreciation = $0 per flight hour
Fixed cost for airplane depreciation = $18400000
2 Cost formula for airplane depreciation: Total cost of airplane depreciation = $18400000
3 Variable rate for fuel = $162144000/16000 = $10134 per flight hour
Fixed cost for fuel = $445896000 - ($10134 x 44000) = $445896000 - $445896000 = $0
4 Cost formula for fuel: Total cost of fuel = $10134 x Flight hours
5 Variable rate for airplane maintenance = $4424000/16000 = $276.50 per flight hour
Fixed cost for airplane maintenance = $16544000 - ($276.50 x 44000) = $16544000 - $12166000 = $4378000
6 Cost formula for airplane maintenance: Total cost of airplane maintenance = $4378000 + ($276.50 x Flight hours)
7 Total cost of airplane depreciation = $18400000
Total cost of fuel = $10134 x Flight hours = $10134 x 36000 = $364824000
Total cost of airplane maintenance = $4378000 + ($276.50 x 36000) = $4378000 + $9954000 = $14332000

Related Solutions

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...
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...
High-Low Method, Cost Formulas The controller of the South Charleston plant of Ravinia, Inc., monitored activities...
High-Low Method, Cost Formulas The controller of the South Charleston plant of Ravinia, Inc., monitored activities associated with materials handling costs. The high and low levels of resource usage occurred in September and March for three different resources associated with materials handling. The number of moves is the driver. The total costs of the three resources and the activity output, as measured by moves for the two different levels, are presented as follows: Resource        Number of Moves        Total...
High-Low Method, Cost Formulas The controller of the South Charleston plant of Ravinia, Inc., monitored activities...
High-Low Method, Cost Formulas The controller of the South Charleston plant of Ravinia, Inc., monitored activities associated with materials handling costs. The high and low levels of resource usage occurred in September and March for three different resources associated with materials handling. The number of moves is the driver. The total costs of the three resources and the activity output, as measured by moves for the two different levels, are presented as follows: Resource        Number of Moves        Total...
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...
Continental Railroad decided to use the high-low method and operating data from the past six months...
Continental 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 Continental 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,900 228,000 February 953,100 255,000 March 673,600 165,000 April 913,800 247,000 May 766,400 198,000 June 982,600 268,000 Determine the variable...
2.) Boston Railroad decided to use the high-low method and operating data from the past six...
2.) 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 $896,400 265,000 February 999,400 296,000 March 706,300 192,000 April 958,200 287,000 May 803,600 231,000 June 1,030,300 312,000 Determine the...
Boston Railroad decided to use the high-low method and operating data from the past six months...
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 $530,900 224,000 February 591,900 250,000 March 418,300 162,000 April 567,500 242,000 May 476,000 195,000 June 610,200 263,000 Determine the variable...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT