The URL can be used to link to this page

Home My WebLink About5A Claims Listing Agenda Report Phone 952.447.9800 / Fax 952.447.4245 / www.cityofpriorlake.com 4646 Dakota Street SE Prior Lake, MN 55372 CITY COUNCIL AGENDA REPORT MEETING DATE: SEPTEMBER 16, 2019 AGENDA #: 5A PREPARED BY: JANET RINGBERG, ACCOUNTING SPECIALIST PRESENTED BY: CATHY ERICKSON, FINANCE DIRECTOR AGENDA ITEM: CONSIDER APPROVAL OF CLAIMS LISTING DISCUSSION: Introduction The purpose of this agenda item is to provide the City Council with a listing of in- voices that have been paid within a specific time period pursuant to MN Statute 471.38 Subd. 3a. Current Circumstances 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. Payments Issued 8/24/2019 – 9/6/2019 Date Checks ACH EFT Totals 8/26/2019 1,422.52 1,422.52 8/27/2019 336.00 336.00 8/28/2019 461.40 461.40 8/29/2019 130,814.84 44,752.47 175,567.31 8/30/2019 46,473.35 46,473.35 9/3/2019 3,359.16 3,359.16 9/4/2019 1,052.45 1,052.45 9/5/2019 1,643.02 1,643.02 9/6/2019 136,777.30 155,832.73 292,610.03 267,592.14 200,585.20 54,747.90 522,925.24 Issues The City Council has asked why payroll payments are not included with the claims listing. MN Statute 471.38 Subd. 2 states “The provisions of this section do not apply to any claim or demand for an annual salary or fees of jurors or witnesses, fixed by law, nor to the salary or wages of any employee whose salary or wages have been fixed on an hourly, daily, weekly or monthly basis, by the governing board of the municipality, and which is now authorized by law to be paid on a payroll basis.” This means that the Council approved budget, which includes payroll, does not need to be approved again or separately by the Council. Payroll information has historically been included as part of the expenditures in the Quarterly Financial Report provided to the Council. 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. Overall, the payroll information is more meaningful on a quarterly basis. Conclusion The Council should consider approving the attached report on claims paid as part of the consent agenda. 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 RECOMMENDED MOTION: Alternative 1 CHECK REGISTER FOR CITY OF PRIOR LAKE 1/4Page: 09/09/2019 09:00 AM User: Janet DB: Prior Lake CHECK DATE FROM 08/24/2019 - 09/06/2019 AmountDescriptionVendor NameVendorCheckBankCheck Date Bank 1 General Bank 1,422.52 2019 HRA ClaimsMEDICA000133255077(E)108/26/2019 336.00 Aug 2019 HSA Admin FeesALERUS000013755078(E)108/27/2019 461.40 2019 Dental ClaimsDELTA DENTAL000272135079(E)108/28/2019 845.00 Tow 2007 Dodge Charger #808516ALLEN'S SERVICE INC000013605080(A)108/29/2019 1,295.75 New Squad EquipmentEMERGENCY AUTOMOTIVE TECH INC000054805081(A)108/29/2019 2,968.44 New Squad Equipment 98.89 New Squad Equipment 4,363.08 864.98 452 Sander motor and fittings FORCE AMERICA000067735082(A)108/29/2019 103.81 Misc Office SuppliesINNOVATIVE OFFICE SOLUTIONS LLC000271495083(A)108/29/2019 30.61 525 Deck wheel MTI DISTRIBUTING INC000139515084(A)108/29/2019 150.67 Embroidered ClothingNORTH AMERICAN SAFETY000145745085(A)108/29/2019 89.00 Earplugs 239.67 96.00 523 Transaxle repair NOVAK COMPANIES000149005086(A)108/29/2019 4,064.48 789 Loader wing refurbishment 4,160.48 4,122.26 Transportation PlanSRF CONSULTING GROUP INC000196925087(A)108/29/2019 51.50 488 Fuel line TITAN MACHINERY000205235088(A)108/29/2019 7,174.62 AsphaltWM MUELLER & SONS INC000236455089(A)108/29/2019 8,720.22 Asphalt 15,894.84 21.03 396 repair WOLF MOTOR CO INC000236755090(A)108/29/2019 2,272.50 TRN18-000001 2018 Recon ProjectWSB & ASSOCIATES INC000237805091(A)108/29/2019 345.00 Haven Ridge 3rd DEV19-000017 405.78 Jul 2019 Traffic Safety Community Engage 4,385.00 Comprehensive Parks Master Plan 2,743.00 2019 Watermain Project 1,950.00 2019 County Road 21 Trail Project 1,471.00 TRN19-0000005 Const Material Testing 13,572.28 149.97 Brush mower parts ZIEGLER INC000265005092(A)108/29/2019 332.96 Skid loader couplers 482.93 3,359.16 2019 HRA ClaimsMEDICA000133255093(E)109/03/2019 1,844.88 Aug 2019 Natural Gas CENTERPOINT ENERGY000135705096(E)108/30/2019 44,628.47 Aug 2019 Electric BillsXCEL ENERGY000147205097(E)108/30/2019 1,643.02 2019 Dental ClaimsDELTA DENTAL000272135098(E)109/05/2019 2,400.00 Aug 2019 Animal Control4 PAWS ANIMAL CONTROL LLC000067985099(A)109/06/2019 1,545.00 Tow Ford F150 #33253ALLEN'S SERVICE INC000013605100(A)109/06/2019 300.00 Store Mazda 2TR #179532 1,845.00 CHECK REGISTER FOR CITY OF PRIOR LAKE 2/4Page: 09/09/2019 09:00 AM User: Janet DB: Prior Lake CHECK DATE FROM 08/24/2019 - 09/06/2019 AmountDescriptionVendor NameVendorCheckBankCheck Date 31.90 MileageAMANDA SCHWABE000276065101(A)109/06/2019 357.08 Per Diem/ MileageANDREW BROTZLER000276745102(A)109/06/2019 116.00 MileageCASEY MCCABE000132075103(A)109/06/2019 1,194.00 HP Prodesk 600G4, LED MonitorCOMPUTER INTEGRATION TECH000037605104(A)109/06/2019 1,762.50 Sep 2019 Managed Services 2,956.50 1,040.00 SuppliesELECTRIC PUMP000231205105(A)109/06/2019 220.40 549 Strobe lamps EMERGENCY AUTOMOTIVE TECH INC000054805106(A)109/06/2019 4,080.33 New squad light bars 358.69 New squad equipment 4,659.42 11.01 452 Fittings FORCE AMERICA000067735107(A)109/06/2019 7.92 452 Fittings 18.93 180.00 Change Logo Color on Printed FormsINNOVATIVE OFFICE SOLUTIONS LLC000271495108(A)109/06/2019 99.76 Misc Office Supplies 1.23 Pencil Box 50.00 Olson - Business Cards 13.50 Office Supplies 118.91 Toner 463.40 101.50 MileageKELSEY COY000112625109(A)109/06/2019 58.00 Sensible Land Use Coalition ConferenceKEVIN BURKART000276025110(A)109/06/2019 144.00 3 Quantitative Fit TestsMED-COMPASS INC000133065111(A)109/06/2019 48.00 Quantitative Fit Test 192.00 1,144.50 Library Alarm RepairMETRO ALARM CONTRACTORS INC000133545112(A)109/06/2019 128,727.37 Sep 2019 Waste Water ServiceMETROPOLITAN COUNCIL000134005113(A)109/06/2019 131.20 452 Sander refurbishment NOVAK COMPANIES000149005114(A)109/06/2019 619.50 May 2019 Data & SoftwarePRECISE MOBILE RESOURCE MGMT000165485115(A)109/06/2019 725.88 AsphaltWM MUELLER & SONS INC000236455116(A)109/06/2019 41.99 756 Leaf spring repair WOLF MOTOR CO INC000236755117(A)109/06/2019 12.56 751 Rear axle repair 54.55 6,502.00 Watzl's Beach Retaining WallWSB & ASSOCIATES INC000237805118(A)109/06/2019 37.50 Winkler Property - WCA Site Review 164.00 Timbercrest Tr Wetland Permitting 3,486.50 Jeffers South Stormwater Pond 10,190.00 15.90 Sep 2019 Merchant FeesAUTHORIZE.NET000268215119(E)109/04/2019 1,036.55 Aug 2019 Merchant FeesPAYMENT SERVICE NETWORK INC000161415120(E)109/04/2019 250.00 742 Navy pump repair A & B AUTO ELECTRIC INC00001010104561108/29/2019 55.92 538 Hose repair ABLE HOSE & RUBBER CO00001115104562108/29/2019 164.37 536 Spray wand ALTEC INDUSTRIES INC00027400104563108/29/2019 CHECK REGISTER FOR CITY OF PRIOR LAKE 3/4Page: 09/09/2019 09:00 AM User: Janet DB: Prior Lake CHECK DATE FROM 08/24/2019 - 09/06/2019 AmountDescriptionVendor NameVendorCheckBankCheck Date 6,959.59 Refund Tower Lease OverpmtAT&TREFUND-MSC104564108/29/2019 691.00 2019 Ground Water QUALITY MonitoringBARR ENGINEERING CO00002113104565108/29/2019 985.00 2019 Ground Water QUALITY Monitoring 1,676.00 1,297.70 Stock pickup tires BAUER BUILT INC00002145104566108/29/2019 2,500.00 18-2065 3293 Wilds Ridge NWCUDDIGAN CUSTOM BUILDERS LLCMISC-CD104567108/29/2019 221.60 Sign MaterialsEARL F ANDERSEN INC00005175104568108/29/2019 5,399.29 Water MetersFERGUSON WATERWORKS #251600006231104569108/29/2019 40.00 Repair Turn Out GearFIRE EQUIPMENT SPECIALTIES INC00006455104570108/29/2019 3,769.45 Final - Stormwater InfrastructureGF JEDLICKI INC00027552104571108/29/2019 44.20 SuppliesGRAINGER INC00023030104572108/29/2019 91,761.58 #10 TRN18-000001HESELTON CONSTRUCTION00027362104573108/29/2019 6,930.00 2018 Annual TIF ReportingNORTHLAND SECURITIES INC00014775104574108/29/2019 1,470.00 Utility Study 8,400.00 100.00 One Stroke Painting InstructorROCHELLE BERTRAM00027678104575108/29/2019 240.29 Cash ICR #19007785SCOTT COUNTY ATTORNEY00019232104576108/29/2019 208.38 526 Deck spindle SEMA EQUIPMENT INC00026973104577108/29/2019 120.15 Cash ICR #19007785STATE TREASURER00019796104578108/29/2019 3,937.76 Sep 2019 Cell Phone BillsVERIZON WIRELESS00001315104579108/29/2019 3,668.56 Aug 2019 Cell Phone Bill 7,606.32 581.92 Wilds Booster StationAUTOMATIC SYSTEMS CO00001975104580109/06/2019 496.00 Aug 2019 UmpiresBASER ASSOCIATION00002124104581109/06/2019 2,500.00 18-1411 14953 Hillside Circle NWBELLEPAR HOMES, LLCMISC-CD104582109/06/2019 100.00 Volleyball League WinnerBEN CARLSONREFUND-REC104583109/06/2019 140.00 Aug 2019 Tai Chi InstructorCHRISTINE T MORGAN00027316104584109/06/2019 350.00 Deck Repair - 4664 Dakota St SECOLTEN HINDERKSREFUND-MSC104585109/06/2019 2,500.00 17-1167 14192 Shady Beach Drive NECOPPER CREEK REAL ESTATEMISC-CD104586109/06/2019 186.13 Meter Replacement Door HangersCREATIVE GRAPHICS00003930104587109/06/2019 165.48 Aug 2019 Bottled WaterCULLIGAN BOTTLED WATER00003958104588109/06/2019 100.00 Volleyball League WinnerDANIELLE RASMUSSENREFUND-REC104589109/06/2019 152.36 Stock batteryFACTORY MOTOR PARTS COMPANY00006020104590109/06/2019 4,176.00 Meter SuppliesFERGUSON WATERWORKS #251600006231104591109/06/2019 75.00 Spyder PongFRANKLIN SPORTS INC00027683104592109/06/2019 905.88 Street Light RepairHAYES ELECTRIC INC00008315104593109/06/2019 100.00 Volleyball League WinnerHAYLEY HAHNREFUND-REC104594109/06/2019 2,500.00 18-0106 15411 Breezy Point Road SEHIGHMARK BUILDERSMISC-CD104595109/06/2019 93.75 Fall Frenzy - DownpmtHOMEWARD BOUND THEATRE CO00027685104596109/06/2019 469.23 756 Leaf spring KREMER SERVICES LLC00011800104597109/06/2019 36.36 UB - REFUND 302978-98MARK & KIM PETRICHREFUND-UB104598109/06/2019 2,000.00 EMR Initial - 4 New FirefightersMDEWAKANTON PUBLIC SAFETY00013287104599109/06/2019 44,282.70 Aug 2019 SAC ChargesMETROPOLITAN COUNCIL-SAC00013406104600109/06/2019 92.84 523 Deck parts MN EQUIPMENT00026912104601109/06/2019 (25.22)Seeder return 67.62 3,895.71 Promote Customer Traffic in Commercial ANEON LIZARD CREATIVE GRAPHIC DES 00027584104602109/06/2019 32,637.00 Library Re-RoofNORTH CENTRAL INSTALLATION00027673104603109/06/2019 321.21 Locater RepairPOLLLARDWATER00027679104604109/06/2019 18,156.00 MOA Cost Share Outlet ChannelPRIOR LAKE-SPRING LAKE00016820104605109/06/2019 5,207.43 EAB TreatmentRAINBOW TREECARE00018150104606109/06/2019 CHECK REGISTER FOR CITY OF PRIOR LAKE 4/4Page: 09/09/2019 09:00 AM User: Janet DB: Prior Lake CHECK DATE FROM 08/24/2019 - 09/06/2019 AmountDescriptionVendor NameVendorCheckBankCheck Date 150.00 DirtROCK HARD LANDSCAPE SUPPLY00018571104607109/06/2019 42.00 Refund - Betty Dangers TripROSE PECKREFUND-REC104608109/06/2019 100.00 Volleyball League WinnerRYAN GREDENREFUND-REC104609109/06/2019 43.40 Cash ICR #18008457SCOTT COUNTY ATTORNEY00019232104610109/06/2019 13,371.11 JPA Line PaintingSIR LINES-A-LOT00019531104611109/06/2019 21.70 Cash ICR #18008457STATE TREASURER00019796104612109/06/2019 499.45 Training AmmunitionSTREICHERS00019900104613109/06/2019 47.88 Park SuppliesSYNCHRONY BANK00026833104614109/06/2019 9.54 Chain saw repair TIM'S SMALL ENGINE REPAIR INC00020510104615109/06/2019 104.56 Toronto St Light RepairVIKING ELECTRIC SUPPLY00022630104616109/06/2019 191.88 789 Loader repair ZACKS INCORPORATED00026100104617109/06/2019 1 TOTALS: 522,925.24 Total of 99 Disbursements: 0.00 Less 0 Void Checks: 522,925.24 Total of 99 Checks: Expenditures- Payroll Only As of 06/30/2019 (Preliminary & Unaudited) ACTIVITY FOR Variance from Variance from MONTH 2019 2019 2019 Amended Budget - % BDGT 08/31/2018 from 2018 8/31/2019 Budget Amended Actual YTD Positive (Negative)USED Actual YTD Positive (Negative) GENERAL FUND Function: General Government 41110.00 MAYOR & COUNCIL 4,018 48,216 48,216 32,144 16,072 67%26,120 (6,024) 41320.00 ADMINISTRATION 49,682 279,108 279,108 272,249 6,859 98%177,590 (94,659) 41330.00 BOARDS & COMMISSIONS 500 10,000 10,000 5,500 4,500 55%4,700 (800) 41400.00 CITY CLERK FUNCTIONS 9,971 46,058 46,058 33,236 12,822 72%- (33,236) 41410.00 ELECTIONS - - - - - n/a 10,855 10,855 41520.00 FINANCE 42,398 357,827 357,827 228,585 129,242 64%207,451 (21,135) 41820.00 HUMAN RESOURCES 13,808 117,024 117,024 75,270 41,754 64%71,640 (3,630) 41830.00 COMMUNICATIONS 9,646 83,189 83,189 52,724 30,465 63%49,592 (3,132) 41910.00 COMMUNITY DEVELOPMENT 26,253 228,629 228,629 134,907 93,722 59%131,496 (3,411) 41920.00 INFORMATION TECHNOLOGY 13,745 118,162 118,162 76,292 41,870 65%74,299 (1,993) 41940.00 FACILITIES - CITY HALL 7,395 61,434 61,434 40,892 20,542 67%39,510 (1,382) Total - Function General Government 177,414 1,349,647 1,349,647 951,799 397,848 71%793,252 (158,546) Function: Public Safety 42100.00 POLICE 372,286 3,090,997 3,110,197 1,895,239 1,214,958 61%1,772,234 (123,005) 42200.00 FIRE 32,990 328,855 328,855 196,877 131,978 60%195,910 (967) 42400.00 BUILDING INSPECTION 53,996 420,164 420,164 281,271 138,893 67%274,044 (7,227) Total - Function Public Safety 459,271 3,840,016 3,859,216 2,373,387 1,485,829 61%2,242,188 (131,199) Function: Public Works 43050.00 ENGINEERING 14,389 233,208 233,208 114,637 118,571 49%137,146 22,509 43100.00 STREET 28,566 314,132 314,132 172,632 141,500 55%171,480 (1,153) 43400.00 CENTRAL GARAGE 18,531 170,418 170,418 101,972 68,446 60%95,075 (6,897) Total - Function Public Works 61,486 717,758 717,758 389,241 328,517 54%403,701 14,460 Function: Culture and Recreation 45100.00 RECREATION 48,662 237,601 218,401 166,985 51,416 76%185,862 18,877 45200.00 PARKS 127,983 775,214 775,214 502,642 272,572 65%550,664 48,023 Total - Function Culture and Recreation 176,645 1,012,815 993,615 669,627 323,988 67%736,527 66,900 General Fund Payroll Only Expenditures Total 874,817 6,920,236 6,920,236 4,384,053 2,536,183 63%4,175,668 (208,385) COMPARATIVE Annual (Preliminary & Unaudited) ACTIVITY FOR Variance from Variance from MONTH 2019 2019 2019 Amended Budget - % BDGT 08/31/2018 from 2018 8/31/2019 Budget Amended Actual YTD Positive (Negative)USED Actual YTD Positive (Negative) COMPARATIVE Annual EDA FUND Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 11,607 97,587 97,587 68,833 28,754 71%64,571 (4,262) EDA Fund Payroll Only Expenditures Total 11,607 97,587 97,587 68,833 28,754 71%64,571 (4,262) WATER FUND Function: Water 41520.00 Finance 5,610 53,089 53,089 31,721 21,368 60%23,226 (8,494) 49400.00 Water 75,623 496,447 496,447 343,498 152,949 69%295,589 (47,909) Water Fund Payroll Only Expenditures Total 81,232 549,536 549,536 375,218 174,318 68%318,815 (56,403) SEWER FUND Function: Sewer 41520.00 Finance 5,609 50,564 50,564 31,719 18,845 63%23,224 (8,494) 49450.00 Sewer 55,781 477,722 477,722 313,887 163,835 66%289,654 (24,234) Sewer Fund Payroll Only Expenditures Total 61,391 528,286 528,286 345,606 182,680 65%312,878 (32,728) STORM WATER FUND Function: Storm Water 49420.00 Water Quality 34,014 225,752 225,752 153,954 71,798 68%142,672 (11,282) Storm Water Fund Payroll Only Expenditures Total 34,014 225,752 225,752 153,954 71,798 68%142,672 (11,282) City-Wide Total Payroll Expenditures 1,063,060 8,321,397 8,321,397 5,327,665 2,993,732 64%5,014,604 (313,061)