The URL can be used to link to this page

Home My WebLink About10/27/2022 - Meeting Materials Publ i c Managing Assets, Capital Planning utiliti s . and Budget Make It Pure October 27, 2022 Asset Capital Asset CI P Project Management Program Delivery Public Utilities SLC Public Utilities Assets By the Numbers ................................................................ ........................................................................... • Water >135 square mile service areaJI > 90,000 water service connections > 1,300 miles of water supply lines • 3 drinking water treatment plants . • 30 pumping plants • 36 groundwater wells • 6 dams 0 30 tanks and reservoirs �- Public Utilities SLC Public Utilities Assets — By the Numbers ............................................................................... ............................................................ • i mr Sewerj. • 600 miles of collection lines I !' 1{ i9l ^ I 1 wastewater treatment plant WaterReclamahonFacil'I'; r� — R 't ` p ry Beck Street Sewer Interceptor • 35 lift stations __ SahLakeCkintemabnalAirort , • Storm Drain -- Orange Street Sewer Interceptor 6 > 300 miles of (ollertion lines ' • I • > 14,000 stormwater inlets ��Imerstate.7 80 ta UnNersity,atUtah • > 36 miles of canals, ditches,and creeks m, • 112 detention basins ' 1000 W sewer Inb=* • Street Lighting Public f � ram Utilities SLCDPU Asset Management Pro g Program • Inventory/Inspect Assets. • Assign Criticality. • Assign Condition. • Create a plan for each asset and schedule next inspection. Public f � Utilities► Inventor Ins Y/ ection p ............................................................................................................................................... A A \ A , r- 0.2ft-General Observation-Corrosion to 5.4" 02111-General ob,erection-Corrosion to 5.e 1241ft-Max Corrosion-A.2' M r 3.6in 2.4in 1.2in 12 O.Din -12in -2.4in „Id7 .3.Bin 0 2 15.4 32.0 46.5 65.1 81.7' 9 114. Public Utilities Example Asset Performance Criteria p ............................................................................................................................................... REGULATORY CUSTOMER SATISFACTION WATER QUALITY SAFETY STRUCTURAL CAPACITY SUSTAINABILITY SEISMIC CARBON FREE BY 2032 OTHER Public Utilities► Criticality ............................................................................................................................................... DescriptionCriticality Rating L Low or minimal impact if the asset is lost or fails 2 Moderate or minimal impact if asset is lost or fails AService restored with repair or system redundancy in 8 to 24 hours after failure of the asset 4 Some critical customers are affected by failure of the asset 5 Significant number of customers or critical facilities are affected by failure of the asset ""Consequence of Failure "" Public Utilities Condition ............................................................................................................................................... Condition Rating Descr . . 0 Asset does not exist. 1 Asset is in very good or new condition. 2 Asset is in good shape without significant defects. 3 Asset has some defects or is deteriorating, and it should be monitored again within five years. 4 Asset has defects that may cause failure within five years and repair should be included in the five year CIP Budget. 5 Asset has defects that may cause failure and repair should be included in the upcoming year's CIP Budget. ""Probability of Failure " i. Public Utilities Criticalityand Condition n w are considered individually � iu■:iiii' There is NO combined �y� • I!It�;�i ■■yci,�ur .:von ■I�Ii`�... �ur�• �. /IIIAnn•� �',..' .7Y:i EFI� ;h=,;_ �i:a-value. ��r .:.i �^ ,7 � � a a,-'��•:� 1, Maps 1 to aide 1 � -a•�.. R�`i:.��.�r'v mil; i), Public Ut� lit�' c�► Plan for the Asset ' ' ............................................................................................................................................... eContinued Asset Management Work Order eCap • • - - Proje "Every Asset Has a Plan "' inh►'ii It 1, WPM - 71 Asset CI P Project Management Delivery • Public Utilities Identified Issues/Concerns cr�4 ............................................................................................................................................... • Lack of organization for documenting capital project p�CP } L � needs. L • Difficulty communicating project status between 4.- t".r•—,I — Operations/Maintenance and Engineering. r �k JAv�n ott_�a�.S arar,...�w.a- b .lS #ik'WC 6 4 - .. - Swsi��; 41Lv ;g.;�,eSl.,t.�-�rtiA..✓e4. • Challenges linking prioritized projects generated fromS Asset Management to the final budget. • Rt ruw IYATNW 4e• 'C¢_ nF Incomplete sco ing of proposed projects before F'4 f �- 1,1� vo.�61Aja-%a-ftVA4 tax, acceptance into the budget. - a. - Asset Capital Asset CI P Project Management Program Delivery Asset Management Progra m Capital Asset Maintenance Inspection Program Work Order Schedule Budget How • • projects generatedfrom Asset Management get into the Budg- • • the Capital Improvement Program? Capital Improvement Progra m Asset Management Legend Maintenance/Operations and Asset Mana em�eF��t Project Inventory/Criticality/Condition(GIS Database) Other Processes Engineering Program Managers Project Manager Coordinato F I Coordinator External Coordination(UDOT,SLCO,Cities,CED) - (Malntenanceand Englneering Program Managers,nmq All Hands(AMC,Maintenance/Operations and Finance Administration (Engineering Program Managers,Finance,Administration) 7tomprlete Create Project Capital Iniect Map,Project Needs No Determine Vey copng Document set, Database B .IS Project Object Capital Project is Needed � z Develop Submit Request a Inspection and for Capital Project A Complete Final c pproved Sloping Preventative aecuest uumerrnrar,�d (AMC Moves to Initial Scoping, c Maintenance Plan — Project Manager and EWO Assigned) E 8 a E 0 Y Meeting to LeB g to a Program Prioritized Budget Work Plan Manager Approval Capital Needs .Review Capital Proposal udget proposal Needs al Z; z S Denied Submit (AMC Notifies Originator) Capital-Asset ti Project Number Project Number plan Annual Assigned Request Form i — y upcoming Fy Only Submittal Upcoming FY Only \�./ I -� Project Delivery Approved SubmittoCity Submit to Submit to Administration Project Management software Budget Council Mayor PUAC Review (Project Manager,0e,rr,li ,,,,,,r.r,,n.,rC,r,.t, - Projects with Additional Phases Remain in Capital Needs Database Public Utllltie�l Capital Asset Program Components ............................................................................................................................................... PubllC CAP Nomination • Request for Capital Projed P,.j�c- CAP StaeD" �°`e.eeig°� U ® I Prtryect Central Stage: ominadon ,,to Develop project Nomination DevNPp YPurnominatipn.Fieltlz in red are requirM.Click the • Submitted by Maintenance/Operations � . . "°"- P. Develop sziEn «ummcess Guitlf Pr°jec P Sc°pina validate � Statu to Project c Naminaha � �• Protect$[°P $[°P D eM Open for lull or Engineering a"Npn • Unique request number °rPJe'ttTi`le water PrPJeN Funtl: • Shop,Project Basic project information, including Ad--: Sturenout. and Other e leings tmentrt Pla Ci Trea Plant Nominated b on Inadon De 1hh.ht: Parleys Teatment plant Y: Er°w^,aasnn. 9 Pa elg cottonwood-ig Treatment plant criticality/(ondition and estimated cost Water Storage Reservois(Canyon Reservd s) nitial Cdticafty: initlal Condlb.n: )ortlan antl Salt lake Canal OraJea List Tags: ❑City Driven Proj.. ❑City/county/state Funded ❑Master Plan ❑frat-Relatetl ProJMs Wxer ExNange Area-Wchards Ditch Water Exchange.rea-Green Difch • Reviewed and approved or denied by DESCRIPTION wrtef Mai ange Area-Upper Ellison project Description: r N E n-County wxer vumv Plant Water Diatrlbutl°n—oh, counterpart Program Manager W Watexerr—a anal°°-DNy y Water Htu Valve1. na -j—Re—, IST . . �thhatad Cost: Source of Eebmate: ❑Vee Workaheef Public f � Utilities Request for Capital Project ............................................................. ................................................... Engineering Project Central /EDRLINI6 l. SharePoint form is completed My CAP Workspace requesting a capital project. Nomination-Under Development J Hu CAPID III nuI Rdj fund Proj Type Nominated by Date Nominated Ndmira Approver SM Assigner Sloping Manager Protest step 2. Notification email is sent to the There are no items to show in this view of the"CAP Nominations'list. Nomination-Awaiting Approval opposite program manager for review • Edo CAP ID Proj-Title PI fund Proj Type ..-in—by Date N—inatM Nomination Approver SM Assigner Sipping Manager Rotes Step There are no items to show in this view of the*CAP Nominations'list. and approval. Validation-Need Scoping Manager Assigned Edo CAP ID 111 Title Raj rand Proj Type Nominated by Date Nom 11 141—11 Approver SM Asaignx -pin,Manager Proresa Step 3. If "Denied", reviewer must document There are no items to show in this view of the'CAP Nominations'list. Validation-Need Scoping why the request was denied. IEtlB CAP ID PI-TXIe Rpj rend PIType N°mi° by Date Npmin Nomination Apo. SM Assignor Sipping Manager Protess Step There are no items to show in this view of the"CAP Nominations'list. ed 4. If "Approved", a Scoping Manager is I 1du tI IDY Me III Tale Proj fund Proj Typa N—na by Dale N..... lip 2D22-1030 Fv 22123 W RF Capital p ject Support .. Sewer Water Reclamation Facility ❑Brown, in 2022 6/1/ 10:58 AM assigneda n d t h e request moves onto ,J 2019-1114 Program Management Support-Storm .. Storm Storm Dram Study ❑Brown,Jaon 9/10/20199:52 AM 2019-1113 Program Management Support-Sewer ... Sewer Sewer Study ❑Brown,Jason 9/10/20199:51 AM theInitial S c o p i n g phase. 4 2019-1112 Program Management Support-Water Water Water Main Wension-City ❑Brown,Jason 9/10/2019 9A8 AM } 2019-1076 Watershed Master Plan update ... Water Watershed Projects ❑Brown,Jason 6/6/2019 7:21 AM 2019-1067 7DO SWh waterline replacement ... Water Water Main Extension-City ❑Brown,Jason 5/3112019998 AM 3 2017-2024 Advance Meter Infrastructure Program(Annual) ... Water Water Smice Connection 0 Brown,Jason 9/29/20171:DO AM Public Utilities Capital Asset Program Components ............................................................................................................................................... ""� " " a- nitial S(oping CAPRALIMPROVEMENT PROJECTS-WATER . ..�°�.. MAIN REPLACEMENT PROJECT State Stnlet-Kelsey Avenue(1161 South)to 1300 South REQUEST NO.2073-02" • Completed by Scoping E Manager (Engineering) �•.Ta ,. gt:;.:� II Ili ..., • Provides closer look at project needs - consultant, M 0 coordination, study, permits, EWO s etc. • Scoping Map created S (y wa.i�nm.is FM Public Utilities Initial Scoping ............................................................................................................................................... l. Notification email is sent to Scoping ... °f�.....°V....�a �..• ° °• CAPITAL IMPROVEMENT PROJECTS-WATER MAIN REPLACEMENT PROJECT Manager to complete the Initial Scoping State$`��-N.IS.yAv.°u.,,,61 1h„°,JUUS001h REQUEST NO.20 13-0246 2. Scoping Manager completes the Initial E Scoping form on SharePoint. 3. Email notification is sent to the Project C Coordinator when Initial Scoping is m +I o complete. ( f 4. Project Coordinator adds the project to -� —, the GIS database, creates a map S (y 11 .� 0 W 100 200 wa.i�nm.is FM Public Utllltle�l Capital Asset Program Components ............................................................................................................................................... "'j- awe: E3 , j Public CAP Nomination :.,ou'"°t'°"w't"°M1 °""°a • Final Scoping J ��°m°n"eQ°w Utl�l}IC$ CAP ID a:2022-1097 PlOfec[CMfAI Stage: PrioAtlEatlon BPerml[s Step: PN',[d a Project Sco ° ❑Doer • Completed by Scoping Manager IudwlN°nalAmad : UDDT ProjeM rtle: stae street-90o s a.oa s sewer a °aa•nole.rs: ❑non. p�mcounal (Engineering) sewer IC"-vrojeEx one: ❑cd"w care Eacnidn plmrrtiae Addr • Review of Initial Scoping NrP,a eee: a.Dg S And 5=tits�weet mch, s Departments ° gulatoryparrnRa °Ch—h- ommatw by: IDmQIe..MA991: °Wa o—d informationInitial Cdd,iility: e-Soma Significant ERe[ Design Type: External Primary Rantlng: Developer lnitlatWIGrowM PROIECT SCHEDULE REQUESTED FISCAL YEAR pre-Dez�gn Ev, 2021/3032 . Dez�gn Ev: 2021/2022 v ConrtrvrElon FY: 202a/3025 • I n c u e s s p e c i i c projectdetails - ".J..u.Ags °City Driven Proj.. °Diry/ COST stakeholders, public involvement °d DESCRIPTION D—pt'°". CIPP''ni 225f°etef°x'etl eofEtlmae: nwnan/-P.m °Uae was hem 5 does not Currently exi ee labeled as MM 2005n .large n design but o-bons/new utilities mmentz. eslgn co npletw[o Me 90%level under project 525003026.Project was id,—d pewing mmpletlan of UDOT m°rerodums along plan, implementation issues, Inhalation of hod Copp In[he lnt state 9[r. ane,gg s wniEn will canElaee in 2025. Design completed to the 90%lev State Street and e00 S.Moratori from 9o%to final,bidding And detailedcost breakdown, work vrojeM Reason: Rebabllltate e,I,dng sewers on S D"a°d—urn. ®5 plan, and requested budget years Project Obj-i— Rebab existing sewers after UDO ®Oik1e°ro�mert•Ty.I�nE 1 \J ��J ��J cements. � ICI ICI ImpkmenUtlon Issues: UDOT mom[orlUm,Tafflc Control A B Click h—t0 attach a file �••/•e..w .... ...✓ee.. p.a.a.• w.i•awem.w�e..w=I•o..e.p I.Is.N•1 Public Utilities Final Scoping ............................................................................................................................................... 1. Notification email is sent to Public CAP Nomination °'�"B0� pcoo.elh...wlm DMer AgenEiee JpConeunaM rveeeea UtiliUtl�l}IC$ CAP ID a:2022-10.1 ❑Easeme- ities Stage: prioAtlEatlon up.—It. Scoping Manager to complete the °^•2B°r°j•°=°° or lurize ..I AUMod[y: IID- Fina coping. .nole.re: ❑non. ProjeM Ytle: state street-aoo s a Boa s sewer R tak paty council pCa unhy Counele 2. Scoping Manager completes the P`J—A El°`It1-1. ""'l"� B Utlli" vrP)ert Adereea: srate street a aoo s ane 30o s ❑sm0me parr Departments Final Scoping form on SharePoint rv°m, O Rog ulamry Pe°Ra oCh—I io , natea br: mmGle..efaggi; ❑ware°nm including cost and time estimates Dooigl Ty,: y: e-Soma 5lgnlflcaM ERe[ esign Type: External 1 PROIECT SCHEDULE-REQUESTED FISCAL YEAR Primary Ranking: Developer lnitlated/GrorrtM1 e5,gn Ev, 2021/3032 . Dez�gn Ev: 021/2022 v ConrtmrElon fy: 024/2025 specific tote project. ".Jea ust ngs: O City Driven Project ❑Citr/ re D z z • • N ESTIMATED COST °,ert°e�d�i° CIPtooP lint,,,225 feet Estlmao:of existing R 0,000 Source of C.—Ito t/3rd party v ❑Uu Workshert 3. The Final S eo p i n g Form is MM 200' d...notCurrently exiCOMMENTS,LINKS&ATTACHMENTS Inne'.t as MH 2005n .large n design bu[b-bons/new utilities mmen z. eslgn co npleted[o Me 90%level uneer proj-525003026.Proje°was shelved P—Ing..Motion of UDOT mootorlums along ztallation of to'CIPP In the Int sots— ane 400 s which will conclude in 2025. generated from SharePoint °°sIg°°pmpleted°°Me90%ICI° State Street and e00 S.Montori from 90%to final,bltltling And to documentationof the projects vroj..Reason: Rehabll o[e exlstlng sewers on 5l ❑nked DPCP— ®°®5 scoping efforts. °h °` vro)eR ObJeRive: Rehab existing sewers after UDO IN nrcrt•Tynlink 1�\J ��J ��J cements. U ICI ICI ImpkmenUtlon Issues: UDOT mom[orlum,Ta(flc Control A d Click I—to attach a file �••/.e..w .... ...✓ee.. °...a.• w.i•awem.we..w=I•o••dP i.ls.N•1 Public f � Uti lit ic�► Project Prioritization .................................... .......................................................................................... 1. Projects are initially prioritized within cost 5 centers based on the Criticality and Condition indicated during Final Scoping. \� 2. An "All Hands" meeting is held to review the prioritized projects. 6 • ~ 3 • 3. Final Scoping is updated based on the o lateP" U discussions in this meeting. 4. A Budget Proposal is prepared based on the 2 • final prioritized project needs and financial constraints. , _ 3 4 5 CRITICALITY Public utilitie�► Annual Timeline ............................................................................................................................................... OctJul Aug Sep Submit Budget Proposal to O Submit Budget Proposal to Public Public Utilities Administration Utilities Advisory Committee Public Utilities Administrative Review Budet Finalization ............................................................................................ ................................... PUBLIC UTILITIES l. Budget Proposal and supporting 2023 BUDGET PROPOSAL documentation (Final Scoping Forms) are submitted to SLCDPU Administration. r `_ Public 2. Upon approval, Budget Proposal is �tl I I#' S presented to PUK 3. Final Budget Proposal is sent to the City p :'C Council and Mayor's Office for review and final approval. ► WATER-SEWER-STORM W ATER-STREET LIGHTING MafCh'17, ENTERPRISE FUNDS ZQZ2 SERVING OUR COMMUNITY,PROTECTING OUR(NVIRONMCNT --- ---- -- - Budget Approved JulyReview Final Budget April Submit Proposed August/September Budget to City Generate List of Council Projects for Next Fiscal Year March y 'L9 October Submit Proposed �� _� Prioritize List Budget to the of Projects Mayor IT February November Submit Proposed Review Project Budget to PUAC Priorities with Program Managers January Submit Capital December Improvement Plan Finalize Asset and Budget to -- Management SLCDPU Database Public Utilities SharePoint Integration ............................................................................................................................................... tin-iu-J. I., ,2DITUNK3 • All CAP information stored in My CAP Workspace Nomination-Under Development SharePoint• Th are w items to M1pw in this w-ew of the'CAP No Im--rMatipre lirt m1ro x.mimu..n m sM ssw w w .r vm Nomination-Awaiting Approval SharePoint list features include: sear• ch T„Nedfemlrems[osM1owin[M1iswewoftM1e'CAP Nomoa[io list N.—I.-.— ,M p — `�i9ro filters, views, attachments. �an'°�.INeed—S "111. 9ef" '9n�°� �M ro,� xe.roeeA.— —M P-1—ne,�.]ee �r�.a �,rypa a�p.paw.9er There are rw irems[o show in[his New of the'CAP Nominations'list. • Workflows notify users of new VaIItlMa^loUPlpNe-11I.l°� ro I]ape w �n�m,ro xemroee..romw sM1,p u� per —— hem �w There are rio irems to show in this New of ttie'CAP Nominations'lirt. requests, required scoping, and other Nominated ByMep M]n (�_ D M`ppg=�300f�WMr,gfip gPMm°,n IwT —II m, . Ma+r.ga eeae�r hp 2azz-,n3n I2 11UPaaiPrgerttxPP T to ai isn.e action items. •2m¢,,,. program Ma g m Supp rt om X -} "L53i T 4h re as l 2at91113 program Ma�Mgemenl support-Sewn ra ail r r Pn • c 112 P. raPPna opl o.� rma • �2a1?lo]a w,Pram Mana9emem Support-water Fe�w cou Yetpm>n(cv)(sysanl6i.earMrye..m.1 - s+.m wea99aots,0.35 c Single location - My CAP workspace •2 � rs �M""a U." Ell 2g South waterline replacement SaanisOie,n'a3rmv cape. Ell 2o1. AM_Math inkaa.—program pn—I) -- -- -- - - — ilea Q 201-3 aoo[art 2100 t]p3 Jenni,sown A SharePoint Document Set has been heated(or)our proecl-900 East HHltiew(4060 South)-Replsoe DIP ht Under Sewer,Request Number sots-56.You can access the Document Set has.It Mill be named sol$-os$6. Please complete the Flual SeoplOR for this pmjeR has.Please contact Kristeen with am.questions. �I Public Utilities The CAP Solution ............................................................................................................................................... A ' Solution Poor tracking of CIP project requests. Single database for all project requests tracked with unique request number. Easy to use! Inconsistent prioritization for budgeted Rating system to classify importance of projects. needs. Incomplete project assessment prior to Detailed scoping to analyze project specific acceptance into budget. coordination, cost, and staffing. Lack of organization for documenting SharePoint database for all CIP needs. capital project needs. Public Capital Asset Program: FY 2018 - FY2023 T~ Utilities . ........... Project Requests 1745 Completed Projects (Total) 333 Completed Projects (4 or 5 Criticality and 4 or 5 Condition) 223 Projects in Progress (Total) 364 Projects in Progress (4 or 5 Criticality and 4 or 5 Condition) 224 Pending Scoped Projects (Total) 562 Pending Scoped Projects (4 or 5 Criticality and 4 or 5 Condition) 161 Projects Budgeted for FY 2022-2023 87 Projects Included in 5-Year Plan 257 ■ ■ ■ ■ Public SLC PUBLIC UTILITIES Financial Review : Financial Dashboard(June 30, 2022 - unaudited, July 31, 2022) September 22, 2022 '., Public utilities Financial Dashboard As of June 30, 2022 — unaudited Water Fund FY 22 Expense Detail ■ Personal Services 180,000,000 15.71 175,000,000 ■ O&M 170,000,000 �2.71% ■ Charges & Services 165,000,000 Debt Services 160,000,000 155,000,000 ■ Capital 150,000,000 26.59% Expenditures 145,000,000 140,000,000 52.29 135,000,000 2 70% Revenues Expenses June 30, 2022 Change from FY21 Percent of Budget ■ FY 20-21 ■ FY 21-22 FY 22 Bud YTD FY 22 Bud Operating Revenues $79,161,815 ($9,560,105) 86.99% Operating Expenses 68,109,138 3,457,431 84.46% Capital Expenditures 79,120,067 (10,482,683) 92.14% Amount Percent Time Total Expenses 147,229,205 (7,025,252) 88.42% Remaining Remaining Remaining June 30, 2022 Change from FY21 Percent Change 2020 Bond Funds $39,638,333 51.30% 37.30% 2022 Bond Funds $68,141,714 100.00/ 100.00/ Available Cash $116,187,837 $31,191,386 36.70% (Included in Cash) Accounts Receivable 4,964,957 (892,625) -15.24% '., Public utilities Financial Dashboard As of June 30, 2022 - unaudited Sewer Fund FY22 Expense Detail 3.52% 0.73% 2.46% 500,000,000 I 4.42% ■ personal Services 450,000,000 - 400,000,000 ■ O&M 350,000,000 ■ Charges & Services 300,000,000 ■ Debt Service 250,000,000 ■ Capital Expenditures 200,000,000 150,000,000 ■ il 100,000,000 50,000,000 88.86% 0 Revenues Expenses June 30, 2022 Change from FY21 Percent of Budget Operating Revenues $58,410,888 $4,317,178 99.66% ■ FY20-21 ■ FY21-22 ■ FY22 Bud YTD ■ FY 22 Bud Operating Expenses 19,903,555 1,317,132 80.32% ,Capital Expenditures 263,372,825 65,538,851 78.53% Amount Percent Time Total Expenses 283,276,380 66,855,983 78.65% Remaining Remaining Remaining 2020 Bond Funds $12,870,168 12.10% 37.30% June 30, 2022 Change from FY21 Percent Change 2022 Bond Funds $293,560,433 100.00% 100.00% Available Cash $299,320,615 $239,695,687 402.01% (Included In Cash) I (Accounts Receivable 3,095,886 (1,977,026) -38.97% '., Public utilities Financial Dashboard As of June 30, 2022 - unaudited Stormwater FY22 Expense Detail 30,000,000 20.96% 25,000,000 20,000,000 0.84% Personal Services ■ O&M 15,000,000 52.64° ■ Charges & Services I ■ Debt Services 10,000,000 L 17.16%■ Capital Expenditures 5,000,000 8.40% 0 June 30, 2022 Change from FY21 Percent of Budget Revenues Expenses Operating Revenues $12,095,190 $1,229,443 110.99% ■ FY20-21 ■ FY21-22 ■ FY22 Bud YTD -A FY 22 Bud Operating Expenses 7,205,255 963,052 78.80% Capital Expenditures 9,735,516 1,250,720 73.53% Amount Percent Time Total Expenses 16,940,771 2,213,772 75.68% Remaining Remaining Remaining June 30, 2022 Change from FY21 Percent Change 2020 Bond Funds $9,657,507 66.37% 37.30% Available Cash $21,163,666 $1,117,210 5.57% (Included in Cash) Accounts Receivable 613,470 9,818 1.63% Public �= -X Utilities Financial Dashboard t ;T As of June 30, 2022 - unaudited Street Lighting FY22 Expense Detail 11.48% 5.95% 7,000,000 �0.02% , personal Services 4.56% 6,000,000 ■ O&M ■ Charges & Services 5,000,000 Debt Services 4,000,000 ■ Capital Expenditures 3,000,000 2,000,000 -----77.99% 1,000,000 0 June 30, 2022 Change from FY21 Percent of Budget Revenues Expenses Operating Revenues $4,325,132 $49,722 103.90% Operating Expenses 3,560,864 (890,384) 108.77% ■ FY20-21 ■ FY21-22 ■ FY22 Bud YTD FY 22 Bud Capital Expenditures 487,130 (104,265) 21.75% Total Expenses 4,047,994 (994,649) 73.42% June 30, 2022 Change from FY21 Percent Change Available Cash $5,551,121 $725,666 15.04% Accounts Receivable 139,557 (226,656) -61.89% '., Public utilities Financial Dashboard As of June 30, 2022 - unaudited Total Public Utilities June 30, 2022 Change from FY21 Percent of Budget Operating Revenues $153,993,025 ($3,963,762) 93.51% Operating Expenses $98,778,812 $4,847,231 83.83% Capital Expenditures $352,715,538 $56,202,623 80.76% Total Expenses $451,494,350 $61,049,854 81.41% June 30, 2022 Change from FY21 Percent Change Available Cash $442,223,239 $272,729,949 160.91% Accounts Receivable $8,813,870 ($3,086,489) -25.94% Delinquent Billings 0.64% Amount Percent Remaining Time Remaining 2020 Bond Funds $62,166,007 31.37% 37.30% 2022 Bond Funds $361,702,147 100.00% 100.00% (Included in Cash) Public �= -X Utilities Financial Dashboard As of July 31, 2022 Water Fund FY 23 Expense Detail 140,000,000 5.21% 0.97% ■ Personal Services I � 10.49 120,000,000 //- ■ O&M 100,000,000 0.70% ■ Charges &Services / Debt Services 80,000,000 60,000,000 — ■ Capital Expenditures 40,000,000 20,000,000 — 0 — . � I Revenues Expenses 82.63% July 31, 2022 Change from FY22 Percent of Budget ■ FY 21-22 ■ FY 22-23 ■ FY 23 Bud YTD FY 23 Bud Operating Revenues $12,862,562 ($1,445,866) 12.32% Operating Expenses 7,817,022 515,850 9.50% Amount Percent Time Capital Expenditures 38,744,638 (9,705,089) 87.49% Remaining Remaining Remaining Total Expenses 46,561,660 (9,189,239) 36.79% 2020 Bond Funds $37,528,348 48.57% 34.40% July 31, 2022 Change from FY22 Percent Change 2022 Bond Funds $68,141,714 100.00% 97.22% Available Cash $122,954,630 $29,817,358 32.01% (Included In cash) Accounts Receivable 6,994,576 4,474,226 177.52% '., Public utilities Financial Dashboard As of July 31, 2022 Sewer Fund FY23 Expense Detail 300,000,000 0.00% 0.19% i•2550.55% ■ Personal Services 250,000,000 ■ O&M ■ Charges & Services 200,000,000 Debt Service 150,000,000 ■ Capital Expenditures 100,000,000 50,000,000 99.01% 0 Revenues Expenses July 31, 2022 Change from FY22 Percent of Budget Operating Revenues $5,410,495 $729,224 7.95% ■ FY 21-22 ■ FY22-23 ■ FY23 Bud YTD FY 23 Bud Operating Expenses 1,894,791 111,411 6.94% Capital Expenditures 188,090,169 72,581,866 90.78% Amount Percent Time Total Expenses 189,984,960 72,693,277 81.02% Remaining Remaining Remaining 2020 Bond Funds $0 0.00% 34.40% July 31, 2022 Change from FY22 Percent Change 2022 Bond Funds $293,560,433 100.00% 97.22% Available Cash $301,481,741 $241,014,364 398.59% (Included in cash) Accounts Receivable 3,114,783 (623,414) -16.68% '., Public utilities Financial Dashboard As of July 31, 2022 Stormwater FY23 Expense Detail 20,000,000 4.89%� 0.14% 18,000,000 5.32% 1.84% 16,000,000 14,000,000 Personal Services 12,000,000 ■ O&M 10,000,000 ■ Charges & Services 8,000,000 ■ Debt Services 6,000,000 ■ Capital Expenditures 4,000,000 2,000,000 87.81% o ■ ■ 1101 July 31, 2022 Change from FY22 Percent of Budget Revenues Expenses Operating Revenues $1,066,596 $152,853 8.53% ■ FY21-22 ■ FY22-23 ■ FY23 Bud YTD ■ FY 23 Bud Operating Expenses 729,492 (91,641) 7.46% Capital Expenditures 6,188,323 1,623,846 84.06% Amount Percent Time Total Expenses 6,917,815 1,532,205 40.35% Remaining Remaining Remaining July 31, 2022 Change from FY22 Percent Change 2020 Bond Funds $9,453,142 64.96% 34.40% Available Cash $22,459,562 $2,105,903 10.35% ((Included in cash) Accounts Receivable 729,699 480,388 192.69% Public �= -X Utilities Financial Dashboard t ;T As of July 31, 2022 Street Lighting FY23 Expense Detail 5.36% 7,000,000 14.72% 0.00% , personal Services 6,000,000 3 73% ■ O&M ■ Charges & Services 5,000,000 Debt Services 4,000,000 ■ Capital Expenditures 3,000,000 2,000,000 -----76.19% 1,000,000 0 - ` July 31, 2022 Change from FY22 Percent of Budget Operating Revenues $184,953 ($1,120) 4.32% Revenues Expenses Operating Expenses 353,036 255,563 10.62% ■ FY21-22 ■ FY22-23 ■ FY23 Bud YTD FY 23 Bud Capital Expenditures 63,729 47,315 2.85% Total Expenses 416,765 302,878 7.49% July 31, 2022 Change from FY22 Percent Change Available Cash $5,353,713 ($124,915) -2.28% Accounts Receivable 233,467 7,306 3.23% Public Utilities Financial Dashboard As of July 31, 2022 Total Public Utilities July 31, 2022 Change from FY22 Percent of Budget Operating Revenues $19,524,606 ($564,909) 10.31% Operating Expenses $10,794,341 $791,183 8.80% Capital Expenditures $233,086,859 $64,547,938 89.28% Total Expenses $243,881,200 $65,339,121 63.55% July 31, 2022 Change from FY22 Percent Change Available Cash $452,249,646 $272,812,710 152.04% Accounts Receivable $11,072,525 $4,338,506 64.43% Delinquent Billings 0.55% Amount Percent Remaining Time Remaining 2020 Bond Funds $46,981,490 23.70% 34.40% 2022 Bond Funds $361,702,147 100.00% 97.22% (Included in Cash) '., Public ,.e Utilities Updates Budget items Rates — increases effective July 1, 2022 Water conservation Audit is currently in progress Additional funding opportunities