Loading...
HomeMy WebLinkAbout2022-08-29 City Council Meeting Packet-Special Meeting AMENDED AGENDA MAPLEWOOD CITY COUNCIL CITY COUNCIL SPECIAL MEETING 5:00 P.M. Monday, August 29, 2022 City Hall, Council Chambers A. CALL TO ORDER B. PLEDGE OF ALLEGIANCE C. ROLL CALL D. UNFINISHED BUSINESS 1. Intent to Close Meeting (Minn. Stat. Section 13D.03) Seek Council Direction on Compensation Study Findings 2. City Council Budget Workshop #2 E. NEW BUSINESS F. ADJOURNMENT THIS PAGE IS INTENTIONALLY LEFT BLANK D1 Council Special Meeting Packet Page Number 1 of 78 D1 Council Special Meeting Packet Page Number 2 of 78 D2 CITY COUNCIL WORKSHOP STAFF REPORT Meeting Date August 29, 2022 Melinda Coleman, City Manager REPORT TO: REPORT FROM: Ellen Paulseth, Finance Director PRESENTER: Ellen Paulseth, Finance Director AGENDA ITEM: City Council Budget Workshop #2 Action Requested: Motion Discussion Public Hearing Form of Action: Resolution Ordinance Contract/Agreement Proclamation Policy Issue: The City is required to file a proposed property tax levy for fiscal year 2023 with Ramsey County by September 30, 2022. The City Council must adopt the final 2023 tax levy by December 30, 2022. The Council may decrease the proposed tax levy prior to final adoption, but may not increase the proposed levy after the September filing with the County. Recommended Action: No action is required. Staff requests direction on the policy decisions outlined in the presentation and attachments. Fiscal Impact: Is There a Fiscal Impact? No Yes, the true or estimated cost is $25,913,885 Financing source(s): Adopted Budget Budget Modification New Revenue Source Use of Reserves Other: N/A Strategic Plan Relevance: Community Inclusiveness Financial & Asset Mgmt Environmental Stewardship Integrated Communication Operational Effectiveness Targeted Redevelopment The budget intersects with all areas of the strategic plan and sets spending policy for the next year. Background: A detailed budget proposal document describing the City ManagerÓs 2023 proposed budget and tax levy is included in this report. The council will consider adoption of the preliminary levy on September 12, 2022 and the final 2022 levy and budget on December 12, 2022. Attachments: 1. PowerPoint 2. Detailed Budget Proposal Council Special Meeting Packet Page Number 3 of 78 D2, Attachment 1 August 29, 2022 2023 City ManagerÓs Budget Workshop #2 Council Special Meeting Packet Page Number 4 of 78 D2, Attachment 1 2 s # e u l p a v o t h e s k r s l s k a a r e m o o v g d i n t d W a n c a s t e s e s j t n e e a i o b g g s m i i e r t t O d a s a r p e u t s x m B a t o t e c l 3 g r a i d e t 2 i ue n 0 bpi 2 www eee iii vvv eee RRR ¤¤¤ Council Special Meeting Packet Page Number 5 of 78 D2, Attachment 1 t n s e n p t s i s o e s s n h i m i t e e s e e t a n n d i g cm r e e i r a a p v v n i i n t o o w s u l a i c e u e l t r e m M v f c S f t e P ml n E I e d a o l s t e y c s a C t n i R i n A e d n o g d i e u m & et t e t l n a a m t e r r a o i r e g g m a i c r p e v o r n a t n t aT C O n I E n S i F Council Special Meeting Packet Page Number 6 of 78 D2, Attachment 1 llll oooo rrrr tttt nnnn oooo CCCC ss tttt ee nnnn s ss eeee oo mmmm pp d rr eeee uu gggg aaaa PP n nnnn tt aaaa nn ee u MMMM //// mm llll aaaaee F iiii gg cccc aa nnnn nn aaaa aa nnnn d iiii FFFFMM o 155 09 o 7 7 22 6 w s s e d s l d n d n s u p n u d F u F a n s F e u d e t u F c n c M i n d s u ee v e j n F rd c v i o u e n e r v e F S u r s R P i l l F e r l l a a l S a r a p i na t r t e i t r c e b n p e e o t t e e T a pn n GSDCEI ¤¤¤¤¤¤ Council Special Meeting Packet Page Number 7 of 78 D2, Attachment 1 d n a s e g s n e i e t l i l a n h u t C r t o e p g p d O u B 3 2 0 2 Council Special Meeting Packet Page Number 8 of 78 D2, Attachment 1 y v e L x a T y t r e p o r $1,544,032 P of y r a n i Increase m i l e r P 3 2 0 2 Council Special Meeting Packet Page Number 9 of 78 D2, Attachment 1 t c a p m y I v x Home e a L T 2 3 y 0 , y r 4 t Median 4 a r 5 , on 1 e n i $ p r o m o $123 i r % l of 3 . P e 6 r d P e f t Increase o a m i t s E Council Special Meeting Packet Page Number 10 of 78 D2, Attachment 1 ? % 7 d e s a Home e r 0 c 9 n 8 Median I , on 5 y 0 v 7 e $132 , L 1 of $ e h t f Increase i t a h W Council Special Meeting Packet Page Number 11 of 78 D2, Attachment 1 ? % 5 d e Home s a e r 3 Median c 9 n on 4 I , 8 y $105 1 v 2 of e , L 1 $ e h Increase t f i t a h W Council Special Meeting Packet Page Number 12 of 78 D2, Attachment 1 $25,913,885 d n u F y b y v e L x a T $24,369,853 Council Special Meeting Packet Page Number 13 of 78 D2, Attachment 1 3 2 0 2 y s r e a u n i n e m i v l e e r R P d / n 2 u 2 F 0 l 2 a t r e e g n d e u G B l a n i F Council Special Meeting Packet Page Number 14 of 78 D2, Attachment 1 3 s 2 e r 0 u 2 t i y d r n a e n i p x m i E l e d r n P / u 2 F 2 l a 0 r 2 e l n a e n i G F Council Special Meeting Packet Page Number 15 of 78 D2, Attachment 1 y b y r s a e r n i u t i m i l d e n r e P p x 3 E 2 0 d 2 n y u r F o l g a r e t e a n C e G Council Special Meeting Packet Page Number 16 of 78 D2, Attachment 1 y b s e r u t i t d n n e e p m x t r E a d p n e u D F l a r e n e G Council Special Meeting Packet Page Number 17 of 78 D2, Attachment 1 % y 4 . 3 r s i 5.0% o s r t a e s Y i n 3.0% e T H t s a P y e v s 3.5% a e e r c n L I e 5.0% g x a r e a v T A 4.0% 2.5% 0.0% Council Special Meeting Packet Page Number 18 of 78 D2, Attachment 1 y r o t s i % 6 . 5 H s i s r y a e t Y i n c e T t a s a P p e s a a e r C c n I l x a u a n n T A e t g a r e e v A N y t i C Council Special Meeting Packet Page Number 19 of 78 D2, Attachment 1 y r o t s i H n % 0 . o 5 i s i t s r a u e Y b n i e T r t t s a s P i e s a D e r c n s I l a e u i n t n i A r e g a a r e v p A s i D l a c s i F Council Special Meeting Packet Page Number 20 of 78 D2, Attachment 1 , n 3 , e n 2 s i ; h 0 t s m e s 2 , e r e i l d t e u n i ti i be l c c l t o o i r u o n r r o p ao t t p s i a p e l a r e r o e p r u f t ph a s n t ; c i ? i o l s i r ; u t k c ge r m D t e r nm nu o s il . ar u l a a m f p r o 2 r o v f a o 2 g 6 o l C ; nyt 0 o c e5 i t W a r 2 n v r 0 a s e , p l g ; a i e r e t 8 s u n sm Ô ia d p i i F l 8 m 0 o v o m h o n l 6 r o r r 6t , f a t a p o e p 9 3 o t r s i f o 1 4 h l l $ m r h c 8 a t g o oa eo i t n t a 2 t r er i p , f t h o ao 1 a l h o s r s M r s g r 5 c g u pt 1 e n u e y l a i P dl e p $ h oi b o a t nr a o rf i m gw h d - o p n l gt i d e g dd p a n t e i i n d a doo s i r n c e l e ra oo a e w t w a ee p h ww u or n m o s o r ee c b l m ll - e oi l ig t en r pp i H t sm vp g e aa s oo ei e n h m RdICtCdMMa ¤¤¤¤¤¤ Council Special Meeting Packet Page Number 21 of 78 D2, Attachment 1 y r o t s % i 2 7 . 1 H - s i s e r a t e Y a n e R T t s a y P t e i s a c e r c a e D l p a u a n n A C e g x a r e a v A T y t i C Council Special Meeting Packet Page Number 22 of 78 D2, Attachment 1 s r o t c a F n o i t a l u c l a C e t a R x a T Council Special Meeting Packet Page Number 23 of 78 D2, Attachment 1 y r o t s i H e s a e r c e D / e s a e r c n I x a T y t i C Council Special Meeting Packet Page Number 24 of 78 D2, Attachment 1 2 0 1 , 2 7 6 0 0 , 1 , 3 $ 7 6 0 , 3 $ 0 2 g 0 n 2 i d Y n F u F S E R A C l a t o T Liquor License Refunds$ 27,889YMCA Business Grant800,000St. JohnÔs Hospital Business Grant86,000CovidLeaves of Absence89,029Wages and Benefits2,064,184 ¤¤¤¤¤ Council Special Meeting Packet Page Number 25 of 78 D2, Attachment 1 0 0 0 , 5 6 4 , 4 0 $ 0 0 , 5 6 4 , 4 $ g n i d n u F A P R A l a t o T Ladder Truck and Tanker 2022-2024$2,100,000Ambulances/Equipment 2021-23 750,000Social Worker 2021-2024370,000Mall Security Cameras 50% 202140,000YMCA CovidRelief 2022350,000Premium Pay Essential Workers 2021 502,970CovidResponse PPE and Wages 2021 352,030 ¤¤¤¤¤¤¤ Council Special Meeting Packet Page Number 26 of 78 D2, Attachment 1 9 2 1 0 9 83 0 s 40 7 3 6 0 6 0 7, , 1 u , , , , l 4 4 80 4 6 5 3 8 0 p 2 3 124 r 5 2 ,,, 0 , , , 6212 u 1 7 1 1 S $$$$$$ d s n t n u e F m l y 1 r e a r 2 a i r 0 u e u e 2 c n q / ) n s 2 a n 1 e e J r a 2 3 lR u e e t / 0 i n a c d I y 2 2 n G B n c e 1 i r p d a l x l 1 s d e oe o a l f t nu 2 a l P t Ba u o g p t c 0 F e r f d n o o ci 2 l u n d l % n d / S 0 u e A a 5 n 1 l F f n d t u o a 3 gs e n F i m B t / u s u u ls : s A 2 m d i o u p s x a Pj 1 r n s a n R md u u m e ( UFSLAAA Council Special Meeting Packet Page Number 27 of 78 D2, Attachment 1 2 2 0 0 s0 0 , 2 u l 0 , 0 p 5 4 , r 1 2 $ u S y r d a n u u n F a J l a d r e e t n n o a i e t c a G c o l o l l l A A l a t o T Employee Benefits Fund$ 400,000Building Fund250,000Public Safety Equipment Fund250,000Fleet Fund250,000EDA Fund350,000 ¤¤¤¤¤ Council Special Meeting Packet Page Number 28 of 78 D2, Attachment 1 2 2 0 0 s 0 0 , u 2 l 0 0 s p 5 , r n 1 $ u o i S t a d c n o l n u l o F i t A l a c a o d l r l e e A s n d o e e s p o G p o o r r P P l a t o T Park Fund$ 500,000Building Fund200,000Technology Fund400,000Fleet Fund100,000EDA Fund300,000 ¤¤¤¤¤ Council Special Meeting Packet Page Number 29 of 78 D2, Attachment 1 s e y s e a s e r m c a n R I y n i v s e L e i t i d e C s g o n p i r o r o P b h y t g i n e u o N C Council Special Meeting Packet Page Number 30 of 78 D2, Attachment 1 ? t x e N s e t e m g d o u y B C v e 2 d t 2 L n 2 2 a a y 0 0 r 2 y h a 2 v , n , e i 2 L 2 W 1 m 1 l i r l a r e e n r e i b PF b tt m m pp e e oo t c dd p e AA e S¤D¤ Council Special Meeting Packet Page Number 31 of 78 D2, Attachment 1 s n o i t a r e d i s n o C y l v i e c L x s n s a e i n T u c i o t l i o e s o i g P c C r l e a a T i D c y m n c r i a i l f n f o i APF ¤¤¤ Council Special Meeting Packet Page Number 32 of 78 D2, Attachment 1 ? s n o i t s e u Q Council Special Meeting Packet Page Number 33 of 78 D2,Attachment2 CityağƓğŭĻƩ͸ƭ2023BudgetProposal August29,2022 6:00PM Council Special Meeting Packet Page Number 34 of 78 D2,Attachment2 Contents HowisthePreliminaryBudgetestablished?Page1 HowdoesthePreliminaryBudgetaffectthetaxlevy?Page2 Whatchangedinthetaxlevyfromlastyear?Page3 WhatwillthePreliminaryGeneralFundBudgetaccomplish?Page48 Wheredoesthemoneygo?Page9 Wheredoesthemoneycomefrom?Page10 WhatwasnotfundedinthePreliminaryBudget?Page11 Howdowecompare?Page12 GeneralFundsummaryPage13 Council Special Meeting Packet Page Number 35 of 78 D2,Attachment2 HowisthePreliminaryBudgetEstablished? CalculatingDepartmentalOperatingBudgets Eachyear,departmentheadsbuildapreliminarybudgetfromthegroundupusingazerobase approach.Staffinglevelsareanalyzedwiththecitymanagerandthefinancedepartmentprovides personnelcostestimates,basedonlaborcontractsinplace.Conservativeestimatesaregeneratedfor positionswithopencontracts.Thefinancedepartmentalsogeneratesdepartmentalestimatesfor large,routineexpendituressuchasinsuranceandutilities.Internaltechnologyandfleetchargesare calculatedbytheappropriatedepartmentheadandthefinancedepartment.Allotherlineitemsare calculatedbyindividualdepartmentheads.Asummaryofthebudget,includinganarrativeexplaining changesovertheprioryear,isprovidedtothecitymanagerandfinancedirector. CapitalExpenditureBudgets TheCapitalImprovementPlan(CIP)formsthebasisforthecapitaloutlaybudgetinthebudgetyear. CapitalImprovementPlanexpendituresareappropriatedeachyearthroughthebudgetprocess. Therefore,2023CIPprojectswillbeincludedinthe2023citybudget.However,eachprojectwillstill requireCouncilapprovalatthetimetheprojectcommences.CIPprojectsareevaluatedinthecontext ofthecurrentbudgetprocesstoprovideforthebestpossiblealignmentofthesetwoprocesses. AdministrativeReviewProcess Thecitymanagerandassistantcitymanagerreviewalldepartmentalbudgetstoensurethat departmentalobjectivesalignwiththeĭźƷǤ͸ƭstrategicgoals,andthatexpenditurelevelsare appropriatelylinkedtodesiredoutcomes.Staffinglevelsofalldepartmentsareanalyzedonanannual basis,toensuretheadequateallocationofresourcestomeetstrategicobjectives.Thecitymanager, assistantcitymanagerandfinancedirectormeettoreviewdepartmentalbudgetsintheaggregateand discussoverallgoalsforthebudgetandtaxlevy.Apreliminarytaxlevytargetisestablished. AnalyticalReview Thefinancedepartmentanalyzeseverylineitemofthecitybudgettoensureaccuracyand reasonableness.Thisreviewisconductedbyboththefinancedirectorandassistantfinancedirector. Personnelcostsarecomparedagainsttheoriginalestimates.Afiveyeartrendanalysisisconductedon roadsaltandmotorfuel,aspricesand lineitemsforthelargescalepurchaseofcommodities,suchas quantitiescanbevolatile.Thebudgetamountisbasedontheaverageyearlyexpenditureforthese items,ratherthantheworstcaseorbestcasescenario.Lineitemexpendituresforuniformallowances andotheremploymentnecessitiesarebudgetedbasedonhowmuchthecityexpectstospend,rather thanthefullcontractualallotment.Thesebudgetsareestablishedthroughtrendanalysisandemployee counts.Budgetsforcontractedprofessionalservicesarecalculatedusingazerobaseapproach,based ontheamountofservicesrequiredinthebudgetyeartomeetstrategicobjectives.Thefinancedirector recommendslineitemadjustmentstothecitymanagerinanamountsufficienttomeettargetgoals,if possible.Itemsthatrequirepolicyreviewareidentifiedbythecitymanagerandfinancedirectorand arepresentedtothecitycouncilfordiscussion. Council Special Meeting Packet Page Number 36 of 78 D,Attachment2 HowdoesthePreliminaryBudgetAffecttheTaxLevy? CityağƓğŭĻƩ͸ƭBudgetProposal ThecityƒğƓğŭĻƩ͸ƭ2023budgetproposalincludesa6.3%increaseoverall,or$1,544,032,ofthetotal citytaxlevy.TheDebtServiceFundlevydecreased2.4%,duetotheamortizationofexistingdebt.The detailsofthemajorchangesandchallengesareincludedonthenextpage.Thecitymanages approximately$80Minoperatinganendituresinover50fundsonanannualbasis.Notall dcapitalexp ofthesefundsrequirepropertytaxrevenues,becausetheyarefundedthroughothercomponentsof theĭźƷǤ͸ƭrevenuestream.Shownbelowisayearoveryearcomparisonofpropertytaxleviesbyfund: Adopted Preliminary$ Increase% Increase Fund2023 Levy(Decrease)(Decrease)2022 Levy General Fund18,185,680$ 19,759,738$ 1,574,058$ 8.7% Debt Service Funds5, 011,931 4,892,661 (119,270)-2.4% EDA Fund 100,000 100,000 -0.0% Capital Project Funds 1,072,242 1,161,486 89,2448.3% Total Levy$ 25,913,88524,369,853$ 1,544,032$ 6.3% GeneralFund TheGeneralFundtaxlevyisaround76%ofthetotalcitytaxlevyonanannualbasis.Leviesfordebt servicefundsarelegallyobligated.Thus,mostofourattentionisdevotedtotheGeneralFundfor establishingthelevy.Otherfundsincludecapitalprojectfunds,equipmentfunds,andtheEDAfund. Council Special Meeting Packet Page Number 37 of 78 D,Attachment2 WhatChangedintheTaxLevyfromLastYear? 2022FinalPropertyTaxLevy$24,369,853 WhatIncreased/Decreased? Amount ImpactonTaxLevy GeneralFundPayrollIncreases$1,362,317 CIPFundΑPlaygroundandRadioCosts10,000 IncreaseinBuildingFund75,000 IncreaseinMCCCapitalFund4,244 IncreaseinContractedServices231,044 IncreaseinSupplies(i.e.,RoadSaltandAsphalt)46,655 DecreaseinDebtService(119.270) IncreaseinTransfersinfromUtilityFunds(15,000) IncreaseinRevenues(50,958) TotalAmountofIncreaseintheLevy $1,544,032 2023ProposedPropertyTaxLevy$25,913,885 Notes Theprimaryreasonsforincreasedexpendituresarecapitalneedsandemployeepayroll.GeneralFund payrollgeneraladjustmentsareapproximately$785K,whilebenefitincreases(includinghealth insurance)areapproximately$577K.Thereare2.4additionalC9͸ƭbudgetedintheGeneralFund, comparedtolastyear. Thebudgetalsoreflectsaconservativeestimateforspecificrevenues,includingrentalhousingfee collectionsandDMVfees.TheamountofDMVbusinesslosttotheStatemailinserviceisunknownat thispoint.Intergovernmentalrevenuewillincreaseslightly,includingStatepoliceandfireaidsandLocal GovernmentAid(LGA). Council Special Meeting Packet Page Number 38 of 78 D,Attachment2 WhatwillthePreliminaryGeneralFundBudgetAccomplish? ExpendituresbyCategory: Expenditureswillincrease$1,640,018comparedtothe2022OriginalBudget,asfollows: PersonnelΑIncreaseof$1,362,317comparedto2022 Estimatedoverallwageadjustment6.0%; ‘ƚƩƉĻƩƭ͸compensationinsurancestabilizedduetonewdeductiblestructure; Noelectionjudgesalariesin2023,saving$101K; Estimatedhealthanddentalinsuranceincreaseof15.0%; Netincreaseof2.4FTEinGeneralFund. ContractualServicesΑIncreaseof$231,046comparedto2022 IncreaseinFleetFundcharges10%forcapitalneeds$68K; Increaseinutilities$32K; Increaseincontractedsocialworkerposition$116K,fundedbyARPA; Increaseforcitizensurvey$8K; Miscellaneousnetincreasesinothercontractsof$7,046. EquipmentandSuppliesΑIncreaseof$46,655comparedto2022 Increaseinpoliceuniformsandsupplies$34K; Decreaseinfiresupplies$14K; Increaseinroadsalt,asphalt,andengineeringsupplies$29K; Miscellaneousnetdecreaseinothersuppliesof$2,345. GeneralFund2023/2022Expenditures 20,000,000 19,324,347 18,000,000 17,188,420 16,000,000 14,000,000 12,000,000 10,000,000 8,000,000 4,937,4964,515,960 6,000,000 4,000,000 969,390 1,010,455 2,000,000 WAGES&BENEFITSCOMMODITIESCONTRACTEDSERVICES 20232022 Council Special Meeting Packet Page Number 39 of 78 D,Attachment2 ExpendituresbyFunction: Expenditureswillincrease$1,640,018,or6.94%in2023.Thiscompareswith$958,510,or4.23%,in theprioryear.Significantchangesinexpendituresbyfunctionalareaaredescribedbelow: GeneralGovernmentΑDecreaseof$132,095or3.52% CityCouncilbudgetincreased$8,238or5.1%,primarilyduetoanincreaseinconsultingfeesfor acitizensurvey; Administrationbudgetincreased$12,539,or2.64%,duetoinflationaryandstepsalary increases; Safetybudgetincreased$500forsupplies; HumanResourcesbudgetincreased$10,818,or2.01%,duetoduetosalaryincreasesnetted outbylowersalariesforanincumbentposition; Financebudgetincreased$47,855,or9.0%duetothe6%salaryandstepadjustmentsandan increaseina.6FTEpositiontoa.8FTEposition; CityClerkbudgetincreased$56,152,or3.5%,duetorestructuringofstaffatlowersalaryrates; DeputyRegistrarbudgetdecreased$161,027or19.6%duetoadecreaseof2.4C9͸ƭforthe appointmentsystemcreatedduringthepandemic; Electioncostsdecreased$107,170,or80.8%,duetonoelectionin2023. Council Special Meeting Packet Page Number 40 of 78 D,Attachment2 CommunityDevelopmentΑIncreaseof$105,330or6.67% CommunityDevelopmentbudgetincreased$59,306,or6.6%,dueto6%salaryincreasesanda smallincreaseinconsultingcosts; Buildinginspectionsincreased$46,024,or6.8%duetothe6%salaryandstepincreasesanda tingcosts. smallincreaseinconsul PublicSafetyΑIncreaseof$1,302,173or9.8% Increaseof$1,121,656,or10.4%inthePoliceDepartment,duetosalaryandstepincreasesand theadditionof2.15C9͸ƭ(recordsclerkand/{h͸ƭΜͲandtheadditionofasocialworkercontract thatiscurrentlyfundedthroughARPAfunds; Increaseof$182,517,or7.3%,intheFireDepartmentduetothe6%salaryincreasesandsteps theadditionofthreenewfirefighters,mitigatedto1.5throughdelayedstartdates.; Decreaseof$2,000,or20.41%,inemergencymanagementduetoareductioninCovid expenses. Parks&RecreationΑIncreaseof$100,284or6.5% ParksAdministrationincreased$47,158or11.39%,duetothe6%salaryincreasesandthe$29K Edgertongymcontractthatwasnotinthebudgetintheprioryear,duetotheeliminationof recreationprogramming.Thegymcontractwasrestored; ParksMaintenanceincreased$53,678,or5.2%,dueto6%salaryandstepincreases; TheOpenSpaceManagementbudgetdecreased$2,147or3.7%; th The4ofJulycelebrationbudgetincreased$1,595,or4.52%. PublicWorksΑIncreaseof$264,326or7.6% BuildingOperationsbudgetincreased$36,476,or5.7%duetothe6%salaryincreases; ThePublicWorksadministrationbudgetincreased$58,562,or17.2%,duetosalaryincreases andGISsoftwarefees; TheStreetMaintenancebudgetincreased$6,302,or0.6%,duetosalaryincreasesandfleet chargeincreasesnettedoutbyadecreaseinǞƚƩƉĻƩƭ͸compensationinsurance; TheEngineeringbudgetincreased$100,475,or14.6%,duetosalaryandstepincreases,a changeintheoverallallocationofpublicworksC9͸ƭacrossallpublicworksfunctions,andfleet charges.AtransferinfromtheWACfundoffsetsthischangeinallocation; TheSnowandIceControlbudgetincreased$19,868,or3.51%duetosalaryandstepincreases, saltpricesandfleetcharges.However,theincreasesweremitigatedbylowerǞƚƩƉĻƩƭ͸ compensationcosts. TheForestrybudgetincreased$42,643,or16.3%,duetosalaryincreasesandanincreasein consultingcostsfortheashborereradicationprogram. Council Special Meeting Packet Page Number 41 of 78 D,Attachment2 Revenues Revenueswillincrease$1,600,018,or6.8%,comparedtothe2022OriginalBudget,asfollows: GeneralRevenuesΑIncreaseof$1,585,018comparedto2022 Propertytaxrevenuewillincrease$1,574,058,or8.7%; Licensesandpermitsrevenueisprojectedtoincrease$12,800,or0.94%; Intergovernmentalrevenueisprojectedtodecrease$1,440,or0.11%; Chargesforservicesareprojectedtoincrease$10,600,or0.90%; DecreaseinFinerevenueof$10,000,or6.67%,duetorecentandcontinuingdownwardtrends; NoincreaseinInterestrevenue; DecreaseinMiscellaneousrevenueof$1,000,or1.1%. OtherFinancingSourcesΑIncreaseof$15,000comparedto2022 IncreaseinTransfersInof15,000,duetoaproposedtransferfromtheWACFund.Thisisnew for2023andwillreplacetheallocationofsmallamountsofpublicworkssalariestotheWAC Fund.TheGeneralFundwillabsorbthesalaries. Council Special Meeting Packet Page Number 42 of 78 D,Attachment2 Personnel Budgetedfulltimeequivalent(FTE)employeesincreasedoverallby2.95forbudgetyear2023.The 2023budgetedC9͸ƭreflectthereductionof2.4fulltimeDMVstaff,fundedthroughtheARPAgrantin 2022.AnadministrativeassistantintheCity/ƌĻƩƉ͸ƭofficewasincreased.20FTE.FireDepartment staffinglevelsincreasedby3.0C9͸ƭͲwiththeadditionofthreenewfirefighterpositions.However, startingdatesarestaggeredovertheyear.ThePoliceDepartmentaddedanewrecordsclerkand increasedCSOpositionstofulltime,resultinginanincreaseof1.15CSOC9͸ƭ͵Thechartreflectstotal employeesacrossallfunds,butdoesnotincludetemporaryorvolunteeremployees.Temporary employeesarenotincluded,butamounttoatotalof1.35C9͸ƭ͵ Theyear2018reflectsareductioninforceduetotheYMCAtakingoveroperationsoftheMaplewood CommunityCenter.In2019,theCitymovedfromapaidoncallfiredepartmentmodeltoafulltime firefighter/paramedicmodel.In2020,theCityaddedemployeestostaffthenewrentalhousing inspectionprogramandapoliceofficer,fundedthroughanautotheftgrant. Council Special Meeting Packet Page Number 43 of 78 D,Attachment2 WheredoestheMoneyGo? Eachyear,about76%oftheGeneralFundbudgetconsistsofpersonnelcosts.Nearly20%represents contractedservices,includingattorneys,auditors,planners,andcontractors.Only4%isspenton commodities,suchasasphaltandroadsalt.Thismakesitdifficulttofindsavingsinthebudgetwithout impactingservices.Theallocationdoesnotchangesignificantlyfromyeartoyear,asshownbelow. Council Special Meeting Packet Page Number 44 of 78 D,Attachment2 WheredoestheMoneyComeFrom? Approximately78%ofthe2023GeneralFundrevenuestreamconsistsofpropertytaxrevenues,up slightlyfrom2022.Licensingandpermitrevenueaccountsfor5.4%.Chargesforservicesprovide4.7% ofGeneralFundrevenues,whileintergovernmentalrevenuesprovide5.1%.Transfersinfromother fundsincludeinternalchargessuchasengineeringandadministrativecharges.Therevenuestream remainssomewhatconsistentovertime,asshownbelow. Council Special Meeting Packet Page Number 45 of 78 D,Attachment2 WhatdidnotgetFundedinthePreliminaryBudget? TheCityManagerandFinanceDirectoridentifiedseveraldepartmentalrequestsasenhancementsto currentservicelevelsrequiringapolicydecisionandtheyareincludedinthebudget.Thefollowing programswerenotfunded. AdditionalEDAlevy$20,000 HRALevy$100,000 Every$240,000increaseinexpenditureswillresultinapproximately1%increaseinthetaxlevy. Council Special Meeting Packet Page Number 46 of 78 D2,Attachment2 HowDoWeCompare? ThefollowingchartcomparesağƦƌĻǞƚƚķ͸ƭ2020spendingandeconomicdatawithsimilarmetropolitancities. TheOfficeoftheStateAuditorprovidedthedata,with2020spendingdatabeingthelatestavailable. TotalDebt 20202020Taxable2020Certified2020Current2020Capital2020Debt2020TotalDebt&DebtServiceOutstanding PeerCityPerCapita PopulationTaxCapacityTaxLevyExpendituresOutlayServiceExpendituresCapital/Total/TotalExpBondedDebt Andover 32,60134,665,21014,291,93920,275,06916,837,3432,895,06040,007,47249.32%7.24%39,840,0001,222 BrooklynCenter 33,78220,910,61719,563,00525,120,0419,497,6024,893,99639,511,63936.42%12.39%46,580,0001,379 InverGroveHeights 35,80142,844,11824,810,66629,296,8037,622,6473,252,45440,171,90427.07%8.10%43,980,0001,228 Roseville 36,25454,289,89223,105,24931,795,7855,238,0592,580,48639,614,33019.74%6.51%25,710,000709 Richfield 36,99436,199,71922,734,96930,616,40511,261,3844,905,53646,783,32534.56%10.49%68,820,0001,860 CottageGrove 38,83936,682,06016,914,43326,976,37328,300,8343,787,62959,064,83654.33%6.41%37,410,000963 Maplewood 42,08844,235,21422,942,78125,535,89413,257,4848,560,09447,353,47246.07%18.08%60,657,1651,441 Shakopee 43,69853,441,57320,380,71734,781,14513,690,9582,943,50351,415,60632.35%5.72%41,075,000940 St.LouisPark 50,01074,394,38834,837,67665,525,8488,140,77414,177,35187,843,97325.41%16.14%90,120,0001,802 AppleValley 54,40059,586,71926,365,65430,536,3989,1761,536,88445,442,45832.80%3.38%18,105,000333 13,36 Average40,44745,724,95122,594,70932,045,97612,721,6264,953,29949,720,90235.81%9.45%47,229,7171,188 Maplewood %ofAverage ЊЉЍ͵ЊіВЏ͵АіЊЉЊ͵ЎіАВ͵АіЊЉЍ͵ЋіЊАЋ͵БіВЎ͵ЋіЊЋБ͵АіЊВЊ͵ЍіЊЋБ͵ЍіЊЋЊ͵Ќі ağƦƌĻǞƚƚķ͸ƭpopulationisslightlylargerthanthesamplegroup,withthetaxabletaxcapacityslightlyless thanthesamegroup.The2020certifiedtaxlevywas1.5%morethanthegroupaverage;however,current (operating)expendituresweresignificantlyless.Capitalexpenditureswere.higherin2020,butgenerallytrend muchlowercomparedtothegroup.Debtservicewashigher;however,retirementofprincipalrelatedtothe issuanceofrefundingbondsisincludedindebtserviceforallcities.ağƦƌĻǞƚƚķ͸ƭoutstandingbondeddebtis stillhigherthanthatofthepeergroup,butitdoesinclude$5,480,000inrefundingdebtthatwasdefeasedin 2021.Therefore,netoutstandingdebtwas$55,177,165.Maplewoodisstillthirdhighestinthegroup,but gettingmuchcloserthanaverage.TherearetwocitieswithhigherdebtpercapitathanMaplewoodin2020. Council Special Meeting Packet Page Number 47 of 78 D2, Attachment 2 CITY OF MAPLEWOOD REVENUES BY ACCOUNT 101GENERAL FUND 000' 20202021202220222023 RECEIVEDRECEIVEDORIG BUDGTRECVD YTDDEPT REQ 3011TAXES - CURRENT17,532,79917,191,0339,373,69518,185,68019,759,739 3012TAXES - DELINQUENT-238,798-139,52861,05900 3014TAXES-FORFTD TAX SALE APP1,5749924,00100 3015TAX INCREMENT00000 3016TAXES-MOBILE HOMES42,98448,2163,67000 3017TAXES-INTEREST-15,547-29,5722,83600 3018TAXES - OTHER3,90096000 3019TAXES - EXCESS TIF20,6105,7547,43800 3031CABLE TV FRANCHISE TAXES00000 TOTAL TAXES 17,347,52217,076,99018,185,6809,452,69919,759,739 3110SPECIAL ASSESSMENTS CURREN00000 3130SPECIAL ASSESSMENTS DELINQU00000 3140SPECIAL ASSESSMENTS DEFERRE00000 3160SP. ASSESS.-PENALTIES/INTEREST464157000 3170SP/A FORFTD TAX SALE APRT00000 3190SP/A DEFERRED - COUNTY00000 S TOTAL SPECIAL ASSESSMENT 464157000 3201LIQUOR181,680205,136200,00031,075200,000 3203CIGARETTE11,49515,36012,00010,67512,000 3204ENTERTAINMENT-AMUSEMENTS776388000 3205GENERAL BUSINESS154,115164,212150,000122,200155,000 3207CONTRACTOR48,62051,35055,00041,60052,000 3208GARBAGE & RUBBISH REMOVAL4,5004,2504,0005004,000 3209SERVICE & REPAIR STATIONS14,19613,46514,0009,10814,000 3210BUSINESS REGISTRATION FEE4,3484,6054,0003,3204,300 3219MISCELLANEOUS21,70420,87323,0005,05622,000 3301BUILDING908,764805,414540,000676,530550,000 3302ELECTRIC PERMIT FEES52,376112,85155,00045,57758,000 3303HEATING270,723211,478205,000109,374205,000 3304PLUMBING49,29066,08570,00056,82968,000 3306ANIMAL2,0864,53301,365500 3307DNR LICENSES AND PERMITS00000 3319MISCELLANEOUS26,11422,57825,00077,46525,000 3321MISC LIC/PERMITS - TASTE OF MAP0002,1250 TOTAL LICENSES AND PERMITS 1,750,7861,702,5771,192,7991,357,0001,369,800 3512FEDERAL DISASTER AID00000 3513FEDERAL EMERGENCY MGMT ASS00000 3516FEDERAL POLICE GRANTS56,23584,43342,779140,000105,000 3517MISC FEDERAL GRANTS20,5534,488,201000 3520STATE FIRE AID209,349221,2500210,000225,000 3521STATE LOCAL GOVT. AID209,9200000 3522STATE MN DOT GRANTS140,0850000 3523STATE HOMESTEAD CREDIT00000 3524STATE POLICE AID474,915487,9720470,000485,000 3525STATE TRANSITION AID000 3526STATE ST. MTNCE. AID275,000275,000275,000275,000275,000 3527STATE POLICE GRANTS147,682169,37452,186100,000100,000 3528STATE FIRE/PARAMEDIC GRANTS2,43682,87508,0005,000 3530MISC. STATE AID/GRANTS21,40214,24015,7605,00010,000 3531COUNTY ROAD BRIDGE AID1,8251,83001,9001,800 3532STATE LOCAL PERFORMANCE AID5,8435,89205,7005,900 3534COUNTY - OTHER GRANTS/AID00000 3541OTHER GOVT SCHL LIAS OFF PRO64,89074,16037,08072,70074,160 Council Special Meeting Packet Page Number 48 of 78 D2, Attachment 2 CITY OF MAPLEWOOD REVENUES BY ACCOUNT 101GENERAL FUND 000' 20202021202220222023 RECEIVEDRECEIVEDORIG BUDGTRECVD YTDDEPT REQ 3542OTHER GOVT JPA02,126000 3544OTHER GOVT-MISC. GRANTS16,0000000 TOTAL INTERGOVERNMENTAL 1,646,1365,907,3531,288,300422,8041,286,860 3031CABLE TV FRANCHISE TAXES00000 3610ELECTION SERVICES6000450 3611GENERAL GOVT.-TAXABLE1572220057100 3612GENERAL GOVT. NON TAXABLE0149100623100 3613GENERAL-MOTOR VEHICLE FEES306,169428,112490,000283,866450,000 3614GENERAL GOVT. DRIVERS LIC FEE75,9060000 3615DNR FILING FEES6,2235,6334,4426,0006,000 3616GENERAL GOVT ADMIN. CH/SWR F00000 3617PASSPORT FEES90,619168,89498,854135,000145,000 3618INVESTMENT MGMT. FEES REVEN00000 3619GEN.GOVT.-ADMIN CHRG-PIP FUN056000 3620ADMINISTRATIVE CHARGES -T.I.F24,0000000 3621AMBULANCE CHARGES00000 3623PUBLIC SAFETY DISPATCHING00000 3624PUBLIC SAFETY MISCELLANEOUS21,49250,73013,95930,00030,000 3625D.A.R.E. PROGRAM00000 3626PAWNBROKER TRANSACTION FEE1,4080010,0000 3627TOW/IMPOUND FEES00000 3628PUBLIC WORKS ABATEMENT PROP01,2003002,0002,000 3629ADMIN. FEE ABATEMENT PROPER036875500500 3630EXCESSIVE CONSUMPTION FEE00000 3631PUBLIC WORKS ENG CH/SP FUND00000 3632PUBLIC WORKS COUNTOUR MAPS00000 3633PUBLIC WORKS MISC.5638,33705001,000 3641RECREATION PROGRAM FEES70,076-6,4291170100 3643REC. - NATURE CTR. FEES4,70901300100 3649MISCELLANEOUS00000 3651UTILITY SERVICE CHARGES00000 3681COMM DEV-PLAN CHECK FEES634,966336,412298,106250,000275,000 3682COMM DEV-MISCELLANEOUS73,86674,10641,36550,00050,000 3683COMM/DEV CNTY RECORD FEES460368460500400 3685COMM DEV-RENTAL LICENSING163,250253,35095,500200,000225,000 3691SUPPRESSION SERVICES00000 3692FIRE DEPT. MISC. CHARGES005000 3693LIFE SAFETY INSPECTION FEE55050500100 3694EXTRICATION FEES00000 3643REC.- NATURE CTR. FEES00000 3643REC.- NATURE CTR. FEES00000 3643REC.- NATURE CTR. FEES00000 3643REC.- NATURE CTR. FEES00000 3643REC.- NATURE CTR. FEES00000 3643REC.- NATURE CTR. FEES00000 3643REC.- NATURE CTR. FEES00000 3643REC.- NATURE CTR. FEES00000 3643REC.- NATURE CTR. FEES00000 TOTAL CHARGES FOR SERVICE 1,474,4741,321,358837,9991,174,8001,185,400 3401FINES91,38989,588110,00033,251100,000 3402PENALTIES38,71055,15940,00011,95040,000 TOTAL FINES 130,100144,747150,00045,201140,000 3801INTEREST ON INVESTMENTS260,865-73,52260,00065,70360,000 Council Special Meeting Packet Page Number 49 of 78 D2, Attachment 2 CITY OF MAPLEWOOD REVENUES BY ACCOUNT 101GENERAL FUND 000' 20202021202220222023 RECEIVEDRECEIVEDORIG BUDGTRECVD YTDDEPT REQ TOTAL INTEREST 260,865-73,52260,00065,70360,000 3802RENT1,6651,6201,5001,4951,500 3803DONATIONS & CONTRIBUTIONS2,85083902950 3804SALE OF PROPERTY5,2842,93702,4950 3805DEVELOPER CHARGES00000 3806SURTAX RETAINER6432925000500 3807S.A.C. RETAINER2,9822,3882,5004,3982,500 3808CONNECTION CHARGES00000 3809OTHER59,84344,18645,00019,32845,000 3810DRUG & ALCOHOL AWARENESS PR2,3263841,0002500 3811ADVERTISING FEES0050000 3812REVENUE BOND FEES00000 3813REIMBURSEMENT OF EXPENSE - N00000 3814ADVERTISING FEES - TASTE OF MA90005001,000500 3816OTHER - TASTE OF MAPLEWOOD002,59000 3823NATURE CENTER - DONATIONS1,7750000 3872RENTALS-ROOM27,22964,02626,16550,00050,000 3873RECREATION CONCESSIONS7016000 3997REVENUE SUSPENSE ACCT000 TOTAL MISCELLANEOUS 106,196116,67757,768101,500100,500 3998RESIDUAL EQUITY TRANSFERS IN00000 3999TRANSFERS IN3,396,1371,315,0001,355,0001,355,0001,370,000 3,396,1371,315,0001,355,0001,355,0001,370,000 /DIV TOTALS DEPT26,112,68127,511,33823,672,28013,429,97425,272,299 Council Special Meeting Packet Page Number 50 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 101CITY COUNCIL 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES00000 4011OVERTIME PAY00000 4025WAGES/TEMPORARY66,40166,16968,02043,60568,013 4040RETIREMENT BENEFITS7,9807,9808,6005,7368,604 4050INSURANCE BENEFITS00000 4090WORKERS' COMPENSATION901301107384 TOTAL PERSONNEL SERVICES 74,47174,27976,73049,41476,701 4110SUPPLIES - OFFICE0120000 4120PROGRAM SUPPLIES4,6633,2945,0003,1135,000 4160SUPPLIES - EQUIPMENT0001,4570 4165SMALL EQUIPMENT00000 4170BOOKS00000 4220SIGNS & SIGNALS00000 TOTAL COMMODITIES 4,6633,4155,0004,5705,000 4310TELEPHONE7586761,000353800 4315INTERNAL PHONE CHARGES00000 4330POSTAGE333323400236400 4360PUBLISHING00000 4370INSURANCE500500300200300 4380SUBSCRIPTIONS & MEMBERSHIPS44,55945,58345,00015,46545,000 4390TRAVEL & TRAINING1764771,4344,0004,000 4400VEHICLE ALLOWANCE3600200200 4430REPAIRS & MTNCE./EQUIPMENT00000 4480FEES FOR SERVICE11,3828,7741,92312,00020,000 4490FEES - CONSULTING06,865000 4520OUTSIDE RENTAL - EQUIPMENT00000 4530OUTSIDE RENTAL-PROPERTY/BLD00000 4580INTERNAL I. T. CHARGES15,48015,10010,33315,50015,965 TOTAL CONTRACTUAL SERVICES 73,22478,29929,94478,40086,665 DEPT/DIV TOTALS152,358155,992160,13083,929168,366 Council Special Meeting Packet Page Number 51 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 102ADMINISTRATION 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES305,300304,202319,490191,419333,395 4011OVERTIME PAY1620000 4020WAGES/PART-TIME00000 4025WAGES/TEMPORARY0050000 4030LEAVE BENEFITS3,8764,3204,7903,1923,334 4040RETIREMENT BENEFITS49,03248,24049,53033,02458,429 4050INSURANCE BENEFITS38,79638,76038,95025,96829,109 4090WORKERS' COMPENSATION3,4304,9603,7202,4803,412 TOTAL PERSONNEL SERVICES 400,596400,482416,980256,083427,679 4110SUPPLIES - OFFICE701567500818800 4120PROGRAM SUPPLIES9893,2924,5001,0904,500 4160SUPPLIES - EQUIPMENT501150000 4165SMALL EQUIPMENT00000 4170BOOKS020000 TOTAL COMMODITIES 1,7403,8905,5001,9085,300 4310TELEPHONE1,8441,8902,0001,2692,000 4315INTERNAL PHONE CHARGES00000 4330POSTAGE208255300207300 4360PUBLISHING00000 4370INSURANCE00000 4380SUBSCRIPTIONS & MEMBERSHIPS3,0324,0264,0004,9766,000 4390TRAVEL & TRAINING1,0071,6102,53210,00010,000 4391EDUCATION REIMBURSEMENTS00000 4400VEHICLE ALLOWANCE2,4002,2002,4001,4002,400 4430REPAIRS & MTNCE./EQUIPMENT00000 4480FEES FOR SERVICE11,6561,7981,5002809,500 4490FEES - CONSULTING2,9802,5358,00000 4520OUTSIDE RENTAL - EQUIPMENT00000 4530OUTSIDE RENTAL-PROPERTY/BLD00000 4550DUPLICATING COSTS1,8501,8633,2001,2022,600 4580INTERNAL I. T. CHARGES21,20020,70021,30014,20021,940 TOTAL CONTRACTUAL SERVICES 46,17736,87752,70026,06754,740 4630EQUIPMENT - OFFICE00000 TOTAL CAPITAL OUTLAY & DEPN 00000 DEPT/DIV TOTALS448,513441,249475,180284,058487,719 Council Special Meeting Packet Page Number 52 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 103LEGAL SERVICES 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4020WAGES/PART-TIME00000 4025WAGES/TEMPORARY00000 4040RETIREMENT BENEFITS00000 4050INSURANCE BENEFITS00000 TOTAL PERSONNEL SERVICE 00000 S 4110SUPPLIES - OFFICE00000 TOTAL COMMODITIES 00000 4310TELEPHONE4394795000500 4370INSURANCE00000 4390TRAVEL & TRAINING00000 4480FEES FOR SERVICE136,092108,259150,00091,816150,000 4490FEES - CONSULTING00000 TOTAL CONTRACTUAL SERVICES 136,530108,737150,50091,816150,500 4970JUDGEMENTS & LOSSES00000 4975SMALL LIABILITY CLAIMS00000 TOTAL OTHER CHARGES 00000 DEPT/DIV TOTALS136,530108,737150,50091,816150,500 Council Special Meeting Packet Page Number 53 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 114SAFETY 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4110SUPPLIES - OFFICE00000 4120PROGRAM SUPPLIES001,0000500 TOTAL COMMODITIES 001,0000500 4370INSURANCE00000 4380SUBSCRIPTIONS & MEMBERSHIPS00000 4390TRAVEL & TRAINING00000 4480FEES FOR SERVICE10,18610,39910,59810,00011,000 4490FEES - CONSULTING00000 4550DUPLICATING COSTS00000 TOTAL CONTRACTUAL SERVICES 10,18610,39910,59810,00011,000 DEPT/DIV TOTALS10,18610,39911,00010,59811,500 Council Special Meeting Packet Page Number 54 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 115BUILDING OPERATIONS 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES177,858182,953179,600112,054190,384 4011OVERTIME PAY16,66318,63110,30011,24018,000 4020WAGES/PART-TIME00000 4025WAGES/TEMPORARY003,00003,000 4030LEAVE BENEFITS2,1842,4492,6901,7921,904 4040RETIREMENT BENEFITS33,32433,21533,90022,60036,250 4050INSURANCE BENEFITS35,61635,59235,57023,71247,516 4090WORKERS' COMPENSATION13,25018,68015,60010,40012,782 TOTAL PERSONNEL SERVICES 278,895291,520280,660181,798309,836 4110SUPPLIES - OFFICE504000400 4130SUPPLIES - JANITORIAL15,60512,69516,0006,71816,000 4160SUPPLIES - EQUIPMENT15,96722,82925,00011,34825,000 4165SMALL EQUIPMENT2,9650000 4170BOOKS00000 4180MAINTENANCE MATERIALS1,3664101,0002571,000 4190CHEMICALS00000 4210FUEL & OIL00000 4220SIGNS & SIGNALS0971,000277600 4230SMALL TOOLS001,00001,000 4240UNIFORMS & CLOTHING9086,5011,0002,5941,500 4290MISCELLANEOUS COMMODITIES2,48507,0009,37910,000 TOTAL COMMODITIES 39,30142,53352,40030,57455,500 4310TELEPHONE1,6561,8381,8001,1011,900 4315INTERNAL PHONE CHARGES00000 4320UTILITIES88,65492,64799,00076,181106,000 4325SOLAR SYSTEM00000 4360PUBLISHING00000 4370INSURANCE13,00013,00016,00010,66716,000 4380SUBSCRIPTIONS & MEMBERSHIPS0305000100 4390TRAVEL & TRAINING0001,0001,000 4391EDUCATION REIMBURSEMENTS00000 4400VEHICLE ALLOWANCE000100100 4410REPAIR & MAINT/BUILDINGS88,16980,30128,75270,00070,000 4430REPAIRS & MTNCE./EQUIPMENT26,35217,8382,62027,00025,000 4480FEES FOR SERVICE21,93227,9698,81836,00035,000 4490FEES - CONSULTING00012,00012,000 4520OUTSIDE RENTAL - EQUIPMENT0036600 4540INTERNAL RENTAL - VEHICLE4,5004,5005,0003,3335,500 4590MISC. CONTRACTUAL SERVICES2,395035,0001,13935,000 TOTAL CONTRACTUAL SERVICES 246,659238,123303,400132,977307,600 4610VEHICLES00000 4630EQUIPMENT - OFFICE00000 4640EQUIPMENT - OTHER31,8320000 4720LAND IMPROVEMENT00000 4730BUILDING IMPROVEMENT00000 4759OTHER CONSTRUCTION COSTS00000 TOTAL CAPITAL OUTLAY & DEPN 31,8320000 DEPT/DIV TOTALS596,688572,177636,460345,349672,936 Council Special Meeting Packet Page Number 55 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 116HUMAN RESOURCES ADMINISTRATION 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES183,053229,283263,870157,188274,428 4011OVERTIME PAY5401,0002101,000 4020WAGES/PART-TIME54,26216,632000 4025WAGES/TEMPORARY0010,00000 4030LEAVE BENEFITS2,7363,3603,9602,6402,744 4040RETIREMENT BENEFITS45,98445,13249,50033,00050,646 4050INSURANCE BENEFITS22,70422,68033,25022,16834,276 4090WORKERS' COMPENSATION2,6403,8202,8601,9072,624 TOTAL PERSONNEL SERVICES 311,433320,907364,440217,113365,718 4110SUPPLIES - OFFICE3314811,5003541,000 4120PROGRAM SUPPLIES3,9602,1582,5001,2682,500 4160SUPPLIES - EQUIPMENT531122000 4165SMALL EQUIPMENT00000 4170BOOKS00000 TOTAL COMMODITIES 4,8212,7614,0001,6223,500 4310TELEPHONE2,1082,1632,1001,4242,200 4315INTERNAL PHONE CHARGES00000 4330POSTAGE277285400226400 4360PUBLISHING32,35425,93114,00044,11125,000 4370INSURANCE00000 4380SUBSCRIPTIONS & MEMBERSHIPS401751,5002291,500 4390TRAVEL & TRAINING151247947,5005,000 4391EDUCATION REIMBURSEMENTS4,0990000 4400VEHICLE ALLOWANCE2,4282,2002,4501,4002,450 4430REPAIRS & MTNCE./EQUIPMENT00000 4480FEES FOR SERVICE20,58135,19650,00042,12586,500 4490FEES - CONSULTING6,50011,50036,50018,7650 4520OUTSIDE RENTAL - EQUIPMENT00000 4530OUTSIDE RENTAL-PROPERTY/BLD00000 4550DUPLICATING COSTS6484371,000291800 4580INTERNAL I. T. CHARGES54,48053,20054,70036,46756,340 TOTAL CONTRACTUAL SERVICES 123,531131,211170,150145,832180,190 4630EQUIPMENT - OFFICE00000 TOTAL CAPITAL OUTLAY & DEPN 00000 DEPT/DIV TOTALS439,786454,880538,590364,567549,408 Council Special Meeting Packet Page Number 56 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 201FINANCE 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES395,792482,234495,460305,318531,428 4011OVERTIME PAY13419000 4020WAGES/PART-TIME19,6761,091000 4025WAGES/TEMPORARY00005,945 4030LEAVE BENEFITS4,8246,5297,4304,9525,314 4040RETIREMENT BENEFITS83,44883,76088,19058,79295,283 4050INSURANCE BENEFITS69,21672,85273,57049,04870,541 4090WORKERS' COMPENSATION4,7406,8705,1503,4334,724 TOTAL PERSONNEL SERVICES 577,710653,755669,800421,544713,235 4110SUPPLIES - OFFICE3,4298732,5008902,500 4120PROGRAM SUPPLIES00000 4160SUPPLIES - EQUIPMENT2904351,00001,000 4165SMALL EQUIPMENT00000 4170BOOKS0162000200 4290MISCELLANEOUS COMMODITIES00000 TOTAL COMMODITIES 3,7181,3243,7008903,700 4310TELEPHONE2,4212,5442,5001,5862,600 4315INTERNAL PHONE CHARGES00000 4330POSTAGE2,0191,8792,2001,1472,100 4360PUBLISHING60206000600 4370INSURANCE4,0004,0004,0002,6674,000 4380SUBSCRIPTIONS & MEMBERSHIPS703515800515800 4390TRAVEL & TRAINING2,6682,0583,8705,8006,000 4391EDUCATION REIMBURSEMENTS00000 4400VEHICLE ALLOWANCE2,4202,6002,6001,4002,600 4430REPAIRS & MTNCE./EQUIPMENT00000 4480FEES FOR SERVICE63,42066,99980,00077,82683,000 4490FEES - CONSULTING00000 4520OUTSIDE RENTAL - EQUIPMENT00000 4550DUPLICATING COSTS2,2491,7273,7001,0343,000 4580INTERNAL I. T. CHARGES63,60062,10063,90042,60065,820 TOTAL CONTRACTUAL SERVICES 144,102144,423166,100132,645170,520 4630EQUIPMENT - OFFICE00000 TOTAL CAPITAL OUTLAY & DEPN 00000 4901LATE PAYMENT PENALTIES00000 4940CASH OVER & SHORT-1300-400 TOTAL OTHER CHARGES-13000-40 DEPT/DIV TOTALS725,517799,502839,600555,039887,455 Council Special Meeting Packet Page Number 57 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 301CITY CLERK 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES373,189268,499341,710200,415356,470 4011OVERTIME PAY1,8775900999 4020WAGES/PART-TIME43,11041,59236,30023,76251,310 4025WAGES/TEMPORARY3,2193,107001,015 4030LEAVE BENEFITS4,6325,6755,6703,7844,078 4040RETIREMENT BENEFITS74,08873,17769,71046,47273,254 4050INSURANCE BENEFITS63,31263,27562,47041,64882,340 4090WORKERS' COMPENSATION3,9505,7204,2902,8603,936 TOTAL PERSONNEL SERVICES 567,378461,103520,150318,942573,402 4110SUPPLIES - OFFICE2,3022,3254,0002,4024,000 4120PROGRAM SUPPLIES002000200 4160SUPPLIES - EQUIPMENT2,4754,8667,0002,2827,000 4165SMALL EQUIPMENT00000 4170BOOKS4111000100 4240UNIFORMS & CLOTHING00000 TOTAL COMMODITIES 4,7827,20211,3004,68411,300 4310TELEPHONE3,6173,2013,8001,0473,600 4315INTERNAL PHONE CHARGES00000 4330POSTAGE5,0947,4018,8005,1808,000 4360PUBLISHING1,8233,6603,0003,0804,000 4370INSURANCE1,0001,000000 4380SUBSCRIPTIONS & MEMBERSHIPS505560700330700 4390TRAVEL & TRAINING06259103,0003,000 4400VEHICLE ALLOWANCE02030300300 4430REPAIRS & MTNCE./EQUIPMENT00000 4480FEES FOR SERVICE39,24729,93019,46625,00027,000 4490FEES - CONSULTING00000 4520OUTSIDE RENTAL - EQUIPMENT01150300300 4530OUTSIDE RENTAL-PROPERTY/BLD00000 4540INTERNAL RENTAL - VEHICLE00000 4550DUPLICATING COSTS7,3646,6077,5005,0457,200 4580INTERNAL I. T. CHARGES39,75038,80039,90026,60041,100 TOTAL CONTRACTUAL SERVICES 98,40092,10392,30061,65795,200 4630EQUIPMENT - OFFICE00000 4640EQUIPMENT - OTHER00000 4730BUILDING IMPROVEMENT00000 TOTAL CAPITAL OUTLAY & DEPN 00000 4940CASH OVER & SHORT2844000 4945UNCOLLECTIBLE CHECKS00000 TOTAL OTHER CHARGES 2844000 DEPT/DIV TOTALS670,587560,452623,750385,283679,902 Council Special Meeting Packet Page Number 58 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 303DEPUTY REGISTRAR 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES317,616440,114386,900178,693346,553 4011OVERTIME PAY1,2414121,0005640 4020WAGES/PART-TIME180,643149,489177,98099,824106,691 4025WAGES/TEMPORARY00000 4030LEAVE BENEFITS4,2365,9898,3605,5764,532 4040RETIREMENT BENEFITS73,47678,937101,47067,64877,807 4050INSURANCE BENEFITS51,18064,04384,55056,36862,004 4090WORKERS' COMPENSATION3,9505,7204,2902,8603,936 TOTAL PERSONNEL SERVICES 632,343744,704764,550411,533601,523 4110SUPPLIES - OFFICE3,4662,3432,5002,6162,700 4160SUPPLIES - EQUIPMENT3,5603,1151,8001881,700 4165SMALL EQUIPMENT00000 TOTAL COMMODITIES 7,0275,4574,3002,8044,400 4310TELEPHONE1381712001,269200 4315INTERNAL PHONE CHARGES00000 4330POSTAGE5,6973,8975,5001,9165,000 4370INSURANCE00000 4380SUBSCRIPTIONS & MEMBERSHIPS07701,0005501,100 4390TRAVEL & TRAINING00444200900 4400VEHICLE ALLOWANCE6406290700500 4480FEES FOR SERVICE2898469,7696001,700 4530OUTSIDE RENTAL-PROPERTY/BLD00000 4550DUPLICATING COSTS5,3355,8106,5002,6696,000 4580INTERNAL I. T. CHARGES39,75038,80039,90026,60041,100 TOTAL CONTRACTUAL SERVICES 51,84950,92254,60043,21756,500 4630EQUIPMENT - OFFICE00000 4730BUILDING IMPROVEMENT00000 TOTAL CAPITAL OUTLAY & DEPN 00000 4940CASH OVER & SHORT239-14408090 TOTAL OTHER CHARGES 239-14400809 DEPT/DIV TOTALS691,458800,938823,450458,362662,423 Council Special Meeting Packet Page Number 59 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 304ELECTIONS 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES2,628004810 4011OVERTIME PAY2,78205,5001,8530 4020WAGES/PART-TIME00000 4025WAGES/TEMPORARY79,068088,0001,0440 4040RETIREMENT BENEFITS6,9967,0097,5705,0480 TOTAL PERSONNEL SERVICES 91,4757,009101,0708,4260 4110SUPPLIES - OFFICE1,419311,500397500 4120PROGRAM SUPPLIES97801,0002470 4160SUPPLIES - EQUIPMENT11901,400334500 TOTAL COMMODITIES 2,516313,9009771,000 4310TELEPHONE1,00901,2002920 4330POSTAGE6712521,200311200 4360PUBLISHING2,80702,80000 4370INSURANCE00000 4390TRAVEL & TRAINING00000 4400VEHICLE ALLOWANCE477060000 4430REPAIRS & MTNCE./EQUIPMENT16,08016,08021,30022,81124,000 4480FEES FOR SERVICE00000 4520OUTSIDE RENTAL - EQUIPMENT0428300285300 4530OUTSIDE RENTAL-PROPERTY/BLD00000 4550DUPLICATING COSTS77019130000 TOTAL CONTRACTUAL SERVICES 21,81416,95127,70023,69924,500 4640EQUIPMENT - OTHER00000 TOTAL CAPITAL OUTLAY & DEPN 00000 DEPT/DIV TOTALS115,80523,991132,67033,10225,500 Council Special Meeting Packet Page Number 60 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 401POLICE 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES5,226,2875,129,3353,181,6135,745,5006,401,518 4011OVERTIME PAY350,586457,399258,902390,000409,989 4020WAGES/PART-TIME34,96016,389065,24050,166 4025WAGES/TEMPORARY6,2989,85818,91912,00036,975 4030LEAVE BENEFITS63,51678,38358,10487,16064,015 4040RETIREMENT BENEFITS1,230,9721,223,389842,9201,264,3801,396,818 4050INSURANCE BENEFITS830,880848,375564,568846,850976,005 4090WORKERS' COMPENSATION281,780415,260293,180439,770503,951 TOTAL PERSONNEL SERVICES 8,025,2798,178,3885,218,2068,850,9009,839,437 4110SUPPLIES - OFFICE7,8265,36913,6003,3698,000 4120PROGRAM SUPPLIES45,09779,50532,20019,28545,000 4140SUPPLIES - VEHICLE4158103,2002320 4150 SUPPLIES - RANGE00000 4160SUPPLIES - EQUIPMENT77,422118,04798,40065,054110,000 4165SMALL EQUIPMENT50,61137,50015,80015,47615,000 4170BOOKS00000 4210FUEL & OIL65,49454,53093,00017,44393,000 4240UNIFORMS & CLOTHING61,51295,73070,30067,63089,000 4290MISCELLANEOUS COMMODITIES7,5982,99715,00012,67415,000 TOTAL COMMODITIES 315,975394,487341,500201,163375,000 4310TELEPHONE39,54642,78344,00024,80044,000 4315INTERNAL PHONE CHARGES00000 4330POSTAGE2,6332,6012,6001,7812,700 4370INSURANCE73,00073,000110,00073,333110,000 4380SUBSCRIPTIONS & MEMBERSHIPS10,13017,41916,00031,49220,000 4390TRAVEL & TRAINING30,85063,35365,23762,00080,000 4391EDUCATION REIMBURSEMENTS00000 4400VEHICLE ALLOWANCE49211000 4420REPAIR & MAINT/VEHICLE61,56265,53023,053106,20075,000 4430REPAIRS & MTNCE./EQUIPMENT9,1644,3152,03815,00012,000 4440REPAIR & MAINT/RADIO14,7078,5963,83111,70010,000 4475FEES FOR DISPATCHING361,220355,519206,255353,600293,624 4480FEES FOR SERVICE241,499240,577310,009327,400490,000 4482PROSECUTION FEES196,050195,000113,750198,000201,960 4490FEES - CONSULTING00000 4520OUTSIDE RENTAL - EQUIPMENT01,96485500 4530OUTSIDE RENTAL-PROPERTY/BLD00000 4540INTERNAL RENTAL/EQUIPMENT00000 4550DUPLICATING COSTS7,9987,86311,0004,4729,000 4580INTERNAL I. T. CHARGES292,880286,000294,500196,333303,335 TOTAL CONTRACTUAL SERVICES 1,341,2871,364,7301,552,0001,057,2401,651,619 4610VEHICLES00000 4630EQUIPMENT - OFFICE00000 4640EQUIPMENT - OTHER00000 4730BUILDING IMPROVEMENT00000 TOTAL CAPITAL OUTLAY & DEPN 00000 4940CASH OVER & SHORT000-80 4945UNCOLLECTIBLE CHECKS00000 TOTAL OTHER CHARGES 0000-8 DEPT/DIV TOTALS9,682,5419,937,6066,476,60010,744,40011,866,056 Council Special Meeting Packet Page Number 61 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 404FIRE 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES1,081,1361,047,2731,096,220693,8701,309,854 4011OVERTIME PAY178,390244,141160,000148,296196,607 4020WAGES/PART-TIME21,94153,48974,00015,0510 4025WAGES/TEMPORARY4,3592,7725,0006,9305,075 4030LEAVE BENEFITS11,13615,06017,55011,70413,098 4040RETIREMENT BENEFITS274,356258,217280,190186,792318,762 4050INSURANCE BENEFITS183,636172,069176,260117,504232,964 4060FIREFIGHTERS PENSION BENEFIT00000 4090WORKERS' COMPENSATION87,830116,640103,70069,133110,632 TOTAL PERSONNEL SERVICES 1,842,7841,909,6611,912,9201,249,2812,186,992 4110SUPPLIES - OFFICE1,1161,4151,0009181,300 4120PROGRAM SUPPLIES4,67310,6667,5002,7095,000 4130SUPPLIES - JANITORIAL2,9622,4262,4002,4062,600 4140SUPPLIES - VEHICLE9109250251255 4160SUPPLIES - EQUIPMENT63,22822,20758,00020,30250,000 4165SMALL EQUIPMENT2,66956,79635,000030,000 4170BOOKS1,7738241,2501,3091,300 4180MAINTENANCE MATERIALS0319000 4190CHEMICALS00000 4210FUEL & OIL15,08213,41820,0004,44420,000 4220SIGNS & SIGNALS00000 4230SMALL TOOLS0001780 4240UNIFORMS & CLOTHING22,36825,94724,00011,38924,500 4290MISCELLANEOUS COMMODITIES00000 TOTAL COMMODITIES 113,881134,128149,40043,905134,955 4310TELEPHONE10,84812,08411,0007,66912,100 4315INTERNAL PHONE CHARGES00000 4320UTILITIES30,59030,39932,00020,83632,500 4330POSTAGE201313250190400 4360PUBLISHING00000 4370INSURANCE21,30021,30013,0008,66713,000 4380SUBSCRIPTIONS & MEMBERSHIPS3,7119,0073,7505,2693,750 4390TRAVEL & TRAINING18,24855,52429,91247,50048,500 4391EDUCATION REIMBURSEMENTS00000 4400VEHICLE ALLOWANCE00000 4410REPAIR & MAINT/BUILDINGS7,87318,09110,00014,10810,000 4420REPAIR & MAINT/VEHICLE49,03841,39760,00023,56950,000 4430REPAIRS & MTNCE./EQUIPMENT4,98014,2135,0008,5377,500 4440REPAIR & MAINT/RADIO3,3051,6382,0002512,000 4475FEES FOR DISPATCHING71,16670,04370,00040,02021,355 4480FEES FOR SERVICE69,59546,804100,00040,88975,000 4520OUTSIDE RENTAL - EQUIPMENT02,6133,0001,3023,000 4540INTERNAL RENTAL - VEHICLE00000 4550DUPLICATING COSTS2,1142,2023,5001,1712,500 4580INTERNAL I. T. CHARGES75,79074,00076,20050,80078,485 TOTAL CONTRACTUAL SERVICES 368,757399,627437,200253,190360,090 4610VEHICLES00000 4630EQUIPMENT - OFFICE00000 4640EQUIPMENT - OTHER00000 4730BUILDING IMPROVEMENT00000 TOTAL CAPITAL OUTLAY & DEPN 00000 DEPT/DIV TOTALS2,325,4232,443,4151,546,3762,499,5202,682,037 Council Special Meeting Packet Page Number 62 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 413EMERGENCY MANAGEMENT 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4020WAGES/PART-TIME00000 4025WAGES/TEMPORARY00000 4040RETIREMENT BENEFITS00000 TOTAL PERSONNEL SERVICES 00000 4110SUPPLIES - OFFICE45418425000 4120PROGRAM SUPPLIES4,85743525000 4160SUPPLIES - EQUIPMENT242,57429,30705,8300 4165SMALL EQUIPMENT59,8030000 4210FUEL & OIL00000 4240UNIFORMS & CLOTHING00000 TOTAL COMMODITIES 307,68829,9265005,8300 4310TELEPHONE0040000 4315INTERNAL PHONE CHARGES00000 4320UTILITIES3325966004390 4330POSTAGE01000 4370INSURANCE500500500333500 4380SUBSCRIPTIONS & MEMBERSHIPS00300180300 4390TRAVEL & TRAINING00000 4400VEHICLE ALLOWANCE00000 4420REPAIR & MAINT/VEHICLE00000 4430REPAIRS & MTNCE./EQUIPMENT6,1327,1847,5006,3327,000 4480FEES FOR SERVICE111,81338,50403,9800 4550DUPLICATING COSTS00000 4580INTERNAL I. T. CHARGES00000 TOTAL CONTRACTUAL SERVICES 118,77746,7869,30011,2647,800 4640EQUIPMENT - OTHER13,4510000 TOTAL CAPITAL OUTLAY & DEPN 13,4510000 DEPT/DIV TOTALS439,91676,7119,80017,0947,800 Council Special Meeting Packet Page Number 63 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 501PUBLIC WORKS ADMINISTRATION 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES104,323119,730123,01075,356136,932 4011OVERTIME PAY36951000 4020WAGES/PART-TIME00000 4025WAGES/TEMPORARY00000 4030LEAVE BENEFITS1,2481,6321,8501,2321,369 4040RETIREMENT BENEFITS20,79621,09722,19014,79224,855 4050INSURANCE BENEFITS21,51621,51721,65014,43230,456 TOTAL PERSONNEL SERVICES 148,251164,027168,700105,812193,612 4110SUPPLIES - OFFICE2,0162,3203,0001,7643,000 4120PROGRAM SUPPLIES00000 4160SUPPLIES - EQUIPMENT452893,0001,1583,000 4165SMALL EQUIPMENT00000 4170BOOKS110000 4210FUEL & OIL00000 4290MISCELLANEOUS COMMODITIES00000 TOTAL COMMODITIES 2,0722,6086,0002,9226,000 4310TELEPHONE341532000200 4315INTERNAL PHONE CHARGES00000 4330POSTAGE3,2493,3555,0001,9373,500 4370INSURANCE00000 4380SUBSCRIPTIONS & MEMBERSHIPS3,0603,0973,2003,3094,500 4390TRAVEL & TRAINING01502004,0004,000 4400VEHICLE ALLOWANCE480520280500500 4430REPAIRS & MTNCE./EQUIPMENT0001,0000 4480FEES FOR SERVICE41,92257,98531,54612,00043,000 4490FEES - CONSULTING0006,0006,000 4520OUTSIDE RENTAL - EQUIPMENT00000 4530OUTSIDE RENTAL-PROPERTY/BLD00000 4550DUPLICATING COSTS6,3325,1896,5003,5126,500 4580INTERNAL I. T. CHARGES127,840124,700128,40085,600132,250 TOTAL CONTRACTUAL SERVICES 182,917195,150166,800126,384200,450 4630EQUIPMENT - OFFICE00000 4710LAND PURCHASE00000 4730BUILDING IMPROVEMENT00000 4759OTHER CONSTRUCTION COSTS00000 TOTAL CAPITAL OUTLAY & DEPN 00000 4940CASH OVER & SHORT00000 4945UNCOLLECTIBLE CHECKS00000 TOTAL OTHER CHARGES 00000 DEPT/DIV TOTALS333,240361,785341,500235,118400,062 Council Special Meeting Packet Page Number 64 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 502STREET MAINTAINANCE 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES320,090306,539329,680113,761349,671 4011OVERTIME PAY12,9028,3007,0002,68610,185 4020WAGES/PART-TIME00000 4025WAGES/TEMPORARY007,20001,015 4030LEAVE BENEFITS3,9844,4634,9503,3043,497 4040RETIREMENT BENEFITS58,42857,73259,76039,84060,799 4050INSURANCE BENEFITS67,21267,22367,59045,06477,918 4090WORKERS' COMPENSATION69,580103,980108,61072,40776,257 TOTAL PERSONNEL SERVICES 532,196548,237584,790277,062579,342 4120PROGRAM SUPPLIES001,00000 4140SUPPLIES - VEHICLE00000 4160SUPPLIES - EQUIPMENT2,3603,1064,0002,2674,000 4165SMALL EQUIPMENT5,5376,8996,00006,000 4180MAINTENANCE MATERIALS93,203100,363100,00034,312100,000 4190CHEMICALS00000 4210FUEL & OIL20,27718,39128,0007,55726,000 4220SIGNS & SIGNALS10,48214,65914,0009,26515,000 4230SMALL TOOLS03925000500 4240UNIFORMS & CLOTHING9,0069,74710,0004,50810,000 4290MISCELLANEOUS COMMODITIES00000 TOTAL COMMODITIES 140,865153,557163,50057,908161,500 4310TELEPHONE6,7917,13710,0005,0538,000 4315INTERNAL PHONE CHARGES00000 4320UTILITIES00000 4370INSURANCE25,00025,00020,00013,33320,000 4380SUBSCRIPTIONS & MEMBERSHIPS15001000150 4390TRAVEL & TRAINING4051206,6653,0003,000 4400VEHICLE ALLOWANCE00000 4430REPAIRS & MTNCE./EQUIPMENT0001,0001,000 4480FEES FOR SERVICE31,10425,4683,44735,00035,000 4490FEES - CONSULTING00000 4520OUTSIDE RENTAL - EQUIPMENT1500000 4530OUTSIDE RENTAL-PROPERTY/BLD0003,0000 4540INTERNAL RENTAL - VEHICLE170,000170,000124,667187,000205,700 TOTAL CONTRACTUAL SERVICES 233,600227,724153,165259,100272,850 4610VEHICLES00000 4630EQUIPMENT - OFFICE00000 4640EQUIPMENT - OTHER00000 4710LAND PURCHASE00000 4730BUILDING IMPROVEMENT00000 4759OTHER CONSTRUCTION COSTS00000 TOTAL CAPITAL OUTLAY & DEPN 00000 4975SMALL LIABILITY CLAIMS00000 TOTAL OTHER CHARGES 00000 DEPT/DIV TOTALS906,662929,5191,007,390488,1361,013,692 Council Special Meeting Packet Page Number 65 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 503ENGINEERING 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES386,316397,720410,580252,020482,418 4011OVERTIME PAY27,76392725,0003,19216,800 4020WAGES/PART-TIME00000 4025WAGES/TEMPORARY8,3978,12820,0005,90410,150 4030LEAVE BENEFITS4,4885,4376,1604,1044,824 4040RETIREMENT BENEFITS71,91672,16975,83050,55292,739 4050INSURANCE BENEFITS67,77667,77570,32046,88091,934 TOTAL PERSONNEL SERVICES 566,656552,156607,890362,652698,865 4110SUPPLIES - OFFICE00000 4160SUPPLIES - EQUIPMENT6,6603231,5003,8956,000 4165SMALL EQUIPMENT00000 4170BOOKS00000 4230SMALL TOOLS0451,0001,0932,000 4240UNIFORMS & CLOTHING04541,000251,000 4290MISCELLANEOUS COMMODITIES002,00002,000 TOTAL COMMODITIES 6,6608225,5005,01411,000 4310TELEPHONE4,1274,0874,6002,0354,500 4315INTERNAL PHONE CHARGES00000 4360PUBLISHING00000 4370INSURANCE00000 4380SUBSCRIPTIONS & MEMBERSHIPS6562285002,6141,000 4390TRAVEL & TRAINING1,4191,7351,6024,0004,000 4391EDUCATION REIMBURSEMENTS00000 4400VEHICLE ALLOWANCE480520280200500 4430REPAIRS & MTNCE./EQUIPMENT2,3882,00008,0008,000 4480FEES FOR SERVICE13,0833,05513412,00012,000 4490FEES - CONSULTING4,3802,6401,18812,00012,000 4520OUTSIDE RENTAL - EQUIPMENT00000 4540INTERNAL RENTAL - VEHICLE30,00030,00022,00033,00036,300 TOTAL CONTRACTUAL SERVICES 56,53244,26429,85274,30078,300 4610VEHICLES00000 4630EQUIPMENT - OFFICE00000 4640EQUIPMENT - OTHER00019,7180 4761LEGAL & FISCAL00000 TOTAL CAPITAL OUTLAY & DEPN 000019,718 DEPT/DIV TOTALS629,848597,242687,690417,237788,165 Council Special Meeting Packet Page Number 66 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 514SNOW AND ICE CONTROL 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES156,169161,010148,620115,110156,821 4011OVERTIME PAY6,96622,08430,00017,98826,190 4020WAGES/PART-TIME00000 4025WAGES/TEMPORARY00000 4030LEAVE BENEFITS1,8362,0172,2301,4881,568 4040RETIREMENT BENEFITS30,25229,97530,66020,44021,107 4050INSURANCE BENEFITS31,96831,88332,07021,38422,662 TOTAL PERSONNEL SERVICES 227,192246,970243,580176,410228,348 4120PROGRAM SUPPLIES00000 4140SUPPLIES - VEHICLE00000 4160SUPPLIES - EQUIPMENT8333395,0001,0423,000 4165SMALL EQUIPMENT00000 4180MAINTENANCE MATERIALS80,16164,47690,00069,055105,000 4190CHEMICALS00000 4210FUEL & OIL00000 4220SIGNS & SIGNALS00000 4230SMALL TOOLS023000 4240UNIFORMS & CLOTHING004000400 4290MISCELLANEOUS COMMODITIES00000 TOTAL COMMODITIES 80,99464,83895,40070,097108,400 4310TELEPHONE9841,0351,0005531,100 4320UTILITIES00000 4370INSURANCE00000 4380SUBSCRIPTIONS & MEMBERSHIPS00000 4390TRAVEL & TRAINING2,4002,1002,50002,500 4400VEHICLE ALLOWANCE00000 4430REPAIRS & MTNCE./EQUIPMENT00000 4480FEES FOR SERVICE3,0016693,0002203,000 4490FEES - CONSULTING00000 4520OUTSIDE RENTAL - EQUIPMENT00000 4540INTERNAL RENTAL - VEHICLE200,000200,000220,000146,667242,000 TOTAL CONTRACTUAL SERVICES 206,385203,804226,500147,440248,600 4610VEHICLES00000 4630EQUIPMENT - OFFICE00000 4640EQUIPMENT - OTHER00014,0350 4710LAND PURCHASE00000 4730BUILDING IMPROVEMENT00000 4759OTHER CONSTRUCTION COSTS00000 TOTAL CAPITAL OUTLAY & DEPN 000014,035 DEPT/DIV TOTALS514,570515,611565,480407,981585,348 Council Special Meeting Packet Page Number 67 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 516FORESTRY 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES49,004104,591105,85094,407117,564 4011OVERTIME PAY2,2641,60402,5482,425 4020WAGES/PART-TIME00000 4030LEAVE BENEFITS1,1161,4031,5901,0641,176 4040RETIREMENT BENEFITS18,45617,76018,61012,40820,058 4050INSURANCE BENEFITS21,79221,90022,00014,66425,770 TOTAL PERSONNEL SERVICES 92,632147,258148,050125,091166,993 4140SUPPLIES - VEHICLE00000 4160SUPPLIES - EQUIPMENT5,2802,7902,0002,2855,000 4165SMALL EQUIPMENT02,3002,00002,000 4210FUEL & OIL00000 4240UNIFORMS & CLOTHING00000 TOTAL COMMODITIES 5,2805,0904,0002,2857,000 4310TELEPHONE249260300330300 4370INSURANCE00000 4390TRAVEL & TRAINING001,30000 4420REPAIR & MAINT/VEHICLE00000 4480FEES FOR SERVICE72,640121,751108,00026,850130,000 4520OUTSIDE RENTAL - EQUIPMENT00000 TOTAL CONTRACTUAL SERVICES 72,889122,011109,60027,181130,300 DEPT/DIV TOTALS170,801274,358261,650154,557304,293 Council Special Meeting Packet Page Number 68 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 601PARKS & REC. ADMINISTRATION 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES91,612203,068224,740136,761238,237 4011OVERTIME PAY005,0002862,000 4025WAGES/TEMPORARY93531,38530,00022,79331,030 4030LEAVE BENEFITS1,3922,7833,3702,2482,382 4040RETIREMENT BENEFITS24,76839,90046,29030,86446,159 4050INSURANCE BENEFITS19,41624,00027,80018,53630,296 4090WORKERS' COMPENSATION11,63015,7709,3506,23311,964 TOTAL PERSONNEL SERVICES 149,753316,906346,550217,720362,068 4530OUTSIDE RENTAL-PROPERTY/BLD000029,000 000029,000 4110SUPPLIES - OFFICE1,1807012,5001,4952,500 4120PROGRAM SUPPLIES1,5811,7247,5002,9157,500 4160SUPPLIES - EQUIPMENT01,7665000500 4165SMALL EQUIPMENT00000 4170BOOKS00000 TOTAL COMMODITIES 2,7614,19010,5004,41010,500 4310TELEPHONE1,7783,3384,8003,1904,500 4315INTERNAL PHONE CHARGES00000 4330POSTAGE9044872,5004561,000 4360PUBLISHING01253000300 4370INSURANCE00000 4380SUBSCRIPTIONS & MEMBERSHIPS9101,0101,1009451,100 4390TRAVEL & TRAINING041901,5001,500 4400VEHICLE ALLOWANCE7002,6001,4009002,800 4430REPAIRS & MTNCE./EQUIPMENT8625326132,8002,500 4480FEES FOR SERVICE2,8613,3424,56217,00017,000 4490FEES - CONSULTING0001,5001,500 4520OUTSIDE RENTAL - EQUIPMENT000500500 4540INTERNAL RENTAL - VEHICLE00000 4550DUPLICATING COSTS1,7283,3672,7001,0194,900 4580INTERNAL I. T. CHARGES21,20020,70021,30014,20021,940 TOTAL CONTRACTUAL SERVICES 30,94335,91956,90026,38559,540 4630EQUIPMENT - OFFICE00000 TOTAL CAPITAL OUTLAY & DEPN 00000 DEPT/DIV TOTALS183,458357,016413,950248,515461,108 Council Special Meeting Packet Page Number 69 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 602PARK MAINTENANCE 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES380,006374,610373,310222,556384,206 4011OVERTIME PAY5,4358,2648,0009,8387,998 4020WAGES/PART-TIME00000 4025WAGES/TEMPORARY014,97620,0001,92014,972 4030LEAVE BENEFITS4,4765,2575,6003,7363,842 4040RETIREMENT BENEFITS70,22468,83267,88045,25634,397 4050INSURANCE BENEFITS79,08079,03277,68051,784111,057 4090WORKERS' COMPENSATION34,90023,65014,0209,34717,946 TOTAL PERSONNEL SERVICES 574,120574,621566,490344,438574,418 4120PROGRAM SUPPLIES04,07000500 4130SUPPLIES - JANITORIAL02510182200 4160SUPPLIES - EQUIPMENT16,39313,50618,00010,01918,300 4165SMALL EQUIPMENT3,8500002,000 4170BOOKS00000 4180MAINTENANCE MATERIALS32,20641,70937,00024,03442,000 4210FUEL & OIL14,43614,97520,0004,20520,000 4220SIGNS & SIGNALS00000 4230SMALL TOOLS0279500798500 4240UNIFORMS & CLOTHING4,3106,6145,5001,4255,500 4290MISCELLANEOUS COMMODITIES00000 TOTAL COMMODITIES 71,19581,40581,00040,66389,000 4310TELEPHONE2,8533,3183,0002,3183,500 4315INTERNAL PHONE CHARGES00000 4320UTILITIES56,14073,35959,70042,55575,000 4370INSURANCE23,00023,00047,00031,33347,000 4380SUBSCRIPTIONS & MEMBERSHIPS00077150 4390TRAVEL & TRAINING1,5303,5901454,0004,000 4400VEHICLE ALLOWANCE00000 4410REPAIR & MAINT/BUILDINGS04006351,0001,000 4420REPAIR & MAINT/VEHICLE0005,0003,000 4430REPAIRS & MTNCE./EQUIPMENT394784001,000 4480FEES FOR SERVICE53,34363,30941,34149,00050,000 4490FEES - CONSULTING00000 4520OUTSIDE RENTAL - EQUIPMENT1,0021,9113,50003,500 4540INTERNAL RENTAL - VEHICLE198,000198,000218,000145,333239,800 TOTAL CONTRACTUAL SERVICES 336,261367,671390,200263,738427,950 4610VEHICLES00000 4630EQUIPMENT - OFFICE00000 4640EQUIPMENT - OTHER15,8860000 4720LAND IMPROVEMENT00000 4730BUILDING IMPROVEMENT00000 TOTAL CAPITAL OUTLAY & DEPN 15,8860000 4970JUDGEMENTS & LOSSES00000 TOTAL OTHER CHARGES 00000 DEPT/DIV TOTALS997,4611,023,6971,037,690648,8381,091,368 Council Special Meeting Packet Page Number 70 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 603RECREATION PROGRAMS 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES172,0080000 4011OVERTIME PAY00000 4025WAGES/TEMPORARY20,3740000 4030LEAVE BENEFITS2,1720000 4040RETIREMENT BENEFITS44,1960000 4050INSURANCE BENEFITS34,0800000 4025WAGES/TEMPORARY2,4590000 4040RETIREMENT BENEFITS00000 4025WAGES/TEMPORARY5,9330000 4040RETIREMENT BENEFITS00000 TOTAL PERSONNEL SERVICE 281,2210000 S 4120PROGRAM SUPPLIES7,0920000 4240UNIFORMS & CLOTHING00000 4120PROGRAM SUPPLIES00000 4120PROGRAM SUPPLIES00000 TOTAL COMMODITIES 7,0920000 4310TELEPHONE1,4610000 4330POSTAGE4,8460000 4360PUBLISHING7,9050000 4370INSURANCE00000 4390TRAVEL & TRAINING00000 4400VEHICLE ALLOWANCE3000000 4480FEES FOR SERVICE27,2400000 4490FEES - CONSULTING00000 4530OUTSIDE RENTAL-PROPERTY/BLD44,7180000 4580INTERNAL I. T. CHARGES32,2200000 4480FEES FOR SERVICE18,4070000 4530OUTSIDE RENTAL-PROPERTY/BLD1,3170000 4480FEES FOR SERVICE2,4200000 4530OUTSIDE RENTAL-PROPERTY/BLD2,7240000 TOTAL CONTRACTUAL SERVICES 143,5580000 4660CONSTRUCTION - BUILDING00000 TOTAL CAPITAL OUTLAY & DEPN 00000 4940CASH OVER & SHORT00000 TOTAL OTHER CHARGES 00000 DEPT/DIV TOTALS431,8720000 Council Special Meeting Packet Page Number 71 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 604NATURE CENTER 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES28,1950000 4011OVERTIME PAY00000 4020WAGES/PART-TIME52,9030000 4025WAGES/TEMPORARY190000 4030LEAVE BENEFITS1,6200000 4040RETIREMENT BENEFITS25,5480000 4050INSURANCE BENEFITS9,8760000 TOTAL PERSONNEL SERVICES 118,1610000 4110SUPPLIES - OFFICE810000 4120PROGRAM SUPPLIES1,6560000 4130SUPPLIES - JANITORIAL00000 4160SUPPLIES - EQUIPMENT1,5500000 4165SMALL EQUIPMENT00000 4170BOOKS00000 4180MAINTENANCE MATERIALS1500000 4190CHEMICALS00000 4210FUEL & OIL00000 4220SIGNS & SIGNALS00000 4230SMALL TOOLS00000 4240UNIFORMS & CLOTHING00000 4290MISCELLANEOUS COMMODITIES00000 TOTAL COMMODITIES 3,4380000 4310TELEPHONE1,3801,117000 4315INTERNAL PHONE CHARGES00000 4320UTILITIES3,2314,239000 4330POSTAGE1530000 4360PUBLISHING1210000 4370INSURANCE6,0006,000000 4380SUBSCRIPTIONS & MEMBERSHIPS3460000 4390TRAVEL & TRAINING1950000 4391EDUCATION REIMBURSEMENTS00000 4400VEHICLE ALLOWANCE7730000 4410REPAIR & MAINT/BUILDINGS5150000 4430REPAIRS & MTNCE./EQUIPMENT500000 4480FEES FOR SERVICE3,980342000 4520OUTSIDE RENTAL - EQUIPMENT00000 4530OUTSIDE RENTAL-PROPERTY/BLD00000 4540INTERNAL RENTAL - VEHICLE00000 4550DUPLICATING COSTS2,9021,327000 TOTAL CONTRACTUAL SERVICES 19,64613,025000 4600UNDESIG. CAPITAL OUTLAY00000 4630EQUIPMENT - OFFICE00000 4640EQUIPMENT - OTHER00000 4660CONSTRUCTION - BUILDING00000 4690CONSTRUCTION - OTHER00000 4720LAND IMPROVEMENT00000 4730BUILDING IMPROVEMENT00000 TOTAL CAPITAL OUTLAY & DEPN 00000 4940CASH OVER & SHORT00000 TOTAL OTHER CHARGES 00000 DEPT/DIV TOTALS141,24413,025000 Council Special Meeting Packet Page Number 72 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 605OPEN SPACE MANAGEMENT 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES15,22620,79221,92013,46723,547 4011OVERTIME PAY000800 4020WAGES/PART-TIME7,6080000 4025WAGES/TEMPORARY007,00000 4030LEAVE BENEFITS312275330224235 4040RETIREMENT BENEFITS6,3123,8894,3202,8807,395 4050INSURANCE BENEFITS3,3723,3353,3602,2403,606 TOTAL PERSONNEL SERVICES 32,83028,29136,93018,89134,783 4110SUPPLIES - OFFICE0030037300 4120PROGRAM SUPPLIES08870039700 4160SUPPLIES - EQUIPMENT1,417216800320800 4165SMALL EQUIPMENT00000 4170BOOKS000720 4180MAINTENANCE MATERIALS2843092,0003152,000 4190CHEMICALS003000300 4210FUEL & OIL00000 4220SIGNS & SIGNALS00000 4240UNIFORMS & CLOTHING00000 TOTAL COMMODITIES 1,7016134,1007834,100 4310TELEPHONE00000 4360PUBLISHING00000 4370INSURANCE00000 4390TRAVEL & TRAINING0250500250500 4400VEHICLE ALLOWANCE26505000500 4480FEES FOR SERVICE9,4753,20615,0005,91915,000 4490FEES - CONSULTING00000 4520OUTSIDE RENTAL - EQUIPMENT2760300974300 4530OUTSIDE RENTAL-PROPERTY/BLD00000 TOTAL CONTRACTUAL SERVICES 10,0163,45616,3007,14316,300 4610VEHICLES00000 4630EQUIPMENT - OFFICE00000 4640EQUIPMENT - OTHER00000 4690CONSTRUCTION - OTHER00000 4720LAND IMPROVEMENT00000 TOTAL CAPITAL OUTLAY & DEPN 00000 DEPT/DIV TOTALS44,54732,36057,33026,81755,183 Council Special Meeting Packet Page Number 73 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 622LIGHT IT UP MAPLEWOOD 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4025WAGES/TEMPORARY036001,7301,095 TOTAL PERSONNEL SERVICES 036001,7301,095 4120PROGRAM SUPPLIES06022,3002,1032,300 TOTAL COMMODITIES 06022,3002,1032,300 4360PUBLISHING00000 4370INSURANCE50050000500 4480FEES FOR SERVICE4,73117,88424,00023,82025,000 4520OUTSIDE RENTAL - EQUIPMENT80009,0003,5008,000 TOTAL CONTRACTUAL SERVICES 6,03118,38433,00027,32033,500 DEPT/DIV TOTALS6,03119,34635,30031,15436,895 Council Special Meeting Packet Page Number 74 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 701COMMUNITY DEVELOPMENT ADMIN. 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES411,989458,704415,350223,477440,141 4011OVERTIME PAY2,1036,21705192,016 4020WAGES/PART-TIME32,87950,634129,58070,696147,948 4025WAGES/TEMPORARY002,00000 4030LEAVE BENEFITS4,6926,7578,1705,4485,881 4040RETIREMENT BENEFITS83,91687,74396,72064,48099,602 4050INSURANCE BENEFITS77,12483,71263,87042,58472,127 4090WORKERS' COMPENSATION4,4806,4904,8603,2404,461 TOTAL PERSONNEL SERVICES 617,184700,257720,550410,444772,176 4110SUPPLIES - OFFICE2,5722,5483,0001,5573,000 4120PROGRAM SUPPLIES3290000 4160SUPPLIES - EQUIPMENT6923042,00002,000 4165SMALL EQUIPMENT00000 4170BOOKS00000 4220SIGNS & SIGNALS00000 4290MISCELLANEOUS COMMODITIES00000 TOTAL COMMODITIES 3,5922,8525,0001,5575,000 4310TELEPHONE4,2394,4874,3002,9704,500 4315INTERNAL PHONE CHARGES00000 4330POSTAGE2,7985,7915,0002,5906,000 4360PUBLISHING001,00001,000 4370INSURANCE24,00024,00027,20018,13327,200 4380SUBSCRIPTIONS & MEMBERSHIPS1,4161,7333,5001,5583,500 4390TRAVEL & TRAINING231999576,0006,000 4400VEHICLE ALLOWANCE2,4572,6001,4002,4002,400 4430REPAIRS & MTNCE./EQUIPMENT00000 4480FEES FOR SERVICE33,93945,29317,85530,00035,000 4490FEES - CONSULTING43,24221,86710,02025,00025,000 4520OUTSIDE RENTAL - EQUIPMENT00000 4530OUTSIDE RENTAL-PROPERTY/BLD00000 4550DUPLICATING COSTS5,6633,2846,4003,7386,000 4580INTERNAL I. T. CHARGES62,33060,80062,60041,73364,480 TOTAL CONTRACTUAL SERVICES 180,107170,055173,400100,953181,080 4630EQUIPMENT - OFFICE00000 TOTAL CAPITAL OUTLAY & DEPN 00000 4940CASH OVER & SHORT-41340490 4945UNCOLLECTIBLE CHECKS00000 TOTAL OTHER CHARGES-41340049 DEPT/DIV TOTALS800,880873,298898,950513,003958,256 Council Special Meeting Packet Page Number 75 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 703BUILDING INSPECTIONS 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4010WAGES/FULL-TIME EMPLOYEES286,624321,185404,110295,191435,236 4011OVERTIME PAY6,9308,52807,2408,679 4020WAGES/PART-TIME71,70874,13003,0950 4025WAGES/TEMPORARY22,946021,00005,075 4030LEAVE BENEFITS4,0566,2636,0604,0404,352 4040RETIREMENT BENEFITS75,22879,11573,06048,70478,050 4050INSURANCE BENEFITS55,83655,88370,08046,72080,876 4090WORKERS' COMPENSATION4,3606,8405,9903,9935,856 TOTAL PERSONNEL SERVICES 527,688551,944580,300408,984618,124 4120PROGRAM SUPPLIES051000 4160SUPPLIES - EQUIPMENT121,0312,0002802,000 4165SMALL EQUIPMENT00000 4170BOOKS2,6391,0165000500 4240UNIFORMS & CLOTHING6187901,5002703,000 TOTAL COMMODITIES 3,2692,8874,0005505,500 4310TELEPHONE3,9843,3834,0001,5193,600 4315INTERNAL PHONE CHARGES00000 4370INSURANCE00000 4380SUBSCRIPTIONS & MEMBERSHIPS2656411,0001231,000 4390TRAVEL & TRAINING3,0501,4151,9345,0005,000 4391EDUCATION REIMBURSEMENTS00000 4400VEHICLE ALLOWANCE640000 4410REPAIR & MAINT/BUILDINGS00000 4420REPAIR & MAINT/VEHICLE00000 4430REPAIRS & MTNCE./EQUIPMENT00000 4480FEES FOR SERVICE57,222109,20137,43265,00070,000 4540INTERNAL RENTAL - VEHICLE19,50019,50014,00021,00023,100 TOTAL CONTRACTUAL SERVICES 84,086134,13955,00896,000102,700 4610VEHICLES00000 4630EQUIPMENT - OFFICE00000 4730BUILDING IMPROVEMENT00000 TOTAL CAPITAL OUTLAY & DEPN 00000 DEPT/DIV TOTALS615,042688,971680,300464,542726,324 Council Special Meeting Packet Page Number 76 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 4998RESIDUAL EQUITY TRANSFERS OU00000 4999OPERATING TRANSFERS OUT356,0711,703,8331,500,00000 356,0711,703,8331,500,00000 DEPT/DIV TOTALS356,0711,703,8331,500,00000 Council Special Meeting Packet Page Number 77 of 78 D2, Attachment 2 CITY OF MAPLEWOOD EXPENDITURES BY ACCOUNT 101GENERAL FUND 999TRANSFERS 20202021202220222023 EXPENDEDEXPENDEDORIG BUDGTEXPEND YTDDEPT REQ 22,567,034.9823,776,108.3323,632,280.0015,789,130.1725,272,296.00 Council Special Meeting Packet Page Number 78 of 78