Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The controller of Rather Production has collected the following monthly expense data for analyzing the cost behavior of electricity costs based upon machine hours
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started