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