The URL can be used to link to this page

Home My WebLink About09/23/2021 - Meeting Materials rlv . Public Utilities PUAC Capital Projects Update Jesse Stewart September 23, 2021 F Public Utilities Upcoming Budgeting for FY 22 Next PUAC Budget Subcommittee Overview of Budget Process American Rescue Plan (ARPA) funding Application: Stormwater: Granary District Flood Plain Mitigation and Re-Mapping: $11.45M WRF: Influent Pump Station and Force Mains: $10M F Public UtWfi s Background Aging Infrastructure (all Utilities) Generational Projects as well as Local Projects (WRF, WTPs, Water Transmission, Sewer Trunk lines, Master planning) Costs (Labor and supply chain issues has driven costs up) Funding Sources (WIFIA, BRIC, ARPA) FPubli ( - � I 1 +41 - Some FY20/21 Numbers Engineering Activity FY 20/21 Ending June 30, 2021 Awards/Amendments/Change Orders Number Value Engineering Agreement Awards 18 $ 3,828,378 WRF Project 21 $ 57,812,361 Professional Services On-call WTO Authorization 71 $ %755,866 Engineering Amendments 17 $ 13,158,381 Construction Contract Awards 48 $ 58,954,746 Construction On-call WTO Authorization 9 $ 554,563 Construction Change Orders 99 $ 844,540 283 $ 144,908,835 Invoices Processed 656 $ 31,282,484 Payment Applications Processed 202 $ 75,095,587 858 $ 106,378,071 Projects Completed Substantially Complete Projects Consultant 37 $ 1,959,929 Substantially Complete Projects Contractor $ 45,257,815 Active Projects Water Sewer Storm Water Projects in Design 83 49 20 Projects in Construction 1 37 37 14 MJ F Pu loll FY20/21 Procurement Overview IFY 1 /20 Design and construct (no IfF F) Program Planned Contracted Water 45 33 73% .Sewer Collections 19 15 7 % .Stormwater 15 3 0% Total 79 51 5% F 0 1 Design and Construct (no WF F) Program Planned Contracted % Water 41 46 11 % Sewer Collections 21 34 1 % tormwater 11 6 55% Total 73 86 11 % F Public + � Utilities FY20/21 Projects Overview $140,000,000 SLCDPU Engineering Activity FY 20/21 O $120,000,000 Capital Projects, O Water, Sewer and Stormwater o $100,000,000 Excluding the WRF O O $80,000,000 O $60,000,000 O O O $40,000,000 O 8 � $120.2 M $20,000,000 $86.5 M 72% $0 July Aug Sept Oct Nov C Mar Apr May June Public Utilities J Pro FY20/21 jects Overview $250,000,000 SLCDPU Engineering Activity FY 20/21 0 $ZooAK= . Capital Projects, o Water, Sewer and $150,000,000 Stormwater Including the WRF o 0-0 ` f $100,000,000 $50,000,000 - 162.1 M -76% $0 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June 4,;LPublic �� Ufili ies J Pro FY20/21 jects Overview $70,000,000.00 Water $60,000,000.00 $50,000,000.00 $40,000,000.00 $30,000,000.00 $60,000,000.00 $20,000,000.00 Sewer ' •• $66,4 M $50,000,000.00 $10,000,000.00 • • • • $44.5M 61% $40,000,000.00 $0.00 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June $30,000,000.00 $20,000,000.00 $10,000,000.00 • $47.5 M $7,000,000.00 • • � - -• 535.71M 75 Stormwater $0.00 $6,000,000.00 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June $5,000,000.00 $4,000,000.00 $3,000,000.00 $2,000,000.00 $1,000,000.00 $6.3 M • • • . $6.3 M 99% $0.00 July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June W. . - - ONE F Public Utilities Significant Projects Water Stormwater: 4t" Avenue Well Master Plan East West Conveyance Fort Douglas Tank Clean-out Box rehab BCWTP Alternatives Analysis Detention Basin Deepening CCWTP Master Planning Jordan River Watershed Project Sewer: Streetlighting: 500 South and State Street (MP-11) Master Plan 700 South lift Station 1800 North Re-alignment 2100 South Project: 2300 E - Highland WRF ¢Sc STOP _ STOP , r� S ► 1 :� i fl �y. r w. 1 F Public Utilities Fort Douglas Tank .p .�Y https://www.dropbox.com/s/tls27kreirglzjd/DJI 0002.MOV?dl=0 F Public Utilities East West Conveyance r „oog Coatsvilie RKe . Ire:: Salt Lake City 21W 5 21006 ur.sua. r ,r,— — - - y y, Terminal A � ]iS Mill rt': Reservoir PHASE 3 5(In Design) 'Phasing dependent upon ovgYable funding. t> �1 t c¢1l j` �� Public Utilities 500 South State Street Diversion,, MP11 s�!rP �y,• �' �` yV\, �` '�';�$t. y •t R: � i"as� • `} ,4�i.-'a��1.j�.r -�� ,�5 � �Si ~ �� =`R Z.��`�*�'�'4��C.�``��1 t' �v^S�Li+s,�Ur4J {, 't� ►'4. _,.T �.: 'cT:: k+ti` �iyx �' .mot• �i Public Umities 700 South Pump Station and Force Mains `T' 1 --?L-IPF r /., 1; b 11 MR ' Public Utilities 1800 North Sewer Realignment ■ . ■ 1800 N o 3 ■ U) z D . n L s 3 °l a ■ LQ 0 172 Increase Reliability, • N .O MAP KEY . Phase 1 Rosewood Park . Phase 2 . Everett Ave — Phase 3 . Public ` .i Utilities 2100 South Capacity Upgrade Project Westminster Ave IT O j 0 0 0 0 0 0 0 0 0 0 ^� M m m m m v rt (A 4A v v v rt rt N (A (A rt rt rt 2100 South - c 3 v • r�r Willmington Ave ` ' • • sCIO • - D • Parkway Ave 16 �C r P + x Utilities Emergency Clean out Box repair _ rc% Public y 1_ Public Utilities Master Plan US 7-� 89 e-�� lab sT 1b Legend ,1h r Master Plan Detention Facilities Area 4 Solution ID 600 �-r �`� l 3a J3b �1 3 d� —T— T— — 6a - 5a 1 5b 4 a 2dt 3 I +5 n •oee 2 oaa 4 ON 1=cct HARSEn Area 4 FIGURE - �LLUCEn SLCDPU Capital Improvement Projects 5-1 L9 F Public Utilities Questions / Comments? y ,� f1 {,•` _ � �� •� ��..� .� is d' t i• y t ■ ■ ■ ■ Public SLC PUBLIC UTILITIES Financial Review : Financial Dashboard(June 30, 2021 - unaudited, July 31, 2021) September 23, 2021 Public � � utilities Financial Dashboard As of June 30, 2021 Water Fund FY 21 Expense Detail ■ Personal Services 180,000,000 14.86 160,000,000 ■ O&M 2.58% 140,000,000 r ■ Charges &Services 120,000,000 ■ Debt Services 100,000,000 Capital 80,000,000 23.48%■ Ca p \ Expenditures 60,000,000 40,000,000 20,000,000 56.71% _ 2.37%0 Revenues Expenses June 30, 2021 Change from FY20 Percent of Budget FY 19-20 ■ FY 20-21 ■ FY 21 Bud YTD FY 21 Bud Operating Revenues $88,721,920 $5,788,045 117.64% Operating Expenses 64,651,707 3,672,016 86.55% Capital Expenditures 89,602,750 25,258,587 104.35% Amount Percent Time Total Expenses 154,254,457 28,930,603 96.07% Remaining Remaining Remaining June 30, 2021 Change from FY20 Percent Change 2020 Bond Funds $68,026,880 88.03% 70.60% Available Cash $84,996,451 $61,529,988 262.20% (Included in cash) Accounts Receivable 5,857,582 (607,995) -9.40% Public <: r utilities Financial Dashboard As of June 30, 2021 Sewer Fund FY21 Expense Detail 300,000,000 4 48% 0 72%`2 85% / 6.26`- Personal Services 250,000,000 - O&M 200,000,000 Charges & Services ■ Debt Service 150,000,000 ■ Capital Expenditures 100,000,000 50,000,000 / 85.69%J 0 Revenues Expenses June 30, 2021 Change from FY20 Percent of Budget ■ FY19-20 ■ FY20-21 ■ FY21 Bud YTD ■ FY 21 Bud Operating Revenues $54,093,710 $7,840,442 104.57% Operating Expenses 18,583,423 759,121 79.31% Capital Expenditures 197,833,974 72,046,551 84.95% Amount Percent Time Total Expenses 216,417,397 72,805,672 84.44% Remaining Remaining Remaining June 30, 2021 Change from FY20 Percent Change 2020 Bond Funds $50,209,061 47.20% 70.60% Available Cash $59,624,928 ($9,928,014) -14.27% (Included in Cash) Accounts Receivable 2,880,372 (463,534) -13.86% Public ¢= -� Utilities Financial Dashboard As of June 30, 2021 Stormwater FY21 Expense Detail 30,000,000 18.77% 25,000,000 52.24% 20,000,000 �1.29% ■ Personal Services / ■ O&M 15,000,000 ■ Charges & Services Debt Services 10,000,000 18.37% ■ Capital Expenditures 5,000,000 9.33% 0 Revenues Expenses June 30, 2021 Change from FY20 Percent of Budget Operating Revenues $10,865,747 $50,285 108.27% ■ FY19-20 ■ FY20-21 ■ FY21 Bud YTD FY 21 Bud Operating Expenses 6,242,203 226,403 71.91% Capital Expenditures 8,484,796 (573,190) 68.89% Amount Percent Time Total Expenses 14,726,999 (346,787) 70.14% Remaining Remaining Remaining June 30, 2021 Change from FY20 Percent Change 2020 Bond Funds $11,943,841 82.08% 70.60% Available Cash $20,046,456 $14,112,422 237.82% (Included in cash) Accounts Receivable 603,652 (196,975) -24.60% Public <: r utilities Financial Dashboard As of June 30, 2021 Street Lighting FY21 Expense Detail 6,000,000 11.29% 5.16% 0.00% ■ Personal Services � — 3.70% 5,000,000 ■ O&M ■ Charges & Services 4,000,000 - Debt Services ■ Capital Expenditures 3,000,000 - 2,000,000 - 79.85% 1,000,000 - 0 - June 30, 2021 Change from FY20 Percent of Budget Revenues Expenses Operating Revenues $4,275,410 $65,574 100.82% ■ FY19-20 ■ FY20-21 ■ FY21 Bud YTD L FY 21 Bud Operating Expenses 4,451,248 1,771,516 149.51% Capital Expenditures 591,395 (248,432) 26.21% Total Expenses 5,042,643 1,523,084 96.35% June 30, 2021 Change from FY20 Percent Change Available Cash $4,794,045 ($1,182,773) -19.79% Accounts Receivable 197,845 (76,714) -27.94% Public f � utilities Financial Dashboard As of June 30, 2021 Total Public Utilities June 30, 2021 Change from FY20 Percent of Budget Operating Revenues $157,956,787 $13,744,346 111.69% Operating Expenses $93,928,581 $6,429,056 85.55% Capital Expenditures $296,512,915 $96,483,516 88.96% Total Expenses $390,441,496 $102,912,572 88.12% June 30, 2021 Change from FY20 Percent Change Available Cash $169,461,880 $64,531,623 61.50% Accounts Receivable $9,235,472 ($1,649,197) -15.15% Delinquent Billings 0.53% Amount Percent Remaining Time Remaining 2020 Bond Funds $130,179,783 65.68% 70.60% (Included in Cash) Public ¢= -� Utilities Financial Dashboard As of July 31, 2021 Water Fund FY 22 Expense Detail r 140,000,000 4.38% 0.449g 20% ■ Personal Services 120,000,000 / ■ O&M 0.59% 100,000,000 / ■ Charges & Services Debt Services 80,000,000 60,000,000 ■ Capital Expenditures 40,000,000 20,000,000 � � �0 Revenues Expenses 86.39% July 31, 2021 Change from FY21 Percent of Budget ■ FY 20-21 ■ FY 21-22 ■ FY 22 Bud YTD FY 22 Bud Operating Revenues $14,308,428 $244,268 15.79% Operating Expenses 7,301,172 (562,832) 9.26% Capital Expenditures 48,449,727 11,254,878 56.42% Amount Percent Time Total Expenses 55,750,899 10,692,046 33.85% Remaining Remaining Remaining July 31, 2021 Change from FY21 Percent Change 2020 Bond Funds $65,941,865 85.34% 67.80% Available Cash $93,137,272 $62,269,815 201.73% (Included in Cash) Accounts Receivable 8,402,382 2,480,730 41.89% Public <: r utilities Financial Dashboard As of July 31, 2021 Sewer Fund FY22 Expense Detail 300,000,000 0.88% 0.19% 0.44% 0.88% I/250,000,000 Personal Services O&M 200,000,000 Charges & Services ■ Debt Service 150,000,000 — ■ Capital Expenditures 100,000,000 50,000,000 ■ NEI0 97.61% Revenues Expenses July 31, 2021 Change from FY21 Percent of Budget ■ FY20-21 ■ FY21-22 ■ FY22 Bud YTD ■ FY 22 Bud Operating Revenues $4,681,271 $477,632 7.99% Operating Expenses 1,783,380 232,722 7.28% Capital Expenditures 115,508,303 7,653,900 50.78% Amount Percent Time Total Expenses 117,291,683 7,886,622 46.55% Remaining Remaining Remaining July 31, 2021 Change from FY21 Percent Change 2020 Bond Funds $43,063,249 40.48% 67.80% Available Cash $60,467,377 $48,483,943 404.59% (Included in Cash) Accounts Receivable 3,738,197 (281,366) -7.00% Public ¢= -� Utilities Financial Dashboard As of July 31, 2021 Stormwater FY22 Expense Detail 25,000,000 5.81 `0.17% 9.18% 20,000,000 � �0.54% ■ Personal Services 15,000,000 _ O&M ■ Charges & Services 10,000,000 Debt Services ■ Capital Expenditures 5,000,000 84.29% Revenues Expenses July 31, 2021 Change from FY21 Percent of Budget Operating Revenues $913,743 ($28,990) 8.38% ■ FY20-21 ■ FY21-22 ■ FY22 Bud YTD FY 22 Bud Operating Expenses 821,133 44,310 9.41% Capital Expenditures 4,564,477 (23,136) 52.17% Amount Percent Time Total Expenses 5,385,610 21,174 30.82% Remaining Remaining Remaining July 31, 2021 Change from FY21 Percent Change 2020 Bond Funds $11,636,200 79.97% 67.80% Available Cash $20,353,659 $15,288,777 301.86% (Included in Cash) Accounts Receivable 708,040 (289,795) -29.04% Public <: r utilities Financial Dashboard As of July 31, 2021 Street Lighting FY21 Expense Detail 6,000,000 12.62% 1 19.05% ■ Personal Services 5,000,000 ■ O&M 16 12.40% 0.00!Charges & Services 4,000,000 Debt Services ■ Capital Expenditures 3,000,000 2,000,000 55.92% 1,000,000 July 31, 2021 Change from FY20 Percent of Budget Revenues Expenses Operating Revenues $186,073 ($179,002) 4.47% ■ FY20-21 ■ FY21-22 ■ FY22 Bud YTD FY 22 Bud Operating Expenses 97,473 (198,671) 2.98% Capital Expenditures 16,414 (73,280) 0.73% Total Expenses 113,887 (271,951) 2.07% July 31, 2021 Change from FY20 Percent Change Available Cash $5,478,628 ($108,324) -1.94% Accounts Receivable 226,161 (346,296) -60.49% Public utilities Financial Dashboard As of July 31, 2021 Total Public Utilities July 31, 2021 Change from FY20 Percent of Budget Operating Revenues $20,089,515 $513,908 12.23% Operating Expenses $10,003,158 ($484,471) 8.67% Capital Expenditures $168,538,921 $18,812,362 51.97% Total Expenses $178,542,079 $18,327,891 40.61% July 31, 2021 Change from FY20 Percent Change Available Cash $179,436,936 $125,934,211 235.38% Accounts Receivable $13,074,780 $1,563,273 13.58% Delinquent Billings 0.35% Amount Percent Remaining Time Remaining 2020 Bond Funds $120,641,315 60.87% 67.80% (Included in Cash) PublicEL Utilities �T:�� Updates Budget Items Rates Pay increases Water conservation Audit is currently in progress Additional funding opportunities State water assistance program