Loading...
HomeMy WebLinkAbout2018-01-02-J01A 01022018_bill list_payroll_correctionKP foeJ City of Waukee Bill Presentation Recap January 2, 2018 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 " Credit Card Detail also included in "D" Payroll Checks Issued: E) 12/15/2017 Grand Total: $1, 057,175.79 $459.11 $128,081.68 $98,606.99 $24,663.95 $210.404.71 a $1,519,392.23 �VOp FY 2018 Fund Recap: Expenditures Revenues Budgeted Year To Date Budgeted Year To Date 010 General Fund $ 11,299,192 $ 5.293,146 $ 11,301,210 $ 9.807,102 060 Road Use Tax Fund $ 2.151,246 $ 988,770 $ 2,122.000 $ 1,343,898 075 Waukee Foundation $ 447 $ 32,233 080 Library Foundation $ - $ - 085 Asset Forfeitures $ 755 $ 3,776 091 Hickman West Indust Park TIF $ 424.625 $ - $ 576,000 $ 306,281 092 Enterprise Business Park TIF Fund $ - $ 867 093 Waukee Urban Renewal Area TIF Fund $ 2,909,501 $ 31,153 $ 2,780,500 $ 1.475,795 094 Gateway Urban Renewal $ 2,601 $ 78,450 $ 42,781 095 Autumn Ridge Urban Renewal $ 246 $ 84,125 $ 42,217 096 Waukee West Urban Renewal $ 66,457 $ - 097 Southwest Business Park $ 3,941 $ 098 Waukee Central URA $ 2,885 $ - 110 Debt Service Fund $ 6,085,734 $ 858,444 $ 7,184,303 $ 1,727,953 111 Special Assessments Fund $ 47,006 $ 45,960 $ 34,200 $ 55,903 210 Employee Benefits Fund $ 1,802,000 $ - $ 1,801,935 $ 935,710 327 Capital Projects $ 12,640,000 $ 10.892.979 $ 11,550,000 $ 2,507,920 330 City Wide SA Sidewalk Project $ - $ 3,213 510 Water Utility Fund $ 4.231,652 $ 1,615,666 $ 4,441,570 $ 2,736,285 520 Sewer Utility Fund $ 16,329,351 $ 5,153,087 $ 4,048,100 $ 3,007,407 521 University Ave Trunk Sewer Project $ - $ 5,695 522 Waste Water Treatment PI $ $ 196 523 E Area Pump Sta Treatment $ - $ 688 540 Gas Utility Fund $ 5,565,596 $ 2,186,450 $ 4.951,010 $ 1,463,078 560 Storm Sewer Utility Fund $ 2,563.779 $ 602.018 $ 830,950 $ 380,912 570 Utility Bill Fund $ 274,090 $ 125,647 $ 224,100 $ 116,915 590 Solid Waste Collect & Rcycl Fund $ 1,211,000 $ 597,013 $ 1,250,900 $ 537,654 750 Golf Course Fund $ 533,455 $ 262,774 $ 610,300 $ 126,918 810 Equipment Revolving Fund $ - $ - $ 833 Total: $ 68,068,227 $ 28,730,438 $ 53,869,653 $ 26,662,228 City of Waukee FY2017 Department Report - General Fund As of JANUARY 2ND . 2018 Expended YTD Budgeted $ Remaining General Fund: Police Department Personnel Services $ 1,135,704 Supplies & Services $ 248,736 Capital Outlay $ 144,463 $ 1,528,903 $ 3,047,240 $ 1,518,337 Warning Sirens Personnel Services $ - Supplies & Services $ Capital Outlay $ $ - $ 2,000 $ 2,000 Westcom Dispatch Personnel Services $ - Supplies & Services $ 190,510 Capital Outlay $ - $ 190,510 $ 490,000 $ 299,490 Fire Department Personnel Services $ 412,563 Supplies & Services $ 64,537 Capital Outlay $ 36,009 $ 513,109 $ 1,227,170 $ 714,061 EMS Personnel Services $ 389,302 Supplies & Services $ 48,664 Capital Outlay $ - $ 437,966 $ 995,460 $ 557,494 Building Inspection Personnel Services $ 156,574 Supplies & Services $ 10,393 Capital Outlay $ - $ 166,968 $ 383,030 $ 216,062 Animal Control Personnel Services Supplies & Services $ 3,591 Capital Outlay $ 3,591 $ 11,000 $ 7,409 Library Services Personnel Services $ 282,234 Supplies & Services $ 122,489 Capital Outlay $ 34,102 $ 438,825 $ 942,105 $ 503,280 Mosquito Control Personnel Services $ - Supplies & Services $ Capital Outlay $ - $ - $ 7,500 $ 7,500 Parks Personnel Services $ 139,082 Supplies & Services $ 111,775 Capital Outlay $ 46,115 $ 296,972 $ 539,997 $ 243,025 Recreation Personnel Services $ 176,268 Supplies & Services $ 75,824 Capital Outlay $ - $ 252,092 $ 576,495 $ 324,403 Community Center Personnel Services $ 2,068 Supplies & Services $ 8,389 Capital Outlay $ - $ 10,458 $ 27,590 $ 17,132 Public Works Personnel Services $ 1,433 Supplies & Services $ (5,498) Capital Outlay $ $ (4,065) $ 65,091 $ 69,156 Public Works Building Personnel Services $ Supplies & Services $ 86,092 Capital Outlay $ - $ 86,092 $ - $ (86,092) Public Works Mechanic Personnel Services $ 84,262 Supplies & Services $ 70,594 Capital Outlay $ 14,147 $ 169,002 $ 193,950 $ 24,948 Median and Bldg Grounds Personnel Services Supplies & Services $ 7,403 Capital Outlay $ 7,403 $ 14,000 $ 6,598 Mayor & Council Personnel Services $ 17,870 Supplies & Services $ 13,987 Capital Outlay $ - $ 31,857 $ 72,840 $ 40,983 Elections Personnel Services $ - Supplies & Services $ 8,532 Capital Outlay $ - $ 8,532 $ 18,000 $ 9,468 Communications Personnel Services $ 16,684 Supplies & Services $ 3,812 Capital Outlay $ - $ 20,495 $ 109,585 $ 89,090 Administration Personnel Services $ 76,623 Supplies & Services $ 119,297 Capital Outlay $ 143 $ 196,062 $ 384,580 $ 188,518 City Hall Personnel Services $ - Supplies & Services $ 34,754 Capital Outlay $ 1,348 $ 36,101 $ 94,300 $ 58,199 Human Resources Personnel Services $ 29,992 Supplies & Services $ 45,952 Capital Outlay $ - $ 75,944 $ 93,080 $ 17,136 Financial Administration Personnel Services $ 51,231 Supplies & Services $ 17,757 Capital Outlay $ - Other Financing $ - $ 68,988 $ 205,350 $ 136,362 Community Development Personnel Services $ 75,064 Supplies & Services $ 54,801 Capital Outlay $ - $ 129,865 $ 335,940 $ 206,075 City Attorney Personnel Services $ - Supplies & Services $ 96,470 Capital Outlay $ - $ 96,470 $ 100,000 $ 3,530 Development Services Personnel Services $ 159,817 Supplies & Services $ 77,494 Capital Outlay $ - $ 237,311 $ 483,535 $ 246,224 Information Technology Personnel Services $ 33,383 Supplies & Services $ 1,321 Capital Outlay $ 52,068 $ 86,772 $ 199,253 $ 112,481 Engineering Personnel Services $ 160,836 Supplies & Services $ 29,052 GIS Capital Outlay Personnel Services Supplies & Services Capital Outlay Transfers to GO Debt Service Total General Fund: $ 14,882 $ (3,172) $ 5,324 Personnel Services $ 3,415,873 Supplies & Services $ 1,543,555 Capital Outlay $333,718.30 Other $ 189,888 $ 642,576 $ 452,688 17,034 $ 37,525 $ 20,491 $ 5,293,146 $11,299,192 $ 6,006,046 $ 5,293,146 Expense Approval Register City of Waukee, IAsh : APPKT00866 - JANUARY 3RD COUNCIL PACKET Waukee Vendor Name Payable Number Post Date Description (Item) Account Number Amount BANKERS TRUST COMPANY INV0004230 01/03/2018 JANUARY'17 SINKING FUND 110-1080100 569,650.00 BANKERS TRUST COMPANY INV0004230 01/03/2018 JANUARY'17 SINKING FUND 510-1080100 26,450.00 BANKERS TRUST COMPANY INV0004230 01/03/2018 JANUARY'17 SINKING FUND 520-1080100 16,350.00 BANKERS TRUST COMPANY INV0004230 01/03/2018 JANUARY'17 SINKING FUND 540-1080100 34,650.00 647,100.00 Department: 1100 - POLICE OPERATIONS DAVID OVERTON #104_2013B 12/01/2017 PRE -EMPLOYMENT POLYGR 010-10.1100.470000 800.00 MID AMERICAN ENERGY 000011217 12/15/2017 DECEMBER'17 STATEMENT 010-10.1100.480000 697.41 STRAUSS SAFE AND LOCK CO 1018513-000 11/30/2017 LOCK SERVICE 010-10.1100.400000 1,146.50 CITY OF URBANDALE 2018-40000157 12/24/2017 SERT REIMBURSEMENT 010-10.1100.470000 156.25 STIVERS FORD 202754 12/12/2017 RESET MAIN BREAKER 010-10.1100.410000 40.50 DESIGN ALLIANCE INC 205191 12/06/2017 PUBLIC SAFETY FACILITY STU 010-10.1100.230000 2,100.00 ELECTRONIC ENGINEERING C 220001704-1 12/04/2017 VEHICLE REPAIRS 7180 010-10.1100.410000 169.95 ELECTRONIC ENGINEERING C 225000292-1 12/04/2017 VEHICLE REPAIRS 7180 010-10.1100.410000 319.95 TABLE MOUNTAIN GROUP, L 2697 12/14/2017 TASERS 010-10.1100.540000 2,600.00 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 010-10.1100.100000 2,240.35 CARPENTER UNIFORM CO 454655 11/29/2017 STOCKING CAPS - TERLOW/G 010-10.1100.120000 158.56 CARPENTER UNIFORM CO 455358 12/11/2017 PANTS -J. LONG 010-10.1100.120000 74.99 CARPENTER UNIFORM CO 455434 12/12/2017 ULTRA LITES 8"SIDE -OAKLE 010-10.1100.120000 96.99 CARPENTER UNIFORM CO 455477 12/12/2017 PANTS-GITZEN 010-10.1100.120000 49.99 CARPENTER UNIFORM CO 455583 12/13/2017 JACKET/BELT -S. KINNEY 010-10.1100.120000 316.97 UNIVERSAL PRINTING SERVI 52342 11/30/2017 SHOP WITH A COP T-SHIRTS 010-10.1100.4030100 407.20 UNIVERSAL PRINTING SERVI 52422 12/11/2017 JACKET-CUNNINGHAM 010-10.1100.120000 46.75 ADECCO EMPLOYMENT SER 68841806 12/11/2017 CONTRACT LABOR- ESPINEL 010-10.1100.230000 393.60 ADECCO EMPLOYMENT SER 68853162 12/18/2017 CONTRACT LABOR - ESPINEL 010-10.1100.230000 314.88 NATIONWIDE OFFICE CLEAN 68893 12/15/2017 CLEANING SERVICES -POLIC 010-10.1100.400100 554.24 BOUND TREE MEDICAL 82700332 11/29/2017 GLOVES 010-30.1300.590000 33.99 VERIZON WIRELESS 9798040427 12/13/2017 DECEMBER'17 STATEMENT 010-10.1100.450000 956.35 HY-VEE INV0004215 12/11/2017 DECEMBER'17 STATEMENT 010-10.1100.570000 3,240.96 Department 1100 - POLICE OPERATIONS Total: 16,916.38 Department: 1400 - FIRE PROTECTION MID AMERICAN ENERGY 000011217 12/15/2017 DECEMBER'17 STATEMENT 010-10.1400.480000 462.24 DELTA DENTAL 33075000200201801 01/01/2018 JAN'19 DENTAL INSURANCE 010-10.1400.100000 543.97 KUM&GO 51828626 11/24/2017 NOVEMBER'17 STATEMENT 010-10.1400.570000 674.30 VERIZON WIRELESS 9798040427 12/13/2017 DECEMBER'17 STATEMENT 010-10.1400.450000 548.66 Department 1400 - FIRE PROTECTION Total: 2,229.17 Department: 1500 - EMS MID AMERICAN ENERGY 000011217 12/15/2017 DECEMBER'17 STATEMENT 010-10.1500.480000 462.24 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 010-10.1500.100000 543.96 KUM&GO 51828626 11/24/2017 NOVEMBER'17 STATEMENT 030-10.1500.570000 674.30 VERIZON WIRELESS 9798040427 12/13/2017 DECEMBER'17 STATEMENT 010-10.1500.450000 548.66 Department 1500 - EMS Total: 2,229.16 Department: 1600 - STREET LIGHTING IOWA SIGNAL INC 3724 12/04/2017 REPAIRED STREET LIGHT CAB 060-30:1600.410300 830.00 Department 1600 - STREET LIGHTING Total: 830.00 Department: 1601 - TRAFFIC SIGNALS MID AMERICAN ENERGY 120781217 12/18/2017 DECEMBER'17 STATEMENT 060-30.1601.480000 56.25 MID AMERICAN ENERGY 370081217 12/15/2017 DECEMBER'17 STATEMENT 060-30.1601.480000 37.82 IOWA SIGNAL INC 3720 12/04/2017 FIBER TESTING FOR CAMERA 060-30.1601.410300 145.00 MID AMERICAN ENERGY 540051217 12/15/2017 DECEMBER'17 STATEMENT 060-30.1601.480000 142.96 MID AMERICAN ENERGY 700061217 12/15/2017 DECEMBER'17 STATEMENT 060-30.1601.480000 68.15 Department 1601 - TRAFFIC SIGNALS Total: 450.18 12/28/2017 12:07:39 PM Page 1 of 10 Expense Approval Register Vendor Name Payable Number Department: 1900- BUILDING INSPECTION DELTA DENTAL 33075000200203 VERIZON WIRELESS 9798040427 HEARTLAND CO-OP INV0004225 Department: 2130 - ALICES ROAD PROJECT GATEHOUSE MEDIA IOWA H 0000232851 CONFLUENCE 14929 IOWASIGNALINC 3719 IOWA SIGNAL INC 3722 Department: 2131- ESKER RIDGE - RISE PROJECT CIVIL ENGINEERING CONSUL 0022810-IN Department: 2150 - PARK & REC COMPLEX CONFLUENCE 14783 FOTH INFRASTRUCTURE & E 53823 FOTH INFRASTRUCTURE & E 54773 FOTH INFRASTRUCTURE & E 54957 FOTH INFRASTRUCTURE & E 55009 Department: 3100 - LIBRARY SERVICES DELTA DENTAL 3307500020i MID AMERICAN ENERGY 520161217 VERIZON WIRELESS 9798040427 SHI INTERNATIONAL CORP B07347857 Department: 4100 - PARKS QUICK SUPPLY CO 0195682-IN FULLER PETROLEUM SERVIC 102642 AIRPORT SIGNS & GRAPHICS 20052 DELTA DENTAL 33075000201 DELTA DENTAL 33075000200201801 DELTA DENTAL 33075000201 BID] SIGNS BUSINESS DESIGN 34362 MULCH MART 43792 ELECTRICAL ENGINEERING E 5280248-00 ELECTRICAL ENGINEERING E 5280259-00 TRUGREEN 76014498 VERIZON WIRELESS 9798040427 HEARTLAND CO-OP INV0004234 Department: 4200 - RECREATION DELTA DENTAL 3307500020 VERIZON WIRELESS 9798040427 HEARTLAND CO-OP INV0004233 Department: 4300 - COMMUNITY CENTER ORKIN PEST CONTROL 164880770 AMAZON.COM LLC 1KFV-9PFY-7HFW AMAZON.COM LLC 1RGT-D3LL-DQQP MENARDS 4166 NATIONWIDE OFFICE CLEAN 68892 MEDIACOM 83849302700901181217 Department: 5300 - STORM WATER G & L CLOTHING 2-184839 G & L CLOTHING 2-184840 Packet: APPKT00866 - JANUARY 3RD COUNCIL PACKET Post Date Description (Item) Account Number Amount 01/01/2018 JAN'18 DENTAL INSURANCE 010-10.1900.100000 311.86 12/13/2017 DECEMBER'17 STATEMENT 010-10.1900.450000 276.60 11/30/2017 NOVEMBER'17 STATEMENT 010-10.1900.570000 223.54 Department 1900 - BUILDING INSPECTION Total: 812.00 11/26/2017 NOVEMBER'17 STATEMENT 327-90.2130.840491 116.88 11/30/2017 PLANNING ADDENDUM 5 327-90.2130.840470 1,129.88 12/04/2017 REPAIR FIBER REPLACE HAN 327-90.2130.840490 1,616.40 12/04/2017 MAINTENANCE ON TEMPOR 327-90,2130.840490 1,200.00 Department 2130 - ALICES ROAD PROJECT Total: 4,063.16 11/17/2017 SE ESKER RIDGE DRIVE 327-90.2131.230051 633.00 Department 2131- ESKER RIDGE - RISE PROJECT Total: 633.00 10/26/2017 WAUKEE SCHOOLS CITY SITE 327-90.2150.980110 10,502.47 09/06/2017 HIGH SCHOOL NO.2/CITY RE 327-90.2150.980110 18,079.00 11/20/2017 HIGH SCHOOL NO 2/CITY RE 327-90.2150.980110 4,564.00 12/06/2017 SCHOOL CAMPUS ENVIROM 327-90.2150.980110 4,006.00 12/08/2017 WAUKEE HIGH SCHOOL NO. 327-90.2150.980110 19,068.00 Department 2150 - PARK & REC COMPLEX Total: 56,219.47 O1/01/2018 JAN'18 DENTAL INSURANCE 010-40.3100.100000 540.66 12/15/2017 DECEMBER'17 STATEMENT 010-40.3100.480000 2,558.47 12/13/2017 DECEMBER'17 STATEMENT 010-40.3100.450000 52.19 11/09/2017 USB CHARGING PORTS 010-40.3100.540000 356.00 Department 3100 - LIBRARY SERVICES Total: 3,507.32 12/08/2017 160N MIRAFI 15'X300' 010-40,4100.410300 310.00 12/06/2017 FUEL 010-40.4100.570000 253.01 12/14/2017 PARKS & REC TRUCK DECALS 010-40.4100.540000 175.00 O1/O1/2018 JAN'18 DENTAL INSURANCE 010-40.4100.100000 24.76 O1/01/2018 JAN'18 DENTAL INSURANCE 010-40.4100.100000 123.78 O1/01/2018 JAN'18 DENTAL INSURANCE 010-40.4100.100000 32.15 12/16/2017 ICE RINK SIGNS 010-40.4100.540000 50.00 11/29/2017 TOWABLE LIFT 010-40.4100.390000 195.00 12/12/2017 GEL 010-40.4100.410300 169.25 12/12/2017 GEL 010-40.4100.410300 52.16 10/26/2017 LAWN SERVICES - TRIANGLE 010-40.4100.590100 36.75 12/13/2017 DECEMBER'17 STATEMENT 010-40.4100.450000 135.48 11/30/2017 NOVEMBER'17 STATEMENT 010-40.4100.570000 528.35 Department 4100 - PARKS Total: 2,085.69 O1/01/2018 JAN'18 DENTAL INSURANCE 010-40.4200.100000 279.71 12/13/2017 DECEMBER'17 STATEMENT 010-40.4200.450000 199.74 11/30/2017 NOVEMBER'17 STATEMENT 010-40.4200.570000 157.71 Department 4200 - RECREATION Total: 637.16 12/18/2017 PEST CONTROL - COMMUNI 010-40.4300.400000 58.44 12/13/2017 LAMP BULB 010-40.4300.540000 78.33 12/13/2017 LAMP BULB 010-40.4300.540000 78.33 12/11/2017 STEPLADDER/DOOR CHAIN 010-40.4300.540000 244.38 12/15/2017 CLEANING SERVICES -COM 010-40.4300.400100 298.77 12/07/2017 DECEMBER'17 SATEMENT- 010-40,4300.480000 63.57 Department 4300 - COMMUNITY CENTER Total: 821.82 12/04/2017 PANTS - TIBBLES 560-80.5300.120000 150.00 12/04/2017 BIBS/PANTS - ENNETT 560-80.5300.120000 274.44 12/28/2017 12:07:39 PM Page 2 of 10 Expense Approval Register Vendor Name Payable Number Post Date DELTA DENTAL 33075000200201801 01/01/2018 DELTA DENTAL 33075000200201801 01/01/2018 FOTH INFRASTRUCTURE& E 54954 12/06/2017 VERIZON WIRELESS 9798040427 12/13/2017 Department: 5400-SOLID WASTE COLLECTION & DISPOSAL ANKENY SANITATION INC. 463474 12/01/2017 Department: 6000 - PUBLIC WORKS AMAZON.COM LLC 1GQC-79MN-XRW6 DELTA DENTAL 33075000200201801 VERIZON WIRELESS 9798040427 Department: 6010 - PUBLIC WORKS BUILDING HOTSY CLEANING SYSTEMS, I 0176742-IN MID AMERICAN ENERGY 240001217 MIDWEST ALARM SERVICES 282360 SUPPLYWORKS 420871584 TECH 24-COMMERCIAL FO 5044548 HILLYARD INC 602798420 NATIONWIDE OFFICE CLEAN 68351 PRAXAIR DISTRIBUTION #44 80200275 CONSOLIDATED COMMUNIC INV0004220 AT&T MOBILITY X12082017 Department: 6150 - PUBLIC WORKS MECHANIC SPRAYER SPECIALTIES INC 1012687-IN MIDWEST WHEEL COMPANI 1022582-00 GRAHAM TIRE OF DES MOIN 1100099478 CFI SALES INC 253459 DELTA DENTAL 33075000200201801 ADEL AUTO PARTS 368982 CAPITALCITY EQUIPMENTC 82322D CAPITALCITY EQUIPMENTC 82339D MURPHY TRACTOR & EQUIP 859717 LAWSON PRODUCTS INC 9305418191 VERIZON WIRELESS 9798040427 Department: 6510- WATER UTILITY GATEHOUSE MEDIA IOWA H 0000232858-12012017 MUNICIPAL SUPPLY, INC. 0679692-IN FULLER PETROLEUM SERVIC 102642 MIDAMERICAN ENERGY 130091217 UNIVERSITY OF IOWA HYGIE 125538 IOWA ONE CALL 197038 IOWA RURAL WATER ASSOC[ 30284 IOWA RURAL WATER ASSOC[ 30285 DELTA DENTAL 33075000200201801 DELTA DENTAL 33075000200201801 DELTA DENTAL 33075000200201801 DELTA DENTAL 33075000200201801 VERIZON WIRELESS 9798040427 WEST DES MOINES WATER INV0004231 Department: 6520 - SANITARY SEWERS & TREATMENT WASTEWATER RECLAMATIO 100162 FULLER PETROLEUM SERVIC 102642 MID AMERICAN ENERGY 200061217 Packet: APPKT00866 - JANUARY 3RD COUNCIL PACKET Description (item) Account Number Amount JAN'18 DENTAL INSURANCE 560-80.5300.100000 279.71 JAN'18 DENTAL INSURANCE 560-80.5300.100000 38.98 CENTENNIAL PARK STREAM 560-80.5300.880015 668.20 DECEMBER'17 STATEMENT 560-80.5300.450000 346.62 Department 5300-STORM WATER Total: 1,757.95 DECEMBER'17 STATEM ENT 590-30.5400.231300 91,363.14 Department 5400 - SOLID WASTE COLLECTION & DISPOSAL Total: 91,363.14 12/20/2017 ]PAD KEYBOARD CASE 010-20.6000.540000 99.99 01/01/2018 JAN'18 DENTAL INSURANCE 010-20.6000.100000 436.89 12/13/2017 DECEMBER'17 STATEMENT 010-20.6000.450000 210.44 Department 6000 - PUBLIC WORKS Total: 747.32 12/05/2017 PUMP/OILCHANGE 010-20.6010.410100 209.10 12/15/2017 DECEMBER'17STATEMENT 010-20.6010.480000 1,316.51 12/08/2017 SERVICE CALL/PARTS 010-20.6010.400000 198.78 11/29/2017 LINERS 010-20,6010.580000 169.56 12/05/2017 PREVENTATIVE MAINTENAN 010-20.6010.400000 369.00 12/06/2017 SOAP 010-20.6010.590000 99.14 11/30/2017 STRIP & WAX ALL VCT 010-20.6010.400100 2,240.00 11/30/2017 CYLINDER 010-20.6010.590000 67.43 12/01/2017 DECEMBER'17 STATEMENT 010-20.6010.450000 167.63 12/08/2017 DECEMBER'17 STATEMENT 010-20.6010.450000 58.13 Department 6010 - PUBLIC WORKS BUILDING Total: 4,895.28 12/04/2017 SUPER SPRAYER 010-20.6150.590000 55.02 12/05/2017 WORKLAMP 010-20.6150.570130 221.52 11/27/2017 TIRES 010-20.6150.570130 478.72 11/30/2017 AXLE CHANGE 010-20.6150.570130 380.50 01/01/2018 JAN'18 DENTAL INSURANCE 010-20.6150.100000 155.93 12/05/2017 OIL FILTERS 010-20.6150.570110 191.76 12/05/2017 NOZZLE 010-20.6150.570130 6.19 12/06/2017 SPRING GAS 010-20.6150.570130 35.51 12/11/2017 HY-GARD TM/OIL FILTER/BO 010-20.6150.570130 236.05 11/29/2017 WEATHERPACK/HEAT SHRIN 010-20.6150.590000 128.25 12/13/2017 DECEMBER'17 STATEMENT 010-20.6150.450000 71.16 Department 6150 - PUBLIC WORKS MECHANIC Total: 1,960.61 11/26/2017 NOVEMBER'17 STATEMENT 510-30.6510.210000 66.58 12/08/2017 METER 510-30.6510.592000 14,112.00 12/06/2017 FUEL 510-30.6510.570000 253.01 12/22/2017 DECEMBER'17 STATEMENT 510-30.6510.480000 12.98 11/30/2017 ANALYSIS 510-30.6510.250000 760.00 12/11/2017 NOVEMBER'17 STATEMENT 510-30.6510.340000 428.90 12/11/2017 43RD ANNUALCONF.-JOHN 510-30.6510.470000 350.00 12/11/2017 43RD ANNUAL CONF. -TIMR 510-30.6510.470000 350.00 01/01/2018 JAN'18 DENTAL INSURANCE 510-30.6510.100000 126.82 01/01/2018 JAN'18 DENTAL INSURANCE 510-30.6510.100000 65.55 01/01/2018 JAN'18 DENTAL INSURANCE 510-30.6510.100000 38.98 01/01/2018 JAN'18 DENTAL INSURANCE 510-30.6510.100000 61.89 12/13/2017 DECEMBER'17 STATEMENT 510-30.6510.450000 213.55 01/03/2018 JANUARY'18 WATER TOWER 510-30.6510.390300 419.18 Department 6510 - WATER UTILITY Total: 17,259.34 01/01/2018 JANUARY'18 FEES 520-30.6520.882700 112,440.00 12/06/2017 FUEL 520-30,6520.570000 253.01 12/15/2017 DECEMBER'17 STATEMENT 520-30.6520,480000 140.92 12/28/2017 12:07:39 PM Page 3 of 10 Expense Approval Register Packet: APPKT00866-JANUARY 3RD COUNCIL PACKET Vendor Name Payable Number Post Date Description (Item) Account Number Amount DELTA DENTAL 33075000200201801 O1/01/2018 JAN'18 DENTAL INSURANCE 520-30.6520.100000 126.82 DELTA DENTAL 33075000200201801 01/01/2019 JAN'18 DENTAL INSURANCE 520-30.6520.100000 131.10 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 520-30.6520.100000 38.98 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 520-30.6520.100000 61.89 VERIZON WIRELESS 9798040427 12/13/2017 DECEMBER'17 STATEMENT 520-30.6520.450000 249.15 CENTURYLINK INV0004216 12/10/2017 DECEMBER'17 STATEMENT 520-30.6520.450000 48.39 BEAR CREEK ARCHEOLOGY, I INV0004218 12/07/2017 ARCHEOLOGICAL INVESTIGA 520-30.6520.883095 12,095,50 Department 6520 - SANITARY SEWERS & TREATMENTTotal: 125,585.76 Department: 6540 - GAS UTILITY GATEHOUSE MEDIA IOWA H 0000232858-12012017 11/26/2017 NOVEMBER'17 STATEMENT 540-30.6540.880181 31.61 FULLER PETROLEUM SERVIC 102642 12/06/2017 FUEL 540-30.6540.570000 253.00 MID AMERICAN ENERGY 110091217 12/22/2017 DECEMBER'17 STATEMENT 540-30.6540.480000 12.88 IOWA ONE CALL 197038 12/11/2017 NOVEMBER'17 STATEMENT 540-30.6540.340000 428.90 INFRASOURCE CONSTRUCTI 3021279 12/15/2017 I-80 INDUSTRIAL PARK/WEST 540-30.6540.880100 13,405.64 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 540-30.6540.100000 61.89 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 540-30.6540.100000 444.99 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 540-30.6540.100000 38.98 MIDWEST ENERGY ASSOCIAT 7281365 11/30/2017 2018 GAS MEMBER DUES 540-30.6540.280000 1,609.30 BORDER STATES ELECTRIC S 914292675 12/05/2017 PARTS 540-30.6540.880181 249.34 BORDER STATES ELECTRIC S 914302368 12/06/2017 TRACER/FASTNER RIVET/PAR 540-30.6540.590100 859.12 BORDER STATES ELECTRIC S 914311558 12/07/2017 U-CHANNEL PC 3/81N HOLE 540-30.6540.590000 40.86 VERIZON WIRELESS 9798040427 12/13/2017 DECEMBER'17 STATEMENT 540-30.6540,450000 267.70 INDUSTRIAL SALES COMPAN 986907-000 07/29/2017 WIRE/TAPE 540-30.6540.590200 1,589.52 INDUSTRIAL SALES COMPAN 997212-000 11/30/2017 HIGHLINE VB/WIRE/TAPE 540-30.6540.590200 3,647.38 INDUSTRIAL SALES COMPAN 998047-000 12/07/2017 KEROTEST POLYBALL 540-30.6540.590200 309.82 FASTENAL COMPANY IAGRM91044 11/30/2017 PARTS 540-30.6540.590000 408.37 BLACK HILLS ENERGY INV0004219 12/06/2017 DECEMBER'17 STATEMENT 540-30.6540.650000 2,891.25 GEORGE GREER INV0004222 01/03/2018 FURNACE & THERMOSTAT R 540-30.6540.685400 105.00 DAVID& JACQUELINE MOLE INV0004227 01/03/2018 FURNACE & THERMOSTAT R 540-30.6540.685400 105.00 WEST DES MOINES WATER INV0004231 01/03/2018 JANUARY'18 WATER TOWER 540-30.6540.390300 419.17 Department 6540 - GAS UTILITY Total: 27,179.72 Department: 6550- UTILITY BILLING TYLER TECHNOLOGIES INC 025-210152 01/O1/2018 ONLINE UTILITY BILLING JAN 570-30.6550,450200 175.00 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 570-30.6550.100000 97.70 PURCHASE POWER, INC. INV0004232 12/24/2017 PERMIT OVERAGE FEE 570-30.6550.360000 25.20 PURCHASE POWER, INC. INV0004232 12/24/2017 NOV'17 BILLS 570-30.6550.360000 1,847.79 PURCHASE POWER, INC. INV0004232 12/24/2017 NOV'17 ACH BILLS 570-30.6550.360000 919.59 Department 6SS0 - UTILITY BILLING Total: 3,065.28 Department: 7100 - STREETS FULLER PETROLEUM SERVIC 102642 12/06/2017 FUEL 060-30.7100.570000 253.01 LOGOED APPAREL & PROMO 16370 12/08/2017 JACKETS - WERTS&SHARON 060-30.7100.120000 107.98 AIRPORT SIGNS & GRAPHICS 20230 12/13/2017 PUBLIC WORKS VEHICLE GRA 060-30.7100.540000 175.00 G&LCLOTH ING 2-185044 12/08/2017 JACKET/BIBS - STEWARD 060-30.7100.120000 251.97 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 060-30.7100.100000 61.89 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 060-30.7100.100000 12.38 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 060-30.7100.100000 527.27 SMITH FERTILIZER GRAIN 4005287 12/07/2017 BEETS+ 060-30.7100.591300 1,584.68 VERIZON WIRELESS 9798040427 12/13/2017 DECEMBER'17 STATEMENT 060-30.7100.450000 189.58 VERIZON WIRELESS 9798040427 12/13/2017 DECEMBER'17 STATEMENT 060-30.7100.590600 80.06 Department 7100 - STREETS Total: 3,243.82 Department: 8100 - MAYOR & COUNCIL CITY OF DES MOINES 100283 12/13/2017 METRO ADVISORY COUNCIL 010-60.8100.280000 250.00 UNIVERSAL PRINTING SERVI 52621 12/15/2017 POSTERS FOR COUNCIL CHA 010-60.8100.540000 167.50 GREATER DES MOINES PART 801-2510 12/15/2017 ANNUAL DINNER TABLE 010-60.8100.470000 1,500.00 AAA AWARDS & EMBROIDER 8961 12/14/2017 PLAQUE 010-60.8100.580000 161.00 AMERICAN TELECONFERENC INV0004228 11/30/2017 NOVEMBER'17 STATEMENT 010-60.8100.450000 11.61 Department 8100 - MAYOR & COUNCILTotal: 2,090.11 12/28/2017 12:07:39 PM Page 4 of 10 Expense Approval Register Vendor Name Payable Number Post Date Department: 8200 - COMMUNICATIONS DELTA DENTAL 33075000200201801 01/01/2018 Department: 8300 - ADMINISTRATION GATEHOUSE MEDIA IOWA H 0000232858-12012017 11/26/2017 SESAC, INC 10151100 12/14/2017 LYLE SUMEK ASSOCIATES IN 17-0815 12/18/2017 DELTA DENTAL 33075000200201801 01/01/2018 MID AMERICAN ENERGY 480551217 12/18/2017 MID AMERICAN ENERGY 490531217 12/15/2017 MEDIACOM 83839302700067921217 12/05/2017 VERIZON WIRELESS 9798040427 12/13/2017 OFFICE DEPOT 987275530001 12/07/2017 OFFICE DEPOT 988581037001 12/12/2017 OFFICE DEPOT 988581128001 12/12/2017 OFFICE DEPOT 989428697001 12/14/2017 DES MOINES REGISTER INV0004221 01/03/2018 AMERICAN SOCIETY OF COM INV0004235 12/20/2017 ACCESS SYSTEMS INV575938 12/13/2017 Department: 8310 - CITY HALL MID AMERICAN ENERGY 030891217 12/15/2017 MID AMERICAN ENERGY 070651217 12/15/2017 MENARDS 2678 11/27/2017 MENARDS 4437 12/13/2017 ELECTRICAL ENGINEERING E 5255357-00 11/15/2017 NATIONWIDE OFFICE CLEAN 68891 12/15/2017 DRYWALL REPAIR SERVICE, L 747 12/13/2017 SELVAGE PLUMBING 8495 12/15/2017 WAUKEE HARDWARE & VARI INV0004229 11/30/2017 Department: 8350 - HUMAN RESOURCES DELTA DENTAL 33075000200201801 01/01/2018 VERIZON WIRELESS 9798040427 12/13/2017 Department: 8400 - FINANCIAL ADMINISTRATION Packet: APPKT00866 - JANUARY 3RD COUNCIL PACKET Description (Item) Account Number Amount JAN'18 DENTAL INSURANCE 010-60.8200.100000 123.78 Department 8200 - COMMUNICATIONS Total: 123.78 NOVEMBER'17 STATEMENT 010-60.8300.210000 830.23 2018 MUSIC LICENSE 010-60.8300.280000 417.00 STRATEGIC PLANNING FOLL 010-60.8300.230000 7,000.00 JAN'18 DENTAL INSURANCE 010-60.8300.100000 189.33 18178 U AVE (FARMHOUSE 010-60.8300,390400 8.50 DECEMBER'17 STATEMENT 010-60.8300.390400 11.85 DECEMBER'17 STATEMENT 010-60.8300,270000 13.29 DECEMBER'17 STATEMENT 010-60.8300.450000 52.19 PAPER 010-60.8300,580000 150.80 BATTERIES 010-60.8300.580000 20.18 BATTERIES 010-60.8300.580000 17.59 BATTERIES 010-60.8300.580000 20.18 MON.- SAT. SUBSCRIPTION 010-60.8300.280000 25.00 '18 MUSIC LICENSE 010-60.8300.280000 348.00 STAPLES 010-60.8300.580000 107.99 Department 8300 -ADMINISTRATION Total: 9,212.13 DECEMBER'17 STATEMENT 010-60.8310.480000 139.53 236 W HICKMAN (OLD CHA 010-60.8310.480000 27.62 PRELITGARLAND 010-60.8310.590000 31.18 PAINT/PRIMER/ENTRY MAT/ 010-60.8310.832000 357.55 LED WIDE FLOOD LIGHT 010-60.8310.400000 450.00 CLEANING SERVICES -CITYH 010-60.8310.400100 597.54 DRYWALL SERVICES -IT/HR 010-60.8310.832000 990.00 REPAIR BROKEN VENT 010-60.8310.400000 193.50 NOVEMBER'17 STATEMENT 010-60.8310,590000 17.77 Department 8310 - CITY HALL Total: 2,804.69 JAN'18 DENTAL INSURANCE 010-60.8350.100000 32.15 DECEMBER'17 STATEMENT 010-60.8350.450000 101.33 Department 8350 - HUMAN RESOURCES Total: 133.48 GATEHOUSE MEDIA IOWA H 0000232858-12012017 11/26/2017 NOVEMBER'17 STATEMENT 010-60.8400.210000 175.89 TYLER TECHNOLOGIES INC 025-209680 01/01/2018 CONTENT MANAGER FEB'18 010-60.8400.270000 1,846.83 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 010-60.8400.100000 221.48 VERIZON WIRELESS 9798040427 12/13/2017 DECEMBER'17 STATEMENT 010-60.8400.450000 92.20 ACCESS SYSTEMS INV577395 12/19/2017 BLACKTONER 010-60.8400.580000 143.47 Department 8400 - FINANCIAL ADMINISTRATION Total: 2,479.87 Department: 8500 - COMMUNITY DEVELOPMENT DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 010-50.8500.100000 65.55 FOTH INFRASTRUCTURE & E 54964 12/06/2017 MAPLE GROVE PLACE AT KET 010-50.8500.230000 2,592.84 VERIZON WIRELESS 9798040427 12/13/2017 DECEMBER'17 STATEMENT 010-50.8500.450000 52.19 Department 8500 - COMMUNITY DEVELOPMENT Total: 2,710.58 Department: 8700 - DEVELOPMENT SERVICES HOISINGTON KOEGLER GRO 016-056-13 11/10/2017 WAUKEE COMPREHENSIVE P 010-50,8700.230000 8,083.89 HOISINGTON KOEGLER GRO 016-056-14 12/09/2017 WAUKEE COMPREHENSIVE P 010-50.8700.230000 10,689.04 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 010-50.8700.100000 279.71 VERIZON WIRELESS 9798040427 12/13/2017 DECEMBER'17 STATEMENT 010-50.8700.450000 104.38 Department 8700 - DEVELOPMENT SERVICES Total: 19,157.02 Department: 8750 - SUGAR CREEK MUNICIPAL G & LCLOTHING 2-185058 12/09/2017 JEANS/BOOTS -J. CARROLL 750-80,8750.120000 332.48 G & LCLOTHING 2-185265 12/14/2017 RETURN BOOTS -J. CARROLL 750-80,8750.120000 -21.25 DELTA DENTAL 33075000200201801 01/01/2018 JAN'18 DENTAL INSURANCE 750-80.8750.100000 86.65 VERIZON WIRELESS 9798040427 12/13/2017 DECEMBER'17 STATEMENT 750-80.8750.450000 299.29 12/28/2017 12:07:39 PM Page 5 of 10 Expense Approval Register Vendor Name Payable Number OFFICE DEPOT 985199014001 OFFICE DEPOT 985240537001 CENTURYLINK INV0004217 Department: 8800 - INFORMATION TECHNOLOGY DELTA DENTAL 33075000200201801 Department: 8900 - ENGINEERING LOGOED APPAREL & PROMO 16370 DELTA DENTAL 33075000200201801 VERIZON WIRELESS 9798040427 HEARTLAND CO-OP INV0004224 Department: 8950 - GIS DELTA DENTAL VERIZON WIRELESS HEARTLAND CO-OP 33075000200201801 9798040427 INV0004223 Packet: APPKT00866 - JANUARY 3RD COUNCIL PACKET Post Date Description (Item) Account Number Amount 11/30/2017 PAPER/MARKERS 750-80.8750.580000 56.56 11/30/2017 LAMINATING POUCHES 750-80.8750.580000 8.31 12/10/2017 DECEMBER'17 STATEMENT 750-80.8750.450000 209.28 Department 8750 - SUGAR CREEK MUNICIPAL Total: 971.32 O1/01/2018 JAN'18 DENTAL INSURANCE 010-60.8800.100000 123.78 Department 8800 - INFORMATION TECHNOLOGY Total: 123.78 12/08/2017 JACKETS - WERTS & SHARON 010-20.8900.120000 107.98 01/O1/2018 JAN'18 DENTAL INSURANCE 010-20.8900.100000 311.86 12/13/2017 DECEMBER'17 STATEMENT 010-20.8900.450000 375.79 11/30/2017 NOVEMBER'17 STATEMENT 010-20.8900.570000 792.20 Department 8900 - ENGINEERING Total: 1,587.83 O1/01/2018 JAN'18 DENTAL INSURANCE 010-20.8950.100000 32.15 12/13/2017 DECEMBER'17 STATEMENT 010-20.8950.450000 77.24 11/30/2017 NOVEMBER'17 STATEMENT 010-20.8950.570000 79.08 Department 8950 - GIS Total: 188.47 Grand Total: 1,057,175.79 12/28/2017 12:07:39 PM Page 6 of 10 Expense Approval Register Packet: APPKTOO866 - JANUARY 3RD COUNCIL PACKET Fund Summary Fund Expense Amount 010- GENERAL FUND 77,453.65 060 - ROAD USE TAX FUND 4,524.00 110- DEBT SERVICE FUND 569,650.00 327 - CAPITAL PROJECTS 60,915.63 510- WATER UTILITY FUND 43,709.34 520- WASTE WATER UTILITY FUND 141,935.76 540 - GAS UTILITY FUND 61,829.72 560 - STORM WATER UTILITY FUND 1,757.95 570 - UTILITY BILL FUND 3,065.28 590 - SOLID WASTE COLLECT & RCY 91,363.14 750 - GOLF COURSE FUND 971.32 Grand Total: 1,057,175.79 Account Summary Account Number Account Name Expense Amount 010-10.1100.100000 HEALTH & LIFE INSURAN 2,240.35 010-10.1100.120000 UNIFORMS 744.25 010-10.1100.230000 CONSULTANT & PROFES 2,808.48 010-10.1100.400000 REPAIR/MAINTENANCE 1,146.50 010-10.1100,400100 CUSTODIAL 554.24 010-10.1100.4030100 COMMUNITY POLICING/ 407.20 010-10.1100.410000 REPAIR OF VEHICLES 530.40 010-10.1100.450000 TELEPHONE 956.35 010-10.1100.470000 TRAINING/TRAVEL EXPE 956.25 010-10.1100.480000 UTILITY SERVICES 697.41 010-10.1100.540000 MINOR EQUIPMENT 2,600.00 010-10.1100.570000 FUEL 3,240.96 010-10.1100.590000 OPERATING SUPPLIES & 33.99 010-10.1400.100000 HEALTH & LIFE INSURAN 543.97 010-10.1400,450000 TELEPHONE 548.66 010-10.1400.480000 UTILITY SERVICES 462.24 010-10.1400.570000 FUEL 674.30 010-10.1500.100000 HEALTH & LIFE INSURAN 543.96 010-10.1500.450000 TELEPHONE 548.66 010-10.1500.480000 UTILITY SERVICES 462.24 010-10.1500.570000 FUEL 674.30 030-10.1900.100000 HEALTH & LIFE INSURAN 311.86 010-10.1900.450000 TELEPHONE 276.60 010-10.1900.570000 FUEL 223.54 010-20.6000.100000 HEALTH & LIFE INSURAN 436.89 010-20.6000.450000 TELEPHONE 210.44 010-20,6000.540000 MINOR EQUIPMENT 99.99 010-20.6010.400000 REPAIR/MAINTENANCE 567.78 010-20.6010.400100 CUSTODIAL SERVICES 2,240.00 010-20.6010.410100 REPAIR/MAINTENANCE 209.10 010-20.6010.450000 TELEPHONE 225.76 010-20.6010.480000 UTILITY SERVICES 1,316.51 010-20.6010.580000 OFFICE SUPPLIES 169.56 010-20.6010.590000 OPERATING SUPPLIES& 166.57 010-20.6150.100000 HEALTH & LIFE INSURAN 155.93 010-20.6150,450000 TELEPHONE 71.16 010-20.6150.570110 COGS -FILTERS 191.76 010-20.6150.570130 COGS - PARTS 1,358.49 010-20.6150.590000 OPERATING SUPPLIES & 183.27 010-20.8900.100000 HEALTH & LIFE INSURAN 311.86 010-20.8900.120000 UNIFORMS 107.98 010-20.8900.450000 TELEPHONE 375.79 010-20.8900.570000 FUEL 792.20 010-20.8950.100000 HEALTH & LIFE INSURAN 32.15 12/28/2017 12:07:39 PM Page 7 of 10 Expense Approval Register Packet: APPKT00866-JANUARY 3RD COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 010-20.8950A50000 TELEPHONE 77.24 010-20.8950.570000 FUEL 79.08 010-40.3100.100000 HEALTH & LIFE INSURAN 540,66 010-40.3100.450000 TELEPHONE 52.19 010-40.3100.480000 UTILITY SERVICES 2,558.47 010-40.3100.540000 MINOR EQUIPMENT 356.00 010-40.4100.100000 HEALTH & LIFE INSURAN 180.69 010-40.4100.390000 RENTAL/LEASE OF EQUI 195.00 010-40.4100.410300 REPAIR/MAINTENANCE 531.41 010-40.4100.450000 TELEPHONE 135.48 010-40.4100.540000 MINOR EQUIPMENT 225.00 010-40.4100.570000 FUEL 781.36 010-40.4100.590100 CHEMICAL/FERTILIZER 36.75 010-40.4200.100000 HEALTH & LIFE INSURAN 279.71 010-40.4200.450000 TELEPHONE 199.74 010-40.4200.570000 FUEL 157.71 010-40.4300.400000 REPAIR/MAINTENANCE 58.44 010-40.4300.400100 CUSTODIAL SERVICES 298.77 010-40A300.480000 UTILITY SERVICES 63.57 010-40.4300.540000 MINOR EQUIPMENT 401.04 010-50.8500.100000 HEALTH & LIFE INSURAN 65.55 010-50.8500.230000 CONSULTANT & PROFES 2,592.84 010-50.8500.450000 TELEPHONE 52.19 010-50.8700.100000 HEALTH & LIFE INSURAN 279.71 010-50.8700.230000 CONSULTANT&PROFES 18,772.93 010-50.8700.450000 TELEPHONE 104.38 010-60.8100.280000 DUES, MEMBERSHIPS & 250.00 010-60.8100.450000 TELEPHONE 11.61 010-60.8100.470000 TRAINING/TRAVEL EXPE 1,500.00 010-60.8100.540000 MINOR EQUIPMENT 167.50 010-60.8100.580000 OFFICE SUPPLIES 161.00 010-60.8200.100000 HEALTH & LIFE INSURAN 123.78 010-60.8300.100000 HEALTH & LIFE INSURAN 189.33 010-60.8300.210000 PUBLIC NOTIFICATION/A 830.23 010-60.8300.230000 CONSULTANT&PROFES 7,000.00 010-60.8900.270000 DATA PROCESSING 13.29 010-60.8300.280000 DUES, MEMBERSHIPS & 790.00 010-60.8300.390400 NORTHVIEW RENTAL PR 20.35 010-60.8300.450000 TELEPHONE 52.19 010-60.8300.580000 OFFICE SUPPLIES 316,74 010-60.8310.400000 REPAIR/MAINTENANCE 643.50 010-60.8310.400100 CUSTODIAL SERVICES 597.54 010-60.8310.480000 UTILITY SERVICES 167.15 010-60.8310.590000 OPERATING SUPPLIES& 48.95 010-60.8310.832000 PROFESSIONAL PLAZA B 1,347.55 010-60.8350.100000 HEALTH & LIFE INSURAN 32.15 010-60.8350.450000 TELEPHONE 101.33 010-60.8400.100000 HEALTH & LIFE INSURAN 221.48 010-60.8400.210000 PUBLIC NOTIFICATION/A 175.89 010-60.8400.270000 DATA PROCESSING 1,846.83 010-60.8400,450000 TELEPHONE 92.20 010-60.8400.580000 OFFICE SUPPLIES 143.47 010-60.8800.100000 HEALTH & LIFE INSURAN 123.78 060-30.1600.410300 REPAIR/MAINTENANCE 830.00 060-30.1601.410300 REPAIR/MAINTENANCE 145.00 060-30.1601.480000 UTILITY SERVICES 305.18 060-30.7100.100000 HEALTH & LIFE INSURAN 601.54 060-30.7100.120000 UNIFORMS 359.95 12/28/2017 12:07:39 PM Page 8 of 10 Expense Approval Register Packet: APPKT00866 - JANUARY 3RD COUNCIL PACKET Account Summary Account Number Account Name Expense Amount 060-30.7100.450000 TELEPHONE 189.58 060-30.7100.540000 MINOR EQUIPMENT 175.00 060-30.7100.570000 FUEL 253.01 060-30.7100.590600 STREETSIGNS 80.06 060-30.7100.591300 CALCIUM CHLORIDE 1,584.68 110-1080100 MONEY MARKET -BANKS 569,650.00 327-90.2130.840470 ALICES RD-ENHANCE AS 1,129.88 327-90.2130.840490 ALICES RD -UNIV TO OL 2,816.40 327-90.2130.840491 ALICES ROAD - OLSON T 116.88 327-90.2131.230051 CONSULTING -ESKER RID 633.00 327-90.2150.980110 HS REC COMPLEX - CON 56,219.47 510-1080100 MONEY MARKET-BANKE 26,450.00 510-30.6510.100000 HEALTH & LIFE INSURAN 293.24 510-30.6510.210000 PUBLIC NOTIFICATION/A 66.58 510-30.6510.250000 TESTING FEES 760.00 510-30.6510.340000 MISCELLANEOUS CONTR 428.90 510-30.6510.390300 TOWER RENT 419.18 510-30.6510.450000 TELEPHONE 213.55 510-30.6510.470000 TRAININGITRAVEL EXPE 700.00 510-30.6510.480000 UTILITY SERVICES 12.88 510-30.6510.570000 FUEL 253.01 510-30.6510.592000 METER PURCHASE 14,112.00 520-1080100 MONEY MARKET-BANKE 16,350.00 520-30.6520.100000 HEALTH & LIFE INSURAN 358.79 520-30.6520.450000 TELEPHONE 297.54 520-30.6520.480000 UTILITY SERVICES 140.92 520-30.6520.570000 FUEL 253.01 520-30.6520.882700 WRA FEES 112,440.00 520-30.6520.883095 WEST AREA TRUNK SEW 12,095.50 540-1080100 MONEY MARKET - BANK 34,650.00 540-30.6540.100000 HEALTH & LIFE INSURAN 545.86 540-30.6540.280000 DUES, MEMBERSHIPS & 1,609.30 540-30.6540.340000 MISCELLANEOUS CONTR 428.90 540-30.6540.390300 TOWER RENT 419.17 540-30.6540.450000 TELEPHONE 267.70 540-30.6540.480000 UTILITY SERVICES 12.88 540-30.6540.570000 FUEL 253.00 540-30.6540.590000 OPERATING SUPPLIES & 449.23 540-30.6540.590100 DEVELOPER MATERIALS 859.12 540-30.6540.590200 INSTALLATION MATERIA 5,546.72 540-30.6540.650000 COSTOF GOODS SOLD 2,891.25 540-30.6540.685400 GAS REBATE 210.00 540-30.6540.880100 DISTRIBUTION SYSTEM I 13,405.64 540-30.6540.880181 ALICES ROAD MAIN REL 280.95 560-80.5300.100000 HEALTH & LIFE INSURAN 318.69 560-80.5300.120000 UNIFORMS 424.44 560-80.5300.450000 TELEPHONE 346.62 560-80.5300.880015 CENTENNIAL PARK STRE 668.20 570-30.6550.100000 HEALTH & LIFE INSURAN 97.70 570-30.6550.360000 POSTAGE & SHIPPING 2,792.58 570-30.6550.450200 CREDIT CARD FEES 175.00 590-30.5400.231300 RESIDENTIAL SOLID WAS 91,363.14 750-80.8750.100000 HEALTH & LIFE INSURAN 86.65 750-80.8750.120000 UNIFORMS 311.23 750-80.8750.450000 TELEPHONE 508.57 750-80.8750.580000 OFFICE SUPPLIES 64.87 Grand Total: 1,057,175.79 12/28/2017 12:07:39 PIA - Page 9 of 10 Expense Approval Register Packet: APPKT00866 - JANUARY 3RD COUNCIL PACKET Project Account Key **None** ALICE55-CONSLT Project Account Summary Grand Total: Expense Amount 1,057,058.91 116.88 1,057,175.79 12/28/2017 12:07:39 PM Page 10 of 10 (A City of Waukee, IA V/bukee P( My Check Report By Check Number Date Range: 12/14/2017 - 12/18/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number Bank Code: AP-WAUKEE STATE 094500 IOWA ASSOCIATION OF BUILDING OFFICIALS 12/18/2017 Regular 0.00 390.00 131680 Payable# Payable Type Post Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0004168 Invoice 12/18/2017 IRC 2018 REGISTRATION-M. WIGGINS 0.00 130.00 010-10.1900,470000 TRAINING/TRAVEL EXPEN IRC 2018 REGISTRATION-M. WI 130.00 INV0004169 Invoice 12/18/2017 IBC 2018 REGISTRATION- R. RASH 0.00 130.00 010-10.1900.470000 TRAINING/TRAVEL EXPEN IBC 2018 REGISTRATION- R. RAS 130.00 INV0004170 Invoice 12/18/2017 IBC 2018 REGISTRATION-T. HUSTED 0.00 130.00 010-10.1900.470000 TRAINING/TRAVEL EXPEN IBC 2018 REGISTRATION-T. HUS 130.00 240300 XENIA RURAL WATER DISTR 12/18/2017 Regular 0.00 69.11 131681 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0004167 Invoice 12/06/2017 WATER 0.00 69.11 510-30.6510.480000 UTILITY SERVICES WATER 69.11 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 4 2 0.00 459.11 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 4 2 0.00 459.21 12/28/2017 12:52:57 PM Page 1 of 2 My Check Report Date Range: 12/14/2017 - 12/18/2017 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 4 2 0.00 459.11 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 4 2 0.00 459.11 Fund Summary Fund Name Period Amount 999 POOLED CASH 12/2017 459.11 459.11 12/28/2017 12:52:57 PM Page 2 of 2 !0 1,Vc)ukee City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE 190825 SAM'S CLUB Payable p Payable Type Account Number INV0004212 Invoice 010-40.4200,461700 010-40.4200.461700 Payment Date Payment Type My Check Report By Check Number Date Range: 12/20/2017-12/28/2017 DiscountAmount PaymentAmount Number 12/20/2017 Regular 0.00 65.38 131831 Post Date Payable Description Discount Amount Payable Amount Account Name Item Description Distribution Amount 12/08/2017 DECEMBER'17 STATEMENT 0.00 65.38 WINTER FEST WINTERFEST MATERIALS -SPRA 31.65 WINTER FEST WINTERFEST-CUPS/SPOONS/C 33.73 055625 EMPLOYEE BENEFITSYSTEMS 12/27/2017 Regular 0.00 128,016.30 131832 12/28/2017 12:54:07 PM Page 1 of 3 My Check Report Date Range: 12/20/2017-12/28/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 INV0004226 Invoice 12/27/2017 JAN'18 HEALTH INSURANCE MONTHLY P 0.00 128,016.30 010-10.1100.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 33,180.38 010-10.1400.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 7,095.21 010-10.1500,100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 7,095.20 010-10.1900.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 4,234.44 010-20.6000.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 5,990.80 010-20.6150,100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 2,117.22 010-20.8900,100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 4,234.44 010-20.8950.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 596.62 010-40.3100,100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 9,118.06 010-40.4100.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 596.62 010-40.4100,100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 1,520.60 010-40.4100.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 304.12 010-40.4200.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 3,637.82 010-50.8500.100000 HEALTH &LIFE INSURANC JAN'18 HEALTH INSURANCE M 1,429.00 010-50.8700.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 3,637.82 010-60.8200.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 1,520.60 010-60.8300.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 2,949.60 010-60.8350.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 596.62 010-60.8400.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 3,546.22 010-60.8800.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 1,520.60 060-30.7100.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 6,679.02 060-30.7100.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 152.06 060-30.7100,100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 760.30 510-30.6510,100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 2,071.42 510-30.6510,100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 529.31 510-30.6510.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 1,429.00 510-30.6510.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 760.30 520-30.6520.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 529.31 520-30.6520.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 760.29 520-30.652.0.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 2,071.42 520-30.6520.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 2,858.00 540-30.6540.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 529.31 540-30.6540,100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 5,947.10 540-30.6540.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 760.30 560-80.5300.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 529.31 560-80.5300.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 3,637.82 570-30.6550.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 2,025.62 750-80.9750.100000 HEALTH & LIFE INSURANC JAN'18 HEALTH INSURANCE M 1,064.42 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 2 2 0.00 128,081.68 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 2 2 0.00 128,081.68 12/28/2017 12:54:07 PM Page 2 of 3 My Check Report J Date Range: 12/20/2027 - 12/28/2017 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 2 2 0.00 128,081.68 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 2 2 0.00 128,081.68 Fund Summary Fund Name Period Amount 999 POOLED CASH 12/2017 128,081.68 128,081.68 12/28/2017 12:54:07 PM Page 3 of 3 C/ City of Waukee, IA Vendor Number Vendor Name Bank Code: AP-WAUKEE STATE Council Payroll Reimbursements By Check Number Date Range: 12/15/2017 - 12/27/2017 Payment Date Payment Type DiscountAmount PaymentAmount Number 034875 CITY OF WAUKEE 12/15/2017 Regular 0.00 5,940.13 131688 Payable# Payable Type Post Date Payable Description DiscountAmount Payable Amount Account Number Account Name Item Description Distribution Amount INV0004179 Invoice 12/15/2017 CELL PHONE REIMBURSEMENT 0.00 237.50 010-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 156.50 060-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 10.13 510-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 11.30 520-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.24 540-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 26.26 560-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 1.82 750-2030000 PAYROLL PAYABLES CELL PHONE REIMBURSEMENT 5.25 INV0004184 Invoice 12/15/2017 LIFE INSURANCE PREMIUM 0.00 696.11 010-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 507.61 060-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 24.75 510-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 28.89 520-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 28.85 540-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 43.47 560-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 27.79 570-2030000 PAYROLL PAYABLES LIFE INSURANCE PREMIUM 34.75 INV0004185 Invoice 12/15/2017 STD INSURANCE PREMIUM 0.00 589.02 010-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 384.89 060-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 49.42 510-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 45.41 520-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 51.97 540-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 23.66 560-2030000 PAYROLL PAYABLES STD INSURANCE PREMIUM 33.67 INV0004188 Invoice 12/15/2017 HEALTH INSURANCE DEDUCTION 0.00 3,937.50 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 2,898.00 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 241.49 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 144.45 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 196.79 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 249.41 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 118.11 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 52.50 750-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 36.75 INV0004189 Invoice 12/15/2017 HEALTH INSURANCE DEDUCTION 0.00 480.00 010-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 360.00 060-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 20.00 510-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 25.09 520-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 24.98 540-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 5.06 560-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 24.87 570-2030000 PAYROLL PAYABLES HEALTH INSURANCE DEDUCTIO 20.00 036350 IOWA DEPT OF HUMAN SERVICES 12/15/2017 Regular 0.00 1,728.68 131689 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0004171 Invoice 12/15/2017 CHILD SUPPORT 0.00 1,728.68 010-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 1,604.80 060-2011300 CHILD SUPPORT PAYABLE CHILD SUPPORT 123.88 036740 COMMUNICATIONS WORKERS OF AMERICA 12/15/2017 Regular 0.00 910.63 131690 12/27/2017 9:48:09 AM Page 1 of 4 Council Payroll Reimbursements 0 Date Range: 12/25/2017 - 12/27/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 INV0004176 Invoice 12/15/2017 CWA LOCAL 7102 UNION DUES 0.00 910.63 010-2014100 CREDIT UNION DEDUCT] CWA LOCAL 7102 UNION DUES 405.95 060-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 85.07 510-2014100 CREDIT UNION DEDUCT[ CWA LOCAL 7102 UNION DUES 78.51 520-2014100 CREDIT UNION DEDUCT[ CWA LOCAL 7102 UNION DUES 109.82 540-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 136.63 560-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 68.73 570-2014100 CREDIT UNION DEDUCTI CWA LOCAL 7102 UNION DUES 25.92 099999 EFTPS 12/15/2017 Regular 0.00 84,557.82 131691 Payable If Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0004194 Invoice 12/15/2017 FICA TAX WITHHOLDING 0.00 37,637.56 010-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 29,358.10 060-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,513.24 510-2010300 FICA TAX WITH HOLDING FICA TAX WITHHOLDING 1,272.10 520-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,619.04 540-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,696.26 560-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 1,172.70 570-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 546.00 750-2010300 FICA TAX WITHHOLDING FICA TAX WITHHOLDING 460.12 INV0004195 Invoice 12/15/2017 FEDERAL WITHHOLDING TAXES 0.00 37,811.76 010-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 29,831.28 060-2010200 FEDERAL TAX WITHHOLD] FEDERAL WITHHOLDING TAXES 1,328.88 510-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,243.06 520-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,849.72 540-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,546.43 560-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 1,182.45 570-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 716.86 750-2010200 FEDERAL TAX WITHHOLDI FEDERAL WITHHOLDING TAXES 113.08 INV0004196 Invoice 12/15/2017 MEDICARE TAX WITHHOLDING 0.00 9,108.50 010-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 7,172.22 060-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 353.92 510-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 297.58 520-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 378.64 540-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 396.70 560-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 274.16 570-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 127.70 750-2010400 MEDICARE TAX WITHHOL MEDICARE TAX WITHHOLDING 107.58 133560 MEALS FROM THE HEARTLAND 12/15/2017 Regular 0.00 114.20 131692 Payable # Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0004181 Invoice 12/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 206800 TOTAL ADMINISTRATIVE SERVICES CORP 12/15/2017 Regular 0.00 5,125.57 131693 12/27/2017 9:48:09 AM Page 2 of 4 Council Payroll Reimbursements C/ Date Range: 12/1S/2017 - 12/27/2017 Vendor Number Vendor Name Payment Date Payment Type Discount Amount PaymentAmount Number Payable p Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0004186 Invoice 12/15/2017 SECTION 125 MEDICAL DEDUCTIONS 0.00 3,088.10 010-2030000 PAYROLL PAYABLES SECTION 125 MEDICAL DEDUCTI 2,333.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 DEDUCT] 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 INV0004187 Invoice 12/15/2017 SECTION 125 DAYCARE DEDUCTIONS 0.00 2,037.47 010-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT 1,624.98 060-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT 100.00 560-2030000 PAYROLL PAYABLES SECTION 125 DAYCARE DEDUCT 312.49 213250 UNITED WAY CENTRAL IOWA 12/15/2017 Regular 0.00 193.30 131694 Payable a Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0004178 Invoice 12/15/2017 UNITED WAY DEDUCTION 0.00 193.30 010-2030000 PAYROLL PAYABLES UNITED WAY DEDUCTION 164.17 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 12/15/2017 Regular 0.00 36.66 131695 Payable k Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0004182 Invoice 12/15/2017 LIBRARY FRIENDS FOUNDATION PAYROLL 0.00 36.66 010-2030000 PAYROLL PAYABLES LIBRARY FRIENDS FOUNDATION 29.12 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 Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 15 8 0.00 98,606.99 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 15 8 0.00 99,606.99 12/27/2017 9:48:09 AM Page 3 of 4 Council Payroll Reimbursements Date Range: 12/15/2017 - 12/27/2017 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 15 8 0.00 98,606.99 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 is 8 0.00 98,606.99 Fund Summary Fund Name Period Amount 999 POOLED CASH 12/2017 98,606.99 98,606.99 12/27/2017 9:48:09 AM Page 4 of 4 My Check Report Date Range: 11/30/2017 - 11/30/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount PaymentAmount Number Bank Code: AP-WAUKEE STATE 021100 BANK OF AMERICA 11/30/2017 Regular 0.00 24,663.95 131678 Payable# Payable Type Post Date Payable Description Discount Amount Payable Amount Account Number Account Name Item Description Distribution Amount INV0004129 Invoice 10/18/2017 BANK OF AMERICA OCTOBER'17 STATEM 0.00 24,663.95 010-10.1100.120000 UNIFORMS MAG POUCH/FIGHT LIGHT MALI 97.00 010-10,1100.400000 REPAIR/MAINTENANCE0 LIGHT BULBS 29.11 010-10,1100.460200 PD COMMUNITY POLICIN HOMECOMING PARADE CANDY 10.59 010-10.1100,460200 PD COMMUNITY POLICIN DONUTS/MUFFINS/JUICE 31.80 010-10.1100.470000 TRAINING/TRAVEL EXPEN KUM & GO REBATES -0.15 010-10.1100.470000 TRAINING/TRAVEL EXPEN 10/11/17 - NEIGHBORHOOD W 15.25 010-10,1100.470000 TRAINING/TRAVEL EXPEN I & I TRAINING DONUTS 21.98 010-10.1100,470000 TRAINING/TRAVEL EXPEN I & I TRAINING DONUTS 16.21 010-10.1100.470000 TRAINING/TRAVEL EXPEN I & I TRAINING DONUTS 11.65 010-10.1100.470000 TRAINING/TRAVEL EXPEN TRAINING RANGE RENTAL FEE 100.00 010-10.1100.470000 TRAINING/TRAVEL EXPEN CO2 CARTRIDGE 29.47 010-10,1100.540000 MINOR EQUIPMENT LINEN TOWER 76.32 010-10,1100.540000 MINOR EQUIPMENT I -PHONE CASE 38.15 010-10,1100.540000 MINOR EQUIPMENT CHAIRS 239.98 010-10.1100.540000 MINOR EQUIPMENT AUTOTAP AR FRONTSIGHTTO 21.18 010-10.1100.590000 OPERATING SUPPLIES& KITCHEN TOWELS 29.88 010-10.1400.270000 DATA PROCESSING DIAGRAMMING SOFTWARE 279.50 010-10.1400.400000 REPAIR/MAINTENANCE 0 DOOR REMOVAL MATERIALS 295.51 010-10.1400.400000 REPAIR/MAINTENANCE O TAX REFUND -5.72 010-10.1400.400000 REPAIR/MAINTENANCE 0 DOOR REMOVAL MATERIALS 156.00 010-10.1400.410000 REPAIR OF VEHICLES HEADLIGHTS 71.50 010-10.1400.470000 TRAINING/TRAVEL EXPEN HAWKEYE CONFERENCE & DUES 260.00 010-10.1400.470000 TRAINING/TRAVEL EXPEN FLIGHTTO INT'L FIRE CHEIFS CO 7.49 010-10.1400.470000 TRAINING/TRAVEL EXPEN FLIGHT TO INT'L FIRE CHEIFS CO 105.40 010-10.1400.470000 TRAINING/TRAVEL EXPEN FLIGHTTO INT'L FIRE CHEIFS CO 13.50 010-10.1400.470000 TRAINING/TRAVEL EXPEN 09/16/17 LUNCH -CLINT 11.66 010-10.1400.470000 TRAINING/TRAVEL EXPEN FLIGHT TO INT'L FIRE CHEIFS CO 78.40 010-10.1400,540000 MINOR EQUIPMENT MONITORS 699.95 010-10.1400.540000 MINOR EQUIPMENT CELL PHONE SCREEN PROTECTO 18.47 010-10.140C.540000 MINOR EQUIPMENT SAW CLAMP/PIN 9.45 010-10.1400,590000 OPERATING SUPPLIES& TRANSPARENCY FILM 17.53 010-10.1400,590000 OPERATING SUPPLIES& COE CONFIRMATION TEMPLATE 135.00 010-10.1500.270000 DATA PROCESSING DIAGRAMMING SOFTWARE 279.50 010-10,1500,410000 REPAIR OF VEHICLES HEADLIGHTS 71.49 010-10.1500,470000 TRAINING/TRAVEL EXPEN FUGHTTO INT'L FIRE CHEIFS CO 105.40 010-10.1500.470000 TRAINING/TRAVEL EXPEN 09/16/17 LUNCH -CLINT 11.66 010-10.1500,470000 TRAINING/TRAVEL EXPEN EMS PROGRAM - HENTGES 90.00 010-10.1500.470000 TRAINING/TRAVEL EXPEN FLIGHT TO INT'L FIRE CHEIFS CO 13.50 010-10.1500.470000 TRAINING/TRAVEL EXPEN FLIGHTTO INT'L FIRE CHEIFS CO 7.49 010-10.1500.470000 TRAINING/TRAVEL EXPEN FLIGHTTO INT'L FIRE CHEIFS CO 78.40 010-10.1500.540000 MINOR EQUIPMENT CELL PHONE SCREEN PROTECTO 18.47 010-10,1500,540000 MINOR EQUIPMENT SAW CLAMP/PIN 9.45 010-10.1900.120000 UNIFORMS STEELTOE WORK BOOTS - BRAD 136.41 010-10.1900,470000 TRAINING/TRAVEL EXPEN 9/20/17 LUNCH MEETING 55.01 010-10.2400,340000 MISCELLANEOUS CONTR PETTAGS 161.00 010-20,6000,470000 TRAINING/TRAVEL EXPEN 10/17/17 LUNCH-J. GIBSON/D. 39.92 010-20.8900.540000 MINOR EQUIPMENT LEVELING TOOLS 959.96 010-40.3100.210100 PROMOTION FACEBOOK ADVERTISEMENTS 29.95 010-40.3100.460300 PROGRAMS KIDS PROGRAM SUPPLIES 85.51 010-40.3100.470000 TRAINING/TRAVEL EXPEN 9/29/17 - LUNCH Kristine & LIBR 37.10 010-40.3100,540000 MINOR EQUIPMENT DINING TABLE & BENCH 798.02 010-40.3100.540000 MINOR EQUIPMENT DRAWER FILE (REIMBURSED BY 643.96 010-40.3100.540000 MINOR EQUIPMENT LIBRARY SERVER HARDWARE 350.00 010-40.3100.580000 OFFICE SUPPLIES LITERATURE HOLDER 227.65 010-40.3100.590000 OPERATING SUPPLIES & DIGITAL SCHOLAR MATERIALS 218.86 010-40.3100.590000 OPERATING SUPPLIES & DIGITAL SCHOLAR MATERIALS 256.13 12/28/2017 11:55:55 AM Page 2 of 5 My Check Report Date Range: 11/30/2017-11/30/2017 Vendor Number Vendor Name Payment Date Payment Type DiscountAmount Payment Amount Number 010-40.3100.640000 LIBRARY BOOKS/FILMS/R SUBSCRIPTION (REIMBURSED B 60.00 010-40.3100.640000 LIBRARY BOOKS/FILMS/R SUBSCRIPTION 12.72 010-40.3100.640000 LIBRARY BOOKS/FILMS/R SUBSCRIPTION 43.14 010-40,4100.410300 REPAIR/MAINTENANCE 0 ICE RINK PARTS 390.00 010-40.4200.460505 ADULT SPORTS LEAGUES SAND VOLLEYBALL PRIZES 30.00 010-40.4200.460505 ADULT SPORTS LEAGUES ADULTSOFTBALL PRIZES 190.00 010-40.4200,460520 CONCESSION STAND CHIPS -CONCESSIONS 8.00 010-40.4200,460550 WINTER RECREATION PR 10/15/17 LUNCH - DANAE (VIKI 22.75 010-40.4200.460550 WINTER RECREATION PR WINTER WONDERLAND LINEN 84.23 010-40,4200.461400 WAUKTOBER FEST FOAM NOODLES 48.75 010-40.420&470000 TRAINING/TRAVEL EXPEN PARKING - MATT J. 19.00 010-40,4200,470000 TRAINING/TRAVEL EXPEN 9/22/17 LUNCH - MATTJ. 7.75 010-40.4200.470000 TRAINING/TRAVEL EXPEN 9/25/17 LUNCH - MATTJ. 8.54 010-40.4200.470000 TRAINING/TRAVEL EXPEN 9/25/17 CAB FARE - MATT J. 41.40 010-40.4200.470000 TRAINING/TRAVEL EXPEN LUGGAGE FEES 25.00 010-40.4200.470000 TRAIN ING/TRAVEL EXPEN 09/28/17 LUNCH - JOSH V & MA 20.00 010-40.4200.470000 TRAINING/TRAVEL EXPEN 9/26/17 DINNER- MATTJ. 23.99 010-40.4200.470000 TRAINING/TRAVEL EXPEN 9/27/17 LUNCH - MATT J. 15.25 010-40.4200.470000 TRAINING/TRAVEL EXPEN LUGGAGE FEES 25.00 010-40.4200.470000 TRAINING/TRAVEL EXPEN 09/25/17 - 09/28/17 HOTEL -M 659.31 010-40_4200.470000 TRAINING/TRAVEL EXPEN 9/26/17 LUNCH - MATT J. 12.52 010-50,8500.470000 TRAINING/TRAVEL EXPEN 10/09/17 LUNCH - DAN/CHRISC 35.38 010-50.8500.470000 TRAINING/TRAVEL EXPEN 9/28/17 COFFEE- DAN 4.40 010-50,8500,470000 TRAINING/TRAVEL EXPEN PARKING- DAN 6.50 010-50.8700,470000 TRAINING/TRAVEL EXPEN 10/5/17 BREAKFAST - BRAD/AN 38.53 010-50,8700.470000 TRAINING/TRAVEL EXPEN 9/20/17 LUNCH MEETING 12.25 010-50.8700.470000 TRAINING/TRAVEL EXPEN 9/26/17 MEETING DESSERTS 30.00 010-50.8700.470000 TRAINING/TRAVEL EXPEN 10/4/17 LUNCH - BRAD (MISSIN 5.87 010-50.8700.470000 TRAINING/TRAVEL EXPEN 10/4/17 DINNER - BRAD/ANDY/ 47.45 010-50,8700.470000 TRAINING/TRAVEL EXPEN 10/5/17 DINNER - BRAD/ANDY/ 69.78 010-50.8700.470000 TRAINING/TRAVEL EXPEN 10/6/17 LUNCH - BRAD/ANDY/ 27.77 010-50.8700.470000 TRAINING/TRAVEL EXPEN 10/9/17 LUNCH - BRAD(MISSIN 10.46 010-50.8700.470000 TRAINING/TRAVEL EXPEN 10/4-10/6 HOTEL ROOM BRAD 206.48 010-50,8700.470000 TRAINING/TRAVEL EXPEN 10/4-10/6 HOTEL ROOM ANDY 206.48 010-50.8700.470000 TRAINING/TRAVEL EXPEN 10/4-10/6 HOTEL ROOM MELIS 206.48 010-60.9100,470000 TRAINING/TRAVEL EXPEN 30/9/17 COUNCIL WORK SESSIO 179.10 010-60.8200.270100 COMPUTER SUPPORT MONTHLY ADOBE PRODUCT FE 49.99 010-60.8200.280000 DUES, MEMBERSHIPS & 5 AMA ANNUAL DUES - SUMMER 250.00 010-60.9200.461200 NEWSLETTER E-NEWSLETTER 125.00 010-60.8200.470000 TRAINING/TRAVEL EXPEN 9/25/17 LUNCH - SUMMER&IN 28.32 010-60.8200.470000 TRAINING/TRAVEL EXPEN 10/10/17 LUNCH - SUMMER&S 28.00 010-60.8200.470000 TRAINING/TRAVEL EXPEN OCTOBER 117 CHAMBER LUNCH 15.00 010-60.8200.540000 MINOR EQUIPMENT LENS CAP FOR CAMERA 15.50 010-60.8200.580000 OFFICE SUPPLIES BATTERIES 12.70 010-60.8300.470000 TRAINING/TRAVEL EXPEN 9/20/17 LUNCH - BECKY GCMO 16.67 010-60.8300.470000 TRAINING/TRAVEL EXPEN 9/20/17 WAUKEE BETTERMENT 30.00 010-60.8300.470000 TRAINING/TRAVEL EXPEN 10/18/17 WAUKEE BETTERMEN 18.00 010-60,8300.470000 TRAINING/TRAVEL EXPEN 10/06/17 TIM BREAKFASTWITH 10.41 010-60,8300.470000 TRAINING/TRAVEL EXPEN 10/04/17 TIM COFEE 6.22 010-60,8300.470000 TRAINING/TRAVEL EXPEN 10/3/17 LUNCH -TIM M. & MA 36.71 010-60,8300.470000 TRAINING/TRAVEL EXPEN 9/29/17 BREAKFAST -TIM M. IL 2.68 010-60,8300.470000 TRAINING/TRAVEL EXPEN 9/27-9/29 HOTEL -TIM M. ILCC 385.28 010-60.8300.470000 TRAINING/TRAVEL EXPEN 9/28/17 BREAKFAST -TIM M. IL 7.15 010-60.8300.470000 TRAINING/TRAVEL EXPEN 9/25/17 TIM LUNCH WITH MAY 55.64 010-60.8300,470000 TRAINING/TRAVEL EXPEN 9/25/17 TIM PARKING 5.00 010-60.8300,470000 TRAINING/TRAVEL EXPEN 9/19/17 TIM &EMPLOYEE LUN 144.55 010-60.9350.120000 UNIFORMS NAMETAG -TONI 18.28 010-60.8350.689200 WELLNESS PROGRAM/IN HEALTHIEST STATE T-SHIRTS 494.46 010-60.8400.470000 TRAINING/TRAVEL EXPEN 9/20/17 GCMOA LUNCH - LIND 18.79 010-60.8400,470000 TRAINING/TRAVEL EXPEN 9/22/17 METRO FINANCE LUNC 15.73 010-60.8400.470000 TRAINING/TRAVEL EXPEN FALL GPGFOA -LINDA 150.00 12/28/2017 11:55:55 AM Page 3 of 5 My Check Report Vendor Number Vendor Name 010-60.8400.470000 010-60.8800.280000 010-60.8800.540000 010-60.8800,540000 010-60.8800.740210 010-60.8800.740210 010-60.8800.740210 060-30.7100.470000 510-30.6510,470000 510-30.6510.470000 510-30.6510.470000 560-80.5300.270000 750-80.8750.280000 750-80.8750,280000 750-80,8750.410100 750-80.8750.540000 750-80.8750.540000 Payment Date TRAINING/TRAVEL EXPEN DUES, MEMBERSHIPS & S MINOR EQUIPMENT MINOR EQUIPMENT SERVER EQUIPMENT SERVER EQUIPMENT SERVER EQUIPMENT TRAINING/TRAVEL EXPEN TRAINING/TRAVEL EXPEN TRAINING/TRAVEL EXPEN TRAINING/TRAVEL EXPEN DATA PROCESSING TRAINING/TRAVEL EXPEN DUES, MEMBERSHIPS & 5 DUES, MEMBERSHIPS & 5 REPAIR/MAINTENANCE E MINOR EQUIPMENT MINOR EQUIPMENT OPERATING SUPPLIES & Date Range: 11/30/2017 - 11/30/2017 Payment Type Discount Amount PaymentAmount Number BUDGET WORKSHOP - LINDA TAX REFUNDED ON PRIME ME IT SERVER HARDWARE IT SERVER HARDWARE ITSERVER HARDWARE ITSERVER HARDWARE ITSERVER HARDWARE 10/2/17 - 30/5/17 HOTEL APWA AW WA -IA ANNUAL CONN F. HO 10/4/17-30/6/17 HOTEL-J GIB HOTEL REBATE STORMWATER INSPECTION APP EROSION CONTROL FALL CONF. GCSAA DUES - ELLIOTT TRI-TECH SYSTEMS SUPPORT REPAIRS TO BEER COOLER LABEL ART TAGS FOR FRAMES FRAMES PLAQUE Bank Code AP Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 1 1 0.00 24,663.95 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 0 0 0.00 0.00 EFT's 0 0 0.00 0.00 1 1 0.00 24,663.95 45.00 -5.94 4,900.00 -4,900.00 5,200.00 -5,200.00 10,100.00 318.48 202.79 246.30 -8.11 22.00 175,00 70.00 30.00 801.00 13.44 100.23 182.50 12/28/2017 11:55:55 AM Page 4 of 5 My Check Report Date Range: 11/30/2027 - 11/30/2017 All Bank Codes Check Summary Payable Payment Payment Type Count Count Discount Payment Regular Checks 1 1 0.00 24,663.95 Manual Checks 0 0 0.00 0.00 Voided Checks 0 0 0.00 0.00 Bank Drafts 0 0 0.00 0.00 EFT's 0 0 0.00 0.00 1 1 0.00 24,663.95 Fund Summary Fund Name Period Amount 999 POOLED CASH 11/2017 24,663.95 24,663.95 12/28/2017 11:55:55 AM Page 5 of 5 `) 0 Ubukee Employee Name ABBOTT, BRENT ABRAMOWITZ, LEVI ADKINS, COREY ALDRICH, SHAW N ANNAPUREDDY, LAXMI ARIAS, HECTOR ARMSTRONG, BRETT BAKER, RANDY BAUMAN, LISA BERGMAN, ANNASTASIA BLUTT, PETER BOHARDT, HAZEL BOTTENBERG, RICHARD BRUNS, RACHEL BURKHART, LINDA CAHALAN, JACE CAMPBELL, JUDY CAMPBELL, SCOTT CARROLL, JOSEPH CATALDO, RUDOLPH CICHOSKI, KELLI CLEMEN, ANTHONY COGGESHELL, LEE COLE, JACOB CORKREAN, JENNIFER COUGHLIN, TONI CRAVEN, GAYLA CUNNINGHAM, DEANA CUNNINGHAM, SCOTT DANIEL, COLE DEBOER, MELISSA DEETS, BRADLY DEZEEUW, DAVID DODGE, JUSTIN DUNBAR, DIANA DUNHAM, BRYCE DUTCHER, DAN EASTMAN, DAVID EDWARDS, DANAE ELDRIDGE, MALLORY ELLIS, NICOLE ENNETT, SAMUEL EVANS, SUMMER FLUGGE-SMITH, JAMIE FREDERICK, JUSTIN FROEHLICH, WILLIAM GIBSON, JOHN GITZEN, ROBERT GODW IN, EDWARD GROVE, BRIAN GUESS, KATHRYN HANSON,ANTHONY HANSON, LAURA HARRISON, BRIAN HEIMANN, RONALD HENKENIUS, JODY HERRICK, ROBERT City of Waukee, IA Publication Report By Employee Name Payroll Set: OS - City of Waukee For Date Range 12/01/2017-12/15/2017 Salary $1,297.35 $777.29 $1,262.51 $1,552.33 $49.13 $2,155.69 $1,720.99 $1,626.49 $1,178.27 $392.49 $241.10 $400.25 $392.49 $1,750.51 $2,876.11 $195.81 $950.99 $2,098.81 $2,021.61 $133.44 $1,560.62 $2,191.50 $1,285.43 $416.93 $1,730.67 $1,230.28 $194.36 $554.27 $2,289.56 $1,286.03 $1,706.88 $3,110.02 $2,216.01 $1,718.81 $1,027.74 $1,267.49 $3,121.95 $527.41 $1,598.43 $847.06 $607.30 $1,474.32 $2,107.20 $1,597.15 $1,683.38 $208.75 $3,404.76 $2,753.67 $333.87 $150.88 $1,429.24 $2,150.78 $1,483.29 $392.49 $2,512.92 $1,085.34 $1,729.44 I Employee Name Salary HILGENBERG, ADAM $1,713.12 HOLDEN, PATRICIA $2,840.08 HUGHES, RACHELLE $342.41 HUSTED, TROY $1,631.13 HUTTON, JOSHUA $1,870.36 IRWIN, BRENT $125.17 JENSEN, CHAD $458.43 JERMIER, MATTHEW $2,678.61 KASS, ANDREW $2,049.25 KASZINSKI, BRETT $720.82 KELLER, CHRISTOPHER $1,575.49 KERR, JACOB $1,559.23 KIES, SUSAN $1,624.18 KINNEY, SCOTT $1,413.72 KOESTER, EVAN $1,711.53 KOESTER, RUDY $2,413.92 LARSON, KENNETH $506.77 LARSON, KRISTINE $2,597.25 LAUGHRIDGE, DANIEL $1,556.71 LE, SON $2,564.97 LEMKE, NEIL $1,536.72 LONDON, SHAY $102.99 LONG, JEREMY $2,373.43 LYNCH, SHANNON $1,530.92 LYON, LARRY $393.55 MANNING, JOSHUA $1,989.18 MAPES, TROY $2,794.21 MAREAN, JOSHUA $1,152.74 MCCLINTIC, JAMES $1,302.21 MELLENCAMP, JEFFREY $2,623.90 MINIKUS, JOSHUA $1,794.38 MOERMAN, TIMOTHY $4,475.74 MORFORD, PAIGE $564.03 MURRA, BRIAN $1,967.19 OAKLEY, JON $1,558.18 OLSEN, KARI $1,502.06 OSBORN, RYAN $720.03 OSTRING, KATHLEEN $1,380.72 PARISH, TONJA $1,368.26 PEARD, WILLIAM $492.68 PERDRIAU, MARIE $300.72 PETERSON, KATIE $1,241.48 PETERSON, OREN $1 99q 29 PETTIT, BRANDON $1,776.13 PIERSON, DAMON $1,277.75 PIZINGER, JAMES $105.53 PUDENZ, DANIELLE $46.68 PURVIS, KATHRYN $1,432.64 QUINN, JOHN $3,294.70 RASH, RONALD $1,964.55 BEES, CALEB $136.02 RICHARDSON, ELIZABETH $1,697.23 ROBINSON, CLINT $3,191.33 ROGERS, BROOKE $333.21 ROYER, TIMOTHY $2 776 29 ROYSTER, JACOB $1,321.97 SAGER, AARON $676.86 SANCHEZ, MARIA $1,390.41 SCHAUFENBUEL, KARI $990.62 SCHETTLER, RODNEY $1,748.70 SCHUETT, REBECCA $2,189.09 SEDDON, JOSH $160.83 SHARON, JEREMIAH $1,397.60 SKELLENGER, AMANDA $78.20 �i Employee Name Salary SMITH, BLAKE $375.64 SNELSON, NATHANIEL $268.06 SOFEN, NATASHA $34.56 SPARKS, WENDI $858.95 SPOSETO, MACKENZIE $2,308.67 SPRAGUE, MATTHEW $1,576.84 STEINKE, KURT $458.02 STEPHENS, CLINT $276.01 STEWARD, ERIC $1,835.38 SUETSUGU, SEAN $110.54 TERLOUW, KYLE $1,661.52 THAYER, CHANDLER $816.72 TIBBLES, STEVEN $1,509.37 TUEL, JASON $306.30 TYSDAL, THOMAS $2,426.95 VANDE KAMP, JOSHUA $1,667.51 VOEGTLE, TIMOTHY $1,449.63 VOKES, LARRY $1,719.86 WALLACE, ERIC $1,788.37 WASKE, CHARLES $1,773.72 WERNIMONT, THOMAS $357.47 WERTS, DANIEL $1,896.59 WESTON STOLL, KERI $1,522.02 WHITE, JASON $1,420.30 WHITE, LEAH $1,308.81 WIGGINS, MATHEW $1,818.74 WINTERS, TROY $1,823.41 WISE, NATHAN $2,324.98 WOOD, DANIEL $1,213.35 YATES, CASSANDRA $337.43