A
B
D
E
F
G
H
K
L
M
A
B
C
D
E
F
G
H
Number of
Operating
Number of Miles
Trips
Costs
High/Low Method
Cost
Driven
January
700
29965
Variable cost/unit of activity=
January
16800
February
720
27910
Fixed cost
February
14200
March
925
33503
March
21000
April
650
26312
Insert text box BELOW showing resulting H/L equation and fill in the box with
Two options
1) Hand crunch numbers and input resulting
April
12000
May
500
25160
highlighting color like this one. Be sure to tell what the x and y variables
values; OR
May
10000
June
880
29605
July
685
21496
represent (e.g., x = ?; y= ?)
27320
2) Use Excel formulas and cell references to
June
17000
August
610
arrive at costs WITHOUT using any actual
July
500
September
745
28247
numbers.
August
16000
October
1020
37511
September
15100
November
1100
30974
For anyone unfamiliar with Excel, a basic
October
26900
December
1050
34987
arithmatic formula begins with "=" and contains
November
19800
cell references (e.g., B4, C9) rather than
25000
numbers.
December
Cost Prediction
To multiply, use "*"
Number of trips
Predicted cost
To divide, use "/'
1,000
-To add or subtract FIRST before multiplying or
dividing, you must put parentheses around the
cell references you wish to add or subtract.
Number of Trips
Number of Miles
Sheet3
+
D
Number of Trips
Number of Miles
Sheet3
+