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: OCTOBER 21, 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 9/28/2019 – 10/11/2019 Date Checks ACH EFT Totals 9/30/2019 1,805.93 1,805.93 10/1/2019 1,672.19 1,672.19 10/2/2019 12.80 12.80 10/4/2019 83,913.71 144,981.55 293.65 229,188.91 10/7/2019 3,803.00 3,803.00 10/9/2019 183,963.39 91,012.64 345.60 275,321.63 10/11/2019 100,906.47 100,906.47 267,877.10 235,994.19 108,839.64 612,710.93 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: 10/14/2019 09:32 AM User: Janet DB: Prior Lake CHECK DATE FROM 09/28/2019 - 10/11/2019 AmountDescriptionVendor NameVendorCheckBankCheck Date Bank 1 General Bank V1,844.88 Aug 2019 Natural Gas CENTERPOINT ENERGY000135705094(E)109/30/2019 V44,628.47 Aug 2019 Electric BillsXCEL ENERGY000147205095(E)109/30/2019 1,805.93 2019 HRA ClaimsMEDICA000133255185(E)109/30/2019 2,400.00 Sep 2019 Animal Control4 PAWS ANIMAL CONTROL LLC000067985186(A)110/04/2019 945.00 Tow/Store 2012 Ford Fusion #308825ALLEN'S SERVICE INC000013605187(A)110/04/2019 91.23 Mileage - MCFOA AcademyANN BAUCOM-ORLOFSKY000276495188(A)110/04/2019 169.53 Mileage, Commander Interview RefreshmentANN SCHROEDER000270355189(A)110/04/2019 125.00 2019 Safety BootsANTHONY ANDERSON000271195190(A)110/04/2019 54.71 Chalkfest SuppliesCASEY MCCABE000132075191(A)110/04/2019 255.20 Supplies - Sand Pt Beach Park pipe repaiCORE & MAIN000273285192(A)110/04/2019 71.97 Lid Casting 327.17 179.22 Mileage - GFOA ConferenceDANIELLE AMIRA000277045193(A)110/04/2019 175.27 452 Laptop standEMERGENCY AUTOMOTIVE TECH INC000054805194(A)110/04/2019 904.02 9200 Laptop mount 145.16 2019 Ford Interceptor 1,043.30 PD Car Supplies 59.57 2021 New sedan squad supplies 51.80 452 Lower post equipment holder 2,379.12 1,666.22 SuppliesFASTENAL COMPANY000061405195(A)110/04/2019 32.72 488 Wing bolts 1,698.94 310.00 Custom BadgeGALLS LLC000070755196(A)110/04/2019 310.00 Custom Badge 310.00 Custom Badge 310.00 Olson - Sgt Badge 1,240.00 828.90 Sep 2019 LocatesGOPHER STATE ONE-CALL INC000075255197(A)110/04/2019 859.57 Sep 2019 UniformsHUEBSCH000275365198(A)110/04/2019 136.38 Misc Office SuppliesINNOVATIVE OFFICE SOLUTIONS LLC000271495199(A)110/04/2019 26.95 Cups 318.38 Toner 1,061.13 Final Bill Envelopes 398.30 Envelopes 1,941.14 173.42 Mileage - GFOA ConferenceJASON ETTER000276975200(A)110/04/2019 289.22 Mileage, Hotel LETG ConferenceJENNIFER BISEK000271475201(A)110/04/2019 39.67 Parking, Mileage Data Practices WorkshopKATIE BEER000276995202(A)110/04/2019 49.41 784 Pump mode switchMACQUEEN EQUIPMENT INC000130545203(A)110/04/2019 128,727.37 Oct 2019 Waste Water ServiceMETROPOLITAN COUNCIL000134005204(A)110/04/2019 67.57 Shirts - ScottNORTH AMERICAN SAFETY000145745205(A)110/04/2019 45.90 452 Aluminum stand NOVAK COMPANIES000149005206(A)110/04/2019 12.00 452 Wing steel 57.90 CHECK REGISTER FOR CITY OF PRIOR LAKE 2/6Page: 10/14/2019 09:32 AM User: Janet DB: Prior Lake CHECK DATE FROM 09/28/2019 - 10/11/2019 AmountDescriptionVendor NameVendorCheckBankCheck Date 607.64 Aug 2019PRECISE MOBILE RESOURCE MGMT000165485207(A)110/04/2019 63.97 Trailer plugs RIGID HITCH INC000184755208(A)110/04/2019 34.24 528 Boat lights 98.21 1,258.50 Tuition ReimbursementROBERT FREIBERG000276965209(A)110/04/2019 310.59 Stock lawn mower tires ROYAL TIRE INC000187325210(A)110/04/2019 62.52 Mileage, Parking Data Practices WorkshopTANIA CARRIER000276985211(A)110/04/2019 1,672.19 Oct 2019 Natural Gas BillsCENTERPOINT ENERGY000135705212(E)110/01/2019 2,195.79 2019 Dental ClaimsDELTA DENTAL000272135213(E)110/07/2019 1,607.21 2019 HRA ClaimsMEDICA000133255214(E)110/07/2019 1,545.00 Tow/Store 2012 Mercedes #237410ALLEN'S SERVICE INC000013605215(A)110/09/2019 1,005.00 Tow/Store 2011 Dodge #534804 105.00 Tow Vehicle for Training 2,655.00 505.55 Recharge Fire ExtinguishersCENTRAL FIRE PROTECTION000033005216(A)110/09/2019 6.68 Patch RepairGALLS LLC000070755217(A)110/09/2019 2,433.75 Sep 2019 GeneralHOFF BARRY PA000273875218(A)110/09/2019 206.25 Sep 2019 Annexation 165.00 Sep 2019 Data Practices/Open Mtg 41.25 Sep 2019 Human Resources 123.75 Sep 2019 Finance 41.25 Sep 2019 Franchises 1,237.50 Sep 2019 PW/Engineering 742.50 Sep 2019 Recreation 123.75 Sep 2019 City Projects 618.75 Sep 2019 Comm Dev 165.00 Sep 2019 Enforcement 577.50 Sep 2019 Development 206.25 Sep 2019 Majestic 866.25 Sep 2019 Code Pt 1 Admin 555.00 Sep 2019 Litigation 41.25 Sep 2019 Antenna 8,145.00 38.79 Sewer Trailer TonerINNOVATIVE OFFICE SOLUTIONS LLC000271495219(A)110/09/2019 37.51 Misc Office Supplies 120.88 Misc Office Supplies 149.09 Misc Office Supplies 59.00 Wedel - Business Cards 405.27 400.00 Oct 2019 ROWay AppPERRILL000065025220(A)110/09/2019 75,690.00 Refurbish Brine TankVARITECH INDUSTRIES INC000222885221(A)110/09/2019 383.90 4452 Colorado St Leak DetectionWATER CONSERVATION SVCS INC000232005222(A)110/09/2019 119.97 4th Qtr 2019 Bottled WaterWATERLOGIC AMERICAS LLC000275835223(A)110/09/2019 278.07 AsphaltWM MUELLER & SONS INC000236455224(A)110/09/2019 207.00 Asphalt 770.90 Asphalt 1,255.97 972.00 3766 Majestic Lane Retaining WallWSB & ASSOCIATES INC000237805225(A)110/09/2019 CHECK REGISTER FOR CITY OF PRIOR LAKE 3/6Page: 10/14/2019 09:32 AM User: Janet DB: Prior Lake CHECK DATE FROM 09/28/2019 - 10/11/2019 AmountDescriptionVendor NameVendorCheckBankCheck Date 348.00 5172 Hope St Retaining Wall 1,320.00 125.30 Mtce Center First Aid SuppliesZEE MEDICAL SERVICE000263505226(A)110/09/2019 12.80 Oct 2019 Merchant FeesAUTHORIZE.NET000268215227(E)110/02/2019 293.65 Sep 2019 Merchant FeesPAYMENT SERVICE NETWORK INC000161415228(E)110/04/2019 345.60 2019 Dental ClaimsDELTA DENTAL000272135229(E)110/09/2019 64,192.34 Oct 2019 Health Insurance PremiumsMEDICA000133255230(E)110/10/2019 142.62 Oct 2019 Merchant Card FeesTRANSFIRST000206935231(E)110/10/2019 36,571.51 Oct 2019 Electric BillsXCEL ENERGY000147205232(E)110/10/2019 4,178.46 Generator MaintenanceADVANCED POWER SERVICE INC00027572104743110/04/2019 1,500.00 Software ServicesALL TRAFFIC SOLUTIONS00027144104744110/04/2019 1,125.30 Pizza Cutter - ChalkfestAMERICAN SOLUTIONS FOR BUSINESS00027700104745110/04/2019 310.15 Well #6 RepairAUTOMATIC SYSTEMS CO00001975104746110/04/2019 1,546.00 Squad Car Camera SystemAXON ENTERPRISE INC00027347104747110/04/2019 1,509.00 Cradlepoint Router 3,055.00 624.04 508 Tires BAUER BUILT INC00002145104748110/04/2019 2,500.00 18-0393 15155 Manitou RoadBRIAN RUEMISC-CD104749110/04/2019 3,000.00 18-0393 15155 Manitou Road 5,500.00 664.31 Sep 2019 Parks RefuseBUCKINGHAM COMPANIES00002919104750110/04/2019 43.98 Oct 019 Mtce Center Refuse 107.93 Oct 2019 City Hall Refuse 44.44 Oct 2019 PD Refuse 44.74 Oct 2019 FS #1 Refuse 44.74 Oct 2019 FS #2 Refuse 107.93 Oct 2019 Library Refuse 1,058.07 13.56 4-07142-00 IrrigationCITY OF PRIOR LAKE00016810104751110/04/2019 219.96 CoffeeCOFFEE WHOLESALE USA00026842104752110/04/2019 7,750.00 Ponds Park Tree RemovalCOLLINS TREE CARE00003670104753110/04/2019 1,379.94 Oct 2019 Library Carpet CleaningCOMMERCIAL STEAM TEAM00003725104754110/04/2019 72.81 Sep 2019 Bottled WaterCULLIGAN BOTTLED WATER00003958104755110/04/2019 250.00 Rozga - Pursuit RefresherDAKOTA CTY TECH COLLEGE00004050104756110/04/2019 400.00 Kelm - Basic PIT/TVI 650.00 225.00 Beer - Data Ptractices WorkshopDATA PRACTICES OFFICE00027547104757110/04/2019 225.00 Carrier - Data Practices Workshop 450.00 14.25 #1108 Tab Renewal 2008 Dodge #312689DRIVER & VEHICLE SERVICES00004610104758110/04/2019 104.50 Sign Post StabilizersEARL F ANDERSEN INC00005175104759110/04/2019 176.25 Sign Blanks 280.75 43.00 Sew Chaplain PatchECKO'S EMBROIDERY00027266104760110/04/2019 143.84 BladesESCH CONSTRUCTION SUPPLY INC00005763104761110/04/2019 CHECK REGISTER FOR CITY OF PRIOR LAKE 4/6Page: 10/14/2019 09:32 AM User: Janet DB: Prior Lake CHECK DATE FROM 09/28/2019 - 10/11/2019 AmountDescriptionVendor NameVendorCheckBankCheck Date 2,500.00 17-0554 3188 Griggs StETERNITY HOMESMISC-CD104762110/04/2019 2,500.00 17-0843 3217 Griggs St 5,000.00 2,500.00 16-1364 3261 Skinner StETERNITY HOMES LLCREFUND-BLG104763110/04/2019 4,648.80 Turf Care SuppliesFARMERS MILL & ELEVATOR INC00027632104764110/04/2019 581.00 Bucket SwingsFLAGSHIP RECREATION LLC00006615104765110/04/2019 900.00 17-0800 15286 Edgewater CircleGEROLD BROTHERSMISC-CD104766110/04/2019 2,500.00 17-0800 15286 Edgewater Circle 3,400.00 406.64 398 New tires GOODYEAR COMMERCIAL TIRE00007510104767110/04/2019 127.20 Pipe Hanger Brine BuildingGRAINGER INC00023030104768110/04/2019 493.75 Brine Building Repairs 116.50 Brine Building Repairs 84.08 City Hall Repair 821.53 703.86 Light Repair VariousHAYES ELECTRIC INC00008315104769110/04/2019 378.71 Water Plant Service 1,082.57 281.25 Puppeteers - Fall FrenzyHOMEWARD BOUND THEATRE CO00027685104770110/04/2019 835.00 Gate Valve Repair Kit PartsHYDROVERGE00027694104771110/04/2019 1,128.35 Transportation - August Field TripsISD #71900009865104772110/04/2019 181.60 Tire RecyclingLIBERTY TIRE RECYCLING LLC00012628104773110/04/2019 118.59 452 Hydraulic hose sleeveLITTLE FALLS MACHINE INC00012705104774110/04/2019 3,408.00 Area 4 - Howard Lake trail SealingMEIGS ADVANTAGE LLC00027154104775110/04/2019 2,526.50 Area 3 Jeffers/Mckenna Trail Sealing 2,187.50 Area 2 Carriage Hills 1,745.00 Area 1 Fish Point Rd Trail Sealing 9,867.00 240.00 1611 Windshield replacement MILESTONE AUTO INC00013510104776110/04/2019 23.00 Pap Water System RenewalMN DEPT OF HEALTH00013618104777110/04/2019 23.00 Ryan Water Supply RenewalMN DEPT OF HEALTH00013618104778110/04/2019 681.72 City Hall ElevatorMN ELEVATOR INC00013623104779110/04/2019 681.72 Police Service 1,363.44 80.42 523 Mower parts MN EQUIPMENT00026912104780110/04/2019 125.59 526 Mower parts 206.01 2,500.00 18-1536 2932 Center RoadPEBBLE CREEK CUSTOM HOMESMISC-CD104781110/04/2019 216.00 Postage Meter 7/11/2019 - 10/10/2019PITNEY BOWES00016400104782110/04/2019 605.00 1516 accident repair PRIOR LAKE AUTO COLLISION00016604104783110/04/2019 2,500.00 18-1007 15263 Fairbanks Trail NERAYMOND JOACHIMMISC-CD104784110/04/2019 700.00 18-1007 15263 Fairbanks Trail NE 3,200.00 CHECK REGISTER FOR CITY OF PRIOR LAKE 5/6Page: 10/14/2019 09:32 AM User: Janet DB: Prior Lake CHECK DATE FROM 09/28/2019 - 10/11/2019 AmountDescriptionVendor NameVendorCheckBankCheck Date 448.29 551 Battery chargerRMS RENTALS00018498104785110/04/2019 272.00 Farmers MarketSAFETY SIGNS00019024104786110/04/2019 20.00 Cash ICR #19004328SCOTT COUNTY ATTORNEY00019232104787110/04/2019 65.40 Cash ICR #19007275 115.61 Cash ICR #19000736 352.65 Cash/2012 Ford Fusion #308825 439.65 2011 Dodge #534804 993.31 1,214.00 Oct 2019 Portable Toilet RentalsSPECIALIZED SANITATION00019703104788110/04/2019 10.00 Cash ICR #19004328STATE TREASURER00019796104789110/04/2019 32.70 Cash ICR #19007275 57.80 Cash ICR #19000736 176.32 Cash/2012 Ford Fusion #308825 219.82 2011 Dodge $537804 496.64 2,500.00 18-1525 14163 Rolling Oaks Circle STONE COTTAGE CONSTRUCTION, INC.MISC-CD104790110/04/2019 2,100.00 18-1525 14163 Rolling Oaks Circle 4,600.00 169.98 Shield Carry BagSTREICHERS00019900104791110/04/2019 38.97 Pepper Spray 208.95 225.00 Monthly Coliform TestingUC LABORATORY00021235104792110/04/2019 452.92 Misc SuppliesULINE00021250104793110/04/2019 549.88 Evidence Supplies 1,002.80 317.82 Filters Markley LakeUNITED RENTALS INC00023195104794110/04/2019 6.21 ShippingUPS00021400104795110/04/2019 11.58 Shippping 17.79 4,019.20 Sep 2019 Cell Phone BillsVERIZON WIRELESS00001315104796110/04/2019 2,500.00 16-1455 16430 Park AvenueYORWAY CONSTRUCTIONREFUND-BLG104797110/04/2019 20,019.55 Council Chambers Audio Equipment ReplaceADVANCED SYSTEM INTEGRATION LLC00027351104798110/09/2019 303.70 Jelle - UniformsASPEN MILLS00001891104799110/09/2019 87.80 12V BatteriesBATTERIES PLUS00002130104800110/09/2019 51,161.00 Well #6 MaintenanceBERGERSON - CASWELL INC00002295104801110/09/2019 167.80 EMS SuppliesBOUND TREE MEDICAL LLC00002695104802110/09/2019 105.00 Sep 2019 Tai Chi InstructorCHRISTINE T MORGAN00027316104803110/09/2019 5,891.70 SCBA JPA Service ContractCLAREY'S SAFETY EQUIPMENT00003530104804110/09/2019 650.00 Snyder, Griffin Pursuit PIT/TI RefresherDAKOTA CTY TECH COLLEGE00004050104805110/09/2019 150.00 Snyder, Griffin Training Car Rental 800.00 1,885.59 BootsFIRE EQUIPMENT SPECIALTIES INC00006455104806110/09/2019 17.89 Well #6 Cable Support GripGRAINGER INC00023030104807110/09/2019 2,500.00 18-1882 15268 Fish Point RoadHIGHMARK BUILDERSMISC-CD104808110/09/2019 CHECK REGISTER FOR CITY OF PRIOR LAKE 6/6Page: 10/14/2019 09:32 AM User: Janet DB: Prior Lake CHECK DATE FROM 09/28/2019 - 10/11/2019 AmountDescriptionVendor NameVendorCheckBankCheck Date 30.97 Wall Mount Key SafeHOME DEPOT CREDIT SERVICES00008865104809110/09/2019 115.00 Olson - Labor Relations TrainingLEAGUE OF MINN CITIES00012450104810110/09/2019 55.00 Briggs - Regional Meeting 170.00 172.38 Brine BuildingMENARDS LUMBER CO00013318104811110/09/2019 29,521.80 Sep 2019 SAC ChargesMETROPOLITAN COUNCIL-SAC00013406104812110/09/2019 2,500.00 18-1024 13643 Crownline DrMI HOMES OF MINNEAPOLIS LLCMISC-CD104813110/09/2019 2,500.00 18-1025 13647 Crownline Dr 2,500.00 18-1322 13654 Crownline Dr 2,500.00 18-1755 13682 Wildflower Way 2,500.00 19-0364 13683 Wildflower Way 2,500.00 19-0183 13626 Kensington Ave 2,500.00 18-0897 13612 Kensington Ave 2,500.00 18-1005 13598 Kensington Ave 2,500.00 18-1440 13584 Kensongton Ave 2,500.00 18-0017 13602 Crownline Dr 2,500.00 18-1324 13647 Kensington Ave 2,500.00 18-0454 13616 Crownline Dr 2,500.00 18-0456 13633 Crownline Dr 2,500.00 18-0455 13637 Crownline Dr 2,500.00 18-1004 13598 Crownline Dr 2,500.00 18-2012 13570 Kensington Ave 2,500.00 18-0190 13601 Crownline Dr 2,500.00 18-0249 13608 Crownline Dr 45,000.00 2,210.00 Hep B VaccineMN OCCUPATIONAL HEALTH00027099104814110/09/2019 3,895.71 Promote Customer Traffic in Commercial ANEON LIZARD CREATIVE GRAPHIC DES 00027584104815110/09/2019 11,025.00 Utility StudyNORTHLAND SECURITIES INC00014775104816110/09/2019 2,070.50 Controller ReplacementPRO-TECH DESIGN INC00027429104817110/09/2019 665.73 Green HeightsRIVERS EDGE CONCRETE INC00018496104818110/09/2019 836.00 Pumpkins, Cornstalks, Straw BalesSAILERS GREENHOUSE00019037104819110/09/2019 2,197.28 2012 Mercedes #237410SCOTT COUNTY ATTORNEY00019232104820110/09/2019 120.00 B Thompson Notary RenewalSECRETARY OF STATE00019330104821110/09/2019 2,500.00 18-2025 14812 Timberwolf TrlSTONE COTTAGE CONSTRUCTION, INC.MISC-CD104822110/09/2019 198.00 Sep 2019 Investigative ServicesWEST PAYMENT CENTER00023420104823110/09/2019 409.99 Wood Cutting Rescue Master BladeWL CONSTRUCTION SUPPLY INC00027262104824110/09/2019 1 TOTALS: 612,710.93 Total of 130 Disbursements: 46,473.35 Less 2 Void Checks: 659,184.28 Total of 132 Checks: City of Prior Lake Expenditures- Payroll Only As of 09/30/2019 (Preliminary & Unaudited) ACTIVITY FOR Variance from Variance from MONTH 2019 2019 2019 Amended Budget - % BDGT 09/30/2018 from 2018 9/30/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 36,162 12,054 75%29,385 (6,777) 41320.00 ADMINISTRATION 16,646 279,108 279,108 288,894 (9,786) 104%199,341 (89,553) 2 city managers 41330.00 BOARDS & COMMISSIONS 500 10,000 10,000 6,000 4,000 60%6,200 200 41400.00 CITY CLERK FUNCTIONS 6,647 46,058 46,058 39,883 6,175 87%- (39,883) 41410.00 ELECTIONS - - - - - n/a 12,430 12,430 41520.00 FINANCE 28,761 357,827 357,827 257,347 100,480 72%233,136 (24,211) 41820.00 HUMAN RESOURCES 10,769 117,024 117,024 86,039 30,985 74%80,577 (5,462) 41830.00 COMMUNICATIONS 6,472 83,189 83,189 59,197 23,992 71%55,556 (3,641) 41910.00 COMMUNITY DEVELOPMENT 17,975 228,629 228,629 152,882 75,747 67%148,594 (4,288) 41920.00 INFORMATION TECHNOLOGY 9,163 118,162 118,162 85,455 32,707 72%83,195 (2,260) 41940.00 FACILITIES - CITY HALL 4,965 61,434 61,434 45,857 15,577 75%44,795 (1,062) Total - Function General Government 105,917 1,349,647 1,349,647 1,057,716 291,931 78%893,209 (164,507) Function: Public Safety 42100.00 POLICE 225,408 3,090,997 3,110,197 2,120,647 989,550 68%1,978,019 (142,629) 42200.00 FIRE 29,680 328,855 328,855 226,556 102,299 69%224,078 (2,478) 42400.00 BUILDING INSPECTION 34,706 420,164 420,164 315,977 104,187 75%306,597 (9,380) Total - Function Public Safety 289,794 3,840,016 3,859,216 2,663,181 1,196,035 69%2,508,694 (154,487) Function: Public Works 43050.00 ENGINEERING 9,047 233,208 233,208 123,685 109,523 53%154,142 30,457 43100.00 STREET 23,228 314,132 314,132 195,860 118,272 62%194,161 (1,700) 43400.00 CENTRAL GARAGE 12,354 170,418 170,418 114,326 56,092 67%106,694 (7,633) Total - Function Public Works 44,630 717,758 717,758 433,871 283,887 60%454,996 21,125 Function: Culture and Recreation 45100.00 RECREATION 16,039 237,601 218,401 183,024 35,377 84%205,497 22,473 45200.00 PARKS 57,799 775,214 775,214 560,440 214,774 72%614,623 54,183 Total - Function Culture and Recreation 73,838 1,012,815 993,615 743,464 250,151 75%820,120 76,655 General Fund Payroll Only Expenditures Total 514,178 6,920,236 6,920,236 4,898,232 2,022,004 71%4,677,018 (221,214) COMPARATIVE Annual City of Prior Lake Expenditures- Payroll Only As of 09/30/2019 (Preliminary & Unaudited) ACTIVITY FOR Variance from Variance from MONTH 2019 2019 2019 Amended Budget - % BDGT 09/30/2018 from 2018 9/30/2019 Budget Amended Actual YTD Positive (Negative)USED Actual YTD Positive (Negative) COMPARATIVE Annual EDA FUND Function: Economic Development 46500.00 ECONOMIC DEVELOPMENT 7,856 97,587 97,587 76,689 20,898 79%72,535 (4,154) EDA Fund Payroll Only Expenditures Total 7,856 97,587 97,587 76,689 20,898 79%72,535 (4,154) WATER FUND Function: Water 41520.00 Finance 3,805 53,089 53,089 35,525 17,564 67%27,425 (8,100) 49400.00 Water 50,319 496,447 496,447 393,817 102,630 79%333,077 (60,740) Water Fund Payroll Only Expenditures Total 54,124 549,536 549,536 429,343 120,193 78%360,502 (68,840) SEWER FUND Function: Sewer 41520.00 Finance 3,804 50,564 50,564 35,523 15,041 70%27,423 (8,100) 49450.00 Sewer 36,478 477,722 477,722 350,365 127,357 73%323,915 (26,450) Sewer Fund Payroll Only Expenditures Total 40,282 528,286 528,286 385,888 142,398 73%351,337 (34,551) STORM WATER FUND Function: Storm Water 49420.00 Water Quality 19,939 225,752 225,752 173,893 51,859 77%158,746 (15,147) Storm Water Fund Payroll Only Expenditures Total 19,939 225,752 225,752 173,893 51,859 77%158,746 (15,147) City-Wide Total Payroll Expenditures 636,379 8,321,397 8,321,397 5,964,044 2,357,353 72%5,620,139 (343,905)