The URL can be used to link to this page

Home My WebLink AboutAgenda Packets - 2023/12/04 CITY OF MOUNDS VIEW CITY COUNCIL WORK SESSION AGENDA MOUNDS VIEW CITY HALL Monday, December 4, 2023 6:30 p.m. ROLL CALL: Lindstrom, Cermak, Gunn, Meehlhause Council Work Sessions are informal gatherings of the council at which no final decisions are made, rather consensus discussion to direct staff on council decision items. AGENDA ITEMS DISCUSSED BY CONSENSUS 1. Non Profits – CM Meehlhause 2. Tribute Park Concept Plan/Costs – Don 3. Stormwater/Wetland Update– Don 4. FD Update – Verbal Nyle 5. 2024 Proposed Tax Levy and Budget – Gayle 6. Commission Appointment Process - Council PUBLIC COMMENT Citizens may speak to issues not on tonight’s agenda. Before speaking, please share your full name and address. Also, please limit your comments to three minutes. NEXT COUNCIL WORK SESSION: Tuesday, January 2, 2024 at 6:00 pm NEXT COUNCIL MEETING: Monday, December 11, 2023 at 6:00 pm THIS PAGE LEFT BLANK INTENTIONALLY Item No: 2 Meeting Date: December 4, 2023 Type of Business: WS Administrator Review: ____ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Don Peterson, Director of Public Works/Parks and Recreation Item Title/Subject: Storm Water Update; Ardan Park, Silver View Park Storm Water Ponds / Ardan Park Wetland Banking Proposal Project Background/Discussion: The Public Works Department has many responsibilities and one is to efficiently operate and manage the storm water system. The system was first constructed in the 1970’s and as with other similar core functions, research, innovation and best management practices have changed over the years. Below is an overview of the projects provided by Dan Edgerton of Stantec Services: Ardan Park Storm Water Ponds: Data collection Field survey is done, except for maybe some minor follow-up Sediment coring was done as part of previous project. Sediment needs to be hauled to landfill. Upland vegetation summary memo was completed and reviewed with Don Peterson. Public engagement Mtg #1 was held on Thursday, 9/28, 5 pm. Meeting summary was submitted to Don Mtg #2 to be held after preliminary plans and concepts complete. The recommendations memo brought to the Park Commission before going to the City Council Second public meeting to be held at a City Council meeting, early 2024. Permitting- Wetlands Per Dan Scollan, MnDNR: As we discussed, please submit to DNR a written memo requesting removal of #62-60W from the DNR’s Public Water Inventory (PWI) and providing evidence to show that this waterbody is an error in the inventory. In other words, please provide evidence that #62-60W does not and did not meet the definition of a public water wetland – a natural type 3, 4, or 5 wetland, as defined in United States Fish and Wildlife Service Circular No. 39 (1971 edition), that is 2.5 or more acres in incorporated areas. Once received, I will work through DNR’s internal process to remove this waterbody from the PWI. Until it is officially removed, I am obligated to regulate it as a Public Water. John Smyth will prepare and submit memo to Dan Scollan We will then proceed with wetland permitting as needed Wetland delineation completed previously For WCA, need permit but no mitigation. Will call them incidental wetlands. Likely still need USACE permit. John will confirm. Kellie Schlegel will apply for Ramsey County ROW Permit (single form, after project bid) Upland vegetation evaluation and recommendations memo Not yet started – will be based on City review of summary memo and public input. Will develop high-level recommendations and cost estimates. Will then review with Don Peterson. Design and construction Based on public meeting comments, will review existing and proposed HWL in ponds relative to adjacent properties Have original grading plan for ponds. Will compare with field bathymetry. Probably restore to original grading plan. Need to determine access point(s). Kellie will discuss with Don Peterson. Will finalize 60% construction plans for review with City Will prepare specifications using Mounds View template. Upland vegetation management plan to be prepared following review of upland recommendations memo Silver View Strom Water Pond: Data collection In-pond veg surveys are done Sediment coring is done. Sediment needs to be hauled to landfill. Water quality sampling is done Upland vegetation summary memo was completed and reviewed with Don Peterson Wetland delineation field work was completed. Report expected shortly so TEP can get out and review. Field survey is scheduled to be completed in the next couple of weeks, with a focus on potential BMP locations Public engagement Mtg #1 was held on Thursday, 9/21, 5 pm. Meeting summary was submitted to Don Mtg #2 to be held after preliminary plans and concepts complete Take the recommendations to the Park Commission early 202, before going to the City Council Have the second public meeting at a City Council meeting, early 2024 Permitting Wetland permitting will be prepared as needed, subject to BMP selection Alum treatment submittal (if needed) will be prepared and submitted to MPCA Water quality assessment and watershed analysis o Based on public meeting comments, will review existing and proposed HWL in ponds relative to adjacent properties Preliminary analysis of water quality and sediment data and pond modeling have been performed, indicating majority of phosphorus loading is from the watershed and not internal loading Aquatic plant data has been assessed, showing primarily coontail and water lilies. Based on this result, we may not be allowed to remove the water lilies or coontail, as they are not non-native. We will follow up with the MnDNR on this, after which we will discuss with Don Peterson. P8 modeling has been performed Technical memo still needs to be prepared. It will cover: Data collection, analysis and modeling, results and recommendations Alum dosing, Aquatic plant community management, Spot dredging BMP recommendations – structural and non-structural (within park setting) Mapping Upland vegetation recommendations memo not yet started. Will be based on City review of summary memo and public input. Will develop high-level recommendations and cost estimates. Will then review with Don Peterson. Specific implementation actions still to be determined but could include: Alum treatment Aquatic plant management Spot dredging Watershed improvements Upland vegetation management (plan sheets) to be prepared following review of upland recommendations memo Ardan Park Wet Land Banking: September 2022 Stantec Engineering Services completed a wetland delineation in Ardan Park (map attached) as part of a development proposal. Stantec also indicated that the current wetland area, in addition to other green spaces, could be developed into a wetland banking project. The Engineer estimated that the City could develop wetland banking and sell these credits to developers, these credits were estimated to value 1 million dollars. The City Council directed Staff to look into the option of creating wetland banking in this area. An application was submitted notifying the following agencies of the project and for these agencies to provide the City with feedback regarding the proposed project. MN Department of Natural Resources (DNR), Rice Creek Watershed District (RCWD), Board of Water and Soil Resources (BWSR), Ramsey County and the U.S. Army Corps of Engineers (USACE). Staff has received comments from the Army Corps of Engineers. Staff and Stantec both believe the project is worth moving forward and after reviewing the comments from USACE. The next step moving forward would be meeting with the various agencies to clarify and respond to comments the City has received. Strategic Plan Strategy/Goal: Maintain and Plan for Infrastructure Improvements to ensure that proper storm water maintenance continues for the future requirements for Mounds View and its property owners. Financial Impact: No financial Impact to the 2023 Budget. Recommendation: Staff will be at the Work Session today to discuss the proposed projects. Respectfully submitted Don Peterson Director of Public Works / Parks and Recreation Attachments: Maps Ardan Park / Silver Park Storm Water Ponds Wetland Banking Maps The Mounds View Vision A Thriving Desirable Community Ardan Park Storm Water Ponds Silver View Pond 10 35W Anoka Ramsey Arden Hills Blaine Fridley Lexington Mounds View Shoreview Spring Lake Park #* #* #* #*#* #*#*#* #* !(!( !(!( !(!( !(!( !(!( ·. ·. ·.·. ·.·. ·.Woodlawn DrEdgewood DrArdan Ave Xylite Ext Ave Sherwood RdLong Lake Rd Laport DrGreenwood Dr£¤10 906 900 904906910900906902906906904908914908898906912906 9 0 8 906910912 912 900 9 1 0 90891 0 9109049049089069 1 4910 912900 910 900 908908900 9 1 0906900906910 90490090090091 0 902910906 902 902910914910912904908900904904902910 91490 0 91291090 0 904910904902910 900 900 910906904908908 90490290690 2 900900908900 9 0 0 904 91090090290890 4 908 908900 906 900 9009 1 0910 902902900 904 9069069049009 1 0 912 9029 0 6 90 0 900904 904902 900910 9029 0 4 9009069 0 2 908902 90890 4 9 0 8 9 0 6 W5 W4 W3 W1 W2 S2S1 S2 W3-Wet W3-Up W4-Up W4-Wet W5-Wet W5-Up 1 2 3 4 5 6 7 Disclaimer: This document has been prepared based on information provided by others as cited in the Notes section. Stantec has not verified the accuracy and/or completeness of this information and shall not be responsible for any errors or omissions which may be incorporated herein as a result. Stantec assumes no responsibility for data supplied in electronic format, and the recipient accepts full responsibility for verifying the accuracy and completeness of the data. Client/Project Figure No. Project Location Title "($$¯\\corp.ads\data\Virtual_Workspace\workgroup\2277\active\227705069\03_data\gis_cad\gis\mxds\227705069_Ardan_Project\227705069_Ardan_Project.aprx Revised: 2022-08-18 By: safosterLegend Environmental Survey Boundary 2 foot Elevation Contour !(Sample Point #*Culvert Field Delineated Waterway Field Delineated Wetland ·.Photo Location Page 1 of 1*No Features Within Data Frame Notes 1. Coordinate System: NAD 1983 StatePlane Minnesota South FIPS 2203 Feet 2. Data Sources: Stantec, NADS, USGS, MnGeo 3. Background: 2019 NAIP (At original document size of 8.5x11) 1:4,800 0 200 400 Feet Prepared by DB on 2022-07-06 TR by DB on 2022-07-13 IR by JF on 2022-08-18 T30N, R23W, S5 C. of Mounds View, Ramsey Co., MN 227705069City of Mounds View Ardan Project Wetland Delineation Field Collected Data 5 Item No: 5 Meeting Date: December 4, 2023 Type of Business: Work Session Administrator Review: _____ City of Mounds View Staff Report To: Honorable Mayor and City Council From: Gayle Bauman, Finance Director Item Title/Subject: 2024 Proposed Tax Levy and Budget Attached is the 2024 Draft Municipal Budget. The City Council has reviewed various portions of the municipal budget throughout the summer and fall and this is one last opportunity before considering final approval at the December 11, 2023 City Council meeting. The City Council adopted a preliminary levy increase of 7.54% ($488,293). The attached proposed budget was prepared assuming a 6.50% levy increase ($421,186). The Street Improvement Fund levy of $150,000 will have no change over 2023. The Police Officer referendum levies will not change and remain at $385,000. There was no increase in the EDA levy. Staff is requesting direction on what levy increase the Council would like to consider at the December 11, 2023 meeting. As discussed at the Truth in Taxation public hearing, the levy is reduced by $16,200 for each 0.25% decrease. If Council opts for a levy increase below 6.50%, the transfers out of the General Fund would be reduced. These transfers support our Community Center and capital funds. A reduction here may cause a deferment of future projects. Respectfully Submitted, Gayle Bauman, Finance Director CITY OF MOUNDS VIEW, MN Combined Budget All Funds CITY-WIDE SUMMARY General Fund Special Revenue Funds Capital Project Funds Enterprise Funds Debt Service Fund Total Budget 2024 Total Budget 2023 Percent Change REVENUES Taxes Property taxes 6,262,675$ 100,000$ 150,000$ -$ 416,293$ 6,928,968$ 6,506,782$ 6.5% Tax increments - 1,786,339 - - - 1,786,339 1,968,519 -9.3% Franchise fee 385,000 - 385,000 - - 770,000 680,000 13.2% Other taxes 59,000 106,000 - - - 165,000 165,000 0.0% Special assessments 5,000 - 11,000 - - 16,000 18,000 -11.1% Licenses and permits 289,522 - -- - 289,522 277,172 4.5% Intergovernmental 1,374,677 57,631 460,000 - - 1,892,308 1,747,001 8.3% Charges for services 48,025 517,800 3,000 4,219,833 - 4,788,658 4,468,061 7.2% Fines & forfeits 35,750 2,000 - - - 37,750 35,750 5.6% Investment earnings 100,000 2,325 7,000 39,400 500 149,225 138,725 7.6% Miscellaneous 329,983 500 - - - 330,483 273,289 20.9% Transfers in 227,457 592,230 1,269,081 45,000 - 2,133,768 2,883,270 -26.0% TOTAL REVENUES 9,117,089$ 3,164,825$ 2,285,081$ 4,304,233$ 416,793$ 19,288,021$ 19,161,569$ 0.7% EXPENDITURES/EXPENSES General Government 1,230,090$ -$ -$ -$ -$ 1,230,090$ 1,129,587$ 8.9% Public Safety 4,731,592 10,700 - - - 4,742,292 4,414,366 7.4% Streets & Highways 1,106,099 - - - - 1,106,099 955,704 15.7% Sanitation - 32,984 - - - 32,984 32,634 1.1% Parks & Recreation 667,328 1,105,698 - - - 1,773,026 1,605,339 10.4% Economic Development 525,613 2,129,029 - - - 2,654,642 2,724,897 -2.6% Other 178,609 - - - - 178,609 149,579 19.4% Debt Service 84,677 - - - - 84,677 121,109 -30.1% Capital Outlay - - 3,401,856 - 392,595 3,794,451 4,214,342 -10.0% Transfers out 1,569,081 - - - - 1,569,081 2,275,000 -31.0% Enterprise Funds - - - 6,167,276 - 6,167,276 7,461,458 -17.3% TOTAL EXPENDITURES/EXPENSES 10,093,089$ 3,278,411$ 3,401,856$ 6,167,276$ 392,595$ 23,333,227$ 25,084,015$ -7.0% NET CHANGES IN FUND BALANCE (976,000)$ (113,586)$ (1,116,775)$ (1,863,043)$ 24,198$ (4,045,206)$ (5,922,446)$ 1 THIS PAGE LEFT BLANK INTENTIONALLY 2 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Taxes 5,086,352 5,236,407 5,414,895 5,842,799 6,262,675 Franchise Taxes 301,756 335,107 425,517 340,000 385,000 Hotel-Motel Taxes 29,264 52,820 60,446 53,000 59,000 Licenses and Permits 269,446 294,605 374,631 277,172 289,522 Intergovernmental 2,419,722 2,078,190 2,068,959 1,254,370 1,374,677 Charges for Services 60,385 42,893 66,961 47,625 48,025 Fines and Forfeits 25,596 43,311 38,418 33,750 35,750 Special Assessments 5,141 1,290 4,637 3,000 5,000 Investment earnings 196,579 (62,699) (644,642) 90,000 100,000 Billboard leases 127,297 130,152 133,551 133,105 139,100 Antenna rentals 98,218 102,147 105,105 79,984 121,183 Miscellaneous 57,251 92,564 270,647 59,700 69,700 Total revenues 8,677,006 8,346,787 8,319,124 8,214,505 8,889,632 Expenditures: City Council 50,168 52,792 55,980 61,935 62,546 Advisory Commissions 3,900 37,548 72,258 26,350 32,350 City Administrator 307,051 311,557 355,819 353,008 382,515 Elections 27,023 35,743 37,842 37,750 67,280 Finance 282,535 291,811 302,997 312,450 324,554 Central Services 252,162 301,375 283,285 338,094 360,845 Community Development 417,362 466,285 490,280 523,603 525,613 Police 3,258,674 3,474,836 3,766,500 3,829,481 4,092,345 Fire 685,219 620,491 713,669 695,294 723,924 Recreation 96,795 - - - - Park Maintenance 399,410 485,102 491,948 530,653 567,208 Forestry 64,092 65,004 104,638 78,252 100,120 Public Works Admin 118,975 121,077 134,727 140,323 195,108 Building & Grounds 171,070 179,260 189,547 167,230 222,543 Veh/Equip Maintenance 136,104 129,935 145,059 154,577 165,849 Street Pavement Mgmt 218,179 203,663 233,785 249,772 265,507 Snow & Ince Control 161,346 149,384 151,603 171,367 182,527 Street Sign Maintenance 42,676 38,601 65,096 72,435 74,565 Convention/Visitor Bureau 29,314 47,865 57,282 50,350 56,050 Miscellaneous 60,631 54,832 64,716 99,229 122,559 Debt Service 166,468 - - - - Total expenditures 6,949,156 7,067,162 7,717,032 7,892,153 8,524,008 Excess (deficit) of revenue over expenditures 1,727,851 1,279,625 602,092 322,352 365,624 Other financing sources (uses): Proceeds from sale of assets/materials 22,694 29,012 811 - - Transfers in (out) EDA (50,000) (50,000) (50,000) (50,000) (50,000) Community Center Fund (550,000) (350,000) (350,000) (350,000) (450,000) Vehicle & Equipment Replacement Fund (299,000) (400,000) (300,000) (300,000) (419,081) Special Projects Funds (475,000) (725,000) (75,000) (75,000) (300,000) Street Improvement Fund - - - (1,500,000) (350,000) Vehicle & Equipment Replacement Fund - - 26,000 27,000 28,000 Water Fund 82,859 85,345 87,905 90,542 93,258 Sewer Fund 82,859 85,345 87,905 90,542 93,258 Street Light Fund 2,940 3,028 3,119 3,213 3,309 Surface Water Fund 8,558 8,815 9,079 9,351 9,632 Net increase (decrease) in fund balance 553,761 (33,830) 41,911 (1,732,000) (976,000) Fund balance - January 1 9,590,786 10,144,547 10,110,717 10,152,627 8,420,627 Fund balance - December 31 10,144,547 10,110,717 10,152,627 8,420,627 7,444,627 CITY OF MOUNDS VIEW GENERAL FUND (100) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 3 General Fund Revenue Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 ChangeChange 100-3101 Advalorem Taxes-Current 4,126,656.75 4,269,907.03 4,455,667.63 5,815,799 6,234,675 418,876 7.2% 100-3102 Ad Valorem Taxes - Delinquent 15,433.03 19,071.86 (50,128.18) - - - 0.0% 100-3111 Mobile Home Taxes - Current 19,351.28 27,889.80 29,861.31 19,000 20,000 1,000 5.3% 100-3112 Mobile Home Taxes - Delinquent 9,957.64 6,316.30 9,257.45 8,000 8,000 - 0.0% 100-3121 Fiscal Disparity - Current 909,124.23 910,787.11 966,739.34 - - - 0.0% 100-3125 Excess Rate Tif - - 128.26 - - - 0.0% 100-3180 Franchise Tax 301,755.50 335,107.47 425,516.99 340,000 385,000 45,000 13.2% 100-3190 Penalties & Interest 5,829.39 2,435.23 3,369.19 - - - 0.0% 100-3195 Hotel-Motel Tax 29,263.56 52,820.43 60,446.33 53,000 59,000 6,000 11.3% Taxes 5,417,371.38 5,624,335.23 5,900,858.32 6,235,799 6,706,675 470,876 7.6% 100-3211 Liquor: On-Sale License 124.66 19,053.33 27,115.00 18,000 20,000 2,000 11.1% 100-3212 Liquor: Off-Sale 260.00 420.00 880.00 500 500 - 0.0% 100-3214 Sunday Liquor Sales - 800.00 1,000.00 500 500 - 0.0% 100-3216 Malt Liquor: Off Sale License 510.00 315.00 200.00 100 100 - 0.0% 100-3221 Tobacco License 1,650.00 2,310.00 3,475.00 3,000 3,000 - 0.0% 100-3223 Amusement Device License - 784.00 - 400 400 - 0.0% 100-3231 Bowling Alley License - 672.00 1,008.00 672 672 - 0.0% 100-3232 Garbage Hauling License 3,670.00 3,670.00 5,320.00 3,800 3,800 - 0.0% 100-3233 Gasoline Station License 1,560.00 1,230.00 1,350.00 850 1,200 350 41.2% 100-3234 Used Car Sales License 224.99 225.00 225.00 200 200 - 0.0% 100-3235 Kennel License 333.00 315.00 483.00 200 200 - 0.0% 100-3236 Restraurant License 345.00 3,755.00 7,546.00 3,200 3,200 - 0.0% 100-3238 Transient & Solicitor License 2,244.00 2,754.00 1,428.00 2,200 2,200 - 0.0% 100-3239 Apartment License 81,953.25 77,165.00 83,712.50 75,000 80,000 5,000 6.7% 100-3240 Rental Conversion 1,325.00 2,250.00 5,825.00 1,000 1,000 - 0.0% 100-3241 Dog License 2,987.00 604.00 3,137.75 1,400 1,400 - 0.0% 100-3242 Massage Therapy 5.00 357.00 119.00 - - - 0.0% 100-3243 Chickens And Bees License 390.00 670.00 410.00 100 100 - 0.0% 100-3244 Change Of Occupancy - - 75.00 - - - 0.0% 100-3250 General Contractor License 1,620.00 1,550.00 1,350.00 1,100 1,100 - 0.0% 100-3251 Hvac Contractor License 3,180.00 3,300.00 2,764.00 3,000 3,000 - 0.0% 100-3252 Cement Contractor License 60.00 - - 100 100 - 0.0% 100-3253 Asphalt Contractor License - - 60.00 100 100 - 0.0% 100-3254 Excavating Contractor License - - - 50 50 - 0.0% 100-3255 Sign & Billboard License - - - 100 100 - 0.0% 100-3256 Sewer & Water Contractor Licen 480.00 60.00 60.00 - - - 0.0% 100-3257 Other Contractor License 2,430.00 3,425.00 1,770.00 2,200 2,200 - 0.0% 100-3258 License Check Fee 1,380.00 1,429.10 1,864.99 1,500 1,500 - 0.0% 100-3260 Fire Permits 1,024.75 1,325.00 2,053.52 1,000 1,000 - 0.0% 100-3268 Plan Check Fee 23,829.93 26,005.08 52,168.19 27,000 27,000 - 0.0% 100-3270 Building Permits 94,351.25 91,906.44 98,713.30 90,000 90,000 - 0.0% 100-3271 Building Permit - Fixed Fee 550.00 1,356.55 12,362.35 - 5,000 5,000 0.0% 100-3273 Hvac Permit 22,804.53 28,227.69 37,209.17 24,000 24,000 - 0.0% 100-3274 Plumbing Permit 14,509.58 11,609.99 15,327.45 11,000 11,000 - 0.0% 100-3275 Non-Building Permit 4,175.00 5,825.75 4,406.05 4,500 4,500 - 0.0% 100-3279 Conditional Use Permit 1,000.00 800.00 600.00 400 400 - 0.0% 100-3280 Building Surcharge 94.73 327.43 (21.03) - - - 0.0% 100-3281 Fixed Fee Building Surcharge (26.83) (164.61) 195.31 - - - 0.0% 100-3282 Mechanical/Commercial Surcharg 802.04 809.82 1,552.69 - - - 0.0% 100-3283 Hvac Surcharge (762.36) (749.71) (1,478.78) - - - 0.0% 100-3284 Plumbing Surcharge (524.59) (222.85) (849.49) - - - 0.0% 100-3285 Fire Inspection Surcharge 174.93 39.61 149.14 - - - 0.0% 100-3286 Sewer & Water Surchage 143.00 166.00 154.00 - - - 0.0% 100-3287 Commercial Plbg Surcharge 568.21 229.64 911.29 - - - 0.0% Licenses and Permits 269,446.07 294,605.26 374,631.40 277,172 289,522 12,350 4.5% 100-3318 Federal Police Grant 14,191.45 78,404.57 77,408.47 - - - 0.0% 100-3319 Other Federal Grants 1,004,135.00 650,000.00 600,541.90 - - - 0.0% 100-3341 Local Government Aid 820,801.00 844,568.00 850,373.00 771,516 923,823 152,307 19.7% 100-3345 Performance Aid 1,892.00 1,855.00 1,839.00 1,854 1,854 - 0.0% 100-3351 Msa - Street Maintenance 147,096.00 136,263.00 153,057.00 145,000 148,000 3,000 2.1% 100-3355 Police Insurance Premium Tax 196,896.61 183,085.34 206,171.57 180,000 195,000 15,000 8.3% 100-3356 Police Training Aid 18,818.21 19,577.02 20,296.34 19,000 20,000 1,000 5.3% 100-3357 State Police Grant - 5,509.26 15,679.09 - - - 0.0% 4 General Fund Revenue Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 ChangeChange 100-3359 Other State Grants 22,284.95 43,251.97 29,886.72 25,000 25,000 - 0.0% 100-3370 Other Local Government Revenue 36,136.97 25,649.21 35,897.09 20,000 20,000 - 0.0% 100-3371 Isd # 621 Sro 157,469.92 90,026.56 77,808.71 92,000 41,000 (51,000) -55.4% Intergovernmental 2,419,722.11 2,078,189.93 2,068,958.89 1,254,370 1,374,677 120,307 9.6% 100-3410 Advertising Revenue - - - 100 100 - 0.0% 100-3414 Fire Inspections 431.25 - 600.00 - - - 0.0% 100-3415 Inspections 822.25 900.00 7,200.00 100 500 400 400.0% 100-3418 Hra Inspections - 200.00 - 200 200 - 0.0% 100-3419 Investigations - 1,605.91 623.95 200 200 - 0.0% 100-3420 Dhs Fire Inspections 100.00 150.00 - - - - 0.0% 100-3421 Police Reports 1,088.20 1,813.83 1,835.33 1,200 1,200 - 0.0% 100-3422 Copies - - - 50 50 - 0.0% 100-3423 Customer Service 10.00 10.00 12.00 100 100 - 0.0% 100-3425 Book Sales - Various 30.00 - - - - - 0.0% 100-3426 Reimbursed Staff Time 2,145.00 1,328.00 2,656.00 500 500 - 0.0% 100-3430 Right-Of-Way 7,380.00 4,970.00 30,570.00 7,500 7,500 - 0.0% 100-3431 Street Opening Fee 800.00 600.00 - - - - 0.0% 100-3432 Tree Removal Charges 44,778.00 25,464.99 18,657.50 35,000 35,000 - 0.0% 100-3433 Overload Permits - 375.00 - - - - 0.0% 100-3458 Zoning Letter 200.00 400.00 475.00 75 75 - 0.0% 100-3461 Subdivision Fee - 2,200.00 1,500.00 1,000 1,000 - 0.0% 100-3462 Variance 1,200.00 400.00 601.25 1,000 1,000 - 0.0% 100-3463 Rezoning - 1,275.00 500.00 200 200 - 0.0% 100-3464 Development Fee - Non Refundab 1,000.00 1,200.00 980.00 200 200 - 0.0% 100-3467 Pud Amendment 400.00 - 750.00 200 200 - 0.0% Charges for Services 60,384.70 42,892.73 66,961.03 47,625 48,025 400 0.8% 100-3510 Ramsey Cty Mun Court 23,916.43 36,942.61 36,782.95 32,000 34,000 2,000 6.3% 100-3511 Controlled Substance Fines - 5,012.00 - - - - 0.0% 100-3520 Administrative Offenses 1,230.00 1,356.00 1,635.00 1,000 1,000 - 0.0% 100-3525 Alarm Violations 450.00 - - 750 750 - 0.0% Fines and Forfeits 25,596.43 43,310.61 38,417.95 33,750 35,750 2,000 5.9% 100-3551 Spec Assessmts - Current 4,984.08 1,289.82 4,631.52 3,000 5,000 2,000 66.7% 100-3552 Spec Assessmts - Delinquent 3.38 - - - - - 0.0% 100-3553 Spec Assessmts - Penalty & Int 153.38 - 5.01 - - - 0.0% Special Assessments 5,140.84 1,289.82 4,636.53 3,000 5,000 2,000 66.7% 100-3610 Interest Revenue 196,579.26 (62,699.07) (644,641.89) 90,000 100,000 10,000 11.1% 100-3630 Billboard Lease 127,297.05 130,152.01 133,550.70 133,105 139,100 5,995 4.5% 100-3631 Water Tower Rental 98,217.97 102,146.68 105,104.70 79,984 121,183 41,199 51.5% 100-3634 Equipment & Space Rental 1,343.92 - 1,384.24 - - - 0.0% 100-3639 Security 784.08 1,660.00 - - - - 0.0% 100-3649 Charitable Gambling 10%- 5,092.42 9,204.59 - - - 0.0% 100-3650 Donations 1,400.00 - 7,785.00 - - - 0.0% 100-3651 Donations - K9 1,625.00 1,550.00 1,180.00 600 600 - 0.0% 100-3654 Cops Events Revenue 4,550.00 1,100.00 1,000.00 5,000 5,000 - 0.0% 100-3665 Park Site Permit 5,623.86 28,288.08 39,743.40 18,000 28,000 10,000 55.6% 100-3679 Commission-Vending Machines - - - 100 100 - 0.0% 100-3680 Miscellaneous Revenue 6,131.48 5,377.55 166,932.30 10,000 10,000 - 0.0% 100-3685 Insurance Reimbursement 35,792.21 49,495.48 43,417.07 20,000 20,000 - 0.0% 100-3911 Sale Of Assets 22,461.50 28,211.91 - 5,000 5,000 - 0.0% 100-3912 Sale Of Materials 232.80 799.80 810.80 1,000 1,000 - 0.0% 100-3972 Transfer From Other Funds 177,216.00 182,533.00 214,008.00 220,648 227,457 6,809 3.1% Other 679,255.13 473,707.86 79,478.91 583,437 657,440 74,003 12.7% 100 General Fund 8,876,916.66 8,558,331.44 8,533,943.03 8,435,153 9,117,089 681,936 8.1% 5 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4100-0100 Regular Salaries 34,596.00 34,596.00 34,596.00 34,596 34,600 4 0.0% 100-4100-0110 Overtime Salaries - - 138.34 - - - 0.0% 100-4100-0300 Social Security 1,337.52 1,358.15 1,347.12 2,647 2,650 3 0.1% 100-4100-0321 PERA Employer 1,050.12 1,070.70 1,060.49 1,730 1,730 - 0.0% 100-4100-0400 Health Employer - - 25.32 - - - 0.0% 100-4100-0410 Life Employer - - 0.02 - - - 0.0% 100-4100-0500 Workers Comp Ins Premiums 160.48 145.42 152.84 176 180 4 2.3% Personnel Expenses 37,144.12 37,170.27 37,320.13 39,149 39,160 11 0.0% 100-4100-1600 Operating Supplies 1,654.25 3,485.51 912.72 3,300 3,300 - 0.0% Supplies and Materials 1,654.25 3,485.51 912.72 3,300 3,300 - 0.0% 100-4100-3030 Other Professional Services 5,221.75 5,814.76 6,941.25 6,400 7,000 600 9.4% 100-4100-3410 Legal Notices - - 49.05 - - - 0.0% 100-4100-3610 Memberships 5,602.00 5,491.00 5,436.00 5,436 5,436 - 0.0% 100-4100-3630 Trainings & Conferences - 310.00 4,806.78 7,000 7,000 - 0.0% 100-4100-4800 Insurance & Bonds 545.78 520.01 514.10 650 650 - 0.0% Other Services and Charges 11,369.53 12,135.77 17,747.18 19,486 20,086 600 3.1% 4100 City Council 50,167.90 52,791.55 55,980.03 61,935 62,546 611 1.0% 100-4110-1600 Operating Supplies 64.46 - - 100 100 - 0.0% 100-4110-2100 Books & Periodicals - - - 50 50 - 0.0% Supplies and Materials 64.46 - - 150 150 - 0.0% 100-4110-3030 Other Professional Services 3,835.90 15,656.90 41,768.13 9,000 9,000 - 0.0% 100-4110-3630 Trainings & Conferences - - - 200 200 - 0.0% 100-4110-3900 Grants to other Organizations - 21,891.07 30,489.63 17,000 23,000 6,000 35.3% Other Services and Charges 3,835.90 37,547.97 72,257.76 26,200 32,200 6,000 22.9% 4110 Advisory Commissions 3,900.36 37,547.97 72,257.76 26,350 32,350 6,000 22.8% 6 Fund: 100 Department: 4100 City Council ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1600 Supplies, operating 1,500 1,500 Employee awards luncheon (R9275) 800 800 Strategic planning sessions 1,000 1,000 Plaques and gift certificates for employee length-of-service awards (R9275) 1,654 3,486 913 3,300 3,300 3030 Other professional services 5,222 5,815 6,941 6,400 7,000 Contractual minutes for Council mtgs ( $260 x 24 reg, + 3 special) 3100 Telephone & communication - - - - - Reimburse for use of personal cellular phones 3410 Legal notices - - 49 - - 3610 Memberships 30 30 Mn Mayor's Association 5,406 5,406 North Metro Mayors 5,602 5,491 5,436 5,436 5,436 3630 Conferences - 310 4,807 7,000 7,000 Council training, LMC conference, LMC meetings/training, RCLLG, Other 4800 Bonds & insurance 546 520 514 650 650 General property & liability 13,024 15,621 18,660 22,786 23,386 22,786 23,386 19.94% 19.45% 22.11% 2.63% Fund: 100 Department: 4110 Advisory Commissions ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1600 Supplies, operating 40 40 Misc supplies for various commissions. 60 60 Copies for Charter Commission 64 - - 100 100 2100 Books & periodicals - - - 50 50 Misc periodicals - Comp plan review, Ordinance revisions. 3030 Other professional services 500 500 Misc. consultant services. 5,000 6,500 Charter commission legal fees 3,500 2,000 Planning Commission and charter meeting minutes 3,836 15,657 41,768 9,000 9,000 3630 Training 75 75 Misc training & conferences. 125 125 Planning Commissioner training & conferences - - - 200 200 3900 Festival in the Park 9,000 15,000 City Festival in the Park (personnel, supplies, restrooms, stage, tables) - - 60th Anniversery 3,000 3,000 Music in the Park (statutory limit is $3,000) 5,000 5,000 Fireworks - - Community picnic (April 2008) - 21,891 30,490 17,000 23,000 3,900 37,548 72,258 26,350 32,350 26,350 32,350 862.68% 92.44% -63.53% 22.77% 7 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4130-0100 Regular Salaries 200,604.20 214,757.78 253,073.15 223,210 251,340 28,130 12.6% 100-4130-0110 Overtime Salaries - - - 811 870 59 7.3% 100-4130-0150 Part Time Salaries 49,643.00 35,908.91 38,146.63 52,521 58,270 5,749 10.9% 100-4130-0300 Social Security 17,439.84 17,356.76 20,102.30 20,322 22,740 2,418 11.9% 100-4130-0321 PERA Employer 5,398.45 5,622.48 7,813.84 17,131 8,370 (8,761) -51.1% 100-4130-0400 Health Employer 26,893.74 27,339.65 29,324.94 26,163 27,870 1,707 6.5% 100-4130-0410 Life Employer 28.08 28.08 25.35 - - - 0.0% 100-4130-0500 Workers Comp Ins Premiums 1,305.16 1,285.92 1,486.44 2,205 2,610 405 18.4% Personnel Expenses 301,312.47 302,299.58 349,972.65 342,363 372,070 29,707 8.7% 100-4130-1230 Supplies - Equipment 155.48 - 475.58 1,200 1,000 (200) -16.7% 100-4130-1600 Operating Supplies 67.95 34.50 39.64 75 75 - 0.0% 100-4130-2100 Books & Periodicals - - - 35 35 - 0.0% Supplies and Materials 223.43 34.50 515.22 1,310 1,110 (200) -15.3% 100-4130-3030 Other Professional Services 584.48 942.00 545.00 - - - 0.0% 100-4130-3100 Telephone 1,069.31 1,408.80 1,194.55 1,300 1,300 - 0.0% 100-4130-3610 Memberships 359.00 1,330.00 1,124.31 1,685 1,685 - 0.0% 100-4130-3630 Trainings & Conferences 3,502.44 4,970.12 2,128.55 6,050 6,050 - 0.0% 100-4130-3800 Mileage & Parking - 572.34 338.86 300 300 - 0.0% Other Services and Charges 5,515.23 9,223.26 5,331.27 9,335 9,335 - 0.0% 4130 City Administrator 307,051.13 311,557.34 355,819.14 353,008 382,515 29,507 8.4% 100-4140-3030 Other Professional Services 27,022.95 35,743.47 37,841.72 37,750 67,280 29,530 78.2% Other Services and Charges 27,022.95 35,743.47 37,841.72 37,750 67,280 29,530 78.2% 4140 Elections 27,022.95 35,743.47 37,841.72 37,750 67,280 29,530 78.2% 8 Fund: 100 Department: 4130 Office of the City Administrator ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1230 Supplies, equipment < $5000 155 - 476 1,200 1,000 Equipment and phones under the $5,000 capitalization threshold 1600 Supplies, Operating 68 35 40 75 75 Miscellaneous supplies 2100 Books & Periodicals - - - 35 35 Miscellaneous reference books 3030 Other professional services 584 942 545 - - 3100 Communications 1,069 1,409 1,195 1,300 1,300 Cell phone service (2) employees 3610 Memberships 50 50 MAMA - (Administrator) Metro Area Manager's Association - - ICMA - International City Manager's Association 150 150 Mn City County Managers Association 210 210 Society for Human Resource Managers (SHRM) 185 185 International Institute of Municipal Clerks (IIMC) 1,000 1,000 New Brighton/Mounds View Rotary Club dues (administrator) 90 90 Municipal Clerks & Finance Officers Association (MCFOA)(2) 359 1,330 1,124 1,685 1,685 3630 Training & conferences 100 100 MAMA meetings 650 650 LMC / miscellaneous training 100 100 Chamber lunches 1,400 1,400 Compass Peer Group/Craig Rapp - Administrator 1,000 1,000 LMC annual conference 2,700 2,700 MN Clerks and Finance Officers Annual Conference (MCFOA)(3) - - Mn City County Managers Assoc conference 100 100 Mn Clerks and Finance Officers Association (MCFOA) institute training - - National ICMA or NLC conference (City Administrator)(every other year) 3,502 4,970 2,129 6,050 6,050 3800 Mileage - 572 339 300 300 Miscellaneous mileage @ IRS rate. 5,739 9,258 5,846 10,645 10,445 10,645 10,445 61.32% -36.85% 82.08% -1.88% Fund: 100 Department: 4140 Elections ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1600 Supplies, operating - - - - - Misc supplies - paper, pens, files, and mats for gym 3030 Other professional services 32,750 39,080 Ramsey Cty elections contract ($9,770/quarter)(25% increase primary) - 21,000 Special election (Next state primary election 2024) 5,000 7,200 Voting equip. maint. Costs (2022 - $6,578)(2021 - $4,480) 27,023 35,743 37,842 37,750 67,280 3410 Legal notices - - - - - Primary and general election (even years and special elections) 7030 Equipment - - - - - Voting equipment 27,023 35,743 37,842 37,750 67,280 32.27% 5.87% -0.24% 78.23% 9 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4150-0100 Regular Salaries 202,758.36 210,373.71 217,531.82 221,438 187,880 (33,558) -15.2% 100-4150-0150 Part Time Salaries - - - - 38,590 38,590 0.0% 100-4150-0300 Social Security 13,742.31 14,226.49 14,872.70 16,507 17,330 823 5.0% 100-4150-0321 PERA Employer 15,288.39 15,353.67 15,925.74 16,184 16,990 806 5.0% 100-4150-0400 Health Employer 28,092.09 28,462.04 32,252.66 32,877 33,770 893 2.7% 100-4150-0410 Life Employer 613.68 613.68 586.46 - - - 0.0% 100-4150-0420 Dental Employer 216.72 216.72 215.30 - - - 0.0% 100-4150-0500 Workers Comp Ins Premiums 1,355.12 1,249.03 1,369.08 1,597 1,770 173 10.8% Personnel Expenses 262,066.67 270,495.34 282,753.76 288,603 296,330 7,727 2.7% 100-4150-1230 Supplies - Equipment - 800.00 - 900 900 - 0.0% 100-4150-1600 Operating Supplies - 126.09 - 50 50 - 0.0% 100-4150-2100 Books & Periodicals 115.94 159.00 142.43 200 200 - 0.0% Supplies and Materials 115.94 1,085.09 142.43 1,150 1,150 - 0.0% 100-4150-3030 Other Professional Services 9,603.80 9,769.40 9,954.13 10,018 13,253 3,235 32.3% 100-4150-3100 Communications 600.00 600.00 600.00 600 600 - 0.0% 100-4150-3430 Printing 941.51 321.58 - 700 700 - 0.0% 100-4150-3610 Memberships 1,010.00 1,020.00 1,237.00 1,180 1,180 - 0.0% 100-4150-3630 Trainings & Conferences 2,324.18 2,353.05 1,834.03 3,400 3,400 - 0.0% 100-4150-5130 Repairs - Equipment 5,873.15 6,166.82 6,475.16 6,799 7,941 1,142 16.8% Other Services and Charges 20,352.64 20,230.85 20,100.32 22,697 27,074 4,377 19.3% 4150 Finance 282,535.25 291,811.28 302,996.51 312,450 324,554 12,104 3.9% 10 Fund: 100 Department: 4150 Finance ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1230 Supplies, equitpment < $5000 - 800 - 900 900 equip. under the $5,000 capitalization threshold (cell phone $800) 1600 Supplies, operating - 126 - 50 50 Misc supplies - planners, plaques, folders, files, etc. 2100 Books & periodicals 116 159 142 200 200 Misc computer & finance books & periodicals 3030 Other professional services 9,398 9,033 24.5% of audit (23-36,145, 24-36,870, 25-37,605, 26-38,360) - 3,600 Additional audit services 460 460 GFOA financial reporting fee 60 60 Safety deposit box rental 100 100 Ramsey County overlapping debt, principal taxpayer reports 9,604 9,769 9,954 10,018 13,253 3100 Communications 600 600 600 600 600 cell phone ($50 month) 3430 Printing 350 350 Accts Payable & payroll checks & envelopes 350 350 Invoices, receipts, & bank deposit slips 942 322 - 700 700 3610 Memberships 400 400 Government Finance Officer's Association (GFOA) 140 140 Mn GFOA (2) 300 300 AICPA Am. Institute of Certified Public Accts 340 340 MNCPA Mn Society of Certified Public Accountants 1,010 1,020 1,237 1,180 1,180 3630 Training & conferences 50 50 Mn GFOA monthly meetings - - Mn GFOA annual seminar (postpone to 12)(13)(14)(15)($950) 2,000 2,000 Seminars & training - - GFOA National conference (Defer)($2800) 1,000 1,000 Accounting and software training 350 350 Mileage 2,324 2,353 1,834 3,400 3,400 5130 Equipment repairs 5,873 6,167 6,475 6,799 7,941 40% software support chgs. (30% each in Water, Sewer)(5% increase) 7030 Equipment > $5000 - - - - - 20,469 21,316 20,243 23,847 28,224 28224 4.14% -5.03% 17.81% 18.35% 11 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4160-1110 Stationary 849.04 532.00 1,965.35 1,000 1,000 - 0.0% 100-4160-1120 Copy Supplies 725.78 642.79 960.54 1,250 1,000 (250) -20.0% 100-4160-1230 Supplies - Equipment 15,278.62 28,489.85 19,964.27 27,000 28,000 1,000 3.7% 100-4160-1600 Operating Supplies 7,146.48 9,405.32 6,985.77 11,000 10,500 (500) -4.5% 100-4160-2100 Books & Periodicals 182.00 463.65 676.05 340 390 50 14.7% Supplies and Materials 24,181.92 39,533.61 30,551.98 40,590 40,890 300 0.7% 100-4160-3010 General Legal Services 37,817.70 63,617.06 35,373.68 48,000 46,000 (2,000) -4.2% 100-4160-3030 Other Professional Services 25,855.16 30,939.67 33,054.11 33,487 43,704 10,217 30.5% 100-4160-3100 Telephone 1,773.95 804.75 95.45 660 - (660) -100.0% 100-4160-3300 Postage 7,193.62 5,964.24 4,571.33 6,500 6,500 - 0.0% 100-4160-3410 Legal Notices 2,916.05 3,231.76 3,131.75 2,600 2,600 - 0.0% 100-4160-3420 Advertising 227.16 978.00 2,312.31 2,500 5,000 2,500 100.0% 100-4160-3430 Printing 11,716.76 12,180.17 14,037.80 12,600 14,600 2,000 15.9% 100-4160-3610 Memberships 19,564.00 19,603.00 20,375.00 19,521 19,963 442 2.3% 100-4160-3630 Training & Conferences 2,750.00 1,750.32 5,942.00 17,000 12,300 (4,700) -27.6% 100-4160-3800 Mileage & Parking 83.84 40.32 - - - - 0.0% 100-4160-4010 Rental - Equipment 1,820.28 1,820.28 1,839.63 2,050 2,050 - 0.0% 100-4160-4800 Insurance & Bonds 15,113.72 14,400.22 15,030.56 18,000 18,000 - 0.0% 100-4160-5100 Repairs - Computers 100,060.53 105,976.28 116,732.17 134,086 148,738 14,652 10.9% 100-4160-5110 Repairs - Bldgs & Grounds 1,087.73 113.00 229.50 - - - 0.0% 100-4160-5130 Repairs - Equipment - 421.99 8.08 500 500 - 0.0% Other Services and Charges 227,980.50 261,841.06 252,733.37 297,504 319,955 22,451 7.5% 4160 Central Services 252,162.42 301,374.67 283,285.35 338,094 360,845 22,751 6.7% 12 Fund: 100 Department: 4160 Central Services ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1110 Stationery 849 532 1,965 1,000 1,000 Envelopes, labels, letterhead, etc. 1120 Copy materials 726 643 961 1,250 1,000 Copy paper 1230 Supplies, equipment < $5000 15,279 28,490 19,964 27,000 28,000 Pc's, software, switches, cameras; Replace pc's 4 yr cycle @ $800 1600 Supplies, operating 10,500 10,000 Toner, rug service, paper, pens, staples, desk supplies, etc. 500 500 Misc operating supplies 7,146 9,405 6,986 11,000 10,500 2100 Books & periodicals 150 150 Employment handbooks/publications 190 240 Star Tribune 182 464 676 340 390 3010 General legal 24,000 24,000 Retainer for legal services 24,000 22,000 Legal fees outside scope of retainer. 37,818 63,617 35,374 48,000 46,000 3030 Other professional services 6,000 4,000 General labor assistance 2,000 2,000 Human resources items - 8,000 Job description update and maintenance 10,000 - Personnel market study (2023 for 2024 implementation) 2,477 4,954 HR recruit/hiring software NEOGOV (1/2 in Comm Ctr)(2nd yr $9,908/2) 1,650 2,000 Open Enrollment/Benefits platform - 7,200 Financial consultant (80 hours) - - Federal Single Audit ARPA Grant (if needed) 3,000 3,000 Western Bank monthly fees 400 400 US Bank positive pay service 1,800 1,800 Section 125 (flex spending plan) & COBRA administration - 3,500 Actuary services GASB 74/75 (every 2 years)(2024 budget)(22 - $2,800) 1,500 1,500 Laserfiche assistance 1,000 1,500 Codification service 3,660 3,850 Web hosting (Revize) (5% annual increase)($2760 + $900 forms) 25,855 30,940 33,054 33,487 43,704 3100 Telephone 1,774 805 95 660 - Basic telephone (analog for alarms)(all digital no longer needed) 3300 Postage 200 200 Courier charges (delivery services) 6,300 6,300 General postage includes PW mailings for street projects. 7,194 5,964 4,571 6,500 6,500 3410 Legal notices 900 900 Truth in taxation notices and Ramsey County fees. 1,700 1,700 Legal notices and legal publications. 2,916 3,232 3,132 2,600 2,600 3420 Advertising 227 978 2,312 2,500 5,000 Job opening advertisements for vacant positions (using NEOGOV above) 3430 Printing 12,000 14,000 4 newsletters and postage, Park and Rec in Comm Ctr Fund. 200 200 Miscellaneous printing 400 400 City guides, directories & miscellaneous 11,717 12,180 14,038 12,600 14,600 3610 Memberships 625 625 Ramsey County League of Local Governments (RCLLG) 475 475 Twin Cities North Chamber of Commerce 5,243 5,158 Metro Cities 13,178 13,705 League of Mn Cities dues 19,564 19,603 20,375 19,521 19,963 3630 Training & conferences 1,000 1,000 League training & seminars 1,000 1,000 Laserfiche training and certification 1,500 1,500 Gallup Team Grid Software (annual) 3,525 3,525 Gallup Annual Summit (out-of-state)(annual) 1,775 1,775 Gallup Training - - Strength Finder assessment 5,200 2,000 Staff development training 2,000 500 Administrator 360 review 800 800 OSHA and blood borne pathogen training 200 200 Information technology training 2,750 1,750 5,942 17,000 12,300 3800 Mileage & parking 84 40 - - - 4010 Rental, equipment 150 150 Misc 1,900 1,900 Postage machine and scale rental (lease thru 9/27) 1,820 1,820 1,840 2,050 2,050 4800 Bonding & insurance 15,000 15,000 Insurance policy premiums 3,000 3,000 Allowance for insurance policy deductibles 15,114 14,400 15,031 18,000 18,000 5100 Repairs, computer 120,009 134,187 Computer, phone, network & technology assistance - Metro I-Net 7,871 8,376 Laserfiche annual maintenance and storage 1,206 1,175 Adobe annual license (18) - - Denial of Service protection (moved to Metro I-Net line) 13 - - Computer, printer, and networks repairs. (moved to Metro I-Net line) 5,000 5,000 Copier maintenance + overages 100,061 105,976 116,732 134,086 148,738 5110 Repairs, bldgs & grounds 1,088 113 230 - - 5130 Repairs, equipment - 422 8 500 500 Postage meter, copy machine, fax, misc. 7010 Capital, Building - - - - - 7030 Equipment > $5000 - - Replace 11 pc's @ $800, 5 yr. Replacement cycle on 53 city pc's - - Software licenses (AutoCAD, MS Office, Windows) - - Network hardware (switches, routers, hubs, ups, servers) - - Arc View GIS software upgrade 4 @ $650 - - Large format plotter replacement - - - - - 252,162 301,375 283,285 338,094 360,845 19.52% -6.00% 19.35% 6.73% 14 THIS PAGE LEFT BLANK INTENTIONALLY 15 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4180-0100 Regular Salaries 305,245.86 336,424.30 373,417.09 365,546 332,230 (33,316) -9.1% 100-4180-0110 Overtime Salaries - - - 828 870 42 5.1% 100-4180-0300 Social Security 20,495.65 20,511.51 23,002.03 23,530 20,280 (3,250) -13.8% 100-4180-0321 PERA Employer 26,522.64 31,393.47 33,344.43 34,876 33,540 (1,336) -3.8% 100-4180-0400 Health Employer 25,330.41 42,016.80 29,954.10 48,600 47,610 (990) -2.0% 100-4180-0410 Life Employer 1,049.10 418.08 1,061.40 - - - 0.0% 100-4180-0420 Dental Employer 1,967.80 1,378.76 1,433.78 - - - 0.0% 100-4180-0500 Workers Comp Ins Premiums 1,956.12 1,778.30 1,987.44 3,240 3,100 (140) -4.3% 100-4180-0600 Unemployment 692.84 - 7,622.66 - - - 0.0% Personnel Expenses 383,260.42 433,921.22 471,822.93 476,620 437,630 (38,990) -8.2% 100-4180-1230 Supplies - Equipment 248.68 - 89.66 1,000 2,500 1,500 150.0% 100-4180-1600 Operating Supplies 89.08 35.41 - 200 200 - 0.0% 100-4180-1700 Motor Fuel & Lubricants 716.97 876.62 682.45 1,625 1,625 - 0.0% 100-4180-2100 Books & Periodicals 754.50 477.81 720.99 840 840 - 0.0% 100-4180-2400 Uniforms & Clothing 18.58 484.13 244.98 450 450 - 0.0% Supplies and Materials 1,827.81 1,873.97 1,738.08 4,115 5,615 1,500 36.5% 100-4180-3030 Other Professional Services 26,973.27 25,131.26 10,124.45 28,900 68,400 39,500 136.7% 100-4180-3040 Consultants - Other 210.00 152.00 - 3,000 3,000 - 0.0% 100-4180-3100 Telephone 2,332.32 2,432.95 2,361.23 2,568 2,568 - 0.0% 100-4180-3430 Printing - - - 500 500 - 0.0% 100-4180-3610 Memberships 1,681.00 1,003.00 943.00 1,700 1,700 - 0.0% 100-4180-3630 Training & Conferences 855.50 1,734.28 3,290.42 6,100 6,100 - 0.0% 100-4180-3800 Mileage & Parking 221.95 36.29 - 100 100 - 0.0% Other Services and Charges 32,274.04 30,489.78 16,719.10 42,868 82,368 39,500 92.1% 4180 Community Development 417,362.27 466,284.97 490,280.11 523,603 525,613 2,010 0.4% 16 Fund: 100 Department: 4180 Community Development ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1230 Supplies, equipment < $5000 249 - 90 1,000 2,500 Miscellaneous equipment & computer peripherals (Lobby computer) 1600 Supplies, operating - - Presentation supplies - - ARC GIS License 200 200 Office supplies 89 35 - 200 200 1700 Motor fuels & lubs 717 877 682 1,625 1,625 Unleaded fuel: 500 gallons @ $3.25 (Gas for Comm Devlopment) 2100 Books & periodicals 200 200 Reference materials 500 500 Intl. Code Council Manuals and Code Updates 140 140 MSP Business Journal 755 478 721 840 840 2400 Uniforms 19 484 245 450 450 Clothing for inspections staff 3030 Other professional 1,400 1,400 Ramsey County JPA (geographic information system) - 500 Plan Review software annual maintenance (New for 2024) 11,000 11,000 New permit software annual maintenance TBD (see Sp Projects) - - Business License Module (one time fee)(annual maintenance $375) 500 500 Filing fees (Ramsey County increased fees from $29 to $48) - - Comcate Code Enforcement Mgr license (5% annual) - - Comcate mobile access (5% annual) 1,000 50,000 Consulting Planning Services 1,000 1,000 Consulting Building Official services 10,000 - Consulting Code Enforcement SBM employee (2 days wk x 10 months) - - Comp plan assistance (carryover) 4,000 4,000 Abatements of nuisance properties 26,973 25,131 10,124 28,900 68,400 3040 Consulting - Development - - Environmental reviews Review (reimbursable)1,500 1,500 City attorney services - - Development case reviews 1,500 1,500 Engineering services 210 152 - 3,000 3,000 3100 Telephone 1,608 1,608 Verizon Cell Accounts (2) for inspectors, Reimb. Director $50/mo 960 960 network cards for blding. Insp. and code enforcement (2 cards @ $40) 2,332 2,433 2,361 2,568 2,568 3430 Printing - - - 500 500 Forms, flyers, etc. 3610 Memberships 400 400 American Planning Association (APA) - National (1) 100 100 American Planning Association (APA-MN) - State (1) 200 200 American Institute of Certified Planners (AICP) 200 200 Economic Development Assoc. of MN (EDAM) 250 250 Assoc. of MN Building Officials (2) 80 80 Fire Marshal's Assoc. of MN 145 145 International Code Council (ICC) 100 100 10K Lakes Chapter of ICC 125 125 MN Assoc. Housing Code Officials (MAHCO) 100 100 MN Building Permit Technicians Association (MBPTA) 1,681 1,003 943 1,700 1,700 3630 Training & conferences 850 850 APA state conference (one attendee) 350 350 Sensible Land Use Coalition (monthly lunches (6 @ $58) 600 600 International Code Council (ICC) Permit Tech Certification 500 500 ICC code seminars 700 700 EDAM Summer and Winter Conference 100 100 ICC Ed of Code Administration - - Tuition reimbursement 600 600 Leadership Growth 400 400 Other software training - - Fire Inspector I & II training - - Building Inspection Technology Certificate 2,000 2,000 Other staff training & seminars - - League of MN Cities conference - - APA National conference (2009)(Minneapolis) 856 1,734 3,290 6,100 6,100 3800 Mileage 222 36 - 100 100 Misc. use of personal automobiles 7030 Equipment > $5000 - - - - - Computer work station for temp inspector for Medtronic project 7040 Vehicle - - - - - Vehicle for inspector for Medtronic project 34,102 32,364 18,457 46,983 87,983 87,983 -5.10% -42.97% 154.55% 87.27% 17 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4200-0100 Regular Salaries 1,926,211.27 2,026,591.89 2,154,019.06 2,212,617 2,306,680 94,063 4.3% 100-4200-0110 Overtime Salaries 121,183.72 175,214.78 138,764.78 104,881 163,070 58,189 55.5% 100-4200-0300 Social Security 33,848.56 35,386.68 37,454.95 41,639 44,330 2,691 6.5% 100-4200-0321 PERA Employer 352,162.42 368,082.81 376,806.26 396,977 423,130 26,153 6.6% 100-4200-0400 Health Employer 279,424.12 274,800.68 289,487.51 343,800 355,680 11,880 3.5% 100-4200-0410 Life Employer 2,787.73 2,693.94 2,535.73 - - - 0.0% 100-4200-0420 Dental Employer 9,362.47 9,925.18 14,384.93 - - - 0.0% 100-4200-0500 Workers Comp Ins Premiums 96,318.44 115,460.48 123,187.33 212,745 239,650 26,905 12.6% 100-4200-0600 Unemployment 655.98 - 3,424.67 - - - 0.0% Personnel Expenses 2,821,954.71 3,008,156.44 3,140,065.22 3,312,659 3,532,540 219,881 6.6% 100-4200-1230 Supplies - Equipment 4,871.98 9,907.11 3,768.86 7,100 7,100 - 0.0% 100-4200-1600 Operating Supplies 11,577.30 10,362.35 8,877.55 12,200 12,200 - 0.0% 100-4200-1700 Motor Fuel & Lubricants 34,496.42 35,226.10 45,212.38 52,325 52,325 - 0.0% 100-4200-2100 Books & Periodicals 142.50 55.00 145.00 300 300 - 0.0% 100-4200-2400 Uniforms & Clothing 23,485.78 27,451.32 26,110.73 24,280 24,724 444 1.8% Supplies and Materials 74,573.98 83,001.88 84,114.52 96,205 96,649 444 0.5% 100-4200-3010 General Legal Services - - - - 1,000 1,000 0.0% 100-4200-3020 Prosecuting Attorney Services 73,500.00 73,500.00 73,500.00 75,000 75,000 - 0.0% 100-4200-3030 Other Professional Services 5,460.68 5,501.89 9,497.77 9,850 20,503 10,653 108.2% 100-4200-3050 Dispatching - Contractual 96,807.84 91,001.57 107,546.47 94,819 83,907 (10,912) -11.5% 100-4200-3055 Information System Fees 1,795.22 2,611.19 3,621.75 4,955 4,955 - 0.0% 100-4200-3070 Cops Events 5,259.83 8,429.67 14,024.30 6,000 6,000 - 0.0% 100-4200-3080 Veterinary Services 906.21 2,682.91 12,162.58 2,000 2,000 - 0.0% 100-4200-3100 Telephone 15,884.53 17,959.92 18,007.54 18,590 18,590 - 0.0% 100-4200-3210 Electricity 434.49 449.04 523.57 450 450 - 0.0% 100-4200-3430 Printing - - - 400 400 - 0.0% 100-4200-3610 Memberships 2,551.00 1,991.00 1,511.00 1,656 1,976 320 19.3% 100-4200-3630 Training & Conferences 22,843.48 28,087.52 32,271.57 26,370 29,370 3,000 11.4% 100-4200-4800 Insurance & Bonds 57,482.11 56,634.57 175,264.95 59,500 74,880 15,380 25.8% 100-4200-5100 Repairs, Computers 76,267.12 92,955.51 92,904.45 111,187 133,650 22,463 20.2% 100-4200-5130 Repairs, Equipment 2,952.61 1,872.81 1,484.47 9,840 10,475 635 6.5% Other Services and Charges 362,145.12 383,677.60 542,320.42 420,617 463,156 42,539 10.1% 4200 Police 3,258,673.81 3,474,835.92 3,766,500.16 3,829,481 4,092,345 262,864 6.9% 18 Fund: 100 Department: 4200 Police ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1210 Supplies, bldgs & grounds - - - - - Carpet cleaning & misc maintenance items 1220 Supplies, vehicles - - - Brake fluid, misc. parts, anti freeze, a/c gas, headlights, spots, bulbs, tune-up, wipers, filters, brakes, tires, batteries 1230 Supplies, equipment < $5000 3,000 3,000 Miscellaneous office equipment - - Laptop - - SLR camera for Investigations add PSO camera $200 - - Shredder - - Rifle mounts (10@$300 each) - - Bicycles and racks for park patrol (3) 1,000 1,000 40 mm launcher 800 800 Alco-sensor portable breath test (PBT's) ($800 each) 2,300 2,300 light bar $2,300 4,872 9,907 3,769 7,100 7,100 1600 Supplies, operating 3,000 3,000 Photo print supplies, fire extinguishers, gloves, inkjet cartridges, toner, etc. 1,200 1,200 K9 Food 500 500 Portable radio batteries (10) @ $50 7,500 7,500 Batteries, breathalyzer parts, DVD's & CD's, disinfectant, simulation ammo ammunition, crime scene tape, emergency blankets, etc. - - Photo print supplies 11,577 10,362 8,878 12,200 12,200 1700 Motor, fuels, & lubs -50,375 50,375 Unleaded gas 15,500 gallons @ $3.25/gal. 1,950 1,950 K9 take home car gas 600 gallons @ $3.25 34,496 35,226 45,212 52,325 52,325 2100 Books & periodicals 143 55 145 300 300 Traf. law, crim. law, HR, employ. law, school year books, & misc. books 2400 Uniforms & clothing 880 900 Chief 880 900 Deputy Chief 4,000 4,000 Initial officer set-ups replacing up to two retiring officers 16,720 17,100 16 officers @ $880, 3 sgts @ $880 (2024 - $900, 2025 - $920) 800 824 Admin. assistant, Records tech, 2@$412 1,000 1,000 Traffic vests, Taser holsters, & misc items 23,486 27,451 26,111 24,280 24,724 3010 General legal - - - - 1,000 Police Civil Service Commission 3020 Legal, prosecuting attorney 73,500 73,500 73,500 75,000 75,000 Retainer ($6,125 per month)(misc charges $1,500) 3030 Other professional services 900 900 Tobacco compliance project 150 150 Hazardous material disposal fee 1,400 1,400 Lab fees, blood tests, physical tests, video, misc. 5,000 5,000 Mental Health Service (annual)(Ridgeway and Associates) - 8,913 Fence Consortium annual - 1,740 Certified Crime Fighter training tracker (CCF)(annual) 1,400 1,400 Automated Pawn service 1,000 1,000 Civil Service and medical testing for new officers - - Transcription service (for large case files) - - Liaison Officer - payment to City of New Brighton 5,461 5,502 9,498 9,850 20,503 3050 Dispatching 96,808 91,002 107,546 94,819 83,907 Ramsey County dispatching 3055 Informational systems fees 2,080 2,080 State service fee - CJDN ($510 per quarter) - - Dedicated CAD Line per St.Paul Records Mgt. System requirement 2,350 2,350 BCA connectivity charge thru Ramsey Cty for CAD 525 525 IACP.net ($525 annual) 1,795 2,611 3,622 4,955 4,955 3070 COPS events/outreach 5,260 8,430 14,024 6,000 6,000 NNO, child ID, stickers, shop, bowl, outreach, COP House discontinued 3080 Veterinarian services 1,000 1,000 Veterinary impound services 1,000 1,000 K9 vet services 906 2,683 12,163 2,000 2,000 3100 Telephone 12,348 12,348 Cell phones (increase from 14 to 21 phones$49 per)(all smart) 6,242 6,242 Air cards for squads CAD (13) at $40.01 per month 15,885 17,960 18,008 18,590 18,590 3210 Electricity 434 449 524 450 450 Civil defense siren's electricity 19 Fund: 100 Department: 4200 Police ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 3430 Printing - - - 400 400 Dept manual, Emergency management manual, business cards, 3610 Memberships 75 75 Tri-County Investigator Association 45 45 Mn Crime Prevention Association - - Mn DARE Officers Association - - MN Emergency Managers Assoc. - - MN Juvenile Officer Assoc 2@ $40 420 420 Mn Police chiefs - 320 FBI National Academy Assoc. 150 150 IACP (International Association of Chief of Police) 36 36 MN Sex Crime Investigators Assoc. 30 30 Natl. Assoc. School Resource Officers - - National DARE Officers Association 200 200 K9 memberships - - Notary commission (3 year due in 2021)($120+$20) 630 630 POST license reimbursement 7 @ $90 35 35 Prof. Law Enforcement Admin. Assoc. 35 35 National Association of Town Watch 2,551 1,991 1,511 1,656 1,976 3630 Training 710 710 MN Chief's conference 2@$355 400 400 BCA/CJDN training (new records tech) 450 450 Intox certification (6@$75) 2,000 2,000 Range Rental - - Juvenal Officer conference - - Emergency Management Conference (reimbursed by HLS) 400 400 MN Sex Crimes Investigators Assoc Conference 2,000 5,000 Tuition reimbursement 4,000 4,000 Supervisor training - - New K9 (If the foundation does not fund) 3,000 3,000 K9 training 1,000 1,000 Emergency Management training 6,000 6,000 Employee development courses 4,000 4,000 Ramsey County SWAT Training and Equipment (New for 2019) 1,615 1,615 Patrol on-line program 795 795 Post training for officers at Century College (1 officers) 22,843 28,088 32,272 26,370 29,370 4010 Rental, equipment - - - - - Copy machine 2007 rate $174.99 X 1.03 =$180.25/mo or $2163/year 4800 Insurance & bonds 25,000 25,000 Liability and automotive insurance 14,500 29,880 Insurance per MN Statute 299A.465 (disability pension eligible employees) 20,000 20,000 Allowance for insurance policy deductibles 57,482 56,635 175,265 59,500 74,880 5100 Technology - maintenance - - Computer network & technology assistance - Roseville (consolidated below) agreements & support 1,000 1,000 Copier maintenance + overages (Loffler) 2,000 2,000 Automatic License plate reader maintenance - - E-ticketing annual maintenance fees - - Software interface fee w/LETG + CAD records mgt and comp aided disp. 2,500 2,500 Taser Maintenance 8,000 4,000 Watch Guard body camera maintenance 2,500 17,220 Body Camera Server maint. (transition to cloud in 24 annual maint. $17,220) - - Air cards for squad CAD (move to 3100) 10,378 10,355 Milestone video maintenance and licenses (Metro Inet) 6,340 7,555 NetMotion 2 factor authentication (Metro Inet) 49,407 58,504 IT support for squad computers and other technology (Metro INet) 419 440 CAD interface (Tritech)(5%)($344 - 2019) 28,643 30,076 Records mgt system and ticket writer annual maintence (Tritech)(5%) 76,267 92,956 92,904 111,187 133,650 5120 Repairs, vehicles - - - Accidents, tires, alignments, glass, radiator, transmission, ignition 5130 Repairs, equipment 2,579 2,579 Misc. equipment repair - defibs, cameras, recorders, fax, printers. - - Car washing 2,000 2,000 Rockwall replacement cables 800 800 Fire extinguisher recharging and inspection - - Squad mobile digital computer repairs 1,000 1,635 Civil Defense siren repair & maint. (maintenance agreement 24 - 27) 2,000 2,000 Radio repair (one-time reprogramming fee $50) 1,461 1,461 800 MHZ radio licenses fees 39 @ 3.12 per month 2,953 1,873 1,484 9,840 10,475 7030 Equipment > $5000 - - - - - Video Recording system - Interview and breath test rooms 7040 Vehicles - Patrol - - - - - (squad purchases moved to vehicle and equipment capital project fund) 436,719 466,679 626,435 516,822 559,805 6.86% 34.23% -17.50% 8.32% 20 THIS PAGE LEFT BLANK INTENTIONALLY 21 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4210-3030 Other Professional Services 2,050.00 - - 2,000 2,000 - 0.0% 100-4210-3032 Contractual Fire Services 463,476.00 444,872.16 465,228.00 481,585 509,392 27,807 5.8% 100-4210-3050 Dispatching - Contractual 5,463.64 5,627.54 5,796.37 5,970 6,149 179 3.0% Other Services and Charges 470,989.64 450,499.70 471,024.37 489,555 517,541 27,986 5.7% 100-4210-7040 Vehicles 51,194.00 7,440.00 84,630.00 84,630 121,706 37,076 43.8% Capital Expenditures 51,194.00 7,440.00 84,630.00 84,630 121,706 37,076 43.8% 100-4210-8010 Debt, Principal 144,781.90 162,551.10 148,025.00 115,475 81,375 (34,100) -29.5% 100-4210-8020 Debt, Interest 18,253.72 - 9,989.76 5,634 3,302 (2,332) -41.4% Debt 163,035.62 162,551.10 158,014.76 121,109 84,677 (36,432) -30.1% 4210 Fire 685,219.26 620,490.80 713,669.13 695,294 723,924 28,630 4.1% 22 Fund: 100 Department: 4210 Fire ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 3030 Fire inspection services 2,050 - - 2,000 2,000 Contractual fee for Fire Marshalling services (SBM) 3032 Contractual fire services 463,476 444,872 465,228 481,585 509,392 Share joint fire dept. costs (fixed @ 15.50%) 3050 Dispatching 5,464 5,628 5,796 5,970 6,149 Anoka County dispatching fee R8810 annual 3% increases 7040 Capital, vehicles & equipment 51,194 7,440 84,630 84,630 121,706 Share of joint fire department's capital costs 8010 Principal - Fire bond - Blaine 144,782 162,551 148,025 115,475 81,375 15.500% of prin pymt on 2013 refunding Fire bonds 8020 Interest - Fire bond - Blaine 18,254 - 9,990 5,634 3,302 15.500% of int pymt on 2013 refunding Fire bonds 685,219 620,491 713,669 695,294 723,924 -9.45% 15.02% -2.57% 4.12% 23 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4360-0100 Regular Salaries 161,399.83 222,607.06 212,624.25 228,053 237,720 9,667 4.2% 100-4360-0110 Overtime Salaries 9,474.87 20,476.14 19,718.30 9,841 13,240 3,399 34.5% 100-4360-0150 Part Time Salaries 32,265.00 22,862.75 22,330.21 37,593 41,760 4,167 11.1% 100-4360-0300 Social Security 15,349.15 20,065.68 19,139.16 21,076 22,390 1,314 6.2% 100-4360-0321 Pera Coordinated - Employer Co 12,224.09 16,768.08 16,194.04 17,842 18,820 978 5.5% 100-4360-0400 Health Insurance - Employer Co 20,455.86 32,378.66 30,740.07 44,910 38,370 (6,540) -14.6% 100-4360-0410 Life Insurance - Employer Cont 387.71 539.62 526.34 - - - 0.0% 100-4360-0420 Dental Insurance - Employer Co 1,089.41 1,679.04 1,642.17 - - - 0.0% 100-4360-0500 Workers Comp Ins Premiums 12,354.00 11,756.88 13,489.56 21,120 22,970 1,850 8.8% 100-4360-0600 Unemployment - - 3.16 - - - 0.0% Personnel Expenses 264,999.92 349,133.91 336,407.26 380,435 395,270 14,835 3.9% 100-4360-1210 Supplies - Bldgs & Grounds 12,251.50 11,976.31 10,895.82 14,600 14,600 - 0.0% 100-4360-1220 Supplies, Vehicles 7,224.29 9,254.30 8,745.71 7,000 9,000 2,000 28.6% 100-4360-1230 Supplies, Equipment 14,042.42 8,880.72 17,055.00 14,850 22,100 7,250 48.8% 100-4360-1600 Operating Supplies 8,074.28 10,646.74 12,897.93 24,700 23,700 (1,000) -4.0% 100-4360-1700 Motor Fuels & Lubricants 7,793.80 8,367.14 10,244.60 10,750 11,275 525 4.9% 100-4360-2400 Uniform & Clothing 2,637.36 2,709.63 2,548.48 1,300 1,900 600 46.2% 100-4360-2410 Maintenance;Mats,Towels,M 628.80 636.97 465.26 728 728 - 0.0% Supplies and Materials 52,652.45 52,471.81 62,852.80 73,928 83,303 9,375 12.7% 100-4360-3030 Other Professional Services 9,845.53 6,785.07 11,185.53 1,880 2,925 1,045 55.6% 100-4360-3100 Telephone 1,635.74 1,348.06 1,280.23 1,800 1,800 - 0.0% 100-4360-3200 Water & Sewer 9,306.77 8,890.61 7,324.72 6,500 7,500 1,000 15.4% 100-4360-3210 Electricity 9,657.54 14,273.65 17,460.90 10,500 17,000 6,500 61.9% 100-4360-3220 Natural Gas 4,903.62 4,614.46 7,868.52 5,200 8,000 2,800 53.8% 100-4360-3530 Refuse Collection - - 92.00 - - - 0.0% 100-4360-3610 Memberships - 400.00 - 100 100 - 0.0% 100-4360-3630 Training & Conferences 220.00 1,889.00 1,133.44 5,120 5,120 - 0.0% 100-4360-3900 Grants To Other Organizations 11,573.00 11,500.00 11,500.00 12,500 12,500 - 0.0% 100-4360-4010 Rental, Equipment 2,628.24 55.92 2,124.79 2,000 2,000 - 0.0% 100-4360-4030 Portable Toilets 5,256.14 7,065.10 5,724.56 6,000 7,000 1,000 16.7% 100-4360-4800 Insurance & Bonds 14,117.62 12,000.18 11,863.68 15,000 15,000 - 0.0% 100-4360-5110 Repairs, Buildings & Grounds 12,269.84 14,673.78 15,129.29 9,690 9,690 - 0.0% 100-4360-5130 Repairs, Equipment 343.90 - - - - - 0.0% Other Services and Charges 81,757.94 83,495.83 92,687.66 76,290 88,635 12,345 16.2% 4360 Park Maintenance 399,410.31 485,101.55 491,947.72 530,653 567,208 36,555 6.9% 24 Fund: 100 Department: 4360 Parks ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1210 Supplies, bldgs & grounds 200 200 Replace bleacher parts 200 200 Repair hockey boards, gates 300 300 Sod 2,000 2,000 MV Blvd. trailway landscaping mulch, shrubs, and plants 500 500 Janitorial supplies 150 150 Snow shovels 200 200 Ice melt 500 500 Round up - - Repair fences, nets 500 500 Perennial flowers for park signs - - Replace play equipment parts 1,500 1,500 Damaged building components (windows, locks, etc.) 300 300 Graffiti remover - - Broadleaf control (move from 3030) 250 250 Goose repellent 2,000 2,000 Replace irrigation heads 2,000 2,000 City Hall Park sign (estimate) 4,000 4,000 Seed, fertilizer 12,252 11,976 10,896 14,600 14,600 1220 Supplies, vehicles 3,500 4,500 Oil filters, mower blades, tires, vehicle registration fees, - - Lift gate #428 3,500 4,500 Miscellaneous repairs 7,224 9,254 8,746 7,000 9,000 1230 Supplies, equipment < $5000 250 250 Drinking fountain parts 250 250 Field Lights 250 250 Park signage - - Trash cans (3) - - Ten portable 50 gallon trash cans with lids 1,000 1,750 Bases, jox boxes, etc. - - Ball field groomer, drag - 4,000 Drag for ball fields - - Gutter broom attachment 700 700 Chain saw (emergency only)(every 2 years)(weed whip) 2,000 3,000 Replace trash cans ($397 each) 4,400 4,400 Grills (CH, Silver View) Ash recepticles (Groveland, Hillview, CH, Random) 6,000 7,500 Replace park equipment, fixtures and misc parts, splash pad parts 14,042 8,881 17,055 14,850 22,100 1600 Supplies, operating 2,800 2,000 Fiber fill for play lots & courts 1,000 1,500 Herbicide 1,800 1,800 Wood chips for trees 1,500 1,400 Ag-lime, black dirt, seed, and surface drying compound for fields - - Surface drying compound 3,000 4,000 Splash Pad chemicals 800 800 Nets 3,100 2,700 Field paint & chalk (partially reimb by school district) - - Jox box (Silverview (2), CH park (1) in 2014) 700 500 Landscaping materials - - Percentage of shop costs 9,500 8,500 Broadleaf control supplies (moved in-house from acct. 3030) 500 500 Hand tools (batteries for hand tools) - - Aggregate for ballfields & trails (3/8" or smaller) 8,074 10,647 12,898 24,700 23,700 1700 Motor fuels & lubes 7,150 7,475 2,300 gallons of unleaded gas @ $3.25 3,600 3,800 950 gallons of diesel fuel @ $4.00 7,794 8,367 10,245 10,750 11,275 2400 Uniforms & clothing 400 600 Clothing allowance 3.0 FTE 600 800 Uniforms 18.2% of $4,500 300 500 Safety glasses, masks, ear protection, etc. 2,637 2,710 2,548 1,300 1,900 2410 Mats & towels 629 637 465 728 728 Share of floor mats and shop towels 18.2% of $4,000 3030 Other professional services 240 240 Fire extinguisher inspection/maint. (2@ $120) - - HVAC maintenance (in Buildings & Grounds) 1,400 1,400 Fire sprinkler testing - 1,045 RPZ Testing 240 240 Backflow prevention testing (3@ $80) 9,846 6,785 11,186 1,880 2,925 Broadleaf control (moved to acct. 1600 will do in-house) 25 Fund: 100 Department: 4360 Parks (continued) ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 3100 Telephone 1,800 1,800 Cellular phones (13.1% of $9,200)(Add tablet in 2023) - - GPS units for mowers (split with dept 4472) - - Replace telephones in park buildings - - Security at Silver View (phones removed from park buildings) 1,636 1,348 1,280 1,800 1,800 3200 Water & wastewater 9,307 8,891 7,325 6,500 7,500 Parkland irrigation & park bathrooms 3210 Electricity 9,658 14,274 17,461 10,500 17,000 Est. 5 park buildings, park sec. lighting, court & field lighting & splash pad 3220 Natural gas 4,904 4,614 7,869 5,200 8,000 Heating cost for Hodges, Hillview, Groveland, & Lambert Park bldgs. 3530 Refuse collection - - 92 - - 3610 Memberships - 400 - 100 100 Playground inspector license (2) 3630 Training & conferences 75 75 Computer classes - - Tuition reimbursement - - Confined space training 100 100 Hearing tests/RTN training (2@$50) - - Low voltage/power limited training 60 60 Maintenance EXPO 110 110 Loss control workshops 1,900 1,900 Playground inspection training (Certified Playground Safety Inspector CPSI) 375 375 Equipment training (18.2% of $2,050) - - Minn Toro Industries school 1,800 1,800 Green Expo 700 700 Certified Pesticide Operator (every 5 years)(2) - - Pesticide license renewal (every 2 years)(in 3610) - - State low voltage electrical licenses (2) - - Sewer, Water & traffic certificates - - Tree inspector training (moved to 4380) - - Work zone traffic control 220 1,889 1,133 5,120 5,120 3900 Grants & subsidies 11,573 11,500 11,500 12,500 12,500 Lakeside Park share of operating costs 4010 Rental, equipment 2,628 56 2,125 2,000 2,000 Tools and equipment (sod cutter, chipper, concrete mixer, etc...) 4030 Portable restrooms 5,256 7,065 5,725 6,000 7,000 For May thru Oct, plus special events such as (add Hodges Park) 4800 Bonding & insurance 11,000 11,000 Insurance policy premiums 4,000 4,000 Allowance for insurance policy deductibles 14,118 12,000 11,864 15,000 15,000 5110 Repairs, bldgs & grounds 750 750 Windows, doors, & lock repairs - - Replace locks - - Sandblast trash cans and paint 1,000 1,000 Building exterior repairs 1,500 1,500 Irrigation system repairs 750 750 Field light repairs 3,000 3,000 Repairs to playground equipment 1,250 1,250 Repairs to furnaces, plumbing, phones, electrical, etc 1,440 1,440 HVAC preventive maintenance agreement (4 park buildings) 12,270 14,674 15,129 9,690 9,690 5130 Repairs equipment 344 - - - - 7030 Capital, equipment > $5000 - - - - - Trencher (irrigation repairs and oak wilt treatments) 7050 Capital, construction - - - - - Mounument signs for 1/2 of parks (1st half started in 07) 134,410 135,968 155,540 150,218 171,938 1.16% 14.40% -3.42% 14.46% 26 THIS PAGE LEFT BLANK INTENTIONALLY 27 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4380-0100 Regular Salaries 3,646.57 6,409.58 4,656.09 7,508 7,990 482 6.4% 100-4380-0110 Overtime Salaries 135.33 115.24 186.03 - - - 0.0% 100-4380-0300 Social Security 286.08 502.88 347.79 574 610 36 6.3% 100-4380-0321 PERA Employer 288.91 494.07 342.20 563 600 37 6.6% 100-4380-0400 Health Employer 489.12 1,106.40 909.09 1,710 750 (960) -56.1% 100-4380-0410 Life Employer 3.94 7.76 5.82 - - - 0.0% 100-4380-0420 Dental Employer 22.52 53.29 45.68 - - - 0.0% 100-4380-0500 Workers Comp Ins Premiums 315.24 302.45 347.40 577 650 73 12.7% Personnel Expenses 5,187.71 8,991.67 6,840.10 10,932 10,600 (332) -3.0% 100-4380-1200 Supplies, Landscaping 5,488.40 5,919.89 9,255.75 9,400 9,600 200 2.1% 100-4380-1600 Operating Supplies - - 159.44 - - - 0.0% Supplies and Materials 5,488.40 5,919.89 9,415.19 9,400 9,600 200 2.1% 100-4380-3030 Other Professional Services 5,000.00 4,200.00 918.98 7,500 7,500 - 0.0% 100-4380-3520 Tree Removal 48,216.00 45,124.50 86,919.00 48,000 70,000 22,000 45.8% 100-4380-3630 Training & Conferences 200.00 768.00 545.00 2,420 2,420 - 0.0% Other Services and Charges 53,416.00 50,092.50 88,382.98 57,920 79,920 22,000 38.0% 4380 Forestry 64,092.11 65,004.06 104,638.27 78,252 100,120 21,868 27.9% 28 Fund: 100 Department: 4380 Forestry ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1200 Supplies, landscaping 400 600 Landscaping materials 1,500 1,500 Small trees to replace damaged trees 2,500 2,500 Large trees - storm damage replacement 800 800 Forestry equipment (saw, chaps, chains) 4,200 4,200 Ash tree replacement trees (EAB) - - EAB treatment supplies 5,488 5,920 9,256 9,400 9,600 1210 Supplies, bldgs & grounds - - - - - City Hall flowers 1600 Supplies, operating - - 159 - - Film, developing, manuals, pamphlets 2400 Uniforms & Clothing - - - - - Uniforms/Clothing allowance 3030 Professional services 3,500 3,500 Tree trimming 500 500 Asset mgt. software 1,500 1,500 Forestry consulting/testing 2,000 2,000 Tree injections (Ash every 2 years) 5,000 4,200 919 7,500 7,500 3033 Joint powers forester - - - - - Amount per joint powers agreement 3520 Tree removal 48,216 45,125 86,919 48,000 70,000 Remove or treat diseased trees (offset by charges 100-3432 50%) 3630 Training & memberships 800 800 Tree Inspector training 120 120 ISA membership 600 600 Arborist Test 900 900 Tree Inspector license (3) 200 768 545 2,420 2,420 3900 Grants & subsidies - - - - - Tree Inventory costing $10,000 (50% grant & 50% local match) 58,904 56,012 97,798 67,320 89,520 -4.91% 74.60% -31.16% 32.98% 29 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4410-0100 Regular Salaries 90,000.04 91,464.13 103,085.93 105,417 144,540 39,123 37.1% 100-4410-0110 Overtime Salaries 1,109.50 977.67 1,722.11 - - - 0.0% 100-4410-0150 Part Time Salaries (91.24) - - - - - 0.0% 100-4410-0300 Social Security 6,769.10 6,870.21 7,779.06 7,795 11,060 3,265 41.9% 100-4410-0321 PERA Employer 6,816.03 6,747.43 7,719.03 7,643 10,840 3,197 41.8% 100-4410-0400 Health Employer 10,173.60 10,198.21 10,230.98 13,320 20,300 6,980 52.4% 100-4410-0410 Life Employer 334.48 333.98 334.44 - - - 0.0% 100-4410-0420 Dental Employer 551.04 559.63 575.19 - - - 0.0% 100-4410-0500 Workers Comp Ins Premiums 802.44 417.04 485.29 870 2,690 1,820 209.2% Personnel Expenses 116,464.99 117,568.30 131,932.03 135,045 189,430 54,385 40.3% 100-4410-1600 Operating Supplies 262.11 449.41 379.49 800 800 - 0.0% 100-4410-2400 Uniform & Clothing 105.57 150.00 179.79 200 200 - 0.0% 100-4410-2410 Maintenance;Mats,Towels,M 48.26 49.01 36.11 - - - 0.0% Supplies and Materials 415.94 648.42 595.39 1,000 1,000 - 0.0% 100-4410-3030 Other Professional Services 975.62 352.00 - 900 900 - 0.0% 100-4410-3100 Telephone 578.70 852.75 992.36 773 773 - 0.0% 100-4410-3610 Memberships 400.00 - 400.00 1,610 1,610 - 0.0% 100-4410-3630 Training & Conferences 140.00 1,655.87 807.43 895 1,295 400 44.7% 100-4410-3800 Mileage - - - 100 100 - 0.0% Other Services and Charges 2,094.32 2,860.62 2,199.79 4,278 4,678 400 9.4% 4410 Public Works Admin 118,975.25 121,077.34 134,727.21 140,323 195,108 54,785 39.0% 30 Fund: 100 Department: 4410 Public Works Adminstration ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1230 Supplies, equipment - - - - - 1600 Operating Supplies 262 449 379 800 800 Office supplies 2400 Uniforms & clothing 106 150 180 200 200 33% of Supervisor's uniform cost. 2410 Maint - mats, towels 48 49 36 - - 3030 Other professional services 100 100 Physicals & drug testing - new employee - - Capital Improvement Program Software (maintenance contract) - - EJCDC Construction document set 500 500 Asset mgt software 300 300 Drug & alcohol testing - federal mandate 976 352 - 900 900 3100 Telephone 579 853 992 773 773 Cellphone (8.4% of $9,200) 3610 Memberships/license fee 400 400 American Public Works Association memb. (APWA) (1/2 of $800) 60 60 City Engineer's Association of MN (CEAM) - - NASASP (National Assoc. of State Agencies for Surplus Property) 200 200 Safe Assure 500 500 Minnesota Parks & Recreation Association (MPRA) 450 450 National Rereations & Parks Association (NRPA) - - MN Board of AELSLAGID (PE Renewal even years) - - American Society of Civil Engineers 400 - 400 1,610 1,610 3630 Training & conferences 500 500 CEAM / APWA conferences 50 50 Computer classes/Web training - - Confined space training 15 15 Hearing tests/RTN training (.34 FTE@$50) 30 30 Maintenance Expo - - Pesticide applicator's class - - Pesticide license renewal 200 200 Required continuing education seminars 100 500 Supervisor training - - Work zone traffic control 140 1,656 807 895 1,295 3800 Mileage reimbursement - - - 100 100 vehicle mileage reimbursement 7030 Capital, equipment > $5000 - - - - - 2,510 3,509 2,795 5,278 5,678 39.79% -20.34% 88.83% 7.58% 31 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4460-0100 Regular Salaries 11,882.11 9,733.85 9,366.97 23,686 19,180 (4,506) -19.0% 100-4460-0110 Overtime Salaries 880.29 1,235.32 299.61 928 1,220 292 31.5% 100-4460-0300 Social Security 965.67 831.24 736.01 1,883 1,560 (323) -17.2% 100-4460-0321 PERA Employer 921.53 773.53 693.70 1,847 1,530 (317) -17.2% 100-4460-0400 Health Employer 74.23 305.18 316.08 3,240 3,870 630 19.4% 100-4460-0410 Life Employer 34.06 24.67 23.28 - - - 0.0% 100-4460-0420 Dental Employer 65.89 73.14 78.24 - - - 0.0% 100-4460-0500 Workers Comp Ins Premiums 846.64 556.90 484.00 1,463 1,200 (263) -18.0% Personnel Expenses 15,670.42 13,533.83 11,997.89 33,047 28,560 (4,487) -13.6% 100-4460-1210 Supplies - Bldgs & Grounds 2,550.76 1,542.41 2,723.38 11,172 11,172 - 0.0% 100-4460-1220 Supplies, Vehicles - 23.78 - - - - 0.0% 100-4460-1230 Supplies, Equipment 783.88 694.53 1,475.11 2,000 2,000 - 0.0% 100-4460-1600 Operating Supplies 11,620.77 5,222.42 6,420.32 5,900 6,700 800 13.6% 100-4460-2400 Uniforms & Clothing 35.56 51.82 33.80 117 117 - 0.0% 100-4460-2410 Maintenance;Mats,Towels,M 16.03 15.07 11.53 1,000 1,000 - 0.0% Supplies and Materials 15,007.00 7,550.03 10,664.14 20,189 20,989 800 4.0% 100-4460-3030 Other Professional Services 44,297.34 50,376.71 45,357.34 20,260 45,260 25,000 123.4% 100-4460-3100 Telephone 1,294.20 217.84 265.26 129 129 - 0.0% 100-4460-3200 Water & Sewer 1,090.82 846.08 1,021.14 1,000 1,000 - 0.0% 100-4460-3210 Electricity 30,422.07 33,506.41 40,369.49 30,000 42,000 12,000 40.0% 100-4460-3220 Natural Gas 19,500.70 18,625.07 33,194.99 18,500 34,000 15,500 83.8% 100-4460-3530 Refuse Collection 10,181.23 9,574.00 13,007.27 10,000 13,500 3,500 35.0% 100-4460-4010 Rental, Equipment - - - 200 200 - 0.0% 100-4460-4800 Insurance & Bonds 5,877.56 5,600.08 5,536.39 7,000 7,000 - 0.0% 100-4460-5110 Repairs, Buildings & Grounds 21,475.63 30,521.17 19,776.45 20,905 23,905 3,000 14.4% 100-4460-5130 Repairs, Equipment 6,252.89 8,909.26 8,357.02 6,000 6,000 - 0.0% Other Services and Charges 140,392.44 158,176.62 166,885.35 113,994 172,994 59,000 51.8% 4460 Bldgs & Grounds 171,069.86 179,260.48 189,547.38 167,230 222,543 55,313 33.1% 32 Fund: 100 Department: 4460 Building & Ground Maintenance ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1210 Supplies, bldgs & grounds 3,400 3,400 Bldg repairs, cleaning/heating supplies, batteries 7,772 7,772 Genesis Air bulbs (HVAC) 2,551 1,542 2,723 11,172 11,172 1220 Supplies, vehicles - 24 - - - 1230 Supplies, equipment < $5000 784 695 1,475 2,000 2,000 Repair parts, filters, hoses, etc., office furniture 1600 Supplies, operating 1,700 2,100 Cleaning supplies 150 150 Lumber & fasteners 300 300 Repair items & hardware 300 300 First aid supplies 200 200 Light bulbs & ballasts 950 950 Paper supplies 600 600 Mechanical items, fans, motors, etc - - Goose repellent - - Weed control - city hall 1,000 1,400 Office supplies - - Meeting refreshments - - Steel supplies 700 700 Paint & supplies - parking lot & building 11,621 5,222 6,420 5,900 6,700 2400 Uniforms & clothing 81 81 Uniforms (1.8% of $4,500) 36 36 Clothing & boot allowance (.20 @$175) 36 52 34 117 117 2410 Mats & towels 90 90 Share of floor mats and shop towels (1.8% of $5,000) 910 910 Floor mats at CH ($45/month) 16 15 12 1,000 1,000 3030 Other professional services 400 400 Backflow prevention testing (5@$80) 60 60 Boiler & pressure vessel registration program 9,500 9,500 HVAC maintenance (City Hall & PW facilities) Emergency spill services - 25,000 City Hall cleaning contract (renews in 2019)(moved in house) - - PW cleaning contract (new)(moved in house) 3,500 3,500 Carpet cleaning, floor striping & waxing (2 times) 1,800 1,800 Alarm testing and monitoring 1,200 1,200 Pest control (12@$100) - - MDH Monitoring well maint. permit - PW bldg. (wells sealed) 2,800 2,800 Service contract for generator 1,000 1,000 Fire extingiusher inspection/service (30@$20) Toxalet testing 44,297 50,377 45,357 20,260 45,260 3100 Telephone 1,294 218 265 129 129 Cellphone (1.6% of $7,500)($9,200) 3200 Water & Sewer 1,091 846 1,021 1,000 1,000 Service at City Hall and Public Works buildings 3210 Electricity 30,422 33,506 40,369 30,000 42,000 Electricity at City Hall and Public Works buildings 3220 Natural gas 19,501 18,625 33,195 18,500 34,000 Natural gas at City Hall and Public Works buildings 3530 Refuse collection 196 196 Hazardous waste disposal, Lamps $100, batteries $30 264 264 Hazardous waste annual fee (State of MN PCA) 470 470 Hazardous waste generator license fee (Ramsey County) 150 150 Used oil filters ($100 in vehicle maint.) 8,920 10,920 Facility dumpsters, city hall, public works - 1,500 Hazardous waste disposal 10,181 9,574 13,007 10,000 13,500 4010 Rental, equipment - - - 200 200 Misc. rentals 4800 Bonding & insurance 5,500 5,500 Insurance policy premiums 1,500 1,500 Allowance for insurance policy deductibles 5,878 5,600 5,536 7,000 7,000 5110 Repairs, bldgs & grounds 4,500 4,500 Door & gate opener repairs - 3,000 Gate inspections (PW and PD)(2 times @ year) 4,755 4,755 Building repairs 1,200 1,200 Elevator maintenance & repairs 100 100 MN DOL operating permit - elevator 350 350 Fire sprinklers & alarm repairs 10,000 10,000 General building & ground maintenance - - Exterminator- City Hall and Public Works (in 3030) - - Fire extinguishers (in 3030) 21,476 30,521 19,776 20,905 23,905 5130 Repairs, equipment 6,253 8,909 8,357 6,000 6,000 HVAC, plumbing & electrical repairs 7030 Capital, equipment > $5000 - - - - - Walk behind broom (1/2 bldg. 1/2 MVCC) 155,399 165,727 177,549 134,183 193,983 6.65% 7.13% -24.43% 44.57% 33 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4465-0100 Regular Salaries 43,850.63 44,836.25 46,031.54 50,740 53,440 2,700 5.3% 100-4465-0110 Overtime Salaries 2,140.31 2,168.35 2,938.01 765 820 55 7.2% 100-4465-0300 Social Security 3,042.98 3,183.29 3,317.21 3,940 4,150 210 5.3% 100-4465-0321 PERA Employer 3,477.62 3,467.02 3,642.91 3,863 4,070 207 5.4% 100-4465-0400 Health Employer 8,090.79 8,273.92 9,517.27 10,620 11,470 850 8.0% 100-4465-0410 Life Employer 28.65 27.20 28.47 - - - 0.0% 100-4465-0420 Dental Employer 63.36 68.86 71.85 - - - 0.0% 100-4465-0500 Workers Comp Ins Premiums 1,875.04 1,488.96 1,623.52 2,087 2,320 233 11.2% Personnel Expenses 62,569.38 63,513.85 67,170.78 72,015 76,270 4,255 5.9% 100-4465-1220 Supplies, Vehicles 31,026.62 28,049.54 30,606.60 30,195 32,632 2,437 8.1% 100-4465-1230 Supplies, Equipment 4,798.33 6,437.43 5,985.48 8,500 9,880 1,380 16.2% 100-4465-1600 Operating Supplies 7,818.11 3,514.85 6,511.62 7,950 7,350 (600) -7.5% 100-4465-1700 Motor Fuels & Lubricants - Unl 3,430.52 4,863.30 5,117.25 4,800 6,500 1,700 35.4% 100-4465-2400 Uniforms & Clothing 710.64 366.08 746.34 350 350 - 0.0% 100-4465-2410 Maintenance;Mats,Towels,M 204.59 207.15 151.50 220 220 - 0.0% Supplies and Materials 47,988.81 43,438.35 49,118.79 52,015 56,932 4,917 9.5% 100-4465-3030 Other Professional Services 70.60 1,728.00 - - - - 0.0% 100-4465-3100 Telephone 416.02 436.99 494.43 387 387 - 0.0% 100-4465-3530 Refuse Collection 50.00 - 345.75 100 100 - 0.0% 100-4465-3610 Memberships 16.00 - - 100 100 - 0.0% 100-4465-3630 Training & Conferences 130.00 306.00 1,058.60 1,810 2,210 400 22.1% 100-4465-4010 Rental, Equipment - 84.95 - 100 100 - 0.0% 100-4465-5120 Repairs, Vehicles 21,329.98 16,626.63 21,738.33 18,550 20,250 1,700 9.2% 100-4465-5130 Repairs, Equipment 3,532.91 3,800.59 5,132.35 9,500 9,500 - 0.0% Other Services and Charges 25,545.51 22,983.16 28,769.46 30,547 32,647 2,100 6.9% 4465 Veh/Equip Maintenance 136,103.70 129,935.36 145,059.03 154,577 165,849 11,272 7.3% 34 Fund: 100 Department: 4465 Vehicle & Equipment Maintenanc ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1220 Supplies, vehicles 200 340 Brake fluid 1,500 1,640 Misc parts, fastners 550 680 Anti freeze 300 430 Air conditioning gas 1,400 1,500 Headlamps, spots, & bulbs 1,800 1,940 Tune up items 550 680 Wiper blades & fluid 3,200 3,330 Minor repairs, rebuilds 2,900 3,330 Automotive parts 3,400 3,500 Filters: oil, air, fuel, transmission 3,500 4,030 Brake pads & shoes 10,895 11,232 Tires & batteries 31,027 28,050 30,607 30,195 32,632 1230 Supplies, equipment < $5000 3,000 3,100 Small equipment tune up items, hand tools 1,500 1,500 Filters belts & hoses 1,500 1,500 Hydraulic system repairs - 3,780 A/C unit and modis - - Band saw 2,500 - Vehicle Asset Management software - - Tire mounting machine (defer to 2016)(bought code scanner in 2015) - - Refridgerant ID machine - - Tires 4,798 6,437 5,985 8,500 9,880 1600 Supplies, operating 2,000 - Battery charger, Load tester (move to 1230 small equipment) 600 600 Welding supplies 800 800 Chains, clevises, & hitch pins 900 1,000 Equipment & vehicle cleaning supplies 700 700 Steel for repairs & fabrication 550 1,550 License tabs 1,200 1,200 Solvents & degreasers 1,200 1,500 Fastners & electrical supplies 7,818 3,515 6,512 7,950 7,350 1700 Motor fuels & lubricants 200 200 Gear lube 300 300 ATF - 7 cases 800 2,500 Aftermarket additives 3,500 3,500 Engine oil: 280 gallons (synthetic) - - Unleaded fuel: 900 gallons @ $4.00 (moved to Comm Dev) 3,431 4,863 5,117 4,800 6,500 2100 Books & periodicals - - - - - Ignition scanner software updates 2400 Uniforms & clothing 200 200 Uniforms 6% of $4,500) 150 150 Clothing and boot allowance (.6@$175) 711 366 746 350 350 2410 Mats & towels 205 207 152 220 220 Share of floor mats and shop towels (5.5% of $4,000) 3030 Other professional services 71 1,728 - - - 3100 Communications 416 437 494 387 387 Cellular telephone (4.1% of $9,200) 3530 Refuse collection 50 - 346 100 100 Oil filter recycling ($150 in 4460-3530) 3610 Memberships 16 - - 100 100 Vehicle inspection license renewal (DOT required) 3630 Training 30 30 Hearing test/RTN training (.6@$50) - - Equipment operation training (Skidsteer & boom) 30 30 Maintenance Expo 300 500 Misc training 1,200 1,200 ASE certifications - - Water/sewer license 250 450 Vehicle inspection recertification (DOT required) - - Work zone traffice control 130 306 1,059 1,810 2,210 4010 Rental, equipment - 85 - 100 100 Specialty tool & equipment rental 5120 Repairs, vehicles 8,500 9,500 Accident repairs 900 1,100 Alignments 1,200 1,200 Glass replacement 435 435 Radiator repairs, replacement 2,300 2,300 Tire repairs 1,200 1,500 Ignition scanner software update 1,815 2,015 Mitchell On Demand Software - - Vehicle and equipment inspections (Fork lift, rock wall, floor hoists) 2,200 2,200 Transmission repairs 21,330 16,627 21,738 18,550 20,250 5130 Repairs, equipment 500 500 Accident repairs 4,000 4,000 Oil testing 3,000 3,000 Mechanical repairs 2,000 2,000 Motor repairs 3,533 3,801 5,132 9,500 9,500 7030 Capital, equipment > $5000 - - - - - Hoist adaptor 73,534 66,422 77,888 82,562 89,579 -9.67% 17.26% 6.00% 8.50% 35 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4470-0100 Regular Salaries 121,924.34 105,974.20 128,685.80 133,202 137,680 4,478 3.4% 100-4470-0110 Overtime Salaries 6,128.15 3,228.34 6,129.29 4,027 4,030 3 0.1% 100-4470-0150 Part Time Salaries 4,560.00 14,115.00 15,866.17 10,605 11,780 1,175 11.1% 100-4470-0300 Social Security 9,488.43 9,108.22 11,169.81 11,269 11,740 471 4.2% 100-4470-0321 Pera Coordinated - Employer Co 9,170.39 7,943.91 9,834.87 10,254 10,630 376 3.7% 100-4470-0400 Health Insurance - Employer Co 11,255.48 11,449.93 11,945.97 19,485 25,180 5,695 29.2% 100-4470-0410 Life Insurance - Employer Cont 2,023.37 1,228.43 1,224.82 - - - 0.0% 100-4470-0420 Dental Insurance - Employer Co 654.24 525.72 843.12 - - - 0.0% 100-4470-0500 Workers Comp Ins Premiums 8,621.80 7,007.81 7,801.95 9,688 10,850 1,162 12.0% Personnel Expenses 173,826.20 160,581.56 193,501.80 198,530 211,890 13,360 6.7% 100-4470-1230 Supplies, Equipment 1,242.15 840.56 1,294.30 1,950 3,500 1,550 79.5% 100-4470-1240 Supplies, Streets 5,627.05 4,754.05 2,337.50 6,500 6,500 - 0.0% 100-4470-1260 Supplies, Traffic Control - 560.00 813.25 900 900 - 0.0% 100-4470-1600 Operating Supplies 558.81 1,308.26 2,308.75 2,000 650 (1,350) -67.5% 100-4470-1700 Motor Fuels & Lubricants 8,002.88 9,602.87 10,217.54 9,425 11,600 2,175 23.1% 100-4470-2400 Uniforms & Clothing 1,627.45 1,589.96 1,100.77 1,500 1,500 - 0.0% 100-4470-2410 Maintenance;Mats,Towels,M 375.74 380.66 279.53 436 436 - 0.0% Supplies and Materials 17,434.08 19,036.36 18,351.64 22,711 25,086 2,375 10.5% 100-4470-3030 Other Professional Services 13,405.13 13,323.00 13,838.48 16,950 16,950 - 0.0% 100-4470-3100 Telephone 1,352.58 893.57 782.56 966 966 - 0.0% 100-4470-3610 Memberships 200.00 200.00 200.00 230 230 - 0.0% 100-4470-3630 Training & Conferences 285.00 1,590.00 939.81 1,185 1,185 - 0.0% 100-4470-4010 Rental, Equipment 2,045.50 3,000.00 1,236.00 2,500 2,500 - 0.0% 100-4470-4800 Insurance & Bonds 5,205.83 4,960.08 4,903.65 6,200 6,200 - 0.0% 100-4470-5130 Repairs, Equipment 4,425.00 78.45 30.99 500 500 - 0.0% Other Services and Charges 26,919.04 24,045.10 21,931.49 28,531 28,531 - 0.0% 4470 Street Pavement Mgmt 218,179.32 203,663.02 233,784.93 249,772 265,507 15,735 6.3% 36 Fund: 100 Department: 4470 Pavement Management ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1230 Supplies, equipment < $5000 750 750 Safety vests and other safety equipment - - Radial arm saw - - Radio/hearing protection - - Traffic counters - - Push mower 800 800 Chainsaw 400 1,950 Hand tools (asphalt hand tools moved from 1600) - - Rear cameras for plow trucks - - Skid steer bucket (1/2 in snow & ice) 1,242 841 1,294 1,950 3,500 1240 Supplies, street repair 4,000 4,000 Asphalt & concrete for street patching & curb repair 1,000 1,000 Disposal 1,500 1,500 Bituminous tack coat/crack fill material 5,627 4,754 2,338 6,500 6,500 1260 Supplies, traffic control 400 400 Traffic cones/baracades 500 500 portable signs (traffic control) - 560 813 900 900 1600 Supplies, operating 1,350 - Asphalt hand tools, rakes, etc. (moved to 1230) - - Asphalt - winter mix, 25 tons @ $80 (move to 1240) - - Traffic marking paint (crosswalks)(move to 4475) 650 650 Batteries, shop supplies, etc. - - Tool box & tools 559 1,308 2,309 2,000 650 1700 Motor fuels & lubricants 5,200 6,400 Diesel fuel: 1600 gallons @ $4.00 - - Propane: 1100 gallons @ $2 4,225 5,200 Unleaded fuel: 1600 gallons @ $3.25 8,003 9,603 10,218 9,425 11,600 2400 Uniforms & clothing 1,200 1,200 Uniforms (10.9% of $4,500) 300 300 Clothing and boot allowance (1.2@$175) 1,627 1,590 1,101 1,500 1,500 2410 Mats & towels 376 381 280 436 436 Share of floor mats and shop towels (10.9% of $4,000) 3030 Other professional services 1,800 1,800 Pavement Mgmt software annual maintenance. 5,000 5,000 Engineering services. - - Annual certification of weight scales 500 500 Asset management software annual maintenance 650 650 ROW weed control - - Material dump charges 3,000 3,000 Sidewalk joint corrections 6,000 6,000 CSAH 10 Planter Maintenance - - Striping of streets (Ramsey County)(move to 4475) 13,405 13,323 13,838 16,950 16,950 3040 Consulting engineers - - - - - Pavement Mgmt Program, system analysis / long range plan 3100 Communications 1,353 894 783 966 966 Cellular telephones (10.5% of $9,200) 3610 Memberships 200 200 American Public Works Association memb. (APWA) (1/4 of $800) 30 30 Pesticide license renewal (TF) - - MN Safety Council 200 200 200 230 230 3630 Training & conferences 50 50 Computer classes - - Confined space training 150 150 Electronics updates, other classes 60 60 Hearing test/RTN training (1.16@$50) 240 240 Maintenance Expo 150 150 APWA/MN conferences. 250 250 Pavement, sealcoating, patching & sealcoating seminars. - - North Dakota Seminar for two - - PW mgt. Class - North Hennepin CC 150 150 Equipment operator training - - Pesticide applicator's class (every 2 years) 60 60 Vehicle inspection license renewal 75 75 Vehicle inspection recertification - - Work zone traffic control (every 3 years) 285 1,590 940 1,185 1,185 4010 Rentals, equipment - - Annual trade-in of skidsteer loaders (will purchase out of 460 Veh Equip) 2,500 2,500 Specialized equip rental (chipper, crack sealing,) 2,046 3,000 1,236 2,500 2,500 4800 Bonding & insurance 4,800 4,800 Insurance policy premiums 1,400 1,400 Allowance for insurance policy deductibles 5,206 4,960 4,904 6,200 6,200 5130 Repairs, equipment 4,425 78 31 500 500 Misc. equipment repairs 7030 Equipment > $5000 - - - - - Crack router 44,353 43,081 40,283 51,242 53,617 -2.87% -6.50% 27.20% 4.63% 37 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4472-0100 Regular Salaries 67,449.58 58,478.86 69,052.56 75,510 80,230 4,720 6.3% 100-4472-0110 Overtime Salaries 18,154.88 19,308.37 18,917.06 8,279 8,610 331 4.0% 100-4472-0300 Social Security 6,168.97 5,716.32 6,471.41 6,379 6,800 421 6.6% 100-4472-0321 PERA Employer 6,242.69 5,633.82 6,406.93 6,254 6,660 406 6.5% 100-4472-0400 Health Employer 6,995.94 6,223.12 7,523.13 11,880 15,950 4,070 34.3% 100-4472-0410 Life Employer 1,070.14 719.02 739.09 - - - 0.0% 100-4472-0420 Dental Employer 485.83 459.15 634.15 - - - 0.0% 100-4472-0500 Workers Comp Ins Premiums 6,506.96 5,015.02 5,596.88 6,918 6,930 12 0.2% Personnel Expenses 113,074.99 101,553.68 115,341.21 115,220 125,180 9,960 8.6% 100-4472-1230 Supplies, Equipment 9,596.73 18,324.72 (775.47) 8,900 8,900 - 0.0% 100-4472-1600 Operating Supplies 30,829.76 21,999.80 27,305.14 31,375 31,375 - 0.0% 100-4472-1700 Motor Fuels & Lubricants 3,295.12 2,736.74 4,446.81 4,180 5,180 1,000 23.9% 100-4472-2400 Uniforms & Clothing 540.39 520.25 523.88 550 550 - 0.0% 100-4472-2410 Maintenance;Mats,Towels,M 316.36 316.51 242.53 328 328 - 0.0% Supplies and Materials 44,578.36 43,898.02 31,742.89 45,333 46,333 1,000 2.2% 100-4472-3030 Other Professional Services 1,464.00 1,551.19 1,620.00 1,450 1,650 200 13.8% 100-4472-3100 Telephone 881.94 1,074.78 2,648.97 3,079 3,079 - 0.0% 100-4472-3630 Training & Conferences 85.00 - 250.00 285 285 - 0.0% 100-4472-5130 Repairs, Equipment 1,261.99 1,306.33 - 6,000 6,000 - 0.0% Other Services and Charges 3,692.93 3,932.30 4,518.97 10,814 11,014 200 1.8% 4472 Snow & Ice Control 161,346.28 149,384.00 151,603.07 171,367 182,527 11,160 6.5% 38 Fund: 100 Department: 4472 Snow & Ice Control ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1230 Supplies, equipment < $5000 500 500 Filters - - Broom for Bobcat - - Skidsteer snow bucket 5,000 5,000 Skidsteer broom - - Snow blower for skid steer - - V plow skid steer 400 400 Chloride Tank 3,000 3,000 Cutting edges, plow shoes 9,597 18,325 (775) 8,900 8,900 1600 Supplies, operating 1,000 1,000 Welding supplies, steel stock, sod for boulevards, etc. 2,250 2,250 Liquid Mg Chloride: 1,500 gallons @ $1.50 per gallon. 28,125 28,125 Salt: 375 tons @ $75 per ton. 30,830 22,000 27,305 31,375 31,375 1700 Motor fuels & lubricants 180 180 Engine oil: 30 gallons @ $6.00 per gallon. - - Propane: 1100 gallons @ $1.00. 4,000 5,000 Diesel fuel: 1,250 gallons @ $4.00 per gallon. 3,295 2,737 4,447 4,180 5,180 2400 Uniforms & clothing 350 350 Uniforms (8.2% of $4,500) 200 200 Clothes & boots allowance (.9@$175) 540 520 524 550 550 2410 Mats & towels 316 317 243 328 328 Cost share of mats & towels (8.2% of $4,000) 3030 Other professional services 1,464 1,551 1,620 1,450 1,650 Weather service reports 3100 Telephone 579 579 Cellphone (6.3% of $7,500)($9,200) 2,500 2,500 GPS data cards (Precise) 882 1,075 2,649 3,079 3,079 3610 Memberships - - - - - Minnesota Safety Council 3630 Training 85 85 Hearing tests/RTN training (1.1@$XX) MSSA meetings 200 200 Defensive Driving class (2 staff) 85 - 250 285 285 4010 Rental, equipment - - - - - Blade 5130 Repairs, equipment 1,262 1,306 - 6,000 6,000 Plow, blower, salt spreader repairs, paint plow assemblies 7030 Capital, equipment > $5000 - - - - - Plow control update (#445) 7040 Vehicles - - - - - Dump truck with plow (possible $10,000 trade-in) 48,271 47,830 36,262 56,147 57,347 -0.91% -24.19% 54.84% 2.14% 39 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4475-0100 Regular Salaries 20,765.62 18,264.13 22,224.17 22,814 23,420 606 2.7% 100-4475-0110 Overtime Salaries 1,003.27 539.86 1,046.67 1,007 1,010 3 0.3% 100-4475-0150 Part Time Salaries - - - 3,535 3,930 395 11.2% 100-4475-0300 Social Security 1,553.79 1,372.66 1,709.30 2,091 2,170 79 3.8% 100-4475-0321 PERA Employer 1,554.98 1,376.64 1,701.37 1,787 1,830 43 2.4% 100-4475-0400 Health Employer 2,272.12 2,347.29 2,472.33 3,735 4,510 775 20.7% 100-4475-0410 Life Employer 351.41 218.44 216.06 - - - 0.0% 100-4475-0420 Dental Employer 115.85 80.73 135.76 - - - 0.0% 100-4475-0500 Workers Comp Ins Premiums 1,538.52 1,356.63 1,514.04 1,871 2,100 229 12.2% Personnel Expenses 29,155.56 25,556.38 31,019.70 36,840 38,970 2,130 5.8% 100-4475-1600 Operating Supplies 4,059.37 3,150.56 22,449.13 22,750 22,750 - 0.0% 100-4475-2400 Uniforms & Clothing 254.71 290.30 113.32 435 435 - 0.0% 100-4475-2410 Maintenance;Mats,Towels,M 63.27 64.15 55.01 160 160 - 0.0% Supplies and Materials 4,377.35 3,505.01 22,617.46 23,345 23,345 - 0.0% 100-4475-3030 Other Professional Services 6,050.17 6,115.34 7,341.60 8,500 8,500 - 0.0% 100-4475-3100 Telephone - - - 230 230 - 0.0% 100-4475-3250 Electricty-Traffic Lights 3,073.15 3,337.38 3,843.83 3,000 3,000 - 0.0% 100-4475-3630 Training & Conferences 20.00 - - 20 20 - 0.0% 100-4475-5130 Repairs, Equipment - 86.84 273.75 500 500 - 0.0% Other Services and Charges 9,143.32 9,539.56 11,459.18 12,250 12,250 - 0.0% 4475 Sign Maintenance 42,676.23 38,600.95 65,096.34 72,435 74,565 2,130 2.9% 40 Fund: 100 Department: 4475 Street Sign Maintenance ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1220 Supplies, vehicles - - - - - Tune ups, air, filters 1600 Supplies, operating 15,000 15,000 Signs, posts, sign hardware, and supplies, mail boxes & posts 5,000 5,000 Street name sign panels, posts, hardware 1,750 1,750 Pavement marking paint (moved from 4470) 500 500 Shop supplies - fastners, degreasers, etc 500 500 Graffitti remover - - (3) Traffic counters - - City signage in County right of way - - City entrance signs (8) - - Portable stop signs (4) 4,059 3,151 22,449 22,750 22,750 1700 Motor fuels & lubs - - - - - Unleaded gas: 500 gallons @ $1.70 2400 Uniforms & clothing 81 81 Uniforms (1.8% of $4,500) 354 354 Clothes and boot allowance (.2@$175) 255 290 113 435 435 2410 Mats & towels 63 64 55 160 160 Cost share of mats & towels (4% of $4,000) 3030 Other professional services 8,000 8,000 Contract pavement marking (Ramsey Co)(moved from 4470) 500 500 Asset management software annual maintenance 6,050 6,115 7,342 8,500 8,500 3100 Telephone - - - 230 230 Cellphone (2.5% of $8,000)($9,200) 3250 Electricity - traffic signals 3,073 3,337 3,844 3,000 3,000 Electricity for traffic signals 3630 Training & conferences 20 - - 20 20 Hearing test/RTN trainging (.4@$50) 5130 Repairs, equipment - 87 274 500 500 Traffic signal repairs & maintenance 7030 Capital, equipment - - - - - 13,521 13,045 34,077 35,595 35,595 -3.52% 161.23% 4.46% 0.00% 41 General Fund Expenditure Detail Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 100-4653-3045 Contractual N. Metro Conf Bure 29,313.54 47,864.52 57,282.31 50,350 56,050 5,700 11.3% Other Services and Charges 29,313.54 47,864.52 57,282.31 50,350 56,050 5,700 11.3% 4653 Convention/Visitor Bureau 29,313.54 47,864.52 57,282.31 50,350 56,050 5,700 11.3% 100-4700-0300 Social Security 74.38 25.47 57.70 - - - 0.0% 100-4700-0321 PERA Employer 395.37 385.45 724.51 - - - 0.0% 100-4700-0400 Health Employer 360.24 210.72 334.03 - - - 0.0% 100-4700-0410 Life Employer 3.14 1.97 2.87 - - - 0.0% 100-4700-0420 Dental Employer 20.06 4.59 9.18 - - - 0.0% 100-4700-0750 FITNESS PROGRAMS 2,723.70 2,268.57 4,382.21 6,500 6,500 - 0.0% Personnel Expenses 3,576.89 2,896.77 5,510.50 6,500 6,500 - 0.0% 100-4700-3065 Contractual Youth Services 22,054.00 51,935.72 53,205.68 57,729 96,059 38,330 66.4% 100-4700-3900 Grants To Other Organizations 35,000.00 - 6,000.00 - - - 0.0% Other Services and Charges 57,054.00 51,935.72 59,205.68 57,729 96,059 38,330 66.4% 100-4700-9100 Contingency - - - 35,000 20,000 (15,000) -42.9% 100-4700-9900 Transfer Out 1,374,000.00 1,525,000.00 775,000.00 2,275,000 1,569,081 (705,919) -31.0% Transfers 1,374,000.00 1,525,000.00 775,000.00 2,310,000 1,589,081 (720,919) -31.2% 4700 Miscellaneous 1,434,630.89 1,579,832.49 839,716.18 2,374,229 1,691,640 (682,589) -28.7% 100-4750-8011 Lease Payable 157,885.28 - - - - - 0.0% 100-4750-8021 Lease, Interest 8,582.60 - - - - - 0.0% Other Services and Charges 166,467.88 - - - - - 0.0% 4750 Debt Service 166,467.88 - - - - - 0.0% 42 Fund: 100 Department: 4653 Convention & Visitor's Bureau ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 3045 N Metro Convention Bureau 29,314 47,865 57,282 50,350 56,050 Payment of 95% of hotel/motel tax collections to (3% tax on gross receipts) support promotion of tourism (City retains 5% for administration) Fund: 100 Department: 4700 Miscellaneous ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 0750 Fitness program 2,724 2,269 4,382 6,500 6,500 Fitness program (maximum $75/month paid with employee sick leave time) 3065 Family & youth social services 30,604 31,250 Northeast Youth and Family Services (NYFS)(4.9% for 2024) 27,125 29,309 NYFS Mental health case management (assist police) - 25,500 Tubman Support Services (assist police, city prosecuter) - 10,000 Community Partners for Youth (CPY) 22,054 51,936 53,206 57,729 96,059 3900 Grants to other Organiztions 35,000 - 6,000 - - 9100 Contingency - - - 35,000 20,000 Unexpected expenditures, deductibles, grant matches 9900 Transfers - miscellaneous 50,000 50,000 Transfer to Economic Development Authority (EDA) SR fund 350,000 450,000 Transfer to Community Center SR fund (for P&R operating costs) 300,000 419,081 Transfer to Vehicle & Equipment CP fund 75,000 300,000 Transfer to Special Projects CP fund 1,500,000 350,000 Transfer to Street Improvement CP fund (from assigned FB) Total Transfers 1,374,000 1,525,000 775,000 2,275,000 1,569,081 1,433,778 1,579,204 838,588 2,374,229 1,691,640 43 210 225 230 252 255 290 441 442 450 Cable TV Forfeiture EDA Community Center Lakeside Park Recycling TIF #6 TIF #7 TIF #5 Total REVENUES Property Taxes -$ -$ 100,000$ -$ -$ -$ -$ -$ -$ 100,000$ Tax Increments - - - - - - 58,280 - 1,728,059 1,786,339 Other Taxes 106,000 - - - - - - - - 106,000 Intergovernmental - - - - 25,000 32,631 - - - 57,631 Charges for Services - - - 517,800 - - - - - 517,800 Fines & Forfeits - 2,000 - - - - - - - 2,000 Investment Earnings - - - 300 25 - 500 - 1,500 2,325 Miscellaneous - - - - 500 - - - - 500 Transfers In - - 142,230 450,000 - - - - - 592,230 TOTAL REVENUES 106,000$ 2,000$ 242,230$ 968,100$ 25,525$ 32,631$ 58,780$ -$ 1,729,559$ 3,164,825$ EXPENDITURES Personnel Expenses 40,820$ -$ 181,850$ 673,810$ 5,765$ 19,120$ -$ -$ -$ 921,365$ Supplies and Materials 2,700 10,200 350 37,100 2,500 750 - - - 53,600 Other Services and Charges 61,484 500 67,024 264,259 17,260 13,114 1,612 553 5,408 431,214 Debt Service - - - - - - 63,997 - 1,716,005 1,780,002 Transfers - - - - - - 5,828 - 86,402 92,230 TOTAL EXPENDITURES 105,004$ 10,700$ 249,224$ 975,169$ 25,525$ 32,984$ 71,437$ 553$ 1,807,815$ 3,278,411$ NET CHANGES IN FUND BALANCE 996$ (8,700)$ (6,994)$ (7,069)$ -$ (353)$ (12,657)$ (553)$ (78,256)$ (113,586)$ 44 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Franchise Tax 116,730 122,006 109,091 112,000 106,000 Miscellaneous - 3,500 - - - Total revenues 116,730 125,506 109,091 112,000 106,000 Expenditures: Personnel services 50,775 53,254 33,806 48,557 40,820 Materials & supplies - 97 825 2,700 2,700 Other services & charges 56,597 55,349 46,302 59,052 61,484 Total expenditures 107,372 108,700 80,933 110,309 105,004 Net increase (decrease) in fund balance 9,358 16,805 28,158 1,691 996 Fund balance - January 1 150,341 159,699 176,504 204,662 206,353 Fund balance - December 31 159,699 176,504 204,662 206,353 207,349 CITY OF MOUNDS VIEW Cable Fund (210) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 45 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 210-4350-0100 Regular Salaries 37,650.07 39,798.69 25,310.78 27,406 22,890 (4,516) -16.5% 210-4350-0150 Part Time Salaries - - - 11,248 9,850 (1,398) -12.4% 210-4350-0300 Social Security 2,532.32 2,695.42 1,757.94 2,956 2,500 (456) -15.4% 210-4350-0321 PERA Employer 2,853.30 2,939.10 1,881.19 2,900 2,460 (440) -15.2% 210-4350-0400 Health Employer 7,476.96 7,574.52 4,575.99 3,762 2,860 (902) -24.0% 210-4350-0410 Life Employer 7.68 7.68 3.56 - - - 0.0% 210-4350-0500 Workers Comp Ins Premiums 254.64 238.48 276.48 285 260 (25) -8.8% Personnel Expenses 50,774.97 53,253.89 33,805.94 48,557 40,820 (7,737) -15.9% 210-4350-1230 Supplies - Equipment - 75.15 825.00 2,000 2,000 - 0.0% 210-4350-1600 Operating Supplies - 21.98 - 700 700 - 0.0% Supplies and Materials - 97.13 825.00 2,700 2,700 - 0.0% 210-4350-3030 Other Professional Services 27,102.44 25,776.12 24,427.57 26,500 28,000 1,500 5.7% 210-4350-3900 Grants to Other Organizations 29,494.30 29,573.27 21,874.79 31,052 31,984 932 3.0% 210-4350-5130 Grants to Other Organizations - - - 1,500 1,500 - 0.0% Other Services and Charges 56,596.74 55,349.39 46,302.36 59,052 61,484 2,432 4.1% 210 Cable TV Fund 107,371.71 108,700.41 80,933.30 110,309 105,004 (5,305) -4.8% 46 Fund: 210 Cable TV Fund: 210 Department: 4350 Operations ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1230 Supplies, equipment < $5000 - 75 825 2,000 2,000 Equipment costing less than $5,000 per item 1600 Supplies, operating 200 200 Recording media - tapes, DVD's 500 500 Batteries, cables, bulbs, tapes, misc - 22 - 700 700 3030 Other professional services 6,500 7,000 Web streaming meetings $501 per month. (current $1502/qtr) 20,000 21,000 Broadcast and Video Production support 27,102 25,776 24,428 26,500 28,000 3630 Training & conferences - - Attendance at local training - - - - - ACM National Conference (free registration)(1/2 paid by Little Canada) - - - - - Submission fees for awards (new item for 2010) 3800 Mileage & parking - - - - - Mileage 3900 Grants & subsidies 29,494 29,573 21,875 31,052 31,984 Share of costs of North Suburban Cable Commission 5130 Repairs, equipment - - - 1,500 1,500 Repair and maintenance of equipment 7030 Capital, equipment > $5000 - - Supplemental duct work/air conditioning - - Video Camera - - Video storage (NAS) - - Control room/Council chambers replacement - - - - - Bulletin Board - - - - - Adobe Creative Suite 3 Production Premium Software - - - - - Non-linear editing system (moved to 2008) - - - - - 56,597 55,447 47,127 61,752 64,184 -2.03% -15.00% 31.03% 3.94% 47 THIS PAGE LEFT BLANK INTENTIONALLY 48 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Forfeitures 22,816 11,664 53,832 2,000 2,000 Total revenues 22,816 11,664 53,832 2,000 2,000 Expenditures: Materials & supplies 20,861 4,620 11,910 10,200 10,200 Other services & charges 5,391 4,198 16,644 500 500 Total expenditures 26,252 8,818 28,554 10,700 10,700 Net increase (decrease) in fund balance (3,436) 2,846 25,278 (8,700) (8,700) Fund balance - January 1 12,688 9,252 12,098 37,376 28,676 Fund balance - December 31 9,252 12,098 37,376 28,676 19,976 CITY OF MOUNDS VIEW Forfeiture Fund (225) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 49 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 225-4200-1230 Supplies - Equipment 13,961.36 4,620.23 11,566.89 10,000 10,000 - 0.0% 225-4200-1600 Operating Supplies 6,899.85 - 343.50 200 200 - 0.0% Supplies and Materials 20,861.21 4,620.23 11,910.39 10,200 10,200 - 0.0% 225-4200-3030 Other Professional Services 5,390.65 4,197.81 16,643.75 500 500 - 0.0% Other Services and Charges 5,390.65 4,197.81 16,643.75 500 500 - 0.0% 225 Forfeiture Fund 26,251.86 8,818.04 28,554.14 10,700 10,700 - 0.0% 50 Fund: 225 Forfeiture Fund: 225 Department: 4200 Operations ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1230 Supplies - equipment < $5000 6,000 6,000 Body/squad cameras 4,000 4,000 Miscellaneous vehicle equipment - - Replacement Glock pistols (2) 13,961 4,620 11,567 10,000 10,000 1600 Supplies - operating 200 200 Supplies to prepare vehicles for auction. (tows, title fees, batteries) - - Taser - - Body camera system - - Radar 6,900 - 344 200 200 3030 Other professional services 5,391 4,198 16,644 500 500 Share of auction costs. 7030 Equipment > $5000 - - Camera - - Department issued handguns and holsters - - Stationary radar sign for County Rd I (Pinewood school) - - One squad $23,000 + set-up $6000 One in General Fund. - - Speed display unit - - - - - 26,252 8,818 28,554 10,700 10,700 -66.41% 223.82% -62.53% 0.00% 51 THIS PAGE LEFT BLANK INTENTIONALLY 52 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Property Taxes 100,774 99,973 97,532 100,000 100,000 Development Fee - 1,500 - - - Interest on Notes 45 239 367 - - Miscellaneous - - 57,547 - - Total revenues 100,819 101,712 155,447 100,000 100,000 Expenditures: Personnel services 146,001 149,195 155,857 161,766 181,850 Materials & supplies 751 - - 350 350 Other services & charges 34,149 28,073 36,987 60,824 43,024 Loans/Subsidies - 5,000 16,050 30,000 24,000 Total expenditures 180,901 182,268 208,893 252,940 249,224 Excess (deficit) of revenue over expenditures (80,082) (80,556) (53,447) (152,940) (149,224) Other financing sources (uses): Transfers in (out) General Fund 50,000 50,000 50,000 50,000 50,000 TIF #5 88,036 89,690 91,484 94,229 86,402 TIF #6 - 6,989 8,149 8,393 5,828 Street Improvement Fund 701,000 - - - - Net increase (decrease) in fund balance 758,954 66,123 96,186 (318) (6,994) Fund balance - January 1 478,535 1,237,489 1,303,612 1,399,798 1,399,480 Fund balance - December 31 1,237,489 1,303,612 1,399,798 1,399,480 1,392,486 CITY OF MOUNDS VIEW EDA Fund (230) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 53 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 230-4650-0100 Regular Salaries 114,464.47 117,009.75 120,342.61 123,765 140,760 16,995 13.7% 230-4650-0300 Social Security 7,694.34 8,172.75 8,573.83 9,468 10,760 1,292 13.6% 230-4650-0321 PERA Employer 8,560.19 8,535.06 8,846.47 9,283 10,420 1,137 12.2% 230-4650-0400 Health Employer 14,600.69 14,850.92 17,411.04 18,126 18,560 434 2.4% 230-4650-0410 Life Employer 15.34 15.36 15.36 - - - 0.0% 230-4650-0500 Workers Comp Ins Premiums 665.68 611.43 667.20 1,124 1,350 226 20.1% Personnel Expenses 146,000.71 149,195.27 155,856.51 161,766 181,850 20,084 12.4% 230-4650-1600 Operating Supplies 751.44 - - 200 200 - 0.0% 230-4650-2100 Books & Periodicals - - - 150 150 - 0.0% Supplies and Materials 751.44 - - 350 350 - 0.0% 230-4650-3030 Other Professional Services 30,563.02 22,709.10 27,089.64 32,508 30,844 (1,664) -5.1% 230-4650-3100 Telephone 600.00 600.00 550.00 600 600 - 0.0% 230-4650-3420 Advertising - - - 1,500 1,500 - 0.0% 230-4650-3430 Printing - - - 500 500 - 0.0% 230-4650-3610 Memberships 110.00 295.00 595.00 950 950 - 0.0% 230-4650-3630 Training & Conferences 350.50 525.00 790.00 3,490 3,490 - 0.0% 230-4650-3800 Mileage & Parking 246.89 969.70 1,936.95 350 350 - 0.0% 230-4650-4800 Insurance & Bonds 754.39 519.21 513.30 649 649 - 0.0% 230-4650-5210 Housing Programs 1,523.71 2,455.11 5,512.00 20,277 4,141 (16,136) -79.6% 230-4650-9300 Business Loans/Subsidies - 5,000.00 16,050.00 30,000 24,000 (6,000) -20.0% Other Services and Charges 34,148.51 33,073.12 53,036.89 90,824 67,024 (23,800) -26.2% 230 EDA General Activities Fund 180,900.66 182,268.39 208,893.40 252,940 249,224 (3,716) -1.5% 54 Fund: 230 EDA Fund: 230 Department: 4650 Housing and Economic Development ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1600 Supplies, operating 751 - - 200 200 Misc office supplies 2100 Books & periodicals - - - 150 150 Misc. reports & periodicals (Finance & Commerce) 3030 Other professional services 4,000 4,000 Legal fees for development reviews 5,000 5,000 Financial consultant fees (Ehlers) 14,500 12,000 Special project consultant fees - - City branding - Marketing Group Services - - Appraisal and environmental fees 1,808 1,844 5% of audit (23-36,145, 24-36,870, 25-37,605, 26-38,360) 4,500 5,500 Loan Program and Energy Audit Consultant (CEE) 2,700 2,500 Marketing Consultant fees 30,563 22,709 27,090 32,508 30,844 3100 Telephone 600 600 550 600 600 Cell phone 3420 Advertising - - - 1,500 1,500 Targeted advertisements. 3430 Printing 400 400 Property ad printing - - Stationary/business cards/signs/site info - - Business directory reprints 100 100 Misc printing - - - 500 500 3610 Memberships 400 400 Economic Development Assoc of MN (EDAM) - - North Metro 35 W Corridor Coalition 250 250 Twin Cities North Chamber of Commerce dues 300 300 Mn Real Estate Exchangers (MREE) - - MN Assoc. of Govt. Communicators (MAGC) - - Urban Land Institute - - North Metro Mayors Assoc (all in General Fund for 2015) 110 295 595 950 950 3630 Training & conferences 535 535 IEDC Conference Minneapolis 275 275 Ehlers Finance Seminar 1,200 1,200 EDAM spring/summer conferences - - Development certification 1,480 1,480 Other miscellaneous training 351 525 790 3,490 3,490 3800 Mileage 247 970 1,937 350 350 Misc. mileage 4800 Insurance 754 519 513 649 649 Allocation of the City's property & liability insurance 5210 Housing programs 1,524 2,455 5,512 20,277 4,141 Housing Improvement programs 5220 Highway 10 redevelopment - - - - - Trailways & lighting in highway corridor, Gateway Signage 7030 Equipment - - - - - New workstation 7050 Capital, real estate - - - - - Property or projects of opportunity or need as they may appear 9300 Business loans/subsidies/grants - 5,000 16,050 30,000 24,000 Business improvement partnership loans/subsidies/grants 34,900 33,073 53,037 91,174 67,374 -5.23% 60.36% 71.91% -26.10% 55 THIS PAGE LEFT BLANK INTENTIONALLY 56 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Recreation Program fees - 44,090 72,127 100,000 125,000 Lease revenue 137,053 146,700 149,300 150,000 160,800 Investment earnings 2,755 (790) (10,139) 300 300 Equipment rental 404 2,626 7,377 4,500 5,000 Banquet room rental 18,173 87,505 109,820 120,000 150,000 Donations - - 500 - - Gym & Meeting room rental 22,704 32,621 36,351 28,000 35,000 Open Gym fees 1,765 19,553 30,742 30,000 40,000 Senior memberships - 1,669 2,370 - 1,000 Vending machines 457 1,416 1,069 500 1,000 Miscellaneous 703 3,860 1,701 - - Total revenues 184,015 339,250 401,217 433,300 518,100 Expenditures: Personnel services 55,874 407,465 493,441 581,885 673,810 Materials & supplies 14,468 27,111 26,780 29,600 37,100 Other services & charges 266,729 208,235 281,883 249,115 264,259 Lease payable 360,996 - - - - Total expenditures 698,067 642,812 802,105 860,600 975,169 Excess (deficit) of revenue over expenditures (514,052) (303,562) (400,888) (427,300) (457,069) Other financing sources (uses): Transfers in (out) General Fund 550,000 350,000 350,000 350,000 450,000 Net increase (decrease) in fund balance 35,948 46,438 (50,888) (77,300) (7,069) Fund balance - January 1 296,388 332,336 378,775 327,887 250,587 Fund balance - December 31 332,336 378,775 327,887 250,587 243,518 CITY OF MOUNDS VIEW Community Center Fund (252) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 57 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 252-4730-0100 Regular Salaries 369.69 49,978.65 56,061.58 66,545 126,010 59,465 89.4% 252-4730-0110 Overtime Salaries - 1,520.30 2,513.26 - - - 0.0% 252-4730-0150 Salaries/Wages, Part-Time Reg - 4,125.00 6,949.20 13,184 14,100 916 6.9% 252-4730-0300 Social Security 27.07 4,211.03 5,144.67 6,099 10,720 4,621 75.8% 252-4730-0321 Pera Employer 47.87 3,704.76 4,896.97 5,979 10,510 4,531 75.8% 252-4730-0400 Health Employer --555.87 9,495 15,820 6,325 66.6% 252-4730-0410 Life Employer -150.68 272.70 - - - 0.0% 252-4730-0420 Dental Employer -929.15 1,147.06 - - - 0.0% 252-4730-0500 Workers Comp Ins Premiums -319.89 378.92 2,421 4,280 1,859 76.8% 252-4730-0999 Allocate; Salaries 10,680.73 8,038.86 7,200.05 23,769 24,330 561 2.4% 252-4732-0100 Regular Salaries 1,684.07 183,556.33 227,163.94 158,746 171,560 12,814 8.1% 252-4732-0110 Overtime Salaries -760.94 5,295.31 - - - 0.0% 252-4732-0150 Salaries/Wages, Part-Time Reg - 64,911.90 71,020.77 120,304 116,120 (4,184) -3.5% 252-4732-0300 Social Security 123.29 18,700.92 22,192.64 21,347 22,010 663 3.1% 252-4732-0321 Pera Employer 218.08 14,307.76 18,541.22 20,928 21,580 652 3.1% 252-4732-0400 Health Employer - 18,053.14 31,171.14 32,085 33,190 1,105 3.4% 252-4732-0410 Life Employer -160.74 152.64 - - - 0.0% 252-4732-0420 Dental Employer -228.45 333.46 - - - 0.0% 252-4732-0500 Workers Comp Ins Premiums - 1,651.46 3,570.00 5,908 6,280 372 6.3% 252-4732-0600 Unemployment --79.85 - - - 0.0% 252-4732-0999 Allocate; Salaries 36,848.47 27,750.34 24,840.15 82,002 83,920 1,918 2.3% 252-4734-0999 Allocate; Salaries 1,602.11 1,189.57 1,080.03 3,565 3,650 85 2.4% 252-4736-0999 Allocate; Salaries 4,272.29 3,215.60 2,879.99 9,508 9,730 222 2.3% Personnel Expenses 55,873.67 407,465.47 493,441.42 581,885 673,810 91,925 15.8% 252-4730-1210 Supplies, Building & Grounds 1.75 --- - - 0.0% 252-4730-1230 Supplies, Equipment 1,508.70 1,620.70 2,317.39 5,000 5,000 - 0.0% 252-4730-2999 Alloc; Materials/Supplies 3,217.57 4,727.34 4,256.10 4,228 4,508 280 6.6% 252-4732-1230 Supplies, Equipment 1,465.84 8,552.01 8,401.01 9,500 16,000 6,500 68.4% 252-4732-1600 Operating Supplies -55.47 861.45 - - - 0.0% 252-4732-2999 Alloc; Materials/Supplies 5,745.90 8,441.80 7,600.40 7,550 8,050 500 6.6% 252-4734-2999 Alloc; Materials/Supplies 344.70 506.55 456.01 453 483 30 6.6% 252-4736-2999 Alloc; Materials/Supplies 2,183.33 3,207.55 2,887.95 2,869 3,059 190 6.6% Supplies and Materials 14,467.79 27,111.42 26,780.31 29,600 37,100 7,500 25.3% 252-4730-3030 Other Professional Services 38,463.68 451.07 2,440.39 5,654 15,672 10,018 177.2% 252-4730-3100 Telephone ---500 500 - 0.0% 252-4730-3420 Advertising 438.39 38.34 429.36 3,000 3,000 - 0.0% 252-4730-3430 Printing -34.50 -250 250 - 0.0% 252-4730-3999 Alloc;Prof Serv/Utilities 22,888.89 27,791.13 35,027.53 24,680 31,248 6,568 26.6% 252-4730-4800 Insurance & Bonds 1,763.27 1,680.03 2,554.49 2,100 2,100 - 0.0% 252-4730-5110 Repairs, Buildings & Grounds 1,628.42 30.43 - 2,700 2,700 - 0.0% 252-4730-5130 Repairs, Equipment 1,247.93 600.00 1,888.47 2,600 2,600 - 0.0% 252-4730-5999 Allocate; Syst Maintenance 8,410.51 10,760.91 14,705.00 13,025 13,025 - 0.0% 252-4732-3030 Other Professional Services 101,008.91 9,455.14 42,936.36 46,121 49,095 2,974 6.4% 252-4732-3100 Telephone --- 1,000 1,000 - 0.0% 252-4732-3430 Printing 1,002.72 10,421.38 19,952.31 12,000 12,000 - 0.0% 252-4732-3999 Alloc;Prof Serv/Utilities 46,511.44 56,543.86 71,547.74 46,330 55,800 9,470 20.4% 252-4732-4010 Rental, Equipment - 32,704.00 17,832.00 20,297 250 (20,047) -98.8% 252-4732-4800 Insurance & Bonds 3,379.59 3,220.06 3,183.43 4,025 4,025 - 0.0% 252-4732-5110 Repairs, Buildings & Grounds 164.00 1,588.12 - 5,000 5,000 - 0.0% 252-4732-5130 Repairs, Equipment - 3,340.05 4,224.71 6,350 6,550 200 3.1% 252-4732-5999 Allocate; Syst Maintenance 15,018.81 19,215.96 26,259.04 23,259 23,258 (1) 0.0% 252-4734-3999 Alloc;Prof Serv/Utilities 2,539.69 3,131.05 3,982.60 2,535 3,348 813 32.1% 252-4734-5999 Allocate; Syst Maintenance 901.18 1,152.99 1,575.59 1,396 1,396 - 0.0% 252-4736-3999 Alloc;Prof Serv/Utilities 14,479.12 17,654.22 22,258.53 16,055 21,204 5,149 32.1% 252-4736-4800 Insurance & Bonds 1,175.52 1,120.01 1,107.28 1,400 1,400 - 0.0% 252-4736-5999 Allocate; Syst Maintenance 5,706.94 7,301.90 9,978.19 8,838 8,838 - 0.0% Other Services and Charges 266,729.01 208,235.15 281,883.02 249,115 264,259 15,144 6.1% 252-4350-8011 Lease Payable 342,384.94 --- - - 0.0% 252-4350-8021 Lease, Interest 18,611.25 --- - - 0.0% Debt Service 360,996.19 --- - - 0.0% 252 Community Center 698,066.66 642,812.04 802,104.75 860,600 975,169 114,569 13.3% 58 Fund: 252 Department: 4350 Community Center Building Overhead Expenditures ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1210 Supplies, bldgs & grounds - - - 1,500 1,500 Lights, signs, fertilizer 1230 Supplies, equipment < $5000 - - - 800 800 Small tools & equipment 1600 Supplies, operating - - - 9,300 9,300 Batteries, soap, paper towels, cleaning supplies for bathrooms, paper cups, plates, e 2400 Uniforms - - - 1,000 2,000 Uniforms/Clothing (7.3% of $4,500 + .8 FTE x $175) 2410 Mats & towels 2,250 2,250 Floor mats and cleaning towels to provide better protection of carpets 250 250 Special events - - - 2,500 2,500 3030 Other professional services 600 600 Backflow inspection, alarm inspection, 500 500 Sprinkler inspections - - Custodial services: 12 months $xxx 1,300 1,300 Commercial carpet cleaning service (twice annually) - - - 2,400 2,400 3100 Telephone & internet - - - 5,100 5,100 Phones, internet, maintenance agreements, & repairs Metro I-Net 3200 Water & Wastewater - - - 8,600 8,600 Water & sewer charges for community center 3210 Electricity - - - 49,000 63,000 Estimated electrice charges 3220 Natural gas - - - 17,500 25,000 Estimated natural gas charges 3420 Advertising - - - 3530 Refuse collection 4,600 4,600 Dumpsters $360 x 12 months 400 400 Extra garbage pick-up charges - - Ramsey County recyclying fee - - - 5,000 5,000 3630 Training 1,000 1,000 Misc training 1,000 1,500 Annual Conference - - - 2,000 2,500 4010 Rental, equipment - - - - - Phone/pager 4800 Bonding & insurance - - - 8,200 8,200 Insurance & bonding cost. 5110 Repairs, building & grounds 1,200 1,200 Repair floor tiles 4,500 4,500 Exterior/Interior building maintenance - - Relocate entrance sign 770 770 Exterminator: 12 months X 64.02 1,500 1,500 Fire alarm system service 1,300 1,300 Parking lot & grounds maintenance 500 500 Security system service - - - 9,770 9,770 5130 Repairs, equipment 11,991 11,991 HVAC system maintenance contract 8,556 8,556 Genesis Air bulbs (HVAC) 6,000 6,000 HVAC repairs - - Sprinkler inspections (moved to 3030) 2,000 2,000 Plumbing, electrical, & misc. interior maintenance - - - 28,547 28,547 7030 Capital, equipment > $5000 - - HVAC Improvements - - Community Center Roof repairs - - Roof over kitchen area (will be done as part of full reroof above in 2012) - - - - - 8011 Lease payable (ESP)342,385 - - - - Lease payable for energy savings program (matures 2-23-27) 8021 Interest 18,611 - - - - 360,996 - - 151,217 174,217 -100.00% #DIV/0! #DIV/0! 15.21% 59 Fund: 252 Community Center - 4730 Banquet Center Expenditures ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1140 Supplies, office - - - 0 0 Miscellaneous 1210 Supplies, building 2 - - 0 0 Light bulbs 1230 Supplies, equipment 3,000 3,000 Tables, mirrors, microphones, projectors, etc. for Banquet Room 2,000 2,000 Override upgrade to Audio/Visual system - - Ice machine 1,509 1,621 2,317 5,000 5,000 1600 Supplies, operating - - - 0 0 Cleaning products 2999 Allocation of supplies 3,218 4,727 4,256 4,228 4,508 28% Allocation from overall building support 3030 Other professional services 904 922 2.5% of audit (23-36,145, 24-36,870, 25-37,605, 26-38,360) 2,500 2,500 Miscellaneous professional services (linen service) - - Banquet facility management (16% of 311,512) 1,750 1,750 Carpet cleaning 2 x year - 10,000 Extra staff for large events (temp agency fees for janitors) 500 500 Legal costs 38,464 451 2,440 5,654 15,672 3037 Contr. Banquet Center - - - Security for events 3100 Telephone/Internet - - - 500 500 Cell phone 3200 Water & Wastewater - - - - - Water & sewer charges 13% of Comm Ctr total 3210 Electricity - - - - - Estimated electrice charges; 13% of Comm Ctr total 3220 Natural gas - - - - - Estimated natural gas charges; 13% of Comm Ctr total 3300 Postage - - - - - Mailing of brochures, flyers, etc. 3420 Advertising & marketing 438 38 429 3,000 3,000 Website and traditional advertising, marketing 3430 Printing - 35 - 250 250 Brochures, flyers, etc. 3999 Allocation of utilities 22,889 27,791 35,028 24,680 31,248 28% Allocation from overall building utilities 3610 Memberships - - - - - Banquet Facility Association 4010 Rental, equipment - - - - - Equipment rented for the benefit of customers and charged to them. 4800 Bonding & insurance 1,763 1,680 2,554 2,100 2,100 Insurance & bonding cost 5110 Repairs, building & grounds 1,200 1,200 Interior building repairs specific to the banquette center/center divider repairs 1,500 1,500 Dance floor maintenance 1,628 30 - 2,700 2,700 5130 Repairs, equipment 1,248 600 1,888 2,600 2,600 Repairs to kitchen, audio system, and other banquette equipment 5999 Allocation of repairs 8,411 10,761 14,705 13,025 13,025 28% Allocation from overall building repairs 7030 Capital, equipment > $5000 - - - - - Tables or other banquet equipment replacement (moved to 1230) 79,569 47,734 63,619 63,737 80,603 -40.01% 33.28% 0.19% 26.46% 60 Fund: 252 Community Center - 4732 Recreation Expenditures ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1140 Supplies, office - - - 0 0 Miscellaneous 1230 Supplies, equipment 1,000 1,000 Miscellaneous (copy paper) 2,500 2,500 Explore More supplies 1,000 7,500 Fitness equipment 2,500 2,500 Youth sports 1,500 1,500 Senior programs 1,000 1,000 Teen/Enrichment 1,466 8,552 8,401 9,500 16,000 1600 Supplies, operating - 55 861 - - Soap, paper towels, cleaning supplies for bathrooms 2400 Uniforms - - - - - Uniforms, mats, mops, towels 2999 Allocation of supplies 5,746 8,442 7,600 7,550 8,050 50% Allocation from overall building support 3030 Other professional services 30,000 30,000 Partner payments - Happy Feet Dance, Pure Intennsity Athletics, Hall of Fame, Elementary track use, Explore More field trips & transportation, and Senior trips & transportation 9,933 10,430 Rec Software (2nd yr $9,933) 5% inflator after yr 2 (2024) - - Senior Program Coordinator - - Copier ($2,100) Computer ($835) per agreement 1,000 1,000 Incode E-time sheet module 2,477 4,954 HR recruit/hiring software NEOGOV (1/2 in GF Cent Serv, 2nd yr $9,908/2) 2,711 2,711 7.5% of audit (23-36,145, 24-36,870, 25-37,605, 26-38,360) 101,009 9,455 42,936 46,121 49,095 3100 Telephone - - - 1,000 1,000 Cell phones (2) 3200 Water & Wastewater - - - - - Water & sewer charges 57% of Comm Ctr total 3210 Electricity - - - - - Estimated electrice charges; 57% of Comm Ctr total 3220 Natural gas - - - - - Estimated natural gas charges; 57% of Comm Ctr total 3300 Postage - - - - - 50% of the cost of mailing the Mounds View Matters newsletter 3430 Printing 1,003 10,421 19,952 12,000 12,000 50% of the cost of printing and mailing the Mounds View Matters newsletter 3530 Refuse collection - - - - - 3999 Allocation of utilities 46,511 56,544 71,548 46,330 55,800 50% Allocation from overall building utilities 4010 Rental, equipment 250 250 Scissor lift rental 20,047 - Fitness equipment - 32,704 17,832 20,297 250 4800 Bonding & insurance 3,380 3,220 3,183 4,025 4,025 Insurance & bonding cost. 5110 Repairs, building & grounds 1,500 1,500 General building repairs 1,000 1,000 Interior improvements 2,500 2,500 Gym floor resurfacing & maintenance 164 1,588 - 5,000 5,000 5130 Repairs, equipment 500 500 Registration system support 4,000 4,200 IT support Metro I-Net 1,000 1,000 Copier annual maintenance 850 850 Repairs to other equipment - 3,340 4,225 6,350 6,550 5999 Allocation of repairs 15,019 19,216 26,259 23,259 23,258 50% Allocation from overall building repairs 7030 Capital, equipment - - - - - Basket Ball Hoops 174,297 153,538 202,798 181,432 181,028 -11.91% 32.08% -10.54% -0.22% 2999 Allocation of supplies 345 507 456 453 483 3% Allocation from overall building support 3999 Allocation of utilities 2,540 3,131 3,983 2535 3348 3% Allocation from overall building support 5999 Allocation of repairs 901 1,153 1,576 1396 1396 3% Allocation from overall building support 2999 Allocation of supplies 2,183 3,208 2,888 2869 3059 19% Allocation from overall building support 3999 Allocation of utilities 14,479 17,654 22,259 16055 21204 19% Allocation from overall building support 4800 Insurance & bonds 1,176 1,120 1,107 1400 1400 5999 Allocation of repairs 5,707 7,302 9,978 8838 8838 19% Allocation from overall building support Total Community Center 642,193 235,347 308,663 278,715 301,359 61 THIS PAGE LEFT BLANK INTENTIONALLY 62 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Other Local Govt grants 23,000 23,000 23,000 25,000 25,000 Investment earnings 352 (99) (1,294) 25 25 Park site permits 255 1,489 122 500 500 Total revenues 23,607 24,390 21,828 25,525 25,525 Expenditures: Personnel services - 4,215 3,962 5,765 5,765 Materials & supplies 1,361 - 1,182 2,500 2,500 Other services & charges 16,612 19,916 13,965 17,260 17,260 Total expenditures 17,973 24,131 19,109 25,525 25,525 Net increase (decrease) in fund balance 5,634 259 2,720 - - Fund balance - January 1 11,795 17,430 17,688 20,408 20,408 Fund balance - December 31 17,430 17,688 20,408 20,408 20,408 CITY OF MOUNDS VIEW Lakeside Park Fund (255) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 63 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 255-4350-0150 Part Time Salaries - 3,680.00 3,680.00 5,120 5,120 - 0.0% 255-4350-0300 Social Security - 282.00 282.00 392 392 - 0.0% 255-4350-0500 Workers Comp - 253.00 - 253 253 - 0.0% Personnel Expenses - 4,215.00 3,962.00 5,765 5,765 - 0.0% 255-4350-1210 Supplies - Bldgs & Grounds 61.21 - 64.50 800 800 - 0.0% 255-4350-1600 Operating Supplies 1,299.80 - 1,117.40 1,700 1,700 - 0.0% Supplies and Materials 1,361.01 - 1,181.90 2,500 2,500 - 0.0% 255-4350-3200 Water & Sewer 4,126.17 5,292.33 3,401.61 2,400 2,400 - 0.0% 255-4350-3210 Electricity 1,379.33 1,588.08 1,796.60 1,300 1,300 - 0.0% 255-4350-3530 Refuse Collection - - - 75 75 - 0.0% 255-4350-4010 Rental - Equipment 5,276.00 5,276.00 5,276.00 5,276 5,276 - 0.0% 255-4350-4030 Portable Toilets 326.75 532.25 499.43 550 550 - 0.0% 255-4350-4800 Insurance & Bonds 5,504.00 5,685.00 2,199.00 6,055 6,055 - 0.0% 255-4350-5130 Repairs - Equipment - 1,542.80 792.28 1,604 1,604 - 0.0% Other Services and Charges 16,612.25 19,916.46 13,964.92 17,260 17,260 - 0.0% 255 Lakeside Park 17,973.26 24,131.46 19,108.82 25,525 25,525 - 0.0% 64 Fund: 255 Lakeside Park Fund: 255 Department: 4350 Expenditures ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1210 Supplies, bldgs & grounds 61 - 65 800 800 Paper, sand, etc. 1600 Supplies, operating 1,300 - 1,117 1,700 1,700 Fertilizer & pesticides 3200 Water & sewer 4,126 5,292 3,402 2,400 2,400 Estimated water & sewer charges 3210 Electricity 1,379 1,588 1,797 1,300 1,300 Estimated electric charges 3530 Refuse collection - - - 75 75 Six months service 4010 Equipment, capital charge 5,276 5,276 5,276 5,276 5,276 Capital charge for usage of SLP city equipment 4030 Satellites 327 532 499 550 550 Five months service 4800 Insurance & bonds 5,504 5,685 2,199 6,055 6,055 Property & liability insurnace 5130 Repairs, equipment - 1,543 792 1,604 1,604 Repair of equipment at the park 7030 Capital, equipment - - - - - 17,973 19,916 15,147 19,760 19,760 10.81% -23.95% 30.46% 0.00% 65 THIS PAGE LEFT BLANK INTENTIONALLY 66 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 County grants 24,110 29,540 31,518 32,631 32,631 Total revenues 24,110 29,540 31,518 32,631 32,631 Expenditures: Personnel services 14,918 16,495 9,525 18,100 19,120 Materials & supplies - 1,857 6,412 750 750 Other services & charges 7,517 10,204 11,087 13,784 13,114 Total expenditures 22,434 28,556 27,023 32,634 32,984 Net increase (decrease) in fund balance 1,676 984 4,495 (3) (353) Fund balance - January 1 28,933 30,609 31,594 36,089 36,086 Fund balance - December 31 30,609 31,594 36,089 36,086 35,733 CITY OF MOUNDS VIEW Recycling Fund (290) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 67 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 290-4420-0100 Regular Salaries 10,539.38 11,347.47 6,961.64 - 1,590 1,590 0.0% 290-4420-0110 Overtime Salaries - 483.64 - - - - 0.0% 290-4420-0150 Part Time Salaries - - - 15,471 14,770 (701) -4.5% 290-4420-0300 Social Security 735.26 837.99 488.79 1,184 1,250 66 5.6% 290-4420-0321 PERA Employer 801.27 876.81 516.78 1,160 1,230 70 6.0% 290-4420-0400 Health Employer 2,769.14 2,874.65 1,478.52 171 150 (21) -12.3% 290-4420-0410 Life Employer 2.88 3.34 1.13 - - - 0.0% 290-4420-0420 Dental Employer - 3.17 - - - - 0.0% 290-4420-0500 Workers Comp Ins Premiums 69.60 67.60 78.00 114 130 16 14.0% Personnel Expenses 14,917.53 16,494.67 9,524.86 18,100 19,120 1,020 5.6% 290-4420-1600 Operating Supplies - 1,856.94 6,412.01 750 750 - 0.0% Supplies and Materials - 1,856.94 6,412.01 750 750 - 0.0% 290-4420-3300 Postage - 1,016.50 1,301.00 2,000 2,000 - 0.0% 290-4420-3430 Printing 1,821.64 1,010.75 1,521.99 2,000 2,000 - 0.0% 290-4420-3530 Refuse Collection 5,694.88 8,176.81 8,263.53 9,784 9,114 (670) -6.8% Other Services and Charges 7,516.52 10,204.06 11,086.52 13,784 13,114 (670) -4.9% 290 Recycling 22,434.05 28,555.67 27,023.39 32,634 32,984 350 1.1% 68 Fund: 290 Recycling Grant Fund: 290 Department: 4420 Expenditures ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1600 Supplies, operatin - 1,857 6,412 750 750 3030 Other professional services - - - - - 3300 Postage - 1,017 1,301 2,000 2,000 City wide mailing for Cleanup Day, Newsletter, organics 3420 Advertisements - - - - - Promotional items 3430 Printing 300 300 Articles in City newsletter 1,700 1,700 Clean-up Day and Organics printing of direct mailing items 1,822 1,011 1,522 2,000 2,000 3530 Refuse collection 5,695 8,177 8,264 9,784 9,114 Recycling coll CH, CC, and Parks, Clean-up Days, shredding, xmas trees 3960 Awards - - - - - Savings bond awards for recycling contest - 2/mth @ $50/bond. 8021 Interest on internal loan - - - - - Interest on money borrowed until Ramsey Cty grant arrives 7,517 12,061 17,499 14,534 13,864 60.46% 45.08% 20.50% -20.77% 69 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Tax increments 10,828 79,937 85,558 83,935 58,280 Investment earnings 10 5 (294) 500 500 Total revenues 10,838 79,942 85,264 84,435 58,780 Expenditures: Other services & charges 1,316 2,282 2,337 1,602 1,612 Developer payments 4,873 40,844 74,473 74,440 63,997 Total expenditures 6,189 43,126 76,810 76,042 65,609 Excess (deficit) of revenue over expenditures 4,649 36,815 8,455 8,393 (6,829) Other financing sources (uses): Transfers in (out) General Fund - (6,989) (8,149) (8,393) (5,828) Net increase (decrease) in fund balance 4,649 29,826 306 - (12,657) Fund balance - January 1 - 4,649 34,475 34,781 34,781 Fund balance - December 31 4,649 34,475 34,781 34,781 22,124 CITY OF MOUNDS VIEW TIF #6 (441) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 70 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Tax increments 1,760,668 1,794,771 1,798,711 1,884,584 1,728,059 Investment earnings 5,126 (1,653) (15,069) 1,500 1,500 Total revenues 1,765,794 1,793,118 1,783,642 1,886,084 1,729,559 Expenditures: Other services & charges 4,656 3,523 3,585 5,408 5,408 Developer payments 1,647,332 1,688,834 1,706,904 1,764,282 1,716,005 Total expenditures 1,651,988 1,692,356 1,710,489 1,769,690 1,721,413 Excess (deficit) of revenue over expenditures 113,806 100,761 73,153 116,394 8,146 Other financing sources (uses): Transfers in (out) EDA (88,036) (89,690) (91,484) (94,229) (86,402) Net increase (decrease) in fund balance 25,770 11,071 (18,331) 22,165 (78,256) Fund balance - January 1 869,475 895,245 906,316 887,985 910,150 Fund balance - December 31 895,245 906,316 887,985 910,150 831,894 CITY OF MOUNDS VIEW TIF #5 (450) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 71 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 441-4650-3030 Other Professional Services 1,316.41 2,282.10 2,336.74 1,602 1,612 10 0.6% 441-4650-8010 Debt - Principal - 7,633.39 67,961.41 74,440 63,997 (10,443) -14.0% 441-4650-8020 Debt - Interest 4,872.59 33,210.91 6,511.42 - - - 0.0% 441-4650-9900 Transfers Out - 6,989.00 8,149.00 8,393 5,828 (2,565) -30.6% Other Services and Charges 6,189.00 50,115.40 84,958.57 84,435 71,437 (12,998) -15.4% 441 TIF 6 6,189.00 50,115.40 84,958.57 84,435 71,437 (12,998) -15.4% 442-4650-3030 Other Professional Services - - - - 553 553 0.0% Other Services and Charges - - - - 553 553 0.0% 442 TIF 7 - - - - 553 553 0.0% 450-4650-3030 Other Professional Services 4,655.72 3,522.53 3,584.72 5,408 5,408 - 0.0% 450-4650-8010 Debt - Principal 626,472.73 700,321.71 754,250.70 - - - 0.0% 450-4650-8020 Debt - Interest 1,020,859.63 988,511.88 952,653.13 1,764,282 1,716,005 (48,277) -2.7% 450-4650-9900 Transfers Out 88,036.00 89,690.00 91,484.00 94,229 86,402 (7,827) -8.3% Other Services and Charges 1,740,024.08 1,782,046.12 1,801,972.55 1,863,919 1,807,815 (56,104) -3.0% 450 TIF 5 1,740,024.08 1,782,046.12 1,801,972.55 1,863,919 1,807,815 (56,104) -3.0% 72 Fund: 441 TIF District #6 Fund: 441 Department: 4650 Economic Development ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1600 Supplies, operating - - - - - Misc office supplies 2100 Books & periodicals - - - City business journal 3030 Other professional services 1,059 1,059 TIF administration and reporting fees Financial consultant fees Special project consultant fees Appraisal and environmental fees 543 553 1.5% of audit (23-36,145, 24-36,870, 25-37,605, 26-38,360) 1,316 2,282 2,337 1,602 1,612 3800 Mileage - - - Misc. mileage 7050 Construction - - - - - 8010 Pay-as-you-go principal - 7,633 67,961 74,440 63,997 Principal on a revenue note issued to promote a development. (MWF) 8020 Pay-as-you-go interest 4,873 33,211 6,511 - - Interest on a revenue note issued to promote a development. 9900 Transfer out to EDA Fund - 6,989 8,149 8,393 5,828 Transfer to cover the EDA operating budget. 6,189 50,115 84,959 84,435 71,437 709.75% 69.53% -0.62% -15.39% Fund: 442 TIF District #7 Fund: 442 Department: 4650 Economic Development ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1600 Supplies, operating - - - - - Misc office supplies 2100 Books & periodicals - - - City business journal 3030 Other professional services - - TIF administration and reporting fees Financial consultant fees Special project consultant fees Appraisal and environmental fees - 553 1.5% of audit (23-36,145, 24-36,870, 25-37,605, 26-38,360) - - - - 553 3800 Mileage - - - Misc. mileage 7050 Construction - - - - - 8010 Pay-as-you-go principal - - - - - Principal on a revenue note issued to promote a development. (Skyline) 8020 Pay-as-you-go interest - - - - - Interest on a revenue note issued to promote a development. 9900 Transfer out to EDA Fund - - - - - Transfer to cover the EDA operating budget. - - - - 553 #DIV/0! #DIV/0! #DIV/0! #DIV/0! Fund: 450 TIF District #5 Fund: 450 Department: 4650 Economic Development ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1600 Supplies, operating - - - - - Misc office supplies 2100 Books & periodicals - - - City business journal 3030 Other professional services 3,600 3,600 TIF administration and reporting fees Financial consultant fees Special project consultant fees Appraisal and environmental fees 1,808 1,808 5% of audit (23-36,145, 24-36,870, 25-37,605, 26-38,360) 4,656 3,523 3,585 5,408 5,408 3800 Mileage - - - Misc. mileage 7050 Construction - - - - - 8010 Pay-as-you-go principal 626,473 700,322 754,251 1,764,282 1,716,005 Principal on a revenue note issued to promote a development. (Medtronic) 8020 Pay-as-you-go interest 1,020,860 988,512 952,653 - - Interest on a revenue note issued to promote a development. (Medtronic) 9900 Transfer out to EDA Fund 88,036 89,690 91,484 94,229 86,402 Transfer to cover the EDA operating budget. 1,740,024 1,782,046 1,801,973 1,863,919 1,807,815 2.42% 1.12% 3.44% -3.01% 73 451 460 480 485 Park Fund Veh/Equip Replacement Special Projects Street Improvements Total REVENUES Property Taxes -$ -$ -$ 150,000$ 150,000$ Franchise Fee - - - 385,000 385,000 Special Assessments - - - 11,000 11,000 Intergovernmental - - - 460,000 460,000 Charges for Services 3,000 - - - 3,000 Investment Earnings 1,000 - 1,000 5,000 7,000 Transfers In - 619,081 300,000 350,000 1,269,081 TOTAL REVENUES 4,000$ 619,081$ 301,000$ 1,361,000$ 2,285,081$ EXPENDITURES Other Services and Charges -$ -$ 220,000$ -$ 220,000$ Capital Expenditures 175,000 244,000 1,410,000 1,279,856 3,108,856 Transfers - 73,000 - - 73,000 TOTAL EXPENDITURES 175,000$ 317,000$ 1,630,000$ 1,279,856$ 3,401,856$ NET CHANGES IN FUND BALANCE (171,000)$ 302,081$ (1,329,000)$ 81,144$ (1,116,775)$ 74 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Park Dedication Fees - 24,803 425,945 3,000 3,000 Investment earnings 3,194 (1,020) (14,627) 500 1,000 Total revenues 3,194 23,783 411,318 3,500 4,000 Expenditures: Materials & supplies 748 2,719 8,520 - - Other services & charges 1,167 - - - - Capital outlay - 9,900 286,138 447,615 175,000 Total expenditures 1,915 12,619 294,658 447,615 175,000 Net increase (decrease) in fund balance 1,279 11,164 116,660 (444,115) (171,000) Fund balance - January 1 183,098 184,377 195,541 312,201 (131,914) Fund balance - December 31 184,377 195,541 312,201 (131,914) (302,914) CITY OF MOUNDS VIEW Park Development Fund (451) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 75 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 451-4470-1230 Supplies - Equipment 748.00 2,719.28 8,520.11 - - - 0.0% Supplies and Materials 748.00 2,719.28 8,520.11 - - - 0.0% 451-4350-5110 Repairs - Bldgs & Grounds 1,167.49 - - - - - 0.0% Supplies and Materials 1,167.49 - - - - - 0.0% 451-4470-7050 Construction - 9,900.00 286,137.82 447,615 175,000 (272,615) -60.9% Capital Expenditures - 9,900.00 286,137.82 447,615 175,000 (272,615) -60.9% 451 Park Fund 1,915.49 12,619.28 294,657.93 447,615 175,000 (272,615) -60.9% 76 Fund: 451 Park Dedication Fund Fund: 451 Department: 4470 Expenditures ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1230 Supplies, equipment 748 2,719 8,520 - - Sand nozzles for Vactor 1240 Supplies, streets - - - Bituminous mix 5110 Repairs - Bldgs & Grounds 1,167 - - 7050 Construction > $25000 20,000 ? Chair swing - Silver View Park 302,615 - Greenfield playground 125,000 ? Pickle Ball court - Silver View Park - 150,000 Hillview Park playground rehab (funding source) - 25,000 Groveland/Hodges Park shelters flooring replacement (funding source) - - - - - Hillview Parking Area - 9,900 286,138 447,615 175,000 9900 Transfer to General Fund - - - - - 1,915 12,619 294,658 447,615 175,000 558.80% 2234.98% 51.91% -60.90% 77 THIS PAGE LEFT BLANK INTENTIONALLY 78 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Miscellaneous revenue - - - - - Total revenues - - - - - Expenditures: Supplies 16,398 2,640 1,966 - - Other Services & Charges 255 - 640 - - Equipment 181,619 208,131 6,930 89,000 47,000 Vehicles 203,455 237,151 16,802 223,000 197,000 Total expenditures 401,727 447,922 26,338 312,000 244,000 Excess (deficit) of revenue over expenditures (401,727) (447,922) (26,338) (312,000) (244,000) Other financing sources (uses): Transfers in (out) General Fund 299,000 400,000 300,000 300,000 419,081 Water Fund 67,000 70,000 70,000 80,000 90,000 Sewer Fund 55,000 55,000 55,000 52,000 60,000 Storm Water Fund 33,000 33,000 35,000 33,000 50,000 General Fund - - (26,000) (27,000) (28,000) Water Fund - (125,000) - (82,500) - Storm Water Fund - - - (37,500) (45,000) Net increase (decrease) in fund balance 52,273 (14,922) 407,662 6,000 302,081 Fund balance - January 1 1,904,974 1,957,247 1,942,325 2,349,987 2,355,987 Fund balance - December 31 1,957,247 1,942,325 2,349,987 2,355,987 2,658,068 CITY OF MOUNDS VIEW Vehicle and Equipment Replacement Fund (460) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 79 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 460-4160-1230 Supplies - Equipment - 839.99 - - - - 0.0% 460-4200-1230 Supplies - Equipment 10,263.10 1,799.65 1,965.64 - - - 0.0% 460-4470-1230 Supplies - Equipment 6,134.62 - - - - - 0.0% Supplies and Materials 16,397.72 2,639.64 1,965.64 - - - 0.0% 460-4160-3030 Other Professional Services - - 640.00 - - - 0.0% 460-4200-5120 Repairs - Vehicles 255.00 - - - - - 0.0% Other Services and Charges 255.00 - 640.00 - - - 0.0% 460-4160-7030 Equip - Central Services - - - - 37,000 37,000 0.0% 460-4200-7030 Equip - Police - 92,839.25 6,930.00 35,000 - (35,000) -100.0% 460-4200-7040 Vehicles - Police 97,068.21 35,259.24 16,801.99 183,000 45,000 (138,000) -75.4% 460-4360-7030 Equip - Parks - 115,292.00 - 29,000 - (29,000) -100.0% 460-4360-7040 Vehicles - Parks 57,043.31 - - 40,000 85,000 45,000 112.5% 460-4470-7030 Equip - Public Works 181,619.00 - - 25,000 10,000 (15,000) -60.0% 460-4470-7040 Vehicles - Public Works 49,343.39 201,892.08 - - 67,000 67,000 0.0% 460-4160-9900 Transfers Out - 125,000.00 26,000.00 147,000 73,000 (74,000) -50.3% Capital Expenditures 385,073.91 570,282.57 49,731.99 459,000 317,000 (142,000) -30.9% 460 Vehicle/Equip Replace 401,726.63 572,922.21 52,337.63 459,000 317,000 (142,000) -30.9% 80 Fund: 460 Vehicle & Equipment Fund ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description Fund: 460 Department: 4160 Central Services Operations 1230 Supplies, equip < $5,000 - 840 - - - 3030 Other professional services - - 640 - - 7030 Equipment > $5000 - 18,000 IP Phones - 19,000 Copiers (5) CH, Comm Dev, PD, PW, Comm Ctr in 2024 - - - - 37,000 7040 Vehicles - - - - - Fund: 460 Department: 4200 Police Operations 1230 Supplies, equip < $5,000 10,263 1,800 1,966 - - 5120 Repairs Vehicles 255 - - - - 7030 Equipment > $5000 - 92,839 6,930 35,000 - Watchgurard server upgrade (move to cloud) 7040 Vehicles 97,068 35,259 16,802 183,000 45,000 (1) Detective/Staff car Fund: 460 Department: 4360 Parks Operations 7030 Equipment > $5000 - 115,292 - 29,000 - Turfcat utility cart 7040 Vehicles 57,043 - - 40,000 85,000 Parks maint 3/4 ton pick-up Fund: 460 Department: 4460 Building & Grounds Operations 7030 Equipment > $5000 - - - - - Replace City Hall entrance lights (Bldg & grnds) 7040 Vehicles - - - - - Fund: 460 Department: 4470 Pavement Management Operations 1230 Supplies, equip < $5,000 6,135 - - - - Refurbish 2 trailers 7030 Equipment > $5000 - 10,000 Auto Lube 25,000 - Compactor - - Sweeper/Scrubber (new item) - - Brine solution equipment (Snow & Ice removal) - - Air compressor (1/2 parks 1/2 pavement mgt.) 181,619 - - 25,000 10,000 7040 Vehicles 49,343 201,892 - - 67,000 Bucket truck (used) 9900 Transfers out 26,000 27,000 28,000 Various equipment purchases general fund - 45,000 Storm Water - F250 truck 37,500 - Storm Water tracked skid steer 1/2 37,500 - Water tracked skid steer 1/2 45,000 - Water - (1/2 ton truck 4x4 ($35,000) - 125,000 26,000 147,000 73,000 401,727 572,922 52,338 459,000 317,000 42.61% -90.86% 777.00% -30.94% 81 THIS PAGE LEFT BLANK INTENTIONALLY 82 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Special Assessments 635 477 - - - Other government grants/aid - - 47,500 - - Investment earnings 18,796 (6,295) (81,333) 1,000 1,000 Total revenues 19,431 (5,818) (33,833) 1,000 1,000 Expenditures: Materials & Supplies 10,208 15,404 7,835 750 - Other Services & Charges 13,140 42,474 172,322 205,000 220,000 Projects 374,360 396,084 189,566 23,500 1,410,000 Total expenditures 397,707 453,962 369,723 229,250 1,630,000 Excess (deficit) of revenue over expenditures (378,277) (459,780) (403,556) (228,250) (1,629,000) Other financing sources (uses): Transfers in (out) General Fund 475,000 725,000 75,000 75,000 300,000 Net increase (decrease) in fund balance 96,723 265,220 (328,556) (153,250) (1,329,000) Fund balance - January 1 1,294,877 1,391,600 1,656,820 1,328,264 1,175,014 Fund balance - December 31 1,391,600 1,656,820 1,328,264 1,175,014 (153,986) CITY OF MOUNDS VIEW Special Projects Fund (480) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 83 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 480-4160-1230 Supplies - Equipment 10,207.71 15,403.84 7,835.44 750 - (750) -100.0% Supplies and Materials 10,207.71 15,403.84 7,835.44 750 - (750) -100.0% 480-4160-3030 Other Professional Services 12,600.00 42,474.07 155,121.91 205,000 220,000 15,000 7.3% 480-4470-3030 Other Professional Services 540.00 - - - - - 0.0% 480-4160-5130 Repairs - Equipment - - 17,200.00 - - - 0.0% Other Services and Charges 13,140.00 42,474.07 172,321.91 205,000 220,000 15,000 7.3% 480-4160-7030 Equip - Central Services 22,316.30 396,084.00 143,367.91 23,500 10,000 (13,500) -57.4% 480-4160-7050 Construction - Central Services 337,543.30 - 26,678.71 - 1,400,000 1,400,000 0.0% 480-4180-7050 Construction - - - 19,518.98 - - - 0.0% 480-4470-7050 Construction - Public Works 14,500.00 - - - - - 0.0% Capital Expenditures 374,359.60 396,084.00 189,565.60 23,500 1,410,000 1,386,500 5900.0% 480 Special Projects 397,707.31 453,961.91 369,722.95 229,250 1,630,000 1,400,750 611.0% 84 Fund: 480 Special Projects Fund: 480 Department: 4160 Expenditures ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1230 Supplies, equipment 10,208 15,404 7,835 750 - Vaccum Comm. Ctr. 1240 Supplies, streets - - - Bituminous mix 3030 Other professional services 35,000 35,000 CommCtr painting (carryover to 2024) 15,000 15,000 CommCtr front counter upgrades (carryover to 2024) 10,000 10,000 CommCtr Repair Skylights (carryover to 2024) - 15,000 MVCC sidewalk replacement - - CommCtr intrusion system update - - Security fence for PD parking lot - - CommCtr Dividers (carryover $6,300) - - Siren upgrades (2 sirens)(Bronson, Mustang Circle) - - Roof management survey - 15,000 Wall management program - 15,000 Roof management program 60,000 30,000 Consultants for CC expansion (R9484, R9485) - - Trench Drian PW Shop - - Codification of City Code - - Comm Dev Permit software TBD 85,000 85,000 Finance/Payroll/Utility Billing software upgrade (place holder) 12,600 42,474 155,122 205,000 220,000 3030 Other professional services 540 - - - - 5130 Repairs - equipemnt - - 17,200 7030 Capital, equipment > $5000 - - CommCtr Banquet Ctr carpet (carryover to 2022) 13,500 - Floor auto scrubber, hand dryers Comm. Ctr. 10,000 10,000 Park building video and door lock improvements - - Video and Security improvements for CH and CC (BBC grant of $2,000) - - Road sensors 3 locations - - Automatic Transfer switch (CH generator)(defer to 2019) - - Upgrade CH electrical panel - - Audio Visual upgrades for Banquet Center - - PW Bldg cameras, floor sealing, security system - - City monument sign County H round-about gateway - - HVAC upgrades - CH, CC, PW 22,316 396,084 143,368 23,500 10,000 7050 Construction > $25000 - - PW floor sealing and ADA Doors (Carryover to 2022) - - Splash Pad - - Police parking lot lighting - - Masonry renovation of CH & CC - - CC retro commissioning Improvements (phase 1) - - CH Park redesign - - CommCtr HVAC Improvements (RTU-4,7 and VAV's)(carryover to 2020) - - Cty Rd H sidewalk - - DP swithches CH & CC (carryover to 2020) - - Remodel prep kitchen - - CommCtr. divider wall replacement & front counter gate - 400,000 City Hall Park challenge course - 250,000 Veterans Memorial - 750,000 PD training and garage addition - - CommCtr restrooms in gym locker rooms 337,543 - 26,679 - 1,400,000 7050 Construction > $25000 - - 19,519 - - 7050 Construction > $25000 14,500 - - - - 9900 Transfers out - - - - - 397,707 453,962 369,723 229,250 1,630,000 14.14% -18.56% -37.99% 611.01% 85 THIS PAGE LEFT BLANK INTENTIONALLY 86 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Property Taxes 151,111 149,942 146,292 150,000 150,000 Franchise Tax 301,755 335,107 425,517 340,000 385,000 Special Assessments 26,042 21,007 16,742 15,000 11,000 State Aid 484,789 408,790 459,169 435,000 460,000 Investment earnings 42,740 (14,196) (96,343) 5,000 5,000 Other 1,924 - 2,185 - - Total revenues 1,008,362 900,651 953,562 945,000 1,011,000 Expenditures: Materials & Supplies - - 9,703 - - Engineering 24,706 162,295 4,862 - - Projects 579,516 380,702 2,113,342 2,683,157 1,279,856 Total expenditures 604,222 542,997 2,127,907 2,683,157 1,279,856 Excess (deficit) of revenue over expenditures 404,139 357,654 (1,174,345) (1,738,157) (268,856) Other financing sources (uses): Transfers in (out) General Fund - - - 1,500,000 350,000 EDA General (701,000) - - - - Net increase (decrease) in fund balance (296,861) 357,654 (1,174,345) (238,157) 81,144 Fund balance - January 1 2,147,774 1,850,913 2,208,567 1,034,222 796,065 Fund balance - December 31 1,850,913 2,208,567 1,034,222 796,065 877,209 CITY OF MOUNDS VIEW Street Improvement Fund (485) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 87 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 485-4470-1600 Operating Supplies - - 9,703.16 - - - 0.0% Supplies and Materials - - 9,703.16 - - - 0.0% 485-4470-3030 Other Professional Services 24,706.17 162,295.01 4,861.50 - - - 0.0% Other Services and Charges 24,706.17 162,295.01 4,861.50 - - - 0.0% 485-4470-7050 Buildings & Structures 579,516.28 380,701.81 2,113,342.20 2,683,157 1,279,856 (1,403,301) -52.3% 485-4470-9900 Impr Other Than Buildings 701,000.00 - - - - - 0.0% Capital Expenditures 1,280,516.28 380,701.81 2,113,342.20 2,683,157 1,279,856 (1,403,301) -52.3% 485 Street Improvements 1,305,222.45 542,996.82 2,127,906.86 2,683,157 1,279,856 (1,403,301) -52.3% 88 Fund: 485 Street Improvement Fund: 485 Department: 4470 Expenditures ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1230 Supplies, equipment - - - Sand nozzles for Vactor 1240 Supplies, streets - - - Bituminous mix 1600 Operating supplies - - 9,703 3030 Other professional services 24,706 162,295 4,862 - - Engineering and other professional fees for 2009 street project 7050 Construction > $25000 - - 2020 Quincy Street (costruction) in TIF #3 50,000 - 2022 Pleasant View and Spring Lake Road N of MV Blvd (const phase) 1,828,000 19,454 2023 Spring Lake Road S of MV Blvd (const phase) 266,000 - Trail segments 7 & 8 bid with street project 13,000 - MV Drive, various cul-de-sacs (design) 225,000 - Pleasant View/Stinson & County Road I ( Design & Reconstruct - Fridley) 50,000 - Bronson Long Lake Road to Edgewood (Reconstruct Design) - 90,000 Design H2 - 110,000 City Hall Park Imp - Splash Pad Parking Lot, Sidewalk and Trails - 125,000 Bronson (L Lake Rd to Edgewood) - 817,712 Mill & overlay - MV Drive, various cul-de-sacs, Park View, Bronson 75,000 75,000 Trailway development and ADA transition project (2022 - 2024) 141,157 42,690 Pavement Maint. Reclomite - Area J, K - - Mill and overlay Silver View parking lot (Carryover to 2019) - - Mill and overlay (CH & MVCC) - - Cty Rd H2/10 intersection (City share)(Ramsey Co is lead) - - Cty Rd H/10 intersection (MSA eligible)(City share)(Ramsey Co is lead) - - Trail segments 1 - 5 - - Traffic signal @ H and Silver Lake Road (what does council want to do?) - - Trail segments 6 and 11 (County grant/match of $39,300) - - Cty Rd I and Quincy Intersection street lights - - Other pavement improvements (Silver View parking lot and trails) 35,000 - Fog seal various parking lots/trails - - Seal coat projects (replaced with Reclomite process) 579,516 380,702 2,113,342 2,683,157 1,279,856 9900 Transfer out 701,000 - - - - EDA 1,305,222 542,997 2,127,907 2,683,157 1,279,856 -34.31% 455.12% 26.96% -52.30% 89 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Property Taxes 418,667 412,848 404,683 413,983 416,293 Investment earnings 2,258 (672) (9,070) 500 500 Total revenues 420,925 412,176 395,613 414,483 416,793 Expenditures: Principal 235,000 240,000 245,000 255,000 260,000 Interest 159,995 152,870 145,595 138,095 130,370 Paying Agent Fee 475 713 475 475 475 Continuing Disclosure - 1,533 4,283 1,750 1,750 Total expenditures 395,470 395,115 395,353 395,320 392,595 Net increase (decrease) in fund balance 25,455 17,061 260 19,163 24,198 Fund balance - January 1 348,395 373,850 390,911 391,171 410,334 Fund balance - December 31 373,850 390,911 391,171 410,334 434,532 CITY OF MOUNDS VIEW Debt Service Fund (506) STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE 90 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 506-4750-8010 Debt - Principal 235,000.00 240,000.00 245,000.00 255,000 260,000 5,000 2.0% 506-4750-8020 Debt - Interest 159,995.00 152,870.00 145,595.00 138,095 130,370 (7,725) -5.6% 506-4750-8030 Paying Agent Fees 475.00 712.50 475.00 475 475 - 0.0% 506-4750-8040 Continuing Disclosure - 1,532.50 4,282.50 1,750 1,750 - 0.0% Debt Service 395,470.00 395,115.00 395,352.50 395,320 392,595 (2,725) -0.7% 506 Debt Service 395,470.00 395,115.00 395,352.50 395,320 392,595 (2,725) -0.7% 91 700 730 740 745 Water Sanitary Sewer Street Lighting Storm Water Total OPERATING REVENUES Charges for Services 1,538,244$ 2,115,806$ 116,814$ 448,969$ 4,219,833$ TOTAL OPERATING REVENUES 1,538,244$ 2,115,806$ 116,814$ 448,969$ 4,219,833$ OPERATING EXPENSES Personnel Expenses 561,390$ 529,970$ 26,040$ 194,920$ 1,312,320$ Supplies and Materials 92,752 37,422 1,000 26,164 157,338 Other Services and Charges 615,557 1,515,930 101,850 180,676 2,414,013 Contingency 15,000 15,000 - - 30,000 Capital Expenditures 600,000 530,000 - 290,000 1,420,000 TOTAL OPERATING EXPENSES 1,884,699$ 2,628,322$ 128,890$ 691,760$ 5,333,671$ NET OPERATING INCOME (LOSS)(346,455)$ (512,516)$ (12,076)$ (242,791)$ (1,113,838)$ NON-OPERATING REVENUE (EXPENSE) Investment Earnings 2,000 20,000 1,400 16,000 39,400 Debt Service (434,148) - - - (434,148) TOTAL NON-OPERATING (432,148)$ 20,000$ 1,400$ 16,000$ (394,748)$ TRANSFERS AND OTHER FINANCING SOURCES (USES) Transfers In - - - 45,000 45,000 Transfers (183,258) (153,258) (3,309) (59,632) (399,457) TOTAL TRANSFERS AND OTHER (183,258)$ (153,258)$ (3,309)$ (14,632)$ (354,457)$ REVENUES OVER (UNDER) EXPENSES (961,861)$ (645,774)$ (13,985)$ (241,423)$ (1,863,043) ADD BACK Capital Expenditures 600,000 530,000 - 290,000 1,420,000 Debt - Principal 355,000 - - - 355,000 NET INCOME (LOSS)(6,861)$ (115,774)$ (13,985)$ 48,577$ (88,043) 92 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Operating revenues: Water billings 1,168,083 1,261,990 1,208,947 1,280,084 1,344,244 Water service insurance 93,774 95,441 95,282 92,000 102,000 Other charges 10,927 13,435 16,237 9,000 9,000 Total revenues 1,272,783 1,370,866 1,320,465.61 1,381,084 1,455,244 Operating expenses (4820): Personnel services 65,508 40,021 88,157 73,054 79,530 Materials & Supplies - - - 50 50 Other Services & Charges 17,096 18,971 17,820 26,263 29,118 Debt costs 100,764 77,350 71,186 86,173 79,148 Operating expenses (4823): Personnel services 349,699 341,047 361,326 385,900 436,660 Materials & Supplies 38,616 47,932 39,007 44,458 46,758 Other Services & Charges 187,693 185,385 274,234 224,194 233,194 Depreciation 198,159 194,482 186,181 220,000 200,000 Operating expenses (4825): Personnel services 42,114 42,150 45,539 45,268 45,200 Materials & Supplies 14,704 20,435 42,157 35,544 45,944 Other Services & Charges 116,149 125,763 140,995 147,245 153,245 Total expenses 1,130,502 1,093,537 1,266,601.50 1,288,149 1,348,847 Operating income (loss) 142,281 277,329 53,864 92,935 106,397 Nonoperating revenues (expenses): Special assessments 87,564 85,600 85,480 80,500 81,000 Investment earnings 6,257 4,157 (83,778) 2,000 2,000 Intergovernmental revenue 649 464 1,589 - - Connection/WAC charges 5,250 2,850 48,550 2,000 2,000 Contingency - - - (15,000) (15,000) Total nonoperating revenues (expenses)99,720 93,071 51,840.96 69,500 70,000 Net income (loss) before contributions and transfers 242,001 370,400 105,705 162,435 176,397 Transfers in (out): General Fund (82,859) (85,345) (87,905) (90,542) (93,258) Vehicle & Equipment Replacement (67,000) (70,000) (70,000) (80,000) (90,000) Vehicle & Equipment Replacement - 125,000 - 82,500 - Change in net assets 92,142 340,055 (52,200) 74,393 (6,861) Net assets - January 1 4,181,479 4,273,621 4,613,675 4,561,475 4,635,868 Net assets - December 31 4,273,621 4,613,675 4,561,475 4,635,868 4,629,007 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Net income (loss) before contributions and transfers 242,001 370,400 105,705 162,435 176,397 Add depreciation 198,159 194,482 186,181 220,000 200,000 Change in current assets (27,528) (124,004) (38,620) - - Change in current liabilities 468,320 352,744 (188,951) - - Purchase of fixed assets (2,959,543) (2,165,314) (1,231,434) (1,707,500) (600,000) Debt principal 5,830,000 - (335,000) (350,000) (355,000) Transfers in (out)(149,859) (30,345) (157,905) (88,042) (183,258) Net increase (decrease) in cash 3,601,551 (1,402,038) (1,660,024) (1,763,107) (761,861) Cash balance - January 1 676,292 4,277,843 2,875,805 1,215,781 (547,326) Cash balance - December 31 4,277,843 2,875,805 1,215,781 (547,326) (1,309,187) STATEMENT OF CASH FLOWS CITY OF MOUNDS VIEW WATER FUND (700) STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS 93 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 700-4820-0100 Regular Salaries 45,906.85 49,825.81 52,688.94 53,699 59,340 5,641 10.5% 700-4820-0150 Part Time Salaries - - - 2,250 2,460 210 9.3% 700-4820-0300 Social Security 3,091.20 3,561.89 3,651.18 4,280 4,670 390 9.1% 700-4820-0321 PERA Employer 2,921.85 3,035.43 3,255.70 4,198 3,930 (268) -6.4% 700-4820-0322 Pension Expense 5,831.00 (24,171.00) 20,406.00 - - - 0.0% 700-4820-0400 Health Employer 6,852.94 6,881.40 7,214.74 8,199 8,640 441 5.4% 700-4820-0410 Life Employer 445.44 445.44 458.52 - - - 0.0% 700-4820-0420 Dental Employer 162.48 162.48 171.99 - - - 0.0% 700-4820-0500 Workers Comp Ins Premiums 296.40 279.18 310.36 428 490 62 14.5% 700-4823-0100 Regular Salaries 248,078.22 249,507.92 255,040.11 255,849 291,380 35,531 13.9% 700-4823-0110 Overtime 15,329.93 11,849.86 17,409.35 11,921 12,400 479 4.0% 700-4823-0150 Part Time Salaries 4,081.88 - 963.88 20,085 21,530 1,445 7.2% 700-4823-0300 Social Security 18,186.45 17,634.82 19,058.24 21,982 24,890 2,908 13.2% 700-4823-0321 PERA Employer 18,793.37 18,550.71 20,101.00 20,888 23,660 2,772 13.3% 700-4823-0400 Health Employer 36,900.76 37,102.04 41,783.75 48,096 53,730 5,634 11.7% 700-4823-0410 Life Employer 414.85 363.38 390.21 - - - 0.0% 700-4823-0420 Dental Employer 959.56 830.82 862.06 - - - 0.0% 700-4823-0500 Workers Comp Ins Premiums 6,954.04 5,207.70 5,717.74 7,079 9,070 1,991 28.1% 700-4825-0100 Regular Salaries 29,624.55 29,068.14 30,246.24 32,329 31,960 (369) -1.1% 700-4825-0110 Overtime 1,649.24 2,195.92 3,138.18 - - - 0.0% 700-4825-0300 Social Security 2,195.20 2,078.98 2,207.27 2,443 2,450 7 0.3% 700-4825-0321 PERA Employer 2,240.22 2,306.09 2,490.05 2,395 2,400 5 0.2% 700-4825-0400 Health Employer 5,339.37 5,522.66 6,385.11 6,840 7,060 220 3.2% 700-4825-0410 Life Employer 10.86 5.89 9.88 - - - 0.0% 700-4825-0420 Dental Employer 1.15 0.92 3.32 - - - 0.0% 700-4825-0500 Workers Comp Ins Premiums 1,053.80 971.30 1,058.72 1,261 1,330 69 5.5% Personnel Expenses 457,321.61 423,217.78 495,022.54 504,222 561,390 57,168 11.3% 700-4820-1600 Operating Supplies - - - 50 50 - 0.0% 700-4823-1210 Supplies - Bldgs & Grounds 2,160.35 2,723.78 1,567.23 3,000 3,000 - 0.0% 700-4823-1220 Supplies - Vehicles 1,637.38 4,940.21 4,801.50 2,000 2,000 - 0.0% 700-4823-1230 Supplies - Equipment 2,836.49 3,356.74 8,357.24 2,625 2,625 - 0.0% 700-4823-1240 Supplies - Streets 5,657.46 8,350.31 5,930.17 5,000 7,500 2,500 50.0% 700-4823-1250 Supplies - Utilities 8,520.51 7,336.19 5,954.76 13,950 13,750 (200) -1.4% 700-4823-1260 Supplies - Traffic Control 211.00 - 494.00 200 200 - 0.0% 700-4823-1600 Operating Supplies 10,355.63 13,659.66 3,641.84 8,500 8,500 - 0.0% 700-4823-1700 Motor Fuels & Lubricants 5,457.93 6,191.88 6,509.47 7,463 7,463 - 0.0% 700-4823-2400 Uniforms & Clothing 1,334.53 959.07 1,447.65 1,100 1,100 - 0.0% 700-4823-2410 Maint - Mats, Towels 444.92 414.60 302.69 620 620 - 0.0% 700-4825-1600 Operating Supplies 13,848.20 19,627.14 41,430.29 34,900 45,300 10,400 29.8% 700-4825-2400 Uniforms & Clothing 615.33 600.89 574.88 500 500 - 0.0% 700-4825-2410 Maint - Mats, Towels 240.79 207.15 151.50 144 144 - 0.0% Supplies and Materials 53,320.52 68,367.62 81,163.22 80,052 92,752 12,700 15.9% 700-4820-3030 Other Professional Services 8,616.28 8,990.31 9,040.61 9,256 9,434 178 1.9% 700-4820-3300 Postage 2,680.37 2,479.28 2,596.84 4,600 4,600 - 0.0% 700-4820-3430 Printing 899.68 1,141.46 380.54 900 900 - 0.0% 700-4820-3630 Training & Conferences - - - 2,400 2,400 - 0.0% 700-4820-5130 Repairs - Equipment 4,899.17 6,360.12 5,802.12 9,107 11,784 2,677 29.4% 700-4823-3030 Other Professional Services 15,612.82 35,421.95 16,519.21 45,750 49,750 4,000 8.7% 700-4823-3100 Telephone 5,208.80 3,491.48 3,514.11 4,084 4,084 - 0.0% 700-4823-3200 Water & Sewer 6,347.20 9,086.67 6,741.97 7,200 7,200 - 0.0% 700-4823-3220 Natural Gas 5,864.02 7,166.34 12,661.77 8,500 8,500 - 0.0% 700-4823-3610 Memberships 150.00 200.00 180.00 360 360 - 0.0% 700-4823-3630 Training & Conferences 1,224.96 2,713.86 4,886.43 5,530 6,130 600 10.8% 700-4823-4010 Rental - Equipment 629.00 265.00 1,053.23 1,500 1,500 - 0.0% 700-4823-4800 Insurance & Bonds 8,589.62 8,184.13 8,091.03 10,230 10,230 - 0.0% 700-4823-5110 Repairs - Bldgs & Grounds 1,983.10 5,182.97 771.20 10,540 10,540 - 0.0% 700-4823-5120 Repairs - Vehicles - - - 1,000 3,000 2,000 200.0% 700-4823-5130 Repairs - Equipment 17,179.51 6,798.77 9,292.33 8,500 10,900 2,400 28.2% 700-4823-5140 Repairs - Streets 15,106.51 1,402.38 7,821.50 10,000 10,000 - 0.0% 700-4823-5150 Repairs - Utilities 13,941.22 12,092.47 50,590.89 17,500 17,500 - 0.0% 700-4823-5155 Repairs - Water Service 94,981.41 90,444.30 147,997.25 90,000 90,000 - 0.0% 700-4823-5160 Repairs - System Maint 874.80 2,934.94 4,112.74 3,500 3,500 - 0.0% 700-4823-7950 Depreciation 198,159.14 194,481.80 186,180.94 220,000 200,000 (20,000) -9.1% 700-4825-3030 Other Professional Services 5,895.72 6,616.76 11,870.41 19,245 23,245 4,000 20.8% 700-4825-3210 Electricity 110,253.37 119,146.67 129,124.16 128,000 130,000 2,000 1.6% Other Services and Charges 519,096.70 524,601.66 619,229.28 617,702 615,557 (2,145) -0.3% 94 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 700-4823-7030 Construction Contract - - - 1,472,500 265,000 (1,207,500) -82.0% 700-4823-7050 Construction Contract - - - 235,000 335,000 100,000 42.6% 700-4823-9100 Contingency - - - 15,000 15,000 - 0.0% Capital Expenditures - - - 1,722,500 615,000 (1,107,500) -64.3% 700-4820-8010 Debt - Principal - - - 350,000 355,000 5,000 1.4% 700-4820-8020 Debt - Interest - 75,580.14 69,178.96 83,223 76,173 (7,050) -8.5% 700-4820-8030 Paying Agent Fees - 237.50 475.00 450 475 25 5.6% 700-4820-8040 Continuing Disclosure - 1,532.50 1,532.50 2,500 2,500 - 0.0% 700-4820-8050 Issuance Costs 100,763.51 - - - - - 0.0% Debt Service 100,763.51 77,350.14 71,186.46 436,173 434,148 (2,025) -0.5% 700-4820-9900 Transfers Out 149,859.00 155,345.00 157,905.00 170,542 183,258 12,716 7.5% Transfers 149,859.00 155,345.00 157,905.00 170,542 183,258 12,716 7.5% 700 Water Utility Fund 1,280,361.34 1,248,882.20 1,424,506.50 3,531,191 2,502,105 (1,029,086) -29.1% 95 Fund: 700 Department: 4820 Billing Services ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1600 Supplies, operating - - - 50 50 Utility billing supplies 3030 Other professional services 8,856 9,034 24.5% of audit (23-36,145, 24-36,870, 25-37,605, 26-38,360) - - Financial/Payroll/Utility billing software search/selection costs - - Inserting & mailing bills (move to 3300) 400 400 County special assessment maintenance fee - - Annual maintenance (meter reading software)(50% sewer, 50% Water) 8,616 8,990 9,041 9,256 9,434 3300 Postage 3,300 3,300 3300 bills X $0.50 postage X 4 billings X 1/2 cost 800 800 Inserting & mailing bills (moved from 3030) 500 500 Late notices: 500 bills X $0.50 postage X 4 billings X 1/2 cost 2,680 2,479 2,597 4,600 4,600 3430 Printing 450 450 Utility bills (1/2 cost) 450 450 Envelopes 900 1,141 381 900 900 3630 Training - - - 2,400 2,400 Seminars on new regulations, software updates, etc. INCODE training 5130 Repairs, equipment 5,183 5,784 Incode software support (30%)(5% annual increase per agreement) 1,200 1,200 Incode UB support - 3,000 Mueller/Incode CIS interface and support (1/2 in sewer) 350 - Neptune reader maintenance (1/2 in sewer)(2019 first year $610) 1,800 1,800 Mueller software maintenance (1/2 in sewer) 574 - Handheld interface support for meter readers (1/2 in sewer)(Incode) 4,899 6,360 5,802 9,107 11,784 7030 Capital, equipment - - - - - Meter reader (1/2 water 1/2 sewer) 8010 Principal - - - 350,000 355,000 Principal due on bonds 8020 Interest - 75,580 69,179 83,223 76,173 Interest due on 2020 A Bonds 8030 Paying agent fees - 238 475 450 475 Paying agent fees on bond issues 8040 Continuing Disclosure - 1,533 1,533 2,500 2,500 Annual debt disclosure requirements and Ramsey county sp. Assmt. Fees 8050 Issuance Costs 100,764 - - - - Annual debt disclosure requirements and Ramsey county sp. Assmt. Fees 9900 Transfers out 90,542 93,258 Transfer to General Fund for administrative overhead costs 80,000 90,000 Transfer to Vehicle & Equipment Fund to fund future purchases 149,859 155,345 157,905 170,542 183,258 267,718 251,666 246,912 633,028 646,574 96 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1210 Supplies, Bldgs & grounds 100 100 Mops, buckets, brooms 500 500 Light tubes & ballasts 200 200 Paper products 200 200 Paint, thinner, & brushes 1,000 1,000 Black dirt & sod/seed, landscaping materials 500 500 Misc. cleaners for well houses & % of shop - - Fertilizer/seed/weed control/goose repellent 500 500 Irrigation parts 2,160 2,724 1,567 3,000 3,000 1220 Supplies, vehicles 300 300 Air, oil, fuel, & transmission filters 100 100 Fluids 400 400 Batteries and tires 50 50 Paint sealant 150 150 Tune ups 1,000 1,000 Misc repairs 1,637 4,940 4,802 2,000 2,000 1230 Supplies, equipment < $5000 100 100 Tune ups 100 100 Grounds maintenance equipment 100 100 Blades, suction hoses, filter screens 175 175 Hydraulic fluid: 35 gallons @ $4.80 / gallon 200 200 Solvents & cleaning fluids 200 200 Air compressor & dehumidifier parts 1,500 1,500 Chemical equipment parts (fluoride pumps) - - Locator ($5000 defer to 2018) - - Spin Doctor (battery operated valve operator) - - Line locator (Metrotech) - - Fluoride tank replacement (3 tanks every 3 years)(2018 next) 250 250 Air, oil, fuel, & trans filters (emergency generator) 2,836 3,357 8,357 2,625 2,625 1240 Supplies, streets 5,657 8,350 5,930 5,000 7,500 Asphalt/concrete/sod/seed for patching minor street, curb, driveway repairs. 1250 Supplies, utilities 5,000 6,000 Paint & sandblasting materials for hydrants 500 500 Copper, steel & PVC pipe - - Location flags & paint (moved to account 1600) 1,250 1,000 Valve box risers, main repair clamps 750 1,250 Hydrant markers - - De-chlorinator - - Scales in treatment plants ($2118 each x 5 plus incidentals) 3,000 2,500 Hydrant parts (hydrant pump $450 - 2017) 3,450 2,500 Meter supplies, etc. (move from account 1600) - - Metal locator replacement - - Motorized gate valve wrench - - Motorized valve exerciser (Hurco Spin Doctor)($4830 defer to 2018) - - Hydrant cut-off tool - - Plasma cutter 8,521 7,336 5,955 13,950 13,750 1260 Supplies, traffic control 211 - 494 200 200 Traffic cones / safety vests 1600 Supplies, operating 500 500 Propane, acetylene & oxygen supplies 400 400 Gloves, masks, & rags 2,850 2,850 Film, first aid supplies, & batteries (add hearing protection) 3,000 3,000 Location flags & paint (moved from account 1250) 250 250 Cleaning supplies 1,500 1,500 Additional & replacement hand tools 10,356 13,660 3,642 8,500 8,500 1700 Motor fuels & lubs 2,138 2,138 Diesel fuel - 475 gallons @ $4.50 450 450 Oil - - Propane: 50 gallons @ $4 4,875 4,875 Unleaded fuel: 1,300 gallons @ $3.75 5,458 6,192 6,509 7,463 7,463 2400 Uniforms 1,335 959 1,448 1,100 1,100 Uniforms 15.5% of $4,500 and clothing 1.7 FTE x $175 per contract 2410 Mats & towels 445 415 303 620 620 Share of floor mats & shop towels (15.5% of $4,000) 3030 Other professional services 700 700 Backflow prevention testing 4,500 4,500 Water system leak survey (every 2 years)(not done in 2019) - - Water tower evaluation 20,000 20,000 Consultant well head protection phase II 2,500 2,500 Annual inspections heating units in all water buildings 2,500 2,500 Annual inspection generator units - - Inspection of water tower and ground reservoir roof 450 450 Copier maintenance agreement (Split with 730) 700 700 Broadleaf control - 4,000 Permit module BS&A (in Water, Sewer, & Storm Water) 6,000 6,000 Asset management software 450 450 Fire sprinkler inspections/testing 200 200 Fire extinguisher inspection/service (10 @ $20) 1,500 1,500 Gopher State One-call locates 2,750 2,750 Safety Data Service (1/3 Sewer, 1/3 Storm Water) 3,500 3,500 ArcView/GIS base map and engineering consulting (Split with 730) 15,613 35,422 16,519 45,750 49,750 97 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 3100 Communications - telephone 600 600 Service & repair 1,954 1,954 Cellular phone service (20.06% of $9,200) 1,440 1,440 Data cards for SCADA (4)(75%)(40.01 per card) balance in Sewer 90 90 800 MHz license fee (33%)(5 radios @ $4.48 per month) 5,209 3,491 3,514 4,084 4,084 3200 Water and wastewater charges 6,347 9,087 6,742 7,200 7,200 3220 Natural gas 5,864 7,166 12,662 8,500 8,500 Heating fuel 3610 Memberships 120 120 MN Rural Water Association (50%) 100 100 MN Safety Council 60 60 Suburban Utility Superintendent Association (SUSA)(50% of $100) 80 80 Pressurized vessel license 150 200 180 360 360 3630 Training 150 200 Computer training/webinars - - Confined space safety seminar 1,200 1,200 Trench safety/confined space alternate years/inspection safety 1,000 1,000 Class A license 110 110 Hearing test/R2K (2.15 FTE * $50) - - License renewal 60 60 Maintenance Expo 2,000 2,000 Water operator class/exam/certificate ($xxx per person) 100 100 Misc. training seminars 300 300 Equipment operator training 150 300 MRWA workshops - - MN Public Works Assoc workshop 400 800 Tuition reimbursement 60 60 Work zone safety seminar (every 3 years) 1,225 2,714 4,886 5,530 6,130 4010 Rental, equipment 1,000 1,000 Skid steer - upgrade 300 300 Barricades & signs 200 200 Tools & equipment - - Fax machine 629 265 1,053 1,500 1,500 4800 Insurance 8,590 8,184 8,091 10,230 10,230 Share of property/liability insurance 5110 Repairs, buildings & grounds 1,000 1,000 Door & lock repairs 1,000 1,000 Roof & wall repairs 7,540 7,540 Electrical & mechanical repairs (well #2 in 17 well #4 in 18 $4540) 1,000 1,000 Site repairs (pavement, fence, irrigation, etc...) 1,983 5,183 771 10,540 10,540 5120 Repairs, vehicles - - - 1,000 3,000 Utility truck repairs 5130 Repairs, equipment 900 900 Well and water treatment plant repairs - - Copier maintenance - - Fire extinguisher recharge / repair (moved to 3030) 500 500 Miscellaneous repairs (Backhoe, Skid steer) - - Repair boiler @ main plant - - Backhoe overhall extend life 10 more years - - Refurbish trailer 2,000 2,000 Generator service - Onan 3,000 3,000 VFD service 1,000 1,000 Meter and valve repairs 1,000 3,000 SCADA repairs - - 10" gate valve repair (well #3) 100 500 Radio repairs 17,180 6,799 9,292 8,500 10,900 5140 Repairs, streets 15,107 1,402 7,822 10,000 10,000 Contractor repairs to streets after water main breaks 5150 Repairs, utilities 5,000 5,000 Fire hydrant repairs 5,000 5,000 Gate valve repairs 7,500 7,500 Water main repairs 13,941 12,092 50,591 17,500 17,500 5155 Water service repairs 80,000 80,000 Contractor repairs to residential water services. 10,000 10,000 Pavement & curb repairs 94,981 90,444 147,997 90,000 90,000 5160 System maintenance 875 2,935 4,113 3,500 3,500 Water system maintenance & repair items 98 Fund: 700 Department: 4823 Water Infrastructure & Equipment Maintenance 7030 Capital, equipment > $5000 15,000 15,000 Gate valves - - Water tower assessment - - GPS Locating Equipment (Sewer 5,000)(carryover from 2010) - - Booster station - - Ener-Tech - - Dehumidifier - - Plate compactor for backhoe - - Meters, MXUs - - Diffuser/Flushing (new) - - SCADA system upgrades (automatic controls) 1,375,000 250,000 Commercial/Residentional meter replacements - - Booster station (pressure valve) - - Water treatment plant (leaking valve) - - Trench box - - Electric rain gauges SCADA System (33%)(total cost $8,250) - - Generator (trailer mounted)(20,000 to water and 10,000 to sanitary sewer) - - Frost breaker - - Chop saw - - Chemical feed equipment - - Dehumidifier (well #6) - - Laptop and mounting bracket for infield use of record drawings - - Security cameras & card key access - - Air Compressor (well #5) - - Generator WTP #1 and booster station 37,500 - T76 T4 Compact Track Loader (skidsteer)(1/2 in Storm Water) 45,000 - 3/4 ton pick-up 4x2 - - Hydrant diffuser - - Water meter reader - handheld programmer - - - 1,472,500 265,000 7050 Construction > $25000 175,000 275,000 Water treatment plant engineering, design, construction - - Water system upgrades wells #1,2 - - Roof replacement well #1 60,000 60,000 Well pump rehabilitation project (approximately every 7 years per well) - - - 235,000 335,000 7950 Depreciation 198,159 194,482 186,181 220,000 200,000 Estimated depreciation 9100 Contingency - - - 15,000 15,000 Contingency 9900 Transfers out - - - - - Water system upgrades in conjunction with major roadway program 424,468 427,800 499,421 2,211,152 1,094,952 99 Fund: 700 Department: 4825 Water Production ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1600 Supplies, operating 550 550 Computer supplies - - Equipment repair parts 800 800 Testing reagents - - Sulfur dioxide: 25 150# cylinders @ $1.10 per pound 15,000 20,000 Chlorine: 8 - 1 ton cylinders @ .65 per pound 7,000 9,000 Chlorine: 75 - 150 # cylinders @ $.92 per pound 7,400 9,000 Hydrofluosilic acid: 20,000 pounds @ $0.37 3,300 5,000 Chlorine neutralizer 850 950 Rebuild kits (chlorine and flouride pump) 13,848 19,627 41,430 34,900 45,300 1700 Motor fuels & lubs - - - - - Turbine & electric motor oil 2400 Uniforms 615 601 575 500 500 Uniforms 3.6% of $4,500 and clothing .4 FTE x $175 per contract 2410 Mats & towels 241 207 152 144 144 Share of floor mats & shop towels (3.6% of $4,000) 3030 Other professional services 2,700 2,700 Bacteria tests (15*$15*12 months)(+$200 Health Dept Rule) - - Arsenal contaminant tests 800 800 Computer maintenance - - Consumer confidence report (on-line) 5,500 9,500 DNR water permit fee (ann. surcharge)(14 - $3826, 15 - $4462, 16 - $4532) - - DNR required Water Emergency and Conservation Plan Update of 1996 plan - - Emergency Response Comm. fees (same as MNDPS - EPCRA program) 1,120 1,120 Full scan tests - 4 @ $280 600 600 Minimum contamination level (MCL) tests - - One-call locating (moved to 700-4823-3030) 1,000 1,000 Radon tests 800 800 Random sample tests - - Wide spectrum water testing for wells - - Filter sand replenishment - - solenoid and valve repairs 1,425 1,425 MCES discharge permits (3*$475) 300 300 MNDPS - EPCRA program ($100/WTP) 5,000 5,000 Water Supply Plan - - Well head protection plan (req. by Dept. of Health)(11, 12, 13 Barr Eng.) 5,896 6,617 11,870 19,245 23,245 3210 Electricity 110,253 119,147 129,124 128,000 130,000 Electricity for wells, tower & reservoir 3630 Training - - - - - General training 7030 Capital, equipment - - - 130,853 146,199 183,151 182,789 199,189 Total Water 823,040 825,664 929,484 3,026,969 1,940,715 0.32% 12.57% 225.66% -35.89% 100 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Operating revenues: Sewer billings 1,825,212 1,848,632 1,940,359 2,003,740 2,101,806 Other charges 4,630 15,441 16,885 10,000 10,000 Total revenues 1,829,841 1,864,073 1,957,243.95 2,013,740 2,111,806 Operating expenses (4820): Personnel services 57,812 36,989 90,878 71,902 79,530 Materials & Supplies - - 81 50 50 Other Services & Charges 21,488 18,664 17,515 25,863 28,718 Operating expenses (4823): Personnel services 345,741 350,171 356,770 393,082 450,440 Materials & Supplies 17,925 22,937 44,827 34,872 37,372 Other Services & Charges 51,296 58,849 228,985 141,932 128,432 Waste water disposal 1,026,404 1,025,642 1,082,913 1,146,734 1,238,780 Depreciation 113,690 122,346 111,520 125,000 120,000 Total expenses 1,634,356 1,635,599 1,933,490.99 1,939,435 2,083,322 Operating income (loss) 195,485 228,474 23,753 74,305 28,484 Nonoperating revenues (expenses): Special assessments 594 6,319 13,273 - 4,000 Investment earnings 39,503 (12,515) (110,711) 20,000 20,000 Intergovernmental revenue 586 407 1,431 - - Connection/SAC charges 36,300 47,660 36,200 - - Contingency - - - (15,000) (15,000) Total nonoperating revenues (expenses)76,983 41,871 (59,806.86) 5,000 9,000 Net income (loss) before contributions and transfers 272,468 270,345 (36,054) 79,305 37,484 Transfers in (out): General Fund (82,859) (85,345) (87,905) (90,542) (93,258) Vehicle & Equipment Replacement (55,000) (55,000) (55,000) (52,000) (60,000) Change in net assets 134,609 130,000 (178,959) (63,237) (115,774) Net assets - January 1 4,310,139 4,444,748 4,574,748 4,395,789 4,332,552 Net assets - December 31 4,444,748 4,574,748 4,395,789 4,332,552 4,216,778 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Net income (loss) before contributions and transfers 272,468 270,345 (36,054) 79,305 37,484 Add depreciation 113,690 122,346 111,520 125,000 120,000 Change in current assets (37,316) (100,605) (37,158) - - Change in current liabilities 126,672 44,769 (64,381) - - Purchase of fixed assets (109,958) (480,150) (27,822) (1,055,000) (530,000) Transfers in (out) (137,859) (140,345) (142,905) (142,542) (153,258) Net increase (decrease) in cash 227,698 (283,639) (196,800) (993,237) (525,774) Cash balance - January 1 2,296,408 2,524,106 2,240,466 2,043,666 1,050,429 Cash balance - December 31 2,524,106 2,240,466 2,043,666 1,050,429 524,655 STATEMENT OF CASH FLOWS CITY OF MOUNDS VIEW SEWER FUND (730) STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS 101 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 730-4820-0100 Regular Salaries 45,906.85 49,825.81 52,688.94 53,699 59,340 5,641 10.5% 730-4820-0150 Part Time Salaries - - - 2,250 2,460 210 9.3% 730-4820-0300 Social Security 3,332.71 3,466.55 3,651.43 4,280 4,670 390 9.1% 730-4820-0321 PERA Employer 2,921.91 3,035.17 3,255.43 4,198 3,930 (268) -6.4% 730-4820-0322 Pension Expense (2,108.00) (27,108.00) 23,124.00 - - - 0.0% 730-4820-0400 Health Employer 6,851.85 6,880.48 7,214.83 7,047 8,640 1,593 22.6% 730-4820-0410 Life Employer 445.20 445.20 458.28 - - - 0.0% 730-4820-0420 Dental Employer 162.72 162.72 172.01 - - - 0.0% 730-4820-0500 Workers Comp Ins Premiums 298.88 281.36 313.52 428 490 62 14.5% 730-4823-0100 Regular Salaries 245,524.02 251,794.18 249,301.44 256,690 295,380 38,690 15.1% 730-4823-0110 Overtime 6,812.52 11,629.10 14,712.33 9,532 9,530 (2) 0.0% 730-4823-0150 Part Time Salaries 4,081.87 - 963.89 20,085 21,530 1,445 7.2% 730-4823-0300 Social Security 18,422.12 18,799.55 19,436.75 21,902 24,970 3,068 14.0% 730-4823-0321 PERA Employer 18,505.76 18,707.04 19,498.94 20,811 23,750 2,939 14.1% 730-4823-0400 Health Employer 36,494.83 35,975.41 38,421.16 49,041 56,920 7,879 16.1% 730-4823-0410 Life Employer 415.03 432.35 346.37 - - - 0.0% 730-4823-0420 Dental Employer 1,918.96 1,704.96 1,354.59 - - - 0.0% 730-4823-0500 Workers Comp Ins Premiums 13,565.80 11,128.62 12,734.90 15,021 18,360 3,339 22.2% Personnel Expenses 403,553.03 387,160.50 447,648.81 464,984 529,970 64,986 14.0% 730-4820-1600 Operating Supplies - - 81.08 50 50 - 0.0% 730-4823-1210 Supplies - Bldgs & Grounds 132.72 490.98 406.38 200 200 - 0.0% 730-4823-1220 Supplies - Vehicles 4,072.15 4,540.93 7,199.25 5,000 5,000 - 0.0% 730-4823-1230 Supplies - Equipment 2,712.90 5,204.68 4,927.70 6,350 8,350 2,000 31.5% 730-4823-1240 Supplies - Streets - - 1,545.00 2,000 2,000 - 0.0% 730-4823-1250 Supplies - Utilities 508.57 1,208.77 993.99 2,900 2,900 - 0.0% 730-4823-1260 Supplies - Traffic Control 132.73 - - 300 300 - 0.0% 730-4823-1600 Operating Supplies 4,785.39 4,523.15 22,349.42 8,850 9,350 500 5.6% 730-4823-1700 Motor Fuels & Lubricants 2,884.49 3,368.18 4,578.10 6,375 6,375 - 0.0% 730-4823-2400 Uniforms & Clothing 1,754.57 2,756.39 2,121.51 2,169 2,169 - 0.0% 730-4823-2410 Maint - Mats, Towels 941.51 844.27 706.11 728 728 - 0.0% Supplies and Materials 17,925.03 22,937.35 44,908.54 34,922 37,422 2,500 7.2% 730-4820-3030 Other Professional Services 8,616.28 8,682.81 8,735.61 8,856 9,034 178 2.0% 730-4820-3300 Postage 3,174.33 2,479.28 2,596.85 4,600 4,600 - 0.0% 730-4820-3430 Printing 4,797.83 1,141.46 380.55 900 900 - 0.0% 730-4820-3630 Training & Conferences - - - 2,400 2,400 - 0.0% 730-4820-5130 Repairs - Equipment 4,899.17 6,360.13 5,802.12 9,107 11,784 2,677 29.4% 730-4823-3030 Other Professional Services 21,921.69 8,817.48 8,977.90 41,456 45,456 4,000 9.6% 730-4823-3100 Telephone 3,128.87 2,423.71 2,478.29 2,906 2,906 - 0.0% 730-4823-3200 Water & Sewer 4,383.82 4,531.89 4,507.50 4,000 4,000 - 0.0% 730-4823-3210 Electricity 2,357.35 3,339.66 4,083.16 2,500 2,500 - 0.0% 730-4823-3230 Waste Water Disposal 1,026,404.08 1,025,642.40 1,082,913.48 1,146,734 1,238,780 92,046 8.0% 730-4823-3231 Waste Water Charges - 2,388.49 573.95 4,000 4,000 - 0.0% 730-4823-3610 Memberships 150.00 150.00 150.00 1,690 1,690 - 0.0% 730-4823-3630 Training & Conferences 860.96 3,613.87 4,128.11 7,530 7,530 - 0.0% 730-4823-4010 Rental - Equipment - - - 500 500 - 0.0% 730-4823-4800 Insurance & Bonds 6,129.46 6,418.34 30,951.82 7,300 7,300 - 0.0% 730-4823-5130 Repairs - Equipment 7,237.08 10,237.81 46,177.49 12,550 15,050 2,500 19.9% 730-4823-5140 Repairs - Streets - - 5,000.00 10,000 10,000 - 0.0% 730-4823-5150 Repairs - Utility - 15,698.70 95,468.38 37,500 17,500 (20,000) -53.3% 730-4823-5160 Repairs - System Maint 5,126.80 1,229.22 6,763.89 10,000 10,000 - 0.0% 730-4823-7950 Depreciation 113,690.33 122,346.02 111,519.54 125,000 120,000 (5,000) -4.0% Other Services and Charges 1,212,878.05 1,225,501.27 1,421,208.64 1,439,529 1,515,930 76,401 5.3% 730-4823-7030 Equipment - - - 25,000 - (25,000) -100.0% 730-4823-7050 Construction Contract 0.02 - - 1,030,000 530,000 (500,000) -48.5% 730-4820-9100 Contingency - - 19,725.00 - - - 0.0% 730-4823-9100 Contingency - - - 15,000 15,000 - 0.0% Capital Expenditures 0.02 - 19,725.00 1,070,000 545,000 (525,000) -49.1% 730-4820-9900 Transfers Out 137,859.00 140,345.00 142,905.00 142,542 153,258 10,716 7.5% Transfers 137,859.00 140,345.00 142,905.00 142,542 153,258 10,716 7.5% 730 Sanitary Sewer Utility Fund 1,772,215.13 1,775,944.12 2,076,395.99 3,151,977 2,781,580 (370,397) -11.8% 102 Fund: 730 Department: 4820 Billing Services ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1600 Supplies, operating - - 81 50 50 Utility billing supplies 3030 Other professional services 8,616 8,683 8,736 8,856 9,034 24.5% of audit (23-36,145, 24-36,870, 25-37,605, 26-38,360) 3300 Postage 3,300 3,300 3300 bills X $0.50 postage X 4 billings X 1/2 cost 800 800 Inserting & mailing bills (moved from 3030) 500 500 Late notices: 500 bills X $0.50 postage X 4 billings X 1/2 cost 3,174 2,479 2,597 4,600 4,600 3430 Printing 450 450 Envelopes 450 450 Utility bills (1/2 cost) 4,798 1,141 381 900 900 3630 Training - - - 2,400 2,400 Seminars on new regulations, software updates, etc. INCODE training 5130 Repairs, equipment 5,183 5,784 Incode software support (30%)(5% annual increase per agreement) 1,200 1,200 Incode UB support - 3,000 Mueller/Incode CIS interface and support 350 - Neptune reader maintenance (1/2 in water)(2019 first year $610) 1,800 1,800 Mueller software maintenance (1/2 in water) 574 - Handheld interface support meter readers (50% water 50% sewer)(Incode) 4,899 6,360 5,802 9,107 11,784 7030 Capital, equipment - - - - - Meter reader (1/2 water 1/2 sewer) 9100 Contingency - - 19,725 - - 9900 Transfers out 85,345 85,345 87,905 90,542 93,258 Transfer to General Fund for admin costs 55,000 55,000 55,000 52,000 60,000 Transfer to Vehicle & Equipment Fund for vehicle use 137,859 140,345 142,905 142,542 153,258 159,347 159,009 180,226 168,455 182,026 103 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1210 Supplies, bldgs & grounds 100 100 Paint, bulbs, fuses, etc 100 100 Seed, dirt, sod, etc 133 491 406 200 200 1220 Supplies, vehicles 75 75 Air, oil, fuel & transmission filters 925 925 Fluids 2,500 2,500 Repair & replacement parts 1,500 1,500 Tires & batteries 4,072 4,541 7,199 5,000 5,000 1230 Supplies, equipment < $5000 650 650 Tune up parts 500 500 Hydraulic fluids & hoses 200 200 Cutting edges (skid loader) 300 300 Misc. replacement & repair parts 300 300 Light equip misc replacement & repair parts 2,000 4,000 Camera track and parts (CCTV) 300 300 Minor repairs 100 100 Gas detection device parts and supplies 2,000 2,000 Vactor cleaning nozzle parts and supplies (nozzle 2017, hose 2018) 2,713 5,205 4,928 6,350 8,350 1240 Supplies, streets 200 200 Tack coat 300 300 Dewatering rock/agg. base 1,500 1,500 Asphalt mix - - 1,545 2,000 2,000 1250 Supplies, utilities 1,500 1,500 Replacement pumps & motors 100 100 Filters, packings, relays, etc 300 300 Speed crete (mortar) 700 700 Repair parts - - Portable flow meter 300 300 Manhole covers, adjust rings & bolts 509 1,209 994 2,900 2,900 1260 Supplies, traffic control 133 - - 300 300 Traffic cones, work zone sign face, safety vests 1600 Supplies, operating 500 500 Additional & replacement hand tools 250 250 Glove & paper products 150 150 Disinfectant supplies 500 1,000 Camera supplies 1,500 1,500 First aid supplies, protective equip (add hearing equipment for 2017) 200 200 CD's, DVD's, software 250 250 Engineering supplies 700 700 Shop supplies, fastners, soap, degreasers, steet, batteries 500 500 Pipe, fittings, and accessories (connectors) 500 500 Locating supplies (paint, flags, markers, etc.) 3,500 3,500 Chemical blocks for lift stations 300 300 Filter replacement for sewer gas monitors 4,785 4,523 22,349 8,850 9,350 1700 Motor fuels & lubs 300 300 Fluids 600 600 Motor oil - 100 gallons $6 gal. 1,875 1,875 Unleaded fuel 500 gallons @ $3.75 3,600 3,600 Diesel fuel 800 gallons @ $4.50 2,884 3,368 4,578 6,375 6,375 2400 Uniforms 1,755 2,756 2,122 2,169 2,169 Uniforms 18.2% of $9,995 and clothing 2.0 FTE x $175 per contract 2410 Mats & towels 942 844 706 728 728 Share of floor mats & shop towels (18.2% of $4,000) 3030 Other professional services 750 750 Gopher State One Call locates 600 600 Consulting engineering services - annual lift station inspections 100 100 Fire extinguisher inspection/servcie (5 @ $20) 15,000 15,000 Engineering study sewer line Silver Lake Rd 450 450 Copier maintenance agreement (Split with 700) 1,106 1,106 Annual generator service/inspection 1,000 1,000 Asset management software - 4,000 Permit module BS&A (in Water, Sewer, & Storm Water) 3,000 3,000 Arcview/GIS base map and engineering consulting (split with 700) 2,750 2,750 Safety Data Service (1/3 Water, 1/3 Storm Water) 16,700 16,700 Sewer I&I monitoring 21,922 8,817 8,978 41,456 45,456 3039 Collection expense - - - Estimated collection expense 3100 Communications - telephone 2,335 2,335 Cellular phone service 481 481 Data cards for SCADA (4)(25%) bal. in Water (40.01 per card per month) 90 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 3,129 2,424 2,478 2,906 2,906 3200 Water & Sewer service 4,384 4,532 4,508 4,000 4,000 Estimated annual charge 3210 Electricity 2,357 3,340 4,083 2,500 2,500 Electricity for lift stations 104 Fund: 730 Department: 4823 Wastewater Infrastructure & Equipment Maintenance (continued) ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 3230 Met Council Environ. Servies MCES 1,026,404 1,025,642 1,082,913 1,146,734 1,238,780 Annual charge (increase 5.89% 2023, 5.58% increase in 2022) 3231 MCES Strength charges - 2,388 574 4,000 4,000 Strength Charge 3610 Memberships 120 120 MN Rural Water Assoc. (50%) - - American Public Works Association (APWA)(25% of $600) 1,400 1,400 Wincam membership 70 70 Suburban Utility Superintendant Association (SUSA)(50% of $100) 100 100 MN Safety Council (20%) 150 150 150 1,690 1,690 3630 Training 1,500 2,000 Collection operators training/renewal ($300 per person) 400 800 Tuition reimbursement (PW Mgt. Class - North Hennepin CC) 150 150 Computer training/webinars 110 110 Hearing test/R2K (2.15 FTE * $50) - - License renewal 900 900 Confined space/trench safety alternate years) - - Trench safety training - - Wastewater collection operators recertification seminar - - Low voltage license - - Metro school - - Pesticide applicators license 2,100 1,200 DACP Training 1,200 1,200 Class A license 750 750 Miscellaneous wastewater training (certified pipe inspector) 60 60 Maintenance Expo 300 300 Equipment operator training - - APWA MN conference 60 60 Work zone safety seminar (every 3 years next 2020) 861 3,614 4,128 7,530 7,530 4010 Rental, equipment - - - 500 500 Barricades & signs 4800 Insurance 6,129 6,418 30,952 7,300 7,300 Share of property/liability insurance 5130 Repairs, equipment 8,000 8,000 Repairs to Vactor (jet truck) 2,500 5,000 Repairs to camera van and camera equipment 1,000 1,000 Repairs to utility truck 1,050 1,050 Misc repairs 7,237 10,238 46,177 12,550 15,050 5140 Repairs, streets - - 5,000 10,000 10,000 Contractor restoration of pavement, bwd., etc... 5150 Repairs, utilities 2,500 2,500 Lift station repairs 20,000 - Groveland grinder 15,000 15,000 Sanitary collection system repairs - 15,699 95,468 37,500 17,500 5155 Utility service repairs - - - - - Service line repairs 5160 System maintenance 4,000 4,000 Root control - - Contractor restoration of pavement, bwd., etc... 4,000 4,000 Lift station maintenance/cleaning/pump service 2,000 2,000 Sewer debris disposal costs 5,127 1,229 6,764 10,000 10,000 7030 Capital, equipment > $5000 - - - 25,000 - Elevator for sewer camera trolly 7050 Construction > $25000 1,000,000 500,000 Sewer pipe relining program (2022 deferred to 2023) 30,000 30,000 Manhole lining - - Upgrade Bronson lift station and nat gas generator (carryover from 2019) 0 - - 1,030,000 530,000 7950 Depreciation 113,690 122,346 111,520 125,000 120,000 Estimated depreciation 9100 Contingency - - - 15,000 15,000 Contingency - may include lift station impeller replacement at Bronson 9900 Transfer out - - - - - Sewer system upgrades in conjunction with major roadway program 1,209,315 1,229,775 1,448,521 2,518,538 2,069,584 Total Sewer 1,368,662 1,388,784 1,628,747 2,686,993 2,251,610 1.47% 17.28% 64.97% -16.20% 105 THIS PAGE LEFT BLANK INTENTIONALLY 106 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Operating revenues: Street light charges 103,917 104,207 104,182 104,412 116,014 Other charges 492 864 997 700 800 Total revenues 104,410 105,071 105,179.17 105,112 116,814 Operating expenses: Personnel services 14,369 13,864 14,767 14,502 26,040 Materials & Supplies - 855 - 1,000 1,000 Other Services & Charges 90,302 80,991 101,194 86,350 101,850 Lease interest 3,232 - - - - Total expenses 107,903 95,710 115,960.98 101,852 128,890 Operating income (loss)(3,494) 9,362 (10,782) 3,260 (12,076) Nonoperating revenues (expenses): Investment earnings 2,269 (846) (4,402) 1,400 1,400 Total nonoperating revenues (expenses) 2,269 (846) (4,401.63) 1,400 1,400 Net income (loss) before contributions and transfers (1,224) 8,516 (15,183) 4,660 (10,676) Transfers in (out): General Fund (2,940) (3,028) (3,119) (3,213) (3,309) Change in net assets (4,164) 5,488 (18,302) 1,447 (13,985) Net assets - January 1 108,468 104,304 109,792 91,489 92,936 Net assets - December 31 104,304 109,792 91,489 92,936 78,951 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Net income (loss) before contributions and transfers (1,224) 8,516 (15,183) 4,660 (10,676) Change in current assets (318) 699 (1,001) - - Change in current liabilities (59,642) 419 613 - - Transfers in (out) (2,940) (3,028) (3,119) (3,213) (3,309) Net increase (decrease) in cash (64,124) 6,606 (18,691) 1,447 (13,985) Cash balance - January 1 141,973 77,849 84,456 65,765 67,212 Cash balance - December 31 77,849 84,456 65,765 67,212 53,227 STATEMENT OF CASH FLOWS CITY OF MOUNDS VIEW STREET LIGHTING FUND (740) STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS 107 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 740-4416-0100 Regular Salaries 10,555.86 10,298.39 10,486.20 11,208 19,060 7,852 70.1% 740-4416-0110 Overtime Salaries 467.18 233.77 598.87 - - - 0.0% 740-4416-0300 Social Security 740.34 730.99 798.54 857 1,460 603 70.4% 740-4416-0321 PERA Employer 753.79 745.39 823.80 754 1,430 676 89.7% 740-4416-0400 Health Employer 1,406.80 1,461.01 1,589.93 1,287 3,560 2,273 176.6% 740-4416-0410 Life Employer 111.94 110.20 108.76 - - - 0.0% 740-4416-0420 Dental Employer 60.07 37.32 65.07 - - - 0.0% 740-4416-0500 Workers Comp Ins Premiums 273.48 246.47 296.20 396 530 134 33.8% Personnel Expenses 14,369.46 13,863.54 14,767.37 14,502 26,040 11,538 79.6% 740-4416-1600 Operating Supplies - 854.97 - 1,000 1,000 - 0.0% Supplies and Materials - 854.97 - 1,000 1,000 - 0.0% 740-4416-3210 Electricity 85,606.81 80,271.02 98,794.56 82,500 98,000 15,500 18.8% 740-4416-4800 Insurance & Bonds 755.68 720.02 711.82 900 900 - 0.0% 740-4416-5150 Repairs - Utility 1,508.36 - 1,687.23 2,950 2,950 - 0.0% 740-4416-5160 Repairs - System Maint 2,431.05 - - - - - 0.0% Other Services and Charges 90,301.90 80,991.04 101,193.61 86,350 101,850 15,500 18.0% 740-4416-8021 Lease Interest 3,232.13 - - - - - 0.0% Capital Expenditures 3,232.13 - - - - - 0.0% 740-4416-9900 Transfers Out 2,940.00 3,028.00 3,119.00 3,213 3,309 96 3.0% Transfers 2,940.00 3,028.00 3,119.00 3,213 3,309 96 3.0% 740 Street Lighting 110,843.49 98,737.55 119,079.98 105,065 132,199 27,134 25.8% 108 Fund: 740 Street Lighting Fund Fund: 740 Department: 4416 Operations ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1600 Supplies, operating - 855 - 1,000 1,000 Bulbs, ballasts, covers, etc... 3210 Electricity 85,607 80,271 98,795 82,500 98,000 Estimate 4800 Insurance 756 720 712 900 900 Share of property/liability insurance 5150 Repairs, utilities 1,508 - 1,687 2,950 2,950 Repairs to street and trail lighting. 5160 System maintenance 2,431 - - - - Repairs to street and trail lighting. 5170 Utility conversion costs - - - - - Conversion of street lights to Xcel ownership. 8011 Lease payable (principal)- - - - - Energy savings program (LED trail lighting) 8021 Lease payable (interest)3,232 - - - - Interest 9900 Transfer out 2,940 3,028 3,119 3,213 3,309 Transfer to General Fund for administrative overhead costs 96,474 84,874 104,313 90,563 106,159 -12.02% 22.90% -13.18% 17.22% 109 THIS PAGE LEFT BLANK INTENTIONALLY 110 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Operating revenues: Storm Water billings 340,809 368,302 394,308 400,500 446,969 Other charges 2,752 2,931 6,170 1,500 2,000 Total revenues 343,561 371,233 400,477.19 402,000 448,969 Operating expenses (4415): Personnel services 133,260 113,762 139,002 157,996 172,620 Materials & Supplies 14,054 15,332 13,245 13,392 13,642 Other Services & Charges 167,778 91,608 123,087 115,146 121,396 Depreciation 35,916 33,996 34,097 35,000 35,000 Operating expenses (4417): Personnel services 18,107 17,933 18,883 20,038 22,300 Materials & Supplies 5,752 15,553 17,386 12,522 12,522 Other Services & Charges - 164 - 14,280 24,280 Total expenses 374,867 288,349 345,700.42 368,374 401,760 Operating income (loss)(31,307) 82,884 54,777 33,626 47,209 Nonoperating revenues (expenses): Investment earnings 34,677 (11,189) (109,669) 16,000 16,000 Intergovernmental revenue 218 149 10,159 - - Total nonoperating revenues (expenses)34,895 (11,040) (99,509.76) 16,000 16,000 Net income (loss) before contributions and transfers 3,588 71,844 (44,733) 49,626 63,209 Transfers in (out): General Fund (8,558) (8,815) (9,079) (9,351) (9,632) Vehicle & Equipment Replacement (33,000) (33,000) (35,000) (33,000) (50,000) Vehicle & Equipment Replacement - - - 37,500 45,000 Change in net assets (37,970) 30,029 (88,812) 44,775 48,577 Net assets - January 1 3,307,673 3,269,704 3,299,733 3,210,921 3,255,696 Net assets - December 31 3,269,704 3,299,733 3,210,921 3,255,696 3,304,273 2023 2020 2021 2022 ORIGINAL BUDGET ACTUAL ACTUAL ACTUAL BUDGET 2024 Net income (loss) before contributions and transfers 3,588 71,844 (44,733) 49,626 63,209 Add depreciation 35,916 33,996 34,097 35,000 35,000 Change in current assets (8,503) (44,229) (5,768) - - Change in current liabilities (4,323) 25,308 4,171 - - Purchase of fixed assets 26,054 (14,456) - (262,500) (290,000) Transfers in (out) (41,558) (41,815) (44,079) (4,851) (14,632) Net increase (decrease) in cash 11,174 30,648 (56,312) (182,725) (206,423) Cash balance - January 1 2,006,378 2,017,552 2,048,200 1,991,887 1,809,162 Cash balance - December 31 2,017,552 2,048,200 1,991,887 1,809,162 1,602,739 STATEMENT OF CASH FLOWS CITY OF MOUNDS VIEW SURFACE WATER FUND (745) STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS 111 2024 Budget Summary Actual Actual Actual Budget Request $ % Acct No Description 2020 2021 2022 2023 2024 Change Change 745-4415-0100 Regular Salaries 97,585.48 96,292.52 103,535.00 106,752 127,950 21,198 19.9% 745-4415-0110 Overtime Salaries 3,354.69 1,618.92 3,986.05 1,524 1,590 66 4.3% 745-4415-0150 Part Time Salaries 4,560.00 4,440.00 - 14,817 3,970 (10,847) -73.2% 745-4415-0300 Social Security 7,665.86 7,634.73 7,958.98 9,416 10,170 754 8.0% 745-4415-0321 PERA Employer 6,761.83 6,581.44 7,290.81 8,964 9,150 186 2.1% 745-4415-0322 Pension Expense 4,495.00 (11,280.00) 7,037.00 - - - 0.0% 745-4415-0400 Health Employer 4,691.62 4,841.34 5,169.12 13,194 16,050 2,856 21.6% 745-4415-0410 Life Employer 730.21 661.59 647.24 - - - 0.0% 745-4415-0420 Dental Employer 894.54 888.84 864.64 - - - 0.0% 745-4415-0500 Workers Comp Ins Premiums 2,521.08 2,082.93 2,513.48 3,329 3,740 411 12.3% 745-4417-0100 Regular Salaries 13,829.98 14,054.53 14,554.26 14,091 15,230 1,139 8.1% 745-4417-0110 Overtime Salaries 707.50 372.09 642.87 1,524 1,590 66 4.3% 745-4417-0300 Social Security 1,080.19 1,072.75 1,124.07 1,195 1,290 95 7.9% 745-4417-0321 PERA Employer 1,063.57 1,027.61 1,094.28 1,171 1,260 89 7.6% 745-4417-0400 Health Employer 536.23 539.84 541.27 1,440 2,000 560 38.9% 745-4417-0410 Life Employer 228.24 227.71 224.21 - - - 0.0% 745-4417-0420 Dental Employer 146.31 162.65 184.58 - - - 0.0% 745-4417-0500 Workers Comp Ins Premiums 515.04 475.47 517.56 617 930 313 50.7% Personnel Expenses 151,367.37 131,694.96 157,885.42 178,034 194,920 16,886 9.5% 745-4415-1230 Supplies - Equipment 5,372.07 9,127.02 4,108.18 3,750 4,000 250 6.7% 745-4415-1240 Supplies - Streets - 227.71 - - - - 0.0% 745-4415-1600 Operating Supplies 6,007.26 2,817.54 4,824.58 5,425 5,425 - 0.0% 745-4415-1700 Motor Fuels & Lubricants 1,951.29 2,303.69 3,575.65 3,375 3,375 - 0.0% 745-4415-2400 Uniforms & Clothing 482.01 605.65 570.96 550 550 - 0.0% 745-4415-2410 Maint - Mats, Towels 241.50 250.73 165.78 292 292 - 0.0% 745-4417-1230 Supplies - Equipment - 7,367.27 8,754.86 3,500 3,500 - 0.0% 745-4417-1600 Operating Supplies 2,850.00 4,323.50 4,451.13 4,500 4,500 - 0.0% 745-4417-1700 Motor Fuels & Lubricants 2,775.90 3,654.99 3,536.37 4,300 4,300 - 0.0% 745-4417-2400 Uniforms & Clothing 69.90 141.35 588.95 150 150 - 0.0% 745-4417-2410 Maint - Mats, Towels 56.06 66.00 54.64 72 72 - 0.0% Supplies and Materials 19,805.99 30,885.45 30,631.10 25,914 26,164 250 1.0% 745-4415-3030 Other Professional Services 30,170.72 23,131.41 103,143.77 12,366 18,616 6,250 50.5% 745-4415-3100 Telephone 1,006.88 1,176.70 1,602.81 1,540 1,540 - 0.0% 745-4415-3610 Memberships 1,055.00 1,080.00 325.00 1,045 1,045 - 0.0% 745-4415-3630 Training & Conferences 161.00 716.00 2,903.44 1,695 1,695 - 0.0% 745-4415-4010 Rental - Equipment 5,164.99 2,860.00 3,668.50 3,000 3,000 - 0.0% 745-4415-4800 Insurance & Bonds 3,358.61 3,200.06 3,163.64 4,000 4,000 - 0.0% 745-4415-5120 Repairs - Vehicles 490.00 39.06 - 1,500 1,500 - 0.0% 745-4415-5150 Repairs - Utilities 90,461.03 59,405.00 8,280.20 90,000 90,000 - 0.0% 745-4415-7950 Depreciation 35,915.84 33,995.90 34,096.54 35,000 35,000 - 0.0% 745-4417-3530 Refuse Collection - - - 10,000 20,000 10,000 100.0% 745-4417-3630 Training & Conferences - 164.00 - 280 280 - 0.0% 745-4417-5130 Repairs - Equipment - - - 4,000 4,000 - 0.0% Other Services and Charges 167,784.07 125,768.13 157,183.90 164,426 180,676 16,250 9.9% 745-4415-7030 Equipment - - - 37,500 65,000 27,500 73.3% 745-4415-7050 Construction 35,909.92 - - 225,000 225,000 - 0.0% Capital Expenditures 35,909.92 - - 262,500 290,000 27,500 10.5% 745-4415-9900 Transfers Out 8,558.00 8,815.00 9,079.00 9,351 9,632 281 3.0% 745-4417-9900 Transfers Out 33,000.00 33,000.00 35,000.00 33,000 50,000 17,000 51.5% Transfers 41,558.00 41,815.00 44,079.00 42,351 59,632 17,281 40.8% 745 Surface Water Management Fund 416,425.35 330,163.54 389,779.42 673,225 751,392 78,167 11.6% 112 Fund: 745 Storm Water Revenues Fund: 745 Department: 4415 System Maintenance ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1230 Supplies, equipment < $5000 2,000 2,000 Miscellaneous equipment & parts (AEBI parts, pole camera parts) 1,500 1,500 Filters, brakes, bulbs, wipers, tires, batteries, etc... - - Leveling bar for skidsteer - - Winch for pick-up truck - - Tommy gate fro pick-up truck - - Truck springs 250 500 Hoses & nozzles 5,372 9,127 4,108 3,750 4,000 1240 Supplies, streets - 228 - - - Bituminous mix 1600 Supplies, operating 450 450 Concrete 2,500 2,500 Rain Garden mix, riprap, topsoil, seed and sod 175 175 Concrete adjustment rings 150 150 Hand tools 150 150 CD's, DVD's, software upgrade for camera van 2,000 2,000 Catch basin castings, pipe, approns, etc... 6,007 2,818 4,825 5,425 5,425 1700 Motor fuels 1,951 2,304 3,576 3,375 3,375 900 gallons unleaded @ $3.75 for utility truck 2100 Books/Periodicals - - - - - Storm water books/periodicals 2400 Uniforms 482 606 571 550 550 Uniforms/clothing (7.3% of $4,500, .8 FTE x $175 per contract) 2410 Mats & towels 242 251 166 292 292 Share of floor mats & shop towels (7.3% of $4,000) 3030 Other professional services 5,750 8,000 Consulting engineers (LGU) - - Storm water system maintenance study 1,500 1,500 Arcview/GIS base map consulting - - FEMA Study - - Silverview pond sediment removal 1,000 1,000 Asset management software - 4,000 Permit module BS&A (in Water, Sewer, & Storm Water) 100 100 Fire extinguisher inspection/servcie (5 @ $20) 1,266 1,266 3.5% of audit (23-36,145, 24-36,870, 25-37,605, 26-38,360) 2,750 2,750 Safety Data Service (1/3 Water, 1/3 Sewer) - - Surface Water Management Plan - - Map development and plan updates & reviews - - Feasibility report - wetland Arden Ave and TH 10 or other area 30,171 23,131 103,144 12,366 18,616 3100 Communications 1,450 1,450 Cell Phone service 90 90 800 Mhz radio license fee (33%)(5 radios @ $4.48 per month) 1,007 1,177 1,603 1,540 1,540 3610 Memberships 200 200 American Public Works Association (APWA)(25% of $800) CPV Program 800 800 Minnesota Cities Storm Water Coalition 45 45 MN Safety Council 1,055 1,080 325 1,045 1,045 3630 Training 200 200 Seminars & training sessions (Stormwater) 55 55 Hearing test/R2K (1.1 FTE * $50) - - Wastewater class/exam 350 350 Safety training 500 500 NPDES compliance training - - Tuition reimbursement - - Public Education Fund - - Trench safety seminar - - Competent person training 270 270 Erosion & Stormwater Maint. Certification 220 220 Equipment operator training 100 100 Computer/webinar training 161 716 2,903 1,695 1,695 4010 Equipment rental 5,165 2,860 3,669 3,000 3,000 Rent mini excavater for clean-outs 4800 Insurance 2,500 2,500 Share of property/liability insurance 1,500 1,500 Deductible 3,359 3,200 3,164 4,000 4,000 5120 Repairs, vehicles 490 39 - 1,500 1,500 Utility truck & equipment repairs (need price sweeper box replacement) 5150 Repairs & maint., utilities 30,000 30,000 Repair & maintain storm sewers, ponds, basins, and drainage issues 30,000 30,000 Storm sewer cleaning 30,000 30,000 Storm Sewer slip linning improvements 90,461 59,405 8,280 90,000 90,000 113 Fund: 745 Department: 4415 System Maintenance 7030 Equipment > $5000 - - Silverview pond aerators - 5,000 Rough cut mower deck for skidsteer - 15,000 Stump grinder attachment for skidsteer - 45,000 Pickup F250 37,500 - T76 T4 Compact Track Loader (skidsteer)(1/2 in Water) - - Small generator for trailer - - Concrete mixer - - Trailer for backhoe - - Camera Cable (Sewer & Storm Water) - - Flail mower for AEBI - - Salt Brine maker - - Electronic rain gauges for SCADA (33%)(total cost $8,250) - - - 37,500 65,000 7050 Construction > $25000 35,910 - - 225,000 225,000 Storm water projects 7950 Depreciation 35,916 33,996 34,097 35,000 35,000 Estimated depreciation 9900 Transfer out 8,558 8,815 9,079 9,351 9,632 General Fund 226,306 149,751 179,508 435,389 469,670 Fund: 745 Department: 4417 Street Cleaning ACTUAL ACTUAL ACTUAL BUDGET BUDGET Account Description 2020 2021 2022 2023 2024 Description 1230 Supplies, equipment < $5000 - 7,367 8,755 3,500 3,500 Misc. sweeper repairs - belts, pumps, hoses, filters, etc. 1600 Supplies, operating 2,600 2,600 Gutter brooms 1,000 1,000 Belts, pumps, hoses, filters, etc... for sweeper 150 150 Gloves, hearing protection, etc... 750 750 2 dirt shoes 2,850 4,324 4,451 4,500 4,500 1700 Motor fuels 3,300 3,300 Diesel fuel - 1000 gallons @ $3.30 1,000 1,000 Hydraulic oil - 4 changes 2,776 3,655 3,536 4,300 4,300 2400 Uniforms 70 141 589 150 150 Uniforms/clothing (1.8% of $4,500, .2 FTE x $175 per contract) 2410 Mats & towels 56 66 55 72 72 Share of floor mats & shop towels (1.8% of $4,000) 3530 Disposal - - - 10,000 20,000 Sweeping pile disposal (estimated 5 year project) 3630 Training 250 250 NPDES compliance training - - Minnesota Public Works Assoc. conference - - American Public Works Assoc. MN conference 30 30 Maintenance Expo - - MSSA operator training sessions. - - Sweeper operator seminar - 164 - 280 280 5130 Repairs, equipment - - - 4,000 4,000 Sweeper repairs 7030 Equipment > $5000 - - - - - Street sweeper (250,000 - trade-in of 40,000) 9900 Transfer out to Vehicle & Equip 33,000 33,000 35,000 33,000 50,000 Transfer to Vehicle & Equip Fund for future replacements 38,752 48,717 52,386 59,802 86,802 Total Surface Water 265,058 198,469 231,894 495,191 556,472 -25.12% 16.84% 113.54% 12.38% 114