C1 — original pdf

Backup

FY2022 Proposed Budget Major Initiatives Summary Overall Budget Summary economic recovery • 62 New FTE’s - $6.4M • $15M revenue growth (2.7% increase) in FY22 driven by customer account growth and modest • Total budget requirements increase over prior year - $32.7M driven primarily by $25M increase in transfers for defeasance due to FY21 defeasance deferral EUM/Strategic Direction Category EUM - Enterprise Resiliency EUM - Infrastructure Strategy & Performance Insourcing of Contracted Services My ATX Water Water Forward EUM - Customer Satisfaction EUM – ELD Affordability – Debt Management Facility Improvements Total Proposed Positions 18 14 10 8 5 3 2 1 1 62 Total Position Cost $1,916,139 1,563,822 635,627 926,464 541,330 410,974 208,890 142,101 69,764 $6,415,110 Major Initiative Cost Drivers Infrastructure Strategy & Performance - $4.8M increase • $2.0M net increase - Pipeline Contract Services increased by $3.5M to create the Austin Water Restoration Services Division, the cost was offset by a decrease in Electric Services and $1.5M decrease in Interdepartmental Public Works Street Cuts. • $830K increase - multi-sensor inspection for large diameter main. This is a new program that will obtain condition assessment data on our large sewer pipes. Austin Water will use the inspection data collected to prioritize capital improvement projects and ensure infrastructure stability. • New Temp FTE’s (11 - $423,200) • Proposed FTE’s (14 - $1,563,821) Job Title AW Treatment O & M Tech Sr Business Process Spec Engineer B Engineer C Engineer, Graduate B IT Geospatial Technician Total 1 Proposed Positions 5 1 4 2 1 1 14 Total Position Cost $ 46,154 103,035 534,475 284,202 120,317 75,638 $1,563,821 FY2022 Proposed Budget Major Initiatives Summary Enterprise Resiliency ($2.74M increase) • New Temp FTE’s (2 - $133,536) • Proposed FTE’s (18 - $1,916,139) Job Title Administrative Senior Administrative Specialist AW Electrician II AW SCADA Analyst AW Treatment O & M Tech Sr Business Process Consultant Sr Business Process Spec Engineer C Internal Auditor III Inventory Planner II IT Business Systems Analyst Sr Ocptnl Health & Safety Spec Sr Ofcr, Emergency Plans Ofcr, Emergency Plans Senior Supt, AW O&M Total Proposed Positions 1 1 2 2 2 1 1 1 1 1 1 1 1 1 1 18 Total Position Cost $ 67,050 78,799 206,070 240,634 178,462 133,619 103,035 142,101 120,317 93,077 126,771 108,461 93,077 97,897 126,771 $1,916,139 Affordability - $24.9M increase • $29.8 million increase for debt defeasance due to the deferral of the planned FY 21 defeasance into FY22 due to market conditions. • $5.0 million decrease in Plus 1 Community Benefit Fund transfers. • Proposed FTE’s (1 - $142,101) Job Title Mgr II, Financial Proposed Positions 1 Total Position Cost 142,101 Operational Needs ($1.4M increase) • $1.4 million increase – Increased chemical costs due to price increase and additional new chemicals needed for the treatment process. 2 FY2022 Proposed Budget Major Initiatives Summary My ATX Water ($1.2M increase) • $250K increase - My ATX Water customer portal advertising to promote to all residential customers through multi-channel advertising – radio, print, digital and TV. • Proposed FTE’s (8 - $926,464) Proposed Positions 1 1 1 1 1 1 2 8 Total Position Cost $171,264 114,205 103,035 142,101 126,771 97,897 171,191 $926,464 Proposed Positions 1 1 1 1 1 5 Total Position Cost $ 89,231 142,101 108,461 108,461 93,077 $541,330 Proposed Positions 1 8 1 10 Total Position Cost $ 67,050 495,941 72,636 $635,627 Job Title Engineer, Managing IT Business Systems Analyst IT Support Analyst Sr IT Systems Consultant Scheduler Analyst Utility Account Analyst Water Meter Technician Sr Total Water Forward ($541K increase) • Proposed FTE’s (5 - $541,330) Job Title AW Treatment O & M Tech Sr Engineer C Planner Senior Project Coord Water Protection Specialist Total Insourcing Contracted Security Services • Proposed FTE’s (10 - $625,627) Job Title Administrative Senior Security Guard Lead Supv, Security Total Customer Satisfaction • Proposed FTE’s - (3 - $410,974) Job Title Engineer C IT Business Systems Analyst Sr Total Proposed Positions 2 1 3 Total Position Cost $284,203 126,771 $410,974 3 FY2022 Proposed Budget Major Initiatives Summary Administrative/Support Services • Proposed FTE’s - (3 - $278,654) Job Title Human Resources Specialist Supv, Human Resources Maintenance Worker III Total Proposed Positions 1 1 1 3 Total Position Cost $ 82,119 126,771 69,764 $278,654 Inter-departmental Transfers ($3.8 M - additional detail attached) • $1.2 million increase - Administration Support Transfer - 8.5% increase due in part to the new human capital management system costs. There was also a $200K error adjustment for the Office of Performance Management allocation. • $1.1 million increase - Capital Project Management Transfer of due to $38.7M (42%) increase of AW CIP Spending from FY19 to FY20. The AW overall allocation % increased from 26% to 39% also due to large reduction in Aviation CIP spending (47% decrease). $859K increase in Transfer for Economic Development is primarily due to the $2.2M contingent liability funding for Colony Park MDA, $530K increase in back charge from DSD for ACD/EDD permitting unit, as well as a projected $0 ending balance in FY21. • $859 thousand increase - Economic development transfer (23% increase) • $581 thousand increase - CTM Support Transfer (15% increase) due to increased IT devices (297 units) to support remote work environment. • $136 thousand increase – Regional radio transfer (27% increase) Other Increases • $685K increase - Computer hardware and software maintenance primarily due to the transition of support and maintenance costs from CIP to O&M. • $297K net increase - Facilities Management is in the process of rolling out a Preventative Maintenance program for HVAC and mandatory equipment inspections and repairs. The repairs related to the finding of the inspections will be contracted out. It includes fire alarm inspection, HVAC inspection, boiler and chiller maintenance, electrical equipment, and ice machines at all facilities. The proposed $705K increase was offset by a decrease of $368K in building maintenance and $40K in computer software maintenance. 4 FY2022 Proposed New FTEs By Austin Water Initiative & Strategic Outcome Count of PCN Sum of Total Cost Austin Water Initiative Row Labels Affordability Mgr II, Financial EUM - Customer Satisfaction Engineer C IT Business Systems Analyst Sr EUM - ELD Human Resources Specialist Supv, Human Resources EUM - Enterprise Resiliency Administrative Senior Administrative Specialist AW Electrician II AW SCADA Analyst AW Treatment O & M Tech Sr Business Process Consultant Sr Business Process Spec Engineer C Internal Auditor III Inventory Planner II IT Business Systems Analyst Sr Ocptnl Health & Safety Spec Sr Ofcr, Emergency Plans Ofcr, Emergency Plans Senior Supt, AW O&M AW Treatment O & M Tech Sr Business Process Spec Engineer B Engineer C Engineer, Graduate B IT Geospatial Technician Facility Improvements Maintenance Worker III Insourcing of Contracted Services Administrative Senior Security Guard Lead Supv, Security My ATX Water Engineer, Managing IT Business Systems Analyst IT Support Analyst Sr EUM - Infrastructure Strategy & Performance 1 2 1 1 1 1 1 2 2 2 1 1 1 1 1 1 1 1 1 1 5 1 4 2 1 1 1 1 8 1 1 1 1 142,101.40 284,202.80 126,770.80 82,118.80 126,770.80 67,050.20 78,799.00 206,070.00 240,633.60 178,461.60 133,618.80 103,035.00 142,101.40 120,316.80 93,076.60 126,770.80 108,460.80 93,076.60 97,897.00 126,770.80 446,154.00 103,035.00 534,475.20 284,202.80 120,316.80 75,638.00 69,763.60 67,050.20 495,940.80 72,635.80 171,264.00 114,205.20 103,035.00 FY2022 Proposed New FTEs By Austin Water Initiative & Strategic Outcome Austin Water Initiative IT Systems Consultant Scheduler Analyst Utility Account Analyst Water Meter Technician Sr Water Forward AW Treatment O & M Tech Sr Engineer C Planner Senior Project Coord Water Protection Specialist Grand Total 1 1 1 2 1 1 1 1 1 62 142,101.40 126,770.80 97,897.00 171,190.80 89,230.80 142,101.40 108,460.80 108,460.80 93,076.60 6,415,110.40 Strategic Outcome Row Labels Government that works for all Health & Environment Safety Grand Total Sum of Total Cost Count of PCN 17 9 36 62 1,852,301.40 1,079,178.00 3,483,631.00 6,415,110.40 Austin Water FY 2022 Inter-departmental Transfer Summary Fleet Maintenance Fleet Fuel Administrative Support Trf to Economic Development CTM Support Trf to CIP Mgm - CPM Workers' Compensation Regional Radio System Trf to PID (Public Improvement District) Fund CTECC Support Street Cuts Transfers Out Other Transfers Trf to General Fund Utility Billing Support Total Inter-departmental Transfers 2017-18 Actual 2018-19 Actual 2019-20 Actual 2020-21 Amended 2021-22 Proposed 16,706,900 5,746,375 12,122,210 3,233,332 4,029,576 2,407,858 1,254,566 293,218 75,000 11,774 14,013,888 59,894,697 18,536,345 5,286,147 13,446,037 3,867,071 4,811,624 2,943,935 1,135,888 454,320 75,000 12,590 16,368,680 66,937,637 24,515,835 5,580,267 13,125,973 4,000,466 4,438,823 2,130,021 1,025,506 449,218 110,573 8,852 12,547,946 67,933,480 24,075,757 5,108,269 13,984,357 3,726,094 3,816,719 2,656,300 966,723 500,599 75,000 19,834 12,500,000 67,429,652 24,991,455 5,174,125 15,181,504 4,585,076 4,397,846 3,766,400 995,725 636,676 75,000 22,176 11,000,000 70,825,983 FY22-FY21 Variance ($) 915,698 65,856 1,197,147 858,982 581,127 1,110,100 29,002 136,077 - 2,342 (1,500,000) 3,396,331 FY22-FY21 Variance (%) 4% 1% 9% 23% 15% 42% 3% 27% 0.0% 12% -12% 5% FY22-FY18 Variance ($) 8,284,555 (572,250) 3,059,294 1,351,744 368,270 1,358,542 (258,841) 343,458 - 10,402 (3,013,888) 10,931,286 FY22-FY18 Variance (%) 50% -10% 25% 42% 9% 56% -21% 117% 0.0% 88% -22% 18% 45,914,379 20,566,947 126,376,023 47,585,534 19,845,099 134,368,270 47,485,805 19,629,848 135,049,133 46,544,409 19,825,622 133,799,683 46,455,866 19,307,652 136,589,501 (88,543) (517,970) 2,789,818 -0.2% -3% 2% 541,487 (1,259,295) 10,213,478 1% -6% 8%