Function: SLOPE, INTERCEPT; Cell Referencing Using Excel to Computer Variable and Fixed Cost Elements Using Regression Data for Stiever Corporation's maintenance costs is shown below. July August September October PROBLEM November December Units Produced Total Cost 18,000 $ 32,000 32,000 48,000 55,000 38,000 66,100 62,000 36,000 22,000 40,000 38,000 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use cell references to the Problem area to identify the high and low points. Use the SLOPE and the INTERCEPT functions with cell referencing to the Problem area. Compute the variable- and fixed-cost elements using regression analysis using Excel's SLOPE and INTERCEPT functions. Variable cost Total fixed costs Present your solution in the form of a cost equation. Cost equation per unit Total cost = + per unit produced

Function: SLOPE, INTERCEPT; Cell Referenclng Using Excel to Computer Varlable and Fixed Cost Elements Using Rerression PROBLEM Data for Stiever Corporation's maintenance costs is shown below Student Work Area Requirod: Provide input into cells shaded in yelow in this template. Use cell references to the Problem area to identify the high and low points. Use the SLOPE and the INTERCEPT functions with cell referencing to the Problem area. Compute the vanable- and fixed-cost elements using regression analysis using Excel's SLOPE and INTERCEPT functions Variable cost per unit Total fixed costs Present your solution in the form of a cost equation. Cost equation Total cost = per unit produced