Loading...
HomeMy WebLinkAbout05(A) - Approval of Claims Listing Report Payments Issued 4/23/2022 - 5/6/2022 DateChecksACHEFTTotal 4/25/2022 1,386.19 1,386.19 4/26/2022 360.00 360.00 4/28/2022 16,482.31 16,482.31 4/29/2022 122,291.39 265,896.73 34,871.29 423,059.41 5/2/2022 790.52 790.52 5/5/2022 87,724.42 242,962.45 344.06 331,030.93 210,015.81 508,859.18 54,234.37 773,109.36 ITEM: 5A CITY COUNCIL AGENDA REPORT MEETING DATE: May 16, 2022 PREPARED BY: Janet Ringberg, Accounting Specialist PRESENTED BY: Cathy Ericksonson, Finance Director AGENDA ITEM: Approval of Claims Listing GOAL AREA High-Value City Services OBJECTIVE: 1. Establish financial stability for all funds. RECOMMENDED ACTION: Adopt claims listing as presented. BACKGROUND: The current claims listing is a check register which includes a chronological listing of payments issued (check, EFT, ACH, and wires) with the associated vendor and description of the claim paid. The option to include a general ledger account number is not available with this report. At the request of the Council and City Manager we have included the payroll paid, by department, for the previous month. We are providing the information in the same format as the quarterly expenditure financial reporting and will provide it on a monthly basis. As a reminder, the city pays wages two weeks in arrears and some pay is seasonal and overtime. ALTERNATIVES: 1. Motion and second as part of the consent agenda to adopt the claims list as presented. 2. Motion and second to remove the claims list from the consent agenda for additional discussion. ATTACHMENTS: 1. 5A Claims Listing 05 16 2022 City of Prior Lake | 4646 Dakota Street SE | Prior Lake MN 55372 CHECK REGISTER FOR CITY OF PRIOR LAKE 1/4Page: 05/09/2022 09:52 AM User: Janet DB: Prior Lake CHECK DATE FROM 04/23/2022 - 05/06/2022 AmountDescriptionVendor NameVendorCheckBankCheck Date Bank 1 General Bank 1,386.19 2022 Dental ClaimsDELTA DENTAL000272138487(E)104/25/2022 360.00 Apr 2022 HSA Admin FeesALERUS000013758488(E)104/26/2022 103.18 MileageBEAU JOHNSON000281458489(A)104/29/2022 35.00 Recharge Fire ExtinguisherCENTRAL FIRE PROTECTION000033008490(A)104/29/2022 1,905.00 IT SupportCOMPUTER INTEGRATION TECH000037608491(A)104/29/2022 1,600.00 BootsFIRE EQUIPMENT SPECIALTIES INC000064558492(A)104/29/2022 71.25 Baker - Initial UniformGALLS LLC000070758493(A)104/29/2022 180.20 Baker - Initial Uniform 99.98 Mager - Uniform Shirts (28.01)Return Handcuffs 323.42 6,415.39 Water Treatment ChemicalsHAWKINS INC000083128494(A)104/29/2022 1,443.75 Ponds & Memorial Park ImprovementsHOISINGTON KOEGLER GROUP INC000087308495(A)104/29/2022 6,437.84 Lakefront Park - Watzl's Beach Master Pl 7,881.59 49.15 3 Hole PunchINNOVATIVE OFFICE SOLUTIONS LLC000271498496(A)104/29/2022 278.99 Toner 18.33 Erickson - Name Plate 48.34 DeMars - Business Cards 124.37 Misc Office Supplies 103.99 Misc Office Supplies 623.17 2,800.34 2022 Annual Subscription IRTH SOLUTIONS INC000098408497(A)104/29/2022 15,500.00 2021 YE AuditMMKR & CO000137498498(A)104/29/2022 1,317.14 ApparelNORTH AMERICAN SAFETY000145748499(A)104/29/2022 227,200.00 2022 Tax Assessment ContractSCOTT COUNTY000192128500(A)104/29/2022 15.40 450 Accident repair WOLF MOTOR CO INC000236758501(A)104/29/2022 177.10 450 Accident repair 192.50 16,482.31 Apr 2022 Natural Gas BillsCENTERPOINT ENERGY000135708502(E)104/28/2022 790.52 2022 Dental ClaimsDELTA DENTAL000272138503(E)105/02/2022 34,871.29 Apr 2022 Electric BillsXCEL ENERGY000147208504(E)104/29/2022 89.55 Welder supplies AIRGAS USA LLC000013138505(A)105/05/2022 260.23 Mileage, Misc ReimbursementsANDREW BROTZLER000276748506(A)105/05/2022 392.00 Planned Maintenance - WTFBARNUM GATE SERVICES INC000020978507(A)105/05/2022 221.00 Dakota & Evanston Intersection Control EBOLTON & MENK INC000026378508(A)105/05/2022 32,105.00 Utility Billing SoftwareBS&A SOFTWARE000268418509(A)105/05/2022 93.58 MileageCHRISTINE WATSON000279068510(A)105/05/2022 173.16 MileageCONRAD ADELMANN000281518511(A)105/05/2022 6,998.00 May 2022 CleaningCOVERALL000275718512(A)105/05/2022 153.94 9220 and 9221N Laptop mounts EMERGENCY AUTOMOTIVE TECH INC000054808513(A)105/05/2022 905.96 9201N Squad supplies 710.50 9201N Fire Squad supplies 1,770.40 5,356.34 Grub ControlFARMERS MILL & ELEVATOR INC000276328514(A)105/05/2022 CHECK REGISTER FOR CITY OF PRIOR LAKE 2/4Page: 05/09/2022 09:52 AM User: Janet DB: Prior Lake CHECK DATE FROM 04/23/2022 - 05/06/2022 AmountDescriptionVendor NameVendorCheckBankCheck Date 285.00 9220 Decals GRAFIX SHOPPE000076158515(A)105/05/2022 775.00 9216 Decals 1,060.00 2,070.00 Howard Lake Park ConceptHOISINGTON KOEGLER GROUP INC000087308516(A)105/05/2022 1,431.34 Motor Replacement - CHHUMERATECH000271848517(A)105/05/2022 880.16 Replace Motor - PD 2,311.50 137.11 Name PlatesINNOVATIVE OFFICE SOLUTIONS LLC000271498518(A)105/05/2022 45.69 Coy business Cards 11.22 Glue Sticks 42.38 Club Prior Logo 34.58 Wall Clock (8.50)Return Wall File 262.48 69.94 PartsKULLY SUPPLY INC000119408519(A)105/05/2022 425.00 2022 Vactor Discharge Permit FeeMETROPOLITAN COUNCIL000134008520(A)105/05/2022 475.00 2022 WTP Discharge Permit 152,056.76 May 2022 Waste Water Service 152,956.76 245.48 Paper ProductsNETWORK SERVICES COMPANY000143818521(A)105/05/2022 379.44 Paper Products 22.94 Paper Products 647.86 919.00 Mar 2022 Labor & EmploymentNILAN JOHNSON LEWIS000081238522(A)105/05/2022 219.38 8508 Garbage truck lid NOVAK COMPANIES000149008523(A)105/05/2022 84.84 508 Garbage truck 275.00 8508 Parts for Garbage Truck 579.22 612.84 Mar 2022 Data & SoftwarePRECISE MOBILE RESOURCE MGMT000165488524(A)105/05/2022 6,397.11 Lakefront Park Camera AdditionsPRO-TEC DESIGN INC000274298525(A)105/05/2022 923.20 Trailer tires ROYAL TIRE INC000187328526(A)105/05/2022 120.00 SErvice - LibraryTRI COUNTY WATER METRO SOUTH000052478527(A)105/05/2022 5,784.12 450 Accident repair parts WOLF MOTOR CO INC000236758528(A)105/05/2022 95.70 7131 Water Pump Assembly 610.20 450 accident repair parts 31.66 7131 Seal Assembly 2.35 7131 Gasket 6,524.03 5,976.25 TRN20-000001 Fish Pt Road Eng SvcsWSB & ASSOCIATES INC000237808529(A)105/05/2022 3,625.50 TH 13 Trail Grant Project 86.00 Kiehm 170th Street Replacement Plan Revi 1,651.25 Kiehm Storage 1,564.25 Revere Place 2,769.00 General Engineering Support CHECK REGISTER FOR CITY OF PRIOR LAKE 3/4Page: 05/09/2022 09:52 AM User: Janet DB: Prior Lake CHECK DATE FROM 04/23/2022 - 05/06/2022 AmountDescriptionVendor NameVendorCheckBankCheck Date 1,206.25 Jeffers Pond - Outlot C - First Addition 725.00 Pike Lake Landing - Commercial 2,002.75 Preserve at Jeffers Pond 19,606.25 443.00 Fuel Island Pump HosesZAHL-PETROLEUM MAINTENANCE CO000261258530(A)105/05/2022 344.06 May 2022 Vision PremiumsEYEMED000279178531(E)105/05/2022 880.75 EMS SuppliesBOUND TREE MEDICAL LLC00002695110007104/29/2022 1,554.41 RockBRYAN ROCK PRODUCTS INC00002905110008104/29/2022 403.60 7133 Backup Camera SystemDEALER AUTOMOTIVE SERVICES INC00027665110009104/29/2022 334.89 7133 Power inverter 738.49 14.25 Tabs - 2021 Ford #53665DEPUTY REGISTRAR #16000004400110010104/29/2022 1,780.13 Repair Ladder L-9280EMERGENCY APPARATUS MAINT00005475110011104/29/2022 27,750.00 Two Outdoor Warning Sirens and Power SupFEDERAL SIGNAL CORPORATION00027724110012104/29/2022 11,450.00 PW Team FacilitatorINNOVATIVE GROWTH LLC00028144110013104/29/2022 20,210.00 Weapon Order KIESLER POLICE SUPPLY00027905110014104/29/2022 713.73 9216 Blower motor controlLARSON COMPANIES00012320110015104/29/2022 172.75 Old tire disposalLIBERTY TIRE RECYCLING LLC00012628110016104/29/2022 250.00 Signal & Light Recert Training - KleistMN DEPT OF TRANSPORTATION00013826110017104/29/2022 52,986.43 1st Qtr 2022 UnemploymentMN UC FUND00013734110018104/29/2022 30.45 Interpreter ServicesOFFICE OF MN IT SERVICES00004396110019104/29/2022 790.00 SeedRAMY TURF PRODUCTS00018173110020104/29/2022 90.64 785 Quick coupler RDO EQUIPMENT COMPANY00018230110021104/29/2022 1,279.36 GlovesSTREICHERS00019900110022104/29/2022 1,600.00 Annual Sprinkler InspectionsSUMMIT FIRE PROTECTION CO00019949110023104/29/2022 276.13 Coffee, TeaARAMARK REFRESHMENT SERVICES00001772110024105/05/2022 126.00 Apr 2022 Yoga InstructorASHLEY BITZAN00028004110025105/05/2022 3,966.37 506 Holder Oil Cooler CUSHMAN MOTOR COMPANY INC00003980110026105/05/2022 90.00 Water Efficiency RebateDEREK KLOSSNERREFUND-MSC110027105/05/2022 4,869.42 Water MetersFERGUSON WATERWORKS #251600006231110028105/05/2022 4,919.20 Water Meters 2,320.00 Water Meters 12,108.62 10,349.00 Park Benches & PlaquesFLAGSHIP RECREATION LLC00006615110029105/05/2022 24.00 May 2022 Go To Meeting LicenseGOTO TECHNOLOGIES USA INC00026895110030105/05/2022 509.90 Light Repair - MCHAYES ELECTRIC INC00008315110031105/05/2022 137.12 Mecatronic Fans HUGHES-PETERS00028142110032105/05/2022 960.00 Heartsaver First Aid/ Adult CPR/ AEDMDEWAKANTON PUBLIC SAFETY00013287110033105/05/2022 431.14 LumberMENARDS LUMBER CO00013318110034105/05/2022 17,221.05 Apr2022 SAC ChargesMETROPOLITAN COUNCIL-SAC00013406110035105/05/2022 198.09 526 Deck SpindleMIDWEST MACHINERY CO00028113110036105/05/2022 2,994.00 Graffiti RemovalMJV SERVICES LLC00028146110037105/05/2022 45.00 Hentges - Wastewater Cert RenewalMN POLLUTION CONTROL AGCY00013850110038105/05/2022 3,300.00 543 Used Truck BoxPICKUP PARTS UNLIMITED MN00028149110039105/05/2022 33.00 PropanePRIOR LAKE RENTAL CENTER00016700110040105/05/2022 28,338.00 Outlet Channel Cost SharePRIOR LAKE-SPRING LAKE00016820110041105/05/2022 395.18 PaintSHERWIN-WILLIAMS CO00019456110042105/05/2022 84.00 Troubleshoot FMUSYN-TECH SYSTEMS 00028147110043105/05/2022 601.06 ChlorineUSA BLUEBOOK00021882110044105/05/2022 5,481.76 May 2022 Cell Phone BillsVERIZON WIRELESS00001315110045105/05/2022 55.00 May 2022 Shredding ServiceVETERAN SHREDDING LLC00027643110046105/05/2022 1 TOTALS: 773,109.36 Total of 85 Checks: CHECK REGISTER FOR CITY OF PRIOR LAKE 4/4Page: 05/09/2022 09:52 AM User: Janet DB: Prior Lake CHECK DATE FROM 04/23/2022 - 05/06/2022 AmountDescriptionVendor NameVendorCheckBankCheck Date 773,109.36 Total of 85 Disbursements: 0.00 Less 0 Void Checks: City of Prior Lake Expenditures- Payroll and BenefitsAs of 4/30/2022 (Preliminary & Unaudited)Activity for Activity for Variance from VariancePrevious Month Month 2022 2022 2022 Amended Budget ‐ % BDGTActual YTDfrom 20213/31/2022 4/30/2022 Budget Amended Actual YTD Positive (Negative) USED4/30/2021 Positive (Negative)GENERAL FUNDFunction: General Government41110.00 MAYOR & COUNCIL 5,223                          5,647                          68,728                 68,728                 19,999                 48,729                               29% 20,433                     434                                         41320.00 ADMINISTRATION 20,743                        27,466                        276,235               276,235               77,892                 198,343                            28% 56,591                     (21,301)                                  41330.00 BOARDS & COMMISSIONS 538                             323                             10,765                 10,765                 861                       9,904                                 8% 1,476                       615                                         41400.00 CITY CLERK FUNCTIONS 12,511                        118                             128,447               128,447               27,645                 100,802                            22% 33,055                     5,410                                     41410.00 ELECTIONS‐                                   77                                57,690                 57,690                 154                       57,536                               0% 171                           17                                           41520.00 FINANCE 34,896                        41,496                        570,810               570,810               136,441               434,369                            24% 150,727                   14,286                                   41820.00 HUMAN RESOURCES 22,202                        22,923                        287,689               287,689               79,342                 208,347                            28% 75,647                     (3,695)                                    41830.00 COMMUNICATIONS 213                             17,761                        142,261               142,261               31,106                 111,155                            22% 31,928                     821                                         41910.00 COMMUNITY DEVELOPMENT 18,566                        23,608                        335,822               335,822               68,323                 267,499                            20% 84,986                     16,663                                   41920.00 INFORMATION TECHNOLOGY 18,017                        18,339                        239,241               239,241               64,622                 174,619                            27% 61,935                     (2,687)                                    41940.00 FACILITIES ‐ CITY HALL 6,642                          7,195                          88,220                 88,220                 26,050                 62,170                               30% 13,753                     (12,297)                                  Total ‐ Function General Government 139,552                      164,952                      2,205,908            2,205,908            532,436               1,673,472                         24% 530,701                   (1,735)                                    Function: Public Safety42100.00 POLICE 380,075                      505,046                      5,445,654            5,445,654            1,537,990            3,907,664                         28% 1,299,823                (238,168)                                42200.00 FIRE 46,267                        59,439                        900,773               900,773               177,757               723,016                            20% 153,547                   (24,211)                                  42400.00 BUILDING INSPECTION 51,971                        60,897                        784,947               784,947               198,234               586,713                            25% 185,154                   (13,081)                                  Total ‐ Function Public Safety 478,313                      625,382                      7,131,374            7,131,374            1,913,982            5,217,392                         27% 1,638,523                (275,459)                                Function: Public Works43050.00 ENGINEERING 26,809                        27,182                        359,793               359,793               92,192                 267,601                            26% 89,765                     (2,426)                                    43100.00 STREET 34,122                        38,867                        537,643               537,643               136,672               400,971                            25% 146,685                   10,013                                   43400.00 CENTRAL GARAGE 18,491                        19,612                        262,456               262,456               70,040                 192,416                            27% 66,583                     (3,457)                                    Total ‐ Function Public Works 79,423                        85,661                        1,159,892            1,159,892            298,904               860,988                            26% 303,034                   4,130                                     Function: Culture and Recreation45100.00 RECREATION 19,067                        33,013                        377,023               377,023               85,939                 291,084                            23% 74,801                     (11,138)                                  45200.00 PARKS 74,639                        86,777                        1,162,215            1,162,215            293,108               869,107                            25% 247,422                   (45,685)                                  Total ‐ Function Culture and Recreation 93,706                        119,790                      1,539,238            1,539,238            379,047               1,160,191                         25% 322,224                   (56,824)                                  General Fund Payroll Only Expenditures Total 790,993                      995,785                      12,036,412         12,036,412         3,124,369            8,912,043                         26% 2,794,482                (329,887)                                COMPARATIVEAnnual City of Prior Lake Expenditures- Payroll and BenefitsAs of 4/30/2022 (Preliminary & Unaudited)Activity for Activity for Variance from VariancePrevious Month Month 2022 2022 2022 Amended Budget ‐ % BDGTActual YTDfrom 20213/31/2022 4/30/2022 Budget Amended Actual YTD Positive (Negative) USED4/30/2021 Positive (Negative)COMPARATIVEAnnualEDA FUNDFunction:  Economic Development   46500.00 ECONOMIC DEVELOPMENT 8,578                          10,783                        143,239               143,239               35,621                 107,618                            25% 41,744                     6,124                                     EDA Fund Payroll Only Expenditures Total 8,578                          10,783                        143,239               143,239               35,621                 107,618                            25% 41,744                     6,124                                     WATER FUNDFunction: Water41520.00 Finance 6,164                          6,235                          84,371                 84,371                 22,109                 62,262                               26% 21,193                     (916)                                       49400.00 Water 65,327                        78,548                        794,320               794,320               247,759               546,561                            31% 207,887                   (39,873)                                  Water Fund Payroll Only Expenditures Total 71,491                        84,782                        878,691               878,691               269,869               608,822                            31% 229,080                   (40,789)                                  SEWER FUNDFunction: Sewer41520.00 Finance 6,163                          6,234                          84,371                 84,371                 22,106                 62,265                               26% 21,190                     (916)                                       49450.00 Sewer 48,502                        50,710                        786,039               786,039               202,118               583,921                            26% 219,074                   16,955                                   Sewer Fund Payroll Only Expenditures Total 54,664                        56,944                        870,410               870,410               224,224               646,186                            26% 240,264                   16,040                                   STORM WATER FUNDFunction: Storm Water49420.00 Water Quality 25,986                        26,641                        356,875               356,875               99,442                 257,433                            28% 94,292                     (5,149)                                    Storm Water Fund Payroll Only Expenditures Total 25,986                        26,641                        356,875               356,875               99,442                 257,433                            28% 94,292                     (5,149)                                    City‐Wide Total Payroll Expenditures 951,712                     1,174,935                  14,285,627         14,285,627         3,753,524           10,532,103                      26% 3,399,862               (353,662)