Loading...
HomeMy WebLinkAbout2022-05-16 I01A 05162022_bill list_payrollCity of Waukee Bill Presentation Recap May 16, 2022 Total Unpaid Bills Presented for Approval : $ 1,303,060.88 Total Checks Issued Prior to Council Approval: (A) Prior to Last Council Meeting $ 570,311.84 (B) After Last Council Meeting $ 13,754.61 (C) After Last Council Meeting $ 248.00 (D) Payroll Taxes & Reimbursements $ 152,273.66 (E) Utility Refunds $ 2,130.76 Payroll Checks Issued: (F) 05/13/2022 $ 302,211.01 - Grand Total: FY 2022 Fund Recap: Expenditures Budgeted Year To Date 010 General Fund $ 16,326,795 $ 14,585,172 011 General Fund-Hotel/Motel Tax $ 13,800 $ 22,418 060 Road Use Tax Fund $ 3,266,914 $ 2,457,342 070 Firemen's Association $ - $ - 080 Library Foundation $ - 085 Asset Forfeitures $ - 090 North Residential TIF $ 91,444 091 Hickman West Indust Park TIF $ 758,806 092 Enterprise Business Park TIF Fund $ - 093 Waukee Urban Renewal Area TIF Fund $ 6,949,333 094 Gateway Urban Renewal $ 1,991,977 095 Autumn Ridge Urban Renewal $ 492,992 096 Waukee West Urban Renewal $ 2,500 097 Southwest Business Park $ 93,000 098 Waukee Central URA $ 176,800 110 Debt Service Fund $ 14,538,957 111 Special Assessments Fund $ - 210 Employee Benefits Fund $ 2,600,000 211 Local Option Sales Tax $ 1,097,969 212 Public Improvement Fund $ - 327 Capital Projects $ 45,120,941 330 City Wide SA Sidewalk Project $ - 510 Water Utility Fund $ 8,197,060 520 Sewer Utility Fund $ 7,179,626 521 University Ave Trunk Sewer Project $ - 522 Waste Water Treatment PI $ - 523 E Area Pump Sta Treatment $ - 540 Gas Utility Fund $ 9,400,209 560 Storm Sewer Utility Fund $ 1,306,771 570 Utility Bill Fund $ 442,610 590 Solid Waste Collect & Rcycl Fund $ 1,528,400 750 Golf Course Fund $ 582,532 810 Equipment Revolving Fund $ 30,000 326 3,777 811,446 1,114 26,219 92,428 1,675,334 22,736,974 5,667,690 6,045,694 8,801,674 622,081 340,076 1,490,658 387,619 $ 2,343,990.76 Revenues udaeted Year To Date 16,767,357 $ 13,773,560 48,100 $ 78,555 3,127,850 $ 2,442,131 - $ - 819,208 4,344,814 2,610,558 716,298 93,182 179,086 16,172,409 2,651,127 3,176,500 22,315,000 6,397,300 6,460,900 8,554,950 1,192,200 417,600 1,527,500 600,000 $ 1,239,680 $ 4,259,438 $ 2,430,737 $ 715,799 $ 87,296 $ 5,248,559 $ 18,724 $ 2,577,415 $ 3,593,077 $ 504,354 $ 25,590,177 $ 1,351 $ 8,848,513 $ 7,506,656 $ 1,231 $ 106 $ 372 $ 10,600,539 $ 1,158,648 $ 395,756 $ 1,330,493 $ 622,356 $ 486 Total: $122,189,436 $ 65,768,042 $ 98,171,939 $ 93,026,008 City of Waukee FY2022 Department Report - General Fund As of May 16, 2022 Expended YTD Budgeted $ Remaining General Fund: Police Department Personnel Services $ 3,189,071 $ 3,924,300 Supplies & Services $ 401,337 $ 539,210 Capital Outlay $ 167,595 $ 169,200 $ 3,758,002 $ 4,632,710 $ 874,708 Warning Sirens Personnel Services $ - $ - Supplies & Services $ 34,078 $ 4,700 Capital Outlay $ - $ 42,000 $ 34,078 $ 46,700 $ 12,622 Emergency Management Supplies & Services $ 281 $ - $ 281 $ - $ (281) Westcom Dispatch Personnel Services $ - $ - Supplies & Services $ 445,167 $ 691,000 Capital Outlay $ - $ - Fire Department EMS Building Inspection Animal Control Library Services Mosquito Control Community Services $ 445,167 $ 691,000 $ Personnel Services $ 752,095 $ 909,675 Supplies & Services $ 145,231 $ 181,360 Capital Outlay $ 2,820 $ - Other Financing $ 1,203 $ 901,349 $ 1,091,035 $ Personnel Services $ 1,598,140 $ 1,850,575 Supplies & Services $ 172,323 $ 224,260 Capital Outlay $ 305,675 $ 78,000 $ 2,076,138 $ 2,152,835 $ Personnel Services $ 614,582 $ 633,600 Supplies & Services $ 34,654 $ 31,900 Capital Outlay $ 27,360 $ 60,000 $ 676,596 $ 725,500 $ Personnel Services $ - $ - Supplies & Services $ 6,919 $ 31,000 Capital Outlay $ - $ - $ 6,919 $ 31,000 $ Personnel Services $ 710,526 $ 979,090 Supplies & Services $ 271,013 $ 315,000 Capital Outlay $ - $ - $ 981,539 $ 1,294,090 $ 245,833 189,686 76,697 48,904 24,081 312,551 Personnel Services $ - $ - Supplies & Services $ - $ 2,000 Capital Outlay $ - $ - $ - $ 2,000 $ 2,000 Personnel Services $ - $ - Supplies & Services $ 25,000 $ 49,000 Capital Outlay $ - $ - $ 25,000 $ 49,000 $ 24,000 Parks Personnel Services $ 327,473 $ 453,550 Supplies & Services $ 251,565 $ 255,590 Capital Outlay $ 174,083 $ 165,000 $ 753,121 $ 874,140 $ Recreation Personnel Services $ 503,953 $ 574,250 Supplies & Services $ 266,141 $ 250,990 Capital Outlay $ 7,692 $ 8,000 $ 777,786 $ 833,240 $ Triumph Park Personnel Services $ 58,329 $ 109,700 Supplies & Services $ 3,820 $ 53,775 Capital Outlay $ - $ 62,150 $ 163,475 $ Community Center Personnel Services $ 4,445 $ 6,000 Supplies & Services $ 20,639 $ 25,000 $ 25,084 $ 31,000 $ Vineyard Supplies & Services $ 5,903 $ 11,000 $ 5,903 $ 11,000 $ Public Works Personnel Services $ (555) $ 69,420 Supplies & Services $ (10,768) $ 6,620 Capital Outlay $ 175 $ - $ (11,148) $ 76,040 $ Public Works Building Personnel Services $ - $ - Supplies & Services $ 274,012 $ Capital Outlay $ - $ - $ 274,012 $ - $ Public Works Mechanic Personnel Services $ 169,409 $ 211,850 Supplies & Services $ 125,193 $ (15,990) Capital Outlay $ - $ - $ 294,602 $ 195,860 $ Median and Bldg Grounds Personnel Services $ - $ - Supplies & Services $ 15,541 $ 25,000 Capital Outlay $ - $ - $ 15,541 $ 25,000 $ Mayor & Council Personnel Services $ 50,897 $ 63,900 Supplies & Services $ 22,578 $ 30,750 Capital Outlay $ - $ - $ 73,475 $ 94,650 $ Elections Personnel Services $ - $ - Supplies & Services $ 6,787 $ 10,000 Capital Outlay $ - $ - $ 6,787 $ 10,000 $ Communications Personnel Services $ 74,026 $ 130,440 Supplies & Services $ 30,608 $ 47,960 Capital Outlay $ - $ - $ 104,634 $ 178,400 $ Administration Personnel Services $ 381,051 $ 252,600 Supplies & Services $ 155,480 $ 144,000 121,019 55,454 101,325 5,916 5,097 87,188 (274,012) (98,742) 9,459 21,175 3,213 73,766 Capital Outlay $ 902,547 $ - $ 1,439,078 $ 396,600 $ (1,042,478) City Hall Personnel Services $ - $ - Supplies & Services $ 126,830 $ 147,500 Capital Outlay $ - $ - $ 126,830 $ 147,500 $ 20,670 Human Resources Personnel Services $ 89,815 $ 131,750 Supplies & Services $ 38,165 $ 23,830 Capital Outlay $ - $ 127,979 $ 155,580 $ 27,601 Financial Administration Personnel Services $ 94,490 $ 236,500 Supplies & Services $ 20,274 $ 31,250 Capital Outlay $ - Other Financing $ - $ 15,000 $ 114,763 $ 282,750 $ 167,987 Economic Development Personnel Services $ 113,152 $ 140,320 Supplies & Services $ 75,956 $ 107,700 Capital Outlay $ - $ - $ 189,108 $ 248,020 $ 58,912 City Attorney Personnel Services $ - $ - Supplies & Services $ 170,206 $ 150,000 Capital Outlay $ - $ - $ 170,206 $ 150,000 $ (20,206) Community Development Personnel Services $ 262,415 $ 465,510 Supplies & Services $ 60,888 $ 75,350 Capital Outlay $ - $ - $ 323,303 $ 540,860 $ 217,557 Information Technology Personnel Services $ 90,530 $ 247,740 Supplies & Services $ 101,404 $ 120,700 Capital Outlay $ 57,240 $ 43,700 $ 249,173 $ 412,140 $ 162,967 Engineering Personnel Services $ 398,442 $ 528,700 Supplies & Services $ 143,939 $ 212,570 Capital Outlay $ - $ - $ 542,381 $ 741,270 $ 198,890 GIS Personnel Services $ (31,092) $ 38,300 Supplies & Services $ 46,429 $ 2,700 Capital Outlay $ - $ 2,400 $ 15,336 $ 43,400 $ 28,064 Transfers to GO Debt Service $14,585,172 $16,326,795 $ 1,741,623 Total General Fund: Personnel Services $ 9,451,473 Supplies & Services $ 3,487,310 Capital Outlay $ 1,645,186 Other $ 1,203.25 $14,585,172 Expense Approval Register City of Waukee, IA APPKT02860 - MAY 16 2022 COUNCIL MEETING Waukee Vendor Name Payable Number Post Date Description (Item) Account Number Amount TREASURER STATE OF IOWA INVO013444 04/30/2022 APR'22 WATER EXCISE TAXES 510-2030500 22,919.85 TREASURER STATE OF IOWA INVO013445 04/30/2022 APR'22 SEWER SALES TAXES 520-2030500 3,945.21 TREASURER STATE OF IOWA INVO013446 04/30/2022 APR'22 GAS SALES TAXES 540-2030500 12,272.16 TREASURER STATE OF IOWA INVO013447 04/30/2022 APR'22 STORM WATER SALE 560-2030500 2,324.82 TREASURER STATE OF IOWA INVO013448 04/30/2022 APR'22 GOLF COURSE SALES 750-2030500 2,641.72 TREASURER STATE OF IOWA INVO013449 04/30/2022 APR '22 PARKS & REC SALES T 010-2030500 273.45 CHRISTOPHER RANALLO INVO013465 05/17/2022 RESERVE AT DAYBREAK LOT 2 010-2035000 500.00 GENESIS HOMES, INC. INVO013492 05/17/2022 LANDING AT KETTLESTONE L 010-2035000 1,200.00 46,077.21 Department: 2100 - POLICE OPERATIONS GALL'S INC 020876599 04/08/2022 PANTS- SPOSETO 010-10.1100.120000 119.98 GALL'S INC 020899889 04/12/2022 PANTS- SPOSETO 010-10.1100.120000 59.99 GALL'S INC 020909762 04/12/2022 PANTS- SPOSETO CREDIT 010-10.1100.120000 -119.98 GALL'S INC 020913070 04/13/2022 BOOTS- RICHARDSON 010-10,1100.120000 110.90 GALL'S INC 020919474 04/13/2022 OUTER VEST- MURRA 010-10.1100.120000 408.99 ULINE 147845329 04/19/2022 OFFICE CHAIR 010-10.1100.540000 359.66 AMAZON.COM 1N1K-YYL7-9NHT 04/26/2022 LENOVO AC ADAPTERS/KEYS 010-10.1100.540000 139.88 ORKIN PEST CONTROL 226284514 04/27/2022 PEST CONTROL- PD 010-10.1100.400000 117.00 IOWA POLICE CHIEFS ASSOCI 3256 04/20/2022 IPCA ANNUAL CONFERENCE- 010-10.1100.470000 50.00 MPH INDUSTRIES, INC. 6017502 04/28/2022 TRAILER COVER 010-10.1100.540000 197.00 STIVERS FORD 658008 04/26/2022 REPLACED TURN SIGNAL BUL 010-10.1100.410000 28.40 STIVERS FORD 658121 04/28/2022 MIL ON/REPLACE SPARK PLU 010-10.1100.410000 613.81 STAPLES BUSINESS CREDIT 7353968419-0-1 04/06/2022 LAMINATE POUCHES/PLASTI 010-10.1100.580000 25.99 STAPLES BUSINESS CREDIT 7353968419-0-1 04/06/2022 LAMINATE POUCHES/PLASTI 010-10.1100.590000 100.66 STAPLES BUSINESS CREDIT 7355018439-0-1 04/20/2022 PRINTER INK 010-10.1100.580000 276.06 WALSH DOOR & SECURITY 779635 04/13/2022 DOOR NOT LATCHING 010-10.1100.400000 174.91 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-10.1100.270110 15.54 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-10.1100.270110 35.22 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-10.1100.270110 15.55 CITY OF WAUKEE APR 22 PUBLIC SAFETY 04/30/2022 APRIL 2022 STATEMENT 010-10.1100.480000 785.03 SHI INTERNATIONAL CORP B15078391 04/15/2022 LAPTOP/SPLIT CABLE 010-10.1100.540000 2,224.70 SHI INTERNATIONAL CORP B15089664 04/18/2022 TP TBT 4 DOCK 010-10.1100.540000 276.20 SHI INTERNATIONAL CORP B15149327 04/28/2022 BROKEN LAPTOP REPLACEM 010-10.1100.540000 1,747.60 AMERITAS LIFE INSURANCE C INVO013442 05/01/2022 MAY'22 VISION INSURANCE 010-10.1100.100000 612.52 CONSOLIDATED COMMUNIC INVO013493 05/01/2022 MAY 2022 STATEMENT- PUBL 010-10.1100.450000 126.50 EMPLOYEE BENEFIT SYSTEM INVO013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-10.1100.100000 44,042.66 KING'S MATERIAL INC KMI7977549 04/19/2022 MULCH 010-10.1100.400000 109.65 KING'S MATERIAL INC KMI7977825 04/20/2022 MULCH 010-10.1100.400000 73.10 STANARD & ASSOCIATES INC SA000050175 04/26/2022 OFFICER TESTING 010-10.1100.470000 75.50 Department 1100 - POLICE OPERATIONS Total: 52,803.02 Department: 1400 - FIRE PROTECTION GALL'S INC 021035086 04/28/2022 T-SHIRTS- MULTIPLE EMPLOY 010-10.1400.120000 46.15 GALL'S INC 021035088 04/28/2022 T-SHIRTS- MULTIPLE EMPLOY 010-10.1400.120000 32.28 DINGES FIRE COMPANY 09051 04/21/2022 ADAPTERS 010-10.1400.540000 291.73 AMAZON.COM 11XL-QKP6-MFHR 04/25/2022 COFFEE 010-10.1400.590000 32.96 AMAZON.COM 14J3-4RLV-YRKF 04/17/2022 BATTERIES/NOTE PADS 010-10.1400.580000 4.53 AMAZON.COM 14J3-4RLV-YRKF 04/17/2022 BATTERIES/NOTE PADS 010-10.1400.590000 9.50 AMAZON.COM 19M6-MT4C-RL9L 04/24/2022 GARAGE DOOR OPENER/COF 010-10.1400.590000 8.47 FIRE SERVICE TRAINING BUR 221529 04/26/2022 BASIC FIRE INVESTIGATION C 010-10.1400.470000 600.00 DINGES FIRE COMPANY 28125 04/21/2022 FIRE GLOVES 010-10.1400.540000 223.20 MOTOROLA SOLUTIONS INC 8281366067 04/26/2022 ANTENNAS 010-10.1400.540000 15.09 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-10.1400.270110 17.61 CITY OF WAUKEE APR 22 PUBLIC SAFETY 04/30/2022 APRIL 2022 STATEMENT 010-10.1400.480000 638.98 AMERITAS LIFE INSURANCE C INVO013442 05/01/2022 MAY'22 VISION INSURANCE 010-10.1400.100000 133.67 5/11/2022 8:37:44 AM Page 1 Of 16 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount CONSOLIDATED COMMUNIC INV0013493 05/O1/2022 MAY 2022 STATEMENT- PUBL 010-10.1400.450000 27.83 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-10.1400.100000 9,448.99 ALADTEC INV00181136 04/29/2022 ANNUAL SUBSCRIPTION 010-10.1400.270000 40.71 SANDRY FIRE SUPPLY LLC INV-020880 03/28/2022 BOOTS 010-10.1400.540000 948.95 SANDRY FIRE SUPPLY LLC INV-021012 04/01/2022 2022 MSA SCBA REPAIR 010-10.1400.410100 10.45 KING'S MATERIAL INC KMI7977549 04/19/2022 MULCH 010-10.1400.400000 54.82 KING'S MATERIAL INC KMI7977825 04/20/2022 MULCH 010-10.1400.400000 36.55 Department 1400 - FIRE PROTECTION Total: 12,622.47 Department: 1500 - EMS GALL'S INC 021035086 04/28/2022 T-SHIRTS- MULTIPLE EMPLOY 010-10.1500.120000 163.62 GALL'S INC 021035088 04/28/2022 T-SHIRTS- MULTIPLE EMPLOY 010-10.1500,120000 114.44 AMAZON.COM 11XL-QKP6-MFHR 04/25/2022 COFFEE 010-10.1500.590000 116.87 AMAZON.COM 14J3-4RLV-YRKF 04/17/2022 BATTERIES/NOTE PADS 010-10.1500.580000 4.53 AMAZON.COM 14J3-4RLV-YRKF 04/17/2022 BATTERIES/NOTE PADS 010-10.1500.590000 9.49 AMAZON.COM 19M6-MT4C-RL9L 04/24/2022 GARAGE DOOR OPENER/COF 010-10.1500.590000 30.01 AMAZON.COM 1TTK-J4JY-FK6T 05/O1/2022 TRAVEL TOOTHBRUSH CASE/ 010-10.1500.590000 45.28 KELTEK INCORPORATED 5262 03/08/2022 AMBULANCE ANTENNA REP 010-10.1500.710310 411.86 MOTOROLA SOLUTIONS INC 8281366067 04/26/2022 ANTENNAS 010-10.1500.540000 53.49 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-10.1500.270100 17.61 CITY OF WAUKEE APR 22 PUBLIC SAFETY 04/30/2022 APRIL 2022 STATEMENT 010-10.1500.480000 401.64 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 010-10.1500.100000 246.61 CONSOLIDATED COMMUNIC INV0013493 05/O1/2022 MAY 2022 STATEMENT- PUBL 010-10.1500.450000 98.67 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-10.1500.100000 16,606.63 ALADTEC INV00181136 04/29/2022 ANNUAL SUBSCRIPTION 010-10.1500.270000 144.34 KING'S MATERIAL INC KMI7977549 04/19/2022 MULCH 010-10.1500.400000 54.82 KING'S MATERIAL INC KMI7977825 04/20/2022 MULCH 010-10.1500.400000 36.55 Department 1500 - EMS Total: 18,556.46 Department: 1600 - STREET LIGHTING MID AMERICAN ENERGY APR221600SUMBILL 04/26/2022 APRIL 2022 STATEMENT 060-30.1600.480000 19,196.66 Department 1600 - STREET LIGHTING Total: 19,186.66 Department: 1601 - TRAFFIC SIGNALS TRAFFIC CONTROL CORPORA 135691 04/28/2022 GPS PREEMPTION VEHICLE K 060-30.1601.410300 43,500.00 IOWA SIGNAL INC 5176 04/14/2022 TRAFFIC SIGNAL REPAIR 060-30.1601.410300 820.00 IOWA SIGNAL INC 5195 04/28/2022 TRAFFIC SIGNALS 060-30.1601.410300 1,290.00 IOWA SIGNAL INC 5196 04/28/2022 STREET SIGN REPAIR 060-30.1601.410300 280.00 IOWA SIGNAL INC 5197 04/28/2022 GRIDSMART CLEANING 060-30.1601.410300 290.00 IOWA SIGNAL INC 5198 04/28/2022 REMOVE HANDHOLE 060-30.1601.410300 560.00 MID AMERICAN ENERGY APR221601SUMBILL 04/26/2022 APRIL 2022 STATEMENT 060-30.1601.480000 1,335.51 CITY OF WEST DES MOINES PW-2022-00065065 05/02/2022 2022 1ST QUARTER TRAFFIC 060-30.1601.480000 172.10 Department 1601 - TRAFFIC SIGNALS Total: 48,247.61 Department: 1900 - BUILDING INSPECTION STAPLES BUSINESS CREDIT 7354237489-0-1 04/08/2022 COFFEE/PAPER/STAPLE REM 010-10.1900.580000 34.74 STAPLES BUSINESS CREDIT 7354237489-2-1 04/14/2022 MARK 010-10.1900.580000 -3.00 AMERITAS LIFE INSURANCE C INV0013442 05/01/2022 MAY'22 VISION INSURANCE 010-10.1900.100000 141.00 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-10.1900.100000 10,206.22 Department 1900 - BUILDING INSPECTION Total: 10,378.96 Department: 2132 - ASHWORTH ROAD IMPROVEMENTS FOTH INFRASTRUCTURE & E 76334 01/31/2022 SE ASHWORTH RD CORRIDO 327-90.2132.230000 1,663.14 FOTH INFRASTRUCTURE & E 77219 03/31/2022 SE ASHWORTH RD CORRIDO 327-90.2132.230000 6,835.36 Department 2132 - ASHWORTH ROAD IMPROVEMENTS Total: 8,498.50 Department: 2150 - PARK & REC COMPLEX TEAM SERVICES INC 1810058-0 03/31/2022 TRIUMPH PARK 327-90.2150.980110 54.75 AMAZON.COM 1WG7-9LN1-C1KH 05/05/2022 TRIUMPH PARK TRASH CANS 327-90.2150.980110 2,907.89 MENARDS 28913 04/22/2022 SHOVEL/HANGING SCALE 327-90.2150.980110 98.97 MOLLY OLSON M2051 05/05/2022 TRIUMPH PARK MAP DESIGN 327-90.2150.980110 630.00 Department 2150 - PARK & REC COMPLEX Total: 3,691.61 Department: 2160 - PUBLIC WORKS BUILDING TEAM SERVICES INC 1810126-0 03/31/2022 PUBLIC WORKS SITE EXPANSI 327-90.2160.230000 889.10 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount FARNSWORTH GROUP, INC 232537 03/31/2022 PUBLIC WORKS SITE EXPANSI 327-90.2160.230000 9,399.63 FARNSWORTH GROUP, INC 232542 03/31/2022 PUBLIC WORKS BLDG 2ND FL 327-90.2160.230000 1,182.94 Department 2160 - PUBLIC WORKS BUILDING Total: 11,471.67 Department: 3100 - LIBRARY SERVICES OFFICE DEPOT 240670579001 04/22/2022 BATTERIES/LABELS/PAPER/T 010-40.3100.580000 106.93 OFFICE DEPOT 240670579001 04/22/2022 BATTERIES/LABELS/PAPER/T 010-40.3100.590000 226.42 OFFICE DEPOT 240708591001 04/22/2022 RUBBING ALCOHOL 010-40.3100.590000 14.67 WASH -ECLAIR 256764 04/25/2022 WINDOW WASHING 010-40.3100.400000 495.00 INGRAM LIBRARY SERVICES 57711979 02/09/2022 BOOKS 010-40.3100.590000 25.47 INGRAM LIBRARY SERVICES 57711979 02/09/2022 BOOKS 010-40.3100.640000 231.72 INGRAM LIBRARY SERVICES 57711980 02/09/2022 BOOKS 010-40.3100.590000 13.98 INGRAM LIBRARY SERVICES 57711980 02/09/2022 BOOKS 010-40.3100.640000 108.79 INGRAM LIBRARY SERVICES 57711981 02/09/2022 BOOKS 010-40.3100.590000 22.51 INGRAM LIBRARY SERVICES 57711981 02/09/2022 BOOKS 010-40.3100.640000 214.62 INGRAM LIBRARY SERVICES 57711982 02/09/2022 BOOKS 010-40.3100.590000 11.35 INGRAM LIBRARY SERVICES 57711982 02/09/2022 BOOKS 010-40.3100.640000 134.92 INGRAM LIBRARY SERVICES 58901602 04/10/2022 BOOKS 010-40.3100.590000 25.41 INGRAM LIBRARY SERVICES 58901602 04/10/2022 BOOKS 010-40.3100.640000 268.81 INGRAM LIBRARY SERVICES 58901603 04/10/2022 BOOKS 010-40.3100.590000 29.40 INGRAM LIBRARY SERVICES 58901603 04/10/2022 BOOKS 010-40.3100.640000 199.03 INGRAM LIBRARY SERVICES 58901604 04/10/2022 BOOKS 010-40.3100.590000 5.00 INGRAM LIBRARY SERVICES 58901604 04/10/2022 BOOKS 010-40.3100.640000 47.94 INGRAM LIBRARY SERVICES 58969701 04/13/2022 BOOKS 010-40.3100.590000 10.96 INGRAM LIBRARY SERVICES 58969701 04/13/2022 BOOKS 010-40.3100.640000 93.84 INGRAM LIBRARY SERVICES 58995644 04/14/2022 BOOKS 010-40.3100.590000 21.80 INGRAM LIBRARY SERVICES 58995644 04/14/2022 BOOKS 010-40.3100.640000 260.72 INGRAM LIBRARY SERVICES 59018699 04/15/2022 BOOKS 010-40.3100.590000 20.96 INGRAM LIBRARY SERVICES 59018699 04/15/2022 BOOKS 010-40.3100.640000 133.32 INGRAM LIBRARY SERVICES 59018700 04/15/2022 BOOKS 010-40.3100.590000 5.17 INGRAM LIBRARY SERVICES 59018700 04/15/2022 BOOKS 010-40.3100.640000 64.16 INGRAM LIBRARY SERVICES 59097482 04/20/2022 BOOKS 010-40.3100.590000 11.04 INGRAM LIBRARY SERVICES 59097482 04/20/2022 BOOKS 010-40.3100.640000 195.14 INGRAM LIBRARY SERVICES 59097483 04/20/2022 BOOKS 010-40.3100.640000 63.72 INGRAM LIBRARY SERVICES 59097484 04/20/2022 BOOKS 010-40.3100.590000 13.48 INGRAM LIBRARY SERVICES 59097484 04/20/2022 BOOKS 010-40.3100.640000 55.65 INGRAM LIBRARY SERVICES 59097485 04/20/2022 BOOKS 010-40.3100.590000 13.01 INGRAM LIBRARY SERVICES 59097485 04/20/2022 BOOKS 010-40.3100.640000 253.33 INGRAM LIBRARY SERVICES 59122153 04/21/2022 BOOKS 010-40.3100.590000 13.79 INGRAM LIBRARY SERVICES 59122153 04/21/2022 BOOKS 010-40.3100.640000 133.25 INGRAM LIBRARY SERVICES 59122154 04/21/2022 BOOKS 010-40.3100.590000 10.11 INGRAM LIBRARY SERVICES 59122154 04/21/2022 BOOKS 010-40.3100.640000 85.73 DEMCO INC. 7118371 04/25/2022 LABEL PROTECTORS/BOOK T 010-40.3100.580000 226.75 CULTUREALL, INC. 72195 03/31/2022 FEBRUARY- APRIL SATURDAY 010-40.3100.460300 670.00 LIBRARY IDEAS LLC 88841 04/08/2022 BOOKS 010-40.3100.640000 603.14 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-40.3100.270110 35.22 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-40.3100.270110 35.22 CITY OF WAUKEE APR 22 LIBRARY 04/30/2022 APRIL 2022 STATEMENT 010-40.3100.480000 385.27 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 010-40.3100.100000 107.12 SHERRY LEVINE INV0013496 04/25/2022 ADULT SUMMER PROGRAM 010-40.3100.460400 40.00 AMANDAARTHUR-STRUSS INV0013497 05/04/2022 ADULT SUMMER PROGRAM 010-40.3100.460400 200.00 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-40.3100.100000 7,445.16 DISCOUNT SCHOOL SUPPLY P41260620101 04/14/2022 KIDS SUMMER PROGRAM SU 010-40.3100.460400 686.01 ONE SOURCE PLUS4380-20220430 04/30/2022 PRE -EMPLOYMENT BACKGR 010-40.3100.470000 35.00 Department 3100 - LIBRARY SERVICES Total: 24,210.04 Department: 4100 - PARKS BOLTON & MENK, INC 0287364 04/15/2022 SUGAR CREEK PARK 327-90,4100.880089 2,400.00 SHERWIN WILLIAMS CO 1434-3 04/08/2022 NARROW HELIX MIXER/5 GA 010-40.4100.590000 17.29 SHERWIN WILLIAMS CO 1457-4 04/08/2022 FIELD PAINT 010-40.4100.590000 32.49 SHERWIN WILLIAMS CO 1575-3 04/11/2022 FIELD PAINT 010-40.4100.590000 35.99 KAY PARK-REC CORP 195370 04/20/2022 DRINKING FOUNTAIN REPAIR 010-40.4100.410310 515.86 S/11/2022 8:37:44 AM Page 3 of 16 Expense Approval Register Vendor Name PARK WAREHOUSE MENARDS MENARDS MENARDS ROTO ROOTER ROTO ROOTER ROTO ROOTER DOORS INC DES MOINES STEEL FENCE PORTABLE PRO, INC BAXSALES INC PLUMB SUPPLY COMPANY PLUMB SUPPLY COMPANY PLUMB SUPPLY COMPANY WAUKEE POWER EQUIPMEN WAUKEE POWER EQUIPMEN WAUKEE POWER EQUIPMEN WAUKEE POWER EQUIPMEN WAUKEE POWER EQUIPMEN WAUKEE POWER EQUIPMEN WAUKEE POWER EQUIPMEN WAUKEE POWER EQUIPMEN CUSTOM AWARDS CITY OF WAUKEE CITY OF WAUKEE CITY OF WAUKEE CITY OF WAUKEE CITY OF WAUKEE CITY OF WAUKEE CITY OF WAUKEE CITY OF WAUKEE CITY OF WAUKEE MID AMERICAN ENERGY AMERITAS LIFE INSURANCE C AMERITAS LIFE INSURANCE C AMERITAS LIFE INSURANCE C EMPLOYEE BENEFIT SYSTEM EMPLOYEE BENEFIT SYSTEM EMPLOYEE BENEFIT SYSTEM KING'S MATERIAL INC WD DESIGNS WD DESIGNS Payable Number 255219 28372 28625 28914 316448 316470 317207 318653 58380 65444 68284 8008951 8019657 8025473 82278 82319 82322 82480 82605 83071 83081 83109 95005 APR 22 ALICE NIZZI PARK APR 22 CENT PARK IR APR 22 DOG PARK APR 22 GRANT PARK APR 22 RIDGE POINT APR 22 SPLASH PAD APR 22 TRAILHEAD APR 22 WESTOWN MEADO APR 22 WINDFIELD APR224100SUMBILL INV0013442 INV0013442 INV0013442 INV0013498 INV0013498 INV0013498 K M 17979309 WAUKEE STAFF SPRING 2 WAUKEE STAFF SPRING Post Date 04/25/2022 04/14/2022 04/18/2022 04/22/2022 04/25/2022 05/02/2022 04/29/2022 04/20/2022 04/29/2022 04/27/2022 04/21/2022 04/11/2022 04/18/2022 04/18/2022 04/22/2022 04/22/2022 04/22/2022 04/26/2022 04/27/2022 05/04/2022 05/04/2022 O5/04/2022 02/03/2022 04/30/2022 04/30/2022 04/30/2022 04/30/2022 04/30/2022 04/30/2022 04/30/2022 04/30/2022 04/30/2022 04/26/2022 05/01/2022 05/01/2022 05/01/2022 05/10/2022 05/10/2022 05/10/2022 04/27/2022 04/26/2022 04/26/2022 Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Description (Item) TRIANGLE PARK LEADERSHIP PAPER TOWELS DOOR CLOSER ADDRESS NUMBERS FOX CREEK SEWER FOX CREEK SEWER FOX CREEK SEWER DOG PARK GATE FOX CREEK FENCE REPAIR PORTABLE RESTROOMS- WA CABLE TIES REGULATOR CART REGULATOR CARTS REGULATOR CART MOWER MAINTENANCE MOWER REPAIR MOWER REPAIR CREDIT WEED EATER LINE WEED EATERS/BATTERIES MOWER REPAIR EDGER BLADE MOWER REPAIR PLAQUE- ETHAN OWENS APRIL 2022 STATEMENT APRIL 2022 STATEMENT APRIL 2022 STATEMENT APRIL 2022 STATEMENT APRIL 2022 STATEMENT APRIL 2022 STATEMENT APRIL 2022 STATEMENT APRIL 2022 STATEMENT APRIL 2022 STATEMENT APRIL 2022 STATEMENT MAY'22 VISION INSURANCE MAY'22 VISION INSURANCE MAY'22 VISION INSURANCE JUN'22 HEALTH INSURANCE JUN '22 HEALTH INSURANCE JUN '22 HEALTH INSURANCE MULCH PARKS & REC STAFF SHIRTS PARKS STAFF SHIRTS Account Number 010-40.4100.760000 010-40.4100.590000 010-40.4100.410300 010-40.4100.590000 010-40.4100.410300 010-40.4100.410300 010-40.4100.410300 010-40.4100.410310 010-40.4100.410300 010-40.4100.480000 010-40.4100.590011 010-40.4100.410300 010-40.4100.410300 010-40.4100.410300 010-40.4100.410100 010-40.4100.410100 010-40.4100.410100 010-40.4100.590000 010-40.4100.540000 010-40.4100.410100 010-40.4100.590000 010-40.4100.410100 010-40.4100.590000 010-40.4100.480000 010-40.4100.480100 010-40.4100.480010 010-40.4100.480000 010-40.4100.480000 010-40.4100.480011 010-40.4100.480000 010-40.4100.480000 010-40.4100.480000 010-40.4100.480000 010-40.4100.100000 010-40.4100.100000 010-40.4100.100000 010-40.4100.100000 010-40.4100.100000 010-40.4100.100000 010-40.4100.410300 010-40.4100.120000 010-40.4100.120000 Department 4100 - PARKS Total: Amount 5,656.91 4.48 52.99 23.92 1,150.00 800.00 850.00 419.00 1,090.00 180.00 75.30 39.45 39.45 39.45 137.46 467.53 -12.83 11.49 759.96 27.81 17.20 825.42 16.00 25.49 284.98 78.09 53.09 288.82 561.43 49.99 59.34 84.34 463.86 8.99 13.62 48.60 901.98 601.32 3,221.68 109.65 20.98 828.30 23,377.17 Department: 4200 - RECREATION FAREWAY STORES, INC. 00183500 05/03/2022 SPRING SOFTBALL CONCESSI 010-40.4200.460520 15.92 FAREWAY STORES, INC. 00242110 04/25/2022 SPRING SOFTBALL CONCESSI 010-40.4200.460520 13.98 LIFETIME ATHLETIC 243 04/29/2022 SPRING TENNIS SESSIONS 7- 010-40.4200.460500 1,674.40 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-40.4200.270110 17.61 CUSTOM AWARDS 95005 02/03/2022 PLAQUE- ETHAN OWENS 010-40.4200.590000 16.00 AMERITAS LIFE INSURANCE C INV0013442 OS/O1/2022 MAY'22 VISION INSURANCE 010-40.4200.100000 75.84 PHIL DICKEY INV0013453 04/21/2022 SESSION 5 KARATE CLASSES 010-40.4200.460550 1,388.00 STUDIO BEA DANCE INV0013454 05/03/2022 SPRING SESSION 1/ 2 TO MO 010-40.4200.460500 252.00 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 1UN'22 HEALTH INSURANCE 010-40.4200.100000 5,025.64 BACKGROUND INVESTIGATIO WA0005050122-1 05/01/2022 BACKGROUND CHECKS 010-40.4200.460500 59.75 BACKGROUND INVESTIGATIO WA0005050122-1 05/O1/2022 BACKGROUND CHECKS 010-40.4200.460510 23.90 WD DESIGNS WAUKEE STAFF SPRING 2 04/26/2022 PARKS & REC STAFF SHIRTS 010-40.4200.120000 514.70 Department 4200 - RECREATION Total: 9,077.74 Department: 4210-TRIUMPH PARK PEAK SOFTWARE SYSTEMS 1 024483 04/29/2022 TRIUMPH PARK SPORTSMAN 010-40.4210.280000 902.10 MCFARLAND CLINIC PC 3439609 04/12/2022 PRE -EMPLOYMENT DRUG SC 010-40.4210.470000 48.00 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount CITY OF WAUKEE APR 22 WINERY BLDG 04/30/2022 APRIL 2022 STATEMENT 010-40,4210.480000 191.18 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 010-40.4210.100000 27.24 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 010-40.4210.100000 8.99 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-40.4210.100000 601.32 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-40.4210.100000 1,803.96 Department 4210 - TRIUMPH PARK Total: 3,582.79 Department: 4300 - COMMUNITY CENTER ORKIN PEST CONTROL 226284520 04/27/2022 PEST CONTROL- COMMUNIT 010-40.4300.400000 65.00 MENARDS 28691 04/19/2022 LIGHT 010-40.4300.400000 15.98 SHERWIN WILLIAMS CO 7094-9 01/25/2022 PAINT 010-40.4300.400000 71.22 NATIONWIDE OFFICE CLEAN 9472 04/30/2022 CLEANING SERVICES- COMM 010-40.4300.400100 298.77 CITY OF WAUKEE APR 22 COMM CENTER 04/30/2022 APRIL 2022 STATEMENT 010-40.4300.480000 216.53 MID AMERICAN ENERGY APR226510SUMBILL 04/26/2022 APRIL 2022 STATEMENT 010-40.4300.480000 79.71 KING'S MATERIAL INC KM17977255 04/18/2022 MULCH 010-40.4300.410300 182.74 KING'S MATERIAL INC KM17977261 04/18/2022 MULCH 010-40.4300.410300 91.38 Department 4300 - COMMUNITY CENTER Total: 1,021.33 Department: 4310 - VINEYARD PROPERTY HILLYARD INC 604716867 04/25/2022 PAPER TOWELS 010-40.4310.590000 69.72 KING'S MATERIAL INC KM17977530 04/19/2022 MULCH 010-40.4310.410300 143.91 KING'S MATERIAL INC KM17977538 04/19/2022 MULCH 010-40.4310.410300 23.98 Department 4310 - VINEYARD PROPERTY Total: 237.61 Department: 5300 - STORM WATER AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 560-80.5300.100000 47.84 AMERITAS LIFE INSURANCE C INV0013442 05/01/2022 MAY'22 VISION INSURANCE 560-80.5300.100000 5.34 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 560-80.5300.100000 3,514.62 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 560-80.5300.100000 354.43 Department 5300 - STORM WATER Total: 3,922.23 Department: 5400 - SOLID WASTE COLLECTION & DISPOSAL ANKENY SANITATION INC. 1217491 05/O1/2022 MAY 2022 STATEMENT 590-30.5400.231300 138,413.08 Department 5400 - SOLID WASTE COLLECTION & DISPOSAL Total: 138,413.08 Department: 5750 - LITTLE WALNUT CREEK FOTH INFRASTRUCTURE & E 77298 03/31/2022 NW 6TH ST CULVERT 327-90.5750.881430 1,667.24 Department 5750 - LITTLE WALNUT CREEK Total: 1,667.24 Department: 6000 - PUBLIC WORKS KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-20.6000.270100 17.61 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-20.6000.270100 35.22 CONSOLIDATED COMMUNIC INV0013437 04/22/2022 APRIL 2022 STATEMENT- PUB 010-20.6000.450000 1,093.71 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 010-20.6000.100000 122.92 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-20.6000.100000 8,926.50 Department 6000 - PUBLIC WORKS Total: 10,195.96 Department: 6010 - PUBLIC WORKS BUILDING SKOLD DOOR & FLOOR COM 214273-APR22-1 04/18/2022 PUBLIC WORKS OVERHEAD D 010-20.6010.400000 801.00 SKOLD DOOR & FLOOR COM 214273-APR22-2 04/26/2022 REPLACED SPRINGS 010-20.6010.400000 807.10 OFFICE DEPOT 239916333001 04/22/2022 CHAIRMAT/PAPER 010-20.6010.580000 57.74 OFFICE DEPOT 239916333001 04/22/2022 CHAIRMAT/PAPER 010-20.6010.590000 32.44 OFFICE DEPOT 239919235001 04/22/2022 LEGAL PAD 010-20.6010.580000 33.99 MMC CONTRACTORS IOWA, 35475-35476 04/19/2022 RADIANT HEAT REPLACEMEN 010-20.6010.400000 90,557.00 AMERICAN ALARMS 59712 04/13/2022 AFFILIATED TT FIRE & NAPCO 010-20.6010.400000 540.00 HILLYARD INC 604715419 04/22/2022 PAPER TOWELS 010-20.6010.590000 158.88 FIRST CHOICE COFFEE SERVI 607437 04/27/2022 COFFEE 010-20.6010.590000 126.50 NATIONWIDE OFFICE CLEAN 8709 04/15/2022 CLEANING SERVICES- PUBLIC 010-20.6010.400100 1,506.84 CITY OF WAUKEE APR 22 PUBLIC WORKS 04/30/2022 APRIL 2022 STATEMENT 010-20.6010.480000 4,393.95 FASTENAL COMPANY IAGRM128772 03/31/2022 SAFETY GEAR 010-20.6010.590000 266.09 CITY OF WAUKEE INV0013451 05/02/2022 HYD 1 HYDRANT METER FIN 010-20.6010.480000 1,857.01 FASTENAL COMPANY MN019646581 04/21/2022 FAST PROGRAM FEE 010-20.6010.590000 300.00 DIRECTV X220421 04/21/2022 APRIL 2022 STATEMENT- PUB 010-20.6010.480000 115.24 Department 6010 - PUBLIC WORKS BUILDING Total: 101,553.78 S/11/2022 8:37:44 AM Page 5 of 16 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 61SO - PUBLIC WORKS MECHANIC AMAZON.COM 17V7-KMGW-HCLK 04/29/2022 TAIL LIGHT 010-20.6150.570130 14.95 AMAZON.COM 1RWD-KT9N-M4J4 04/25/2022 OIL DRAIN VALVE/USB TO SE 010-20.6150.570130 118.85 AMAZON.COM 1RWD-KT9N-M4J4 04/25/2022 OIL DRAIN VALVE/USB TO SE 010-20.6150.590000 25.17 GRAHAM TIRE OF DES MOIN 220009410 05/04/2022 TIRES 010-20.6150.570130 591.56 ADEL AUTO PARTS 443895 04/27/2022 OIL 010-20.6150.570100 32.45 ADEL AUTO PARTS 443898 04/27/2022 OIL 010-20.6150.570100 76.14 ADEL AUTO PARTS 443972 04/28/2022 OIL FILTER 010-20.6150.570110 19.14 STIVERS FORD 5024164 04/25/2022 MIRROR ASY 010-20.6150.570130 836.61 STIVERS FORD 5024204 04/26/2022 COIL ASY- IGNITION 010-20.6150.570130 415.84 STIVERS FORD 5024234 04/27/2022 COIL ASY- IGNITION CREDIT 010-20.6150.570130 -461.16 STIVERS FORD 5024235 04/27/2022 BRAKE LINING/ROTOR ASY 010-20.6150.570130 365.79 MATHESON TRI-GAS INC 51951342 04/30/2022 CYLINDERS 010-20.6150.590000 145.35 BAX SALES INC 68259 04/20/2022 WASHERS/DRILL BITS/JACK P 010-20.6150.570130 38.87 BAX SALES INC 68259 04/20/2022 WASHERS/DRILL BITS/JACK P 010-20.6150.590000 35.35 BAX SALES INC 68305 04/22/2022 DRILL BITS 010-20.6150.590000 39.26 BAX SALES INC 68326 04/25/2022 NUTS/BOLTS/WASHERS 010-20.6150.570130 265.25 BAX SALES INC 68403 04/27/2022 HAIR PIN COTTERS 010-20.6150.570130 15.90 CERTIFIED LABRATORIES 7746260 04/06/2022 DIESEL EXHAUST FLUID 010-20.6150.570130 389.45 CERTIFIED LABRATORIES 7746779 04/07/2022 HYDRAULIC OIL 010-20.6150.570100 137.46 CERTIFIED LABRATORIES 7762930 04/29/2022 CHERRY BLITZ WIPES 010-20.6150.590000 144.31 MARK STUCHEL INC. CEP2745777O 04/28/2022 6 PC BORE BRUSH SET 010-20.6150.590000 15.00 PEAK DISTRIBUTING CG16677 04/22/2022 TUFFSTUFF PLUGS/RED THU 010-20.6150.570130 116.55 PEAK DISTRIBUTING CG16677 04/22/2022 TUFFSTUFF PLUGS/RED THU 010-20.6150.590000 219.66 STATE STEEL OF DES MOINES DM515032 04/18/2022 HOT ROLLED ROUND 010-20.6150.570130 19.74 MIDWEST UNDERGROUND S ID34189 04/20/2022 BOLTS/NUTS/WASHERS 010-20.6150.570130 787.12 MIDWEST UNDERGROUND S ID34245 04/27/2022 BOLTS/NUTS/WASHERS CRE 010-20.6150.570130 -92.14 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 010-20.6150.100000 47.84 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-20.6150.100000 3,514.62 MACQUEEN EQUIPMENT P16074 05/06/2022 QUICK CONNECT 010-20.6150.570130 48.22 Department 6150 - PUBLIC WORKS MECHANIC Total: 7,923.15 Department: 6510 - WATER UTILITY FAREWAY STORES, INC. 00103426 05/06/2022 TEAM BUILDING LUNCH 510-30.6510.470000 11.78 MUNICIPAL SUPPLY INC. 0830033-IN 04/11/2022 CURB BOX KEY/ADJUSTABLE 510-30.6510.590000 257.00 MUNICIPAL SUPPLY INC. 0831250-IN 04/20/2022 METERS 510-30.6510.592000 34,444.00 IOWA CHAPTER APWA 10763689 03/10/2022 2022 APWA SPRING CONFER 510-30.6510.470000 250.00 LEGACY MATERIALS LLC 1298 04/15/2022 FILLSAND 510-30.6510.410400 74.97 IOWA ONE CALL 239998 04/27/2022 MARCH 2O22 STATEMENT 510-30.6510.340000 501.15 PLUMB SUPPLY COMPANY 8019771 04/13/2022 THREAD SEAL TAPE 510-30.6510.590000 51.60 PLUMB SUPPLY COMPANY 8043924 04/26/2022 PVC THREADED CAP 510-30.6510.590000 5.30 AHLERS & COONEY PC 822476 04/25/2022 LITTLE WALNUT CREEK N TR 510-30.6510.880904 475.00 USA BLUE BOOK 941958 04/11/2022 MAGNETOMATIC PIPE LOCAT 510-30.6510.590000 129.48 CITY OF WAUKEE APR 22 SALES 04/30/2022 APRIL 2022 STATEMENT 510-30.6510.480000 449.82 MID AMERICAN ENERGY APR226510SUMBILL 04/26/2022 APRIL 2022 STATEMENT 510-30.6510.480000 175.47 DES MOINES WATER WORKS INV0013438 04/22/2022 APRIL 2022 STATEMENT 510-30.6510.650000 15,091.40 DES MOINES WATER WORKS INV0013439 04/22/2022 APRIL 2022 STATEMENT 510-30.6510.650000 26,593.35 DES MOINES WATER WORKS INV0013440 04/22/2022 APRIL 2022 STATEMENT 510-30.6510.650000 105,394.70 VEENSTRA & KIMM INC INV0013441 04/25/2022 2020 WATER MODEL UPDAT 510-30.6510.230000 404.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 LITTLE WALNUT CREEK N TR 510-30.6510.880904 1,421.07 VEENSTRA & KIMM INC INV0013441 04/25/2022 LITTLE WALNUT CREEK N TR 510-30.6510.880904 25.25 VEENSTRA & KIMM INC INV0013441 04/25/2022 LITTLE WALNUT CREEK N TR 510-30.6510.880904 64.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 3RD ST ELEVATED STORAGE T 510-30.6510.881100 330.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 ASR WELL REHAB 510-30.6510.882421 1,870.00 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 510-30.6510.100000 20.60 AMERITAS LIFE INSURANCE C INV0013442 05/01/2022 MAY'22 VISION INSURANCE 510-30.6510.100000 68.82 AMERITAS LIFE INSURANCE C INV0013442 OS/O1/2022 MAY'22 VISION INSURANCE 510-30.6510.100000 5.34 XENIA RURAL WATER DISTR INV0013458 O5/05/2022 MAY 2022 STATEMENT 510-30.6510.650000 69.11 XENIA RURAL WATER DISTR INV0013459 05/05/2022 MAY 2022 STATEMENT 510-30.6510.650000 69.11 XENIA RURAL WATER DISTR INV0013460 05/05/2022 MAY 2022 STATEMENT 510-30.6510.650000 69.11 XENIA RURAL WATER DISTR INV0013461 05/05/2022 MAY 2022 STATEMENT 510-30.6510.650000 82.89 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount WAUKEE HARDWARE & VARI INV0013462 04/30/2022 APRIL 2022 STATEMENT- PUB 510-30.6510.590000 54.64 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 510-30.6510.100000 354.43 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 510-30.6510.100000 1,710.66 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 510-30.6510.100000 5,078.81 CORE & MAIN LP Q705638 04/22/2022 HOSE NOZZLE/0-RING 510-30.6510.410500 644.31 MACQUEEN EQUIPMENT W03314 05/03/2022 EQUIPMENT REPAIR 510-30.6510.410100 864.27 Department 6510 - WATER UTILITY Total: 197,111.44 Department: 6520 - SANITARY SEWERS & TREATMENT FAREWAY STORES, INC. 00103426 05/06/2022 TEAM BUILDING LUNCH 520-30.6520.470000 11.79 ELECTRIC PUMP & TOOL INC 0895996-IN 04/22/2022 LIFT STATION NO. 2 520-30.6520.411100 367.94 JCG LAND SERVICES INC 6005.2 01/31/2022 NE OUTFALL SEWER 520-30.6520.883000 1,107.94 JCG LAND SERVICES INC 6005.3 02/28/2022 NE OUTFALL SEWER 520-30.6520.883000 3,809.63 JCG LAND SERVICES INC 6005.4 03/31/2022 NE OUTFALL SEWER 520-30.6520.883000 919.88 RJ LAWN SERVICE INC 66661 04/22/2022 FERTILIZER 520-30.6520.410300 65.00 AHLERS & COONEY PC 822475 04/25/2022 LIFT STATION NO. 2 REHAB 520-30.6520.880000 1,900.00 AHLERS & COONEY PC 822476 04/25/2022 LITTLE WALNUT CREEK N TR 520-30.6520.883060 1,425.00 CITY OF WAUKEE APR 22 LIFT STATIONS 04/30/2022 APRIL 2022 STATEMENT 520-30.6520.480000 138.80 MID AMERICAN ENERGY APR226520SUMBILL 04/26/2022 APRIL 2022 STATEMENT 520-30.6520.480000 1,947.92 VEENSTRA & KIMM INC INV0013441 04/25/2022 LIFT STATION NO. 2 REHAB 520-30.6520.880000 23,243.17 VEENSTRA & KIMM INC INV0013441 04/25/2022 NE OUTFALL SEWER 520-30.6520.883000 7,160.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 LITTLE WALNUT CREEK N TR 520-30.6520.883060 192.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 LITTLE WALNUT CREEK N TR 520-30.6520.883060 4,263.23 VEENSTRA & KIMM INC INVO013441 04/25/2022 LITTLE WALNUT CREEK N TR 520-30.6520.883060 75.75 VEENSTRA & KIMM INC INV0013441 04/25/2022 WESTTRUNK SEWER EXT PH 520-30.6520.883095 22,203.06 AMERITAS LIFE INSURANCE C INVOO13442 05/O1/2022 MAY'22 VISION INSURANCE 520-30.6520.100000 68.82 AMERITAS LIFE INSURANCE C INV0013442 05/01/2022 MAY'22 VISION INSURANCE 520-30.6520.100000 5.34 WAUKEE HARDWARE & VARI INV0013462 04/30/2022 APRIL 2022 STATEMENT- PUB 520-30.6520.590000 90.82 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 520-30.6520.100000 354.43 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 520-30.6520.100000 5,078.81 MACQUEEN EQUIPMENT W03314 05/03/2022 EQUIPMENT REPAIR 520-30.6520.410100 864.27 Department 6520 - SANITARY SEWERS & TREATMENT Total: 75,293.60 Department: 6540 - GAS UTILITY FAREWAY STORES, INC. 00103426 05/06/2022 TEAM BUILDING LUNCH 540-30.6540.470000 11.79 INDUSTRIAL SALES COMPAN 1115478-001 04/11/2022 METERS 540-30.6540.592000 1,100.00 INDUSTRIAL SALES COMPAN 1116943-000 04/18/2022 RISERS/CONNECTORS/TAP TE 540-30.6540.590100 12,038.84 CLAYTON ENERGY CORPORA 15113 05/02/2022 APRIL 2022 RESERVATION 540-30.6540.650000 43,574.54 GAS PRODUCTS SALES 22104-135 04/27/2022 SPRINGS 540-30.6540.590000 253.15 IOWA ONE CALL 239998 04/27/2022 MARCH 2O22 STATEMENT 540-30.6540.340000 501.15 INFRASOURCE CONSTRUCTI 3081908 04/20/2022 GREENWAY PL/PRAIRIE ROSE 540-30.6540.880100 17,966.26 INFRASOURCE CONSTRUCTI 3082082 04/27/2022 PAINTED WOODS/PRAIRIE R 540-30.6540.880100 7,236.68 MATHESON TRI-GAS INC 51951342 04/30/2022 CYLINDERS 540-30.6540.590000 24.30 FOTH INFRASTRUCTURE & E 76545 01/31/2022 10" GAS MAIN PROJECT 540-30.6540.880100 705.00 PLUMB SUPPLY COMPANY 8021310 04/14/2022 COUPLINGS 540-30.6540.590000 151.01 MID AMERICAN ENERGY APR226540SUMBILL 04/26/2022 APRIL 2022 STATEMENT 540-30.6540.480000 138.47 FASTENAL COMPANY IAGRM129663 04/20/2022 3M SUPER 88 3/4X66X7 540-30.6540.590000 359.78 UTILITY SAFETY AND DESIGN IN20221490 04/18/2022 LEAK SURVEY 540-30.6540.230000 1,400.00 UTILITY SAFETY AND DESIGN IN20221534 04/18/2022 PRAIRIE VILLAGE PLAT 3 540-30.6540.230000 600.00 UTILITY SAFETY AND DESIGN IN20221660 04/26/2022 RETAINER FEES 540-30.6540.230000 2,275.00 AMERITAS LIFE INSURANCE C INV0013442 05/01/2022 MAY'22 VISION INSURANCE 540-30.6540.100000 108.96 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 540-30.6540.100000 5.34 WAUKEE HARDWARE & VARI INV0013462 04/30/2022 APRIL 2022 STATEMENT- PUB 540-30.6540.590000 7.98 DAN DAVIS INV0013463 04/15/2022 FURNACE REBATE 540-30.6540.685400 75.00 KRISTIN & MATT SALGE INV0013464 05/02/2022 FURNACE REBATE 540-30.6540.685400 75.00 GREGORY HELTON INV0013466 04/18/2022 WATER HEATER REBATE 540-30.6540.685400 50.00 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 540-30.6540.100000 354.43 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 540-30.6540.100000 7,215.84 STUART C IRBY CO 5012946607.001 04/07/2022 RISERS 540-30.6540.590200 1,550.23 Department 6540 - GAS UTILITY Total: 97,778.75 5/ 11/2022 8:37:44 AM -- - - - - -- _ - Page 7 of 16 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 6550 - UTILITY BILLING UNIVERSAL PRINTING SERVI 74118 04/25/2022 STATEMENT INSERTS 570-30.6550.350100 884.01 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 570-30.6550.100000 31.28 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 570-30.6550.100000 2,419.52 Department 6550 - UTILITY BILLING Total: 3,334.81 Department: 7100 - STREETS FAREWAY STORES, INC. 00103426 05/06/2022 TEAM BUILDING LUNCH 060-30.7100.470000 11.78 IOWA PRISON INDUSTRIES 032039 04/20/2022 STREET SIGNS 060-30.7100.590600 4,291.20 US CELLULAR 0502134280 04/10/2022 APRIL 2022 STATEMENT 060-30.7100.450000 633.77 MCCLURE ENGINEERING CO 139022 04/27/2022 STREET RESURFACING 060-30.7100.590420 360.00 LIBERTY READY MIX 186301 04/11/2022 CONCRETE 060-30.7100.590400 604.00 CALHOUN-BURNS AND ASSO 2021247.00-2 04/16/2022 2022 BRIDGE RATING & INSP 060-30.7100.230000 1,151.60 CALHOUN-BURNS AND ASSO 2022164.00-1 04/16/2022 N WARRIOR LN BRIDGE 060-30.7100.230000 4,189.80 ARDICK EQUIPMENT CO., IN 2334 04/23/2022 NO TRESPASSING SIGNS 060-30.7100.590600 583.25 MARTIN MARIETTA AGGREG 35075269 04/07/2022 ROAD STONE 060-30.7100.590300 398.83 MARTIN MARIETTA AGGREG 35086413 04/08/2022 ROAD STONE 060-30.7100.590300 502.05 MARTIN MARIETTA AGGREG 35099405 04/11/2022 ROAD STONE 060-30.7100.590300 106.72 MARTIN MARIETTA AGGREG 35112890 04/12/2022 ROAD STONE 060-30.7100.590300 499.12 MARTIN MARIETTA AGGREG 35124930 04/13/2022 ROAD STONE 060-30.7100.590300 729.45 MARTIN MARIETTA AGGREG 35139341 04/14/2022 ROAD STONE 060-30.7100.590300 1,697.72 MARTIN MARIETTA AGGREG 35152675 04/18/2022 ROAD STONE 060-30.7100.590300 183.03 MARTIN MARIETTA AGGREG 35166304 04/19/2022 ROAD STONE 060-30.7100.590300 639.33 MARTIN MARIETTA AGGREG 35181311 04/20/2022 ROAD STONE 060-30.7100.590300 160.84 MARTIN MARIETTA AGGREG 35208918 04/22/2022 ROAD STONE 060-30.7100.590300 102.67 MARTIN MARIETTA AGGREG 35251652 04/27/2022 ROAD STONE 060-30.7100.590300 321.13 DETROIT INDUSTRIAL TOOL 590496 04/22/2022 DIAMOND BLADES 060-30.7100.590400 1,869.43 RJ LAWN SERVICE INC 65428 04/13/2022 FERTILIZER 060-30.7100.340000 3,354.00 RJ LAWN SERVICE INC 66594 04/20/2022 FOUNTAIN SERVICE 060-30.7100.340000 1,575.00 BAX SALES INC 68336 04/25/2022 3/4-10 X 5 1/2 HHCS GR8 ZY 060-30.7100.590000 84.82 FOTH INFRASTRUCTURE & E 76338 01/31/2022 NW MEREDITH DR OVERLAY 327-90.7100.880800 45,874.28 FOTH INFRASTRUCTURE & E 77223 03/31/2022 NW MEREDITH DR OVERLAY 327-90.7100.880800 5,846.50 AHLERS & COONEY PC 822474 04/25/2022 NW MEREDITH DR OVERLAY 327-90.7100.880800 1,900.00 LOGAN CONTRACTORS SUPP A52574 04/25/2022 PLEXI MELT/MIRROR LENS 060-30.7100.390000 8,405.84 LOGAN CONTRACTORS SUPP A52578 04/25/2022 DETACK SURFACE TACK 060-30.7100.590400 334.80 VEENSTRA & KIMM INC INV0013441 04/25/2022 2022 ASHWORTH RD PAVEM 060-30.7100.230000 3,163.00 AMERITAS LIFE INSURANCE C INV0013442 05/01/2022 MAY'22 VISION INSURANCE 060-30.7100.100000 99.04 AMERITAS LIFE INSURANCE C INV0013442 05/01/2022 MAY'22 VISION INSURANCE 060-30.7100.100000 54.48 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 060-30.7100.100000 13.62 WAUKEE HARDWARE & VARI INV0013462 04/30/2022 APRIL 2022 STATEMENT- PUB 060-30.7100.590000 99.63 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN '22 HEALTH INSURANCE 060-30.7100.100000 901.98 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN '22 HEALTH INSURANCE 060-30.7100.100000 3,607.92 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN '22 HEALTH INSURANCE 060-30.7100.100000 7,077.84 LOUNSBURY LANDSCAPING T6368 04/30/2022 TOPSOIL 060-30.7100.590000 412.00 Department 7100 - STREETS Total: 101,840.47 Department: 7150 - SIDEWALKS VEENSTRA & KIMM INC INV0013441 04/25/2022 2021 ADA SIDEWALK IMPRO 327-90.7150.235000 2,579.74 Department 7150 - SIDEWALKS Total: 2,579.74 Department: 7200 - NORTH HIGH SCHOOL ROAD SYSTEM TEAM SERVICES INC 181G062-0 03/31/2022 NW 2ND ST, NW VENTURE D 327-90.7200.235040 361.67 TEAM SERVICES INC 1810080-0 03/31/2022 NE DOUGLAS PKWY EXTENSI 327-90.7200.235030 850.96 INFRASOURCE CONSTRUCTI 3081908 04/20/2022 NW 2ND ST 327-90.7200.235040 8,337.88 INFRASOURCE CONSTRUCTI 3082082 04/27/2022 NW DOUGLAS PKWY 327-90.7200.235030 13,032.91 INFRASOURCE CONSTRUCTI 3082082 04/27/2022 NW 2ND ST 327-90.7200.235040 1,932.84 INFRASOURCE CONSTRUCTI 3082468 05/06/2022 NW DOUGLAS PKWY 327-90.7200.235030 24,291.30 FOTH INFRASTRUCTURE & E 76335 01/31/2022 NW 2ND ST, NW VENTURE D 327-90.7200.235040 2,092.52 FOTH INFRASTRUCTURE & E 76336 01/31/2022 NW 4TH ST, NW SUNRISE DR 327-90.7200.230000 13,980.00 FOTH INFRASTRUCTURE & E 76337 01/31/2022 NW DOUGLAS PKWY, NW 10 327-90.7200.235030 1,040.00 FOTH INFRASTRUCTURE & E 76344 01/31/2022 NW 30TH ST 327-90.7200.235020 1,640.60 FOTH INFRASTRUCTURE & E 77220 03/31/2022 NW 2ND ST, NW VENTURE D 327-90.7200.235040 3,543.22 5/11/2022 8:37:44 AM Page 8 of 16 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount FOTH INFRASTRUCTURE & E 77221 03/31/2022 NW DOUGLAS PKWY, NW 10 327-90.7200.235030 5,467.96 FOTH INFRASTRUCTURE & E 77222 03/31/2022 NW 4TH ST, NW SUNRISE DR 327-90.7200.230000 14,893.93 FOTH INFRASTRUCTURE & E 77334 03/31/2022 NW LOTH ST BASE BID 327-90.7200.235020 1,261.00 Department 7200 - NORTH HIGH SCHOOL ROAD SYSTEM Total: 92,726.79 Department: 7740 - DOUGLAS PARKWAY BOLTON & MENK, INC 0287783 04/22/2022 DOUGLAS PKWY EXTENSION 327-90.7740.230000 3,062.00 CALHOUN-BURNS AND ASSO 2020237.00-19 04/16/2022 DOUGLAS PKWY EXTENSION 327-90.7740.230000 971.20 Department 7740 - DOUGLAS PARKWAY Total: 4,033.20 Department: 7770 - R22 / LITE AVENUEIMPROVEMENTS JERICO SERVICES INC 0084098-IN 04/29/2022 UTE/ASHWORTH INTERSECTI 327-90.7770.230000 4,000.00 TEAM SERVICES INC 1810088-0 03/31/2022 LITE AVE & ASHWORTH RD 327-90.7770.230000 1,237.81 Department 7770 - R22 / LITE AVENUEIMPROVEMENTS Total: 5,237.81 Department: 7850 - TIF DEBT SERVICE AHLERS & COONEY PC 822052 04/27/2022 ACCESS SYSTEMS 093-30.7850.230000 554.00 Department 7850 - TIF DEBT SERVICE Total: 554.00 Department: 8200 - COMMUNICATIONS BUSINESS PUBLICATIONS 72167 04/27/2022 ADVERTISING 010-60.8200.210000 755.00 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-60.8200.100000 -1,803.96 Department 8200 - COMMUNICATIONS Total: -1,048.96 Department: 8300 - ADMINISTRATION PREMIERE GLOBAL SERVICES 887168 03/31/2022 MARCH 2O22 STATEMENT 010-60.8300.450000 5.91 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-60.8300.270110 35.22 CITY OF WAUKEE APR 22 RENTAL 04/30/2022 APRIL 2022 STATEMENT 010-60.8300.390400 196.29 SHI INTERNATIONAL CORP B15070538 04/14/2022 TP UNIVERSAL USB-C DOCK 030-60.8300.540000 185.11 AMERITAS LIFE INSURANCE C INV0013442 05/01/2022 MAY'22 VISION INSURANCE 010-60.8300.100000 75.08 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-60.8300.100000 5,318.58 Department 8300 - ADMINISTRATION Total: 5,816.19 Department: 8310 - CITY HALL CRYSTAL CLEAR BOTTLED WA 375872 04/22/2022 WATER 010-60.8310.590000 53.70 CINTAS CORPORATION 5107381019 05/09/2022 FIRST AID KIT SUPPLIES 010-60.8310,590000 166.93 CITY OF WAUKEE APR 22 CAM 04/30/2022 APRIL 2022 STATEMENT 010-60.8310.390600 228.27 CITY OF WAUKEE APR 22 CITY HALL 1 04/30/2022 APRIL 2022 STATEMENT 010-60.8310.480000 278.09 CITY OF WAUKEE APR 22 CITY HALL 2 04/30/2022 APRIL 2022 STATEMENT 010-60.8310.480000 54.14 CITY OF WAUKEE APR 22 CITY HALL 3 04/30/2022 APRIL 2022 STATEMENT 010-60.8310.480000 21.90 CITY OF WAUKEE APR 22 DEV SERV 04/30/2022 APRIL 2022 STATEMENT 010-60.8310.480000 154.58 MID AMERICAN ENERGY APR228310SUMBILL 04/26/2022 APRIL 2022 STATEMENT 010-60.8310.480000 726.23 SPLAW PROPERTIES, LLC INV0013436 05/17/2022 MAY 2022 ANNEX LEASE 010-60.8310.290000 107.50 SPLAW PROPERTIES, LLC INV0013436 05/17/2022 MAY 2022 ANNEX LEASE 010-60.8310.390100 4,397.33 Department 8310 - CITY HALL Total: 6,188.67 Department: 8350 - HUMAN RESOURCES KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-60.8350.270110 48.35 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 010-60.8350.100000 54.48 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-60.8350.100000 3,607.92 [SOLVED BENEFIT SERVICES, I W19654 04/30/2022 APR'22 PEPM FEES FOR DEP 010-60.8350.230000 533.25 Department 8350 - HUMAN RESOURCES Total: 4,244.00 Department: 8400 - FINANCIAL ADMINISTRATION KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-60.8400.270110 15.54 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-60.8400.270110 15.55 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-60.8400.270110 63.60 AMERITAS LIFE INSURANCE C INV0013442 05/01/2022 MAY'22 VISION INSURANCE 010-60.8400.100000 48.60 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-60.8400.100000 4,085.48 Department 8400 - FINANCIAL ADMINISTRATION Total: 4,229.77 Department: 8500 - ECONOMIC DEVELOPMENT STAPLES BUSINESS CREDIT 7354237489-0-1 04/08/2022 COFFEE/PAPER/STAPLE REM 010-50.8500.580000 30.99 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 010-50.8500.100000 27.24 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-50.8500.100000 1,803.96 Department 8500 - ECONOMIC DEVELOPMENT Total: 1,862.19 5/11/2022 8:37:44 AM Page 9 of 16 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 8600 - CITY ATTORNEY BRICK GENTRY BOWERS SWA 375506 04/25/2022 APRIL 2022 STATEMENT 010-60.8600.230000 36,937.50 Department 8600 - CITY ATTORNEY Total: 36,937.50 Department: 8700 - DEVELOPMENT SERVICES WINDSTAR LINES 114262 05/01/2022 WASP SENIOR TOUR 010-50.8700.470000 756.00 STAPLES BUSINESS CREDIT 7352870418-1-1 03/31/2022 BATTERIES CREDIT 010-50.8700.590000 -1.38 STAPLES BUSINESS CREDIT 7354237489-0-1 04/08/2022 COFFEE/PAPER/STAPLE REM 010-50.8700.580000 122.23 STAPLES BUSINESS CREDIT 7354237489-0-1 04/08/2022 COFFEE/PAPER/STAPLE REM 010-50.8700.590000 24.49 STAPLES BUSINESS CREDIT 7354237489-1-1 04/14/2022 STAPLE REMOVER CREDIT 010-50.8700.580000 -9.68 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-50.8700.270110 35.22 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 010-50.8700.100000 48.60 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-50.8700.100000 3,221.68 Department 8700 - DEVELOPMENT SERVICES Total: 4,197.16 Department: 8750 - SUGAR CREEK MUNICIPAL JUNGMANN CORPORATION 043022 04/30/2022 CRUSHED ASPHALT 750-80.8750.590200 142.87 D & K PRODUCTS INC. 0543553-IN 04/27/2022 FERTILIZER 750-80.8750.590100 532.00 ORKIN PEST CONTROL 226284495 04/27/2022 PEST CONTROL- GOLF COUR 750-80.8750.400000 87.24 CORELL CONTRACTOR INC 26951 04/15/2022 ASPHALT 750-80.8750.590200 232.67 CINTAS CORPORATION 4117336804 04/22/2022 PAPER TOWELS/HAND SOAP/ 750-80.8750.590000 284.91 PORTABLE PRO, INC 65761 04/27/2022 PORTABLE RESTROOMS 750-80.8750.480000 180.00 CHEMSEARCH 7748207 04/08/2022 LITHIPLEX SYNTHETIC BLEND 750-80.8750.570100 266.45 LAWSON PRODUCTS INC 9309473034 04/14/2022 PAINT 750-80.8750.410100 25.48 CALLAWAY GOLF 934704180 04/21/2022 GOLF BALLS 750-80.8750.651000 124.98 CALLAWAY GOLF 934735654 04/26/2022 GOLF BALLS 750-80.8750.651000 245.10 CITY OF WAUKEE APR 22 SUGAR CREEK PARK 04/30/2022 APRIL 2022 STATEMENT 750-80.8750.480000 34.34 CITY OF WAUKEE APR 22 SUGAR CREEK 04/30/2022 APRIL 2022 STATEMENT 750-80.8750.480000 325.44 MID AMERICAN ENERGY APR228750SUMBILL 04/26/2022 APRIL 2022 STATEMENT 750-80.8750.480000 224.25 AMERITAS LIFE INSURANCE C INV0013442 05/01/2022 MAY'22 VISION INSURANCE 750-80.8750.100000 27.24 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 750-80.8750.100000 9.26 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 750-80.8750.100000 601.32 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 750-80.8750.100000 1,803.96 P & W GOLF SUPPLY LLC INV92891 04/21/2022 CUSTOM BARRIER NET WITH 750-80.8750.410300 3,479.63 MILLER & SONS GOLF CARS, M24070 03/11/2022 IGNITION SWITCH 750-80.8750.590000 82.38 MILLER & SONS GOLF CARS, M24144 03/19/2022 FRONT STRUT PAINTED 750-80.8750.410360 129.26 WD DESIGNS WAUKEE SUGAR CREEK 05/03/2022 SUGAR CREEK PARK SHIRTS 750-80.8750.120000 4,142.50 Department 8750 - SUGAR CREEK MUNICIPAL Total: 12,981.28 Department: 8800 - INFORMATION TECHNOLOGY INSIGHT PUBLIC SECTOR, INC 1100936068 04/26/2022 MICROSOFT 365 LICENSING 010-60.8800.270000 56,345.17 AMAZON.COM 11JC-6TYY-74XM 04/24/2022 PHONE HOLSTER BELT-CLIP/C 010-60.8800.590000 47.64 AMAZON.COM iN1K-YYL7-9NHT 04/26/2022 LENOVO AC ADAPTERS/KEYB 010-60.8800.540000 327.87 AMAZON.COM 1W9F-HFFL-KWTJ 04/22/2022 REPLACEMENT LAPTOP SCRE 010-60.8800.590000 74.20 SHI INTERNATIONAL CORP B15070538 04/14/2022 TP UNIVERSAL USB-C DOCK 010-60.8800.540000 370.22 SHI INTERNATIONAL CORP B15075276 04/15/2022 LAPTOP PRIVACY SCREENS 010-60.8800.590000 77.80 SHI INTERNATIONAL CORP B15122902 04/25/2022 MAIL ARCHIVE MAINTENAN 010-60.8800.270100 2,460.00 SHI INTERNATIONAL CORP B15125143 04/25/2022 MONITORS 010-60.8800.540000 2,174.40 SHI INTERNATIONAL CORP B15149274 04/28/2022 STORAGE SERVER MAINTEN 010-60.8800.270100 3,389.00 SHI INTERNATIONAL CORP B15149327 04/28/2022 BROKEN LAPTOP REPLACEM 010-60.8800.540000 1,747.60 AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 010-60.8800.100000 55.24 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-60.8800.100000 4,887.64 ONE SOURCE PLUS4380-20220430 04/30/2022 PRE -EMPLOYMENT BACKGR 010-60.8800.470000 45.00 Department 8800 - INFORMATION TECHNOLOGY Total: 72,001.78 Department: 8900 - ENGINEERING MCFARLAND CLINIC PC 3439609 04/12/2022 PRE -EMPLOYMENT DRUG SC 010-20.8900.470000 48.00 FOTH INFRASTRUCTURE & E 76544 01/31/2022 KETTLESTONE MASTER PLAN 010-20.8900.230000 11,389.00 KONICA MINOLTA BUSINESS 9008570020 04/30/2022 APRIL 2022 COPIER/PRINTER 010-20.8900.270110 35.22 VEENSTRA & KIMM INC INV0013441 04/25/2022 RJ LAWN & LANDSCAPE EXPA 010-20.8900.231200 67.45 VEENSTRA & KIMM INC INV0013441 04/25/2022 NEW CREATIONS PRELIMINA 010-20.8900.231200 192.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 DUPACO CREDIT UNION SITE 010-20.8900.231200 355.50 VEENSTRA & KIMM INC INV0013441 04/25/2022 ACCESS SYSTEMS PRELIMINA 010-20.8900.231200 512.00 5/11/2022 8:37:44 AM Page 10 of 16 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Vendor Name Payable Number Post Date Description (Item) Account Number Amount VEENSTRA & KIMM INC INV0013441 04/25/2022 FOX CREEK MEADOWS PRELI 010-20.8900.231200 64.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 STONE PRAIRIE PLAT 7, LOT 3 010-20.8900.231200 128.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 COURTYARDS AT PARKSIDE P 010-20.8900.231200 1,857.24 VEENSTRA & KIMM INC INV0013441 04/25/2022 ALDER POINT PRELIMINARY 010-20.8900.231200 64.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 STRATFORD CROSSING PLAT 010-20.8900.231200 654.50 VEENSTRA & KIMM INC INV0013441 04/25/2022 STRATFORD CROSSING PLAT 010-20.8900.231200 596.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 PAINTED WOODS WEST PHA 010-20.8900.231200 936.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 WAUKEE CROSSING PLAT 3 C 010-20.8900.231200 155.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 MAPLE GROVE PLACE SITE PIL 010-20.8900.231200 1,671.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 EDENCREST AT KETTLESTONE 010-20.8900.231200 204.29 VEENSTRA & KIMM INC INV0013441 04/25/2022 COFFEE BEAN ADDITION PLA 010-20.8900.231200 155.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 ASHELY ACRES PLAT 3 PRELI 010-20.8900.231200 64.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 CONVERGE NW CONSTRUCTI 010-20.8900.231200 128.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 PROJECT MORGAN SITE LOGI 010-20.8900.231200 64.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 SPRING CREST TOWNHOMES 010-20.8900.231200 256.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 PRAIRIE VILLAGE PLAT 3 CON 010-20.8900.231200 192.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 MORGAN PLAT 2 (APPLE) SIT 010-20.8900.231200 64.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 HAMILTON RIDGE PLAT 9 CO 010-20.8900.231200 128.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 INDI RUN PLAT 4 PRELIMINA 010-20.8900.231200 64.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 HY-VEE EXPANSION PRELIM] 010-20.8900.231200 256.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 PRAIRIE VILLAGE TOWNHOM 010-20.8900.231200 192.00 VEENSTRA & KIMM INC INV0013441 04/25/2022 KEETOWN LOOP SITE PLAN 010-20.8900.231200 256.00 AMERITAS LIFE INSURANCE C INV0013442 05/01/2022 MAY'22 VISION INSURANCE 010-20.8900.100000 103.08 WAUKEE HARDWARE & VARI INV0013462 04/30/2022 APRIL 2022 STATEMENT- PUB 010-20.8900.590000 144.98 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-20.8900.100000 6,829.60 Department 8900 - ENGINEERING Total: 27,825.86 Department: 8950 - GIS AMERITAS LIFE INSURANCE C INV0013442 05/O1/2022 MAY'22 VISION INSURANCE 010-20.8950.100000 10.68 EMPLOYEE BENEFIT SYSTEM INV0013498 05/10/2022 JUN'22 HEALTH INSURANCE 010-20.8950.100000 708.86 Department 8950 - GIS Total: 719.54 Grand Total: 1,303,060.88 �/11/2022 8:37:44 AM Page 11 of 16 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Fund Summary Fund O10-GENERAL FUND 060 - ROAD USE TAX FUND 093 - WAUKEE URBAN RENEWAL AREA 327 - CAPITAL PROJECTS 510- WATER UTILITY FUND 520 - WASTE WATER UTILITY FUND 540 - GAS UTILITY FUND 560 - STORM WATER UTILITY FUND 570 - UTILITY BILL FUND 590 - SOLID WASTE COLLECT & RCY 750 - GOLF COURSE FUND Account Number 010-10.1100.100000 010-10.1100.120000 010-10.1100.270110 010-10.1100.400000 010-10.1100.410000 010-10.1100.450000 010-10.1100.470000 010-10.1100.480000 010-10.1100.540000 010-10.1100.580000 010-10.1100.590000 010-10.1400.100000 010-10.1400.120000 010-10.1400.270000 010-10.1400.270110 010-10.1400.400000 010-10.1400.410100 010-10.1400.450000 010-10.1400.470000 010-10.1400.480000 010-10.1400.540000 010-10.1400.580000 010-10.1400.590000 010-10.1500.100000 010-10.1500.120000 010-10.1500.270000 010-10.1500.270100 010-10.1500.400000 010-10.1500.450000 010-10.1500.480000 010-10.1500.540000 010-10.1500.580000 010-10.1500.590000 010-10.1500.710310 010-10.1900.100000 010-10.1900.580000 010-20.6000.100000 010-20.6000.270100 010-20.6000.450000 010-20.6010.400000 010-20.6010.400100 010-20.6010.480000 010-20.6010.580000 010-20.6010.590000 Grand Total: Account Summary Account Name HEALTH & LIFE INSURAN UNIFORMS COPIER / PRINTER LEASE REPAIR/MAINTENANCE REPAIR OF VEHICLES TELEPHONE TRAINING/TRAVEL EXPE UTILITY SERVICES MINOR EQUIPMENT OFFICE SUPPLIES OPERATING SUPPLIES & HEALTH & LIFE INSURAN UNIFORMS DATA PROCESSING COPIER / PRINTER LEASE REPAIR/MAINTENANCE REPAIR/MAINTENANCE TELEPHONE TRAINING/TRAVEL EXPE UTILITY SERVICES MINOR EQUIPMENT OFFICE SUPPLIES OPERATING SUPPLIES & HEALTH & LIFE INSURAN UNIFORMS DATA PROCESSING COMPUTER SUPPORT REPAIR/MAINTENANCE TELEPHONE UTILITY SERVICES MINOR EQUIPMENT OFFICE SUPPLIES OPERATING SUPPLIES & AMBULANCE HEALTH & LIFE INSURAN OFFICE SUPPLIES HEALTH & LIFE INSURAN COMPUTER SUPPORT TELEPHONE REPAIR/MAINTENANCE CUSTODIAL SERVICES UTILITY SERVICES OFFICE SUPPLIES OPERATING SUPPLIES & Expense Amount 427,986.63 115,653.96 554.00 185,927.34 220,031.29 79,238.81 110,050.91 6,247.05 3,334.81 138,413.08 15,623.00 1,303,060.88 Expense Amount 44,655.18 579.88 66.31 474.66 642.21 126.50 125.50 785.03 4,945.04 302.05 100.66 9,582.66 78.43 40.71 17.61 91.37 10.45 27.83 600.00 638.98 1,478.97 4.53 50.93 16,853.24 278.06 144.34 17.61 91.37 98.67 401.64 53.49 4.53 201.65 411.86 10,347.22 31.74 9,049.42 52.83 1,093.71 92,705.10 1,506.84 6,366.20 91.73 883.91 5/11/2022 8:37:44 AM Page 12 of 16 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Account Summary Account Number Account Name Expense Amount 010-20.6150.100000 HEALTH & LIFE INSURAN 3,562.46 010-20.6150.570100 COGS - OIL 246.05 010-20.6150.570110 COGS -FILTERS 19.14 010-20.6150.570130 COGS - PARTS 3,471.40 010-20.6150.590000 OPERATING SUPPLIES & 624.10 010-20.8900.100000 HEALTH & LIFE INSURAN 6,932.68 010-20.8900.230000 CONSULTANT & PROFES 11,389.00 010-20.8900.231200 DEVELOPERS ENGINEERI 9,275.98 010-20.8900.270110 COPIER / PRINTER LEASE 35.22 010-20.8900.470000 TRAINING/TRAVEL EXPE 48.00 010-20.8900.590000 OPERATING SUPPLIES & 144.98 010-20.8950.100000 HEALTH & LIFE INSURAN 719.54 010-2030500 SALES TAX COLLECTED P 273.45 010-2035000 DEVELOPER DEPOSIT PAY 1,700.00 010-40.3100.100000 HEALTH & LIFE INSURAN 7,552.28 010-40.3100.270110 COPIER / PRINTER LEASE 70.44 010-40.3100.400000 REPAIR/MAINTENANCE 495.00 010-40.3100.460300 PROGRAMS 670.00 010-40.3100.460400 SUMMER READING CLU 926.01 010-40.3100.470000 TRAINING/TRAVEL EXPE 35.00 010-40.3100.480000 UTILITY SERVICES 385.27 010-40.3100.580000 OFFICE SUPPLIES 333.68 010-40.3100.590000 OPERATING SUPPLIES & 494.53 010-40.3100.640000 LIBRARY BOOKS/FILMS/ 3,147.83 010-40.4100.100000 HEALTH & LIFE INSURAN 4,796.19 010-40.4100.120000 UNIFORMS 849.28 010-40.4100.410100 REPAIR/MAINTENANCE 1,445.39 010-40.4100.410300 REPAIR/MAINTENANCE 4,170.99 010-40.4100.410310 REPAIR/MAINTENANCE- 934.86 010-40.4100.480000 UTILITY SERVICES 1,204.93 010-40.4100.480010 UTILITIES -DOG PARK 78.09 010-40.4100.480011 UTILITIES -FOX CRK SPLA 561.43 010-40.4100.480100 UTILITIES -PARK IRRIGATI 284.98 O10-40.4100.540000 MINOR EQUIPMENT 759.96 010-40.4100.590000 OPERATING SUPPLIES & 158.86 010-40.4100.590011 OPERATING SUPPLIES-F 75.30 010-40.4100.760000 OTHER CAPITAL EQUIPM 5,656.91 010-40.4200.100000 HEALTH & LIFE INSURAN 5,101.48 010-40.4200.120000 UNIFORMS 514.70 010-40.4200.270110 COPIER / PRINTER LEASE 17.61 010-40.4200.460500 SUMMER RECREATION P 1,986.15 010-40.4200.460510 YOUTH SPORTS LEAGUE 23.90 010-40.4200.460520 CONCESSION STAND 29.90 010-40.4200.460550 WINTER RECREATION PR 1,388.00 010-40.4200.590000 OPERATING SUPPLIES & 16.00 010-40.4210.100000 HEALTH & LIFE INSURAN 2,441.51 010-40.4210.280000 DUES, MEMBERSHIPS & 902.10 010-40.4210.470000 TRAINING/TRAVEL EXPE 48.00 010-40.4210.480000 UTILITY SERVICES 191.18 010-40.4300.400000 REPAIR/MAINTENANCE 152.20 010-40.4300.400100 CUSTODIAL SERVICES 298.77 010-40.4300.410300 REPAIR/MAINTENANCE 274.12 010-40.4300.480000 UTILITY SERVICES 296.24 010-40.4310.410300 REPAIR/MAINTENANCE 167.89 010-40.4310.590000 OPERATING SUPPLIES & 69.72 010-50.8500.100000 HEALTH & LIFE INSURAN 1,831.20 010-50.8500.580000 OFFICE SUPPLIES 30.99 010-50.8700.100000 HEALTH & LIFE INSURAN 3,270.28 5/11/2022 8:37:44 AM Page 13 of 16 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Account Summary Account Number Account Name Expense Amount 010-50.8700.270110 COPIER / PRINTER LEASE 35.22 010-50.8700.470000 TRAINING/TRAVEL EXPE 756.00 010-50.8700.580000 OFFICE SUPPLIES 112.55 010-50.8700.590000 OPERATING SUPPLIES & 23.11 010-60.8200.100000 HEALTH & LIFE INSURAN -1,803.96 010-60.8200.210000 PUBLIC NOTIFICATION/A 755.00 010-60.8300.100000 HEALTH & LIFE INSURAN 5,393.66 010-60.8300.270110 COPIER / PRINTER LEASE 35.22 010-60.8300.390400 RENTAL PROP EXPENSES 196.29 010-60.8300.450000 TELEPHONE 5.91 010-60.8300.540000 MINOR EQUIPMENT 185.11 010-60.8310.290000 CITY HALL ANNEX INSUR 107.50 010-60.8310.390100 CITY HALL ANNEX LEASE 4,397.33 010-60.8310.390600 PROF PLAZA CAM EXPEN 228.27 010-60.8310.480000 UTILITY SERVICES 1,234.94 010-60.8310.590000 OPERATING SUPPLIES & 220.63 010-60.8350.100000 HEALTH & LIFE INSURAN 3,662.40 010-60.8350.230000 CONSULTANT & PROFES 533.25 010-60.8350.270110 COPIER / PRINTER LEASE 48.35 010-60.8400.100000 HEALTH & LIFE INSURAN 4,134.08 010-60.8400.270110 COPIER / PRINTER LEASE 94.69 010-60.8600.230000 CONSULTANT & PROFES 36,937.50 010-60.8800.100000 HEALTH & LIFE INSURAN 4,942.88 010-60.8800.270000 DATA PROCESSING 56,345.17 010-60.8800.270100 COMPUTER SUPPORT 5,849.00 010-60.8800.470000 TRAINING/TRAVEL EXPE 45.00 010-60.8800.540000 MINOR EQUIPMENT 4,620.09 010-60.8800.590000 OPERATING SUPPLIES & 199.64 060-30.1600.480000 UTILITY SERVICES 19,186.66 060-30.1601.410300 REPAIR/MAINTENANCE F 46,740.00 060-30.1601.480000 UTILITY SERVICES 1,507.61 060-30.7100.100000 HEALTH & LIFE INSURAN 11,754.88 060-30.7100.230000 CONSULTANT & PROFES 8,504.40 060-30.7100.340000 MISCELLANEOUS CONTR 4,929.00 060-30.7100.390000 RENTAL/LEASE OF EQUIP 8,405.84 060-30.7100.450000 TELEPHONE 633.77 060-30.7100.470000 TRAINING/TRAVEL EXPE 11.78 060-30.7100.590000 OPERATING SUPPLIES & 596.45 060-30.7100.590300 ROAD STONE 5,340.89 060-30.7100.590400 ROAD REPAIR -PATCH 2,808.23 060-30.7100.590420 ROAD REPAIRS - ASPHAL 360.00 060-30.7100.590600 STREETSIGNS 4,874.45 093-30.7850.230000 CONSULTANT/PROFESSI 554.00 327-90.2132.230000 SE ASHWORTH CORRIDO 8,498.50 327-90.2150.980110 HS REC COMPLEX - CON 3,691.61 327-90.2160.230000 CONSULT- PW EXPANSI 11,471.67 327-90.4100.880089 SUGAR CREEK/DAYBREA 2,400.00 327-90.5750.881430 NW 6TH ST LITTLE WALN 1,667.24 327-90.7100.880800 MEREDITH DRIVE ASPHA 53,620.78 327-90.7150.235000 CONSTRUCTION-ADA TR 2,579.74 327-90.7200.230000 2ND HS RDS-N 4TH ST C 28,873.93 327-90.7200.235020 LOTH STREET IMPROVE 2,901.60 327-90.7200.235030 DOUGLAS PARKWAY - PH 44,683.13 327-90.7200.235040 NW 2ND STREET- PHAS 16,268.13 327-90.7740.230000 CONSULT - NE DOUGLAS 4,033.20 327-90.7770.230000 CONSULT - LITE & ASHW 5,237.81 510-2030500 SALES TAX COLLECTED P 22,919.85 510-30.6510.100000 HEALTH & LIFE INSURAN 7,238.66 5/11/2022 8:37:44 AM Page 14 of 16 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Account Summary Account Number Account Name Expense Amount 510-30.6510.230000 CONSULTANT & PROFES 404.00 510-30.6510.340000 MISCELLANEOUS CONTR 501.15 510-30.6510.410100 REPAIR/MAINTENANCE 864.27 510-30.6510.410400 REPAIR/MAINT OF DELIV 74.97 510-30.6510.410500 REPAIR/MAINTENANCE 644.31 510-30.6510.470000 TRAINING/TRAVEL EXPE 261.78 510-30.6510.480000 UTILITY SERVICES 625.29 510-30.6510.590000 OPERATING SUPPLIES & 498.02 510-30.6510.592000 METER PURCHASE 34,444.00 510-30.6510.650000 COST OF GOODS SOLD 147,369.67 510-30.6510.880904 LITTLE WALNUT CREEK 1,985.32 510-30.6510.881100 3RD STREET ELEVATED S 330.00 510-30.6510.882421 ASR FACILITY 1,870.00 520-2030500 SALES TAX COLLECTED P 3,945.21 520-30.6520.100000 HEALTH & LIFE INSURAN 5,507.40 520-30.6520.410100 REPAIR/MAINTENANCE 864.27 520-30.6520.410300 REPAIRS/MAINTENANCE 65.00 520-30.6520.411100 REPAIR/MAINTENANCE 367.94 520-30.6520.470000 TRAINING/TRAVEL EXPE 11.79 520-30.6520.480000 UTILITY SERVICES 2,086.72 520-30.6520.590000 OPERATING SUPPLIES & 90.82 520-30.6520.880000 FACILITIES 25,143.17 520-30.6520.883000 OUTFALLSEWER 12,997.45 520-30.6520.883060 LITTLE WALNUT CREEKS 5,955.98 520-30.6520.883095 WEST AREA TRUNK SEW 22,203.06 540-2030500 SALES TAX COLLECTED P 12,272.16 540-30.6540.100000 HEALTH & LIFE INSURAN 7,684.57 540-30.6540.230000 CONSULTANT & PROFES 4,275.00 540-30.6540.340000 MISCELLANEOUS CONTR 501.15 540-30.6540.470000 TRAINING/TRAVEL EXPE 11.79 540-30.6540.480000 UTILITY SERVICES 138.47 540-30.6540.590000 OPERATING SUPPLIES & 796.22 540-30.6540.590100 DEVELOPER MATERIALS 12,038.84 540-30.6540.590200 INSTALLATION MATERIA 1,550.23 540-30.6540.592000 METER PURCHASE 1,100.00 540-30.6540.650000 COST OF GOODS SOLD 43,574.54 540-30.6540.685400 GAS REBATE 200.00 540-30.6540.880100 DISTRIBUTION SYSTEM 1 25,907.94 560-2030500 SALES TAX COLLECTED P 2,324.82 560-80.5300.100000 HEALTH & LIFE INSURAN 3,922.23 570-30.6550.100000 HEALTH & LIFE INSURAN 2,450.80 570-30.6550.350100 PRINTING 884.01 590-30.5400.231300 RESIDENTIAL SOLID WAS 138,413.08 750-2030500 SALES TAX COLLECTED P 2,641.72 750-80.8750.100000 HEALTH & LIFE INSURAN 2,441.78 750-80.8750.120000 UNIFORMS 4,142.50 750-80.8750.400000 REPAIR/MAINTENANCE 87.24 750-80.8750.410100 REPAIR/MAINTENANCE 25.48 750-80.8750.410300 REPAIR/MAINTENANCE F 3,479.63 750-80.8750.410360 REPAIR/MAINTENANCE 129.26 750-80.8750.480000 UTILITY SERVICES 764.03 750-80.8750.570100 OIL/FILTERS/LUBE 266.45 750-80.8750.590000 OPERATING SUPPLIES & 367.29 750-80.8750.590100 CHEMICAL/FERTILIZER 532.00 750-80.8750.590200 SAND AND MILLINGS 375.54 750-80.8750.651000 PRO SHOP MERCHANDIS 370.08 Grand Total: 1,303,060.88 5/11/2022 8:37:44 AM Page 15 of 16 Expense Approval Register Packet: APPKT02860 - MAY 16 2022 COUNCIL MEETING Project Account Summary Project Account Key Expense Amount **None** 1,045,943.56 CONSLT-3RD ST TANK 330.00 CONSLT-N 10TH ST 2,901.60 CONSULTING - NW 6TH LITTLE WALNUT CREEK CULVERT 1,667.24 CONSULTING - NW MEREDITH DRIVE 53,620.78 CONSULTING DAYBREAK PARK 2,400.00 CONSULTING-10" GAS MAIN 705.00 CONSULTING-2ND HIGH SCHOOL RD-4TH ST 28,873.93 CONSULTING-ADA SIDEWALKS 2021 2,579.74 CONSULTING-ASHWORTH/UTE INTERSECTION 5,237.81 CONSULTING-ASR 1,870.00 CONSULTING-DOUGLAS PARKWAY PHS II -A 44,683.13 CONSULTING-DOUGLAS PKWY EAST OF WARRIOR 4,033.20 CONSULTING-HS ATHLETIC COMPLEX 3,691.61 CONSULTING -LIFT STATION 2 REHAB 25,143.17 CONSULTING -NE OUTFALL SEWER 12,997.45 CONSULTING -NW 2ND STREET PHS I-B 16,268.13 CONSULTING-PW EXPANSION 11,471.67 CONSULTING -SE ASHWORTH RD CORRIDOR 8,498.50 CONSULTING -WALNUT CREEK NORTH SEWER-PHS 2 192.00 CONSULTING -WATER CREEK WATERMAIN 1,985.32 CONSULTING -WEST AREA TRUNK SEWER PHS 2 22,203.06 LWC SEWER PHS 5 - CONSULTING 5,763.98 Grand Total: 1,303,060.88 5/ 11/2022 8:37:44 AM Page 16 of 16 ��i�/ City of Waukee, IA \(/at.1k/ee Check Report By Check Number Date Range: 04/27/2022 - 05/02/2022 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number Bank Code: AP-WAUKEE STATE 095485 IOWA DEPT OF INSPECTIONS & APPEALS 04/27/2022 Regular 0.00 1,200.00 151236 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0013428 Invoice 04/28/2022 TRIUMPH PARK NE QUAD CONCESSION ST 0.00 400.00 010-40.4210,280000 DUES, MEMBERSHIPS & S TRIUMPH PARK NE QUAD CONC 400.00 INVO013429 Invoice 04/28/2022 TRIUMPH PARK SE QUAD CONCESSION ST 0.00 400.00 010-40.4210.280000 DUES, MEMBERSHIPS & S TRIUMPH PARK SE QUAD CONC 400.00 INVO013430 Invoice 04/28/2022 TRIUMPH PARK NW QUAD CONCESSION S 0.00 400.00 010-40.4210.280000 DUES, MEMBERSHIPS & S TRIUMPH PARK NW QUAD CON 400.00 095485 IOWA DEPT OF INSPECTIONS & APPEALS 04/27/2022 Regular 0.00-1,200.00 151236 095485 IOWA DEPT OF INSPECTIONS & APPEALS 04/28/2022 Regular 0.00 400.00 151237 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO013431 Invoice 04/28/2022 TRIUMPH PARK CONCESSION STAND FOO 0.00 400.00 010-40.4210.280000 DUES, MEMBERSHIPS & S TRIUMPH PARK CONCESSION ST 400.00 150505 O'HALLORAN -VEHICLE 04/29/2022 Regular 0.00 189,777.00 151238 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount T ! 5z: Invoice 04/29/2022 '22 INTL HV507 SFA 4X2 VIN0722 0.00 189,777.00 060-30.7100.3760300 SALE OF OLD EQUIPMENT TRADE IN 2010 INTL 7300 SFA 4 -11,000.00 060-30.7100.760000 OTHER CAPITAL EQUIPME '22 INTL HV507 SFA 4X2 VIN072 46,755.40 510-30.6510,3760300 SALE OF OLD EQUIPMENT TRADE IN 2010 INTL 7300 SFA 4 -11,000.00 510-30.6510.790000 VEHICLE OR EQUIPMENT '22 INTL HV507 SFA 4X2 VIN072 46,755.40 520-30.6520.3760300 SALE OF OLD EQUIPMENT TRADE IN 2010 INTL 7300 SFA 4 -11,000.00 520-30.6520.790000 VEHICLE OR EQUIPMENT '22 INTL HV507 SFA 4X2 VIN072 46,755.40 540-30.6540.3760300 SALE OF OLD EQUIPMENT TRADE IN 2010 INTL 7300 SFA 4 -11,000.00 540-30.6540.790000 VEHICLE OR EQUIPMENT '22 INTL HV507 SFA 4X2 VIN072 46,755.40 560-80.5300.790000 VEHICLE OR EQUIPMENT '22 INTL HV507 SFA 4X2 VIN072 46,755.40 094730 IOWA CHAPTER APWA 05/02/2022 Regular 0.00 225.00 151239 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount 10559292 Invoice 02/18/2022 2022 APWA IOWA SPRING CONFERENCE- 0.00 225.00 060-30.7100.470000 TRAINING/TRAVEL EXPEN 2022 APWA IOWA SPRING CONF 225.00 035130 CLAYTON ENERGY CORPORATION 04/28/2022 EFT 0.00 372,985.45 254490 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount I _ u l Invoice 04/13/2022 MARCH 2O22 COMMODITY 0.00 372,985.45 540-30.65,10.650000 COST OF GOODS SOLD MARCH 2O22 COMMODITY 372,985.45 095450 IOWA DEPARTMENT OF HUMAN SERVICES 04/28/2022 EFT 0.00 3,724.13 254491 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount 05 2022 66 Invoice 04/15/2022 MAY 2022 STATE SHARE OF GEMT 0.00 3,724.13 010 7Q1500.231800 AMBULANCE BILLING FEE MAY 2022 STATE SHARE OF GEM 3,724.13 217150 US POSTAL SERVICE 04/28/2022 EFT 0.00 1,642.54 254492 5/11/2022 9:32:42 AM Page 1 of 3 Check Report Vendor Number Payable # INVO013433 217150 Payable # INV0013432 217150 Payable # INVO013434 Vendor Name Payable Type Account Number Invoice 570-30.6550.360000 US POSTAL SERVICE Payable Type Account Number Invoice 570-30.6550.360000 US POSTAL SERVICE Payable Type Account Number Invoice 570-30.6550.360000 1 Date Range: 04/27/2022 - 05/02/2022 Payment Date Payment Type Discount Amount Payment Amount Number Post Date Payable Description Discount Amount Payable Amount Account Name Item Description Distribution Amount 04/28/2022 APRIL 2022 REGULAR BILLS 0.00 1,642.54 POSTAGE & SHIPPING APRIL 2022 REGULAR BILLS 1,642.54 04/28/2022 EFT 0.00 475.29 254493 Post Date Payable Description Discount Amount Payable Amount Account Name Item Description Distribution Amount 04/28/2022 APRIL 2022 LATE NOTICES 0.00 475.29 PnSTAGF Rt SHIPPING APRIL 2022 LATE NOTICES 475.29 04/28/2022 EFT Post Date Payable Description Di Account Name Item Description 04/28/2022 APRIL 2022 ACH BILLS POSTAGE & SHIPPING APRIL 2022 ACH BILLS Bank Code AP Summary Payable Payment Payment Type Count Count Regular Checks 6 4 Manual Checks 0 0 Voided Checks 0 1 Bank Drafts 0 0 EFT's 5 5 11 30 Discount 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,082.43 254494 scount Amount Payable Amount Distribution Amount 0.00 1,082.43 1,082.43 Payment 191,602.00 0.00 -1,200.00 0.00 379,909.84 570,311.84 1/11/2022 9:32:42 AM Page 2 of 3 Check Report N Date Range: 04/27/2022 - 05/02/2022 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 6 4 0.00 191,602.00 Manual Checks 0 0 0.00 0.00 Voided Checks 0 1 0.00 -1,200.00 Bank Drafts 0 0 0.00 0.00 EFT's 5 5 0.00 379,909.84 11 10 0.00 570,311.84 Fund Summary Fund Name Period Amount 999 POOLED CASH 4/2022 570,086.84 999 POOLED CASH 5/2022 225.00 570,311.84 5/il/2022 9:32:42 AM Page 3 of 3 City of Waukee, IA Wcyjkee Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE 136050 MI -FIBER, LLC Payable # Payable Type Account Number 11035098 Invoice 7 1�0-80.8750.450000 11040859 Invoice 010-10.1100.450000 010-10.1400.450000 010-10.1500.450000 11041453 Invoice 010-40.3100.450000 11043681 Invoice 010-40.4300.450000 Payment Date Payment Type Check Report By Check Number Date Range: 05/04/2022 - 05/11/2022 Discount Amount Payment Amount Number 05/06/2022 Regular 0.00 653.90 151385 Post Date Payable Description Discount Amount Payable Amount Account Name Item Description Distribution Amount 05/O1/2022 MAY 2022 STATEMENT- GOLF 0.00 105.25 TELEPHONE MAY 2022 STATEMENT- GOLF 105.25 05/O1/2022 MAY 2022 STATEMENT- PUBLIC SAFETY 0.00 338.15 TELEPHONE MAY 2022 STATEMENT- PUBLIC 169.07 TELEPHONE MAY 2022 STATEMENT- PUBLIC 37.20 TELEPHONE MAY 2022 STATEMENT- PUBLIC 131.88 05/O1/2022 MAY 2022 STATEMENT- LIBRARY 0.00 105.25 TELEPHONE MAY 2022 STATEMENT- LIBRARY 105.25 05/O1/2022 MAY 2022 STATEMENT- COMMUNITY CEN 0.00 105.25 TELEPHONE MAY 2022 STATEMENT- COMM 105.25 199023 SUGAR CREEK GOLF COURSE 05/06/2022 Regular 0.00 233.00 151386 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0013455 Invoice 05/06/2022 GOLF LEAGUE PRIZES 0.00 233.00 750-80.8750.653000 LEAGUE PRIZES/EXPENSE GOLF LEAGUE PRIZES 233.00 5/11/2022 9:34:49 AM Page 1 of 4 Check Report Date Range: 05/04/2022 - 05/11/2022 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 235285 WELLS FARGO COMMERCIAL CARD 05/06/2022 EFT 0.00 12,867.71 254517 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount WF04262O22 Invoice 04/25/2022 WELLS FARGO CREDIT CARD 0.00 12,867.71 010-10.1100.470000 TRAINING/TRAVEL EXPEN JM0942- SENT POST TESTS BACK 12.75 010-10.1100.470000 TRAINING/TRAVEL EXPEN SW5957- LUNCH TRAINING. 58.43 010-10.1100.470000 TRAINING/TRAVEL EXPEN MS1007- MEAL- ILEA MEETING 19.50 010-10.1100.470000 TRAINING/TRAVEL EXPEN MS1007- MEAL - IA ASSOC OF 15.61 010-10.1100.470000 TRAINING/TRAVEL EXPEN KC0892- JOHNSON GRADUATIO 32.87 010-10.1100.470000 TRAINING/TRAVEL EXPEN HA0876- WORKING LUNCH W/ 31.82 010-10.1100.570000 FUEL SC0900- GAS FOR TRAINING. 90.18 010-10.1400.410000 REPAIR OF VEHICLES TT1205- VEHICLE UPFITTING 2.93 010-10.1400.410000 REPAIR OF VEHICLES NW1213- CARBURETOR CLEANE 13.13 010-10.1400.410100 REPAIR/MAINTENANCE 0 AH1171- 4 GAS FIX 131.00 010-10.1400.470000 TRAINING/TRAVEL EXPEN AC1155- TRAVEL TO PINNACLE C 150.41 010-10.1400.470000 TRAINING/TRAVEL EXPEN S04529- PANCAKE BREAKFAST B 500.00 010-10.1400.470000 TRAINING/TRAVEL EXPEN S04529- PANCAKE BREAKFAST B 500.00 010-10.1400.590000 OPERATING SUPPLIES & TT1205- DIGITAL DASHBOARD F 2,452.30 010-10.1400.590000 OPERATING SUPPLIES & TT1205- HOUSE FOOD 24.46 010-10.1500.410000 REPAIR OF VEHICLES TT1205- VEHICLE UPFITTING 10.42 010-10.1500.410000 REPAIR OF VEHICLES NW1213- LIGHT BULB AMBULA 2.60 010-10.1500.470000 TRAINING/TRAVEL EXPEN NW1213- PIG TRACHS FOR PRA 196.75 010-10.1500.470000 TRAINING/TRAVEL EXPEN AC1155-TRAVEL TO PINNACLE C 533.30 010-10.1500.590000 OPERATING SUPPLIES & TT1205- HOUSE FOOD 24.46 010-20,6150.590000 OPERATING SUPPLIES & RB1247- ADAPTER AND 18V BAT 160.48 010-40.3100.360000 POSTAGE & SHIPPING KL1015- POSTAGE 6.63 010-40,3100.460300 PROGRAMS KL1015- ADULT PROGRAM SUPP 80.98 010-40.3100.460300 PROGRAMS KW1023- KIDS PROGRAM SPEAK 280.00 010-40.3100.640000 LIBRARY BOOKS/FILMS/R KL1015- MAGAZINE SUBSCRIPTI 234.63 010-40.4200.461600 EASTER EGG HUNT DE1056- EASTER COLORING CO 45.57 010-40.4210.350100 PRINTING JV1122- MIRACLE LEAGUE FLYER 14.50 010-50.8500.470000 TRAINING/TRAVEL EXPEN JB5414- COMMERCIAL REAL EST 38.77 010-60.8300.470000 TRAINING/TRAVEL EXPEN BD1403- DINNER DEPOSIT WAS 750.00 010-60.8300.470000 TRAINING/TRAVEL EXPEN BD1403- LUNCH FOR 3 @ COUR 30.31 010-60.8300.470000 TRAINING/TRAVEL EXPEN BD1403- LUNCH WITH CONSULT 45.99 010-60.8300.470000 TRAINING/TRAVEL EXPEN BD1403- LUNCH WITH DEVELOP 22.46 010-60.8300.470000 TRAINING/TRAVEL EXPEN BD1403- PARKING FOR WRA ME 1.00 010-60.8300.470000 TRAINING/TRAVEL EXPEN RS1528- 04-11-2022 COUNCIL 231.25 010-60.8300.590000 OPERATING SUPPLIES & BD1403- COOKIES FOR PUBLIC A 25.98 010-60.8300.590000 OPERATING SUPPLIES & RS1528- FUNERAL FLOWERS - S 80.00 010-60.8350.470000 TRAINING/TRAVEL EXPEN TC1486- DINNER NIGHT BEFORE 54.52 010-60.8350.470000 TRAINING/TRAVEL EXPEN ML1494- IAPELRA SPRING CONF 6.57 010-60.8350.470000 TRAINING/TRAVEL EXPEN ML1494- IAPELRA SPRING CONF 24.17 010-60.8350.470000 TRAINING/TRAVEL EXPEN ML1494- IAPELRA SPRING CONF 127.18 010-60.8350.470000 TRAINING/TRAVEL EXPEN ML1494- LUNCH MEETING MIC 29.85 010-60.8350.470000 TRAINING/TRAVEL EXPEN TC1486- HOTEL FOR IAPELRA CO 119.18 010-60.8800.450000 TELEPHONE SL1239- CITYWIDE TELEPHONE 200.00 010-60.8800.540000 MINOR EQUIPMENT SL1239- PD TEMPORARY HARD 209.99 010-60.8800.540000 MINOR EQUIPMENT SL1239- PD DATA RECOVERY HA 99.98 010-60.8800.540000 MINOR EQUIPMENT SL1239- DOCKING CABLE FOR HI 131.07 327-90.2150.980111 HS REC COMPLEX - CONS JC1049- TRIUMPH SHOP BREAK 2,226.24 327-90.2150.980111 HS REC COMPLEX - CONS SL1239- TRI. PARK MIRACLE LEA 1,283.99 510-30.6510.360000 POSTAGE & SHIPPING DK5965- WATER FLOW TESTING 19.22 510-30.6510.470000 TRAINING/TRAVEL EXPEN TC1486- PRE -EMPLOYMENT DR 75.00 510-30.6510.590000 OPERATING SUPPLIES & ER1569-TROY WINTERS RETIRE 50.29 510-30.6510.882421 ASR FACILITY SL1239- PW ASR WELL FACILITY 1,283.99 520-30.6520.470000 TRAINING/TRAVEL EXPEN TC1486- PRE -EMPLOYMENT DR 75.00 5/11/2022 9:34:49 AM Page 2 of 4 Check Report Vendor Number Vendor Name Payment Date Payment Type Bank Code AP Summary Payable Payment Payment Type Count Count Discount Regular Checks 5 2 0.00 Manual Checks 0 0 0.00 Voided Checks 0 0 0.00 Bank Drafts 0 0 0.00 E FT's 1 1 0.00 6 3 0.00 Date Range: 05/04/2022 - 05/11/2022 Discount Amount Payment Amount Number Payment 886.90 0.00 0.00 0.00 12,867.71 13,754.61 5/11/2022 9:34:49 AM Page 3 of 4 Check Report 4Y-,, Date Range: 05/04/2022 - 05/11/2022 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 5 2 0.00 886.90 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 0 0 0.00 0.00 EFT's 1 1 0.00 12,867.71 6 3 0.00 13,754.61 Fund Summary Fund Name Period Amount 999 POOLED CASH 5/2022 13,754.61 13,754.61 5/11/2022 9:34:49 AM Page 4 of 4 City of Waukee, IA Waukee Vendor Number Vendor Name Payment Date Payment Type Bank Code: AP-WAUKEE STATE 199023 SUGAR CREEK GOLF COURSE 05/03/2022 Regular Payable # Payable Type Post Date Payable Description Account Number Account Name Item Description INV0013443 Invoice 05/03/2022 GOLF LEAGUE PRIZES 750-80.8750.653000 LEAGUE PRIZES/EXPENSE GOLF LEAGUE PRIZES Bank Code AP Summary Payable Payment Payment Type Count Count Discount Regular Checks 1 1 0.00 Manual Checks 0 0 0.00 Voided Checks 0 0 0.00 Bank Drafts 0 0 0.00 EFT's 0 0 0.00 1 1 0.00 Check Report By Check Number Date Range: 05/03/2022 - 05/03/2022 Discount Amount Payment Amount Number 0.00 248.00 151361 Discount Amount Payable Amount Distribution Amount 0.00 248.00 248.00 Payment 248.00 0.00 0.00 0.00 0.00 248.00 5/11/2022 9:42:45 AM Page 1 of 2 Check Report Date Range: 05/03/2022 - 05/03/2022 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 1 1 0.00 248.00 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 0 0 0.00 0.00 EFT's 0 0 0.00 0.00 1 1 0.00 248.00 Fund Summary Fund Name Period Amount 999 POOLED CASH 5/2022 248.00 248.00 5/11/2022 9:42:45 AM Page 2 of 2 Council Payroll Reimbursements CPO Wo kee City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE By Check Number Date Range: 04/28/2022 - 05/11/2022 Payment Date Payment Type Discount Amount Payment Amount Number 034875 CITY OF WAUKEE 05/10/2022 Regular 0.00 13,636.11 151391 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO013474 Invoice 05/13/2022 CELL PHONE REIMBURSEMENT 0.00 132.50 010-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 92.50 060-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 15.00 510-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 3.76 520-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 3.74 540-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 15.00 750-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 2.50 INVO013475 Invoice 05/13/2022 LIFE INSURANCE PREMIUM 0.00 801.24 Q10-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 648.00 060-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 37.61 510-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 10.26 520-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 10.24 540-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 38.20 560-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 32.68 570-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 21.05 750-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 3.20 INVO013476 Invoice 05/13/2022 STD INSURANCE PREMIUM 0.00 969.39 010-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 786.13 060-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 79.59 510-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 26.20 520-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 25.95 540-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 19.25 560-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 23.15 750-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 9.12 I_NVO013481 Invoice 05/13/2022 HEALTH INSURANCE DEDUCTION 0.00 7,443.72 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 5,782.90 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 660.32 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 120.28 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 119.84 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 480.24 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 120.06 750-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 160.08 INVO013482 Invoice 05/13/2022 HEALTH INSURANCE DEDUCTION 0.00 1,569.78 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 1,338.93 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 69.78 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 68.76 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 23.10 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 23.04 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 46.17 INVO013483 Invoice 05/13/2022 HEALTH INSURANCE DEDUCTION 0.00 1,945.98 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 1,405.43 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 162.23 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 162.10 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 108.11 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 108.11 INVO013484 Invoice 05/13/2022 HEALTH INSURANCE DEDUCTION 0.00 773.50 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 663.00 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 110.50 5/11/2022 7:41:17 AM Page 1 of 4 a Council Payroll Reimbursements Date Range: 04/28/2022 - 05/11/2022 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 036350 IOWA DEPT OF HUMAN SERVICES 05/10/2022 Regular 0.00 754.66 151392 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO013468 Invoice 05/13/2022 CHILD SUPPORT 0.00 754.66 010-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 754.66 091000 ICMA RETIREMENT TRUST 457 05/10/2022 Regular 0.00 10,860.97 151393 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO013469 Invoice 05/13/2022 ICMA 457 ROTH CONTRIBUTION 0.00 357.00 010-2011200 IPERS WITHHOLDING PAY ICMA 457 ROTH CONTRIBUTION 332.00 560-2011200 IPERS WITHHOLDING PAY ICMA 457 ROTH CONTRIBUTION 25.00 INVO013470 Invoice 05/13/2022 ICMA401A 0.00 2,130.81 010-2011200 IPERS WITHHOLDING PAY ICMA 401A 2,130.81 INVO013471 Invoice 05/13/2022 ICMA ROTH CONTRIBUTION 0.00 1,653.92 010-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 1,303.92 060-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 50.00 510-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 62.52 520-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 62.52 540-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 112.52 560-2011200 IPERS WITHHOLDING PAY ICMA ROTH CONTRIBUTION 62.44 INVO013472 Invoice 05/13/2022 ICMA RETIREMENT 0.00 3,261.92 010-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 3,086.92 060-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 25.00 540-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 50.00 570-2011200 IPERS WITHHOLDING PAY ICMA RETIREMENT 100.00 INVO013473 Invoice 05/13/2022 ICMA 0.00 3,457.32 010-2011200 IPERS WITHHOLDING PAY ICMA 3,366.70 510-2011200 IPERS WITHHOLDING PAY ICMA 45.00 5,20-2011200 IPERS WITHHOLDING PAY ICMA 45.62 099999 EFTPS 05/10/2022 Regular 0.00 113,492.23 151394 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INVO013489 Invoice 05/13/2022 FICA TAX WITHHOLDING 0.00 54,225.94 010-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 43,523.88 060-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 2,598.50 510-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,729.64 520-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,428.46 540-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,988.02 560-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 876.00 570-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 877.86 750-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,203.58 INVO013490 Invoice 05/13/2022 FEDERAL WITHHOLDING TAXES 0.00 46,584.47 010-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 39,001.60 060-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,800.09 510-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,260.03 520-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,054.44 540-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,601.07 560-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 603.24 570-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 897.05 750-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 366.95 INVO013491 Invoice 05/13/2022 MEDICARE TAX WITHHOLDING 0.00 12,681.82 010-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 10,178.94 060-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 607.70 510-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 404.60 520-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 333.98 540-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 464.90 560-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 204.90 5/11/2022 7:41:17 AM Page 2 of 4 Council Payroll Reimbursements Date Range: 04/28/2022 - 05/11/2022 Vendor Number Vendor Name Payment Date Payment Type Discount Amount Payment Amount Number 570-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 205.30 750-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 281.50 167175 POLK COUNTY SHERIFF'S OFFICE 05/10/2022 Regular 0.00 399.50 151395 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0013477 Invoice 05/13/2022 WAGE GARNISHMENT 0.00 399.50 060-2030000 PAYROLL PAYABLES WAGE GARNISHMENT 399.50 099300 ISOLVED BENEFIT SERVICES, INC 05/10/2022 EFT 0.00 13,130.19 254518 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0O13478 Invoice 05/13/2022 LIMITED PURPOSE FLEX MEDICAL DEDUC 0.00 41.66 010-2030000 PAYROLL PAYABLES LIMITED PURPOSE FLEX MEDICA 20.83 060-2030000 PAYROLL PAYABLES LIMITED PURPOSE FLEX MEDICA 20.83 INV0013479 Invoice 05/13/2022 SECTION 125 MEDICAL DEDUCTIONS 0.00 4,833.20 010-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCT] 3,556.24 060-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 382.72 510-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCT] 94.10 520-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 93.36 540-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCT] 389.56 560-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCT] 180.84 570-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 101.66 750-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCT] 34.72 INV0013480 Invoice 05/13/2022 SECTION 125 DAYCARE DEDUCTIONS 0.00 3,387.44 010-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCTI 2,949.95 060-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT] 208.33 560-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT] 208.33 750-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT] 20.83 1_NV0013487 Invoice 05/13/2022 RETIREMENT HEALTH SAVINGS ACCOUNT 0.00 4,867.89 510-2030000 PAYROLL PAYABLES RETIREMENT HEALTH SAVINGS 4,867.89 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 17 5 0.00 139,143.47 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 0 0 0.00 0.00 EFT's 4 1 0.00 13,130.19 21 6 0.00 152,273.66 5/11/2022 7:41:17 AM Page 3 of 4 Council Payroll Reimbursements Date Range: 04/28/2022 - 05/11/2022 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 17 5 0.00 139,143.47 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 0 0 0.00 0.00 EFT's 4 1 0.00 13,130.19 21 6 0.00 152,273.66 Fund Summary Fund Name Period Amount 999 POOLED CASH 5/2022 152,273.66 152,273.66 5/11/2022 7:41:17 AM Page 4 of 4 Utility Refund Check Report k LO City of Waukee, IA Ubulkee Date Range: 4/28/2022 - 5/11/2022 Adj Account Number Name Date Type Amount Reference Packet Receipt Type 16-00696-03 Ballwin, Ryan J 5/4/2022 Refund 49.30 Check #:151364 UBPKTO9879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 49.30 0.00 0.00 0.00 0.00 49.30 Aging Total: 49.30 0.00 0.00 0.00 0.00 49.30 18-00258-01 Burlin, Austin 5/4/2022 Refund 66.85 Check #: 151367 UBPKT09879 996 66.85 0.00 0.00 0.00 0.00 66.85 Aging Total: 66.85 0.00 0.00 0.00 0.00 66.85 19-00399-02 Carfrae, Jak 5/4/2022 Refund 23.46 Check #: 151368 UBPKT09879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 21-00142-00 Clayton Properties (DBA Clover &... 5/4/2022 Refund 21-00056-00 Clayton Properties, DBA Summit H... 5/4/2022 Refund 19-00404-02 Dreamer, Brady M 5/4/2022 Refund 996 -76.54 100.00 0.00 0.00 0.00 23.46 Aging Total: -76.54 100.00 0.00 0.00 0.00 23.46 151.20 Check #: 151375 UBPKT09879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 0.00 151.20 0.00 0.00 0.00 151.20 996 0.00 153.68 0.00 0.00 0.00 153.68 Aging Total: 0.00 304.88 0.00 0.00 0.00 304.88 146.24 Check #: 151373 UBPKT09879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 0.00 146.24 0.00 0.00 0.00 146.24 996 0.00 195.84 0.00 0.00 0.00 195.84 996 0.00 215.68 0.00 0.00 0.00 215.68 996 0.00 151.20 0.00 0.00 0.00 151.20 996 0.00 141.28 0.00 0.00 0.00 141.28 Aging Total: 0.00 850.24 0.00 0.00 0.00 850.24 25.18 Check #: 151369 UBPKT09879 996 -74.82 100.00 0.00 0.00 0.00 25.18 Aging Total: -74.92 100.00 0.00 0.00 0.00 25.18 17-00430-04 Lee, Diamonique 5/4/2022 Refund 50.80 Check #: 151366 UBPKT09879 996 Aging Total 50.80 0.00 0.00 0.00 0.00 50.80 50.80 0.00 0.00 0.00 0.00 50.80 5/11/2022 7:41:43 AM Utility Refund Check Report Page 1 of 3 V\ Adj Account Number Name Date Type Amount Reference Packet Receipt Type 83-01593-08 Mujic, Vahid 5/4/2022 Refund 3.43 Check #: 151382 UBPKT09879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 3.43 0.00 0.00 0.00 0.00 3.43 Aging Total: 3.43 0.00 0.00 0.00 0.00 3.43 21-00171-00 Orton Homes LLC 5/4/2022 Refund 181.86 Check #: 151377 UBPKT09879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 0.00 181.86 0.00 0.00 0.00 181.86 996 0.00 149.96 0.00 0.00 0.00 149.96 Aging Total: 0.00 331.82 0.00 0.00 0.00 331.82 16-00809-04 Redd, Christina O 5/4/2022 Refund 70.98 Check #: 151365 UBPKT09879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 70.98 0.00 0.00 0.00 0.00 70.98 Aging Total: 70.98 0.00 0.00 0.00 0.00 70.98 83-00070-07 Romoff, Merilyn 5/4/2022 Refund 4.42 Check #: 151381 UBPKT09879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 4.42 0.00 0.00 0.00 0.00 4.42 Aging Total: 4.42 0.00 0.00 0.00 0.00 4.42 19-01094-01 Rose, Wesley S 5/4/2022 Refund 49.44 Check #: 251372 UBPKT09879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 49.44 0.00 0.00 0.00 0.00 49.44 Aging Total: 49.44 0.00 0.00 0.00 0.00 49.44 84-02145-01 Salkic, Enes 5/4/2022 Refund 49.71 Check #: 151384 UBPKT09879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 0.00 49.71 0.00 0.00 0.00 49.71 Aging Total: 0.00 49.71 0.00 0.00 0.00 49.71 84-00191-02 Sojourn, Therese K 5/4/2022 Refund 93.80 Check #: 151383 UBPKT09879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 93.80 0.00 0.00 0.00 0.00 93.80 Aging Total: 93.80 0.00 0.00 0.00 0.00 93.80 16-00553-05 Toubl Contracting Inc 5/4/2022 Refund 68.60 Check #: 151363 UBPKT09879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 68.60 0.00 0.00 0.00 0.00 68.60 Aging Total: 68.60 0.00 0.00 0.00 0.00 68.60 19-00799-04 Wood, Lisa D 5/4/2022 Refund 33.85 Check #: 151370 UBPKT09879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 33.85 0.00 0.00 0.00 0.00 33.85 Aging Total: 33.85 0.00 0.00 0.00 0.00 33.85 03-32605-21 Woodard, Abigail K 5/4/2022 Refund 54.00 Check #: 151362 UBPKT09879 Revenue Code Current Plus 1 Plus 2 Plus 3 Plus 4 Balance 996 0.00 54.00 0.00 0.00 0.00 54.00 Aging Total: 0.00 54.00 0.00 0.00 0.00 54.00 Transaction Grand Total for Period: 2,130.76 S/1112022 7:41:43 AM Utility Refund Check Report Page 2 of 3 Totals by Transaction Type Transaction Type Count Amount Refund 23 2,130.76 Total for Period: 23 2,130.76 Totals by Transaction Type and Revenue Code Transaction Type Revenue Code Count Amount Refund 996 - Unapplied Credits 49 2,130.76 Refund Total: 2,130.76 Total for Period: 49 2,130.76 Totals by Revenue Code Revenue Code Count Amount 996 - Unapplied Credits 49 2,130.76 Total for Period: 49 2,130.76 5/11/2022 7:41:43 AM Utility Refund Check Report Page 3 of 3 City of Waukee, IA Employee Name ABRAMOWITZ, LEVI ADKINS, COREY ADKISSON, JENNIFER AHRENS, ELIZA ALDRICH, SHAWN ANDERSON,SARA ANNIS, JEREMY ANTON, MARY ARIAS, HECTOR BAKER, RANDY BARTLING, DARREL BAUMAN, LISA BECKER,CHEYANNE BECKNER, HALEY BEDFORD, SAMANTHA BLACK, HUNTER BOYD, ISAAC BOYLE, GAVIN BRACKETT, ELIZABETH BROWN, ANGALEA BROWN, JENNIFER BROWN, NATHAN BRUENING, BENJAMIN BRUNS, RACHEL BURKHART, LINDA BURKHART, MARK CAMPBELL, SCOTT CARPENTER, PAUL CARROLL,JOSEPH CHAMBERS, KYLE CHRISTENSEN, AARON CHRISTENSEN, ABAGAIL CICHOSKI, KELLI CLAYTON, ANISTON CLAYTON, EMMA CLEMEN, ANTHONY COGGESHELL, LEE CORKREAN, JENNIFER COUGHLIN, RYANN COUGHLIN, TON] CRAVEN,GAYLA CRONE, ERIN CUNNINGHAM, SCOTT DANIEL, COLE DEBOER, MELISSA DEETS, BRADLY DEETS, MAXWELL DEZEEUW, DAVID DODGE, JUSTIN EDWARDS, DANAE EHLER,JOEL FLUGGE-SMITH, JAMIE FREDERICK, JUSTIN FREDERICKSEN, BROCK FREEMAN, MATTHEW FROEHLICH, WILLIAM FUNKE, JASON Payroll Publication Report By Employee Name Payroll Set: 01 - City of Waukee For Date Range 05132022-05132022 Salary 1,746.71 1,436.49 599.52 24.51 2,052.21 1,441.69 292.65 149.21 2,244.61 1,918.36 185.54 1,293.68 357.40 1,557.13 1,396.41 1,338.81 1,563.25 1,339.86 991.23 1,487.22 2,207.13 2,169.02 276.85 2,295.90 3,194.37 948.68 2,459.77 1,742.74 2,137.17 1,744.42 750.07 1,302.47 1,844.53 255.11 209.78 2,602.71 1,623.99 1,645.09 84.04 1,002.22 138.58 560.81 2,882.47 1,421.16 2,238.68 4,702.09 45.02 2,488.19 2,209.62 2,134.59 822.71 1,891.90 2,160.97 1,303.65 1,516.24 415.14 497.19 Employee Name Salary FYFE, JUSTIN 1,697.59 GARLICH, ELIZABETH 196.15 GAVIN, HALEY 584.56 GIBBS, AUSTIN 1,669.76 GIBSON IV, WILLIAM 1,723.74 GILCHRIST, NICHOLAS 1,669.10 GITZEN, ROBERT 2,067.93 GOINS, ANDREA 2,390.44 GROVE, BRIAN 228.00 GUESS, KATHRYN 1,716.11 HABGOOD, FINLEY 188.39 HANSON, LAURA 1,891.30 HAUCK, BRETT 523.74 HEIMANN, RONALD 2,016.71 HENTGES, ERIC 1,756.74 HERRICK, ROBERT 2,352.87 HILGENBERG, ADAM 2,318.29 HILL, JOHN 64.64 HILLMAN, TAYLOR 1,074.18 HIRSCHY, TAYA 192.08 HOLMES, HOLLY 1,548.15 HUFFORD, ROSEMARY 526.30 HUSTED, TROY 1,868.07 HUTTON, JOSHUA 2,551.44 JACKSON, COLE 1,683.15 JERMIER, MATTHEW 3,109.45 JOHNSON, WYATT 1,851.85 KAMMERER, EMMILY 753.97 KAPPOS, SARA 2,744.42 KASS, ANDREW 2,784.45 KASZINSKI, BRETT 916.51 KELLER, CHRISTOPHER 2,019.95 KICKBUSH, CHRISTOPHER 1,766.80 KINNEY, SCOTT 2,876.07 KINSETH, RICHARD 443.82 KLEINWOLTERINK, COLE 1,886.10 KLEVER, JUDY 916.28 KNEPPER, AARON 161.92 KNUDSEN, DYLAN 2,045.86 KNUST, DANIEL 1,684.23 KOESTER, RUDY 3,519.65 KOSTECKI, BROOKE 670.27 KREFT, ALEXUS 547.53 KUHLES, KAMRYN 399.65 KUHLMAN, TERESA 416.70 LARSON, KENNETH 606.62 LARSON, KRISTINE 2,737.98 LAUGHRIDGE, DANIEL 1,796.88 LE, SON 3,094.41 LEMKE, NEIL 1,818.28 LEVSEN, BRYAN 2,906.11 LINDSAY, MICHELLE 2,756.48 LONG, JEREMY 3,018.58 LOVETINSKY, TRACY 1,688.88 LYNCH, JEREMY 1,287.81 MANNING, JOSHUA 2,114.63 MAREAN, JOSHUA 1,198.51 MAREK, JAMES 1,865.15 MCCAY, BRENDA 280.29 MCCOY, CARA 656.87 MEEKER, BRYCE 2,040.73 MELLENCAMP, JEFFREY 2,821.96 METTEE, WILLIAM 1,893.89 MINAR, VANESSA 1,185.43 Employee Name Salary MINIKUS, JOSHUA 1,701.88 MONA, RACHEL 1,834.40 MORRIS, ASHLEY 1,491.30 MURRA, BRIAN 1,902.25 MURRAY, JACK 2,441.82 NEWBURY, NICHOLAS 1,731.74 NICHOLS, ANDREW 1,851.01 NICODEMUS, BLAKE 873.97 OLDHAM, JAMES 2,324.05 OLSASKY, JOHN 294.72 OSBORN, RYAN 310.97 OSBORN, SARAH 1,620.67 OSTRING, KATHLEEN 1,743.47 OWENS, TANNER 1,004.38 PARISH, TONJA 1,573.89 PARKER, ABIGAIL 170.63 PATTERSON, KEVIN 1,419.68 PAYNE, THOMAS 1,650.96 PELLETTERI, SALVATORE 285.38 PERKINS, JACOB 1,794.97 PETTIT, BRANDON 2,515.01 PIZINGER, JAMES 1,409.02 PORTER, NICKOLAS 453.64 PURVIS, KATHRYN 1,383.79 QUAM, BRADLEY 1,712.23 QUICK, TIMOTHY 297.46 QUINN, JOHN 3,515.37 RASH, RONALD 2,020.50 RICHARDSON, DACE 1,390.11 RICHARDSON, ELIZABETH 1,637.48 RIPPIN, PEYTON 238.26 ROBBINS, CORBY 2,041.06 ROBINSON, CLINT 3,671.32 ROBINSON, NATHANIEL 294.39 ROSENOW, MELANIE 558.05 ROTH, TITO 1,671.67 ROTSCHAFER, CARMEN 1,450.54 ROYER, TIMOTHY 3,038.88 SCHAUFENBUEL, KARI 1,155.89 SCHETTLER, RODNEY 7,458.56 SCHUETT, REBECCA 2,486.63 SCHULTZ, JEFFREY 2,155.88 SEDDON, JOSH 2,079.91 SHAFFER, CHET 402.18 SLYCORD, JASON 1,862.46 SMITH, BLAKE 1,955.81 SNOW, SUSAN 221.64 SOFEN, NATASHA 34.42 SPOSETO, MACKENZIE 2,535.00 STEINKE, KURT 783.42 STEPHENS, CLINT 526.09 STEWARD, ERIC 1,853.52 STIFEL, DALTON 2,037.28 STONE, GREGORY 395.09 STOTZ, MELISSA 601.26 STRONG, RACHAEL 531.46 TAYLOR, CHRISTINA 113.38 THAYER, CHANDLER 2,352.55 THIES, ROBERT 212.04 TOWNSEND, MCKENNA 2,353.79 TRUMAN, GRAHAM 134.92 TYSDAL, THOMAS 2,974.38 VANDEKAMP, JOSHUA 2,194.85 VENTO, NICHOLAS 1,392.86 Employee Name Salary WARMAN, THOMAS 152.76 WAUGH, DOUGLAS 797.07 WEBER, BRIAN 1,350.12 WERTS, DANIEL 2,061.52 WESTON STOLL, KERI 1,813.13 WHITE, JASON 1,410.11 WIGGINS, MATHEW 149.71 WILLIAMS, NATHAN 620.37 WILLIAMS, SUSAN 2,028.56 WINTERS, TROY 1,869.56 WISE, NATHAN 2,362.17 WOOD, DANIEL 533.62 WRIGHT, MICHAEL 1,824.89 WRIGHT, PAUL 752.52 YOUNG, JOH NATHAN 1,798.92 YOUSO, ANTHONY 1,433.83 *TOTALS* 302, 211.01