The URL can be used to link to this page

Home My WebLink About01/27/2022 - Meeting Materials ■ ■ ■ ■ Public SLC PUBLIC UTILITIES Financial Review : Financial Dashboard(November 30, 2021, December 31, 2021) January 27, 2022 '., Public utilities Financial Dashboard As of November 30, 2021 Water Fund FY 22 Expense Detail 200,000,000 12.01% ■ Personal Services 180,000,000 1.82% ■ O&M 160,000,000 ■ Charges & Services 140,000,000 120,000,000 ' 20.915/,■ Debt Services 100,000,000 ■ Capital 80,000,000 Expenditures 60,000,000 40,000,000 1.88% 20,000,000 0 63.38% Revenues Expenses November 30, 2021 Change from FY21 Percent of Budget ■ FY 20-21 ■ FY 21-22 ■ FY 22 Bud YTD FY 22 Bud Operating Revenues $44,266,758 ($6,824,696) 48.85% Operating Expenses 30,368,079 2,525,066 37.67% Capital Expenditures 55,409,315 9,365,184 64.53% Amount Percent Time Total Expenses 85,777,394 11,890,250 51.52% Remaining Remaining Remaining November 30, 2021 Change from FY21 Percent Change 2020 Bond Funds $61,853,741 80.05% 56.60% Available Cash $90,201,665 ($30,627,911) -25.35% (Included in Cash) Accounts Receivable 3,272,163 (130,233) -3.83% '., Public utilities Financial Dashboard As of November 30, 2021 Sewer Fund FY22 Expense Detail 400,000,000 1.97% 0.41% 1.38% 2.27% 350,000,000 \ Personal Services O&M 300,000,000 ■ Charges & Services 250,000,000 Debt Service 200,000,000 — ■ Capital Expenditures 150,000,000 100,000,000 ' 50,000,000 93.97% 0 Revenues Expenses November 30, 2021 Change from FY21 Percent of Budget ■ FY20-21 ■ FY21-22 ■ FY22 Bud YTD ■ FY 22 Bud Operating Revenues $23,592,098 $2,954,419 40.25% Operating Expenses 8,658,516 1,268,485 34.95% Capital Expenditures 216,490,899 50,645,950 64.55% Amount Percent Time Total Expenses 225,149,415 51,914,435 62.51% Remaining Remaining Remaining November30, 2021 Changefrom FY21 Percent Change 2020 Bond Funds $37,439,065 35.20% 56.60% Available Cash $56,997,344 ($52,698,675) -48.04% (Included in cash) Accounts Receivable 3,039,948 287,670 10.45% '., Public utilities Financial Dashboard As of November 30, 2021 Stormwater FY22 Expense Detail 30,000,000 16.05% 25,000,000 �0.92% 20,000,000 Personal Services / — O&M '4 15,000,000 L 17.26 E Charges & Services 58.52°0 Debt Services 10,000,000 ■ Capital Expenditures �7.25% 5,000,000 0 Revenues Expenses November 30, 2021 Change from FY21 Percent of Budget Operating Revenues $4,912,867 $667,252 45.08% ■ FY20-21 ■ FY21-22 ■ FY22 Bud YTD d FY 22 Bud Operating Expenses 3,058,801 416,206 33.46% Capital Expenditures 5,230,339 925,294 39.50% Amount Percent Time Total Expenses 8,289,140 1,341,500 37.04% Remaining Remaining Remaining November30, 2021 Change from FY21 Percent Change 2020 Bond Funds $10,642,353 73.14% 56.60% Available Cash $20,074,095 $444,447 2.26% (Included in cash) Accounts Receivable 627,958 116,902 22.87% Public �= -X Utilities Financial Dashboard t ;T As of November 30, 2021 Street Lighting FY21 Expense Detail 5.97%� 7. 7,000,000 1.22% 90% 0.00% , personal Services 6,000,000 ■ O&M ■ Charges & Services 5,000,000 Debt Services 4,000,000 ■ Capital Expenditures 3,000,000 2,000,000 84.92% 1,000,000 0 November 30, 2021 Change from FY20 Percent of Budget Revenues Expenses O perating Revenues $1,680,931 $129,842 40.38% ■ FY20-21 ■ FY21-22 ■ FY22 Bud YTD FY 22 Bud Operating Expenses 1,252,907 315,670 38.28% Capital Expenditures 16,414 (33,737) 0.73% Total Expenses 1,269,321 281,933 23.02% November 30, 2021 Change from FY20 Percent Change Available Cash $5,798,038 ($723,985) -11.10% Accounts Receivable 180,627 2,671 1.50% '., Public utilities Financial Dashboard As of November 30, 2021 Total Public Utilities November 30, 2021 Change from FY20 Percent of Budget Operating Revenues $74,452,654 ($3,073,183) 45.32% Operating Expenses $43,338,303 $4,525,427 36.79% Capital Expenditures $277,146,967 $60,902,691 63.46% Total Expenses $320,485,270 $65,428,118 57.79% November 30, 2021 Change from FY20 Percent Change Available Cash $173,071,142 ($83,606,124) -32.57% Accounts Receivable $7,120,696 $277,010 4.05% Delinquent Billings 0.94% Amount Percent Remaining Time Remaining 2020 Bond Funds $109,935,159 55.47% 56.60% (Included in Cash) '., Public utilities Financial Dashboard As of December 31, 2021 Water Fund FY 22 Expense Detail 200,000,000 13.39% ■ Personal Services 180,000,000 1.85% ■ O&M 160,000,000 ■ Charges & Services 140,000,000 120,000,000 ' Debt Services 100,000 000 22.50% ■ Capital 80,000,000 Expenditures 60,000,000 40,000,000 20,000,000 2.11% 0 60.15% Revenues Expenses December 31, 2021 Change from FY21 Percent of Budget ■ FY 20-21 ■ FY 21-22 ■ FY 22 Bud YTD FY 22 Bud Operating Revenues $47,863,439 ($6,675,082) 52.82% Operating Expenses 35,305,844 2,268,990 43.78% Capital Expenditures 56,262,710 (7,750,053) 65.52% Amount Percent Time Total Expenses 91,568,554 (5,481,063) 54.99% Remaining Remaining Remaining December 31, 2021 Change from FY21 Percent Change 2020 Bond Funds $59,439,194 76.92% 53.80% Available Cash $85,546,735 ($30,377,649) -26.20% (Included in Cash) Accounts Receivable 2,774,689 603,661 27.81% '., Public utilities Financial Dashboard As of December 31, 2021 Sewer Fund FY22 Expense Detail 400,000,000 2.13% 0.42% 1.41% 2.46% 350,000,000 - \ I I i Personal Services I O&M 300,000,000 ■ Charges & Services 250,000,000 Debt Service 200,000,000 — ■ Capital Expenditures 150,000,000 100,000,000 50,000,000 . 93.57% 0 Revenues Expenses December 31, 2021 Change from FY21 Percent of Budget ■ FY20-21 ■ FY21-22 ■ FY22 Bud YTD ■ FY 22 Bud Operating Revenues $28,664,943 $3,581,136 48.91% Operating Expenses 10,084,259 964,394 40.69% Capital Expenditures 238,147,040 71,283,057 71.01% Amount Percent Time Total Expenses 248,231,299 72,247,451 68.92% Remaining Remaining Remaining December31, 2021 Changefrom FY21 Percent Change 2020 Bond Funds $33,438,651 31.43% 53.80% Available Cash $57,203,240 ($50,041,941) -46.66% (Included in cash) Accounts Receivable 2,503,092 396,886 18.84% '., Public utilities Financial Dashboard As of December 31, 2021 Stormwater FY22 Expense Detail 30,000,000 18.28% 25,000,000 20,000,000 1.00% ■ Personal Services / ■ O&M 15,000,000 53.810 ■ Charges & Services L 18.67%■ Debt Services 10,000,000 ■ Capital Expenditures 5,000,000 8 24% 0 Revenues Expenses December 31, 2021 Change from FY21 Percent of Budget Operating Revenues $6,012,253 $839,050 55.17% ■ FY20-21 ■ FY21-22 ■ FY22 Bud YTD d FY 22 Bud Operating Expenses 3,578,513 382,590 39.14% Capital Expenditures 5,075,141 92,996 38.33% Amount Percent Time Total Expenses 8,653,654 475,586 38.66% Remaining Remaining Remaining December 31, 2021 Change from FY21 Percent Change 2020 Bond Funds $10,170,987 69.90% 53.80% Available Cash $20,576,618 $593,834 2.97% (Included In cash) Accounts Receivable 626,830 197,021 45.84% Public �= -X Utilities Financial Dashboard t ;T As of December 31, 2021 Street Lighting FY21 Expense Detail 5.86% 0.99% 7.93% 7,000,000 � 0.00% , personal Services 6,000,000 ■ O&M ■ Charges & Services 5,000,000 Debt Services 4,000,000 ■ Capital Expenditures 3,000,000 2,000,000 85.21% 1,000,000 0 December 31, 2021 Change from FY20 Percent of Budget Revenues Expenses Operating Revenues $2,179,012 $275,639 52.34% ■ FY20-21 ■ FY21-22 ■ FY22 Bud YTD FY 22 Bud Operating Expenses 1,536,861 29,229 46.95% Capital Expenditures 16,414 (270,405) 0.73% Total Expenses 1,553,275 (241,176) 28.17% December 31, 2021 Change from FY20 Percent Change Available Cash $6,015,965 ($72,786) -1.20% Accounts Receivable 168,664 20,928 14.17% '., Public utilities Financial Dashboard As of December 31, 2021 Total Public Utilities December 31, 2021 Change from FY20 Percent of Budget Operating Revenues $84,719,647 ($1,979,257) 51.57% Operating Expenses $50,505,477 $3,645,203 42.86% Capital Expenditures $299,501,305 $63,355,595 68.58% Total Expenses $350,006,782 $67,000,798 63.11% December 31, 2021 Change from FY20 Percent Change Available Cash $169,342,558 ($79,898,542) -32.06% Accounts Receivable $6,073,275 $1,218,496 25.10% Delinquent Billings 1.82% Amount Percent Remaining Time Remaining 2020 Bond Funds $103,048,832 51.99% 53.80% (Included in Cash) '., Public Utilities Updates Budget Items FY2023 — Process initiated — operational costs, capital will be evaluated in coming months Budget priorities Planning for FY22 bond issue WIFIA annual update and quarterly report — initial loan draw LL� _• T' t SLCDPU Lead and Copper program is dedicated to Lead and Copper protecting public health and water quality by minimizing the risks associated with lead and copper in drinking water. Health Effects of ' . • Exposure to high levels ADULTS Signs of -•' -• exposure Brain P . der six are i O'soning-Eve,low I mostat risk from lead • abdominal pain, cramps, constipation Memory loss,lack ofconcentration, • aggressive behavior headaches, Body adccuse hyperactivity in children irritability, Fatigue,joint and • sleep problems depression. muscle pain CHILDREN headaches• Cardiovascular Brain Digestive ' High blood pressure Behaviorproblems, • irritabilitySystem lower IQ,hearing loss, pressure• high Constipation, learning disabilities bloodnausea and Kidneys god poor appetite Abnormal function y numbness• • and damage decreased bone and muscle • memory loss Nervous ReproductiveIs growth System System • kidney • • Damage including • Men:Decreased sexBlood numbness and drive and sperm count, Anemia pain in the and sperm anomalies. Kidnextremities Women:Spontaneous AbnoNervous • •• miscarriage functionSystem • vomiting daDamage • Seizures • Encephalopathy Long Term EffectsThere are no safe known levels of Lead • loss of developmental skills in children • Increased Alzheimer's in adults i EPA How does lead and 0 CERNED ABOUT LEAD IN YOUR DRINKING WATER? copper get into drinking water? Sources of LEAD in Drinking Water - Faucets:Fixtures • inside your home • • may contain lead. • Copper Pipe with • Lead Solder:Solder made ,, Galvanized Pipe: or installed before 1986 • • Lead particles can contained high lead levels. _ ■ attach to the surface of • galvanized pipes.Over • • time,the particles can • • enter your drinking .... • .y water,causing • elevated lead levels. .a..t�. 1r � � � •� � �� r r h � • .� 1 � l ` � � � � 0 • - s . : �,r ` i. � , i / � � - _ . ��1�(t �. , )� '., _ � ._ ._ _. � ___ .+male 1•.�_. i Drinking Water Systems Implementation& Public Education Administrative / t S Outreach mpling Corrosion Sa Control _ `'�' I Fountain-Faucet Treatment �\ ' Residential Childcare Timeline of Actions Item Due Date Effective Date 2021 LSL Removal Plans due 2024 LSL Inventory due 2024 Begin annual notification to owners of LSL presence 2024 Begin pitcher distribution for LSL disturbances 2024 Provide notices when shuttina off water 2024 Begin schools and childcare facilities sampling 2024 Begin first compliance period 2025 End first comoliance period 2025 Issue tier 1 public notice if action level exceeded 2025 Beqin required 3% LSL replacement 2025 Begin work on Corrosion Control Treatment study 2025 20%schools and childcare facilities sampled 2025 40%schools and childcare facilities sampled 2026 3%of LSL replaced 1 )6 60%schools and childcare facilities sampled 2027 Finish pipe loops/recommend Corrosion Control Treatment 2028 80%schools and childcare facilities sampled 2028 State reviews treatment recommendation 2028 Install treatment completed 2029 100%schools and childcare facilities sampled 2029 FU T WA I T. THERE'S MORE. Timeline of Actions Item Due Date Effective Date 2021 LSL Removal Plans due 2024 LSL Inventory due 2024 Beqin annual notification to owners of LSL presence 2024 Beqin pitcher distribution for LSL disturbances 2024 Provide notices when shuttina off water 2024 Begin schools and childcare facilities sampling 2024 Beqin first compliance period 2025 End first comoliance period 2025 -, i_ie liar 1 pul_In- notice if action level exceeded F)—jin [-ji i —1 LSLreplacement E)_iui ;_rh -�n 'ca rc„ion Control Treatment study z025 20%schools and childcare facilities sampled 2025 40%schools and childcare facilities sampled 2026 of LSL r i,l ia- ,_l 202c 60%schools and childcare facilities sampled 2027 Finish pipe loops/recommend Corrosion Control Treatment 2028 80%schools and childcare facilities sampled 2028 State reviews treatment recommendation 202-' Install treatment completed 20�' 100%schools and childcare facilities sampled 2029 InventoryLead Service Line tSalt La�„'ke CitYeumic Utiliities r�Servjic_e Lin'kaL e t Identification Public Way P41W Property him., -.aaam t t t t t t t t t _ Water Meter t 1 i Water Main Water Service One SLC Water: Homeowner Water Responsibility: From the Water Main to the Water Meter Anything after the Water Meter to the Home Where re we ? I Unknowns on Private side service lines How we can address unknowns Record Review Currently have Approximately approximately Ongoing fieldwork 90,000 service 60,000 connections unknown on private side Inspection Program Profile Sampling Potholing or Excavating Approximately IFF Only 12 known g,000 Customer Surveys LSL's unknown city side Predictive Modeling SLCDPUis policy has been to remove any lead lines as discovered in the field for many years Notify owners when a lead service line is identified on the historical customer's side during field work, and leave the hole excavated in case the owner wants to replace their efforts to portion of the lead line reducelead Historically SLC has been on triennial sampling because of such low lead results during compliance tap sampling in accordance with 1993 LCR. Last round in 2021 was in line with former years falling below any action level for lead or copper. SLCDPU routinely samples for lead in the distribution system and the results are typically lead-free Monitor treatment plants for corrosivity. Typically, corrosion control treatment does not need to be implemented because of the high quality of our water and its natural hardness. current status and Hard water creates coating on the inside of pipes called scale. Scale generally separates the water from the lead piping risks for lead protecting the water from leaching lead. In the department's experience, the greatest risk for lead in water comes from older private premise plumbing containing lead, including service lines installed before 1930. HOMES WITH HIGH PROBABILITY OF ?' LEAD PROPERTY SIDE SERVICE (Homes 1930 or older) ••., r�r ! .. •� Ernramental SChools& i • Justice Daycares • a .,. : Demograpn,cs • • (%10 -mome H+Property Side • + • and%people of Lead Probatiity a a Law Data not Concawation a 'table HXP _ - - '✓ �� •�" _ A Less than 50% Concentration w w ,• a a i .es • S0-60% • w-80% 90-95% • � • 95-100% e � k P r Probable Homes with Lead Heat Map dO.Ic Lake City a 1� t � 171 p vw eao 5 - 1 lorWrl va!kh!a n rva models � WO"Pv k ' •.. nd Aue ® 8 � i �M1vn., 3 Imos � Tr 8 3 � i J lnr,c - nxh Sl,n��,irp Probable Children under 5 — Schools —Lead SALT LAKE CITY LEAD&COPPER POPULATION UNDER THE AGE OF FIVE if u f, fJ1•; I � jam. y i.f .� ___ • Ong cl ••/� O hlYl O Jorda �aOark �' 1 And eace Gardens h• s� = = TswK•• i - it s u/nr11 .•..Liu wmrm�wr { A•y 7.11'LY / dsI11fIMA ti or b '1 t-81W -..7�• a i <<,cq Avg . TRAX-Ball Pat.,, u_S_ - lznnc >e Ls 1s•.s..,. . � d i 1 s. J 1 • i II ---_- ouch Par sss�/� •'•f flf n V I -- t I •NI b tAltt W 1830 S `? _ I Mommommis _ Tools for customers to • https://www.slc.gov/utilities/leadandcopper/ help identify their • Step by Step guide to help identify Lead lines • Survey to report lead lines or request assistance in service line material identification es a a + n r Oo you have lead pipes in your home? • i Lead exposure,even in small amounts,may cause health problems.It is connected with behavior and learning problems in kids,and high blood pressure and kidney problems in adults. f Lead In water systems is one possible source of exposure,and that's because In many homes. a the pipe that connects the building's plumbing to the water system is still made of lead. We'll help you find out whether your drinking water is at risk in a few simple steps.You won't need anything fancier than a magnet and a coin,but you will need to be at home to follow along. If you do find lead,we'll show you what you can do. a a a a•a' a= Not at home?Add a reminder to your Calendar. _ a i e f Or,if you already know you have lead pipes,here's what to do next. a + Find address or place CZ Smith l , o Ballpapark r Kensington Ave r �%+ q d / n / 1700 S ° n {/ N ^ Wilson Ave Wils:� • How much is this going to cost? ' ' ' ' • ' ' ' ' • American Water Works Association estimates 6.1 million lead service lines f 16 y remain in U.S. communities, at an estimated $30 billion -s to replace. 1 _ r ( - • Teresa Gray—Water Quality and Treatment Administrator • 801-654-9574 ,reaa. ray�Lu�,ILV v.wni Questions? Dustin White —Cross Connection Control / Lead and Copper Manager 801-483-6867 ustin.White@slcgov.corr