D.16-06-004
2018
ttac
ment
Page 1 of 1
Water Conservation Memorandum Account
Twelve Months Ended December 31, 2018
Potable water
SALES DATA (CCF)
601.10 METERED RESIDENTIAL
JAN 2018 FEB 2018 MAR 2018 APR 2018 MAY 2018 JUN 2018 JUL 2018 AUG 2018 SEP 2018 OCT 2018 NOV 2018 DEC 2018 2018 Total
Actual Consumption (CCF) 1,958,272 1,617,982 1,604,456 1,500,483 1,651,111 2,056,920 2,740,314 2,541,484 2,843,080 2,491,190 2,624,592 2,244,476 25,874,360
Adopted Usage/Customer 146.6
Monthly Allocation - 3 Yr. Average Distribution 6.60% 5.35% 5.62% 5.68% 7.36% 8.70% 11.35% 10.39% 11.64% 9.92% 9.77% 7.64% 100.00%
Allocated Adopted CCF/Customer 9.67 7.85 8.24 8.32 10.79 12.75 16.63 15.23 17.06 14.54 14.32 11.21 146.60
Recorded # Customers 199,006 199,018 199,138 199,242 199,448 199,053 199,034 199,257 199,521 199,738 199,808 199,691
Normalized Adopted Sales 1,924,388 1,561,376 1,639,952 1,658,635 2,151,412 2,538,253 3,310,633 3,033,957 3,403,789 2,903,412 2,861,644 2,237,834 29,225,284
Difference Actual vs. Normalized Adopted Sales (CCF) 33,884 56,606 (35,495) (158,152) (500,301) (481,333) (570,318) (492,472) (560,710) (412,222) (237,052) 6,642 (3,350,924)
601.10 METERED BUSINESS
Actual Consumption (CCF) 1,201,156 1,168,834 1,057,162 1,102,563 1,174,769 1,446,909 1,642,845 1,684,236 1,582,018 1,633,706 1,489,708 1,432,422 16,616,329
Adopted Usage/Customer 858.3
Monthly Allocation - 3 Yr. Average Distribution 6.53% 6.65% 5.85% 7.04% 7.70% 9.62% 9.68% 10.33% 9.87% 9.74% 8.51% 8.48% 100.00%
Allocated Adopted CCF/Customer 56.04 57.11 50.24 60.40 66.07 82.56 83.10 88.68 84.71 83.58 73.06 72.77 858.30
Recorded # Customers 20,610 20,585 20,636 20,619 20,641 20,639 20,658 20,668 20,681 20,682 20,689 20,687
Normalized Adopted Revenue 1,155,074 1,175,586 1,036,654 1,245,402 1,363,805 1,703,883 1,716,597 1,832,891 1,751,795 1,728,510 1,511,471 1,505,343 17,727,011
Difference Actual vs. Normalized Adopted Sales (CCF) 46,082 (6
,752) 20,509 (142,838) (189,036) (256,974) (73,752) (148,655) (169,778) (94,804) (21,763) (72,921) (1,110,682)
601.20 METERED INDUSTRIAL
ACTUAL 16,825 16,703 16,470 18,700 19,538 21,044 19,795 21,111 19,355 22,788 18,241 20,152 230,721
ADP CCF/CUST 3,830.2
Monthly Allocation - 3 Yr. Average Distribution 6.30% 8.08% 6.77% 7.19% 8.83% 9.99% 8.07% 10.28% 8.18% 8.75% 9.20% 8.35% 100.00%
Allocated Adopted CCF/Customer 241.35 309.52 259.23 275.44 338.18 382.80 309.12 393.75 313.31 335.32 352.41 319.76 3,830
REC # CUST 53 54 52 52 51 51 52 52 54 54 54 54
NORMALIZED 12,792 16,714 13,480 14,323 17,247 19,523 16,074 20,475 16,919 18,107 19,030 17,267 201,951
Difference Actual vs. Normalized Adopted Sales (CCF) 4,033 (11) 2,990 4,377 2,291 1,521 3,721 636 2,436
4,681 (789) 2,885 28,771
601.30 METERED PUBLIC AUTHORITY
ACTUAL 82,950 82,793 90,038 89,191 202,527 302,129 344,704 335,121 330,521 280,556 217,748 120,309 2,478,588
ADP CCF/CUST 1,969.8
Monthly Allocation - 3 Yr. Average Distribution 2.8% 3.2% 3.4% 5.1% 10.3% 13.5% 14.4% 14.3% 13.1% 9.6% 6.6% 3.7% 100.00%
Allocated Adopted CCF/Customer 55.28 62.41 66.23 100.12 202.28 266.91 283.95 282.28 257.48 190.00 130.01 72.91 1,970
REC # CUST 1,310 1,310 1,310 1,311 1,310 1,309 1,307 1,307 1,306 1,305 1,305 1,305
NORMALIZED 72,413 81,755 86,756 131,253 264,984 349,380 371,121 368,945 336,269 247,945 169,665 95,141 2,575,627
Difference Actual vs. Normalized Adopted Sales (CCF) 10,537 1
,039 3,282 (42,061) (62,457) (47,251) (26,417) (33,824) (5,748) 32,611 48,083 25,168 (97,040)
603.10 Resale
ACTUAL 12,848 12,834 10,410 10,745 15,884 20,406 21,944 23,713 22,749 20,004 19,938 15,033 206,508
ADP CCF/CUST 10,062.5
Monthly Allocation - 3 Yr. Average Distribution 3.73% 4.03% 3.70% 4.80% 8.34% 10.76% 13.89% 12.36% 12.81% 11.95% 7.00% 6.63% 100.0%
Allocated Adopted CCF/Customer 375.51 405.13 371.96 483.36 839.25 1,082.52 1,397.73 1,243.34 1,289.15 1,202.74 704.63 667.19
10,063
REC # CUST 33 33 33 33 33 33 33 33 33 33 33 33
NORMALIZED 12,392 13,369 12,275 15,951 27,695 35,723 46,125 41,030 42,542 39,690 23,253 22,017 332,063
Difference Actual vs. Normalized Adopted Sales (CCF) 456 (535) (1,865) (5,206) (11,811) (15,317) (24,181) (17,317) (19,793) (19,686) (3,315) (6,984) (125,555)
609.00 RAW WATER SALES
ACTUAL 844 733 426 1,526 23,296 17,178 20,440 23,589 20,509 15,376 12,504 6,723 143,143
ADP CCF/CUST 3,500.0
Monthly Allocation - 3 Yr. Average Distribution 3.73% 4.03% 3.70% 4.80% 8.34% 10.76% 13.89% 12.36% 12.81% 11.95% 7.00% 6.63% 100.0%
Allocated Adopted CCF/Customer 130.611 140.916 129.377 168.124 291.914 376.530 486.166 432.468 448.400 418.343 245.088 232.064 3,500.000
REC # CUST 5 5 5 5 5 5 5 5 5 5 5 5
NORMALIZED 653.054 704.580 646.887 840.619 1,459.572 1,882.650 2,430.828 2,162.338 2,241.998 2,091.714 1,225.438 1,160.322 17,500
Difference Actual vs. Normalized Adopted S
ales (CCF) 191 28 (221) 686 21,837 15,295 18,009 21,426 18,267 13,284 11,278 5,563 125,643
609.00 OTHER SALES
ACTUAL 5,538 2,962 6,331 5,259 13,116 12,446 12,211 7,791 13,722 12,708 7,039 7,072 106,195
ADP CCF/CUST 424.5
Monthly Allocation - 3 Yr. Average Distribution 2.38% 3.98% 4.24% 4.03% 7.11% 8.23% 16.58% 10.14% 13.18% 11.59% 7.54% 11.01% 100.0%
Allocated Adopted CCF/Customer 10.10 16.91 18.00 17.09 30.19 34.93 70.37 43.04 55.94 49.22 32.01 46.73 424.53
REC # CUST 236 222 213 221 234 268 268 280 271 277 283 272 3,045
NORMALIZED 2,383 3,755 3,834 3,778 7,065 9,361 18,859 12,051 15,161 13,633 9,058 12,710 111,647
Difference Actual vs. Normalized Adopted Sales (CCF) 3,155 (793) 2,497 1,481 6,051 3,085 (6,648) (4,260) (1,439) (925) (2,019) (5,638) (5,452)
TOTAL SALES DIFFERENCE (CCF) 98,338 49,581 (8,303) (341,714) (733,427) (780,974) (679,586) (674,467) (736,763) (477,062) (205,575) (45,285) (4,535,238)
Total Quantity Vo
lumes 3,277,589 2,902,108 2,784,867 2,726,942 3,076,946 3,859,854 4,781,812 4,613,457 4,811,444 4,460,952 4,377,266 3,839,464 45,512,701
Quantity Rates
Effective date 1/1/2018 1/1/2018 1/1/2018 &3/22/18 3/22/2018 3/22/2018 3/22/2018 7/1/2018 7/1/2018 8/25/2018 8/25/2018 8/25/2018 8/25/2018
Uniform Rate App. to All Potable Water Excl. Raw $5.6482 $5.6482 $5.6211 $5.5670 $5.5670 $5.5670 $5.6222 $5.6222 $5.6660 $5.6660
$5.6660 $5.6660
Revenue Loss Excluding Raw Water $ 554,355 $ 279,884 $ (45,433) $ (1,906,137) $ (4,204,552) $ (4,432,832) $ (3,922,022) $ (3,912,450) $ (4,278,002) $ (2,778,301) $ (1,228,694) $ (288,104) $ (26,162,288)
Raw Water Rates per CCF $5.4186 $5.4186 $5.3915 $5.3374 $5.3374 $5.3374 $5.3926 $5.3926 $5.4464 $5.4464 $5.4464 $5.4464
Revenue Loss
Raw Water $1,035 $154 ($1,191) $3,659 $116,550 $81,635 $97,116 $115,544 $99,490 $72,350 $61,426 $30,298 $678,066
GROSS REVENUE GAIN (LOSS) $ 555,389 $ 280,038 $ (46,624) $ (1,902,478) $ (4,088,001) $ (4,351,196) $ (3,824,906) $ (3,796,907) $ (4,178,512) $ (2,705,951) $ (1,167,267) $ (257,807) $ (25,484,222)
GROSS REVENUE GAIN (LOSS) 0 $ 555,389 $ 280,038 $ (46,624) $ (1,902,478) $ (4,088,001) $ (4,351,196) $ (3,824,906) $ (3,796,907) $ (4,178,512) $ (2,705,951) $ (1,167,267) $ (257,807) $ (25,484,222)
Details of Variable Cos
t Reductions:
PURCHASED POWER 17,693 8,921 (1,494) (61,482) (131,960) (140,514) (122,273) (121,351) (132,560) (85,834) (36,988) (8,148) (815,989)
PURCHASED WATER 178,497 89,997 (15,072) (620,257) (1,331,270) (1,417,575) (1,343,250) (1,333,131) (1,456,264) (942,947) (406,334) (89,509) (8,687,115)
PUMP TAXES 110,450 55,688 (9,326) (383,800) (823,758) (877,162) (836,954) (830,648) (907,370) (587,532) (253,179) (55,771) (5,399,364)
LEASED WATER RIGHTS
- - - - - - - - - - - - -
Chemical Costs 940 474 (79) (3,267)
(7,012) (7,467) (6,498) (6,449) (7,044) (4,561) (1,966) (433) (43,363)
UNCOLLECTIBLES 1,088 549 (92) (3,782) (8,117) (8,643) (7,804) (7,745) (8,531) (5,524) (2,380) (524) (51,505)
LOCAL TAXES 1,787 901 (151) (6,209) (13,328) (14,192) (12,796) (12,700) (13,984) (9,055) (3,902) (860) (84,489)
Subtotal - Variable Cost Increase (Reduction) 310,456 156,529 (26,214) (1,078,798) (2,315,445) (2,465,553) (2,329,574) (2,312,024) (2,525,754) (1,635,453) (704,749) (155,245) (15,081,825)
20 BASIS PT. ADJ. * (117,536) (117,536) (122,927) (121,954) (121,954) (121,954) (121,954) (121,954) (124,811) (124,811) (124,811) (124,811) (1,467,012)
Total Adjustments to Gross Lost Revenue 192,919 38,993 (149,141) (1,200,752) (2,437,398) (2,587,507) (2,451,528) (2,433,978) (2,650,565) (1,760,264) (829,560) (280,056) ($16,548,837)
ADJUSTED NET REVENUE - OVER- (UNDER-) RECOVERY
362,470 241,045 102,517 (701,727) (1,650,603) (1,763,689) (1,373,378) (1,362,928) (1,527,947) (945,687) (337,707) 22,249 (8,935,385)
*Acutal Consumption taken fr
om JV 1
Raw Consumption is included in Resale Category in JV1
**Raw Consumption is taken from CC&B report "Monthly_Sales-
Raw
Aug 15 onward provided monthly from Customer Systems.
***Number of Raw Customers is taken from Rate Statistics by SA
Ty
pe (CMSA020A) provided by Customer Systems or Accounting.