Fiscal Year 2021ACTUAL 2016ACTUAL 2017ACTUAL2018ACTUAL2019BUDGET2020EST. ACTUAL2020BUDGET2021GENERAL FUND EXPENDITURES DETAIL101‐4339‐14‐0000 AD REPAIR & MAINTENANCE 1,267 3,397 ‐ 1,248 1,300 1,300 1,326 2.00% RAMSEY COUNTY CONTRACT 2019‐2020, 2021 RENEWAL NOT YET AVAILABLE101‐4341‐14‐0000 AD TRAINING, CONF. & MTG. 200 279 816 174 428 428 900 110.08% ELECTION/CLERK/ COMMUNICATIONS TRAINING101‐4342‐14‐0000 AD MEMBERSHIPS & DUES‐ ‐ ‐ 85 150 150 153 2.00% CLERKS ASSOCIATION101‐4351‐14‐0000 AD NOTICES & PUBLICATIONS‐ ‐ ‐ 160 150 150 153 2.00% COMMUNICATIONS SUBSCRIPTIONS101‐4499‐14‐0000 AD MISCELLANEOUS‐ ‐ ‐ ‐ 150 150 153 2.00% PLACEHOLDER TOTAL 22,114$ 23,740$ 20,893$ 34,113$ 123,402$ 108,991$ 130,313$ 5.60%FINANCIAL SERVICES101‐4110‐15‐0000 FS REGULAR EMPLOYEE166,690$ 174,095$ 190,903$ 194,309$ 114,857$ 118,806$ 123,648$ 7.65% INCLUDES ESTIMATED 2021 WAGE ADJUSTMENTS / STAFF TURNOVER FROM 2020101‐4111‐15‐0000 FS OVERTIME1,563 2,193 8,131 8,912 4,646 4,646 4,739 2.00% 2021 PROJECTED RUN RATE101‐4121‐15‐0000 FS PERA12,864 13,580 14,775 15,409 8,963 9,259 9,629 7.43% BASED ON CURRENT PERA FUNDING RATE 101‐4122‐15‐0000 FS FICA/MEDICARE10,625 11,530 14,440 13,473 9,142 9,444 9,822 7.43% BASED ON ER 7.65% OF GROSS101‐4131‐15‐0000 FS INSURANCE HEALTH21,562 20,969 21,133 22,174 20,456 23,810 22,565 10.31% SPLIT 9.4% PREMUIM INCREASE IN 2021 PLUS EAP FEES@100/mo101‐4135‐15‐0000 FS INSURANCE WC836 1,773 1,290 1,947 1,185 1,739 1,967 65.99% 2020/2021 RENEWAL101‐4133‐15‐0000 FS LIFE INSURANCE905 863 787 951 942 850 867 ‐7.93% 2021 PROJECTED RUN RATE101‐4211‐15‐0000 FS OFFICE SUPPLIES5,662 5,161 5,163 5,500 6,120 6,120 6,242 2.00% 2021 PROJECTED RUN RATE101‐4221‐15‐0000 FS SUPPLIES ‐ EQUIP853 679 ‐ 219 1,000 600 1,000 0.00% MINOR EQUIPMENT NEW & REPLACEMENT 101‐4226‐15‐0000 FS GENERAL SUPPLIES 2,176 1,876 2,686 3,077 2,500 2,500 2,900 16.00% ADJUST TO RUN RATE / ALLOCATION TO OTHER DEPTS ELIMINATED101‐4300‐15‐0000 FS PROFESSIONAL SERVICES 17,220 19,142 16,655 18,080 18,250 18,250 17,150 ‐6.03% AUDIT AND FD ACTUARY REPORT UPDATE IN 2019101‐4309‐15‐0000 FS CONTRACTED IT & SW SUPPORT3,088 3,962 3,850 3,902 6,200 4,800 5,810 ‐6.29% BASED ON CONTRACTED IT /SW SPREADSHEET CIVIC UPGRADE 2020/2021101‐4310‐15‐0000 FS MISC CONTRACTED SERVICES4,230 4,916 6,510 5,434 4,490 5,890 6,030 34.30% BASED ON MISC CONTRACTED SERVICES SPREADSHEET 101‐4315‐15‐0000 FS HC ASSESSOR SERVICES460 446 ‐ ‐ 500 500 510 2.00% HC TNT MAILING101‐4325‐15‐0000FS COMMUNICATIONS1,159 638 962 1,379 775 775 800 3.23% ADJ TO ESTIMATED RUN RATE‐COMMUNICATIONS SPREADSHEET101‐4339‐15‐0000 FS REPAIR & MAINTENANCE328 205 ‐ ‐ 173 173 177 2.00% CURRENT RUN RATE101‐4341‐15‐0000 FS TRAINING, CONF. & MTG.3,307 5,991 1,669 1,004 2,750 500 1,250 ‐54.55% INCLUDES LESS IN TUTION REIMBURSEMENT EXPECTED FOR 2021101‐4342‐15‐0000 FS MEMBERSHIPS & DUES 515 486 95 105 115 145 150 30.43% 2021 PROJECTED RUN RATE101‐4350‐15‐0000 FS PRINTED FORMS & ENVELOPES 1,381 1,172 1,077 1,879 1,500 2,004 1,750 16.67% 2021 PROJECTED RUN RATE101‐4351‐15‐0000 FS NOTICES & PUBLICATIONS 1,115 1,701 781 1,776 1,500 2,100 2,150 43.33% 2021 PROJECTED RUN RATE101‐4365‐15‐0000 FS INSURANCE PROPERTY / LIABILITY 78,867 68,962 74,109 81,212 84,295 88,842 97,586 15.77% BASED ON 2020/2021 RENEWAL 101‐4498‐15‐0000 FS REIMBURSED COSTS ADVANCED 5,886 6,594 6,280 6,144 6,725 6,725 6,860 2.00% MWMO ADP COST101‐4499‐15‐0000 FS MISCELLANEOUS 75 459 8 608 133 133 300 126.16% ADJUSTED TO ESTIMATED RUN RATETOTAL 341,367$ 347,391$ 371,306$ 387,492$ 297,217$ 308,611$ 323,902$ 8.98%LEGAL101‐4312‐16‐0000 AT GENERAL LEGAL 30,000$ 39,272 16,786 15,812 35,000 28,000 35,000 0.00% 2021 PROJECTED RUN RATE101‐4313‐16‐0000 AT CIVIL LITIGATION 32,693 5,467 16,583 34,386 65,250 15,000 65,250 0.00% 2021 BUDGET INCLUDES POTENTIAL REDACTION COSTS 101‐4314‐16‐0000 AT PROSECUTION RETAINER42,000 42,000 42,000 42,000 42,000 42,000 42,000 0.00% 2021 PROJECTED RUN RATETOTAL 104,693$ 86,739$ 75,369$ 92,198$ 142,250$ 85,000$ 142,250$ 0.00%ASSESSING101‐4110‐17‐0000 ASR REGULAR EMPLOYEE2,718$ 2,789$ 2,890$ 3,013$ 3,082$ 3,308$ 3,387$ 9.90% INCLUDES ESTIMATED 2021 WAGE ADJUSTMENTS / STAFF TURNOVER101‐4111‐17‐0000 ASR OVERTIME EMPLOYEE47 87 295 277 415 415 416 0.24% 2021 PROJECTED RUN RATE101‐4121‐17‐0000 ASR PERA206 215 237 246 262 262 285 8.75% BASED ON CURRENT PERA FUNDING RATE 101‐4122‐17‐0000 ASR FICA/MEDICARE 212 220 244 252 268 268 291 8.75% BASED ON ER 7.65% OF GROSS101‐4131‐17‐0000 ASR INSURANCE HEALTH 486 471 503 531 564 564 604 7.09% SPLIT 9.4% PREMUIM INCREASE IN 2021101‐4226‐17‐0000 ASR GENERAL SUPPLIES 138 135 116 166 170 170 173 2.00% 2021 PROJECTED RUN RATE101‐4311‐17‐0000 ASR HC ASSESSOR SERVICES 55,531 58,000 61,000 64,000 68,000 68,000 71,000 4.41% BASED ON ASSESSOR CORESPONDENCE DATED 7/1/20101‐4350‐17‐0000 ASR PRINTED FORMS & ENVELOPES‐ ‐ ‐ ‐ 160 160 160 0.00% PLACEHOLDERTOTAL 59,338$ 61,917$ 65,285$ 68,483$ 72,921$ 73,147$ 76,316$ 4.66%CITY BUILDINGS101‐4310‐18‐0000 CB MISC CONTRACTED SERVICES 10,718$ 55,817 54,760 56,825 56,985 56,985 59,100 3.71% City contracted cleaning services / refuse / rugs 101‐4325‐18‐0000 CB COMMUNICATIONS 6,532 5,833 5,762 5,624 6,270 6,270 6,700 6.86% BASED ON COMMUNICATION SPREADSHEET101‐4340‐18‐0000 CB REPAIRS AND MAINTENANCE 25,345 19,121 17,414 23,118 22,950 22,950 23,409 2.00% 2021 PROJECTED RUN RATE101‐4381‐18‐0000CB ELECTRIC AND GAS UTILITIES32,596 33,751 33,505 40,571 36,465 35,528 37,500 2.84% 2021 budget based on usage run rates and Estimated rate increases101‐4920‐18‐0000 CB TRANSFER CH RENT 81,800 85,890 90,185 94,694 96,588 96,588 100,451 4.00% 4.0 % increase in rent transfer ‐ funds CC / CH Facility expensesTOTAL 156,991$ 200,412$ 201,625$ 220,831$ 219,257$ 218,320$ 227,160$ 3.60%26
|