SheetJS Table Export
BILL SEGREGATION CALCULATOR
Billing MonthUnit BilledVC CharegedC/O Marth Sb.
Sep-22
Oct-22
Nov-2270
Dec-2270
Jan-2370
Feb-2370
Mar-2370
Apr-237.740
May-237.740
Jun-237.740
Jul-23120
Aug-2332.030
Sep-23
Oct-23
Nov-23
Dec-23
As Charged00
No of Months5
Units Per Month0-100
Protected
(If Units are less than 200 and have Less than 200 units in prevous 6 Monts)
Rate for 100 Units7.747.74
VC of 100 Units3870
Rate For Remaining Units10.0610.06
VC for Remaining Units-5030
AS Charged0
Un ProtectedUnit Rate14To Be Charged-1160
To be Charged0VC1160
VC0ED17
ED0GST197
GST0LPS1296
LPS1296Amount adjusted1160
Total Adjustment1296Total Adjustment2671
BILL AMOUNT18000BILL AMOUNT18000
REVISED E BILL16704REVISED E BILL15329.4

Comments