Loading...
HomeMy WebLinkAbout05(A) - Approval of Claims Listing Report City of Prior Lake Expenditures- Payroll and BenefitsAs of 7/31/2021 (Preliminary & Unaudited)Activity for Activity for Variance from VariancePrevious Month Month 2021 2021 2021 Amended Budget ‐ % BDGT7/31/20from 20206/30/2021 7/31/2021 Budget Amended Actual YTD Positive (Negative) USEDActual YTD Positive (Negative)GENERAL FUNDFunction: General Government41110.00 MAYOR & COUNCIL 5,095                          5,061                          66,234                 66,234                 36,115                 30,119                               55% 33,389                     (2,726)                                    41320.00 ADMINISTRATION 20,616                        30,074                        197,222               197,222               123,871               73,351                               63% 142,736                   18,864                                   41330.00 BOARDS & COMMISSIONS 969                             1,077                          10,765                 10,765                 4,383                   6,382                                 41% 2,368                       (2,015)                                    41400.00 CITY CLERK FUNCTIONS 9,332                          13,787                        120,422               120,422               65,612                 54,810                               54% 63,108                     (2,505)                                    41410.00 ELECTIONS‐                                    ‐                                   3,500                   3,500                   137                       3,363                                 4% 7,677                       7,540                                     41520.00 FINANCE 41,603                        61,485                        537,955               537,955               295,215               242,740                            55% 242,690                   (52,525)                                  41820.00 HUMAN RESOURCES 20,841                        30,847                        271,624               271,624               148,054               123,570                            55% 150,320                   2,265                                     41830.00 COMMUNICATIONS 8,819                          12,980                        128,054               128,054               62,698                 65,356                               49% 60,626                     (2,072)                                    41910.00 COMMUNITY DEVELOPMENT 24,251                        35,462                        317,724               317,724               169,910               147,814                            53% 160,921                   (8,989)                                    41920.00 INFORMATION TECHNOLOGY 17,017                        24,918                        225,935               225,935               121,085               104,850                            54% 82,621                     (38,464)                                  41940.00 FACILITIES ‐ CITY HALL 5,851                          9,340                          91,018                 91,018                 35,296                 55,722                               39% 39,881                     4,586                                     Total ‐ Function General Government 154,395                      225,030                      1,970,453            1,970,453            1,062,378            908,075                            54% 986,338                   (76,040)                                  Function: Public Safety42100.00 POLICE 349,583                      553,961                      4,736,215            4,939,965            2,556,512            2,383,453                         52% 2,393,949                (162,562)                                42200.00 FIRE 38,744                        58,495                        760,123               760,123               288,793               471,330                            38% 258,730                   (30,063)                                  42400.00 BUILDING INSPECTION 51,256                        75,362                        679,565               679,565               363,335               316,230                            53% 325,198                   (38,137)                                  Total ‐ Function Public Safety 439,584                      687,818                      6,175,903            6,379,653            3,208,640            3,171,013                         50% 2,977,878                (230,762)                                Function: Public Works43050.00 ENGINEERING 25,876                        39,240                        350,041               350,041               184,383               165,658                            53% 173,713                   (10,669)                                  43100.00 STREET 35,647                        58,639                        503,876               503,876               273,962               229,914                            54% 250,008                   (23,954)                                  43400.00 CENTRAL GARAGE 17,276                        26,530                        247,198               247,198               127,229               119,969                            51% 126,261                   (967)                                       Total ‐ Function Public Works 78,799                        124,409                      1,101,115            1,101,115            585,573               515,542                            53% 549,982                   (35,591)                                  Function: Culture and Recreation45100.00 RECREATION 22,132                        53,096                        360,011               360,011               166,123               193,888                            46% 135,446                   (30,677)                                  45200.00 PARKS 82,989                        150,679                      1,081,258            1,081,258            540,819               540,439                            50% 492,257                   (48,562)                                  Total ‐ Function Culture and Recreation 105,121                      203,775                      1,441,269            1,441,269            706,943               734,326                            49% 627,703                   (79,240)                                  General Fund Payroll Only Expenditures Total 777,899                      1,241,032                  10,688,740         10,892,490         5,563,534            5,328,956                         51% 5,141,901                (421,633)                                COMPARATIVEAnnual City of Prior Lake Expenditures- Payroll and BenefitsAs of 7/31/2021 (Preliminary & Unaudited)Activity for Activity for Variance from VariancePrevious Month Month 2021 2021 2021 Amended Budget ‐ % BDGT7/31/20from 20206/30/2021 7/31/2021 Budget Amended Actual YTD Positive (Negative) USEDActual YTD Positive (Negative)COMPARATIVEAnnualEDA FUNDFunction:  Economic Development   46500.00 ECONOMIC DEVELOPMENT 10,637                        15,496                        135,544               135,544               78,286                 57,258                               58% 80,298                     2,012                                     EDA Fund Payroll Only Expenditures Total 10,637                        15,496                        135,544               135,544               78,286                 57,258                               58% 80,298                     2,012                                     WATER FUNDFunction: Water41520.00 Finance 5,871                          8,491                          76,881                 76,881                 41,469                 35,412                               54% 40,622                     (847)                                       49400.00 Water 54,136                        84,468                        749,281               749,281               404,402               344,879                            54% 390,402                   (14,000)                                  Water Fund Payroll Only Expenditures Total 60,007                        92,959                        826,162               826,162               445,871               380,291                            54% 431,024                   (14,847)                                  SEWER FUNDFunction: Sewer41520.00 Finance 5,870                          8,490                          76,881                 76,881                 41,463                 35,418                               54% 40,682                     (781)                                       49450.00 Sewer 51,892                        82,602                        731,502               731,502               403,070               328,432                            55% 408,830                   5,760                                     Sewer Fund Payroll Only Expenditures Total 57,762                        91,092                        808,383               808,383               444,534               363,849                            55% 449,512                   4,979                                     STORM WATER FUNDFunction: Storm Water49420.00 Water Quality 26,270                        39,825                        366,879               366,879               185,639               181,240                            51% 183,351                   (2,288)                                    Storm Water Fund Payroll Only Expenditures Total 26,270                        39,825                        366,879               366,879               185,639               181,240                            51% 183,351                   (2,288)                                    City‐Wide Total Payroll Expenditures 932,575                     1,480,405                  12,825,708         13,029,458         6,717,863           6,311,595                         52% 6,286,087               (431,776)                                CHECK REGISTER FOR CITY OF PRIOR LAKE 1/4Page: 08/09/2021 08:55 AM User: Janet DB: Prior Lake CHECK DATE FROM 07/24/2021 - 08/06/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date Bank 1 General Bank 1,612.56 2021 Dental ClaimsDELTA DENTAL000272137472(E)107/26/2021 125.00 Safety Boots 2021ALEX BREEGGEMANN000027897473(A)107/30/2021 4,502.50 Door Repair FS #1AUTOMATED DOOR SERVICE INC000274197474(A)107/30/2021 125.00 Safety Boots 2021CHAD SHIMOTA000270447475(A)107/30/2021 225.00 Ponds & Ryan Parks Restroom CleaningCOVERALL000275717476(A)107/30/2021 470.48 Raymond Lift StationELECTRIC PUMP000231207477(A)107/30/2021 3,289.50 Raymon Lift Station 3,759.98 786.12 7113 Squad supplies EMERGENCY AUTOMOTIVE TECH INC000054807478(A)107/30/2021 786.12 7105 Squad supplies (100.00)Cable Conductor (100.00)Cable Conductor 1,372.24 1,011.95 Firefighter GlovesFIRE EQUIPMENT SPECIALTIES INC000064557479(A)107/30/2021 144.80 Air Filters & System Cleaning - City HalG&B ENVIRONMENTAL INC000278747480(A)107/30/2021 974.00 507 Front tires HART BROS TIRE CO000082377481(A)107/30/2021 19,850.78 Water Treatment ChemicalsHAWKINS INC000083127482(A)107/30/2021 20.53 Conklin - Name PlateINNOVATIVE OFFICE SOLUTIONS LLC000271497483(A)107/30/2021 370.00 Lever - FS #1LOCKSAFE 000108557484(A)107/30/2021 709,097.04 #3 Fish Pt Road Phase I TRN20-0000001MCNAMARA CONTRACTING INC000132867485(A)107/30/2021 393.39 Toro Mower PartsMTI DISTRIBUTING INC000139517486(A)107/30/2021 125.23 Brake Light 108.11 536 Throttle cable 167.18 539 Tail lamp 793.91 95.20 Jun 2021 MileageNICHOLAS MONSERUD000273907487(A)107/30/2021 684.25 Night to Unite ShirtsNORTH AMERICAN SAFETY000145747488(A)107/30/2021 124.89 8540 Headache rack NOVAK COMPANIES000149007489(A)107/30/2021 1,066.59 Attorney Laserfiche LicenseOPG-3 INC000271757490(A)107/30/2021 2,801.28 8313 Accident repair PRIOR LAKE AUTO COLLISION000166047491(A)107/30/2021 319.54 8313 Front windshield mouldings 3,120.82 154.91 480 Repair RIGID HITCH INC000184757492(A)107/30/2021 1,625.00 Roofing Repairs - WTFSCHWICKERT'S TECTA AMERICA LLC000279117493(A)107/30/2021 2,151.00 Roofing Repairs - FS #1 3,776.00 97.76 Squad supplies TERMINAL SUPPLY COMPANY000202707494(A)107/30/2021 61.55 Squad supplies 116.77 Old squad antenna covers 18.36 7112 Terminal Block 294.44 127.24 Emergency ExitVIKING ELECTRIC SUPPLY000226307495(A)107/30/2021 348.00 Jul 2021 HSA Admin FeesALERUS000013757496(E)107/27/2021 1,489.01 Jul 2021 Natural Gas BillsCENTERPOINT ENERGY000135707497(E)107/29/2021 CHECK REGISTER FOR CITY OF PRIOR LAKE 2/4Page: 08/09/2021 08:55 AM User: Janet DB: Prior Lake CHECK DATE FROM 07/24/2021 - 08/06/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date 55,416.41 Jul 2021 Electric BillsXCEL ENERGY000147207498(E)107/29/2021 1,032.58 2021 Dental ClaimsDELTA DENTAL000272137499(E)108/02/2021 2,400.00 Jul 2021 Animal Control4 PAWS ANIMAL CONTROL LLC000067987500(A)108/03/2021 1,380.00 Tow Yamaha R6 #039086 ALLEN'S SERVICE INC000013607501(A)108/03/2021 618.41 Jul 2021 Misc SuppliesCARLSON HARDWARE COMPANY000031257502(A)108/03/2021 7,890.00 Aug 2021 CleaningCOVERALL000275717503(A)108/03/2021 1,408.20 Tractor RepairFLEXIBLE PIPE TOOL CO000066607504(A)108/03/2021 2,186.25 Jul 2021 GeneralHOFF BARRY PA000273877505(A)108/03/2021 660.00 Jul 2021 Annexation 330.00 Jul 2021 Finance 41.25 Jul 2021 Franchises 41.25 Jul 2021 PW/Engineering 371.25 Jul 2021 Recreation 206.25 Jul 2021 EDA 288.75 Jul 2021 Development 206.25 Jul 2021 Towering Woods 137.50 Jul 2021 Cardinal Overlook Addn 82.50 Jul 2021 Fire 247.50 Jul 2021 Code Pt 1 165.00 Jul 2021 Code Pt 11 68.75 Jul 2021 Majestic 5,032.50 848.64 Jul 2021 UniformsHUEBSCH000275367506(A)108/03/2021 101.02 472 GreaseKATH FUEL OIL SERVICE000024107507(A)108/03/2021 15,195.67 Jul 2021 FuelKELLEY FUELS INC000112197508(A)108/03/2021 592.07 Jun 2021 Data & SoftwarePRECISE MOBILE RESOURCE MGMT000165487509(A)108/03/2021 1,011.88 Jul 2021 Misc SuppliesPRIOR LAKE HARDWARE000166587510(A)108/03/2021 1,404.00 Priority Repairs - FS #2SCHWICKERT'S TECTA AMERICA LLC000279117511(A)108/03/2021 575.00 Repairs - Salt Shed 2,400.00 Roofing Inspection - CH 1,000.00 Repairs - WTF 5,379.00 704.00 AsphaltWM MUELLER & SONS INC000236457512(A)108/03/2021 285.97 Aug 2021 Vision PremiumsEYEMED000279177513(E)108/05/2021 46.00 Filing Fee - Res 21-08PCSCOTT COUNTY000192127514(E)107/28/2021 46.00 Filing Fee - Annexation PID 119120042 92.00 234.00 Jul 2021 Yoga InstructorASHLEY BITZAN00028004108541107/30/2021 100.00 Water Efficiency RebateBRIAN ROTHMEYERREFUND-MSC108542107/30/2021 1,035.00 City Hall Window ShadesBUDGET BLINDS00002956108543107/30/2021 1,076.45 BarricadeEARL F ANDERSEN INC00005175108544107/30/2021 2,717.00 Water MetersFERGUSON WATERWORKS #251600006231108545107/30/2021 214.33 Program SuppliesFUN EXPRESS00027257108546107/30/2021 49.73 Program Suppplies 264.06 589.25 TV Wiring - PD ConfHAYES ELECTRIC INC00008315108547107/30/2021 8,750.00 150th St GuardrailINSITE CONTRACTING INC00028021108548107/30/2021 3,380.00 Dehumidifier - WTFKLAMM MECHANICAL CONTRACTORS INC00026904108549107/30/2021 3,380.00 Dehumidifier - Wilds Booster Station 6,760.00 CHECK REGISTER FOR CITY OF PRIOR LAKE 3/4Page: 08/09/2021 08:55 AM User: Janet DB: Prior Lake CHECK DATE FROM 07/24/2021 - 08/06/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date 13,529.00 #8531 Felling TrailerLANO EQUIPMENT INC00012255108550107/30/2021 2,500.00 20-1664 5754 Apex Way NELENNAR HOMESMISC-CD108551107/30/2021 2,500.00 20-1896 5738 Apex Way NE 2,500.00 20-2050 5722 Apex Way NE 2,500.00 20-1500 5771 Apex Way NE 2,500.00 20-1829 5785 Meridian Way NE 2,500.00 20-2305 5798 Apex Way NE 2,500.00 20-2170 5959 Pinnacle Circle NE 17,500.00 37.57 Clay & CaulkMENARDS LUMBER CO00013318108552107/30/2021 6.36 Parts 43.93 1,800.00 2021 Membership MS4 Metro Watershed PartMETRO WATERSHED PARTNERS00026825108553107/30/2021 2,500.00 20-1838 13699 Crowline Drive NEMI HOMES OF MINNEAPOLIS LLCMISC-CD108554107/30/2021 580.00 Foaming Hand SoapMINNCOR INDUSTRIES00013543108555107/30/2021 300.00 Sep 2021-Aug 2022 Membership DuesMN RURAL WATER ASSOC00013674108556107/30/2021 1,001.05 Dell OptiPlex, MonitorNOW MICRO INC00027966108557107/30/2021 3,996.00 2021 Pre-Pay PropaneO'CONNELL OIL CO00015054108558107/30/2021 185.40 City Hall Boiler Replacement Design & CoOERTEL ARCHITECTS00015155108559107/30/2021 81.50 Misc ReimbursementsPETTY CASH00016300108560107/30/2021 1,942.50 Baseball ClassREVOLUTIONARY SPORTS LLC00027855108561107/30/2021 1,684.20 Speed & Agility Camp 3,626.70 870.00 UB - REFUND/OVERPAID #2-07307-01 RICHARD & MELISSA LEWISREFUND-UB108562107/30/2021 2,750.00 Crane TrainingRIDGEWATER COLLEGE00028019108563107/30/2021 100.00 Water Efficiency RebateSCOTT LUNDQUISTREFUND-MSC108564107/30/2021 153,517.82 TIF 1st Half 2021SHEPHERD'S PATH00019450108565107/30/2021 378.48 HydrantUSA BLUEBOOK00021882108566107/30/2021 959.60 Locator RepairUTILITY LOGIC00027760108567107/30/2021 15,517.30 170th St - Transformer InstallationXCEL ENERGY00014720108568107/30/2021 65.00 Pest Control - Club PriorXTREME PEST SOLUTIONS INC00027116108569107/30/2021 86.84 536 sprayer wand repair ALTEC INDUSTRIES INC00027400108570108/03/2021 800.00 8/20/2021 Music in the ParkAMERICAN BOOTLEG 00028025108571108/03/2021 212.25 CoffeeARAMARK REFRESHMENT SERVICES00001772108572108/03/2021 20.96 Coffee 233.21 6,640.00 Interview Rm Camera Storage #2AXON ENTERPRISE INC00027347108573108/03/2021 55.36 Water - 4662 Dakota St SECITY OF PRIOR LAKE00016810108574108/03/2021 929.39 #8531 Trailer Plates & TitleDEPUTY REGISTRAR #16000004400108575108/03/2021 2,709.22 Aug 2021 RefuseDICK'S SANITATION INC00027918108576108/03/2021 31.26 Program SuppliesFUN EXPRESS00027257108577108/03/2021 54.00 Hand SanitizerGRAINGER INC00023030108578108/03/2021 100.00 Water Efficiency RebateHAROLD GARNETTREFUND-MSC108579108/03/2021 2,472.45 CSAH 21/Revere KIMLEY-HORN & ASSOCIATES INC00011372108580108/03/2021 2,500.00 21-0058 5845 Pinnacle Circle NELENNAR HOMESMISC-CD108581108/03/2021 165.98 Poly ClearMENARDS LUMBER CO00013318108582108/03/2021 32.00 Meger - Water Operator Exam ApplicationMN DEPT OF HEALTH00013618108583108/03/2021 32.00 Whitmer - Water Operator Exam Applicatio 32.00 Krenik - Water Operator Exam Application 96.00 CHECK REGISTER FOR CITY OF PRIOR LAKE 4/4Page: 08/09/2021 08:55 AM User: Janet DB: Prior Lake CHECK DATE FROM 07/24/2021 - 08/06/2021 AmountDescriptionVendor NameVendorCheckBankCheck Date 160.00 WoodchipsROCK HARD LANDSCAPE SUPPLY00018571108584108/03/2021 360.00 Sink Rental - Beach Parties, Music in thSPECIALIZED SANITATION00019703108585108/03/2021 3,160.00 Aug 2021 Portable Toilets 3,520.00 466.00 40mm Launcher and munitions STREICHERS00019900108586108/03/2021 300.00 Water Softener SaltTRI COUNTY WATER METRO SOUTH00005247108587108/03/2021 1 TOTALS: 1,116,802.24 Total of 90 Disbursements: 0.00 Less 0 Void Checks: 1,116,802.24 Total of 90 Checks: