Loading...
HomeMy WebLinkAboutFS 2016-12-06 COMPLETE AGENDA PACKETCity of Tukwila Finance and Safety Committee O Verna Seal, Chair O Dennis Robertson O Kate Kruller AGENDA Distribution: Recommended Action V. Seal C. O'Flaherty D. Robertson R. Turpin K. Kruller L. Humphrey K. Hougardy R. Bianchi T. McLeod B. Giberson Mayor Ekberg L. Richardson D. Cline V. Carlsen P. McCarthy M. Villa TUESDAY, DECEMBER 6, 2016 — 5:30 PM HAZELNUT CONFERENCE ROOM (formerly known as CR #3) at east entrance of City Hall Item Recommended Action Page 1. PRESENTATION(S) 2. BUSINESS AGENDA a. A resolution adopting a legislative agenda for 2017. a. Forward to 12/12 C.O.W. Pg.i Rachel Bianchi, Communications and Government and Special Mtg. Relations Manager b. An agreement for the Public Safety Plan. b. Forward to 12/12 C.O.W. Pg.9 Bob Giberson, Public Works Director and Special Mtg. c. Grant funding for a Disposition Research Specialist c. Forward to 12/12 Pg.27 position in the Police Department. Consent Agenda. Leon Richardson, Police Records Manager d. 2016 2nd Quarter Investment Report. d. Information only. Pg.55 Vicky Carlsen, Deputy Finance Director e. 2016 3rd Quarter sales tax report. e. Information only. Pg.63 Vicky Carlsen, Deputy Finance Director f. 2016 3rd Quarter Police Department Report. f. Information only. Pg. 71 Mike Villa, Police Chief 3. ANNOUNCEMENTS 4. MISCELLANEOUS Next Scheduled Meeting: January 2017 SThe City of Tukwila strives to accommodate individuals with disabilities. Please contact the City Clerk's Office at 206 - 433 -1800 (TukwilaCityClerk @TukwilaWA.gov) for assistance. City of Tukwila Allan Ekberg, Mayor TO: Finance and Safety Committee Community Affairs and Parks Committee FROM: Rachel Bianchi, Communications and Government Relations Manager CC: Mayor Ekberg RE: 2017 Legislative Agenda DATE: October 27, 2016 ISSUE Each year the City develops a legislative agenda for the upcoming session. The Council is being asked to approve the agenda for 2017. BACKGROUND Staff reviewed legislative agendas from a variety of organizations, including the Association of Washington Cities, as well as the 2017/2018 adopted priorities to ensure alignment with the draft agenda attached. The draft agenda was shared with Dr. Nancy Coogan and Director Dave Larson at the Tukwila School District to ensure alignment, particularly around education issues. In addition, staff wanted the opportunity to inform you that the Communications Division will be contracting with Jennifer Ziegler to represent the City in Olympia in the coming session. Ms. Ziegler comes highly recommended and has a very strong background in transportation and other issues. While the contract is below the mayor's signing authority, staff wanted to ensure Councilmembers are well informed. An opportunity for the Council to meet Ms. Ziegler will be developed in December. RECOMMENDATION Staff requests Committee provide feedback on the draft legislative agenda, including requested edits, and then forward to the Committee of the Whole and Special Meeting to follow on December 12, 2016. ATTACHMENTS Draft Resolution adopting a 2017 Legislative Agenda Resume of Jennifer Ziegler DRA�+T A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF TUKWILA, WASHINGTON, ADOPTING A LEGISLATIVE AGENDA FOR USE DURING THE 2017 WASHINGTON STATE LEGISLATIVE SESSION. WHEREAS, the City Council has agreed to pursue certain legislative issues for 2017; and WHEREAS, the City Council recognizes this agenda is not all encompassing, in that certain additional items may arise during the legislative session that require support or opposition; and WHEREAS, a legislative agenda outlines the priority issues that elected officials may discuss when speaking to members of the Washington State Legislature; and WHEREAS, the City Council agreed to these priorities at the Special City Council Meeting on December 12, 2016; NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF TUKWILA, WASHINGTON, HEREBY RESOLVES AS FOLLOWS: The Tukwila City Council has identified priorities for the 2017 Washington State Legislative Session that provide a framework for advocacy on behalf of the community. The City of Tukwila 2017 Legislative Agenda is hereby incorporated by reference as Attachment A. PASSED BY THE CITY COUNCIL OF THE CITY OF TUKWILA, WASHINGTON, at a Special Meeting thereof this day of 12016. ATTEST/AUTHENTICATED: Christy O'Flaherty, MMC, City Clerk I Joe Duffie, Council President Filed with the City Clerk: Passed by the City Council: Resolution Number: Rachel B. Turpin, City Attorney Attachment A: City of Tukwila 2017 Legislative Agenda w:\word Processing\Resolutions\Legislative Agenda for 2017 11-22-16 RB:bjs Page 1 of 1 rG] El City of Tukwila 2017 Legislative Agenda Transportation & Infrastructure • Join the US DOT, Freight Mobility Strategic Investment Board, the City of Tukwila and other partners to fund the Strander Extension project to increase freight mobility and remove 55,000 vehicles a day from 1-405, 167 and other nearby roadways. • Create stable, reliable infrastructure assistance funding for cities to assist in repairing roads, bridges and other public infrastructure that support economic development. Housing & Human Services • Provide future stable funding for homelessness by eliminating the sunset and increasing the document recording fee. • Create new local options to generate revenue for housing and human services and for capital construction of affordable housing. the health • We strongly encourage the state to adequately fund human services programs for of the safety net. Shared Revenue • The State must continue its role as a partner with cities. • Maintaining existing programs such as Streamlined Sales Tax Mitigation Payments, which provides Tukwila over $1.1 million annually, is part of this partnership. • In addition, the state must retain the local share of liquor taxes to allow jurisdictions to address impacts, such as public safety, of privatized liquor in our cities. Revenue Reform • Allow cities the authority and flexibility to address the fact that growth in the cost of services continue to outstrip revenues. • The state should amend the law that limits annual property tax growth to 1 percent and work with cities to authorize additional funding flexibility and opportunities at the local level. Public Records • Provide cities with additional tools to address public disclosure requests that are voluminous, overly broad, commercially- driven or retaliatory in nature. • The City of Tukwila is committed to — and has a long history of — making public documents as accessible as possible; however, many of the more onerous public disclosure requests require an inappropriate use of tax payer dollars, particularly when subsidizing requests tied to commercial or personal gain. Education • Implement needs based funding for allocation of social emotional student support resources and expand funding for learning opportunities for summer school students. • Increase funding for homeless students and secondary ELL students. • Incorporate early learning for low income students as a part of Basic Education. Law Enforcement • Increase funding for law enforcement training to ensure that all police officers have access to key resources that save lives. A Jennifer Hanlon Ziegler 1127 Arcadia Street NW Olympia, WA 98502 • (360) 790 -6089 Employment OWNER JANUARY 2013- CURRENT Jennifer Ziegler Public Affairs Consulting Provide public affairs services in legislative advocacy, government relations and strategic communications. Clients include HNTB Corporation, Patrick Dunn and Associates, the Small and Mid -Size Transit Alliance, Washington State Association of Counties, the Washington State Patrol Captains and Lieutenants, Woodland Park Zoo, and the Cities of Burien, Cheney and Edmonds. EXECUTIVE POLICY ADVISOR AND LEGISLATIVE DIRECTOR 2006 -2009 AND 2011 -2013 Governor Gregoire's Executive Policy Office Advised Governor Gregoire on transportation issues, including the replacement of the Alaskan Way Viaduct, the State Route 520 bridge project and transportation funding options. Developed partnerships with stakeholders on behalf of the Governor's office. Staffed the Governor's Connecting Washington task force regarding transportation funding. Participated in the development of the Governor's budget proposals, managed the Governor's outreach staff and provided advice to the Governor on legislative strategy. DIRECTOR OF GOVERNMENT RELATIONS AND COMMUNICATIONS 2009 -2011 Toll Division, Washington State Department of Transportation Drafted legislation and coordinated advocacy efforts for bills providing for the implementation of tolling on SR 520 and authorizing express toll lanes on I -405. Developed communications plans and supervised marketing efforts related to tolling on the Tacoma Narrows Bridge, SR 167 High Occupancy Toll Lanes and SR 520. DIRECTOR OF GOVERNMENT RELATIONS 2005 -2006 Washington State Department of Transportation Developed and implemented the legislative agenda for the Washington State Department of Transportation (WSDOT) on a range of issues including apprenticeship participation on transportation projects and vessel procurement for the state ferry system. Coordinated the 7 legislative activities of WSDOT, which included tracking legislation pertaining to multiple topics and providing the Legislature with an integrated response to issues from WSDOT programs. EXECUTIVE DIRECTOR Washington State Transportation Commission 2003 -2005 Advised Transportation Commissioners on transportation policy issues, including transportation revenue, state and regional governance issues and the movement of freight in Washington. Coordinated the Transportation Commission's rule - making activities. STAFF COUNSEL Senate Committee Services 10 11 Advised Senators on legal issues regarding the state transportation budget and drafted transportation budget legislation. Presented legislation at Committee hearings. Supervised legal and policy staff working for the Commerce and Trade Committee. Education JURIS DOCTOR Seattle University School of Law BACHELOR OF SCIENCE IN POLITICAL SCIENCE Emporia State University Memberships and Related Activities Member, Washington State Bar Association Board Member, Washington Highway Users Federation Vice President, Olympia School District Education Foundation Board Member, Association of Washington Business Board Member, WSDOT Memorial Foundation Ziegler Resume 1993 -1996 Tacoma, WA 1989 -1993 Emporia, KS Tukwila Attan Ekberg, Mayor Public Works Department - Bob Giberson, Director TO: Mayor Ekberg FROM: Bob Giberson, Public Works Director DATE: October 5, 2016 SUBJECT: Public Safety Plan Project Management Services Consultant Selection and Agreement for Project Management Services ISSUE Approve Shiels Obletz Johnsen (SOJ) to perform Phase 1 Project Management Services for the Public Safety Plan. _ . rT:7�11P► f�7 On August 18 and 25, 2016 the City advertised a Request for Proposals for Project Management (PM) Services on the Public Safety Plan projects. Two proposals were received and both firms were interviewed. ANALYSIS As shown on attached evaluation matrix, based on experience and qualifications, SOJ ranked higher than Hill International after thoroughly reviewing proposals and conducting interviews. Hill International also has a lot of experience in large public facility projects. SOJ is exceptionally knowledgeable and experienced with large public facility projects and alternative project delivery methods such as GC /CM (General Contractor /Construction Manager). SOJ has provided similar PM services for numerous large local projects including: Burien Town Square, ShoWare Event Center, SCORE Jail, Seattle City Hall and Seattle Police Headquarters. FISCAL IMPACT The Public Safety Bond projects and cost model include all estimated amounts for architectural, engineering and project management fees, as presented to the Finance and Safety Committee. The recommended and negotiated contract amount with SOJ is within the overall Public Safety Plan project budgets. RECOMMENDATION Approve the agreement for $2,694,716 with Shiels Obletz Johnsen for Project Management Services for the Public Safety Plan projects. Attachments: Consultant Selection Matrix Consultant Agreement with Exhibits A, B & C wApw eng \projects \a - bg projects \public safety plan \rfp and evaluation \info memo consultant selection and contract - soj.docx 9 10 City of Tukwila Contract Number: • 6200 Southcenter Boulevard, Tukwila WA 98188 CONSULTANT AGREEMENT FOR PROJECT MANAGEMENT SERVICES THIS AGREEMENT is entered into between the City of Tukwila, Washington, hereinafter referred to as "the City ", and Shiels Obletz Johnsen (SOJ), hereinafter referred to as "the Consultant ", in consideration of the mutual benefits, terms, and conditions hereinafter specified. 1. Project DesiLFnation. The Consultant is retained by the City to perform Property Management services in connection with the project titled Public Safety Plan. 2. Scone of Services. The Consultant agrees to perform the services, identified on Exhibit "A" attached hereto, including the provision of all labor, materials, equipment and supplies. 3. Duration of Agreement; Time for Performance. This Agreement shall be in full force and effect for a period commencing upon execution and ending March 31, 2021, unless sooner terminated under the provisions hereinafter specified. Work under this Agreement shall commence upon written notice by the City to the Consultant to proceed. The Consultant shall perform all services and provide all work product required pursuant to this Agreement no later than March 31, 2021, unless an extension of such time is granted in writing by the City. 4. Payment. The Consultant shall be paid by the City for completed work and for services rendered under this Agreement as follows: A. Payment for the work provided by the Consultant shall be made as provided on Exhibit "B" and "C" attached hereto, provided that the total amount of payment to the Consultant shall not exceed $2,694,716 without express written modification of the Agreement signed by the City. B. The Consultant may submit invoices to the City once per month during the progress of the work for partial payment for that portion of the project completed to date. Such invoices will be checked by the City and, upon approval thereof, payment shall be made within thirty (30) days to the Consultant in the amount approved. C. Final payment of any balance due the Consultant of the total contract price earned will be made promptly upon its ascertainment and verification by the City after the completion of the work under this Agreement and its acceptance by the City. D. Payment as provided in this section shall be full compensation for work performed, services rendered, and for all materials, supplies, equipment and incidentals necessary to complete the work. E. The Consultant's records and accounts pertaining to this Agreement are to be kept available for inspection by representatives of the City and the state of Washington for a period of three (3) years after final payments. Copies shall be made available upon request. 11 5. Ownership and Use of Documents. All documents, drawings, specifications and other materials produced by the Consultant in connection with the services rendered under this Agreement shall be the property of the City whether the project for which they are made is executed or not. The Consultant shall be permitted to retain copies, including reproducible copies, of drawings and specifications for information, reference and use in connection with the Consultant's endeavors. The Consultant shall not be responsible for any use of the said documents, drawings, specifications or other materials by the City on any project other than the project specified in this Agreement. 6. Compliance with Laws. The Consultant shall, in performing the services contemplated by this Agreement, faithfully observe and comply with all federal, state, and local laws, ordinances and regulations, applicable to the services rendered under this Agreement. 7. Indemnification. The Consultant shall defend, indemnify and hold the City, its officers, officials, employees and volunteers harmless from any and all claims, injuries, damages, losses or suits including attorney fees, arising out of or resulting from the acts, errors or omissions of the Consultant in performance of this Agreement, except for injuries and damages caused by the negligence of the City. Should a court of competent jurisdiction determine that this Agreement is subject to RCW 4.24.115, then, in the event of liability for damages arising out of bodily injury to persons or damages to property caused by or resulting from the concurrent negligence of the Consultant and the City, its officers, officials, employees, and volunteers, the Consultant's liability hereunder shall be only to the extent of the Consultant's negligence. It is further specifically and expressly understood that the indemnification provided herein constitutes the Consultant's waiver of immunity under Industrial Insurance, Title 51 RCW, solely for the purposes of this indemnification. This waiver has been mutually negotiated by the parties. The provisions of this section shall survive the expiration or termination of this Agreement. The City shall defend, indemnify and hold the City, its officers, officials, employees harmless from any and all claims, injuries, damages, losses or suits including attorney fees, arising out of or resulting from the acts, errors or omissions of the City in performance of this Agreement, except for injuries and damages caused by the negligence of the Consultant. 8. Insurance. The Consultant shall procure and maintain for the duration of the Agreement, insurance against claims for injuries to persons or damage to property which may arise from or in connection with the performance of the work hereunder by the Consultant, its agents, representatives, or employees. Consultant's maintenance of insurance as required by the agreement shall not be construed to limit the liability of the Consultant to the coverage provided by such insurance, or otherwise limit the City's recourse to any remedy available at law or in equity. A. Minimum Amounts and Scope of Insurance. Consultant shall obtain insurance of the types and with the limits described below: CA revised : 1 -2013 12 1. Automobile Liability insurance with a minimum combined single limit for bodily injury and property damage of $1,000,000 per accident. Automobile Liability insurance shall cover all owned, non - owned, hired and leased vehicles. Coverage shall be written on Insurance Services Office (ISO) form CA 00 01 or a substitute form providing equivalent liability coverage. If necessary, the policy shall be endorsed to provide contractual liability coverage. Page 2 2. Commercial General Liability insurance with limits no less than $1,000,000 each occurrence, $2,000,000 general aggregate. Commercial General Liability insurance shall be written on ISO occurrence form CG 00 01 and shall cover liability arising from premises, operations, independent contractors and personal injury and advertising injury. The City shall be named as an insured under the Consultant's Commercial General Liability insurance policy with respect to the work performed for the City. 3. Workers' Compensation coverage as required by the Industrial Insurance laws of the State of Washington. 4. Professional Liability with limits no less than $1,000,000 per claim and $1,000,000 policy aggregate limit. Professional Liability insurance shall be appropriate to the Consultant's profession. B. Other Insurance Provision. The Consultant's Automobile Liability and Commercial General Liability insurance policies are to contain, or be endorsed to contain that they shall be primary insurance with respect to the City. Any Insurance, self - insurance, or insurance pool coverage maintained by the City shall be excess of the Consultant's insurance and shall not be contributed or combined with it. C. Acceptability of Insurers. Insurance is to be placed with insurers with a current A.M. Best rating of not less than A:VII. D. Verification of Coverage. Consultant shall furnish the City with original certificates and a copy of the amendatory endorsements, including but not necessarily limited to the additional insured endorsement, evidencing the insurance requirements of the Consultant before commencement of the work. Certificates of coverage and endorsements as required by this section shall be delivered to the City within fifteen (15) days of execution of this Agreement. E. Notice of Cancellation. The Consultant shall provide the City with written notice of any policy cancellation, within two business days of their receipt of such notice. F. Failure to Maintain Insurance. Failure on the part of the Consultant to maintain the insurance as required shall constitute a material breach of contract, upon which the City may, after giving five business days notice to the Consultant to correct the breach, immediately terminate the contract or, at its discretion, procure or renew such insurance and pay any and all premiums in connection therewith, with any sums so expended to be repaid to the City on demand, or at the sole discretion of the City, offset against funds due the Consultant from the City. 9. Independent Contractor. The Consultant and the City agree that the Consultant is an independent contractor with respect to the services provided pursuant to this Agreement. Nothing in this Agreement shall be considered to create the relationship of employer and employee between the parties hereto. Neither the Consultant nor any employee of the Consultant shall be entitled to any benefits accorded City employees by virtue of the services provided under this Agreement. The City shall not be responsible for withholding or otherwise deducting federal income tax or social security or for contributing to the state industrial insurance program, otherwise assuming the duties of an employer with respect to the Consultant, or any employee of the Consultant. CA revised : 1 -2013 Page 3 13 10. Covenant A14ainst ContinlZent Fees. The Consultant warrants that lie has not employed or retained any company or person, other than a bonafide employee working solely for the Consultant, to solicit or secure this contract, and that he has not paid or agreed to pay any company or person, other than a bonafide employee working solely for the Consultant, any fee, commission, percentage, brokerage fee, gifts, or any other consideration contingent upon or resulting from the award or making of this contract. For breach or violation of this warrant, the City shall have the right to annul this contract without liability, or in its discretion to deduct from the contract price or consideration, or otherwise recover, the full amount of such fee, commission, percentage, brokerage fee, gift, or contingent fee. 11. Discrimination Prohibited. The Consultant, with regard to the work performed by it under this Agreement, will not discriminate on the grounds of race, religion, creed, color, national origin, age, veteran status, sex, sexual orientation, gender identity, marital status, political affiliation or the presence of any disability in the selection and retention of employees or procurement of materials or supplies. 12. Assignment. The Consultant shall not sublet or assign any of the services covered by this Agreement without the express written consent of the City. 13. Non - Waiver. Waiver by the City of any provision of this Agreement or any time limitation provided for in this Agreement shall not constitute a waiver of any other provision. 14. Termination. A. The City reserves the right to terminate this Agreement at any time by giving ten (10) days written notice to the Consultant. In the event of Termination, City shall pay Consultant for work completed by the Consultant up to the date of Termination. B. In the event of the death of a member, partner or officer of the Consultant, or any of its supervisory personnel assigned to the project, the surviving members of the Consultant hereby agree to complete the work under the terms of this Agreement, if requested to do so by the City. This section shall not be a bar to renegotiations of this Agreement between surviving members of the Consultant and the City, if the City so chooses. 15. Applicable Law; Venue; Attorney's Fees. This Agreement shall be subject to, and the Consultant shall at all times comply with, all applicable federal, state and local laws, regulations, and rules, including the provisions of the City of Tukwila Municipal Code and ordinances of the City of Tukwila. In the event any suit, arbitration, or other proceeding is instituted to enforce any term of this Agreement, the parties specifically understand and agree that venue shall be properly laid in King County, Washington. The prevailing party in any such action shall be entitled to its attorney's fees and costs of suit. Venue for any action arising from or related to this Agreement shall be exclusively in King County Superior Court. 16. Severability and Survival. If any term, condition or provision of this Agreement is declared void or unenforceable or limited in its application or effect, such event shall not affect any other provisions hereof and all other provisions shall remain fully enforceable. The provisions of this Agreement, which by their sense and context are reasonably intended to survive the completion, expiration or cancellation of this Agreement, shall survive termination of this Agreement. CA revised : 1 -2013 14 AMA- A 17. Notices. Notices to the City of Tukwila shall be sent to the following address: City Clerk City of Tukwila 6200 Southcenter Boulevard Tukwila, WA 98188 Notices to Consultant shall be sent to the following address: Ken Johnsen Shiels Obletz Johnsen, Inc. 800 5"' Avenue, Suite 4130 Seattle, WA 98104 18. Entire Agreement; Modification. This Agreement, together with attachments or addenda, represents the entire and integrated Agreement between the City and the Consultant and supersedes all prior negotiations, representations, or agreements written or oral. No amendment or modification of this Agreement shall be of any force or effect unless it is in writing and signed by the parties. DATED this day of CITY OF TUKWILA Mayor, Allan Ekberg Attest/Authenticated: City Clerk, Christy O'Flaherty CA revised : 1 -2013 20 CONSULTANT By: Printed Name: Title: Approved as to Form: Office of the City Attorney Page 5 15 16 PUBLIC SAFETY PLAN - PROJECT MGMT RFP Consultant Selection Matrix (Internal Selection, No Interviews) points possible SHIELS OBLETZ JOHNSON HILL INTERNATIONAL Qualifications, expertise and experience of project management staff 30 30 25 Project understanding and approach 20 20 15 Experience with siting selection and land acquisition process 20 15 15 Experience working with community engagement efforts, citizen oversight groups and City Council reportin: 15 10 10 Knowledge of BUILDING DESIGN AND PERMITTING 10 10 10 Compliance with RFP Requirements 5 5 5 SUBTOTAL 100 90 80 Interview 100 90 90 TOTAL 200 180 170 For each category, highest score is listed (with the lowest or worst score at 0) Consultant with the highest score is ranked the best. Selection Date: Monday September 26, 2016 Selected Consultant: Shiels Obletz Johnsen, Inc. Selection Justification: This firm ranked highest for experience and qualifications, per RCW. iu: SHIELS OBLETZ JOHNSEN, INC. SCOPE OF SERVICES: Project Management City of Tukwila Public Safety Plan Under the direction of the City's Public Works Director, perform the following scope of services: 1. Organize and attend project management meetings • Executive Owner Group • Three Project Management Groups • Quarterly status reports to Council 2. Establish and maintain a project management plan. Plan to include: 2.1. Project Organization • Roles /Responsibilities /Contacts for Staff/ consultants, work groups and committees • Communication Protocols • Overall community engagement strategy • Document control 2.2. Project Schedule • Overall target project schedule for program and projects • Key project milestones including: • Selection of design team(s) • Selection property acquisition team(s) • Permitting requirements and milestones • Siting Decisions • Land acquisitions • Design • Construction • Move in • Schedule Management 2.3. Project Budget • Budgets for overall program and individual projects • Process for budget management • Process for tracking project budgets 3. Develop strategy for selection of design team(s) and acquisition and other consultants 4. Assist with tracking and reporting project budgets 19 5. Develop and assist with RFPs and selections of design team and land acquisition consultants, construction managers including qualifications and interviews. 6. Develop strategy for selection of contractors for projects • Assist in determining best method for controlling pro projects including GCCM, Design /Bid /Build, 63 -20 and low bid options • Assist in contractor selection process including steps to secure State approval for GCCM and /or Design /Bid /Build. 7. Develop and maintain document control solutions 8. Oversee land acquisition consultants and siting selection process through City Council • 8.1 Coordinate and communicate with Public Safety Plan Financial Oversight Committee (refer to City Ordinance No. 2509) • 8.2 Assist in public outreach and communications 9. Oversee and advise design team process for all building projects 10. Assure all required permits are obtained for all building projects 11. During Construction, advise City regarding: • Status of schedule and budget • Quarterly report for City Council • Issues affecting schedule, budget and quality 12. Provide additional construction management services as requested by the City 20 Exhibit B City of Tukwila Public Safety Plan Project Management Services Consultant - Shiels Obletz Johnsen (SOJ) SOJ will perform services on a time and materials basis. SOJ's team will bill for hours spent working on the project. Hourly rates for team members are listed below. Any direct costs such as travel, will be billed at cost. Exhibit C outlines a project schedule for SOJ services on the Public Safety Plan. Monthly hourly estimates are shown. It is important to note that these monthly estimates will actually differ month to month. As shown in Exhibit C, we are proposing a 29 month (December 2016 — April 2019) first phase for SOJ services that completes site selection and design phases for all projects. Construction Management (CM) services are also shown for Fire Station 51 and Justice Center projects through April of 2019. The City and SOJ will address potential additional CM services from SOJ for the other 3 projects in mid -2018. Project Team hourly billing rates: Ken Johnsen; Principal $270.00 Justine Kim; Sr. Project Management $200.00 Ethan Bernau, Project Manager $165.00 DJ Baxter, Sr. Project Manager Land and Acquisition $200.00 *Carrie Holmes; Deputy Project Manager $150.00 *Adam Strutynski; Budget /Schedule Specialist $140.00 * = Sub - consultant billed under SOJ contract Hourly rates escalated 3% January 1 of each year. A monthly estimate is also shown for Enviroissues to provide public outreach and communication services for Phase I- Site selection and Pre- design. As shown on Exhibit B, the Phase I Not -To- Exceed budget for SOJ services is $1,843,407. This budget is based upon the assumption that one A/E firm and one contractor are chosen to design and build all three fire stations. If this does not happen, additional budget will be required. The budget also assumes that the City and SOJ will work together to make efficient use of project team meetings. 21 22 24,000 I 1,654,407 I 1,843,407.:1 11/29/2016 Tukwila Public Safety Program - SOJ Hourly Estimates PHASE I: December 2016 - April 2019 TOTAL PROJECT VALUE (YOE$): $82.5M EXHIBIT C - Justice Center - Fire Station 51 - Fire Station 52 - Fire Station 54 - City Shops Ken Johnsen: Est. Hours Billing Rate: $270 /hour LL rn O 0 LL rn O 0 LL SubTotal Est Hours (thru Apr 2019) SUBTOTAL FOR PROJECT (thru Apr 2019) start start start start start 20 Design Phase (ncl. Reviews / Approvals & VE) Design Phase (incl. Reviews / Approvals & VE) Construction Phase Construction Phase 20 20 24 24 24 24 24 24 24 24 24 24 300 12 12 12 12 Desgn Phase (in I. Reviews / Approvals & VE) Design Phase (in I. Reviews / Approvals & VE) Desgn Phase (in I. Reviews / Approvals & VE) 12 12 12 12 12 12 12 12 144 8 8 8 8 32 476 130.213 Justine Kim: Est. Hours Billing Rate: $200 /hour 40 40 60 60 80 80 80 100 100 100 100 100 100 1,040 110 110 110 110 110 110 110 110 110 110 110 110 1,320 10 110 110 110 440 2,800 573.279 Cariie Holmes: Est. Hours Billing Rate: $150 /hour 30 60 60 60 60 60 60 60 80 80 80 80 80 850 80 80 80 80 110 110 110 110 110 110 110 110 1,200 110 110 110 110 440 2,490 382.919 DJ: Est. Hours Billing Rate: $ 200 /hour 40 60 60 60 60 60 60 60 60 60 60 60 60 760 40 40 40 40 40 40 240 1,000 201.440 Ethan Bernau Billing Rate: $165 /hour 0 0 0 0 0 0 40 40 60 60 200 80 80 80 80 80 80 80 80 80 80 80 100 980 00 100 100 100 400 1,580 269.570 Adam Strutynski Est. Hours Billing Rate: $135 /hour 20 20 30 30 30 16 16 16 16 16 16 16 16 258 16 16 16 16 16 16 16 16 16 16 16 16 Reimbursable Expenses Equivalent FTE: 0.81 131 131 144 135 135 148 1.6 1.85 1.85 1.98 1.98 192 20 20 20 20 80 530 72.985 2.04 2.04 2.04 2.04 223 223 1.98 1.98 1.98 1.98 1.98 2.1 2.13 2.13 2.13 2.13 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 500 500 500 500 500 500 8,876 $ 1,630,407 500 500 500 500 Reimburseables SOJ TOTAL Dec 2016 - Apr 2019 Is Is Erin Tam /Dennis Sandstrom: Est. Hours billing Rate: $150 /hour 60 60 60 60 60 60 60 60 60 60 60 60 60 780 40 40 40 40 40 40 40 40 40 40 40 40 480 Enviroissues Total Dec2016- Jun2017 1260 $ 89,000 PHASE I TOTAL SOJ + ENVIROISSUES Page 1 of 2 N 5,300 I 29,300 I 2,505,71.6 I 2,694,71.6.1 EXHIBIT C PHASE II: May 2019 - March 2021 1.69 1.56 1.44 1.44 1.56 1.44 1.38 1.38 250 250 250 250 250 250 250 250 1.375 1.4 1.4 1.4 1.4 1.4 as 0.9 0.8 0.8 as 0.5 as as as 0 0 0 0 0 250 250 250 250 250 250 250 250 250 250 250 250 100 100 100 Reimurseables SOJ TOTAL Dec 2016 - Apr 2019 Is Is 851,309 % SOJ Fee of Total Project Budget % Fee of MACC Ave Monthly FTE Reimurseables SOJ 3.00% 4.47% 1.52 Is Enciroissuesl $ 189,000. GRAND TOTAL SOJ + ENVIROISSUES Page 2 oft Rates i ' O noNI 'Dec subtotal hours May -Dec, 2019 i I4pr i I4ug dal O noN1 'Dec subtotal hours 2020 ls1 i I4pr 2 D kug subtotal hours 2021 SubTotal Est Hours (2019 -2021) SUBTOTAL FOR PROJECT (2019 -2021) Total Est Hours TOTAL FOR PROJECT Construction Phase Move- rnfClose} post occupancy Const oVeaNCio post occupancy Con truction Phase ve- jn /Cto post occ Con truction Phase ve- n/Ci° . post occ Construction Phase lave- 1 pos occupancy 8 8 8 8 6 6 6 6 56 6 6 6 6 6 6 6 6 6 6 6 6 72 8 8 8 24 162 $ 44.577 628 $ 174.789 860 4,620 5 966.344 110 110 110 110 110 110 100 100 100 100 100 100 100 100 60 60 40 40 20 20 840 40 40 40 120 1,820 5 393065 80 2,570 5 395.650 40 20 0 0 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 80 5 12.731 0 1,000 0 201.440 0 0 0$ 800 3,420 5 597.770 100 100 100 100 100 100 100 100 100 100 100 100 100 100 60 60 60 60 40 40 920 40 40 40 120 1,840 5 328200 160 990 5 140.422 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 240 20 20 20 60 460 $ 67.436 4,352 13,228 $ 846,009 $ 2,476,416 1.69 1.56 1.44 1.44 1.56 1.44 1.38 1.38 250 250 250 250 250 250 250 250 1.375 1.4 1.4 1.4 1.4 1.4 as 0.9 0.8 0.8 as 0.5 as as as 0 0 0 0 0 250 250 250 250 250 250 250 250 250 250 250 250 100 100 100 Reimurseables SOJ TOTAL Dec 2016 - Apr 2019 Is Is 851,309 % SOJ Fee of Total Project Budget % Fee of MACC Ave Monthly FTE Reimurseables SOJ 3.00% 4.47% 1.52 Is Enciroissuesl $ 189,000. GRAND TOTAL SOJ + ENVIROISSUES Page 2 oft Rates 26 City of Tukwila Allan Ekberg, Mayor INFORMATIONAL MEMORANDUM TO: Finance and Safety FROM: Mike Villa, Chief of Police BY: Leon Richardson, Senior Manager CC: Mayor Ekberg DATE: 30 November 2016 SUBJECT: Disposition Research Specialist (Grant funded position) ISSUE There are multiple records that need to be updated due to processing errors which are resulting in Criminal History not reflecting accurately for some people. BACKGROUND Tukwila began using a new correctional facility, SCORE in 2011. The SCORE facility is having issues placing the Tukwila case number in their system when booking people. This causes criminal history checks to not always show complete information. We have identified a significant amount of records that need to be researched and corrected. ANALYSIS To continue with the current incoming workload and to maintain the current level of service to the community and other agencies the Tukwila Police Records Unit needs to add one temporary FTE who will be assigned to research and correct SCORE booking information. FINANCIAL IMPACT The Tukwila Police Department was awarded a grant in the amount of $56,475 with a 10% match of $5,647. Federal Reimbursement (90%) $50,827.50. This reimbursement is at the discretion of the agency in that it can be Monthly, Quarterly or one lump sum at the end of the FY. RECOMMENDATION Please forward to the consent agenda on 12 December 2016, and approve 1 temporary FTE for 2017. ATTACHMENTS Washington State Patrol Interagency agreement Washington State Patrol Annual Compliance Report (march 2016) Washington State Patrol Annual Compliance Report (march 2015) 27 W. VVSP Interagency Agreement — NCH|PSubreopient 11/20/15 Page 1of9 WSP Contract No. WASHINGTON STATE PATROL K1 2324 INTERAGENCY AGREEMENT CFDA No. National Criminal History Improvement Program (NCHIP) Grant Fiscal Year 2016 16.554 - National Criminal History Improvement This Agreement is between the State of Washington, Washington State Patrol and the Public Agency identified below, and is issued pursuant to the Interlocal Cooperation Act, chapter 39.34 RCW. PUBLIC AGENCY NAME Statewide Vendor Registration Number CITY OF TUKWILA POLICE DEPARTMENT I SWV0018023-05 Public Agency Location Address Public Agency Mailing Address (if different from location address) 6200 Southcenter Blvd, Tukwila, WA 98188 Public Agency Contact Name Public Agency Data Universal Numbering System (DUNS) unique identifier Mr. Leon Richardson, Records Manager Public Agency Contact Telephone Public Agency Contact E-mail Address 206-431-1808 I.richardson@tukwilaWA.gov WSP Contact Information WSP Project Manager Name and Title WSP Project Manager Address WSP Criminal Records Division Ms. Deborah Collinsworth 3000 Pacific Avenue, SE Ste 204 Olympia, WA 98504-2633 Telephone Fax E-mail Address (360) 534-2102 (360) 534-207 Deborah. Col I insworth @±Lap.wa._qov WSP Administrative Contact Name and Title WSP Administrative Contact Address Mr. Simon Tee WSP Budget and Fiscal Services Grants and Contracts Manaqer PO Box 42602, Olympia WA 98504-2602 Telephone Fax E-mail Address (360) 596-4052 (360) 596-4078 Simon.Tee@wsp.wa. ov Federal Assistance Information Is the Public Agency a subrecipient of federal assistance for the purposes of Federal Grant Award Number this agreement? Yes E] No 2016-RU-BX-KO25 Federal Agency Federal Grant Award Date US Department of Justice, Office of Justice Programs, Bureau of Justice Statistics August 26, 2016 Is this agreement funded by a federal award for research and development? Federal Award to WSP El Yes M No 1 $569,1999 Agreement Start Date Agreement End Date Maximum Agreement Amount October 1, 2016 September 30, 2017 $56,475 (includes 10% Match) This Agreement, including the attached Terms and Conditions and any other documents incorporated by reference, contains all of the terms and conditions agreed upon by the parties. No other understandings or representations, oral or otherwise, regarding the subject matter of this Agreement shall be deemed to exist or bind the parties. The parties signing below warrant that they have read and understand this Agreement and have the authority to enter into this Agreement. FOR THE WASHINGTON STATE PATROL: FOR THE PUBLIC AGENCY: WSP Signature Date Public Agency Signature Date Printed Name and Title Name and Title John R. Batiste, Chief VVSP Interagency Agreement — NCH|PSubreopient 11/20/15 Page 1of9 WSP INTERAGENCY AGREEMENT (Continued) 1. Definitions. "Agreement" means this Interagency Agreement, including all documents attached or incorporated by reference. "Equipment" means an article of nonexpendable, tangible personal property having a useful life of more than one year and an acquisition cost which equals the lesser of (a) the capitalization level established by the governmental unit for financial statement purposes, or (b) $5,000. "BJS" means the Bureau of Justice Statistics of the Office of Justice Programs (OJP), U.S. Department of Justice (DOJ), the grantor of National Criminal History Improvement Program (NCHIP) Grant funds. "Public Agency" means the entity performing services to this Agreement and includes the Public Agency's officers, directors, trustees, employees and /or agents unless otherwise stated in this Agreement. For the purposes of this agreement, the Public Agency shall not be considered an employee or agent of WSP. "WSP" means the State of Washington, Washington State Patrol, and its officers, directors, trustees, employees and /or agents. 2. Statement of Work. The Public Agency shall perform the services as set forth in Exhibit A, Statement of Work, which is attached hereto and incorporated herein. 3. Special Terms and Conditions. In addition to the terms contained in this Agreement, the Public Agency shall comply with the terms and conditions contained in Exhibit B, Special Terms and Conditions, which is attached hereto and incorporated herein. 4. Payment. WSP shall pay the Public Agency an amount not to exceed the Maximum Agreement Amount specified on Page 1 of this Agreement, minus any matching requirements held by the Public Agency as specified in this Agreement. 5. Billing Procedure. WSP shall reimburse the Public Agency according to Exhibit A, Statement of Work, for work performed to the satisfaction of the WSP Project Manager. Compensation for services rendered shall be payable upon receipt of properly completed invoices, which shall be submitted not more often than monthly to the WSP Project Manager. The invoice must include the following: a. description of the work performed b. activities accomplished c. progress of the project d. fees and expenses f. match amount as well as amount requested for reimbursement g. for equipment purchases, a copy of the Public Agency's property record which includes the tag number that is assigned to the equipment h. for salary and benefits reimbursement, summary report of hours and costs of salaries and benefits by employees assigned to the project L reference to WSP's agreement number. The Public Agency shall submit the final invoice not later than forty -five (45) calendar days from the Agreement End Date. 6. Agreement Alterations and Amendments. WSP and the Public Agency may mutually amend this Agreement. Such amendments shall not be binding unless they are in writing and signed by personnel authorized to bind WSP and the Public Agency. WSP Interagency Agreement — NCHIP Subrecipient Page 2 of 9 11/20/15 WSP INTERAGENCY AGREEMENT (Continued) 7. Assignment. The work to be provided under this Agreement, and any claim arising thereunder, is not assignable or delegable by either party in whole or in part, without the express written consent of the other party. 8. Certification regarding Debarment, Suspension or Ineligibility. If federal funds are the basis for this Agreement, the Public Agency certifies that neither the Public Agency nor its principals are presently debarred, suspended, proposed for debarment, declared ineligible, or voluntarily excluded from participating in this Agreement by any federal department or agency. If requested by WSP, the Public Agency shall complete and sign a Certification Regarding Debarment, Suspension, Ineligibility, and Voluntary Exclusion form. Any such form completed by the Public Agency for this Agreement shall be incorporated into this Agreement by reference. Further, the Public Agency agrees not to enter into any arrangements or contracts related to this Agreement with any party that is on the "General Service Administration List of Parties Excluded from Federal Procurement or Non - procurement Programs" which can be found at www.sam.gov. 9. Compliance with Civil Rights Laws. During the period of performance for this Agreement, both parties shall comply with all federal and state nondiscrimination laws. 10. Disputes. In the event that a dispute arises under this Agreement, it shall be determined by a Dispute Board in the following manner: The Chief of WSP shall appoint a member to the Dispute Board. The Public Agency shall appoint a member to the Dispute Board. The Chief of WSP and the Public Agency shall jointly appoint a member to the Dispute Board, The Dispute Board shall evaluate the dispute and make a determination of the dispute. The determination of the Dispute Board shall be final and binding to all parties to this Agreement. 11. Federal Funding Accountability and Transparency Act. In order to comply with the Federal Funding Accountability and Transparency Act, the Public Agency shall provide to WSP the following information: a. The Public Agency's Data Universal Numbering System (DUNS) unique identifier; b. The names and total compensation of the five most highly compensated officers of the Public Agency if the Public Agency in the preceding fiscal year received (i) 80 percent or more of its annual gross revenues in Federal awards; and (ii) $25,000,000 or more in annual gross revenues from Federal awards; and (iii) the public does not have access to information about the compensation of the senior executives of the entity through periodic reports filed under section 13(a) or 15(d) of the Securities Exchange Act of 1934 (15 U.S.C. 78m(a), 78o(d)) or section 6104 of the Internal Revenue Code of 1986; and c. Other relevant information specified by the U.S. Office of Management and Budget in subsequent guidance or regulation. 12. Indemnification. The Public Agency shall be responsible for and shall indemnify and hold WSP harmless for all claims resulting from the acts or omissions of the Public Agency and its subcontractors. WSP shall be responsible for and shall indemnify and hold the Public Agency harmless for all claims resulting from the acts or omissions of WSP and its subcontractors. 13. Independent Capacity. The employees or agents of each party who are engaged in the performance of this Agreement shall continue to be employees or agents of that party and shall not be considered for any purpose to be employees or agents of the other party. 14. Inspection; Maintenance of Records. During the term of this Agreement and for one year following termination or expiration of this Agreement, the Public Agency shall give reasonable access to the Public Agency's place of business and records to WSP and any other employee or agent of the State of Washington or the United States of America for the purpose of inspecting the Public Agency's place of business and its records, and monitoring, auditing and evaluating WSP Interagency Agreement — NCHIP Subrecipient 11/20/15 Page 3 of 9 31 WSP INTERAGENCY AGREEMENT (Continued) the Public Agency's performance and compliance with applicable laws, regulations, rules and this Agreement. During the term of this Agreement and for six years following termination or expiration of this Agreement, the Public Agency shall maintain records sufficient to document (i) performance of all acts required by statute, regulation, rule, or this Agreement; (ii) substantiate the Public Agency's statement of its organization's structure, tax status, capabilities and performance; and (iii) demonstrate accounting procedures, practices and records which sufficiently and properly document the Public Agency's invoices to WSP and all expenditures made by the Public Agency to perform as required by this Agreement. 15. Order of Precedence. In the event of any inconsistency in the terms of this Agreement, or between its terms and any applicable statute or rule the inconsistency shall be resolved by giving precedence in the following order to: Applicable federal and state law, regulations and rules; This Agreement; Exhibit A, Statement of Work; Exhibit B, Special Terms and Conditions Any other provision of this Agreement; and Any document incorporated by reference. 16. Personnel. WSP officers performing work under the terms of this Agreement shall be under the direct command and control of the Chief of WSP or designee, and shall perform duties required under this Agreement in a manner consistent with WSP policy and regulations, and applicable federal, state and local laws. The assignment of WSP personnel under this Agreement shall be at the discretion of the Chief of WSP or designee. 17. Savings. In the event that funds WSP relied upon to establish this Agreement are withdrawn, reduced or limited, or if additional or modified conditions are placed on such funding, WSP may immediately terminate this Agreement by providing written notice to the Public Agency. This termination shall be effective on the date specified in the notice of termination. 18. Severability. If any provision of this Agreement or any provision of any document incorporated by reference shall be held invalid, such invalidity shall not affect the other provisions of this Agreement which can be given effect without the invalid provision, if such remainder conforms to the requirements of applicable law and the fundamental purpose of this Agreement, and to this end the provisions of this Agreement are declared to be severable. 19. Single Audit Act Compliance. If the Public Agency is a subrecipient and expends $750,000 or more in federal awards from any and /or all sources in any fiscal year, the Public Agency shall procure and pay for a single audit or a program- specific audit for that fiscal year. Upon completion of each audit, the Public Agency shall: (1) Submit to the WSP contact person the data collection form and reporting package specified in 2 CFR Part 200, Subpart F, reports required by the program - specific audit guide (if applicable), and a copy of any management letters issued by the auditor; (2) Follow -up and develop corrective action for all audit findings; in accordance with 2 CFR Part 200, Subpart F; prepare a Summary Schedule of Prior Audit Findings" reporting the status of all audit findings included in the prior audit's schedule of findings and questioned costs.. 20. Statewide Payee Registration. The Public Agency is required to be registered as a Statewide Payee prior to submitting a request for payment under this Agreement. The Washington State Department of Enterprise Services (DES) maintains the Statewide Payee Registration System; to obtain registration materials go to: http: / /www des wa gov/ services/ ContractingPurchasina /BusinessNendorPay /Pages /default.aspx. WSP Interagency Agreement — NCHIP Subrecipient 11/20/15 32 Page 4of9 WSP INTERAGENCY AGREEMENT (Continued) 21. Subcontracting. Except as otherwise provided in this Agreement, the Public Agency may subcontract for any of the services provided under this Agreement with the prior, written approval of WSP. The Public Agency shall be responsible for the acts and omissions of any subcontractor. 22. Termination. Except as otherwise provided in this Agreement, either party may terminate this Agreement upon thirty (30) calendar days written notification. If this Agreement is so terminated, the terminating party shall be liable only for performance in accordance with the terms of this Agreement for performance rendered prior to the effective date of termination 23. Waiver. A failure by either party to exercise its rights under this Agreement shall not preclude that party from subsequent exercise of such rights and shall not constitute a waiver of any other rights under this Agreement unless stated to be such in writing and signed by an authorized representative of the party and attached to the original Agreement. WSP Interagency Agreement — NCHIP Subrecipient 11/20/15 Page 5of9 33 Exhibit A STATEMENT OF WORK 1. Introduction. The purpose of this Agreement is to provide National Criminal History Improvement Program (NCHIP) grant funds for Fiscal Year 2016 to the Public Agency in order to increase the number of fingerprint submissions sent to and received by the state repository. Any work, personnel, and /or equipment funded must be for the authorized purposes of the grant in accordance with Federal statutes, regulations and the terms and conditions stated in the U.S. Department of Justice announcement OMB No. 1121 -0329 and the grant award. Federal funds under this award will be used to supplement but not supplant local government funds. This subaward is not for Research and Development (R &D) purpose. 2. Scope of Work. The Public Agency shall employ one temporary employee to research and correct SCORE booking information which will increase disposition compliance with WSP and FBI. 3. Project Budget. WSP shall reimburse the Public Agency according to the following budget, a summary of the budget proposed in the Public Agency application: Category Cost Personnel $29,120.00 Fringe Benefits $27,355.00 Total Direct Costs $56,475.00 Federal Reimbursement (90 %) $50,827.50 Local Match (10 %) $5,647.50 Indirect may be charged for total direct costs. As a local government, the Public Agency is required to prepare and retain its indirect cost proposal on file for review. If applicable, Public Agency shall use the approved federally recognized indirect cost rate negotiated between the Public Agency and the Federal Government or, if no such rate exists, either a rate negotiated between the WSP and the Public Agency, or a de minimis indirect cost rate as defined in §200.414 Indirect (F &A) costs, paragraph (f). Matching funds are restricted to the same use of funds as allowed for the Federal funds and are subject to audit. The Public Agency must maintain records which clearly show the source, amount, and timing for all matched contributions. Local funds committed as match can only be so for one federal grant. Expenditures may only occur within the categories listed above. However, changes of up to 10% can be made without prior approval from WSP. Changes that exceed 10% will require the Public Agency to submit a budget change request to WSP for approval. 4. Equipment Management. a. Title to Equipment. Upon successful completion of the terms of this Agreement, all equipment purchased by the Public Agency with Agreement funds will be owned by the Public Agency, or a recognized subrecipient for which a contract, subgrant agreement, or other means of legal transfer or ownership is in place. b. Use of Equipment. The Public Agency, or a recognized subrecipient, shall be responsible for any and all operation, maintenance, replacement, and for the safe operation of the equipment, including all questions of liability. WSP Interagency Agreement — NCHIP Subrecipient 11/20/15 34 Page 6of9 c. Equipment Records. The Public Agency shall maintain Equipment records that include: a description of the Equipment; the manufacturer's serial number, model number, or other identification number, including the tag number; the source of the Equipment, including the Catalog of Federal Domestic Assistance (CFDA) number; who holds title; the acquisition date; the cost of the Equipment and the percentage of federal participation in the cost; the location, use and condition of the Equipment at the date the information was reported; and disposition data including the date of disposal and sale price of the Equipment. Equipment records shall be retained by the Public Agency for a period of six (6) years from the date of the disposition, replacement or transfer. If any litigation, claim, or audit is started before the expiration of the six year period, the records shall be retained by the Public Agency until all litigations, claims, or audit findings involving the records have been resolved. A copy of the Public Agency's record showing the above information of the purchased equipment is required when requesting reimbursement for the equipment. d. Inventories. The Public Agency shall take a physical inventory of the Equipment and reconcile the results with the property records at least once every two years. Any differences between quantities determined by the physical inspection and those shown in the records shall be investigated by the Public Agency to determine the cause of the difference. The Public Agency shall, in connection with the inventory, verify the existence, current utilization, and continued need for the Equipment. The Public Agency shall develop a control system to ensure adequate safeguards to prevent loss, damage, and theft of the property. Any loss, damage or theft shall be investigated and a report generated. The Public Agency will develop adequate maintenance procedures to keep the property in good condition. e. Disposition of Equipment. If the Public Agency is authorized or required to sell the property, proper sales procedures must be established to ensure the highest possible return. When original or replacement equipment is no longer needed for the original project or program or for other activities currently or previously supported by a federal agency, disposition of the equipment will be made as follows: • Items of equipment with a current per -unit fair market value of less than $5,000 may be retained, sold or otherwise disposed of by the Public Agency with no further obligation to the awarding agency. • Items of equipment with a current per -unit fair market value of more than $5,000 may be retained or sold and the Public Agency shall compensate the U.S. Department of Justice for its share. 5. Progress Reports. a. Semi - Annual Reports. The Public Agency shall submit to the WSP Project Manager semi- annual progress reports within 20 calendar days after the end of the reporting periods, which are June 30 and December 31, for the life of this Agreement. Final and Closeout Report. The Public Agency shall submit a final report to the WSP Project Manager at the end of this Agreement documenting all relevant project activities during the entire period of support under this Agreement. This report will include a summary and assessment of the program carried out with this Agreement, including but not limited to, information about how the funds were actually used, how match was met and documented, data to support statements of progress, and data concerning individual results and outcomes of funded projects reflecting project successes and impacts. The final report is due no later than 30 days following the close of the Agreement. WSP Interagency Agreement — NCHIP Subrecipient 11/20/15 Page 7 of 9 35 Exhibit B SPECIAL TERMS AND CONDITIONS 1 Financial Guide. The Public Agency agrees tocomply with the financial and administrative requirements set forth in the current edition of the Office of Justice Programs (OJP) Financial Guide. OL Equal Employment Opportunity Plan. The Public Agency acknowledges that failure ho submit an acceptable Equal Employment Opportunity Plan (if Public Agency is required to submit one pursuant to 28 C.F.R. Section 42.302) that is approved by the Office for Civil Rights, U.S. Department of Justice, may result in suspension nr termination cf funding, until such time oo the Public Agency io in compliance. 3. Lobbying. The Public Agency understands and agrees that it cannot use any federal funds, either directly or indirectly, in support of the enactment, repeal, modification or adoption of any law, regulation or policy, at any level of government. 4. Federal False Claims Act. The Public Agency must promptly notify VVSPof any credible evidence that a principal, employee, agent, contractor, subgrantee, subcontractor, or other pemonhaoeither 1) submitted a false claim for Agreement funds under the False Claims Act; or 2) committed a criminal or civil violation of laws pertaining to fraud, conflict of interest, bribery' gratuity' or similar misconduct involving Agreement funds. 5' Performance Measures. The Public Agency agrees to provide performance related data, as outlined in the program announcement tobeused to measure the results of the project. G' Withholding Funds. The Public Agency understands and agrees that funds may bewithheld (including funds under future awards), or other /a|utad requirements maybe imposed, if the required information ia not submitted ona timely basis. 7' Consultant Rates. Approval of this Agreement does not indicate approval of any consultant rate in excess of $650 per day. A detailed justification must be submitted to and approved by WSP prior to obligation or expenditure of such funds. 8. Environmental Laws and Regulations. The Public Agency agrees to comply with all federal, state, and local environmental laws and regulations applicable to the development and implementation of the activities tobe funded under this Agreement. Q. Text Messaging While Driving. Pursuant to Executive Order 18513. "Federal Leadership on Reducing Text Messaging While Oriving'"74 Fed. Reg. 51225 (October 1'2OO9)'NUencourages recipients and sub recipients of Agreement funds to adopt and enforce policies banning employees from text messaging while driving any vehicle during the course of performing work funded by this Agreement, and to establish workplace safety policies and conduct education, awareness, and other outreach to decrease crashes caused by distracted drivers. 10. SUBRECIPIENTS. A. General. K the Public Agency iaaoubreoipien1cd federal awards am defined by2 CFRPed 2OO and this Agreement, the Public Agency shall: (1) Maintain records that identify, in its accounts, all federal awards received and expended and the federal programs under which they were received, by Catalog of Federal. Domestic Assistance (CFDA) title and number, award number and year, name of the federal agency, and name cf the pass-through entity; VVSP Interagency Agreement —NCH|PSubreopient 11/20/15 Page 8 of 9 (2) Maintain internal controls that provide reasonable assurance that the Public Agency is managing federal awards in compliance with laws, regulations, and provisions of contracts or grant agreements that could have a material effect on each of its federal programs; (3) Prepare appropriate financial statements, including a schedule of expenditures of federal awards; (4) Incorporate 2 CFR Part 200, Subpart F audit requirements into all agreements between the Public Agency and its Subcontractors who are subrecipients; (5) Comply with the applicable requirements of 2 CFR Part 200, including any future amendments to 2 CFR Part 200, and any successor or replacement Office of Management and Budget (OMB) Circular or regulation; and (6) Comply with the Omnibus Crime Control and Safe streets Act of 1968, Title VI of the Civil Rights Act of 1964, Section 504 of the Rehabilitation Act of 1973, Title II of the Americans with Disabilities Act of 1990, Title IX of the Education Amendments of 1972, The Age Discrimination Act of 1975, and The Department of Justice Non - Discrimination Regulations, 28 C.F.R. Part 42, Subparts C.D.E. and G, and 28 C.F.R. Part 35 and 39. (Go to www.oip.usdoi.gov /ocr/ for additional information and access to the aforementioned Federal laws and regulations.) B. Overpayments. If it is determined by WSP, or during the course of a required audit, that the Public Agency has been paid unallowable costs under this or any Program Agreement, WSP may require the Public Agency to reimburse WSP in accordance with 2 CFR Part 200. 11. The indirect cost rate for the Federal award (Award No. 2016- RU- BX -K025) through which this subaward is issued is 29.90 %. WSP Interagency Agreement — NCHIP Subrecipient 11/20/15 Page 9of9 37 1 , t Annual Compliance Report Disposition Reporting March 1, 2016 Annual report of disposition reporting compliance of prosecuting attorneys, municipal, district, and superior courts and originating agencies as required by RCW 10.98.100 W EN P a g e Introduction This report is intended for prosecuting attorneys; superior, district, and municipal courts; and originating law enforcement agencies. Purpose The annual disposition reporting compliance report can be used as a tool to evaluate the effectiveness of procedures for compiling criminal history record information (CHRI) from various sources. Contributing agencies will be able to assess their disposition reporting efficiencies and identify where improvements may be necessary to improve disposition reporting compliance. Background Established during the 1972 Legislative Session, the Identification and Criminal History Section (Section) is the central repository for statewide CHRI. The CHRI is based on arrest fingerprint card submissions from sheriffs' offices, police departments, and adult correctional and juvenile detention facilities. The state of Washington is a "single- source" contributor to the Federal Bureau of Investigation (FBI) for all criminal and applicant fingerprint cards (except those submitted for federal purposes). Final disposition reports, court orders of expungement, vacation, or sealing, and deceased notices must be sent to the Section for forwarding to the FBI. All records contained within the Section's files are based upon positive fingerprint identification. FIN P a g e CHRI is used for many purposes including criminal justice investigations, public and private employment background checks, licensing background checks, proper sentencing of convicted felons, and presentence and post-sentence evaluations. Certified criminal justice agencies (CCJA) receive both conviction and nonconviction CHRI. According to Washington State law, conviction records may be disseminated without restriction. Per Revised Code of Washington (RCW)10.97.030(3), a conviction record includes CHRI relating to an incident which has led to a conviction or other disposition adverse to the subject. Although the Section continues to provide Washington State conviction CHRI through the mail, a request for criminal history is available on the internet using the Washington Access to Criminal History (WATCH) application. WATCH allows citizens, private employers, and public agencies to request, view, and print criminal history instantly. WATCH-Criminal Justice (WATCH- CJ) is available online for certified criminal justice agencies. A fingerprint search is the most thorough search, as it will identify individuals who have been arrested or convicted and who maybe using alias identifiers. Disposition Reporting State statute (RCW 10.98.090) requires that in the case of superior court or felony disposition, the county clerk or prosecuting attorney promptly submit the completed disposition information to the Section. In a county where the judicial information system (JIS) or other secure method of electronic transfer of information has been implemented between the court and the Section, the county clerk will provide the disposition information electronically to the Section. 42 Page 13 In the case of a lower court disposition, the district or municipal court administrator must either promptly submit the completed disposition form, or in a county where the JIS or other secure method of electronic transfer of information has been implemented between the court and the Section, electronically provide the disposition information to the Section. For any arrest charge that results in a case not being filed, the law enforcement agency (LEA) or prosecutor that determines that no charges are to be filed shall submit a completed disposition report form to the Section indicating "No Charges Filed." For all other dispositions, the originating law enforcement agency must submit the completed disposition form to the Section. When a disposition report form has been forwarded to a prosecutor or court in error, or if the case receives a change of venue, the receiving agency must forward the disposition form to the appropriate entity. If the offense charged at arrest is a felony, but it is reduced to a gross misdemeanor and will be heard in a court of lower jurisdiction, the prosecutor or superior court must forward the disposition report form to the appropriate court of limited jurisdiction. Between the years 1996 and 2002, the Process Control Number (PCN) project was implemented statewide. The PCN is a tracking number generated at the time of fingerprinting. The PCN is initially generated by a live scan fingerprinting system or fingerprint card PCN packets provided by the Section. Each packet contains fingerprint cards and a disposition sheet form all stamped with the same PCN. FIN Page 14 The PCN should be used for all reportable arrests, administrative bookings, and commitments. The PCN is part of our state's ongoing effort to improve disposition reporting to the Section. The PCN links disposition information in the court systems to arrest data in the Section's Washington State Identification System (WASIS) criminal history database. PCN guidelines were updated in 2013 and are included as part of this report. Dispositions entered by court staff into the court system are submitted electronically to WASIS. Dispositions that are unable to update WASIS without human intervention ("lights out") are routed to an incident queue where they are processed by Section employees. Following the arrest event, the fingerprints and related arrest data (including PCN) are submitted to the Section and the disposition form (including PCN) is forwarded to the appropriate court for entry into the Administrative Office of the Courts (AOC) systems: Superior Court Information Management System (SCOMIS) and Judicial Information System (JIS). After the court enters the PCN to the corresponding court case and there is a case resolution, an electronic disposition transfer report (EDTR) is sent to the Section. This electronic transfer of information expedites disposition information and eliminates the need for court staff to mail a disposition report to the Section, with the exception where no court action is taken (no charges filed, not filed, etc.). When the Prosecuting Attorney's office declines to file charges, the Prosecuting Attorney's office is responsible for submitting that information to the Section. EV, P a g e 15 Currently about 5% of electronically submitted dispositions update WASIS without human intervention, referred to as "lights out". Section staff is able to process approximately 85% electronically in the Criminal History Incident Processing Queue (CHIPS) with minimal manual intervention. Washington State/NCIC Record of Arrest and Prosecution (RAP) Sheet The RAPsheet is an accumulation of the retainable fingerprint cards and dispositions received by the Section. This information received is from law enforcement agencies and courts. The information includes: criminal arrest cards, criminal justice applicants and contract employees, missing persons information, personal identification, sex/kidnapping offender registrations, and Department of Corrections incarcerations and supervisions. A "conviction record" is a criminal history record relating to an incident which has led to a conviction or other disposition adverse to the subject. A conviction RAPsheet is disseminated without restriction based on RCW 10-97.050(1) and 43.43.830-845. "Nonconviction data" is a criminal history record relating to an incident which has not led to a conviction or other disposition adverse to the subject, and for which proceedings are no longer actively pending. A nonconviction RAPsheet is disseminated to criminal justice agencies only based on RCW 10.97.050. Statutory Requirements: RCW 10.98.100 requires the Washington State Patrol: F, R P a g e 16 • Administer a compliance audit at least once annually for each prosecuting attorney, district and municipal court, and originating agency to ensure that all disposition reports have been received and added to the criminal history record information. • Furnish a list of outstanding disposition reports to the agencies. The results of compliance audits shall be published annually and distributed to legislative committees dealing with criminal justice issues, the office of financial management, and criminal justice agencies and associations. Report of Compliance: This report summarizes and compares previously reported arrests with dispositions received to determine the compliance rate with submitting dispositions as mandated by state statute. The "Total Arrest Charges Reported" column includes those fingerprint based arrest events submitted by each agency. The "Total Open Charges" column indicates the number of arrest charges for which a final disposition has not been reported. The "Percentage in Compliance" indicates the percentage of arrest charges for each contributing agency which do have a final disposition on file. The goal is 100% compliance. The arrest charges included in this fifth annual compliance audit report were all originated by the arresting agency or the prosecutor from arrest events that occurred between January 1, 2014 and December 31, 2014. The report includes the disposition data reported as of February 11, 2016. While these charges have had more than a year to process through the courts, it is possible some charges are not yet disposed. EN RCW 10.97.050 RCW 10.98.090 RCW 10.98.100 RCW 43.43.540 RCW 43.43.700 RCW 43.43.735 RCW 43.43.740 RCW 43.43.760 RCW 43.43.770 RCW 43.43.815 RCW 43.43.830-45 47 2016 Washington State Patrol Annual Disposition Reporting Compliance Report For Arrests Occurring 01/01/2014 through 12/31/2014 Total Arrest Originating Charges Total Open Percent In Originating Agency Name Agency ORI Reported Charges Compliance GRAYS HARBOR COUNTY SHERIFF OFFICE WA0140000 1465 146 90.03% ABERDEEN POLICE DEPARTMENT WA0140100 1589 256 83.89% ELMA POLICE DEPARTMENT WA0140200 393 67 82.95% HOQUTAM POLICE DEPARTMENT WA0140300 326 139 57.36% GRAYS HARBOR COUNTY JUVENILE COURT WA014035J 15 3 80.00% MCCLEARY POLICE DEPARTMENT WA0140400 35 8 77.14% MONTESANO POLICE DEPARTMENT WA0140500 124 18 85.48% COSMOPOLIS POLICE DEPARTMENT WA0140600 28 5 82.14% OAKVILLE POLICE DEPARTMENT WA0140700 3 0 100.00% OCEAN SHORES POLICE DEPARTMENT WA0140800 147 40 72.79% WESTPORT POLICE DEPARTMENT WA0140900 142 23 83.80% ISLAND COUNTY ISLAND COUNTY SHERIFFS OFFICE WA0150000 776 186 76.03% OAK HARBOR POLICE DEPARTMENT WA0150100 1002 401 59.98% COUPEVILLE TOWN MARSHALS OFFICE WA0150200 19 7 63.16% ISLAND COUNTY SUPERIOR COURT WA015025J 23 8 65.22% LANGLEY POLICE DEPARTMENT WA0150300 16 7 56.25% ISLAND COUNTY JUVENILE DETENTION WA015035J 103 78 24.27% JEFFERSON COUNTY -- „- JEFFERSON COUNTY SHERIFF WA0160000 705 150 78.72% PORT TOWNSEND POLICE DEPARTMENT WA0160100 215 38 82.33% KING COUNTY KING COUNTY SHERIFFS OFFICE WA0170000 15 7 53.33% AUBURN POLICE DEPARTMENT WA0170100 5781 632 89.07% BELLEVUE POLICE DEPARTMENT WA0170200 2569 283 88.98% SOUTH CORRECTIONAL ENTITY WA017021C 4325 133; 9 :92% BOTHELL POLICE DEPARTMENT WA0170300 1485 306 79.39% ENUMCLAW POLICE DEPARTMENT WA0170400 474 158 66.67% ISSAQUAH POLICE DEPARTMENT WA0170600 1039 329 68.33% KENT POLICE DEPARTMENT WA0170700 8221 749 90.89% KIRKLAND POLICE DEPARTMENT WA0170800 3273 983 69.97% MERCER ISLAND POLICE DEPARTMENT WA0170900 238 115 51.68% NORMANDY PARK POLICE DEPARTMENT WA0171000 164 23 85.98% NORTH BEND POLICE DEPARTMENT WA0171100 328 79 75.91% REDMOND POLICE DEPARTMENT WA0171200 1763 496 71.87% RENTON POLICE DEPARTMENT WA0171300 3754 266 92.91% ALGONA POLICE DEPARTMENT WA0171400 133 23 82.71% BLACK DIAMOND POLICE DEPARTMENT WA0171500 104 36 65.38% CARNATION POLICE DEPARTMENT WA0171600 27 3 88.89% Page 3 .: 2016 Washington State Patrol Annual Disposition Reporting Compliance Report For Arrests Occurring 01/01/2014 through 12/31/2014 Page 4 Total Arrest Originating Charges Total Open 9ercent|n Originating Agency Name AgenrV00| Reported Charges Compliance DES MOINES POLICE DEPARTMENT WA0171700 1185 131 88.95% DUVALL POLICE DEPARTMENT VVA0171808 176 DO 54.55V6 K8ED\NA POLICE DEPARTMENT VVA0172000 46 10 78.26% PACIFIC POLICE DEPARTMENT VVA0172100 332 63 81.02% SNOQUALM|E POLICE DEPARTMENT VVA0172200 423 143 66.1996 ,W OLICE,,',,DEPARTMENT , � �� � ' �ez UNIVERSITY OF WASHINGTON POLICE VVA0172400 154 55 64.29% CLYDE HILL POLICE DEPARTMENT VVA0172500 41 12 70.73Y6 LAKE FOREST PARK POLICE DEPARTMENT VVA0172600 321 75 76.64% SKYKOK4|GH POLICE DEPARTMENT VVA0172700 1 O 100.0096 HUNTS POINT POLICE DEPARTMENT VVA0173000 1 1 0.00% YARROW POINT POLICE DEPARTMENT VVA0173100 2 1 50.00V6 PORT DF SEATTLE POLICE DEPARTMENT VVA0173200 440 120 72.73% FEDERAL WAY POLICE DEPARTMENT VVA0173600 4345 718 83.48% SEATAC POLICE DEPARTMENT VVA0172700 1491 138 90.68% VVOOD|NV|LLE POLICE DEPARTMENT VVA0174000 233 64 72.53% BUR|EN POLICE DEPARTMENT VVA0174100 1860 353 81.02% NEWCASTLE POLICE DEPARTMENT VVA0174200 54 12 77.78Y6 SHORELINE POLICE DEPARTMENT VVA0174300 1841 346 81.2IY6 EASTS|DE NARCOTICS TASK FORCE VVA0174500 6 O 100.00% MAPLE VALLEY POLICE DEPARTMENT VVA0174700 102 17 83.33% COV|NGTDN POLICE DEPARTMENT VVA0174800 571 178 68.83% KENMORE POLICE DEPARTMENT VVA0174900 479 128 73.28% SAK1MAK8|SH POLICE DEPARTMENT VVA0175000 232 102 56.03Y6 KING COUNTY SHERIFFS OFFICE VVAKCS000O 12974 1461 88.74% SEATTLE POLICE DEPARTMENT VVASPD000O 19537 7053 63.90% SEATTLE POLICE DEPARTMENT VVA3PD000I 1 O 100.00% KITSAP COUNTY SHERIFF WA0180000 4993 688 86.22% BREW1ERTON POLICE DEPARTMENT VVA0180100 2395 279 88.35Y6 K|TS8PCOUNTY]UVEN|LE[DURT VVA018025] 266 3 98.87% PORT ORCHARD POLICE DEPARTMENT VVA0180400 1195 153 87.2096 POULS8{} POLICE DEPARTMENT VVA0180500 279 41 85.3096 BA|NBR|DGE ISLAND POLICE DEPARTMENT VVA0180700 167 45 73.05% KITTITAS COUNTY KITTITAS MUNTY SHERIFF OFFICE WA0190000 846 133 84.28% ELLENS8URG POLICE DEPARTMENT VVA0190100 992 85 91.43% CLEELUM POLICE DEPARTMENT VVA0180200 150 27 82.0096 K|TT|TAS COUNTY JUVENILE COURT VVA019025] 52 17 67.3196 RDSLYNPPOL|CEDEPARTMENT VVA0180400 2 0 I00.00Y6 Page 4 WASHINGTON STATE Annual Compliance Report Disposition Reporting March 1, 2015 Annual report of disposition reporting compliance of prosecuting attorneys, municipal, district, and superior courts and originating agencies as required by RCW 10.98.100 51 52 2015 Washington State Patrol Annual Disposition Reporting Compliance Report For Arrests Occurring 01/01/2013 through 12/31/2013 Total Arrest Originating Charges Total Open Percent In Originating Agency Name Agency ORI Reported Charges Compliance WARDEN POLICE DEPARTMENT WA0131100 76 14 81.58% GRAYS HARBOR COUNTY SHERIFF OFFICE WA0140000 1534 183 88.07% ABERDEEN POLICE DEPARTMENT WA0140100 1493 286 80.84% ELMA POLICE DEPARTMENT WA0140200 287 73 74.56% HOQUTAM POLICE DEPARTMENT WA0140300 333 88 73.57% GRAYS HARBOR COUNTY JUVENILE COURT WA014035J 18 1 94.44% MCCLEARY POLICE DEPARTMENT WA0140400 61 20 67.21% MONTESANO POLICE DEPARTMENT WA0140500 146 40 72.60% COSMOPOLIS POLICE DEPARTMENT WA0140600 39 5 87.18% OCEAN SHORES POLICE DEPARTMENT WA0140800 174 53 69.54% WESTPORT POLICE DEPARTMENT WA0140900 $6 11 87.21% ISLAND COUNTY SHERIFFS OFFICE WA0150000 710 173 75.63% OAK HARBOR POLICE DEPARTMENT WA0150100 1355 580 57.20% COUPEVILLE TOWN MARSHALS OFFICE WA0150200 27 12 55.56% LANGLEY POLICE DEPARTMENT WA0150300 21 5 76.19% ISLAND COUNTY JUVENILE DETENTION WA015035J 101 92 8.91% ,� I I 0�„ 4 ,�, 1. JEFFERSON COUNTY SHERIFF WA0160000 552 100 81.88% PORT TOWNSEND POLICE DEPARTMENT WA0160100 127 16 87.40% t J I� 0M KING COUNTY SHERIFFS OFFICE WA0170000 8 1 87.50% AUBURN POLICE DEPARTMENT WA0170100 5199 454 91.27% BELLEVUE POLICE DEPARTMENT WA0170200 2404 1066 55.66% SOUTH CORRECTIONAL ENTITY WA017021C 2115 1961 7.28% BOTHELL POLICE DEPARTMENT WA0170300 1342 401 70.12% ENUMCLAW POLICE DEPARTMENT WA0170400 366 229 37.43% HOUGHTON POLICE DEPARTMENT WA0170500 1 0 100.00% ISSAQUAH POLICE DEPARTMENT WA0170600 646 319 50.62% KENT POLICE DEPARTMENT WA0170700 8299 901 89.14% KIRKLAND POLICE DEPARTMENT WA0170800 3714 1178 68.28% MERCER ISLAND POLICE DEPARTMENT WA0170900 169 103 39.05% NORMANDY PARK POLICE DEPARTMENT WA0171000 172 83 51.74% NORTH BEND POLICE DEPARTMENT WA0171100 128 42 67.19% REDMOND POLICE DEPARTMENT WA0171200 1416 475 66.45% RENTON POLICE DEPARTMENT WA0171300 3869 314 91.88% ALGONA POLICE DEPARTMENT WA0171400 188 30 84.04% BLACK DIAMOND POLICE DEPARTMENT WA0171500 85 43 49.41% 3 53 2015 Washington State Patrol Annual Disposition Reporting Compliance Report For Arrests Occurring 01/01/2013 through 12/31/2013 4 +L" 7 Total Arrest Originating Charges Total Open Percent In Originating Agency Name Agency ORI Reported Charges Compliance CARNATION POLICE DEPARTMENT WA0171600 49 24 51.02% DES MOINES POLICE DEPARTMENT WA0171700 1074 117 89.11% DUVALL POLICE DEPARTMENT WA0171800 211 103 51.18% MEDINA POLICE DEPARTMENT WA0172000 53 19 64.15% PACIFIC POLICE DEPARTMENT WA0172100 389 101 74.04% SNOQUALMIE POLICE DEPARTMENT WA0172200 295 158 46.44% TUKWILA POLICE DEPARTMENT WA0172300 2580 1367 47.02% UNIVERSITY OF WASHINGTON POLICE WA0172400 142 59 58.45% CLYDE HILL POLICE DEPARTMENT WA0172500 50 16 68.00% LAKE FOREST PARK POLICE DEPARTMENT WA0172600 410 147 64.15% SKYKOMISH POLICE DEPARTMENT WA0172700 1 1 0.00% HUNTS POINT POLICE DEPARTMENT WA0173000 5 3 40.00% PORT OF SEATTLE POLICE DEPARTMENT WA0173200 419 128 69.45% FEDERAL WAY POLICE DEPARTMENT WA0173600 3943 862 78.14% SEATAC POLICE DEPARTMENT WA0173700 1623 1041 35.86% WOODINVILLE POLICE DEPARTMENT WA0174000 235 122 48.09% BURIEN POLICE DEPARTMENT WA0174100 1933 357 81.53% NEWCASTLE POLICE DEPARTMENT WA0174200 34 6 82.35% SHORELINE POLICE DEPARTMENT WA0174300 1660 352 78.80% EASTSIDE NARCOTICS TASK FORCE WA0174500 4 0 100.00% MAPLE VALLEY POLICE DEPARTMENT WA0174700 99 19 80.81% COVINGTON POLICE DEPARTMENT WA0174800 559 92 83.54% PD KENMORE WA0174900 483 132 72.67% SAMMAMISH POLICE DEPARTMENT WA0175000 214 94 56.07% KING COUNTY SHERIFFS OFFICE WAKCS0000 11903 1440 87.90% SEATTLE POLICE DEPARTMENT WASPD0000 21855 7957 63.59% ,,, ,,;,� �, , „�,, 1111111,011, ; KITSAP COUNTY SHERIFF WA0180000 4490 616 86.28% BREMERTON POLICE DEPARTMENT WA0180100 2739 336 87.73% KITSAP COUNTY JUVENILE COURT WA018025J 395 14 96.46% PORT ORCHARD POLICE DEPARTMENT WA0180400 1239 185 85.07% POULSBO POLICE DEPARTMENT WA0180500 310 42 86.45% BAINBRIDGE ISLAND POLICE DEPARTMENT WA0180700 170 49 71.18% KITTITAS COUNTY SHERIFF OFFICE WA0190000 934 116 87.5806 ELLENSBURG POLICE DEPARTMENT WA0190100 970 80 91.75% CLE ELUM POLICE DEPARTMENT WA0190200 190 29 84.74% KITTITAS COUNTY JUVENILE COURT WA019025J 29 7 75.86% ROSLYN POLICE DEPARTMENT WA0190400 23 0 100.00% PD KITTITAS CARE OF ELLSO WA0190600 45 12 73.33% 4 +L" 7 City of Tukwila Allan Ekberg, Mayor INFORMATIONAL MEMORANDUM TO: Mayor Ekberg Finance and Safety Committee FROM: Peggy McCarthy, Finance Director BY: Vicky Carlsen, Deputy Finance Director DATE: November 30, 2016 SUBJECT: Second Quarter 2016 Cash & Investment Report ISSUE The second quarter Investment Report is included with this memorandum and is discussed below. BACKGROUND City funds are invested to earn a reasonable return while preserving principal and allowing sufficient liquidity to meet the City's operating needs. To achieve these objectives investments are diversified by type, by financial institution, and by maturities in compliance with the City Investment Policy. DISCUSSION Portfolio Components As of June 30, 2016, the portfolio totaled $54.5 million comprised of $43.4 million in cash and cash equivalents and $11.1 in longer term investments. The portfolio balance increased by $1.9 million from a March 31, 2016 balance of $52.6 million. Details on individual fund activity is provided below in the Fund Cash Investment Balances section. In May, two of the City's agency investments were called. On May 2311, a Federal National Mortgage Association agency investment of $1 million was called. Additionally, on May 25th, a Federal Home Loan Mortgage Corp. agency investment of $1 million called. At this time, the City has not replaced these investments with new longer -term investments. We continue to look for investments where the interest rate exceeds the rate the City receives with US Bank. Portfolio Performance The portfolio weighted average yield on June 30, 2016, was .41 %. Considering the portfolio's weighted average maturity was 0.8 years, and the yield on the cash & cash equivalent accounts was .21 %, the portfolio yield of 0.41 % is still favorable. The total yield has been sustained by the 4.14% average yield on the municipal bond investments, the .43% yield on the certificate of deposits, the 1.15% yield on the agencies, and the .45% earnings credit on the US Bank depository account. Investment income through the end of June 2016 for all investments is $221,633 against an annual budget of $227,322. Not included in the portfolio is interest earned from the operating and capital loans to the MPD. The operating loan is being repaid on a monthly basis and will be paid in full by May 2023. Interest earned on the loan through June 2016 is $8,147. The capital loan is being repaid semi - annually 55 INFORMATIONAL MEMO Page 2 and will be paid in full by December 2022. Interest accrued through June 2016 is $9,917. Attached to the investment report are amortization schedules for both loans to the MPD. Policy Compliance and Liquidity Analysis As of the end of the 2nd quarter, the portfolio profile is well within the range of all the investment policy parameters. There is currently a healthy mix of investments with a range of maturity dates. Current investments allow for adequate cash flow requirements. Fund Cash & Investment Balances Year over Year Comparison Total fund cash and investments balances are $52.9 million, which is $1.8 million higher than second quarter 2015. The general fund total cash and investment balance is $8.9 million, which is $704K higher than June of 2015. Most revenue categories continue to perform well, with gambling taxes continuing to exceed budget coupled with revenue outpacing spending. The arterial street fund in the capital projects fund group shows a decrease of $2 million. In 2015, the City issued $5.8 million LTGO bonds as partial funding for the Interurban South and BAR Bridge projects. Proceeds are expected to be spent by the end of 2016. A one -time increase in Real Estate Excise Tax at the end of 2015 of $700 thousand accounts for much of the of $856 thousand increase in the Land Acquisition, Rec., and Park Fund. Utility funds all have increases in fund balances from the prior year through June. Investment Environment While the Federal Reserve increased the target rate from zero to 0.25% in December 2015, it was anticipated that an additional rate hike could occur in June of 2016. However, in June, it was decided that a rate hike in June would be postponed. It is now predicted that there may be an interest rate hike in December. Even if a rate hike does occur, interest rates will likely remain low and fluctuate within a narrow range for some time to come. Locally, the steady growth realized in 2015 is expected to continue through 2016. There is growth in housing permits, housing inventories are low and rents are rising. Employment shows growth while unemployment rates in King County continue to fall. The portfolio will continue to be managed to take advantage of investment opportunities as they arise. RECOMMENDATION Presentation is for information only. ATTACHMENTS Cash and Investment Report Policy Compliance & Liquidity Analysis Cash and Investment Balances by Fund Treasury Rates and Yield Curves Amortization Schedule — MPD Operating Loan Amortization Schedule — MPD Capital Loan 56 CITY OF TUKWILA CASH & INVESTMENT REPORT June 30, 2016 Total Cash & Cash Equivalents 43,394,286 (c) (a) Rating Book Purchase Maturity Term Agency / Issuer Moody s Investment Type Date Date Yrs CASH & CASH EQUIVALENTS 1/12/2016 5/26/2017 $18,241,130 US Bank Depository Various (b) Washington State Treasurer LGIP Investment Pool Various (b) Columbia Bank Money market Various (b) Total Cash & Cash Equivalents 43,394,286 (c) (d) Par Book Yield to Year -to -Date Value Balance Maturity Return US agency 1/12/2016 5/26/2017 $18,241,130 $18,241,130 (e) 45,402 (e) 493 (g) Sound Community Bank Certificate of Deposit 3/4/2014 3/4/2017 0.45% 3,188,291 10,972,546 10,972,546 (f) 23,695 (b) 3,438,291 0.43% 0.4488% FHLB 14,180,609 14,180,609 (f) 33,816 (f) 3.0 1,000,000 0.52% 1.22% (f) Total Cash & Cash Equivalents 43,394,286 43,394,286 0.24% 102,913 INVESTMENTS Total Investments 4.1 10,880,000 11,116,066 Certificates of Deposit 118,720 US agency 1/12/2016 5/26/2017 Bank of Washington Certificate of Deposit 5/2/2016 6/2/2017 1.1 250,000 250,000 0.80% 493 (g) Sound Community Bank Certificate of Deposit 3/4/2014 3/4/2017 3.0 3,000,000 3,188,291 0.85% 13,554 (g) CERTIFICATES OF DEPOSIT -- TOTAL 2.9 3,250,000 3,438,291 0.43% 14,047 Agencies 6.3 3,630,000 3,675,428 2.20% 80,698 Total Investments 4.1 10,880,000 11,116,066 Federal Home Loan Mtg Corp 118,720 US agency 1/12/2016 5/26/2017 1.4 1,000,000 999,000 0.75% 4,750 (FHLMC) FHLB US agency 9/21/2015 9/21/2018 3.0 1,000,000 1,000,000 1.22% (f) 6,100 FHLMC US agency 5/29/2015 5/25/2018 3.0 1,000,000 1,001,750 1.25% (f) 6,250 Federal Farm Credit Bank US agency 1/19/2016 12/21/2018 2.9 1,000,000 1,001,597 1.38% (f) 6,875 (FFCB) 0.60% 23,975 TOTAL AGENCIES 2.6 4,000,000 4,002,347 Taxable Municipal Bonds Washington State Convention Aa3 Lodging Tax Bonds 11/30/2010 7/1/2016 5.6 500,000 500,728 3.60% 9,808 Center Facility City of Marysville, sinking Aa3 LTGO Refunding 11/23/2010 12/1/2017 5.5 290,000 327,149 3.37% 7,879 2014 -2017, ave 5.5 years Skagit County BAB Aa3 1/12/2016 12/1/2017 0.4 365,000 365,000 2.85% 5,201 UW Biomedical Center Aa1 Revenue Bonds 12/14/2010 7/1/2017 6.6 500,000 501,586 4.05% 10,740 UW Biomedical Center Aa1 Revenue Bonds 12/14/2010 7/1/2019 8.6 500,000 502,565 4.70% 12,203 Douglas County, ESD, sinking Aa1 UTGO 12/23/2010 12/1/2020 8.9 1,135,000 1,144,802 4.55% 27,240 2018 -2020, ave 9 yrs Port of Anacortes Al LTGO 12/17/2010 9/1/2020 9.7 340,000 333,598 5.00% 7,628 TOTAL MUNICIPAL BONDS 6.3 3,630,000 3,675,428 2.20% 80,698 Total Investments 4.1 10,880,000 11,116,066 1.07% 118,720 TOTAL CASH, CASH EQUIVALENTS & INVESTMENTS 0.8 $ 54,274,286 $ 54,510,352 1 0.41% 1 $ 221,633 Current Portfolio (a) On calleable bonds, term is calculated to final maturity even though call date may occur first; term of liquid investments is one day; on sinking fund bonds, average maturity is used to calculate term. (b) No fixed maturity, funds are available within one day. Percent of Cash & Investment Portfolio (c) Yield to Maturity represents average rate for the year for various investment vehicles. Agencies_ Municipal (h) Annualized Return represents actual earnings through current reporting period 34% CDs 6% 20% +11 CITY OF TUKWILA Policy Compliance & Liquidity Analysis CASH & INVESTMENT REPORT June 30, 2016 Liauiditv Reauirements and Funds Available for Investing: Funds immediately available $ 43,394,286 Restrictions & designations: Operating liquidity (a) 14,000,000 Liquidity threshold 14,000,000 Funds available for longer term investing $ 29,394,286 (a) Represents largest one month decline in portfolio balance over the most recent 36 month period doubled; or the 6.3 equivalent of a 100% cushion. IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII As of Report Date Total Portfolio IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII Available Available Available in Portfolio Portfolio Within 1 Year Within 5 5 - 10 Years Liquidity Analysis & Maturity Diversification Amount % of Total Years Funds immediately available $ 43,394,286 $ 43,394,286 $ 43,394,286 Fixed Maturity Investments, maturing in: Yes Washington State Treasurer 10,972,546 0 -90 days after Report Date 500,728 Yes Columbia Bank 91 -180 days after Report Date - 50.0% Yes 181 -270 days after Report Date 3,188,291 5.8% 50.0% 271 -360 days after Report Date 1,249,000 7,927,775 14.5% Investments maturing in 1 year or less 4,938,020 4,938,020 4,938,020 Investments maturing in 1 -3 years 4,197,082 4,197,082 Investments maturing in 3 -5 years 1,980,965 POLICY 1,980,965 Investments maturing in 5 -7 years - % of Total MAXIMUM Investments maturing in 7 -10 years - 18,241,130 33.5% Investments maturing in more than 1 year 6,178,047 State Investment Pool 10,972,546 and less than 10 years. 75.0% Yes Money market TOTALS $ 54,510,352 $ 48,332,305 $ 54,510,352 $ Certificate of Deposit 3,438,291 89% 100% 0% Investment Policy Parameters POLICY LIMIT PORTFOLIO Policy Met? Funds available within 1 year 30.0% min 89% Yes Funds available within 5 years 80.0% min 100% Yes Funds available in 5- 10 years 20.0% max 0% Yes Liauiditv Reauirements and Funds Available for Investing: Funds immediately available $ 43,394,286 Restrictions & designations: Operating liquidity (a) 14,000,000 Liquidity threshold 14,000,000 Funds available for longer term investing $ 29,394,286 (a) Represents largest one month decline in portfolio balance over the most recent 36 month period doubled; or the 6.3 equivalent of a 100% cushion. IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII Total Portfolio IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIII 3.5 Portfolio Yes POLICY Policy Financial Institution Diversification Amount % of Total MAXIMUM Met? US Bank $ 18,241,130 33.5% 50.0% Yes Washington State Treasurer 10,972,546 20.1% 75.0% Yes Columbia Bank 14,180,609 26.0% 50.0% Yes Sound Community Bank 3,188,291 5.8% 50.0% Yes Other financial institutions 7,927,775 14.5% 50.0% Yes Total $ 54,510,352 100.0% Portfolio POLICY Policy Investment Mix Amount % of Total MAXIMUM Met? Depository 18,241,130 33.5% insured by PDPC Yes State Investment Pool 10,972,546 20.1% 75.0% Yes Money market 14,180,609 26.0% insured by PDPC Yes Certificate of Deposit 3,438,291 6.3% insured by PDPC Yes US Agency 4,002,347 7.3% 75.0% Yes Municipal Bonds 3,675,428 6.7% no limit specified in policy Yes Total 54,510,352 100.0% Weiahted Average Maturites: Years Certificates of deposit 2.9 Municipal bonds 6.3 Total Investments 4.1 Total Portfolio F 0.8 POLICY MAXIMUM 3.5 Policy Met? Yes Note: Cash and cash equivalents are available within one day and are factored into the Total Portfolio weighted average maturity. i Performance Analysis Current portfolio yield 0.41% Benchmarks: 6 month treasury 0.36% 2 year treasury 0.58% Local Govt Invst Pool (f) 0.4488% CITY OF TUKWILA Cash & Investment Balances By Fund and Fund Group CASH & INVESTMENT REPORT June 30, 2016 107 FIRE EQUIP. CUM. RESERVE - 109 DRUG SEIZURE FUND 20,265 Special Revenue Total 6,419,905 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48,952 68,308 Balances Balances Balances Balances $ 4,149,258 • • + + 06/30/15 06/30/14 General 000 GENERAL 8,915,911 $ 8,211,831 $ 6,987,822 8,9 neral Total ......................................................................................................................................................................................................................................... ............................... ..........1............5,9 1.1..... 8,211,831 6,98 7 ,8 22 Special Revenue 101 HOTEL/MOTELTAX 797,137 378,109 495,322 105 CONTINGENCY 5,602,503 5,777,260 5,763,258 107 FIRE EQUIP. CUM. RESERVE - 109 DRUG SEIZURE FUND 20,265 Special Revenue Total 6,419,905 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48,952 68,308 Balances Balances 06/30/13 06/30/12 $ 4,149,258 $4,903,893 4,149,258 4,903,893 660,126 440,145 1,461,857 1,458,686 945,694 943,850 146,312 222,196 6,204,321 6,326,889 3,213,989 3,064,877 Debt Service 200 DEBT SERVICE 447,966 208,614 - 206 L.I. GUARANTEE 669,149 669,147 669,147 208 LIMITED TAX G.O. BONDS 2000 - - - - - 209 LIMITED TAX G.O. BONDS 2003 1 1 1 3,020,451 3,828,526 210 LIMITED TAX G.O. REFUNDING 2003 195 195 244,320 247 469,496 211 LIMITED TAX G.O. REFUNDING 2008 327,916 315,416 406,416 218 705,717 212 LTGO SCORE BONDS 2 2 291,688 1,390 30,891 213 LTGO SCORE BLD AMER BONDS - - - - 115,995 214 LTGO 2010 Series A 231,339 192,676 296,039 108,557 369,525 215 LTGO 2010 Series B - - - 4,612 66,508 216 VALLEY COM Refunding bonds 2010 794 115,194 106,434 12,954 14 217 LIMITED TAX GO BONDS REFUNDING 210,539 203,039 274,214 1 101,738 218 LTGO 2013 - - - - - .................................................................................................................................................................................................................. 233 LID #33 ............................... 114,349 ..2.......................... 120,971 81,316 - Debt, Service,Total ..Project ...................... ..............1.03............. ............................... 00 2250 ...................704,929.... 1,825,256 2 ,369,5 74 4 3, 14 8, 30 5,688, 4 09 Ca...... ita.'. STREET.............................................................................................................. 1,022,252 1 450 893 1,051,963 938 114 104 ARTERIAL STREET 5,380,807 7,338,446 1,582,095 911,325 2,055,132 301 LAND ACQ, REC & PARK DEVLPMNT 2,421,570 1,565,474 1,236,430 1,099,701 1,633,257 302 FACILITY REPLACEMENT 829,711 1,432,223 1,904,720 2,088,543 2,018,535 303 GENERAL GOVERNMNT IMPROVEMENTS 378,110 453,915 570,592 637,101 433,693 304 FIRE IMPACT FEES 613,058 520,962 454,321 402,514 317,677 Ca,,.ital, Pro' ectTotal ......................................................................................................................................................................................................................................... p ............ ............................... ...............4.00............ ............................... 10,328,186 .... ............................. ..................33..54.1..... 12 271 ,333, 7,199,051 1 114 6, 9 8 7 4 ,396, 09 Enterprise Enterp rise UTILITY..ON..ACCT..( overp ay ments....................... (overpayments) ) 17,544 22,106 27,857 17,122 401 WATER 5,928,220 5,007,023 5,376,215 5,655,077 3,982,420 402 SEWER 6,631,035 5,386,807 3,335,265 2,316,037 1,238,090 411 FOSTER GOLF COURSE 788,121 785,170 622,681 458,643 114,058 ........................................................................................................................................................................................................ 412 SURFACE WATER ............................... ..............1.5,777,068.... 2,396,149 1,399,569 2,361,899 2,985,279 2,683,138 Enter,,..,rise Total 12,596,113 11,718,166 11,442,893 8,034,828 Internal Service 501 EQUIPMENT RENTAL 5,321,862 4,627,495 4,650,880 4,474,197 3,804,498 502 INSURANCE 3,183,595 4,418,574 5,238,745 6,239,565 6,198,009 503 INSURANCE - LEOFF 1 984,062 856,012 735,138 1,666,674 1,904,047 Internal „Service Total ...................................................................................................................................................................................... ............................... ...............9,489,51.9.... 9,902,081 10 624 763 12,380,436 11,906,554 Grand Total 52,932,838 51,072,873 45,226,266 40,526,154 40,994,970 Funds not included in the Grand Total are the fiduciary funds. However, these balances ($1,577,514) are included in the investment balances +Ze CITY OF TUKWILA Treasury Rates and Yield Curves CASH & INVESTMENT REPORT June 30, 2016 Rates at June 30, 2016 3mo 0.26% 6mo 0.36% 1 Yr 0.45% 2Yr 0.58% 3Yr 0.71% 5Yr 1.01% 10Yr 1.49% 30Yr 2.30% Source: US Department of the Treasury Rates at June 30, 2015 Rate % Change Change M111111 11111111 0.25% 96% 3mo 0.01% 0.25% 69% 6mo 0.11% 0.17% 38% 1Yr 0.28% -0.06% -10% 2Yr 0.64% -0.30% -42% 3Yr 1.01% -0.62% -61% 5Yr 1.63% -0.86% -58% 10Yr 2.35% -0.81% -35% 30Yr 3.11% Comparison of Treasury Rates .8 MPD Operating Loan - through end of 2015 only Period Accumulated Interest (Date) Beg Bal Funding Payments Interest End Bal Interest Principal Pmt Pmt 10/1/2011 $ - $ 191,294 $ - $ 319 $ 191,613 $ 319 11/1/2011 191,612.82 - - 319.35 191,932.18 638.18 12/1/2011 191,932.18 - - 319.89 192,252.07 958.07 1/1/2012 192,252.07 - - 320.42 192,572.49 1,278.49 2/1/2012 192,572.49 - - 320.95 192,893.44 1,599.44 3/1/2012 192,893.44 - - 321.49 193,214.93 1,920.93 4/1/2012 193,214.93 225,000.00 - 697.02 418,911.95 2,617.95 5/1/2012 418,911.95 - - 698.19 419,610.14 3,316.14 6/1/2012 419,610.14 - - 699.35 420,309.49 4,015.49 7/1/2012 420,309.49 - - 700.52 421,010.01 4,716.01 8/1/2012 421,010.01 - - 701.68 421,711.69 5,417.69 9/1/2012 421,711.69 - - 702.85 422,414.54 6,120.54 10/1/2012 422,414.54 433,706.00 - 1,426.87 857,547.41 7,547.41 11/1/2012 857,547.41 - - 1,429.25 858,976.66 8,976.66 12/1/2012 858,976.66 - - 1,431.63 860,408.28 10,408.28 1/1/2013 860,408.28 250,000.00 - 1,850.68 1,112,258.96 12,258.96 2/1/2013 1,112,258.96 - - 1,853.76 1,114,112.73 14,112.73 3/1/2013 1,114,112.73 - - 1,856.85 1,115,969.58 15,969.58 4/1/2013 1,115,969.58 - - 1,859.95 1,117,829.53 17,829.53 5/1/2013 1,117,829.53 - 19,692.58 1,863.05 1,100,000.00 19,692.58 19,692.58 6/1/2013 1,100,000.00 - 10,121.48 1,833.33 1,091,711.85 21,525.91 8,288.15 1,833.33 7/1/2013 1,091,711.85 - 10,121.48 1,819.52 1,083,409.89 23,345.43 8,301.96 1,819.52 8/1/2013 1,083,409.89 - 10,121.48 1,805.68 1,075,094.10 25,151.12 8,315.80 1,805.68 9/1/2013 1,075,094.10 - 10,121.48 1,791.82 1,066,764.44 26,942.94 8,329.66 1,791.82 10/1/2013 1,066,764.44 - 10,121.48 1,777.94 1,058,420.90 28,720.88 8,343.54 1,777.94 11/1/2013 1,058,420.90 - 10,121.48 1,764.03 1,050,063.46 30,484.92 8,357.45 1,764.03 12/1/2013 1,050,063.46 - 10,121.48 1,750.11 1,041,692.08 32,235.02 8,371.37 1,750.11 1/1/2014 1,041,692.08 - 10,121.48 1,736.15 1,033,306.76 33,971.18 8,385.33 1,736.15 2/1/2014 1,033,306.76 - 10,121.48 1,722.18 1,024,907.45 35,693.35 8,399.30 1,722.18 3/1/2014 1,024,907.45 - 10,121.48 1,708.18 1,016,494.15 37,401.53 8,413.30 1,708.18 4/1/2014 1,016,494.15 - 10,121.48 1,694.16 1,008,066.83 39,095.69 8,427.32 1,694.16 5/1/2014 1,008,066.83 - 10,121.48 1,680.11 999,625.46 40,775.80 8,441.37 1,680.11 6/1/2014 999,625.46 - 10,121.48 1,666.04 991,170.02 42,441.84 8,455.44 1,666.04 7/1/2014 991,170.02 - 10,121.48 1,651.95 982,700.49 44,093.79 8,469.53 1,651.95 8/1/2014 982,700.49 - 10,121.48 1,637.83 974,216.85 45,731.63 8,483.65 1,637.83 9/1/2014 974,216.85 - 10,121.48 1,623.69 965,719.06 47,355.32 8,497.79 1,623.69 10/1/2014 965,719.06 - 10,121.48 1,609.53 957,207.11 48,964.85 8,511.95 1,609.53 11/1/2014 957,207.11 - 10,121.48 1,595.35 948,680.98 50,560.20 8,526.13 1,595.35 12/1/2014 948,680.98 - 10,121.48 1,581.13 940,140.63 52,141.33 8,540.34 1,581.14 1/1/2015 940,140.63 - 10,121.48 1,566.90 931,586.06 53,708.24 8,554.58 1,566.90 2/1/2015 931,586.06 - 10,121.48 1,552.64 923,017.22 55,260.88 8,568.84 1,552.64 3/1/2015 923,017.22 - 10,121.48 1,538.36 914,434.10 56,799.24 8,583.12 1,538.36 4/1/2015 914,434.10 - 10,121.48 1,524.06 905,836.68 58,323.30 8,597.42 1,524.06 5/1/2015 905,836.68 - 10,121.48 1,509.73 897,224.93 59,833.03 8,611.75 1,509.73 6/1/2015 897,224.93 - 10,121.48 1,495.37 888,598.82 61,328.40 8,626.11 1,495.37 7/1/2015 888,598.82 - 10,121.48 1,481.00 879,958.34 62,809.40 8,640.48 1,481.00 8/1/2015 879,958.34 - 10,121.48 1,466.60 871,303.46 64,276.00 8,654.88 1,466.60 9/1/2015 871,303.46 - 10,121.48 1,452.17 862,634.15 65,728.17 8,669.31 1,452.17 10/1/2015 862,634.15 - 10,121.48 1,437.72 853,950.39 67,165.89 8,683.76 1,437.72 11/1/2015 853,950.39 - 10,121.48 1,423.25 845,252.16 68,589.14 8,698.23 1,423.25 12/1/2015 845,252.1_6_ _ _ _ _ _ - — _ _10,121.48_ 1,40_8.7_5 _ _ _8_36,539.44_ 69,997.90_ _ 8,712.73_ 1,408.75 1/1/2016 836,539.44 - 10,121.48 1,394.23 827,812.19 71,392.13 8,727.25 1,394.23 2/1/2016 827,812.19 - 10,121.48 1,379.69 819,070.40 72,771.82 8,741.79 1,379.69 3/1/2016 819,070.40 - 10,121.48 1,365.12 810,314.03 74,136.93 8,756.36 1,365.12 4/1/2016 810,314.03 - 10,121.48 1,350.52 801,543.08 75,487.46 8,770.96 1,350.52 5/1/2016 801,543.08 - 10,121.48 1,335.91 792,757.50 76,823.36 8,785.57 1,335.91 6/1/2016 792,757.50 - 10,121.48 1,321.26 783,957.28 78,144.62 8,800.22 1,321.26 7/1/2016 783,957.28 - 10,121.48 1,306.60 775,142.40 79,451.22 8,814.88 1,306.60 8/1/2016 775,142.40 - 10,121.48 1,291.90 766,312.82 80,743.12 8,829.58 1,291.90 9/1/2016 766,312.82 - 10,121.48 1,277.19 757,468.53 82,020.31 8,844.29 1,277.19 10/1/2016 757,468.53 - 10,121.48 1,262.45 748,609.50 83,282.76 8,859.03 1,262.45 11/1/2016 748,609.50 - 10,121.48 1,247.68 739,735.70 84,530.44 8,873.80 1,247.68 12/1/2016 739,735.70 - 10,121.48 1,232.89 730,847.11 85,763.33 8,888.59 1,232.89 or urrent 61 MPD Capital Loan PAYMENT BEGINNING DUE DATE BALANCE 2/1/2013 Capital Loan to MPD Repayment Schedule PRINCIPAL INTEREST PAYMENT RATE Amount loaned to the MPD INTEREST PAYMENT ENDING 1,000,000.00 6/1/2013 1,000,000.00 (50,731.67) 0.02 (5,833.33) 949,268.33 12/1/2013 949,268.33 (48,258.90) 0.02 (8,306.10) 901,009.43 6/1/2014 901,009.43 (48,681.17) 0.02 (7,883.83) 852,328.26 12/1/2014 852,328.26 (49,107.13) 0.02 (7,457.87) 803,221.13 6/1/2015 803,221.13 (49,536.82) 0.02 (7,028.18) 753,684.31 _ 1.2/1/2015_ _ 753, 684.31_ _ �49_970.26L _ _ _ _0.02_ _ _ (6,594_7 _ _ 70_3_714_0_5 _ 6/1/2016 703,714.05 (46,537.07) 0.03 (10,027.93) 657,176.98 12/1/2016 657,176.98 (47,200.23) 0.03 (9,364.77) 609,976.75 6/1/2017 609,976.75 (47,872.83) 0.03 (8,692.17) 562,103.92 12/1/2017 562,103.92 (48,555.02) 0.03 (8,009.98) 513,548.90 6/1/2018 513,548.90 (49,246.93) 0.03 (7,318.07) 464,301.97 12/1/2018 464,301.97 (49,948.70) 0.03 (6,616.30) 414,353.27 6/1/2019 414,353.27 (48,277.93) 0.04 (8,287.07) 366,075.34 12/1/2019 366,075.34 (49,243.49) 0.04 (7,321.51) 316,831.85 6/1/2020 316,831.85 (50,228.36) 0.04 (6,336.64) 266,603.49 12/1/2020 266,603.49 (51,232.93) 0.04 (5,332.07) 215,370.56 6/1/2021 215,370.56 (52,257.59) 0.04 (4,307.41) 163,112.97 12/1/2021 163,112.97 (53,302.74) 0.04 (3,262.26) 109,810.23 6/1/2022 109,810.23 (54,368.80) 0.04 (2,196.20) 55,441.43 12/1/2022 55,441.43 (55,441.43) 0.04 (1,108.83) 0.00 (131,285.26) 62 Prior Current City of Tukwila Allan Ekberg, Mayor INFORMATIONAL MEMORANDUM TO: Mayor Ekberg Finance and Safety Committee FROM: Peggy McCarthy, Finance Director BY: Lily Jue, Fiscal Coordinator DATE: December 6, 2016 SUBJECT: Sales Tax and Miscellaneous Revenue Report - 3rd Quarter 2016 Schedule I - Sales Tax in $1,000's Third quarter total sales tax collections is down by $270K as compared with the same quarter in the previous year. There has been a notable decline in sales tax collections from Other Industries of $253K, or a decrease of 6 %, while at the same time the Construction sales tax revenue has declined by $17K, or down by 5% during this quarter. 63 2015 Actual 2016 Actual YOY Change Other -- Month Other Total Other Total Construction Industries ! Total Collect- Construe I Construe I I i ed Rec'd tion 1 Industries tion 1 Industries Amount % Amount % Amount % Jan Mar $ 85 I $ 1,195 I $ 1,280 $ 99 I $ 1,190 I $ 1,289 $ 14 16 %1 $ (5) 0 %1 $ 9 1% Feb Apr 861 1,2271 1,313 971 1,2301 1,328 11 13 %1 3 0 %1 15 1% Mar May 100 ' 1,362 ' 1,462 106 ' 1,4131 1,519 6 6 %' 51 4 %' 57 4% C -1 Totals $ 271 3,784 $ 4,055 $ 302 3,834 $ 4,136 $ 31 11 %: 50 1 %: $ 81 2% Apr Jun 109 1,210 1,319 105 1,336 1,440 (4) -4 %: 126 10 % 121 9% May Jul 91 1,453 1,544 118 1,362 1,480 27 29 %!. (91) -6 %!. (65) -4% Jun Aug 141 ! 1,621 ! 1,762 143 ! 1,549 ! 1,692 2 1 %! 73 -4 %! 71 -4% C -2 Totals $ 341 ! 4,285 ! $ 4,626 $ 365 ! 4,246 ! $ 4,612 $ 24 7 %! (38) -1 %! $ (14) 0% Jul Sep 95 1,653 1,748 109 1,4281 1,537 14 14 %i (224) -14 %! (211) -12% Aug Oct 133 i 1,463 i 1,596 111 i 1,438 i 1,549 (21) -16 %i (25) -2 %i (46) -3% Sep Nov 124 ' 1,448 ' 1,572 115 ' 1,4441 1,559 9 -8 %' 4 0 %' 13 -1% C -3 Totals $ 352 4,564 $ 4,916 $ 335 4,310 $ 4,646 $ (17) -5 %: (253) -6 %: $ (270) -5% Oct Dec 93 i 1,414 i 1,507 Nov Jan 98 ; 1,370 ; 1,468 Dec Feb 100 1,992 ! 2,092 C -4 Totals $ 291 ! 4,776 ! $ 5,067 $ - i $ - $ Totalsj $ 1,256 i 17,409 i $18,664 $ 1,003 i 12,391 i $13,393 $ 38 i (241) Third quarter total sales tax collections is down by $270K as compared with the same quarter in the previous year. There has been a notable decline in sales tax collections from Other Industries of $253K, or a decrease of 6 %, while at the same time the Construction sales tax revenue has declined by $17K, or down by 5% during this quarter. 63 INFORMATIONAL MEMO Page 2 Budget to Actual - Sales Tax in $1,000's Schedule I - Sales Tax Actual total year -to -date revenue from sales tax collections received continues to exceed amended budget estimates by $314K of overall budget through September. 64 W: \FIN Projects \Sales Tax Information\2016 \Info Memo Sales Tax - 2016 -Q3 2016MEMO (Dec 2016).docx 2015 2016 Variance [actual Over (Unger) -- Month -- Amended Budget] Collect- Original Amended ed Rec'd Actual Budget Budget + Actual Amt % Jan Mar $ 1,280 $ 1,162 $ 1,231 $ 11289 58 5% Feb Apr 1,313 $ 1,193 $ 1,263 1,328 65 5 % Mar May 1,462 $ 1,328 $ 1,406 1,519 113 8 % Q -1 Totals $ 4,054 $ 3,683 $ 3,900 $ 4,136 $ 236 6% Apr Jun 1,319 $ 1,198 $ 1,269 1,440 171 14% May Jul 1,544 $ 1,403 $ 1,486 1,480 (6) 0% Jun Aug 1,762 $ 1,601 $ 1,695 1,692 4 0% Q -2 Totals $ 4,626 $ 4,202 $ 4,450 $ 4,612 $ 162 4% Jul Sep 1,748 $ 1,588 $ 1,681 1,537 (144) -9% Aug Oct 1,596 $ 1,450 $ 1,535 1,549 14 1% Sep Nov 1,572 $ 1,428 $ 1,513 1,559 47 3% Q -3 Totals $ 4,916 $ 4,466 $ 4,729 $ 4,646 $ 83 -2% Oct Dec 1,507 $ 1,369 $ 1,450 - - Nov Jan 1,469 $ 1,334 $ 1,413 Dec Feb 2,092 $ 1,901 $ 2,012 - Q -4 Totals $ 5,067 $ 4,604 $ 4,875 $ - $ - $ - Totals $ 18,664 $ 16,954 $ 17,954 $ 13,394 $ 314 Actual total year -to -date revenue from sales tax collections received continues to exceed amended budget estimates by $314K of overall budget through September. 64 W: \FIN Projects \Sales Tax Information\2016 \Info Memo Sales Tax - 2016 -Q3 2016MEMO (Dec 2016).docx INFORMATIONAL MEMO Page 3 Below is a graph of sales tax collections by type of industry showing overall change between the 2015 and 2016 revenue receipts. The overall Construction increase shown above continues to be within the Contractors NAICS category 238 by $128K, or 51.7% over the same quarter last year. Both the Manufacturing and Transportation/Warehousing industries have been relatively stable throughout the year. The overall continuing decline in the "Wholesale Trade" category is attributable to the NAICS category 423, "Wholesale Trade in Durable Goods" by $512K, or down 37% year -to -date. The increase in the "Retail Trade" group is due to increased year -to -date sales activity in the categories of Electronics & Appliances of $131 K and Miscellaneous Store Retailers of $70K. Of the total $204K year -to -date increase in the "Services" industry, there were combined year - to -date increases totaling over $213K in the categories of: Finance & Insurance, Real Estate /Rental /Leasing, Healthcare Social Assistance and Accommodation & Food Services. The miscellaneous category includes activities from agriculture, forestry, fishing and mining /utilities with "Unclassifiable Establishments" showing an overall year -to -date decrease of $107K, or down nearly 38 %. The Unclassifiable Establishments include those taxpayers who report use taxes to a special trust account under NAICS code 999. In 2015, there was a large taxable amount of $14.3 million reported, whereas in 2016 there has been a decrease in reported taxable gross revenue. WARN Projects \Sales Tax Information\2016 \Info Memo Sales Tax - 2016 -Q3 2016MEMO (Dec 2016).docx 65 INFORMATIONAL MEMO Page 4 Schedule II shows the year -to -date sales tax from the top ten industry classifications. Electronics and Appliances in the NAICS 443 category has the highest year over year increase at $131,202 due to growth in overall gross sales. This is followed by an increase of $70,005 in the category of Miscellaneous Store Retailers as well as an increase of $37,756 in the category of Building Material and Garden. These are also attributable to an overall increase in reported gross revenues for the current period. Schedule II Schedule III shows the ten largest declines in sales tax revenue for industries with over $7,000 collected year -to -date. While the NAICS category for Wholesale Trade & Durable Goods experienced a current quarter decrease in sales tax collections of $512K, the NAICS category 611 for Educational Services had a 64.2% decrease in sales activity over the previous year. Schedule III YTD YTD Dollar % Group Name Current Prior Diff. Diff. 452 General Merchandise Stores $ 1,579,747.29 $ 1,567,521.77 $ 12,226 0.78% 448 Clothing and Accessories $ 1,460,551.12 $ 1,510,722.02 $ (50,171) -3.32% 722 Food Services, Drinking Places $ 1,307,449.90 $ 1,272,667.67 $ 34,782 2.73% 423 Wholesale Trade, Durable Goods $ 873,970.05 $ 1,386,159.95 $ (512,190) - 36.95% 443 Electronics and Appliances $ 849,236.41 $ 718,034.57 $ 131,202 18.27% 236 Construction of Buildings $ 563,342.75 $ 644,119.41 $ (80,777) - 12.54% 444 Building Material and Garden $ 562,902.66 $ 525,146.44 $ 37,756 7.19% 721 Accommodation $ 520,183.19 $ 495,737.51 $ 24,446 4.93% 453 Miscellaneous Store Retailers $ 508,396.01 $ 438,390.98 $ 70,005 15.97% 517 Telecommunications $ 486,638.83 $ 519,897.07 $ (33,258) -6.40% Schedule III shows the ten largest declines in sales tax revenue for industries with over $7,000 collected year -to -date. While the NAICS category for Wholesale Trade & Durable Goods experienced a current quarter decrease in sales tax collections of $512K, the NAICS category 611 for Educational Services had a 64.2% decrease in sales activity over the previous year. Schedule III 66 WARN Projects \Sales Tax Information\2016 \Info Memo Sales Tax - 2016 -Q3 2016MEMO (Dec 2016).docx YTD YTD Dollar % Group Name Current Prior Diff. Diff. 423 Wholesale Trade, Durable Goods $ 873,970.05 $ 1,386,159.95 $ (512,190) - 36.95% 999 Nonclassifiable Establishments $ 175,678.27 $ 282,386.49 $ (106,708) - 37.79% 236 Construction of Buildings $ 563,342.75 $ 644,119.41 $ (80,777) - 12.54% 448 Clothing and Accessories $ 1,460,551.12 $ 1,510,722.02 $ (50,171) -3.32% 517 Telecommunications $ 486,638.83 $ 519,897.07 $ (33,258) -6.40% 454 Nonstore Retailers $ 131,157.90 $ 161,672.87 $ (30,515) - 18.87% 532 Rental and Leasing Services $ 442,780.55 $ 462,061.78 $ (19,281) -4.17% 237 Heavy and Civil Construction $ 57,685.47 $ 73,593.13 $ (15,908) - 21.62% 713 Amusement, Gambling, and Rec $ 160,031.74 $ 174,605.92 $ (14,574) -8.35% 611 Educational Services $ 7,431.23 $ 20,760.46 $ (13,329) - 64.20% 66 WARN Projects \Sales Tax Information\2016 \Info Memo Sales Tax - 2016 -Q3 2016MEMO (Dec 2016).docx INFORMATIONAL MEMO Page 5 The following charts show sales tax receipts the City collected from major industries from 2010 through the current year. These categories include retail, services, wholesale, construction, and other consisting of manufacturing, transportation & warehousing, automotive, and miscellaneous. Retail Construction Other -Mfg. Trnsp /Wrhsng, Automotive, & Misc. WARN Projects \Sales Tax Information\2016 \Info Memo Sales Tax - 2016 -Q3 2016MEMO (Dec 2016).docx 67 INFORMATIONAL MEMO Page 6 Below is Schedule IV which shows quarterly gambling tax earned for the prior year compared to the current year. Schedule IV -Gambling Tax (a) Gambling tax actual revenue collected through September reporting continues to exceed year - to -date allocated budget estimates by a total of $885K, or 47.6% overall budgeted increase. Actual total year- over -year increase as compared with 2015 is $688K, or 33.5% higher. Casinos within the City continue to do well. Schedule V shows monthly admissions tax receipts for the prior year and current year to date. Schedule V - Admissions Tax (b) (d) 2016 INCREASE (DECREASE) Quarter 2015 2016 Allocated YEAR OVER YEAR BUDGET VARIANCE Earned Actual Actual Budget Amount % Amount % Q1 $ 129,245 $ (d) 2016 $ 32,024 INCREASE (DECREASE) Quarter 2015 2016 Allocated YEAR OVER YEAR BUDGET VARIANCE Earned Actual Actual Budget Amount % Amount % Q1 $ 698,773 $ 950,379 $ 631,914 $ 251,606 36% $ 318,465 50% Q2 679,484 867,047 614,471 187,562 28% 252,576 41% Q3 677,923 927,316 613,059 249,393 37% 314,257 51% Q4 743,365 - 672,240 - - - - Totals $2,799,545 $ 2, 744, 742 $2,531,684 $ 688,562 - $ 885,298 - Gambling tax actual revenue collected through September reporting continues to exceed year - to -date allocated budget estimates by a total of $885K, or 47.6% overall budgeted increase. Actual total year- over -year increase as compared with 2015 is $688K, or 33.5% higher. Casinos within the City continue to do well. Schedule V shows monthly admissions tax receipts for the prior year and current year to date. Schedule V - Admissions Tax (b) (d) 2016 INCREASE (DECREASE) Quarter 2015 2016 Allocated YEAR OVER YEAR BUDGET VARIANCE Earned Actual Actual Budget Amount % Amount % Q1 $ 129,245 $ 161,269 $ 135,169 $ 32,024 25% $ 26,100 19% Q2 171,745 156,588 179,617 (15,157) -9% (23,029) -13% Q3 159,808 157,862 167,133 (1,946) _1% (9,271) -6% Q4 166,452 - 174,081 - - - - Totals $ 627,250 $ 475,719 $ 656,000 $ 14,921 - $ (6,200) - While admissions tax actual revenue received through September reporting decreased by a total of $6K, or 1.3% less than budgeted projectons, the actual total year- over -year increase is nearly $15K compared to 2015, or 3.2% higher. Schedule VI shows monthly telecommunications utility tax receipts for the prior year and current year to date. Schedule VI - Telecommunications Utility Tax (C) As telecommunications utility tax collections received through September reporting exceeded year -to -date budgeted projections by a total of $14K, or is up by 1.5 %, actual total year -over- year receipts has decreased by $7K, or down slightly by just 1 %. (a) Gambling tax currently includes card games, punch boards, pull tabs, and amusement games. (b) Excludes golf course admissions tax. (c) Telecommunications Utility tax currently includes cellular, pager and telephone usage. (d) Actuals reflected in Schedules IV, V and VI are amounts earned through second quarter 2016. 68 W: \FIN Projects \Sales Tax Information\2016 \Info Memo Sales Tax - 2016 -Q3 2016MEMO (Dec 2016).docx (d) 2016 INCREASE (DECREASE) Quarter 2015 2016 Allocated YEAR OVER YEAR BUDGET VARIANCE Earned Actual Actual Budget Amount % Amount % Q1 $ 317,991 $ 348,156 $ 311,176 $ 30,166 9% $ 36,980 12% Q2 349,024 321,852 341,544 (27,172) -8% (19,692) -6% Q3 327,197 317,156 320,185 (10,041) -3% (3,029) _1% Q4 319,135 - 312,295 - - - - Totals $ 1,313,347 $ 987,164 $ 1,285,200 $ (7,047) - $ 14,259 - As telecommunications utility tax collections received through September reporting exceeded year -to -date budgeted projections by a total of $14K, or is up by 1.5 %, actual total year -over- year receipts has decreased by $7K, or down slightly by just 1 %. (a) Gambling tax currently includes card games, punch boards, pull tabs, and amusement games. (b) Excludes golf course admissions tax. (c) Telecommunications Utility tax currently includes cellular, pager and telephone usage. (d) Actuals reflected in Schedules IV, V and VI are amounts earned through second quarter 2016. 68 W: \FIN Projects \Sales Tax Information\2016 \Info Memo Sales Tax - 2016 -Q3 2016MEMO (Dec 2016).docx SALES TAX SUMMARY 3rd Quarter 2016 (Received in March 2016 - November 2016) NAICS CONSTRUCTION 236 Construction of Buildings 237 Heavy & Civil Construction 238 Specialty Trade Contractors 15 TOTAL 816,608 83,868 354,811 TOTAL CONSTRUCTION $ 1,255,287 $ Overall Construction Change from Previous Year MANUFACTURING 311 Food Manufacturing 312 Beverage & Tobacco Products 313 Textile Mills 314 Textile Product Mills 315 Apparel Manufacturing 316 Leather & Allied Products 321 Wood Product Manufacturing 322 Paper Manufacturing 323 Printing & Related Support 324 Petroleum & Coal Products 325 Chemical Manufacturing 326 Plastic & Rubber Products 327 Nonmetallic Mineral Products 331 Primary Metal Manufacturing 332 Fabricated Metal Mfg Products 333 Machinery Manufacturing 334 Computer & Electronic Products 335 Electric Equipment, Appliances 336 Transportation Equipment Mfg 337 Furniture & Related Products 339 Miscellaneous Manufacturing TOTAL MANUFACTURING 15 TOTAL 7,984 6,892 206 12,439 752 44 2,201 22,787 30,445 16 9,219 3,774 3,227 2,115 4,342 12,189 6,661 4,678 129,312 6,908 14,923 $ 281,114 $ Overall Manufacturing Change from Previous Year TRANSPORTATION & WAREHOUSING 481 Air Transportation 482 Rail Transportation 484 Truck Transportation 485 Transit and Ground Passengers 487 Scenic and Sightseeing Tran 488 Transportation Support 491 Postal Services 492 Couriers & Messengers 493 Warehousing & Storage TOTAL TRANSP & WHSING $ Overall Transportation Change from Previous 15 TOTAL 0 839 2,809 1,211 2,567 48,590 710 992 1,272 58,990 $ Year WHOLESALE TRADE 15 TOTAL 423 Whls Trade - Durable Goods 1,858,044 424 Whls Trade - Nondurable Goods 158,224 425 Wholesale Electronic Markets 2,975 WHOLESALE TRADE TOTAL $ 2,019,243 $ co Overall Wholesale Change from Previous Year 15 YTD 644,119 73,593 248,239 965,952 $ 15 YTD 5,062 5,608 180 9,206 586 44 1,825 16,748 21,522 12 7,249 2,511 2,459 1,548 2,422 960 4,998 4,321 91,886 5,938 11,268 196,352 $ 15 YTD 0 0 2,140 532 925 37,607 512 796 1,053 43,565 YTD 16 YTD %Diff 563,343 -12.5% 57,685 - 21.6% 376,691 51.7% 997,719 $31,767 3.3% YTD 16 YTD % Diff 6,173 22.0% 2,719 - 51.5% 169 -5.9% 8,157 - 11.4% 810 38.4% 28 - 35.6% 2,106 15.4% 20,410 21.9% 20,361 -5.4% 15 29.4% -2,262 - 131.2% 5,628 124.2% 1,761 -28.4% 1,729 11.6% 8,868 266.2% 10,151 957.6% 3,718 -25.6% 2,131 - 50.7% 87,430 -4.8% 3,926 - 319% 13,470 19.5% 197,501 $1,148 0.6% YTD 16 YTD % Diff 0 0.0% 36 0.0% 1,648 - 23.0% 247 - 53.7% 2,022 118.5% 37,250 -0.9% 536 4.7% 2,048 157.2% 1,077 2.3% $ 44,864 $1,298 3.0% 15 YTD 16 YTD 1,386,160 873,970 119,892 121,941 2,415 1,868 1,508,467 $ 997,779 ($510,688) -33.9% YTD % Diff - 37.0% 1.7% -22.7% NAICS AUTOMOTIVE 15 TOTAL 441 Motor Vehicle & Parts Dealer 736,250 447 Gasoline Stations 88,948 TOTAL AUTOMOTIVE $ 825,199 $ Overall Automotive Change from Previous Year NAICS 442 443 444 445 446 448 451 452 453 454 RETAIL TRADE Furniture & Home Furnishings Electronics & Appliances Building Material & Garden Food & Beverage Stores Health & Personal Care Clothing & Accessories Sporting Goods, Hobby, Books General Merchandise Stores Miscellaneous Store Retailers Nonstore Retailers TOTAL RETAIL TRADE 15 TOTAL 433,006 1,053,598 683,037 222,002 293,982 2,159,644 607,620 2,205,774 652,495 218,152 $ 8,529,311 $ Overall General Retail Change from Previous Year SERVICES 15 TOTAL 51X Information 818,883 52X Finance & Insurance 119,526 53X Real Estate, Rental, Leasing 582,227 541 Professional, Scientific, Tech 499,110 551 Company Management 2 56X Admin, Supp, Remed Svcs 123,092 611 Educational Services 25,643 62X Health Care Social Assistance 334,406 71X Arts & Entertainment 251,187 72X Accommodation & Food Svcs 2,329,336 81 X Other Services 236,159 92X Public Administration 73,067 TOTAL SERVICES $ 5,392,636 $ Overall Services Change from Previous Year MISCELLANEOUS 15 TOTAL 000 Unknown 18 111 -115 Agriculture, Forestry, Fishing 314 211 -221 Mining & Utilities 791 999 Unclassifiable Establishments 300,911 MISCELLANEOUS TOTAL $ 302,034 $ Overall Miscellaneous Change from Previous Year 15 TOTAL YTD 15 YTD 16 YTD % Diff 493,141 480,445 -2.6% 67,240 67,083 -0.2% 560,381 $ 547,527 ($12,854) -2.3% 15 YTD 315,899 718,035 525,146 162,864 205,120 1,510,722 417,721 1,567,522 438,391 161,673 6,023,093 $ 15 YTD 629,091 64,423 480,063 315,418 0 93,178 20,760 210,961 201,714 1,768,405 176,069 55,971 4,016,053 $ 15 YTD 4 164 301 282,386 282,855 $ 15 YTD 16 YTD % Diff 323,864 2.5% 849,236 18.3% 562,903 7.2% 169,117 3.8% 219,951 7.2% 1,460,551 -3.3% 406,856 -2.6% 1,579,747 0.8% 508,396 16.0% 131,158 - 18.9% 6,211,780 $188,687 3.1% YTD 16 YTD % Diff 643,250 2.3% 101,252 57.2% 483,273 0.7% 391,317 24.1% 5 0.0% 110,148 18.2% 7,431 - 64.2% 252,396 19.6% 191,751 -4.9% 1,827,633 3.3% 160,959 -8.6% 50,690 -9.4% 4,220,105 $204,052 5.1% YTD 16 YTD % Diff 0 - 100.0% 257 57.1% -87 - 128.9% 175,678 - 37.8% 175,848 ($107,007) -37.8% YTD 16 YTD % Diff GRAND TOTALS $18,663,814 $13,596,719 Grand Total Change from Previous Year Grand Total Change from Previous Year - Without New Construction $13,393,123 ($203,595) -1.50% ($235,363) -1.86% 70 Tukwila Police Department Finance and Safety Committee Quarterly Information Brief 3rd Quarter, 2016 Finance & Safety Quarterly Information Brief 3rd QUARTER HIGHLIGHTS U Staffing • New Entry Level Officer • Peter Tiemann U Recognition ':'Outstanding Pc Ron Corrigan Finance & Safety Quarterly Information Brief 3rd QUARTER HIGHLIGHTS U Community Outreach + Police Safety Education To Refugee Children • Ramadan Celebration + Presentation to Tukwila Teens Group + World Affairs Council Meeting + Night Out Against Crime + School Safety Patrol Training Finance & Safety Quarterly Information Brief 3rd QUARTER HIGHLIGHTS U Community Outreach (cont'd) + Somali Soccer Tournament + Houses of Worship + Somali Youth Presentation + Community Service Officer Position Finance & Safety Quarterly Information Brief 3rd QUARTER HIGHLIGHTS U Significant Operations & Events + Fourth of July Event + Facilities Planning + Juvenile Justice Equity Steering Committee • Police Executive Research Forum in DC + Boeing Founders Day —July 16th and July 17tH + G0vQA +Social Media Project Finance & Safety Quarterly Information Brief 3rd QUARTER HIGHLIGHTS U Significant Operations & Events + Taking Back Our Boulevard — Equitable Share Forfeiture Monies - $545,888 + Records Management System — Spillman + Marijuana Grow Investigation + Juvenile Prostitution Investigation + Auto Theft Task Force Emphasis + Suspect of La Rachelle Apts captured in Idaho Finance & Safety Quarterly Information Brief 3rd QUARTER CRIME STATISTICS 3000 2500 2000 N O a. iJC 1500 In cD u 1000 500 0 Case Reports 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 Third Quarter 2005 -2016 Third Quarter Average Finance & Safety Quarterly Information Brief 3rd QUARTER CRIME STATISTICS Calls for Service 12000 10000 8000 6000 4000 2000 0 Calls for Service • 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 =Third Quarter 2005 -2016 Third Quarter Average Finance & Safety Quarterly Information Brief 3rd QUARTER CRIME STATISTICS Robbery in 0 0 0 00 0 ° O O 0 0 0 0 rl 0 N N rl 0 N M rl 0 N rl O N Lfl rl 0 N rl 0 N Third Quarter 2005- 2016 Third Quarter Average 2016 CRIME STATISTICS 14 12 10 8 6 4 2 0 Finance & Safety Quarterly Information Brief Robbery Offenses 2016 Compared to Previous Years -=== = ;;=;---;;—;7■--= \\I T Lii _a c > _a ra - Li- (0 0 a) (1) co - s_ c 2 < 2 ▪ 0 z oo CL < (f) Range Since 2005 Finance & Safety Quarterly Information Brief 3rd QUARTER CRIME STATISTICS 35 30 25 a, 20 4- O 15 10 5 0 Aggravated Assault L.f) up N 00 Cr) 0 T -I N en d' Ln LID 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 N N N N N N N N N N N N Third Quarter 2005- 2016 Third Quarter Average 2016 CRIME STATISTICS 14 12 Finance & Safety Quarterly Information Brief Aggravated Assault Offenses 2016 Compared to Previous Years k 10 \ 8 \ _ \ \�� 6_ ` u 0 cam. Z ii- : - - 4 ~y \ ` 0 L.n -0 S- S- > c tin Q I. > u LO -0 > c tin Q o Q Q cn O z o °� 2 co < 2 Q cn Range Since 2005 2015 -2016 Finance & Safety Quarterly Information Brief 3rd QUARTER CRIME STATISTICS Burglary 1st and 2nd Degree 0 0 0 0 0 ° 0 0 0 0 0 0 0 N N m 0 N N N LID N Third Quarter 2005- 2016 .Third Quarter Average 2016 CRIME STATISTICS 25 20 Finance & Safety Quarterly Information Brief Commercial Burglary Offenses 2016 Compared to Previous Years 15 ~ a _ EE- �: No Range Since 2005 Finance & Safety Quarterly Information Brief 3rd QUARTER CRIME STATISTICS 60 50 40 N Vl 30 0 20 10 0 Residential Burglary Lfl l0 N 00 Ol 0 r-I N M Lf1 l0 0 0 0 0 0 O O 0 0 0 0 0 0 0 0 0 0 N N N N N N N N N N N N Third Quarter 2005- 2016 Third Quarter Average 2016 CRIME STATISTICS 30 25 20 Finance & Safety Quarterly Information Brief Residential Burglary Offenses 2016 Compared to Previous Years 15 :-= Z--- - ---.- 3-'—. :„— -..-- V , ...--,_ Z---- :-.-- 10 „, ''',4,,,,■• , ...._---= S, ”. , ■. '''■1 .. _. ot \ \ 4 Range Since 2005 2014-2 015 S- S- c (13 0_ co oo CL < (1) U > U 0 (1) z >. c -5 tto CL C u_ 2 < 2 —, < (..) NI c co Finance & Safety Quarterly Information Brief 3rd QUARTER CRIME STATISTICS 200 180 160 140 120 tn a) N cuC 100 4- 80 60 40 20 0 Auto Theft if) (.0 N 00 Ol 0 N m if) lfl o o o o o o o o o o o o N N N N N N N N N N N N Third Quarter 2005- 2016 Third Quarter Average 2016 CRIME STATISTICS 70 60 50 40 30 20 10 0 Finance & Safety Quarterly Information Brief Auto Theft Offenses 2016 Compared to Previous Years c Q te% e 04 e` ' at Pic Oti� l cO�fi10 kef �aJ >a >a� Range Since 2005 2015 -2016 Finance & Safety Quarterly Information Brief 3rd QUARTER CRIME STATISTICS 400 350 300 250 N Vl 200 O 150 100 50 Theft from Vehicle if) O O O O N- o O N N N 00 O O N O O N 0 N N 0 N M 0 N O N if) 0 N 0 N Third Quarter 2005- 2016 Third Quarter Average 2016 CRIME STATISTICS 180 160 Finance & Safety Quarterly Information Brief Theft from Vehicle Offenses 2016 Compared to Previous Years 140 120 100\ 80 60 40 20 Range Since 2005 2014 -2015 Finance & Safety Quarterly Information Brief Questions?