Question

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?

Homework Answers

Answer #1

Variable cost per hour = (Highest activity cost – Lowest activity cost)/(Highest activity hour – Lowest activity hour)

= (10,510 - 8,350)/(1,085 - 365)

= 2,160/720

= $3

Fixed cost = Highest activity cost – (Variable cost per hour x Highest activity hour)

= 10,510 - ( 3 x 1,085)

= 10,510 - 3,255

= $7,255

Cost function :

(Y) Total cost = Fixed cost + (Variable cost per hour x Number of hour)

Y = 7,255 + 3 x

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
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.)...
High and Low Method Jim, the owner of Jim’s Bistro, wants to analyze labor costs in...
High and Low Method Jim, the owner of Jim’s Bistro, wants to analyze labor costs in his restaurant operations and has asked your assistance. Using the H-L method answer the following questions. Month Number of Customers Labor Costs Jan 4,000 $15,500 Feb 2,400 10,450 March 3,700 18,500 April 4,450 19,000 May 4,400 19,000 June 4,800 20,250 July 5,000 20,500 Aug 3,900 18,500 Sept 3,800 18,000 Oct 3,100 15,500 Nov 2,900 15,250 Dec 3,000 16,650 Total Using the high/low two-point method,...
High-Low Method for a Service Company Boston Railroad decided to use the high-low method and operating...
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,452,500 387,000 February 1,619,400 432,000 March 1,144,500 280,000 April 1,552,600 419,000 May 1,302,200 337,000...
High-Low Method for a Service Company Boston Railroad decided to use the high-low method and operating...
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 $614,200 246,000 February 684,800 275,000 March 484,000 178,000 April 656,600 266,000 May 550,700 214,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.
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and construct a cost function Pizza...
Using High-Low to Calculate Fixed Cost, Calculate the Variable Rate, and construct a cost function Pizza Vesuvio makes specialty pizzas. Data for the past 8 months were collected: Month Labor Cost Employee Hours January 9,590 490 February 7,100 570 March 7,631 610 April 8,240 460 May 9,887 530 June 8,590 420 July 12,460 680 August 7,600 380 Pizza Vesuvio's controller wants to calculate the fixed and variable costs associated with labor used in the restaurant. In your calculations, round the...
Use the following data and the high-low method to determine the variable costs per unit. Month...
Use the following data and the high-low method to determine the variable costs per unit. Month Units Total Costs January 1000 $ 45,550.00 February 1500 $ 52,000.00 March 2100 $ 61,500.00 April 1800 $ 62,000.00 May 750 $ 41,250.00 a. $15 B $22.50 C. $7.40 D. 15.25
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.
Uptop Mining has compiled the following data to analyze utility costs: Month Machine Hours Utility Cost...
Uptop Mining has compiled the following data to analyze utility costs: Month Machine Hours Utility Cost January 200 300 February 325 440 March 400 480 April 410 490 May 525 620 June 680 790 July 820 840 August 900 900 Use the least square method to develop a formula for budgeting utility cost. *Don't us excel or any other software to solve this problem.
Southlake Inc uses the high low method to analyze cost behavior. The company observed that at...
Southlake Inc uses the high low method to analyze cost behavior. The company observed that at 30,000 machine hours of activity, total maintenece costs averaged $11/hour. When activity jumped to 60,000 machine hours which was still within the relevant range, the average total maintence cost was $9. What are the total costs estimated to be at the level of 50,000 machine hours?