Function: SLOPE. INTERCEPT: Call Referencing Jsing Excel to Determine a Cost Equation Using the High- ow Method PROBLEM Jarkowis Corp, has collected the following data concerning Faintenance costs for the past 6 months Student Work Area Required. Provide input into cos shaded in yelow in this for plate Use col rolorences to the Problem area in the input colo in parta. In parib, use the SLOPE and the INTERCEPT functions with coll referencing to the work we Select the date to use under high-low method July August September October November December Units Produced Total Cost 18.000$ 36,000 32,000 45.000 30.000 35.000 22.000 38.000 40,000 74.500 38.000 62.000 Units 40.000 High Low Total Cost 50 MODO TODO Compute the variable and fixed-cost clomonts using Excore SLOPE and INTERCEPT functions incorrect Variable cost 15 HP score: 0.0 out of 0:318 Feedback Use the SLOPE function to determine the amount of the unit Totalfixed costs 4750 variable cost or the slope of the line created by your two chosen data points. This function takes the change in the total cost and divides it by the change in the units produced. The X variable is the number of units produced, and the variable is the total cost Be sure to well referencing to your work in part Instruction as of your score Function: SLOPE. INTERCEPT: Call Referencing Using Bacel to Determine a Cost Equation Using the High- Low Method PROBLEM Markowis Corp. has colected the following data concerning to maintenance costs for the past 6 months Student Work Area Required. Provide input into cells shaded in yelow in this template Use coll references to the Problem area in the input cels in parta. In part use the SLOPE and the INTERCEPT lucions with coll referencing to the work area 1. Select the data to use under high-low method July August 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 September October November December Total cost High Low Units 20.000 FR000 10.000 Compute the variable and fed-cost elements using Excel SLOPE and INTERCEPT functions Variable cost Totalfixed costs E 151 perunt incorrect Score 00 out of 0.318 Feedback Use the INTERCEPT function to determine the amount of total fed cost of the intercept the point where the line created by your two chosendata points crosses the ans. This function takes the total cost and subtracts the total variable costs to arrive at the totale cost. The X variable is the number of units produced, and the variable is the total cost. Be sure to use celreferencing to your work in parta Instruction: 31 of your score