Loading...
HomeMy WebLinkAboutORD 2022-02 - Roll-forward Budget FY 2022ORDINANCE NO. 02, Z-_OZ AN ORDINANCE OF THE CITY OF GEORGETOWN, TX, AMENDING THE FISCAL YEAR 2022 ANNUAL BUDGET DUE TO CONDITIONS THAT RESULTED IN NEW PROGRAM REQUIREMENTS IN THE CURRENT YEAR, AND DUE TO THE TIMING OF CAPITAL PROJECTS AND OTHER EXPENDITURES APPROVED IN THE PRIOR YEAR; APPROPRIATING THE VARIOUS AMOUNTS THEREOF; AND REPEALING ALL ORDINANCES OR PARTS OF ORDINANCES IN CONFLICT THEREWITH. WHEREAS, certain mid -year adjustments are required to accommodate timing and changing conditions due to growth and capital improvements that occurred during FY 2021; and WHEREAS, certain appropriations among divisions and funds are required for personnel costs, programs, goods and services; and WHEREAS, the various budgets need to be amended in FY2022 for these revenue and expense adjustments and transfers; and WHEREAS, certain capital improvement and other planned projects budgeted in FY2021 were not completed in FY2021; and WHEREAS, these certain capital improvements and other planned projects need funds and related budget appropriations to be rolled forward into FY2022; and WHEREAS, the General, General Capital Projects, Tourism, Street Maintenance, PEG, Library, Tree, Parks Restricted, Parkland Dedication, Police Forfeitures — State, American Rescue Plan, Village PID, GTEC, Facilities, Fleet, Joint Services, Information Technology, Airport, Electric, Stormwater, and Water funds have FY2021 fund balances in excess of amounts projected at the time of the FY2022 budget adoption; and WHEREAS, Certificates of Obligation, General Obligation, or Revenue bonds have been or will be issued to fund the capital improvements not already included in the adopted 2022 budget; and WHEREAS, the City Council of the City of Georgetown wishes to use those excess funds for these new conditions in FY2022; and WHEREAS, the changes were unknown and unforeseeable at the time the fiscal year 2022 budget was approved; and WHEREAS, the City Charter allows for changes in the Annual Operating Plan by a Council majority plus one for municipal purposes and in emergency situations; Ordinance Number:2— Description: Roll -forward Amendment Date Approved: Page 1 of 3 NOW, THEREFORE, BE IT ORDAINED BY THE CITY COUNCIL OF THE CITY OF GEORGETOWN, TEXAS, THAT: SECTION 1. The facts and recitations contained in the preamble of this ordinance are hereby found and declared to be true and correct, and are incorporated by reference herein and expressly made a part hereof, as if copied verbatim. SECTION 2. The amendment to the 2022 Annual Budget of the revenues of the City of Georgetown and expenses of conducting the affairs thereof, is in all things adopted and approved as an addition to the previously approved budget of the current revenues and expenses as well as fixed charges against said City for the fiscal year beginning October 1, 2021, and ending September 30, 2022. A copy of the amendments are attached hereto as Exhibits "A, B, C and D." SECTION 3. The total of $341,511,772 is hereby appropriated for payments of expenditures and payments of the funds and included in the Exhibit "A". SECTION 4 All ordinances and resolutions, or parts of ordinances and resolutions, in conflict with this Ordinance are hereby repealed, and are no longer of any force and effect. This ordinance complies with the vision statement of the Georgetown 2030 Plan. SECTION 5. If any provision of this ordinance or application thereof to any person or circumstance, shall be held invalid, such invalidity shall not affect the other provisions, or application thereof, of this ordinance which can be given effect without the invalid provision or application, and to this end the provisions of this ordinance are hereby declared to be severable. SECTION 6. The Mayor is hereby authorized to sign this ordinance and the City Secretary to attest. This ordinance shall become effective upon adoption of its second and final reading by the City Council of the City of Georgetown, Texas. PASSED AND APPROVED on First Reading on the 14th day of December, 2021. PASSED AND APPROVED on Second Reading on the 11th day of January, 2022. Ordinance NUmbev ZZ,1)Z Description: Roll -forward Amendment Date Approved: Page 2 of 3 ATTEST: I�(,"AAbVL,&V- Robyn DLvnsmore City Secretary APPROVED AS TO FORM: Skye sson City Attorney Ordinance Number: juj,z. _n L Description: Roll -forward Amendment Date Approved: THE I r�F GEORGETOWN: By: J ice. 1#!5 Mayor QMp IQhy` Page 3 of 3 f51 lti.l "i GEORGETOWN TFXAS� FY2Q22: 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 expenses 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 0 Water - $247 thousand GEORG�T'OWN I' 522 C I P Roll I onward ArnenTment Major operational roll forwards include: • 2"d 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 citywide. 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 GFNFRALFLIND: Current budget for the General Fund revenues total $90,772,990. Current budget for the General Fund expenses totals $94,244,537. This amendment recognizes $495,784 in additional fund balance for rollforward requests, as well as $2,383,006 to be added to the Economic Stability Reserve. 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 $1Sk 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. GEoRdT'0WN FYZ022 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 forthe 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 TOLIRISM 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 - ST Iti[ 1848 GEORGETOWN TEXAS 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 fif IH tft GEORGETOWN TEXAS Services Fund and will have no net effect on the fund as a whole. This amendment also proposes the transfer 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: South lake Water Treatment Plant •' • FY2f]27. I RniE Forward Arr�endmena Amount: $140,000,000 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. FY2022 Budget Amendment Budget BeRinning Fund Balance 21,533,929 2,978,790 24,412,719 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:OtherTaxes 420,000 420,000 41001:Fines 311,150 311,150 41002:Penalties 85,000 85,000 42001:lnterest 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:GrantRevenue 185,000 185,000 44S03: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 - 9,871,270 Revenue Total 90,772,990 31,185 90,804,175 CC0001 Non -Departmental 1,237,635 273,000 1,510,635 CC0107 Planning 3,043,678 449,983 3,493,661 CCO202 Parks Administration 734,701 - 734,701 CCO210 Library 3,295,247 3,295,247 CCO211 Parks 2,965,312 4,527 2,969,839 CCO212 Recreation 4,630,251 - 4,630,251 CCO213 Tennis Center 512,912 512,912 CCO215 Garey Park 1,063,906 - 1,063,906 CCO218 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,979 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 CC0946 Streets 4,458,099 14,984 4,473,082 Expense Total 94,244,536 610,169 94,854,705 Ending Fund Balance 18,062,393 2,299,806 20,362,189 Benefit Payout Reserve 340,000 340,000 Contingency Reserve 15,824,255 80,137 15,904,392 Economic Stability Reserve 1,467,563 2,383,006 3,850,569 Reserves Total 17,631,818 2,463,143 20,094,961 Available Fund Balance 430,555 (163,3371 267,228 FY2022 Budget Amendment Budget Beginning Fund Balance 30,704,575 68,937,134 99,641,709 42001:lnterest 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 CC0001 Non -Departmental CCO211 Parks CC0302 Finance Administration CC0319 Facilities CC0402 Fire Support Services/Administration CCO526 Systems Engineering CCO533 Environmental Services CC0602 Administrative Services CC0702 Police Administration CC0802 Public Works CCO846 Streets Expense Total 4,820,000 5,062,500 2,012,500 300,000 40, 200, 000 52,395,000 231,499 2,409,820 336,126 4,784,249 870,000 34,838,938 101217, 969 2,276,859 62,588 121385,811 570,715 68,984,574 5,051,499 7,472,320 336,126 6,796,749 1,170, 000 75,038,938 10,217,969 2,276,859 62,588 12,385,811 570,715 121,379,574 Ending Fund Balance 1 29,839,575 0 29,839,575 Mobility Bond Proceeds Reserves Total 28,000,000 28,000,000 28,000,000 - 28,000,000 Available Fund Balance 1 1,839,575 0 1,839,575 Tourism FY2022 Current Rollforward Amended Budget Amendment Budget Beginning Fund Balance 1,271,504 44,053 1,315,557 40008:Other Taxes 1,000,000 - 1,000,000 42001:lnterest 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 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 Contingency Reserve Capital Reserve Reserves Total 337,842 337,842 597,724 597,724 935,566 - 935,566 Available Fund Balance 1 0 0 1 Beginning Fund Balance 40002:Sales Taxes 42001:lnterest Income Revenue Total FY2022 Current Rollforward Amended Budget Amendment Budget 40637,731 2,875,899 7,513,630 5,322,969 5,322,969 5,000 - 5,000 5,327,969 - 5,327,969 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 Arterial Reserve 750,000 750,000 Reserves Total 750,000 - 750,000 Available Fund Balance 5,340,700 (3,100,000) 2,240,700 on FY2022 Current Rollforward Amended Budget Amendment Budget Beginning Fund Balance 298,537 4,348 302,885 40005:Franchise Taxes I 168,786 - 168,786 42001:lnterest Income 500 - 500 Revenue Total 169,286 - 169,286 Operating Capital 125,000 4,348 129,348 Expense Total 125,000 4,348 129,348 Ending Fund Balance 342,823 - 342,823 Reserves Total - - - Available Fund Balance 342,823 - 342,823 FY2022 Current Rollforward Amended Budget Amendment Budget Beginning Fund Balance 1 154,133 84,510 238,643 44504:Donations Revenue Total 140,000 140,000 140,000 - 140,000 Operations 130,000 81,510 211,510 Operating Capital I - 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 Beginning Fund Balance 42001:lnterest Income 43001:Fees Revenue Total FY2022 Current Rollforward Amended Budget Amendment Budget 2,283,691 2,195 2,285,886 5,000 500,000 5,000 500,000 505,000 - 505,000 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 Total Available Fund Balance 1 2,388,691 - 2,388,691 Parks Restricted Fund Balance 42001:lnterest Income 43001:Fees 43606:Airport Charges 44504:Donations 70001:Transfers In Revenue Total Operations Operating Capital Expense Total FY2022 Current Rollforward Amended Budget Amendment Budget 448,491 196,272 644,763 1,500 1,500 125 125 4,500 4,500 4,000 4,000 297,000 297,000 307,125 307,125 310,500 196,272 506,772 114,716 - 114,716 425,216 196,272 621,488 Ending Fund Balance 330,400 - 330,400 1 Reserves Total - - - Available Fund Balance 330,400 - 330,400 Fund Balance 42001:lnterest Income 44502:Developer Contributions Revenue Total FY2022 Current Rollforward Amended Budget Amendment Budget 3,423,739 283,737 3,707,476 6,300 6,300 1,250,000 1,250,000 1,256,300 - 1,256,300 ❑perating Capital 1,700,000 283,737 1,983,737 1 Expense Total 1,700,000 283,737 1,983,737 Ending Fund Balance 2,980,039 - 2,980,039 Reserves Total Available Fund Balance 1 2,990,039 - 2,980,039 Police Forfeitures - State ........ Beginning Fund Balance Operations Expense Total FY2022 Current Rollforward Amended Budget Amendment Budget 3,160 50,000 53,160 50,000 50,000 50,000 50,000 Ending Fund Balance 3,160 - 3,160 Reserves Total Available Fund Balance 1 3,160 - 3,160 FY2022 Current Rollforward Amended Budget Amendment Budget Beginning Fund Balance 40014,753 (87,774) 3,926,979 44001:Grant Revenue 4,014,753 4,014,753 Revenue Total 4,014,753 - 4,014,753 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 Total Available Fund Balance 1 8,004,506 (159,774) 7,844,732 Village PID FY2022 Current Rollforward Budget Amendment Amended Budget Beginning Fund Balance 651,019 51,500 702,519 Revenue 40001:Property Taxes 42001:lnterest Income 522,274 1,000 - - 522,274 1,000 Revenue Total 523,274 - 523,274 Expense Operations Operating Capit i! 395,425 7488,725 - 51,500 395,425 540,225 Expense Total 884,150 51,500 935,650 Ending Fund Balance 290,143 - 290,143 Reserves Total - - Available Fund Balance 1 790,143 - 290,143 FY2022 Current Rollforward Amended Budget Amendment Budget Beginning Fund Balance 22,698,301 16,201,742 38,900,043 40002:Sales Taxes 42001:lnterest Income 46001:13ond Proceeds Revenue Total 10, 645, 938 10, 645, 938 24,000 24,000 3,700,000 3,700,000 14,369,938 - 14,369,938 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 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 Current Rollforward Amended Budget Amendment Budget Beginning Fund Balance 2,271,982 2,271,982 42001:lnterest Income 6,500 6,500 43004:Administrative Charges 4,664,244 4,664,244 45001:Misc Revenue 2,000 2,000 45002:lnsurance Proceeds 1,000 1,000 Revenue Total 4,673,744 - 4,673,744 Personnel Operations Operating Capital Transfers Expense Total 734,847 2,942 737,789 3,614,016 - 3,614,016 809,261 809,261 50,000 - 50,000 5,208,125 2,942 5,211,067 Ending Fund Balance 1,737,602 (2,942) 1,734,660 Contingency Reserve Capital Reserve Reserves Total 281,055 1,456,546 (2,942) 278,113 1,456,546 1,737,601 (2,942) 1,734,659 Available Fund Balance 1 1 - 1 Fleet Services Fund FY2022 Budget Amendment Budget Beginning Fund Balance 1 5,134,768 2,959,306 8,094,074 42001:lnterest Income 25,000 25,000 43004:Administrative Charges 3,585,068 3,585,068 45002:lnsurance 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 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 Contingency Reserve Fire Vehicle Reserve Capital Reserve Reserves Total 549,558 549,558 493,000 493,000 1,418,240 1,418,240 2,460,798 - 2,460,798 Available Fund Balance 1 2,560,718 (5,434) 2,555,285 FY2022 Budget Amendment Budget Beginning Fund Balance 1,974,965 141,598 2,116,563 Revenue 42001:lnterest 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 CC0001 Non -Departmental CC0302 Finance Administration CC0315 Accounting CC0317 Purchasing CC0321 Customer Care CC0322 Billing CC0323 Data Analytics & Administration CC0503 Organizational and Operational Excellence CC0526 Systems Engineering CC0523 Real Estate CC0534 Conservation CC0637 Economic Development CC0639 Human Resources CC0640 Citywide Human Resources CC0654 Legal Expense Total 923,500 115,000 1,038,500 1,223,443 25,000 1,248,443 1,591,909 - 1,591,909 1,073,285 1,073,285 6,979,073 (5,905,121) 1,073,953 - 1,304,610 1,304,610 - 4,801,286 4,801,286 380,014 380,014 3,344,935 (579,820) 2,765,115 - 254,820 254,820 646,962 (646,963) (1) 655,188 655,188 1,736,466 1,736,466 1,354,125 1,354,125 1,367,308 - 1,367,308 21,276,209 (631,188) 20,645,021 Ending Fund Balance 1 2,437,380 (1,414) 2,435,966 Contingency Reserve Reserves Total 2,437,380 (1,414) 2,435,966 2,437,380 (1,414) 2,435,966 Available Fund Balance 1 0 (0) (0) Information Technology Fund 42001:Interest Income 43004:Administrative Charges 70001:Transfers In Revenue Total CC0001 Non -Departmental CC0648 IT Fiber CC0649 IT Applications CC0650 IT Public Safety CC0651 IT Infrastructure CC0652 IT Management Expense Total 8,000 8,000 11,766,494 - 11,766,494 139,000 36,000 175,000 11,913,494 36,000 11,949,494 35,000 - 35,000 353,136 75,000 428,136 1,543,959 1,543,959 493,043 - 493,043 2,668,770 18,621 2,687,391 6,771,478 71,000 6,842,478 11, 865,385 164,621 12,030,006 Ending Fund Balance 1 1,776,527 (3,621) 1,772,906 Contingency Reserve Reserve for Capital Reserves Total 1,173,234 603,294 (3,621) 1,169,613 603,294 1,776,528 (3,621) 1,772,907 Available Fund Balance 1 (0) - (0) FY2022 Current Rollforward Amended Budget Amendment Budget Beginning Fund Balance 1,254,102 750,000 2,004,102 40001:Property Taxes 57,000 57,000 42001:lnterest 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:13ond Proceeds - 500,000 500,000 Revenue Total 4,079,122 500,000 4,579,122 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,7611 Contingency Reserve Debt Service Reserve Reserves Total 342,905 342,905 186,458 186,458 529,363 - 529,363 Available Fund Balance 1 249,398 - 249,398 FY2022 Current Rollforward Amended Budget Amendment Budget Beginning Fund Balance 32,262,067 6,654,998 38,917,065 40002:Sales Taxes 5,000 - 5,000 41002: Penalties 600,000 600,000 42001:lnterest 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:13ond Proceeds 8,461,500 3,500,000 11,961,500 Revenue Total 103,050,645 3,500,000 106,550,645 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 1 8,053,402 10,361,601 18,415,002 Expense Total 98,690,327 10,210,634 108,900,960 Ending Fund Balance 1 36,622,385 (55,636) 36,566,750 Operating Contingency Reserve Rate Stabilization Reserve Non -Operating Reserve Transformer Reserve Reserves Total 6,426,561 6,426,561 18,600,000 18,600,000 6,049,061 6,049,061 4,069,154 4,069,154 35,144,776 - 35,144,776 Available Fund Balance 1 1,477,609 (55,636) 1,421,974 Stormwater Services I FY2022 Budget Amendment Budget Beginning Fund Balance 1 2,301,927 1,040,847 3,342,774 41002:Penalties 42001:lnterest Income 43605:Stormwater Charges 46001:13ond Proceeds Revenue Total CC0001 Non -Departmental CC0802 Public Works CC0845 Stormwater Expense Total 32,000 32,000 6,800 6,800 3,922,000 3,922,000 500,000 500,000 4,460,800 - 4,460,800 855,920 - 855,920 - 300,000 300,000 4,050,744 744,582 4,795,326 4,906,663 1,044,582 5,951,246 Ending Fund Balance 1 -1,856,064 (3,735) 1,852,328 Contingency Reserve Debt Service Reserve Reserves Total 413,189 413,189 486,959 486,959 900,148 - 900,148 Available Fund Balance 1 955,916 (3,735) 952,180 41002:Penalties 315,000 315,000 41602:Impact Fees 31,890,000 - 31,890,000 42001:lnterest 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 I - 115,000 115,000 Revenue Total 110,251,240 140,115,000 250,366,240 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 I 59,293,447 (49,184) 59,244,263 Contingency Reserve Non -Operating Revenue Impact Fee Reserve Reserves Total 10, 613,110 110,761 10, 723, 871 10,000,000 10,000,000 3,190,000 3,190,000 23,803,110 110,761 23, 913,871 Available Fund Balance 35,490,337 (159,945) 35,330,3 9=2 _! i P ? 7 1 it 011 a,;:.i.",°-. 120 General Capital Projects CC0001 Non -Departmental PRJO00124 Radio Replacement CC0001 Non -Departmental Total CCO211 Parks PRJ000048 Garey Park PRJO00125 Parks Master Plan PRJ000126 Regional Trail Development PRJ000129 Ada Transition Plan PRJ000190 Heritage Gardens PRJ000240 South Main Plaza PRJ000293 San Gabriel Park - Phase 3 CCO211 Parks Total CC0302 Finance Administration PRJ000038 ERP Project CC0302 Finance Administration Total CC0319 Facilities PRJ000178 Public Safety Operation and Training Center Phase II PRJ000179 Recreation Center Teen/Senior Renovation PRJ000180 Recreation Center Natatorium HVAC Replacement PRJ000191 Georgetown City Center - Festival/Public Space CC0319 Facilities Total CC0402 Fire Support Services/Administration PRJ000134 SCBA Replacement CC0402 Fire Support Services/Administration Total CC0526 Systems Engineering PRJ000137 Intersection Improvements (Lakeway @ Williams Drive) PRJ000138 Downtown Sidewalks PRJ000188 DB Wood (SH 29 to Oak Ridge) PRJ000214 Intersection Improvements (Traffic Signals) PRJ000215 2021 Intersection Safety Enhancements (RRFB) PRJ000216 FY21 Downtown Sidewalk Improvements PRJ000217 SW Bypass - Wolf Ranch Extension PRJ000254 Shell Road PRJ000255 Rockride Lane PRJ000256 Westinghouse Road PRJ000257 Sam Houston Ave Ext/SE1/Wilco Corridor PRJ000267 Allocations - Intersections/Bike Lanes/Sidewalks - MB21 PRJ000297 Southeast Inner Loop - MB21 CC0526 Systems Engineering Total 184,059 184,059 246,480 92,115 1,186,449 606,131 212,050 2,725 63,870 2,409,820 336,126 336,126 4,485,310 215,525 32,454 50,960 4,784,249 870,000 870,000 1,606,630 768,190 2,896,980 1,061,957 96,400 986,350 1,741,431 3,005,000 5,776,000 8,200,000 4,000,000 1,700,000 3,000,000 34,838,938 CCO533 Environmental Services PRJ000116 Transfer Station 10,217,969 CCO533 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 1 190,174 CC0602 Administrative Services Total 2,276,859 CC0702 Police Administration PRJ000133 Body Cameras 62,588 CC0702 Police Administration Total 62,588 CCO802 Public Works PRJ000139 Westinghouse - Scenic Lake Traffic Signal 265,937 PRJ000140 Austin Ave Bridges 2,343,66S 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 CCO846 Streets PRJ000202 FM 971 570,715 CCO846 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 CCO802 Public Works Total 2,875,899 203 Street Tax Total 2,875,899 402 GTEC - Projects CCO500 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 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 CCO557 Electrical Engineering PRJ000189 Ronald Reagan - Glasscock Feeder Extension along Hwy 195 -Phase 1 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 612 Electric Services - Projects Total 6,626,230 642 Stormwater Services - Projects CC0802 Public Works PRJ000149 Drainage Improvement/Flood Mitigation Projects 300,000 CCO802 Public Works Total 300,000 CCO845 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 CCO845 Stormwater Total 740,847 642 Stormwater Services - Projects Total 1,040,847 662 Water Services - Projects CCO524 Metering Services PRJ000220 AMI Western District Improvements 750,000 CCO524 Metering Services Total 750,000 CCO526 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 CCO526 Systems Engineering Total 82,005,749 CC0553 Water Operations PRJ000023 Cr 255 (Wd14-2) PRJ000059 LWTP Raw Water Intake Rehab PRJ000066 Park Lift Station & Force Main PRJ000096 Shell Road Water Line PRJ000119 Water Mains CC0553 Water Operations Total 662 Water Services - Projects Total Grand Total 1,817,359 268,618 1,554,712 6,018,091 931,123 10,589,904 95,345,6:53 1 192,672,914 100 General Fund I ' CC0001 Non -Departmental FY22 CIP-RF: Double Tap Agreement 16,185 FY22 CIP-RF: Vehicles for K9 Unit - 255,000 FY22 CIP-RF: Water & Fire New Employee IT Equipment - 18,000 CC0001 Non -Departmental Total 16,185 273,000 CC0107 Planning FY22 CIP-RF: Engineering Planning Re-Org FY22 CIP-RF: Operational Rollforward CCO107 Planning Total CCO211 Parks FY22 CIP-RF: Standby Stipend Increase CCO211 Parks Total CCO218 Arts and Culture FY22 CIP-RF: Art Mural Program FY22 CIP-RF: Operational Rollforward CCO218 Arts and Culture Total CC0402 Fire Support Services/Administratioi FY22 CIP-RF: Operational Rollforward FY22 CIP-RF: Standby Stipend Increase CC0402 Fire Support Services/Administration T CC0422 Fire Emergency Services FY22 CIP-RF: Operational Rollforward CC0422 Fire Emergency Services Total CC0602 Administrative Services FY22 CIP-RF: Employee Engagement Survey FY22 CIP-RF: Operational Rollforward CC0602 Administrative Services Total CC0638 General Government Contracts FY22 CIP-RF: Engineering Planning Re-Org FY22 CIP-RF: Vehicles for K9 Unit FY22 CIP-RF: Water & Fire New Employee 11 CC0638 General Government Contracts Total CC0655 Communications/Public Engagemen FY22 CIP-RF: Operational Rollforward CC0655 Communications/Public Engagement T CC0742 Police Operations FY22 CIP-RF: Dispatch Shift Differential FY22 CIP-RF: Operational Rollforward FY22 CIP-RF: Standby Stipend Increase CC0742 Police Operations Total CC0744 Animal Services FY22 CIP-RF: Standby Stipend Increase CC0744 Animal Services Total 15.000 I r_ nnn 325,000 124,983 449,983 4,527 4,527 15,000 6,150 21,150 577 3,678 4,256 258,828 258,828 22,000 36,000 58,000 (325,000) (255,000) (18,000) (598,000) 12,000 12,000 37,000 57,245 13,581 107,826 3,615 3,615 CC0846 Streets FY22 CIP-RF: Standby Stipend Increase CC0846 Streets Total 100 General Fund Total 120 General Capital Projects CC0001 Non -Departmental FY22 CIP-RF: Capital Project Rollforward FY22 CIP-RF: Fire Truck Cost Increase CC0001 Non -Departmental Total CCO211 Parks FY22 CIP-RF: Capital Project Rollforward CCO211 Parks Total CC0302 Finance Administration FY22 CIP-RF: Capital Project Rollforward CC0302 Finance Administration Total CC0319 Facilities FY22 CIP-RF: Capital Project Rollforward CC0319 Facilities Total CC0402 Fire Support Services/Administra FY22 CIP-RF: Capital Project Rollforward CC0402 Fire Support Services/Administratic CCO526 Systems Engineering FY22 CIP-RF: Capital Project Rollforward CC0626 Systems Engineering Total CCO533 Environmental Services FY22 CIP-RF: Capital Project Rollforward CCO533 Environmental Services Total CC0602 Administrative Services FY22 CIP-RF: Capital Project Rollforward CC0602 Administrative Services Total CC0702 Police Administration FY22 CIP-RF: Capital Project Rollforward CC0702 Police Administration Total CC0802 Public Works FY22 CIP-RF: Capital Project Rollforward CCO802 Public Works Total CCO846 Streets FY22 CIP-RF: Capital Project Rollforward CCO846 Streets Total 14,984 14,984 31,185 610,169 184,059 47,440 231,499 2,409,820 2,409,820 336,126 336,126 4,784,249 4,784,249 870,000 870,000 34,838,938 34,838,938 10,217,969 10,217,969 2,276,859 2,276,859 62,588 62,588 12,385,811 12,385,811 570,715 570,715 120 General Capital Projects Total 47,440 r 68,984,574 201 Tourism CC0001 Non -Departmental FY22 CIP-RF: Double Tap Agreement CC0001 Non -Departmental Total CCO208 CVB FY22 CIP-RF: Operational Rollforward CCO208 CVB Total 201 'Tc urism Total 203 Street Tax CC0802 Public Works FY22 CIP-RF: Capital Project Rollforward FY22 CIP-RF: Memorial Drive CC0802 Public Works Total 203 Street'Tax ':Total 209 PEG Fee CC0666 Communications/Public Engagement FY22 CIP-RF: Operational Rollforward CC0655 Communications/Public Engagement Total 209 PEG Fee Total 221 Library CCO210 Library FY22 CIP-RF: Operational Rollforward CCO210 Library Total 221 Library Total 228 Tree Fund CCO211 Parks FY22 CIP-RF: Operational Rollforward CCO211 Parks Total 228 Tree Fund Total 231 Parks - Restricted CCO211 Parks FY22 CIP-RF: Operational Rollforward CCO211 Parks Total 231 Parks - Restricted Total 234 Parkland Dedication CCO211 Parks FY22 CIP-RF: Operational Roll CCO211 Parks Total 234 Parkl'atrtl, D'atiicatlon T©tal 269 Police Forfeitures - State 16,185 16,186 27,868 27,868 44,063 2,875.899 3,100,000 5,975,899 61,9176,189$ 4,348 4,348 4,348 84,510 84,610 84,510 2,195 2,196 2,195 196,272 196,272 196,272 283,737 283,737 283,737 CC0742 Police Operations FY22 CIP-RF: Police Forfeitures P CC0742 Police Operations Total 269 Police Forfeitures - State Total 278 American Rescue Plan CC0605 Community Services FY22 CIP-RF: ARPA - Rapid COV CC0605 Community Services Total 278 American Rescue Plan Total 350 Village PID CCO211 Parks FY22 CIP-RF: Operational Rollforward CCO211 Parks Total 360 Village PID Total 402 GTEC - Projects CC0500 GTEC FY22 CIP-RF: Capital Project Rollforward CC0500 GTEC Total 402 GTEC - Projects Total 500 Facilities Maintenance Fund CC0319 Facilities FY22 CIP-RF: Standby Stipend Increase CC0319 Facilities Total 500 Facilities Maintenance Fund Total 520 Fleet Services Fund CC0001 Non -Departmental FY22 CIP-RF: Fire Truck Cost Increase FY22 CIP-RF: Vehicles for K9 Unit CC0001 Non -Departmental Total 50,000 50,000 60,000 72,000 72,000 72,000 51,500 61,500 51,600 - 16,201,742 16,201,742 16,201,742 47,440 255,000 302,440 2,942 2,942 2,942 CC0320 Fleet FY22 CIP-RF: Capital Project Rollforward - 2,895,410 FY22 CIP-RF: Fire Truck Cost Increase - 47,440 FY22 CIP-RF: Operational Rollforward - 63,896 FY22 CIP-RF: Standby Stipend Increase - 5,433 FY22 CIP-RF: Vehicles for K9 Unit - 255,000 CC0320 Fleet Total - 3,267,180 520 Fleet Services Fund Total 302,440 3,267,180 640 Joint Service Fund CC0001 Non -Departmental FY22 CIP-RF: Customer Care Re-Org (449,200) - FY22 CIP-RF: Engineering Planning Re-Org (325,000) - FY22 CIP-RF: Water Conservation Roll Forward Transfer - 115,000 CC0001 Non -Departmental Total CC0302 Finance Administration FY22 CIP-RF: Operational Rollforwarc CC0302 Finance Administration Total CC0321 Customer Service FY22 CIP-RF: Customer Care Re-Orc FY22 CIP-RF: Operational Rollforwarc FY22 CIP-RF: Standby Stipend Increa CC0321 Customer Service Total CC0322 Billing FY22 CIP-RF: Customer Care Re-Orc CC0322 Billing Total CC0323 Data Analytics & Administrati FY22 CIP-RF: Customer Care Re-Orc CC0323 Data Analytics & Administration CC0623 Real Estate FY22 CIP-RF: Engineering Planning F CC0523 Real Estate Total CC0526 Systems Engineering FY22 CIP-RF: Engineering Planning F CC0526 Systems Engineering Total CC0534 Conservation FY22 CIP-RF: Customer Care Re-Orc CC0534 Conservation Total 640 Joint Service Fund Total 570 Information Technology Fund CC0001 Non -Departmental FY22 CIP-RF: Water & Fire New Employee IT Equipment CC0001 Non -Departmental Total CC0648 IT Fiber FY22 CIP-RF: Operational Rollforward CC0648 IT Fiber Total CC0651 IT Infrastructure FY22 CIP-RF: Operational Rollforward FY22 CIP-RF: Standby Stipend Increase T CC0651 IT Infrastructure Total CC0652 IT Management FY22 CIP-RF: Operational Rollforward FY22 CIP-RF: Water & Fire New Employee IT Equipment CC0652 IT Management Total 570 Information Technology Fund Total 36,000 36,000 0 0 36,000 116,000 25,000 25,000 (5,908,133) 1,598 1,414 (6,905,121) 1,304,610 1,304,610 4,801,286 4,801,286 254,820 254,820 (579,820) (579,820) (646, 963) (646,963) (631,188) 75,000 75,000 15,000 3,621 18,621 35,000 36,000 71,000 164,621 602 Airport Operations - Projects CC0001 Non -Departmental FY22 CIP-RF: Airport Maintenance Facility Cost Increase 500,000 - CC0001 Non -Departmental Total 500,000 - CC0636 Airport FY22 CIP-RF: Airport Maintenance Facility Cost Increase - 500,000 FY22 CIP-RF: Capital Project Rollforward - 750,000 CC0636 Airport Total - 1,250,000 602 Airport Operations - Projects Total -,� Y 500,000 1,250,000 610 Electric Services CC0001 Non -Departmental FY22 CIP-RF: Electric New Development CC0001 Non -Departmental Total CC0520 Electric Safety & Employee Deve FY22 CIP-RF: Electric Reorg CC0520 Electric Safety & Employee Develor CC0524 Metering Services FY22 CIP-RF: Operational Rollforward CC0524 Metering Services Total CC0525 T&D Services _ FY22 CIP-RF: Electric Reorg FY22 CIP-RF: Standby Stipend Increase CC0525 T&D Services Total CC0556 Electric Systems Operations FY22 CIP-RF: Standby Stipend Increase CC0555 Electric Systems Operations Total CC0557 Electrical Engineering FY22 CIP-RF: Electric Reorg CC0557 Electrical Engineering Total 610 Electric Services Total 612 Electric Services - Projects CC0001 Non -Departmental FY22 CIP-RF: Electric New Development Increase CC0001 Non -Departmental Total CC0657 Electrical Engineering FY22 CIP-RF: Capital Project Rollforward FY22 CIP-RF: Electric New Development Increase CC0557 Electrical Engineering Total 612 Electric Services - Projects Total 640 Stormwater Services CC0845 Stormwater FY22 CIP-RF: Standby Stipend Increase 3,500,000 3,500,000 3,500,000 35,000 35,000 397,325 397,325 28,768 28,768 (632,696) 16,675 (616,021) 3,961 3,961 235,371 235,371 84,404 6,626,230 3,500,000 10,126,230 10,126,230 3,735 CC0845 Stormwater Total 640 Stormwater Services Total 642 Stormwater Services - Projects CC0802 Public Works FY22 CIP-RF: Capital Project Rollforward CC0802 Public Works Total CC0845 Stormwater FY22 CIP-RF: Capital Project Rollforward CC0845 Stormwater Total 642 Stormwater Services - Projects Total 660 Water Services CC0001 Non -Departmental FY22 CIP-RF: Water & Fire New Employee IT Equipment FY22 CIP-RF: Water Conservation Roll Forward Transfer CC0001 Non -Departmental Total CC0527 Water Services Administration FY22 CIP-RF: Customer Care Re-Org FY22 CIP-RF: Operational Rollforward FY22 CIP-RF: Water Conservation Re-Org CC0527 Water Services Administration Total CC0528 Water Distribution FY22 CIP-RF: Operational Rollforward CC0528 Water Distribution Total CC0529 Water Plant Management FY22 CIP-RF: Operational Rollforward FY22 CIP-RF: Standby Stipend Increase FY22 CIP-RF: Water Conservation Re-Org CC0529 Water Plant Management Total CC0531 Wastewater Plant Management FY22 CIP-RF: Operational Rollforward FY22 CIP-RF: Standby Stipend Increase CC0531 Wastewater Plant Management Total CC0534 Conservation FY22 CIP-RF: Customer Care Re-Org FY22 CIP-RF: Operational Rollforward FY22 CIP-RF: Water Conservation Re-Org CC0534 Conservation Total CC0553 Water Operations FY22 CIP-RF: Standby Stipend Increase FY22 CIP-RF: Water Conservation Re-Org CC0553 Water Operations Total 115,000 115,000 3,736 3,735 300,000 300,000 740,847 740,847 1,040,847 18,000 18,000 (449,200) 45,806 (146,484) (649,878) 429 429 69,397 3,511 (98,176) (25,268) 16,534 3,511 20,046 449,200 115,000 440,832 1,005,032 _ 24,163 (196,172) (172,009) 660 Water Services Total 115,000 296,352 662 Water Services - Projects CC0001 Mon -Departmental FY22 CIP-RF: Southlake WTP CC0001 Mon -Departmental Total CC0524 Metering Services FY22 CIP-RF: Capital Project Rollforward CC0524 Metering Services Total CC0626 Systems Engineering FY22 CIP,-RF: Capital Project Rollforward FY22 CIP-RF: Southlake WTP CC0526 Systems Engineering Total CC0563 Water Operations FY22 CIP-RF: Capital Project Rollforward CC0653 Water Operations Total 662 Water:S'erv:lces - Projects Total 140,000,000 140,000,000 750,000 750,000 82, 005, 749 140,000, 000 222,005,749 10,589, 904 » 10,689,904 140MG,000 233,346,663 Grand Total 143,767,865 341,511,772 100 General Fu CC0107 Plan Assistant Developm Engineerin Housing C Landscape Managem Neighborh Planner Planning A Planning D Planning S Principal PI Senior Plan CC0107 Plannin CCO202 Park Administrat Parks & Re CCO202 Parks CCO210 Libr Accounting Administrat Assistant Li Community Librarian Library Aid Library Ass Library Se Marketing Senior Libr Senior Libr CCO210 Library CCO211 Park Assistant P Business A Parks Main Parks Main Parks Sup Project Ma Senior Par Urban Fore Parks & Re CCO211 Parks T CCO212 Recr Administrat Aquatics M Aquatics S Aquatics S Business A Challenge Office Spec Recreation Recreation Recreation Recreation Senior Rec Senior Rec Special Ev Youth Adve CCO212 Recreat Amendment 2022 Amended FY2020 1 IChanger. CCO213 Tennis Center Tennis Center Assistant Tennis Center Specialisl Tennis Professional CCO213 Tennis Center Total CCO214 Recreation Programs Recreation Assistant Senior Recreation Assistant CCO214 Recreation Programs Total CCO215 Garay Park _ Event Coordinator Croup Sales i Servicing Coordinator Marketing Events Specialist Parks Maintenance Foreman Parks Maintenance Worker Recreation Assistant Recreation Program Coordinator Recreation Specialist Senior Parks Maintenance Worker CCO215 Garay Park Total CCO218 Arts and Culture Arts & Culture Coordinator CCO218 Arts and Culture Total CC0316 Municipal Court Associate Deputy Court Clerk Deputy Court Clerk Municipal Court Administrator _ Municipal Court Judge Municipal Court Supervisor Senior Deputy Court Clerk CCO316 Municipal Court Total CC0402 Fire Support Services/Administration Administrative Assistant Assistant Fire Chief _ Battalion Chief R Business Analyst Deputy Fire Marshal Division Chief E-mergency Management Coordinator Executive Assistant (Sup) Fire and Life Safety Specialist Fire Captain Fire Chief Fire Lieutenant Fire Marshal Fire Protection Engineer Logistics Coordinator -' Paramedic II CC04012 Fire Support Services/Administration Total CC0422 Fire Emergency Services _ Battalion Chief Fire and Life Safety Specialist Fire Captain Fire Driver Fire Lieutenant _ Firefighter Paramedic II Quality Improvement and Compliance -Coordinator CC0422 Fire Emergency Services Total i 1.50 L 1.00 I 1.00 3.50 4.50 0.50 5.00 - 1.00 - 1.00 1.00 _ 1.50 1.00 _ 1.00 _ 1.00 7.50 i _ 1.50 1.00 1.00 - 3.60 4.00 f - 4.00 _ 1.00 _ 1.00 1.00 I 1.50 1.00 1.00 3.50 4.00 _ - 4.00 1.00 1.00 1.00 1.50 1.00 1.00 1.00 7.50 1.00 1.50 1.00 1.00 3.50 4.00 - 4.00 1.00 1.00 1.00 1.50 1.50 1.00 1.00 1.00 7.50 _ 1.00 1.00 1.00 ' 7.50 0.50 0.50 2.00 1.00 1.00 0.50 1.00 1.00 6.50 ! 0.50 0.50 2.00 _ 1.00 _ _ 1.00 . 0.50 1.00 . 1.00 6.50 1.00 1.00 1.00 T2.00 2.00 _ _1.00 1.00 _ 0.50 _ _ _ _ _ _ 1.00 1.00 _ 0.50 _ 1.00 1.00 5.50 1.00 2.00 1.00 1.00 2.00 1.00 1.00 5.00 5.50 _ 1.00 1.00 1.00 2.00 2.00 2.00 2.00 1.00 1.00 - 1.00 - 2.00 2.00 - 1.00 1.00 - _. - 1.00 5.00 1.00 1.00 . - 1.00 1.00 _ I� 2.00 1 �_ 1.00 _ 21.00 - - 1.00 1.00 - 4.00 3.00 1.00 1.00 1.00 1.00 - 1.00 _ 1.00 _ 1.00 1.00 18.00 f 1.00 - 1.00 1 1.00 2.00 1.00 _ 21.00 3.00 - 14.00 21.00 10.00 67.00 2.00 - 117.00 3.00 - 1.00 1.00 15.00 3.00 - _ 6.00 23.00 j 15.00 1 59.00 - 3.00 3.00 1 I 14.00 _ 21.00 1 10.00 _ 67.00 2.00 - 117.00 1 - 13.00 21.00 10.00 60.00 2.00 - - 106.00 109.00 CC0448 EMS - 1.00 1.00 } 1.00 Fire Driver 22.00 21.00 21.00 Firefighter 21.00 - - 2.00 2.00 Paramedic II 2.00 1.00 - Quality Improvement & Compliance Coordinator - 23.00 24.00 24.00 CC0448 EMS Total 24.00 CC0536 Inspection Services 1 Assistant Chief Building Official 1.00 _ 1.[10 1.00 1.00 Building Inspector 3.00 5.00 5.00 5.00 Building Plans Examiner 2.00 - 4.00 4.00 4.00 Chief Building Inspector Chief Building Official _ 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 Chief Plans Examiner _ 1.00 1.00 1.00 1.00 Combination Building Inspector 3.00 2.00 2.00 2.00 Permit Technician 3.00 4.00 4.00 4.00 CC0536 Inspection Services Total 15.00 . _ 19.00 M 19.00 i _ 19.00 CC0602 Administrative Services Administrative Assistant - 1.00 1.00 1 1.00 Assistant City Manager _ 3.00 3.00 3.00 i 3.00 _ _ Assistant to the City Manager _ _ _ 1.00 1.00 1.00 1 1.00 CIP Manager 1.00 - - - City Manager 1.00 1.00 1.00 1.00 Contract Administrator 1.00 i 1.00 1.00 1.00 Executive Assistant _ _ 1.00 1 1.00 f 1.00 1.00 Executive Assistant 1.00 - Executive Assistant (Sup) 1.00 I 1.00 1.00 1.00 Mail Courier 1.00 1.00 1.00 1.00 Management Analyst _ 1.00 1.00 - - CC0602 Administrative Services Total 12.00 11.00 10.00 10.00 CC0605 Community Services 1�00 1.0.0 Community Services Director 1.00 1.00 1.4R. I _ 1.00 _ _ _ _ Emergency Management Coordinator 1.00 2.00 2.M CC0605 Community Services Total 2.00 2.00 CC0635 City Secretary Services _ 1.00 Administrative Assistant 1-00 1.001 1.00 Assistant City Secretary 1.00 _ 1.00 1.00 1.00 1.00 City Secretary 1-00 1.00 1.00 1.00 Open Records Coordinator 1.00 _ 2.00 2.00 2.00 Records Management Analyst 2.00 2.00 2.00 6.00 CC0635 City Secretary Services Total 6.00 �^ 7.00 7.00 CC0655 Communications/Public Engagement _ _- 1.00 Communications and Public Engagement Director 1.00 1.00 �_ 1.00 Multimedia Specialist 1.00 1.00 1.00 1.00 1.00 Public Communications Manager Public Engagement Coordinator Social Media and Marketing Coordinator 1.00 1.00 1.00 1.00 1 1� 1.00 1 I� 1A6 J 1.00 1.00 1.00 - 1.00 Website Content Specialist - - 1 1,00 _ _ 1.00 4.00 CC0655 Communications/Public Engagement Total 5.00 6.00 6.00 CC0702 Police Administration Assistant Police Chief 1.00 1.00 1.0-0 1.00 Executive Assistant 1.00 T 1.00 1.00 l 1.00 _ Police Chief _ 1.00 1.00 _ 1 A0 1.00 Public Safety Information Specialist CC0702 Police Administration Total _ 1.00 4.00 1.00 4.00 1.00 J 4.06 I 1.00 4.00 CC0742 Police Operations Administrative Assistant 1.00 - _ 1.00 - Crime Scene Specialist 1.00 _ 1.00 _ 1.00 1.00 Criminal Intelligence Analyst _ 1,00 1,00 _ 1.00 1.00 Criminal Investigations Detective Emergency Communications Manager _ i 1.00 1.00 1.00 - 1.00 1.00 1.00 Emergency Communications Operator 11.00 3.00 3.00 _ 3.00 - 2.00 E=mergency Communications Operator Trainee 2.00 , 2.00 Emergency Communications Supervisor 4.00_I 4.00 ' _ 4.00 4.00 Parking Enforcement Officer 1.00 1.00 1.00 1.00 Police Captain _2.00 T 2.00 2.00 2.00 9.00 Police Lieutenant 9.00 9.00 9.00 Police Officer 62.00 66.00 _ _ 66.00 64.00 Police Records Specialist 2.00 2.00 3.00 _ 3.00 Police Records Supervisor 1.00 1.00 1.00 1.00 Police Sergeant _ 14.00 14.00 14.00 14.00 Property & Evidence Control Technician 1.00-1- 1.00 1.00 _ 1.00 Public Safety Volunteer Program Coordinator 0.50 0.50 0.50 0.50 Senior Emergency Communications Operator 5.00 11.00 11.00 11.00 1.00 Victim Services Coordinator 1.00 1.00 1.00 CC0742 Police Operations Total 116.50 118.50 123.50 123.50 CC0744 Animal Services Animal Care Supervisor 1.00 1.00 T 1.00 �. 1.00 Animal Control Officer 3.00 3.00 3.001 3.00 _ Animal Control Supervisor Animal Health Technician _ 1.00 2.00 •_ 1.00 2.00 I ! 1.00 1 1 2.001 1.00 2.00 Animal Services Manager Animal Services Marketing Coordinator _ 1.00 2.00 i 1.00 2.00 1.00 i 2.00 1 _ 1.00 2.00 Animal Shelter Technician 1.50 1.50 1.501 1.50 Office Assistant - - - - Veterinarian _ _ _ - 0.50 0.50 0.50 CCO744 Animal Services Total 11.50 _ 12.00 1- 12.00 12.00 C:C0745 Code Compliance Chief Code Enforcement Officer Code Enforcement Officer 1.00 _ 1.00 5.00 5.00 1.00 5.00 1.00 5.00 CCO745 Code Compliance Total 6.00 ! 6.00 _ 6.00 6.00 CCO802 Public Works Administrative Assistant 1.00 1.00 1.00 1.00 _ Environmental Services Program Coordinator Public Works Director 1.00 _ 1.00 1.00 ' 1.00 1.00 I 1.00 1.00 _ 1.00 _ Public Works Engineer - Engineer In Training 1.00 ; 1.00 1.00 I 1.00 _ Transportation Planning Coordinator _ _ _ 1.00 i _ 1.00 1.001 _ 1.00 CCO802 Public Works Total 5.00 5.00 5.00 5.00 CC0846 Streets Assistant Director of Public Works - - 1.00 1.00 Business Systems Analyst 1.00 1.00 1.00 1.00 3.00 4.00 4.00 Heavy Equipment Operator 4.00 9.00 9.00 9.00 Light Equipment Operator 9.00 1.00 - Paving Foreman - I 1.00 1.00 1.00 Public Works Operations Manager _ 1.00 - 1.00 1.00 Public Works Planner Scheduler _ 1.00 2.00 4.00 4.00 Sign & Signal Field Technician 4.00 Streets Foreman 2.00 2.00 _ 2.00 _ 2.00 Streets Maintenance Worker - - - CC0846 Streets Total _ 19.00 22.00 23.00 23.00 100 General Fund Total 448.50 467.00 487.50 -7 1 487.50 201 TOUIUM j• _ CCO208 CVB Tourism & CVB Manager 1.00 1.00 1.00 T 1.00 2.00 2.00 Tourism Coordinator 2.00 2.00 Tourism Coordinator (Sup) 1.00 1.00 1.00 1.00 , Visitor Information Specialist 1.00 1.00 1.00 1.00 5.00 CCO208 CVB Total 5.00 5.00 5.00 241 Tourism Total 5100 T 5.00 500 Facilities Maintenance Fund t CC0319 Facilities Building Maintenance Technician Facilities Coordinator Facilities Director Facilities Foreman Facilities Manager Senior Building Maintenance Technician CC0319 Facilities Total 500 Facilities MainlenapiGe Frond Total 520 Fleet Services Fund CC0320 Fieet Fleet Services Ma{-IatieF Lead Mechanic Master Mechanic .... _........ - Mechanic Office Specialist CCO320 Fleet Total 1 520 ffeet-iftrArev IF:OW Tat 540 Joint Service Fund CCO302 Finance Administration Administrative Assistant Assistant Finance Director Budget Analyst _ Budget Manager Business Systems Analyst Finance Director Senior Budget Analyst Treasurer CC0302 Finance Administration Total CC0315 Accounting Accountant Accounting Specialist Accounting Specialist Supervisor Assistant Controller Assistant Finance Director Controller _ E=RP Applications Administrator Payroll Specialist Senior Accountant Senior Accounting Specialist CC0315 Accounting Total CC0317 Purchasing Buyer Purchasing Assistant Purchasing Manager Senior Buyer Senior Warehouse Worker Support Services Manager _ Warehouse Coordinator Warehouse Supervisor Warehouse Worker CC0317 Purchasing Total CCO502 Georgetown Utility Administration Administrative Assistant Business Process Consuitant Executive Assistant Office Specialist Records Specialist General Manager Utilities Utility Department General Manager 2.00 1.00 1.00 1.00 1.00 6.00 2.00 1.00 1.00 1.00 1.00 1.00 7.00 zxa 3.00 3.00 1.06 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 8.00-1 8.00 mo Bets { 1.00 1.00 _ 1.00 1 1.00 6.00 6.00 - 1.00 1.00 1.00 1.00 10.00 10.00 �'�Y.fIE.•. WSESO 1.00 1.00 6.00 1.00 1.00 10.00 ua.v 1.00 �� 1.00 1 _ 6.06 1.00 _ 1.00 ! 10.00 U 1.00 1.00 1.00 1.00 - 1.00 1.00 1.00 2.00 1.00 1.00 _ 1.00 1.00 - - 1.00 1 1.00 1.00 1.00 - 1.00 1.00 1.00 6.00 6.00 1.00 ! 1.00 2.00 i 3.00 1.00 ! 1.00 1.00 j 1.00 1.00 1.00 1.00 1.00 6.00 I 1.00 3.00 1.00 1.00 1.00 - 1.00 6.00 1.00 3.00 1.00 1.00 1.00 ! 1.00 2.00 3.00 1.00 14.00 1 1.00 1.00 1.00 2.00 v 2.00 1.00 - 100 1.00 - 1.00 1.00 1.00 1.00 3.001 3.00 1.00 1.00 12.00 13.00 i I 1.00 1.00 1.00 1.00 1.00 i 1.00 1.00 ` 2.00 - [ 2.00 1.00 1.00 1.00i - - 1.00 1.00 2.00 - 9.00 9.00 1.00 2.00 3.00 1.00 14.00 1.00 1.00 1.00 2.00 2.00 1.00 1.00 9.00 9.00 CC0502 Georgetown Utility Administration Total CC0503 Organizational and Operational Excellence Business Improvement Program Manager Business Process Analyst Performance Management Program Manager CC0503 Organizational and Operational Excellence Total CC0526 Systems Engineering Administrative Assistant Building Inspector CIP Manager (Sup) Contract Coordinator Inspection Supervisor Master Inspector Project Manager Public Improvement Inspector Real Estate Services Coordinator Real Estate Services Manager Senior Public Improvement Inspector Systems Engineering Director Transportation Engineer _ Utilities Engineer - Professional Engineer _ Utility Coordinator Utility Systems Info Manager Water Utility Engineer CC0526 Systems Engineering Total CC0534 Conservation Energy Auditor/Coordinator Marketing Data Analyst Public Engagement Coordinator Utilities Conservation Coordinator CC0534 Conservation Total CC0547 Business System Services Business Systems Analyst GIS Analyst 1 GIS Analyst II IT Supervisor Senior Systems Analyst Systems Analyst CC0547 Business System Services Total CC0637 Economic Development Economic Development Director Economic Development Program Manager Special Events & Marketing Coordinator CC0637 Economic Development Total CC0639 Human Resources Assistant Human Resources Director Benefits & Wellness Program Administrator Business Systems Analyst Compensation & HR Analyst Human Resources Director Human Resources Generalist Human Resources Program Manager Human Resources Specialist Learning and Development Coordinator Safety & Training Specialist Safety & Training Supervisor Senior Human Resources Generalist Senior Human Resources Specialist CC0639 Human Resources Total CC0654 Legal - - 1.00 1.00 1.00 3.00 1.00 1.00 1.00 3.00 1.Oa 1.00 7:Q0 1.00 1.44 1.00 3.00 3.00 1.00 1.00 - - 1.00 _ 1.00 _ 1.00 1.00 _ 1.00 ! 1.00 1.00 _ - 2.00 4.00 _ 1.00 _ 4.00 1.00 ._ 1.00 - 1.00 6.00 3.00 1.00 1.00 1.00 _ 1.00 1.00 1.00 - - 1.00 - 1.00 1.00 2.00 - I 1.00 - 1.00 1.00 2.00 - 4.00 4.00 1.00 . 1.00 3.00 1.00 _ 1.00� _ 1.00 1.00 4.00 4.00 (1.00) = M (1.00) - 3.00 1.00 1.00 1.00 1.00 - 1.00 (2.00) 21.00 1.00 - - 1.00 _ 1.00 1.00 20.00 21.00 23.00 - - 1.00 f.00 _ _ 1.00 - (1.00) - 1.00 1.00 - - _- - 3.00 1.00 _ 1.00 _ 1.00 _ 1.00 - 3.00 1 - 1.00 - 1.00 - 3.00 - _ 10.00 _ I 1.00 1.00 2.00 1 2.00 1.00 1 1.00 4.00 4.00 T� 1.00 1.00 1.00.- 1.00 - - _ 1.00 1.00 1 1.00 _ 2.00 ! 1.00 1.00 _ 1.00 1.00 1 1.00 1.00 1 1.00 2.00 2.00 1.00 ' 1.00 1.00 1.00 1.00 12.00 13.00 - - - - - - - - - 1.00 2.00 1.00 4.00 1.00 2.00 1.00 4.00 1.00 _ _ 1.00 _ _ 1.00 1.00 - 1.00 1.00 1.00 _ 1.00 1.00 1.00 2.00 1.00 1.00 1.00 1.00 1.00 _ 1.00 2.00 1.00 1.00 1.00 13.00 4 l 1.00 1.00 _ 1.00 13.00 City Attol Executive Legal As'. CCO654 legal CCO523 Re Real Est, Real Est, CCO523 Real I CC0322 Bill AMI & Bil Custome Custome Developr Senior Q CC0322 Billing CC0323 Dal Administ, Business Custome Marketini CC0323 Data i CC0321 Cu: Administr Airport Bi AMI & Bil Business Customer Customer Custome Customej Developn Senior Ct CC0321 Custo City Attorney ley Assistant (Sup) ,istant Total d Estate ite Services Coordinator 2.00 1.001� 1.00 1.00 5.00 �� 2.00 1.00 1.00 1.00 �� 5.00 3.00 i 1.00 1.00 _ 1.00 6.001 3.00 1.00 1.00 1.00 6.00 - 1.00 1.00 ite Services Manager - - 1.00 1.00 :state Total - 2.00 2.00 ing ing Specialist Service Representative Service Supervisor lent Account Specialist istomer Service Representative 1 Total a Analytics & Administration ative Assistant Systems Analyst Care Director Data Analyst iinalytics & Administration Total - itomer Service ative Assistant isiness Operations Coordinator ing Specialist Systems Analyst Care Director Care Manager Service Representative Service Supervisor lent Account Specialist istomer Service Representative mer Service Total --- _ 4.00 - 1.00 _ - 2.00 - 2.00 - 1.00 10.00 1.00 - 2.00 - _ 1.00 - 1.00 5.00 i - (1.00) !_ 5.00 (4.00)1 2.00 (2.00) (1.00) - _ 7.00 (1.00) 3.00 (2.00) 3.00 (2.00) 3.00 (1.00) 23.00 (14.00) 4.00 1.00 2.00 2.00 1.00 10.00 M 1.00 2.00 1.00 1.00 5.00 _ (1.00) 1.00 (1.00) - 6.00 1.00 1.00 2.00 9.00 _ - - - - - - - - - - 1.00 4.00 _ 1.00 1.00 1.00 2.00 3.00 3.00 9.00 25.00 - - 5.00 _ - _ - - _ 7.00 3.00 3.00 3.00 T 21.00 540 Joint Service Fund Total a - 570 Information Technology Fund CC0652 IT Infrastructure Administrative Assistant Assistant IT Director Director IT Manager IT Supervisor IT Support Specialist Lead Systems Administrator Network Administrator Public Safety Systems Analyst Senior Systems Administrator Senior Systems Analyst _ _ _ Systems Administrator _ Systems Anailyst Web Developer CC0652 IT Infrastructure Total CCO662 Applications Business Systems Analyst GIS Analyst 1 GIS Analyst II IT Manager IT Supervisor Senior Systems Analyst Systems Analyst 109.00 96.00 102.00 - - 1.00 i _~ 1.00 ' 3.00 1.00 1 1.00 1 - 2.00 102.00 1.00 1.00IT 1.00 3.00 2.00 3.00 2.00 1.00 _ 3.00 _ 2.00 2.00 2.00 1.00 1.00 25.00 - - 1.00 1.00 3.00 1.00 1.00 - 2.00 - 2.00 11.00 1 1.00 3.00 1.00 2.00 2.00 3.00 1.00 1.00 3.00 1.00 1.00 - 2.00 - - 2.00 2.00 - - - 11.00 11.00 1.00 _ 3.00 _ 1.00 2.00 2.00 3.00 1.00 3.00 - 1.00 2.00 - 2.00 - 3.00 GIS Administrator CCO662 Applications Total - CC0672 Fiber Fiber Maintenance Coordinator IT Supervisor CC0672 Fiber Total CC0682 IT Administration Administrative Assistant Assistant IT Director - IT Director IT Manager - Lead Systems Administrator - Senior Systems Analyst Systems Analyst _ - Web Developer CC0682 IT Administration Total - CC0692 IT Public Safety IT Manager Public Safety Systems Analyst CC0692 IT Public Safety Total CC0649 Applications Lead Systems Analyst CC0649 Applications Total 570 IClQ1t7tlIR8�lEtAi i��Pr1[ClsF�kaSif{¢EN•[f'TaLaf 600 Airport Operations CCO636 Airport Airport Attendant Airport Business Operations Coordinator Airport Maintenance Supervisor _ Airport Maintenance Worker _ Airport Manager CCO636 Airport Total 60G1A`btpot3 Operations Total 610 Electric Services CCO521 Electric Technical Services Fiber Infrastructure Technician Fiber Maintenance Coordinator Network Administrator SCADA I & C Technician I SCADA Supervisor Senior SCADA Technician AMI Analyst Utility Operational Technology Manager SCADA I & C Technician II CCO521 Electric Technical Services Total CCO522 Electric Administration Executive Assistant (Sup) General Manager of Electric Utilities Utilities Analyst CCO522 Electric Administration Total CC0524 Metering Services IT Manager Meter Services Manager Metering Technician Metering Technician. Trainee Senior Metering Technician Utilities Scheduler Planner 2.00 1.00 2.00 1.00 6.66 i6?W 1.00 1.00 13.00 13.00 1.00 1.00 1.00 1.00 2.00 2.00 1.00 9 1.00 1.00 1.00 1.00 1.00 1.00 'I 1.00 8.00 1.00 2.00 1.00 1.00 2.00 1.00 C 7.00 7.G0 1.00 i 1.00 1.00 1 1.00 j 1.00 1.00 1.00 1.00 8.00 1.00 91" 2.00 1.00 1.00 _ 2.00 1.00 7.00 7'roo ,. 1.00 - - _ 2.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 _ 1.00 _ 7.00 - ? - - - 1.00 I 5.00 4.00 1.00 - 1.00 1.00 1.00 1.00 3.00 U0 3.00 4.00 4.00 1.00 - - 1.00 1.00 1.00 7.00 7.00 7.00 1.00 1.00 1.00 2.00 2.00 2.00 - 1.000 1.00 1.00 1.00 1.00 2.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 8.00 1.00 3.00 4.00 1.00 1.00 3$_00 2.00 1.00 1.00 2.00 1.00 7.00 7.00 Ji 1.00 1.00 1.00 1.00 1.00 1.00 1.00 7.00 1.00 3.00 4.00 f 1.00 7.00 1.00 2.00 1.00 CC0524 Metering Services Total CC0525 T&D Services Electric Crew Leader _ Electric Journevman Lineman Electric Lineman Apprentice I Electric Lineman Apprentice II Electric Lineman ApprenticeN _ Electric Operations Manager Electric Operations Supervisor Electric Planner Scheduler Electric Pre -Apprentice Substation Protection and Control Technician Substation Technician Electric Engineering Manager Electric Safety Program Manager CCO526 T&D Services Total CCO537 Electric Resource Management Resource Plan and Integration Manager Utilities Analyst CCO537 Electric Resource Management Total CCO555 Electric Systems Operations Control Center Manager Control Center Supervisor Safety & Training Specialist _ Safety & Training Supervisor System Operator _ Utility Director _ Utility Systems Locator _ Utility Systems Operator Utility Systems Operator Trainee Line Locator Supervisor CCO555 Electric Systems Operations Total CC0557 Electrical Engineering Associate Electric Project Coordinator Electric Engineer Electric Operations Supervisor Electric Planner Scheduler Electric Project Coordinator Electric Service Delivery Supervisor Electrical Engineering Manager Systems Analyst Electric Engineering Analyst Electric Engineering Supervisor _ CCO557 Electrical Engineering Total CCO520 Electric Safety & Employee Development _ Electric Crew Leader Electric Planner Scheduler _ CCO520 Electric Safety & Employee Development Total 610 Elec-trio Servicas Total 640 Stormwater Services CCO845 Stormwater Combination Building Ins_ Crewman Drainage Foreman Heavy Equipment Opera Light Equipment Operato Stormwater Managemen T.00 E 8.00 8.00 1 2.00 10.00 - 1.00 1.00 1.00 1.00 2.00 2.00 Sam] �R Qfiti XnAm - fSDAR t CCO845 Stormwater Total 640 3to�t�ts M6.r'&terv1v#s'T4;al 12.00 12.00 12.00 12.00 4.00 4.00 4.00 _ (1.00) 3.00 9.00 9.00 9.00 _ 9.00 1.00 5.00 5.00 _ 5.00 1.00 2.00 2.00 2.00 1.00 - - - 1.00 1.00 1.00 { 1.00-1 4.00 3.00 3.00 (1.00) 2.00 3.00 3.00 3.00 (2.00) 1.00 4.00 2.00 2.00 2.00 2.00 2.00 2.00 2.00 = 1.00 1.00 1.00 - 1.00 1.00 1.00 33.00 33.00. 33.00 (4.00) 29.00 1.00 1.00 1.00 _ 1.00 2.00 2.00 2.00 2.00 3.00 3.00 4..00 . 4.00 6.00 6.00 6.00 ;6.00 _ 2.00 2.00 ` 2.00 ' 2.00 - _ 1.00 1.00 1.00 14.00 15.00 I 16.00 16.00 1.00 1.00 . 1.00 _ 1.00 1.00 1.00 _ 1.00 - - 1.00 1.00 - - 1.00 1.00 4.00 3.00 3.00 3.00 1.00 - - _ 1.00 1.00 1.00 1.00 - 1.00 1.00 1.00 - 1.00 1.00 1 1.00 T.00 E 8.00 8.00 1 2.00 10.00 - 1.00 1.00 1.00 1.00 2.00 2.00 Sam] �R Qfiti XnAm - fSDAR pector - - 1.00 1.00 _ 0.50 0.50 0.50 0.50 _ 1.00 1.00 1.00 1.00 for 1.00 1 1.00 1.00 1.00 r _ 5.00 5.00 5.00 5.00 Coordinator 1.00 1 1.00 1.00 1.00 8.50 8.50 9.50 9.50 1 3.50 11.30 9.5f1 = - - � 9.50 660 Water Services CCO527 Water Services Administration Administrative Assistant Engineer PMP Business Analyst Records Specialist Water Services Manager Water Utilities Director Code Compliance Officer Assistant Water Utilities Director CCO527 Water Services Administration Total CCO529 Water Plant Management Plant Operations Supervisor _ Plant Operations Technician Plant Operations Technician Trainee Regulatory Analyst _ Senior Plant Operations Technician Water Services Manager Water Services Technician CC0529 Water Plant Management Total CCO531 Wastewater Plant Management Plant Operations Supervisor Plant Operations Technician Plant Operations Technician Trainee Senior Plant Operations Technician CCO531 Wastewater Plant Management Total CCO534 Conservation Regulatory Analyst Social Media and Marketing Coordinator _ Utilities Conservation Coordinator CCO534 Conservation Total CCO553 Water Operations Marketing & Conservation Manager Metering Technician, Trainee Safety & Training Specialist Senior Water Services Technician Social Media and Marketing Coordinator Utilities Conservation Coordinator Utility System Locator Utility Systems Operator Water Services Manager Water Services Supervisor Water Services Supervisor Inspections Water Services Technical Specialist Water Services Technician Water Services Technician Trainee Utilities Scheduler Planner Metering Service Supervisor CCO553 Water Operations Total 660 Water Services Total Grand Total 1.00 1.00 1.00 1.00 1.00 - 1.00 - 1.00 1.00 1.00 1.00 _ 1.00 1.00 1.00 1.00 - 1,00 1.00 1.00 1.00 _ 1.00 _ 1.00 _ 1.00 1.00 7.00 1.00 8.00 1.00 1.00 2.00 _ 2.00 1.00 1.00 1.00 (1.00 9.00 9.00 1.00 1.00 4.00 4.00 19.00 (1.00) 18.00 1.00 1.00 1.00 1.00 1.00 1.00 10.00 10.00 13.00 13.00 - 1.00 1.00 1,00 1.00 1.00 1.00 - 3.00 3.00 1.00 (1.00} - 0.50 0.56 1.00 1.00 3.00 3.00 1.00 (1.00) - 1.00 (1.00) - -- 1.00 1.00 - - 1,D0 t, 00 - - - 3.00 5.00 1.00 2.00 1.00 1.00 6.00 1.00 1.00 2.00 1.00 4.00 1.00 9.00 12.00 1.00 1.00 1.00 2.00 1.00 4.00 7.00 7.00 10.00 - - - 1.00 - - - 1.00 7.00 3.00 - - 1.00 1.00 - - 1.00 1.00 1.00 1.00 1.00 6.00 6.00 6.00 6.00 1,00 - - - 3.00 3.06 _ 19.00 19.00 13.00 13.00 1.00 1.00 1.00 1.00 52.50 (3.00) 49.50 i 91.50 - 91.50 2.00 3.00 15.00 13.00 15.00 13.00 - 43.00 70.00 - 48.00 1 67.00 59.00 784.50 839.50 - 839.50