Loading...
HomeMy WebLinkAbout14 Reference 335 Contingency Reserve Requirements Worksheet (per Section XII.B of Fiscal and Budgetary Policy) -------------------- B Y F U N D -------------------- CITY WIDE General Electric Water Services Total budgeted expenditures 231,124,287 51,695,797 72,304,895 41,451,316 Less: Purchased Power- Electric (37,073,038)(37,073,038) Sanitation Contract - General (5,259,568)(5,259,568) Social Service & Contingency funding (710,049)(710,049) Capital Improvements - Electric, WW, Water (23,132,000)(10,413,000) (12,719,000) Capital Improvements - Other Enterprise Funds (3,397,561) Capital Improvements - GCP & Streets (11,667,620) Capital Maintenance - General/Utilities (3,207,230)(1,483,730) (1,040,000)(683,500) Capital Improvements - Special Revenue Funds (2,394,900) Restricted Special Revenue funds (3,265,506) Airport Fuel Charge (2,228,000) Debt Service - General (11,359,651) One-Time Only Expenses (901,493)(851,493)(50,000) Interfund Transfers (12,805,301)(523,998) (4,722,933)(4,693,151) Interfund Charges (23,410,489)(12,317,636) (6,290,197)(4,802,656) Budgeted operating expenditures 90,311,881 30,549,323 12,715,727 18,553,009 Percentage reserve requirements: 60 days - 16.67%15,051,980 5,091,554 2,119,288 3,092,168 75 days - 20.83%18,814,975 6,364,442 2,649,110 3,865,210 90 days - 25%22,577,970 7,637,331 3,178,932 4,638,252 09/30 RESERVE BALANCES: Minimum Minimum Current Days Amount Amount Fund Required Required Included Electric Fund N/A 2,649,110 6,215,000 General Fund 90 days 7,637,331 7,695,000 Stormwater Drainage Fund N/A 250,000 250,000 Water Services Fund 90 days 4,638,252 4,565,000 Airport Fund N/A 119,507 119,507 Airport Fund contingency adjustment (120,000)(funded with Electric per policy) Convention & Visitors Bureau SRF 60 days 75,000 75,000 All other City Funds expenditures N/A*3,445,775 N/A (held in other operating funds) Totals for all expenditures 75 days 18,814,975 18,799,507 Note:The city-wide contingency reserve requirement is 75 days of operating expenses. Only the General, Stormwater Drainage, Water Services, and Convention and Visitors Bureau SRF have a specific minimum fund reserve requirement. All excess reserves for City expenditures in funds that do not have a specific fund requirement are held in other operating funds. 336 Financial Ratio Comparisons Georgetown has chosen to measure its financial condition against cities in the surrounding area that have similar size, location or growth issues. The acceptable levels referred to below are based on the City’s Fiscal and Budgetary Policy. (per Section XII.G of the Fiscal and Budgetary Policy) Fund Balance to Equity ratio is a function of fund balance to equity for governmental type funds (General Fund, Special Revenue, etc.). Working capital is the liquid reserve available to meet uncertainties. It is a function of current assets less current liabilities. Current ratio and quick ratio are measures of liquidity. Liquidity is an organization's ability to convert noncash assets into cash or to obtain cash to meet impending obligations. Current ratio includes inventories and prepaid expenses, whereas the Quick ratio excludes inventories and prepaid expenditures. A ratio of 1 or greater is an acceptable level for both ratios. 337 Financial Ratio Comparisons Georgetown has chosen to measure its financial condition against cities in the surrounding area that have similar size, location or growth issues. The acceptable levels referred to below are based on the City’s Fiscal and Budgetary Policy. (per Section XII.G of the Fiscal and Budgetary Policy) Debt to assessed value is a ratio of the assessed value to tax supported debt. A ratio or less than 5 is acceptable. The ratio of current liabilities plus long term debt to total assets. A ratio of 1 or lower is acceptable. Enterprise operational coverage is a ratio of operating revenue to operating expenses of the city's combined enterprise funds. A ratio of 1.25 or greater is acceptable. Number of times the utility debt service requirements would be covered by the current utility operating revenue net of current operating expense. A ratio of 1.5 or greater is acceptable. 338 Personnel Summary by Division 2013 - 2016 12/13 13/14 13/14 FINAL / ORIGINAL FINAL / 14/15 15/16 PERSONNEL SUMMARY ACTUAL BUDGET ACTUAL ADOPTED PROJECTED DOWNTOWN & COMMUNITY SERVICES Administration 3.5 3.5 3.5 4 4 Facilities Maintenance 0 0 0 7 7 Public Communications 0 2 2 3 3 Convention & Visitor's Bureau 3.5 3.5 3.5 4 4 Main Street 1 1 1 1 1 Public Library 19/2.5 19/2.5 19/2.5 19/2.5 19/2.5 Parks Admin 2 2 2 2 2 Parks 17/1.5 17/1.5 17/1.5 18/1.5 18/1.5 Recreation 20/18.5 20/18.5 20/18.5 22/19.5 22/19.5 Total (FT/PT)66/22.5 68/22.5 68/22.5 80/23.5 80/23.5 FINANCE & ADMINISTRATION Administration 6 5 5 5 5 Accounting 8 9 9 9 9 Municipal Court 6 6 7 7 7 Purchasing and Properties 7 8 8 8 8 Facilities Maintenance 6 7 7 0 0 Fleet Services 8 8 8 8 8 Information Technology 9 12 12 18 18 GIS 4 4 4 0 0 Customer Care 18 19 19 19 19 Total (FT/PT)72 78 79 74 74 FIRE SERVICES Support Services 6 7 7 10 10 Emergency Services 84 86 86 93 93 Total (FT/PT)90 93 93 103 103 GEORGETOWN UTILITY SYSTEMS Administration 6 7 7 9 9Conservation34466 Electric Admin 1.5 1.5 1.5 1.5 1.5 Electric 32 34 34 36 36 T&D Operations 20 21 21 22 22 Systems Engineering 20 12 12 12 12 Engineering Support 0 8 8 8 8 Inspections 10 10 10 10 10 Environmental Services 1 1 1 1 1 Water Services - Administration 0.5 0.5 0.5 0.5 0.5 Water Services - Reuse Irrigation 1 1 1 1 1 Water Services - Wastewater 14 14 14 14 14 Water Services - Water 17 17 17 19 19 Total (FT/PT)126 131 131 140 140 MANAGEMENT SERVICES City Secretary 3 4 4 5 5 City Manager's Office 5/.5 5/.5 4/.5 3/.5 3/.5 Planning 8 8 8 9 9 Legal 4 4 5 5 5 Public Communications 2 0 0 0 0 Economic Development 2 2/.5 2/.5 3 3 Human Resources 6/.5 6 6 7 7 Total (FT/PT)30/1 29/1 29/1 32/.5 32/.5 POLICE SERVICES Administration 4 4 4 4 4 Operations 98 98 98 101/.5 101/.5 Animal Services 6/3.25 9/1.5 9/1.5 9/1.5 9/1.5 Code Enforcement 4 4 4 5 5 Total (FT/PT)112/3.25 115/1.5 115/1.5 119/2.0 119/2.0 TRANSPORTATION SERVICES Transportation Admin 2 3 3 3 3Streets18/.75 18/.75 18/.75 18/.75 18/.75 Airport 2/3.5 3/2.5 3/2.5 3/2.5 3/2.5 Stormwater Drainage 5/.5 7/.5 7/.5 7/.5 7/.5 Total (FT/PT)27/4.75 31/3.75 31/3.75 31/3.75 31/3.75 TOTAL CITY OF GEORGETOWN (FT/PT)523/31.50 545/28.75 546/28.75 579/29.75 579/29.75 339 Personnel Summary 2014/15 Base Position Summary 340 Personnel Summary 2014/15 13/14 Final / Actual 14/15 Base Budget Proposed Staff Additions 14/15 Funded Positions Downtown & Community Services 90.50 97.50 6.00 103.50 Finance 79.00 72.00 2.00 74.00 Fire 93.00 94.00 9.00 103.00 GUS 131.00 130.00 10.00 140.00 Management Services 30.00 30.00 2.50 32.50 Police 116.50 116.50 4.50 121.00 Transportation 34.75 34.75 - 34.75 Total 574.75 574.75 34.00 608.75 341 New Positions 2014/15 Division/Dept NEW POSITIONS FTEs Hire Date Downtown & Community Services Communications Media Marketing Specialist 1 April 2015 CVB Group Sales & Servicing Coordinator 1 June 2015 Parks & Recreation Aquatic Specialist 1 April 2015 Parks & Recreation Senior Parks Maintenance Worker 1 June 2015 Parks & Recreation Recreation Specialist 1 April 2015 Parks & Recreation Recreation Assistants (2 PT)1 April 2015 Finance & Administration IT Systems Administrator 1 October 2014 IT Desktop Tech 1 October 2014 Fire Emergency Svcs Public Safety - Fire Based Paramedic Prog.9 October 2014 Georgetown Utility Systems (GUS) GUS Admin Office Specialist (Records)1 October 2014 Inspections Building Plans Examiner 1 April 2015 Conservation Svcs Landscape Inspector 1 October 2014 Conservation Svcs Conservation Program Analyst 1 October 2014 Electric Ops Tech Services Manager 1 October 2014 Electric Ops Project Coordinator 1 October 2014 Electric Ops Metering Tech 1 October 2014 T&D Svcs Utility Locator 1 October 2014 Water Operations Operations Specialist 1 October 2014 Water Operations Technician Trainee 1 October 2014 Management Services City Secretary Administrative Assistant (Records)1 October 2014 Economic Development Business Development Program Manager 0.5 October 2014 Planning Planner 1 April 2015 Police Operations Police Officers 3 April 2015 Operations Volunteer In Police Services Coordinator 0.5 April 2015 Code Enforcement Code Enforcement Officer 1 April 2015 TOTAL NEW POSITIONS 34 342 Service Level Improvements & Program Requests Funded in Current Year (by Division) Division / Dept Description FTE Total 1X Downtown & Community Services D&CS Admin HARC Training Funds 2,500 D&CS Admin New Street Signs for Downtown and Old Town Historic District 25,000 D&CS Admin Historic Resource Survey Update 50,000 X D&CS Admin FEMA Matching Grants 5,000 X D&CS Admin CDBG Administration & Matching Funds 10,000 D&CS Admin Home Grant Funds 24,000 TOTAL DOWNTOWN & COMMUNITY SERVICES ADMIN 116,500$ Communications Website & E-Newsletter Upgrade & Social Media Archiving 5,029 Communications City Annual Report 12,000 Communications Media Marketing Specialist (Hire April 2015)1 42,105 Communications GTV Capital Costs 37,520 TOTAL COMMUNICATIONS OFFICE 96,654$ CVB Visitor's Guide & Update CVB Website 12,000 X CVB Group Sales & Servicing Coordinator (Hire June 2015)1 26,584 CVB Advertising, Public Relations & Content Production 69,400 CVB CVB Conference Planner 8,000 X CVB Christmas Wreaths for Main Street & Austin Ave.9,600 X TOTAL CVB 125,584$ Library Temporary On-Call Staff 5,483 Library Expand Programs Library 8,000 TOTAL LIBRARY 13,483$ Main Street Annual Downtown Holiday Lighting 30,000 Main Street Façade Main Street Fund Raisers 10,000 X TOTAL MAIN STREET 40,000$ Parks ADA Self-Assessment Survey 27,150 X Recreation Playground Audits 25,000 X Recreation Aquatic Specialist (April 2015)1 31,395 Recreation Recreation Center Sunday Operations (April 2015)2 66,951 Recreation Senior Parks Maintenance Worker (Trails Lead Position) (Hire June 2015)1 47,066 Recreation Aquatic Supervisor (position upgrade)3,054 Recreation Recreation Specialist Senior (Athletics) (position upgrade)8,551 Recreation Big Belly Solar Trashcans 44,359 X Recreation Community Center Projection Screen & Projector 25,000 X Rec Programs NOLS Wilderness First Responder Recertification Course 7,300 X TOTAL PARKS 285,826$ Facilities Increase in Janitorial Service (5 Days per Weeks)50,000 Facilities Art Center Exterior Cleaning/Mortar Restoration 50,000 X Facilities Rec Center Pool Deck Grinding 90,000 X Facilities Fire Alarm Detection & Notification System - CVB/Fire Station 2 40,000 X Facilities Security System Embedded Technician 60,000 Facilities Grace Heritage Restoration Design 25,000 X TOTAL FACILITIES 315,000$ TOTAL DOWNTOWN & COMMUNITY SERVICES 6 993,047$ 343 Division / Dept Description FTE Total 1X Finance & Administration Finance & Admin Review & Evaluation for FIS 20,000 TOTAL ACCOUNTING 20,000$ Customer Care Customer Information System 4,500,000 Customer Care Customer Demographic Research 4,500 X Customer Care Customer Data Management & Analytics 60,000 TOTAL CUSTOMER CARE 4,564,500$ IT Add Second Systems Administrator Position within IT 1 105,314 IT Replace Current Data Back Up Solution with Improved Product 70,000 IT Desktop Tech Position 1 65,513 IT Expand Virtual Desktop Environment 56,500 X TOTAL IT 297,327$ Vehicle Svcs Integrate Fleet Data Management into the City's EAM System 138,516 X TOTAL VEHICLE SERVICES 138,516$ TOTAL FINANCE & ADMINISTRATION 2 5,020,343$ Fire Emergency Svcs Public Safety - Fire Based Paramedic 9 1,321,885 Emergency Svcs Special Services 20,000 Emergency Svcs Electronic Patient Care Reporting (ePCR)150,000 X Emergency Svcs Travel & Training Increase 15,000 Emergency Svcs Uniforms 6,735 Emergency Svcs CAD/WEBEX Equipment for All Fire Stations 5,000 X Emergency Svcs Educational Supplies 2,500 Emergency Svcs SCBA Supplies & Special Events 2,500 Emergency Svcs Rope & Rescue Team 8,000 Emergency Svcs Dive/Swift Water Team 8,000 Emergency Svcs Medical Supplies 10,000 Emergency Svcs Pipe Band/Honor Guard 2,500 Emergency Svcs Salary for Medical Director & Misc. Operating Costs 75,000 TOTAL EMERGENCY SERVICES 1,627,120$ Support Svcs Haz Mat 5,000 X TOTAL SUPPORT SERVICES 5,000$ TOTAL FIRE 9 1,632,120$ 344 Division / Dept Description FTE Total 1X GUS GUS Admin Office Specialist (Records)1 52,556 TOTAL GUS ADMIN 52,556$ Conservation Landscape Inspector 1 127,398 Conservation Conservation Program Analyst 1 127,398 Conservation Drought Research Project with TAMU Agrilife 48,500 Conservation Water Conservation Education Program 43,700 Conservation Energy Efficiency Education 47,600 TOTAL CONSERVATION 394,596$ T&D Services Add 3rd Utility Locator Due to System Growth 1 126,171 TOTAL T&D Services 126,171$ Electric Sys. Eng.Replace Project Coordinator / Reclassed for EAM 1 133,049 TOTAL ELECTRIC SYSTEM ENGINEERING 133,049$ Energy Svcs Replace Metering Tech Position Reclassed for an EAM Planner 1 75,756 Energy Svcs Tech Services Manager 1 140,403 TOTAL ENERGY SERVICES 216,159$ Inspections Building Plans Examiner (Hire April 2015)1 37,408 TOTAL INSPECTIONS 37,408$ Water Operations Crew Truck & 2 FTE to Maintain Service Level for System Growth 2 230,981 TOTAL WATER OPERATIONS 230,981$ Eng. Support High Resolution Orthophotography Covering the Existing Utility Boundaries 30,000 X TOTAL ENGINEERING SUPPORT 30,000$ TOTAL GUS 10 1,220,920$ Management Services City Secretary Laser fiche License Purchases 8,000 City Secretary Laser fiche Signature Pad Implementation 12,000 X City Secretary Laser fiche Management Services Document Scanning 5,000 City Secretary Records Management Administrative Assistant 1 69,166 City Secretary Archiving Historical Records 18,000 City Secretary Continuation & Maintenance of Laser fiche Program TOTAL CITY SECRETARY 112,166$ Gov. Contracts WCCD Board Increase in Funding per Population & Level II Mosquito Control Program 11,397 Gov. Contracts Renovate Kitchen at Mary Bailey Head Start Center 6,344 X TOTAL GOVERNMENT CONTRACTS 17,741$ Eco Devo Business Development Program Manager 0.5 95,220 TOTAL ECONOMIC DEVELOPMENT 95,220$ HR Safety Program -Consultant 20,000 TOTAL HUMAN RESOURCES 20,000$ Planning Consulting Services 9,500 X Planning Planner (Hire April 2015)1 43,110 Planning Study 2006 Williamson Dr. Gateway Plan Redevelopment & Rezoning 24,525 X TOTAL PLANNING 77,135$ TOTAL MANAGEMENT SERVICES 2.5 322,262$ 345 Division / Dept Description FTE Total 1X Police Admin FATPOT SunGard 3,400 TOTAL ADMINISTRATIVE SERVICES 3,400$ Code Enforcement Code Enforcement Officer (Hire April 2015)1 82,293 TOTAL ANIMAL SERVICES 82,293$ Operations Deployment Unit (Hire April 2015)3 331,246 Operations Emergency Communication Operators 230,000 Operations Volunteer in Police Services (VIPS) Coordinator - Part Time (Hire April 2015)0.5 13,012 Operations Community Services 13,000 Operations Establish Bike Patrol Line Item 8,400 Operations Establish Honor Guard Line Item 5,000 Operations Sexual Assault Nurses Exam Kit (SANE)6,400 Operations Mine-Resistant Ambush Protected (MRAP) vehicle 12,500 Operations Williamson County Children's Advocacy Center (CAC)5,000 Operations Purchase the Cellebrite Equipment to Assist in Cell Phone Forensics 11,000 TOTAL PD OPERATIONS 635,558$ TOTAL POLICE 4.5 721,251$ Transportation Services Admin Review Possibility of a Road Bond to Include Only the Highest Priorities 80,000 X Admin Expansion of Transit Program 117,100 Admin Public Works Director 67,720 TOTAL TRANSPORTATION ADMIN 264,820$ Stormwater Crew Truck 56,545 Stormwater Special Services Increase from $45K to $69K 24,000 Stormwater Establish a Telephone Line Item in Stormwater 5,080 Stormwater Drainage Overtime 6,108 TOTAL STORMWATER 91,733$ Streets Crack Sealing Crew 103,945 Streets Additional Distributor Truck 169,900 TOTAL STREETS 273,845$ TOTAL TRANSPORTATION 630,398$ GRAND TOTAL SERVICE LEVEL/PROGRAM REQUESTS 34 10,540,341$ 346 Internal Service Premiums * With Programs Department Facilities Maintenance Fleet Information Services Joint Services General General Fund Transportation Administration - 9,282 14,592 - - Streets - 235,552 87,549 - - Planning 24,749 4,310 42,635 - - Inspection Services 31,500 35,881 96,953 - - Code Enforcement 0 24,075 26,146 - - Municipal Court 14,811 - 29,725 - - Fire Services Administration 421,602 - 34,875 - - Fire Operations - 229,446 428,464 - - Environmental Services - - 9,695 - - City Manager's Office 49,894 10,458 26,647 - - General Government 18,310 - - 3,087,145 - City Council 44,295 - 21,317 - - Communications 2,234 - 10,413 - - Downtown & Comm Services Admin 29,865 - 18,223 - - Parks 209,963 199,241 99,424 - - Recreation 678,793 25,721 104,131 - - Library 343,481 11,991 98,924 - - Police Administration 462,063 350,114 666,720 - - Animal Services 72,342 17,689 58,828 - - Economic Development & Tourism SRF Convention & Visitors Bureau 80,173 - 18,223 - 10,120 Facilities Maintenance Fund Facilities Maintenance - 44,176 34,680 - - Fleet Management Fund Vehicle Service Center 24,632 47,681 39,634 - - Joint Services Fund Economic Development 20,105 - 10,659 - - Main Street - - 5,207 - - GUS Administration 147,711 4,856 67,867 - - Systems Engineering - 58,178 193,906 - - Finance Administration 31,695 - 24,771 - - Accounting - - 44,588 - - Purchasing 47,074 18,014 39,634 - - Utility Office 48,726 15,325 94,131 - - Environmental & Conservation Services - 28,913 38,781 62,939 - Human Resources 32,426 - 31,976 - - Legal 8,074 - 21,317 - - 347 Internal Service Premiums * With Programs Department Facilities Maintenance Fleet Information Services Joint Services General Information Services Fund Information Resources 47,580 9,163 79,268 - - Electric Fund Administration 14,769 609,384 592,784 4,119,743 954,286 Water Services Fund Administration - 471,828 340,097 3,546,667 444,064 Stormwater Drainage Fund Stormwater Drainage - 135,350 34,047 828,838 150,907 Airport Fund Airport Operations 141,171 30,149 14,592 54,992 122,896 Total 3,048,038 2,626,777 3,601,423 11,700,324 *1,682,273 ** * Excludes intergovernmental charges to GTEC of $53,816 * Excludes intergovernmental charges to GEDCO of $152,864 ** Excludes intergovernmental charges to GTEC of $285,876 Internal Service Fund premiums include: Facilities Maintenance  Contracts and repairs for buildings and grounds are charged to departments based on actual usage and charges. Fleet  Vehicle lease fees are charged to departments based on actual replacement costs. Maintenance fees are charged based on each department’s prior year actual usage. Information Technology  Computer and software lease fees are charged to departments based on replacement costs and estimated usage. Joint Services and General (nondepartment)  Fees are charged to funds receiving administrative services from another fund based on a reasonable, rational basis. The following factors are used as applicable.  relative revenues  relative personnel  number of utility accounts  number of work orders  number of requisitions 348 Transfers Between Funds T R A N S F E RS T O General Fund Gen Cap Projects SRF Fleet Joint Services Information Technology Electric Water Total Out: General Fund 152,386 50,600 53,410 259,172 8,430 523,998 T R Gen Cap Projects 1,208,000 1,208,000 A N SRF 20,000 302,000 698,000 150,850 1,170,850 S F Fleet 243,516 243,516 E R Joint Services 785 785 S Electric 4,464,952 88,675 85,348 14,850 69,108 4,722,933 F R Water Services 2,264,505 75,675 70,016 3,450 2,279,505 4,693,151 O M Airport 3,463 3,463 Stormwater Drainage 173,318 49,500 15,787 238,605 Total In:6,922,775 302,000 152,386 2,170,450 228,024 672,623 2,287,935 69,108 12,805,301 Interfund transfers include: Dividend to General Fund:  Per the City’s Fiscal and Budgetary Policy, utility operations transfer seven percent of its gross billings for utility services to the General Fund as a payment of the profits of the fund or a return on investment. The total return on investment transfer to the General Fund is $6,477,775 in 2014/15. Other Transfers:  Other transfers include grant matching, fire hydrant testing, and equipment purchases to other funds. 349 General Fund Five Year Projections Projected Projected Projected Projected Projected FY15 FY16 FY17 FY18 FY19 Beginning Fund Balance 9,940,212 7,781,182 8,456,137 8,669,808 8,886,275 Revenues Property Taxes 11,109,039 12,706,309 12,770,906 13,612,225 14,274,235 Sales Tax 11,805,875 12,160,051 12,433,652 12,682,325 12,967,678 Sanitation Revenue 6,211,991 6,286,535 6,380,833 6,412,737 6,476,864 Interest 25,000 25,000 25,000 25,125 25,000 Administrative Charges 1,958,029 1,981,525 2,011,248 2,021,304 2,051,674 All Other Revenue 11,504,058 12,234,139 12,478,822 12,541,216 12,792,040 Return on Investment 6,477,775 7,671,681 7,825,115 7,981,617 8,141,249 Transfers In 445,000 460,575 474,392 479,136 483,928 Total Revenues 49,536,767 53,525,815 54,399,968 55,755,685 57,212,668 Expenses Downtown & Community Svcs 9,790,974 9,946,220 10,136,589 10,541,218 10,910,161 Finance & Administration 552,164 568,729 576,515 599,156 620,126 Fire Department 10,759,601 11,077,239 11,520,329 11,981,142 12,400,482 Georgetown Utility Systems 6,456,274 6,649,962 6,915,961 7,192,599 7,444,340 Management Services 2,746,755 2,765,813 2,607,389 2,285,910 2,291,093 Police Department 13,115,778 13,413,903 13,808,811 14,219,516 14,576,232 Transportation 4,663,108 4,725,236 4,789,758 4,735,492 4,615,781 Administrative Expense 3,087,145 3,179,759 3,306,950 3,439,228 3,559,601 Transfers Out 523,998 523,998 523,998 544,958 564,031 Total Expenses 51,695,797 52,850,859 54,186,300 55,539,219 56,981,847 Ending Fund Balance 7,781,182 8,456,138 8,669,805 8,886,274 9,117,096 Contingency 7,695,000 8,456,138 8,669,805 8,886,274 9,117,096 Available Fund Balance 86,182 0 0 0 0 Effective Tax rate Operations & Maint.0.20740 0.26960 0.26170 0.27530 0.28390 Debt Service 0.22660 0.21530 0.25190 0.25390 0.25540 Total 0.43400 0.48490 0.51360 0.52920 0.53930 350 Water Services Fund Five Year Projections The projections assume no water or wastewater retail rate increases through the five year horizon. Rates, capital improvements and system operations are reviewed as part of the annual budget planning process. Strategies for any identified potential shortfalls will be implemented as needed to eliminate the deficits. Projected Projected Projected Projected Projected FY15 FY16 FY17 FY18 FY19 Beginning Fund Balance 19,175,665 19,175,665 19,175,665 19,175,665 19,175,665 Primary Revenues Water Services 31,698,634 31,918,557 32,293,119 32,674,113 33,061,668 Other Water 2,986,000 3,065,500 3,147,385 3,231,727 3,318,598 Wastewater 1,115,500 1,143,850 1,173,051 1,203,127 1,234,106 Irrigation 0 0 0 0 0 Total Primary Revenue 35,800,134 36,127,907 36,613,555 37,108,967 37,614,372 Primary Expenses Contracts 9,951,126 10,048,159 10,147,672 10,249,732 10,354,407 Water 11,861,736 12,301,883 12,477,999 12,648,126 12,949,937 Wastewater 2,611,959 2,683,223 2,756,624 2,832,228 2,910,100 Irrigation 181,775 190,864 200,407 210,427 220,949 CIP Expense 15,885,500 20,110,000 20,319,000 23,634,000 34,445,000 Total Primary Expenses 40,492,096 45,334,128 45,901,703 49,574,513 60,880,393 Other Revenue SIP Fees 634,250 253,700 0 0 0 Other 171,908 171,908 171,908 171,908 171,908 Bond Revenue 7,990,000 14,040,000 12,163,000 11,919,000 22,116,000 Total Other Revenue 8,796,158 14,465,608 12,334,908 12,090,908 22,287,908 Other Expenses Transfer Out 2,501,940 1,994,299 2,020,518 2,047,188 2,074,317 CAFR Adjustment 0 0 0 0 0 Debt Service 4,575,367 4,442,322 5,505,098 6,480,365 7,083,264 Total Other Expenses 7,077,307 6,436,621 7,525,616 8,527,552 9,157,581 Ending Fund Balance 16,202,554 17,998,431 14,696,810 10,273,474 9,039,972 Contingency 4,566,000 4,566,000 4,566,000 4,566,000 4,566,000 351 Electric Fund Five Year Projections The projections assume no retail electric rate increases through the fiveyear horizon. Rates, purchased power costs and system operations are reviewed as part of the annual budget planning process. Strategies for any identified potential shortfalls will be implemented over time to mitigate the potential deficit. Projected Projected Projected Projected Projected FY15 FY16 FY17 FY18 FY19 Beginning Fund Balance 11,686,069 11,799,614 13,036,039 14,507,749 14,105,951 Primary Revenues Electric Services 63,130,214 62,219,329 64,750,718 64,969,280 66,918,358 Other 1,085,000 1,106,300 1,128,239 1,150,836 1,174,111 Total Primary Revenues 64,215,214 63,325,629 65,878,957 66,120,116 68,092,470 Primary Expenses Contracts 37,286,896 35,098,840 36,383,575 37,589,387 38,717,069 Operations 13,799,472 13,824,825 14,209,719 14,606,161 15,014,496 Franchise Fees 1,658,452 1,712,535 1,768,239 1,825,615 1,880,383 CIP Expense 10,086,400 6,824,000 5,800,000 3,800,000 3,800,000 Total Primary Expenses 62,831,221 57,460,199 58,161,533 57,821,163 59,411,948 Other Revenue Interest 26,000 26,000 26,000 26,000 26,000 Other 1,030,000 1,030,000 1,030,000 1,030,000 1,030,000 Bond Revenue 6,473,000 3,269,000 2,245,000 245,000 245,000 Total Other Revenue 7,529,000 4,325,000 3,301,000 1,301,000 1,301,000 Other Expenses Transfer Out 4,725,674 4,364,799 4,501,896 4,643,106 4,777,899 CAFR Adjustment 0 0 0 0 0 Debt Service 4,073,775 4,589,206 5,044,818 5,358,646 5,252,827 Total Other Expenses 8,799,449 8,954,005 9,546,714 10,001,751 10,030,726 Ending Fund Balance 11,799,614 13,036,039 14,507,749 14,105,951 14,056,746 Contingency 3,525,000 3,525,000 3,525,000 3,525,000 3,525,000