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?

can you show me how to do this? Function: SLOPE, INTERCEPT; Cell

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!