HomeMy WebLinkAbout3rd Qtr Report
Vision: A caring
community,
honoring our past,
and innovating for
the future.
CITY OF
GEORGETOWN
FISCAL YEAR
2019 BUDGET
THIRD QUARTER REPORT
FINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended June 30, 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-42
Quarterly Investment Report - GTEC ...................................................................................................... 43-48
Quarterly Investment Report - GEDCO ................................................................................................... 49-54
Grant Applications ....................................................................................................................................... 55
Capital Improvement Projects ................................................................................................................ 56-58
Long-term Commitments and Other Unfunded Liabilities ..................................................................... 59-61
FINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended June 30, 2019
Table of Contents
Executive Summary .................................................................................................................................... 1-6
General Fund Schedule ................................................................................................................................. 7
Electric Fund Schedule .................................................................................................................................. 8
Water Services Fund Schedule ...................................................................................................................... 9
Joint Services Fund Schedule ....................................................................................................................... 10
Council Discretionary Fund Schedule .......................................................................................................... 11
Convention & Visitors Bureau Fund Schedule ............................................................................................. 12
Airport Fund Schedule ................................................................................................................................. 13
Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 14
Georgetown Economic Development Corporation Fund Schedule ............................................................. 15
Quarterly Investment Report - City ........................................................................................................ 16-39
Quarterly Investment Report - GTEC ...................................................................................................... 40-45
Quarterly Investment Report - GEDCO ................................................................................................... 46-51
Grant Applications ....................................................................................................................................... 52
Capital Improvement Projects ................................................................................................................ 53-55
Long-term Commitments and Other Unfunded Liabilities ..................................................................... 56-58
F FY2019 Quarterly Report
EXECUTIVE SUMMARY FOR THE QUARTER ENDED JUNE 30, 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 3rd quarter report reflects the Mid-Year Amendment that was
adopted in June.
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 third quarter of FY2018 to FY2019 in ROI and Franchise Fees in the General Fund.
GENERAL FUND REVENUES:
General Fund revenues total $53.3 million, or 75% of budget. Year to date, revenues exceed last year’s third quarter
revenues by 9.3%.
The sales tax revenue through June totals $9.6 million, or
60.2% 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 third quarter of FY2019 is up
11.5%, or $1.4 million from the third quarter of FY2018. Through the third quarter of FY2019, collections total 98.4%
of budget. After the third 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 third
quarter, franchise fee revenues total $3.5 million in FY2019, a decrease of 6.5% from the third quarter of FY2018.
The decrease is due to the protracted billing cycle of the electric, water, and wastewater franchise fees.
Return on Investment revenue represents 11% of total general fund revenues. Year to date ROI revenue totals $5.3
million. This revenue stream includes an ROI for the Electric, Water, and Stormwater funds. ROI is projected to end
FY2019 at $7.27 million, or 6.4% less than budget. Staff is proposing transferring only $3.825 million from the Electric
Fund instead of the full budgeted amount of $4.325 million.
Sanitation revenue through the third quarter totals $7.1 million or 75% of budget. It is projected this revenue stream
will finish at budget.
$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
F FY2019 Quarterly Report
Development related revenue continues to be strong. Through the third quarter, development related revenue totals
$2.35 million or 71.2% of budget. As shown in the graph to the right, permits tend to increase in the spring and
summer months. The number of building permits is slightly down 1.4% when compared to the third quarter of
FY2018, however, development related revenue is up
19.6%. This is due to a one-time payment of Master
Development fees from MUDs in FY2019 of about
$400,000 received in June.
Fire and EMS revenue through the third quarter totals
$5.7 million, or 82.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 $1.9 million through
the third quarter. This represents an increase of 11.7%
from the third quarter of FY2018. Year to date, Parks and
Rec revenues are at 65.2% of budget. It is anticipated that
Parks and Recreation revenue will end at $2.7 million.
This is a variance of $251,000 from budget. This is
primarily due to Garey Park revenue which is projected to
come in $175,000 less than budget. FY2019 is the first year of operations. Staff has decreased the revenue budget
in FY2020.
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 third 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 third quarter total $50.97 million, or 71.8% of budget (includes personnel,
operations, and capital costs). Total salaries and benefit expenditures through the third quarter total $30.1 million.
Operational costs total $20.2 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 General Government
Contracts) expenditures for the third quarter total $1.9 million, which represents 73.6% of budget.
Year-to-date expenditures for the Community Services (Parks and Rec., Library, and Communications) and Finance
Division (Municipal Court) total $8.7 million or 70.1% of budget.
-
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
F FY2019 Quarterly Report
Year-to-date expenditures for the Development & Planning Division totals $1.9 million through the third quarter or
63.5% of budget. Operational expenses total only 41.4% year-to-date. The savings is due to TIA reimbursements and
Annexation planning. These two savings total $170,000 and was incorporated in the FY2020 Budget development.
The Georgetown Utility System Division (Environmental Services, Inspections, Public Works, and Streets)
expenditures through the third quarter total $8.3 million or 68.5% of budget.
Year-to-date expenditures for Police through the third quarter total $12.2 million or 75.6% of budget. Year-to-date
expenditures for Fire through the third quarter total $13.7 million or 72.8% of budget.
The City has experienced 20 of 26 pay periods through the third quarter, or 76.9% of total cycles.
Personnel and Operations Summary (excludes capital accounts)
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.
Every division is anticipated to finish FY2019 at or below budget with the possible exception of Police. The Police
Department is experiencing an increase in overtime due to special events and summer patrol of Blue Hole. The
FY2020 budget proposes increased overtime in Police to address these issues.
UTILITY FUNDS:
Electric Fund: Electric sales revenue through the third quarter of FY2019 totals $52.4 million, or 66.3% of budget.
Electric revenue sales are typically higher in the summer months when consumption increases. Purchased Power
expenses total $35.4 million, or 66.7% of budget. This report includes the regular June (3rd Quarter) Electric Fund
Schedule, as well as a preliminary July 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 July 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 June 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.
Water Fund: Overall water operating revenue totals $45.6 million, or 73.5% of budget. Water, wastewater, and
irrigation sales revenue through the third quarter totals $26.6 million, or 62.8% of budget. Capital Recovery Fees total
$11.7 million.
Water operating expenses total $26.8 million, which represents 72% of budget. Non-operational expenses total $29.2
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: Overall revenue in the fund totals 1.1 million, or 73.9% of budget. Hotel
Occupancy Tax revenue totals $951,794 for the third quarter of FY2019, or 70.5% of budget. HOT revenue is typically
higher in the spring and summer months. Year to date expenses in the Convention & Visitors Bureau Fund total $1.07
million, or 79.0% of budget. The fund is budgeted to finish FY2019 with a fund balance of $1.4 million and meet the
90-day operational reserve.
Airport Fund: Airport operating revenue totals $2.4 million, which represents 61.7% of budget. Operation expenses
in the Airport fund total $3.0 million, or 85.0% of budget. Approximately $624,000 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 $1.26 million in fund balance and meet all 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 third quarter of fiscal year
2019 includes the maturing of financial institution deposits (CDs), reinvestment of CD’s, & investing of new bond
proceeds in CD’s and Treasury Bills. Interest rates for money market accounts, Treasury bills, and CD’s decreased
during this quarter. We have begun to see a decline in rates being submitted, due to changes in the market. The
F FY2019 Quarterly Report
City will continue soliciting for the best rates to improve both diversity and yield, while keeping in mind safety and
liquidity.
The Investment Reports for the quarter ending June 30, 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 June 30, 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
3/31/19 6/30/19 3/31/19 6/30/19 3/31/19 6/30/19
Total cash and investments
$188,114,708 $204,976,917 $19,423,174 $21,345,649 $7,551,001 $7,950,908
Average Yield 2.41% 2.50% 2.53% 2.50% 2.45% 2.43%
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 100% with a letter of credit or 102% with pledged securities for all of the City’s investments.
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 this quarter, 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.
F FY2019 Quarterly Report
FIRE STATIONS 6 & 7
Fire Station No. 6: Both CMU blocks and wood framing are underway. The wood framing began this month and its
anticipated to be complete within a couple of weeks. Site utilities are almost complete, and concrete is scheduled to
begin in the next few weeks.
Fire Station No. 7: CMU construction is near completion. The bay walls are full height and wood framing is near
completion. Truss delivery is to begin soon so roofing can be put in place. Site utilities are almost complete, and the
contractor has bored under University Ave, bringing COG water and wastewater to the site. Site concrete is scheduled
to begin in the next few weeks.
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 is complete and bids were opened on July 16th.
Georgetown Transportation Advisory Board (GTAB) will consider awarding the project on August 9, 2019 followed by
Council.
Austin Ave. Sidewalks (Hwy. 29 to Leander Rd): Approximately 95% of the sidewalk is installed. The contractor plans
to have all concrete work completed by the end of the summer. Pedestrian activated lights will also be installed
along with crosswalk striping.
TRANSPORTATION
10th & 11th @ Austin Ave Improvements: This project is substantially complete. The contractor is working on a few
remaining punch list items.
ELECTRIC
New development projects continue through the third quarter and include residential, multifamily, and business
projects. Projects under construction include:
Sun City neighborhood 71, Small Cell installation, Vista Point Cottages, Palace Education Center, Vanguard Trucking
Center, Heritage Court, and University widening project.
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 linear foot 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.
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR‐END
PROJECTION
BEGINNING FUND BALANCE 10,917,971 10,946,800
Revenue
Administrative Charges 2,428,000 202,333 1,821,000 2,428,000
All Other Revenue 2,430,500 112,328 1,855,205 2,183,832
Development and Permit Fees 3,307,000 422,264 2,353,149 3,726,935
Franchise Fees 5,434,000 487,380 3,798,860 5,589,123
Parks and Rec Fees 2,960,100 338,570 1,929,387 2,708,167
Property Tax 13,850,000 (487,522) 13,628,002 13,880,000
ROI 7,777,490 1,295,917 5,249,806 7,277,490
Sales Tax 15,924,475 1,444,210 9,584,753 16,734,375
Sanitation Revenue 9,448,500 1,066,104 7,090,422 9,452,750
Fire/EMS Revenue 6,926,266 2,025,388 5,723,577 6,885,370
Transfer In 321,782 68,750 233,033 321,782
Revenue Total 70,808,113 6,975,722 53,267,193 71,187,824
Expense
Administrative Services 1,571,103 129,723 1,222,474 1,571,084
Animal Services 926,122 91,624 660,959 888,693
Arts & Culture 37,545 2,250 21,788 37,545
City Council 171,395 19,842 131,065 169,595
City Secretary 897,280 58,724 590,067 844,379
Code Enforcement 432,800 28,027 288,283 419,061
Communications 425,160 31,463 318,692 409,718
Environmental Services 7,902,414 651,053 4,982,662 7,901,514
Fire Emergency Services 13,181,569 1,042,842 9,681,306 13,177,738
Fire Support Services 3,000,589 244,523 2,128,285 2,973,649
Fire EMS 2,593,697 146,987 1,868,800 2,584,430
Garey Park 948,290 57,460 590,482 842,399
General Gov't Contracts 3,430,401 306,359 3,460,096 3,964,796
Inspections 1,277,145 95,303 926,392 1,249,703
Municipal Court 635,935 49,294 488,408 634,168
Library 2,696,579 213,555 2,040,855 2,683,051
Parks 2,799,674 219,794 1,951,226 2,691,034
Parks Admin 615,051 49,966 454,023 613,715
Planning 1,746,148 118,227 992,825 1,507,294
Police Admin 2,355,161 194,829 1,793,226 2,387,527
Police Operations 12,450,598 978,489 9,474,909 12,575,343
Public Works 1,296,263 142,685 1,046,755 1,196,755
Rec Programs 1,358,009 161,137 723,210 1,310,665
Recreation 2,650,888 268,575 1,984,120 2,650,686
Streets 4,688,211 218,226 2,503,980 4,463,819
Tennis Center 463,162 37,627 291,429 449,365
Transfer Out 361,000 ‐ 361,000 446,000
Expense Total 70,912,190 5,558,582 50,977,316 70,643,724
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (104,076) 1,417,140 2,289,877 544,100
AVAILABLE FUND BALANCE 10,813,895 11,490,900
Year‐End Projection to Approved: Jun FY2019
General Fund
FY2019 Budget CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 2,103,922 2,103,922
Operating Revenue
Electric Revenue 79,100,000 8,636,461 52,408,141 80,681,744
Interest 38,000 5,607 67,297 107,819
Other Revenue 5,243,546 628,392 3,045,752 5,306,828
Transfer In 95,787 (95,787) - -
Operating Revenue Total 84,477,333 9,174,674 55,521,190 86,096,391
Operating Expenditures
CRR Credits (3,000,000) (24,986) (1,908,387) (3,000,000)
Georgetown Utility Systems 19,337,779 1,534,391 14,419,820 19,159,987
Purchased Power 53,185,477 4,310,990 35,476,493 55,236,511
Transfer Out-ROI 4,325,000 921,145 3,671,503 3,825,000
Operating Expenditures Total 73,848,256 6,741,541 51,659,429 75,221,498
Total Net Operations 10,629,077 2,433,133 3,861,761 10,874,893
Non-Operating Revenue
Grant Revenue 100,000 - - 100,000
Transfer In-Other 548,104 - - 548,104 Non-Operating Revenue Total 648,104 - - 648,104
Non-Operating Expenditures
CIP 4,017,007 647,701 2,993,836 3,858,007
Interest Expense 1,386,781 - 721,821 1,386,781
Debt Service 3,035,374 - 1,725 3,035,374
Non-Operating Expenditures Total 8,439,162 647,701 3,717,382 8,280,162
Total Net Non-Operations (7,791,058) (647,701) (3,717,382) (7,632,058)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 2,838,019 1,785,432 144,380 3,242,835
ENDING FUND BALANCE 4,941,941 5,346,757
Contingency 4,082,999 4,082,999
Rate Stabilization Reserve 147,079 1,263,757
AVAILABLE FUND BALANCE 711,862 -
Year-End Projection to Approved: Jun FY2019
Electric Fund
FY2019 Budget CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 2,103,922 2,103,922
Operating Revenue
Electric Revenue (SEE NOTE A)79,100,000 3,138,709 55,546,849 80,681,744
Interest 38,000 4,820 72,117 107,819
Other Revenue 5,243,546 404,567 3,450,319 5,306,828
Transfer In 95,787 - - -
Operating Revenue Total 84,477,333 3,548,096 59,069,286 86,096,391
Operating Expenditures
CRR Credits (3,000,000) (490,614) (2,399,001) (3,000,000)
Georgetown Utility Systems 19,337,779 707,031 15,057,292 19,159,987
Purchased Power 53,185,477 5,870,221 41,353,886 55,236,511
Transfer Out-ROI (SEE NOTE B)4,325,000 153,497 3,825,000 3,825,000
Operating Expenditures Total 73,848,256 6,240,135 57,837,178 75,221,498
Total Net Operations 10,629,077 (2,692,039) 1,232,108 10,874,893
Non-Operating Revenue
Grant Revenue 100,000 - - 100,000
Transfer In-Other 548,104 - - 548,104 Non-Operating Revenue Total 648,104 - - 648,104
Non-Operating Expenditures
CIP 4,017,007 144,846 3,058,465 3,858,007
Interest Expense 1,386,781 - 721,821 1,386,781
Debt Service 3,035,374 - 1,725 3,035,374
Non-Operating Expenditures Total 8,439,162 144,846 3,782,011 8,280,162
Total Net Non-Operations (7,791,058) (144,846) (3,782,011) (7,632,058)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 2,838,019 (2,836,885) (2,549,902) 3,242,835
ENDING FUND BALANCE 4,941,941 5,346,757
Contingency 4,082,999 4,082,999
Rate Stabilization Reserve 147,079 1,263,757
AVAILABLE FUND BALANCE 711,862 -
NOTES:
A.INCLUDES ACCRUAL FOR JUNE REVENUE BILLED THROUGH AUG 10
B.JULY PROJECTION ADJUSTED DOWN TO $153,497.27 IN ORDER TO CAP ANNUAL ROI EXPENSE AT $3,825,00.
Year-End Projection to Approved: Jul FY2019
Electric Fund
PRELIMINARY
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB) YEAR‐END PROJECTION
BEGINNING FUND BALANCE 89,159,703 89,128,534
Operating Revenue
Capital Recovery Fee 14,250,000 1,779,823 11,799,336 15,139,255
Interest 569,400 230,030 1,521,802 1,482,998
Irrigation Utility Revenue 301,557 18,968 110,157 301,578
Other Revenue 2,262,146 451,563 3,833,155 3,546,274
Raw Water Revenue 140,000 37,782 143,173 140,000
Transfer In, Debt 103,725 ‐ ‐ 103,725
Wastewater Utility Revenue 12,975,345 1,117,493 9,956,510 13,015,186
Water Utility Revenue 29,116,931 2,896,307 18,197,150 29,350,000
Operating Revenue Total 59,719,104 6,531,965 45,561,283 63,079,016
Operating Expenditures
Irrigation 270,324 13,816 116,088 270,000
Transfer Out, Fleet/Joint Service/IT 245,000 ‐ 245,000 245,000
Transfer Out, General 275,000 68,750 206,250 275,000
Transfer Out, ROI 3,200,000 345,963 1,444,248 3,200,000
Transfer Out, Utilities 95,787 (95,787) ‐ ‐
Wastewater Distribution 904,415 47,512 506,719 795,050
Wastewater Plant Management 2,705,069 284,887 2,321,289 2,687,676
Water Administration 19,923,733 1,787,061 15,259,460 20,981,179
Water Distribution 2,707,265 224,114 1,646,713 2,598,600
Water Operations 4,157,528 450,353 3,196,912 4,252,288
Water Plant Management 2,948,733 183,197 1,839,702 2,909,309
Operating Expenditures Total 37,432,854 3,309,865 26,782,382 38,214,102
Total Net Operations 22,286,250 3,222,100 18,778,901 24,864,914
Non‐Operating Revenue
Bond Proceeds ‐ ‐ ‐ ‐
Non‐Operating Revenue Total ‐ ‐ ‐ ‐
Non‐Operating Expenditures
CIP 85,667,940 2,829,182 28,013,387 40,226,858
Debt Service 6,250,111 ‐ 1,149,964 6,250,111
Non‐Operating Expenditures Total 91,918,051 2,829,182 29,163,351 46,476,969
Total Net Non‐Operations (91,918,051) (2,829,182) (29,163,351) (46,476,969)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (69,631,801) 392,918 (10,384,450) (21,612,055)
ENDING FUND BALANCE 19,527,902 67,516,479
Reserved Bond Proceeds ‐ 18,000,000
Contingency 7,498,183 7,498,183
Non‐Operating Contingency 9,500,000 9,500,000
AVAILABLE FUND BALANCE 2,529,719 32,518,296
Year‐End Projection to Approved: Jun FY2019
Water Fund
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 1,469,434 1,469,434
Revenue
Gedco Admin/Contract Fee 238,622 19,885 178,967 238,622
Gtec Admin/Contract Fee 172,318 14,360 129,239 172,318
Interest 17,503 4,130 17,905 25,000
Other 136,153 39,953 128,526 213,412
Service Fees - Airport 128,966 10,747 96,724 128,966
Service Fees - Electric 4,615,524 384,627 3,461,643 4,313,880
Service Fees - General 3,573,156 297,763 2,679,867 3,384,629
Service Fees - Stormwater 1,020,427 85,036 765,320 982,721
Service Fees - Water 7,966,284 663,857 5,974,713 8,494,162
VPID Admin/Contract Fee 15,924 1,327 11,943 15,924
Revenue Total 17,884,877 1,521,685 13,444,846 17,969,634
Expense
Accounting 1,067,433 65,954 776,360 1,044,212
BIP 150,085 13,165 96,758 127,117
City Wide Hr 415,500 22,338 256,788 382,500
Conservation 766,699 96,156 482,389 704,374
Customer Care 4,701,266 340,663 3,689,022 4,696,447
Economic Development 635,768 43,121 430,455 609,899
Engineering 2,430,052 169,960 1,699,568 2,258,637
Engineering Support 1,147,160 106,783 856,327 1,131,488
Finance Administration 975,583 51,215 782,585 960,951
Gus Administration 1,476,541 119,405 1,046,463 1,490,841
Human Resources 1,003,190 71,332 732,619 991,779
In-House Legal 1,038,782 118,646 733,995 1,031,103
Insurance & Legal 752,000 6,360 646,481 727,249
Joint Svcs Con 598,775 110,232 633,485 960,000
Purchasing 811,459 52,983 474,208 770,628
Transfer Out 157,000 - 57,000 157,000
Expense Total 18,127,294 1,388,314 13,394,504 18,044,225
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (242,416) 133,371 50,343 (74,591)
AVAILABLE FUND BALANCE 1,227,018 1,394,843
Joint Services Fund
Year-End Projection to Approved: Jun FY2019
APRROVED
BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 131,914 131,914
Revenue
Interest 10,000 338 1,795 2,500
Transfer In, General Fund - - - -
Revenue Total 10,000 338 1,795 2,500
Expense
Transfer Out, GCP - - - -
Transfer Out, General Fund 25,000 - 5,000 25,000
Transfer Out, Joint Services - - - -
Expense Total 25,000 - 5,000 25,000
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (15,000) 338 (3,205) (22,500)
ENDING FUND BALANCE 116,914 109,414
Year-End Projection to Approved: Jun FY2019
Council Discretionary Fund
APRROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR-END
PROJECTION
BEGINNING FUND BALANCE 1,170,801 1,301,054
Revenue
Hotel/Motel Occupancy Tax Revenues 1,350,000 245,134 951,794 1,300,000
Interest 5,000 3,178 16,130 18,000
Other 23,500 2,706 17,286 18,500
Poppy Festival 136,150 41 135,153 144,283
Revenue Total 1,514,650 251,059 1,120,363 1,480,783
Expense
Operations 713,831 23,284 552,199 703,729
Personnel 369,492 28,524 285,312 371,704
Poppy Festival 165,200 87 147,523 165,200
Transfer to Facilities 49,507 4,126 37,130 49,507
Transfer to Fleet 5,048 421 3,786 5,048
Transfer to General Fund 21,783 - 21,783 21,783
Transfer to Information Technology 27,722 2,310 20,792 27,722
Expense Total 1,352,583 58,750 1,068,526 1,344,693
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 162,067 192,309 51,837 136,090
ENDING FUND BALANCE 1,332,868 1,437,144
Contingency 271,189 271,189
Reserved for Capital 1,061,680 1,061,680
AVAILABLE FUND BALANCE (2) 104,274
Year-End Projection to Approved: Jun FY2019
Convention & Visitors Bureau Fund
APPROVED
BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB)
YEAR‐END
PROJECTION
BEGINNING FUND BALANCE 1,298,256 1,298,256
‐
Operating Revenue
Fuel and Terminal Sales 2,907,450 190,497 1,695,685 2,751,500
Interest and Other 80,260 2,683 34,666 86,000
Leases and Rentals 863,952 72,552 647,311 859,940
Operating Revenue Total 3,851,662 265,732 2,377,662 3,697,440
Operating Expenditures
Operations‐Fuel 2,400,000 104,970 2,236,458 2,200,000
Operations‐Non Fuel 732,721 69,520 524,911 726,748
Personnel 417,348 36,056 256,681 371,525
Operating Expenditures Total 3,550,069 210,546 3,018,051 3,298,273
TOTAL NET OPERATIONS 301,593 55,186 (640,389) 399,167
Non‐Operating Revenue
Bond Proceeds 465,000 ‐ 472,813 465,000
Grants 40,000 ‐ ‐ 40,000
Non‐Operating Revenue Total 505,000 ‐ 472,813 505,000
Non‐Operating Expenditures
Hangar Upgrades 75,000 26,914 75,000 75,000
Pavement Upgrades 15,000 ‐ (10,744) 15,000
Runway Rehab 516,500 ‐ ‐ 516,500
Taxiway Edge Lighting 150,000 ‐ ‐ 150,000
Wildlife Management 35,000 ‐ 24,351 35,000
Debt Service 147,975 ‐ 29,809 147,975
Non‐Operating Expenditure Total 939,475 26,914 118,417 939,475
TOTAL NET NON‐OPERATIONS (434,475) (26,914) 354,397 (434,475)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (132,882) 28,272 (285,992) (35,308)
ENDING FUND BALANCE 1,165,374 (285,992) 1,262,948
RESERVES
Contingency 264,442 264,442
Reserves Total 264,442 264,442
AVAILABLE FUND BALANCE 900,932 998,506
Airport Operations Fund
Preliminary For the Month Ended: Jun FY2019
APPROVED BUDGET CURRENT PERIOD
YEAR TO DATE
(W/ENCUMB) YEAR-END PROJECTION
BEGINNING FUND BALANCE 18,539,789 18,539,789
Operating Revenue
Sales Tax 7,073,100 641,871 4,259,888 7,437,500
Interest 190,000 21,815 333,486 308,317
Operating Revenue Total 7,263,100 663,686 4,593,373 7,745,817
Operating Expenditure -
Administrative Support 391,697 32,575 293,294 391,197
Operating Expenditure Total 391,697 32,575 293,294 391,197
TOTAL NET OPERATIONS 6,871,403 631,112 4,300,079 7,354,620
Non-Operating Revenue
Debt Proceeds - - - -
Non-Operating Revenue Total - - - -
Non-Operating Expenditure
Pecan Center Dr to Airport Rd (FY15)2,445,036 - (334) 386,000
Arterial SE1:Inner Loop/SH130 - - - -
Rivery TIA Improvements 359,496 75,298 281,090 359,496
FM 971 / Fontana 63,102 15,206 14,767 63,102
Rivery-Extension Williams Dr to NW Blvd (FY16)730,635 16,502 475,086 730,635
IH 35 / HWY29 Intersection 606,653 3,216 160,684 606,648
NB Frontage 2338 to Lakeway 51,631 - 17,114 51,631
SW Bypass 2243 to IH35 128,144 - - 13,071
FM1460 Widening 500,783 60 500,783
Wolf Ranch Pkwy Extension 283,350 - - 11,000
Mays St 4,500,000 236 38,550 1,000,000
Available for Projects TBD 1,716,644 - - 1,716,644
SE Inner Loop Widening (Rock Ride ROW)900,000 - 948,251 -
Debt Service 3,324,747 - 522,432 3,324,747
Non-Operating Expenditure Total 15,610,221 110,459 2,457,701 8,763,757
TOTAL NET NON-OPERATIONS (15,610,221) (110,459) (2,457,701) (8,763,757)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (8,738,818) 520,653 1,842,378 (1,409,137)
ENDING FUND BALANCE 9,800,971 17,130,652
RESERVES
Contingency 1,768,275 1,768,275
Reserved Bond Proceeds - 2,500,000
Reserves Total 1,768,275 4,268,275
AVAILABLE FUND BALANCE 8,032,696 12,862,377
Georgetown Transportation Enhancement Corporation Fund
Year-End Projection to Approved: Jun FY2019
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 - 116,685 40,300
Sales Tax 1,768,275 160,468 1,064,972 1,768,275
OPERATING REVENUES Total 1,808,575 160,468 1,181,657 1,808,575
OPERATING EXPENDITURES
Joint Services Allocation 238,622 19,885 178,967 238,622
Miscellaneous Expense 50 - - 50
Promotional & Marketing Program 100,000 4,500 73,843 100,000
Special Services 30,000 - - 30,000
Travel & Training 500 - - 500
OPERATING EXPENDITURES Total 369,172 24,385 252,810 369,172
TOTAL NET OPERATIONS 1,439,403 136,083 928,847 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 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 - 72,534 7,840,407
TOTAL NET NON-OPERATIONS (7,840,407) - (72,534) (7,840,407)
EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL
REQUIREMENTS (6,401,004) 136,083 856,313 (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: June FY2019
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
87,558.34 43,779.17
Airport Federal Aviation
Administration
Texas Department of
Transportation-Aviation
16MPGRGTN Airport Master Plan Update 5,870.00 5,870.00
Airport Federal Aviation
Administration
Texas Department of
Transportation-Aviation
1814GRGTN Runway 18/36 Rehabilitation-
Engineering
458,400.00 412,560.00
Airport Federal Aviation
Administration
Texas Department of
Transportation-Aviation
1814GEORG Runway 18/36 Rehabilitation-
Construction
3,737,864.25 3,364,077.83
Fire US Department of Homeland
Security
Federal Emergency
Management Agency
EMW-2017-FH-00496 SAFER 281,576.26 210,896.11
Fire N/A Capital Area Trauma Regional
Advisory Council
FY 18/19 EMS County Grant 4,853.06 4,853.06
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)
54,984.90 54,984.90
Planning US Department of Housing &
Urban Development
Williamson County B-17-UC-48-0502 CDBG Sidewalks and Ramps
along 17th St
8,950.00 8,950.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 Meeting with Partner August
7th to draft paperwork
Planning Williamson County/CDBG Home Repair Action Plan in Public
Comment Stage until Jul 31
Planning Williamson County/CDBG Scenic Dr Sidewalk Action Plan in Public
Comment Stage until Jul 31
Parks Texas Parks and Wildlife
Department (TPWD)
Recreation San Gabriel Trails Approved at July 9th council
meeting
*Some revenue was recognized after 6/30.
Reviewed By:
CITY OF GEORGETOWN
Grant/Federal Funding Report
as of June 30, 2019
COG Name/Purpose
Active
Applications Pending Award
CIP Quarterly Report - Q3 FY2019 Budget
Year-todate
(W/Encum)Remaining Balance
AIRPORT OPERATIONS
600-5-0636-52-140 DESIGN RUNWAY REHAB 35,000 - 35,000
600-5-0636-52-141 HANGAR UPGRADES 516,500 75,000 441,500
600-5-0636-52-142 PAVEMENT UPGRADES 75,000 (10,744) 85,744
600-5-0636-52-145 WILDLIFE MANAGEMENT 15,000 24,351 (9,351)
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
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 - 11,792 (11,792)
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 42,787 102,658
610-9-0580-90-263 LEANDER RD_IH35 INTERSECTION 10,000 - 10,000
610-9-0580-90-266 RIVERY EXTENSION 49,269 24,713 24,557
610-9-0580-90-267 UNIVERSITY_MAYS WIDENING 154,000 1,377 152,623
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 2,572,161 450,839
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 89,972 160,028
120-9-0280-90-035 VFW PARK 175,000 156,551 18,449
120-9-0280-90-045 SAN GABRIEL PARK IMPROVEMENT 834,288 458,990 375,298
120-9-0280-90-046 GAREY PARK 370,000 23,851 346,149
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
120-9-0380-90-159 FIRE STATION 7 6,471,601 5,332,252 1,139,349
120-9-0380-90-160 EOC SIREN SYSTEM 6,631 - 6,631
120-9-0380-90-163 FIRE STATION 6 5,499,725 4,848,683 651,042
120-9-0380-90-166 DATA CENTER - PSOTC 100,676 - 100,676
120-9-0380-90-168 TRANSFER STATION/LANDFILL 1,011,337 - 1,011,337
120-9-0380-90-169 ERP PROJECT 5,366,384 5,362,422 3,962
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 740,189 (258,358)
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
CIP Quarterly Report - Q3 FY2019 Budget
Year-todate
(W/Encum)Remaining Balance
120-9-0880-90-050 NB FRONTAGE RD 150,000 2,803 147,197
120-9-0880-90-054 AUSTIN AVENUE BRIDGE 238,132 5,139 232,993
120-9-0880-90-065 SOUTHWESTERN BLVD 1,550,000 509,485 1,040,515
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 900,000 - 900,000
120-9-0880-90-091 SW BYPASS/WOLF RANCH PKWY 1,717,771 715,647 1,002,124
120-9-0880-90-092 SOUTHEAST INNER LOOP 1,200,000 855,082 344,918
120-9-0880-90-105 NORTHWEST BLVD BRIDGE 10,307,612 2,421,907 7,885,705
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 - 55,259 (55,259)
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 24,205 425,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 4,101,211 1,342,405
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,998,813 2,286,854
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 - 3,327 (3,327)
660-9-0580-90-125 SHELL ROAD WATER LINE 6,033,651 - 6,033,651
660-9-0580-90-146 LWTP - DEWATERING FACILITY - 29,879 (29,879)
660-9-0580-90-166 LEANDER INTERCONNECT 225,000 - 225,000
660-9-0580-90-167 WEST LOOP (H-1A)2,119,000 854,862 1,264,138
660-9-0580-90-168 LWTP RAW WATER INTAKE REHAB 13,450,000 2,658,381 10,791,619
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 18,645 375,254
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 777,046 1,431,279
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,630,461 15,083,700
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 1,137,010 862,990
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
CIP Quarterly Report - Q3 FY2019 Budget
Year-todate
(W/Encum)Remaining Balance
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 153,074,434 58,246,756 94,827,678
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates - 3/31/19 Status Updates - 6/30/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.
Continue to request $75,000 annual reserves for future maintenance
costs.
Continue to request the $75,000 be added to the 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.
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%.
No change.
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.
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.
No change.
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.
The current amount of the Benefit Payout Reserve is $255,000. No change.
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 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.
The PCA was increased in June of 2019 to recover additional costs
for purchased power. The 90 day contingency reserve is projected to
be met at the end of FY2019. The June PCA is scheduled to remain in
effect during the FY2020 budget.
CITY OF GEORGETOWN
Long-term Commitments, Reservations, and Other Unfunded Liabilities
June 30, 2019
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates - 3/31/19 Status Updates - 6/30/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 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.
There is a new paving project that will begin the last week of August.
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 ADA transition plan for Parks includes $150,000 per year
for FY2020-FY2022. No change.
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.
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.
Debt funded projects: Old Town NE Sidewalk – Approval has been
received from TCEQ. Design is completed. All easements have been
secured. Bid opening held on July 16th. GTAB approved award to
Choice Builders on August 9th. City Council will consider award on
August 27th 2019. Austin Ave Sidewalks (Leander to Hwy 29) – Patin
Construction has installed all sidewalk and pedestrian ramps
throughout the project. Contractor is completing steel plate work in
3 areas and working to have pedestrian activated signs installed at
16th and Austin Ave. All striping work is being scheduled.
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 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.
Projects in the FY 19 budget continue to be underway. There is an
increase of $97,000 proposed for the FY 20 budget to help fund the
projects identified for 2020.
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 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.
Radios ordered on 7/17/19. On 8/12 and 8/13, we received three
pallets of radio equipment. Asset management process has begun.
The T1 to Ethernet conversion is scheduled to be completed by 9/15.
NICE Recording Solution has a longer implementation process. The
goal is to have the installation completed by 12/31/19.
Unfunded Liability &
Commitments Financial Impact/Notes Status Updates - 3/31/19 Status Updates - 6/30/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.
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.
The Hot In Place Asphalt recycling is currently on-going in the Old
Town Area should be complete next week, then the Hot In Place
Asphalt recycling will move out to Berry Creek. In regards to the
High Performance Sealant Projects, application of the sealant has
started in University Park and Raintree Subdivisions. The contractor
should start in Sun City on Monday, August 19th and then
application of the sealant will begin the 1st week of September in
Georgetown Village.