Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Presentation 02/27/2012
PrW e+Lta M)- V 0 FY 12-13 Water Transmission Budget Overview The proposed budget for FY 2012-2013 continues to be based on accomplishing a focused set of goals centered around the Water Agency's Water Supply Strategy Action Plan, including the required elements of the Biological Opinion, continued implementation of hazard mitigation and reliability projects, and normal maintenance of facilities. Whenever possible, alternative sources of revenue, such as FEMA grants and existing fund balances, will be used to finance capital projects Deliveries As required by the Restructured Agreement for Water Supply, the budget year forecast deliveries are based on the past 12 months actual deliveries or the 12 month average over the past 36 months, whichever is smaller. The 12 month actual deliveries through January 2012 were 45,961 acre feet and the annual average over the last 36 months was 47,677 acre feet. Therefore, 45,961 acre feet are used to calculate rates in the DRAFT budget submitted to the water contractors. This is a 4% drop in water deliveries from the 47,848 acre feet used for the FY 2011-2012 budget and rates. The drop in water delivered continues to be a major factor resulting in increased rates (Restructured Agreement Section 4.1). Recommended rates were calculated after the January water deliveries per agreement with the Technical Advisory Committee. Rates The resulting rates are shown below: O&M $432.01 $432.01 $432.01 Water Management Planning 1.09 1.09 1.09 Watershed Planning & Restoration 81.06 81.06 81.06 Recycled Water & Local Supply 9.00 9.00 9.00 Water Conservation 32.85 32.85 32.85 Total O&M $ 556.01 $ 556.01 $ 556.01 Storage and Common Bond and Loan Charges 99.78 99.78 99.78 Sonoma Aqueduct Bond Charge 68.31 Total Prime without Local Supply and Capital $655.79 $655.79 $724.09 Percent Change from FYII-12 Budget 3.42% 3.42% 2.95% Aqueduct Capital Charges (build fund balance for future projects) 9.25 9.25 9.25 Local Recycled Water Tier 2 Program 6.99 6.99 6.99 Prime Contractors 16.24 16.24 16.24 Total Prime Contractors $672.03 $672.03 $740.33 Total Percent Change from FY 11-11 Budget 5.98% 5.98% 5.26% ■ Water Transmission System Fund R Revenues The total revenue of the Water Transmission System Agency Fund is budgeted to decrease by .35% or $113,169 to $32,547,625 This total revenue is comprised of numerous revenue categories, the biggest of which is water sales. Other revenue sources are grants, power sales, meter service installation charges, and interest on cash balances. Water rates and therefore water revenues will not increase enough to pay for the budgeted capital expenses on a "pay -go" basis. Additional borrowing is planned to make up this difference. u Expenses Expenses for operations and maintenance, capital improvement projects, and main sub -funds are as follows: FY 11-12 Budget Operations and Maintenance $19,990,500 Capital Projects $3,788,000 Water Management Planning $200,000 Watershed Planning and Restoration $2,610,680 Recycled Water and Local Supply $947,500 Water Conservation $1,505,000 Totals $29,491,680 FY 12-13 Requested Change $19,623,250 ($367,250) $13,261,000 $9,473,000 $50,000 ($150,000) $3,725,600 $1,114,920 $985,000 $37,500 $1,510,000 $5,000 $39,154,850 $9,663,170 Capital Projects Pipeline • Santa Rosa Aq Cathodic Protection Upgrade • Santa Rosa, Petaluma, and Sonoma Aq - LHMP $800,000 —Program Design $75,000 • Santa Rosa Aq Rodgers Creek Fault • Petaluma Aq Cathodic Protection $265,000 $1,094,000 SBS Electical Upgrade and Pumping Reliability $300,000 • Storage • Sonoma Tank Fence Replacement $90,000 Petaluma Aq Relocation Kastania $300,000 • Kawana to Sonoma Booster Pipeline Design (Reliability and Enhancement) $350,000 Common • Isolation Valves $133,000 • Billing Meter Replacement $400,000 • Russian River Crossing $405,000 • Collectors 3 and 5 Liquefaction Mitigation Predesign $220,000 • Collector 6 Chlorine Solution Lines $25,000 • Air Valves • Mirabel Surge Control • Mark West Creek Crossing • Water Agency Westside Facility $1, 200, 000 $541,000 $200,000 $554,000 • 2 FY 12-13 Prime Contractor Rates Summary CHARGE PER ACRE FOOT. Santa Rosa Petaluma Sonoma Aqueduct Aqueduct Aqueduct O&M Charae r4.21 $432.01 $432.01 $432.01 Water Management Planning Sub -charge [4.13] $1.09 1.09 1.09 Watershed Planning/Restoration Sub -charge [4.14] $81.06 81.06 81.06 Recycled Water & Local Supply Sub -charge [4.15] $9.00 9.00 9.00 Water Conservation Sub -charge [4.16] $32.85 32.85 32.85 O&M Charge 556.01 556.01 556.01 Storage and Common Bond & Loan Charges 99.78 99.78 99.78 Sonoma Aqueduct Bond Charge 68.31 PRIME CONTRACTORS $655.79 $655.79 $724.09 Increase from FY 11-12 3.42% 3.42% 2.95% Capital Charges - to build fund balance for future projects 9.25 9.25 9.25 Local Recycled Water Tier 2 Program 6.99 6.99 6.99 PRIME CONTRACTORS 16.24 16.24 16.24 Increase over base rate from FY 11-12 2.28% 2.28% 1.95% TOTAL PRIME CONTRACTORS 1 $672.03 $672.03 $740.33 Increase from FY 11-12 ® 5.98% 5.98% 5.26% 2/14/2012 4.30 PM 3 E WATER TRANSMISSION SYSTEM FY 12-13 WATER CHARGES PER ACRE-FOOT FOR PRIME CONTRACTORS SANTA % INCR. PETALUMA % INCR. SONOMA ROSA (DECR.) AQUEDUCT (DECR.) AQUEDUCT AQUEDUCT 2012/13 672.03 5.98% 672.03 5.98% 740.33 2011/12 634.11 634.11 703.33 2010/11 603.92 603.92 674.47 2009/10 564.78 564.78 622.11 2008/09 471.13 511.13 486.22 2007/08 441.70 461.70 453.49 2006/07 431.29 451.29 442.60 2005/06 412.68 432.68 424.53 2004/05 402.51 422.51 41442 2003/04 393.89 413.89 4D7 95 2002/03 387.49 397.90 387.43 2001/02 383.29 384.02 373.38 2000/01 330.76 33161 320.74 % INCR. (DECR.) 5.26% 2/14/2012 4 30 PM 0I I WATER TRANSMISSION SYSTEM FY 12-13 REVENUE SUMMARY CHART FY 12-13 FY 11-12 FY 12-13 WATER CUSTOMER Budgeted Water Use (Acre- Rate Proposed Rate Dollar Change Percent Feet) $/Acre -Foot $/Acre -Foot Change Santa Rosa Aqueduct 14,749 $634.11 $672.03 $37.92 6.0% Petaluma Aqueduct 10,031 634.11 672.03 $37.92 6.0% Sonoma Aqueduct 7,809 703.33 740.33 $37.00 5 3% North Marin Water Dist. 6,013 690.43 707.49 $17.06 2.5% MarinMunicipal -Third 4,300 795.60 832.41 $36.81 4.6% Off Peak Marin Municipal- 1,113 735.64 751.08 $15.44 2.1% Supplemental Forestville Aqueduct 369 634.11 662.78 $28.67 4.5% Wholesale/Municipal 976 843.99 888.4 $44.41 5.3% Surplus 92 656.84 675.61 $18.77 2.9% Windsor 508 760.93 806.44 $45.51 6.0% TOTAL 45,961 0 0 0 1i 7 000,000 z 6,000,000 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 u - -1,000.000 z WATER TRANSMISSION SYSTEM FUNDS - ESTIMATED ENDING FUND BALANCES Water Trans. Common Facilities Storage Facilities Pipeline Facilities Santa Rosa Petaluma Sonoma Aqueduct Forestville Agency Fund Aqueduct Capital Aqueduct Capital Capital Aqueduct Capital N a FY 10-11 ® FY 11-12 6 FY 12-13 il (X J ESTIMATED p OFFICIAL CHARGE PER ACRE FOOT: To Be Approved by Board of Directors on April DO, 2012 Santa Rosa Petaluma Sonoma Aqueduct Aqueduct Aqueduct PRIME CONTRACTORS O&M Charge t4 21 $432.01 $432 01 $432.01 Water Management Planning Sub -charge [4.13] $1,09 $1.09 $1 09 Watershed Planning/Restoration Sub -charge [4 141 $81 06 81 06 81.06 Recycled Water & Local Supply Sub -charge [4.15] $15.99 1599 1599 Water Conservation Sub -charge [4 16) $32 85 3285 3285 O&M Charge $563 00 $563 00 $563.00 Caoital Charges - to build fund balance for future oroiects Aqueduct Facilities Capital Charges [4 6 e] $9.25 $9.25 $9.25 Bond & Loan Charges - to oav for exishna debt service Storage Facilities Capital Charge [4.7] 23.45 2345 2345 Common Facilities Capital Charge [4 8] 7633 7633 7633 Aqueduct Facilities Capital Charges [4 6 b] 6831 Total Capital Charges $99 78 $99.78 $168.08 TOTAL PRIME CONTRACTORS $672,03 $672 03 $740 33 Charge without LRT2 and voluntary AQ capital Charge $655 79 $655 79 $724 09 OTHER AGENCY CUSTOM ERSNVHOLESALE CHARGES (WATER CO'S & PUBLIC AGENCIES) O&M Charge $563 00 $563 00 $563 00 Capital Charges 9978 99.78 168,08 Aqueduct Facilities Capital Charge $225 62 $225 62 $157.31 TOTAL OTHER AGENCY CUSTOMERSANHOLESALE CHARGES (4.12) $888 40 $888.40 $888.40 (120% OF HIGHEST PRIME) FORESTVILLE O&M Charge [4.2] $432 01 Water Management Planning Sub -charge 14 13) 1.09 Watershed Planning/Restoration Sub -charge [4,14] 81,06 Recycled Water & Local Supply Sub -charge [4.15] 1599 Water Conservation Sub -charge [4 16] 3285 O&M Charge $563 01 Bond & Loan Chances - to oav for exisbno debt service Aqueduct Facilities Capital Charges (4 6) 0.00 is Storage Facilities Capital Charge [4.7] 2345 Common Facilities Capital Charge [4 8] 7633 Total Capital Charges $99 78 TOTAL FORESTVILLE $662.78 Forestville Water District exempt from Santa Rosa Aqueduct sub -charge from FY O6/07 to FY 16117 [4 121 NORTH MARIN WATER DISTRICT O&M Charge North Marin Bond & Loan Charge [4 9] Russian River Conservation Charge [4 18 (a)] Russian River Projects Charge [4.18 (1 TOTAL NORTH MARIN WATER DISTRICT THIRD OFF-PEAK (MARIN MUNICIPAL) Highest Prime Russian River Conservation Charge Russian River Projects Charge TOTAL THIRD OFF-PEAK SUPPLEMENTAL (MARIN MUNICIPALI O&M Charge Capital Charge [4 11 (b)] Russian River Consenvabon Charge Russian River Projects Charge TOTAL SUPPLEMENTAL SURPLUS Non -Municipal ) Municipal 14 11 (a)] (120% of O&M Charge) $563 00 Note N Mann does 52.41 not pay an Act 7208 Capital Charge 2000 70749 $740.33 7208 2000 $832 41 $563 00 9600 7208 2000 $751 08 $675 61 $675 61 $675 61 Town of Windsor $806 44 Town of Windsor is charged 120% of the highest charge for any other prime contractor on the Santa Rosa Aqueduct from FY 06107 to FY 21/22 [4 17 (a)] Town of Windsor pays all subcharges [4.13, 4,14, 4,15. and 4 161 on all water they dived from the Russian River using their equipment [4 17 (b)]. The applicable section of the Restructured Agreement has been indicated in brackets 211412012 4:30 PM W n L-A SCHEDULE OF WATER DELIVERIES BY AQUEDUCT PAST 36 MONTHS 112 MONTHS AVERAGE DELIVERING AQUEDUCT Monthly Santa Rosa I Petaluma I Forestville Sonoma Total 36 Feb-09 1,070.2 2,023.7 19.6 381.7 3,495.3 35 Mar-09 982.2 1,828.7 19.1 440.2 3,2701 34 Apr-09 1,653.0 2,945.9 37.0 788.3 5,424.2 33 May-09 1,511.9 2,309.9 33.9 614.8 4,470.4 32 Jun-09 1,927.5 2,4584 49.7 7566 5,192.2 31 Jul-09 1,664 3 1,988 5 49.5 6727 4,375.1 30 Aug-09 2,065 7 2,256.5 56.4 6739 5,052.4 29 Sep-09 1,8677 1,880.7 492 6033 4,400.9 28 Oct-09 1,057.5 1,604 8 297 606.3 3,2983 27 Nov-09 1,088.8 2,291.5 26.7 619.6 4,026.7 26 Dec-09 977.2 1,911.5 21.1 453.5 3,3632 25 Jan-10 928.4 1,781.2 19.8 432A 3,1615 24 Feb-10 1,0007 1,7541 23.2 417.3 3,195.4 23 Mar-10 1,283.1 2,172.1 24.7 525.4 4,005.2 22 Apr-10 903.5 1,374.8 21.0 442.0 2,741.2 21 May-10 1,270.8 1,482.9 26.0 621.1 3,400.8 20 Jun-10 1,883.7 2,061.9 43.9 8630 4,852.4 19 Jul-10 1,914 8 2,156 8 45.1 886.9 5,0036 18 Aug-10 1,934.1 2,616 2 54.9 1,077.9 5,683.1 17 Sep-10 1,560.0 2,1582 47.3 916.7 4,6823 16 Oct-10 1,355 7 1,906.8 38.0 779.9 4,080.4 • 15 Nov-10 1,145.1 1,614.3 24.6 547.4 3,331.4 14 Dec-10 1,1887 1,9820 237 516.6 3,711.0 13 Jan-11 965.7 1,446.8 19.8 420.4 2,852.8 12 Feb-11 996.1 1,574.5 17.9 421.7 3,010.3 11 Mar-11 945.0 1,308.7 193 424.2 2,6971 10 Apr-11 1,044.8 1,295.4 21.8 516.5 2,878.5 9 May-11 1,7220 2,4071 36.4 954.1 5,119.6 8 Jun-11 1,3315 1,883.3 32.5 747.8 3,995.1 7 Jul-11 1,503 0 2,218 8 39.4 9225 4,683.8 6 Aug-11 2,204.3 2,676.0 55.1 935.9 5,871.2 5 Sep-11 1,3235 2,206 3 41.7 8449 4,4164 4 Oct-11 784.5 1,557 1 293 6806 3,051.5 3 Nov-11 1,031.6 1,641.7 29.0 634.3 3,336.6 2 Dec-11 1,340 0 1,861 8 27.2 409.0 3,638.1 1 Jan-12 1,122.8 1,803.1 19.3 317.2 3,262.3 Total Deliveries 48,549.3 70,442.0 I 1,172.8 22,866.3 143,030.5 3-Year Annual Average 16,183.1 I 23,4807 I 390.9 7,6221 47,6768 Past 12 Months 15,349.3 I 22,433.7 I 368.9 7,808.6 45,960.6 Total Deliveries 48,549.3 70,442.0 1,172.8 22,866.3 143,030.5 Less North Marin 19,932 8 19,932 8 Marin Municipal 18,470 1 18,470.1 Sonoma Co. Deliveries 48,5493 I 32,0392 I 1,172.8 22,866.3 104,627.7 3-Year Annual Average 16,183.1 I 10,679.7 I 3909 7,6221 34,875.9 A-6 2/14/2012 4:30 PM Aill SONG OUNTY WATER AGENCY SCHEDULE OF ACTUAL PRIOR 12 MONTHS WATER DELIVERIES IN ACRE FEET (BY CUSTOMER TYPE) JANUARY 11 THROUGH DECEMBER 11 (Applicable Years as Indicated) Aqueduct No. FEB 11 MAR 11 APR 11 MAY 11 JUN 11 JUL 11 AUG 11 SEPT 11 OCT 11 NOV 11 DEC 11 JAN 12 TOTAL PRIMES 1 City of Santa Rosa 1,1055 1,0766 1,207.1 1,995.2 1,528.1 1,7969 2,3380 1,608.0 1,0179 1,133.5 1,292.6 1.134.1 17,233.5 2 City of Petaluma 384.7 3419 412.4 786.7 707.5 883.6 1,0201 741 8 6027 576.0 551.0 434.5 7.442.8 2 North Mann Water Dist. 396.6 208.4 236.2 662.0 554.9 678.9 874.1 781 5 393.4 328.4 5524 346.6 6,013.2 2 City of Rohnert Park 2649 2666 285.0 460A 310.3 3394 350.3 269.5 231 5 260.6 294.2 261.9 3,594.3 2 City of Cotati 27.3 270 335 59.3 51.3 552 79.3 52.9 367 328 29.2 26.9 511.4 1 Town of Windsor 40.9 34.7 47.5 78.4 50.8 483 42.6 481 332 323 31.8 31.6 520.1 4 City of Sonoma 896 79.8 105.0 226.5 170.9 208.2 281.5 211 0 1508 1630 139.2 102.9 1,928.4 4 Valley of the Moon Dist. 1274 122.0 133.5 220.5 175.8 216.6 2839 224.8 1665 2131 1956 155.1 2,234.9 TOTAL PRIMES 2,4370 2,156.9 2,4601 4,488.7 3,549.7 4,227.0 5,269.7 3,9376 2,6325 2,739.7 3,086.1 2,4937 39,478.7 OTHER AGENCY CUSTOMERS 1 Larkfield Water Cc 6.1 11.1 14.9 50.6 48.5 45.3 62.2 45.6 18.8 13.9 101 3.4 330.4 2 Penngrove Water Co 10.7 10.1 10.4 179 16.1 18.9 24.9 18.7 159 14.4 13.0 10.3 181.2 4 Lawndale Mutual 2.5 2.9 4 3 7.7 6.0 8.2 10.6 8.6 6.7 5.0 4.8 3.8 71.2 4 Kenwood Village Water Co 0.2 0.2 0.2 0.5 0.4 0.5 0.8 0 9 0.6 0.4 0.3 0.2 5.0 3 Forestville Co Water Dist. 18.0 19.4 21.9 36.9 33.0 40.2 56.1 43.0 30.1 29.2 27.3 19.4 374.4 1 Other Gov -Santa Rosa Aq 0.2 0.1 0.1 0.3 0.2 0.3 0.4 0.5 0.2 0.2 0.2 0.2 2.9 2 Other Gov -Petaluma Aq 0.0 0.0 0.0 0.0 00 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 4 Other Gov -Sonoma Aq 0.5 0.5 0.5 1.2 10 1.3 1.5 1.8 1.0 0.6 0.6 0.6 11.1 TOTAL OTHER AGY COST 38.1 442 524 115.0 105.2 114.6 156.5 1192 73.2 63.7 56.2 378 976.2 OFF-PEAK CUSTOMERS 2 Marin Municipal 534.2 494.8 358.0 498.2 334.7 332.7 425.8 343.0 340.1 530.0 493.3 728.5 5,413.3 SURPLUS CUSTOMERS 1 Irrigation -Santa Rosa Aq 0.1 0.2 6.2 1.8 2.1 4.4 9.7 9.4 24 0.8 0.5 0.3 37.9 2 Irrigation -Petaluma Aq 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 4 Irrigation -Sonoma Aq 0.9 1.0 1.9 15.8 3.3 5.1 9.5 7.3 3.2 2.2 2.0 2.1 54.4 TOTAL SURPLUS CUST. 1 0 1.2 8.0 17.6 5.5 9.6 19.3 16.7 5.6 3 1 2.5 24 92.3 TOTAL DELIVERIES 3,010.3 2,697.1 2,8785 5,119.6 3,995.1 4,6838 5,871 2 4,416.4 3,051 5 3,3366 3,638.1 3,262.3 45,960.6 2/14/2012 4.30 PM N FY 2012-13 BUDGET Water Transmission System Agency Fund ESTIMATED WATER DELIVERIES AND WATER SALES - O&M plus Surcharges Sub-Object4161 ESTIMATED REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED DELIVERED RATES REVENUE WATER SALES - O&M 1 PRIMES without Subcharges 39,4787 432.01 17,055,223 2 OTHER AGENCY CUSTOMERS 976.2 75741 739,381 3 MARIN MUNICIPAL (OFF-PEAK) 4,300.0 609.34 2,620,158 4 MARIN MUNICIPAL (SUPPLEMENTAL) 1,113.3 528.01 587,830 5 SURPLUS CUSTOMERS 92.3 54461 50,286 TOTAL WATER SALES - O&M 45,960.6 N/A $21,052,878 Sub-Obje-t 4175, 4176, 4177, rnd 4178 ESTIMATED REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED DELIVERED RATES REVENUE WATER SALES - Sub -charges 1a Water Management Planning Sub -charge [4.13] 45,960.6 1.09 50,000 1 b Watershed Planning/Restoration Sub -charge [4 14] 45,960.6 81.06 3,725,600 lc Recycled Water & Local Supply Sub -charge [4 151 45.960.6 15.99 735,000 1d Water Conservation Sub -charge [4 16] 45,960.6 32.85 1,510,000 TOTAL WATER SALES - Subcharges 45,960.6 N/A $6,020,600 • • 2/14/20120%1 FY 2012-13 BUDGET Water Transmission System Agency Fund SANTA ROSA AQUEDUCT ESTIMATED WATER DELIVERIES AND WATER SALES - O&M plus Surcharges Sub -Object 4161 ESTIMATED REVENUE CATEGORY ACRE FEET ESTIMATED DELIVERED RATES WATER SALES - O&M 1 SANTA ROSA AQUEDUCT 15,349.3 Sub-Obje :t 4175, 4176, 4177, : nd 4178 ESTIMATED REVENUE CATEGORY ACRE FEET ESTIMATED DELIVERED RATES WATER SALES -Sub-charues 43201 ESTIMATED REVENUE 6,631,040 ESTIMATED REVENUE 1a Water Management Planning Sub -charge [4.13] 15,349.3 1 09 16,698 1b Watershed Planning/Restoration Sub -charge [4.14] 15,349.3 81.06 1,244,223 1c Recycled Water & Local Supply Sub -charge [4.15] 15,349.3 15.99 245,465 ld Water Conservation ,Sub -charge [4161 15,349.3 32.85 504,288 TOTAL WATER SALES - Subcharges 15,349.3 N/A $2,010,674. ESTIMATED REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED DELIVERED RATES REVENUE CAPITAL CHARGES Aqueduct Facilities Capital Charges [4.6 e] 15,349.3 9.25 141,981 BOND AND LOAN CAPITAL CHARGES Storage Facilities Capital Charge [4 7] 15,349.3 23.45 359,935 Common Facilities Capital Charge [4.8] 15,349.3 76.33 1,171,561 Aqueduct Facilities Capital Charges [4.6 b] 15,349.3 000 0 TOTAL WATER SALES - Capital & Bond and Loan Charges 15,349.3 N/A $1,673,477 TOTAL ESTIMATED REVENUE $10,316,191 2/14/2012 4:30 PM s FY 2012-13 BUDGET Water Transmission System Agency Fund PETALUMA AQUEDUCT ESTIMATED WATER DELIVERIES AND WATER SALES - O&M plus Surcharges Sub -Object 4161 ESTIMATED REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED DELIVERED RATES REVENUE WATER SALES - O&M 1 PETALUMA AQUEDUCT 22,433.7 Sub -Object 4175, 4176, 4177, rnd 4178 ESTIMATED REVENUE CATEGORY ACRE FEET ESTIMATED DELIVERED RATES WATER SALES - Sub -charges 432.01 9,691,603 ESTIMATED REVENUE - la Water Management Planning Sub -charge [4.13] 22,433.7 1.09 24,405 lb Watershed-Planning/Restoration Sub -charge [4.14] 22,433.7 81.06 1,818,496 1c Recycled Water & Local Supply Sub -charge [4.15] 22,433.7 1599 358,759 ld Water Conservation Sub -charge [4.16] 22,433.7 32.85 737,043 TOTAL.WATER SALES -Subcharges 22,4337 N/A $2,938,703 ESTIMATED REVENUE CATEGORY ACRE FEET ESTIMATED ESTIMATED DELIVERED - RATES REVENUE CAPITAL CHARGES Aqueduct Facilities Capital Charges [4 6 e] 22,433.7 9.25 207,512 BOND AND LOAN CAPITAL CHARGES Storage Facilities Capital Charge 14.7] 22,433.7 23.45 526,064 Common Facilities Capital Charge 14.8] 22,433.7 76.33 1,712,297 Aqueduct Facilities Capital Charges [4.6 b] 22,433.7 0.00 0 TOTAL WATER SALES - Capital & Bond and Loan Charges 22,433.7 N/A - $2,445,873 TOTAL ESTIMATED, REVENUE $15,076,179 • • 2/14/2012&M is FY 2012-13 BUDGET Water Transmission System Agency Fund SONOMA AQUEDUCT ESTIMATED WATER DELIVERIES AND WATER SALES - O&M plus Surcharges Sub -Object 4161 ESTIMATED REVENUE CATEGORY ACRE FEET ESTIMATED DELIVERED RATES WATER SALES - O&M 1 SONOMA AQUEDUCT 7,808.6 Sub-Obje ,t 4175, 4176, 4177, a nd 4178 ESTIMATED REVENUE CATEGORY ACRE FEET ESTIMATED DELIVERED RATES WATER SALES - Sub -charges 1a Water Management Planning Sub -charge [4.13] 7,808.6 11b Watershed Planning/Restoration Sub -charge [4.14] 7,808.6 lc Recycled Water & Local Supply Sub -charge [4 15] 7,808.6 ld Water Conservation Sub -charge [4.16] 7,808.6' TOTAL WATER SALES - Subcharges 7,808.6 N/A ESTIMATED REVENUE CATEGORY ACRE FEET ESTIMATED DELIVERED 'RATES CAPITAL CHARGES Aqueduct Facilities Capital Charges [4.6 e] BOND AND LOAN CAPITAL CHARGES Storage Facilities Capital Charge (4.7] Common Facilities Capital Charge [4.8] Aqueduct Facilities Capital Charges [4.6 b] TOTAL WATER SALES -Capital & Bond and Loan Charges 7,808.6 7,808.6 7,808.6 7,8086 N/A TOTAL ESTIMATED REVENUE 43201 1.09 81.06 15.99 3285 ESTIMATED REVENUE 3,373,416 ESTIMATED REVENUE 8,495 632.975 124,876 256.547 $1,022.893 ESTIMATED REVENUE 9.25 72,230 23.45 76.33 68.31 183,110 596,010 533,371 $1�384,721, $5;761,030 2/14/2012 4:30 PD7 FY 2012-13 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: l Water Transmission System Agency Fund Section/Index No: 675108 Actual Estimated Adopted Requested Percent Subobject Title 2010-11 2011-12 2011-12 2012-13 Difference Change IBEGINNNG FUND BALANCE 3,857,624 6,810,781 4,809,241 REVENUES USE OF MONEY/PROPERTY 1700 Interest on Pooled Cash 73,335 33,275 33,275 30,250 (3,025) (9 09%) 1701 Interest Earned 0 0 0 0 0 N/A 1800 Rents /Concessions 0 0 0 0 0 N/A 1801 Rent -Real Estate 450 0 0 0 0 N/A SUBTOTAL 73,785 33,275 33,275 30,250 (3,025) (9 09%) INTERGOVERNMENTAL REVENUES 2400 State - Disaster Relief 0 0 0 0 0 N/A 2680 Federal - Disaster Relief 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A CHARGES FOR SERVICES 3666 Meter Service / Install 30,037 20,000 20,000 20,000 0 0.00% 3980 Revenue Applicable to PY 6,470 0 0 0 0, N/A SUBTOTAL 36,507 20,000 20,000 20,000 0 0.00% MISCELLANEOUS REVENUES 4039 Sale - Power 774,631 800,000 800,000 800,000 0 0 00 % •, 4040 Miscellaneous Revenues 15,959 0 0 0 0 N/A 4102 Donations/Reimb 119,935 0 0 2,000 2,000 N/A 4109 Outdated Warrants 0 0 0 0 0 N/A 4161 Water Sales -O&M 21,044,169 20,178,530 .22,911,950 21,137,480 (1,774,470) (7.74%) 4162 Comm. Rev. Bd. Charge 2,259,385 2,198,437 2,228,411 2,628,828 400,417 17.97% 4163 Storage Rev Ed. Charge 813,308 797,391 808,229 807,647 (582) (0,07%) 4164 Sonoma Aq. Rev Charge 291,170 288,184 294,175 294,056 (119) (0.04%) 4166 'SR Aq. Capital Charge 62,381 65,965 66,445 211,891 145,446 218.90% 4167 Petaluma Aq. Cap. Chg 0 0 r 0 207,512 207,512 N/A 4168 Sonoma Aq Cap Charge 0 0 0 72,230 72,230 N/A 4169 NM Revenue Bd Charge 274,455 305,413 315,129 315,131 2 0.00% 4175 Water Mgmt Planning Sub -charge 195,087 192,115 200,000 50,000 (150,000) (75.00°/n) 4176 Watershed Planning/Rest Sub -charge 1,710,554 2,507,609 2,610,680 3,725,600 1,114,920 42.71% 4177 Recycled Water & Local Supply Sub -charge 811,557 833,265 867,500 735,000 (132,500) (15.27%) 4178 Water Conservation Sub -charge 11542,147 1,445,460 1,505,000 1,510,000 5,000 033% 4303 State Grant 0 0 0 0 0 N/A SUBTOTAL 29,914,738 29,612',369 32,607,519 32,497,375 (110,144) (0.34%) OTHER FINANCING SOURCES 4625 Operating Transfer In 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A TOTAL REVENUES 30,025,030 29,665,644 32,660,794 32,547,625 (113,169) (0.35%) 211412012 4:30 PM R-, Section Title: I Water Transmission System Agency Fund I Section/Index No: 675106 Actual Estimated Adopted Requested' Percent Subobject Title 2o10-11 2011-12 2011-12 2012-A3 Difference Change EXPENDITURES SERVICES AND SUPPLIES 6020 Clothing /Personal 359 0 0 0, 0 N/A 6040 Communications 62,465 75,000 60,000 75,000' 15;000 25:00% 6066 Food 0 0 0 0. ..0 N/A 6080 Household Expense 227 1,362 0 0 �0 N/A 6084 Janitorial Supplies 0 0 0 1,000 1,000 N/A 6085 JanitorialServices 0 0 0 0 0 N/A 6104 Fire Insurance 0 0 0 0 '0' N/A 6140 Maintenance -Equipment 695,788 765,00o 1,024,000 1';200,000; 176,000 .1719%, 6180 Maintenance -Buildings 75,853 234,000 234,000 '0, (23410o0) (loo.00%', 6190 Landscaping Service 4,193 0 0 0, .0 N/A 6233 Maintenance - Prof Outside 0 0 0 0 0 N/A 6262 Laboratory Supplies 23,711 25,000 20,000 25,000 5,000 25:00% 6280 Memberships 38,791 50,000 75,000 77,500 2',800, 3.33% 6300 Miscellaneous 0 0 0 0 10 N/A 6400 Office Expense 2,336 2,000 0 '2,000' 2,000 N/A 6410 Postage 2,744 31000 0 1,000, i1,000, N/A 6415 Books/Periodicals 780 1;000 0 '1,000 1"000 N/A 6430 Printing 1,756 2,000 0 '11000 -1;Oo0' N/A 6461' Supplies / Expenses 54,443 55,000 50,000 50,000' 0 '0.00%' 6500 Professional / Special Svcs 0 0 0 0 0 N/A 6512 Testing/Analysis 116,513 135,000 155,000 135,000 (20,000) (12190%) 6516 Data Processing Servies 256 5,000 0 5,000 5,000 N/A 6522 District Services 660;889 0 0 0' 0 NIA 6523 District Operations 8,499,478 9.600,000 10,200,000 9;800;000 (400,000) (3.92%) 6540 Contract Services 0 15,000 0 30,000 30;000 N/A 6553 Contract -Security Services 20',618 21,000 30,000 25,66o (5,000) ;(1667%. 6570 Consultant Services 290,581 450,000 1,101,000 1,395,750 294;750: 2677% 6589 Permits 0 6,000 0 6,000 6;000 N/A 6590 Engineering Services 0 0 0 0 0 N/A 6595 Feasibility Study 0 0 0 0 0 'N/A 6610 Legal Services 6,021 25,000 50,000 50,006 0 ,6.66%, 6616 Change of Venue 0 0 0 0 0 N/A 6635 Fiscal AgentFees 0 0 0 0 0 N/A 6654 Medical Examinations 0 0 0 0 0, .N/A 6706 Water Quality 0 0 0 0 0 N/A 6710 Film Program 0 0 0 0 0 N/A 6800 Public/Legal Notices 2,093 2,000 5,000 5,000 0 6:00% 6820 Rents, and Leases -Equip 84,688 100,000 74,000 85,006 11,000 14.869% 6840 Rents and Leases-Bldg/Imp 0 0 0 0 0 N/A. 6880 Small Tools - Instruments 81,495 90,000' 50,000 90,000 40,000 80.00% 6889 Software 16,645 216,000 210,000 120,000 (90,000) 6890 Computer Hardware 9,416 10,000 0 10,000 10,000' N/A 7052 Out of Slate Use Tax 0 0 0 0 0 N/A 7110 Professional Development Admin Mgmt 0 0 0 0 0 N/A 7120 Training-m-Service 16,640 17,000 5,000 18,000 13,000' 260.00% 7130 Tuition / Textbook 0 0 0 0 0 N/A 7201 Gas / Oil 2,512 5,000 4,000 5,000 1,060 2600%4 7206 Equipment Usage Charge 664,338 749,000 600,000, 750',000 '150,000 25 00%Q 7212 Chlorine Chem/Recorder 7351030 750,000 1,050,000 850;000 (200,000) 7217 State Permits / Fees 39,645 40,000 25,000 40,000 15,000 60 00%' 7247 Water. Conservation Prog 0 0 0 0 0 N/A 7250 Reimbursable Projects 0 2,000 0 2,006 2,060 N/A. 7277 Recycled Water Use Prog 0 0 0 0 0 'N/A 7296 FERC Fees / Costs 4,353 5,000 5,000 5,000 0 0.00°/ 7297 Riverfront Park Levee Maintenance 7,128 40,000 40,000 40;000 0 0.00% 7301 County Car Expense 0 0 0 0 0 N/A 7302 Travel Expense 22,044 22,000 20,060 20;000 0 0'.00°%* 7303 Private Car Expense 2,248 2,000 2,500 2,000 (500)' (20:00%). 2/14/2012 4'30 PM Section Title: lWater Transmission System Agency Fund Sectionllndex No: F 6-751-08 • Actual Estimated Adopted' Requested Percent Subobiedt Title 2610-11, '2011-12 2011-12 2012;13i Difference. dhange' 7320 Utilities 299 1,000 1,000 1,000 0; 0.00% 7394 Power 4,475,440 4,700,000 4,900,000 4,700;000 (200,000) (4 08%) 7480 Expense applicable to Prior Year 0 0 0 0 0 N/A SUBTOTAL 16,721,816 18,224,362 19,990,500 19,623,250 (367,250) (1.84%) OTHER CHARGES 7920 Interest Expense 0 120,618 58,956 43,146 (15,810) (26.82%) 79241nteresl-PY (7,243) 0 0 0 0 N/A 7980 Depreciation 5,287,938 5,580,182 5,500,000 5,700,000 200,000 3.64% 7981 Amortization 0 27,110 0 129,000 129,000 NA 8010 Contribution to Non -County 0 0 0 0 0 N/A 8090 Loss on Fixed Assets 0 0 0 0 0 N/A SUBTOTAL 5,280,695 5,727,910 5,558,956 5,872,146 313,190 563% FIXED ASSETS 8510 Buildings/Improvements 237 70,000 0 70,000 70,000 N/A 8515 Engineering Costs 541 9,000 0 0 0 N/A 8517 Adminsitration 458 9,000 0 0 0 N/A 8533 SCWA-New Metered Ser 1,152 20,000 20,000 2Q000 0 0.00% 8560 Equipment 529,964 430,000 430,000 30,000 (400,000) (93.02%) 8562 Comp/Word Process Equip 0 0 0 0 0 N/A 8571 Field Equipment 0 0 0 0 0 N/A 8572 Laboratory Equipment 0 0 0 0 0 N/A 8573 Mobile Equipment 0 0 0 0 0 N/A 8574 Shop Equipment 0 0 0 0 0 N/A 9482 Amort WIP Outlay 60,000 100,000 0 0 6 N/A • SUBTOTAL 592,352 638,000 450,000 120,000 (330,000) (73:33%) OTHER FINANCING USES 8625 OT - Win Special Dist 9,357,507 12,294,205 12,682,156 11,766,293 (915',863) (7.22%)' SUBTOTAL 9,357,507 12,294,205 12,682,156 11,766,293 (915,863) (7.22%) APPROP. FOR CONTINGENCIES 9000 Approp for Contingencies 0 140,000 140,000 140,000 0 0.00% SUBTOTAL 0 140,000 140,000 140,000 0 0.00% ADMIN. CONTROL ACCOUNT 9200 Ent -Principal 0 266,752 266,752 282,562 15,810 5.93% 9209 Ent - Principal Clearing 0 (266,752) (266,752) (282,562) •.(15,810) 5.93 % SUBTOTAL 0 0 0 0 0 N/A PRIOR YEAR ENCUMBRANCE EXPENSE 9614 PY Enc- Maintenanpe:Eguip 30,080 0 0 0 0 N/A 9,618 PY Enc - M2infenance Bidgs/Imp 0 0 0 0 0 N/A 4646 PY Enc - Offce Expense 0 0 0 0 0 N/A 9650 PY Enc - Profess / Special 668,586 0 0 0 0 N/A 9688 PY Enc - Small Tools/Instruments 0 0 0 0 0 N/A 9700 PY Enc- Special Dept Exp 0 0 0 0 0 N/A 9852 PY Enc- Bldg / Imp / Equip 0 0 0 0 0 N/A 9853 PY Enc- Equip 163,043 0 0 0 0 N/A SUBTOTAL 861,709 0 0 0 0 N/A TOTAL EXPENDITURES 32,814,079 37,024',477 '38,821,612 37,521,689 (1,299,923) (3.35%) • .Depreciation/Amortization 5,287,938 5,607,292 5,829,000 Outstanding Encumbrances - (Decrease) Fund Balance 461,511 0 0 2114,2O12 430 PM 10( Section Title: lWater Transmission System Agency Fund Section/Index No: 675108 Actual Estimated 'Adopted Racu6sled Suboblect Title 2010-11 2011-12 2011-12 2012,13 PY Encumbrances Change in Prudent Reserve 0 Post Audit Adjustments-Payables 0 Post Audit Adjustments -Receivables 0 Post Audit Adjustments -Inventory 0 Post Audit Adjustments -Prepaid Expense 0 Increase in Recycled/Conservation Deposits 0 Capitalized Interest (7,243) Gain/Loss of Disposal of Fixed'Asset 0 Reclass of Prior Year Asset 0 IENDING'FUND'BALANCE 6,810,781: Operations and Maintenance 675108 Fund Balance Reserve Goal Over/(Under) Goal (250,000) 0 0 0 0 0 0 0 0 4;809,241 a 0 0 0 0 0 0, 0 0 0, 0' 5,664,177 5,013,849 650,328' Percent Difference Change 118, 19,01 21142012 4:30'PM t. J C� Water Transmission Svstem,Aaencv Fund Maior Services & Supplies Expenditure Items Sub -Object No. and Title Actual Adopted Requested FY 10-11 FY 11-12 FY 12-13 Difference 6140 Maintenance - Eauipment 695,788 1,024,000 1,200,000 176,000 See Project List on page A-12 for detail. 6180 Maintenance - Proiects 75,853 234,000 0 (234,000) Starting in Fy 2012/13 the costs to maintain the pumping, storage, pipeline and hydro -electric facilities will be budgeted in 6140. 6280 Memberships 38,791 75,000 77,500 2,500 Reflects level of actual expenditures. 6461 Suoolies / Exoenses 54,443 No change from prior year. 6512 Testina / Analvsis 116,513 Anticipated lower costs based on prior year actuals. 6523 District Operations 8,499,478 Reflects MTO and held vacancies. 50,000 50,000 0 155,000 135,000 (20,000) 10,200,000 9,800,000 (400,000) 6570 Consultant Services 290,581 1,101,000 1,395,750 294.750 See Consultant Services Project List for detail on page A-13. 6610 Leaal Services 6,021 50,000 50,000 0 No change from prior year. 6880 Small Tools - Instruments 81,495 50,000 90,000 40,000 Anticipated higher costs based on prior year actuals. 6889 Software 16,645 210,000 120,000 (90,000) This item is requested to provide continuing support for the IBM Collaboration Platform development. 7206 Equipment Usage Charqe 664,338 600,000 750,000 150,000 Increased expenditures based on prior year actuals and maintenance required. 7212 Chlorine Chemical / Recorder 735,030 1,050,000 850,000 (200,000) Reflects level of actual expenditures. Percent Change 17.2% -100.0% 3.3% 0.0% 12:9% -3.9% 26 8% 0.0% 80.0% -42.9% 25:0% -19.0% 7394 Power 4,475,440 4.900,000 4,700,000 (200,000) -4.1% No change from prior year. • 8560 Eauioment 529,964 430,000 30,000 (400,000) -93.0% Reflects change in how we account for some "maintenance" projects. Many projects that were previously budgeted under '6180" are now budgeted here. 2/14/2012 4:30 PM FY 2012-13 BUDGET Water Transmission System Agency Fund • DESCRIPTION - 6180 Maintenance Buildings AMOUNT 1 Combined with 6140 6180 Total $ DESCRIPTION - 6140 Maintenance-Contracts'and Equipment AMOUNT 1 ElectricahSupplies and Maintenance; Services 300,000 2 Pump and Pipeline. Supplies and Maintenance°Services 250,000 3 Hardware, and'Miscellaneous Supplies 160,000 4 Water Treatment. Systems Supplies and Maintenance Services 80,000 5 Safety Equipment and Safety Equipment Testing 70,000 6 Grounds Maintenance 40,000 7 Prefunding Cotati Tank #3 Recoat 300,000 6140 Total $ 1,200,000 is • 211412012 4:30 PM ZZ- Water Transmission Agency Fund, N676108 Multi -Year Subobject Review FY2012-13 BUDGET Actual Actual Actual Actual Actual Actual Estimate Budget Subobject Title Subobject Number FY 05106 BY 06107 FY 07108 FY 08/09 FY 0911a FY 10/11 FY 11-12 FY 12-13 Maintenance -Equipment 6140 114,538 1,777,109 1,036922 927,294 865,722 695,788 765000 1,200.D00 Maintenance - Bidgllmp 6150 7,344,885 1949,875 1, 880.212 495,840 272.670 75 B53 234000 0 DistrictAmomstrabon 5522 5682854 5,722654 8,047 9,189 6,344 me 889 0 0 Distract Operations 6523 0 3208,841 10,589.066 10820,013 10,062.360 8499478 9600,000 9,B001000 Total of the Four Cost Categories $ 13,142,257 $ 12,658,479 $ 13,514,247 $ 12,252,316 $ 11,207,096 f 9.932.008 f 10,599,000 f 11,000,000 Percentage Change hom Prior Year -368% 675% -934% -853% -1138% 672% 378% These subobjecls are combined to allow review 0 SCWA labor expenses Idradryear FY06I07, an accounting change was processetl 1p isolate SCWAlabpr mststosuibobject6523, Prior to that accounting change, SCWA labor osts were included adman subobjects 6140, 6180, and 6523. Actual Actual Actual Actual Actual Actual Estimate Budget Subobject TNe Subobject Number FY(i FY 06107 FY 07108 FY 08109 FV 09110 FY 10)11 FY 11/12 FY 12-13 Consulting Service 6570 5 590,672 It 693,373 $ 712,593 5 860,688 $ 653,985 290581 $ 450A00 $ 1,395,750 Percentage Change from Prior Year 1739% 277% 2078% -2402% -5557% 5486% 210,17% Memrsed Seoul for 6570 Consulting Ser olces Budget DESCRIPTIDN FY 12-13 Collector 102 Rehab Feasibility Study 125,000 L8NL Wohler Geophysics (phase 2 5 3) 15,000 LH MP Update 1 Program Design 75,000 Energy Optirmi 30,000 USGS Water Duality (Diversion Facilities) and S W1GW Studies 40goo Rate Study 60,000 Surface WaterlGroundwater Model (HEC) 100,000 Dry Creek Stream Gauges 35,000 Engineering Services 100,000 Operations Support 15900 IRWMPs 97.500 Conservation strategy group 25,000 Legislative Advocary, 50goo Natural Resource Results 15000 Miscellaneous Small Patters 14 250 Programmable Logic Control and Maintenance 15,000 Tank Inspection 0 Cleaning 50000 Cathodic Protector Design Agreements 59D00 Water Shortage Allocation Metbddobgy 90,000 5-Yeat Water Duality Study 150 000 6570 Total S 1,151.750 Actual Actual Actual Actual Actual r'i Estimate Budget Subobject Title Subobject Number FY 05106 FY O61W FY 07108 FY 08109 FY 09/10 FY 10111 FY 11112 FY 12-13 Power Usage Review 7394 $ 2,814,786 f 3,23T,$65 5 5,930,313 3 4,928,207 $ 3.739,841 $ 4,475,440 $ 4,700,000 5 4,700.000 Percentage Change dom Prior Year 1502% 8317% -1690% -2411% 20% 5% 0% 21142012 4 30 PM • • • Water Transmission System Agency Fund Local SuDDIv / Recvcled'Water /'Tier 2 Proarams Balance as of January 13. 2012 10-Year Amount Amount Contractor Allocation Approved Disbursed Santa Rosa $5;065,236 $4,003,876 $3,908,003 Petaluma 2.197,913 2,197,913 2,197,913 MMWD 1,724,026 1,000,000 1,000,000 NMWD 1,846,726 1,846,726 1,846,726 Rohnert Park 649,629 649,629 0 VOM WD 627,875 627,875 627,875 Sonoma 539,411 450,000 264,294 Windsor 86,996 86,996 86,996 Cotati 157,235 0 0 Forestville 104,963 104,953 104,953 TOTAL $13,000,000 $10,967,968 $10,036,760 Program started June 30, 2000 - No end date specified. Balance Available 1,157,233 0 724,026 0 649,629 0 275,117 0 157,235 0 $2,963,240 P-MMMiifs I M FY 2012-13 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Storage :Facilities Section/Index No: 675405 Actual Estimated Adopted Requested Subobject Title 2010-11 2011-12 2011-12 2012-13 IBEGINNING,FUND BALANCE 695;194 584,648 70;537 REVENUES USE OF'MONEY. / PROPERTY 1700 Interestor-PooledCash 4,294 SUBTOTAL 4,294 MISCELLANEOUS REVENUE 4102 Donations/Reimbursements 0 (Petaluma A- -. Caltrans Project) SUBTOTAL 0 CHARGES FOR SERVICES 3145 Plans/Specs 60 SUBTOTAL 60 OTHER FINANCING.SOURCES 4625 OT - WhwSpecial Dist 16,874 SUBTOTAL 16,874 Residual Eauitv Transfer In 4865 Residual Equity Transfer In 0 SUBTOTAL 0 TOTAL REVENUES 21,228 EXPENDITURES OTHER CHARGES 7924 Interest- Prior Year (8,781) FIXED ASSETS Difference Percent Change 4,070 4,070 1,250 (2,820) (69.290/.) 4,070 4,070 1,250 (2,820) (69.29%) 150,000 0 0 0 N/A 150,000 0 0 0 N/A 0 0 0 0 N/A 0 0 0 0 N/A • 0 0 740;000 740,000 N/A 0 0 740,000 740,000 N/A 0 0 0 0 N/A 0 0 0 0 N/A 154,070 4,070 741,250 737,180 18112.53% 0 0 0 0 N/A 8510, Buildings/Improvements 40,491 0 0 90,000 90,000 N/A 8515 Engineering Costs 18,813 83,665 0 0 0 N/A 8517 Adminsitration 16,572 0 0 0 0 N/A 8542 Kawana.Springs Reservoir 0 0 0 0 0 N/A 9137 Eldridge Booster Pump 0 0 0 0 0 N/A 9144 Reservoir inlet/outlet 0 0 0 0 0 N/A 9150 Kawana,.Spg Res. Pipeline 0 0 0 0 0 N/A 9151 Pipeline,'Rights - City of Sant 0 0 0 0 0 N/A 9153 Reservoir ,Siesmic.Valves 0 0 0 0 0 N/A 9157 Cotati Res .Revegetation 8543 Petaluma Aque Relocation 0 45,696' 0 300,000 0 150,000 0 300,000 0 150,000 N/A 100.00% r 9162 Kawana'to Ralphine Tanks 10,202 284,516 75,000 350,000 275,000 366.67% 2/14/2012 4:30 PM 2w '9168 Kawana Springs Tank # 2 0 0 0 0 0 N/A 91;7.1'Oakmorit,Pipeline 0 0 0 0 0 N/A SUBTOTAL 131,774 668,181 225;000 .740,000 515,000 228.89% TOTAL EXPENDITURES 122,993 668,181 225,000 740,000 515,000 228.89% Outstanding Encumbrances - Net C 0 0 Long Term Debt proceeds 0 0 Capitalized Interest (8,781) 0 0 CIP Adjustment 0 ENDING FUND BALANCE 584,648 70,537 71,787 r 1 U • 211412012 4:30 PM FY 2012-13 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Storage Facilities Revenue Bond - 2003A • Section'Andex No: 6754621 Actual Estimated Adopted Requested, Percent Subobject.Title 2010-11 2011-12 2011-12 2012-13 Difference Change (BEGINNING FUND'.BALANCE $256,881' $309;202 $360,409 REVENUES' USE OF MONEY / PROPERTY 1700 Interest on Pooled Cash 1,741 1,304 1,304 1,185' (119) (9.13%) 1701 Interest Earned 54 6 0 0 0 N/A SUBTOTAL 1,795 1,304 1,304 1,185 (119) (913%) ADMINISTRATIVE CONTROL 4200 Long Term Debt Proceeds 0 0 0 0 0 N/A 4209 Long Term Debt Clearing 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A OTHER FINANCING SOURCES 4625 OT - Win Special Dist 357,755 358,568 358,508 357,683 (825) (0.23%) SUBTOTAL 357,755 358;508 358,508 357.,683 (825) (0.23%) TOTAL REVENUES 359,550 359,812 359,812 368,868 (944) (0.26%) EXPENDITURES SERVICES AND SUPPLIES 6635 Fiscal Agent Fees 783 1,500 1,500 1,500 0 0.00% 6640 Debt Insurance Costs 21822 2,822 2,822 2,822 0 0 00% SUBTOTAL 3,605 4,322 4,322 4,322 0 0:00% OTHER CHARGES 7920 Interest 191,620 187,622 187,622 182,250 (5,372) (2:86%) 7923 Discount / Bonds 319 319 319 319 0 0.00% SUBTOTAL 191,939 187,941 187,941 182,569 (5,372) (286%) OTHEWFINANCING USES 8625 OT - W/in Special Dist 0 0 0 240,000 240,000 N/A SUBTOTAL 0 0 0 240,000 240,000 N/A ADMIN. CONTROL ACCOUNT 9200 Ent - Principal 114,628 119,483 119,483 124,138. 4,655 3.90% 9209 Ent - Principal Clearing (114',828) (1.19,483) (119,483) (124,138) (4,655) 190% SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURES 195,544 192,263 192,263 426;891 234,628 12103% Increase in Bonds Payable 0 0 0 Amort. of Bond Issuance Costs 3,141 3,141 3,141 Principal Payment (114,826) (119,483) (124,138) (ENDING FUNDBALANCE$309,262 $360;409 $171,389 IRWE -101ki irI8l9w FY 2012-13 'BUDGET AND ENDING CASH SUMMARY •BEGINNING Section Title: IStorage4Ficilities Revenue Bonds 2006 Section/Index No: 675488 Actual Estimated Adopted Requested Percent Subobject Title 2010;11 2011.12 2011-12 2012-13 Difference Change BEGINNING FUND BALANCE $416,964 $467,253 $534,553 REVENUES USE OF MONEY I PROPERTY 1700 Interest on Pooled Cash 2,722 4,065 4,065 1,500 (2,565) (63.10%) 1701 Interest Earned 69 0 0 0 0 N/A SUBTOTAL 2,791 4,065 4,065 1,500 (2,565) (63.10%) ADMINISTRATIVE CONTROL 4200 Long Term Debt Proceeds 0 0 0 0 0 N/A 4209 Long Term Debt Clearing 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A OTHER FINANCING SOURCES 4625OT - Win Special Dist 449,236 449,721 449,721 449,964 243 0.05% SUBTOTAL 449,236 449,721 449,721 449,964 243 0.05% TOTAL REVENUES 452,027 453,786 453,786 451,464 (2,322) (0.51%) EXPENDITURES SERVICES AND SUPPLIES •, 6635 Fiscal Agent Fees 1,301 2,500 2,500 2,500 0 0.00% 6640 Debt Insurance Costs 4,575 4,576 4,576 4,576 0 0.00% SUBTOTAL 5,876 7,076 7,076 7,076 0 0.00% OTHER CHARGES 7920 Interest 262,044 257,184 257,184 252,112 (5,072) (1.97%) 7922 Premium -Call Bonds (2,223) 0 0 0 0 N/A SUBTOTAL 259,821 257,184 257,184 252,112 (5,072) (1,97%) OTHER FINANCING USES 8625 OT - Win Special Dist 16,874 0 0 500,000 500,000 N/A SUBTOTAL 16,874 0 0 500,000 500,000 N/A ADMIN. CONTROL ACCOUNT 9200 Ent -'Principal 121,518 126,802 126,802 132,085 5,283 4.17% 9209 Ent- Principal Clearing (121,518) (126,802) (126,802) (132,085) (5,283) 4.17% SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURES 282,571 264,260 264,260 759,188 494,928 187.29% Cost of Issuance 0 0 Restricted Cash w/Fiscal Agent 0 0 Increase in Bonds Payable 0 0 0 Amort of Bond Premium 0 0 0 Amort. of Bond Issuance Costs 2,352 4,576 4,576 Long Term Debt Proceeds 0 0 0 Principal Payment (121,519) (126,802) (132,085) Post -Audit Adjustment - Closing • COI Funds 0 0 (ENDING FUND BALANCE $467,253 $534,553 $99,320 211412012 4'30 PM Zq FY 2012-13 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Section/Index No: Subobject Title �BEGINNINGFUND BALANCE REVENUES USE OF MONEY I PROPERTY 1700 Interest on Pooled Cash SUBTOTAL INTERGOVERNMENTAL REVENUE 2852 Federal Grants SUBTOTAL MISCELLANEOUS REVENUE 4102 Donations/Reimbursements SUBTOTAL OTHER FINANCING' SOURCES 4625 OT=Wfin'Special.Dist SUBTOTAL TOTAL,REVENUES EXPENDITURES FIXED ASSETS 8510Buildiings/Improvements 8515 .Engineering Costs 8517 Admmsitrahon 8543 Petaluma Aq Relocation - Kastania 9106 Santa Rosa;Aqueduct Sections 2 & 3 (Slusser to Pet Aq) 9115 Wohler Santa Rosa,Pipeline 9128 Local Hazard Mitigation 9154 Petaluma Aqueduct 9163 Eldridge-Madrene Pipeline 9174 South Trans Syst Pipeline 9192 Sonoma; Aqueduct 9482 Amort WIP Outlay SUBTOTAL OTHER CHARGES 7924 Interest - Prior Year TOTAL EXPENDITURES Outstanding Encumbrances - Net Change Capitalized Interest CIP Adjustment JENDING FUND BALANCE lPipeline Facilities 675413 Actual Estimated Adopted Requested 2610-11 2011-12' 2011-12 2012=13 Difference 1,013,236 628,061 87,759 Percent Change 6,316 5,698 5,698 2;500 (3,198) -56.12% 6,316 5,698 5,698 2,500 (3,198) -56.12% 71,253 0 0 0 0 N/A 71,253 0 0 0 0 N/A 0 0 0 0 0 N/A 0 0 0 0 0 N/A 19,878 1,161,000 1,161,000 2,534,000 1',373,000 118.26% 19,878 1,161,000 1,161,000 2,S34,000 1,373,000 118.26% 97,447 1,166,698 1,166,698 2,536,500 1,369,802 117.41% 175 0 0 0 0 N/A • 15,188 0 0 0 0 N/A 13;512 0 0 0 0 N/A 0 0 0 0 0 N/A 0 562,000 322,000 825,000 503,000 156.21% 0 0 0 0 0 N/A 71,280 800,000 0 1,094,o00 1,094,000 N/A 11,808 300,000. 714,000 290',000 (424',000) (59 38%) 0 0 0 0 0 N/A 6 0 0 6 0 N/A 0 45,000 125,000 325,000 200,000 160.00% 345 0 0 0 0 N/A 112,308 1,707,000 1,161,000 2,534,000 1,373,000 118.26% (120,184) 0 0 0 0 N/A (120,184) 0 0 0 0 N/A (7,876) 1,767,000 1,161,000 2,534,000 1,373,000 118.26% (370,314) 0 (120,184) 0 0 628,061 87,759 90,259 • {9fGl/ZrSL'iAtrI�l�i71 FY'2012-13 BUDGET • BEGINNING AND ENDING; CA'SKSUMMARY Section Title: jSononna.A0ueduct;Ri6Vehue Bonds Section/Index No: 1 675470 1 Actual Estimated Adopted Requested Percent Subobject Title 2010-11 2011-12 2011-12 2012-13 Difference Change (BEGINNING FUND BALANCE $426,294 $470,625 $463,811 REVENUES USE OF MONEY / PROPERTY 1700 Interest on Pooled Cash 2,807 2,233 2,233 2,030 (203) (9.09%) 1701Interest Earned 45 0 0 0 0 N/A SUBTOTAL 2,852 2,233 2,233 2,030 (203) (9.09%) ADMINISTRATIVE CONTROL 4200 Long Term Debt Proceeds 0 0 0 0 0 N/A 4209 Long Term Debt Clearing 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A OTHER FINANCING SOURCES 4625 OT - W/in Special Dist 294,.115 294,175 294,175 294,056 (119) (0 04%) SUBTOTAL 294,115 294,175 294,175 294,056 (119) (0.04%) TOTAL REVENUES 296,967 296,408 296;408 296,086 (322) (0.11%) • EXPENDITURES SERVICES AND SUPPLIES 6635 Fiscal Agent Fees 667 1,200 1,200 1,200 0 0,00% 6640 Debt Insurance Costs 2,320 2,320 2,320 2,320 0 0.00% SUBTOTAL 2,987 3,520 3,520 3,520 0 0.00% OTHER CHARGES 7920 Interest 157,555 153,780 153,780 149,850 (3,930) (2.56%) 7923 Discount/Bonds 262 262 262 262 0 0.00% SUBTOTAL 157,817 154,042 154,042 150,112 (3,930) (2.55%) OTHER FINANCING USES 8625 OT - W/in Special Dist 0 50,000 50,000 325,000 275,000 550.00% ,SUBTOTAL 0 50,000 50,000 325,000 275,000 550.00% ADMIW CONTROL ACCOUNT 9200 Ent - Principal 94,414 98,242 98,242 102,069 3,827 '3 90% 9209 Ent - Principal Clearing (94,414) (98;242) (98,242) (102,069) (3;827) 3.90% SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURES 160,804 207,562 207,562 478,632 271,070 130.60% Increase in Bonds Payable 0 0 Amort. of Bond Issuance Costs 2,582 2,582 2,582 Principal Payments on Bonds (94,414) (98,242) (102,069) (ENDING FUND BALANCE $470,625 $463,811 $181,778 C1 2/14/2012 4:30 PM a FY 2012-13 BUDGET BEGINNING AND ENDING CASH, SUMMARY • Section Title: ICommon Facilities Section/index No: 675421 Actual Estimated Adopted Requested Percent Subobject-Title 2010-11 2011.12 .2011-12 2012-13 Difference Change BEGINNING FUND BALANCE (602;376) (946,262) (621',851) REVENUES USE OF MONEY'/PROPERTY 1700 Interest on'Pooled Cash (6,686) (32,790) (1,100) (1,000) 100; (9.09%)_ SUBTOTAL (6,686) (32;790) (1,100) (1,000) 100 (909%) Interaovernmental Revenue 4304 Federal Grant 0 255,132 0 0 0 N/A SUBTOTAL 0 255,132 0 0 0 N/A Charaes for Services 3980 Revenue Apply to PY 6,167 0 0 0 0 N/A SUBTOTAL 6,167 0 0 0 0 N/A Miscellaneous Revenues 4040 Miscellaneous;Revenue 0 0 0 0 0 N/A 4102 Donations/Reimbursements 0 0 0 300,000 300,000 N/A 4109 Outdate/Cancel Warrants 330 0 0 0 0 N/A 4303 State Grants 1,200 0 0 0 0 N/A SUBTOTAL 1,530 0 0 300,000 300,000 N/A ADMINISTRATIVE CONTROL 4210 Advarices 0 0 0 6;959,124 6,959,124 N/A 4219Advances-Clearing 0 0 0 (6',959,124) (6,959,124) N/A SUBTOTAL 0 0 0 0 0 N/A OTHER FI NANCINCr SOURCES 4625 OT - Win Special Dist 1',369,633 2,545,399 2;727,708 3,825,384 1,097,676 40.24% SUBTOTAL 1,369,633 2545,399 2;727,708 3;825,384 1,097,676 40.24% TOTAL REVENUES 1,370,644 2,767,741 2;726,608 4,124,384 1,397,776 51.26% EXPENDITURES OTHER CHARGES 7480, Exp Applicable to Prior Year 0 0 0 0 0 N/A 7920 Interest Payment 0 0 0 277,146 277,146 N/A 7924 Capital Interest (656,873) 0 0 0 0 N/A 8090 Loss on'Fixed Assets 69,174 0 0 0 0 N/A SUBTOTAL (587,699) 0 0 277,146 277,146 N/A FIXED ASSETS 8500 Land 0 0 0 0 0 N/A 8510 Buildings / Improvements 7;783 350,000 350,000 1,825,000 1,475,000 421.43% 8515 Engine ering'Costs 56,237 0 0 0 0 N/A 8517 Adminsitration 47;896 0 0 0 0 N/A 8528 Mirabel'Generator 0 0 0 0 0 N/A. 8529 IsolationValves & Meters 205,468 191,330 150,000 133,000 (17,000) (11.339 32 211412012 4.30 PM Section Title: lCommon Facilities Sectionllndex No: 675429 Actual Estimated Adopted Requested Percent Subobject Title _ 2010-11 2011.1Z 2011.12 2012.13 _ Difference Change 8552 Forestville Storage Tank 1 14 (c) and (d 105,482 722,000 722,000 0 (722,000) (10000%) 8558 Collector 1& 2 Aq Exp 0 0 0 0 0 N/A 8559 Early Warning System 0 0 0 0 0 N/A 8625 Unclaimable OT within Special Districts 0 0 0 0 0 N/A 9105 Mirabel Fish Screen Replacement 20,506 200,000 0 6,309,000 6,309,000 N/A 9107 Air Valves 373,197 370,000 370,000 541,000 171,000 46.22% 9108 Aquifer Sediments Geochemical Study 0 0 0 0 0 N/A 9109 Surface Water/Groundwater Model HEC 0 0 0 0 0 N/A 9110 Surge Protection 0 0 0 0 0 N/A 9112 Mirabel Site Improvement 0 0 0 0 0 N/A 9113 Wohler Site Improvement 0 0 200,000 0 (200,000) (100.00%) 9114 River Well Field Develop 0 0 0 0 0 N/A 9115 Mirabel Inflatable Dam 0 0 0 0 0 N/A 9125 Sonoma Booster Upgrade 0 0 0 0 0 N/A 9128 Local Hazard Mitigation 71,578 610,000 610,000 1,179,000 569,000 93.28% 9130 Trans System Exp - Water Project EIR, Dry Creek Feasibility Study, Mrabel/Cotati Feasibility Study, Flow EIR, Spring Lake Groundwater, Phase II 12 kv Project 439 0 0 0 0 N/A 9136 Production Wells Improv. 0 0 0 0 0 N/A 9138 River Road Site Improve. 0 0 0 0 0 N/A 9152 Pump & Collector Capacity 0 0 0 0 0 N/A 9159 Pump & Collector Capacity 0 0 0 0 0 N/A 9163 Eldridge-Madrone Pipeline 0 0 0 0 0 N/A •9164 Emergency Power for Trans. System 0 0 0 0 0 N/A 9170 River Front Park Recl 0 0 0 0 0 N/A 9172 Water Education Facility 0 0 0 0 0 N/A 9175 Wohler Mirabei 12KV 0 0 0 0 0 N/A 9176 Mirabel - Cotati Pipeline 0 0 0 0 0 N/A 9177 Dry Creek Bypass Pipeline 0 0 0 0 0 N/A 9193 Auto Meter Infrastructure 38,195 0 0 0 0 N/A 9480 Intangible Assets 3 0 0 0 0 N/A 9482 Amort WIP Outlay 604 0 0 0 0 N/A SUBTOTAL 927,388 2,443,330 2,402,000 9,987,000 7,585,000 315 78% OTHER FINANCING USES 8625 OT - W/in Special Dist 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A ADMIN. CONTROL ACCOUNT 9210 Advances 0 0 0 123,256 123,256 N/A 92'19 Advances -Clearing 0 0 0 (123,256) (123,256) N/A SUBTOTAL 0 0 0 0 0 N/A PRIOR YEAR ENCUMBRANCEEXPENSE 9852 PY Enc - Bldg / Imp 19,751 0 0 0 0 N/A SUBTOTAL 19,751 0 0 0 0 N/A • TOTAL EXPENDITURES 359,440 2,443,330 2,402,000 10,264,146 7,862,146 327.32% 211412012 4:30 PM a Section Title: Section/index No: Subobject Title Loan Outstanding Encumbrances - Net Change Capitalized Interest Proceeds from State Loan,& Other LT Debt Principal payment on Loan Change in Deposit with,Others Change in Contingent Liability PY CIP Adjustment - Reclass to PY Exp (ENDING FUND BALANCE lCommon Facilities 675421 Actual Estimated Adopted Requested 2010=112011-12 2011-12 2012-13' 0 0 6;959,124- (767,391) 0 0' (656,873) 0 0 0 0 0 0 0 (123,256) 0 0 10 0 0 69,174 (946,262) (621,851) 74,255 Difference Percent Change • 211412012 4 30 PM P FY 2012-13 BUDGET Common Facilities " Section 675421 Detailed Listing of Capital Projects SUB -OBJECT DESCRIPTION 8510 Buildings and Improvements DESCRIPTION Mirabel Potable Water Line Billing Meter Replacement Collector 6 Chlorine Solution Lines Mirabel Surge Control Water Agency Westside Facility 8528 Mirabel Generator DESCRIPTION Mirabel Generator 8529Isolation Valves and Meters DESCRIPTION Isolation Valves 9105 Mirabel Fish Screen Replacement DESCRIPTION Fish Screen Replacement 9107 Air Valves DESCRIPTION Air Valves 9128 Local Hazard Mitigation Projects DESCRIPTION RDS Liquefaction Mitigation Collector 6 Liquefaction Mitigation RR Crossing MW Creek Crossing Mirabel Dam,Emergency Response Plan Collector 3 and 5 Liquefaction Mitigation Predesign 9482 - Amort WIP Outlay DESCRIPTION IBM Collaboration Platform (moved to,GF w/WT support services s/o 6889) Total Common Facilities Project & Subobject FY 2012-13 BUDGET 0 400,000 25;000 200;000 1,200,000 4,825;000, TBD 01 8528TotaIt :'" 0{ 7379 133;000 8529Totalr=;"" ".1336000� 7357,75321 6,309,000 1 9105 Total["_4.�, �- 6;309;000 7429 541,000 1 9107 Total 541';000 0 405,000 554,000 0 TBD 220,000 9128 Total[. "1„179,000' 0� !' .. of 9,987,000 2/14/2012 4'30 PM FY 2012-13 BUDGET • BEGINNING AND ENDING'CASH SUMMARY Section Title: Common Facilities Revenue Bonds - 2003 A Section/Index No: 675454 1 Actual Estimated Adopted Requested Percent Subobject,Title 2010-11 2011'-12 2011-12 2012,13 Difference Change BEG. FUND BALANCE $222,543 $294,384,. $365;286 REVENUES USE OF MONEY /PROPERTY 1700 Interest on Pooled Cash 1,559 1,238 1,238 1,000 (238), (19.22%) 1701 Interest Earned 76 0 0 0 0 N/A SUBTOTAL 1,635 1,238 1,238 1,000 '(238) (19.22%) ADMINISTRATIV E'CONTROL 4200 Long Term DebtProceed: 0 0 0 0 0 N/A 4209 Long Term Debt Clearing 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A OTHER FINANCING SOURCES 4625 OT - W/m Special Dist 500,280 500,380 500,380 500,180 (200) (0.04%) SUBTOTAL 500,280 500,380 500,380 500;180 - (200)" (0:04%) TOTAL REVENUES 501,915 501,618 501,618 501,180 (438) (0.09%) EXPENDITURES SERVICES AND SUPPLIES 6635 Fiscal Agent Fees 1,047 1;600 1,600 1,600 0 0 00% 6640 Debt Insurance Costs 3,950 3,951 3,951 3,951 0 0 00% SUBTOTAL 4,997 5,551 5,551 5,551 0 0.00% OTHER CHARGES 7920'Interest 268,269 261,840 261,840 255,148 (6,692) (2.56%) 7923 Discount I Bonds 446 446 446 446 0 0.00% SUBTOTAL 268,715 262,286 262;286 255,594 (6,692) (2.55%) OTHER FINANCING USES 8625 OT- Wk'Special Dist 0 0 0 400,000 400,000 N/A SUBTOTAL 0 0 0 400,000 400,000 N/A ADMIN. CONTROL ACCOUNT 9200 Ent - Principal 160,759 167,276, 167,276 173,794 6,518 3.90% 9209 Ent - Principal Clearing (160,759) (167,276) (167,276) (173;794) (6,518) 3.90% SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURES 273,712 267,837 267,837 661,145 393,308 146.85% ' Increase in Bonds Payable 0 0 0 Amort of Bond Issuance Costs 4,397 4,397 4,397 Long Term Debt Proceeds Principal Payment (160,759) (.167,276) (173,794) ENDING FUND BALANCE $294',384 $365,286 $35,924 0 2/14/2012 4 30 PM 0 • • FY 2012-13 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: lCommon Facilities Revenue Bonds 2006 Section/Index No: 1 675496 Actual Estimated Adopted Requested Percent Subobject Title 2010-11 2011.12 2011-12 2012.13 Difference Change BEG. FUND BALANCE $118,970 $177,370 $229,886 REVENUES USE OF MONEY/PROPERTY 1700 Interest on Pooled Cash 1701 Interest Earned SUBTOTAL ADMINISTRATIVE CONTROL 4200 Long Term Debt Proceed; 4209 Long Term Debt Clearing SUBTOTAL OTHER FINANCING SOURCES 4625 OT - Win Special Dist SUBTOTAL TOTAL REVENUES EXPENDITURES SERVICES AND SUPPLIES 6635 Fiscal Agent Fees 6640 Debt Insurance Costs SUBTOTAL OTHER CHARGES 7920 Interest 7922 Premium -Call Bonds SUBTOTAL OTHER FINANCING USES 8625 OT- Win Special Dist SUBTOTAL ADMIN. CONTROL ACCOUNT 9200 Ent -Principal 9209 Ent -Principal Clearing SUBTOTAL TOTAL EXPENDITURES Cost of Issuance Restricted Cash w/Fiscal Agent Increase in Bonds Payable Amort of Bond Premium Amort of Bond Issuance Costs Long Term Debt Proceeds Principal Payment Post -Audit Adjustment - Closing COI Funds (ENDING FUND BALANCE 813 825 825 750 61 0 0 0 874 825 825 750 0 0 0 0 0 0 0 0 0 0 0 0 401,125 401,125 401,557 401,774 401,125 401;125 401,557 401,774 401,999 401,950 402,382 402,524 1,183 2,300 2,300 2,300 4,085 4,085 4,085 4,085 5,268 6,385 6,385 6,385 233,934 233,936 229,596 225,068 (1,984) 0 0 0 231,950 233,936 229,596 225,068 0 0 0 250,000 0 0 0 250,000 108,482 113,199 113,199 117,916 (108,482) (113,199) (113,199) (117,916) 0 0 0 0 237,218 240,321 235,981 481,453 0 0 0 0 0 0 0 0 0 (1,984) 0 0 4,085 4,085 4,085 0 0 0 (108,482) (113,199) (117,916) 0 0 0 $177,370 $229,885 $37,125 (75) (9.09%) 0 N/A (75) (9 09%) 0 N/A 0 N/A 0 N/A 217 217 142 0 0 0 (4,528) 0 (4,528) 250,000 250,000 4,717 (4,717) 0 245,472 0,05% 0 05% 0.04% 0.00% 0 00% 0 00% (1.97%) N/A (1.97%) N/A N/A 4.17% 4,17% N/A 104.02% 2/14/2012 4:30 PM FY`2012-13 BUDGET • BEGINNING.AND'ENDING CASH SUMMARY Section Title: IState Loan.Debt,Service Fund Section/Indez,No: 1 675439 1 Actual Estimated Adopted Requested Percent Subobject Title 2010-11 201IA2 201.1-12 2012-13 Difference Change BEGINNING FUND BALANCE $105,354 $247;824 $407,500, REVENUES USE OF --MONEY /PROPERTY 1700 Interest on Pooled Cash 4,317 3,641 3,641 3,500 (141) . (3.87%) 1701 Interest Earned 0 0 0 0 0 N/A SUBTOTAL 4,317 3,641 3,641 3,500 (141) (387%) OTHER FINANCING SOURCES 4625 OT- W/in Special Dist 1,196,268 1,196,268 1,196,268 1,196,268 (0) (0.00%) SUBTOTAL 1,196,268 1,196;26& 1,196,268 1,196,268. (0) (0.00%) TOTAL -REVENUES 1,200,585 1,199,909 1,199,909 1,199,768 (141) (0:01%) EXPENDITURES OTHER CHARGES 7930 Interest -LT Debt 404,469 386,587 386,587 368,200. (18,387) (4.76%) • SUBTOTAL 404,469 386,587 386,587 368,200 (18,387) (4.76%) OTHER FINANCING USES 8625 OT - W/in Special Dist 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A ADMIN. CONTROL ACCOUNT 9200, Ent -Principal 635,758, 653,646 653,646 672,033 18,387 2.81% 9209 Ent- Principal Clearing (635,758) (653,646) (653,646) (672,033) (18,387) 2.81% SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURES 404,468 386,587 366,687 368,200 (18,387) (4.76%) Principal Payment (635,762) (653,646) (672,033) Change in Due to Other'Gov (17,884) ENDING FUND'BALANCE $247,824' $407,500 $567,035 • 3e 2/14/2012 4:30 PM FY'12012=1'3 BUDGET BEGINNING AND' ENDING CASH SUMMARY Section Title: IState Loan Reserve Fund Section/Index No: 675447 Actual Estimated Adopted Requested Percent Subobject Title 2010-11 2011-12 2011-12 2012-13 Difference Change BEGINNING FUND BALANCE $0 $0 $0 REVENUES USE OF MONEY / PROPERTY 1700 Interest on Pooled Cash 5,619 4,373 4,373 4,500 127 2,90% 1701 Interest Earned 0 0 0 0 0 N/A SUBTOTAL 5,619 4,373 4',373 4,500 127 2.90% OTHER FINANCING SOURCES 4625 OT - W/in Special Dist 119,627 119,627 119,627 119,627 (0) (0.00%) SUBTOTAL 119;627 119,627 119,627 119,627 (0) (0.00%) • TOTAL REVENUES 125,241 124,000 114,111 124,127 121 0,10% EXPENDITURES OTHER FINANCING'USES 6625 OT - Win Special Dist 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURES 0 0 0 0 0 NIA Reserve Unavail. for Budgeting (125,246) (124,000) (124,127) (ENDING FUND BALANCE $0 $0 $0 Fund Balance Comaonents at Beainnina of FY $40,360 $40,725 Cash $857,896 $983,142 • 2/14/2012 4:30 PM FY 2012-13 BUDGET BEGINNING AND ENDING CASH'SUMMARY Section Title: North'Marin Water Deposit Section/Index No: 675512 1 ISubobject Title BEGINNING FUND BALANCE REVENUES USE OF MONEY/PROPERTY 1700 Interest on Pooled Cash SUBTOTAL Intergovernmental Revenue 2900 Other Government Agencies SUBTOTAL MISCELLANEOUS REVENUES 4625 OT - W/in Special Dist SUBTOTAL TOTAL REVENUES EXPENDITURES OTHER CHARGES 8010 Contribution Non -Co Govt SUBTOTAL OTHER FINANCING USES 8625 OT - Win Special Dist SUBTOTAL TOTAL, EXPENDITURES ENDING FUND BALANCE Actual Estimated Adopted Requested Percent 2010.11 2011.12 2011-U -2012-13, Difference Change 12,433 12,540 12;634' 107 94 94 85 (9) (9.57%) 107 94 94 85 (9) (9.57%) 0 0 0 1,240,876 1',240,876 N/A 0 0 0 1,240,876 1,240,876 N/A 0 0 0 0 0 N/A 0 0 0 0 0 N/A 107 94 94 1,240,961 1;240,867 1320071.28% • 0 0 0 0 0 N/A 0 0 0 0 0 N/A 0 0 0 1,240;876 11240,876 N/A 00 0 1,240,876 1',240,876 N/A' 0 0 0 1,240;876 1;240,876 N/A 12,540 12,634 12,719 0 2/14M 12 4:30 PM FY 20.12-13 .BUDGET BEGINNING AND ENDING CASH SUMMARY • Section Title: ISanta Rosa Aqueduct Capital Fund. Section/Index No: 675207 I Actual Estimated Adopted Requested Percent Subobject Title 2010-11 2011-12 2011-12 2012-13 Difference Change BEGINNING FUND BALANCE 5,696,127 5,775,073 5,549,241 REVENUES USE OF MONEY I PROPERTY 1700 Interest on Pooled Cash 36,443 31,037 31,037 25,000 (6,037) (19.45%) 1701 Interest Earned 0 0 0 124,716 124,716 N/A SUBTOTAL 36,443 31,037 31,037 149,716 118,679 382.38% MISCELLANEOUS REVENUES 4035 Sale -Water Resale 0 0 0 0 0 N/A 4036 Sale - Water Government 0 0 0 0 0 N/A 4102 Reimbursements 0 0 0 0 0 N/A 4166 SR Aqueduct Capital Chargf 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A ADMINISTRATIVE CONTROL ACCOUNT 4210 Advances 0 0 0 55,465 55,465 N/A • 4219 Advances- Clearing 0 0 0 (55,465) (55,465) N/A SUBTOTAL 0 0 0 0 0 N/A OTHER FINANCING SOURCES 4625 OT - W/in Special Dist 62,381 65,131 66,445 211,891 145,446 218.90% SUBTOTAL 62,381 65,131 66,445 211,891 145,446 218.90% TOTAL REVENUES 98,824 96,168 97,482 361,607 264,125 270.95% EXPENDITURES OTHER FINANCINGUSES 8625 OT - W/in Special Dist 19,878. 322,000 322,000 1,919,000 1,597,000 495 96% SUBTOTAL 19,878 322,000 322,000 1,919,000 1,597;000 '495.96% ADMINISTRATIVE CONTROL ACCOUNT 9210 Advances 0 0 0 3,131,606 3,131,606 N/A 9219 Advances -Clearing 0 0 0 (3,131,606) (3,131,606) N/A SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURES 19,878 322,000 322,000 1,919,000 1,597,000 495.96% Advances to Common (3,131,606) Increase/(Decrease) in Loan Payable 0 • Principal Receipt on Advance 55,465 (ENDING FUND BALANCE 5,775,073 5,549,241 915,707 211412012 4:30 PM Li 1 FY 2012-13 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Petaluma Aqueduct Capital Fund Section/Index No: '675215 1 Actual Subobject Title, 2010711 BEGINNING FUND BALANCE 5,545,740 REVENUES USE OF MONEY/PROPERTY 1700 Interest on Pooled Cash 35,483 1701 Interest Earned 0 SUBTOTAL 35,483 MISCELLANEOUS: REVENUES 4035 Sale' -•Water Resale 0 4036 Sale -Water Govt 0 4102 Reimbursements 0 4167 Petaluma:Aqueduct Cap F 0 SUBTOTAL 0 ADMINISTRATIVE CONTROL ACCOUNT 4210 Advances 0 4219 Advances -.Clearing 0 SUBTOTAL 0 OTHER FINANCING SOURCES 4625 OT- Win Special Dist 0 SUBTOTAL 0 TOTAL REVENUES 35,483 EXPENDITURES OTHER FINANCING USES 8625 OT - W/in Special Dist 0 SUBTOTAL 0 ADMINISTRATIVE CONTROL ACCOUNT 9210 Advances 0 9219 Advances - Clearing 0 SUBTOTAL 0 TOTAL EXPENDITURES 0 Estimated Adopted' 2011-12 2011-12 5,581,223 Requested 2012-13' Difference 4,897A05 Percent Change • 30,382 30,382 25;000 (5,382) (17.71%) 0 0 152,430 152,430 N/A 30,382, 30,382 177,430 147,048 484.00% 0 0 0 0 N/A 0 0 0 0 N/A 0 0 0' 0 N/A 0 0 0 0 N/A 0 0 0 0 N/A 0 0 67,791 67;791 N/A 0 0 (67,791) (67,791) N/A 0 0 .0 0 N/A 0 0 0 0 30,382 30,382' 714,000 714,000 714,000 714,000 0 0 0 0 0 0 714,000 714,000 Advance.to Common Increase/(Decrease)in Loan Payable Principal Receipt on Advance 1ENCIING FUND,BALANCE 5,5811'223 4;897,605, 207,512 207.512' 384,942 207;512 207,512' 354;560 N/A N/A 1167.01 % 290,000 (424;OD0) (59.38%) 290,000 (42410D0) (59:38%) 3,827,518 3A27;518 N/A (3,827;518) (3,827;518) N/A 0 .0 N/A 290,00d (4241000) (59.386/.) (3,827,518) 0 67,791 1,232;820 0 42 2/14/2012 4:30 PM FY 2012=13, BUDGET AND ENDING'CASH SUMMARY •BEGINNING Section Title: I Sonoma Aqueduct,Capital Fund, Section/index No: 675231 Actual Estimated, Adopted Requested Percent Subobject Title 2010.11 2011-12 2011-12 2012-13 Difference Change BEGINNING FUND BALANCE 124,2641. 125,049 50,731 REVENUES USE OF MONEY / PROPERTY 1700 Interest on Pooled Cash 795 682 682 650 (32) (4 69%) 1701 Interest Earned 0 0 0 0 0 N/A SUBTOTAL 795 682 682 650 (32) (4.69%) OTHER FINANCING SOURCES 4625 OT - Win Special Dist 0 MOW 50,000 72,230 22,230 44.46% SUBTOTAL 0 50,000 50,000 72,230 22,230 44.46% TOTAL REVENUES 795 50,682 50,682 72,880 22,198 43.80% EXPENDITURES OTHER FINANCING USES. 8625 OT - W/in Special Dist 0 125,000 125,000 0 (125,000) (100.00%) SUBTOTAL 0 125,000 125,000 0 (125,000) (100.00%) • TOTAL EXPENDITURES 0 125,000 125,000 0 (125,000) (100.00%) (ENDING FUND BALANCE 125,049 50,731 123,611 211412012 4:30 PM FY 2012-13 BUDGET BEGINNING AND ENDING 'CASH SUMMARY Section Title: Water -Management Planning S e ct i o n l l n d ex' N o: 675710 Actual Estimated 'Adopted Requested Subobject Title 2010,11 ,2011-12 - 2011-12 2012-13 Difference 1BEGINNING'F6ND BALANCE REVENUES USE OF MONEY'/ PROPERTY 1700 Interest on',Pooled Cash SUBTOTAL 362,617 72,630 3,692 3,157 3,692 3,157 Interaovernmental Revenue' 2912 Town of Windsor 12,242 SUBTOTAL 12,242 Miscellaneous Revenue 4040 Miscellaneous Revenue' 30 4175 Water Management Planning Char( 0 SUBTOTAL 30 OTHER, FINANCING SOURCES 4625 OT- Wlin Special Dist 195,087 SUBTOTAL 195,087 TOTAL REVENUES 211,051 EXPENDITURES Services and Suoolies 6040'Communications 123 6180 Maintenance Bldg/Imp 0 6430 Printing Services, 1,556 6461 Supplies/Expense 146 6522 District Operations 25,701 6523 District -Operations 302,359' 6570 Consultant Svs 18,265 6610 Legal Services 127,296 7206 Equipment.Usage 150 7247 Water Conservation 0 7303 Private Car Expense 103 SUBTOTAL 475,699 PRIOR YEAR ENCUMBRANCE EXPENSE 9650 PY Enc - Profess/Special 143,548 SUBTOTAL 143,548 TOTAL EXPENDITURES 619,247 Outstanding Encumbrances - Net Change 118,209 ENDING FUND'BALANCE 72,630 13,376 13,376 Er co 81,278 Percent Change • 3,157 2,870 (287). (9.09%) 3,157 2,870 (287)(9.09%) 13,376 3,481 (9,895) (73,97%) 13,376 3,481 (9,895) (73.97%) 0 0 0 N/A 0 0 0 N/A 0 0 0 N/A 192,115 200,000 wxo (150,000) (7500%) 192, 1,15 200,000 50,000 (15Q000) (7500%) 208,648 216,533 66,351 (160,182) (7198% 0 0 0 0 N/A 0 0 0 0 N/A 0 0 0 0 N/A 0 0 0 0 N/A 0 0 0 0 N/A 75,000 75,000 25,000 (501000) (66.67%) 50,060 50,000 25,000 (25,000) (50 00%) 75;000 75,000 0 (75,000) (100.00%) 0 0 0 0 N/A 0 0 0 0 N/A 0 0, 0 0 N/A 200,000 200,000 50,000 '(150,000) (75.00%) 0 0 0 0 N/A 0 0 0 0 N/A 200,000 200,000 (150,000) (75.00%) 50,000 Is 81,278 87A29 Liq 2/14/2012 4:30 PM FY 2012-13 BUDGET BEGINNING AND'END/N6,CASH.'SUMMARY • Section.Title: lWatershed,Planning/Restoration Section/Index No: 675728 , Actual Estimated Adopted Requested Percent Subobject Title 2010-11 2011-12 2011-12 2012-13 Difference Change BEGINNING FUND BALANCE (913,142) (1,303,176) 152,932 REVENUES USE OF MONEY/PROPERTY 1700 Interest on Pooled Cash (4,231) 0 1 1 (0) (37.50%) SUBTOTAL (4,231) 0 1 1 (0) (37500/.) Intergovernmental Revenue 2912 Town of Windsor 106,850 174,592, 174,597 259,394 84,797 48 57 % SUBTOTAL 106,850 174.592 174,597 259,394 84,797 4857% Miscellaneous Revenues 3980 Revenue applicable to prior year 0 0 0 0 0 N/A 4102 Donations/Reimbursements- SR Plain Groundwater 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A OTHER FINANCING SOURCES 4625 OT -W/in Special Dist 2,058,295 3,892,196 3,995,267 3,725,600 (269,667) (675%) SUBTOTAL 2,058,295 3,892,196 3,995,267 3,725,600 (269,667) (6.75%) TOTAL REVENUES 2,160,914 4,066,788 4,169,865 3,984,995 (184,870) (4.43% EXPENDITURES Services and Sunolies 6040 Communications 2,216 0 0 0 0 N/A 6140 Maint-Equipment 1,350 0 0 0 0 N/A 6180 Maintenance Bldg/Imp 12,417 0 0 0 0 N/A • 6262 Lab Supplies 1,101 0 0 0 0 N/A 6400 Office Supplies 4D2 0 0 0 0 N/A 6410 Postage 325 0 0 0 0 N/A 6415 Books/Penocical 173 0 0 0 0 N/A 6430 Printing Services 11,139 0 0 0 0 N/A 6461 Supplies/Expenses 6,918 0 0 0 0 N/A 6512 Testing/Analysis 53,467 0 0 0 0 N/A 6522 District Services 168,551 0 0 0 0 N/A 6523 District Operations - RRIFR Program 1,544,458 2,176,180 2,176,180 2,705,600 529,420 24.33% 6570 Consultant Services - RRIFR Program 217,279 404,500 404,500 990,000 585,500 144 75% 6610 Legal Services 1 04,61 0 30,000 30,000 30,000 0 0 00% 6800 Public/Legal Notices 6,120 0 0 0 0 N/A 6840 Rents/Leases-Bldg/Imp 605 0 0 0 0 N/A 6880 Small Tools/Instruments 9,973 0 0 0 0 N/A 6889 Software 6,330 0 0 0 0 N/A 6890 Hardware 1,726 0 0 0 0 N/A 7022 Public Relations Exp 1,442 0 0 0 0 N/A 7206 Equipment Usage 21,029 0 0 0 0 N/A 7217,State Permits/Fees 1,373 0 0 0 0 -N/A 7302 Travel Exp 14,581 0 0 0 0 N/A 7303 Private Car Expense 509 0 0 0 0 N/A SUBTOTAL 2,188,094 2,61 6680 2,610,680 3,725,600 1,114,920 42.71% PRIOR YEAR ENCUMBRANCE EXPENSE 9650 PY Enc - Profess/Special 571,46D 0 0 0 0 N/A SUBTOTAL 571,460 0 0 0 0 NIA TOTAL EXPENDITURES 2,759,554 2,610,680 2,610,680 3,725,600 1,114,920 42.71% • Outstandmg Encumbrances - Net Change 208,606 ENDING FUND BALANCE (1,303,176) 152,932 412,327 2/14/2012 4 30 PM 45 FY 2012-13 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: [RBCVCIed Water and Local Sui Section/index No: 1 676736 Actual Estimated Adopted Requested Percent Subpblect Title 2010-11 2011-12 2011-12 2012-13 Difference Chance BEGINNING FUND BALANCE 237.578 313,253 293,703 REVENUES USE OF MONEY I PROPERTY 1700 Interest on Pooled Cash 7,662 14,685 14,585 2,500 (12,185), (8298%) SUBTOTAL 7,662 14,685 14,685 2.500 - (12.155) (8298°n) InterapvemmeMal Revenue 2912 Torn of Windsor ,50,677 58,016 58017 51, 174 (6,843) (1179%) SUBTOTAL 50,677 58,016 58.017 51,174 be 843) (1179%) MISCELLANEOUS REVENUE 4040 Miscellaneous Revenue 0 0 0 0 0 N/A 41020onations/R_eimbursements 75,000 80,000 80000 140.000 60,000 7500% 4303 State Grant 27690 0 0 110000 110.000 NIA SUBTOTAL 102,660 80,000 80000 250000 170,000 21250% OTR ER FINANCING SOURCES 4625 OT- W4n Special Dist 311,557 833,265 867.500 735,000 (132,500) (15 27%) SUBTOTAL 811557 833,265 867.500 735,000 (132,500) (1527%) TOTAL REVENUES 972,756 986,966 1,020,202 1,038,674 18,472 1.81% EXPENDITURES Senators and Sumatra 6040 Commumraoons 313 0 0 0 0 NIA 6140 Mamt-Equpment 848 0 0 0 0 NIA 64000(Flce Expense 67 0 0 0 0 NIA 6410 Postage 77 0 0 0 0 NIA 5430 Printing Supplies 17.261 0 0 0 0 NIA 6451 suppheslExpenses 437 0 0 0 0 N/A 6522 Dlsmct Admmistratlan 28, 167 0 0 0 0 ;N/A 85230rstrict Operators 279718 330000 330.000 275,000 (55,000) (1667%) SV GW Mi Plan, SR Plain GW Study a Mgmt Plan 6570, Consultant Services 364,800 617.500 617,500 385,000 (232,500) (3765%) SV GW a4gmt Plan, SR Plain GW Study S Mgns Plan 6610 Legal Services 784 0 0 0 0 NIA 6630 Audit Services 0 0 0 0 0 NIA 6800 PublidLegal Notre 1, 127 0 0 0 0 NIA 6840 Rem5llaases/Bldg/Imp 786 0 0 0 0 6889 SoMrxre, 3,461 a 0 0 0 _NIA WA 7206 Equipment Usage 1,683 0 0 0 0 NIA 7217 State Permns/Fees 678 0 0 0 0 'N/A 7277 Recycled Water Use 0 0 0 0 0 N/A 7302 Travel Expense 17 0 0 0 0 N/A 7303 Private Car Expense 0 0 0 0 0 'NIA SUBTOTAL 700,224 947.500: 947,500 660000 (287,51 (3034%) Other Charges 7924 - Interest PY (21,357) 0 0 0 0 NIA 8010 Contnbuton Non -County Government 0 0 0 325,000 (LRT2) SUBTOTAL (21,357) 0 0 325,000 0 ',NIA Capital Assets 8510 Buildingsi 50,096 0 0 0 0 N/A 8515 Engmeenng Costs 448 0 0 0 0 N/A 8517 Adminsitratons 402 0 0 0 0 'NIA 9482 Amorinice WE 0 0 0 0 0 N/A SUBTOTAL 60946 0 0 0 0 NIA PRIOR YEAR ENCUMBRANCE EXPENSE 9650 PY Eno - Proless/Special 65,267 0 0 0 0 NIA 9700 PY Eric-SpecialDept Exp 1,189.451 0 0 0 0 NIA SUBTOTAL 1274,718 0 0 0 0 N/A TOTAL EXPENDITURES 2,014,531 947,500 947.600 985,000 37,500 3.96% Outstanding Encumbrances - Net Change 1,255,339 Capital Interest (21,357) 0 Change in Windsor Reserve (50,678) (58016) (51,174) Aud6Adjustment (65,854) JENDINGFUNO BALANCE 313,253 293703 296,263 C� • • 271472012 430 PM FY,2012"-13 BUDGET BEGINNING ,A'Nd ENDING CASH SUMMARY • Section Title: I Water CenserVetion Secti onll n d ex No: 675744 Actual Estimated Adopted Requested Percent Suboblect Title 2010-11 2011.12 2011-12 2012-13 Difference Change BEGINNING FUND BALANCE 186,164 164,246 29,262 REVENUES USE OF MONEY / PROPERTY 1700 Interest on Pooled Cash 3,493 3,658 3,658 2,500 (1,158) (31.66%) SUBTOTAL 3,493 3,658 3,658 2,500 (1,158) (31669%) Intergovernmental Revenue 2911 City of Santa Rosa 0 0 0 0 0 N/A 2912 Town of Windsor 96,318 100,640 100,651 105,134 4,483 4 45% 2914 City of Rohnert Park 0 0 0 0 0 N/A 2919 City of Sonoma 0 0 0 0 0 N/A 2951 North Marin Water District 0 0 0 0 0 N/A 2954 Town of Windsor 0 0 0 0 0 N/A SUBTOTAL 96,318 100,640 100,651 105,134 4,483 445% Miscellaneous Revenue 3980Revenue Applicable to Prior Y - - - - 0 N/A 4640 Miscellaneaous Revenue - - - - 0 N/A 4102 Donations/Reimbursements 0 0 0 0 0 N/A 4303 State Grants (2,106) 67.347 0 0 0 N/A SUBTOTAL (2;106) 67,347 0 0 0 N/A OTHER FINANCING SOURCES • 4625 OT - Who Special Dist 1,542,148 1,445,460 1,505,000 1,510,000 5,000 0 33% SUBTOTAL 1,542,148 1,445,460 1,505,000 1,510,000 5,000 033°% TOTAL REVENUES 1,639,853 1,617,105 1,609,309 1.617,634 8,325 0.52% EXPENDITURES Services and Suoolies 6180 Maint-Bldg/Imp 813 0 0 0 0 N/A 6020 Clothing 0 0 0 0 0 N/A 6415 Books/Penodicals 119 0 0 0 0 N/A 6461 Supllies/Expense 953 0 0 0 0 N/A 6522 District Services 92,547 0 0 0 0 N/A 6523 District Operations 1,143,623 900,000 900,000 895,000 (5,000) (0 56%) 6536 Business Environmental Allian 41,897 50,000 50,000 50,000 0 0 00% 6570 Consultant Services 0 20,000 10,000 0 (10,000) (100.00%) 6584 Trade Shows - So Cty Fair 0 20,000 20,000 20,000 0 0 00% 6610 Legal Services 0 0 0 0 0 N/A 6630 Audit Svs - Review of Prg 0 0 0 0 0 N/A 6800 Public Information 27,363 0 0 0 0 N/A 6840 Rents/Lease-Bldg/Imp 835 0 0 0 0 N/A 7022 Pubhc Relations 121,682 165,000 165,000 165,000 0 0 00% 7206 Equipment Usage 10,688 0 0 0 0 N/A 7247 Water Conservation 208,609 360,000 360,000 380,000 20,000 556% 7250 Reimbursable Projects 0 0 0 0 0 N/A 7302 Travel Expense 399 0 0 0 0 N/A 7303 Private Car Expense 1,709 0 0 0 0 N/A SUBTOTAL 1,651,237 1,515,000 1,505,000 1,510,000 5.000 0 33% Other Charges 8010 Contribution to Non -County 0 67,347 0 0 0 N/A SUBTOTAL 0 67,347 0 0 0 N/A • PRIOR YEAR ENCUMBRANCE EXPENSE 9650 PY Eric - Profess/Special 14,284 0 0 0 0 N/A 9700 PY Enc-Special Dept Exp 127,312 0 0 0 0 N/A 2/142012 4'30 PM 4+ SUBTOTAL 141,596 0 0 0 0 N/A TOTAL EXPENDITURES 1,792:833 1,582,347 1.505,000 1,510,000 5,000 0133% Outstanding Encumbrances 126;491 • Change in Windsor Reserve 10,425 (109,742) (105,134) Audd Adjustment (65,854) IENDING,FUND BALANCE 104;246 29,262 31,762 • 2/142012 4:30 PM M FY 2012-13 BUDGET CHARACTER JUSTIFICATION Department - Division: Sonoma CountyWater,Agency Water Transmission • 'Section Title: Water Conservation Character Title: Use of, Money and Property Character No.: 675744-17 1700 Interest on Pooled Cash, this account records interest on pooled cash held for the Agency by the County Treasurer's office. Estimated interest is projectedbased on cash on hand and current interest rate trends Estimated Average Cash Balance 500,000 Projected Interest Rate 0,50% Projected/Planned Interest on Pooled Cash $2:500 Character Title: Intergovernmental Revenues Character No.: 675744-20 2912 Town of Windsor This item records revenue earned from the Tow_ n of Windsor for water diverted from the Russian River using the Town's equipment Restructured Agreement 4 17b Character Title: Miscellaneous Revenues Character No.: 675744-40 4303 State Grants This is for an anticipated Grant from CA Dept of Water. Resources Character Title: Other Financing Sources Character No.: 675744-46 4625 OT - W/in Special Dist - BOS This item records transfers of funds from the O&M fund to provide for planned expenditures $1,510,000 Character Title: Services and Supplies Character No.: 675744-60 6523 District Operation This Rem is requested to provide for the charging of salaries, benefits and overhead costs for staff assigned to projects budgeted within the Water Conservation Fund. Water Conservation, Water Education and Public Affairs Staff' • 755,000 Water education Seasonal Staffing 80,000 Prop 84 Water Conservation Grant Administration 60,000 L$ Moil 6536 Business Environmental Alliance 2319-22, 7190 Agreement with the Economic Development Board 50,000 t. $; 50;0001 t 6570 Consulting Services 0 0 6584 Trade Shows 7189 0 Sonoma County Fair 20,000 L$_20,t 00J a 7022 Public Relations 7189 0 Public Information and ACWA Campaign 165,000 C$-_116571000j 7247 Water Conservation 0 School Education Program 280,000 QWEL English B. Spanish 15,000 Seminars, Workshops, and Training 15,000 County Children's Museum 25,000 Wholesaler Support 20,000 Green Business Program 15,000 English as a Second Language Curriculum Program 10,000 L$ __.A6i Character Title: Other Charges Character No.: 675744-75 • I 6010 Contribution Non -County Governments This item is request to pass DWR grant monies through to other governments $0 2A 412012 430 PM FY 2012-13 BUDGET SONOMA COUNTY WATER AGENCY Operations and Maintenance Rate Computation O & M REVENUE; REQUIREMENT ESTIMATED FISCAL,YEAR 11M EXPENDITURES LESS:' Dep rec i at io nAm o rtizat i o n Investment Income,Interest on Pooled Cash, Charges for Services Power Sales PWRPA Pre -pain Expense - FY 08109 Rate Reduction -One time only "Mandatory Prudent Reserve" charge_ Recycled, Water funds (Sub -object 7277) taken from special reserve Transfers Out REVENUE' REQUIREMENT (Net Expenditures) O & M ACRE FOOT BASE AVERAGE DELIVERIES - PAST 12'MONTHS LESS: Marin Municipal Surplus (Irrigation) TOTAL BASE DELIVERIES O & M RATE COMPUTATION: $37, 521,689 5,829.000 50,250 800,000 0 0 10,15T493 $20;684,946 Rate = Revenue Requirement - (Marin! Muni Off, Peak' Deliveries x Highest Prime Rate) - (Marin Muni SurolusAelivedes:x (O&M Charoe + Caoital Charae) Total Deliveries -'Surplus Deliveries - Marin Muni Past 36 Months Deliveries = 20.684.946 - (4.300.00 x 609.34) - (.1.113.30 x 528.011 45,960.6 - 913 - 5,413.3 * = $432 01 0 45,960.6 5,413.3 • 92.3 40,454.9 C 211412012 4:30 PM REVENUE BOND I STATE LOAN CHARGES -WATER RATES AND ESTIMATED REVENUER FOR FY 12-13 A ANNUAL DEBT SERVICE REQUIREMENTS Sonoma 'Common Watershed Plan Water) Storage) Pipeline) Faci dea Restoration Conservation F.b Facilities 2003 A Revenue Bond 611414 $24,138 TED TSD 875462 $18�,500 '675d70 $id9,800 251,600 FISCAL AGENT FEES DEBT ISSUANCE COSTS 3,951 2,622 2,320 DISCOUNT/BONDS 446 319 262 lore)lntlividuel Blood 466241I 346654I 238.3551 Bond Reserve) 0I I Total Individual Bond Debt Service 600,180 0 367,683 294,056 2006 A Revenue Bond 676496 676488 PRINCIPAL $117,916 $132,085 INTEREST 225,068 252, 112 FISCADAGENTFEES 2,300 2,500 DEBT ISSUANCE COSTS 4,085 4,576 DISCOUNT/BONDS Total Individual Bond Fermi 34SW9 1 358 Bond Be.,,1 52,405 I I I 691 0 Total Individual Bond Debt Service 401,774 aaii 0 2012 Santa Rosa AO Capital Fund Loan PRINCIPAL 55,465 ,INTEREST 124,710 FISCAL AGENT FEES 0 DEBT ISSUANCE COSTS 0 MSCOUNTARONDS 0 Total lndiNduel Loan Payments 180,181 0 Loan Reserve 0 Total lntllvltlual Loan Debt Service 180,181 0 2012 Petaluma AD Capital Fund Loan PRINCIPAL 67,791 INTEREST 162,430 FISCAL AGENT FEES 0 DEBT ISSUANCE COSTS 0 DISCOUNTIBONDS 0 Total Individual Loan Payments 220,221 Lee, Reserve Total lntllvltlual Loan Debt Service 220,221 1 09/10 Flnancmd Em for Common Fac mG above Mirabel TSO - Water Ed TBD- Oakmont umh mice. ealahoommi Generator, TED - BRIER Bldg Pipeline PRINCIPAL 282.562 • INTEREST 14 43,146 FISCAL AGENT FEES 0 0 DEBT ISSUANCE COSTS 0 Total Individual Bond Paaymentts 325,700I 0I 0I 0IRtsn. 0 Total Individual Financing Debt Service 326,70E 0 0 0 0 SRF LOAN 676439 PRINCIPAL 672.033 N A NA INTEREST 368,200 N A N A USE OF SEE LOAN FUND BALANCE: 675439 Reserve Ralansi mint 156,035 Total SRF Debt Service 1,196,268 SRF LOAN RESERVE 675447 RESERVE 119,627 NA NA Total SRF Debt Service 1,316,89511 TOTAL DEBT SERVICE I $2,943,959 $0I $0I $807,647 $294,056 LESS REV. FROM N MA RIN REV BOND CHARGES $315131 REMAINING REVENUE REQUIREMENT $2.628,828 1 $0 ( $0 ( $807.647 1 $294,058 1 Br CALCILATirll OF WATER RATES FOR FY 12.13 Sonoma Common Watershed Plan Water Storage Pipeline Facilities Restoration Conserval Fauhties Facilities Debt Service Debt Service Debt Service Revenue Bonds Revenue Bonds ChaFoe Charge 'Charoe Charge Charoe ' REVENUE REQUIREMENT $2,628.828 $0 50 $807,647 $294.056 APPLICABLE BASE WATER DELIVERIES IN A F 34d417 45,8583 45,8583 34,441.7 4,3050 CHARGES PER ACRE-FEET $76 33 $0.00 $0 00 $23.45 $fib 31 C CALCULATIONS OF NORTH MARIN REVENUE BONDS CHARGE REVENUE REQUIREMENT FOR COMMON FACILITIES DEBT SERVICE' 2,543,557 N. MARIN'S SHARE (REV REGMT FOR COMMON FAD DEBT SERVICE % (11 2/90 4)) 315,131 ESTIMATED WATER DELIVERIES TO NORTH MARTIN (IN A F) NORTH MARTIN REVENUE BONDS CHARGE 6,013 52 Common Facilities 'North Mann exetcieed option for cash payment Total Debt Surma - 2,543.557 of Aqueduct Loan funded projects N Mantis Shore H1.21904) 315.131 Total Revenue Required $2,943.959 Estimated Water Deliveries tart. Mann 6,0132 Less Aqueduct Loans (400,402) Applicable potion of the N Mann R Bonds Charge S6241 Revenue base for NMWD $2,543.557 2/14/2012 4 30 PM 51 SONOMA COUNTY WATER AGENCY RUSSIAN RIVER 6ONSERVATION CHARGE,C6MPUTATION • FISCAL YEAR'2012-13 PROPERTY ASSESSMENT VALUES AS OF'FY'11-12: TAX CODE ENTITY SECURED UNSECURED TOTAL VALUE 14000 Forestville Co Water District $308';546;065 $4,397,'481 $312,943,546 42800 City of Cotati 808,720,683 16,491,973 825',212,656 43500! City of Petaluma 7'113,916,314 329,7771166 7,443,693,480 43800 City of Rohnert Park 3,656,156,306 107,758,749 3,763,915,055 44500 City of Santa Rosa 16,979,374,646 657,091,122 17,636,465,768 45000 City of Sonoma 1,879,343,524 63,204;228 1;942,547,752 Valley of the;Moon Water District 2,365,864;261 17,064,944 2,382,929,205 TOTAL $33,11'1,921;799 $1;195,785;663 $34;307;707,462 Notes: 1 Total value ofsecured and unsecured property in service areas of Prime Water Contractors of Sonoma County (see above) $34,307,707;462 2 2011-12 Sonoma.County tax rate per $1 00'of'full cash value assessed for payment of Warm Springs Dam Project Obligations 0:067 3 Total tax levied on citizens residing in service areas of Prime Water Contractors of Sonoma County, i.e., (Line 1/100) x Line 2 $2,401,54t, 4 Total acre feet of water delivered to Prime WaterContractors of Sonoma County (excluding North Marin and Town of Windsor) plus deliveries to Forestville 33,319.75 during the last '12 month period' 5 Total Russian River Conservation Charge per Acre Foot (Line 3 / Line 4) $72.08 Russian River Projects Charge H i stori ca I. calcu lations For FY Calculated 00-01 5.8 01-02 5.66 02-03 6.15 03-04 14.93 04-05 19.18 05-06 24. 3 First FY with 10 full years of data. 06-07 17.02 07-08 21:4 08-09 25.08 09-10 24.68 10-11 24.4 11-12 23.44 12-13 20.38 �Z 2/14/2012 430PM • FY 2012.13 BUDGET Water Transmission SystemOperating Transfers Fund Santa Rosa Aq. Capital, Fund Petaluma Aq Capital Fund Sonoma Aq Capital Fund Sonoma Rev Bond 2003 Fund Storage Rev Bond 2003 Fund Storage Rev Bond 2006 Fund Common Rev Bond 2003 Fund Common Rev Bond 2006 Fund State Loan Debt Service State Loan Reserve Capital Lease Financing Agency Fund (Discretionary) Agency Fund (Charges) Pipeline Facilities Storage Facilities Common Facilities North Mann Water Management Planning Watershed Planning /Restoration Recycled Water & Local Supply Water Conservation Total Common Facilities OT - in'4625 From Water Transmission (discretionary) Water Transmission (Charges) North Marin 2003 Bond Fund 2006 Bond Fund Aaencv Fund (Chances) OT - Out Santa Rosa Aq. Capital Fund Petaluma Aq Capital Fund Sonoma Aq. Capital Fund Sonoma Rev Bond 2003 Fund Storage Rev Bond 2003 Fund Storage Rev Bond 2006 Fund Common Rev Bond 2003 Fund CommonRev Bond 2006 Fund State Loan Debt Service StateLoan Reserve Common Facilities Water Management Planning Watershed:Planning./Restoration Recycled Water'& Local Supply Water Conservation • Index SOT-Out(8625) To 675207 1,919,000 Pipeline Facilities 675215 290,060 Pipeline Facilities 675231 0 675470 325,000 Pipeline Facilities 675462 240,000 Storage Facilities 675488 500,000 Storage Facilities 675454 400,000 Common Facilities 675496 250,000 Common, Facilities 675439 0 675447 0 675371 0 675108 1,608;800 Common Facilities 675108 10,157:493 675413 675405 675421 0 675512 1,240,876 Common Facilities 676716 575728 675736 675744 16,931,169 1,608,800 325;708 1,240,876 400,000 250,000 3,825,384 211,890 71 207,512.01 72,229.99 294,056.15 357,683 35 449,963 95 500;179.85 401,774 35 1,196,267 95 119,626.80 325,708.00 50,000 3,725,600 735,000 '1',510,000 10,157,493 Beginning Fund Ending Fund OT In (4625) Balance Balance 211,891 $ 207,512 $ 72,230 $ 294,056 $ 357,683 $ 449.964 $ 500,180 $ 401,774 $ 1,196,268 $ 119,627 $ 0 $ 0 $ 0 $ 2;534,000 $ 740,000 $ iT W3- -tt3 T $ 0 $ 50,000 $ 3,725,600 $ 735,000 $ 1;510,000 S 5,549,241 4,897,605 50,731 463,812 360,468 534,554 365,286 229,885 407,500 31 4,809,240 87,758 $ 70,536 $ (621,851) $ 12,633 $ 81,279 $ 152,932 $ 293,704 $ 29,262 $ 16, 931,169 17, 774, 546 915,707 1,232,820 123,611 181,779 171,388 99,321 35,924 37,125 567,035 Increase (Decrease) $ (4,633,534) $' (3,664,785) $ 72,880 $ (282,033) $ (189,020) $ (435,233) $ (329,362) $ (192,760) $ 159;535 31 $ 5,664,176 $ 90,258 $ 71,786 $ 74,255 $ 12,718 $ 87,630 $ 412,327 $ 296,204 $ 31,762 $ 10,105;858 0 854,936 2,500 1,250 696,106 85 6,351 259,395 2,500 2,500 (7,668,688) 2/14/2012 4:30 PM FY 12-13 Proposed Water Rates FY 11-12 FY 12-13 (Actual) (Proposed) 0 /O,Change O&M Charge 439.64 432.01 -1.61% Water. Management Planning Sub -Charge 4.18 1.09 -74.0% Watershed Planning/Restoration Sub -Charge 54.56 81.06 48.6%o Recycled Water Sub -Charge 18.13 15.99 -1-1..8% Water Conservation Sub -Charge 31.45 32.85 4:5%0 Total O&M Charge 547.36 563.01 2;9% Santa Rosa Auued'uct Rate E O&M Charge 547.36 563.00 2.91% Aqueduct Facilities Capital Charges [4.6 e] 0.00 9.25 N/A Storage Facilities Capital Char9e,[4.7] 23.09 23.45 1.6% Common Facilities_ Capital Charge, [4.8] 63.70 76.33 19:8% TOTAL 634.15 672.03 6.6% • Petaluma Aqueduct Rate O&M Charge 547.36 563.00 2.0% Aqueduct Facilities Capital Charges [4.6 e] 0.00 9.25 N/A Storage Facilities Capital Charge [4.7] 23.09 23.45 1.6% Common Facilities Capital Charge [4.8] 63.70 76.33 19.8% TOTAL 634.15 672.03 6.0% Sonoma Aqueduct Rate O&M Charge 547.36 563.00 2.9% Aqueduct Facilities Capital'Charges.[4.6 e] 0.00 9.25 N/A Storage Facilities Capital Charge' [4.7] 23.09 23.45 1.6% Common Facilities Capital Charge [4.8] 63.66 76.33 19.9% Aqueduct Facilities Capital Charges [4.6 b] 69.22 68.31 -1.3% TOTAL 703.33 740.34 5i3.% • 2/14/2012 4 30 PM P FY " , •Water Transmission System Budget Et Rates Lynne Rossetti Michael Finance Et Accounting Mgr Assistant General Manager OTOWITIOWITIGM www.sonomacountywater.org I Propo,se,d.FY 12-13 Rate Changes 2� 1% .56% �.23 6% 0 i ,r Rate Setting Catcutation Cost of Operations and Maintenance Cost of Water Water Sold (Dollars per acre-foot) Water Sold = Lesser of Average of last 3 years annua.. deliverieswater Last 12 months or of actual water deliveries �4ATER Primary Factors Affecting Rate Increase %�Y <. �.L. 1 w•iw ..�<.' r ..:S $'% �. :r ' . 1 �-.k.-an .' _ ".K't . � � i4 *,._';t'- +r3i:"' i;r' •.ftj# � Jr..,' Z_.- _ � ' .Mt P:.`- - z' Op ` Increarse.to` Vllatershed.• Plafth'Tng ;Rest (tB..O.) +4 '4% N,e:tY R:eduction:in,Oth:er.-Ex :en - 2.0� _ .__. -, -.>_ .:.......-r;_a_,w.xz_ � �. ._.:<•-r.:d?.: _ ram... " ,s`e _ - =:5�;. -- ... -�•:,�� _ - - ,. - *Note: 45,961 Ac Ft in the Prior 12 M'ont-hs vs. 47,848 Ac Ft used in the 2011-12 rate calculation WATER `. l Major Factors of Reduced Costs: ®Labor @ Powe r ®Chemicals Sz Of * •1 090 water Mgt P\an &. RestOrat�or watershed P\a�n�r\g water Recye\ed water �Orv5erJat�or d aX)d \-Oaf\ Charges 3? g5 �556,p1 99 ? 8 $655 �9 ncrea5e fr0�' F`�1112 C),25 6.99 i �ota� 09LW Go�`�00 go' UtUCI protects Sp°fie cOr�tractOrs \d fund ba\ance {Or fi bu} t0 . ns �ap`ta\ cOntr\bu�ater Tier 2 program c\ed \_Oca\ Recy ct�T dates tit-12 \r tv,a prune 5°now r baSNtRAc- fog S �toTA PRIME CO $67�'p3 5.9$% Fv 11.12 0 Water Agency Rate Changes and Deliveries 30.00 25.00% - ------ ------' - N OA 20.00% s U v 15.00% 13.0 M Y {Q),) 10.00% N a 5 00% 0.00% 2009-2010 2010-2011 65,000 60,000 H LL 55,000 U a v •L 50,000 � 0 45,000 40,000 2012-2013 Santa Rosa Aqueduct MMM Petaluma Aqueduct -----Deliveries in AC FT si.�iini,n' tv ATERi '..��_' 1. 0 'mr,ad *61 M or Fish Screen — Fish LaddierProoect wReplace existing Fish Screen -Fish Ladcl�e.r eStatO grant offsetting design costs. 0 0 a • New valves have stainless steel bodies & Teflon i,nner parts Air -valve venting above grade Petaluma � 6 Aqueduct rctec i il ,1 ® Extend life of corrosion protection of pipes ® Install deep anode wells in strategic locations ® Acquire ROW and easements 1WA'TCR 5 0 -ion by Water AdvisOrY, Committee endat eRecomm March 5 (This will require a special mee, Board of Directors — by April 30 .p ad by the . � FY 12-13 Water a ? .s F • } �F 3 i�} F�f t Rates i ei m l• ',iEt 1 Admin Division Manager � � a. , a i • RMUMENOM Finance Et Accounting • I rosse l i scwa e ea . gov 707-524-3771 www. sonomacountywater. org michae @sc a4cam ear