Loading...
FINANCE COMMITTEE Packet - 12/13/2016 *Time Amended **Amended CITY OF MUSKEGO FINANCE COMMITTEE AGENDA December 13, 2016 6:15 PM * City Hall, W182 S8200 Racine Avenue CALL TO ORDER PLEDGE OF ALLEGIANCE ROLL CALL PUBLIC MEETING NOTICE APPROVAL OF MINUTES - November 22, 2016 LICENSE APPROVALS 1. Approval of Taxi Driver Licenses - Muskego Senior Taxi Service 2. Recommend Approval of Operator Licenses 3. Recommend Approval of Temporary License for the Sale of Fermented Malt Beverages and Wine - Special Olympics Wisconsin for the Muskeg Polar Plunge - February 12, 2017 NEW BUSINESS 1. Recommendation to Authorize Naviant Statement of Work Agreement 2. Approve Additional Funding for Enforcing Overweight Truck Restrictions 3. Recommend Approval of Municipal Engineering Services Master Agreement with GRAEF-USA, Inc. 4. **Recommend Dedication and Acceptance of Public Improvements in and for Parkland Towne Center VOUCHER APPROVAL 1. Utility Vouchers 2. General Fund Vouchers 3. Wire Transfers for Payroll/Invoice Transmittals FINANCE DIRECTOR’S REPORT 1. Finance & Administration Department Third Quarter Report COMMUNICATIONS AND ANY OTHER BUSINESS AS AUTHORIZED BY LAW Finance Committee Agenda 2 December 13, 2016 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 November 22, 2016 6:50 PM City Hall, W182 S8200 Racine Avenue CALL TO ORDER Mayor Chiaverotti called the meeting to order at 6:50 p.m. PLEDGE OF ALLEGIANCE Those present recited the Pledge of Allegiance. ROLL CALL Present: Committee Members Aldermen Wolfe (arrived just after call to order), Engelhardt and Madden. Also present: Aldermen Hammel, Kapusta and Kubacki as well as City Attorney Warchol and Deputy Clerk Blenski. PUBLIC MEETING NOTICE The Deputy Clerk stated that the meeting was noticed in accordance with the open meeting law. APPROVAL OF MINUTES - October 25 and November 2, 2016 Alderman Engelhardt made a motion to approve. Alderman Madden seconded motion carried. LICENSE APPROVALS Approval of Taxi Driver Licenses - Muskego Senior Taxi Service Alderman Madden made a motion to approve licenses for Rebecca Dublinski, Michael Ensley, Karin Geier-Nickel, Michael Gorski, Patricia Greenlees, James Haack, Kathy Kalashian, Gary Kulas, Michael Manthy, Sandra Ortega, Arthur Sprague, Lynn Ussel and Ann Wissing. Alderman Engelhardt seconded; motion carried. Recommend Approval of Operator Licenses Alderman Madden made a motion to approve recommend approval of Operator Licenses for Matthew Hauser, Shawna Jesse, Virginia Johnson, David Skrobis, Allison Wiswell and Britney Wojciechowski. Alderman Engelhardt seconded; motion carried. Recommend Approval of "Class B" Liquor License and Class B Dance Hall License - JDDS Investments LLC d/b/a JD's on Hillendale, W191S6409 Hillendale Drive, Donna Kuri Marg- Agent Alderman Madden made a motion to recommend approval. Alderman Wolfe seconded; motion carried. Finance Committee Minutes 2 November 22, 2016 NEW BUSINESS Recommend Approval of Relocation Order for Moorland Road Reconstruction Alderman Madden made a motion to recommend approval. Alderman Wolfe seconded; motion carried. Recommend Approval of Contract for Professional Real Estate Services between Single Source, Inc. and the City of Muskego Alderman Engelhardt made a motion to recommend approval. Alderman Madden seconded; motion carried. VOUCHER APPROVAL Utility Vouchers Alderman Wolfe made a motion to recommend approval of Utility Vouchers in the amount of $23,363.22. Alderman Madden seconded; motion carried. General Fund Vouchers Alderman Wolfe made a motion to recommend approval of General Fund Vouchers in the amount of $218,948.55. Alderman Madden 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 $13,500. Alderman Engelhardt 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 $434,020.93. Alderman Madden seconded; motion carried. ADJOURNMENT Alderman Engelhardt made a motion to adjourn at 6:55 p.m. Alderman Madden seconded; motion carried. Minutes taken and transcribed by Deputy Clerk Jill Blenski. TAXI DRIVER LICENSES FOR THE MUSKEGO SENIOR TAXI SERVICE FINANCE COMMITTEE – 12/13/2016 Neil Borgman Michael Dombeck Jane Durovy Daniel J. Steele Janis Theel Debra Young T\Departments\FinanceAdmin\Clerk\Licenses: TaxiDrivers-20161213 OPERATOR LICENSE APPROVALS COMMON COUNCIL – 12/13/2016 Tammy King Danielle Wenger Tiffany Zebrasky T:\Departments\FinanceAdmin\Clerk\Licenses\Oper Lic Approval Lists\2016 CITY OF MUSKEGO STAFF REPORT To: Finance Committee & Common Council From: Departments of Information Technology and Finance & Administration Subject: OnBase Enterprise Content Management Solution for SIRE Conversion Date: December 13, 2016 Background Information: The Document Management System capital request was initially proposed and approved during the 2010 budget process. Due to staff transition, project implementation of the SIRE Document Management System and Workflow Software did not occur until 2011 year-end. Since that time, SIRE was acquired by Hyland which prompted City staff to pursue other options in transitioning to a more robust and supported document & agenda management solution. Key Points and/or Information for Discussion (Maximum of 5): 1. The Information Technology and Finance Staff made several attempts over the past two (2) years to work with the Hyland Government Team to address on-going problems with the current SIRE suite, as well as planning for eventual conversion to OnBase. These requests were never resolved due to Hyland’s lack of sufficient staffing and back log of new clients. Hyland eventually recommended the City contact Naviant (3rd party software reseller) to provide assistance for planning, implementation and support assistance for the initial project. 2. After contacting various references, including the State of Wisconsin and viewing demonstrations of the solution suite along with several preliminary discussions, staff agreed that Naviant best met the needs of the organization as a whole as compared to other software packages. 3. The conversion will enhance document and process management capabilities across the City departments to improve efficiencies, reduce costs and improve service internal users and constituents. 4. Project Pricing includes no additional charge for many of the software packages since maintenance on the SIRE suite was kept current. This equates to a $54,040 value. Staff also negotiated the maximum estimated professional services cost down from $109,200 to $86,000. Funding for this project is available in the Special Revenue Cable Fund 2017 budget. By authorizing this agreement prior to year-end, the City will save $8,235.42 of SIRE software maintenance fees which will be waived by Naviant. Recommendation for Action by Committee: Staff requests the Finance Committee and Common Council approve the attached Statement of Work – OnBase Enterprise Content Management Solution for Accounts Payable, Agenda Management & SIRE Conversion Is Common Council action required? Yes Fiscal Note(s): On-going support and maintenance fees are anticipated to be reduced by $4,864 in 2018 due to transition to in-house staff reliance Total $ Requested: $86,000 product/$15,672 support Amount of Total Requested Budgeted: $101,672.00 Amount of Total Requested Unbudgeted: $0.00 Expenditure Account(s) number recommended to be used: #209.01.00.00.6057 Statement of Work OnBase Enterprise Content Management Solution for Accounts Payable, Agenda Management & SIRE Conversion Prepared For: Barb Loudon, IT Director Sharon Mueller, Director of Finance City of Muskego Prepared By: Matt Hein, Strategic Account Executive Steve Zirkle, Government BPM Consultant Guy Schroeder, Manager of Sales Engineering Ed Modjeska, Vice President Naviant, Inc. 9 November 2016 Revised 28 November 2016 Revised 2 December 2016 Revised 12 December 2016 City of Muskego 12 December 2016 Naviant, Inc. – Confidential 1 Version 12.15 PROJECT SCOPE Introduction The City of Muskego, located in Waukesha County, Wisconsin, United States, has a population of approximately 24,555 and is the fifth largest city in the county. Muskego is a suburb of Milwaukee, Wisconsin and consists of new development, high-quality residential subdivisions, business districts, beautiful lakes and improved roads have been adding to the appeal for many people. The acquisition of SIRE by Hyland approximately three years ago has prompted the City of Muskego to pursue an option in transitioning to a more robust and supported document & agenda management solution (OnBase). CivicPlus (local SIRE reseller) provided the initial SIRE implementation and support to Muskego for the past two plus years. Muskego leadership has identified the need to enhance document and process management capabilities across the City government and business/administrative departments to improve efficiencies, reduce costs, and enhance service to internal users and constituents. Over the past few months, Naviant and the City of Muskego (sometimes referred to in this Agreement as Customer) have engaged in preliminary discussions and demonstrations to review best practices and options for optimizing enterprise content management (ECM), business process management (BPM), and case management (CM) through the OnBase solution suite including the conversion of their existing content in their current document & agenda management solution, SIRE. The OnBase software suite (www.onbase.com/government) for federal, state, and local government streamlines paper-based processes across the enterprise with a proven solution for each level of government, helping each meet the challenges of smaller budgets and staffs while laying the foundation for simplified, efficient, and mobile government information technology. As the industry-leading solution to government and their constituents, OnBase provides an extensive breadth of solutions including Finance & Administration, Housing & Human Services, Justice & Public Safety, Planning & Public Works, and Integrations to departmental/agency government applications like Accella, Cityworks, ESRI, and more. While many opportunities exist to leverage the OnBase solution suite across the enterprise, based on discussions to date, the City of Muskego has identified the following four (4) areas for this initial project: 1. Agenda Management 2. Accounts Payable Automation 3. Document Management for remaining business areas 4. SIRE Conversion As a result of Naviant’s experience with government solutions leveraging the OnBase solution suite, the City of Muskego has requested Naviant assistance to provide planning, implementation, and support assistance for this initial project. This assistance will be provided via a future Statement of Work (sometimes referred to as SOW or Agreement) for “OnBase Enterprise Content Management Solution”, and will extend pricing and procurement advantages to the City of Muskego via the OnBase Local Government Licensing Model (local governments with populations of less than 250,000), existing Naviant State of Wisconsin Cooperative Purchasing Agreement, and SIRE to OnBase software migration program. Project Objectives & Preliminary Scope As identified above, the City of Muskego has identified four (4) areas for this initial project: Agenda Management, Accounts Payable Automation, Document Management, and SIRE Conversion. The following preliminary project objectives and assumptions have been identified prior to the formal Planning Phase activities. Initial planning will be provided through a Planning Phase to validate requirements, identify design options, and provide solution recommendations. Planning will validate business process options, specific software licensing necessary, and professional services required to deliver and implement the solution. As a City of Muskego 12 December 2016 Naviant, Inc. – Confidential 2 Version 12.15 result, Future State process assumptions, project requirements, and professional services estimates are based on information available at this time. In the event that additional products and/or services requirements are identified after the Planning Phase is completed, a Change Order Authorization may be required prior to the Implementation Phase engagement. As identified above, the City of Muskego has identified four (4) areas for this initial project: Agenda Management, Accounts Payable Automation, Document Management, and SIRE Conversion. Following is a high-level overview of the preliminary Current State and Future State process objectives and assumptions. Agenda Management The OnBase Agenda Management solution enables government organizations to effectively manage board, council, and committee meetings by automating the processes of agenda item reviews and assembly of meeting related documents. Staff can create agenda items and import related documents in a centralized, secure repository. Agenda items are then routed through OnBase Workflow to ensure the appropriate reviews take place. Meeting packets are automatically generated and available for distribution prior to meetings. If revisions are required, Clerks can easily incorporate changes and immediately distribute updated packets via email, a website, or other channels. With the OnBase Agenda Management solution, government agencies accelerate legislative processes while offering improved transparency to constituents. Each City of Muskego committee has a separate agenda template creating a wide variety of formats throughout the organization. Benefits  Automates & streamlines agenda creation & distribution, reducing manual tasks & costly paper processes  Ensures that the most current versions of documents are included in meeting packets  Supports collaboration by allowing staff to simultaneously participate in the agenda planning process  Reduces staff time required to assemble meeting packets, creating time for higher-value tasks  Increases transparency with a comprehensive view of the process & the status of individual agenda items Key Features  Automatically creates, assembles, updates & distributes meeting packets  Automates the addition of ordinance & resolution numbers, page numbers & placeholder pages  Electronic distribution eliminates paper packets, increases ROI & conserves funds for higher-value projects  Offers instant access to agenda updates, changes & ad-hoc submissions  Captures attendance, motions & votes, and automatically routes items for follow-up after meetings Future State – Preliminary Scope Assumptions As a replacement to the City of Muskego’s existing processes utilizing SIRE, the standard OnBase Agenda Management solution will provide a repeatable framework to provide management best practices with optional future customization opportunities. The project planning and implementation activities will include the following objectives and assumptions:  Standard OnBase Agenda Management framework including pre-configured best practices design and core workflow for City Clerk processing o Utilize Hyland’s agenda plus SIRE Conversion Utility  Convert existing SIRE Meeting Type outlines to OnBase Meeting Types  Convert existing SIRE agenda templates to OnBase agenda templates  Convert and publish to OnBase Agenda Online legacy agenda_plus meeting document and meeting dates o Set up and configuration of an Agenda Item Type and supporting configuration including: City of Muskego 12 December 2016 Naviant, Inc. – Confidential 3 Version 12.15  The submission form for each agenda item type  A Word template that will create an easily readable summary of the agenda item type  Associating up to eight (8) Supporting Document Types allowing submitters to import documents related to the submitted agenda item o Set up and configuration of one (1) Agenda Item Packet Template for formatting, consolidation, and PDF creation of a single packet document o Set up and configuration of up to two (2) Meeting Packet Templates for formatting, consolidation, and PDF creation of a single meeting packet (public and confidential creating separate packets) o Set up and configuration of Core Workflow for receipt, management, notifications, and distribution of City Clerk agenda items. Naviant will perform a gap analysis with Customer to clarify and confirm the agenda management processes. Changes to the Core Workflow business processes or automation considerations may impact the work effort estimated within this estimate resulting in further analysis and discussions. Following is a high-level example of the simple, preconfigured Core Agenda Item Workflow:  Agenda Item Approval (Submitter);   Agenda Item Approval (Department Head);   Agenda Item Approval (Legal);   Agenda Item Approval (Finance); and   Agenda Item Approval (City Manager).  o Post-Meeting Actions  The base solution for Agenda Management does not include workflows specific to the management of Agenda Item disposition processing for things like assigning final resolution or ordinance numbers, document signatures, and those types of processes. While the system can accommodate these types of processes, Naviant will need to understand Customer’s specific processes, and as appropriate, provide a service estimate for post-meeting action processing if requested within the project scope. o Baseline City Clerk training to revise, duplicate & create additional Meeting Type templates o Customer will be responsible for performing business process and user-acceptance testing  OnBase Agenda Media – YouTube Integration o Set up and configuration of OnBase YouTube Integration would capture the meeting(s) video via the encoder (output to Real-Time Messaging Protocol compatibility required) and feed into OnBase. YouTube Integration provides OnBase Agenda Management solution customers the ability to expose and link meeting videos to OnBase Agenda OnLine (public access viewer) for web for public access with integrated archival to YouTube. This YouTube- integrated solution provides the value of OnBase agenda-tagged media streaming without the ongoing costs of local media hosting or 3rd party hosting services. o Legacy archived video will be stored in OnBase as a separate document and will not be retrievable through Agenda Online; rather, legacy video can be retrieved through a separate web access link and public sector constituency access. Please note, legacy video bookmarks will not be converted. o Important Note: As a result of current Google/YouTube (YouTube) and Hyland Software (Hyland) legal negotiations regarding integration updates, the OnBase YouTube Integration may or may not be available at the required time for Customer’s OnBase project configuration. As a result, Hyland Software has provided an interim, short-term video hosting offering for the Customer until the Hyland/YouTube integration agreement is finalized:  Hyland will offer Customer the OnBase Global Cloud Service (GCS) Media Hosting solution at the discounted fee of 83.33/month, which is the same as the OnBase YouTube Integration annual maintenance fees ($1,000/year).  Customer agrees to move off the GCS and onto the YouTube Integration once the legal agreement with Hyland/YouTube agreement is finalized. City of Muskego 12 December 2016 Naviant, Inc. – Confidential 4 Version 12.15  Once the Hyland/YouTube agreement is finalized, Customer would have 90 days to stop using the GCS and covert the existing and day-forward media to the OnBase/YouTube Integration solution.  Hyland resources will assist Naviant in the upload of the Customer’s FLV meeting video files (created via the new GCS solution) into YouTube during the 90-day conversion window from GCS to YouTube.  Hyland will assist with this work as available and within reason for no additional professional services costs to Customer.  During initial configuration of the GCS solution, the option for local storage of the final video must be enabled. o This enablement will send one copy of the video to GCS – this is the video that is streamed and connected to Agenda Online – but also saves a local copy on premise. o The intent is to upload these local copies to YouTube when the Customer conversion occurs.  Note: If Customer elects to remain on the GCS solution after the 90-day conversion window, Customer will continue to be billed for GCS at Hyland’s standard list price for GHC Media Hosting services ($500/month).  Standard Agenda OnLine (public access viewer) to expose documents to the web for public access o Setup and configuration of OnBase Agenda Online includes set up of the software and configuration of the interface to match Customer’s branding (i.e. baseline customization for color scheme & logo). It should be anticipated that this will involve conversations with Customer IT to ensure communication between external site and internal application server. This will include presentment of day-forward and legacy (post-SIRE conversion) agenda content, and will leverage a new conversion utility in development by Hyland Software. Customer will be responsible for all effort to integrate Agenda OnLine with existing online presence. Any changes to the out of the box Agenda OnLine interface is out of scope and will require a change order if needed. Example of standard Document Types to be extended via Agenda OnLine include: Name Sample Description File Type Agenda Document that will be posted to web site MS Word (published as HTML & PDF) Agenda Packet Final agenda and all related material. This is printed for council members PDF Minutes Document that has the official minutes from the meeting MS Word (published as HTML & PDF) Item Cover Sheet Contains information specific to the agenda item. Often referred to as:  Staff Report  Agenda Item Memo MS Word (published PDF) Ordinance/Resolution Template MS Word (published PDF) Accounts Payable Automation Accounts Payable receives invoices via mail and email (Outlook 2010 – local install of Office 365); however, all invoices are currently processed and approved within SIRE. Invoices are both centrally received by Finance, and de-centrally received by departments. Invoices (16,000/year, paper based and emails printed) received by Finance are copied and SIRE Workflow routed to departments for GL coding and approval. Invoices received directly by departments are GL coded and approved prior to manually sending to Finance for processing. Purchase Orders are not used currently. Once an invoice is received by Accounts Payable utilizing SIRE Capture, invoice data (vendor, invoice number) is manually entered into SIRE, and then uploaded from SIRE into Clarity (Caselle). City of Muskego 12 December 2016 Naviant, Inc. – Confidential 5 Version 12.15 Future State – Preliminary Scope Assumptions  AP early-capture (centralized) scanning and electronic email (Outlook 2010) ingestion of invoices o OnBase batch scanning via one (1) centralized AP MFP with OnBase directory sweep process  Invoices will be routed via OnBase Workflow to AP Specialist for review and identification of non- PO invoices requiring approvals.  Invoice transaction data from Clarity may be “shared” with OnBase via OnBase Application Enabler for automated document indexing and retrieval from both OnBase and Clarity. One (1) OnBase autofill look-up to the appropriate SQL tables in Clarity is included at this time.  Invoice distribution with email notifications to approvers will be based on simplified, drop-down menu selection for AP Specialist selection o If a structured Schedule of Authority (SOA) is currently available within Clarity or another external data source, integration between Clarity and OnBase Workflow may be considered but is not included within the current project scope assumptions at this time o Optionally, but not included within the current project scope assumptions, the Naviant NavRULES Engine or OnBase WorkView solution may be considered to provide a structured, systematic SOA approval process within OnBase Workflow  Approvers will receive email notifications, review, enter GL coding via OnBase Workflow/Unity Form, and then approve via OnBase Integration for Outlook 2010 – including timers and escalations as appropriate with electronic routing back to AP o Throughout the review process, the ability for users to create notes on the invoice is included as base functionality within OnBase  After manager approval, AP will provide QC review and commit the transaction in OnBase at which time OnBase will provide a batch file of invoice transaction data to Clarity for vouchering o This will require Customer IT assistance to designate batch file formatting, and to provide batch file ingestion processing  All transaction history, approvals, routings, and status will be tracked within OnBase Document Management The City of Muskego currently uses SIRE document management for additional areas. This functionality is limited to capture, storage, and retrieval. The following is a summary of these areas and SIRE cabinets:  Plats  Conditional Use Grants (CUG)  Police Accreditation  Resolutions  Ordinances  Asbuilts Customer has requested OnBase configuration to re-create these document types and the ability for these departments to continue to scan from multi-function devices via a sweep process directly to OnBase. Future State – Preliminary Scope Assumptions  A single disk group will be configured within OnBase to store the six (6) document types noted above. o Up to ten (10) keywords will be configured and related to document types for indexing and future retrieval.  Native OnBase Document Retrieval will be leveraged for flexible search and retrieval of stored documents. o Custom Queries are available within OnBase to provide a simplified search experience for users. Configuration of Custom Queries is out of scope of this project. City of Muskego 12 December 2016 Naviant, Inc. – Confidential 6 Version 12.15  Each of the above noted document types will be configured for full-text search via the native OnBase Document Retrieval interface.  Naviant will work with customer to determine which aforementioned document types are revisable and configure the document types accordingly allowing for use of EDM Services to create/manage revisions of documents.  Appropriate security will be determined for each document type and be configured accordingly.  The conversion of document annotations from SIRE to OnBase is out of scope o The Customer has confirmed that all planning/engineering department annotations are done within their GIS program, and then converted to PDF and embedded within the image, such that no document management annotations or overlays are considered for conversion. SIRE Conversion to OnBase The strategic vision for OnBase is to migrate all SIRE content (documents & data) to OnBase. As a result of recent discussions, the Customer has requested Naviant to provide requirements validation assistance and conversion assistance to migrate content from SIRE to OnBase. High-level project activities will include: Requirements Validation  Review SIRE to OnBase document type conversion mapping o Confirm current legacy content (documents and data) within SIRE, including document types, agenda templates, and metadata. o Identify day-forward OnBase Document Types, Keyword Values, and User Groups required post-conversion import o Approximately two (2) to three (3) templates for conversion  Configuration o Naviant configuration of Future State OnBase Document Types, Keyword Values, and User Groups based on conversion mapping requirements  Documentation Conversion Services Naviant will work with Hyland Software (OnBase) for the following conversion work tasks including utilization of a Hyland utility that has been specifically developed to assist with streamlining this SIRE conversion process. 1. Conversion of approximately 12.7 GB from SIRE (Initial estimate provided by the Customer) 2. The legacy system is expected to be static and no new documents or changes will take place once the conversion begins. If however this is not the case then a Delta conversion will be required and provided by Customer. One (1) Delta conversion load is included in Naviant professional services assumptions. Additional Delta conversion loads may require additional Naviant professional services not currently included in the scope of this project at this time. 3. Project Reconciliation. We will provide a reconciliation of the following items: A. Documents not delivered due to format B. All media received, converted, not converted, and delivered Conversion Processing, DIP Import & Validation  Naviant data extraction from SIRE and configuration to expected format of conversion (OnBase Document Import Processor format ((DIP)) file  Naviant coordination with Customer & validation of data format & content  Naviant configuration of OnBase Document Import process  Naviant Conversion Unit Testing  Customer User Acceptance Testing (Naviant support) City of Muskego 12 December 2016 Naviant, Inc. – Confidential 7 Version 12.15  Customer monitoring of conversion DIP import process (Customer is fully responsible for the execution of any full cabinet conversion from SIRE to OnBase. If customer does not have a resource for this task, a change order will be needed for Naviant to perform this work)  Naviant data validation – queries & reports to confirm data load to OnBase Preliminary Software & Hardware Requirements The following software licensing recommendations are the preliminary requirements based upon the processes described above for this OnBase implementation. OnBase currently offers a one-time software migration path from SIRE which will provide zero-cost software replacement (not applicable to software maintenance/support) for eligible software components as determined by Hyland Software. Software – One-Time Migration Path The software listed below is included in the one-time software migration path.  Local Government Licensing Bundle o Multi-User Server o Unity Client o Full-Text Search for Autonomy IDOL Server o EDM Services Application Enabler (Single Instance - Clarity) o Virtual Print Driver  Local Government Add-On Licenses o Production Document Imaging (1) o Concurrent Client (9) o Workflow Concurrent Client (9) o Full-Text Indexing Concurrent Client for Autonomy IDOL (2) o Office Business Application 2010 (5)  Agenda Management Local Government Add-On Licenses o Agenda Management Bundle  Agenda Management Core  Conversion Framework for Aspose  PDF Framework licenses o Agenda Concurrent Client (5) – Includes Agenda Workflow Concurrent o Public Sector Constituency Web Access – (25,000 Constituents)  Document Import Processor (DIP) – Two (2) Month Rental Software – Not Included in One-Time Migration Path The software listed below is not included in the software migration path, and will require net-new purchase.  Local Govt Named User Client (5)  Local Govt Web Server  Outlook Integration for 2010 (Outlook version specific, local install required) Hardware  Customer will provide all hardware components including servers, workstations, storage devices, etc.  Customer will provide all operating system software, database software, and client access licenses.  Customer will provide new scanner(s) hardware, if required. Scanner hardware and implementation/support services are available through Naviant as a single-source contract; however, they are not included within the scope of this pricing estimate this time. Assumptions  Customer will commit a Project Manager, Subject Matter Expert, System Analyst, and System Administrator time as needed for project activities. City of Muskego 12 December 2016 Naviant, Inc. – Confidential 8 Version 12.15  Customer will lead development of procedural and end-user training documentation, and conduct end- user training sessions, as needed.  Implementation Phase estimates are provided pre-Planning Phase activities. After completion of the Planning Phase, Naviant and Customer will review Implementation Phase project requirements, including but not limited to Future State process designs, work effort estimates and software, and execute a Change Order Authorization as appropriate. City of Muskego 12 December 2016 Naviant, Inc. – Confidential 9 Version 12.15 APPROACH During the engagement, Naviant will utilize our experience with process and technology to make recommendations on how to best design a solution to meet your objectives. Naviant will provide guidance, experience, and expertise based on the project scope on how to best manage processes and systems relative to strategic capture/ingestion, storage, retrieval, sharing, management, integration, and automation of information. In addition, Naviant will leverage the knowledge gained through previous deployments to avoid potential issues. This engagement will:  Develop a clear vision of the high-level solution goals and constraints  Unify the project team behind a common vision  Determine the appropriate “Future State Project” design  Define the sequence of tasks required for successful implementation  Implement the solution in the test environment  Migration of solution to the production environment  Provide detailed documentation as appropriate throughout the project Naviant Methodology Naviant utilizes a consultative and diagnostic approach to review current organizational processes, technologies, operational systems and supporting intelligence to build our analysis and recommendations. Naviant’s methodical approach shows our commitment to process, and forces logic and ideals into well-organized business models. The Naviant methodology is designed to provide a complete validation of the current situation and understanding of the future solution. Each step in this methodology builds on the prior step to drive to a final solution. Our approach follows an iterative methodology which allows the “Project Teams” to review and refine the solution from the “Solution Design Phase” through the “Feedback & Test Phase,” with the end result being a “Solution Blueprint”, including the “Project Plan” and final specifications to implement a solid solution. Naviant incorporates “Business Excellence” principles and tools to improve process performance that supports customer experience, stakeholder value, and alignment to corporate objectives through the measurement and monitoring of key performance benchmarks and metrics. As a foundation for improvement, Business Excellence validates the use of best practices across the organization and creates an environment for continuous improvement through a blended approach of process tools, technology platforms, and resource alignment. The ultimate objective is to provide visibility into organizational performance to enhance business decisions, process innovation and drive organizational value. Project Phases Naviant has developed a two-phased approach, Planning Phase and Implementation Phase, to implementing Enterprise Content Management (ECM) solutions that is driven by proven methodologies and processes. Naviant’s phased approach provides customers with a high-level overview of what to expect at each phase, including deliverables and responsibilities for both Customer and Naviant. City of Muskego 12 December 2016 Naviant, Inc. – Confidential 10 Version 12.15 KICK-OFF Pre-Engagement Questionnaire Prior to the “Project Kick-Off Meeting,” Naviant will provide Customer with a “Pre-Engagement Questionnaire” as appropriate. This document will be used to establish an understanding of your current work environment. Areas of focus may include:  IT Infrastructure Overview  Internal Risk Assessment  Current Hardware Usage  Key Metrics You Care About  Organizational Charts (Corporate & Dept)  Test Environment Requirements  Overview of Current Environment  User Population & Distribution  Administrative Practices & Procedures Project Kick-Off Meeting Naviant will begin the Project Kick-Off Meeting with your “Core Project Team.” The Kick-Off Meeting will last approximately one to two hours (depending on how much of the questionnaire is complete) and will include:  Introduction of your Core Project Team and Naviant team members  Establishment of roles and schedule of steps outlined in phased approach above  Knowledge transfer and review of your company and vision  Review of Pre-Engagement Questionnaire and clarification of questions  Review of each step of the processes and goals  Requirements definition Overall Project Customer Responsibilities  Assign Core Project Team members and ensure they all attend Kick-Off Meeting  Project Sponsor must be present and participate. The Project Sponsor is the individual that is responsible for signing the SOW. This is the person who has ultimate authority over the project. The project sponsor provides project funding, resolves issues and scope changes, approves major deliverables and provides high-level direction. They also champion the project with internal and external stakeholders.  Project Lead must be present and participate. The Project Lead is the individual that is responsible for project management, including: o Coordinate Project activities with Lead Naviant Consultant o Responsible for Customer resource availability and tracking of tasks assigned to staff o Work with Naviant Project Lead to coordinate activities and provide status reports o Work with Naviant Project Lead to develop Project Plan o Coordinate logistics for non-Customer staff (meeting rooms, remote access, etc.) o Create all Customer required documentation and ensure timely internal sign-offs o Commit and confirm Project Team resources (Project Sponsor, Project Lead, Subject Matter Experts (SMEs), IT resources) will be available as needed for project sessions and activities o Complete and return the Pre-Engagement Questionnaire (if needed) prior to the meeting via email or fax to Naviant at sales@naviant-inc.com or 608-848-0901 City of Muskego 12 December 2016 Naviant, Inc. – Confidential 11 Version 12.15 o Verify you can comply with minimum server specifications for Development/Test Environments (if required) and Production Environment o Provide meeting logistics to Naviant prior to the meeting, including location (address, room location) and remote access codes for conference calls or web conferencing Overall Project Naviant Responsibilities  Identify Naviant Project Team and commit resources  Review completed Pre-Engagement Questionnaire documentation (if needed) prior to meeting  Deliver Preliminary Project Plan, which is a high-level overview based on estimates  Deliver Meeting Agendas (prior to meeting)  Deliver Meeting Notes (post meeting)  Naviant Project Lead will be present and participate. The Project Lead is the individual that is responsible for project management, including: o Lead Customer contact responsible for project execution o Coordinate meetings and status reports with Customer Project Lead Manage issue log and communications with Customer Project Lead o Track project budget o Manage tasks, issues and risks o Milestone sign-off and Project closure & support transition City of Muskego 12 December 2016 Naviant, Inc. – Confidential 12 Version 12.15 PROCESS REVIEW In order to design a Future State solution which meets your needs and preserves the essential functionality of current processes, it is necessary to gain a thorough understanding of the “Current State” environment. In this phase, it is important to keep in mind the goal of process optimization, including minimizing time spent by knowledge workers in the Current State on non-value-added activities (tasks that are easily automated). The Process Review phase is accomplished through a series of working sessions with various Subject Matter Experts (SMEs) including process owner and knowledge workers. During this phase, we will use various techniques to gather information including verbal descriptions, Customer-generated documentation, and live walk-throughs. Customer Responsibilities  SMEs will need to participate in working sessions, and come prepared to discuss Current State processes and process exceptions  Provide additional Current State process documentation that was not identified in Pre-Engagement Questionnaire responses  Discuss any changes you have identified that you would like to see implemented in Future State Naviant Responsibilities  Facilitate and review Current State processes discussions as defined in objectives and provide subsequent high-level documentation  Facilitate and review Current State technical architecture/infrastructure discussions and provide subsequent documentation  Capture Future State considerations, as appropriate City of Muskego 12 December 2016 Naviant, Inc. – Confidential 13 Version 12.15 SOLUTION DESIGN The “Solution Design” phase is where we develop and validate requirements, identify process automation opportunities, and design the final Solution Blueprint (aka Future State design document). Specific software licensing will be identified, as well as professional services required to deliver the solution. Naviant will provide guidance, experience, and expertise based on project scope on how to best manage processes and systems relative to strategic capture/ingestion, storage, retrieval, sharing, management, integration, and automation of information. The Solution Design phase is built together with Customer to ensure best practice methodologies, and includes Joint Application Design (JAD) sessions with various Project Team participants (SMEs, process managers, IT resources, etc.) to define high-level solution parameters. Our approach follows an iterative methodology, which allows for improved and accurate requirements definition while adhering to project direction and deadlines through an open dialogue of communication between our customers and consultants. This iterative process allows the Project Teams to review and refine the solution from the Solution Design Phase through “Test Phase,” with the end result being a final Solution Blueprint, Project Plan, and final specifications to implement a solid Future State solution. The outcome of this phase is the Solution Blueprint, which includes: Project Specifications (work breakdown details), Project Plan, and validation of software licensing, hardware requirements, and professional services estimates. Deliverables The deliverables will be provided to Customer in Adobe PDF format, and will provide for up to one (1) iteration of the draft based on the estimated professional services identified within the SOW. Based on mutual schedules, Naviant’s objective will be to provide the draft deliverables to Customer within seven (7) business days after the conclusion of the onsite sessions. The deliverables will reflect Naviant Group’s Methodology, and typically will include the following standard sections, including:  Overview o Situation Overview o Project Objectives o Participants  Current State Analysis o Process Descriptions  Future State Solution o Solution Summary o Process Descriptions o Process Diagrams/Maps  Infrastructure o Architecture & System Requirements  Project Plan o Phase Plan & Estimates o Resource Requirements o Software & Hardware Requirements City of Muskego 12 December 2016 Naviant, Inc. – Confidential 14 Version 12.15  Estimated Project Pricing o Professional Services o Software & Hardware Customer Responsibilities  Project Team resources (SMEs, IT Resources, decision makers, and others that are impacted by Future State, etc.) must be available to participate in JAD sessions  Attendees collectively must have the power to make Future State process and design decisions  Project Sponsor must review Solution Blueprint and provide sign-off that they have reviewed the document and updated pricing  Change Order required if final Solution Blueprint differs from the initial assumptions and solution estimate provided Naviant Responsibilities  Facilitate JAD sessions with SMEs to validate requested Future State solution design and business requirements (both functional and non-functional)  Technical requirements gathering  Build a high-level Project Plan based on the information gathered  Finalize implementation costs and professional services estimates  Design and deliver the final Solution Blueprint, including Future State architecture based on business and technical requirements, Future State architecture diagram, and hardware/software requirements City of Muskego 12 December 2016 Naviant, Inc. – Confidential 15 Version 12.15 DEVELOPMENT In this phase, the actual solution development work begins based on your Solution Blueprint. Software is configured, integrations are designed, custom development is addressed, electronic forms are created, and workflows are built, all depending upon your Solution Blueprint. The Development phase may be accomplished remotely or onsite at Naviant’s discretion. Customer Responsibilities  SMEs must be available to answer questions in a timely manner  Verification that basic equipment needs for deployment into your environment (development, test, and production) have been provided to Naviant (database server, file server with ample storage, web server if applicable, security, network’s ability to handle incoming traffic, Customer machines, etc.)  Responsible for ensuring Naviant has remote access to the Customer development, test, and production environments Naviant Responsibilities  Develop and configure based on the Solution Blueprint  Execute “Unit Testing” which means Naviant configures the solution and tests to make sure it works as designed City of Muskego 12 December 2016 Naviant, Inc. – Confidential 16 Version 12.15 FEEDBACK & TEST The “Feedback & Test” phase is critical to a successful implementation. Without proper feedback and testing, production go live time comes with a fear of the unknown. During the Feedback portion of this phase, Naviant will provide a prototype walk through demonstration of the Solution with the Core Project Team, and solicit feedback based on Customer expectations and objectives outlined in the SOW. Customer will identify a “Test Team” and conduct “End-to-End Testing,” “System Integration” testing if applicable, and scenario-based “User Acceptance” testing based upon timelines established and agreed upon by the Project Leads for Customer and Naviant. Keep in mind this phase is iterative, and if changes are required based on Feedback & Testing, we can move back through the Solution Design and Development phases to ensure the end result is a solution that meets your objectives. Please note that User Acceptance testing is only done once in the final iteration. Customer Responsibilities  Define and document business scenarios for User Acceptance testing  Identify Test Team and define clear testing responsibilities  Project Leads work closely together to manage testing in agreed upon timelines  Test Team will conduct End-to-End testing, System Integration testing (if applicable), and User Acceptance testing in agreed upon timeline  Decide upon mechanism for “issue tracking”. In absence of a Customer-provided means, Naviant will provide an issue tracking log for Customer to use to maintain issues  Ongoing management and tracking of issues. Naviant Responsibilities  Review business scenarios to ensure they have appropriate coverage  Facilitate user feedback sessions and create feedback documentation  Project Leads work closely together to manage testing in agreed upon timelines  Ongoing management and tracking of reported issues. City of Muskego 12 December 2016 Naviant, Inc. – Confidential 17 Version 12.15 PRODUCTION The Production phase is the actual implementation and deployment of the Solution Blueprint. The Naviant Project Team will provide HyperCare to address any issues that arise once the project has moved into production. Customer will be provided with appropriate contact information once you have reached this phase of the project. Naviant HyperCare Naviant HyperCare provides project support and enhancement assistance through a combination of Go-Live Support and Post-Production Monitoring & Assistance. Naviant Go-Live Support is the stabilization period after project go-live which focuses on customer support and system availability. The Naviant project team will provide technical and process support to the customer’s go-live project team. The team will leverage BPM and technical knowledge and experience from the Naviant deployment and support teams to ensure that all questions and issues are resolved in a timely and effective manner. Go-Live Support will aid the customer’s project team in technical issue resolution and system use. As necessary, Naviant Support Tickets can be opened via the standard SLA process to resolve and track any issues or enhancement requests. Naviant Post-Production Monitoring & Assistance (PPMA) affords dedicated project hours that may be utilized to provide process enhancement and design changes requested by the customer after go-live. The Naviant PPMA team is a group of assigned individuals who will provide process, development and technical support to the customer’s project team. Naviant’s experience recognizes that ECM & BPM solutions expose customers to new technologies and process capabilities which may not be fully evident until after go-live. The overall objective of the PPMA team is to work with each customer, onsite or remote as applicable for the Project Plan, to provide an opportunity for continuous process improvement and to ensure that the solution will be utilized efficiently. Customer Responsibilities  Define participants for Naviant led train the trainer session  Customer will be responsible for end-user training  Project Leads will work closely together so Naviant can track and manage all implementation issues  Ongoing management and tracking of reported issues  Assist in the development of training documentation The installation of this solution will require assistance from Customer, and the personnel assigned to this Project must be available during normal working hours to assist Naviant personnel. The installation of this solution may require assistance from the Customer’s IT staff to obtain access to the servers and network devices the solution may reside on; and thus it is required that the Customer schedule their IT resource to be available within 30 minutes of Naviant being onsite for installation. If Naviant resource has to wait for longer than 30 minutes for an IT resource to be available for assistance with the installation, the Customer will be charged in ¼ hour increments at the prevailing rate for the time lost. Customer will be responsible for timely site preparation including, but not limited to, the provision of adequate electrical power and sufficient number and type of electrical outlets, dust, and smoke control provisions, adequate furniture, and sufficient work space for City of Muskego 12 December 2016 Naviant, Inc. – Confidential 18 Version 12.15 Naviant personnel to perform installation. The installation of this solution may require Naviant to obtain access to the servers and network devices the solution may reside on. Customer will be responsible for additional equipment cabling, except as specifically set forth to be provided by Naviant. In the event Customer will be required to provide specific additional equipment prior to installation, it is the responsibility of Customer to provide the necessary versions of network OS, server software, database, hardware, browsers, and desktop OS to work with the proposed solutions prior to the scheduled Project milestone or task requiring additional equipment, or costs may be incurred by the Customer. Customer will be responsible for the actual results with hardware operations (including among other aspects, network, server or scanner speeds; personnel requirements; and costs) and results may vary from those indicated due to overall network environment, volume estimates, personnel and other factors. Naviant Responsibilities  Project Leads work closely together so Naviant can track and manage all reported issues  Assist in the development of training documentation  Conduct train the trainer sessions  Deliverables include the implementation plan, configuration reports, and finalized solution specifications  Post-production monitoring and assistance City of Muskego 12 December 2016 Naviant, Inc. – Confidential 19 Version 12.15 CLOSURE & SUPPORT Closure The “Project Closure” phase ensures that both the Customer and Naviant agree that the project is in production based on objectives outlined in the SOW, and the project should transition to Naviant Support. Naviant will facilitate a meeting with the Core Project Team to review the project, identify any open issues, and sign-off on project completion. Customer Responsibilities  Core Project Team needs to attend, as well as any additional staff supporting the solution  Project Sponsor must attend and sign-off on project closure Naviant Responsibilities  Facilitate support transition meeting and review project  Introduction of Naviant’s Customer Care Group (CCG) to Customer Support The “Support” phase begins with a Support kick-off meeting facilitated by Naviant’s Customer Care Group (CCG) to review how Customer would engage Naviant for support-related issues. CCG will review the different methods for contacting CCG, tiered support programs, review authorized support contacts approved by Customer, share issue tracking methodology, training, and learning opportunities. Software Support Level Agreement (SLA) Naviant’s experienced support team maintains a dedicated help desk to provide the first line of support for all Enterprise Content Management (ECM) solution implementations. Naviant customers are provided with a toll- free number to use when calling in for support, and will be connected directly with the help desk technician and the call will be logged into the Naviant support service system. By utilizing this streamlined approach to support, Naviant ensures that each issue will be responded to and tracked in a timely and efficient way to minimize disruption to both system operation and work processes. Naviant is an industry leader in solutions support, and is recognized by Hyland Software as a “Diamond Level Support” provider with a 95%+ customer retention rate for annual support renewals. Additional Training OnBase System Administrator Training Naviant recommends that at least one individual participate in the OnBase system administration training class prior to the system being installed or within six months of installation. The course is designed to introduce new and existing system administrators to the use, maintenance, and administration of OnBase and provide in- depth, hands-on experience using actual business scenarios. The class also investigates technical support process, effective maintenance strategies, online documentation and other resources available to OnBase system administrators. City of Muskego 12 December 2016 Naviant, Inc. – Confidential 20 Version 12.15 CommunityLIVE Conference Hyland's CommunityLIVE Conference will stretch your imagination to the limits as OnBase experts and users from around the globe demonstrate how to achieve more with your current system and how you can be the technology leader in your industry with the latest and greatest OnBase upgrades and enhancements. OTTC offers the following benefits:  Industry expert led discussions focused on best practices & areas of concern (VOGUE)  100+ educational sessions & training courses offered  Over 1,500 attendees to share best practices  More compelling keynote speakers & networking events Naviant ECM Leadership Summit Customers are entitled to complimentary attendance at Naviant’s annual ECM Leadership Summit (educational user conference). Naviant's nationally recognized Summit brings together customers, end-users, vendor partners, invited prospects, and Naviant resources to discuss industry trends, learn about new solution offerings, and recognize how to best leverage current investments in content management technologies. The annual Summit focuses on critical business issues, case studies, and solution/industry-focused educational sessions designed to bring increased value to your organization by improving the effectiveness and efficiency of your operations. Support Phase Responsibilities Customer Responsibilities  Provide list of staff authorized to contact Naviant CCG for support (Authorized Support Contacts)  Following meeting, Customer will contact Naviant CCG for any questions on the solution Naviant Responsibilities  Review “CCG New Customer Packet”  Review maintenance support tiers  CCG reviews support coverage with Customer  CCG provides agenda City of Muskego 12 December 2016 Naviant, Inc. – Confidential 21 Version 12.15 PROJECT PRICING Software Description Part # Qty Unit Price Total Local Government Pricing Bundle GV-B-LOCAL 1 16,000 Included Multi-User Server Included Unity Client Included Full-Text Indexing for Autonomy IDOL Included EDM Services Included Application Enabler - Single Instance Included Virtual Print Driver Included Unity Forms UFIPI1 1 0 $0 Local Govt Integration for Outlook 2010 GV-B-MU2-OLIPI1-10 1 2,000 $2,000 Local Govt Production Document Imaging (1) GV-B-MU2-DIIPW1 1 2,000 Included Local Govt Named User Client GV-B-MU2-CTIPN1 5 400 $2,000 Local Govt Concurrent Client GV-B-MU2-CTIPC1 9 650 Included Local Govt Workflow Concurrent Client GV-B-MU2-WLIPC1 9 1,000 Included Local Govt Full-Text Indexing Concurrent Client GV-B-MU2-IDIPC1 2 120 Included Local Govt Office Business Application 2010 GV-B-MU2-OIIPW1-10 5 40 Included Agenda Management AGEIPI1 1 5,000 Included Agenda Concurrent Client AGEIPC1 5 500 Included Local Govt Web Server GV-B-MU2-WTIPW1 1 4,000 $4,000 Public Sector Constituency Web Access GWIPI1 1 250 Included Document Import Processor – 30 Day Rental DPIPW1-30 2 1,500 Included Agenda Media - YouTube Integration AGYIPI1 1 5,000 Included Total Software ($54,040 Value) $8,000 Support & Maintenance - Annual Recurring Description Notes % Software Total Manufacturer Software Maintenance OnBase 20.0% $10,808 Naviant Software Support Level Agreement (SLA) Tier 1 9.0% $4,864 Total Support & Maintenance $15,672 Professional Services Description Total Deployment Services $81,200 Post-Production Monitoring & Assistance $4,800 Total Estimated Professional Services $86,000 1. Actual costs for professional services incurred on a Time & Materials basis will be billed monthly. Actual and reasonable travel expenses (mileage, transportation, lodging, and meals) will be charged to Customer as incurred. Consultant travel time will be billed to Customer at $95 per hour. Professional Services for this Agreement will not exceed a total cost of $86,000, excluding any applicable travel expenses, without a Change Order Authorization approved and executed in writing by Naviant and Customer 2. Please note, subtotals do not include applicable sales tax and freight. Additional freight charges may apply for deliveries to locations without docks, or if product needs to be delivered to a specific locale within the building. 3. Total Software will be invoiced upon receipt of Customer-executed SOW, and if applicable Customer-required Purchase Order, with payment terms consistent with the Standard Terms & Agreement. Manufacturer Software Maintenance and Support Level Agreement fees will begin ninety (90) days from Customer Purchase Order, and are annually renewable. 4. Customer agrees to abide by the provisions set forth in the SLA Provisions and PMA Provisions. These provisions are available at www.naviant-inc.com/services/tech-support-onbase. 5. Customer agrees to cooperate with Naviant marketing efforts, as shall be reasonably requested which may include: (i) providing in-person or phone references to prospective customers; (ii) working to prepare a Customer-success story and/or press release documenting the relationship of the parties; and (iii) allowing use of Customer’s logo, subject to Customer’s standard guidelines, on Naviant’s website and in presentations under Naviant’s customer section and as part of marketing and pre-sales materials used by Naviant. City of Muskego 12 December 2016 Naviant, Inc. – Confidential 22 Version 12.15 SIGNATURE PAGE Customer Name City of Muskego Project Contact Barb Loudon Billing Address (only required for New Customers) W182 S8200 Racine Ave. Muskego, WI 53150-0749 Shipping Address NA Attention Barb Loudon Attention NA Special Instructions None Purchase Order (PO) Requirement Is a PO Required by the Customer? Yes No Purchase Order # This Agreement is entered into pursuant to and incorporates the foregoing, including Exhibits and Schedules, if any, and the attached Standard Terms & Conditions (“Terms”) dated ____________________. This Agreement, and only this Agreement, represents the final description and scope of the Agreement between the parties. Any previous drafts of this Agreement or previous documents used to evaluate this project are not part of this Agreement. Naviant will not be obligated to accept any agreement which has not been signed and returned by Customer to Naviant within thirty (30) days from the date on this Agreement. This Agreement contains confidential information related to and/or owned by Naviant. In consideration of the receipt of this Agreement, Customer agrees not to reproduce or make any such information available in any manner except to persons employed by Customer and required to know such information in the performance of their job duties for Customer, except with prior written consent of Naviant in its sole discretion. Notwithstanding the foregoing restrictions, Customer may disclose the Agreement to third parties as may be required under Wisconsin’s public records laws. This Agreement has been prepared in accordance with Naviant's understanding of Customer requirements based on the information provided. Therefore, it is understood that any additional hardware, software, professional services, and maintenance requests above and beyond the original scope of this Agreement will be billed in addition to those listed in this Agreement. In the event that additional products and/or services beyond the original scope of this Agreement are required, a Change Order Authorization will be generated outlining the details, as well as time and cost estimates, of the modifications to this Agreement. A Change Order Authorization must be authorized, approved, and executed by Naviant’s President, Vice President, or Chief Financial Officer, and the Customer, in order for the modifications to be incorporated into the Agreement. If PO is required, the PO # must be inserted above upon Customer’s execution of this Agreement. Any terms and conditions appearing in any PO shall have no effect unless agreed to in writing by both parties hereof. Upon signed acceptance, please return the entire document to “Attention: Naviant Sales Support” via email or fax at purchasing@naviant.com or 608-848-0901. Acceptance creates a binding contract. Customer Naviant, Inc. Name: Name: Title: Title: Signature: Signature: Date: Date: MUSKEGO POLICE DEPAR TMENT MEMORANDUM TO: FINANCE COMMITTE FROM: CAPTAIN DAVID CONSTANTINEAU SUBJECT: PURCHASE OF PORTABLE TRUCK SCALE SYSTEM DATE: DECEMBER 8, 2016 The police department is requesting permission to purchase a portable truck scale system to better enforce overweight truck restrictions on city streets. In late 2015, the Muskego Police Department began enforcing overweight truck restrictions based on the weight of the violating truck instead of a generic one size fits all weight restriction violation. By utilizing truck scales that local businesses allow us to use, this enforcement, conducted by a few day shift officers, have generated $106,881.01 in fines since November 2105, with the city retaining $84,209.69 of those fines. In 2017, the police department will train all of our officers in the proper identification and enforcement of overweight truck restrictions based on truck weight. The reason to have all officers trained is to ultimately gain compliance and keep overweight trucks off our roads. The problem is that companies with scales close at 4:30pm, and are not always open on weekends, meaning that our officers cannot perform weight enforcement outside those hours. Our officers spoke with representatives from New Berlin PD, which also does overweight truck enforcement and uses portable scales owned by their department. By utilizing portable scales, our officers will be able to do overweight truck enforcement outside of normal business hours. In addition, the time spend on each overweight truck enforcement stop during business hours will decrease significantly, as the investigating officer will be able to conduct their investigation immediately and not be forced to go with the suspected violator to the location of the scales to continue the investigation. This will allow the truck to be on its way faster, and get the officer back in service quicker. The system we are requesting is the same system that New Berlin uses. It is lightweight, utilizes 4 weigh pads and includes a weight indicator with built in printer, built by Scale Dynasty. The total cost of the request is $5,050.00. By purchasing the scales now, we will be able to incorporate them into our officer training. Respectfully, Invoice Date 12/2/2016 Invoice # SD 14331 Bill To Muskego Police Department Captain David Constantineau W182S8200 Racine Ave. Muskego, WI 53150 Dispatch (262)679-4130 Ship To tbd Scale Dynasty Div. of Tara Systems 520 State Place Escondido, CA 92029 P.O. Number Terms Due on receipt Rep Ship Via BEST WAY F.O.B.Project E-mail sales@scaledyansty.com Total www.scaledynasty.com (877) 814-6306 Item Code DescriptionQuantity Price Each Amount PS60KWW 60,000 LB X 10 LB PORTABLE WHEEL WEIGHER TRUCK AXLE SCALE SYSTEM WITH INDICATOR AND BUILT-IN PRINTER. INCLUDES: - 2 WEIGH PADS - SIZE: 24" (W) X 16" (L) X 2" (H) (EACH SCALE) (WIDE ENOUGH FOR DUAL TIRES) - WEIGHT GRADUATION IN 10 LB INCREMENTS - PORTABLE LOW PROFILE DESIGN WITH ATTACHED RAMPS - INDICATOR WITH INTERNAL RECHARGEABLE BATTERY AND BUILT-IN THERMAL PRINTER. A/C ADAPTER INCLUDED. SIZE: 18 x 15 x 8 - INDICATOR WEIGHT READOUT IN LB OR KG - 40' LOAD CELL CABLES - VIEW OR PRINT PER TIRE WEIGHT AS WELL AS TOTAL AXLE WEIGHT AND TOTAL VEHICLE WEIGHT. - FULLY ELECTRONIC, NO MOVING PARTS TO WEAR OUT - 0.05% ACCURACY - 100% OVERLOAD PROTECTION - STRONG ALUMINUM SCALE BASE - PACKAGE CONFIGURED AND CALIBRATED WITH 4000 DIVISIONS - STATIC WEIGHING ONLY. DOES NOT WEIGH IN MOTION - ONE YEAR LIMITED WARRANTY ON ELECTRONICS - TWO YEAR LIMITED WARRANTY ON WEIGH PADS 1 2,700.00 2,700.00 ADDITIONAL S... SET OF WEIGHING PADS 2 WEIGH PADS: 16" X 24" X 2" 2 YEAR WARRANTY 1 2,350.00 2,350.00 SHIPPING SHIPPING AND HANDLING - NO CHARGE 0.00 0.00 TAX NON-TAXABLE 0.00 0.00 $5,050.00 PDF Created with deskPDF PDF Writer - Trial :: http://www.docudesk.com COMMON COUNCIL - CITY OF MUSKEGO RESOLUTION #095-2016 APPROVAL OF MUNICIPAL ENGINEERING SERVICES MASTER AGREEMENT WITH GRAEF-USA, INC. WHEREAS, In September of 2016, the Director of Public Works/City Engineer left the City’s employment; and WHEREAS, The City has chosen GRAEF-USA, Inc. to provide the necessary professional engineering services; and WHEREAS, The Finance Committee has reviewed the attached Municipal Engineering Services Master Agreement with GRAEF-USA, Inc. and has recommended approval. NOW , THEREFORE, BE IT RESOLVED That the Common Council of the City of Muskego, upon the recommendation of the Finance Committee, does hereby approve the attached Municipal Engineering Services Master Agreement with GRAEF-USA, Inc. BE IT FURTHER RESOLVED That the Mayor is authorized to sign the contract with GRAEF-USA, Inc. and the City Attorney is authorized to make substantive changes to the agreement as may be necessary in order to preserve the general intent thereof. DATED THIS 13th DAY OF DECEMBER, 2016. SPONSORED BY: FINANCE COMMITTEE This is to certify that this is a true and accurate copy of Resolution #095-2016 which was adopted by the Common Council of the City of Muskego. _________________________ Deputy Clerk 12/2016 COMMON COUNCIL - CITY OF MUSKEGO RESOLUTION # 097-2016 DEDICATION AND ACCEPTANCE OF PUBLIC IMPROVEMENTS IN AND FOR PARKLAND TOWNE CENTER WHEREAS, Parkland Towne Center Development, Inc , hereafter called “DEVELOPER” has constructed public improvements in and around Parkland Towne Center including all water distribution, sanitary sewer facilities, and storm sewers including any and all equipment and appurtenances which may in any way be a part thereof or pertain to, in and for the Parkland Towne Center; and WHEREAS, the DEVELOPER has completed the construction and installation of the following improvements: Sanitary Sewer 4 EA, Sanitary Manhole (avg depth 12’) 751.2 LF, 8” PVC Sanitary (Crushed Stone Backfill) 140 LF, 6” PVC Sanitary lateral (with Crushed Stone Backfill) Water Main 6 EA, Hydrant 788.2 LF, 12” PVC Water (Crushed Stone Backfill) 505.35 LF, 8” PVC Water (Crushed Stone Backfill) 605.8 LF, 8” PVC Water (Excavated Backfill) 355.1 LF, 6” PVC Water (Crushed Stone Backfill) 130.1 LF, 6” PVC Water Laterals (with Crushed Stone Backfill) 2 EA, 12” Butterfly Valve with Valve Box 6 EA, 8” Butterfly Valve with Valve Box 6 EA, 6” Butterfly Valve with Valve Box 4 EA, 6” Butterfly Valve with Valve Box for Laterals 3 EA, Connect to Ex WM 59 LF, 6” PVC Hydrant Lead Storm Sewer 2 EA, Catch Basin 37 LF, 24” PVC Storm Pavement/Roadway 760.99 LF, 30” Curb/gutter 7981.76 SF, Lannon Drive Asphalt Mill and Overlay 2” min. 1235.14 SF, Concrete Drive Aprons 4018.72 SF, Public Concrete sidewalk 5037.43 SF, Asphalt Pavement and appurtenances (collectively called “IMPROVEMENTS”) in accordance with the provision of Chapter 18 of the Municipal Code of the City of Muskego, hereafter called the “CITY”, and the City Engineer has certified the systems’ acceptability; and Reso. #097-2016 Page 2 WHEREAS, it is the Developer’s intent to, without charge to the CITY, unconditionally give, grant, convey and fully dedicate the IMPROVEMENTS to the CITY, free and clear of all encumbrances, and together with mains, conduits, pipes, plants, machinery, equipment and appurtenances which relate directly to the utilization of such IMPROVEMENTS; and WHEREAS, the DEVELOPER shall guarantee the public improvements to be dedicated against any defects due to faulty materials or workmanship which appear within a period of one (1) year from the date of dedication and shall pay for any damages resulting therefrom to the CITY property and shall indemnify the CITY against any claims, suits, or liabilities brought against the CITY at any time arising out of the alleged defects or other failure of this guarantee; and WHEREAS, the DEVELOPER must complete the installation of the roadway per the subdivider’s agreement, and such installation must meet all City requirements; and NOW, THEREFORE, BE IT RESOLVED That the Common Council of the City of Muskego, upon the recommendation of the Finance Committee, does hereby accept dedication and acceptance of the public improvements in and for the Parkland Towne Center. DATED THIS 13th DAY of DECEMBER , 2016 SPONSORED BY: FINANCE COMMITTEE This is to certify that this is a true and accurate copy of Resolution #097-2016 which was adopted by the Common Council of the City of Muskego. _____________________________ Clerk-Treasurer Council Date DECEMBER 13, 2016 Total Vouchers All Funds $933,668.28 Total Voucher Approval Utility Vouchers (Approve Separately) Water Vouchers $11,070.94 Water Wire Transfers Total Water $11,070.94 Sewer Vouchers 20,007.10 Sewer Wire Transfers Total Sewer $20,007.10 Net Total Utility Vouchers $ 31,078.04 #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 $902,590.24 General Fund Void Checks ()** Total General Fund Vouchers $ 902,590.24 #3 - General Voucher Approval Big Muskego Lake Vouchers $ . Wire transfers (Approve Separately): Tax Settlements $ Debt Service $ Payroll/Invoice Transmittals $312,847.36 #4 - Wire Transfers Approval Void Checks Since Last Report Check #Amount Check #Amount 146085 83.40 146864 45.00 147487 4,550.74 Total *** Total 4,679.14 *Total *** CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 1 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM 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 5 ALARM FIRE & SAFETY EQUP,LLC 162006-1 1 Invoice REPAIR GAS METER 11/15/2016 12/13/2016 460.41 1116 601.61.61.21.5306 Total 5 ALARM FIRE & SAFETY EQUP,LLC:460.41 ALSCO 42510/121316 1 Invoice 11/16 UNIFORM RENTAL 12/01/2016 12/13/2016 74.08 1216 601.61.61.12.5702 42510/121316 2 Invoice 11/16 UNIFORM RENTAL 12/01/2016 12/13/2016 74.08 1216 605.56.09.21.5835 42510/121316 3 Invoice 11/16 UNIFORM RENTAL 12/01/2016 12/13/2016 243.28 1216 100.04.51.07.5704 42511/121316 1 Invoice 11/16 UNIFORM RENTAL 12/01/2016 12/13/2016 119.72 1216 100.04.51.07.5704 42511/121316 2 Invoice 11/16 UNIFORM RENTAL 12/01/2016 12/13/2016 40.12 1216 601.61.61.12.5702 42511/121316 3 Invoice 11/16 UNIFORM RENTAL 12/01/2016 12/13/2016 40.12 1216 605.56.09.21.5835 Total ALSCO:591.40 AMERICAN LITHO, INC. 251077-01 1 Invoice Program Guide Printing-Winter/Sprin 11/29/2016 12/13/2016 3,304.00 1216 100.05.72.10.5820 Total AMERICAN LITHO, INC.:3,304.00 AQUECS, INC. 25927 1 Invoice Slow down yard signs 12/02/2016 12/13/2016 371.00 1216 505.00.00.00.2638 Total AQUECS, INC.:371.00 ARENZ, MOLTER, MACY AND RIFFLE 11102 1 Invoice MISC/GENERAL GOV 12/02/2016 12/13/2016 58.00 1216 100.01.05.00.5805 Total ARENZ, MOLTER, MACY AND RIFFLE:58.00 ASSURANT EMPLOYEE BENEFITS 60169/121316 1 Invoice ACCIDENT - NOV 2016 12/02/2016 12/13/2016 154.98 1216 100.00.00.00.2247 60169/121316 2 Invoice CRITICAL ILLNESS - NOV 2016 12/02/2016 12/13/2016 130.75 1216 100.00.00.00.2248 60169/121316 3 Invoice LONG-TERM DIS - NOV 2016 12/02/2016 12/13/2016 315.19 1216 100.00.00.00.2246 60169/121316 4 Invoice sHORT-TERM DIS - NOV 2016 12/02/2016 12/13/2016 307.47 1216 100.00.00.00.2243 Total ASSURANT EMPLOYEE BENEFITS:908.39 AT&T AMER2520160 1 Invoice CLAIM DIGGING - GAULKE 11/23/2016 12/13/2016 297.62 1216 100.01.06.00.6108 Total AT&T:297.62 ATLAS BUSINESS SOLUTIONS, INC. INV283412 1 Invoice Scheduling software 2017 12/06/2016 12/13/2016 960.00 1216 100.00.00.00.1601 Total ATLAS BUSINESS SOLUTIONS, INC.:960.00 ATONEMENT LUTHERAN CHURCH AT121316 1 Invoice GENERAL ELECTION - CUSTODIA 12/02/2016 12/13/2016 50.00 1216 100.01.03.00.5704 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 2 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total ATONEMENT LUTHERAN CHURCH:50.00 BABCOCK AUTO SPRING CO. 71534 1 Invoice SPRINGS #7 11/16/2016 12/13/2016 1,553.64 1116 100.04.51.07.5405 Total BABCOCK AUTO SPRING CO.:1,553.64 BAKER & TAYLOR COMPANY 2032448228 1 Invoice PRINT 11/29/2016 12/13/2016 899.96 1216 100.05.71.01.5711 2032452208 1 Invoice PRINT 11/29/2016 12/13/2016 350.76 1216 100.05.71.01.5711 2032455604 1 Invoice REPLACEMENT 11/29/2016 12/13/2016 262.61 1216 100.05.71.00.5774 2032455604 2 Invoice PRINT 11/29/2016 12/13/2016 180.84 1216 100.05.71.01.5711 2032457745 1 Invoice PRINT 11/29/2016 12/13/2016 1,016.51 1216 100.05.71.01.5711 2032458393 1 Invoice PRINT 11/29/2016 12/13/2016 809.63 1216 100.05.71.01.5711 2032458393 2 Invoice AV 11/29/2016 12/13/2016 19.23 1216 100.05.71.02.5711 2032458547 1 Invoice PRINT 11/29/2016 12/13/2016 738.60 1216 100.05.71.01.5711 2032458760 1 Invoice PRINT 12/07/2016 12/13/2016 8,756.32 1216 100.05.71.01.5711 2032466037 1 Invoice PRINT 12/07/2016 12/13/2016 1,151.32 1216 100.05.71.01.5711 2032472303 1 Invoice PRINT 12/07/2016 12/13/2016 783.36 1216 100.05.71.01.5711 2032472303 2 Invoice AV 12/07/2016 12/13/2016 10.99 1216 100.05.71.02.5711 2032483963 1 Invoice REPLACEMENT 12/07/2016 12/13/2016 13.35 1216 100.05.71.00.5774 2032483963 2 Invoice PRINT 12/07/2016 12/13/2016 326.31 1216 100.05.71.01.5711 5014340231 1 Invoice PRINT 11/29/2016 12/13/2016 135.15 1216 100.05.71.01.5711 5014348380 1 Invoice PRINT 12/06/2016 12/13/2016 47.98 1216 100.05.71.01.5711 Total BAKER & TAYLOR COMPANY:15,502.92 BAKER & TAYLOR ENTERTAINMENT B30510520 1 Invoice AV 11/29/2016 12/13/2016 133.05 1216 100.05.71.02.5711 B30510521 1 Invoice AV 11/29/2016 12/13/2016 32.39 1216 100.05.71.02.5711 B30689100 1 Invoice AV 11/29/2016 12/13/2016 214.35 1216 100.05.71.02.5711 B30766620 1 Invoice AV 11/29/2016 12/13/2016 14.23 1216 100.05.71.02.5711 B30832350 1 Invoice AV 11/29/2016 12/13/2016 118.70 1216 100.05.71.02.5711 B30905030 1 Invoice AV 11/29/2016 12/13/2016 360.32 1216 100.05.71.02.5711 B31105500 1 Invoice AV 12/06/2016 12/13/2016 28.78 1216 100.05.71.02.5711 B31350160 1 Invoice AV 11/29/2016 12/13/2016 172.63 1216 100.05.71.02.5711 B31350270 1 Invoice AV 12/06/2016 12/13/2016 11.88 1216 100.05.71.02.5711 B31422640 1 Invoice AV 12/06/2016 12/13/2016 24.41 1216 100.05.71.02.5711 B31422641 1 Invoice AV 12/06/2016 12/13/2016 100.76 1216 100.05.71.02.5711 B31422642 1 Invoice AV 12/07/2016 12/13/2016 22.31 1216 100.05.71.02.5711 B31422643 1 Invoice AV 12/06/2016 12/13/2016 30.95 1216 100.05.71.02.5711 B31440960 1 Invoice AV 12/06/2016 12/13/2016 5.93 1216 100.05.71.02.5711 B31494720 1 Invoice AV 12/07/2016 12/13/2016 1,198.07 1216 100.05.71.02.5711 B31560100 1 Invoice AV 12/06/2016 12/13/2016 14.08 1216 100.05.71.02.5711 B31567600 1 Invoice AV 12/06/2016 12/13/2016 28.76 1216 100.05.71.02.5711 B31719960 1 Invoice AV 12/06/2016 12/13/2016 9.86 1216 100.05.71.02.5711 B33437660 1 Invoice AV 12/06/2016 12/13/2016 14.23 1216 100.05.71.02.5711 B33437661 1 Invoice AV 12/07/2016 12/13/2016 18.71 1216 100.05.71.02.5711 B33437662 1 Invoice AV 12/06/2016 12/13/2016 82.77 1216 100.05.71.02.5711 B33437663 1 Invoice AV 12/06/2016 12/13/2016 43.18 1216 100.05.71.02.5711 T46493920 1 Invoice AV 11/29/2016 12/13/2016 28.79 1216 100.05.71.02.5711 T47388130 1 Invoice AV 12/06/2016 12/13/2016 35.99 1216 100.05.71.02.5711 T47436560 1 Invoice AV 12/06/2016 12/13/2016 11.03 1216 100.05.71.02.5711 Total BAKER & TAYLOR ENTERTAINMENT:2,756.16 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 3 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number BAKER TILLY VIRCHOW KRAUSE, LLP BT1027803 1 Invoice 2015 AUDIT OF FINANCIAL STATE 12/08/2016 12/13/2016 1,200.00 1216 100.01.06.00.5810 Total BAKER TILLY VIRCHOW KRAUSE, LLP:1,200.00 BAYCOM INC EQUIPINV_005 1 Invoice Arbitrator 12/06/2016 12/13/2016 5,910.00 1216 410.08.91.20.6507 EQUIPINV_005 1 Invoice Radio footpedal 12/06/2016 12/13/2016 276.00 1216 410.08.91.20.6507 Total BAYCOM INC:6,186.00 BOBCAT PLUS, INC. IB92483 1 Invoice #SKIDSTEER 11/22/2016 12/13/2016 612.31 1116 100.04.51.07.5405 Total BOBCAT PLUS, INC.:612.31 BPI COLOR 0015910 1 Invoice METER READING 12/01/2016 12/13/2016 18.93 1216 100.06.18.01.5410 Total BPI COLOR:18.93 BROCK-WHITE CO OF WIS, INC 0206247 1 Invoice SNOW FENCE TIES 12/02/2016 12/13/2016 150.00 1216 100.04.51.05.5746 Total BROCK-WHITE CO OF WIS, INC:150.00 BRODART CO. 454090 1 Invoice PROCESSING SUPPLIES 11/29/2016 12/13/2016 165.36 1216 100.05.71.00.5701 454753 1 Invoice PROCESSING SUPPLIES 12/07/2016 12/13/2016 103.04 1216 100.05.71.00.5701 Total BRODART CO.:268.40 BUMPER TO BUMPER MUSKEGO 644-482646 1 Invoice GLOVES 12/01/2016 12/13/2016 11.99 1216 215.06.00.00.5704 Total BUMPER TO BUMPER MUSKEGO:11.99 CIEPLUCH, MARK CI121316 1 Invoice REIMBURSE RESTITUTION 12/08/2016 12/13/2016 4,005.00 1216 202.08.94.74.6530 Total CIEPLUCH, MARK:4,005.00 COMMUNITY MEMORIAL HOSPITAL 2630459 1 Invoice blood draw 12/06/2016 12/13/2016 33.00 1216 100.02.20.01.5722 Total COMMUNITY MEMORIAL HOSPITAL:33.00 COMPLETE OFFICE OF WIS 695700 1 Invoice Office Supplies 11/29/2016 12/13/2016 124.40 1216 100.01.08.00.5701 697675 1 Invoice CALENDARS 12/01/2016 12/13/2016 24.96 1216 100.06.18.01.5701 699464 1 Invoice manilla folders 12/06/2016 12/13/2016 36.88 1216 100.02.20.01.5701 701907 1 Invoice CALENDAR 12/01/2016 12/13/2016 9.85 1216 100.06.18.01.5701 703173 1 Invoice FILE FOLDERS - NON DEPT 12/02/2016 12/13/2016 38.32 1216 100.01.06.00.5701 Total COMPLETE OFFICE OF WIS:234.41 CORBETT, SEAN CO121316 1 Invoice Class Instruction - Karate 12/02/2016 12/13/2016 1,440.00 1216 100.05.72.13.5110 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 4 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total CORBETT, SEAN:1,440.00 CUA CLAWS 102516-46 1 Invoice FLAT WHEELS 11/10/2016 12/13/2016 1,238.00 1116 601.61.61.16.5411 Total CUA CLAWS:1,238.00 DAVIS, PATTI 85135 1 Invoice Class Cancellation Refund 11/29/2016 12/13/2016 35.00 1216 100.00.00.00.2110 Total DAVIS, PATTI:35.00 DEMCO EDUCATIONAL CORP 5981253 1 Invoice PROCESSING SUPPLIES 12/06/2016 12/13/2016 63.94 1216 100.05.71.00.5701 6010224 1 Invoice PROCESSING SUPPLIES 11/29/2016 12/13/2016 58.95 1216 100.05.71.00.5701 6012555 1 Invoice PROGRAMMING 12/06/2016 12/13/2016 77.58 1216 100.05.71.00.6062 Total DEMCO EDUCATIONAL CORP:200.47 DIVERSIFIED BENEFIT SERV INC. 231562 1 Invoice FSA FEES - NOVEMBER 12/02/2016 12/13/2016 192.45 1216 100.01.06.00.5203 Total DIVERSIFIED BENEFIT SERV INC.:192.45 DIXON ENGINEERING INC 16-1408 1 Invoice T MOBILE - TOWER INSPECTION 11/29/2016 12/13/2016 950.00 1216 605.56.09.23.5815 Total DIXON ENGINEERING INC:950.00 EAGLE MEDIA, INC. 00121956 1 Invoice Karfonta polos 12/06/2016 12/13/2016 81.86 1216 100.02.20.10.5151 00122042 1 Invoice Mueller shirts 12/06/2016 12/13/2016 81.86 1216 100.02.20.10.5151 00122330 1 Invoice Rens Uniform 12/06/2016 12/13/2016 143.92 1216 100.02.20.01.5151 Total EAGLE MEDIA, INC.:307.64 ECITY TRANSACTIONS LLC 4020-17 1 Invoice DECEMBER MONTHLY 12/08/2016 12/13/2016 300.00 1216 100.01.06.00.6014 4020-17 2 Invoice 2017 PARK & REC SETUP FEE 12/08/2016 12/13/2016 8,500.00 1216 100.00.00.00.1601 4020-17 3 Invoice PARK & REC ADD ON 12/08/2016 12/13/2016 150.00 1216 100.05.72.10.5820 4020-17 4 Invoice UTILITY BALANCE UPLOAD & STO 12/08/2016 12/13/2016 27.50 1216 601.61.63.42.5701 4020-17 5 Invoice UTILITY BALANCE UPLOAD & STO 12/08/2016 12/13/2016 27.50 1216 605.56.09.21.5712 Total ECITY TRANSACTIONS LLC:9,005.00 EDWARDS, WILLIAM ED121316 1 Invoice Program Guide Ads 11/29/2016 12/13/2016 35.60 1216 100.05.72.10.5820 Total EDWARDS, WILLIAM:35.60 ELECTION SOURCE 35645 1 Invoice SHIPPING CHARGE 12/02/2016 12/13/2016 22.31 1216 100.01.03.00.5704 Total ELECTION SOURCE:22.31 ELLIOTS ACE HARDWARE 601005/121316 1 Invoice CITY HALL MAINT 12/08/2016 12/13/2016 63.25 1216 100.01.09.00.5415 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 5 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number 601005/121316 2 Invoice LIBRARY MAINT 12/08/2016 12/13/2016 9.52 1216 100.05.71.00.5415 601005/121316 3 Invoice TOWN HALL MAINT 12/08/2016 12/13/2016 6.26 1216 100.05.72.03.5702 601005/121316 4 Invoice SEWER MAINT 12/08/2016 12/13/2016 103.99 1216 601.61.61.15.5415 Total ELLIOTS ACE HARDWARE:183.02 ENTERPRISE SYSTEMS GROUP 74142 1 Invoice DPW Fax not working 12/02/2016 12/13/2016 257.00 1216 100.01.14.00.5840 Total ENTERPRISE SYSTEMS GROUP:257.00 FACTORY MOTOR PARTS CO 13-206488 1 Invoice BATTERY 3 11/15/2016 12/13/2016 225.00 1216 100.04.51.07.5405 13-X00403 1 Invoice PRIOR CREDIT - DEFECTIVE BAT 12/01/2016 12/13/2016 50.45-1216 100.04.51.07.5405 Total FACTORY MOTOR PARTS CO:174.55 FINDAWAY WORLD,LLC 201265 1 Invoice AV 11/29/2016 12/13/2016 731.87 1216 100.05.71.02.5711 Total FINDAWAY WORLD,LLC:731.87 FIRST SCRIBE 2471687 1 Invoice ROWAY WEB APPLICATION 12/07/2016 12/13/2016 85.00 1216 100.04.19.00.5815 Total FIRST SCRIBE:85.00 FONS, NICHOLAS FO121316 1 Invoice Training meals 12/06/2016 12/13/2016 20.00 1216 100.02.20.01.5301 Total FONS, NICHOLAS:20.00 FORCE AMERICA INC. 1099061 1 Invoice FEEDBACK SENSOR 11/21/2016 12/13/2016 342.72 1116 100.04.51.07.5405 1100668 1 Invoice PROP PFC N/C 12/02/2016 12/13/2016 .00 1216 100.04.51.07.5405 1100723 1 Invoice OWD ASSEMBLY 11/30/2016 12/13/2016 791.28 1216 100.04.51.07.5405 1101283 1 Invoice CABLE EXT 12/01/2016 12/13/2016 111.63 1216 100.04.51.07.5405 Total FORCE AMERICA INC.:1,245.63 FOTH INFRASTRUCTURE & 50242 1 Invoice EDGEWATER HEIGHTS 11/30/2016 12/13/2016 17,071.10 1216 507.00.00.00.2672 50243 1 Invoice OAKRIDGE GLEN SURFACE PAVI 11/30/2016 12/13/2016 656.70 1216 507.00.00.00.2675 Total FOTH INFRASTRUCTURE &:17,727.80 FOX RIVER CHRISTIAN CHURCH FO121316 1 Invoice GENERAL ELECTION - CUSTODIA 12/02/2016 12/13/2016 50.00 1216 100.01.03.00.5704 Total FOX RIVER CHRISTIAN CHURCH:50.00 FOX SERVICES, LLC 5427 1 Invoice GROUNDS MAINTENANCE CONTR 12/07/2016 12/13/2016 710.00 1216 100.04.51.01.5820 5428 1 Invoice LAWN MOWING SERVICES 12/07/2016 12/13/2016 6,081.25 1216 100.04.51.01.5820 Total FOX SERVICES, LLC:6,791.25 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 6 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number GAIL FORCE ENTERPRISES 5336 1 Invoice Class Instruction Yoga 11/29/2016 12/13/2016 495.00 1216 100.05.72.13.5110 5337 1 Invoice Class Instruction Yoga 11/29/2016 12/13/2016 371.25 1216 100.05.72.13.5110 Total GAIL FORCE ENTERPRISES:866.25 GELLINGS, BLAINE GE121316 1 Invoice 2016 REIMB 12/07/2016 12/13/2016 150.00 1216 601.61.61.12.5702 GE121316 2 Invoice 2016 REIMB 12/07/2016 12/13/2016 150.00 1216 605.56.09.30.5228 Total GELLINGS, BLAINE:300.00 GENE'S GETTING IT CUT LLC GE121316 1 Invoice SLED HILL - MANCHESTER 10/31/2016 12/13/2016 500.00 1116 100.04.51.08.5415 Total GENE'S GETTING IT CUT LLC:500.00 GRAEF INC 0090905 1 Invoice MUSKEGO-RACINE AVENUE REC 11/30/2016 12/13/2016 3,300.00 1216 202.08.94.74.6573 0090949 1 Invoice GENERAL ENGINEERING 12/08/2016 12/13/2016 1,460.10 1216 100.04.19.00.5815 0090949 2 Invoice PUBLIC WORKS MEETING 12/08/2016 12/13/2016 1,663.70 1216 100.04.19.00.5815 0090949 3 Invoice GENERAL MEETINGS 12/08/2016 12/13/2016 16.20 1216 100.04.19.00.5815 0090949 4 Invoice PARKLAND TOWNE CENTER 12/08/2016 12/13/2016 2,902.15 1216 411.08.91.19.5815 0090949 5 Invoice EDGEWATER HEIGHTS 12/08/2016 12/13/2016 2,913.95 1216 507.00.00.00.2672 0090949 6 Invoice 2017 ROAD PROGRAM 12/08/2016 12/13/2016 89.00 1216 100.07.51.02.6502 0090949 7 Invoice CITY HALL DEVELOPMENT 12/08/2016 12/13/2016 3,146.86 1216 410.08.90.09.6550 0090949 8 Invoice APOLLO DR BUILDING 12/08/2016 12/13/2016 451.09 1216 410.08.93.51.6550 0090949 9 Invoice MOORLAND ROAD PROJECT 12/08/2016 12/13/2016 1,291.20 1216 410.08.91.19.6503 0090949 10 Invoice JANESVILLE ROAD TRAIL PROJE 12/08/2016 12/13/2016 75.00 1216 202.08.94.74.6573 0090949 11 Invoice KRAFT PROPERTY 12/08/2016 12/13/2016 300.00 1216 100.04.19.00.5815 0090949 12 Invoice N CAPE ROAD (MIDDLE SCHOOL)12/08/2016 12/13/2016 150.00 1216 507.00.00.00.2793 0090949 13 Invoice ST LEONARDS CHURCH REVIEW 12/08/2016 12/13/2016 150.00 1216 100.04.19.00.5815 0090949 14 Invoice MARTIN DRIVE TRAIL 12/08/2016 12/13/2016 89.00 1216 202.08.94.74.6573 Total GRAEF INC:17,998.25 GRAYBAR 988344930 1 Invoice LIGHTING - CITY HALL 12/02/2016 12/13/2016 35.00 1216 100.01.09.00.5415 988344930 2 Invoice LIGHTING - LIBRARY 12/02/2016 12/13/2016 52.50 1216 100.05.71.00.5415 988547777 1 Invoice CITY HALL LIGHTING 12/08/2016 12/13/2016 219.78 1216 100.01.09.00.5415 Total GRAYBAR:307.28 HANSEN, TATIANNA 85133 1 Invoice Class Cancellation Refund 11/29/2016 12/13/2016 75.00 1216 100.00.00.00.2110 Total HANSEN, TATIANNA:75.00 HAWKINS, INC. 3988957 1 Invoice AZONE 11/30/2016 12/13/2016 657.00 1216 605.53.06.31.5750 Total HAWKINS, INC.:657.00 HEARTLAND BUSINESS SYSTEMS I161027108 1 Invoice Consulant- Lib. wireless+ Monthly 12/02/2016 12/13/2016 690.00 1216 100.01.14.00.5840 I161114150 1 Invoice Troubleshoot Storage 12/02/2016 12/13/2016 86.25 1216 100.01.14.00.5840 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 7 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total HEARTLAND BUSINESS SYSTEMS:776.25 HENNECKE, JENNY HE121316-RE 1 Invoice Class Cancellation Refund 12/05/2016 12/13/2016 45.00 1216 100.00.00.00.2110 Total HENNECKE, JENNY:45.00 HOLZ MOTORS, INC 1090700 1 Invoice Sqd 2 trans case shift module repair 12/06/2016 12/13/2016 50.88 1216 100.02.20.01.5405 Total HOLZ MOTORS, INC:50.88 HUMPHREY SERVICE PARTS 1128805 1 Invoice #14 PARTS 11/14/2016 12/13/2016 28.82 1116 100.04.51.07.5405 1129183 1 Invoice OFFSET MIRROR 11/17/2016 12/13/2016 61.28 1116 100.04.51.07.5405 1129329 1 Invoice #12 PARTS 11/18/2016 12/13/2016 125.66 1116 100.04.51.07.5405 1129528 1 Invoice #12 PARTS 11/21/2016 12/13/2016 1,546.60 1116 100.04.51.07.5405 1129679 1 Invoice FILLINGS #14 11/23/2016 12/13/2016 20.70 1216 100.04.51.07.5405 1129826 1 Invoice MIRROR 11/25/2016 12/13/2016 30.64 1216 100.04.51.07.5405 1129827 1 Invoice MIRROR PLOW 11/25/2016 12/13/2016 97.56 1216 100.04.51.07.5405 Total HUMPHREY SERVICE PARTS:1,911.26 IIMC 1754/121316 1 Invoice 2017 MEMBER DUES - DEPUTY CL 12/08/2016 12/13/2016 100.00 1216 100.00.00.00.1601 Total IIMC:100.00 INLAND LEASING 58865801 1 Invoice CONTRACT PAYMENT - DEC 2016 12/02/2016 12/13/2016 116.84 1216 100.01.06.00.5410 Total INLAND LEASING:116.84 JAMES IMAGING SYSTEMS INC 712726 1 Invoice MONTHLY CHARGES 11/17/2016 12/13/2016 25.32 1116 605.56.09.21.5401 712726 2 Invoice MONTHLY CHARGES 11/17/2016 12/13/2016 25.32 1116 601.61.63.42.5701 712726 3 Invoice MONTHLY CHARGES 11/17/2016 12/13/2016 25.33 1116 100.04.51.01.5701 Total JAMES IMAGING SYSTEMS INC:75.97 JANI-KING INC- MILW REGION MIL12160155 1 Invoice CLEANING - CITY HALL 12/02/2016 12/13/2016 2,150.00 1216 100.01.09.00.5835 MIL12160155 2 Invoice CLEANING - PD 12/02/2016 12/13/2016 1,728.00 1216 100.02.20.01.5835 MIL12160155 3 Invoice CLEANING - LIBRARY 12/02/2016 12/13/2016 3,049.00 1216 100.05.71.00.5835 MIL12160155 4 Invoice CLEANING - TOWN HALL 12/02/2016 12/13/2016 363.00 1216 100.05.72.03.5820 MIL12160155 5 Invoice CLEANING - PARK ARTHUR 12/02/2016 12/13/2016 480.00 1216 100.04.51.01.5820 Total JANI-KING INC- MILW REGION:7,770.00 JM BRENNAN, INC. SALES000080 1 Invoice BOILER REPAIR - CITY HALL 12/02/2016 12/13/2016 1,944.63 1216 100.01.09.00.5415 Total JM BRENNAN, INC.:1,944.63 JOHNNY'S PETROLEUM PROD INC 47153 1 Invoice 7502 UNLEADED 12/02/2016 12/13/2016 15,446.62 1216 100.04.51.07.5736 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 8 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total JOHNNY'S PETROLEUM PROD INC:15,446.62 JOURNAL SENTINEL INC 700556/121316 1 Invoice ELECTIONS 12/08/2016 12/13/2016 187.25 1216 100.01.03.00.5704 700556/121316 2 Invoice CARING ALTERNATIVES BSO #89 12/08/2016 12/13/2016 116.06 1216 507.00.00.00.2728 700556/121316 3 Invoice MISC PUBLICATIONS 12/08/2016 12/13/2016 14.00 1216 100.01.06.00.6001 JO121316 1 Invoice 2017 12 MONTH RENEWAL 12/02/2016 12/13/2016 126.10 1216 100.00.00.00.1601 JO121316 2 Invoice 2017 12 MONTH RENEWAL 12/02/2016 12/13/2016 126.10 1216 100.00.00.00.1601 Total JOURNAL SENTINEL INC:569.51 JSA ENVIRONMENTAL, INC. 2643 1 Invoice 10030 VEOLIA OVERSIGHT & AUDI 12/02/2016 12/13/2016 3,398.60 1216 210.03.00.00.5816 2643 2 Invoice EARLY 2.5% PAYMENT DISCOUNT 12/02/2016 12/13/2016 84.97-1216 210.03.00.00.5816 2647 1 Invoice VEOLIA OVERSIGHT & AUDIT 12/07/2016 12/13/2016 4,335.78 1216 210.03.00.00.5816 Total JSA ENVIRONMENTAL, INC.:7,649.41 KARFONTA, AMY KA121316 1 Invoice Karfonta pants 12/06/2016 12/13/2016 75.67 1216 100.02.20.10.5151 Total KARFONTA, AMY:75.67 LAKELAND SUPPLY, INC. 085765 1 Invoice HOUSEKEEPING SUPPLIES 12/06/2016 12/13/2016 32.00 1216 100.05.71.00.5703 Total LAKELAND SUPPLY, INC.:32.00 LAKESIDE INTERNATIONAL TRUCKS 2121116P 1 Invoice DUST SHIELD #11 08/19/2016 12/13/2016 113.62 1216 100.04.51.07.5405 2121116PX1 1 Invoice DUST SHIELD #11 08/26/2016 12/13/2016 171.12 1216 100.04.51.07.5405 2121122P 1 Invoice KEY IGNITION #7 08/19/2016 12/13/2016 13.62 1216 100.04.51.07.5405 2124564P 1 Invoice LIGHT HEAD OLD #13 10/04/2016 12/13/2016 102.73 1216 100.04.51.07.5405 2124850P 1 Invoice FILTER ASSEMBLY KIT STR 10/07/2016 12/13/2016 547.36 1216 100.04.51.07.5405 2127288P 1 Invoice KT FILTER ASSEMBLY 11/08/2016 12/13/2016 201.28 1216 100.04.51.07.5405 2128479P 1 Invoice HOSE ASSEMBLY #12 11/22/2016 12/13/2016 92.08 1216 100.04.51.07.5405 2128479PX1 1 Invoice EXT #12 & 15 11/25/2016 12/13/2016 379.86 1216 100.04.51.07.5405 CM2107960P 1 Invoice CORE RETURN 08/22/2016 12/13/2016 598.50-1216 100.04.51.07.5405 CM2118812P 1 Invoice CORE RETURN 08/22/2016 12/13/2016 593.75-1216 100.04.51.07.5405 CM2118977P 1 Invoice CORE RETURN 08/22/2016 12/13/2016 63.84-1216 100.04.51.07.5405 CM2126322P 1 Invoice CORE RETURN 11/28/2016 12/13/2016 266.00-1216 100.04.51.07.5405 Total LAKESIDE INTERNATIONAL TRUCKS:99.58 LANGE ENTERPRISES 60264 1 Invoice ADDRESS TILES AND FRAMES 12/08/2016 12/13/2016 188.34 1216 100.02.25.00.5752 Total LANGE ENTERPRISES:188.34 LEGACY RECYCLING 0900 1 Invoice EMERALD PARK LANDFILL 11/30/2016 12/13/2016 3,040.57 1216 205.03.00.00.5820 0916 1 Invoice EMERALD PARK LANDFILL 11/30/2016 12/13/2016 1,915.44 1216 205.03.00.00.5820 Total LEGACY RECYCLING:4,956.01 LUDWIG, STEVEN LU121316 1 Invoice 2016 CLOTHING 12/02/2016 12/13/2016 150.00 1216 601.61.61.12.5702 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 9 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number LU121316 2 Invoice 2016 CLOTHING 12/02/2016 12/13/2016 150.00 1216 605.56.09.30.5228 Total LUDWIG, STEVEN:300.00 MARK J. RINDERLE TIRE INC. 121606 1 Invoice SQ 5 TIRES 11/15/2016 12/13/2016 1,034.23 1116 100.02.20.01.5405 Total MARK J. RINDERLE TIRE INC.:1,034.23 MCKINLEY CUSTOM PRODUCTS, INC 68252 1 Invoice NAME BADGE - WARCHOL 12/02/2016 12/13/2016 5.35 1216 100.01.06.00.5701 Total MCKINLEY CUSTOM PRODUCTS, INC:5.35 MEGA RENTALS INC 31994 1 Invoice SIGNS FOR WOODS RD CLOSUR 11/28/2016 12/13/2016 960.00 1216 410.08.91.19.6508 Total MEGA RENTALS INC:960.00 MIDWEST TAPE 94510033 1 Invoice AV 11/29/2016 12/13/2016 24.14 1216 100.05.71.02.5711 94524973 1 Invoice AV 11/29/2016 12/13/2016 31.49 1216 100.05.71.02.5711 94524974 1 Invoice AV 11/29/2016 12/13/2016 28.33 1216 100.05.71.02.5711 Total MIDWEST TAPE:83.96 MILLER, KATHI MI121316 1 Invoice Class Instruction Clutter Control 11/29/2016 12/13/2016 276.00 1216 100.05.72.18.5110 Total MILLER, KATHI:276.00 MILLER, SCOT MI121316 1 Invoice 2016 REIMB BOOTS & CLOTHING 12/06/2016 12/13/2016 300.00 1216 100.04.51.01.5225 Total MILLER, SCOT:300.00 MILW MET. SEWERAGE DISTRICT 249-16 1 Invoice 3RD QTR 2016 LANDFILL 11/08/2016 12/13/2016 3,704.46 1116 601.61.61.03.6072 C09-16 1 Invoice CREDIT - BETHEL CHURCH LEAK 09/09/2016 12/13/2016 166.84-1116 601.61.61.03.6072 Total MILW MET. SEWERAGE DISTRICT:3,537.62 MILWAUKEE AUDUBON SOCIETY MI121316-CD 1 Invoice BIRD CITY APPLICATION 12/07/2016 12/13/2016 100.00 1216 215.06.00.00.5305 Total MILWAUKEE AUDUBON SOCIETY:100.00 MISS BECKY LLC MI121316-2 1 Invoice Class Instruction Dance 11/29/2016 12/13/2016 90.00 1216 100.05.72.13.5110 Total MISS BECKY LLC:90.00 MUNICIPAL COURT LAKE GENEVA 11395 1 Invoice Aaron Lanza warrant 12/02/2016 12/13/2016 978.80 1216 100.01.08.00.4272 Total MUNICIPAL COURT LAKE GENEVA:978.80 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 10 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number MUSKEGO ICETRONAUT SNOWMOBILE MU121316-PR 1 Invoice Class Instruction Snowmobile Safety 11/29/2016 12/13/2016 260.00 1216 100.05.72.14.5110 Total MUSKEGO ICETRONAUT SNOWMOBILE:260.00 MUSKEGO NORWAY SCHOOL DISTRICT 0012 1 Invoice MHS West Athletic Field Expenses- 12/02/2016 12/13/2016 1,157.29 1216 100.05.72.04.5910 0012 2 Invoice MHS West Athletic Field Expenses- 12/02/2016 12/13/2016 3,889.71 1216 100.05.72.04.5915 0012 3 Invoice MHS West Athletic Field Expenses-12/02/2016 12/13/2016 9,075.00 1216 100.05.72.04.5820 0012 4 Invoice MHS West Athletic Field Expenses-J 12/02/2016 12/13/2016 2,871.00 1216 100.05.72.04.5420 Total MUSKEGO NORWAY SCHOOL DISTRICT:16,993.00 NAKED FURNITURE 21879 1 Invoice Class Instruction Painting Classes 11/29/2016 12/13/2016 94.50 1216 100.05.72.18.5110 Total NAKED FURNITURE:94.50 OCCUPATIONAL HEALTH CENTERS 102577935 1 Invoice hearing tests 12/06/2016 12/13/2016 416.00 1216 100.01.06.00.6021 Total OCCUPATIONAL HEALTH CENTERS:416.00 OLSEN SAFETY EQUIPMENT CORP. 0337527-IN 1 Invoice GLOVES - RAIN GEAR 11/18/2016 12/13/2016 311.72 1116 601.61.61.15.5425 0337527-IN 2 Invoice GLOVES - RAIN GEAR 11/18/2016 12/13/2016 311.72 1116 605.54.06.41.5702 Total OLSEN SAFETY EQUIPMENT CORP.:623.44 OSG BILLING SERVICES 400000280 1 Invoice 3RD QUARTER & POSTAGE 10/26/2016 12/13/2016 1,516.92 1116 601.61.63.42.5701 400000280 2 Invoice 3RD QUARTER & POSTAGE 10/26/2016 12/13/2016 1,516.92 1116 605.55.09.03.5710 400000280 3 Invoice 3RD QUARTER & POSTAGE 10/26/2016 12/13/2016 758.45 1116 205.03.00.00.6056 400000280 4 Invoice 3RD QUARTER & POSTAGE 10/26/2016 12/13/2016 758.45 1116 205.03.30.00.5704 Total OSG BILLING SERVICES:4,550.74 PARAGON DEVELOPMENT SYS INC 00964729 1 Invoice Additional Ram-new computers 12/02/2016 12/13/2016 63.48 1216 100.07.01.06.6501 00964873 1 Invoice New computer- Sharon 12/02/2016 12/13/2016 1,186.55 1216 100.07.01.06.6501 00965115 1 Invoice Det. Computer replacment 12/02/2016 12/13/2016 1,051.43 1216 100.07.01.06.6501 00965898 1 Invoice additional ram for new computers 12/02/2016 12/13/2016 35.80 1216 100.07.01.06.6501 Total PARAGON DEVELOPMENT SYS INC:2,337.26 PARKLAND TOWNE CENTER DEV INC PA121316-#3 1 Invoice PARKLAND TOWNE CTR GRANT #12/08/2016 12/13/2016 543,690.00 1216 411.08.91.19.6520 Total PARKLAND TOWNE CENTER DEV INC:543,690.00 PARTSMASTER 23089227 1 Invoice WASHERS ETC 11/23/2016 12/13/2016 254.55 1216 100.04.51.07.5405 Total PARTSMASTER:254.55 PAYNE & DOLAN OF WISCONSIN 1461262 1 Invoice 4.2T ASPHALT 11/17/2016 12/13/2016 185.85 1116 100.04.51.02.5740 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 11 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total PAYNE & DOLAN OF WISCONSIN:185.85 PENGUIN RANDOM HOUSE LLC 1089475577 1 Invoice AV 12/07/2016 12/13/2016 40.00 1216 100.05.71.02.5711 1089539197 1 Invoice AV 12/07/2016 12/13/2016 60.00 1216 100.05.71.02.5711 Total PENGUIN RANDOM HOUSE LLC:100.00 PINKY ELECTRIC INC. 18661 1 Invoice NORTH SHORE L/S 12/02/2016 12/13/2016 215.00 1216 601.61.61.15.5415 Total PINKY ELECTRIC INC.:215.00 PIPKE, DANIEL PI121316 1 Invoice SOCKS 12/01/2016 12/13/2016 5.90 1216 100.04.51.01.5225 Total PIPKE, DANIEL:5.90 PIRANHA PAPER SHREDDING LLC 10122111716 1 Invoice PAPER SHREDDING 12/02/2016 12/13/2016 12.50 1216 100.01.06.00.5701 1492111716 1 Invoice Monthly shred 12/06/2016 12/13/2016 30.00 1216 100.02.20.01.5723 Total PIRANHA PAPER SHREDDING LLC:42.50 PORT-A-JOHN 1264432-IN 1 Invoice RESTROOM AT ENGEL 12/01/2016 12/13/2016 75.00 1216 215.06.00.00.5801 Total PORT-A-JOHN:75.00 R.A. SMITH NATIONAL INC. 127902 1 Invoice 2016 ROAD IMPROVEMENT PROG 12/07/2016 12/13/2016 236.25 1216 100.07.51.02.6502 127903 1 Invoice PARKLAND TOWNE CENTER CON 12/07/2016 12/13/2016 4,305.45 1216 507.00.00.00.2643 127904 1 Invoice NORTH CAPE ROAD MULTI USE P 12/07/2016 12/13/2016 8,307.81 1216 202.08.94.74.6573 Total R.A. SMITH NATIONAL INC.:12,849.51 ROCK LEAGUE BASEBALL, LLC 144 1 Invoice Cooking Class Instruction @ The Ro 12/07/2016 12/13/2016 106.65 1216 100.05.72.18.5110 Total ROCK LEAGUE BASEBALL, LLC:106.65 ROZMAN TRUE VALUE/PW 22000/121316 1 Invoice MISC BUILDING SUPPLIES 11/16 11/25/2016 12/13/2016 20.94 1216 100.04.51.08.5415 Total ROZMAN TRUE VALUE/PW:20.94 ROZMAN TRUE VALUE/UTI 25000/121316 1 Invoice PARKS BUILDING ANTI FREEZE 11/25/2016 12/13/2016 28.74 1216 100.04.51.08.5415 25000/121316 2 Invoice DUMP TRUCK - UPS CHARGE 11/25/2016 12/13/2016 15.92 1216 601.61.61.21.5306 25000/121316 3 Invoice SOBECK 4S HEATER 11/25/2016 12/13/2016 19.99 1216 601.61.61.15.5415 25000/121316 4 Invoice SOBECK 4S SCRUBBER 11/25/2016 12/13/2016 8.99 1216 601.61.61.16.5411 25000/121316 5 Invoice SOBECK 4S BOOSTER 11/25/2016 12/13/2016 8.87 1216 601.61.61.16.5411 25000/121316 6 Invoice TOOLS 11/25/2016 12/13/2016 44.97 1216 601.61.61.12.5702 25000/121316 7 Invoice KNEE CUSHIONS 11/25/2016 12/13/2016 4.79 1216 601.61.61.12.5702 25000/121316 8 Invoice OIL 4S 11/25/2016 12/13/2016 219.80 1216 601.61.61.16.5411 25000/121316 9 Invoice REPAIR LINK - PARK BUILDING 11/25/2016 12/13/2016 1.58 1216 100.04.51.08.5415 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 12 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total ROZMAN TRUE VALUE/UTI:353.65 SAFEWAY PEST MANAGEMENT INC. 543967 1 Invoice PEST CONTROL 12/06/2016 12/13/2016 30.00 1216 100.05.71.00.5415 543968 1 Invoice PEST CONTROL CITY HALL - NOV 12/02/2016 12/13/2016 32.00 1216 100.01.09.00.5415 Total SAFEWAY PEST MANAGEMENT INC.:62.00 SECURIAN FINANCIAL GROUP, INC. 002832L/12131 1 Invoice LIFE INS PREMIUMS - JANUARY 2 12/08/2016 12/13/2016 2,762.89 1216 100.00.00.00.1601 Total SECURIAN FINANCIAL GROUP, INC.:2,762.89 SHERIDAN, SCOTT SH121316 1 Invoice training meals 12/06/2016 12/13/2016 20.00 1216 100.02.20.01.5301 Total SHERIDAN, SCOTT:20.00 SOBIESKI, STEPHEN SO121316 1 Invoice REIMBURSE CLOTHING 11/26/2016 12/13/2016 95.32 1216 100.04.51.01.5225 Total SOBIESKI, STEPHEN:95.32 SOMAR TEK LLC/ ENTERPRISES 100035 1 Invoice targets 12/06/2016 12/13/2016 48.00 1216 100.02.20.01.5720 10025 1 Invoice Gun cleaning supplies 12/06/2016 12/13/2016 72.95 1216 100.02.20.01.5720 Total SOMAR TEK LLC/ ENTERPRISES:120.95 SOUTHEAST PARK & REC COUNCIL SO121316 1 Invoice SEPRC Annual Dues - 2017 12/02/2016 12/13/2016 30.00 1216 100.05.72.10.5305 Total SOUTHEAST PARK & REC COUNCIL :30.00 ST. PAULS EV. LUTHERAN CHURCH ST121316 1 Invoice GENERAL ELECTION - CUSTODIA 12/02/2016 12/13/2016 50.00 1216 100.01.03.00.5704 Total ST. PAULS EV. LUTHERAN CHURCH:50.00 STARNET TECHNOLOGIES, INC 0090259-IN 1 Invoice LOOMIS 4S SERVICE 11/16/2016 12/13/2016 3,920.00 1116 601.61.61.16.5411 Total STARNET TECHNOLOGIES, INC:3,920.00 THE HAPPY MOWER 221 1 Invoice WEED CONTROL SERVICE 12/07/2016 12/13/2016 2,240.00 1216 100.04.51.01.5820 Total THE HAPPY MOWER:2,240.00 THELEN, BILL TH121316 1 Invoice BALANCE 2016 CLOTHING 12/06/2016 12/13/2016 108.35 1216 100.04.51.01.5225 Total THELEN, BILL:108.35 TIME WARNER CABLE 701507601/121 1 Invoice WAN ETHERNET CONNECT CHAR 12/08/2016 12/13/2016 180.00 1216 100.04.51.01.5506 701507601/121 2 Invoice DEDICATED INTERNET CIRCUIT 12/08/2016 12/13/2016 872.50 1216 100.01.14.00.5507 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 13 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number 703399401/121 1 Invoice 911 conn.12/06/2016 12/13/2016 178.67 1216 100.02.20.10.5604 Total TIME WARNER CABLE:1,231.17 TOLLEFSEN STEEL AND FABR, INC. TO121316 1 Invoice BUSINESS PARK GRANT 12/08/2016 12/13/2016 5,000.00 1216 402.08.96.01.6520 Total TOLLEFSEN STEEL AND FABR, INC.:5,000.00 TRANSUNION RISK & ALTERNATIVE 911461/121316 1 Invoice Reverse lookup investigations 12/06/2016 12/13/2016 25.00 1216 100.02.20.01.5722 Total TRANSUNION RISK & ALTERNATIVE:25.00 TUDOR OAKS TU121316 1 Invoice GENERAL ELECTION - CUSTODIA 12/02/2016 12/13/2016 50.00 1216 100.01.03.00.5704 Total TUDOR OAKS:50.00 USA BLUE BOOK 120991 1 Invoice VALVE - DIAPHRAM 11/30/2016 12/13/2016 300.29 1216 605.53.06.31.5702 121605 1 Invoice FUNCTION VALVE 11/30/2016 12/13/2016 339.46 1216 605.53.06.31.5702 Total USA BLUE BOOK:639.75 USA FIRE PROTECTION 251672 1 Invoice NOVEMBER 2016 QUARTERLY 12/02/2016 12/13/2016 180.00 1216 100.01.09.00.5415 251674 1 Invoice Quarterly sprinkler test 12/06/2016 12/13/2016 180.00 1216 100.02.20.01.5415 251675 1 Invoice QUARTERLY SPRINKLER INSPEC 11/29/2016 12/13/2016 180.00 1216 100.05.71.00.5415 Total USA FIRE PROTECTION:540.00 VERIZON WIRELESS 9775080948 1 Invoice Monthly Charge 12/02/2016 12/13/2016 290.79 1216 100.02.20.01.5604 Total VERIZON WIRELESS:290.79 VON BRIESEN & ROPER S.C. 224090 1 Invoice ATTORNEY FEES TIF PARKLAND 11/14/2016 12/13/2016 1,160.00 1116 411.08.91.19.5805 Total VON BRIESEN & ROPER S.C.:1,160.00 WAL-MART WA121316-PD 1 Invoice Shop with a Cop 12/02/2016 12/13/2016 100.00 1216 505.00.00.00.2637 Total WAL-MART:100.00 WAUER, TIMOTHY WA121316-DP 1 Invoice REIMBURSE CLOTHING 11/28/2016 12/13/2016 142.36 1116 601.61.61.12.5702 WA121316-DP 2 Invoice REIMBURSE CLOTHING 11/28/2016 12/13/2016 142.36 1116 605.56.09.30.5228 Total WAUER, TIMOTHY:284.72 WAUKESHA COUNTY TREASURER 2016-0000021 1 Invoice Inmate billing 12/06/2016 12/13/2016 1,138.47 1216 100.01.08.00.6017 2016-0000025 1 Invoice Radio upgrades 12/06/2016 12/13/2016 550.68 1216 410.08.91.20.6507 2016-0000025 1 Invoice #56 RADIO 11/14/2016 12/13/2016 235.76 1116 100.04.51.07.5405 WA121316-CO 1 Invoice JAIL ASSESSMENTS - NOVEMBER 12/02/2016 12/13/2016 1,162.00 1216 100.01.08.00.4269 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 14 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number WA121316-CO 2 Invoice DRIVER SURCHARGE - NOVEMBE 12/02/2016 12/13/2016 1,419.80 1216 100.01.08.00.4269 WA121316-CO 3 Invoice INTERLOCK SURCHARGE - NOVE 12/02/2016 12/13/2016 149.10 1216 100.01.08.00.4269 Total WAUKESHA COUNTY TREASURER:4,655.81 WAUKESHA POLICE DEPT. 11443 1 Invoice Joshua Dahl warrant 12/06/2016 12/13/2016 114.00 1216 100.01.08.00.4272 Total WAUKESHA POLICE DEPT.:114.00 WAUSAU EQUIPMENT COMPANY 5600928 1 Invoice WING & PLOW #12 11/30/2016 12/13/2016 78,715.00 1216 100.07.51.07.6504 Total WAUSAU EQUIPMENT COMPANY:78,715.00 WE ENERGIES 0000-020-164/1 Invoice CITY GROUP BILL - CITY HALL 12/02/2016 12/13/2016 2,831.34 1216 100.01.09.00.5910 0000-020-164/2 Invoice CITY GROUP BILL - PD 12/02/2016 12/13/2016 2,382.18 1216 100.02.20.01.5910 0000-020-164/3 Invoice CITY GROUP BILL - STREET LIGH 12/02/2016 12/13/2016 4,294.43 1216 100.04.51.06.5910 0000-020-164/4 Invoice CITY GROUP BILL - IND PARK LIG 12/02/2016 12/13/2016 621.03 1216 100.04.51.06.5910 0000-020-164/5 Invoice CITY GROUP BILL - LITTLE LAKE 12/02/2016 12/13/2016 22.64 1216 100.04.51.08.5910 0000-020-164/6 Invoice CITY GROUP BILL-GARAGE/ANNE 12/02/2016 12/13/2016 552.61 1216 100.04.51.08.5910 0000-020-164/7 Invoice CITY GROUP BILL- SEWER 25%12/02/2016 12/13/2016 276.31 1216 601.61.61.20.5910 0000-020-164/8 Invoice CITY GROUP BILL - WATER 25%12/02/2016 12/13/2016 276.31 1216 605.56.09.21.5910 0000-020-164/9 Invoice CITY GROUP BILL - PARKS 12/02/2016 12/13/2016 630.70 1216 100.04.51.08.5910 0000-020-164/10 Invoice CITY GROUP BILL - PARKS GARA 12/02/2016 12/13/2016 75.71 1216 100.04.51.08.5910 0000-020-164/11 Invoice CITY GROUP BILL - COMMERCE C 12/02/2016 12/13/2016 15.71 1216 100.04.51.08.5910 0000-020-164/12 Invoice CITY GROUP BILL - SALT SHED 12/02/2016 12/13/2016 21.62 1216 100.04.51.06.5910 0000-020-351/1 Invoice WELLS ELECTRIC - 10/16 11/29/2016 12/13/2016 5,241.04 1216 605.52.06.22.5910 0000-020-351/2 Invoice WELLS GAS - 10/16 11/29/2016 12/13/2016 12.24 1216 605.52.06.22.5910 0000-021-027/1 Invoice 10/16 GROUP 4S 11/21/2016 12/13/2016 6,069.41 1116 601.61.61.20.5910 0000-021-134/1 Invoice GROUP BILL - CITY HALL 12/02/2016 12/13/2016 275.79 1216 100.01.09.00.5910 0000-021-134/2 Invoice GROUP BILL - PD 12/02/2016 12/13/2016 46.63 1216 100.02.20.01.5910 0000-021-134/3 Invoice GROUP BILL - GARAGE 50%12/02/2016 12/13/2016 34.91 1216 100.04.51.08.5910 0000-021-134/4 Invoice GROUP BILL - SEWER 25%12/02/2016 12/13/2016 17.46 1216 601.61.61.20.5910 0000-021-134/5 Invoice GROUP BILL - WATER 25%12/02/2016 12/13/2016 17.46 1216 605.56.09.21.5910 0000-021-134/6 Invoice GROUP BILL - PARKS 12/02/2016 12/13/2016 127.63 1216 100.04.51.08.5910 0000-021-134/7 Invoice GROUP BILL - PARKS GARAGE 12/02/2016 12/13/2016 29.49 1216 100.04.51.08.5910 0456-343-427/1 Invoice 11/16 PIONEER ELECTRIC 12/02/2016 12/13/2016 21.05 1216 601.61.61.20.5910 1222-851-033/1 Invoice 10/16 WELL 9 ELECTRIC 11/21/2016 12/13/2016 457.05 1116 605.52.06.22.5910 1222-851-033/2 Invoice 10/16 WELL 9 GAS 11/21/2016 12/13/2016 11.30 1116 605.52.06.22.5910 2014-674-485/1 Invoice Firing Range 12/06/2016 12/13/2016 22.92 1216 100.02.20.01.6023 3556-286-012/1 Invoice STREET LIGHTING 12/08/2016 12/13/2016 3,680.18 1216 100.04.51.06.5910 3836-104-158/1 Invoice 11/16 GROUP L/S 12/01/2016 12/13/2016 950.77 1216 601.61.61.20.5910 5024-948-351/1 Invoice 10/16 GAS HILLENDALE 12/02/2016 12/13/2016 27.97 1216 605.52.06.22.5910 5499-564-961/1 Invoice LIBRARY - GAS 12/08/2016 12/13/2016 1,072.06 1216 100.05.71.00.5910 5499-564-961/2 Invoice LIBRARY - ELECTRIC 12/08/2016 12/13/2016 4,481.13 1216 100.05.71.00.5910 5499-564-961/3 Invoice HISTORICAL SOCIETY 12/08/2016 12/13/2016 152.44 1216 100.05.72.03.5910 5499-564-961/4 Invoice HIST SOCIETY POLE LIGHT 12/08/2016 12/13/2016 13.47 1216 100.04.51.08.5910 5499-564-961/5 Invoice VET PARK ARCH 12/08/2016 12/13/2016 20.33 1216 100.04.51.08.5910 5499-564-961/6 Invoice VET PARK FOUNTAIN 12/08/2016 12/13/2016 55.97 1216 100.04.51.08.5910 5499-564-961/7 Invoice PAVILION 12/08/2016 12/13/2016 90.94 1216 100.04.51.08.5910 5499-564-961/8 Invoice AREA LIGHTS 12/08/2016 12/13/2016 114.00 1216 100.04.51.08.5910 5499-564-961/9 Invoice VET PARK LIGHTS 12/08/2016 12/13/2016 60.87 1216 100.04.51.08.5910 6673-530-586/1 Invoice 10/16 RACINE 12/05/2016 12/13/2016 16.65 1216 601.61.61.20.5910 9495-306-298/1 Invoice 11/16 RYAN ELECTRIC 11/18/2016 12/13/2016 19.91 1116 601.61.61.20.5910 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 15 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total WE ENERGIES:35,141.66 WELDERS SUPPLY COMPANY 424045 1 Invoice OXYGEN - ACETYLENE 11/16/2016 12/13/2016 73.10 1116 100.04.51.07.5704 Total WELDERS SUPPLY COMPANY:73.10 WERNER, ANDREW WE121316 1 Invoice 2016 REIMB 12/05/2016 12/13/2016 300.00 1216 100.04.51.01.5225 Total WERNER, ANDREW:300.00 WILDE, JODI 242626 1 Invoice Class Cancellation Refund 11/29/2016 12/13/2016 14.00 1216 100.00.00.00.2110 242627 1 Invoice Class Cancellation Refund 11/29/2016 12/13/2016 52.00 1216 100.00.00.00.2110 Total WILDE, JODI:66.00 WIND LAKE AUTO PARTS 1975/121316 1 Invoice SQ 5 - ROTORS & PADS 11/30/2016 12/13/2016 135.86 1216 100.02.20.01.5405 1975/121316 2 Invoice MOWER & LIFT SUPPORT 11/30/2016 12/13/2016 17.84 1216 601.61.61.21.5306 1975/121316 3 Invoice MOWER & LIFT SUPPORT 11/30/2016 12/13/2016 38.52 1216 601.61.61.21.5306 1975/121316 4 Invoice TRUCKS 14 & 17 LEAF SUCKER 11/30/2016 12/13/2016 631.95 1216 100.04.51.07.5405 Total WIND LAKE AUTO PARTS:824.17 WIS RURAL WATER ASSOC 3084 1 Invoice SAFETY AUDIT 11/14/2016 12/13/2016 49.88 1116 601.61.61.15.5425 3084 2 Invoice SAFETY AUDIT 11/14/2016 12/13/2016 99.76 1116 100.04.51.01.5228 3084 3 Invoice SAFETY AUDIT 11/14/2016 12/13/2016 49.88 1116 605.54.06.41.5702 549 1 Invoice SAFETY HANDBOOK UPDATE 12/02/2016 12/13/2016 292.93 1216 601.61.61.15.5425 549 2 Invoice SAFETY HANDBOOK UPDATE 12/02/2016 12/13/2016 292.92 1216 605.54.06.41.5702 Total WIS RURAL WATER ASSOC:785.37 WISCONSIN BUILDING INSPECTION, LLP 146/121316 1 Invoice NOVEMBER PERMITS AND INSPE 12/07/2016 12/13/2016 13,569.77 1216 100.02.25.00.5820 Total WISCONSIN BUILDING INSPECTION, LLP:13,569.77 WISCONSIN DEPARTMENT OF REVENUE DOR121316 1 Invoice ASSESSMENT FEE - MANF PROP 12/08/2016 12/13/2016 4,651.77 1216 100.01.04.00.5801 Total WISCONSIN DEPARTMENT OF REVENUE:4,651.77 WISCONSIN DEPT OF ADMIN WI121316-CO 1 Invoice COURT FEES - NOVEMBER 12/02/2016 12/13/2016 8,133.23 1216 100.01.08.00.4269 Total WISCONSIN DEPT OF ADMIN:8,133.23 WISCONSIN DEPT OF JUSTICE - CIB L6806T/12131 1 Invoice RECORD NAME SEARCHES 12/08/2016 12/13/2016 105.00 1216 100.01.06.00.6002 Total WISCONSIN DEPT OF JUSTICE - CIB:105.00 WORLD BOOK, INC. 0001545793 1 Invoice PRINT 12/07/2016 12/13/2016 999.00 1216 100.05.71.01.5711 CITY OF MUSKEGO Payment Approval Report - Board Report Alpha Page: 16 Report dates: 11/23/2016-12/13/2016 Dec 08, 2016 02:55PM Invoice Number SeqNo Type Description Invoice Date Payment Due Date Total Cost GL Period GL Account Number Total WORLD BOOK, INC.:999.00 WPRA 659-17 1 Invoice 2017 WPRA Annual Dues 12/07/2016 12/13/2016 130.00 1216 100.05.72.10.5305 Total WPRA:130.00 ZEPHYR BELLYDANCE 11.17.2016 1 Invoice Class Instruction Belly Dance 11/29/2016 12/13/2016 219.17 1216 100.05.72.13.5110 Total ZEPHYR BELLYDANCE:219.17 ZIMMERMAN ARCHITECTURAL STUDIOS 55255 1 Invoice CITY HALL FACILITY 12/08/2016 12/13/2016 18,916.82 1216 410.08.90.09.6550 55392 1 Invoice CITY HALL FACILITY 12/08/2016 12/13/2016 6,979.55 1216 410.08.90.09.6550 55728 1 Invoice CITY HALL FACILITY 12/08/2016 12/13/2016 6,979.55 1216 410.08.90.09.6550 Total ZIMMERMAN ARCHITECTURAL STUDIOS:32,875.92 Grand Totals: 933,668.28 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 December 13th, 2016, Finance Committee Meeting Major Projects and Activities being worked on within the Finance & Administration Department: Elections – Staff and poll workers encountered very few issues during the November 8th Fall General Election. Resident inquiries included having more ‘I Voted’ stickers available since various business promotions were being offered for having voted; and periodic line wait times due to the split poll books. The Wisconsin Election Recount began on December 1st. All ballots for Muskego were reconciled and recounted at the Waukesha County Administration Building on Monday, December 5th. The results indicated an increase of 0.07% (.00066) or 10 votes out of 15,069 from the original count totals (+6 Trump, +5 Clinton & -1 De La Fuente). 2016 Tax Roll/Rates/Bills – As compared to 2015, the total tax rate decreased by $0.07 or 0.44% per $1000 of assessed value. Following review and reconciliation of the tax roll, Waukesha County was directed to post tax bills to their website on December 2nd. Due to changes with the equated manufacturing rolls at the State level, the tax billing process was delayed. The Finance staff has continued to improve the accounts receivable module this year by importing additional customer data which should allow for more immediate collection processing. 2016 Audit – The preliminary audit is scheduled to begin on January 10th, with the final audit fieldwork scheduled for May 1st – May 12th, 2017. City Liability Insurance – The required insurance applications in preparation for renewal rates were submitted to R&R Insurance on September 23rd. Rate renewal information will be supplied to the City on December 19th. 2017 Budgets – Adopted Budgets have been uploaded to the City’s financial system and have been posted to the website. Payroll/Benefit Administration – • 3rd Quarter Federal & State Payroll Tax Reports reconciled and submitted to the IRS and State Department of Revenue on October 14th. • Imputed income for affected employees has been calculated and will be processed with the December payroll along with informational memos provided to staff. • Year-end payroll information was distributed electronically to employees on November 22nd. Staff will also be working with employees over the next few weeks to process any requested changes along with performing account reconciliations in preparation of W-2 processing, which are expected to be distributed in early January since the last pay period of the year falls on December 29th. • The new web based MiPay site implemented this year for employees to view and print their pay stubs and W- 2 Forms appears to be working very well and has saved the City supply costs & staff time. FINANCE & ADMIN. DIRECTOR’S REPORT 12/13/16 PAGE 2 2 Investments – No changes to report since last quarterly report. Year-to-date results indicate an increase of $24,500 of interest earnings as compared to the prior year. Borrowing/Debt Issuance – On November 1st, $2,866,170 of Taxable General Obligation Promissory Notes were issued as authorized by Council on October 25th for the purpose of financing the Parkland Towne Center grant requests for specific site work. The advantages of selling this short-term note to First Business Bank is that the City has the ability to request disbursements on an ‘as-needed’ basis and that interest will not begin to accrue until that time. Total borrowing is anticipated to be $1 million less than the authorized debt issuance due to a $500,000 potential WEDC grant and $500,000 of internal funding from the Special Revenue TIF Residual fund. MMSD Housing Survey Report – The 3rd quarter Housing report was completed and submitted to the Milwaukee Metropolitan Sewer District (MMSD) as required. 3rd Quarter Utility Bills – Processed and reconciled in timely manner. Wisconsin Revolving Loan Fund Semi-Annual Report Certification – Reconciled and submitted to the Department of Commerce by required due date. Licensing – The Dog license reconciliation report was submitted to Waukesha County on November 25th. Application and informational documents have been updated for 2017. Other Projects – Continued progression as follows: • Electronic Payment processing – Customers may now create a profile and acquire their utility account balance information when making a payment. • miTime (electronic timekeeping) – All Departments are utilizing this program with the exception of the Police Department, which should be implemented by year-end. • Accounts Payable Workflow – All invoices are being processed electronically through SIRE workflow, which are then routed to Department Heads for general ledger coding and approval. This is followed by a batch file upload directly into the financial system. 3rd Quarter, 2016 General Fund Operating Results – See attached. The attached worksheets recap the City’s General Fund operating results for the third quarter ending September 30th, 2016. As reported, the year-to-date expenditures are under budget by 31.02%, which is within 0.87% of the prior year; and a very comfortable position in relation to the 25% benchmark (3 months remaining October-December/12 months). Compared to the prior year, third quarter net revenues over expenditures resulted in an increase of $5,769 or 0.19%. Contributing to this increase is additional revenue recognized in court fines & forfeitures, investment earnings and taxes. With only three weeks of the year remaining, current projections indicate year-end results should remain extremely positive. Please note the ‘Miscellaneous’ revenue category will reflect a transfer in the 4th quarter to allocate interest earnings to various special revenue and capital funds. Should you have any questions, please email or contact me at (262) 679-5622. Thank you. September 30, 2016 Budget Actual Over/(Under) % Over/(Under)Revenue Comparison Taxes $10,251,398 $10,243,910 -$7,488 -0.07% Intergovernmental $1,824,559 $1,106,187 -$718,372 -39.37% Licenses and Permits $747,712 $581,381 -$166,330 -22.25% Fines, Forfeits and Penalties $207,000 $293,302 $86,302 41.69% Public Charges for Services $671,831 $684,282 $12,451 1.85% Intergov. Charges for Services $146,200 $74,380 -$71,820 -49.12% Miscellaneous $237,870 $248,837 $10,967 4.61% Other Financing Sources $574,000 $11,410 -$562,590 -98.01% Interdepartmental $217,150 $48,269 -$168,881 -77.77% Total Revenue $14,877,720 $13,291,957 ($1,585,763) -10.66% 2016 Budget Quarter 3 Results: REVENUES General Fund - Annual Operating Results 77% 8% 5% 2%5% 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 September 30, 2016 General Government Budget Actual Over/(Under) % Over/(Under)Actual Cost Breakdown Common Council/Mayor $205,578 $143,274 -$62,304 -30.31% Finance & Administration $612,038 $404,068 -$207,970 -33.98% Assessor $147,375 $81,935 -$65,440 -44.40% Attorney $110,133 $67,824 -$42,309 -38.42% Non-Departmental $574,517 $497,639 -$76,878 -13.38% Municipal Court $195,228 $134,328 -$60,899 -31.19% Building Maintenance $192,162 $124,872 -$67,290 -35.02% Information Technology $339,739 $160,571 -$179,167 -52.74% Bank Service Charges $18,000 $16,473 -$1,527 -8.48% Total $2,394,770 $1,630,985 -$763,785 -31.89% Public Safety Budget Actual Over/(Under) % Over/(Under) Police - Sworn Officers $4,639,586 $3,107,263 -$1,532,323 -33.03% Police - Dispatch & Clerical $666,501 $463,210 -$203,291 -30.50% Volunteer Fire $790,765 $348,750 -$442,015 -55.90% Non-Departmental $20,511 $19,031 -$1,480 -7.22% Building Inspection $247,443 $186,210 -$61,233 -24.75% Total $6,364,807 $4,124,464 -$2,240,343 -35.20% Health & Human Services Budget Actual Over/(Under) % Over/(Under) Animal Warden $3,600 $3,581 -$19 -0.53% Public Safety Supplies & Expenses $50 $0 -$50 -100.00% Total $3,650 $3,581 -$69 -1.89% Public Works Budget Actual Over/(Under) % Over/(Under)Budget vs. Actual Engineering $196,512 $134,473 -$62,039 -31.57% Public Works $2,381,604 $1,709,781 -$671,823 -28.21% Total $2,578,116 $1,844,255 -$733,862 -28.47% Culture, Recreation & Education Budget Actual Over/(Under) % Over/(Under) Parade Fund & Little Lake District $59,500 $58,943 -$557 -0.94% Library $1,233,258 $825,719 -$407,539 -33.05% Parks $29,275 $7,926 -$21,349 -72.93% Recreation $564,764 $425,326 -$139,438 -24.69% Total $1,886,797 $1,317,915 -$568,882 -30.15% Conservation & Development Budget Actual Over/(Under) % Over/(Under) Planning, Conservation & Development $381,244 $268,299 -$112,945 -29.63% Total $381,244 $268,299 -$112,945 -29.63% Capital Outlay-Operations Budget Actual Over/(Under) % Over/(Under) Computer Replacements $18,000 $12,075 -$5,926 -32.92% Police Vehicle Replacements $77,700 $75,636 -$2,064 -2.66% Road Program $700,000 $676,686 -$23,314 -3.33% Public Works Vehicle Replacements $185,000 $95,100 -$89,900 -48.59% Contingency $74,025 $0 -$74,025 -100.00% Transfer to Capital from GF $213,610 $213,610 $0 0.00% Total $1,268,335 $1,073,106 -$195,229 -15.39% Total Expenditures Budget Actual Over/(Under) % Over/(Under) $14,877,719 $10,262,606 ($4,615,113)-31.02% 2016 Budget Quarter 3 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 16% 40% 0% 18% 13% 3%10% General Government Public Safety Health & Human Services Public Works Culture, Recreation & Education Conservation & Development Capital Outlay-Operations September 30, 2016 2016 2015 Comparison Revenues vs. Expenditures Total Revenues $13,291,957 $12,975,332 $316,625 Total Expenditures $10,262,606 $9,951,750 $310,855 Total Surplus/(Deficit) $3,029,351 $3,023,582 $5,769 General Fund - Annual Operating Results Quarter 3 Budget Results - 2016 vs. 2015 $0 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 2016 2015