Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Agenda_GTEU_07.21.2022
Notice of Meeting for the Georgetown Electric Utility B oard of the City of Georgetown July 21, 2022 at 4:00 P M at Williamson Room at Georgetown Municipal Complex, 300-1 I ndustrial Av e, Georgetown T X 78626 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. The Ge orge town E lec tric Utility Advisor y B oar d is now mee ting in pe rson. A quor um of the B oard will be in attendance at the Williamson R oom at Ge orge town M unic ipal Complex, 300-1 Industr ial Ave, Geor getown T X 78626. It is possible that one or more boar d membe rs may atte nd via vide o Confe re nc e using the Zoom clie nt. 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 C all to O rder- R obert C as e; Board C hairman B Introduc tion of Visitors - R obert C ase; Board C hairman C P ublic Wis hing to Address the Board- R obert C ase; Board C hairman D R eview and Approval of Minutes from 06/16/2022 Meeting- Noah F ry; Board Liaison E G eneral Manager's Monthly R eport- Daniel Bethapudi; G eneral Manager of Electric Utility E xecutiv e Session In c omplianc e with the O pen Meetings Ac t, C hapter 551, G overnment C ode, Vernon's Texas C odes, Annotated, the items listed below will be dis cus s ed in c los ed session and are s ubjec t to action in the regular s es s ion. F S ec . 551.086 C ompetitive Matters P urchased P ower R eview S ec . 551.089 Deliberation R egarding S ec urity Devic es or S ecurity Audits C yber S ecurity U pdate Adjournment Ce rtificate of Posting Page 1 of 54 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 54 City of Georgetown, Texas Electric Utility Board July 21, 2022 S UB J E C T: R eview and Approval of Minutes from 06/16/2022 Meeting- Noah F ry; Board Liais on IT E M S UMMARY: F IN AN C IAL IMPAC T: N/A S UB MIT T E D B Y: Noah F ry- Board Lias ion AT TAC H ME N T S: Description Type 6.16 Minutes Backup Material Page 3 of 54 Minutes of the Meeting for the Georgetown Electric Utility Board Thursday, June 16th at 4:00 PM at the Community Room at Georgetown City Hall, 402 W. 8th St. Georgetown, TX 78626 Board Members Present: Robert Case - Chairman, Rick Woodruff- Vice-Chairman, Sam Jones- Secretary, Ben Butler, Mike Triggs Board Members Absent: None Staff Present: David Morgan, Daniel Bethapudi, Laurie Brewer, Leigh Wallace, Daniel McReynolds, Mike Westbrook, Elaine Wilson, Leticia Zavala, Cindy Pospisil, Richard Pajestka, Daniel Potter, Kress Carson and Noah Fry Public Attendees: None 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 -- Robert Case, Board Chairman • Meeting called to order at 4:00 pm by Case. B. Roll Call of Board Members -- Robert Case, Board Chairman • All Present C. Introduction of Visitors -- Robert Case, Board Chairman • Introduction of Noah Fry – New Electric Staff Member D. Public Wishing to Address the Board • None present E. Review and Approval of Minutes- Robert Case, Board Chairman • Minutes from 5/19/22 Meeting to reflect Jones and Woodruff as absent, not Butler and Woodruff on Voting Items E, F & G. • Triggs motions to amend May 19th Minutes • Jones Seconds • Passes unanimously – 5/19 Minutes Amended • Jones moves to Approve Minutes, Butler Seconds from 5/19 Meeting • Passes unanimously – Minutes from 5/19 Meeting approved Page 4 of 54 Regular Session (cont.) F. General Managers Monthly Report- Daniel Bethapudi- General Manager of Electric Utility • Customer Service and Billing- Leticia Zavala- Customer Care Director o 30,871 Available Services o 30,533 Electric customers/accounts, 125 estimated “bad meter reads” o 30,058 Billed Electric Meters o Compared billed meters from May ‘21 to May ‘22. Roughly the same. ▪ Bills reflect usage through April. o YTD electric bills for May ‘22 compared to May ‘21. ▪ Billing numbers slightly lower than last year due to a more mild Winter season. o Residential Customers Average 742kWh in May ’22 compared to 730kWh in May of ’21. ▪ Case adds that City of Georgetown is $.04-.07 below market for price per kWh. ▪ Bethapudi adds that March ’22 sales are about 7% higher than March of ’21 and we haven’t gotten into the hottest parts of the year yet. o Electric Revenue Breakdown and Receivables presented- roughly 61% of yearly budgeted amount collected o 44% of 3rd Quarter (Apr, May, June) billings collected o Aged receivables increased slightly. o Summer Disconnects for Non-Payment stopped around June 7th o COG has collected $283,537.47. Collection Agency has charged COG $55,234.72. Electric Operations Report- Mike Westbrook- Electric Operations Manager o Electric Reliability (SAIFI)- .281 o Electric Outage Duration (CAIDI)-67.467 minutes o Top 5 Outages Report ▪ Largest outage, affecting 174 customers, was a guy wire clipped by vehicle, guy wire got into primary wire, blowing fuse. o Storm/lightning on 5/5 affected 14 customers with avg duration of 99 minutes per customer in Gabriel/Rivery service area. o 2 significant outages on Monday, 6/13 and Tuesday, 6/14. ▪ 6/13 outage: 4:24pm, Rivery 90 locked out. 2300 customers out. Crews were dispatched and all 2300 customers were picked back up in 45 minutes. • Zavala adds this outage served as a test for new outage notification system and it worked very well, preventing COG from being inundated with customer calls. • 6/14 outage: Rivery 90 was isolated and Pedro Construction began work on feeder. Pedro Construction accidentally cut Page 5 of 54 into Rivery 80 (the good circuit), causing flash, injury to crew member, and 2900 customers out of power. Switching was done successfully. Westbrook comments on the quality of our air-break switches and capacity of our conductor to be able to maintain load. • Investigations will be completed. • Electric Employee Safety and Development Report- Danny Potter – Electric Safety and Employee Development Manager o 6/8 – Safety Down Day o Weekly safety meetings o Zero Safety Incidents for COG Personnel o Meter Apprentice Program Development – Northwest Lineman College, Certification through VA and DOL. o KPA Software – 100% Electric Safety Documentation has been moved to software. • Quarterly Financial Report- Leigh Wallace- Finance Director o FY22 revenue budget is $124 million, 69% is from electric sales charges, 16% is bond proceeds, 10% is developer contributions, 5% is other charges for services, and 1% is from non-rate fees and Renewable Energy Credits ▪ Operating and Non-Operating: revenues FY22 Q2 revenues compared to Q2 of FY21. ▪ Renewable Energy Credits (RECs) are not being reported under Fees within Operating Revenues. ▪ Electric Sales Charges at 42% for halfway through the fiscal year. ▪ Developer Contributions are at 222% of Budget. ▪ Sale of Property line is where RECs used to be located. • Transition of Fiber asset has progressed quicker than anticipated with IT being able to purchase from Electric using savings. • Bonds were sold in April and closed on in May. Proceeds to be reflected in 3rd quarter report. • Woodruff asks if Misc. Revenue is partly due to the sale of excess solar or wind. Westbrook answers with an example of billing contractors that damage our equipment or services. Wallace adds that Misc. Revenue is usually one-off items that do not fit anywhere else. • Electric Sales Charges through March ’22: 43% of budget, down 1% compared to same timeframe last FY. o FY22 expense budget is $115 million. ▪ T&D Services and Electric Engineering labor expenses are capitalized at year end. ▪ Purchase Power is within Resource Management – 54% variance from Q2 of FY21 due to Winter Storm Uri. ▪ Net Purchased Power – 66% of operating expenses. Net Purchase Power is down 63% from same period as last FY due to Winter Storm Uri. ▪ For FY22, the Electric Fund is at 53% of Net Purchase Power budget. • TEC Warehouse Update – Mike Westbrook o Material transfer to take place last week in June. o Project is moving along as anticipated Page 6 of 54 • Partner Software Implementation – Danny McReynolds o Map Viewer portion rolled out o Design/Staking portion – 3-day training completed. Anticipate roll out 1st week of August. o Workflow portion being tested over next several weeks. • Joint Use/Pole Attachment Updates – Kress Carson o Schneider Engineering is administering as of 5/6. o Updated Pole Attachment Fees being presented to Council on June 28th. o Exploring a live tracking system with which entities can track their pole attachments. G. Legislative Item: NewGen Amendment – Cost of Service Study – Daniel Bethapudi o Bethapudi provides updates to Cost of Service study. Notifies of Contract that will require a change order for an additional $35,615 from original $45,275. ▪ Butler requests clarification on if the scope of work was documented properly and if it was notated that the consultant would require a change order. Bethapudi advises that the scope of work was given to legal and was approved. ▪ Morgan adds that the Electric Board is an advisory board and that the change order consideration was provided as an informative update. ▪ Butler adds that, in the future, he’d like to see some sort of parameters set for how much a consultant can request in a change order, percentage wise. o Butler and Triggs move to approve NewGen Change Order, Vote Passes. o Bethapudi provides update on Net Metering Policy ▪ Many customers pursuing renewables, DERs, and battery storage. All of which are avenues with which the Utility cannot recover costs. ▪ There are (2) rate constructs that exist to address these issues. • Demand Charge for customers who use Utility as a backup during peak demand. • Fixed Charge – Example of New Braunfels charges DER customers $10 per kW. Page 7 of 54 Board moves into Executive Session at 5:04 PM Executive Session In compliance with the Open Meetings Act, Chapter 551, Government Code, Vernon's Texas Codes, Annotated, the items listed below will be discussed in closed session and are subject to action in the regular session. H. Section 551.086: Competitive Matters • Purchased Power Update • Cyber Security Updates • Butler excuses himself during Executive Session Board moves back into Regular Session at 5:30 PM. Adjournment MOTION by Triggs, seconded by Jones to adjourn the Board Meeting APPROVED 4-1 (Butler absent before adjournment) Electric Board Meeting Adjourned at 5:32 PM. Page 8 of 54 City of Georgetown, Texas Electric Utility Board July 21, 2022 S UB J E C T: G eneral Manager's Monthly R eport- Daniel Bethapudi; G eneral Manager of Elec tric Utility IT E M S UMMARY: Includes : C ustomer S ervice and Billing R eport- Letic ia Zavala- C us tomer S ervic e Direc tor Electric O perations R eport- Mike Wes tbrook- Elec tric O perations Manager Electric S afety and Employee Development R eport- Daniel P otter- Electric S afety and Employee Development Manager F inance R eport- Leigh Wallace- F inance Director P roject Updates C os t of S ervice S tudy Update F IN AN C IAL IMPAC T: N/A S UB MIT T E D B Y: Daniel Bethapudi-G eneral Manager of Electric Utility AT TAC H ME N T S: Description Type FY23 Budget Works hop - Electric Fund Cover Memo Electric Utility Board Presentation Pres entation Page 9 of 54 FY 2023 Budget Workshop ELECTRIC FUND The Electric Fund is used to account for the revenues and expenses of the City’s electric utility. This includes operating departments, purchased power costs, debt payments, and capital projects. The fund also transfers a Payment in Lieu of Taxes (PILOT) benefit to the General Fund, which represents the value the community receives for utility ownership. FISCAL YEAR 2022 Total operating revenues are projected to be $105.5 million, or 2% increase over the FY2022 budget. Electric Sales Revenues are projected to end the year on budget at $85.6 million. While usage and sales were flat for the first half of the year, the May and June hot and dry weather patterns drove increased usage by customers. Staff will continue monitoring projections for the third and fourth quarter, which so far have also been very hot and dry. Developer contributions are projected to end the year at $12 million, on pace with the amended budget. New development capital expense has increased significantly in FY2023, and line extensions fees have been adjusted to account for increased costs of materials and labor. Line extension application fees are now shown under permits. Renewable Energy Credit (REC) sales revenues are projected to be $2.75 million as the City continues to benefit from good pricing in this market. Electric Services FY2021 FY2022 Actuals Budget Projections Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget Operating Revenue 40002:Sales Taxes 5,863 5,000 5,000 - 100.00% 41002:Penalties 848,000 600,000 700,000 100,000 116.67% 42001:Interest Income 33,570 11,000 66,000 55,000 600.00% 43001:Fees 1,036,657 1,851,000 3,614,000 1,763,000 195.25% 43003:Permits - - 55,000 55,000 0.00% 43004:Administrative Charges 3,222,103 3,539,712 3,539,712 - 100.00% 43601:Electric Sales Charges 80,933,053 85,541,593 85,541,593 - 100.00% 44502:Developer Contributions 7,828,988 12,000,000 12,000,000 - 100.00% 70001:Transfers In 1,562,058 - - - 0.00% Operating Revenue Total 95,470,292 103,548,305 105,521,305 1,973,000 101.91% Operating Expense CC0001 Non-Departmental 6,609,740 6,963,362 6,963,362 - 100.00% CC0317 Purchasing 2,021 - - - 0.00% CC0521 Operational Technology 670,962 1,276,176 1,151,964 124,212 90.27% CC0522 Electric Administration 8,868,267 9,825,545 9,857,150 (31,604) 100.32% CC0523 Electric Safety and Employee Development - 268,825 368,935 (100,110) 137.24% CC0524 Metering Services 1,939,497 1,964,459 1,189,449 775,010 60.55% CC0525 T&D Services 4,185,597 1,975,555 2,180,115 (204,560) 110.35% CC0537 Electric Resource Management 110,515,572 55,493,445 55,493,445 (0) 100.00% CC0555 Electric Systems Operations 1,579,253 1,926,520 1,841,136 85,384 95.57% CC0557 Electrical Engineering 1,070,057 644,339 1,107,635 (463,296) 171.90% Operating Expense Total 135,440,965 80,338,226 80,153,190 185,036 99.77% 61Page 10 of 54 FY 2023 Budget Workshop Total operating expenses are projected to be $80.1 million which is slightly under the budget of $80.3 million. The largest expense in operations is purchased power, which is projected to be at budget for the year. However, as the hot summer progresses, staff may adjust this projection. Curtailment costs have been higher than previous years and the City is investigating the causes behind the curtailment. Hedging in the winter months mitigates risk, but increases costs. Net purchased power includes curtailment related expenses, congestion revenue rights, and renewable energy credits under non-operating revenue. The operational cost centers are generally projected to end the year on budget. Transmission and Distribution and Electrical Engineering cost centers budget the full cost of labor in operations, and at fiscal year end, an accounting entry capitalizes the costs of labor attributed to capital improvement projects. Several cost centers were re-organized during FY2022 for operational efficiency and effectiveness. This slightly skews comparisons to the prior year and should normalize in FY2023. Once the utility completes the transition to outsource warehouse operations during the summer of 2022, an estimated $200,000 expense is included to write off obsolete inventory. Total non-operating revenue is $20.2 million for FY2022. This includes $19.5 million in bond proceeds for capital projects and vehicles, $200K from miscellaneous project related billings, and $352K in cost reimbursement (grant revenue) for a TXDOT project. The $665K budget for Sale of Property represents the third of four installments to transfer the City’s Fiber asset from the Electric Fund to the IT Fund. Using one-time savings from FY2021, the IT Department was able to complete both the third and fourth installments of the asset transfer in FY2022. These transactions will show on the balance sheet at the end of the fiscal year. Electric Services FY2021 FY2022 Actuals Budget Projections Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget Non-Operating Revenue 45001:Misc Revenue 523,214 35,000 200,000 165,000 571.43% 45003:Misc Reimbursements - - 750 750 0.00% 45004:Sale of Property 4,127,598 665,840 52,330 (613,510) 7.86% 44001:Grant Revenue - - 352,313 352,313 0.00% 46001:Bond Proceeds 54,065,000 19,461,500 17,995,000 (1,466,500) 92.46% 46002:Bond Premium 652,424 - 1,644,538 1,644,538 0.00% Non-Operating Revenue Total 59,368,236 20,162,340 20,244,931 82,591 100.41% Non-Operating Expense CC0001 Non-Departmental 4,298,971 10,097,271 10,097,271 0 100.00% CC0557 Electrical Engineering 3,386,145 25,026,230 25,026,230 - 100.00% Non-Operating Expense Total 7,685,116 35,123,501 35,123,501 0 100.00% Total non-operating expenses are projected to be $35.1 million. The $25 million in capital project expenses include capitalized labor and equipment expenses, as well as all materials. Debt service represents $10.1 million of the total, a little under half of which is for the debt-financed energy costs of Winter Storm Uri, and the remainder is for infrastructure and vehicles. 62Page 11 of 54 FY 2023 Budget Workshop Total fund balance is projected to be $50.2 million as of September 30, 2022. The 90 day operational contingency reserve is projected to be $6.4 million at year-end while the rate stabilization reserve is projected at $18.6 million, and the non-operating contingency is projected to be $8.9 million. $4.0 million of proceeds from the 2020 sale of the transformers is reserved to pay the existing debt on the assets. While ending fund balance has significantly increased in the past three years, several current circumstances should be noted. The electric utility is still in the process of completing a thorough cost of service study with a consultant. As load increases with population growth and industrial development, the costs of purchased power will also increase. In turn, the rate stabilization reserve will need to increase. Operating and non-operating reserves will also need to increase. Additionally, Shell Energy and the City are renegotiating the Qualified Scheduling Entity contract. The City will be directly responsible for collateral to participate in the ERCOT market. Cash reserves may be necessary to perform this function. All of these recommendations will be reviewed with the Electric Board and Council once the studies, models and contracts are completed. FISCAL YEAR 2023 Total operating revenues are budgeted to be $103.4 million. Electric sales revenue is budgeted to increase due to commercial and residential customer growth. Industrial load growth through approved economic development agreements has been conservatively estimated. Renewable Energy Credits are budgeted at $1.2 million. Developer Contributions are conservatively estimated at $6 million. Administrative Charges have increased to $3.5 million because of a reorganization of shared services between Water and Electric Utilities, and increases to the base and enhanced budgets of the shared services. 63Page 12 of 54 FY 2023 Budget Workshop The Electric utility and Customer Care staff have worked with the cost of service study consultants to review the non-rate fees for various services. These fees have not been reviewed in recent years and need to be updated for increased costs of labor and materials. The preliminary estimated incremental revenue from the increased fees is $500,000 annually. (This incremental increase is not shown in the fund yet. Staff are reviewing these fee increases with Council on July 12.) Total operating expenses are $87.5 million with proposed service level enhancements. Net purchased power costs, including curtailment, are expected to be $59.9 million. The amount of labor budgeted to be capitalized in T&D and Electrical Engineering is $4.7 million. Base budget increases include merit, market, health and retirement personnel costs. The budget includes replacement vehicles, as well as a $5.5 million transfer to the General Fund for PILOT. This continues to be a capped amount under policy to assist the Electric Fund with increasing fund balance. The City completed an outside review of the cost allocation methods for shared services such as Finance, City Secretary, and Human Resources. The results of the study shift costs away from the Electric Services FY2021 FY2022 FY2023 Actuals Budget Projections Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget Base Budget Changes Proposed Budget Variance Fav/(Unfav): FY2023 Budget to FY202 Projections %Variance Fav/(Unfav): FY2023 Budget to FY202 Projections Operating Revenue 40002:Sales Taxes 5,863 5,000 5,000 - 100.00% 5,500 - 5,500 500 110.00% 41002:Penalties 848,000 600,000 700,000 100,000 116.67% 630,000 - 630,000 (70,000) 90.00% 42001:Interest Income 33,570 11,000 66,000 55,000 600.00% 45,000 - 45,000 (21,000) 68.18% 43001:Fees 1,036,657 1,851,000 3,614,000 1,763,000 195.25% 2,448,000 - 2,448,000 (1,166,000) 67.74% 43003:Permits - - 55,000 55,000 0.00% 50,000 - 50,000 (5,000) 90.91% 43004:Administrative Charges 3,222,103 3,539,712 3,539,712 - 100.00% 3,510,104 - 3,510,104 (29,608) 99.16% 43601:Electric Sales Charges 80,933,053 85,541,593 85,541,593 - 100.00% 90,511,753 - 90,511,753 4,970,160 105.81% 44502:Developer Contributions 7,828,988 12,000,000 12,000,000 - 100.00% 6,000,000 - 6,000,000 (6,000,000) 50.00% 70001:Transfers In 1,562,058 - - - 0.00% - - - - 0.00% Operating Revenue Total 95,470,292 103,548,305 105,521,305 1,973,000 101.91% 103,200,357 - 103,200,357 (2,320,948) 97.80% Operating Expense CC0001 Non- Departmental 6,609,740 6,963,362 6,963,362 - 100.00% 7,991,940 130,500 8,122,440 1,159,078 116.65% CC0317 Purchasing 2,021 - - - 0.00% - - - - 0.00% CC0521 Operational Technology 670,962 1,276,176 1,151,964 124,212 90.27% 2,347,368 198,898 2,546,266 1,394,301 221.04% CC0522 Electric Administration 8,868,267 9,825,545 9,857,150 (31,604) 100.32% 10,580,773 111,467 10,692,239 835,090 108.47% CC0523 Electric Safety and Employee Development - 268,825 368,935 (100,110) 137.24% 546,932 - 546,932 177,997 148.25% CC0524 Metering Services 1,939,497 1,964,459 1,189,449 775,010 60.55% - - - (1,189,449) 0.00% CC0525 T&D Services 4,185,597 1,975,555 2,180,115 (204,560) 110.35% 2,069,649 118,664 2,188,312 8,197 100.38% CC0537 Electric Resource Management 110,515,572 55,493,445 55,493,445 (0) 100.00% 59,900,000 - 59,900,000 4,406,555 107.94% CC0555 Electric Systems Operations 1,579,253 1,926,520 1,841,136 85,384 95.57% 1,964,999 195,887 2,160,885 319,749 117.37% CC0557 Electrical Engineering 1,070,057 644,339 1,107,635 (463,296) 171.90% 1,349,943 18,000 1,367,943 260,308 123.50% Operating Expense Total 135,440,965 80,338,226 80,153,190 185,036 99.77% 86,751,602 773,415 87,525,017 7,371,827 109.20% 64Page 13 of 54 FY 2023 Budget Workshop Water and Electric Utilities, and toward the General Fund. Due to economic pressure in the General Fund, this new allocation methodology will be implemented over two fiscal years. Additionally, the costs of shared services have increased for personnel compensation and other inflationary costs, as well as for the one-time upgrade of the utility customer billing software system. The net effect to the Electric Fund is an increase in contributions for shared services. The budget includes a re- organization of metering functions from the Electric utility to Customer Care. Electric Services FY2021 FY2022 FY2023 Actuals Budget Projections Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget Base Budget Changes Proposed Budget Variance Fav/(Unfav): FY2023 Budget to FY2022 Projections %Variance Fav/(Unfav): FY2023 Budget to FY2022 Projections Non-Operating Revenue 45001:Misc Revenue 523,214 35,000 200,000 165,000 571.43% 36,750 - 36,750 (163,250) 18.38% 45003:Misc Reimbursements - - 750 750 0.00% - - - (750) 0.00% 45004:Sale of Property 4,127,598 665,840 52,330 (613,510) 7.86% - - - (52,330) 0.00% 44001:Grant Revenue - - 352,313 352,313 0.00% - - - (352,313) 0.00% 46001:Bond Proceeds 54,065,000 19,461,500 17,995,000 (1,466,500) 92.46% 9,856,455 - 9,856,455 (8,138,545) 54.77% 46002:Bond Premium 652,424 - 1,644,538 1,644,538 0.00% - - - (1,644,538) 0.00% Non-Operating Revenue Total 59,368,236 20,162,340 20,244,931 82,591 100.41% 9,893,205 - 9,893,205 (10,351,726) 48.87% Non-Operating Expense CC0001 Non- Departmental 4,298,971 10,097,271 10,097,271 0 100.00% 11,200,191 - 11,200,191 1,102,920 110.92% CC0557 Electrical Engineering 3,386,145 25,026,230 25,026,230 - 100.00% 11,900,000 - 11,900,000 (13,126,230) 47.55% Non-Operating Expense Total 7,685,116 35,123,501 35,123,501 0 100.00% 23,100,191 - 23,100,191 (12,023,309) 65.77% Total non-operating revenues are budgeted at $9.9 million. The majority of this revenue is from bond proceeds for capital projects and vehicles. Total non-operating expenses are budgeted to be $23.1 million, a decrease of 34% relative to FY2022 projections due to the timing of capital projects. These are comprised of $11.9 million in capital projects related to electric system growth and enhancements. $11.2 million is for debt payments. Proposed service level enhancements include programing to meet the business needs for the utility. These include: Operational Technology: SCADA Analyst: Current Supervisory Control and Data Acquisition (SCADA) personnel have skills pre-dominantly water and wastewater focused. The electric operations work plan includes distribution automation which requires SCADA personnel with an electric distribution focus. Additionally, a SCADA Analyst is necessary to facilitate the impending SCADA upgrade and needs assessment. Proposed Ongoing: $142,133 65Page 14 of 54 FY 2023 Budget Workshop Proposed One-time: $3,000 Proposed Total Cost: $145,133 Operational Technology: Data Plans and Network Supplies: With the recent re- organization involving Meter Services and Operational Technology, the costs associated with AMI field network data plans are now being budgeted in the Operational Technology cost center. Proposed Ongoing: $12,500 Proposed One-time: $0 Proposed Total Cost: $12,500 Operational Technology: Network Supplies: Based on the initial assessment of the Operational Technology network, immediate network updates are required. This request is to provide funding necessary to maintain and routinely upgrade the network at a satisfactory level. Proposed Ongoing: $20,500 Proposed One-time: $0 Proposed Total Cost: $20,500 Operational Technology: Shared Vehicle: As the Operational Technology cost center continues to increase in number of employees, a vehicle is necessary to ensure repairs and maintenance of field equipment occurs in a timely manner. Proposed Ongoing: $5,800 Proposed One-time: $40,000 Proposed Total Cost: $45,800 Operational Technology: Cybersecurity Assessment, Network Enhancements, and Upgrades: The new Operational Technology personnel are developing a plan to enhance the department’s cyber security posture and preparedness. The effort will require additional consulting engagements and upgrades. This request is for funding necessary to the department to ensure cyber security is in an optimal position. Proposed Ongoing: $22,500 Proposed One-time: $0 Proposed Total Cost: $22,500 Electric Administration: Administrative Assistant: Lack of adequate administrative support has become a pain point for the Electric department. This request is to provide funding for an Administrative Assistant position to join existing personnel in Electric Administration and provide critical public meeting, financial system, and other support to all cost centers in the Electric department. Proposed Ongoing: $74,867 Proposed One-time: $3,000 66Page 15 of 54 FY 2023 Budget Workshop Proposed Total Cost: $77,867 Electric Administration: Employee Recognition: After going through Gallup employee engagement and action planning sessions with all employees in the Electric department, one consistent area found in need of improvement was employee recognition and communication. This request will provide funding necessary to respond to employee feedback. Proposed Ongoing: $36,600 Proposed One-time: $0 Proposed Total Cost: $36,600 T&D Services: Metering Technician: Due to the recent re-organization involving meter services, the current meter tech personnel have taken on the responsibility of installing new residential and Commercial and Industrial (C&I) meters, troubleshooting electric meter issues, Distributed Energy Resources (DER) inspections and electric meter audits. This increased workload along with customer growth, particularly in the C&I customer classes and DER installs, warrant the addition of a new FTE resource. Proposed Ongoing: $116,864 Proposed One-time: $44,800 Proposed Total Cost: $161,664 Electric Systems Operations: Senior Utility Systems Operator: With the addition of a Utility Systems Operator, the group can now have a total of five shifts each with two Operators. This allows for a training shift and alleviates excess workload of current Operators. Proposed Ongoing: $90,349 Proposed One-time: $3,000 Proposed Total Cost: $93,349 Electric Systems Operations: Utility Systems Locator: As the City continues to grow, so does the ticket numbers and the area of coverage Electric Systems Operations is responsible for. An additional Locator will provide critical support on system growth and ensure tickets are completed in a timely manner. Proposed Ongoing: $82,538 Proposed One-time: $61,500 Proposed Total Cost: $144,038 Electrical Engineering: ANB Systems: In FY 2022 the department implemented a software platform for DER application and permitting. The annual software maintenance cost is $6,500. The department will also be implementing line extensions application and pole attachment application modules to this platform. The implementation cost is $5,000 for each of these modules. Proposed Ongoing: $18,000 67Page 16 of 54 FY 2023 Budget Workshop Proposed One-time: $0 Proposed Total Cost: $18,000 Total fund balance is budgeted to be $53 million by September 30, 2023. This balance meets the 90-day operating contingency reserve of $7.5 million. It also reserves $25.6 million for rate stabilization for purchased power, a $7 million increase over the prior year. The non-operating reserve is $9.6 million. The bond proceed reserve to pay the remaining debt on the 2020 sale of transformers is $4 million. 68Page 17 of 54 FY 2023 Budget Workshop Fund Schedule Electric Services FY2021 FY2022 FY2023 Actuals Amended Budget Projected Base Budget Changes Proposed Budget Beginning Fund Balance 28,020,533 39,711,400 39,711,400 50,200,945 - 50,200,945 Operating Revenue 40002:Sales Taxes 5,863 5,000 5,000 5,500 - 5,500 41002:Penalties 848,000 600,000 700,000 630,000 - 630,000 42001:Interest Income 33,570 11,000 66,000 45,000 - 45,000 43001:Fees 1,036,657 1,851,000 3,614,000 2,448,000 - 2,448,000 43003:Permits - - 55,000 50,000 - 50,000 43004:Administrative Charges 3,222,103 3,539,712 3,539,712 3,510,104 - 3,510,104 43601:Electric Sales Revenue 80,933,053 85,541,593 85,541,593 90,511,753 - 90,511,753 44502:Developer Contributions 7,828,988 12,000,000 12,000,000 6,000,000 - 6,000,000 70001:Transfers In 1,562,058 - - - - - Operating Revenue Total 95,470,292 103,548,305 105,521,305 103,200,357 - 103,200,357 Operating Expense CC0001 Non-Departmental 6,609,740 6,963,362 6,963,362 7,991,940 130,500 8,122,440 CC0317 Purchasing 2,021 - - - - - CC0521 Operational Technology 670,962 1,276,176 1,151,964 2,347,368 198,898 2,546,266 CC0522 Electric Administration 8,868,267 9,825,545 9,857,150 10,580,773 111,467 10,692,239 CC0523 Electric Safety and Employee Development - 268,825 368,935 546,932 - 546,932 CC0524 Metering Services 1,939,497 1,964,459 1,189,449 - - - CC0525 T&D Services 4,185,597 1,975,555 2,180,115 2,069,649 118,664 2,188,312 CC0537 Electric Resource Management 110,515,572 55,493,445 55,493,445 59,900,000 - 59,900,000 CC0555 Electric Systems Operations 1,579,253 1,926,520 1,841,136 1,964,999 195,887 2,160,885 CC0557 Electrical Engineering 1,070,057 644,339 1,107,635 1,349,943 18,000 1,367,943 Operating Expense Total 135,440,965 80,338,226 80,153,190 86,751,602 773,415 87,525,017 Available Operating Fund Balance (11,950,140) 62,921,479 65,079,515 66,649,700 (773,415) 65,876,285 Non-Operating Revenue 44001:Grant Revenue - - 352,313 - - - 45001:Misc Revenue 523,214 35,000 200,000 36,750 - 36,750 45003:Misc Reimbursements - - 750 - - - 45004:Sale of Property 4,127,598 665,840 52,330 - - - 46001:Bond Proceeds 54,065,000 19,461,500 17,995,000 9,856,455 - 9,856,455 46002:Bond Premium 652,424 - 1,644,538 - - - Non-Operating Revenue Total 59,368,236 20,162,340 20,244,931 9,893,205 - 9,893,205 Non-Operating Expense CC0001 Non-Departmental 4,298,971 10,097,271 10,097,271 11,200,191 - 11,200,191 CC0557 Electrical Engineering 3,386,145 25,026,230 25,026,230 11,900,000 - 11,900,000 Non-Operating Expense 7,685,116 35,123,501 35,123,501 23,100,191 - 23,100,191 Ending Fund Balance 39,732,980 47,960,318 50,200,945 53,442,713 (773,415) 52,669,298 Reserves AFR Adjustment (21,580) - - - - - Market 115,000 115,000 Operating Contingency Reserve 4,018,754 6,426,561 6,426,561 7,349,932 193,402 7,543,334 Rate Stabilization Reserve 18,600,000 18,600,000 18,600,000 18,600,000 7,000,000 25,600,000 Non-Operating Reserve 3,486,903 8,930,396 8,930,396 8,339,313 1,233,428 9,572,741 Transformer Reserve 4,448,314 4,069,154 4,069,154 4,069,154 - 4,069,154 Reserves Total 30,532,391 38,026,111 38,026,111 38,358,399 8,426,830 46,900,229 Available Fund Balance 9,157,429 9,934,207 12,174,834 15,084,314 (9,200,245) 5,769,069 69Page 18 of 54 FY 2023 Budget Workshop Electric Services: City of Georgetown FY2020 FY2021 ACTUALS ACTUALS AMENDED BUDGET PROJECTIONS %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget BASE BUDGET CHANGES PROPOSED BUDGET %Variance Fav/(Unfav): FY2023 Budget to FY2022 Projections REVENUE 40002:Sales Taxes 7,358 5,863 5,000 5,000 100.00%5,500 - 5,500 10.00% 41002:Penalties 529,508 848,000 600,000 700,000 116.67%630,000 - 630,000 -10.00% 42001:Interest Income 10,703 33,570 11,000 66,000 600.00%45,000 - 45,000 -31.82% 43001:Fees 614,274 1,036,657 1,851,000 3,614,000 195.25%2,448,000 - 2,448,000 -32.26% 43003:Permits - - - 55,000 0.00%50,000 - 50,000 -9.09% 43004:Administrative Charges 3,192,618 3,222,103 3,539,712 3,539,712 100.00%3,510,104 - 3,510,104 -0.84% 43601:Electric Charges 85,733,316 80,933,053 85,541,593 85,541,593 100.00%90,511,753 - 90,511,753 5.81% 44001:Grant Revenue 1,860 - - 352,313 0.00%- - - -100.00% 44502:Developer Contributions 4,476,298 7,828,988 12,000,000 12,000,000 100.00%6,000,000 - 6,000,000 -50.00% 45001:Misc Revenue 195,508 523,214 35,000 200,000 571.43%36,750 - 36,750 -81.63% 45003:Misc Reimbursements - - - 750 0.00%- - - -100.00% 45004:Sale of Property 10,813,949 4,127,598 665,840 52,330 7.86%- - - -100.00% 46001:Bond Proceeds 5,055,000 54,065,000 19,461,500 17,995,000 92.46%9,856,455 - 9,856,455 -45.23% 46002:Bond Premium - 652,424 - 1,644,538 0.00%- - - -100.00% 70001:Transfers In 500,000 1,562,058 - - 0.00%- - - 0.00% REVENUE TOTAL 111,130,393 154,838,528 123,710,645 125,766,236 101.66%113,093,562 - 113,093,562 -10.08% FY2022 FY2023 70Page 19 of 54 FY 2023 Budget Workshop Electric Services: CC0001 Non-Departmental FY2020 FY2021 ACTUALS ACTUALS AMENDED BUDGET PROJECTIONS %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget BASE BUDGET CHANGES PROPOSED BUDGET %Variance Fav/(Unfav): FY2023 Budget to FY2022 Projections PERSONNEL OPERATIONS 52501:Office Supplies 1,957 - - - 0.00%- - - 0.00% 52510:Bad Debt Expense - 1,263,669 1,089,862 1,089,862 100.00%1,250,000 - 1,250,000 14.69% OPERATIONS TOTAL 1,957 1,263,669 1,089,862 1,089,862 100.00%1,250,000 - 1,250,000 14.69% OPERATING CAPITAL CIP EXPENSE DEBT SERVICE 55001:Principal Reduction 2,693,612 2,831,509 7,289,826 7,289,826 100.00%7,963,295 - 7,963,295 9.24% 55002:Interest Expense 1,181,242 1,205,823 2,450,465 2,450,465 100.00%3,037,018 - 3,037,018 23.94% 55003:Handling Fees 2,750 2,750 2,750 2,750 100.00%2,750 - 2,750 0.00% 55004:Bond Issuance Costs 46,500 258,888 354,230 354,230 100.00%197,129 - 197,129 -44.35% DEBT SERVICE TOTAL 3,924,104 4,298,971 10,097,271 10,097,271 100.00%11,200,191 - 11,200,191 10.92% TRANSFERS 80001:Transfers Out 329,792 846,071 1,073,500 1,073,500 100.00%1,241,940 130,500 1,372,440 27.85% 80002:Transfers Out - ROI 4,500,000 4,500,000 4,800,000 4,800,000 100.00%5,500,000 - 5,500,000 14.58% TRANSFERS TOTAL 4,829,792 5,346,071 5,873,500 5,873,500 100.00%6,741,940 130,500 6,872,440 17.01% CC0001 Non-Departmental Total 8,755,853 10,908,710 17,060,633 17,060,633 100.00%19,192,131 130,500 19,322,631 13.26% FY2022 FY2023 71Page 20 of 54 FY 2023 Budget Workshop Electric Services: CC0521 Operational Technology FY2020 FY2021 ACTUALS ACTUALS AMENDED BUDGET PROJECTIONS %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget BASE BUDGET CHANGES PROPOSED BUDGET %Variance Fav/(Unfav): FY2023 Budget to FY2022 Projections PERSONNEL 50100:Salaries 332,137 298,544 647,893 562,825 86.87%979,679 94,702 1,074,382 90.89% 50200:Payroll Tax Expense 24,943 22,140 55,176 42,727 77.44%75,088 7,245 82,332 92.70% 50201:Worker's Compensation 2,723 462 3,069 2,677 87.23%5,275 106 5,381 100.98% 50202:TWC Expense 873 1,008 1,764 756 42.86%2,772 252 3,024 300.00% 50300:Benefits 55,743 50,130 94,286 79,093 83.89%158,691 13,155 171,846 117.27% 50301:TMRS Expense 41,931 37,773 80,940 70,694 87.34%123,674 11,838 135,512 91.69% PERSONNEL TOTAL 458,349 410,056 883,127 758,772 85.92%1,345,179 127,298 1,472,477 94.06% OPERATIONS 51001:Administrative Expense 56,474 187,278 231,978 231,978 100.00%253,036 5,800 258,836 11.58% 51004:Contractual Services - 26,466 26,466 26,466 100.00%18,000 22,500 40,500 53.03% 51006:Subscriptions 25,609 (884) 741 884 119.30%30,200 - 30,200 3316.29% 51007:Contracts & Leases 6,370 - - - 0.00%5,600 - 5,600 0.00% 51009:Telephone 3,279 1,054 3,024 3,024 100.00%52,615 12,500 65,115 2053.27% 51340:Employee Recognition - - - - 0.00%2,500 - 2,500 0.00% 52501:Office Supplies 2,996 772 3,000 3,000 100.00%3,390 - 3,390 13.00% 52506:Operational Supplies 3,058 4,514 8,090 8,090 100.00%72,156 20,500 92,656 1045.35% 52509:Maintenance Expense 54,780 35,113 90,000 90,000 100.00%527,000 9,300 536,300 495.89% 53002:Postage & Freight - - - - 0.00%750 - 750 0.00% 53003:Food - 150 500 500 100.00%3,332 - 3,332 566.40% 53010:Uniform Expense 2,526 649 3,250 3,250 100.00%5,060 - 5,060 55.69% 53016:Travel Expense 2,264 594 3,000 3,000 100.00%6,550 - 6,550 118.33% 53017:Training Expense - 5,200 23,000 23,000 100.00%22,000 1,000 23,000 0.00% OPERATIONS TOTAL 157,356 260,905 393,049 393,192 100.04%1,002,189 71,600 1,073,789 173.10% OPERATING CAPITAL 60004:Capital Outlay - Equipment 4,166 - - - 0.00%- - - 0.00% OPERATING CAPITAL TOTAL 4,166 - - - 0.00%- - - 0.00% CIP EXPENSE DEBT SERVICE TRANSFERS CC0521 Operational Technology Total 619,871 670,962 1,276,176 1,151,964 90.27%2,347,368 198,898 2,546,266 121.04% FY2022 FY2023 72Page 21 of 54 FY 2023 Budget Workshop Electric Services: CC0522 Electric Administration FY2020 FY2021 ACTUALS ACTUALS AMENDED BUDGET PROJECTIONS %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget BASE BUDGET CHANGES PROPOSED BUDGET %Variance Fav/(Unfav): FY2023 Budget to FY2022 Projections PERSONNEL 50100:Salaries 295,709 476,630 347,721 559,978 161.04%483,020 50,274 533,294 -4.77% 50200:Payroll Tax Expense 20,763 31,706 37,417 38,222 102.15%40,727 3,846 44,573 16.62% 50201:Worker's Compensation 236 88 540 525 97.12%708 56 764 45.56% 50202:TWC Expense 505 1,296 1,008 1,008 100.00%1,260 252 1,512 50.00% 50300:Benefits 18,759 50,949 61,638 55,349 89.80%67,550 13,155 80,705 45.81% 50301:TMRS Expense 36,519 60,331 68,433 70,636 103.22%79,897 6,284 86,181 22.01% PERSONNEL TOTAL 372,490 620,999 516,758 725,718 140.44%673,162 73,867 747,028 2.94% OPERATIONS 51001:Administrative Expense 6,428,558 5,851,209 6,028,563 6,028,563 100.00%6,767,165 - 6,767,165 12.25% 51004:Contractual Services 40,475 70,176 - 184 0.00%- - - -100.00% 51005:Professional Services 4,000 4,000 - 4,000 0.00%4,000 - 4,000 0.00% 51006:Subscriptions 59,303 60,674 60,000 60,000 100.00%61,800 - 61,800 3.00% 51008:Utilities 95,256 29,894 43,200 52,500 121.53%43,200 - 43,200 -17.71% 51009:Telephone 511 240 11,355 11,355 100.00%11,696 - 11,696 3.00% 51010:Legal Services 639,066 453,222 1,100,000 1,100,000 100.00%1,133,000 - 1,133,000 3.00% 51340:Employee Recognition - 875 - 771 0.00%- 36,600 36,600 4647.08% 52501:Office Supplies 3,186 2,919 4,000 4,000 100.00%4,120 - 4,120 3.00% 52502:Educational Supplies - - - 161 0.00%- - - -100.00% 52506:Operational Supplies 931 322 - 407 0.00%- - - -100.00% 52507:Janitorial Supplies 260 945 - - 0.00%- - - 0.00% 52508:Utility Meters (450) - - - 0.00%- - - 0.00% 52509:Maintenance Expense 2,094 - - - 0.00%- - - 0.00% 53001:Public Notices & Recording Fees 90 125 - - 0.00%- - - 0.00% 53002:Postage & Freight 384 36 1,000 1,000 100.00%1,030 - 1,030 3.00% 53003:Food 2,007 4,363 7,800 7,800 100.00%8,800 - 8,800 12.82% 53010:Uniform Expense - 459 2,800 2,800 100.00%1,800 - 1,800 -35.71% 53012:Franchise Fee Expense 1,769,537 1,765,381 2,023,198 1,800,000 88.97%1,850,000 - 1,850,000 2.78% 53015:Other Miscellaneous Expense - - - 4,244 0.00%- - - -100.00% 53016:Travel Expense 44 730 3,000 3,000 100.00%9,000 - 9,000 200.00% 53017:Training Expense 1,605 1,700 23,872 23,872 100.00%12,000 1,000 13,000 -45.54% OPERATIONS TOTAL 9,046,856 8,247,269 9,308,788 9,104,657 97.81%9,907,611 37,600 9,945,211 9.23% OPERATING CAPITAL 60010:Capital Outlay - - - 26,775 0.00%- - - -100.00% OPERATING CAPITAL TOTAL - - - 26,775 0.00%- - - -100.00% CIP EXPENSE DEBT SERVICE TRANSFERS CC0522 Electric Administration Total 9,419,346 8,868,267 9,825,545 9,857,150 100.32%10,580,773 111,467 10,692,239 8.47% FY2022 FY2023 73Page 22 of 54 FY 2023 Budget Workshop Electric Services: CC0523 Electric Safety and Employee Development FY2020 FY2021 ACTUALS ACTUALS AMENDED BUDGET PROJECTIONS %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget BASE BUDGET CHANGES PROPOSED BUDGET %Variance Fav/(Unfav): FY2023 Budget to FY2022 Projections PERSONNEL 50100:Salaries - - 78,916 158,037 200.26%212,241 - 212,241 34.30% 50200:Payroll Tax Expense - - (598) 12,105 -2024.23%16,259 - 16,259 34.32% 50201:Worker's Compensation - - - 177 0.00%237 - 237 34.32% 50202:TWC Expense - - - - 0.00%504 - 504 0.00% 50300:Benefits - - 25,931 18,879 72.80%36,465 - 36,465 93.15% 50301:TMRS Expense - - 4,776 19,937 417.45%26,780 - 26,780 34.32% PERSONNEL TOTAL - - 109,025 209,135 191.82%292,487 - 292,487 39.86% OPERATIONS 51006:Subscriptions - - - - 0.00%20,000 - 20,000 0.00% 51340:Employee Recognition - - - - 0.00%250 - 250 0.00% 52506:Operational Supplies - - 40,000 40,000 100.00%38,365 - 38,365 -4.09% 53003:Food - - - - 0.00%300 - 300 0.00% 53010:Uniform Expense - - 30,800 30,800 100.00%74,600 - 74,600 142.21% 53016:Travel Expense - - 25,000 25,000 100.00%24,640 - 24,640 -1.44% 53017:Training Expense - - 64,000 64,000 100.00%96,290 - 96,290 50.45% OPERATIONS TOTAL - - 159,800 159,800 100.00%254,445 - 254,445 59.23% OPERATING CAPITAL CIP EXPENSE DEBT SERVICE TRANSFERS CC0523 Electric Safety and Employee Development Total - - 268,825 368,935 137.24%546,932 - 546,932 48.25% FY2022 FY2023 74Page 23 of 54 FY 2023 Budget Workshop Electric Services: CC0524 Metering Services FY2020 FY2021 ACTUALS ACTUALS AMENDED BUDGET PROJECTIONS %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget BASE BUDGET CHANGES PROPOSED BUDGET %Variance Fav/(Unfav): FY2023 Budget to FY2022 Projections PERSONNEL 50100:Salaries 700,435 711,174 581,279 609,471 104.85%- - - -100.00% 50200:Payroll Tax Expense 53,440 51,393 47,360 44,923 94.85%- - - -100.00% 50201:Worker's Compensation 3,595 781 4,612 3,511 76.12%- - - -100.00% 50202:TWC Expense 2,226 3,334 3,024 2,454 81.14%- - - -100.00% 50300:Benefits 130,632 122,214 110,533 112,219 101.53%- - - -100.00% 50301:TMRS Expense 89,595 89,691 74,839 75,420 100.78%- - - -100.00% PERSONNEL TOTAL 979,923 978,588 821,647 847,997 103.21%- - - -100.00% OPERATIONS 51001:Administrative Expense 314,127 271,320 312,403 312,403 100.00%- - - -100.00% 51003:Marketing & Promotional 15 - - - 0.00%- - - 0.00% 51004:Contractual Services 3,603 7,946 18,000 - 0.00%- - - 0.00% 51006:Subscriptions 152 - 1,000 - 0.00%- - - 0.00% 51007:Contracts & Leases - 1,331 6,000 - 0.00%- - - 0.00% 51009:Telephone 12,169 12,633 33,500 - 0.00%- - - 0.00% 52501:Office Supplies 769 854 900 - 0.00%- - - 0.00% 52506:Operational Supplies 8,683 35,719 74,872 29,049 38.80%- - - -100.00% 52507:Janitorial Supplies - 23 100 - 0.00%- - - 0.00% 52508:Utility Meters 1,750 1,232 - - 0.00%- - - 0.00% 52509:Maintenance Expense 451,329 617,897 648,000 - 0.00%- - - 0.00% 53002:Postage & Freight - 40 500 - 0.00%- - - 0.00% 53003:Food 636 520 1,000 - 0.00%- - - 0.00% 53010:Uniform Expense 10,533 9,293 10,268 - 0.00%- - - 0.00% 53016:Travel Expense 11,159 - 1,500 - 0.00%- - - 0.00% 53017:Training Expense 600 200 6,000 - 0.00%- - - 0.00% OPERATIONS TOTAL 815,527 959,007 1,114,043 341,452 30.65%- - - -100.00% OPERATING CAPITAL 60004:Capital Outlay - Equipment 209 1,903 28,768 - 0.00%- - - 0.00% OPERATING CAPITAL TOTAL 209 1,903 28,768 - 0.00%- - - 0.00% CIP EXPENSE DEBT SERVICE TRANSFERS CC0524 Metering Services Total 1,795,658 1,939,497 1,964,459 1,189,449 60.55%- - - -100.00% FY2022 FY2023 75Page 24 of 54 FY 2023 Budget Workshop Electric Services: CC0525 T&D Services FY2020 FY2021 ACTUALS ACTUALS AMENDED BUDGET PROJECTIONS %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget BASE BUDGET CHANGES PROPOSED BUDGET %Variance Fav/(Unfav): FY2023 Budget to FY2022 Projections PERSONNEL 50100:Salaries 2,037,914 2,294,999 (491,456) 390,004 -79.36%145,501 81,869 227,370 -41.70% 50200:Payroll Tax Expense 155,664 171,006 184,091 (1,022) -0.55%10,410 6,263 16,673 -1731.97% 50201:Worker's Compensation 12,239 3,016 20,643 (3,973) -19.25%1,598 91 1,689 -142.51% 50202:TWC Expense 5,000 6,929 9,072 (943) -10.39%353 252 605 -164.16% 50300:Benefits 362,174 283,312 255,105 25,602 10.04%15,645 13,155 28,800 12.49% 50301:TMRS Expense 259,677 290,889 291,910 12,764 4.37%17,219 10,234 27,453 115.08% PERSONNEL TOTAL 2,832,667 3,050,152 269,365 422,433 156.83%190,726 111,864 302,590 -28.37% OPERATIONS 51001:Administrative Expense 85,220 170,738 222,552 222,552 100.00%200,294 5,800 206,094 -7.40% 51003:Marketing & Promotional 78 - - - 0.00%- - - 0.00% 51004:Contractual Services 2,939 5,146 8,000 9,798 122.48%18,000 - 18,000 83.71% 51005:Professional Services 21,871 13,468 22,000 22,000 100.00%25,000 - 25,000 13.64% 51006:Subscriptions 1,904 211 - 97 0.00%- - - -100.00% 51008:Utilities 264 264 282 286 101.42%500 - 500 74.83% 51009:Telephone 15,499 5,306 29,000 32,700 112.76%- - - -100.00% 51340:Employee Recognition - 2,353 - - 0.00%6,250 - 6,250 0.00% 52501:Office Supplies 1,886 1,353 3,000 3,000 100.00%3,090 - 3,090 3.00% 52502:Educational Supplies - 413 - - 0.00%- - - 0.00% 52506:Operational Supplies 89,202 106,842 141,360 145,244 102.75%159,266 - 159,266 9.65% 52507:Janitorial Supplies - 356 - 210 0.00%- - - -100.00% 52508:Utility Meters 28,840 128,396 - - 0.00%- - - 0.00% 52509:Maintenance Expense 588,621 557,408 993,996 993,996 100.00%1,159,022 - 1,159,022 16.60% 53002:Postage & Freight 149 140 - 15 0.00%- - - -100.00% 53003:Food 1,709 4,830 4,000 4,000 100.00%7,500 - 7,500 87.50% 53010:Uniform Expense 12,453 28,663 2,000 7,121 356.05%- - - -100.00% 53016:Travel Expense 26,625 6,119 5,000 5,954 119.08%- - - -100.00% 53017:Training Expense 2,030 14,035 5,000 5,000 100.00%- 1,000 1,000 -80.00% OPERATIONS TOTAL 879,288 1,046,039 1,436,190 1,451,973 101.10%1,578,922 6,800 1,585,722 9.21% OPERATING CAPITAL 60004:Capital Outlay - Equipment 217,216 24,885 - 38,773 0.00%- - - -100.00% 60007:Capital Outlay - Distribution Systems (Infrastructure)2,440 64,521 270,000 266,936 98.87%300,000 - 300,000 12.39% OPERATING CAPITAL TOTAL 219,656 89,406 270,000 305,709 113.23%300,000 - 300,000 -1.87% CIP EXPENSE DEBT SERVICE TRANSFERS CC0525 T&D Services Total 3,931,610 4,185,597 1,975,555 2,180,115 110.35%2,069,649 118,664 2,188,312 0.38% FY2022 FY2023 76Page 25 of 54 FY 2023 Budget Workshop Electric Services: CC0537 Electric Resource Management FY2020 FY2021 ACTUALS ACTUALS AMENDED BUDGET PROJECTIONS %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget BASE BUDGET CHANGES PROPOSED BUDGET %Variance Fav/(Unfav): FY2023 Budget to FY2022 Projections PERSONNEL 50100:Salaries 83,023 - - - 0.00%- - - 0.00% 50200:Payroll Tax Expense 5,995 - - - 0.00%- - - 0.00% 50201:Worker's Compensation 68 - - - 0.00%- - - 0.00% 50202:TWC Expense 159 108 - - 0.00%- - - 0.00% 50300:Benefits 16,087 - - - 0.00%- - - 0.00% 50301:TMRS Expense 10,222 - - - 0.00%- - - 0.00% PERSONNEL TOTAL 115,553 108 - - 0.00%- - - 0.00% OPERATIONS 51001:Administrative Expense 11,886 13,349 16,458 16,458 100.00%- - - -100.00% 51004:Contractual Services 268,881 145,786 350,000 350,000 100.00%377,904 - 377,904 7.97% 51007:Contracts & Leases - - (1,000,000) - 0.00%- - - 0.00% 51009:Telephone 23 - - - 0.00%- - - 0.00% 51010:Legal Services - 59,250 - - 0.00%- - - 0.00% 52001:Purchase Power 61,542,930 109,307,818 54,126,987 54,126,987 100.00%58,442,369 - 58,442,369 7.97% 52002:Net Congestive Rights Revenue (CRR) Expense (1,858,623) 989,262 2,000,000 1,000,000 50.00%1,079,727 - 1,079,727 7.97% 52501:Office Supplies 2,605 - - - 0.00%- - - 0.00% OPERATIONS TOTAL 59,967,702 110,515,464 55,493,445 55,493,445 100.00%59,900,000 - 59,900,000 7.94% OPERATING CAPITAL CIP EXPENSE DEBT SERVICE TRANSFERS CC0537 Electric Resource Management Total 60,083,255 110,515,572 55,493,445 55,493,445 100.00%59,900,000 - 59,900,000 7.94% FY2022 FY2023 77Page 26 of 54 FY 2023 Budget Workshop Electric Services: CC0555 Electric Systems Operations FY2020 FY2021 ACTUALS ACTUALS AMENDED BUDGET PROJECTIONS %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget BASE BUDGET CHANGES PROPOSED BUDGET %Variance Fav/(Unfav): FY2023 Budget to FY2022 Projections PERSONNEL 50100:Salaries 941,461 999,141 1,181,764 1,154,584 97.70%1,262,943 103,849 1,366,792 18.38% 50200:Payroll Tax Expense 73,511 75,091 97,460 77,615 79.64%88,431 7,287 95,718 23.32% 50201:Worker's Compensation 6,617 1,151 7,072 6,387 90.31%8,010 106 8,116 27.08% 50202:TWC Expense 2,499 3,935 4,038 3,314 82.06%4,032 504 4,536 36.88% 50300:Benefits 131,478 116,987 156,910 129,660 82.63%160,504 33,495 193,999 49.62% 50301:TMRS Expense 120,476 126,323 146,845 128,978 87.83%145,651 11,907 157,558 22.16% PERSONNEL TOTAL 1,276,042 1,322,627 1,594,090 1,500,536 94.13%1,669,571 157,148 1,826,719 21.74% OPERATIONS 51001:Administrative Expense 67,081 112,382 141,739 141,739 100.00%92,165 7,383 99,548 -29.77% 51004:Contractual Services 29,600 64,166 85,000 80,000 94.12%90,000 - 90,000 12.50% 51006:Subscriptions 12,693 222 4,000 6,552 163.80%6,552 - 6,552 0.00% 51007:Contracts & Leases - - 26,000 25,000 96.15%15,000 - 15,000 -40.00% 51008:Utilities 261 - - - 0.00%- - - 0.00% 51009:Telephone 7,343 4,076 12,890 10,000 77.58%15,000 456 15,456 54.56% 52501:Office Supplies 1,318 1,456 6,500 1,900 29.23%2,500 - 2,500 31.58% 52506:Operational Supplies 8,938 15,764 25,051 25,056 100.02%23,811 28,000 51,811 106.78% 52507:Janitorial Supplies 5 8 - 150 0.00%150 - 150 0.00% 52509:Maintenance Expense 20,231 10,526 2,000 8,324 416.20%10,000 - 10,000 20.13% 53002:Postage & Freight 528 (1,052) - - 0.00%- - - 0.00% 53003:Food 718 212 900 429 47.67%1,000 350 1,350 214.69% 53010:Uniform Expense 1,872 2,010 3,350 2,750 82.09%3,750 550 4,300 56.36% 53015:Other Miscellaneous Expense - 8,708 - 25,000 0.00%25,000 - 25,000 0.00% 53016:Travel Expense - 774 - 3,700 0.00%500 - 500 -86.49% 53017:Training Expense 2,150 34,969 25,000 10,000 40.00%10,000 2,000 12,000 20.00% OPERATIONS TOTAL 152,738 254,221 332,430 340,600 102.46%295,428 38,739 334,167 -1.89% OPERATING CAPITAL 60004:Capital Outlay - Equipment 17,753 2,404 - - 0.00%- - - 0.00% OPERATING CAPITAL TOTAL 17,753 2,404 - - 0.00%- - - 0.00% CIP EXPENSE DEBT SERVICE TRANSFERS CC0555 Electric Systems Operations Total 1,446,533 1,579,253 1,926,520 1,841,136 95.57%1,964,999 195,887 2,160,885 17.37% FY2022 FY2023 78Page 27 of 54 FY 2023 Budget Workshop Electric Services: CC0557 Electrical Engineering FY2020 FY2021 ACTUALS ACTUALS AMENDED BUDGET PROJECTIONS %Variance Fav/(Unfav): FY2022 Projections to FY2022 Budget BASE BUDGET CHANGES PROPOSED BUDGET %Variance Fav/(Unfav): FY2023 Budget to FY2022 Projections PERSONNEL 50100:Salaries 354,388 526,367 (241,011) 298,080 -123.68%165,470 - 165,470 -44.49% 50200:Payroll Tax Expense 27,095 38,784 90,131 24,680 27.38%12,617 - 12,617 -48.88% 50201:Worker's Compensation 813 206 1,314 1,977 150.44%403 - 403 -79.60% 50202:TWC Expense 875 1,937 2,268 (277) -12.21%403 - 403 -245.49% 50300:Benefits 82,003 87,857 167,454 11,410 6.81%24,381 - 24,381 113.69% 50301:TMRS Expense 45,619 65,887 143,706 46,568 32.40%20,886 - 20,886 -55.15% PERSONNEL TOTAL 510,794 721,038 163,862 382,437 233.39%224,160 - 224,160 -41.39% OPERATIONS 51001:Administrative Expense 266,048 334,025 420,919 420,919 100.00%327,113 - 327,113 -22.29% 51004:Contractual Services - - 10,000 50,000 500.00%707,000 - 707,000 1314.00% 51005:Professional Services - 3,215 - - 0.00%- - - 0.00% 51006:Subscriptions - 549 - - 0.00%- 18,000 18,000 0.00% 51007:Contracts & Leases 4,194 - - - 0.00%- - - 0.00% 51009:Telephone 2,728 114 7,800 7,800 100.00%8,034 - 8,034 3.00% 51340:Employee Recognition - - - 59 0.00%3,500 - 3,500 5832.20% 52501:Office Supplies 927 1,342 2,500 2,500 100.00%4,000 - 4,000 60.00% 52506:Operational Supplies 1,513 4,962 8,757 9,592 109.54%23,871 - 23,871 148.86% 52507:Janitorial Supplies - 41 - - 0.00%- - - 0.00% 52509:Maintenance Expense 7,047 3,186 4,693 208,393 4440.33%1,500 - 1,500 -99.28% 53002:Postage & Freight 25 - - - 0.00%- - - 0.00% 53003:Food - 32 500 534 106.80%4,200 - 4,200 686.52% 53010:Uniform Expense 577 748 1,200 1,200 100.00%3,200 - 3,200 166.67% 53016:Travel Expense 1,557 - 5,700 5,700 100.00%12,700 - 12,700 122.81% 53017:Training Expense 5,565 6,350 15,500 15,500 100.00%30,664 - 30,664 97.83% OPERATIONS TOTAL 290,179 354,563 477,569 722,197 151.22%1,125,782 18,000 1,143,782 58.38% OPERATING CAPITAL 60004:Capital Outlay - Equipment - (5,545) 2,907 3,000 103.21%- - - -100.00% 60010:Capital Outlay 128,201 - - - 0.00%- - - 0.00% OPERATING CAPITAL TOTAL 128,201 (5,545) 2,907 3,000 103.21%- - - -100.00% CIP EXPENSE 62001:CIP Expense 1,255,863 3,386,145 25,026,230 25,026,230 100.00%11,900,000 - 11,900,000 -52.45% CIP EXPENSE TOTAL 1,255,863 3,386,145 25,026,230 25,026,230 100.00%11,900,000 - 11,900,000 -52.45% DEBT SERVICE TRANSFERS CC0557 Electrical Engineering Total 2,185,037 4,456,202 25,670,568 26,133,864 101.80%13,249,943 18,000 13,267,943 -49.23% FY2022 FY2023 79Page 28 of 54 FY 2023 Budget Workshop Electric Services: City of Georgetown FTEs Proposed One-Time Ongoing Proposed Total Not Proposed Total FY2023 SLR-02: SCADA Analyst-CC0521 Operational Technology 1.00 - 146,584 146,584 - FY2023 SLR-03: Data Plans for AMI Network-CC0521 Operational Technology - - 12,500 12,500 - FY2023 SLR-04: Network Supplies-CC0521 Operational Technology - - 20,500 20,500 - FY2023 SLR-05: Operational Technology Shared Vehicle-CC0521 Operational Technolo - - 5,800 5,800 - FY2023 SLR-06: Cybersecurity Assessment, Network Enhancements, and Upgrades-CC0 - - 22,500 22,500 - FY2023 SLR-07: SCADA Maintenance for Electric and Water/Wastewater Utilities-CC05 - - 9,300 9,300 - FY2023 SLR-08: Metering Related Expenses-CC0521 Operational Technology - - - - - CC0521 Operational Technology 1.00 - 217,184 217,184 - FY2023 SLR-01: Administrative Assistant-CC0522 Electric Administration 1.00 - 74,867 74,867 - FY2023 SLR-02: Employee Recognition-CC0522 Electric Administration - - 36,600 36,600 - FY2023 SLR-03: Website Updates-CC0522 Electric Administration - - - - 40,000 CC0522 Electric Administration 1.00 - 111,467 111,467 40,000 FY2023 SLR-01: PPE and Safety Shoes-CC0523 Electric Safety and Employee Developme - - - - - FY2023 SLR-02: KPA/iScout EHS Software-CC0523 Electric Safety and Employee Develo - - - - - FY2023 SLR-03: Training and Other Related Costs-CC0523 Electric Safety and Employee - - - - - CC0523 Electric Safety and Employee Development - - - - - FY2023 SLR-01: Metering Technician-CC0525 T&D Services 1.00 1,800 116,864 118,664 - CC0525 T&D Services 1.00 1,800 116,864 118,664 - FY2023 SLR-02: Utility Systems Locator-CC0555 Electric Systems Operations 1.00 23,000 82,538 105,538 - FY2023 SLR-01: Senior Utility Systems Operator-CC0555 Electric Systems Operations 1.00 - 90,349 90,349 - CC0555 Electric Systems Operations 2.00 23,000 172,887 195,887 - FY2023 SLR-01: Hand Tools for Engineering Personnel-CC0557 Electrical Engineering - - - - - FY2023 SLR-02: ANB Systems-CC0557 Electrical Engineering - - 18,000 18,000 - FY2023 SLR-03: Training and Travel Increase-CC0557 Electrical Engineering - - - - - FY2023 SLR-04: Engineering Contractor Support-CC0557 Electrical Engineering - - - - - CC0557 Electrical Engineering - - 18,000 18,000 - FY2023 SLR-02: Utility Systems Locator-CC0001 Non-Departmental - 38,500 - 38,500 - FY2023 SLR-01: Administrative Assistant-CC0001 Non-Departmental - 3,000 - 3,000 - FY2023 SLR-01: Senior Utility Systems Operator-CC0001 Non-Departmental - 3,000 - 3,000 - FY2023 SLR-01: Metering Technician-CC0001 Non-Departmental - 43,000 - 43,000 - FY2023 SLR-02: SCADA Analyst-CC0001 Non-Departmental - 3,000 - 3,000 - FY2023 SLR-05: Operational Technology Shared Vehicle-CC0001 Non-Departmental - 40,000 - 40,000 - CC0001 Non-Departmental - 130,500 - 130,500 - ELECTRIC TOTAL 5.00 155,300 636,401 791,701 40,000 80 Page 29 of 54 Georgetown Electric Utility Advisory Board 07/21/2022 Page 30 of 54 22 AGENDA I.Regular Session: (* -indicates legislative action) A.Call to Order B.Roll Call C.Introduction of Visitors D.Public Wishing to Address the Board E.Review and Approval of Minutes* F.General Manager’s Monthly Report i.Customer Service and Billing Report ii.Operations Report iii.Safety and Employee Development Report iv.Project Updates II.Executive Session: I.Purchased Power Update J.Cyber Security Update *-indicates legislative action Page 31 of 54 Customer Service and Billing – Electric Services Customer Service and Billing – Electric Services Review of Minutes 06/16/2022 Page 32 of 54 General Manager’s Monthly Report 07/21/2022 Page 33 of 54 Customer Service and Billing – Electric Services Customer Service and Billing – Electric Services Customer Service and Billing – Electric Services Leticia Zavala Customer Care Director Page 34 of 54 66 •All Available Services** Customer Statistics Available Electric Meters:May-2022 Jun-2022 Residential 27,581 27,636 General -Small 2,594 2,595 General -Large 350 351 Industrial 22 22 Industrial -Large 1 1 School Services 24 24 Municipal 241 240 Municipal -Pumping 58 59 Total Services Count 30,871 30,928 Available Security Lights May-2022 Jun-2022 Residential 94 94 Non-Residential 127 127 Municipal 4,203 4,203 Total Services Count 4,424 4,424 Net Metering REC Meters*546 546 *Main Meters Included in Counts above **Active & Inactive service delivery points Page 35 of 54 77 •Breakdown by Active Electric Customers (unique) : •Electric Billing Collection: •Advanced Metering Infrastructure (AMI): 99.7% –Usage data automatically transmitted to billing office •Automated Meter Reading (AMR): .3% –Usage data is collected via a drive by system •# of Customer Estimations: 405 •Account did not get a “good” READ; or •Account did not get “ANY” READ (work order put in for metering to investigate) Customer Statistics May-2022 Jun-2022 Residential 26,926 27,025 Builder 885 853 Commercial & Industrial 2,428 2,423 Municipal/Schools 294 295 Total Electric Customers:30,533 30,596 Page 36 of 54 88 •Billed Meters/Services* Customer Statistics Billed Electric Meters:May-2022 Jun-2022 Residential 27,127 27,458 General -Small 2,333 2,328 General -Large 318 326 Industrial 18 21 Industrial -Large 1 1 School Services 25 25 Municipal 182 182 Municipal -Pumping 54 54 Total Services Count 30,058 30,395 Billed Security Lights May-2022 Jun-2022 Residential 94 94 Non-Residential 127 127 Municipal 4,203 4,203 Total Services Count 4,424 4,424 Billed Net Meters*544 545 *Also included in above meter counts *Meters billed during the month Page 37 of 54 99 Customer Billing Statistics Average Monthly Electric Bill FY22 -June FY21 -June All Customers $253.30 $235.92 Average YTD Electric Bill FY2022 FY2021 All Customers $209.22 $208.05 Residential Customer -FY2022 FY2021 Cost per 1000 kWh $134.35 $134.35 (including PCA + Base) Average kWh 805 741 Electric Bill (based on Average kWh)$108.15 $99.55 Page 38 of 54 1010 Electric Revenue –FY 2022 Page 39 of 54 1111 Aged Receivables Report Electric AR –Combined Aging Breakdown Electric AR –Active & Inactive Accounts –As of 6/30/22 Electric Jun-22 Prior Month Variance Active Accounts $99,834.05 $92,595.39 $7,238.66 Inactive Accounts $494,606.11 $466,367.41 $28,238.70 Total $594,440.16 $558,962.80 $35,477.36 Electric Jun-22 Prior Month Variance 31 –60 Days $73,883.90 $69,756.76 $4,127.14 61 –90 Days $39,380.99 $44,538.44 ($5,157.45) 91 –120 Days $39,568.78 $30,357.20 $9,211.58 120 –365 Days $242,009.71 $248,074.97 ($6,065.26) > 365 Days $199,596.78 $166,235.43 $33,361.35 Total $594,440.16 $558,962.80 $35,477.36 Customer Count 2764 2541 223 Page 40 of 54 1212 Collection Agency Review Month Accounts Assigned Assigned Amount Assign Average Bal Current Collected Collected ToDate Fee Paid to Collection Agency Liquidity Jun-22 87 $58,725.50 $675.01 $181.44 $181.44 0.3% May-22 216 $64,610.98 $299.12 $1,117.79 $1,612.03 $1,370.94 2.5% Apr-22 59 $20,342.43 $344.79 $0.00 $1,429.88 $1542.12 7.0% Mar-22 75 $25,424.37 $338.99 $306.46 $3,801.85 $31,362.07 15.0% Feb-22 249 $96,830.86 $388.88 $27.00 $11,974.39 $2,167.60 12.4% Jan-22 0 $0.00 $0.00 $0.00 $0.00 $1476.78 0.0% Dec-21 104 $95,028.38 $913.73 $0.00 $66,134.14 $900.16 69.6% Nov-21 48 $16,358.98 $340.81 $0.00 $1,489.58 $855.10 9.1% Oct-21 123 $39,594.42 $321.91 $445.98 $10,475.16 $1,916.84 26.5% Sep-21 131 $44,705.08 $341.26 $0.00 $8,028.43 $1,841.48 18.0% Aug-21 52 $19,337.56 $371.88 $88.08 $1,503.70 $2,750.86 7.8% Jul-21 327 $165,161.34 $505.08 $85.00 $38,220.53 $4,661.59 23.1% Jun-21 0 $0.00 $0.00 $0.00 $0.00 $5469.96 0.0% May-21 2467 $1,391,124.99 $563.89 $263.17 $141,201.26 $290.16 10.2% Total 3851 $2,037,244.89 $517.33 $2,514.92 $286,052.39 $56,605.66 14.0% Page 41 of 54 Electric Operations Report Mike Westbrook Electric Operations Manager Page 42 of 54 14 Performance Metrics City of Georgetown Jun-22 May June Good Caution Alert Training 100%100%>90%90%-80%<80% Safety 100%100%>90%90%-80%<80% SO OTC 91%90%>90%90%-80%<80% PM WO OTC 99%99%>90%90%-80%<80% CM WO OTC 100%99%>90%90%-80%<80% Electric Reliability (SAIFI)0.281 0.621 <1 1-2 >2 Electric Outage Duration (CAIDI)67.467 58.35 <116 116-200 >200 Page 43 of 54 15 Top Five Outages & Events City of Georgetown Date Start Time Duration (min) Customers Affected Customer Minutes Cause Area 6/1/2022 05:29am 193 163 31,459 Transformer hit/damaged primary cable Rivery-90 6/4/2022 11:26pm 32 1040 33,280 Mylar balloon in the primary Rivery-30 6/10/2022 5:43am 23 2020 46,460 Report of car pole South Georgetown 6/13/2022 4:24pm 45 2387 107,415 Boring contractor hit UG primary Rivery-90 6/14/2022 2:02pm 67 2803 187,801 Contractor damaged primary UG cable Rivery-80 Date Start of Event End of Event # of Outages Average Duration Cause Area N/A Page 44 of 54 Electric Safety and Training Report Danny Potter Electric Safety and Employee Development Manager Page 45 of 54 17 Electric Employee Safety and Development •Monthly and weekly Safety Meetings •Monthly -Heat Stress •Weekly –Lock Out Tag Out Procedures •Safety Incidents: 0 •Employee Training and Development •NLC Apprentice progress Page 46 of 54 Project Updates 07/21/2022 Page 47 of 54 1919 •Go Live was 6/30/2022 •Inventory Purchase on track to be completed Week of 7/18 •Next Steps •Finish up committed orders with Techline •Starting to order material through TEC •Five (5) Blanket Work Orders have been established with TEC for quick turnaround material •Electric Operations Truck Stock •Electric Metering Truck Stock •Electric Operations Emergency Material •Electric Operations Street Lights TEC Warehouse Outsourcing Update COG Current Books $ 2,378,364.24 TEC Purchase $ 1,550,449.76 $ 827,914.48 Page 48 of 54 © 2022 NEWGEN STRATEGIES AND SOLUTIONS, LLC CITY OF GEORGETOWN MISCELLANEOUS UTILITY FEE REVIEW -RECAP July 19, 2022 Page 49 of 54 © 2022 NEWGEN STRATEGIES AND SOLUTIONS, LLC MISCELLANEOUS UTILITY FEE REVIEW •Opportunity to review fees in conjunction with current Electric Rate Study. •Fees last reviewed and updated in 2012: ̶Prior to 2012, last updated in early 2000: ̶Last time Utility Account Set-up Fee reviewed was 2004 •Why now? ̶Last review done 10 years ago. ̶Significantly increase in labor and other operating costs ̶Align with the cost-of-service study currently underway 21 MISCELLANEOUS UTILITY FEE REVIEW •Opportunity to review fees in conjunction with current Electric Rate Study. •Fees last reviewed and updated in 2012: ̶Prior to 2012, last updated in early 2000: ̶Last time Utility Account Set-up Fee reviewed was 2004 •Why now? ̶Last review done 10 years ago. ̶Significantly increase in labor and other operating costs ̶Align with the cost-of-service study currently underway Page 50 of 54 22 Page 51 of 54 Legislative Action Items 07/21/2022 Page 52 of 54 Executive Session: In compliance with the Open Meetings Act, Chapter 551, Government Code, Vernon's Texas Codes, Annotated, the item listed below will be discussed in closed session and is subject to action in the regular session. Sec. 551.086 Competitive Matters •Purchased Power Review Sec. 551.089 Deliberation Regarding Security Devices or Security Audits •Cyber Security Update Page 53 of 54 City of Georgetown, Texas Electric Utility Board July 21, 2022 S UB J E C T: IT E M S UMMARY: F IN AN C IAL IMPAC T: N/A S UB MIT T E D B Y: R obert C as e- Board C hairman Page 54 of 54