Loading...
HomeMy WebLinkAboutAgenda_GTAB_10.08.2021Notice of Meeting for the Georgetown Transportation Adv isory B oard of the City of Georgetown October 8, 2021 at 10:00 AM at Georgetown P ublic Library-F riends Room T he C ity of G eorgetown is committed to compliance with the Americans with Disabilities Act (ADA). If you require as s is tance in partic ipating at a public meeting due to a disability, as defined under the ADA, reas onable as s is tance, adaptations , or ac commodations will be provided upon request. P leas e c ontact the C ity S ec retary's O ffic e, at leas t three (3) days prior to the sc heduled meeting date, at (512) 930-3652 or C ity Hall at 808 Martin Luther King Jr. S treet, G eorgetown, T X 78626 for additional information; T T Y users route through R elay Texas at 711. Regular Session (T his R egular S es s ion may, at any time, be rec es s ed to c onvene an Exec utive S es s ion for any purpose authorized by the O pen Meetings Act, Texas G overnment C ode 551.) A P ublic Wishing to Address the Board O n a subject that is posted on this agenda, please fill out a speaker regis tration form whic h can be found on the table at the entrance to the Board Meeting. C learly print your name and the letter of the item on whic h you wis h to s peak and pres ent it to the S taff Liais on, prior to the start of the meeting. You will be called forward to s peak when the Board c onsiders that item. O nly persons who have delivered the speaker form prior to the meeting being called to order may speak. O n a subject not posted on the agenda: P ers ons may add an item to a future R egular sc heduled Board agenda by filing a written reques t with the S taff Liaison no later than one week prior to the Board meeting. T he request mus t inc lude the speaker’s name and the spec ific topic to be addres s ed with sufficient information to inform the board and the public. Only those persons who have submitted a timely request will be allowed to speak. P lease s end comments to G TAB Board Liais on, Danielle Dutra at danielle.dutra@georgetown.org. B C all to O rder - Board C hair C Introduc tion of Visitors - Board C hair D S eptember 2021 F inancial O verview of Airport F und-Nathan P arras , Assistant F inanc e Direc tor E O ctober 2021 G TAB Updates - Wes ley Wright, P.E., S ys tems Engineering Director / C hris P ous s on, C I P Manager. F Airport Monthly R eport – Eric Johns on, P ublic Works Direc tor L egislativ e Regular Agenda G C ons ideration and possible action to approve the S eptember 10, 2021 minutes of the G eorgetown Trans portation Advis ory Board. -- Danielle Dutra, Board Liais on H C ons ideration and possible action to recommend approval of Task O rder KPA-22-011 for professional engineering design s ervic es for F Y22 S treet Maintenanc e, S idewalks , and C urb and G utter improvements with Kasberg P atrick & As s ociates of G eorgetown, Texas in the amount of $713,250.00 -- Page 1 of 93 Wes ley Wright, P E, S ys tems Engineering Director/C hris P ous s on, C I P Manager I C ons ideration and possible action to award a c ontract to DeNucc i C ons tructors , LLC of Aus tin, Texas for the C ons truction of the Williams Drive @ Lakeway Inters ection improvements in the amount of $1,448,918.00 -- Wes ley Wright, P.E., S ys tems Engineering Director / C hris P ous s on, C I P Manager J C ons ideration and possible action to approve the purchas e of a 2021 John Deere 325G track loader – Eric Johnson, P ublic Works Director Adjournment Ce rtificate of Posting I, R obyn Densmore, C ity S ecretary for the C ity of G eorgetown, Texas, do hereby c ertify that this Notic e of Meeting was posted at C ity Hall, 808 Martin Luther King Jr. S treet, G eorgetown, T X 78626, a plac e readily acc es s ible to the general public as required by law, on the _____ day of _________________, 2021, at __________, and remained s o posted for at leas t 72 c ontinuous hours prec eding the s cheduled time of said meeting. __________________________________ R obyn Dens more, C ity S ec retary Page 2 of 93 City of Georgetown, Texas Transportation Advisory Board October 8, 2021 S UB J E C T: S eptember 2021 F inanc ial O verview of Airport F und-Nathan P arras, As s is tant F inance Director IT E M S UMMARY: S eptember 2021 F inanc ial O verview of Airport F und -Nathan P arras , Assistant F inanc e Direc tor F IN AN C IAL IMPAC T: . S UB MIT T E D B Y: Nathan P arras , Assistant F inanc e Direc tor AT TAC H ME N T S: Description Type Financial Report Backup Material Financial Presentation Pres entation Financial Summary Backup Material Airport Budget FY22-Powerpoint Presentation Pres entation FY2022 Airport Budget Detail Backup Material Page 3 of 93 F GTAB FINANCIAL REPORT AS OF SEPTEMBER 30, 2021 COG - Airport Operations Financial Report Period: Sep-21 Budget Period FY2021 Sep-21 YTD Actuals w/Encumbrances Variance % of Budget Projections 2021 Variance Fav/(Unfav)% of Projection Beginning Fund Balance 1,463,499 1,463,499 - 100.00%1,463,499 - 100.00% Operating Revenue 40001:Property Taxes 40,000 - - (40,000) 0.00%57,000 (57,000) 0.00% 42001:Interest Income 3,000 - 3,429 429 114.31%3,129 300 109.60% 43606:Airport Charges 3,908,500 321,023 3,821,039 (87,461) 97.76%3,754,800 66,239 101.76% Operating Revenue Total 3,951,500 321,023 3,824,468 (127,032) 96.79%3,814,930 9,539 100.25% Operating Expense Personnel 464,472 40,871 430,953 33,519 92.78%465,860 34,907 92.51% Operations 3,559,192 161,259 4,234,390 (675,198) 118.97%3,416,469 (817,921) 123.94% Operating Capital 404,067 - 19,839 384,228 4.91%105,255 85,416 18.85% Operating Expense Total 4,427,731 202,130 4,685,182 (257,451) 105.81%3,987,583 (697,599) 117.49% Total Net Operations (476,231) 118,893 (860,714) (384,483) 180.73%(172,654) (688,060) 498.52% Non-Operating Revenue 44001:Grant Revenue - 50,000 206,980 206,980 0.00%157,000 49,980 131.83% 45001:Misc Revenue 5,000 - 2,250 (2,750) 45.00%1,000 1,250 225.00% 46001:Bond Proceeds 700,000 - 650,000 (50,000) 92.86%650,000 - 100.00% 46002:Bond Premium - - 64,186 64,186 0.00%64,186 0 100.00% Non-Operating Revenue Total 705,000 50,000 923,417 218,417 130.98%872,186 51,231 105.87% Non-Operating Expense CIP Expense 750,000 - - 750,000 0.00%750,000 750,000 0.00% Debt Service 158,931 - 147,520 11,411 92.82%158,931 11,411 92.82% Non-Operating Expense Total 908,931 - 147,520 761,411 16.23%908,931 761,411 16.23% Net Non-Operations (203,931) 50,000 775,897 979,827 -380.47%(36,745) 812,642 -2111.58% Excess (Deficiency) of Total Revenue over Total Requirements (680,162) 168,893 (84,817) 595,345 12.47%(209,398) 124,581 40.51% Ending Fund Balance 783,337 168,893 1,378,682 595,345 176.00%1,254,101 124,581 109.93% Reserves Contingency Reserves 332,917 332,917 100%332,917 - 100.00% Debt Service Reserve 141,478 141,478 100%141,478 - 100.00% Reserves Total 474,395 474,395 100%474,395 - 100.00% Available Fund Balance 308,942 168,893 904,287 595,345 292.70%779,706 124,581 115.98% YTD Actuals Budget Vs. Actuals Year-End: Projections Vs. Actuals Page 4 of 93 Georgetown Transportation Advisory Board FY2021 Financial Summary: September 21Page 5 of 93 FY2021 FINANCIAL SUMMARY: GTAB Airport Revenue •FY2021 Revenue Budget •Revenue Budget Sources •FY2021 Revenue Budget totals $4,656,500 •Operating Revenue •Airport Charges: •Fuel Sales 64%, including Midyear Budget Amendment addition of $500,000 •Hangar Rentals 10% •Facility Leases 5% •Non-Operating Revenue •Bond Proceeds $700,000 1% 0% 82% 0% 17%40001:Property Taxes 42001:Interest Income 43606:Airport Charges 45001:Misc Revenue 46001:Bond Proceeds Page 6 of 93 FY2021 FINANCIAL SUMMARY: GTAB Airport Operating Revenue COG - Airport Operations Financial Report Period: Sep-21 Budget FY2021 Sep-20 Sep-21 Variance % Variance Variance from Budget % of Budget Projections 2021 Variance Fav/(Unfav)% of Projection Operating Revenue 40001:RC0125 Property Taxes 40,000 57,018 - (57,018) -100.00%(40,000) 0.00%57,000 (57,000) 0.00% 42001:Interest Income:RC0000 - 3 - (3) -100.00%- 0.00%- - 0.00% 42001:RC0008 Allocated Interest 2,500 17,646 3,389 (14,257) -80.80%889 135.55%3,100 288 109.30% 42001:RC0013 Bond Interest 500 608 40 (567) -93.34%(460) 8.10%28 12 142.23% 43606:RC0047 Facility Leases - Airport 230,000 243,595 244,464 869 0.36%14,464 106.29%244,000 464 100.19% 43606:RC0057 Fuel Sales 3,000,000 2,300,938 2,824,989 524,051 22.78%(175,011) 94.17%2,761,200 63,788 102.31% 43606:RC0066 Hangar Rentals 475,000 465,246 467,035 1,789 0.38%(7,965) 98.32%468,000 (965) 99.79% 43606:RC0084 Land Leases 165,000 173,103 232,408 59,305 34.26%67,408 140.85%232,000 409 100.18% 43606:RC0156 Storage Rentals 4,500 5,543 9,874 4,331 78.13%5,374 219.43%7,500 2,374 131.65% 43606:RC0177 Terminal Sales 2,000 2,611 2,432 (179) -6.87%432 121.59%2,100 332 115.78% 43606:RC0180 Tie Down Revenue 32,000 36,105 39,838 3,732 10.34%7,838 124.49%40,000 (163) 99.59% Operating Revenue Total 3,951,500 3,302,416 3,824,468 522,053 15.81%(127,032) 96.79%3,814,930 9,539 100.25% YTD Comparison YTD Budget Comparison Year End: Projections Vs Actuals Page 7 of 93 FY2021 FINANCIAL SUMMARY: GTAB Airport Operating Revenue •Operating Revenue •Fuel revenue total 75.92% of the operating revenue budget, or $3.0 million. •Amended fuel revenue by $500,000 as part of the mid-year budget amendment •Year-to-date fuel revenue totals $2.82 million, 94.17% of budget •FY2021 year-to-date fuel revenue are 22.78% more than FY2020 year-to-date collections 22.78% 2,824,989 Fuel Sales K 500K 1.0M 1.5M 2.0M 2.5M 3.0M Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep FY2020 FY2021 Page 8 of 93 FY2021 FINANCIAL SUMMARY: GTAB Airport Expenses •FY2021 Expense Budget •Expense Budget Sources •FY2021 Expense Budget totals $5,336,662 •Operating Expense •Personnel 9% •Operations 67%, including Midyear Budget Amendment increase of $500,000 •Operating Capital 8% •Non-Operating Expense •CIP Expense 14% •$750,000 Airport Maintenance Facility •Debt Service 3% 9% 65% 7% 16% 3%Personnel Operations Operating Capital CIP Expense Debt Service Page 9 of 93 FY2021 FINANCIAL SUMMARY: GTAB Airport Operating Expenses COG - Airport Operations Financial Report Period: Sep-21 Budget FY2021 YTD Actuals w/Encumbrances: Sep-20 YTD Actuals w/Encumbrances: Sep-21 Variance % Variance Variance from Budget % of Budget Projections 2021 Variance Fav/(Unfav) % of Projection Operating Expense Personnel 464,472 433,817 430,953 2,863 -0.66%33,519 92.78%465,860 34,907 92.51% Operations 3,559,192 928,431 4,234,390 (3,305,958) 356.08%(675,198) 118.97%3,416,469 (817,921) 123.94% Operating Capital 404,067 199,320 19,839 179,481 -90.05%384,228 4.91%105,255 85,416 18.85% Operating Expense Total 4,427,731 1,561,568 4,685,182 (3,123,614) 200.03%(257,451) 105.81%3,987,583 (697,599) 117.49% YTD Actuals w/Encumbrances Comparison YTD Budget Comparison Year End: Projections Vs Actuals Page 10 of 93 FY2021 FINANCIAL SUMMARY: GTAB Airport Operating Expense •Operating Expense –Aviation Fuel •Aviation Fuel expense totals 59% of operating expense, equal to a budget of $2.6 million •Aviation Fuel actuals total $2.12 million. 2,824,989 2,123,401 Fuel Sales to Fuel Expenses 150K 301K 451K 583K 713K 958K 1.2M 1.3M 1.6M 1.8M 2.0M 2.1M2.0M 1.8M 1.7M 1.5M 1.4M 1.2M 965K 808K 559K 347K 103K K K 500K 1.0M 1.5M 2.0M 2.5M 3.0M 01) Oct 02) Nov 03) Dec 04) Jan 05) Feb 06) Mar 07) Apr 08) May 09) Jun 10) Jul 11) Aug 12) Sep Actuals Encumbrances 43606:RC0057 Fuel Sales Page 11 of 93 FY2021 FINANCIAL SUMMARY: GTAB Questions Page 12 of 93 F GTAB MONTHLY REPORT AS OF SEPTEMBER 30, 2021 Operating revenues include fuel sales, leases, and all other revenue. The operating revenue budget totals $3,951,500. This includes recognizing the Midyear Budget Amendment increasing fuel sales by $500,000. Year-to-date operating revenue totals $3,824,468, or 96.79% of the operating revenue budget. Fuel is the largest revenue stream in the fund and represents $3,000,000, or 75.92% of budgeted operating revenues. Through the period, fuel sales total $2,824,989, or 94.17% the fuel budget. Year-to-date fuel sales are up by 22.78% relevant to the same time last fiscal year. Fuel sales are tracked every month by staff and are part of the Airport’s performance metrics. Hangar rental revenues are the second largest stream of revenue for the Airport, representing 12.02% budgeted operating revenues. Year-to-date, hangar revenue totals $467,035 or 98.32% of budget. Occupancy rates continue to be strong. The stated goal per the Airport performance management program is to have occupancy rates over 90%. In fiscal year 2021, the Airport has monthly basis continues to meet this goal. Operating expenses include personnel costs, airport operations, ongoing capital maintenance, and fuel for resale. Airport operating expenses total budget is $4,427,731. Year-to-date personnel expenses total $430,953, or 92.78% of budget. Year to date personnel costs include the addition of 1 full time employee, who was transferred from Customer Care to Airport as part of the Midyear Budget Amendment. The City has experienced 23 of 26 pay periods through this period, or 88.46% of total cycles. Other Airport operational related expenses include internal service and administrative allocation charges, fuel expenses, and various other operating expense. Internal service charges total $312,056, or 100.00% of budget. Administrative allocation totals $123,528, or 100.00% of budget. Fuel expense is the largest expense of the Airport operating budget totaling $2,600,000, or 58.72% of the operating budget. Fuel expense budget was amended in the Midyear Budget Amendment in the amount of $500,000. Year-to-date fuel expense $2,123,401, or 81.67% of budget. Fuel is encumbered at the beginning of the fiscal year and liquidated throughout the year. At the time of this report the fund has fully liquidated the encumbrance for fuel for the year. The Finance team is actively working with our ERP consultant to address and liquidate the identified purchase order balance to $0. This will decrease the actual expense in the fund by $1,266,739. K 200K 400K 600K 800K Q1 Q2 Q3 Q4 AIRPORT FUND FUEL SALES FY2020 FY2021 K 200K 400K 600K 800K Q1 Q2 Q3 Q4 AIRPORT FUND FUEL EXPENSES FY2020 FY2021 Page 13 of 93 F Operating capital includes items that are typically routine in nature such as pavement maintenance, hangar maintenance, and wildlife management. The budget for operating capital totals $404,067, or 9.13% of the operating budget. Year-to-date operating capital expenses totals $19,839. Non-operating revenues budget includes a total of $705,000 for bond proceeds and miscellaneous revenue for the year. The Airport fund anticipates to issue bond proceeds in the amount of $700,000 for the construction of a new maintenance facility. Non-operating expenses have a total budget of $908,931, year to date spending totals $147,520. The Airport will use $750,000 in CIP expense for the construction of a new maintenance facility. The non-operating budget amount is for the Airport funds debt service payment. The debt service payment is made up of principal reduction, $89,813, and interest expense, $53,618. FY2021 REVENUE PROJECTIONS: Staff will monitor FY2021 projections as the end of the fiscal year approaches. Total operating revenues are projected to end FY2021 at $3,814,930. The largest component of operating revenue is fuel sales revenue, which is projected to end the year at $2,761,200. Through the quarter, actuals make up 100.25% of total operating revenue projections. Total non-operating revenue are projected to end FY2021 at $872,186. Through the quarter, actuals are 105.87% of total non-operating projections. FY2021 EXPENSE PROJECTIONS: Staff will continue to monitor FY2021 actuals to ensure they align with year-end projections. Total operating expenses are projected to end FY2021 at $3,987,583. Through the quarter, actuals are 117.49% of total operating expense projections. This overage above 100% is driven by the purchase order of $1,266,739 that the city is working to close. Non-operating expenses are projected to end FY2021 at $908,931, year to date actuals are 16.23% of year end projections. The Airport Fund anticipates meeting all the funds below line contingency requirements by the end of FY2021. Contingency requirements include a 90-day operating contingency of $332,917, a debt service reserve totaling $141,478. Page 14 of 93 Georgetown Transportation Advisory Board FY2022 BudgetPage 15 of 93 FY2022 Budget: GTAB Fund Structure -Revenue Airport Fund Cost Center Revenue Operating Revenue Ledger Revenue Category Non-Operating Revenue Grant Revenue Ledger Revenue Category Bond Proceeds Ledger Revenue Category Page 16 of 93 FY2022 Budget: GTAB FY2022 –Revenue Airport Operations: City of Georgetown FY2019 FY2020 ACTUALS ACTUALS AMENDED BUDGET PROJECTED % VARIANCE: FY2020 ACTUALS TO FY2021 PROJECTED BASE BUDGET CHANGES PROPOSED BUDGET % VARIANCE: FY2021 PROJECTED TO FY2022 BUDGET OPERATING REVENUE 40001:Property Taxes 30,818 57,018 40,000 57,000 -0.03%57,000 - 57,000 0.00% 40001:RC0125 Property Taxes 30,818 57,018 40,000 57,000 -0.03%57,000 - 57,000 0.00% 42001:Interest Income 20,631 18,257 3,000 3,129 -82.86%3,025 - 3,025 -3.32% 42001:Interest Income:RC0000 1,070 3 - - -100.00%- - - 0.00% 42001:RC0008 Allocated Interest 16,035 17,646 2,500 3,100 -82.43%3,000 - 3,000 -3.24% 42001:RC0013 Bond Interest 3,526 608 500 28 -95.32%25 - 25 -12.16% 43606:Airport Charges 3,344,792 3,227,142 3,908,500 3,754,800 16.35%3,910,097 - 3,910,097 4.14% 43606:RC0047 Facility Leases - Airport 219,260 243,595 230,000 244,000 0.17%251,000 - 251,000 2.87% 43606:RC0057 Fuel Sales 2,444,691 2,300,938 3,000,000 2,761,200 20.00%2,867,400 - 2,867,400 3.85% 43606:RC0066 Hangar Rentals 476,425 465,246 475,000 468,000 0.59%482,000 - 482,000 2.99% 43606:RC0084 Land Leases 165,492 173,103 165,000 232,000 34.02%257,000 - 257,000 10.78% 43606:RC0156 Storage Rentals 4,478 5,543 4,500 7,500 35.30%9,497 - 9,497 26.62% 43606:RC0177 Terminal Sales 2,285 2,611 2,000 2,100 -19.56%2,000 - 2,000 -4.77% 43606:RC0180 Tie Down Revenue 32,160 36,105 32,000 40,000 10.79%41,200 - 41,200 3.00% OPERATING REVENUE TOTAL 3,396,241 3,302,416 3,951,500 3,814,930 15.52%3,970,122 - 3,970,122 4.07% NON-OPERATING REVENUE 44001:Grant Revenue 55,870 129,193 - 157,000 21.52%108,000 - 108,000 -31.21% 44001:Grant Revenue:RC0000 - (3,868,535) - - -100.00%- - - 0.00% 44001:RC0064 Grant Revenue 55,870 3,997,729 - 157,000 -96.07%108,000 - 108,000 -31.21% 45001:Misc Revenue 757 570 5,000 1,000 75.48%1,000 - 1,000 0.00% 45001:RC0095 Misc Revenue 757 570 5,000 1,000 75.48%1,000 - 1,000 0.00% 46001:Bond Proceeds - - 700,000 650,000 0.00%- - - -100.00% 46001:RC0015 Bond Proceeds - - 700,000 650,000 0.00%- - - -100.00% 46002:Bond Premium - - - 64,186 0.00%- - - -100.00% 46002:RC0014 Bond Premium - - - 64,186 0.00%- - - -100.00% NON-OPERATING REVENUE TOTAL 56,627 129,763 705,000 872,186 572.14%109,000 - 109,000 -87.50% TOTAL REVENUE 3,452,868 3,432,179 4,656,500 4,687,116 36.56%4,079,122 - 4,079,122 -12.97% FY2021 FY2022 Page 17 of 93 FY2022 Budget: GTAB Fund Structure -Expense Airport Fund Cost Center Expense Operating Expense Personnel Ledger Spend Category Operations Ledger Spend Category Operating Capital Ledger Spend Category Non-Operating Expense CIP Ledger Spend Category Transfers Ledger Spend Category Debt Service Ledger Spend Category Spend Category Page 18 of 93 FY2022 Budget: GTAB Expense Reporting Expense Operating Expense Personnel Ledger Spend Category Operations Ledger Spend Category Operating Capital Ledger Spend Category Non- Operating Expense CIP Ledger Spend Category Transfers Ledger Spend Category Debt Service Ledger Spend Category Spend Category Page 19 of 93 FY2022 Budget: GTAB FY2022 –Operating Expense Personnel Airport Operations: City of Georgetown FY2019 FY2020 ACTUALS ACTUALS AMENDED BUDGET PROJECTED % VARIANCE: FY2020 ACTUALS TO FY2021 PROJECTED BASE BUDGET CHANGES PROPOSED BUDGET % VARIANCE: FY2021 PROJECTED TO FY2022 BUDGET PERSONNEL 50100:Salaries 300,713 334,221 376,915 371,834 11.25%401,343 - 401,343 7.94% 50100:Salaries:SC0000 - 168,740 - - -100.00%- - - 0.00% 50100:SC0420 Payroll - Overtime 2,192 1,952 2,155 52 -97.34%- - - -100.00% 50100:SC0140 Payroll - Longevity 3,842 2,887 6,629 - -100.00%8,184 - 8,184 0.00% 50100:SC0214 Payroll - Intern Pay 42,277 - - - 0.00%- - - 0.00% 50100:SC0221 Payroll - TMRS Expense 82,550 - - - 0.00%- - - 0.00% 50100:SC0421 Payroll - Part-Time Salaries 2,947 62,197 105,055 68,433 10.03%89,125 - 89,125 30.24% 50100:SC0423 Payroll - Salaries 166,905 98,445 263,076 303,349 208.14%304,035 - 304,035 0.23% 50200:Payroll Tax Expense 22,653 26,265 27,254 26,991 2.77%30,822 - 30,822 14.19% 50200:Payroll Tax Expense:SC0000 - 12,833 - - -100.00%- - - 0.00% 50200:SC0422 Payroll - Tax Expense 22,653 13,432 27,254 26,991 100.95%30,822 - 30,822 14.19% 50201:Worker's Compensation 506 2,039 1,875 2,427 19.00%2,852 - 2,852 17.52% 50201:Worker's Compensation:SC0000 - 1,084 - - -100.00%- - - 0.00% 50201:SC0250 Worker's Compensation 506 955 1,875 2,427 154.00%2,852 - 2,852 17.52% 50202:TWC Expense 119 2,018 1,071 950 -52.92%2,268 - 2,268 138.75% 50202:TWC Expense:SC0000 - 455 - - -100.00%- - - 0.00% 50202:SC0229 TWC Expense 119 1,563 1,071 950 -39.23%2,268 - 2,268 138.75% 50300:Benefits 28,967 36,103 21,754 25,429 -29.56%26,272 - 26,272 3.32% 50300:Benefits:SC0000 - 13,443 - - -100.00%- - - 0.00% 50300:SC0417 Payroll - Cell Phone Stipend - - 1,075 1,814 0.00%3,120 - 3,120 72.01% 50300:SC0121 Group Insurance 28,967 22,660 20,679 23,615 4.22%23,152 - 23,152 -1.96% 50301:TMRS Expense 57,600 37,868 35,603 38,229 0.95%39,164 - 39,164 2.45% 50301:TMRS Expense:SC0000 - 19,042 - - -100.00%- - - 0.00% 50301:SC0221 Payroll - TMRS Expense 57,600 18,826 35,603 38,229 103.06%39,164 - 39,164 2.45% PERSONNEL TOTAL 410,556 438,514 464,472 465,860 6.24%502,721 - 502,721 7.91% FY2021 FY2022 Page 20 of 93 FY2022 Budget: GTAB Expense Reporting Expense Operating Expense Personnel Operations Operating Capital Non- Operating Expense CIP Transfers Debt Service Page 21 of 93 FY2022 Budget: GTAB Expense Reporting Airport Operations Period: Sep-21 Budget Current Period FY2021 Sep-21 YTD Actuals w/ Encumbrances Variance % of Budget Projections Variance Fav/(Unfav)% of Projection Operating Expenses Personnel 464,472 40,871 430,953 33,519 92.78%465,860 34,907 92.51% Operations 3,559,192 162,404 4,365,108 (805,916) 122.64%3,416,469 (948,640) 127.77% Operating Capital 404,067 - 19,839 384,228 4.91%105,255 85,416 18.85% Total Operating Expenses 4,427,731 203,274 4,815,901 (388,170) 108.77%3,987,583 (828,317) 120.77% Non-Operating Expenses CIP Expense 750,000 - - 750,000 0.00%750,000 750,000 0.00% Debt Service 158,931 - 147,520 11,411 92.82%158,931 11,411 92.82% Total Non-Operating Expenses 908,931 - 147,520 761,411 16.23%908,931 761,411 16.23% Year-End: Projections Vs. ActualsYear-to-Date Actuals Budget Vs. Actuals Page 22 of 93 FY2022 Budget: GTAB FY2022 Service Level Enhancement •Market Rate and Lease Term Analysis; $45,000 (one-time) •The Market Rate Analysis will be used to analyze and apply property values for all airport assets. This will include currently developed land as well as undeveloped land, and land with easements. The FAA requires that any land used for any reason be charged a fair market value. This would include land on which the City has an easement for any reason. Once this analysis is complete, the airport will have a tool that can be used to set lease rates for undeveloped land as well as land on which there are easements. The lease term portion will be utilized to either justify or refute the need to extend the maximum length of a lease to match current Texas Statue of 40 years. There have been multiple investors who have approached the airport and have stated that the ROI on a 30-year lease will not allow for a competitive rate of return. Page 23 of 93 Airport Operations: City of Georgetown FY2019 FY2020  ACTUALS  ACTUALS  AMENDED BUDGET  PROJECTED   % VARIANCE:  FY2020 ACTUALS  TO FY2021  PROJECTED  BASE BUDGET  CHANGES   PROPOSED  BUDGET   % VARIANCE:  FY2021 PROJECTED  TO FY2022 BUDGET  OPERATING REVENUE 40001:Property Taxes 30,818                       57,018                      40,000                      57,000                      ‐0.03% 57,000                        ‐                            57,000                      0.00% 40001:RC0125 Property Taxes 30,818                       57,018                       40,000                       57,000                       ‐0.03% 57,000                        ‐                            57,000                       0.00% 42001:Interest Income 20,631                       18,257                      3,000                         3,129                        ‐82.86%3,025                          ‐                            3,025                          ‐3.32% 42001:Interest Income:RC0000 1,070                          3                                  ‐                              ‐                            ‐100.00%‐                               ‐                             ‐                             0.00% 42001:RC0008 Allocated Interest 16,035                       17,646                       2,500                         3,100                        ‐82.43%3,000                           ‐                            3,000                          ‐3.24% 42001:RC0013 Bond Interest 3,526                          608                            500                            28                             ‐95.32%25                                ‐                            25                               ‐12.16% 43606:Airport Charges 3,344,792                  3,227,142                 3,908,500                 3,754,800                16.35% 3,910,097                   ‐                            3,910,097                 4.14% 43606:RC0047 Facility Leases ‐ Airport 219,260                     243,595                    230,000                    244,000                   0.17% 251,000                      ‐                            251,000                    2.87% 43606:RC0057 Fuel Sales 2,444,691                  2,300,938                 3,000,000                 2,761,200                20.00%2,867,400                   ‐                            2,867,400                 3.85% 43606:RC0066 Hangar Rentals 476,425                     465,246                    475,000                    468,000                   0.59% 482,000                      ‐                            482,000                    2.99% 43606:RC0084 Land Leases 165,492                     173,103                    165,000                    232,000                   34.02%257,000                      ‐                            257,000                    10.78% 43606:RC0156 Storage Rentals 4,478                          5,543                         4,500                         7,500                        35.30%9,497                           ‐                            9,497                         26.62% 43606:RC0177 Terminal Sales 2,285                          2,611                         2,000                         2,100                         ‐19.56% 2,000                           ‐                            2,000                          ‐4.77% 43606:RC0180 Tie Down Revenue 32,160                       36,105                       32,000                       40,000                      10.79% 41,200                        ‐                            41,200                       3.00% OPERATING REVENUE TOTAL 3,396,241                  3,302,416                 3,951,500                 3,814,930                15.52% 3,970,122                   ‐                            3,970,122                 4.07% NON‐OPERATING REVENUE 44001:Grant Revenue 55,870                       129,193                     ‐                             157,000                   21.52%108,000                      ‐                            108,000                    ‐31.21% 44001:Grant Revenue:RC0000 ‐                              (3,868,535)                 ‐                              ‐                            ‐100.00%‐                              ‐                            ‐                             0.00% 44001:RC0064 Grant Revenue 55,870                       3,997,729                  ‐                             157,000                   ‐96.07%108,000                     ‐                            108,000                    ‐31.21% 45001:Misc Revenue 757                             570                            5,000                         1,000                        75.48%1,000                          ‐                            1,000                         0.00% 45001:RC0095 Misc Revenue 757                             570                            5,000                         1,000                        75.48%1,000                          ‐                            1,000                         0.00% 46001:Bond Proceeds ‐                               ‐                             700,000                    650,000                   0.00%‐                               ‐                             ‐                             ‐100.00% 46001:RC0015 Bond Proceeds ‐                               ‐                             700,000                    650,000                   0.00%‐                              ‐                            ‐                             ‐100.00% 46002:Bond Premium ‐                               ‐                              ‐                             64,186                     0.00%‐                               ‐                             ‐                             ‐100.00% 46002:RC0014 Bond Premium ‐                               ‐                              ‐                             64,186                      0.00%‐                              ‐                            ‐                             ‐100.00% NON‐OPERATING REVENUE TOTAL 56,627                       129,763                    705,000                    872,186                   572.14%109,000                      ‐                            109,000                    ‐87.50% TOTAL REVENUE 3,452,868                  3,432,179                 4,656,500                 4,687,116                36.56%4,079,122                   ‐                            4,079,122                  ‐12.97% FY2021 FY2022 Page 24 of 93 Airport Operations: City of Georgetown FY2019 FY2020  ACTUALS  ACTUALS  AMENDED BUDGET  PROJECTED   % VARIANCE:  FY2020 ACTUALS  TO FY2021  PROJECTED  BASE BUDGET  CHANGES   PROPOSED  BUDGET   % VARIANCE:  FY2021 PROJECTED  TO FY2022 BUDGET  PERSONNEL 50100:Salaries 300,713                    334,221                    376,915                     371,834                     11.25% 401,343                      ‐                            401,343                   7.94% 50100:Salaries:SC0000 ‐                             168,740                     ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 50100:SC0062 Babysitter Payroll ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0079 Camp Pro Payroll ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0092 Contract Labor ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0094 Council Compensation ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0418 Payroll ‐ Assignment Pay ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0419 Payroll ‐ Certification Pay ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0420 Payroll ‐ Overtime 2,192                         1,952                         2,155                          52                               ‐97.34%‐                               ‐                             ‐                            ‐100.00% 50100:SC0136 Payroll ‐ Lesson Instruction ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0140 Payroll ‐ Longevity 3,842                         2,887                         6,629                           ‐                              ‐100.00%8,184                           ‐                            8,184                        0.00% 50100:SC0167 Payroll ‐ Pools ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0179 Payroll ‐ Public Safety ‐ Education ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0195 Payroll ‐ Scheduled Overtime ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0205 Payroll ‐ Standby Stipends ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0214 Payroll ‐ Intern Pay 42,277                        ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0215 Tennis Camp Payroll ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0221 Payroll ‐ TMRS Expense 82,550                        ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0421 Payroll ‐ Part‐Time Salaries 2,947                         62,197                       105,055                      68,433                       10.03% 89,125                        ‐                            89,125                      30.24% 50100:SC0460 Vacancy Factor ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50100:SC0423 Payroll ‐ Salaries 166,905                    98,445                       263,076                      303,349                     208.14%304,035                      ‐                            304,035                   0.23% 50200:Payroll Tax Expense 22,653                      26,265                      27,254                        26,991                       2.77% 30,822                        ‐                            30,822                     14.19% 50200:Payroll Tax Expense:SC0000 ‐                             12,833                        ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 50200:SC0422 Payroll ‐ Tax Expense 22,653                       13,432                       27,254                        26,991                       100.95%30,822                        ‐                            30,822                      14.19% 50201:Worker's Compensation 506                            2,039                         1,875                          2,427                         19.00% 2,852                          ‐                            2,852                        17.52% 50201:Worker's Compensation:SC0000 ‐                             1,084                          ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 50201:SC0250 Worker's Compensation 506                            955                            1,875                          2,427                         154.00%2,852                           ‐                            2,852                        17.52% 50201:SC0429 Payroll Workers Comp ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50202:TWC Expense 119                            2,018                         1,071                          950                             ‐52.92%2,268                          ‐                            2,268                        138.75% 50202:TWC Expense:SC0000 ‐                             455                             ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 50202:SC0229 TWC Expense 119                            1,563                         1,071                          950                             ‐39.23%2,268                           ‐                            2,268                        138.75% 50300:Benefits 28,967                      36,103                      21,754                        25,429                       ‐29.56%26,272                        ‐                            26,272                     3.32% 50300:Benefits:SC0000 ‐                             13,443                        ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 50300:SC0087 Payroll ‐ Clothing Allowance ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50300:SC0417 Payroll ‐ Cell Phone Stipend ‐                              ‐                             1,075                          1,814                         0.00% 3,120                           ‐                            3,120                        72.01% 50300:SC0121 Group Insurance 28,967                       22,660                       20,679                        23,615                       4.22% 23,152                        ‐                            23,152                       ‐1.96% 50300:SC0140 Payroll ‐ Longevity ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50300:SC0178 Public Safety ‐ Incentive ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 50301:TMRS Expense 57,600                      37,868                      35,603                        38,229                       0.95% 39,164                        ‐                            39,164                     2.45% 50301:TMRS Expense:SC0000 ‐                             19,042                        ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 50301:SC0221 Payroll ‐ TMRS Expense 57,600                       18,826                       35,603                        38,229                       103.06%39,164                        ‐                            39,164                      2.45% 50900:Fringe Benefit Estimates ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                            0.00% PERSONNEL TOTAL 410,556                    438,514                    464,472                     465,860                     6.24% 502,721                      ‐                            502,721                   7.91% OPERATIONS 51001:Administrative Expense 377,295                    428,955                    456,346                     456,345                     6.39% 581,564                      ‐                            581,564                   27.44% 51001:SC0212 Technology Allocation ‐ Expense 45,068                       54,870                       73,439                        73,439                       33.84%89,202                        ‐                            89,202                      21.46% 51001:SC0233 Vehicle Lease Allocation ‐ Expense 19,612                       19,571                       20,762                        20,762                       6.08% 21,987                        ‐                            21,987                      5.90% FY2021 FY2022 Page 25 of 93 Airport Operations: City of Georgetown FY2019 FY2020  ACTUALS  ACTUALS  AMENDED BUDGET  PROJECTED   % VARIANCE:  FY2020 ACTUALS  TO FY2021  PROJECTED  BASE BUDGET  CHANGES   PROPOSED  BUDGET   % VARIANCE:  FY2021 PROJECTED  TO FY2022 BUDGET  FY2021 FY2022 51001:SC0259 Administrative (Joint Services) Allocation ‐ Ex 245,541                    194,589                    123,528                      123,528                     ‐36.52%209,975                      ‐                            209,975                   69.98% 51001:SC0260 General Fund Allocation ‐ Expense ‐                             65,487                       136,758                      136,758                     108.83%143,743                      ‐                            143,743                   5.11% 51001:SC0261 Facilities Allocation ‐ Expense 41,792                       75,922                       77,751                        77,751                       2.41% 91,608                        ‐                            91,608                      17.82% 51001:SC0262 Fleet Maintenance Allocation ‐ Expense 25,283                       18,515                       24,108                        24,108                       30.21%25,049                        ‐                            25,049                      3.90% 51003:Marketing & Promotional 855                            744                            500                             500                             ‐32.80%500                              ‐                            500                           0.00% 51003:SC0171 Advertising ‐ Print and Digital 855                            744                            500                             500                             ‐32.80%500                              ‐                            500                           0.00% 51004:Contractual Services 481,547                    50                              3,100                          960                             1820.00%960                             45,000                     45,960                     4687.50% 51004:Contractual Services:SC0000 481,547                     ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 51004:SC0132 Janitorial services ‐                              ‐                             100                              ‐                              0.00%‐                               ‐                             ‐                            0.00% 51004:SC0160 Pest Extermination ‐                              ‐                              ‐                              960                             0.00% 960                              ‐                            960                           0.00% 51004:SC0193 Sanitation Services ‐                             50                               ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 51004:SC0329 Consulting ‐ Aviation ‐                              ‐                             3,000                           ‐                              0.00%‐                              45,000                      45,000                      0.00% 51005:Professional Services ‐                             150                            2,052                          51                               ‐65.75%2,075                          ‐                            2,075                        3938.54% 51005:SC0312 Engineering Services ‐                             150                            2,000                           ‐                              ‐100.00%2,000                           ‐                            2,000                        0.00% 51005:SC0048 TCEQ Inspections ‐                              ‐                             52                                51                               0.00% 75                                ‐                            75                             45.97% 51006:Subscriptions 5,512                         8,306                         5,000                          7,525                          ‐9.40% 5,400                          ‐                            5,400                        ‐28.24% 51006:SC0328 Accreditation Fees ‐                             188                             ‐                               ‐                              ‐100.00%300                              ‐                            300                           0.00% 51006:SC0209 Subscriptions & Dues 5,512                         8,118                         5,000                          7,500                          ‐7.61% 5,000                           ‐                            5,000                        ‐33.33% 51006:SC0494 Licenses and Certifications ‐                              ‐                              ‐                              25                               0.00% 100                              ‐                            100                           300.00% 51007:Contracts & Leases 10,450                      990                             ‐                              60                               ‐93.97%‐                               ‐                             ‐                            ‐100.00% 51007:Contracts & Leases:SC0000 10,450                        ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 51007:SC0227 Tree and Shrub Removal Services ‐                             950                             ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 51007:SC0241 Water ‐                             40                               ‐                              60                               48.73%‐                               ‐                             ‐                            ‐100.00% 51008:Utilities 90,454                      114,900                    120,000                     124,000                     7.92% 120,000                      ‐                            120,000                    ‐3.23% 51008:SC0231 Utilities 90,454                       114,900                    120,000                      124,000                     7.92% 120,000                      ‐                            120,000                    ‐3.23% 51009:Telephone 20,613                      26,514                      25,000                        30,500                       15.03% 39,000                        ‐                            39,000                     27.87% 51009:SC0055 Cellular Data Plans ‐                             76                              1,000                           ‐                              ‐100.00%1,000                           ‐                            1,000                        0.00% 51009:SC0148 Modem Services 18,242                       22,260                       22,000                        29,000                       30.28%35,000                        ‐                            35,000                      20.69% 51009:SC0162 Phone 2,371                         4,178                         2,000                          1,500                         ‐64.09%3,000                           ‐                            3,000                        99.94% 51010:Legal Services ‐                             14,381                      102,500                     60,000                       317.21%70,000                        ‐                            70,000                     16.67% 51010:SC0135 Legal Services ‐                             14,381                       102,500                      60,000                       317.21%70,000                        ‐                            70,000                      16.67% 52501:Office Supplies 4,421                         4,222                         4,500                          2,500                         ‐40.79%4,500                          ‐                            4,500                        80.02% 52501:SC0286 Office Supplies, General 4,421                         4,222                         4,500                          2,500                         ‐40.79%4,500                           ‐                            4,500                        80.02% 52506:Operational Supplies 1,940,880                 1,762,886                 2,608,500                  2,607,000                 47.88%2,707,400                   ‐                            2,707,400                3.85% 52506:SC0114 First Aid Cabinets, Kits and Refills ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 52506:SC0119 Fuel ‐ Gas 1,934,792                 1,715                         4,500                          4,500                         162.33%1,800                           ‐                            1,800                        ‐60.00% 52506:SC0330 Fuel ‐ Aviation ‐                             1,756,318                 2,600,000                  2,600,000                  48.04%2,700,000                   ‐                            2,700,000                3.85% 52506:SC0343 Emergency Management Supplies ‐                             190                             ‐                               ‐                              ‐100.00%1,000                           ‐                            1,000                        0.00% 52506:SC0385 Switches, Parts and Accessories, Miscellaneo ‐                             170                             ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 52506:SC0145 Medical Supplies ‐                             (24)                              ‐                               ‐                              ‐100.00%600                              ‐                            600                           0.00% 52506:SC0161 Shelter Supplies ‐ Bedding, etc.‐                             17                               ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 52506:SC0203 Hand Tools, Powered and Non‐Powered 6,088                         2,022                         4,000                          2,500                         23.63%4,000                           ‐                            4,000                        60.01% 52506:SC0278 Oil, Grease and Lubricants ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 52506:SC0279 Hardware and Related Items ‐                             2,478                          ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 52507:Janitorial Supplies ‐                              ‐                              ‐                               ‐                             0.00%‐                               ‐                             ‐                            0.00% 52507:SC0307 Maintenance ‐ Buildings ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 52507:SC0463 Cleaning Supplies ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 52509:Maintenance Expense 279,384                    125,469                    162,135                     80,504                       ‐35.84%159,750                      ‐                            159,750                   98.44% 52509:SC0314 Maintenance ‐ Equipment 3,609                         4,096                         4,000                          4,000                          ‐2.34% 4,000                           ‐                            4,000                        0.00% 52509:SC0332 Maintenance ‐ Electrical Equipment ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 52509:SC0370 Maintenance ‐ Pumps 7,189                         10,549                       90,500                        25,000                       137.00%15,000                        ‐                            15,000                      ‐40.00% Page 26 of 93 Airport Operations: City of Georgetown FY2019 FY2020  ACTUALS  ACTUALS  AMENDED BUDGET  PROJECTED   % VARIANCE:  FY2020 ACTUALS  TO FY2021  PROJECTED  BASE BUDGET  CHANGES   PROPOSED  BUDGET   % VARIANCE:  FY2021 PROJECTED  TO FY2022 BUDGET  FY2021 FY2022 52509:SC0377 Maintenance ‐ Security and Access Systems ‐                             49                               ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 52509:SC0406 Maintenance ‐ Lawn, Ball Fields, Tennis Court 33,170                       68,019                       47,500                        31,000                       ‐54.42%50,000                        ‐                            50,000                      61.29% 52509:SC0120 Maintenance ‐ Miscellaneous ‐                             241                             ‐                              450                             86.42%‐                               ‐                             ‐                            ‐100.00% 52509:SC0208 Maintenance ‐ Street Asphaltic 70,045                        ‐                              ‐                              (0)                                0.00% 70,000                        ‐                            70,000                      ‐87500100.00% 52509:SC0307 Maintenance ‐ Buildings 150,167                    25,578                       20,135                        20,000                       ‐21.81%20,000                        ‐                            20,000                      0.00% 52509:SC0024 Improvements ‐ Other 15,202                       15,549                        ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 52509:SC0459 Maintenance ‐ Gates ‐                             1,387                          ‐                              54                               ‐96.13%750                              ‐                            750                           1295.87% 53002:Postage & Freight 105                            172                            211                             175                             1.36% 200                              ‐                            200                           14.40% 53002:SC0168 Postage 105                            117                            100                             100                              ‐14.64% 100                              ‐                            100                           0.21% 53002:SC0197 Shipping & Freight ‐                             56                              111                             75                               34.99%100                              ‐                            100                           33.28% 53003:Food 1,392                         524                            1,500                          1,550                         195.77%2,000                          ‐                            2,000                        29.01% 53003:SC0251 Prepared Foods ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 53003:SC0269 Coolers, Drinking Water (Water Fountains)‐                             215                             ‐                              750                             249.34%1,000                           ‐                            1,000                        33.29% 53003:SC0277 Food 1,392                         309                            1,500                          800                             158.58%1,000                           ‐                            1,000                        25.00% 53004:Insurance Expense 9,332                         9,333                         10,500                        10,484                       12.33% 9,146                          ‐                            9,146                         ‐12.76% 53004:Insurance Expense:SC0000 ‐                              ‐                              ‐                              (17)                              0.00%‐                               ‐                             ‐                            ‐100.00% 53004:SC0176 Property and Casualty Insurance 9,332                         9,333                         10,500                        10,500                       12.51% 9,146                           ‐                            9,146                         ‐12.89% 53004:SC0453 Long Term Disability ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 53010:Uniform Expense 1,577                         4,073                         1,500                          1,717                         ‐57.85%1,800                          ‐                            1,800                        4.85% 53010:SC0177 Protective clothing ‐                              ‐                              ‐                              66                               0.00% 100                              ‐                            100                           50.88% 53010:SC0192 Safety Shoes ‐                              ‐                              ‐                              150                             0.00% 200                              ‐                            200                           33.33% 53010:SC0230 Uniforms 1,577                         4,073                         1,500                          1,500                         ‐63.16%1,500                           ‐                            1,500                         ‐0.03% 53013:Depreciation 571,410                     ‐                              ‐                               ‐                             0.00%‐                               ‐                             ‐                            0.00% 53013:Depreciation:SC0000 571,410                     ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 53015:Other Miscellaneous  Expense 32,651                      30,454                      32,000                        32,200                       5.74% 35,200                        ‐                            35,200                     9.32% 53015:SC0095 Credit Card Fees 31,278                       30,593                       32,000                        32,000                       4.60% 35,000                        ‐                            35,000                      9.37% 53015:SC0361 Permits ‐                              ‐                              ‐                              200                             0.00% 200                              ‐                            200                           0.00% 53015:SC0156 Over/Short 1,374                         (140)                            ‐                              0                                 ‐100.17%‐                               ‐                             ‐                            ‐100.00% 53016:Travel Expense 12,776                      4,347                         16,500                         ‐                             ‐100.00%10,520                        ‐                            10,520                     0.00% 53016:SC0081 Travel ‐ Car rental ‐                              ‐                             1,400                           ‐                              0.00%‐                               ‐                             ‐                            0.00% 53016:SC0349 Travel ‐ Lodging ‐                              ‐                             3,400                           ‐                              0.00% 3,000                           ‐                            3,000                        0.00% 53016:SC0352 Travel ‐ Airlines ‐                              ‐                             6,000                           ‐                              0.00%‐                               ‐                             ‐                            0.00% 53016:SC0143 Travel ‐ Meals ‐                              ‐                             800                              ‐                              0.00% 800                              ‐                            800                           0.00% 53016:SC0146 Travel ‐ Mileage 5,393                         1,998                         4,000                           ‐                              ‐100.00%4,000                           ‐                            4,000                        0.00% 53016:SC0199 Travel ‐ Transportation, Other ‐                              ‐                             200                              ‐                              0.00% 20                                ‐                            20                             0.00% 53016:SC0222 Travel ‐ Incidental Expenses (Tolls, Tips)‐                              ‐                             500                              ‐                              0.00% 500                              ‐                            500                           0.00% 53016:SC0232 Travel ‐ Parking Fees ‐                              ‐                             200                              ‐                              0.00% 200                              ‐                            200                           0.00% 53016:SC0257 Travel 7,383                         2,350                          ‐                               ‐                              ‐100.00%2,000                           ‐                            2,000                        0.00% 53017:Training Expense ‐                              ‐                             7,348                          398                             0.00% 7,500                          ‐                            7,500                        1784.90% 53017:SC0399 Training ‐ Registration Fees ‐                              ‐                             5,848                          398                             0.00% 6,000                           ‐                            6,000                        1407.92% 53017:SC0225 Training ‐ Conference/Convention ‐                              ‐                             1,500                           ‐                              0.00% 1,500                           ‐                            1,500                        0.00% OPERATIONS TOTAL 3,840,655                 2,536,470                 3,559,192                  3,416,469                 34.69%3,757,516                  45,000                     3,802,516                11.30% OPERATING CAPITAL 60004:Capital Outlay ‐ Equipment ‐                             8,681                         70,000                        70,255                       709.31%‐                               ‐                             ‐                            ‐100.00% 60004:SC0002 Equipment ‐ Airport ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 60004:SC0003 Furniture and Fixtures ‐                              ‐                              ‐                              174                             0.00%‐                               ‐                             ‐                            ‐100.00% 60004:SC0013 Computer Hardware ‐                             49                               ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 60004:SC0280 Lawn Maintenance Equipment ‐                             521                             ‐                              81                               ‐84.48%‐                               ‐                             ‐                            ‐100.00% 60004:SC0025 Equipment ‐ Miscellaneous ‐                             8,111                         70,000                        70,000                       763.03%‐                               ‐                             ‐                            ‐100.00% Page 27 of 93 Airport Operations: City of Georgetown FY2019 FY2020  ACTUALS  ACTUALS  AMENDED BUDGET  PROJECTED   % VARIANCE:  FY2020 ACTUALS  TO FY2021  PROJECTED  BASE BUDGET  CHANGES   PROPOSED  BUDGET   % VARIANCE:  FY2021 PROJECTED  TO FY2022 BUDGET  FY2021 FY2022 60009:Capital Outlay ‐ Improvements ‐                             101,780                    334,067                     35,000                       ‐65.61%65,000                        ‐                            65,000                     85.71% 60009:SC0001 Airport Distribution ‐                             12,921                        ‐                               ‐                              ‐100.00%‐                               ‐                             ‐                            0.00% 60009:SC0272 Fencing ‐                              ‐                              ‐                               ‐                              0.00%‐                               ‐                             ‐                            0.00% 60009:SC0024 Improvements ‐ Other ‐                             88,859                       334,067                      35,000                       ‐60.61%65,000                        ‐                            65,000                      85.71% OPERATING CAPITAL TOTAL ‐                             110,461                    404,067                     105,255                      ‐4.71% 65,000                        ‐                            65,000                     ‐38.25% CIP EXPENSE DEBT SERVICE TRANSFERS City of Georgetown Total 4,251,212                 3,085,444                 4,427,731                  3,987,583                 29.24%4,325,237                  45,000                     4,370,237                9.60% Page 28 of 93 Airport Operations: City of Georgetown FY2019 FY2020  ACTUALS  ACTUALS  AMENDED BUDGET  PROJECTED   % VARIANCE:  FY2020 ACTUALS  TO FY2021  PROJECTED  BASE BUDGET  CHANGES   PROPOSED  BUDGET   % VARIANCE:  FY2021 PROJECTED  TO FY2022 BUDGET  CIP EXPENSE 62001:CIP Expense ‐                              ‐                             750,000                     750,000                     0.00%‐                               ‐                             ‐                            ‐100.00% 62001:SC0308 Construction ‐                              ‐                              ‐                              750,000                     0.00%‐                               ‐                             ‐                            ‐100.00% 62001:SC0009 Buildings Metal ‐                              ‐                             750,000                       ‐                              0.00%‐                               ‐                             ‐                            0.00% CIP EXPENSE TOTAL ‐                              ‐                             750,000                     750,000                     0.00%‐                               ‐                             ‐                            ‐100.00% DEBT SERVICE 55001:Principal Reduction ‐                             86,358                      89,813                        89,813                       4.00% 110,605                      ‐                            110,605                   23.15% 55001:SC0099 Debt Payment ‐                             86,358                       89,813                        89,813                       4.00% 110,605                      ‐                            110,605                   23.15% 55002:Interest Expense 46,939                      60,062                      53,618                        53,618                        ‐10.73% 73,494                        ‐                            73,494                     37.07% 55002:SC0398 Debt Interest 46,939                       60,062                       53,618                        53,618                        ‐10.73% 73,494                        ‐                            73,494                      37.07% 55003:Handling Fees 127                            142                            500                             500                             252.11%127                              ‐                            127                           ‐74.60% 55003:SC0400 Bond Handling Fee 127                            142                            500                             500                             252.11%127                              ‐                            127                           ‐74.60% 55004:Bond Issuance Costs 7,813                          ‐                             15,000                        15,000                       0.00%‐                               ‐                             ‐                            ‐100.00% 55004:SC0401 Bond Issuance Costs 7,813                          ‐                             15,000                        15,000                       0.00%‐                               ‐                             ‐                            ‐100.00% DEBT SERVICE TOTAL 54,879                      146,562                    158,931                     158,931                     8.44% 184,226                      ‐                            184,226                   15.92% TRANSFERS NON‐OPERATING EXPENSE TOTAL 54,879                      146,562                    908,931                     908,931                     520.17%184,226                      ‐                            184,226                   ‐79.73% FY2021 FY2022 Page 29 of 93 City of Georgetown, Texas Transportation Advisory Board October 8, 2021 S UB J E C T: O c tober 2021 G TAB Updates - Wesley Wright, P.E., S ystems Engineering Direc tor / C hris P ousson, C I P Manager. IT E M S UMMARY: October 2021 G TAB Updates F M 971 - Realignment at Austin Avenue: Utility relocation in the park c omplete. S ubgrade underway. P edestrian tunnel under cons truction Northwest Blvd: S ubstantial c ompletion and ribbon c utting to open road 8-27-21 P unchlis t items being addressed for final c ompletion by the end of O ctober D B Woods: P roject design to utilize exis ting R O W, Des ign is underway with typic al sec tions c urrently under review along with bridge options. Meeting held with DB Wood residents 7-29 to talk with them about their concerns . New s ection pushed out to residents. In pers on meetings being sc heduled with property owners . S outhwestern Blvd: P reliminary alignment revised. P erforming Hydrologic and Hydraulic c alculations . R O W needs forwarded to Travis. S E Inner Loop: S ubgrade c omplete final s ection and final culvert work 90%, final paving to be ins talled this month. 2020 Curb and G utter: C ontractor has plac ed notific ations on residents’ doors . C urb work is 90% complete on Meadowbrook. As phalt repairs need to be made. Rock S idewalk / F Y20 Downtown AD A sidewalk Improvements: C ontractor has c ompleted work on R oc k S t between 8th and 9th. T hey are c urrently working on R ock S t between 7th and 8th S t. C urb and sidewalk are in on 7th S t in front of G eorgetown Title. P aving set for the week of 7/26. 2021 Signal Improvements: S hell R d @ Verde Vista and Williams @ Es trella C ros s ing were bid July 22 with Aus tin traffic S ignal as the low bid and recommended for award. C ontrac ts being executed, work to begin April or May upon receipt of poles . 2021 Intersection Pedestrian Safety Enhancements: Des ign and survey underway for rec tangular rapid flas h beacons (R R F B) at the following locations. C ool Page 30 of 93 S prings Way @ C owan C reek Amenity C enter, 5th S treet @ Austin Ave., 8 th S treet @ Library (new parking lot) and Industrial Ave @ G MC remote parking lot. 100% plans reviewed. Bids opened on July 12th. Austin Traffic S ignal sole bidder for the projec t. Unit prices s imilar to previously bid project. G TAB and C ouncil Approved, C ontracts routed for signatures. S H 29 Access Improvements – traffic signal: Ins tallation of light is complete and open to traffic at new signal. 2021 High Performance Pavement S eal P roject #1: G TAB Board and C ouncil approved award in May 2021. C ontrac ts s igned and ac cepted. C holla s tarted in S un C ity on S eptember 20th, sc heduled to be completed in S un C ity on O ctober 12th. Work to begin in Q uail Valley/P leasant Valley area on O ctober 17th. 2021 High Performance Pavement S eal P roject #2: Andale C onstruc tion c ontract was approved by G TAB Board and C ity C ouncil in May 2021. Areas inc luded in the projec t are Berry C reek and G atlin C reek neighborhoods . Andale has c ompleted work on 95% of s treets . C ontractor to return to c omplete O akmont and C ul-de-s acs in P arkview Es tates . S chedule is pending. 2021 HIP R P roject: Area off Williams Dr./ HI P R c omplete. Downtown area approx. 70%, with rain c ontractor doing cleanup for festival weekend and will begin paving again firs t week of O c t. F IN AN C IAL IMPAC T: N/A S UB MIT T E D B Y: Wesley Wright, P.E., S ystems Engineering Direc tor/C hris P ousson, C I P Manager AT TAC H ME N T S: Description Type October 2021 GTAB Updates Pres entation Page 31 of 93 October 2021 GTAB Updates Cover Sheet FM 971 - Realignment at Austin Avenue: Utility relocation in the park complete. Subgrade underway. Pedestrian tunnel under construction Northwest Blvd: • Substantial completion and ribbon cutting to open road 8-27-21 • Punchlist items being addressed for final completion by the end of October DB Woods Project design to utilize existing ROW, Design is underway with typical sections currently under review along with bridge options. Meeting held with DB Wood residents 7-29 to talk with them about their concerns. New section pushed out to residents. In person meetings being scheduled with property owners. Southwestern Blvd: • Preliminary alignment revised. • Performing Hydrologic and Hydraulic calculations. • ROW needs forwarded to Travis. SE Inner Loop: Subgrade complete final section and final culvert work 90%, final paving to be installed this month. 2020 Curb and Gutter Contractor has placed notifications on residents’ doors. Curb work is 90% complete on Meadowbrook. Asphalt repairs need to be made. Rock Sidewalk / FY20 Downtown ADA sidewalk Improvements Contractor has completed work on Rock St between 8th and 9th. They are currently working on Rock St between 7th and 8th St. Curb and sidewalk are in on 7th St in front of Georgetown Title. Paving set for the week of 7/26. 2021 Signal Improvements Shell Rd @ Verde Vista and Williams @ Estrella Crossing were bid July 22 with Austin traffic Signal as the low bid and recommended for award. Contracts being executed, work to begin April or May upon receipt of poles. 2021 Intersection Pedestrian Safety Enhancements Design and survey underway for rectangular rapid flash beacons (RRFB) at the following locations. Cool Springs Way @ Cowan Creek Amenity Center, 5th Street @ Austin Ave., 8th Street @ Library (new parking lot) and Industrial Ave @ GMC remote parking lot. 100% plans reviewed. Bids opened on July 12th. Austin Traffic Signal sole bidder for the project. Unit prices similar to previously bid project. GTAB and Council Approved, Contracts routed for signatures. Page 32 of 93 SH 29 Access Improvements – traffic signal Installation of light is complete and open to traffic at new signal. 2021 High Performance Pavement Seal Project #1 GTAB Board and Council approved award in May 2021. Contracts signed and accepted. Cholla started in Sun City on September 20th, scheduled to be completed in Sun City on October 12th. Work to begin in Quail Valley/Pleasant Valley area on October 17th. 2021 High Performance Pavement Seal Project #2 Andale Construction contract was approved by GTAB Board and City Council in May 2021. Areas included in the project are Berry Creek and Gatlin Creek neighborhoods. Andale has completed work on 95% of streets. Contractor to return to complete Oakmont and Cul-de-sacs in Parkview Estates. Schedule is pending. 2021 HIPR project Area off Williams Dr./ HIPR complete. Downtown area approx. 70%, with rain contractor doing cleanup for festival weekend and will begin paving again first week of Oct. Page 33 of 93 FM 971 at Austin Avenue Realignment Intersection Improvements Project No. 1BZ TIP No. AG October 2021 Project Description Design and preparation of final plans, specifications and estimates (PS&E) for the widening and realignment of FM 971 at Austin Avenue, eastward to Gann Street. Purpose To provide a new alignment consistent with the alignment of the proposed Northwest Boulevard Bridge over IH 35; to allow a feasible, alternate route from the west side of I 35 to Austin Avenue, to Georgetown High School, to San Gabriel Park and a more direct route to SH 130. Project Managers Joel Weaver Engineer Klotz Associates, Inc. Element Status / Issues Design TxDOT bid June of 2021 Low bid by CHASCO construction, contracts finalized, work to begin September 7th Environmental/ Archeological Complete Rights of Way Final parcel preparing for closing Utility Relocations TBD Construction Utility relocation in the park complete. Subgrade underway. Pedestrian tunnel under construction Other Issues AFA with TxDOT complete. Page 34 of 93 Northwest Boulevard (Fontana Drive to Austin Avenue) Project No. 5QX TIP No. AF October 2021 Project Description Construction of overpass and surface roads to connect Northwest Boulevard with Austin Avenue and FM 971. Purpose This project will relieve congestion at the Austin Avenue/Williams Drive intersection and provide a more direct access from the west side of IH 35 corridor to Georgetown High School and SH 130 via FM 971. Project Manager Joel Weaver and Wesley Wright, P.E. Engineer Klotz Associates Element Status / Issues Design Design Complete Environmental/ Archeological Complete Rights of Way ROW Documents are being finalized. All offers have been made. 8 Parcels required. 5 acquired, 1 in closing, 2 in condemnation. Utility Relocations TBD Construction • Substantial completion and ribbon cutting to open road 8-27-21 • Punchlist items being addressed for final completion by the end of October Other Issues Page 35 of 93 D B Wood Widening Project No. PRJ000188 TIP No. October 2021 Project Description D.B . Wood (SH 29 to Oak Ridge) ,Roadway improvements on DB Wood from SH29 to Oak Ridge Drive. Expanding Roadway from 2 lanes to 5 lanes (4 travel lanes w/turn lanes). Purpose To manage current and future traffic flow Project Manager Joel Weaver Engineer Kimely-Horn and Associates. Inc. Element Status / Issues Design Design is underway with typical sections currently under review along with bridge options. Meeting held with DB Wood residents 7-29 to talk with them about their concerns. New section pushed out to community. In person meetings being scheduled with property owners. Surveying Survey is underway Environmental/ Archeological Underway Rights of Way Project design to utilize existing ROW Utility Relocations TBD Construction N/A Other Issues None Page 36 of 93 Widening of: SE Inner Loop - FM 1460 to Austin Avenue Roadway & Southwestern Boulevard – Raintree Drive to SE Inner Loop Roadway October 2021 Project Description FM 1460 to Austin Avenue Roadway Widening Project & Southwestern Boulevard – Raintree Drive to SE Inner Loop Roadway Widening Project (See Attached Exhibit C). The professional services will consist of providing final roadway, drainage, water, wastewater, incidental designs, as well as, utility coordination, ROW support, environmental phase I investigations, archeological investigations, geotechnical investigations, ROW & Temporary Construction Easement (TCE) metes and bounds documents, bidding documents, bidding services, and construction administration services. Project Managers Joel Weaver and Wesley Wright, P.E. Engineer KPA & Associates Element Status / Issues Design Southwestern: • Preliminary alignment revised • Performing Hydrologic and Hydraulic calculations • ROW needs forwarded to Travis Environmental/ Archeological Efforts to begin April 2019 and any issues are expected to be identified in the coming month. Rights of Way ROW needs on Southwestern to be determined Total Parcels: 0 Possession: 0 Pending: 0 Utility Relocations To be determined Construction SE Inner Loop: Subgrade complete final section and final culvert work 90%, final paving to be installed this month. Other Issues None. Page 37 of 93 2020 Curb and Gutter Project No. PRJ000024 TIP No. None Updated - October 2021 Project Description Design and preparation of final plans, specifications and estimates (PS&E) and construction administration for curb and gutter replacements on Meadowbrook Drive, Oakland Drive and Ridge Oak Drive. Purpose This project consists of removing and replacing old curb and gutter that do not properly drain storm water and prematurely damage streets. Project Managers Chris Pousson / Chris Logan Engineer Contractor KPA Yoko Excavating Element Status / Issues Design Design is complete. Environmental/ Archeological N/A Rights of Way N/A Utility Relocations None Bid Phase Project is advertised. Bid Opening held on December 15th, 2020. Yoko Excavating LLC low qualified bidder. GTAB approved award on February 12th,, Council approved award on February 23rd. Construction Work on Meadowbrook and Oakland is complete minus some punchlist items. Curb is half complete on Ridge Oak. Other Issues Page 38 of 93 Citywide Sidewalk Improvements Project Rock Sidewalk / FY 20 Downtown ADA Improvements Project No. PRJ000138 TIP No. None Updated - October 2021 Project Description The proposed project consists of the rehabilitation and installation of pedestrian facilities along several streets on Rock Street between 8th and 7th and Downtown ADA Sidewalk Improvements. Various methods of rehabilitating existing non- compliant sidewalks will be considered. This project requires coordination with TCEQ and TDLR and all proposed pedestrian elements will be ADA compliant with the Texas Accessibility Standards (TAS). Purpose To provide ADA/TDLR compliant sidewalks and ramps identified in the 2015 Sidewalk Master Plan. Project Managers Chris Pousson Engineer Contractor KPA TBD Element Status / Issues Design Finalizing design with Facilities and Park departments. Submitting TCEQ WPAP Exception. Environmental/ Archeological TBD Rights of Way / Easements Will require a couple Temporary Construction easement. TCO has been acquired by Georgetown Title Company. Utility Relocations TBD Construction The intersection including crosswalks are complete at Rock and 7th. There is minor work left on Rock St before they move to 7th and Austin. They plan on moving over to 7th and Austin after Poppy is over. Other Issues Page 39 of 93 Signal Improvements – Various Locations Project No. PRJ000214 TIP No. None October 2021 Project Description Design and preparation of Plans, Specifications, Estimate, Bidding Documents, and construction phase services for the construction of signal improvements for the intersections of Williams Drive & Estrella Crossing, Shell Road & Verde Vista and SE Inner Loop & Rockride Lane. Purpose To better manage traffic movements at the intersection. Project Manager Joel Weaver Engineer KPA Element Status / Issues Design Shell Rd @ Verde Vista and Williams @ Estrella Crossing were bid July 22 with Austin traffic Signal as the low bid and recommended for award. Contracts being executed, work to begin April or May upon receipt of poles. Surveying Completed Environmental/ Archeological TBD Rights of Way TBD Utility Relocations TBD Construction Rock Ride and SE Innerloop contract awarded. Traffic Signal poles and mast arms are on delivery. Contractor EARTC Other Issues None Page 40 of 93 2021 Street Maintenance Project No. PRJ000211 / PRJ000212 TIP No. None Updated - October 2021 Project Description Purpose 2021 CIP Maintenance project consist of furnishing and installing approximately 230,000 square yards of high performance pavement seal (PMM) and approximately 190,000 square yards of high performance pavement seal (HA5) traffic control, and miscellaneous striping in Sun City, Berry Creek, Gatlin Creek, Reata Trails, Quail Valley and Pleasant valley neighborhoods. To provide protection and maintain an overall pavement condition index of 85% Project Manager Daniel Havins Engineer/Engineers KPA, LP Task Status / Issues High performance pavement seal Package #1 (PMM) GTAB Board and Council approved award in May 2021. Contracts signed and accepted. Contractor began work in Sun City on September 20th scheduled to be completed in Sun City on October 12th unless delayed. Work to begin in the Quail Valley/Pleasant Valley area on October 17th. High performance pavement seal Package #2 (HA5) Andale Construction contract was approved by GTAB Board and City Council in May 2021. Areas included in the project are Berry Creek, and Gatlin Creek neighborhoods. Andale has completed 95% of all work. Contractor to return to complete Oakmont in Berry Creek and Cul-de-sac’s in Parkview Estates. Schedule for this work is pending. Page 41 of 93 Page 42 of 93 Page 43 of 93 Page 44 of 93 Page 45 of 93 Page 46 of 93 Project: 2021 Street Maintenance Hot In Place Recycling (HIPR) Project# PRJ000210 October 2021 Project Description: This project will consist of furnishing an installing approximately 115,000 square yards of hot-in-place asphalt recycling, edge milling, adjustment of water valves and manholes, tree pruning, traffic control and miscellaneous striping. Purpose: The purpose of this project is to maintain high Pavement Condition Indices (PCI) by Hot-In-Place asphalt recycling within the City Street Maintenance Program Project Manager: Joel Weaver Engineer: KPA Contractor: Cutler repaving Phase Start Finish Status / Comments Preliminary Engineering 10/ 2020 1/ 2021 ROW / Easements N/A N/A Bid / Award Bid # Bid 4-22 $1,662,185.20 TBD Total cost / Sq. Yd 2021 $14.45 (2020 $13.88) Construction TBD TBD Area off Williams Dr./ HIPR complete. Downtown area aprx 70%, with rain contractor doing cleanup for festival weekend and will begin paving again first week of oct. Post Construction Page 47 of 93 Page 48 of 93 Page 49 of 93 City of Georgetown, Texas Transportation Advisory Board October 8, 2021 S UB J E C T: Airport Monthly R eport – Eric Johnson, P ublic Works Director IT E M S UMMARY: Airport R eports: o Maintenance Building o F uel S ales and O perations R eport o Hangar / Tie-Down Lease R eport o F Y 2021 Ac complishments and P rojec ts o Avgas F uel P ric e C omparison o Jet A F uel P rice C omparis on F IN AN C IAL IMPAC T: None S UB MIT T E D B Y: Debbie Jolly, Airport Bus iness C oordinator AT TAC H ME N T S: Description Type Airport Cover Sheet Cover Memo Maintenance Building Backup Material Fuel Sales and Operations Report Backup Material Hangar Tie-Down Report Backup Material FY 2021 Projects and Accomplishments Backup Material Avgas Fuel Price Comparison Backup Material Jet A Fuel Price Comparis on Backup Material Page 50 of 93 GTAB Meeting Date: October 8, 2021 Item No. AGENDA ITEM COVER SHEET _____________________________________________________________________________________________________________________ SUBJECT: Airport Monthly Report – Eric Johnson, Public Works Director ____________________________________________________________________________________________________________________ ITEM SUMMARY: Airport Reports: o Maintenance Building o Fuel Sales and Operations Report o Hangar / Tie-Down Lease Report o FY 2021 Accomplishments and Projects o Avgas Fuel Price Comparison o Jet A Fuel Price Comparison STAFF RECOMMENDATION: None FINANCIAL IMPACT: None COMMENTS: None ATTACHMENTS: Submitted By: Debbie Jolly, Airport Business Coordinator Jeff Belding Interim Airport Manager Eric Johnson Public Works Director Page 51 of 93 1 MEMORANDUM TO: Georgetown Transportation Advisory Board Members FROM: Eric Johnson, Public Works Director SUBJECT: Airport Maintenance Building DATE: September 30, 2021 The purpose of this memo is to provide GTAB with updates for the Airport Maintenance Facility Building at the Georgetown Municipal Airport. 1. History a. Airport requested and was granted a $700,000 bond in 2019. This was to design and build a new Maintenance Facility that would be able to accommodate all of the maintenance equipment that is currently housed in two storage hangars and in an old, dilapidated hangar. b. The building would have an interior bay for vehicle storage, a tool crib for secure storage of all tools, and supply storage for all the supplies used on the airport. There would also be an outdoor covered wash bay so that equipment could be kept clean and reduce wear and tear. c. An RFP was released in early 2021, with GarverUSA being selected as the design contractor. d. After Design is completed, another RFP will be released for a construction contractor to complete the construction of the building. 2. Current Status a. City Facilities Manager, City Attorney, and GarverUSA are working through the contract, ironing out all details. b. Site has been selected for the new building. This site will be located at the end of Wright Brothers Drive in the woods to the east of Carol’s Corner. This area is not an aeronautical use area and allows easy access to the airport environment. c. As of 6/28/2021 there is no update to the previous information. Page 52 of 93 Georgetown Municipal Airport Fuel Sales and Airport Tower Operations Update For Month of September 2021 YEAR TO DATE YEAR TO DATE 2020 2021 2020 2021 GALLONS % AVGAS 32,576 39,726 394,380 389,284 (5,096)-1.3% JET A 47,215 51,802 399,590 530,040 130,450 24.6% TOTALS 79,791 91,528 793,970 919,324 125,354 13.6% FUEL REPORT FOR MONTH OF SEPTEMBER GALLONS SOLD FOR MONTH CHANGE PREVIOUS/CURRENT TYPE OF FUEL This does not include flyover operations (i.e. handoffs from ABIA approach/departure control to KGTU tower then onto the next ATC). KGTU OPERATIONS FOR THE MONTH OF SEPTEMBER TAKEOFF/LANDING MONTHLY NUMBERS PREVIOUS/CURRENT YR YEAR TO DATE YEAR TO DATE PREVIOUS/CURRENT YR 2020 2021 COUNT % 2020 2021 COUNT % IFR 1026 923 -103 -11% 10217 11171 954 8.5% VFR 3794 4642 848 18% 46278 46595 317 0.7% LOCAL 6591 5946 -645 -11% 68820 61159 -7661 -12.5% TOTALS 11411 11511 100 0.9% 125315 118925 -6390 -5.4% Page 53 of 93 Airport Hangar / Tie-Down Lease Update September 2021 Project Description Hangar / Tie-Down Lease Agreements Purpose Occupancy Rates Unit Stats Total T-Hangars – 130 • 126 Occupied • 3 Vacant • 1 Vacant – Maintenance working on electric door Anticipated Time on Waitlist for most recent listee • 6+ years • 363 persons on T-Hangar wait list Total Storage Units – 16 • 15 Occupied • 1 Vacant Total Tie-Downs – 44 Monthly, 8 for Overnight/Transient Parking • 41 Monthly Occupied • 1 Monthly Vacant – Grass location • 1 Monthly Vacant – Asphalt location • 1 as last resort due to location • 43 persons on Tie-Down wait list T-Hangars Storage Hangars Tie-Downs Total Total 130 16 44 190 Occupied 126 15 41 182 95.79%Percentage Occupied Page 54 of 93 GTU Airport End of FY 2021 In-Work Projects Upgrade to bi-fold door drive motors in Hangars BB & CC. In progress. Install roller poppers in Hangar I. In progress – ½ complete. Convert lights in Hangars E, F, and G to LED. In progress. ITB for new fuel contract. Scoring complete. Waiting for results. RFP for Market Rate Analysis and Lease Term Length Study. Working with purchasing to initiate the process. Virtower, LLC Aircraft monitoring system. Working through IT process to purchase device. Will allow for real time operational counts as well as Based Aircraft Inventory, and Noise Mitigation tools. Maintenance Building. Facilities is leading this project, currently they are working with legal and the consultant, GarverUSA, to develop a contract. Building will be designed by GarverUSA and then will be put out for ITB/RFP/RFQ for construction. $750,000 budget, $700,000 of which is bond funded. Accomplishments for FY 2021 Tower Cab computer monitor replacement Fuel System Maintenance Contract Work with outside Attorney for FAA Part 13 response Cattle guard installation at north gate. 7 Acres cleared of trees and brush in Site 6 area (for Tower visibility from Genesis and wildlife management). Page 55 of 93 Planned Projects FY 2022 Update tower communications equipment. Replace HVAC unit in CTA sheet metal shop. Spray seal Runway 11/29. Spray seal asphalt pavement at north side of AeroJet Center hangar. Spray seal asphalt pavement at Hangars H, I, and J. Install cattle guard at south gate. Install decorative rock around AST and oil recovery tank fences. Replace window shades in Tower Cab. Install Tower alarm when ATC voice recorder is inoperable. Repaint parking spaces and tie-down T’s Page 56 of 93 Page 57 of 93 Page 58 of 93 Page 59 of 93 Page 60 of 93 City of Georgetown, Texas Transportation Advisory Board October 8, 2021 S UB J E C T: C onsideration and pos s ible ac tion to approve the S eptember 10, 2021 minutes of the G eorgetown Transportation Advisory Board. -- Danielle Dutra, Board Liaison IT E M S UMMARY: C onsideration and pos s ible ac tion to approve the S eptember 10, 2021 minutes of the G eorgetown Transportation Advisory Board. F IN AN C IAL IMPAC T: . S UB MIT T E D B Y: Danielle Dutra, Board Liais on AT TAC H ME N T S: Description Type GTAB Minutes 9.10.21 Backup Material Page 61 of 93 Board Members Present: John Hesser, Michael Miles, George (Jerry) McCulley, James Hougnon, Robert Redoutey, & Amanda Parr Board Members Absent: Jake French, Al Hajka Staff Present: Eric Johnson, Elaine Wilson, Wesley Wright, Wayne Nero, Cindy Medrano, Sheila Mitchell, Danielle Dutra, Katherine Clayton, Karrie Pursley, Chris Pousson, Jeff Belding, Will Parrish, Molly Ritter & Aaron St. Pierre Others Present: Larry Brundige, Hugh (Carl) Norris, Ken McHenry, Sarah Bagwell Rudy, John Mutchler Regular Session A. Call to Order: Meeting called to order by Chair John Hesser at 10:02am Georgetown Transportation Advisory Board may, at any time, recess the Regular Session to Convene an Executive Session at the request of the Chair, a Board Member, The City Manager, Assistant City Manager, General Manager of Utilities, City Council Member, or legal counsel for any purpose authorized by the Open Meetings Act, Texas Government Code Chapter 551, and are subject to action in the Regular Session that follows. B. Introduction of Visitors: All board members, visitors, and staff were introduced. C. Public Wishing to Address the Board On a subject not posted on the agenda: Persons may add an item to a future Regular scheduled Board agenda by filing a written request with the Staff Liaison no later than one week prior to the Board meeting. The request must include the speaker’s name and the specific topic to be addressed with sufficient information to inform the board and the public. Only those persons who have submitted a timely request will be allowed to speak. For Board Liaison contact information, please logon to http://georgetown.org/boardsandcommissions At the time of this posting, no persons had signed up to address the Board. Minutes of the Meeting of the Georgetown Transportation Advisory Board and the Governing Body of the City of Georgetown, Texas September 10, 2021 Page 62 of 93 D. August 2021 Airport Monthly Report – Eric Johnson, Public Works Director • Johnson provided the board with the monthly airport update. • Johnson informed the board that Airport Manager, Joseph Carney has retired. They are currently searching for an interim manager to fill the vacancy until a new manager can be hired. • A visitor requested clarification related to jet fuel sales. Staff agreed to answer clarifying questions after the board meeting. • There was one statement submitted for this item. The statement is attached to the minutes. E. September 2021 GTAB Updates – Wesley Wright, P.E., Systems Engineering Director/ Chris Pousson, CIP Manager • Wright provided the board with transportation updates throughout the City of Georgetown. • Board asked when the last round of individual meetings with property owners on D.B. Woods Road will take place. Wright stated these meetings will begin in the second half of September and be completed by the end of October. • Board had clarifying questions on a previous statement, “New section pushed out to residents”, regarding a potential median on D.B Woods Road. Wright clarified that they will not be moving forward with this median. • Board Vice Chair, Miles, requested information on who to contact regarding Annexation Ordinance 2005-103 related to D.B. Woods Road. Is D.B Woods a major or minor arterial? City of Georgetown Transportation Planner Will Parrish verified that University to Oak Ridge is a minor arterial, and Oak Ridge to Williams Drive is a major arterial. Wright will work to obtain ordinance 2005-103 information. • The Overall Transportation Plan (OTP) will be updated in 2022, funding has already been allocated in the FY22 budget. Page 63 of 93 F. August 2021 Financial Overview of Airport Fund and Budget Report Workshop – Elaine Wilson, Assistant Finance Director • Wilson provided the board with the August financial overview related to the airport. • Council will approve the final FY22 budget on September 28, 2021. Legislative Regular Agenda G. Consideration and possible action to approve the August 13, 2021, minutes of the Georgetown Transportation Advisory Board – Danielle Dutra, Board Liaison • MOTION by Hougnon, second by Redoutey. APPROVED unanimously 6-0-2 French & Hajka Absent H. Consideration and possible recommendation to approve an agreement with D.I.J Construction of Bertram, Texas for an annual Street Striping contract, in an amount not to exceed $180,264.00. – Eric Johnson, Public Works Director/Molly Ritter, Public Works Operations Manager • Johnson explained the process of “piggybacking” that the City of Georgetown uses to work off existing contracts with other local government entities to avoid creating a new contract for services from scratch. For this contract COG will piggyback off Williamson County contract IFB #T2526. • Board had clarifying question on what type of projects this contract will cover. Johnson clarified that this contract will only cover old faded striping replacement throughout the City. All new road projects include striping in their individual contracts. • MOTION by Hougnon, second by Miles. APPROVED unanimously 6-0- 2 French & Hajka Absent. I. Consideration and possible recommendation to approve the Texas Department of Transportation Grant for Routine Airport Maintenance -Eric Johnson, Public Works Director. • MOTION by Miles, second by McCulley. APPROVED unanimously 6-0- 2 French & Hajka Absent Page 64 of 93 Adjournment • MOTION by Miles, second by Parr. APPROVED unanimously 6-0-2 French & Hajka Absent The meeting adjourned at 10:54 AM John Hesser - Chair Robert Redoutey – Secretary Danielle Dutra – GTAB Board Liaison Page 65 of 93 Page 66 of 93 Page 67 of 93 City of Georgetown, Texas Transportation Advisory Board October 8, 2021 S UB J E C T: C onsideration and pos s ible ac tion to rec ommend approval of Tas k O rder KPA-22-011 for profes s ional engineering des ign services for F Y22 S treet Maintenance, S idewalks, and C urb and G utter improvements with Kas berg P atric k & Assoc iates of G eorgetown, Texas in the amount of $713,250.00 -- Wesley Wright, P E, S ystems Engineering Direc tor/C hris P ousson, C I P Manager IT E M S UMMARY: T his tas k o rd er is fo r c ivil engineering d es ign, b id d ing and c o nstruc tion services related to multiple F Y22 C apital Improvement P lan projec ts inc luding: S treet Maintenanc e - Hot-in-P lace R ec yc ling is s cheduled to c o ntinue in the downto wn area, north o f the area c urrently being c o mp leted, generally in the area bound b y 6th, Blue Hole, Aus tin Avenue, & S cenic. Als o includ ed in the F Y22 s treet maintenanc e plan is the area north of Williams Drive, generally b o und by Wagon W heel, Algerita, Lakeway, and Williams Drive. A d etailed map sho wing eac h street is attac hed for referenc e. S treet Maintenanc e - High P erformance P avement S eal is proposed for multip le neighb o rhoods inc luding far no rthwest p o rtions of S un C ity, s treets in C hurchill F arms , G eorgetown C rossing and Mead o ws of G eorgetown s ubdivis ions. A detailed map showing each proposed s treet is inc luded for reference. S idewalks - T he F Y22 C I P Bud get inc ludes a c o ntinuation o f P rio rity 1 S idewalk improvements in the Downtown Area. P rior year fund ing inc luded the immediate Do wntown S quare and new C ity Hall area. C urrent year fund ing will extend o ut fro m that area and c o ntinue to foc us on the Do wntown O verlay Dis tric t. C urb and G utter repairs for vario us loc ations o f o ld /damaged /no n-func tioning curb & gutter is also inc luded in this sc ope of des ign services. F IN AN C IAL IMPAC T: F unds are inc luded in the F Y22 C apital Improvement Budget S UB MIT T E D B Y: Wesley Wright, P.E., S ystems Engineering Direc tor / C hris P ousson, C I P Manager. AT TAC H ME N T S: Description Type KPA-22-001-TO Backup Material Page 68 of 93 TASK ORDER Georgetown – Revised 3.11 EJCDC E-505 Standard Form of Agreement Between Owner and Engineer Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. Attachment 1 – Task Order Form Page 1 of 4 Task Order In accordance with paragraph 1.01 of the Master Services Agreement between Owner and Kasberg, Patrick & Associates, LP (“Engineer”) for Professional Services – Task Order Edition, dated March 23, 2016, ("Agreement"), Owner and Engineer agree as follows: 1. Specific Project Data A. Title: 2022 Street Maintenance Projects B. Description: Professional Engineering Services for the preparation of plans, specifications, bidding documents and construction administration for the City of Georgetown’s 2022 Street Maintenance Projects. The project consists of the two (2) different street maintenance methods: hot in place recycling (HIPR) and high performance pavement seal application, as well as, the 2022 Curb & Gutter Replacement Project and 2022 Downtown Sidewalk Improvements. Each project will also include the evaluation of all existing pedestrian ramps along the proposed project route to determine if the ramps are ADA compliant. Any pedestrian ramp that identified as non-compliant will be removed and replaced in conjunction with this project. This project will also include Onsite Representation Services for the high performance pavement seal applications. C. City of Georgetown Project Number: __________________________________________ D. City of Georgetown General Ledger Account No.: ________________________________ E. City of Georgetown Purchase Order No.: _______________________________________ F. Master Services Agreement, Contract Number: 21-0115-MSA_____________________ 2. Services of Engineer See Exhibit A, Scope of Services, attached 3. Owner's Responsibilities Owner shall have those responsibilities set forth in the Agreement subject to the following: City to provide asbuilt/record drawing of City owned utilities located in the proposed project areas. 4. Times for Rendering Services Phase Completion Date HIPR & HPPS Projects February 1, 2022 2021 C&G, FY 22 SW May 15, 2022 Task Order No. KPA-22-001-TO, consisting of _____ pages. 14 Page 69 of 93 TASK ORDER Georgetown – Revised 3.11 EJCDC E-505 Standard Form of Agreement Between Owner and Engineer Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. Attachment 1 – Task Order Form Page 2 of 4 Bidding: HIPR & HPPS Projects March 1, 2022 2022 C&G & FY22 Sidewalks June 15, 2022 Construction Administration/Onsite Representation: HIPR & HPPS Projects October 1, 2022 2022 C&G & FY22 Sidewalks January 1, 2023 5. Payments to Engineer A. Owner shall pay Engineer for services rendered as follows: Category of Services Compensation Method Lump Sum of Compensation for Services Basic Services Final Design, Bidding, Construction Phase A. Lump Sum $713,250.00 B. The terms of payment are set forth in Article 4 of the Agreement unless modified in this Task Order. 6. Consultants: Kasberg, Patrick & Associates, LP – Georgetown, Texas John Aldridge, Inspector – Georgetown, Texas All County Surveying – Georgetown, Texas 7. Other Modifications to Agreement: None 8. Attachments: Exhibit A – Scope of Services Exhibit B – Fee Schedule Summary Exhibit C – Overall Project Exhibit 9. Documents Incorporated By Reference: The Agreement effective March 23, 2016. Page 70 of 93 TASK ORDER Georgetown – Revised 3.11 EJCDC E-505 Standard Form of Agreement Between Owner and Engineer Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. Attachment 1 – Task Order Form Page 3 of 4 Terms and Conditions: Execution of this Task Order by Owner and Engineer shall make it subject to the terms and conditions of the Agreement (as modified above), which Agreement is incorporated by this reference. Engineer is authorized to begin performance upon its receipt of a copy of this Task Order signed by Owner. The Effective Date of this Task Order is , 2022. OWNER: ENGINEER: By: By: Name: Josh Schroeder Name: Alvin R (Trae) Sutton III, PE.CFM Title: Mayor, City of Georgetown Title: Principal Engineer License or Firm’s Certificate No. F-510 State of: Texas Date: Date: APPROVED AS TO FORM: ________________________________________ ________________________________________ City Attorney Septmeber 27, 2021 Page 71 of 93 TASK ORDER Georgetown – Revised 3.11 EJCDC E-505 Standard Form of Agreement Between Owner and Engineer Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. Attachment 1 – Task Order Form Page 4 of 4 Owner: Engineer: Designated Representative for Task Order: Designated Representative for Task Order: Name: Chris Pousson Name: Trae Sutton, P.E., CFM Title: CIP Manager Title: Principal Address: 300-1 Industrial Ave. Georgetown, TX 78626 Address: 800 South Austin Avenue Georgetown, TX 78626 E-Mail Address: Chris.Pousson@georgetown.org E-Mail Address: TSutton@kpaengineers.com Phone: 512-930-8162 Phone: 512-819-9478 Fax: Fax: 254-733-6667 Page 72 of 93 EXHIBIT A – DETAILED PROJECT SCOPE SERVICES PROVIDED BY ENGINEER KASBERG, PATRICK & ASSOCIATES, LP GEORGETOWN, TEXAS Project Description: This project involves final design, bidding, construction administration and onsite representation services for the City of Georgetown’s 2022 Street Maintenance Projects. The project consists of two (2) different street maintenance methods: hot in place recycling (HIPR) and high-performance pavement seal applications, as well as the 2022 Curb and Gutter Replacement Project, and 2022 Downtown Sidewalk Improvements. Each project will also include the evaluation of all existing pedestrian ramps along the proposed project route to determine if the ramps are ADA compliant. Any pedestrian ramp that identified as non-compliant will be removed and replaced in conjunction with this project. This project will also include Onsite Representation Services for the high-performance pavement seal application. This service will be provided during the construction phase of these projects and will consist of construction observation, daily construction reports, product installation evaluation, project communication with the City, and general conformance with plans and specifications by the contractor and replaced in conjunction with this project For the hot in place recycling (HIPR Process) application, each street location will include the evaluation of the existing pedestrian ramps along the proposed project route to determine if the ramps are ADA compliant. Any pedestrian ramp that identified as non-compliant will be removed and replaced in conjunction with this project. The streets that are proposed to receive the HIPR treatment can be found on the attached Exhibit C. The high-performance pavement seal application is a high-density mineral bond asphalt emulsion that includes a blend of fine aggregates. The application limits oxidative damage to the roadway that is a result of sun exposure and moisture. The streets proposed for high performance pavements seals in this year’s project are identified on the attached Exhibit C. This task order also involves final design, bidding and construction administration services for the City of Georgetown’s 2022 Curb & Gutter Replacement Project. The exact location of the curb and gutter replacement will be finalized prior to surveying being authorized. The 2022 Curb & Gutter Replacement project will remove the existing square top curb and replace with standard curb and gutter. We will also include the evaluation of all existing pedestrian ramps that intersect the proposed project route to determine if the ramps are ADA compliant. Any pedestrian ramp that identified as non -compliant will be removed and in conjunction with this project. The FY22 Downtown Sidewalk Improvements Project will include sidewalk and ADA improvements at various locations in and around the downtown area, and other pedestrian connection points in the downtown area. The services for this project shall include the performing of topographic surveys, preparation of plans and technical specifications, bidding services, product submittal review and construction administration services. Services also include Environmental Phase I Investigations. Exact locations for the sidewalk improvements will be determined by City Staff prior to performing topographic surveys. Page 73 of 93 Scope of Services: 2022 Street Maintenance Projects Scope of Services: The scope of services associated with these projects is as follows: I. Design Phase a. Data Collection, Permits, and Utility Coordination i. The ENGINEER will utilize existing topographic information and City data to develop surfaces for the proposed street maintenance streets. ii. The ENGINEER will determine areas within the project that require tree pruning and care. Details and procedures will be developed, coordinated, and approved by the City of Georgetown arborist. iii. The ENGINEER will coordinate with utility companies and other City departments to identify any possible conflicts and/or proposed utility improvements on the proposed street maintenance projects. iv. The ENGINEER will investigate general Drainage within the project area and conveyance to positive flow at the connection points of the project to existing conditions. Any areas of concern or non-conveyance will be reported to the City of Georgetown Staff and discussed. v. The ENGINEER will review curbs, Driveways, etc. to determine conflicts with existing private property connections to the project. vi. The ENGINEER will conduct a review of all pedestrian ramps to determine their ADA compliance status along the project routes. vii. The ENGINEER will incorporate City of Georgetown imagery into the GIS data and integrate the two as a model. b. Develop Design Plans i. The ENGINEER will utilize any existing topographic data and surface model to develop plan sheets identifying project limits for each s treet maintenance application. The plan sheets shall identify locations of existing water valve, fire hydrant, wastewater manholes and other existing utilities located within the project limits. ii. The ENGINEER will develop plan sheets with elevation call outs for in-house curb and gutter replacement projects. iii. The ENGINEER will develop erosion control/sedimentation/tree protection plans. iv. The ENGINEER will develop traffic control, striping and signing plans for each street maintenance application location. v. The ENGINEER will develop all standard and special details for each construction method. vi. The ENGINEER will develop plan sheets identifying non-compliant ADA pedestrian ramps that are to be replaced as part of this project. The plan sheets will identify location, ramp type and any sidewalk improvement required to bring the ADA ramp into compliance. vii. The ENGINEER will develop a quantity take-off and an estimate of probable construction cost for each street maintenance method. Page 74 of 93 c. Develop Bidding Documents for the Project i. The ENGINEER will develop detailed technical specifications for each street maintenance method. ii. The ENGINEER will develop a detailed quantity take off for work to be performed for each street maintenance method. The ENGINEER will utilize this detailed quantity take off to prepare a bid schedule for the project. iii. The ENGINEER will prepare the contract document project manual. d. Review Plans with City Staff, Incorporate Comments i. The ENGINEER will schedule a meeting with City Staff to review the plans at the 50%, 75% and 90% design stages to discuss issues and report any dilemmas that have been encountered. ii. The ENGINEER will receive all City Staff comments and incorporate into the plans. Once comments have been incorporated the ENGINEER will schedule a second meeting with City Staff to review the revised plans. iii. The ENGINEER will submit the five sets of final plans to City Staff. II. Bidding a. The ENGINEER will develop the invitation to bid and deliver to City Staff for advertising the project for public bidding. The ENGINEER will also solicit bids from past contractors to acquire as competitive a bidding process as possible; b. The ENGINEER will manage and distribute bidding documents; c. The ENGINEER will prepare for the Pre-Bid Conference, develop an agenda and sign in sheet, conduct the Pre-Bid Conference, take notes at the conference, prepare minutes and incorporate into the addenda; d. The ENGINEER will receive all questions from bidders, log the questions and answer in the form of an addenda; e. The ENGINEER will conduct the bid letting, receive all bids, tabulate the bids and certify them; f. The ENGINEER will research the low bidder(s) qualifications and recommend award to the City of Georgetown. III. Construction Administration a. The ENGINEER will prepare contract documents; forward those to the contractor awarded the project by the Georgetown City Council. Once the contractor has executed the contract documents, they will be checked for proper documentation and forwarded to the City of Georgetown for execution; b. The ENGINEER will schedule and conduct the Pre-Construction Conference. Minutes from the conference will be taken and distributed; c. The ENGINEER will receive and review all submittals and material samples for the project. Documentation for the submittals will be generated and distributed to the City of Georgetown and the contractor; d. The ENGINEER will hold regularly scheduled construction progress meetings. These meetings will include meeting agendas covering project specifics and schedules. Notes will be taken by the ENGINEER at the meetings. Minutes will Page 75 of 93 then be developed and distributed to the City of Georgetown Staff and the contractor; e. The ENGINEER will make periodic visits the project site. These site visits are utilized to perform a general overview of the project and answer any questions the contractor may have. The City of Georgetown will provide daily on-site representation for the project; f. The ENGINEER will develop pay estimate forms for the project. These will be distributed to City Staff and the contractor. The ENGINEER will review the pay requests with City Staff; g. The ENGINEER will conduct a final walk through of the project. Punch list items will be generated during this review. A letter addressed to City Staff will be generated discussing the findings of the walk through. The contractor will be copied on this letter as well; h. The ENGINEER will develop final record Drawings for the City of Georgetown Staff. The record Drawings will be presented in the form of a DVD with pdf of each plan sheet and a full 11x17 hard copy. IV. Onsite Representation a. The ENGINEER will observe equipment and materials for compliance with the plans and specifications and approved shop drawing submittals; b. The ENGINEER will verify installed quantities and materials on hand for monthly pay estimates to Contractors. c. The ENGINEER will confirm and note changes on as-built plans submitted by Contractors. d. The ENGINEER will prepare written daily reports on the City of Georgetown Inspection Form. The information provided will include construction activities summarizing work performed, quantities installed, number of laborers on site, equipment used, weather conditions and significant activities and test results (if required). 2022 Curb & Gutter Replacement Scope of Services: The scope of services associated with this project is as follows: I. Design Phase a. Data Collection, Permits, and Utility Coordination i. The ENGINEER will obtain and develop detailed topographical survey for all curb and gutter replacement projects. ii. The ENGINEER will coordinate with utility companies and other City departments to identify any possible conflicts and/or proposed utility improvements on the proposed roadway rehabilitations. iii. The ENGINEER will investigate general drainage within the project area and conveyance to positive flow at the connection points of the project to existing conditions. Any areas of concern or non-conveyance will be reported to the City of Georgetown Staff and discussed. iv. The ENGINEER will review curbs, driveways, etc. to determine conflicts with existing private property connections to the project. Page 76 of 93 v. The ENGINEER will conduct a review of all pedestrian ramps to determine their ADA compliance status along the project routes. vi. The ENGINEER will incorporate City of Georgetown imagery into the field surveys and integrate the two as a model. b. Develop Design Plans i. The ENGINEER will utilize the survey data and surface model to develop plan and profile sheets for the proposed curb and gutter replacement projects. The ENGINEER will illustrate all proposed slopes, typical sections, plan/profiles, and improvement locations. ii. The ENGINEER will develop plan/profiles for curb and gutter replacement projects. iii. The ENGINEER will develop erosion control/sedimentation/tree protection plans. iv. The ENGINEER will develop traffic control, striping and signing plans if required. v. The ENGINEER will develop all standard and special details for each construction method. vi. The ENGINEER will develop a quantity take-off and an estimate of probable construction cost for the project. c. Develop Technical Specifications for the Project i. The ENGINEER will develop detailed technical specifications for the Curb & Gutter. d. Review Plans with City Staff, Incorporate Comments i. The ENGINEER will schedule a meeting with City Staff to review the plans at the 60% and 90% design stages to discuss issues and report any dilemmas that have been encountered. ii. The ENGINEER will receive all City Staff comments and incorporate into the plans. Once comments have been incorporated the ENGINEER will schedule a second meeting with City Staff to review the revised plans. iii. The ENGINEER will submit the five sets of final plans to City Staff. II. Bidding a. The ENGINEER will develop the invitation to bid and deliver to City Staff for advertising the project for public bidding. The ENGINEER will also solicit bids from past contractors to acquire as competitive a bidding process as possible. b. The ENGINEER will manage and distribute bidding documents. c. The ENGINEER will prepare for the Pre-Bid Conference, develop an agenda and sign in sheet, conduct the Pre-Bid Conference, take notes at the conference, prepare minutes and incorporate into the addenda. d. The ENGINEER will receive all questions from bidders, log the questions and answer in the form of an addenda. e. The ENGINEER will conduct the bid letting, receive all bids, tabulate the bids and certify them. f. The ENGINEER will research the low bidder(s) qualifications and recommend award to the City of Georgetown. Page 77 of 93 III. Construction Administration a. The ENGINEER will prepare contract documents; forward those to the contractor awarded the project by the Georgetown City Council. Once the contractor has executed the contract documents, they will be checked for proper documentation and forwarded to the City of Georgetown for execution. b. The ENGINEER will schedule and conduct the Pre-Construction Conference. Minutes from the conference will be taken and distributed. c. The ENGINEER will receive and review all submittals and material samples for the project. Documentation for the submittals will be generated and distributed to the City of Georgetown and the contractor. d. The ENGINEER will hold regularly scheduled construction progress meetings. These meetings will include meeting agendas covering project specifics and schedules. Notes will be taken by the ENGINEER at the meetings. Minutes will then be developed and distributed to the City of Georgetown Staff and the contractor. e. The ENGINEER will make periodic visits the project site. These site visits are utilized to perform a general overview of the project and answer any questions the contractor may have. The City of Georgetown will provide daily on-site representation for the project. f. The ENGINEER will develop pay estimate forms for the project. These will be distributed to City Staff and the contractor. The ENGINEER will review the pay requests with City Staff. g. The ENGINEER will conduct a final walk through of the project. Punch list items will be generated during this review. A letter addressed to City Staff will be generated discussing the findings of the walk through. The contractor will be copied on this letter as well. h. The ENGINEER will develop final record drawings for the City of Georgetown Staff. The record drawings will be presented in the form of a DVD with pdf of each plan sheet and a full 11x17 hard copy. 2022 Downtown Sidewalk Improvements Scope of Services: The scope of services associated with this project is as follows: I. Design Phase a. Data Collection, Permits, and Utility Coordination i. The ENGINEER will obtain and develop detailed topographical survey for each area. ii. The ENGINEER will coordinate with utility companies and other City departments to identify any possible conflicts and/or proposed utility improvements on the proposed roadway rehabilitations. iii. The ENGINEER will investigate general drainage within the project area and conveyance to positive flow at the connection points of the project to existing conditions. Any areas of concern or non-conveyance will be reported to the City of Georgetown Staff and discussed. iv. The ENGINEER will review curbs, driveways, etc. to determine conflicts with existing private property connections to the project. Page 78 of 93 v. The ENGINEER will conduct a review of all pedestrian ramps to determine their ADA compliance status along the project routes. vi. The ENGINEER will incorporate City of Georgetown imagery into the field surveys and integrate the two as a model. b. Develop Design Plans i. The ENGINEER will utilize the survey data and surface model to develop plan and profile sheets for the proposed curb and gutter replacement projects. The ENGINEER will illustrate all proposed slopes, typical sections, plan/profiles, and improvement locations. ii. The ENGINEER will develop plan/profiles for the following: a. Sidewalk Improvements. b. Pedestrian Ramps. iii. The ENGINEER will develop erosion control/sedimentation/tree protection plans. iv. The ENGINEER will develop traffic control, striping and signing plans if required. v. The ENGINEER will develop all standard and special details for each construction method. vi. The ENGINEER will develop a quantity take-off and an estimate of probable construction cost for each project. c. TDLR Clearances i. The ENGINEER will submit the final design plans to TDLR for project review and registration. The fee associated with project review, registr ation and inspection is included in Exhibit B of this Task Order. d. TCEQ Clearances i. The ENGINEER shall prepare an Exception Request based on the sidewalk improvements being located within the downtown water quality pond drainage area. ii. The ENGINEER will develop plans, reports and other required documents to submit to TCEQ an Exception Request for Edwards Aquifer clearances. The TCEQ fee for this type of approval has been included in Exhibit B of this Task Order; e. Develop Project Details i. The ENGINEER will develop details for the project to include: 1. Sidewalk Details 2. Curb & Gutter Details (If Required) 3. Drainage Details (If Required) 4. Misc. Details f. Develop Technical Specifications for the Project i. The ENGINEER will develop detailed technical specifications for the Project. g. Review Plans with City Staff, Incorporate Comments i. The ENGINEER will schedule a meeting with City Staff to review the plans at the 60% and 90% design stages to discuss issues and report any dilemmas that have been encountered. Page 79 of 93 ii. The ENGINEER will receive all City Staff comments and incorporate into the plans. Once comments have been incorporated the ENGINEER will schedule a second meeting with City Staff to review the revised plans. iii. The ENGINEER will submit the five sets of final plans to City Staff. II. Bidding a. The ENGINEER will develop the invitation to bid and deliver to City Staff for advertising the project for public bidding. The ENGINEER will also solicit bids from past contractors to acquire as competitive a bidding process as possible. b. The ENGINEER will manage and distribute bidding documents. c. The ENGINEER will prepare for the Pre-Bid Conference, develop an agenda and sign in sheet, conduct the Pre-Bid Conference, take notes at the conference, prepare minutes and incorporate into the addenda. d. The ENGINEER will receive all questions from bidders, log the questions and answer in the form of an addenda. e. The ENGINEER will conduct the bid letting, receive all bids, tabulate the bids and certify them. f. The ENGINEER will research the low bidder(s) qualifications and recommend award to the City of Georgetown. III. Construction Administration a. The ENGINEER will prepare contract documents; forward those to the contractor awarded the project by the Georgetown City Council. Once the contractor has executed the contract documents, they will be checked for proper documentation and forwarded to the City of Georgetown for execution. b. The ENGINEER will schedule and conduct the Pre-Construction Conference. Minutes from the conference will be taken and distributed. c. The ENGINEER will receive and review all submittals and material samples for the project. Documentation for the submittals will be generated and distributed to the City of Georgetown and the contractor. d. The ENGINEER will hold regularly scheduled construction progress meetings. These meetings will include meeting agendas covering project specifics and schedules. Notes will be taken by the ENGINEER at the meetings. Minutes will then be developed and distributed to the City of Georgetown Staff and the contractor. e. The ENGINEER will make periodic visits the project site. These site visits are utilized to perform a general overview of the project and answer any questions the contractor may have. The City of Georgetown will provide daily on-site representation for the project. f. The ENGINEER will develop pay estimate forms for the project. These will be distributed to City Staff and the contractor. The ENGINEER will review the pay requests with City Staff. g. The ENGINEER will conduct a final walk through of the project. Punch list items will be generated during this review. A letter addressed to City Staff will be generated discussing the findings of the walk through. The contractor will be copied on this letter as well. h. The ENGINEER will develop final record drawings for the City of Georgetown Staff. Page 80 of 93 EXHIBIT B FEE SCHEDULE KPA 2022 Street Maintenance Projects Kasberg, Patrick & Associates, Georgetown, Texas September 21, 2021 Bid Package Roadway Repair Method Proposed Professional Services Fee Opinion of Probable Construction Costs Total Project Cost 1 Hot in Place Recycling (HIPR)308,700.00$ 2,441,300.00$ 2,750,000.00$ 2 High Performance Pavement Seal (HPPS)136,100.00$ 1,113,900.00$ 1,250,000.00$ 3 Onsite Representation - HPPS 73,200.00$ 73,200.00$ 4 2022 Curb & Gutter Replacement 65,250.00$ 434,750.00$ 500,000.00$ 5 2022 Downtown Sidewalk Improvements 130,000.00$ 870,000.00$ 1,000,000.00$ Total Project Costs 713,250.00$ 4,859,950.00$ 5,573,200.00$ Summary of Proposed Project Costs Page 81 of 93 KASBERG, PATRICK & ASSOCIATES, LP CONSULTING ENGINEERS GEORGETOWN, TEXAS 78626 FIRM REGISTRATION NUMBER F-510 PROPOSED 2022-2023 STREET MAINTENANCE PROJECTS EXHIBIT C 0 HORIZONTAL SCALE IN FEET 2500 5000 N O R T H © 20 1 4 K a s b e r g , P a t r i c k & A s s o c i a t e s , L P FI L E : P: \ G e o r g e t o w n \ 2 0 2 1 \ d e v e l o p m e n t \ s t r e e t m a i n t e n a n c e p r o j e c t s \ 2 0 2 2 - 2 3 S T R E E T M A I N T E N A N C E P R O J E C T S . d w g L A S T S A V E D : 9/ 2 7 / 2 0 2 1 1 0 : 3 1 : 5 6 A M LA Y O U T : 11 x 1 7 e x h i b i t GEORGETOWNTEXAS EST. 1848 LEGEND GEORGETOWN CITY LIMITS GEORGETOWN ETJ BID PROJECTS HIGH PERFORMANCE PAVEMENT SEAL (HPPS) HOT IN PLACE RECYCLING (HIPR) Page 82 of 93 City of Georgetown, Texas Transportation Advisory Board October 8, 2021 S UB J E C T: C onsideration and pos s ible ac tion to award a contrac t to DeNuc ci C onstruc tors, LLC of Austin, Texas for the C onstruc tion of the Williams Drive @ Lakeway Intersec tion improvements in the amount of $1,448,918.00 -- Wesley Wright, P.E., S ystems Engineering Direc tor / C hris P ousson, C I P Manager IT E M S UMMARY: T his projec t cons is ts of adding a dedic ated left hand turn lane from Booty’s C ros s ing to Williams Drive and a dedic ated right hand turn lane from Williams Drive onto Lakeway Drive at the Williams Drive and Lakeway Drive Intersec tion. T he work propos ed will include the new turn lanes , removal of the existing traffic signal, ins tallation of new traffic signal, pedestrian poles , ada c ompliant ramps, c ros s walks , pedes trian sidewalk, drainage improvements, water quality improvements, striping, and other misc ellaneous cons truction activities . T his projec t was advertis ed in the Williams on C ounty S un on S unday Augus t 1st, S unday Augus t 8th, and S unday Augus t 15th. Bids were opened at 2:00 p.m. on August 26th, 2021. We rec eived two (2) c ompetitive bids . T he low qualified bidder for the projec t is DeNucc i C ons tructors , LLC of Aus tin, Texas . DeNuc ci C onstruc tors, LLC . has succ es s fully c ompleted s imilar intersec tion improvements for s everal other C entral Texas Municipalities in the recent pas t. Kasberg, P atric k & Assoc iates have reviewed the current workload, references and cons truction history of DeNucc i C ons tructors , LLC , and their s ubc ontractors . S TAF F R E C O MME N D AT IO N S: S taff and Kas berg, P atrick & As s ociates , LP of G eorgetown, Texas , recommend that a contrac t be awarded to DeNuc ci C onstruc ters, LLC for the cons truction of the Williams Drive @ Lakeway Intersec tion improvements in the amount of $1,448,918.00 F IN AN C IAL IMPAC T: F unding for this projec t is generated from the 2015 Voter Approved R oad Bond P rogram and is available in the Trans portation C I P F und. S UB MIT T E D B Y: Wesley Wright, P.E., S ystems Engineering Direc tor/C hris P ousson, C I P Manager. AT TAC H ME N T S: Description Type Letter of Recommendation Backup Material Bid Tab Backup Material Project Exhibit Backup Material Page 83 of 93 Page 84 of 93 September 20, 2021 Mr. Joel Weaver Systems Engineering Project Manager City of Georgetown 300-1 Industrial Avenue Georgetown, Texas 78626-8445 Re: City of Georgetown Williams at Lakeway Intersection Improvements Georgetown, Texas Dear Mr. Weaver, Bids were received by the City of Georgetown until 2:00 P.M. on Thursday, August 26, 2021, for the above referenced project. There were two (2) competitive bids submitted for this project. A detailed bid tabulation of this bid is attached for your use. The attached Exhibit A depicts the proposed improvements for the project. This project consists of adding a dedicated left hand turn lane from Booty’s Crossing to Williams Drive and a dedicated right hand turn lane from Williams Drive onto Lakeway Drive at the Williams Drive and Lakeway Drive Intersection. The work proposed will include the new turn lanes, removal of the existing traffic signal, installation of new traffic signal, pedestrian poles, ada compliant ramps, crosswalks, pedestrian sidewalk, drainage improvements, water quality improvements, striping, and other miscellaneous construction activities. The low qualified bidder for the project is DeNucci Constructors, LLC of Austin, Texas. DeNucci Constructors, LLC. has successfully completed similar intersection improvements for several other Central Texas Municipalities in the recent past. We have reviewed the current workload, references and construction history of DeNucci Constructors, LLC, and their subcontractors. As a result of our findings, we recommend that a contract be awarded to DeNucci Constructors, LLC in the total bid amount of $1,448,918.00. Sincerely, Alvin R. (Trae) Sutton III, P.E., CFM ARS/ xc: Mr. Wesley Wright, PE, City of Georgetown Mr. Joel Weaver, City of Georgetown Ms. Nicole Abrego, City of Georgetown Mr. Justin Goolsby, TxDOT Mr. Paul DeNucci, DeNucci Constructors, LLC 2020-156-40 KASBERG, PATRICK & ASSOCIATES, LP CONSULTING ENGINEERS Texas Firm F-510 Temple RICK N. KASBERG, P.E. Georgetown 19 North Main Street R. DAVID PATRICK, P.E., CFM 800 South Austin Avenue Temple, Texas 76501 THOMAS D. VALLE, P.E. Georgetown, Texas 78626 (254) 773-3731 GINGER R. TOLBERT, P.E. (512) 819-9478 ALVIN R. “TRAE” SUTTON, III, P.E., CFM JOHN A. SIMCIK, P.E., CFM Page 85 of 93 CSJ # 0914-05-201 STP 2021(746)MM BID TABULATION CITY OF GEORGETOWN WILLIAMS AT LAKEWAY INTERSECTION IMPROVEMENTS Bid No. 202163 August 26, 2021; 2:00 PM 2019-166-40 BIDDER INFORMATION Bid TxDOT Estimated Unit Bid Data Unit Extended Unit Extended Unit Extended No.Spec No.Quantity Description Price Amount Price Amount Price Amount 1 100 9 STA Provide Labor,Equipment,Tools and Supervision to Complete Preparation of Right-of-way $1,500.00 $13,500.00 $8,000.00 $72,000.00 $8,000.00 $72,000.00 2 104 45 CY Remove Existing Concrete 125.00 5,625.00 60.00 2,700.00 198.00 8,910.00 3 105 750 SY Remove Existing Asphalt 10.00 7,500.00 60.00 45,000.00 38.00 28,500.00 4 110 980 CY Unclassified Excavation of Existing Roadway & ROW 18.00 17,640.00 10.00 9,800.00 44.00 43,120.00 5 132 75 CY Unclassified Fill For Roadway & ROW 12.00 900.00 20.00 1,500.00 42.00 3,150.00 6 132 150 CY Select Fill (Offsite) For Roadway & ROW 25.00 3,750.00 20.00 3,000.00 64.00 9,600.00 7 164 4,000 SY Install,Maintain &Establish Hydromulch with Flexible Growth Medium, Including 4-Inch Top Soil 3.00 12,000.00 12.00 48,000.00 8.00 32,000.00 8 247 2,100 SY Furnish & Install 12.5" Crushed Limestone Base Material 20.00 42,000.00 25.00 52,500.00 63.00 132,300.00 9 260 2,100 SY Furnish & Install 6" Moisture Conditioned Subgrade 8.00 16,800.00 10.00 21,000.00 4.00 8,400.00 10 340 1,500 SY Furnish & Install 2" Type D HMAC, Including Tack Coat 15.00 22,500.00 20.50 30,750.00 23.00 34,500.00 11 340 1,500 SY Furnish & Install 4" Type B HMAC, Including Prime Coat 30.00 45,000.00 35.25 52,875.00 36.00 54,000.00 12 340 2,100 SY Furnish & Install 7" Type B HMAC, Including Prime Coat 40.00 84,000.00 51.50 108,150.00 59.00 123,900.00 13 340 250 TN Furnish & Install Type D HMAC, Including Tack Coat Patch 250.00 62,500.00 210.00 52,500.00 235.00 58,750.00 14 402 100%LS Submit Trench Safety Plan Prepared &Signed by P.E.,in Conformance with State Law and OSHA, for Base Bid 1,000.00 1,000.00 2,000.00 2,000.00 800.00 800.00 15 402 415 LF Implement & Follow Trench Safety Plan (Pipe)2.50 1,037.50 2.00 830.00 3.00 1,245.00 16 402 6,600 SF Implement & Follow Trench Safety Plan (Structures)2.50 16,500.00 0.50 3,300.00 3.00 19,800.00 17 416 11 LF DRILL SHAFT (TRF SIG POLE) (30 IN)450.00 4,950.00 325.00 3,575.00 750.00 8,250.00 18 416 39 LF DRILL SHAFT (TRF SIG POLE) (36 IN)600.00 23,400.00 375.00 14,625.00 820.00 31,980.00 19 421 80 SY Furnish & Install Concrete Paver Base for Brick Pavers in Island 50.00 4,000.00 45.00 3,600.00 125.00 10,000.00 20 432 100 SY Furnish & Install Concrete Riprap 60.00 6,000.00 63.00 6,300.00 125.00 12,500.00 21 460 1 EA Connect to Existing CMP Culverts Crossing Booty's Crossing 4,500.00 4,500.00 2,500.00 2,500.00 3,300.00 3,300.00 22 462 220 LF Furnish & Install 2- 5'x2' RCBs 750.00 165,000.00 800.00 176,000.00 840.00 184,800.00 23 464 4 EA Connect Proposed 12" RCP to Proposed 5'x2' RCB 4,500.00 18,000.00 5,000.00 20,000.00 2,000.00 8,000.00 24 464 40 LF Furnish & Install 12" RCP 60.00 2,400.00 150.00 6,000.00 250.00 10,000.00 25 464 160 LF Furnish & Install 24" RCP 85.00 13,600.00 250.00 40,000.00 260.00 41,600.00 26 464 1 EA Connect to Existing 24" RCP 2,500.00 2,500.00 3,000.00 3,000.00 5,000.00 5,000.00 27 465 1 EA Remove Existing 3'x3'Junction Box and Furnish &Install 3'x3' Junction Box with Lid 6,500.00 6,500.00 5,000.00 5,000.00 6,000.00 6,000.00 28 466 1 EA Furnish & Install Concrete Headwall (CH-FW-0) for 24" RCP 5,500.00 5,500.00 2,715.00 2,715.00 7,000.00 7,000.00 29 467 1 EA Furnish & Install Concrete SET (SETB-PD) for 2-5'x2' RCB's 12,500.00 12,500.00 8,000.00 8,000.00 24,000.00 24,000.00 30 COG 4 EA Furnish & Install Stormceptor 450i with Curb Inlet or approved 18,500.00 74,000.00 17,500.00 70,000.00 22,000.00 88,000.00 31 500 100%LS Insurance, Bonds and Mobilization, not to exceed 5% of Base Bid 57,500.00 57,500.00 65,000.00 65,000.00 90,000.00 90,000.00 32 502 8 MO Implement and Administer Barricade,Signing and Traffic Safety Plan (Vehicular and Pedestrian) for Base Bid 15,000.00 120,000.00 1,100.00 8,800.00 10,000.00 80,000.00 33 COG 100%LS Prepare Stormwater Pollution Prevention Plan,Including Submission to and Receiving Permits from Texas Commission on Environmental Quality (TCEQ) for Base Bid 2,500.00 2,500.00 2,200.00 2,200.00 9,000.00 9,000.00 OPC 2 DeNucci Constructors, LLC 8310-1 Capital Texas Hwy State 275 Joe Bland ConstructionFinal Opinion of Probable Construction Cost 13111 Dessau Road Austin, TX 78754 1 Austin, TX 78731 Page 1 of 3Page 86 of 93 CSJ # 0914-05-201 STP 2021(746)MM BID TABULATION CITY OF GEORGETOWN WILLIAMS AT LAKEWAY INTERSECTION IMPROVEMENTS Bid No. 202163 August 26, 2021; 2:00 PM 2019-166-40 BIDDER INFORMATION Bid TxDOT Estimated Unit Bid Data Unit Extended Unit Extended Unit Extended No.Spec No.Quantity Description Price Amount Price Amount Price Amount OPC 2 DeNucci Constructors, LLC 8310-1 Capital Texas Hwy State 275 Joe Bland ConstructionFinal Opinion of Probable Construction Cost 13111 Dessau Road Austin, TX 78754 1 Austin, TX 78731 34 506 510 LF Furnish, Install & Maintain Silt Fence 2.50 1,275.00 4.25 2,167.50 4.00 2,040.00 35 506 510 LF Remove Silt Fence 2.00 1,020.00 1.00 510.00 2.00 1,020.00 36 506 30 LF Furnish, Install & Maintain Rock Berm 50.00 1,500.00 40.00 1,200.00 50.00 1,500.00 37 506 30 LF Remove Rock Berm 15.00 450.00 10.00 300.00 25.00 750.00 38 528 760 SF Furnish & Install Brick Pavers in Island 20.00 15,200.00 12.00 9,120.00 20.00 15,200.00 39 529 1,310 LF Furnish & Install 24" Standard Curb & Gutter 20.00 26,200.00 29.50 38,645.00 22.00 28,820.00 40 529 300 LF Furnish & Install Double 24" Spill Curb & Gutter for Median 20.00 6,000.00 26.00 7,800.00 22.00 6,600.00 41 529 170 LF Furnish & Install Sawtooth Curb & Gutter 20.00 3,400.00 35.00 5,950.00 22.00 3,740.00 42 530 130 SY Furnish & Install 6" Thick Concrete Driveway 75.00 9,750.00 69.00 8,970.00 180.00 23,400.00 43 531 170 SY Furnish & Install 5" Thick Concrete Sidewalk 65.00 11,050.00 54.00 9,180.00 150.00 25,500.00 44 531 8 EA Furnish & Install TxDOT Type 7 Ramp 3,500.00 28,000.00 2,800.00 22,400.00 3,600.00 28,800.00 45 618 35 LF CONDT (PVC) (SCHD 40) (2")30.00 1,050.00 15.00 525.00 24.00 840.00 46 618 90 LF CONDT (PVC) (SCHD 40) (3")35.00 3,150.00 18.00 1,620.00 29.00 2,610.00 47 618 70 LF CONDT (PVC) (SCHD 40) (4")45.00 3,150.00 24.00 1,680.00 35.00 2,450.00 48 618 380 LF CONDT (PVC) (SCHD 80) (4") (BORE)100.00 38,000.00 65.00 24,700.00 134.00 50,920.00 49 620 2,140 LF ELEC CONDUCTOR (NO. 8) INSULATED 2.00 4,280.00 2.50 5,350.00 2.00 4,280.00 50 620 635 LF ELEC CONDUCTOR (NO. 6) BARE 3.00 1,905.00 2.50 1,587.50 2.00 1,270.00 51 620 70 LF ELEC CONDUCTOR (NO. 6) INSULATED 4.00 280.00 3.00 210.00 3.00 210.00 52 624 3 EA GROUND BOX TY D (162922) W/APRON 2,500.00 7,500.00 1,700.00 5,100.00 2,200.00 6,600.00 53 628 1 EA ELC SRV TY D 120/240 070 (NS)AL(E)PS(U)9,500.00 9,500.00 5,500.00 5,500.00 9,800.00 9,800.00 54 666 460 LF Furnish & Install Thermoplastic White Crosswalk Striping 5.00 2,300.00 10.00 4,600.00 15.00 6,900.00 55 666 160 LF Furnish & Install Thermoplastic White 2' Wide Stop Bar 20.00 3,200.00 12.00 1,920.00 8.00 1,280.00 56 666 3 EA Furnish & Install Thermoplastic Right Turn Arrow 250.00 750.00 240.00 720.00 300.00 900.00 57 666 1 EA Furnish & Install Thermoplastic Straight/Right Turn Arrow 250.00 250.00 300.00 300.00 400.00 400.00 58 666 5 EA Furnish & Install Thermoplastic Straight Arrow 250.00 1,250.00 180.00 900.00 300.00 1,500.00 59 666 4 EA Furnish & Install Thermoplastic Left Turn Arrow 250.00 1,000.00 240.00 960.00 300.00 1,200.00 60 666 13 EA Furnish & Install "ONLY" Emblem 250.00 3,250.00 250.00 3,250.00 400.00 5,200.00 61 666 1,000 LF Furnish &Install Thermoplastic White Dash Striping With Traffic Buttons 6.50 6,500.00 2.00 2,000.00 2.00 2,000.00 62 666 1,130 LF Furnish & Install Thermoplastic White Solid Striping 5.00 5,650.00 2.00 2,260.00 2.00 2,260.00 63 666 650 LF Furnish & Install Double Thermoplastic Yellow Solid Striping 7.50 4,875.00 3.25 2,112.50 2.00 1,300.00 64 680 1 EA INSTALL HWY TRAF SIG (ISOLATED)30,000.00 30,000.00 25,000.00 25,000.00 43,000.00 43,000.00 65 680 1 EA REMOVING TRAFFIC SIGNALS 12,500.00 12,500.00 5,000.00 5,000.00 7,000.00 7,000.00 66 682 8 EA VEH SIG SEC (12") LED (GRN)450.00 3,600.00 400.00 3,200.00 500.00 4,000.00 67 682 4 EA VEH SIG SEC (12") LED (GRN ARW)450.00 1,800.00 400.00 1,600.00 500.00 2,000.00 68 682 8 EA VEH SIG SEC (12") LED (YEL)450.00 3,600.00 400.00 3,200.00 500.00 4,000.00 69 682 8 EA VEH SIG SEC (12") LED (YEL ARW)450.00 3,600.00 400.00 3,200.00 500.00 4,000.00 70 682 8 EA VEH SIG SEC (12") LED (RED)450.00 3,600.00 400.00 3,200.00 500.00 4,000.00 71 682 8 EA VEH SIG SEC (12") LED (RED ARW)450.00 3,600.00 400.00 3,200.00 500.00 4,000.00 72 682 8 EA PED SIG SEC (LED) (COUNTDOWN)450.00 3,600.00 1,000.00 8,000.00 1,200.00 9,600.00 73 682 8 EA BACKPLATE W/REF BRDR (3 SEC) (VENT) ALUM 225.00 1,800.00 80.00 640.00 200.00 1,600.00 74 682 4 EA BACKPLATE W/REF BRDR (5 SEC)(VENTED) ALUM 275.00 1,100.00 100.00 400.00 200.00 800.00 Page 2 of 3Page 87 of 93 CSJ # 0914-05-201 STP 2021(746)MM BID TABULATION CITY OF GEORGETOWN WILLIAMS AT LAKEWAY INTERSECTION IMPROVEMENTS Bid No. 202163 August 26, 2021; 2:00 PM 2019-166-40 BIDDER INFORMATION Bid TxDOT Estimated Unit Bid Data Unit Extended Unit Extended Unit Extended No.Spec No.Quantity Description Price Amount Price Amount Price Amount OPC 2 DeNucci Constructors, LLC 8310-1 Capital Texas Hwy State 275 Joe Bland ConstructionFinal Opinion of Probable Construction Cost 13111 Dessau Road Austin, TX 78754 1 Austin, TX 78731 75 684 398 LF TRF SIG CBL (TY A) (14 AWG) (5 CONDR)3.00 1,194.00 2.50 995.00 3.00 1,194.00 76 684 240 LF TRF SIG CBL (TY A) (14 AWG) (7 CONDR)3.50 840.00 3.00 720.00 3.00 720.00 77 684 735 LF TRF SIG CBL (TY A) (14 AWG) (10 CONDR)5.00 3,675.00 3.50 2,572.50 6.00 4,410.00 78 684 560 LF TRF SIG CBL (TY A) (14 AWG) (20 CONDR)7.25 4,060.00 5.00 2,800.00 9.00 5,040.00 79 684 1,195 LF TRF SIG CBL (TY C) (12 AWG) (2 CONDR)10.00 11,950.00 2.00 2,390.00 2.00 2,390.00 80 686 1 EA INS TRF SIG PL AM (S) 1 ARM (32') LUM&ILSN 10,500.00 10,500.00 12,500.00 12,500.00 19,000.00 19,000.00 81 686 2 EA INS TRF SIG PL AM (S) 1 ARM (40') LUM&ILSN 11,250.00 22,500.00 14,400.00 28,800.00 21,000.00 42,000.00 82 686 1 EA INS TRF SIG PL AM (S) 1 ARM (48') ILSN 12,000.00 12,000.00 14,800.00 14,800.00 22,000.00 22,000.00 83 687 2 EA PEDESTAL POLE ASSEMBLY 4,500.00 9,000.00 2,000.00 4,000.00 3,500.00 7,000.00 84 688 8 EA PED DETECT PUSH BUTTON (APS)1,000.00 8,000.00 550.00 4,400.00 1,300.00 10,400.00 85 688 1 EA PED DETECTOR CONTROLLER UNIT 8,500.00 8,500.00 3,200.00 3,200.00 4,000.00 4,000.00 86 6058 1 EA BBU SYSTEM (EXTERNAL BATT CABINET)12,500.00 12,500.00 5,900.00 5,900.00 11,000.00 11,000.00 87 6306 1 EA VIVDS PROSR SYSTEM 10,500.00 10,500.00 9,000.00 9,000.00 11,000.00 11,000.00 88 6306 4 EA VIVDS CAM ASSY FXD LENS 3,000.00 12,000.00 1,800.00 7,200.00 2,500.00 10,000.00 89 6306 1 EA VIVDS CNTRL SOFTWARE 2,500.00 2,500.00 300.00 300.00 2,200.00 2,200.00 90 6306 781 LF VIVDS CABLING 5.00 3,905.00 3.00 2,343.00 6.00 4,686.00 91 4 EA ILLUMINATED STREET NAMES SIGNS 2,500.00 10,000.00 2,400.00 9,600.00 5,500.00 22,000.00 92 COG 100%LS For Providing a Video DVD of the Project Area Prior to and After Construction for Base Bid 2,500.00 2,500.00 1,000.00 1,000.00 2,900.00 2,900.00 93 COG 100%LS For City of Georgetown Electrical Connection Allowance to be paid based off COG Electrical Invoice plus 10% 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 94 COG 100%LS City of Georgetown Force Account 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 150,000.00 BIDDER INFORMATION Did Bidder Acknowledge Addenda 1 thru 3? Did Bidder provide Bid Security? Did Bidder provide required documents? I hereby certify that this is a correct & true tabulation of all bids received Alvin R. Sutton III, P.E.Date Kasberg, Patrick & Associates, LP YES YES YES 2 YES 1,448,918.00$ DeNucci Constructors, LLC 8310-1 Capital Texas Hwy State 275 1,456,711.50$ Austin, TX 78754 1,920,635.00$ Austin, TX 78731 Joe Bland Construction YES YES 13111 Dessau Road 1 Page 3 of 3 August 30, 2021 Page 88 of 93 TSP TSP TSP TSP ONLY ONLY ONLY ONLY ONLY ONLY ONLY ONLY ONLY ONLY ONLY ONLY C L - W I L L I A M S D R I V E BL - B O O T Y S C R O S S I N G R O A D CL - D R I V E W A Y 3 C L - W I L L I A M S D R I V E 7 + 2 0 1 + 0 0 2 + 0 0 3 + 0 0 4 + 0 0 5 + 0 0 6 + 0 0 7 + 0 0 4+50 1+0 0 2+0 0 3+00 4+00 FURNISH AND INSTALL 169 LF OF CURB AND GUTTER FURNISH AND INSTALL 37 LF OF CURB AND GUTTER FURNISH AND INSTALL 31 LF OF CURB AND GUTTER FURNISH AND INSTALL 103 LF OF CURB AND GUTTER LOT 1A RESUBDIVISION OF SAN GABRIEL ESTATES LOTS 1, 2, 3, 23, & 24 Doc. No. 2001081693 ROW Line of Booty's Crossing Road as per map in Doc. No. 2014072516 LOT 1, BLOCK 1 AMENDED PLAT OF A RESUBDIVISION OF WILLIAMSBURG VILLAGE Cab. P, Sl. 270 15' Public Utility E a s e m e n t & L a n d s c a p e A r e a C a b . P , S l . 2 7 0 CALLED 0.486 ACRE WILLIAMSBURG VILLAGE CENTER, LP Doc. No. 2014072516 2 0 ' U t i l i t y E a s e m e n t C a b . O , S l . 1 4 2 LOT 1A, BLOCK 1 THE RESUBDIVISION OF LOT 1, PARK MEADOW WEST Cab. O, Sl. 142 LOT 1, BLOCK 1 FIRST NATIONAL BANK ADDITION Cab. E, Sl. 225 LOT 1, BLOCK A RABB SUBDIVISION Cab. G, Sl. 364 LOT 1, BLOCK A WILLIAMS POOL SUBDIVISION Doc. No. 2016019523 10' U t i l i t y E a s e m e n t D o c . N o . 2 0 1 6 0 1 9 5 2 3 1 0 ' U t i l i t y E a s e m e n t D o c . N o . 2 0 1 6 0 1 9 5 2 3 D o c . N o . 2 0 0 3 0 8 6 4 0 8 2 0 ' U t i l i t y E a s e m e n t LOT 3A BLOCK 1 AMENDING PLAT OF LOTS 1, 2, & 3 MESQUITE FLATS Doc. No. 2003086408 2 0 ' U t i l i t y E a s e m e n t D o c . N o . 2 0 0 1 0 8 1 6 9 3 FURNISH AND INSTALL 482 LF OF CURB AND GUTTER CL - D R I V E W A Y 1 CL - D R I V E W A Y 2 1 + 0 0 2 + 0 0 3 + 0 0 4+0 0 5+0 0 6+00 7+00 8+00 L O G - W I L L I A M S D R I V E T O B O O T Y ' S C R O S S I N G R O A D FURNISH AND INSTALL 162 LF OF CURB AND GUTTER FURNISH AND INSTALL 152 LF OF SAWTOOTH CURB AND GUTTER FI L E : P: \ G e o r g e t o w n \ 2 0 1 9 \ 2 0 1 9 - 1 6 6 W I L L I A M S A T L A K E W A Y I N T I M P \ C A D \ P l a n s \ w o r k i n g p l a n s e t \ P L A N - P R O F I L E \ O V E R A L L . d w g L A S T S A V E D : 1/ 2 0 / 2 0 2 1 1 : 1 4 : 3 1 P M LA Y O U T : OV E R A L L - R O A D W A Y Plot Date: 7/29/2021 9:21:45 AM Plotted By: KVILLALBA SHEET NO. PP-01 OF 05 SHEETS ROADWAY SHEETS OVERALL - ROADWAY N O R T H 0 HORIZONTAL SCALE IN FEET 30 60 CITY OF GEORGETOWN, TEXAS WILLIAMS AT LAKEWAYKASBERG, PATRICK & ASSOCIATES, LP CONSULTING ENGINEERS GEORGETOWN, TEXAS 78626 DESIGN SET 2019-166 Kevin Villalba APPROVED BY DESIGNED BY DRAWN BY PROJECT NO. DATE BYREVISIONDATENO. © 2021 Kasberg, Patrick & Associates, LP KPA Firm Registration Number F-510 Alvin R. Sutton, III, P.E. DESIGN SET Page 89 of 93 City of Georgetown, Texas Transportation Advisory Board October 8, 2021 S UB J E C T: C onsideration and pos s ible ac tion to approve the purc hase of a 2021 John Deere 325G trac k loader – Eric Johns on, P ublic Works Direc tor IT E M S UMMARY: T he C oronavirus Aid, R elief, and Economic S ecurity (C AR ES ) Ac t inc ludes funding and financ ing for airlines and aviation busines s es as well as grants for airports, public trans it and Amtrak. T his is a 100% F ed erally fundable grant and funds have alread y been rec eived by the C ity o f G eorgetown for the Airport. T he purchas e of the Jo hn Deere 325G track loader is an investment that will allo w Airp o rt Maintenanc e to expedite projec ts eas ily and more effic iently. F IN AN C IAL IMPAC T: F unds us ed for this purchas e will be from the C ares Act grant. S UB MIT T E D B Y: Debbie Jolly, Airport Bus iness C oordinator AT TAC H ME N T S: Description Type Airport John Deere Cover Sheet Cover Memo John Deere Inves tment Proposal Quote Backup Material Page 90 of 93 GTAB Meeting Date: October 8, 2021 Item No. AGENDA ITEM COVER SHEET _____________________________________________________________________________________________________________________ SUBJECT: Consideration and possible action to approve the purchase of a 2021 John Deere 325G track loader – Eric Johnson, Public Works Director ____________________________________________________________________________________________________________________ ITEM SUMMARY: The Coronavirus Aid, Relief, and Economic Security (CARES) Act includes funding and financing for airlines and aviation businesses as well as grants for airports, public transit and Amtrak. This is a 100% Federally fundable grant and funds have already been received by the City of Georgetown for the Airport. The purchase of the John Deere 325G track loader is an investment and will allow Airport Maintenance to expedite projects easily and more efficiently. SPECIAL CONSIDERATIONS: None FINANCIAL IMPACT: Funds used for this purchase will be from the Cares Act grant. STAFF RECOMMENDATION: Staff recommends approval of this purchase. COMMENTS: None ATTACHMENTS: Investment Proposal (Quote) from RDO Equipment Company. Submitted By: Debbie Jolly, Airport Business Coordinator Jeff Belding Interim Airport Manager Eric Johnson Public Works Director Page 91 of 93 Investment Proposal (Quote) RDO Equipment Co. 16415 N IH-35 Pflugerville TX, 78660 Phone: (512) 272-4141 - Fax: (512) 272-9365 Proposal for: CITY OF GEORGETOWN PO BOX 409 GEORGETOWN, TX, 786270409 WILLIAMSON Investment Proposal Date: Pricing Valid Until: Deal Number: Customer Account#: Sales Professional: Phone: Fax: Email: 9/6/2021 9/20/2021 1482341 3679006 Tim Schuelke (512) 272-4141 TSchuelke@rdoequipment.com Comments SOURCEWELL PRICING. DELIVERY APX 12/20/2021 AS OF 9/7/2020 JOHN DEERE SOURCEWELL CONTRACT # 032515-JDC Equipment Information Quantity Serial Number Stock Number Hours (approx.) Status / Year / Make / Model Additional Items Cash Price 1 523466 X253463 0 New 2021 JOHN DEERE 325G $84,908.00 Other 32% SOURCEWELL DISCOUNT ($27,171.00) Freight Out $350.00 Freight in FACTORY FREIGHT IN $1,680.00 Prep / Reconditioning PRE DELIVERY INSPECTION $1,224.00 Warranty -John Deere Comprehensive-24 Months, 2000 Hours,Deductible: 0 $0.00 Equipment Subtotal:$60,991.00 Purchase Order Totals Balance:$60,991.00 Total Taxable Amount:$0.00 TX STATE TAX:$0.00 TX SPECIAL TAX:$0.00 Sales Tax Total:$0.00 Sub Total:$60,991.00 Cash with Order:$0.00 Balance Due:$60,991.00 D1482341 Page 1 of 2Page 92 of 93 Equipment Options Qty Serial Number Year / Make / Model Description 1 523466 2021 JOHN DEERE 325G 0750 2SP STDFL SLEV CB/AC PQT 0953 ISO SWITCHABLE CTLS & JS PPK 1301 ENGINE TURBO 4TNV98CT 1501 ENGLISH OP MAN & DECALS 170C JDLINK 4G ULTMT W 5 YRS SERV 2645 WIDE ZIG ZAG 15.8" 400MM TRK 4003 3" SEAT BELT W/2"SHLDR STRAP 6003 AIR SUSPENSION SEAT 8042 REAR VIEW CAMERA 8060 PRE CLEANER 8300 CTRWGT STACK SINGLE SET 8342 RADIO AM/FM W/BLUETOOTH 8380 FOOTREST WITH FLOORMAT 9052 HD 78 IN CONST BUCKET W EDGE D1482341 Page 2 of 2Page 93 of 93