Question

The following information is available for a company’s maintenance cost over the last twelve months: Month...

The following information is available for a company’s maintenance cost over the last twelve months:

Month

Maintenance Hours

Maintenance Cost

January

43

$43,820

February

38

$45,010

March

35

$44,000

April

31

$45,000

May

36

$43,200

June

28

$38,760

July

18

$32,300

August

19

$35,440

September

25

$37,500

October

29

$39,560

November

34

$42,100

December

39

$46,700

Based on the high-low method, what is the variable and fixed cost component of total maintenance cost?

Variable cost per unit: $

Fixed cost: $

Homework Answers

Answer #1

Solution:

High low Method

1.) Variable cost per unit

= [Maintenance cost at highest hour - maintenance cost at lowest hour] / [number of highest hours - number of lowest hours]

= ($ 43,820-$ 32,300) / (43-18)

=$ 11,520 / 25

= $ 460.8

2.Fixed cost

Total Maintenance cost at 43 maintenance hours = $43,820

Less: Variable cost (43 X $ 460.8) =$ 19814

Total fixed cost = $ 24,006

Or

Total maintenance cost at 18 hours =$ 32,300

Less: Variable cost ( 18 X $ 460.8) = $ 8,294

Total fixed cost = $ 24,006

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
The following information is available for a company’s maintenance cost over the last twelve months: Month...
The following information is available for a company’s maintenance cost over the last twelve months: Month Maintenance Hours Maintenance Cost January 43 $43,820 February 38 $45,010 March 35 $44,000 April 31 $45,000 May 36 $43,200 June 28 $38,760 July 18 $32,300 August 19 $35,440 September 25 $37,500 October 29 $39,560 November 34 $42,100 December 39 $46,700 Based on the high-low method, what is the variable and fixed cost component of total maintenance cost? Variable cost per unit: $ Fixed cost:...
The following information is available for a company’s maintenance cost over the last seven months. Month...
The following information is available for a company’s maintenance cost over the last seven months. Month Maintenance Hours Maintenance Cost June 9 $ 5,450 July 18 6,900 August 12 5,100 September 15 6,000 October 21 6,900 November 24 8,100 December 6 3,600 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 point Variable costs at the high point: Volume...
The following information is available for a company’s manufacturing over the last twelve months: Month Units...
The following information is available for a company’s manufacturing over the last twelve months: Month Units Produced Manufacturing Cost January 32,250 $63,400 February 34,400 $67,000 March 34,000 $66,300 April 35,100 $68,200 May 33,240 $64,200 June 28,500 $59,280 July 29,000 $60,000 August 27,900 $57,800 September 24,450 $52,400 October 25,300 $53,100 November 26,500 $54,560 December 27,900 $55,900 Based on the high-low method, what is the variable and fixed cost component of total manufacturing cost? Variable cost per unit (round your answer to...
The following information is available for a company’s maintenance cost over the last seven months. Month...
The following information is available for a company’s maintenance cost over the last seven months. Month Maintenance Hours Maintenance Cost June 9 $ 4,590 July 18 7,110 August 12 5,430 September 15 6,270 October 21 7,950 November 24 8,790 December 6 3,750 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 0 Total cost at the high point Variable costs at the high point:...
Company has presented the following information for the past eight months operations Machine-Hours Maintenance Cost March...
Company has presented the following information for the past eight months operations Machine-Hours Maintenance Cost March 4,440 $50,950 April 4,431 $50,877 May 4,412 $50,696 June 4,460 $51,113 July 4,414 $50,711 August 4,433 $50,900 September 4,443 $50,976 October 4,415 $50,730 November 4,391 $50,530 Management believes that maintenance cost is a mixed cost that depends on machine-hours. Using the high-low method, calculate a. Variable cost per machine-hour b.  Fixed cost per month c. What would total costs be for a month with 4,000...
Slonaker Inc. has provided the following data concerning its maintenance costs: Machine-Hours Maintenance Cost   April 5,799...
Slonaker Inc. has provided the following data concerning its maintenance costs: Machine-Hours Maintenance Cost   April 5,799           $30,379           May 5,782           $30,289           June 5,764           $30,237           July 5,761           $30,233           August 5,717           $30,078           September 5,795           $30,360           October 5,809           $30,388           November 5,801           $30,378           December 5,785           $30,318         Management believes that maintenance cost is a mixed cost that depends on machine-hours. Required: Estimate the variable cost per machine-hour and...
Cullumber Corp. has collected the following data concerning its maintenance costs for the past 6 months....
Cullumber Corp. has collected the following data concerning its maintenance costs for the past 6 months. Units Produced Total Cost July 20,190 $44,085 August 35,904 53,856 September 40,392 61,710 October 24,684 47,358 November 44,880 83,589 December 42,636 69,564 (a1) Compute the variable cost per unit using the high-low method. (Round answer to 2 decimal places, e.g. 2.25.) Variable cost per unit    (a2) Compute the fixed cost elements using the high-low method. Fixed costs
The Stanford Company incurred the following maintenance cost during a five month period: Month Production Volume...
The Stanford Company incurred the following maintenance cost during a five month period: Month Production Volume Maintenance Costs June 75 $250 July 115 310 August 190 400 September 60 240 October 135 355 Using a computer or calculator, compute the estimate of the fixed portion of maintenance costs using the method of least squares. Rounded to dollars, this value would be?
You have taken over a the maintenance department in an existing business and you are asked...
You have taken over a the maintenance department in an existing business and you are asked to determine how much you should budget for the 2021 budget year if you are expected to process 475,000 work orders. Your only reference is historical financial data for the past 12 months as follows.    Months Workorders Total Costs January        330,000 $         167,000 February        165,000 110,000 March        280,000 225,000 April        225,000 105,000 May        325,000 230,000 June        210,000...
The Jedi Hotel has been tracking its property repairs and maintenance costs (PR&M) over the past...
The Jedi Hotel has been tracking its property repairs and maintenance costs (PR&M) over the past year. The results were as follows for the year: The Jedi Hotel Month Activity (Room Nights Sold) PR&M Costs January 2050 $3,225 February 2800 $3,754 March 3200 $3,947 April 3800 $4,091 May 4100 $4,572 June 4350 $5,583 July 4700 $5,824 August 4900 $6,257 September 4500 $5,727 October 3300 $3,995 November 2700 $3,706 December 2400 $3,465 Required: Using the high-low two point method: 1. Calculate...