Days |
= |
Date 2 - Date 1 |
Number Of Months Or 6 Month Periods (1) |
= |
Int ( ( ( Number Days Between Date
1 And Date 2 ) - 10 ) / ( 365 / 2 ) ) + 1
OR
Number Of Complete and Partial Months Between Date 1 And Date
2
|
Water Units Used (2) |
= |
Meter Reading 2 - Meter Reading
1 |
Sewage Units Used |
= |
(Meter Reading 2 - Meter Reading 1 ) * Sewage
Volume Allowance |
Water Units Cost |
= |
Water Units Used * Water Volume Charge |
Sewage Units Cost |
= |
Sewage Units Used * Sewage Volume Charge |
Water Fixed Charge |
= |
Period Water Fixed Charge * Number of Periods |
Sewage Fixed Charge |
= |
Period Sewage Charge * Number of Periods |
Total Fixed Charge |
= |
Water Fixed Charge + Sewage Fixed Charge |
Total Cost |
= |
Water Units Cost + Sewage Units Cost + Total
Fixed Charge - Discount 1 |
Total Cost (inc VAT) (3) |
= |
Total Cost * ( 1 + VAT%) / 100 - Discount 2 |
Predicted Days |
= |
Date a + Number of 6 Months or Months To
Predict Forward (This can be less than Actual Days) |
Water Units Used |
= |
( Meter Reading 2 - Meter Reading
1
) * ( Predicted Days / Actual Days ) |
Sewage Units Used |
= |
(Meter Reading 2 - Meter Reading 1 ) * Sewage
Volume Allowance * (Predicted Days ) / Actual Days ) |
Water Units Cost |
= |
Water Units Used * Water Volume Charge *
( Predicted Days / Actual Days ) |
Sewage Units Cost |
= |
Sewage Units Used * Sewage Volume Charge
* ( Predicted Days / Actual Days ) |
Water Fixed Charge |
= |
Period Water Fixed Charge * Number of Prediction
Periods |
Sewage Fixed Charge |
= |
Period Sewage Charge * Number of Prediction
Periods |
Total Fixed Charge |
= |
Water Fixed Charge + Sewage Fixed Charge |
Total Cost |
= |
Predicted Water Units Cost + Predicted Sewage
Units Cost + Predicted Total Fixed Charge - (Discount 1 * Number of Prediction
Periods ) |
Total Cost (inc VAT) |
= |
( Predicted Total Cost * ( 1 + VAT%) / 100 ) - (Discount 2 * Number of Prediction
Periods ) |
