the variable and fixed cost components of your
total meals cost.
1. To get these three pieces of information you
will need three Excel functions, namely
SLOPE, INTERCEPT, and RSQ.
iii. The first step within Excel is to place your cursor
in cell F4 and press the = key. Click on the pull-
down menu and scroll down to “More Functions.”
1. The slope, or estimated variable cost per
unit, is identified on the screen as shown.
Click “OK” to put this value on your
spreadsheet.
vi. Return to the function box and click on
“Statistical” and then on “INTERCEPT.”