The URL can be used to link to this page

Home My WebLink AboutFY 19 - 3rd Qtr Report_RedactedFINANCIAL 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 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 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.