Question

In: Accounting

1.Nutt Industries electricity costs and machine hours over a six-month period follow: Machine Electricity Hours Cost...

1.Nutt Industries electricity costs and machine hours over a six-month period follow:

Machine Electricity
Hours Cost
January 2000 $4,800
February 2500 5,200
March 3000 5,400
April 2400 5,000
May 2800 5,600
June 2200 5,000

Required:


a. Using the high-low method, what is the estimated electricity cost per machine hour?

b. Differentiate high-low method from other methods of inventory valuation.

Solutions

Expert Solution

Solution:

A) Computation of electricity cost per machine hour using high low point method

Particulars

Machine hours

Electricity cost

Highest activity level

3000 machine hours

$ 5,400

Lowest activity level

2000 machine hours

$ 4,800

Difference

1000 machine hours

$ 600

Variable electricity cost per machine hour = Difference in costs / Difference in machine hours

                                                                                   =   $ 600 / 1000 machine hours

                                                                                   =   $ 0.60 per machine hour

At 3000 machine hours

Particulars

Amount in $

Electricity cost

$ 5,400

Less : Variable electricity cost

($ 1,800)

(3000 machine hours * $ 0.60)

Fixed electricity costs

$ 3,600

B) Differences that shall arise between high low method and other methods of inventory are enumerated below

· Its easy to calculate the fixed and variable costs in high low method and do not require much of complex nature for calculation where as in other methods it quite cumbersome to calculate.

· The accuracy can be provided only when the activity and cost are perfectly linear otherwise the above method fails to do so.

· High low method ignores inflation where as other methods consider the same in inventory valuation.

· High low method is oversimplified cost behavior whereas other methods do not follow the same and quite different .


Related Solutions

SHOW ALL WORK!!                 Machine hours and electricity costs for ABC Industries for the past eleven...
SHOW ALL WORK!!                 Machine hours and electricity costs for ABC Industries for the past eleven months were as follows: Month Electricity Costs Machine Hours January $12,600                 2,000 February              14,000 2,400 March   9,310   1,400 April       15,200 2,600 May       19,000 2,300 June      15,500 3,300 July        17,000 3,600 August 15,500 3,000 September         10,700 1,500 October               17,700 3,300 November          21,000 4,200 Required: a.            Using the high-low method, develop an estimate of variable electricity costs per machine hour. (Round to the nearest penny) b.           ...
Nova Company’s total overhead costs at various levels of activity follow: Month Machine-Hours Total Overhead Costs...
Nova Company’s total overhead costs at various levels of activity follow: Month Machine-Hours Total Overhead Costs April 78,000 $ 214,000 May 115,500 286,000 June 96,000 238,000 July 106,000 246,640 Assume that the total overhead costs consist of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 78,000 machine-hour level of activity is as follows: Utilities (V) $ 48,640 Supervisory salaries (F) 22,600 Maintenance (M) 142,760 Total overhead costs $ 214,000 V = variable; F = fixed; M...
1. Orange Inc., is a manufacturer of computer keyboards. Requirements over a typical six-month period are...
1. Orange Inc., is a manufacturer of computer keyboards. Requirements over a typical six-month period are as follows; (Questions 1,2,3) Month January February March April May June Forecasted Demand 200 300 400 400 200 300 Cost and other Information Inventory holding cost Back ordering cost Wages Hiring cost Lay off cost Production rate Beginning Number of employees $1/unit/month $2/unit/ month $1000/worker/ employee $400/worker $250/worker 100/worker/ month 4 in the beginning of January If a Chase strategy is applied, what is...
(1) Fromme's Frocks has the following machine hours and production costs for the last six months...
(1) Fromme's Frocks has the following machine hours and production costs for the last six months of last year: Month Machine Hours Production Cost July 17,000 $ 12,175 August 15,500 12,800 September 13,500 9,820 October 17,500 12,280 November 16,800 11,792 December 14,100 9,982 If Fromme expects to incur 12,600 machine hours in January, what will be the estimated total production cost using the high-low method? (A) $20,029.00. (B) $8,841.60. (C) $7,749.00. (D) $9,266.50. (3) Case (A) Case (B) Case (C)...
Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have...
Thane Company is interested in establishing the relationship between electricity costs and machine hours. Data have been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow: Month Machine Hours Electricity Costs January 3,000 $ 18,650 February 3,400 $ 21,500 March 2,400 $ 13,750 April 3,600 $ 23,500 May 4,300 $ 28,500 June 3,800 $ 22,500 July 4,600 $ 25,000 August 4,000 $ 23,000 September 2,500 $ 16,000 October 4,200 $ 26,500 November 5,600...
Fromme's Frocks has the following machine hours and production costs for the last six months of...
Fromme's Frocks has the following machine hours and production costs for the last six months of last year: Month Machine Hours Production Cost July 15,000 $12,075 August 13,500 10,800 September 11,500 9,580 October 15,500 12,080 November 14,800 11,692 December 12,100 9,922 If Fromme expects to incur 14,000 machine hours in January, what will be the estimated total production cost using the high-low method?
Fromme's Frocks has the following machine hours and production costs for the last six months of...
Fromme's Frocks has the following machine hours and production costs for the last six months of last year: Month Machine Hours Production Cost July 16,600 $ 12,155 August 15,100 12,400 September 13,100 9,740 October 17,100 12,240 November 16,400 11,772 December 13,700 9,970 If Fromme expects to incur 12,200 machine hours in January, what will be the estimated total production cost using the high-low method? $8,732.63. $9,177.50. $7,625.00. $19,865.00.
Computer’s R Us, is a manufacturer of computer keyboards. The requirements over a typical six-month period...
Computer’s R Us, is a manufacturer of computer keyboards. The requirements over a typical six-month period are as follows; Demand per month. 1: 600 2: 600 3: 450 4: 750 5: 900 6: 300 The current workforce level is 4 workers. Production rate is 150/worker/month. The following costs apply:Wages = $2,000/worker/month Hiring cost = $200/worker Layoff Cost = $250/worker Inventory holding cost = $1/unit/month Back ordering cost = $2/unit/month What would be the production rate per month for a level...
Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694...
Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694 4 1,470 108,694 5 1,620 116,694 6 1,690 115,694 7 1,490 107,694 8 1,310 102,694 9 1,450 106,694 10 1,580 113,694 11 1,300 100,694 12 1,600 113,694 13 1,650 114,694 14 1,440 109,694 15 1,340 102,694 16 1,670 114,694 17 1,480 106,694 18 1,360 103,694 19 1,340 103,694 20 1,540 112,694 Assume that the following relationship holds: Maintenance Costs = (v * Machine Hours)...
Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694...
Month Machine Hours (hrs.) Maintenance Costs ($) 1 1,330 102,694 2 1,400 103,694 3 1,500 108,694 4 1,470 108,694 5 1,620 116,694 6 1,690 115,694 7 1,490 107,694 8 1,310 102,694 9 1,450 106,694 10 1,580 113,694 11 1,300 100,694 12 1,600 113,694 13 1,650 114,694 14 1,440 109,694 15 1,340 102,694 16 1,670 114,694 17 1,480 106,694 18 1,360 103,694 19 1,340 103,694 20 1,540 112,694 Assume that the following relationship holds: Maintenance Costs = (v * Machine Hours)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT