Question: can you show me how to do this? Function: SLOPE, INTERCEPT; Cell Referencing BE2.8 - Using Excel to Determine Variable and Fixed Student Work Area
can you show me how to do this?

Function: SLOPE, INTERCEPT; Cell Referencing BE2.8 - Using Excel to Determine Variable and Fixed Student Work Area Cost Elements Using the High-Low Method Required: Provide input into cells shaded in yellow in this PROBLEM template. Use cell referencing to the Problem area and the work Westerville Corp. has collected the following data area along with the SLOPE and the INTERCEPT functions to concerning its maintenance costs for the past six month. determine the cost components. Units Produced Total Cost Calculate the variable and fixed cost elements using the high- July 18,000 $ 32,000 low method with the SLOPE and INTERCEPT functions. August 32,000 48,000 September 36,000 55,000 Units Total Cost October 22,000 38,000 High November 40,000 65,000 Low December 38,000 62,000 Variable cost per unit Total fixed costs
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
