Water is a valuable public asset which should be available to all, not sold to the highest bidder to exploit for profits.
Validating My Consolidation Of Aqua’s Data
I suspect Aqua would deny that this represents their filing data. A way to validate the accuracy of the data is to apply Aqua’s billing rates to it and compare the resulting revenue with Aqua’s stated revenue. The following table does that for the rates in effect before the rate increase resulting from Aqua’s 2021 rate filing:
The left half of the table tabulates the billing rates and copies the consumption data from the above table. A simple multiplication then calculates revenue for each line - the red box in about the middle of the table.
The right side of the table copies Aqua’s revenue data from the six pages of their compliance filing (LINK). The numbers in yellow are a direct copy of Aqua’s data. Since Aqua’s data is divided into “Consumption” and “Adjustments”, the two are added to arrive at a total revenue - the red near the right hand side of the table.
Finally, the far right column compares my calculated revenue with Aqua’s total. For the individual rate bands the agreement is always 99.999% or better. The bottom line total differs by only $1.00 out of a total of almost $3 million. That is strong proof validating my data consolidation.
There is also a second validation. Aqua’s compliance filing also tabulated the increased revenue after the rate increase. The following table repeats the revenue comparison for the increased billing rates:
Again, it is essentially a perfect match. The “least” accurate is a 99.999% match. The bottom line differs by one dollar out of over $4 million.
My conclusion: the consolidation of Aqua’s data is accurate.