Function: SLOPE, INTERCEPT; Cell Referencing

Using Excel to Computer Variable and Fixed Cost

Student Work Area

Elements Using Regression

PROBLEM

Data for Stiever Corporation's maintenance costs is shown

below.

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

PLEASE SHOW WHAT TO TYPE INTO EXCEL IN ORDER TO GET THE ANSWER

using Excel's SLOPE and INTERCEPT functions.

per unit

Total fixed costs

Present your solution in the form of a cost equation.

Cost equation

Total cost $=$

per unit produced