Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
CC WS PACKET 08082022
CITY OF SAINT ANTHONY VILLAGE WORKSESSION AGENDA Monday, August 8, 2022 at 5:45PM Join Meeting via Zoom There is also a dial -in option available. Members of the public who wish to attend the meeting may do so in person. Minutes WS 7 -12 -22.PDF Worksession Topics Staff Proposed 2023 Budget And Levy Presentation Shelly Rueckert, Finance Director, presenting. 1 OVERALL LEVY OPTIONS.PDF 2 GF REV DETAIL.PDF 3 GF EXP DETAIL.PDF 4 LQ CASH FLOW.PDF Future Worksession Dates, Times And Agenda Items Next Worksessions: September 13th 5:45 - Police Department Staffing Structure Renewal Ramsey County Mutual Aid Adjournment If you would like to request special accommodations or alternative formats, please contact the City Clerk at 612 -782 -3313 or email city@savmn.com . People who are deaf or hard of hearing can contact us by using 711 Relay. Our Mission is to be a progressive and welcoming Village that is walkable, sustainable and safe. 1. Documents: 2. A. Documents: 3. 4. 1 CITY OF SAINT ANTHONY VILLAGEWORKSESSION AGENDAMonday, August 8, 2022 at 5:45PMJoin Meeting via ZoomThere is also a dial -in option available. Members of the public who wish to attend the meeting may do so in person. Minutes WS 7 -12 -22.PDFWorksession TopicsStaff Proposed 2023 Budget And Levy PresentationShelly Rueckert, Finance Director, presenting.1 OVERALL LEVY OPTIONS.PDF2 GF REV DETAIL.PDF3 GF EXP DETAIL.PDF4 LQ CASH FLOW.PDFFuture Worksession Dates, Times And Agenda ItemsNext Worksessions:September 13th 5:45 -Police Department Staffing StructureRenewal Ramsey County Mutual Aid Adjournment If you would like to request special accommodations or alternative formats, please contact the City Clerk at 612 -782 -3313 or email city@savmn.com . People who are deaf or hard of hearing can contact us by using 711 Relay. Our Mission is to be a progressive and welcoming Village that is walkable, sustainable and safe. 1.Documents:2.A.Documents:3.4. 2 City of St. Anthony CITY COUNCIL WORK SESSION Minutes July 12, 2022 Present: Mayor & Council Randy Stille, Mayor, Thomas Randle, Councilmember, Jan Jenson, Councilmember, Bernard Walker, Councilmember Staff: Charlie Yunker, City Manager Consultants: Steve Grittman, City Planner Call to Order: Mayor Stille called the Work Session to order at 5:45 p.m. Code Amendments: City Planner Grittman reviewed the draft amendments to the City Code that have been compiled from the work of the staff code committee discussing challenges encountered applying the code in their day- to-day activities. This covered seven general topics of; wild animals, landscaping, fencing, right of way management, alcohol licensing, bus benches, and food trucks. Council discussed the process for approving chickens, and members present affirmed the current process for approval. Council asked questions on, and discussed verbiage in various topics and did not make any revisions. In-depth discussion was held on other topics; tap rooms and food trucks. Council discussed alcohol licensing for tap room “growler” off-site sales, which is newly allowable from recent code changes, on how this may impact the city-owned off-sale liquor stores. Council directed staff to get comments from the Liquor Operations Manager on expected impact. Council discussed the existing food to alcohol ratio requirement in the code, and directed staff to examine the applicability and necessity of that requirement. Council discussed the food truck topic on how to avoid unfair competition with established, “brick and mortar” restaurants. Council discussed exploring identifying certain areas food trucks can operate to avoid unfair competition. Staff will integrate the Council feedback into the draft that will be presented to the Planning Commission for their input, before coming back to Council and a regular meeting for consideration. Edible Cannabinoids: City Manager Yunker reviewed the initial guidance from the League of Minnesota Cities on the new law effective July 1, 2022 legalizing some forms of edible THC’s. Regulation is left to cities to determine, and staff asked Council their thoughts on where the City should go in terms of regulation. 3 Council discussed the topic, and consensus of the members present was to pass an interim ordinance that would establish a moratorium to allow time for further study. Still will add that to the July 26, 2022 regular Council Meeting agenda. Future Work Sessions: Next Work Sessions will be held on July 26th, 2022, at 6:00pm in the Council Chambers. Adjournment: The meeting adjourned at 6:54 p.m. Respectfully submitted by Charlie Yunker, City Manager. 4 CITY OF ST. ANTHONY VILLAGE 2023 BUDGET OVERALL LEVY *2023 OVERALL PRELIMINARY LEVY 2022 $ Change 2023 % Change General Fund 5,080,297$ 361,574 5,441,871$ 7.12% HRA Fund 209,414 - 209,414 0.00% CIP Fund 308,200 30,000 338,200 9.73% Debt Service Funds 2,487,181 2,487,181 0.00% Infrastructure Fund 65,000 5,000 70,000 7.69% Building Improvement Fund 88,000 5,000 93,000 5.68% Park Improvement Fund 5,000 5,000 10,000 NA Total (union contracts at 3% increase ) 8,243,092$ 406,574$ 8,649,666$ 4.93% Option to include reserve for employee retention 27,209$ 8,676,875$ 5.26% Fire Union - Paramedic MOU 10,550$ 8,687,425$ 5.39% *Factors included in Preliminary Levy estimate: 2) Health Insurance premiums increased 10.85 %, high claims impacted scheduled rate increase - estimated cost $31,751 4) Professional Services and Contracted IT services costs up $52,857 substantially due to anticipated rate increases due to inflation. 5) Fuel and Utilities estimated costs up $44,979 - 2022 cost per gallon $2.94, 2023 est. cost per gallon $3.82 6) Miscellaneous Contracted services reduced by $53,173 substantially due to bringing communication staff in house and assuming the maintenance duties for Salo Park 7) Reflects an $42,521 increase in Local Government Aid 8) Increase of 2023 charges for police services adds revenue of $58,027. 9) Includes $12,757 in additional permit revenues due to inflated construction costs. 10) Liquor transfer to General Fund increases by $25,000 for 2023, transfer amount $275,000 11) Estimated Excess TIF revenue to increase by $51,780, County is reviewing their calculations. 12) HRA Levy remains at same level as 2022. 13) Debt service levy at a zero levy increase. 14) CIP, Building, Infrastructure, Park improvement annual levy increases are consistent with Long Term Capital plans. Please note that for the every $82,430 in General Fund incremental spending, equals a 1% overall levy increase. Year Levy % increase COLA 2022 4.80%3.00% 2021*3.37%2.00% 2020 4.08%3.25% 2019 6.74%3.25% 2018 6.19%3.00% * Did not Levy annual $30,000 increase in capital levies due to COVID uncertainties Past five year levy increases General Fund Cost Drivers Capital and Debt Levy Impacts 1) 3 % Wage adjustment, plus step adjustments, public safety longevity adjustments, public works lead worker adjustments in-house communications position, part-time accounting clerk converted to full-time - cost impact $340,027. 3) Workman's Compensation, Liability, Property and Casualty premiums projected to increase by $25,577, substantially due to statewide police PTSD claims impacting police workers compensation rates. General Fund Revenue Impacts 5 Fiscal Year 2023 12/31/2020 ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET 2018 2019 2020 2021 2022 2022 2023 TAXES 101-3101-0-0-01 TAX - CURRENT HENNEPIN/RAMSEY 3,948,658$ 4,275,305$ 4,572,738$ 4,737,190$ 4,978,673$ 4,978,673$ 5,333,034$ BASED ON PRELIMINARY ESTIMATES 101-3102-0-0-01 TAX - DELINQUENT 24,954 (18,387) 34,379 15,046 2,500 5,000 5,000 Based on current run rate 101-3103-0-0-02 TAX - MOBILE HOME/NON-LEVY 5,414 5,033 345 17,158 2,050 5,000 5,000 Based on current run rate 101-3105-0-0-01 TAX - TIF 257,772 286,087 262,104 215,555 147,220 199,000 199,000 Based on 2022 estimated actual TOTAL 4,236,798$ 4,548,038$ 4,869,566$ 4,984,950$ 5,130,443$ 5,187,673$ 5,542,034$ LICENSES 101-3210-1-1-01 LICENSE ON SALE INTOXICATING 16,400$ 16,719$ 16,400$ 17,767$ 24,600$ 24,600$ 24,600$ Based on current License count 101-3210-1-1-02 LIQUOR INVST /COMPLIANCE 500 1,000 1,000 500 - - - No fines for noncompliance anticipated 101-3210-1-1-03 LICENSE WINE & BEER 6,375 5,125 3,000 3,500 3,500 3,500 4,500 Based on current License count 101-3210-1-1-04 LICENSE BEER 3.2%550 300 200 200 200 200 200 Based on current License count 101-3211-1-1-01 LICENSE RENTAL SF 14,450 14,450 16,100 15,250 14,400 14,550 14,550 Based on Est. current License count trend 101-3211-1-1-02 LICENSE RENTAL MULTI FAMILY 16,990 16,990 17,190 20,010 16,990 16,990 20,045 Based on current License count- partial Doran and Hayden license in 2023 101-3212-1-1-00 LICENSE CIGARETTE SALES 2,100 2,400 2,100 2,600 2,400 2,100 2,100 Based on current License count 101-3213-1-2-00 LICENSE DOG - - - 500 - 20 - Reg. Dog License retired in 2017 replaced w/ Dangerous dog license 101-3214-1-1-00 LICENSE SERVICE STATION 1,560 2,100 1,590 1,590 1,590 1,590 1,590 Based on current License count for active stations 101-3215-1-1-00 LICENSE OTHER 460 430 430 430 430 430 430 Based on current License count 101-3216-1-2-00 LICENSE FIREWORKS 100 100 100 100 100 100 100 Based on current License count 101-3218-1-1-00 LICENSE GENERAL CONTRACTOR 4,385 4,715 4,075 5,075 3,500 3,500 3,500 License count varies based on construction activity 101-3219-1-1-00 LICENSE HAULERS 1,350 1,350 1,350 1,350 1,350 1,200 750 3 Commercial / 1 Residential Hauler TOTAL 65,220$ 65,679$ 63,535$ 68,872$ 69,060$ 68,780$ 72,365$ PERMITS 101-3220-1-1-00 PERMITS LAND USE 7,000$ 5,650$ 9,960$ 18,955$ 4,500$ 7,500$ 5,000$ Conservative Est of run rate 101-3221-1-1-00 PERMITS BUILDING 104,862 92,355 131,472 462,511 107,411 107,411 113,856 2023 baseline estimate 101-3221-1-1-01 PERMITS PLAN CHECK 50,422 33,048 53,429 275,669 47,067 47,067 49,891 2023 baseline estimate 101-3222-1-1-00 PERMITS GAS, HVAC 20,376 15,012 11,083 107,878 19,706 19,706 20,888 2023 baseline estimate 101-3223-1-1-00 PERMITS PLUMBING 11,143 9,305 8,854 101,685 9,981 9,981 10,580 2023 baseline estimate 101-3224-1-1-00 PERMITS ELECTRICAL 18,797 21,315 20,611 62,172 18,447 18,447 19,554 2023 baseline estimate 101-3225-1-1-00 PERMITS ADMIN FEES 9,968 11,295 12,046 10,266 15,000 10,000 10,600 2023 baseline estimate 101-3228-1-1-00 PERMITS ALARM 3,454 2,760 3,260 3,215 2,800 2,800 2,884 Conservative Est of run rate 101-3229-1-1-00 PERMITS MISCELLANEOUS 4,710 12,145 3,982 5,224 6,000 8,000 8,000 Sign permits & ROW permits TOTAL 230,732$ 202,884$ 254,697$ 1,047,574$ 230,912$ 230,912$ 241,253$ INTERGOVERNMENTAL 101-3310-2-3-00 FEDERAL GRANTS 471 2,036 689,176$ 5,061 31,070 31,070 175,539 Includes State vest reimbursement as well & SAFER GRANT PLACEHOLDERS 101-3320-2-2-01 ISD 282- DARE PROGRAM 14,500 14,500 16,326 - - - - School opted out of DARE program after 2021 budget was adopted 101-3330-0-0-00 MVHC/LGA 552,240 553,865 613,302 640,386 640,386 640,386 682,907 Based on Senate 2023 LGA proposal 101-3340-0-0-00 STATE AID- PERA INCREASE 7,197 7,197 - - - - - Legislation to extend aid past 2020 failed 101-3342-2-2-00 STATE AID- FIRE RELIEF 53,083 53,716 - - - - - FIRE RELEF PART OF STATE PLAN NO PASS THOUGH OF AID 101-3346-2-2-00 STATE AID- POLICE 206,192 197,500 205,476 205,489 196,057 196,057 196,057 2023 budget based on 2022 budget - 2022 aid not yet received 101-3348-3-2-00 STATE AID- MSA MAINTENANCE 97,275 96,265 103,441 93,988 93,988 107,826 107,826 2023 Based on 2022 State Aid 101-3350-2-2-00 LOCAL GRANTS- FIRE (DISABILITY & ED) 19,696 11,552 9,856 36,082 14,210 14,210 14,210 2022 Estimated 2021/2022 Grant base level plus minimal surplus allocation 101-3360-2-2-00 LOCAL GRANTS- POLICE 41,623 52,625 52,689 39,815 48,000 48,000 35,000 Safe and sober program estimated activity 101-3362-0-0-00 LOCAL GRANTS-RECYCLING - - - - 17,567 17,567 17,567 Closed out recycling fund-moved revenue here 101-3365-1-1-00 LOCAL GRANTS- MISCELLANEOUS - - - - 250 3,638 6,429 Includes State aid for disabled officer health insurance 101-3370-2-2-00 LOCAL GRANTS- PW 68 4,432 1,064 5,064 5,000 5,000 5,000 Opportunity operating grants TOTAL 992,347$ 993,689$ 1,691,330$ 1,025,885$ 1,046,528$ 1,063,754$ 1,240,535$ GENERAL FUND REVENUES DETAIL 6 Fiscal Year 2023 12/31/2020 ACTUAL ACTUAL ACTUAL ACTUAL BUDGET EST. ACTUAL BUDGET 2018 2019 2020 2021 2022 2022 2023 GENERAL FUND REVENUES DETAIL 101-3380-1-1-03 CS MWMO 102,148 109,612$ 115,381$ 114,695$ 110,789$ 110,789$ 114,113$ 2023 based on Est increase in personnel billing rates & less HR time 101-3380-1-1-04 CS BIRCHWOOD 7,789 11,492 8,138 8,529 9,200 9,200 9,476 Based on current level of contract services and rate increase 101-3380-1-1-05 CS NINENORTH 12,000 45,000 40,000 41,200 2023 based on personnel billing rates & EST. time 101-3380-1-2-07 CS ISD 282 11,965 13,981 6,445 8,834 7,500 9,250 9,250 Based on current level of contract services 101-3380-2-1-08 CS PD OTHER REIMB OT - - - - - - - Other reimbursed OT, No National event held in state in 2022 101-3380-3-1-05 CS HENNEPIN 31,756 33,464 39,532 40,505 40,505 40,505 40,505 Estimated at 2021 Actual 101-3380-3-1-06 CS NEW BRIGHTON FUEL 90,678 79,493 76,610 6,556 - - - NEW BRIGHTON PURCHASING ENDED FEB 2021 101-3380-5-1-01 CS LAUDERDALE 692,768 713,204 747,071 773,218 802,283 802,283 860,310 Based on 2023 Police contract proposal 101-3380-5-1-02 CS FALCON HGTS - - - - - - - TOTAL 937,105$ 961,246$ 993,177$ 964,338$ 1,015,277$ 1,012,027$ 1,074,854$ FINES 101-3510-1-1-00 COURT FINES 65,661$ 78,797$ 71,974$ 98,582$ 73,414$ 68,706$ 70,000$ 2023 projected run rate 101-3510-1-1-01 FALSE ALARMS 6,913 6,290 3,600 14,581 3,500 3,500 3,605 Est of run rate 101-3885-2-1-00 POLICE IMPOUND FEES 2,037 2,100 360 - - - - ADMN DUTIES ASSUMED BY TOW COMPANY IN 2020 TOTAL 74,611$ 87,187$ 75,934$ 113,163$ 76,914$ 72,206$ 73,605$ REIMBURSEMENTS AND OTHER REVENUES 101-3410-0-1-00 CLEAN-UP DAY FEES -$ -$ -$ -$ -$ 2,500$ 2,600$ Activity in general fund since 2022 101-3622-1-1-00 WT LEASE RENTALS 56,256 58,232 60,280 62,401 64,598 64,598 61,368 2023 SCHEDULED RENTS. 101-3800-1-1-00 DONATIONS GENERAL 500 - - - 500 500 500 Est of run rate 101-3800-2-1-01 DONATIONS PD - 500 400 500 500 500 500 Est of run rate 101-3800-2-1-02 DONATIONS PD CRIME PREVENTION 3,373 - - 100 - - - 101-3800-4-1-00 DONATIONS PARKS - - - 10 - - - 101-3804-1-1-00 RR- MISCELLANEOUS 19,596 9,752 15,605 6,108 3,500 3,500 3,500 Miscellaneous cost reimbursements / no net levy impact 101-3805-4-1-00 CABLE FRANCHISE FEES 101,612 97,200 95,517 103,768 97,951 97,951 93,053 2023 Comcast cable fees at conservative estimate 101-3809-0-0-00 LMC DIVIDENDS 8,358 6,954 17,117 32,487 11,554 11,554 11,554 2023 dividend placeholder 101-3810-0-0-00 INVESTMENT INCOME 23,866 58,472 36,153 (8,752) 11,500 11,500 4,700 Improved interest rates offset by market adjustment for exsisting CD'S at lower rates. 101-3810-1-1-00 MISCELLANEOUS 5,199 7,258 1,934 9,309 3,250 1,750 1,750 includes, branch chipping, sac/doli admin fees, spec. asmts., etc 101-3890-0-0-00 INSURANCE PROCEEDS 23,793 150 21,709 4,989 - 18,851 - TOTAL 242,554$ 238,518$ 248,715$ 210,919$ 193,353$ 210,704$ 179,526$ TRANSFERS IN 101-3920-0-0-00 LIQUOR FUND 250,000$ 250,000$ 250,000$ 250,000$ 250,000$ 275,000$ 275,000$ No change to Liquor transfer 101-3920-0-0-00 TIF ADMINISTRATION FEES 7,870 8,200 12,500 15,000 15,000 15,000 15,000 Additional staff time with TIF redevelopment activities 101-3920-0-0-00 WATER FILTRATION INT EARNINGS - - - - - - - 101-3920-0-0-00 CAPITAL RESERVE/OTHER TRANSFERS 100,000 - - 9,729 - - - CLOSED FUNDS 240/225 101-3920-0-0-00 CONDUIT FEE REASSIGNED - - - - - - - TOTAL 357,870$ 258,200$ 262,500$ 274,729$ 265,000$ 290,000$ 290,000$ TOTAL FUND REVENUE 7,137,235$ 7,355,442$ 8,459,454$ 8,690,430$ 8,027,487$ 8,136,056$ 8,714,170$ CHARGES FOR SERVICES 7 Fiscal Year 2023 12/31/2020 ACTUAL 2018 ACTUAL 2019 ACTUAL 2020 ACTUAL 2021 BUDGET 2022 EST. ACTUAL 2022 BUDGET 2023 MAYOR / CITY COUNCIL 101-4110-11-0000 CN REGULAR EMPLOYEE 38,256$ 38,256$ 38,256$ 38,256$ 38,256$ 38,256$ 38,256$ 0.00% NO CHANGE IN 2023 COUNCIL COMPENSATION 101-4121-11-0000 CN PERA 1,913 1,913 1,553 1,553 1,510 1,515 1,515 0.33% 5% CONTRIBUTION RATE, ONE OPT OUT BW 101-4122-11-0000 CN FICA/MEDICARE 552 555 1,113 1,001 555 1,048 1,048 88.92% 1.45% CONTRIBUTION RATE - MEDICARE, PLUS ONE MEMBER SS TAX 6.2 PERC BW 101-4300-11-0000 CN PROFESSIONAL SERVICES 6,508 6,088 20,270 10,127 7,500 7,225 8,500 13.33% 2020-2021 INCLUDED CM SEARCH - 2022 1K GOAL SETTING TELEVISED 101-4309-11-0000 CN MISC CONTRACTED SERVICES 907 905 846 850 949 949 1,190 25.43% ADJUSTED TO ESTIMATED RUN RATE (ADP) 101-4315-11-0000 CN RECORDING SERVICE 6,441 5,749 5,923 6,567 7,039 6,721 7,057 0.26% INFLATE RUN RATE 5 PERC 101-4341-11-0000 CN TRAINING, CONF., AND MTG.14,698 10,612 7,701 7,623 9,527 9,169 9,627 1.06% INFLATE RUN RATE 5 PERC 101-4342-11-0000 CN MEMBERSHIPS & DUES 13,121 13,250 13,616 21,128 29,766 29,043 30,495 2.45% 2023 PROJECTED RUN RATE - 2021/2022 INCREASED SUPPORT FOR NYFS 101-4345-11-0000 CN INTERGOVERMENTAL ACTIVITIES 3,678 - 472 97 425 435 450 5.88% SISTER CITY COSTS 101-4352-11-0000 CN CITY NEWSLETTER 6,624 7,558 10,037 21,626 18,966 19,457 20,235 6.69% INFLATE RUN RATE 4 PERC 101-4499-10-0000 CN MISCELLANEOUS 839 1,181 3,446 901 1,000 970 1,000 0.00% 4499-10 and 4499-11/unemployment benefits TOTAL 93,537$ 86,066$ 103,232$ 109,729$ 115,492$ 114,788$ 119,374$ 3.36% GENERAL MANAGEMENT 101-4110-12-0000 GM REGULAR EMPLOYEE 76,046$ 80,586$ 147,527$ 107,171$ 137,456$ 137,456$ 141,309$ 2.80% INCLUDES ESTIMATED WAGE ADJUSTMENTS 3 PERC 101-4121-12-0000 GM PERA 5,665 5,999 11,450 7,704 10,309 10,309 10,598 2.80% BASED ON CURRENT PERA FUNDING RATE 101-4122-12-0000 GM FICA/MEDICARE 3,929 4,016 9,878 7,419 10,515 10,515 10,810 2.80% BASED ON ER 7.65% OF GROSS 101-4131-12-0000 GM INSURANCE HEALTH 11,849 12,328 9,149 3,189 5,292 5,670 5,376 1.59% SPLIT 10.85% PREMUIM INCREASE 2023 101-4135-12-0000 GM INSURANCE WC 1,054 1,142 1,527 1,726 1,515 1,515 1,635 7.92% BASED ON 2022/2023 RENEWAL 101-4211-12-0000 GM OFFICE SUPPLIES 117 862 183 197 250 250 250 0.00% KEPT FLAT 101-4300-12-0000 GM PROFESSIONAL SERVICES - - - - - - - 0.00% 101-4306-12-0000 GM CONTRACTED HR - - - - - - - 0.00% 101-4309-12-0000 GM MISC CONTRACTED SERVICES 800 362 421 1,229 500 500 500 0.00% BASED ON MISC CONTRACTED SERVICES SPREADSHEET / license fee in 2021 101-4325-12-0000 GM COMMUNICATIONS - - - 31 300 300 300 0.00% KEPT FLAT 101-4341-12-0000 GM TRAINING, CONF., AND MTG.14,387 11,498 4,143 3,500 11,695 5,750 11,750 0.47% 2023 RETURNING TO PRE COVID ACTIVITY LEVEL 101-4342-12-0000 GM MEMBERSHIPS & DUES 6,664 6,841 4,864 6,365 6,750 8,268 8,600 27.41% 2023 EST. RUN RATE - added NAT'L LEAGUE OF CITIES MEMBERSHIP IN 2022 101-4343-12-0000 GM HEALTH & SAFETY PROGRAMS 7,430 7,248 7,365 7,404 7,848 7,575 8,014 2.11% INTEGRATED LOSS CONTROL SERVICES 101-4499-12-0000 GM MISCELLANEOUS - - 22 107 275 250 275 0.00% TOTAL 127,942$ 130,883$ 196,528$ 146,042$ 192,706$ 188,359$ 199,417$ 3.48% PLANNING 101-4110-13-0100 PL REGULAR EMPLOYEE 7,259$ 7,996$ 8,307$ 9,002$ 9,306$ 9,306$ 9,822$ 5.54% INCLUDES ESTIMATED WAGE ADJUSTMENTS 101-4110-13-0000 PL COMMISSION 2,295 1,855 1,390 2,065 2,500 2,200 2,500 0.00% BASED ON MEETINGS ATTENDED BY COMMISSIONERS 101-4111-13-0000 PL OVERTIME - 3 - - 260 260 260 0.00% KEPT FLAT 101-4121-13-0000 PL PERA 544 600 623 649 717 770 756 5.39% ADJUSTED TO ESTIMATED RUN RATE 101-4122-13-0000 PL FICA/MEDICARE 731 754 742 847 923 923 963 4.28% ADJUSTED TO ESTIMATED RUN RATE 101-4131-13-0000 PL INSURANCE HEALTH 1,723 1,793 1,869 1,972 378 378 384 1.59% SPLIT 10.85% PREMUIM INCREASE 2023 101-4226-13-0000 PL GENERAL SUPPLIES 121 133 35 155 125 125 125 0.00% KEPT FLAT 101-4302-13-0000 PL CONTRACTED PLANNER 57,805 78,061 61,215 61,793 72,000 69,992 72,792 1.10% ASSUMES HIGH ACTIVITY LEVEL CONTINUES 101-4302-13-0100 PL COMP PLAN - PLANNER - - - - - - - 0.00% COMPREHENSIVE PLAN COMPLETE GENERAL FUND EXPENDITURES DETAIL 8 Fiscal Year 2023 12/31/2020 ACTUAL 2018 ACTUAL 2019 ACTUAL 2020 ACTUAL 2021 BUDGET 2022 EST. ACTUAL 2022 BUDGET 2023 GENERAL FUND EXPENDITURES DETAIL 101-4305-13-0000 PL GIS CONTRACTED SERVICES 2,887 4,039 9,454 11,177 7,800 10,945 11,492 47.34% DATA LINK MAINT, GIS, ADDED CIVIC BUILDING PERMITS IN 21, 2022 actual plus 5% 101-4341-13-0000 PL TRAINING, CONF. & MTG.- 362 168 318 500 125 500 0.00% PLANNING COMMISSION TRAINING/GOAL SETTING 101-4351-13-0000 PL NOTICES & PUBLICATIONS 178 - - - - - - 0.00% TOTAL 73,544$ 95,596$ 83,804$ 87,978$ 94,509$ 95,024$ 99,594$ 5.38% ADMINISTRATIVE SERVICES 101-4110-14-0000 AD REGULAR EMPLOYEE -$ -$ 33,618$ 35,432$ 46,529$ 52,487$ 81,369$ 74.88% INC ESTIMATED WAGE ADJ/INCL RECYCLYING/INC PT COMM STAFF KWATSON 101-4111-14-0000 AD OVERTIME - - 3,152 - 4,200 - - -100.00% EARLY VOTING PROCESS NOW PART OF RAMSEY ELECTION CONTRACT 101-4112-14-0000 AD PART-TIME EMPLOYEE - - 3,989 1,216 2,500 - - -100.00% EARLY VOTING PROCESS NOW PART OF RAMSEY ELECTION CONTRACT 101-4121-14-0000 AD PERA - - 2,492 2,597 3,805 3,805 6,103 60.40% BASED ON CURRENT PERA FUNDING RATE 101-4122-14-0000 AD FICA/MEDICARE - - 1,891 1,846 4,072 4,072 6,225 52.87% BASED ON ER 7.65% OF GROSS 101-4131-14-0000 AD INSURANCE HEALTH - - 6,854 7,889 1,512 1,512 1,920 26.98% SPLIT 10.85% PREMUIM INCREASE 2023 101-4211-14-0000 AD OFFICE SUPPLIES 365 428 1,409 1,427 1,650 1,600 1,750 6.06% 2023 PROJECTED RUN RATE 101-4221-14-0000 AD SUPPLIES- EQUIPMENT - 899 108 - 160 160 160 0.00% 2022 PROJECTED RUN RATE 101-4226-14-0000 AD POSTAGE - 137 346 500 375 375 - -100.00% PART OF ELECTION CONTRACT 101-4309-14-0000 AD CONTRACTED SERVICES 19,713 20,700 20,700 28,980 28,980 28,980 28,980 0.00% RAMSEY CO. ELECTIONS CONTRACT NO INCREASE 2023 101-4315-14-0000 AD MISC CONTRACTED SERVICES - 10,282 46,285 40,232 48,628 8,426 6,200 -87.25% PT COMM. STAFF IN WAGES/ ADDED ANNUAL COST OF POCO SURVEY SFTWR 101-4339-14-0000 AD REPAIR & MAINTENANCE - 1,248 2,317 2,447 3,750 3,874 4,068 8.47% COUNTIES MAINTENANCE CHARGES INCREASING/ absentee ballot costs 101-4341-14-0000 AD TRAINING, CONF. & MTG.816 174 1,701 379 900 450 1,000 11.11% ELECTION/CLERK/ COMMUNICATIONS TRAINING 101-4342-14-0000 AD MEMBERSHIPS & DUES - 85 131 - 150 150 155 3.00% CLERKS ASSOCIATION 101-4351-14-0000 AD NOTICES & PUBLICATIONS - 160 - - 160 650 750 368.75% COMMUNICATIONS SUBSCRIPTIONS/ ANNUAL REPORTS PRINTING 101-4435-14-0000 AD CLEAN-UP DAY COSTS - - - - 8,025 6,660 7,660 -4.55% CLOSED RECYCLING FUND AND MOVED COSTS HERE 101-4499-14-0000 AD MISCELLANEOUS - - 448 90 160 100 150 -6.25% PLACEHOLDER TOTAL 20,893$ 34,113$ 125,440$ 123,034$ 155,556$ 113,301$ 146,489$ -5.83% FINANCIAL SERVICES 101-4110-15-0000 FS REGULAR EMPLOYEE 190,903$ 194,309$ 118,308$ 129,103$ 127,360$ 161,062$ 189,816$ 49.04% INCLUDES ESTIMATED WAGE ADJUSTMENTS / PT TO FT STAFF T. SAX 101-4112-15-0000 FS PART-TIME EMPLOYEE - - - - 23,031 - - -100.00% PT STAFF CONVERTED TO FT UNDER REGULAR EMPLOYEE 101-4111-15-0000 FS OVERTIME 8,131 8,912 7,778 9,141 4,905 4,905 5,052 3.00% INFLATE 2022 BUDGET 3 PERC 101-4121-15-0000 FS PERA 14,775 15,409 9,276 9,796 9,920 12,080 14,615 47.33% BASED ON CURRENT PERA FUNDING RATE 101-4122-15-0000 FS FICA/MEDICARE 14,440 13,473 7,011 7,527 11,880 12,321 14,907 25.48% BASED ON ER 7.65% OF GROSS 101-4131-15-0000 FS INSURANCE HEALTH 21,133 22,174 24,083 22,626 20,956 23,946 26,358 25.78% SPLIT 10.85% PREMUIM INCREASE 2023 101-4135-15-0000 FS INSURANCE WC 1,290 1,947 1,739 1,137 1,085 1,114 1,171 7.93% BASED ON 2022/2023 RENEWAL 101-4133-15-0000 FS LIFE INSURANCE 787 951 851 1,106 859 3,007 3,067 257.06% 2023 PROJECTED RUNRATE - NEW CONTRACT 2022 ($3.63 BASIC LIFE, $0.63 ADD) 101-4211-15-0000 FS OFFICE SUPPLIES 5,163 5,500 5,479 5,868 6,251 5,650 6,102 -2.38% 2023 PROJECTED RUNRATE 101-4221-15-0000 FS SUPPLIES - EQUIP - 219 468 1,096 1,000 600 1,000 0.00% MINOR EQUIPMENT NEW & REPLACEMENT 101-4226-15-0000 FS GENERAL SUPPLIES 2,686 3,077 2,760 1,987 2,009 2,215 2,326 15.80% 2023 PROJECTED RUNRATE 101-4300-15-0000 FS PROFESSIONAL SERVICES 16,655 18,080 15,513 15,598 15,975 16,990 16,537 3.52% AUDIT -2022 INCLUDES 1K FOR ELHERS FMP 101-4309-15-0000 FS CONTRACTED IT & SW SUPPORT 3,850 3,902 6,275 5,166 5,760 4,500 5,950 3.30% BASED ON CONTRACTED IT /SW SPREADSHEET 101-4310-15-0000 FS MISC CONTRACTED SERVICES 6,510 5,434 5,411 5,817 6,316 5,750 6,200 -1.84% BASED ON MISC CONTRACTED SERVICES SPREADSHEET 101-4315-15-0000 FS HC ASSESSOR SERVICES - - - 567 510 510 540 5.88% HC TNT MAILING 101-4325-15-0000 FS COMMUNICATIONS 962 1,379 1,125 595 950 705 750 -21.05% BASED ON COMMUNICATION SPREADSHEET 101-4339-15-0000 FS REPAIR & MAINTENANCE - - 155 76 150 100 150 0.00% CURRENT RUN RATE 9 Fiscal Year 2023 12/31/2020 ACTUAL 2018 ACTUAL 2019 ACTUAL 2020 ACTUAL 2021 BUDGET 2022 EST. ACTUAL 2022 BUDGET 2023 GENERAL FUND EXPENDITURES DETAIL 101-4341-15-0000 FS TRAINING, CONF. & MTG.1,669 1,004 404 394 1,250 1,750 2,500 100.00% INCLUDES TUITION REIMBURSEMENT PLACEHOLDER 101-4342-15-0000 FS MEMBERSHIPS & DUES 95 105 145 105 150 150 155 3.00% 2023 PROJECTED RUNRATE 101-4350-15-0000 FS PRINTED FORMS & ENVELOPES 1,077 1,879 1,973 950 1,750 1,250 1,600 -8.57% 2023 PROJECTED RUNRATE 101-4351-15-0000 FS NOTICES & PUBLICATIONS 781 1,776 2,727 3,324 3,200 3,100 3,300 3.13% 2023 PROJECTED RUN RATE -REDEVELOPMENT IMPACT 101-4365-15-0000 FS INSURANCE PROPERTY / LIABILITY 74,109 81,212 88,842 80,968 74,920 74,920 80,055 6.85% BASED ON 2022/2023 RENEWAL 101-4498-15-0000 FS REIMBURSED COSTS ADVANCED 6,280 6,144 6,381 15,112 6,563 6,563 5,940 -9.49% MWMO/NINENORTH ADP COST CIVIC/ADP,ADDED NN TO ADP 2022 101-4499-15-0000 FS MISCELLANEOUS 8 608 61 35 300 150 150 -50.00% ADJUSTED TO ESTIMATED RUN RATE TOTAL 371,306$ 387,492$ 306,765$ 318,094$ 327,049$ 343,337$ 388,241$ 18.71% LEGAL 101-4312-16-0000 AT GENERAL LEGAL 16,786 15,812 26,768$ 58,099 50,000 38,080 50,000 0.00% 2023 PROJECTED RUNRATE 101-4313-16-0000 AT CIVIL LITIGATION 16,583 34,386 10,952 - 50,250 15,980 50,000 -0.50% 2023 BUDGET INCLUDES POTENTIAL REDACTION COSTS 101-4314-16-0000 AT PROSECUTION RETAINER 42,000 42,000 42,000 42,000 42,000 42,000 42,000 0.00% 2023 PROJECTED RUNRATE TOTAL 75,369$ 92,198$ 79,720$ 100,099$ 142,250$ 96,060$ 142,000$ -0.18% ASSESSING 101-4110-17-0000 ASR REGULAR EMPLOYEE 2,890$ 3,013$ 3,324$ 3,378$ 3,489$ 3,475$ 3,594$ 3.01% INCLUDES ESTIMATED WAGE ADJUSTMENTS 101-4111-17-0000 ASR OVERTIME EMPLOYEE 295 277 136 230 430 250 430 0.00% KEPT FLAT 101-4121-17-0000 ASR PERA 237 246 258 270 294 294 302 2.68% BASED ON CURRENT PERA FUNDING RATE 101-4122-17-0000 ASR FICA/MEDICARE 244 252 266 277 300 300 308 2.68% BASED ON ER 7.65% OF GROSS 101-4131-17-0000 ASR INSURANCE HEALTH 503 531 564 604 590 590 647 9.66% SPLIT 10.85% PREMUIM INCREASE 2023 101-4226-17-0000 ASR GENERAL SUPPLIES 116 166 84 56 125 125 125 0.00% 2023 PROJECTED RUNRATE 101-4311-17-0000 ASR HC ASSESSOR SERVICES 61,000 64,000 69,000 71,000 74,550 74,550 79,000 5.97% 2023 PROJECTED RUNRATE 101-4350-17-0000 ASR PRINTED FORMS & ENVELOPES - - - - 160 75 75 -53.13% PLACEHOLDER TOTAL 65,285$ 68,483$ 73,631$ 75,814$ 79,937$ 79,659$ 84,480$ 5.68% CITY BUILDINGS 101-4310-18-0000 CB MISC CONTRACTED SERVICES 54,760 56,825 54,223$ 59,468 58,035 61,211 63,047 8.64% City contracted cleaning services / refuse / rugs 101-4325-18-0000 CB COMMUNICATIONS 5,762 5,624 5,688 4,951 6,320 4,500 4,770 -24.53% 2023 PROJECTED RUNRATE 101-4340-18-0000 CB REPAIRS AND MAINTENANCE 17,414 23,118 32,253 23,392 29,000 22,800 29,000 0.00% 2023 PROJECTED RUNRATE 101-4381-18-0000 CB ELECTRIC AND GAS UTILITIES 33,505 40,571 32,270 34,405 43,750 42,500 45,050 2.97% 2023 INFLATE 2022 ACTUALS BY 6 PERC 101-4920-18-0000 CB TRANSFER CH RENT 90,185 94,694 96,588 100,451 105,474 105,474 120,000 13.77% Increase in rent transfer - funds CC / CH Facility expenses TOTAL 201,625$ 220,831$ 221,022$ 222,667$ 242,579$ 236,485$ 261,867$ 7.95% CABLE FRANCHISE 101-4110-19-0000 CF REGULAR EMPLOYEE 7,259$ 7,999$ 8,307$ 9,002$ 9,306$ 9,377$ 9,822$ 5.54% INCLUDES ESTIMATED WAGE ADJUSTMENTS 101-4121-19-0000 CF PERA 544 600 623 649 698 703 737 5.54% BASED ON CURRENT PERA FUNDING RATE 101-4122-19-0000 CF FICA/MEDICARE 555 612 636 689 712 717 751 5.54% BASED ON ER 7.65% OF GROSS 101-4131-19-0000 CF INSURANCE HEALTH 1,723 1,793 1,869 1,972 378 378 384 1.59% SPLIT 10.85% PREMUIM INCREASE 2023 101-4211-19-0000 CF OPERATING SUPPLIES - 20 - - 408 408 200 -50.98% 2023 PROJECTED RUNRATE 101-4221-19-0000 CF SUPPLIES- EQUIPMENT - 32 44 - 1,000 1,000 500 -50.00% 2023 PROJECTED RUNRATE 101-4307-19-0000 CF NSCC OPERATING SUPPORT 30,529 29,777 31,881 36,618 36,648 37,000 42,850 16.92% 2023 PROJECTED RUNRATE 101-4310-19-0000 CF MISC CONTRACTED SERVICES 6,961 3,403 3,573 3,752 3,940 3,940 4,140 5.08% 2023 MISC CONTRACTED SPREADSHEET WEBSITE COST 101-4341-19-0000 CF TRAINING, CONF & MTG - - - - - - - 0.00% TOTAL 47,572$ 44,237$ 46,934$ 52,682$ 53,089$ 53,523$ 59,384$ 11.86% 10 Fiscal Year 2023 12/31/2020 ACTUAL 2018 ACTUAL 2019 ACTUAL 2020 ACTUAL 2021 BUDGET 2022 EST. ACTUAL 2022 BUDGET 2023 GENERAL FUND EXPENDITURES DETAIL POLICE PROTECTION 101-4110-21-0000 PD REGULAR EMPLOYEE $ 1,934,184 1,976,883$ 2,079,493$ 2,145,502$ 2,246,409$ 2,186,900$ 2,356,694$ 4.91%INCLUDES ESTIMATED 2023 WAGE ADJUSTMENTS AND UNIFORM COSTS 101-4110-21-0300 PD NEW OFFICER TRAINING PERIOD-WAGES 44,250$ NA INCLUDES ESTIMATED 3.5 MONTH TRAINING FOR TWO NEW OFFICERS/RETIREMENTS 101-4110-21-0100 PD MECHANIC ALLOC-WAGES 17,894 18,476 17,677 19,333 21,707 21,707 22,981 5.87% INCLUDES ESTIMATED 2023 WAGE ADJUSTMENT 101-4110-21-0200 PD DARE -WAGES 7,947 8,215 8,648 8,697 - - - 0.00% DARE PROGRAM DISCONTINUED BY SCHOOL DISTRICT 101-4111-21-0000 PD OVERTIME EMPLOYEE 105,139 98,673 120,029 110,920 114,975 218,705 118,424 3.00% 2022 HIGH OT, STAFF RETIREMENTS/MILTARY LEAVE/VARIOUS MEDICAL LEAVES 101-4111-21-0100 PD MECHANIC OVERTIME EMPLOYEE 71 159 21 28 250 250 250 0.00% INCLUDES ESTIMATED 2023 WAGE ADJUSTMENT 101-4111-21-0200 PD DARE - OT 371 538 582 609 - - - 0.00% DARE PROGRAM DISCONTINUED BY SCHOOL DISTRICT 101-4111-21-0300 PD SAFE & SOBER - OT 31,805 37,916 45,057 30,423 39,504 28,943 28,350 -28.24% PASS THROUGH COSTS NO NET LEVY IMPACT 101-4111-21-0400 PD COURT OVERTIME 3,927 4,316 2,595 1,712 3,780 2,250 2,500 -33.86% Based on estimated run rate 101-4111-21-0500 PD OTHER REIMB OT 15,379 - - - - - - 0.00% NATIONAL EVENTS, I.E. SUPER BOWL 101-4121-21-0000 PD PERA 322,711 340,375 379,882 385,574 409,388 412,124 428,152 4.58% BASED ON CURRENT PERA FUNDING RATE 101-4121-21-0100 PD MECHANIC ALLOC- PERA 1,423 1,474 1,511 1,544 1,647 1,647 1,742 5.80% BASED ON CURRENT PERA FUNDING RATE 101-4121-21-0200 PD DARE ALLOC- PERA 1,487 1,621 1,739 1,777 - - - 0.00% BASED ON CURRENT PERA FUNDING RATE 101-4122-21-0000 PD FICA/MEDICARE 37,432 38,224 40,816 40,916 45,669 46,310 47,890 4.86% DEPT SUMMARIES FICA 101-4122-21-0100 PD MECHANIC ALLOC-SS/MEDICARE 1,383 1,430 1,466 1,496 1,661 1,661 1,758 5.87% BASED ON ER 7.65% OF GROSS 101-4122-21-0200 PD DARE ALLOC-SS/MEDICARE 123 128 134 135 - - - 0.00% DARE PROGRAM DISCONTINUED BY SCHOOL DISTRICT 101-4131-21-0000 PD INSURANCE HEALTH 308,057 318,684 336,157 349,836 334,458 323,400 363,423 8.66% SPLIT 10.85% PREMUIM INCREASE 2023/STAFF TURNOVER EST ELECTIONS 101-4131-21-0100 PD MECHANIC ALLOC-HLTH INS 840 958 1,525 1,025 1,058 1,058 1,075 1.61% SPLIT 10.85% PREMUIM INCREASE 2023 101-4131-21-0200 PD HEALTH - DARE 1,450 1,506 1,567 1,650 - - - 0.00% DARE PROGRAM DISCONTINUED BY SCHOOL DISTRICT 101-4135-21-0000 PD WORKER'S COMP INS 71,027 83,558 91,376 103,259 131,572 131,572 157,923 20.03% BASED ON 2022/2023 RENEWAL 101-4212-21-0100 PD MOTOR FUELS 47,154 36,821 39,687 39,362 49,600 50,570 67,296 35.68% 2022 contracted cost per gal $2.94 / 2023 projection $3.82 / 2% increase gallons used 101-4220-21-0000 PD SQUADS CLEANING 1,399 1,336 1,285 2,205 2,353 2,500 2,750 16.87% 2023 PROJECTED RUNRATE 101-4221-21-0000 PD SUPPLIES- EQUIPMENT 537 3,959 1,039 101 1,500 1,500 1,500 0.00% 2023 PROJECTED RUNRATE 101-4221-21-0100 PD VEHICLE REPAIRS/PARTS 11,045 16,144 13,653 13,513 16,800 15,645 16,897 0.58% 2023 PROJECTED RUNRATE 101-4226-21-0000 PD GENERAL SUPPLIES 19,439 17,894 16,560 18,084 22,500 24,509 23,625 5.00% INFLATE 2022 BUDGET 5 PERC / 22 ACT NEW EE COSTS 101-4226-21-0100 PD SHOP SUPPLIES 100 536 485 847 550 550 600 9.09% 2023 PROJECTED RUNRATE 101-4226-21-0200 PD DARE SUPPLIES 1,981 2,595 - - - - - 0.00% DARE PROGRAM RETIRED 101-4226-21-0400 PD CITIZENS ACADEMY- SUPPLIES - - - 297 - - - 0.00% 101-4226-21-0500 PD VEST GRANT SUPPLIES 2,212 4,073 2,404 8,440 4,500 4,075 4,635 3.00% Supported by grant revenues 101-4308-21-0000 AC ANIMAL CONTROL CONTRACT - - - - - - - 0.00% Included with miscellaneous contracted services 101-4309-21-0000 PD CONTRACTED IT & SFTW SUPPORT 69,210 87,643 93,147 99,107 102,500 101,750 122,570 19.58% BASED ON CONTRACTED IT SPREADSHEET 101-4310-21-0000 PD MISC CONTRACTED SERVICES 5,008 10,814 16,827 14,656 17,305 17,440 19,982 15.47% BASED ON MISC. CONTRACTED SERVICES SPREADSHEET 101-4325-21-0000 PD COMMUNICATIONS 55,454 61,645 59,186 63,118 69,000 68,115 72,700 5.36% BASED ON COMMUNICATION SPREADSHEET 101-4333-21-0000 PD HC PRISONER SERVICES 5,766 7,233 7,540 9,845 9,250 4,500 7,500 -18.92% 2023 PROJECTED RUN RATE, 2021 high due to one longer stay for repeat offender 101-4335-21-0000 PD INSURANCE CLAIMS 5,044 8,338 - - - - 0.00% N/A 101-4341-21-0000 PD TRAINING, CONF. & MTG.27,738 22,353 7,488 18,140 25,500 23,710 26,265 3.00% 2023 PROJECTED RUNRATE 101-4342-21-0000 PD MEMBERSHIPS & DUES 1,954 5,606 4,741 4,027 5,600 5,743 5,973 6.66% 2023 PROJECTED RUNRATE 101-4350-21-0000 PD PRINTED FORMS & ENVELOPES 769 1,442 - 1,241 1,075 1,170 1,250 16.28% 2023 PROJECTED RUNRATE 101-4365-21-0000 PD INSURANCE PC / LIABILITY 51,065 54,753 60,360 64,946 70,585 70,585 58,855 -16.62% BASED ON 2022/2023 RENEWAL 101-4345-21-0000 PD MISC GRANTS / REIMB INS PREMUMS 1,756 - 924 147 500 20,859 21,110 4122.00% 2023 PROJECTED RUNRATE-INCLUDES HI INS. DISABLED OFFICER 101-4499-21-0000 PD MISCELLANEOUS 49 - 27 1,000 250 250 250 0.00% PLACEHOLDER -2021 body camera audit TOTAL 3,170,332$ 3,276,319$ 3,455,625$ 3,563,513$ 3,751,445$ 3,789,998$ 4,029,170$ 7.40% 11 Fiscal Year 2023 12/31/2020 ACTUAL 2018 ACTUAL 2019 ACTUAL 2020 ACTUAL 2021 BUDGET 2022 EST. ACTUAL 2022 BUDGET 2023 GENERAL FUND EXPENDITURES DETAIL FIRE PROTECTION 101-4110-22-0000 FD REGULAR EMPLOYEE 519,281$ 521,497$ 540,180$ 548,941$ 555,527$ 547,500$ 575,943$ 3.68% INCLUDES ESTIMATED WAGE ADJUSTMENT 101-4110-22-0400 FD REGULAR EMPLOYEE- SAFER GRANT 59,639 59,639 249,845 318.93% 2 SAFER POSITIONS STARTING 10/1/22 IF GRANT SECURED 101-4110-22-0300 PD NEW FF TRAINING PERIOD-WAGES 6,436 6,629 0.00% 5 WEEKS TRAINING FOR NEW FF 101-4110-22-0100 FD MECHANIC ALLOC- WAGES 10,225 10,558 10,101 11,048 12,404 12,404 13,132 5.87% 16% of mechanic wages/uniform 101-4111-22-0000 FD OVERTIME EMPLOYEE 43,950 35,486 35,838 48,855 44,600 48,695 52,200 17.04% 101-4111-22-0100 FD OT - UNION CONTRACT 35,918 36,303 37,539 37,956 40,147 40,147 46,081 14.78% FROM DEPT SUMMARIES OT 101-4112-22-0000 FD PART-TIME EMPLOYEE 83,155 82,977 77,157 76,501 72,000 72,500 75,400 4.72% 2023 PROJECTED RUNRATE 101-4112-22-0100 FD CODE ENFORCEMENT 4,883 5,509 12,973 20,570 22,403 21,805 22,459 0.25% 2023 PROJECTED RUNRATE 101-4121-22-0000 FD PERA 97,699 100,475 109,616 113,668 113,329 113,772 120,069 5.95% BASED ON CURRENT PERA FUNDING RATE 101-4121-22-0100 FD MECHANIC ALLOC- PERA 813 842 863 882 930 930 985 5.87% BASED ON ER 7.65% OF GROSS 101-4122-22-0000 FD FICA/MEDICARE 15,585 14,325 14,936 16,116 16,697 16,400 14,455 -13.42% See dept. summary-PR, Medicare on FD OT union plus fica for VT off 101-4122-22-0100 FD MECHANIC FICA/MEDICARE 791 817 837 855 949 949 1,005 5.87% BASED ON ER 7.65% OF GROSS 101-4123-22-0000 FD CITY CONTR- FIRE RELIEF 6,000 6,000 6,000 6,000 6,000 6,000 6,000 0.00% Kept same 101-4124-22-0000 FD CONTR. STATE AID FIRE RELIEF 52,743 54,716 - - - - - 0.00% FIRE RELIEF WENT TO STATE PLAN IN 2020 101-4131-22-0000 FD INSURANCE HEALTH 92,441 87,755 91,788 106,457 98,074 88,638 95,230 -2.90% SPLIT 10.85% PREMUIM INCREASE 2023/STAFF TURNOVER EST ELECTIONS 101-4131-22-0100 FD MECHANIC ALLOC- HLTH INS 480 547 872 586 605 605 614 1.49% SPLIT 10.85% PREMUIM INCREASE 2023 101-4135-22-0000 FD INSURANCE WC 33,916 36,035 36,688 34,437 43,167 39,645 47,599 10.27% BASED ON 2022/2023 RENEWAL and 23/24 LMC rate information 101-4140-22-0000 FD UNIFORM EXPENSES 8,155 8,445 8,236 4,090 9,250 8,200 9,250 0.00% ADJUSTED TO ESTIMATED RUN RATE 101-4212-22-0100 FD MOTOR FUELS 6,214 5,240 5,113 5,612 6,600 7,605 10,253 55.35% 2022 contracted cost per gal $2.94 / 2023 projection $3.82 / 2% increase gallons used 101-4221-22-0000 FD SUPPLIES- EQUIPMENT 3,484 1,411 2,195 2,634 3,000 3,000 3,200 6.67% 2023 PROJECTED RUNRATE 101-4221-22-0100 FD VEHICLE REPAIRS/PARTS 13,486 4,746 21,130 19,190 21,000 27,190 22,050 5.00% 2023 PROJECTED RUNRATE 101-4225-22-0000 FD FIRE PREVENTION SUPPLIES 1,373 1,530 1,657 1,555 2,000 2,000 2,100 5.00% 2023 PROJECTED RUNRATE 101-4226-22-0000 FD GENERAL SUPPLIES 4,670 3,558 2,954 6,985 6,038 5,400 6,100 1.04% 2023 PROJECTED RUNRATE 101-4226-22-0100 FD SHOP SUPPLIES 349 1,803 428 481 1,350 750 1,000 -25.93% 2023 PROJECTED RUNRATE 101-4227-22-0000 FD MEDICAL SUPPLIES 5,184 4,958 3,743 9,315 7,938 7,938 8,176 3.00% 2023 PROJECTED RUNRATE 101-4309-22-0000 FD CONTRACTED IT & SFTW SUPPORT 27,163 31,789 34,418 36,230 39,450 39,450 47,430 20.23% BASED ON CONTRACTED IT /SW SPREADSHEET 101-4310-22-0000 FD MISC CONTRACTED SERVICES 3,063 2,221 3,070 7,352 11,330 11,330 11,670 3.00% 2023 PROJECTED RUNRATE 101-4325-22-0000 FD COMMUNICATIONS 15,686 17,213 18,510 27,946 29,120 28,350 29,970 2.92% BASED ON COMM SPREADSHEET/RADIO BUDGET 101-4339-22-0000 FD EQUIP REPAIRS & MAINTENANCE 196 685 4,736 4,290 3,850 3,850 3,966 3.00% 2023 PROJECTED RUNRATE 101-4340-22-0000 FD BLDG REPAIRS & MAINTENANCE 936 617 - - - - 0.00% 2023 PROJECTED RUNRATE 101-4341-22-0000 FD TRAINING, CONF. & MTG.13,753 10,942 24,314 19,550 17,500 23,500 24,000 37.14% 2023 PROJECTED RUNRATE 101-4342-22-0000 FD MEMBERSHIPS & DUES 917 1,125 1,595 1,764 1,650 1,650 1,700 3.00% 2023 PROJECTED RUNRATE 101-4345-22-0000 FD GRANT REIMB/EXPENDITURES 2,780 403 3,300 - 510 - 510 0.00% 2023 PROJECTED RUNRATE TOTAL 1,105,292$ 1,090,527$ 1,110,789$ 1,169,864$ 1,247,056$ 1,246,278$ 1,509,020$ 21.01% 12 Fiscal Year 2023 12/31/2020 ACTUAL 2018 ACTUAL 2019 ACTUAL 2020 ACTUAL 2021 BUDGET 2022 EST. ACTUAL 2022 BUDGET 2023 GENERAL FUND EXPENDITURES DETAIL PROTECTIVE INSPECTIONS 101-4110-24-0000 PI REGULAR EMPLOYEE 10,943$ 11,761$ 10,818$ 5,383$ 10,960$ 10,960$ 11,613$ 5.96% INCLUDES ESTIMATED WAGE ADJUSTMENTS 101-4121-24-0000 PI PERA 817 850 781 522 822 822 871 5.96% BASED ON CURRENT PERA FUNDING RATE 101-4122-24-0000 PI FICA/MEDICARE 837 900 845 597 838 838 888 5.96% BASED ON ER .0765 OF GROSS 101-4131-24-0000 PI INSURANCE HEALTH 1,150 1,234 1,336 1,122 1,591 1,591 1,686 5.97% SPLIT 10.85% PREMUIM INCREASE 2023 101-4226-24-0000 PI GENERAL SUPPLIES - - 228 - - - - 0.00% 101-4320-24-0000 PI BUILDING OFFICAL CONTRACT 91,209 74,789 101,020 521,098 95,051 104,978 112,161 18.00% EXPENSE BASED ON SHARE OF REVENUES 101-4321-24-0000 PI ELECTRICAL INSPECTOR 17,819 17,134 18,366 49,795 13,835 13,835 14,665 6.00% EXPENSE BASED ON SHARE OF REVENUES 101-4350-24-0000 PI PRINTED FORMS & ENVELOPES 433 - 154 - 150 150 155 3.00% 2023 PROJECTED RUN RATE TOTAL 123,208$ 106,668$ 133,548$ 578,516$ 123,248$ 133,175$ 142,039$ 15.25% EMERGENCY MANAGEMENT 101-4110-25-0000 EMS REGULAR EMPLOYEE 53,409$ 55,548$ 59,033$ 61,209$ 63,283$ 61,120$ 65,819$ 4.01% INCLUDES ESTIMATED WAGE ADJUSTMENTS 101-4121-25-0000 EMS PERA 8,613 9,371 10,304 10,826 11,201 11,134 11,650 4.01% BASED ON CURRENT PERA FUNDING RATE 101-4122-25-0000 EMS FICA/MEDICARE 774 806 856 887 918 886 954 4.01% 1.45% FICA rate 101-4131-25-0000 EMS INSURANCE HEALTH 7,248 7,533 7,840 8,254 8,109 8,109 8,609 6.17% SPLIT 10.85% PREMUIM INCREASE 2023 101-4135-25-0000 EMS INSURANCE WC 3,741 4,123 4,042 4,555 4,755 4,755 5,249 10.39% BASED ON 2022/2023 RENEWAL and 23/24 LMC rate information 101-4221-25-0000 EMS SUPPLIES- EQUIPMENT 301 - 222 220 520 350 520 0.00% 2023 PROJECTED RUN RATE 101-4227-25-0000 EMS MEDICAL SUPPLIES 48 - - - 50 50 50 0.00% 2023 PROJECTED RUN RATE 101-4323-25-0000 EMS PAGERS, SIREN 1,289 1,233 1,272 1,275 1,476 1,300 1,365 -7.52% 2023 PROJECTED RUN RATE 101-4339-25-0000 EMS REPAIRS AND MAINTENANCE - 287 - - 750 750 773 3.00% 2023 PROJECTED RUN RATE 101-4341-25-0000 EMS TRAINING, CONF. & MTG.970 615 - 903 1,045 950 1,025 -1.91% 2023 PROJECTED RUN RATE 101-4350-25-0000 EMS PRINTED FORMS & ENVELOPES - - 68 - 75 75 75 0.00% 2023 PROJECTED RUN RATE TOTAL 76,393$ 79,515$ 83,637$ 88,129$ 92,182$ 89,479$ 96,089$ 4.24% PUBLIC WORKS 101-4110-31-0000 PW REGULAR EMPLOYEE 278,917$ 286,839$ 296,772$ 269,133$ 307,706$ 306,500$ 326,120$ 5.98% INCLUDES ESTIMATED WAGE ADJUSTMENTS 101-4110-31-0100 PW MECHANIC 36,837 37,966 36,354 39,933 42,811 42,141 45,772 6.92% INCLUDES ESTIMATED WAGE ADJUSTMENTS 101-4111-31-0000 PW OVERTIME EMPLOYEE 13,518 12,285 6,382 8,932 15,939 12,813 15,100 -5.26% INCLUDES ESTIMATED WAGE ADJUSTMENTS 101-4111-31-0100 PW OVERTIME MECHANIC 141 318 41 56 362 362 373 3.00% INFLATE 2022 BUDGET 3 PERC 101-4112-31-0000 PW PART-TIME EMPLOYEE 30,018 30,300 28,292 5,055 41,312 29,000 36,000 -12.86% 2023 PROJECTED RUN RATE 101-4121-31-0000 PW PERA 21,775 22,611 23,523 20,756 24,273 24,273 25,592 5.43% BASED ON CURRENT PERA FUNDING RATE 101-4121-31-0100 PW MECHANIC ALLOC- PERA 2,845 2,948 3,022 3,088 3,238 3,343 3,461 6.88% BASED ON CURRENT PERA FUNDING RATE 101-4122-31-0000 PW FICA 22,682 23,654 24,209 18,175 27,919 24,540 26,575 -4.81% BASED ON ER .0765 OF GROSS 101-4122-31-0100 PW MECHANIC ALLOC- FICA 3,028 3,157 3,243 3,318 3,303 2,966 3,530 6.88% BASED ON ER .0765 OF GROSS 101-4131-31-0000 PW INSURANCE HEALTH 60,325 60,641 69,346 67,073 72,064 64,982 70,839 -1.70% SPLIT 10.85% PREMUIM INCREASE 2023/STAFF ELECTIONS 101-4131-31-0100 PW MECHANIC ALLOC- HI 1,680 1,915 1,203 2,170 2,117 2,013 2,150 1.56% 56% Tucker 101-4135-31-0000 PW INSURANCE WC 13,436 13,198 14,354 16,239 18,085 15,690 15,248 -15.69% BASED ON 2022/2023 RENEWAL and 23/24 LMC rate information 101-4140-31-0000 PW UNIFORM EXPENSES 9,137 12,504 13,734 12,824 12,715 12,225 13,500 6.18% 2023 PROJECTED RUN RATE 101-4140-31-0100 PW UNIFORM EXPENSES - MECH 727 1,172 396 187 900 300 350 -61.10% 2023 PROJECTED RUN RATE 101-4212-31-0100 PW MOTOR FUELS MISC 1,080 3,460 1,790 571 1,550 1,000 1,250 -19.35% Other non-contracted motor oil and gas 13 Fiscal Year 2023 12/31/2020 ACTUAL 2018 ACTUAL 2019 ACTUAL 2020 ACTUAL 2021 BUDGET 2022 EST. ACTUAL 2022 BUDGET 2023 GENERAL FUND EXPENDITURES DETAIL 101-4212-31-0200 PW MOTOR FUELS NB 88,671 77,009 73,048 7,164 - - - 0.00% NEW BRIGHTON PW ADDED ON SITE RE-FUELING FEB 2021 101-4212-31-0300 PW FUEL - MWMO 1,488 1,164 1,373 1,676 1,765 2,125 2,845 61.19% 2022 contracted cost per gal $2.94 / 2023 projection $3.82 / 2% increase gallons used 101-4212-31-0400 PW FUEL - SANB #282 8,710 10,480 6,295 6,449 10,300 10,557 14,078 36.68% 2022 contracted cost per gal $2.94 / 2023 projection $3.82 / 2% increase gallons used 101-4212-31-0600 PW FUEL - STREET/PARKS 14,846 14,229 13,133 11,695 26,145 28,017 38,092 45.70% 2022 contracted cost per gal $2.94 / 2023 projection $3.82 / 2% increase gallons used 101-4221-31-0100 PW VEHICLE REPAIRS/PARTS 16,540 13,556 11,523 14,520 15,003 19,520 17,500 16.65% 2023 PROJECTED RUNRATE 101-4223-31-0000 PW SMALL TOOLS MECHANIC 750 70 - 375 600 600 600 0.00% KEPT FLAT 101-4223-31-0100 PW SMALL TOOLS 583 447 397 260 500 500 500 0.00% KEPT FLAT 101-4224-31-0000 PW STREET SIGNS 464 2,763 2,758 785 2,550 1,550 2,550 0.00% KEPT FLAT 101-4226-31-0000 PW GENERAL SUPPLIES 10,838 6,879 10,833 8,805 9,625 10,920 11,575 20.26% 2023 PROJECTED RUNRATE 101-4226-31-0100 PW SHOP SUPPLIES 1,499 562 2,622 1,331 2,753 2,753 2,050 -25.53% 2023 PROJECTED RUNRATE 101-4228-31-0000 PW STREET REPAIR & MAINTENANCE 16,621 91,192 19,956 25,857 26,500 28,500 29,000 9.43% 2023 PROJECTED RUNRATE 101-4229-31-0000 PW STREET CHEMICALS & SAND 31,281 32,630 23,415 18,913 24,451 19,581 21,376 -12.58% 2023 - 250 tons of salt 101-4230-31-0000 PW STORMWATER MAINTENANCE 5,817 7,247 720 - - - - 0.00% Moved to Stormwater utility fund 101-4303-31-0000 PW CONTRACTED ENGINEER 33,093 45,932 27,986 27,623 32,500 39,377 42,500 30.77% 2022-23 HIGHER ACTIVITY & INFLATION IMPACT ON RATES 101-4309-31-0000 PW CONTRACTED IT & SFTW SUPPORT 13,155 13,566 12,724 12,242 13,000 13,000 14,870 14.38% BASED ON CONTRACTED IT /SW SPREADSHEET 101-4310-31-0000 PW MISC. CONTRACTED SERVICES 43,978 24,399 35,856 36,376 36,100 36,100 17,000 -52.91% SALO PARK CAM AND VARIOUS RELATED COSTS 101-4325-31-0000 PW COMMUNICATIONS 2,918 3,425 448 4,583 4,337 5,675 5,925 36.62% BASED ON COMMUNICATION SPREADSHEET, CENTURYLINK 2022 FOR PW 101-4339-31-0000 PW EQUIP REPAIRS & MAINTENANCE 6,452 8,701 6,383 5,630 7,500 9,250 8,150 8.67% 2023 PROJECTED RUNRATE 101-4340-31-0000 PW BLDG REPAIRS & MAINTENANCE 380 2,882 - 255 - - - 0.00% now included in city buiding repairs 101-4341-31-0000 PW TRAINING, CONF. & MTG.3,499 6,835 731 1,886 4,250 3,650 4,250 0.00% 2023 PROJECTED RUNRATE 101-4342-31-0000 PW MEMBERSHIPS & DUES 1,143 1,428 1,166 879 1,273 1,273 1,312 3.00% 2023 PROJECTED RUNRATE 101-4344-31-0000 PW TRAINING CERT PROGRAMS 46 123 23 450 600 600 618 3.00% 2023 PROJECTED RUNRATE 101-4345-31-0000 PW GRANT REIMB EXPENDITURES 14,338 2,832 - 5,000 5,000 15,000 5,000 0.00% grant exps for opportunity grants projected in revenue section 101-4381-31-0000 PW STREETLIGHTS & SIGNALS 65,516 61,512 60,087 68,549 73,038 74,050 78,493 7.47% 2023 PROJECTED RUNRATE 101-4435-31-0000 PW STORM CLEAN-UP COSTS 500 - 3,450 2,150 - - - 0.00% 101-4499-31-0000 PW MISCELLANEOUS - 44 60 738 160 160 165 3.00% TOTAL 879,273$ 942,872$ 837,648$ 731,698$ 872,244$ 864,907$ 904,308$ 3.68% PARKS 101-4110-51-0000 PR REGULAR EMPLOYEE 109,030$ 112,855$ 105,447$ 110,163$ 119,450$ 123,781$ 131,583$ 10.16% INCLUDES ESTIMATED WAGE ADJUSTMENTS 101-4110-51-0100 TW REGULAR EMPLOYEE 29,007 29,970 29,401 31,510 32,373 32,575 34,854 7.66% INCLUDES ESTIMATED WAGE ADJUSTMENTS 101-4110-51-0200 PR COMMITTEE 180 200 600 330 600 600 600 0.00% Parks commission all opt-in for pay 101-4111-51-0000 PR OVERTIME EMPLOYEE 1,827 2,216 1,654 2,163 2,588 2,325 2,600 0.48% BASED ON EE MAPPING 101-4111-51-0100 TW OVERTIME EMPLOYEE 1,048 1,176 575 1,013 1,035 1,200 1,250 20.77% BASED ON EE MAPPING 101-4121-51-0000 PR PERA 8,606 8,807 8,630 8,162 9,153 9,458 10,064 9.95% BASED ON CURRENT PERA FUNDING RATE 101-4121-51-0100 TW PERA 2,343 2,424 2,445 2,533 2,506 2,533 2,708 8.07% BASED ON CURRENT PERA FUNDING RATE 101-4122-51-0000 PR FICA/MEDICARE 8,767 9,003 8,667 9,409 9,382 9,693 10,311 9.90% BASED ON ER 7.65% OF GROSS 101-4122-51-0100 TW FICA/MEDICARE 2,357 2,459 2,486 2,588 2,556 2,584 2,762 8.07% BASED ON ER 7.65% OF GROSS 101-4131-51-0000 PR INSURANCE HEALTH 21,306 22,380 23,441 21,865 28,369 28,369 28,036 -1.17% SPLIT 10.85% PREMUIM INCREASE 2023/CURRENT ELECTIONS 101-4131-51-0100 TW INSURANCE HEALTH 5,004 5,277 5,615 6,011 5,873 5,873 6,444 9.72% SPLIT 10.85% PREMUIM INCREASE 2023 101-4135-51-0000 PR INSURANCE WC 3,286 3,641 4,255 4,482 5,524 5,524 6,315 14.32% BASED ON 2022/2023 RENEWAL and 23/24 LMC rate information 14 Fiscal Year 2023 12/31/2020 ACTUAL 2018 ACTUAL 2019 ACTUAL 2020 ACTUAL 2021 BUDGET 2022 EST. ACTUAL 2022 BUDGET 2023 GENERAL FUND EXPENDITURES DETAIL 101-4135-51-0100 TW INSURANCE WC 2,191 2,455 2,837 2,584 3,683 3,683 4,210 14.31% BASED ON 2022/2023 RENEWAL and 23/24 LMC rate information 101-4212-51-0000 PW FUEL - STREET/PARKS - 633 40 - - - - 0.00% PW FUELS USE CONSOLIDATED UNDER STREETS DEPT 101-4226-51-0000 PR GENERAL SUPPLIES 14,357 15,538 15,700 18,005 17,500 18,450 19,188 9.65% 2023 PROJECTED RUNRATE 101-4310-51-0100 TW MISC. CONTRACTED SERVICES - 190 - - - - - 0.00% coded to 4338 101-4325-51-0000 PR COMMUNICATIONS 1,622 1,522 1,693 1,820 1,834 3,647 4,400 139.91% BASED ON COMMUNICATION SPREADSHEET, CENTURYLINK 2022 FOR PARKS 101-4325-51-0100 TW COMMUNICATIONS 197 147 67 71 204 - - -100.00% BASED ON COMMUNICATION SPREADSHEET, ADDED TO PARKS 101-4337-51-0000 PR STRUCTURES REPAIRS & MAINT.12,365 6,682 1,356 5,650 15,650 9,500 10,250 -34.50% 2023 PROJECTED RUNRATE 101-4338-51-0100 TW TREE REPLACEMENT 583 3,796 2,778 2,174 4,000 3,000 3,500 -12.50% 2023 PROJECTED RUNRATE 101-4339-51-0000 PR EQUIP REPAIRS & MAINTENANCE 7,857 11,090 8,776 17,442 11,500 13,500 14,000 21.74% 2023 PROJECTED RUNRATE 101-4339-51-0100 TW EQUIP REPAIRS & MAINTENANCE - - 691 - 350 750 500 42.86% 2023 PROJECTED RUNRATE 101-4381-51-0000 PR ELECTRIC AND GAS UTILITIES 19,316 19,389 15,870 35,509 25,650 29,130 30,878 20.38% 2023 INFLATE 2022 ACTUALS BY 6 PERC 101-4415-51-0000 PR SS RENTALS 1,821 2,820 2,122 3,992 3,450 3,050 3,233 -6.29% 2023 INFLATE 2022 ACTUALS BY 6 PERC 101-4499-51-0000 PR MISCELLANEOUS - - - - 110 110 125 13.22% 2023 PROJECTED RUNRATE 101-4499-51-0100 TW MISCELLANEOUS 646 - - - 110 110 125 13.22% 2023 PROJECTED RUNRATE 101-4671-61-0000 CS ISD 282 REC PROGRAMS 52,176 52,176 52,176 52,176 52,176 52,176 52,176 0.00% Annual Fixed amount TOTAL 305,892$ 316,846$ 297,321$ 339,653$ 355,625$ 361,622$ 380,111$ 6.89% OTHER EXPENDITURES AND TRANSFERS 101-4335-70-0000 INSURANCE CLAIMS 14,384 8,710 14,606$ 9,350 15,000 15,000 15,000 0.00% 101-4343-70-0000 EQUITY INTITIATIVE 5,119 9,008 1,438 13,305 10,000 11,104 10,000 0.00% Established funding and specific tracking of initiative costs 101-4346-70-0000 COLLABORATIVE INTITIATIVE 1,055 11,573 2,464 6,375 10,000 10,000 10,000 0.00% Established funding and specific tracking of initiative costs 101-4347-70-0000 PROPERTY RESOURCE INTITIATIVE - 593 - - 10,000 10,000 7,500 -25.00% Established funding and specific tracking of initiative costs 101-4348-70-0000 SUSTAINABILITY INTITIATIVE 2,601 22,400 2,772 4,622 17,500 17,500 10,000 -42.86% Established funding and specific tracking of initiative costs 101-4499-70-0000 NB MISCELLANEOUS 6,298 25,947 7,195 - 20,000 17,900 - -100.00% 2022 COMMUNITY SURVEY 101-4499-23-0000 INCIDENT/DATA PROD/COVID-19 176,371 135,233 379,334 16,325 - - - 0.00% 2020 -2021 COVID 19 RELATED EXP 101-4920-70-0000 TRANSFER - SEVERENCE FUND 86,300 86,300 86,300 86,300 86,300 86,300 86,300 0.00% ANNUAL TRANSFER 101-4920-70-0000 TRANSFER - HRA PROJECTS FUND - - - - - - - 0.00% 101-4920-70-0000 TRANSFER - HRA FUND - - - - - - - 0.00% 101-4920-70-0000 TRANSFER - OTHER - - 2,500 367,845 - - - 0.00% 2020 RECYCLING FUND / EST. 2021 EXCESS FUND BAL TRANSFER TOTAL 292,128$ 299,764$ 496,609$ 504,122$ 168,800$ 167,804$ 138,800$ -17.77% TOTAL FUND EXPENDITURES 7,029,590$ 7,272,412$ 7,652,254$ 8,211,634$ 8,013,767$ 7,973,797$ 8,700,383$ 8.57% TOTAL FUND REVENUE 7,137,235$ 7,355,442$ 8,459,454$ 8,690,430$ 8,027,487$ 8,027,487$ 8,714,170$ 8.55% with 20k hi coverage CHANGE IN FUND BALANCE 107,646$ 83,030$ 807,201$ 478,796$ 13,720$ 53,691$ 13,787$ 0.49%9,901.00$ BEGINNING FUND BALANCE 2,400,114 2,507,759 2,590,790 3,397,990 3,876,786 3,876,786 3,930,477 1.38% ENDING FUND BALANCE 2,507,759$ 2,590,790$ 3,397,990$ 3,876,786$ 3,890,506$ 3,930,477$ 3,944,264$ 1.38% 15 CITY OF ST. ANTHONY VILLAGE LIQUOR OPERATION CASH POSITION 2015-2022 Maintain 25% gm 4% higher operating costs 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 stress test 2024 stress test Operating Income AUDITED AUDITED AUDITED AUDITED AUDITED AUDITED AUDITED AUDITED AUDITED AUDITED EST ACTUAL 4% drop in sales 2% drop in sales Sales 7,144,624 6,908,143 6,076,040 5,966,189 5,875,868 5,767,016 5,868,809 6,160,696 7,016,295 7,260,591 6,962,367 6,683,872 6,550,195 Less COGS & Expenses 6,529,345 6,336,052 5,730,651 5,644,614 5,550,374 5,496,104 5,541,231 5,816,037 6,570,870 6,740,185 6,534,488 6,428,310 6,384,668 Less Depreciation 85,500 81,695 76,566 75,658 68,064 68,064 68,782 71,110 70,859 72,085 72,085 72,085 72,085 Less Interest Expense 5,475 - - - - - - - - - - - - Plus Interest income - - - 4,014 5,973 4,495 7,275 20,757 13,127 (3,466) 2,250 2,250 2,250 Net Income Before Transfers 524,304 490,396 268,823 249,931 263,403 207,343 266,071 294,306 387,693 444,855 358,044 185,727 95,692 Adjustments to Operating Income Internal Loan Principal 36,500 73,000 - - - - - - - - - - - Bond Principal - - - - - - - - - - - - - Capital Purchases - - 7,125 - - - - - - (49,273) - - - Budgeted Capital Expenditures - - - - - - - - - - - - Change in Inventory / Payables 100,064 108,551 (116,811) 110,321 70,635 (13,706) 94,816 (189,358) 148,524 (88,651) (50,000) (50,000) (50,000) Funds Available for Transfer 387,740 308,845 378,509 139,610 192,768 221,049 171,255 483,664 239,169 582,779 408,044 235,727 145,692 Transfer to General Fund 305,800 330,800 214,244 67,849 156,396 156,396 250,000 250,000 250,000 250,000 275,000 275,000 275,000 Transfer to Capital Equipment 204,200 108,200 108,200 181,200 92,653 92,653 - - - - - - - Transfer to Building Improvement - - 73,000 - - - - - - - - - - Add Back Depreciation 85,500 81,695 76,566 75,658 68,064 68,064 68,782 71,110 70,859 72,085 72,085 72,085 72,085 Increase / (Decrease) in Cash (36,760) (48,460) 59,631 (33,781) 11,783 40,064 (9,963) 304,774 60,028 404,864 205,129 32,812 (57,223) Beginning Cash Balance 487,028 450,268 401,808 461,439 427,658 439,441 479,505 469,542 774,316 834,344 1,239,208 1,444,337 1,477,150 Ending Cash Balance 450,268 401,808 461,439 427,658 439,441 479,505 469,542 774,316 834,344 1,239,208 1,444,337 1,477,150 1,419,927 Cash Reserve Calculation Cash Floor 510,000 439,000 395,444 249,049 249,049 249,060 250,000 250,000 250,000 250,000 275,000 275,000 275,000 One Year of Transfers Cash Ceiling 949,000 834,444 790,888 498,098 498,098 498,098 825,000 825,000 825,000 825,000 875,000 875,000 875,000 Two Years of Transfers + 5yr CIP Cash Above / (Below) Floor (59,732) (37,192) 65,995 178,609 190,392 230,445 219,542 524,316 584,344 989,208 1,169,337 1,202,150 1,144,927 Cash Above / (Below) Ceiling (498,732) (432,636) (329,449) (70,440) (58,657) (18,593) (355,458) (50,684) 9,344 414,208 569,337 602,150 544,927 $0 $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 2016 2017 2018 2019 2020 2021 2022 2023 2024 Current Ceiling Floor C:\Users\shelly.rueckert\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\WRAU8P5Z\Council Summary LQ cash flow.xlsx 8/3/2022 16