Loading...
FINANCE COMMITTEE Packet - 5/22/2018CITY OF MUSKEGO FINANCE COMMITTEE AGENDA 05/22/2018 5:30 PM Muskego City Hall, W182 S8200 Racine Avenue CALL TO ORDER PLEDGE OF ALLEGIANCE ROLL CALL PUBLIC MEETING NOTICE LICENSE APPROVALS Review and Recommendation Regarding Operator Application for Angeline Livingston Recommend Approval of Operator Licenses Recommend Approval of Temporary License to Sell Fermented Malt Beverages and Wine for Muskego Moose Lodge1057 for June 1, 2018 Recommend Approval of Outside Dance Permit for Tres Locos, W172 S7505 Lannon Drive, for June 1, 2018 (5:00 pm to 11:30 pm) Recommend Approval of Outside Dance Permit for A.J.'s Bar & Grill, S90 W13970 Boxhorn Drive, for June 24, 2018 (2:00 pm to 6:00 pm) NEW BUSINESS Recommendation Regarding Official City Newspaper Recommend Expenditure for No Trucking Signage Discuss Military Leave for Police Officers Daniel Gaenslen and Gregory Slamka VOUCHER APPROVAL VOUCHER REPORT Utility Vouchers General Fund Vouchers Wire Transfers for Payroll/Invoice Transmittals FINANCE DIRECTOR’S REPORT Packet Page 1 Finance Committee Agenda 2 5/22/2018 5:30:00 PM Annual 2017 and First Quarter 2018 COMMUNICATIONS AND ANY OTHER BUSINESS AS AUTHORIZED BY LAW ADJOURNMENT NOTICE IT IS POSSIBLE THAT MEMBERS OF AND POSSIBLY A QUORUM OF MEMBERS OF OTHER GOVERNMENTAL BODIES OF THE MUNICIPALITY MAY BE IN ATTENDANCE AT THE ABOVE-STATED MEETING TO GATHER INFORMATION; NO ACTION WILL BE TAKEN BY ANY GOVERNMENTAL BODY AT THE ABOVE-STATED MEETING OTHER THAN THE GOVERNMENTAL BODY SPECIFICALLY REFERRED TO ABOVE IN THIS NOTICE. ALSO, UPON REASONABLE NOTICE, EFFORTS WILL BE MADE TO ACCOMMODATE THE NEEDS OF DISABLED INDIVIDUALS THROUGH APPROPRIATE AIDS AND SERVICES. FOR ADDITIONAL INFORMATION OR TO REQUEST THIS SERVICE, MUSKEGO CITY HALL, (262) 679-4100. Packet Page 2 OPERATOR LICENSE APPROVALS COMMON COUNCIL – 05/22/2018 Samantha Ahern Martha Alexander Wendy Block Jacqui Elfering Mary Frami Michael Gollinger Kristen Hanson T:\Departments\FinanceAdmin\Clerk\Licenses\Oper Lic Approval Lists\2018 Page 1 of 1 Recommend Approval of Operator Licenses Packet Page 3 Page 1 of 1 Recommend Approval of Temporary License to Sell... Packet Page 4 Page 1 of 1 Recommend Approval of Outside Dance Permit for Tres... Packet Page 5 Page 1 of 1 Recommend Approval of Outside Dance Permit for A.J.'s... Packet Page 6 CITY OF MUSKEGO To: Finance Committee From:Jill Blenski, Deputy Clerk Department: Finance and Administration Subject: Acceptance of Bid for City’s Official Newspaper Date:May 16, 2018 Background Information: The City is required to advertise annually for bids for its official newspaper. Wis. Statute 985 regulates official newspapers. The Advertisement for Bids was published in the Waukesha NOW as required by state statute. The City received one bid from USA Today Network/NOW Media Group. Key Issues for Consideration: 1. The statute requires that the paper making the lowest effective bid shall be awarded the contract. 2. The bid submitted does not reflect an increase. 3. The publishing fees are governed by Wisconsin State Statutes. Recommendation for Action by Committee and/or Council: Recommend acceptance of the bid submitted by the Journal Sentinel designating the Muskego Now as the City’s official newspaper. Date of Committee Action: May 22, 2018 Planned Date of Council Action (if required): May 22, 2018 $ Budgeted: Money has been budgeted for publication costs. When applicable, the cost of publication is passed on to the customer. (5/2018) Page 1 of 1 Recommendation Regarding Official City Newspaper Packet Page 7 Page 1 of 2 Recommend Expenditure for No Trucking Signage Packet Page 8 Page 2 of 2 Recommend Expenditure for No Trucking Signage Packet Page 9 Page 1 of 1 Discuss Military Leave for Police Officers Daniel Gaenslen... Packet Page 10 Council Date MAY 22, 2018 Total Vouchers All Funds $1,204,849.57 Total Voucher Approval Utility Vouchers (Approve Separately) Water Vouchers $12,218.77 Water Wire Transfers Total Water $12,218.77 Sewer Vouchers 15,788.91 Sewer Wire Transfers Total Sewer $15,788.91 Net Total Utility Vouchers $ 28,007.68 #1 - Utility Voucher Approval Tax Vouchers - Refunds & Tax Settlements (Approve Separately) Tax Vouchers $ Tax Void Checks ()** Total Tax Vouchers $ - #2 - Tax Voucher Approval Total General Fund Vouchers (Approve Separately) General Fund Vouchers $1,176,796.30 General Fund Void Checks ()** Total General Fund Vouchers $ 1,176,796.30 #3 - General Voucher Approval Big Muskego Lake Vouchers $45.59 Development Fund Vouchers $ Wire transfers (Approve Separately): Tax Settlements $ Debt Service $ Payroll/Invoice Transmittals $341,993.70 #4 - Wire Transfers Approval Void Checks Since Last Report Check #Amount Check #Amount 809308 1,034.29 Total *** Total 1,034.29 *Total *** Page 1 of 16 VOUCHER REPORT Packet Page 11 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 1 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Report Criteria: Detail report. Invoices with totals above $0 included. Paid and unpaid invoices included. [Report].Description = {<>} "1099 adjustment" Invoice Detail.Type = {>} "adjustments" Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number ABSOLUTE CONSTRUCTION ENTERPRISES 3566 1 Invoice CITY HALL ADDITION 04/30/2018 05/22/2018 397,529.09 518 401.08.90.09.6550 Total ABSOLUTE CONSTRUCTION ENTERPRISES:397,529.09 ACE HARDWARE - WINDLAKE 102824 1 Invoice GARBAGE BAGS 04/05/2018 05/22/2018 83.94 518 601.61.61.15.5415 102824 2 Invoice PENCILS PAPER 04/05/2018 05/22/2018 5.28 518 601.61.63.42.5701 Total ACE HARDWARE - WINDLAKE:89.22 ADVANCED DISPOSAL - MUSKEGO-C6 C60001495674 1 Invoice TRASH 04/30/2018 05/22/2018 45,691.81 518 205.03.30.00.5820 C60001495674 2 Invoice RECYCLING 04/30/2018 05/22/2018 24,038.28 518 205.03.00.00.5820 C60001495674 3 Invoice YARD WASTE 04/30/2018 05/22/2018 1,420.22 518 205.03.00.00.6056 Total ADVANCED DISPOSAL - MUSKEGO-C6:71,150.31 ALSCO 042510/052218 1 Invoice UNIFORMS 04/26/2018 05/22/2018 330.08 518 100.04.51.07.5704 042510/052218 2 Invoice UNIFORMS 04/26/2018 05/22/2018 109.49 518 601.61.61.12.5702 042510/052218 3 Invoice UNIFORMS 04/26/2018 05/22/2018 109.49 518 605.56.09.21.5835 042511/052218 1 Invoice UNIFORMS 04/26/2018 05/22/2018 159.84 518 100.04.51.07.5704 042511/052218 2 Invoice UNIFORMS 04/26/2018 05/22/2018 45.16 518 601.61.61.12.5702 042511/052218 3 Invoice UNIFORMS 04/26/2018 05/22/2018 45.16 518 605.56.09.21.5835 Total ALSCO:799.22 ARING EQUIPMENT CO., INC 588773 1 Invoice PARTS 04/11/2018 05/22/2018 885.72 518 100.04.51.07.5405 Total ARING EQUIPMENT CO., INC:885.72 ASSOCIATED BAG COMPANY N870260 1 Invoice BAGS PARKS 05/04/2018 05/22/2018 1,081.25 518 100.04.51.11.5415 Total ASSOCIATED BAG COMPANY:1,081.25 AT & T 262679410605/ 1 Invoice CENTREX LINES 05/01/2018 05/22/2018 591.20 518 100.01.06.00.5601 Total AT & T:591.20 BAKER & TAYLOR COMPANY 2033676324 1 Invoice PRINT 04/26/2018 05/22/2018 961.15 518 100.05.71.01.5711 2033683104 1 Invoice PRINT 05/01/2018 05/22/2018 3,063.55 518 100.05.71.01.5711 2033689785 1 Invoice PRINT 05/02/2018 05/22/2018 2,222.66 518 100.05.71.01.5711 2033704763 1 Invoice PRINT 05/08/2018 05/22/2018 800.28 518 100.05.71.01.5711 3089743 1 Invoice PRINT 04/25/2018 05/22/2018 24.48- 518 100.05.71.01.5711 5014983973 1 Invoice PRINT 04/25/2018 05/22/2018 187.20 518 100.05.71.01.5711 5014994845 1 Invoice PRINT 05/02/2018 05/22/2018 113.07 518 100.05.71.01.5711 Page 2 of 16 VOUCHER REPORT Packet Page 12 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 2 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number 5015005358 1 Invoice PRINT 05/09/2018 05/22/2018 165.68 518 100.05.71.01.5711 Total BAKER & TAYLOR COMPANY:7,489.11 BAKER & TAYLOR ENTERTAINMENT B88421660 1 Invoice AV 04/24/2018 05/22/2018 114.11 518 100.05.71.02.5711 B88421661 1 Invoice AV 04/24/2018 05/22/2018 5.03 518 100.05.71.02.5711 B89008180 1 Invoice AV 05/01/2018 05/22/2018 64.77 518 100.05.71.02.5711 B89140790 1 Invoice AV 05/02/2018 05/22/2018 25.19 518 100.05.71.02.5711 B89226810 1 Invoice AV 05/03/2018 05/22/2018 14.23 518 100.05.71.02.5711 B89637940 1 Invoice AV 05/08/2018 05/22/2018 93.56 518 100.05.71.02.5711 Total BAKER & TAYLOR ENTERTAINMENT:316.89 BAYCOM INC EQUIPINV_014 1 Invoice ARBITRATOR FOR NEW SQUAD 05/10/2018 05/22/2018 5,753.00 518 100.07.20.01.6501 Total BAYCOM INC:5,753.00 BEACON ATHLETICS 0488746-IN 1 Invoice BALL PARK 04/12/2018 05/22/2018 821.12 518 202.08.94.74.6572 0488746-IN 2 Invoice BALL PARK 04/12/2018 05/22/2018 57.03 518 202.08.94.74.6571 0488746-IN 3 Invoice BALL PARK 04/12/2018 05/22/2018 102.64 518 202.08.94.74.6570 0488746-IN 4 Invoice BALL PARK 04/12/2018 05/22/2018 228.09 518 202.08.94.74.6575 0488746-IN 5 Invoice BALL PARK 04/12/2018 05/22/2018 1,072.02 518 202.08.94.74.6530 0489454-IN 2 Invoice BALL PARK 04/24/2018 05/22/2018 5.78 518 202.08.94.74.6571 0489454-IN 3 Invoice BALL PARK 04/24/2018 05/22/2018 10.39 518 202.08.94.74.6570 0489454-IN 4 Invoice BALL PARK 04/24/2018 05/22/2018 23.08 518 202.08.94.74.6575 0489454-IN 5 Invoice BALL PARK 04/24/2018 05/22/2018 108.49 518 202.08.94.74.6530 0489454-IN 1 Invoice BALL PARK 04/24/2018 05/22/2018 83.10 518 202.08.94.74.6572 Total BEACON ATHLETICS:2,511.74 BEST SPECIALITIES INC. 57103 1 Invoice NEW CITY HALL ACCESSORIES-T 04/04/2018 05/22/2018 1,540.00 518 401.08.90.09.6550 Total BEST SPECIALITIES INC.:1,540.00 BRAD'S RUSTIC WOOD CREATIONS BR052218-PD 1 Invoice WOODEN FLAGS FOR NEW PD LO 05/11/2018 05/22/2018 150.00 518 505.00.00.00.2637 Total BRAD'S RUSTIC WOOD CREATIONS:150.00 BROCK WHITE COMPANY LLC 12885758-00 1 Invoice IDLE ISLE PAY BOX 04/24/2018 05/22/2018 98.40 518 100.04.51.11.5415 Total BROCK WHITE COMPANY LLC:98.40 BRODART CO. 499952 1 Invoice PROCESSING SUPPLIES 05/03/2018 05/22/2018 759.20 518 100.05.71.00.5702 Total BRODART CO.:759.20 CDW GOVERNMENT, INC MMX9052 1 Invoice LONGER POWER CORDS TV-CHA 04/26/2018 05/22/2018 12.50 518 401.08.90.09.6550 Total CDW GOVERNMENT, INC:12.50 Page 3 of 16 VOUCHER REPORT Packet Page 13 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 3 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number CENTURY LINK 1439631585 1 Invoice LONG DISTANCE 04/30/2018 05/22/2018 5.15 518 100.01.06.00.5601 Total CENTURY LINK:5.15 COMMUNITY MEMORIAL HOSPITAL 2514021 1 Invoice BLOOD DRAW 04/17/2018 05/22/2018 33.00 518 100.02.20.01.5722 2608883 1 Invoice BLOOD DRAW 04/23/2018 05/22/2018 33.00 518 100.02.20.01.5722 2630459/05221 1 Invoice BLOOD DRAW 04/07/2018 05/22/2018 33.00 518 100.02.20.01.5722 2728246 1 Invoice BLOOD DRAW 04/26/2018 05/22/2018 33.00 518 100.02.20.01.5722 Total COMMUNITY MEMORIAL HOSPITAL:132.00 COMPASS MINERALS AMERICA 254358 1 Invoice 110.61 SALT 04/26/2018 05/22/2018 6,700.75 518 100.04.51.05.5747 254801 1 Invoice 45.16 TON SALT 04/27/2018 05/22/2018 2,735.79 518 100.04.51.05.5747 Total COMPASS MINERALS AMERICA:9,436.54 COMPLETE OFFICE OF WIS 309810 1 Invoice DYMO LABELS 05/03/2018 05/22/2018 80.30 518 100.01.03.00.5701 314649 1 Invoice STORAGE BOXES 05/10/2018 05/22/2018 106.27 518 100.06.18.01.5701 317512 1 Invoice LIBRARY MAINT 05/15/2018 05/22/2018 274.00 518 100.05.71.00.5415 Total COMPLETE OFFICE OF WIS:460.57 CONSERV FS INC 60016061 1 Invoice OIL 04/30/2018 05/22/2018 58.70 518 100.04.51.07.5735 Total CONSERV FS INC:58.70 CORE & MAIN LP I854478 1 Invoice ENTERPRISE MAIN BREAK 05/10/2018 05/22/2018 1,791.74 518 605.54.06.51.5410 Total CORE & MAIN LP:1,791.74 CUMMINS NPOWER LLC F6-5549 1 Invoice JENSEN 04/17/2018 05/22/2018 2,651.00 518 601.61.61.16.5411 Total CUMMINS NPOWER LLC:2,651.00 DAN KRALL & CO., INC. 65255 1 Invoice REBUILD CYLINDER 04/30/2018 05/22/2018 480.00 518 100.04.51.07.5405 Total DAN KRALL & CO., INC.:480.00 DC MOTORS PLUS INC 74950 1 Invoice SCISSOR LIFT RENTAL 04/19/2018 05/22/2018 450.00 518 100.04.51.07.5410 Total DC MOTORS PLUS INC:450.00 DELL MARKETING L.P. 10240149190 1 Invoice LAPTOP NEW VAN 05/04/2018 05/22/2018 2,259.19 518 410.08.91.20.6527 Total DELL MARKETING L.P.:2,259.19 DEMCO EDUCATIONAL CORP 6372037 1 Invoice PROCESSING 05/08/2018 05/22/2018 192.66 518 100.05.71.00.5702 Page 4 of 16 VOUCHER REPORT Packet Page 14 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 4 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number FOL6359641 1 Invoice FOL - SUMMER READING SHIRTS 04/24/2018 05/22/2018 47.00 518 100.05.71.00.6062 Total DEMCO EDUCATIONAL CORP:239.66 DEPT OF NATURAL RESOURCES/ DNR 370-00000079 1 Invoice BURN GEAR 04/24/2018 05/22/2018 380.02 518 215.06.00.00.6008 Total DEPT OF NATURAL RESOURCES/ DNR:380.02 DF TOMASINI, INC. DF052218-EN 1 Invoice EMERGENCY REPAIR NORTH SH 04/20/2018 05/22/2018 11,372.04 518 100.04.51.04.5745 Total DF TOMASINI, INC.:11,372.04 DIVERSIFIED BENEFIT SERV INC. 261577 1 Invoice HRA FEE/MAY 05/01/2018 05/22/2018 364.25 518 100.01.06.00.5203 Total DIVERSIFIED BENEFIT SERV INC.:364.25 EAGLE MEDIA, INC. EA052218-PD 1 Invoice KRAUS UNIFORMS 02/20/2018 05/22/2018 195.90 518 100.02.20.01.5151 Total EAGLE MEDIA, INC.:195.90 ECITY TRANSACTIONS LLC 4020-34 1 Invoice MAY MONTHLY CHARGES 05/01/2018 05/22/2018 300.00 518 100.01.06.00.6014 4020-34 2 Invoice PARK & REC ADD ON 05/01/2018 05/22/2018 150.00 518 100.05.72.10.5506 4020-34 3 Invoice SEWER UTILITY CHARGES 05/01/2018 05/22/2018 30.00 518 601.61.63.42.5701 4020-34 4 Invoice WATER UTILITY CHARGES 05/01/2018 05/22/2018 30.00 518 605.56.09.21.5712 Total ECITY TRANSACTIONS LLC:510.00 ELLIOTT'S ACE HARDWARE 601005/052218 1 Invoice FUEL FILTER - TOM ZAGAR 04/30/2018 05/22/2018 4.29 518 215.06.00.00.5704 601005/052218 2 Invoice MAINT VEHICLE 04/30/2018 05/22/2018 4.98 518 100.01.09.00.5405 601005/052218 3 Invoice CH MAINT 04/30/2018 05/22/2018 9.97 518 100.01.09.00.5415 601005/052218 4 Invoice CH MAINT 04/30/2018 05/22/2018 70.96 518 100.01.09.00.5415 601005/052218 5 Invoice CH MAINT 04/30/2018 05/22/2018 13.28 518 100.01.09.00.5415 Total ELLIOTT'S ACE HARDWARE:103.48 ESCH CONSTRUCTION SUPPLY, INC. 583285 1 Invoice ASPHALT BLADE 05/02/2018 05/22/2018 375.00 518 100.04.51.07.5405 Total ESCH CONSTRUCTION SUPPLY, INC.:375.00 EWALD AUTOMOTIVE GROUP LLC 29665 1 Invoice SQAUD 3 REPLACEMENT 05/09/2018 05/22/2018 36,810.00 518 100.07.20.01.6501 Total EWALD AUTOMOTIVE GROUP LLC:36,810.00 FASTENAL COMPANY WIMUK71620 1 Invoice PARKS SUPPLIES 05/04/2018 05/22/2018 282.50 518 100.04.51.11.5702 Total FASTENAL COMPANY:282.50 FEH DESIGN 109006 1 Invoice CHILDRENS REDESIGN 05/01/2018 05/22/2018 1,318.29 518 410.08.90.71.6508 Page 5 of 16 VOUCHER REPORT Packet Page 15 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 5 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total FEH DESIGN:1,318.29 FICKAU INC. 76549 1 Invoice CITY HALL TVS 04/19/2018 05/22/2018 75.44 518 401.08.90.09.6550 76558 1 Invoice DPW KEYS 04/24/2018 05/22/2018 6.78 518 100.04.51.11.5702 Total FICKAU INC.:82.22 FINDAWAY WORLD,LLC 252365 1 Invoice AV 04/25/2018 05/22/2018 327.94 518 100.05.71.02.5711 Total FINDAWAY WORLD,LLC:327.94 FIRST BUSINESS 0026/052218 1 Invoice CA ALCOHOL TRAINING 04/27/2018 05/22/2018 19.96 518 100.02.20.01.5721 0026/052218 2 Invoice SHOE POLISH 04/27/2018 05/22/2018 24.80 518 100.02.20.01.5722 0026/052218 3 Invoice INSERVICE FOOD 04/27/2018 05/22/2018 51.85 518 100.02.20.01.5722 0042/052218 1 Invoice WRWC CONFERENCE 04/27/2018 05/22/2018 286.43 518 605.56.09.21.5303 0042/052218 2 Invoice WTR SAMPLES 04/27/2018 05/22/2018 89.10 518 605.53.06.32.5702 0067/052218 1 Invoice AMAZON WEB SERVICE-MO 04/27/2018 05/22/2018 127.90 518 100.01.14.00.5507 0067/052218 2 Invoice ROZMAN TRUE VAULE- SHIP BAC 04/27/2018 05/22/2018 14.38 518 100.02.20.01.5504 0067/052218 3 Invoice FORCED AIR- MOUNTING GEAR A 04/27/2018 05/22/2018 142.72 518 401.08.90.09.6550 0067/052218 4 Invoice DH WIRELESS- SENT TO REPAIR 04/27/2018 05/22/2018 50.00 518 100.02.20.01.5504 0067/052218 5 Invoice AMAZON-COURT HEADSET 04/27/2018 05/22/2018 295.79 518 100.01.08.00.5504 0067/052218 6 Invoice ADOBE- MO. SUB DRONE 04/27/2018 05/22/2018 21.01 518 100.02.20.01.5504 0067/052218 7 Invoice AMAZON-POWERSUPPLY-04/27/2018 05/22/2018 29.90 518 100.01.14.00.5701 0067/052218 8 Invoice CDWG-PD PRINTER- VAN 04/27/2018 05/22/2018 295.63 518 410.08.91.20.6527 0067/052218 9 Invoice BEST BUY- MOUNTS CH CHAMBE 04/27/2018 05/22/2018 288.00 518 401.08.90.09.6550 0067/052218 10 Invoice AMAZON-POWERSUPPLY-SANDIS 04/27/2018 05/22/2018 4.99 518 100.01.14.00.5701 0083/052218 1 Invoice LUNCH FOR VOLUNTEERS 04/27/2018 05/22/2018 41.26 518 215.06.00.00.5704 0286/052218 1 Invoice LEXIS NEXIS SUBSCRIPTION CON 04/27/2018 05/22/2018 281.19 518 100.01.05.00.5506 0286/052218 2 Invoice PARKING - 724 N 2ND MILWAUKEE 04/27/2018 05/22/2018 7.00 518 100.01.05.00.5701 0463/052218 1 Invoice TOLL FREE PHONE NUMBER 04/27/2018 05/22/2018 14.86 518 100.06.18.01.5704 3469/052218 1 Invoice SUPPLIES 04/27/2018 05/22/2018 67.75 518 100.05.71.00.5701 3469/052218 2 Invoice WLA MEMBERSHIP 04/27/2018 05/22/2018 219.00 518 100.05.71.00.5305 3469/052218 3 Invoice WLA CONFERENCE 04/27/2018 05/22/2018 147.00 518 100.05.71.00.5303 3469/052218 4 Invoice PROGRAMMING - BRIDGES INNO 04/27/2018 05/22/2018 1,539.78 518 100.05.71.00.6062 3897/052218 1 Invoice AV 04/27/2018 05/22/2018 195.39 518 100.05.71.02.5711 3897/052218 2 Invoice PRINT 04/27/2018 05/22/2018 79.27 518 100.05.71.01.5711 3913/052218 1 Invoice MAKERSPACE CONFERENCE 04/27/2018 05/22/2018 82.83 518 100.05.71.00.5303 3921/052218 1 Invoice SCHOOLS OUT SNACKS 04/27/2018 05/22/2018 56.38 518 100.05.72.16.5702 3921/052218 2 Invoice PRESCHOOL FIELD TRIP 04/27/2018 05/22/2018 180.00 518 100.05.72.16.5820 3921/052218 3 Invoice VOLLEYBALLS SPORTS EQUIPME 04/27/2018 05/22/2018 117.68 518 100.05.72.13.5702 3921/052218 4 Invoice DNR CERTIFICATION FEES HUNT 04/27/2018 05/22/2018 240.00 518 100.05.72.14.5110 4273/052218 1 Invoice ELECTION FOOD 04/27/2018 05/22/2018 168.98 518 100.01.03.00.5704 4273/052218 2 Invoice POLICE RANGE 04/27/2018 05/22/2018 23.48 518 100.02.20.01.6023 4273/052218 3 Invoice VENDING 04/27/2018 05/22/2018 12.00 518 100.01.06.00.5702 4273/052218 4 Invoice CH MAINT 04/27/2018 05/22/2018 26.69 518 100.01.09.00.5415 4273/052218 5 Invoice POLICE MAINT 04/27/2018 05/22/2018 6.88 518 100.02.20.01.5415 5731/052218 1 Invoice SKROEGER - APWA CONFERENC 04/27/2018 05/22/2018 460.00 518 100.04.19.00.5303 5731/052218 2 Invoice SKROEGER - APWA CONFERENC 04/27/2018 05/22/2018 276.29 518 100.04.19.00.5303 6904/052218 1 Invoice CREDIT BOAT - TAX 04/27/2018 05/22/2018 52.75- 518 410.08.91.20.6513 6904/052218 2 Invoice BOAT 04/27/2018 05/22/2018 1,087.04 518 410.08.91.20.6513 6904/052218 3 Invoice TARGETS - RANGE 04/27/2018 05/22/2018 128.46 518 100.02.20.01.6023 6947/052218 1 Invoice MAILBOX SUPPLIES 04/27/2018 05/22/2018 8.23 518 100.04.51.05.5704 6947/052218 2 Invoice DENOON REPAIRS 04/27/2018 05/22/2018 256.00 518 100.04.51.11.5415 6947/052218 3 Invoice IT & TV SUPPLIES CITY HALL 04/27/2018 05/22/2018 121.97 518 401.08.90.09.6550 Page 6 of 16 VOUCHER REPORT Packet Page 16 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 6 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number 6947/052218 4 Invoice FORK LIFT REPAIRS 04/27/2018 05/22/2018 31.00 518 100.04.51.07.5405 9960/052218 1 Invoice WMCA DIST 5 MTG 5/17/18 - JILL & 04/27/2018 05/22/2018 56.00 518 100.01.03.00.5303 9994/052218 1 Invoice FONS/SIPPEL SCHOOL 04/27/2018 05/22/2018 2,000.00 518 100.02.20.01.5301 9994/052218 2 Invoice CURRAN/SARTORIUS SCHOOL 04/27/2018 05/22/2018 540.00 518 100.02.20.01.5301 9994/052218 3 Invoice KRAUS SCHOOL - ROOM 04/27/2018 05/22/2018 246.00 518 100.02.20.01.5301 9994/052218 4 Invoice SPITMASKS 04/27/2018 05/22/2018 152.43 518 100.02.20.01.5722 FOL 3871/0522 1 Invoice PROGRAMMING -ADULT 04/27/2018 05/22/2018 23.33 518 100.05.71.00.6062 FOL 3871/0522 2 Invoice STAFF APPRECIATION - FOL 04/27/2018 05/22/2018 189.58 518 100.05.71.00.5701 FOL 3905/0522 1 Invoice YA PROGRAMMING - FOL 04/27/2018 05/22/2018 160.00 518 100.05.71.00.6062 FOL 3905/0522 2 Invoice WLA MEMBERSHIP 04/27/2018 05/22/2018 132.00 518 100.05.71.00.5305 FOL 3905/0522 3 Invoice WLA CONFERENCE 04/27/2018 05/22/2018 125.00 518 100.05.71.00.5303 Total FIRST BUSINESS:11,190.46 FLEET CHARGE 2165813P 1 Invoice FILTER S 03/23/2018 05/22/2018 76.48 518 100.04.51.07.5405 2167713P 1 Invoice RING O TURBO TUBE KIT 04/18/2018 05/22/2018 3,271.77 518 100.04.51.07.5405 2167713PX1 1 Invoice #8 PIPE AIR CLEANE ASSBLY HOS 04/19/2018 05/22/2018 119.74 518 100.04.51.07.5405 2167713PX2 1 Invoice CLAMP HOSE ASSBLY 04/24/2018 05/22/2018 24.40 518 100.04.51.07.5405 2168104P 1 Invoice BRACKET SOLENOI 04/24/2018 05/22/2018 128.68 518 100.04.51.07.5405 2169039P 1 Invoice #10 BELT 05/08/2018 05/22/2018 101.17 518 100.04.51.07.5405 CM2162317P 1 Invoice CORE RETURN 03/26/2018 05/22/2018 631.75- 518 100.04.51.07.5405 CM2164386P 1 Invoice CORE RETURN 03/26/2018 05/22/2018 199.50- 518 100.04.51.07.5405 Total FLEET CHARGE:2,890.99 FOTH INFRASTRUCTURE & 56631 1 Invoice HILLENDALE DRIVE RECONSTRU 05/07/2018 05/22/2018 3,376.72 518 401.08.91.19.6507 Total FOTH INFRASTRUCTURE &:3,376.72 FRANKLIN AGGREGATES, INC. 1546790 1 Invoice STONE 05/10/2018 05/22/2018 3,195.26 518 100.04.51.02.5741 1546791 1 Invoice STONE 05/10/2018 05/22/2018 6,863.14 518 100.04.51.02.5741 1546792 1 Invoice STONE 05/10/2018 05/22/2018 3,765.43 518 100.04.51.02.5741 Total FRANKLIN AGGREGATES, INC.:13,823.83 FRANKLIN POLICE DEPT. 14647 1 Invoice WHITNEY KSOBIECH WARRANT - 05/13/2018 05/22/2018 376.00 518 100.01.08.00.4272 Total FRANKLIN POLICE DEPT.:376.00 GAIL FORCE ENTERPRISES 5422 1 Invoice CLASS INSTRUCTION SPRING YO 05/04/2018 05/22/2018 132.00 518 100.05.72.13.5110 5423 1 Invoice CLASS INSTRUCTION FRI IN APRI 05/05/2018 05/22/2018 33.00 518 100.05.72.13.5110 Total GAIL FORCE ENTERPRISES:165.00 GENERAL CODE PG000014994 1 Invoice RECODE PROJECT 04/30/2018 05/22/2018 7,474.00 518 410.08.90.01.6502 PG000014994 2 Invoice SUBSCRIPTION 04/30/2018 05/22/2018 995.00 518 100.01.06.00.5506 Total GENERAL CODE:8,469.00 GLEASON REDI MIX 263159 1 Invoice REDI MIX 04/24/2018 05/22/2018 350.00 518 100.04.51.04.5744 263228 1 Invoice REDI MIX 04/25/2018 05/22/2018 650.00 518 100.04.51.04.5744 Page 7 of 16 VOUCHER REPORT Packet Page 17 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 7 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number 263363 1 Invoice REDI MIX 04/27/2018 05/22/2018 700.00 518 100.04.51.04.5744 263859 1 Invoice REDIMIX 05/09/2018 05/22/2018 271.00 518 100.04.51.04.5744 Total GLEASON REDI MIX:1,971.00 GRAEF INC 0097295 1 Invoice ROAD PROGRAM 04/24/2018 05/22/2018 299.00 518 100.07.51.02.6502 0097295 2 Invoice PARKLAND TOWN CENTER 04/24/2018 05/22/2018 489.00 518 507.00.00.00.2643 0097295 3 Invoice MSP MUSKEGO 04/24/2018 05/22/2018 372.13 518 507.00.00.00.2697 0097295 4 Invoice CITY HALL PROJECT 04/24/2018 05/22/2018 2,263.00 518 401.08.90.09.6550 0097295 5 Invoice MOORLAND ROAD PROJECT 04/24/2018 05/22/2018 2,853.73 518 410.08.91.19.6503 0097295 6 Invoice NORTH CAPE ROAD 04/24/2018 05/22/2018 1,022.09 518 507.00.00.00.2732 0097295 7 Invoice THE GLEN AT PELLMAN FARM 04/24/2018 05/22/2018 4,222.35 518 507.00.00.00.2691 0097295 8 Invoice PINNACLE PEAK 04/24/2018 05/22/2018 848.00 518 507.00.00.00.2728 0097296 1 Invoice PPII 04/24/2018 05/22/2018 905.00 518 601.61.63.43.5815 0097296 2 Invoice ROYAL RECOGNITION PROPERTY 04/24/2018 05/22/2018 327.42 518 507.00.00.00.2760 0097296 3 Invoice MHS CONCESSION STAND 04/24/2018 05/22/2018 800.61 518 507.00.00.00.2732 0097296 4 Invoice HI VIEW CONSTRUCTION 04/24/2018 05/22/2018 671.19 518 507.00.00.00.2733 0097296 5 Invoice 4FRONT DEVELOPMENT 04/24/2018 05/22/2018 519.16 518 507.00.00.00.2644 0097296 6 Invoice JEWELL HILLENDALE 2 LOT CSM 04/24/2018 05/22/2018 2,884.10 518 507.00.00.00.2750 0097296 7 Invoice HILLENDALE FORCE MAIN STUDY 04/24/2018 05/22/2018 184.00 518 605.00.00.00.1984 0097296 8 Invoice JEWELL FORCE MAIN 04/24/2018 05/22/2018 4,137.47 518 507.00.00.00.2750 0097296 9 Invoice 4FRONT ENGINEERING SOLUTIO 04/24/2018 05/22/2018 330.71 518 507.00.00.00.2644 0097296 10 Invoice COMMERCE CENTER INDUSTRIA 04/24/2018 05/22/2018 323.24 518 507.00.00.00.2791 0097296 11 Invoice LML DAM INSPECTION 04/24/2018 05/22/2018 949.03 518 100.04.51.09.5744 0097296 12 Invoice MNSD FIBER OPTIC UTILITY REVI 04/24/2018 05/22/2018 1,203.25 518 507.00.00.00.2732 0097296 13 Invoice PREPARE CITY RFPS 04/24/2018 05/22/2018 23.25 518 202.08.94.74.6575 0097296 14 Invoice RACINE AVE & MARTIN DR TRAIL 04/24/2018 05/22/2018 1,398.00 518 202.08.94.74.6573 0097296 15 Invoice BAY LANE RECONSTRUCTION 04/24/2018 05/22/2018 323.00 518 410.08.91.19.6504 0097296 16 Invoice ROAD PROGRAM 04/24/2018 05/22/2018 4,891.69 518 100.07.51.02.6502 0097297 1 Invoice GENERAL ENGINEERING SERVIC 04/24/2018 05/22/2018 3,116.85 518 100.04.19.00.5815 0097298 1 Invoice SKYLARK LANE CULVERT EVAL 04/24/2018 05/22/2018 215.16 518 100.04.19.00.5815 0097299 1 Invoice LML DREDGING HAUL ROUTE RE 04/24/2018 05/22/2018 2,100.00 518 100.04.19.00.5815 0097300 1 Invoice HILLENDALE RECONSTRUCTION 04/24/2018 05/22/2018 813.50 518 410.08.91.19.6507 0097301 1 Invoice MS4 PERMIT 04/24/2018 05/22/2018 184.00 518 100.04.19.00.5815 0097302 1 Invoice HI VIEW WATER MAIN CONSTRUC 04/24/2018 05/22/2018 3,250.17 518 507.00.00.00.2733 0097303 1 Invoice MHS BLEACHER REVIEW 04/24/2018 05/22/2018 687.50 518 507.00.00.00.2729 0097304 1 Invoice ATHLETIC FIELD MAINTENANCE B 04/24/2018 05/22/2018 671.10 518 100.04.19.00.5815 0097305 1 Invoice PORTABLE TOILET BID 04/24/2018 05/22/2018 504.75 518 100.04.19.00.5815 0097306 1 Invoice TENNIS COURT PROJECT MANUA 04/24/2018 05/22/2018 1,932.75 518 202.08.94.74.6575 0097307 1 Invoice MUSKEGO GARDENS DEVELOPM 04/24/2018 05/22/2018 276.00 518 507.00.00.00.2745 0097308 1 Invoice VERIZON FIBER OPTIC 04/24/2018 05/22/2018 75.00 518 100.04.19.00.5815 0097309 1 Invoice WATER MAIN RELAY COSTS 04/24/2018 05/22/2018 444.46 518 100.04.19.00.5815 0097310 1 Invoice WILL ROSE APTS 04/24/2018 05/22/2018 230.00 518 507.00.00.00.2699 0097311 1 Invoice MHS SYNTHETIC FIELD 04/24/2018 05/22/2018 345.00 518 507.00.00.00.2732 0097312 1 Invoice CASEY'S GENERAL STORE 04/24/2018 05/22/2018 46.00 518 507.00.00.00.2767 0097313 1 Invoice GENERAL PLANNING 04/24/2018 05/22/2018 481.82 518 100.06.18.01.5801 0097313 2 Invoice APPLICANT REVIEW-CASEY'S GE 04/24/2018 05/22/2018 87.00 518 507.00.00.00.2767 0097313 3 Invoice PLANNING PERMIT REVIEW 04/24/2018 05/22/2018 1,239.90 518 100.06.18.01.5801 Total GRAEF INC:48,941.38 HEARTLAND BUSINESS SYSTEMS 260505-H 1 Invoice BLOCK OF HOURS-HEARTLAND C 04/26/2018 05/22/2018 5,000.00 518 100.01.14.00.5840 260718-H 1 Invoice CONSULANT BLOCK HOURS 04/26/2018 05/22/2018 .00 518 100.01.14.00.5840 Total HEARTLAND BUSINESS SYSTEMS:5,000.00 Page 8 of 16 VOUCHER REPORT Packet Page 18 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 8 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number HORN BROS, INC. 143435/142338 1 Invoice WELL 13 04/28/2018 05/22/2018 448.85 518 605.54.06.41.5702 Total HORN BROS, INC.:448.85 HUMPHREY SERVICE PARTS 1174876 1 Invoice PARKS BATHRM 05/01/2018 05/22/2018 118.16 518 100.04.51.11.5702 1175302 1 Invoice VALVE 05/04/2018 05/22/2018 14.22 518 100.04.51.07.5405 1175314 1 Invoice BOTTOM TAP 05/04/2018 05/22/2018 23.49 518 100.04.51.07.5405 Total HUMPHREY SERVICE PARTS:155.87 JM BRENNAN, INC. SALES000095 1 Invoice REPLACED MOTOR SHEAVE/BELT 04/25/2018 05/22/2018 480.38 518 100.05.71.00.5415 Total JM BRENNAN, INC.:480.38 JOERS, STACI JO052218-RE 1 Invoice COOKING CLASS INSTRUCTION 05/14/2018 05/22/2018 16.00 518 100.05.72.18.5110 Total JOERS, STACI:16.00 JOHN PAUL'S 466165 1 Invoice SQ 1 NUTS 05/04/2018 05/22/2018 61.40 518 100.02.20.01.5405 Total JOHN PAUL'S:61.40 JOURNAL SENTINEL INC 700556/052218 1 Invoice LML PROPOSED DREDGING 04/30/2018 05/22/2018 190.64 518 100.05.06.00.6052 700556/052218 2 Invoice JEWELL CROWBAR PUBLICATION 04/30/2018 05/22/2018 380.28 518 507.00.00.00.2777 700556/052218 3 Invoice MISC PUBLICATIONS 04/30/2018 05/22/2018 449.92 518 100.01.06.00.6001 700556/052218 4 Invoice BML 04/30/2018 05/22/2018 45.59 518 250.01.00.00.5710 Total JOURNAL SENTINEL INC:1,066.43 JUMP BUNCH OF WAUKESHA-LAKE COUNTRY 1771/051218 1 Invoice SUMMER PROGRAMMING 05/03/2018 05/22/2018 800.00 518 100.05.71.00.6062 Total JUMP BUNCH OF WAUKESHA-LAKE COUNTRY:800.00 KETTLE MORAINE LAND STEWARDS 252018 1 Invoice GUERNSEY WOODS PRESERVE A 05/10/2018 05/22/2018 1,745.00 518 215.06.00.00.6008 Total KETTLE MORAINE LAND STEWARDS:1,745.00 KUJAWA ENTERPRISES INC. 116117 1 Invoice PLANT SERVICE - MAY 05/07/2018 05/22/2018 61.00 518 100.05.71.00.5415 Total KUJAWA ENTERPRISES INC.:61.00 LEGACY RECYCLING 1373 1 Invoice EMERALD PARK LANDFILL MARC 05/04/2018 05/22/2018 1,478.96 518 205.03.00.00.5820 Total LEGACY RECYCLING:1,478.96 LITTLE MUSKEGO LAKE DIST 2193.970.049/0 1 Invoice CHECK-LITTLE LAKE PMT PETER 05/04/2018 05/22/2018 380.00 518 100.05.06.00.6052 Page 9 of 16 VOUCHER REPORT Packet Page 19 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 9 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total LITTLE MUSKEGO LAKE DIST:380.00 MAGILL CONSTRUCTION COMPANY MA052218-DP 1 Invoice DPW MERCURY & APOLLO BLDGS 05/10/2018 05/22/2018 354,130.55 518 401.08.93.51.6550 Total MAGILL CONSTRUCTION COMPANY:354,130.55 MARK J. RINDERLE TIRE INC. 127657 1 Invoice TRAILER TIRES 04/26/2018 05/22/2018 134.00 518 100.04.51.07.5735 127713 1 Invoice TIRES 05/01/2018 05/22/2018 517.60 518 100.02.20.01.5405 127781 1 Invoice TIRES 05/08/2018 05/22/2018 632.80 518 100.02.20.01.5405 Total MARK J. RINDERLE TIRE INC.:1,284.40 MCGINNESS, AMANDA 20197 1 Invoice CLASS CANCELLATION REFUND 05/10/2018 05/22/2018 76.00 518 100.05.72.13.4318 Total MCGINNESS, AMANDA:76.00 MICROMARKETING LLC 716783 1 Invoice AV 04/19/2018 05/22/2018 51.00 518 100.05.71.02.5711 717455 1 Invoice AV 04/25/2018 05/22/2018 35.00 518 100.05.71.02.5711 Total MICROMARKETING LLC:86.00 MIDWEST TAPE 96050541 1 Invoice AV 04/30/2018 05/22/2018 123.87 518 100.05.71.02.5711 96077884 1 Invoice AV 05/08/2018 05/22/2018 120.72 518 100.05.71.02.5711 Total MIDWEST TAPE:244.59 MIKOLAINIS, KAREN MUSK#109r/05 1 Invoice ZUMBA GOLD CLASS INSTRUCTI 05/10/2018 05/22/2018 140.00 518 100.05.72.13.5110 Total MIKOLAINIS, KAREN:140.00 MILW MET. SEWERAGE DISTRICT 086-18 1 Invoice 1ST QTR LANDFILLS 2018 05/04/2018 05/22/2018 10,202.20 518 601.61.61.03.6072 Total MILW MET. SEWERAGE DISTRICT:10,202.20 MUSKEGO PUBLIC LIBRARY PC052218-LIB 1 Invoice SUPPLIES 05/14/2018 05/22/2018 10.14 518 100.05.71.00.5701 PC052218-LIB 2 Invoice PROGRAMMING 05/14/2018 05/22/2018 11.99 518 100.05.71.00.6062 Total MUSKEGO PUBLIC LIBRARY:22.13 NABCO ENTRANCES 90051949 1 Invoice SERVICE CALL/LABOR - LIBRARY 04/24/2018 05/22/2018 139.00 518 100.05.71.00.5415 90052538 1 Invoice CH MAINT - FRONT DOORS 04/25/2018 05/22/2018 118.00 518 100.01.09.00.5415 Total NABCO ENTRANCES:257.00 NAPA AUTO PARTS 5266-220261 1 Invoice ZEKES TRACTOR 05/03/2018 05/22/2018 73.42 518 100.04.51.11.5405 5266-220294 1 Invoice TRAILER 05/04/2018 05/22/2018 8.99 518 100.04.51.07.5405 5266-220778 1 Invoice BATTERY FOR BOAT 05/10/2018 05/22/2018 120.71 518 100.02.20.01.5405 Page 10 of 16 VOUCHER REPORT Packet Page 20 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 10 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total NAPA AUTO PARTS:203.12 NAVIANT 0134548-IN 1 Invoice ONBASE CONVER. HELP 05/08/2018 05/22/2018 1,850.00 518 209.01.00.00.6050 Total NAVIANT:1,850.00 NEW BERLIN REDI-MIX, INC. 1044156 1 Invoice ENTERPRISE MAIN BREAK 05/10/2018 05/22/2018 988.20 518 605.54.06.51.5410 Total NEW BERLIN REDI-MIX, INC.:988.20 OLSON'S OUTDOOR POWER 101748 1 Invoice CHAIN SAW AND CASE 05/07/2018 05/22/2018 487.40 518 215.06.00.00.5704 Total OLSON'S OUTDOOR POWER:487.40 OTTO PAAP CO., INC. 127531 1 Invoice AIR CLEARNER 05/09/2018 05/22/2018 247.82 518 100.04.51.07.5405 127532 1 Invoice BLADE 05/09/2018 05/22/2018 184.23 518 100.04.51.11.5405 Total OTTO PAAP CO., INC.:432.05 PARAGON DEVELOPMENT SYS INC 01047115 1 Invoice COMPUTER REPLACMENT- DISPA 05/10/2018 05/22/2018 737.75 518 100.07.01.06.6501 01047116 1 Invoice COMPUTER REPLACMENTS-CH 05/10/2018 05/22/2018 5,360.00 518 100.07.01.06.6501 Total PARAGON DEVELOPMENT SYS INC:6,097.75 PARTSMASTER 23277760 1 Invoice CAP SCREWS NUTS SUPPLIES 04/23/2018 05/22/2018 634.26 518 100.04.51.07.5405 Total PARTSMASTER:634.26 PATRIOT FENCE AND CONSTRUCTION 2255 1 Invoice BACKSTOP ON PARK ARTHUR 05/02/2018 05/22/2018 6,320.00 518 100.01.06.00.6108 Total PATRIOT FENCE AND CONSTRUCTION:6,320.00 PENGUIN RANDOM HOUSE LLC 1087671042 1 Invoice AV 04/20/2018 05/22/2018 40.00 518 100.05.71.02.5711 1087786886 1 Invoice AV 05/01/2018 05/22/2018 40.00 518 100.05.71.02.5711 1087791642 1 Invoice AV 04/25/2018 05/22/2018 50.00 518 100.05.71.02.5711 Total PENGUIN RANDOM HOUSE LLC:130.00 PINKY ELECTRIC INC. 2632 1 Invoice LIGHT MENS BATHROOM IDLE ISL 05/03/2018 05/22/2018 117.00 518 100.04.51.11.5415 Total PINKY ELECTRIC INC.:117.00 PROF SERVICE INDUSTRIES, INC. 00564554 1 Invoice CITY HALL ADDITION 04/30/2018 05/22/2018 250.00 518 401.08.90.09.6550 Total PROF SERVICE INDUSTRIES, INC.:250.00 Page 11 of 16 VOUCHER REPORT Packet Page 21 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 11 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number PROHEALTH CARE 201804-0 1 Invoice BLOOD DRAWS 04/30/2018 05/22/2018 140.00 518 100.02.20.01.5722 Total PROHEALTH CARE:140.00 QUALITY HYDRO 27976 1 Invoice BOBCAT AUGER 05/04/2018 05/22/2018 909.95 518 100.04.51.07.5405 Total QUALITY HYDRO:909.95 QUILL CORP 13608 1 Invoice DESK PRINTER TONER 05/03/2018 05/22/2018 153.99 518 100.05.72.10.5701 Total QUILL CORP:153.99 R.A. SMITH INC. 136941 1 Invoice BAY LANE ROAD FINAL DESIGN 05/10/2018 05/22/2018 3,150.00 518 410.08.91.19.6504 Total R.A. SMITH INC.:3,150.00 RED THE UNIFORM TAILOR 00W69226 1 Invoice PETZ NAMETAG 04/30/2018 05/22/2018 15.00 518 100.02.20.01.5151 Total RED THE UNIFORM TAILOR:15.00 REGISTRATION FEE TRUST TRUCK19REG/ 1 Invoice PLATE #19 05/11/2018 05/22/2018 5.00 518 100.04.51.07.5405 Total REGISTRATION FEE TRUST:5.00 REINDERS BROS INC 1298258-00 1 Invoice BALL PARK 04/23/2018 05/22/2018 3,780.72 518 202.08.94.74.6572 1298258-00 2 Invoice BALL PARK 04/23/2018 05/22/2018 262.55 518 202.08.94.74.6571 1298258-00 3 Invoice BALL PARK 04/23/2018 05/22/2018 472.59 518 202.08.94.74.6570 1298258-00 4 Invoice BALL PARK 04/23/2018 05/22/2018 1,050.20 518 202.08.94.74.6575 1298258-00 5 Invoice BALL PARK 04/23/2018 05/22/2018 4,935.93 518 202.08.94.74.6530 1730544-00 1 Invoice NAIL 04/27/2018 05/22/2018 18.69 518 202.08.94.74.6572 1730544-00 2 Invoice NAIL 04/27/2018 05/22/2018 1.30 518 202.08.94.74.6571 1730544-00 3 Invoice NAIL 04/27/2018 05/22/2018 2.34 518 202.08.94.74.6570 1730544-00 4 Invoice NAIL 04/27/2018 05/22/2018 5.19 518 202.08.94.74.6575 1730544-00 5 Invoice NAIL 04/27/2018 05/22/2018 24.40 518 202.08.94.74.6530 2581979-00 1 Invoice BALL PARK 04/24/2018 05/22/2018 364.72 518 202.08.94.74.6572 2581979-00 2 Invoice BALL PARK 04/24/2018 05/22/2018 25.33 518 202.08.94.74.6571 2581979-00 3 Invoice BALL PARK 04/24/2018 05/22/2018 45.59 518 202.08.94.74.6570 2581979-00 4 Invoice BALL PARK 04/24/2018 05/22/2018 101.31 518 202.08.94.74.6575 2581979-00 5 Invoice BALL PARK 04/24/2018 05/22/2018 476.15 518 202.08.94.74.6530 Total REINDERS BROS INC:11,567.01 RELIANCE BARCODE SOLUTIONS 4647 1 Invoice PROCESSING SUPPLIES 04/24/2018 05/22/2018 518.32 518 100.05.71.00.5702 Total RELIANCE BARCODE SOLUTIONS:518.32 ROYAL RECOGNITION 18-70596 1 Invoice AWARDS CREEMONY CERTIFICAT 05/11/2018 05/22/2018 183.00 518 100.02.20.01.5722 Page 12 of 16 VOUCHER REPORT Packet Page 22 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 12 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total ROYAL RECOGNITION:183.00 RUNDLE-SPENCE S2663965.001 1 Invoice BLUHM REGULATOR 05/02/2018 05/22/2018 51.70 518 601.61.61.16.5411 Total RUNDLE-SPENCE :51.70 SAFEWAY PEST MANAGEMENT INC. 9092/052218 1 Invoice PEST CONTROL - CH APR 05/02/2018 05/22/2018 32.00 518 100.01.09.00.5415 9092/052218 2 Invoice PEST CONTROL - LIB APR 05/02/2018 05/22/2018 30.00 518 100.05.71.00.5415 9092/052218 3 Invoice PEST CONTROL - PD APR 05/02/2018 05/22/2018 38.00 518 100.02.20.01.5415 Total SAFEWAY PEST MANAGEMENT INC.:100.00 SCHMELING'S LANDSCAPE, LLC TREES/052218 1 Invoice TREES 05/08/2018 05/22/2018 4,885.00 518 100.01.06.00.5820 Total SCHMELING'S LANDSCAPE, LLC:4,885.00 SECURIAN FINANCIAL GROUP, INC. 002832L/05221 1 Invoice LIFE INSURANCE PREMIUMS - JU 05/09/2018 05/22/2018 2,704.17 518 100.00.00.00.2207 Total SECURIAN FINANCIAL GROUP, INC.:2,704.17 SERVICE SANITATION WISCONSIN INC 7514495 1 Invoice IDLE ISLE PARK 05/01/2018 05/22/2018 85.00 518 100.04.51.01.5820 7514496 1 Invoice SANDHILL PARK 05/01/2018 05/22/2018 85.00 518 100.04.51.01.5820 7514497 1 Invoice DENOON PARK (3)05/01/2018 05/22/2018 255.00 518 100.04.51.01.5820 7514498 1 Invoice JENSEN PARK 05/01/2018 05/22/2018 85.00 518 100.04.51.01.5820 7514499 1 Invoice BIG MUSKEGO LAKE BOAT LAUN 05/01/2018 05/22/2018 85.00 518 100.04.51.01.5820 7514500 1 Invoice BOXHORN BOAT LAUNCH 05/01/2018 05/22/2018 85.00 518 100.04.51.01.5820 7514501 1 Invoice MANCHESTER HILL PARK 05/01/2018 05/22/2018 85.00 518 100.04.51.01.5820 7514502 1 Invoice MOORLAND PARK 05/01/2018 05/22/2018 85.00 518 100.04.51.01.5820 7514503 1 Invoice RESTROOMS 05/01/2018 05/22/2018 85.00 518 215.06.00.00.5801 7514504 1 Invoice RESTROOMS 05/01/2018 05/22/2018 85.00 518 215.06.00.00.5801 Total SERVICE SANITATION WISCONSIN INC:1,020.00 SHRM (SOCIETY HUMAN RESOURCE) 9007509934 1 Invoice RENEWAL FEE - SHARON 05/15/2018 05/22/2018 209.00 518 100.01.03.00.5305 Total SHRM (SOCIETY HUMAN RESOURCE):209.00 SIRCHIE FINGER PRINT LAB 0349014-IN 1 Invoice EVIDENCE TUBING 05/15/2018 05/22/2018 83.44 518 100.02.20.01.5722 Total SIRCHIE FINGER PRINT LAB:83.44 SOMAR TEK LLC/ ENTERPRISES 100958 1 Invoice RAKERS FLASHLIGHT BATTERY 05/10/2018 05/22/2018 13.99 518 100.02.20.01.5151 100963 1 Invoice GAENSLEN UNIFORM 05/15/2018 05/22/2018 449.44 518 100.02.20.01.5151 100964 1 Invoice SHOCKLEY UNIFORM 05/15/2018 05/22/2018 439.11 518 100.02.20.01.5151 100965 1 Invoice HANDCUFFS NEW OFFICER 05/15/2018 05/22/2018 26.99 518 100.02.20.01.5151 Total SOMAR TEK LLC/ ENTERPRISES:929.53 Page 13 of 16 VOUCHER REPORT Packet Page 23 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 13 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number SPOK B0282335Q 1 Invoice PAGERS 04/30/2018 05/22/2018 8.14 518 601.61.63.42.5701 B0282335Q 2 Invoice PAGERS 04/30/2018 05/22/2018 8.14 518 605.56.09.21.5607 Total SPOK:16.28 STEPHAN, JOHN 21011 1 Invoice CLASS CANCELLATION REFUND 05/10/2018 05/22/2018 36.00 518 100.05.72.18.4318 Total STEPHAN, JOHN:36.00 STREICHER'S I1312105 1 Invoice GAS CANISTERS FOR TRAINING 04/27/2018 05/22/2018 534.00 518 100.02.20.01.5722 I1313926 1 Invoice ONDRICKA VEST 05/10/2018 05/22/2018 794.99 518 100.02.20.01.5227 Total STREICHER'S:1,328.99 SUPERIOR CHEMICAL 192913 1 Invoice PARKS SOAP 05/07/2018 05/22/2018 192.65 518 100.04.51.08.5415 Total SUPERIOR CHEMICAL:192.65 TAPCO INC. I600627 1 Invoice YELLOW VERTICLE 05/08/2018 05/22/2018 221.36 518 100.04.51.03.5743 Total TAPCO INC.:221.36 THE HAPPY MOWER 44 1 Invoice APRIL LAWN AND LANDSCAPE MA 05/05/2018 05/22/2018 6,928.57 518 100.01.06.00.5820 Total THE HAPPY MOWER:6,928.57 THE REESE GROUP, LLC RE052218-LIB 1 Invoice CHILDRENS REDESIGN 05/11/2018 05/22/2018 47,827.75 518 410.08.90.71.6508 Total THE REESE GROUP, LLC:47,827.75 TIME WARNER CABLE 043858401/052 1 Invoice CABLE BOXES 05/10/2018 05/22/2018 16.18 518 100.02.20.01.5415 063003301042 1 Invoice BUSINESS INTERENET CONNECTI 04/24/2018 05/22/2018 94.57 518 100.05.71.00.5505 701507601043 1 Invoice DEDICATED INTERNET CIRCUIT 05/06/2018 05/22/2018 1,045.00 518 100.01.14.00.5507 Total TIME WARNER CABLE:1,155.75 TRANSUNION RISK & ALTERNATIVE 911461/052218 1 Invoice REVERSE LOOKUP INVESTIGATIO 05/01/2018 05/22/2018 31.80 518 100.02.20.01.5722 Total TRANSUNION RISK & ALTERNATIVE:31.80 TYLER TECHNOLOGIES, INC 060-9266 1 Invoice ASSESSMENT SERVICES 05/04/2018 05/22/2018 8,460.00 518 100.01.04.00.5503 Total TYLER TECHNOLOGIES, INC:8,460.00 U.S. BANK NATIONAL ASSOCIATION S2018-05957 1 Invoice BANK FRAUD INVESTIGATION - W 05/04/2018 05/22/2018 25.75 518 100.02.20.01.5722 Page 14 of 16 VOUCHER REPORT Packet Page 24 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 14 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total U.S. BANK NATIONAL ASSOCIATION:25.75 U.S. CELLULAR 0246740444 1 Invoice MONTHLY CHARGE- PLANNING 04/28/2018 05/22/2018 10.00 518 100.06.18.01.5601 0246740444 2 Invoice MONTHLY CHARGE- POLICE 04/28/2018 05/22/2018 703.33 518 100.02.20.01.5604 0246740444 3 Invoice MONTHLY CHARGE- WATER SCA 04/28/2018 05/22/2018 70.00 518 605.56.09.21.5607 0246740444 4 Invoice MONTHLY CHARGE- SEWER SCA 04/28/2018 05/22/2018 70.00 518 601.61.63.42.5606 0246740444 5 Invoice MONTHLY CHARGE- IS 04/28/2018 05/22/2018 30.00 518 100.01.14.00.5601 0246740444 6 Invoice MONTHLY CHARGE- ENGINEERIN 04/28/2018 05/22/2018 10.00 518 100.04.19.00.5601 0246740444 7 Invoice MONTHLY CHARGE- LIBRARY 04/28/2018 05/22/2018 10.00 518 100.05.71.00.5602 0246740444 8 Invoice MONTHLY CHARGE- FINANCE 04/28/2018 05/22/2018 10.00 518 100.01.03.00.5601 0246740444 9 Invoice MONTHLY CHARGE- DPW 04/28/2018 05/22/2018 60.00 518 100.04.51.01.5605 0246740444 10 Invoice MONTHLY CHARGE- REC 04/28/2018 05/22/2018 10.00 518 100.05.72.10.5601 Total U.S. CELLULAR:983.33 USA BLUE BOOK 562869 1 Invoice HYD LOCK 05/03/2018 05/22/2018 49.95 518 605.54.06.54.5702 Total USA BLUE BOOK:49.95 VOYA SUBSCRIPTIONS 1054650-B1 1 Invoice PRINT 05/01/2018 05/22/2018 124.00 518 100.05.71.01.5711 Total VOYA SUBSCRIPTIONS:124.00 WAUKESHA COUNTY 107/052218 1 Invoice 4 FRONT MAINT AGRMT 04/30/2018 05/22/2018 30.00 518 507.00.00.00.2644 107/052218 2 Invoice MIDDLE SCHOOL MAINT AGRMT 04/30/2018 05/22/2018 30.00 518 507.00.00.00.2732 107/052218 3 Invoice 4 FRONT DEV AGRMT 04/30/2018 05/22/2018 30.00 518 507.00.00.00.2644 107/052218 4 Invoice S76 W18109 JANESVILLE ROAD D 04/30/2018 05/22/2018 30.00 518 100.04.19.00.5704 Total WAUKESHA COUNTY:120.00 WAUKESHA COUNTY TREASURER 2018-0000008 1 Invoice INMATE BILLING 05/08/2018 05/22/2018 1,302.64 518 100.01.08.00.6017 Total WAUKESHA COUNTY TREASURER:1,302.64 WE ENERGIES 0000-020-351/ 1 Invoice WELL'S GROUP 04/27/2018 05/22/2018 8,000.20 518 605.52.06.22.5910 3665-286-012/ 1 Invoice STREET LIGHTING 05/02/2018 05/22/2018 2,602.90 518 100.04.51.06.5910 3836-104-158/ 1 Invoice 4/18 L/S GROUP 05/01/2018 05/22/2018 1,417.61 518 601.61.61.20.5910 5499-564-961/ 1 Invoice LIBRARY - ELECTRIC 04/30/2018 05/22/2018 3,720.66 518 100.05.71.00.5910 5499-564-961/ 2 Invoice LIBRARY - GAS 04/30/2018 05/22/2018 1,150.87 518 100.05.71.00.5910 5499-564-961/ 3 Invoice HISTORICAL SOCIETY 04/30/2018 05/22/2018 361.06 518 100.05.72.03.5910 5499-564-961/ 4 Invoice HIST SOCIETY POLE LIGHT 04/30/2018 05/22/2018 13.38 518 100.04.51.08.5910 5499-564-961/ 5 Invoice VETERANS PARK ARCH 04/30/2018 05/22/2018 22.02 518 100.04.51.08.5910 5499-564-961/ 6 Invoice VETERANS PARK FOUNTAIN 04/30/2018 05/22/2018 53.46 518 100.04.51.08.5910 5499-564-961/ 7 Invoice PAVILLION 04/30/2018 05/22/2018 43.15 518 100.04.51.08.5910 5499-564-961/ 8 Invoice AREA LIGHTS 04/30/2018 05/22/2018 113.46 518 100.04.51.08.5910 5499-564-961/ 9 Invoice VETERANS PARK LIGHTS 04/30/2018 05/22/2018 59.35 518 100.04.51.08.5910 Total WE ENERGIES:17,558.12 WELDERS SUPPLY COMPANY 10001073 1 Invoice MONTHLY ACETYLENE 04/30/2018 05/22/2018 6.65 518 100.04.51.07.5405 Page 15 of 16 VOUCHER REPORT Packet Page 25 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 15 Report dates: 5/9/2018-5/22/2018 May 17, 2018 03:22PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total WELDERS SUPPLY COMPANY:6.65 WIND LAKE AUTO PARTS 1975/052218 1 Invoice BATTERY BRAKE PADS #29 & #26 04/30/2018 05/22/2018 117.51 518 601.61.61.21.5306 1975/052218 2 Invoice BATTERY BRAKE PADS #29 & #26 04/30/2018 05/22/2018 117.51 518 605.56.09.33.5405 1975/052218 3 Invoice JETTER 04/30/2018 05/22/2018 91.88 518 601.61.61.21.5306 1975/052218 4 Invoice TRKS#17,3,16 FILTERS BALL JOIN 04/30/2018 05/22/2018 1,338.74 518 100.04.51.07.5405 Total WIND LAKE AUTO PARTS:1,665.64 WINDSTREAM 70081706 1 Invoice PRI __PHONES 05/04/2018 05/22/2018 1,111.07 518 100.01.06.00.5601 Total WINDSTREAM:1,111.07 WIS DEPT OF AGRICULTURE 115-000000902 1 Invoice WEIGHTS & MEASURES INSPECTI 04/30/2018 05/22/2018 5,200.00 518 100.02.22.00.5820 Total WIS DEPT OF AGRICULTURE:5,200.00 WISCONSIN DEPT OF TRANSPORTATION 395-00000536 1 Invoice MOORLAND ROAD RECONSTRUC 05/02/2018 05/22/2018 36,055.50 518 401.08.91.19.6503 Total WISCONSIN DEPT OF TRANSPORTATION:36,055.50 ZUERN BUILDING PRODUCTS INC 75248 1 Invoice PARK TABLES 04/13/2018 05/22/2018 128.70 518 100.04.51.11.5415 Total ZUERN BUILDING PRODUCTS INC:128.70 Grand Totals: 1,204,849.57 Report Criteria: Detail report. Invoices with totals above $0 included. Paid and unpaid invoices included. [Report].Description = {<>} "1099 adjustment" Invoice Detail.Type = {>} "adjustments" Page 16 of 16 VOUCHER REPORT Packet Page 26 OVER -> City of Muskego Finance & Administration Department Sharon Mueller Finance & Administration Director Finance & Administration Department Quarterly Report May 22nd, 2018, Finance Committee Meeting Major Projects and Activities being worked on within the Finance & Administration Department: Elections – With the exception of one signage complaint, there were no other incidents to report for either the February 20th or April 3rd elections held. The remaining elections for 2018 include the following:  August 14th Partisan Primary – Governor; U.S. Senator; U.S. Representative; odd-numbered Wisconsin State Senate seats; all Wisconsin Assembly seats  November 6th Fall General – Governor; U.S. Senator; U.S. Representative; odd-numbered Wisconsin State Senate seats; all Wisconsin Assembly seats Due to testing and equipment issues at the State level, the electronic poll book implementation has been delayed. 2017 Tax Roll/Rates/Bills – As approved through the budget process, the City tax rate decreased by $0.46 from $4.87 to $4.41 per $1,000 assessed value mainly due to the assessment revaluation. Staff continues to seek ways to improve upon the collection procedure and additional electronic payment options for tax payment & refund processing. 2017 Audit (Operating, Special Revenue, Capital, BML, Sewer & Water Utility) – Field work began on May 7th and was completed by May 11th. Additional GASB (Governmental Accounting Standards Board) requirements were addressed. The State Financial Report (Form C) was finalized and submitted to the Wisconsin Department of Revenue on May 11th. First draft financial statements have been completed and supplied to the auditors for review. Following will be preparation of the Management Discussion and Analysis (MD&A) for finalization of the City Financial Statement document. The audit review will be presented at a future Finance Committee meeting in July or August. Preliminary results for all City funds have remained positive. It should be noted unrestricted cash & investment balances in the Water Utility have continued on an upward trend; however, the elevated storage tank painting project did have a significant impact to operating expenses since this item was not capitalized per recommended accounting standards. Lastly, as reported at the May 8th Finance Committee meeting, fees for the 2017 audit were negotiated down by approximately $18,000 as a result of in-house reconciliations, analysis, State reporting and financial statement preparation. 2017 Workers Compensation Audit – Audit took place on February 2nd, resulting in a $23,190 credit to the City. 2017 Budget Amendments – As in prior years, due to proper budgetary control being exercised at the General fund level, it appears no amendments will be required which will save the City in publishing costs as well as Committee, Council and staff time. This will be finalized once Baker Tilly has completed their review. Budgets – The tentative 2019 Budget Goals and Timeline will be prepared within the next few weeks and distributed sometime during the months of May/June for review and discussion. Finance and Administrative staff will concurrently begin working with the Mayor and Department Heads in preparation of the proposed Operating, Debt Service, Special Revenues, Water and Sewer Utilities and Big Muskego Lake budgets. Page 1 of 9 Annual 2017 and First Quarter 2018 Packet Page 27 FINANCE & ADMIN. DIRECTOR’S REPORT 05/22/18 PAGE 2 2 Investments/Financial Status – Rates in the Certificate of Deposit Account Registry Service Network (CDARS) and new Expanded FDIC Insurance Account have continued to rise resulting in an annual increase of $65,000+ over the prior year. Debt Issuance – The Refunding for the Debt Issues dated July 26th, 2016 and December 27th, 2017 will be within the ’90-day’ callable period as of June 1st. Staff will begin working with HSE Financial Consultants to prepare for the initial refunding process. It is anticipated the long-term debt principal refunding amount will remain the same as the Note Anticipation Notes (NANs). Additionally, the callable Water Utility Revenue Debt will possibly be converted to General Obligation Debt in order to reduce interest expense and eliminate the need for a separate Utility Reserve Fund. Once determined, the recommendations will be brought before the Finance Committee and Common Council. Payroll/Benefit Administration –  Employee W-2 Wage and Tax Statements were reconciled and distributed on January 5th. Annual State, Federal and Retirement reports were completed well before the due date with no adjustments to report.  Various wellness and fitness programs are under review as agreed upon in the Police Association Agreement.  1st Quarter Federal and State payroll tax reports reconciled and submitted to the IRS and DOR on April 19th.  The City Wellness Program Health Risk Assessment took place the week of May 7th. Final assessment and participation reports will follow.  Health insurance rate renewal information as well as other employee benefit options is under review. Summary updates will be briefly discussed at the May 22nd COW meeting. 4th & 1st Quarter Utility Bills – Billings and collections processed in a timely manner. Due to transition of printing vendors, there were a few issues to report regarding the layout of the invoice. Staff has notified the vendor of the necessary adjustments, which are expected to be resolved by the next quarterly billing. Wisconsin Revolving Loan Fund Semi-Annual Report Certification – Reconciled and submitted to the Department of Commerce on April 6th. Board of Review – Staff is in the process of organizing the BOR meetings for property owners who wish to appeal their assessment/revaluation. The initial meeting to call the BOR into session is scheduled to take place on Monday, June 5th; with adjournment scheduled for July 26th. Meetings include selection of a Vice Chairman, review of policies and establishing dates for future meetings. Open book assessment examination will commence on June 11th and end on June 22. Licensing – Staff has begun the process of preparing and issuing various licenses and permits, including liquor and fireworks. Other Projects – Continued progression with the transition to Agenda/Document Management Workflow. 1st Quarter, 2018 General Fund Operating Results and 2017 Annual Results – See attached and below. The attached worksheets recap the City’s General Fund operating results for the first quarter ending March 31st, 2018. Net revenues over expenditures reflect a minimal change over the prior year, resulting in a slight increase of $3,843. As compared to the budget, revenue results typically include significant variances within each category either because of economic factors or the timing of funds received and will become more proportionate with the budget by the 2nd and 3rd quarters. The expenditures also vary due to seasonal events or the timing of transactions such as with recreational program activity, hydrant rental, vehicle replacements and road program costs. Total expenditures under budget amounted to (-) 78.37% which is an insignificant variance of 1.19% over the prior year. Page 2 of 9 Annual 2017 and First Quarter 2018 Packet Page 28 March 31, 2018 Budget Actual Over/(Under) % Over/(Under)Revenue Comparison Taxes $10,548,898 $10,539,356 -$9,542 -0.09% Intergovernmental $1,937,646 $315,989 -$1,621,657 -83.69% Licenses and Permits $804,995 $182,802 -$622,193 -77.29% Fines, Forfeits and Penalties $310,000 $90,225 -$219,775 -70.90% Public Charges for Services $726,204 $66,726 -$659,478 -90.81% Intergov. Charges for Services $156,000 $1,040 -$154,960 -99.33% Miscellaneous $260,570 $177,589 -$82,981 -31.85% Other Financing Sources $570,000 $0 -$570,000 -100.00% Interdepartmental $233,350 $16,525 -$216,825 -92.92% Total Revenue $15,547,663 $11,390,252 ($4,157,411) -26.74% 2018 Budget Quarter 1 Results: REVENUES General Fund - Annual Operating Results 92% 3%2% 1%1% 0% 1% 0% 0% Taxes Intergovernmental Licenses and Permits Fines, Forfeits and Penalties Public Charges for Services Intergov. Charges for Services Miscellaneous Other Financing Sources Interdepartmental Page 3 of 9 Annual 2017 and First Quarter 2018 Packet Page 29 March 31, 2018 General Government Budget Actual Over/(Under) % Over/(Under)Actual Cost Breakdown Common Council/Mayor $193,437 $52,916 -$140,521 -72.64% Finance & Administration $546,912 $127,621 -$419,291 -76.67% Assessor $119,700 $13,354 -$106,346 -88.84% Attorney $139,798 $29,448 -$110,350 -78.94% Non-Departmental $607,716 $254,843 -$352,873 -58.07% Municipal Court $209,535 $52,992 -$156,543 -74.71% Building Maintenance $194,149 $49,484 -$144,665 -74.51% Information Technology $321,412 $109,373 -$212,039 -65.97% Bank Service Charges $19,000 $3,137 -$15,863 -83.49% Total $2,351,659 $693,168 -$1,658,491 -70.52% Public Safety Budget Actual Over/(Under) % Over/(Under) Police - Sworn Officers $5,078,207 $1,254,720 -$3,823,487 -75.29% Police - Dispatch & Clerical $712,850 $161,094 -$551,756 -77.40% Volunteer Fire $793,838 $0 -$793,838 -100.00% Non-Departmental $19,910 $15,304 -$4,606 -23.13% Building Inspection $299,676 $49,892 -$249,784 -83.35% Total $6,904,481 $1,481,010 -$5,423,471 -78.55% Health & Human Services Budget Actual Over/(Under) % Over/(Under) Animal Warden $3,600 $3,581 -$19 -0.53% Public Safety Supplies & Expenses $100 $38 -$62 -62.18% Total $3,700 $3,619 -$81 -2.19% Public Works Budget Actual Over/(Under) % Over/(Under)Budget vs. Actual Engineering $223,948 $49,380 -$174,569 -77.95% Public Works $2,515,908 $645,631 -$1,870,277 -74.34% Total $2,739,856 $695,011 -$2,044,846 -74.63% Culture, Recreation & Education Budget Actual Over/(Under) % Over/(Under) Parade Fund & Little Lake District $59,000 $10,070 -$48,930 -82.93% Library $1,251,732 $272,789 -$978,943 -78.21% Parks $14,845 $2,674 -$12,171 -81.99% Recreation $546,287 $76,451 -$469,835 -86.01% Total $1,871,864 $361,984 -$1,509,879 -80.66% Conservation & Development Budget Actual Over/(Under) % Over/(Under) Planning, Conservation & Development $402,836 $94,753 -$308,083 -76.48% Total $402,836 $94,753 -$308,083 -76.48% Capital Outlay-Operations Budget Actual Over/(Under) % Over/(Under) Computer Replacements $18,000 $2,334 -$15,666 -87.03% Server/Host Replacements $15,000 $0 -$15,000 -100.00% Social Media Archive $4,000 $0 -$4,000 -100.00% Police Vehicle Replacements $45,000 $28,310 -$16,691 -37.09% Road Program $730,000 $2,566 -$727,434 -99.65% Public Works Vehicle Replacements $187,500 $0 -$187,500 -100.00% Contingency $223,767 $0 -$223,767 -100.00% Trf to Comp Abs from GF $50,000 $0 -$50,000 -100.00% Total $1,273,267 $33,210 -$1,240,057 -97.39% Total Expenditures Budget Actual Over/(Under) % Over/(Under) $15,547,663 $3,362,755 ($12,184,908)-78.37% 2018 Budget Quarter 1 Results: EXPENDITURES General Fund - Annual Operating Results $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 Budget Actual 20% 44%0% 21% 11%3%1% General Government Public Safety Health & Human Services Public Works Culture, Recreation & Education Conservation & Development Capital Outlay-Operations Page 4 of 9 Annual 2017 and First Quarter 2018 Packet Page 30 March 31, 2018 2018 2017 Comparison Revenues vs. Expenditures Total Revenues $11,390,252 $11,002,374 $387,878 Total Expenditures $3,362,755 $2,978,720 $384,035 Total Surplus/(Deficit) $8,027,497 $8,023,654 $3,843 General Fund - Annual Operating Results Quarter 1 Budget Results - 2018 vs. 2017 $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 2018 2017 Page 5 of 9 Annual 2017 and First Quarter 2018 Packet Page 31 CITY OF MUSKEGO FINANCE & ADMINISTRATION DEPARTMENT W182 S8200 Racine Avenue, Muskego, WI 53150 M E M O R A N D U M TO: Finance Committee and Common Council FROM: Sharon Mueller, Director of Finance & Administration DATE: May 22nd, 2018 RE: 2017 Annual Operating Results (Preliminary) ______________________________________________________________________________ The attached worksheets recap the City’s annual operating results for the General Operating Fund. As of December 31st, 2017, revenues exceeded expenditures by $809,635. The following listing is an itemization of accounts contributing to the unanticipated budget surplus: $ – Over/(Under) Budget Revenues = $54,958 Over Budget – $ 187,485 – Licenses & Permits (building, plan & engineer inspections) $(124,599) – Commercial Revenues (interest allocation to other funds) $( 52,121) – Other Financing Sources (Water Utility tax equivalent) $ 44,193 – Intergovernmental (Little Lake dredging project reimburse) Expenditures = $(754,677) Under Budget – $(373,238) – Personnel Expenditures (various resignations/retirements) $(175,136) – Health Insurance (negotiated rate renewal & vacancies) $( 81,265) – Fuel, Gas & Electric (rates remained status quo) $( 23,190) – City Insurance (workers comp. audit) $( 12,994) – Unemployment Compensation (claim reduction) $( 8,854) – Bank Service Charges (new investment fee reduction) $( 80,000) – Contingency (use not required) As noted above, the results in the attached worksheet have undergone a preliminary audit but are subject to change until final reporting. Should you have any questions, please contact me at (262) 679-5622. Thank you. Page 6 of 9 Annual 2017 and First Quarter 2018 Packet Page 32 December 31, 2017 Budget Actual Over/(Under) % Over/(Under)Revenue Comparison Taxes $10,358,898 $10,344,083 -$14,815 -0.14% Intergovernmental $1,797,733 $1,810,711 $12,978 0.72% Licenses and Permits $769,470 $976,844 $207,374 26.95% Fines, Forfeits and Penalties $299,000 $288,463 -$10,537 -3.52% Public Charges for Services $722,755 $710,552 -$12,203 -1.69% Intergov. Charges for Services $149,000 $193,193 $44,193 29.66% Miscellaneous $278,890 $154,291 -$124,599 -44.68% Other Financing Sources $575,000 $538,478 -$36,522 -6.35% Interdepartmental $105,004 $94,093 -$10,911 -10.39% Total Revenue $15,055,750 $15,110,708 $54,958 0.37% 2017 Budget Quarter 4 Results: REVENUES General Fund - Annual Operating Results 68% 12%6% 2%5% 1% 1% 4% 1% Taxes Intergovernmental Licenses and Permits Fines, Forfeits and Penalties Public Charges for Services Intergov. Charges for Services Miscellaneous Other Financing Sources Interdepartmental Page 7 of 9 Annual 2017 and First Quarter 2018 Packet Page 33 December 31, 2017 General Government Budget Actual Over/(Under) % Over/(Under)Actual Cost Breakdown Common Council/Mayor $204,438 $193,233 -$11,205 -5.48% Finance & Administration $578,932 $517,475 -$61,457 -10.62% Assessor $169,625 $166,753 -$2,872 -1.69% Attorney $113,149 $117,689 $4,540 4.01% Non-Departmental $591,660 $571,839 -$19,821 -3.35% Municipal Court $214,379 $192,442 -$21,937 -10.23% Building Maintenance $190,652 $173,293 -$17,359 -9.11% Information Technology $358,737 $246,313 -$112,424 -31.34% Bank Service Charges $19,000 $10,146 -$8,854 -46.60% Total $2,440,572 $2,189,183 -$251,389 -10.30% Public Safety Budget Actual Over/(Under) % Over/(Under) Police - Sworn Officers $4,787,265 $4,573,144 -$214,121 -4.47% Police - Dispatch & Clerical $684,170 $644,435 -$39,735 -5.81% Volunteer Fire $794,313 $795,665 $1,352 0.17% Non-Departmental $20,910 $20,353 -$557 -2.66% Building Inspection $279,867 $361,068 $81,201 29.01% Total $6,566,525 $6,394,665 -$171,860 -2.62% Health & Human Services Budget Actual Over/(Under) % Over/(Under) Animal Warden $3,600 $3,581 -$19 -0.53% Public Safety Supplies & Expenses $50 $153 $103 206.00% Total $3,650 $3,734 $84 2.30% Public Works Budget Actual Over/(Under) % Over/(Under)Budget vs. Actual Engineering $176,564 $190,544 $13,980 7.92% Public Works $2,423,647 $2,338,543 -$85,104 -3.51% Total $2,600,211 $2,529,087 -$71,124 -2.74% Culture, Recreation & Education Budget Actual Over/(Under) % Over/(Under) Parade Fund & Little Lake District $59,000 $84,347 $25,347 42.96% Library $1,206,056 $1,120,240 -$85,816 -7.12% Parks $30,655 $13,129 -$17,526 -57.17% Recreation $564,133 $508,965 -$55,168 -9.78% Total $1,859,844 $1,726,681 -$133,163 -7.16% Conservation & Development Budget Actual Over/(Under) % Over/(Under) Planning, Conservation & Development $422,946 $348,214 -$74,732 -17.67% Total $422,946 $348,214 -$74,732 -17.67% Capital Outlay-Operations Budget Actual Over/(Under) % Over/(Under) Computer Replacements $18,000 $14,835 -$3,165 -17.58% Server/Host Replacements $7,000 $6,962 -$38 -0.54% Social Media Archive $4,000 $3,788 -$212 -5.30% Police Vehicle Replacements $103,000 $111,248 $8,248 8.01% Road Program $725,000 $740,722 $15,722 2.17% Public Works Vehicle Replacements $185,000 $173,684 -$11,316 -6.12% Contingency $80,000 $0 -$80,000 -100.00% Trf to Comp Abs from GF $40,000 $58,270 $18,270 45.68% Total $1,162,000 $1,109,509 -$52,491 -4.52% Total Expenditures Budget Actual Over/(Under) % Over/(Under) $15,055,750 $14,301,073 ($754,677)-5.01% 2017 Budget Quarter 4 Results: EXPENDITURES General Fund - Annual Operating Results $0 $1,000,000 $2,000,000 $3,000,000 $4,000,000 $5,000,000 $6,000,000 $7,000,000 Budget Actual 15% 45%0% 18% 12%2%8% General Government Public Safety Health & Human Services Public Works Culture, Recreation & Education Conservation & Development Capital Outlay-Operations Page 8 of 9 Annual 2017 and First Quarter 2018 Packet Page 34 December 31, 2017 2017 2016 Comparison Revenues vs. Expenditures Total Revenues $15,110,708 $15,051,188 $59,520 Total Expenditures $14,301,073 $14,137,760 $163,313 Total Surplus/(Deficit) $809,635 $913,428 ($103,793) General Fund - Annual Operating Results Quarter 4 Budget Results - 2017 vs. 2016 $13,600,000 $13,800,000 $14,000,000 $14,200,000 $14,400,000 $14,600,000 $14,800,000 $15,000,000 $15,200,000 2017 2016 Page 9 of 9 Annual 2017 and First Quarter 2018 Packet Page 35