Question

The Fairmont Machine Shop wants to develop a cost estimating equation for its monthly cost of...

The Fairmont Machine Shop wants to develop a cost estimating equation for its monthly cost of electricity. It has the following data: Month Cost of Electricity (Y) Direct Labor-Hours (X) January $14,000 1,500 April $15,000 1,700 July $17,000 2,000 October $14,500 1,600 What would be the best equation using the high-low method?

Homework Answers

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
Machine hours and electricity costs for AMK Industries for the past eleven months were as follows:...
Machine hours and electricity costs for AMK Industries for the past eleven months were as follows: Month Electricity Costs Machine Hours January $12,600 8000 February 14,333 9600 March 9,333 5600 April 15,667 10200 May 19,167 9200 June 15,134 13200 July 16,834 14400 August 15,500 12000 September 10,667 6000 October 17,667 13200 November 21,000 16800 Required: a. Using the high-low method, develop an estimate of variable electricity costs per machine hour. b. Using the high-low method, develop an estimate of fixed...
The controller of Ivanhoe Production has collected the following monthly expense data for analyzing the cost...
The controller of Ivanhoe Production has collected the following monthly expense data for analyzing the cost behavior of electricity costs. Total Electricity Costs Total Machine Hours January $2,300 270 February 2,920 390 March 3,500 500 April 4,780 690 May 3,230 450 June 4,920 790 July 4,010 625 August 3,870 530 September 5,050 665 October 4,260 625 November 3,220 390 December 6,080 810 Determine the fixed- and variable-cost components using the high-low method. Fixed-costs $ Variable-costs $ Link to Text Link...
Oriole, Inc., has collected the following information on its cost of electricity: Machine Hours Total Electricity...
Oriole, Inc., has collected the following information on its cost of electricity: Machine Hours Total Electricity Costs January 500 $240 February 540 $300 March 370 $210 April 440 $220 May 680 $290 June 730 $330 July 330 $180 August 530 $260 September 230 $118 October 740 $340 November 860 $370 December 600 $340 Using the high-low method, compute the variable cost of electricity per machine hour. (Round unit cost to 2 decimal places, e.g. 52.75.) Variable cost $   per machine hour...
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,500 $ 18,900 February 3,900 $ 22,000 March 2,900 $ 14,000 April 4,100 $ 24,000 May 4,800 $ 28,750 June 4,300 $ 23,000 July 5,500 $ 25,250 August 4,500 $ 23,250 September 3,000 $ 16,500 October 4,700 $ 27,000 November...
Scattergraph Method. Castanza Company produces computer printers. Management wants to estimate the cost of production equipment...
Scattergraph Method. Castanza Company produces computer printers. Management wants to estimate the cost of production equipment used to produce printers. The company reported the following monthly cost data related to production equipment (this is the same data as the previous exercise): Reporting Period (Month) Costs Machine Hours January $  920,000 45,000 February 600,000 25,000 March 500,000 20,000 April 1,100,000 90,000 May 1,140,000 95,000 June 620,000 30,000 July 880,000 38,000 August 910,000 48,000 September 1,060,000 78,000 October 960,000 51,000 November 1,400,000 96,000...
Kathy Smith, owner of Tulip Time, operates a local chain of floral shops. Each shop has...
Kathy Smith, owner of Tulip Time, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Smith wants to set the delivery fee based on the distance driven to deliver the flowers. Smith wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. She has the following data from the past seven months:...
Exercise 6-34 Estimating Cost Behavior by Multiple Methods (Appendix) (LO 6-1, 6-2, 6-5, 6-8) Gator Beach...
Exercise 6-34 Estimating Cost Behavior by Multiple Methods (Appendix) (LO 6-1, 6-2, 6-5, 6-8) Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store hours that fluctuate from month to month as the tourist trade in the community varies. The utility costs for one of the company’s stores are listed below for the past six months.    Month Total Hours of Operation Total Utility Cost January 550 $ 1,620 February 600 1,700 March 700...
May Day Florists is an on-line order and delivery flower shop. The company has tracked their...
May Day Florists is an on-line order and delivery flower shop. The company has tracked their mixed costs overhead costs for the first 6 months of the year. May Day wants to be able to estimate these overhead costs for different levels of activity of the business. The number of orders and overhead costs for 6 months are provided in the table below. Month Number of Orders Overhead Costs January 150 $2,575 February 475 $3,875 March 200 $2,950 April 275...
You have been asked by the Royal University Hospital to assist in estimating their cost structure...
You have been asked by the Royal University Hospital to assist in estimating their cost structure so that management is better able to plan and control the business affairs of the Magnetic Resonance Imaging (MRI) department. The manager of the MRI department has asked you to assist in classifying the utility costs. Utility cost are very high in the department given that the MRI machine cannot be turned off due to the long warm-up period required for its use. When...
Jurgenson Industries has compiled the data below concerning manufacturing overhead cost for its first year of...
Jurgenson Industries has compiled the data below concerning manufacturing overhead cost for its first year of operations. They believe that overhead cost is closely related to the number of batches processed and would like to develop a way of projecting overhead cost for budgeting and future operational decision-making. Month Number of Batches (X) Manufacturing Overhead (Y) January 309 $84,000 February 128 $41,000 March 249 $63,000 April 159 $44,000 May 216 $44,000 June 174 $48,000 July 264 $66,000 August 162 $46,000...