Impressive calculations, Steve. I just wondered as I read, what you were actually supposed to be doing when you diverted your attention to this problem...
Toni: the obvious solution to the subdivision's water problem is not to build so many new houses. Subdivisions are over running the countryside and cities are empty.