|
6.G. - Page 189 of 238
<br />Page 1 of 5 REVISED ATTACHMENT K-5
<br />520
<br />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.0)
<br />(E) _ (Ell + (E2) +
<br />(1) = (A) - (el - (E) - (G) -
<br />(A)
<br />(a)
<br />(C)
<br />(D)=(A)-(a)-(C)
<br />(EL)
<br />(E2)
<br />(E3)
<br />(E4)
<br />IES)
<br />(E6)
<br />(E3)+(E4)+(ES)+(E6)
<br />IF)
<br />=(C)+(D)-(E)
<br />(G)
<br />(H)
<br />(I)
<br />(H)-(1)
<br />Unexpended
<br />Appropriation
<br />Balances of
<br />Transfer
<br />Out
<br />Appropriation after
<br />through Closeout
<br />DEOBUGATE /
<br />Closeout and
<br />Appropriation
<br />YTD Expenditures
<br />PTD Expenditures
<br />Encumbrances
<br />Available Balance
<br />Expenditures
<br />in
<br />Encumbrances
<br />Process
<br />OBLIGATION
<br />Deobligate
<br />ro'ect
<br />Project Title
<br />Fund Tyne
<br />Subfund Classification
<br />As of June 30, 2009
<br />As of June
<br />30, 2009
<br />As of lune
<br />30, 2009
<br />As of June 30, 2009 As of lune
<br />30, 2009
<br />FY 2009-10
<br />FY 203011
<br />FY 2011-12 I
<br />FY 2012-13 I
<br />FY 2013-14 I
<br />YTD FY 2014.15
<br />Total Expenditures
<br />Unused
<br />Balance
<br />As of lune 30, 2015 As of June 30, 2015
<br />As of June 30, 2015
<br />As of June 30, 2015.
<br />Water Assets•
<br />Addition to K-5
<br />CUW111
<br />CRYSTAL SP RES OP PLAN'
<br />SW
<br />AAAACP REGIONAL
<br />$ 1,058,054
<br />$
<br />-
<br />$
<br />1,023,222
<br />$ -
<br />$
<br />34,832
<br />$
<br />-
<br />$ -
<br />$ -
<br />$
<br />-
<br />$
<br />-
<br />$
<br />-
<br />$ -
<br />$
<br />34,832
<br />$ -
<br />$
<br />34,832
<br />$ -
<br />$ -
<br />Addition to K-5
<br />CUW112
<br />CRYSTAL SPRINGS P/L NO 1 -PHASE 2'
<br />SW
<br />AAAACP REGIONAL
<br />$ 2,422,523
<br />$
<br />207
<br />$
<br />1,375,634
<br />$
<br />$
<br />1,046,889
<br />$
<br />1,327
<br />$ 99
<br />$
<br />$
<br />S
<br />S
<br />$ 1,426
<br />$
<br />1,045,463
<br />$
<br />$
<br />1,045,463
<br />$
<br />$
<br />Addition to K-5
<br />CUW118
<br />MILLBRAE SHOP -PHASE 2-B'
<br />SW
<br />AAAACP REGIONAL
<br />$ 11,263,269
<br />$
<br />3,998
<br />$
<br />11,014,662
<br />$ -
<br />$
<br />248,607
<br />$
<br />.
<br />$ -
<br />$ -
<br />$
<br />$
<br />$
<br />-
<br />$ -
<br />$
<br />248,607
<br />$ -
<br />$
<br />248,607
<br />$ -
<br />$ -
<br />K-5
<br />CUW135
<br />NEW LINE &BYPASS VALVES'
<br />SW
<br />AAAACP REGIONAL
<br />$ 4,829,680
<br />$
<br />2,103
<br />$
<br />4,689,067
<br />$ -
<br />$
<br />140,613
<br />$
<br />23,027
<br />$ 1,453
<br />$ -
<br />$
<br />-
<br />$
<br />-
<br />$
<br />-
<br />$ 24,480
<br />$
<br />116,133
<br />$ -
<br />$
<br />116,133
<br />$ -
<br />-
<br />K-5
<br />CUW143
<br />HETCH HETCHY WATER TREATMENT PLAN' '10
<br />5W
<br />AAAACP REGIONAL
<br />$ 18,821,529
<br />$
<br />164,267
<br />$
<br />18,616,320
<br />$ 47,947
<br />$
<br />157,262
<br />$
<br />36,572
<br />$ 7,125
<br />$ -
<br />$
<br />-
<br />$
<br />-
<br />$
<br />-
<br />$ 43,697
<br />$
<br />161,512
<br />$ -
<br />$
<br />161,512
<br />$ -
<br />$ -
<br />K-5
<br />CUW148
<br />ENVIRONMENTAL& REGULATORY COMP'
<br />SW
<br />AAAACP REGIONAL
<br />$ 3,241,279
<br />$
<br />990
<br />$
<br />3,015,985
<br />$ -
<br />$
<br />225,294
<br />$
<br />-
<br />$ -
<br />$
<br />$
<br />-
<br />$
<br />$
<br />-
<br />$ -
<br />$
<br />225,294
<br />$ -
<br />$
<br />225,294
<br />$
<br />$ -
<br />K-5
<br />CUW161
<br />TREATMENT FACILITIES IMPROVEMENTS'
<br />SW
<br />AAAACP REGIONAL
<br />$ 15,028,319
<br />$
<br />334
<br />$
<br />14,747,873
<br />$ •
<br />$
<br />280,446
<br />$
<br />580
<br />$ 45,176
<br />$
<br />$
<br />-
<br />$
<br />$
<br />$ 45,756
<br />$
<br />234,690
<br />$
<br />$
<br />234,690
<br />$
<br />$ -
<br />K-5
<br />CUW168
<br />ALAMEDA CREEK FISH RELEASE
<br />5W
<br />AAAACP REGIONAL
<br />$ 1,537,398
<br />$
<br />100,642
<br />$
<br />1,094,937
<br />$ 125,057
<br />$
<br />317,404
<br />$
<br />11,523
<br />$ 67,487
<br />$ 31,045
<br />$
<br />2,233
<br />$
<br />(6,684)
<br />$ 105,604
<br />$
<br />336,857
<br />$ 7,068
<br />$
<br />329,789
<br />$ -
<br />$ -
<br />K-5
<br />CUW202
<br />SAN ANTONIO PIPELINE EMERGENCY REPAIR
<br />5W
<br />AAAACP REGIONAL
<br />$ 1,400,000
<br />$
<br />(339,465)
<br />$
<br />923,712
<br />$ 16,032
<br />$
<br />460,256
<br />$
<br />5,936
<br />$ 5,366
<br />$ -
<br />$
<br />-
<br />$
<br />$
<br />-
<br />$ 11,302
<br />$
<br />464,986
<br />$ -
<br />$
<br />464,986
<br />$ -
<br />$
<br />K-5
<br />CUW210
<br />MILLBRAE ADMIN BLDG INTERIM REMODEL'
<br />SW
<br />AAAACP REGIONAL
<br />$ 2,407,700
<br />$
<br />284,902
<br />$
<br />1,935,204
<br />$ 160
<br />$
<br />472,336
<br />$
<br />.
<br />$ -
<br />$ -
<br />$
<br />$
<br />-
<br />$
<br />$ .
<br />$
<br />472,496
<br />$ -
<br />$
<br />472,496
<br />$
<br />$ -
<br />K-5
<br />CUW227
<br />WATERSHED FENCES/FACILITIES'
<br />SW
<br />AAAACP REGIONAL
<br />$ 3,000,000
<br />$
<br />530,822
<br />$
<br />2,548,376
<br />$ 494,574
<br />$
<br />(42,950)
<br />$
<br />221,715
<br />$ 38,212
<br />$ -
<br />$
<br />-
<br />$
<br />-
<br />$
<br />-
<br />$ 259,927
<br />$
<br />191,697
<br />$ -
<br />$
<br />191,697
<br />$ -
<br />$ -
<br />K-5
<br />CUW228
<br />WATERSHED ROADS RECONSTRUCTION'
<br />SW
<br />AAAACP REGIONAL
<br />$ 5,170,000
<br />$
<br />85,843
<br />$
<br />4,415,913
<br />$ 2,742
<br />$
<br />751,345
<br />$
<br />-
<br />$ -
<br />$ -
<br />$
<br />-
<br />S
<br />-
<br />S
<br />-
<br />$ -
<br />$
<br />754,087
<br />$ -
<br />$
<br />754,087
<br />$ -
<br />$ -
<br />K-5
<br />CUW231
<br />MILLBRAE LAB CAPITAL IMPROVEMENTS'
<br />SW
<br />AAAACP REGIONAL
<br />$ 770,000
<br />$
<br />40,678
<br />$
<br />553,694
<br />$ -
<br />$
<br />216,306
<br />$
<br />42,703
<br />$ 54,851
<br />$ -
<br />$
<br />$
<br />$
<br />-
<br />$ 97,554
<br />$
<br />118,752
<br />$
<br />$
<br />118,752
<br />$
<br />S -
<br />K-5
<br />CUW241
<br />FACILITIES MAINT SUPPORT STRUCTURES'
<br />SW
<br />AAAACP REGIONAL
<br />$ 5,000,000
<br />$
<br />8,390
<br />$
<br />4,988,882
<br />$ -
<br />$
<br />11,118
<br />$
<br />1,745
<br />$ -
<br />$ -
<br />$
<br />$
<br />-
<br />$
<br />-
<br />$ 1,745
<br />$
<br />9,373
<br />$
<br />$
<br />9,373
<br />$
<br />$ -
<br />K-5
<br />CUW242
<br />DEMOLITION UNSAFE STRUCTURES'
<br />SW
<br />AAAACP REGIONAL
<br />$ 1,000,000
<br />$
<br />24,867
<br />$
<br />410,040
<br />$ 21,524
<br />$
<br />568,436
<br />$
<br />-
<br />$ -
<br />$ -
<br />$
<br />-
<br />S
<br />-
<br />$
<br />-
<br />$ -
<br />$
<br />589,960
<br />$ -
<br />$
<br />589,960
<br />$ -
<br />$ -
<br />K-5
<br />CUW250
<br />WATERSHED TRAILS& RECREATION IMPROV
<br />SW
<br />AAAACP REGIONAL
<br />$ 387,639
<br />$
<br />9,431
<br />$
<br />112,689
<br />$ 11,233
<br />$
<br />263,717
<br />$
<br />4,558
<br />$ -
<br />$ -
<br />$
<br />-
<br />5
<br />-
<br />$
<br />-
<br />$ 4,558
<br />$
<br />270,392
<br />$ -
<br />$
<br />270,392
<br />$ -
<br />S -
<br />K-5
<br />CUW253
<br />FACILITIES SECURITY PROJECT"'
<br />SW
<br />AAAACP REGIONAL
<br />$ 5,300,000
<br />$
<br />234,328
<br />$
<br />4,308,224
<br />$ 142,789
<br />$
<br />848,987
<br />$
<br />142,346
<br />$ 100,591
<br />$ 748,839
<br />$ 991,776
<br />$
<br />-
<br />$ -
<br />$
<br />-
<br />$ -
<br />$ -
<br />K-5
<br />CUW257
<br />WATER PROTECTION'''
<br />SW
<br />AAAACP REGIONAL
<br />$ 1,448,720
<br />$
<br />113,871
<br />$
<br />497,747
<br />$ 481,704
<br />$
<br />469,269
<br />$
<br />357,690
<br />$ 593,283
<br />$
<br />$
<br />$
<br />-
<br />$
<br />-
<br />$ 950,973
<br />$
<br />$
<br />$
<br />$
<br />$
<br />K-5
<br />CUW261
<br />REGIONAL WATER STORAGE RNR - BUDGET'"
<br />SW
<br />AAAACP REGIONAL
<br />$ 1,750,000
<br />$
<br />430,990
<br />$
<br />706,684
<br />$ 283,219
<br />$
<br />760,097
<br />$
<br />1,043,316
<br />$ -
<br />$ -
<br />$
<br />-
<br />5
<br />-
<br />$
<br />-
<br />$ 1,043,316
<br />$
<br />-
<br />$ -
<br />$
<br />-
<br />$ -
<br />$ -
<br />K-5
<br />CUW262
<br />TREATMENT FACS/WQ IMPROVE - BUDGET'
<br />SW
<br />AAAACP REGIONAL
<br />$ 4,801,000
<br />$
<br />896,697
<br />$
<br />3,201,827
<br />$ 293,371
<br />$
<br />1,305,802
<br />$
<br />622,441
<br />$ 473,078
<br />$ 33,103
<br />$
<br />24,981
<br />$
<br />-
<br />$
<br />-
<br />$ 1,153,603
<br />$
<br />445,570
<br />$ -
<br />$
<br />-
<br />$ -
<br />$ 445,570
<br />K-5
<br />CUW263
<br />CONVEYANCE/TRANSMISSION - BUDGET'
<br />SW
<br />AAAACP REGIONAL
<br />$ 7,825,000
<br />$
<br />1,404,501
<br />$
<br />4,019,441
<br />$ 381,217
<br />$
<br />3,424,342
<br />$
<br />2,062,574
<br />$ 749,747
<br />$ 217,706
<br />$
<br />1,642
<br />S
<br />446,362
<br />$
<br />$ 3,478,031
<br />$
<br />327,528
<br />$ 327,528
<br />$
<br />-
<br />$ -
<br />S -
<br />K-5
<br />CUW264
<br />WATERSHED ROADS - BUDGET'
<br />SW
<br />AAAACP REGIONAL
<br />$ 3,000,000
<br />$
<br />202,638
<br />$
<br />1,517,064
<br />$ 145,665
<br />$
<br />1,337,271
<br />$
<br />687,176
<br />$ 473,915
<br />$ 69,916
<br />$
<br />17,763
<br />$
<br />118,158
<br />$
<br />1,753
<br />$ 1,368,681
<br />$
<br />114,255
<br />$ -
<br />$
<br />-
<br />$ -
<br />$ 114,255
<br />K-5
<br />CUW127
<br />I NST SCADA SYSTEM'" s
<br />SW
<br />AAAACP LOCAUREGIONAL
<br />$ 13,156,681
<br />$
<br />6,221,108
<br />$
<br />12,393,475
<br />$
<br />$
<br />763,206
<br />$
<br />.
<br />$ •
<br />$ -
<br />$
<br />•
<br />$
<br />.
<br />$
<br />$ -
<br />$
<br />763,206
<br />$ -
<br />$
<br />763,206
<br />$
<br />S
<br />K-5
<br />CUW392
<br />PROGRAM MANAGEMENT SERVICES -WSIF''°'''10
<br />SW
<br />AAAACP LOCAUREGIONAL
<br />$ 1,000,000
<br />$
<br />(92,112)
<br />$
<br />758,065
<br />$ 33,289
<br />$
<br />208,646
<br />$
<br />-
<br />$ 2
<br />$ -
<br />$
<br />-
<br />$
<br />-
<br />$
<br />-
<br />$ 2
<br />$
<br />241,933
<br />$ -
<br />$
<br />241,933
<br />$ -
<br />-
<br />K-5
<br />CUW710
<br />OCI P PROJ ECT CONTROL'''
<br />SW
<br />AAAACP LOCAL/REGIONAL
<br />$ 2,497,881
<br />$
<br />235,706
<br />$
<br />2,496,959
<br />$ -
<br />$
<br />922
<br />$
<br />-
<br />$ -
<br />$ -
<br />$
<br />-
<br />$
<br />-
<br />$
<br />-
<br />$ -
<br />$
<br />922
<br />$ -
<br />$
<br />922
<br />$ -
<br />$ -
<br />CUH977-03
<br />HH MATHER FACILITIES
<br />5T
<br />AAAACP Local
<br />$ 73,000
<br />$
<br />13,327
<br />$
<br />55,989
<br />$ -
<br />$
<br />17,011
<br />$
<br />17,011
<br />$ -
<br />$ -
<br />$
<br />-
<br />$
<br />$
<br />-
<br />$ 17,011
<br />$
<br />-
<br />$ -
<br />$
<br />-
<br />$ -
<br />TOTAL ALL PROJECTS PER K-5
<br />118,189,672
<br />$
<br />10,579,063
<br />$
<br />101,421,685
<br />$ 2,480,523
<br />$
<br />14,287,464
<br />$
<br />5,282,240
<br />$ 2,610,385
<br />$ 1,100,609
<br />$
<br />46,619
<br />$
<br />557,836
<br />$
<br />1,753
<br />$ 9,599,442
<br />$
<br />7,168,545
<br />$ 334,596
<br />$
<br />6,274,124
<br />$
<br />559,825
<br />LOCAL PROJECTS
<br />LOCAL
<br />$ 73,000
<br />$
<br />13,327
<br />$
<br />55,989
<br />$ -
<br />$
<br />17,011
<br />$
<br />17,011
<br />$ -
<br />$ -
<br />$
<br />-
<br />$
<br />$
<br />-
<br />$ 17,011
<br />$
<br />-
<br />$ -
<br />$
<br />-
<br />$ -
<br />$ -
<br />JOINT LOCAL AND REGIONAL PROJECTS
<br />LOCAUREGIONAL
<br />$ 16,654,562
<br />$
<br />6,364,702
<br />$
<br />15,648,499
<br />$ 33,289
<br />$
<br />972,774
<br />$
<br />-
<br />$ 2
<br />$ -
<br />$
<br />-
<br />$
<br />-
<br />$
<br />-
<br />$ 2
<br />$
<br />1,006,061
<br />$ -
<br />$
<br />1,006,061
<br />$ -
<br />$
<br />REGIONAL PROJECTS
<br />(AA) REGIONAL
<br />$ 101,462,110
<br />$
<br />4,201,034
<br />$
<br />85,717,197
<br />$ 2,447,234
<br />$
<br />13,297,679
<br />$
<br />5,265,229
<br />$ 2,610,383
<br />$ 1,100,609
<br />$
<br />46,619
<br />$
<br />557,836
<br />$
<br />1,753
<br />$ 9,582,429
<br />$
<br />6,162,484
<br />$ 334,596
<br />$
<br />5,268,063
<br />$
<br />$ 559,825
<br />TOTAL ALL PROJECTS PER K-5
<br />$ 118,189,672
<br />$
<br />10,579,063
<br />$
<br />101,421,685
<br />$ 2,480,523
<br />$
<br />14,287,464
<br />$
<br />5,282,240
<br />$ 2,610,395
<br />$ 1,100,609
<br />$
<br />46,619
<br />$
<br />557,836
<br />$
<br />1,753
<br />$ 9,599,442
<br />$
<br />7,168,545
<br />$ 334,596
<br />$
<br />6,274,124
<br />$ -
<br />$ 559,825
<br />Proportional Water Use per J -Table
<br />(BB)
<br />66.67%
<br />65.86%
<br />65.83%
<br />66.569.
<br />67.63%
<br />65.67%
<br />Wholesale Share before Customer Information System
<br />(Cl) _ (AA) x (BB)
<br />$
<br />3,510,328
<br />$ 1,719,198
<br />$ 724,531
<br />$
<br />31,030
<br />$
<br />377,264
<br />$
<br />1,151
<br />$ 6,363,503
<br />Addition to K-5
<br />CUW690
<br />CUSTOMER INFORMATION SYSTEM'
<br />SW
<br />AAAACP LOCAUREGIONAL
<br />$ 8,856,574
<br />$
<br />3,786,403
<br />$
<br />5,757,389
<br />$ 1,384,017
<br />$
<br />1,715,168
<br />$
<br />2,400,419
<br />$ 47,133
<br />$ 523,304
<br />$
<br />40,839
<br />$
<br />24,696
<br />$
<br />-
<br />$ 3,036,391
<br />$
<br />62,794
<br />$ 51,242
<br />$
<br />11,552
<br />$ -
<br />$ -
<br />Water Regional share (49.7% of Customer Information System up to FY 2013 and 51.2% for FY 2014)
<br />S
<br />1.193.008
<br />S 23.425
<br />$ 260,082
<br />$
<br />20,297
<br />S
<br />12,644
<br />$
<br />S 1.509.457
<br />Wholesale share (2% from Water Regional share)
<br />(C2)
<br />$
<br />23,860
<br />$ 469
<br />$ 5,202
<br />$
<br />406
<br />$
<br />253
<br />$
<br />$ 30,189
<br />Wholesale Share after Customer Information System
<br />CC= (Cl +C2)
<br />$
<br />3,534,188
<br />$ 1,719,667
<br />$ 729,733
<br />S
<br />31,436
<br />$
<br />377,517
<br />i$
<br />1,151
<br />$ 6,393,692
<br />Pooled Interest Rate in FY 2010-11
<br />(DDI)
<br />1.2491
<br />-
<br />-
<br />-
<br />-
<br />Pooled Interest Rate in FY 2011-12
<br />(DD2)
<br />1.11%
<br />1.11%
<br />Pooled Interest Rate in FY 2012-13
<br />(DD3)
<br />0.85%
<br />0.85%
<br />0.85%
<br />Pooled Interest Rate in FY 2013.14
<br />(DD4)
<br />0.663%
<br />0.663%
<br />0.663%
<br />0.663%
<br />Estimated Pooled Interest Rate in FY2014-15(as of March 3I, 20I5)
<br />(DDS)
<br />0.499%
<br />0.499%
<br />0.499%
<br />0.499%
<br />0.499%
<br />0.499%
<br />Interest Amount in FY 2010-11
<br />(EEI) _ (CC) x (DDI)
<br />$
<br />43,824
<br />$ .
<br />$
<br />$
<br />$
<br />$
<br />-
<br />$ 43,824
<br />InterestAmount in FY 2011-12
<br />(EE2) = (CC) x (DD2)
<br />$
<br />39,229
<br />$ 19,088
<br />$ -
<br />$
<br />-
<br />$
<br />-
<br />$
<br />-
<br />$ 58,318
<br />InterestAmount in FY 2012-13
<br />(EE3) _ (CC) x (DD3)
<br />,
<br />30,041
<br />$ 14,617
<br />$ 6,203.,-
<br />$
<br />$
<br />$ 50,860
<br />InterestAmount in FY 2013-14
<br />(EE4) _ (CC) x (DD4)
<br />_$
<br />$
<br />23,432
<br />' $ 11,431
<br />' $ 4,938
<br />.$ 208
<br />$$
<br />-
<br />$ 39,880
<br />Estimated InterestAmount in FY20I4-I5 (as of March 31,
<br />20I5)
<br />(EES) _ (CC) x (DDS)
<br />$
<br />17,636
<br />$ 8158I
<br />$ 3,642
<br />$
<br />157
<br />$
<br />1,884
<br />$
<br />6
<br />$ 31,905
<br />Balance due from Wholesale Customers
<br />(FF)=(CC)+(EES)+(EE2)+(EE3)+(EE4)+(EES)
<br />S
<br />3.688.350
<br />$ 1.773.355
<br />S 744,415
<br />S
<br />31.801
<br />S
<br />379.401
<br />S
<br />1.157
<br />S 6,618.478
<br />Page 1 of 5 REVISED ATTACHMENT K-5
<br />520
<br />
|