The URL can be used to link to this page

Home My WebLink AboutStaff Report 1.A 03/23/2015Agenda Item # LA Water Transmission FY 2015-2016 Draft Budget and Rates The preliminary draft proposed FY 15-16 rates are shown in the table below: z�I[YIF� J �1I1( E .� 1 'j•i ?YfF-I«� '.'.rLl-.� __�%�avT J �j Deliveries (Acre -Feet) 50,590 50,590 50,590 O&M $507.22 $507.22 $507.22 Water Management Planning $3.92 $3.92 $3.92 Watershed Planning & Restoration $79.67 $79.67 $79.67 Recycled Water and Local Supply $15.58 $15.58 $15.58 Water Conservation $40.53 $40.53 $40.53 Total O&M $646.92 $646.92 $646.92 Storage & Common Bond/Loan Charges $78.63 $78.63 $78.63 Sonoma Aqueduct Bond/Loan Charge $62.00 Prime Contractors $725.55 $725.55 $787.55 Discretionary Charges Capital Charges - to build fund balance for future $19.50 $19.50 $39.00 projects Local Recycled Water Tier 2 Program (LRT2) $16.00 $16.00 $16.00 Prime Contractors $35.50 $35.50 $55.00 Total Prime Contractors $761.05 $761.05 $842.55 Total Overall Increase; 4.16% 4.16% 1 6.22% Note: The total rate for the Recycled Water Subfund is the sum of the Subfund plus the LRT2 rate = $31.58 SUMMARY C Deliveries: (Budget Packet Pages 8-13): o These FY15-16 Rates are based on budgeted deliveries of 50,590 Acre -Feet (AF). This is per the Restructured Agreement for Water Supply which states that rates be calculated using th dlesser F: the average of the last 3 years of annual deliveries (52,891 AF) or the last 12 months of actual water deliveries` (50,590 AF). o In FY14-15 the Water Advisory Committee (WAC) approved budgeted deliveries of 46,000 AF due to ongoing druught conditions. o Deliveries for Calendar Year (CY) 2014 were 9% less than CY 2013 and actual deliveries for FY14-15 are projected at less than 50,000 AF. Operations and Maintenance (O&M) -Water Transmission O&M Fund (Budget Packet Pages 14-20): o In accordance with the Restructured Agreement for Water Supply: The rate is calculated by dividing operations and maintenance expenditures (less specific cash and noncash revenues and expenditures) by budgeted deliveries. Sonoma County Water Agency 1 2/27/2015 �tl��IftU1r� S. �. -r .>�. `r ^- - - �� ysr�ii� ' - s.. -t-�-�•�c-� -z r ii r "-'''--�� y-�y.= _� =sem' ,,•-� = ' '� .r- Routine services and supplies are increasing 3.4%. Factors Rate per AF $35.82 7.2% affecting this increase are described below. Attributable to rate increase and 10% increase in budgeted Revenue $4,867,125 13.8% deliveries. Sonoma County Water Agency 1 2/27/2015 e a 1 i`� .tr 1 CIE °3n -y.`I'. x :&.,..,Tt ¢3x �,y-;'St*-, r1k RIME— r 7Yt` { , ffalt £1le" •C w I4 ' rv�. `` i 4 kF 3i3Si .}"t1.i Cly 3ffla&' "£upy Sr{i-d IC nY,R ,S, a..wsa'.:�m4Yi+L.w.SYui.�.._...,d' u... •J m - .a.:. _ 31- "1tiv:_• ... 1•' .w{ i.'", p" Expenditures $5,605,661 13.9% 3.4% of increase is routine services and supplies- See below for other factors affecting the rate. Factors affecting the 0&M rate: 4 � Icy llf l y3j. �i}s V T-tl -. .S"l-4. r,y. zl• �. Ir ..�LY'+4 �3 �+, f � 4.tFi�LS'��`'` Fv} -t, T 4+'3- { Labor $345,000 3.0% Expected to keep pace with the CPI. Expected to decrease over FY13-14 actuals ($4.99 million) Power $400,000 9.1% but increase over FY14-15 budget ($4.4 million) due to increased deliveries. Chemicals -$160,000 -17.8% Expected to be in line with FY13-14 actual expenditures. Contract $560,. 000 629% Expected to increase due to contracts for aqueduct cathodic Services protection projects. Consulting $271,000 ° 27.5/° Expected to decrease and be more closely aligned with actual Services and encumbered consulting services from prior years. Reduced to align more closely with CPI rate increases for Maintenance - routine services and supplies. Maintenance projects occur Equipment & -$213,000 -21.3% according to long term plan. No critical maintenance projects are being differed. New maintenance -infrastructure budget Infrastructure category in county Enterprise Financial System implementation. Small Tools - $60,000 60.0% Expected to be in line with FY13-14 actuals and FY14-15 Instruments estimated expenditures. Operating Transfers (OT's) move revenue generated by rates into respective funds and maintain appropriate fund balance. Operating OT from O&M fund to Common Facilities for capital projects $4,947,000 37.0% has not kept pace with expenditures in Common Facilities Transfers over past three years. Increase in OT required to implement projects and maintain positive fund balance. Majority of OT's do not directly impact rates Note: Numbers rounded to the nearest (1,000). List does not include all 0&M expenditures. m Subfunds: (Budget Packet Pages 21-32): o Subfund rates are calculated by dividing subfund expenditures minus grant revenue by budgeted water deliveries. o Water Management Planning: Expenditures are for Urban Water Management Planning (UWMP) which is required to be updated every five years. In intervening years, the Water Agency typically incurs minimal costs to review regulatory requirements and revise the scope of work accordingly. Sonoma County Water Agency ii 2/27/2015 o Watershed Planning and Restoration: • Expenditures are for planning, design, and implementation of watershed restoration projects and projects required under the Biological Opinion. m gt- Ate: - 17 t t a FY14-15 rate: $0.97; rate needed for Urban Water Rate per AF $0.66 0.8% Management Plan (UWMP) update. Rate subsidized with Rate per AF $2.96 305.6%° fund balance: $205,000 (FYI4-15)and $76,500 (FYI 5-16). Revenue $398,109 10,2% When deliveries are declining due to drought, use of fund Rate per AF $4.02 14.69,16 balance softens impact to rate payers. Revenue $163,460 328.9% Due to rate increase and increase in FYI 5-16 budgeted water Expenditures $711,000 17.9% deliveries as compared to FY14-15 budget. Expenditures 1 $25,000 10.0% Required to update the UWMP due July 1, 2016. o Watershed Planning and Restoration: • Expenditures are for planning, design, and implementation of watershed restoration projects and projects required under the Biological Opinion. o Recycled Water and Local Supply: Expenditures are for planning, design, and implementation of recycled water and local supply projects including water contractor projects under the Local Recycled Water Tier 2 (LRT2) Program. gt- gg t t OR - Rate per AF $0.66 0.8% FY14-15 rate: $79.01. Use of $650,000 in fund balance to reduce rate increase. Revenue $398,109 10,2% Due to rate increase and increase in FYI 5-16 budgeted water Rate per AF $4.02 14.69,16 deliveries as compared to FY14-15 budget. Draft and final flow EIR, climate adaption projects associated Expenditures $711,000 17.9% with the NOAA Russian River Habitat Blueprint program and Revenue $345,139 22.6% the NOAA NIDIS program, and initiation of the design of Dry Creek Habitat Enhancement miles 3, 4, and 5. o Recycled Water and Local Supply: Expenditures are for planning, design, and implementation of recycled water and local supply projects including water contractor projects under the Local Recycled Water Tier 2 (LRT2) Program. o Water Conservation: Expenditures are for water use efficiency projects, outreach, and education. Sonoma County Water Agency iii 2/27/2015 gt- gg t t $15.58 per AF for groundwater management planning; $16 per AF for LRT2 projects per TAC. FY14-15 combined rate of Rate per AF $4.02 14.69,16 $27.56; $349,000 in fund balance to fund portion of City of Santa Rosa LRT2 Projects. Revenue $345,139 22.6% Due to rate increase and increase in FYI 5-16 budgeted water deliveries as compared to FY14-15 budget. $961,500 is to implement Santa Rosa, Petaluma and Sonoma Valley Groundwater Management Planning Projects and Expenditures $299,463 16.5% initiate Sustainable Groundwater Management Act planning activities; $1,157,233 is for City of Santa Rosa's LRT2 Projects. o Water Conservation: Expenditures are for water use efficiency projects, outreach, and education. Sonoma County Water Agency iii 2/27/2015 Rate per AF $1.18 3.0% 1 FY14-15 rate: $39.35. Rate increase consistent with CPI. Revenue $327,595 15.3% Due to rate increase and increase in FY15-16 budgeted water deliveries as compared to FY14-15 budget. Implement water use efficiency, outreach and education Expenditures $263,820 13.1% projects and address ongoing water conservation needs given continued drought conditions. • Storage and Common and Sonoma Aqueduct Bond/Loan Charges: (Budget Packet Pages 44-52): o The rates are calculated by dividing the annual debt service and reserve requirements (2006A and 2012A Water Revenue Bonds and Interfund loans) by water deliveries. The rate decreases shown below can be attributed to the increase in deliveries over the FY14-15 budget. • Aqueduct Capital Charge: (Budget Packet Page 1): o A discretionary charge is added by the water contractors to build fund balance for future aqueduct capital projects and minimize rate spikes. o $19.50 per AF for Santa Rosa and Petaluma Aqueducts o $39 per AF for Sonoma Aqueduct. • We are asking Sonoma Aqueduct contractors to consider the higher aqueduct capital charge to increase their fund balance (at FY14-15 year end, fund balance is projected to be approximately $663), to begin saving for known needed future capital projects. o The FY14-15 budget included a rate of $19.50 for all three aqueducts. • Overall Draft Proposed Rate Increases: (Budget Packet Pages 1-7): 0 4.16% (Santa Rosa and Petaluma Aqueducts) 0 6.22% (Sonoma Aqueduct) o The proposed budget and rates align with the Water Agency's Long Range Financial Plan which shows rate increases of 4-6% allow us to meet our operating and capital needs while minimizing rate spikes. List of Capital Projects - next page. Sonoma County Water Agency iv 2/27/2015 MIMI Storage Bond/Loan ($1.56) -5.9% FY14-15 rate: $26.31. Charge Common Bond/Loan ($13) -19.1% FY14-15 rate: $66.58. Charge Sonoma FY14-15 rate: $60. Sonoma Aqueduct pays an additional Aqueduct ($1) ° -0.9/° revenue bond charge for the bonds associated with the Bond/Loan Eldridge-Madrone Pipeline Project. Charge • Aqueduct Capital Charge: (Budget Packet Page 1): o A discretionary charge is added by the water contractors to build fund balance for future aqueduct capital projects and minimize rate spikes. o $19.50 per AF for Santa Rosa and Petaluma Aqueducts o $39 per AF for Sonoma Aqueduct. • We are asking Sonoma Aqueduct contractors to consider the higher aqueduct capital charge to increase their fund balance (at FY14-15 year end, fund balance is projected to be approximately $663), to begin saving for known needed future capital projects. o The FY14-15 budget included a rate of $19.50 for all three aqueducts. • Overall Draft Proposed Rate Increases: (Budget Packet Pages 1-7): 0 4.16% (Santa Rosa and Petaluma Aqueducts) 0 6.22% (Sonoma Aqueduct) o The proposed budget and rates align with the Water Agency's Long Range Financial Plan which shows rate increases of 4-6% allow us to meet our operating and capital needs while minimizing rate spikes. List of Capital Projects - next page. Sonoma County Water Agency iv 2/27/2015 Capital Projects Pra ectx=d - Petaluma Aq Relocation —Kastania (Caltrans Project) Storage 50,000 Santa Rosa Creek Crossing Pipeline 400,000 LHMP - Program Design (for Future FEMA Funds) Pipeline 15,000 Ely BPS Flood Control & Electrical Upgrade Pipeline 285,000 LHMP - Program Design (for Future FEMA Funds) Pipeline 15,000 Marin Sonoma Narrows Segment C2 Pipeline 50,000 SBS Electrical Upgrade and Pumping Reliability Pipeline 375,000 LHMP- Program Design (for Future FEMA Funds) Pipeline 15,000 Sonoma AQSpring Creek & Bennett Valley Fault Crossing Pipeline 100,000 SBS Storage Building Pipeline 100,000 Isolation Valves (FEMA Funds -$1.9M) Common 3,560,000 Mirabel Fish Screen/Fish Ladder (Dept of Fish and Wildlife Funds -$1.18M) Common 1,500,000 RR Crossing (FEMA Funds - $2.9M) Common 320,000 MW Creek Crossing (FEMA Funds - $2.8M) Common 200,000 Caisson 6 Vaults Common 100,000 Caissons 3, 4, 5 Pump Discharge Valves Common 200,000 Water Agency Westside Facility- offsetting revenue $80,000 Common 80,000 Mirabel Chlorine Lines Replacement Common 250,000 Mirabel Dam Bladder Replacement Common 50,000 Mirabel Storage Building Common 250,000 PH Pump Replacement Common 100,000 RDS Pump Replacement Common 150,000 System wide Meter Replacements Common 300,000 Wohler PDS & Sub Station Upgrade Common 100,000 '..TOTAL 8,565,000 Sonoma County Water Agency v 2/27/2015 Sonoma County Water Agency FYI 5-16 Water Transmission Budget and Rates Budget Packet Page Prime Contractor Rates Summary 1 Water Charges Per Acre -Foot 2 Revenue Summary 3 Deliveries Deliveries 10 vcuvcuca auu ncvcnuc - v r.yucuu... _ Deliveries and Revenue - Petaluma Aqueduct 12 Deliveries and Revenue - Sonoma Aqueduct 13 O&M Subfund Watershed Services 14-18 19 26-27 28-31 Facilities and Other Funds 46 Santa Rosa Aqueduct Capital Fund 33 Petaluma Aqueduct Capital Fund 34 Sonoma Aqueduct Capital Fund 35 Storaae Facilities Cash Summary 36-37 Common Facilities Cash Summary 39-41 North Marin Water Deposit Fund 42 43 Common Bonds 2012 Cash Summary 46 Sonoma Bonds Cash Summary 47 Storage Bonds 2006 Cash Summary 48 Common Bonds 2006 Cash Summary 49 Annd R I nnn Charoes 50-51 Fund Balances and Operating Transfers 52 212 712 01 5 Pq At (6 E E O In w QS L O U c O U d E 'L a cD U - LL Lo o (D N N N W co to to o Cl co (D n (» N a CD (D V-: to v n ta o n N m M m m m a o o o o v o V m O m M N m in n m O m d N m V 1� O M, 6 N N N n m m 6 M M � a tR E VN N r -- 00m N O O m Lo N' Cl) (o c v O Lq (n e> va m into r 3 O r � � O co M fJi 7 O r d' � N � � a• LO (D n vi fPr a, V} EPr fPr �, N N 1— O co N co 0(D 0 o o m o o) (D LO (D O Lq N OO m N O co O th d' �t 1— N N cM ui m C6 m m o m M N M M m a rn v3 � v3 et u> (n vi ei d LO d M u O n IL m m m m T m o o o o m o V m O m M N m m O m m m 0 N r O 6 r 6 NN (6 = � Oi (O � � O cq U fA r� E m U M� c M N M U) O d (� N M O L zm N N O J d m 4 K O Q R rn v L Pr N o N = U "- L Cf) ° a M M V =a «s d m ° Pr m c Lo o (D N N N W co to to o Cl co (D n (» N a CD (D V-: to v n ta N N 1� rb co N CO O 0 0 0 EN OO«') «7m (OO b O O O O O co 03 CD , to 00 C\l r m1— LO = d d' V 1� O M, c(7 O O Lo (o � a tR E VN N r -- 00m N O O m Lo N' Cl) (o O O O O Lq cn into 3 O M 0... � O co M w 7 O r d' d' N m a• LO (D n a, ¢ �, N N 1— O co N co 0(D 0 m N 6) (o (() Lo o) (D LO (D O Lq N OO m N O co O th d' �t 1— cM '=O (o n = a m a rn LO d M u IL T F It Lii m m im L N L V C (6 = C7 m° m U c E U M� c co U) O d (� N L zm N O J d O O O Q rn v L Ol (6 = L O- N o N = U "- L ° a =a «s d m ° m c 1- (/1 FL0 o m O a O , a1- 040 c rn En cr Z ° Z L c 'O C m m° Lc�.= (DL)m R m Q m O U _ U ° mU O U U v rn E W m y �_ W L L d d >, d O - d (C Cc U O'S�w�O Cl)<n Q- arr -ja Lo o (D N N N W co to to o Cl co (D n (» N a CD (D V-: to v n ta O O LL W CO U Q Oa0 m5 W U) O O Z 2 U W Q U �E �wE EL OLL Q LL } 0 UN Z U m - W 0 LO N r M M a. r N m O M Nm M m d' ~ N Cl) N O M V N N V(0 (n VM V' CO f-- Q U V' m (O It O I- N m M N 7 V I� r Cl) O 00 (O V' N O00 I- N 0 r-) CC) j,,r t` Co M V V V v d V M M M Z W OD cn 0 0 ZU v - W 0r Q O coOOM Cl) ON];r M 0: 6] W r m O N U O IA N V' M V r r- N M (n Co m 0 co (O M O I- MO (O c'.: (D LO CONN M CO J O I- r I,- co 0 (O m r Q LU LO V V V' V' It Cl) M M F wd �Q co0 U U I Z W 0 n H O00 OM O .r- W OD M O m N r m m m (O U r O LO N V CO V r I� N M m O V Nr-- Q CO CO O I` M O (O r N_ N (O r-.: M6 ZO O r (fl M M In V' V It r 'V fCD m7 M co C0 U d Q CO (O V M Cl r O m (O I- M (n V M N r x 0 0 0 0 0 0 0 0 0 m V M N O 6l m P- ( LO It M N O x 0 (DC) 0 0 0 0 0 0 0 0 O O O O 0 0 0 0 0 0 0 C":, cc 0 0 N N N N N N" N N 0 N N N N N N N a N N M. W c F-- Of G Q U U U Z Q OCO� C 5� W D Q W - W of W co r Q n LL 0 o a o a o 0 C U N N N m m m m N N N U � W L IL U r r m m m m m m u: rn c� Ci c%� m v r m u� v C O O m m m OJ O O M O t es bs er m ua v� c» csr er uj U m 0 N m m LL) m N Ol e7 (O O m m rLd N cz; 7 7 rn M N N n 0 LL O yy a co — m m m .. v � � en } � v LL Q U1 N (D � U N N U] LL � N N m co 0] O U a I m m v v F— 6 U C C ¢ Q n C , ¢ 2P= N ~ l9 U Q L 7 n O W m m 0 C m d LL Cl) m `o j� U Z LL SONOMA COUNTY WATER AGENCY RATES FOR WATER DELIVERIES IN FY 15-16 IXJESTIMATED 0OFFICIAL Approved by Board of Directors on PRIME CONTRACTORS O&M Charge 14.21 Water Management Planning Sub -charge [4.13] Watershed Planning/Restoration Sub -charge [4.14] Recycled Water & Local Supply Sub -charge [4.15] Water Conservation Sub -charge [4.16] O&M Charge CHARGE PER ACRE FOOT. Santa Rosa Petaluma Sonoma 24.75 Aqueduct Aqueduct Aqueduct $507.22 _ $507.22 $507.22 $3.92 $3.92 $3.92 $78.63 $79.67 $79.67 $79.67 $31.58 31.58 31.58 $40.53 40.53 40.53 19.50 $662.92 $662.92 $662.92 Bond & Loan Charges - to pay for existing debt service Storage Facilities Capital Charge [4.7] 24.75 24.75 24.75 Common Facilities Capital Charge [4.8] 53.88 53.88 53.88 Sonoma Aqueduct Facilities Capital Charges 14.6 b] 62.00 Total Bond & Loan Charges $78.63 $78.63 $140.63 Discretionary: Aqueduct Capital Charges - to build fund balance for future o oiects Aqueduct Facilities Capital Charges [4.6 e] 19.50 19.50 39.00 LRT2 - included in Recycled Water & Local Supply Sub -Charge above. TOTAL PRIME CONTRACTORS $761.05 $761.05 $842.55 Charge without LRT2 and voluntary AO Capital Charge $725.55 $725.55 $787.55 OTHER AGENCY CUSTOMERSIWHOLESALE CHARGES (WATER CO'S & PUBLIC AGENCIES) O&M Charge $662.92.. $662.92 $662.92 Capital Charges 78.63 78.63 140.63 Aqueduct Facilities Capital Charge $269.51 $269.51 $207.51 TOTAL OTHER AGENCY CUSTOMERS/WHOLESALE CHARGES(4.12) x$1,011.06 $1,011.06 $1,011.06 (i20% OF HIGHEST PRIME) FORESTVILLE O&M Charge [4.2]' $507.22. Water Management Planning Sub -charge [4.13] 3.92 Watershed Planning/Restoration Sub -charge [4.14] 79.67 Recycled Water& Local Supply Sub -charge [4.15] 31.58 Water Conservation Sub -charge [4.16] '40.53 O&M Charge $662.90 Bond & Loan Charges - to pay for existing debt service Aqueduct Facilities Capital Charges [4.6]-:. 0.00 Storage Facilities Capital Charge [4.7] 24.75 Common Facilities Capital Charge [4.8] 53.88 Total Capital Charges $78.63 TOTAL FORESTVILLE $741.53 ` 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 $662.92 Note: N. Marin pays North Marin Bond & Loan Charge [4.9] 33.77 bond and loan charge Russian River Conservation Charge 14.18 (a)] 69.38 in lieu of Capital Charge. Russian River Projects Charge [4.18 (b)] 12.39 TOTAL NORTH MARIN WATER DISTRICT 778.46 THIRD OFF-PEAK (MARIN MUNICIPAL) Highest Prime $842.55 Russian River Conservation Charge 69.38 Russian River Projects Charge 12.39 TOTAL THIRD OFF-PEAK $924.32 SUPPLEMENTAL (MARIN MUNICIPAL) O&M Charge $662.92 Capital Charge [4.11 (b)] 96.00 Russian River Conservation Charge 69.38 Russian River Projects Charge 12.39 TOTAL SUPPLEMENTAL $840.69 SURPLUS Non -Municipal / Municipal [4.11 (a)] $795.50 $795.50 $795.50 (120% of O&M Charge) Town of Windsor $913.26 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 14.17 (a)]. Town of Windsor pays all subcharges [4.13, 4.14, 4.15, and 4.161 on all water they divert from the Russian River using their equipment [4.17 (b)]. $913.26 The applicable section of the Restructured Agreement has been indicalfd in brackets. 2272015 FY 2015-16 BUDGET SONOMA COUNTY WATER AGENCY Operations and Maintenance Rate Computation O & M REVENUE REQUIREMENT FY 15-16 ESTIMATED FISCAL YEAR EXPENDITURES $46,037,553 LESS: DepreciationAmortization 5,968,500 Investment Income, Interest on Pooled Cash, Charges for Services 100,000 Power Sales 800,000 PWRPA Pre -paid Expense - FY 08/09 Rate Reduction -One time only "Mandatory Prudent Reserve" charge Recycled Water funds (Sub -object 7277) taken from special reserve 0 Transfers Out 11,632,784 REVENUE REQUIREMENT (Net Expenditures) $27,536,269 O & M ACRE FOOT BASE DELIVERIES: 50,589.8 LESS: Marin Municipal 7,099.0 Surplus (Irrigation) 62.9 TOTAL BASE DELIVERIES 43,428.0 O & M RATE COMPUTATION: Rate = Revenue Requirement - (Marin Muni Off Peak Deliveries x Highest Prime Rate) - (Marin Muni Surplus Deliveries x (O&M Charge + Capital Charge) Total Deliveries - Surplus Deliveries - Marin Muni Past 36 Months Deliveries = 27.536.269 - (4,300.00 x 686.85) - (4,236.11 x 603.22) 50,589.8 - 62.9 - 7,099.0 = $507.2190656940 2/27/2015 FY 15-16 Proposed Water Rates O&M Charge Water Management Planning Sub -Charge Watershed Planning/Restoration Sub-Chargt Recycled Water Sub -Charge FY 14-15 FY 15-16 (Actual) (Proposed) % Change 471.40 507.22 7.60% 0.97 3.92 305.60% 79.01 79.67 0.83% 27.56 31.58 14.58% Water Conservation Sub -Charge 39.35 40.53 3.00% Total O&M Charge 618.29 662.93 7.22% Santa Rosa Aqueduct Rate O&M Charge Aqueduct Facilities Capital Charges [4.6 e] Storage Facilities Capital Charge [4.7] Common Facilities Capital Charge [4.8] 618.29 -; 662.92 7.22% 19.50 19.50: 0.0% 26.31 24.75 -5.95% 66.58 53.88 -19.07% TOTAL 730.68 761.05 4.16% Petaluma Aqueduct Rate 19.50 39.00 100.0% O&M Charge 618.29 662.92 7.22% Aqueduct Facilities Capital Charges [4.6 e] 19.50 19.50 0.0% Storage Facilities Capital Charge [4i7] 26.31 24.75 -5.95% Common Facilities Capital Charge [4.8] 66.58 53.88 -19.07% TOTAL 730.68 761.05 4.16% Sonoma Aqueduct Rate O&M Charge 618.29 662.92 7.22% Aqueduct Facilities Capital Charges [4.6 e] 19.50 39.00 100.0% Storage Facilities Capital Charge [4.7] 26.31 24.75 -5.95% Common Facilities Capital Charge [4.8] 66.58 53.88 -19.07% Sonoma Aqueduct Facilities Capital Charge! 62.56 62.00 -0.89% TOTAL 793.24 842.55 6.22% 6 2/27/2015 SONOMA COUNTY WATER AGENCY RUSSIAN RIVER CONSERVATION CHARGE COMPUTATION FISCAL YEAR 2015-16 PROPERTY ASSESSMENT VALUES AS OF FY 14-15: TAX CODE ENTITY SECURED UNSECURED TOTAL VALUE 14000 Forestville Co Water District 333,262,608 2,609,667 $335,872,275 42800 City of Cotati 871,460,968 18,054,724 889,515,692 43500 City of Petaluma 7,837,328,840 372,952,708 8,210,281,548 43800 City of Rohnert Park 3,950,498,159 119,758,987 4,070,257,146 44500 City of Santa Rosa 18,969,884,670 663,518,433 19,633,403,103 45000 City of Sonoma 2,124,813,821 64,407,786 2,189,221,607 Valley of the Moon Water District 2,675,850,964 20,181,131 2,696,032,095 TOTAL $36,763,100,030 $1,261,483,436 $38,024,583,466 Notes: 1 Total value of secured and unsecured property in service areas of Prime Water Contractors of Sonoma County (see above) $38,024,583,466 2 2011-12 Sonoma County tax rate per $100 of full cash value assessed for payment of Warm Springs Dam Project Obligations 0.007 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,661,721 4 Total acre feet of water delivered to Prime Water Contractors of Sonoma County (excluding North Marin and Town of Windsor) plus deliveries to Forestville 38,367.05 during the prior 12 month period ending March 31. 5 Total Russian River Conservation Charge per Acre Foot (Line 3 / Line 4) $69.38 Russian River Projects Charge RR Conservation Charge Historical calculations Historical calculations For FY Calculated Actual Charge 05-06 24.23 $ 20.00 $ 45.06 06-07 17.02 $ 17.02 $ 48.33 07-08 21.4 $ 20.00 $ 52.70 08-09 25.08 $ 20.00 $ 58.44 09-10 24.68 $ 20.00 $ 57.70 10-11 24.4 $ 20.00 $ 74.62 11-12 23.44 $ 20.00 $ 72.27 12-13 20.38 $ 20.00 $ 72.08 13-14 14.72 $ 14.72 $63.30 14-15; 8.727 $ 8.72 $63.90 15-16 12.39: $ 12.39 ':$69.38 'FY1'4-15 7-1&86 rate for half of yr following removal of $6M in add'I water rights revenue per county counsel FY0506 First FY with 10 full years of data. 7 2/27/2015 SCHEDULE OF WATER DELIVERIES BY AQUEDUCT PAST 36 MONTHS / 12 MONTHS AVERAGE DELIVERING AQUEDUCT Monthly Santa Rosa Petaluma Forestville Sonoma Total 36 Jan -12 1,169.7 1,808.7 19.4 264.7 3,262.3 35 Feb -12 1,138.5 1,744.8 20.9 242.2 3,146.4 34 Mar -12 1,175.7 1,682.8 19.5 246.6 3,124.7 33 Apr -12 1,161.4 1,663.4 21.1 265.5 3,111.4 32 May -12 1,921.6 3,012.8 43.1 561.9 5,539.3 31 Jun -12 1,941.7 2,879.0 43.5 480.8 5,345.0 30 Jul -12 2,688.8 3,451.2 57.7 644.2 6,841.9 29 Aug -12 2,318.3 2,641.9 48.6 511.9 5,520.8 28 Sep -12 1,975.2 2,366.6 50.2 477.7 4,869.8 27 Oct -12 2,282.41 2,544.1 48.3 503.7 5,378.5 26 Nov -12 1,221.0 1,655.1 23.2 266.6 3,165.8 25 Dec -12 1,129.9 1,718.5 19.7 231.2 3,099.2 24 Jan -13 1,384.5 1,950.0 "24.6 287.1 3,646.1 23 Feb -13 1,188.2 1,574.1 23.4 240.4 3,026.1 22 Mar -13 1,317.5 1,724,9 23.2 312.8 3,378.4 21 Apr -13 1,839.4 2,4728 34.0 436.0 4,782.2 20 May -13 2,150.0 2,558,5 44.4 484.1 5,237.0 19 Jun -13 2,115.7 2,664.0r 42.7 475.6 5,297.9 18 Jul -13 2,768.2 " 3,215.1 52.5 622.8 6,658.6 17 Aug -13 2,023.7 2,499 .7 44.9 481.9 5,050.2 16 Sep -13 1,992.1 2,560.3 46.5 460.5 5,059.4 15 Oct -13 2,060.9 2,765.2 4Z2 524.0 5,397.4 14 Nov 13 1,398.0 2,108.6 29.4 354.8 3,890.8 13 Dec -13 1`,426.6 2,492.7 29.2 304.5 4,253.0 12 Jan -14 1,248.2 2,096.2 22.7 354.4 3,721.5 11 Feb -14 1,103.1 2,156.5 18.6 230.8 3,509.0 10 Mar -14 1,113.1 2,016.6 18.0 247.1 3,394.8 9 Apr -14 1,474.6 2,619.0 27.0 328.5 4,449.0 8 May -14 1,614.8 2,457.7 36.0 389.3 4,497.8 7 Jun -14 '- 1,770.4 2,607.8 38.1 433.3 4,849.6 6 Jul -14 2,1354 3,092.7 51.7 535.6 5,815.5 5 Aug -14 1,623.8 2,090.5 39.4 389.2 4,147.9 4 Sep -14 1,832.5 3,131.9 44.1 435.8 5,444.3 3 Oct -14 1,432.4 2,108.1 29.9 325.8 3,896.1 2 Nov -14 1,077.8 1,854.4 22.1 228.5 3,182.8 1 Dec -14 1,274.4 2,165.9 21.4 219.8 3,681.4 Total Deliveries 59,494.3 84,152.3 1,226.1 13,799.4 158,672.2 3 -Year Annual Average 19,831.4 28,050.8 408.7 4,599.8 1 52,890.7 Past 12 Months 17,705.5 28,397.3 369.0 4,118.1 50,589.8 Total Deliveries 59,494.3 84,152.3 1,226.1 13,799.4 158,672.2 Less: North Marin 23,494.4 23,494.4 Marin Municipal 21,296.9 21,296.9 Sonoma Co. Deliveries 59,494.3 39,361.0 1,226.1 13,799.4 113,880.8 3 -Y -ea rAnnualAverage 19,831.4 13,120.3 408.7 4,599.8 37,960.3 W a 0: W 0 O I- U) D C) U } m W w LL w Of Z_ 1/] U wa IY C w y > tp J y W Ujr:N >- F Z3o W N Q Q Q Z m O W W Q w OU } d Z Q (7 �F o OQof LL = O~ M Z J r O�> ZWD p=Z U)� J O O m m N r (O M V' v m V m O m 0 i v I- O N O) m Q W �OONMaON '-MO7MWOCm 0 O NN M N m O m m 0 m v m r 0 N r M m m m � (D m1�m rNr m O a m m my mO m r,�mm mC] fl. Nv mOION Oi m O Om v UM O m 0 N v N t v r r 0 M 0 0 0 N N O O N r W O m m O M m O r f r N v c 0 m U InvM rm N m m O O ct r r N N m O m V' [ 0 m r m 0 f 0 m v I� 00I� m > v m m m m n m ltO m o m O N U O O m f 0 -CO- 0 COrO Z r N m I� m MJ O" M w O r V vat V> O m r v NOON F_ m yr C6m10 U1 Nm nM 6O 6 e'OO N - N O O N m U M�(n0m vv�mN rr N 1� LLQ] � O r r m 1+i omrmmrr< m COCO m LL 6Nr6o66m6C6 6666aN6rI_� 6 vOOv a W N M r v O O V r M O LL] m cV t_�] 067 mm mN m ma OO t_: 6 6 �N dv NO OO .N- lmL [m6 6 C v v O [`] m 1� 10 10 10 N f0 V t� O m N :r M O CJ v u-7I�mN rN m m .-- Q - m v m m r v m m O f N U] 1� m 'V I� O O m f0 r O O I r m J M m m N M m O m 1 . m O :O r mo_" O O v v 16 S O m ro M N N V N r l0 m m m N v L m mrMNMMMN m(+I(OM-.O100m CONN m zS r ro O NN N ct rm�W Comm O N m rmvinmu'�I�1nm mmrvOMOMN v COMM m } ov�Nai u'i uirlri 661,: oc6N666 4 o o r� r Q mvf mi mm Mr M m m r c+i v 7 m v I� O m O LLJ N r O m N C t Of O f0 O O m M O LL. 01 N(V cV mm ONm ism 4O I. -r O 0' 16 OO OO m LL O m m m I m N m CC__ m M O N O t C o O m Q O v V N V' M O m 17 r r r Om - r N m r. r v N m m m N m O M O M( M O t o m 4 O m m O m m wM=M NM mu] Qlmm O m000r m O OIC C w O v O N m N m m 0 t r �O r m 0 r r N M CM-MrMvmn MovMl Momm i� Id o rnm 1n z1� n m m NO r N M r moi' O N O O O N O V' O O LL] Q �1m0�Nv mm(DO N- N (0 0 r N r m r ci U) of 0O U O U y Q n � m Q 1n vi U m0 0Q 0.0 W W Q Q U UY U O N OMQi cG NQ QU fn o UU 3��E10(7 O po mQU w K E `° r m m o U v m� Q m- Ir E U) E� W Z v m m c cc w m m O J W 003 m.-�E 2 w 30 o0mow Uo �cmca > m c c m c o m m - U m a (A 2 o U N N O R' J c L c 0 3 m > 0>>> I- Y c cq m 0_ U W U7 rqd O�U�(Awd Qv a °1v= 0 0 00 Q 0 � c c cm O w.`.�:w- O„ O J S N pl'00 �,� C7 C7 C7 J W:E J O O O J J O O O L O O C O Q W c c C 3 NQ a C 4. " Q Q c L L L I- Ll O] Ol OI f H a_ ZUUIo- U>I- O�d�Yt 000 O� cn= �0 v o <Zl N N N r v "t r N a v m r N 7 N r N ? 0 H w 0 § / G § » LL � � \ k LVA \( } \ \ \ \� m to 7§ < (n ujw \/ < w cn LU W � ruj � � y /\\ ^kcn j S §- w0 d LU \ ` \ k § 0 ) / \ 7 § ° z j \ U) \ j \ \ m ) ) E $ § ; w 2 � \ y \ \ } 0 \ \ \ \ ( \ § \ \ § \( } \ \ \ m to 7§ < (n ujw LU W � ruj � � y ^kcn j S §- LU \ ` \ \ § 0 ) / \ 7 § ° U) \ j \ \ § ) ) 00 \ , 2 'Wn V m Lh N N r LL a c 7 LL T U C d m Q E Y T N C O Lo N E N C R Y R C .rt W z z W > W K ❑ W Q F- F- F - U) w J F- O F- v m m m r r WW _ WW urns .N- O ~ a z < Z a z urn M v u r r WC4 rn r F W W W N rn r m m h a] m iii ai n r> o v ❑ ai v N vi � o F N ❑ aF � W N a Z Q y � aF a Q W Z N a: Q] Lo N N 1p .L6 t;0 6 O 6 O N O O W W W 'w r r r Q w iz W O W > O O O p F❑ n n r r n r W W W r w W Q ❑ Q W Q � _ N m rG W > v J Ot L N } � L U 3l U f0 N O CN V n 0 z c N N N w Qrn w O R O O t a < U c$ n o W 7 m a ~ a z w v a o N w s O c R U m J m 0 � N a } fA W v m T v C o 0 J N U U R W w O1 x U L w W ry a U V w a U m U � a = 3 V w W W z z W > W K ❑ W Q F- F- F - U) w J F- O F- r o o 0 WW N O < Z a z v M W n v rn r F W W ai v N vi � o ❑ W N aF a Q Z N a: W O O O O O p F❑ n n r r n r W W W r w Q W rG W > J 0 W a O N N N t U S] C m O V J N a } d n m L U C o 0 U R W w O1 U L w w a U m U � a = m V w W ) J U U i W = W c n w w LLmui U m i Q KQ z LL m o a a o O JR m E E E J 2 _`o c vJ a Q z to U O~ Q Q F- F- O a z U ol W W z z W > W K ❑ W Q F- F- F - U) w J F- O F- F W 0 D to (D O N U - LL v C 3 U- C C d m Q Ol T fn C O .y O E N C R F- Y R r! u ❑ w Q F N W [O 4 r N v r r m W w v o m aZ Nn rn u� v w m N N m V N w N W W r N r m Rl r n v F (/1 ai v ci o W Q N m Z p � N Q W F K N cc`.c mm c . 01- ❑ = m m. - M cn W. W W Q W W 'L W > I.., K J m m m m m W W W N N N N W Q ❑ i 1 1 1 1 1 1 -KJ m � � W Q ❑ V A U U v K UC U ) p U n m U v (A w W n o o T d m J a a C m � � N N n d UQ m J Z W m ac Q J C 3 w r E E O .� J Q p U y ry N Z h o a >� N m N C > C o tl GJ W m N v rn m m a Q W W 0 T N U N> >W >N r m U ❑ > ZU w J p J > W m a N v N W Q F N v U) U .� r v cn o v W W v o m h Z o m m Q Z m r n n W N F W W r ai v ci o N m ❑ F N Q W Q F K N W ❑1-❑ m m m m m W W W N N N N < � W W > 1 -KJ W Q ❑ v m L U a C m � V J N N 9 C a7 m `m N > m ^ R L U a C o o r m �° tl GJ W m m N v rn m m a Q L U W 0 U m 0:LU U m U ❑ ZU J p J > W N N W - F N v U) U .� w la. Z ti ¢ F Q KQ o C o tO E 3 � p U Q ❑ o O I.Q., J Q Z m U (4 o F QI ❑ EL z U m W 0 m O N LL LL a c LL LL T U C N rn QC G >. a O N N E N C m a L� N N -r- 2 U L N zi c4 C O y W Cf) ti Z Q w LU W LUQ 0 c1-� C W U L11 Q O Z O N m W W r F Q Z m Z O W N F W W N cl N r O W N Q W F h w N W m ❑ h ❑ W W w Q W 2w> f- K J W Q O r 0 O O W Q U Z U w �w of o O Q y 2i w O J Z Q O N CO w w Q 3 w z 2 W W K W a m w J 0 F r o o m rn W W W W 7 C rn - m r O Q Z r F Q Z .6 N o C m P � w ui LL of 7 W p W W W ix W N r m nJ O c'l QI f O O r M P O ❑ 61 R [7 N N RJ N Q F p m ❑ Q Z W F Ix m U) Q F W Q m m m wwW F m N Q !Wi w W � W > m F R J m m m m ❑ ❑ wwww m U W P P P P w of W Q O Q LL W � m _ N W �2 W i ? N m w A t UI N O1 'T.0 W Q ❑ U d O U � v m U W N c O T w J Q m m n m N U 'C O n U K m m w ry j 1- z W w a c m o J c 3 Wm w E`mz C 3 J m Q F a U m P J OF ul c m D w o c 0 a m m W w w T w rn J jp N U N w a w O w V w L7 m a w m 'a d W 3 w z 2 W W K W a m w J 0 F r W W 7 C rn - m m r F Q Z m O .- N ui LL of 7 W W W O m m O O r m O 61 R [7 N RJ N m m ❑ W m Q F Q Z F m N W m m m m m ❑ ❑ wwww C P P P P w of Q LL W �2 W i F m J W Q ❑ v t U � c m Q P J N a m rn m w a O V w L7 m w m 'a d W LW Q U 0 U K U d U =3 U = V W U J U U i w w F Q W w EL N w= D N m �- F W -rs Z LL m Q C9 Q w C o m E o J O U to Q J Q Z n 0 Q Q t- ❑ a o U w w z 2 W W K W a m w J 0 F r FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: 1water Transmission System Agency Fund Section/Fund No: 44205 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change BEGINNNG FUND BALANCE 12,438,163 5,132,113 5,007,959 REVENUES USE OF MONEY/PROPERTY 44002 Interest on Pooled Cash 126,837 64,262 60,000 60,000 44003 Other Interest Earnings 0 0 0 0 44109 Concessions 0 0 0 0 44101 Rent- Real Estate 450 1,000 0 0 SUBTOTAL 127,287 65,262 '-60,000 60,000 INTERGOVERNMENTAL REVENUES 42358 State Other Funding 35,560 0 0 -- 50,000 42401 Federal Public Assist Admin 0 0 0 0 42461 Federal Other Funding 4,080 0 0 0 42510 Other Governmental Agencies 0 -:0 '- 0 0 42610 Other Governmental Agencies 0 0 0 0 SUBTOTAL 39,640 0 0 50,000 MISCELLANEOUS REVENUES 46040 Miscellaneous Revenue 27,582 26,949 0 0 46029 Donations/Contributions 4,000 0 0 40,000 46050 Cancelled/Stale Dated Warrants 0 0 0 0 46027 Insurance Claims Reimbursement 0 0 0 0 46021 Capital Grants - Federal (4,080):. 0 0 0 46040 Miscellaneous Revenue 69,766 0 0 0 46200 Revenue Appl PY Misc Revenue:.. 4,925 19,537 0 0 SUBTOTAL 102,193 46,486 0 40,000 MISCELLANEOUS REVENUES 45223 Sewer/Water Hook up Fees 26,184 0 0 0 45313 Sale - Water 0 0 0 0 45313 Sale - Water 0 0 0 0 45313 Sale - Water 0 0 0 0 45313 Sale -Water 0 0 0 0 45313 Sale - Water 0 0 0 0 45313 Sale - Water 0 0 0 0 45314 Sale - Power 715,029 800,000 800,000 800,000 45065 Inspection Fees (3,998) 0 0 0 45062 Construct/Bldg Permit Rvw Svcs 20 0 0 0 45223 Sewer/Water Hook up Fees 0 30,266 0 0 45301 Charges for Services 0 0 0 0 45315 Sale- Water, Wholesale 25,709,139 23,848,091 22,861,396 27,170,774 45323 Common Fac Rev Bond Chg 2,559,710 2,279,929 2,279,125 1,841,731 45324 Storage Fac Rev Bond Chg 812,190 900,945 900,703 845,815 45325 Sonoma Aqueduct Rev Bond Chg 299,576 250,924 262,316 255,333 45326 Petaluma Aqueduct Rev Bond Chg 0 0 0 0 45327 Santa Rosa Aque Rev Bond Chg 521,604 330,814 433,516 433,323 45328 Petaluma Aqueduct Cap Chg 386,780 280,061 453,155 273,495 0 0.00% 0 N/A 0 N/A 0 N/A 0 0- 50,000 N/A 0 N/A 0 N/A 0 N/A 0 N/A 50,000 N/A 0 40,000 0 0 0 0 0 H11111101, 0 0 0 0 0 0 0 0 0 0 0 0 4,309,378 (437,394) (54,888) (6,983) 0 (193) (179,660) N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A 0.00% N/A N/A N/A N/A 18.85% (19.19%) (6.09%) (2.66%) N/A (0.04 (39.65%) 14 2/27/2015 Section Title: lWater Transmission System Agency Fund Section/Fund No: 44205 45330 North Marin Rev Bond Chg Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change 45329 Sonoma Aqueduct Cap Chg 246,221 80,303 81,765 170,423 88,658 108.43% 45330 North Marin Rev Bond Chg 249,620 397,308 325,592 263,737 (61,855) (19.00°/x) 45331 Water Mgmt Plan/Restore Chg 53,708 48,940 44,500 198,500 154,000 346.07% 45332 Watershed Plan/Restore Chg 4,688,957 3,997,147 3,634,500 4,030,500 396,000 10.90% 45333 Recycled Water& Local Supply 1,398,964 1,394,321 1,267,819 1,597,600 329,781 26.01% 45316 Water Conservation 1,936,199 1,990,600 1,810,000 2,050,281 240,281 1328% SUBTOTAL 39,599,903 35,629,651 35,154,387 39,931,512 4,777,125 13.59% MISCELLANEOUS REVENUES 46022 Capital Grants - State 0 0 0 0 0 N/A 15 2/27/2015 0 a 0 0 0 0 OTHER FINANCING SOURCES 47002 Sale of Capital Assets 30,983 0 ` 0 ;. 0 0 N/A 47101 Transfers In -within a Fund 0 0 0 0 0 N/A. SUBTOTAL 30,983 0 i:0 0 0 0 TOTAL REVENUES 39,900,007 36,741,399. 35,214,387 40,081,512 4,867,125 13.62% EXPENDITURES SERVICES AND SUPPLIES 52021 Clothing, Uniforms, Personal 9,189 '. 7,477 10,000 10,000 0 0.00% 51902 Telecommunication Usage 84,113 70,000 70,000 80,000 M000 14.29% 52031 Food 631 525 0 669 669 N/A 52041 Household Supplies Expense 0 0 0 0 0 N/A 52042 Janitorial Supplies 0 0 0 0 0 N/A 51032 Janitorial Services 0 228 0 300 300 N/A 51042 Insurance - Premiums 0 0 0 0 0 N/A 51042 Insurance - Premiums 0 0 0 0 0 N/A 51061 Maintenance - Equipment 846,248 1,000,000 1,000,000 754,000 (246,000) (24.60%) 51061 Maintenance - Equipment 491 0 0 0 0 N/A 51071 Maintenance - Bldg & Improve 72,616 44,903 0 0 0 N/A 51072 Landscaping Services 2,355 3,511 5,000 3,000 (2,000) (40.00°/x) 51071 Maintenance - Bldg & Improve 0 0 0 0 0 N/A 52081 Medical/Laboratory Supplies 29,034 35,338 35,000 35,000 0 0.00% 52091 Memberships/Certifications 40,512 40,000 40,000 42,000 2,000 5.00% 52101 Other Supplies 0 0 0 0 0 N/A 52111 Office Supplies 9,808 6,247 5,000 6,000 1,000 20.00% 52117 Mail and Postage Supplies 3,434 4,000 4,000 4,000 0 0.00% 52115 Books/Media/Subscriptions 101 1,300 0 1,000 1,000 N/A 51241 Outside Printing and Binding 3,034 2,100 3,000 4,000 1,000 33.33% 52111 Office Supplies 18,153 20,000 30,000 25,000 (5,000) (16.67°/x) 51249 Other Professional Services 0 0 0 0 0 N/A 51249 Other Professional Services 4,239 1,000 0 0 0 N/A 15 2/27/2015 Section Title: Water Transmission system Agency Fund Section/Fund No: 44205 Account Title Actual Estimated Adopted 2013-14 2014-15 2014-15 Requested 2015-16 Difference Percent Change 51248 Micrographics/Microfilm Svc 0 0 0 0 0 N/A 51231 Testing/Analysis 119,776 135,600 135,000 13U,Uuu (0,uuu) (3.1u%0) 51209 Information Tech Svc (non ISD) 1,565 9,550 12,000 5,000 (7,000) (58.33%) 51201 Administration Services 0 0 0 0 0 N/A 51917 District Operations Chgs 11,413,951 11,500,000 11,500,000 11,845,000 345,000 3.00% 51803 Other Contract Services 1,741,080 890,000 890,000 1,450,000 560,000 62.92% 51230 Security Services 0 1,000 0 0 0 N/A 51226 Consulting Services 328,145 986,000 986,000 715,000 (271,000) (27.48%) 51244 Permits/License/Fees 47,391 40,000 40,000 40,000 0 0.00% 51213 Engineer Services 0 0 0 0 0 N/A 51217 Feasibility Study 0 0 0 0 0 N/A 51211 Legal Services 19,324 30,000 30,000 20,000 (10,000) (33.33%) 51249 Other Professional Services 0 0 0 0 0 N/A 51242 Bank Charges 0 0 0 0 0 N/A 51221 Medical/Laboratory Services 0 54,000 0 0 0 N/A 51249 Other Professional Services 0 0 '0 0 0 N/A 51249 Other Professional Services 0 0 0 0 0 N/A 51301 Publications and Legal Notices 630 2,000 2,000 1,000 (1,000) (50.00%) 51401 Rents and Leases - Equipment 159,470 150,000 :150,000 .155,000 5,000 3.33% 51421 Rents and Leases- Bldg/Land 1,273 1,412 0 '` 1,300 1,300 N/A 52141 Minor Equipment/Small Tools 169,236 160,000-. 100,000 160,000 60,000 60.00% 52143 Computer Software/Licensing Fees 15,595 20,000 10,000. 20,000 10,000 100.00% 52142 Computer EquipmentlAccessories 0 :10,000.'' '::.-10,000 0 (10,000) (100.00%) 52162 Special Department Expense 0 .;30,000 0 0 0 N/A 52162 Special Department Expense 810 0 0 0 0 N/A 52162 Special Department Expense 0 -' 0 0 0 0 N/A 52163 Professional Development 0 '. 0.., 0 0 0 N/A 51225 Training Services 8,656 15,000 15,000 12,000 (3,000) (20.00%) 51225 Training Services 0 0 0 0 0 N/A 52061 Fuel/Gas/Oil 30,218' 15,000 6,000 15,000 9,000 150.00% 51921 Equipment Usage Charges 555,675 600,000 600,000 560,000 (40,000) (6.67%) 52072 Chemicals 742,862:0 850,000 900,000 740,000 (160,000) (17.78%). 51244 Permits/License/Fees 0 0 0 0 0 N/A 52171 Water Conservation Program 0 0 0 25,000 25,000 N/A 52162 Special Department Expense 0 0 0 0 0 N/A 52162 Special Department Expense 0 0 0 0 0 N/A 52162 Special Department Expense 0 5,000 5,000 5,000 0 0.00% 52162 Special Department Expense 0 25,000 25,000 0 (25,000) (100.00%) 51922 County Car Expense 0 0 0 0 0 N/A 51602 Business Travel/Mileage 25,046 15,000 15,000 15,000 0 0.00% 51605 Private Car Expense 2,964 2,000 2,000 2,000 0 0.00% 52191 Utilities (3,974) 13,000 13,000 0 (13,000) (100.00%) 52193 Utilities -Electric 4,991,144 4,600,000 4,400,000 4,800,000 400,000 9.09% 51801 Other Services 0 0 0 0 0 N/A 51216 Lobbyist 0 51,803 0 52,000 52,000 N/A 51077 Maint-Infrastructure 0 33,006 0 33,000 33,000 N/A SUBTOTAL 21,494,796 21,481,000 21,048,000 21,766,269 718,269 3.41% OTHER CHARGES 53103 Interest on LT Debt 0 0 0 0 0 N/A 53103 Interest on LT Debt (1,574) 0 0 0 0 N/A 53402 Depreciation Expense 5,446,522 5,727,000 5,727,000 5,727,000 0 0.000, 53401 Amortization Expense 240,716 241,500 241,500 241,500 0 0.00% 16 2/27/2015 Section Title: lWater Transmission System Agency Fund Section/Fund No: 44205 Actual Estimated Adopted Requested Percent (Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change b3bU1 contributions 0 30,000 U U U N/A 53403 Loss - Disposed Capital Asset 0 0 0 0 0 N/A SUBTOTAL 5,685,664 5,998,500 5,968,500 5,968,500 0 0.00% 19831 CIP - Bldg & Impr 470 0 0 0 0 N/A 19831 CIP - Bldg & Impr 0 0 0 0 0 N/A 19831 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19820 Machinery and Equipment 299 0 60,000 0 (60,000) (100.00%) 19824 Computer Equipment 0 0 0 0 0 N/A 19820 Machinery and Equipment 0 0 0 0 0 N/A 19820 Machinery and Equipment 0 0 0 0 0 N/A 19822 Mobile Equipment 0 0 0 0 0 N/A 19820 Machinery and Equipment 0 0; -0 0 0 N/A 19840 Work in Progress - Eqt 0 46,000 `- ' 0 0 0 N/A 19832 CIP - Bldg & Impr 0 250,000 0 ':.. 0 0 N/A 19851 Intangible Assets - Non -amort 37,741 22,100. 0 0 n N/A 19841 Work in Progress - Intang 21,600 SUBTOTAL 38,509 339,700 - 60,000 0 (60,000) (100.00°/x) OTHER FINANCING USES 57011 Transfers Out- within a Fund 23,508,598 -15,014,854 13,355,392 18,302,784 4,947,392 37.04% SUBTOTAL 23,508,5985; 15,014,854 13,355,392 18,302,784 4,947,392 37.04% APPROP. FOR CONTINGENCIES 55011 Appropriation for Contingent 0 0 0 0 0 N/A SUBTOTAL 0: 0 0 0 0 N/A ADMIN. CONTROL ACCOUNT - 59004 Administrative Control Account ': :0 282,562 282,562 0 (282,562) (100.00%) 59005 Admin Control Acct Clearing 0 (282,562) (282,562) 0 282,562 (100.00%) SUBTOTAL 0 0 0 0 0 N/A PRIOR YEAR ENCUMBRANCE EXPENSE 51,059,072 42,834,053 40,431,892 46,037,553 5,605,661 13.86% Depreciation/Amortization 5,687,238 9614 PY Enc - Maintenance Equir 152,940 0 0 0 0 N/A 9618 PY Enc - Maintenance Bldgs_ 8,148 0 0 0 0 N/A 9640 PY Enc - Office Expense 0 0 0 0 0 N/A 9650 PY Enc - Profess / Special 170,417 0 0 0 0 N/A 9688 PY Enc - Small Tools / Instn 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 0 0 0 0 0 N/A SUBTOTAL 331,505 0 0 0 0 N/A TOTAL EXPENDITURES 51,059,072 42,834,053 40,431,892 46,037,553 5,605,661 13.86% Depreciation/Amortization 5,687,238 5,968,500 5,968,500 Outstanding Encumbrances - (Decrease) Ft (548,437) 0 0 17 2/27/2015 Section Title: Iwater Transmission System Agency Fund Section/Fund No: 44205 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change Capitalized Interest (1,574) 0 0 Gain/Loss of Disposal of Fixed Asset (69,766) 0 Cash Movement from RESCO JV FYE 12-1 (1,214,445) ENDING FUND BALANCE 5,132,113 5,007,959 5,020,419 Operations and Maintenance 675108 Fund Balance Reserve Goal Over/(Under) Goal 5,501,942 (481,524) 18 2/27/2015 Water Transmission System Agency Fund Major Services & Supplies Expenditure Items Actual Adopted Requested Percent FY 13-14 FY 14-15 FY 15-16 Difference Change 51061 Maintenance -Equipment 846,248 1,000,000 754,000 (246,000) -24.6% Reduced to maintain routine O&M at CPI & CCI. No critical projects deferred. 51071 Maintenance - Bldg & Improve 72,616 0 0 0 NA Reflects level of expected expenditures. -17.8% Anticipated costs based on prior year actuals. 52091 Memberships/Certifications 40,512 40,000 42,000 2,000 5.0% Reflects level of expected expenditures. 9.1% Reflects level of expected expenditures in comparison to prior year actuals. 52111 Office Supplies 18,153 30,000 25,000 (5,000) -16.7% Reduced to more closely reflect prior year actuals. 51231 Testing/Analysis 119,776 135,000 '130,000 (5,000) -3.7% Reduced to more closely reflect prior year actuals. 51917 District Operations Chgs 11,413,951 11,500,000 11,845,000 345,000 3.0% Labor expected to keep pace with the CPI and CCI. 51226 Consulting Services 328,145 986,000 - 715,000 (271,000) -27.5% See attached list. Reduced to more closely align with actual and encumbered consulting services from prior years. 51211 Legal Services 19,324 30,000 20,000 (10,000) -33.3% Anticipated costs based on prior year actuals.'.. 52141 Minor Equipment/Small Tools 169,236 100,000 160,000 60,000 60.0% Anticipated higher costs based on prior year actuals 52143 Computer Software/Licensing Fees „15,595 10,000 20,000 10,000 100.0% Reflects level of expected expenditures 51921 Equipment Usage Charges 555,675 600,000 560,000 (40,000) -6.7% Anticipated costs based on prior year actuals. 52072 Chemicals 742,862 900,000 740,000 (160,000) -17.8% Anticipated costs based on prior year actuals. 52193 Utilities -Electric 4,991,144 4,400,000 4,800,000 400,000 9.1% Reflects level of expected expenditures in comparison to prior year actuals. 19820 Machinery and Equipment 299 60,000 0 (60,000) -100.0% Anticipated costs based on prior year actuals 19 2/27/2015 FY2015-2016 Water Transmission System Agency Fund 51061 IMaintenance - Equipment AMOUNT 1 Electrical Supplies and Maintenance Services 155,000 2 Grounds Maintenance 30,000 3 Hardware and Miscellaneous Supplies 125,000 4 Pump and Pipeline Supplies and Maintenance Services 155,000 5 Reservoir Fall Restraints 100,000 6 RR-Cotati Intertie - Cathodic Protection Upgrade 15,000 7 Safety Equipment and Safety Equipment Testing 30,000 8 Santa Rosa Plain Well Monitoring Program (SCWA Wells) 25,000 9 Wilfred Booster Station 40,000 10 Mirabel Flaw meters 51803 Total $ 675,000 51803 Other Contract Services AMOUNT 1 Cotati Tank No 3 Coating Repairs 300,000 2 Recoat Kastania Tank 200,000 3 Petaluma Aqueduct cathodic protection upgrade 710,000 4 Santa Rosa Aqueduct Cathodic Protection Upgrade 50,000 5 Riverfront Park Maintenance 90,000 6 Miscellaneous Contract Services 100,000 7 Legislative Advocacy - Federal 51803 Total $ 1,450,000 51226 lConsulting Services AMOUNT 1 Aqueduct Condition Assessments 70,000 2 BAIRWMP 30,000 3 Collector Capacity Study ,. i 180,000 4 Community Outreach Program 5,000 5 Groundwater Banking Feasibility - Pilot Studies 40,000 6 LBNL Wohler Geophysics (phase 2 & 3) 50,000 7 Legislative Advocacy - Federal 50,000 8 Legislative Advocacy - State 25,000 9 LHMP - program planning 5,000 10 Mirabel Flaw meters 5,000 11 NCIRWMP 30,000 12 Quagga Mussel Program 25,000 13 SCYEC 20,000 14 Strategic Partnerships Initiative 10,000 15 Tank Inspection & Cleaning 70,000 16 Transmission System Hydraulic Modeling Transients 30,000 17 USGS Water Quality (Diversion Facilities) and SW/GW Studies 70,000 51226 Total 715,000 20 2/27/2015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: 1water Management Planning Section/Fund No: LIL210 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change BEGINNING FUND BALANCE 357,801 409,666 313,802 REVENUES USE OF MONEY/ PROPERTY 44002 Interest on Pooled Cash 2,496 2,100 2,100 2,100 0 0.00% SUBTOTAL 2,496 2,100 2,100 2,100 0 0.00% Intergovernmental Revenue 42619 Town of Windsor 2,991. 3,096 3,096 12,556 9,460 305.55% SUBTOTAL 2,991 3,096 3,096 12,556 9,460 305.55% OTHER FINANCING SOURCES 0 51921 Equipment Usage Charges 0 0 0 52171 Water Conservation Progran 47101 Transfers In -within a Fund 53,708 48,940 44,500 198,500 154,000 346.07% SUBTOTAL 53,708 48,940 44,500- 198,500 154,000 346.07% TOTAL REVENUES 59,195 54,136 :49,696 EXPENDITURES Services and Supplies 51917 District Operations Chgs 7,098 50,000 .1'50,000 51226 Consulting Services 0 100,000 200,000 51211 Legal Services 0 ': 0 0 51921 Equipment Usage Charges 0 0 0 52171 Water Conservation Progran 0 0 0 51602 Business Travel/Mileage 232 0 0 51605 Private Car Expense 0 0 0 SUBTOTAL 7,330:. 150,000 250,000 Other Charges 53103 Interest on LT Debt '0 0 0 53501 Contributions 0 0 0 SUBTOTAL SUBTOTAL TOTAL EXPENDITURES Outstanding Encumbrances `213,156 163,460 328.92% 75,000 25,000 50.00% 200,000 0 0.00% 0 0 N/A 0 0 N/A 0 0 N/A 0 0 0 0 N/A 275,000 25,000 10.00% 0 0 N/A 0 0 N/A 0 0 0 0 0 N/A 5,558 0 5,558 0 12,887 150,000 5,557 0 0 0 N/A 0 0 0 N/A 250,000 275,000 25,000 10.00% ENDING FUND BALANCE 409,666 313,802 251,957 21 z/z7izo15 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: lWatershed Planning/Restoration Section/Fund No: 1 44215 Actual Estimated Adopted Requested Percent Ac count Title 2013-14 2014-15 2014-15 2015-16 Difference Change BEGINNING FUND BALANCE 2,973,611 5,072,518 4,726,273 REVENUES USE OF MONEY/PROPERTY 44002 Interest on Pooled Cash 21,303 18,000 18,000 18,000 0 0.00% SUBTOTAL 21,303 18,000 18,000 18,000 0 0.00% Intereovernmental Revenue 42619 Town of Windsor 261,188 SUBTOTAL 261,188 MISCELLANEOUS REVENUE 46200 Revenue Appl PY Misc Revenue 46040 Miscellaneous Revenue 46029 Donations/Contributions 46050 Cancelled/Stale Dated Warrant 161 SUBTOTAL OTHER FINANCING SOURCES 47101 Transfers In -within a Fund SUBTOTAL 161 252,835 252,835 254,944 2,109 0.83% 252,835 252,835 254,944 2,109 0.83% 0 0 0 0 0 0 4,688,957 3,997,147 3,634,500 4,688,957f 3,997,147 3,634,500 TOTAL REVENUES 4,971,609; ,.. 4,267,982 3,905,335 EXPENDITURES 0 0 2,100 Services and Supplies 1,436 5,700 0 52021 Clothing, Uniforms, Personal 742 1,200 0 51902 Telecommunication Usage; 75 100 0 52031 Food ,'561 530 0 51061 Maintenance - Equipment ' ` 27,068 200 0 51071 Maintenance - Bldg & Improve 0 0 0 52081 Medical/Laboratory Supplies 581 1.700 0 52111 Office Supplies 52117 Mail and Postage Supplies 52114 Freight/Postage 51241 Outside Printing and Binding 52101 Other Supplies 51231 Testing/Analysis 51209 Information Tech Svc (non ISD 51201 Administration Services 51917 District Operations Chgs 51803 Other Contract Services 51226 Consulting Services 51244 Permits/License/Fees 51211 Legal Services 51221 Medical/Laboratory Services 51401 Rents and Leases - Equipment 52141 Minor Equipment/Small Tools 52143 Computer Software/Licensing f 52142 Computer Equipment/Accessor 130 0 0 2,090 0 0 0 2,100 0 1,436 5,700 0 23,572 1,800 0 111,263 79,016 0 2,077 0 0 0 0 0 1,865,191 1,900,000 2,693,500 554,143 490,000 0 0 2,025,30D 1,276,000 12,922 0 0 13,414 25,395 0 0 19,656 0 99 27,700 0 29,493 2,527 0 601 0 0 0 0 0 22 4,030,500 396,000 10.90% 4,030,500 396,000 10.901, 4,303,444 398,109 10.19% 3,469,500 776,000 0 0 1,211,000 (65,000" N/A N/A N/A N/A N/A N/A N/A NIA N/A N/A N/A N/A N/A NIA 28.81% N/A (5.09%) N/A N/A N/A N/A N/A N/A 2/27/2015 51601 Training/Conference 0 1,487 0 0 0 N/A 51225 Training Services 675 0 0 0 0 N/A 52061 Fuel/Gas/Oil 0 0 0 0 0 N/A 51921 Equipment Usage Charges 16,479 25,000 0 0 0 N/A 58010 Reimb.-General 3,950 0 0 0 0 N/A 51602 Business Travel/Mileage 6,798 1,300 0 0 0 N/A 51605 Private Car Expense 1,505 1,015 0 0 0 N/A 52162 Special Department Expense 0 0 0 0 0 N/A SUBTOTAL 2,674,866 4,611,726 3,969,500 4,680,500 711,000 17.91% Other Charges 53103 Interest on LT Debt 0 0 0 0 0 N/A 53501 Contributions 0 2,500 0 0 0 N/A SUBTOTAL 0 2,500 0 0 0 N/A Reimbursements 0 D 0 0 N/A TOTAL EXPENDITURES 58010 Reimb.-General 1,917 0 0 0 0 N/A SUBTOTAL 1,917 0 0 0 0 N/A PRIOR YEAR ENCUMBRANCE EXPENSE 9618 PY Enc-Maint Bldgs/Imp 6,156 0 0 0 0 N/A 9650 PY Enc- Profess!Specia 285,331 0 0 0 0 N/A SUBTOTAL 291,487 0 D 0 0 N/A TOTAL EXPENDITURES 2,968,270 4,614,226 3,969,500 4,660,500 711,000 17.91 Outstanding Encumbrances - t` 95,568 Capital Interest ENDING FUND BALANCE 5.072.518 4.726.273 4.349.218 23 2/27/2015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: I Recycled Water and Local Supply Section/Fund No:44220 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change BEGINNING FUND BALANCE 958,788 1,112,225 1,122,070 REVENUES USE OF MONEY I PROPERTY 44002 Interest on Pooled Cash 8,143 10,651 4,500 4,500 0 0.00% SUBTOTAL 8,143 10,651 4,500 4,500 0 0.00% Intergovernmental Revenue 42358 State Other Funding (7,491) 0 0 0 0 NIA 42619 Town of Windsor 77,938 88,196 88,196 101,054 12,858 14.58% SUBTOTAL 70,447 88,196 88,196 101,054 12,858 14.58% MISCELLANEOUS REVENUE 45301 Charges for Services 0 355,000 0 0 0 N/A SUBTOTAL 0 355,000 0 0 0 0 MISCELLANEOUS REVENUE 46200 Revenue Appl PY Misc Revenue :.200 46029 Donations/Contributions 0 -`: 170,0004, 170,000 172,500 2,500 1.47% SUBTOTAL 0 Y- 170,200-: 170,000 172,500 2,500 1.47% OTHER FINANCING SOURCES 47101 Transfers In - within a Fund 1,398;964 1,394,321 1,267,819 1,597,600 329,781 26.01% SUBTOTAL 1,398,964:.. 1,394,321 1,267,819 1,597,600 329,781 26.01% TOTAL REVENUES 1,477,554 2,018,368 1,530,515 1,875,654 345,139 22.55% EXPENDITURES 51902 Telecommunication Usage 82 83 0 0 0 N/A 52031 Food 33 60 0 0 0 NIA 51061 Maintenance - Equipment 161 0 0 0 0 N/A 51071 Maintenance - Bldg & Improve 0 0 0 0 0 N/A 52111 office Supplies 299 0 0 0 0 N/A 52117 Mail and Postage Supplies 0 0 0 0 0 N/A 51241 Outside Printing and Binding 4,446 2,421 0 0 0 N/A 52111 Office Supplies 188 0 0 0 0 N/A 51201 Administration Services 0 0 0 0 0 N/A 51917 District Operations Chgs 627,455 640,000 455,000 515,000 60,000 13.19% 51803 Other Contract Services 137,180 150,000 58,950 0 (58,950) (100.00%) 51226 Consulting Services 58,977 100,000 490,000 404,500 (85,500) (17.45%) 51211 Legal Services 12,717 40,000 1,883 42,000 40,117 2130.48% 51206 Accounting/Auditing Services 0 0 0 0 0 N/A 51301 Publications and Legal Notices 0 0 0 0 0 N/A 51401 Rents and Leases - Equipment 1,328 0 0 0 0 N/A 51421 Rents and Leases - Bldg/Land 0 0 0 0 0 N/A 52141 Minor Equipment/Small Tools 14,815 50 0 0 0 NIA 52143 Computer Software/Licensing Fees 1,300 0 0 0 0 N/A 52162 Special Department Expense 324 6,398 0 0 0 N/A 52162 Special Department Expense 473 0 0 0 0 N/A 51225 Training Services 0 1,842 0 0 0 N/A 52061 Fuel/Gas/Oil 0 0 0 0 0 N/A 51921 Equipment Usage Charges 1,069 1,652 0 0 0 N/A 24 2272015 Section Title: Section/Fund No: 51244 Permits/License/Fees 52162 Special Department Expense 51602 Business Travel/Mileage 51605 Private Car Expense SUBTOTAL Other Charges 53103 Interest on LT Debt 53501 Contributions SUBTOTAL 19831 CIP - Bldg & Impr 19831 CIP - Bldg 8 Impr 19831 CIP - Bldg 8 Impr 19832 CIP-Infrastructure 19841 Work in Progress - Intang SUBTOTAL Recycled Water and Local Supply 44220 9618 PY Enc-Maint Bldgs/Imp 0 0 Actual Estimated Adopted Requested 9650 PY Enc - Profess/Special Percent 2013-14 2014-15 2014-15 2015-16 Difference Change 0 50 0 0 0 0 N/A 0 0 0 0 0 0 N/A 0 0 504,569 0 0 0 N/A 0 0 TOTAL EXPENDITURES 0 0 0 N/A 860,848 942,557 1,005,833 961,500 (44,333) (4.41%) 0 0 0 0 0 N/A 157,235 813,437 813,437 1,157,233 343,796 42.26% 157,235 813,437 813,437 1,157,233 343,796 4226% 175,000 N/A 0 175,000 0 0 0 N/A PRIOR YEAR ENCUMBRANCE EXPENSE 9618 PY Enc-Maint Bldgs/Imp 0 0 '0 0 0 N/A 9650 PY Enc - Profess/Special 179,940 0 0 0 0 N/A 9700 PY Enc - Special Dept Exp 0 0 0 0 0 N/A 9801 PY Enc-Contrib Govmt Agency 324,629 0 0 0 0 NIA SUBTOTAL 504,569 0 0 0 0 N/A TOTAL EXPENDITURES 1,522,653 1,930,994 1,819,270 2,118,733 299,463 16.46% Outstanding Encumbrances - Net Change;,' Change in Windsor Reserve ENDING FUND ,938) (77,529) (101,054) 25 2272015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Water Conservation Section/Fund No: 44225 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change BEGINNING FUND BALANCE (185,935) 209,855 277,576 REVENUES USE OF MONEY / PROPERTY 44002 Interest on Pooled Cash 4,711 7,511 600 600 0 0.00% SUBTOTAL 4,711 7,511 600 600 0 0.00% Intergovernmental Revenue 42358 State Other Funding 70,198 125,000 0 0 0 NIA 42610 Other Governmental Agencies 57,844 2,000 80,000 60,000 (20,000) (25.00%) 42611 City of Santa Rosa 0 0 0 0 0 N/A 42619 Town of Windsor 107,853 125,913 125,913 129,688 3,775 3.00% 42612 City of Petaluma 0 ❑ 0 0 0 N/A 42613 City of Raiment Park ❑ 0 0 0 0 N/A 42615 City of Cotati 0 0 0 0 0 N/A 42618 City of Sonoma 0 0> 0 0 0 NIA 42621 North Marin Water District 0 '. 0. 0 0 0 N/A 42610 Other Governmental Agencies 0 0 0 0 0 N/A SUBTOTAL 235,894 252,913 2❑5,913 :-189,688 (16,225) (T88%) OTHER FINANCING SOURCES 46040 Miscellaneous Revenue - - 0 N/A 46029 Donations/Contributions 0 0 0 0 0 N/A 46050 Cancelled/Stale Dated Warrants 0 `. 0 0 0 0 N/A 46200 Revenue Appl PY Misc Revenue 91.693 0 0 0 0 N/A 46022 Capital Grants - State 0 0 130,000 202,500 72,500 55.77% 42461 Federal Other Funding 31,039 31,039 N/A SUBTOTAL 91,693 ' 0 130,000 233,539 72,500 55.77% OTHER FINANCING SOURCES 47101 Transfers ln-withinaFund 1,936,199 1990,600 1,810,000 2,050,281 240,281 13.28% SUBTOTAL 1,936,199 1990,600 1,810,000 2,050,281 240,281 13.28% TOTAL REVENUES 2,268,498 2,251,024 2,146,513 2,474,108 296,556 13.82% EXPENDITURES Services and Supplies - 52021 Clothing, Uniforms, Personal 0 0 0 0 0 NIA 51902 Telecommunication Usage 398 381 0 0 0 NIA 52031 Food 893 0 0 0 0 N/A 51032 Janitorial Services 0 345 0 0 0 NIA 51061 Maintenance -Equipment 34 0 0 0 0 N/A 51071 Maintenance-Bldg&Improve 0 2,587 0 0 0 N/A 52091 Memberships/Certifications 7,699 15,000 0 10,000 10,000 N/A 52111 Office Supplies 1,098 775 0 0 0 N/A 52117 Mail and Postage Supplies 28 441 ❑ 0 0 N/A 52115 Books/Media/Subscriptions 716 4,000 0 0 0 N/A 51241 Outside Printing and Binding 48,560 14,584 0 10,001) 10,000 N/A 52111 Office Supplies 17,701 20,000 0 20,000 20,000 N/A 51209 Information Tech Svc (non ISD) 372 72 0 0 0 N/A 51201 Administration Services 0 0 0 0 0 N/A 51917 District Operations Chgs 1,050,050 1,091,470 1,070,000 1,357,000 287,000 26.82% 51249 Other Professional Services 0 0 0 0 0 N/A 51803 Other Contract Services 96,761 150,000 200,000 262,600 62,600 31.30% 51226 Consulting Services 0 0 0 0 0 N/A 51249 Other Professional Services 0 0 20,000 20,000 ❑ 0.00% 51211 Legal Services 170 1,000 0 0 0 N/A 51206 Accounting/Auditing Services 0 0 0 0 0 N/A 51301 Publications and Legal Notices 0 2,065 ❑ 0 0 NIA 26 2272015 Section Title: lWater Conservation 9650 PY Enc - Profess/Special Section/Fund No: 44225 ❑ 0 N/A 9700 PY Enc - Special Dept Exp 8,184 0 0 Actual Estimated Adopted Requested 0 Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change 51401 Rents and Leases - Equipment 2,136 865 ❑ 0 0 N/A 51421 Rents and Leases - Bldg/Land 0 0 0 0 0 N/A 52141 Minor Equipment/Small Tools 1,215 0 0 0 0 N/A 52143 Computer Software/Licensing Fee 3,000 0 0 0 0 N/A 52142 Computer Equipment/Accessories 0 0 0 0 0 N/A 52162 Special Department Expense 215,725 177,199 165,000 185,000 20,000 12.12% 52162 Special Department Expense 5,989 0 0 0 0 N/A 51225 Training Services 3,315 10,000 0 0 0 N/A 51921 Equipment Usage Charges 13,813 16,321 0 0 ❑ N/A 52072 Chemicals 0 0 0 0 0 N/A 52171 Water Conservation Program 0 565,000 565,000 401,220 (163,780) (28.99%) 52162 Special Department Expense 0 0 0 0 0 N/A 51602 Business Travel/Mileage 8,519 2,500 0 18,000 18,000 N/A 51605 Private Car Expense 1,339 1,392 0 0 _ 0 N/A SUBTOTAL 1,479,529 2,075,597 2,020,000 2,283,820 263,820 NA Other Charges 53501 Contributions 250,001 0 0 0 0 N/A SUBTOTAL 250,001 0 0 ❑ 0 N/A PRIOR YEAR ENCUMBRANCE EXPENSE 9650 PY Enc - Profess/Special 13,216 0 0 ❑ 0 N/A 9700 PY Enc - Special Dept Exp 8,184 0 0 0 0 N/A 9801 PY Enc-Contnb Govmt Agei 0 0 ❑ 0 0 N/A SUBTOTAL 21,400 0 0 0 0 N/A TOTAL EXPENDITURES 1,750,929 ..:2,075,997 2,020,000 2,283,820 263,820 13.06% Outstanding Encumbrances (158,477) Change in Windsor Reserve 36,698 - (107,306) (129,688) ENDING FUND BALANCE 209,855 277,576 338,176 27 227/2015 w 0 0 0 0 O O O C 0 0 0 0 O V d N N N (O M Fsr » vs m 0 O N O O@ E a C@ Q1 N V 0« @ U O OlL , 0 O O a N E N E N d > .` >` O N U a 'U 0 0 m L N E O O C Ola >`C@o�a=��y O.@O. GNL Q�Qa W U ul 0@ Q` U C T C yl p >i �,°C O@ a Q a O` C@ ai.- LL LLL C v C a 0 n x E o J u c N L Ulm @ O T« O •' l/1 O L U _ @ O @ E r L E U @ Q O k p U E O@ N x@ C N p N T O LL C @ N Q1 C O a LL C O 3 O1 m Y C v E .o o Q r 3 d N o o D@ w an 6 O O T d ( G O Cv@ a 0 U> m T O a O@ N O._ c _ 0 a C O c= T- N N pcl Ul G @ @ _ as O N @N �N. 3 S E °c' J U N >@ O) F > N C o .D C @> U W nZC a CNS p d_O@C@CN @ZCN@ N�Z W C a -J.0 N° Cr@ L N- C.L.. 0 O J o U O O L 3' �l m> N.. m -3 v w oa E a c a E m 3 m m p`c o E o ° rn o o UI JOU NU�..J.U@ �.@@dC O O N U O Ql 0...@ O U rn -J -ia0@ J@ m f0 - m Q lV L 0 m c > w o. v a a a`l m m v o o m c..a @ m o mrn o a @N� °p� ZTTUN@>.CUIU ay"L .Ca j00 OIQU C@OU 00`C Q Q@NC O'NN a0 OaLjC-p ON:L N O N C a -O 0.0 0 0 ° 0 0@ O L O C E y 0l N N E �• O 0 p 0 W O . M 0 C J@ U > d m O W«« Q m E U UU N C O. a (n G Ol O LL >>a ."T. @^ y °ld U O C iC 00 a J O-0 J U N O aE ° LL @ C Q LL C d N a C U C) w @ @ c a� @ `w 0> @ E (DO E E o °� Q c U m ° yaci Q E U@ O >@@ .-. W N Q m a Z @ C@ C O >@@ 2 O > @@ LL a cm O= C C c @0Ol O N N N=TX > N @@ @@ OI >CL O m w o y v °l c a t c o 'm >@ Z @ a m@> a a a J K@ o o H w E 3 nN m y LL@ d o Ir @ � @ c > 0 E N a C @ c O TMS @ U) @ C c ELL d y@ a @ O C U DC, to CI L �L W @ Q m« Ol 0 @ O Q d@ �2� zLLSUa 0 0 0 0 0 0 N O O N O r r O E E o m c m O0 m C a ma o a o a m m m a a S acv m o E2 v E m Mo> a w > p a , a� y J O.L m U y N m m 3 m m N m rL. w N a m a U a Y p O O a E> o a o c E m� oaU7 0 m J N C O p r m m O V C mom' 0'0 N d YW O M a.my oa 0 O m o U T p L N m a..N- m a C = ID U) G'; 0 N N N .0.'.E U1 :m 2i rA N OL-' y J c m c c m aEi o 3 3 N N J E Ul m O L L T m C U) N m 6 p c 3 v j m E Um J O O E'5 OC U a m z m O E m O Ear C O N O LL m m O 3 o 3 0(DMcg V. m N 46 m m v « m m Y >> C C O d a 0 O d �CZ'a3p CIO C'>'O CE'O Ca CCm nam ¢ U- w >� o U� j > > N m E m v c E ci m 0 Qm c v m- m m E J 0 m o c m mv�omym 000 mo �Em MO- N=ao v0 mU)cm 2`w m m +.' O E m n U m a a a 00 w U m E U C N O] C N O 0 CO C C UJ ENO Oam C .. a U C a E :.'.: N > N J W y' J y O U O L Y O- N O O O m O, a C Ipq 0" a m �..� N C y o m m r > m OI J o U m: m> m C> _ O > a N C 0I 0 > o m a E >. o E m c o N� U > C O MN_N -0.1-. rna2CLi G E.N N a y C 0 0 d m T m_m C y a p m m ?' E m a 'O`- C C L O aocE N m m L C m EL>;m-.rnc O m Y m EYE L y E E m EmamS:.m m m s:c' m c E E m U` c m m..a �." o m c. c 0- CL L nm M 0 m a a m L O.T. v, Y> m °' Jo c Q v m m m a? o C y ? E m E 0 C N >o O M c I EC> m °'t mEat 0JU `0 d Um c� M 0 > :- 7 >U U m o c E -0a yE m a E 01 E o m v m m J m ._ O m O O N a7 O Nvm �mm Y> VMmswwa aO_E p aa Cm y am . aai vc 0o a�mN : z U a- d of U Fn w cl Fri O w T p- >� N p m OIC N A N O a U a m a O Q E V y> m U) J O m mEo Hi -6 U U — (l U y ? C yp v U `p N a O y m o m 3 m m n c - 0 m w E N a '° 3 w cop w E ->' Jo NN O d L J m O N N p y Mm m 3 Q N C .0 O. O W + 10 OI O1 L- LOA N a E o a m c�vtn a'0Eo a - V O O c N O U _ U > ¢Oy Jp E m>'a jLaw a N i9 0 o c � a c uJi r w c a Q'^ o rua cco�_ cilia m 0 m '? m U c E U L maoUEpna-�m... c c m oc= y m c J N c M m - o w, o -O E o :s O ,- o w m me c U T� o-niuN m J.O c m m m m O O m IL c 3 N m U L a�Nm. 0a o a m m L m m C C C J C C O1� m m> C m m N N U9 O O m o c m m E N J U Q N E m o 0 0 F- E Q (n d J m C N 5 U U C 0 0 a 0 v f9 0 N N v C C. VII to N n N R M O O o O O C) O O N O (p O O (D O N O O M r N m h O d m ca LL fA fH (f} fPr (A (Ii fH if)v3 N C C '- m 0 VI L N a m O T �- � O m L d E d d m O O T U C L m E E c m O � C `pL U m N O m O O C L a a J o O `o > y o O U a m T O U C E c U)) a 0.. E ti o a E U w E m m p m m c m rn a m W m E ::m o> c a O c c d o n v m m U) a o O U1 U1 m C N C U d OI o m m m a 'Un a U Q w m .O EO c a N O C m m m 0 0 m p p m c a a N ,n C7 _ a m a E c4'i y O Y o U .� o 'n W c m m F- E.0 ? E m h C v1 L N U m y N ti m: ; N LL.. 'O O N m > dN O 2:1 N m C C � N U) l m p N 'y C Q y LLI In o W o y m m c m y v > y c C m N d O L C m O a N O g 0 j a LL > L' Q N LL> J Un C C L O C Lp c ro O a O LL J Z LL O L O y C G m U) m N G O d 'O H C L y coQ m U rG m n m m m a m O EL 0c ='LnEwu� m� a N W C m m m tY U m E U°�cmm�my N m c� T E Em`m om mmE°1da�m`mm m� U) "" U C m C C> 'C L p C EN m C> 'C L N m W m m O m O C O O m m U a O m L m m m m U O m (D CL 0 W U) U)U)d U] a 0 W UUr0 U)U]d> > (D :D to N n N R M Water Transmission System Agency Fund Local Supply / Recycled Water / Tier 2 Programs Balance as of January 22, 2015 Contractor 10 -Year Allocation Amount Approved by WAC Amount Disbursed Balance Available' Encumbered 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,724,026 1,000,000 724,026 NMWD 1,846,726 1,846,726 1,846,726 0 Rohnert Park 649,629 649,629 649,629 0 VOM WD 627,875 627,875 627,875 0 Sonoma 539,411 539,411 264,294 275,117 185,706 Windsor 86,996 86,996 86,996 0 Cotati 157,235 157,235 157,235 0 Forestville 104,953 104,953 104,953 0 TOTAL $13.000.000 $11.938.640 $10.843624 $2.156.376 1. Balance Available based on 10 -Year Allocation Program started June 30, 2000 - No end date specified. 32 2/27/2015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Santa Rosa Aqueduct Capital Fund Section/Fund No: 44230 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change MISCELLANEOUS REVENUES BEGINNING FUND BALANCE 3,537,789 2,481,052 2,901,585 0 REVENUES 0 0 N/A 45313 Sale -Water USE OF MONEY I PROPERTY 0 :. 0 0 0 44002 Interest on Pooled Cash 21,660 14,589 10,800 10,800 0 0.00% 44003 Other Interest Earnings 0 90,130 90,130 63,719 (26,411) (29.30%) SUBTOTAL 21,660 104,719 100,930 74,519 (26,411) (26.17%) MISCELLANEOUS REVENUES 45313 Sale -Water 0 0 -: 0 0 0 N/A 45313 Sale -Water 0 0 :. 0 0 0 N/A 45327 Santa Rosa Aqua Rev E 0 0 i `0: 0 0 NIA SUBTOTAL 0 :_ 0 0 0 N/A 0 ADMINISTRATIVE CONTROL ACCOUNT 49002 Advances 0 28,338 42,297: 28,338 (13,959) (33.00%) 49003 Advances Clearing 0 (28,338); :..(42,297) (28,338) 13,959 (33.00%) SUBTOTAL 0 0 0 0 0 N/A OTHER FINANCING SOURCES 47101 Transfers In - within a F 521,604 - 330,814 433,516 433,323 (193) (0.04%) SUBTOTAL 433,516 433,323 (193) (0.04%) 521,604 330,814 TOTAL REVENUES 543,263 -: 435,533 534,446 507,842 (26,604) (4.98%) EXPENDITURES OTHER FINANCING USES 57011 Transfers Out-withina 0 15,000 SUBTOTAL 0 15,000 15,000 15,000 415,000 400,000 2666.67% 415,000 400,000 2666.67% TOTAL EXPENDITURE 0 15,000 15,000 415,000 400,000 2666.67% Advances to Storage (1,600,000) 0 Increase/(Decrease) in Loan Payable 0 Principal Receipt on Advance 0 ENDING FUND BALANCE 2,481,052 2,901,585 2,994,428 33 2/27/2015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Petaluma Aqueduct Capital Fund Section/Fund No: 44235 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014.15 2014-15 2015-16 Difference Change BEGINNING FUND BALANCE 5,603,507 6,227,499 2,566,306 REVENUES USE OF MONEY / PROPERTY 44002 Interest on Pooled Ca 33,874 13,220 15,000 15,000 0 0.00% 44003 Other Interest Earninc 0 160,526 160,526 163,281 2,755 1.72% SUBTOTAL 33,874 173,746 175,526 178,281 2,755 1.57% ADIOINISTRATIVE CONTROL ACCOUNT 49002 Advances 0 0 0.` 72,616 72,616 N/A 49003 Advances Clearing 0 0 0'. (72,616) (72,616) N/A SUBTOTAL 0 0 0 0 0 N/A OTHER FINANCING SOURCES 47101 Transfers In -within a 590,118 280,061 453,155 273,495 (179,660) (39.65%) SUBTOTAL 590,118 280,061 ". 453,155 273,495 (179,660) (39.65%) TOTALREVENUES 623,992 453,807 628,681 451,776 (176,905) (28.14%1 EXPENDITURES OTHER FINANCING USES 57011 Transfers Out within 0 '15,000 15,000 350,000 335,000 2233.33% SUBTOTAL 0 15,000 15,000 350,000 335,000 2233.33% TOTAL EXPENDITUF 0 15,000 15,000 350,000 335,000 2233.33% Advance to Common (4,100,000) Increase/(Decrease) in Loan Payable Principal Receipt on Advance 0 0 72,616 ENDING FUND BALANCE 6,227,499 2,566,306 2,740,698 34 2/27/2015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Sonoma Aqueduct Capital Fund Section/Fund No: LAL240 Actual Estimated Adopted Requested Percent !Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change OTHER FINANCING SOURCES 47101 Transfers In - witlOT- 246,221 80,303 81,765 BEGINNING FUND BALANCE 266,725 104,892 663 REVENUES 80,303 81,765:::1- 170,423 USE OF MONEY / PROPERTY 108.43% TOTAL REVENUES 248,167 44002 Interest on Poole Inten 1,946 468 1,200 1,200 0 0.00% 44003 Other Interest Ea Inter( 0 0 0 0 0 N/A SUBTOTAL 1,946 468 1,200 1,200 0 0.00% OTHER FINANCING SOURCES 47101 Transfers In - witlOT- 246,221 80,303 81,765 170,423 88,658 108.43% SUBTOTAL 246,221 80,303 81,765:::1- 170,423 88,658 108.43% TOTAL REVENUES 248,167 80,771 82,965 171,623 88,658 106.86% EXPENDITURES OTHER FINANCING USES 57011 Transfers Out -wOT- 410,000 185,000 -80,000 7 50,000 (30,000) (37.50%) SUBTOTAL 410,000 185,000 ' 80,000 50,000 (30,000) (37.50°/x) TOTAL EXPENDITUR. r. 410,000 185,000 80,000 50,000 (30,000) (37.50%) ENDING FUND BALANCE s 104,892 663 122,285 35 2/27/2015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: IStorage Facilities Section/Fund No: 44250 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change BEGINNING FUND BALANCE (1,688,286) 412,925 145,315 REVENUES USE OF MONEY / PROPERTY 44002 Interest on Pooled Cash SUBTOTAL (10,260) 1,110 1,110 1,110 0 0.00% (10,260) 1,110 1,110 1,110 0 0.00% MISCELLANEOUS REVENUE 46029 Donations/Contributions 0 46040 Miscellancous Revenue 5,031 46022 Capital Grants - State 115,408 (Petaluma AQ - Caltrans Project) SUBTOTAL 120,440 Administrative Control 0 0 0 0 N/A 0 0 0 0 0 N/A 0 0 0 0 N/A 49002 Advances 1,600,000 0<`; 'C.0 0 0 N/A 49003 Advances Clearing (1,600,000) 0 0 ` 0 0 N/A SUBTOTAL 0 0<' 0 0 0 N/A OTHER FINANCING SOURCES (134,112) 0 0 0 0 N/A 47101 Transfers In - within a Fund 780,000 90000 50 000 110 000 60 000 12000% SUBTOTAL -780,000 90,000 50,000 110,000 60,000 120.00% TOTAL REVENUES. 890,180 91,110 51,110 111,110 60,000 117.39% EXPENDITURES OTHER CHARGES 53103 Interest on LT Debt 63,719 0 63,719 63,719 N/A 53103 Interest on LT Debt (134,112) 0 0 0 0 N/A SUBTOTAL (134,112) 63,719 0 63,719 63,719 N/A FIXED ASSETS 19831 CIP - Bldg & Impr 223,835 0 0 0 0 N/A 19831 CIP - Bldg & Impr 0 0 0 0 0 N/A 19831 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 57 50,000 0 50,000 50,000 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 50,000 0 (50,000) (100.OD%) 19832 CIP - Bldg & Impr 113 120,000 0 0 0 N/A 19832 CIP - Bldg & Impr 0 125,000 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 36 2/27/2015 19832 CIP - Bldg & Impr 0 19832 CIP - Bldg & Impr 0 19832 CIP - Bldg & Impr 0 19832 CIP - Bldg & Impr 43,070 19832 CIP - Bldg & Impr 0 SUBTOTAL 267,075 PRIOR YEAR ENCUMBRANCE EXPENSE 9852 PY Enc - Bldg / Imp / Ec 1,818 9854 PY Enc - Infrastructure 22,085 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 295,000 50,000 50,000 0 0.00% 0 0 0 0 N/A SUBTOTAL 23,903 0 0 0 0 N/A TOTAL EXPENDITURES 156,866 358,719 50,000 113,719 63,719 127.44% Advances from Aqueduct fund; 1,600,000 0 Principal payment on Loan from AQ funds (28,338) Outstanding Encumbrances -1` (97,991) 0 Capitalized Interest (134,112) 0 0 CIP Adjustment 0 ENDING FUND BALANCE 412,925 145,315 ..114,368 37 2/27/2015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Pi eline Facilities SectionlFund No: 44255 45062 ConslrucUBldg Pencil R 0 0 0 0 0 NIA SUBTOTAL 0 0 0 0 0 N/A MISCELLANEOUS REVENUE 46021 Capital Grants - Federal Actual Estimated Adopted Requested 0 Percent SUBTOTAL 2013-14 2014-15 2014-15 2015-16 Difference Change 47101 Transfers ln- within a FL 836,528 356,000 151,000 '_. 905.000 °754,000 BEGINNING FUND BALANCE (56,832) 998,586 883,662 REVENUES SUBTOTAL 836,528 356,000'..%'=151 Too 905,000 754,000 USE OF MONEY I PROPERTY TOTAL REVENUE 1,728,817 366,176 151,090 905,090 754,000 44002 Interest on Pooled Cash (4,244) 10,176 90 90 0 0.00% SUBTOTAL (4,244) 10,176 90 90 0 000% INTERGOVERNMENTAL REVENUE 19831 CIP - Bldg 8lmpr 255,969 0.-. 0 0 0 42611 City of Santa Rosa 0 0 0 0 0 NIA 42441 Federal FEMA Disaster (17,635) 0 0 0 0 NIA SUBTOTAL (17,635) 0 0 0 0 NIA 45062 ConslrucUBldg Pencil R 0 0 0 0 0 NIA SUBTOTAL 0 0 0 0 0 N/A MISCELLANEOUS REVENUE 46021 Capital Grants - Federal 914,169 0 0 0 0 N/A SUBTOTAL Q 14169 0 0-. '. 0 0 NIA 47101 Transfers ln- within a FL 836,528 356,000 151,000 '_. 905.000 °754,000 499.34% 0 SUBTOTAL 836,528 356,000'..%'=151 Too 905,000 754,000 499.34% TOTAL REVENUE 1,728,817 366,176 151,090 905,090 754,000 499.04% EXPENDITURES FIXED ASSETS 19831 CIP - Bldg 8lmpr 255,969 0.-. 0 0 0 N/A 19832 CIP - Bldg B lmpr ( 0.:: 65,000 15,000 415,000 400,000 2666.67% 19832 CIP - Bldg 81mpr 65,689 0 0 0 0 NIA 19832 CIP -BItlg 8lmpr 0 : 65,000 15,000 350,000 335,000 2233.33% 19832 CIP - Bldg 81mpr 0 350,000 250,000 590,000 340,000 136.00'% 19832 CIP-BItlg 8lmpr '662 i0 0 0 19841 Work in Progress -Intan -0 1,100 0 0 0 NIA SUBTOTAL 322,320( 481,100 280,000 1355,000 7,075,000 383.93% OTHER CHARGES 53103 Interest on LT Debt.:.. (166,348) 0 0 0 0 NIA 53403 Loss- Disposed Cppital 111,812 0 0 0 0 NIA SUBTOTAL (74,536) 0 0 0 0 N/A Other Financing Uses 57011 Transfers Out - withina 203,338 0 0 0 0 N/A SUBTOTAL 203,338 0 0 0 0 NIA PRIOR YEAR ENCUMBRANCE EXPENSE 9852 PYEnc-Bldglln 810,049 0 0 0 0 NIA 9854 PYEnc-Infmrtm 9,270 0 0 0 0 NIA SUBTOTAL 819,310 0 0 0 0 NIA TOTAL EXPENDIT 1,270,441 481,160 280,000 1,355,000 7 075.060 383.93% Advance from Sonoma AO Revenue Bond 2015 0 Outstanding Encumbrr 671,578 0 Loss on Fixed Asset 117,812 Capitalized Interest (186,348) 0 CIP Adjustment 0 ENDING FUND BALANCE 998,586 883,662 433,752 38 212712015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: lCommon Facilities Section/Fund No: 44260 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change BEGINNING FUND BALANCE 3,221,676 16,782,237 593,955 REVENUES USE OF MONEY/PROPERTY 44002 Interest on Pooled Cast 16,885 95,709 6,000 6,000 0 0.00% SUBTOTAL 16,885 95,709 6,000 6,000 0 0.00% Charges For Services 45062 Construct/Bldg Permit F SUBTOTAL 908 0 0 908 0 '0 0 0 N/A 0 0 N/A Charges for Services 0 160,526 160,526 163,281 2,755 1.72% 46200 Revenue AppIPY Misc 0 0 :.: 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A Miscellaneous Revenues (318,756) 160,526 160,526 163,281 2,755 1.72% 46040 Miscellaneous Revenue 0 0 0 0 0 N/A 46029 Donations/Contributions 0 365,000 365,000 80,000 (285,000) (78.08%) 46050 Cancelled/Stale Dated %-313 0 0 0 0 N/A 46200 Revenue Appl PY Misc ' 0 0 0 0 46022 Capital Grants - State : (57,222) 800,000 0 0 0 N/A 46021 Capital Grants Federal 181,150 100,000 0 0 SUBTOTAL 124,241 F. 1,265,000 365,000 80,000 (285,000) (78.08%) ADMINISTRATIVE CONTROL 49002 Advances 4,100,000 0 0 0 0 N/A 49003 Advances Clearing (4,100,000) 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A 47101 Transfers In -within a F 12,519,585 3,830,449 2,556,527 6,880,000 4,323,473 169.12% SUBTOTAL 12,519,585 3,830,449 2,556,527 6,880,000 4,323,473 169.12% TOTAL REVENUE 12,661,620 5,191,158 2,927,527 6,966,000 4,038,473 137.95% EXPENDITURES OTHER CHARGES 53103 Interest on LT Debt 0 160,526 160,526 163,281 2,755 1.72% 53103 Interest on LT Debt (318,756) 0 0 0 0 N/A 53403 Loss - Disposed Capital 0 0 0 0 0 N/A. SUBTOTAL (318,756) 160,526 160,526 163,281 2,755 1.72% 39 2/27/2015 Section Title: lCornmon Facilities Section/Fund No: 44260 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change 19810 Land 0 0 0 0 0 N/A 19831 CIP - Bldg & Impr 2,239,808 2,297,000 1,415,000 1,580,000 165,000 11.66% '19831 CIP - Bldg & Impr 0 0 0 0 0 N/A 19831 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 700,000 2,800,000 3,560,000 760,000 27.14% 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 58,210 14,344,000 775,000 1,500,000 725,000 93.55% 19832 CIP - Bldg & Impr 0 200,000 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 40,000 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 '` 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0, 0 0 0 N/A 19832 CIP - Bldg & Impr 117,504 1,677,914 700,000 520,000 (180,000) (25.71%) 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0.- 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0c. 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 80,000 80,000 N/A 19832 CIP - Bldg & Impr 0 110,000 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr 0 0 0 0 0 N/A 19832 CIP - Bldg & Impr _.0 450,000 0 0 0 N/A 19832 CIP - Bldg & Impr 225,437 1,200,000 0 0 0 N/A 19851 Intangible Assets - Non- 3,084 100,000 750,000 0 (750,000) (100.00°/x) 19841 Work in Progress - Intar 0 100,000 1,250,000 0 (1,250,000) (100.00%) SUBTOTAL 2,644,043 21,218,914 7,690,000 7,240,000 (450,000) (5.85%) Other Financing Uses 57011 Transfers Out -within a 0 SUBTOTAL 0 59002 Advances 0 59003 Advances Clearing 0 SUBTOTAL 0 77,374 63,345 0 0 0 0 N/A 0 0 0 0 N/A 0 75,466 72,616 (2,850) (3.78%) 0 (75,466) (72,616) 2,850 (3.78%) 0 0 0 0 N/A 0 0 0 0 N/A 40 2/27/2015 Section Title: Icommon Facilities Section/Fund No: F 44260 Actual Estimated Adopted Requested Percent iccountTitle 2013-14 2014-15 2014-15 2015-16 Difference Change SIIRTOTAI. 140.719 0 0 0 0 N/A TOTAL EXPENDITURE 7,850,526 7,403,281 (447,245) (5.70%) 2,466,006 21,379,440 Loan 4,100,000 0 0 Outstanding Encumbrar (416,297) 0 0 Capitalized Interest (318,756) 0 0 Principal payment on Lc 0 0 (72,616) Change in Deposit with 0 0 0 �ENDiNG FUND BALANCE 16,782,237 593,955 84,058 41 2/27/2015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: North Marin Water Deposit Section/Fund No: 44300 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change BEGINNING FUND BALANCE 12,822 12,923 13,022 REVENUES USE OF MONEY / PROPERTY 44002 Interest on Pooled Cash 101 SUBTOTAL 101 9 I7 101 101 (0) (0.20°/x) 101 101 (0) (0.20%) Intergovernmental Revenue 42610 Other Governmental Agencie: 0 0 ` ` 0 - 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A MISCELLANEOUS REVENUES 47101 Transfers In - within a Fund 0 0 0 - 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A TOTAL REVENUES 101 99. 101 101 (0) (0.201. EXPENDITURES OTHER CHARGES 53501 Contributions 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A OTHER FINANCING USES 57011 Transfers Out -within a Fund `.. 0 0 0 0 0 N/A SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURE: 0 0 0 0 0 N/A ENDING FUND BALANCE 12,923 13,022 13,122 42 2/27/2015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: State Loan Debt Service Fund Section/Fund No: 44255 Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change BEGINNING FUND BALANCE $538,091 $181,395 $23,252 REVENUES USE OF MONEY I PROPERTY 44002 Interest on Pooled Cast 6,702 5,256 1,500 1,500 0 0.00% 44003 Other Interest Earnings 0 0 0 0 0 N/A SUBTOTAL 6,702 5,256 1,500:. 1,500 0 0.00% OTHER FINANCING SOURCES 47101 Transfers In-withinaF 1,196,268 1,196268 1,196,268 (-:1,040,234 (156,034) (13.04%) SUBTOTAL 1,196,268 1,196,268 1,196,268 1,040,234 (156,034) (13.04%) TOTAL REVENUE 1,202,970 1,201,524 1,197,768 --. 1,041,734 (956,034) (13.03%) EXPENDITURES OTHER CHARGES 53103 Interest on LT Debt 349,296 .349,296 ` 349,296 309,880 (39,416) (11.28%) SUBTOTAL 349,296 ' 349,296 = 349,296 309,880 (39,416) (11.28%) OTHER FINANCING USES 57011 Transfers Out - within a 500,000 300,000 0 0 0 N/A SUBTOTAL 500,000 300,000 0 0 0 N/A ADMIN. CONTROL ACCOUNT 59004 Administrative Control P 0 `.' 0 690,937 730,354 39,417 5.70% 59005 Admin Control Acct Cle; 0 0 (690,937) (730,354) (39,417) 5.70% SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURE 849,296 649,296 349,296 309,880 (39,416) (11.28%) Principal Payment (690,936) (710,371) (730,354) Change in Due to Other (19,435) ENDING FUND BALANCE $181,395 $23,252 $24,752 2/27/2015 43 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: I State Loan Reserve Fund Section/Fund No: 44270 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change BEGINNING FUND BALM $0 $0 $0 REVENUES USE OF MONEY / PROPERTY 44002 Interest on Poo 7,332 7,183 0 0 0 N/A 44003 Other Interest E 0 0 0 0 0 N/A SUBTOTF 7,332 7,183 0 0 0 N/A OTHER FINANCING SOURCES 47101 Transfers In - H 0 0 : 0 0 0 N/A SUBTOTF 0 0 0 0 0 N/A TOTAL RI 7,332 7,183 0 0 0 NIA EXPENDITURES OTHER FINANCING USES 57011 Transfers Out- 0 0 0 0 0 N/A SUBTOTA 0 r',0 0 0 0 N/A TOTAL EXPEIS 0 0 0 0 0 N/A Reserve Unays (7,332).:; (7,183) 0 ENDING FUND BALANCE $0 $0 $0 Fund Balance $41,456 $41,821 $1,240,274 $1,247,606 2/27/2015 44 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: IStorage Facilities Revenue Bond - 2012A Section/Fund No: 44280 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change BEGINNING FUND BALANCE $273,193 $12,510 $11,262 REVENUES (8,770) (2.75%) SUBTOTAL USE OF MONEY I PROPERTY 316,555. 318,555 309,785 44002 Interest on Pooled Cash 1,673 147 90 90 0 0.00% 44003 Other Interest Earnings 39 0 0 0 0 N/A SUBTOTAL 1,713 147 90 90 0 0.00% 47101 Transfers In -within a Fund 310,186 318,555 318,555 309,785 (8,770) (2.75%) SUBTOTAL 310,186 316,555. 318,555 309,785 (8,770) (2.75%) TOTAL REVENUES 311,899 318,702 318,645 309,875 (8,770) (2.75%) EXPENDITURES SERVICES AND SUPPLIES 51242 Bank Charges 874 2,500 2,500 2,500 0 0.00% SUBTOTAL 874 'x2,500 ::2,500 2,500 0 0.00% OTHER CHARGES 53103 Interest on LT Debt 121,386 115,276 120,804 116,382 (4,422) (3.66%) 53103 Interest on LT Debt (10,307) ' 0 0 0 0 N/A 53103 Interest on LT Debt 0 0 0 0 0 N/A 53105 Costs of Issuance 0 0 6,307 0 (6,307) (100.00%) SUBTOTAL 111,079 115,276 127,111 116,382 (10,729) (8.44%) OTHER FINANCING USES 57011 Transfers Out -within a Fund 310,000 50,000 50,000 40,000 (10,000) (20.00%) SUBTOTAL 310,000 50,000 50,000 40,000 (10,000) (20.00%) ADMIN. CONTROL ACCOUNT 59004 Administrative Control Account 145,841 147,393 147,393 150,496 3,103 2.11% 59005 Admin Control Acct Clearing `-.(145,84-1) (147,393) (147,393) (150,496) (3,103) 2.11% SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURES 421,953 167,776 179,611 158,882 (20,729) (11.54%) Increase in Bonds Payable 0 0 0 Proceeds from issuance 0 2003A Bond Redemption 0 2003A Deferred amount of refunding 0 Reclass of good faith on refunding to LT E 0 Debt Issuance Costs 0 Restricted cash with trustee (reserve) (7) Amortization of Premium bond discount (10,307) (10,307) Amortization of deferred amount of refund 5,526 5,526 Amort. of Bond Issuance Costs 0 0 0 (ENDING FUND BALANCE $12,510 $11,262 $11,758 1 45 2/27/2015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Common Facilities Revenue Bonds - 2012 A Section/Fund No: 44275 Actual Estimated Adopted Requested Percent Account Title 2013-14 2014-15 2014-15 2015-16 Difference Change BEG. FUND BALANCE $171,492 $111,262 $13,811 REVENUES (12,280) (2.76%) SUBTOTAL USE OF MONEY/PROPERTY 444,963 '' 444,963 432,683 44002 Interest on Pooled Cash 710 274 300 300 0 0.00% 44003 Other Interest Earnings 55 0 0 0 0 N/A SUBTOTAL 765 274 300 300 0 0.00% 47101 Transfers In - within a Fund 433,246 444,963 '.'444,963 432,683 (12,280) (2.76%) SUBTOTAL 433,246 444,963 '' 444,963 432,683 (12,280) (2.76%) TOTAL REVENUES 434,011 445,237 445,263.. 432,9e3 (12,280) (2.76%) EXPENDITURES 190,673:: 222,000 0 110,000 110,000 N/A SERVICES AND SUPPLIES 51242 Bank Charges 1,162 2,500: `.2,500 2,500 0 0.00% 59005 Admin Control Acct Clearing 0 0% - 0 0 0 N/A SUBTOTAL 1,162 2,500. 2,500 2,500 0 0.00% OTHER CHARGES 347,424 393,705 180,5313 275,513 94,977 52.61% 53103 Interest on LT Debt 170,020 .` : 169,205 ` r 169,205 163,013 (6,192) (3.66%) 53103 Interest an LT Debt (14,432) '0 0 0 0 N/A 53103 Interest on LT Debt 0 0 0 0 0 N/A 53105 Costs of Issuance 0.: 0 8,831 0 (8,831) (100.00%) SUBTOTAL 155,588 - 169,205 178,036 163,013 (15,023) (8.44%) OTHER FINANCING USES 57011 Transfers Out within Fund 190,673: 222,000 0 110,000 110,000 N/A SUBTOTAL 190,673:: 222,000 0 110,000 110,000 N/A ADMIN. CONTROL ACCOUNT 59004 Administrative Control Account 204,215 206 ,388 206,388 210,733 4,345 2.11% 59005 Admin Control Acct Clearing (204,215) (206,388) (206,388) (210,733) (4,345) 2.11% SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURES 347,424 393,705 180,5313 275,513 94,977 52.61% Increasel(Decrease) in Bonds Paya 64,051 64,051 64,051 Debt Issuance Costs 0 0 0 Restricted cash with trustee (resery (8) 0 0 Amortization of bond premium (14,432) (14,432) (14,432) Amortization of deferred amount of 7,787 7,787 7,787 Amort. of Bond Issuance Costs 0 0 0 Principal Payment (204,215) (206,388) 210,733) ENDING FUND BALANCE $111,262 $13,811 $17,954 2/272015 46 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: Sonoma Aqueduct Revenue Bonds Section/Fund No: 4285 Actual Estimated Adopted Requested Percent Account Title 2013-14 .2014-15 .2014-15 2015-16 Difference Change BEGINNING FUND BALANCE $530,928 $197,913 ; 2,500 $77,566 0 0.00% REVENUES 2003A Bond Redemption 0 2003A Deferred amount of 0 USE OF MONEY / PROPERTY 99,871 99,193 99,193 95,757 (3,436) (3.46%) 44002 Interest on Pooled Cash 3,222 1,242 1,200 1,200 0 0.00% 44003 Other Interest Earnings 32 0 0 0 0 N/A SUBTOTAL 3,254 1,242 1,200 1.200 0 0.00% OTHER FINANCING SOURCES 91,394 104,380 104,380 95,757 (8,623) (8.26%) 47101 Transfers In - within a Func 306,243 250,924 262,316 255,333 (6,983) (2.66%) SUBTOTAL 306,243 250,924 '' 262,316 255,333 (6,983) (2.66%) TOTAL REVENUES 309,497 252,166 r. -263,516 256,533 (6,983) (2.65%) EXPENDITURES SERVICES AND SUPPLIES 119,944 121,221 121,221 123,772 2,551 2.10% 51242 Bank Charges 748 2,019 2,500:. 2,500 0 0.00% SUBTOTAL 748 "2,019 ; 2,500 2,500 0 0.00% OTHER CHARGES 2003A Bond Redemption 0 2003A Deferred amount of 0 53103 Interest on LT Debt 99,871 99,193 99,193 95,757 (3,436) (3.46%) 53103 Interest on LT Debt (8,477) 0 0 0 0 N/A 53103 Interest on LT Debt 0 0 0 0 0 N/A 53105 Costs of Issuance 0 5,187 5,187 0 (5,187) (100.00%) SUBTOTAL 91,394 104,380 104,380 95,757 (8,623) (8.26%) OTHER FINANCING USES 57011 Transfers Out -within a Fw '426,528 141,000 41,000 90,000 49,000 119.51% SUBTOTAL 426,528 141,000 41,000 90,000 49,000 119.51% ADMIN. CONTROL ACCOUNT 59004 Administrative Control Acc< 119,944 121,221 121,221 123,772 2,551 2.10% 59005 Admin Control Acct Clearin (119,944) (121,221) (121,221) (123,772) (2,551) 2.10% SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURES 518,670 247,399 147,880 188,257 40,377 27.30% Proceeds from issuance 0 2003A Bond Redemption 0 2003A Deferred amount of 0 Reclass of good faith on re 0 Debt Issuance Costs 0 Restricted cash with truste( (5) Amortization of Premium N (8,477) (8,477) Amortization of deferred an 4,584 4,584 Amort. of Bond Issuance C 0 0 0 Principal Payments on Bon (119,944) (121,221) (123,772) ENDING FUND BALANCE $197,913 $77,566 $22,071 47 2/272015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: IStorage Facilities Revenue Bonds 2006 Section/Fund No: 44290 Actual Estimated Adopted Requested Percent Account Title 2013-14 - 2014-15 2014-15 2015-16 Difference Change BEGINNING FUND BALANCE $411.213 $2,562 $23,652 REVENUES (5,749) (1.28%) SUBTOTAL USE OF MONEY / PROPERTY 449,721 449,721 443,972 44002 Interest on Pooled Cast 2,097 78 180 180 0 0.00% 44003 Other Interest Earnings 58 0 0 0 0 N/A SUBTOTAL 2,155 78 180 180 0 0.00% 47101 Transfers In - within a F 444,703 449,721 449,721 443,972 (5,749) (1.28%) SUBTOTAL 444,703 449,721 449,721 443,972 (5,749) (1.28%) TOTALREVENUE 446,858 449,799 -. ; 449,901 444,152 (5,749) (1.28%) EXPENDITURES SERVICES AND SUPPLIES 51242 Bank Charges 1,312 2,500_ 2,500 2,500 0 0.00% SUBTOTAL 0 1,312 _ 2,500 ;. 2,500 2,500 0.00% 53103 Interest on LT Debt 246,828 241,334 241,334 235,628 (5,706) (2.36- 53103 Interest on LT Debt (2,223) '0 0 0 0 N/A 53105 Costs of Issuance 0 0'.:. ' 4,576 0 (4,576) (100.00%) SUBTOTAL (10,282) (4.18°/x) 244,606 .'241,334 245,910 235,628 57011 Transfers Out - withinac 470,000 40,000 0 70.000 70,000 N/A SUBTOTAL 470,000 40,000 0 70,000 70,000 N/A 59004 Administrative Control F 137;368 142,652 142,652 147,935 5,283 3.70% 59005 Admin Control Acct Cie (137,368)' (142,652) (142,652) (147,935) (5,283) 3.70% SUBTOTAL 0 0 0 0 0 N/A TOTAL EXPENDITURE 715,918 283,834 248,410 308,128 59,718 24.04% 0 Amort. of Bond ISSUanc (2,223) (2,223) (2,223) Principal Payment (137,369) (142,652) (147,935) ENDING FUND BALANCE $2,562 $23,652 $9,518 48 227/2015 FY 2015-16 BUDGET BEGINNING AND ENDING CASH SUMMARY Section Title: lCommon Facilities Revenue Bonds 2006 Section/Fund No:44295 2013-14 2014-15 2014-15 2015-16 Difference Cha BEG. FUND BALANCE $238,110 ($40) $54,530 REVENUES (5,132) (128%) SUBTOTAL USE OF MONEY / PROPERTY 401,787:: 401,787 " :: 396,655 44002 Interest on Pooled Cash 1,341 62 180 180 0 0.00% 44003 Other Interest Earnings 52 0 0 0 0 N/A SUBTOTAL 1,393 62 :..180 180 0 0.00% 47101 Transfers In -within a Fund 397,308 401,787 -: 401,787 396,655 (5,132) (128%) SUBTOTAL 397,308 401,787:: 401,787 " :: 396,655 (5,132) (1.28%) TOTAL REVENUES 398,701 401,849 < 401,967. 396,835. .(5,132) (1.28%) EXPENDITURES SERVICES AND SUPPLIES 51242 Bank Charges 1,198 2,500 2,500 2,500 0 0.00% 0 0 .0 0 0 N/A SUBTOTAL 1,198 2,500 - 2,500 2,500 0 0.00% 53103 Interest on LT Debt 220,351 215,446 215,446 210,352 (5,094) (2.36%) 53103 Interest on LT Debt (11,984) 0 0 0 0 NIA 53105 Costs of Issuance 0 -: 0 4,085 0 (4,085) (100.00%) SUBTOTAL 218,366 -, 215,446 219,531 210,352 (9,179) (4.18%) OTHER FINANCING USES 57011 Transfers Out -within a Funs 290,701 0 0 100,000 100,000 NIA SUBTOTAL 290,701 0 0 100,000 100,000 NIA ADMIN. CONTROL ACCOUNT 59004 Administrative Control ACCOL 122,632 127,349 127,349 132,065 4,716 3.70% 59005 Admin Control Acct Clearing (122,632) (127,349) (127,349) (132,065) (4,716) 3.70% SUBTOTAL 0 0 a 0 0 N/A TOTAL EXPENDITURES 510,265 217,946 222,031 312,852 90,821 40.90% Proceeds from issuance 0 Advance to Common 0 Amort of Bond Premium (1,984) (1,984) 0 Restricted Cash with Truster (1,970) Amort. of Bond Issuance Co 0 0 0 ENDING FUND BALANCE 2/27/2015 49 REVENUE BOND I STATE LOAN CHARGES -WATER RATES AND ESTIMATED REVENUES FOR FY 15-16 A ANNUAL DEBT SERVICE REQUIREMENTS Watershed 2012 A Revenue Bomr PRINCIPAL INTEREST FISCAL AGENT FEES DEBT ISSUANCE COSTS DISCOUNTIBONDS Total Individual Bond Payment. Bond Reserve Total Individual Bond Debt Servic, Revenue Bond (New Money PRINCIPAL INTEREST FISCAL AGENT FEES DEBT ISSUANCE COSTS DISCOUNTIBONDS Total individual Bond Payment Bond Reserve Total Individual Bond Debt Service 2086 A Revenue Bon, PRINCIPAL INTEREST FISCAL AGENT FEES DEBT ISSUANCE COSTS DISCOUNTIBONDS Total Individual Bond Payment Bond Resery Total Individual Bond Debt Serviu 2013 Capital Fund Loan PRINCIPAL INTEREST FISCAL AGENT FEES DEBT ISSUANCE COSTS $210,733 163,013 2,500 0 0 0 D B 0 675496 S13" 065 210 352 2 500 a 51 0 0 0 0 0 Total Individual Loan Payments ". a Loan Reserve Total Individual Loan Debt Service 2013 Santa Rasa AQ Capital Fund Loan PRINCIPAL INTEREST FISCAL AGENT FEES - DEBTISSUANCECOSTS DISCOUNTIBONDS Total Individual Loan Payments Loan Reserve Total Individual Loan Debt Service 2013 Petaluma AQ Capital Fund Loan PRINCIPAL 72,616 INTEREST 163,281 FISCAL AGENT FEES 0 DEBT ISSUANCE COSTS 0 DISCOUNT/BONDS 0 Total Individual Loan Payments 235,897 Loan Reserve Total Individual Loan Debt Service 235,897 TBD - PRINCIPAL 0 NTEREST 0 FISCALAGENTFEES 0 DEBT ISSUANCE COSTS 0 Total Individual Bond Payments 0 $150,496 5123,772 116,382 95,757 2,580 2,500 0 269,378 222,029 40.407 33,304 309,785 255,333 675488 0 0 0 0 0 0 0 0 00 0 0 0 0 875488 5147,935 235,628 2,500 TBD -Water Edl TBD - 28,338 63,719 0 0 0 92,058 0 50 2/27/2015 REVENUE BOND/ STATE LOAN CHARGES -WATER RATES AND ESTIMATED REVENUES FOR FY 15-16 A. ANNUAL DEBT SERVICE REQUIREMENTS Reserve Total individual Financing Debt Service SRF LOAN PRINCIPAL INTEREST USE OF SRF LOAN FUND BALANCE .675439 Reserve Requirement Total SRF Debt Service SRF LOAN RESERVE RESERVE Total SRF Debt Service TOTAL DEBT SERVICE LESS REV. FROM N. MARIN REV. BOND CHARGES REMAINING REVENUE REQUIREMENT B. CALCULATIONS OF WATER RATES FOR FY 15-16 231,628 2 ESTIMATED WATER DELIVERIES TO NORTH MARIN (IN A.F.) 7,810 Sonoma Common Watershed Plan Water Storage Pipeline Facilities Restoration Conservation Facilities Facilities 0 0 0 0 0 0 0 0 0 0 675439 -. Charge Charge Charge Charge 730,354 $0 $0 N.A N.A 309,880 APPLICABLE BASE WATER DELIVERIES IN AF_ 34,18060 N.A N.A 0 4,118.1 CHARGES PER ACRE-FEET :$53.88 $0.00 1,040,234 $24.75 $62.00 675447 N.A N.A 1,040,234 $2,105,469 $0 $0 $845,815 $255,333 263,737 $1,841,731 SO $0 $845,815 $255,333 B. CALCULATIONS OF WATER RATES FOR FY 15-16 REVENUE REQUIREMENT FOR COMMON FACILITIES DEBT SERVICE (Remaining Facilities per RA 4.3a2) 1,869,571 -. a.. N. NIARIN'S SHARE (REV. REQfdT FOR COMMON FAC. DEBT SERVICE X (11.2/90.4)) 231,628 2 ESTIMATED WATER DELIVERIES TO NORTH MARIN (IN A.F.) 7,810 NORTH MARIN REVENUE BONDS CHARGE Sonoma REVENUE REQUIREMENT: FOR COMMON FACILITIES DEBT SERVICE (Additional Facilities per RA 4.3b9) Common Watershed Plan -Water Storage Pipeline NORTH MARIN REVENUE BONDS CHARGE Facilities Restoration Conservation Facilities Facilities N. Mann's Share (11.2/90.4) 231,628 Total Revenue Required $2,105,469 Debt Service Debt Service Debt Service Revenue Bonds Revenue Bonds Charge -. Charge Charge Charge Charge $1,841,731.31 $0 $0 $845,815 $255,333 REVENUE REQUIREMENT APPLICABLE BASE WATER DELIVERIES IN AF_ 34,18060 150,486.3 50,4B6,3 34,180.60 4,118.1 CHARGES PER ACRE-FEET :$53.88 $0.00 $0.00 $24.75 $62.00 REVENUE REQUIREMENT FOR COMMON FACILITIES DEBT SERVICE (Remaining Facilities per RA 4.3a2) 1,869,571 -. a.. N. NIARIN'S SHARE (REV. REQfdT FOR COMMON FAC. DEBT SERVICE X (11.2/90.4)) 231,628 2 ESTIMATED WATER DELIVERIES TO NORTH MARIN (IN A.F.) 7,810 NORTH MARIN REVENUE BONDS CHARGE 29.66 REVENUE REQUIREMENT: FOR COMMON FACILITIES DEBT SERVICE (Additional Facilities per RA 4.3b9) 235,897 N. MARIN'S SHARE (REV. REQMT. FOR COMMON FAC. DEBT SERVICE X (19.9/146.2)) 32,109 ESTIMATED WATER DELIVERIES TO NORTH MARIN (IN A.F.) 7,810 NORTH MARIN REVENUE BONDS CHARGE 4.12 Common Facilities Debt Service RA 4.3a2 (remaining facilities) 1,869,571 N. Mann's Share (11.2/90.4) 231,628 Total Revenue Required $2,105,469 Estimated Water Deliveries to N. Marin 7,81(13 Debt service - loan to Common (235,897) Applicable portion of the N. Marin R. Bonds Charge $29.66 Revenue base for NMWD $1,869,571 Debt Service RA 4.3b9 (additional facilities) 235,897 Per Agreement (Steve Shupe and Chris DeGabrielle - 3/2/12) N. Mann's Share (19.9/146.2) 32,189 Estimated Water Deliveries to N. Marin 7,810 Update formula for the lesser of three years or 12 months average delivery. Applicable portion of the N. Marin R. Bonds Charge $ 4.12 Total NMWD Share 263,737 NMWD Total Bonds Charge $33.77 51 2127/2015 FY 2015-16 BUDGET Water Transmission System - Fund Balances and Operating Transfers Total 19,527,784 .:..19,527,784 18,756,261 17,332,920 (1,423,341) Common Facilities OT - in 47101 From Beginning Fund Ending Fund Water Transmission (Charges) Increase Fund Index OT Out (57011) To OT In (47101) 2006 Bond Fund Balance Balance (Decrease) Agency Fund (Charges) OT - Out Santa Rosa Aq. Capital Fund 44230 415,000 Pipeline Facilities 433,323 $ 2,901,586 $ 2,994,428 $ 92,842 Petaluma Aq. Capital Fund 44235 350,000 Pipeline Facilities 273,495 $ 2,566,306 $ 2,740,698 $ 174,392 Sonoma Aq. apital Fund 44240 50,000 170,423 $ 663 $ $ 121,623 Sonoma Rev Bond 2012 Fund 44285 90,000 Pipeline Facilities 255,333 $ 77,567 $ 22,071 $ (55,496) Storage Rev Bond 2012 Fund 44280 40,000 Storage Facilities 309,785 $ 11,262 $ 11,759 S 497 Storage Rev Bond 2006 Fund 44290 70,000 Storage Facilities 443,972 $ 23,652 $ 9,519 $ (14,133) Common Rev Bond 2012 Fund 44275 110,000 Common Facilities 432,693 $ 13,812 $ 17,954 $ 4,143 Common Rev Bond 2006 Fund 44295 100,000 Common Facilities 396,655 $ 54,530 $ 6,448 $ (48,082) State Loan Debt Service 44265 0 1.040,234 $ 23,251 $ 24,751 $ 1,500 State Loan Reserve 44270 0 0 $ - $ - S - Capilal Lease Financing 675371 0 0 S - $ - $ - Agency Fund (Discretionary) 44205 6,670,000 Common Facilities 0 $ 5,007,960 $ 5,020,420 $ 12,460 Agency Fund (Charges) 44205 11,632,784 0 $ - $ - $ - Pipeline Facilities 44255 905,000 $ 883,662 $ 433,752 $ (449,910) Storage Facilities 44250 110,000 $ 145,315 $ 114,367 $ (30,948) Common Facilities 44260 0 6,880,000 $ 593,955 $ 84,058 S (509,897) North Marin 44300 0 0- $ 13,022 $ 13,123 $ 101 Water Management Planning 44210 198,500 $ 313,802 $ 251,958 $ (61,844) Watershed Planning/Restoration 44215 4,030,500. $ 4,726,273 $ 4,349,217 $ (377,056) Recycled Water & Local Supply 44220 -1,597,600 $'- 1,122,070 S 777,937 $ (344,133) Water Conservation 44225 = 2;050,281 $ 277,575 $ 338,175 $ 60,600 Total 19,527,784 .:..19,527,784 18,756,261 17,332,920 (1,423,341) Common Facilities OT - in 47101 From Water Transmission (discretionary) 6,670,000 Water Transmission (Charges) - North Marin - 2012 Bond Fund 110,000 2006 Bond Fund 100,000 6,880,000 Agency Fund (Charges) OT - Out Santa Rosa Aq. Capital Fund 433,322 96 Petaluma Art. Capital Fund 273,495 12 Sonoma Aq. Capital Fund 170,422.60 Sonoma Rev Bond 2012 Fund 255,333.35. C Storage Rev Bond 2012 Fund 309,784.70:=. Storage Rev Bond 2006 Fund 443,972.45 Common Rev Bond 2012 Fund 432,682.90 Common Rev Bond 2006 Fund 396,654.55 State Loan Debt Service 1,040,234.00 Stale Loan Reserve 0.00 Common Facilities 6,670,000.00 Water Management Planning 198,500 Watershed PlanninglRestoration 4,030,500 Recycled Water & Local Supply 1,597,600 Water Conservation 2,050,281 18,302,784 2/27/2015 52