Question: Function: SLOPE, INTERCEPT, Cell Referencing Using Excel to Determine a Cost Equation Using the High- Low Method PROBLEM Markow's Corp. has collected the following data
Function: SLOPE, INTERCEPT, Cell Referencing Using Excel to Determine a Cost Equation Using the High- Low Method PROBLEM Markow's Corp. has collected the following data concerning its maintenance costs for the past 6 months. Student Work Area Required: Provide input into cells shaded in yelow in this template. Use cell references to the Problem area in the input cells in parta. In part b, use the SLOPE and the INTERCEPT functions with cel referencing to the work area a Select the data to use under high-low method. July August September October November December Units Produced Total Cost 18,000 $ 36,000 32,000 45,000 36,000 55,000 22,000 38,000 40,000 74,500 38.000 62.000 Units Total Cost High Low b. Compute the variable and foed-cost elements using Excel's SLOPE and INTERCEPT functions Variable cost per unit Total foxed costs
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
