Question: D E H Function: SLOPE, INTERCEPT: Cell Referencing Using Excel to Computer Variable and Fixed Cost Elements Using Regression PROBLEM Data for Stiever Corporation's maintenance
D E H Function: SLOPE, INTERCEPT: Cell Referencing Using Excel to Computer Variable and Fixed Cost Elements Using Regression PROBLEM Data for Stiever Corporation's maintenance costs is shown below 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 July August September October November December Units Produced Total Cost 18.000$ 32,000 32.000 48,000 36.000 55,000 22.000 38,000 40.000 66,100 38 62.000 Compute the variable- and fixed-cost elements using regression analysis using Excel's SLOPE and INTERCEPT functions Variable cost per unit Total foxed costs Present your solution in the form of a cost equation 0 1 2 3 4 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 30 Cost equation Total cost - per unit produced Enter
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
