FINANCE COMMITTEE Packet - 5/23/2017
CITY OF MUSKEGO
FINANCE COMMITTEE AGENDA
May 23, 2017
6:20 PM
City Hall, W182 S8200 Racine Avenue
CALL TO ORDER
PLEDGE OF ALLEGIANCE
ROLL CALL
PUBLIC MEETING NOTICE
APPROVAL OF MINUTES - May 9, 2017
LICENSE APPROVALS
1. Recommend Approval of Operator Licenses
2. Recommend Approval of Outside Dance Permits for Tres Locos, W172S7505 Lannon
Drive
Friday, June 2, 2017 and August 4, 2017 - 5:00 pm to 11:30 pm
3. Recommend Approval of Outside Dance Permits for AJ's Bar & Grill, S90W13970
Boxhorn Drive
Friday, June 23, 2017, July 28, 2017 and August 18, 2017 - 6:00 pm to 10:00 pm
4. Recommend Approval of Temporary License to Sell Fermented Malt Beverages -
Muskego Storm for the June 2 Jammin' on Janesville, Location S75W17461 Janesville
Road (Pop's Kettle Corn)
VOUCHER APPROVAL
1. Utility Vouchers
2. Tax Vouchers
3. General Fund Vouchers
4. Wire Transfers for Debt Service
5. Wire Transfers for Payroll/Invoice Transmittals
FINANCE DIRECTOR’S REPORT - Annual 2016 and First Quarter 2017
COMMUNICATIONS AND ANY OTHER BUSINESS AS AUTHORIZED BY LAW
ADJOURNMENT
Finance Committee Agenda 2
May 23, 2017
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.
Unapproved
CITY OF MUSKEGO
FINANCE COMMITTEE MINUTES
May 9, 2017
6:55 PM
City Hall, W182 S8200 Racine Avenue
CALL TO ORDER
Mayor Chiaverotti called the meeting to order at 6:56 p.m.
PLEDGE OF ALLEGIANCE
Those present recited the Pledge of Allegiance.
ROLL CALL
Present: Committee Members Aldermen Wolfe, Kapusta and Kubacki. Also present:
Aldermen Hammel, Borgman, Engelhardt and Madden, City Attorney Warchol, Finance and
Administration Director Mueller.
PUBLIC MEETING NOTICE
Director Mueller stated that the meeting was noticed in accordance with the open meeting law.
APPROVAL OF MINUTES – April 25, 2017
Alderman Kubacki moved to approve. Alderman Wolfe seconded; motion carried.
LICENSE APPROVALS
Recommend Approval of Operator Licenses
Alderman Kubacki moved to recommend approval of an Operator's License for Michelle
Barbieri, Gary Schmutzer, David Schulze, Samantha Shannon and Jennifer Smerz.
Alderman Wolfe seconded; motion carried.
Recommend Approval of Temporary License for the Sale of Fermented Malt Beverages and
Wine – Muskego Area Chamber of Commerce (Jammin’ on Janesville – 6/2/2017 and
8/4/2017 – Location S74W16894 Janesville Road)
Alderman Wolfe moved to recommend approval. Alderman Kapusta seconded; motion
carried.
Approval of Taxi Driver License for Muskego Senior Taxi Service – Patricia Niemann and
Paul Ackerman
Alderman Wolfe moved to approve. Alderman Kubacki seconded; motion carried.
NEW BUSINESS
Recommend Approval of CSM on Green Court Subdivider’s Agreement
Alderman Kubacki moved to recommend approval. Alderman Wolfe seconded; motion
carried.
Finance Committee Minutes 2
May 9, 2017
Recommendation Regarding Official City Newspaper (NOW Newspapers/Muskego/New
Berlin)
Alderman Wolfe moved to recommend. Alderman Kapusta seconded; motion carried.
Aldermen Kubacki and Madden noted that the Muskego/New Berlin NOW is not available as
an insert for papers delivered in their districts. Staff will research the issue.
VOUCHER APPROVAL
Utility Vouchers
Alderman Wolfe moved to recommend approval of Utility Vouchers in the amount of
$375,888.09. Alderman Kubacki seconded; motion carried.
Tax Vouchers
Alderman Wolfe moved to recommend approval of Tax Vouchers in the amount of
$1,805.00. Alderman Kapusta seconded; motion carried.
General Fund Vouchers
Alderman Wolfe moved to recommend General Fund Vouchers in the amount of
$352,783.98. Alderman Kubacki seconded; motion carried.
Wire Transfers for Debt Service
Alderman Wolfe moved to recommend approval of Wire Transfers for Debt Service in
the amount of $514,246.01. Alderman Kapusta seconded; motion carried.
Wire Transfers for Payroll/Invoice Transmittals
Alderman Wolfe moved to recommend approval of Wire Transfers for Payroll/Invoice
Transmittals in the amount of $302,133.75. Alderman Kubacki seconded; motion
carried.
ADJOURNMENT
Alderman Kubacki moved to adjourn at 7:00 p.m. Alderman Wolfe seconded; motion
carried.
Minutes transcribed by Jill Blenski, Deputy Clerk.
OPERATOR LICENSE APPROVALS
COMMON COUNCIL – 5/23/2017
Kelly Jo Brock
Matthew Dallmann
Amy Dirmeier
Dennis Flitsch
Tia Garcia
Stephanie Grode
Cheyenne Hernitz
Evagelia Kardaris
Connie Pfaff
Christine Satterstrom
Judith Semrad
Dawn Shier
Kelly Zamitalo
S/CityHall/Licenses/Oper Lic Approval Lists/2017.doc
Council Date MAY 23, 2017
Total Vouchers All Funds $287,977.69
Total Voucher Approval
Utility Vouchers (Approve Separately)
Water Vouchers $29,817.15
Water Wire Transfers
Total Water $29,817.15
Sewer Vouchers 17,726.86
Sewer Wire Transfers
Total Sewer $17,726.86
Net Total Utility Vouchers $ 47,544.01
#1 - Utility Voucher Approval
Tax Vouchers - Refunds & Tax Settlements (Approve Separately)
Tax Vouchers $600.00
Tax Void Checks ()**
Total Tax Vouchers $ 600.00
#2 - Tax Voucher Approval
Total General Fund Vouchers (Approve Separately)
General Fund Vouchers $239,833.68
General Fund Void Checks ()**
Total General Fund Vouchers $ 239,833.68
#3 - General Voucher Approval
Big Muskego Lake Vouchers $
.
Wire transfers (Approve Separately):
Tax Settlements $
Debt Service $688,500.00
Payroll/Invoice Transmittals $321,297.71
#4 - Wire Transfers Approval
Void Checks Since Last Report
Check #Amount Check #Amount
149582 16.63
Total ***
Total 16.63 *Total ***
CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 1
Report dates: 5/10/2017-5/23/2017 May 19, 2017 11:13AM
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
ADVANCED DISPOSAL - MUSKEGO-C6
C6000141519 1 Invoice REFUSE - APRIL 05/15/2017 05/23/2017 44,631.20 517 205.03.30.00.5820
C6000141519 2 Invoice RECYCLING - APRIL 05/15/2017 05/23/2017 23,455.12 517 205.03.00.00.5820
C6000141519 3 Invoice YARD WASTE - APRIL 05/15/2017 05/23/2017 1,393.74 517 205.03.00.00.6056
Total ADVANCED DISPOSAL - MUSKEGO-C6:69,480.06
ALSCO
042510/052317 1 Invoice 4/17 UNIFORM RENTAL 04/30/2017 05/23/2017 270.85 517 100.04.51.07.5704
042510/052317 2 Invoice 4/17 UNIFORM RENTAL 04/30/2017 05/23/2017 70.22 517 601.61.61.12.5702
042510/052317 3 Invoice 4/17 UNIFORM RENTAL 04/30/2017 05/23/2017 70.22 517 605.56.09.21.5835
042511/052317 1 Invoice 4/17 UNIFORM RENTAL 04/30/2017 05/23/2017 45.16 517 605.56.09.21.5835
042511/052317 2 Invoice 4/17 UNIFORM RENTAL 04/30/2017 05/23/2017 45.16 517 601.61.61.12.5702
042511/052317 3 Invoice 4/17 UNIFORM RENTAL 04/30/2017 05/23/2017 117.60 517 100.04.51.07.5704
Total ALSCO:619.21
ARING EQUIPMENT CO., INC
577168 1 Invoice KNIFE, PIN, V BELTS 05/05/2017 05/23/2017 387.23 517 100.04.51.07.5405
Total ARING EQUIPMENT CO., INC:387.23
ASSOCIATED BAG COMPANY
N733157 1 Invoice CAN LINERS/CLEAR BAGS 05/01/2017 05/23/2017 990.00 517 100.04.51.08.5415
Total ASSOCIATED BAG COMPANY:990.00
AT & T
262679410605/1 Invoice Monthly Bill 05/17/2017 05/23/2017 607.60 517 100.01.06.00.5601
Total AT & T:607.60
BAKER & TAYLOR COMPANY
0002965526 1 Invoice BOOK RETURN 05/18/2017 05/23/2017 6.76-517 100.05.71.01.5711
0002967159 1 Invoice BOOK RETURN 05/18/2017 05/23/2017 10.43-517 100.05.71.01.5711
2032836304 1 Invoice PRINT 05/15/2017 05/23/2017 596.66 517 100.05.71.01.5711
2032839852 1 Invoice PRINT 05/15/2017 05/23/2017 1,599.82 517 100.05.71.01.5711
2032853915 1 Invoice PRINT 05/18/2017 05/23/2017 1,362.46 517 100.05.71.01.5711
5014544458 1 Invoice PRINT 05/15/2017 05/23/2017 86.72 517 100.05.71.01.5711
5014553910 1 Invoice PRINT 05/18/2017 05/23/2017 108.39 517 100.05.71.01.5711
Total BAKER & TAYLOR COMPANY:3,736.86
BAKER & TAYLOR ENTERTAINMENT
B49745420 1 Invoice AV 05/15/2017 05/23/2017 14.23 517 100.05.71.02.5711
B49745421 1 Invoice AV 05/15/2017 05/23/2017 68.36 517 100.05.71.02.5711
B49964810 1 Invoice AV 05/15/2017 05/23/2017 96.77 517 100.05.71.02.5711
B50018800 1 Invoice AV 05/15/2017 05/23/2017 114.98 517 100.05.71.02.5711
B50277780 1 Invoice AV 05/18/2017 05/23/2017 25.26 517 100.05.71.02.5711
B50277781 1 Invoice AV 05/18/2017 05/23/2017 9.01 517 100.05.71.02.5711
B50277782 1 Invoice AV 05/18/2017 05/23/2017 141.77 517 100.05.71.02.5711
CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 2
Report dates: 5/10/2017-5/23/2017 May 19, 2017 11:13AM
Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number
B50277783 1 Invoice AV 05/18/2017 05/23/2017 25.19 517 100.05.71.02.5711
B50390830 1 Invoice AV 05/18/2017 05/23/2017 12.73 517 100.05.71.02.5711
T58455870 1 Invoice AV 05/18/2017 05/23/2017 12.73 517 100.05.71.02.5711
Total BAKER & TAYLOR ENTERTAINMENT:521.03
BEILFUSS CORPORATION
1770 1 Invoice Pre-Season Field Prep Park Arthur 05/18/2017 05/23/2017 1,500.00 517 202.08.94.74.6530
1770 2 Invoice Pre-Season Field Prep Bluhm Park 05/18/2017 05/23/2017 1,500.00 517 202.08.94.74.6572
1770 3 Invoice Pre-Season Field Prep Kurth Park 05/18/2017 05/23/2017 375.00 517 202.08.94.74.6575
1770 4 Invoice Pre-Season Field Prep Denoon Park 05/18/2017 05/23/2017 375.00 517 202.08.94.74.6571
1770 5 Invoice Pre-Season Field Prep Horn Park 05/18/2017 05/23/2017 375.00 517 202.08.94.74.6570
Total BEILFUSS CORPORATION:4,125.00
BOYD, DAVID
BO052317-FIN 1 Invoice DEVELOPER DEPOSIT REFUND 05/18/2017 05/23/2017 1,000.00 517 507.00.00.00.2766
Total BOYD, DAVID:1,000.00
CENTURY LINK
1408375375 1 Invoice Monthly Charge Long Distance 05/17/2017 05/23/2017 4.05 517 100.01.06.00.5601
Total CENTURY LINK:4.05
CHAPPELL SPORTS
19760 1 Invoice Softball League Plaques & shirts 05/15/2017 05/23/2017 131.00 517 100.05.72.17.5702
Total CHAPPELL SPORTS:131.00
CIVIC PLUS CORP
164044 1 Invoice City Hall Web Page -annual 05/17/2017 05/23/2017 7,134.45 517 100.01.14.00.5507
164852 1 Invoice Lib. Web Page annual 05/17/2017 05/23/2017 650.00 517 100.05.71.00.5505
Total CIVIC PLUS CORP:7,784.45
CLERK OF CIRCUIT COURT
12446 1 Invoice Bond Jeffrey Dickrell 05/12/2017 05/23/2017 1,000.00 517 100.01.08.00.4272
12452 1 Invoice Kayla Anderson bond 05/12/2017 05/23/2017 1,000.00 517 100.01.08.00.4272
Total CLERK OF CIRCUIT COURT:2,000.00
CONSERV FS INC
110001190 1 Invoice 5W 30 OIL 05/02/2017 05/23/2017 530.85 517 100.04.51.07.5735
110001210 1 Invoice OIL KITS LUBE 05/11/2017 05/23/2017 572.05 517 100.04.51.07.5735
Total CONSERV FS INC:1,102.90
COVELLI, GENE
CO052317-LIB 1 Invoice JAMMIN ON JANESVILLE 05/12/2017 05/23/2017 200.00 517 100.05.71.00.6062
Total COVELLI, GENE:200.00
DIVERSIFIED BENEFIT SERV INC.
241366 1 Invoice HRA FEES - MAY 05/15/2017 05/23/2017 360.42 517 100.01.06.00.5203
Total DIVERSIFIED BENEFIT SERV INC.:360.42
CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 3
Report dates: 5/10/2017-5/23/2017 May 19, 2017 11:13AM
Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number
EAGLE MEDIA, INC.
00123944 1 Invoice magnetic sign for door 05/18/2017 05/23/2017 99.00 517 100.02.20.01.5415
Total EAGLE MEDIA, INC.:99.00
ELLIOTT'S ACE HARDWARE
601005/052317 1 Invoice FASTENERS 05/15/2017 05/23/2017 3.00 517 100.04.51.03.5704
601005/052317 2 Invoice SEWER FILTERS/PARTS 05/15/2017 05/23/2017 52.53 517 601.61.61.12.5702
601005/052317 3 Invoice PICKLEBALL COURT SUPPLIES 05/15/2017 05/23/2017 17.97 517 100.04.51.08.5415
601005/052317 4 Invoice PD MAINT 05/15/2017 05/23/2017 20.17 517 100.02.20.01.5415
601005/052317 5 Invoice LIBRARY MAINT 05/15/2017 05/23/2017 31.46 517 100.05.71.00.5415
Total ELLIOTT'S ACE HARDWARE:125.13
ESCH CONSTRUCTION SUPPLY, INC.
564982 1 Invoice BLADES 04/28/2017 05/23/2017 620.00 517 100.04.51.04.5744
Total ESCH CONSTRUCTION SUPPLY, INC.:620.00
FACTORY MOTOR PARTS CO
13-1367488 1 Invoice RETURN 03/20/2017 05/23/2017 166.36-517 100.04.51.07.5405
13-1375973 1 Invoice MOWER PARTS 05/01/2017 05/23/2017 86.56 517 100.04.51.07.5405
13-1375973 2 Invoice CORE 05/01/2017 05/23/2017 15.00 517 100.04.51.07.5405
13-1376058 1 Invoice CREDIT - CORE 05/01/2017 05/23/2017 15.00-517 100.04.51.07.5405
13-207352 1 Invoice CORE CREDIT & PARTS 03/10/2017 05/23/2017 124.36 517 100.04.51.07.5405
Total FACTORY MOTOR PARTS CO:44.56
FEH DESIGN
108274 1 Invoice CHILDREN'S REDESIGN 05/12/2017 05/23/2017 837.00 517 410.08.90.71.6508
Total FEH DESIGN:837.00
FERGUSON WATERWORKS #2516
0237547 1 Invoice SOFTWARE MAINT NEPTUNE 05/01/2017 05/23/2017 2,046.06 517 605.55.09.03.5702
Total FERGUSON WATERWORKS #2516:2,046.06
FIRST BUSINESS
0018/052317 1 Invoice PEG CONFERENCE CHIEF 04/27/2017 05/23/2017 695.00 517 100.02.20.01.5303
0042/052317 1 Invoice SUPPLIES PARKS 04/27/2017 05/23/2017 49.29 517 100.04.51.08.5415
0042/052317 2 Invoice SUPPLIES PARKS 04/27/2017 05/23/2017 26.31 517 100.04.51.08.5415
0042/052317 3 Invoice BACK FLOW PREVENTER 04/27/2017 05/23/2017 190.96 517 605.54.06.53.5702
0042/052317 4 Invoice WELL - GROUNDS 04/27/2017 05/23/2017 24.79 517 605.54.06.41.5415
0042/052317 5 Invoice UPS - SAMPLES 04/27/2017 05/23/2017 143.75 517 605.56.09.23.5865
0042/052317 6 Invoice MAINT BUILDING/GROUNDS 04/27/2017 05/23/2017 107.98 517 605.54.06.41.5415
0042/052317 7 Invoice AIR COMP WELLS 04/27/2017 05/23/2017 39.98 517 605.51.06.05.5702
0059/052317 1 Invoice LP TANK 04/27/2017 05/23/2017 32.58 517 100.04.51.07.5735
0059/052317 2 Invoice PD - GUN RANGE 04/27/2017 05/23/2017 398.73 517 100.02.20.01.6023
0059/052317 3 Invoice MORTAR MIX 04/27/2017 05/23/2017 227.20 517 100.04.51.02.5742
0059/052317 4 Invoice POST HANDLES 04/27/2017 05/23/2017 270.63 517 100.04.51.07.5704
0059/052317 5 Invoice WOODS ROAD RAILING 04/27/2017 05/23/2017 28.92 517 100.04.51.02.5742
0059/052317 6 Invoice TREATED WOOD MAILBOXES 04/27/2017 05/23/2017 85.92 517 100.04.51.05.5704
0059/052317 7 Invoice PICLEBALL TIES 04/27/2017 05/23/2017 39.99 517 100.04.51.08.5915
0059/052317 8 Invoice PAINT TRUCKS 04/27/2017 05/23/2017 107.48 517 100.04.51.07.5405
0059/052317 9 Invoice PARACORD BLACK NET - PARKS 04/27/2017 05/23/2017 10.94 517 100.04.51.08.5915
0067/052317 1 Invoice FAA STATE BOARD EXAM-DRONE 04/27/2017 05/23/2017 150.00 517 410.08.91.20.6519
0067/052317 2 Invoice AMAZON-DRONE ACCESSORIES 04/27/2017 05/23/2017 83.34 517 410.08.91.20.6519
CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 4
Report dates: 5/10/2017-5/23/2017 May 19, 2017 11:13AM
Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number
0067/052317 3 Invoice AMAZON WEB SERVICES 04/27/2017 05/23/2017 93.99 517 100.01.14.00.5507
0067/052317 4 Invoice GIPAW - CONFERENCE 04/27/2017 05/23/2017 100.00 517 100.01.14.00.5303
0067/052317 5 Invoice CHULA VISTA ROOM - CONFEREN 04/27/2017 05/23/2017 82.00 517 100.01.14.00.5303
0067/052317 6 Invoice GO DADDY - DOMAIN RENEWAL 04/27/2017 05/23/2017 136.22 517 100.01.14.00.5507
0067/052317 7 Invoice CDWG - POWER ADAPTER - LIB L 04/27/2017 05/23/2017 139.83 517 100.05.71.00.5505
0083/052317 1 Invoice TREE STUFF.COM 04/27/2017 05/23/2017 485.91 517 215.06.00.00.6009
0083/052317 2 Invoice FORESTRY SUPPLIERS 04/27/2017 05/23/2017 119.95 517 215.06.00.00.6008
0083/052317 3 Invoice FORESTRY SUPPLIERS 04/27/2017 05/23/2017 88.45 517 100.04.19.00.5715
0286/052317 1 Invoice LEXIS NEXIS SUBSCRIPTION 04/27/2017 05/23/2017 273.00 517 100.01.05.00.5506
0463/052317 1 Invoice ACCESSLINE - TOLL FREE NUMB 04/27/2017 05/23/2017 14.73 517 100.06.18.01.5704
0463/052317 2 Invoice BUILDING SEALS 04/27/2017 05/23/2017 1,654.99 517 100.02.25.00.5751
1002/052317 1 Invoice HEADLIGHT BULBS/ENVELOPES 04/27/2017 05/23/2017 109.40 517 100.02.20.01.5405
1002/052317 2 Invoice MAIL TOUGH HOOK BACK 04/27/2017 05/23/2017 13.73 517 100.02.20.01.5722
1002/052317 3 Invoice ERAD STRIP READER 04/27/2017 05/23/2017 19.99 517 100.02.20.01.5722
3863/052317 1 Invoice FOL - PR 04/27/2017 05/23/2017 146.95 517 100.05.71.00.5752
3871/052317 1 Invoice PROGRAMMING 04/27/2017 05/23/2017 42.63 517 100.05.71.00.6062
3871/052317 2 Invoice FOL - PR 04/27/2017 05/23/2017 88.66 517 100.05.71.00.5752
3871/052317 3 Invoice WLA MEMBERSHIP - LIBRARIAN 04/27/2017 05/23/2017 129.00 517 100.05.71.00.5305
3889/052317 1 Invoice AV 04/27/2017 05/23/2017 272.80 517 100.05.71.02.5711
3889/052317 2 Invoice PRINT 04/27/2017 05/23/2017 395.88 517 100.05.71.01.5711
3897/052317 1 Invoice PRINT 04/27/2017 05/23/2017 66.55 517 100.05.71.01.5711
3897/052317 2 Invoice PROGRAMMING 04/27/2017 05/23/2017 391.78 517 100.05.71.00.6062
3905/052317 1 Invoice FOL - PR 04/27/2017 05/23/2017 457.89 517 100.05.71.00.5752
3905/052317 2 Invoice ELECTRONIC MATERIALS 04/27/2017 05/23/2017 570.55 517 100.05.71.03.5711
3905/052317 3 Invoice PROGRAMMING 04/27/2017 05/23/2017 29.86 517 100.05.71.00.6062
3913/052317 1 Invoice WLA MEMBERSHIP LIBRARIAN 04/27/2017 05/23/2017 120.00 517 100.05.71.00.5305
3913/052317 2 Invoice WLA MEMBERSHIP FREF ASSIST 04/27/2017 05/23/2017 111.00 517 100.05.71.00.5305
3913/052317 3 Invoice AV 04/27/2017 05/23/2017 755.25 517 100.05.71.02.5711
3913/052317 4 Invoice PROGRAMMING 04/27/2017 05/23/2017 28.21 517 100.05.71.00.6062
3913/052317 5 Invoice FOL - PR 04/27/2017 05/23/2017 16.85 517 100.05.71.00.5752
3921/052317 1 Invoice RED CROSS BABYSITTING BOOK 04/27/2017 05/23/2017 1,278.71 517 100.05.72.14.5730
3921/052317 2 Invoice RED CROSS BABYSITTING CERTI 04/27/2017 05/23/2017 70.00 517 100.05.72.14.5730
3921/052317 3 Invoice PICKLEBALL CENTRAL - PICKLEB 04/27/2017 05/23/2017 119.96 517 100.05.72.13.5702
3921/052317 4 Invoice WDNR - CERTIFICATIONS BOATE 04/27/2017 05/23/2017 120.00 517 100.05.72.14.5110
3921/052317 5 Invoice PIGGLY WIGGLY - SCHOOLS OUT 04/27/2017 05/23/2017 158.98 517 100.05.72.16.5702
3939/052317 1 Invoice LIBRARY MAINT 05/09/2017 05/23/2017 72.74 517 100.05.71.00.5415
3939/052317 2 Invoice ELECTIONS 05/09/2017 05/23/2017 147.88 517 100.01.03.00.5704
3939/052317 3 Invoice CITY HALL MAINT 05/09/2017 05/23/2017 197.95 517 100.01.09.00.5415
3939/052317 4 Invoice VENDING SUPPLIES 05/09/2017 05/23/2017 139.01 517 100.01.06.00.5702
6904/052317 1 Invoice SIG SAUER TRAINING PETZ/SUND 04/27/2017 05/23/2017 500.00 517 100.02.20.01.5301
7106/052317 1 Invoice EMD RECERT LT ANDRICKA 04/27/2017 05/23/2017 100.00 517 100.02.20.01.5301
9960/052317 1 Invoice BOR MATERIALS 04/27/2017 05/23/2017 45.00 517 100.01.04.00.5802
9960/052317 2 Invoice MUNI OFFICIALS HANDBOOKS 04/27/2017 05/23/2017 225.00 517 100.01.01.00.5701
9994/052317 1 Invoice SHERIDAN HOMICIDE INV SCHOO 04/27/2017 05/23/2017 164.00 517 100.02.20.01.5301
Total FIRST BUSINESS:13,009.07
FIRST SCRIBE
2472602 1 Invoice ROWAY WEB APPS 05/19/2017 05/23/2017 85.00 517 100.04.19.00.5815
Total FIRST SCRIBE:85.00
FONS, NICHOLAS
FO052317-PD 1 Invoice Fons training material reimburse 05/18/2017 05/23/2017 6.33 517 100.02.20.01.5722
Total FONS, NICHOLAS:6.33
CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 5
Report dates: 5/10/2017-5/23/2017 May 19, 2017 11:13AM
Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number
FRANKLIN AGGREGATES, INC.
1479842 1 Invoice 7.34 TB 05/04/2017 05/23/2017 67.53 517 100.04.51.02.5741
Total FRANKLIN AGGREGATES, INC.:67.53
GLEASON REDI MIX
248069 1 Invoice FORMS 05/03/2017 05/23/2017 159.25 517 100.04.51.04.5744
248217 1 Invoice FORMS 05/05/2017 05/23/2017 136.50 517 100.04.51.04.5744
Total GLEASON REDI MIX:295.75
GOVERNMENT FINANCE OFFICERS ASSOCIATION
0146376/05231 1 Invoice MEMBERSHIP RENEWAL - SHARO 05/18/2017 05/23/2017 225.00 517 100.01.03.00.5305
Total GOVERNMENT FINANCE OFFICERS ASSOCIATION:225.00
HALQUIST STONE CO., INC.
414254 1 Invoice ROCK 05/08/2017 05/23/2017 1,065.05 517 100.04.51.04.5744
414340 1 Invoice ROCK 30.99 TON 05/09/2017 05/23/2017 526.83 517 100.04.51.04.5744
Total HALQUIST STONE CO., INC.:1,591.88
HD SUPPLY FACILITIES
9153834006 1 Invoice PARKING PERMIT STICKERS 05/18/2017 05/23/2017 545.00 517 100.01.03.00.5713
Total HD SUPPLY FACILITIES:545.00
HEARTLAND BUSINESS SYSTEMS
227939-H 1 Invoice 911 Firewall Update 05/12/2017 05/23/2017 948.75 517 100.02.20.01.5504
227940-H 1 Invoice 911 Config/update 05/12/2017 05/23/2017 172.50 517 100.02.20.01.5504
227941-H 1 Invoice Monthly Onsite Visit 05/12/2017 05/23/2017 977.50 517 100.01.14.00.5840
228567-H 1 Invoice 911-Consulant- update 05/17/2017 05/23/2017 460.00 517 100.02.20.01.5504
HBS00544501 1 Invoice New Server-1st year charges 05/12/2017 05/23/2017 900.45 517 100.07.01.06.6503
Total HEARTLAND BUSINESS SYSTEMS:3,459.20
HOLZ MOTORS, INC
71605 1 Invoice 2017 SILVERADO 05/10/2017 05/23/2017 13,018.69 517 605.00.00.00.1962
71605 2 Invoice 2017 SILVERADO 05/10/2017 05/23/2017 13,018.69 517 601.00.00.00.1922
Total HOLZ MOTORS, INC:26,037.38
HUMPHREY SERVICE PARTS
1130505 1 Invoice PERMATEX 01/01/2017 05/23/2017 49.95 517 100.04.51.07.5405
1143942 1 Invoice #15 HUB CAP 05/04/2017 05/23/2017 17.90 517 100.04.51.07.5405
1144040 1 Invoice DENOON BACKSTOP NET 05/05/2017 05/23/2017 235.41 517 100.04.51.08.5415
1144763 1 Invoice VACUUP PUMP SCALE SPOT GUN 05/15/2017 05/23/2017 1,000.17 517 100.04.51.07.5405
1144763 2 Invoice VACUUP PUMP SCALE SPOT GUN 05/15/2017 05/23/2017 1,000.17 517 601.61.61.12.5702
Total HUMPHREY SERVICE PARTS:2,303.60
JAMES IMAGING SYSTEMS INC
745004 1 Invoice CONTRACT BASE 4/18-5/17/17 05/15/2017 05/23/2017 396.73 517 100.01.06.00.5410
745004 2 Invoice OVERAGE CHARGE 3/18-4/17/17 05/15/2017 05/23/2017 122.20 517 100.01.06.00.5701
Total JAMES IMAGING SYSTEMS INC:518.93
CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 6
Report dates: 5/10/2017-5/23/2017 May 19, 2017 11:13AM
Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number
JANI-KING INC- MILW REGION
MIL05170592 1 Invoice Cleaning of Park Restrooms -May 05/12/2017 05/23/2017 1,326.00 517 100.04.51.01.5820
Total JANI-KING INC- MILW REGION:1,326.00
JOHN PAUL'S
386917 1 Invoice SQD 2 05/09/2017 05/23/2017 44.99 517 100.02.20.01.5405
Total JOHN PAUL'S:44.99
JOHNSON, BONNIE
13144/052317 1 Invoice Class Cancellation Refund- Cake De 05/15/2017 05/23/2017 40.00 517 100.05.72.18.4318
Total JOHNSON, BONNIE:40.00
KARFONTA, AMY
KA052317-PD 1 Invoice Karfonta pants 05/18/2017 05/23/2017 22.06 517 100.02.20.10.5151
Total KARFONTA, AMY:22.06
KUTZ, DANIEL & AMY
2199103/05231 1 Invoice TAX REFUND/86 05/15/2017 05/23/2017 600.00 517 501.00.00.00.2120
Total KUTZ, DANIEL & AMY:600.00
LA CROSSE CO SHERIFF'S OFFICE
LA052317-PD 1 Invoice Sheridan Hostage Negotiations 05/18/2017 05/23/2017 25.00 517 100.02.20.01.5301
Total LA CROSSE CO SHERIFF'S OFFICE:25.00
LAKEPOINT CHURCH
LA052317-RE 1 Invoice Security Deposit LakePoint Circle Re 05/12/2017 05/23/2017 50.00 517 100.05.72.16.5820
Total LAKEPOINT CHURCH:50.00
LANGE ENTERPRISES
61693 1 Invoice ADDRESS TILES 05/11/2017 05/23/2017 391.14 517 100.02.25.00.5752
Total LANGE ENTERPRISES:391.14
LEGACY RECYCLING
1044 1 Invoice EMERALD PARK LANDFILL 05/12/2017 05/23/2017 2,032.45 517 205.03.00.00.5820
1073 1 Invoice EMERALD PARK LANDFILL RECY 05/18/2017 05/23/2017 1,993.01 517 205.03.00.00.5820
Total LEGACY RECYCLING:4,025.46
LEMKE, KATIE
LE052317-RE 1 Invoice Class Cancellation Refund 05/12/2017 05/23/2017 20.00 517 100.05.72.18.4318
Total LEMKE, KATIE:20.00
LYNCH TRUCK CENTER
K4258796/052 1 Invoice 2017 CHEVY DUMP #50 05/10/2017 05/23/2017 47,871.00 517 410.08.93.51.6507
Total LYNCH TRUCK CENTER:47,871.00
MEACHAM NURSERY
IV17-7039 1 Invoice Trees 05/19/2017 05/23/2017 3,433.00 517 215.06.00.00.6008
CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 7
Report dates: 5/10/2017-5/23/2017 May 19, 2017 11:13AM
Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number
Total MEACHAM NURSERY:3,433.00
MICROMARKETING LLC
666417 1 Invoice AV 05/12/2017 05/23/2017 95.94 517 100.05.71.02.5711
669853 1 Invoice AV 05/15/2017 05/23/2017 30.00 517 100.05.71.02.5711
669972 1 Invoice AV 05/15/2017 05/23/2017 79.98 517 100.05.71.02.5711
670455 1 Invoice AV 05/15/2017 05/23/2017 34.95 517 100.05.71.02.5711
670703 1 Invoice AV 05/18/2017 05/23/2017 34.99 517 100.05.71.02.5711
670778 1 Invoice AV 05/18/2017 05/23/2017 69.99 517 100.05.71.02.5711
Total MICROMARKETING LLC:345.85
MIDWEST TAPE
95020420 1 Invoice AV 05/15/2017 05/23/2017 65.07 517 100.05.71.02.5711
95042381 1 Invoice AV 05/18/2017 05/23/2017 165.82 517 100.05.71.02.5711
Total MIDWEST TAPE:230.89
MISS BECKY LLC
492 1 Invoice Class Instruction -Pom/Dance 05/12/2017 05/23/2017 37.50 517 100.05.72.13.5110
Total MISS BECKY LLC:37.50
MUNICIPAL PROPERTY INSURANCE CO
30887 1 Invoice POLICY ENDORSEMENT 2017 05/15/2017 05/23/2017 46.00 517 100.01.06.00.6103
Total MUNICIPAL PROPERTY INSURANCE CO:46.00
NAVIANT
0131592-IN 1 Invoice Onbase Conversion 05/17/2017 05/23/2017 5,075.00 517 209.01.00.00.6050
Total NAVIANT:5,075.00
NEENAH FOUNDRY CO
212093 1 Invoice LD - 12 03/30/2017 05/23/2017 1,812.00 517 100.04.51.04.5744
Total NEENAH FOUNDRY CO:1,812.00
NOWICKI, ERIC
NO052317-PD 1 Invoice Inservice meals 05/18/2017 05/23/2017 30.00 517 100.02.20.01.5301
Total NOWICKI, ERIC:30.00
O'BRIEN, TERESA
2017-0015 1 Invoice Class Instruction-Art & Drawing 05/18/2017 05/23/2017 290.00 517 100.05.72.12.5110
Total O'BRIEN, TERESA:290.00
OCCUPATIONAL HEALTH CENTERS
102652558 1 Invoice TESTING - MAYER 05/03/2017 05/23/2017 21.00 517 601.61.63.42.6056
102652558 2 Invoice TESTING - MAYER 05/03/2017 05/23/2017 21.00 517 605.56.09.30.5305
102652558 3 Invoice TESTING - GELLINGS 05/03/2017 05/23/2017 21.00 517 601.61.63.42.6056
102652558 4 Invoice TESTING - GELLINGS 05/03/2017 05/23/2017 21.00 517 605.56.09.30.5305
102652558 5 Invoice TESTING - DELIKAT 05/03/2017 05/23/2017 78.50 517 100.04.51.01.5227
Total OCCUPATIONAL HEALTH CENTERS:162.50
CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 8
Report dates: 5/10/2017-5/23/2017 May 19, 2017 11:13AM
Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number
OLSEN SAFETY EQUIPMENT CORP.
0342815 1 Invoice GLOVES 05/10/2017 05/23/2017 264.24 517 100.04.51.01.5225
Total OLSEN SAFETY EQUIPMENT CORP.:264.24
PARTSMASTER
23141383 1 Invoice CAP SCREW 04/25/2017 05/23/2017 29.83 517 100.04.51.07.5704
Total PARTSMASTER:29.83
PINKY ELECTRIC INC.
1962 1 Invoice LAKE DR 05/11/2017 05/23/2017 90.00 517 601.61.61.15.5415
1974 1 Invoice MOTION DETECTOR BATHROOM I 05/16/2017 05/23/2017 230.00 517 100.04.51.08.5415
1975 1 Invoice LAMP DPW 05/16/2017 05/23/2017 92.00 517 100.04.51.08.5415
Total PINKY ELECTRIC INC.:412.00
PIRANHA PAPER SHREDDING LLC
10122050417 1 Invoice PAPER SHREDDING 05/15/2017 05/23/2017 12.50 517 100.01.06.00.5701
1492050417 1 Invoice Monthly shred 05/18/2017 05/23/2017 30.00 517 100.02.20.01.5723
Total PIRANHA PAPER SHREDDING LLC:42.50
PORT-A-JOHN
0424546-IN 1 Invoice AGATE DR RESTROOMS 05/19/2017 05/23/2017 85.00 517 100.04.51.01.5820
0424547-IN 1 Invoice CROWBAR RD RESTROOMS 05/19/2017 05/23/2017 255.00 517 100.04.51.01.5820
0424548-IN 1 Invoice PARKLAND DR RESTROOMS 05/19/2017 05/23/2017 85.00 517 100.04.51.01.5820
0424549-IN 1 Invoice MOORELAND RD RESTROOMS 05/19/2017 05/23/2017 85.00 517 100.04.51.01.5820
1270441-IN 1 Invoice RESTROOM AT BADERTSCHER 05/11/2017 05/23/2017 75.00 517 215.06.00.00.5801
1270555-IN 1 Invoice Hardtke Drive Restrooms 05/17/2017 05/23/2017 75.00 517 100.04.51.01.5820
1270556-IN 1 Invoice DURHAM DR RESTROOM 05/17/2017 05/23/2017 75.00 517 100.04.51.01.5820
1270557-IN 1 Invoice BOXHORN LAUNCH RESTROOM 05/17/2017 05/23/2017 75.00 517 100.04.51.01.5820
Total PORT-A-JOHN:810.00
PROFORMA
90N8401385 1 Invoice CLOTHING ALLOWANCE 05/18/2017 05/23/2017 1,594.60 517 100.05.71.00.5701
90N8401386 1 Invoice CLOTHING ALLOWANCE FINANCE 05/18/2017 05/23/2017 888.42 517 100.01.03.00.5704
90N8401386 2 Invoice CLOTHING ALLOWANCE PLANNIN 05/18/2017 05/23/2017 223.38 517 100.06.18.01.5704
90N8401386 3 Invoice CLOTHING ALLOWANCE IT 05/18/2017 05/23/2017 313.80 517 100.01.14.00.5701
90N8401386 4 Invoice CLOTHING ALLOWANCE COURT 05/18/2017 05/23/2017 91.96 517 100.01.08.00.5702
90N8401386 5 Invoice CLOTHING ALLOWANCE RECREA 05/18/2017 05/23/2017 204.86 517 100.05.72.10.5701
90N8401386 6 Invoice CLOTHING ALLOWANCE LAW 05/18/2017 05/23/2017 99.96 517 100.01.05.00.5701
90N8401386 7 Invoice CLOTHING ALLOWANCE CONSER 05/18/2017 05/23/2017 95.96 517 215.06.00.00.5704
90N8401386 8 Invoice CLOTHING ALLOWANCE FREIGHT 05/18/2017 05/23/2017 145.07 517 100.01.06.00.5704
Total PROFORMA:3,658.01
PROHEALTH CARE
201704-0 1 Invoice blood draw 05/18/2017 05/23/2017 35.00 517 100.02.20.01.5722
Total PROHEALTH CARE:35.00
PROVEN POWER INC
02-220248 1 Invoice GASKETS OIL CAP SEAL 05/02/2017 05/23/2017 34.80 517 100.04.51.07.5405
02-221451 1 Invoice LINE 05/10/2017 05/23/2017 36.90 517 601.61.61.12.5702
CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 9
Report dates: 5/10/2017-5/23/2017 May 19, 2017 11:13AM
Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number
Total PROVEN POWER INC:71.70
QUILL CORP
12937 1 Invoice Office Supplies-card stock, pens 05/17/2017 05/23/2017 96.88 517 100.05.72.10.5701
Total QUILL CORP:96.88
RED THE UNIFORM TAILOR
0B204794 1 Invoice Patterson shirt 05/18/2017 05/23/2017 44.99 517 100.02.20.01.5151
Total RED THE UNIFORM TAILOR:44.99
RICOH USA, INC
5048325254 1 Invoice ASSESSOR'S COPIER 05/15/2017 05/23/2017 6.83 517 100.01.04.00.5701
Total RICOH USA, INC:6.83
RUEKERT & MIELKE INC
118812 1 Invoice IND PARK ELEVATED TANK PAINT 05/15/2017 05/23/2017 4,663.97 517 605.00.00.00.1941
118813 1 Invoice HILLENDALE DR LPS ANALYSIS 05/15/2017 05/23/2017 185.05 517 507.00.00.00.2750
118814 1 Invoice SCADA SERVICE WORK 05/15/2017 05/23/2017 515.64 517 601.61.63.42.5430
118814 2 Invoice SCADA SERVICE WORK 05/15/2017 05/23/2017 515.64 517 605.56.09.23.5620
118815 1 Invoice SCADA SERVICE WORK 05/15/2017 05/23/2017 1,369.82 517 605.56.09.23.5620
118816 1 Invoice MMSD FACILITIES PLAN REVIEW 05/15/2017 05/23/2017 1,145.00 517 601.61.63.43.5815
Total RUEKERT & MIELKE INC:8,395.12
RUNDLE-SPENCE
S2569423.001 1 Invoice BLUHM PARK BATHROOM 05/08/2017 05/23/2017 27.74 517 100.04.51.08.5415
Total RUNDLE-SPENCE :27.74
SECURIAN FINANCIAL GROUP, INC.
002832L/05231 1 Invoice LIFE INSURANCE PREMIUMS-JUN 05/15/2017 05/23/2017 2,590.33 517 100.00.00.00.2207
Total SECURIAN FINANCIAL GROUP, INC.:2,590.33
SHRM (SOCIETY HUMAN RESOURCE)
9007081572 1 Invoice RENEWAL FEE - SHARON 05/18/2017 05/23/2017 199.00 517 100.01.03.00.5305
Total SHRM (SOCIETY HUMAN RESOURCE):199.00
SOMAR TEK LLC/ ENTERPRISES
100387 1 Invoice Petz tac light and gloves 05/18/2017 05/23/2017 189.19 517 100.02.20.01.5151
Total SOMAR TEK LLC/ ENTERPRISES:189.19
SPOK
A0282335Q 1 Invoice MAY PAGERS 05/01/2017 05/23/2017 8.13 517 601.61.63.42.5701
A0282335Q 2 Invoice MAY PAGERS 05/01/2017 05/23/2017 8.13 517 605.56.09.21.5607
Total SPOK:16.26
STREICHER'S
I1260475 1 Invoice Patterson pants 05/18/2017 05/23/2017 79.99 517 100.02.20.01.5151
CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 10
Report dates: 5/10/2017-5/23/2017 May 19, 2017 11:13AM
Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number
Total STREICHER'S:79.99
TAPCO INC.
I562937 1 Invoice BRACKETS 05/05/2017 05/23/2017 408.26 517 100.04.51.03.5743
Total TAPCO INC.:408.26
THE DISC GOLF EXPERIENCE LLC
13 1 Invoice Denoon Park-Disc Golf Design partia 05/18/2017 05/23/2017 1,000.00 517 202.08.94.74.6571
Total THE DISC GOLF EXPERIENCE LLC:1,000.00
TIME WARNER CABLE
701507601/052 1 Invoice Monthly Charge 05/12/2017 05/23/2017 1,045.00 517 100.01.14.00.5507
Total TIME WARNER CABLE:1,045.00
TRI-STATE EQUP. CO. INC
126793 1 Invoice METRIC HOSE 05/09/2017 05/23/2017 287.69 517 100.04.51.07.5405
Total TRI-STATE EQUP. CO. INC:287.69
TYLER TECHNOLOGIES, INC
060-7348 1 Invoice ASSESSMENT SERVICES 05/18/2017 05/23/2017 4,890.00 517 100.01.04.00.5801
060-7349 1 Invoice ASSESSMET REVAL 05/18/2017 05/23/2017 710.00 517 100.01.04.00.5830
Total TYLER TECHNOLOGIES, INC:5,600.00
USA FIRE PROTECTION
255482 1 Invoice PARKS HEADQUARTERS 05/18/2017 05/23/2017 290.20 517 100.04.51.08.5415
255482 2 Invoice WELL SITES, L/S, PARKS FAC, ST 05/18/2017 05/23/2017 366.56 517 601.61.61.15.5415
255482 3 Invoice WELL SITES, L/S, PARKS FAC, ST 05/18/2017 05/23/2017 366.56 517 605.54.06.41.5702
255482 4 Invoice MUNICIPAL GARAGE 05/18/2017 05/23/2017 931.68 517 100.04.51.08.5415
255482 5 Invoice LIBRARY 05/18/2017 05/23/2017 183.28 517 100.05.71.00.5415
255482 6 Invoice POLICE 05/18/2017 05/23/2017 442.93 517 100.02.20.01.5415
255482 7 Invoice CITY HALL 05/18/2017 05/23/2017 213.83 517 100.01.09.00.5415
255482 8 Invoice HISTORICAL SOCIETY 05/18/2017 05/23/2017 198.56 517 100.05.72.03.5702
255482 9 Invoice POLICE RANGE 05/18/2017 05/23/2017 61.10 517 100.02.20.01.6023
255530 1 Invoice SPRINKLER INSPECTION 05/18/2017 05/23/2017 180.00 517 100.05.71.00.5415
255531 1 Invoice MAY 2017 SPRINKLER INSPECTIO 05/15/2017 05/23/2017 180.00 517 100.05.71.00.5415
255532 1 Invoice sprinkler inspection 05/18/2017 05/23/2017 180.00 517 100.02.20.01.5415
Total USA FIRE PROTECTION:3,594.70
WAUKESHA COUNTY TECH COLLEGE
S0640101 1 Invoice In Services 05/18/2017 05/23/2017 530.95 517 100.02.20.01.5301
Total WAUKESHA COUNTY TECH COLLEGE:530.95
WAUKESHA COUNTY TREASURER
2017-0000003 1 Invoice BALLOTS AND NOTICE 05/18/2017 05/23/2017 117.06 517 100.01.03.00.5704
2017-0000007 1 Invoice Inmate billing 05/18/2017 05/23/2017 1,527.20 517 100.01.08.00.6017
Total WAUKESHA COUNTY TREASURER:1,644.26
WE ENERGIES
0000-020-351/1 Invoice MAR 17 WELLS - ELECTRIC 04/28/2017 05/23/2017 6,872.50 517 605.52.06.22.5910
CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 11
Report dates: 5/10/2017-5/23/2017 May 19, 2017 11:13AM
Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number
0000-020-351/2 Invoice MAR 17 WELLS - GAS 04/28/2017 05/23/2017 180.53 517 605.52.06.22.5910
3665-286-012/1 Invoice STREET LIGHTING 05/15/2017 05/23/2017 2,112.89 517 100.04.51.06.5910
3836-104-158/1 Invoice GROUP L/S 05/02/2017 05/23/2017 1,225.43 517 601.61.61.20.5910
5499-564-961/1 Invoice LIBRARY - GAS 05/15/2017 05/23/2017 1,247.65 517 100.05.71.00.5910
5499-564-961/2 Invoice LIBRARY - ELECTRIC 05/15/2017 05/23/2017 4,167.12 517 100.05.71.00.5910
5499-564-961/3 Invoice HISTORICAL SOCIETY 05/15/2017 05/23/2017 237.07 517 100.05.72.03.5910
5499-564-961/4 Invoice HISTORICAL SOCIETY POLE LIGH 05/15/2017 05/23/2017 13.42 517 100.04.51.08.5910
5499-564-961/5 Invoice VETERANS PARK ARCH 05/15/2017 05/23/2017 25.41 517 100.04.51.08.5910
5499-564-961/6 Invoice VETERANS PARK FOUNTAIN 05/15/2017 05/23/2017 52.44 517 100.04.51.08.5910
5499-564-961/7 Invoice PAVILION 05/15/2017 05/23/2017 81.08 517 100.04.51.08.5910
5499-564-961/8 Invoice AREA LIGHTS 05/15/2017 05/23/2017 113.70 517 100.04.51.08.5910
5499-564-961/9 Invoice VETERANS PARK LIGHTS 05/15/2017 05/23/2017 59.30 517 100.04.51.08.5910
7232-065-152/1 Invoice GARAGE 50%05/18/2017 05/23/2017 26.47 517 100.04.51.08.5910
7232-065-152/2 Invoice SEWER 25%05/18/2017 05/23/2017 13.24 517 601.61.61.20.5910
7232-065-152/3 Invoice WATER 25%05/18/2017 05/23/2017 13.23 517 605.56.09.21.5910
WE052317-RE 1 Invoice Light Pole & Electrical Work at Idle Is 05/18/2017 05/23/2017 946.96 517 202.08.94.74.6579
Total WE ENERGIES:17,388.44
WERNER, ANDREW
WE022317 1 Invoice LICENSE/EXAM 05/10/2017 05/23/2017 225.26 517 100.04.51.01.5228
Total WERNER, ANDREW:225.26
WESTERN CULVERT & SUPPLY INC
052687 1 Invoice GUARDRAIL/POSTS 04/28/2017 05/23/2017 517.12 517 100.04.51.02.5742
Total WESTERN CULVERT & SUPPLY INC:517.12
WIND LAKE AUTO PARTS
1975/052317 1 Invoice #4 SQ ROTOR & PADS 04/29/2017 05/23/2017 159.38 517 100.02.20.01.5405
1975/052317 2 Invoice #30 + #20 FUEL CAP & BATTERIES 04/29/2017 05/23/2017 97.19 517 601.61.61.21.5306
1975/052317 3 Invoice #30 + #20 FUEL CAP & BATTERIES 04/29/2017 05/23/2017 97.18 517 605.56.09.33.5405
1975/052317 4 Invoice FILTERS #11,#4 CHIPPER CABLES 04/29/2017 05/23/2017 700.41 517 100.04.51.07.5405
Total WIND LAKE AUTO PARTS:1,054.16
WIND LAKE AUTOMOTIVE INC
29631 1 Invoice 2015 TAHOE 05/11/2017 05/23/2017 60.00 517 100.02.20.01.5405
Total WIND LAKE AUTOMOTIVE INC:60.00
WINDSTREAM
69022197 1 Invoice Monthly Charges 05/17/2017 05/23/2017 1,069.21 517 100.01.06.00.5601
Total WINDSTREAM:1,069.21
WIS STEAM CLEANER SALES CO INC
45882 1 Invoice SUPPLIES 05/08/2017 05/23/2017 984.39 517 100.04.51.07.5405
Total WIS STEAM CLEANER SALES CO INC:984.39
WISCONSIN BUILDING INSPECTION, LLP
151/052317 1 Invoice APRIL PERMITS/INSPECTIONS 05/17/2017 05/23/2017 24,415.02 517 100.02.25.00.5820
Total WISCONSIN BUILDING INSPECTION, LLP:24,415.02
CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 12
Report dates: 5/10/2017-5/23/2017 May 19, 2017 11:13AM
Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number
WISCONSIN DEPT OF JUSTICE - CIB
L6806T-2 1 Invoice RECORD NAME SEARCHES 05/15/2017 05/23/2017 259.00 517 100.01.06.00.6002
Total WISCONSIN DEPT OF JUSTICE - CIB:259.00
ZEPHYR BELLYDANCE
4.15.2017 1 Invoice Class Instruction- Belly Dance 05/18/2017 05/23/2017 80.00 517 100.05.72.13.5110
Total ZEPHYR BELLYDANCE:80.00
Grand Totals: 287,977.69
Report Criteria:
Detail report.
Invoices with totals above $0 included.
Paid and unpaid invoices included.
[Report].Description = {<>} "1099 adjustment"
Invoice Detail.Type = {>} "adjustments"
OVER ->
City of Muskego
Finance & Administration Department
Sharon Mueller
Finance & Administration Director
Finance & Administration Department Quarterly Report
May 23rd, 2017, Finance Committee Meeting
Major Projects and Activities being worked on within the Finance & Administration Department:
Elections – There were no incidents to report for either the February 21st or April 4th elections held.
2016 Tax Roll/Rates/Bills – As approved through the budget process, the City tax rate decreased by $0.02 from
$4.89 to $4.87 per $1,000 assessed value. Staff continues to seek ways to improve upon the collection procedure and
additional electronic payment options for tax payment & refund processing.
2016 Audit (Operating, Special Revenue, Capital, BML, Sewer & Water Utility) – Field work began on May 1st
and was completed by May 5th. 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 are close to completion and should be available for audit review
by month end. Following will be preparation of the Management Discussion and Analysis (MD&A) for finalization
of the City Financial Statement document. The audit presentation is expected to take place at the Finance Committee
meeting in late July or August. Preliminary results for all funds have continued to be extremely positive, including the
working capital within the Water Utility which has almost reached the recommended funding level equivalent to three
months of operating expenditures.
2016 Workers Compensation Audit – Audit took place on February 3rd, resulting in a $12,075 credit to the City.
2016 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 2018 Budget Goals and Timeline will be prepared within the next few weeks and distributed
sometime during the month of 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.
Investments/Financial Status – Available funds in the Water Utility and Library Trust have recently been invested
in the Certificate of Deposit Account Registry Service Network (CDARS) and new Expanded FDIC Insurance
Account for improved rates of return. Recently the City received notice from LendEDU for ranking in the top 500
“U.S. Cities with the Best & Worst Credit Scores”. Muskego ranked #44 overall and 5th in Wisconsin. The full report
and methodology can be found at https://lendedu.com/blog/best-credit-score/.
Debt Issuance – Borrowing for the Public Works and Police Department facility projects will be reviewed following
the bidding process, which is anticipated to take place in late 2017 or early spring of 2018. Additionally, analysis has
been ongoing to consider the appropriate timing of converting the Water Utility Revenue Debt 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.
FINANCE & ADMIN. DIRECTOR’S REPORT 05/23/17
PAGE 2
2
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 20th.
The City Wellness Program Health Risk Assessment took place the week of May 15th. Final assessment and
participation reports will follow.
Health insurance rate renewal information as well as other employee benefit options is under review. Updates
will be presented at the May 23rd COW meeting.
4th & 1st Quarter Utility Bills – Billings and collections processed in a timely manner with no issues to report.
Wisconsin Revolving Loan Fund Semi-Annual Report Certification – Reconciled and submitted to the
Department of Commerce on April 7th.
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 is scheduled to take place on Monday, May 22nd with adjournment
to July 27th. Meetings include selection of a Vice Chairman, review of policies and establishing dates for future
meetings.
Licensing – Staff has begun the process of preparing and issuing various licenses and permits, including liquor and
fireworks.
Other Projects – Continued progression with Electronic Payment processing, miTime (electronic timekeeping),
Accounts Payable workflow and upgrade/conversion to OnBase document management system.
1st Quarter, 2017 General Fund Operating Results and 2016 Annual Results – See attached and below.
The attached worksheets recap the City’s General Fund operating results for the first quarter ending March 31st, 2017.
Net revenues over expenditures are extremely consistent with the prior year, resulting in a slight increase of $50,773.
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 (-) 79.56% which is a minimal variance of 0.16% over the prior year.
March 31, 2017
Budget Actual Over/(Under) % Over/(Under)Revenue Comparison
Taxes $10,358,898 $10,337,084 -$21,814 -0.21%
Intergovernmental $1,797,733 $279,148 -$1,518,584 -84.47%
Licenses and Permits $769,470 $107,477 -$661,993 -86.03%
Fines, Forfeits and Penalties $299,000 $107,214 -$191,786 -64.14%
Public Charges for Services $722,755 $140,947 -$581,808 -80.50%
Intergov. Charges for Services $149,000 $1,055 -$147,945 -99.29%
Miscellaneous $278,890 $69,904 -$208,986 -74.93%
Other Financing Sources $575,000 $0 -$575,000 -100.00%
Interdepartmental $105,004 $15,300 -$89,704 -85.43%
Total Revenue
$15,055,750 $11,058,130 ($3,997,619) -26.55%
2017 Budget Quarter 1 Results: REVENUES
General Fund -
Annual Operating Results
93%
3%
1%
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
March 31, 2017
General Government Budget Actual Over/(Under) % Over/(Under)Actual Cost Breakdown
Common Council/Mayor $204,438 $48,599 -$155,840 -76.23%
Finance & Administration $578,932 $118,663 -$460,269 -79.50%
Assessor $169,625 $27,824 -$141,801 -83.60%
Attorney $113,149 $21,944 -$91,206 -80.61%
Non-Departmental $591,660 $236,231 -$355,429 -60.07%
Municipal Court $214,379 $49,791 -$164,589 -76.77%
Building Maintenance $190,652 $40,485 -$150,167 -78.76%
Information Technology $358,737 $65,188 -$293,549 -81.83%
Bank Service Charges $19,000 $2,967 -$16,033 -84.38%
Total $2,440,572 $611,690 -$1,828,882 -74.94%
Public Safety Budget Actual Over/(Under) % Over/(Under)
Police - Sworn Officers $4,787,265 $1,123,172 -$3,664,094 -76.54%
Police - Dispatch & Clerical $684,170 $147,218 -$536,952 -78.48%
Volunteer Fire $794,313 $116,250 -$678,063 -85.36%
Non-Departmental $20,910 $14,710 -$6,200 -29.65%
Building Inspection $279,867 $32,252 -$247,615 -88.48%
Total $6,566,525 $1,433,602 -$5,132,923 -78.17%
Health & Human Services Budget Actual Over/(Under) % Over/(Under)
Animal Warden $3,600 $0 -$3,600 -100.00%
Public Safety Supplies & Expenses $50 $0 -$50 -100.00%
Total $3,650 $0 -$3,650 -100.00%
Public Works Budget Actual Over/(Under) % Over/(Under)Budget vs. Actual
Engineering $176,564 $32,746 -$143,819 -81.45%
Public Works $2,423,647 $493,136 -$1,930,511 -79.65%
Total $2,600,211 $525,881 -$2,074,330 -79.78%
Culture, Recreation & Education Budget Actual Over/(Under) % Over/(Under)
Parade Fund & Little Lake District $59,000 -$240 -$59,240 -100.41%
Library $1,206,056 $272,273 -$933,783 -77.42%
Parks $30,655 $1,531 -$29,124 -95.00%
Recreation $564,133 $78,434 -$485,699 -86.10%
Total $1,859,844 $351,998 -$1,507,846 -81.07%
Conservation & Development Budget Actual Over/(Under) % Over/(Under)
Planning, Conservation & Development $422,946 $74,618 -$348,328 -82.36%
Total $422,946 $74,618 -$348,328 -82.36%
Capital Outlay-Operations Budget Actual Over/(Under) % Over/(Under)
Computer Replacements $18,000 $0 -$18,000 -100.00%
Server/Host Replacements $7,000 $0 -$7,000 -100.00%
Social Media Archive $4,000 $3,788 -$212 -5.30%
Police Vehicle Replacements $103,000 $73,270 -$29,730 -28.86%
Road Program $725,000 $2,015 -$722,985 -99.72%
Public Works Vehicle Replacements $185,000 $0 -$185,000 -100.00%
Contingency $80,000 $0 -$80,000 -100.00%
Trf to Comp Abs from GF $40,000 $0 -$40,000 -100.00%
Total $1,162,000 $79,073 -$1,082,927 -93.20%
Total Expenditures Budget Actual Over/(Under) % Over/(Under)
$15,055,749 $3,076,863 ($11,978,887)-79.56%
2017 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%
47%
0%
17%
11%2%3%
General Government
Public Safety
Health & Human Services
Public Works
Culture, Recreation & Education
Conservation & Development
Capital Outlay-Operations
March 31, 2017
2017 2016 Comparison Revenues vs. Expenditures
Total Revenues $11,058,130 $10,920,341 $137,790
Total Expenditures $3,076,863 $2,989,846 $87,017
Total
Surplus/(Deficit)
$7,981,268 $7,930,495 $50,773
General Fund -
Annual Operating Results
Quarter 1 Budget Results - 2017 vs. 2016
$0
$2,000,000
$4,000,000
$6,000,000
$8,000,000
$10,000,000
$12,000,000
2017 2016
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 23rd, 2017
RE: 2016 Annual Operating Results (Preliminary)
______________________________________________________________________________
The attached worksheets recap the City’s annual operating results for the General Operating
Fund. As of December 31st, 2016, revenues exceeded expenditures by $913,428. The following
listing is an itemization of accounts contributing to the unanticipated budget surplus:
$ – Over/(Under) Budget
Revenues = $173,468 Over Budget –
$ 155,029 – Fines, Forfeits & Penalties (overweight hauling fines)
$ 29,946 – Licenses & Permits (contracted building inspection)
$ 129,159 – Public Charges for Services (fees & insurance dividends)
$( 14,189) – Other Financing Sources (Water Utility Tax Equivalent)
$(126,477) – Interdepartmental (vehicle reimbursements not required)
Expenditures = $(739,960) Under Budget –
$(298,037) – Personnel Expenditures (various vacancies)
$(220,645) – Health Insurance (negotiated rate renewal & vacancies)
$(123,900) – Fuel, Gas & Electric
$( 64,222) – City Insurance (workers comp.)
$( 22,392) – Assessor & Contracted Services (revaluation fee carryover)
$( 22,000) – Public Works Materials & Supplies
$( 74,025) – Contingency (use not required)
$ 85,261 – Capital Outlay Projects (comp abs funding & road program)
Recent updates regarding reduced Federal funding for the Moorland Reconstruction project
indicate that the City may need to budget an additional $700,000+. Council may want to
consider reserving a portion of the 2016 budget surplus for this anticipated deficit.
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.
December 31, 2016
Budget Actual Over/(Under) % Over/(Under)Revenue Comparison
Taxes $10,251,398 $10,244,098 -$7,300 -0.07%
Intergovernmental $1,829,559 $1,833,891 $4,332 0.24%
Licenses and Permits $747,712 $777,658 $29,946 4.01%
Fines, Forfeits and Penalties $207,000 $362,029 $155,029 74.89%
Public Charges for Services $666,831 $795,990 $129,159 19.37%
Intergov. Charges for Services $146,200 $150,121 $3,921 2.68%
Miscellaneous $237,870 $232,259 -$5,612 -2.36%
Other Financing Sources $574,000 $564,471 -$9,530 -1.66%
Interdepartmental $217,150 $90,673 -$126,477 -58.24%
Total Revenue
$14,877,720 $15,051,188 $173,468 1.17%
2016 Budget Quarter 4 Results: REVENUES
General Fund -
Annual Operating Results
68%
12%
5%
2%5%
1%
2%
4%
1%
Taxes
Intergovernmental
Licenses and Permits
Fines, Forfeits and Penalties
Public Charges for Services
Intergov. Charges for Services
Miscellaneous
Other Financing Sources
Interdepartmental
December 31, 2016
General Government Budget Actual Over/(Under) % Over/(Under)Actual Cost Breakdown
Common Council/Mayor $205,578 $196,495 -$9,083 -4.42%
Finance & Administration $612,038 $579,361 -$32,677 -5.34%
Assessor $147,375 $108,983 -$38,392 -26.05%
Attorney $110,133 $99,734 -$10,399 -9.44%
Non-Departmental $574,517 $491,897 -$82,620 -14.38%
Municipal Court $195,228 $183,910 -$11,318 -5.80%
Building Maintenance $192,162 $175,927 -$16,235 -8.45%
Information Technology $339,739 $213,081 -$126,657 -37.28%
Bank Service Charges $18,000 $20,003 $2,003 11.13%
Total $2,394,770 $2,069,393 -$325,377 -13.59%
Public Safety Budget Actual Over/(Under) % Over/(Under)
Police - Sworn Officers $4,639,586 $4,450,798 -$188,788 -4.07%
Police - Dispatch & Clerical $666,501 $639,989 -$26,512 -3.98%
Volunteer Fire $790,765 $793,327 $2,562 0.32%
Non-Departmental $20,511 $19,362 -$1,149 -5.60%
Building Inspection $247,443 $262,690 $15,246 6.16%
Total $6,364,807 $6,166,166 -$198,641 -3.12%
Health & Human Services Budget Actual Over/(Under) % Over/(Under)
Animal Warden $3,600 $3,581 -$19 -0.53%
Public Safety Supplies & Expenses $50 $37 -$13 -26.40%
Total $3,650 $3,618 -$32 -0.88%
Public Works Budget Actual Over/(Under) % Over/(Under)Budget vs. Actual
Engineering $196,512 $170,710 -$25,802 -13.13%
Public Works $2,381,604 $2,318,681 -$62,923 -2.64%
Total $2,578,116 $2,489,391 -$88,725 -3.44%
Culture, Recreation & Education Budget Actual Over/(Under) % Over/(Under)
Parade Fund & Little Lake District $59,500 $59,999 $499 0.84%
Library $1,233,258 $1,149,760 -$83,498 -6.77%
Parks $29,275 $28,209 -$1,066 -3.64%
Recreation $564,764 $520,430 -$44,334 -7.85%
Total $1,886,797 $1,758,399 -$128,398 -6.81%
Conservation & Development Budget Actual Over/(Under) % Over/(Under)
Planning, Conservation & Development $381,244 $371,222 -$10,022 -2.63%
Total $381,244 $371,222 -$10,022 -2.63%
Capital Outlay-Operations Budget Actual Over/(Under) % Over/(Under)
Computer Replacements $18,000 $14,412 -$3,588 -19.93%
Mobile Devices $0 $0 $0 #DIV/0!
Server Replacements $0 $0 $0 #DIV/0!
Police Vehicle Replacements $77,700 $85,824 $8,124 10.46%
Road Program $700,000 $713,243 $13,243 1.89%
Public Works Vehicle Replacements $185,000 $173,815 -$11,185 -6.05%
Contingency $74,025 $0 -$74,025 -100.00%
Trf to Capital from GF $213,610 $213,610 $0 0.00%
GF Trf to Comp Abs Fund $0 $78,667 $78,667 #DIV/0!
Total $1,268,335 $1,279,571 $11,236 0.89%
Total Expenditures Budget Actual Over/(Under) % Over/(Under)
$14,877,719 $14,137,760 ($739,960)-4.97%
2016 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%
44%
0%
17%
12%3%9%
General Government
Public Safety
Health & Human Services
Public Works
Culture, Recreation & Education
Conservation & Development
Capital Outlay-Operations
December 31, 2016
2016 2015 Comparison Revenues vs. Expenditures
Total Revenues $15,051,188 $14,573,028 $478,160
Total Expenditures $14,137,760 $13,938,218 $199,541
Total
Surplus/(Deficit)
$913,428 $634,810 $278,618
General Fund -
Annual Operating Results
Annual Budget Results - 2016 vs. 2015
$13,200,000
$13,400,000
$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
2016 2015