Calculation guide
Use a monetary credit bank. Credits offset only imported energy charges; unused credit carries fully to the next bill. Fixed charges remain payable.
Inputs
Imported kWh
Example entry 400.
Exported kWh
Example entry 250.
Import price per kWh
Example entry .25 (in the selected currency).
Export credit per kWh
Example entry .12 (in the selected currency).
Opening monetary credit
Example entry 80 (in the selected currency).
Non-creditable charges
Example entry 15 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Imported kWh | 400 |
| Exported kWh | 250 |
| Import price per kWh | 0.25 |
| Export credit per kWh | 0.12 |
| Opening monetary credit | 80 |
| Non-creditable charges | 15 |
| Result | Value |
|---|---|
| Bill payable | 15 |
| Credit carried forward | 10 |
| Credits applied | 100 |
Calculation steps
Bill payable = (Non-creditable charges + max(0, (((Imported kWh × Import price per kWh) − Opening monetary credit) − (Exported kWh × Export credit per kWh))))
(15 + max(0, (((400 × 0.25) − 80) − (250 × 0.12)))) = 15
Credit carried forward = max(0, ((Opening monetary credit + (Exported kWh × Export credit per kWh)) − (Imported kWh × Import price per kWh)))
max(0, ((80 + (250 × 0.12)) − (400 × 0.25))) = 10
Credits applied = min((Imported kWh × Import price per kWh), (Opening monetary credit + (Exported kWh × Export credit per kWh)))
min((400 × 0.25), (80 + (250 × 0.12))) = 100
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Imported kWh | 400 | 440 | Credit carried forward | 10 | 0 |
| Exported kWh | 250 | 275 | Credit carried forward | 10 | 13 |
| Import price per kWh | 0.25 | 1.25 | Bill payable | 15 | 405 |
| Export credit per kWh | 0.12 | 1.12 | Credit carried forward | 10 | 260 |
| Opening monetary credit | 80 | 88 | Credit carried forward | 10 | 18 |
| Non-creditable charges | 15 | 17 | Bill payable | 15 | 17 |
