The URL can be used to link to this page

Home My WebLink AboutPresentation 02/27/2012 Presenatto-w • 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: t`,Chaige,/Agiieductt,." ' +„ h 'x ,Santaftosai " ;Petalumat °'4Sonon aY 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 FY 11-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-12 Budget 5.98% 5.98% 5.26% • Water Transmission System Fund • ▪ 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 watersales. 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. • Expenses Expenses for operations and maintenance, capital improvement projects, and main sub-funds are as follows: FY 11-12 FY 12-13 Budget Requested Change Operations and Maintenance $19,990,500 $19,623,250 ($367,250) Capital Projects $3,788,000 $13,261,000 $9,473,000 Water Management Planning $200,000 $50,000 ($150,000) Watershed Planning and Restoration $2,610,680 $3,725,600 $1,114,920 Recycled Water and Local Supply $947,500 $985,000 $37,500 • Water Conservation $1,505,000 $1,510,000 $5,000 Totals $29,491,680 $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 • Air Valves $541,000 • Billing Meter Replacement $400,000 • Mirabel Surge Control $200,000 • Russian River Crossing $405,000 • Mark West Creek Crossing $554,000 • Collectors 3 and 5 Liquefaction Mitigation • Water Agency Westside Facility Predesign $220,000 $1,200,000 • Collector 6 Chlorine Solution Lines $25,000 • 2 FY 12-13 Prime Contractor Rates Summary CHARGE PER ACRE FOOT: Santa Rosa Petaluma Sonoma Aqueduct Aqueduct Aqueduct O&M Charge [4.2] $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 I 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 I $672.03 $672.03 $740.33 Increase from FY 11-12 5.98% 5.98% 5.26% 2/14/2012 4:30 PM 3 0_ a O co N O N 0 N Cd N U (n Z W 0 co m r 1— N (P O co N N co co V H co co V' '— N V co Lf) V' a) 7 M cc O O M V N (O ni N V V N M cv co to V- Nr 2 D N- Or CO CO 7 7 7 V' d' V co co M 00 Z H O OU 0 0 W Lu F CO K • co CO ZU (n U CC H — W ZO d< a 0 co Cn W H H M .- m CO O O (0 CO O N UU, QU o � rnr � I� (y co (n aomoco ix O 2 0 Ni CO M (O r N N (yi Ic V N. CO O CO (p LO M N O) N CM z = W J 0 CO CO CO CO N V V V V V co co co Q U H D CC w d a a woo • co H LL. a cc u_ 0X N — W >- ° 0 IL H (h - N N O O O N ^ N ((0 (O a0 V N N-cNi Q _ N- CO 0 (0 N- V CO N O 00)) CO W N CO CO CO 0 V 7 V V' 7 co co co co Q CO N r O W CO I— (O (0 V Cr) N x 0 0 0 0 0 0 0 0 0 N \ O O) CO I CO (1) V CO N r O r- 0 0 0 0 0 0 0 0 0 0 O 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N. N N N N N N N 5 0 _ o 0 0 0 0 0 0 o a o N O O CO I() CD .- )0 Co Cr) O C LP co ID U) N 4 N V )(] N 6 0 c U N Q)a 0 0 CO N N 0 CD co v ccoo v N U)) rn C IO co co r O N V CO tD Cu r to 69 69 69 EA 69 69 H) 0 0 0 m 0 a a) CO Co co V 7 co co (D V N M 0 0 r r a 0 M U) CD co N O H , -a LL CD CO N- N- O r CD O CO CC N O N M c Q >- 00 0 W 2 LL o_Q H C Q LL A (n CO a c00 CD 00) co OM) Z L. N 0 co Co O 00) 00) M CO am 7 ri )Of) O _ N LL O CD I'- CD N- N- CD CO CD N 0 N N 69 CO } LL' 0 CO (/) LL Q 2 W "' CO D • Z Z V M 0 0 M CD N. 00)) 0 O d ti O O O M M 47 LL') O Q W U a O f` O .c r ir LL] W Q 7— Co ct CC CD W e) M D Q N r co ) r y > LL LL -0 LL 0 C) 0) a co C W -6 CO 9 — o t ° n 0 CD -a O" 3 (0 N N 0 N J Co O -J f0 Q Q 0_ 0) 'C E' < 2 2 N Q D N CO C _C LL C UI N N 5 O o E co o 4- 2 C a N w co 1— II— LU co co C y C f0 (n N .c o w LL z LL • IN m >- >- r Y a O N TS' a a m j U E.' � `o U) LL c W a U Z a a < a CO a s m m 2 EP D tiii LL $3�a�+`H To 2 ` , m 6*� ,,• a co 0 r . 4 3� ' tip g m Y, z �r 7 E 3' �' t+'"" w*l z �._�p ? u .,z; 'tY7 5 m -Oa LLI a W C _ you. rah; 'WY,-sb » ,a r # " a .rr r ¢ U " � � a z '^" c -o LU 4.,44R r3' a+20- 1<,°'u ..c at .-.t:n .41...a]n.1,_A$8",a.n.'uY4 _,., .} ii 0 Z " 2 LA ici > Z . 2t'1 at 2 ,. , . o U z z co W o o t° �c y +u s�. A m fly. ,.}% V Y t{, .. ,a Mrvdi�.+w i. }a.J�.Y%n M$� n�k � LL •! "^ s;°xie > r�°A .4,.c" �� ` » "s»z.�fi z.-.? !_.at,..V_..» ._...sue s..a''...a .. .tea:?,,,..:.,... 3 a o a 0 0 0 0 o a o 0 0 0 0 0 o o a 0 a 0 0 0 44 6 (X I ESTIMATED (]OFFICIAL CHARGE PER ACRE FOOT: To Be Approved by Board of Directors on April DD,2012 Santa Rosa Petaluma Sonoma Aqueduct Aqueduct Aqueduct PRIME CONTRACTORS O&M Charge[4.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] $15.99 15.99 15.99 Water Conservation Sub-charge[4.16] $32.85 32.85 32.85 O&M Charge $563.00 $563.00 $563.00 Capital Charges-to build fund balance for future projects Aqueduct Facilities Capital Charges[4.6 e] $9.25 $9.25 $9.25 Bond&Loan Charges-to pay for existing debt service Storage Facilities Capital Charge[4.7] 23.45 23.45 23.45 Common Facilities Capital Charge[4.8] 76.33 76.33 76.33 Aqueduct-Facilities Capital Charges[4.6 b] 68.31 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 CUSTOMERS/WHOLESALE CHARGES (WATER CO'S&PUBLIC AGENCIES) O&M Charge 5563:00 $563.00 $563.00 Capital Charges 99.78 99.78 168.08 Aqueduct Facilities Capital Charge 5225.62 $225.62 $157.31 TOTAL OTHER AGENCY CUSTOMERS/WHOLESALE CHARGES(4.12) S888.40 S888.40 $888.40 (120%OF HIGHEST PRIME) FORESTVILLE O&M Charge[4.2]' $432.01 Water Management Planning Sub-charge[4.13) 1.09 Watershed Planning/Restoration Sub-charge[4.14] 81.06 Recycled Water&Local Supply Sub-charge,[4.15] 15.99 Water Conservation Sub-charge[4.16] 32.85 O&M Charge $563.01 Bond&Loan Charges-to pay for existing debt service • Aqueduct.Facilities Capital Charges[4.6] 0.00 Storage FacilitiesCapital Charge[4.7] 23.45 Common Facilities Capital Charge[4.8] 76.33 Total Capital Charges $99.78 TOTAL FORESTVILLE $662.78 'Forestville Water District exempt from Santa Rosa Aqueduct sub-charge from FY 06/07 to FY 16/17 [4.12]. NORTH MARIN WATER DISTRICT O&M Charge $563.00 Note: N. Marin does North Marin Bond&.Loan Charge[4.9] 52.41 not pay an•Aq Russian River Conservation Charge[4.18(a)] 72.08 Capital Charge. Russian River Projects Charge[4.18(b)] 20.00 TOTAL NORTH MARIN-WATER DISTRICT 707.49 THIRD OFF-PEAK(MARIN MUNICIPAL) Highest Prime $740.33 Russian River Conservation Charge 72.08 Russian River Projects Charge 20.00 TOTAL THIRD OFF-PEAK $832.41 SUPPLEMENTAL.(MARIN MUNICIPAL) O&M Charge $563.00 Capital Charge[4.11 (b)] 96.00 Russian River Conservation Charge 72.08 Russian River Projects Charge 20.00 TOTAL SUPPLEMENTAL $751.08 SURPLUS Non-Municipal!Municipal[4.11 (a)] $675.61 $675.61 $675.61 (120%of O&M Charge) 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 06/07 to FY 21/22[4.17(a)], Town of Windsor pays all subcharges[4.13,4.14,4.15,and 4.16)on all-water they divert from the Russian River using their equipment[4:17(b)]. The applicable section of the Restructured Agreement has been indicated in brackets. 2/14/2012 4:30 PM q • SCHEDULE OF WATER DELIVERIES BY AQUEDUCT PAST 36 MONTHS/ 12 MONTHS AVERAGE DELIVERING AQUEDUCT Monthly Santa Rosa Petaluma 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,270.1 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,458.4 49.7 756.6 5,192.2 31 Jul-09 1,664.3 1,988.5 49.5 672.7 4,375.1 30 Aug-09 2,065.7 2,256.5 56.4 673.9 5,052.4 29 Sep-09 1,867.7 1,880.7 49.2 603.3 4,400.9 28 Oct-09 1,057.5 1,604.8 29.7 606.3 3,298.3 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,363.2 25 Jan-10 928.4 1,781.2 19.8 432.1 3,161.5 24 Feb-10 1,000.7 1,754.1 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 863.0 4,852.4 19 Jul-10 1,914.8 2,156.8 45.1 886.9 5,003.6 18 Aug-10 1,934.1 2,616.2 54.9 1,077.9 5,683.1 17 Sep-10 1,560.0 2,158.2 47.3 916.7 4,682.3 • 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,188.7 1,982.0 23.7 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 19.3 424.2 2,697.1 10 Apr-11 1,044.8 1,295.4 21.8 516.5 2,878.5 9 May-11 1,722.0 2,407.1 36.4 954.1 5,119.6 8 Jun-11 1,331.5 1,883.3 32.5 747.8 3,995.1 7 Jul-11 1,503.0 2,218.8 39.4 922.5 4,683.8 6 Aug-11 2,204.3 2,676.0 55.1 935.9 5,871.2 5 Sep-11 1,323.5 2,206.3 41.7 844.9 4,416.4 4 Oct-11 784.5 1,557.1 29.3 680.6 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 1,172.8 22,866.3 143,030.5 3-Year Annual Average 16,183.1 23,480.7 390.9 7,622.1 47,676.8 Past 12 Months 15,349.3 22,433.7 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 Mahn 19,932.8 19,932.8 Marin Municipal 18,470.1 18,470.1 Sonoma Co. Deliveries 48,549.3 32,039.2 1,172.8 22,866.3 104,627.7 3-Year Annual Average 16,183.1 10,679.7 l 390.9 7,622.1 34,875.9 • A-6 2/14/2012 4:30 PM Um 0 N N M V r V T N. a N N O a m O r N M m O a CO D J M N M 7 r O M 4 f O r r U V N O . O M N O U N O Q co V - co r N N M N M N r N- r N- M to m <D N 4- O LC) In o O N a CO r co m V ca O r I- co-M r N N <0 V N• r In co m O <D a) r r- 4 V CD O N O M a co co N V N O O m M O M O m O O O N- N M O r a co. O O N N N a Q co 4- fl N N co O N co r r co N N N r N CO O N O O V N N W N D r r O co M co N O D N M LL) O O U Ni r N t m r 6 6 co O M 4 O N- O O O M M O O N N N W N IO Lo N N M r r P r r N N 0) <0 N ❑ r M cO - N O V <O W M O r F- m V O V N N O co I- O M O N r <O M <O N O.N N N) M O) M 4 tO O m O O O M O O O N M M co I- N co co M <O M r r N co M M 0 r lO co N r N N to CO Z r N M - m I- V uN i- N c0 O 0 co m I� M r N O O N r 4 O N CO U) H I- N M r <D,M O O N OM M W r 0 D O O O O r M IT) CO co � O N O M N r 0 O co C) N - - N M O 0 N CO r - O co If) U m r O N <O <D Ih O co O t0 0 00 N O . O co I. V H 0 r r m N co r o M NOM O O r m M co 0 : O co O V co <O < r N CO V r 4- a r a. co I-- r 0 N N 0) r M V _W 0 r co' V ✓ O r r co co co <O m I� N Cr) <O co r 4. 0 t1) to N r O <n M N CC r W O V O m N r M m O I- V N N O O O O O r p D N r 0 O N N m O m m r co W D M co cO N N r. 4- 2 Q N r N O 0 H Cl) r m <O m N co N O O M m N o N M O M co V O r M W O M O O O O co co r A N m O O O O r 4 N V O 6 m M U N N V O N N a r V c0 co 0 co <D M r c0 CO } r 7 a H W r to m M <O co m co N- to r O a O N O O N N- r O M t0 W Z O r. O r 0 0 0 m 6 co O O MOO r a N O M m 0 L_ O N 0 m N 0V r co 0 ❑ c0 r r U r CO m W -) r CO CO 0 Z 3 N r O r M O t0 0 - M m N. 0 m M O N 0 N co O co O O 0 O N O O N M O cf O r r O MOO r O N r O O - m >- Nm r N r CO r r co Q Q m ,CO a N N a a r LL j 2 r V m W> N r 4- N O 0 0 O « r Q) 7 M N m r 0 to V O N O m 0 0 N <o <0 M 4- M O a O V O O O O Ni N D O r o W W N o N M d' 0 M a_ cq co V N r r N 0 M t- ❑ 0 Q r N N W Q) 0 I- p r 0 m y O O N- co O Cr) 7 r m N V r O O Ni co N O N _ Z a U O r 0 O r V m N O '- O N O m 0 0 0 t a O O r r r LC I-- V O 0 N co I- N 0 r r V m m Q O CO N N r V co r^ 2 r N N V _ ¢ H Z r _ LO I- O m CO CO CO V O r N- LO N O N O U? r N r O m 0 co it O r r h V O V t- O m IC IC O O N O N 0 0 0 cc V O O O r O W cc m O co co N N 7 CO (Ni co CO CO W W r co M N r [I CO to O QN co a r N W CO a W i H O U O U .� a• H c U W H w Q W It U) o- H I- a N �; cc m o U o.U W w ¢ o- CO Z C7 co U a E r U` O 0 o m ¢ 0 w H o m a o o <n U U a re oQ Ha E ED E CC E w co , W Z Yl N. s N c m C a D co (n co O J W Q = m = > w ._ -o E • W ?> > o m 00W 02- w c m c a > 0 a H m c c m >c_ o o c — U Ul a CO S <_ U <a a) o a' J O r m 0C) o o > U - a Q � > aJ -0 = 00 00 o O C o <n co a W co wr <n r/Ja � KU orn o J � --o o 0 o "� 0 U` U` J W o 0 0 � ❑ v ° ° s o o c o aTi.Q W :=v °)'0 3 w a`) v m Q a c a c c@ Q Q O ❑ T >t T T T_ • I- . C ?i C 4) L_ L_ L H a "1. a m o) m H H Z Wj a) a0UZ00H0 > H OJaJY U. 000H 02 � - _ O H O = Z <n Q < Z r N N N N r .7 a r N V V M r N V N r N V I1 CO ro N O O O O w CO LO CO N CO N CO O 0 0 CD w w W F 7 (O m O N O N F = O 4O LLO O O S W O r N � 0 2 W CV(0 1-0 O LO, O 2 > N O P W r N F w » t Ell o K W ce , V O) (0 0) (D — O V CO 0 (O 0 0 0) CO N N � O N V Co r M V N (D LC) LC) U1 CU (a 0 O W � aF ¢ aF Q 3 � a Z () N � N w z = W W Q c Z 7 O w LL T co a . 0 LLl 'a F— C J G W 07 Q co V Q o C7 Co ( 06 O O O . D (0 CO (0 O O O O O O N. (D CO O CO D D E N N o � rn D v a) M m m a) m a):: WwW v v � WwW id v c) v v m T k C) a LL W ^ a LL W el (/) a) 2w > .- 2w > r C Q -R1 P C V F C •cl N Q . W a W ^ W a ❑ N E W N v u>-.. m -~ I— J• O ,_ W -a 4-) O ) V Lo UJ 2 r a m Q 08 a o o s O) U v m a W o< W >- .c .0 co =-J co F- 0 Z < 0 u CO a a w 0 _o Z CC Q W N W V) 0 a CO LU r0 c N J LU a) 2 d LL H a C W U °' O ii. 0_ < 0 E o V) K W @ H LL D 3 w C (0 a F =W Z U D J J0 Z d D n a Cf) 0 J J O) m w d a OO E c m J U w L re Z U U F K O a) m a) 1-- o j m n @ w O a7 L U F O D D 3 0 C 75 W ( aai U co ES Z Z -I CO - _ _ _ J a U aJ m d m m y 2 w N a o w re W w m d -0 C r- N CO V (D F • 3 3 12-- • Q �. 0) co CO co r 0 o] M CO O N 0) 1 W W O W'W (0 N CO N (O IL W O) O ul -Cr 'F 7 F.7 (o c )ri `v o F 7 w t- Ci ui ° a W o a W N N 00 O a W • > (0 > ,- N - > r O N I- w P e f w - N co re wIr co re W - W W v N H i) o w rn LEI (n IS) N o (a O O O m co N V 07 O N '- '- CO N O) (h (O O W r CO N N L C'Cr . 0 y H 7 O, W Z 0 0 I- W 0 D IL 47 H 0 H N Z O Q w < w ¢ a W Q > • K5'< Z Z re IP LLI CO co co w a J w Q 4 y 2 '6 a co W a0 W LL Q a- Q a U F 1— 0 C ca C 0 W OI 2 W co CO CO M CO CO Cr) co CO co co 0 a Q m ^ ci O) Q) m m ci m O) ci O) 0 C r V n V O V V V '' O V V V C - we co e- CO CO CO CO CO CO CO CO CO m r w W w W w"w.‘t ) W wW U)cr !r CO N .. 1- W X (p' F W Q' F W W T W U a LL W ^ < LL W a LL W N "a 1 2 w > r 2 w.> 2 w > a— C --I .Q F- R' J• W 9 Q N p w a r Q R 1.- CO3_1 co Q O^ F4J W Q D N N W ) R E 0 E Q N w LL O a H Q 0 m W 4 L 2 U crs /4 En C Q H N d C) V E." J IZ y 0) V O) m L C W En 0 0 a 0 O) L (4 j f0 CO ✓ Y m u U (0 N y v ° d o Z K C D a n K m u v m m O O a V) 0) V CO O a) m a) D5 2' a, 0 OI Ta ill 0 .1. I- I- V) a o. o) a I- CO W C m co 0 a m CO U 0 = 00 L o. C�' < U < c 0 cL) R < K U co Q U c C to w m a m' m Q w O w a m m. m = 7n 2 'a ra '. 0) Z W 2 a a to a co 3 Z m U a m CO N O W n w c c J 0 w y J U U 0 J > 0 > co m c., M :Cu Q > °) la- m m. .ami a Ct w CL Q K v m' `m Z H K = a) - w N CC Z O c a �i c W U 'co' u LL F Q N Q y y m U K m < a) o m < w r w 0 m i. L. a 0 Q N E N J J Z J m m o c 2 S `o E g a re w a W W m .0 ti -0 d Z • 3 f 3 CO S CO to 0 O CO CO N V I-- O CO W 7 (0 W 0) LO iii o N m WW (0 all o r W F. I-. 7 F'.7 v O o0 r 06 f. 7 r �O N to t0 0. Q,W t00 Q':W N co M n Q W N cp LO r V r- 2 > 0) -'> `-' N > H N N' V1wi co,W cc w N W 0,cc W W W 7 co N O ' (U LU If) co O L O O O 0 0 0) 03 N O CO O W N r r ^1 N O M 0 O .0 co co' M N N- U L Co N 0 C O ❑ ❑ w 7 Q:F err Ill Q Q F W K W W W W W J Q CC C7 7 W h. w LL F., c Q T Q ItF F U a C a m o W rn Z N- N N- N N r r IN IN IN N 0 Q q ,. ri n ri of ei ri r) ri ri M ri ri 0 E .CO t\ CO CO CO' CO CO CO CO CO (0 CO y ❑ Fo ° �. ❑ F ❑ v v v v v_ ❑ F ❑ v v v v 'Cr '7 r W Q W W.W N Q W W(lO N N N N N W W W N N N 'N N m T in CC, C.) Q w;W f0 < U. w ~ u. (X C"> CO > 2 Wr> •^- 5 w.> 2 w > r C .Q I- X"J �t H re;] F.. K J p J. Q w < 0 WUW w < ea • CVO .H 0 ' W Q ❑ ^ W Q ❑ W Q ❑ r N E CO a LL N U - 3 m o N W' z U co Co v c Q to a) in Sc v y En o _ J F V O a) .c C DI U a a 0 W 0) CO m a 1- Y Y t 0 <o �? > 0 � 0 a a U o s -0 o N w y o m CD W w CO O ?` 01 W N N O ;m N. CO U U. c o v lx 0 0 w 0 �' — :U Q W H W c o, N W w -Q 2 Q Z 0 z v a 0. N Q Z m U a -0 m co a w O W m J. C w U _J (° U U W > j > co N c D .,O J > .Q U y m J J = co 'a3 :d <o to N W O 2 in c a >. c 0 w � U m ;.LL H ca a)Q. Co J N N 0 U i 3 Q N C O. J F LU >m alall U Yl < a) L N FL 0 .I rx re LY Q Q H W W a) v d Z 3 3 ) m C- - • n � 2 0 . I rn �, la \ k� ~ ` / , _ \ ( , � : \ - ( \ � \ \ \ j ) ) ) O 111 / 0 § ® i- ° § kre \r . { \ \ \ m ] §u- IL »co tli - wk \ 2 I- § } $ 2 222 / § § ® 888 ® « « w w o3 tO§ k§ R « n £ w ) 2w > - 2w> § \■ • r $ j \ § « � « j § (§ § ) cc3wit � / q 0 IT � ® ) w § § o § u ( 0 _ _ _0 o cCC au O l) - 0 - - - a _K - / � - - - / { \ ( \ \ \ m \ 0 \ \ \ \ § f co § ) ) { § ) < / \ ) \ \ } \ « o \ \ ( m cc / ! w % � § ; & a ; C 0 0 FY 2012-13 BUDGET BEGINNING•AND ENDING CASH SUMMARY IIISection'Title: Water.Transmission System Agency:Fund Sectionllndex No: 675108. Actual Estimated Adopted' Requested Percent Subobject Title 2010-11 2011-12 .2011-12 2012-13 Difference Charlie BEGINNNGFUND"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,00 800,000 800,000 0 0.00% , 4040 Miscellaneous Revenues 15,959 0 0 0 N/A 4102 Donations/Reimb. 119,935 0 2,000 2,000. N/A 4109 Outdated Warrants 0 0 0 0 N/A 4161 Water Sales-O&M 21,044,169 20,178,53 22,911,950 21,137,480 (1,774,470) (7.74%) 4162 Comm.Rev.Bd.Charge 2,259,385 2,198,43 2,228,411 2,628,828 400,417 17.97%• 4163 Storage Rev.Bd.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 t 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%) 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 8,Local Supply Sub-charge 811,557 833,265 .867,500 735,000 (132,500) (15.27%) 4178 Water Conservation Sub-charge 1,542,147 1,445,460 1,505,000 1,510,000 5,000 0.33%. 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 38660,794 32,547,625 (113,169) (0.35%) • 2/14/2012 4:30 PM i% Section Title: Water Transmission System Agency Fund Section/Index No: 675108 Actual Estimated Adopted Requested' Percent SubobjecfTitle 2010-14 ;2011v--12 2011-12 2012=13; Difference Changer EXPENDITURES SERVICES AND SUPPLIES 6020 Clothing/:Personal 359 0 0, 0 N/A 6040, Communications 62,465, 75,00 60,000 75,000' 15;000 25:00% 6060 Food 0 0 0. ..0 N/A 6080 Household Expense 227 1;36 0 0- co N/A 6084 Janitorial Supplies 0 0 -1,000 1;000 N/A 6085 Janitorial Services 0 0 0' A N/A 6104 Fire Insurance 0 0: '0' N/A 6140. Maintenance-Equipment 695,788 765,00 1,024,00 1';200,000:. 1,76,000 17.19%, 6180 Maintenance-Buildings 75,853 234,00 234,00 '0 ;(2341000) (100.00%)' 6190 Landscaping Service 4,193 0:, .0 N/A . 6233 Maintenance-Proj Outside 0 0 '0 N/A 6262 Laboratory Supplies 23,711 25,00 20,00 25,000 ,5,000 25;00% 6280 Memberships 38;791 50,00 75,00. 77,500 2,500; '3.33'/0 6300 Miscellaneous 0 0 '0 N/A 6400 Office Expense 2,336 2,00 ''.2;000'. '2-,000 N/A 6410 Postage 2,744 3100 -1,000, 1,000, N/A 6415 Books/Periodicals 780 1;00 '1,000 1',000: N/A 6430 Printing 1,756 2,00 '1,000 !1;000' N/A 6461' Supplies]Expenses 54,443 55,00 50,00 50,000'. 0 '0.00%0` 6500 Professional./Special Svcs 0 0. '0 'N/A 6512 Testing/Analysis 116,513 135;00 155,00 135,000 (20,000) (1290%)' 6516 Data Processing Servies 256 5,00 5,000: '5,000 ` N/A 6522 Distract Services 660;889 0 0;, N/A%6523 District Operations 8,499,478 9,600,00 10,200,00 9,800;000 (400,000) (3.92%) 6540 Contract Services 0 15,00 30,000 30;000 N/A 6553 Contract Security Services 20,618 21,00 30,00 25,000 (5,000) ,(16:67% 6570 Consultant Services 290,581 450;00 1,101,00 1',,395,750 294750 26.77W 6589 Permits 0 6,00 6,000: .6;000, N/A 6590 Engineering Services 0 0 0 'N/A 6595 Feasibility Study 0 0'. 0: • 'N/A 6610 Legal Services 6,021. 25,00 50,00 50,000 0 ,0.00% 6616 Change of Venue 0 0' N/A 6635 Fiscal Agent Fees 0 0: 'N/A 6654 Medical Examinations 0 0, .`N/A 6706 Water Quality 0 0 N/A 6710 Film Program 0 0 N/A 6800 PublidLegal Notices 2;09 2,00 5,00 5',000 0 0:00% 6820 Rents;and Leases:Equip 84,68 100,00 74,00 ... 5,000 11,000. '14.86% 6840 Rents and Leases-Bldg/Imp ' 0 ' 0 N/A. 6880 Small Tools-Instruments 81,49 90,00 50,00 90,000' 40,000 80.00%, 6889 Software 16,64 210,00 210,00 120,000 (90,000) (42.86%) 6890 Computer Hardware 9,41 10,00 10,000 10,000' N/A 7052 Out of State'Use Tax 0 0 N/A 7110 Professional Development Admin Mgmt 0 0 N/A 7120 Training-in-Service 16,64 17,00 5,00 18,000 13,000' .26.0.00% 7130 Tuition/Textbook 0 0 N/A. 7201 Gas]Oil 2,51 5,00 4',00 5,000 1,000 25,00%u' 7206 Equipment Usage 64,33 749,00 600,00 ,7212 Chlorine Chem Recorders 735:03 759,00 1,050,00 850:000 (200,000) (19.05%)' 7217 StatePermits I Fees 39,64 40,00 25,00 40;000 15;000 60:00%d _ 7247 WaterConservation Prog 0 0. 'N/A 7250 Reimbursable Projects 2,00 2,000 '2,000 N/A. 7277 Recycled Water Use Prog 0 0 [NIA. 7296 FERC Fees./Costs 4,35 5,00 5,00 5,000 0 0.00%` 7297. 'River-front Park Levee Maintenance 7,12 40,00 40,00 40;000 0 0:00% 7301 County Car Expense 0 0, N/A 7302 Travel Expense 22,04 22,00 20,00 20000 0 O'00°f 7303 Private Car Expense 2,24 2;00 , 2,50 2;000 (500)' (2900%) qq 2114/2012 4:30 PM 1V Section Title: [ater Transmission System Agency•Fund • Section/lndex.No: 675108 Actual Estimated Adopted' Requested Percent. SubobjectcTitle 2010-11. i2011-12 2011°-12 2012;130 Difference Change'- 7320 Utilities 299 1,000 1,000 1,000 Q 0.00%a. 7394 Power 4,475,440 4,700,000 4,900,000 4,70Q000 (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,95 43,146 (15,810) (26.82%) 7924 Interest-PY (7,243) 0 0 0 N/A 7980 Depreciation 5,287,938 5,580,182 5,500,00 5,700,000 200,000 3.64% 7981 Amortization 0 27,110 129,000 129,000 N/A 8010 Contribution to Non-County 0 0 0 0 N/A 8090 Loss on Fixed Assets 0 0 0 0 N/A SUBTOTAL 5,280,695 5,727,910 5,558,95 5,872,146 313,190 5.63% FIXED ASSETS 8510 Buildings/Improvements 237 70,000 70,00 70,00 N/A 8515 Engineering Costs 541 9,000 N/A 8517 Adminsitration 458 9;000 N/A 8533 SCWA-New Metered Ser 1,152 20,000 20,00 20;00 0.00% 8560 Equipment 529,964 430,000 430,00 30,00 (400,00 ) (93.02%) 8562 Comp/Word Process Equip 0 0 N/A 8571 Field Equipment 0 0 N/A 8572 Laboratory Equipment 0 0 N/A 8573 Mobile Equipment 0 0 N/A 8574 Shop Equipment 0 0 N/A 9482 Amort WIP Outlay 60,000 100,000 N/A • SUBTOTAL 592,352 638,000 450,000 120,000 (330,000) (73:33%) OTHER FINANCING USES 8625 OT-W/in 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`7EAR'.ENCUMBRANCE EXPENSE . 9614 PY Enc Maintenance:Eguip 30,080 0 N/A 9618 PY<Enc Maintenance Bldgs/Imp 0 0 N/A -,9640 Pie-Enc'-Offce.Expense 0 0 N/A 9650 PYEnc=Profess/Special 668,586 0 N/A 9688 PY Enc-Small Tools/Instruments 0 0 N/A 9700 PY Enc-Special Dept Exp 0 0 N/A 9852 PY Enc-Bldg/Imp/Equip 0 0 N/A 9853 PY Enc-Equip 163,043 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 2/14/2012 4:30 PM tq Section Title: 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. PY Encumbrances 0, Change in Prudent Reserve 0 (250,000) 0. Post Audit Adjustments-Payables 0 0 0: Post Audit Adjustments-Receivables 0 0 0 Post Audit Adjustments-Inventory 0 0 0 Post Audit Adjustments-Prepaid.Expense 0 0. 0, Increase in Recycled/Conservation Deposits 0 0 0. Capitalized Interest (7,243) 0 0 Gain/Loss of Disposal of Fixed'Asset 0 0 0; Reclass of Prior Year Asset 0 0 0' ENDING'FUND'BALANCE 6,810,781'. 4,809,241 5,664,17E Operations and Maintenance 675108 Fund Balance Reserve Goal 5,013,849 Oved(Under}Goal 650,328' • •' 2/14/2012 4:30 PM 20 Water`Transmission System/Agency Fund IIIMajor Services & Supplies Expenditure Items Sub-Object No. and Title Actual Adopted Requested Percent FY 10-11 FY 11-12 FY 12-13 Difference Change 6140 Maintenance-Equipment 695,788 1,024,000 1,200,000 176,000 17.2% See Project List on page A-12 for detail. 6180 Maintenance- Projects 75,853 234,000 0 (234,000) -100.0% 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 3.3% Reflects level of actual expenditures. 6461 Supplies/Expenses 54,443 50,000 50,000 0 0.0% No change from prior year. 6512 Testing/Analysis 116,513 155,000 135,000 (20,000) -12:9% Anticipated lower costs based on prior year actuals. 6523 District Operations 8,499,478 10,200,000 9,800,000 (400,000) -3.9% Reflects MTO and held vacancies. • 6570 Consultant Services 290;581 1,101,000 1,395,750 294,750 26.8% See Consultant Services Project List for detail on page A-13. 6610 Legal Services 6,021 50,000 50,000 0 0.0% No change from prior year. 6880 Small Tools- Instruments 81,495 50,000 90,000 40,000 80.0% Anticipated higher costs based on prior year actuals. 6889 Software 16,645 210,000 120,000 (90,000) -42.9% 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 25:0% Increased expenditures based on prior year actuals and maintenance required. 7212 ChlorineChemical/Recorder 735,030 1,050,000 850,000 (200,000) -19.0% Reflects level of actual expenditures. 7394 Power 4,475,440 4,900,000 4,700,000 (200,000) -4.1% No change from prior year. • 8560 Equipment 529,964 430,000 3Q000 (400,000) -93.0% Reflects change in how we accountlfor some"maintenance"projects. Many projects that were previously budgeted under"6180" are now budgeted here. 2/14/2012 4:30 PM 21 FY 2012-13 BUDGET Water Transmission System Agency Fund • I DESCRIPTION -6180 Maintenance Buildings AMOUNT 1 Combined with 6140 6180 Total $ - DESCRIPTION -6140 Maintenance -Contracts-and Equipment AMOUNT 1 ElectricaISupplies and MaintenanceServices 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 I 7 Prefunding Cotati Tank#3 Recoat 300,000 6140Total $ 1,200,000 • •. 2/14/2012 4:30 PM a. • - r. . 2 .P1 I , , , l : l , . , ,,,g. . , Et: ; : ; : ! ,I , } ; P 2 ,5. -- § : (2i \ ( ` { / P ; E - -— - : !\ :2.3 , 0000 ,0e gc'ggg // a ) i ( i! } ; § ( : E , . , r , < : : zE j \ Ir ` { 2 : 34' / \ / `\ i ) ! § ( [H jE ~ }` [ T. ; \r - � () ! _ : / , � [ E § ` \ \ � / ` 13 ' ` [ ( § ; ! _, / ) / / \ _ � / / o • ,v, ` ( \ � \ \ � \/ \ / ( / \ j \\ \ � � ( \ \ \ - \� � � \ � « ` } Z }� � ` [\ \ - . . :\ \`� � �g{ ) ) )— _ _ _ \ \ _ [ f_ - : / - - ° ) ` \ IA ( § � \\ \} IT el 14 _ ) f ; {f s : : - ! : \: !` - . 1 7 : = - § - a ; \ i / ) ! { 7f ! ; ) ) [ I4 \ } [ ) ; \ } £[ ; f ; ] f ) § ) § Lon 0 75 0' Water Transmission System.Agency Fund Local Supply/ Recvcled'Water/'Tier 2 Programs Balance as of.January 13, 2012 10-Year Amount Amount Balance Contractor Allocation Approved Disbursed Available Santa Rosa $5,065,236 $4,003,876 $3,908,003 1,157,233 Petaluma 2,197,913 2,197,913 2,197,913 0 MMWD 1,724,026 1,000,000 1,000,000 724,026 NMWD 1,846,726 1,846,726 1,846,726 0 Rohnert Park 649,629 649,629 0 649,629 VOM WD 627,875 627,875 627,875 0 Sonoma 539,411 450,000 264,294 275,117 Windsor 86,996 86,996 86,996 0 Cotati 157,235 0 0 157,235 Forestville 104,953 104,953 104,953 0 TOTAL $13,000,000 $10,967,968 $10,036;760 $2,963,240 Program started June 30, 2000-No end date specified. • • 2/14/2012 4:30 PM 25 FY 2012-13 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Storage:Facilities • Section/Index No: 675405 Actual Estimated Adopted Requested Percent SubobjectTitle. 201011 201112 201112 201213 Difference Change BEGINNING:.FUND BALANCE 695,194 584,648 70,537 REVENUES USEtOF'MONEY/PROPERTY 1700 Interest.bn'POoed Cash 4;294 4,070 4,070 1,250 (2,820) (69:29%) SUBTOTAL 4,294 4,070 4,070 1,250 (2,820) (69.29%) _MISCELLANEOUS REVENUE 4102 Donations/Reimbursements 0 150,000 0 0 0 N/A (Petaluma AO-..Caltrans Project) _ SUBTOTAL 0 150,000 0 0 0 N/A CHARGES'FOR SERVICES 3145 Plans/Specs. 60 0 0 _ 0 0 N/A SUBTOTAL 60 0 0 0 0 N/A OTHER FINANCING,SOURCES • 4625 OT W/imSpecial Dist 16,874 0 0 740;000 740;000 N/A SUBTOTAL 16,874 0 0 740,000 74Q000 N/A Residual-Equity Transfer In 4865 Residual Equity Transfer In 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A TOTAL REVENUES 21,228 154,070 4,070 741,250 737,180 18112.53% EXPENDITURES OTHER-CHARGES 7924 Interest-.Prior Year (8,781) 0 0 0 0 N/A FIXED ASSETS 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 0 0 0 0 0 N/A 8543 Petaluma Aque elocation 45,696' 300,000 150;000 300,000 150,000 106100% • R 9162 Kawanato Ralphine Tanks 10,202 284,516 75,000 350,000 275,000 366.67% 2/14/2012 4:30 PM 2t '9168. Káwaha Springs Tank#2 0 0 0 0 0 N/A 91;71OakrnonLPipeline 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 • • 2/14/2012 4:30 PM 21' FY 2012-13 BUDGET BEGINNING AND ENDING GASH SUMMARY Section Title: Storage FacilitiesRevenue;Bond -2003A • Section%Index No: 675462' Actual Estimated Adopted Requested, Percent Subobject.Title ,2010-11 2011-12 2011-12 2012-13 Difference Change BEGINNINGIFUND.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 54 0 0 0 0 N/A SUBTOTAL 1,795 1,304 1,304 1,185 (119) (9.13%) 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-VV/in`Special Dist 357,755 358,508 35 8,508 357,683 (825). (023%) SUBTOTAL .357,755 358,508 358,508 357,683 (825) (023%) TOTAL REVENUES 359,550 359;812 359,812 358,868 (944) (0.26%°) it EXPENDITURES Mr SERVICES AND SUPPLIES 6635 Fiscal Agent Fees 783 1,500 1,500 1,500 0 0.00% 6640 Debt Insurance Costs 2;822 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) (2.86%) OTHER`FINANCING USES 8625 OT VV/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,828 119;483 119,483 124,138 4,655 3.90% 9209 Ent-Principal Clearing (114,828) (119;483) (119,483) (124,138) (4,655) 3.90% SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURES 195;544 192,263 192;263 426;891 234,628 122:03% Increase in Bonds;Payable 0 0 0 Amort. of Bond Issuance Costs 3,141. 3,141 3,141. Principal Payment (1,14;826) (119,483) (124,138) ENDING FUND-,BALANCE $309,202 $360,409 $171,389 aill 2/14/2012 4:30 PM 20 FY 2012-13 :BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: StorageTacilities Revenue Bonds 2006 . Section/Index No: 675488 Actual Estimated Adopted Requested Percent SubobjectTitle 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 i 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 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-CalFBonds (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-W/in 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 Bend 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 0. COI Funds 0 0 ENDING FUND BALANCE $467,253 $534,553 $99,320 2/14/2012 4:30 PM 291 FY 2012-13 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Pipeline Facilities • Section/Index No: 675413 ... _ Actual Estimated Adopted Requested Percent Subobject Title 2010-11 2011-12 2011-12:. 2012:13 Difference. Change BEGINNING'FUND,BALANCE 1,013,236 628,061 87,759. REVENUES USE OF MONEY/PROPERTY 1700 Interest on'Pooled Cash '6,316 5,698 5,698 2;500 (3,198) -56.12% SUBTOTAL 6,316 5,698 5,698 .2;500 (3,198) -56.12% INTERGOVERNMENTAL REVENUE 2852 Federal Grants 71,253 0 0 0 0 N/A SUBTOTAL 71,253 0 0 0 0 N/A MISCELLANEOUS REVENUE. 4102 Donations/Reimbursements 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A OTHER FINANCING'SOURCES. 4625 OT>Weiin'Special.Dist 19,878 1,161;000 1,161,000 2,534,000 0373,000 118.26% . SUBTOTAL 19,878 1,161,000 1,161,000 2,534,000 ' 1,373,000 118.26% TOTA •REVENUES 97,447 1,166,698 1,166,698 2;536,500 1;369,802 117.41% EXPENDITURES FIXED ASSETS 8510 Buildungs/Improvements 17 0 N/A 111/ 8515-Engineering Costs 15,18 0 N/A 8517 Adminsitralion 13;51 0 N/A 8543 Petaluma Aq Relocation-:Kastania 0 N/A 9106 Santa Rosa;Aqueduct Sections 2&3(Slusser to Pet Aq) 562,00 322,00 825;000 503,00 15621% 9115 Wohler Santa`Rosa,Pipeline _ 0 N/A 9128 Local Hazard Mitigation 71,28 800,00 1,094,000 1,094,00 _ N/A 9154 Petaluma Aqueduct 11,80 300,00 . .714,00. 290,000 M24,00 ) (59.38%) 9163 Eldridge Madrone Pipeline 0 N/A 9174 South Trans Sim' 0. N/A 9192 Sonoma'Aqueduct 45,00 125,00 325;000 200,00 160.00% 9482 Amori WIP Outlay 34 0 N/A SUBTOTAL 112,308 1,707,000 1,161,000 2,534,000 1,373,000 118.26% OTHER CHARGES 7924 Interest-Prior Year (120,184) 0 0 0 0 N/A (120,184) 0 0 0 0 N/A TOTAL EXPENDITURES (7,876) 1,707,000 1,161,000 2,534,000 1,373,000 118.26% Outstanding Encumbrances-Net Change (370,314) 0 Capitalized.Interest (120,184) 0 CIP Adjustment 0 ENDING FUND BALANCE 628,061 87,759 90,259 • • 2/14/2012 4:30 PM 3W FY`201243 BUDGET BEGINNING AND ENDING CA'SH,SUMMARY • Section Title: Sonoma tineducUReveWue Bonds Section/Index No: 675470 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.OFMONEY/PROPERTY 1700 Interest on Pooled Cash 2;807 2,233 2,233 2,030 (203) (9.09%) 1701 Interest 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 1200 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% ADMIN. 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 • 2/14/2012 4:30 PM 3 FY 2012-13 BUDGET BEGINNING AND ENDING CASH,SUMMARY • Section Title: Common Facilities Section/Index No: 675421 Actual Estimated Adopted Requested Percent SubobjecfTitle 2010,11 .261i-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 (9.09%) Intergovernmental.Revenue 4304 Federal Grant 0 255,132 0 0 0 N/A SUBTOTAL 0 255,132 0 0 0 N/A Charges for Services 3980 Revenue Apply to FY 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 Advances 0 0 0 6;959,124 6,959,124. N/A 4219 Advances-Clearing 0 0 0 (6,959,124) (6,959,124) N/A SUBTOTAL 0 0 0 0 0 N/A OTHER FINANCING.SOURCES 4625 OT-W/in Special Dist 1,369;633 2,545,399 2,727,708 3;825,384 1,097,676 40.24% SUBTOTAL l 369;633 2.545,399 '2727,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;Ezp 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 8500Land 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 Engineering'Cbsts 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 Isolation'Valves&Meters 205,468 191,330 150,000 133,000 (17,000) (11.33°_ 2/14/2012 4:30 PM 32— • Section Title: Common Facilities: Section/Index No;. 675421 • Actual 'Estimated Adopted Requested Percent Subobject Title 2010-11 2011.12';. 2011-12 2012-13 _ Difference :Change 8552 Forestville Storage:Tahk.1.14.(c)and(d 105,482 722,000 722,000 0 (722,000) (100:00%) 8558 Collector l&.2 Aq'Exp 0 0 0 0 0 N/A 8559 Early Warning System 0 0 0 0 0 N/A 8625 Unclaimable OTwithin.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, Mirabel/Cotati Feasibility Study, Flow EIR, Spring.Lake Groundwater, Phase II 12kv 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 Red. 0 0 0 0 0 N/A 9172 Water Education Facility 0 0 0 0 0 N/A 9175 Wohler Mirabel 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 9219 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/l nip 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% 2/14/2012 4:30 PM v 35 Section Title: Common Facilities Section/Index No: 675421 I Actual Estimated Adopted Requested Percent SutiobjecfTitle 2010 11' 2011-12 2011-12 2012-13'i Difference Change. Loan 0 0 6,959,124 Outstanding Encumbrances'.--Net Change (767,391) 0 0' Capitalized Interest (656,873) 0 0 Proceeds from State Loan.&Other LT Debt 0 0 0 Principal payment on 0 0 (123,256). Change in Deposit with-Others 0 0 0 Change in Cdntingent'Liability 0 0 PY CIP Adjustment-Reclass-to PY Exp 69,174 ENDING FUND BALANCE (946,262) (621,851) 74,255 . III 2/14/2012 4:30 PM a\ • FY 201243 BUDGET Common Facilities Section 675421 Detailed Listing of Capital Projects Project& SUB-OBJECT DESCRIPTION Subobject FY 2012-13 BUDGET 8510 Buildings and Improvements DESCRIPTION Mirabel Potable Water Line 0 Billing Meter Replacement 400,000 Collector.6 Chlorine Solution Lines 25;000 Mirabel Surge Control 200;000 Water Agency WestsideFacility 1,200,000 IQ% -, . 41,825;000, 8528 Mirabel.Generator DESCRIPTION Mirabel Generator TBD 0' 8528 Total ° T.' 0: 8529 Isolation Valves and Meters DESCRIPTION Isolation Valves 7379 133;000 • 8529 Total r4 -.133}000, 9105 Mirabel Fish Screen Replacement DESCRIPTION Fish Screen Replacement 7357, 75321 6,309,000 9105 Total[' .__ 4_ ;8;309;000?. 9107 Air Valves DESCRIPTION Air Valves 7429 541,000 9107 Total l .y 541;00_0 9128 Local Hazard Mitigation Projects DESCRIPTION RDS Liquefaction Mitigation 0 Collector 6 Liquefaction Mitigation 0 RR Crossing 405,000. MW Creek Crossing 554,000 Mirabel Dam,Emergency.Response Plan 0 Collector 3 and 5 Liquefaction.Mitigation Predesign TBD 220,000 9128 Total[<.'.. ''1,179;000! • 9482-Amort WIP Outlay DESCRIPTION IBM Collaboration Platform(moved to,GF wNVT support services s/o 6889) 0 • Total Common Facilities $ 9,987,000 2/14/2012 4:30 PM 35 FY 2012-13 BUDGET • BEGINNING AND.ENDING''CASH SUMMARY Section Title: Common Facilities Revenue Bonds -2003 A Section/Index No: 675454 Actual Estimated Adopted Requested Percent SubobJecf,Title 2010-11 2011'-12 2011-12 2012-13 Difference Change BEG. FUND BALANCE $222,543 $294,384,. $365;286 REVENUES USE OF MONEY IROPERTY 17001ntereston 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 ECONTROL 4200 Long Term Debt Proceed: 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 ISOURCES 4625 OT-W/in Special Dist 500,280 500,380 500,380 500,.180 (200) (0.04%) SUBTOTAL 500;280 500;380 500,380 500,180- •(200y (0:04%) TOTAL REVENUES 501,915 501,618 501,618 501,180 (438) (0.09%) EXPENDITURES SERVICES AND SUPPLIES 6635 FiscalAgent 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 l 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-W/in`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 • 2/14/2012 4:30'PM .• FY.2012-13 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Common Facilities Revenue Bonds-2006 Section/Index No: 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;885 REVENUES USE.OF MONEY!PROPERTY 1700 Interest on Pooled Cash 813 825 825 750 (75) (9.09%) 1701 Interest Earned 61 0 0 0 0 N/A SUBTOTAL 874 825 825 750 (75) (9.09%) ADMINISTRATIVE CONTROL 4200 Long Term Debt Proceed; 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 401,125 401,125 401,557 401,774 217 0.05% SUBTOTAL 401,125 401;125 401,557 401,774 217 0.05% TOTAL REVENUES 401,999 401,950 402,382 402524 142 0.04% • EXPENDITURES SERVICES AND SUPPLIES 6635. Fiscal Agent Fees 1,183 2,300 2,300 2,300 0 0.00% 6640 Debt Insurance Costs 4,085 4,085 4,085 4,085 0 0.00% SUBTOTAL 5,268 6,385 6,385 6,385 0 0.00% OTHER CHARGES 7920 Interest 233,934 233,936 229,596 225,068 (4,528) (1.97%) 7922 Premium-Call Bonds (1,984) 0 0 0 0 N/A SUBTOTAL 231,950 233,936 229,596 225,068 (4,528) (1.97%) OTHER FINANCING USES 8625 OT-W/in Special Dist 0 0 0 250,000 250,000 N/A SUBTOTAL 0 0 0 250,000 250,000 N/A ADMIN.CONTROL ACCOUNT 9200 Ent.-Principal 108,482 113,199 113,199 117,916 4,717 4.17% 9209 Ent-Principal Clearing (108,482) (113,199) (113,199) (117,916) (4,717) 4.17% SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURES 237,218 240,321 235,981 481,453 245,472 104.02% Cost of Issuance 0 0 0 Restricted Cash w/Fiscal Agent 0 0 0 Increase in Bonds Payable 0 0 0 Amort of Bond Premium (1,984) 0 0 Amort. of Bond Issuance Costs 4,085 4,085 4,085 Long Term Debt Proceeds 0 0 0 Principal Payment (108,482) (113,199) (117,916) Post-Audit Adjustment- Closing COI Funds 0 0 0 • ENDING FUND BALANCE $177,370 $229,885 $37,125 2/14/2012 4:30 PM a71 Ft 2012-13 BUDGET BEGINNING.AND''ENDING°CASH SUMMARY Section Title:. State Loan,Debt?Service Fund Section/I n dek No: 675439 Actual Estimated. Adopted Requested Percent SubobjectTitle 2010-11' 2011=12 201.1-12 2012-13 Difference Change BEGINNING FUND BALANCE. $105,354 $247,824 $407,500, REVENUES USE OFMONEY/PROPERTY 1700 Interest.on Pooled Cash 4,317 3541 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) (3:87%) OTHER.FINANCINGSOURCES 4625 OT-VV/in Special Dist 1,196,268 1,196,268 1,196268 1,196268. (0) (0:00%) SUBTOTAL 1,196,268 1,196,268; 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 386587 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,469 386,587 386;587 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 • 2/14/2012.4:30 PM • FY'2012433 BUDGET BEGINNING AND'ENDING CASH SUMMARY Section Title: State Loan Reserve Fund H Section/Index No: 675447 Actual Estimated Adopted Requested Percent SubobjecfTitle 2010-11 2011-12 2011-12 2012A3 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,246 124,000 124,000 124,127 127 0.10% • EXPENDITURES OTHER FINANCING'USES. 8625 OT-W/in Special Dist 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURES 0 0 0 0 0 N/A Reserve Unavail. for Budgeting (125,246) (124,000) (124,127) ENDING FUND BALANCE $0 $0 $0 Fund Balance Components at Bepinninp'of FY $40,360 $40;725 Cash $857,896 $983;142 • 2/14/2012 4:30 PM FY 2012-13 BUDGET BEGINNING AND ENDING CASHSUMMARY Section Title: North''Marin Water Deposit Section/Index No: 675512 Actual Estimated Adopted Requested Percent SubobjectTitle 2010-11 2011-12 2011-12 -2012-13. Difference Change BEGINNING FUND BALANCE 12,433 "12,540 12;634 REVENUES USE OF.MONEY 1 PROPERTY 1700 Interest on.Pooled'Cash 107 94 94 85 (9) (9.57%) SUBTOTAL 107 94 94 85 (9) (9.57%) Intergovernmental Revenue 2900 Other GovernmentAgencie; 0 0 0 1,240,876 1;240;876 N/A SUBTOTAL 0 0 0 1,240,876 1,240;876 N/A MISCELLANEOUS REVENUES 4625 OT -W/in'Special Dist 0 0 0 0 0 N/A SUBTOTAL - 0 0 0 0 0 N/A TOTAL REVENUES 107 94 94 1,240,961 1;240;867 1320071.28%• EXPENDITURES OTHER CHARGES 8010 Contribution Non-Co Govt 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A OTHER FINANCING:USES 8625 OT-W/in„Specialbist 0' 0 0 1,240;876 1;240,876 N/A SUBTOTAL 0 0 0 1,240,876 1;240,876' N/A TOTAL,EXPENDITURES 0 0 0 1,240,876. 1;240,876 N/A ENDING FUND BALANCE 12,540 12,634 12,719 W14/2012 4:30 PM 40 FY 2012-13 .BUDGET O. BEGINNING AND ENDING CASH SUMMARY Section Title:, Santa Rosa Aqueduct Capital Fund, Section/Index No: 675207 Actual Estimated Adopted Requested Percent Subobject Title .2010-11 2011-12 :201142 2012-13 Difference Change BEGINNING FUND BALANCE 5,696,127 5,775,073 5,549,241 REVENUES USE OF MONEY/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 00 (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 FINANCING+USES 8625 OT-W/in SpecialDist 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% ADMINISTRATIVECONTROL 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 • 2/14/2012 4:30 PM LI I FY 2012-13 BUDGET BEGINNING AND ENDING CASH SUMMARY • Section Title: Petaluma Aquednct capital Fund, Section/Index No: '675215' I Actual Estimated Adopted' Requested Percent SubobjectTitle, 2010-11 2011-12 2011-12 2012-13' Difference Change BEGINNING FUND BALANCE 5;545;740 5,581,223 4,897;605' REVENUES USE OF MONEY/PROPERTY' 1700 Interest'66Pooled`Cash 35,483 30,382 30,382. 25;000 (5;382) (17.71%) 1701 Interest'Earred 0 0 0 152,430 952;430 N/A SUBTOTAL 35,483 30,382, 30382 177,430 147;048 484.00% MISCELLANEOUSREVENUES 4035 Sale'-,Water Resale 0 0 0 0 0 N/A 4036 Sale-Water Govt 0 0 0 0 0 N/A 4102 Reimbursements 0 0 0 0' 0 N/A 4167 Petaluma Aqueduct Cap C 0 0 0 0 0 ' N/A SUBTOTAL 0 0 0 0 0 N/A ADMINISTRATIVE CONTROL ACCOUNT 4210 Advances 0 0 0 67,791 67,791 N/A 4219 Advances-.Clearing 0 0 0 (67,791) (64,791) N/A SUBTOTAL 0 0 0 .0 0 N/A • OTHER FINANCING SOURCES 4625 OT-,W/in!Special Dist 0 0 0 207,512 207;512 N/A SUBTOTAL 0 0 0 207,512 207,512' N/A TOTAL REVENUES 35,483 30,382 30,382' 384,942 354$560 1167.01% EXPENDITURES OTHER FINANCING USES 8625 OT-W/inSpecialDist 0 714,000 714;000: 290,000 (424;000) (59.38%) SUBTOTAL 0 714,000 714,000 290,000 (424;030); (59:38%) ADMINISTRATIVE CONTROL ACCOUNT 9210 Advances 0 0 0 3,827,518 3;827;518 N/A 9219 Advances-Clearing 0 0 0 (3,827;518) (3,827;518) N/A SUBTOTAL 0 - 0 0 0 .0 N/A TOTAL.EXPENDITURES 0 714,000 714,000 290,000 (424,000) (59:38%) Advance,to Common (3,827;518) Increase/(Decrease) in Loan Payable 0 Principal Receipt on Advance 67,791 (ENDING FUND;,BALANCE 5,581;223 4;897,605, 1,232;820 S • 2/14/2012 4:30 PM 42 FY 2012-13, BUDGET BEGINNING,AND ENDING'CASH SUMMARY Section Title: Sonoma Aqueduct,Capital Fund Section/IndexNo: 675231 Actual Estimated Adopted Requested Percent Subobject,Title 2010-11 2011-12 2011-12 2012-13 Difference Change, BEGINNING FUND BALANCE 124,254 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-W/in Special Dist 0 50,000 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 • • 2/14/2012 4:30 PM 14..� FY 2012-13 BUDGET . BEGINNINGAND ENDING'CASH SUMMARY Section Title: WaterManagementPlanning I • Section/Index;N o: 675710 Actual Estimated 'Adopted Requested Percent Subobject Title. 2010-11 2011-12.. - 2011:12 2012=13 Difference Change BEGINNING!FUND BALANCE 362,617 72,630 81,278 REVENUES USE OF MONEY'/PROPERTY 1700 Interest on,Pooled Cash 3;692 3,157 3,157 2,870 (287). (9.09%) SUBTOTAL '.3,692 3,157 3,157 2,870 (287) I(9.09%) Intergovernmental Revenue 2912 Town of Windsor 12;242 13,376 13;376 3,481 (9,895) (73.97%) SUBTOTAL 12,242 13;376 13,376 3,481 (9,895) (73:97%) Miscellaneous Revenue 4040 Miscellaneous Revenue' 30 0 0 0 0 N/A 4175 Water Management.Planning Charr 0 0 0 0 0 N/A SUBTOTAL 30 0 0 0 0 N/A OTHER FINANCING SOURCES, 4625 OT-W/in Special Dist 195;087 1.92,115 200;000 50;000 (150,000) (75 00%) SUBTOTAL 195,057 192115 ,200;000 50,000 (150,000) (75.00%) TOTAL REVENUES .211,051 208,648 216,533 56,351 (160,182) (73.98%) . EXPENDITURES Services and-Supplies 6040'Communications 123 0 0 0 0 N/A 6180 Maintenance Bldg/Imp• 0 0 0 0 0 N/A 6430 Printing Services, 1,556 0 0 0 0 N/A 6461 Supplies/Expense 146 0 0 0 0 N/A 6522 District Operations. 25;701 0 0 0 0 N/A 6523 District Operations 302,359' 75,000 75,000 25,000 (50;000) (66.67%) 6570 ConsultantSvs. 18,265 50,000 50,000 25;000 (25,000) (50.00%) 6610 Legal Services 127;296 75;000 75,000 0 (75,000) (100 00%) 7206 Equipment U age 150 0 0 0 0 N/A 7247 Water Conservation 0 0 0 0 0 N/A 7303 Private Car Expense 103 0 0, 0 0 N/A SUBTOTAL 475;699 200,000 200,000 50,000 1(150000) (75.00%) PRIOR YEAR ENCUMBRANCE EXPENSE 9650 PY Enc-Profess/Special 143,548 0 0 0 0 N/A SUBTOTAL 143;548 0 0 0 0 N/A TOTAL EXPENDITURES 619,247 200,000 200,000 50,000 (150,000) (75.00%) Outstanding Encumbrances.-.Net Change 118;209 ENDING FUNDBALANCE 72,630 81,278 87;629 • 2/14/2012.4:30 PM Hq FY2012=13 BUDGET BEGINNING AND ENDING;CASH.'SUMMARY •. Section.Title:;: Watershed Planning/Restoration iSection/Index Not. 675728 I, Actual Estimated Adopted Requested. Percent ,Subobject Title 201041 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) (37.50%) Intemovernmental 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 48.57% 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;692,196 3,995,267 3,725,600 (269,667) (6:75%) 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 Supplies 6040 Communications 2,216 N/A 6140 Maint-Equipment 1,350 N/A • 6180 Maintenance Bldg/Imp 12,417 N/A 6262 Lab Supplies 1,101 N/A 6400 Office Supplies 402 N/A 6410 Postage 325 N/A 6415 Books/Periocical 173 N/A 6430 Printing Services 11,139 N/A 6461 Supplies/Expenses 6,918 N/A 6512 Testing/Analysis 53,467 N/A 6522 District Services' 168,551 N/A 6523 District Operations-RRIFR Program 1,544,458 2,176,18 2,176,18 2,705,60 529,42 24.33% 6570 Consultant Services-RRIFR Program 217,279 404,50 404,50 990,00 585,50 144.75% 6610 Legal Services 104,610 30,00 30,00 30,00 0.00% 6800 Public/Legal Notices 6,120 N/A 6840 Rents/Leases-Bldg/Imp 605 N/A 6880 Small Tools/Instruments 9,973 N/A 6889 Software 6,330 N/A 6890 Hardware 1,726 N/A 7022 Public Relations Exp 1,442 N/A 7206 Equipment Usage 21,029 N/A 7217;state Permits/Fees 1,373 -N/A 7302 Travel Exp 14,581 - 'N/A 7303 Private Car Expense 509 N/A SUBTOTAL 2,188,094 2,610,680 2,610,68 3,725,60 1,114,92 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 N/A TOTAL EXPENDITURES 2,759,554 2,610,680 2,610,680 3,725,600 1,114,920 42.71% Outstanding 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: Recycled Water and Local Supply Section/Index No: 675736 I • Actual .Estimated Adopted Requested. Percent Subobject Title 2010-11 2011:12 '2011-12 .2012-13 Diffarena. Change: BEGINNING FUND BALANCE 237,578 .313,253 293,703-- • REVENUES. USE OF MONEY/PROPERTY 1700 Interest on Pooled Cash 7,862 14,685 14,685 _ 2,500 (12,185). '(8298%) SUBTOTAL 7,682 14,685 14,665 2,500 " (12,155) ' 482.98%) • . . _ovammental Revenue ' 2912 Town of Windsor ,50,677 58,016 58,017 51,174 (8,94 2912 3) (11.79%) -SUBTOTAL 50,677 58,016 58,017 51,174 (6,843). (11.79%) MISCELLANEOUS REVENUE 4040 Miscellaneous Revenue 0 0 0 0 0 N/A 4102 Donations/Reimbursements 75,000 80,000 80,000 140,000 60,000 75.00% 4303 State Grant .21.690 0 0 110.000 110,000 N/A SUBTOTAL 102,660 80,000 80,000 250,000 170,000 212.50% OTHER FINANCING SOURCES 4625 OT-Wan Special Dist 811',557 833,265 867,500 735,000 (132,500)! (15.27%) SUBTOTAL '811,557 833,265 867,500 735,000 (132,500) (15.27%) TOTAL REVENUES) 972,756 985,966 1,020,202 1,038,674` 18,472 11.81% EXPENDITURES Services and Supplies 6040 Communications 313 0 • N/A 6140 Maint-Equipment 848 0 N/A 6400 Office Expense 67 0 N/A '6410 Postage _ 77 N/A 6430 Printing Supplies 17.261 ' N/A 6461 supplies/Expenses 437 N/A- 6522 District Adminislaticn ' 28,167 ;N/A 8523 Cis-trim Operations 279718 330,00 330,00 275,00 ' (55,00 ) (1E67%) SV OW Mgmt Plan,SR Plain OW Study B Mgrnt Plan 6570 Cdnsultant Services 364,800 617,50 617,50 385,00 (232,500). (37.65%) • SVGWMgml Plan,SR Plain GW Stud/ill Mgmt Plan 8610 Label Services 784 N/A 6630 Audit Servces 0 - N/A 6800 PublidLegal Notice 1,127 N/A 6840 Rents/Leases/Bldg/Imp '766 N/A 6689 Sotware, 3,461 N/A 7208:Equipment U Sge 1,683 N/A 7217 State Pem,its/Fees 678 _ 'N/A 7277 Recycled Water Use 0 N/A 7302 Travel Expense 17 N/A 7303 Private Car Expense 0 ' 'NIA SUBTOTAL 700.224 947,50 ( 947,500 660,00 (287,500) (30.34%) Other Charges '7924-Interest P.Y (21,357) 0 0 0 0 N/A 8010 Contribution Non-County Government' 0 0 0 325,000 (LRT2) SUBTOTAL (21,357) 0 0 325,000 0 1 N/A Capital Assets 8510 Buildings/Imp 60,098 0 0 0 0 N/A 8515 Engineering Costs 448 0 0 0 0 N/A 851],Adminahations 402 0 0 0 0' 'N/A 9482 Amortizable WIP 0 0 0 0 0 N/A SUBTOTAL 60,946 0 0 0 0 N/A PRIOR YEAR ENCUMBRANCE EXPENSE 9650-PV Enc-Profess/Seecial 85,267 0 0 0 0. N/A 9700'PY Eno-Special Dept Exp 1,189,451 0' 0 0 0. N/A SUBTOTAL '1,274.718 0: 0 0 0' N/A TOTAL-EXPENDITURES 2,014,531 947,500 947,500 985,000 37,500 3.96% Outstanding Encumbrances-Net Change 1,255,339 Capital Interest ' (21,357) 0 Change in Wmdsor.Reserve '(50,678) (56,016) (51',174) Audit Adjustment •(65,854) . ENDING-FUND BALANCE 313,253 293,703,_ 396,203 • •. 2/14/2012 4:30 PM 4,w . FY 2012.1,3 BUDGET BEGINNINGA'NUENDING CASH.SUMMARY • Section Title: Water Conservation Section/Index',No; 6757441 Actual Estimated Adopted .Requested .Percent Subobject Title .2010-11 2011-12 2011-12 2012-13 Difference •Change. BEGINNING FUND BALANCE 186,164 '104 ,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) (31.66%) Intergovernmental Revenue 2911 City of Santa Rosa 0 0 0 N/A 2912 Town of Windsor 96,31 100,64 100,651 105,134 4,483 4.45% 2914 City of Rohnert Park 0 0 0 N/A 2919 City of Sonoma 0 0 0 N/A 2951 North Mahn Water District 0 0 0 N/A 2954 Town of Windsor 0 0 0 N/A SUBTOTAL 96,31 100,64 100,651 105,134 4,483 4.45% Miscellaneous Revenue 3980'Revenue Applicableto Prior Y - - - - 0 N/A 4040..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-.W/In 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 0.33% TOTAL REVENUES 1;639,853 1,617,105 1,609,309 1,617,634 8,325 0.52% EXPENDITURES Services andSupplies 6180 Maint-Bldg/Imp 81 N/A 6020 Clothing N/A 6415 Books/Periodicals 11 N/A 6461 Supllies/Expense .95 N/A 6522 District Services 92,54 N/A 6523 District Operations 1,143,62 900,00 900,00 895,00 (5,00 ) (0.56%) 6536 Business Environmental Allian 41,89 50;00 50,00 50,00 0.00% 6570 Consultant Services 20,00 10,00 (10,00 ) (100.00%) 6584 Trade Shows-So Cty Fair 20,00 20,00 20,00 0.00% 6610 Legal Services N/A 6630 Audit Sys-Review of Prg N/A 6800'Public information 27,36 N/A 6840 Rents/Lease-Bldg/Imp 83 N/A 7022 PublicRelations. 121,68 165;00 165,00 165,00 0.00%• 7206 Equipment Usage 10,68 N/A 7247 Water Conservation 208,60 360,00 360,00 380,00 20,00 5.56% 7250 Reimbursable,Projects N/A 7302 Travel Expense ' 39 N/A 7303 Private Car Expense 1,70 N/A SUBTOTAL 1,651,237 1,515,00 1,505,00 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 •• PRIORYEAR ENCUMBRANCE EXPENSE. 9650 PY'Enc-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/14/2012 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 0.33% • Outstanding Encumbrances 126;491 Change in Windsor Reserve 10,425 (109:742) (105,134). Audit Adjustment_ (65854). ENDING FUND BALANCE 164;246 29,262, 31,762 • 2/14/2012 4:30 PM 413 FY 2012-13 BUDGET CHARACTER JUSTIFICATION. Department-Division: Sonoma`County WatenAgency,:Water Transmission •, Section Title: Water Conservation Character Title: Use of y Moneand.Properiy 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 projected'based 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•Town 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 • 4303State.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 item is requested to provide for the charging of salaries, benefits and overhead costs for staff assigned to • projects budgeted within the Water Conservaton Fund. Water Conservation,Water Education and Public Affairs Staff' 755,000 Water education Seasonal Staffng 80,000 Prop 84 Water Conservation Grant Administration 60,000 L$ '895,0001 6536 Business Environmental Alliance 2319-22,7190 Agreement with the Economic Development Board 50,000 50;000 6570 Consulting Services 0 0 6584 Trade Shows 7189 0 Sonoma County Fair 20,000 L$: 20,000 0 7022 Public Relations 7189 0 Public Information and ACWA Campaign 165,000 L5' '065;000j 7247 Water Conservation 0 School Education'Program 280,000 QWEL English&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 LS- ',380;000U Character Title: Other Charges Character No:: 675744-75 • 8010 Contribution Non-County Governments This item is request to pass DWR grant monies through to other governments $0 • 2/14/2012 4:30 PM �(� 1 FY 2012-13 BUDGET SONOMA• COUNTY WATER AGENCY Operations and Maintenance Rate Computation • O & M REVENUEREQUIREMENT` ESTIMATED FISCAL,YEAR 11/12 EXPENDITURES $37,521,689 LESS:' DepreciationAmortization 5,829,000 In■estment Income,'Interest on Pooled Cash, Charges for Services 50,250 Power Sales 800,000 PWRPA Pre-paid Expense.-:FY08/09RaterReduction-One time only Mandatory Prudent Reserve'charge; . 0 Recycled.Water funds (Sub-object 7277) taken from special reserve 0 Transfers Out 10,157,493' REVENUE"REQUIREMENT(Net Expenditures) $20;684,946 0 & M. ACRE FOOT BASE AVERAGE DELIVERIES- PAST 12 MONTHS 45;960.6 LESS: • Mahn Municipal 5,413.3 Surplus (Irrigation) 92.3 TOTAL BASE DELIVERIES 40,454.9 0&M RATE COMPUTATION: Rate= Revenue Requirement- (Marin!Muni.Off,Peak'Deliveries x Highest Prime Rate) - (Mahn Muni Surplus.Deliveries x(O&M'Charge:+Capital Charge) Total Deliveries 'Surplus Deliveries- Mahn Muni Past 36 Months Deliveries = 20;684,946 (4,300.00 x 609.34) - (1,113.30 x 528.01) 45,960.6 - 92.3 - 5,413.3 * = $432.01 �(� 2/14/2012 4:30 PM REVENUE BOND I STATE LOAN CHARGES-WATER RATES AND ESTIMATED REVENUES FOR FY 12-13 A. ANNUAL DEBT SERVICE REQUIREMENTS Sonoma 'Common Watershed Plan ' .Water Storage Pipeline Facilities .Restoration Conservation Facilities Fadlities • 2003 A Revenue Bond 676464 T80 TED 675462 I675470 PRINCIPAL $173,794 $124,138 $102069 INTEREST 255,148 182,250 `149,850 FISCAL AGENT FEES 1,600 1,500 1.200 DEBT ISSUANCE COSTS 3,951 2,822 2,320 DISCOUNT/BONDS .446 319 262. Total Individual Bond Payments 434,939 0 311,029 255,7D1 Bond Reserve 65,241 0 46.654 38,355 Total Individual Bond Debt Service 600,180 '0 357,683 294,056 2006 A Revenue Bond 576495 676488 PRINCIPAL 8117,916 $132,085 INTEREST, 225,068 252,112 FISCALAGENTFEES. 2,300 2,500 'DEBT ISSUANCE COSTS 4,085 4,576 DISCOUNT/BONDS Total Individual Bond Payments 349369 391,273 0 Band Reserve 52,405 58.691 0 Total Individual Bond Debt SeMLe .401,774 449,964 0 2012 Santa Rosa AQ Capital Fund Loan PRINCIPAL 65,46 ,INTEREST 124,71 •FISCAL AGENT FEES. DEBT I COSTS ➢iscobN DS' Total Individual Loan Pei ment e 190,18 0 Loan Reserve 0 Total Individual Loan Debt Service 180,181 0 2012 Petaluma AQ Capital Fund Loan PRINCIPAL 87,791 INTEREST 162,430 FISCAL AGENT FEES 0 DEBT.ISSUANCE COSTS 0 DISCOUNT/BONDS 0 Total Individual Loan Payments 220,221 .Loan Reserve Total Individual Loan Debt Service 220,221 1. 09/10 Financing Exo for Common Fac End above Mabel TED-Water.Ed TBD-Oakmont • until index eslablisheq Generators TBD.RRIFR Bldg Pipeline PRINCIPAL 282,582 INTEREST 43,146 FISCAL AGENT FEES 0 DEBT ISSUANCE COSTS 0 Total inelvldeal Bond Payments 325,708 0 0 0 0 Reserve 0 0 0 0 0 Total individual Financing Debt Service 326,708 0 0 0 0 SRF LOAN 675439 PRINCIPAL 672,033 N.A NA INTEREST 368,200 N.A NA USE OF SRF LOAN FUND BALANCE:675439 Reserve Requirement 156,035 Total SRF Debt Service 1,196,268 SRF LOAN RESERVE 675447 RESERVE. 119,627 N.A NA Total SRF Debt Service 1,315,095' TOTAL DEBT SERVICE $2,943,959 $0 $0 $807,647 $294,056 LESS REVIFROM N.MARIN REV.BOND CHARGES $315.131 REMAINING REVENUE REQUIREMENT $2,628,828 $0 $0 $807,647' $294,056 Br CALCULATIONS OF WATER RATES FOR FY 12.13 Sonoma Common Watershed Plan Water Storage Pipeline Facilities Resoration Conservation Facilities Facilities •Debt Service Debi Service Debt Service Revenue Bonds•Revenue Bonds Charge - Charge 'Charge Charge Charge REVENUE REQUIREMENT $2,628,828 50 50 $807,647 $294,056 APPLICABLE BASE WATER DELIVERIES IN A.F. 34441.7 45,858.3 45,858.3 34,441.7 4,305.0 CHARGES PER ACRE-FEET $76.33 $0.00 $0.00 $23.45 $68.31 C. CALCULATIONS OF NORTH MARIN REVENUE BONDS CHARGE REVENUE REQUIREMENT FOR COMMON FACILITIES DEBT SERVICE' 2,543,557 N.MARIN'S SHARE(REV.REQMT.FOR COMMON FAC,DEBT SERVICE X(11.2/90.4)) 315,131 ESTIMATED WATER DELIVERIES TO NORTH MARIN(IN AF.) 6,013 NORTH MARIN REVENUE BONDS CHARGE 52 Common Facilities 'North Mann exercised option for cash payment Totel'Debt Service' 2,543,557 of Aqueduct Loan funded projects . N.Manns Share(11.2/904) 315,131 Total Revenue Required $2,943,959 Estimated Water Defvedes tdN-Mann 6.013,2 Less Aqueduct Loans (400.402) Applicable portion of the N.Mann R.'Bonds Charge $52.41 Revenue base for NMWD $2,543,557 2/14/2012 4:30 PM 51 SONOMA COUNTY WATER AGENCY RUSSIAN RIVER CONSERVATION CHARGE,COMPUTATION _ • FISCAL NEAR'2012=13 PROPERTY ASSESSMENT VALUES AS OF'FY11-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,777;166 7,443,693,480 43800 City of Rohnert Park 3,656;156;306 107,759,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,921;799 $1195,785,663' $34;307;707,462 Notes: 1 Total value of secured 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$100 of full.cash value as sessed for payment of Warm Springs Dam Project Obligations 0007 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;54411 4 Total acre feet of water delivered to+Prime Water'Contractors of.Sonoma County (excluding North Mann and Town of Windsor)]plus deliveries to Forestville 33,319.75 during the last`12 month period 5 Total Russian River Conservation Chargé per Acre.Foot(Line 3/Line 4) $72:08 Russian River'Projects Charge Historical calculations For FY Calculated 00-01 5.8 01-02 5.66 02-03 9.15 03-04 14:93 04-05 19.18 05-06 24:23 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 ip, 2/14/2012 4:30 PM Da • FY 2012.13 BUDGET Water Transmission System'OperatingTransfers Beginning Fund Ending Fund Increase Fund Index 4OTOut(8625). To OT In(4625). Balance Balance (Decrease) Santa Rosa Aq:Capital,Fund 675207 1,919,000 Pipeline Facilities 211,891 $ 5;549,241 $ 915,707 $ (4;633,534) Petaluma Aq.Capital Fund 675215 290,000 Pipeline Facilities 207,512 $ 4;897,605 $ 1,232;820 $ (3,664,785) Sonoma Aq.Capital Fund 675231 0 72,230 $ '50,731 $ 123,611 $ 72,880 Sonoma Rev Bond 2003 Fund 675470 325,000 Pipeline Facilities 294,056 $ 463,812 $ 181, 779 $ (282,033), Storage Rev Bond 2003 Fund 675462 240,000 Storage facilities 357,683 $ 360,408 $ 171,388 $ (189,020) Storage.Rev Bond 2006.Fund 675488 500,000 Storage Facilities 449,964. $ 534,554 $ 99,321 $ (435,233) Common Rev Bond 2003 Fund 675454 -400,000 Common Facilities 500;180 $ 365,286 $ 35,924 $ (329,362) Common Rev Bond 2006 Fund 675496 250,000 Common Facilities 401,774 $ 229,885 $ 37,125 $ (192,760) State Loan Debt Service 675439 0 1,196,268 $ 407,500. $ 567,035 $ 159;535 State Loan Reserve 675447 0 119,627 $ - $ - $ - Capital Lease Financing .675371 0 0 $ 31 $ 31 $ 0 ... Agency Fund(Discretionary) .675108 1,608;800 Common Facilities 0 $ 4,809,240 $ 5,664,176 $ 854;936 Agency Fund(Charges) 675108 10,157,493 0 $ - $ - $ - Pipeline Facilities ;675413 2;534,000' $ 87,758 $ 90,258 $" 2;500 Storage.Facilities 675405 740,000 $ 70,536 5 71,786 $ 1,250 - : Common Facilities 675421 0 nr 3j825;384u $ (621,851) $ 74,255 $ 696,106 North Marin 675512 1;240,876 Common Facilities 0 $ 12,633 $ 12,718 $ 85 Water Management Planning 875'710 50,000 $ 81,279 $ 87,630 $ 6,351 Watershed Planning./Restoration 675728 3,725,600 $ 152;932 $ 412,327 $ 259,395 Recycled Water&Local Supply 675736 735,000 $ 293,704 $ 296,204 $ 2,500 Water Conservation 675744. 1;510,000 $ 29,262 $ 31,762 $ 2,500 Total 16,931,169 16,931,169 17,774,546 10,105,858 (7,668,688) Common Facilities OT-in'4625 From Water Transmission(discretionary) 1,608,800 Water Transmission(Charges) '325,708 North Marin 1,240,876 2003 Bond Fund 400,000 2006 Bond Fund 250,000 3,825,384 Agency Fund(Charges)OT-Out Santa Rosa Aq.Capital Fund 211,890.71 Petaluma Aq.Capital Fund ::207,512.01 Sonoma Aq.Capital Fund 72,229.99 Sonoma Rev Bond 2003 Rind 294,056.15 Storage Rev Bond 2003 Fund 357,683.35 Storage Rev Bond 2006 Fund 449,963:95 Common Rev Bond2003 Fund 500;179.85 Common,Rev Bond 2006 Fund 401,774.35 State Loan.Debt Service 1,196,267.95 State Loan Reserve 119,626:80 ' Common'.Facilities 325,708.00 ,Water,Managemen6Planning" 60;000 Wetershed'Planning:%Restoration 3;725,600 Recycled Water&Local Supply 735,000 Water Conservation '1,510,000 10;157,493 • .. 2/14/2012 4:30 PM �z� 53 FY 12-13 Proposed Water Rates • FY 11-12 FY 12-13 0 (Actual) (Proposed) /°'Change O&M Charge 439.04 432.01 -1.6% Water Management Planning Sub-Charge 4.18 1.09 -74.0% Watershed Planning/Restoration Sub-Chary 54.56 81.06 48.6% Recycled Water Sub-Charge 18.13 15.99 -'11.8% Water Conservation Sub-Charge 31.45 32.85 4:5%0 Total O&M Charge 547.36 563.01 2:9%- Santa Rosa Aqueduct Rate O&M Charge 547.36 563.00 2,9%d Aqueduct Facilities Capital Charges[4.6 e] 0.00 9.25 N/A Storage Facilities;Capital Charge [4.7] 2109 23.45 1.6% Common:Facilities:Capital Charge4[4,8] 63.70 76.33 19:8% TOTAL 634.15 672.03 6.0% • Petaluma Aqueduct Rate O&M Charge 547.36 563.00 2:9%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 53.% • 2/14/2012 4:30 PM /''may � M.rtitc �¢��y „'"" °! k L u -- Lr� e � "1st sa,'Y.'s+r� � h gy 4j`7 �H z�'�`f i V uR o in p fl 03 c W ate+rad Vi 4-) • ` 4 J HE VI cn tn r0 ce r— � N sir Q� can . M t0 ,� '"• �� A � U d' r U L C 0 3 � Ca � I"� O b V �' a •> 0 c o nki CU CU o Len al >21 >aN VI - .0 II ,.� i . ::�".,1 rn N (I:• t ea „` M ... . N ®. " Q • .I I ii H . re "cc " <.11 ':um. : u ‘ a: uv C< a '' a"�° j -0 " -0 o" Li. c in • c Li" ED (J o "boon il n ID : 0." — `"d co:: " � o F 5(v 0 0 TEW if:41*::11 .001=116%. MIJ .: }. 0 LI- "1 (1) • ..f a) r —C a) L.- cs 4_0 4 ) c oz (A 4.., L. 0 LL: .Pa° Eill:44 EICS (1) a m ......,. ..,4 , # 4.j saws., f (/) k C L.I L■ 0 ra ( • .. .• , 0 ri 4..... WSJ. 0 ,. . 4..j if■0 0 12=1 V 4:=J In 0 1/4:-... i ra 0 0 0 ,z U ----f 1- • = U Ii (1) V) 2 V) 8 al ra tr) c a) 1 i U o u -a rel tin .1.. c Q.) on 4—; M ra -0 a L- C C > '''li'". (1) s 1/44---- e••••• ••--- • pin 4., in 4•J rt a"'"" - 4—P a. rts 0 •1C 4....) L.- , • . (11) v) I) asi) = iv CO OD L.... ,.... ro ro us) 0 0 a j:CS \41 >N co -6-, V: e ' r 4-si V) c co 0 en • c---1 ,--Ti __y --IT. ;� 0 :. o• N a +. I 4� + , N vr3 _c' u 0. +U(0 [5 o ° N v1' O J 1 v � i u _ CD N i Q) I- N . m rI .L j � O •�- ` a--+ -8--� L: _c Q) 4— d U Q : .-CI) .: N +:.: r 1 f 1 .�7 I ••i c•. q) LL• cL U• H w O 00 I fC�' i � i I .p[ . %.-.+'. ` j 4 1 ( W I .1 II r.:14=ibli 1 *nt JO rl ei M m ? -, , c? t o 0 u-, o o c i N c j i L c i c r., cr t 0 : (-.j a 0 CO 6 N LA N, n, m N u) & co 3 CU' rn . ri - ni Ln cri Li) le - • tti i ill N cm , i ' --1 co cm rn Ln cr, ID (-A (7/ L'D 1-1 nj U) LA War in in in- in- 1 , i ri i• -., rfii L.L i :.... E E , •ick o o ? VO " 4— e4 ertt CO 4— ,- Icel;:' CO V) VI li, 2 t 03 (.) t._ I — 2 c . r go i _ _.... D 1 , 11... ctA- L- c) sly,- in 4- 0 -V- IbLa o c . co n3 4.,_, Ilit ' U ri -0 E , .. E 0 ro 24°, CO ri T-i * as) fa'zt o o 7 4— 2 >- u_. 1 4—.0 CTi. ro -o .., , -o a_ E ta 0 C to — cc a a. n o r, -0 _a •;4 CC C (I) l.,) 0 •,— la CU 4, . CZ 0 Oa 4--. r— QJ -I--, ct In " ill 112 CC i —0 1?3, eup bp C c a) ¶ 1.... c n '16' tai '' c c ._ ._ 0 o c,-) — ra in C. 3tal. C C 7-, L_ 47-, V) 'f. c C s- ra E 0 0 '' 0 n3 (13 (3) > E t; _o -a u ,_ ... L_ f<% 0 o E • r .rMtuta- ao w U U u o I t-ot' r" ma w a) % c >- co ,_ E • ra E w iat. _ lb9(1) II A ®MI\ % 0 • • ./ 1]jVuRmmmAO (.. \ \ 0 0 0 } ,. : . , . : > . \ / /w. . % \ Ci:4>i're-iiir4rerf4S.' "-I \ •V/ ` / \ , 2 - \ \ ) k - t ~ 3 ` 5 cc | al ; } D s . o } • [ y , CC u j Hi ela \ C 2 ! \ • t . . ( Z 2 < ; . y CU : y ( j F / \ . d. . y » \ \ } » . G . . ; . ƒ\ 2 . F , \ \ \ - - \ .a8ueq au .ate ua#ad . \ • . . . (Pi • <_, L ( •^ i v>t• • I/C.v. d f ii ,S -'e tFL - a I. • i : 1 4 . ti Y .•� -� - 1 ,i 4. t ^^•�,, s J a, TU 1 L ; ' v' i J . 1 � �'S11.., - ■ I T.,1 t '.�9...4,, .ii- . o f , • kiy fi e f �I �! N I cn 0. T, r I. hA I L w. . (/) i resoi i rvo 1 o ® a) }! , ken C -1 0 4— Ctia telaga 1 W ■ 1' ®® tt A , j _ _ - _ , i 1 12 U - c✓ I r .r. Oz t zt --,.Lz 1') f 0 N �S cu N an 73 c V/ j v .0 - ,.....L- - o 5 p CU — > W O km O - O C �4o Z Q O a)4-1 co U 0 W - N CC fa a• It °" ' Cn E 5 cr ® Yet C72 4—r1 ra Una }tro e -. '4` .,F i(f t �- Y taint, & afe'", 'I've /� 'vIrr4TP'' I've" 0 tR. i t "wit t4, n rrn t ert n r. `t. N 5'. t t W Q a I • (03 . „II ,t1tald, ,_ a) CD c) 'PI ... . DI _sic+. , " _ E t "Pk ...t o ,IN7 >g% 0 a) _a - - I 0 — u) ! L. !...!, .. .•.. . (,) ''A':•••'it..4'...' • °D.: 0) u < a a) cri) 0•.. .. . a.:4 co LLI: ta 14- h 2 CU ..CD 0 ilia . . . V .. . Imi >I Cr 415 , . o . . .•',, .1._ c 03 .. • . _ O. a) CO ..0 4.0 . , , CU v 0 . .... . „, . „,.,,,...„iii. 4 ) . tnn i0,) E. ,.. C - . , ..,t 0 . X E L° ., . .. . . .... . _ . . CU 0 = u o a .. . „ . Z 1... ._. -, ... , . ,. .., ..• . . . . . ...... (04. ki trat,,,, ,810-47 gve71,02Y ilsizt C s,.... > CD 0 a) ° C i , 44. 41' k =A .k:0"1 0 tin On (.7% ' JEA oils, .;:',14-fr., Ma ..,-'oti: ' ';.. •,,i 0.11 a rti arra-4; c ri ' E u N- • 0 (15 LA fxst,4 .07, mra 3 ' '''`I'1,anci ...0 c 44.F, 131‘41+Th'41 sfiev,„0: is 4.,.. . ,;41%44 4, 141,44,04 E.... ......, _ 1 ___, ...- .4 0 r.... (I a) can u 0 ro .,— - , 0 Vi .1.". a 0 Ir. c .0 vs) ro E tn 4t A . - - , tn 4=1,0 Ln C ra in ,. ...4 , a ai ‹C Sc. 0 1.... di •n-- k- > r > r3/4.4% -a' a On N.. z 4 ) (1) 0 0 0 la) • N- ' -7', n . 4..) -0 on (NI (.,,, • rn .,' 4 En. kil ro ra • ..0 in on ni ...iL " ira a) en c titi 1 0 a (....) a.) ra tan • tc.) it— i: •47; it LiCN i 4-) al ,---1 pi C D r..-. = c u 8 c 0 ;_, ..;4. C u CA3 Cii 4r- Usi i'°' ...›.1 0-0) icV1 a Y.) S (....1 in 5 La 44C = , ..a -..1 A CO I E lit •l. " (I) , CI itj . ' k E o ..0 a) fa c Le rtsi w c al r, 0 rin 4.ci ,..: •si its >N. -0 • < c . , . LL 0 . . LCO