Alpine Manufacturing has collected the following data concerning its electricity costs for the past 6 months. Month Machine Hours Total Cost January 1,250 $4,375 February 1,850 $5,675 March 2,100 $6,250 April 1,500 $4,875 May 2,350 $6,825 June 1,950 $5,925 Compute the fixed and variable cost elements using the high-low method.

Alpine Manufacturing has collected the following data concerning its electricity costs for the past 6 months. Month Machine Hours Total Cost January 1,250 $4,375 February 1,850 $5,675 March 2,100 $6,250 April 1,500 $4,875 May 2,350 $6,825 June 1,950 $5,925 Compute the fixed and variable cost elements using the high-low method.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter4: Activity-based Costing

Section: Chapter Questions

Problem 22E: Silven Company has identified the following overhead activities, costs, and activity drivers for the...

See similar textbooks

Similar questions

Deidoro Company has provided the following data for maintenance cost: Machine hours Maintenance cost Multiple Choice Maintenance cost is a mixed cost with variable and fixed components. The fixed and variable components of maintenance cost are closest to: (Round your intermediate calculations to 2 decimal places.) O O Prior Year 17,100 20,100 $ 29,400 $ 34,200 $29,400 per year; $1.701 per machine hour Current Year $2,040 per year; $1.701 per machine hour $2,040 per year; $1.600 per machine hour $29,400 per year; $1.600 per machine hour
The controller of Cullumber Production has collected the following monthly cost data for analyzing the behavior of electricity costs. January February March April May June July August September October November December (a) Total Total Electricity Costs Machine Hours $2,480 2,900 Total fixed costs 3.520 4,780 3,220 5,000 4,090 3,810 5.110 4,270 3,320 5,840 Variable cost per machine hour $ 210 $ 340 500 685 420 750 650 510 Determine the fixed costs and unit variable costs using the high-low method. 675 600 340 770
Markowis Corp. has collected the following data concerning its maintenance costs for the past 6 months.July August September October November DecemberUnits Produced18,000 32,000 36,000 22,000 40,000 38,000Total Cost$36,000 48,000 55,000 38,000 74,500 62,000Compute the variable- and fixed-cost elements using the high-low method.
please help
Harbor Images has collected the following cost data for various levels of activity: Images Created Total Cost $5,700 $6,320 $9,210 $5,250 Month 6,000 7,750 8,100 4,500 August September October November a. Using the high-low method, determine the variable cost per image created and the total fixed cost. (Round your variable cost to 2 decimal places.) Variable Cost Per Image Fixed Cost Per Month b. Estimate the total costs when 6,500 images are created. (Do not round your intermediate calculations.) Total Costs
The controller of Ivanhoe Industries has collected the following monthly cost data for use in analyzing the behavior of maintenance costs. Month January February March April May June (a1) Total Maintenance Costs $3,041 3,456 4,147 5,184 3,686 5,633 Total Machine Hours 4,032 Variable cost per machine hour $ 4,608 6,912 9,101 5,760 9,216 Determine the unit variable costs using the high-low method for this mixed cost. (Round answer to 2 decimal places e.g. 2.25.)
The electricity costs and machine hours for a period of 6 months are as follows Hours CostsMonths machine electricityJanuary 2,000 $ 4,800February 2,500 $ 5,200March 3,000 $ 5,400April 2,400 $ 5,000May 2,800 $ 5,600June 2,200 $ 5,000Using the high-low method, what is the formula to use to determine electricity costs at different volumes of electricity hours? (Fixed cost + variable cost × volume). a. Electricity costs = $ 2,800 + ($ 1.00 x number of machine hours) b. Electricity costs = $ 2,600 + ($ 1.00 x number of machine hours) c. Electricity costs = $ 400 + ($ 1.67 x number of machine hours) d. Electricity costs = $ 3,600 + ($ .60 x number of machine hours)
Sunland Co. gathered the following information on power costs and factory machine usage for the last six months: Month January February March April May June (a) Power Cost $28,390 (b) 36,069 32,895 26,235 (c) 23,890 20,700 Your answer is correct. Variable power costs $ Using the high-low method of analyzing costs, answer the following questions and show computations to support your answers. eTextbook and Media Your answer is correct. Factory Machine Hours What is the estimated variable portion of power costs per factory machine hour? (Round answer to 2 decimal places, e.g. 15.25.) Fixed power costs $ eTextbook and Media 15,800 21,400 Total power cost $ 18,700 High 15,100 13,500 What is the estimated fixed power cost each month? 10,500 1.41 5,895 per factory machine hour Low 5,895 If it is estimated that 13,800 factory machine hours will be run in July, what is the expected total power cost for July?
The controller of Sandhill Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs. Month January February March April May June Variable cost per machine hour Total Maintenance Costs Determine the variable-cost components using the high-low method. (Round answer to 2 decimal places e.g. 2.25.) Determine the fixed cost components using the high-low method. Fixed costs $2,825 3,210 3,852 4,815 3,424 5,476 Total Machine Hours 3,740 4,280 6,420 8,453 5,350 8,560 $ $
The controller of Carla Vista Industries has collected the following monthly cost data for use in analyzing the behavior of maintenance costs. Month Total Maintenance Costs Total Machine Hours January $2,830 300 February 3,130 350 March 3,730 500 April 4,630 690 May 3.330 500 June 6,030 700 (a1) Your answer is correct. Determine the unit variable costs using the high-low method for this mixed cost. (Round answer to 2 decimal places e.g. 2.25.) Variable cost per machine hour $ 8 (a2) eTextbook and Media Determine the fixed costs using the high-low method for this mixed cost. Total fixed costs $ Attempts: 1 of 10 used
Given the following cost and activity observations for Bounty Company's utilities, use the high-low method to calculate Bounty' variable utilities costs per machine hour. Round your answer to the nearest cent. March April May June Cost $3,100 2,700 2,900 3,600 Machine Hours 15.000 10,000 12,000 18,000
The controller of Sheridan Industries has collected the following monthly cost data for use in analyzing the behavior of maintenance costs. Month Total Maintenance Costs Total Machine Hours January $2,930 350 February 3,230 400 March 3,830 550 April 4,730 640 May 3,430 550 June 5,730 750 Determine the unit variable costs using the high-low method for this mixed cost. (Round answer to 2 decimal places e.g. 2.25.) Variable cost per machine hour eTextbook and Media Determine the fixed costs using the high-low method for this mixed cost.