Loading...
HomeMy WebLinkAbout2017-09-05-J01A 09052017_bill list_payrollCity of Waukee Bill Presentation Recap September 5, 2017 Total Unpaid Bills Presented for Approval : Total Checks Issued Prior to Council Approval: Regular Checks: A) Prior to Last Council Meeting B) After Last Council Meeting C) Payroll Taxes & Reimbursements D) Utility Refunds Payroll Checks Issued: E) 0811512017 Grand Total: FY 2018 Fund Recap: Expenditures Budgeted Year To Date 010 General Fund $ 11,299,192 $ 1,711,311 060 Road Use Tax Fund $ 2,151,246 $ 270,507 075 Waukee Foundation $ - 080 Library Foundation $80.20 085 Asset Forfeitures $ - 091 Hickman West Indust Park TIF $ 424,625 $ - 092 Enterprise Business Park TIF Fund $ - 093 Waukee Urban Renewal Area TIF Fund $ 2,909,501 $ 10,000 094 Gateway Urban Renewal $ - 095 Autumn Ridge Urban Renewal $ - 096 Waukee West Urban Renewal $ 3,965 110 Debt Service Fund $ 6,085,734 $ - 111 Special Assessments Fund $ 47,006 $ - 210 Employee Benefits Fund $ 1,802,000 $ - 327 Capital Projects $ 12,640,000 $ 4,389,885 330 City Wide SA Sidewalk Project $ - 510 Water Utility Fund $ 4,231,652 $ 403,017 520 Sewer Utility Fund $ 1,658,400 521 University Ave Trunk Sewer Project $ - 522 Waste Water Treatment PI $ 16,329,351 $ - 523 E Area Pump Sta Treatment $ - 540 Gas Utility Fund $ 5,565,596 $ 443,327 560 Storm Sewer Utility Fund $ 2,563,779 $ 127,236 570 Utility Bill Fund $ 274,090 $ 28,352 590 Solid Waste Collect & Rcycl Fund $ 1,211,000 $ 214,380 750 Golf Course Fund $ 533,455 $ 121,807 810 Equipment Revolving Fund $ - $ - $1,125,542.89 $127,914.88 $211,390.45 $106, 957.10 $4,290.49 $234, 049.13 6� $1,810,144.94 4�OL, AD1-7 Revenues Budgeted Year To Date $ 11,301,210 $ 208,202 $ 2,122,000 $ 474,029 $ 401 $ 576,000 $ - $ 2,780,500 $ 6,414 $ 78,450 $ - $ 84,125 $ $ 7,184,303 $ 4,335 $ 34,200 $ 1,396 $ 1,801,935 $ 2,079 $ 11,550,000 $ 613,598 $ 4,441,570 $ 1,296,734 $ 922,112 $ 212 $ 4,048,100 $ - $ 4,951,010 $ 315,574 $ 830,950 $ 141,819 $ 224,100 $ 10,070 $ 1,250,900 $ 214,698 $ 610,300 $ 166,770 Total: $ 68,068,227 $ 9,382,266 $ 53,869,653 $ 4,378,441 City of Waukee FY2017 Department Report - General Fund As of SEPTEMBER 5TH , 2017 Expended YTD Budgeted $ Remaining General Fund: Police Department Personnel Services $ 325,048 Supplies & Services $ 101,963 Capital Outlay $ 16,784 $ 443,796 $ 3,047,240 $ 2,603,444 Warning Sirens Personnel Services $ - Supplies & Services $ Capital Outlay $ $ - $ 2,000 $ 2,000 Westcom Dispatch Personnel Services $ - Supplies & Services $ 1,733 Capital Outlay $ - $ 1,733 $ 490,000 $ 488,267 Fire Department Personnel Services $ 136,513 Supplies & Services $ 38,291 Capital Outlay $ - $ 174,804 $ 1,227,170 $ 1,052,366 EMS Personnel Services $ 119,209 Supplies & Services $ 24,850 Capital Outlay $ - $ 144,059 $ 995,460 $ 851,401 Building Inspection Personnel Services $ 42,753 Supplies & Services $ 4,130 Capital Outlay $ - $ 46,883 $ 383,030 $ 336,147 Animal Control Personnel Services Supplies & Services $ 540 Capital Outlay $ 540 $ 11,000 $ 10,460 Library Services Personnel Services $ 84,039 Supplies & Services $ 51,569 Capital Outlay $ 1,004 $ 136,612 $ 942,105 $ 805,493 Mosquito Control Personnel Services $ - Supplies & Services $ Capital Outlay $ - $ - $ 7,500 $ 7,500 Parks Personnel Services $ 39,736 Supplies & Services $ 22,468 Capital Outlay $ 28,270 $ 90,474 $ 539,997 $ 449,523 Recreation Personnel Services $ 62,109 Supplies & Services $ 23,390 Capital Outlay $ - $ 85,499 $ 576,495 $ 490,996 Community Center Personnel Services $ 439 Supplies & Services $ 3,639 Capital Outlay $ - $ 4,078 $ 27,590 $ 23,512 Public Works Personnel Services $ 58,456 Supplies & Services $ 5,965 Capital Outlay $ - $ 64,420 $ 65,091 $ 671 Public Works Building Personnel Services $ Supplies & Services $ 35,367 Capital Outlay $ - Public Works Mechanic Personnel Services $ 24,403 Supplies & Services $ 15,660 Capital Outlay $ - Median and Bldg Grounds Personnel Services Supplies & Services $ 3,052 Capital Outlay Mayor & Council Personnel Services $ 5,902 Supplies & Services $ 9,602 Capital Outlay $ - Elections Personnel Services $ - Supplies & Services $ Capital Outlay $ - Communications Personnel Services $ 8,346 Supplies & Services $ 3,688 Capital Outlay $ - Administration Personnel Services $ 43,281 Supplies & Services $ 41,346 Capital Outlay $ 105 City Hall Personnel Services $ - Supplies & Services $ 14,424 Capital Outlay $ - Human Resources Personnel Services $ 22,732 Supplies & Services $ 12,904 Capital Outlay $ - Financial Administration Personnel Services $ 44,175 Supplies & Services $ 2,832 Capital Outlay $ - Other Financing $ - Community Development Personnel Services $ 24,974 Supplies & Services $ 28,250 Capital Outlay $ - City Attorney Personnel Services $ - Supplies & Services $ 16,280 Capital Outlay $ - Development Services Personnel Services $ 46,070 Supplies & Services $ 7,089 Capital Outlay $ - Information Technology Personnel Services $ 16,137 Supplies & Services $ 1,678 Capital Outlay $ - Engineering Personnel Services $ 63,732 Supplies & Services $ 7,112 35,367 $ - $ (35,367) 40,062 $ 193,950 $ 153,888 3,052 $ 14,000 $ 10,948 15,504 $ 72,840 $ 57,336 $ 18,000 $ 18,000 12,034 $ 109,585 $ 97,551 84,731 $ 384,580 $ 299,849 14,424 $ 94,300 $ 79,876 35,636 $ 93,080 $ 57,444 47,007 $ 205,350 $ 158,343 53,224 $ 335,940 $ 282,716 16,280 $ 100,000 $ 83,720 53,159 $ 483,535 $ 430,376 17,814 $ 199,253 $ 181,439 Capital Outlay GIS Personnel Services Supplies & Services Capital Outlay Transfers to GO Debt Service Total General Fund: Personnel Services Supplies & Services Capital Outlay Other $ 17,635 $ 1,640 1,185,688 479,461 46,162.11 av 70,844 $ 642,576 $ 571,732 19,275 $ 37,525 $ 18,250 $ 1,711,311 $11,299,192 $ 9,587,881 $ 1,711,311 Expense Approval Register City of Waukee, IA ,ilwwii�j \kt&&ee �cket: APPKT00734 - SEPT 6TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount BANKERS TRUST COMPANY INV0003530 09/06/2017 SEPTEMBER'17 SINKING FU 110-1080100 569,650.00 BANKERS TRUST COMPANY INV0003530 09/06/2017 SEPTEMBER'17 SINKING FU 510-1080100 26,450.00 BANKERS TRUST COMPANY INV0003530 09/06/2017 SEPTEMBER'17 SINKING FU 520-1080100 16,350.00 BANKERS TRUST COMPANY INV0003530 09/06/2017 SEPTEMBER'17 SINKING FU 540-1080100 34,650.00 647,100.00 Department: 1100 - POLICE OPERATIONS MID AMERICAN ENERGY 000010817 08/17/2017 AUGUST'17 STATEMENT 010-10.1100.480000 1,023.26 SIRCHIE FINGER PRINT LAB 0312201-IN 08/08/2017 FINGERPRINTING STATION 010-10.1100.540000 344.47 KIESLER'S POLICE SUPPLY, IN 0834469 07/27/2017 WEAPON LIGHT 010-10.1100.540000 223.00 KIESLER'S POLICE SUPPLY, IN 0835455 08/18/2017 HOLSTER- SANCHEZ 010-10.1100.540000 116.90 AMAZON.COM LLC 114-1578234-3104247 08/11/2017 MONITORS 010-10.1100.540000 179.69 AMAZON.COM LLC 114-4030811-9732259 08/09/2017 NETWORK SERVER CABINET 010-10.1100.540000 80.19 AMAZON.COM LLC 114-7496968-6966625 08/07/2017 CABLES/HDMI/ADAPTER/PR 010-10.1100.540000 751.07 AMAZON.COM LLC 114-7995484-7766658 08/07/2017 LOW VOLTAGE MOUNTING 010-10.1100.540000 14.99 ORKIN PEST CONTROL 1600060374 08/21/2017 PEST CONTROL-P.D. 010-10.1100.400000 105.28 ULTRAMAX 164970 07/18/2017 RIFLE AMMUNITION 010-10.1100.470010 7,560.00 ULTRAMAX 165241 07/18/2017 AMMUNITION 010-10.1100.470010 2,760.00 STIVERS FORD 192187C 08/21/2017 VEHICLE REPAIRS 010-10.1100.410000 40.50 STIVERS FORD 192530 08/24/2017 ALIGNMENT 010-10.1100.410000 79.95 AMAZON.COM LLC 1D6P-KGN9-49DX 08/17/2017 ITCABELING ACCESSORIES 010-10.1100.540000 61.00 AMAZON.COM LLC 1FNT-H61Y-39JJ 09/16/2017 CABLE/WIRING SUPPLIES 010-10,1100.540000 10.70 AMAZON.COM LLC 1WNX-TGRW-6Y39 08/22/2017 WIRING/CABLING 010-10.1100.540000 170.99 AMAZON.COM LLC 1WNX-TGRW-CGNF 08/22/2017 CABLING/NETWORK ACCESS 010-10.1100.540000 51.92 AMAZON.COM LLC 1WNX-TGRW-093N 08/22/2017 CABLING/NETWORK ACCESS 010-10.1100.540000 49.98 AMAZON.COM LLC 1XDF-VQ4H-6LGN 08/15/2017 7 PORT USB DATA HUB WITH 010-10.1100.540000 30.99 ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PRINTER LEASE 010-10.1100.270110 1,059.39 REVEAL MEDIA USA INC 264 08/16/2017 BODY CAMERA REPLACEME 010-10.1100.540000 795.00 TRIPLETT OFFICE ESSENTIAL 304187-0 08/07/2017 DESK 010-10.1100.540000 943.00 TRIPLETT OFFICE ESSENTIAL 306941-0 08/22/2017 PANELS 010-10.1100.540000 603.76 TRIPLETT OFFICE ESSENTIAL 307973-0 08/23/2017 PANELS 010-10.1100.540000 52.50 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-10.1100.100000 1,969.99 WEBSTER ELECTRIC 34348 08/16/2017 ADD OUTLET IN JAIL 010-10.1100.400000 225.00 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-10.1100.100000 1,045.82 FASTSIGNS 42-95383 08/21/2017 OFFICESIGNAGE 010-10.1100.540000 40.28 CARPENTER UNIFORM CO 446673 08/11/2017 VEST-SANCHEZ 010-10.1100.120000 699.00 CARPENTER UNIFORM CO 446903 08/15/2017 POUCH/BELT-KERB 010-10.1100.120000 109.97 CARPENTER UNIFORM CO 447080 08/17/2017 BADGE- MAPES 010-10.1100.120000 141.50 CARPENTER UNIFORM CO 447392 08/22/2017 POLOS - GUESS 010-10.1100.120000 98.28 CARPENTER UNIFORM CO 447473 08/23/2017 BOOTS- MAPES 010-10.1100.120000 84.99 MIDWEST STORAGE SOLUTI 6162 08/15/2017 GEARSTORAGE 010-10.1100.540000 3,210.96 NATIONWIDE OFFICE CLEAN 64443 08/09/2017 GARBAGE BAGS/PAPER TOW 010-10.1100.590000 172.33 NATIONWIDE OFFICE CLEAN 64847 08/15/2017 AUGUST'17 CLEANING SERV 010-10.1100.400100 554.24 NATIONWIDE OFFICE CLEAN 64900 08/07/2017 WINDOW CLEANING -POLIC 010-10.1100.400100 360.00 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-10.1100.100000 369.65 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-10.1100.100100 429.58 ADECCO EMPLOYMENT SER 68675876 08/14/2017 CONCTRACT LABOR - RHEA 010-10.1100.230000 340.69 J&MLOCK&KEY SERVICE 7955 08/15/2017 REPAIR JAIL LOCK 010-10,1100.400000 35.00 OFFICE DEPOT 946605213001 07/21/2017 POSTERBOARD 010-10.1100.580000 9.54 OFFICE DEPOT 946605520001 07/25/2017 WIPES/FRAME/PAPER 010-10.1100.580000 20.95 OFFICE DEPOT 946605520001 07/25/2017 WIPES/FRAME/PAPER 010-10.1100.590000 53.84 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-10.1100.450000 955.14 VERIZON WIRELESS 9790958377 08/13/2017 AUGUST'17 STATEMENT 010-10.1100.450000 22.75 CONSOLIDATED COMMUNIC INV0003546 08/08/2017 AUGUST'17 STATEMENT 010-10.1100.450000 347.13 HY-VEE INV0003549 08/10/2017 AUGUST'17 STATEMENT 010-10.1100.570000 3,976.91 8/30/2017 4:08:34 PM Page 1 of 17 Expense Approval Register Packet: APPKT00734 - SEPT 6TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount WAUKEE HARDWARE&VARI INV0003555 07/31/2017 JULY'17 STATEMENT 010-10.1100.400000 30.55 WAUKEE HARDWARE &VAR[ INV0003555 07/31/2017 JULY'17 STATEMENT 010-10.1100.460200 134.50 WAUKEE HARDWARE & VARI INV0003555 07/31/2017 JULY'17 STATEMENT 010-10.1100.470000 3.49 WAUKEE HARDWARE & VARI INV0003555 07/31/2017 JULY'17 STATEMENT 010-10.1100.540000 17.98 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-10.1100.270100 436.11 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-10.1100.110000 1,870.98 EVERBRIDGE, INC. M34040 07/13/2017 NIXLE ENGAGE 010-10.1100.280000 2,121.80 Department 1100 - POLICE OPERATIONS Total: 36,997.48 Department: 1400 - FIRE PROTECTION MID AMERICAN ENERGY 000010817 08/17/2017 AUGUST'17 STATEMENT 010-10.1400.480000 678.21 ED M FELD EQUIPMENT CO 0316083-IN 08/15/2017 FACE PIECE REPAIR 010-10.1400.410100 144.86 ED M FELD EQUIPMENT CO 0316215-IN 08/17/2017 FIRE HOSE REPAIR 010-10.1400.410100 53.50 FIRE SAFETY USA, INC. 102766 08/16/2017 LIGHT POLE REPAIR 010-10.1400.410000 65.00 GILCREST/JEWETT LUMBER 11278738 08/18/2017 PLYWOOD 010-10.1400.590000 27.78 KELTEK INCORPORATED 17845 08/22/2017 AMBULANCE COMPUTER AN 327-90.1400.710310 290.09 ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PRINTER LEASE 010-10.1400.270110 117.71 DELTA DENTAL 33075000200201709 09/O1/2017 SEP'17 DENTAL INSURANCE 010-10.1400.100000 543.97 ADELAUTO PARTS 362254 08/04/2017 AIR/OIL FILTERS AND SPARK 010-10.1400.410100 104.94 ADEL AUTO PARTS 363328 08/24/2017 BATTERY 010-10.1400.410000 689.16 ADEL AUTO PARTS 363329 08/24/2017 FLAPS 010-10.1400.410000 27.16 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-10.1400.100000 213.71 IOWA SIGN COMPANY 4980 08/08/2017 STRIPING REPAIR 010-10.1400.410000 90.50 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-10.1400.100000 155.70 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-10.1400.100100 106.62 SHERWIN WILLIAMS CO 8286-0 08/18/2017 NSG PRGRD PP 32-GRT 010-10.1400.590000 6.40 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-10.1400.450000 172.59 CAPITAL SANITARY SUPPLY C239080A 08/16/2017 10" FLO-THRU BRUSH 010-10.1400.590000 26.04 CAPITAL SANITARY SUPPLY C239080A O8/16/2017 10"FLO-THRU BRUSH 010-10.1400.590000 26.04 MUNICIPAL EMERGENCY SER IN1154600 08/15/2017 NEW HIRE HELMET FRONTS 010-10.1400.540000 341.25 WAUKEE HARDWARE & VARI INV0003512 07/31/2017 JULY'17 STATEMENT 010-10.1400.590000 76.31 HEARTLAND CO-OP INV0003513 07/31/2017 JULY'17STATEMENT -FIRE 010-10.1400.590000 16.04 FIRE ENGINEERING INVO003534 09/06/2017 SUBSCRIPTION-ROBINSON 010-10.1400.280000 19.50 IOWA ASSOCIATION OF PRO INV0003540 09/06/2017 IAPFC'17 FALL CONFERENCE 010-10.1400.470000 10.00 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-10.1400.270100 164.08 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-10.1400.110000 4,975.34 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-10.1400.110000 4,836.69 Department 1400 - FIRE PROTECTION Total: 13,979.19 Department: 1500 - EMS MID AMERICAN ENERGY 000010817 08/17/2017 AUGUST'17 STATEMENT 010-10.1500.480000 678.21 GILCREST/JEWETT LUMBER 11278738 08/18/2017 PLYWOOD 010-10.1500.590000 27.78 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-10.1500.100000 543.96 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-10.1500.100000 213.70 IOWA SIGN COMPANY 4980 08/08/2017 STRIPING REPAIR 010-10.1500.410000 90.50 MUTUALOF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-10.1500.100000 13.00 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-10.1500.100100 48.12 BOUND TREE MEDICAL 82585437 08/07/2017 MEDICALSUPPLIES 010-10.1500.540000 54.03 BOUND TREE MEDICAL 82585437 08/07/2017 MEDICAL SUPPLIES 010-10.1500.590050 279.54 BOUND TREE MEDICAL 82587134 08/08/2017 MEDICAL SUPPLIES 010-10.1500.590050 28.95 BOUND TREE MEDICAL 82590162 08/10/2017 MEDICAL SUPPLIES 010-10.1500.590050 166.08 BOUND TREE MEDICAL 82591436 08/13/2017 RESTRAINTSTRAP 010-10.1500.540000 133.99 BOUND TREE MEDICAL 82592873 08/14/2017 MEDICAL SUPPLIES 010-10.1500.590050 54.07 SHERWIN WILLIAMS CO 8286-0 08/18/2017 NSG PRGRD PP 32-GRT 010-10.1500.590000 6.39 STIVERS FORD 850613 08/21/2017 DOME LIGHT BULBS 010-10.1500.410000 7.50 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-10.1500.450000 172.59 MERCY COLLEGE OF HEALTH INV0003533 08/23/2017 NEO-NATAL EMERGENCY CA 010-10.1500.590050 10.00 FIRE ENGINEERING INV0003534 09/06/2017 SUBSCRIPTION-ROBINSON 010-10.1500.280000 19.50 JEANNE FORSTER INV0003536 09/06/2017 REFUND INCIDENT 161335 010-10.1500.3529900 100.00 CARROL HARRIS INV0003537 09/06/2017 REFUND INCIDENT 17244230 010-10.1500.3529900 77.62 LORI HOPKINS INV0003538 09/06/2017 REFUND INCIDENT 16000119 010-10.1500.3529900 92.00 COVENTRY HEALTHCARE OF INV0003539 09/06/2017 REFUND INCIDENT 17143673 010-10.1500.3529900 143.52 8/30/2017 4:08:34 PM Page 2 of 17 Expense Approval Register Packet: APPKT00734 -SEPT 6TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount IOWA ASSOCIATION OF PRO INVO003540 09/06/2017 IAPFC'17 FALL CONFERENCE 010-10.1500.470000 10.00 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-10.1500.270100 135.87 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-10.1500.110000 11.42 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-10.1500.110000 4,836.69 Department 1500 - EMS Total: 7,955.03. Department: 1600 - STREET LIGHTING IOWASIGNALINC 3633 08/15/2017 LED LIGHT FIXTURES 060-30.1600.410300 2,743.32 MID AMERICAN ENERGY AUG171600SUMBILL 08/23/2017 AUGUST'17 STATEMENT 060-30.1600.480000 17,364.82 Department 1600 - STREET LIGHTING Total: 20,108.14 Department: 1601- TRAFFIC SIGNALS MID AMERICAN ENERGY AUG171601SUMBILL 08/23/2017 AUGUST'17 STATEMENT 060-30.1601A80000 520.79 Department 1601- TRAFFIC SIGNALS Total: 520.79 Department: 1900 - BUILDING INSPECTION ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PRINTER LEASE 010-10.1900.270110 117.71 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-10.1900.100000 311.86 HOLMES MURPHY 423415 09/O1/2017 SEP'17 HMA MONTHLY CON 010-10.1900.100000 127.32 MUTUALOF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-10.1900.100000 58.50 MUTUALOF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-10.1900.100100 95.09 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-10.1900.450000 313.76 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-10.1900.270100 62.80 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-10.1900.110000 144.53 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-10.1900.110000 4.65 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-10.1900.110000 9.36 Department 1900 - BUILDING INSPECTION Total: 1,245.58 Department: 2130 - ALICES ROAD PROJECT FOTH INFRASTRUCTURE & E 53471 08/08/2017 SE ALICES/SE UNIV/SE OLSO 327-90.2130.840490 5,842.89 FOTH INFRASTRUCTURE & E 53473 08/08/2017 SE ALICES RD/SE OLSON DR/ 327-90.2130.840491 46,091.80 Department 2130 - ALICES ROAD PROJECT Total: 51,934.69 Department: 2131- ESKER RIDGE - RISE PROJECT FOTH INFRASTRUCTURE & E 53472 08/08/2017 SE ESKER RIDGE DRIVE RISE 327-90.2131.230051 972.87 Department 2131- ESKER RIDGE - RISE PROJECT Total: 972.87 Department: 3100 - LIBRARY SERVICES AMAZON.COM LLC 1FNT-H61Y-3H9R 08/16/2017 BATTERY BACKUP 010-40.3100.540000 190.21 ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PRINTER LEASE 010-40.3100.270110 235.42 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-40.3100.100000 508.51 HOLMES MURPHY 423415 09/O1/2017 SEP'17 HMA MONTHLY CON 010-40.3100.100000 263.73 MERRITT COMPANY INC 51118 08/22/2017 AUGUST'17 CLEANING - LIB 010-40.3100.400100 610.00 MID AMERICAN ENERGY 520160817 08/17/2017 AUGUST'17 STATEMENT 010-40.3100.480000 4,864.99 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-40.3100.100000 68.60 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-40.3100.100100 61.51 CINTAS CORPORATION 762541900 08/18/2017 MAT SERVICES - LIBRARY 010-40.3100.400000 38.51 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-40.3100.450000 52.08 INGRAM LIBRARY SERVICES 99612268 08/04/2017 BOOKS 010-40.3100.590000 2.38 INGRAM LIBRARY SERVICES 99612268 08/04/2017 BOOKS 010-40.3100.640000 31.62 INGRAM LIBRARY SERVICES 99627316 08/06/2017 BOOKS 010-40.3100.590000 8.54 INGRAM LIBRARY SERVICES 99627316 08/06/2017 BOOKS 010-40.3100.640000 43.92 INGRAM LIBRARY SERVICES 99693229 08/09/2017 BOOKS 010-40.3100.640000 5.74 INGRAM LIBRARY SERVICES 99715217 08/10/2017 BOOKS 010-40.3100.590000 6.14 INGRAM LIBRARY SERVICES 99715217 08/10/2017 BOOKS 010-40.3100.640000 32.88 INGRAM LIBRARY SERVICES 99715218 08/10/2017 BOOKS 010-40.3100.590000 8.99 INGRAM LIBRARY SERVICES 99715218 08/10/2017 BOOKS 010-40.3100.640000 36.14 INGRAM LIBRARY SERVICES 99747054 08/13/2017 BOOKS 010-40.3100.590000 191.56 INGRAM LIBRARY SERVICES 99747054 08/13/2017 BOOKS 010-40.3100.640000 833.04 INGRAM LIBRARY SERVICES 99747055 08/13/2017 BOOKS 010-40.3100.590000 5.16 INGRAM LIBRARY SERVICES 99747055 08/13/2017 BOOKS 010-40.3100.640000 66.14 INGRAM LIBRARY SERVICES 99789252 08/15/2017 BOOKS 010-40.3100.590000 49.61 INGRAM LIBRARY SERVICES 99789252 08/15/2017 BOOKS 010-40.3100.640000 310.86 INGRAM LIBRARY SERVICES 99789253 08/15/2017 BOOKS 010-40.3100.590000 1.19 8/30/2017 4:08:34 PM Page 3 of 17 Expense Approval Register Packet: APPKT00734 -SEPT 6TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount INGRAM LIBRARY SERVICES 99789253 08/15/2017 BOOKS 010-40.3100.640000 9.77 INGRAM LIBRARY SERVICES 99815647 08/16/2017 BOOKS 010-40.3100.590000 117.13 INGRAM LIBRARY SERVICES 99815647 08/16/2017 BOOKS 010-40.3100.640000 752.26 INGRAM LIBRARY SERVICES 99825234 08/17/2017 BOOKS 010-40.3100.640000 143.70 INGRAM LIBRARY SERVICES 99838652 08/17/2017 BOOKS 010-40.3100.590000 15.48 INGRAM LIBRARY SERVICES 99838652 08/17/2017 BOOKS 010-40.3100.640000 103.95 INGRAM LIBRARY SERVICES 99838653 08/17/2017 BOOKS 010-40.3100.590000 0.25 INGRAM LIBRARY SERVICES 99838653 08/17/2017 BOOKS 010-40.3100.640000 22.49 BIRDS & BLOOMS INV0003552 09/06/2017 SUBSCRIPTION 010-40.3100.640000 7.50 US WEEKLY INV0003554 09/06/2017 SUBSCRIPTION 010-40.3100.640000 19.98 MAD MAGAZINE INV0003558 09/06/2017 SUBSCRIPTION 010-40.3100.640000 19.99 GARDEN GATE INV0003559 09/06/2017 SUBSCRIPTION 010-40.3100.640000 27.00 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-40.3100.270100 161.33 IOWA MUNICIPALITIES WOR INV65814 09/O1/2017 SEPTEMBER'17 WORKERS C 010-40.3100,110000 39.22 DISCOUNT SCHOOL SUPPLY P36033890102 08/17/2017 GIANT BUILDING BRICKS/BE 010-40.3100.460300 104.57 Department 3100 - LIBRARY SERVICES Total: 10,072.09 Department: 4100 - PARKS FULLER PETROLEUM SERVIC 104084 08/07/2017 FUEL 010-40.4100.570000 187.31 CONFLUENCE 14442 07/31/2017 WAUKEE DOG PARK 327-90.4100.880070 5,475.00 STIVERS- VEHICLES 145383 08/22/2017 2017 FORD F-3501FTRF3B67 010-40.4100.710000 28,270.00 HOY TREE FARM 17081101 08/11/2017 YOUTH IN PARKS HEART OF 010-40.4100.410300 450.00 DOG WASTE DEPOT 171297 08/15/2017 DOG WASTE BAGS 010-40.4100.590000 119.97 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-40.4100.100000 123.78 DELTA DENTAL 33075000200201709 09/O1/2017 SEP'17 DENTAL INSURANCE 010-40.4100.100000 32.15 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-40.4100.100000 24.76 MULCH MART 41784 08/14/2017 PLAY MATCERTIFIED 010-40.4100.410300 372.00 MULCH MART 41819 08/15/2017 PLAY MATCERTIFIED 010-40.4100.410300 124.00 HOLMES MURPHY 423415 09/O1/2017 SEP'17 HMA MONTHLY CON 010-40.4100.100000 18.19 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-40.4100.100000 45.47 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-40.4100.100000 9.09 ROG PLANNING & DESIGN 42863 07/31/2017 ALICE NIZZI PARK MP 010-40.4100.230000 1,319.43 ELECTRICAL ENGINEERING E 5079567-00 05/26/2017 PARTS 010-40.4100.410300 198.56 HY-VEE 5800920643 07/10/2017 P.B. PARK TOUR SOAP/WATE 010-40.4100.470000 55.37 HY-VEE 5802329835 07/10/2017 SAFETY MEETING FOOD 010-40.4100.470000 54.37 HY-VEE 58030305680 07/18/2017 IAMU BUCKET TRUCK TRAINI 010-40.4100.470000 10.98 HY-VEE 58040889203 08/04/2017 JULY'17 PW SAFETY DAY 010-40.4100.470000 78.43 HILLYARD INC 602657866 08/17/2017 SOAP 010-40.4100.590000 63.28 VAN -WALL EQUIPMENT INC 644097 08/02/2017 NEW TIRE FOR MOWER 010-40.4100.410100 174.23 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-40.4100.100000 2.60 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-40.4100.100000 0.52 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-40.4100.100000 2.60 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-40.4100.100100 27.72 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-40.4100.100100 1.81 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-40.4100.100100 10.80 MENARDS 90379 08/14/2017 PRIMED MDF BOARD 010-40.4100.410300 9.55 MENARDS 90878 08/18/2017 LEVER/TAPE 010-40.4100.590000 42.57 VERIZON WIRELESS 9790958376 . 08/13/2017 AUGUST'17 STATEMENT 010-40.4100.450000 98.82 MID AMERICAN ENERGY AUG174100SUMBILL 08/23/2017 AUGUST'17 STATEMENT 010-40.4100.480000 237.67 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-40.4100.270100 113.70 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-40.4100.110000 246.88 Department 4100 - PARKS Total: 38,002.61 Department: 4200 - RECREATION KIDS IN HARMONY, LLC 0001728 08/05/2017 KIDS IN HARMONYJULY SESS 010-40.4200.460500 176.00 FAREWAY STORES, INC. 00365666 08/04/2017 AUGUSTSENIOR SOCIALSUP 010-40.4200.460500 60.20 ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PRINTER LEASE 010-40.4200.270110 117.71 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-40.4200.100000 279.71 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-40.4200.100000 109.13 HY-VEE 58026676581 07/12/2017 DALLAS COUNTY FAIR PIES 010-40.4200.460500 77.94 HY-VEE 58027823251 07/14/2017 SUPER SNACKERS SUPPLIES 010-40.4200.460500 170.55 HY-VEE 58036553700 07/25/2017 SUPER SNACKERS SUPPLIES 010-40.4200.460500 119.21 8/30/2017 4:08:34 PM Page 4 of 17 Expense Approval Register Packet: APPKT00734 - SEPT 6TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount HY-VEE 58040889203 08/04/2017 JULY'17 PW SAFETY DAY 010-40.4200.470000 78.43 MUTUALOF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-40.4200.100000 66.50 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-40.4200.100100 63.00 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-40.4200.450000 199.28 ACCESS SYSTEMS CW11167 08/18/2017 CONNECTING LAPTOP TO S 010-40.4200.270100 557.50 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-40.4200.270100 99.64 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-40.4200.110000 104.92 Department 4200 - RECREATION Total: 2,279.72 Department: 4300 - COMMUNITY CENTER ORKIN PEST CONTROL 160060382 08/21/2017 PEST CONTROL - COMMUNI 010-40.4300.400000 55.28 NATIONWIDE OFFICE CLEAN 64846 08/15/2017 AUGUST'17 CLEANING SERV 010-40.4300.400100 298.77 MENARDS 89855 08/09/2017 LED RECESS DISC 010-40.4300.400000 22.97 MEDIACOM INV0003553 08/07/2017 AUGUST'17 STATEMENT 010-40.4300.450000 88.23 Department 4300 - COMMUNITY CENTER Total: 465.25 Department: 5000 - BIKE TRAIL OLD RAILROAD TEAM SERVICES INC 1790178-0 07/28/2017 NORTH LOTH TRAILHEAD PA 327-90.5000.881130 110.00 Department 5000 - BIKE TRAIL OLD RAILROAD Total: 110.00 Department: 5300-STORM WATER AMAZON.COM LLC 114-1578234-3104247 08/11/2017 MONITORS 560-80.5300.540000 179.69 AMAZON.COM LLC 11HQ-7XCH-CIRF 08/22/2017 MONITOR 560-80.5300.540000 184.24 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 560-80.5300.100000 279.71 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 560-80.5300.100000 38.98 CHRISTIAN PRINTERS INC 38528 08/10/2017 BUSINESS CARDS- WEND] SP 560-80.5300.350100 31.00 HOLMES MURPHY 423048 08/14/2017 REFUND-'12 STREETSWEEP 560-80.5300.290100 -763.60 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 560-80.5300.100000 109.13 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 560-80.5300.100000 15.92 FOTH INFRASTRUCTURE & E 53467 08/08/2017 CENTENNIAL PARK STREAM 560-80.5300.880015 1,403.96 FOTH INFRASTRUCTURE & E 53537 08/09/2017 CENTENNIAL PARK STREAM 560-80.5300,880015 2,716.54 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 560-80.5300.100000 58.90 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 560-80.5300.100000 1.30 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 560-80.5300.100100 3.97 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 560-80.5300.100100 80.26 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 560-80.5300.450000 306.30 HOLMES MURPHY DM0000004 08/14/2017 DEBIT MEMO REFUND CHEC 560-80.5300.290100 188.89 HDSUPPLY WATERWORKS H625244 08/10/2017 PVCSWR PERF PIPE 560-80.5300.410300 141.38 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 560-80.5300.270100 144.11 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 560-80.5300.110000 154.92 Department 5300 - STORM WATER Total: 5,275.60 Department: 6000 - PUBLIC WORKS DELTA DENTAL 33075000200201709 09/01/2017 5EP'17 DENTAL INSURANCE 010-20.6000.100000 436.89 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-20.6000.100000 181.88 PROGRESSIVE BUSINESS PUB 5093780 07/01/2017 QUALITY MANAGERS ALERT 010-20.6000.280000 299.00 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-20.6000.100000 258.50 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-20.6000.100100 115.35 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-20.6000.450000 210.14 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-20.6000.270100 12.76 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-20.6000.110000 10.56 IOWA MUNICIPALITIES WOR INV65814 09/O1/2017 SEPTEMBER'17 WORKERS C 010-20.6000.110000 153.80 Department 6000 - PUBLIC WORKS Total: 1,678.88 Department: 6010 - PUBLIC WORKS BUILDING ELECTRIC PUMP & TOOL INC 0875130-IN O8/10/2017 REPAIRS TO FLUSH VALVE 010-20.6010.400000 55.00 ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PAINTER LEASE 010-20.6010.270110 588.55 MID AMERICAN ENERGY 240000817 08/17/2017 AUGUST'17 STATEMENT 010-20.6010.480000 2,136.48 INGERSOLL RAND 30619661 08/08/2017 AIRCARE ADVANTAGE 010-20.6010.400000 617.14 SUPPLYWORKS 408530319 08/02/2017 WIPER POP UP 010-20.6010.590000 114.96 SUPPLYWORKS 408840452 08/04/2017 WIPER POP UP 010-20.6010.590000 114.96 SUPPLYWORKS 409303476 08/09/2017 BATH TISSUES/LINERS/PAPS 010-20.6010.590000 349.98 PLUMB SUPPLY COMPANY 4702259 08/09/2017 SINK 010-20.6010.400000 523.80 TECH 24-COMMERCIAL FO 4933562 08/04/2017 CLEAN AND SANITIZED ICE M 010-20.6010.400000 369.00 8/30/2017 4:08:34 PM Page 5 of 17 Expense Approval Register Packet: APPKT00734 - SEPT 6TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount CINTAS CORPORATION 5008496581 08/15/2017 FIRST AID KIT SUPPLIES 010-20.6010.590000 175.92 ELECTRICAL ENGINEERING E 5106981-00 06/22/2017 RETURN 010-20.6010.400000 -325.72 HILLYARD INC 602632842 07/31/2017 TOILET PAPER/PAPERTOWE 010-20.6010.590000 254.66 NATIONWIDE OFFICE CLEAN 64657 08/15/2017 AUGUST'17 CLEANING SERV 010-20,6010.400100 1,247.04 METRO WASTE AUTHORITY 8237 08/16/2017 ELECTRONIC WASTE 010-20.6010.510100 21.50 Department 6010 - PUBLIC WORKS BUILDING Total: 6,243.27 Department: 6150 - PUBLIC WORKS MECHANIC NORTHERN TOOL &EQUIPM 0791020373 09/08/2017 ROTARY TOOL KIT 010-20.6150.590000 59.99 NORTHERN TOOL &EQUIPM 0792077429CM 06/22/2017 RETURN RATCHETING WIRE 010-20.6150.570130 -9.12 NORTHERN TOOL &EQUIPM 0792080242CM 05/08/2017 PRICE MATCH CREDIT MEM 010-20.6150.570130 -2.76 NORTHERN TOOL &EQUIPM 0793042623 08/21/2017 A -FRAME TOPWIND/ROUND 010-20.6150.570130 59.98 ELECTRONIC ENGINEERING C 117000238-1 08/18/2017 INSTALL RADIO 010-20.6150.570130 1,231.49 CAPITAL CITY EQUIPMENT C 1236K 08/14/2017 0RING 010-20.6150.570130 6.18 TRUCK EQUIPMENT INC 282100 08/16/2017 LED STROBE MINI BAR 010-20.6150.570130 529.36 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-20.6150.100000 155.93 ADEL AUTO PARTS 362793 08/15/2017 OIL FILTERS 010-20.6150.570110 5.79 ADEL AUTO PARTS 362800 08/15/2017 BATTERY 010-20.6150.570130 72.45 ADEL AUTO PARTS 362991 08/17/2017 FUEL PUMP 010-20.6150.570130 244.77 ADEL AUTO PARTS 363261 08/23/2017 OIL FILTER 010-20.6150.570110 13.11 SHOTTENKIRK CHEVROLET-P 39746 08/21/2017 STRAP 010-20.6150.570130 43.66 HOLMES MURPHY 423415 09/01/2017 SEP'17 PIMA MONTHLY CON 010-20.6150.100000 63.66 CLIVE POWER EQUIPMENT 608541 08/14/2017 CARBURETOR 010-20.6150.570130 46.19 VAN -WALL EQUIPMENT INC 657034 08/23/2017 PARTS 010-20.6150.570130 10.74 VAN -WALL EQUIPMENT INC 657035 08/23/2017 PARTS 010-20.6150.570130 94.02 MUTUALOF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-20.6150.100000 5.20 MUTUALOF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-20.6150.100100 116.61 MIDWEST WHEEL COMPANI 90221400 08/16/2017 WHEELS 010-20.6150.570130 202.92 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-20.6150.450000 69.94 EH WACHS COMPANY INV138209 08/04/2017 HYDRAULIC COOLER 010-20.6150.570130 1,591.00 IOWA MUNICIPALITIES WOR INV65814 09/O1/2017 SEPTEMBER'17 WORKERS C 010-20.6150.110000 136.26 Department 6150 - PUBLIC WORKS MECHANIC Total: 4,747.37 Department: 6510 - WATER UTILITY MUNICIPAL SUPPLY, INC. 0666359-IN O8/11/2017 METERS 510-30.6510.592000 3,021.30 MUNICIPAL SUPPLY, INC. 0666779-IN O8/15/2017 METER 510-30.6510.592000 22,272.00 FULLER PETROLEUM SERVIC 104084 08/07/2017 FUEL 510-30.6510.570000 187.31 MID AMERICAN ENERGY 110090817 08/15/2017 AUGUST'17 STATEMENT 510-30.6510.480000 21.06 IOWA ONE CALL 193539 08/09/2017 JULY'17 STATEMENT 510-30.6510.340000 347.05 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 510-30.6510.100000 61.89 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 510-30.6510.100000 126.82 DELTA DENTAL 33075000200201709 09/O1/2017 SEP'17 DENTAL INSURANCE 510-30.6510.100000 38.98 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 510-30.6510.100000 65.55 SHERWIN WILLIAMS CO 3731-9 08/03/2017 PAINT 510-30.6510.410500 92.58 HOLMES MURPHY 423415 09/O1/2017 SEP'17 HMA MONTHLY CON 510-30.6510.100000 63.66 HOLMES MURPHY 423415 09/O1/2017 SEP'17 HMA MONTHLY CON 510-30.6510.100000 45.47 HOLMES MURPHY 423415 09/O1/2017 SEP'17 HMA MONTHLY CON 510-30.6510.100000 15.92 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 510-30.6510.100000 22.73 HY-VEE 5802329835 07/10/2017 SAFETY MEETING FOOD 510-30.6510.470000 54.37 HY-VEE 58030305680 07/18/2017 IAMU BUCKET TRUCK TRAINI 510-30.6510.470000 10.99 HY-VEE 58040889203 08/04/2017 JULY'17 PW SAFETY DAY 510-30.6510.470000 78.43 MUTUALOF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 510-30.6510.100000 2.60 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 510-30.6510.100000 1.30 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 510-30.6510.100000 19.40 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 510-30.6510.100000 26.50 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 510-30.6510.100100 77.55 MUTUALOF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 510-30.6510.100100 53.89 MUTUALOF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 510-30.6510.100100 58.24 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 510-30.6510.100100 3.86 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 510-30.6510.450000 438.14 MID AMERICAN ENERGY AUG176510SUMBILL 08/23/2017 AUGUST'17 STATEMENT 510-30.6510.480000 672.92 WEST DES MOINES WATER INV0003231A 07/11/2017 JULY&JUNE'17WATERTO 510-30.6510.390300 109.34 8/30/2017 4:08:34 PM Page 6 of 17 Expense Approval Register Packet: APPKT00734 - SEPT 6TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount WEST DES MOINES WATER INV0003361A 08/08/2017 AUGUST'17 WATER TOWER 510-30.6510.390300 54.68 WEST DES MOINES WATER INV0003531 09/06/2017 SEPTEMBER'17 WATER TOW 510-30.6510.390300 419.18 DES MOINES WATER WORKS INV0003532 08/22/2017 2ND QRTR'17 WSS 0&M 510-30.6510.650010 18,695.87 DES MOINES WATER WORKS INV0003547 08/10/2017 LAB ANALYSIS 510-30.6510.250000 15.00 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 510-30.6510.270100 770.41 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 510-30.6510.110000 562.50 IOWA MUNICIPALITIES WOR INV65814 09/O1/2017 SEPTEMBER'17 WORKERS C 510-30.6510.110000 104.93 Department 6510 - WATER UTILITY Total: 48,622.42 Department: 6520 - SANITARY SEWERS & TREATMENT FULLER PETROLEUM SERVIC 104084 08/07/2017 FUEL 520-30.6520.570000 187.30 WASTEWATER RECLAMATIO 23402A 09/01/2017 SEPTEMBER'17 FEES 520-30.6520.882700 112,440.00 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 520-30.6520.100000 126.82 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 520-30.6520.100000 131.10 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 520-30,6520.100000 61.89 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 520-30.6520.100000 38.98 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 520-30.6520.100000 15.92 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 520-30.6520.100000 63.66 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 520-30.6520.100000 90.94 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 520-30.6520.100000 22.73 ELECTRICAL ENGINEERING E 5147644-0 08/03/2017 LIFTSTATION REPAIR PARTS/ 520-30.6520.411100 968.40 HY-VEE 5802329835 07/10/2017 SAFETY MEETING FOOD 520-30.6520.470000 54.37 HY-VEE 58030305680 07/18/2017 IAMU BUCKETTRUCK TRAIN[ 520-30.6520.470000 10.99 HY-VEE 58040889203 08/04/2017 JULY'17 PW SAFETY DAY 520-30.6520.470000 78.43 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 520-30.6520.100000 5.20 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 520-30.6520.100000 1.30 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 520-30.6520.100000 1.30 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 520-30.6520.100000 6.50 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 520-30.6520.100100 3.97 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 520-30.6520.100100 76.78 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 520-30.6520.100100 3.86 MUTUALOF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 520-30.6520.100100 18.61 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 520-30.6520.450000 273.53 MID AMERICAN ENERGY AUG176520SUMBILL 08/23/2017 AUGUST'17 STATEMENT 520-30.6520.480000 10,054.55 CENTURYLINK INV0003544 08/10/2017 AUGUST'17 STATEMENT 520-30.6520.450000 48.28 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 520-30.6520.270100 633.54 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 520-30.6520.110000 127.60 IOWA MUNICIPALITIES WOR INV65814 09/O1/2017 SEPTEMBER'17 WORKERS C 520-30.6520.110000 104.93 Department 6520 - SANITARY SEWERS & TREATMENT Total: 125,651.48 Department: 6540-GAS UTILITY MARK STUCHEL INC. 08171751038 08/17/2017 SNAP RING PLIERS SET 540-30.6540.590000 198.00 FULLER PETROLEUM SERVIC 104084 08/07/2017 FUEL 540-30.6540.570000 187.30 MID AMERICAN ENERGY 110090817 08/15/2017 AUGUST'17 STATEMENT 540-30.6540.480000 21.05 IOWA ONE CALL 193539 08/09/2017 JULY'17 STATEMENT 540-30.6540.340000 347.05 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 540-30.6540.100000 38.98 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 540-30.6540.100000 61.89 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 540-30.6540.100000 444.99 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 540-30.6540.100000 22.73 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 540-30.6540.100000 181.88 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 540-30.6540.100000 15.92 HY-VEE 5802104043 07/10/2017 CANDY FOR 4TH OFJULY PA 540-30.6540.590000 59.90 HY-VEE 5802329835 07/10/2017 SAFETY MEETING FOOD 540-30.6540.470000 54.37 HY-VEE 58030305680 07/18/2017 IAMU BUCKET TRUCK TRAINI 540-30.6540.470000 10.99 HY-VEE 58040889203 08/04/2017 JULY'17 PW SAFETY DAY 540-30.6540.470000 78.43 MUTUALOF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 540-30.6540.100000 1.30 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 540-30.6540.100000 91.30 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 540-30.6540.100000 1.30 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 540-30.6540.100100 3.97 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 540-30.6540.100100 3.86 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 540-30.6540.100100 69.50 GRAINGER PARTS 9522453316 08/08/2017 GAUGE PRESSURE 540-30.6540.590000 141.40 8/30/2017 4:08:34 PM Page 7 of 17 Expense Approval Register Packet: APPKT00734 - SEPT 6TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 540-30.6540.450000 283.72 INDUSTRIAL SALES COMPAN 980564-000 08/08/2017 CRISC065001PS 540-30.6540.590100 11,009.60 INDUSTRIAL SALES COMPAN 988090-000 08/10/2017 NICOTAP/TAP TEE/POLY BAL 540-30.6540.590200 3,538.98 INDUSTRIAL SALES COMPAN 988100-000 08/10/2017 PARTS 540-30.6540.590100 225.01 MID AMERICAN ENERGY AUG176540SUMBILL 08/23/2017 AUGUST'17 STATEMENT 540-30.6540.480000 77.18 UTILITY SAFETY AND DESIGN IN20172819 07/31/2017 MUELLER TAPPING MACHIN 540-30.6540.410400 18,952.68 UTILITY SAFETY AND DESIGN IN20172847 07/31/2017 CP INVESTIGATION ON HP U 540-30.6540.230000 500.00 WEST DES MOINES WATER INV0003231A 07/11/2017 JULY &DUNE '17 WATERTO 540-30.6540.390300 109.36 WEST DES MOINES WATER INV0003361A 08/08/2017 AUGUST'17 WATER TOWER 540-30.6540.390300 54.67 WEST DES MOINES WATER INV0003531 09/06/2017 SEPTEMBER'17 WATER TOW 540-30.6540.390300 419.17 GARY KNIGHT INV0003535 09/06/2017 FURNACE REBATE 540-30.6540.685400 75.00 NICHOLAS RIZZI INV0003556 09/06/2017 FURNACE REBATE 540-30.6540.685400 150.00 RANDALTAETS INV0003557 09/06/2017 FURNACE REBATE 540-30.6540.685400 75.00 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 540-30.6540.270100 987.00 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 540-30,6540.110000 104.93 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 540-30.6540.110000 442.67 DITCH WITCH-IOWA INC 505955 08/15/2017 REPAIR TO HOUSINGS 540-30.6540.410600 552.73 Department 6540 - GAS UTILITY Total: 39,593.81 Department: 6550 - UTILITY BILLING ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PRINTER LEASE 570-30.6550.270110 117.71 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 570-30.6550.100000 97.70 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 570-30.6550.100000 63.66 MUTUALOF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 570-30.6550.100000 74.70 MUTUALOF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 570-30.6550.100100 15.78 PURCHASE POWER, INC. INV0003562 08/23/2017 PERMIT OVERAGE FEES 570-30.6550.360000 28.60 PURCHASE POWER, INC. INV0003562 08/23/2017 IULY'17 UTILITY BILLS 570-30.6550.360000 1,855.49 PURCHASE POWER, INC. INV0003562 08/23/2017 JULY'17 LATE NOTICES 570-30.6550.360000 342.92 PURCHASE POWER, INC. INV0003562 08/23/2017 JULY'17 ACH BILLS 570-30.6550.360000 907.81 PURCHASE POWER, INC. INV0003562 08/23/2017 FINANCE CHARGES 570-30.6550.360000 101.03 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 570-30.6550.270100 55.89 IOWA MUNICIPALITIES WOR INV65814 09/O1/2017 SEPTEMBER'17 WORKERS C 570-30.6550.110000 9.77 Department 6550 - UTILITY BILLING Total: 3,671.06 Department: 7100 -STREETS FULLER PETROLEUM SERVIC 104084 08/07/2017 FUEL 060-30.7100.570000 187.31 MARTIN MARIETTA AGGREG 21005936 08/07/2017 ROAD STONE 060-30.7100.590300 733.86 DALE EDWARDS TRUCKING 1 2961 08/12/2017 HAULING 060-30.7100.590300 269.10 DALE EDWARDS TRUCKING 1 2962 08/12/2017 HAULING 060-30.7100.590300 101.51 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 060-30.7100.100000 435.64 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 060-30.7100.100000 61.89 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 060-30.7100.100000 12.38 BAX SALES, INC 35655A O8/16/2017 SIGNS 060-30.7100.590600 108.06 IOWA SIGNAL INC 3629 08/08/2017 REPAIRS T04TH&HICKMAN 060-30.7100.410300 155.00 IOWASIGNALINC 3630 08/08/2017 FLASHING BEACONS 060-30.7100.410300 1,972.00 HOLMES MURPHY 423415 09/O1/2017 SEP'17 HMA MONTHLY CON 060-30.7100.100000 4.55 HOLMES MURPHY 423415 09/O1/2017 SEP'17 HMA MONTHLY CON 060-30.7100.100000 172.79 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 060-30.7100.100000 22.74 HY-VEE 5802329835 07/10/2017 SAFETY MEETING FOOD 060-30.7100.470000 54.37 HY-VEE 58040889203 08/04/2017 JULY'17 PW SAFETY DAY 060-30.7100.470000 78.43 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 060-30.7100.100000 50.40 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 060-30.7100.100000 0.26 MUTUALOF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 060-30.7100.100000 7.30 MUTUALOF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 060-30.7100.100100 0.90 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 060-30.7100.100100 17.34 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 060-30.7100.100100 147.35 BAILEY IRRIGATION INC 8881 08/28/2017 REPAIRS ON NE DARTMOOR 060-30.7100.340000 84.30 LIBERTY READY MIX 90613 08/08/2017 CONCRETE 060-30.7100.590400 890.50 LIBERTY READY MIX 90614 08/08/2017 CONCRETE 060-30.7100.590400 616.50 LIBERTY READY MIX 90701 08/09/2017 CONCRETE 060-30.7100.590300 685.00 LIBERTY READY MIX 90702 08/09/2017 CONCRETE 060-30.7100.590300 548.00 LIBERTY READY MIX 90786 08/10/2017 CONCRETE 060-30.7100.590400 1,370.00 8/30/2017 4:08:34 PM Page 8 of 17 Expense Approval Register Packet: APPKT00734 - SEPT 6TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (item) Account Number Amount VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 060-30.7100.450000 218.72 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 060-30.7100.590600 80.02 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 060-30.7100.270100 334.36 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 060-30.7100.110000 1,010.55 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 060-30.7100.110000 104.93 LOGAN CONTRACTORS SUPP M35256 08/09/2017 LIMESTONE 30OZ TUBE/CAU 060-30.7100.590000 189.10 LOGAN CONTRACTORS SUPP M35293 08/09/2017 LCS831 DIAMOND 060-30.7100.590000 605.00 Department 7100 -STREETS Total: 11,330.16 Department: 7730 - SE W ESTOWN PKWY CONSTRUCTION FOTH INFRASTRUCTURE & E 53468 08/08/2017 WESTOWN PKWY/SE PARKVI 327-90.7730.230000 1,981.45 Department 7730 - SE W ESTOW N PKWY CONSTRUCTION Total: 1,981.45 Department: 7850 -TIF DEBT SERVICE AHLERS & COONEY PC 732579 07/28/2017 WAUKEE WEST URP 096-30.7850,230000 3,964.50 Department 7850 - TIF DEBT SERVICE Total: 3,964.50 Department: 8100 - MAYOR & COUNCIL IOWA LEAGUE OF CITIES 075339 08/18/2017 MID -SIZED CITIES TIM M. & 010-60.8100.470000 11.63 HY-VEE 5804089330 08/04/2017 CITIZEN BOARD APPRECIATI 010-60.8100.470000 577.96 AMERICAN TELECONFERENC INV0003560 07/31/2017 JULY'17 STATEMENT 010-60.8100.450000 4.68 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-60.8100.110000 2.56 Department 8100 - MAYOR & COUNCIL Total: 596.83 Department: 8200 - COMMUNICATIONS DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-60.8200.100000 123.78 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-60.8200.100000 45.47 MUTUALOF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-60.8200.100000 7.80 MUTUALOF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-60.8200.100100 33.60 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-60.8200.110000 7.96 Department 8200 - COMMUNICATIONS Total: 218.62 Department: 8300 - ADMINISTRATION UNITED PARCEL SERVICE OOOOAW7647327 08/12/2017 SHIPPING 010-60.8300.360000 36.13 IOWA LEAGUE OF CITIES 075339 08/18/2017 MID -SIZED CITIES TIM M. & 010-60.8300.470000 11.63 LYLE SUMEKASSOCIATES IN 17-0411 08/19/2017 STRATEGIC PLANNING 010-60.8300.230000 5,346.00 LYLE SUMEK ASSOCIATES IN 17-0514 08/18/2017 STRATEGIC PLANNING 010-60.8300.230000 12,817.20 LYLE SUMEK ASSOCIATES IN 17-0515 08/18/2017 STRATEGIC PLANNING 010-60.8300.230000 2,500.00 ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PRINTER LEASE 010-60.8300.270110 117.71 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-60.8300.100000 189.33 HOLMES MURPHY 421885 08/03/2017 5 BEL AIRE INSURANCE 010-60.8300.290000 574.71 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-60.8300.100000 90.94 MID AMERICAN ENERGY 480550817 08/18/2017 28178 U AVE (FARMHOUSE 010-60.8300.390400 8.50 MID AMERICAN ENERGY 490530817 08/17/2017 AUGUST'17 STATEMENT 010-60.8300.390400 9.31 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-60.8300.100000 54.80 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-60.8300.100100 28.66 AHLERS & COONEY PC 734407 08/23/2017 LAND AQUISITION WITH SCH 010-60.8300.580000 28.50 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-60.8300.450000 52.08 TOTAL ADMINISTRATIVE SER IN1087862 08/17/2017 FLEX PLAN ADMIN 10/1/17- 010-60.8300.230000 1,277.82 MEDIACOM INV0003550 08/05/2017 AUGUST'17 STATEMENT 010-60.8300.270000 4.43 DES MOINES REGISTER INV0003551 09/06/2017 MON.- SAT. SUBSCRIPTION 010-60.8300.280000 25.00 AMERICAN TELECONFERENC INV0003560 07/31/2017 JULY'17 STATEMENT 010-60.8300.450000 2.31 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-60.8300.270100 2,260.34 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-60.8300.110000 24.05 Department 8300 - ADMINISTRATION Total: 2S,459.45 Department: 8310 - CITY HALL MID AMERICAN ENERGY 030890817 08/17/2017 AUGUST'17 STATEMENT 010-60.8310.390600 239.11 ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PRINTER LEASE 010-60.8310.270110 235.42 HY-VEE 5803425419 07/24/2017 CITY HALLSUPPLIES 010-60.8310.590000 3.34 HY-VEE 5803529629 07/26/2017 CITY HALL MEETING SUPPLIE 010-60.8310.590000 12.80 NATIONWIDE OFFICE CLEAN 64845 08/15/2017 AUGUST'17 CLEANING SERV 010-60.8310.400100 597.54 MID AMERICAN ENERGY AUG178310SUMBILL 08/23/2017 AUGUST'17 STATEMENT 010-60.8310.480000 692.05 Department 8310 - CITY HALL Total: 1,780.26 8/30/2017 4:08:34 PM Page 9 of 17 Expense Approval Register Packet: APPKT00734 - SEPT 6TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount Department: 8350 - HUMAN RESOURCES ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PRINTER LEASE 010-60.8350.270110 117.71 HY-VEE PHARMACY 255A 07/01/2017 FLU SHOTS 010-60.8350.689200 124.99 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-60.8350.100000 32.15 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-60.8350.100000 18.19 HY-VEE 5800822773 07/10/2017 WELLNESS SCREENING FOOD 010-60.8350.689200 172.24 HY-VEE 5800863788 07/10/2017 WELLNESS SCREEN CATERIN 010-60.8350.689200 34.00 HY-VEE 5802609293 07/11/2017 YEARS OF SERVICE GIFT CERT 010-60.8350.689000 185.00 HY-VEE 5802609847 07/11/2017 WATER - END OF YEAR CELE 010-60.8350.689200 23.92 HY-VEE 5802656469 07/12/2017 YEAR END CELEBRATION CO 010-60.8350.689200 108.72 MUTUALOF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-60.8350.100000 2.60 MUTUALOF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-60.8350.100100 74.24 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-60.8350.450000 101.14 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-60.8350.270100 12.02 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-60.8350.110000 9.00 Department 8350 - HUMAN RESOURCES Total: 1,015.92 Department: 8400 - FINANCIAL ADMINISTRATION ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PRINTER LEASE 010-60,8400,270110 353.14 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-60.8400.100000 221.48 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-60.8400.100000 109.13 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-60.8400.100000 13.80 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-60.8400.100100 66.90 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-60.8400.450000 92.09 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-60.8400.270100 30.14 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-60.8400.110000 18.65 Department 8400 - FINANCIAL ADMINISTRATION Total: 905.33 Department: 8500 - COMMUNITY DEVELOPMENT UNITED PARCEL SERVICE OOOOAW7647327 08/12/2017 SHIPPING 010-50.8500.360000 249.04 ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PRINTER LEASE 010-50.8500.270110 117.71 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-50,8500.100000 -8.10 MUTUALOF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-50.8500,100100 8.32 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-50.8500.450000 52.08 AMERICAN TELECONFERENC INV0003560 07/31/2017 JULY'17 STATEMENT 010-50.8500.450000 14.85 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-50.8500.270100 46.21 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-50.8500.110000 128.67 IOWA MUNICIPALITIES WOR INV65814 09/O1/2017 SEPTEMBER'17 WORKERS C 010-50.8500.110000 5.05 Department 8500 - COMMUNITY DEVELOPMENT Total: 613.83 Department: 8700 - DEVELOPMENT SERVICES ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PRINTER LEASE 010-50.8700.270110 117.71 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-50.8700.100000 279.71 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-50.8700.100000 109.13 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-50.8700.100000 51.40 MUTUALOF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-50.8700.100100 34.86 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-50.8700.450000 104.16 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-50.8700.270100 81.02 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-50.8700.110000 296.32 Department 8700 - DEVELOPMENT SERVICES Total: 1,074.31 Department: 87SO - SUGAR CREEK MUNICIPAL GOLF COURSE SUPERINTEND 00552 08/10/2017 2017 IOWA GCSA OPEN BUS 750-80.8750.470000 70.00 ZIMCO SUPPLY CO 112311 08/09/2017 CHEMICALS FOR FAREWAY/ 750-80.8750.590100 1,316.10 BEST PORTABLE TOILETS, IN 13885 07/28/2017 SERVICE KYBOS 750-80.8750.480000 365.00 ORKIN PEST CONTROL 160060349 08/21/2017 PEST CONTROL -GOLF COUR 750-80.8750.400000 76.45 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 750-80.8750.100000 86.65 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 750-80.8750.100000 31.83 HOLMES MURPHY 424250 08/25/2017 GOLF COURSE PEDESTRIAN B 750-80.8750.290000 399.53 HY-VEE 5801448497 07/10/2017 BROWNIES/SALAD DRESSIN 750-80.8750.650300 74.22 HY-VEE 5802353848 07/10/2017 COUPLE'S NIGHT DESSERT/F 750-80.8750.650300 89.44 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 750-80.8750.100000 1.82 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 750-80.8750.100100 6.32 8/30/2017 4:08:34 PM Page 10 of 17 Expense Approval Register Packet: APPKT00734 - SEPT 6TH COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount MENARDS 90077 08/11/2017 SAFETY FENCE 750-80.8750.410300 123.95 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 750-80.8750.450000 147.20 MID AMERICAN ENERGY AUG 178750SUM BILL O8/24/2017 AUGUST'17 STATEMENT 750-80.8750.480000 1,604.18 R & R PRODUCTS INC CD2155502 08/10/2017 PARTS - SPOON - 2/4 CLOSE 750-80.8750.590000 156.26 CENTURYLINK INV0003545 08/10/2017 AUGUST'17 STATEMENT 750-80.8750.450000 329.81 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 750-80.8750.270100 140.52 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 750-80.8750.110000 108.02 LA CROSSE SEED SINP-17-17630 08/07/2017 REPAIR AREAS WITH SOD& 750-80.8750.590150 2,375.00 Department 8750 - SUGAR CREEK MUNICIPAL Total: 7,502.30 Department: 8800 - INFORMATION TECHNOLOGY AMAZON.COM LLC 114-7496968-6966625 08/07/2017 CABLES/HDMI/ADAPTER/PR 010-60.8800.540000 125.83 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-60.8800.100000 123.78 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-60.8800.100000 45.47 MUTUALOF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-60.8800.100000 2.60 MUTUAL OF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-60.8800.100100 12.12 Department 8800 - INFORMATION TECHNOLOGY Total: 309.80 Department: 8900 - ENGINEERING ACCESS SYSTEMS LEASING 21160077 08/17/2017 COPIER/PRINTER LEASE 010-20.8900.270110 117.71 DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-20.8900.100000 311.86 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON O10-20.8900.100000 127.32 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-20.8900.100000 55.80 MUTUAL OF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-20.8900.100100 105.60 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-20.8900.450000 375.35 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-20.8900.270100 94.26 IOWA MUNICIPALITIES WOR INV65814 09/01/2017 SEPTEMBER'17 WORKERS C 010-20.8900.110000 159.61 Department 8900 - ENGINEERING Total: 1,347.51 Department: 8950 - GIS DELTA DENTAL 33075000200201709 09/01/2017 SEP'17 DENTAL INSURANCE 010-20.8950.100000 32.15 HOLMES MURPHY 423415 09/01/2017 SEP'17 HMA MONTHLY CON 010-20.8950.100000 18.19 MUTUALOF OMAHA 659297699 09/01/2017 SEP'17 LIFE & DISABILITY PR 010-20.8950.100000 5.00 MUTUALOF OMAHA 659297699 09/O1/2017 SEP'17 LIFE & DISABILITY PR 010-20.8950.100100 9.86 VERIZON WIRELESS 9790958376 08/13/2017 AUGUST'17 STATEMENT 010-20.8950.450000 77.10 ACCESS SYSTEMS INV542593 08/15/2017 AUGUST'17 SERVICE FEE 010-20.8950.270100 4.92 IOWA MUNICIPALITIES WOR INV65814 09/O1/2017 SEPTEMBER'17 WORKERS C 010-20.8950.110000 79.08 Department 8950 - GIS Total: 226.30 Grand Total: 1,125,542.89 8/30/2017 4:08:34 PM Page 11 of 17 Expense Approval Register Packet: APPKT00734 - SEPT 6TH COUNCIL PACKET Fund Summary Fund O10-GENERAL FUND 060- ROAD USE TAX FUND 096- WAUKEE WEST URBAN RENEWAL 110- DEBT SERVICE FUND 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 750-GOLF COURSE FUND Account Number 010-10.1100.100000 010-10.1100.100100 010-10.1100.110000 010-10.1100.120000 010-10.1100.230000 010-10.1100.270100 010-10.1100.270110 010-10.1100.280000 010-10,1100.400000 010-10,1100.400100 010-10.1100.410000 010-10.1100.450000 010-10.1100.460200 010-10.1100.470000 010-10.1100.470010 010-10.1100.480000 010-10.1100.540000 010-10.1100.570000 010-10.1100.580000 010-10.1100.590000 O10-10.1400.100000 010-10.1400.100100 010-10.1400.110000 010-10.1400.270100 010-10.1400.270110 010-10.1400.280000 010-10.1400.410000 010-10.1400.410100 010-10.1400.450000 010-10.1400.470000 010-10.1400.480000 010-10.1400.540000 010-10.1400.590000 010-10.1500.100000 010-10.1500.100100 010-10.1500.110000 010-10.1500.270100 010-10.1500.280000 010-10.1500.3529900 010-10.1500.410000 010-10.1500.450000 010-10.1500.470000 010-10.1500.480000 010-10.1500.540000 Grand Total: Account Summary Account Name HEALTH & LIFE INSURAN LONGTERM DISABILITY WORKERS COMPENSATI UNIFORMS CONSULTANT & PROFES COMPUTER SUPPORT COPIER/ PRINTER LEASE DUES, MEMBERSHIPS & REPAIR/MAINTENANCE CUSTODIAL REPAIR OF VEHICLES TELEPHONE PD COMMUNITY POLICI TRAINING/TRAVEL EXPE AMMUNITION UTILITY SERVICES MINOR EQUIPMENT FUEL OFFICE SUPPLIES OPERATING SUPPLIES & HEALTH & LIFE INSURAN LONG TERM DISABILITY WORKERS COMPENSATI COMPUTER SUPPORT COPIER/ PRINTER LEASE DUES, MEMBERSHIPS & REPAIR OF VEHICLES REPAIR/MAINTENANCE TELEPHONE TRAINING/TRAVEL EXPE UTILITY SERVICES MINOR EQUIPMENT OPERATING SUPPLIES & HEALTH & LIFE INSURAN LONGTERM DISABILITY WORKERS COMPENSATI COMPUTER SUPPORT DUES, MEMBERSHIPS & AMBULANCE TRANSPOR REPAIR OF VEHICLES TELEPHONE TRAINING/TRAVEL EXPE UTILITY SERVICES MINOR EQUIPMENT Expense Amount 151,448.53 31,959.09 3,964.50 569,650.00 60,764.10 75,062.42 142,001.48 74,243.81 5,275.60 3,671.06 7,502.30 1,125,542.89 Expense Amount 3,385.46 429.58 1,870.98 1,133.74 340.69 436.11 1,059.39 2,121.80 395.83 914.24 120.45 1,325.02 134.50 3.49 10,320.00 1,023.26 7,749.37 3,976.91 30.49 226.17 913.38 106.62 9,812.03 164.08 117.71 19.50 871.82 303.30 172.59 10.00 678.21 341.25 178.61 770.66 48.12 4,848.11 135.87 19.50 413.14 98.00 172.59 10.00 678.21 188.02 8/30/2017 4:08:34 PM Page 12 of 17 Expense Approval Register Packet: APPKT00734 - SEPT 6TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-10.1500.590000 OPERATING SUPPLIES & 34.17 010-10.1500.590050 MEDICAL SUPPLIES 538.64 010-10.1900.100000 HEALTH & LIFE INSURAN 497.68 010-10.1900.100100 LONGTERM DISABILITY 95.09 010-10.1900.110000 WORKERS COMPENSATI 158.54 010-10.1900.270100 COMPUTER SUPPORT 62.80 010-10.1900.270110 COPIER/PRINTER LEASE 117.71 010-10.1900.450000 TELEPHONE 313.76 010-20.6000.100000 HEALTH & LIFE INSURAN 877.27 010-20.6000.100100 LONGTERM DISABILITY 115.35 010-20.6000.110000 WORKERS COMPENSATI 164.36 010-20.6000.270100 COMPUTER SUPPORT 12.76 010-20.6000.280000 DUES, MEMBERSHIPS & 299.00 010-20.6000.450000 TELEPHONE 210.14 010-20.6010.270110 COPIER/PRINTER LEASE 588.55 010-20,6010.400000 REPAIR/MAINTENANCE 1,239.22 010-20.6010.400100 CUSTODIAL SERVICES 1,247.04 010-20.6010.480000 UTILITYSERVICES 2,136.48 010-20.6010.510100 GARBAGE PICK UP 21.50 010-20.6010.590000 OPERATING SUPPLIES & 1,010.48 010-20.6150.100000 HEALTH & LIFE INSURAN 224.79 010-20.6150.100100 LONGTERM DISABILITY 116.61 010-20.6150.110000 WORKERS COMPENSATI 136.26 010-20.6150.450000 TELEPHONE 69.94 010-20.6150.570110 COGS -FILTERS 18.90 010-20.6150.570130 COGS - PARTS 4,120.88 010-20.6150.590000 OPERATING SUPPLIES& 59.99 010-20.8900.100000 HEALTH & LIFE INSURAN 494.98 010-20.8900.100100 LONGTERM DISABILITY 105.60 010-20.8900.110000 WORKERS COMPENSATI 159.61 010-20.8900.270100 COMPUTER SUPPORT 94.26 010-20.8900.270110 COPIER/PRINTER LEASE 117.71 010-20.8900.450000 TELEPHONE 375.35 010-20.8950.100000 HEALTH & LIFE INSURAN 55.34 010-20.8950.100100 LONG TERM DISABILITY 9.86 010-20.8950.110000 WORKERS COMPENSATI 79.08 010-20.8950.270100 COMPUTERSUPPORT 4.92 010-20.8950.450000 TELEPHONE 77.10 010-40.3100.100000 HEALTH & LIFE INSURAN 840.84 010-40.3100.100100 LONGTERM DISABILITY 61.51 010-40.3100.110000 WORKERS COMPENSATI 39.22 010-40.3100.270100 COMPUTER SUPPORT 161.33 010-40.3100.270110 COPIER/PRINTER LEASE 235.42 010-40.3100,400000 REPAIR/MAINTENANCE 38.51 010-40.3100.400100 CUSTODIAL SERVICES 610.00 010-40.3100.450000 TELEPHONE 52.08 010-40.3100.460300 PROGRAMS 104.57 010-40.3100.480000 UTILITY SERVICES 4,864.99 010-40.3100.540000 MINOR EQUIPMENT 190.21 010-40.3100.590000 OPERATING SUPPLIES& 406.43 010-40.3100.640000 LIBRARY BOOKS/FILMS/ 2,466.98 010-40.4100.100000 HEALTH & LIFE INSURAN 259.16 010-40.4100.100100 LONGTERM DISABILITY 40.33 010-40.4100.110000 WORKERS COMPENSATI 246.88 010-40.4100.230000 CONSULTANT & PROFES 1,319.43 010-40.4100.270100 COMPUTERSUPPORT 113.70 010-40.4100.410100 REPAIR/MAINTENANCE 174.23 010-40.4100.410300 REPAIR/MAINTENANCE 1,154.11 8/30/2017 4:08:34 PM Page 13 of 17 Expense Approval Register Packet: APPK1700734 -SEPT 6TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-40.4100.450000 TELEPHONE 98.82 010-40.4100.470000 TRAINING/TRAVEL EXPE 199.15 010-40.4100.480000 UTILITY SERVICES 237.67 010-40.4100.570000 FUEL 187.31 010-40.4100.590000 OPERATING SUPPLIES & 225.82 010-40.4100.710000 AUTOMOTIVE EQUIPME 28,270.00 010-40.4200.100000 HEALTH & LIFE INSURAN 455.34 010-40.4200.100100 LONG TERM DISABILITY 63.00 010-40.4200.110000 WORKERS COMPENSATI 104.92 010-40.4200.270100 COMPUTERSUPPORT 657.14 010-40.4200.270110 COPIER / PRINTER LEASE 117.71 010-40.4200.450000 TELEPHONE 199.28 010-40.4200.460500 SUMMER RECREATION P 603.90 010-40.4200.470000 TRAINING/TRAVEL EXPE 78.43 010-40.4300.400000 REPAIR/MAINTENANCE 78.25 010-40.4300.400100 CUSTODIAL SERVICES 298.77 010-40.4300.450000 TELEPHONE 88.23 010-50.8500.100000 HEALTH & LIFE INSURAN -8.10 010-50.8500.100100 LONG TERM DISABILITY 8.32 010-50.8500.110000 WORKERS COMPENSATI 133.72 010-50.8500.270100 COMPUTER SUPPORT 46.21 010-50.8500.270110 COPIER/PRINTER LEASE 117.71 010-50.8500.360000 POSTAGE & SHIPPING 249.04 010-50.8500.450000 TELEPHONE 66.93 010-50.8700.100000 HEALTH & LIFE INSURAN 440.24 010-50.8700.100100 LONGTERM DISABILITY 34.86 010-50.8700.110000 WORKERS COMPENSATI 296.32 010-50.8700.270100 COMPUTER SUPPORT 81.02 010-50.8700.270110 COPIER/ PRINTER LEASE 117.71 010-50.8700.450000 TELEPHONE 104.16 010-60.8100.110000 WORKERS COMPENSATI 2.56 010-60.8100.450000 TELEPHONE 4.68 010-60.8100.470000 TRAINING/TRAVEL EXPE 589.59 010-60.8200.100000 HEALTH & LIFE INSURAN 177.05 010-60.8200.100100 LONG TERM DISABILITY 33.60 010-60.8200.110000 WORKERS COMPENSATI 7.96 010-60.8300.100000 HEALTH & LIFE INSURAN 335.07 010-60.8300.100100 LONG TERM DISABILITY 28.66 010-60.8300.110000 WORKERS COMPENSATI 24.05 010-60.8300.230000 CONSULTANT&PROFES 21,941.02 010-60.8300.270000 DATA PROCESSING 4.43 010-60.8300.270100 COMPUTERSUPPORT 2,260.34 010-60.8300.270110 COPIER / PRINTER LEASE 117.71 010-60.8300.280000 DUES, MEMBERSHIPS & 25.00 010-60.8300.290000 GENERAL LIABILITY INSU 574.71 010-60.8300.360000 POSTAGE & SHIPPING 36.13 010-60.8300.390400 NORTHVIEW RENTAL PR 17.81 010-60.8300.450000 TELEPHONE 54.39 010-60.8300.470000 TRAINING/TRAVEL EXPE 11.63 010-60.8300.580000 OFFICE SUPPLIES 28.50 010-60.8310.270110 COPIER / PRINTER LEASE 235.42 010-60.8310.390600 PROF PLAZA CAM EXPEN 239.11 010-60.8310.400100 CUSTODIAL SERVICES 597.54 010-60.8310.480000 UTILITY SERVICES 692.05 010-60.8310.590000 OPERATING SUPPLIES & 16.14 010-60.8350.100000 HEALTH & LIFE INSURAN 52.94 010-60.8350.100100 LONG TERM DISABILITY 74.24 010-60.8350.110000 WORKERS COMPENSATI 9.00 8/30/2017 4:08:34 PM Page 14 of 17 Expense Approval Register Packet: APPKT00734 - SEPT 6TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-60.8350.270100 COMPUTER SUPPORT 12.02 010-60.8350.270110 COPIER/ PRINTER LEASE 117.71 010-60.8350.450000 TELEPHONE 101.14 010-60.8350.689000 EMPLOYEE APPRECIATIO 185.00 010-60.8350.689200 WELLNESS PROGRAM/1 463.87 010-60.8400.100000 HEALTH & LIFE INSURAN 344.41 010-60.8400.100100 LONGTERM DISABILITY 66.90 010-60.8400.110000 WORKERS COMPENSATI 18.65 010-60.8400.270100 COMPUTER SUPPORT 30.14 010-60.8400.270110 COPIER/PRINTER LEASE 353.14 010-60.8400.450000 TELEPHONE 92.09 010-60.8800.100000 HEALTH & LIFE INSURAN 171.85 010-60.8800.100100 LONGTERM DISABILITY 12.12 010-60.8800.540000 MINOR EQUIPMENT 125.83 060-30.1600.410300 REPAIR/MAINTENANCE 2,743.32 060-30.1600.480000 UTILITY SERVICES 17,364.82 060-30.1601.480000 UTILITY SERVICES 520.79 060-30.7100.100000 HEALTH & LIFE INSURAN 767,95 060-30.7100.100100 LONGTERM DISABILITY 165.59 060-30.7100.110000 WORKERS COMPENSATI 1,115.48 060-30.7100.270100 COMPUTER SUPPORT 334.36 060-30.7100.340000 MISCELLANEOUS CONTR 84.30 060-30.7100.410300 REPAIR/MAINTENANCE 2,127.00 060-30.7100.450000 TELEPHONE 218.72 060-30.7100.470000 TRAINING/TRAVEL EXPE 132.80 060-30.7100.570000 FUEL 187.31 060-30.7100.590000 OPERATING SUPPLIES & 794.10 060-30.7100.590300 ROADSTONE 2,337.47 060-30.7100.590400 ROAD REPAIR -PATCH 2,877.00 060-30.7100.590600 STREET SIGNS 188.08 096-30.7850.230000 CONSULTANT/PROFESSI 3,964.50 110-1080100 MONEY MARKET-BANKE 569,650.00 327-90.1400,710310 AMBULANCE EQUIPMEN 290.09 327-90.2130.840490 ALICES RD -UNIV TO OL 5,842.89 327-90.2130.840491 ALICES ROAD - OLSON T 46,091.80 327-90.2131.230051 CONSULTING -ESKER RID 972.87 327-90.4100.880070 DOG PARK - CONSULTIN 5,475.00 327-90.5000.881130 RRVT TRAILHEAD ART I 110.00 327-90.7730.230000 CONSULTANT & PROFES 1,981.45 510-1080100 MONEY MARKET-BANKE 26,450.00 510-30.6510.100000 HEALTH & LIFE INSURAN 490.82 510-30.6510.100100 LONGTERM DISABILITY 193.54 510-30.6510.110000 WORKERS COMPENSATI 667.43 510-30.6510.250000 TESTING FEES 15.00 510-30.6510.270100 COMPUTER SUPPORT 770.41 510-30.6510.340000 MISCELLANEOUS CONTR 347.05 510-30.6510.390300 TOWER RENT 583.20 510-30.6510.410500 REPAIR/MAINTENANCE 92.58 510-30.6510.450000 TELEPHONE 438.14 510-30.6510.470000 TRAINING/TRAVEL EXPE 143.79 510-30.6510.480000 UTILITY SERVICES 693.98 510-30.6510.570000 FUEL 187.31 510-30.6510.592000 METER PURCHASE 25,293.30 510-30.6510.650010 DSMWW OPERATING & 18,695.87 520-1080100 MONEY MARKET-BANKE 16,350.00 520-30.6520.100000 HEALTH & LIFE INSURAN 566.34 520-30.6520.100100 LONGTERM DISABILITY 103.22 520-30.6520.110000 WORKERS COMPENSATI 232.53 8/30/2017 4:08:34 PM Page 15 of 17 Expense Approval Register Packet: APPKT00734 - SEPT 6TH COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 520-30.6520.270100 COMPUTER SUPPORT 633.54 520-30.6520.411100 REPAIR/MAINTENANCE 968.40 520-30.6520.450000 TELEPHONE 321.81 520-30.6520.470000 TRAINING/TRAVEL EXPE 143.79 520-30.6520.480000 UTILITY SERVICES 10,054.55 520-30.6520.570000 FUEL 187.30 520-30.6520.882700 WRA FEES 112,440.00 540-1080100 MONEY MARKET - BANK 34,650.00 540-30.6540.100000 HEALTH & LIFE INSURAN 860.29 540-30.6540.100100 LONG TERM DISABILITY 77.33 540-30.6540.110000 WORKERS COMPENSATI 547.60 540-30.6540.230000 CONSULTANT&PROFES 500.00 540-30.6540.270100 COMPUTER SUPPORT 987.00 540-30.6540.340000 MISCELLANEOUS CONTR 347.05 540-30.6540.390300 TOWER RENT 583.20 540-30.6540.410400 REPAIR/MAINT OF DELIV 18,952.68 540-30.6540.410600 EMERGENCY REPAIRS 552.73 540-30.6540.450000 TELEPHONE 283.72 540-30.6540.470000 TRAINING/TRAVEL EXPE 143.79 540-30.6540.480000 UTILITY SERVICES 98.23 540-30.6540.570000 FUEL 187.30 540-30.6540.590000 OPERATING SUPPLIES& 399.30 540-30.6540.590100 DEVELOPER MATERIALS 11,234.61 540-30.6540.590200 INSTALLATION MATERIA 3,538.98 540-30.6540.685400 GAS REBATE 300.00 560-80.5300.100000 HEALTH & LIFE INSURAN 503.94 560-80.5300.100100 LONG TERM DISABILITY 84.23 560-80.5300.110000 WORKERS COMPENSATI 154.92 560-80.5300.270100 COMPUTER SUPPORT 144.11 560-80.5300.290100 VEHICLE INSURANCE -574.71 560-80.5300.350100 PRINTING 31.00 560-80.5300.410300 REPAIR/MAINTENANCE 141.38 560-80.5300.450000 TELEPHONE 306.30 560-80.5300.540000 MINOR EQUIPMENT 363.93 560-80.5300.880015 CENTENNIAL PARK STRE 4,120.50 570-30.6550.100000 HEALTH & LIFE INSURAN 236.06 570-30.6550.100100 LONGTERM DISABILITY 15.78 570-30.6550.110000 WORKERS COMPENSATI 9.77 570-30.6550.270100 COMPUTER SUPPORT 55.89 570-30.6550.270110 COPIER/PRINTER LEASE 117.71 570-30.6550.360000 POSTAGE & SHIPPING 3,235.85 750-80.8750.100000 HEALTH & LIFE INSURAN 120.30 750-80.8750.100100 LONG TERM DISABILITY 6.32 750-80.8750.110000 WORKERS COMPENSATI 108.02 750-80.8750.270100 COMPUTER SUPPORT 140.52 750-80.8750.290000 GENERAL LIABILITY INSU 399.53 750-80.8750.400000 REPAIR/MAINTENANCE 76.45 750-80.8750.410300 REPAIR/MAINTENANCE 123.95 750-80.8750.450000 TELEPHONE 477.01 750-80.8750.470000 TRAINING/TRAVEL EXPE 70.00 750-80.8750.480000 UTILITY SERVICES 1,969.18 750-80.8750,590000 OPERATING SUPPLIES& 156.26 750-80.8750.590100 CHEMICAL/FERTILIZER 1,316.10 750-80.8750.590150 GRASSSEED 2,375.00 750-80.8750,650300 COGS -CATERING 163.66 Grand Total: 1,125,542.89 8/30/2017 4:08:34 PM Page 16 of 17 Expense Approval Register Packet: APPKT00734 - SEPT 6TH COUNCIL PACKET Project Account Key "None" Project Account Summary Expense Amount 1,125,542.89 Grand Total: 1,125,542.89 8/30/2017 4:08:34 PM Page 17 of 17 0,00 Waukee City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE 103950 JIMMYJOHN'S Payable# Payable Type Account Number INV0003509 Invoice 190825 Payable # INV0003507 199023 Payable # INV0003508 203200 Payable # INV0003510 047290 Payable # INV0003511 055625 750-80.8750.650300 SAM'S CLUB Payable Type Account Number Invoice 750-80.875&590000 750-80.8750.650200 750-80.8750.650200 Payment Date Payment Type 08/17/2017 Regular Post Date Payable Description Account Name Item Description 08/17/2017 COUPLE'S NIGHT FOOD COGS -CATERING COUPLE'S NIGHT FOOD 08/17/2017 Regular Post Date Payable Description Account Name Item Description 08/08/2017 AUGUST'17 STATEMENT OPERATING SUPPLIES & TRASH BAGS COGS-SNACKS/CANDY REFUND ON TAX COGS-SNACKS/CANDY CANDY/CUPS SUGAR CREEK GOLF COURSE O8/17/2017 Regular Payable Type Post Date Payable Description Account Number Account Name Item Description Invoice 08/17/2017 COUPLE'S NIGHT PRIZES 750-80.8750.653000 LEAGUE PRIZES/EXPENSE COUPLE'S NIGHT PRIZES My Check Report By Check Number Date Range: 08/17/2017- 08/21/2017 DiscountAmount PaymentAmount Number 0.00 104.00 130173 DiscountAmount Payable Amount Distribution Amount 0.00 104.00 104.00 0.00 347.46 130174 DiscountAmount Payable Amount Distribution Amount 0.00 347.46 16.98 -16.27 346.75 0.00 240.00 130175 DiscountAmount Payable Amount Distribution Amount 0.00 240.00 240.00 THE KEE O8/17/2017 Regular 0.00 837.00 130176 Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 08/17/2017 COUPLE'S NIGHT CATERING 0.00 837.00 750-80.8750.650300 COGS -CATERING COUPLE'S NIGHT CATERING 837.00 DOLL DISTRIBUTING, LLC Payable Type Account Number Invoice 750-80.8750.650100 O8/17/2017 Regular Post Date Payable Description Account Name Item Description O8/17/2017 BEER DELIVERY COGS-BEER/ALCOHOL BEER DELIVERY EMPLOYEE BENEFITSYSTEMS 08/21/2017 Regular 0.00 384.80 130177 DiscountAmount Payable Amount Distribution Amount 0.00 384.80 384.80 0.00 125,436.42 130197 8/30/2017 2:53:35 PM Page. 1 of 4 My Check Report Date Range: 08/17/2017 - 08/21/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount Payment Amount Number Payable# Payable Type Post Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount 11646 Invoice 08/21/2017 SEP'17 HEALTH INSURANCE MONTHLY P 0.00 125,436.42 010-10.1100.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 33,550.10 010-10.1400.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 7,095.21 010-10AS00.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 7,095.20 010-10.1900.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 4,234.44 010-20.6000.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 5,990.80 010-20.6150.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 2,117.22 010-20.8900.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 4,234.44 010-20.8950.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 596.62 010-40,3100.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 8,521.44 010-40.4100.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 596.62 010-40.4100.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 1,520.60 010-40.4100.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 304.12 010-40.4200.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 3,637.82 010-50.8500.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 43.70 010-50.8700.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 3,637.82 010-60.8200.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 1,520.60 010-60.8300.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 2,949.60 010-60.8350.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 596.62 010-60.8400.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 3,546.22 010-60.8900.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 1,520.60 060-30.7100.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 5,755.04 060-30.7100,100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 152.06 060-30.7100,100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 760.30 510-30.6510.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 2,071.42 510-30.6510.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 529.31 510-30.6510.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 1,520.60 510-30.6510.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 760.30 520-30.6520.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 529.31 520-30.6520.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 760.30 520-30.6520.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 2,071.42 520-30.6520.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 2,858.00 540-30.6540.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 529.31 540-30.6540.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 5,811.80 540-30.6540.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 760.29 560-80.5300.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 529.31 560-80.5300.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 3,637.82 570-30.6550.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 2,025.62 750-80.8750.100000 HEALTH & LIFE INSURANC SEP'17 HEALTH INSURANCE MO 1,064.42 094675 IOWA BEVERAGE SYSTEMS INC 08/21/2017 Regular 0.00 365.20 130198 Payable# Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003515 Invoice 08/21/2017 BEER DELIVERY 0.00 365.20 750-80.8750,650100 COGS-BEER/ALCOHOL BEER DELIVERY 365.20 233105 PETTY CASH -CITY HALL 08/21/2017 Regular 0.00 200.00 130199 8/30/2017 2:53:35 PIA Page 2 of 4 My Check Report Vendor Number Vendor Name Payment Date Payment Type Payable # Payable Type Post Date Payable Description Account Number Account Name Item Description INV0003514 Invoice 08/21/2017 GIBSON- TRAVEL CASH 010-20.6000,470000 TRAINING/TRAVELE%PEN GIBSON -TRAVEL CASH Date Range: 08/17/2017 - 08/21/2017 DiscountAmount Payment Amount Number DiscountAmount Payable Amount Distribution Amount 0.00 200.00 200.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 8 8 0.00 127,914.88 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 8 8 0.00 127,914.88 8/30/2017 2:53:35 PM Page 3 of 4 My Check Report Date Range: 08/17/2017 - 08/21/2017 Fund Summary Fund Name Period Amount 999 POOLED CASH 9/2017 127,914.88 127,914.88 8/30/2017 2:53:35 PM Page 4 of 4 0 City of Waukee, IA WbL)kee Vendor Number Vendor Name Payment Date Payment Type Bank Code: AP-WAUKEE STATE 013015 AGRIVISION EQUIPMENT GROUP 08/24/2017 Regular Payable If Payable Type Post Date Payable Description Account Number Account Name Item Description 2630886 Invoice 08/14/2017 JOHN DEERE HX15 My Check Report By Check Number Date Range: 08/23/2017 - 08/30/2017 DiscountAmount PaymentAmount Number 0.00 67,950.00 130336 DiscountAmount Payable Amount Distribution Amount 0.00 14,500.00 060-30.7100.760000 OTH ER CAPITAL EQUI PM JOHN DEERE HX151POHX15ECH 7,250.00 560-80.5300,790000 VEHICLE OR EQUIPMENT JOHN DEERE HX151POHX15ECH 7,250.00 2630890 Invoice 08/14/2017 JOHN DEERE 5100E 0.00 53,450.00 060-30.7100.760000 OTHER CAPITAL EQUIPM JOHN DEERE 5100E 1LV5100ET 26,725.00 560-80.5300.790000 VEHICLE OR EQUIPMENT JOHN DEERE 5100E 1LV5100ET 26,725.00 047290 DOLL DISTRIBUTING, LLC 08/24/2017 Regular 0.00 356.20 130337 Payable# Payable Type Post Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INVOOD3528 Invoice 08/24/2017 BEER DELIVERY 0.00 356.20 750-80.8750.650100 COGS-BEER/ALCOHOL BEER DELIVERY 356.20 199023 SUGAR CREEK GOLF COURSE 08/24/2017 Regular 0.00 3%00 130338 Payable# Payable Type Post Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003529 Invoice 08/24/2017 LEAGUE PRIZES 0.00 360.00 750-80.8750.653000 LEAGUE PRIZES/EXPENSE LEAGUE PRIZES 360.00 216965 US ENVIRONMENTAL PROTECTION AGENCY-R 08/24/2017 Regular 0.00 17,127.00 130339 Payable# Payable Type Post Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003527 Invoice 08/24/2017 EPA PENALTY 0.00 17,127.00 560-80.5300.230000 CONSULTANT & PROFESS EPA PENALTY 17,127.00 094675 IOWA BEVERAGE SYSTEMS INC 08/28/2017 Regular 0.00 537.25 130340 Payable# Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003541 Invoice 08/28/2017 BEER DELIVERY 0.00 537.25 750-80.8750.650100 COGS-BEER/ALCOHOL BEER DELIVERY 537.25 116425 KLOCKE'S EMERGENCY VEHICLES 08/28/2017 Regular 0.00 122,920.00 130341 Payable# Payable Type Post Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount 9002490 Invoice 08/17/2017 2017 FORD E-450 AMBULANCE 0.00 122,920.00 327-90.1400.710310 AMBULANCE EQUIPMEN 2017 FORD E-450 AMBULANCE 122,920.00 199023 SUGAR CREEK GOLF COURSE 08/28/2017 Regular 0.00 1,356.00 130342 Payable# Payable Type Post Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003542 Invoice 08128/2017 LEAGUE PRIZES 0.00 1,356.00 750-80.8750.653000 LEAGUE PRIZES/EXPENSE LEAGUE PRIZES 1,356.00 203200 THE KEE 08/28/2017 Regular 0.00 784.00 130343 B/30/2017 2:54:57 PM Page 1 of 3 My Check Report Vendor Number Payable # INV0003543 Vendor Name Payable Type Account Number Invoice 750-80.8750.650300 Payment Date Payment Type Post Date Payable Description Account Name Item Description O8/28/2017 LEAGUE FOOD COGS -CATERING LEAGUE FOOD Date Range: 08/23/2017 - 08/30/2017 DiscountAmount Payment Amount Number DiscountAmount Payable Amount Distribution Amount 0.00 784.00 784.00 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 9 8 0.00 211,390.45 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 9 8 0.00 221,390.45 8/30/2017 2:54:57 PM Page 2 of 3 My Check Report 0 Date Range: 08/23/2017 - 08/30/2017 Fund Summary Fund Name Period Amount 999 POOLED CASH 8/2017 - 211,390.45 211,390.45 8/30/2017 2:54:57 PM Page 3 of 3 U Council Payroll Reimbursements 046 VAO A ee City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE By Check Number Date Range: 08/15/2017 - 08/30/2017 Payment Date Payment Type Discount Amount PaymentAmount Number 034875 CITY OF WAUKEE 08/15/2017 Regular 0.00 5,796.76 130164 Payable N Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003485 Invoice 08/15/2017 CELL PHONE REIMBURSEMENT 0.00 230.00 010-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 155.00 060-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 9.37 510-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 11.42 520-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.24 540-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.43 560-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 1.54 INV0003490 Invoice 08/15/2017 LIFE INSURANCE PREMIUM 0.00 688.21 010-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 505.01 060-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 19.45 510-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 28.95 520-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 28.83 540-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 43.51 560-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 27.71 570-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 34.75 INV0003491 Invoice 08/15/2017 STD INSURANCE PREMIUM 0.00 598.55 010-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 387.69 060-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 56.15 510-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 45.77 520-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 51.95 540-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 24.02 560-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 32.97 INV0003494 Invoice 08/15/2017 HEALTH INSURANCE DEDUCTION 0.00 3,780.00 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 2,793.00 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 189.00 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 144.77 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 196.81 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 249.69 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 117.48 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 52.50 750-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 36.75 INV0003495 Invoice 08/15/2017 HEALTH INSURANCE DEDUCTION 0.00 500.00 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 360.00 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 40.00 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 25.46 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 24.99 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 5.45 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 24.10 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 20.00 036350 IOWA DEPT OF HUMAN SERVICES 08/15/2017 Regular 0.00 2,183.66 130165 Payable p Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003477 Invoice 08/15/2017 CHILD SUPPORT 0.00 2,183.66 010-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 1,604.80 060-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 123.88 510-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 227.49 520-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 227.49 8/30/2017 10:19:53 AM Page 1 of 4 Council Payroll Reimbursements Date Range: 08/15/2017 - 08/30/2017 Vendor Number 036740 Payable # INV0003482 099999 Payable # INV0003500 INV0003501 INV0003502 133560 Payable # INV0003487 206800 Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number COMMUNICATIONS WORKERS OF AMERICA 08/15/2017 Regular 0.00 910.63 130166 Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 08/15/2017 CWA LOCAL 7102 UNION DUES 0.00 910.63 010-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 405.95 060-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 85.07 510-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 78.98 520-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 109.86 540-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 137.12 560-2014100 CREDIT UNION DEDUCT[ CWA LOCAL 7102 UNION DUES 67.73 570-2014100 CREDIT UNION DEDUCT[ CWA LOCAL 7102 UNION DUES 25.92 EFTPS 08/15/2017 Regular 0.00 92,943.87 130167 Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 08/15/2017 FICA TAX WITHHOLDING 0.00 42,675.16 010-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDI NG 31,423.34 060-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 2,433.62 510-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,610.78 520-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,953.64 540-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,970.82 560-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,251.02 570-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 556.86 750-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,475.08 Invoice 08/15/2017 FEDERAL WITHHOLDING TAXES 0.00 40,246.97 010-2010200 FEDERAL TAX WITHHOLD] FEDERAL WITHHOLDING TAXES 30,127.43 060-2010200 FEDERAL TAX WITHHOLD] FEDERAL WITHHOLDING TAXES 2,226.64 510-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,463.83 520-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 2,078.55 540-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,785.49 560-2010200 FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,195.54 570-2010200 FEDERALTAX WITHHOLDI FEDERAL WITHHOLDING TAXES 737.43 750-2010200 FEDERALTAX WITHHOLD[ FEDERAL WITHHOLDING TAXES 632.06 Invoice 08/15/2017 MEDICARE TAX WITHHOLDING 0.00 10,021.74 010-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 7,390.30 060-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 569.14 510-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 376.78 520-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 456.86 540-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 460.88 560-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 292.60 570-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 130.24 750-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 344.94 MEALS FROM THE HEARTLAND O8/15/2017 Regular 0.00 114.20 130168 Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount Invoice 08/15/2017 MEALS FROM HEARTLAND DEDUCTION 0.00 114.20 010-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 93.66 510-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 3.54 520-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 2.50 560-2030000 PAYROLL PAYABLES MEALS FROM HEARTLAND DED 14.50 TOTAL ADMINISTRATIVE SERVICES CORP 08/15/2017 Regular 0.00 4,767.24 130169 8/30/2017 10:19:53 AM Page 2 of 4 Council Payroll Reimbursements U Date Range: 08/15/2017 - 08/30/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003492 Invoice 08/15/2017 SECTION 125 MEDICAL DEDUCTIONS 0.00 3,038.10 010-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 2,283.70 060-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 43.75 510-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 117.00 520-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 26.98 540-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 283.34 560-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 143.75 570-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 125.00 750-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 14.58 INV0003493 Invoice 08/15/2017 SECTION 125 DAYCARE DEDUCTIONS 0.00 1,729.14 010-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT 1,416.65 560-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT 312.49 213250 UNITED WAY CENTRAL IOWA O8/15/2017 Regular 0.00 186.63 130170 Payable# Payable Type Post Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003484 Invoice 08/15/2017 UNITED WAY DEDUCTION 0.00 186.63 010-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 157.50 510-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 6.89 520-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 4.99 540-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 10.00 560-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 7.25 233050 WAUKEE PUBLIC LIBRARY FRIENDS FOUNDATIC 08/15/2017 Regular 0.00 33.33 130171 Payable # Payable Type Post Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003488 Invoice 08/15/2017 LIBRARY FRIENDS FOUNDATION PAYROLL 0.00 33.33 010-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 25.79 510-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 3.54 520-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 2.50 560-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 1.50 099999 EFTPS 08/15/2017 Regular 0.00 20.78 130172 Payable# Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0003504 Invoice 08/15/2017 FICA TAX WITHHOLDING 0.00 14.88 750-2010300 FICA TAX WITH HOLDING FICA TAX WITHHOLDING 14.88 INV0003505 Invoice 08/15/2017 FEDERAL WITHHOLDING TAXES 0.00 2.42 750-2010200 FEDERAL TAX WITHHOLD] FEDERAL WITHHOLDING TAXES 2.42 INV0003506 Invoice 08/15/2017 MEDICARE TAX WITHHOLDING 0.00 3.48 750-2010400 MEDICARE TAX WITH HOL MEDICARE TAX WITHHOLDING 3.48 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 18 9 0.00 106,957.10 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 18 9 0.00 106,957.10 8/30/2017 10:19:53 AM Page 3 of 4 Council Payroll Reimbursements 64 Date Range: 08/15/2017 - 08/30/2017 Fund Summary Fund Name Period Amount 999 POOLED CASH 8/2017 106,957.10 306,957.10 8/30/2017 10:19:53 AM Page 4 of 4 08-30-2019 10:23 AM PERIOD: 8/17/2017 THRU 8/30/2017 ZONE: * - All Zones REVENUE CODE: All ADJUSTMENT CODES: All ACCOUNT N04 NAME MONTHLY TRANSACTION DATE TYPE REPORT AMOUNT REFERENCE PAGE: 1 PACKET RECEIPT ADJ 01-64402-00 ORTEGA, ELIZABETH 8/18/2017 RF-CK 28.43 REFUND CK: 130178 20960 09-10131-06 SPIZZIRRI, CLEMENCIA E 8/18/2017 RF-CK 62.94 REFUND CK: 130199 20960 16-00095-00 HALE DEVELOPMENT CO LLC 8/18/2017 RF-CK 564.09 REFUND CK: 130180 20960 16-00137-00 KIMBERLEY DEVELOPMENT 8/18/2017 RF-CK 46.54 REFUND CK: 130181 20960 16-00152-00 NEXT STEP HOMES 8/18/2017 RF-CK 98.95 REFUND CK: 130182 20960 16-00300-00 ROCK EQUITY HOLDINGS, LLC 8/18/2017 RF-CK 35.55 REFUND CK: 130183 20960 16-00586-00 KIMBERLEY DEVELOPMENT 8/18/2017 RF-CK 50.52 REFUND CK: 130184 20960 16-00659-01 BEWLEY, GARY / DIANNE 8/18/2017 RF-CK 100.00 REFUND CK: 130185 20960 83-00246-11 COMSTOCK, RYAN 8/18/2017 RF-CK 45.24 REFUND CK: 130186 20960 83-00850-13 GARDNER, TRAVIS 8/18/2017 RF-CK 4.49 REFUND CK: 130189 20960 E3-00935-04 FOSTER, CANDICE N 8/18/2017 RF-CK 24.56 REFUND CK: 130188 20960 83-01254-06 VILLOTTI, BOBBIE 8/18/2017 RF-CK 150.00 REFUND CK: 130189 20960 83-01511-19 SIEREN, JOE S 8/18/2017 RF-CK 105.95 REFUND CK: 130190 20960 84-00431-13 GRADY, ETHAN 8/18/2017 RF-CK 21.00 REFUND CK: 130191 20960 84-00552-00 ELDER CORPORATION 8/18/2017 RF-CK 2,390.86 REFUND CK: 130192 20960 84-02279-09 DEMEUSE, DAVID E 8/18/2017 RF-CK 51.90 REFUND CK: 130193 20960 84-90000-00 NEW OPPORTUNITIES, INC 8/18/2017 RF-CK 124.94 REFUND CK: 130194 20960 85-00084-04 VOLD, RON 8/18/2017 RF-CK 41.24 REFUND CK: 130195 20960 85-00890-00 GRAYRAWK HOMES OF IOWA INC 8/18/2017 RF-CK 336.51 REFUND CK: 130196 20960 08-30-2019 10:23 AM MONTHLY TRANSACTION REPORT PAGE: 2 PERIOD: 8/17/2017 THRU 8/30/2017 ZONE: * - All Zones REVENUE CODE: All ADJUSTMENT CODES: All D A I L Y D I S T R I B U T I O N DAY REVENUE CODE TYPE COUNT AMOUNT TYPE COUNT AMOUNT TYPE COUNT AMOUNT 18 999 - REFUND RF-CK 19 4,290.49 roa•�ryv_v�i GRAND TOTAL FOR PERIOD 4,290.49. DEPOSIT TOTAL FOR PERIOD 0.00 08-30-2017 10:23 AM MONTHLY TRANSACTION REPORT PAGE: 3 PERIOD: 8/17/2017 THRU 8/30/2017 ZONE: - - All Zones REVENUE CODE: All ADJUSTMENT CODES: All ____________________________________ R E V E N U E C O D E T O T A L S B Y T Y P E = ------- CODE TYPE COUNT AMOUNT TYPE COUNT AMOUNT TYPE COUNT AMOUNT 999 - REFUND RP-CK 19 4,290.49 GRAND TOTAL FOR PERIOD 4,290.49 _______________________________________ T 0 T A L S B Y T R A N S A C T I O N T Y P E TYPE COUNT AMOUNT ------------------------------------------- REFUND CHECK 19 4,290.49 TOTAL FOR PERIOD 19 4,290.49 l'j 0 Vbukee Employee Name ABBOTT, BRENT ADKINS, COREY ALDRICH, SHAW N ALLEN, JASON APPLE, WILLIAM ARIAS, HECTOR ARMSTRONG, BRETT BAKER, RANDY BARTUNG, DARREL BAUMAN, LISA BELL, RYAN BERG, BROOKE BERGMAN, ANNASTASIA BEST, KELSEY BLUTT, PETER BOHARDT, HAZEL BOTTENBERG, RICHARD BRUNS, RACHEL BURKHART, LINDA CAHALAN, JACE CAMPBELL, JUDY CAMPBELL, SCdTT CASEY, MARK CATALDO, RUDOLPH CICHOSKI, KELLI CLAYTON, KRISTIN CLEMEN, ANTHONY COLE, JACOB CORKREAN, JENNIFER COUCHMAN, KENNETH COUGHLIN, SHAYE COUGHLIN, TONI CRAVEN,GAYLA CUNNINGHAM, DEANA CUNNINGHAM, SCOTT DANIEL, COLE DEBOER, MELISSA DEETS, BRADLY DEZEEUW, DAVID DODGE, JUSTIN DRAKE, ALISHA DUNBAR, DAANA DUNHAM, BRYCE DUTCHER, DAN EASTMAN, DAVID EDDIE, CHASE EDWARDS, DANAE ELLIOTT, RYAN ELLIOTT, STEVE ENNETT, SAMUEL EVERMAN, MASON FLUGGE-SMITH, JAMIE FOGT, ASHLEY FORRET, DENNIS FREDERICK, JUSTIN FREEMAN, PARKER FROEHLICH, WILLIAM City of Waukee, IA Publication Report By Employee Name Payroll Set: 01 - City of Waukee For Date Range 08/01/2017-08/15/2017 Salary $1,297.35 $1,262.51 $1,623.39 $55.41 $770.18 $2,482.40 $1,467.89 $1,626.49 $169.84 $1,178.27 $211.01 $78.20 $392.49 $55.72 $270.54 $212.43 $392.49 $1,750.51 $2,872.28 $79.70 $933.20 $1,966.69 $282.91 $273.25 $1,763.35 $372.75 $2,060.44 $484.70 $1,672.08 $116.19 $223.49 $1,193.80 $112.86 $580.45 $2,289.56 $1,343.93 $1,757.62 $3,110.02 $2,094.11 $1,765.61 $864.68 $1,022.27 $1,279.99 $3,121.95 $328.72 $846.51 $1,598.43 $900.62 $1,880.94 $1,474.32 $43.95 $1,905.93 $377.48 $54.62 $1,734.02 $864.78 $433.56 lw Employee Name Salary GEADELMANN, WILLIAM $45.71 GIBSON, JOHN $3,404.76 GITZEN, ROBERT $2,258.73 GODW IN, BRYCE $549.45 GODW IN, EDWARD $605.43 GRACE, ANDREW $790.64 GRANT, ABIGAIL $330.15 GROVE, BRIAN $277 24 GROVO,ANDREW $303.39 GUESS, CHRISTOPHER $622.46 GUESS, KATHRYN $1,546.27 HANSON, ANTHONY $1,933.05 HANSON, LAURA $1,483.29 HARDIN, THOMAS $117.69 HARRISON, BRIAN $392.49 HEIMANN, RONALD $2,149.17 HENTGES, ERIC $882.12 HERRICK, ROBERT $1,803.95 HILGENBERG, ADAM $1,824.18 HILLYER, COLDEN $748.76 HOCHSTETLER, DENNIS $875 29 HOLDEN, PATRICIA $2 840 08 HUGHES, RACHELLE $342.41 HULSING, TAYLOR $224.57 HUSTED, TROY $1,631.13 HUTTON, JOSHUA $1,870.36 IRWIN, BRENT $145.70 JENSEN, CHAD $598.34 JENSEN,SHELBY $535.21 JERMIER, MATTHEW $2,678.61 JOHNSON, GABLE $554.10 KASS, ANDREW $2,049.25 KASZINSKI, BRETT $833.62 KELLER, CHRISTOPHER $1,575.49 KERR, JACOB $1,854.11 KIES, SUSAN $1,681.66 KOESTER, EVAN $1,721.53 KOESTER, RUDY $2,408.73 KOPPES, BROOKE $328.65 KUMSHER, AUDRIANA $108.22 LARSON, KENNETH $314.38 LARSON, KRISTINE $2,530.74 LAUGHRIDGE, DANIEL $1,801.85 LE, SON $2,339.93 LEMKE, NEIL $1,800.50 LEON, NATHAN $324.14 LOFTSGARD, MARA $346.37 LONDON, SHAY $102.99 LONG, JEREMY $2,480.73 LOVE, WILLIAM $119.88 LYNCH, JEREMY $791.66 LYNCH, SHANNON $1,502.23 LYON, LARRY $393.55 MANNING, JOSHUA $1,911.17 MANNING, TAYLOR $92.71 MAPES, TROY $2,794.21 MCCLINTIC, JAMES $994 90 MCKERN, DOUGLAS $761.99 MEDDERS, BRETT $1,105.34 MELLENCAMP, JEFFREY $2,451.67 MICKELSON, EMILY $505.82 MINIKUS, JOSHUA $1,595.91 MOERMAN, TIMOTHY $3,826.67 MORFORD, PAIGE $735.04 Employee Name Salary MURRA, BRIAN $1,733.16 NITZEL, NICOLE $681.95 OAKLEY, JON $1,889.96 OLSEN, KARI $1,502.06 OSBORN, RYAN $173.96 OSTRING, KATHLEEN $1,453.58 PARISH, TONJA $1,345.85 PARKER, SUSAN $102.17 PAYNE, THOMAS $650.65 PEARD, WILLIAM $492.68 PELLETTERI, SALVATORE $198.23 PERDRIAU, MARIE $208.01 PETERSON, KATIE $1,416.65 PETERSON, OREN $1,994.29 PETTIT, BRANDON $1,801.01 PIERSON, DAMON $1,277.75 PINEGAR, TOMMIE $366.81 PIZINGER, JAMES $1,234.90 POSADAS, OSCAR $473.28 PROHASKA, JOSHUA $864.40 PUDENZ, COLE $506.77 PUDENZ, DANIELLE $194.31 PURVIS, KATHRYN $1,227.81 QUINN, JOHN $3,151.64 RALEY, MORGAN $155.84 RASH, RONALD $1,583.86 REESE, JAMES $86829 RICHARDSON, ELIZABETH $1,697.23 RICHTER, ALICIA $24.27 RIPPERGER, TRACY $159.75 ROBINSON, CLINT $3,259.60 ROOSE, NICHOLAS $692.85 ROYER, TIMOTHY $2,776.29 ROYSTER, JACOB $1,521.03 SANCHEZ, MARIA $1,400.74 SANDQUIST, BENJAMIN $207.71 SCHAUFENBUEL, KARI $1,038.02 SCHETTLER, RODNEY $2,332.86 SCHMEINK, AMANDA $900.62 SCHRODER, BLAKE $1,094.94 SCHUETT, REBECCA $2,258.11 SEDDON, JOSH $130.29 SEESE, KATELYN $45.71 SHARON, JEREMIAH $1,422.66 SMITH, BLAKE $241.10 SNYDER, ALLISON $699.68 SOFEN, NATASHA $34.56 SPARKS, WENDI $823.64 SPOSETO, MACKENZIE $1,991.76 SPRAGUE, MATTHEW $1,691.81 STEINKE, KURT $639.38 STEPHENS, CLINT $302.80 STEWARD, ERIC $1,835.38 STOTZ, MELISSA $916.08 SUETSUGU, SEAN $71.24 TERLOUW, KYLE $1,620.97 TETMEYER, CARL $491.95 THAYER, CHANDLER $823.67 THOMAS, JULIE $85 82 TIBBLES, STEVEN $1,529.38 TUEL, JASON $183.55 TYSDAL, THOMAS $2,426.95 VANDE KAMP, JOSHUA $1,667.51 VANROEKEL, DREW $684.75 Employee Name Salary VOEGTLE, TIMOTHY _ $1,449.63 VOKES, LARRY $1,719.86 WALLACE, ERIC $1,434.18 WARD, WILLIAM $414.69 WASKE, CHARLES $1,998.02 WAUGH, DOUGLAS $845.53 WEBSTER, JACKSON $329.24 WERNIMONT, THOMAS $357.47 WERTS, DANIEL $1,866.10 WESTON STOLL, KERI $1,522.02 WHITE, JASON $1,420.30 WHITE, LEAH $1,308.81 WIEDNER, TYLER $751.11 WIGGINS, MATHEW $1,818.74 WILSON, JODY $1,787.83 WINTERS, TROY $1,885.79 WISE, NATHAN $2,725.07 WOOD, DANIEL $1,537.95 WRIGHT, PAUL $849.54 WYZGOWSKI, JASMINE $109.13 YATES, CASSANDRA $435.99 YOUNG, BRIANNA $279.35