Loading...
HomeMy WebLinkAbout5A 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: JANUARY 21, 2020 AGENDA #: 5A PREPARED BY: JANET RINGBERG, ACCOUNTING SPECIALIST PRESENTED BY: CATHY ERICKSON, FINANCE DIRECTOR AGENDA ITEM: 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 12/28/2019 – 1/10/2020 Date Checks ACH EFT Totals 12/30/2019 2,052.55 2,052.55 12/31/2019 5,623.06 5,523.06 1/3/2020 91,487.91 170,114.15 2,751.50 264,353.56 1/6/2020 28,810.68 28,810.68 1/7/2020 110.00 110.00 1/8/2020 8,966.95 8,966.95 10/10/2020 106,859.69 65,335.24 74,518.71 246,713.64 198,347.60 235,449.39 122,833.45 556,630.44 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/6Page: 01/13/2020 11:47 AM User: Janet DB: Prior Lake CHECK DATE FROM 12/28/2019 - 01/10/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date Bank 1 General Bank 2,052.55 2019 HRA ClaimsMEDICA000133255530(E)112/30/2019 1,465.50 TRN20-000002 Survey & Base MappingBOLTON & MENK INC000026375531(A)101/03/2020 110.00 2020 Membership DuesCHAMBER OF COMMERCE000033705532(A)101/03/2020 300.00 PL-opoly Sponsor 410.00 1,408.00 HP ProDesk, Monitor, AdapterCOMPUTER INTEGRATION TECH000037605533(A)101/03/2020 1,125.00 Jan 2020 CIT Managed Backup 1,762.50 Jan 2020 Managed Services 4,295.50 39.99 Duggan - Short Sleeve ShirtGALLS LLC000070755534(A)101/03/2020 66.82 USB Flash DrivesGRANT PROM000277445535(A)101/03/2020 1,980.00 Dec 2019 GeneralHOFF BARRY PA000273875536(A)101/03/2020 288.75 Dec 2019 Bylaws 123.75 Dec 2019 Data Practices/Open Meeting 660.00 Dec 2019 Finance 206.25 Dec 2019 Franchises 495.00 Dec 2019 PW/Engineering 123.75 Dec 2019 Recreation 495.00 Dec 2019 Comm Dev 495.00 Dec 2019 EDA 618.75 Dec 2019 Enforcement 412.50 Dec 2019 Development 68.75 Dec 2019 Majestic 82.50 Dec 2019 Police 330.00 Dec 2019 Fire 412.50 Dec 2019 Code Pt 3 536.25 Dec 2019 Code Pr 8 330.00 Dec 2019 Code Pt 11 231.25 Dec 2019 Litigation 1,490.75 Dec 2019 Spec Assmt Appeald 123.75 Dec 2019 Annexation 9,504.50 51.54 Misc Office SuppliesINNOVATIVE OFFICE SOLUTIONS LLC000271495537(A)101/03/2020 203.00 2019 MileageKELSEY COY000112625538(A)101/03/2020 271.44 2019 MileageKEVIN ROACH000185135539(A)101/03/2020 138,178.11 Jan 2020 Waste Water ServiceMETROPOLITAN COUNCIL000134005540(A)101/03/2020 125.00 Safety Boots 2019SAM OLSON000270295541(A)101/03/2020 946.00 Faith Lutheran Church Dev Plan ReviewWSB & ASSOCIATES INC000237805542(A)101/03/2020 1,861.00 2019 Watermain Project 9,829.75 TRN20-000001 Fish Pt Road Eng Svcs 1,782.50 Green Hghts/Pershing TRN22-000001 1,083.50 Misc As-Builts 15,502.75 5,623.06 Dec 2019 Natural Gas BillsCENTERPOINT ENERGY000135705543(E)112/31/2019 110.00 2019 Dental ClaimsDELTA DENTAL000272135544(E)101/07/2020 11.60 Jan 2020 Merchant FeesAUTHORIZE.NET000268215545(E)101/03/2020 1,195.00 2019 Dental ClaimsDELTA DENTAL000272135546(E)101/03/2020 CHECK REGISTER FOR CITY OF PRIOR LAKE 2/6Page: 01/13/2020 11:47 AM User: Janet DB: Prior Lake CHECK DATE FROM 12/28/2019 - 01/10/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date 482.00 2019 Dental Claims 1,677.00 1,062.90 Dec 2019 Merchant FeesPAYMENT SERVICE NETWORK INC000161415547(E)101/03/2020 2,400.00 Dec 2019 Animal Control4 PAWS ANIMAL CONTROL LLC000067985548(A)101/10/2020 1,495.68 467 DEF System repair BOYER FORD TRUCKS INC000027105549(A)101/10/2020 392.44 Dec 2019 Misc SuppliesCARLSON HARDWARE COMPANY000031255550(A)101/10/2020 548.77 SuppliesCORE & MAIN000273285551(A)101/10/2020 1,197.52 Water Supplies 326.72 Supplies 2,073.01 647.00 Cutting EdgesCRYSTEEL TRUCK EQUIPMENT000039555552(A)101/10/2020 82.96 Safety Boots 2019DAVID MONNENS000272695553(A)101/10/2020 8.70 Cable TiesFASTENAL COMPANY000061405554(A)101/10/2020 167.40 Dec 2019 LocatesGOPHER STATE ONE-CALL INC000075255555(A)101/10/2020 236.94 PaintHIRSHFIELD'S DECORATING000086855556(A)101/10/2020 236.94 Paint 473.88 875.68 Dec 2019 UniformsHUEBSCH000275365557(A)101/10/2020 20.50 BatteriesINNOVATIVE OFFICE SOLUTIONS LLC000271495558(A)101/10/2020 315.21 Toner 15.35 Index Tabs 29.28 Coffee Filters, Cups 380.34 125.00 Safety Boots 2019JACOB HARTMAN000271385559(A)101/10/2020 4,739.02 Beet HeetK-TECH SPECIALTY COATINGS INC000275685560(A)101/10/2020 126.49 TireMTI DISTRIBUTING INC000139515561(A)101/10/2020 441.60 JD Blower skids NOVAK COMPANIES000149005562(A)101/10/2020 321.89 Dec 2019 Repair PartsO'REILLY AUTO PARTS000150885563(A)101/10/2020 106.63 150th Street RepairPENTAGON MATERIALS INC000274265564(A)101/10/2020 329.69 150th Street Repair 436.32 400.00 Jan 2020 ROWay AppPERRILL000065025565(A)101/10/2020 146.00 CPESC Re-CertificationPETER YOUNG000250235566(A)101/10/2020 610.27 Nov 2019 Data & SoftwarePRECISE MOBILE RESOURCE MGMT000165485567(A)101/10/2020 192.26 Dec 2019 Misc SuppliesPRIOR LAKE HARDWARE000166585568(A)101/10/2020 380.80 OilTITAN MACHINERY000205235569(A)101/10/2020 1,479.60 Cold MixUNIQUE PAVING MATERIALS000213055570(A)101/10/2020 564.20 LightsVARITECH INDUSTRIES INC000222885571(A)101/10/2020 (349.95)Return 214.25 812.00 Hwy 13-Fish Lake Rd and 3368 SycamoreWATER CONSERVATION SVCS INC000232005572(A)101/10/2020 324.80 5467 150th St 1,136.80 119.97 1st Qtr 2020 Bottled WaterWATERLOGIC AMERICAS LLC000275835573(A)101/10/2020 CHECK REGISTER FOR CITY OF PRIOR LAKE 3/6Page: 01/13/2020 11:47 AM User: Janet DB: Prior Lake CHECK DATE FROM 12/28/2019 - 01/10/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date 18.60 Tire valve stem WOLF MOTOR CO INC000236755574(A)101/10/2020 95.08 Regulator 98.77 815 Drivers seat belt buckle 89.95 546 DEF repair 302.40 62.50 5172 Hope St Retaining WallWSB & ASSOCIATES INC000237805575(A)101/10/2020 8,038.75 Comprehensive Parks Master Plan 20,269.50 Water Main Replacement - Rustic Road 1,415.00 Spring Lake Ridge Dev Plan Review 1,787.00 2019 Watermain Project 2,360.50 TH 13/ Duluth Avenue Engineering Service 9,458.00 TRN20-000001 Fish Pt Road Eng Svcs 1,421.00 Green Hghts/Pershing TRN22-000001 125.50 2019/220 MSAS Assistance 44,937.75 227.73 465 Belt tensioner ZIEGLER INC000265005576(A)101/10/2020 479.80 2019 Dental ClaimsDELTA DENTAL000272135577(E)101/06/2020 7,290.55 2019 HRA ClaimsMEDICA000133255578(E)101/06/2020 21,040.33 Jan 2020 Electric BillsXCEL ENERGY000147205579(E)101/06/2020 8,966.95 4th Qtr 2019 State SurchargeMN DEPT OF LABOR & INDUSTRY000138015580(E)101/08/2020 74,441.97 Jan 2020 Health Insurance PremiumsMEDICA000133255581(E)101/10/2020 76.74 Jan 2020 Merchant Card FeesTRANSFIRST000206935582(E)101/10/2020 635.00 Mtce Center Generator RepairADVANCED POWER SERVICE INC00027572105313101/03/2020 69.95 Battery Back-UpBATTERIES PLUS00002130105314101/03/2020 675.00 2020 Firehouse Software MaintenanceESO SOLTUIONS INC00027644105315101/03/2020 23,460.07 N-Sight Neptune Software LicenseFERGUSON WATERWORKS #251600006231105316101/03/2020 1,057.98 Firefighter Gloves, Bar Container HolderFIRE EQUIPMENT SPECIALTIES INC00006455105317101/03/2020 470.94 Mtce Center Electrical RepairHAYES ELECTRIC INC00008315105318101/03/2020 10,659.55 M&V 2020HONEYWELL INTERNATIONAL INC00026863105319101/03/2020 25.00 2020 MembershipIPMA-HR00027073105320101/03/2020 1,750.00 Pay Equity Compliance TestingKEYSTONE COMPENSATION GROUP LLC00027218105321101/03/2020 20,210.00 2020 Membership DuesLEAGUE OF MINN CITIES00012450105322101/03/2020 275.00 Burkart - 2020 Elected Leaders Institute 20,485.00 300.00 Detail 2008 Dodge SprinterMARTY'S AUTO SALES00027690105323101/03/2020 72.00 2020 DOT Inspection Decals MN STATE PATROL, CMV SECTION00026856105324101/03/2020 2,300.00 Marketing - Tech Village, Fast Track BusNEON LIZARD CREATIVE GRAPHIC DES 00027584105325101/03/2020 216.00 Postage Meter 10/11/2019 - 1/10/2020PITNEY BOWES00016400105326101/03/2020 225.00 2020 Bulk Mail Permit #33POSTMASTER00016490105327101/03/2020 237.50 PD Card Reader RepairPRO-TECH DESIGN INC00027429105328101/03/2020 3,700.00 2020 SubscriptionRECDESK LLC00026885105329101/03/2020 4,000.00 Fireworks - Decembrrr DazzleRES PYRO00027743105330101/03/2020 3,900.00 2020 SubscriptionTRACKER A DIVISION OF C2 LLC00020662105331101/03/2020 2,920.00 2020 Software License FeeTRACKER PRODUCTS LLC00020664105332101/03/2020 9,269.18 2020 Software Maintenance TYLER TECHNOLOGIES00003765105333101/03/2020 1,758.89 2020 Third Party Printing Interface Mtce 11,028.07 600.00 Briggs - 2020 Membership DuesURBAN LAND INSTITUTE00026975105334101/03/2020 2,381.00 Bluebeam Revu Software MtceUS CAD00013104105335101/03/2020 319.85 SuppliesVIKING ELECTRIC SUPPLY00022630105336101/03/2020 32.81 UB REFUND # 1-02924-06ADMIR MUJKANOVIC REFUND-UB105337101/10/2020 14.04 UB REFUND # 4-04897-03ALEX & FRANCESCA KEMPSTON REFUND-UB105338101/10/2020 CHECK REGISTER FOR CITY OF PRIOR LAKE 4/6Page: 01/13/2020 11:47 AM User: Janet DB: Prior Lake CHECK DATE FROM 12/28/2019 - 01/10/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date 898.43 Dock SuppliesAMERICAN MUSCLE DOCKS & FABRICATION00026897105339101/10/2020 121.61 UB REFUND # 1-03941-00ARTIE MILLER REFUND-UB105340101/10/2020 187.91 UB REFUND ACCT# 1-00296-03ASHLEY ABBOTTREFUND-UB105341101/10/2020 257.10 Media ConverterAUTOMATIC SYSTEMS CO00001975105342101/10/2020 6,122.35 Well #6 Services 6,379.45 2,947.00 2019 Ground Water QUALITY MonitoringBARR ENGINEERING CO00002113105343101/10/2020 6,759.00 2019 Ground Water LEVEL Monitoring 9,706.00 458.48 397 Tires BAUER BUILT INC00002145105344101/10/2020 131.59 UB REFUND # 2-04169-00BERNICE LEAHYREFUND-UB105345101/10/2020 315.38 UB REFUND #3-00571-00BOB WELSH REFUND-UB105346101/10/2020 54.99 UB REFUND # 1-01090-01BRIAN & TIFFANY WENNGATZREFUND-UB105347101/10/2020 65.29 UB REFUND # 4-06241-00BRIAN CARTER REFUND-UB105348101/10/2020 57.61 UB REFUND # 3-05588-00BRUCE & SUSAN KRONENREFUND-UB105349101/10/2020 271.70 Dec 2019 Parks RefuseBUCKINGHAM COMPANIES00002919105350101/10/2020 1,719.84 De-IcerCARGILL INC00003123105351101/10/2020 22.48 UB REFUND # 4-07941-01CHAD BROSIOUS REFUND-UB105352101/10/2020 134.62 UB REFUND # 1-06679-00CHRISTINE THEILEN REFUND-UB105353101/10/2020 837.50 Summit Booster GuttersCISCO'S HUNG WELL SIDING INC00027742105354101/10/2020 3,137.93 Dec 2019 UB BillingCSG SYSTEMS INC00027506105355101/10/2020 346.67 UB REFUND # 308830-00CUBESMART, LPREFUND-UB105356101/10/2020 56.67 UB REFUND IRRIGATION # 3-08831-00 403.34 65.22 Dec 2019 Bottled WaterCULLIGAN BOTTLED WATER00003958105357101/10/2020 229.17 UB REFUND # 3-02627-03DAVID GLAESERREFUND-UB105358101/10/2020 104.02 Head LampDELEGARD TOOL CO00004333105359101/10/2020 110.82 Small tools 214.84 39.74 UB REFUND # 4-05522-00DENISE PRESCOTTREFUND-UB105360101/10/2020 92.97 UB REFUND # 1-00244-00DENNIS & CAROL RACETTE REFUND-UB105361101/10/2020 1,605.29 Unmarked Squad 2019 Ford #103077DRIVER & VEHICLE SERVICES00004610105362101/10/2020 43.37 UB REFUND # 1-06851-98ELIZABETH & BRIAN AMIOTREFUND-UB105363101/10/2020 106.14 UB REFUND # 3-01137-01EMIL PEDICK REFUND-UB105364101/10/2020 54.73 UB REFUND # 4-06327-00EMILY ROBINSON REFUND-UB105365101/10/2020 4,753.00 Water Meter PartsFERGUSON WATERWORKS #251600006231105366101/10/2020 2,113.10 Water Meter Parts 127.19 Water Meter Parts 407.18 Water Meter Parts 7,400.47 46.65 9260 Tanker repair FLEETPRIDE00003260105367101/10/2020 440.01 9260 and 465 Floor mats 486.66 997.68 Cutting edges H&L MESABI00008008105368101/10/2020 875.41 Mtce Center Electrical RepairHAYES ELECTRIC INC00008315105369101/10/2020 CHECK REGISTER FOR CITY OF PRIOR LAKE 5/6Page: 01/13/2020 11:47 AM User: Janet DB: Prior Lake CHECK DATE FROM 12/28/2019 - 01/10/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date 552.00 Electrical Repair 1,427.41 2,000.00 Down Pmt - 5/15/2020 Music in the ParkHELLO! BOOKING INC00008439105370101/10/2020 59.00 UB REFUND # 1-06915-01INESSA HANSEN REFUND-UB105371101/10/2020 71.78 UB REFUND ACCT #: 1-02553-01JACKIE SUSSREFUND-UB105372101/10/2020 329.10 SuppliesJEFFERSON FIRE & SAFETY INC00010359105373101/10/2020 38.38 UB REFUND # 1-01880-00JOSEPH FISCHERREFUND-UB105374101/10/2020 7,805.95 Dec 2019 UnleadedKELLEY FUELS INC00011219105375101/10/2020 8,964.48 Dec 2019 Diesel 16,770.43 9.99 UB REFUND # 3-03158-00KEVIN KERRREFUND-UB105376101/10/2020 100.00 6/5/2020 Beach Party DowmpmtKIDSDANCE00011347105377101/10/2020 7,226.33 9216 Turbo replacement LARSON COMPANIES00012320105378101/10/2020 48.62 UB REFUND # 3-09071-00LENNAR HOMES REFUND-UB105379101/10/2020 7.43 UB REFUND #3-00570-00LEROY FARRELLREFUND-UB105380101/10/2020 224.85 Tire RecyclingLIBERTY TIRE RECYCLING LLC00012628105381101/10/2020 25.65 Tire Recycling 250.50 14.81 UB REFUND # 3-04605-05LINDA DAWSONREFUND-UB105382101/10/2020 149.26 PartsLUBE-TECH & PARTNERS LLC00012791105383101/10/2020 183.54 UB REFUND # 1-00714-00MARK MONROE REFUND-UB105384101/10/2020 23.85 Water SuppliesMENARDS LUMBER CO00013318105385101/10/2020 31.92 Tough Box 616.66 Parks Supply 672.43 17,221.05 Dec 2019 SAC ChargesMETROPOLITAN COUNCIL-SAC00013406105386101/10/2020 750.00 Hand SoapMINNCOR INDUSTRIES00013543105387101/10/2020 263.90 Dec 2019 Random Drug TestingMN OCCUPATIONAL HEALTH00027099105388101/10/2020 32.00 Park SupplyMONNENS SUPPLY INC00013909105389101/10/2020 28.80 Park Supply 60.80 335.00 Membership 2020MPSTMA00013949105390101/10/2020 1,146.18 Dec 2019 Repair PartsNAPA AUTO PARTS00014060105391101/10/2020 60.00 UB REFUND # 4-04860-04OPEN DOOR LABSREFUND-UB105392101/10/2020 44.12 UB REFUND 3 4-07491-04OPENDOORREFUND-UB105393101/10/2020 673.32 UB RFUND # 2-02859-00PAM MELVILLE-DELLIREFUND-UB105394101/10/2020 16.26 UB REFUND # 3-04641-00PHILIP KLEIN REFUND-UB105395101/10/2020 10.00 2020 Bulk Mail Permit #33 (Add'l Amt DuePOSTMASTER00016490105396101/10/2020 38.04 510 Chipper knife bolts POWERPLAN00022435105397101/10/2020 149.64 2019 CWCU ExpensesPRIOR LAKE-SPRING LAKE00016820105398101/10/2020 103.76 UB REFUND #4-07225-03ROBERT DUFRESNEREFUND-UB105399101/10/2020 19.34 UB REFUND # 1-08401-01ROBERT REES REFUND-UB105400101/10/2020 87.50 UB REFUND # 3-08875-01SANKARI WRIGHT REFUND-UB105401101/10/2020 132.62 UB REFUND # 4-06084-00SARAH STEFFLREFUND-UB105402101/10/2020 3,882.99 SuppliesSCALE TEC 00019074105403101/10/2020 12.05 UB REFUND # 4-08005-01SCOTT & DIANE RITCHIE REFUND-UB105404101/10/2020 325.00 Cash ICR #19015206SCOTT COUNTY ATTORNEY00019232105405101/10/2020 74.00 Cash ICR #18016849 399.00 CHECK REGISTER FOR CITY OF PRIOR LAKE 6/6Page: 01/13/2020 11:47 AM User: Janet DB: Prior Lake CHECK DATE FROM 12/28/2019 - 01/10/2020 AmountDescriptionVendor NameVendorCheckBankCheck Date 36.47 UB REFUND #2-03581-03SEAN HENRETTY REFUND-UB105406101/10/2020 123.75 PaintSHERWIN-WILLIAMS CO00019456105407101/10/2020 82.38 Dec 2019 Legal AdsSOUTHWEST NEWSPAPERS00019676105408101/10/2020 915.96 Eco ThawSPECIALTY SOLUTIONS LLC00027576105409101/10/2020 162.50 Cash ICR #19015206STATE TREASURER00019796105410101/10/2020 37.00 Cash ICR #18016849 199.50 152.93 UB REFUND # 408302-02STEPHANIE & ALAN EL-DARAZIREFUND-UB105411101/10/2020 4,166.00 FleetZoomSYCOM INC00019985105412101/10/2020 9.81 UB REFUND #3-00065-01T.J & NATALIE BROWN REFUND-UB105413101/10/2020 21.04 UB REFUND # 1-01276-0THERESA IRMEN-DUNN REFUND-UB105414101/10/2020 90.00 UB REIMBURSEMENT SIGNPOST # 3-03430-02TITLE SMART REFUND-UB105415101/10/2020 356.46 Dec 2019 Misc SuppliesTRACTOR SUPPLY CREDIT PLAN00020663105416101/10/2020 296.00 Parts and ServiceTRI COUNTY WATER METRO SOUTH00005247105417101/10/2020 450.00 Anderson,Karrow - Shade Tree CourseUNIVERSITY OF MINNESOTA00021770105418101/10/2020 6.22 ShippingUPS00021400105419101/10/2020 24.54 Shipping 30.76 6,610.15 Jan 2020 Cell Phone BillsVERIZON WIRELESS00001315105420101/10/2020 16.27 UB REFUND # 1-06509-00WILFRED & GEO FRITZREFUND-UB105421101/10/2020 2,250.35 Warming House RentalWILLIAMS SCOTSMAN INC00027554105422101/10/2020 1 TOTALS: 556,630.44 Total of 163 Disbursements: 0.00 Less 0 Void Checks: 556,630.44 Total of 163 Checks: City of Prior Lake Expenditures- Payroll OnlyAs of 11/30/2019 (Preliminary & Unaudited)ACTIVITY FOR ACTIVITY FORVariance fromVariance fromPREVIOUS MONTH MONTH 2019 2019 2019 Amended Budget - % BDGT 11/30/2018 from 201810/31/201911/30/2019BudgetAmendedActual YTDPositive (Negative)USEDActual YTDPositive (Negative)GENERAL FUNDFunction: General Government41110.00 MAYOR & COUNCIL 4,018 4,018 48,216 48,216 44,198 4,018 92% 35,915 (8,283) 41320.00 ADMINISTRATION 9,862 21,693 279,108 279,108 320,450 (41,342) 115% 242,844 (77,605) 41330.00 BOARDS & COMMISSIONS 900 700 10,000 10,000 7,600 2,400 76% 7,900 300 41400.00 CITY CLERK FUNCTIONS 6,647 6,647 46,058 46,058 53,177 (7,119) 115% - (53,177) 41410.00 ELECTIONS- - - - - - n/a 23,656 23,656 41520.00 FINANCE28,788 28,941 357,827 357,827 315,077 42,750 88% 287,324 (27,753) 41820.00 HUMAN RESOURCES 10,769 9,480 117,024 117,024 106,288 10,736 91% 98,451 (7,837) 41830.00 COMMUNICATIONS 6,398 6,480 83,189 83,189 72,075 11,114 87% 67,718 (4,357) 41910.00 COMMUNITY DEVELOPMENT 18,705 17,553 228,629 228,629 189,140 39,489 83% 182,697 (6,443) 41920.00 INFORMATION TECHNOLOGY 9,163 9,163 118,162 118,162 103,781 14,381 88% 100,988 (2,794) 41940.00 FACILITIES - CITY HALL 4,965 5,104 61,434 61,434 55,926 5,508 91% 54,832 (1,094) Total - Function General Government100,216 109,780 1,349,647 1,349,647 1,267,712 81,935 94% 1,102,325 (165,387) Function: Public Safety42100.00 POLICE219,437 215,243 3,090,997 3,110,197 2,555,327 554,870 82% 2,390,533 (164,794) 42200.00 FIRE25,684 29,580 328,855 328,855 281,820 47,035 86% 285,358 3,538 42400.00 BUILDING INSPECTION 33,818 33,684 420,164 420,164 383,479 36,685 91% 370,654 (12,824) Total - Function Public Safety278,939 278,507 3,840,016 3,859,216 3,220,626 638,590 83% 3,046,545 (174,081) Function: Public Works43050.00 ENGINEERING 19,056 19,392 233,208 233,208 200,974 32,234 86% 189,067 (11,908) 43100.00 STREET23,308 23,741 314,132 314,132 242,910 71,222 77% 240,118 (2,792) 43400.00 CENTRAL GARAGE 12,354 12,354 170,418 170,418 139,035 31,383 82% 129,931 (9,104) Total - Function Public Works54,719 55,487 717,758 717,758 582,919 134,839 81% 559,115 (23,804) Function: Culture and Recreation45100.00 RECREATION 15,108 14,284 237,601 218,401 212,416 5,985 97% 233,474 21,058 45200.00 PARKS53,946 47,306 775,214 775,214 661,693 113,521 85% 710,004 48,312 Total - Function Culture and Recreation69,054 61,590 1,012,815 993,615 874,109 119,506 88% 943,478 69,369 General Fund Payroll Only Expenditures Total502,927 505,365 6,920,236 6,920,236 5,945,365 974,871 86%5,651,463 (293,902) COMPARATIVEAnnual City of Prior Lake Expenditures- Payroll OnlyAs of 11/30/2019 (Preliminary & Unaudited)ACTIVITY FOR ACTIVITY FORVariance fromVariance fromPREVIOUS MONTH MONTH 2019 2019 2019 Amended Budget - % BDGT 11/30/2018 from 201810/31/201911/30/2019BudgetAmendedActual YTDPositive (Negative)USEDActual YTDPositive (Negative)COMPARATIVEAnnualEDA FUNDFunction: Economic Development 46500.00 ECONOMIC DEVELOPMENT 8,864 8,134 97,587 97,587 93,686 3,901 96% 87,373 (6,313) EDA Fund Payroll Only Expenditures Total8,864 8,134 97,587 97,587 93,686 3,901 96%87,373 (6,313) WATER FUNDFunction: Water41520.00 Finance3,822 3,965 53,089 53,089 43,313 9,776 82% 35,150 (8,163) 49400.00 Water41,361 40,641 496,447 496,447 436,978 59,469 88% 407,759 (29,219) Water Fund Payroll Only Expenditures Total45,184 44,606 549,536 549,536 480,290 69,246 87%442,909 (37,382) SEWER FUNDFunction: Sewer41520.00 Finance3,822 3,965 50,564 50,564 43,310 7,254 86% 35,147 (8,163) 49450.00 Sewer37,986 37,470 477,722 477,722 425,821 51,901 89% 392,271 (33,550) Sewer Fund Payroll Only Expenditures Total41,808 41,435 528,286 528,286 469,131 59,155 89%427,418 (41,713) STORM WATER FUNDFunction: Storm Water49420.00 Water Quality 20,394 20,915 225,752 225,752 215,201 10,551 95% 193,512 (21,689) Storm Water Fund Payroll Only Expenditures Total20,394 20,915 225,752 225,752 215,201 10,551 95%193,512 (21,689) City-Wide Total Payroll Expenditures619,176 620,454 8,321,397 8,321,397 7,203,674 1,117,723 87% 6,802,675 (400,999) City of Prior Lake Expenditures- Payroll OnlyAs of 12/31/2019 (Preliminary & Unaudited)ACTIVITY FOR ACTIVITY FORVariance fromVariance fromPREVIOUS MONTH MONTH 2019 2019 2019 Amended Budget - % BDGT 11/30/2018 from 201811/30/201912/31/2019BudgetAmendedActual YTDPositive (Negative)USEDActual YTDPositive (Negative)GENERAL FUNDFunction: General Government41110.00 MAYOR & COUNCIL 4,018 4,018 48,216 48,216 48,216 - 100% 39,180 (9,036) 41320.00 ADMINISTRATION 21,693 21,740 279,108 279,108 342,189 (63,081) 123% 282,494 (59,696) 41330.00 BOARDS & COMMISSIONS 700 - 10,000 10,000 7,600 2,400 76% 8,900 1,300 41400.00 CITY CLERK FUNCTIONS 6,647 6,647 46,058 46,058 59,825 (13,767) 130% - (59,825) 41410.00 ELECTIONS- - - - - - n/a 18,043 18,043 41520.00 FINANCE28,941 25,498 357,827 357,827 340,575 17,252 95% 336,905 (3,670) 41820.00 HUMAN RESOURCES 9,480 9,718 117,024 117,024 116,006 1,018 99% 114,751 (1,255) 41830.00 COMMUNICATIONS 6,480 6,552 83,189 83,189 78,627 4,562 95% 78,990 364 41910.00 COMMUNITY DEVELOPMENT 17,553 17,889 228,629 228,629 207,029 21,600 91% 224,263 17,235 41920.00 INFORMATION TECHNOLOGY 9,163 9,163 118,162 118,162 112,944 5,218 96% 115,847 2,903 41940.00 FACILITIES - CITY HALL 5,104 5,547 61,434 61,434 61,473 (39) 100% 64,337 2,865 Total - Function General Government109,780 106,771 1,349,647 1,349,647 1,374,483 (24,836) 102% 1,283,710 (90,773) Function: Public Safety42100.00 POLICE215,243 232,625 3,090,997 3,110,197 2,787,953 322,244 90% 2,947,665 159,713 42200.00 FIRE29,580 21,787 328,855 328,855 303,607 25,248 92% 331,068 27,461 42400.00 BUILDING INSPECTION 33,684 34,479 420,164 420,164 417,958 2,206 99% 429,955 11,997 Total - Function Public Safety278,507 288,892 3,840,016 3,859,216 3,509,518 349,698 91% 3,708,688 199,170 Function: Public Works43050.00 ENGINEERING 19,392 18,387 233,208 233,208 219,361 13,847 94% 221,401 2,040 43100.00 STREET23,741 25,736 314,132 314,132 268,645 45,487 86% 292,533 23,888 43400.00 CENTRAL GARAGE 12,354 13,595 170,418 170,418 152,630 17,788 90% 153,327 698 Total - Function Public Works55,487 57,717 717,758 717,758 640,636 77,122 89% 667,262 26,626 Function: Culture and Recreation45100.00 RECREATION 14,284 14,959 237,601 218,401 227,375 (8,974) 104% 257,627 30,252 45200.00 PARKS47,306 50,410 775,214 775,214 712,103 63,111 92% 790,327 78,224 Total - Function Culture and Recreation61,590 65,369 1,012,815 993,615 939,478 54,137 95% 1,047,954 108,476 General Fund Payroll Only Expenditures Total505,365 518,749 6,920,236 6,920,236 6,464,115 456,121 93%6,707,615 243,500 COMPARATIVEAnnual City of Prior Lake Expenditures- Payroll OnlyAs of 12/31/2019 (Preliminary & Unaudited)ACTIVITY FOR ACTIVITY FORVariance fromVariance fromPREVIOUS MONTH MONTH 2019 2019 2019 Amended Budget - % BDGT 11/30/2018 from 201811/30/201912/31/2019BudgetAmendedActual YTDPositive (Negative)USEDActual YTDPositive (Negative)COMPARATIVEAnnualEDA FUNDFunction: Economic Development 46500.00 ECONOMIC DEVELOPMENT 8,134 7,864 97,587 97,587 101,551 (3,964) 104% 94,992 (6,559) EDA Fund Payroll Only Expenditures Total8,134 7,864 97,587 97,587 101,551 (3,964) 104%94,992 (6,559) WATER FUNDFunction: Water41520.00 Finance3,965 3,965 53,089 53,089 47,278 5,811 89% 42,386 (4,892) 49400.00 Water40,641 42,481 496,447 496,447 479,458 16,989 97% 483,212 3,754 Water Fund Payroll Only Expenditures Total44,606 46,446 549,536 549,536 526,736 22,800 96%525,598 (1,138) SEWER FUNDFunction: Sewer41520.00 Finance3,965 3,965 50,564 50,564 47,274 3,290 93% 42,382 (4,892) 49450.00 Sewer37,470 40,169 477,722 477,722 465,989 11,733 98% 446,533 (19,456) Sewer Fund Payroll Only Expenditures Total41,435 44,133 528,286 528,286 513,264 15,022 97%488,915 (24,348) STORM WATER FUNDFunction: Storm Water49420.00 Water Quality 20,915 18,577 225,752 225,752 233,778 (8,026) 104% 218,369 (15,409) Storm Water Fund Payroll Only Expenditures Total20,915 18,577 225,752 225,752 233,778 (8,026) 104%218,369 (15,409) City-Wide Total Payroll Expenditures620,454 635,769 8,321,397 8,321,397 7,839,443 481,954 94% 8,035,489 196,046