|
Review of Unexpended Balances of Appropriated Funds (Not Included in CWIP as of 6/30/2009)
<br />Construction Work in Progress As of June 30, 2009
<br />(Section 5.03.CI
<br />(A) (8) (C) (D) = (A) -(8)-(C)
<br />Appropriiltion YTD Expenditures PTD Expenditures Enc umbrilnces Avililiible Billilnce
<br />(E) =(El)+ (E2) +
<br />r--�(E�1)�---�(E _2)�---�(E_3�) ---�(E_4�) ---�(E_5�) ____ (�E6�)---, (E3)+(E4)+(E5) + (E6)
<br />Expenditures in
<br />Project
<br />Wiiter Assets:
<br />CliissifiCiltion As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 As of June 30, 2009 L.....FY.2_009 __ -_10 ...... _ ... FY_2_0_1_0-_1 ... 1 _ ...... FY ... 2_0_1_1-_1_2 _..._ I .. FY ..... 20_1_2-.. 1 .. 3_..._ 1..,FY...,.20.1 .. 3-.. 1 .. 4 _ _._.. IYT.,D...,rv .,2.0 .. 1,..4-.1__,5 T ot il Ex penditures
<br />Addition to K-5 CUWlll
<br />Addition to K-5 CUW112
<br />Addition to K-5 CUW118
<br />K-5 CUW135
<br />K-S CUW143
<br />K-5 CUW148
<br />K-5 K-5
<br />K-5
<br />K-5
<br />K-5
<br />K-S
<br />K-5
<br />K-5
<br />K-5
<br />K-5
<br />K-5
<br />K-5
<br />K-5
<br />K-S
<br />K-5
<br />K-5
<br />K-5
<br />K-5
<br />K-5
<br />CUW161 CUW168
<br />CUW202
<br />CUW210
<br />CUW227
<br />CUW228
<br />CUW231
<br />CUW241
<br />CUW242
<br />CUW2SO
<br />CUW253
<br />CUW2S7
<br />CUW261
<br />CUW262
<br />CUW263
<br />CUW264
<br />CUW127
<br />CUW392
<br />CUW710
<br />CRYSTAL SP RES OP PLAN'
<br />CRYSTAL SPRINGS P/L NO 1-PHASE 21
<br />MILLBRAE SHOP-PHASE 2-B'
<br />NEW LINE & BYPASS VALVES'
<br />HETCH HETCHY WATER TREATMENT PLAN'·10
<br />ENVIRONMENTAL & REGULATORY COMP1
<br />TREATMENT FACILITIES IMPROVEMENTS'
<br />ALAMEDA CREEK FISH RELEASE
<br />SAN ANTONIO PIPELINE EMERGENCY REPAIR
<br />MILLBRAE ADMIN BLDG INTERIM REMODEL'
<br />WATERSHED FENCES/FACILITIES'
<br />WATERSHED ROADS RECONSTRUCTION'
<br />MILLBRAE LAB CAPITAL IMPROVEMENTS'
<br />FACILITIES MAINT SUPPORT STRUCTURES'
<br />DEMOLITION UNSAFE STRUCTURES'
<br />WATERSHED TRAILS & RECREATION IMPRO v'
<br />FACILITIES SECURITY PROJECT'''
<br />WATER PROTECTION'·'
<br />REGIONAL WATER STORAGE RNR -BUDGET1''
<br />TREATMENT FACS/WQ IMPROVE -BUDGET'
<br />CONVEYANCE/TRANSMISSION -BUDGET'
<br />WATERSHED ROADS -BUDGET'
<br />INST SCADA SYSTEM7'1
<br />PROGRAM MANAGEMENT SERVICES -WSIF�'·'·"
<br />OCIP PROJECT CONTROL2'1
<br />CUH977-03 HH MATHER FACILITIES TOTAL ALL PROJECTS PER K-5
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />SW
<br />ST
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />AAAACP
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />REGIONAL
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$ $
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />AAAACP REGIONAL $
<br />AAAACP LOCAL/REGIONAL $
<br />AAAACP LOCAL/REGIONAL $
<br />AAAACP LOCAL/REGIONAL $
<br />AAAACP Local $
<br />l,OSS,054 $
<br />2,422,523 $
<br />11,263,269 $
<br />4,829,680 $
<br />18,821,529 $
<br />3,241,279 $
<br />15,028,319 $ 1,S37,398 $
<br />1,400,000 $
<br />2,407,700 $
<br />3,000,000 $
<br />5,170,000 $
<br />770,000 $
<br />S,000,000 $
<br />1,000,000 $
<br />387,639 $
<br />S,300,000 $
<br />1,448,720 $
<br />1,7SO,OOO $
<br />4,801,000 $
<br />7,82S,OOO $
<br />3,000,000 $
<br />13,1S6,681 $
<br />1,000,000 $
<br />2,497,881 $
<br />73,000 $
<br />118,18 9,672 $
<br />$
<br />207 $
<br />3,998 $
<br />2,103 $
<br />164,267 $
<br />990 $
<br />334 $ 100,642 $
<br />(339,46S) $
<br />284,902 $
<br />S30,822 $
<br />85,843 $
<br />40,678 $
<br />8,390 $
<br />24,867 $
<br />9,431 $
<br />234,328 $
<br />113,871 $
<br />430,990 $
<br />896,697 $
<br />1,404,SOl $
<br />202,638 $
<br />6,221,108 $
<br />(92,112) $
<br />235,706 $
<br />13,327 $
<br />1 0,57 9,063 $
<br />1,023,222 $
<br />1,37S,634 $
<br />11,014,662 $
<br />4,689,067 $
<br />18,616,320 $
<br />3,0lS,985 $
<br />14,747,873 $ 1,094,937 $ 923,712 $
<br />l,93S,204 $
<br />2,548,376 $
<br />4,415,913 $
<br />S53,694 $
<br />4,988,882 $
<br />410,040 $
<br />112,689 $
<br />4,308,224 $
<br />497,747 $
<br />706,684 $
<br />3,201,827 $
<br />4,019,441 $
<br />1,517,064 $
<br />12,393,475 $
<br />7S8,065 $
<br />2,496,959 $
<br />SS,989 $
<br />1 01,421,685 $
<br />$
<br />$
<br />$
<br />$
<br />47,947 $
<br />$
<br />$ 125,057 $
<br />16,032 $
<br />160 $
<br />494,574 $
<br />2,742 $
<br />$
<br />$
<br />21,524 $
<br />11,233 $
<br />142,789 $
<br />481,704 $
<br />283,219 $
<br />293,371 $
<br />381,217 $
<br />14S,665 $
<br />$
<br />33,289 $
<br />$
<br />$
<br />2,48 0,523 $
<br />34,832 $
<br />1,046,889 $
<br />248,607 $
<br />140,613 $
<br />157,262 $
<br />225,294 $
<br />280,446 $ 317,404 $
<br />460,2S6 $
<br />472,336 $
<br />(42,9SO) $
<br />751,34S $
<br />216,306 $
<br />11,118 $
<br />568,436 $
<br />263,717 $
<br />848,987 $
<br />$
<br />1,327 $
<br />$
<br />23,027 $
<br />36,572 $
<br />$
<br />580 $ 11,523 $
<br />5,936 $
<br />$
<br />221,71S $
<br />$
<br />42,703 $
<br />1,74S $
<br />$
<br />4,558 $
<br />142,346 $
<br />469,269
<br />760,097
<br />1,305,802
<br />3,424,342
<br />1,337,271
<br />$ 3S7,690 $
<br />763,206
<br />208,646
<br />922
<br />17,011
<br />14,287,464
<br />$ 1,043,316 $
<br />$ 622,441 $
<br />$ 2,062,S74 $
<br />$ 687,176 $
<br />$ $
<br />$ $
<br />$ $
<br />$ 17,011 $
<br />$ 5,282,24 0 $
<br />$
<br />99 $
<br />$
<br />1,4S3 $
<br />7,125 $
<br />$
<br />45,176 $ 67,487 $
<br />5,366 $
<br />$
<br />38,212 $
<br />$
<br />54,851 $
<br />$
<br />$
<br />$
<br />100,S91 $
<br />S93,283 $
<br />$
<br />473,078 $
<br />749,747 $
<br />473,915 $
<br />$
<br />2 $
<br />$
<br />$
<br />2,610,385 $
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$ 31,045 $
<br />748,839
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />33,103 $
<br />217,706 $
<br />69,916 $
<br />$
<br />$
<br />$
<br />$
<br />1,100,609 $
<br />2,233
<br />24,981
<br />1,642
<br />17,763
<br />46,61 9 $
<br />(6,684)
<br />$
<br />$
<br />$
<br />446,362 $
<br />118,158 $
<br />$
<br />$
<br />$
<br />$ 557,836 $
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$ $
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />1,753 $
<br />$
<br />$
<br />$
<br />$ 1,753 $
<br />$
<br />1,426 $
<br />$
<br />24,480 $
<br />43,697 $
<br />$
<br />45,756 $ 105,604 $
<br />11,302 $
<br />$
<br />259,927 $
<br />$
<br />97,554 $
<br />1,745 $
<br />$
<br />4,558 $
<br />991,776 $
<br />950,973 $
<br />1,043,316 $
<br />1,153,603 $
<br />3,478,031 $
<br />1,368,681 $
<br />$
<br />$
<br />$
<br />17,011 $ 9,599,442 $
<br />(F) = (C) + (D) -(E) (GI (H)
<br />Appropriiltion
<br />Transfer Out
<br />through Ooseout
<br />(I)
<br />DEOBLIGATE /
<br />Encumbrances Process OBLIGATION
<br />Unused Balance As of June 30, 2015 As of June 30, 2015 As of June 30, 2015
<br />34,832 $
<br />1,045,463 $
<br />248,607 $
<br />116,133 $
<br />161,512 $
<br />225,294 $
<br />234,690 $ 336,857 $
<br />464,986 $
<br />472,496 $
<br />191,697 $
<br />754,087 $
<br />118,752 $
<br />9,373 $
<br />589,960 $
<br />270,392 $
<br />$
<br />$
<br />$
<br />445,570 $
<br />327,528 $
<br />114,255 $
<br />763,206 $
<br />241,933 $
<br />922 $
<br />$ 7,168,545 $
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />7,068 $
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />327,528 $
<br />$
<br />$
<br />$
<br />$
<br />$ 334,596 $
<br />34,832 $
<br />1,045,463 $
<br />248,607 $
<br />116,133 $
<br />161,512 $
<br />225,294 $
<br />234,690 $ 329,789 $
<br />464,986 $
<br />472,496 $
<br />191,697 $
<br />754,087 $
<br />118,752 $
<br />9,373 $
<br />589,960 $
<br />270,392 $
<br />$
<br />$
<br />$
<br />$
<br />$
<br />$
<br />763,206 $
<br />241,933 $
<br />922 $
<br />6,274,124 $
<br />VI= {A) -(8) -(E) -(G) (H)-(11 Unexpended
<br />Balilnces of
<br />Appropriation after
<br />Closeout and
<br />Deobligate
<br />As of June 3 0, 2 015
<br />445,570
<br />114,255
<br />559,825
<br />LOCAL PROJECTS LOCAL $ 73,000 $ 13,327 $ 55,989 $ $ 17,011 $ 17,011 $ $ $ $ $ $ 17,011 $ $ $ $ $
<br />Addition to K-5 CUW690
<br />Page 1 of 5
<br />JOINT LOCAL AND REGIONAL PROJECTS
<br />REGIONAL PROJECTS
<br />TOTAL ALL PROJECTS PER K-5
<br />Proportionill Water Use per J-Tiible
<br />Wholesille Share before Customer lnformiltion System
<br />CUSTOMER INFORMATION SYSTEM' SW
<br />(AA)
<br />(BB)
<br />LOCAL/REGIONAL $ 16,654,562 $ 6,364,702 $ 15,648,499 $ 33,289 $ 972,774 $ $ 2 $ $ $ $ $ $ 1,006,061 $ $ 1,006,061 $ $
<br />REGIONAL $ 101,462,110 $ 4,201,034 $ 85,717,197 $ 2,447,234 $ 13,297,679 $ 5,265,229 $ 2,610,383 $ 1,100,609 $ 46,619 $ 557,836 $ 1,753 $ 9,582,429 $ 6,162,484 $ 334,596 $ 5,268,063 $ $ 559,825
<br />-$,--711"'8"',1"'89"',--=6"'72 ,-T$--""10"',5"'79"""',06"'3,-T$--,1-,-01 "",4 "'2"'1"",6 "'85=-""'s---2=-,""43"'0"',s"'2"'3-,$,----=1 74,"'2s"'7"",464=--,s,---=5--=,2 7s2=-,724,-,oc-$,---=2--=,6"'1"'0,"'3ss =--s,---=1"',1 "'00"',--=609=----,,-s----,46 "',--=6"'19 ,-T$--,5"'5,:7--:,8-=-36=-Ts----,-1,-=75:,3,-$,----,9,-,5 :,99,.,-,,44,-,2=-""'s---=7,""1"'68,.,,54=5---,$,-----=3734,-,5 :,9"'6-,-,$,---,6--=,z-=74 7,"'12 ,.,4C-$,-------$,-----:5-:,59 ,-,s:,2"'5,-
<br />66.67% 65.86% 65.83% 66.56% 67.63% 65.67%
<br />(Cll = (AA) x (BB) $ 3,510,328 $ 1,719,198 $ 724,531 $ 31,030 $ 377,264 $ 1,151 $ 6,363,503
<br />AAAACP LOCAL/REGIONAL $ 8,856,574 $ 3,786,403 $ 5,757,389 $ 1,384,017 $ 62,794 $ 51,242 $ 11,552 $ - $
<br />Water Regional share (49.7% of Customer Information System up to FY 2013 and 51.2% for FY 2014)
<br />1,715,168 $ 2,400,419 $
<br />$ 1,193,008 $
<br />47,133 $
<br />23,425 $
<br />523,304 $
<br />260,082 $
<br />40,839 $
<br />20,297 $
<br />24,696 $
<br />12,644 $
<br />3,036,391 $
<br />1,509,457
<br />Wholesille share {2% from Water Regional share} (C2)
<br />Wholesale Share after Customer Information System
<br />Pooled Interest Rate in FY 2010-11
<br />Pooled Interest Rate in FY 2011-12
<br />Pooled Interest Rate in FY 2012-13 Pooled Interest Rate in FY 2013-14
<br />Estimated Pooled Interest Rate in FY 2014-15 (as of March 31, 2015}
<br />Interest Amount in FY 2010-11
<br />Interest Amount in FY 2011-12
<br />Interest Amount in FY 2012-13 Interest Amount in FY 2013-14
<br />Estimated lntere5t Amount in FY 2014-15 (as of March 31., 2015}
<br />Balance due from Wholesale Customers
<br />CC=(Cl+C2)
<br />(DDl)
<br />(DD2)
<br />(DD3) (DD4)
<br />(DDS)
<br />(EEl) = (CC) x (DDl}
<br />(EE2) = (CC) x (DD2)
<br />(EE3) = (CC) x (DD3) (EE4) = (CC) x (DD4}
<br />(EES) = (CC) x (DDS)
<br />(FF)= (CC)+ (EEl) + (EE2) + (EE3} + (EE4) + (EE5)
<br />$ 23,860 $ 469 $
<br />$ 3,534,188 $ 1,719,667 $
<br />1.24%
<br />1.11% 1.11%
<br />0.85% 0 .85% 0.663% 0.663%
<br />0.499% 0.499%
<br />5,202 $
<br />729,733
<br />0.85%
<br />0 .663%
<br />0.499%
<br />406 $ 253 $ $
<br />31,436 $ 377,517 $ 1,151 $
<br />0.663%
<br />0.499% 0.499% 0.499%
<br />_$-_43_,,'-82_4---,-$ ____ $ ____ -,$ ____ .;-$ ___ ---'$�---$
<br />_$'--_3�9.:..;;,22.;;.9;..._$'--_1;;.;;9.:.;;,0.;;.88;..._$'------$'------$'------$'------$
<br />$ 3 0,041 $ 14,617 $ 6,2 03 $ $ $ $
<br />-$',---2�3,�43 -2 -�$--1-1,�4-01-.,..$---4�,838-�$---2 -08--,-$-------,$-----$
<br />$ 17,636 $ 8,581 $ 3,641 $ 157 $ 1,884 $ 6 $
<br />$ 3,688,350 $ 1,773,355 $ 744,415 $ 31,801 $ 379,401 $ 1,157 $
<br />3 0,189
<br />6,393,692
<br />43,824
<br />58,318
<br />50,860 39,880
<br />31,905
<br />6,618,478
<br />REVISED ATTACHMENT K-5
|