Days |
= |
Date 2 - Date 1 |
Number Of Months
Or 6 Month Periods ** |
= |
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 |
= |
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 |
Total Cost (inc
VAT) |
= |
Total Cost * ( 1 + VAT%) / 100 |
** See Using EnCalcLU for an explanation of this
formula which is used to work out the multiplier for fixed charges
and predictions
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 |
Total Cost (inc VAT) |
= |
Predicted Total Cost * ( 1 +
VAT%) / 100 |
