The controller of Rather Production has collected the following monthly expense data for analyzing the cost...

  

Transcribed Image Text:

The controller of Rather Production has collected the following monthly expense data for analyzing the cost behavior of electricity costs based upon machine hours Machine Electricity Costs Month Hours January 300 2,500.00 February 350 3,000.00 March 500 3,600.00 April 690 4,500.00 May 400 3,200.00 June July 700 4,900.00 650 4,100.00 August 520 3,800.00 September 480 5,100.00 October 630 4,200.00 November 350 3,300.00 December 720 5,860.00 Based upon the above date, create the total cost equation using: a. High-Low Method b. Scatterplot Method (make sure you create the trendline to extend back to the y-axis and record the r-squared (how closely the dots resemble a straight-line). c. Calculate the total costs using a per unit cost of 1,000 (fill in for X on total cost equation) for both the high-low method and scatterplot method The controller of Rather Production has collected the following monthly expense data for analyzing the cost behavior of electricity costs based upon machine hours Machine Electricity Costs Month Hours January 300 2,500.00 February 350 3,000.00 March 500 3,600.00 April 690 4,500.00 May 400 3,200.00 June July 700 4,900.00 650 4,100.00 August 520 3,800.00 September 480 5,100.00 October 630 4,200.00 November 350 3,300.00 December 720 5,860.00 Based upon the above date, create the total cost equation using: a. High-Low Method b. Scatterplot Method (make sure you create the trendline to extend back to the y-axis and record the r-squared (how closely the dots resemble a straight-line). c. Calculate the total costs using a per unit cost of 1,000 (fill in for X on total cost equation) for both the high-low method and scatterplot method

Answer rating: 100% (QA)

a HighLow Method To calculate the total cost equation using the HighLow Method we need to determine the variable cost per machine hour and the fixed c... View the full answer