Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Agenda_GWUAB_01.13.2022
Notice of Meeting for the Georgetown Water Utility B oard of the City of Georgetown January 13, 2022 at 2:00 P M at West Side Serv ice Center, 5501 Williams Dr., Georgetown, T X, 78633 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: P leas e fill out a s peaker registration form which c an be found on the counter at the entranc e 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 W UAB Interim Board Liais on, at sheila.mitchell@georgetown.org B C all to O rder - Board C hair C Updates from Water Utility Direc tors; C hels ea S olomon, Director of Water Utilities - any updates will be highlighted at the meeting. T he Directors report will be sent prior to the meeting. T he F Y 2021 4th Quarter C ombined R eport from Finance is attached. D R eview and pos s ible ac tion to approve the minutes from the November 11, 2021 G eorgetown Water Utility Advisory Board Meeting.- S heila Mitc hell, Interim Board Liaison E C ons ideration and possible recommendation to award Holt P ower S ys tems, of S an Antonio, Texas , for the C omplete R emoval and R eplacement of S tandby G enerator at P ec an Branch Was tewater Treatment P lant, in the amount of $147,500.00. – Mike Welc h, Treatment and R egulatory Manager F C ons ideration and p o s s ib le rec ommend ation to approve a Task O rder Amendment #1 to Tas k O rder C DM-21-006 with C DM S mith, Inc . of Austin, Texas , fo r p ro fes s io nal s ervic es related to the 2022 Water and Was tewater Utility Mas ter P lans Update, Integrated Water R esource P lan, Water and Was tewater Imp act F ee and 2021/2022 Utility Evaluations S upport in the amount o f $128,725.00. -- Wes ley Wright, P.E., S ys tems Engineering Director / C hris P ous s on, C I P Manager G C ons ideration and possible recommendation to approve a contrac t amendment to C F G Industries , LLC . O f Magnolia, T X for additional repairs needed for the S ouths ide C learwell R oof R eplacement and Page 1 of 171 R ehabilitation project in the amount of $98,000.00. -- Wesley Wright, P.E., S ystems Engineering Direc tor / C hris P ous s on, C I P Manager H C ons ideration and possible recommendation to approve Tas k O rder KPA-22-002 with Kas berg, P atrick & As s ociates , LP of G eorgetown, Texas , for professional services related to F Y 22 Water S ystem Improvement projects that c onsist of three water line improvements and one water pump station upgrade projec ts in the amount of $1,133,525.00. -- Wesley Wright, P.E., S ystems Engineering Direc tor / C hris P ous s on, C I P Manager I C ons ideration and possible recommend ation to approve Tas k O rder C DM-22-002 with C DM S mith, Inc . o f Aus tin, Texas , fo r p ro fes s io nal services related to G eorgetown Lake Water Treatment P lant Emergenc y P ower S up p ly S ys tem P rojec t in the amount $760,000.00. -- Wes ley Wright, P.E., S ys tems Engineering Direc tor / C hris P ousson, C I P Manager 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 _________________, 2022, 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 171 City of Georgetown, Texas Water Utility Board January 13, 2022 S UB J E C T: Updates from Water Utility Directors ; C helsea S olomon, Direc tor of Water Utilities - any updates will be highlighted at the meeting. T he D irectors report will be sent prior to the meeting. T he F Y2021 4th Q uarter Combined Report from F inance is attached. IT E M S UMMARY: F IN AN C IAL IMPAC T: . S UB MIT T E D B Y: C helsea S olomon, Direc tor of Water Utilities AT TAC H ME N T S: Description Type 01 Directors Report - GWUAB January 13 2022 FINAL Backup Material Quarterly Executive Summary Backup Material Water Fund Backup Material Rollforward - Narrative Backup Material Exhibit A. CIPRF Backup Material Exhibit B. Capital Project Rollforward Summary Backup Material Page 3 of 171 Directors’ Report January 13, 2022 City of GeorgetownPage 4 of 171 Customer Service and Billing – Water Services Page 5 of 171 •Water Service Customer Account Breakdown: **work order initiated for meter investigation after second consecutive month** •Water Billing Collection: •Advanced Metering Infrastructure (AMI): 77%Usage transmitted automatically •Automated Meter Reading (AMR): 23%Usage collected via “drive by” system Customer Statistics -Water •Average Water Bill/Dec FY-2021 FY-2022 Residential $48.08 $52.02 All Customers $63.89 $61.73 Water Customers November December Estimations* Residential 45,619 45,962 Non-Residential 5,380 5,312 Total Customers 50,999 51,274 1,171 Page 6 of 171 Aged Receivables Report -Water Compared to Previous Month Water Prior Month Variance 31 –60 Days $41,346.05 $41,346.05 ($36,471.87) 61 –90 Days $19,805.75 $19,805.75 ($6,427.48) 91 –120 Days $14,834.69 $14,834.69 $19.50 120 –365 Days $29,333.42 $29,333.42 ($46,895.28) > 365 Days $3,057.85 $3,057.85 ($211,595.38) Total $108,377.76 $108,377.76 ($301,370.51) Customer Counts 1147 1147 (1488) Water Prior Month Variance 31 –60 Days $59,071.70 $75,630.67 ($16,558.97) 61 –90 Days $58,204.73 $23,624.28 $34,580.45 91 –120 Days $22,806.67 $18,521.95 $4,284.72 120 –365 Days $57,881.99 $42,646.92 $15,235.07 > 365 Days $5,079.36 $4,023.29 $1,056.07 Total $203,044.45 $164,447.11 $38,597.34 Customer Counts 1604 1240 364 Page 7 of 171 •Sewer Service Customer Account Breakdown: Customer Statistics -Sewer •Average Sewer Bill/Dec FY-2021 FY-2022 Residential $34.88 $37.87 All Customers $41.40 $45.19 Sewer Customers November December Residential 29,534 29,706 Non-Residential 2,880 2,866 Total Customers 32,414 32,572 Page 8 of 171 Aged Receivables Report -Sewer Compared to Previous Month Sewer Prior Month Variance 31 –60 Days $11,935.13 $10,795.02 $1,140.11 61 –90 Days $7,092.06 $5,022.16 $2,069.90 91 –120 Days $4,989.61 $4,247.71 $741.90 120 –365 Days $16,888.80 $14,876.04 $2,012.76 > 365 Days $2,067.82 $1,780.09 $287.73 Total $42,973.42 $36,721.02 $6,252.40 Customer Counts 928 683 245 Page 9 of 171 Collection Agency Monthly Review City of GeorgetownPage 10 of 171 •Residential –Water •Residential –Sewer Customer Rates Rates –Effective 1-1-2021 Base Charge (3/4” meter)$24.50 / $29.45 Volumetric Charges: 0 –7 kgal $1.85 7,001 -15 kgal $2.75 15,001 –25 kgal $4.80 25,001 +$8.40 Rates –Effective 1-1-2021 Fixed Charge $34.85 / $40.10 Page 11 of 171 Finance FY2021 Q4 Report FY2022 Budget Amendment Page 12 of 171 Fourth Quarter Background •Budget in this report reflects the CIP Roll Forward and Operational Amendment as well as the Midyear Budget Amendment •Due to COVID-19 pandemic timing, year over year comparisons of 2020 and 2021 show large variances in some revenues and expenses, which was expected going into FY2021 •Report reflects operational impacts of the winter storm in expenses –City has applied for FEMA reimbursement, timing of reimbursement unknown Page 13 of 171 Water Fund Fund Revenue •FY2021 Revenue Budget •Revenue Budget Sources –The FY2021 revenue budget for the Water Fund is $89.7 million –57% of budgeted revenues is charges for service •Water: $32.2 million •Wastewater: $14.2 million •Irrigation: $300 thousand –Impact Fees total 21% –Bond proceeds total 16.3 million or 18.2% 0.28% 0.26% 56.88% 23.69% 0.70% 18.18%Fines and Penalties Investment Income Charges for Services Other Miscellaneous Revenue Developer Contributions Bond Proceeds Page 14 of 171 Water Fund Revenue - Quarterly Water Quarterly Comparison: Q4 FY2021 Budget FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % of Budget Variance % Variance Operating Revenue 41002:Penalties 255,000 305,880 513,447 258,447 201.35%207,567 67.86% 42001:Interest Income 237,250 1,475,880 427,758 190,508 180.30%(1,048,122) -71.02% 43001:Fees 4,290,000 6,644,405 9,598,958 5,308,958 223.75%2,954,553 44.47% 43005:Rental Revenue 55,000 61,178 112,975 57,975 205.41%51,797 84.67% 43602:Water Charges 32,150,000 35,208,127 41,143,198 8,993,198 127.97%5,935,071 16.86% 43603:Wastewater Charges 14,200,000 14,282,982 15,125,001 925,001 106.51%842,019 5.90% 43604:Irrigation Charges 300,000 513,679 360,002 60,002 120.00%(153,677) -29.92% 41602:Impact Fees 18,800,000 27,891,155 40,034,496 21,234,496 212.95%12,143,341 43.54% 44502:Developer Contributions 625,000 661,160 1,490,202 865,202 238.43%829,042 125.39% Operating Revenue Total 70,912,250 87,044,447 108,806,038 37,893,788 153.44%21,761,591 25.00% Non-Operating Revenue 45001:Misc Revenue 1,112,500 559,186 1,312,616 200,116 117.99%753,430 134.74% 45003:Misc Reimbursements - - 10,422 10,422 0.00%10,422 0.00% 45004:Sale of Property 1,327,774 735,404 1,330,463 2,689 100.20%595,058 80.92% 44001:Grant Revenue - 338 - - 0.00%(338) -100.00% 46001:Bond Proceeds 16,300,000 9,375,000 14,975,000 (1,325,000) 91.87%5,600,000 59.73% 46002:Bond Premium - - 1,415,140 1,415,140 0.00%1,415,140 0.00% Non-Operating Revenue Total 18,740,274 10,669,927 19,043,639 303,365 101.62%8,373,712 78.48% Revenue Total 89,652,524 97,714,374 127,849,678 38,197,154 142.61%30,135,303 30.84% FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison Page 15 of 171 Water Fund Revenue Projections Water Quarterly Comparison: Q4 FY2021 Budget FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav)% of Projections Operating Revenue 41002:Penalties 255,000 513,447 258,447 201.35%355,000 158,447 144.63% 42001:Interest Income 237,250 427,758 190,508 180.30%492,336 (64,577) 86.88% 43001:Fees 4,290,000 9,598,958 5,308,958 223.75%7,655,000 1,943,958 125.39% 43005:Rental Revenue 55,000 112,975 57,975 205.41%60,000 52,975 188.29% 43602:Water Charges 32,150,000 41,143,198 8,993,198 127.97%35,100,000 6,043,198 117.22% 43603:Wastewater Charges 14,200,000 15,125,001 925,001 106.51%14,000,000 1,125,001 108.04% 43604:Irrigation Charges 300,000 360,002 60,002 120.00%300,000 60,002 120.00% 41602:Impact Fees 18,800,000 40,034,496 21,234,496 212.95%32,500,000 7,534,496 123.18% 44502:Developer Contributions 625,000 1,490,202 865,202 238.43%1,496,239 (6,037) 99.60% Operating Revenue Total 70,912,250 108,806,038 37,893,788 153.44%91,958,575 16,847,463 118.32% Non-Operating Revenue 45001:Misc Revenue 1,112,500 1,312,616 200,116 117.99%1,262,350 50,266 103.98% 45003:Misc Reimbursements - 10,422 10,422 0.00%- 10,422 0.00% 45004:Sale of Property 1,327,774 1,330,463 2,689 100.20%1,327,774 2,689 100.20% 44001:Grant Revenue - - - 0.00%- - 0.00% 46001:Bond Proceeds 16,300,000 14,975,000 (1,325,000) 91.87%14,975,000 - 100.00% 46002:Bond Premium - 1,415,140 1,415,140 0.00%1,415,140 (0) 100.00% Non-Operating Revenue Total 18,740,274 19,043,639 303,365 101.62%18,980,264 63,375 100.33% Revenue Total 89,652,524 127,849,678 38,197,154 142.61%110,938,839 16,910,839 115.24% FY2021 FY2021 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals Page 16 of 171 Water Fund Operating Revenue •Water Charges –36% of budgeted Water Fund operating revenue –$41.1 million, or 128% of water revenue budget received through the quarter –Water charges revenue is up 17% compared to the same period of FY2020 •Sales growth from customers –15% increase in KGAL used same period 2020 •Rate increases for cost of service 17% 41,143,198 WATER CHARGES REVENUE K 5.0M 10.0M 15.0M Q1 Q2 Q3 Q4 FY2020 FY2021 Page 17 of 171 Water Fund Expenses - Quarterly Water Services Financial Report Quarterly Comparison: Q4 FY2021 Budget FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % of Budget Variance % Variance Operating Expense City of Georgetown (Only)- 210,469 - - 0.00%210,469 -100.00% CC0001 Non-Departmental 4,223,814 4,255,702 5,131,684 (907,870) 121.49%(875,982) 20.58% CC0526 Systems Engineering - 7,130,305 (1,836,056) 1,836,056 0.00%8,966,361 -125.75% CC0532 Irrigation Operations 295,000 268,930 139,285 155,715 47.22%129,646 -48.21% CC0530 Wastewater Operations 896,265 764,733 547,171 349,094 61.05%217,562 -28.45% CC0531 Wastewater Plant Management 4,013,950 3,271,553 3,516,184 497,766 87.60%(244,631) 7.48% CC0527 Water Services Administration 26,369,169 23,848,381 24,491,296 1,877,873 92.88%(642,915) 2.70% CC0528 Water Distribution 3,207,552 2,626,683 3,176,051 31,501 99.02%(549,369) 20.91% CC0529 Water Plant Management 4,326,865 3,685,707 3,479,406 847,459 80.41%206,302 -5.60% CC0553 Water Operations 4,173,316 4,325,327 4,377,488 (204,172) 104.89%(52,161) 1.21% Operating Expense Total 47,505,930 50,387,791 43,022,509 4,483,421 90.56%7,365,282 -14.62% Non-Operating Expense CC0001 Non-Departmental 4,083,411 3,131,244 92,665 3,990,746 2.27%3,038,578 -97.04% CC0526 Systems Engineering 99,509,468 4,264,398 13,900,168 85,609,300 13.97%(9,635,770) 225.96% CC0532 Irrigation Operations 121,879 125,075 121,994 (115) 100.09%3,081 -2.46% CC0530 Wastewater Operations 3,026,798 10,351,145 3,160,381 (133,583) 104.41%7,190,763 -69.47% CC0531 Wastewater Plant Management 2,050,000 - - 2,050,000 0.00%- 0.00% CC0527 Water Services Administration - - - - 0.00%- 0.00% CC0528 Water Distribution 1,159,424 77,506 781,316 378,108 67.39%(703,809) 908.07% CC0529 Water Plant Management 2,757 - - 2,757 0.00%- 0.00% CC0553 Water Operations 14,124,300 2,081,831 11,704,343 2,419,957 82.87%(9,622,512) 462.21% CC0524 Metering Services 750,000 - - 750,000 0.00%- 0.00% Non-Operating Expense Total 124,828,037 20,031,198 29,760,867 95,067,170 23.84%(9,729,669) 48.57% Expense 172,333,967 70,418,989 72,783,376 99,550,591 57.77%(2,364,387) 3.36% FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison Page 18 of 171 Water Fund Expense - Projections Water Services Financial Report Quarterly Comparison: Q4 FY2021 Budget FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav)% of Projection Operating Expense City of Georgetown (Only)- - - 0.00%- - 0.00% CC0001 Non-Departmental 4,223,814 5,131,684 (907,870) 121.49%4,713,430 (418,254) 108.87% CC0526 Systems Engineering - (1,836,056) 1,836,056 0.00%(639,847) 1,196,209 286.95% CC0532 Irrigation Operations 295,000 139,285 155,715 47.22%295,000 155,715 47.22% CC0530 Wastewater Operations 896,265 547,171 349,094 61.05%834,706 287,535 65.55% CC0531 Wastewater Plant Management 4,013,950 3,516,184 497,766 87.60%3,704,111 187,927 94.93% CC0527 Water Services Administration 26,369,169 24,491,296 1,877,873 92.88%26,232,898 1,741,602 93.36% CC0528 Water Distribution 3,207,552 3,176,051 31,501 99.02%3,911,851 735,800 81.19% CC0529 Water Plant Management 4,326,865 3,479,406 847,459 80.41%3,910,271 430,866 88.98% CC0553 Water Operations 4,173,316 4,377,488 (204,172) 104.89%4,463,681 86,193 98.07% Operating Expense Total 47,505,930 43,022,509 4,483,421 90.56%47,426,102 4,403,593 90.71% Non-Operating Expense CC0001 Non-Departmental 4,083,411 92,665 3,990,746 2.27%3,887,651 3,794,986 2.38% CC0526 Systems Engineering 99,509,468 13,900,168 85,609,300 13.97%99,630,405 85,730,237 13.95% CC0532 Irrigation Operations 121,879 121,994 (115) 100.09%121,929 (65) 100.05% CC0530 Wastewater Operations 3,026,798 3,160,381 (133,583) 104.41%3,026,798 (133,583) 104.41% CC0531 Wastewater Plant Management 2,050,000 - 2,050,000 0.00%2,050,000 2,050,000 0.00% CC0527 Water Services Administration - - - 0.00%6,037 6,037 0.00% CC0528 Water Distribution 1,159,424 781,316 378,108 67.39%781,316 - 100.00% CC0529 Water Plant Management 2,757 - 2,757 0.00%2,757 2,757 0.00% CC0553 Water Operations 14,124,300 11,704,343 2,419,957 82.87%13,962,363 2,258,021 83.83% CC0524 Metering Services 750,000 - 750,000 0.00%750,000 750,000 0.00% Non-Operating Expense Total 124,828,037 29,760,867 95,067,170 23.84%124,219,256 94,458,389 23.96% Expense 172,333,967 72,783,376 99,550,591 57.77%171,645,358 98,861,982 42.40% FY2021 FY2021 Year-to-date: Budget Vs. Actuals FY2021 Year-to-date Vs. Projections Page 19 of 171 Water Fund Quarterly •Personnel –Increase OT associated with winter storm •Operational savings –Utilities –Expiring development agreement –Colorado River Basin •Capital –Large variances with Systems Engineering due to normalization of coding capital projects after financial software conversion –Multi-year capital projects will be rolled forward into FY2022 •Overall –expected to end year near budget, meeting reserve requirements Page 20 of 171 FY2022 Budget Amendment •Updates for amendment adopted by Council January 11, 2022 City of GeorgetownPage 21 of 171 The Budget Process •Council adopted the FY2022 budget in September, and the fiscal year began October 1 •Each winter staff bring forward a CIP Roll Forward amendment to move unspent funds for large capital improvement projects that span multiple years •Other amendments are necessary because new information is available since the previous summer –re- organizations, program updates, cost estimates •Typically, staff bring a mid-year amendment in May, and a year-end amendment in Nov Page 22 of 171 The Budget Process •Council adopted the FY2022 budget in September, and the fiscal year began October 1 •Each winter staff bring forward a CIP Roll Forward amendment to move unspent funds for large capital improvement projects that span multiple years •Other amendments are necessary because new information is available since the previous summer –re- organizations, program updates, cost estimates •Typically, staff bring a mid-year amendment in May, and a year-end amendment in Nov Page 23 of 171 Budget Amendment Types •Tier 1 –CIP Roll Forward -routine •Tier 2 –Other Operational or capital amendments –Conceptually known by staff/council –Workshops or legislative items approved by council since budget adoption that need budget authority Page 24 of 171 CIP Roll Forward Example •Life of a Capital Project Project Budget FY2019 Actuals FY2020 Actuals FY2021 Actuals FY2022 Roll Forward $11,250,00 0 $78,108 $2,721,856 $4,264,249 $4,185,787 Year 1- Design/Stu dy Year 2 - Constructio n Year 3 - Constructio n Year 4 – Completion Page 25 of 171 Amendment •Water CIP Roll Forward-$93.3 million –Berry Creek Interceptor –Round Rock Pump Station –Northlake Plant Expansion –Detail list attached •Water Operational Amendments -$247K Page 26 of 171 Water Fund •Southlake Water Treatment Plant: $140 million increase to bond proceed revenue and capital expense budget •Discussed with Council during budget development •Accelerate plant expansion to meet projected peak demand forecast on time •Total current estimate is $160 million ($20 million already budgeted); bids due back this winter •Staff continues putting together a funding plan that recognizes significant water impact fee contributions that will help offset debt issuance, as well as downstream impact on rates •Revised plan and any needed amendments will be brought back to Council in spring –Customer Care Re-Organization: $449 thousand •Move Conservation cost center into the Water Fund with matching reduction to Joint Service Fund allocation expense Page 27 of 171 Standby Stipend Increase (Operational) •General Fund -$40 thousand •Facilities -$2.9 thousand •Fleet -$5.4 thousand •Joint Services -$1.4 thousand •IT -$3.6 thousand •Electric -$20.6 thousand •Stormwater -$3.7 thousand •Water -$31 thousand •Request during FY2022 budget process to review standby pay for Electric •Staff conducted market comparison and reviewed options citywide for equity •Update flat dollar amount from $17 to $25 per day; within staff authority by policy; Effective Jan 3 •Total citywide net budget impact of $109K Page 28 of 171 Operations Report Page 29 of 171 Operating Statistics December 2021/Year in Review •Water System (MGD) –Rated Capacity /Available Capacity 44 / 40 mgd –Production for the year 8,219 million gallons –Average Annual Production (YTD)22.52 mgd –Peak Day Production (2021-wet summer)38.42 (90%) –2020 Peak 42.87 (97%) –2019 Peak 41.7 (94%) •Wastewater System (MGD) –Rate Capacity 8.5 –Average Annual Production (YTD)6.0 –Average Production 5.6 –Average Reuse 0.59 –Total Treatment for Year 2,173 million gallons City of GeorgetownPage 30 of 171 Conservation Programs and Rebates •12% of wrong day watering cases created in past three years are customers who have had previous cases •74% -Residential •26% -Commercial, Industrial, Institutional (CII) Wrong Day Watering Rebate Type Number of Rebates (FY19) Amount (FY19) Number of Rebates (FY20) Amount (FY20) Number of Rebates (FY21) Amount (FY21) Irrigation Checkup 2,327 $174,525.00 580 $43,500.00 2,360 $177,125.00 Smart/Weather Based Controller 119 $16,655.17 42 $5,820.47 166 $23,829.23 Spray-to-Drip Conversion 24 $3, 447.80 8 $1,117.15 41 $5,762.53 Multi-Stream Nozzle Zone Conversion 116 $16,551.03 28 $3,768.53 103 $14,603.76 Rain Barrel 5 $125.00 1 $25.00 17 $425.00 Zero Scape Total 2,591 $207,856.20 659 $54,231.15 2,687 $221,745.52 Cases Opened FY19 FY20 FY21 130 1200 1771 Wrong Day Watering Page 31 of 171 Page 32 of 171 Operational Items of Note Brazos River Authority Currently Has Lake Georgetown Drought Phase 1 City of Georgetown Basin Triggers (Stillhouse pump station to lake Georgetown 781 msl (old -on)783 msl (new -on) 783 msl (old -off)785 msl (new -off)Page 33 of 171 Resource Status •Integrated Water Resource Plan in Progress •ASR Phase 4 started •BRA RFP Water Resources (due March 21, 2022) https://brazos.org/Doing-Business/Purchasing-Professional-Services/Request-for-Proposals If you are contacted by a potential water provider with inquiries about the process, the BRA requests that all inquiries be directed to the BRA’s purchasing/procurement office to maintain the integrity of the evaluation process.Feel free to reach out to us if you have questions.We will continue to keep you updated on this planning effort. •Western District Meter Replacement project has been bid, evaluation and interviews ongoing •Master Plan in Progress City of GeorgetownPage 34 of 171 Engineering Page 35 of 171 Capital Improvement Projects (CIP) Design Wastewater –Cimarron Hills WWTP Expansion •CDM Smith Task Order approved October. Cost estimates have increased dramatically. Considering alternative lift station pump over to South San Gabriel Interceptor. Ongoing discussions with developer, engineer, Operations, and City Manager’s Office. –Berry Creek Interceptor (BC LS to PB WWTP) •Easement appraisals finalizing, acquisition support ongoing. 13 parcels total –4 outstanding. –San Gabriel Interceptor (SH29/SWU to PB WWTP) •Design on hold pending Wastewater Master Plan update and confirmation of line size, service area, and routing. –San Gabriel and Dove Springs WWTP rehab •Under design for major rehab of aging treatment plants. Ongoing coordination with Operations. Design Water –South Lake Water Treatment Plant •44mgd plant. Bid opening January 19th. –Shell Road Waterline •On hold pending BCI wastewater, expected 2022 bid. –Round Rock West and Hoover Pump Station, EST, & Linework •Currently under design pump site and easements. Tanks ready to bid after new year –steel prices high! –Southside WTP Rehab •Pilot study completed, foundation and roof/tank repair underway, rehab Fall 2022. Page 36 of 171 Capital Improvement Projects (CIP) Construction Wastewater –Aside from standard EARZ WW line rehab, no major WW projects currently under construction. Construction Water –Northlake Pump Station and Treatment Plant Expansion •980 pump station improvements –Substantially Complete •8.8MGD plant expansion –Cunningham Constructors (work underway). Page 37 of 171 Questions? City of GeorgetownPage 38 of 171 City of Georgetown WHAT IS AN IMPACT FEE? A one-time, up-front payment levied on new or expanded development for its capital costs being place on the utility system. Intended to mitigate rate impacts arising from the capital costs of new development and help make growth pay for itself. Impact Fees in Texas are statutorily addressed in Chapter 395 of the Local Government Code. Page 39 of 171 City of Georgetown The real issue underlying impact fees and rates is, “Who pays for utility capacity related to growth?” •If there are no impact fees, ratepayers carry the costs. •If there are impact fees, the costs are shared. The ultimate goal is to assure that: •Infrastructure needed to accommodate growth is constructed. •Capacity will be available when the development community needs it. •Limitations will not be placed on growth due to lack of utility capacity. Page 40 of 171 Water •Supply/Treatment •Storage •Pumping •Transmission Wastewater •Treatment •Pumping •Interceptors City of Georgetown Produces a maximum fee amount, subject to Council decision on that or lesser amount. FEE DESIGN Overall fees are made up of component fees Page 41 of 171 MAXIMUM FEE DETERMINATION City of Georgetown Define Impact Fee Service Area & Land Uses Estimate Water & Wastewater Utility Demands Compare to existing capacity Identify amount and cost of existing available capacity and new facility needs (10-Year CIP) Allocate current & future service demands to facilities Page 42 of 171 MAXIMUM FEE DETERMINATION City of Georgetown Calculate weighted cost of existing and new capacity per Living Unit Equivalent (LUE) Determine amount of capital being funded through rates per LUE Weighted Capacity Cost per LUE Minus: Rate Credit per LUE Equals: Maximum Impact Fee per LUE Page 43 of 171 FEE COORDINATION & DECISION-MAKING City of Georgetown Advisory Committee makes recommendations to Council City Council to set Public Hearing date Provide Public Notice of pending hearing Conduct Public Hearing Council Action Page 44 of 171 Impact Fees Fee Type Current Impact Fee - Water $ 6,921 Impact Fee – Wastewater $ 3,115 Impact Fee – South Fork Wastewater $ 4,348 Page 45 of 171 F FY2021 Quarterly Report EXECUTIVE SUMMARY FOR THE QUARTER ENDED SEP. 30, 2021 I. QUARTERLY FINANCIAL ANALYSIS Each year, the City amends the budget for multi-year capital projects, as well as operational changes that were unknown at the time the budget was adopted. The fourth Quarter Report Approved Budget includes Capital Project Roll Forward and Operational Amendments Approved by Council in January 2021, and the Mid-year Budget Amendment Approved in June 2021. The February Winter Storm Uri had a large impact on expenses for the second quarter. Council approved amendments related to the storm during a formal budget amendment in June 2021. Furthermore, this report compares actuals to budget, and compares to the performance of actuals in the same quarter in the previous year. The fourth quarter report also includes a comparison of year-to-date actuals to year-end projections. Please note this quarterly report includes unaudited figures. Currently, City staff along with our audit partners, are in the process of completing the year-end close out and the Comprehensive Annual Finance Report (CAFR). It is anticipated the CAFR process will be completed within the next few months and all numbers finalized. The numbers presented in this report are unaudited, preliminary, and subject to change. A Year-End Budget Amendment is proposed on the same Council Agenda as this report. The Year-End Amendment formalizes the projection to transfer $4.7 million of FY2020 available fund balance from the General Fund to the Council Special Revenue Fund to hold for appropriate one-time expenses approved by the Council. The amendment also formalizes other projections made after the mid-year amendment. Most notably, increased revenues and expenses in the Self-Insurance Fund due to acute claims, the American Rescue Fund Grant acceptance, the first tranche of the Mobility Bond debt and associated capital projects. Page 46 of 171 F FY2021 Quarterly Report GENERAL FUND REVENUES: General Fund revenues total $90,675,491, or 108.98% of budget through the end of FY2021. Revenues exceed last year’s same quarter total by $11,773,469, or 14.92%. The difference between the same period last year is primarily driven by increases in building permits, continued growth in sales tax, as well as one-time master development contributions. Municipal Court fines and Interest Income are both decreased compared to the same period last year due to the pandemic circumstances. General Fund Quarterly Comparison: Q4 FY2021 Budget FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % of Budget Variance % Variance Revenue 40001:Property Taxes 15,976,505 15,060,590 15,893,725 (82,780) 99.48% 833,135 5.53% 40002:Sales Taxes 18,576,250 19,108,465 23,895,422 5,319,172 128.63% 4,786,957 25.05% 40005:Franchise Taxes 6,255,270 5,757,843 6,183,295 (71,975) 98.85% 425,452 7.39% 40008:Other Taxes 400,000 399,896 481,489 81,489 120.37% 81,593 20.40% 41001:Fines 328,392 298,524 270,205 (58,187) 82.28% (28,319) -9.49% 41002:Penalties 60,000 64,989 104,967 44,967 174.95% 39,978 61.52% 42001:Interest Income 75,000 244,164 81,050 6,050 108.07% (163,114) -66.81% 43001:Fees 7,028,184 7,099,793 7,532,037 503,853 107.17% 432,244 6.09% 43002:Garbage Charges 10,151,764 10,086,812 10,867,148 715,385 107.05% 780,336 7.74% 43003:Permits 4,317,750 3,435,816 4,781,179 463,429 110.73% 1,345,363 39.16% 43004:Administrative Charges 3,396,447 2,717,730 3,392,501 (3,946) 99.88% 674,771 24.83% 43005:Rental Revenue 148,140 110,711 199,449 51,309 134.64% 88,738 80.15% 45001:Misc Revenue 871,955 122,015 717,891 (154,064) 82.33% 595,876 488.36% 45003:Misc Reimbursements - 872 13,521 13,521 0.00% 12,649 1450.59% 44001:Grant Revenue 679,884 1,322,553 914,494 234,610 134.51% (408,059) -30.85% 44501:Contribution Revenue - 150,000 - - 0.00% (150,000) -100.00% 44502:Developer Contributions 423,112 3,217 229,682 (193,430) 54.28% 226,465 7040.32% 44503:Interlocal Agreement Revenue 5,091,091 4,021,598 5,093,767 2,676 100.05% 1,072,169 26.66% 44504:Donations - 19,400 6,238 6,238 0.00% (13,162) -67.84% 70001:Transfers In 995,302 373,100 995,302 - 100.00% 622,202 166.77% 70002:Transfers In - Payment in Lieu of Taxes (PILOT) 8,431,375 8,503,933 9,022,128 590,753 107.01% 518,195 6.09% Revenue Total 83,206,421 78,902,022 90,675,491 7,469,070 108.98% 11,773,469 14.92% Page 47 of 171 F FY2021 Quarterly Report Sales tax revenue accounts for $18,576,250 of General Fund budgeted revenue. Through the quarters, the City has collected 128.63% of the budgeted sales tax amount, or $23,895,422. Sales tax data lags two months in arrears, but all accruals are made for FY2021. Sales tax continues to have a strong performance - the quarterly returns for sales tax were 25.05% higher compared to the same period last year. The increase in sales tax revenue is the result of continued growth in the City’s core sales tax sectors of retail, food, and information, in combination with new businesses coming online. Additionally, March of 2020 was the start of the pandemic resulting in dampened sales taxes beginning in that period. While these returns are excellent news, the City remains cautious in sales tax forecasting for FY2022. Building Materials make up a large portion of retail sales, and this sub-industry is experiencing supply chain pressures. The continuance of COVID variants impact on consumer habits and other economic indicators is also cause for caution. Property tax revenues are the second largest revenue segment in the General Fund and has a budget of $15,976,505. Property tax revenue is typically received during the first two quarters of the fiscal year, with most of the taxes collected in December and January. Through the quarter, property tax year-to-date collections total 99.48% of budget, or $15,893,725, reflecting the property tax base remains strong. Year-to-date property tax revenues are 5.53% higher than the same period last year. The City collects franchise fees for electric, natural gas, cable, and non-cellular telephone services. Through the quarter, franchise fee revenues total $6,183,295 in FY2021, or 98.85% of budget. Franchise fee revenue is 7.39% higher than the fourth quarter of FY2020. Payment in Lieu of Taxes (PILOT) revenue from City-owned utilities is budgeted at $8,431,375. Year-to-date, PILOT revenues total $9,022,128, or 107.01% of budget. PILOT revenue is $518,195, or 6.09% higher than the fourth quarter of FY2020. The Water and Wastewater Fund contributed more than their budgeted amount. This is from increase in customer base and consumption. The City capped the Electric Fund PILOT at $4,500,000 in FY2021. Planning and Development related revenue continues to be strong in FY2021. Planning and Development has a total revenue budget of $6,922,437. Through the quarter, planning and development reported revenues total $7,040,505 or 101.71% of budget. Permit fees are up 13.72%, or $274,249 compared to the same quarter in FY2020. Development related permits continue to be strong with year-to-date revenues up 38.81%, or $1,332,825 compared to year-to-date from FY2020. Staff continues to monitor the amount of residential building permits. The following graph shows the number of residential building permits issued by quarter for the past 3 years. K 2.0M 4.0M 6.0M 8.0M 10.0M Q1 Q2 Q3 Q4 GENERAL FUND: SALES TAX FY2020 FY2021 276 311 369 396370 537 469 531 682 665 589 591 - 200 400 600 Q1 Q2 Q3 Q4 Residential Building Permits FY2019 FY2020 FY2021Page 48 of 171 F FY2021 Quarterly Report Sanitation revenue budget totals $10,151,764. Through the quarter, year-to-date revenues from sanitation 10,867,148, or 105.37% of budget. Sanitation rates increased as part of the FY2021 budget to support demand for service as well as to support the debt service for a new transfer station. The variance between the same period last year is $780,336, or 7.74%. Fire and EMS total budgeted revenue is $8,012,095. Through the quarter, Fire and EMS fee related revenue totals $8,196,882, or 102.31% of budget. Additional Fire/EMS revenue is comprised of the Interlocal Agreement Emergency Services District 8 contract for service, as well as public safety grants such as the SAFER grant and unanticipated grant funding from FEMA for department physicals. Parks and Recreation fee revenue budget totals $1,893,234. Through the quarter, parks and recreation related fee revenue totals $2,114,979, or 111.71% of budget. Parks and Recreation revenue is up 36.60% compared to FY2020. The Parks and Recreation department has seen an increase in revenue compared to FY2020 as programming continues to increase to pre-COVID levels. Notable increases were in Garey Park and Recreation Center Memberships .FY2021 REVENUE PROJECTIONS: FY2021 year-to-date actuals came in higher than FY2021 projections. Total revenues were projected to end FY2021 at $87,814,662. Through the quarter, actuals are 103.26% of total projections. General Fund Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projections Revenue 40001:Property Taxes 15,976,505 15,893,725 (82,780) 99.48% 15,996,505 (102,780) 99.36% 40002:Sales Taxes 18,576,250 23,895,422 5,319,172 128.63% 22,924,375 971,047 104.24% 40005:Franchise Taxes 6,255,270 6,183,295 (71,975) 98.85% 6,182,563 731 100.01% 40008:Other Taxes 400,000 481,489 81,489 120.37% 410,000 71,489 117.44% 41001:Fines 328,392 270,205 (58,187) 82.28% 290,600 (20,395) 92.98% 41002:Penalties 60,000 104,967 44,967 174.95% 70,000 34,968 149.95% 42001:Interest Income 75,000 81,050 6,050 108.07% 87,429 (6,379) 92.70% 43001:Fees 7,028,184 7,532,037 503,853 107.17% 6,876,306 655,731 109.54% 43002:Garbage Charges 10,151,764 10,867,148 715,385 107.05% 10,300,000 567,148 105.51% 43003:Permits 4,317,750 4,781,179 463,429 110.73% 4,880,250 (99,071) 97.97% 43004:Administrative Charges 3,396,447 3,392,501 (3,946) 99.88% 3,396,447 (3,946) 99.88% 43005:Rental Revenue 148,140 199,449 51,309 134.64% 125,947 73,503 158.36% 45001:Misc Revenue 871,955 717,891 (154,064) 82.33% 804,049 (86,158) 89.28% 45003:Misc Reimbursements - 13,521 13,521 0.00% - 13,521 0.00% 44001:Grant Revenue 679,884 914,494 234,610 134.51% 500,000 414,495 182.90% 44501:Contribution Revenue - - - 0.00% - - 0.00% 44502:Developer Contributions 423,112 229,682 (193,430) 54.28% 423,332 (193,650) 54.26% 44503:Interlocal Agreement Revenue 5,091,091 5,093,767 2,676 100.05% 5,091,092 2,675 100.05% 44504:Donations - 6,238 6,238 0.00% - 6,238 0.00% 70001:Transfers In 995,302 995,302 - 100.00% 995,302 - 100.00% 70002:Transfers In - Payment in Lieu of Taxes (PILOT) 8,431,375 9,022,128 590,753 107.01% 8,460,467 561,661 106.64% Revenue Total 83,206,421 90,675,491 7,469,070 108.98% 87,814,662 2,860,829 103.26% Page 49 of 171 F FY2021 Quarterly Report GENERAL FUND EXPENSES: Annual expenses through the quarter total $79,743,765, or 96.09% of budget. This is an increase of 7.93% compared to the same period last year. The increase is driven by increases in operational expense such as internal service allocations, and timing of transfers. Additionally, increase in expense compared to the same period last year is due to COVID and the winter storm and the general delay those events caused in entering into various consulting services contracts. Merit and market adjustments for personnel expenses are also a factor in the increase spending compared to last year. Personnel and Operations Summary Personnel costs through the quarter total $45,808,334, or 100.20% of personnel budget. Operational costs total $32,394,577, or 91.73%. The table below includes all expenditures in the General Fund. Capital costs can fluctuate from year-to-year based on projects, timing, and various other factors, primarily in the Streets cost center. General Fund Quarterly Comparison: Q4 FY2021 Budget FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % Of Budget Variance % Variance Expense Personnel 45,716,778 41,394,712 45,808,334 (91,556) 100.20% (4,413,622) 10.66% Operations 35,315,108 30,717,258 32,394,577 2,920,532 91.73% (1,677,319) 5.46% Operating Capital 298,603 1,144,727 183,939 114,664 61.60% 960,788 -83.93% CIP Expense - 36,962 - - 0.00% 36,962 -100.00% Transfers 1,654,691 591,860 1,356,916 297,775 82.00% (765,056) 129.26% Total Expense 82,985,180 73,885,519 79,743,765 3,241,415 96.09% (5,858,247) 7.93% Many departments in the General Fund were impacted by the February winter storm. The public safety division and public works division were impacted the most. As part of the FY2021 Mid-Year Budget Amendment, staff proposed additional appropriation to cover unforeseen overtime cost and operational costs related to the storm. A complete list of cost center, budget, actuals, and projections is attached as part of supplemental information to this report. Personnel and Operations Summary by Division: DEVELOPMENT SERVICES DIVISION: Through the quarter Planning has reported expenses totaling $1,750,470, or 88.49% of budget. Inspections incurred personnel and operational expenses amounting to $1,459,857, or 94.31% of budget. Year-to-date personnel and operational expenditures for Community Services are as follows, Community Services main cost center has a total of $350,621, or 99.08% of budget, through the quarter, Animal Services has reported $934,970, which is 84.48% of their budget, Code Compliance has shown spending of $483,750, or 85.96% of budget. Animal Services and Code Compliance had vacancies throughout the year, resulting in less than anticipated expenses. Environmental Services incurred personnel and operational expenditures amounting to $9,587,669, or 99.22% of budget. Page 50 of 171 F FY2021 Quarterly Report Public Works personnel and operational expenditures for the quarter totals $1,365,719, which represents 80.06% of budget. Year-to-date expenditures related to personnel and operations for Streets totals $2,872,098, 91.55% of budget. FINANCE ADMINISTRATION DIVISION: Municipal Court year-to-date expenses total $554,822, or 94.82% of budget. This spending includes $476,716 for personnel costs and $82,453 for operational costs. POLICE OPERATIONS DIVISION: Police Operations saw personnel and operational expenditures through the quarter totals $14,763,085, or 100.64% of budget. Police Administration expenditures through the quarter resulted in $2,365,080, or 92.10% of budget. FIRE AND EMS DIVISION: Year-to-date personnel and operational expenditures through the quarter total $3,766,322, or 86.61% of budget for Fire Support Services/Administration, $15,520,210, or 97.28% of budget for Fire Emergency Services, and $2,879,530, or 111.59% of budget for Fire EMS. Fire Emergency Services budget was budgeted with positions that typically are in the EMS cost center. The Fire budget is viewed at a division level which includes the roll-up of all Fire associated cost centers. The overall division is under budget in FY2021. ADMINISTRATIVE SERVICES DIVISION: Administrative Services saw operational and personnel costs totaling $1,694,473, or 89.47% of budget year-to-date. City Secretary personnel and operational expenditures for the quarter totals $981,238, which represents 97.17% of budget. Year-to-date personnel and operational expenditures for Communications totals $704,633, which represents 83.43% of budget. Non-Departmental includes a transfer out of $1,369,493, or 82.76% of anticipated transfer expense for the year. A year-end budget amendment is proposed to transfer $4,700,000 from the General Fund to the Council SRF. The transfer is to reserve one-time available savings from FY2020 for future one-time expenses as approved by the Council. This transfer is reflected in the FY2021 projections. General Government Contracts includes budgeted vacancy savings estimates for all General Fund departments. Real vacancy savings is realized in each cost center. The budgeted vacancy factor against year-to-date actuals in the administrative division cost center drives the percent of budget up. Staff will adjust and forecast the vacancy factor as part of the FY2021 projections. LIBRARY, TOURISM, AND ARTS AND CULTURE DIVISION: Arts and Culture recognized year to date expenses totaling $82,372, or 142.37% of budget. Library year-to-date expenses total $2,699,109, or 95.11% of budget. The overage is due to a shift in booking Arts & Culture personnel from the Library cost center to Arts & Culture cost center to align with organizational structure. PARKS AND RECREATION DIVISION: Year-to-date personnel and operations costs for Parks and Recreation within the following cost centers: Parks Administrations, Parks, Garey Park, Tennis Center, Recreation, and Recreation Programs, comes to a total of $8,162,487, or 91.16% of budget. Parks year-to-date through the quarter totals $2,583,064, or 94.71% of budget. Recreational Programs total expenses are $948,688, which is 75.81% of budget. Garey Park year-to-date is $857,934, or 87.36% of budget. Page 51 of 171 F FY2021 Quarterly Report Personnel and Operations Summary by Division: General Fund Quarterly Comparison: Q4 FY2021 Budget Actuals Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections 2021 Variance Fav/(Unfav) % of Projection Development Services Personnel 6,213,438 5,706,390 507,048 91.84% 5,824,965 118,574 97.96% Operations 13,812,057 13,081,536 730,522 94.71% 13,788,192 706,656 94.87% Operating Capital 29,789 17,227 12,562 57.83% 41,564 24,337 41.45% Development Services Total Expense 20,055,285 18,805,153 1,250,132 93.77% 19,654,721 849,568 95.68% Finance Administration Personnel 484,734 476,716 (32,203) 98.35% 473,558 (3,158) 100.67% Operations 100,389 78,106 4,347 77.80% 83,151 5,044 93.93% Finance Administration Total Expense 585,123 554,822 30,301 94.82% 556,709 1,887 99.66% Police Operations Personnel 12,961,182 13,227,102 (265,920) 102.05% 12,876,859 (350,243) 102.72% Operations 4,198,668 3,881,695 316,973 92.45% 4,120,724 239,029 94.20% Operating Capital 77,104 19,368 57,736 25.12% 77,104 57,736 25.12% Police Operations Total Expense 17,236,954 17,128,165 108,789 99.37% 17,074,687 (53,478) 100.31% Fire and EMS Personnel 18,120,403 17,672,086 448,317 97.53% 18,215,389 543,303 97.02% Operations 4,599,221 4,375,064 224,157 95.13% 4,443,242 68,178 98.47% Operating Capital 162,899 118,912 43,987 73.00% 162,470 43,558 73.19% Fire and EMS Total Expense 22,882,523 22,166,062 716,461 96.87% 22,821,101 655,039 97.13% Administrative Services Personnel 1,326,001 2,542,113 (1,216,112) 191.71% 2,315,816 (226,297) 109.77% Operations 7,382,852 6,246,565 1,136,287 84.61% 7,144,768 898,202 87.43% Transfers 1,654,691 1,356,916 297,775 82.00% 6,354,691 4,997,775 21.35% Administrative Services Total Expense 10,363,544 10,145,594 217,950 97.90% 15,815,274 5,669,680 64.15% Library, Tourism, and Arts and Culture Personnel 1,798,754 1,708,455 90,299 94.98% 1,828,761 120,306 93.42% Operations 1,068,507 1,064,474 4,033 99.62% 1,074,019 9,546 99.11% Operating Capital 28,500 8,553 19,947 30.01% 7,960 (593) 107.46% Library, Tourism, and Arts and Culture Total Expense 2,895,761 2,781,482 114,279 96.05% 2,910,740 129,258 95.56% Parks and Recreation Personnel 4,812,266 4,475,473 336,793 93.00% 4,735,425 259,952 94.51% Operations 4,153,414 3,667,136 486,278 88.29% 3,908,685 241,549 93.82% Operating Capital 311 19,879 (19,568) 6392.30% - (19,879) 0.00% CIP Expense - - - 0.00% - - 0.00% Parks and Recreation Total Expense 8,965,991 8,162,487 803,503 91.04% 8,644,110 481,623 94.43% General Fund Total 82,985,180 79,743,765 3,241,415 96.09% 87,477,342 7,733,577 91.16% Page 52 of 171 F FY2021 Quarterly Report FY2021 EXPENSE PROJECTIONS: Total expenses are projected to end FY2021 at $87,477,342. Through the quarter, actual expenses are 91.16% of total projections. Preliminary, unaudited projected ending available balance is $12,499,020. As previously mentioned, $4,700,000 of expense will process in the year-end budget amendment to transfer FY2020 one-time savings in fund balance to the Council Special Revenue Fund. Additionally, Since the City converted to a new financial software system in FY2020, open encumbrances are no longer held in a prior year. Instead, these commitments for operational and capital expense are rolled forward into the next year. It should be noted that several unfinished projects from FY2021 will be rolled forward into FY2022 and staff will be bringing forward a budget amendment of approximately $495,000. After accounting for the transfer to the Council Special Revenue Fund and Capital Roll Forwards requirements, ending available fund balance is estimated at $5.8 million. These figures are preliminary and unaudited. Staff is exercising caution in presenting options for the use of available fund balance until the year-end audit is complete. Overall, General Fund expenditures are within budget and the fund can cover the 90-day Contingency Reserve, Economic Stability Reserve, and the Benefit Payout Reserve. Page 53 of 171 F FY2021 Quarterly Report UTILITY FUNDS: Electric Fund: The City has used multiple strategies in the past two years to improve the performance of the Electric Fund in relation to past and current expenditures for purchased power contracts. These strategies include increasing the Power Cost Adjustment rate to recover revenue, reducing operating and capital expenditures in the electric utility, selling utility assets, hiring a new General Manager, and contracting professional services for energy portfolio management and risk oversight. These have resulted in improved financial performance of the fund. To improve rate competitiveness for customers, the City lowered the Power Cost Adjustment in January of 2021 by 1 cent per kWh, to 1.375 cents per kWh. This resulted in a $5 million decrease in Electric Revenue as part of the FY2021 Amended budget in January and is reflected in this report. Many departments in the utility funds were impacted by the winter storm. The Electric and Water fund incurred significant increases in overtime, operations, and equipment needs/replacement. As part of the FY2021 Mid-Year Budget Amendment City Council has approved additional appropriation to cover unforeseen costs associated with the winter storm. As part of the FY2022 budget development process, the utilities are reviewing various initiatives to improve resiliency to extreme weather, including those required by legislation. ELECTRIC REVENUE: Operating revenue in the Electric Fund totals $95,470,292 through the quarter, or 110.20% of budget. Electric sales revenue, the largest component of operating revenue, has brought in $80,933,053 through the quarter, totaling 102.47% of Electric charges budget. Electric revenue sales are typically higher in the summer months when consumption increases due to hot weather. As this summer was relatively mild, revenue projections were conservative, and Electric sales revenue ended the year at 102.34% of projection. Developer contributions were conservatively budgeted at $1,500,000. Year-to-date collection totals $7,828,988, or 521.93% of budget. Developer contributions drive the need for utility infrastructure, while there is an increase in revenue, there are more new development project expenses than anticipated. Due to global supply chain issues the cost of material for electric infrastructure projects increased significantly. These cost increases also resulted in increased capital expenses. These capital expenses will be presented in a year-end budget amendment. Electric Services Quarterly Comparison: Q4 FY2021 Budget FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % of Budget Variance % Variance Operating Revenue 40002:Sales Taxes 5,000 7,358 5,863 863 117.25% (1,495) -20.32% 40005:Franchise Taxes 115,732 - - (115,732) 0.00% - 0.00% 41002:Penalties 553,724 529,508 848,000 294,276 153.14% 318,492 60.15% 42001:Interest Income 5,000 10,703 33,570 28,570 671.40% 22,867 213.64% 43001:Fees 685,000 614,274 1,036,657 351,657 151.34% 422,383 68.76% 43004:Administrative Charges 3,222,103 3,192,618 3,222,103 (0) 100.00% 29,485 0.92% 43601:Electric Charges 78,982,278 85,733,316 80,933,053 1,950,775 102.47% (4,800,262) -5.60% 44502:Developer Contributions 1,500,000 4,476,298 7,828,988 6,328,988 521.93% 3,352,689 74.90% 70001:Transfers In 1,562,058 500,000 1,562,058 - 100.00% 1,062,058 212.41% Operating Revenue Total 86,630,895 95,064,075 95,470,292 8,839,397 110.20% 406,216 0.43% Non-Operating Revenue 45001:Misc Revenue 35,000 195,508 523,214 488,214 1494.90% 327,706 167.62% 45004:Sale of Property 10,000 10,813,949 4,127,598 4,117,598 41275.98% (6,686,351) -61.83% 44001:Grant Revenue - 1,860 - - 0.00% (1,860) -100.00% 46001:Bond Proceeds 54,648,625 5,055,000 54,065,000 (583,625) 98.93% 49,010,000 969.54% 46002:Bond Premium - - 652,424 652,424 0.00% 652,424 0.00% Non-Operating Revenue Total 54,693,625 16,066,317 59,368,236 4,674,611 108.55% 43,301,919 269.52% Revenue Total 141,324,520 111,130,393 154,838,528 13,514,008 109.56% 43,708,136 39.33% Page 54 of 171 F FY2021 Quarterly Report The budget for non-operating revenue totals $54,693,625 in FY2021. The city has recognized revenues of $54,065,000 in bond proceed revenues through the quarter due to the debt financing of the energy costs of Winter Storm Uri. Year-to-date non- operating revenues are above the fourth quarter of FY2020, mainly driven by the debt issuance from the winter storm extreme energy costs. FY2021 REVENUE PROJECTIONS: FY2021 operating revenue projections came in slightly higher than anticipated at $95,470,292. Total operating revenues were projected to end the year at $91,408,444. The largest component of operating revenue is electric sales revenue, which is projected to end the year at $79,081,809. Electric charges came in at $80,933,053, or 102.34% of projections. This is largely driven by healthy customer growth, along with a slight increase in utility usage in the late summer months. Through the quarter, actuals make up 104.44% of total operating revenue projections. Total non-operating revenues are projected to end FY2021 at $57,477,051. This includes $2,526,604 of renewable energy credits (REC) accounted for in Sale of Property. The City continues to sell RECs in the market when advantageous and was able to bring revenue in $1,600,994 over projections, for a total revenue of $4,127,598. Through the quarter, actuals are 103.29% of total non-operating revenue projections. Electric Services Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projection Operating Revenue 40002:Sales Taxes 5,000 5,863 863 117.25% 5,000 863 117.25% 40005:Franchise Taxes 115,732 - (115,732) 0.00% - - 0.00% 41002:Penalties 553,724 848,000 294,276 153.14% 547,759 300,241 154.81% 42001:Interest Income 5,000 33,570 28,570 671.40% 20,828 12,742 161.18% 43001:Fees 685,000 1,036,657 351,657 151.34% 868,887 167,770 119.31% 43004:Administrative Charges 3,222,103 3,222,103 (0) 100.00% 3,222,103 (0) 100.00% 43601:Electric Charges 78,982,278 80,933,053 1,950,775 102.47% 79,081,809 1,851,244 102.34% 44502:Developer Contributions 1,500,000 7,828,988 6,328,988 521.93% 6,100,000 1,728,988 128.34% 70001:Transfers In 1,562,058 1,562,058 - 100.00% 1,562,058 - 100.00% Operating Revenue Total 86,630,895 95,470,292 8,839,397 110.20% 91,408,444 4,061,848 104.44% Non-Operating Revenue 45001:Misc Revenue 35,000 523,214 488,214 1494.90% 233,023 290,191 224.53% 45004:Sale of Property 10,000 4,127,598 4,117,598 41275.98% 2,526,604 1,600,994 163.37% 44001:Grant Revenue - - - 0.00% - - 0.00% 46001:Bond Proceeds 54,648,625 54,065,000 (583,625) 98.93% 54,065,000 - 100.00% 46002:Bond Premium - 652,424 652,424 0.00% 652,424 0 100.00% Non-Operating Revenue Total 54,693,625 59,368,236 4,674,611 108.55% 57,477,051 1,891,185 103.29% Revenue Total 141,324,520 154,838,528 13,514,008 109.56% 148,885,495 5,953,033 104.00% K 5.0M 10.0M 15.0M 20.0M 25.0M Q1 Q2 Q3 Q4 ELECTRIC FUND: ELECTRIC SALES REVENUE FY2020 FY2021 Page 55 of 171 F FY2021 Quarterly Report ELECTRIC EXPENSES: Operating expenses in the Electric Fund total $134,738,524 through the quarter. Year-to-date purchase power expenses total $108,693,051, while net congestion revenue rights (CRRs) credits total $989,262. This is due to congestion in the grid. Without the event of the winter storm purchase power expenses would be $60,693,051, or 9.2% than FY2020 actuals. The polar vortex winter storm Uri caused significant disruption in the Texas energy market. This disruption led to extreme price spikes in the cost of energy, and the City had a net obligation of approximately $48 million. The $48 million is beyond the City’s capacity to handle with current unrestricted reserves. For comparison, the annual cost of energy is about $60 million. Therefore, the City has secured a Public Property Finance Contractual Obligation (PPFCO). This is a tax-backed obligation with a subordinate lien on Electric Utility revenues. The PPFCO has a 9.5-year term, with a 5-year call option. This is a fixed rate bond (1.73% taxable) that was privately placed with Wells Fargo. It is structured with level annual payments. The average annual principal and interest payment of $5,298,851 will be repaid with Electric revenues and the current Power Cost Adjustment of 1.375 per kWh. Given the unusual circumstances of the winter storm’s costs, staff is working closely with the External Auditor, Bond Counsel and Financial Advisor on all related accounting procedures for the year-end financial statements. In addition to overtime from the winter storm, personnel costs in Electric Engineering and Transmission and Distribution (T&D) cost centers look inflated. This labor will be capitalized to the appropriate capital improvement project on the final year-end financial statements. Electric Services Quarterly Comparison: Q4 FY2021 Budget FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % of Budget Variance % Variance Operating Expense City of Georgetown (Only) - 252,201 - - 0.00% 252,201 -100.00% CC0001 Non-Departmental 5,506,375 4,868,428 6,520,044 (1,013,669) 118.41% (1,651,616) 33.93% CC0522 Electric Administration 8,738,792 10,243,728 8,868,267 (129,476) 101.48% 1,375,461 -13.43% CC0525 T&D Services 3,122,421 3,951,577 4,185,597 (1,063,176) 134.05% (234,020) 5.92% CC0526 Systems Engineering - (291,007) - - 0.00% (291,007) -100.00% CC0537 Electric Resource Management 108,334,393 65,419,453 109,900,806 (1,566,413) 101.45% (44,481,354) 67.99% CC0555 Electric Systems Operations 1,610,228 1,441,701 1,579,253 30,976 98.08% (137,552) 9.54% CC0557 Electrical Engineering 663,952 839,101 1,070,057 (406,104) 161.16% (230,955) 27.52% CC0521 Electric Technical Services 727,388 603,639 670,962 56,426 92.24% (67,322) 11.15% CC0524 Metering Services 2,022,094 1,848,935 1,939,497 82,597 95.92% (90,562) 4.90% CC0526 Systems Engineering - (291,007) - - 0.00% (291,007) -100.00% Operating Expense Total 130,725,643 89,177,755 134,738,524 (4,012,881) 103.07% (45,560,769) 51.09% Non-Operating Expense CC0001 Non-Departmental 4,375,805 3,924,104 4,298,971 76,834 98.24% (374,867) 9.55% CC0557 Electrical Engineering 8,166,143 1,850,513 3,386,145 4,779,997 41.47% (1,535,632) 82.98% CC0526 Systems Engineering - 1,030,860 - - 0.00% 1,030,860 -100.00% Non-Operating Expense Total 12,541,948 6,805,477 7,685,116 4,856,831 61.28% (879,639) 12.93% Expense Total 143,267,591 95,983,232 142,423,640 843,951 99.41% (46,440,408) 48.38% Non-operating expenditures are budgeted at $12,541,948 in FY2021. Budgeted non-operating expenditures include $8,166,143 for capital projects and $4,375,805 for debt service payments, both of which typically trend towards later quarters. As previously mentioned, a significant portion of labor expenses for capital projects will be journaled at the end of the fiscal year, bringing operations and capital expense in balance with their budgets. Page 56 of 171 F FY2021 Quarterly Report FY2021 EXPENSE PROJECTIONS: Total operating expenses were projected to end FY2021 at $132,217,192. The overage in FY2021 projections is due from writing off uncollectible bill revenues that are older than 120 days. The City hired a collections agency in the summer and they are making progress on reducing outstanding receivables. Through the quarter, actuals are 101.91% of total operating expense projections. Electric Services Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections 2021 Variance Fav/(Unfav) % of Projections Operating Expense City of Georgetown (Only) - - - 0.00% - - 0.00% CC0001 Non-Departmental 5,506,375 6,520,044 (1,013,669) 118.41% 6,668,720 148,676 97.77% CC0522 Electric Administration 8,738,792 8,868,267 (129,476) 101.48% 8,944,477 76,210 99.15% CC0525 T&D Services 3,122,421 4,185,597 (1,063,176) 134.05% 3,089,942 (1,095,655) 135.46% CC0526 Systems Engineering - - - 0.00% 80,506 80,506 0.00% CC0537 Electric Resource Management 108,334,393 109,900,806 (1,566,413) 101.45% 108,331,349 (1,569,457) 101.45% CC0555 Electric Systems Operations 1,610,228 1,579,253 30,976 98.08% 1,639,454 60,202 96.33% CC0557 Electrical Engineering 663,952 1,070,057 (406,104) 161.16% 715,684 (354,372) 149.52% CC0521 Electric Technical Services 727,388 670,962 56,426 92.24% 717,148 46,186 93.56% CC0524 Metering Services 2,022,094 1,939,497 82,597 95.92% 2,029,912 90,414 95.55% CC0526 Systems Engineering - - - 0.00% 80,506 80,506 0.00% Operating Expense Total 130,725,643 134,738,524 (4,012,881) 103.07% 132,217,192 (2,521,332) 101.91% Non-Operating Expense CC0001 Non-Departmental 4,375,805 4,298,971 76,834 98.24% 4,373,805 74,834 98.29% CC0557 Electrical Engineering 8,166,143 3,386,145 4,779,997 41.47% 8,166,142 4,779,997 41.47% CC0526 Systems Engineering - - - 0.00% - - 0.00% Non-Operating Expense Total 12,541,948 7,685,116 4,856,831 61.28% 12,539,947 4,854,831 61.29% Expense Total 143,267,591 142,423,640 843,951 99.41% 144,757,139 2,333,499 98.39% Non-operating expenses are projected to end FY2021 at $12,539,947, which is 61.29% of year-to-date actuals through the quarter. Approximately $6 million in unfinished capital projects expenses will be presented in the FY2022 Rollforward Budget Amendment. The Electric Fund anticipates meeting all the funds below line contingency requirements by the end of FY2021. Contingency requirements include a 90-day operating contingency of $4,018,754, a reserve for bond proceeds totaling $4,448,314, non-operating reserve of $3,486,903, as well as re-establishing a rate stabilization reserve in the amount of $18,600,000 at the end of FY2021. After accounting for the Capital Roll Forward requirement, ending available fund balance is estimated at $3.9 million. This is $2.2 million over the projection of $1.7 million. These figures are preliminary and unaudited. Staff is exercising caution in presenting options for the use of available fund balance or any proposed changes to rates until the year-end audit is completed and purchased power is managed during the coming winter months. Page 57 of 171 F FY2021 Quarterly Report FY2021 Quarterly Report K 5.0M 10.0M 15.0M 20.0M FY2020 FY2021 FY2020 FY2021 FY2020 FY2021 FY2020 FY2021 Q1 Q2 Q3 Q4 WATER FUND: CHARGES FOR SERVICES Irrigation Charges Wastewater Charges Water Charges Water Fund: WATER REVENUE: Year-to-date Operating revenue totals $108,806,038, or 153.44% of budget. The largest revenue streams in the Water Fund are charges for services for water, wastewater, and irrigation use. Through the quarter, Water Charges total $41,143,198, which is 127.97% of budget. Year-to-date, Wastewater Charges are $15,125,001, or 106.51% of budget. Irrigation Charges total $360,002 for the quarter, or 120.00% of budget. Increases in number of meters and customers as well as rate increase effect January 1st, have proven to significantly increase year-to-date revenues for the Water Fund from 2020 to 2021. The budget for Impact Fees for the fiscal year is $18,800,000. Through the quarter, impact fee revenues total $40,034,496, or 212.95% of budget. Water utility staff included an updated estimate of these fees for fiscal year- end projections and for FY2022 planning. The increase in impact fees is attributed to growth as well as an increase in the installation of meters that are larger in diameter such as meters used for multi-family housing. FY2020’s new Living Equivalent Units was 4,470, while FY2021’s LEU’s installed were 5,822. This equates to is a 30% increase. Impact fees are used for funding capital infrastructure approved in the impact fee plan. They may be used as a cash equivalent, or to repay debt service for the projects. Staff are currently in the process of reconciling impact fees available to assist with the needed expansion of the South Lake Treatment Plant, along with other large projects. Water Quarterly Comparison: Q4 FY2021 Budget FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % of Budget Variance % Variance Operating Revenue 41002:Penalties 255,000 305,880 513,447 258,447 201.35% 207,567 67.86% 42001:Interest Income 237,250 1,475,880 427,758 190,508 180.30% (1,048,122) -71.02% 43001:Fees 4,290,000 6,644,405 9,598,958 5,308,958 223.75% 2,954,553 44.47% 43005:Rental Revenue 55,000 61,178 112,975 57,975 205.41% 51,797 84.67% 43602:Water Charges 32,150,000 35,208,127 41,143,198 8,993,198 127.97% 5,935,071 16.86% 43603:Wastewater Charges 14,200,000 14,282,982 15,125,001 925,001 106.51% 842,019 5.90% 43604:Irrigation Charges 300,000 513,679 360,002 60,002 120.00% (153,677) -29.92% 41602:Impact Fees 18,800,000 27,891,155 40,034,496 21,234,496 212.95% 12,143,341 43.54% 44502:Developer Contributions 625,000 661,160 1,490,202 865,202 238.43% 829,042 125.39% Operating Revenue Total 70,912,250 87,044,447 108,806,038 37,893,788 153.44% 21,761,591 25.00% Non-Operating Revenue 45001:Misc Revenue 1,112,500 559,186 1,312,616 200,116 117.99% 753,430 134.74% 45003:Misc Reimbursements - - 10,422 10,422 0.00% 10,422 0.00% 45004:Sale of Property 1,327,774 735,404 1,330,463 2,689 100.20% 595,058 80.92% 44001:Grant Revenue - 338 - - 0.00% (338) -100.00% 46001:Bond Proceeds 16,300,000 9,375,000 14,975,000 (1,325,000) 91.87% 5,600,000 59.73% 46002:Bond Premium - - 1,415,140 1,415,140 0.00% 1,415,140 0.00% Non-Operating Revenue Total 18,740,274 10,669,927 19,043,639 303,365 101.62% 8,373,712 78.48% Revenue Total 89,652,524 97,714,374 127,849,678 38,197,154 142.61% 30,135,303 30.84% Page 58 of 171 F FY2021 Quarterly Report FY2021 Quarterly Report K 250K 500K 750K 1.0M Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep WATER FUND: CONSUMPTION (KGALS) FY2020 FY2021 Total Water Fund operating revenue is up 116.86% compared to the same period last fiscal year due to growth in sales and collections in impact fees. Year-to- date consumption of water has increased 9% over FY2020, despite a relatively wet summer. The budget for non-operating revenue totals $18,740,274 in FY2021. This total includes bond proceeds for capital projects in the amount of $16,300,000. Year to date through the quarter the City has recognized bond proceed and premium revenues. Sale of property revenue includes the Chisolm Trail building sale to the City of Florence. Misc revenue includes the Blanchard contract revenue, billed annually in the 4th quarter. FY2021 REVENUE PROJECTIONS: Water Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projections Operating Revenue 41002:Penalties 255,000 513,447 258,447 201.35% 355,000 158,447 144.63% 42001:Interest Income 237,250 427,758 190,508 180.30% 492,336 (64,577) 86.88% 43001:Fees 4,290,000 9,598,958 5,308,958 223.75% 7,655,000 1,943,958 125.39% 43005:Rental Revenue 55,000 112,975 57,975 205.41% 60,000 52,975 188.29% 43602:Water Charges 32,150,000 41,143,198 8,993,198 127.97% 35,100,000 6,043,198 117.22% 43603:Wastewater Charges 14,200,000 15,125,001 925,001 106.51% 14,000,000 1,125,001 108.04% 43604:Irrigation Charges 300,000 360,002 60,002 120.00% 300,000 60,002 120.00% 41602:Impact Fees 18,800,000 40,034,496 21,234,496 212.95% 32,500,000 7,534,496 123.18% 44502:Developer Contributions 625,000 1,490,202 865,202 238.43% 1,496,239 (6,037) 99.60% Operating Revenue Total 70,912,250 108,806,038 37,893,788 153.44% 91,958,575 16,847,463 118.32% Non-Operating Revenue 45001:Misc Revenue 1,112,500 1,312,616 200,116 117.99% 1,262,350 50,266 103.98% 45003:Misc Reimbursements - 10,422 10,422 0.00% - 10,422 0.00% 45004:Sale of Property 1,327,774 1,330,463 2,689 100.20% 1,327,774 2,689 100.20% 44001:Grant Revenue - - - 0.00% - - 0.00% 46001:Bond Proceeds 16,300,000 14,975,000 (1,325,000) 91.87% 14,975,000 - 100.00% 46002:Bond Premium - 1,415,140 1,415,140 0.00% 1,415,140 (0) 100.00% Non-Operating Revenue Total 18,740,274 19,043,639 303,365 101.62% 18,980,264 63,375 100.33% Revenue Total 89,652,524 127,849,678 38,197,154 142.61% 110,938,839 16,910,839 115.24% Operating revenue for the Water Fund was projected to end FY2021 at $91,958,575, but actual revenues are $16,847,463 higher. The City is averaging an additional 370 new meters a month and 3,388 new wastewater connections per year over the past two years. Overall, operating revenue year-to-date actuals make up 118.32%, and exceed projections. In addition to the analysis on water impact fee use for capital projects, the City is working with a consultant on a rate study to evaluate growth projections, rate class equity, conservation, and the financial sustainability of the utility. Page 59 of 171 F FY2021 Quarterly Report FY2021 Quarterly Report Total non-operating revenues are projected to end FY2021 at $18,980,264. Through the quarter, actual revenues are 100.33% of total non-operating projections. WATER EXPENSES: Operating expenditures in the Water Fund total $43,022,509 through the quarter, or 90.56% of budget. The Non- departmental Cost Center is over budget due to writing off bad debt expense and an increase in PILOT expense to the General Fund. The PILOT calculation is based off usage, thus an increase in usage increases the amount transferred to the General Fund. Water Operations is over budget due increased OT and personnel costs associated with the winter storm. The negative entry for Systems Engineering reflects a true-up of data conversion from the financial software changes to Operational costs are trending on budget. Water Services Financial Report Quarterly Comparison: Q4 FY2021 Budget FY2020 FY2021 FY2021 Year-to-date: Budget Vs. Actuals Quarterly Comparison FY2021 YTD Actuals: Q4 FY2020 YTD Actuals: Q4 FY2021 Variance % of Budget Variance % Variance Operating Expense City of Georgetown (Only) - 210,469 - - 0.00% 210,469 -100.00% CC0001 Non-Departmental 4,223,814 4,255,702 5,131,684 (907,870) 121.49% (875,982) 20.58% CC0526 Systems Engineering - 7,130,305 (1,836,056) 1,836,056 0.00% 8,966,361 -125.75% CC0532 Irrigation Operations 295,000 268,930 139,285 155,715 47.22% 129,646 -48.21% CC0530 Wastewater Operations 896,265 764,733 547,171 349,094 61.05% 217,562 -28.45% CC0531 Wastewater Plant Management 4,013,950 3,271,553 3,516,184 497,766 87.60% (244,631) 7.48% CC0527 Water Services Administration 26,369,169 23,848,381 24,491,296 1,877,873 92.88% (642,915) 2.70% CC0528 Water Distribution 3,207,552 2,626,683 3,176,051 31,501 99.02% (549,369) 20.91% CC0529 Water Plant Management 4,326,865 3,685,707 3,479,406 847,459 80.41% 206,302 -5.60% CC0553 Water Operations 4,173,316 4,325,327 4,377,488 (204,172) 104.89% (52,161) 1.21% Operating Expense Total 47,505,930 50,387,791 43,022,509 4,483,421 90.56% 7,365,282 -14.62% Non-Operating Expense CC0001 Non-Departmental 4,083,411 3,131,244 92,665 3,990,746 2.27% 3,038,578 -97.04% CC0526 Systems Engineering 99,509,468 4,264,398 13,900,168 85,609,300 13.97% (9,635,770) 225.96% CC0532 Irrigation Operations 121,879 125,075 121,994 (115) 100.09% 3,081 -2.46% CC0530 Wastewater Operations 3,026,798 10,351,145 3,160,381 (133,583) 104.41% 7,190,763 -69.47% CC0531 Wastewater Plant Management 2,050,000 - - 2,050,000 0.00% - 0.00% CC0527 Water Services Administration - - - - 0.00% - 0.00% CC0528 Water Distribution 1,159,424 77,506 781,316 378,108 67.39% (703,809) 908.07% CC0529 Water Plant Management 2,757 - - 2,757 0.00% - 0.00% CC0553 Water Operations 14,124,300 2,081,831 11,704,343 2,419,957 82.87% (9,622,512) 462.21% CC0524 Metering Services 750,000 - - 750,000 0.00% - 0.00% Non-Operating Expense Total 124,828,037 20,031,198 29,760,867 95,067,170 23.84% (9,729,669) 48.57% Expense 172,333,967 70,418,989 72,783,376 99,550,591 57.77% (2,364,387) 3.36% Non-operating expense are budgeted at $124,828,037 in FY2021. Expenses total $29,760,867 through the quarter, which includes expenses for large projects as well as payment for debt services. Principal debt payments are made in the 4th quarter. Large variances between Systems Engineering and Water Operations cost centers compared to FY2020 are due to data coding changes in the new financial reporting system that are related to new tracking mechanisms for capital projects. Page 60 of 171 F FY2021 Quarterly Report FY2021 Quarterly Report Unspent commitments for large multi-year capital projects will be proposed in an FY2022 Roll Forward Budget Amendment. Approximately $93.3 million in water and wastewater projects are positioned to roll forward. FY2021 EXPENSE PROJECTIONS: Total expenses are projected to end FY2021 at $171,645,358. Water Services Financial Report Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date: Budget Vs. Actuals FY2021 Year-to-date Vs. Projections FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projection Operating Expense City of Georgetown (Only) - - - 0.00% - - 0.00% CC0001 Non-Departmental 4,223,814 5,131,684 (907,870) 121.49% 4,713,430 (418,254) 108.87% CC0526 Systems Engineering - (1,836,056) 1,836,056 0.00% (639,847) 1,196,209 286.95% CC0532 Irrigation Operations 295,000 139,285 155,715 47.22% 295,000 155,715 47.22% CC0530 Wastewater Operations 896,265 547,171 349,094 61.05% 834,706 287,535 65.55% CC0531 Wastewater Plant Management 4,013,950 3,516,184 497,766 87.60% 3,704,111 187,927 94.93% CC0527 Water Services Administration 26,369,169 24,491,296 1,877,873 92.88% 26,232,898 1,741,602 93.36% CC0528 Water Distribution 3,207,552 3,176,051 31,501 99.02% 3,911,851 735,800 81.19% CC0529 Water Plant Management 4,326,865 3,479,406 847,459 80.41% 3,910,271 430,866 88.98% CC0553 Water Operations 4,173,316 4,377,488 (204,172) 104.89% 4,463,681 86,193 98.07% Operating Expense Total 47,505,930 43,022,509 4,483,421 90.56% 47,426,102 4,403,593 90.71% Non-Operating Expense CC0001 Non-Departmental 4,083,411 92,665 3,990,746 2.27% 3,887,651 3,794,986 2.38% CC0526 Systems Engineering 99,509,468 13,900,168 85,609,300 13.97% 99,630,405 85,730,237 13.95% CC0532 Irrigation Operations 121,879 121,994 (115) 100.09% 121,929 (65) 100.05% CC0530 Wastewater Operations 3,026,798 3,160,381 (133,583) 104.41% 3,026,798 (133,583) 104.41% CC0531 Wastewater Plant Management 2,050,000 - 2,050,000 0.00% 2,050,000 2,050,000 0.00% CC0527 Water Services Administration - - - 0.00% 6,037 6,037 0.00% CC0528 Water Distribution 1,159,424 781,316 378,108 67.39% 781,316 - 100.00% CC0529 Water Plant Management 2,757 - 2,757 0.00% 2,757 2,757 0.00% CC0553 Water Operations 14,124,300 11,704,343 2,419,957 82.87% 13,962,363 2,258,021 83.83% CC0524 Metering Services 750,000 - 750,000 0.00% 750,000 750,000 0.00% Non-Operating Expense Total 124,828,037 29,760,867 95,067,170 23.84% 124,219,256 94,458,389 23.96% Expense 172,333,967 72,783,376 99,550,591 57.77% 171,645,358 98,861,982 42.40% Total operating expenses are projected to end FY2021 at $47,426,102. Operating expenses are anticipated to come in less than expected. In Water Administration, staff budgeted to buy Colorado river basin water in FY2021. However, the CIP project was not done so purchase of the water is not needed. There is significant savings in Water Distribution related to the timing of economic incentive agreements with the Parkside development. Finally, there is operational savings in Water Plant Management in utilities costs from less production over the summer months due to rain and, the Southside treatment plant being offline in the month of September. Through the quarter, actuals are 90.71% of total operating expense projections. Non-operating expenses are projected to end FY2021 at $124,219,256, which is 23.96% of year-to-date actuals through the quarter. The budget for capital projects will be rolled into FY2022 as part of the CIP RollForward Page 61 of 171 F FY2021 Quarterly Report FY2021 Quarterly Report Budget Amendment. The rollforward amendment will appropriate dollars multi-year projects and other projects that may have been affected by supply chain issues in FY2021. The Water Fund anticipates meeting all the funds below line contingency requirements by the end of FY2021. Contingency requirements include a 90-day operating contingency of $9,127,742, and a non-operating reserve of $10,000,000. Additionally, staff projects $40 million in water impact fees held for future capital appropriation, as well as a need to roll forward $93.3 million in open capital projects. After accounting for these, preliminary, unaudited available fund balance is projected to be $28 million. Page 62 of 171 F FY2021 Quarterly Report OTHER MAJOR FUNDS: Tourism Fund: The COVID-19 pandemic significantly impacted the tourism sector. Overall revenue in the fund totals $1,296,934, or 123.52% of budget. Hotel Occupancy Tax revenue in this fund year to date totals $1,247,146 through the quarter, or 138.57% of budget. Staff have continued to market Georgetown and are pleased to see occupancy rates recovering slowly but steadily. FY2021 REVENUE PROJECTIONS: Total revenues were projected to be $899,850. Through the quarter, actuals are 144.13% of total projections. The overnight stays in Georgetown are beginning to trend upward again. Estimates reflect a conservative approach due to the uncertainty of the pandemic’s impact on the remainder of the fiscal year. Tourism Fund Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date: Budget Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % Variance Projections FY2021 Variance Fav/(Unfav) % of Projection Revenues 40008:Other Taxes 900,000 1,247,146 347,146 138.57% 850,000 397,146 146.72% 42001:Interest Income 5,000 5,057 57 101.15% 5,000 57 101.14% 45001:Misc Revenue 95,000 40,531 (54,469) 42.66% 39,850 682 101.71% 45003:Misc Reimbursements - - - 0.00% - - 0.00% 44001:Grant Revenue - 4,200 4,200 0.00% - 4,200 0.00% 44504:Donations - - - 0.00% - - 0.00% 44505:Sponsorship 50,000 - (50,000) 0.00% 5,000 (5,000) 0.00% Total Revenues 1,050,000 1,296,934 246,934 123.52% 899,850 397,084 144.13% FY2021 EXPENSE PROJECTIONS: Year to date expenses in the Convention & Visitors Bureau Fund total $1,071,232 or 72.47% of budget. Total expenses were projected to end FY2021 at $1,304,309. The savings are primarily due to from personnel vacancies and savings in contracted labor. The fall POPPTober festival and other modified programming were successful in promoting tourism downtown and throughout Georgetown. Overall, Tourism Fund expenditures are within budget and the fund can cover the 90-day Contingency Reserve. Total year-end fund balance is anticipated to be $508,619 in FY2021 with a contingency reserve of $305,771. Tourism Fund Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date Vs. Budget Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projection Expenses City of Georgetown (Only) - - - 0.00% - - 0.00% CC0001 Non-Departmental 28,634 28,634 - 100.00% 28,634 - 100.00% CC0208 CVB 1,241,841 995,389 246,453 124.76% 1,093,475 98,086 91.03% CC0254 Poppy Festival 207,700 47,209 160,491 439.96% 182,200 134,991 25.91% Total Expenses 1,478,175 1,071,232 406,944 137.99% 1,304,309 233,077 82.13% 309K 368K 392K 313K K 100K 200K 300K 400K 500K Q1 Q2 Q3 Q4 HOTEL OCCUPANCY TAX FY2019 FY2020 FY2021 Page 63 of 171 F FY2021 Quarterly Report Airport Fund: Airport operating revenue budget totals $3,951,500. Airport Charges, the largest segment of revenue totals $3,908,279 year to date. This includes revenue for fuel sales, facility lease, and hangar rentals. Total operating revenues through the quarter are $3,971,785, or 100.51% of budget. Non-operating revenue are bond proceeds for capital projects. Through the quarter the City has received $650,000 of bond proceeds as well as $64,186 in bond premiums. Total non-operating revenue through the quarter are $923,417. FY2021 REVENUE PROJECTIONS: Total operating revenues are projected to end FY2021 at $3,814,930. At the end of the quarter, operating revenue projections are 104.11% of year-to-date actuals. Non- operating revenues are projected to end the year at $872,186, and are at 105.87% of year-to-date actuals. Airport Quarterly Comparison: Q4 FY2021 Budget FY2021 FY2021 Year-to-date Vs. Budget Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projection Operating Revenue 40001:Property Taxes 40,000 59,423 19,423 148.56% 57,000 2,423 104.25% 42001:Interest Income 3,000 4,082 1,082 136.08% 3,129 953 130.47% 43606:Airport Charges 3,908,500 3,908,279 (221) 99.99% 3,754,800 153,479 104.09% Operating Revenue Total 3,951,500 3,971,785 20,285 100.51% 3,814,930 156,855 104.11% Non-Operating Revenue 45001:Misc Revenue 5,000 2,250 (2,750) 45.00% 1,000 1,250 225.00% 44001:Grant Revenue - 206,980 206,980 0.00% 157,000 49,980 131.83% 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 923,417 218,417 130.98% 872,186 51,231 105.87% Total Revenue 4,656,500 4,895,202 238,702 105.13% 4,687,116 208,086 104.44% K 200K 400K 600K 800K 1.0M Q1 Q2 Q3 Q4 AIRPORT FUND FUEL SALES FY2020 FY2021 Page 64 of 171 F FY2021 Quarterly Report Operating expenses in the Airport fund include a budget of $4,427,731. Year-to-date operation expenses totals $3,725,236. The budget for non-operating expenses total $908,931. This includes a CIP expense of $750,000 for the construction of a maintenance facility at the airport. The main capital project is a maintenance building. This project in incomplete and the unused funds will roll forward into the FY2022 budget amendment. Additionally, the estimated costs of the facility have increased after the design and bid. Bond proceeds will need to be increased in FY2022 as well to cover increased construction costs. The remaining amount of non-operating expense is for the airport’s debt service payment, which the fund has paid $147,341 year-to-date. FY2021 EXPENSE PROJECTIONS: FY2021 projections total $3,987,583. Through the quarter, actuals are 93.42% of total projections. Airport Fund Quarterly Comparison: Q4 FY2021 Budget FY2021 Year-End: Projections Vs. Actuals Year-End: Projections Vs. Actuals FY2021 YTD Actuals: Q4 FY2021 Variance % of Budget Projections FY2021 Variance Fav/(Unfav) % of Projection Operating Expense Personnel 464,472 447,529 16,943 96.35% 465,860 18,331 96.07% Operations 3,559,192 3,177,144 382,048 89.27% 3,416,469 239,325 92.99% Operating Capital 404,067 100,563 303,504 24.89% 105,255 4,692 95.54% Total Operating Expenses 4,427,731 3,725,236 702,495 84.13% 3,987,583 262,347 93.42% Non-Operating Expense CIP Expense 750,000 - 750,000 0.00% 750,000 750,000 0.00% Debt Service 158,931 147,341 11,590 92.71% 158,931 11,590 92.71% Non-Operating Expense Total 908,931 147,341 761,590 16.21% 908,931 761,590 16.21% Expense Total 5,336,662 3,872,577 1,464,085 72.57% 4,896,514 1,023,937 79.09% Overall, Airport Operation expenditures are within budget and the fund can cover the 90-day Contingency Reserve of $332,917, as well as a debt service reserve of $184,099. Page 65 of 171 Water Services Fund Period: Sep-21 Budget Current Period FY2021 Sep-21 YTD Actuals Variance % of Budget Projections Variance Fav/(Unfav)% of Projection Beginning Fund Balance 125,458,053 125,458,053 - 100.00%125,458,053 - 100.00% Operating Revenue 41002:Penalties 255,000 54,861 513,447 258,447 201.35%355,000 158,447 44.63% 42001:Interest Income 237,250 19,335 427,758 190,508 180.30%492,336 (64,577) 86.88% 43001:Fees 4,290,000 525,550 9,598,958 5,308,958 223.75%7,655,000 1,943,958 125.39% 43005:Rental Revenue 55,000 46,430 112,975 57,975 205.41%60,000 52,975 188.29% 43602:Water Charges 32,150,000 5,697,888 41,143,198 8,993,198 127.97%35,100,000 6,043,198 117.22% 43603:Wastewater Charges 14,200,000 1,346,460 15,125,001 925,001 106.51%14,000,000 1,125,001 108.04% 43604:Irrigation Charges 300,000 72,113 360,002 60,002 120.00%300,000 60,002 120.00% 41602:Impact Fees 18,800,000 3,668,562 40,034,496 21,234,496 212.95%32,500,000 7,534,496 123.18% 44502:Developer Contributions 625,000 - 1,490,202 865,202 238.43%1,496,239 (6,037) 99.60% Total Operating Revenue 70,912,250 11,431,199 108,806,038 37,893,788 153.44%91,958,575 16,847,463 118.32% Operating Expenses City of Georgetown (Only)- - - - 0.00%- - 0.00% CC0001 Non-Departmental 4,223,814 942,511 5,131,684 (907,870) 121.49%4,713,430 (418,254) 108.87% CC0526 Systems Engineering - - (1,836,056) (1,836,056) 0.00%(639,847) 1,196,209 286.95% CC0532 Irrigation Operations 295,000 11,987 139,285 155,715 47.22%295,000 155,715 47.22% CC0530 Wastewater Operations 896,265 45,966 547,171 349,094 61.05%834,706 287,535 65.55% CC0531 Wastewater Plant Management 4,013,950 289,802 3,516,184 497,766 87.60%3,704,111 187,927 94.93% CC0527 Water Services Administration 26,369,169 2,078,728 24,491,296 1,877,873 92.88%26,232,898 1,741,602 93.36% CC0528 Water Distribution 3,207,552 224,030 3,176,051 31,501 99.02%3,911,851 735,800 81.19% CC0529 Water Plant Management 4,326,865 379,014 3,479,406 847,459 80.41%3,910,271 430,866 88.98% CC0553 Water Operations 4,173,316 458,338 4,377,488 (204,172) 104.89%4,463,681 86,193 98.07% CC0524 Metering Services - (265) - - 0.00%- - 0.00% Operating Expense Total 47,505,930 4,430,111 43,022,509 4,483,421 90.56%47,426,102 4,403,593 90.71% Available Operating Fund Balance 23,406,320 65,783,529 33,410,367 44,532,473 21,251,056 147.72% Non-Operating Revenue 45001:Misc Revenue 1,112,500 1,073,450 1,312,616 200,116 117.99%1,262,350 50,266 103.98% 45003:Misc Reimbursements - - 10,422 10,422 0.00%- 10,422 0.00% 45004:Sale of Property 1,327,774 - 1,330,463 2,689 100.20%1,327,774 2,689 100.20% 44001:Grant Revenue - - - - 0.00%- - 0.00% 46001:Bond Proceeds 16,300,000 - 14,975,000 (1,325,000) 91.87%14,975,000 - 100.00% 46002:Bond Premium - - 1,415,140 1,415,140 0.00%1,415,140 (0) 100.00% Non-Operating Revenue Total 18,740,274 1,073,450 19,043,639 303,365 101.62%18,980,264 63,375 100.33% Non-Operating Expenses CC0001 Non-Departmental 4,083,411 - 92,665 3,990,746 2.27%3,887,651 3,794,986 2.38% CC0526 Systems Engineering 99,509,468 2,895,483 13,900,168 85,609,300 13.97%99,630,405 85,730,237 13.95% CC0532 Irrigation Operations 121,879 - 121,994 (115) 100.09%121,929 (65) 100.05% CC0530 Wastewater Operations 3,026,798 137,163 3,160,381 (133,583) 104.41%3,026,798 (133,583) 104.41% CC0531 Wastewater Plant Management 2,050,000 - - 2,050,000 0.00%2,050,000 2,050,000 0.00% CC0527 Water Services Administration - - - - 0.00%6,037 6,037 0.00% CC0528 Water Distribution 1,159,424 - 781,316 378,108 67.39%781,316 - 100.00% CC0529 Water Plant Management 2,757 - - 2,757 0.00%2,757 2,757 0.00% CC0553 Water Operations 14,124,300 126,666 11,704,343 2,419,957 82.87%13,962,363 2,258,021 83.83% CC0524 Metering Services 750,000 - - 750,000 0.00%750,000 750,000 0.00% Non-Operating Expense Total 124,828,037 3,159,313 29,760,867 95,067,170 23.84%124,219,256 94,458,389 23.96% Excess (Deficiency) of Total Revenue over Total Requirements (82,681,443) (142,162,493) 55,066,302 137,747,744 -66.60%(60,706,519) 115,772,820 -90.71% Ending Fund Balance 42,776,610 180,524,355 137,747,744 422.02%64,751,534 115,772,820 278.80% Reserves Contingency Reserve 9,127,742 9,127,742 - 100.00%9,127,742 - 100.00% Non-Operating Reserve 10,000,000 10,000,000 - 100.00%10,000,000 - 100.00% Reserves Total 19,127,742 19,127,742 - 100.00%19,127,742 - 100.00% Available Fund Balance 23,648,868 161,396,613 137,747,744 682.47%45,623,792 115,772,820 353.76% Year-to-Date Actuals Budget Vs. Actuals Year-End: Projections Vs Actuals Page 66 of 171 F FY2022 CIP Roll Forward Amendment FY2022: CIP ROLL FORWARD BUDGET AMENDMENT Each year, the City amends the budget for multi-year capital projects, as well as operational changes that were unknown at the time the budget was adopted. CAPITAL PROJECT ROLLFORWARD: This amendment rolls forward CIP projects started, but not completed, by the end of FY2021 which have ongoing encumbrances and bond proceeds to be spent in FY2022. The impact to each fund is listed below, and the impact across all funds totals $192.7 million. • General Capital Projects - $68.9 million • Street Maintenance - $2.9 million • Fleet - $2.9 million • GTEC - $16.2 million • Water - $93.3 million • Electric – $6.6 million • Stormwater - $1.0 million • Airport - $750 thousand Major projects include: • FY2021 Mobility Bond Projects • Bond Funded Public Safety Vehicles • Transfer Station • Aviation Drive • Various Electric New Development Projects • Berry Creek Interceptor • Northlake WTP Expansion • Round Rock Supply Pump Station and Elevated Storage Tank OPERATIONAL ROLLFORWARD: Departments may request a budgetary roll forward for operational and operating capital expenses. Eligible expense s include equipment, vehicles, and one-time expenses. Due to supply chain issues, many departments saw shipping delays push delivery dates into FY2022. These delivery issues account for the majority of departmental roll forward requests, along with one-time studies or projects nearing completion. The roll forward impact across all funds totals $1.6 million. • General Fund - $496 thousand • CVB - $28 thousand • Special Revenue Funds - $623 thousand • Fleet - $64 thousand • Joint Services - $27 thousand • IT - $125 thousand • Electric - $29 thousand • Water - $247 thousand Page 67 of 171 F FY2022 CIP Roll Forward Amendment Major operational roll forwards include: • 2nd Half of San Jose and TRG Small Area Plans • Conservation Customer Portal and Analysis Software Project • Police Back-Ordered Ammunition and Equipment • Finance Cost Allocation Study • AMR Handhelds • Back-Ordered PPE Equipment for Firefighters STANDBY STIPEND INCREASE: During the FY2022 budget development process, a department requested a review of the standby pay policy and amount. After conducting a market review, staff recommends updating the amount c itywide. This amendment recognizes the additional appropriation needed to increase the standby stipend rate from $17 to $25 per day. The impact across all funds totals $109 thousand. • General Fund - $40 thousand • Facilities - $2.9 thousand • Fleet - $5.4 thousand • Joint Services - $1.4 thousand • IT - $3.6 thousand • Electric - $20.6 thousand • Stormwater - $3.7 thousand • Water - $31 thousand GENERAL FUND: Current budget for the General Fund revenues total $90,772,990. Current budget for the General Fund expenses totals $94,244,537. Amendment Name: Art Mural Program Amount: $0 Reason: Several art mural projects around Georgetown are paid for by the Arts & Culture department and then reimbursed by the business or property where the mural is located. This amendment appropriates $15k for art mural projects that come up throughout the year, and recognizes a matching revenue to account for the reimbursement from the business. There will be no net impact to the General Fund. Amendment Name: Dispatch Shift Differential Amount: $37,000 Reason: Finance, Human Resources, Police and Legal departments coordinate a review of police dispatch shift differential pay. The results of the review are to provide a budget for the time increment preparing before and after shift start and end times, for consistency with Fair Labor Standards Act application. Amendment Name: Employee Engagement Survey Amount: $22,000 Reason: This budget amendment is to appropriate the second year of the employee engagement survey administered by Gallup. Page 68 of 171 F FY2022 CIP Roll Forward Amendment Amendment Name: Engineering / Planning Re-Organization Amount: $325,000 Reason: Since the summer, staff have been preparing a reorganization of development related activities in order to improve customer service. As a part of the Systems Engineering & Planning re-organization, $325k in engineering services for TIA reviews and plan reviews will be moved from the Joint Services Fund to the General Fund. The General Fund will see a matching reduction in the Joint Services allocation charge. There will be no net impact to the General Fund. Amendment Name: K9 Unit Vehicles Amount: $255,000 Reason: During the FY2022 budget development process, $300k was appropriated in General Government Contracts for one-time equipment to start up a police K9 unit. $255k of this appropriation is for the purchase of 3 SUV interceptors with K9 equipment. This amendment reduces the appropriation in General Government Contracts and transfers $255k to the Fleet Fund for the purchase of these vehicles. There will be no net impact to the General Fund since the expense was already appropriated. Amendment Name: Fire Department IT Equipment Amount: $18,000 Reason: During the FY2022 budget development process, $500k was appropriated in General Government Contracts to implement an over hire plan to help mitigate staffing stresses in the Fire department. Fire has been able to hire additional staff members, and this budget amendment transfers $18k to the IT Fund for the purchase of computer equipment and software licenses. There will be no net impact to the General Fund since the expense was already appropriated. GENERAL CAPITAL PROJECTS FUND: Current budget for the General Capital Projects Fund revenues total $51,530,000. Current budget for the General Capital Projects Fund expenses totals $52,395,000. Amendment Name: Fire Truck Cost Increase Amount: $47,400 Reason: The 2 new FY2022 fire trucks are anticipated to cost $47,400 more than originally budgeted due to general price increases. This amendment recognizes an additional $47,400 in bond proceeds and an increased transfer out to the Fleet Fund for the purchase of the fire trucks. SPECIAL REVENUE FUNDS TOURISM FUND: Amendment Name: Double Tap Agreement Amount: $16,185 Reason: To increase transparency in the reporting and tracking of seizures and forfeitures, the Police Forfeitures – State fund was established in FY2021, and received a transfer of revenue from the Federal POLICE FORFEITURES - STATE: Page 69 of 171 F FY2022 CIP Roll Forward Amendment Amendment Name: Appropriating Police Forfeitures Transfer Amount: $50K Reason: To increase transparency in the reporting and tracking of seizures and forfeitures, the Police Forfeitures – State fund was established in FY2021, and received a transfer of revenue from the Federal Seizures and Forfeitures fund. This amendment appropriates $50k to be used for appropriate supplies and training expenses. AMERICAN RESCUE PLAN FUND: Amendment Name: Rapid COVID Tests Amount: $72,000 Reason: This amendment recognizes grant-eligible expenses for rapid COVID tests purchased for City staff and first-responders that were delivered in October of FY2022. INTERNAL SERVICE FUNDS FLEET SERVICES FUND: Current budget for the Fleet Maintenance Fund revenues total $9,116,309. Current budget for the Fleet Maintenance Fund expenses totals $9,229,561. Amendment Name: Fire Truck Cost Increase Amount: $47,400 Reason: The 2 new FY2022 fire trucks are anticipated to cost $47,400 more than originally budgeted due to general price increases. This amendment recognizes an additional $47,400 transfer in from GCP and appropriates the additional expense. Amendment Name: K9 Unit Vehicles Amount: $255k Reason: During the FY2022 budget development process, $300k was appropriated in General Government Contracts for one-time equipment to start up a police K9 unit. $255k of this appropriation is for the purchase of 3 SUV interceptors with K9 equipment. This amendment recognizes the transfer in from the General Fund and appropriates the expense for the police vehicles. JOINT SERVICES FUND: Current budget for the Joint Service Fund revenues total $21,738,624. Current budget for the Joint Service Fund expenses total $21,276,209. Amendment Name: Customer Care Re-Organization Amount: $0 Reason: Staff is proposing a re-organization to the current Customer Care structure as follow through on activities related to utility visioning and incremental moves toward a “311 Like System”. This amendment proposes creating two new cost centers for Billing and Data Analytics & Administration, and transferring the appropriate staff and operational costs to these new cost centers. These expenses will remain in the Joint Services Fund and will have no net effect on the fund as a whole. This amendment also proposes the transfer Page 70 of 171 F FY2022 CIP Roll Forward Amendment of the Conservation department to the Water Fund. Previously, the Conservation department was funded 100% by Water through the Joint Services allocation. This amendment proposes moving these costs into the Water Fund and reducing the Joint Services allocation charge in Water. The Joint Services Fund will see a decrese in revenue and expense of $449,200. Amendment Name: Engineering / Planning Re-Organization Amount: $0 Reason: As a part of the Systems Engineering & Planning re-organization, $325k in engineering services for TIA reviews and plan reviews will be moved from the Joint Services Fund to the General Fund. The Joint Services Fund will see a reduction in allocation revenue for this amount. This amendment also creates a new cost center for Real Estate and transfers the appropriate staff and operational expenses. There is no net impact to the Joint Services Fund. ENTERPRISE FUNDS AIRPORT FUND: Current budget for the Airport Fund revenues total $4,079,122. Current budget for the Airport Fund expenses totals $4,554,460. Amendment Name: Airport Maintenance Facility Cost Increase Amount: $500,000 Reason: Due to increased cost of materials, the Airport maintenance facility is anticipated to cost an additional $500k. This amendment recognizes $500k in bond proceeds and appropriates the additional capital expense. ELECTRIC SERVICES FUND: Current budget for the Electric Fund revenues total $103,050,645. Current budget for the Electric Fund expenses totals $98,690,326. Amendment Name: New Development Capital Projects Amount: $3,500,000 Reason: New Development projects have continued to accelerate across the City, and costs of materials have increased as well. This amendment increases the New Development project budget by $3.5 million and recognizes $3.5 million in additional bond proceeds. Many of these project costs are reimbursed by developer contributions and as the Electric Fund debt strategy is re-evaluated, these projects may be cash funded in the future. WATER SERVICES FUND: Current budget for the Water Fund revenues total $110,251,240. Current budget for the Water Fund expenses totals $115,987,327. Amendment Name: Southlake Water Treatment Plant Amount: $140,000,000 Page 71 of 171 F FY2022 CIP Roll Forward Amendment Reason: During several workshops throughout 2021, staff have presented peak water demand forecasts and the need to accelerate the delivery of the South Lake Water Treatment Plant expansion. The original FY2022 budget included an estimate of a first phase and task only. This amendment recognizes appropriating the current fully estimated amount of all phases, an increase of $140 million, for a total of $160 million. The project is out for bid, and estimates will be updated after bids are received. This amendment shows increasing bond proceeds by the same amount. Staff is still reviewing received water impact fees from FY2021 and will bring forward a revised estimate of how much can be used to offset debt issuance for the plant, as well as options to extend the debt amortization to 25 or 30 years, both with the downstream goal of mitigating rate increases. Council will have the opportunity to review these updated estimates before the debt is actually issued and the project awarded. A mid-year amendment for this project is likely. Amendment Name: Water Department IT Equipment Amount: $18,000 Reason: During the FY2022 budget development process, 6 Plant Operations Technicians were added to the Water Fund. This budget amendment transfers $18k to the IT Fund for the purchase of computer equipment and software licenses that were previously not included in the budget. Page 72 of 171 General Fund Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 21,533,929 495,784 22,029,713 Revenue 40001:Property Taxes 17,100,000 - 17,100,000 40002:Sales Taxes 23,955,859 - 23,955,859 40005:Franchise Taxes 6,266,830 - 6,266,830 40008:Other Taxes 420,000 - 420,000 41001:Fines 311,150 - 311,150 41002:Penalties 85,000 - 85,000 42001:Interest Income 80,000 - 80,000 43001:Fees 8,321,834 - 8,321,834 43002:Garbage Charges 10,600,000 - 10,600,000 43003:Permits 4,849,750 - 4,849,750 43004:Administrative Charges 2,721,543 - 2,721,543 43005:Rental Revenue 54,040 - 54,040 44001:Grant Revenue 185,000 - 185,000 44503:Interlocal Agreement Revenue 5,700,557 - 5,700,557 45001:Misc Revenue 855,935 - 855,935 45003:Misc Reimbursements - 15,000 15,000 70001:Transfers In 394,222 16,185 410,407 70002:Transfers In - ROI 8,871,270 - 8,871,270 Revenue Total 90,772,990 31,185 90,804,175 Expense CC0001 Non-Departmental 1,237,635 273,000 1,510,635 CC0107 Planning 3,043,678 449,983 3,493,661 CC0202 Parks Administration 734,701 - 734,701 CC0210 Library 3,295,247 - 3,295,247 CC0211 Parks 2,965,312 4,527 2,969,839 CC0212 Recreation 4,630,251 - 4,630,251 CC0213 Tennis Center 512,912 - 512,912 CC0215 Garey Park 1,063,906 - 1,063,906 CC0218 Arts and Culture 190,659 21,150 211,809 CC0316 Municipal Court 616,073 - 616,073 CC0402 Fire Support Services/Administration 4,636,775 4,255 4,641,030 CC0422 Fire Emergency Services 16,859,238 258,828 17,118,066 CC0448 EMS 3,548,753 - 3,548,753 CC0533 Environmental Services 9,707,764 - 9,707,764 CC0536 Inspection Services 1,769,388 - 1,769,388 CC0602 Administrative Services 2,255,217 58,000 2,313,217 CC0605 Community Services 400,264 - 400,264 CC0634 City Council Services 205,570 - 205,570 CC0635 City Secretary Services 1,154,634 - 1,154,634 CC0638 General Government Contracts 6,299,645 (598,000) 5,701,645 CC0655 Communications/Public Engagement 1,078,475 12,000 1,090,475 CC0702 Police Administration 2,809,065 - 2,809,065 CC0742 Police Operations 16,958,879 107,826 17,066,705 CC0744 Animal Services 1,231,600 3,615 1,235,215 CC0745 Code Compliance 598,221 - 598,221 CC0802 Public Works 1,982,576 - 1,982,576 CC0846 Streets 4,458,098 14,984 4,473,082 Expense Total 94,244,536 610,169 94,854,705 Ending Fund Balance 18,062,383 (83,200) 17,979,183 Reserves Benefit Payout Reserve 340,000 340,000 Contingency Reserve 15,824,255 80,137 15,904,392 Economic Stability Reserve 1,467,563 1,467,563 Reserves Total 17,631,818 80,137 17,711,955 Available Fund Balance 430,565 (163,337) 267,228 FY2022 Page 73 of 171 Capital Project Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 30,704,575 68,937,134 99,641,709 Revenue 42001:Interest Income 100,000 - 100,000 43001:Fees 45,000 - 45,000 46001:Bond Proceeds 50,860,000 47,440 50,907,440 70001:Transfers In 525,000 - 525,000 Revenue Total 51,530,000 47,440 51,577,440 Expense CC0001 Non-Departmental 4,820,000 231,499 5,051,499 CC0211 Parks 5,062,500 2,409,820 7,472,320 CC0302 Finance Administration - 336,126 336,126 CC0319 Facilities 2,012,500 4,784,249 6,796,749 CC0402 Fire Support Services/Administration 300,000 870,000 1,170,000 CC0526 Systems Engineering 40,200,000 34,838,938 75,038,938 CC0533 Environmental Services - 10,217,969 10,217,969 CC0602 Administrative Services - 2,276,859 2,276,859 CC0702 Police Administration - 62,588 62,588 CC0802 Public Works - 12,385,811 12,385,811 CC0846 Streets - 570,715 570,715 Expense Total 52,395,000 68,984,574 121,379,574 Ending Fund Balance 29,839,575 0 29,839,575 Reserves Mobility Bond Proceeds 28,000,000 28,000,000 Reserves Total 28,000,000 - 28,000,000 Available Fund Balance 1,839,575 0 1,839,575 FY2022 Page 74 of 171 Tourism Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 1,271,504 44,053 1,315,557 Revenue 40008:Other Taxes 1,000,000 - 1,000,000 42001:Interest Income 5,000 - 5,000 44505:Sponsorship 50,000 - 50,000 45001:Misc Revenue 105,000 - 105,000 Revenue Total 1,160,000 - 1,160,000 Expense Personnel 435,215 - 435,215 Operations 1,024,501 27,868 1,052,369 Transfers 36,222 16,185 52,407 Expense Total 1,495,938 44,053 1,539,990 Ending Fund Balance 935,566 0 935,567 Reserves Contingency Reserve 337,842 337,842 Capital Reserve 597,724 597,724 Reserves Total 935,566 - 935,566 Available Fund Balance 0 0 1 FY2022 Page 75 of 171 Street Tax Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 4,637,731 2,875,899 7,513,630 Revenue 40002:Sales Taxes 5,322,969 - 5,322,969 42001:Interest Income 5,000 - 5,000 Revenue Total 5,327,969 - 5,327,969 Expense Operating Capital - 5,975,899 5,975,899 CIP Expense 3,875,000 - 3,875,000 Expense Total 3,875,000 5,975,899 9,850,899 Ending Fund Balance 6,090,700 (3,100,000) 2,990,700 Reserves Arterial Reserve 750,000 750,000 Reserves Total 750,000 - 750,000 Available Fund Balance 5,340,700 (3,100,000) 2,240,700 FY2022 Page 76 of 171 PEG Fee Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 298,537 4,348 302,885 Revenue 40005:Franchise Taxes 168,786 - 168,786 42001:Interest Income 500 - 500 Revenue Total 169,286 - 169,286 Expense Operating Capital 125,000 4,348 129,348 Expense Total 125,000 4,348 129,348 Ending Fund Balance 342,823 - 342,823 Reserves Reserves Total - - - Available Fund Balance 342,823 - 342,823 FY2022 Page 77 of 171 Library Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 154,133 84,510 238,643 Revenue 44504:Donations 140,000 - 140,000 Revenue Total 140,000 - 140,000 Expense Operations 130,000 81,510 211,510 Operating Capital - 3,000 3,000 Expense Total 130,000 84,510 214,510 Ending Fund Balance 164,133 - 164,133 Reserves Reserves Total - - - Available Fund Balance 164,133 - 164,133 FY2022 Page 78 of 171 Tree Fund Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 2,283,691 2,195 2,285,886 Revenue 42001:Interest Income 5,000 - 5,000 43001:Fees 500,000 - 500,000 Revenue Total 505,000 - 505,000 Expense Operations 400,000 2,195 402,195 Expense Total 400,000 2,195 402,195 Ending Fund Balance 2,388,691 - 2,388,691 Reserves Reserves Total - - - Available Fund Balance 2,388,691 - 2,388,691 FY2022 Page 79 of 171 Parks Restricted Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 448,491 196,272 644,763 Revenue 42001:Interest Income 1,500 - 1,500 43001:Fees 125 - 125 43606:Airport Charges 4,500 - 4,500 44504:Donations 4,000 - 4,000 70001:Transfers In 297,000 - 297,000 Revenue Total 307,125 - 307,125 Expense Operations 310,500 196,272 506,772 Operating Capital 114,716 - 114,716 Expense Total 425,216 196,272 621,488 Ending Fund Balance 330,400 - 330,400 Reserves Reserves Total - - - Available Fund Balance 330,400 - 330,400 FY2022 Page 80 of 171 Parkland Dedication Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 3,423,739 283,737 3,707,476 Revenue 42001:Interest Income 6,300 - 6,300 44502:Developer Contributions 1,250,000 - 1,250,000 Revenue Total 1,256,300 - 1,256,300 Expense Operating Capital 1,700,000 283,737 1,983,737 Expense Total 1,700,000 283,737 1,983,737 Ending Fund Balance 2,980,039 - 2,980,039 Reserves Reserves Total - - - Available Fund Balance 2,980,039 - 2,980,039 FY2022 Page 81 of 171 Police Forfeitures - State Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 3,160 50,000 53,160 Revenue Expense Operations - 50,000 50,000 Expense Total - 50,000 50,000 Ending Fund Balance 3,160 - 3,160 Reserves Reserves Total - - - Available Fund Balance 3,160 - 3,160 FY2022 Page 82 of 171 American Rescue Plan Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 4,014,753 (87,774) 3,926,979 Revenue 44001:Grant Revenue 4,014,753 - 4,014,753 Revenue Total 4,014,753 - 4,014,753 Expense Operations - 72,000 72,000 Transfers 25,000 - 25,000 Expense Total 25,000 72,000 97,000 Ending Fund Balance 8,004,506 (159,774) 7,844,732 Reserves Reserves Total - - - Available Fund Balance 8,004,506 (159,774) 7,844,732 FY2022 Page 83 of 171 Village PID Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 651,019 51,500 702,519 Revenue 40001:Property Taxes 522,274 - 522,274 42001:Interest Income 1,000 - 1,000 Revenue Total 523,274 - 523,274 Expense Operations 395,425 - 395,425 Operating Capital 488,725 51,500 540,225 Expense Total 884,150 51,500 935,650 Ending Fund Balance 290,143 - 290,143 Reserves Reserves Total - - - Available Fund Balance 290,143 - 290,143 FY2022 Page 84 of 171 GTEC Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 22,698,301 16,201,742 38,900,043 Revenue 40002:Sales Taxes 10,645,938 - 10,645,938 42001:Interest Income 24,000 - 24,000 46001:Bond Proceeds 3,700,000 - 3,700,000 Revenue Total 14,369,938 - 14,369,938 Expense Operations 2,747,716 - 2,747,716 Operating Capital - 16,201,742 16,201,742 CIP Expense 3,700,000 - 3,700,000 Transfers 3,232,111 - 3,232,111 Debt Service 944,500 - 944,500 Expense Total 10,624,327 16,201,742 26,826,069 Ending Fund Balance 26,443,912 0 26,443,912 Reserves Contingency Reserve 2,617,664 2,617,664 Debt Service Reserve 3,918,959 3,918,959 Reserves Total 6,536,623 - 6,536,623 Available Fund Balance 19,907,289 0 19,907,289 FY2022 Page 85 of 171 Facilities Maintenance Fund Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 2,271,982 2,271,982 Revenue 42001:Interest Income 6,500 - 6,500 43004:Administrative Charges 4,664,244 - 4,664,244 45001:Misc Revenue 2,000 - 2,000 45002:Insurance Proceeds 1,000 - 1,000 Revenue Total 4,673,744 - 4,673,744 Expense Personnel 734,847 2,942 737,789 Operations 3,614,016 - 3,614,016 Operating Capital 809,261 - 809,261 Transfers 50,000 - 50,000 Expense Total 5,208,125 2,942 5,211,067 Ending Fund Balance 1,737,602 (2,942) 1,734,660 Reserves Contingency Reserve 281,055 (2,942) 278,113 Capital Reserve 1,456,546 1,456,546 Reserves Total 1,737,601 (2,942) 1,734,659 Available Fund Balance 1 - 1 FY2022 Page 86 of 171 Fleet Services Fund Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 5,134,768 2,959,306 8,094,074 Revenue 42001:Interest Income 25,000 - 25,000 43004:Administrative Charges 3,585,068 - 3,585,068 45002:Insurance Proceeds 327,241 - 327,241 70001:Transfers In 5,179,000 302,400 5,481,400 Revenue Total 9,116,309 302,400 9,418,709 Expense Personnel 908,011 5,433 913,444 Operations 1,874,050 63,896 1,937,946 Operating Capital 2,151,000 3,197,810 5,348,810 CIP Expense 4,296,500 - 4,296,500 Expense Total 9,229,561 3,267,140 12,496,700 Ending Fund Balance 5,021,516 (5,434) 5,016,083 Reserves Contingency Reserve 549,558 549,558 Fire Vehicle Reserve 493,000 493,000 Capital Reserve 1,418,240 1,418,240 Reserves Total 2,460,798 - 2,460,798 Available Fund Balance 2,560,718 (5,434) 2,555,285 FY2022 Page 87 of 171 Joint Services Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 1,974,965 141,598 2,116,563 Revenue 42001:Interest Income 6,250 - 6,250 43001:Fees 11,600 - 11,600 43004:Administrative Charges 21,575,774 (774,200) 20,801,574 45003:Misc Reimbursements 120,000 - 120,000 70001:Transfers In 25,000 - 25,000 Revenue Total 21,738,624 (774,200) 20,964,424 Expense CC0001 Non-Departmental 923,500 115,000 1,038,500 CC0302 Finance Administration 1,223,443 25,000 1,248,443 CC0315 Accounting 1,591,909 - 1,591,909 CC0317 Purchasing 1,073,285 - 1,073,285 CC0321 Customer Care 6,979,073 (5,905,121) 1,073,953 CC0322 Billing - 1,304,610 1,304,610 CC0323 Data Analytics & Administration - 4,801,286 4,801,286 CC0503 Organizational and Operational Excellence 380,014 - 380,014 CC0526 Systems Engineering 3,344,935 (579,820) 2,765,115 CC0523 Real Estate - 254,820 254,820 CC0534 Conservation 646,962 (646,963) (1) CC0637 Economic Development 655,188 - 655,188 CC0639 Human Resources 1,736,466 - 1,736,466 CC0640 Citywide Human Resources 1,354,125 - 1,354,125 CC0654 Legal 1,367,308 - 1,367,308 Expense Total 21,276,209 (631,188) 20,645,021 Ending Fund Balance 2,437,380 (1,414) 2,435,966 Reserves Contingency Reserve 2,437,380 (1,414) 2,435,966 Reserves Total 2,437,380 (1,414) 2,435,966 Available Fund Balance 0 (0) (0) FY2022 Page 88 of 171 Information Technology Fund Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 1,728,418 125,000 1,853,418 Revenue 42001:Interest Income 8,000 - 8,000 43004:Administrative Charges 11,766,494 - 11,766,494 70001:Transfers In 139,000 36,000 175,000 Revenue Total 11,913,494 36,000 11,949,494 Expense CC0001 Non-Departmental 35,000 - 35,000 CC0648 IT Fiber 353,136 75,000 428,136 CC0649 IT Applications 1,543,959 - 1,543,959 CC0650 IT Public Safety 493,043 - 493,043 CC0651 IT Infrastructure 2,668,770 18,621 2,687,391 CC0652 IT Management 6,771,478 71,000 6,842,478 Expense Total 11,865,385 164,621 12,030,006 Ending Fund Balance 1,776,527 (3,621) 1,772,906 Reserves Contingency Reserve 1,173,234 (3,621) 1,169,613 Reserve for Capital 603,294 603,294 Reserves Total 1,776,528 (3,621) 1,772,907 Available Fund Balance (0) - (0) FY2022 Page 89 of 171 Airport Operations Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 1,254,102 750,000 2,004,102 Revenue 40001:Property Taxes 57,000 - 57,000 42001:Interest Income 3,025 - 3,025 43606:Airport Charges 3,910,097 - 3,910,097 44001:Grant Revenue 108,000 - 108,000 45001:Misc Revenue 1,000 - 1,000 46001:Bond Proceeds - 500,000 500,000 Revenue Total 4,079,122 500,000 4,579,122 Expense Personnel 502,721 - 502,721 Operations 3,802,516 - 3,802,516 Operating Capital 65,000 1,250,000 1,315,000 Debt Service 184,226 - 184,226 Expense Total 4,554,463 1,250,000 5,804,463 Ending Fund Balance 778,761 - 778,761 Reserves Contingency Reserve 342,905 342,905 Debt Service Reserve 186,458 186,458 Reserves Total 529,363 - 529,363 Available Fund Balance 249,398 - 249,398 FY2022 Page 90 of 171 Electric Services Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 32,262,067 6,654,998 38,917,065 Revenue 40002:Sales Taxes 5,000 - 5,000 41002:Penalties 600,000 - 600,000 42001:Interest Income 11,000 - 11,000 43001:Fees 691,000 - 691,000 43004:Administrative Charges 3,539,712 - 3,539,712 43601:Electric Sales Charges 85,541,593 - 85,541,593 44502:Developer Contributions 2,500,000 - 2,500,000 45001:Misc Revenue 35,000 - 35,000 45004:Sale of Property 1,665,840 - 1,665,840 46001:Bond Proceeds 8,461,500 3,500,000 11,961,500 Revenue Total 103,050,645 3,500,000 106,550,645 Expense CC0001 Non-Departmental 16,875,633 35,000 16,910,633 CC0520 Electric Safety & Employee Development - 397,325 397,325 CC0521 Electric Technical Services 1,131,831 - 1,131,831 CC0522 Electric Administration 9,711,489 - 9,711,489 CC0524 Metering Services 2,119,825 28,768 2,148,593 CC0525 T&D Services 3,467,567 (616,021) 2,851,546 CC0537 Electric Resource Management 55,493,445 - 55,493,445 CC0555 Electric Systems Operations 1,837,134 3,961 1,841,095 CC0557 Electrical Engineering 8,053,402 10,361,601 18,415,002 Expense Total 98,690,327 10,210,634 108,900,960 Ending Fund Balance 36,622,385 (55,636) 36,566,750 Reserves Operating Contingency Reserve 6,426,561 6,426,561 Rate Stabilization Reserve 18,600,000 18,600,000 Non-Operating Reserve 6,049,061 6,049,061 Transformer Reserve 4,069,154 4,069,154 Reserves Total 35,144,776 - 35,144,776 Available Fund Balance 1,477,609 (55,636) 1,421,974 FY2022 Page 91 of 171 Stormwater Services Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 2,301,927 1,040,847 3,342,774 Revenue 41002:Penalties 32,000 - 32,000 42001:Interest Income 6,800 - 6,800 43605:Stormwater Charges 3,922,000 - 3,922,000 46001:Bond Proceeds 500,000 - 500,000 Revenue Total 4,460,800 - 4,460,800 Expense CC0001 Non-Departmental 855,920 - 855,920 CC0802 Public Works - 300,000 300,000 CC0845 Stormwater 4,050,744 744,582 4,795,326 Expense Total 4,906,663 1,044,582 5,951,246 Ending Fund Balance 1,856,064 (3,735) 1,852,328 Reserves Contingency Reserve 413,189 413,189 Debt Service Reserve 486,959 486,959 Reserves Total 900,148 - 900,148 Available Fund Balance 955,916 (3,735) 952,180 FY2022 Page 92 of 171 Water Services Current Budget Rollforward Amendment Amended Budget Beginning Fund Balance 64,751,535 93,477,820 158,229,355 Revenue 41002:Penalties 315,000 - 315,000 41602:Impact Fees 31,890,000 - 31,890,000 42001:Interest Income 390,000 - 390,000 43001:Fees 7,877,000 - 7,877,000 43005:Rental Revenue 50,000 - 50,000 43602:Water Charges 36,100,000 - 36,100,000 43603:Wastewater Charges 14,500,000 - 14,500,000 43604:Irrigation Charges 300,000 - 300,000 44502:Developer Contributions 767,240 - 767,240 45001:Misc Revenue 1,462,000 - 1,462,000 46001:Bond Proceeds 16,600,000 140,000,000 156,600,000 70001:Transfers In - 115,000 115,000 Revenue Total 110,251,240 140,115,000 250,366,240 Expense CC0001 Non-Departmental 9,902,643 18,000 9,920,643 CC0524 Metering Services - 750,000 750,000 CC0526 Systems Engineering 49,800,000 222,005,749 271,805,749 CC0527 Water Services Administration 33,339,401 (549,878) 32,789,524 CC0528 Water Distribution 4,267,030 429 4,267,459 CC0529 Water Plant Management 4,696,227 (25,268) 4,670,959 CC0530 Wastewater Operations 3,962,191 - 3,962,191 CC0531 Wastewater Plant Management 3,999,762 20,045 4,019,807 CC0532 Irrigation Operations 603,000 - 603,000 CC0534 Conservation - 1,005,032 1,005,032 CC0553 Water Operations 5,139,074 10,417,895 15,556,969 Expense Total 115,709,328 233,642,004 349,351,332 Ending Fund Balance 59,293,447 (49,184) 59,244,263 Reserves Contingency Reserve 10,613,110 110,761 10,723,871 Non-Operating Revenue 10,000,000 10,000,000 Impact Fee Reserve 3,190,000 3,190,000 Reserves Total 23,803,110 110,761 23,913,871 Available Fund Balance 35,490,337 (159,945) 35,330,392 FY2022 Page 93 of 171 Page 94 of 171 Capital Projects Roll Forward Amount 120 General Capital Projects CC0001 Non-Departmental PRJ000124 Radio Replacement 184,059 CC0001 Non-Departmental Total 184,059 CC0211 Parks PRJ000048 Garey Park 246,480 PRJ000125 Parks Master Plan 92,115 PRJ000126 Regional Trail Development 1,186,449 PRJ000129 Ada Transition Plan 606,131 PRJ000190 Heritage Gardens 212,050 PRJ000240 South Main Plaza 2,725 PRJ000293 San Gabriel Park - Phase 3 63,870 CC0211 Parks Total 2,409,820 CC0302 Finance Administration PRJ000038 ERP Project 336,126 CC0302 Finance Administration Total 336,126 CC0319 Facilities PRJ000178 Public Safety Operation and Training Center Phase II 4,485,310 PRJ000179 Recreation Center Teen/Senior Renovation 215,525 PRJ000180 Recreation Center Natatorium HVAC Replacement 32,454 PRJ000191 Georgetown City Center - Festival/Public Space 50,960 CC0319 Facilities Total 4,784,249 CC0402 Fire Support Services/Administration PRJ000134 SCBA Replacement 870,000 CC0402 Fire Support Services/Administration Total 870,000 CC0526 Systems Engineering PRJ000137 Intersection Improvements (Lakeway @ Williams Drive)1,606,630 PRJ000138 Downtown Sidewalks 768,190 PRJ000188 DB Wood (SH 29 to Oak Ridge)2,896,980 PRJ000214 Intersection Improvements (Traffic Signals)1,061,957 PRJ000215 2021 Intersection Safety Enhancements (RRFB)96,400 PRJ000216 FY21 Downtown Sidewalk Improvements 986,350 PRJ000217 SW Bypass - Wolf Ranch Extension 1,741,431 PRJ000254 Shell Road 3,005,000 PRJ000255 Rockride Lane 5,776,000 PRJ000256 Westinghouse Road 8,200,000 PRJ000257 Sam Houston Ave Ext/SE1/Wilco Corridor 4,000,000 PRJ000267 Allocations - Intersections/Bike Lanes/Sidewalks - MB21 1,700,000 PRJ000297 Southeast Inner Loop - MB21 3,000,000 CC0526 Systems Engineering Total 34,838,938 Page 95 of 171 CC0533 Environmental Services PRJ000116 Transfer Station 10,217,969 CC0533 Environmental Services Total 10,217,969 CC0602 Administrative Services PRJ000029 Downtown Parking Garage 176,873 PRJ000042 Fire Station 6 177,401 PRJ000043 Fire Station 7 528,792 PRJ000131 Fuel Station 1,078,619 PRJ000223 City Center Signage 125,000 PRJ000136 GMC Remodel Phase I 190,174 CC0602 Administrative Services Total 2,276,859 CC0702 Police Administration PRJ000133 Body Cameras 62,588 CC0702 Police Administration Total 62,588 CC0802 Public Works PRJ000139 Westinghouse - Scenic Lake Traffic Signal 265,937 PRJ000140 Austin Ave Bridges 2,343,665 PRJ000141 Southwestern Blvd 3,477,473 PRJ000143 Leander Rd(Norwood-Swbypass)6,291,830 PRJ000203 FM1460 Widening 6,907 CC0802 Public Works Total 12,385,811 CC0846 Streets PRJ000202 FM 971 570,715 CC0846 Streets Total 570,715 120 General Capital Projects Total 68,937,134 203 Street Tax CC0802 Public Works PRJ000174 2020 street maintenance HIPR 249,466 PRJ000210 2021 HIPR Street Maintenance 1,431,519 PRJ000211 2021 High Performance Pavement Seal Project #1 674,947 PRJ000212 2021 High Performance Pavement Seal Project #2 519,967 CC0802 Public Works Total 2,875,899 203 Street Tax Total 2,875,899 402 GTEC - Projects CC0500 GTEC PRJ000046 FM 971/ Fontana (Nw Bridge)35,267 PRJ000060 Rabbit Hill Road 4,340,378 PRJ000145 Sh29 Signal And Roadway Improvements 1,155,690 PRJ000181 Aviation Drive 7,752,124 Page 96 of 171 PRJ000209 Southeast Inner Loop 2,918,283 CC0500 GTEC Total 16,201,742 402 GTEC - Projects Total 16,201,742 520 Fleet Services Fund CC0320 Fleet Bond Funded Public Safety Vehicles - Fire 708,045 Bond Funded Public Safety Vehicles - Police 1,085,611 Bond Funded Vehicles - Electric 337,882 Vehicles 763,873 CC0320 Fleet Total 2,895,410 520 Fleet Services Fund Total 2,895,410 602 Airport Operations - Projects CC0636 Airport PRJ000184 Airport Maintenance Facility 750,000 CC0636 Airport Total 750,000 602 Airport Operations - Projects Total 750,000 612 Electric Services - Projects CC0557 Electrical Engineering PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase I 527,716 PRJ000221 Titan-Aviation Dr to IH35 Infrastructure Addition 722,745 PRJ000225 Chapel Hill, WS-11139 (GEO-45-C.3)380,054 PRJ000226 Wolf Ranch West - Section 1AG & 1BG 445,647 PRJ000227 Ascend Westinghouse Apartments 415,432 PRJ000229 Sun City NH 76 WS-11188 (GEO-18.2-N.51)166,924 PRJ000230 Sun City NH 78 276,799 PRJ000234 Summit at Westinghouse Self-Storage 43,830 PRJ000236 Medcore (Georgetown) Senior Living 206,837 PRJ000238 The Oscar at Georgetown 366,227 PRJ000239 Wolf Ranch West - Section 3 - Phase 2 393,786 PRJ000242 Allora North Georgetown 522,630 PRJ000243 Fairfield Inn - WS11346 89,495 PRJ000245 Morgan Mays Street Apartments 452,508 PRJ000246 Vida Apartments 198,248 PRJ000247 Georgetown (Longhorn) Travel Center Rev 181,610 PRJ000250 Georgetown Infiniti 135,733 PRJ000272 Wolf Lakes 512,345 PRJ000273 The Grove II Townhomes 108,924 PRJ000282 ANB Systems - Interconnection Service Portal 75,009 PRJ000283 Partners Software and Implementation 120,000 PRJ000289 Wolf Lakes Offsite Utility 283,732 CC0557 Electrical Engineering Total 6,626,230 Page 97 of 171 612 Electric Services - Projects Total 6,626,230 642 Stormwater Services - Projects CC0802 Public Works PRJ000149 Drainage Improvement/Flood Mitigation Projects 300,000 CC0802 Public Works Total 300,000 CC0845 Stormwater PRJ000004 18th and Hutto Drainage 158,824 PRJ000024 2020 Curb & Gutter 178,229 PRJ000104 Stormwater Infrastructure 126,509 PRJ000213 2021 Curb & Gutter Project 277,285 CC0845 Stormwater Total 740,847 642 Stormwater Services - Projects Total 1,040,847 662 Water Services - Projects CC0524 Metering Services PRJ000220 AMI Western District Improvements 750,000 CC0524 Metering Services Total 750,000 CC0526 Systems Engineering PRJ000014 Berry Creek Inter.25,179,218 PRJ000017 Cedar Breaks Est 236,730 PRJ000034 Earz 4,360 PRJ000057 Lift Station Upgrade 1,165,000 PRJ000101 Southlake Wtp 6,189,533 PRJ000152 Hoover Pump Station 6,691,014 PRJ000155 Southside Water Treatment Plant 2,957,390 PRJ000156 Gatlin/Teravista Improvements 450,000 PRJ000157 Leander Interconnect 89,500 PRJ000160 Round Rock Supply Pump Station And Elevated Storage Tank 10,040,535 PRJ000161 Miscellaneous Line Upgrades 188,790 PRJ000162 South West Bypass Water (H24-1)1,221,993 PRJ000163 Tank Rehabilitation 2,219,099 PRJ000165 San Gabriel WWTP Rehabilitation 1,159,307 PRJ000167 San Gabriel Inter SGI -2 4,375,055 PRJ000168 WWTP Upgrade 870,453 PRJ000177 Northlake WTP Phase IV Expansion 14,372,500 PRJ000181 Aviation Drive 1,028,160 PRJ000185 Cimarron Hills Wastewater Treatment Plant Expansion 613,795 PRJ000218 EARZ Wastewater Rehabilitation Area 2 - 2019 779,847 PRJ000219 Southside GST Foundation Improvements 535,678 PRJ000228 Southside GST Roof Rehab 567,000 PRJ000241 2020 - 2021 EARZ - Area 3 1,070,792 CC0526 Systems Engineering Total 82,005,749 Page 98 of 171 CC0553 Water Operations PRJ000023 Cr 255 (Wd14-2)1,817,359 PRJ000059 LWTP Raw Water Intake Rehab 268,618 PRJ000066 Park Lift Station & Force Main 1,554,712 PRJ000096 Shell Road Water Line 6,018,091 PRJ000119 Water Mains 931,123 CC0553 Water Operations Total 10,589,904 662 Water Services - Projects Total 93,345,653 Grand Total 192,672,914 Page 99 of 171 City of Georgetown, Texas Water Utility Board January 13, 2022 S UB J E C T: R eview and possible action to approve the minutes from the November 11, 2021 G eorgetown Water Utility Advisory Board Meeting.- S heila Mitc hell, Interim Board Liaison IT E M S UMMARY: Board to review and take action to approve the minutes from the November 11, 2021 G eorgetown Water Utility Advis ory Board Meeting. F IN AN C IAL IMPAC T: . S UB MIT T E D B Y: S heila Mitchell, Interim Board Liais on AT TAC H ME N T S: Description Type GWUAB Nov 11, 2021 DAFT Minutes Backup Material Page 100 of 171 Georgetown Water Utilities Advisory Board November 11, 2021 Board Members Present: Stuart Garner, Chair; Michael Morrison, Scott Macmurdo, Steve Fought Staff Members Present: Chelsea Solomon, Director of Water Utilities; Leticia Zavala Jones, Customer Care Director; Wesley Wright, System Engineering Director; Chris Graham, Water Utility Support Manager, Chris Pousson, Project Manager; Cindy Popisil, ERP Applications Administrator; Tina Davis, Board Liaison Regular Session (This Regular Session may, at any time, be recessed to convene an Executive Session for any purpose authorized by the Open Meetings Act, Texas Government Code 551.) A. Call to Order - Meeting was called to order by Garner; Chair at 2:07 PM B. Public Wishing to Address the Board – No one signed up to speak. C. Review and possible action to approve the minutes from October, 2021 – No discussion on minutes. Motion to approve by Morrison, Seconded by Macmurdo, 4-0-0 D. Directors Report – Brief explanation on what causes the difference in the number of new water connections vs. wastewater connections. A lot of the service area in the ETJ is outside of the Wastewater service area. The City has a 400 square mile service territory for water and approximately 75 miles for wastewater. Will look at the ordinances for Conservation to see if it can be enforced differently going forward to prevent repeat wrong day watering occurrences, compare our rebate program with other utility companies. Will be running a campaign that talks about how to winterize your system. Consultants are working on the Resource Plan, ASR Contract was approved by Council, BRA has issued their RFP for purchasing water. South Lake Plant, the largest ($160 million to $180 million) project the City has ever done is out to bid. One pre-bid meeting so far. Plan to bring to the Board in January and Council January 25, 2022. This will be a competitive sealed bid. Possibility this will push back to February. With regard to Engineering Services, there will be a request for qualifications coming out where interested Firms can submit their statement of qualifications. Once reviewed and ranked by City, the firms will be added to a list and used for upcoming projects. The list will be revised every 3 years so that Firms can stay current on the list. There is a separate statement of qualification currently out for new development for plan review. This is for new City of Georgetown, Texas Georgetown Water Utility Board Meeting Minutes Thursday, November 11, 2021 at 2:00 p.m. Page 101 of 171 Georgetown Water Utilities Advisory Board November 11, 2021 development that will report to the Planning Department. E. Consideration and possible action to approve the renewal of contract SCON- 2000183 for the purchase of Bioxide from Evoqua Water Technologies LLC, of Sarasota, Florida in an amount not to exceed $100,000 from October 1, 2021, to September 30, 2022. (Fiscal Year 2022) – Chris Graham, Water Utility Support Manager. Evoqua is a proprietary company that the City has used in the past. Most of the stations we have that use bioxide are set up with their proprietary skids. Evoqua provides two service calls annually. Brief discussion on which plants have Bioxide coming into the plants. Chelsea will follow-up with PH level of wastewater. Motion to approve by Morrison, Seconded by Macmurdo, 4-0-0 Adjournment Motion to adjourn by Macmurdo, Seconded by Morrison. The meeting adjourned at 2:40 PM Thomas Glab, Chair Secretary Board Liaison Page 102 of 171 City of Georgetown, Texas Water Utility Board January 13, 2022 S UB J E C T: C onsideration and pos s ible rec ommendation to award Holt P ower S ystems , of S an Antonio, Texas, for the C omplete R emoval and R eplac ement of S tandby G enerator at P ecan Branc h Wastewater Treatment P lant, in the amount of $147,500.00. – Mike Welch, Treatment and R egulatory Manager IT E M S UMMARY: After a replac ement of a failed water pump, a full load test revealed that the unit would not power the facility during an outage. Evaluation determined failure of one or both of the generator turbines. T his unit is out of produc tion and a nationwide searc h could not locate replac ement turbines nor parts . Holt P ower S ystems /Holt C at has submitted a quote for turnkey acquis ition, removal, plac ement, connec tion, and s tartup of a new upsized diesel generator and fuel tank. S P E C IAL C O N S ID E R AT ION S : Holt P ower S ystems /Holt C at is a BuyBoard provider. F inance has confirmed. Legal is reviewing propos al. S TAF F R E C O MME N D AT IO N: S taff recommends awarding Holt P ower S ys tems/Holt C at $147,500.00 for equipment and services. F IN AN C IAL IMPAC T: F unds for this expenditure will impact the C I P Budget – P R J000259, P ec an Branch Expansion > G eneral P roject Work > G eneral P rojec t Work S UB MIT T E D B Y: Mike Welch, Treatment and R egulatory Manager/skm AT TAC H ME N T S: Description Type Quote Backup Material Page 103 of 171 Austin • Brownsville • Corpus Christi • Dallas • Edinburg • Ft Worth • Laredo • Longview • Pflugerville • San Antonio • Victoria • Waco Quote No: 31010652 Quote Date: 12/29/21 Quote Expires: 1/29/22 Re: Georgetown Pecan Water Greetings, We are pleased to submit the following confirmation of our quote. Holt Power Systems proposes to furnish this equipment at the attached quoted price. If Start-up is included, Holt Cat will arrange for initial start-up services at no additional charge. These services include a check of wiring continuity, safety shutoffs and controls; including automatic transfer switches or paralleling gear on and related to the unit that we supply. Load bank testing is provided if requested or required by specifications. Holt Cat will arrange for the load banks and the personnel to conduct the test, with fuel being the responsibility of others. All work is to be conducted during normal Holt working hours (Monday –Friday, 7:30 AM – 4:30 PM, excluding national holidays) unless otherwise stated with in this quotation. (Please provide at least two -week notification before startups). Additional charges may be added for wor ked requested to be done outside HPS standard business hours, or holiday. Installation is to be by others. Thank you for the opportunity of quoting this project. Holt Power Systems remains at your disposal for any additional information or assistance that you may require. Sincerely yours, Matt Hodges Power Systems Sales 5665 SE Loop 410 San Antonio, TX 78222-3903 Cell: 512-803-5531 matt.hodges@holtcat.com Page 104 of 171 CAT 500KW Diesel Generator Set BILL OF MATERIAL Quantit y Characteristic Name Feature Code Feature Description 1 PGS EMISSION CERTIFICATION CERTESE_ I EPA STATIONARY EMERGENCY Meets USA Environmental Protection Agency (EPA). Stationary Emergency Certifications for Stationary Use only during defined emergency conditions. Standby ratings - Stationary Emergency emissions levels Tier 3 1 VOLTAGE OPTION 60H0480_I 60HZ 480 VOLT (WYE) Voltage Indicator 60 Hz, 480V 1 APPLICATION INDICATOR STANDBY_ I STANDBY POWER STANDBY POWER APPLICATION Output available with varying load for duration of the interruption of the normal source power. Average power output is 70 % if the standby power rating. Typical operation is 200 hours per year, with the maximum expected usage of 500 hours per year. 1 ENGINE RATING KW00500_I 500ekW, 60Hz, 1800rpm 60 Hz, 500 kW W/Fan 1 UL LISTING ULLIST_I UL 2200 LISTED PACKAGE GEN SET 1 MARKET WORK CODE MWCODEF _I STANDBY POWER 1 SPACE (ALT) HEATER KITS SHK0012_I SPACE HEATER 12 Space heaters protect generator windings from abnormally high humidity conditions when the generator is idle. The heater maintains the air around the windings at a suitable temperature to prevent winding corrosion due to condensation. Voltage: 120V/230V, Power: 150V/250W 1 ALTERNATOR TEMPERATURE RISE GENT130_I 130C TEMP RISE OVER 40C AMB Page 105 of 171 1 ALTERNATOR OGNAR61_ I LC6124F AREP CIP ALT 61 Gen. Frame LC6124F: AREP LC Generator frame with Coastal Ingress Protection (CIP). Temp Rise upto 130DegC 1 VOLTAGE REGULATOR STDIVR_I INTEGRATED VOLTAGE REGULATOR The Integrated Voltage Regulator (IVR) is designed to provide robust, precise closed-loop control of the generator voltage, optimized transient performance and industry leading feature specification 1 GEN RUNNING & FAULT RELAY EMCCAS3_ I GEN RUNNING & FAULT RELAY Gen Running & Fault Relay 1 ALT ATTACHMENTS PMEXCI3_I PERMANENT MAGNET EXCITATION 03 Permanent magnet generator provides improved source of excitation to alternators. 1 CURRENT TRANSFORMER CT1005A_I 1000:5 CT RATIO 1 GEN MOUNTING & DUCT PLATE GENMTG_I GEN MOUNTING DUCT PLATE 1 EXTERNAL CONTROL GROUP ANLIN01_I EXTERNAL ANALOG INPUT Two terminal blocks wired to controller inputs. Inputs are locked but can be configured via dealer Service Tool (CAN). 1 BASE TYPE (MOUNTING OPTION) MNTWB10_ I WIDE BASE 10 Wide Base 1 SUB BASE FUEL TANK FTDW005_I 1000 Gal SUB TANK BASE 1024 Gal (3876 Litres) Usable Capacity, 38Hr Sub tank base. UL142 construction. 1 FUEL TANK OPTIONS FFLCK_I FUEL TANK FILL PIPE & LOCK CAP Locking fuel fill 1 ENCLOSURE ENCSAV7_ I SA LVL 2 ENC - WHITE, W/O WIND SA Level-2 Enclosure without viewing window, White. Upto 72dBA 1 CONTROL PANEL MODEL EMCP42B_ I EMCP4.2B CONTROL PANEL The Cat® EMCP 4.2B offers fully featured power metering, protective relaying Page 106 of 171 and engine and generator control and monitoring. Engine and generator controls, diagnostics, and operating information are accessible via the control panel keypads; diagnostics from the EMCP 4 optional modules can be viewed and reset through the EMCP 4.2B 1 BATTERY OPTIONS BAT2454_I STANDARD WET BATTERY Standard wet batteries come pre installed with the Genset. Technical: 1000 CCA batteries, Wet, 90 amp/hr. 1 BATTERY CHARGERS BTC1028_I BATTERY CHARGER 10 AMP This 10 Amp battery charger offers accurate, automatic charging of lead-acid and nickel cadmium batteries. The output voltage automatically adjusts to changing input, load, battery and ambient conditions. This prevents battery over-charging and consequent loss of battery electrolyte. Refer: LEHE0141 1 JACKET WATER HEATER WHHH03_I JACKET WATER HTR PUMP STYLE 03 With Circulating Pump Requires customer supplied aux supply 1 CONTROL PANEL LOCATION EMCCPLH_ I CONTROL PANEL MOUNTING LEFT 1 HEATERS CONTROL GROUP HTRCG01_ I HEATER CONTROL GROUP Includes shore power relay, circuit breaker, terminals and harnesses to be used when connecting jacket water heater and / or alt space heaters 1 CIRCUIT BREAKER SELECTION SINGLE_I SINGLE CIRCUIT BREAKER 1 POWER CENTER LOCATION PWRCTRH _I POWER CENTER - RH MOUNTED Right Mounted Power Center, suitable for use as service disconnect 1 1ST CIRCUIT BREAKER CBK0602_I 800A SINGLE MANUAL Circuit Breaker LS/I 1 NEUTRAL BARS NTS1_I NEUTRAL BAR NTS1 Page 107 of 171 1 POWER CENTRE CABLES CBLG002_I CB CABLE GP ABB/T6-800/600 Cables for 600A/800A breaker 1 CB NEUTRAL CABLES NCBG002_I NEUTRAL CABLE GP 800A 1 AIR CLEANER (ENGINE) STDAIR_I STD AIR CLEANER Standard Air Cleaner: Cat® standard engine air cleaners are well-suited for normal duty applications, delivering increased engine protection and preventing equipment downtime. Refer LEHE1872 1 RADIATOR STDRAD_I STANDARD RADIATOR Standard Radiator 1 MUFFLERS MUFSA42_I SA LEVEL 2 MUFFLER 1 REMOTE E-STOP BUTTON EMGSTP1_ S 1 1 MODBUS MONITORING PACKAGES DEVSER1_ I DEVICE SERVER RS485/Modbus RTU to Ethernet/Modbus TCP Gateway. Optically Isolated Ports 2 Ethernet Ports and Wi- Fi Capable. Reference LEHE0975 1 TESTING - GENERATOR SET STDTEST_I STD TEST - PKG GEN SET 0.8 PF 1 DECALS CATDEC_I CAT DECALS 1 Freight Freight to jobsite 1 Training Training 1 Startup Startup & commissioning with load bank test Page 108 of 171 Turnkey Install: Items by SunTech: Crane- four hours fuel- 1024 gallons disconnect wiring from existing generator reconnect wiring to new generator- polaris taps as required anchor new generator to slab ground new generator as required assist with CAT start up Excluded: removal of fuel from existing generator haul off of existing generator platforms or railings slab extension (existing slab is large enough for new generator) conduit stub area to be similar for new unit so existing conduit and wire can remain and be reused. Customer Price…….………………………..….…$155,263.15 Texas BuyBoard Price…………………..…….…$147,500.00 **PLEASE REFERENCE TEXAS BUYBOARD CONTRACT #597-19** Local, state, sales or TERP taxes, which may be applicable, are not included. Notes, Clarifications and Exceptions: - No plans or specs provided, quoted off of site visit and emails. ATS excluded will use the existing ATS. Enclosure is 72DBA @ 23’, exception to Georgetown 56DBA enclosure requirement, if required. - Existing gen has NO platform, proposed generator has a 38” high tank, no platforms provided unless requested. - Taxes and engineered drawings excluded. - Excluded, removal of fuel from existing gen, platforms or railings, haul off of existing gen. Accessories & Services Included: • Delivery to jobsite • Startup w/ 2 hour resistive load bank testing • O & M and Parts manuals • Soft copy Submittals o Hard copy submittals can be provided upon request Page 109 of 171 Accessories & Services NOT Included: • Factory Witness Testing (not specified) • Generator Load Side Cable Lugs • Infrared Scanning • Coordination / Arc Flash Studies and Labels • Independent Testing Agency • NETA Testing • Construction and Fuel Tank permits and/or registrations • Offloading of equipment at jobsite • Protection from damage after delivery • Cleaning and/or repairs from damage done by others after delivery • Installation of equipment shipped loose (Exhaust and Fuel Tank accessories) • Fuel for startup and testing -HOLT POWER SYSTEMS TERMS & CONDITIONS- Proposal This proposal is provided to meet the intention of the project equipment requirements. Some interpretational differences between our proposal and the specifications may exist; therefore the above bill of material contains our offer for this project. None other is expressed or implied unless stated in writing. Pricing This Proposal is valid for 30 days from the date of proposal unless specifically noted otherwise. Taxes & Permits This Proposal excludes any local, state and TERP applicable sales taxes, permits and licensing. Taxes, unless otherwise stated are not included in our Proposal. Note that a 2% additional charge is required by the state of Texas for all stationary engine equipment due to emission restrictions. This is in addition to any state and local taxes that may be required. No permits are included in this proposal unless specified in the preceding proposal. Lead Time Standard delivery of proposed Caterpillar Generator Set to jobsite will be confirmed after receipt of order and submittals are approved and credit terms are agreed. The quoted lead-times are standard from the factory at the time of this quotation. In some cases lead-times maybe able to be improved to assist in customer needs. Please call and inquire about possible improved lead-times. Note: The Caterpillar factory has mandatory factory shutdowns for two weeks in December/January and one week in July. The length of those shutdowns will extend lead-times on orders entered at those times. Orders, which include non - standard features, may require additional time before shipment. Consult with your Caterpillar dealer at the time of order. Special Notes It is the responsibility of the customer to verify the voltage, number of poles in ATS, terminal conductor sizes and other Bill of Material items quoted above as compared to the requirements of this project. Lugs for terminations are included but is the responsibility of the customer to ensure compatibility. Holt Cat will not supply new lugs once submittals are approved. Page 110 of 171 Fuel Tank Changes occur at the municipal level in regard to fire code requirements. Unless otherwise stated within the body of this quotation, the fuel tank included is as specified by the written specifications of this project (if specifications were supplied at the time of quotation). The specifications may be in conflict with City Fire Codes for the location of the project. Responsibility for local code compliance is with the specifying engineer and those responsible for the permits for the project. Payment Terms Payment due in full Net 30 after delivery with approved Holt credit or COD at time of shipment. In cases where retainage is required, a maximum of 10% retainage will be allowed. The balance of retainage is due after startup-up/ commissioning services of equipment provided by Holt Cat is completed. Sales tax will be added to invoice. Resale tax certificate must be on file with the Holt credit department for tax-exempt sales. Warranty Caterpillar’s standard two (2) year warranty applies for standby applications, unless otherwise noted. Standard manufacturer’s warranty applies to all non- Caterpillar equipment. Copies of warranty statements are available upon request. Cancellation There will be a minimum 25% cancellation fee for orders cancelled, on ce placed and accepted by Holt Power Systems. Cost of custom components, completed fabrication, or any other work performed at the time of cancellation will be added to the cancellation fee. If all material have been acquired the cancellation fees will be 100%. Caterpillar content, 14 days after orders placed will be 100% of the order. Written notice of cancellation is required. General Clarifications Holt Power Systems is an equipment supplier only. No fuel, wiring, connecting, hook-up, plumbing, or other installation type labor is included in the proposal unless noted herein. This includes any control wiring to and from the generator sets to any automatic transfer switches, paralleling gear or other devices which HPS may or may not supply. The customer is responsible for any and all installation of the above equipment. Holt personnel will perform an installation audit prior to start -up. Unless stated otherwise in this proposal, service and/or maintenance for this equipment are not included. HPS product support service group can provide a quote to the end user of this equipment for those services under a separate proposal. All equipment needed to perform any loading or unloading of the equipment supplied by Holt Power Systems is the responsibility of the buyer. Holt Power Systems limits the scope of supply for this quotation to the equipment and services listed in our bill of material. Unless specifically listed in our bill of material, equipment not indicated is to be supplied by others. We have detailed the equipment proposed in the bill of material. Please carefully review it to be certain it meets your requirements. Third party electrical testing and certifications, seismic calculations, coordination studies, stamped engineering calculations, emissions testing, NETA, infrared Page 111 of 171 scanning, meg-testing or other services and material not specifically included in the preceding quotation, is not included in this proposal. Holt Power Systems reserves the right to correct any errors or omissions. Contracts which include penalty or liquidated damage clauses for failure to meet promised shipping dates are not acceptable or binding on Holt Power Systems, unless accepted and confirmed in writing by an officer of Holt Cat . Holt Power Systems standard terms and conditions are included in the quotation and hereby become part of this quotation. These same terms need to be noted on any purchase order received by Holt Power Systems. Holt Power Systems will not be responsible for any labor or material charged by others associated with the start-up and installation of this equipment unless previously agreed upon in writing by HPS. Testing & Commissioning If included in the proposal, all on-site startup/ commissioning, testing and training will be performed Monday through Friday during normal business hours and excluding nights, weekends, or holidays unless agreed otherwise in writing. Additional charges may be added for work requested to be done outside HPS’s standard business hours, on weekends, or holiday. For those instances, standard overtime rates will apply. All permits are to be by others. Paralleling Unless otherwise stated in the proposal, a single unit generator application is represented. Startup labor, controls conversion or additions and load banking for the above equipment for a system arrangement have not been included. Shipping Delivery of the product unless otherwise stated is by hired independent freight carriers that may require road permitting and other requirements which are outside the responsibility of Holt Cat. Traffic delays and required routing may also delay deliveries. Holt Cat is not responsible for any delays and costs associated with those delays. Submittals An order for the equipment covered by this proposal will be accepted on a “Hold for Submittal Release” basis. The order will not be released and scheduled for production until written approval to proceed is received in HPS’s office. Authorization: I, (printed name) accept the above terms and conditions on behalf of (printed company name) and authorize Holt Cat to order the equipment detailed in this Proposal as per approved submittals and as described in the above Proposal. Accepted By: Authorized Signature Date Printed Name & Title Purchase Order # or Job Name Reference Thank you for the opportunity of quoting this project. Should you require additional assistance or additional information, don’t hesitate to contact me. Page 112 of 171 Sincerely yours, Matt Hodges Power Systems Sales Cell: 512-803-5531 matt.hodges@HoltCat.com Page 113 of 171 City of Georgetown, Texas Water Utility Board January 13, 2022 S UB J E C T: C onsideration and pos s ible rec ommendation to approve a Tas k O rder Amendment #1 to Tas k O rder C DM-21-006 with C DM S mith, Inc. o f Aus tin, Texas, fo r p ro fes s io nal services related to the 2022 Water and Was tewater Utility Master P lans Update, Integrated Water R es ourc e P lan, Water and Wastewater Imp act F ee and 2021/2022 Utility Evaluations S upport in the amount o f $128,725.00. -- Wesley Wright, P.E., S ystems Engineering Direc tor / C hris P ousson, C I P Manager IT E M S UMMARY: In August 2021, C ity C ouncil approved a tas k order for profes s ional s ervic es for C DM S mith to update the Water and Wastewater Mas ter P lans by updating water and wastewater demands per available data and planning information, updating and improving the water model to inc lude recently c onstruc ted facilities and operational c omponents, updating the was tewater model to include rec ently cons tructed fac ilities and inc orporate flow monitoring analysis, re-assessing propos ed water and wastewater projec ts, and develop a 10-year C I P to meet projec ted facility needs as more fully desc ribed below. Additional tas ks inc lude s upporting the C ity of G eorgetown with Water and Was tewater impact fee as s is tance, perform long range Integrated Water R esource P lan analys is and utility evaluations for 2021-2022. T his first tas k order amendment includes the installation, maintenance, data analysis and calibration of an additional 5 was tewater flow meters as part of the was tewater flow monitoring and was tewater s ystem calibrations tasks in the approved task order. O ne of the five meters will be inc luded in the downtown area for a downtown re-development review. T his amendment also inc ludes profes s ional s ervic es to provide a detailed water and was tewater redevelopment review of the downtown area to identify the ability of exis ting infrastruc ture to handle expec ted redevelopment and recommend projec ts as needed to ac count for and handle the expec ted redevelopment of the downtown area. S TAF F R E C O MME N D AT IO N S: S taff recommends executing this 1st amendment to Tas k O rder C DM-21-006 with C DM S mith, Inc. for additional professional services related to the 2022 Water and Was tewater Utility Master P lans Update in the amount of $128,725.00. F IN AN C IAL IMPAC T: F unds for this expenditure are available in the Water/Was tewater C I P Budget S UB MIT T E D B Y: C hris P ousson, C I P Manager AT TAC H ME N T S: Description Type First Amendment to TO CDM-21-006 Backup Material Page 114 of 171 Georgetown – Revised 3.11 Page 1 of 3 Attachment 1 (Modifications) to Exhibit K – Amendment to Task Order EJCDC E-505 Standard Form of Agreement Between Owner and Engineer for Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. EXHIBIT K, consisting of 4 pages, referred to in and part of the Master Services Agreement between Owner and CDM Smith, Inc. (“Engineer”) for Professional Services – Task Order Edition dated September 30, 2016. First Amendment to Task Order No. CDM-21-006 1. Specific Project Data: A. Title: Water/Wastewater Master Plan Update/Wastewater Flow Monitoring, IWRP and 2021- 2022 Utility Evaluations Support B. Description: Overall Project: Update the Water and Wastewater Master Plans by updating water demands and wastewater flows per available data and planning information, updating and improving the water model to include recently constructed facilities and operational components, updating the wastewater model to add new trunk sewers, pump stations and force mains, re-assessing water and wastewater projects, and develop a 10-year CIP to meet projected facility needs as more fully described below. Perform long-range integrated water resources planning (IWRP) analysis to examine long-range water supply options and tradeoffs. First Amendment: This amendment one includes the installation, maintenance, data analysis and calibration of an additional 5 wastewater flow meters as part of the wastewater flow monitoring and wastewater system calibration tasks. One of the 5 meters will be included in the downtown area for a downtown re-development review. This amendment also includes a detailed water and wastewater redevelopment review of the downtown area to identify the ability of existing infrastructure to handle expected redevelopment and recommend projects to handle the expected redevelopment. 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: 2016-738-MSA 2. Nature of Amendment [Check those that are applicable and delete those that are inapplicable.] Additional Services to be performed by Engineer Modifications to Services of Engineer Modifications to Responsibilities of Owner Modifications to Payment to Engineer Modifications to Time(s) for rendering Services Page 115 of 171 Georgetown – Revised 3.11 Page 2 of 3 Attachment 1 (Modifications) to Exhibit K – Amendment to Task Order EJCDC E-505 Standard Form of Agreement Between Owner and Engineer for Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. Modifications to other terms and conditions of the Task Order 3. Description of Modifications A. Engineer shall perform the following Additional Services: Subtask 5.10 Downtown Redevelopment Review Water Analysis: This task will perform a detailed water system analysis of the downtown area based on the redevelopment map included in Attachment 2 as well as a sensitivity analysis of the max buildout redevelopment of the downtown overlay district. This task will identify existing deficiencies and perform a future condition analysis including identification of recommended improvements based on the currently planned redevelopment and a buildout redevelopment analysis. The downtown water analysis will be documented in the Draft and Final Water Master Plan Report. Subtask 6.3 Wastewater Flow Monitoring Updates: Wastewater flow monitoring will be included at 15 key locations, adding an additional 5 locations from the original agreement. This task includes hydraulic selection of locations, installation/operation and maintenance of flow meters, and wet weather/dry weather data analysis. Flow meters will have wireless capability and access will be to view (read only) flow data. Flow monitoring will be conducted for a 90-day period. The approximate location of the 15 flow meters is illustrated in Attachment 1. Subtask 6.4 Existing System Calibration Updates: The existing system model will be calibrated based on the flow monitoring data captured and analyzed in Task 6.3 including the 5 additional flow monitoring locations. Subtask 6.8 Downtown Redevelopment Review Wastewater Analysis: This task will perform a detailed wastewater analysis of the downtown area based on the redevelopment map included in Attachment 2 as well as a sensitivity analysis of the max buildout redevelopment of the downtown overlay district. This task will identify existing deficiencies and perform a future condition analysis including identification of recommended improvements based on the currently planned redevelopment and a buildout redevelopment analysis. The downtown wastewater analysis will be documented in the Draft and Final Wastewater Master Plan Report. B. The Scope of Services currently authorized to be performed by Engineer in accordance with the Task Order and previous Amendments, if any, is modified as follows: Modifications to the scope are documented in paragraph A above. C. The responsibilities of Owner are modified as follows: No change from original agreement. D. For the Additional Services or the modifications to Services set forth above, Owner shall pay Engineer the following additional or modified compensation: Page 116 of 171 Georgetown – Revised 3.11 Page 3 of 3 Attachment 1 (Modifications) to Exhibit K – Amendment to Task Order EJCDC E-505 Standard Form of Agreement Between Owner and Engineer for Professional Services—Task Order Edition Copyright ©2004 National Society of Professional Engineers for EJCDC. All rights reserved. 2022 Master Plan CIP Tasks Additional Cost Task 5.10 Downtown Redevelopment Review Water Analysis $28,495.00 Task 6.3 Wastewater Flow Monitoring $46,710.00 Task 6.3 (CDM Smith)$5,210.00 Task 6.3 (Interra Hydro)$41,500.00 Task 6.4 Existing System Calibration $23,100.00 Task 6.8 Downtown Redevelopment Review Water Analysis $30,420.00 TOTAL $128,725.00 E. The schedule for rendering Services is modified as follows: No change from the original agreement F. Other portions of the Task Order (including previous Amendments, if any) are modified as follows: No additional changes. 4.Attachments [if any]: Attachment 1: Flow Meter Locations Map Attachment 2: Downtown Redevelopment Map Terms and Conditions: Owner and Engineer hereby agree to modify the above-referenced Task Order as set forth in this Amendment. All provisions of the Agreement and the Task Order not modified by this or previous Amendments remain in effect. The Effective Date of this Task Order Amendment is . OWNER:ENGINEER: By:By: Name:Name:Allen Woelke, P.E. Title:Title:Vice President Engineer License or Firm’s Certificate No.F-3043 State of:Texas City Attorney _________________________________ Skye Masson Page 117 of 171 F M 971 W SH 29 F M 3 4 0 5 C R 1 0 0 N IH 35 SB R M 2 2 4 3 F M 9 7 2 C R 1 5 0 E S H 2 9 SH 195 F M 1 1 0 5 C R 1 1 0 R O N A L D W R E A G A N B L V D C R 1 3 0 N IH 35 NB W ILLIA M S D R N IH 35 FWY SB N IH 35 FWY NB C R 1 5 2 C R 1 2 4 F M 1 4 6 0 RM 2338 S H 1 3 0 S BLEANDER R D C R 175 S H E L L R D C R 2 5 5 C R 1 0 5 S H 1 3 0 T O L L S B S H 1 3 0 T O L L N B C R 1 2 6 S IH 35 NB C R 2 5 8 C R 1 5 6 U N I V E R S I T Y B L V D C R 1 1 2 C R 2 6 6 S I H 3 5 F W Y S B C R 3 2 9 S IH 35 FWY NB C R 1 4 0 C R 1 4 3 C R 2 7 0 FM 1660 C R 2 6 2 LIMMER LOOP C R 1 2 0 C R 1 1 8 C R 1 7 6 D B W O O D R D U S 1 8 3 N B H E R O W A Y C R 1 9 4 C R 1 2 1 C R 2 4 5 C R 1 4 7 C H A N D L E R R D C R 2 8 9 CR 154 C R 1 4 9 C R 1 0 6 S IH 35 SB S E I N N E R L O O P AIRPORT RD C R 2 6 0 C R 1 0 3 C R 1 0 8 E U N I V E R S I T Y A V E CR 267 C R 2 6 1 C R 1 4 1 C R 1 5 3 1 8 3 A T O L L R D F R S B 1 8 3 A T O L L R D F R N B C R 1 2 7 C R 1 0 7 S A U S T I N AV E S U N CIT Y B L V D C R 1 5 5 C R 1 7 7 NE INNER LOOP C R 1 3 1 U S 1 8 3 S H 1 3 0 N B CR 234 N AUSTIN AVE D R V W 1 8 3 A T O L L R D S B 183A TOLL RD NB P A T R I O T W A Y C R 1 4 8 S U S 1 8 3 C R 3 2 7 W E S T I N G H O U S E R D TOWER RD CR 256 S E R E N A D A D R AS H S T S A M H O U S T O N A V E E L M S T CR 248 R O C K R I D E L N C R O S S C R E E K R D L A K E W A Y D R S C R 2 8 9 C R 1 4 2 P I N E S T I N D I A N S P R I N G S R D U S 1 8 3 S B P A T R I C I A R D W UNIVERSITY AVE N O R T H W E S T B L V D C R 2 5 9 B E R R Y L N C R 2 4 7 S W E S T D R C E D A R H O L L O W R D C R 1 8 6 C R O S S C R E E K L N G R O V E L N C R 1 9 6 DEL WEBB BLVD C R 1 8 9 P V R 9 0 0 B O N N E T L N C R 1 1 9 S O N N Y D R P V R 9 0 8 C R 1 6 6 DAW N DR P V R 9 4 5 R I D G M A R R D S C H U R C H S T JIM HOGG RD J O U R N E Y P K W Y O A K B R A N C H D R C R 1 6 2 REDBIRD RD W S O U T H S T E 1 5 T H S T E A S T V I E W D R WEIR RANCH RD RED OAK B O O T Y S C R O S S I N G R D N I H 3 5 F R B U C K B N D O L D 2 2 4 3 W E S T D O E R U N N A W G R I M E S B L V D E 7 T H S T M A P L E S T C H A M P I O N S D R S O UTH W ESTER N BLVD CR 268 N IH 35 F W Y S T A D I U M D R W H I S P E R L N N U S 1 8 3 S E D R O T R L R O C K H O U S E D R B E L L G I N R D R O C K S T H O R I Z O N P A R K B L V D CR 331 TERAVISTA CLUB D R S E T O N P K W Y C R 1 1 7 BAKER LN P V R 9 1 6 MALAGA DR N C O LLE G E ST M E L M A T H I S A V E OLD HWY 29 S K Y L I N E R D E A G L E S W A Y WOLF RANCH PKWY C R 1 6 7 N L A K E W O O D S D R P A R K S I D E P K W Y FLINN ST HIGHLAND SPRING LN M U N I C I P A L D R S B A G D A D R D E S A N G A B R I E L P K W Y K I N G R E A W RID G E W O O D R D M E S A D R C R 1 0 9 S H 1 3 0 S B F R CR 257 L O S T R I V E R R D M AD RID DR C O U R T N E E S W A Y L E A N D E R D R PARK LN V A L L E Y V I E W R D R A B B I T H I L L R D B R A N G U S R D S H 1 9 5 E B R A I D E R W A Y G R E E N A C R E S P V R 9 2 0 RAILROAD AVE C A V U R D H O L L Y S T N MAYS ST W ESPARADA DR CEDAR BREAKS RD R U S K L N PARKER D R T W I N C R E E K D R P V R 9 3 3 L E M E N S A V E C R 1 9 1 L U N A T R L C A R U S O L N J A N L N R I V E R R U N N A V A J O T R L L I G H T N I N G R A N C H R D RIVERY BLVD A L Y S O N L N WHISPERING WIND DR S U S A N A D R UNITY DR C R 2 7 6 C O U N C I L R D C R 2 6 9 MARKET ST R I V E R B E N D D R P V R 9 0 7 F A M I L Y C I R Q U AIL V A L L E Y D R LIVE OAK SEVILLA DR KAUFFMAN LOOP VERDE VISTA C R 1 0 1 W E S T S T A L L E N C I R S I E R R A D R E 2 N D S T H U T T O R D L I Z L N CROCKETT GARDENS RD C O OL SPRIN G W AY P V R 9 1 4 L O G A N R A N C H R D LANDONS WAY SUNNY SLOPE RD CR 264 C A R L S O N C V L O V I E L N W I N D Y H I L L R D W S E Q U O I A T R L R I D G E V I E W D R L I O N D R G L A S S D R P V R 9 1 5 D E E R T R L TERRA ST RANCHO BUENO DR M U S T A N G W A Y L A C Y D R WILD OAK TRL L A N D F I L L R DTAMARA D R P O L O B N D SHEPHERD RD W IL D W O O D D R W 17TH S T I N D I G O L N E C R Y S T A L F A L L S P K W Y S I N U S O D R S LAKEWOODS DR B U S B Y X I N G F A U B I O N D R POWER RD D O V E H O L L O W T R L W CIMARRON HILLS TRL ALMQUIST ST E S T R E L L A X I N G R I C H A R D R D S A U L S T R A N C H R D DIEGO DR S C E N I C L A K E D R H Y V I E W L N B R I A R C R E S T D R A R T E R I A L H L U N A T A W A Y Y O U N G R A N C H R D R I V A R I D G E D R SYLVAN ST SOUTH GABRI EL DR D E E R D R A W L I V E O A K T R L L A Q UIN T A D R T O P A Z L N H A R B O R D R C H A P A R R A L R D M E A D O W D R K E L L E Y D R LAWHON LN G R A N D L A K E P K W Y S A T E L L I T E V W N E C H E S T R L SU NSET R D O A K R I D G E R D P E N N Y L N B E R R Y C R E E K D R L A R K S T G A B RIEL VIE W D R S H 1 3 0 N B E X I T BELLAIRE DR KING REA SPUR L A K E S I D E D R SPRIN G VALLEY R D VAL VERDE DR R E E F L N E X I T 4 1 5 S B PA R K P L A C E D R M E M O R I A L D R S H E L L S T O N E T R L S N E A D D R P V R 9 4 9 S H 1 3 0 T O L L R I O B R A V O R D P I E N Z A D R L E E D R I N D I A N M O U N D R D F A W N R I D G E EXIT 417 SB R I V E R V A L L E Y D R ALG ERITA D R CR 132 J A C O B S W A Y W I C H I T A T R L A S H B U R Y R D J E N N I N G S B R A N C H R D ARMSTRONG DR T E N O A K S D R O A K T R E E D R H I G G S R D P I N N A C L E D R VIA DE SIENNA BLVD PERRY MAYFIELD F A R R I S R A N C H R D S U N R I S E R D P V R 9 4 6 S H 1 3 0 N B F R W O L F R D H O B B Y S T A S H B E R R Y T R L E E S P A R A D A D R ADDIE LN FORES T ST T E X A S D R B U E N A V I S T A D R E S T A N C I A W A Y P V R 9 1 8 H O M E S T E A D L N ORCHARD DR R E I N H A R D T B LV D W 11 T H S T E M O R R O W ST R I V E R V I E W D R SCISSORTAIL TRL R U SSE LL PAR K R D JOSHUA DR SERVICE WAGON WHEEL TRL MARQUESA TRL R A N C H E R O R D VORTAC LN ENTR 265 NB C O LL E G E P A R K D R DIAMOND TRL GOODNIGHT DR B O N N E T B L V D V I S T A L N S M A I N S T G R E E N S I D E T R L L E A N D E R S T T O L T E C T R L BOWLINE DR Y A U P O N D R P V R 9 3 1 C H A D W I C K D R YUKON TER E X I T 4 2 1 S B MAGELLAN WAY S I L V E R A D O D R R E D BIR D T R L ENTR 417 SB HERITAGE LOOP S A N J O S E S T B E L L M E A D O W S D R G A B R I E L F O R E S T L A U R E L G L E N B L V D G R A N A D A D R W E S T B U R Y L N W I L L S M I T H D R EXIT 262 SB GOLDRIDGE DR H E R I T A G E G R O V E R D CERVINIA DR F A I R O A K S S T PEG G Y D R C A S S I D Y D R G R A N I T E D R ENTR 266 SB S T A N D I N G O A K D R LO W ER PARK RD COUNTRY RD N I C O L E W A Y W WINDEMERE R I D G E O A K D R S T O W N S M I L L R D BL U E Q U AIL D R C A R M E L C R E E K S I D E D R EXIT 265 NB E X I T 4 1 9 S B C A T T L E M A N D R W I L L O W D R A N D ELE W AY L I T T L E E L M W A Y R I D G E W O O D D R ENTR 262 SB TWIN SPRINGS RD BELEN DR K A T Y L N W I N D M I L L R I D G E R D C A L L A L I L Y B L V D S U N N Y V A L E CREEK CROSSING DR P V R 9 1 0 DAN MOODY TRL B L U E S P R I N G S B L V D R A B B I T H O L L O W L N B R Y S O N R I D G E T R L D O R A D O S T TA S C A T E S T S P A N I S H O A K D R FAIR OAKS DR W O O D R A N C H R D W E S T L A K E P K W Y H I L L R I D G E D R D A W S O N T R L C R 1 0 7 S P U R SIGNAL HILL DR T E R A V I S T A X I N G AXIS LP S C U R L O C K F A R M S R D CR 328 N HOOT O WL LN O L D P E A K R D E 21ST ST E X I T 4 1 3 S B EXIT 260 SB L O S T O A K C V ENTR 261 NB ALDEA ST E 1 9 T H S T PVR VIEW DR T U L A T R L L A S C O L I N A S D R SHADY ELM DR RIVER DOWN RD M Y R N A B N D W I L K I E L N SUNSET DR W AYC R O SS D R KRUPP AVE M I D D L E B R O O K D R M A T T H E W R D AER O D R LANTANA D R B R A D L E Y R A N C H R D A B I L E N E L N L A Z Y R D C R A I G E N R D M O U L I N S L N G R E AT V I E W D R B A R L E Y R D GANN ST L O N E S T A R D R W A R F I E L D O A K M O N T D R M A S O N S T PALMETTO DR HENDELSON LN B A S S S T DEER FIELD DR C A S A L O M A C I R W I L B U R W R I G H T D R O A K P L A Z A D R K YL E L N W I L D F L O W E R L N H O R S E S H O E D R RIVER HILLS DR GREENSIDE LN M A D I S O N O A K S A V E ORCHARD RIDGE PKWY E X I T 2 6 0 N B C R 2 7 4 S B R U S H Y S T M E A D O W C R E S T D R J U D G E FIS K D R M E D A S T ALYSSA DR F O L S O M C T H E R M A N N S T P V R 9 0 6 M A R TIN C R E E K L N V A L L E Y VIE W D R DE SOTO LOOP D R I V E W A Y V I N E S T PABLO WAY B U M B L E B E E D R C E N T E R B R O O K P L F L I N T L O C K D R P E C A N C R E E K D R S O U T H R I D G E C I R K I N G L N SYCAMORE ST DEWBERRY DR O L D B L U E M O U N T A I N L N E T N A W A Y H O L M E S R D S B A K E R C I R WOODLAKE DR BIRDSTONE LN H I L L V U E R D J E F F E R S O N L N ENTR 268 NB L A M I R A D A S T BROADE WAY M O N T E L L D R A V I A T I O N D R R A I N D A N C E D R C R Y S T A L L N WILCO WAY W O O DLAND RD E R I C A N N A L N T E R M I N A L D R E N T R 411 S B C L E A R V I E W D R C A L V I N S T C HI C HI D R FONTANA DR B R O M E D R E N T R 2 6 0 N B S K I N N E R L N E V A N G E L I N E L N C E D A R L A K E B L V D WINTER D R S U N S E T R D G V A L L E Y D R M A N C O S D R B I G V A L L E Y S P U R B I G D R M E L D A S T EXIT 256 SB N CHURC H ST W IL L O W R U N GOOSE ISLAND DR T H U N D E R B A Y D R E A S T D R B U C K L N C A M P D R A G A V E L N T R I N I T Y L N B L I S S L N M A T T H E W L N F I O R E T R L B A R C H E T T A D R A N TLE R D R N G A B R I E L S T G A B R I E L W O O D S D R PIGEON VIEW ST S O U T H G L E N C V H A L M A R C V S O R A N O A V E G R E E N L E E D R R A I N L I LY L N T H O M A S P A R K D R W M E T R O D R DURANGO TRL M I N D Y W A Y LEONARDO DR R I F L E B E N D D R C O T T O N T A I L L N N I G H T H A W K W A Y M A R B E L L A W A Y N O G A L E S L N YAUPON LN CAVALIER CV SALT CREEK LN S U M M IT S T STEPHEN LN I S A B E L L A L N ROSADI CV H I C K O R Y T R E E D R S E T T L E R S P A T H W O O D Y W A Y R A N C H V I E W R D A N I M A S D R H E I D E R O S A R U N C O U N T R Y V I S T A L N ELK DR S P R A Y L N A R R O W H E A D R D T A N A G E R P A S S WEST BEND DR B I G O A K S S U N S H I N E D R C A M I N O A L T O D R WOODVISTA PL TA SU S WAY F L I N T R O C K D RPIRATE D R R A N I E R L N NUECES TRL R O C K M I L L L N G R A C E B L V D C R E E K M E A D O W C V W O O D V I E W D R M I C K E L S O N L N H I G H T R A I L D R S H 1 3 0 S B WILLIAMS DR US 183 SB SH 195 U S 1 8 3 S H 130 S B N IH 35 NB T E X A S D R C R 1 4 7 C L E A R V I E W D R F M 1 1 0 5 S H 1 3 0 S B F R C R 2 5 8 DRVW FM 971 S H 1 3 0 S B S H 1 3 0 N B E MORROW ST S H 1 3 0 S B F R R A B B I T H I L L R D F M 1 6 6 0 C R 1 0 7 MA PLE S T N M AY S S T SUN CITY BLVD U S 1 8 3 K A U F F M A N L O O P S IH 35 NB PECA N BR ANCH WW TP SA N GABRIEL WW TP BERRY CREEK WWTP DOVE SPRINGS WWTP CIMMARO N HILLS WWTP 4,300 Feet Page 118 of 171 Int-LS S G -T SCENIC LS BLUE HOLE LS INTERCEPTOR LS Sources: Esri, HERE, Garmin, USGS, Intermap, INCREMENT P, NRCan, Esri Japan, METI, Esri China (Hong Kong), Esri Korea, Esri (Thailand), NGCC, (c)OpenStreetMap contributors, and the GIS User Community Page 119 of 171 35-40k SF Bank/ Office (R Bank) (Site Work) Possible Parking Garage Possible Parking Garage Possible Parking Garage Wish Well (Opening) 70-100k SF Office/Retail/ Restaurant/ Hotel (Bank Building to Remain) 30-40k SF Hotel New Restaurant (Todos Santos) Attachment 2 Page 120 of 171 City of Georgetown, Texas Water Utility Board January 13, 2022 S UB J E C T: C onsideration and pos s ible rec ommendation to approve a c ontract amendment to C F G Indus tries, LLC . O f Magnolia, T X for additional repairs needed for the S outhside C learwell R oof R eplac ement and R ehabilitation projec t in the amount of $98,000.00. -- Wes ley Wright, P.E., S ys tems Engineering Director / C hris P ousson, C I P Manager IT E M S UMMARY: In April 2021 C ity C ounc il approved to award a contrac t to C F G Industries , LLC for the S ouths ide C learwell R oof replac ement and rehabilitation project. After awarding the contrac t to C F G but prior to them mobilizing onsite. T he C learwell roof s upport struc ture experienc e further degradation resulting in the roof deflec ting and partial collapse of panel sec tion(s ) of the ring wall. Due to the further degradation and subs equent damage occ urring. F urther work outs ide of the awarded s cope is required to ens ure proper repairs of the tank is c ompleted along with the original sc ope of work which included the removal and replacement of the C learwell roof and c omplete removing and replacement of the coating sys tem. As part of the projec t s tructural inspec tion has been c ompleted and no further s tructural is s ues have been disc overed. T hese additional repairs along with the awarded s cope will allow the C learwell to be returned to s ervic e and c ontinue to provide water s torage for the sys tem and cus tomers. C DM S mith and C ity S taff have reviewed the sc ope of work required to make these additional repairs, impact to sc hedule and c os t. S TAF F R E C O MME N D AT IO N S: S taff and C DM S mith rec ommends approval of a contrac t amendment to C F G Industries , LLC . O f Magnolia, T X for additional repairs needed for the S outhside C learwell R oof R eplac ement and R ehabilitation projec t in the amount of $98,000.00. F IN AN C IAL IMPAC T: F unds for this expenditure are available in the Water C I P Budget. S UB MIT T E D B Y: C hris P ousson, C I P Manager AT TAC H ME N T S: Description Type Change Order Documents Backup Material Page 121 of 171 EJCDC C-941 Change Order – Revised 2/2013 Prepared by the Engineers Joint Contract Documents Committee and endorsed by the Construction Specifications Institute. Page 1 of 2 Change Order No. 01 Date of Issuance: 11/9/2021 Effective Date: Owner: City of Georgetown Purchase Order No.: N/A Owner's Contract No.: 21-0063-CIP Contract: Southside Water Treatment Plant Clearwell Roof Replacement (Project No. PRJ000228) Date of Contract: February 2021 (NTP 6/21/2021) Contractor: CFG Industries LLC Engineer's Project No.: 2048-225799 The Contract Documents are modified as follows upon execution of this Change Order: Description: Out-of-scope tank repairs are needed due to additional recent tank roof deflection that has caused damage to the upper portion of the existing welded steel clearwell ground storage tank. The damaged tank shell plates in the upper two rings of the tank will need to be removed and repaired with new tank steel plate material. This $98,000 change order is needed so CFG Industries can perform the out-of-scope tank repairs. Attachments (list documents supporting change): Refer to attached CFG Industries Change Request No. 1 dates 10/15/2021 CHANGE IN CONTRACT PRICE: CHANGE IN CONTRACT TIMES: Original Contract Price: Original Contract Times: Working days Calendar days Substantial completion (days or date): 300 days $547,000.00 Ready for final payment (days or date): 330 days From previously approved Change Orders No.: From previously approved Change Orders No.: Substantial completion (days): N/A N/A Ready for final payment (days): N/A Contract Price prior to this Change Order: Contract Times prior to this Change Order: Substantial completion (days or date): 15 days $98,000.00 Ready for final payment (days or date): 15 days Increase/Decrease of this Change Order: Increase of this Change Order: Substantial completion (days or date): 315 days $0.00 Ready for final payment (days or date): 345 days Contract Price incorporating this Change Order: Contract Times with all approved Change Orders: Substantial completion (days or date): 315 days $645,000.00 Ready for final payment (days or date): 345 days RECOMMENDED: ACCEPTED: ACCEPTED: By: By: By: Engineer (Authorized Signature) Owner (Authorized Signature) Contractor (Authorized Signature) Date: Date: Date: 11/9/2021 Page 122 of 171 EJCDC C-941 Change Order – Revised 2/2013 Prepared by the Engineers Joint Contract Documents Committee and endorsed by the Construction Specifications Institute. Page 2 of 2 Change Order Instructions A. GENERAL INFORMATION This document was developed to provide a uniform format for handling contract changes that affect Contract Price or Contract Times. Changes that have been initiated by a Work Change Directive must be incorporated into a subsequent Change Order if they affect Price or Times. Changes that affect Contract Price or Contract Times should be promptly covered by a Change Order. The practice of accumulating Change Orders to reduce the administrative burden may lead to unnecessary disputes. If Milestones have been listed in the Agreement, any effect of a Change Order thereon should be addressed. For supplemental instructions and minor changes not involving a change in the Contract Price or Contract Times, a Field Order should be used. B. COMPLETING THE CHANGE ORDER FORM Engineer normally initiates the form, including a description of the changes involved and attachments based upon documents and proposals submitted by Contractor, or requests from Owner, or both. Once Engineer has completed and signed the form, all copies should be sent to Owner or Contractor for approval, depending on whether the Change Order is a true order to the Contractor or the formalization of a negotiated agreement for a previously performed change. After approval by one contracting party, all copies should be sent to the other party for approval. Engineer should make distribution of executed copies after approval by both parties. If a change only applies to price or to times, cross out the part of the tabulation that does not apply. Page 123 of 171 0DJQROLD+LOOV'ULYH 0DJQROLD7H[DV &HOO 2IILFH &)*,1'8675,(6//& Change Request Job:&,7<2)*(25*(72:1 Number: Date: 10/15 To:*HUDOG6)XUULHU3(303%&(( $VVRFLDWH(QJLQHHU &'06PLWK :HVWKHLPHU5RDG6XLWH +RXVWRQ7; RIILFH PRELOH Description:5HSDLU*67([WHULRU We are pleased to offer the following specifications and pricing to make the following changes: 5(3$,5$5($2)7$1.$62)$8*8677+:+,&+,1&/8'('(;75$6758&785$/6833257$1''(9,$7,21 )256758&785$/5(3$,52)7+(25,*,1$/&21',7,212)%$6(%,'352326$/ Further Structural Repair to support the current conditions of the tank and additional safety measures will be implemented to protect workers safety. The total amount to provide this work is ..................................................................................................$ .00 Submitted by:Approved by: Date: &RY\:LONLQVRQ Page 1 of 2Page 124 of 171 Change Request 2 Price Breakdown Continuation Sheet Description:5HSDLU*67([WHULRU Description PriceOtherLabor $ Page 2 of 2 &)*,1'8675,(6//& 0DJQROLD+LOOV'ULYH 0DJQROLD7H[DV &HOO 2IILFH Material Equipment Subcontract 8 $ Labor 1.Welders a. 3 welders at $65hr b. 1 welders helper at $35hr c. 14 days for completion 2.Lodging 3.General Laborers a. Project Manager 4. 0DWHULDO 1.Steel Fabrication 2.Fuel 3.Welding Consumables (TXLSPHQW 1. Welding Machines 2. Crane and Operator 3. Compressor 4. Forklift :HOGHUVWLPHODERUDQGHTXLSPHQW 98,000 Page 125 of 171 Services Proposal Pricing: ITEM UOM Type of Service Requested Pay Rate Hours 1 Hrly welder $65.00 10.00 2 Hrly Welder $65.00 10.00 3 Hrly Welder $65.00 10.00 4 Hrly Welder $35.00 10.00 ITEM UOM Equipment Rates Per Hour Days/Hours 5 DAILY Compressor $300.00 12 6 HR Crane $425.00 24 7 DAILY Forklift $450.00 12 8 DAILY Welding Machines $250.00 12 ITEM per unit Material Rate Amount 9 unit Metal Fabrication $12,500.00 10 unit Welding Consumables $12,500.00 ITEM per unit Overhead and Profit Rate Amount 11 OVERHEAD 12%$79,750.00 12 PROFIT 10%$89,320.00 CFG Industries 22535 Magnolia hills Dr Magnolia Tx, 77354 Quote:GEORGETOWN SHELL REPAIR Page 126 of 171 Page 127 of 171 Page 128 of 171 City of Georgetown, Texas Water Utility Board January 13, 2022 S UB J E C T: C onsideration and pos s ible rec ommendation to approve Task O rder KPA-22-002 with Kasberg, P atric k & As s ociates , LP of G eorgetown, Texas , for professional services related to F Y 22 Water S ystem Improvement projec ts that cons is t of three water line improvements and one water pump s tation upgrade projects in the amount of $1,133,525.00. -- Wes ley Wright, P.E., S ys tems Engineering Director / C hris P ousson, C I P Manager IT E M S UMMARY: T he work to be performed by the Engineer under this tas k order c onsists of profes s ional engineering s ervic es for des ign services inc luding the assoc iated eas ement doc uments, environmental phas e 1 and G eological as s es s ment investigations. Als o included are bidding, and cons truction s ervic es for three water line improvement projects and one water pump s tation upgrade projec t. T hese as s ociated projec ts are inc luded in the F Y 2022 Water C apital Improvement P lan. T he projec ts as s ociated with this task order are as follows: Aviation Drive Water Line Project: T his project c onsists of the design, bidding, and c onstruc tion s ervic es of approximately 7,000 LF on 16” water line from S H 195 south along the wes t s ide of I H35 and will connec t to the proposed Aviation Drive Extens ion at I H35. T his als o include approximately 800 LF of 12” water line from S H 195 to the c urrent terminus of the existing water line on Berry C reek Drive. T his project is needed to provide redundanc y and additional fire flow from a higher pres s ure plane to the Industrial/C ommerc ial/R etail development in the area. County Road 262 Water Line Improvement P roject: T his project c onsists of the design, bidding, and cons truction s ervic es for approximately 10,400 LF of 12” water line along C R 262 from the intersec tion of R eef Lane and extend to the end of C R 262 near the entrance to R ussell P ark. T his project is needed to improve fire flow in the area and eliminate multiple different s ized lines that run the length of C R 262. T his als o includes a 12” line to be bored under F M 3045 to c onnect exis ting water lines to improve looped feeds and improve fire flow. Carriage Oaks Water Line Improvements P roject: T his project c onsists of the design, bidding, and cons truction s ervic es for approximately 6,250 LF of a 16-inch Water line from the C arriage O aks ES T located near the inters ection of C R 200 and P alomino P lace and will extend eas t along P alomino P lac e and will trans ition to a 24-inc h water line at C R 214. T he 24-inc h water line will then c ontinue south along C R 214 for approximately 6,000 LF and connec t to the exis ting 20-inc h water line jus t north of the C R 214 & Neal Drive Inters ection. T his project is needed to meet continuing growth demands in the area. S tonewall Ranch Booster P ump S tation Improvements: T his projec t cons is ts of the des ign, bidding, and cons truction s ervic es for the expansion of the exis ting pump s tation from 2.5 million gallons per day (MG D) to approximately 4 MG D. T he existing P ump S tation has two (2) 250 HP horizontal s plit case pumps with a loc ation for a third (3rd) pump. T he new third pump will be on a variable frequency drive allowing O perations to better c ontrol tank levels and flow in the area. In addition to the pump addition, the improvements will inc lude the addition of a pump control valve, dis charge pres s ure trans mitter, and an emergency generator, replac ement of the tank fill control valve and manhole and applicable electrical improvements to acc ommodate the new pump and generator. Page 129 of 171 S TAF F R E C O MME N D AT IO N S: S taff recommends approval of Task O rder KPA-22-002 with Kasberg, P atric k & Assoc iates, LP of G eorgetown, Texas, for profes s ional s ervic es related to F Y 22 Water S ys tem Improvement projec ts that cons is t of three water line improvements and one water pump s tation upgrade projec ts in the amount of $1,133,525.00. F IN AN C IAL IMPAC T: F unds for this expenditure are available in the Water C I P Budget. S UB MIT T E D B Y: C hris P ousson, C I P Manager AT TAC H ME N T S: Description Type Task Order KPA-22-002 Backup Material Page 130 of 171 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: FY 22 Water System Improvements Projects B. Description: The FY 22 Water System Improvements Projects will consist of three (3) water line improvements and one (1) pump station upgrade. The proposed water line improvements include the SH 195 to Aviation Drive 16-inch Water Line Improvements, CR 262 12-inch Water Line Improvements, and the Carriage Oaks 16-inch & 24-inch Water Line Improvements. The proposed pump station improvements will be upgrading the pumps and electrical components at the Stonewall Ranch Pump Station. The professional engineering services for the water line improvements include project management/coordination, utility easement coordination, preliminary design, final design, bidding services, and construction administration services. These services also include topographic surveys, easement field notes and sketches, environmental phase I and geological assessment investigations. The professional engineering services for the pump station improvements include preliminary design, final design, bidding services, construction administration services, and project coordination. These services also include a Power System Study consisting of coordination and review of existing electrical service, arc flash study and breaker settings study/coordination with electrical provider. 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: Consultant will require coordination from the City to capture locations of existing City owned utilities and easements within the project limits. Task Order No. KPA-22-002-TO, consisting of _____ pages. 20 Page 131 of 171 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 4.Times for Rendering Services Phase Completion Date Design WL - 6 Months, PS – 9 Months Bidding WL – 2 Month, PS – 2 Months Construction Administration WL - 10 Months, PS – 12 Months 5.Payments to Engineer A. Owner shall pay Engineer for services rendered as follows: Category of Services Compensation Method Lump Sum Amount of Compensation for Services Basic Services Project Management & Coordination, Preliminary Design, Final Design, Bidding, Construction Phase, Easements & Surveys. A.Lump Sum $1,133,525.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 Terracon Associates, Inc. – Austin, Texas All County Surveying – Temple, Texas McCreary & Associates – Dallas, Texas 7.Other Modifications to Agreement: None 8.Attachments: Exhibit A – Scope of Services Exhibit B – Fee Schedule 9.Documents Incorporated By Reference: The Agreement effective March 23, 2016. Page 132 of 171 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: 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 January 4, 2022 Page 133 of 171 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: Wesley Wright Name: Alvin R (Trae) Sutton III, P.E., CFM Title: Systems Engineering Director Title: Principal Address: 300-1 Industrial Ave. Georgetown, TX 78626 Address: 1008 South Main Street Georgetown, TX 78626 E-Mail Address: Wesley.Wright@georgetown.org E-Mail Address: TSutton@kpaengineers.com Phone: 512-931-7672 Phone: 512-819-9478 Fax: Fax: 254-733-6667 Page 134 of 171 EXHIBIT A – DETAILED PROJECT SCOPE SERVICES PROVIDED BY ENGINEER KASBERG, PATRICK & ASSOCIATES, LP GEORGETOWN, TEXAS Project Description: The FY 22 Water System Improvements Projects will consist of three (3) water line improvements and one (1) pump station upgrade. The proposed water line improvements include the SH 195 to Aviation Drive 16-inch Water Line Improvements, CR 262 12-inch Water Line Improvements, and the Carriage Oaks 16-inch and 24-inch Water Line Improvements. The proposed pump station improvements will be upgrading the pumps and electrical components at the Stonewall Ranch Pump Station. The SH 195 to Aviation Drive Water Line Improvement Project will include the installation of approximately 7,000 LF of a 16-inch Water line from the intersection of SH 195 & IH 35 and will extend south along IH 35 Frontage Road and will connect to the proposed Aviation Drive Extension at IH 35. This will also include the extension of a 12-inch water line from SH 195 at Berry Creek Drive west approximately 800 LF to the existing 12-inch water line termination point. The CR 262 Water Line Improvement Project will include the installation of approximately 10,400 LF of a 12-inch Water line from the intersection of CR 262 and Reef Lane and will extend south/southeast along CR 262 and terminate at the entrance of Russell Park. This project will also include a bore across FM 3405 near Woodland Hills Drive for a 12-inch water line to connect existing water line infrastructure to provide better service to the area. The Carriage Oaks Water Line Improvement Project will include the installation of approximately 6,250 LF of a 16-inch Water line from the Carriage Oaks EST located near the intersection of CR 200 and Palomino Place and will extend east along Palomino Place and will transition to a 24-inch water line at CR 214. The 24-inch water line will then continue south along CR 214 for approximately 6,000 LF and connect to the existing 20-inch water line just north of the CR 214 & Neal Drive Intersection. The professional engineering services for the water line improvements include project management/coordination, utility easement coordination, preliminary design, final design, bidding services, and construction administration services. These services also include topographic surveys, easement field notes and sketches, environmental phase I and geological assessment investigations. The Stonewall Ranch Booster Pump Station Improvements will expand the existing pump station from 2.5 million gallons per day (MGD) to approximately 4 MGD. The existing Pump Station has two (2) 250 HP horizontal split case pumps with a location for a third (3rd) pump. The new pump will be on a variable frequency drive. In addition to the pump addition, the improvements Page 135 of 171 will include the addition of a pump control valve, discharge pressure transmitter, and an emergency generator, replacement of the tank fill control valve and manhole and applicable electrical improvements to accommodate the new pump and generator. The professional engineering services for the pump station improvements include preliminary design, final design, bidding services, construction administration services, and project coordination. These services also include a Power System Study consisting of coordination and review of existing electrical service, arc flash study and breaker settings study/coordination with electrical provider. Scope of Services: The scope of services associated with the FY 22 Water Line Project includes: I. Project Management/Coordination a. The ENGINEER shall coordinate, conduct and document a Project Kickoff Meeting with City Staff. b. The ENGINEER shall attend 30%, 60%, 90% and 100% Project Submittal Meetings with City Staff. The ENGINEER shall review the submittal package with City Staff and provide written questions and or comments that may arise during the design process and review those with City Staff and provide recommendations, if required. These meetings may also include meeting with Landowners to review the proposed project alignment. Assume six (6) meetings shall be required. c. The ENGINEER shall provide Contract Management and Coordination. This shall include developing monthly invoices and progress reports, subconsultant coordination, design coordination with the City and design coordination with dry utilities. d. The ENGINEER shall obtain and review the existing data provided from the City and that have a direct impact of the proposed project. II. Utility Coordination/Easement Support a. The ENGINEER will research the current property ownership along the proposed route and provide a property ownership map and list of impacted property owners to the City for use in obtaining right of entry. b. The ENGINEER will provide project support in the form of project data, exhibits and information to the City’s assigned right-of-way agent. The ENGINEER will be available to attend meetings with impacted property owners to address questions and comments, if requested. c. The ENGINEER will provide project data, exhibits and information to the surveyor in support of preparation of a right-of-way map, metes and bounds documents and field sketches. The ENGINEER will review the field sketches and metes and bounds documents to verify document accuracy. Below is the number of proposed documents per project: Page 136 of 171 i. SH 195 to Aviation Drive Water Line Improvements – 12 Documents ii. CR 262 Water Line Improvements – 0 Documents iii. Carriage Oaks Water Line Improvements – 30 Documents d. The ENGINEER will provide project data, exhibits and information to the surveyor in support of preparation of a Temporary Construction Easement & Permanent City of Georgetown Water Utility Easement Map for the development of metes and bounds documents and field sketches. The ENGINEER will review the field sketches and metes and bounds documents to verify document accuracy. e. The ENGINEER shall develop a Utility Conflict Map detailing the approximate locations of the existing dry utilities and identify potential conflicts with impacted existing dry utilities. f. The ENGINEER shall coordinate, attend and document a Utility Coordination Meeting with the existing utilities located within the proposed corridor to discuss impacts this project on the existing utilities. The ENGINEER shall document the highlights of this meeting. Assume two (2) meetings shall be required. III. Preliminary Design a. Develop Proposed Alignment and Verify i. The ENGINEER will utilize the rights-of-way, easements and property map to develop the proposed alignment of the utilities. ii. The ENGINEER will walk the project route to identify alignment changes and obstacles. iii. The ENGINEER will verify the alignment to release design surveys to commence. b. Develop Project Layout with Connections i. The ENGINEER will utilize all gathered information to develop the proposed horizontal alignment layout. ii. The ENGINEER will develop connection to the existing City of Georgetown Water Utility. c. Review Alignment with City Staff i. The ENGINEER will coordinate and meet with City Staff to review the proposed alignment. All information discovered concerning existing dry utilities, obstacles, rights-of-way, easements and private property will be discussed. ii. The ENGINEER will develop a consensus with City Staff on the proposed alignment and adjust as agreed upon. d. Finalize the Alignment Page 137 of 171 i. The ENGINEER will utilize the Schematic Design, coordination meetings and consensus to finalize the utility locations for the project. ii. The ENGINEER will generate a revised map illustrating rights-of-way, dry utilities and the proposed utility infrastructure. e. Coordinate with Dry Utilities i. The ENGINEER will coordinate a meeting with all affected dry utilities and City Staff to discuss the proposed alignment and relocations, if any, of dry utilities. IV. Final Design a. Develop Survey Data into Surfaces i. The ENGINEER will develop from the field survey data, surfaces for the project to allow for integrated computer surface design. ii. The ENGINEER will incorporate City of Georgetown imagery into the field surveys and integrate the two as a model. b. Develop Plan and Profiles for the Water Utility i. The ENGINEER will utilize the surface model and the finalized alignment to develop plan and profile for the water utility. ii. The ENGINEER will produce 11”x17” sheets illustrating the location of the proposed water line improvements both horizontally and vertically. iii. The ENGINEER will illustrate all depth to existing ground over the centerline of the proposed waterline. iv. The ENGINEER will illustrate all obstacles, dry utilities, rights-of-way, existing easements, proposed easements and private property. v. The ENGINEER will illustrate all proposed slopes, elevations, locations and fittings for the water line utility. c. Develop Project Layout with Connections i. The ENGINEER will develop connection details for connection to the existing City of Georgetown Water Utility. d. Develop Erosion Control & Traffic Control Plan i. The ENGINEER will develop erosion control for the construction of the project. ii. The ENGINEER will prepare plan sheets illustrating locations and types of Temporary Best Management Practices for erosion control. These sheets will be available for use by the contractor in obtaining permits from the TCEQ for construction of the project. iii. The ENGINEER will develop a traffic control plan to be utilized for this project. e. Develop Project Details i. The ENGINEER will develop details for the project to include: Page 138 of 171 1. Water Line Details 2. Trench and Bedding Details 3. Erosion Control Details 4. Concrete Details 5. Traffic Control Details 6. Casing and Encasement Details 7. Misc. Details f. Design Roadway/Driveway Crossings i. The ENGINEER will locate areas where the proposed utilities will cross existing roadways and driveways for construction of the project. ii. The ENGINEER will determine, in conjunction and consensus with City Staff the method of crossing (open cut or bore). iii. The ENGINEER will develop plan sheets illustrating the proposed crossings. g. Design Connections i. The ENGINEER will determine locations and size of the existing water utility. This will be accomplished by field investigations, reviewing of record drawings and meetings with City Staff. ii. The ENGINEER will design connections for the 8-inch water line improvements to the existing water utility. iii. The ENGINEER will design connections for the service connections to residential and commercial customers. h. WPAP Exemption Submittal i. The ENGINEER shall prepare a Water Pollution Abatement Plan (WPAP) Exemption request for the Edwards Aquifer Recharge Zone and submit the proposed exemption to TCEQ for approval. i. Complete Plans and Specifications i. The ENGINEER will develop specifications for the project. ii. The ENGINEER will develop project quantities for all proposed bid items for the project. iii. The ENGINEER will review the plans and specifications that have been developed for quality assurance and quality control (QA/QC). iv. The ENGINEER will adjust the plans and specifications from the QA/QC. v. The ENGINEER will coordinate the plans and specifications. vi. The ENGINEER will develop General Notes for the Project and index sheet for the plans. vii. The ENGINEER will print all specifications and plans to be bound for submittal. Page 139 of 171 j. Review Plans with City Staff, Incorporate Comments and Prepare for Bidding i. The ENGINEER will schedule a meeting with City Staff to review the plans and specifications. 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 bidding documents to purchasing for comments. All comments will be addressed. iv. The ENGINEER will prepare documents for bidding and assist the City Staff in advertising the project. v. The ENGINEER will prepare a final Opinion of Probable Construction Cost. V. 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. VI. Construction Administration a. The ENGINEER will prepare contract documents; forward those to the contractor awarded the project by the Georgetown City Council. 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. Page 140 of 171 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. i. The ENGINEER will prepare a project closeout package that will include final record drawings, final pay estimate, final closeout change order and any other project closeout documentation. Scope of Services: The scope of services associated with the Southwest Stonewall Ranch Booster Pump Station Improvements Project includes: I. Schematic Design a. Survey & As-Built Existing Pump Station i. The ENGINEER will coordinate survey of exterior site to allow site layout and Generator location. ii. The ENGINEER will as-built the interior of the pump station, electrical room and fill tank manhole to allow base plans for modifications. b. Develop System Head Curve i. The ENGINEER will perform field tests to determine actual flow and pressure conditions for the discharge piping of the BPS. Page 141 of 171 ii. The ENGINEER will perform calculations, incorporating field data, to prepare a system head curve. iii. The ENGINEER will utilize the system head curve and existing pump curves to determine necessary sizing of proposed pump. c. Select Acceptable Pumps for Expansion i. The ENGINEER will meet with City Staff and determine acceptable pump manufacturers. ii. The ENGINEER will meet with the acceptable pump manufacturers to select pumps that meet the operating requirements developed above. iii. The ENGINEER will meet with City Staff to review pumps to be included in Final Design Specification d. Electrical Power Study i. The ENGINEER will coordinate with electrical service provider to determine necessary improvements to existing electrical service to accommodate improvements (additional pump and generator). ii. The ENGINEER will preliminarily size generator for expanded condition. iii. The ENGINEER will meet with City Staff and make recommendations for acceptable manufacturers for electrical and generator equipment (to be incorporated into specification during final design). iv. Review existing interconnections and insure existing control panel (valves) and VFDs are interconnected. v. Confirm HVAC system is sufficient for added VFD. e. Preliminarily Size and Determine Acceptable Equipment Manufacturers i. The ENGINEER will determine sizing of applicable valves and equipment and meet with City Staff to determine acceptable manufacturers. f. Finalize Layouts i. The ENGINEER will prepare preliminary plan sheets detailing layouts and necessary modifications/relocations for Owner review g. Chlorine Room Analysis i. The ENGINEER will review the existing chlorination room and recommend improvements related to the existing TCEQ Chapter 290 Regulations and Chlorine Institute best practices. The addition of forced air ventilation was noted on the site visit. This item will be an overall review. II. Final Design a. Develop Plan Sheets i. The ENGINEER will develop from the field survey data, plan sheets detailing the: 1. Pump Addition, Page 142 of 171 2. Suction and Discharge Piping Modifications 3. Electrical Room Modifications 4. Replacement of Fill Tank Valve and Manhole 5. Generator Addition 6. Electrical, Mechanical, Instrumentation and Controls improvements / modifications as necessary. 7. Chlorine Storage and Feed Modifications/Improvements. b. Develop Project Details i. The ENGINEER will develop details for the project to include: 1. Mechanical / Piping Details 2. Connect Details 3. Electrical Details 4. Manole/Pipe Bedding Details 5. Misc. Details c. Complete Plans and Specifications i. The ENGINEER will develop specifications for the project. ii. The ENGINEER will develop project quantities for all proposed bid items for the project. iii. The ENGINEER will review the plans and specifications that have been developed for quality assurance and quality control (QA/QC). iv. The ENGINEER will adjust the plans and specifications from the QA/QC. v. The ENGINEER will coordinate the plans and specifications. vi. The ENGINEER will develop General Notes for the Project and index sheet for the plans. vii. The ENGINEER will print all specifications and plans to be bound for submittal. d. TCEQ Submittal i. The ENGINEER shall prepare a cover letter and required documentation for the proposed project improvements and submit the documentation to TCEQ for approval. e. Review Plans with City Staff, Incorporate Comments and Prepare for Bidding i. The ENGINEER will schedule a meeting with City Staff to review the plans and specifications. 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 bidding documents to purchasing for comments. All comments will be addressed. iv. The ENGINEER will prepare documents for bidding and assist the City Staff in advertising the project. Page 143 of 171 v. The ENGINEER will prepare a final Opinion of Probable Construction Cost. III. 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. IV. Construction Administration a. The ENGINEER will prepare contract documents; forward those to the contractor awarded the project by the Georgetown City Council. 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. Page 144 of 171 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. i. The ENGINEER will prepare a project closeout package that will include final record drawings, final pay estimate, final closeout change order and any other project closeout documentation. j. The ENGIEER will conduct final Power System Study including: i. Arc Flash Study including coordination with the Contractor, ii. Confirm Breaker Settings Study including coordination with Contractor and Electrical Provider, iii. Model System in SKM – update to reflect actual electrical gear purchased and iv. Prepare Final Report and Permanent Labels, including startup assistance. Page 145 of 171 Kasberg, Patrick & Associates, Georgetown, Texas December 22, 2021 Bid Package FY 22 Water Sytem Improvements Proposed Professional Services Fee Opinion of Probable Construction Costs Total Project Cost 1 SH 195 to Aviation Drive Water Line Improvements 214,700.00$ 1,248,000.00$ 1,462,700.00$ 2 CR 262 Water Line Improvements 187,200.00$ 1,260,000.00$ 1,447,200.00$ 3 Carriage Oaks Water Line Improvements 430,800.00$ 2,500,000.00$ 2,930,800.00$ 4 Stonewall Ranch Booster Pump Station Improvements 300,825.00$ 2,000,000.00$ 2,300,825.00$ Total Project Costs 1,133,525.00$ 7,008,000.00$ 8,141,525.00$ Summary of Proposed Project Costs EXHIBIT B FEE SCHEDULE KPA FY 22 Water System Improvements Page 146 of 171 EXHIBIT B: FEE SCHEDULE KPA ACS ACS TERRACON TOTAL 1.PROJECT MANAGEMENT/COORDINATION 12,800.00$ 12,800.00$ 2.FINAL DESIGN 99,600.00$ 31,200.00$ 27,000.00$ 5,500.00$ 163,300.00$ 3.BIDDING 7,500.00$ 7,500.00$ 4.CONSTRUCTION ADMINISTRATION 31,100.00$ 31,100.00$ PROJECT TOTAL 151,000.00$ 31,200.00$ 27,000.00$ 5,500.00$ 214,700.00$ Subconsultants: Topographic Surveying - All County Surveying (ACS) Easement Documents - All County Surveying (ACS) Environmental (Geological Assessment) - Terracon COST SUMMARY Summary of Costs December 22, 2021 Summary of Professional Services Fee Estimate by Consultant SH 195 to Aviation Drive Water Line Improvements SUMMARY Page 2 of 5Page 147 of 171 EXHIBIT B: FEE SCHEDULE KPA ACS TERRACON TOTAL 1.PROJECT MANAGEMENT/COORDINATION 18,900.00$ 18,900.00$ 2.FINAL DESIGN 86,600.00$ 39,800.00$ 5,500.00$ 131,900.00$ 3.BIDDING 7,500.00$ 7,500.00$ 4.CONSTRUCTION ADMINISTRATION 28,900.00$ 28,900.00$ PROJECT TOTAL 141,900.00$ 39,800.00$ 5,500.00$ 187,200.00$ Subconsultants: Topographic Surveying - All County Surveying (ACS) Environmental (Geological Assessment) - Terracon CR 262 Water Line Improvements Summary of Professional Services Fee Estimate by Consultant December 22, 2021 COST SUMMARY Summary of Costs SUMMARY Page 3 of 5Page 148 of 171 EXHIBIT B: FEE SCHEDULE KPA ACS ACS TERRACON TOTAL 1.PROJECT MANAGEMENT/COORDINATION 33,600.00$ 33,600.00$ 2.FINAL DESIGN 217,400.00$ 46,500.00$ 67,500.00$ 5,500.00$ 336,900.00$ 3.BIDDING 7,500.00$ 7,500.00$ 4.CONSTRUCTION ADMINISTRATION 52,800.00$ 52,800.00$ PROJECT TOTAL 311,300.00$ 46,500.00$ 67,500.00$ 5,500.00$ 430,800.00$ Subconsultants: Topographic Surveying - All County Surveying (ACS) Easement Documents - All County Surveying (ACS) Environmental (Geological Assessment) - Terracon Carriage Oaks Water Line Improvements Summary of Professional Services Fee Estimate by Consultant December 22, 2021 COST SUMMARY Summary of Costs SUMMARY Page 4 of 5Page 149 of 171 EXHIBIT B: FEE SCHEDULE KPA McCreary TOTAL 1.PROJECT MANAGEMENT/COORDINATION 18,170.00$ 18,170.00$ 2.SCHEMATIC DESIGN 43,675.00$ 24,450.00$ 68,125.00$ 3.FINAL DESIGN 84,900.00$ 41,800.00$ 126,700.00$ 4.BIDDING 11,580.00$ 1,500.00$ 13,080.00$ 5.CONSTRUCTION ADMINISTRATION 61,750.00$ 13,000.00$ 74,750.00$ PROJECT TOTAL 220,075.00$ 80,750.00$ 300,825.00$ Subconsultants: Electrical (McCreary) Stonewall Ranch Booster Pump Station Improvements Summary of Professional Services Fee Estimate by Consultant December 22, 2021 COST SUMMARY Summary of Costs SUMMARY Page 1 of 1 Page 150 of 171 City of Georgetown, Texas Water Utility Board January 13, 2022 S UB J E C T: C onsideration and pos s ible rec o mmendatio n to ap p ro ve Tas k O rd er C DM-22-002 with C DM S mith, Inc. of Aus tin, Texas , fo r profes s ional s ervic es related to G eo rgeto wn Lake Water Treatment P lant Emergency P o wer S up p ly S ys tem P roject in the amount $760,000.00. -- Wes ley Wright, P.E., S ys tems Engineering Director / C hris P ous s on, C I P Manager IT E M S UMMARY: T his tas k order is for professional engineering services cons is ting of design, bidding, c onstruc tion, and s pecial s ervic es for the Lake Water Treatment P lant Emergenc y P ower S upply S ys tem. T he proposed emergency bac kup/standby power supply s ystem (EP S S ) will be c onstruc ted on the c urrent Lake W T P s ite. T he generator for the raw water pump station will also be loc ated on the W T P site and connec t to the pump station’s power from the W T P site. T he EP S S will provide the standby power required to s upport the continuity of the water treatment plant’s c apacity of 37.4 million gallons per day (MG D) production and s ervic e pumping during an extended utility power outage exc eeding 24 hours . It is as s umed up to s even (7) generators will be added at the Lake W T P to s upport the plant operations, on-s ite pump s tations, and the raw water pump station. T his is part of the F Y 2022 C apital Improvement S ystem R esiliency projec t. S TAF F R E C O MME N D AT IO N S: S taff recommends executing Task O rder C DM-22-002 with C DM S mith, Inc. for profes s ional s ervic es related to G eorgetown Lake Water Treatment P lant Emergenc y P ower S upply S ys tem P roject in the amount $760,000.00. F IN AN C IAL IMPAC T: F unds for this expenditure are available in the Water C I P Budget. S UB MIT T E D B Y: C hris P ousson, C I P Manager AT TAC H ME N T S: Description Type CDM-22-002 Backup Material Page 151 of 171 Page 152 of 171 Page 153 of 171 Page 154 of 171 Page 155 of 171 Page 156 of 171 Page 157 of 171 Page 158 of 171 Page 159 of 171 Page 160 of 171 Page 161 of 171 Page 162 of 171 Page 163 of 171 Page 164 of 171 Page 165 of 171 Page 166 of 171 Page 167 of 171 Page 168 of 171 Page 169 of 171 Page 170 of 171 Page 171 of 171