The URL can be used to link to this page

Home My WebLink About01/26/2023 - Meeting Materials ■ ■ ■ ■ Public SLC PUBLIC UTILITIES Financial Review : Financial Dashboard(November 30, 2022 and December 31, 2022) January 26, 2023 '., Public utilities Financial Dashboard As of November 30, 2022 Water Fund FY 23 Expense Detail 250,000,000 13.59% ■ Personal Services `2.08% ■ O&M 200,000,000 / ■ Charges & Services 150,000,000 Debt Services 24.82%0 Capital 100,000,000 Expenditures 50,000,000 55.93% 0 3.57% Revenues Expenses November 30, 2022 Change from FY22 Percent of Budget ■ FY 21-22 ■ FY 22-23 ■ FY 23 Bud YTD FY 23 Bud Operating Revenues $53,427,550 $9,160,792 51.17% Operating Expenses 32,069,195 1,701,116 37.71% Amount Percent Time Capital Expenditures 44,293,100 (11,116,215) 39.14% Remaining Remaining Remaining Total Expenses 76,362,295 (9,415,099) 38.52% 2020 Bond Funds $33,137,939 42.88% 23.30% November 30, 2022 Change from FY22 Percent Change 2022 Bond Funds $68,005,131 99.80% 86.00% Available Cash $130,796,711 $40,595,046 45.00% (Included In cash) Accounts Receivable 4,142,368 870,205 26.59% '., Public utilities Financial Dashboard As of November 30, 2022 Sewer Fund FY23 Expense Detail 500,000,000 1.85% 0.49%r 1.30% 3 88% 450,000,000 I ■ Personal Services 400,000,000 I ■ O&M 350,000,000 ■ Charges & Services 300,000,000 ■ Debt Service ■250,000,000 Capital Expenditures 200,000,000 150,000,000 100,000,000 50,000,000 oil 92.48% 0 Revenues Expenses November 30, 2022 Change from FY22 Percent of Budget ■ FY 21-22 ■ FY22-23 ■ FY23 Bud YTD ■ FY 23 Bud Operating Revenues $30,733,285 $7,141,187 45.13% Operating Expenses 9,484,086 825,570 34.21% Amount Percent Time Capital Expenditures 240,867,779 24,376,880 62.43% Remaining Remaining Remaining Total Expenses 250,351,865 25,202,450 60.54% 2020 Bond Funds $0 0.00% 23.30% November 30, 2022 Change from FY22 Percent Change 2022 Bond Funds $274,970,218 98.05% 86.00% Available Cash $265,304,185 $208,306,841 365.47% (Included in cash) Accounts Receivable 3,457,442 417,494 13.73% '., Public utilities Financial Dashboard As of November 30, 2022 Stormwater FY23 Expense Detail 30,000,000 12.39% 25,000,000 `0.96% 20,000,000 Personal Services ■ O&M L 18.31% 15,000,000 ■ Charges & Services ■ Debt Services 10,000,000 62.67 \ ■ Capital Expenditures 5,000,000 5.67% 0 November 30, 2022 Change from FY22 Percent of Budget Revenues Expenses Operating Revenues $5,921,198 $1,008,331 47.37% ■ FY21-22 ■ FY22-23 ■ FY23 Bud YTD -A FY 23 Bud Operating Expenses 3,613,376 554,575 35.76% Capital Expenditures 7,151,264 1,920,925 53.77% Amount Percent Time Total Expenses 10,764,640 2,475,500 46.00% Remaining Remaining Remaining November 30, 2022 Change from FY22 Percent Change 2020 Bond Funds $7,564,640 51.99% 23.30% Available Cash $22,084,605 $2,010,510 10.02% ((Included in cash) Accounts Receivable 783,195 155,237 24.72% Public �= -X Utilities Financial Dashboard t ;T As of November 30, 2022 Street Lighting FY23 Expense Detail 4.76% 6.53% 7,000,000 4.47°�� I �0.00% m 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.23% 1,000,000 0 November 30, 2022 Change from FY22 Percent of Budget Revenues Expenses Operating Revenues $1,659,194 ($21,737) 38.79% ■ FY21-22 ■ FY22-23 ■ FY23 Bud YTD FY 23 Bud Operating Expenses 1,638,608 385,701 49.21% Capital Expenditures 85,994 69,580 3.81% Total Expenses 1,724,602 455,281 30.87% November 30, 2022 Change from FY22 Percent Change Available Cash $5,510,560 ($287,478) -4.96% Accounts Receivable 228,869 48,242 26.71% Public Utilities Financial Dashboard As of November 30, 2022 Total Public Utilities November 30, 2022 Change from FY22 Percent of Budget Operating Revenues $91,741,227 $17,288,573 48.47% Operating Expenses $46,805,265 $3,466,962 37.09% Capital Expenditures $292,398,137 $15,251,170 56.83% Total Expenses $339,203,402 $18,718,132 52.94% November 30, 2022 Change from FY22 Percent Change Available Cash $423,696,061 $250,624,919 144.81% Accounts Receivable $8,611,874 $1,491,178 20.94% Delinquent Billings 0.99% Amount Percent Remaining Time Remaining 2020 Bond Funds $40,702,579 20.54% 23.30% 2022 Bond Funds $342,975,349 98.39% 86.00% (Included in Cash) '., Public utilities Financial Dashboard As of December 31, 2022 Water Fund FY 23 Expense Detail ■ Personal Services 250,000,000 14.99% ■ O&M 2.14% 200,000,000 ■ Charges & Services 150,000,000 Debt Services ■ Capital 100,000,000 �26.66% Expenditures 50,000,000 52.19% 0 4.03% Revenues Expenses December 31, 2022 Change from FY22 Percent of Budget ■ FY 21-22 ■ FY 22-23 ■ FY 23 Bud YTD FY 23 Bud Operating Revenues $53,065,717 $5,202,278 50.82% Operating Expenses 37,507,785 2,201,941 44.10% Amount Percent Time Capital Expenditures 44,704,146 (11,558,564) 39.41% Remaining Remaining Remaining Total Expenses 82,211,931 (9,356,623) 41.42% 2020 Bond Funds $33,137,939 42.88% 20.50% December 31, 2022 Change from FY22 Percent Change 2022 Bond Funds $68,005,131 99.80% 83.20% Available Cash $128,675,739 $43,129,004 50.42% (Included In cash) I jAccounts Receivable 2,658,447 (116,242) -4.19% '., Public utilities Financial Dashboard As of December 31, 2022 Sewer Fund FY23 Expense Detail 2.19% 0.53% 1.56% 500,000,000 \ I I 4.68% ■ Personal Services 450,000,000 ■ O&M 400,000,000 ■ Charges & Services 350,000,000 ■ Debt Service 300,000,000 ■ Capital Expenditures 250,000,000 200,000,000 150,000,000 100,000,000 50,000,000 91.04%J I HI 0 ■ December 31, 2022 Change from FY22 Percent of Budget Revenues Expenses■ FY 21-22 ■ FY22-23 FY23 Bud YTD r FY 23 Bud Operating Revenues $37,486,262 $8,821,319 55.05% Operating Expenses 11,288,554 1,204,295 40.72% Amount Percent Time Capital Expenditures 240,398,142 2,251,102 62.31% Remaining Remaining Remaining Total Expenses 251,686,696 3,455,397 60.86% 2020 Bond Funds $0 0.00% 20.50% December 31, 2022 Change from FY22 Percent Change 2022 Bond Funds $239,028,351 85.23% 83.20% Available Cash $267,392,488 $210,189,248 367.44% (Included in cash) Accounts Receivable 2,647,287 144,195 5.76% '., Public utilities Financial Dashboard As of December 31, 2022 Stormwater FY23 Expense Detail 30,000,000 14.14% 25,000,000 1.30% 20,000,000 Personal Services ■ O&M 15,000,000 L 18.555in Charges & Services 59.70% ■ Debt Services 10,000,000 ■ Capital Expenditures 5,000,000 6.31% 0 December 31, 2022 Change from FY22 Percent of Budget Revenues Expenses Operating Revenues $7,146,460 $1,134,207 57.17% ■ FY21-22 ■ FY22-23 ■ FY23 Bud YTD -A FY 23 Bud Operating Expenses 4,184,854 606,341 41.41% Capital Expenditures 7,349,462 2,274,321 55.26% Amount Percent Time Total Expenses 11,534,316 2,880,662 49.28% Remaining Remaining Remaining December 31, 2022 Change from FY22 Percent Change 2020 Bond Funds $7,564,640 51.99% 20.50% Available Cash $22,686,947 $2,110,329 10.26% (Included in Cash) Accounts Receivable 588,184 (38,646) -6.17% Public �= -X Utilities Financial Dashboard t ;T As of December 31, 2022 Street Lighting FY23 Expense Detail 6.36% 6.55% 7,000,000 4.44%� �0.00% m 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 82.65% 1,000,000 0 December 31, 2022 Change from FY22 Percent of Budget Revenues Expenses Operating Revenues $2,029,473 ($149,539) 47.45% ■ FY21-22 ■ FY22-23 ■ FY23 Bud YTD FY 23 Bud Operating Expenses 1,942,831 405,970 58.35% Capital Expenditures 138,499 122,085 6.14% Total Expenses 2,081,330 528,055 37.26% December 31, 2022 Change from FY22 Percent Change Available Cash $5,572,598 ($443,367) -7.37% Accounts Receivable 171,991 3,327 1.97% '., Public utilities Financial Dashboard As of December 31, 2022 Total Public Utilities December 311, 2022 Change from FY22 Percent of Budget Operating Revenues $99,727,912 $15,008,265 52.69% Operating Expenses $54,924,024 $4,418,547 43.52% Capital Expenditures $292,590,249 ($6,911,056) 56.83% Total Expenses $347,514,273 ($2,492,509) 54.21% December 31, 2022 Change from FY22 Percent Change Available Cash $424,327,772 $254,985,214 150.57% Accounts Receivable $6,065,909 ($7,366) -0.12% Delinquent Billings 1.93% Amount Percent Remaining Time Remaining 2020 Bond Funds $40,702,579 20.54% 20.50% 2022 Bond Funds $307,033,482 88.08% 83.20% (Included in Cash) '., Public Utilities Updates Budget items Budget subcommittee meetings — January 11 and January 25 FY2024 — Operational requests under review, capital will be refined in the coming weeks. Planning for FY2024 bond issue fall 2023 Funding opportunities/WIFIA updates I Publi IT ri Utilities Public Engagement Update 1 /26/2023 Chloe Morroni: Communications Ft Public Engagement Manager ► Ensure the involvement of residents and stakeholders D o affected by or interested aL�J 0 O in an issue o o Q Q ► Public engagement is top priority for SLCDPU pa Construction and programmatic public engagement Collaboration assessment tool o Determine the level of public LT @ jo 69D- 0 engagement needed (OUVeggN Working with consultant to create customized POP for SLCDPU �)�0000 ,T Consistent with the City's public engagement guidelines Public Utiliti s. Make P.re- Water Reclamation Facility City Council Tour Salt IaMe[iry'r New WMer Rttlamadon FxJlty • Coordinating if others want to tour COUNCIL • Councilwoman Victoria Petro R DISTRICT ONE -Article ran in January newsletter Mwm - F � �„ -••� - Post video, I photos and newsletter Happy New Yearl - Prepare SWAG packet for her IlprMmeap—Mlynrepresenlyvudlnrgmyflrtlye 1.ffi-1-11. •„�„„I,� y.,;1„�a,;l, ,a�,., - Involve in engagement activities was filled—M—y—rg nen -1.11dways ieme--n» —I —a mis nu..nenprs lnn°2 ,m Iin,m edu,mg go!to aha,e wm you a mpmw:d W,neghborham IogeRler 1 was elecxd n eryng°rye..•.re uoliiy.a„e erceua w,n a,an ar,rtin°en w by my peen m serve M Sall L C11y C-1 Vim Char and I lock forward b i4is°i""`r of m.miml —.rg with you I—— c.--.Iy e.•en Imrc Hlis w—,,g year. °N>a kmv Ine urrmi neamml bcary Im, aIr Other H y-bare any vmwons or cnr<r,n plea—dm'1 heaila!fo reach—! • Videos of Laura , wtip maMtlMaeak.,wn. • Implement Influent Pump Station Thanll you _ Action Plan • look for earned media opportunities ` C-1 hlerrbv V,—.P— p- WOr1801 5357713 1 p Coll 801 503-51W \ 1 ;Public Utiliti s. Make Pire, Water Reclamation Facility Winter Construction Flyer • Mailed to Rose Park area • Extra 200 printed to place in key buildings and distribute ac • Email to SLCDPU staff Email to SLC officials,community councils,and others Post on websiteJIM M+ HoNLow Construction aea ramweri ry, City Creek Canyon Water Treatment Plant Upgrades a ► Signage in canyon I ► Update closures on website &social media - -'_� ► Text alerts about access during construction ► Continue stakeholder outreach Presented to Greater Avenues Community Council (GACC) last month GACC included write up in newsletter d 1 4. Y _ ► KSL news story ► Launching 16-week public engagement campaign next month: Survey asking residents for feedback regarding w�it2� ;s •� �� '' the chosen design for the project. '1 ,.. i`, ► Survey will be live for a month u"fiet' a - �® ► Prepared mailers and social posts 1 14 BigCottonwood Canyon Water Treatment Plant Rebuild ► Public involvement plan - includes project website, email and hotline ' ► Key stakeholder coordination underway with Cottonwood Heights, Salt �. r. Lake County, UDOT, Rocky Mountain Power, Brighton Community Council, and Metropolitan Water District of Salt Lake and Sandy Continue meeting with other key stakeholders Murray, Holladay, Sandy, Brighton, US Forest Service, Millcreek, Utah DEQ- DDW, both ski resorts in the canyon, local advocacy and recreational groups .r.: Formed public engagement advisory group with representatives from " Wr SLCDPU, SLCo, UDOT, and Cottonwood Heights Meets in March ' No. Presented to Big Cottonwood Community Council -�- No. Will present to Association of Community Councils in March r ', ► Preparing educational outreach on water treatment to support need for project ' Program should roll out later this year '� Lead and Copper Rule Revisions Worked to notify every customer believed to have lead service lines Coordinating with Division of Drinking Water on public messaging before Oct 2024 deadline for inventory Public •'= Draft RFP for public outreach and engagement Outreach to pick up in Summer Revamped webpage Identify lead service lines and pipes, health effects of lead, and ways to mitigate impacts of lead - W Created customer survey to report lead service - - lines, schedule inspection, and send pictures for Water Meter identification Pilot study for inspection and sampling to refine I , service line identification process, assess impact of lead service lines Targeted about 50 homes that met criteria Water Main S.Water Water Service Line�I Outreach about SLCDPU providing filters to remove lead Created "lead hotline" and email lead@slcgov.com From the Water Main to the Water Meter Anything after the Water Meter to the Home Held six tabling events Robust stakeholder outreach in English and Spanish Watershed '`- Management Plan Engagement started fall of 2021 Advisory committee (3 total meetings; 1 held to-date) Stakeholder committee max. (8 total meeting; 4 held to-date) - ► Ad hoc work groups (TBD) ► Public open houses (4 total; 2 held to-date) Next round of engagement in coming months lo Expecting more input from stakeholders Need to be nimble if areas need more discussion and ad hoc work groups '" Overall objectives - have plan supported - Y and implemented with goal of keeping 1 �. - drinking water pure Adopt A Storm Drain rc► Continue to educate through presentations ► Promote program - website, social media, newsletters N o News release great media coverage " LSalt LA, 95 drains adopted ,, yrr : c . Adopt a Stom Drain Program �. � r o F. 0. G Fe0eGe- 0o. Continue to educate food service establishments Keep Fats,Oils&Grease ► Small budget to expand outreach to homeowners with help from consultant Out of Your Drain! ► Promote program on website and social media - ► News release - great media coverage ` � 9 I Publi IT ri Utilities Public Engagement Update 1 /26/2023 Chloe Morroni: Communications Ft Public Engagement Manager ■ ■ ■ ■ Public SLC PUBLIC UTILITIES Financial Review : Financial Dashboard(November 30, 2022 and December 31, 2022) January 26, 2023 '., Public utilities Financial Dashboard As of November 30, 2022 Water Fund FY 23 Expense Detail 250,000,000 13.59% ■ Personal Services `2.08% ■ O&M 200,000,000 / ■ Charges & Services 150,000,000 Debt Services 24.82%0 Capital 100,000,000 Expenditures 50,000,000 55.93% 0 3.57% Revenues Expenses November 30, 2022 Change from FY22 Percent of Budget ■ FY 21-22 ■ FY 22-23 ■ FY 23 Bud YTD FY 23 Bud Operating Revenues $53,427,550 $9,160,792 51.17% Operating Expenses 32,069,195 1,701,116 37.71% Amount Percent Time Capital Expenditures 44,293,100 (11,116,215) 39.14% Remaining Remaining Remaining Total Expenses 76,362,295 (9,415,099) 38.52% 2020 Bond Funds $33,137,939 42.88% 23.30% November 30, 2022 Change from FY22 Percent Change 2022 Bond Funds $68,005,131 99.80% 86.00% Available Cash $130,796,711 $40,595,046 45.00% (Included In cash) Accounts Receivable 4,142,368 870,205 26.59% '., Public utilities Financial Dashboard As of November 30, 2022 Sewer Fund FY23 Expense Detail 500,000,000 1.85% 0.49%r 1.30% 3 88% 450,000,000 I ■ Personal Services 400,000,000 I ■ O&M 350,000,000 ■ Charges & Services 300,000,000 ■ Debt Service ■250,000,000 Capital Expenditures 200,000,000 150,000,000 100,000,000 50,000,000 oil 92.48% 0 Revenues Expenses November 30, 2022 Change from FY22 Percent of Budget ■ FY 21-22 ■ FY22-23 ■ FY23 Bud YTD ■ FY 23 Bud Operating Revenues $30,733,285 $7,141,187 45.13% Operating Expenses 9,484,086 825,570 34.21% Amount Percent Time Capital Expenditures 240,867,779 24,376,880 62.43% Remaining Remaining Remaining Total Expenses 250,351,865 25,202,450 60.54% 2020 Bond Funds $0 0.00% 23.30% November 30, 2022 Change from FY22 Percent Change 2022 Bond Funds $274,970,218 98.05% 86.00% Available Cash $265,304,185 $208,306,841 365.47% (Included in cash) Accounts Receivable 3,457,442 417,494 13.73% '., Public utilities Financial Dashboard As of November 30, 2022 Stormwater FY23 Expense Detail 30,000,000 12.39% 25,000,000 `0.96% 20,000,000 Personal Services ■ O&M L 18.31% 15,000,000 ■ Charges & Services ■ Debt Services 10,000,000 62.67 \ ■ Capital Expenditures 5,000,000 5.67% 0 November 30, 2022 Change from FY22 Percent of Budget Revenues Expenses Operating Revenues $5,921,198 $1,008,331 47.37% ■ FY21-22 ■ FY22-23 ■ FY23 Bud YTD -A FY 23 Bud Operating Expenses 3,613,376 554,575 35.76% Capital Expenditures 7,151,264 1,920,925 53.77% Amount Percent Time Total Expenses 10,764,640 2,475,500 46.00% Remaining Remaining Remaining November 30, 2022 Change from FY22 Percent Change 2020 Bond Funds $7,564,640 51.99% 23.30% Available Cash $22,084,605 $2,010,510 10.02% ((Included in cash) Accounts Receivable 783,195 155,237 24.72% Public �= -X Utilities Financial Dashboard t ;T As of November 30, 2022 Street Lighting FY23 Expense Detail 4.76% 6.53% 7,000,000 4.47°�� I �0.00% m 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.23% 1,000,000 0 November 30, 2022 Change from FY22 Percent of Budget Revenues Expenses Operating Revenues $1,659,194 ($21,737) 38.79% ■ FY21-22 ■ FY22-23 ■ FY23 Bud YTD FY 23 Bud Operating Expenses 1,638,608 385,701 49.21% Capital Expenditures 85,994 69,580 3.81% Total Expenses 1,724,602 455,281 30.87% November 30, 2022 Change from FY22 Percent Change Available Cash $5,510,560 ($287,478) -4.96% Accounts Receivable 228,869 48,242 26.71% Public Utilities Financial Dashboard As of November 30, 2022 Total Public Utilities November 30, 2022 Change from FY22 Percent of Budget Operating Revenues $91,741,227 $17,288,573 48.47% Operating Expenses $46,805,265 $3,466,962 37.09% Capital Expenditures $292,398,137 $15,251,170 56.83% Total Expenses $339,203,402 $18,718,132 52.94% November 30, 2022 Change from FY22 Percent Change Available Cash $423,696,061 $250,624,919 144.81% Accounts Receivable $8,611,874 $1,491,178 20.94% Delinquent Billings 0.99% Amount Percent Remaining Time Remaining 2020 Bond Funds $40,702,579 20.54% 23.30% 2022 Bond Funds $342,975,349 98.39% 86.00% (Included in Cash) '., Public utilities Financial Dashboard As of December 31, 2022 Water Fund FY 23 Expense Detail ■ Personal Services 250,000,000 14.99% ■ O&M 2.14% 200,000,000 ■ Charges & Services 150,000,000 Debt Services ■ Capital 100,000,000 �26.66% Expenditures 50,000,000 52.19% 0 4.03% Revenues Expenses December 31, 2022 Change from FY22 Percent of Budget ■ FY 21-22 ■ FY 22-23 ■ FY 23 Bud YTD FY 23 Bud Operating Revenues $53,065,717 $5,202,278 50.82% Operating Expenses 37,507,785 2,201,941 44.10% Amount Percent Time Capital Expenditures 44,704,146 (11,558,564) 39.41% Remaining Remaining Remaining Total Expenses 82,211,931 (9,356,623) 41.42% 2020 Bond Funds $33,137,939 42.88% 20.50% December 31, 2022 Change from FY22 Percent Change 2022 Bond Funds $68,005,131 99.80% 83.20% Available Cash $128,675,739 $43,129,004 50.42% (Included In cash) I jAccounts Receivable 2,658,447 (116,242) -4.19% '., Public utilities Financial Dashboard As of December 31, 2022 Sewer Fund FY23 Expense Detail 2.19% 0.53% 1.56% 500,000,000 \ I I 4.68% ■ Personal Services 450,000,000 ■ O&M 400,000,000 ■ Charges & Services 350,000,000 ■ Debt Service 300,000,000 ■ Capital Expenditures 250,000,000 200,000,000 150,000,000 100,000,000 50,000,000 91.04%J I HI 0 ■ December 31, 2022 Change from FY22 Percent of Budget Revenues Expenses■ FY 21-22 ■ FY22-23 FY23 Bud YTD r FY 23 Bud Operating Revenues $37,486,262 $8,821,319 55.05% Operating Expenses 11,288,554 1,204,295 40.72% Amount Percent Time Capital Expenditures 240,398,142 2,251,102 62.31% Remaining Remaining Remaining Total Expenses 251,686,696 3,455,397 60.86% 2020 Bond Funds $0 0.00% 20.50% December 31, 2022 Change from FY22 Percent Change 2022 Bond Funds $239,028,351 85.23% 83.20% Available Cash $267,392,488 $210,189,248 367.44% (Included in cash) Accounts Receivable 2,647,287 144,195 5.76% '., Public utilities Financial Dashboard As of December 31, 2022 Stormwater FY23 Expense Detail 30,000,000 14.14% 25,000,000 1.30% 20,000,000 Personal Services ■ O&M 15,000,000 L 18.555in Charges & Services 59.70% ■ Debt Services 10,000,000 ■ Capital Expenditures 5,000,000 6.31% 0 December 31, 2022 Change from FY22 Percent of Budget Revenues Expenses Operating Revenues $7,146,460 $1,134,207 57.17% ■ FY21-22 ■ FY22-23 ■ FY23 Bud YTD -A FY 23 Bud Operating Expenses 4,184,854 606,341 41.41% Capital Expenditures 7,349,462 2,274,321 55.26% Amount Percent Time Total Expenses 11,534,316 2,880,662 49.28% Remaining Remaining Remaining December 31, 2022 Change from FY22 Percent Change 2020 Bond Funds $7,564,640 51.99% 20.50% Available Cash $22,686,947 $2,110,329 10.26% (Included in Cash) Accounts Receivable 588,184 (38,646) -6.17% Public �= -X Utilities Financial Dashboard t ;T As of December 31, 2022 Street Lighting FY23 Expense Detail 6.36% 6.55% 7,000,000 4.44%� �0.00% m 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 82.65% 1,000,000 0 December 31, 2022 Change from FY22 Percent of Budget Revenues Expenses Operating Revenues $2,029,473 ($149,539) 47.45% ■ FY21-22 ■ FY22-23 ■ FY23 Bud YTD FY 23 Bud Operating Expenses 1,942,831 405,970 58.35% Capital Expenditures 138,499 122,085 6.14% Total Expenses 2,081,330 528,055 37.26% December 31, 2022 Change from FY22 Percent Change Available Cash $5,572,598 ($443,367) -7.37% Accounts Receivable 171,991 3,327 1.97% '., Public utilities Financial Dashboard As of December 31, 2022 Total Public Utilities December 311, 2022 Change from FY22 Percent of Budget Operating Revenues $99,727,912 $15,008,265 52.69% Operating Expenses $54,924,024 $4,418,547 43.52% Capital Expenditures $292,590,249 ($6,911,056) 56.83% Total Expenses $347,514,273 ($2,492,509) 54.21% December 31, 2022 Change from FY22 Percent Change Available Cash $424,327,772 $254,985,214 150.57% Accounts Receivable $6,065,909 ($7,366) -0.12% Delinquent Billings 1.93% Amount Percent Remaining Time Remaining 2020 Bond Funds $40,702,579 20.54% 20.50% 2022 Bond Funds $307,033,482 88.08% 83.20% (Included in Cash) '., Public Utilities Updates Budget items Budget subcommittee meetings — January 11 and January 25 FY2024 — Operational requests under review, capital will be refined in the coming weeks. Planning for FY2024 bond issue fall 2023 Funding opportunities/WIFIA updates