Print this Page
the big picture
5.2.24 B24 Request Water
Close this Page

Water:
Water utility billing and management is very similar to gas services and contracts.   Meter readings take place with a unit of "cubic metres" and a rate as pounds per cubic metre.   Standing charges apply in the same way as gas contracts with a rate and units as pounds per day.
Water is unique in that two bills are calculated for each meter, one for water and one for sewerage - two service providers exist, but only the water service provider does the billing for both water and sewerage.

Selection:
The formal list of water service providers is needed - only Affinity exists at the current time.

Extra:
* For financial planning and as a Key Performance Factor (KPI), the following fields are needed as:-
ECO71 Contract Estimated Annual Commission.
ECO66 Contract Estimated Annual Spend.
ECO70 Contract Estimated Annual Saving (one year on the next).
* For brokerage renewal purposes, the following fields are added:-
ECO30 Contract Termination Days.
ECO32 Contract Letter of Termination Due Date.
ECO31 Contract Letter of Termination Step.
ECO23 Contract Renewal Step.
* For billing purposes, the following fields are added:-
ECO74 Contract Last billed Date.
ECO67 Contract Billing Frequency.
ECO35 Contract Billing VAT rules.

Water Service:
The water service that has been provided for some years, appears to cover most of the requirements identified.   As with all Bespoke Application Service facilities, the data structure is implemented at two levels as (1) service as the physical meter and (2) contract as one or many contracts that may apply from time-to-time.   In addition, readings are supported so bill analysis can be automated.   Because this overall design is identical to energy services and contracts, renewals and financial data are also identical in structure.

Details:
ESE26 is service water meter number.
ESE47 is service water meter type: landline, mobile etc...
ESE62 is service water reference: optional and may be blank.
ESE37-44 service water postal address.
ESE23-33 service water contact name: optional and may be blank.
+
ECO28 is contract water start date.
ECO29 is contract water end date.
ECO24 is contract water life cycle.
ECO25 is contract water contract step.
ECO27 is contract water provider (supplier) name.
ECO27 is contract water provider account or customer nr.
ECO41 is contract water usage rate.
ECO42 is contract water sewerage rate.
ECO72 is contract water commission rate.
ECO60 is contract water standing charge rate.
ECO51 is contract water usage units.
ECO52 is contract water sewerage units.
ECO69 is contract water commission units.
ECO62 is contract water standing charge units.

Cash Flow, Spend, Savings and Commission Forecast:
The estimated annual spend and commission are divided by the annual billing frequency to create a set of billing and commission estimated for the life of the contract.   For any selected month, the company revenue can be estimated and the staff commission can be estimated.   The estimated annual spend is the sum of all the rates multiplied by all the units, including standing or fixed charges.   The estimated annual commission is the sum of the units multiplied by the commission rate.   The commission for any month is assigned to staff based on the percentage held at the client level.   The estimated annual saving is the previous estimated annual spend minus the current estimated annual spend.

Document Control:
1. Document Title: B24 Request Water.
3. Keywords: B24 Request Water.
4. Description: B24 Request Water.
5. Privacy: Public education service as a benefit to humanity.
6. Issued: 11 Jun 2018.
7. Edition: 1.3.