Loading...
4/1/2024 - City Council - Regular - Agendas* The Consent Agenda lists those items of business which are routine, recommended for approval, and/or need no discussion. The several separate items listed on the Consent Agenda are acted upon by one motion. There will be no separate discussion of these items unless a Council Member makes a request, in which event the item will be removed from the Consent Agenda and placed elsewhere on the regular agenda for Council discussion and action. ** Under Public Comment, individuals may address the City Council about any item not contained on the regular agenda. Each speaker should keep their statements to three minutes to allow sufficient time for others. The Council will take no official action on items disc ussed at the forum, except for referral to staff for future report. CITY OF SPRING PARK CITY COUNCIL AGENDA APRIL 1, 2024 – 6:30 PM SPRING PARK CITY HALL 1. CALL TO ORDER 2. PLEDGE OF ALLEGIANCE 3. APPROVAL OF AGENDA 4. PUBLIC COMMENT** Those wishing to speak must state their name and address for the record. Each person will have three (3) minutes to make their remarks. Speakers will address all comments to the City Council as a whole and not one individual councilmember. The Council will not take official action on any item presented during the Public Comment period. If appropriate, the Council will refer items discussed to the City Administrator for follow-up. 5. REQUESTS & PRESENTATIONS 2023 Audit Presentation - ADBO 6. CONSENT AGENDA* a. Minutes – March 25, 2024 – Special Meeting b. Approval of Expenditure and Financial Reports c. Approval of Nuvei Proposal (Customer Payment Portal) 7. ACTION AGENDA a. None 8. REPORTS a. Mayor & Council b. Staff i. Spring Clean Up Day – May 11th. 9. ANNOUNCEMENTS/MISCELLANEOUS (INFORMATION ONLY) a. April 10, 2024 – Planning Commission Meeting – Public Hearing - 6:00PM b. April 15, 2024 – Regular City Council Meeting – 6:30PM c. April 15, 2024 – Work Session Meeting – 5:30PM d. May 06, 2024 – Regular City Council Meeting – 6:30PM 10. ADJOURNMENT City of Spring Park 2023 Financial Statement Audit Introduction •Audit Results •General Fund •Other Governmental Funds •Enterprise Funds •Key Performance Indicators 2 Unmodified Opinion 3 Audit Results Minnesota Legal ComplianceAuditor’s Opinion No instances of noncompliance noted Audit Results 2023 Audit Findings •Limited Segregation of Duties •Internal Control Finding •Financial Reporting •Internal Control Finding 4 Auditor Recommendations •Evaluate the current procedures and segregate duties where possible •Implement any compensating controls 5 6 General Fund - Fund Balances 60.00% 48.90%51.00%37.20% 26.40% $1,325,801 $1,386,770 $1,348,960 $1,672,485 $1,848,715 60%60% 60% 60% $- $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 $1,400,000 $1,600,000 $1,800,000 $2,000,000 2019 2020 2021 2022 2023 2024 Unassigned Fund Balance Budget Minimum Fund Balance Policy 7 General Fund Budget to Actual Final Budgeted Actual Variance with Amounts Amounts Final Budget Revenues 1,337,185$ 1,334,125$ (3,060)$ Expenditures 1,672,485 1,431,118 241,367 Net Change in Fund Balances (335,300) (96,993) 238,307 Fund Balances, January 1 660,874 660,874 - Fund Balances, December 31 325,574$ 563,881$ 238,307$ 8 General Fund Revenues by Type $- $200,000 $400,000 $600,000 $800,000 $1,000,000 $1,200,000 Taxes Licenses and Permits Intergovernmental Other 2021 2022 2023 9 General Fund Expenditures by Type $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 General Government Public Safety Public Works Other 2021 2022 2023 10 Special Revenue Fund Balances $(60,000) $(40,000) $(20,000) $- $20,000 $40,000 $60,000 $80,000 $100,000 TIF Lakeview Lofts TIF Presbeterian Homes 2021 2022 2023 11 Capital Projects Fund Balances $(300,000) $(250,000) $(200,000) $(150,000) $(100,000) $(50,000) $- Capital Project Fund 2021 2022 2023 12 Debt Service Funds $- $20,000 $40,000 $60,000 $80,000 $100,000 $120,000 $140,000 $160,000 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Principal Interest Maturity Total Total Remaining Date Cash Assets Bonds 2010A G.O. Bonds 2/1/26 30,516$ 30,516$ 30,000$ 2015A G.O. Bonds 2/1/30 98,467 98,467 313,750 2022A G.O. Bonds 2/1/38 13,685 13,685 265,000 Total 142,668$ 142,668$ 608,750$ Total Remaining Interest Payments 82,505$ Debt Description December 31, 2023 13 Water Fund Cash Flows from Operations and Cash Balances $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 $350,000 $400,000 $450,000 $500,000 2020 2020 2021 2021 2022 2022 2023 2023 Operating Costs Debt Payments Operating Receipts $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 2020 2021 2022 2023 Cash from Bond Issuance Unrestricted Minimum Target Balance (Following Year Debt Service Plus 50% of Operating Costs) 14 Sewer Fund Cash Flows from Operations and Cash Balances $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 2020 2020 2021 2021 2022 2022 2023 2023 Operating Costs Debt Payments Operating Receipts $(200,000) $- $200,000 $400,000 $600,000 $800,000 $1,000,000 2020 2021 2022 2023 Cash from Bond Issuance Unrestricted Minimum Target Balance (Following Year Debt Service Plus 50% of Operating Costs) 15 Cash and Investments Balances by Fund Type $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 $4,000,000 $4,500,000 2021 2022 2023 General Fund Capital Projects Funds Special Revenue Funds Debt Service Funds Enterprise Funds 16 Taxes Key Performance Indicators 2020 2021 2022 2023 City of Spring Park 32.0% 30.1% 30.5% 29.2% Class 4 Cities 58.8% 57.6% Cities in Hennepin County 41.5% 40.1% 0.0% 10.0% 20.0% 30.0% 40.0% 50.0% 60.0% 70.0% Tax Rate 2020 2021 2022 2023 City of Spring Park $790 $828 $845 $860 Class 4 Cities $606 $630 Cities in Hennepin County $847 $878 $- $100 $200 $300 $400 $500 $600 $700 $800 $900 $1,000 Taxes per Capita 17 Debt Key Performance Indicators 2020 2021 2022 2023 City of Spring Park $943 $806 $1,984 $1,884 Class 4 Cities $2,150 $2,198 Cities in Hennepin County $1,803 $1,817 $- $500 $1,000 $1,500 $2,000 $2,500 Debt per Capita 18 Expenditures Key Performance Indicators 2020 2021 2022 2023 City of Spring Park $798 $812 $908 $910 Class 4 Cities $839 $856 Cities in Hennepin County $913 $929 $- $100 $200 $300 $400 $500 $600 $700 $800 $900 $1,000 Current Expenditure per Capita 19 Your Abdo Team Andy Berg, CPA Partner bonnie.schwieger@abdosolutions.com Jill Knutson, CPA andrew.berg@abdosolutions.com Senior Associate jill.knutson@abdosolutions.com Mathato MakhayeBonnie Schwieger, CPA Senior Associate mathato.makhaye@abdosolutions.com Dave Abriol Partner Associate dave.abriol@abdosolutions.com Jack Pemble Intern jack.pemble@abdosolutions.com All meetings of the Spring Park City Council are video recorded and available for viewing online at www.ci.spring-park.mn.us or Spring Park | Lake Minnetonka Cable Commission (lmcc-tv.org). Meeting minutes are intended to be a general synopsis of the meetings of the City Council. More detail regarding discussions and policy considerations is provided by watching the recording of the meeting. CITY OF SPRING PARK CITY COUNCIL MINUTES SPECIAL MEETING MARCH 25, 2024 5:30 PM SPRING PARK CITY HALL The Spring Park City Council has called for a Special Meeting on Monday, March 25 at 5:30 p.m. under Minn. Stat. sec. 412.02, subd. 2a. The meeting will be held at City Hall, 4349 Warren Ave., in the Council Chambers to discuss the vacant seat of Office of the Mayor and discuss items from the March 18, 2024 meeting agenda that was previously cancelled. 1. CALL TO ORDER The meeting was called to order at 5:30 p.m. Council Present: Council Member’s Sippel, Hoffman, Chase and Horton were present. Council Member Hoffman was Acting Mayor. Staff Present: City Administrator Anderson, City Engineer Morast 2. PLEDGE OF ALLEGIANCE Acting Mayor Hoffman led the audience in the Pledge of Allegiance 3. APPROVAL OF AGENDA 4. Council Member Sippel motioned, being seconded by Council Member Horton, to approve the agenda as presented. On vote being taken, the motion was unanimously approved. 5. PUBLIC COMMENT** Those wishing to speak must state their name and address for the record. Each person will have three (3) minutes to make their remarks. Speakers will address all comments to the City Council as a whole and not one individual councilmember. The Council will not take official action on any item presented during the Public Comment period. 6. REQUESTS & PRESENTATIONS None 7. CONSENT AGENDA* a. Minutes, Regular City Council Meeting – March 4, 2024 b. Approval of Expenditures and YTD Budget Comparison: Revenue/Expenditures c. Resolution #24-09: Declaring Vacancy for the Office of the Mayor Council Member Chase motioned, being seconded by Council Member Horton, to approve the consent agenda as presented. On vote being taken, the motion was unanimously approved. 8. ACTION AGENDA a. Mayor Vacancy Memo to Council; City Council Vacancy Process b. Resolution #24-10: Appointing Mayor to fill the Unexpired Term Council Member Horton motioned, being seconded by Council Member Chase, to approve Resolution #24-10: Appointing Mayor to fill the Unexpired Term and appoint Acting Mayor Hoffman as Mayor to fulfill Jerome P. “Jerry” Rockvam’s All meetings of the Spring Park City Council are video recorded and available for viewing online at www.ci.spring-park.mn.us or Spring Park | Lake Minnetonka Cable Commission (lmcc-tv.org). Meeting minutes are intended to be a general synopsis of the meetings of the City Council. More detail regarding discussions and policy considerations is provided by watching the recording of the meeting. unexpired term ending 12/31/2024. On vote being taken, the motion was unanimously approved. In addition, City Administrator Anderson will be the attest signer for all Resolutions and Ordinances during the same unexpired term. c. Resolution #24-11: Declaring Vacancy of a Council Member The Council directed staff to post, publish, and accept applications for the Council vacancy. The Council will conduct interviews at the April 15, 2024 City Council Work Session. Council Member Hoffman motioned, being seconded by Council Member Chase, to approve Resolution #24-11; Declaring Vacancy of a Council Member and directing staff to move forward with accepting applications to fill the vacancy. On vote being taken, the motion was unanimously approved. d. Warren Ave Road Construction Approval City Engineer Morast reviewed the road design for Warren Avenue, Interlachen, and Kings Road. Council Member Chase would like the sidewalk to extend at some point either on Kings Road or on Interlachen to connect CR15 to Warren and Warren to the trail. Council requested the Engineer to include the sidewalk in the design now but will most likely move that part of the project to next year. Council Member Sippel motioned, being seconded by Council Member Chase, to instruct the City Engineer to move forward with the design work not to exceed $50K in engineering fees. On vote being taken, the motion was unanimously approved. 9. REPORTS a. Mayor & Council; i. Council Member Sippel stated he will not be at the April 1 or April 15 Council Meetings/Work Session. ii. Council Member Chase recapped the highlights from his meeting at the Police Commission. b. Staff: i. City Administrator Anderson stated the Spring clean-up is scheduled for May 11, 2024 and that a new security system was installed at City Hall with the public safety money received from the state. 10. ANNOUNCEMENTS/MISCELLANEOUS (INFORMATION ONLY) a. April 1, 2024 – Regular City Council Meeting – 6:30PM b. April 10, 2024 – Planning Commission Meeting and Public Hearing – 6:00PM c. April 15, 2024 – Regular City Council Meeting – 6:30PM d. April 15, 2024 – Council Work Session – 5:30PM 11. ADJOURNMENT There being no further discussion, Council Member Horton motioned, being seconded by Council Member Sippel, to adjourn the meeting at 7:31p.m. On vote being taken, the motion was unanimously approved. Respectfully submitted, Jamie Hoffman, City Clerk Batch: 040124PAY Page 1 03/29/24 9:37 AMCITY OF SPRING PARK *Check Detail Register© Amount CommentInvoiceCheck #Check Date Vendor Name 10100 Wells Fargo Bank NA 33714 03/29/24 ABDO LLP $2,000.00 Certified audit services for year ended 12/31/23Auditing Services 486040E 101-41500-301 $2,000.00 Certified audit services for year ended 12/31/23Auditing Services 486040E 601-49400-301 $2,000.00 Certified audit services for year ended 12/31/23Auditing Services 486040E 602-49450-301 $6,000.00Total 33715 03/29/24 CATALIS LLC $665.00 Annual Web Base Service from March 2024 - Feb. 2025 IT Technology Support INV30831493E 101-41500-330 $665.00 Annual Web Base Service from March 2024 - Feb. 2025 IT Technology Support INV30831493E 601-49400-330 $665.00 Annual Web Base Service from March 2024 - Feb. 2025 IT Technology Support INV30831493E 602-49450-330 $1,995.00Total 33716 03/29/24 ECM PUBLISHERS, INC. $57.13 Publish Public Hearings - April 10Legal Notices Publishing 990062E 101-41600-351 $57.13Total 33717 03/29/24 HAWKINS, INC. $30.00 Purchased Chemicals for WTPChemicals and Chem Pro 6708640E 601-49400-216 $644.19 Purchased Chemicals for WTPChemicals and Chem Pro 6713979E 601-49400-216 $674.19Total 33718 03/29/24 HENNEPIN COUNTY TREASURER $195.13 2024 Fee for Mailing Truth & Taxation NoticesContracted ServicesE 101-41550-310 $195.13Total 33719 03/29/24 LEAGUE OF MN CITIES INS TRUST $208.35 Annual Workers Comp.Premium 03/16/24-03/16/25Liability/Prop Ins/WCE 101-41900-361 $416.70 Annual Workers Comp.Premium 03/16/24-03/16/25Liability/Prop Ins/WCE 101-41500-361 $138.90 Annual Workers Comp.Premium 03/16/24-03/16/25Liability/Prop Ins/WCE 101-43100-361 $69.45 Annual Workers Comp.Premium 03/16/24-03/16/25Liability/Prop Ins/WCE 101-45200-361 $305.58 Annual Workers Comp.Premium 03/16/24-03/16/25Liability/Prop Ins/WCE 601-49400-361 $250.02 Annual Workers Comp.Premium 03/16/24-03/16/25Liability/Prop Ins/WCE 602-49450-361 $1,389.00Total 33720 03/29/24 LOFFLER COMPANIES, INC. $16.06 Copier Usage 02/22/24-03/21/24Office Equipment/Rental 4643292E 101-41500-413 $16.05 Copier Usage 02/22/24-03/21/24Office Equipment/Rental 4643292E 601-49400-413 $16.05 Copier Usage 02/22/24-03/21/24Office Equipment/Rental 4643292E 602-49450-413 $48.16Total 33721 03/29/24 MISSION COMMUNICATIONS LLC $563.40 2024 Alarm Monitoring System for WTPContracted Services 1085756E 601-49400-310 $563.40Total 33722 03/29/24 NORLINGS LAKE MTKA LANDSCAPE $9,645.00 2024 Spring tree trimmingLandscaping/Gardens/Mai 43042E 101-41940-432 $9,645.00Total Batch: 040124PAY Page 2 03/29/24 9:37 AMCITY OF SPRING PARK *Check Detail Register© Amount CommentInvoiceCheck #Check Date Vendor Name 33723 03/29/24 QUALITY CONTROL & INTEGR., INC $3,501.75 General Repairs on 03/12/24 to install new transducer at WTP & Emergency services on 03/10/24 Repairs/Maint General 46531E 601-49400-400 $3,501.75Total 33724 03/29/24 SAMBATEK, INC. $346.50 Engi. Fees - Black Lake Rd 02/04/24-03/02/24Black Lake Rd Feasibility 26224E 201-43100-529 $346.50Total 33725 03/29/24 UNICLEAN CLEANROOM SERVICES $122.37 Rug rental services 02/25/24-03/23/24Contracted Services 207056E 101-41500-310 $122.37Total 10100 Wells Fargo Bank NA $24,537.63 Fund Summary 10100 Wells Fargo Bank NA 101 GENERAL FUND $13,534.09 201 PUBLIC IMPROV REVOLVING FUND $346.50 601 WATER FUND $7,725.97 602 SEWER FUND $2,931.07 $24,537.63 *Check Summary Register© CITY OF SPRING PARK 03/29/24 9:36 AM Page 1 Batch: 040124PAY Name Check Date Check Amt 10100 Wells Fargo Bank NA 33714 ABDO LLP 3/29/2024 $6,000.00 Certified audit services for year ended 12/31/23 33715 CATALIS LLC 3/29/2024 $1,995.00 Annual Web Base Service from March 2024 - F 33716 ECM PUBLISHERS, INC.3/29/2024 $57.13 Publish Public Hearings - April 10 33717 HAWKINS, INC.3/29/2024 $674.19 Purchased Chemicals for WTP 33718 HENNEPIN COUNTY TREASURE 3/29/2024 $195.13 2024 Fee for Mailing Truth & Taxation Notices 33719 LEAGUE OF MN CITIES INS TRU 3/29/2024 $1,389.00 Annual Workers Comp.Premium 03/16/24-03/1 33720 LOFFLER COMPANIES, INC.3/29/2024 $48.16 Copier Usage 02/22/24-03/21/24 33721 MISSION COMMUNICATIONS LLC 3/29/2024 $563.40 2024 Alarm Monitoring System for WTP 33722 NORLINGS LAKE MTKA LANDSC 3/29/2024 $9,645.00 2024 Spring tree trimming 33723 QUALITY CONTROL & INTEGR., I 3/29/2024 $3,501.75 General Repairs on 03/12/24 to install new tran 33724 SAMBATEK, INC.3/29/2024 $346.50 Engi. Fees - Black Lake Rd 02/04/24-03/02/24 33725 UNICLEAN CLEANROOM SERVIC 3/29/2024 $122.37 Rug rental services 02/25/24-03/23/24 Total Checks $24,537.63 *Budget YTD Rev-Exp© 03/29/24 9:38 AM Page 1 Current Period: March 2024 CITY OF SPRING PARK 2024 March YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 Revenues Expenditures Gain/(Loss)$0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 Expenditure Active $0.00 $0.00 $0.00 0.00%$0.00 Total Expenditure $0.00 $0.00 $0.00 0.00%$0.00 $0.00Total $0.00 $0.00 0.00%$0.00 GENERAL FUND Revenues Expenditures Gain/(Loss)($184,732.00)($635,281.80)$450,549.80 343.89%($95,346.57) $1,663,983.00 -$114,833.60 $1,778,816.60 -6.90%$6,487.22 $1,848,715.00 $520,448.20 $1,328,266.80 28.15%$101,833.79 Revenue Active $1,479,483.00 ($102,313.96)$1,581,796.96 -6.92%$0.00R 101-31010 Current Ad Valorem T Active $20,000.00 ($16,279.87)$36,279.87 -81.40%$0.00R 101-31090 In Lieu of Taxes Active $1,000.00 $0.00 $1,000.00 0.00%$0.00R 101-32000 Dock Licenses Active $0.00 $0.00 $0.00 0.00%$0.00R 101-32105 Cigarette Permits Active $15,000.00 $0.00 $15,000.00 0.00%$0.00R 101-32110 Alchoholic Beverages Active $250.00 $0.00 $250.00 0.00%$0.00R 101-32120 Sign Permits Active $750.00 $1,400.00 ($650.00)186.67%$1,400.00R 101-32160 Garbage Haulers Active $2,500.00 $1,950.00 $550.00 78.00%$1,950.00R 101-32170 Special Events Active $10,000.00 $885.00 $9,115.00 8.85%$585.00R 101-32180 Other Licenses/Permit Active $35,000.00 $928.36 $34,071.64 2.65%$928.36R 101-32210 Building Permits Active $0.00 $265.01 ($265.01)0.00%$16.50R 101-32215 Building Permit - Surc Active $5,000.00 ($2,682.50)$7,682.50 -53.65%$0.00R 101-33100 Grants and Aids Active $0.00 $0.00 $0.00 0.00%$0.00R 101-33404 PERA Aid Active $1,500.00 $0.00 $1,500.00 0.00%$0.00R 101-33620 Recycling Active $1,000.00 $500.00 $500.00 50.00%$500.00R 101-34103 Variance/CUP Reque Active $25,000.00 $732.36 $24,267.64 2.93%$732.36R 101-34104 Plan Check Fee Active $2,000.00 $0.00 $2,000.00 0.00%$0.00R 101-34105 Dance & Police Fees Active $0.00 $0.00 $0.00 0.00%$0.00R 101-34401 Recycling Apartments Active $8,500.00 ($593.00)$9,093.00 -6.98%$0.00R 101-35100 Court Fines Active $0.00 $0.00 $0.00 0.00%$0.00R 101-36100 Special Assessments Active $4,500.00 $0.00 $4,500.00 0.00%$0.00R 101-36210 Interest Earnings Active $2,500.00 $0.00 $2,500.00 0.00%$0.00R 101-39102 LMCIT Dividend Active $50,000.00 $375.00 $49,625.00 0.75%$375.00R 101-39104 Other Revenue Active $0.00 $0.00 $0.00 0.00%$0.00R 101-39203 Trsfr from General Fu Total Revenue $1,663,983.00 ($114,833.60)$1,778,816.60 -6.90%$6,487.22 Expenditure Active $19,200.00 $2,955.20 $16,244.80 15.39%$0.00E 101-41100-105 Salaries Active $800.00 $60.00 $740.00 7.50%$0.00E 101-41100-109 Recording Servic Active $2,000.00 $0.00 $2,000.00 0.00%$0.00E 101-41100-121 PERA/FICA/Hosp Active $1,000.00 $0.00 $1,000.00 0.00%$0.00E 101-41100-437 Other Miscellaneo Active $3,500.00 $0.00 $3,500.00 0.00%$0.00E 101-41410-105 Salaries Active $500.00 $0.00 $500.00 0.00%$0.00E 101-41410-200 Office Supplies Active $500.00 $0.00 $500.00 0.00%$0.00E 101-41410-351 Legal Notices Pu Active $1,000.00 $936.23 $63.77 93.62%$0.00E 101-41410-437 Other Miscellaneo Active $43,575.00 $8,914.90 $34,660.10 20.46%$1,744.21E 101-41500-101 Administrator *Budget YTD Rev-Exp© 03/29/24 9:38 AM Page 2 Current Period: March 2024 CITY OF SPRING PARK 2024 March YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 Active $29,217.00 $4,226.36 $24,990.64 14.47%$809.68E 101-41500-102 Clerk Active $21,151.00 $3,663.53 $17,487.47 17.32%$710.52E 101-41500-107 Office Assistant Active $2,000.00 $0.00 $2,000.00 0.00%$0.00E 101-41500-119 Ordinance Codific Active $36,800.00 $7,620.07 $29,179.93 20.71%$2,933.03E 101-41500-121 PERA/FICA/Hosp Active $2,000.00 $0.00 $2,000.00 0.00%$0.00E 101-41500-200 Office Supplies Active $2,000.00 $197.43 $1,802.57 9.87%$17.67E 101-41500-207 Computer Suppor Active $7,500.00 $8,333.34 ($833.34)111.11%$2,000.00E 101-41500-301 Auditing Services Active $1,000.00 $0.00 $1,000.00 0.00%$0.00E 101-41500-302 Accounting Servic Active $2,500.00 $7,027.46 ($4,527.46)281.10%$1,839.22E 101-41500-310 Contracted Servic Active $500.00 $251.88 $248.12 50.38%$83.97E 101-41500-321 Telephone and Mt Active $1,200.00 $0.00 $1,200.00 0.00%$0.00E 101-41500-322 Postage & Meter Active $8,900.00 $1,138.34 $7,761.66 12.79%$665.00E 101-41500-330 IT Technology Su Active $1,500.00 $207.75 $1,292.25 13.85%$0.00E 101-41500-350 Print/Binding Active $8,500.00 $8,402.15 $97.85 98.85%$8,402.15E 101-41500-361 Liability/Prop Ins/ Active $1,500.00 $102.00 $1,398.00 6.80%$77.54E 101-41500-413 Office Equipment/ Active $5,000.00 $0.00 $5,000.00 0.00%$0.00E 101-41500-433 Membership/Due Active $15,000.00 $343.47 $14,656.53 2.29%$25.68E 101-41500-437 Other Miscellaneo Active $2,500.00 $984.17 $1,515.83 39.37%$0.00E 101-41500-439 Other - TIF Active $3,000.00 $0.00 $3,000.00 0.00%$0.00E 101-41500-581 Historical Society Active $135,500.00 $29,302.94 $106,197.06 21.63%$12,538.20E 101-41510-310 Contracted Servic Active $27,000.00 ($22,804.87)$49,804.87 -84.46%$195.13E 101-41550-310 Contracted Servic Active $26,000.00 $1,740.00 $24,260.00 6.69%$1,015.00E 101-41600-304 Legal Fees Active $1,500.00 $57.13 $1,442.87 3.81%$57.13E 101-41600-351 Legal Notices Pu Active $500.00 $0.00 $500.00 0.00%$0.00E 101-41600-353 Ordinance Public Active $25,250.00 $7,225.00 $18,025.00 28.61%$375.00E 101-41900-310 Contracted Servic Active $4,000.00 $4,201.10 ($201.10)105.03%$4,201.10E 101-41900-361 Liability/Prop Ins/ Active $3,500.00 $299.66 $3,200.34 8.56%$275.35E 101-41900-381 Utilities/Electric/G Active $500.00 $122.06 $377.94 24.41%$0.00E 101-41900-384 Refuse/Garbage Active $250.00 $0.00 $250.00 0.00%$0.00E 101-41900-437 Other Miscellaneo Active $45,000.00 $1,534.00 $43,466.00 3.41%$782.50E 101-41910-310 Contracted Servic Active $10,000.00 $0.00 $10,000.00 0.00%$0.00E 101-41940-431 Flags/Banners/M Active $70,000.00 $9,645.00 $60,355.00 13.78%$9,645.00E 101-41940-432 Landscaping/Gar Active $12,000.00 $2,000.00 $10,000.00 16.67%$1,000.00E 101-42000-304 Legal Fees Active $530,000.00 $128,772.54 $401,227.46 24.30%$42,924.18E 101-42000-310 Contracted Servic Active $0.00 $0.00 $0.00 0.00%$0.00E 101-42000-312 Workhouse Exp Active $1,000.00 $1,410.24 ($410.24)141.02%$795.44E 101-42000-313 Booking Per Die Active $1,000.00 $0.00 $1,000.00 0.00%$0.00E 101-42000-321 Telephone and Mt Active $1,000.00 $298.62 $701.38 29.86%$0.00E 101-42000-324 Internet Service Active $6,500.00 $1,011.25 $5,488.75 15.56%$1,011.25E 101-42100-310 Contracted Servic Active $180,250.00 $49,484.00 $130,766.00 27.45%$0.00E 101-42260-310 Contracted Servic Active $15,000.00 $1,037.72 $13,962.28 6.92%$608.72E 101-42400-305 Plan Check Fees Active $30,000.00 $2,186.60 $27,813.40 7.29%$1,146.44E 101-42400-310 Contracted Servic Active $20,000.00 $0.00 $20,000.00 0.00%$0.00E 101-42800-310 Contracted Servic Active $15,000.00 $3,230.88 $11,769.12 21.54%$1,615.44E 101-42900-310 Contracted Servic Active $5,000.00 $309.00 $4,691.00 6.18%$0.00E 101-43100-303 Engineering Fees Active $3,000.00 $2,800.70 $199.30 93.36%$2,800.70E 101-43100-361 Liability/Prop Ins/ Active $17,000.00 $1,926.56 $15,073.44 11.33%$138.19E 101-43100-381 Utilities/Electric/G Active $0.00 $0.00 $0.00 0.00%$0.00E 101-43100-399 Storm Damage Active $57,000.00 $0.00 $57,000.00 0.00%$0.00E 101-43100-402 Repairs/Maint Str Active $0.00 $0.00 $0.00 0.00%$0.00E 101-43101-307 Snow Removal - *Budget YTD Rev-Exp© 03/29/24 9:38 AM Page 3 Current Period: March 2024 CITY OF SPRING PARK 2024 March YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 Active $40,000.00 $0.00 $40,000.00 0.00%$0.00E 101-43101-309 Snow Plowing - S Active $25,000.00 $0.00 $25,000.00 0.00%$0.00E 101-43101-318 Street Salt-Sandi Active $5,000.00 $0.00 $5,000.00 0.00%$0.00E 101-43150-303 Engineering Fees Active $5,000.00 $0.00 $5,000.00 0.00%$0.00E 101-43150-402 Repairs/Maint Str Active $11,000.00 $0.00 $11,000.00 0.00%$0.00E 101-45180-310 Contracted Servic Active $18,000.00 $0.00 $18,000.00 0.00%$0.00E 101-45200-310 Contracted Servic Active $1,500.00 $1,400.35 $99.65 93.36%$1,400.35E 101-45200-361 Liability/Prop Ins/ Active $0.00 $0.00 $0.00 0.00%$0.00E 101-45200-381 Utilities/Electric/G Active $5,000.00 $122.06 $4,877.94 2.44%$0.00E 101-45200-384 Refuse/Garbage Active $500.00 $244.00 $256.00 48.80%$0.00E 101-46000-310 Contracted Servic Active $250,122.00 $210,000.00 $40,122.00 83.96%$0.00E 101-47500-601 Debt Srv Bond Pri Active $20,000.00 $26,577.38 ($6,577.38)132.89%$0.00E 101-47500-611 Bond Interest Active $0.00 $0.00 $0.00 0.00%$0.00E 101-47500-612 Bond Premium A Active $1,000.00 $950.00 $50.00 95.00%$0.00E 101-47500-620 Fiscal Agent s Fe Total Expenditure ($1,848,715.00)($520,448.20)($1,328,266.80)28.15%($101,833.79) $450,549.80Total GENERAL FUND ($184,732.00)($635,281.80)343.89%($95,346.57) PUBLIC IMPROV REVOLVING FUND Revenues Expenditures Gain/(Loss)$0.00 ($279,400.86)$279,400.86 0.00%($346.50) $0.00 $0.00 $0.00 0.00%$0.00 $0.00 $279,400.86 -$279,400.86 0.00%$346.50 Revenue Active $0.00 $0.00 $0.00 0.00%$0.00R 201-33100 Grants and Aids Active $0.00 $0.00 $0.00 0.00%$0.00R 201-36210 Interest Earnings Active $0.00 $0.00 $0.00 0.00%$0.00R 201-39108 Inter.Gov.Aid Active $0.00 $0.00 $0.00 0.00%$0.00R 201-39310 Proceeds-Gen Obligat Total Revenue $0.00 $0.00 $0.00 0.00%$0.00 Expenditure Active $0.00 $0.00 $0.00 0.00%$0.00E 201-41900-520 City Hall Ramp Pr Active $0.00 $0.00 $0.00 0.00%$0.00E 201-41900-521 Records Presevat Active $0.00 $0.00 $0.00 0.00%$0.00E 201-41900-522 Sidewalk/ADA Pr Active $0.00 $0.00 $0.00 0.00%$0.00E 201-41900-527 City Hall Improve Active $0.00 $0.00 $0.00 0.00%$0.00E 201-41900-723 Playgrounds Active $0.00 $0.00 $0.00 0.00%$0.00E 201-43100-227 Street Light Repai Active $0.00 $0.00 $0.00 0.00%$0.00E 201-43100-407 Seal Coating Active $0.00 $0.00 $0.00 0.00%$0.00E 201-43100-501 West Arm West F Active $0.00 $0.00 $0.00 0.00%$0.00E 201-43100-528 Road Pavement Active $0.00 $279,400.86 ($279,400.86)0.00%$346.50E 201-43100-529 Black Lake Rd Fe Active $0.00 $0.00 $0.00 0.00%$0.00E 201-43100-724 Comprehensive P Active $0.00 $0.00 $0.00 0.00%$0.00E 201-43150-209 West Arm Road Active $0.00 $0.00 $0.00 0.00%$0.00E 201-43150-402 Repairs/Maint Str Active $0.00 $0.00 $0.00 0.00%$0.00E 201-43200-526 West Arm Road Active $0.00 $0.00 $0.00 0.00%$0.00E 201-43200-599 Water & Sewer In Active $0.00 $0.00 $0.00 0.00%$0.00E 201-43200-724 Comprehensive P Active $0.00 $0.00 $0.00 0.00%$0.00E 201-45200-518 Thor Thompson P Active $0.00 $0.00 $0.00 0.00%$0.00E 201-47500-590 Water Tower Impr Active $0.00 $0.00 $0.00 0.00%$0.00E 201-47500-613 Bond Issuance C Active $0.00 $0.00 $0.00 0.00%$0.00E 201-47500-620 Fiscal Agent s Fe Active $0.00 $0.00 $0.00 0.00%$0.00E 201-49999-720 Operating Transfe Total Expenditure $0.00 ($279,400.86)$279,400.86 0.00%($346.50) *Budget YTD Rev-Exp© 03/29/24 9:38 AM Page 4 Current Period: March 2024 CITY OF SPRING PARK 2024 March YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 $279,400.86Total PUBLIC IMPROV REVOLVING FUND $0.00 ($279,400.86)0.00%($346.50) HOUSING DEV PROJ FUND (TIF) Revenues Expenditures Gain/(Loss)$0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 Expenditure Active $0.00 $0.00 $0.00 0.00%$0.00E 202-46500-301 Auditing Services Active $0.00 $0.00 $0.00 0.00%$0.00E 202-46500-304 Legal Fees Active $0.00 $0.00 $0.00 0.00%$0.00E 202-46500-437 Other Miscellaneo Active $0.00 $0.00 $0.00 0.00%$0.00E 202-49999-720 Operating Transfe Total Expenditure $0.00 $0.00 $0.00 0.00%$0.00 $0.00Total HOUSING DEV PROJ FUND (TIF)$0.00 $0.00 0.00%$0.00 CAPITAL SPEC REV FUND Revenues Expenditures Gain/(Loss)$0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 Revenue Active $0.00 $0.00 $0.00 0.00%$0.00R 203-36210 Interest Earnings Total Revenue $0.00 $0.00 $0.00 0.00%$0.00 Expenditure Active $0.00 $0.00 $0.00 0.00%$0.00E 203-43200-515 Sunset Drive Impr Active $0.00 $0.00 $0.00 0.00%$0.00E 203-46500-301 Auditing Services Active $0.00 $0.00 $0.00 0.00%$0.00E 203-46500-304 Legal Fees Active $0.00 $0.00 $0.00 0.00%$0.00E 203-46500-437 Other Miscellaneo Active $0.00 $0.00 $0.00 0.00%$0.00E 203-49999-720 Operating Transfe Total Expenditure $0.00 $0.00 $0.00 0.00%$0.00 $0.00Total CAPITAL SPEC REV FUND $0.00 $0.00 0.00%$0.00 TIF LAKEVIEW LOFTS Revenues Expenditures Gain/(Loss)$0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 Revenue Active $0.00 $0.00 $0.00 0.00%$0.00R 204-36210 Interest Earnings Total Revenue $0.00 $0.00 $0.00 0.00%$0.00 Expenditure Active $0.00 $0.00 $0.00 0.00%$0.00E 204-46500-439 Other - TIF Active $0.00 $0.00 $0.00 0.00%$0.00E 204-49999-720 Operating Transfe Total Expenditure $0.00 $0.00 $0.00 0.00%$0.00 $0.00Total TIF LAKEVIEW LOFTS $0.00 $0.00 0.00%$0.00 TIF PRESBYTERIAN HOMES Revenues Expenditures Gain/(Loss)$87,453.00 $143,813.24 ($56,360.24)164.45%$0.00 $87,453.00 $0.00 $87,453.00 0.00%$0.00 $0.00 -$143,813.24 $143,813.24 0.00%$0.00 Revenue Active $87,453.00 $0.00 $87,453.00 0.00%$0.00R 205-31050 Tax Increments Active $0.00 $0.00 $0.00 0.00%$0.00R 205-36210 Interest Earnings *Budget YTD Rev-Exp© 03/29/24 9:38 AM Page 5 Current Period: March 2024 CITY OF SPRING PARK 2024 March YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 Total Revenue $87,453.00 $0.00 $87,453.00 0.00%$0.00 Expenditure Active $0.00 ($73,336.38)$73,336.38 0.00%$0.00E 205-46500-437 Other Miscellaneo Active $0.00 ($70,476.86)$70,476.86 0.00%$0.00E 205-46500-439 Other - TIF Total Expenditure $0.00 $143,813.24 ($143,813.24)0.00%$0.00 ($56,360.24)Total TIF PRESBYTERIAN HOMES $87,453.00 $143,813.24 164.45%$0.00 TIF DEBT SERVICE Revenues Expenditures Gain/(Loss)$0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 Revenue Active $0.00 $0.00 $0.00 0.00%$0.00R 301-36210 Interest Earnings Total Revenue $0.00 $0.00 $0.00 0.00%$0.00 Expenditure Active $0.00 $0.00 $0.00 0.00%$0.00E 301-47500-437 Other Miscellaneo Active $0.00 $0.00 $0.00 0.00%$0.00E 301-47500-601 Debt Srv Bond Pri Active $0.00 $0.00 $0.00 0.00%$0.00E 301-47500-611 Bond Interest Active $0.00 $0.00 $0.00 0.00%$0.00E 301-47500-620 Fiscal Agent s Fe Total Expenditure $0.00 $0.00 $0.00 0.00%$0.00 $0.00Total TIF DEBT SERVICE $0.00 $0.00 0.00%$0.00 2010A GO BONDS Revenues Expenditures Gain/(Loss)$0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 Revenue Active $0.00 $0.00 $0.00 0.00%$0.00R 302-31010 Current Ad Valorem T Active $0.00 $0.00 $0.00 0.00%$0.00R 302-36210 Interest Earnings Total Revenue $0.00 $0.00 $0.00 0.00%$0.00 Expenditure Active $0.00 $0.00 $0.00 0.00%$0.00E 302-47500-601 Debt Srv Bond Pri Active $0.00 $0.00 $0.00 0.00%$0.00E 302-47500-611 Bond Interest Active $0.00 $0.00 $0.00 0.00%$0.00E 302-47500-620 Fiscal Agent s Fe Total Expenditure $0.00 $0.00 $0.00 0.00%$0.00 $0.00Total 2010A GO BONDS $0.00 $0.00 0.00%$0.00 2015 GO BONDS Revenues Expenditures Gain/(Loss)$0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 Revenue Active $0.00 $0.00 $0.00 0.00%$0.00R 303-31010 Current Ad Valorem T Active $0.00 $0.00 $0.00 0.00%$0.00R 303-36100 Special Assessments Active $0.00 $0.00 $0.00 0.00%$0.00R 303-36210 Interest Earnings Total Revenue $0.00 $0.00 $0.00 0.00%$0.00 Expenditure Active $0.00 $0.00 $0.00 0.00%$0.00E 303-47500-601 Debt Srv Bond Pri Active $0.00 $0.00 $0.00 0.00%$0.00E 303-47500-611 Bond Interest Total Expenditure $0.00 $0.00 $0.00 0.00%$0.00 *Budget YTD Rev-Exp© 03/29/24 9:38 AM Page 6 Current Period: March 2024 CITY OF SPRING PARK 2024 March YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 $0.00Total 2015 GO BONDS $0.00 $0.00 0.00%$0.00 2022 GO BOND Revenues Expenditures Gain/(Loss)$0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 Revenue Active $0.00 $0.00 $0.00 0.00%$0.00R 304-31010 Current Ad Valorem T Total Revenue $0.00 $0.00 $0.00 0.00%$0.00 Expenditure Active $0.00 $0.00 $0.00 0.00%$0.00E 304-47500-601 Debt Srv Bond Pri Active $0.00 $0.00 $0.00 0.00%$0.00E 304-47500-611 Bond Interest Total Expenditure $0.00 $0.00 $0.00 0.00%$0.00 $0.00Total 2022 GO BOND $0.00 $0.00 0.00%$0.00 CHANNEL ROAD Revenues Expenditures Gain/(Loss)$0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 Expenditure Active $0.00 $0.00 $0.00 0.00%$0.00E 401-49999-720 Operating Transfe Total Expenditure $0.00 $0.00 $0.00 0.00%$0.00 $0.00Total CHANNEL ROAD $0.00 $0.00 0.00%$0.00 KINGS RD/WARREN DRAINAGE IMPRV Revenues Expenditures Gain/(Loss)$0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 Revenue On Hold $0.00 $0.00 $0.00 0.00%$0.00R 402-36210 Interest Earnings Total Revenue $0.00 $0.00 $0.00 0.00%$0.00 $0.00Total KINGS RD/WARREN DRAINAGE IMPRV $0.00 $0.00 0.00%$0.00 WATER FUND Revenues Expenditures Gain/(Loss)($406,388.00)($32,259.25)($374,128.75)7.94%$12,317.49 $0.00 $160,369.53 -$160,369.53 0.00%$36,815.85 $406,388.00 $192,628.78 $213,759.22 47.40%$24,498.36 Revenue Active $0.00 $0.00 $0.00 0.00%$0.00R 601-33100 Grants and Aids Active $0.00 $0.00 $0.00 0.00%$0.00R 601-33439 PERA Pension Reven Active $0.00 $0.00 $0.00 0.00%$0.00R 601-36210 Interest Earnings Active $0.00 $126,705.83 ($126,705.83)0.00%$35,009.95R 601-37100 Water Sales Active $0.00 $0.00 $0.00 0.00%$0.00R 601-37150 Meter Deposit & Perm Active $0.00 $90.00 ($90.00)0.00%$0.00R 601-37151 Connect/Reconnect F Active $0.00 $3,810.44 ($3,810.44)0.00%$1,582.31R 601-37160 Water Penalty Active $0.00 $2,507.60 ($2,507.60)0.00%$223.59R 601-39100 Testing Fees Active $0.00 $27,255.66 ($27,255.66)0.00%$0.00R 601-39104 Other Revenue Active $0.00 $0.00 $0.00 0.00%$0.00R 601-39311 Trsfr from Water Fund Total Revenue $0.00 $160,369.53 ($160,369.53)0.00%$36,815.85 Expenditure *Budget YTD Rev-Exp© 03/29/24 9:38 AM Page 7 Current Period: March 2024 CITY OF SPRING PARK 2024 March YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 Active $74,713.00 $70,000.00 $4,713.00 93.69%$0.00E 601-47500-601 Debt Srv Bond Pri Active $13,000.00 $8,859.13 $4,140.87 68.15%$0.00E 601-47500-611 Bond Interest Active $0.00 $0.00 $0.00 0.00%$0.00E 601-47500-612 Bond Premium A Active $0.00 $0.00 $0.00 0.00%$0.00E 601-47500-613 Bond Issuance C Active $0.00 $0.00 $0.00 0.00%$0.00E 601-47500-620 Fiscal Agent s Fe Active $33,075.00 $2,971.66 $30,103.34 8.98%$581.41E 601-49400-101 Administrator Active $30,940.00 $4,102.06 $26,837.94 13.26%$785.87E 601-49400-102 Clerk Active $42,000.00 $12,239.66 $29,760.34 29.14%$2,686.75E 601-49400-103 People Service/O Active $19,910.00 $3,555.78 $16,354.22 17.86%$689.62E 601-49400-107 Office Assistant Active $26,000.00 $8,874.07 $17,125.93 34.13%$2,932.99E 601-49400-121 PERA/FICA/Hosp Active $0.00 $0.00 $0.00 0.00%$0.00E 601-49400-129 Pension Expense Active $500.00 $0.00 $500.00 0.00%$0.00E 601-49400-200 Office Supplies Active $4,000.00 $85.97 $3,914.03 2.15%$85.97E 601-49400-201 Meters & Supplie Active $0.00 $0.00 $0.00 0.00%$0.00E 601-49400-206 GIS Active $2,000.00 $197.41 $1,802.59 9.87%$17.67E 601-49400-207 Computer Suppor Active $7,500.00 $71.02 $7,428.98 0.95%$0.00E 601-49400-215 Shop Supplies Active $4,000.00 $1,301.59 $2,698.41 32.54%$674.19E 601-49400-216 Chemicals and C Active $5,000.00 $5,315.00 ($315.00)106.30%$0.00E 601-49400-220 Repair/Maint Sup Active $500.00 $1,274.20 ($774.20)254.84%$0.00E 601-49400-299 Admin Expenses Active $7,500.00 $8,333.33 ($833.33)111.11%$2,000.00E 601-49400-301 Auditing Services Active $4,500.00 $0.00 $4,500.00 0.00%$0.00E 601-49400-302 Accounting Servic Active $3,000.00 $0.00 $3,000.00 0.00%$0.00E 601-49400-303 Engineering Fees Active $5,000.00 $979.00 $4,021.00 19.58%$927.00E 601-49400-306 Testing Fees Active $5,000.00 $7,241.76 ($2,241.76)144.84%$2,130.99E 601-49400-310 Contracted Servic Active $1,000.00 $251.88 $748.12 25.19%$83.96E 601-49400-321 Telephone and Mt Active $500.00 $0.00 $500.00 0.00%$0.00E 601-49400-322 Postage & Meter Active $250.00 $0.00 $250.00 0.00%$0.00E 601-49400-323 Web Host Active $1,000.00 $298.63 $701.37 29.86%$0.00E 601-49400-324 Internet Service Active $4,000.00 $1,138.34 $2,861.66 28.46%$665.00E 601-49400-330 IT Technology Su Active $0.00 $207.75 ($207.75)0.00%$0.00E 601-49400-350 Print/Binding Active $5,500.00 $6,161.48 ($661.48)112.03%$6,161.48E 601-49400-361 Liability/Prop Ins/ Active $33,000.00 $528.12 $32,471.88 1.60%$496.18E 601-49400-381 Utilities/Electric/G Active $11,000.00 $30,363.54 ($19,363.54)276.03%$3,501.75E 601-49400-400 Repairs/Maint Ge Active $0.00 $0.00 $0.00 0.00%$0.00E 601-49400-405 Depreciation Active $0.00 $0.00 $0.00 0.00%$0.00E 601-49400-410 Facility Lease Active $60,000.00 $17,755.42 $42,244.58 29.59%$0.00E 601-49400-411 Repairs / Breaks Active $1,500.00 $101.98 $1,398.02 6.80%$77.53E 601-49400-413 Office Equipment/ Active $500.00 $420.00 $80.00 84.00%$0.00E 601-49400-433 Membership/Due Active $0.00 $0.00 $0.00 0.00%$0.00E 601-49400-437 Other Miscellaneo Total Expenditure ($406,388.00)($192,628.78)($213,759.22)47.40%($24,498.36) ($374,128.75)Total WATER FUND ($406,388.00)($32,259.25)7.94%$12,317.49 SEWER FUND Revenues Expenditures Gain/(Loss)($694,329.30)($45,634.88)($648,694.42)6.57%$5,201.87 $0.00 $171,239.13 -$171,239.13 0.00%$45,980.06 $694,329.30 $216,874.01 $477,455.29 31.24%$40,778.19 Revenue Active $0.00 $0.00 $0.00 0.00%$0.00R 602-33100 Grants and Aids Active $0.00 $0.00 $0.00 0.00%$0.00R 602-33439 PERA Pension Reven Active $0.00 $0.00 $0.00 0.00%$0.00R 602-36210 Interest Earnings *Budget YTD Rev-Exp© 03/29/24 9:38 AM Page 8 Current Period: March 2024 CITY OF SPRING PARK 2024 March YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 Active $0.00 $166,195.86 ($166,195.86)0.00%$43,837.12R 602-37200 Sewer Sales Active $0.00 $5,043.27 ($5,043.27)0.00%$2,142.94R 602-37260 Swr Penalty Active $0.00 $0.00 $0.00 0.00%$0.00R 602-39104 Other Revenue Active $0.00 $0.00 $0.00 0.00%$0.00R 602-39312 Trsfr from Sewer Fun Total Revenue $0.00 $171,239.13 ($171,239.13)0.00%$45,980.06 Expenditure Active $74,713.30 $70,000.00 $4,713.30 93.69%$0.00E 602-47500-601 Debt Srv Bond Pri Active $13,000.00 $8,859.13 $4,140.87 68.15%$0.00E 602-47500-611 Bond Interest Active $0.00 $0.00 $0.00 0.00%$0.00E 602-47500-612 Bond Premium A Active $0.00 $0.00 $0.00 0.00%$0.00E 602-47500-613 Bond Issuance C Active $33,075.00 $2,971.66 $30,103.34 8.98%$581.41E 602-49450-101 Administrator Active $30,940.00 $4,102.06 $26,837.94 13.26%$785.87E 602-49450-102 Clerk Active $42,000.00 $12,239.65 $29,760.35 29.14%$2,686.75E 602-49450-103 People Service/O Active $21,151.00 $3,555.78 $17,595.22 16.81%$689.62E 602-49450-107 Office Assistant Active $26,000.00 $8,873.98 $17,126.02 34.13%$2,932.97E 602-49450-121 PERA/FICA/Hosp Active $0.00 $0.00 $0.00 0.00%$0.00E 602-49450-129 Pension Expense Active $500.00 $0.00 $500.00 0.00%$0.00E 602-49450-200 Office Supplies Active $0.00 $0.00 $0.00 0.00%$0.00E 602-49450-206 GIS Active $1,500.00 $197.40 $1,302.60 13.16%$17.66E 602-49450-207 Computer Suppor Active $7,500.00 $0.00 $7,500.00 0.00%$0.00E 602-49450-215 Shop Supplies Active $250.00 $0.00 $250.00 0.00%$0.00E 602-49450-220 Repair/Maint Sup Active $8,000.00 $8,333.33 ($333.33)104.17%$2,000.00E 602-49450-301 Auditing Services Active $3,000.00 $0.00 $3,000.00 0.00%$0.00E 602-49450-302 Accounting Servic Active $5,000.00 $0.00 $5,000.00 0.00%$0.00E 602-49450-303 Engineering Fees Active $2,500.00 $1,831.63 $668.37 73.27%$1,567.60E 602-49450-310 Contracted Servic Active $1,000.00 $251.88 $748.12 25.19%$83.96E 602-49450-321 Telephone and Mt Active $500.00 $0.00 $500.00 0.00%$0.00E 602-49450-322 Postage & Meter Active $350.00 $0.00 $350.00 0.00%$0.00E 602-49450-323 Web Host Active $1,000.00 $298.63 $701.37 29.86%$0.00E 602-49450-324 Internet Service Active $270,000.00 $84,743.48 $185,256.52 31.39%$21,068.56E 602-49450-327 MCES Sewer Ser Active $10,000.00 $1,138.32 $8,861.68 11.38%$665.00E 602-49450-330 IT Technology Su Active $250.00 $207.75 $42.25 83.10%$0.00E 602-49450-350 Print/Binding Active $4,500.00 $5,041.22 ($541.22)112.03%$5,041.22E 602-49450-361 Liability/Prop Ins/ Active $15,000.00 $1,641.13 $13,358.87 10.94%$95.04E 602-49450-381 Utilities/Electric/G Active $1,000.00 $0.00 $1,000.00 0.00%$0.00E 602-49450-400 Repairs/Maint Ge Active $20,000.00 $0.00 $20,000.00 0.00%$0.00E 602-49450-403 Cleaning-Televisi Active $1,000.00 $0.00 $1,000.00 0.00%$0.00E 602-49450-404 Repairs/Existing Active $75,000.00 $0.00 $75,000.00 0.00%$0.00E 602-49450-405 Depreciation Active $2,000.00 $0.00 $2,000.00 0.00%$0.00E 602-49450-410 Facility Lease Active $3,000.00 $0.00 $3,000.00 0.00%$0.00E 602-49450-411 Repairs / Breaks Active $600.00 $101.98 $498.02 17.00%$77.53E 602-49450-413 Office Equipment/ Active $0.00 $0.00 $0.00 0.00%$0.00E 602-49450-433 Membership/Due Active $20,000.00 $2,485.00 $17,515.00 12.43%$2,485.00E 602-49450-437 Other Miscellaneo Active $0.00 $0.00 $0.00 0.00%$0.00E 602-49450-491 LS Repair/Maint Active $0.00 $0.00 $0.00 0.00%$0.00E 602-49450-492 LS Repair/Maint Active $0.00 $0.00 $0.00 0.00%$0.00E 602-49450-493 LS Repair/Maint Active $0.00 $0.00 $0.00 0.00%$0.00E 602-49450-494 LS Repair/Maint Active $0.00 $0.00 $0.00 0.00%$0.00E 602-49450-495 LS Repair/Maint Active $0.00 $0.00 $0.00 0.00%$0.00E 602-49450-496 LS Repair/Maint Active $0.00 $0.00 $0.00 0.00%$0.00E 602-49450-497 LS Repair/Maint *Budget YTD Rev-Exp© 03/29/24 9:38 AM Page 9 Current Period: March 2024 CITY OF SPRING PARK 2024 March YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 Total Expenditure ($694,329.30)($216,874.01)($477,455.29)31.24%($40,778.19) ($648,694.42)Total SEWER FUND ($694,329.30)($45,634.88)6.57%$5,201.87 CONVERSION FUND Revenues Expenditures Gain/(Loss)$0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 Revenue Active $0.00 $0.00 $0.00 0.00%$0.00R 999-31010 Current Ad Valorem T Active $0.00 $0.00 $0.00 0.00%$0.00R 999-33439 PERA Pension Reven Active $0.00 $0.00 $0.00 0.00%$0.00R 999-39310 Proceeds-Gen Obligat Total Revenue $0.00 $0.00 $0.00 0.00%$0.00 Expenditure Active $0.00 $0.00 $0.00 0.00%$0.00E 999-49999-100 Wage Active $0.00 $0.00 $0.00 0.00%$0.00E 999-49999-129 Pension Expense Active $0.00 $0.00 $0.00 0.00%$0.00E 999-49999-405 Depreciation Active $0.00 $0.00 $0.00 0.00%$0.00E 999-49999-500 Capital Outlay Active $0.00 $0.00 $0.00 0.00%$0.00E 999-49999-601 Debt Srv Bond Pri Active $0.00 $0.00 $0.00 0.00%$0.00E 999-49999-611 Bond Interest Active $0.00 $0.00 $0.00 0.00%$0.00E 999-49999-612 Bond Premium A Total Expenditure $0.00 $0.00 $0.00 0.00%$0.00 $0.00Total CONVERSION FUND $0.00 $0.00 0.00%$0.00 Report Total ($1,197,996.30)($848,763.55)($349,232.75)70.85%($78,173.71) PRICE PROPOSAL FOR CITY OF SPRING PARK, MN March 20, 2024 | Pricing valid for 90 days 2 Price Proposal for the City of Spring Park, MN | March 20, 2024 Table of Contents Welcome .......................................................................................................................... 2 Product Overview ........................................................................................................... 8 Admin Portal..................................................................................................................12 Implementation Process ..............................................................................................14 Training & Support .......................................................................................................14 Citizen Marketing Services ..........................................................................................14 Client Testimonials .......................................................................................................15 Company Overview.......................................................................................................17 Summary........................................................................................................................17 3 Price Proposal for the City of Spring Park, MN | March 20, 2024 Welcome March 20, 2024 Mr. Mike Anderson City Administrator City of Spring Park, MN 4349 Warren Avenue Spring Park, MN 55384 Dear Mr. Anderson, We appreciate the opportunity to provide a price proposal to the City of Spring Park, MN. Nuvei (NASDAQ: NUVEI) is a global payments company with offices throughout the United States. Nuvei provides online payment, e -Billing, and citizen engagement solutions to utilities and municipalities . Nuvei helps government organizations: • Increase citizen engagement & customer satisfaction • Increase self -service digital payments • Increase e-Billing & Auto -Pay enrollments • Decrease call-center calls & walk -in traffic • Reduce operational costs Nuvei's UtilityConnect platform is a secure payments platform designed to make it easier and more convenient for your citizens to pay, how they want, when they want, without requiring employee assistance. Not only does the solution integrate seamlessly with your existing Banyon system, our Software-as-a-Service (SaaS) architecture means you'll never have to perform an upgrade or an update again. 4 Price Proposal for the City of Spring Park, MN | March 20, 2024 Your citizens expect a user-friendly payment experience that they can manage independently. Your staff need effective tools to answer questions, troubleshoot problems, and deliver excellent service. UtilityConnect will help your organization achieve these results and more. Sincerely, Tiffany Donica Mid-market Sales Executive 5 Price Proposal for the City of Spring Park, MN | March 20, 2024 Challenges and Goals Challenges Objectives & Goals Future State • Engaging multilingual demographic • Offer a user-friendly, payment solution that supports multiple languages • Increase self -service payments • Increase citizen satisfaction • Reduce routine, billing -related support calls • Multiple payment vendors • Consolidate payment vendors • Simplify reconciliation • Streamline operations • Nuvei offers a single solution that can take payments for multiple departments including: all utilities (IVR + Online), permits & licenses, courts, and more • Single vendor makes it easier for to get support when needed • Non-existent or subpar customer support • Faster, more responsive technical support + assistance, when needed • Assigned Client Success Manager and team • 99.9% uptime • Fast, responsive support via telephone and e -mail • Low e-Billing enrollment s • Increase e-Billing enrollments by 37% in 1st year • Estimated savings to be 31% per month • Low Auto -Pay adoption rates • Increase Auto -Pay adoption payments by 45% in 1st year • Reduce printed check processing • Streamline collections • Free up staff time • Influx of calls/office traffic • Decrease call volume by 25% • Decrease walk -in traffic by 10% • Save staff ~40 hours per week or ~160 hours per month (at 5 mins a call) • Increase customer satisfaction • No long lines • Communication outreach • Reduce later payers & shutoffs by 10% • Decrease mailing costs • Reduce printed costs • Email & text payment notification reminders prior to bill due date • Customer preferred communication channels 6 Price Proposal for the City of Spring Park, MN | March 20, 2024 Pricing and Terms Pricing is based on the following information provided by the City of Spring Park, MN: Bills/Quarter 400 Average Quarterly Payment $300 Credit Card Transactions (quarterly) 320 ACH Transactions (quarterly ) 80 Pricing Model Convenience (Transaction fees paid by the end user) Payment Fees Credit/Debit Card 2.95% ACH $0.99 per transaction Other Fees e-Bills - Only charged when customer no longer receives a printed bill $.20 per e-Bill - Waived IVR (Pay -by-Phone) Payments - Only charged for completed payments $.50 - Waived Chargeback Returned Check Fee $7.00 per chargeback $7.00 per returned check PCI Compliance $9.95 per month Service Description Monthly Portal Fee - Includes unlimited user license for the Customer and Admin Portals $250/Mo - Waived Implementation Fee - Includes CIS integration, billing process configuration, portal setup, and staff training $5,000 - Waived Help Desk Support - Unlimited phone + e -mail inquiries. Assigned Client Success Manager Included All payment channels included: online, IVR, Live Agent, Text & Pay, and POS. All fees include recurring, one -time payments, all payment channels, and all card brands (Visa, MasterCard, American Express and Discover). 7 Price Proposal for the City of Spring Park, MN | March 20, 2024 Standard Pricing Based on the proposed pricing convenience fee model and the statements/transaction details that you provided, Nuvei will be able to reduce cost in the following manner: Convenience Fee Model (Fees paid by end user). Average payment of $300 based on payments data provided b y City of Spring Park, MN. 2.95% per Credit Card payment (up to $25,000 maximum payment) $.99 ACH/e -check per payment (up to $25,000 maximum payment) Included all payment channels: IVR, Live Agent, Text & Pay , Web, and e -Billing. 8 Price Proposal for the City of Spring Park, MN | March 20, 2024 Product Overview Nuvei leverages best-in-class technologies to address today's needs and tomorrow's opportunities. UtilityConnect is a comprehensive payment solution focused on delivering an intuitive, user-friendly payment experience for citizens, and administrative tools that help staff members perform their daily tasks more efficiently. Advanced Software -as-Service (SaaS) Solution UtilityConnect’s SaaS architecture will "future proof" your online payment application. Nuvei continues to evolve its platform to stay abreast of the rapid changes in the financial technology industry and meet compliance standards such as: PCI, Nacha, and more. In addition, your organization will never have to perform an upgrade or an update again. You will always run the most current version of software and our team manages all backups, hardware maintenance, system upgrades, etc. Direct Integration with Your CIS System Nuvei has integrated with more than 300 municipal software applications. Using batch and real-time transfer methods, we'll save you time and effort by keeping critical account and payment data synched between your CIS/Utility Billing system and UtilityConnect. 9 Price Proposal for the City of Spring Park, MN | March 20, 2024 Multilingual Dashboard Configuration UtilityConnect can be translated into multiple languages , enabling municipal organizations to encourage underserved segments of their customer base to use self-service payment options. Guest Pay Offering a Guest Pay or "one -time" payment method is useful for citizens who don't want to create another username and password before being able to pay. Citizens can view their bill amount, due date, and pay with credit/debit cards or ACH transfers. Partial payments can be accepted if t his option is supported by your municipality. Payment receipts can be e -mailed or texted. Integrated Auto-Pay, e-Billing, Text & Pay Options With Auto -Pay, citizens can have their payments automatically paid on the due date or scheduled for a specific day. e -Billing enables citizens to receive paperless bills instead of printed bills. With Text & Pay, citizens can opt to receive a text when a bill is posted and pay directly from that message. 10 Price Proposal for the City of Spring Park, MN | March 20, 2024 Increasing Auto -Pay enrollments improves cash flow and results in fewer collection s dollars that municipalities must manage. Transitioning customers from printed to electronic bills drives valuable print and mail cost savings. Text & Pay is an excellent way to provide a self -service payment option to non-technical users who don't want to pay online or via Pay by Phone (IVR). Easy Mobile Payments…No App Required! Municipalities can expect 50% or more of their payments to be made using a mobile device. Many citizens don't want to download a mobile app in order to pay. UtilityConnect automatically displays information to fit the mobile, tablet, laptop or desktop screen the citizen is using. We support all mobile devices and these Web browsers: Google Chrome, Apple Safari, Mozilla Firefox, Microsoft Edge and Internet Explorer. Pay by Phone (IVR) Nuvei's integrated Pay by Phone service provides municipalities an assigned dedicated toll-free telephone number that can be accessed directly by citizens or linked to an existing customer support line. IVR enables customers to: • Make effortless, secure payments, 24/7, using a credit/debit card or e -Check • Easily check balances and due dates • Receive instructions in Spanish • Complete a payment in 2-3 mins. Utilities benefit because: • Customer Service Reps (CSRs) can stop taking manual phone payments • Payments are integrated into UtilityConnect • Staff have more time to focus on other support & service tasks. IVR gives those no n-technically savvy an easy way to pay using their phones. In addition, municipal organizations can minimize manual errors and the handling of sensitive payment information by staff. 11 Price Proposal for the City of Spring Park, MN | March 20, 2024 Manage Multiple Accounts Property managers and users with multiple accounts can create a single online profile, and then view and manage all their accounts. Automated E-mail & Text Reminders UtilityConnect automatically sends a variety e -mail and text reminders when: • New bill posting • Upcoming Auto -Pay payment • Successful/unsuccessful payment confirmation Point of Sale (POS) Staff can process in-person and walk -in payments using a variety of cloud-based, secured EMV and swipe card readers. Payments are directly integrated into UtilityConnect. 12 Price Proposal for the City of Spring Park, MN | March 20, 2024 Admin Portal Nuvei's Admin Portal helps staff perform their daily tasks more efficiently. The portal includes payment management tools so staff can quickly and easily accept payments, notify citizens, view trends and insights, build custom reports, and reconcile payment deposits with ease. 13 Price Proposal for the City of Spring Park, MN | March 20, 2024 Configurable Dashboards The dashboards show a summary of data, such as: payment volume processed, open balance totals, successful transactions, portal sign -ups and more. Staff can view key performance information that is important to their organizations. Manage Customer Accounts Staff can access any customer account in the system and: • Take payments • Change account information: address , phone numbers, passwords, etc. • Enroll citizens in e-Billing, Auto -Pay, and Text & Pay • Provide portal support Communicate Directly with Citizens Portal notifications allow staff members to send e -mail and text messages directly to citizens for: boil water alerts, water main breaks, maintenance issues, news, reminders , and more. Now keeping customers engaged and informed is a simple process. Reporting Configurable, real-time reporting in the Admin Portal enables staff to view a variety of standard reports or create their own. Building custom reports is an easy process requiring no software programming knowledge. Reports can be scheduled for delivery: daily, weekly, monthly and more. Access to accurate, reliable, and relevant data helps your municipality understand customer behavior, track payment information, and improve decision making. 14 Price Proposal for the City of Spring Park, MN | March 20, 2024 Implementation Process Nuvei has implemented payment solutions for more than 2,000 government agencies. After contract signature, your organization will be assigned a dedicated Implementation Manager who will work with your team until the payment site has been launched. This experienced professional will guide: the Merchant ID application and creation process, data integration, configuration, testing, and training. In general, the implementation process takes about 3-4 months to complete. Training & Support After the payment site is live, remote training and support are included. Staff can contact our dedicated help desk via phone and e -mail, Monday - Friday, 6am - 4pm MT. In case of after-hour emergencies, our on-call support is always available. Citizen Marketing Services To encourage citizens to use the new payment s platform in order to drive self - service payments and e -Billing and Auto -Pay enrollments, Nuvei offers: • A dedicated Customer Success Manager • E-mail campaigns • Marketing collateral: social media ads, bill inserts, etc. • Prize giveaways 15 Price Proposal for the City of Spring Park, MN | March 20, 2024 Our team will develop a customized program for your municipality with the goal of achieving the following adoption improvements (Figure 1). Before Nuvei 1 Year w/ Nuvei 45% Auto -Pay Enrollments 37% e-Billing Enrollments 16 Price Proposal for the City of Spring Park, MN | March 20, 2024 Client Testimonials Nuvei's top priority is ensuring the success of our clients. Our payment solutions drive superior commerce outcomes and empower our clients to reach their operational goals. Below are just a few testimonials from our clients. “We’ve had big growth in online payments, and we really do enjoy working with Nuvei.” Sara W. – Customer Service Manager “Changing our bill presentment was a game- changer for us in mitigating customer complaints. We couldn’t have done that without Nuvei.” Jessica D. - Utility Support Service Manager “We have happier customers. They’re happy with our payment solution, and we’re happy with it.” Everett B. General Manager “Nuvei has a great customer service team. When I email them, they are so friendly and amazingly fast, I don’t have to wait to get a problem fixed. Their customer support and technical support is fast and they understand our needs.” Customer Administrator “We are pleased with Nuvei. The integration is working well and we are happy to offer mobile technology to our citizens. Nuvei offers excellent customer service and works very hard to serve our court staff. I highly recommend their payment service to other courts.” Presiding Judge Birmingham Municipal Court “We like the ease of use and quick response time, and Nuvei’s service is excellent.” Court Administrator 17 Price Proposal for the City of Spring Park, MN | March 20, 2024 Company Overview Nuvei is a leading provider of integrated payment and frictionless commerce solutions that help customers accept and make payments, expedite receipt of money, and increase operating efficiencies. Nuvei’s Connect suite of platforms (UtilityConnectTM, MuniConnectTM, and CourtConnectTM), are PCI Level 1 compliant and specifically designed for simplicity, scalability, and flexibility. Our solutions enable citizens to make payments at any time, from any device, and from just about anywhere. Ensuring your staff has access to the most innovative technology to support and streamline your operations is our goal. 2,000+ 30 8M+ $1B Agencies and Municipalities Served States Served Agency Payments Processed per Year Agency Revenue Collected per Year Summary Thank you for the opportunity to present a proposal for Nuvei's UtilityConnect solution. We look forward to partnering with the City of Spring Park, MN and helping you achieve your online payment and e -Billing goals. Please contact me if you have any questions regarding our solution or this proposal. Sincerely, Tiffany Donica Mid-Market Sales Executive