FORMULA TABLE FOR HIGH LOW METHOD
(values are entered in the shaded areas)
FORMULA AUDIT TRACE
STEP 1 -- Calculating Difference in usage
and cost from high to low
(low subtracted from high)
STEP 2 -- Calculating variable cost per
unit
(cost difference divided by usage difference)
STEP 3 -- Carrying total costs forward
STEP 4 -- Calculating variable cost at the
high usage
(usage times variable cost per unit)
STEP 5 -- Calculating variable cost for the
low usage
(usage times variable cost per unit)
STEP 6 -- Calculating fixed cost
(total cost minus variable portion)