Question

Johanson Company has provided the following data for the first five months of the year: Machine...

Johanson Company has provided the following data for the first five months of the year:

Machine Hours Lubrication Cost
January 120 $750
February 160 $800
March 200 $870
April 150 $790
May 170 $840

Using the High Low Method, compute the expected cost at 140 Machine Hours.

Homework Answers

Answer #1

Answer

High-Low Method

As we can see that In January month the Machine hours are least and In March month the Machine hours are maximum.

Machine

Hours

Lubrication Cost

January

     120

750

March

     200

   870

Difference

     80

120

Variable cost = Change in Cost / Change in Hours

= $120 / 80 Hours

Variable cost = $1.5 per hour

Fixed Cost = Total Cost – Variable cost

Let’s take January month example

Fixed Cost = $750 – (120 Hours * $1.5 per hour)

Fixed Cost = $570

Cost of 140 Machine Hours

Total Cost = 570 + (140 Hours * $1.5 per hour)

Total Cost = $780

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
Jorgenson Corporation has provided the following data for the first five months of the year: Machine...
Jorgenson Corporation has provided the following data for the first five months of the year: Machine Hours Lubrication Cost January 265 $ 1,515 February 355 $ 1,635 March 425 $ 1,765 April 320 $ 1,615 May 365 $ 1,720 Using the least-squares regression method of analysis, the estimated variable lubrication cost per machine hour is closest to:
Jorgenson Corporation has provided the following data for the first five months of the year: Machine...
Jorgenson Corporation has provided the following data for the first five months of the year: Machine Hours Lubrication Cost January 255 $ 1,525 February 355 $ 1,635 March 430 $ 1,770 April 315 $ 1,620 May 350 $ 1,700 Using the least-squares regression method of analysis, the estimated variable lubrication cost per machine hour is closest to: Multiple Choice $.92 $1.50 $1.38 $1.27
Rooter's Cleaning Services provided data concerning the costs incurred to clean hotel rooms for which hotel...
Rooter's Cleaning Services provided data concerning the costs incurred to clean hotel rooms for which hotel customers pay $150 per night. Data for the past 7 months are as follows: January February March April May June July Number of rooms cleaned 250 160 200 150 285 170 260 Cleaning cost $6,450 $4,060 $5,100 $4,100 $6,760 $4,200 $6,530 How much are estimated monthly variable costs using the high-low method? Round to two decimal places.
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.
The following are the monthly figures of advertising expenditure and sales of a company. It is...
The following are the monthly figures of advertising expenditure and sales of a company. It is found that advertising expenditure has impact on sales generally after 2 months. Allowing for this time lag, calculate the coefficient of correlation : Month Advertising expenditure (in thousand ) Sales (in units) January 50 1200 February 60 1500 March 70 1600 April 90 2000 May 120 2200 June 150 2500 July 140 2400 August 160 2600 September 170 2800 October 100 2000 November 200...
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...
Dundar Mifflin makes electronic products for the RCMP. The following data is for the first six...
Dundar Mifflin makes electronic products for the RCMP. The following data is for the first six months: Direct Labor Hours Manufacturing Overhead January 45,000 $295,000 February 65,000 $309,000 March 57,000 $323,000 April 58,000 $320,000 May 25,000 $181,000 June 29,000 $162,500 Required: 1. Use the high-low method to estimate the cost formula 2. Estimate the total overhead cost at an activity level of 40,000 machine hours, using the separate estimates you obtained for its components.
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...
The controller of Norton Industries has collected the following monthly expense data for use in analyzing...
The controller of Norton Industries has collected the following monthly expense data for use in analyzing the cost 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,840 750 Determine the variable cost components using the high-low method. (Round variable cost to 3 decimal places e.g. 12.250.) Determine the fixed cost components using the high-low method. (Round answer to 0 decimal places...
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT