Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
5/6/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 discussed at the forum, except for referral to staff for future report. CITY OF SPRING PARK CITY COUNCIL AGENDA MAY 6, 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 6. CONSENT AGENDA* a. Regular City Council & Work Session Minutes – April 15, 2024 b. Approval of Expenditure and Financial Reports 7. ACTION AGENDA a. Vacant Council Seat Appointment b. Water Treatment Plant Upgrades – Approve Quote from Quality Control 8. REPORTS a. Mayor & Council b. Staff 9. ANNOUNCEMENTS/MISCELLANEOUS (INFORMATION ONLY) a. May 08, 2024 – Planning Commission Meeting – 6:00PM b. May 20, 2024 – Regular City Council Meeting – 6:30PM c. May 20, 2024 – Council Work Session – 5:30PM d. May 27, 2024 – Closed – Memorial Day e. June 03, 2024 - Regular City Council Meeting – 6:30PM 10. ADJOURNMENT * 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 MINUTES APRIL 15, 2024 – 6:30 PM SPRING PARK CITY HALL 1. CALL TO ORDER The meeting was called to order at 6:30 p.m. Council Present: Mayor Hoffman and Council Member’s Chase and Horton were present. Council Member Sippel was absent. Staff Present: City Administrator Anderson 2. PLEDGE OF ALLEGIANCE Mayor Hoffman led the audience in the Pledge of Allegiance 3. APPROVAL OF AGENDA Council Member Horton motioned, being seconded by Council Member Chase, to approve the agenda as presented. On vote being taken, the motion was unanimously approved. 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 6. CONSENT AGENDA* a. Regular City Council Meeting Minutes – April 1, 2024 b. Approval of Expenditure and Financial Reports c. Annual Dock Permits d. Back Channel Brewing – Special Events; i. Run for a Reason 5K ii. Dance Agenda iii. Artimer Market Council Member Horton motioned, being seconded by Mayor Hoffman, to approve the consent agenda as presented. On vote being taken, the motion was unanimously approved. 7. ACTION AGENDA a. Ordinances 24-01 & 24-02: Adding As-Built Survey Requirements into City Code i. Ordinance #24-01: As-Built Surveys for Remodel’s, Rebuilds, Additions, etc. Council Member Chase motioned, being seconded by Council Member Horton, to approve Ordinance #24-01. On vote being taken, the motion was unanimously approved. * 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. ii. Ordinance #24-02: As-Built Survey for Subdivided Land Council Member Horton motioned, being seconded by Council Member Chase, to approve Ordinance #24-02. On vote being taken, the motion was unanimously approved. b. Vacant Council Seat; Application Process Mayor Hoffman and Council requested staff to set up interviews with all four applicants. c. Scope of Work & Cost Estimate: Moore Engineering - Warren Ave Project John from Moore Engineering reviewed the revised scope of work and cost estimate from the changes requested by Council at the prior meeting. The estimate is $280K. Next step is to review the final plans which will occur at the May Work Session. Council Member Horton motioned, being seconded by Council Member Chase, to approve the curb and gutter and storm drainage and rough estimate of $280K and move forward with final plans. On vote being taken, the motion was unanimously approved. 8. REPORTS a. Mayor & Council: Council Member Horton stated she is going to purchase another arbor to go to Wilkes Park. b. Staff: City Administrator Anderson mentioned the Celebration of Life at Lord Fletcher’s for the late Mayor Rockvam. 9. ANNOUNCEMENTS/MISCELLANEOUS (INFORMATION ONLY) a. May 06, 2024 – Regular City Council Meeting – 6:30PM b. May 08, 2024 – Planning Commission Meeting – 6:00PM c. May 20, 2024 – Regular City Council Meeting – 6:30PM d. May 20, 2024 – Council Work Session – 5:30PM e. Orono Support Letter for LMCD Code Changes for Watercraft Rentals 10. ADJOURNMENT There being no further discussion, Council Member Horton motioned, being seconded by Council Member Chase, to adjourn the meeting at 7:04p.m. On vote being taken, the motion was unanimously approved. Respectfully submitted, Jamie Hoffman, City Clerk CITY OF SPRING PARK WORK SESSION MINUTES APRIL 15, 2024 – 6:00 PM SPRING PARK CITY HALL (Work Session discussion times are approximate) 1. 6:00: Council Vacancy Discussion; Interview Process & Next Steps The Council decided they would like to interview all 4 candidates. These interviews will take place at the May 6th meeting and directed staff to let the applicants know the next steps. 2. 6:25 Miscellaneous Mayor Hoffman brought forward the letter from the Orono Police department regarding the LMCD watercraft rental ordinance. Council agreed to support the ordinance for safety reasons as these private owners are not licensed and/or properly insured. Mayor Hoffman suggested the City draft something up using the same narrative as the Orono Police and also send it to Gabe Jabbour and others at the LMCD. Council Member Horton asked about the docks at Back Channel. Mayor Hoffman advised that the decision to allow additional dock space at that location is up to the LMCD. Discussion was had regarding the Warren Avenue Project components and cost estimate. 3. 6:30: Adjourn After no further discussion, Council Member Chase motioned, being seconded by Council Member Horton , to adjourn the work session at 6:20p.m. *Check Summary Register© CITY OF SPRING PARK 05/02/24 2:35 PM Page 1 Batch: 050124PresHomesDocks,050624PAY,050624PAY02 Name Check Date Check Amt 10100 Wells Fargo Bank NA 33757 ASSA ABLOY 4/30/2024 $451.59 Back entry door services for automatic opener 33758 HAWKINS, INC.4/30/2024 $30.00 Purchased Chemicals for WTP 33759 LAKESIDE NETWORKS 4/30/2024 $275.00 Installation and Internet Services from 04/26/24 33760 LOFFLER COMPANIES, INC.4/30/2024 $99.38 Copier Usage 03/22/24-04/21/24 33761 METRO COUNCIL ENVIRON SER 4/30/2024 $21,568.56 May 24' Wastewater Treatment Monthly Fee 33762 METRO CITIES 4/30/2024 $846.00 2024 Metro Cities Membership Dues 33763 MINUTEMAN PRESS 4/30/2024 $153.49 Purchase of Spring Park Logo Flag 33764 OPTUM BANK 4/30/2024 $11.25 HSA Employee Monthly Service Fee 33765 PRESBYTERIAN HOMES & SERV 4/30/2024 $256.25 Refund for Online payment license at 4515 Sho 33766 PRESS PERFECT PRINTING & G 4/30/2024 $1,040.30 Spring 2024 Newsletter 33767 QUALITY CONTROL & INTEGR., I 4/30/2024 $10,820.00 Install new keystone valves at WTP 33768 SECURITY & SOUND CO 4/30/2024 $22,613.00 2024 Annual Fee for Monitoring Security Syste 33769 SOLUTION BUILDERS, INC.4/30/2024 $615.76 Security System Setup 33770 CITY OF SPRING PARK 4/30/2024 $105.98 1st Qtr. Utility 2024 - City Hall 33771 STA-SAFE LOCKSMITHS CO.4/30/2024 $300.00 City Hall & WTP Lock Rekeyed 33772 UNICLEAN CLEANROOM SERVIC 4/30/2024 $122.37 Rug rental services 03/24/24-04/20/24 33773 US BANK 4/30/2024 $1,128.38 March 24' Credit Card Purchases - Microsoft & 33774 WSB & ASSOCIATES, INC.4/30/2024 $1,104.00 March 24' Planning Services - General 33776 CITY OF BLOOMINGTON 5/2/2024 $28.00 March 24' Water Testing Fees 33777 MARK HODGES 5/2/2024 $60.00 April 24' Work Session Recording Total Checks $61,629.31 Batch: 050124PresHomesDocks,050624PAY,050624PAY02 Page 1 05/02/24 2:37 PMCITY OF SPRING PARK *Check Detail Register© Amount CommentInvoiceCheck #Check Date Vendor Name 10100 Wells Fargo Bank NA 33757 04/30/24 ASSA ABLOY $451.59 Back entry door services for automatic openerGrants and Aids 92994R 101-33100 $451.59Total 33758 04/30/24 HAWKINS, INC. $30.00 Purchased Chemicals for WTPChemicals and Chem Pro 6731550E 601-49400-216 $30.00Total 33759 04/30/24 LAKESIDE NETWORKS $91.68 Installation and Internet Services from 04/26/24- 05/25/24 Internet Service 001862E 101-42000-324 $91.66 Installation and Internet Services from 04/26/24- 05/25/24 Internet Service 001862E 601-49400-324 $91.66 Installation and Internet Services from 04/26/24- 05/25/24 Internet Service 001862E 602-49450-324 $275.00Total 33760 04/30/24 LOFFLER COMPANIES, INC. $33.14 Copier Usage 03/22/24-04/21/24Office Equipment/Rental 4671580E 101-41500-413 $33.12 Copier Usage 03/22/24-04/21/24Office Equipment/Rental 4671580E 601-49400-413 $33.12 Copier Usage 03/22/24-04/21/24Office Equipment/Rental 4671580E 602-49450-413 $99.38Total 33761 04/30/24 METRO COUNCIL ENVIRON SERVICES $500.00 2024 Industrial Discharge Permit for Jan - Dec. 2024 MCES Sewer Service Chg 0001171763E 602-49450-327 $21,068.56 May 24' Wastewater Treatment Monthly FeeMCES Sewer Service Chg 1170611E 602-49450-327 $21,568.56Total 33762 04/30/24 METRO CITIES $846.00 2024 Metro Cities Membership DuesMembership/Dues/Edu 1774E 101-41500-433 $846.00Total 33763 04/30/24 MINUTEMAN PRESS $153.49 Purchase of Spring Park Logo FlagFlags/Banners/Maint/Labo 24035E 101-41940-431 $153.49Total 33764 04/30/24 OPTUM BANK $11.25 HSA Employee Monthly Service FeeOther Miscellaneous 0001580208E 101-41500-437 $11.25Total 33765 04/30/24 PRESBYTERIAN HOMES & SERVICES $256.25 Refund for Online payment license at 4515 Shoreline Other Licenses/PermitsR 101-32180 $256.25Total 33766 04/30/24 PRESS PERFECT PRINTING & GRAPGICS $200.59 Spring 2024 NewsletterPrint/Binding 25010E 101-41500-350 $200.58 Spring 2024 NewsletterPrint/Binding 25010E 601-49400-350 $200.58 Spring 2024 NewsletterPrint/Binding 25010E 602-49450-350 $438.55 Purchase of window envelopesOffice Supplies 25010E 101-41500-200 Batch: 050124PresHomesDocks,050624PAY,050624PAY02 Page 2 05/02/24 2:37 PMCITY OF SPRING PARK *Check Detail Register© Amount CommentInvoiceCheck #Check Date Vendor Name $1,040.30Total 33767 04/30/24 QUALITY CONTROL & INTEGR., INC $10,820.00 Install new keystone valves at WTPRepairs/Maint General 46676E 601-49400-400 $10,820.00Total 33768 04/30/24 SECURITY & SOUND CO $20,753.00 Security Alarm & Access Control Upgrade for City Hall & WTP Grants and Aids 28088R 101-33100 $360.00 2024 Annual Fee for Monitoring Security System in WTP Contracted Services 28093E 601-49400-310 $1,500.00 Security Alarm & Access Control Upgrade for City Hall & WTP Grants and Aids 28128R 101-33100 $22,613.00Total 33769 04/30/24 SOLUTION BUILDERS, INC. $413.25 Headsets for Teams PhonesOffice Equipment/Rental SB56256E 101-41500-413 $202.51 Security System SetupIT Technology Support SB56266E 101-41500-330 $615.76Total 33770 04/30/24 CITY OF SPRING PARK $105.98 1st Qtr. Utility 2024 - City HallUtilities/Electric/GasE 101-41900-381 $105.98Total 33771 04/30/24 STA-SAFE LOCKSMITHS CO. $300.00 City Hall & WTP Lock RekeyedOther Miscellaneous 014264E 101-41900-437 $300.00Total 33772 04/30/24 UNICLEAN CLEANROOM SERVICES $122.37 Rug rental services 03/24/24-04/20/24Contracted Services 207463E 101-41500-310 $122.37Total 33773 04/30/24 US BANK $33.03 March 24' Credit Card Purchases - Microsoft & Adobe Computer Support/SupplieE 101-41500-207 $33.02 March 24' Credit Card Purchases - Microsoft & Adobe Computer Support/SupplieE 601-49400-207 $33.02 March 24' Credit Card Purchases - Microsoft & Adobe Computer Support/SupplieE 602-49450-207 $51.47 March 24' Credit Card Purchases - Labels for Elections Office SuppliesE 101-41410-200 $19.59 March 24' Credit Card Purchases - Felt tip pensOffice SuppliesE 101-41500-200 $38.25 March 24' Credit Card Purchases - Command hooks and air fresheners Other MiscellaneousE 101-41900-437 $920.00 March 24' Credit Card Purchases - Year 2 Clerks Institute for Jamie & Patria Membership/Dues/EduE 101-41500-433 $1,128.38Total 33774 04/30/24 WSB & ASSOCIATES, INC. $782.00 March 24' Planning Services - GeneralContracted Services R-024509-00E 101-41910-310 $322.00 March 24' Planning Services - Land Use App / 3880 Sunset Contracted Services R-024509-00E 101-41910-310 $1,104.00Total Batch: 050124PresHomesDocks,050624PAY,050624PAY02 Page 3 05/02/24 2:37 PMCITY OF SPRING PARK *Check Detail Register© Amount CommentInvoiceCheck #Check Date Vendor Name 33776 05/02/24 CITY OF BLOOMINGTON $28.00 March 24' Water Testing FeesTesting Fees 23451E 601-49400-306 $28.00Total 33777 05/02/24 MARK HODGES $60.00 April 24' Work Session RecordingRecording Service 2-04152024E 101-41100-109 $60.00Total 10100 Wells Fargo Bank NA $61,629.31 Fund Summary 10100 Wells Fargo Bank NA 101 GENERAL FUND $28,105.99 601 WATER FUND $11,596.38 602 SEWER FUND $21,926.94 $61,629.31 *Budget YTD Rev-Exp© 05/03/24 7:45 AM Page 1 Current Period: May 2024 CITY OF SPRING PARK 2024 May 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)($785,849.99)$601,117.99 425.40%($24,748.26) $1,663,983.00 -$141,762.21 $1,805,745.21 -8.52%-$19,603.11 $1,848,715.00 $644,087.78 $1,204,627.22 34.84%$5,145.15 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 $800.00 $200.00 80.00%$800.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%$0.00R 101-32160 Garbage Haulers Active $2,500.00 $3,200.00 ($700.00)128.00%$1,250.00R 101-32170 Special Events Active $10,000.00 $923.75 $9,076.25 9.24%($256.25)R 101-32180 Other Licenses/Permit Active $35,000.00 $19,773.29 $15,226.71 56.50%$572.93R 101-32210 Building Permits Active $0.00 $1,503.26 ($1,503.26)0.00%$11.05R 101-32215 Building Permit - Surc Active $5,000.00 ($65,626.59)$70,626.59 -1312.53%($22,704.59)R 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%$0.00R 101-34103 Variance/CUP Reque Active $25,000.00 $14,450.91 $10,549.09 57.80%$723.75R 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 $500.00 $49,500.00 1.00%$0.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 ($141,762.21)$1,805,745.21 -8.52%($19,603.11) Expenditure Active $19,200.00 $4,432.80 $14,767.20 23.09%$0.00E 101-41100-105 Salaries Active $800.00 $120.00 $680.00 15.00%$60.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 $51.47 $448.53 10.29%$51.47E 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 $10,659.10 $32,915.90 24.46%$0.00E 101-41500-101 Administrator *Budget YTD Rev-Exp© 05/03/24 7:45 AM Page 2 Current Period: May 2024 CITY OF SPRING PARK 2024 May YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 Active $29,217.00 $5,000.22 $24,216.78 17.11%$0.00E 101-41500-102 Clerk Active $21,151.00 $4,339.58 $16,811.42 20.52%$0.00E 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 $8,469.48 $28,330.52 23.01%$0.00E 101-41500-121 PERA/FICA/Hosp Active $2,000.00 $458.14 $1,541.86 22.91%$458.14E 101-41500-200 Office Supplies Active $2,000.00 $281.36 $1,718.64 14.07%$33.03E 101-41500-207 Computer Suppor Active $7,500.00 $8,333.34 ($833.34)111.11%$0.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,149.83 ($4,649.83)285.99%$122.37E 101-41500-310 Contracted Servic Active $500.00 $335.92 $164.08 67.18%$0.00E 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,577.51 $7,322.49 17.72%$202.51E 101-41500-330 IT Technology Su Active $1,500.00 $408.34 $1,091.66 27.22%$200.59E 101-41500-350 Print/Binding Active $8,500.00 $8,402.15 $97.85 98.85%$0.00E 101-41500-361 Liability/Prop Ins/ Active $1,500.00 $548.39 $951.61 36.56%$446.39E 101-41500-413 Office Equipment/ Active $5,000.00 $3,229.46 $1,770.54 64.59%$1,766.00E 101-41500-433 Membership/Due Active $15,000.00 $3,010.37 $11,989.63 20.07%$11.25E 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 $3,000.00 $0.00 100.00%$0.00E 101-41500-581 Historical Society Active $135,500.00 $41,841.14 $93,658.86 30.88%$0.00E 101-41510-310 Contracted Servic Active $27,000.00 ($22,804.87)$49,804.87 -84.46%$0.00E 101-41550-310 Contracted Servic Active $26,000.00 $2,301.88 $23,698.12 8.85%$0.00E 101-41600-304 Legal Fees Active $1,500.00 $57.13 $1,442.87 3.81%$0.00E 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 $8,451.31 $16,798.69 33.47%$0.00E 101-41900-310 Contracted Servic Active $4,000.00 $4,201.10 ($201.10)105.03%$0.00E 101-41900-361 Liability/Prop Ins/ Active $3,500.00 $576.47 $2,923.53 16.47%$105.98E 101-41900-381 Utilities/Electric/G Active $500.00 $234.03 $265.97 46.81%$0.00E 101-41900-384 Refuse/Garbage Active $250.00 $395.18 ($145.18)158.07%$338.25E 101-41900-437 Other Miscellaneo Active $45,000.00 $4,340.00 $40,660.00 9.64%$1,104.00E 101-41910-310 Contracted Servic Active $10,000.00 $153.49 $9,846.51 1.53%$153.49E 101-41940-431 Flags/Banners/M Active $70,000.00 $9,645.00 $60,355.00 13.78%$0.00E 101-41940-432 Landscaping/Gar Active $12,000.00 $3,000.00 $9,000.00 25.00%$0.00E 101-42000-304 Legal Fees Active $530,000.00 $171,696.72 $358,303.28 32.40%$0.00E 101-42000-310 Contracted Servic Active $0.00 $140.00 ($140.00)0.00%$0.00E 101-42000-312 Workhouse Exp Active $1,000.00 $1,485.24 ($485.24)148.52%$0.00E 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 $693.75 $306.25 69.38%$91.68E 101-42000-324 Internet Service Active $6,500.00 $1,011.25 $5,488.75 15.56%$0.00E 101-42100-310 Contracted Servic Active $180,250.00 $88,728.50 $91,521.50 49.23%$0.00E 101-42260-310 Contracted Servic Active $15,000.00 $1,037.72 $13,962.28 6.92%$0.00E 101-42400-305 Plan Check Fees Active $30,000.00 $3,515.79 $26,484.21 11.72%$0.00E 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 $4,846.32 $10,153.68 32.31%$0.00E 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%$0.00E 101-43100-361 Liability/Prop Ins/ Active $17,000.00 $4,297.31 $12,702.69 25.28%$0.00E 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© 05/03/24 7:45 AM Page 3 Current Period: May 2024 CITY OF SPRING PARK 2024 May 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%$0.00E 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 $234.03 $4,765.97 4.68%$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)($644,087.78)($1,204,627.22)34.84%($5,145.15) $601,117.99Total GENERAL FUND ($184,732.00)($785,849.99)425.40%($24,748.26) PUBLIC IMPROV REVOLVING FUND Revenues Expenditures Gain/(Loss)$0.00 ($279,400.86)$279,400.86 0.00%$0.00 $0.00 $0.00 $0.00 0.00%$0.00 $0.00 $279,400.86 -$279,400.86 0.00%$0.00 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%$0.00E 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%$0.00 *Budget YTD Rev-Exp© 05/03/24 7:45 AM Page 4 Current Period: May 2024 CITY OF SPRING PARK 2024 May 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%$0.00 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© 05/03/24 7:45 AM Page 5 Current Period: May 2024 CITY OF SPRING PARK 2024 May 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 Active $0.00 $0.00 $0.00 0.00%$0.00E 302-47500-720 Operating Transfe 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 *Budget YTD Rev-Exp© 05/03/24 7:45 AM Page 6 Current Period: May 2024 CITY OF SPRING PARK 2024 May YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 Active $0.00 $0.00 $0.00 0.00%$0.00E 303-47500-720 Operating Transfe Total Expenditure $0.00 $0.00 $0.00 0.00%$0.00 $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)($52,000.26)($354,387.74)12.80%($11,596.38) $0.00 $161,482.04 -$161,482.04 0.00%$0.00 $406,388.00 $213,482.30 $192,905.70 52.53%$11,596.38 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 $128,927.94 ($128,927.94)0.00%$0.00R 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 $2,508.34 ($2,508.34)0.00%$0.00R 601-37160 Water Penalty Active $0.00 $2,700.10 ($2,700.10)0.00%$0.00R 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-39201 Trsfr In *Budget YTD Rev-Exp© 05/03/24 7:45 AM Page 7 Current Period: May 2024 CITY OF SPRING PARK 2024 May YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 Active $0.00 $0.00 $0.00 0.00%$0.00R 601-39311 Trsfr from Water Fund Total Revenue $0.00 $161,482.04 ($161,482.04)0.00%$0.00 Expenditure 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 $3,553.07 $29,521.93 10.74%$0.00E 601-49400-101 Administrator Active $30,940.00 $4,853.16 $26,086.84 15.69%$0.00E 601-49400-102 Clerk Active $42,000.00 $14,926.41 $27,073.59 35.54%$0.00E 601-49400-103 People Service/O Active $19,910.00 $4,211.95 $15,698.05 21.15%$0.00E 601-49400-107 Office Assistant Active $26,000.00 $9,723.46 $16,276.54 37.40%$0.00E 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%$0.00E 601-49400-201 Meters & Supplie Active $0.00 $0.00 $0.00 0.00%$0.00E 601-49400-206 GIS Active $2,000.00 $281.33 $1,718.67 14.07%$33.02E 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,331.59 $2,668.41 33.29%$30.00E 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%$0.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 $1,007.00 $3,993.00 20.14%$28.00E 601-49400-306 Testing Fees Active $5,000.00 $8,219.63 ($3,219.63)164.39%$360.00E 601-49400-310 Contracted Servic Active $1,000.00 $335.92 $664.08 33.59%$0.00E 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 $693.73 $306.27 69.37%$91.66E 601-49400-324 Internet Service Active $4,000.00 $1,375.01 $2,624.99 34.38%$0.00E 601-49400-330 IT Technology Su Active $0.00 $408.33 ($408.33)0.00%$200.58E 601-49400-350 Print/Binding Active $5,500.00 $6,161.48 ($661.48)112.03%$0.00E 601-49400-361 Liability/Prop Ins/ Active $33,000.00 $2,967.52 $30,032.48 8.99%$0.00E 601-49400-381 Utilities/Electric/G Active $11,000.00 $41,183.54 ($30,183.54)374.40%$10,820.00E 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 $135.10 $1,364.90 9.01%$33.12E 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)($213,482.30)($192,905.70)52.53%($11,596.38) ($354,387.74)Total WATER FUND ($406,388.00)($52,000.26)12.80%($11,596.38) SEWER FUND Revenues Expenditures Gain/(Loss)($694,329.30)($57,848.20)($636,481.10)8.33%($21,926.94) $0.00 $173,661.37 -$173,661.37 0.00%$0.00 $694,329.30 $231,509.57 $462,819.73 33.34%$21,926.94 Revenue *Budget YTD Rev-Exp© 05/03/24 7:45 AM Page 8 Current Period: May 2024 CITY OF SPRING PARK 2024 May YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 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 Active $0.00 $170,271.56 ($170,271.56)0.00%$0.00R 602-37200 Sewer Sales Active $0.00 $3,389.81 ($3,389.81)0.00%$0.00R 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-39201 Trsfr In Active $0.00 $0.00 $0.00 0.00%$0.00R 602-39312 Trsfr from Sewer Fun Total Revenue $0.00 $173,661.37 ($173,661.37)0.00%$0.00 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 $3,553.07 $29,521.93 10.74%$0.00E 602-49450-101 Administrator Active $30,940.00 $4,853.16 $26,086.84 15.69%$0.00E 602-49450-102 Clerk Active $42,000.00 $14,926.40 $27,073.60 35.54%$0.00E 602-49450-103 People Service/O Active $21,151.00 $4,211.95 $16,939.05 19.91%$0.00E 602-49450-107 Office Assistant Active $26,000.00 $9,723.36 $16,276.64 37.40%$0.00E 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 $281.31 $1,218.69 18.75%$33.02E 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%$0.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,839.06 $660.94 73.56%$0.00E 602-49450-310 Contracted Servic Active $1,000.00 $335.92 $664.08 33.59%$0.00E 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 $693.73 $306.27 69.37%$91.66E 602-49450-324 Internet Service Active $270,000.00 $106,312.04 $163,687.96 39.37%$21,568.56E 602-49450-327 MCES Sewer Ser Active $10,000.00 $1,374.99 $8,625.01 13.75%$0.00E 602-49450-330 IT Technology Su Active $250.00 $408.33 ($158.33)163.33%$200.58E 602-49450-350 Print/Binding Active $4,500.00 $5,041.22 ($541.22)112.03%$0.00E 602-49450-361 Liability/Prop Ins/ Active $15,000.00 $3,052.47 $11,947.53 20.35%$0.00E 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 $135.10 $464.90 22.52%$33.12E 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 ($12,425.00)$32,425.00 -62.13%$0.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 *Budget YTD Rev-Exp© 05/03/24 7:45 AM Page 9 Current Period: May 2024 CITY OF SPRING PARK 2024 May YTD Balance % of Budget 2024 YTD Budget YTD Amt MTD Amt 2024 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 Total Expenditure ($694,329.30)($231,509.57)($462,819.73)33.34%($21,926.94) ($636,481.10)Total SEWER FUND ($694,329.30)($57,848.20)8.33%($21,926.94) 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-41000-405 Depreciation Active $0.00 $0.00 $0.00 0.00%$0.00E 999-43000-121 PERA/FICA/Hosp Active $0.00 $0.00 $0.00 0.00%$0.00E 999-43000-405 Depreciation Active $0.00 $0.00 $0.00 0.00%$0.00E 999-43000-500 Capital Outlay Active $0.00 $0.00 $0.00 0.00%$0.00E 999-45000-405 Depreciation 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)($1,031,286.07)($166,710.23)86.08%($58,271.58) City of Spring Park 4349 WARREN AVENUE, SPRING PARK, MINNESOTA 55384-9711 (952) 471-9051 FAX (952) 471-9160 WWW.CI.SPRING-PARK.MN.US Staff Memo: 2024 Water Treatment Plant Upgrade To: Spring Park – Mayor and Council Subject: Water Treatment Plant Upgrades Since switching to Moore engineering, we have had a couple of walk throughs by Jimm Sepp, a Water Plant expert from Moore. He has sent information to the city regarding upgrades that are recommended and needed. The first phase of the Water Treatment Plant Upgrades is to upgrade its programming. Currently, our system that we have no longer has technical support. The plan (attached) is to completely overhaul this so we no longer have control issues, and the software can be operated remotely as needed. This would save time and money for call outs when Quality Flow needs to come assist Orono in fixing issues while also bringing us into 2024 with our technology. The second phase, which can be completed later in 2024, will be a full cleanse (sand blasting, painting, cleaning of filters/backwash/valves, etc.) of the Water Treatment Plant. This is necessary as the treatment plant has not been cleaned in years and the inside needs to be reconditioned. This cleanse will cost roughly $80,000. Staff recommendation – Motion to approve the control upgrades to make for a better and more efficient Treatment Plant. Budget – The cost would come from the Utility Account. This is an un-budgeted item and will show a loss in the 2024 Audit report in 2025. The Water fund can support this cost. Memorandum Page | 1 Water Treatment Plant – Controls System Improvements Memorandum Date: April 30, 2024 Prepared By: James Sepp, PE To: City of Spring Park, Minnesota Subject: Water Treatment Plant – Controls System Improvements We received and reviewed copy of a quotation to the City of Spring Park from Quality Control & Integration (New Prague, MN) for proposed improvements to the water plant control system, dated April 12th, 2024, a copy of which is attached for reference. The control system at the water plant consists of programmable controllers, touchscreens, and instruments which together provide the automation inside the water plant, such as when to start and stop pumps to transfer water and fill tanks, add the correct amount of treatment chemicals, and control the associated treatment processes in sequence. The controls system at the water plant was significantly upgraded last in 2009 and at that time included logic controllers, touchscreen, and components. QC&I has indicated that the existing components are now obsolete and no longer supported by the manufacturer. In addition, the only interface available to operators to operate the system is from an obsolete touchscreen interface inside the water treatment plant that requires physical presence inside the water treatment plant to operate and to view current operating conditions and set points (such as tank levels, fault or alarm conditions, etc.). It is also very slow and cumbersome to operate and is at the end of its expected service life. A few other controls system issues were identified in my Memorandum of March 11th, 2024, including the lack of a flow meter to measure and control filter backwash flow rates, no set points available to set and maintain constant and consistent treatment flow rates through the plant, and lack of chemical feed rate proportioning control for the chemical pumps. Some of the programming functions built into the existing control panels are unknown by the current operators and do not provide desired operational flexibility and control. In addition, the operations staff do not have a way to remotely interface with and perform routine operations monitoring and control. QC&I’s proposal includes a major overhaul of the water treatment plant control system, including new and current logic controllers, input/output modules, a new color touchscreen operator interface, remote access capability, and re-development of the programming functions. The new color touchscreen operator interface will be provided to better (graphically) represent the equipment and processes being controlled. Additional alarms will be created to alert the operations staff of alarm or failure conditions. A secure remote access / firewall appliance will be added, in conjunction with City’s IT staff, to facilitate staff being able to remotely view operation of the plant on any Internet connected smart device. In addition, a new flow meter will be provided to better monitor and control the filter backwashing process, and to alert operators if or when an inappropriate backwash flow rate 2 Carlson Pkwy N, Ste 110, Plymouth, MN 55447 T: 320.281.5493 mooreengineeringinc.com Memorandum Page | 2 Water Treatment Plant – Controls System Improvements (which can result in filter media washout) is happening. We recommend proceeding with these improvements due to the age and obsoletion of the current controls system and providing the described improvements to the plant controls. QUALITY CONTROL & INTEGRATION, INC. Phone: (952) 758-9445 Fax: (952) 758-9661 Page 1 of 2 Re: Spring Park, MN; WTP; Controls Rehabilitation Quotation Number: 20240321BJTJPM Quality Control & Integration is pleased to provide a quotation in accordance with your request and as follows: Item A – Control Upgrade: Water Treatment Plant; Control Panel Upgrades; Furnish and install new PLC and I/O modules to replace the existing (now obsolete) Sixnet PLC and I/O modules. The controls will be modified at both the existing main control cabinet as well as the existing remote I/O cabinet that was added in support of the TCE removal system. Ladder logic will be re-written to facilitate the automation of the existing pumps, valves, and blowers as originally designed, but on a currently supported hardware platform (Allen-Bradley CompactLogix). Several enhancements have been requested which will make the plant easier to run, more flexible in application, and to provide more complete user feedback. In addition, the color touchscreen operator interface will be enhanced to better (graphically) represent the equipment and processes being controlled. Additional alarms will be created to alert the operator of a failed valve and the logic will be enhanced to allow the filter backwash routine to continue in the event of a failed zone valve on the filter. A secure remote access / firewall appliance will be added, in conjunction with City’s IT staff, to facilitate staff being able to remotely view operation of the plant on any Internet connected smart device. Additionally, this remote device will facilitate access by QFS Engineering staff to allow for remote troubleshooting and / or modifications to the code without the added time and expense of travel to the site. To include: Qty Description 1 PLC; Allen Bradley CompactLogix 1769-L33ER; to replace Sixnet iPM A/R I/O modules; A-B 1769 Series; for within the existing main cabinet; to replace all Sixnet I/O 1 Ethernet Expansion Module; Allen-Bradley 1669-AENTR; for expansion cabinet A/R I/O modules; A-B 1769 Series; for within the existing expansion cabinet; to replace all Sixnet Ethertrack I/O 1 Ethernet Switch; Unmanaged; gig-speed 1 Remote Access / Firewall Appliance; Ewon Cosy A/R Terminal Block; Single; 18-10AWG A/R Cabling; for between main cabinet and remote I/O cabinet A/R Programming of PLC and Operator Interface A/R Configuration of Remote Access / Firewall appliance A/R Field installation of new PLC & I/O devices and terminations to all existing equipment Total Sell Price for Item A is $77,890.00 Optional Item B – Replacement of Operator interface with Allen-Bradley Version: Operator Interface Upgrade; Furnish and install a new Allen-Bradley PanelView Plus 7 Operator Interface. To include: Qty Description 1 Allen-Bradley; PanelView Plus 7 Operator Interface; 15-inch A/R Field installation of new Operator Interface in existing Main Control Panel door Total Sell Price for Item B is $6,800.00 - Deduct $1,200.00 to utilize a 10” OIT vs. the 15” above Quotation To: City Engineer – Spring Park, MN Attn: Mr. Jim Sepp Date: 04/12/2024 From: Pat Malay Phone: (952) 758-9445 Engineer: N/A QUALITY CONTROL & INTEGRATION, INC. Phone: (952) 758-9445 Fax: (952) 758-9661 Page 2 of 2 Optional Item C – 8” NSF61 Flowmeter Installed: Furnish and install a new 8” flowmeter in the Backwash Line; To include: To include: Qty Description 1 Rosemount Model 8750W, 8” flange style flowmeter with NSF 61 rating. To include integral mount transmitter with local operator interface and display, scalable 4-20ma and pulse output. A/R Field installation of new flowmeter and desired programming addition. To include necessary piping fittings. Total Sell Price for Item C is $8,870.00 Sincerely, Patrick Malay Patrick Malay