HomeMy WebLinkAbout2nd Qtr Report_Entire ReportVision: A caring
community,
honoring our past,
and innovating for
the future.
CITY OF
GEORGETOWN
FISCAL YEAR 2019 BUDGET
SECOND QUARTER REPORT
FINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended March 31, 2019
Table of Contents
Executive Summary .................................................................................................................................... 1-6
General Fund Schedule ................................................................................................................................. 7
Electric Fund Schedule .................................................................................................................................. 8
Preliminary Electric Fund Schedule ............................................................................................................... 9
Water Services Fund Schedule .................................................................................................................... 10
Joint Services Fund Schedule ....................................................................................................................... 11
Council Discretionary Fund Schedule .......................................................................................................... 12
Convention & Visitors Bureau Fund Schedule ............................................................................................. 13
Airport Fund Schedule ................................................................................................................................. 14
Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 15
Georgetown Economic Development Corporation Fund Schedule ............................................................. 16
Quarterly Investment Report - City ........................................................................................................ 17-40
Quarterly Investment Report - GTEC ...................................................................................................... 41-46
Quarterly Investment Report - GEDCO ................................................................................................... 47-52
Grant Applications ....................................................................................................................................... 53
Capital Improvement Projects ................................................................................................................ 54-56
Long-term Commitments and Other Unfunded Liabilities ..................................................................... 57-59
F FY2019 Quarterly Report
EXECUTIVE SUMMARY FOR THE QUARTER ENDED MARCH 31, 2019
I.QUARTERLY FINANCIAL ANALYSIS
Each year the City amends the budget for multi‐year capital projects, as well as operational changes that were not
known at the time the budget was adopted. This 2nd quarter report reflects the “Roll Forward” budget amendment
that affected many major funds. The Rollforward amendment was adopted in January 2019. The Mid‐Year
Amendment will be adopted in June and will be reflected in the 3rd Quarter Report.
In the fall of 2018, the City implemented a new utility billing software. The new system has a different billing cycle for
large consolidated account customers (hospitals, schools, and City facilities). The different billing schedule skews the
comparisons for the second quarter of FY2018 to FY2019 in ROI and Franchise Fees in the General Fund. Currently,
staff is working with the implementation vendor to shorten the timeframe between when these large consolidated
accounts are billed and when the collection occurs. It is anticipated the City will receive all budgeted revenue in these
affected accounts by the end of the fiscal year.
GENERAL FUND REVENUES:
General Fund revenues total $37.1 million, or 52.4% of
budget. Year to date, revenues exceed last year’s second
quarter revenues by 7.5%.
The sales tax revenue through March totals $5.4 million,
or 33.7% of budget. At this stage of the fiscal year, all four
year‐end regression models have the City finishing the
year around 5% higher than budget.
The City continues to see growth in our core sectors of
retail, food, and information. Sales tax revenue has been
bolstered by one‐time‐in‐nature collections in the first
quarter. Additionally in previous fiscal years, the general
fund transferred sales tax dollars to the Wolf Ranch PID.
This transfer is no longer occurring and thus those dollars
are staying in the fund.
Property tax revenues are typically received during the first two quarters of the fiscal year, with the majority of the
taxes being received in December and January. Property tax revenue for the second quarter of FY2019 is up 12.8%,
or $1.6 million from the second quarter of FY2018. Through the second quarter of FY2019, collections total 99.5% of
budget. After the second quarter in FY2018, property tax collections totaled 91.2% of budget.
The City collects franchise fees for electric, natural gas, cable, and non‐cellular telephone services. Through the
second quarter, franchise fee revenues total $2.5 million in FY2019, a decrease of 9.8% from the second quarter of
FY2018. The decrease is due to the protracted billing cycle of the electric, water, and wastewater franchise fees.
Franchise fees for cable TV and telephone services are 1% higher in FY2019 than the second quarter of FY2018.
Franchise fee collections occur on a quarterly basis. The new billing cycle also skews the comparison of Return on
Investment. ROI is only 34.1% of the budgeted amount; though staff anticipates all budgeted revenue will be received
by year‐end.
$600,000
$700,000
$800,000
$900,000
$1,000,000
$1,100,000
$1,200,000
$1,300,000
$1,400,000
$1,500,000
OctNovDecJanFebMarAprMayJunJulAugSepSales Tax
2015 2016 2017 2018 2019
1
F FY2019 Quarterly Report
Sanitation revenue through the second quarter totals $4.5 million or 47.8% of budget. Compared to the second
quarter of FY2018, sanitation revenue is up 5.1%.
Development related revenue continues to be strong. In
the second quarter, development related revenue totals
$1.4 million or 43.6% of budget through the second
quarter. As shown in the graph to the right, permits tend
to increase in the spring and summer months. The City
continues to witness growth in building permits and when
compared to the second quarter of FY2018, development
related revenue is up 20.5%.
EMS revenue through the second quarter totals $1.6
million, or 58.6% of budget. Previously, EMS was
budgeted in a separate fund. As part of the FY2019
Budget, the department moved into the General Fund.
Parks and Recreation revenue totals $972,579 through
the second quarter. This represents a decrease of 5.6%
from the second quarter of FY2018. Year to date, Parks
and Rec revenues are at 39.5% of budget. However, Parks and Rec revenues historically skew more heavily to the
spring and summer months. Garey Park revenue totals $139,879, or 28.0% of budget. It is anticipated Garey Park
revenue will increase in the summer months.
Overall, the City’s two largest revenue streams, property tax and sales tax, are projecting at or above budget. Other
revenue streams like EMS and development related revenues continue to grow with population and new
development. The utility related fees and revenues through the second quarter are down due to the longer billing
cycles. However, staff is working to shorten the billing cycle for future periods.
GENERAL FUND EXPENDITURES:
Overall expenditures through the second quarter total $33.4 million, or 47.4% of budget. Total salaries and benefit
expenditures through the second quarter total $19.2 million. Operational costs total $13.7 million. The table below
excludes capital accounts (like street repair or transfers out for fleet purchases) and is used to compare the personnel
and operations costs year to year.
Generally, year over year increases are reflective of growth in new programs, and personnel costs for new salaries
and benefits as well as merit and market adjustments.
Personnel and Operations Summary (excludes capital accounts)
Administration Services Division (Administrative Services, City Council, City Secretary, and Social Service Funding)
expenditures for the second quarter total $1.3 million, which represents 49.6% of budget.
Year‐to‐date expenditures for the Community Services (Parks and Rec., Library, and Communications) and Finance
Division (Municipal Court) total $5.7 million or 46.2% of budget.
COMBINDED EXPENSES FY2019 Budget
FY2019 YTD
Actuals
% of FY2019
Budget FY2018 Budget
FY2018 YTD
Actuals
% of
FY2018
Budget
Personnel Expense 39,744,389 19,210,761 48.3% 36,675,585 18,091,825 49.3%
Operations Expense 28,613,268 13,652,218 47.7% 26,653,247 12,386,077 46.5%
TOTAL 68,357,657 32,862,979 48.1% 63,328,832 30,477,901 48.1%
‐
20
40
60
80
100
120
140
160
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
Building Permits
2015 2016 2017 2018 2019
2
F FY2019 Quarterly Report
The Georgetown Utility System Division (Environmental Services, Inspections, Public Works, and Streets)
expenditures through the second quarter total $5.4 million or 44.8% of budget.
Year‐to‐date expenditures for Police through the second quarter total $7.7 million or 47.8% of budget
Year‐to‐date expenditures for Fire through the second quarter total $9.0 million or 48.1% of budget
The City has experienced 13 of 26 pay periods through the second quarter, or 50.0% of total cycles.
Personnel and Operations Summary (excludes capital accounts)
FY2019 Budget FY2019 Actuals
% of FY2019
Budget FY2018 Budget FY2018 Actuals
% of
FY2018
Budget
Expenditure
Administrative Services
Personnel Expense 1,941,881 989,098 50.9% 1,900,756 919,198 48.4%
Operations Expense 663,827 302,500 45.6%712,883 283,355 39.7%
Administrative Services Total 2,605,708 1,291,598 49.6% 2,613,639 1,202,553 46.0%
Community Services and Finance
Personnel Expense 7,156,124 3,269,030 45.7% 6,730,047 2,979,897 44.3%
Operations Expense 5,228,877 2,454,921 46.9% 4,910,503 2,262,523 46.1%
Community Services and Finance Total 12,385,001 5,723,950 46.2% 11,640,550 5,242,420 45.0%
Development & Planning
Personnel Expense 2,308,625 1,041,235 45.1% 2,164,868 978,747 45.2%
Operations Expense 714,668 167,704 23.5%731,484 130,630 17.9%
Development & Planning Total 3,023,293 1,208,939 40.0% 2,896,352 1,109,377 38.3%
Fire Services*
Personnel Expense 15,104,380 7,072,283 46.8% 12,686,454 6,350,274 50.1%
Operations Expense 3,661,475 1,961,613 53.6% 3,430,316 1,732,760 50.5%
Fire Services Total 18,765,854 9,033,896 48.1% 16,116,770 8,083,034 50.2%
General Gov't Contracts
Personnel Expense (1,145,000) ‐ 0.0% (750,000) ‐ 0.0%
Operations Expense 4,436,401 2,445,447 55.1% 4,003,786 2,262,444 56.5%
General Gov't Contracts Total 3,291,401 2,445,447 74.3% 3,253,786 2,262,444 69.5%
GUS
Personnel Expense 1,875,598 879,587 46.9% 1,860,648 836,736 45.0%
Operations Expense 10,275,620 4,569,949 44.5% 9,414,929 3,861,350 41.0%
GUS Total 12,151,218 5,449,537 44.8% 11,275,577 4,698,086 41.7%
Police Services
Personnel Expense 12,502,781 5,959,529 47.7% 12,082,813 6,026,973 49.9%
Operations Expense 3,632,400 1,750,084 48.2% 3,449,346 1,853,014 53.7%
Police Services Total 16,135,181 7,709,613 47.8% 15,532,159 7,879,988 50.7%
Expense Total 68,357,657 32,862,979 48.1% 63,328,832 30,477,901 48.1%
*Fire Services Dicvision includes EMS Fund.
3
F FY2019 Quarterly Report
Overall, General Fund expenditures are within budget and the fund can cover the 90‐day Contingency Reserve and
the Benefit Payout Reserve.
UTILITY FUNDS:
Electric Fund: Electric sales revenue through the second quarter of FY2019 totals $32.0 million, or 43.8% of budget.
Electric revenue sales are typically higher in the summer months when consumption increases. Purchased Power
expenses total $21.4 million, or 44.4% of budget. This report includes the regular March (2nd Quarter) Electric Fund
Schedule, as well as a preliminary April schedule. A team of staff from City Manager’s Office, Finance, and the Utility
continue to monitor Purchased Power costs every two weeks and provide regular updates to Council and the public.
The preliminary April fund schedule has the most current year‐end projections for revenues and expenses. These
updates include the following:
The revenue impact of the Purchase Cost Adjustment (PCA) from February through September.
Recognize updated projections for purchased power and congestion revenue rights.
Recognize savings in operational expenses and vacant positions.
Recognize capital reimbursement revenue from the South Georgetown TIRZ.
On the May 28th Council meeting, staff is proposing a Mid‐Year Budget Amendment. This proposed amendment will
impact the electric fund. The amendment will be approved on June 11 and reflected in the 3rd quarter report.
Water Fund: Overall water revenue totals $26.9 million, or 45.1% of budget. Water, wastewater, and irrigation sales
revenue through the second quarter totals $17.1 million, or 40.5% of budget. Capital Recovery Fees total $6.2 million.
Water operating expenses total $19.6 million, which represents 52% of budget. Non‐operational expenses total $25.1
million. The total budget for non‐operating expenses in the Water fund following the CIP rollforward is $91.9 million.
These non‐operational expenses are capital improvement projects that normally span multiple years. A summary
report of all CIP projects is included in this report.
OTHER MAJOR FUNDS:
Convention & Visitors Bureau Fund: Hotel Occupancy Tax revenue totals $435,909 for the second quarter of FY2019,
or 32.3% of budget. HOT revenue is typically higher in the spring and summer months. Year to date expenses in the
Convention & Visitors Bureau Fund total $643,938, or 47.6% of budget. The fund is budgeted to finish FY2019 with a
fund balance of $1.3 million and can cover the 90‐day operational reserve.
Airport Fund: Airport revenue totals $1.7 million, which represents 43.7% of budget. The current vacancy of the
Airport Manager is creating salary savings in the fund. Expenses in the Airport fund total $2.7 million, or 72.7% of
budget. Over $1.2 million of the year to date expenses is fuel related encumbrances. Overall, both revenues and
expenses are tracking well relative to budget and the fund is budgeted to end FY2019 with $965,059 in fund balance
and meet all of its debt service and contingency requirements.
II. INVESTMENTS
The investment activity and strategies described in this report comply with the Public Funds Investment Act (PFIA),
the City’s investment policy, and generally accepted accounting principles. Activity for the second quarter of fiscal
year 2019 includes the maturing of financial institution deposits (CDs), reinvestment of CD’s, & investing of bond
proceeds in CD’s and Treasury Bills. Interest rates for money market accounts, Treasury bills, and CD’s increased
slightly during this quarter. However, we have begun to see a decline in rates being submitted, due to changes in
the market. The City will continue soliciting for the best rates to improve both diversity and yield, while keeping in
mind safety and liquidity.
4
F FY2019 Quarterly Report
The Investment Reports for the quarter ending March 31, 2019, and the supporting schedules are attached. Valley
View Consulting, L.L.C., has prepared the attached investment reports. A component of our investment advisory
services contract includes Valley View preparing the quarterly investment reports on behalf of the City. A summary
of the investment balances at March 31, 2019, compared to the prior quarter, is shown below for the City, as well as
Georgetown Transportation Enhancement Corporation (GTEC) and Georgetown Economic Development Corporation
(GEDCO).
CITY Book Value GTEC GEDCO
12/31/18 3/31/19 12/31/18 3/31/19 12/31/18 3/31/19
Total cash and investments
$177,790,533 $188,114,708 $18,526,812 $19,423,174 $7,236,643 $7,551,001
Average Yield 2.25% 2.41% 2.19% 2.53% 2.33% 2.45%
The City’s strategy continues to be matching maturities with cash flow needs, while focusing on the investment
policy’s long‐range goals. The City’s investment strategy is to “ladder” or stagger maturities, thus minimizing erratic
interest rate fluctuations. The City is continuing to manage the yield on bond proceeds for arbitrage purposes.
City portfolio balances have increased in the last few years due to the increase in contingency reserves, interest rate
increases, and debt proceeds issued for future capital improvement projects. The City’s investment portfolio includes
bank deposits, local government investment pool balances, money market accounts, financial institution deposits
(CD’s), and Treasury Bills. All of these investments carry insurance or an implied backing from the Federal
Government. The collateral on all City investments are monitored monthly to ensure the financial institutions carry
minimum collateral of 102% of market value of the City’s investments.
The City began to further diversify investments in August 2018. A Treasury bill was purchased with bond proceeds.
The City has a safekeeping relationship with BBVA Compass to manage security purchases. The investment officers,
with the direction of Valley View, will work with approved brokers for purchases. All securities held by financial
institutions as collateral on behalf of the City have been reviewed and met PFIA‐minimum rating criteria.
The City has worked closely with the City’s depository bank (JPMorgan Chase) to find an average daily balance that
is best to receive the highest yield on the account. These balances earn credit against the fees charged by the bank.
As of March, the City is receiving the alternative premium rate of 1.25% for our Earnings Credit Rate (ECR). The City
will continue to verify depository yield versus investment yield to achieve the best outcome.
The City's investment program is conducted to accomplish the objectives of safety, liquidity, public trust, and yield.
Each aspect is considered when making decisions regarding investments.
III. CAPITAL PROJECTS
The projects in the Capital Improvement Program (CIP) consist of infrastructure and related construction and do not
include small capital items such as furniture, equipment, and vehicle maintenance. Maintenance‐type projects are
not capitalized as a fixed asset and are usually cash funded. Therefore, these projects are operational in nature and
are in the departmental operating budget. A year‐to‐date budget status for each of the approved projects is included
in the quarterly report.
5
F FY2019 Quarterly Report
PARKS
San Gabriel Park Improvements: Phase one of San Gabriel Park is complete. A contract with Prime Construction was
approved by City Council on May 22, 2018 for the construction of phase two. Construction is expected to be
completed by June 2019. Phase two includes entry monuments, roadway and parking improvements, four medium
size picnic and barbecue pavilions, a large multi‐use pavilion, ten small picnic pavilions, trails and trail heads, two
children’s play areas, restoration of two existing springs, one new small restroom building, lighting for two existing
volleyball courts, one lighted basketball court, directional and interpretive signage, open spaces and landscaping. In
addition, the trail extension from San Gabriel Park to the park at Katy Crossing will also be constructed.
COMMUNITY SERVICES
Construction on several sidewalk improvement projects throughout the city began in May 2017. This was the first
round of sidewalk improvement projects identified in the adopted Sidewalk Master Plan and was funded in part by a
road bond approved by voters in May 2015. Work on the initial designed portion is complete and the next downtown
sidewalk project is currently being designed.
Old Town North East Sidewalks: The Water Pollution Abatement Plan (WPAP) approval has been received from TCEQ.
Design is completed. All easements have been secured. Advertising started on May 5th and bid proposals are
expected in late May. Staff plans to take the item to GTAB on June 14th and later to Council for approval.
Austin Ave Sidewalks (Hwy. 29 to Leander Rd): Patin Construction has installed Erosion Controls and Tree protection.
Construction will commence in late April 2019. Estimated completion is late August.
TRANSPORTATION
10th & 11th @ Austin Ave Improvements: The contractor has completed a majority of the work on 11th between Rock
and Main including the concrete roadway section of Austin Ave. The contractor is currently working to install curb,
gutter, pedestrian ramps and sidewalk on the west side of Austin Ave at 11th. The contractor will move to 10th &
Austin Ave once they complete 11th street.
ELECTRIC
New development continues to exceed expectations in the second quarter with additional residential, multifamily,
and business projects in progress. Below is a list of projects currently under construction:
Sun City neighborhood 70, Academy Sports, Round Rock multi‐family, Fire station 7, Watkins building, QuikTrip gas
station, Goddard School, Rivery Boulevard extension, Airport Road expansion, AT&T small cells, Duluth Trading
Center, Wolf Crossing, Wolf Ranch Section 3 and 4A, and Stillwater 1 and 2.
WATER
The Berry Creek Interceptor phase 4, 5, and 6 will be approximately 15,000 linear feet of 36‐inch wastewater from
the existing lift station at Sun City to the Berry Creek lift station. Construction started January 28, 2019 and is
scheduled for completion in January 2020.
The Pecan Branch Wastewater Treatment Plant expansion will take the existing plant from 1.5 million gallons to 3
million gallons of treatment capacity. The Pecan Branch wastewater treatment plant construction started in July 2017
and is scheduled for completion in August 2019.
The Shell Road and CR 255 water main designs are complete and easement acquisitions are in progress. This project
will be approximately 44,500 LF of 30‐inch waterline from Daniels Mountain Water storage tank to Braun Water
storage tank. Construction of Shell Road Waterline Improvements is estimated to start in February 2021. CR 255 has
been on hold and moved to Reagan 30‐inch waterline and is scheduled for completion in June 2019.
6
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 10,607,485 10,607,485
Revenue
Administrative Charges 2,428,000 202,333 1,214,000 2,428,000
All Other Revenue 6,575,870 1,069,880 2,747,929 6,575,870
Development and Permit Fees 3,307,000 300,656 1,442,621 3,307,000
Franchise Fees 5,434,000 175,097 2,454,981 5,434,000
Garey Park 500,000 50,928 139,879 500,000
Parks and Rec Fees 2,460,100 218,336 972,579 2,460,100
Property Tax 13,850,000 184,815 13,781,618 13,850,000
ROI 7,777,490 487,738 2,650,943 7,777,490
Sales Tax 15,924,475 1,114,419 5,363,400 15,924,475
Sanitation Revenue 9,448,500 1,491,063 4,516,334 9,448,500
EMS Revenue 2,780,896 231,501 1,628,999 2,780,896
Transfer In 301,782 68,750 164,283 301,782
Revenue Total 70,788,113 5,595,517 37,077,566 70,788,113
Expense
Administrative Services 1,552,033 118,665 801,857 1,552,033
Animal Services 926,122 60,428 432,421 926,122
Arts & Culture 37,545 2,608 15,044 37,545
City Council 171,395 12,576 86,197 171,395
City Secretary 882,280 70,831 403,545 882,280
Code Enforcement 432,800 29,728 194,220 432,800
Communications 425,160 38,372 207,224 425,160
Environmental Services 7,902,414 649,487 3,021,281 7,902,414
Fire Emergency Services 13,181,569 975,904 6,271,859 13,181,569
Fire Support Services 2,990,589 229,017 1,378,182 2,990,589
Fire EMS 2,593,697 150,863 1,384,404 2,593,697
Garey Park 948,290 65,727 406,976 948,290
General Gov't Contracts 3,291,401 302,912 2,445,447 3,291,401
Inspections 1,277,145 96,928 609,917 1,277,145
Municipal Court 635,935 49,186 327,312 635,935
Library 2,696,579 208,818 1,350,909 2,696,579
Parks 2,774,674 192,142 1,337,844 2,774,674
Parks Admin 610,051 46,123 302,615 610,051
Planning 1,746,148 97,118 599,022 1,746,148
Police Admin 2,330,161 193,865 1,196,661 2,330,161
Police Operations 12,450,598 602,847 5,886,310 12,450,598
Public Works 1,296,263 38,158 837,520 1,296,263
Rec Programs 1,358,009 59,807 413,345 1,358,009
Recreation 2,625,888 205,133 1,284,318 2,625,888
Streets 4,688,211 244,346 1,752,274 4,688,211
Tennis Center 458,162 27,983 181,468 458,162
Transfer Out 361,000 - 361,000 361,000
Expense Total 70,644,120 4,769,572 33,489,173 70,644,120
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 143,994 825,945 3,588,393 143,994
Economic Stability Reserve - -
Contingency 9,977,771 9,977,771
Benefit Payout 255,000 255,000
AVAILABLE FUND BALANCE 518,708 518,708
Year-End Projection to Approved: Mar FY2019
General Fund
7
FY19 Amended Budget CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR‐END
PROJECTION
BEGINNING FUND BALANCE 1,970,691$ 1,970,691$
Operating Revenue
Electric Revenue 73,100,000 10,806,674 31,997,417 79,100,000
Interest 38,000 7,455 48,769 38,000
Other Revenue 5,243,546 658,080 2,041,891 5,243,546
Operating Revenue Total 78,381,546 11,472,209 34,088,077 84,381,546
Operating Expenditures
CRR Credits (3,500,000) (88,669) (1,293,647) (3,500,000)
Georgetown Utility Systems 19,053,784 1,643,205 9,762,216 18,882,979
Purchased Power 48,000,000 3,622,558 21,411,647 53,000,000
Transfer Out‐ROI 4,325,000 351,656 1,949,911 4,325,000
Operating Expenditures Total 67,878,784 5,528,750 31,830,127 72,707,979
Total Net Operations 10,502,762 5,943,459 2,257,950 11,673,567
Non‐Operating Revenue
Grant Revenue 100,000 ‐ ‐ 100,000
Transfers in 95,787 ‐ 95,787 95,787
Non‐Operating Revenue Total 195,787 ‐ 95,787 195,787
Non‐Operating Expenditures
CIP 4,017,007 211,593 2,314,857 3,983,007
CIS implentation ‐ ‐ 20,000 34,000
Interest Expense 1,386,781 ‐ 721,821 1,386,781
Debt Service 3,035,374 ‐ 350 3,035,374
Non‐Operating Expenditures Total 8,439,162 211,593 3,057,028 8,439,162
Total Net Non‐Operations (8,243,375) (211,593) (2,961,241) (8,243,375)
EXCESS (DEFICIENCY) OF TOTAL REVENUE
OVER TOTAL REQUIREMENTS 2,259,387 5,731,866 (703,291) 3,430,192
ENDING FUND BALANCE 4,230,078$ 5,400,883$
90 Day Operational Contingency 4,082,999 4,082,999
Non‐Operational Contingency 147,079 147,079
AVAILABLE FUND BALANCE ‐ 1,170,805
Year‐End Projection to Approved: Mar FY2019
Electric Fund
8
FY2019 Budget CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR‐END
PROJECTION
BEGINNING FUND BALANCE 1,970,691 2,103,922
Operating Revenue
Electric Revenue 73,100,000 2,368,208 31,311,530 79,100,000
Interest 38,000 6,601 55,370 38,000
Other Revenue 5,243,546 370,746 2,412,638 5,243,546
Transfer In 95,787 ‐ 95,787 95,787
Operating Revenue Total 78,477,333 2,745,555 33,875,325 84,477,333
Operating Expenditures
CRR Credits (3,500,000) (8,763) (1,302,410) (3,000,000)
Georgetown Utility Systems 19,053,783 750,974 10,439,259 19,337,779
Purchased Power 48,000,000 3,606,172 25,000,066 53,185,477
Transfer Out‐Interfund Transfers ‐ ‐ ‐ ‐
Transfer Out‐ROI 4,325,000 ‐ 2,361,911 4,325,000
Operating Expenditures Total 67,878,783 4,348,384 36,498,826 73,848,256
Total Net Operations 10,598,550 (1,602,828) (2,623,502) 10,629,077
Non‐Operating Revenue
Bond Proceeds ‐ ‐ ‐ ‐
Grant Revenue 100,000 ‐ ‐ 100,000
Transfer In‐Other ‐ ‐ ‐ 548,104
Non‐Operating Revenue Total 100,000 ‐ ‐ 648,104
Non‐Operating Expenditures
CIP 4,017,007 280,496 2,400,374 4,017,007
Interest Expense 1,386,781 ‐ 721,821 1,386,781
Debt Issuance Cost ‐ ‐ ‐ ‐
Debt Service 3,035,374 ‐ 350 3,035,374
Non‐Operating Expenditures Total 8,439,162 280,496 3,122,545 8,439,162
Total Net Non‐Operations (8,339,162) (280,496) (3,122,545) (7,791,058)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 2,259,388 (1,883,324) (5,746,047) 2,838,019
ENDING FUND BALANCE 4,230,079 4,941,941
Contingency 4,082,999 4,082,999
Non‐Operational Contingency 147,079 147,079
AVAILABLE FUND BALANCE 0 711,862
Year‐End Projection to Approved: Apr FY2019
Electric Fund
PRELIMINARY
The preliminary April fund schedule has the most current year-end projections for revenues and expenses. These updates include the following:
• The revenue impact of the Purchase Cost Adjustment (PCA) from February through September.
• Recognize updated projections for purchased power and congestion revenue rights.
• Recognize savings in operational expenses and vacant positions.
• Recognize capital reimbursement revenue from the South Georgetown TIRZ.
9
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB) YEAR‐END PROJECTION
BEGINNING FUND BALANCE 89,159,703 89,159,703
Operating Revenue
Capital Recovery Fee 14,250,000 3,218,078 6,221,859 14,250,000
Interest 569,400 187,534 982,768 569,400
Irrigation Utility Revenue 301,557 22,868 72,939 301,557
Other Revenue 2,262,146 459,178 2,503,329 2,262,146
Raw Water Revenue 140,000 11,301 64,227 140,000
Transfer In, Debt 103,725 ‐ ‐ 103,725
Wastewater Utility Revenue 12,975,345 2,126,892 6,918,610 12,975,345
Water Utility Revenue 29,116,931 3,475,012 10,180,563 29,116,931
Operating Revenue Total 59,719,104 9,500,864 26,944,295 59,719,104
Operating Expenditures
Irrigation 270,324 126 62,217 270,324
Transfer Out, Fleet/Joint Service/IT 245,000 ‐ 245,000 245,000
Transfer Out, General 275,000 68,750 137,500 275,000
Transfer Out, ROI 3,200,000 124,495 637,007 3,200,000
Transfer Out, Utilities 95,787 ‐ 95,787 95,787
Wastewater Distribution 904,415 43,200 389,176 904,415
Wastewater Plant Management 2,705,069 222,830 1,716,487 2,705,069
Water Administration 19,923,733 4,894,261 11,912,575 19,923,733
Water Distribution 2,707,265 173,082 1,083,519 2,707,265
Water Operations 4,157,528 312,808 1,990,808 4,157,528
Water Plant Management 2,948,733 126,930 1,360,465 2,948,733
Operating Expenditures Total 37,432,854 5,966,482 19,630,540 37,432,854
Total Net Operations 22,286,250 3,534,382 7,313,755 22,286,250
Non‐Operating Revenue
Bond Proceeds ‐ ‐ ‐ ‐
Non‐Operating Revenue Total ‐ ‐ ‐ ‐
Non‐Operating Expenditures
CIP 90 85,667,940 2,331,557 23,885,592 85,667,940
CIP 91 ‐ ‐ 63,857 ‐
Debt Service 6,250,111 ‐ 1,148,839 6,250,111
Non‐Operating Expenditures Total 91,918,051 2,331,557 25,098,288 91,918,051
Total Net Non‐Operations (91,918,051) (2,331,557) (25,098,288) (91,918,051)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (69,631,801) 1,202,825 (17,784,533) (69,631,801)
ENDING FUND BALANCE 19,527,902 19,527,902
Contingency 7,498,183 7,498,183
Non‐Operating Contingency 9,500,000 9,500,000
AVAILABLE FUND BALANCE 2,529,719 2,529,719
Year‐End Projection to Approved: Mar FY2019
Water Fund
10
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR‐END
PROJECTION
BEGINNING FUND BALANCE 842,416 842,416
Revenue
Gedco Admin/Contract Fee 238,622 19,885 119,311 238,622
Gtec Admin/Contract Fee 172,318 14,360 86,159 172,318
Interest 17,503 1,578 12,625 21,500
Other 136,153 12,889 89,412 136,153
Service Fees ‐ Airport 128,966 10,747 64,483 128,966
Service Fees ‐ Electric 4,615,524 384,627 2,307,762 4,615,524
Service Fees ‐ General 3,573,156 297,763 1,786,578 3,573,156
Service Fees ‐ Stormwater 1,020,427 85,036 510,213 1,020,427
Service Fees ‐ Water 7,966,284 663,857 3,983,142 7,966,284
VPID Admin/Contract Fee 15,924 1,327 7,962 15,924
Revenue Total 17,884,877 1,492,068 8,967,647 17,888,874
Expense
Accounting 1,067,433 70,086 525,659 1,067,433
BIP 250,085 14,885 62,978 250,085
City Wide Hr 415,500 8,969 170,659 415,500
Conservation 766,699 38,923 275,763 766,699
Customer Care 4,701,266 525,659 2,692,374 4,701,266
Economic Development 635,768 41,715 281,765 635,768
Engineering 2,430,052 157,172 1,123,356 2,430,052
Engineering Support 1,147,160 70,776 573,527 1,147,160
Finance Administration 975,583 60,097 608,353 975,583
Gus Administration 1,476,541 123,495 682,983 1,476,541
Human Resources 1,003,190 76,880 480,612 1,003,190
In‐House Legal 1,038,782 74,821 453,773 1,038,782
Insurance & Legal 752,000 ‐ 600,110 752,000
Joint Svcs Con 598,775 66,844 367,241 598,775
Purchasing 811,459 53,205 335,143 811,459
Transfer Out 57,000 ‐ 57,000 57,000
Expense Total 18,127,293 1,383,526 9,291,296 18,127,294
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER
TOTAL REQUIREMENTS (242,416) 108,542 (323,649) (238,419)
Contingency 600,000 600,000
AVAILABLE FUND BALANCE 0 3,997
Joint Services Fund
Year‐End Projection to Approved: Mar FY2019
11
APRROVED
BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 131,914 131,914
Revenue
Interest 10,000 260 1,147 10,000
Transfer In, General Fund - - - -
Revenue Total 10,000 260 1,147 10,000
Expense
Transfer Out, GCP - - - -
Transfer Out, General Fund 5,000 - 5,000 5,000
Transfer Out, Joint Services - - - -
Expense Total 5,000 - 5,000 5,000
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 5,000 260 (3,853) 5,000
ENDING FUND BALANCE 136,914 136,914
Year-End Projection to Approved: Mar FY2019
Council Discretionary Fund
12
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 1,170,801 1,170,801
Revenue
Hotel/Motel Occupancy Tax Revenues 1,350,000 70,777 435,909 1,350,000
Interest 5,000 2,336 10,292 20,000
Other 23,500 1,685 8,165 23,500
Poppy Festival 136,150 48,715 76,495 136,150
Revenue Total 1,514,650 123,512 530,861 1,529,650
Expense
Operations 713,831 35,924 376,628 713,831
Personnel 369,492 27,970 180,609 369,492
Poppy Festival 165,200 15,610 23,779 165,200
Transfer to Facilities 49,507 4,126 24,753 49,507
Transfer to Fleet 5,048 421 2,524 5,048
Transfer to General Fund 21,783 - 21,783 21,783
Transfer to Information Technology 27,722 2,310 13,861 27,722
Expense Total 1,352,583 86,360 643,938 1,352,583
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 162,067 37,152 (113,076) 177,067
ENDING FUND BALANCE 1,332,868 1,347,868
Contingency 271,189 271,189
Reserved for Capital 1,061,680 1,061,680
AVAILABLE FUND BALANCE (2) 14,998
Year-End Projection to Approved: Mar FY2019
Convention & Visitors Bureau Fund
13
APPROVED
BUDGET CURRENT PERIOD
YEAR YO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 1,062,941 1,062,941
-
Operating Revenue
Fuel and Terminal Sales 2,907,450 175,854 1,231,092 2,907,450
Interest and Other 80,260 2,937 22,500 80,260
Leases and Rentals 863,952 72,766 430,985 863,952
Operating Revenue Total 3,851,662 251,557 1,684,577 3,851,662
Operating Expenditures
Debt Service 147,975 - 21,996 147,975
Operations-Fuel 2,400,000 122,268 2,235,620 2,400,000
Operations-Non Fuel 732,721 14,655 287,376 732,721
Personnel 417,348 24,754 144,146 417,348
Operating Expenditures Total 3,698,044 161,677 2,689,138 3,698,044
TOTAL NET OPERATIONS 153,618 89,880 (1,004,561) 153,618
Non-Operating Revenue
Bond Proceeds 500,000 - - 500,000
Grants 40,000 - - 40,000
Non-Operating Revenue Total 540,000 - - 540,000
Non-Operating Expenditures
Hangar Upgrades 75,000 4,400 19,442 75,000
Pavement Upgrades 15,000 - (19,054) 15,000
Runway Rehab 516,500 - - 516,500
Taxiway Edge Lighting 150,000 - - 150,000
Wildlife Management 35,000 7,200 14,751 35,000
Non-Operating Expenditure Total 791,500 11,600 15,140 791,500
TOTAL NET NON-OPERATIONS (251,500) (11,600) (15,140) (251,500)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (97,882) 78,280 (1,019,701) (97,882)
ENDING FUND BALANCE 965,059 965,059
RESERVES
Contingency 264,442 264,442
Reserves Total 264,442 264,442
AVAILABLE FUND BALANCE 700,617 700,617
Airport Operations Fund
For the Month Ended: Mar FY2019
14
APPROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB) YEAR‐END PROJECTION
BEGINNING FUND BALANCE 18,078,282 18,078,282
Operating Revenue
Sales Tax 7,073,100 495,298 2,383,731 7,073,100
Interest 190,000 25,246 210,365 210,365
Operating Revenue Total 7,263,100 520,543 2,594,096 7,283,465
Operating Expenditure
Administrative Support 391,697 32,575 195,570 391,697
Operating Expenditure Total 391,697 32,575 195,570 391,697
TOTAL NET OPERATIONS 6,871,403 487,969 2,398,526 6,891,768
Non‐Operating Revenue
Debt Proceeds 7,200,000 ‐‐ 7,200,000
Non‐Operating Revenue Total 7,200,000 ‐‐ 7,200,000
Non‐Operating Expenditure
Pecan Center Dr to Airport Rd (FY15)2,445,036 2,000 (334) 2,445,036
Arterial SE1:Inner Loop/SH130 7,200,000 ‐‐ 7,200,000
Rivery TIA Improvements 359,496 5,885 (11,986) 359,496
FM 971 / Fontana 63,102 10,966 ‐ 63,102
Rivery‐Extension Williams Dr to NW Blvd (FY16)730,635 6,800 460,784 730,635
IH 35 / HWY29 Intersection 606,653 ‐160,375 606,653
SW Bypass 2243 to IH35 128,144 ‐‐ 128,144
FM1460 Widening 500,783 ‐60 500,783
Wolf Ranch Pkwy Extension 283,350 ‐‐ 283,350
Mays St 4,500,000 ‐4 4,500,000
Available for Projects TBD 1,768,275 ‐‐ 1,768,275
SE Inner Loop Widening (Rock Ride ROW)900,000 ‐948,251 948,251
Debt Service 3,438,747 ‐521,942 3,438,747
Non‐Operating Expenditure Total 22,924,221 25,651 2,079,097 22,972,472
TOTAL NET NON‐OPERATIONS (15,724,221)(25,651)(2,079,097) (15,772,472)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (8,852,818) 462,318 319,429 (8,880,704)
ENDING FUND BALANCE 9,225,464 9,197,578
RESERVES
Contingency 1,768,275 1,768,275
Reserves Total 1,768,275 1,768,275
AVAILABLE FUND BALANCE 7,457,189 7,429,303
Georgetown Transportation Enhancement Corporation Fund
Year‐End Projection to Approved: Mar FY2019
15
APPROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 6,853,073 6,853,073
OPERATING REVENUES
Interest 40,300 15,608 85,241 40,300
Sales Tax 1,768,275 123,824 595,933 1,768,275
OPERATING REVENUES Total 1,808,575 139,432 681,174 1,808,575
OPERATING EXPENDITURES
Joint Services Allocation 238,622 19,885 119,311 238,622
Miscellaneous Expense 50 - - 50
Promotional & Marketing Program 100,000 - 63,429 100,000
Special Services 30,000 - - 30,000
Travel & Training 500 - - 500
OPERATING EXPENDITURES Total 369,172 19,885 182,740 369,172
TOTAL NET OPERATIONS 1,439,403 119,547 498,434 1,439,403
NON-OPERATING EXPENDITURES
Principal Reduction 80,568 - - 80,568
Debt Service 205,069 - 42,534 205,069
Interest Expense 23,157 - - 23,157
Atmos Energy 146,096 - - 146,096
DisperSol 50,000 30,000 30,000 50,000
Economic Development Projects -Undetermined 7,000,517 - - 7,000,517
Holt Cat 185,000 - - 185,000
Radiation Detection Company 150,000 - - 150,000
NON-OPERATING EXPENDITURES Total 7,840,407 30,000 72,534 7,840,407
TOTAL NET NON-OPERATIONS (7,840,407) (30,000) (72,534) (7,840,407)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (6,401,004) 89,547 425,900 (6,401,004)
ENDING FUND BALANCE 452,069 452,069
RESERVES
Contingency 442,069 442,069
RESERVES Total 442,069 442,069
AVAILABLE FUND BALANCE 10,000 10,000
Georgetown Economic Development Corporation Fund
Year-End Projection to Approved: Mar FY2019
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized
Airport N/A Texas Department of
Transportation-Aviation
M1914GEOR RAMP Grant - Routine Airport
Maintenance Program
- -
Airport Federal Aviation Administration Texas Department of Transportation-Aviation 16MPGRGTN Airport Master Plan Update - -
Airport Federal Aviation Administration Texas Department of Transportation-Aviation 1814GRGTN Runway 18/36 Rehabilitation-Engineering - -
Airport Federal Aviation
Administration
Texas Department of
Transportation-Aviation
1814GEORG Runway 18/36 Rehabilitation-
Construction
- -
Airport Federal Aviation
Administration
Texas Department of
Transportation-Aviation
17WAGEORG Wildlife Hazard Assessment - -
Fire US Department of Homeland Security Federal Emergency Management Agency EMW-2017-FH-00496 SAFER 72,505.33 54,378.99
Fire Federal Emergency
Management Agency
Texas Department of Public
Safety - TDEM
TEEX Tracy Ryan Deployment
Urban Search and Rescue (US&R)
13,411.76 13,411.76
Gus - Electric N/A Bloomberg Philanthropies 2017 Mayors Challenge 2,100.00 -
Library Institute of Museum & Library Services Texas State Library & Archives Commission LS-00-18-0044-18 TSL Resource Coordinator - 3rd year (Patrick Lloyd) 35,760.19 35,760.19
Planning US Department of Housing &
Urban Development
Williamson County B-17-UC-48-0502 CDBG Sidewalks and Ramps
along 17th St
1,250.00 1,250.00
Police Bureau of Justice Assistance N/A KXPIIIA Bullet Proof Vests - Supply Police with new vests 3,560.85 1,780.44
Public Works Dept. of Transportation /Federal Highway Administration
Texas Department of Transportation CSJ-0914-05-187 Highway Planning & Construction (Austin Ave Bridge)
72,793.51 -
Division Grantor Status
Gus - Electric Department of Energy (DOE)Battery Storage Project Under DOE Review
Planning Williamson County/CDBG Home Repair Applied - Council 5/14; due 5/22 to County Planning Williamson County/CDBG Scenic Dr Sidewalk Applied - Council 5/14; due
5/22 to County Parks Texas Parks and Wildlife Department (TPWD)Recreation San Gabriel Trails TxDOT Review
Reviewed By:
CITY OF GEORGETOWN
Grant/Federal Funding Reportas of March 31 2019
COG Name/Purpose
Active
Applications Pending Award
5/17/2019
53
CIP Quarterly Report - Q2 FY2019 Budget
Year-todate
(W/Encum)Remaining Balance
AIRPORT OPERATIONS
600-5-0636-52-140 DESIGN RUNWAY REHAB 516,500 - 516,500
600-5-0636-52-141 HANGAR UPGRADES 75,000 19,442 55,558
600-5-0636-52-142 PAVEMENT UPGRADES 15,000 (19,054) 34,054
600-9-0636-52-144 TAXIWAY EDGE LIGHTING 150,000 - 150,000
CDBG GRANTS
215-9-0880-90-003 17TH STREET 206,824 30,040 176,784
215-9-0880-90-004 MAPLE STREET 80,784 - 80,784
DOWNTOWN TIRZ
293-9-0602-90-002 PARKING IMPROVEMENTS 106,902 - 106,902
293-9-0602-90-003 DTWN LANDSPING & PUBLC ART 45,000 43,202 1,798
293-9-0602-90-007 GRACE HERITAGE PLAZA 139,100 - 139,100
ECO DEVO SALES TAX
420-9-0980-90-001 ECONOMIC DEVEL PROJECTS 7,000,517 - 7,000,517
420-9-0980-90-022 RADIATION DETECTION COMPANY 150,000 - 150,000
420-9-0980-90-026 DISPERSOL TECHNOLOGIES, LLC 50,000 30,000 20,000
420-9-0980-90-030 HOLT CAT 185,000 - 185,000
420-9-0980-90-031 ATMOS ENERGY 146,096 - 146,096
ELECTRIC SERVICES
610-9-0580-90-134 HWY 195 - 903 (903)
610-9-0580-90-137 RONALD REAGAN - 303 (303)
610-9-0580-90-142 DOWNTOWN WEST 227,536 138,226 89,310
610-9-0580-90-143 SHELL ROAD FEEDERS - 10,349 (10,349)
610-9-0580-90-256 GEO. EAST T2 VOLTAGE CHANGE 23,757 5,350 18,407
610-9-0580-90-260 DB WOOD_SH29 INTERSECTION 145,445 40,000 105,445
610-9-0580-90-263 LEANDER RD_IH35 INTERSECTION 10,000 - 10,000
610-9-0580-90-264 NORTHWEST BLVD WIDENING - 20,000 (20,000)
610-9-0580-90-266 RIVERY EXTENSION 49,269 48,732 537
610-9-0580-90-267 UNIVERSITY_MAYS WIDENING 154,000 - 154,000
610-9-0580-90-310 POWER QUALITY IMPROVEMENTS 40,000 - 40,000
610-9-0580-90-320 SECTIONALIZATION IMPROVEMENTS 50,000 - 50,000
610-9-0580-90-410 NEW DEVELOPMENT PROJECTS 3,023,000 1,874,769 1,148,231
610-9-0580-90-430 STREET LIGHTING 44,000 226 43,774
610-9-0580-90-500 CONSULTANT ENGINEERING 150,000 150,000 -
610-9-0580-90-701 FIBER OPTIC 50,000 26,000 24,000
610-9-0580-90-702 FIBER TO SIGNAL LIGHTS 50,000 - 50,000
610-9-0580-91-105 CIS SYSTEM - 20,000 (20,000)
GATEWAY TIRZ
295-9-0602-90-001 CAPITAL IMPROVEMENTS 120,000 - 120,000
GENERAL CAPITAL PROJECTS
120-9-0280-90-031 NEIGHBORHOOD PARK DEVELOPMENT 250,000 - 250,000
120-9-0280-90-035 VFW PARK 175,000 152,328 22,672
120-9-0280-90-045 SAN GABRIEL PARK IMPROVEMENT 834,288 440,847 393,441
120-9-0280-90-046 GAREY PARK 370,000 21,685 348,315
120-9-0280-90-047 SIDEWALKS 142,858 - 142,858
120-9-0280-90-051 LIBRARY CANOPY 155,000 75,934 79,066
120-9-0280-90-060 ADA PARKS 450,405 - 450,405
120-9-0280-90-066 KATY CROSSING TRAIL 240,313 - 240,313
120-9-0380-90-048 FIRE STATION ASSESSMENTS 30,000 - 30,000
120-9-0380-90-080 DOWNTOWN PARKING GARAGE 5,000,000 62,950 4,937,050
54
CIP Quarterly Report - Q2 FY2019 Budget
Year-todate
(W/Encum)Remaining Balance
120-9-0380-90-159 FIRE STATION 7 6,471,601 5,293,780 1,177,821
120-9-0380-90-160 EOC SIREN SYSTEM 6,631 - 6,631
120-9-0380-90-163 FIRE STATION 6 5,499,725 4,776,377 723,349
120-9-0380-90-166 DATA CENTER - PSOTC 100,676 - 100,676
120-9-0380-90-168 TRANSFER STATION/LANDFILL 811,337 - 811,337
120-9-0380-90-169 ERP PROJECT 5,166,384 5,073,262 93,122
120-9-0380-90-170 FACILITY EFFICIENCY STUDY 78,734 91,234 (12,500)
120-9-0381-90-022 RADIO REPLACEMENT PUB SAFETY 500,000 - 500,000
120-9-0381-91-016 FIRE SCBA 290,000 - 290,000
120-9-0381-91-022 RADIO REPLACEMENT 500,000 - 500,000
120-9-0680-90-008 CVB REDESIGN 175,000 - 175,000
120-9-0680-90-012 DOWNTOWN WEST 481,831 484,360 (2,529)
120-9-0680-90-013 DOWNTOWN WEST SIGNAGE 125,000 - 125,000
120-9-0680-90-014 DOWNTOWN PARKING EXPANSION 600,000 11,595 588,405
120-9-0880-90-038 LEANDER RD(NORWOOD-SWBYPASS)2,000,000 - 2,000,000
120-9-0880-90-041 BLUE HOLE PARKING LOT/SIDEWALK 100,000 - 100,000
120-9-0880-90-050 NB FRONTAGE RD 150,000 3 149,997
120-9-0880-90-054 AUSTIN AVENUE BRIDGE 88,132 5,139 82,993
120-9-0880-90-065 SOUTHWESTERN BLVD 1,550,000 - 1,550,000
120-9-0880-90-066 SHELL ROAD SIDEWALK 180,000 - 180,000
120-9-0880-90-086 SW BYPASS LEANDER TO I35 - (1,000) 1,000
120-9-0880-90-087 FM 971 3,900,000 18,050 3,881,950
120-9-0880-90-088 FM 1460 550,000 - 550,000
120-9-0880-90-091 SW BYPASS/WOLF RANCH PKWY 1,717,771 - 1,717,771
120-9-0880-90-092 SOUTHEAST INNER LOOP 1,200,000 472 1,199,528
120-9-0880-90-105 NORTHWEST BLVD BRIDGE 10,307,612 2,063,898 8,243,714
120-9-0880-90-106 LEANDER RD(RIVER RIDGE/SW BYPA 1,550,000 - 1,550,000
120-9-0880-90-107 ROCK ST-6TH TO 9TH ST 273,000 - 273,000
120-9-0880-90-108 RIVERY EXTENSION - 25,500 (25,500)
120-9-0880-90-109 SE INNER LOOP ROCKRIDE IMPRV 115,000 - 115,000
120-9-0880-91-001 10TH ST (MAIN-ROCK)168,880 168,880 -
120-9-0880-91-002 11TH ST. (MAIN-ROCK)236,130 236,130 -
120-9-0880-91-006 AUSTIN AVE. (SH29-FM2243)492,300 494,445 (2,145)
120-9-0880-91-008 OLD TOWN NORTHEAST 826,445 917 825,528
120-9-0880-91-009 PH 1 SIGNAL & CURB RAMP IMPR.308,837 - 308,837
STORMWATER CAPITAL IMPROVEMENT
640-9-0880-90-005 CURB & GUTTER 527,504 117,365 410,139
640-9-0880-90-020 STORMWATER INFASTRUCTURE 200,000 41,100 158,900
640-9-0880-90-040 SPOILS FACILITY 100,000 - 100,000
640-9-0880-90-064 POND REHAB-2ND AND ROCK 450,000 21,205 428,795
640-9-0880-90-078 18TH AND HUTTO DRAINAGE 184,367 25,544 158,823
640-9-0880-90-079 2ND AND ROCK POND - 894 (894)
640-9-0880-90-081 VILLAGE PID INLET 75,000 - 75,000
STREET TAX SRF
203-9-0880-90-071 STREET MAINTENANCE 5,443,616 189,277 5,254,339
WATER SERVICES
660-9-0580-90-071 TANK REHAB PROJECTS 480,000 55,455 424,545
660-9-0580-90-076 DB WOOD/ PASTOR 24 DEDICATED 5,285,667 2,951,113 2,334,554
660-9-0580-90-077 RABBIT HILL WATERLINE 1,050,000 - 1,050,000
660-9-0580-90-078 RONALD REAGAN/DANIELS MOUNTAIN 6,425,959 6,177,625 248,334
660-9-0580-90-079 ROCK SUPPLY LINE 1,100,000 - 1,100,000
660-9-0580-90-080 RADIO REPLACEMENT 153,670 - 153,670
660-9-0580-90-097 SUN CITY ELEVATED STORAGE TANK - 2,432 (2,432)
55
CIP Quarterly Report - Q2 FY2019 Budget
Year-todate
(W/Encum)Remaining Balance
660-9-0580-90-125 SHELL ROAD WATER LINE 6,033,651 - 6,033,651
660-9-0580-90-166 LEANDER INTERCONNECT 225,000 - 225,000
660-9-0580-90-167 WEST LOOP (H-1A)2,119,000 - 2,119,000
660-9-0580-90-168 LWTP RAW WATER INTAKE REHAB 13,450,000 (7,319) 13,457,319
660-9-0580-90-170 CR 255 (WD14-2)1,493,963 - 1,493,963
660-9-0580-90-171 DOMEL PS IMPROVEMENTS (216,892) (216,892) -
660-9-0580-90-175 BRAUN EST 4,350,731 3,528,453 822,278
660-9-0580-90-176 MISC. LINE UPGRADES 393,899 - 393,899
660-9-0580-90-177 PARK WTP CLEARWELL 170,000 - 170,000
660-9-0580-90-178 S. LAKE WTP 2018 6,950,260 3,179,544 3,770,716
660-9-0580-90-179 SW BYPASS WATER H24-1 500,000 - 500,000
660-9-0580-90-180 TANK REHABILITATION 480,000 - 480,000
660-9-0580-90-200 WATER MAINS 2,208,325 729,716 1,478,609
660-9-0580-91-102 ASSET MANAGEMENT - 26,203 (26,203)
660-9-0580-91-105 CIS SYSTEM - 37,653 (37,653)
660-9-0581-90-051 PECAN BRANCH PH 2 - 424 (424)
660-9-0581-90-160 BERRY CREEK INTER (BC 4-6)20,714,161 5,614,279 15,099,882
660-9-0581-90-162 BERRY CREEK INTER (BC 1-3)- 677 (677)
660-9-0581-90-163 SAN GABRIEL BELT PRESS 1,900,932 58,500 1,842,432
660-9-0581-90-164 PARK LIFT STATION & FORCE MAIN 3,585,740 11,400 3,574,340
660-9-0581-90-166 EARZ 2,000,000 754,265 1,245,735
660-9-0581-90-167 SAN GABRIEL INTER SGI-2 2,500,000 1,037,700 1,462,300
660-9-0581-90-200 WW INTERCEPTORS 613,874 5,385 608,489
660-9-0581-90-210 WWTP UPGRADE/EXP 1,150,000 - 1,150,000
660-9-0581-90-220 LIFT STATION UPGRADE 550,000 2,835 547,165
Grand Total 159,821,047 46,280,105 113,540,941
56
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates - 12/31/18 Status Updates - 3/31/19
Cemetery Special Revenue
Fund
Currently cemetery operations are self-funded through plot
sales of approximately $50K per year. The cemetery is
managed through Parks Administration. In 2015, Council
elected to reserve $75,000 annually for future costs
associated with maintaining the property. The General Fund
has made this transfer in since FY 2016.
The columbarium project is complete. Finance and Parks staff
continue to evaluate cemetery related fees, costs, and options to
fund the perpetual reserve.
Continue to request $75,000 annual reserves for future maintenance
costs.
Unfunded Actuarial Accrued
Liability (UAAL)
Recognizes the outstanding liability for the City’s employee
retirement plan through TMRS. The City contributes
monthly to fund the UAAL, based on an annual percentage
of payroll. Actual % of payroll costs is recognized within each
fund. The UAAL is provided by TMRS and lags one year.
No change. Updated once annually.
As of 12/31/2017, the net pension liability (NPL) is $17.3 million and
is 87.8% funded. The 2019 TMRS total combined contribution rate is
12.36%.
Other Post Employee Benefits
(OPEB)
While the City has no obligation to offer additional retiree
benefits, retirees are eligible to participate in the City’s
health insurance program. That ability represents a subsidy
that impacts health insurance costs to the City. Retirees pay
their monthly premiums to the self insurance fund, which
then processes their health insurance claims.
No change. Updated once annually.
This is an actuarial calculation based on current and future
employees on future City health insurance costs and Life insurance
benefits, which has numerous and complex factors in its calculation.
Retirees pay their own premiums, and thus the liability is considered
“pay as you go”. With additional employees being added, potential
future
retiree impacts increase. The 2018 current OPEB liability is
$2,182,012 for healthcare benefits and $1,091,292 for Life insurance
benefits.
Compensated Absence
Future costs associated with benefits such as vacation, and
sick leave for City employees. Compensated Absence is
accrued annually to each proprietary fund type on a GAAP
basis and accounted for on the balance sheet of each fund.
For governmental funds (and for budgetary basis), the
expense is recognized when due and payable.
In 2018, total citywide compensated absence is $6.9M, of that
$5.8M is considered unfunded in the General Fund. The City's Fiscal
and Budgetary Policy state the payout reserve will equal 15% of the
liability in the Governmental Funds. The FY 2020 budget process
should consider increasing the payout reserve for the Governmental
Funds to be in compliance with the policy.
The current amount of the Benefit Payout Reserve is $255,000.
For FY 2020, it needs to be increased to approximately $340,000.
Electric Fund Rate Stabilization
Reserve
Intended to mitigate potential rate impacts due to increased
fuel costs or other external factors. The RSR is maintained
within the Electric Fund.
The FY2019 Electric Fund budget was amended on first reading in
December 2018 and second reading in January 2019. The
amendment included recognizing additional revenue by leaving the
current Power Cost Adjustment in place, reducing operating
expenditures, reducing bond proceeds and reducing capital
expenditures. These changes restore the 90 day contingency reserve
on a budget basis. Staff continue vetting and implementing options
to improve the Electric Fund reserves.
The PCA was increased in February 2019 to recover power costs and
maintain the 90 day contingency reserve. In order to build the rate
stabilization reserve, the PCA will need to increase again.
March 31, 2019
Long-term Commitments, Reservations, and Other Unfunded Liabilities
CITY OF GEORGETOWN
57
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates - 12/31/18 Status Updates - 3/31/19
Airport Maintenance
Fund on-going maintenance of the Airport grounds, runways
and taxi ways. Terminal and Tower included in Facilities ISF.
An Airport Master Plan was developed to address long term
capital maintenance project prioritization.
The Airport Fund continues to have a positive balance. The Wildlife
Hazard Assessment is complete and undergoing final review. The
Texas Transportation Commission approved the Runway 18-36
rehabilitation project, including grooving the new pavement, overlay
of additional shoulder pavement, and installation of lighting
infrastructure in preparation for future lighting projects.
Construction is expected to start February 2019 and end May 2019.
Currently in the process of interviewing and hiring a new Airport
Manager.
The Airport Fund continues to have a positive balance. The Wildlife
Hazard Assessment is complete and undergoing final review by
TxDOT. The Texas Transportation Commission approved the Runway
18-36 rehabilitation project, including grooving the new pavement,
overlay of additional shoulder pavement, and installation of lighting
infrastructure in preparation for future lighting projects.
Construction started and expected to end May 2019. New Airport
Manager starts May 13,2019.
Americans with Disabilities Act
(ADA) Compliance Needs
As facilities are built or repurposed, meeting ADA
compliance will be included in Project Costs. Funding for
program expansion will be needed (General Fund sources).
The City has an adopted policy, as required by Federal Law,
that it will make reasonable accommodations and
modifications to ensure that people with disabilities have an
equal opportunity to enjoy its programs, services, and
activities. The City does not maintain a reserve for these
modifications.
The City is continuing the work on the CIP ADA projects. The ADA transition plan for Parks includes $150,000 per year
for FY2020-FY2022.
Sidewalk Maintenance &
Masterplan
Currently, new sidewalks are built as development occurs.
Repairs are funded as needed or if funding is available,
when major roads are repaired. Useful life of a sidewalk is
estimated at 40 to 50 years. The largest revenue source
comes from the City’s General Fund, but there has been
some debt funding as well.
Old Town NE Sidewalk – Approval has been received from TCEQ.
Design is 95% completed. One owner has signed the easement. Five
easements remain and are being worked on. Austin Ave Sidewalks
(Leander to Hwy 29) – Contract awarded to Patin Construction. Pre-
construction meeting to be held, contractor plans to start 1st part of
February.
Debt funded projects: Old Town NE Sidewalk – Approval has been
received from TCEQ. Design is completed. All easements have been
secured. We will start advertising May 5th 2019 and open bids in
late May. Plan to take to GTAB on June 14th 2019 followed by
Council. Austin Ave Sidewalks (Leander to Hwy 29) – Patin
Construction has installed Erosion Controls and Tree protection.
Construction will commence in late April 2019. Estimated
completion is late August.
Park Equipment Maintenance
& Replacement
Over the past 5 years, funding for Park Maintenance and
Replacement has increased. $200K transfer from General
Fund included in FY2018 budget. Staff has listed all assets &
developed replacement schedule funded by the General
Fund.
FY19 projects are currently in the planning stages.
FY19 projects are underway. Projects identified in the the FY20
budget total $394,000, which if completed will require an increase in
the FY20 transfer. Some of the projects identified are at Booty's
Park, Raintree Park, University Park, the Recreation Center, along
with a few others.
Radio Equipment Replacement
Communication system consisting of 500 on-body and in-
vehicle radios for Police, Fire, parks and utilities.
Replacement radios are compatible with newer technology.
Staff will be meeting with the vendor for pricing and will be
presented to Council in the next few months.
Staff is meeting with Motorola on 4/26/19, the purchases will be
presented to GGAF on 5/29/19, and taken to Council on 6/11/19.
FY2019 is the 3rd year of the replacement project, with $500,000
debt funded for the replacement. The FY2020 proposed budget
amount is $129,000 and FY2021 is $234,278.
58
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates - 12/31/18 Status Updates - 3/31/19
Street Maintenance
The City funds street maintenance in the General Fund,
supplemented by a 1/8th Street Sales Tax special revenue
fund. In 2017 and 2018, the Council and GTAB reviewed
various methods for enhanced street maintenance and
costs. Direction from Council is to use high performance
surface seals and pavement wearing courses and begin
programmatically addressing the street network's deferred
maintenance backlog, creating a need for approximately $2
million more per year for street maintenance.
The 2018 Pavement Condition Survey project was completed and
local roads were prioritized for bidding. Due to weather delays, the
entire program was not able to be completed, but will resume work
in the Spring 2019 along with other projects selected for
maintenance. Planned and programed Street Maintenance is
currently coordinated and completed by Systems Engineering
through contracting services. Public Works Operations staff
continue to work on spot repairs and general street maintenance.
2019 Street Maintenance projects scheduled include 47 lane miles of
local roads to be treated with High Performance Sealant. Pavement
rehabilitation projects using Hot In Place Asphalt Recycling total 25.5
lane mile.
59