Question

The Company accumulates the following data concerning a mixed cost, using kilometres as the activity level:...

The Company accumulates the following data concerning a mixed cost, using kilometres as the activity level:

                  Kilometres Driven   Total Cost.       Kilometres Driven                  Total Cost        

January           8,000.                  $14,850           March 4,750                             $12,330         

February         7,510                       14,200             April    8,330                                17,342         

Calculate the fixed cost element using the high-low method. Ignore the money sign.

Homework Answers

Answer #1

Solution :

Fixed Cost in April = Total cost in April - (Kilometers in April * Variable cost per km)

= $17,342 - (8,330 Km * $1.4 )

   = $17,342 - $11,662

Fixed cost =$5,680

Working:

Calculation of Variable cost

Highest Kilometer Driven Month = April

Lowest Kilometer Driven Month = March

Variable cost undr High low method = (Total cost in April - Total cost in March) / (Km. in April - kilometer in March)

= ( $17,342 - $12,330) /(8,330 - 4750)

= $5,012 / 3,580

= $1.4 per km

Know the answer?
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
Similar Questions
Question A- Keys Company accumulates the following data concerning a mixed cost, using miles as the...
Question A- Keys Company accumulates the following data concerning a mixed cost, using miles as the activity level.                      Miles Driven         Total Cost January            10,000                 $15,000 February            8,000                   13,500 March                9,000                   14,400 April                  7,500                   12,500 Required: Compute the variable and fixed cost elements using the high-low method If it is estimated that 12,000 miles will be drive in May, what is the expected total cost for May?                                                                                                                        (7.5 Marks) B- XYZ Company sells its only product for $40 per unit....
Ken-Ken Company has determined that their maintenance cost is a mixed cost and aims to perform...
Ken-Ken Company has determined that their maintenance cost is a mixed cost and aims to perform segregation technique. They observed the maintenance cost over a six-month period according to behavior with machine hours, their main cost driver. Use high-low method and compute the following below. Month Maintenance Cost Machine Hours January 5,400.00   900.00 February 6,000.00 1,050.00 March 7,200.00 1,500.00 April 9,000.00 2,070.00 May 6,400.00 1,200.00 June 11,000.00 2,100.00 1. Variable cost rate per hour 2. Fixed cost 3. Expected total...
In the Bonita, maintenance costs are a mixed cost. At the low level of activity (100...
In the Bonita, maintenance costs are a mixed cost. At the low level of activity (100 direct labor hours), maintenance costs are $1200. At the high level of activity (400 direct labor hours), maintenance costs are $2200. Using the high-low method, what is the variable maintenance cost per unit and the total fixed maintenance cost? Variable Cost Per Unit Total Fixed Cost $3.33          $1000 $3.33          $868 $5.50          $275 $5.50          $2600
Pearson Electric Company uses the high-low method to analyze mixed costs. The following information relates to...
Pearson Electric Company uses the high-low method to analyze mixed costs. The following information relates to the production data for the first six months of the year. Month Cost(Y) Hours(H) January $ 8,350 365 February $ 10,000 800 March $ 8,240 480 April $ 8,360 400 May $ 10,510 1,085 June $ 9,750 775 How should the cost function be properly stated using the high-low method?
Pearson Electric Company uses the high-low method to analyze mixed costs. The following information relates to...
Pearson Electric Company uses the high-low method to analyze mixed costs. The following information relates to the production data for the first six months of the year. Month Cost(Y) Hours(H) January $ 8,620 425 February $ 10,500 840 March $ 8,640 520 April $ 8,860 440 May $ 10,780 1,145 June $ 10,230 815 What is the estimated total cost at an operating level of 1,180 hours, using the high-low method? (Round variable cost per unit to 2 decimal places.)...
Given the following cost and activity observations for Smithson Company's utilities, use the high-low method to...
Given the following cost and activity observations for Smithson Company's utilities, use the high-low method to calculate Smithson's fixed costs per month. Cost Machine Hours January $75,830 10,100 February 126,860 18,200 March 88,800 12,100 April 108,830 15,300 a.$12,200 b.$20,700 c.$9,800 d.$39,000
The following information relates to ABC Company's utilities cost and activity for the first six months...
The following information relates to ABC Company's utilities cost and activity for the first six months of 2021: Month Utilities Costs Units Produced January $17,200 6,200 February 14,500 5,300 March 18,600 7,100 April 13,700 4,800 May 15,900 5,900 June 12,800 4,600 ABC Company expects to produce 6,500 units during July. Using the high-low method, calculate ABC Company's expected utilities cost for July.
Part 1: Zeva Security Products gathered the following monthly warehouse support costs and unit sales data...
Part 1: Zeva Security Products gathered the following monthly warehouse support costs and unit sales data for January through June 2018: Warehouse Support Units Sold Total Cost Unit Cost January 7,510 $166,093 $22.12 February 9,890 $182,158 $18.42 March 5,640 $153,470 $27.21 April 6,890 $161,908 $23.50 May 9,400 $178,850 $19.03 June 4,350 $144,763 $33.28 a) Use the High-Low Method to determine the cost function for warehouse support costs. You must present calculations to support the amounts in your cost functions. (4...
Given the following cost and activity observations for Smithson Company's utilities, use the high-low method to...
Given the following cost and activity observations for Smithson Company's utilities, use the high-low method to calculate Smithson's fixed costs per month. Round your final answer to the nearest dollar. Do not round interim calculations. Cost Machine Hours January $26,400 10,100 February 37,500 18,400 March 28,900 12,000 April 30,200 14,900 a.$21,918 b.$10,314 c.$12,893 d.$41,258
The following information is available regarding the total repair costs of Billy´s Automotive Company for six...
The following information is available regarding the total repair costs of Billy´s Automotive Company for six months of 2016: # of Units produced Total Cost January 1,600 $ 15,700 February 1,850 $ 17,300 March 1,100 $ 12,550 April 1,350 $ 14,100 May 1,975 $ 18,000 June 2,350 $ 21,050 Instruction: (show your calculations and round to 2 decimal places) Compute the following using the high low method: The variable element of repair cost per unit of production: The fixed element...