The URL can be used to link to this page

Home My WebLink AboutFY 19 - 2nd Qtr Report_RedactedFINANCIAL REPORT AND INVESTMENT REPORT For the Quarter Ended March 31, 2019 Table of Contents Executive Summary .................................................................................................................................... 1-6 General Fund Schedule ................................................................................................................................. 7 Electric Fund Schedule .................................................................................................................................. 8 Preliminary Electric Fund Schedule ............................................................................................................... 9 Water Services Fund Schedule .................................................................................................................... 10 Joint Services Fund Schedule ....................................................................................................................... 11 Council Discretionary Fund Schedule .......................................................................................................... 12 Convention & Visitors Bureau Fund Schedule ............................................................................................. 13 Airport Fund Schedule ................................................................................................................................. 14 Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 15 Georgetown Economic Development Corporation Fund Schedule ............................................................. 16 Quarterly Investment Report - City ........................................................................................................ 17-40 Quarterly Investment Report - GTEC ...................................................................................................... 41-46 Quarterly Investment Report - GEDCO ................................................................................................... 47-52 Grant Applications ....................................................................................................................................... 53 Capital Improvement Projects ................................................................................................................ 54-56 Long-term Commitments and Other Unfunded Liabilities ..................................................................... 57-59 APRROVED BUDGET CURRENT PERIOD YEAR TO DATE (W/ENCUMB) YEAR-END PROJECTION BEGINNING FUND BALANCE 10,607,485 10,607,485 Revenue Administrative Charges 2,428,000 202,333 1,214,000 2,428,000 All Other Revenue 6,575,870 1,069,880 2,747,929 6,575,870 Development and Permit Fees 3,307,000 300,656 1,442,621 3,307,000 Franchise Fees 5,434,000 175,097 2,454,981 5,434,000 Garey Park 500,000 50,928 139,879 500,000 Parks and Rec Fees 2,460,100 218,336 972,579 2,460,100 Property Tax 13,850,000 184,815 13,781,618 13,850,000 ROI 7,777,490 487,738 2,650,943 7,777,490 Sales Tax 15,924,475 1,114,419 5,363,400 15,924,475 Sanitation Revenue 9,448,500 1,491,063 4,516,334 9,448,500 EMS Revenue 2,780,896 231,501 1,628,999 2,780,896 Transfer In 301,782 68,750 164,283 301,782 Revenue Total 70,788,113 5,595,517 37,077,566 70,788,113 Expense Administrative Services 1,552,033 118,665 801,857 1,552,033 Animal Services 926,122 60,428 432,421 926,122 Arts & Culture 37,545 2,608 15,044 37,545 City Council 171,395 12,576 86,197 171,395 City Secretary 882,280 70,831 403,545 882,280 Code Enforcement 432,800 29,728 194,220 432,800 Communications 425,160 38,372 207,224 425,160 Environmental Services 7,902,414 649,487 3,021,281 7,902,414 Fire Emergency Services 13,181,569 975,904 6,271,859 13,181,569 Fire Support Services 2,990,589 229,017 1,378,182 2,990,589 Fire EMS 2,593,697 150,863 1,384,404 2,593,697 Garey Park 948,290 65,727 406,976 948,290 General Gov't Contracts 3,291,401 302,912 2,445,447 3,291,401 Inspections 1,277,145 96,928 609,917 1,277,145 Municipal Court 635,935 49,186 327,312 635,935 Library 2,696,579 208,818 1,350,909 2,696,579 Parks 2,774,674 192,142 1,337,844 2,774,674 Parks Admin 610,051 46,123 302,615 610,051 Planning 1,746,148 97,118 599,022 1,746,148 Police Admin 2,330,161 193,865 1,196,661 2,330,161 Police Operations 12,450,598 602,847 5,886,310 12,450,598 Public Works 1,296,263 38,158 837,520 1,296,263 Rec Programs 1,358,009 59,807 413,345 1,358,009 Recreation 2,625,888 205,133 1,284,318 2,625,888 Streets 4,688,211 244,346 1,752,274 4,688,211 Tennis Center 458,162 27,983 181,468 458,162 Transfer Out 361,000 - 361,000 361,000 Expense Total 70,644,120 4,769,572 33,489,173 70,644,120 EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 143,994 825,945 3,588,393 143,994 Economic Stability Reserve - - Contingency 9,977,771 9,977,771 Benefit Payout 255,000 255,000 AVAILABLE FUND BALANCE 518,708 518,708 Year-End Projection to Approved: Mar FY2019 General Fund 7 FY19 Amended Budget CURRENT PERIOD YEAR TO DATE (W/ENCUMB) YEAR‐END PROJECTION BEGINNING FUND BALANCE 1,970,691$ 1,970,691$ Operating Revenue Electric Revenue 73,100,000 10,806,674 31,997,417 79,100,000 Interest 38,000 7,455 48,769 38,000 Other Revenue 5,243,546 658,080 2,041,891 5,243,546 Operating Revenue Total 78,381,546 11,472,209 34,088,077 84,381,546 Operating Expenditures CRR Credits (3,500,000) (88,669) (1,293,647) (3,500,000) Georgetown Utility Systems 19,053,784 1,643,205 9,762,216 18,882,979 Purchased Power 48,000,000 3,622,558 21,411,647 53,000,000 Transfer Out‐ROI 4,325,000 351,656 1,949,911 4,325,000 Operating Expenditures Total 67,878,784 5,528,750 31,830,127 72,707,979 Total Net Operations 10,502,762 5,943,459 2,257,950 11,673,567 Non‐Operating Revenue Grant Revenue 100,000 ‐ ‐ 100,000 Transfers in 95,787 ‐ 95,787 95,787 Non‐Operating Revenue Total 195,787 ‐ 95,787 195,787 Non‐Operating Expenditures CIP 4,017,007 211,593 2,314,857 3,983,007 CIS implentation ‐ ‐ 20,000 34,000 Interest Expense 1,386,781 ‐ 721,821 1,386,781 Debt Service 3,035,374 ‐ 350 3,035,374 Non‐Operating Expenditures Total 8,439,162 211,593 3,057,028 8,439,162 Total Net Non‐Operations (8,243,375) (211,593) (2,961,241) (8,243,375) EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 2,259,387 5,731,866 (703,291) 3,430,192 ENDING FUND BALANCE 4,230,078$ 5,400,883$ 90 Day Operational Contingency 4,082,999 4,082,999 Non‐Operational Contingency 147,079 147,079 AVAILABLE FUND BALANCE ‐ 1,170,805 Year‐End Projection to Approved: Mar FY2019 Electric Fund 8 FY2019 Budget CURRENT PERIOD YEAR TO DATE (W/ENCUMB) YEAR‐END PROJECTION BEGINNING FUND BALANCE 1,970,691 2,103,922 Operating Revenue Electric Revenue 73,100,000 2,368,208 31,311,530 79,100,000 Interest 38,000 6,601 55,370 38,000 Other Revenue 5,243,546 370,746 2,412,638 5,243,546 Transfer In 95,787 ‐ 95,787 95,787 Operating Revenue Total 78,477,333 2,745,555 33,875,325 84,477,333 Operating Expenditures CRR Credits (3,500,000) (8,763) (1,302,410) (3,000,000) Georgetown Utility Systems 19,053,783 750,974 10,439,259 19,337,779 Purchased Power 48,000,000 3,606,172 25,000,066 53,185,477 Transfer Out‐Interfund Transfers ‐ ‐ ‐ ‐ Transfer Out‐ROI 4,325,000 ‐ 2,361,911 4,325,000 Operating Expenditures Total 67,878,783 4,348,384 36,498,826 73,848,256 Total Net Operations 10,598,550 (1,602,828) (2,623,502) 10,629,077 Non‐Operating Revenue Bond Proceeds ‐ ‐ ‐ ‐ Grant Revenue 100,000 ‐ ‐ 100,000 Transfer In‐Other ‐ ‐ ‐ 548,104 Non‐Operating Revenue Total 100,000 ‐ ‐ 648,104 Non‐Operating Expenditures CIP 4,017,007 280,496 2,400,374 4,017,007 Interest Expense 1,386,781 ‐ 721,821 1,386,781 Debt Issuance Cost ‐ ‐ ‐ ‐ Debt Service 3,035,374 ‐ 350 3,035,374 Non‐Operating Expenditures Total 8,439,162 280,496 3,122,545 8,439,162 Total Net Non‐Operations (8,339,162) (280,496) (3,122,545) (7,791,058) EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 2,259,388 (1,883,324) (5,746,047) 2,838,019 ENDING FUND BALANCE 4,230,079 4,941,941 Contingency 4,082,999 4,082,999 Non‐Operational Contingency 147,079 147,079 AVAILABLE FUND BALANCE 0 711,862 Year‐End Projection to Approved: Apr FY2019 Electric Fund PRELIMINARY The preliminary April fund schedule has the most current year-end projections for revenues and expenses. These updates include the following: • The revenue impact of the Purchase Cost Adjustment (PCA) from February through September. • Recognize updated projections for purchased power and congestion revenue rights. • Recognize savings in operational expenses and vacant positions. • Recognize capital reimbursement revenue from the South Georgetown TIRZ. 9 APRROVED BUDGET CURRENT PERIOD YEAR TO DATE (W/ENCUMB) YEAR‐END PROJECTION BEGINNING FUND BALANCE 89,159,703 89,159,703 Operating Revenue Capital Recovery Fee 14,250,000 3,218,078 6,221,859 14,250,000 Interest 569,400 187,534 982,768 569,400 Irrigation Utility Revenue 301,557 22,868 72,939 301,557 Other Revenue 2,262,146 459,178 2,503,329 2,262,146 Raw Water Revenue 140,000 11,301 64,227 140,000 Transfer In, Debt 103,725 ‐ ‐ 103,725 Wastewater Utility Revenue 12,975,345 2,126,892 6,918,610 12,975,345 Water Utility Revenue 29,116,931 3,475,012 10,180,563 29,116,931 Operating Revenue Total 59,719,104 9,500,864 26,944,295 59,719,104 Operating Expenditures Irrigation 270,324 126 62,217 270,324 Transfer Out, Fleet/Joint Service/IT 245,000 ‐ 245,000 245,000 Transfer Out, General 275,000 68,750 137,500 275,000 Transfer Out, ROI 3,200,000 124,495 637,007 3,200,000 Transfer Out, Utilities 95,787 ‐ 95,787 95,787 Wastewater Distribution 904,415 43,200 389,176 904,415 Wastewater Plant Management 2,705,069 222,830 1,716,487 2,705,069 Water Administration 19,923,733 4,894,261 11,912,575 19,923,733 Water Distribution 2,707,265 173,082 1,083,519 2,707,265 Water Operations 4,157,528 312,808 1,990,808 4,157,528 Water Plant Management 2,948,733 126,930 1,360,465 2,948,733 Operating Expenditures Total 37,432,854 5,966,482 19,630,540 37,432,854 Total Net Operations 22,286,250 3,534,382 7,313,755 22,286,250 Non‐Operating Revenue Bond Proceeds ‐ ‐ ‐ ‐ Non‐Operating Revenue Total ‐ ‐ ‐ ‐ Non‐Operating Expenditures CIP 90 85,667,940 2,331,557 23,885,592 85,667,940 CIP 91 ‐ ‐ 63,857 ‐ Debt Service 6,250,111 ‐ 1,148,839 6,250,111 Non‐Operating Expenditures Total 91,918,051 2,331,557 25,098,288 91,918,051 Total Net Non‐Operations (91,918,051) (2,331,557) (25,098,288) (91,918,051) EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (69,631,801) 1,202,825 (17,784,533) (69,631,801) ENDING FUND BALANCE 19,527,902 19,527,902 Contingency 7,498,183 7,498,183 Non‐Operating Contingency 9,500,000 9,500,000 AVAILABLE FUND BALANCE 2,529,719 2,529,719 Year‐End Projection to Approved: Mar FY2019 Water Fund 10 APRROVED BUDGET CURRENT PERIOD YEAR TO DATE (W/ENCUMB) YEAR‐END PROJECTION BEGINNING FUND BALANCE 842,416 842,416 Revenue Gedco Admin/Contract Fee 238,622 19,885 119,311 238,622 Gtec Admin/Contract Fee 172,318 14,360 86,159 172,318 Interest 17,503 1,578 12,625 21,500 Other 136,153 12,889 89,412 136,153 Service Fees ‐ Airport 128,966 10,747 64,483 128,966 Service Fees ‐ Electric 4,615,524 384,627 2,307,762 4,615,524 Service Fees ‐ General 3,573,156 297,763 1,786,578 3,573,156 Service Fees ‐ Stormwater 1,020,427 85,036 510,213 1,020,427 Service Fees ‐ Water 7,966,284 663,857 3,983,142 7,966,284 VPID Admin/Contract Fee 15,924 1,327 7,962 15,924 Revenue Total 17,884,877 1,492,068 8,967,647 17,888,874 Expense Accounting 1,067,433 70,086 525,659 1,067,433 BIP 250,085 14,885 62,978 250,085 City Wide Hr 415,500 8,969 170,659 415,500 Conservation 766,699 38,923 275,763 766,699 Customer Care 4,701,266 525,659 2,692,374 4,701,266 Economic Development 635,768 41,715 281,765 635,768 Engineering 2,430,052 157,172 1,123,356 2,430,052 Engineering Support 1,147,160 70,776 573,527 1,147,160 Finance Administration 975,583 60,097 608,353 975,583 Gus Administration 1,476,541 123,495 682,983 1,476,541 Human Resources 1,003,190 76,880 480,612 1,003,190 In‐House Legal 1,038,782 74,821 453,773 1,038,782 Insurance & Legal 752,000 ‐ 600,110 752,000 Joint Svcs Con 598,775 66,844 367,241 598,775 Purchasing 811,459 53,205 335,143 811,459 Transfer Out 57,000 ‐ 57,000 57,000 Expense Total 18,127,293 1,383,526 9,291,296 18,127,294 EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (242,416) 108,542 (323,649) (238,419) Contingency 600,000 600,000 AVAILABLE FUND BALANCE 0 3,997 Joint Services Fund Year‐End Projection to Approved: Mar FY2019 11 APRROVED BUDGET CURRENT PERIOD YEAR TO DATE (W/ENCUMB) YEAR-END PROJECTION BEGINNING FUND BALANCE 131,914 131,914 Revenue Interest 10,000 260 1,147 10,000 Transfer In, General Fund - - - - Revenue Total 10,000 260 1,147 10,000 Expense Transfer Out, GCP - - - - Transfer Out, General Fund 5,000 - 5,000 5,000 Transfer Out, Joint Services - - - - Expense Total 5,000 - 5,000 5,000 EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 5,000 260 (3,853) 5,000 ENDING FUND BALANCE 136,914 136,914 Year-End Projection to Approved: Mar FY2019 Council Discretionary Fund 12 APRROVED BUDGET CURRENT PERIOD YEAR TO DATE (W/ENCUMB) YEAR-END PROJECTION BEGINNING FUND BALANCE 1,170,801 1,170,801 Revenue Hotel/Motel Occupancy Tax Revenues 1,350,000 70,777 435,909 1,350,000 Interest 5,000 2,336 10,292 20,000 Other 23,500 1,685 8,165 23,500 Poppy Festival 136,150 48,715 76,495 136,150 Revenue Total 1,514,650 123,512 530,861 1,529,650 Expense Operations 713,831 35,924 376,628 713,831 Personnel 369,492 27,970 180,609 369,492 Poppy Festival 165,200 15,610 23,779 165,200 Transfer to Facilities 49,507 4,126 24,753 49,507 Transfer to Fleet 5,048 421 2,524 5,048 Transfer to General Fund 21,783 - 21,783 21,783 Transfer to Information Technology 27,722 2,310 13,861 27,722 Expense Total 1,352,583 86,360 643,938 1,352,583 EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 162,067 37,152 (113,076) 177,067 ENDING FUND BALANCE 1,332,868 1,347,868 Contingency 271,189 271,189 Reserved for Capital 1,061,680 1,061,680 AVAILABLE FUND BALANCE (2) 14,998 Year-End Projection to Approved: Mar FY2019 Convention & Visitors Bureau Fund 13 APPROVED BUDGET CURRENT PERIOD YEAR YO DATE (W/ENCUMB) YEAR-END PROJECTION BEGINNING FUND BALANCE 1,062,941 1,062,941 - Operating Revenue Fuel and Terminal Sales 2,907,450 175,854 1,231,092 2,907,450 Interest and Other 80,260 2,937 22,500 80,260 Leases and Rentals 863,952 72,766 430,985 863,952 Operating Revenue Total 3,851,662 251,557 1,684,577 3,851,662 Operating Expenditures Debt Service 147,975 - 21,996 147,975 Operations-Fuel 2,400,000 122,268 2,235,620 2,400,000 Operations-Non Fuel 732,721 14,655 287,376 732,721 Personnel 417,348 24,754 144,146 417,348 Operating Expenditures Total 3,698,044 161,677 2,689,138 3,698,044 TOTAL NET OPERATIONS 153,618 89,880 (1,004,561) 153,618 Non-Operating Revenue Bond Proceeds 500,000 - - 500,000 Grants 40,000 - - 40,000 Non-Operating Revenue Total 540,000 - - 540,000 Non-Operating Expenditures Hangar Upgrades 75,000 4,400 19,442 75,000 Pavement Upgrades 15,000 - (19,054) 15,000 Runway Rehab 516,500 - - 516,500 Taxiway Edge Lighting 150,000 - - 150,000 Wildlife Management 35,000 7,200 14,751 35,000 Non-Operating Expenditure Total 791,500 11,600 15,140 791,500 TOTAL NET NON-OPERATIONS (251,500) (11,600) (15,140) (251,500) EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (97,882) 78,280 (1,019,701) (97,882) ENDING FUND BALANCE 965,059 965,059 RESERVES Contingency 264,442 264,442 Reserves Total 264,442 264,442 AVAILABLE FUND BALANCE 700,617 700,617 Airport Operations Fund For the Month Ended: Mar FY2019 14 APPROVED BUDGET CURRENT PERIOD YEAR TO DATE (W/ENCUMB) YEAR‐END PROJECTION BEGINNING FUND BALANCE 18,078,282 18,078,282 Operating Revenue Sales Tax 7,073,100 495,298 2,383,731 7,073,100 Interest 190,000 25,246 210,365 210,365 Operating Revenue Total 7,263,100 520,543 2,594,096 7,283,465 Operating Expenditure Administrative Support 391,697 32,575 195,570 391,697 Operating Expenditure Total 391,697 32,575 195,570 391,697 TOTAL NET OPERATIONS 6,871,403 487,969 2,398,526 6,891,768 Non‐Operating Revenue Debt Proceeds 7,200,000 ‐‐ 7,200,000 Non‐Operating Revenue Total 7,200,000 ‐‐ 7,200,000 Non‐Operating Expenditure Pecan Center Dr to Airport Rd (FY15)2,445,036 2,000 (334) 2,445,036 Arterial SE1:Inner Loop/SH130 7,200,000 ‐‐ 7,200,000 Rivery TIA Improvements 359,496 5,885 (11,986) 359,496 FM 971 / Fontana 63,102 10,966 ‐ 63,102 Rivery‐Extension Williams Dr to NW Blvd (FY16)730,635 6,800 460,784 730,635 IH 35 / HWY29 Intersection 606,653 ‐160,375 606,653 SW Bypass 2243 to IH35 128,144 ‐‐ 128,144 FM1460 Widening 500,783 ‐60 500,783 Wolf Ranch Pkwy Extension 283,350 ‐‐ 283,350 Mays St 4,500,000 ‐4 4,500,000 Available for Projects TBD 1,768,275 ‐‐ 1,768,275 SE Inner Loop Widening (Rock Ride ROW)900,000 ‐948,251 948,251 Debt Service 3,438,747 ‐521,942 3,438,747 Non‐Operating Expenditure Total 22,924,221 25,651 2,079,097 22,972,472 TOTAL NET NON‐OPERATIONS (15,724,221)(25,651)(2,079,097) (15,772,472) EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (8,852,818) 462,318 319,429 (8,880,704) ENDING FUND BALANCE 9,225,464 9,197,578 RESERVES Contingency 1,768,275 1,768,275 Reserves Total 1,768,275 1,768,275 AVAILABLE FUND BALANCE 7,457,189 7,429,303 Georgetown Transportation Enhancement Corporation Fund Year‐End Projection to Approved: Mar FY2019 15 APPROVED BUDGET CURRENT PERIOD YEAR TO DATE (W/ENCUMB) YEAR-END PROJECTION BEGINNING FUND BALANCE 6,853,073 6,853,073 OPERATING REVENUES Interest 40,300 15,608 85,241 40,300 Sales Tax 1,768,275 123,824 595,933 1,768,275 OPERATING REVENUES Total 1,808,575 139,432 681,174 1,808,575 OPERATING EXPENDITURES Joint Services Allocation 238,622 19,885 119,311 238,622 Miscellaneous Expense 50 - - 50 Promotional & Marketing Program 100,000 - 63,429 100,000 Special Services 30,000 - - 30,000 Travel & Training 500 - - 500 OPERATING EXPENDITURES Total 369,172 19,885 182,740 369,172 TOTAL NET OPERATIONS 1,439,403 119,547 498,434 1,439,403 NON-OPERATING EXPENDITURES Principal Reduction 80,568 - - 80,568 Debt Service 205,069 - 42,534 205,069 Interest Expense 23,157 - - 23,157 Atmos Energy 146,096 - - 146,096 DisperSol 50,000 30,000 30,000 50,000 Economic Development Projects -Undetermined 7,000,517 - - 7,000,517 Holt Cat 185,000 - - 185,000 Radiation Detection Company 150,000 - - 150,000 NON-OPERATING EXPENDITURES Total 7,840,407 30,000 72,534 7,840,407 TOTAL NET NON-OPERATIONS (7,840,407) (30,000) (72,534) (7,840,407) EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (6,401,004) 89,547 425,900 (6,401,004) ENDING FUND BALANCE 452,069 452,069 RESERVES Contingency 442,069 442,069 RESERVES Total 442,069 442,069 AVAILABLE FUND BALANCE 10,000 10,000 Georgetown Economic Development Corporation Fund Year-End Projection to Approved: Mar FY2019 16 Department Federal Grantor Pass-Through Agency Identifying Number COG Name/Purpose YTD Expenditures YTD Revenue Recognized Airport N/A Texas Department of Transportation-Aviation M1914GEOR RAMP Grant - Routine Airport Maintenance Program - - Airport Federal Aviation Administration Texas Department of Transportation-Aviation 16MPGRGTN Airport Master Plan Update - - Airport Federal Aviation Administration Texas Department of Transportation-Aviation 1814GRGTN Runway 18/36 Rehabilitation- Engineering - - Airport Federal Aviation Administration Texas Department of Transportation-Aviation 1814GEORG Runway 18/36 Rehabilitation-Construction - - Airport Federal Aviation Administration Texas Department of Transportation-Aviation 17WAGEORG Wildlife Hazard Assessment - - Fire US Department of Homeland Security Federal Emergency Management Agency EMW-2017-FH-00496 SAFER 72,505.33 54,378.99 Fire Federal Emergency Management Agency Texas Department of Public Safety - TDEM TEEX Tracy Ryan Deployment Urban Search and Rescue (US&R) 13,411.76 13,411.76 Gus - Electric N/A Bloomberg Philanthropies 2017 Mayors Challenge 2,100.00 - Library Institute of Museum & Library Services Texas State Library & Archives Commission LS-00-18-0044-18 TSL Resource Coordinator - 3rd year (Patrick Lloyd) 35,760.19 35,760.19 Planning US Department of Housing & Urban Development Williamson County B-17-UC-48-0502 CDBG Sidewalks and Ramps along 17th St 1,250.00 1,250.00 Police Bureau of Justice Assistance N/A KXPIIIA Bullet Proof Vests - Supply Police with new vests 3,560.85 1,780.44 Public Works Dept. of Transportation /Federal Highway Administration Texas Department of Transportation CSJ-0914-05-187 Highway Planning & Construction (Austin Ave Bridge) 72,793.51 - Division Grantor Status Gus - Electric Department of Energy (DOE)Battery Storage Project Under DOE Review Planning Williamson County/CDBG Home Repair Applied - Council 5/14; due 5/22 to County Planning Williamson County/CDBG Scenic Dr Sidewalk Applied - Council 5/14; due 5/22 to County Parks Texas Parks and Wildlife Department (TPWD) Recreation San Gabriel Trails TxDOT Review CITY OF GEORGETOWN Grant/Federal Funding Report as of March 31 2019 COG Name/Purpose Active Applications Pending Award 53 CIP Quarterly Report - Q2 FY2019 Budget Year-todate (W/Encum)Remaining Balance AIRPORT OPERATIONS 600-5-0636-52-140 DESIGN RUNWAY REHAB 516,500 - 516,500 600-5-0636-52-141 HANGAR UPGRADES 75,000 19,442 55,558 600-5-0636-52-142 PAVEMENT UPGRADES 15,000 (19,054) 34,054 600-9-0636-52-144 TAXIWAY EDGE LIGHTING 150,000 - 150,000 CDBG GRANTS 215-9-0880-90-003 17TH STREET 206,824 30,040 176,784 215-9-0880-90-004 MAPLE STREET 80,784 - 80,784 DOWNTOWN TIRZ 293-9-0602-90-002 PARKING IMPROVEMENTS 106,902 - 106,902 293-9-0602-90-003 DTWN LANDSPING & PUBLC ART 45,000 43,202 1,798 293-9-0602-90-007 GRACE HERITAGE PLAZA 139,100 - 139,100 ECO DEVO SALES TAX 420-9-0980-90-001 ECONOMIC DEVEL PROJECTS 7,000,517 - 7,000,517 420-9-0980-90-022 RADIATION DETECTION COMPANY 150,000 - 150,000 420-9-0980-90-026 DISPERSOL TECHNOLOGIES, LLC 50,000 30,000 20,000 420-9-0980-90-030 HOLT CAT 185,000 - 185,000 420-9-0980-90-031 ATMOS ENERGY 146,096 - 146,096 ELECTRIC SERVICES 610-9-0580-90-134 HWY 195 - 903 (903) 610-9-0580-90-137 RONALD REAGAN - 303 (303) 610-9-0580-90-142 DOWNTOWN WEST 227,536 138,226 89,310 610-9-0580-90-143 SHELL ROAD FEEDERS - 10,349 (10,349) 610-9-0580-90-256 GEO. EAST T2 VOLTAGE CHANGE 23,757 5,350 18,407 610-9-0580-90-260 DB WOOD_SH29 INTERSECTION 145,445 40,000 105,445 610-9-0580-90-263 LEANDER RD_IH35 INTERSECTION 10,000 - 10,000 610-9-0580-90-264 NORTHWEST BLVD WIDENING - 20,000 (20,000) 610-9-0580-90-266 RIVERY EXTENSION 49,269 48,732 537 610-9-0580-90-267 UNIVERSITY_MAYS WIDENING 154,000 - 154,000 610-9-0580-90-310 POWER QUALITY IMPROVEMENTS 40,000 - 40,000 610-9-0580-90-320 SECTIONALIZATION IMPROVEMENTS 50,000 - 50,000 610-9-0580-90-410 NEW DEVELOPMENT PROJECTS 3,023,000 1,874,769 1,148,231 610-9-0580-90-430 STREET LIGHTING 44,000 226 43,774 610-9-0580-90-500 CONSULTANT ENGINEERING 150,000 150,000 - 610-9-0580-90-701 FIBER OPTIC 50,000 26,000 24,000 610-9-0580-90-702 FIBER TO SIGNAL LIGHTS 50,000 - 50,000 610-9-0580-91-105 CIS SYSTEM - 20,000 (20,000) GATEWAY TIRZ 295-9-0602-90-001 CAPITAL IMPROVEMENTS 120,000 - 120,000 GENERAL CAPITAL PROJECTS 120-9-0280-90-031 NEIGHBORHOOD PARK DEVELOPMENT 250,000 - 250,000 120-9-0280-90-035 VFW PARK 175,000 152,328 22,672 120-9-0280-90-045 SAN GABRIEL PARK IMPROVEMENT 834,288 440,847 393,441 120-9-0280-90-046 GAREY PARK 370,000 21,685 348,315 120-9-0280-90-047 SIDEWALKS 142,858 - 142,858 120-9-0280-90-051 LIBRARY CANOPY 155,000 75,934 79,066 120-9-0280-90-060 ADA PARKS 450,405 - 450,405 120-9-0280-90-066 KATY CROSSING TRAIL 240,313 - 240,313 120-9-0380-90-048 FIRE STATION ASSESSMENTS 30,000 - 30,000 120-9-0380-90-080 DOWNTOWN PARKING GARAGE 5,000,000 62,950 4,937,050 54 CIP Quarterly Report - Q2 FY2019 Budget Year-todate (W/Encum)Remaining Balance 120-9-0380-90-159 FIRE STATION 7 6,471,601 5,293,780 1,177,821 120-9-0380-90-160 EOC SIREN SYSTEM 6,631 - 6,631 120-9-0380-90-163 FIRE STATION 6 5,499,725 4,776,377 723,349 120-9-0380-90-166 DATA CENTER - PSOTC 100,676 - 100,676 120-9-0380-90-168 TRANSFER STATION/LANDFILL 811,337 - 811,337 120-9-0380-90-169 ERP PROJECT 5,166,384 5,073,262 93,122 120-9-0380-90-170 FACILITY EFFICIENCY STUDY 78,734 91,234 (12,500) 120-9-0381-90-022 RADIO REPLACEMENT PUB SAFETY 500,000 - 500,000 120-9-0381-91-016 FIRE SCBA 290,000 - 290,000 120-9-0381-91-022 RADIO REPLACEMENT 500,000 - 500,000 120-9-0680-90-008 CVB REDESIGN 175,000 - 175,000 120-9-0680-90-012 DOWNTOWN WEST 481,831 484,360 (2,529) 120-9-0680-90-013 DOWNTOWN WEST SIGNAGE 125,000 - 125,000 120-9-0680-90-014 DOWNTOWN PARKING EXPANSION 600,000 11,595 588,405 120-9-0880-90-038 LEANDER RD(NORWOOD-SWBYPASS)2,000,000 - 2,000,000 120-9-0880-90-041 BLUE HOLE PARKING LOT/SIDEWALK 100,000 - 100,000 120-9-0880-90-050 NB FRONTAGE RD 150,000 3 149,997 120-9-0880-90-054 AUSTIN AVENUE BRIDGE 88,132 5,139 82,993 120-9-0880-90-065 SOUTHWESTERN BLVD 1,550,000 - 1,550,000 120-9-0880-90-066 SHELL ROAD SIDEWALK 180,000 - 180,000 120-9-0880-90-086 SW BYPASS LEANDER TO I35 - (1,000) 1,000 120-9-0880-90-087 FM 971 3,900,000 18,050 3,881,950 120-9-0880-90-088 FM 1460 550,000 - 550,000 120-9-0880-90-091 SW BYPASS/WOLF RANCH PKWY 1,717,771 - 1,717,771 120-9-0880-90-092 SOUTHEAST INNER LOOP 1,200,000 472 1,199,528 120-9-0880-90-105 NORTHWEST BLVD BRIDGE 10,307,612 2,063,898 8,243,714 120-9-0880-90-106 LEANDER RD(RIVER RIDGE/SW BYPA 1,550,000 - 1,550,000 120-9-0880-90-107 ROCK ST-6TH TO 9TH ST 273,000 - 273,000 120-9-0880-90-108 RIVERY EXTENSION - 25,500 (25,500) 120-9-0880-90-109 SE INNER LOOP ROCKRIDE IMPRV 115,000 - 115,000 120-9-0880-91-001 10TH ST (MAIN-ROCK)168,880 168,880 - 120-9-0880-91-002 11TH ST. (MAIN-ROCK)236,130 236,130 - 120-9-0880-91-006 AUSTIN AVE. (SH29-FM2243)492,300 494,445 (2,145) 120-9-0880-91-008 OLD TOWN NORTHEAST 826,445 917 825,528 120-9-0880-91-009 PH 1 SIGNAL & CURB RAMP IMPR.308,837 - 308,837 STORMWATER CAPITAL IMPROVEMENT 640-9-0880-90-005 CURB & GUTTER 527,504 117,365 410,139 640-9-0880-90-020 STORMWATER INFASTRUCTURE 200,000 41,100 158,900 640-9-0880-90-040 SPOILS FACILITY 100,000 - 100,000 640-9-0880-90-064 POND REHAB-2ND AND ROCK 450,000 21,205 428,795 640-9-0880-90-078 18TH AND HUTTO DRAINAGE 184,367 25,544 158,823 640-9-0880-90-079 2ND AND ROCK POND - 894 (894) 640-9-0880-90-081 VILLAGE PID INLET 75,000 - 75,000 STREET TAX SRF 203-9-0880-90-071 STREET MAINTENANCE 5,443,616 189,277 5,254,339 WATER SERVICES 660-9-0580-90-071 TANK REHAB PROJECTS 480,000 55,455 424,545 660-9-0580-90-076 DB WOOD/ PASTOR 24 DEDICATED 5,285,667 2,951,113 2,334,554 660-9-0580-90-077 RABBIT HILL WATERLINE 1,050,000 - 1,050,000 660-9-0580-90-078 RONALD REAGAN/DANIELS MOUNTAIN 6,425,959 6,177,625 248,334 660-9-0580-90-079 ROCK SUPPLY LINE 1,100,000 - 1,100,000 660-9-0580-90-080 RADIO REPLACEMENT 153,670 - 153,670 660-9-0580-90-097 SUN CITY ELEVATED STORAGE TANK - 2,432 (2,432) 55 CIP Quarterly Report - Q2 FY2019 Budget Year-todate (W/Encum)Remaining Balance 660-9-0580-90-125 SHELL ROAD WATER LINE 6,033,651 - 6,033,651 660-9-0580-90-166 LEANDER INTERCONNECT 225,000 - 225,000 660-9-0580-90-167 WEST LOOP (H-1A)2,119,000 - 2,119,000 660-9-0580-90-168 LWTP RAW WATER INTAKE REHAB 13,450,000 (7,319) 13,457,319 660-9-0580-90-170 CR 255 (WD14-2)1,493,963 - 1,493,963 660-9-0580-90-171 DOMEL PS IMPROVEMENTS (216,892) (216,892) - 660-9-0580-90-175 BRAUN EST 4,350,731 3,528,453 822,278 660-9-0580-90-176 MISC. LINE UPGRADES 393,899 - 393,899 660-9-0580-90-177 PARK WTP CLEARWELL 170,000 - 170,000 660-9-0580-90-178 S. LAKE WTP 2018 6,950,260 3,179,544 3,770,716 660-9-0580-90-179 SW BYPASS WATER H24-1 500,000 - 500,000 660-9-0580-90-180 TANK REHABILITATION 480,000 - 480,000 660-9-0580-90-200 WATER MAINS 2,208,325 729,716 1,478,609 660-9-0580-91-102 ASSET MANAGEMENT - 26,203 (26,203) 660-9-0580-91-105 CIS SYSTEM - 37,653 (37,653) 660-9-0581-90-051 PECAN BRANCH PH 2 - 424 (424) 660-9-0581-90-160 BERRY CREEK INTER (BC 4-6)20,714,161 5,614,279 15,099,882 660-9-0581-90-162 BERRY CREEK INTER (BC 1-3)- 677 (677) 660-9-0581-90-163 SAN GABRIEL BELT PRESS 1,900,932 58,500 1,842,432 660-9-0581-90-164 PARK LIFT STATION & FORCE MAIN 3,585,740 11,400 3,574,340 660-9-0581-90-166 EARZ 2,000,000 754,265 1,245,735 660-9-0581-90-167 SAN GABRIEL INTER SGI-2 2,500,000 1,037,700 1,462,300 660-9-0581-90-200 WW INTERCEPTORS 613,874 5,385 608,489 660-9-0581-90-210 WWTP UPGRADE/EXP 1,150,000 - 1,150,000 660-9-0581-90-220 LIFT STATION UPGRADE 550,000 2,835 547,165 Grand Total 159,821,047 46,280,105 113,540,941 56 Unfunded Liability & Commitments Financial Impact/Notes Status Updates - 12/31/18 Status Updates - 3/31/19 Cemetery Special Revenue Fund Currently cemetery operations are self-funded through plot sales of approximately $50K per year. The cemetery is managed through Parks Administration. In 2015, Council elected to reserve $75,000 annually for future costs associated with maintaining the property. The General Fund has made this transfer in since FY 2016. The columbarium project is complete. Finance and Parks staff continue to evaluate cemetery related fees, costs, and options to fund the perpetual reserve. Continue to request $75,000 annual reserves for future maintenance costs. Unfunded Actuarial Accrued Liability (UAAL) Recognizes the outstanding liability for the City’s employee retirement plan through TMRS. The City contributes monthly to fund the UAAL, based on an annual percentage of payroll. Actual % of payroll costs is recognized within each fund. The UAAL is provided by TMRS and lags one year. No change. Updated once annually. As of 12/31/2017, the net pension liability (NPL) is $17.3 million and is 87.8% funded. The 2019 TMRS total combined contribution rate is 12.36%. Other Post Employee Benefits (OPEB) While the City has no obligation to offer additional retiree benefits, retirees are eligible to participate in the City’s health insurance program. That ability represents a subsidy that impacts health insurance costs to the City. Retirees pay their monthly premiums to the self insurance fund, which then processes their health insurance claims. No change. Updated once annually. This is an actuarial calculation based on current and future employees on future City health insurance costs and Life insurance benefits, which has numerous and complex factors in its calculation. Retirees pay their own premiums, and thus the liability is considered “pay as you go”. With additional employees being added, potential future retiree impacts increase. The 2018 current OPEB liability is $2,182,012 for healthcare benefits and $1,091,292 for Life insurance benefits. Compensated Absence Future costs associated with benefits such as vacation, and sick leave for City employees. Compensated Absence is accrued annually to each proprietary fund type on a GAAP basis and accounted for on the balance sheet of each fund. For governmental funds (and for budgetary basis), the expense is recognized when due and payable. In 2018, total citywide compensated absence is $6.9M, of that $5.8M is considered unfunded in the General Fund. The City's Fiscal and Budgetary Policy state the payout reserve will equal 15% of the liability in the Governmental Funds. The FY 2020 budget process should consider increasing the payout reserve for the Governmental Funds to be in compliance with the policy. The current amount of the Benefit Payout Reserve is $255,000. For FY 2020, it needs to be increased to approximately $340,000. Electric Fund Rate Stabilization Reserve Intended to mitigate potential rate impacts due to increased fuel costs or other external factors. The RSR is maintained within the Electric Fund. The FY2019 Electric Fund budget was amended on first reading in December 2018 and second reading in January 2019. The amendment included recognizing additional revenue by leaving the current Power Cost Adjustment in place, reducing operating expenditures, reducing bond proceeds and reducing capital expenditures. These changes restore the 90 day contingency reserve on a budget basis. Staff continue vetting and implementing options to improve the Electric Fund reserves. The PCA was increased in February 2019 to recover power costs and maintain the 90 day contingency reserve. In order to build the rate stabilization reserve, the PCA will need to increase again. March 31, 2019 Long-term Commitments, Reservations, and Other Unfunded Liabilities CITY OF GEORGETOWN 57 Unfunded Liability & Commitments Financial Impact/Notes Status Updates - 12/31/18 Status Updates - 3/31/19 Airport Maintenance Fund on-going maintenance of the Airport grounds, runways and taxi ways. Terminal and Tower included in Facilities ISF. An Airport Master Plan was developed to address long term capital maintenance project prioritization. The Airport Fund continues to have a positive balance. The Wildlife Hazard Assessment is complete and undergoing final review. The Texas Transportation Commission approved the Runway 18-36 rehabilitation project, including grooving the new pavement, overlay of additional shoulder pavement, and installation of lighting infrastructure in preparation for future lighting projects. Construction is expected to start February 2019 and end May 2019. Currently in the process of interviewing and hiring a new Airport Manager. The Airport Fund continues to have a positive balance. The Wildlife Hazard Assessment is complete and undergoing final review by TxDOT. The Texas Transportation Commission approved the Runway 18-36 rehabilitation project, including grooving the new pavement, overlay of additional shoulder pavement, and installation of lighting infrastructure in preparation for future lighting projects. Construction started and expected to end May 2019. New Airport Manager starts May 13,2019. Americans with Disabilities Act (ADA) Compliance Needs As facilities are built or repurposed, meeting ADA compliance will be included in Project Costs. Funding for program expansion will be needed (General Fund sources). The City has an adopted policy, as required by Federal Law, that it will make reasonable accommodations and modifications to ensure that people with disabilities have an equal opportunity to enjoy its programs, services, and activities. The City does not maintain a reserve for these modifications. The City is continuing the work on the CIP ADA projects. The ADA transition plan for Parks includes $150,000 per year for FY2020-FY2022. Sidewalk Maintenance & Masterplan Currently, new sidewalks are built as development occurs. Repairs are funded as needed or if funding is available, when major roads are repaired. Useful life of a sidewalk is estimated at 40 to 50 years. The largest revenue source comes from the City’s General Fund, but there has been some debt funding as well. Old Town NE Sidewalk – Approval has been received from TCEQ. Design is 95% completed. One owner has signed the easement. Five easements remain and are being worked on. Austin Ave Sidewalks (Leander to Hwy 29) – Contract awarded to Patin Construction. Pre- construction meeting to be held, contractor plans to start 1st part of February. Debt funded projects: Old Town NE Sidewalk – Approval has been received from TCEQ. Design is completed. All easements have been secured. We will start advertising May 5th 2019 and open bids in late May. Plan to take to GTAB on June 14th 2019 followed by Council. Austin Ave Sidewalks (Leander to Hwy 29) – Patin Construction has installed Erosion Controls and Tree protection. Construction will commence in late April 2019. Estimated completion is late August. Park Equipment Maintenance & Replacement Over the past 5 years, funding for Park Maintenance and Replacement has increased. $200K transfer from General Fund included in FY2018 budget. Staff has listed all assets & developed replacement schedule funded by the General Fund. FY19 projects are currently in the planning stages. FY19 projects are underway. Projects identified in the the FY20 budget total $394,000, which if completed will require an increase in the FY20 transfer. Some of the projects identified are at Booty's Park, Raintree Park, University Park, the Recreation Center, along with a few others. Radio Equipment Replacement Communication system consisting of 500 on-body and in- vehicle radios for Police, Fire, parks and utilities. Replacement radios are compatible with newer technology. Staff will be meeting with the vendor for pricing and will be presented to Council in the next few months. Staff is meeting with Motorola on 4/26/19, the purchases will be presented to GGAF on 5/29/19, and taken to Council on 6/11/19. FY2019 is the 3rd year of the replacement project, with $500,000 debt funded for the replacement. The FY2020 proposed budget amount is $129,000 and FY2021 is $234,278. 58 Unfunded Liability & Commitments Financial Impact/Notes Status Updates - 12/31/18 Status Updates - 3/31/19 Street Maintenance The City funds street maintenance in the General Fund, supplemented by a 1/8th Street Sales Tax special revenue fund. In 2017 and 2018, the Council and GTAB reviewed various methods for enhanced street maintenance and costs. Direction from Council is to use high performance surface seals and pavement wearing courses and begin programmatically addressing the street network's deferred maintenance backlog, creating a need for approximately $2 million more per year for street maintenance. The 2018 Pavement Condition Survey project was completed and local roads were prioritized for bidding. Due to weather delays, the entire program was not able to be completed, but will resume work in the Spring 2019 along with other projects selected for maintenance. Planned and programed Street Maintenance is currently coordinated and completed by Systems Engineering through contracting services. Public Works Operations staff continue to work on spot repairs and general street maintenance. 2019 Street Maintenance projects scheduled include 47 lane miles of local roads to be treated with High Performance Sealant. Pavement rehabilitation projects using Hot In Place Asphalt Recycling total 25.5 lane mile. 59