Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
FINANCE COMMITTEE Packet - 10/10/2017
CITY OF MUSKEGO FINANCE COMMITTEE AGENDA October 10, 2017 6:20 PM City Hall, W182 S8200 Racine Avenue CALL TO ORDER PLEDGE OF ALLEGIANCE ROLL CALL PUBLIC MEETING NOTICE APPROVAL OF MINUTES - September 26, 2017 LICENSE APPROVALS 1. Recommend Approval of Operator Licenses 2. Report on Three-Month Background Check for Colleen Dobrzynski-Gartzke and Scott Walker 3. Review and Recommendation Regarding Operator Application for Angeline Livingston NEW BUSINESS 1. Review and Recommendation Regarding Lions Park Pickleball Court Maintenance VOUCHER APPROVAL 1. Utility Vouchers 2. General Fund Vouchers 3. Wire Transfers for Payroll/Invoice Transmittals FINANCE DIRECTOR’S REPORT - Second Quarter 2017 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. Unapproved CITY OF MUSKEGO FINANCE COMMITTEE MINUTES September 26, 2017 6:15 PM City Hall, W182 S8200 Racine Avenue CALL TO ORDER Alderman Wolfe called the meeting to order at 6:16 pm. PLEDGE OF ALLEGIANCE Those present recited the Pledge of Allegiance. ROLL CALL Present: Committee Members Aldermen Wolfe and Kapusta. Committee Member Alderman Kubacki was absent. Also present: Aldermen Hammel, Borgman and Engelhardt, City Attorney Warchol and Finance and Administration Director Mueller. Mayor Chiaverotti arrived at 6:25 pm. PUBLIC MEETING NOTICE Ms. Mueller stated that the meeting was noticed in accordance with the open meeting law. APPROVAL OF MINUTES - September 12, 2017 Alderman Kapusta made a motion to approve. Alderman Wolfe seconded; motion carried. 2016 AUDIT PRESENTATION Wendi Unger and Tim Sowinski of Baker Tilly Virchow Krause, LLP were present and distributed the “City of Muskego Report to the Mayor and Finance Committee.” Mr. Sowinski reviewed the highlights of the report. LICENSE APPROVALS Recommend Approval of Operator Licenses Alderman Kapusta made a motion to recommend approval of an Operator License for Deborah Brook, Anthony DeFancisco, Isabel Gallegos, Korey Klohn, Chad Lugo and Kent McCullough. Alderman Wolfe seconded; motion carried. Approval of Taxi Driver Licenses for the Muskego Senior Taxi Service - Mary E. Zurowski and Sharan Zelinski Alderman Wolfe made a motion to approve. Alderman Kapusta seconded; motion carried. Report on Three-Month Background Check for Jerrylee Coubal, Adam Jankowski and Ryan Oschmann Finance Committee Minutes 2 September 26, 2017 A three-month background check did not reflect any new issues for Jerrylee Coubal, Adam Jankowski and Ryan Oschmann. Recommend Approval of Outside Dance Permit (Noon to 4:00 p.m.) and Request to Amend Licensed Premise (Noon to 6:00 p.m.) for The Gingerbread House - September 30, 2017 Alderman Wolfe made a motion to recommend approval. Alderman Kapusta seconded; motion carried. UNFINISHED BUSINESS Recommendation Regarding Temporary Limited Wetland Restoration Easement Granted by the Wisconsin DNR (Deferred September 12, 2017) City Attorney Warchol noted that the DNR agreed to remove the clause in the easement document that he objected to. Alderman Wolfe made a motion to recommend approval. Alderman Kapusta seconded; motion carried. NEW BUSINESS Recommend Approval of Reduction of Letter of Credit for Edgewater Heights Phase II Subdivision Alderman Wolfe made a motion to recommend the Letter of Credit be reduced to $920,888.61. Alderman Kapusta seconded; motion carried. Recommend Award of Bid - Wetland Restoration Project The following bids were received: Base Bid__ Mud Tech $175,032.00 Schaefer Snowplowing and Grading $ 49,920.00 Superwestern $124,800.00 Buteyn-Peterson $486,720.00 Krause Excavating $ 96,408.00 Alderman Wolfe made a motion to recommend the bid be awarded to Schaefer Snowplowing and Grading. Alderman Kapusta seconded; motion carried. VOUCHER APPROVAL Utility Vouchers Alderman Wolfe made a motion to recommend approval of Utility Vouchers in the amount of $25,089.33. Alderman Kapusta seconded; motion carried. Tax Vouchers Alderman Wolfe made a motion to recommend approval of Tax Vouchers in the amount of $262.34. Alderman Kapusta seconded; motion carried. Finance Committee Minutes 3 September 26, 2017 General Fund Vouchers Alderman Wolfe made a motion to recommend approval of General Vouchers in the amount of $907,235.02. Alderman Kapusta seconded; motion carried. Wire Transfers for Debt Service Alderman Wolfe made a motion to recommend approval of Wire Transfers for Debt Service in the amount of $1,627,422.38. Alderman Kapusta seconded; motion carried. Wire Transfers for Payroll/Invoice Transmittals Alderman Wolfe made a motion to recommend approval of Wire Transfers for Payroll/Invoice Transmittals in the amount of $844,297.93. Alderman Kapusta seconded; motion carried. ADJOURNMENT Alderman Kapusta moved to adjourn at 6:36 pm. Alderman Wolfe seconded; motion carried. Minutes transcribed by Kim Chavie, Assistant Deputy Clerk OPERATOR LICENSE APPROVALS COMMON COUNCIL –10/10/2017 Nora Baranyk Jennifer Goessling Richard Grabow Lisa Hamilton Jessica Kosiboski Jacquelyn Nycz T:\Departments\FinanceAdmin\Clerk\Licenses\Oper Lic Approval Lists\2017 CITY OF MUSKEGO Staff Report to Finance Committee/Common Council To: Finance Committee/Common Council From: Scott Kroeger, PE, PLS – Public Works and Development Director Subject: Lions Park Pickleball Court Maintenance Project Date: October 10, 2017 The City of Muskego is seeking to address the state of the Lions Park pickleball courts by implementing a two-phase maintenance plan to eliminate the rapid deterioration of the pickleball court surface and bring them back to the proper level of play. Fall 2017: The first phase includes the removal and installation of new net posts with internal cranking systems, address all cracking on surface, asphalt paving of 1 1/2”-2” thickness over entire court surface to eliminate puddling and pitted areas, and apply temporary lines to keep courts playable. (Cost of $24,744.00) Spring 2018: The second phase will be the painting of the courts. The 4 court Plexipave System entails two coats of black textured acrylic resurfacer, two coats of colored blue and green Plexipave. Each coat of paint will be cross-applied from previously applied coat. Lastly is to layout and apply white masked lines. (Cost of $8,145.00) Recommendation for Action by Committee: With the initial investment to install the pickleball courts and with the several private donations, the City Recreation Pickleball program is now attended by more than 130 participants annually and is one of the largest in our area. To protect the City’s initial investment with the courts, we recommend moving forward to implement this two phase project to eliminate the deterioration of the playing surface and create a well-rounded facility to maintain this thriving program. Council Date OCTOBER 10, 2017 Total Vouchers All Funds $454,757.06 Total Voucher Approval Utility Vouchers (Approve Separately) Water Vouchers $47,029.01 Water Wire Transfers Total Water $47,029.01 Sewer Vouchers 20,394.07 Sewer Wire Transfers Total Sewer $20,394.07 Net Total Utility Vouchers $ 67,423.08 #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 $386,502.58 General Fund Void Checks ()** Total General Fund Vouchers $ 386,502.58 #3 - General Voucher Approval Big Muskego Lake Vouchers $831.40 . Wire transfers (Approve Separately): Tax Settlements $ Debt Service $ Payroll/Invoice Transmittals $369,434.94 #4 - Wire Transfers Approval Void Checks Since Last Report Check #Amount Check #Amount Total *** Total 0.00 *Total *** CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 1 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM 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 ASSOCIATED BAG COMPANY D 59594 1 Invoice GLOVES 09/19/2017 10/10/2017 115.25 1017 100.02.20.01.5722 Total ASSOCIATED BAG COMPANY:115.25 ASSOCIATED TRUST CO 7168 1 Invoice ANNUAL FEE- WATER REVENUE B 09/11/2017 10/10/2017 475.00 1017 605.56.09.21.6056 Total ASSOCIATED TRUST CO:475.00 ASSURANT EMPLOYEE BENEFITS 60169/101017 2 Invoice ACCIDENT - SEPT 2017 09/19/2017 10/10/2017 128.41 1017 100.00.00.00.2247 60169/101017 4 Invoice CRITICAL ILLNESS - SEPT 2017 09/19/2017 10/10/2017 43.80 1017 100.00.00.00.2248 60169/101017 1 Invoice LONG TERM DIS - SEPT 2017 09/19/2017 10/10/2017 383.36 1017 100.00.00.00.2246 60169/101017 3 Invoice SHORT TERM DIS - SEPT 2017 09/19/2017 10/10/2017 460.20 1017 100.00.00.00.2243 Total ASSURANT EMPLOYEE BENEFITS:1,015.77 BAKER & TAYLOR COMPANY 0003010635 1 Invoice PRINT 09/12/2017 10/10/2017 31.69-1017 100.05.71.01.5711 2033139753 1 Invoice PRINT 09/07/2017 10/10/2017 334.73 1017 100.05.71.01.5711 2033146667 1 Invoice PRINT 09/09/2017 10/10/2017 925.59 1017 100.05.71.01.5711 2033157353 1 Invoice PRINT 09/13/2017 10/10/2017 166.25 1017 100.05.71.01.5711 2033172176 1 Invoice PRINT 09/20/2017 10/10/2017 2,181.41 1017 100.05.71.01.5711 2033174991 1 Invoice PRINT 09/20/2017 10/10/2017 1,035.19 1017 100.05.71.01.5711 2033181031 1 Invoice PRINT 09/22/2017 10/10/2017 204.86 1017 100.05.71.01.5711 5014691093 1 Invoice PRINT 09/06/2017 10/10/2017 131.53 1017 100.05.71.01.5711 5014698423 1 Invoice PRINT 09/13/2017 10/10/2017 59.43 1017 100.05.71.01.5711 5014705986 1 Invoice PRINT 09/20/2017 10/10/2017 21.07 1017 100.05.71.01.5711 Total BAKER & TAYLOR COMPANY:5,028.37 BAKER & TAYLOR ENTERTAINMENT B60691220 1 Invoice AV 09/09/2017 10/10/2017 162.63 1017 100.05.71.02.5711 B60899990 1 Invoice AV 09/12/2017 10/10/2017 11.88 1017 100.05.71.02.5711 B60899991 1 Invoice AV 09/12/2017 10/10/2017 179.88 1017 100.05.71.02.5711 B60899992 1 Invoice AV 09/12/2017 10/10/2017 7.91 1017 100.05.71.02.5711 B60899993 1 Invoice AV 09/12/2017 10/10/2017 35.99 1017 100.05.71.02.5711 B61531400 1 Invoice AV 09/19/2017 10/10/2017 288.52 1017 100.05.71.02.5711 B61556200 1 Invoice AV 09/19/2017 10/10/2017 11.03 1017 100.05.71.02.5711 B61556201 1 Invoice AV 09/19/2017 10/10/2017 103.57 1017 100.05.71.02.5711 B61556202 1 Invoice AV 09/19/2017 10/10/2017 39.58 1017 100.05.71.02.5711 B61556203 1 Invoice AV 09/19/2017 10/10/2017 10.79 1017 100.05.71.02.5711 B61556204 1 Invoice AV 09/19/2017 10/10/2017 21.59 1017 100.05.71.02.5711 B61556205 1 Invoice AV 09/19/2017 10/10/2017 21.59 1017 100.05.71.02.5711 B62139290 1 Invoice AV 09/26/2017 10/10/2017 138.20 1017 100.05.71.02.5711 B62139291 1 Invoice AV 09/26/2017 10/10/2017 187.02 1017 100.05.71.02.5711 B62139292 1 Invoice AV 09/26/2017 10/10/2017 13.64 1017 100.05.71.02.5711 T64609980 1 Invoice AV 09/21/2017 10/10/2017 64.77 1017 100.05.71.02.5711 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 2 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total BAKER & TAYLOR ENTERTAINMENT:1,298.59 BAKER TILLY VIRCHOW KRAUSE, LLP BT1161451 1 Invoice AUDIT FINAL BILLING - CITY FUND 09/29/2017 10/10/2017 37,400.00 1017 100.01.06.00.5810 BT1161451 3 Invoice AUDIT FINAL BILLING - SEWER UT 09/29/2017 10/10/2017 2,350.00 1017 601.61.63.43.5810 BT1161451 2 Invoice AUDIT FINAL BILLING - WATER UTI 09/29/2017 10/10/2017 3,150.00 1017 605.56.09.23.5810 BT1161452 1 Invoice FINAL AUDIT BILLING - BIG LAKE 09/29/2017 10/10/2017 500.00 1017 250.01.00.00.5810 Total BAKER TILLY VIRCHOW KRAUSE, LLP:43,400.00 BPI COLOR 0515278 1 Invoice LARGE FORMAT PAPER 09/21/2017 10/10/2017 197.48 1017 100.06.18.01.5704 Total BPI COLOR:197.48 BRODART CO. 480551 1 Invoice PROCESSING 09/18/2017 10/10/2017 320.00 1017 100.05.71.00.5702 Total BRODART CO.:320.00 BUMPER TO BUMPER MUSKEGO 644-497164 1 Invoice SUPPLIES 09/22/2017 10/10/2017 22.58 1017 215.06.00.00.5704 Total BUMPER TO BUMPER MUSKEGO:22.58 BURMEISTER,GREG BU101017-AD 1 Invoice LANDFILL MEETING 9/11/17 10/02/2017 10/10/2017 50.00 1017 207.01.00.00.6055 Total BURMEISTER,GREG:50.00 CHAPPELL SPORTS 20352 1 Invoice YOUTH SPORTS PROGRAM SHIR 09/27/2017 10/10/2017 80.00 1017 100.05.72.13.5702 Total CHAPPELL SPORTS:80.00 CITY OF MUSKEGO 2258.042/1010 1 Invoice BML PMT #2258.042/SERGENT RU 09/29/2017 10/10/2017 39.20 1017 100.00.00.00.1601 CI101017-BL 1 Invoice BML PUBS 09/14/2017 10/10/2017 331.40 1017 250.01.00.00.5710 Total CITY OF MUSKEGO:370.60 CITY OF WAUKESHA MUNICPAL CRT 13249 1 Invoice WARRANT MARTIN BEMBENEK 09/22/2017 10/10/2017 76.20 1017 100.01.08.00.4272 Total CITY OF WAUKESHA MUNICPAL CRT:76.20 COMMUNITY MEMORIAL HOSPITAL 1354052 1 Invoice BLOOD DRAW 06/14/2017 10/10/2017 33.00 1017 100.02.20.01.5722 1644909 1 Invoice BLOOD DRAW 09/15/2017 10/10/2017 33.00 1017 100.02.20.01.5722 2613566 1 Invoice BLOOD DRAW 08/07/2017 10/10/2017 33.00 1017 100.02.20.01.5722 2677534 1 Invoice BLOOD DRAW 09/17/2017 10/10/2017 33.00 1017 100.02.20.01.5722 Total COMMUNITY MEMORIAL HOSPITAL:132.00 COMPLETE OFFICE OF WIS 150783 1 Invoice PROGRAMMING 09/19/2017 10/10/2017 95.80 1017 100.05.71.00.6062 150783 2 Invoice MISC OFFICE SUPPLIES 09/19/2017 10/10/2017 66.08 1017 100.05.71.00.5701 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 3 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number 152681 1 Invoice PENS - SUPPLY ROOM 09/21/2017 10/10/2017 19.26 1017 100.01.06.00.5701 153677 1 Invoice PENS - TINA 09/22/2017 10/10/2017 34.96 1017 100.01.03.00.5701 158545 1 Invoice BINDER CLIPS/CALENDAR/LAMIN 09/29/2017 10/10/2017 67.83 1017 100.02.20.01.5701 158546 1 Invoice CD ENVELOPES 09/29/2017 10/10/2017 52.30 1017 100.02.20.01.5701 161268 1 Invoice MAILROOM SUPPLIES 10/04/2017 10/10/2017 36.60 1017 100.01.06.00.5701 161268 2 Invoice FINANCE SUPPLIES 10/04/2017 10/10/2017 48.03 1017 100.01.03.00.5701 161270 1 Invoice RED BINDERS - TINA 10/04/2017 10/10/2017 27.12 1017 100.01.03.00.5701 Total COMPLETE OFFICE OF WIS:447.98 CONSTANTINEAU, DAVID CO101017-PD 1 Invoice TRAINING MEALS 09/20/2017 10/10/2017 24.09 1017 100.02.20.01.5301 Total CONSTANTINEAU, DAVID:24.09 CORE & MAIN LP H804801 1 Invoice PVC PIPE 09/15/2017 10/10/2017 693.00 1017 100.04.51.04.5745 H881149 1 Invoice LITTLE LAKE DRAW DOWN CPLG 09/29/2017 10/10/2017 258.26 1017 100.04.51.09.5744 H884259 1 Invoice LITTLE LAKE DRAW DOWN 10/02/2017 10/10/2017 306.60 1017 100.04.51.09.5744 H893437 1 Invoice LITTLE LAKE DRAW DOWN SUPPL 10/03/2017 10/10/2017 939.96 1017 100.04.51.09.5744 Total CORE & MAIN LP:2,197.82 CRACK FILLING SRV. CORP. CR101017-DP 1 Invoice CRACK FILLING 09/18/2017 10/10/2017 50,000.00 1017 100.04.51.02.5740 Total CRACK FILLING SRV. CORP.:50,000.00 DC MOTORS PLUS INC 74335 1 Invoice PAINT LIFT 09/19/2017 10/10/2017 350.00 1017 601.61.61.15.5415 Total DC MOTORS PLUS INC:350.00 DEMCO EDUCATIONAL CORP 6217071 1 Invoice PROCESSING 09/22/2017 10/10/2017 649.30 1017 100.05.71.00.5702 Total DEMCO EDUCATIONAL CORP:649.30 DF TOMASINI, INC. DFT 2007-35/1 1 Invoice WATER MAIN REPAIR - CITY HALL 07/17/2017 10/10/2017 2,182.40 1017 605.54.06.51.5410 DFT#2007-52 1 Invoice SATURN DR MAIN BREAK 09/13/2017 10/10/2017 4,613.08 1017 605.54.06.51.5410 Total DF TOMASINI, INC.:6,795.48 DISC GOLF ASSOCIATION, INC. 50706 1 Invoice DISC GOLF ANCHORS 09/28/2017 10/10/2017 259.00 1017 100.04.51.08.5415 Total DISC GOLF ASSOCIATION, INC.:259.00 DISCOUNT SCHOOL SUPPLY W2942880010 1 Invoice PRESCHOOL CLASSROOM SUPPL 09/19/2017 10/10/2017 64.87 1017 100.05.72.16.5702 Total DISCOUNT SCHOOL SUPPLY:64.87 DIVERSIFIED BENEFIT SERV INC. 248503 1 Invoice FSA FEES - SEPT 09/19/2017 10/10/2017 184.25 1017 100.01.06.00.5203 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 4 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total DIVERSIFIED BENEFIT SERV INC.:184.25 DIVERSIFIED TRUCK SRV INC 7745 1 Invoice TRUCK 14 SAND BLASTING 09/27/2017 10/10/2017 3,463.00 1017 100.04.51.07.5405 7746 1 Invoice TRK 14 SAND BLASTING 09/27/2017 10/10/2017 3,143.00 1017 100.04.51.07.5405 Total DIVERSIFIED TRUCK SRV INC:6,606.00 EAGLE MEDIA, INC. 00124729 1 Invoice FALL CA POLOS 09/18/2017 10/10/2017 188.64 1017 100.02.20.01.5721 Total EAGLE MEDIA, INC.:188.64 ENVIROTECH EQUIPMENT CO 092317-14A 1 Invoice SWR NOZZLE 09/23/2017 10/10/2017 159.87 1017 601.61.61.16.5411 092317-15A 1 Invoice TIGERTAIL SWR GUIDE 09/23/2017 10/10/2017 122.00 1017 601.61.61.16.5411 Total ENVIROTECH EQUIPMENT CO:281.87 F & W LANDSCAPE SPECIALISTS 206 1 Invoice PARKS MOWING PAYMENT 6 OF 7 10/01/2017 10/10/2017 5,214.28 1017 100.04.51.01.5820 Total F & W LANDSCAPE SPECIALISTS:5,214.28 FACTORY MOTOR PARTS CO 13-Z08556 1 Invoice BATTERY 09/14/2017 10/10/2017 330.88 1017 601.61.61.16.5411 Total FACTORY MOTOR PARTS CO:330.88 FASTENAL COMPANY WIMUK68088 1 Invoice MCSHANE 09/21/2017 10/10/2017 37.64 1017 601.61.61.16.5411 Total FASTENAL COMPANY:37.64 FERGUSON WATERWORKS #1476 0232913 1 Invoice 3" HYDRANT MTR 09/26/2017 10/10/2017 1,340.75 1017 605.00.00.00.1953 Total FERGUSON WATERWORKS #1476:1,340.75 FOTH INFRASTRUCTURE & 54165 1 Invoice BELLE CHASSE PHASE III 10/03/2017 10/10/2017 5,340.14 1017 507.00.00.00.2708 54166 1 Invoice EDGEWATER HEIGHTS 10/03/2017 10/10/2017 22,916.12 1017 507.00.00.00.2672 Total FOTH INFRASTRUCTURE &:28,256.26 FRANKLIN AGGREGATES, INC. 1512606 1 Invoice STONE 09/21/2017 10/10/2017 2,944.37 1017 100.04.51.02.5741 Total FRANKLIN AGGREGATES, INC.:2,944.37 GAMETIME INC PJI-0069894 1 Invoice SWING 09/18/2017 10/10/2017 2,200.22 1017 100.04.51.08.5415 Total GAMETIME INC:2,200.22 GELLINGS, BLAINE GE101017-UT 2 Invoice BAL DUE 10/03/2017 10/10/2017 31.25 1017 605.56.09.30.5228 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 5 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number GE101017-UT 1 Invoice BAL DUE 10/03/2017 10/10/2017 31.26 1017 601.61.61.12.5702 Total GELLINGS, BLAINE:62.51 GRAEF INC 0094543 1 Invoice MUSKEGO HI VIEW DRIVE WATER 09/19/2017 10/10/2017 2,625.00 1017 605.56.09.23.5815 0094544 1 Invoice GENERAL PLANNING 09/19/2017 10/10/2017 1,314.75 1017 100.06.18.01.5801 0094545 1 Invoice GENERAL ENGINEERING 09/19/2017 10/10/2017 2,316.20 1017 100.04.19.00.5815 0094545 3 Invoice COMMERCE CENTER INDUSTRIA 09/19/2017 10/10/2017 187.50 1017 507.00.00.00.2666 0094545 5 Invoice MIDDLE SCHOOL WATER MAIN C 09/19/2017 10/10/2017 948.30 1017 507.00.00.00.2732 0094545 7 Invoice FOUR FRONT DEVELOPMENT 09/19/2017 10/10/2017 1,127.00 1017 507.00.00.00.2644 0094545 9 Invoice COMMERCE CENTER CSM 09/19/2017 10/10/2017 471.75 1017 507.00.00.00.2666 0094545 11 Invoice COMMERCE CENTER INDUSTRIA 09/19/2017 10/10/2017 3,365.05 1017 507.00.00.00.2666 0094545 13 Invoice CULVERT INSPECTION S72W1368 09/19/2017 10/10/2017 1,357.83 1017 100.04.51.09.5744 0094545 15 Invoice SAND HILL STAKING 09/19/2017 10/10/2017 2,206.29 1017 203.08.94.74.6501 0094545 2 Invoice SAND HILL PARK PLAYGROUND 09/19/2017 10/10/2017 521.91 1017 203.08.94.74.6501 0094545 4 Invoice MUSKEGO HS CONCESSIONS 09/19/2017 10/10/2017 1,744.44 1017 507.00.00.00.2732 0094545 6 Invoice MIDDLE SCHOOL EASEMENT ACQ 09/19/2017 10/10/2017 1,441.05 1017 507.00.00.00.2732 0094545 8 Invoice JEWELL HILLENDALE 2 LOT CSM 09/19/2017 10/10/2017 23.00 1017 507.00.00.00.2750 0094545 10 Invoice 4 FRONT ENG SOLUTIONS 09/19/2017 10/10/2017 1,316.25 1017 507.00.00.00.2644 0094545 12 Invoice MUSKEGO HS POOL 09/19/2017 10/10/2017 507.00 1017 507.00.00.00.2732 0094545 14 Invoice BRIDGE INSPECTION S102W1394 09/19/2017 10/10/2017 1,322.76 1017 100.04.51.09.5744 0094545 16 Invoice LITTLE MUSKEGO LAKE DAM INS 09/19/2017 10/10/2017 154.85 1017 100.05.06.00.6052 0094625 1 Invoice GENERAL ENGINEERING 09/26/2017 10/10/2017 138.00 1017 100.04.19.00.5815 0094625 3 Invoice EDGWATER HEIGHTS SUBDIVISIO 09/26/2017 10/10/2017 92.00 1017 507.00.00.00.2672 0094625 5 Invoice CITY HALL DEVELOPMENT 09/26/2017 10/10/2017 1,727.00 1017 401.08.90.09.6550 0094625 7 Invoice MIDDLE SCHOOL NORTH CAPE R 09/26/2017 10/10/2017 2,374.00 1017 507.00.00.00.2732 0094625 9 Invoice GENERAL ENGINEERING 09/26/2017 10/10/2017 115.00 1017 100.04.19.00.5815 0094625 11 Invoice SAND HILL PARK 09/26/2017 10/10/2017 983.47 1017 203.08.94.74.6501 0094625 2 Invoice MSP MUSKEGO 09/26/2017 10/10/2017 9,739.26 1017 507.00.00.00.2697 0094625 4 Invoice 2017 ROAD PROGRAM 09/26/2017 10/10/2017 11,884.16 1017 100.07.51.02.6502 0094625 6 Invoice MOORLAND ROAD PROJECT 09/26/2017 10/10/2017 346.00 1017 410.08.91.19.6503 0094625 8 Invoice MILL VALLEY SCHOOL 09/26/2017 10/10/2017 23.00 1017 507.00.00.00.2732 0094625 10 Invoice THE GLEN AT PELLMAN FARM 09/26/2017 10/10/2017 1,102.25 1017 507.00.00.00.2691 0094625 12 Invoice PINNACLE PEAK 09/26/2017 10/10/2017 837.25 1017 507.00.00.00.2728 Total GRAEF INC:52,312.32 GREEN MEADOWS PETTING FARM GR101017-RE 1 Invoice PRESCHOOL FIELD TRIP 09/29/2017 10/10/2017 486.00 1017 100.05.72.16.5820 Total GREEN MEADOWS PETTING FARM:486.00 HIGGINS TOWER SRV. INC 17-47140 1 Invoice TOWER PAINT 09/13/2017 10/10/2017 17,525.00 1017 605.00.00.00.1941 Total HIGGINS TOWER SRV. INC:17,525.00 HUMPHREY SERVICE PARTS 1155613 1 Invoice TIE WRAPS 09/21/2017 10/10/2017 48.75 1017 100.04.51.07.5405 1155700 1 Invoice VACUUM PUMP KIT 09/22/2017 10/10/2017 74.48 1017 100.04.51.07.5405 1155810 1 Invoice BATTERY STROBE LIGHT 09/22/2017 10/10/2017 191.84 1017 100.04.51.07.5405 Total HUMPHREY SERVICE PARTS:315.07 ITU ABSORB TECH, INC MSOABJ00189 1 Invoice SUPPLIES 09/19/2017 10/10/2017 53.75 1017 100.04.51.01.5228 MSOABJ00189 1 Invoice SUPPLIES 09/19/2017 10/10/2017 15.40 1017 601.61.61.12.5702 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 6 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number MSOABJ00189 2 Invoice SUPPLIES 09/19/2017 10/10/2017 15.40 1017 605.56.09.21.6056 Total ITU ABSORB TECH, INC:84.55 JAMES IMAGING SYSTEMS INC 772135-2 1 Invoice OVERAGE CHARGE OVERPAYME 09/13/2017 10/10/2017 42.65-1017 100.01.06.00.5701 773347 1 Invoice CONTRACT BASE 9/18-10/17/17 09/19/2017 10/10/2017 396.73 1017 100.01.06.00.5410 773348 2 Invoice MONTHLY CHARGE 09/19/2017 10/10/2017 23.26 1017 601.61.63.42.5701 773348 1 Invoice MONTHLY COPIES 09/19/2017 10/10/2017 23.26 1017 605.56.09.21.5401 773348 3 Invoice MONTHLY CHARGES 09/19/2017 10/10/2017 23.25 1017 100.04.51.01.5701 Total JAMES IMAGING SYSTEMS INC:423.85 JAMES IMAGING SYSTEMS INC (lease) 339433286 1 Invoice PUBLIC PRINT STATION 09/08/2017 10/10/2017 425.99 1017 100.05.71.00.5401 Total JAMES IMAGING SYSTEMS INC (lease):425.99 JANI-KING INC- MILW REGION MIL10170153 2 Invoice CLEANING - POLICE DEPT - OCTO 10/01/2017 10/10/2017 1,728.00 1017 100.02.20.01.5835 MIL10170153 4 Invoice CLEANING - TOWN HALL - OCTOB 10/01/2017 10/10/2017 363.00 1017 100.05.72.03.5820 MIL10170153 1 Invoice CLEANING - CITY HALL - OCTOBE 10/01/2017 10/10/2017 2,345.00 1017 100.01.09.00.5835 MIL10170153 3 Invoice CLEANING - LIBRARY - OCTOBER 10/01/2017 10/10/2017 3,049.00 1017 100.05.71.00.5835 MIL10170153 5 Invoice CLEANING - PARK ARTHUR - OCT 10/01/2017 10/10/2017 480.00 1017 100.04.51.01.5820 Total JANI-KING INC- MILW REGION:7,965.00 JM BRENNAN, INC. SALES000088 1 Invoice AC DOWN 08/31/2017 10/10/2017 4,314.20 1017 100.05.71.00.5415 Total JM BRENNAN, INC.:4,314.20 JOHNNY'S PETROLEUM PROD INC 2426/2415 1 Invoice LITTLE DAM FUEL 09/22/2017 10/10/2017 564.46 1017 100.04.51.07.5736 2429 1 Invoice FUEL LITTLE LAKE DAM DRAW DO 09/23/2017 10/10/2017 287.75 1017 100.04.51.09.5744 2434 1 Invoice LITTLE LAKE DRAW DOWN FUEL 09/24/2017 10/10/2017 378.25 1017 100.04.51.09.5744 2438 1 Invoice LITTLE LAKE DRAW DOWN FUEL 09/25/2017 10/10/2017 167.00 1017 100.04.51.09.5744 2445 1 Invoice LITTLE LAKE DRAW DOWN FUEL 09/26/2017 10/10/2017 310.25 1017 100.04.51.09.5744 2452 1 Invoice LITTLE LAKE DRAW DOWN FUEL 09/27/2017 10/10/2017 305.00 1017 100.04.51.09.5744 2459 1 Invoice LITTLE LAKE DRAW DOWN FUEL 09/28/2017 10/10/2017 471.75 1017 100.04.51.09.5744 2467 1 Invoice LITTLE LAKE DRAW DOWN FUEL 09/29/2017 10/10/2017 350.75 1017 100.04.51.09.5744 Total JOHNNY'S PETROLEUM PROD INC:2,835.21 JOHNSON'S NURSERY, INC SBI-11944 1 Invoice TREES 10/03/2017 10/10/2017 107.00 1017 215.06.00.00.6008 Total JOHNSON'S NURSERY, INC:107.00 JOURNAL SENTINEL INC MJ0092662/10 1 Invoice PRINT 09/27/2017 10/10/2017 142.66 1017 100.05.71.02.5711 Total JOURNAL SENTINEL INC:142.66 JSA ENVIRONMENTAL, INC. 2689 1 Invoice VEOLIA OVERSIGHT & AUDIT SEP 10/02/2017 10/10/2017 3,942.95 1017 210.03.00.00.5816 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 7 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total JSA ENVIRONMENTAL, INC.:3,942.95 KIEFFER, ROLAND KI101017-ADE 1 Invoice LANDFILL MEETING 9/11/17 10/02/2017 10/10/2017 50.00 1017 207.01.00.00.6055 Total KIEFFER, ROLAND:50.00 KNOX CO. INV01149363 1 Invoice MIDDLE SCHOOL - 2ND KNOX 09/29/2017 10/10/2017 600.00 1017 100.02.25.00.5704 Total KNOX CO.:600.00 KORNBURGER, CHRISTINE KO101017-RE 1 Invoice CLASS INSTRUCTION - JAZZERCI 09/12/2017 10/10/2017 150.00 1017 100.05.72.13.5110 Total KORNBURGER, CHRISTINE:150.00 LANG TRUCKING 581152 1 Invoice SCREENINGS 09/21/2017 10/10/2017 60.00 1017 605.54.06.41.5415 Total LANG TRUCKING:60.00 LINCOLN CONTRACTORS SUPPLY INC L32018 1 Invoice DISCHARGE HOSE 10/02/2017 10/10/2017 161.97 1017 100.04.51.07.5405 Total LINCOLN CONTRACTORS SUPPLY INC:161.97 LITTLE MUSKEGO LAKE DIST #2193.996/LAR 1 Invoice LMLD LAKE PMT/#2193.996/LARSE 09/25/2017 10/10/2017 400.00 1017 100.05.06.00.6052 2189.093 BOH 1 Invoice LITTLE LAKE PAYMENT 2189.093 B 10/04/2017 10/10/2017 80.00 1017 100.05.06.00.6052 Total LITTLE MUSKEGO LAKE DIST:480.00 LYNKIEWICZ, PETER LY101017-PD 1 Invoice LYNK CIB CONF. ROOM 09/22/2017 10/10/2017 164.00 1017 100.02.20.01.5301 Total LYNKIEWICZ, PETER:164.00 MARK J. RINDERLE TIRE INC. 125029 1 Invoice #14 TIRES 09/21/2017 10/10/2017 1,337.56 1017 100.04.51.07.5735 Total MARK J. RINDERLE TIRE INC.:1,337.56 MATEICKA, SR. DON MA101017-AD 1 Invoice LANDFILL MEETING 9/11/17 10/02/2017 10/10/2017 50.00 1017 207.01.00.00.6055 Total MATEICKA, SR. DON:50.00 MATTANO, REBECCA MA101017-AD 1 Invoice LANDFILL MEETING 9/11/17 10/02/2017 10/10/2017 50.00 1017 207.01.00.00.6055 Total MATTANO, REBECCA:50.00 MCELWEE, BILL 6245 1 Invoice REFUND BOAT LAUNCH MONEY - 09/13/2017 10/10/2017 10.00 1017 100.05.72.02.4315 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 8 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total MCELWEE, BILL:10.00 MCKINLEY CUSTOM PRODUCTS, INC 69026 1 Invoice PUBLIC WORKS BUSINESS CARD 09/27/2017 10/10/2017 108.75 1017 100.04.51.01.5701 69026 2 Invoice ALDERMAN MADDEN - BUSINESS 09/27/2017 10/10/2017 21.75 1017 100.01.01.00.5701 Total MCKINLEY CUSTOM PRODUCTS, INC:130.50 MICROMARKETING LLC 687680 1 Invoice AV 09/06/2017 10/10/2017 72.50 1017 100.05.71.02.5711 688301 1 Invoice AV 09/12/2017 10/10/2017 114.97 1017 100.05.71.02.5711 688378 1 Invoice AV 09/12/2017 10/10/2017 44.99 1017 100.05.71.02.5711 688767 1 Invoice AV 09/14/2017 10/10/2017 45.00 1017 100.05.71.02.5711 Total MICROMARKETING LLC:277.46 NAPA AUTO PARTS/ #26 & 27 205032 1 Invoice LITTLE LAKE DRAW DOWN THER 09/26/2017 10/10/2017 61.98 1017 100.04.51.09.5744 Total NAPA AUTO PARTS/ #26 & 27:61.98 NATL ASSC SCHOOL RES OFFICERS 67224/101017 1 Invoice SRO DUES NOWICKI 10/04/2017 10/10/2017 40.00 1017 100.02.20.01.5305 Total NATL ASSC SCHOOL RES OFFICERS :40.00 NAVIANT 0132602-IN 1 Invoice ONBASE CONVERSION 09/07/2017 10/10/2017 2,975.00 1017 209.01.00.00.6050 Total NAVIANT:2,975.00 NEOPOST USA INC 55175672 1 Invoice METER RENTAL 10/18-1/17/18 09/18/2017 10/10/2017 162.00 1017 100.01.06.00.5410 Total NEOPOST USA INC:162.00 NORTHERN LAKE SERVICE INC 122794 1 Invoice WTR TEST BACTERIA 09/25/2017 10/10/2017 20.00 1017 605.56.09.23.5865 Total NORTHERN LAKE SERVICE INC:20.00 ORG DEVELOPMENT CONSULTANTS 12068 1 Invoice FREGOSO PSYCH 09/29/2017 10/10/2017 675.00 1017 100.02.20.01.5845 Total ORG DEVELOPMENT CONSULTANTS:675.00 PARTSMASTER 23196578 1 Invoice SUPPLIES 09/20/2017 10/10/2017 390.16 1017 100.04.51.07.5704 Total PARTSMASTER:390.16 PAYNE & DOLAN OF WISCONSIN 1514161 1 Invoice ASPHALT 09/28/2017 10/10/2017 271.78 1017 100.04.51.02.5740 1514190 1 Invoice ASPHALT 09/28/2017 10/10/2017 267.85 1017 100.04.51.02.5740 Total PAYNE & DOLAN OF WISCONSIN:539.63 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 9 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number PENGUIN RANDOM HOUSE LLC 1083827146 1 Invoice AV 09/08/2017 10/10/2017 130.00 1017 100.05.71.02.5711 1083997409 1 Invoice AV 09/14/2017 10/10/2017 280.00 1017 100.05.71.02.5711 1084039310 1 Invoice AV 09/18/2017 10/10/2017 45.00 1017 100.05.71.02.5711 Total PENGUIN RANDOM HOUSE LLC:455.00 PIECHURA, JAMES PI101017-ENG 1 Invoice WATER MAIN EASEMENT 09/26/2017 10/10/2017 4,000.00 1017 507.00.00.00.2732 Total PIECHURA, JAMES:4,000.00 PINKY ELECTRIC INC. 2213 1 Invoice LIGHT POLE BALLASTS 09/22/2017 10/10/2017 1,260.00 1017 100.04.51.06.5916 2214 1 Invoice VETERAN PARK 09/22/2017 10/10/2017 300.00 1017 100.04.51.08.5415 2225 1 Invoice CCV LIFT STN WORK 10/03/2017 10/10/2017 3,055.00 1017 601.61.61.15.5415 Total PINKY ELECTRIC INC.:4,615.00 PIOTROSKI, CAROLYN PI101017-COU 1 Invoice WITNESS FEES 10/04/2017 10/10/2017 13.45 1017 100.01.08.00.6004 Total PIOTROSKI, CAROLYN:13.45 PORT-A-JOHN 0426669-IN 1 Invoice MAINTENANCE RANGE PORT-A-P 09/25/2017 10/10/2017 80.00 1017 100.02.20.01.6023 1277186-IN 1 Invoice RESTROOM PARK ARTHUR 09/22/2017 10/10/2017 70.00 1017 100.04.51.01.5820 Total PORT-A-JOHN:150.00 POSTMASTER OF MUSKEGO PO101017-FIN 1 Invoice RENEWAL FIRST CLASS PERMIT #09/20/2017 10/10/2017 225.00 1017 100.01.06.00.5710 Total POSTMASTER OF MUSKEGO:225.00 PROVEN POWER INC 02-245949 1 Invoice STARTER PART 09/18/2017 10/10/2017 14.40 1017 100.04.51.07.5405 02-246413 1 Invoice SUPPLIES 09/25/2017 10/10/2017 22.55 1017 100.04.51.07.5405 Total PROVEN POWER INC:36.95 PUBLIC SERVICE COMM OF WIS RA18-I-04005 1 Invoice PSC ASSESSMENT 09/28/2017 10/10/2017 2,025.79 1017 605.58.04.08.6701 Total PUBLIC SERVICE COMM OF WIS:2,025.79 QUICK SIGNS 46354 1 Invoice LITTLE MUSKEGO DRAWDOWN B 08/28/2017 10/10/2017 320.00 1017 507.00.00.00.2640 Total QUICK SIGNS:320.00 QUILL CORP 1007492 1 Invoice DRY ERASE MARKERS 09/20/2017 10/10/2017 8.29 1017 100.04.51.01.5701 13206 1 Invoice DRY ERASE 09/25/2017 10/10/2017 49.99 1017 100.04.51.01.5701 13660 1 Invoice OFFICE SUPPLIES 09/19/2017 10/10/2017 55.58 1017 100.04.51.01.5701 13893 1 Invoice PRESCHOOL CLASSROOM SUPPL 09/18/2017 10/10/2017 55.86 1017 100.05.72.16.5702 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 10 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total QUILL CORP:169.72 R.A. SMITH NATIONAL INC. 133052 1 Invoice NORTH CPE ROAD MULTI USE PA 09/19/2017 10/10/2017 79.17 1017 202.08.94.74.6573 133053 1 Invoice PARKLAND TOWNE CENTER CON 09/19/2017 10/10/2017 1,546.82 1017 507.00.00.00.2643 Total R.A. SMITH NATIONAL INC.:1,625.99 R.S. PAINT & TOOLS LLC 939667 2 Invoice MARKING PAINT BLUE 09/25/2017 10/10/2017 118.08 1017 605.54.06.41.5870 939667 4 Invoice MARKING PAINT PINK 09/25/2017 10/10/2017 118.08 1017 100.04.51.04.6026 939667 1 Invoice RAKES 24 9.89 09/25/2017 10/10/2017 237.36 1017 100.04.51.05.5704 939667 3 Invoice MARKING PAINT GREEN 09/25/2017 10/10/2017 157.44 1017 601.61.63.43.5801 939684 1 Invoice LIFT STN LOCKS AND KEYS 10/02/2017 10/10/2017 436.80 1017 601.61.61.15.5415 Total R.S. PAINT & TOOLS LLC:1,067.76 RED THE UNIFORM TAILOR 0W67327A 1 Invoice SANDRETTI UNIFORMS 09/14/2017 10/10/2017 111.96 1017 100.02.20.01.5151 0W67328A 1 Invoice WRENN UNIFORMS 09/14/2017 10/10/2017 170.91 1017 100.02.20.01.5151 Total RED THE UNIFORM TAILOR:282.87 ROZMAN TRUE VALUE/PD 23755/101017 1 Invoice STAPLES FOR RANGE 09/25/2017 10/10/2017 7.58 1017 100.02.20.01.6023 Total ROZMAN TRUE VALUE/PD:7.58 ROZMAN TRUE VALUE/PK & REC 23750/101017 1 Invoice PARK RANGER CLEANING SUPPLI 09/25/2017 10/10/2017 13.98 1017 100.05.72.19.5702 Total ROZMAN TRUE VALUE/PK & REC:13.98 ROZMAN TRUE VALUE/PW 22000/101017 2 Invoice MISC SUPPLIES BRUSH TROWEL 09/25/2017 10/10/2017 83.90 1017 100.04.51.07.5704 22000/101017 1 Invoice PARKDS SUPPLIES 09/25/2017 10/10/2017 145.49 1017 100.04.51.08.5415 Total ROZMAN TRUE VALUE/PW:229.39 ROZMAN TRUE VALUE/UT 25000/101017 1 Invoice ZIPLOC BAG 09/25/2017 10/10/2017 7.98 1017 605.54.06.41.5415 25000/101017 3 Invoice COPPER CAP 09/25/2017 10/10/2017 7.44 1017 601.61.61.12.5702 25000/101017 5 Invoice RESPIRATOR 09/25/2017 10/10/2017 13.99 1017 601.61.61.12.5702 25000/101017 7 Invoice SPR PAINT 09/25/2017 10/10/2017 5.99 1017 601.61.61.12.5702 25000/101017 9 Invoice FILTER CART 09/25/2017 10/10/2017 21.98 1017 601.61.61.15.5415 25000/101017 11 Invoice RUBBER BOOT IMP DRIVER 09/25/2017 10/10/2017 255.99 1017 601.61.61.12.5702 25000/101017 2 Invoice PIPE NIPPLE 09/25/2017 10/10/2017 44.94 1017 601.61.61.16.5411 25000/101017 4 Invoice LOCK KEY 09/25/2017 10/10/2017 3.96 1017 601.61.61.16.5411 25000/101017 6 Invoice IMP NUT SET 09/25/2017 10/10/2017 16.99 1017 601.61.61.12.5702 25000/101017 8 Invoice SPR PAINT 09/25/2017 10/10/2017 11.98 1017 601.61.61.12.5702 25000/101017 10 Invoice CUTT WHEEL 09/25/2017 10/10/2017 6.98 1017 601.61.61.12.5702 25000/101017 12 Invoice FILTER CART REFILLS 09/25/2017 10/10/2017 30.96 1017 601.61.61.15.5415 Total ROZMAN TRUE VALUE/UT:429.18 RUEKERT & MIELKE INC 120529 1 Invoice MIDDLE SCHOOL WATER EVALUA 09/22/2017 10/10/2017 180.00 1017 507.00.00.00.2733 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 11 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number 120530 1 Invoice TANK PAINTING ENGINEERING 09/22/2017 10/10/2017 1,400.28 1017 605.00.00.00.1941 120531 1 Invoice PAINTING TANK ENGINEERING 09/22/2017 10/10/2017 258.00 1017 605.00.00.00.1941 120533 1 Invoice FACILITIES THRU 9/1/17 09/22/2017 10/10/2017 2,977.00 1017 601.61.63.43.5815 120534 1 Invoice MISC ENG NEW 18TH WCA DISTRI 09/22/2017 10/10/2017 591.50 1017 605.56.09.23.5815 23063 1 Invoice SCADA MAINT 09/22/2017 10/10/2017 84.50 1017 601.61.63.42.5430 Total RUEKERT & MIELKE INC:5,491.28 SARTORIUS, JEFFREY JR. SA101017-PD 1 Invoice TRAINING MEALS 09/24/2017 10/10/2017 20.00 1017 100.02.20.01.5301 Total SARTORIUS, JEFFREY JR.:20.00 SCHMELING'S LANDSCAPE, LLC SC101017-PLA 1 Invoice PARK TREES 09/25/2017 10/10/2017 2,016.00 1017 202.08.94.74.6584 Total SCHMELING'S LANDSCAPE, LLC:2,016.00 SCHWEITZER, HARVEY SC101017-AD 1 Invoice LANDFILL MEETING 9/11/17 10/02/2017 10/10/2017 50.00 1017 207.01.00.00.6055 Total SCHWEITZER, HARVEY:50.00 SECURIAN FINANCIAL GROUP, INC. 002832L/10101 1 Invoice LIFE INSURANCE PREMIUMS - NO 10/05/2017 10/10/2017 2,834.41 1017 100.00.00.00.2207 Total SECURIAN FINANCIAL GROUP, INC.:2,834.41 SHERWIN-WILLIAMS CO. 5283-7 1 Invoice TRAFFIC PAINT 09/12/2017 10/10/2017 1,151.30 1017 100.04.51.02.5742 Total SHERWIN-WILLIAMS CO.:1,151.30 SHRED-IT USA 8123216887 1 Invoice MONTHLY SHRED AUGUST AND S 09/22/2017 10/10/2017 60.00 1017 100.02.20.01.5723 8123218293 1 Invoice PAPER SHREDDING 09/22/2017 10/10/2017 25.00 1017 100.01.06.00.5701 Total SHRED-IT USA:85.00 SLOCOMB, MARK SL101017-ADE 1 Invoice LANDFILL MEETING 9/11/17 10/02/2017 10/10/2017 50.00 1017 207.01.00.00.6055 Total SLOCOMB, MARK:50.00 SOMAR TEK LLC/ ENTERPRISES 100576 1 Invoice FTO BADGE CURRAN 09/20/2017 10/10/2017 16.40 1017 100.02.20.01.5151 100579 1 Invoice LED FLASH LIGHT 09/22/2017 10/10/2017 69.98 1017 100.04.51.02.5742 Total SOMAR TEK LLC/ ENTERPRISES:86.38 STREICHER'S I1281490 1 Invoice SQUAD BAG 09/26/2017 10/10/2017 29.99 1017 100.02.20.01.5151 Total STREICHER'S:29.99 SULLIVAN, TIM SU101017-PD 1 Invoice SULLIVAN TRAINING MEALS 09/21/2017 10/10/2017 30.00 1017 100.02.20.01.5301 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 12 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total SULLIVAN, TIM:30.00 SUPERIOR CHEMICAL 172495 1 Invoice 4 GAL CONCENTRATE 09/26/2017 10/10/2017 90.27 1017 100.04.51.08.5415 Total SUPERIOR CHEMICAL:90.27 TAPCO INC. I577832 1 Invoice PARKS LOCK BOXES (2) IDLE ISLE 09/15/2017 10/10/2017 18,430.00 1017 202.08.94.74.6579 I578093 1 Invoice MARKERS 09/18/2017 10/10/2017 523.28 1017 100.04.51.03.5704 Total TAPCO INC.:18,953.28 TESS CORNERS VOL FIRE DEPT TCVFD101017 1 Invoice QUARTERLY REVIEW FEES 10/04/2017 10/10/2017 765.00 1017 100.02.21.00.5850 Total TESS CORNERS VOL FIRE DEPT:765.00 THE BUGMAN/AQUAFIX INC 22532 1 Invoice GREASE ZILLA 09/27/2017 10/10/2017 3,702.18 1017 601.61.61.16.5426 Total THE BUGMAN/AQUAFIX INC:3,702.18 THE HAPPY MOWER 401-MUSKEG 1 Invoice MEDIANS, LIBRARY, CH, PD MOWI 10/02/2017 10/10/2017 6,928.57 1017 100.01.06.00.5820 Total THE HAPPY MOWER:6,928.57 TIME WARNER CABLE 701507601093 1 Invoice DEDICATED INTERNET CIRCUIT 09/30/2017 10/10/2017 1,045.00 1017 100.01.14.00.5507 703399401091 1 Invoice 911 CONNECTION 09/16/2017 10/10/2017 178.67 1017 100.02.20.10.5604 Total TIME WARNER CABLE:1,223.67 TRANSUNION RISK & ALTERNATIVE 911461/101017 1 Invoice REVERSE LOOK UP INVESTIGATI 10/01/2017 10/10/2017 34.20 1017 100.02.20.01.5722 Total TRANSUNION RISK & ALTERNATIVE:34.20 USA BLUE BOOK 363765 1 Invoice STENNER PUMP TUBE 09/11/2017 10/10/2017 280.46 1017 605.54.06.41.5702 375693 1 Invoice CHEMICALS WELL 2 09/25/2017 10/10/2017 55.12 1017 605.54.06.41.5702 Total USA BLUE BOOK:335.58 VERIZON WIRELESS 9792474746 2 Invoice MONTHLY GIS-TABLET 09/10/2017 10/10/2017 40.01 1017 100.01.14.00.5601 9792474746 1 Invoice MONTHLY CELL- PD 09/10/2017 10/10/2017 80.02 1017 100.02.20.01.5604 Total VERIZON WIRELESS:120.03 WAUKESHA COUNTY 00 4359 2 Invoice MNSD WATER MAIN AGREEMENT 10/02/2017 10/10/2017 30.00 1017 507.00.00.00.2733 00 4359 1 Invoice PINNACLE PEAK CUG DOC RECO 10/02/2017 10/10/2017 30.00 1017 507.00.00.00.2728 Total WAUKESHA COUNTY:60.00 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 13 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number WAUKESHA COUNTY TREASURER 2017-0000005 1 Invoice FALL FISHING FIESTA CLASS PAR 10/04/2017 10/10/2017 33.00 1017 100.05.72.18.5702 WA101017 1 Invoice JAIL ASSESSMENTS/SEPT 09/29/2017 10/10/2017 1,259.80 1017 100.01.08.00.4269 WA101017 3 Invoice INTERLOCK SURCHARGE/SEPT 09/29/2017 10/10/2017 50.00 1017 100.01.08.00.4269 WA101017 2 Invoice DRIVER SURCHARGE/SEPT 09/29/2017 10/10/2017 499.40 1017 100.01.08.00.4269 WA101017(1)2 Invoice DRIVER SURCHARGE/AUG 08/31/2017 10/10/2017 1,251.00 1017 100.01.08.00.4269 WA101017(1)1 Invoice JAIL ASSESSMENTS/AUG 08/31/2017 10/10/2017 1,400.00 1017 100.01.08.00.4269 WA101017(1)3 Invoice INTERLOCK SURCHARGE/AUG 08/31/2017 10/10/2017 143.00 1017 100.01.08.00.4269 Total WAUKESHA COUNTY TREASURER:4,636.20 WE ENERGIES 0000-020-164/2 Invoice CITY GROUP BILL - POLICE DEPT 09/21/2017 10/10/2017 2,646.12 1017 100.02.20.01.5910 0000-020-164/4 Invoice CITY GROUP BILL - SALT SHED 09/21/2017 10/10/2017 21.68 1017 100.04.51.06.5910 0000-020-164/6 Invoice CITY GROUP BILL - LITTLE LAKE D 09/21/2017 10/10/2017 24.18 1017 100.04.51.08.5910 0000-020-164/8 Invoice CITY GROUP BILL - SEWER 25%09/21/2017 10/10/2017 338.27 1017 601.61.61.20.5910 0000-020-164/10 Invoice CITY GROUP BILL - PARKS 09/21/2017 10/10/2017 501.91 1017 100.04.51.08.5910 0000-020-164/12 Invoice CITY GROUP BILL - COMMERCE C 09/21/2017 10/10/2017 16.38 1017 100.04.51.08.5910 0000-020-164/1 Invoice CITY GROUP BILL - CITY HALL 09/21/2017 10/10/2017 3,019.73 1017 100.01.09.00.5910 0000-020-164/3 Invoice CITY GROUP BILL - STREET LIGH 09/21/2017 10/10/2017 4,225.21 1017 100.04.51.06.5910 0000-020-164/5 Invoice CITY GROUP BILL - IND PARK LIG 09/21/2017 10/10/2017 452.81 1017 100.04.51.06.5910 0000-020-164/7 Invoice CITY GROUP BILL - GARAGE 50%09/21/2017 10/10/2017 676.54 1017 100.04.51.08.5910 0000-020-164/9 Invoice CITY GROUP BILL - WATER 25%09/21/2017 10/10/2017 338.26 1017 605.56.09.21.5910 0000-020-164/11 Invoice CITY GROUP BILL - PARKS GARA 09/21/2017 10/10/2017 51.35 1017 100.04.51.08.5910 0000-020-351/1 Invoice AUG 2017 09/27/2017 10/10/2017 9,885.85 1017 605.52.06.22.5910 0000-021-027/1 Invoice 8/17 LIFT STNS 09/21/2017 10/10/2017 5,794.81 1017 601.61.61.20.5910 0000-021-134/1 Invoice GROUP BILL - CITY HALL 09/21/2017 10/10/2017 102.48 1017 100.01.09.00.5910 0000-021-134/3 Invoice GROUP BILL - GARAGE 50%09/21/2017 10/10/2017 13.11 1017 100.04.51.08.5910 0000-021-134/5 Invoice GROUP BILL - WATER 25%09/21/2017 10/10/2017 6.55 1017 605.56.09.21.5910 0000-021-134/7 Invoice GROUP BILL - PARKS GARAGE 09/21/2017 10/10/2017 9.57 1017 100.04.51.08.5910 0000-021-134/2 Invoice GROUP BILL - PD 09/21/2017 10/10/2017 44.31 1017 100.02.20.01.5910 0000-021-134/4 Invoice GROUP BILL - SEWER 25%09/21/2017 10/10/2017 6.56 1017 601.61.61.20.5910 0000-021-134/6 Invoice GROUP BILL - PARKS 09/21/2017 10/10/2017 194.17 1017 100.04.51.08.5910 2014-674-485/1 Invoice WE ENERGIES 09/20/2017 10/10/2017 65.31 1017 100.02.20.01.6023 5499-564-961/1 Invoice LIBRARY - GAS 09/28/2017 10/10/2017 777.63 1017 100.05.71.00.5910 5499-564-961/3 Invoice HISTORICAL SOCIETY 09/28/2017 10/10/2017 251.81 1017 100.05.72.03.5910 5499-564-961/5 Invoice VETERANS PARK ARCH 09/28/2017 10/10/2017 19.34 1017 100.04.51.08.5910 5499-564-961/7 Invoice PAVILION 09/28/2017 10/10/2017 120.60 1017 100.04.51.08.5910 5499-564-961/9 Invoice VETERANS PARK LIGHTS 09/28/2017 10/10/2017 124.77 1017 100.04.51.08.5910 5499-564-961/2 Invoice LIBRARY - ELECTRIC 09/28/2017 10/10/2017 5,539.87 1017 100.05.71.00.5910 5499-564-961/4 Invoice HISTORICAL SOCIETY POLE LIGH 09/28/2017 10/10/2017 13.42 1017 100.04.51.08.5910 5499-564-961/6 Invoice VETERANS PARK FOUNTAIN 09/28/2017 10/10/2017 95.18 1017 100.04.51.08.5910 5499-564-961/8 Invoice AREA LIGHTS 09/28/2017 10/10/2017 113.70 1017 100.04.51.08.5910 WE101017-EN 1 Invoice CITY HALL NEW ELECTRIC INSTA 09/27/2017 10/10/2017 36,173.99 1017 401.08.90.09.6550 Total WE ENERGIES:71,665.47 WESTERN CULVERT & SUPPLY INC 054098 1 Invoice BANDS 09/22/2017 10/10/2017 116.10 1017 100.04.51.04.5745 Total WESTERN CULVERT & SUPPLY INC:116.10 WILEAG WI101017-REN 1 Invoice ACCREDITATION 09/30/2017 10/10/2017 622.43 1017 100.02.20.01.5722 Total WILEAG:622.43 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 14 Report dates: 9/27/2017-10/10/2017 Oct 06, 2017 09:51AM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number WINDSTREAM 69293953 1 Invoice LONG DISTANCE 09/04/2017 10/10/2017 1,112.22 1017 100.01.06.00.5601 Total WINDSTREAM:1,112.22 WISCONSIN BUILDING INSPECTION, LLP 156 1 Invoice SEPTEMBER PERMITS 10/02/2017 10/10/2017 33,179.82 1017 100.02.25.00.5820 Total WISCONSIN BUILDING INSPECTION, LLP:33,179.82 WISCONSIN DEPT OF ADMIN COURT FEES 1 Invoice COURT FEES/SEPT 09/29/2017 10/10/2017 6,278.68 1017 100.01.08.00.4269 Total WISCONSIN DEPT OF ADMIN:6,278.68 WISCONSIN DEPT OF JUSTICE - CIB L6806T/10101 1 Invoice RECORD NAME SEARCHES 09/30/2017 10/10/2017 287.00 1017 100.01.06.00.6002 Total WISCONSIN DEPT OF JUSTICE - CIB:287.00 WMCA HMNR9K5G3V 1 Invoice WMCA DISTRICT 5 MEETING - SH 09/21/2017 10/10/2017 30.00 1017 100.01.03.00.5303 MZNLW3FQM 1 Invoice WMCA DISTRICT MEETING - KIM 09/20/2017 10/10/2017 30.00 1017 100.01.03.00.5303 ZKNLY84NFF6 1 Invoice WMCA DISTRICT 5 MEETING - JEN 09/26/2017 10/10/2017 30.00 1017 100.01.03.00.5303 Total WMCA :90.00 ZIMMERMAN ARCHITECTURAL STUDIOS 57117 1 Invoice POLICE DEPARTMENT DESIGN 09/26/2017 10/10/2017 5,763.66 1017 410.08.91.20.6550 57118 1 Invoice CITY HALL CONTSTRUCTION ADM 09/26/2017 10/10/2017 4,273.76 1017 401.08.90.09.6550 57119 1 Invoice PUBLIC WORKS DESIGN 09/26/2017 10/10/2017 6,723.81 1017 410.08.93.51.6550 Total ZIMMERMAN ARCHITECTURAL STUDIOS:16,761.23 Grand Totals: 454,757.06 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 October 10th, 2017, Finance Committee Meeting Major Projects and Activities being worked on within the Finance & Administration Department: Elections –The upcoming 2018 elections and offices on the ballot will include the following: February 20th Spring Primary – State Circuit Court of Appeals; State Circuit Court Judge April 3rd Spring – State Circuit Court of Appeals; State Circuit Court Judge; Muskego Aldermanic Districts #1, #3 & #5; School Board 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 Tax Roll/Rates/Bills – Final settlement with Waukesha County was reconciled and balanced on August 15th. 2016 Audit (Operating, Special Revenue, Capital, BML, Sewer & Water Utility) – As reported in the first quarter, field work began on May 1st and was completed by May 5th. First draft financial statements and the Management Discussion and Analysis (MD&A) were prepared in-house and finalized on July 13th. The audit presentation took place at the September 26th Finance Committee meeting. All City Funds reported positive results, including continued movement toward working capital recovery within the Water Utility. The Audit Report to the Mayor and Finance Committee is attached. Budgets – The 2018 Capital Budget and 5-Year Summary was distributed on August 18th for discussion at the August 22nd COW meeting. The Proposed 2018 Operating Budget, which includes general operations, debt service and special revenue was reviewed at the September 21st COW meeting and includes a tax levy increase of $205,000 in order to fund new positions in the departments of Public Safety and Public Works. Due to the assessment revaluation, the City tax rate is expected to decrease by $0.46 or 9.48%. Continued budget discussions, including review of the Water and Sewer Utility budgets, will take place at the October 10th meeting. All budgets have been based on goals which were set by the Committee of the Whole on June 27th. Payroll/Benefit Administration – 2nd Quarter Federal and State payroll tax reports reconciled and submitted to the IRS and DOR on July 21st. The City Wellness Program Health Risk Assessment took place the third week in May. Total employee participation was 99%. Final assessment reports have continued positive trend results. Health insurance rate renewal negotiations resulted in no increase to the current premiums. Various health insurance options were reviewed by the Committee of the Whole, with a consensus for benefits to remain status quo until the 2019 budget process. Investments – Interest earnings are holding steady with only a slight increase in rates to report. FINANCE & ADMIN. DIRECTOR’S REPORT 10/10/17 PAGE 2 2 Debt Issuance – Options for financing future capital projects were discussed at the September 21st and 26th COW meetings. Anticipated debt issuance will finance three facility projects, three road improvement projects and Volunteer Fire equipment in the amount of approximately $18 million. The Committee agreed issuing a Note Anticipation Note (NAN) in 2017 and refunding in late 2018 would be the most cost effective option as compared to issuing general obligation bonds. The recommendation will be brought before the Finance Committee and Common Council in mid to late November. 2nd Quarter Utility Bills – Billings and collections processed in a timely manner with no issues to report. Licensing – Various licenses and permits, including liquor and fireworks, were all processed and issued on a timely basis. Board of Review – The first meeting to consider filed objections took place on July 27th, resulting in an overall property assessment valuation adjustment of $572,200. The change in value was recorded with the County and reflected in the Statement of Assessment which was filed with the State on August 4th. Other Projects – Continued progression within the following applications: Document Management/Work Flow – Accounts Payable work flow went live on September 20th; initial meetings have been held for implementation of the Agenda Management project. 2nd Quarter, 2017 General Fund Operating Results – See attached. As reported, the year-to-date expenditures are under budget by (-) 57.08% which is a decrease of 0.09% or $122,578 over the prior year. The reduction is contributed to the 2016 authorized budget transfer of $213,610 to the Capital Expenditure fund which resulted from additional Transportation Aids. Overall results continue to reflect a ‘leveling- off’ of the saving recognized from past departmental consolidations and contracted services. As compared to the prior year, second quarter revenues over expenditures resulted in an increase of $297,434. Please note second quarter account activity is significantly under budget either due to the timing of funds received or project status; such as the road program, vehicle replacements and water tax equivalent. Current projections continue to indicate positive results. Please email or contact me at (262) 679-5622 with any questions. Thank you. June 30, 2017 Budget Actual Over/(Under) % Over/(Under)Revenue Comparison Taxes $10,358,898 $10,359,434 $536 0.01% Intergovernmental $1,797,733 $726,437 -$1,071,296 -59.59% Licenses and Permits $769,470 $437,403 -$332,067 -43.16% Fines, Forfeits and Penalties $299,000 $186,050 -$112,950 -37.78% Public Charges for Services $722,755 $514,245 -$208,510 -28.85% Intergov. Charges for Services $149,000 $75,506 -$73,494 -49.33% Miscellaneous $278,890 $189,679 -$89,211 -31.99% Other Financing Sources $575,000 $0 -$575,000 -100.00% Interdepartmental $105,004 $44,939 -$60,066 -57.20% Total Revenue $15,055,750 $12,533,691 ($2,522,059) -16.75% 2017 Budget Quarter 2 Results: REVENUES General Fund - Annual Operating Results 83% 6% 3% 1%4% 1% 2% 0% 0% Taxes Intergovernmental Licenses and Permits Fines, Forfeits and Penalties Public Charges for Services Intergov. Charges for Services Miscellaneous Other Financing Sources Interdepartmental June 30, 2017 General Government Budget Actual Over/(Under) % Over/(Under)Actual Cost Breakdown Common Council/Mayor $204,438 $99,106 -$105,332 -51.52% Finance & Administration $578,932 $257,574 -$321,358 -55.51% Assessor $169,625 $80,838 -$88,787 -52.34% Attorney $113,149 $49,898 -$63,251 -55.90% Non-Departmental $591,660 $368,676 -$222,984 -37.69% Municipal Court $214,379 $98,077 -$116,302 -54.25% Building Maintenance $190,652 $82,764 -$107,888 -56.59% Information Technology $358,737 $131,058 -$227,679 -63.47% Bank Service Charges $19,000 $5,850 -$13,150 -69.21% Total $2,440,572 $1,173,842 -$1,266,730 -51.90% Public Safety Budget Actual Over/(Under) % Over/(Under) Police - Sworn Officers $4,787,265 $2,284,546 -$2,502,719 -52.28% Police - Dispatch & Clerical $684,170 $317,384 -$366,786 -53.61% Volunteer Fire $794,313 $232,500 -$561,813 -70.73% Non-Departmental $20,910 $19,910 -$1,000 -4.78% Building Inspection $279,867 $140,390 -$139,477 -49.84% Total $6,566,525 $2,994,730 -$3,571,795 -54.39% Health & Human Services Budget Actual Over/(Under) % Over/(Under) Animal Warden $3,600 $3,581 -$19 -0.53% Public Safety Supplies & Expenses $50 $75 $25 50.84% Total $3,650 $3,656 $6 0.18% Public Works Budget Actual Over/(Under) % Over/(Under)Budget vs. Actual Engineering $176,564 $72,683 -$103,881 -58.83% Public Works $2,423,647 $1,121,528 -$1,302,119 -53.73% Total $2,600,211 $1,194,211 -$1,406,000 -54.07% Culture, Recreation & Education Budget Actual Over/(Under) % Over/(Under) Parade Fund & Little Lake District $59,000 $9,715 -$49,285 -83.53% Library $1,206,056 $560,690 -$645,366 -53.51% Parks $30,655 $6,590 -$24,065 -78.50% Recreation $564,133 $195,061 -$369,072 -65.42% Total $1,859,844 $772,056 -$1,087,788 -58.49% Conservation & Development Budget Actual Over/(Under) % Over/(Under) Planning, Conservation & Development $422,946 $160,879 -$262,068 -61.96% Total $422,946 $160,879 -$262,068 -61.96% Capital Outlay-Operations Budget Actual Over/(Under) % Over/(Under) Computer Replacements $18,000 $10,698 -$7,302 -40.57% 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 $90,535 -$12,466 -12.10% Road Program $725,000 $10,056 -$714,944 -98.61% 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 $40,000 $0 0.00% Total $1,162,000 $162,039 -$999,961 -86.06% Total Expenditures Budget Actual Over/(Under) % Over/(Under) $15,055,750 $6,461,413 ($8,594,336)-57.08% 2017 Budget Quarter 2 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 18% 46% 0% 18% 12%3%3% General Government Public Safety Health & Human Services Public Works Culture, Recreation & Education Conservation & Development Capital Outlay-Operations June 30, 2017 2017 2016 Comparison Revenues vs. Expenditures Total Revenues $12,533,691 $12,358,835 $174,856 Total Expenditures $6,461,413 $6,583,992 ($122,578) Total Surplus/(Deficit) $6,072,278 $5,774,843 $297,434 General Fund - Annual Operating Results Quarter 2 Budget Results - 2017 vs. 2016 $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 2017 2016 CITY OF MUSKEGO September 26, 2017 Presented By: Wendi Unger, CPA, Partner REPORT TO THE MAYOR AND FINANCE COMMITTEE 777 E Wisconsin Ave 32nd Floor Milwaukee, WI 53202 414 777 5500 © 2017 Baker Tilly Virchow Krause, LLP Actual data was derived from current and prior years audited financial statements Tim Sowinski, Senior Accountant Baker Tilly Virchow Krause, LLP This communication is intended solely for the information and use of management, the Common Council and others within the organization, and is not intended to be, and should not be, used by anyone other than the specified parties. Nonspendable 2016 includes fund balance amounts that cannot be spent either because they are not in spendable form or because legal or contractual requirements require them to be maintained intact.14,684$ Unassigned includes residual positive fund balance within the general fund which has not been classified within the other above mentioned categories. 5,387,739 Total General Fund Balance 5,402,423$ CITY OF MUSKEGO 2016 FINANCIAL STATEMENT HIGHLIGHTS DETAILS OF GENERAL FUND BALANCE Nonspendable 1% Unassigned 99% General Fund Balance Nonspendable Unassigned © 2016 Baker Tilly Virchow Krause, LLP Page 1 2012 2013 2014 2015 2016 Unrestricted Fund Balance 3,375,795$ 3,348,747$ 3,739,227$ 4,449,520$ 5,387,739$ Expenditures 13,421,729 13,977,468 14,024,488 13,896,155 13,845,483 % of expenditures 25.15% 23.96% 26.66% 32.02% 38.91% GFOA recommended range for % of expenditures:no less than 2 months of regular GF operating expenditures Acceptable range per city policy:10-17% Reference values for the population range: 17,500 to 30,000 generated from 2012-2015 Baker Tilly municipal client data for Wisconsin. CITY OF MUSKEGO 2016 FINANCIAL STATEMENT HIGHLIGHTS ANALYSIS OF GENERAL FUND BALANCE 25.15% 23.96% 26.66%32.02% 38.91% 31.22%32.58% 30.15% 32.20% 15.00% 20.00% 25.00% 30.00% 35.00% 40.00% 45.00% 2012 2013 2014 2015 2016 Unreserved or Unrestricted General Fund Balance as a Percentage of Expenditures General Fund Actual GFOA recommended minimum Reference - Median © 2016 Baker Tilly Virchow Krause, LLP Page 2 2012 %2013 %2014 %2015 %2016 % Total Revenues Taxes 12,028,504$ 78% 12,083,616$ 77% 12,184,478$ 76% 12,270,896$ 76% 12,383,443$ 74% Intergovernmental 1,442,397 9% 1,686,727 11% 1,685,174 11% 1,692,627 10% 1,828,955 11% Licenses and permits 641,700 4% 667,083 4% 801,469 5% 762,419 5% 777,658 5% Fines, forfeitures, and penalties 173,709 1% 204,460 1% 210,838 1% 235,358 1% 362,029 2% Public Charges for Services 673,308 4% 667,585 4% 671,782 4% 697,355 4% 773,302 5% Commercial revenue 136,589 1% 193,750 1% 202,055 1% 261,929 2% 272,052 2% Intergovernmental charges for services 195,122 1% 136,960 1% 145,526 1% 149,077 1% 150,121 1% Interdepartmental revenues 77,694 1% 83,596 1% 73,880 0% 73,555 0% 90,673 0% TOTAL 15,369,023$ 100% 15,723,777$ 100% 15,975,202$ 100% 16,143,216$ 100% 16,638,233$ 100% CITY OF MUSKEGO 2016 FINANCIAL STATEMENT HIGHLIGHTS GENERAL & DEBT SERVICE FUND REVENUES $- $2 $4 $6 $8 $10 $12 $14 2012 2013 2014 2015 2016 Mi l l i o n s Total Revenue Taxes Intergovernmental Regulation & Compliance Special Assessments Public Charges for Services Investment Income & Miscellaneous 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 2012 2013 2014 2015 2016 % of Total Revenue © 2016 Baker Tilly Virchow Krause, LLP Page 1 Page 3 CITY OF MUSKEGO 2016 FINANCIAL STATEMENT HIGHLIGHTS 2016 GENERAL & DEBT SERVICE FUND REVENUES Total Revenues: $16,638,233 Taxes 74% Intergovernmental 11% Licenses and permits 5% Fines, forfeitures, and penalties 2%Public Charges for Services 5% Investment Income & Miscellaneous 2% Intergovernmental charges for services 1% Interdepartmental revenues 0%Taxes Intergovernmental Licenses and permits Fines, forfeitures, and penalties Public Charges for Services Commercial revenue Intergovernmental charges for services Interdepartmental revenues © 2016 Baker Tilly Virchow Krause, LLP Page 3 Page 4 2012 %2013 %2014 %2015 %2016 % Total Expenditures General Government 2,076,953$ 13% 2,241,931$ 13% 2,210,070$ 13% 2,094,068$ 12% 2,069,393$ 12% Public Safety 5,961,986 37% 6,112,807 34% 6,030,826 35% 6,026,425 35% 6,166,166 36% Public Works 1,835,233 11% 2,159,467 12% 2,200,192 13% 2,574,786 15% 2,489,391 15% Health and sanitation 3,610 0% 3,605 0% 3,595 0% 3,675 0% 3,618 0% Conservation and development 266,592 2% 295,021 2% 323,638 2% 338,990 2% 371,222 2% Education and recreation 2,102,178 13% 2,247,413 13% 2,326,268 14% 1,823,081 11% 1,758,399 10% Debt Service 2,771,384 17% 3,828,891 22% 3,012,567 18% 3,118,826 18% 3,066,825 18% Capital Outlay 1,175,177 7% 917,224 5% 929,899 5% 1,035,130 6% 987,294 6% TOTAL 16,193,113$ 100% 17,806,359$ 100% 17,037,055$ 100% 17,014,981$ 100% 16,912,308$ 100% **Excludes debt refunding CITY OF MUSKEGO 2016 FINANCIAL STATEMENT HIGHLIGHTS GENERAL & DEBT SERVICE FUND EXPENDITURES $- $1 $2 $3 $4 $5 $6 $7 2012 2013 2014 2015 2016 Mi l l i o n s Total Expenditures General Government Public Safety Public Works Parks, Rec. & Education Debt Service** Capital Outlay 0% 5% 10% 15% 20% 25% 30% 35% 40% 2012 2013 2014 2015 2016 % of Total Expenditures © 2016 Baker Tilly Virchow Krause, LLP Page 4 Page 5 **Excludes debt refunding Total Expenditures: $16,912,308 CITY OF MUSKEGO 2016 FINANCIAL STATEMENT HIGHLIGHTS 2016 GENERAL & DEBT SERVICE FUND EXPENDITURES General Government 12% Public Safety 37%Public Works 15% Health and sanitation 0% Conservation and development 2% Education and recreation 10% Debt Service 18% Capital Outlay 6% General Government Public Safety Public Works Health and sanitation Conservation and development Education and recreation Debt Service Capital Outlay © 2016 Baker Tilly Virchow Krause, LLP Page 6 Page 6 2012 2013 2014 2015 2016 Total General Obligation (G.O.) Debt (net) City 32,334,940$ 31,077,425$ 29,130,092$ 26,938,162$ 33,484,259$ Utilities 1,565,060 1,462,575 1,350,990 1,308,409 1,272,802 Subtotal 33,900,000 32,540,000 30,481,082 28,246,571 34,757,061 Less: Fund equity available for debt (2,974,793) (2,757,268) (2,566,729) (2,603,811) (2,689,262) TOTAL 30,925,207$ 29,782,732$ 27,914,353$ 25,642,760$ 32,067,799$ Population 24,407 24,239 24,621 24,621 24,882 G.O. Debt Capacity $128,300,000 $126,700,000 $132,200,000 $135,300,000 138,300,000$ G.O. debt per capita $1,267 $1,229 $1,134 $1,041 1,289$ % of debt limit 24% 24% 21% 19% 23% 2012-2014 Reference values for the population range: 17,500 to 30,000 taken from MunicpalFacts16 publication by the Wisconsin Taxpayers Alliance, 2016. CITY OF MUSKEGO 2016 FINANCIAL STATEMENT HIGHLIGHTS GENERAL OBLIGATION DEBT OUSTANDING 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 2012 2013 2014 2015 2016 Percentage of Debt Limit ReferenceͲ High ReferenceͲ Median ReferenceͲ Low Cityof Muskego $0 $1,000 $2,000 $3,000 $4,000 $5,000 $6,000 2012 2013 2014 2015 2016 G.O. Debt Outstanding - Per Capita © 2016 Baker Tilly Virchow Krause, LLP Page 1 Page 7 2012 2013 2014 2015 2016 Total Debt Service Principal 1,634,300$ 2,697,515$ 2,023,415$ 2,117,616$ 2,128,903$ Interest 1,137,084 1,131,376 989,152 1,001,210 937,922 TOTAL 2,771,384$ 3,828,891$ 3,012,567$ 3,118,826$ 3,066,825$ Total Non-Capital Expenditures Total governmental funds expenditures 24,252,650$ 25,879,673$ 22,911,715$ 21,717,680$ 23,481,799$ Less: capital outlay (7,492,293) (6,782,606) (4,733,551) (3,952,794) (4,455,287) TOTAL NON-CAPITAL EXPENDITURES 16,760,357$ 19,097,067$ 18,178,164$ 17,764,886$ 19,026,512$ % of debt service to non-capital expenditures 16.54% 20.05% 16.57% 17.56% 16.12% 2012 2013 2014 2015 Bond rating agencies recommended %20.00% 20.00% 20.00% 20.00% High - Reference:54.97% 63.06% 58.78% 59.17% Median - Reference:21.29% 29.88% 18.80% 20.67% Low - Reference:12.25% 12.06% 15.94% 4.23% Reference values for the population range: 17,500 to 30,000 generated from 2012-2015 Baker Tilly municipal client data for Wisconsin. 2016 FINANCIAL STATEMENT HIGHLIGHTS ANALYSIS OF DEBT SERVICE - GOVERNMENTAL FUNDS CITY OF MUSKEGO 16.54%20.05%16.57%17.56%16.12% 54.97% 63.06% 58.78%59.17% 21.29% 29.88% 18.80%20.67% 12.25%12.06% 15.94% 4.23%0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00% 70.00% 2012 2013 2014 2015 2016 Debt Service to Non-Capital Expenditures City of Muskego Bond Rating Agencies Recommendation Reference - High Reference - Median Reference - Low © 2016 Baker Tilly Virchow Krause, LLP Page 2 Page 8 2012 %2013 %2014 %2015 %2016 % Gallons Sold (000's) Residential 240,785$ 74% 205,945$ 72% 199,105$ 71% 203,123$ 70% 221,698$ 72% Commercial 50,808 16% 48,195 17% 47,923 17% 52,352 18% 53,995 17% Industrial 17,939 5% 20,060 7% 23,268 8% 23,499 8% 22,960 7% Public authority 17,209 5% 11,226 4% 10,761 4% 11,314 4% 11,083 4% TOTAL 326,741 100% 285,426 100% 281,057 100% 290,288 100% 309,736 100% Operating Revenues 1,991,212$ 1,878,055$ 1,889,769$ 1,982,037$ 2,081,319$ Operating Expenses 1,417,379 1,511,538 1,578,264 1,508,894 1,596,996 What it means… CITY OF MUSKEGO WATER UTILITY 2016 FINANCIAL STATEMENT HIGHLIGHTS ANALYSIS OF INCOME STATEMENT The water industry trend has reflected continual decrease in overall usage due to conservation and economic reasons. Because providing quality water is a highly capital intensive industry, declining sales makes monitoring the ongoing adequacy of rates more important. $- $50,000 $100,000 $150,000 $200,000 $250,000 $300,000 Residential Commercial Industrial Public authority Comparison of Gallons Sold (000's) 2012 2013 2014 2015 2016 $- $1 $1 $2 $2 $3 2012 2013 2014 2015 2016 Mi l l i o n s Water Utility - Operations Operating revenues Operating Expenses © 2016 Baker Tilly Virchow Krause, LLP Page 1Page 9 2012 2013 2014 2015 2016 Operating Income Financial statement 1 573,833$ 366,517$ 311,505$ 473,143$ 484,323$ PSC reporting 480,680 267,891 260,571 451,355 487,825 Rate of Return Actual rate 5.75% 3.25% 3.11% 5.27% 5.74% Authorized rate 7.00% 7.00% 7.00% 7.00% 7.00% What it means… 1 Financial statement operating income excludes PILOT but includes depreciation on contributed plant. PSC operating income includes PILOT but excludes depreciation on contributed plant. ANALYSIS OF INCOME STATEMENT (cont.) Rate of return is a key indicator of financial results in any regulated utility like your water utility. Rate of return is calculated based on the PSC formula. The formula is based on the utility's PSC reporting operating income divided by investment in plant in service, less plant that was contributed to the utility, less accumulated depreciation. CITY OF MUSKEGO WATER UTILITY 2016 FINANCIAL STATEMENT HIGHLIGHTS 5.75% 3.25% 3.11% 5.27% 5.74% 0.00% 1.00% 2.00% 3.00% 4.00% 5.00% 6.00% 7.00% 8.00% 2012 2013 2014 2015 2016 Water Utility Rate of Return Actual rate Authorized rate © 2016 Baker Tilly Virchow Krause, LLP Page 2Page 10 2012 2013 2014 2015 2016 Ability to meet current obligations Unrestricted cash & investments 78,044$ 9,635$ -$ 10,891$ 266,324$ Months of unrestricted cash 0.47 0.06 - 0.07 1.54 What it means… CITY OF MUSKEGO WATER UTILITY 2016 FINANCIAL STATEMENT HIGHLIGHTS ANALYSIS OF STATEMENT OF NET POSITION A utility should have enough funds on hand to cover its operations in a normal business operation cycle (i.e. quarterly, monthly) plus a contingency. In addition, a utility should have available an amount equal to one year's routine capital improvements. Ͳ 1 1 2 2 3 3 4 2012 2013 2014 2015 2016 Unrestricted Funds on Hand Actual Minimumtarget (3months) © 2016 Baker Tilly Virchow Krause, LLP Page 3Page 11 2012 2013 2014 2015 2016 Operating Revenues 6,001,364$ 6,041,785$ 6,066,555$ 6,102,976$ 6,183,279$ Operating Expenses 6,370,495 6,734,434 6,716,984 7,240,000 7,390,295 Note: Depreciation expense 1,095,057 1,116,768 1,086,912 1,055,855 1,061,226 What it means… CITY OF MUSKEGO SEWER UTILITY 2016 FINANCIAL STATEMENT HIGHLIGHTS ANALYSIS OF INCOME STATEMENT Operating income is an indicator of the financial health of a sewer utility, but it can be misleading. Operating expenses include depreciation. Since sewer rates are generally based on cash flow needs, depreciation may not be fully recovered through rates. Therefore, the importance of this metric is the trend. $- $1 $2 $3 $4 $5 $6 $7 $8 2012 2013 2014 2015 2016 Mi l l i o n s Sewer Utility - Operations Operating revenues Operating expenses © 2016 Baker Tilly Virchow Krause, LLP Page 4Page 12 2012 2013 2014 2015 2016 Ability to meet current obligations Unrestricted cash & investments 9,032,981$ 9,082,318$ 7,468,199$ 7,016,288$ 6,932,755$ Months of unrestricted cash 18.06 18.04 14.77 13.80 13.45 What it means… 2016 FINANCIAL STATEMENT HIGHLIGHTS ANALYSIS OF STATEMENT OF NET POSITION A utility should have enough funds on hand to cover its operations in a normal business operation cycle (i.e. quarterly, monthly) plus a contingency. In addition, a utility should have available an amount equal to one year's routine capital improvements. CITY OF MUSKEGO SEWER UTILITY Ͳ 2 4 6 8 10 12 14 16 18 20 2012 2013 2014 2015 2016 Unrestricted Funds on Hand Actual Minimumtarget (3months) © 2016 Baker Tilly Virchow Krause, LLP Page 5Page 13