Question

High-Low Method Apply the high-low method of cost analysis to the three cost data groups shown...

High-Low Method

Apply the high-low method of cost analysis to the three cost data groups shown below.

Volume
(applicable to
each group)
Group A
Costs
Group B
Costs
Group C
Costs
2,000 $5,200 $2,000 $4,800
12,000 25,200 12,000 4,800
16,000 33,200 16,000 4,800
20,000 41,200 20,000 4,800

What cost behavior patterns are apparent? Express each as a cost formula: Total cost = Fixed costs + (Variable cost x Volume).

Group Fixed costs + (Variable cost x Volume)
A Answer + Answer x Volume
B Answer + Answer x Volume
C Answer + Answer x Volume
0 0
Add a comment Improve this question Transcribed image text
Answer #1

variable cost per unit = (41200-5200)/18000 = 2': Fixed cost = 41200-(20000*2) = 1200

Variable cost per unit = (20000-2000)/18000 = 1; Fixed cost = 20000-20000 = 0

What cost behavior patterns are apparent? Express each as a cost formula: Total cost = Fixed costs + (Variable cost x Volume).

Group Fixed costs + (Variable cost x Volume)
A 1200 + 2 *X
B 0 + 1 *X
C 4800 + 0 *X
Add a comment
Know the answer?
Add Answer to:
High-Low Method Apply the high-low method of cost analysis to the three cost data groups shown...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • QS 18-3 Cost behavior estimation-high-low method LO P1 The following information is available for a company's...

    QS 18-3 Cost behavior estimation-high-low method LO P1 The following information is available for a company's maintenance cost over the last seven months. Month June July August September October November December Maintenance Hours Maintenance Cost 3,710 5,240 4,220 4,730 5,750 6,260 3,200 15 Using the high-low method, estimate both the fixed and variable components of its maintenance cost. Using the high-low method, estimate both the fixed and variable components of its maintenance cost. High-Low method - Calculation of variable cost...

  • QS 18-3 Cost behavior estimation-high-low method LO P1 The following information is available for a company's...

    QS 18-3 Cost behavior estimation-high-low method LO P1 The following information is available for a company's maintenance cost over the last seven months Units Produced 100 Month June July August September October November December 190 110 140 200 230 Maintenance cost $ 5,250 7.850 5.540 6,41e 8.15 9.02e 3,800 Using the high-low method, estimate both the fixed and variable components of its maintenance cost High Low method - Calculation of variable cost per maintenance hour Total cost at the high...

  • 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 Cost Forklift...

  • 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: Airplane Flight Hours Resource Total Cost Airplane depreciation: High 44,000 20,000 $ 18,100,000 $18,100,000 Fuel: 14 000 445,896,000...

  • Check my QS 21-3 Cost behavior estimation-high-low method LO P1 The following information is available for...

    Check my QS 21-3 Cost behavior estimation-high-low method LO P1 The following information is available for a company's maintenance cost over the last seven months intenance Maintenance Cos une July August September October 18 12 15 21 24 s5,e7e 8,130 6,090 7,110 9,158 10,170 4,850 December Using the high-low method, estimate both the fixed and variable components of its maintenance cost Total cost at the high point Variable costs at the high point Volume at the high poin Varlable cost...

  • eBook Calculator High-Low Method, Cost Formulas During the past year, the high and low use of...

    eBook Calculator 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: Airplane Flight Hours Resource Total Cost Airplane depreciation: High 44,000 $ 18,700,000 Low 28,000 $ 18,700,000...

  • Exercise 18-6 Cost behavior estimation-scatter diagram and high-low LO P1 Felix & Co. reports the following...

    Exercise 18-6 Cost behavior estimation-scatter diagram and high-low LO P1 Felix & Co. reports the following Information about its units produced and total costs. points Units Produced Period Period Total Costs $2,700 3,300 3,980 4.500 608 1.ece 1.489 1.800 Units Produced 2,200 2.680 3.898 3,480 3,888 Total Costs $5.799 6,300 6,988 7.500 9. 160 eBook 5.100 le Hint Estimate total costs of 3.200 units are produced. Complete the below table to calculate the fixed cost and variable cost of sales...

  • 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 $28,166,000 104.000 114,000 29,781,000 128,000 32,042,000 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. X Open spreadsheet a. Determine the variable...

  • Exercise 21-6 Cost behavior estimation-scatter diagram and high-low LO P1 Felix & Co. reports the following...

    Exercise 21-6 Cost behavior estimation-scatter diagram and high-low LO P1 Felix & Co. reports the following information about its units produced and total costs. Units Produced Period 1 2 3 4 5 410 810 1,210 1,610 Total Costs $2,510 3,110 3,710 4,310 4,910 Period 6 7 8 9 Units Produced 2,010 2,410 2,810 3,210 3,610 Total Costs $5,510 6,110 6,710 7,310 8,286 LO Estimate total costs if 3,010 units are produced. Complete the below table to calculate the fixed cost...

  • 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,700,000 Low 28,000 $ 18,700,000 Fuel: High...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT