Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
11-21-22 FCA
C IT Y C O UNC I L/F INANC I AL C O M M IS S IO N M E E T I NG City Hall Council Chambers November 21, 2022 AGE NDA 1.Call to Order The City Council requests that attendees turn off cell phones and pagers during the meeting. A copy of the full City C ounc il packet is available to the public . The packet ring binder is loc ated at the entrance of the council chambers. 2.Roll Call 3.Discussion Items a.Central Garage b.Utilities 4.Future M eetings a.Budget M eeting December 5, 2022 5.Adjourn 6. 7. CENTRAL GARAGE FUND -70100 INTERNAL SERVICE FUND ?/J)/1 '!tfJ Jo ~Ill) 4%rt/ 'j))J/t; J&l8 '2G+9-. .2e2{)' September "'"202i 2022' Object Code I Descri[!tlon Actual Actual YTD Budget Budget Change 49951 -CENTRAL GARAGE OPERATIONS OPERATING REVENUES 4862 -FUEL SALES-INTERNAL 167,275 158,725 168,048 345,000 400,000 15.94% 4863 -REPLACEMENT CHARGES 1,057,511 955,346 1,000,839 1,321,339 -100.00% 4864 -OVERHEAD CHARGES 135,759 300,345 197,631 260,796 -100.00% 4865 -REPAIR/MAINT CHARGES 337,867 428,578 247,489 400,000 -100.00% TOTAL SALES AND USER FEES 1,698,412 1,842,994 1,614,007 2,327,135 400,000 -82.81% TOTAL OPERATING REVENUES 1,698,412 1,842,994 1,614,007 2,327,135 400,000 -82.81% OPERATING EXPENSES 6101 -WAGES & SALARIES-FT EMPLOYEES 315,229 331,676 320,709 453,675 477,500 5.25% 6102 -OVERTIME-FT EMPLOYEES 1,157 1,104 228 600 600 0.00% 6111-SEVERANCEPAY 3,037 7,542 0.00% 6122-PERA COORDINATED PLAN 23,729 24,959 24,070 34,071 35,859 5.25% 6125 -FICA-SOCIAL SECURITY 19,323 20,389 19,568 28,164 29,642 5.25% 6126 -FICA-MEDICARE 4,552 4,769 4,577 6,586 6,934 5.28% 6131 -CAFETERIA PLAN CONTRIBUTIONS 73,138 67,615 62,951 99,792 102,786 3.00% 6151 -WORKER'S COMP INSURANCE 13,442 11,787 10,341 15,023 14,381 -4.27% TOTAL PERSONAL SERVICES 453,607 469,841 442,444 637,911 667,702 4.67% 6201 -OFFICE SUPPLIES 450 419 530 500 500 0.00% 6203-BOOKS/REFERENCE MATERIALS 35 200 200 0.00% 6212-MOTOR FUELS 195,748 196,471 184,874 345,800 503,100 45.49% 6213-LUBRICANTS & ADDITIVES 14,285 16,253 12,650 19,000 19,000 0.00% 6215-SHOP MATERIALS 10,762 12,586 9,759 10,000 10,000 0.00% 6217 -SAFETY SUPPLIES 4,243 2,878 1,141 5,000 3,000 -40.00% 6218 -WELDING SUPPLIES 5,751 5,393 2,480 5,000 5,000 0.00% 6219-GENERAL OPERATING SUPPLIES 1,263 1,309 106 1,450 1,500 3.45% 6221 -MOTOR VEHICLES 90,193 108,745 81,038 92,882 100,000 7.66% 6222-TIRES 17,402 17,980 7,354 19,100 19,100 0.00% 6227 -PAINT SUPPLIES 37 210 210 0.00% 6239 -OTHER REPAIR & MAINT SUPPLIES 310 2,000 2,000 0.00% 6241 -SMALL TOOLS 3,808 4,714 1,089 4,000 4,000 0.00% 6242 -MINOR EQUIPMENT 9,507 17,529 11,135 17,500 17,500 0.00% 6243 -MINOR COMPUTER EQUIPMENT 316 4,945 0.00% TOTAL SUPPLIES 353,728 389,569 312,191 522,642 .685,110 31.09% 6307 -PROFESSIONAL SERVICES 3,686 4,789 1,818 4,500 4,500 0.00% 6321 -TELEPHONE/PAGERS 729 347 110 1,100 1,100 0.00% 6323 -RADIO COMMUNICATIONS 2,940 3,017 1,853 3,152 3,152 0.00% 6333-FREIGHT/DRAYAGE 110 28 620 620 0.00% 6351 -PRINTING 340 340 0.00% 6401 -MOTOR VEHICLE SERVICES 96,366 170,524 75,910 85,000 85,000 0.00% 6402 -EQUIPMENT SERVICES 2,929 618 913 5,950 5,950 0.00% 6406 -MUL Tl-FUNCTION MTN CE 694 824 1,003 0.00% 6417-UNIFORMS 4,452 3,642 1,809 3,863 3,979 3.00% 6421 -SOFTWARE LICENSE 23,682 136 770 7,000 -100.00% 6422 -SOFTWARE MAINT 8,032 6,924 9,983 8,500 100.00% 6423 -LOGIS CHARGES 5,521 6,146 4,538 6,000 7,428 23.80% 6432 -CONFERENCES AND SCHOOLS 1,244 926 3,000 3,000 0.00% 6433 -MEETING EXPENSES 100 400 300.00% 6434 -DUES & SUBSCRIPTIONS 1,047 1,245 742 1,000 1,000 0.00% 6441 -LICENSES, TAXES & FEES 10,314 9,448 6,415 17,200 16,200 -5.81% 6447 -TOWING CHARGES 2,779 1,131 4,143 3,000 3,000 0.00% 6449 -OTHER CONTRACTUAL SERVICE 4,233 5,580 3,927 3,000 5,000 66.67% 6471 -ADMINISTRATIVE SERVICE TRANSFEF 42,314 57,132 42,494 56,658 65,318 15.28% TOTAL SERVICES & OTHER CHARGES 209,828 272,775 157,354 201,483 214,487 6.45% 6363 -MOTOR VEHICLE INSURANCE 55,500 55,729 41,228 57,500 60,000 4.35% 6367 -EQUIPMENT (INLAND MARINE) 10,615 10,934 6,965 12,500 12,500 0.00% TOTAL INSURANCE 66,115 66,663 48,193 70,000 72,500 3.57% 6388 -HAZARDOUS WASTE DISPOSAL 537 3,614 1,155 1,500 800 -46.67% TOTAL UTILITIES 537 3,614 1,155 1,500 800 -46.67% 2021 2019 2020 September 2021 2022 Object Code I Descri~tion Actual Actual YTD Budget Budget Change 6461 -FUEL CHARGES 1,872 1,847 2,192 1,700 -100.00% 6463 -REPAIR & MAINT CHARGES 3,756 6,378 6,303 3,500 4,000 14.29% TOTAL CENTRAL GARAGE CHARGES 5,628 8,225 8,495 5,200 4,000 -23.08% 6550 -MOTOR VEHICLES 796,356 1,046,500 1,128,500 7.84% TOTAL CAPITAL OUTLAY 796,356 1,046,500 1,128,500 7.84% 6494 -DEPRECIATION EXPENSE 897,970 927,530 900,000 950,000 5.56% TOTAL DEPRECIATION 897,970 927,530 900,000 950,000 5.56% TOTAL OPERATING EXPENSES 1,987,413 2,138,217 1,766,188 3,385,236 3,723,099 9.98% OPERATING INCOME (289,001) (295,223) (152,181) (1,058,101) (3,323,099) 214.06% 4603 -INTEREST EARNINGS 74,625 41,107 21,773 35,900 39,700 10.58% 4605-UNREALIZED INVESTMENT GAIN/LOSS 34,225 (46,239) 0.00% TOTAL INVESTMENT EARNINGS 108,850 (5,132) 21,773 35,900 39,700 10.58% 4320 -MISC FEDERAL GRANTS 9,487 0.00% 4606 -OTHER REVENUE 167 173 87 0.00% 4911 -SALE OF PROPERTY 10,551 8,057 5,000 -100.00% 4915-TRANSFERSIN 25,500 0.00% 4919-GAIN ON FIXED ASSET DISPOSAL 82,875 99,450 8,500 70,000 50,000 -28.57% 4921 -REFUNDS & REIMBURSEMENTS 17,331 66,477 71,077 15,000 15,000 0.00% TOTAL MISCELLANEOUS 145,911 174,157 79,664 90,000 65,000 -27.78% TOTAL NONOPERATING REVENUES 254,761 169,025 101,437 125,900 104,700 -16.84% NONOPERATING EXPENSES 6496 -LOSS ON FIXED ASSET DISPOSAL 9,316 30,157 0.00% TOTAL NONOPERATING EXPENSES 9,316 30,157 0.00% NET CHANGE IN FUND BALANCE $ {43,556) $ {156,355) $ {50,744) $ {932,201) $ {3,218,399) 245.25% -?-1~M --1,44 p1eUB {) - ---sttuJA,v?l r tf JJlfl\LuJ ~ Central Garage Cash Flow -, $5,000,000 Central Garage -Cash Balance $4,500,000 _, $4,000,000 $3,500,000 _, $3,000,000 _, $2,500,000 =t s2,ooo,ooo -Sl,500,000 $1,000,000 $500,000 s- 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 -Capital Outlay --Cas h Balance -Actual ..,._Cash Ba lance-Targeted Public Works Department Responsibly provide for the maintenance and operations of the City's infrastructure and facilities in a quality, cost effective manner including: • 121 miles of water main, 2,050 valves , 1,000 hydrants, 9,000 metered connections • 105 miles sanitary sewer, 9,000 sewer service connections, 10 lift stations • 88 miles of storm drains and 100 treatment facilities • 270 city-owned ornamental lights, 920 Xcel lights and 100 traffic signal overhead lights 11/21/2022 • City Council Work Session, November 21, 2022 Strategic Function -Public Utilities • Water Utility: 1.3 billion gal/yr supplied to customers from 9 wells, 3 water towers, water treatment plant • Sanitary Sewer Utility: Conveyance of 900 million gal/yr of wastewater • Storm Drainage Utility: Maintain approx. 88 miles of drainage pipes, 40 ponds, storm sewer structures • Street Light Utility: Operation of 1300 street lights 1 11/21/2 0 22 --------------- Public Utilities -Staffing Levels Positions _____ FTEs ---Supervisor of Utilities 1 1 1 Engineering Technician 3 (distributed 1/3 over 49141, 49 251 , 1 1 1 49411) Maintenance II (4-49141, 2-49251, 2-49411) 9 9 9 Part Time/Summer Temporary Employee s (3-49141, 2-49251, 1-2 .0 2 .0 3 .0 49411 ) Annual Goals & Strategies 1. Meet or exceed safe drinking water standards of the State of Minnesota and manage storm water runoff in an efficient and environmentally sensitive manner. a. Manage and enforce the City's Wellhead Protection Plan goals. b. Implement Best Management Practices (BMPs) that support the City's and Watershed's impaired waters Total Maximum Daily Load (TMDL) plans. 2. Initiate improved, streamlined management strategies and techniques by use of refined methods and technologies. a. Automate the monthly well pump i ng records and reporting to the Minnesota Department of Health. 2 Utili t ies Pe rform a n ce M ea sur e s Performance Objectives Description of Performance Measure Pe rfo rmance l evels Miles of annual street sweeping performed Miles of annual sanitary sewer televised, cleaned, root-sawed, lined and new pipe Private sanitary sewer backups per year (due to Coty system blockage) Drinking Water Regulated Substances: Copper lead Barium Trlhalomethanes Haloacetlc Acids Total Chlorine Flourlde Ke y Initiatives •Ac tu a l Val ue 1459.1 mil es (4 Ci t ywide, 10 targeted ) 26 No vlo latlon No vio la tion No vlolatlon No violation No viola tion No violation No violation • Rain garden landscaping and maintenance • Stocking light poles • Lead and copper data collection • Continuing lift station rehabilitations • 1-94 & Dupont 24" steel water main replacement • Water treatment plant redundant water main connection • Freeway and Highway utility crossing replacements Target Va lue >990 mil es (4 Citywide ro unds, 10 rounds of targeted secondary a reas} >= 19.6 mil es (1/5 o f the City's total 97.9 miles) No violations 11/21/2022 3 Cash Flow /Rate Projections • Assumptions for Cash Flow/Rate Projections • Includes capital outlay based on 15 -year CIP • Anticipated debt issues include: • Water G.O. Revenue Bonds -2024, 2025, 2028 • Sanitary Sewer G.O. Revenue Bonds -2024, 2025, 2028, 2030 • Storm Sewer G.O. Revenue Bonds -2029, 2030 • 3% annual increase in personal services, 2% annual increase in operating expenses Water Utility Rate & Cash Average Real dentlal Fee I (181000 Gallons I Per Qtr.) 69.82 S 76.07 S 62.09 $ 89.52 95.77 I S 102.49 P r Qua~~ge j S 3.33 S ~ S ~2 1 S 7.43 6.2 , S ,E_.?J Base Chiroel.~---,c--i S 17.◄◄ 19.01 S 20.53 S 22.38 23.95 S 25.63 l Consumption Charge (0-:SO) S 2.9 1 3 .17 S 3.42 I S 3.73 3 .99 S 4-27 l Conaumptlon Chnrge (30-60) S 3.62 3.95 S 4.27 $ 4.65 4 .98 $ 5.33 j _iConaumptlonFCharge (~) 1l _S-=~5-.4_1 _, _S_=~5·_•0_1 _• ~=6~--37_•-=~6_.•_•--==7-.◄-3-+-S~==7-.9-5~ Actual Projected Budgel ed Projected Projected Projed ed l 2 02 1 2022 2023 2024 2025 2026 Ri~::~~;o L_ 1 s 4 ,610,129 s s.02s,04 1 s s ,427,04◄ I s s ,915,476 s 6 ,329.561 s s,n2,s31 1 lhvestment Eamkigs (11,465) 32,600 31 ,800 4 ,674 6 ,864 1 15,293 Uonoper 11Un g 70,026 --I Bond Pr oceeds (GO) t---='' "'92c':9"c0'=83=---c'c'sc':occo'=oo"-cot------ac--c=='7C--C:3"c8"c20c'-O"-cocco_---=•-=6'c'SOc'Oc':O'=-O+-----=-==-,--- jTota l I -l 6 ,597,773 6 ,557,641 S,458,84-4 : 9,740,152 7,986,-42S j 6 ,787,92-4 Expenditure• I !Pe rsonal Se'}'~ 658.369 662,277 I 726,511 7-48,306 770,756 Supplies I · 30S,369 388,910 464 ,400 473,668 483,162 l~U';[!,~::k:~h11 r9~ e:;::~~ 6~:~~ r ~O~:~: 1,0~:~~~ t,o;~:~:: ..,.,., J 256,178 236,900 27S,900 28 1,-418 287,046 IDeprecillLio_n __ __ 1,697,753 ! 1,697,753 ___!,897,753 1,697,753 1,697,753 I C11plll l Outlay (CIP) 2,552,583 1, 738,84 I 2, 182,888 ◄,D I 6,000 I ,052,000 I Debt Service (Exis ting) 1,157 ,641 1,-405 ,464 1,5-45,037 1,566,998 1,552,978 I DebtService(PfA) 1,140 ,3 10 1,1-40,390 1,t-40 ,370 I 1,140,250 1,1-41 ,030 I Debt Service (Pro}!lcted) 184 ,936 I 184,936 655,908 Uonoper11ling = 1 -1 I Tral\sfers Out -l -: I ~--=--_ 8 ,909,529 I 8 ,169,89 1 ~.~780 I Co ■h Balance -Begi nning 3,135,562 2 ,359,055 2 ,6-44 ,558 I 1,394,614 5 19,375 8 ,947,602 762,666 !:~::~: ~ t ,068,~ 60.s•2 I 2 92 ,787 1,897,753 1 1,824,000 1,542,08~ t ,1'4 0 ,700 849,33~ I 9 ,962,475 1 1,699,242 !changes l'I Accruals (362,50-4) f Revcnues _I _ 6 ,597,773 6,557,641 5,458,84"' 9 ,740,152 7,986,425 6 ,787,92'4 !Expenditures (8,909,529) (8,169,89 1) (9,48 1,780 ) (I 1,394,614) (8,9"'7,602) (9,962,475) jJloncash -Depreciatio n 1 897 753 I 897 753 1 897 753 l 1 897 753 I 897 753 I 1 697 753 ! Cash Balance -Ending 1 .. s,___,2.,_35_9_10 ... 66...,. ... ,.2=.6«-=·=••,.•_.s'-'.,•s.••=·=''=6-'S'-'-'7=62,.,6 .. 6 .. 6_,S_,,l.=69,.9=,2-'4"'2 ..,1 .. s_ .. •2 .. 2=·• .. 44 ... 11/21 /2 0 22 4 11/21/2022 Water Utility Cash Flow 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 -capital ouUiy ....,cash Bal.Jnce-Encing .....,Minlmum Tatgeted Balance• Water Utility Rate Comparison $200,00 Residential Cost of 18,000 Gallons of Water per Quarter for 2022 $166.48 ~C' to-"'"' ~q,.:lo ,..,, ,F"-' <f'.,, ~$-"'""' ~ ~o<I' -.,<> -.,<> ,,,_., cs(' <,.~ •"' ~~ ~., ,._.,-"i' <' <' .:po Q-0 .,, .. " ~--"' ~"' ~--..;,.'"q <J-" <J-" <:,<$' ,...._,,. ~---" .p"" ,.,,<P ,.,, 5 11/21/2022 -------------------------------------------- Residential -Flat Fee I Per Qtr. 93.59 s 96.21 J s 103.19 1 s 10::!! I : 113.16 I s 117.16 P~r Quarter fhange 4.46 s 4.66 s 4.91 S HT ~ I Actua l Projected I Budgeted Projected Projected Proje_f_ted Sanitary J 2021 2022 2023 I 2024 I 2025 2026 Revenues I Ope rali'lg 4,660,679 s 5,140,000 5,397,000 s 5,666,650 5,950,193 s 6,126,696 Investmen t Ea rnings 15,254 47 ,000 ~.200 36,445 35,649 33,352 Sewer ?l onope ra tflg 1,100 Bon d Proceeds 1421407 ! 1600000 -I 1 900 000 2 290 000 I Total 6,116,440 6,767,000 _2,44~,200 I 7~,295 [ 6,275,842 I 6.jg,~O _i==_ I Utility Expenditures T l I Perso nal Services 242,910 t 250,197 292,229 300,996 310,026 i ~,327 Supp[es 30,210 31 ,116 ] 65,200 66,904 66,642 90,415 _ othe r Se rvices & Cha rges 2,967,690 3,077,321 3,736,790 I 3,613,566 3,669,637 1 3,967,~ Rate/Cash 'Ins urance 22,207 ~ 22,673 I 24,600 I 25,296 25,802 26,316 ]Ulilies 34 ,630 35,669 I ~,300 41 ,106 41.,928 1 42,767 j Dep reciatio n -1,030,919 1,030,919 I 1,030,919 1 1,030,919 1 1,030,919 1,oJQ,919 I Caplal Oullay 2,436,339 I 1 ,◄◄2,◄51 I l .464~ 2,323,000 2,850,000 ~ 1~000 t Flow Debi Se rvice (Exis!Wlg) 764,465 I 910,599 I 1,005,807 1 1,026,854 1,016,645 963,Q.1_5 l Deti l Service (Projected) 73 975 73 975 306,227 590.564 I Tota l I 7.§5.1,390 6,801 ,145 7~~1 8,:m,615 I 9,562,026 + _6,313,957 I I ____l_ I ---------' Cash B.11ance -Beg inning 4,678,097 4,309,130 I 5,325,903 I 4,049,414 3,961 ,013 ~705,7.fl_ !changes in Accruals (166,936) ---___ -I -1 !Re venues 6,118,440 6,lli,QQQ__ 5,449,200 7,603,295 6,275,842 I 6 ,1s2.~ I IExpen dlures (7 ,551 ,390) (6 ,8Q!,145)' (7 ,756,606) (6,722,615) (9,562,026) (8,313,957) ltloncash -Deprecia tion I 1,030 919 1 030,919 ' 1.030 919 I 1,030 919 1030919 1.030,919 Cash Balance -Endin g s 4,309,130 6,325,903 I $ 4,049,414 I S 3,961,013 3,705,747 2,584,759 Sanitary Sewer Utility Cash Flow 6,000,000 ~------------------------------------------------------ 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 2011 2013 2024 2025 2016 2027 2018 2019 2030 2031 2032 20ll 2034 2035 2036 2037 -c,p11~ outlay .._cash Balance (en di"€) ....,Minimum Targeted Balan<e' 6 Sanitary Sewer Utility Rate Comparison $140.00 / Residential Cost of 18,000 Gallons of Sanitary Sewer per Quarter for 2022 $U0.00 / $100.00 $80.00 $60.00 $40.00 $20.00 $- Storm Water Utility Rate/Cash Flow S 1,742 ,704 I S 1,664,lli 1,995 ,222 $ -1,134,888 S 2,21!1,330 I_S__l,ill,233 evenues ~ t L ~ L..______ ·-F~~~l~Eam ings I _§722 43 200 50 ,800 ....B.fil ~320 40 639 menta l 501000 __ -- 2,230 629 11 30 000 ~filMSS 3,462 ,650 _-1,484 ,872 ;,c;;===~-_ t 328,~----+ ----11,Im r====r=~C=h11rg ~ 502,701 ling) je tte d) 2,874 1,84 3 11/21/2022 7 11/21/2022 --------------------------------------------------------------___ ---------------------------------------- Storm Water Utility Cash Flow 6,000,000 2021 2021 2023 2024 1025 2016 2017 1018 1019 1030 2031 2031 1033 2034 2035 1036 2037 -a.pit~outlay -a.shB~aoce-Endi~ +MWmumT;rg,ted B.iillCe' Storm Sewer Utility Rate Comparison $40.00 $15.00 $30.00 $25.00 $20.00 $15.00 $10.00 $S.OO $- White Bear Fridley Lnke Residential Storm Water Charge per Quarter for 2022 Rosevflle Brooklyn Center- 2022 Brooklyn Center - 2023 Richfield Crystal Golden Maplewood New Hope Shoreview Valley 8 Comparative -f City Utility Rates Comparative City Utility Rates CITY OF BROOKLYN CENTER __ TOTAL WATER ,j_EWER , AND STORM UTILITY BILL BASED ON QUARTERLY BILLING CYCLE , ASSUMING 18,000 GALLONS USAGE COMPARISON AS OF 11/20/22 i ---r -i-~ I T Citv \.later !Sewer Storm Total \./hite Bear Lake $ 45.44 $ 110.40 $ 6.00 $ 161.84 --- _ Brooklyn Center -2022 76.07 98 .27 17.10 191.44 -Roseville 96.64 89 .36 14.54 200 .54 -Fridley 72.80 119.10 11.10 203.00 --- -Brooklyn Center -2023 82 .09 103.19 18 .30 203 .58 Richfield 94.09 110 .70 21.80 226 .59 Maplewood 101.26 98.49 27 .25 227.01 Shoreview 88 .15 103.63 35.27 227 .05 --Golden Vallev 137.45 95 .01 27.00 259 .46 -Cry stal 156.00 . 112.56 22 .15 290.71 -New Hope 166.48 138.78 27 .39 332 .65 -I I I I I 2011 Residential Quarterly total Water, Sewer, and Storm Utility Bill (18,000 gallons) """ '""' Whle!Nr llrootl,n RomUe J"riclty Broct!yn Ri:tii tld Map lewoo d Shorwir,t, Gd den Val ley UytUI New Kope W e center -2022 cerur -2013 11/21/2022 9 11/21/2022 ----------------------------------------------------------- Street Light Utility Rate/ Cash Flow 2021 2022 ------------------------ Res idential -Flat Fe e/ Per Qtr Per Quarter Change I --I ~ j Ope rating_L___ Investmen t Earnings l~~ 1 ~operating ---j-"""1-j- - s 6.55 s 6.55 1 S s -s -s ---__ I Acl_u_& E!_ojected .I 202 1 2022 I __ I _ s 448,957 j s 460,000 Js (2 ,894) 8,200 I -1 -1 f 44§,063 ~~o I __ 10 8,030 6.88 I s o.33 I s I Budgeted + 2023 483 ,000 I s 12,8~1 -I ~800 1 __ 1 109,059 ~pen d itu reil l suppries L_ Othe r Services & C~g~ Ins urance -I Ulillties - _J t __!{g,590 _ 885 ="'l 104 ,642 _ 930 -1,000 ~.ooo IDeprecia lion l- lCa plta l Ou tlay Trans fers Ou t Tot al -i-__i__:::-I Cas h Bala nce -Beginning JCh1mges in Accrua~ Revenues I- Expend ft ures Uo ncas h -Dep recia tion Cas h Bala nce -End ing r , l I I I 185 ,253 _!01,115 553 ,500 - ~,353 1,152,977 38,697 446,063 (943,353) 10 1.115 I I S 795,499 I $ 200,000 101,115 501 ,450 916,167 795,499 ~1-(916,167) 101 .1Ts I 448,647 I S 101 ,115 20,000 ~•m i ::::::~ (589,924) 101 TTs I 455,638 I S 7.36 0.48 P~ojecte d 2024 516,81 0 7,974 - 524,78 4 1s,525 I 111 ,2j0 _ 1,020 224 ,400 101 ,115 541 ,000 9_!)5 ,300 -- 455,638 --- 524,784 (995 ,300) 101115 I s s s 861237 I S 1.s1 I s s .5o I o.52 ts o.63 I Projected Projected 2025 I 552,987 ~s 1,509 -1 554,496 1 I 16,856 1 113,§§_ _1,040 I 22s,88s I 10 1,115 1 260,000 -1 721 ,364 I I 86,237 I --I 554 ,496 ! (721 ,364) 101115 I 20 ,4 84 I S 2026 _§!)7 ,226 358 -1 597 ,584 17,193 1_§734 __1 ~ 233,466 101,115 t 250,000 11s,ss9 I I 20,48~ I 597,584 I (718,569) 101115 I 614 I Street Light Utility Cash Flow 2023 2024 2025 202 6 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 -capital oo tfay ...,_cash Balance• Ending ....,_Minimum Targeted Balance• 2037 10 11/21/2022 Street Light Utility Rate Comparison $16.00 Residential Street Light Charge per Quarter for 2022 $14.00 $12.00 $10.00 / $8.00 $6.55 $6.00 $4.00 $2.00 $- Crystal New Hope Richfield Brooklyn Center Brooklyn Center Golden Valley Shorevie w -2022 -2023 Recycling Utility Rate/Cash Flow $250,000 Recycling Fund Utility 2020 20 21 2022 2023 2024 2025 2026 20 27 2028 2029 20 30 20 31 2032 20 33 2034 203S 2036 -+-Cas h Bnlimc~ • Endin1 11 11/2l/2022 ------------------------------------------- Recycling Utility Rate Comparison $20.00 $11.00 $16.00 $14.00 $12.00 $10.00 $8.00 $6,00 $4.00 $2.00 $- Rosevllle Fridley Residential Recycling Charge per Quarter for 2022 $17.00 Brooklyn Center -2022 New Hope Brooklyn Maplewood Golden Valley Center -2023 Questions? 12 Central Garage Fund • Central Garage -Equipment Replacement • This fund accounts for the operation of a centralized management offuel, preventive maintenance, repair and replacement of city owned motorized equipment and fleet. • Staffing FTE • Deputy Public Works Director • Crew Leader/Mechanic • Mechanic • Night Service Person • Administrative Technician 1 1 2 1 1 • Note: In 2021 the Deputy Public Works Directo r was included directly to this fund and will be funded through central garage cha rges to supported funds . 2023 Eq ui p m e n t Pu rchases Vehicle/Equipment Department Ford SUV Inte rcepto r Fire Gro undsm as t er M ower Par ks Ford SUV Inte rce ptor Po li ce Ford SUV Inter ce pto r Po li ce Fo r d SUV Interce pto r Po li ce Fo rd SUV Inte rce pto r Po li ce Mack GU7 12 St ree t Cate rpillar 928 Wh ee l Loa der Stree t s Tripl e Axle Trailer Hea vy Duty Stree t s Tand em Dump Tru ck Stree t s Ree lm ast er M ower Go lf 11/2 1/20 22 1 3 11/21/2022 ----------------------- ----------------------------------- Questions? Pr o pos e d Beautification Fund • Initial funding proposed in 2022 • $50,000 of excess 2020 General Fund Balance over 52% of 2021 expenditures • $50,000 of 2021 LGA Allocation • Proposed transfers have not occured • Expenditures would be capital in nature (all related personnel, supplies, etc., would remain in general fund) 14 11/21/2022 Questions? 15 WATER UTILITY FUND· 60100 PUBLIC UTILITY FUND 2022 2020 2021 September 2022 2023 Object Code / Descrl~tlon Actual Actual YTD Budget Budget Change 49141 -WATER UTILITY-OPERATIONS OPERATING REVENUES 4701 -WATER SALES $ 3,727,823 $ 4,174,739 $ 2,957,013 $ 4,266,500 $ 4,920,793 15.34% 4702 -FIRE LINES 9,236 9,122 6,956 10,000 10,000 0.00% 4703 -WATER METER SALES (11,197) (15,803) (14,164) (10,000) (10,000) 0.00% 4704 -WATER METER RENTALS 7,400 6,500 1,325 5,000 5,000 0.00% 4705 -SERVICE RESTORATION FEES 1,043 1,000 1,000 0.00% 4706 -CONNECTION CHARGES 48,000 1,500 12,500 10,000 10,000 0.00% 4707 -PENAL TIES 0.00% 4708 -TOWER RENTAL FEES 391,678 398,921 (95,339) 400,000 400,000 0.00% 4709 -CERTIFICATION CHARGES 32,300 35,150 63,800 40,000 40,000 0.00% TOTAL SALES AND USER FEES 4,206,283 4,610,129 2,932,091 4,722,500 5,376,793 13.85% TOTAL OPERATING REVENUES 4,206,283 4,610,129 2,932,091 4,722,500 5,376,793 13.85% OPERATING EXPENSES 6101 -WAGES & SALARIES-FT EMPLOYEES 383,130 396,041 310,458 400,036 435,457 8.85% 6102 -OVERTIME-FT EMPLOYEES 45,066 49,230 43,959 48,000 48,000 0.00% 6103 -WAGES-PART TIME EMPLOYEES 18,204 36,151 33,403 35,000 54,000 54.29% 6111-SEVERANCEPAY 7,331 15,692 0.00% 6122 -PERA COORDINATED PLAN 32,115 33,396 26,581 35,329 38,884 10.06% 6125 -FICA-SOCIAL SECURITY 26,665 28,892 23,563 29,205 32,144 10.06% 6126 -FICA-MEDICARE 6,312 6,757 5,511 6,830 7,518 10.07% 6131 -CAFETERIA PLAN CONTRIBUTIONS 75,660 79,200 62,370 88,150 90,794 3.00% 6151 -WORKER'S COMP INSURANCE 15,840 13,010 11,304 19,727 19,714 -0.07% TOTAL PERSONAL SERVICES 610,323 658,369 517,149 662,277 726,511 9.70% 6201 -OFFICE SUPPLIES 1,790 1,566 528 1,800 4,300 138.89% 6203 -BOOKS/REFERENCE MATERIALS 90 500 500 0.00% 6204 -STATIONARY SUPPLIES 0.00% 6212 -MOTOR FUELS 2,763 5,855 5,944 5,000 7,000 40.00% 6214 -CLOTHING & PERSONAL EQUIPMENT 225 400 400 0.00% 6216 -CHEMICALS/CHEMICAL PRODUCTS 162,955 183,809 182,265 160,000 200,000 25.00% 6217 -SAFETY SUPPLIES 1,855 7,585 2,131 4,500 4,500 0.00% 6219 -GENERAL OPERATING SUPPLIES 15,960 21,339 9,244 16,000 32,000 100.00% 6223 -BUILDINGS & FACILITIES 45,474 1,132 1,160 11,500 10,000 -13.04% 6224 -STREET MAINT MATERIALS 4,615 6,266 7,676 10,000 10,500 5.00% 6225 -PARK & LANDSCAPE MATERIALS 634 60 1,500 1,500 0.00% 6227 -PAINT SUPPLIES 1,642 2,655 2,086 3,500 3,500 0.00% 6235 -UTILITY SYSTEM SUPPLIES 41,816 31,457 195,627 70,000 70,000 0.00% 6239 -OTHER REPAIR & MAINT SUPPLIES 27,767 33,746 64,563 40,000 70,000 75.00% 6241 -SMALL TOOLS 1,415 2,218 1,067 5,000 5,000 0.00% 6242 • MINOR EQUIPMENT 2,786 7,471 1,642 57,600 23,600 -59.03% 6243 • MINOR COMPUTER EQUIPMENT 5,233 210 1,520 3,500 21,600 517.14% TOTAL SUPPLIES 316,795 305,369 475,678 390,800 464,400 18.83% 6301 • ACCTG, AUDIT & FIN'L SERVICES 2,555 2,509 3,000 3,000 3,000 0.00% 6302 -ARCH, ENG & PLANNING 6,900 4,246 21,841 85,500 105,000 22.81% 6307 -PROFESSIONAL SERVICES 178,875 93,327 22,344 60,000 75,000 25.00% 6321 -TELEPHONE/PAGERS 3,659 2,327 1,857 4,100 3,500 -14.63% 6322 -POSTAGE 84 4,818 43 0.00% 6329 -OTHER COMMUNICATION SERVICES 6,209 4,949 2,292 5,000 5,000 0.00% 6331 -TRAVEL EXPENSE/MILEAGE 200 200 0.00% 6333 -FREIGHT/DRAYAGE 43 50 50 0.00% 6341 -PERSONNEL ADVERTISING 160 160 0.00% 6342 -LEGAL NOTICES 100 100 0.00% 6351 -PRINTING 105 52 28 500 500 0.00% 6402 -EQUIPMENT SERVICES 1,562 1,300 2,557 5,000 6,000 20.00% 6403 -BLDGS/FACILITIES MAINT SERVICE 7,966 23,575 1,979 7,500 10,000 33.33% 6406 -MULTI-FUNCTION MTNCE 151 119 94 250 250 0.00% 6409 -OTHER REPAIR & MAINT SVCS 42,602 12,531 31,451 26,200 40,200 53.44% 6417 • UNIFORMS 2,690 2,410 1,891 2,000 2,000 0.00% 6421 -SOFTWARE LICENSE 229 68 0.00% 6422 -SOFTWARE MAINT 189 1,500 100.00% 6423 -LOGIS CHARGES 53,094 50,463 33,817 60,000 58,265 -2.89% 6432 -CONFERENCES AND SCHOOLS 3,410 5,247 3,977 8,000 8,000 0.00% 6434 -DUES & SUBSCRIPTIONS 5,909 3,557 1,729 4,000 4,000 0.00% 6435 -CREDIT CARD FEES 46,180 37,000 37,000 0.00% 6438 -CASH SHORT (OVER) 1,215 0.00% 6405 -PARK & LANDSCAPE SERVICES 2,256 6,106 3,268 10,000 10,000 0.00% 6441 -LICENSES, TAXES & FEES 98,993 115,534 65,782 110,000 110,000 0.00% 6443 -PRIZE AWARDS/EXP REIMB 779 350 300 500 500 0.00% 6449 -OTHER CONTRACTUAL SERVICE 207,156 322,721 188,569 147,500 170,000 15.25% TOTAL SERVICES & OTHER CHARGES 626,399 656,252 433,188 576,560 650,225 12.78% 6361 -GENERAL LIABILITY INSURANCE 36,139 34,446 24,120 36,168 37,000 2.30% 6362 -PROPERTY INSURANCE 8,063 16,289 20,054 17,104 17,200 0.56% 6366 -MACHINERY BREAKDOWN INSURANCE 1,233 2,712 2,737 2,850 2,850 0.00% TOTAL INSURANCE 45,435 53,447 46,911 56,122 57,050 1.65% 6381 -ELECTRIC 180,141 193,404 186,930 190,000 190,000 0.00% 6382-GAS 16,043 27,679 32,551 22,600 54,600 141.59% 6383-WATER 6,329 13,739 5,552 7,000 9,500 35.71% 6385-SEWER 4,815 9,022 5,853 6,000 10,000 66.67% 6386 -STORM SEWER 9,336 9,617 5,145 8,700 8,800 1.15% 6389 -STREET LIGHTS 2,624 2,717 1,312 2,600 3,000 15.38% TOTAL UTILITIES 219,288 256,178 237,343 236,900 275,900 16.46% 6461 -FUEL CHARGES 4,011 3,887 4,019 4,500 4,700 4.44% 6462 -FIXED CHARGES 5,902 13,438 7,738 10,307 13,148 27.56% 6463 -REPAIR & MAINT CHARGES 15,035 8,086 10,636 10,600 10,600 0.00% 6465 -REPLACEMENT CHARGES 22,450 22,520 24,200 32,267 45,183 40.03% TOTAL CENTRAL GARAGE CHARGES 47,398 47,931 46,593 57,674 73,631 27.67% 6494 -DEPRECIATION EXPENSE 1,800,118 1,897,753 1,458,217 1,897,753 100.00% TOTAL DEPRECIATION 1,800,118 1,897,753 1,458,217 1,897,753 100.00% TOTAL OPERATING EXPENSES 3,665,756 3,875,299 3,215,079 1,980,333 4145 470 109.33% OPERATING INCOME 540,527 734,830 1282 19B8l 2,742,167 1,231,323 -55.10% NONOPERATING REVENUES 4601 -SPECIAL ASSESSMENTS 47,046 66,491 223,136 0.00% TOTAL SPECIAL ASSESSMENTS 47,046 66,491 223,136 0.00% 4603 -INTEREST EARNINGS 51,801 25,584 13,493 23,600 31,800 34.75% 4605 -UNREALIZED INVESTMENT GAIN/LOSS 35,329 (37,045) 0.00% TOTAL INVESTMENT EARNINGS 87,130 (11,461) 13,493 23,600 31,800 34.75% 4320 -FEDERAL GRANTS 18,862 225 0.00% 4604 -CHECK PROCESSING FEES 1,350 1,320 1,530 0.00% 4606 -OTHER REVENUE 384 375 0.00% 4921 -REFUNDS & REIMBURSEMENTS 6,392 1,840 0.00% TOTAL MISCELLANEOUS 26,988 3,535 1,755 0.00% 4931 -BOND SALES 3,800,000 -100.00% TOTAL DEBT ISSUANCE 3,800,000 -100.00% TOTAL NONOPERATING REVENUES 161164 58,565 238,384 3,823,600 31 800 -99.17% NONOPERATING EXPENSES 6530 -IMPROVEMENTS 152,258 90,759 4,539,724 2,116,888 -53.37% 6540 -EQUIPMENT & MACHINERY 10,639 8,000 66,000 725.00% TOTAL CAPITAL OUTLAY 152,258 101,398 4,547,724 2,182,888 -52.00% 6601 -BOND PRINCIPAL 1,071,250 2,073,250 2,253,250 8.68% 6611 -BOND INTEREST 462,204 465,927 472,208 472,605 617,093 30.57% 6621 -PAYING AGENT/OTHER FEES (20,752) (56,849) 3,000 -100.00% TOTAL DEBT SERVICE 441,452 409,078 1,543,458 2,548,855 2,870,343 12.61% 6471 -ADMINISTRATIVE SERVICE TRANSFER 105,996 183,696 138,468 184,625 283,079 53.33% TOTAL TRANSFERS 105,996 183,696 138,468 184,625 283,079 53.33% TOTAL NONOPERATING EXPENSES 699,706 592,774 1,783,324 7,281,204 5,336,310 -26.71% NET CHANGE IN FUND BALANCE i 1,985 i 200,621 i (1,827,928) i (715,437) i {4,073,187) 469.33% SEWER UTILITY FUND -60200 PUBLIC UTILITY FUND 2022 2020 2021 September 2022 2023 Object Code I Descriellon Actual Actual YTD Budget Budget Change 49251 -SEWER UTILITY-OPERATIONS OPERATING REVENUES 4707 -PENALTIES $ $ $ $ $ 0.00% 4721 -SEWER SERVICE 4,662,342 4,680,679 3,820,845 5,140,000 5,294,200 3.00% TOTAL SALES AND USER FEES 4,662,342 4,680,679 3,820,845 5,140,000 5,294,200 3.00% TOTAL OPERATING REVENUES 4,662,342 4,680,679 3,820,845 5,140,000 5,294,200 3.00% OPERATING EXPENSES 6101 -WAGES & SALARIES-FT EMPLOYEES 151,647 149,634 117,420 157,260 166,082 5.61% 6102 -OVERTIME-FT EMPLOYEES 18,246 20,050 17,956 18,000 20,000 11.11% 6103 -WAGES-PART TIME EMPLOYEES 31,198 3,773 7,416 25,000 25,000 0.00% 6111-SEVERANCEPAY 2,455 6,731 0.00% 6122 -PERA COORDINATED PLAN 12,742 12,726 10,153 14,383 15,681 9.02% 6125 -FICA -SOCIAL SECURITY 12,935 11,197 9,218 11,889 12,964 9.04% 6126 -FICA -MEDICARE 3,042 2,619 2,156 2,781 3,033 9.06% 6131 -CAFETERIA PLAN CONTRIBUTIONS 30,264 30,360 24,948 38,254 39,401 3.00% 6151 -WORKER'S COMP INSURANCE 7,805 5,820 6,730 8,766 10,068 14.85% TOTAL PERSONAL SERVICES 270,334 242,910 195,997 276,333 292,229 5.75% 6201 -OFFICE SUPPLIES 32 100 100 2,600 2500.00% 6203 -BOOKS/REFERENCE MATERIALS 200 200 0.00% 6204 -STATIONARY SUPPLIES 0.00% 6214 -CLOTHING & PERSONAL EQUIPMENT 75 300 300 0.00% 6216 -CHEMICALS/CHEMICAL PRODUCTS 7,791 10,139 11,500 11,500 0.00% 6217 -SAFETY SUPPLIES 2,993 13,091 1,261 12,000 10,000 -16.67% 6219 -GENERAL OPERATING SUPPLIES 2,772 693 6,045 3,500 3,500 0.00% 6223 -BUILDINGS & FACILITIES 25 9,813 30,000 40,000 33.33% 6224 -STREET MAINT MATERIALS 2,557 861 7,500 7,500 0.00% 6227 -PAINT SUPPLIES 607 667 936 675 1,000 48.15% 6239 -OTHER REPAIR & MAINT SUPPLIES 3,817 3,088 5,000 5,000 0.00% 6241 -SMALL TOOLS 707 576 1,000 1,000 0.00% 6242 -MINOR EQUIPMENT 420 925 495 2,600 2,600 0.00% 6243 -MINOR COMPUTER EQUIPMENT 4,262 70 1,520 3 500 -100.00% TOTAL SUPPLIES 26,058 30,210 20,070 77,875 85,200 9.41% 6301 -ACCTG, AUDIT & FIN'L SERVICES 2,555 2,509 3,000 3,000 3,000 0.00% 6302 • ARCH, ENG & PLANNING 1,900 1,900 0.00% 6307 • PROFESSIONAL SERVICES 29,842 6,786 3,124 4,820 55,000 1041.08% 6321 -TELEPHONE/PAGERS 2,189 1,298 311 3,100 1,500 -51.61% 6322 -POSTAGE 4,818 0.00% 6351 -PRINTING 375 375 0.00% 6403 -BLDGS/FACILITIES MAINT SERVICE 3,611 3,765 2,057 7,000 7,000 0.00% 6409 -OTHER REPAIR & MAINT SVCS 65,902 49,896 48,172 100,000 115,000 15.00% 6417 -UNIFORMS 680 800 1,000 1,000 0.00% 6421 -SOFTWARE LICENSE 160 0.00% 6423 -LOGIS CHARGES 43,843 43,640 28,826 45,000 50,839 12.98% 6432 -CONFERENCES AND SCHOOLS 2,060 3,801 51 4,000 4,000 0.00% 6434 -DUES & SUBSCRIPTIONS 264 286 286 425 425 0.00% 6441 -LICENSES, TAXES & FEES 123 300 300 0.00% 6449 -OTHER CONTRACTUAL SERVICE 42,891 47,682 18,781 25,000 25,000 0.00% TOTAL SERVICES & OTHER CHARGES 194,120 165,281 104,608 195,920 265,339 35.43% 6361 -GENERAL LIABILITY INSURANCE 19,431 20,486 17,269 21,511 22,500 4.60% 6362 -PROPERTY INSURANCE 1,426 1,457 1,850 1,530 2,000 30.72% 6366 -MACHINERY BREAKDOWN INSURANCE 258 264 260 280 300 7.14% TOTAL INSURANCE 21,115 22,207 19,379 23,321 24,800 6.34% 6381 -ELECTRIC 36,689 34,630 29,991 39,100 40,300 3.07% 6391 -MET COUNCIL ENVIRON SVCS 2,653,796 2,554,790 2,169,895 2,646,952 3,019,710 14.08% TOTAL UTILITIES 2,690,485 2,589,420 2,199,886 2,686,052 3,060,010 13.92% 6461 -FUEL CHARGES 9,929 10,898 12,138 12,700 13,300 4.72% 6462 -FIXED CHARGES 9,039 19,650 13,096 17,439 23,114 32.54% 6463 -REPAIR & MAINT CHARGES 10,383 11,622 9,212 15,800 15,000 -5.06% 6465 -REPLACEMENT CHARGES 58,005 58,705 83,881 111,841 146,529 31.02% TOTAL CENTRAL GARAGE CHARGES 87,356 100,875 118,327 157,780 197,943 25.46% 6494 -DEPRECIATION EXPENSE 977,861 1,030,919 807,700 1,000,000 1,030,919 3.09% TOTAL DEPRECIATION 977,861 1,030,919 807,700 1,000,000 1,030,919 3.09% TOTAL OPERATING EXPENSES 4,267,329 4,181,822 3,465,967 4,417,281 4,956,440 12.21% OPERATING INCOME 395,013 498,857 354,878 722 719 337 760 -53.27% NONOPERATING REVENUES 4320 • FEDERAL GRANTS 8,271 0.00% TOTAL INTERGOVERNMENTAL 8,271 0.00% 4603 • INTEREST EARNINGS 100,246 45,617 33,266 47,000 52,200 11.06% 4605 • UNREALIZED INVESTMENT GAIN/LOSS 52,609 (60,868) 0.00% TOTAL INVESTMENT EARNINGS 152,855 (15,251) 33,266 47,000 52,200 11.06% 4601 -SPECIAL ASSESSMENTS 422 0.00% 4921 • REFUNDS AND REIMBURSEMENTS 1,100 0.00% TOTAL MISCELLANEOUS 422 1,100 0.00% 4931 -BOND SALES 1,600,000 -100.00% TOTAL DEBT ISSUANCE 1,600,000 -100.00% TOTAL NONOPERATING REVENUES 161 548 (14,151! 33,266 1,647,000 52,200 -96.83% NONOPERATING EXPENSES 6530 • IMPROVEMENTS (195) 27,603 2,492,900 1,464,588 -41.25% TOTAL CAPITAL OUTLAY (195) 27,603 2,492,900 1,464,588 -41.25% 6601 -BOND PRINCIPAL 721,473 721,473 833,213 15.49% 6611 • BOND INTEREST 164,501 176,581 189,125 189,126 246,569 30.37% 6621 • PAYING AGENT/OTHER FEES 8,317 (27,664) 3,000 -100.00% TOTAL DEBT SERVICE 172,818 148,917 910,598 913,599 1,079,782 18.19% 6471 • ADMINISTRATIVE SERVICE TRANSFER 99,426 166,744 125,882 167,842 255,798 52.40% TOTAL TRANSFERS 99,426 166,744 125,882 167,842 255,798 52.40% TOTAL NONOPERATING EXPENSES 272,049 315,661 1,064,083 3,574,341 2 18001168 -21.66% NET CHANGE IN FUND BALANCE ~ 284,512 ~ 169,045 ~ {675,939) i {1,204,622) ~ {2,410,208) 100.08% STORM SEWER UTILITY FUND -65100 PUBLIC UTILITY FUND 2022 2020 2021 September 2022 2023 Object Code I Descriellon Actual Actual YTD Budget Budget Change 49411 -STORM SEWER UTILITY-OPERATIONS OPERATING REVENUES 4707 -PENAL TIES $ $ $ $ $ 0.00% 4731 -STORM DRAINAGE FEES 1,691,946 1,770,889 1,403,515 1,864,694 1,995,222 7.00% TOTAL SALES AND USER FEES 1,691,946 1,770,889 1,403,515 1,864,694 1,995,222 7.00% TOTAL OPERATING REVENUES 1,691,946 1,770,889 1,403,515 1,864,694 1,995,222 7.00% OPERATING EXPENSES 6101 -WAGES & SALARIES-FT EMPLOYEES 215,822 224,053 169,572 223,403 240,796 7.79% 6102 -OVERTIME-FT EMPLOYEES 348 1,815 1,129 2,500 2,500 0.00% 6103 -WAGES-PART TIME EMPLOYEES 6,934 808 10,800 10,800 0.00% 6111 -SEVERANCE PAY 3,030 5,650 0.00% 6122 -PERA COORDINATED PLAN 16,213 16,940 12,803 17,754 19,057 7.34% 6125 -FICA-SOCIAL SECURITY 13,735 14,105 10,625 14,676 15,755 7.35% 6126 -FICA-MEDICARE 3,278 3,299 2,485 3,432 3,685 7.37% 6131 -CAFETERIA PLAN CONTRIBUTIONS 45,396 47,520 37,422 56,549 58,245 3.00% 6141 -UNEMPLOYMENT INSURANCE 2,791 0.00% 6151 -WORKER'S COMP INSURANCE 16,567 14,055 11 020 21,463 20,960 -2.34% TOTAL PERSONAL SERVICES 324,114 328,245 245,056 350,577 371,798 6.05% 6204 -STATIONARY SUPPLIES 0.00% 6217 -SAFETY SUPPLIES 1,406 256 500 500 '0.00% 6219 -GENERAL OPERATING SUPPLIES 525 48 32 6,000 6,000 0.00% 6224 -STREET MAINT MATERIALS 3,690 3,119 (35) 8,000 9,000 12.50% 6239 -OTHER REPAIR & MAINT SUPPLIES 7,704 20,091 19,801 36,000 36,000 0.00% 6241 -SMALL TOOLS 2,758 1,351 1,500 1,500 0.00% 6243 -MINOR COMPUTER EQUIPMENT 1,622 281 0.00% TOTAL SUPPLIES 13,541 27,703 21,405 52,000 53,000 1.92% 6301 -ACCTG, AUDIT & FIN'L SERVICES 2,555 2,509 3,000 3,000 3,000 0.00% 6302 -ARCH, ENG & PLANNING 11,151 55,554 21,406 20,000 20,000 0.00% 6307 -PROFESSIONAL SERVICES 5,271 1,828 1,323 2,000 2,000 0.00% 6322 -POSTAGE 0.00% 6329 -OTHER COMMUNICATION SERVICES 29 0.00% 6331 -TRAVEL EXPENSE/MILEAGE 500 500 0.00% 6342 -LEGAL NOTICES 150 150 0.00% 6351 -PRINTING 1,500 1,500 0.00% 6384 -REFUSE DISPOSAL 2,800 1,843 2,560 5,000 5,000 0.00% 6409 -OTHER REPAIR & MAINT SVCS 17,544 21,629 6,942 36,000 100,000 177.78% 6417 -UNIFORMS 1,050 1,300 1,569 1,100 1,500 36.36% 6423 -LOGIS CHARGES 24,067 24,996 16,472 24,000 29,051 21.05% 6432 -CONFERENCES AND SCHOOLS 390 700 700 0.00% 6434 -DUES & SUBSCRIPTIONS 62,266 120,727 1,511 63,400 63,400 0.00% 6449 -OTHER CONTRACTUAL SERVICE 4,530 18,495 5 003 13,000 13,000 0.00% TOTAL SERVICES & OTHER CHARGES 131,234 249,300 59,786 170,350 239,801 40.77% 6361 -GENERAL LIABILITY INSURANCE 2,759 2,874 1700 3,018 3,300 9.34% TOTAL INSURANCE 2,759 2,874 1,700 3,018 3,300 9.34% 6461 -FUEL CHARGES 8,209 10,631 7,342 9,900 10,400 5.05% 6462 -FIXED CHARGES 4,763 6,645 4,122 5,492 6,839 24.53% 6463 -REPAIR & MAINT CHARGES 29,649 22,261 10,734 18,300 15,000 -18.03% 6465 -REPLACEMENT CHARGES 51,475 46,778 44426 59,234 63,473 7.16% TOTAL CENTRAL GARAGE CHARGES 94,096 86,315 66,624 92,926 95,712 3.00% 6494 -DEPRECIATION EXPENSE 1,431,750 1,444,192 1,089 082 1,450,000 1,450,000 0.00% TOTAL DEPRECIATION 1,431,750 1,444,192 1,089,082 1,450,000 1,450,000 0.00% TOTAL OPERATING EXPENSES 1,997,494 2,138,629 1,483,653 2,118,871 2,213,611 4.47% OPERATING INCOME (LOSS) (305,548) (367,740) (80,138) (254,177) (218,389) -14.08% NONOPERATING REVENUES 4603 -INTEREST EARNINGS 93,458 43,561 38,897 43,200 50,800 17.59% 4605 -UNREALIZED INVESTMENT GAIN/LOSS 44,656 (59,282) 0.00% TOTAL INVESTMENT EARNINGS 138,114 (15,721) 38,897 43,200 50,800 17.59% 4320 -FEDERAL GRANTS 24,896 0.00% 4373 -OTHER GRANTS/AID 50,000 0.00% 4912 -CAPITAL CONTRIBUTIONS 391,952 485,710 0.00% TOTAL MISCELLANEOUS 416,848 535,710 0.00% 4931 -BOND SALES 940,000 -100.00% 4932 -PREMIUM ON BOND SALES 0.00% TOTAL DEBT ISSUANCE 940,000 -100.00% TOTAL NONOPERATING REVENUES 554,962 519,989 38 897 983,200 50 800 -94.83% NONOPERATING EXPENSES 6540 -EQUIPMENT & MACHINERY 27,645 14,400 52,000 261.11% 6530 -IMPROVEMENTS 179,751 292,879 1,831,207 377,181 -79.40% TOTAL CAPITAL OUTLAY 207,396 292,879 1,845,607 429,181 -76.75% 6601 -BOND PRINCIPAL 355,000 355,000 515,000 45.07% 6611 -BOND INTEREST 135,514 141,011 170,470 170,470 194,106 13.87% 6621 -BOND ISSUE COSTS (16,485) (10,324) 1,500 1,500 0.00% TOTAL DEBT SERVICE 119,029 130,687 525,470 526,970 710,606 34.85% 6471 -ADMINISTRATIVE SERVICE TRANSFER 99,426 168,929 126,844 169,125 257,845 52.46% TOTAL TRANSFERS 99,426 168,929 126,844 169,125 257,845 52.46% TOTAL NONOPERATING EXPENSES 425,851 299,616 945,193 2,541,702 1,397,632 -45.01% NET CHANGE IN FUND BALANCE i {176,437) i {147,367) ~ {986,434) ~ {1,812,679) . ~ (1,565,221) -13.65% STREET LIGHT UTILITY FUND· 65200 PUBLIC UTILITY FUND 2022 2020 2021 September 2022 2023 Object Code / Descrl~tlon Actual Actual YTD Budget Budget Change 49571 ·STREETLIGHT-OPERATIONS OPERATING REVENUES 4707 -PENAL TIES $ $ $ $ $ 0.00% 4741 -STREET LIGHT SERVICE CHARGE 449,286 448,957 348182 460,000 483,000 5.00% TOTAL SALES AND USER FEES 449,286 448,957 348 182 460,000 483,000 5.00% TOTAL OPERATING REVENUES 449,286 448,957 348,182 460,000 483,000 5.00% OPERATING EXPENSES 6204 -STATIONARY SUPPLIES 0.00% 6243 -MINOR COMPUTER EQUIPMENT 405 10 0.00% 6239 -OTHER REPAIR & MAINT SUPPLIES 76 569 13,750 138,750 909.09% TOTAL SUPPLIES 481 10 569 13,750 138,750 909.09% 6307 -PROFESSIONAL SERVICES 32 23 19 200 200 0.00% 6322 -POSTAGE 0.00% 6351 -PRINTING 100 100 0.00% 6409 -OTHER REPAIR & MAINT SVCS 20,482 33,242 20,588 20,000 25,000 25.00% 6423 -LOGIS CHARGES 5,452 6,354 4,118 6,000 7,263 21.05% 6449 -OTHER CONTRACTUAL SERVICE 788 15,041 453 300 500 66.67% TOTAL SERVICES & OTHER CHARGES 26,754 54,660 25,178 26,600 33,063 24.30% 6361 -GENERAL LIABILITY INSURANCE 1,132 885 505 930 1,000 7.53% TOTAL INSURANCE 1,132 885 505 930 1,000 7.53% 6381 -ELECTRIC 182,385 185,253 159 280 200,000 220,000 10.00% TOTAL UTILITIES 182,385 185,253 159,280 200,000 220,000 10.00% 6494 -DEPRECIATION EXPENSE 70,101 101,115 98588 80,000 101,115 26.39% TOTAL DEPRECIATION 70,101 101,115 98,588 80,000 101,115 26.39% TOTAL OPERATING EXPENSES 280,853 341,923 284,120 321,280 493,928 53.74% OPERATING INCOME (LOSS) 168,433 107,034 64,062 138,720 (10,928! -107.88% NONOPERATING REVENUES 4603 -INTEREST EARNINGS 16,892 12,018 7,730 8,200 12,800 56.10% 4605 -UNREALIZED INVESTMENT GAIN/LOSS 8,696 (14,912) 0.00% TOTAL INVESTMENT EARNINGS 25,588 (2,894) 7,730 8,200 12,800 56.10% 4912 • CAPITAL CONTRIBUTIONS 15,069 0.00% 4921 • REFUNDS & REIMBURSEMENTS 27,480 38,559 42,778 0.00% TOTAL MISCELLANEOUS 27,480 53,628 42,778 0.00% TOTAL NONOPERATING REVENUES 53 068 50 734 50,508 8 200 12 800 56.10% NONOPERATING EXPENSES 6530 -IMPROVEMENTS 571,662 20,000 -96.50% TOTAL CAPITAL OUTLAY 571,662 20,000 -96.50% 6471 -ADMINISTRATIVE SERVICE TRANSFER 25,766 47,930 36,038 48,051 75,996 58.16% TOTAL TRANSFERS 25,766 47,930 36,038 48,051 75,996 58.16% TOTAL NONOPERATING EXPENSES 25,766 47 930 36,038 619 713 95 996 -84.51% NET CHANGE IN FUND BALANCE i 195,735 ~ 109,838 i 78,532 ~ (472,793) ~ (94,124) -80.09% RECYCLING UTILITY FUND· 65300 PUBLIC UTILITY FUND 2022 2020 2021 September 2022 2023 Object Code / Descri~tion Actual Actual YTD Budget Budget ChanQe 49311 • RECYCLING OPERATING REVENUES 4707 • PENAL TIES $ 234 $ $ $ $ 0.00% 4751 • RECYCLING SERVICE FEES 394,261 393,347 300,198 400,000 408,000 2.00% TOTAL SALES AND USER FEES 394,495 393,347 300,198 400,000 408,000 2.00% TOTAL OPERATING REVENUES 394,495 393,347 300,198 400,000 4081000 2.00% OPERATING EXPENSES 6204 • STATIONARY SUPPLIES 0.00% 6243 • MINOR COMPUTER EQUIPMENT 405 10 0.00% TOTAL SUPPLIES 405 10 0.00% 6307 -PROFESSIONAL SERVICES 52 36 31 0.00% 6322 -POSTAGE 0.00% 6423 -LOGIS CHARGES 5,452 6,354 4,118 6,000 7,263 21.05% 6449 • OTHER CONTRACTUAL SERVICE 377,444 377,422 302,040 400,000 410,000 2.50% TOTAL SERVICES & OTHER CHARGES 382,948 383,812 306,189 406,000 417,263 2.77% 6361 -GENERAL LIABILITY INSURANCE 1,880 1,404 822 1,404 1,418 1.00% TOTAL INSURANCE 1,880 1,404 822 1,404 1,418 1.00% TOTAL OPERATING EXPENSES 385,233 385,226 307 011 407 404 418 681 2.77% OPERATING INCOME (LOSS) 9 262 8121 (6,813l (7,404l po,681l 44.26% NONOPERATING REVENUES 4603 -INTEREST EARNINGS 3,309 2,104 1,425 1,600 2,200 37.50% 4605 • UNREALIZED INVESTMENT GAIN/LOSS 1,500 (2,563) 0.00% TOTAL INVESTMENT EARNINGS 4,809 (459) 1,425 1,600 2,200 37.50% NONOPERATING EXPENSES 6471 -ADMINISTRATIVE SERVICE TRANSFER 11,169 17,831 13,658 18,211 20,806 14.25% TOTAL TRANSFERS 11,169 17,831 13,658 18,211 20,806 14.25% NET CHANGE IN FUND BALANCE i 2,902 i (10,169) i (19,046) i (24,015) i (29,287) 21.95% 't, o O K L Jo' ~~~111~: City of Brooklyn Center ~ 2023 Budget -Public Utilities Funds Summary AT THe CENTER / .t I I \ '---....._ / / I \ ' 60100 60200 65100 65200 65300 Sanitary Storm Street Water Sewer Sewer Lights Reclcling Total Revenues Charges for goods and services $ 5,376,793 $ 5,294,200 $ 1,995,222 $ 483,000 $ 408,000 $ 13,557,215 Investment earnings 31,800 52,200 50,800 12,800 2,200 149,800 Total Revenues 5,408,593 5,346,400 2,046,022 495,800 410,200 13,707,015 Expenditures Capital outlay 2,182,888 1,464,588 429,181 20,000 -4,096,657 Debt service 2,870,343 1,079,782 710,606 --4,660,731 Utility operations 4,145,470 4,956,440 2,213,611 493,928 418,681 12,228,130 Total Expenditures/Expenses 9,198,701 7,500,810 3,353,398 513,928 418,681 20,985,518 Other Financing Sources and Uses Issuance of debt Transfers out (283,079) (255,798) (257,845) {75,996) {20,806) (893,524) Total Other Financing Sources & Uses (283,079) (255,798) (257,845) (75,996) (20,806) (893,524) Net Change in Fund Balance $ (4,073,187} $ {2,410,208) $ {1,565,221} $ {94,124} $ (29,287} $ {8,172,027) 1/2/2023 1 Public Works Department City Council Work Session, November 21, 2022 Elizabeth Heyman, Public Works Director and Angela Holm, Finance Director Responsibly provide for the maintenance and operations of the City’s infrastructure and facilities in a quality, cost effective manner including: •121 miles of water main, 2,050 valves, 1,000 hydrants, 9,000 metered connections •105 miles sanitary sewer, 9,000 sewer service connections, 10 lift stations •88 miles of storm drains and 100 treatment facilities •270 city‐owned ornamental lights, 920 Xcel lights and 100 traffic signal overhead lights Strategic Function – Public Utilities •Water Utility: 1.3 billion gal/yr supplied to customers from 9 wells, 3 water towers, water treatment plant •Sanitary Sewer Utility: Conveyance of 900 million gal/yr of wastewater •Storm Drainage Utility: Maintain approx. 88 miles of drainage pipes, 40 ponds, storm sewer structures •Street Light Utility: Operation of 1300 street lights 2 1/2/2023 2 Public Utilities – Staffing Levels 3 Positions FTEs 2021 2022 2023 Supervisor of Utilities 111 Engineering Technician 3 (distributed 1/3 over 49141, 49251, 49411) 111 Maintenance II (4‐49141, 2‐49251, 2‐49411) 9 9 9 Part Time/Summer Temporary Employees (3‐49141, 2‐49251, 1‐ 49411) 2.0 2.0 3.0 Total 13.0 13.0 13.0 Annual Goals & Strategies 1. Meet or exceed safe drinking water standards of the State of Minnesota and manage storm water runoff in an efficient and environmentally sensitive manner. a. Manage and enforce the City’s Wellhead Protection Plan goals. b. Implement Best Management Practices (BMPs) that support the City’s and Watershed’s impaired waters Total Maximum Daily Load (TMDL) plans. 2. Initiate improved, streamlined management strategies and techniques by use of refined methods and technologies. a. Automate the monthly well pumping records and reporting to the Minnesota Department of Health. 4 1/2/2023 3 Utilities Performance Measures 5 Performance Objectives Description of Performance Measure Performance Levels *Actual Value Target Value Miles of annual street sweeping performed 1459.1 miles (4 Citywide, 10 targeted) >990 miles (4 Citywide rounds, 10 rounds of targeted secondary areas) Miles of annual sanitary sewer televised, cleaned, root‐sawed, lined and new pipe 26 >= 19.6 miles (1/5 of the City’s total 97.9 miles) Private sanitary sewer backups per year (due to City system blockage)10 Drinking Water Regulated Substances: Copper Lead Barium Trihalomethanes Haloacetic Acids Total Chlorine Flouride No violation No violation No violation No violation No violation No violation No violation No violations Key Initiatives 6 •Rain garden landscaping and maintenance •Stocking light poles •Lead and copper data collection •Continuing lift station rehabilitations •I‐94 & Dupont 24” steel water main replacement •Water treatment plant redundant water main connection •Freeway and Highway utility crossing replacements 1/2/2023 4 7 Cash Flow/Rate Projections •Assumptions for Cash Flow/Rate Projections •Includes capital outlay based on 15 –year CIP •Anticipated debt issues include: •Water G.O. Revenue Bonds – 2024, 2025, 2028 •Sanitary Sewer G.O. Revenue Bonds – 2024, 2025, 2028, 2030 •Storm Sewer G.O. Revenue Bonds – 2029, 2030 •3% annual increase in personal services, 2% annual increase in operating expenses •Adjustments to address inflation and other operational updates 8 Water Utility Rate & Cash 1/2/2023 5 9 Water Utility Cash Flow Water Utility Rate Comparison 10 1/2/2023 6 Sanitary Sewer Utility Rate/Cash Flow 11 Sanitary Sewer Utility Cash Flow 12 1/2/2023 7 Sanitary Sewer Utility Rate Comparison 13 Storm Water Utility Rate/Cash Flow 14 1/2/2023 8 Storm Water Utility Cash Flow 15 Storm Sewer Utility Rate Comparison 16 1/2/2023 9 17 Comparative City Utility Rates 18 Comparative City Utility Rates 1/2/2023 10 Street Light Utility Rate/ Cash Flow 19 Street Light Utility Cash Flow 20 1/2/2023 11 Street Light Utility Rate Comparison 21 Recycling Utility Rate/Cash Flow 22 1/2/2023 12 Recycling Utility Rate Comparison 23 Questions? 24 1/2/2023 13 Central Garage Fund •Central Garage – Equipment Replacement •This fund accounts for the operation of a centralized management of fuel, preventive maintenance, repair and replacement of city owned motorized equipment and fleet. •Staffing FTE •Deputy Public Works Director 1 •Crew Leader/Mechanic 1 •Mechanic 2 •Night Service Person 1 •Administrative Technician 1 •Note: In 2021 the Deputy Public Works Director was included directly to this fund and will be funded through central garage charges to supported funds. 2023 Equipment Purchases Vehicle/Equipment Department Ford SUV Interceptor Fire Groundsmaster Mower Parks Ford SUV Interceptor Police Ford SUV Interceptor Police Ford SUV Interceptor Police Ford SUV Interceptor Police Mack GU712 Street Caterpillar 928 Wheel Loader Streets Triple Axle Trailer Heavy Duty Streets Tandem Dump Truck Streets Reelmaster Mower Golf 1/2/2023 14 Central Garage Cash Flow 27 Questions? 28 1/2/2023 15 Proposed Beautification Fund 29 •Initial funding proposed in 2022 •$50,000 of excess 2020 General Fund Balance over 52% of 2021 expenditures •$50,000 of 2021 LGA Allocation •Proposed transfers have not occured •Expenditures would be capital in nature (all related personnel, supplies, etc., would remain in general fund) Questions? 30