calculating water rates on a per thousand/tier

I am trying to calculate a water table that I could change the rates in B12-B23 in order to get a monthly bill about for water consumption. I have found several issues.   Even if 0 qty is used ther...