Loading...
FEDRAC PKT 07-28-2020CITY OF Federal Way FINANCE/ECONOMIC DEVELOPMENT/REGIONAL AFFAIRS COMMITTEE [FEDRAC] Notice: Pursuant to Governor Inslee's Proclamation 20-28, all in -person meetings are prohibited until further notice. The Mayor and City Council are providing opportunities for public comment by submitting written comment or calling into the meeting to provide oral testimony. To access these options please use the following: Click Here to Watch Online Live Streaming Video of the Meeting Listen to the live meeting: (888) 788-0099 or 253-215-8782 Meeting ID: 422 053 447 Sign -Up* here to give citizen comment during the meeting (via calling -in) 0 Click Here to submit written comments to the City Council 9 Watch from the Zoom mobile app with meeting: 422 053 447 and password: 452084 TUESDAY — July 28, 2020 5:00 P.M. AGENDA 1. CALL TO ORDER 2. PUBLIC COMMENT 3. COMMITTEE BUSINESS Page # Topic Title/Description A. APPROVAL OF SUMMARY MINUTES —JUNE 23,202 3 B. CIVIC PLUS — SEECLICKFIX FOR EYES ON FEDERAL WAY 7 C. MICROSOFT ENTERPRISE AGREEMENT 17 D. VOUCHERS —JUNE 2020 E. MONTHLY FINANCIAL REPORT—JUNE 2020 4. OTHER Utility Tax Update 5. FUTURE AGENDA ITEMS 39 73 Presenter/ Action or Time Allotted Discussion D. ALMBERG 5 MINUTES T. FICHTNER 5 MINUTES T. FICHTNER 5 MINUTES A. ARIWOOLA 5 MINUTES A. ARIWOOLA 5 MINUTES Hl I IUN 7/28 Committee Hl I IUN 8/11Council Consent ACTION 8/11Council Consent ACTION 8/11Council Consent ACTION 8/11 Council Consent NEXT MEETING: August 25, 2020 @ 5:00 P.M. City Staff: Hoang Tran, Chair Ade Ariwoola, Finance Director Mark Koppang Dana Almberg, Administrative Assistant II Linda Kochmar 253-835-2527 CITY ❑F �. Federal Way Centered on Opportunity This page was intentionally left blank. JACITY OF FederalWay City Council Finance/Economic Development/Regional Affairs Committee Tuesday, June 23, 2020 5:00 p.m. SUMMARY MINUTES Meeting held remotely via Zoom CALL TO ORDER: Council Chair Hoang Tran called the meeting to order at 5:00 p.m. COMMITTEE MEMBERS VIA ZOOM: Chair Tran, Councilmember Koppang, and Councilmember Kochmar. COUNCILMEMBERS VIA ZOOM: Council President Honda; Councilmember Baruso; Councilmember Assefa — Dawson; and Councilmember Moore STAFF MEMBERS VIA ZOOM: Finance Director Ade Ariwoola; Accounting Manager Chase Donnelly; City Attorney Ryan Call; Economic Development Director Tim Johnson; Police Chief Andy Hwang; Police Commander Kurt Schwan; Public Works Director EJ Walsh; IT Director Thomas Fichtner; Parks Director John Hutton; Community Relations Liaison/Contract Administrator Autumn Gressett; PAEC General Manager Brian Hoffman; Executive Assistant to the Council Jeri -Lynn Clark; and Administrative Assistant II Dana Almberg PUBLIC COMMENT: No public comment Council Chair Tran announced that item G — Ordinance: 2019/2020 Biennial Budget Amendment is being pulled from this agenda to allow the Mayor and management to make some modifications. A. Approval of Summary Minutes — May 26, 2020 Meeting Motion made by Councilmember Koppang to approve the minutes from May 26, 2020 as written; motion seconded by Councilmember Kochmar and carried 3-0. B. Tourism Enhancement Grant Recommendation for July -December 2020: Presented by Economic Development Director Tim Johnson. This is the second round of the annual Tourism Enhancement Grant. Due to COVID-19, many applicants are unable to present their events. The funding for the Grants comes from the one percent collected through the City's Lodging Tax. These grants can be used for events and festivals, marketing tourism venues and capital improvements for tourism -oriented venues in the effort to increase hotel stays in Federal Way. Applications are reviewed and awarded by the Committee twice a year for activities occurring from January to June and July to December. Tuesday, June 23, 2020 Page 1 3 CITY OF Feder l Way The Lodging Tax Committee recommendation is to approve a total of $4,000 in grants to the following: • Federal Way Knights Annual Baseball Tournament: $1,500.00 • Northern Body Building Championships: $2.500.00 Council President Honda asked the question if the recipients need to spend the money before they get it from the City, is it reimbursable? Director Johnson said this is a reimbursement grant, so they do have to spend it and then get reimbursed. Motion made by Councilmember Kochmar to forward Option 1, to the July 7, 2020 consent agenda for approval; motion seconded by Councilmember Koppang and carried 3-0. C. 2020 COPS Hiring Program Grant: Presented by Police Commander, Kurt Schwan. Commander Schwan is presenting the 2020 COPS Hiring Program (CHP) grant in the amount of $750,000 from the U.S. Department of Justice. By accepting this, the City commits to hiring six officers over the three - year award period (2020-2023). The CHP is a competitive award program intended to reduce crime and advance public safety through community policing by providing funding for the hiring of law enforcement officers. The Federal Way Police Department has been awarded multiple CHP grants, the latest being 2017, which will expire in November of this year. With the acceptance of this grant and the addition of six officers, the police to population ratio will become more in line with the nationally accepted 1.4 officers per 1,000 persons of city population. We can immediately start drawing on this as early as October of this year. The money can only be used for salary and benefits only. This grant is for entry level officers. Finance Director Ariwoola wanted to bring to the Council's attention that there is a matching requirement. The City will need to come up with matching grant to provide equipment, vehicles, etc. The grant will only cover approximately 60-70% of the salary. Also, we are required to keep the additional officers after the three years and fund the 60-70% that will be funded by the grant now. Chief Hwang wanted to clarify the commitment for this grant and hiring six officers does not mean that later on we are committed to keeping all 140 officers. During normal budget cycles, we can reduce the Police Department budget by cutting FTE's if need be. Motion made by Councilmember Kochmar to forward Option 1, to the July 7, 2020 consent agenda for approval; motion seconded by Councilmember Koppang and carried 3-0. D. Performing Arts and Event Center Report: Presented by Community Relations Liaison/Contract Administrator, Autumn Gressett and PAEC General Manager, Brian Hoffman. General Manager Hoffman provided an update on the PAEC, notable areas included: • Last event held inside the PAEC was March 4, 2020 Tuesday, June 23, 2020 Page 2 4 CITY OF FederalWay • Facility closed March 9, 2020 • 35 Part-time staff members furloughed March 12, 2020 • Three City departments re -located to the PAEC March 13. 2020 • 3 out of 5 Full-time employees furloughed on May 1. 2020 • The only Spectra staff on the payroll are the General Manager— on site daily and the Finance Director who is working remotely. Spectra is looking at revenue and cost saving measures. In May, there was seven days of Amazon truck driver training held in the parking lot, and we are looking to hopefully hold more in late June and July. Some other parking lot ideas are Outdoor home shows, Outdoor Spa shows, Flea Market or Community garage sale and Food truck Fridays. Approximately $22,000 a month is the cost savings from furloughs, minimal janitorial and utilities. Some opportunities once Washington State moves to Phase 3 are: Indoor movies, Small meetings (less than 50 people), and Phase 4 opportunities are Meeting and banquets, and theatre capacity of approximately 188 patrons. This item was for information/discussion purposes only. No action was taken. E. VOUCHERS 05/16/2020-06/15/2020 AND PAYROLL VOUCHERS 05/01/2020-05/31/2020: Presented by Chase Donnelly, Accounting Manager. Accounting Manager Donnelly summarized the May vouchers, and there were no questions. Council President Honda sent some questions through email earlier to the Finance Director and the questions were answered and sent back to all Councilmembers. Motion made by Councilmember Kochmar to forward the May Vouchers to the July 7, 2020 consent agenda for approval; motion seconded by Councilmember Koppang and carried 3-0. F. MONTHLY FINANCIAL REPORT — May 2020: Presented by Finance Director Ade Ariwoola. Finance Director Ariwoola would like to thank the Council members who worked hard on the Utility tax issue with Lakehaven. Finance Director Ariwoola summarized the May 2020 Monthly Financial Report. Notable areas include: • Sales tax • CD Permits & Fees • Utility tax • Business License Fees Motion made by Councilmember Koppang to forward the May 2020 Monthly Financial Report to the July 7, 2020 consent agenda for approval; motion seconded by Councilmember Kochmar and carried 3-0. Tuesday, June 23, 2020 Page 3 5 CITY OF FederalWay OTHER: NEXT MEETING: July 28, 2020 MEETING ADJOURNED: The meeting was adjourned at 6:14 p.m. Attest: Approved by Committee: Dana Almberg, Administrative Assistant II Date Tuesday, June 23, 2020 Page 4 6 COUNCIL MEETING DATE: August 11, 2020 ITEM #: CITY OF FEDERAL WAY CITY COUNCIL AGENDA BILL SUBJECT: CIVIC PLUS — SEECLICKFIx FOR EYES ON FEDERAL WAY POLICY QUESTION: Should Council approve the agreement with Civic Plus for the SeeClickFix Platform to support the Eyes on Federal Way Program? COMMITTEE: FEDRAC MEETING DATE: July 28, 2020 CATEGORY: N Consent ❑ City Council Business ❑ Ordinance ❑ . Public Hearing ❑ Resolution ❑ Other STAFF REPORT BY: Thomas Fichtner, IT Director Attachments: 1. Staff Report 2. Draft Contract for SeeClickFix. DEPT: Information Technology Options Considered: 1. Approve the proposed purchase. 2. Do not approve the proposed purchase and provide direction to staff. MAYOR'S RECOMMEND6,1�I0N: Option 1. MAYOR APPROVAL: 7 I �• DIRECTOR APPROVAL:F� ; (XTnnAc,,,' tucil iniiial!Rnrc .nitial?Dite lmtinlrF}7 COMMITTEE RECOMMENDATION: "I move to forward the proposed agreement to the August 11, 2020 consent agenda for approval. " Committee Chair Committee Member Committee Member PROPOSED COUNCIL MOTION: "I move approval of the proposed 5-year agreement . for the SeeClickFix platform from Civic Plus for a total not to exceed $241, 000.00 and authorize the Mayor to execute said agreement. " (BELOW TO BE COMPLETED BY CITY CLERK'S OFFICE) COUNCIL ACTION: ❑ APPROVED COUNCIL BILL # ❑ DENIED First reading ❑ TABLED/DEFERRED/NO ACTION Enactment reading ❑ NIOVED TO SECOND READING (ordinances only) ORDINANCE # REVISED — 11/2019 RESOLUTION # 7 CITY OF FEDERAL WAY MEMORANDUM DATE: July 20, 2020 TO: City Council Members VIA: Jim Ferrell, Mayor FROM: Thomas Fichtner, IT Director SUBJECT: Civic Plus — SeeClickFix for Eyes on Federal Way Financial Imnacts: The cost to the City of $48,400 for the SeeClickFix platform Year 1, is included in the proposed 2020 Budget Amendment. After Year 1, the initial renewal term will have a base amount of $41,000 with an annual percentage increase along with any applicable taxes, which will be included as part of the IT Department's proposed budget for the 2021/2022 Budget. BacklZround Information: At the 2020 State of the City Address, Mayor Ferrell announced the Eyes on Federal Way initiative which consisted of a smart phone app that allows residents and visitors to report any issues to the City in a simple, easy to use interface. The IT Department was tasked with surveying Federal Way's neighboring cities and come up with a recommendation for the software platform for the app. After touring Lakewood, Auburn, Renton, and Redmond, the City narrowed the search for the app down to two platforms. After a thorough examination of the features, capabilities, integrations, and price of the two systems, the SeeClickFix platform by Civic Plus was the recommended platform to move forward with. SeeClickFix is currently used by Auburn, Renton, Shoreline, Tukwila, Covington, and SeaTac to name a few. The SeeClickFix platform is a Customer/Citizen Relations Management (CRM) system. This allows for requests to be submitted in a variety of ways such as from the City's website as well as the Android/Apple app, with more ways including text messaging coming in future a future release. The request form is populated by City staff and will route requests to the appropriate department or staff person. If wanted, staff can interact with the citizen over the platform if additional information is needed about a particular request and once the request is completed, the system automatically notifies the requestor. 8 Rev. 7/ 18 One of the deciding factors to recommend SeeClickFix was the platform's abilities to integrate with other City systems such as the ESRI GIS, Vueworks, and GovQA systems. In a future release, the City can also add integration to the City's AMANDA permitting system as well. These integrations allow staff to continue to utilize the system that they are used to working on, while SeeClickFix routes the requests into those systems. This means that the staff who use the Vueworks (PublicWorks) and GovQA (multiple City departments) systems won't need to learn another system making for an easier transition. TI,P anrf-P�mant k a 5-vpnr arrr-Pmpnt hroken clown as follows: Year 1 Year 2 Year 3 Year 4 Year 5 Total 5-year Base $44,000 41,000 $41,820 $42,657 $43,511 $212,988 Price Estimated $4,400 $4,100 $4,182 $4,266 $4,351 Sales/Use $21,299 Tax 10%) Yearly $48,400 $45,100 $46,002 $46,923 $47,862 $234,287 Total Not to $50,000 $45,500 $47,000 $48,500 $50,000 $241,000 Exceed Amount *The Yearly Total figures subject to change based on finalized agreement annual escalator, sales/use tax increases, and additional modules purchased in future years, the "Not to Exceed Amount" provides for some contingency. 9 Rev. 7/18 Ca CivicPlus 302 South 4th St. Suite 500 Manhattan, KS 66502 us Quote #: Date: Expires On: Product: Ship To Bill To Thomas Fichtner Federal Way WA - CP Connect Federal Way WA - CP Connect Exhibit A.1 - Statement of Work Q-09334-1 5/22/2020 1:35 PM 5/31 /2020 CP Connect QTY Product Name DESCRIPTION PRODUCT TYPE 1.00 CP Connect Annual Fee CP Connect Base Annual Fee Renewable 1.00 CP Connect Standard CP Connect Implementation and Initial Training One-time Implementation Total ❑ays of Quote:457 Total Investment —Year 1 USD 0.00 Annual Services — Year 2 USD 0.00 CivicPlus • 302 S. 4th Street, Suite 500 • Manhattan, KS 66502 • www.CivicPlus.cont Toll Free 888-228-2233 • Accounting Ext. 291 • Support Ext. 307 • Fax 785-587-8951 Page 1 10 1. This Sales Form and the Statement of Work (SOW) attached as Exhibit A, constitute the entire agreement ("Agreement") of CivicsPlus and the City of Federal Way ("Parties").This Agreement shall remain in effect for an initial term beginning at signing and ending August 28, 2021. In the event that neither party gives 60 days' notice to terminate prior to the end of the initial or any subsequent Renewal Term, this Agreement will automatically renew for an additional one-year renewal term ("Renewal Term"). 2. The subscription described herein shall have an initial term beginning with mutual execution of this form (the "Effective Date") and ending August 28, 2021, and shall automatically renew for any number of additional 1 year Renewal Terms. The Initial Term Fee of $44,000 (sum of One Time Costs and Annual Recurring Costs) for the initial term shall be invoiced at signing. Annual Costs for any renewal terms shall be invoiced on the first day of such Renewal Term beginning August 29, 2021. 3. Each full year that this Agreement is in effect as measured from the date it is signed, a technology investment and benefit fee up to 5% will be applied to the Annual Fee Increase. Client will be invoiced electronically through email. Upon request CivicPlus will mail the invoice and the Client will be charged a $5.00 convenience fee. 4. All prices for software or services billed under this Agreement are reflected on the SOW attached as Exhibit A to this Agreement, which is incorporated by reference. 5. The Recurring Costs herein are for a maximum of 120 user licenses. Client may purchase additional licenses for individual users ("User Licenses") at the annual rate of $1,000 per User License. Upon purchase of additional User Licenses, Clients Annual Services fee shall be increased from the time of purchase, reflecting the additional User Licenses and prorated to align with the Client's billing cycle. 6. The Phone Services (Voice/SMS) with unlimited lines, unlimited recordings (as further described herein), and up to 3000 minutes per user license per month and 500 SMS per user license per month. If phone usage (voice/SMS) exceeds the set usage amounts included herein, additional minutes and additional SMS will be invoiced in arrears to the client at $0.01 per minute and $0.01 per SMS. 7. The number of phone recordings and file size of phone recordings through CP Connect are unlimited. CivicPlus will store the phone recordings for up to 3 years and purge all recordings over 3 years old. Client understands it is Client's sole responsibility to download and store recordings prior to the third year. 8. Client understands that CP Connect does not collect, and discourages Client from collecting, any personally identifiable information ("PII") of the requesting citizens. In the event Client does collect PII, Client, and not CivicPlus, shall be solely responsible for the collection of such PII. 9. Client allows CivicPlus to display a "Government Websites by CivicPlus" insignia, and web link at the bottom of their web pages. Client understands that the pricing and any related discount structure provided under this SOW #1 assumes such perpetual permission. 10. The Client will be invoiced electronically through email. Upon request CivicPlus will mail invoices and the Client will be charged a $5.00 convenience fee. A Client agrees to use CP Connect service (the "Service") in ways that conform to all applicable laws and regulations. Client agrees not to make any attempt to gain unauthorized access to any of CivicPlus' systems or networks. Client agrees that CivicPlus shall not be responsible or liable for the content of messages created by Client, or by those who access Service, or otherwise delivered by Service on behalf of Client 12. CivicPlus does not own any data, information or material that Client, or its constituents, submit to the Service in the course of using the Service ("Client Data"). CivicPlus will establish and maintain safeguards against the destruction, loss or CivicPlus • 302 S. 4th Street, Suite 500 • Manhattan, KS 66502 • www.CivicPlus.com Toll Free 888-228-2233 • Accounting Ext. 291 • Support Ext. 307 • Fax 785-587-8951 Page 2 11 alteration of Client Data in its possession that are no less rigorous than those in effect for Civic Plus's own operations. CivicPlus will not intentionally withhold, remove and/or discard Client Data for breach of contract without first giving Client 30 days' notice and an opportunity to cure. In addition, Client shall, at all times during the life of this SOW have the right to export any existing data which qualifies as a public record under Washington state law. 13. CivicPlus will provide unlimited telephone support Monday -Friday, 7:00 am — 7:00 pm (Central Time) excluding holidays, for authorized callers. Client is responsible for providing CivicPlus with authorized caller contact updates. 14. Support includes providing technical support and technical maintenance of the CP Connect software. Following initial setup, additional setup support may be contracted separately for an additional fee. 15. During the period of this Agreement and subsequent Renewal Periods, CivicPlus warrants that it will, without additional charge to the Client, take action to correct any problems or defects discovered in the CP Connect software and reported to CivicPlus by the Client, such warranty to include ongoing maintenance upgrades and technical error correction. 16. TO THE MAXIMUM EXTENT PERMITTED BY LAW, NEITHER CIVICPLUS NOR CLIENT SHALL BE LIABLE FOR SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES OF ANY KIND INCLUDING, BUT NOT LIMITED TO, LOST PROFITS, OR LOST DATA, REGARDLESS OF THE FORESEEABILITY OF THOSE DAMAGES, ARISING OUT OF OR IN CONNECTION WITH CLIENT'S USE OF CP CONNECT. IN NO EVENT SHALL EITHER PARTY'S AGGREGATE LIABILITY FOR DIRECT DAMAGES ARISING OUT OF A BREACH OF CONTRACT OR WARRANTY EXCEED THE AMOUNTS ACTUALLY PAID BY CLIENT IN THE 12 MONTH PERIOD IMMEDIATELY PRECEDING THE EVENT GIVING RISE TO THIS CLAIM. 17. Each party represents and warrants that it has the legal power and authority to enter into this Agreement. CivicsPlus warrants that all Service provided in accordance with this SOW is free from material defects, performs substantially in accordance with its end -user documentation when used as designed, does not infringe on the intellectual property rights of third parties, and that any software included in the Service does not contain harmful code, such as viruses or malware. . CivicPlus will use commercially reasonable efforts to maintain continuous access but will not be responsible for events beyond CivicPlus'control. 18. The Parties agree that any dispute or controversy arising out of or in connection with this Agreement shall be referred to arbitration for final and binding resolution to the maximum extent allowable by law. Either Party to this Agreement may initiate arbitration of the dispute by the filing of an application for resolution by one arbitrator appointed by and in accordance with the rules of the American Arbitration Association. The arbitration shall be conducted in the city and state in which the non -filing Party is located, but the Parties agree that counsel and witnesses for all Parties may appear remotely, by live video feed (Zoom, Skype, or a similar service). The award in the arbitration shall be final, binding and non -appealable. The award may be entered as a final, non -appealable judgment in any court having jurisdiction in Washington state or Kansas. Each Party will bear their own costs and attorneys' fees arising out of the dispute and will split the cost of the arbitrator's fees. 19. The laws of the United States and the State of Washington shall govern this Agreement, without regard to conflicts of laws principles. 20. The parties agree that CivicPlus shall be the sole and exclusive owner of any and all software, materials or other original works created by or licensed to CivicPlus prior to the execution of this Agreement and that the City will refrain from any actions which interfere with those ownership rights or exceed the scope of its license as defined by this Agreement. 21. The parties agree that scanned, copied, or electronic signatures shall have the same legal effect as originals CivicPlus • 302 S. 4th Street, Suite 500 • Manhattan, KS 66502 • www.CivicPlus.com Toll Free 888-228-2233 • Accounting Ext. 291 • Support Ext. 307 • Fax 785-587-8951 Page 3 12 22. If any provision of this Agreement shall be determined to be invalid or unenforceable, such invalidity or unenforceability shall not affect the remainder of this Agreement, which shall be construed as if such invalid or unenforceable provision had never been a part of this Agreement but in a manner so as to carry out as nearly as possible the Parties' original intent Acceptance We, the undersigned, agreeing to the conditions specified in this document, understand and authorize the provision of services outlined in this Agreement. Client By: Name: Title: Date: Civicplus By: Name: Title: Date: CivicPlus • 302 S. 4th Street, Suite 500 • Manhattan, KS 66502 • www.CivicPlus.com Toll Free 888-228-2233 • Accounting Ext. 291 • Support Ext. 307 • Fax 785-567-8951 Page 4 13 Contact Information .all documents must be returned: Master Service Agreement, Statement of Work, and Contact Information Sheet. Organization URL Street Address Address 2 City State Postal Code CivicPlus provides telephone support for all trained clients from 7am —7pm Central Time, Monday -Friday (excluding holidays). Emergency Support is provided on a 24/7/365 basis for representatives named by the Client. Client is responsible for ensuring CivicPlus has current updates. Emergency Contact & Mobile Phone Emergency Contact & Mobile Phone Emergency Contact & Mobile Phone Billing Contact E-Mail Phone Ext. Fax Billing Address Address 2 City State Postal Code Tax ID # Sales Tax Exempt # Billing Terms Account Rep Info Required on Invoice (PO or Job #) Contract Contact Email Phone Ext. Fax Project Contact Email Phone Ext. Fax 145 Exhibit A — Statement of Work Prepared for: Prepared by: Thomas Fichtner Andrew Shetty Federal Way Washington Account Executive , Washington, andrew.shetty@civicplus.com thomas.fichtner@cityoffederalway.com (203) 349-6685 (253) 835-2547 Issue Date: 5/26/2020 Pricing Expires: 5131 /2020 Product Name DESCRIPTION CITY TOTAL SeeClickFix Annual SeeClickFix Annual Licenses 120.0 USD 41,979.46 SeeClickFix Year 1 Annual Fee Year 1 Annual Fee Discount 1.00 USD-9,100.00 Discount Marketplace App Annual Marketplace App Annual 1.00 USD 3,498.29 SeeClickFix Year 1 Annual Fee Year 1 Annual Fee Discount 1.00 USD-800.00 Discount Single Sign -On Single sign -on uses SAML to replace standard 1.00 USD 787.11 SeeClickFix authentication with a third party authentication service such as Active Directory. SeeClickFix Year 1 Annual Fee Year 1 Annual Fee Discount 1.00 USD-100.00 Discount SeeClickFix Connector for ArcGIS Feature Service within ArcGIS to display your 1.00 USD 787.11 request data in internal reports, public maps and Open Data Portals SeeClickFix Year 1 Annual Fee Year 1 Annual Fee Discount 1.00 USD -49.92 Discount SeeClickFix Connector for GovQA SeeClickFix-hosted integration with GovQA's 1.00 USD 1,574.23 CRM/311 solution (WebQA). Requires GovQA 0pen311 API. Features include: Syncing Request Categories Syncing Request Questions & Answers Syncing Requests SeeClickFix Year 1 Annual Fee Year 1 Annual Fee Discount 1.00 USD-100.00 Discount SeeClickFix Connector for VUEWorks SeeClickFix-hosted integration with 1.00 USD 2,623.72 VUEWorks (DTS GIS), via Service Call Web Service (REST methods) SeeClickFix Year 1 Annual Fee Year 1 Annual Fee Discount 1.00 USD-100.00 Discount SeeClickFix Custom Account SeeClickFix Custom Account Configuration 1.00 USD 1,500.00 Configuration SeeClickFix Custom Training SeeClickFix Custom Training 1.00 USD 1,500.00 TOTAL: USD 44,000.00 16 One Time Costs USD 3,000.00 Recurring Costs I USD 41,000.00 'Annual Fee is subject to 5% annual technology uplift in subsequent renewal years, starting with the second renewal year. Page 7 16 COUNCIL MEETING DATE: August 11, 2020 ITEM #: CITY OF FEDERAL WAY CITY COUNCIL AGENDA BILL SUBJECT: MICROSOFT ENTERPRISE AGREEMENT POLICY QUESTION: Should Council approve the 3-year Microsoft Enterprise Agreement with Insight Public Sector, Inc.? COMMITTEE: FEDRAC MEETING DATE: July 28, 2020 CATEGORY: ® Consent ❑ Ordinance ❑ Public Hearing ❑ City Council Business ❑ Resolution ❑ Other STAFF REPORT BY: Thomas Fichtner, IT Director DEPT: Information Technology Attachments: 1. Staff Report 2. City of Federal Way Microsoft EA Renewal Pricing 3. Sample Enterprise Agreement from Washington State DES Options Considered: 1. Approve the proposed purchase. 2. Do not approve the proposed purchase and provide direction to staff. MAYOR'S RECOMMENDATION: Option 1. MAYOR APPROVAL: DIRECTOR APPROVAL: COMMITTEE RECOMMENDATION: "I move to forward the proposed agreement to the August 11, 2020 consent agenda for approval. " Committee Chair Committee Member Committee Member PROPOSED COUNCIL MOTION: "I move approval of the proposed Microsoft Enterprise Agreement from Insight Public Sector, Inc. for a total not to exceed $389,168.99 and authorize the Mayor to execute said agreement. " (BELOW TO BE COMPLETED BY CITY CLERK'S OFFICE) COUNCIL ACTION: ❑ APPROVED COUNCIL BILL # ❑ DENIED First reading ❑ TABLED/DEFERRED/NO ACTION Enactment reading ❑ MOVED TO SECOND READING (ordinances only) ORDINANCE # REVISED — 11/2019 RESOLUTION # 17 CITY OF FEDERAL WAY MEMORANDUM DATE: July 20, 2020 TO: City Council Members VIA: Jim Ferrell, Mayor FROM: Thomas Fichtner, IT Manager SUBJECT: Microsoft Enterprise Agreement Financial Imnacts: The EA renewal is split into three payments. The three payments are taken from 2020, 2021, and 2022 funds respectively. The total cost to the City for the entire agreement is $389,168.99 inclusive of a 10% tax. The total "Year-1" (2020) payment will be $133,858.11 inclusive of tax. The "Year-2" (2021) payment will be $116,050.40 plus tax (figured with a 5% inflator) and the "Year-3" (2022) payment will be approximately $116,050.40 plus tax (figured with a 5% inflator). The IT Department has budgeted a total amount of $109,045 for the Microsoft Enterprise Agreement. Included in the proposed 2020 Budget Amendment is an additional $20,000 to cover the Windows 7 Extended Security, which brings a total budgeted amount of $129,045. The additional $4,814 will be absorbed by savings within the IT fund. For Years 2 and 3, the additional $18,610.44 will be included as part of the IT Department's proposed budget for the 2021/2022 Budget. Baclgground Information: The City has maintained an Enterprise Agreement (EA) with Microsoft since 2008. The EA provides licensing for all of the City's Microsoft software ranging from the Windows desktop operating system, Office productivity suite, Exchange/Outlook email system, SQL database and Windows Server platforms. The EA also provides many benefits to the City such as technical support and Software Assurance for licensed products which includes version upgrades to the latest release of the software, staff training resources for Windows, Office and other products. Based on the previous Enterprise Agreement, Microsoft has increased the prices of their products across the board on average of 6.64%, with some products such as Office increasing by 19.9% and Windows by 18.8%. Meanwhile, Microsoft is also pushing adoption to their Microsoft 365 cloud platforms, which include many additional features and licensing advantages over traditional on -premise licensing models. With the increase in the City's license staying status -quo, a calculation was performed to determine if it was 18 Rev. 7/18 possible to leverage some of the Microsoft 365 benefits, while keeping our annual payment inline with what we would be paying for the traditional on -premise model. A hybrid approach that blends both on -premise as well as Microsoft 365 was crafted that allows the City to reduce the total amount of licenses it needs due to the Microsoft 365 platform licensing up to 5 devices per user. Originally the City had 479 user/device licenses, but only needed 405. This was due to the City having more physical devices than users. With the Microsoft 365 and on -premise hybrid plan, the City can scale back down to 405 total user licenses. This will give the City 130 licenses for the Microsoft 365 platform, while still keeping 275 users licensed with on -premise licensing. This hybrid model will allow the City to deploy the Microsoft 365 plans to users who can take full advantage of it, such as users with Microsoft Surface devices and users who are more mobile focused. It will also allow the City to pilot the Microsoft 365 cloud and figure out the best way to deploy it to users City-wide. In addition, should the City increase staffing and licensing requirements, it is possible to add additional licenses as needed throughout the term of the agreement, by performing a True -Up. This agreement also includes the Software Assurance (SA) cost for the additional 80 Remote Desktop licenses that the City purchased to facilitate remote work during the COVID-19 pandemic. The additional 80 licenses will bring the total amount of remote licenses available to the City to 100 at the time of this writing. This Enterprise Agreement will be purchased from Insight Public Sector, Inc., an authorized Microsoft Reseller, which is selected based on the Washington State Department of Enterprise Services (DES) Master Contract# 06016. The current Washington State DES Master Contract will expire in 2021, at which time DES will solicit bids again from Microsoft resellers. Each reseller provides a different price for software based on their margin with Microsoft. This is why there is a 5% inflator for the "Year-2" and "Year-3" payments, as it is unknown which reseller will be chosen based on the DES bids, and what the winning reseller's margin will be. Hopefully it will be the same or less, however, it is necessary to provide a possibility of up to a 5% increase. 19 Rev. 7/18 iA 4j*)- l00D W Q�-l1 Owl IN-� P.- v 0 o 0-1 00 lD O O to l0 to O O to O O (D (D (D W W W N F� D rDD 00) v (D (D (D p O X X X r+ rr � ) Ln Ln r rt rt o 0 F, v 0J o O � O � Ol X D T. 0 to w to to -I V m w w D D N N O < 00 m m m m Z V< <n �' D D m N v p w v a Z D p o n ;D N 0 0 W oo m 00 O 6 O '0 0 p O O 00 r-jO Ol W N A O iv 0O 0O W I--� N ON N F'' N li O V � W Ln Ln 0 w VO Ln w N Ln V co � 0O N W N W N W w 00 w 0o N I--' p p X O Ln o -� c<n V ffDD Z O n (") ( N r S m m n N rn+ n m -o < < < D Q Ln Ln (D < D cmi� D o rN+ ci� p Ln c0 c 3 r+ r< W W Ln Z ° sZ n n s 0 D 0 o N r+ o 0n O o Z o- 3 o c D D G) < O n f D (D (D Z N N D D N D Z (n n cn o ro D D 2 D Z '2 D r n D D D ((DD Z Dr Z Z D O Z w 7 Z D O Z Z n cn p G) Gl D oa < Gl < r cn G) G) G) D < r D n n D r D D � N D D 0-0 D N D D< r r D < n r _+: < < 3 < < < D n (Dr O" (D C < N r: r N N N r cn D N N rn r n r r r = -ha n n r L D n o o O r) n< On ((DD D on n vC N Z D n r ? In Q c < a' D r Z < � r c � Cr (o 0 < " C r r (D O C O fll r X p' m O rn N r+ O N N N r+ O O In O In 010,010 V w m m O O O 00 O W 0101010 O (n N O O O 01010101 Ln m m O O O O O O O O O 0 0 0 0 0 0 0 0 0 Q (D F F Ln w I N F I 7 In 4�- � O o. F I' N 00 O N W N w lD to A I '+ O LT1 N O w 00 00 m �I V N A m 4�- N (n V V V N w N O O ' ' m V m N V w In N N F, U'1 lD L m 1 m 1-+ W W 00 lD LD 00 W lD 4�- m (n W V � i/f iA in• i? to i/} i/� in• i/� V1 i/� to i/} i/� i/1 t/A i/? iR i/� iA W N :N N F+ I--' I--' N I--' Ol V W I--+ N � V Ln � V w N I-, F� N � 00 In m N 01 m N N O W A lrn V O N m V In O LD r�. O 00 00 w In V F1 N W p N O I W 00 W W V W V W I-1 j.+ O N In In m N O 0o In W O Ln A N V F O I� N w O Ln O N Oo . w O N V O In w O O In w N I -A N f+ F" F w N N Ql V w I-, N -A :-I (n A V to N F-� I--� N A 00 In I-� m F � I-, V V O N N N O to A In IliO N m V cn A O lD A O N A W -;N N O F-+ W 0o W W V W V W . C11 y� j... N Ul In m N O W In w O I--+ Ln .A N V 1--+ O I -A N tD to O N 00 0o O N V I O I In 100 O O In I W I N 20 012 Microsoft Volume Licensing ■u Enterprise Agreement State and Local CTM (Custom Agreement) for Washington State — Department of Enterprise Services Not for Use with Microsoft Business Agreement or Microsoft Business and Services Agreement WADES-070616 This Microsoft Enterprise Agreement ("Agreement") is entered into between the entities identified on the signature form. Effective date. The effective date of this Agreement is the first day Or August 2016. Any reference in this Agreement or an Enrollment to a "day" means a calendar day, except references that specify "business day". This Agreement consists of (1) these Agreement terms and conditions, including any amendments and the signature form and all attachments identified therein, (2) the Product Terms applicable to Products licensed under this Agreement, (3) the Online Services Terms, (4) any Affiliate Enrollment entered into under this Agreement, and (5) any order submitted under this Agreement. Please note: Documents referenced in this Agreement but not attached to.:the.s at htti7:rww.mi,,roscft.com/lIcensInqlcontracts, including. the Produpt`Ter n' documents may contain additional terms and condltiari's.for Products 4c.en. may be changed from time to tittle; -Customer should review such doc; ts` signing and periodically its real or, ands fully understand all terms antl candi licensed. Nonetheless, ��oniy the documents IA'cluded in The' paragraph ;above they may �er rerice as brndingj are_intended fo 6e'.7racrarporated Into fhrs�A°gr .e Terms aridtiConcfiti6ns '"�." 9. Definitions:`-, "Affiiliat�":means ': a. with regard to Customer, e form may be found Use. Rights. These thiqAA.,greement and y• botf};;at the time of ,olicable toFProducts (i) any government agency, department, office, instrumentality, division, unit or other entity of the state or local government that is supervised by or is part of Customer, or which supervises Customer or of which Customer is a part, or which is under common supervision with Customer; (ii) any county, borough, commonwealth, city, municipality, town, township, special purpose district, or other similar type of governmental instrumentality established by the laws of Customer's state and located within Customer's state jurisdiction and geographic boundaries; and (iii) any other entity in Customer's state expressly authorized by the laws of Customers state to purchase under state contracts; provided that a state and its Affiliates shall not, for purposes of this definition, be considered to be Affiliates of the federal government and its Affiliates; and b, with regard to Microsoft, any legal entity that Microsoft owns, that owns Microsoft, or that is under common ownership with Microsoft; "Customer" means the legal entity that has entered into this Agreement with Microsoft; EA2015Agr(US)SLG(ENG)(Aug2015) CTM Page 1 of 12 Based on Document X20-12056 21 "Customer Data means all data, including all text, sound, software, image, or video files that are provided to Microsoft by, or on behalf of, an Enrolled Affiliate and its Affiliates through use of online Services. "Enrolled Affiliate" means an entity, either Customer or any one of Customer's Affiliates that has entered into an Enrollment under this Agreement; "Enrollment" means the document that an Enrolled Affiliate submits under this Agreement to place its initial order; "Enterprise" means an Enrolled Affiliate and the Affiliates for which it is responsible and chooses on its Enrollment to include in its enterprise; "Fixes' means Product fixes, modifications or enhancements, or their derivatives, that Microsoft either releases generally (such as Product service packs) or provides to Customer to address a specific issue. "License" means the right to download, install, access and use a Product. For certain Products, a License may be available on a fixed term or subscription basis ("Subscription License"). Licenses for Online Services will be considered Subscription Licenses; "Microsoft" means the Microsoft Affiliate that has entered into this Agreement or an Enrollment and its Affiliates, as appropriate; "Online Services" means the Microsoft -hosted services identified as Online Services in the Product Terms. "Online Services Terms" means the additional terms that apply to Customer's use of Online Services published on the Volume Licensing Site and updated from time to tim.e..:-.' "Product" means all products identified in the Product..Terms, sadi as all: S.oftv.*a q;,Online Services and other web -based services, including pre-release or beta versions; "Product Terms" means tne'dccuhient that provlde's°informat on about N[Icfosvft Products End .Professional Services available through vo10" licensing: The Product, Terms document.is pubfis'r ed dmt�i'e'-Volume ::. . Licensing Site and is updated from time,to time. "SLA" means Service Level Agreement, whicfi.,specifies tli'e..minirrtuinservice level fQr Q.nlin`Service5 and is published on the Volume Licensing Site. "Software" means licensed copies of Microsoft software ioentified on the Frodbct Terms. Software does not include Online Services, but Software may be part of 6'6 Online r§ervice;�` "Software Assurance" Is an offering by Microsoft that provides new version rights and other benefits for Products as further described In the Product Terms. "Trade Secret""means information that is not generally known or readily ascertainable. to the.public, has econgmic'value as a result, and has been subject to reasonable steps under the ciecumstances.ta;maintain its secrecy; "use" or "run" means to copy, install, use, access, display, run or otherwise interact. "Use Rights" means the use rights or terms of service for each Product published on the Volume Licensing Site and updated from time to time. The Use Rights supersede the terms of any end user license agreement that accompanies a Product. The Use Rights for Software are published by Microsoft in the Product Terms. The Use Rights for Online Services are published in the Onllne Services Terms. "Volume Licensing Site" means http://www.rnicrosoft.com)[icensin-gicontracts or a successor site. 2. How the Enterprise program works. a. General. The Enterprise program consists of the terms and conditions on which an Enrolled Affiliate may acquire Product Licenses. Under the Enterprise program, Customer and its Affiliates may order Licenses for Products by entering into Enrollments. b. Enrollments. The Enterprise program gives Customer and/or its Affiliates the ability to enter into one or more Enrollments to order Products. Subscription Enrollments may be available for EA2015Agr(US)SLG(ENG)(Aug2015) CTM Page 2 of 12 Based on Document X20-12056 22 some of these Enrollments. Notwithstanding any other provision of this Agreement, only Enrolled Affiliates identified in an Enrollment will be responsible for complying with the terms of that Enrollment, including the terms of this Agreement incorporated by reference in that Enrollment c. Licenses. The types of Licenses available are (1) Licenses obtained under Software Assurance (L&SA), and (2) Subscription Licenses. These License types, as well as additional License Types, are further described in the Product List. d. Pricing. (1) Establishing Price Levels. 777e Price Levels that Microsoft will charge Enrolled Affiliate's reseller for all Enrollments entered into on or after the Effective Date of this Agreement, and that will apply for the entire term of such Enrollments, are as follows: 1) Enterprise Products & Enterprise Online Services: Level D minus 8% for initial orders, and Level D for all subsequent orders (e-g. True -ups, Supplemental Orders, Annual Orders). 2) Additional Products & Additional Online Services: Level D for initial orders and for all subsequent orders (e.g, True -ups, Supplemental Orders, Annual Orders). (ii) Placing Orders through Reseller. Orders under an. Enrollment will be made to Enrolled Affiliate's Reseller. Microsoft will invoice the Reseller according to the terms in the applicable Enrollment. Throughout this Agreement: tire. term "price" refers to reference price. The Reseller and the Enrolled.Afliate 44i,J ddoirnine the Enrolled Affiliate's actual price and payment terms 3. Licenses for Pl oducts: a. License Grant, Micro soft'grantsthe;Enterprise a non -ex c[s e, irvowidb ar;d limitad right to download, install a4d use.,softv�are Qroducts, and'to..accc `ss'and use tie Online Services, each in the quAntity ordered underzan''Enrollment. _The=ng[its_ granted;arersubject to the terms of this Agreement, the Use Rights and t.he. Produ Terms.:..•MiGrosNreserves all rights not expressly granted in this Agreement. b. Duration of Licenses. Subscription Licenses and most Software Assurance rights are temporary and expire when the applicable Enrollment is terminated or expires, unless the Enrolled Affiliate exercises a buy-out option, which is-avaiiableforsome Subscription Licenses. Except as otherwise noted in the applicable Enrollment or Use Rights, all other Licenses s� become perpetual only when all payments for that License have been made and the initial Enrollment term has expired. c. Applicable Use Rights. (i) Products (otherthan Online Services). The Use Rights in effect on the effective date of the Enrollment will apply to Enterprise's use of the version of each Product that is current at the time. For future versions and new Products, the Use Rights in effect when those versions and Products are first released will apply. Changes Microsoft makes to the Use Rights for a particular version will not apply unless the Enrolled Affiliate chooses to have those changes apply. The Use Rights applicable to perpetual Licenses that were acquired under a previous agreement or Enrollment are determined by the Agreement or Enrollment under which they were acquired_ Renewal of Software Assurance does not change which Use Rights apply to those Licenses. (ii) Online Services. For Online Services, the Use Rights in effect on the subscription start date will apply for the subscription term as defined in the Product Terms, d. Downgrade rights. Enrolled Affiliate may use an earlier version of a Product other than Online Services than the version that is current on the effective date of the Enrollment. In that case, the Use Rights for the current version apply to the use of the earlier version. If the earlier EA2015Agr(1JS)SLG(ENG)(Aug2015) CTM Page 3 of 12 Based on Document X20-12056 23 Product version includes features that are not in the new version, then the Use Rights applicable to the earlier version apply with respect to those features. e. New Version Rights under Software Assurance. Enrolled Affiliate must order and maintain continuous Software Assurance coverage for each License ordered. With Software Assurance coverage, Enterprise automatically has the right to use a new version of a licensed Product as soon as it is released, even if Enrolled Affiliate chooses not to use the new version immediately. (€) Except as otherwise permitted under an Enrollment, use of the new version will be subject to the new version's Use Rights. (i€) If the License for the earlier version of the Product is perpetual at the time the new version is released, the License for the new version will also be perpetual. Perpetual Licenses obtained through Software Assurance replace any perpetual Licenses for the earlier version. f. License confirmation. This Agreement, the applicable Enrollment, Enrolled Affiliate's order confirmation, and any documentation evidencing transfers of perpetual Licenses, together with proof of payment, will be Enrolled Affiliate's evidence of all Licenses obtained under an Enrollment. g. Reorganizations, consolidations and privatizations. If1he number of Licenses covered by an Enrollment changes by more than ten percent as a result of (1) a reorganization, consolidation or privatization of an entity or an -operating division, (2) a privatization of an Affiliate or an operating division of Enrolled Affiliate or any o'f•!6Affillates, or (3) a consolidation including a merger with a third party that has an existing agreerfient or Enrollment, Microsoft will work with Enrolled Affiliate in good,faifh-to determine hp*J.accammgdate its changed circumstances in fhe;_context of this Agreement. ',•,y 4. Making cojv es ofProafucl and re=imaging rights. _►_ : a. General. Enrolled Affiliate "may make:as many copies, of Pr ducts, as it needs to distribute them within the Enterprise. Gopies:= rnt. )L be`-,trge ;and;•cpmplete (inbluding copyright and trademark notices) from master copies.obtairlet°from a. Microsoft approved fulfillment source. Enrolled Affiliate may use a third party to shake these -copies, but Enrolled Affiliate agrees it will be responsible for any third party's actions. Enrolled Affiliate agrees to make reasonable efforts to notify its employees, agents, and any other individuals who use the Products that the Products are licensed from Microsoft and subject,to tn'e terms of this Agreement. b; Copies for traininglevatuation and back-up. For all Products other than Online Services, Enrolled Affiliate may: (1) use up to 40 complimentary copies of any licensed Product in a dedicated training facility on its premises for purposes of training on that particular Product- (2) use up to 20 complimentary copies of any Products for a 60 day evaluation period, and (3) use one complimentary copy of any licensed Product for back-up or archival purposes for each of its distinct geographic locations. Trials For Online Services may be available if specified in the Use Rights. e. Right to re -image. In certain cases, re -Imaging is permitted using the Product media. If the Microsoft Product is licensed (1) tom an original equipment manufacturer (OEM), (2) as a full packaged Product through a retail source, or (3) under another Microsoft program, then media provided under this Agreement may generally be used to create images for use In place of copies provided through that separate source. This right is conditional upon the following: (€) Separate Licenses must be acquired from the separate source for each Product that is re - imaged. (ii) The Product, language, version, and components of the copies made must be identical to the Product, language, version, and all components of the copies they replace and the number of copies or instances of the re -imaged Product permitted remains the same. EA2015Agr(US)3I.G(ENG)(Aug2015) CTM Page 4 of 12 Based on Document X20-12056 24 (til) Except for copies of an operating system and copies of Products licensed under another Microsoft program, the Product type (e.g., Upgrade or full License) re -imaged must be identical to the Product type licensed from the separate source. (iv) Enrolled Affiliate must adhere to any Product -specific processes or requirements for re - imaging identified in the Product Terms. Re -imaged Products remain subject to the terms and use rights of the License acquired from the separate source. This subsection does not create or extend any Microsoft warranty or support obligation. 5. Transferring and reassigning Licenses. a. License transfers. Enrolled Affiliate may transfer only fully -paid perpetual Licenses to: (I) an Affiliate or (H) an unaffiliated third party in connection with (A) a privatization of an Affiliate or agency or of an operating division of Enrolled Affiliate or an Affiliate, (13) a reorganization, or (C) a consolidation. Upon such transfer, Enrolled Affiliate must uninstall and discontinue using the licensed Product and render any copies unusable. b. Notification of License Transfer. Enrolled Affiliate must notify Microsoft of a License transfer by completing a license transfer.. form, which.:: car}-'. be obtained from htt ://www.micros)ft,comllicensin Lgntraa and sending the completed form to Microsoft before the License1ra.nsfer. No Licenseti'arisfer will be valid unless Ehr—aiiEd Aiflljate provides to the transferee; aria:-'tPie- transferee accepts in writing,xdocu,..Qen s. sufficien t, f4 enable the transfere%foiwascertain the scojY purpcse:and limi6tions of the rights.graiited y_Microsoft u_r�dar the licenses belthg triansfe6ed'{including, wiiilSut l rriitatio.n, the apnlsgat?Ie.iJs�ights, rise and transfer restrictions„warranties anti limitatiori:s of liatai.11ty, Anj+ license transfer not made in compliance with this section will. be- Vol c. Internal Assignment of Licenses' art&:-SofbRare Assurance. Licenses and Software Assurance must be assigned to a single user or device within the Enterprise. Licenses and Software Assurance may be reassigned within the Enterprise as described in the Use Rights. & 'Term and termination. `a. Term. The term of this Agreement will be 36 full calendar Months from the Effective date unless terminated by either party as described below. Each Enrollment will have the term provided in that Enrollment. b. Termination without cause. Elther party may terminate this Agreement, without cause, upon 60 days written notice. In the event of termination, new Enrollments will not be nocepted, but any existing Enrollment will continue for the term of such Enrollment and will continue to be governed by this Agreement. c. Mid-term termination for non -appropriation of Funds. Enrolled Affiliate may terminate this Agreement or an Enrollment without liability, penalty or further obligation to make payments if funds to make payments under the Agreement or Enrollment are not appropriated or allocated by the Enrolled Affiliate for such purpose. d. Termination for cause. Without limiting any other remedies it may have, either party may terminate an Enrollment if the other party materially breaches its obligations under this Agreement, including any obligation to submit orders or pay invoices. Except where the breach is by its nature not curable within 30 days, the terminating party must give the other party 30 days' notice of Its intent to terminate and an opportunity to cure the breach. EA2015Agr(US)SLG(ENG)(Aug 2015) CTM Page 5 of 12 Based on Document X20-12056 25 if Microsoft gives such notice to an Enrolled Affiliate, Microsoft also will give Customer a copy of that notice and Customer agrees to help resolve the breach. If the breach affects other Enrollments and cannot be resolved between Microsoft and Enrolled Affiliate, together with Customer's help, within a reasonable period of time, Microsoft may terminate this Agreement and all Enrollments under it. If an Enrolled Affiliate ceases to be Customer's Affiliate, it must promptly notify Microsoft, and Microsoft may terminate the farmer Affiliate's Enrollment. If an Enrolled Affiliate terminates its Enrollment as a result of a breach by Microsoft, or if Microsoft terminates an Enrollment because Enrolled Affiliate ceases to be Customer's Affiliate, then Enrolled Affiliate will have the early termination rights described in the Enrollment. e. Early termination. If (1) an Enrolled Affiliate terminates its Enrollment as a result of a breach by Microsoft, or (2) if Microsoft terminates an Enrollment because the Enrolled Affiliate has ceased to be an Affiliate of Customer, or (3) Enrolled Affiliate terminates an Enrollment for non - appropriation of funds, or (4) Microsoft terminates an Enrollment for non-payment due to non - appropriation of funds, then the Enrolled Affiliate will have the following options: (i) it may immediately pay the total remaining amount due, including all installments, in which case, the Enrolled Affiliate will have perpetual rights for all Licenses it has ordered; or (11) It may pay only amounts due as of the termination date, in which case the Enrolled Affiliate will have perpetual Licenses for: T . 1) all copies of Products (including the latest version-'df Products ordered under SA coverage in the current term) for which payment has dean' made in full, and 2) the number of copies of Products, it has ordered '(including. tl`Aatest version of Products ordered under Software Assurance coverage`-,16'... curreht',.term) that is proportional to the total of installment payments paid- versus •to?al-. amounts due (paid and payable) if1he,early termination had not occurred: (iii) in the case,of Early TerTJnation antler Subscriptidn Ehe.611ments, Enrolled Affiliate=will have -tile following options: 7 r 1) For eligible products Enrolled Affiliate may obtain perpetual Licenses as described in the section titled "Buy-out option;";provided that;M' _1Prosoft receives the buy-out order for those Licenses within 60 day'safter Enroll'ed'Affilfate provides notice of termination. 2) Where not exercising buy-out option, in'tFie event of breach by Microsoft, Microsoft will issue Reseller a credit for any amount paid in advance that would apply after the date of termination. Nothing in this section shall affect perpetual License rights acquired either in a separate agreement or in a prior term of the terminated Enrollment. f. Effect of termination or expiration. When an Enrollment expires or is terminated, (i) Enrolled Affiliate must order Licenses for all copies of Products it has run for which it has not previously submitted an order. Any and all unpaid payments or any order of any kind, including subscription services, remain due and payable. Except as provided in the subsection titled 'Early termination," all unpaid payments for Licenses immediately become due and payable. (ii) Enrolled Affiliate's right to Software Assurance benefits under this Agreement ends if it does not renew Software Assurance. g, Modificatlon or termination of an Online Service for regulatory reasons. Microsoft may modify or terminate an Online Service where there is any current or future government requirement or obligation that: (1) subjects Microsoft to any regulation or requirement not generally applicable to businesses operating there; (2) presents a hardship for Microsoft to continue operating the Online Service without modification; and/or (3) causes Microsoft to believe these terms or the Online Service may conflict with any such requirement or obligation. EA2015Agr(US)SLG(ENG)(Aug2016) CTM Page 6 of 12 Based on Document X20-12056 26 h. Program updates. Microsoft may make changes to this program that will make it necessary for Customer and its Enrolled Affiliates to enter into new agreements and Enrollments at the time of an Enrollment renewal. 7. Use, ownership, rights, and restrictions. a. Products. Unless otherwise specified in a supplemental agreement, use of any Product is governed by the Use Rights specific to each Product and version and by the terms of the applicable supplemental agreement. b. Fixes. Each Fix is licensed under the same terms as the Product to which it applies. If a Fix is not provided for a specific Product, any use terms Microsoft provides with the Fix will apply. c. Non -Microsoft software and technology. Enrolled Afiliate is solely responsible for any non - Microsoft software or technology that it installs or uses with the Products or Fixes. d. Restrictions. Enrolled Affiliate must not (and must not attempt to) (1) reverse engineer, decompile, or disassemble any Product or Fix, (2) install or use non -Microsoft software or technology in any way that would subject Microsoft's Intellecutal property or technology to obligations beyond those included in this agreement, .,or (3) work around any technical limitations in the Products or restrictions in Product documentation. Except as expressly permitted in this agreement, Customer must not (i) separate and run parts of a Product on more than one device, upgrade or downgrade parts of a Produt;at different times, or transfer parts of a Product separately; or (ii) distribute, sublicense, rent,' lease;.,:lend, .or use any Product or Fix to offer hosting services to a third party.: e. No transfer of-rywkgership; reservation< of rights. Products .and Fixes are. -protected by copyright ,and-.:otft6r. intellectual prcRarty-rlghts laws and internab.pn.ai::treaties. Microsoft (1}does. riot trarsfer any ownersh6 rights- irr any Products. ar Fixes and `(2j° eseives all, rights not expressly dranted in this,Agreement. J. 8. Confidentiality. "Confidential Information" is non-public information th it� i's designated 'confidential" or that a reasonable person should understand is confidential, including Custvmef Data. Confidential Information does not include information that (a) becomes publicly available without a breach of this agreement, (b) the receiving..party received lawfully from another source without a confidentiality -obligation, (c) is independen4 developed, or (d) is a comment or suggestion volunteered about the other party's business, -products or services. Each party will take reasonable steps to protect the other's Confidential Information and will use the other party's Confidential Information only for purposes of the parties' business relationship. Neither party will disclose that Confidential Information to third parties, except to its employees, Affiliates, contractors, advisors and consultants ("Representatives") and than only on a need -to -know basis under nondisclosure obligations at least as protective as this agreement. Each party remains responsible for the use of the Confidential Information by its Representatives and, in the event of discovery of any unauthorized use or disclosure, must promptly notify the other party. A party may disclose the other's Confidential Information if required by law; but only after it notifies the other party (if legally permissible) to enable the other party to seek a protective order. Neither party is required to restrict work assignments of its Representatives who have had access to Confidential Information. Each party agrees that the use of information retalned in Representatives' unaided memories in the development or deployment of the parties' respective products or services does not create liability under this agreement or trade secret law, and each party agrees to limit what it discloses to the other accordingly. These obligations apply (i) for Customer Data until it is deleted from the Online Services, and ( 5 for all other Confidential Information, for a period of five years after the Confidential Information is received. EA2015Agr(US)SLG(ENG)(Aug2015) GTM Page 7 of 12 Based on Document X20-12056 27 9. Privacy and Compliance and Laws. a. Enrolled Affiliate consents to the processing of personal information by Microsoft and its agents to facilitate the subject matter of this Agreement. Enrolled Affiliate will obtain all required consents from third parties under applicable privacy and data protection law before providing personal information to Microsoft. b. Personal information collected under this agreement (i) may be transferred, stored and processed in the United States or any other country In which Microsoft or its contractors maintain facilities and (ii) will be subject to the privacy terms specified in the Use Rights. Microsoft abides by the EU Safe Harbor and the Swiss Safe Harbor frameworks as set forth by the U.S. Department of Commerce regarding the collection, use, and retention of data from the European Union, the European Economic Area, and Switzerland. c. U.S. export jurisdiction. Products and Fixes are subject to U.S. export jurisdiction. Enrolled Affiliate must comply with all applicable international and national laws, including the U.S. Export Administration Regulations and International Traffic in Arms Regulations, and end -user, end use and destination restrictions issued by U.S. and other governments related to Microsoft products, services and technologies. 10. Warranties. a. Limited warranties and remedies. "< (i) Software. Microsoft warrants that each version'of the sbnwBrt will perform substantially as described in -:the applicable Product :document iio' ipr one year from the date the Enterprise:ris :�rstf,licensed for that ;?grsion. If it' oi~5.-riot and:, :Enterer yse notifies Microsoft,vvj}�iirf the warranty. term, .then Microsoft will, at its.,aptia �T-),retur.n`the price Enrclled-,Affiliate paid for the', Software license, or,(2) rgpile 8r1%p1ace tFi.e tofttivare. . �, :. (il)"brillne Services. Micrvsoft'wai-rants that,each Onlini3 5enrice vrill perforrn•in accordance With the applicable SLA c uring-the Enterprise"s use? . f tie Enterprise's; erriedies for breach of this warranty are in the StA. The remedies above are the Enterprise's:: sole remedies far breach of the warranties in this section. Customer waives any breach of warranty claims not ►riade during the warranty period. b. Exclusions. The warranties in this agreement do not cover problems caused by accident, use in a manner inconsistent with this Agreement, incWding failure to meet minimum system requirements. These warranties do not apply to free, trial, pre-release, or beta Products, or to components of Products that Enrolled Affiliate its permitted to redistribute. c. DISCLAIMER. Microsoft provides no other warranties or conditions and disclaims any other express, implied, or statutory warranties, including warranties of quality, title, non - infringement, merchantability, and fitness for a particular purpose. 11. Defense of third party claims. a. By Microsoft. Microsoft will defend Enrolled Affiliate against any claims made by an unaffiliated third party (1) that any Product or Fix infringes its patent, copyright, or trademark or makes unlawful use of its Trade Secret; or (2) that arises from Microsoft's provision of an Online Service in violation of laws applicable to all online services providers. Microsoft will pay the amount of any resulting adverse final judgment or approved settlement. This does not apply to claims based on (i) Customer Data; (ii) non -Microsoft software; (51) modifications to a Product or Fix Enrolled Affiliate makes or any specifications or materials Enrolled Affiliate provides; (iv) Enrolled Affiliate's combination of the Product or Fix with (or damages based on the value of) a non -Microsoft product, data, or business process; (v) Enrolled Affiliate's use of a Microsoft trademark without express, written consent or the use or redistribution of a Product or Fix in EA2015Agr(US)SLG(ENG)(Aug2015) CTM Page 8 of 12 Based on Document X20-12056 violation of this Agreement; (vi) Enrolled Affiliate's continued use of a Product or Fix after being notified to stop due to a third party claim; or (vii) Products or Fixes provided free of charge. b. By Enrolled Affiliate. Enrolled Affiliate will defend Microsoft against any claims made by an unaffiliated third party that: (i) any Customer Data or non -Microsoft software Microscfl hosts on Enrolled Affiliate's behalf infringes the third party's patent, copyright, or trademark or makes unlawful use of its Trade Secret; or (11) arises from use of an Online Service in violation of applicable laws and regulations; a violation of the legal rights of others; or unauthorized access to or disruption of any service, data, account, or network in connection with the use of the Online Services. Enrolled Affiliate will pay the amount of any adverse final judgment or approved settlement resulting from a claim covered by this section titled "By Enrolled Affiliate." c. Rights and remedies in case of possible infringement or misappropriation. If Microsoft reasonably believes that a claim under this section may result in a legal bar prohibiting Enrolled Affiliate's use of the Product or Fix, Microsoft will seek to obtain the right for Enrolled Affiliate to keep using it or modify or replace it with a functional equivalent, in which case Enrolled Affiliate must discontinue use of the prior version immediately. If these options are not commercially reasonable, Microsoft may terminate Enrolled .Affiliate's right to the Product or Fix and refund any amounts Enrolled Affiliate has paid for those -rights to Software or Fixes and, for Online Services, any amount paid for a usage period aft %e termination date. d. Other terms. The party being defended; under thissectiori :1.1' mbst Katiy the other party promptly of any cial-tri: subject to the subsection titled 'By Microsoft, giveJhe other party sole control over tile. d �ris'e or settlement, and provide reasonable .assistaN 6. in defending the claim. Th arty providing the ,iarotectiorc: ttiili reimburse. tl s:.a l er`pasty'for reasonable out of pocket expenses that it incurs in' pravfding;assistarice. Arty settlement must.b ra.pprgVed in +7ir"itirig by"he defending pony.. The remedies provided in -t> 1s` section..11.'arfiJlheexclusive remedies for the claims desditbed.in this'section.�, 12. Limitation of liability. Far each Product, each party's maximum, aggregate liability to the other tihber this Agreement is limited to direct damages finally awarded in an amount not to exceed the amounts. Enrolled Affiliate was required to payfoi�tl3e%applicable Products during the term of this Agreement, subject`to the: following: ar "Online Services. For Online Services, Microsoft's maximumliability to: Enrolled Affiliate for any incident giving rise to a claim will not exceed the monthly amount Enrolled Affiliate paid or is required to pay for the Online Service multiplied by 24. b. Free Products and Distributable Code. For Products provided free of charge and code that Enrolled Affiliate is authorized to redistribute to third parties without separate payment to Microsoft, Microsoft's liability is limited to direct damages finally awarded up to US$5,000. c. Exclusions. In no event will either party be liable for indirect, incidental, special, punitive, or consequential damages, including loss of use, loss of profits, or interruption of business, however caused or on any theory of liability. d. Exceptions. No limitation or exclusions will apply to liability arising out of either party's (1) confidentiality obligations (except for all liability related to Customer Data, which will remain subject to the limitations and exclusions above); (2) defense obligations: (3) violation of the other party's intellectual property rights; or (4) liability fordamages caused by either party s gross negligence or willful misconduct and awarded by a court of final adjudication (provided that in jurisdictions that do not recognize a legal distinction between "gross negligence"and negligence," "gross negligence" as used in this subsection shall mean "recklessness'). EA2015Agr(US)5LG(ENG)(Aug2015) CTM Page 9 of 12 Based on Document X20-12056 29 13. Verifying compliance. a. Right to verify compliance. Enrolled Affiliate must keep accurate and complete records relating to all use and distribution of Products by Enrolled Affiliate and its Affiliates. Microsoft has the right, at its expense, to the extent permitted by applicable law, to verify Enrolled Affiliate and its Affiliates' compliance with the Product's license terms for the Products. b. Verification process and limitations. Microsoft will provide Enrolled Affiliate at least 30 days' notice of its intent to verify compliance. Verification will take place during normal business hours and in a manner that does not interfere unreasonably with Enrolled Affiliate's operations. Microsoft will engage an independent auditor, which will be subject to a confidentiality obligation. Enrolled Affiliate must promptly provide the independent auditor with any information the auditor reasonably requests in furtherance of the verification, including access to systems running the Products and evidence of Licenses for Products Enrolled Affiliate hosts, sublicenses, or distributes to third parties. Enrolled Affiliate agrees to complete Microsoft's self -audit process, which Microsoft may require as an alternative to a third parry audit. Any information collected in the self -audit will be used solely for purposes of determining compliance. c. Remedies for non-compliance. if verification or self -audit reveals any unlicensed use or distribution, then within 30 days, (1) Enrolled Affiliate must order sufficient licenses to cover that use or distribution, and (2) if unlicensed use or distribution is 5% or more, Enrolled Affiliate must reimburse Microsoft for the cost Microsoft- has incurred In verification and acquire the necessary additional licenses at 125% of the pfssed based on,-Ltl e tf?e7i-current price list and _�-,... Enrolled Affiliate price level. The unlicensed .use percentage�r based on•the_total number of licenses purchased. compared to actual. irft@1l base. if there -is. Tics:unlicensed'use, Microsoft will not subject Enrollod-Affiliate to another verification for' at. least one Yeah Byekercising the rights and: prpcedures described..above, •Microsoft,does not waive;;its rights. to enforce this Agreement arota protect its. intelfectual.property by, any other means; permitted key law. - 14. Miscellaneous. 1: �;{,y;�,, a. Notices. Notices to Microsoft must be sent?to th Microsoft address on the signature form with a copy sent to the address below. Natices.rnust be -:in writirgy and will be treated as delivered on the date. shown on the return receipt or on the courier 'pr fax confirmation of delivery. Microsoft.-.may..provide information to Enrolled Affiliate about upcoming ordering..deadlines, services, and subscription information in electronic farm, including by email to contacts provided by Enrolled Affiliate: Emails will be treated"as delivered on the transmission date. Microsoft Corporation Legal and Corporate Affairs Volume Licensing Group One Microsoft Way Redmond, WA 98052 USA b. Assignment. Either party may assign this Agreement to an Affiliate, but must notify the other party in writing of the assignment. Any other proposed assignment must be approved by the other party in writing. Assignment will not relieve the assigning. party of its obligations under the assigned agreement. Any attempted assignment without required approval will be void. c. Severability. If any provision in this agreement is found unenforceable, the balance of the agreement will remain in full force and effect. EA2015Agr(US)8LG(ENG)(Aug2015) CTM Page 10 of 12 Based on Document X20-12056 30 d. Use of contractors. Microsoft may use contractors to perform services, but will be responsible for their performance subject to the terms of this Agreement. e. Waiver. Failure to enforce any provision of this agreement will not constitute a waiver. Any waiver must be in writing and signed by the waiving party. f. Applicable law; dispute resolution. The terms of this Agreement will be governed by the laws of Customer's state, without giving effect to its conflict of laws. Disputes relating to this Agreement will be subject to applicable dispute resolution laws of Customer's state. g. This Agreement is not exclusive. Customer and its Affiliates are free to enter into agreements to license, use or promote non -Microsoft products. h. Management and Reporting. Customer and/or Enrolled Affiliate may manage account details (e.g., contacts, orders, Licenses, software downloads) on Microsoft's Volume Licensing Service Center ("VLSC") web site (or successor site) at: hitps://www.microsoft.com/licensinalservicecenter. Upon the effective date of this Agreement and any Enrollments, the contact(s) identified for this purpose will be provided access to this site and may authorize additional users and contacts. Microsoft will take commercially - reasonable efforts to assure the information on the web site is accurate. 1. Order of precedence. In the case of a conflict between any.documents in this Agreement that is not expressly resolved in those documents, their termswiil.control in the following order from highest to lowest priority: (1) this Enterprise Agre'ement;'(2}`,any Enrollment, (3) the Product Terms, (4) the Online Services Terms, (5) orders s.ubmitter. Ader:this`Agreement, and (6) any other documents that are referenced in this Agreement, and ox' pressfy inoprporated herein, including but not limited to the Service Level Agreements applia'd'.separate�y :to Enrollments and applicable to ce►fain Online Services as set forth in the,P,P uct'Teriiis end Online Services Terms, fore N; 96-y scripfion_ term.. ,Terms .in ari, ameiaiii 8itt confraf`ovef.the. amended documentdan '�aFly prior amendm6rits.concerning tt?e sarrie,subject .I• 'i -. - ip. .. j. siirvlval. All provisions survive, termination,; -or= expAtlon -o . this` Rgceemeiit except those requiring performance only during.the.term of the agreement..,.,: x k. Free Products. It is Microsoft's interit'tNt-the .torms' of this Agreement -and the Use Rights be in compliance with all applicable federal..) - an Tegulation's.:, Any free Product provided to Enrolled Affiliate is for the sole use and benefit of the Enrolled Affiliate, and is not provided for use by or personal benefit of any specific government employee. k: Amendments, Any amendment to this Agreement must lie eXecuted-by both parties, except that Microsoft may change the Product Terms and the Use Rights from.. -time to time in accordance with the terms of this Agreement. Any conflicting terms and conditions contained in an Enrolled Affiliate's purchase order will not apply. Microsoft may require Customer to sign a new agreement or an amendment before an Enrolled Affiliate enters into an Enrollment under this agreement. m. Voluntary Product Accessibility Templates. Microsoft supports the government's obligation to provide accessible technologies to its citizens with disabilities as required by Section 508 of the Rehabilitation Act of 1973, and its state law counterparts. The Voluntary Product Accessibility Templates ("VPATs") for the Microsoft technologies used in providing the online services can be found at Microsoft's VPAT page. Further information regarding Microsoft's commitment to accessibility can be found at htt ://www.microsoft.com/enable. n. Natural disaster. In the event of a "natural disaster," Microsoft may provide additional assistance or rights by posting them on http://www.microsaff-com at such time. o. Copyright violation. Except as set forth in the section above entitled "Transferring and reassigning Licenses", the Enrolled Affiliate agrees to pay for, and comply with the terms of this Agreement and the Use Rights, for the Products it uses. Except to the extent Enrolled Affiliate is licensed under this Agreement, it will be responsible for its breach of this contract and EA2015Agr(US)SLG(ENG)(Aug2015) CTM Page 11 of 12 Based on Document X20-12056 31 violation of Microsoft's copyright in the Products, including payment of License fees specified in this Agreement for unlicensed use. p. Calendar days. Any reference in this Agreement or an Enrollment to a "day" means a calendar day, except references that specify "business day". q. Force Majeure. Neither party shall be liable or deemed to be in default for any Force Majeure delay in performance occasioned by unforeseeable causes beyond the control and without the faultornegligence of the parties, including, but not restricted to, acts of God orthe public enemy (other than a Security Incident, as defined in the Online Services Terms), fires, floods, epidemics, quarantine, restrictions, strikes, freight embargoes, or unusually severe weather. emu_• a p IV • '• EA2015Agr(US)SLG(ENG)(Aug2015) CTM Page 12 of 12 Based on Document X20-12056 32 E] <i .� Microsoft Volume Licensing Supplemental Contact Information Form Ti7'is form can . he- usPd`, in :combiria(ion 'with. M$SA, AgreeMjpnt, atid:-:Eri�oilmenb'Reglstration. Howeuer, a:separ te..farm must be submitted; fore;ach enrolfii eritlregisfra#lori;-irrh'en;more than one is.': sei rj7itfed oh! a€'signature form.. For, the .purposes of this form, entity.? can- met a 1 signing entity;. Ct�stbrri'ert i~nrol ed Affiliate, ..GcvernmentiPartner, Institution, or other., party°::entering into. a- vai�onie licerising.progra i'agreemet t: Primary ai 0ci Notices contacts'i'ri=this form: Will not apply #O;enrailiiients . u. ya or registrations. r' •z�a This form applies to: ❑ MBSA ® Agreement ❑ Enrollment/Affiliate Registration Form Insert primary entity name if more than one Enrollment/Registration Form is submitted Contact information. Each party will notify the other in writing if any of the- information in the:foilgdving-contact information page(s) changes. The asterisk . (*) indicate required .fields; if the e,niity C. Opses to.' designate other contact types, the same regtii►e fields must be completed for',each .section' - -By providing contact information, entity cansMfopurptoses of administering the; Enroliment'by.Mignz,0fl and other parties that help Micrasof aomtriister this Encaliment:� Tfie person in provided ii 'connection with this agreeraient will be used arid protected ac ording to the-;:pr vairy.. stafsrrisnf available at htt s://licensin .microsoft,Com. 1. Additional notices contact. V This contact receives ..;all notices that are sent from Microsoft. No online access is granted to this individual. Name Of efltiry" - Contact riairie*; First last Co'n6c- t email address* Street address* City* StatelProvince* Postal code* Country* Phone* Fax ❑ This contact is a third party (not the entity). Warning: This contact receives personally identifiable information of the entity. 2. Software Assurance manager. This contact will receive online permissions to manage the Software Assurance benefits under the Enrollment or Registration. Name of entity* Contact name*: First Last Contact email address* Street address* City* StatelProvince* Postal code* S up Co n tactlnfo Form (NA, IN D)(E NG)(O ct2013) Page 1 of 3 33 Country* Phone* Fax ❑ This contact is a third party (not the entity). Warning: This contact receives personally identifiable information of the entity. 3. Subscriptions manager. This contact will assign MSDN, Expression, and TechNet Plus subscription licenses to the individual subscribers under this Enrollment or Registration. Assignment of the subscription licenses is necessary for access to any of the online benefits, such as subscription downloads. This contact will also manage any complimentary or additional media purchases related to these subscriptions. Name of entity* Contact name*: First Last Contact email address* Street address* City* StatelProvince* Postal code* Country* Phone* Fax ❑ This contact is a third party (not the entity), Warning: This cortact receives personally identifiable information of the entity. 4. Online services manager. This contact will be provided online permissions to-; manage the. online ,;;services . o; dered under the Enrollment or Registration.= Name of entity* Contact name*: First Last s . Contact email address* Street address* City* StatelProvince* Postal code* Country* Phone* Fax - ❑ This contact Is a.third -party (not the entity). Warning: This contact"receives personally identifiable informatiop4 p,entity. 5.' Customer Support Manager (CSM). This person is designated as the Customer Support Manager (CSM) for support -related activities. Name of entity* Contact name*: First Last Contact email address* Street address* City* StatelProvince* Postal code* Country* Phone* Fax 6. Primary contact information. An individual from inside the organization must serve as the primary contact. This contact receives online administrator permissions and may grant online access to others. This contact also receives all notices unless Microsoft is provided written notice of a change. Name of entity* Department of Enterprise Services SupContactl nfo Form (NA,IND)(EN G)(Oct2013) Page 2 of 3 34 Contact name*: First Mike Last Dombrowsky Contact email address* mike.dombrowsky@des.wa.gov Street address* 1500 Jefferson St SW City* Olympia StatelProvince* WA Postal code* 98501-2355 Country* USA Phone* 360-407-8717 Fax 7. Notices contact and online administrator information. This individual receives online administrator permissions and may grant online access to others. This contact also receives all notices. ® Same as primary contact Name of entity* Contact name*: First Last Contact email address* Street address* City* StatelProvince* Postal code* Country* Phone* Fax ❑ This contact is a third party (not the entity). Warning: This contact. receives personally identifiable information of the entity. SupContactlnfoForm(NA, IND)(ENG)(Oct2013) Page 3 of 3 35 Microsoft Program Signature Form MBAIMBSA number Agreement number 1� Volume Licensing LWADES-070616 Mote: Enter the, applicable active numbers associated with the documents below. Microsoft requires the associated active number be Indicated here, or listed below as new. Fdf the purposes `oi t€iis inrm,:."Customer' can,. menn : the. signing .eniity, Enrolled-Affili ts,. GO-vernmei f . arlrrer,=ins;it�r[ian, or•oMer party eriter:ng intr3 a �oiUmE liceis,Cn'g'",(]rOgr3rri ' agreBmant. -.. — This signature form and all contract documents identified in the talife below are entered into between the Customer and the Microsoft Affillate signing, as of the effective date identified below. By signing below, Customer and4he Microsoft Affiliate agree that poth parties (1) have recetved, read and understand the above contract documents, including any websites or documents incorporated by reference and any amendments and (2) agree to.be bound by the terms of all such documents. Name of Entity (must be legal entity name)* Department of Enterprise Services Signature*! /17 e'(Os 169¢^'�___ Printed First end Last Name* Greg Tolbert Printed Title Legal Services Manager Signature Date* July 27, 2016 Tax ID * indicates required field - ProgramSigns=orm(MSSIg n)(NA,LafAri)ExBRA, MLi (ENG)(Aug2o 14) Page I of 2 36 Microsoft no Signature Printed First and last krame Printed Title 71 VeneSSa Johnson Signature Date puly Authorized on behalf of (date Microsoft Afmate countersigns) Ni1Cr4SiSft Garparatiort Agreement Date (may be differentt than than Micrcrosotl's signature date) Optional 2nd Customer signature or outsourcer signature (if applicable) Name of Entity (must be legal entity name)* Signature* Printed First and last Name* Printed Title Signature Date* indicates required fie.fd Name of Entity (must be legal entity name)*,;. Signature* Printed First and Last Name* Printed Title $igiiature Date* *indicates required field If Customer requires physical media, additional contacts, or is reporting multiple previous Enrollments, include the appropriate form(s) with this signature form. After this signature farm is signed by the Customer, send it and the Contract Documents to Customer's channel partner or Microsoft account manager, who must submit them to the following address. When the signature form is fully executed by Microsoft, Customer will receive a confirmation COPY. Microsoft Corporation Dept. 551, Volume Licensing 6100 Neil Road, Suite 210 Reno, Nevada 89511-1137 USA ProgramSignForm(MSSign)(NA,LatAm)ExBRA,MLI(ENG)(Aug20t4) Page 2 of 2 37 CITY ❑F �. Federal Way Centered on Opportunity This page was intentionally left blank. m COUNCIL MEETING DATE: August, 11, 2020 ITEM CITY OF FEDERAL WAY CITY COUNCIL AGENDA BILL SUBJECT: AP VOUCHERS 06/16/2020-07/15/2020 AND PAYROLL VOUCHERS 06/01/2020-06/30/2020 POLICY QUESTION: Should the City Council approve the AP vouchers in the total amount of $3,246,333.43 and payroll vouchers in the total amount of $3,550,671.71? COMMITTEE: Finance, Economic Development, and Regional Affairs Committee MEETING DATE: July 28, 2020 CATEGORY: ® Consent ❑ Ordinance ❑ Public Hearing ❑ City Council Business ❑ Resolution ❑ Other STAFF REPORT BY: Ade Ariwoola, Finance Director DEPT: Finance I, the undersigned, do hereby certify under penalty of perjury that the materials have been furnished, the services rendered, or the labor performed as described herein and that the claims are just and due obligations against the Cit of Federal Way, W hiugton, and that I am authorized to authenticate and certify said liens. Finance Director Attachments: Voucher List Options Considered: MAYOR'S RECOMMENDATION: MAYOR APPROVAL: -716 a % ryDIRECTOR APPROVAL: amen r C[ un"t e� v nuial COMMITTEE RECOMMENDATION: I move to forward the vouchers to the August f y 2020 consent agenda for approval. Committee Chair Committee Member Committee Member PROPOSED COUNCIL MOTION: "I move approval of the vouchers pursuant to RCW 42.24. " BELOW TO BE COMPLETED BY CITY CLERKS OFFICE) COUNCIL ACTION: ❑ APPROVED COUNCIL BILL # ❑ DENIED IST reading ❑ TABLED/DEFERRED/NO ACTION Enactment reading ❑ MOVED TO SECOND READING (ordinances only) ORDINANCE # REVISED — 08/12/2010 RESOLUTION # 39 City of Federal Way - Accounts Payable Check List Key Bank Page 1 of 33 Check No Date Vendor Invoice Date Invoice Description AmountGLTotal ACCOUNT PAYABLE-ESCOM $17,953.52 272870 6/30/2020 REYNOLDS, JULIE 6/17/2020 58787 $4,734 70 PKDBC-REFUND CANCELLED CONTRAC 272882 6/30/2020 TAHOMA UNITARIAN UNIV CO6/19/2020 58790-1-2-3 $3,362.36 PKDBC-REFUND CANCELLED CONTRAC 272931 7/15/2020 DALE GOLDEN, ATTN: DALE G7/7/2020 58833 $900.00 PKDBC-REFUND CANCELLED CONTRAC 273013 7/15/2020 ST PATRICKS PARISH, 6/23/2020 58804 &58805 & 58806 $4,45&30 PKDBC-REFUND CANCELLED CONTRAC 272986 7/15/2020 NW WASHINGTON SYNOD, 6/23/2020 58809 & 58810 $3,243.24 PKDBC-REFUND CANCELLED CONTRAC 273005 7/15/2020 SIERRA CLUB, 6/24/2020 58819 $1,254.92 PKDBC-REFUND CANCELLED CONTRAC ADVERTISING $450.00 273008 7/15/2020 SOUND PUBLISHING INC, 6/26/2020 83733388 $450 00 MO-AD#2504860 MAYOR'S MEMO AGRICULTURAL SUPPLIES $1,172.86 272793 6/30/2020 COASTAL FARM & HOME SUPI6/22/2020 3793 $52 79 PKM-REPAIR & MAINT SUPPLIES 273045 7/15/2020 WILBUR-ELLIS COMPANY, 5/7/2020 13449627 $591.75 PWST-OPER SUPPLIES 273045 7/15/2020 WILBUR-ELLIS COMPANY. 5/12/2020 13465996 $237 93 PWST-OPER SUPPLIES 272910 7/15/2020 AGRISHOP INC, 6/9/2020 6113711 $248 68 SWIM -EQUIPMENT PARTS & REPAIRS 272972 7/15/2020 LOWE'S HIW INC, 6/19/2020 01021 $41 71 SWM-MAINT SUPPLIES ANIMAL LICENSE $45.00 272973 7/15/2020 LUBY, PATRICIA 7/8/2020 3-00096458 $45 00 PD-REFUND DUPLICATED PAYMENT# ASPHALT & ROAD OIL $1,444.53 272843 6/30/2020 MILES RESOURCES LLC, 6/8/2020 308542 $280 17 SWM-ASPHALT SUPPLIES 272829 6/30/2020 LAKESIDE INDUSTRIES INC, 3/31/2020 119609 $831 60 SWM-REPAIR SUPPLIES 272975 7/15/2020 MILES RESOURCES LLC, 6/22/2020 309024 $33276 SWM-ASPHALT SUPPLIES AUTOMATION FEE $190.25 272875 6/30/2020 SEKHON DDS PLLC, 6/19/2020 BUSINESS LICENSE $1 00 FI-REFUND OVERPAYMENT FOR BUS 272969 7/15/2020 LAY COMMERCIAL ROOFING 15/12/2020 20-101894 $151 65 CD -REFUND OVERPAYMENT #20-1018 273000 7/15/2020 S M E SOLUTIONS, 5/12/2020 20-101895 $37 60 CD -REFUND TACOMA PWOER'S PJ #2 BOOKS, MAPS, & PERIODICALS $499.20 272850 6/30/2020 NEWS TRIBUNE, 5/29/2020 TAC-76999850 $499.20 CHB-NEWSPAPER ADS/SUBSCRIPTION BUILDING MATERIALS $270.15 272837 6/30/2020 LOWE'S HIW INC, 6/19/2020 2713 $27.13 PKM-MAINT SUPPLIES Key Bank Page 2 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGLTotal 272837 6/30/2020 LOWE'S HIW INC, 6/17/2020 23857 $139.98 CHB-REPAIR & MAINT SUPPLIES 272815 6/30/2020 HOME DEPOT-DEPT 32-2500716/11/2020 5624342 $47 75 CHB-REPAIR & MAINT SUPPLIES 272972 7/15/2020 LOWE'S HIW INC, 6/29/2020 11618 $10.44 CHB-MAINT SUPPLIES 272972 7/15/2020 LOWE'S HIW INC, 7/7/2020 23050 $13.57 CHB-MAINT SUPPLIES 272972 7/15/2020 LOWE'S HIW INC, 7/7/2020 02927 $31.28 CHB-MAINT SUPPLIES BUILDING PERMITS $3,033.00 272969 7/15/2020 LAY COMMERCIAL ROOFING 15/12/2020 20-101894 $3,033.00 CD -REFUND OVERPAYMENT #20-1018 CELLULAR PHONE AIR TIME $14,953.61 272781 6/30/2020 AT&T MOBILITY, 6/11/2020 287288982773X0619202 $3,043 50 IT-06/20 DATA CARDS 272781 6/30/2020 AT&T MOBILITY, 6/5/2020 287290386709X0613202 $40 04 IT-06/20 DATA CARDS 272781 6/30/2020 AT&T MOBILITY, 6/5/2020 287290386709X0613202 $441 34 IT-06/20 DATA CARDS 272885 6/30/2020 T-MOBILE USA INC, 6/14/2020 830401935 $37.60 IT-06/20 CELLULAR SVC 272891 6/30/2020 VERIZON WIRELESS, 6/13/2020 9856656805 $480 12 IT-05/20 CELLULAR SVC ACCT# 272891 6/30/2020 VERIZON WIRELESS, 6/13/2020 9856656805 $120.03 IT-05/20 CELLULAR SVC ACCT# 272891 6/30/2020 VERIZON WIRELESS, 6/13/2020 9856656806 $5,405.53 IT/PAEC-06/20 CELLULAR SVC 272891 6/30/2020 VERIZON WIRELESS, 6/13/2020 9856656806 $4,646.66 IT/PAEC-06/20 CELLULAR SVC 272891 6/30/2020 VERIZON WIRELESS, 6/13/2020 9856656806 $191.89 IT/PAEC-06/20 CELLULAR SVC 272891 6/30/2020 VERIZON WIRELESS, 6/13/2020 9856656807 $443,20 IT-06/20 CELLULAR SVC ACCT# 272891 6/30/2020 VERIZON WIRELESS, 6/13/2020 9856656807 $10370 IT-06/20 CELLULAR SVC ACCT# CEMENT $659.37 272815 6/30/2020 HOME DEPOT-DEPT 32-2500716/17/2020 9021478 $203.92 SWM-REPAIR & MAINT SUPPLIES 272953 7/15/2020 HOME DEPOT-DEPT 32-250076/9/2020 7020584 $32.56 SWM-REPAIR & MAINT SUPPLIES 272972 7/15/2020 LOWE'S HIW INC, 6/11/2020 01332 $69.92 PWST-MAINT SUPPLIES 272981 7/15/2020 NATIONAL BARRICADE COMP.6/18/2020 287034 $241.38 PWST-MAINT SUPPLIES 272972 7/15/2020 LOWE'S HIW INC, 6/16/2020 02007 $13.57 PWST-MAINT SUPPLIES 273044 7/15/2020 WESTSIDE CONCRETE ACCES/18/2020 1379193-IN $89.23 PWST-CONCRETE SUPPLIES 273029 7/15/2020 TRINITY ACE HARDWARE, 6/23/2020 116007 $879 PWST-SUPPLIES CLAIMS PROPERTY - OTHER DEPT $2,147.64 41 Key Bank Page 3 of 33 Check No_ Date Vendor Invoice Date Invoice Description AmountGL Total 272874 6/30/2020 SECOMA FENCE INC, 6/17/2020 15014 $2,147 64 LAW-RM ST LK MAINT FENCE/GATE; CLOTHING AND FOOTWEAR $3,249.21 272772 6/30/2020 911 SUPPLY INC, 6/12/2020 INV-2-3178 $93.39 PD-UNIFORM SUPPLIES 272877 6/30/2020 SOUND UNIFORM/BRATWEA%/9/2020 202006SU074 $46 28 PD-UNIFORM/EQUIPMENT 272793 6/30/2020 COASTAL FARM & HOME SUP15/19/2020 3792 $140 79 PKM-UNIFORM SUPPLIES 272798 6/30/2020 D J TROPHY, 1/14/2020 283504 $130 35 PARKS -CLOTHING SUPPLIES 272798 6/30/2020 D J TROPHY, 1/15/2020 283550 $180.02 PARKS -CLOTHING SUPPLIES 272772 6/30/2020 911 SUPPLY INC, 2/7/2020 85715 $193.57 PD-UNIFORM SUPPLIES 272772 6/30/2020 911 SUPPLY INC, 2/7/2020 85716 $355.29 PD-UNIFORM SUPPLIES 272905 6/30/2020 ZAICHKIN, ETHAN 6/22/2020 ZAICHKIN 2020 $200,00 PD-REIMB BOOTS 272858 6/30/2020 PETTY CASH -POLICE DEPT, 6/24/2020 032961 $65 12 PD-MOTORCYCLE GLOVES- 272847 6/30/2020 MURPHY, CARY 6/24/2020 MURPHY 2020 $192,32 PD-REIMB BOOTS 273011 7/15/2020 SPORTSMAN'S WAREHOUSE.6/16/2020 210-466074 $322.28 SWM-UNIFORM SUPPLIES 273010 7/15/2020 SOUND UNIFORM/BRATWEAR6/15/2020 202006SU133 $548.80 PD-UNIFORM/EQUIPMENT 273010 7/15/2020 SOUND UNIFORM/BRATWEAR6/15/2020 202006SU134 $548.80 PD-UNIFORM/EQUIPMENT 273009 7/15/2020 SOUND SAFETY PRODUCTS 16/19/2020 160139/3 $174.34 PWST-SAFETY CLOTHING 273010 7/15/2020 SOUND UNIFORM/BRATWEA%/12/2020 202006SU114 $57.86 PD-UNIFORM/EQUIPMENT COMMUNICATIONS $2,534.76 272786 6/30/2020 CENTURYLINK, 5/19/2020 1492103182 $228.39 IT-05/20 FACILITY PHONE SERVIC 272786 6/30/2020 CENTURYLINK, 5/19/2020 1492103182 $228,39 IT-05/20 FACILITY PHONE SERVIC 272785 6/30/2020 CENTURYLINK, 6/4/2020 206-Z04-0609472E $90907 IT-06120 PHONE SERVICES 272785 6/30/2020 CENTURYLINK, 6/4/2020 206-Z04-0609472E $90906 IT-06/20 PHONE SERVICES 272913 7/15/2020 AMERICALL COMMUNICATIN7/1/2020 2D6417200701 $86.62 SWM/PWST/CHB-CALL CENTER SVC 272913 7/15/2020 AMERICALL COMMUNICATION7/1/2020 2DG417200701 $86.62 SWM/PWST/CHB-CALL CENTER SVC 272913 7/15/2020 AMERICALL COMMUNICATION/1/2020 2D6417200701 $86.61 SWM/PWST/CHB-CALL CENTER SVC COMPUTER HARDWAREIEQUIPMENT $45,661.52 272816 6/30/2020 HP INC., 6/1/2020 9010349209 $28,427.22 IT-PD-RR Getac B300 G7. Intel 42 Key Bank Page 4 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272816 6/30/2020 HP INC., 6/1/2020 9010349209 $2,842.72 Sales Tax 273049 7/15/2020 ZONES INC, 6/26/2020 K15509440101 $13,083.25 PD-IT SH-IN2440 5-in-1 Low Pro 273049 7/15/2020 ZONES INC, 6/26/2020 K15509440101 $1,308.33 Sales Tax CONCEALED PISTOL LIC - FBI $13.25 273039 7/15/2020 WA STATE PATROL, 7/6/2020 120007686 $13.25 PD-BACKGROUND CHECKS CONCEALED PISTOL LIC - STATE $1,323.00 273037 7/15/2020 WA STATE DEPT OF LICENSIN6/26/2020 06/26/20 CPL FEES $1,323.00 PD-06/26/2020 CPL FEES - CONSTRUCTION PROJECTS $472,344.03 272852 6/30/2020 NORTHWEST PLAYGROUND, 6/26/2020 46688 $194 12 Sales Tax 272852 6/30/2020 NORTHWEST PLAYGROUND, 6/26/2020 46688 $1,941.20 PK/ADM/PL: 50 CUBIC YARDS OF E 272887 6/30/2020 TRANSPO GROUP USA INC, 6/11/2020 24839 $4,803.43 PWST-CITYWIDE ADAPTIVE TRAFFIC 272887 6/30/2020 TRANSPO GROUP USA INC, 6/11/2020 24839 $753.06 PWST-CITYWIDE ADAPTIVE TRAFFIC 272849 6/30/2020 NATIONAL CONSTRUCTION R6/11/2020 5778831 $93.50 PKM-STORAGE CONTAINER 272843 6/30/2020 MILES RESOURCES LLC, 6/16/2020 AG20-053 #1 $94,147 50 PWST-AG20-053 2020 ASPHALT OVE 272843 6/30/2020 MILES RESOURCES LLC, 6/16/2020 AG20-053 #1 $264,937.46 PWST-AG20-053 2020 ASPHALT OVE 273004 7/15/2020 SHOPE CONCRETE PRODUC-6/12/2020 10001296 $35,17 PKM-RISER 272957 7/15/2020 KCDA PURCHASING COOPER5/13/2020 300483184 $95,775.22 PKADM/PL: PLAYGROUND EQUIPMEN 272959 7/15/2020 KING COUNTY FINANCE DIVI54/30/2020 105157-105163 $1,222.81 PW-RSD FW PJ#105157-105163 273027 7/15/2020 TRANSPO GROUP USA INC, 6/30/2020 24913 $6,244 11 PWST-CITYWIDE ADAPTIVE TRAFFIC 273027 7/15/2020 TRANSPO GROUP USA INC, 6/30/2020 24913 $2,196 45 PWST-CITYWIDE ADAPTIVE TRAFFIC CONSULTING CONTRACTS $236,864.85 272800 6/30/2020 EFELLE MEDIA, 6/24/2020 40506 $810 00 MOED-ANNUAL HOSTING JULY-DEC 2 272855 6/30/2020 PARAMETRIX INC, 6/15/2020 19519 $55,951 31 PWST-CITY CENTER ACCESS AG17-1 272783 6/30/2020 BRIGHT ENGINEERING INC, 6/11/2020 6440 $1,427.70 PARKS-AG17-183 SUPPRT WiRSLD R 272825 6/30/2020 KPFF INC, KPFF CONSULTING6/11/2020 327810 $89,143.10 PW-AG20-008 PACIFIC HW NON -MOT 272822 6/30/2020 KBA, INC., 6/10/2020 3005303 $1,454.36 PW-AG19-030 ON -CALL CONSTRUCTI 272855 6/30/2020 PARAMETRIX INC, 5/11/2020 18656 $68,593,05 PWST-CITY CENTER ACCESS AG17-1 272901 6/30/2020 WEST COAST CODE CONSUL75/4/2020 220-FED-APR $1,055,00 CD-AG19-070 BUILDING DIVISION 43 Key Bank Page 5 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272959 7/15/2020 KING COUNTY FINANCE DIVIS4/30/2020 105157-105163 $2,555.22 PW-RSD FW PJ#105157-105163 272932 7/15/2020 DKSASSOCIATES, 6/16/2020 73992R1 $4,576.77 PW-AG20-004 SW DASHPOINT RD/47 272923 7/15/2020 CENTURY WEST ENGINEERIN6/26/2020 241251 $10,928.34 PW-AG19-219 ON -CALL PRO CONSUL 273043 7/15/2020 WEST COAST CODE CONSUL7/10/2020 220-FED-JUN $360.00 CD-AG19-070 BUILDING DIVISION COPIER & PRINTER SUPPLIES $607.73 272928 7/15/2020 COMPLETE OFFICE, 7/2/2020 1975035-0 $101.29 HR-OFFICE SUPPLIES 272928 7/15/2020 COMPLETE OFFICE, 7/2/2020 1975036-0 $101.29 HR-OFFICE SUPPLIES 272928 7/15/2020 COMPLETE OFFICE, 7/2/2020 1975037-0 $202 58 HR-OFFICE SUPPLIES 272928 7/15/2020 COMPLETE OFFICE, 7/2/2020 1975038-0 $101 29 HR-OFFICE SUPPLIES 272928 7/15/2020 COMPLETE OFFICE, 7/2/2020 1975039-0 $50 64 HR-OFFICE SUPPLIES 272928 7/15/2020 COMPLETE OFFICE, 7/2/2020 1975040-0 $50 64 HR-OFFICE SUPPLIES CORPORATIONS -GENERAL $80.00 272875 6/30/2020 SEKHON DDS PLLC, 6/19/2020 BUSINESS LICENSE $80 00 FI-REFUND OVERPAYMENT FOR BUS COURT - AUTO THEFT PREVENTION $2,300.38 272895 6/30/2020 WASTATE-STATE REVENUES,6/19/2020 MAY 2020 $2,300.38 FI-05/20 AUTO THEFT PREVENTION COURT - CRIME VICTIMS $600.29 272866 6/30/2020 PROSECUTING ATTORNEYSC6/19/2020 06/19/20 $600.29 FI-REFUND KC CRIME VICTIMS REM COURT - DEATH INV ACCT $52.05 272895 6/30/2020 WA STATE -STATE R EVEN U ES,6/19/2020 MAY 2020 $52 05 FI-05/20 DEATH INVESTIGATIONS COURT - HWY SAFETY ACT $170.22 272895 6/30/2020 WA STATE -STATE R EVEN U ES,6/19/2020 MAY 2020 $170 22 FI-05/20 HIGHWAY SAFETY COURT - PSEA AS $8,801.03 272895 6/30/2020 WA STATE -STATE REVENU ES,6/19/2020 MAY 2020 $8,80103 FI-05/20 PSEAJIS FEES COURT - SCHOOL SAFETY ZONE $71.11 272895 6/30/2020 WASTATE-STATE REVENUES,6/19/2020 MAY 2020 $7111 FI-05/20 SCHOOL ZONE SAFETY COURT - STATE PORTION $19,437.48 272895 6/30/2020 WA STATE -STATE REVEN UES,6/19/2020 MAY 2020 $19,437.48 FI-05/20 STATE PORTION REMIT F COURT - STATE PSEA 2 $9,091.30 272895 6/30/2020 WASTATE-STATER EVEN U ES,6/19/2020 MAY 2020 $9,09130 FI-05/20 PSEA COURT FEES #2 COURT - STATE PSEA3 $187.14 272895 6/30/2020 WA STATE -STATE REVEN UES,6/19/2020 MAY 2020 $187 14 FI-05/20 PSEA COURT FEES #3 COURT - TRAUMA BRAIN INJURY $786.03 Key Bank Page 6 of 33 Check No Date Vendor Invoice Date Invoice Description AmountGL Total 272895 6/30/2020 WA STATE -STATE REVEN UES,6119/2020 MAY 2020 $786 03 FI-05/20 BRAIN TRAUMA INJ COURT - WSP HIWAY ACCT $295.86 272895 6/30/2020 WA STATE -STATE REVEN UES,6/19/2020 MAY 2020 $295 86 FI-05/20 WSP HIGHWAY COURT -TRAUMA VICTIMS $1,155.69 272895 6/30/2020 WASTATE-STATER EVEN U ES,6/19/2020 MAY 2020 $1,15569 FI-05/20 TRAUMA VICTIMS CUSTODIAL & CLEANING $3,798.44 272784 6/30/2020 CEDAR BUILDING SERVICE IN5/31/2020 50131 $1.029.15 PKDBC-AG19-170 JANITORIAL & 272869 6/30/2020 REGENCY CLEANERS, DBA: I5/31/2020 578 $1,216.72 PD-DRY CLEANING SVC AG14-024- 272779 6/30/2020 ARAMARK UNIFORM SERVICE5/21/2020 1991759018 $73.92 FWCC-LINEN SVC 272779 6/30/2020 ARAMARK UNIFORM SERVICE5/21/2020 1991759017 $39.62 FWCC-LINEN SVC 272779 6/30/2020 ARAMARK UNIFORM SERVICE5/14/2020 1991750297 $33 68 FWCC-LINEN SVC 272779 6/30/2020 ARAMARK UNIFORM SERVICE619/2020 1991783207 $29 82 FWCC-LINEN SVC 272779 6/30/2020 ARAMARK UNIFORM SERVICE5/7/2020 1991741467 $73 92 FWCC-LINEN SVC 272779 6/30/2020 ARAMARK UNIFORM SERVICE5/7/2020 1991741466 $39.62 FWCC-LINEN SVC 273014 7/15/2020 STANLEY CONVERGENT SECA/1/2020 17604401 $115.50 CHB-FW CITY HALL 08/01/20-10/3 272980 7/15/2020 MY ALARM CENTER, 7/1/2020 14073331 $118.29 CHB-ALARM MONITORING 272922 7/15/2020 CEDAR BUILDING SERVICE IN3/30/2020 50218 $1,028.20 PKDBC-AG19-170 JANITORIAL & DEF REV-FWCC-REC TRAC $202.08 272951 7/15/2020 HESKIN, ROGER 6/24/2020 334098 $202.08 FWCC-REFUND CANCELLED MEMB #33 DEF REV-GEN REC-REC TRAC $625.00 272834 6/30/2020 LIFE CHRISTIAN CHURCH, 6/17/2020 333995 $210.00 FWCC-REFUND CANCELLED PGM #333 272853 6/30/2020 NORWESCON, 6/17/2020 333989 $155 00 FWCC-REFUND CANCELLED PGM #333 272876 6/30/2020 SLAVIC GOSPEL CHURCH, 6/17/2020 333992 $260.00 FWCC-REFUND CANCELLED PGM #333 DEPOSITIBONDS PAYABLE-PW $1,772.00 272821 6/30/2020 JOHN KORSMO CONSTRUCT15/19/2020 17-100045 $1,772.00 PW-REFUND CASH DEPOSIT#17-100 DEPOSIT-CD-BLDG OTHER BLDG RV $480.00 272901 6/30/2020 WEST COAST CODE CONSUL75/4/2020 220-FED-APR $480.00 CD-AG19-070 BUILDING DIVISION DISPATCH SERVICES-INTERGOV $453,988.15 273034 7/15/2020 VALLEY COMMUNICATIONS C7/10/2020 0024751 $451,614.50 PD-JULY/AUG 2020 EMER DISPATCH 273034 7/15/2020 VALLEY COMMUNICATIONS C7/10/2020 0024793 $2,373.65 PD-WSP ACCESS 2020 Q2 45 Key Bank Page 7 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total EDUCATIONAL ASSISTANCE 272841 6/30/2020 MCCONNELL, JOSH 6/22/2020 MCCONNELL2020 $2,013.21 PD-REIMB TUITION & BOOKS 272961 7/15/2020 KOPIS, GARY 7/6/2020 KOPIS 2020 $918 50 PD-TUITION REIMB CJUS 300 ELECTRICAL PERMITS 273000 7/15/2020 S M E SOLUTIONS, 5/12/2020 20-101895 $752.01 CD -REFUND TACOMA PWOER'S PJ #2 273020 7/15/2020 TAYLOR HEATING, 5f7/2020 20-101849 $96.50 CD -REFUND OVERPAYMENT #20-1018 ELECTRICITY 272881 6/30/2020 TACOMA PUBLIC UTILITIES, 3/9/2020 100826512 $23.84 PWTR-11/14/19-1/16/20 PUBLIC U 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $230 78 PKM- 2410 S 312TH BEACH RR/CON 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $14.98 PKM- 1STAVE & CAMPUS DR. WINC 272868 6/30/2020 PUGET SOUND ENERGY INC, 6/1/2020 300000007322 $7,534.18 PWTR-06/20 PSE ELECTRICITY CHG 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $15.30 PKM- 2410 S 312TH STORAGE- 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $112.64 PKM- 2410 S 312TH WOODSHOP- 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $303.80 PKM- 2645 S 312TH ANX-RR/FIELD 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $11.02 PKM- 28156 1/2 24TH HERITGE PA 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $83.72 CHB- 31104 28TH AVE S HAUGE BO 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $652 43 PKDBC- 3200 SW DASH PT ROAD- 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $59 31 PKDBC- 3200 SW DASH PT ROAD- 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $9,454 75 CHB- 33325 8TH AVE Z004537423 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $1,250.97 PKM- 33914 19TH AVE SAG FIELD 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $14.11 PKM- 34915 4TH AVE MARKX HOUSE 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $561.41 CHB-600 S 333RD EVID. BLDG UO 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $28.91 FWCC- 876 S 333RD LIGHTS U0962 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $570.03 PKM- S 324TH BLDG A Z004354804 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $551.56 PKM- S 324TH BLDG B Z007917706 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $43.66 PKM-7TH AVE SW N OF SW 320TH N 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $229 60 PKM- 21STAVE LAKOTA RR BLDG & $2,931.71 $848.51 $103,304.09 Em Key Bank Page 8 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $23.62 PKM- 2410 S 312TH STLK ST LIGH 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $157.49 PKM-31600 PETE VON REICHBAUER 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $102.77 PKM-726 S 356TH A093042663 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $127.99 PKM- 726 S 356TH BROOKLAKE B 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $353,09 CHB- 31104 28TH AVE S STLK SHO 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $7,549,29 FWCC- 876 S 333RD Z003478572 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $8 10 PKM-726 S 356TH BROOKLAKE MOBI 272868 6/30/2020 PUGET SOUND ENERGY INC, 4/30/2020 300000007322 $8,230.60 PWTR-04/20 PSE ELECTRICITY CHG 272881 6/30/2020 TACOMA PUBLIC UTILITIES, 5/6/2020 100826512 $23.09 PWTR-1/17/20-3/18/20 PUBLIC U 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/16/2020 220023000239 $16.69 PWTR-06/20 32513 39TH AVE S FE 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/17/2020 220003675349 $8.10 PKM-06/20 726 S 356TH ELECTRIC 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/17/2020 220018358782 $131.27 PKM-06/20 550 SW CAMPUS DR #ZO 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/15/2020 220014198398 $11.42 PKM-06/20 2645 S 312TH ST ELEC 272996 7/15/2020 PUGET SOUND ENERGY INC, 5/28/2020 220023000239 $43.41 PWTR-05/20 32513 39TH AVE S FE 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/11/2020 300000009526 $40,130,00 PWTR-06/20 PWTR STREETLIGHTS 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $11,21 PKM- 28156 1/2 24TH HERITGE PA 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $8.450 99 FWCC- 876 S 333RD Z003478572 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $8 10 PKM-726 S 356TH BROOKLAKE MOBI 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $10,017.03 CHB- 33325 8TH AVE Z004537423 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $1,291.41 PKM- 33914 19TH AVE SAG FIELD 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $14.26 PKM- 34915 4TH AVE MARKX HOUSE 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $548 69 CHB- 600 S 333RD EVID. BLDG UO 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $26.79 FWCC- 876 S 333RD LIGHTS U0962 272996 7/15/2020 PUGET SOUND ENERGY INC. 6/22/2020 300000001978 $55949 PKM- S 324TH BLDG A Z004354804 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $585 77 PKM- S 324TH BLDG B Z007917706 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $44.83 PKM-7TH AVE SW N OF SW 320TH N 47 Key Bank Page 9 of 33 Check No, Date Vendor Invoice Date Invoice Description AmountGL Total 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $104.39 PKM- 21STAVE LAKOTA RR BLDG & 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $24.10 PKM- 2410 S 312TH STLK ST LIGH 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $158.95 PKM-31600 PETE VON REICHBAUER 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $110.65 PKM-726 S 356TH A093042663 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $152.31 PKM- 726 S. 356TH BROOKLAKE B 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $357.15 CHB- 31104 28TH AVE S STLK SHO 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $671.14 PKDBC- 3200 SW DASH PT ROAD- 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $61.01 PKDBC- 3200 SW DASH PT ROAD- 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001234 $47 32 PWTR-06/20 34016 9TH AVE FLOOD 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $634.38 PKM- SAC PARK RR FIELD IGHTS Z 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $20.09 PKM- 1ST AVE & CAMPUS DR. WINC 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $216.89 PKM- 2410 S 312TH BEACH RR/CON 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $16.78 PKM- 2410 S 312TH STORAGE- 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $118.69 PKM- 2410 S 312TH WOODSHOP- 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $281.75 PKM- 2645 S 312TH ANX-RR/FIELD 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $105.99 CHB- 31104 28TH AVE S HAUGE BO FIRST CLASS POSTAGE $1,745.83 272943 7/15/2020 FEDEX OFFICE, 6/26/2020 7-049-48222 $6.25 FI-MAILING SVC 272993 7/15/2020 PITNEY BOWES PRESORT SV6/6/2020 1015794666 $102.74 FI-PITNEY BOWES POSTAGE DEPOSI 272993 7/15/2020 PITNEY BOWES PRESORT SV6/6/2020 1015794667 $1,636.84 FI-PITNEY BOWES POSTAGE DEPOSI FOOD & BEVERAGE $1,031.31 272900 6/30/2020 WATERLOGIC USA LLC, 6/1/2020 65041 $356.40 PD-06/20 RENTAL DEFERRED COOLIE 272845 6/30/2020 MOUNTAIN MIST WATER, 5/31/2020 077665 $48.35 PD-WATER ACCT#077665 272807 6/30/2020 FEDERAL WAY NUTRITION SE3/31/2020 6292 $24.25 PD-03/20 OFFICER LUNCHES 272858 6/30/2020 PETTY CASH -POLICE DEPT, 6/24/2020 032961 $33.96 PD-CUP OF NOODLES FOR- 272920 7/15/2020 CAFFE D'ARTE LLC, 6/29/2020 442712 $40.00 HR-COFFEE SUPPLIES 272977 7/15/2020 MOUNTAIN MIST WATER, 6/30/2020 077665 $24,30 PD-WATER ACCT#077665 Key Bank Page 10 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272997 7/15/2020 QUENCH, INC, 7/1/2020 INV02521503 $65,90 PARKS/FWCC-DRINKING WATER SERV 272997 7/15/2020 QUENCH, INC, 7/1/2020 INV02521503 $32.95 PARKS/FWCC-DRINKING WATER SERV 272948 7/15/2020 GROSSNICKLE, TRACY 7/7/2020 GROSSNICKLE 2020 $405.20 PD-REIMB FOOD FOR JULY 4TH BBQ GASOLINE $15,973.74 272808 6/30/2020 FEDERAL WAY PUBLIC SCHO(5/31/2020 AR13095 $15,695,68 PD-VEHICLE FUEL 272801 6/30/2020 ERNIE'S FUEL STOPS (DBA), 6/15/2020 469142CT $183.61 PD-VEHICLE FUEL 272940 7/15/2020 ERNIE'S FUEL STOPS (DBA), 6/30/2020 474422CT $94 45 PD-VEHICLE FUEL HEALTH INSURANCE PREMIUM $200.00 272871 6/30/2020 ROY, MICHELLE 6/18/2020 ROY 2020 $100 00 PD-DEDUCTIBLE REIMB 273017 7/15/2020 SUND, GRETCHEN 6/29/2020 SUND 2020 $100 00 PD-DEDUCTIBLE REIMB HOUSEHOLD SUPPLIES $14,747.73 272896 6/30/2020 WALTER E NELSON CO., 6/24/2020 764325 $26 34 CHB-JANITORIAL SUPPLIES 272896 6/30/2020 WALTER E NELSON CO., 6/16/2020 763168 $85.56 PARKS -JANITORIAL SUPPLIES 272896 6/30/2020 WALTER E NELSON CO., 6/12/2020 762694 $734.27 FWCC-JANITORIAL SUPPLIES 272896 6/30/2020 WALTER E NELSON CO., 6/16/2020 763171 $157.45 CHB-MAINT SUPPLIES 272896 6/30/2020 WALTER E NELSON CO., 6/16/2020 763169 $85.56 PARKS -JANITORIAL SUPPLIES 272896 6/30/2020 WALTER E NELSON CO., 6/15/2020 762901 $762.83 CHB-JANITORIAL SUPPLIES 272896 6/30/2020 WALTER E NELSON CO„ 6/15/2020 762906 $256,19 FWCC-JANITORIAL SUPPLIES 272896 6/30/2020 WALTER E NELSON CO., 6/15/2020 762907 $42.77 FWCC-JANITORIAL SUPPLIES 272896 6/30/2020 WALTER E NELSON CO„ 6/15/2020 762908 $390.63 FWCC-JANITORIAL SUPPLIES 272896 6/30/2020 WALTER E NELSON CO., 6/8/2020 761713 $32,74 FWCC-JANITORIAL SUPPLIES 273040 7/15/2020 WALTER E NELSON CO., 6/25/2020 764532 $78.31 PKM-JANITORIAL SUPPLIES 273040 7/15/2020 WALTER E NELSON CO„ 6/29/2020 764824 $3,826.90 CHB-JANITORIAL SUPPLIES 273040 7/15/2020 WALTER E NELSON CO., 6/29/2020 764825 $3,826.90 CHB-JANITORIAL SUPPLIES 273040 7/15/2020 WALTER E NELSON CO., 6/29/2020 764831 $13442 CHB-JANITORIAL SUPPLIES 273040 7/15/2020 WALTER E NELSON CO., 6/29/2020 764832 $33.60 PKM-JANITORIAL SUPPLIES 273040 7/15/2020 WALTER E NELSON CO., 7/1/2020 765254 $17.95 PKM-JANITORIAL SUPPLIES mg Key Bank Page 11 of 33 Check No Date Vendor Invoice Date Invoice Description AmountGL Total 273040 7/15/2020 WALTER E NELSON CO., 7/1/2020 765266 $1,241 66 CHB-JANITORIAL SUPPLIES 273040 7/15/2020 WALTER E NELSON CO., 7/1/2020 765271 $26,93 PKM-JANITORIAL SUPPLIES 273040 7/15/2020 WALTER E NELSON CO., 7/2/2020 765716 $2,432.58 CHB-JANITORIAL SUPPLIES 273040 7/15/2020 WALTER E NELSON CO., 7/9/2020 766388 $554,14 PKM-JANITORIAL SUPPLIES INSURANCE -STOP LOSS $57,110.77 701203039 7/1/2020 KAISER FOUNDATION HEALTF7/1/2020 JULY 2020 $6,297 54 FI-07/20ADMIN FEE KAISER HEAL 701203040 7/1/2020 KAISER FOUNDATION HEALTF7/1/2020 JULY 2020 #2 $50,813.23 FI-07/20ADMIN FEE KAISER HEAL INVESTMENT INCOME $2.08 272809 6/30/2020 FEDERAL WAY SCHOOL DISTP6/19/2020 SIF-MAY 2020 $2.08 FI-MAY 2020 SCHL IMPACT FEE JAIL CS - ISSAQ $90 AG19-068 $50,310.00 272789 6/30/2020 CITY OF ISSAQUAH, 6/16/2020 20000470 $24,750.00 PD-AG19-068 JAIL SVC-INMATE HO 272925 7/15/2020 CITY OF ISSAQUAH, 7/10/2020 20000523 $25,560.00 PD-AG19-068 JAILSVC-INMATE HO JAIL CS - KENT $150 + AG19-133 $25,555.00 272926 7/15/2020 CITY OF KENT, 7/8/2020 RI 59143 $25,555.00 PD-AG19-133 JAIL SVC INMATE HO JAIL CS - KING CO $197 + AG13-016 $7,501.75 272824 6/30/2020 KING COUNTY FINANCE DIVI55/9/2020 3002950 $7,501.75 PD-05/20 DAJD OTH CITIES AG13- JAIL CS - PUYALLUP $95 + AG19-069 $2,525.64 272791 6/30/2020 CITY OF PUYALLUP, 6/3/2020 AR113851 $2,525.64 PD-05/20 AG 19-069 JAIL SVC I N M JAIL CS - YAKIM CTY $57.65+AG19-061 $7,133.25 273048 7/15/2020 YAKIMACOUNTY, 7/10/2020 JUNE2020 $7,133.25 PD-AG19-066 JAIL SVC-INMATE HO LEGAL NOTICES $1,514.49 272983 7/15/2020 NEWS TRIBUNE, 5/31/2020 104674580-05152020 $397.63 CD-05/20 NEWSPAPER ADS/SUBSCRI 272983 7/15/2020 NEWS TRIBUNE, 5/27/2020 104655560-05272020 $563 79 CDHS-05/20 NEWSPAPER ADS/SUBSC 272983 7/15/2020 NEWS TRIBUNE, 5/6/2020 104639536-05062020 $553.07 CDHS-05/20 NEWSPAPER ADS/SUBSC LONG DISTANCE CHARGES $412.27 272924 7/15/2020 CENTURYLINK, 6/19/2020 1493898982 $206.14 IT-06/20 FACILITY PHONE SERVIC 272924 7/15/2020 CENTURYLINK, 6/19/2020 1493898982 $206.13 IT-06/20 FACILITY PHONE SERVIC LOW INCOME SENIOR UTAX REBATE $457.21 272999 7/15/2020 ROBINSON. DELLA 7/6/2020 ROBINSON 2019 $71.87 FI-2019 UTILITY TAX REBATE 273003 7/15/2020 SHINN, BONNIE 7/6/2020 SHINN 2019 $98.96 FI-2019 UTILITY TAX REBATE 272911 7/15/2020 ALBRIGHT, C 7/6/2020 ALBRIGHT 2019 $203.78 FI-2019 UTILITY TAX REBATE 50 Key Bank Page 12 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272919 7/15/2020 BENNETT, LYNN 7/6/2020 BENNETT 2019 $82,60 FI-2019 UTILITY TAX REBATE MEDICAL SERVICES 273048 7/15/2020 YAKIMA COUNTY. 7/10/2020 JUNE 2020 $19.51 PD-AG19-066 JAIL SVC-INMATE HO MEDICAL SERVICES - CLAIMS 619206180 6/19/2020 KAISER FOUNDATION HEALTI6/19/2020 INVSF0006180 $5,265.20 FI-06/09/20-06/15/20 KAISER HE 619206194 6/19/2020 KAISER FOUNDATION HEALTF6/19/2020 INVSF0006194 $27,478 45 FI-06/09/20-06/15/20 KAISER HE 626206251 6/26/2020 KAISER FOUNDATION HEALTF6/26/2020 INVSF0006251 $61,648 49 FI-06/16/20-06/22/20 KAISER HE 626206229 6/26/2020 KAISER FOUNDATION HEALTF6/26/2020 INVSF0006229 $523 63 FI-06/16/20-06/22/20 KAISER HE 707206269 7/7/2020 KAISER FOUNDATION HEALTF7/7/2020 INVSF0006269 $2,481 05 FI-06/23/20-06/30/20 KAISER HE 707206293 7/7/2020 KAISER FOUNDATION HEALTF7/7/2020 INVSF0006293 $84,623.23 FI-06/23/20-06/30/20 KAISER HE 710206306 7/10/2020 KAISER FOUNDATION HEALTF7/10/2020 INVSF0006306 $2,865.71 FI-07/01/20-07/06/20 KAISER HE 710206344 7/10/2020 KAISER FOUNDATION HEALTF7/10/2020 INVSF0006344 $54,149 89 FI-07/01/20-07/06/20 KAISER HE MENTAL HEALTH SERVICES 272824 6/30/2020 KING COUNTY FINANCE DIVI,%/9/2020 3002950 $556.86 PD-05/20 DAJD OTH CITIES AG13- MINOR DP SOFTWARE 272832 6/30/2020 LENOVO INC, 6/6/2020 6454597029 $1,700 00 IT -CD -SOUND TRANSIT LENOVO THI 272832 6/30/2020 LENOVO INC,. 6/6/2020 6454597029 $170 00 Sales Tax 272832 6/30/2020 LENOVO INC, 6/13/2020 6454638915 $164 00 IT -CD -SOUND TRANSIT LENOVO THI 272832 6/30/2020 LENOVOINC, 6/13/2020 6454638915 $16.40 Sales Tax MINOR EQUIP-MISC 272904 6/30/2020 WILSON, JUSTIN 6/12/2020 WILSON 2020 $185 80 PD-REIMB HARD DRIVE 272883 6/30/2020 TAN, JEDIDIAH T 6/19/2020 TAN 2020 $100 00 PD-EQUIP ALLOW 272782 6/30/2020 BRACCO, ROBERT 6/23/2020 BRACCO 2020 $219 99 PD-EQUIP ALLOW 272858 6/30/2020 PETTY CASH -POLICE DEPT, 6/24/2020 032961 $42.00 PD-SWAT RIFLE PARTS- 272782 6/30/2020 BRACCO, ROBERT 6/25/2020 BRACCO 2020 $187.00 PD-EQUIP ALLOW 272914 7/15/2020 AMERICAN BARCODE & RFID,7/9/2020 167906 $3,015.00 IT-PD-ZEBRA ZQ520 272914 7/15/2020 AMERICAN BARCODE & RFID,7/9/2020 167906 $301.50 Sales Tax 272914 7/15/2020 AMERICAN BARCODE & RFID,7/8/2020 167799 $80.00 IT-PD-ZEBRA ACCESSORY MICRO US $19.51 $239,035.65 $556.86 $2,050.40 $12,334.03 51 Key Bank Page 13 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGLTotal 272914 7/15/2020 AMERICAN BARCODE & RFID,7/812020 167799 $21.09 Freight 272914 7/15/2020 AMERICAN BARCODE & RFID,7/8/2020 167799 $10.11 Sales Tax 272967 7/15/2020 LARSON, DAVID A 7/3/2020 LARSON 2020 $219.98 MC-REIMB WIRELESS HEADSET 272953 7/15/2020 HOME DEPOT-DEPT 32-250076/12/2020 4093739 $240.81 SWM-REPAIR & MAINT SUPPLIES 273010 7/15/2020 SOUND UNIFORM/BRATWEAR6/16/2020 202006SU146 $1,173 59 PD-UNIFORM/EQUIPMENT 273010 7/15/2020 SOUND UNIFORM/BRATWEA%/16/2020 202006SU147 $1,173.59 PD-UNIFORM/EQUIPMENT 273012 7/15/2020 SRN SYSTEMS INC, 6/3/2020 179692 $4,880 98 PD-DOUBLE BARRIER PACKAGE 273012 7/15/2020 SRN SYSTEMS INC, 6/3/2020 179693 $482.59 PD-CANOPY PACKAGE MISC PROFESSIONAL SVS-INTERGOV $123,403.91 272893 6/30/2020 WA STATE DEPT OF ECOLOG15/18/2020 RS-000000064 $45,062.00 SWM-F92AA500 & F92AB500 WAR045 272894 6/30/2020 WA STATE DEPT OF TRANSPC6/15/2020 RE 41 JZ0247 L018 $1,734,01 PW-PROJECT JZ0247 FEES 272892 6/30/2020 WA STATE AUDITOR'S OFFICES/10/2020 L136934 $21,274.11 FI-STATE AUDITOR SERVICES 272824 6/30/2020 KING COUNTY FINANCE DIVIS5/31/2020 11009140 $87.00 IT-AG20-063 KING COUNTY I -NET 272824 6/30/2020 KING COUNTY FINANCE DIVIS5/31/2020 11009140 $500.00 IT-AG20-063 KING COUNTY I -NET 273039 7/15/2020 WA STATE PATROL, 6/15/2020 00072402 $600 00 IT -ACCESS USER FEE 272959 7/15/2020 KING COUNTY FINANCE DIVISB/8/2020 105654 $26.429.00 SWM-WRIA TOTAL 2020 COST CFW 272959 7/15/2020 KING COUNTY FINANCE DIV154/30/2020 105157-105163 $4,767.97 PW-RSD FW PJ#105157-105163 272959 7/15/2020 KING COUNTY FINANCE DIVIS3/31/2020 104669-104674 $10.852.02 PW-RSD FW PJ#104669-104674 272960 7/15/2020 KING COUNTY RADIO, 6/29/2020 16013 $12,097.80 IT-06/20 RADIO COMMUNICATION MISC SERVICES & CHARGES $117,653.47 272804 6/30/2020 FDS HOLDINGS INC, DBACA%/24/2020 REM11477348 $344.85 FWCC/PARKS-05/20 CARD CONNECT 272804 6/30/2020 FDS HOLDINGS INC, DBACAR6/24/2020 REM11477348 $344.85 FWCC/PARKS-05/20 CARD CONNECT 272804 6/30/2020 FDS HOLDINGS INC, DBA CARS/24/2020 REM11477349 $12 50 FWCC/PARKS-05/20 CARD CONNECT 272804 6/30/2020 FDS HOLDINGS INC, DBA CA%/24/2020 REM11477349 $12 50 FWCC/PARKS-05/20 CARD CONNECT 272787 6/30/2020 CITY OF AUBURN, 12/20/2019 19-034043 $2,916.66 FI-01/20 GAME FARM PARKADMIN 272867 6/30/2020 PUBLIC SAFETY TESTING, 6/10/2020 2020-0297 $60.00 HR-AG16-017 POLICE OFFICER 272901 6/30/2020 WEST COAST CODE CONSUU6/3/2020 220-FED-MAY-WA $4,529.95 CD-AG19-070 BUILDING DIVISION 52 Key Bank Page 14 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272891 6/30/2020 VERIZON WIRELESS, 6/12/2020 9856524128 $160.04 PD-06/20 WATPA CELLULAR SVC AC 272806 6/30/2020 FEDERAL WAY INDOOR RANGE/12/2020 202 $224,40 PD-INDIVIDUAL RANGE USE 272806 6/30/2020 FEDERAL WAY INDOOR RANG/12/2020 203 $224.40 PD-INDIVIDUAL RANGE USE 272806 6/30/2020 FEDERAL WAY INDOOR RAN05/12/2020 204 $171 60 PD-INDIVIDUAL RANGE USE 272891 6/30/2020 VERIZON WIRELESS, 6/13/2020 9856656809 $43344 PD-06/20 CELLULAR SVC ACCT# 272819 6/30/2020 IRON MOUNTAIN INFORMATIC5/31/2020 CRZR130 $852 63 PD-STORAGE SVC 272856 6/30/2020 PETEK, PHD, THOMAS C 5/31/2020 10851 $900.00 PD-PSYCHOLOGICAL EVALUATION 272848 6/30/2020 MV TOWING LLC, 6/20/2020 17633 $77.00 PD-VEHICLE TOW 272819 6/30/2020 IRON MOUNTAIN INFORMATIC12/31/2019 CGZJ177 $900.16 PD-STORAGE SVC 272819 6/30/2020 IRON MOUNTAIN INFORMATICl/31/2020 CJSH752 $858.85 PD-STORAGE SVC 272787 6/30/2020 CITY OF AUBURN, 4/15/2020 20-034796 $28,105.88 FI-03/20 MISCELLANEOUS REIMB 272862 6/30/2020 PORT OF SEATTLE, 4/15/2020 CM-3905 $10,296.39 FI-3/1/20-3/31/20 AUTO THEFT R 272792 6/30/2020 CITY OF TACOMA POLICE DER/20/2020 0032 $12,314.47 FI-03/20 WATPA GRANT REIMB 272788 6/30/2020 CITY OF BONNEY LAKE, 4/13/2020 03312020 $13,203,59 FI-03/20 WATPA GRANT AUTO THIEF 272790 6/30/2020 CITY OF LAKEWOOD, 4/7/2020 PD-01456 $18,689.96 FI-03/20 WATPA GRANT REIMB 272860 6/30/2020 PIERCE COUNTY FINANCE DE3/31/2020 CI-286744 $11,146.76 FI-03/20 WATPA GRANT REIMB 272819 6/30/2020 IRON MOUNTAIN INFORMATIC3/31/2020 CMXH359 $975.18 PD-STORAGE SVC 272939 7/15/2020 EQUIFAX CREDIT INFORMATI6/17/2020 701VC01748 $83.75 PD-CREDIT REPORTING SVC 273042 7/15/2020 WATCH SYSTEMS LLC, 6/18/2020 45785 $424.10 PD-COMM NOTIFICATION SVC 272979 7/15/2020 MV TOWING LLC, 6/24/2020 17640 $220.00 PD-VEHICLE TOW 272979 7/15/2020 MV TOWING LLC, 6/24/2020 17852 $77.00 PD-VEHICLE TOW 273032 7/15/2020 UNIVERSITY OF WASHINGTOt2/26/2020 313 $100.00 PD-JOB FAIR TICKET 272998 7/15/2020 REGIONAL TOXICOLOGYSER6/30/2020 61294063020 $316.45 MC -DRUG TESTS 273046 7/15/2020 WILD WEST INTERNATIONAL 16/30/2020 9795 $12 09 PD-RANGE FEE 272956 7/15/2020 IRON MOUNTAIN INFORMATI06/30/2020 CTKZ823 $95423 PD-STORAGE SVC 272991 7/15/2020 PIERCE COUNTY SECURITY Ir7/1/2020 379135 $7,210.76 MC -SECURITY SERVICES AG16-023 53 Key Bank Page 15 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272930 7/15/2020 D J TROPHY, 7/1/2020 284069 $136 03 PD-RETIREMENT PLAQUE 272942 7/15/2020 FEDERAL WAY INDOOR RANG7/2/2020 205 $158 40 PD-INDIVIDUAL RANGE USE 273028 7/15/2020 TRANSUNION RISK&ALTERN.7/1/2020 837597 $204.60 PD-06/20 BACKGROUND CHECKS NATURAL GAS $6,977.12 272868 6/30/2020 PUGET SOUND ENERGY INC, 6/17/2020 220006213759 $12.45 PKM-06/20 726 S 356TH GAS #493 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $1,860.61 FWCC- 876 S 333RD LIGHTS U0962 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $157.56 CHB- 31104 28TH AVE S STLK SHO 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $193.79 PKM- 726 S 356TH BROOKLAKE C- 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $157,08 CHB- 600 S 333RD EVID BLDG 000 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $812.23 PKDBC- 3200 SW DASH PT ROAD- 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $73.84 PKDBC- 3200 SW DASH PT ROAD- 272868 6/30/2020 PUGET SOUND ENERGY INC, 5/22/2020 300000001978 $32.21 CHB- 31104 28TH AVE S HAUGE - 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $2,361.75 FWCC- 876 S 333RD LIGHTS U0962 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $188.27 PKM- 726 S 356TH BROOKLAKE C- 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $130.71 CHB- 600 S 333RD EVID BLDG 000 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $813.46 PKDBC- 3200 SW DASH PT ROAD- 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $73.95 PKDBC- 3200 SW DASH PT ROAD- 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $87,74 CHB- 31104 28TH AVE S STLK SHO 272996 7/15/2020 PUGET SOUND ENERGY INC, 6/22/2020 300000001978 $21.47 CH B- 31104 28TH AVE S HAUGE - NON GOVT DP SERVICES $11,227.10 272804 6/30/2020 FDS HOLDINGS INC, DBACARo"/24/2020 REM11477347 $25.00 IT-05/20 CH CARD CONNECT FEE 272824 6/30/2020 KING COUNTY FINANCE DIVIS5/31/2020 11009140 $500.00 IT-AG20-063 KING COUNTY I -NET 272780 6/30/2020 ARCHIVESOCIAL INC, 5/17/2020 10431 $4,788.00 IT-ARCHIVE-STANDARD-399, ONE M 272842 6/30/2020 MDE INC, 5/20/2020 8260 $310.00 Sales Tax 272842 6/30/2020 MDE INC, 5/20/2020 8260 $3,100.00 IT-PD YEARLY MAINENANCE PLAN - 272954 7/15/2020 IDENTITY AUTOMATION LP, 6/30/2020 INV-04174 $2,135.00 IT-PD-MULTIFACTOR AUTHENTICATI 272954 7/15/2020 IDENTITY AUTOMATION LP, 6/30/2020 INV-04174 $141.45 IT-PD-MULTIFACTOR AUTHENTICATI 54 Key Bank Page 16 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272954 7/15/2020 IDENTITY AUTOMATION LP, 6/30/2020 INV-04174 $227.65 Sales Tax OFFICE SUPPLIES $1,020.59 272795 6/30/2020 COMPLETE OFFICE, 6/3/2020 1966867-1 $14.39 PW-OFFICE SUPPLIES 272795 6/30/2020 COMPLETE OFFICE, 6/5/2020 1966867-2 $90.42 PW-OFFICE SUPPLIES 272795 6/30/2020 COMPLETE OFFICE, 5/29/2020 1966867-0 $57.74 PW/SWM/SWR-OFFICE SUPPLIES 272795 6/30/2020 COMPLETE OFFICE, 5/29/2020 1966867-0 $74.72 PW/SWM/SWR-OFFICE SUPPLIES 272795 6/30/2020 COMPLETE OFFICE, 5/29/2020 1966867-0 $98 54 PW/SWM/SWR-OFFICE SUPPLIES 272795 6/30/2020 COMPLETE OFFICE, 5/29/2020 1966867-0 $19 24 PW/SWM/SWR-OFFICE SUPPLIES 272795 6/30/2020 COMPLETE OFFICE, 5/29/2020 1966867-0 $77.00 PW/SWM/SWR-OFFICE SUPPLIES 272795 6/30/2020 COMPLETE OFFICE, 5/29/2020 1966867-0 $57 74 PW/SWM/SWR-OFFICE SUPPLIES 272928 7/15/2020 COMPLETE OFFICE, 6/18/2020 1972049-0 $33.12 CD -OFFICE SUPPLIES 272928 7/15/2020 COMPLETE OFFICE, 6/18/2020 1972049-0 $22.95 CD -OFFICE SUPPLIES 273036 7/15/2020 VILMASIGNS, 5/26/2020 3227 $170.50 PW-OFFICE SUPPLIES 273015 7/15/2020 STAPLES BUSINESS ADVANTF6/30/2020 3450188378 $44.11 PD-OFFICE SUPPLIES 273015 7/15/2020 STAPLES BUSINESS ADVANTF6/30/2020 3450188379 $17.62 PD-OFFICE SUPPLIES 272928 7/15/2020 COMPLETE OFFICE, 7/2/2020 1975041-0 $101 29 MC -OFFICE SUPPLIES 272928 7/15/2020 COMPLETE OFFICE, 7/6/2020 1966769-0 $81 06 SWM-OFFICE SUPPLIES 272928 7/15/2020 COMPLETE OFFICE, 6/29/2020 1974229-0 $60 15 PW-OFFICE SUPPLIES OPERATING RENTALSILEASES $17,176.36 272819 6/30/2020 IRON MOUNTAIN INFORMATIC5/31/2020 CSBR711 $2,08272 HRCK-SHREDDING SVC 272813 6/30/2020 HAROLD LEMAY ENTERPRISE5/1/2020 441496 $60 71 HRCK-SHREDDING SVC 272813 6/30/2020 HAROLD LEMAY ENTERPRISES/1/2020 4661478 $33 30 HRCK-SHREDDING SVC 272813 6/30/2020 HAROLD LEMAY ENTERPRISES/l/2020 4661479 $193 30 HRCK-SHREDDING SVC 272917 7/15/2020 BALLI ROAD LLC, 6/1/2020 3160 $3,000 00 PD-06/20 SUBSTATION RENTAGI4- 273022 7/15/2020 THE HUMANE SOCIETY FOR, 7/1/2020 IVC0002225 $6,350 00 PD-AG19-094AGR FOR SHELTER & 273022 7/15/2020 THE HUMANE SOCIETY FOR, 6/30/2020 IVC0002226 $360 50 PD-AG19-094 AGR FOR SHELTER & 272956 7/15/2020 IRON MOUNTAIN INFORMATI03/30/2020 CTLR903 $2,094.83 HRCK-STORAGE SVC 55 Key Bank Page 17 of 33 Check No, Date Vendor Invoice Date Invoice Description AmountGLTotal 272917 7/15/2020 BALLI ROAD LLC, 7/1/2020 3161 $3,000 00 PD-07/20 SUBSTATION RENTAG14- OTHER MISC REVENUE $173.17 625203485 6/25/2020 WA STATE REVENUE DEPART6/25/2020 601-223-5385 $11.36 FI-05/20 REMIT SALES TAX 625203485 6/25/2020 WA STATE REVENUE DEPART6/25/2020 601-223-5385 $0.01 FI-05/20 REMIT SALES TAX 625203485 6/25/2020 WA STATE REVENUE DEPART6/25/2020 601-223-5385 $161 80 FI-05/20 REMIT SALES TAX FWCC OTHER MISCELLANEOUS REVENUE $1,494.77 625203485 6/25/2020 WA STATE REVENUE DEPART6/25/2020 601-223-5385 $1.494 77 FI-05/20 REMIT SALES TAX DBC OTHER OPERATING SUPPLIES $49,851.62 272896 6/30/2020 WALTER E NELSON CO., 6/24/2020 764411 $16,257 96 CHB-JANITORIAL SUPPLIES 272890 6/30/2020 VADINO, BILL 6/25/2020 VADINO 2020 $258 51 MO-REIMB JUNETEENTH FLAG 272858 6/30/2020 PETTY CASH -POLICE DEPT, 6/24/2020 032961 $27 48 PD-FIREARMS TRAINING BOOK- 272858 6/30/2020 PETTY CASH -POLICE DEPT, 6/24/2020 032961 $69.03 PD-DOG FOOD SUPPLIES FOR- 272858 6/30/2020 PETTY CASH -POLICE DEPT, 6/24/2020 032961 $60.19 PD-DOG FOOD SUPPLIES FOR- 272837 6/30/2020 LOWE'S HIW INC, 3/6/2020 01332 $78.14 SWM-MAINT SUPPLIES 272872 6/30/2020 SAN DIEGO POLICE EQUIPME6/3/2020 642954 $565.02 Sales Tax 272872 6/30/2020 SAN DIEGO POLICE EQUIPME6/3/2020 642954 $5,650.20 PD-POLICE AMMUNITION SUPPLIES- 272896 6/30/2020 WALTER E NELSON CO., 6/15/2020 762905 $204.95 PARKS -JANITORIAL SUPPLIES 272896 6/30/2020 WALTER E NELSON CO., 6/16/2020 763170 $85.56 1 PARKS -JANITORIAL SUPPLIES 272795 6/30/2020 COMPLETE OFFICE, 6/15/2020 1970622-0 $263.78 CHB-OFFICE SUPPLIES 272795 6/30/2020 COMPLETE OFFICE, 6/15/2020 1969930-0 $38.49 CC -FACE MASK 272865 6/30/2020 PROFORCE LAW ENFORCEMI6/12/2020 413653 $3,877.51 PD-TASER SUPPLIES 272826 6/30/2020 L N CURTIS & SONS, 5/29/2020 INV392952 $1,165.91 PD-OPER SUPPLIES 272858 6/30/2020 PETTY CASH -POLICE DEPT, 6/24/2020 032961 $10.27 PD-DOG FOOD FOR DOG TRAP USED 272896 6/30/2020 WALTER E NELSON CO., 5/27/2020 760165 $76.54 PARKS -JANITORIAL SUPPLIES 272837 6/30/2020 LOWE'S HIW INC, 6/18/2020 23887 $28.03 CHB-REPAIR & MAINT SUPPLIES 272837 6/30/2020 LOWE'S HIW INC, 3/11/2020 01140 $295.76 SWM-MAINT SUPPLIES 272837 6/30/2020 LOWE'S HIW INC, 3/11/2020 98407 $1,484.99 SWM-MAINT SUPPLIES 56 Key Bank Page 18 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272837 6/30/2020 LOWE'S HIW INC, 3/12/2020 01324 $148.04 SWM-MAINT SUPPLIES 272837 6/30/2020 LOWE'S HIW INC, 3/12/2020 01424 $96 69 SWM-MAINT SUPPLIES 272811 6/30/2020 FOOTPRINT PROMOTIONS IN6/5/2020 52841 $584 92 MC-SANITIZER, MASK&ALC WIPES 272837 6/30/2020 LOWE'S HIW INC, 3/12/2020 01347 $203 84 SWM-MAINT SUPPLIES 272981 7/15/2020 NATIONAL BARRICADE COMP6/18/2020 287035 $55.00 SWM-OPER SUPPLIES 272915 7/15/2020 ARAMARK UNIFORM SERVICES/18/2020 22513254 $2,500.96 CHB-FACE MASK 272915 7/15/2020 ARAMARK UNIFORM SERVICE6/18/2020 22513974 $3,126.20 CHB-FACE MASK 272915 7/15/2020 ARAMARK UNIFORM SERVICE6/17/2020 22510349 $3,126.20 CHB-FACE MASK 272946 7/15/2020 GRAINGER INC, 6/12/2020 9559633699 $34.11 PWST-FACILITY MAINT SUPPLIES 272946 7/15/2020 GRAINGER INC, 6/12/2020 9559633707 $17.06 PWST-FACILITY MAINT SUPPLIES 272953 7/15/2020 HOME DEPOT-DEPT 32-250076/15/2020 1616626 $9.28 IT -REPAIR & MAINT SUPPLIES 272937 7/15/2020 EMERALD SERVICES INC, 6/2/2020 83084563-2002272088 $153.50 FLT-MAINT SUPPLIES 272941 7/15/2020 EXCEL SUPPLY COMPANY, IN(6/12/2020 122841 $341 96 SWM-SAFETY SUPPLIES 272941 7/15/2020 EXCEL SUPPLY COMPANY, IN(6/1212020 122862 $202 36 PWST-SAFETY SUPPLIES 272972 7/15/2020 LOWE'S HIW INC, 6/12/2020 01484 $58 48 PWST-MAINT SUPPLIES 272945 7/15/2020 FLOYD EQUIPMENT COMPAN6/26/2020 459358 $153 84 CHB-REPAIR/MAINT SUPPLIES 273030 7/15/2020 TRI-TECH FORENSICS INC, 6/25/2020 281672 $1,907 70 PD-OPER SUPPLIES 273030 7/15/2020 TRI-TECH FORENSICS INC, 6/25/2020 281675 $479.25 PD-OPER SUPPLIES 272972 7/15/2020 LOWE'S HIW INC, 6/23/2020 23229 $100.82 CHB-MAINT SUPPLIES 272984 7/15/2020 NORMED, 6/24/2020 12378-813824 $492.65 PD-FIRSTAID SUPPLIES 272972 7/15/2020 LOWE'S HIW INC, 6/24/2020 16426 $-85.66 CHB-RETURN CREDIT 272941 7/15/2020 EXCEL SUPPLY COMPANY, IN(3/12/2020 3977 $220.04 PWST-SAFETY SUPPLIES 272941 7/15/2020 EXCEL SUPPLY COMPANY,IN(3/12/2020 3978 $76.93 PWST-SAFETY SUPPLIES 273015 7/15/2020 STAPLES BUSINESS ADVANTl6/30/2020 3450188367 $41.51 PD-OFFICE SUPPLIES 273015 7/15/2020 STAPLES BUSINESS ADVANTP6/30/2020 3450188368 $15.64 PD-OFFICE SUPPLIES 273015 7/15/2020 STAPLES BUSINESS ADVANTF6/30/2020 3450188370 $15.64 PD-OFFICE SUPPLIES 57 Key Bank Page 19 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 273015 7/15/2020 STAPLES BUSINESS ADVANTF6/30/2020 3450188371 $184,84 PD-OFFICE SUPPLIES 273015 7/15/2020 STAPLES BUSINESS ADVANTf6/30/2020 3450188372 $328.10 PD-OFFICE SUPPLIES 273015 7/15/2020 STAPLES BUSINESS ADVANTf6/30/2020 3450188374 $31.28 PD-OFFICE SUPPLIES 273015 7/15/2020 STAPLES BUSINESS ADVANTf6/30/2020 3450188375 $28272 PD-OFFICE SUPPLIES 273015 7/15/2020 STAPLES BUSINESS ADVANTF6/30/2020 3450188377 $15.64 PD-OFFICE SUPPLIES 272946 7/15/2020 GRAINGER INC, 7/1/2020 9577368401 $1.358.58 PKM-FACILITY MAINT SUPPLIES 272928 7/15/2020 COMPLETE OFFICE, 7/6/2020 1975942-0 $366 70 MO -OFFICE SUPPLIES 272928 7/15/2020 COMPLETE OFFICE, 7/6/2020 1975944-0 $6.66 MO -OFFICE SUPPLIES 273047 7/15/2020 XTREME GRAPHIX INC, 7/7/2020 20-1089 $15.85 PKM-PARK SIGNS AG 17-050- 272934 7/15/2020 DOOLEY ENTERPRISES INC, 7/15/2020 57494 $2,685.97 PD-AMMUNITION -AFFIDAVIT PARKINGITOLLS $6.00 272858 6/30/2020 PETTY CASH -POLICE DEPT, 6/24/2020 032961 $6.00 PD-TOLL FEES FOR BACKGROUND PD - CLAIMS AUTO $5,258.14 272794 6/30/2020 COMPLETE COLLISION CENT[1/7/2020 24944 $3,198.69 LAW-RM PD 6402 12/31/19 DAMAGE 272844 6/30/2020 MONARCH COLLISION CENTE5/13/2020 1231 $1,988.01 LAW-RM PD 6343 EVOC DAMAGE; RM 272830 6/30/2020 LARSEN SIGN CO., 6/2/2020 27126 $71.44 LAW-RM-PD 6343 EVOC DAMAGE;RSK PER DIEM MEALS $1,400.00 272841 6/30/2020 MCCONNELL, JOSH 6/2612020 MCCONNELL 2020 $580.00 PD-ADV TVL REIMB FHI LV1 272782 6/30/2020 BRACCO, ROBERT 6/26/2020 BRACCO 2020 $580.00 PD-ADC TVL REIMB FHI LV1 272831 6/30/2020 LARSON, DAYNA 6/24/2020 LARSON 2020 $240.00 PD-ADV TVL REIMB BACO CERT POSTAGEIDELIVERY SERVICES $1,022.76 272889 6/30/2020 UNITED PARCEL SERVICE, 6/6/2020 000OF658BV230 $1 11 PD-DOCUMENT DELIVERY SERVICE 272993 7/15/2020 PITNEY BOWES PRESORT SV6/6/2020 1015794666 $24 46 FI-PITNEY BOWES POSTAGE DEPOSI 272993 7/15/2020 PITNEY BOWES PRESORT SV6/6/2020 1015794666 $35.88 FI-PITNEY BOWES POSTAGE DEPOSI 272993 7/15/2020 PITNEY BOWES PRESORT SV6/6/2020 1015794667 $389.72 FI-PITNEY BOWES POSTAGE DEPOSI 272993 7/15/2020 PITNEY BOWES PRESORT SV6/6/2020 1015794667 $571.59 FI-PITNEY BOWES POSTAGE DEPOSI PRESCRIPTION SERVICES - CLAIMS $64,876.49 619206180 6/19/2020 KAISER FOUNDATION HEALT[6/19/2020 INVSF0006180 $25,970.14 FI-06/09/20-06/15/20 KAISER HE MQ Key Bank Page 20 of 33 Check No_ Date Vendor Invoice Date Invoice Description AmountGL Total 619206194 6/19/2020 KAISER FOUNDATION HEALTF6/19/2020 INVSF0006194 $9,760.50 FI-06/09/20-06/15/20 KAISER HE 626206229 6/26/2020 KAISER FOUNDATION HEALTF6126/2020 INVSF0006229 $1,295.04 FI-06/16/20-06/22/20 KAISER HE 626206251 6/26/2020 KAISER FOUNDATION HEALTF6/26/2020 INVSF0006251 $8,260.98 FI-06/16/20-06/22/20 KAISER HE 707206269 7/7/2020 KAISER FOUNDATION HEALTF7/7/2020 INVSF0006269 $10779 FI-06/23/20-06/30/20 KAISER HE 707206293 7/7/2020 KAISER FOUNDATION HEALTF7/7/2020 INVSF0006293 $11,013.98 FI-06/23/20-06/30/20 KAISER HE 710206344 7/10/2020 KAISER FOUNDATION HEALTF7/10/2020 INVSF0006344 $8.450.08 FI-07/01/20-07/06/20 KAISER HE 710206306 7/10/2020 KAISER FOUNDATION HEALTF7/10/2020 INVSF0006306 $17.98 FI-07/01/20-07/06/20 KAISER HE PRINTING/PHOTO SERVICES $275.14 272863 6/30/2020 PRINTERY COMM U NICATIONE5/29/2020 200330 $275 14 HR-BC IMPRINTS PROFESSIONAL SERVICES $341,533.67 272820 6/30/2020 JIMENEZ PRODUCTIONS, DA\,6/23/2020 JIMENEZ 06/23/2020 $72 50 IT -VIDEO SVC FEDRAC ZOOM MTG 272774 6/30/2020 ABOU-ZAKI, KAMAL 6/23/2020 06/23/20 $110 00 MC -INTERPRETER SVC 272823 6/30/2020 KIM, CHULJOON 6/23/2020 06/23/20 $110.00 MC -INTERPRETER SVC 272823 6/30/2020 KIM, CHUL JOON 6/23/2020 06/23/20 #2 $110.00 MC -INTERPRETER SVC 272818 6/30/2020 INTERCOM LANGUAGE SVCS,6/19/2020 20-325 $1,041.25 MC -INTERPRETER SVC 272854 6/30/2020 OGDEN, MURPHY, WALLACE, 5/25/2020 839272 $37,000 00 LAW-AG18-150 LEGAL SERVICES- 272878 6/30/2020 SPECTRA LABORATORIES 1-1-3/1/2020 0000013-IN $1.322 00 CDHS-2020 MLK COMM EVENT 272814 6/30/2020 HERRERA ENVIRONMENTAL, 6/10/2020 46727 $5,245.04 SWM-AG 18-104 SWM COMPREHENSIV 272820 6/30/2020 JIMENEZ PRODUCTIONS, DAW9/2020 JIMENEZ 06/09/2020 $43.50 CC-6/9/2020 PRHSPS MTG 272818 6130/2020 INTERCOM LANGUAGE SVCS)5/12/2020 20-318 $1,547.26 MC -INTERPRETER SVC 272820 6/30/2020 JIMENEZ PRODUCTIONS, DAb6/16/2020 JIMENEZ 06/16/20 $188.50 IT -VIDEO SVC CC MTG 272820 6130/2020 JIMENEZ PRODUCTIONS, DAb6/16/2020 JIMENEZ 06/16/20 #2 $120.00 IT -VIDEO SVC BEHALF ST 272774 6/30/2020 ABOU-ZAKI, KAMAL 6/17/2020 06/17/20 $110.00 MC -INTERPRETER SVC 272854 6/30/2020 OGDEN. MURPHY, WALLACE, 6/16/2020 840186 $770.00 LAW-AG18-150 LEGAL SERVICES- 272828 6/3012020 LAKEHAVEN UTILITY DISTRIC6/17/2020 232804 $37.69 PAEC-05/20 31510 20 AVE S. IRR 272840 6/30/2020 MADRONA LAW GROUP PLLC,G/2/2020 10225 $4,700.00 LAW-AG19-245 LEGAL SERVICES- 272797 6/30/2020 CORRECTIONS SOFTWARE, 55/1/2020 48146 $500.00 MC-06/20 PROBATION COMPUTER SY 59 Key Bank Page 21 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272805 6/30/2020 FEDERAL WAY BOYS & GIRLS6/26/2020 1/1/20 - 6/30/20 $35,358.00 CDHS-AG20-082 EXPANDED LEARNIN 272859 6/30/2020 PHENOMENAL SHE, 6/25/2020 06/25/20 $35,059.38 CDHS-AG20-072 PHENOMENAL SHE A 701203039 7/1/2020 KAISER FOUNDATION HEALTI-7/1/2020 JULY 2020 $4,538.24 FI-07/20 ADMIN FEE KAISER HEAL 701203040 7/1/2020 KAISER FOUNDATION HEALTI-7/1/2020 JULY 2020 #2 $35,262 74 FI-07/20 ADMIN FEE KAISER HEAL 273001 7/15/2020 SAFAROVA-DOWNEY,ALMIRA7/3/2020 07/03/20 $12100 MC -INTERPRETER SVC 272949 7/15/2020 HAWKINS & CRAWFORD, PLL(7/3/2020 20200703 $46,030-00 MO-AG19-109 06/20 PUBLIC DEFEN 272932 7/15/2020 DKS ASSOCIATES, 7/7/2020 0074120 $61 13 PW-AG19-216 HORIZONTAL CURVE W 272968 7/15/2020 LAW OFFICES OF MATTHEW F716/2020 293 $500 00 MO-AG16-049 CONFLICT DEFENDER 272958 7/15/2020 KIM, CHUL JOON 6/30/2020 06/30/20 $110 00 MC -INTERPRETER SVC 272907 7/15/2020 ABOU-ZAKI, KAMAL 6/30/2020 06/30/20 $112.50 MC -INTERPRETER SVC 273001 7/15/2020 SAFAROVA-DOWNEY, ALMIRA6/30/2020 06/30/20 $121.00 MC -INTERPRETER SVC 272938 7/15/2020 EPICENTER SERVICES LLC, 6/29/2020 2020-04 $586.58 PWSWR-AG18-090 RECYCLING COLLIE 272990 7/15/2020 PERFORMING ARTS & EVENT3/1/2020 0000013-IN $1,322.00 CDHS-2020 MLK COMM EVENT 273033 7/15/2020 USIC HOLDINGS INC, 3/31/2020 375492 $2.301.75 PWTR/SWM-AG19-078 UGD ULT LOCA 273033 7/15/2020 USIC HOLDINGS INC, 3/31/2020 375492 $5,370 75 PWTR/SWM-AG19-078 UGD ULT LOCA 272959 7/15/2020 KING COUNTY FINANCE DIVIS3/31/2020 104669-104674 $1,375.38 PW-RSD FW PJ#104669-104674 273014 7/15/2020 STANLEY CONVERGENT SECr7/1/2020 17598590 $115,50 CHB-FW EVIDENCE BULD 08/01/20- 272978 7/15/2020 MULTICARE CENTERS OF, OC7/1/2020 138550 $990.00 PD-OFFICER PHYSICAL 272982 7/15/2020 NAVIA BENEFIT SOLUTIONS, 6/30/2020 10261672 $262.65 HR-06/20 FLEX PLAN ADM SVCS 272987 7/15/2020 OCCUPATIONAL HEALTH CEN6130/2020 68335506 $102.50 HR-WELLNESS SCREENING 272965 7/15/2020 LANGUAGE LINE SERVICES, I6/30/2020 4853583 $210.88 PD-LANGUAGE SVC 273035 7/15/2020 VIGILNETAMERICALLC, 6/30/2020 1989479 $6,111.15 MC -PROBATION ALCOHOL MONITORIN 273024 7/15/2020 THUILLIER, JENNIFER 6/30/2020 202041 $210,00 PW/SWM-EDITS TO CP PUBLICATION 273024 7/15/2020 THUILLIER, JENNIFER 6/30/2020 202041 $210.00 PW/SWM-EDITS TO CP PUBLICATION 272907 7/15/2020 ABOU-ZAKI, KAMAL 7/8/2020 07/08/20 $121.00 MC -INTERPRETER SVC 272958 7/15/2020 KIM, CHULJOON 7/8/2020 07/08/20 $110.00 MC -INTERPRETER SVC Key Bank Page 22 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 273027 7/15/2020 TRANSPO GROUP USA INC, 7/8/2020 24931 $378.12 PW-AG19-168 VARIABLE LANE USE 272964 7/15/2020 LANE POWELL PC, 6/22/2020 3829324 $85,871.00 PW-AG_ 19-225 LEGAL SERVICES- 272976 7/15/2020 MILLER, NASH, GRAHAM & DL6/25/2020 2140162 $413.00 LAW -AG 18-075 CONDEMNATION LE 272955 7/15/2020 INTERCOM LANGUAGE SVCS,G/26/2020 20-333 $491.00 MC -INTERPRETER SVC 272952 7/15/2020 HISTORICAL SOCIETY-FEDER6/28/2020 23 $5,000 00 FI-Q2/20 MOU HISTORICAL SOCIET 272918 7/15/2020 BENCHMARK HOLDCO LLC, D6/1/2020 258 $15,500.00 PD-AG20-071 BENCHMARK ANALYTIC 272962 7/15/2020 KPG INC, 4/1/2020 3-8320 $2,642.68 SWM-AG19-182 ON -CALL SURVEYING 273016 7/15/2020 SUMMIT LAW GROUP, 6/19/2020 113769 $1,536.00 HR-AG19-235 LEGAL SVC TEAMSTER PUBLIC WORKS - INSPECTION DEPOS $413.00 272821 6/30/2020 JOHN KORSMO CONSTRUCTI5/20/2020 17-100045-00-OP $413.00 PW-REFUND CASH DEPOSIT#17-100 PW - CLAIMS GLIPL $583.00 272810 6/30/2020 FLOYD, PFLUEGER & RINGER6/3/2020 59901 $454.50 LAW -LEGAL SVCS AG13-033- 272810 6/30/2020 FLOYD, PFLUEGER & RINGER6/3/2020 59900 $128,50 LAW -LEGAL SVCS AG13-033— RENTAL OF FURNITUREIEQUIPMENT $2,302.00 272950 7/15/2020 HEAD -QUARTERS PTS, 4/30/2020 35436 $1,151.00 PARKS-AG18-017 SANICAN SERVICE 272950 7/15/2020 HEAD -QUARTERS PTS, 6/30/2020 35726 $1,151.00 PARKS-AG18-017 SANICAN SERVICE REPAIR & MAINT SUPPLIES $27,228.10 272815 6/30/2020 HOME DEPOT-DEPT 32-2500716/24/2020 2618138 $22.45 PKM-REPAIR & MAINT SUPPLIES 272773 6/30/2020 986 LABS INC, 6/2/2020 986-1163 $-1,154.99 CHB-DISCOUNT 272773 6/30/2020 986 LABS INC, 6/2/2020 986-1163 $2,100.00 CHB-PEDESTALS FOR TEMPERTURE S 272773 6/30/2020 986 LABS INC, 6/2/2020 986-1163 $21,000.00 CHB-AUTOMATED TEMPERATURE SCRE 272773 6/30/2020 986 LABS INC, 6/2/2020 986-1163 $495,65 Freight 272851 6/30/2020 NORTHSHORE VILLAGE, 6/9/2020 11364 $7,90 PKDBC-MAINT SUPPLIES 272837 6/30/2020 LOWE'S HIW INC, 6/11/2020 02140 $65.54 SWM-MAINT SUPPLIES 272812 6/30/2020 GRAINGER INC, 6/11/2020 9557443190 $433,40 CHB-FACILITY MAINT SUPPLIES 272837 6/30/2020 LOWE'S HIW INC, 6/12/2020 10511 $3621 CHB-MAINT SUPPLIES 272837 6/30/2020 LOWE'S HIW INC, 6/15/2020 09290 $11.48 SWM-MAINT SUPPLIES 272815 6/30/2020 HOME DEPOT-DEPT 32-250076/11/2020 5616122 $6.88 PKM-REPAIR & MAINT SUPPLIES 61 Key Bank Page 23 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGLTotal 272824 6/30/2020 KING COUNTY FINANCE DIVIS3/4/2020 2123173 $408.84 SWM-METERIALS FOR FEB 2020 272824 6/30/2020 KING COUNTY FINANCE DIVIS3/4/2020 2123178 $648,01 SWM-METERIALS FOR FEB 2020 ACC 272888 6/30/2020 TRINITY ACE HARDWARE, 6/19/2020 115146 $18.68 PKM-SUPPLIES 272851 6/30/2020 NORTHSHORE VILLAGE, 6/23/2020 11405 $93.46 PKM-MAINT SUPPLIES 272815 6/30/2020 HOME DEPOT-DEPT 32-2500714/24/2020 3616902 $65.96 SWM-REPAIR & MAINT SUPPLIES 272972 7/15/2020 LOWE'S HIW INC, 6/18/2020 02445 $177.85 SWM-MAINT SUPPLIES 273029 7/15/2020 TRINITY ACE HARDWARE, 6/10/2020 113466 $21.71 SWM-SUPPLIES 273029 7/15/2020 TRINITY ACE HARDWARE, 4/17/2020 101270 $98 98 , PKM-SUPPLIES 273023 7/15/2020 THE PART WORKS INC, 4/29/2020 INV55902 $544 05 PKDBC-MAINT SUPPLIES 273029 7/15/2020 TRINITYACE HARDWARE, 6/8/2020 113124 $61 56 SWM-SUPPLIES 272972 7/15/2020 LOWE'S HIW INC, 6/5/2020 01280 $117.27 SWM-MAINT SUPPLIES 273029 7/15/2020 TRINITY ACE HARDWARE, 6/2/2020 111789 $5.49 SWM-SUPPLIES 272980 7/15/2020 MY ALARM CENTER, 6/12/2020 14114809 $181.29 PKM-ALARM MONITORING SVC 272988 7/15/2020 O'REILLY AUTO PARTS, 6/11/2020 3710-398184 $55.42 SWM-MAINT PARTS 272972 7/15/2020 LOWE'S HIW INC, 6/12/2020 01455 $20,89 PWST-MAINT SUPPLIES 272972 7/15/2020 LOWE'S HIW INC, 6/12/2020 01466 $166.16 PWST-MAINT SUPPLIES 273029 7/15/2020 TRINITYACE HARDWARE, 6/29/2020 117413 $18.83 PKM-SUPPLIES 272910 7/15/2020 AGRISHOP INC, 6/26/2020 61351/1 $244.46 PKM-EQUIPMENT PARTS & REPAIRS 272912 7/15/2020 AMB TOOLS & EQUIPMENT C(6/26/2020 T322804 $348.29 PKM-MAINT SUPPLIES 273029 7/15/2020 TRINITYACE HARDWARE, 6/25/2020 116477 $76.89 PKM-SUPPLIES 272910 7/15/2020 AGRISHOP INC, 6/24/2020 61317/1 $224.93 PKM-EQUIPMENT PARTS & REPAIRS 272936 7/15/2020 ECOLIGHTS NORTHWEST, 6/25/2020 INV-001593 $152.60 CHB-RECYCING SUPPLIES 272929 7/15/2020 CONSOLIDATED ELECTRICAL6/22/2020 8073-645860 $256.63 CHB-LIGHTING SUPPLIES 273029 7/15/2020 TRINITYACE HARDWARE, 6/30/2020 117553 $10.99 PKM-SUPPLIES 273029 7/15/2020 TRINITYACE HARDWARE, 6/30/2020 117557 $7.69 PKM-SUPPLIES 272994 7/15/2020 PLATT ELECTRIC SUPPLY, 6/25/2020 OL90020 $247 16 CHB-ELECTRICAL SUPPLIES 62 Key Bank Page 24 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 273029 7/15/2020 TRINITYACE HARDWARE, 3/30/2020 98163 $1869 SWM-SUPPLIES 272972 7/15/2020 LOWE'S HIW INC, 7/2/2020 23760 $14 59 PKM-MAINT SUPPLIES 272910 7/15/2020 AGRISHOP INC, 7/2/2020 61426/1 $9.19 PKM-EQUIPMENT PARTS & REPAIRS 272929 7/15/2020 CONSOLIDATED ELECTRICAL6/30/2020 8073-648305 $-247.50 CHB-LIGHTING SUPPLIES 272910 7/15/2020 AGRISHOP INC, 7/7/2020 61467/1 $134.52 PKM-EQUIPMENT PARTS & REPAIRS REPAIR PARTS $9,940.91 272899 6/30/2020 WASHINGTON TRACTOR INC,6115/2020 2115865 $246.05 FLT-MAINT PARTS 272899 6/30/2020 WASHINGTON TRACTOR INC,6115/2020 2115858 $374.76 FLT-MAINT PARTS 272776 6/30/2020 ADVANCE AUTO PARTS, 6/11/2020 13144-391873 $131 96 FLT-MAINT SUPPLIES 272778 6/30/2020 ADVANCED TRAFFIC PRODUCE/18/2020 0000027031 $4,536.40 PD-EMITTER 272802 6/30/2020 EVERGREEN AUTO ELECTRIC4/20/2020 32027 $115.34 FLT-MAINT SUPPLIES 272909 7/15/2020 ADVANCED TRAFFIC PRODUCE/25/2020 0000027079 $4.536.40 PD-EMITTER REPAIRS AND MAINTENANCE $204,058.71 272858 6/30/2020 PETTY CASH -POLICE DEPT, 6/24/2020 032961 $78.00 PD-ROADSIDE ASSISTANCE- 272858 6/30/2020 PETTY CASH -POLICE DEPT, 6/24/2020 032961 $12.00 PD-CAR WASH FOR TAKE HOME- 272835 6/30/2020 LIMITED ENERGY SERVIC INC4/15/2020 P 4822 $1,655.78 CHB-SYSTEM MAINT SVC 272903 6/30/2020 WHITMAN GLOBAL CARPET C5/1/2020 85203 $2,043.14 CHB-CARPET CLEANING SVC AG13-0 272775 6/30/2020 ACTION SERVICES CORPORA4/30/2020 105183 $5,235.30 PWST-AG19-002, ST SWEEPING- 272879 6/30/2020 SPEEDY GLASS-TACOMA, 4/29/2020 6005-1946614 $345.51 PD-VEHICLE WINDSHIELD REPAIR 272846 6/30/2020 MT VIEW LOCATING SERVICE3/30/2020 22351.20734 $212.50 PKM-LOCATING SVC 272861 6/30/2020 PIRTEK KENT. 4/6/2020 KE-T00000203 $382.43 FLT-VEHICLE MAINT 272897 6/30/2020 WASHDUP, LLC, 5/31/2020 366 $541.70 PD-05/20 CAR WASH SERVICES 272799 6/30/2020 EAGLE TIRE & AUTOMOTIVE (6/2/2020 1-39135 $867.49 PD-VEHICLE MAINT 272848 6/30/2020 MV TOWING LLC, 6/19/2020 17500 $77.00 PD-VEHICLE TOW 272796 6/30/2020 COPIERS NORTHWEST INC, 6/19/2020 INV2157547 $27.46 IT-AG17-182 PRINTER MAINT EXP: 272796 6/30/2020 COPIERS NORTHWEST INC, 6/19/2020 INV2157547 $62.25 IT-AG17-182 PRINTER MAINT EXP: 272796 6/30/2020 COPIERS NORTHWEST INC, 6/19/2020 INV2157547 $39.97 IT-AG17-182 PRINTER MAINT EXP: 63 Key Bank Page 25 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272880 6/30/2020 SYSTEMS FOR PUBLIC SAFEl6/18/2020 37768 $98.09 PD-VEHICLE REPAIR SVC 272880 6/30/2020 SYSTEMS FOR PUBLIC SAFE16/18/2020 37815 $49.05 PD-VEHICLE REPAIR SVC 272886 6/30/2020 TOTAL LANDSCAPE CORP, 5/31/2020 77465 $1,656 00 PKDBC - GROUNDS SERVCE 272886 6/30/2020 TOTAL LANDSCAPE CORP, 5/31/2020 77465 $165.60 Sales Tax 272830 6/30/2020 LARSEN SIGN CO., 5/29/2020 27107 $769,30 PD-VEHICLE GRAPHICS REPLACE SV 272857 6/30/2020 PETERSEN BROTHERS INC, 5/30/2020 18057031 $3,676.54 PWST-AG#18-079 ON -CALL GUARD R 272799 6/30/2020 EAGLE TIRE & AUTOMOTIVE (6/10/2020 1-39212 $58.24 FLT-VEHICLE MAINT 272799 6/30/2020 EAGLE TIRE &AUTOMOTIVE (6/4/2020 1-39131 $2,126.41 PD-VEHICLE MAINT 272817 6/30/2020 HTR GLASS & CONSTRUCTIO6/10/2020 20009-1 $2,750.00 PKDBC-AG20-018 DOOR & WINDOW M 272817 6/30/2020 HTR GLASS & CONSTRUCT1O6/10/2020 20013-1 $2,024.00 PKDBC-DOOR MAINT SVC 272839 6/30/2020 MACMOR INC, 6/12/2020 14318 $3.869.50 PWST/SWR-LANDSCAPE MAINTAG17- 272799 6/30/2020 EAGLE TIRE &AUTOMOTIVE (6/3/2020 1-39138 $935.62 PD-VEHICLE MAINT 272799 6/30/2020 EAGLE TIRE & AUTOMOTIVE (6/3/2020 1-39137 $806,38 PD-VEHICLE MAINT 272830 6/30/2020 LARSEN SIGN CO., 6/5/2020 27142 $675.89 PD-VEHICLE GRAPHICS REPLACE SV 272799 6/30/2020 EAGLE TIRE & AUTOMOTIVE (6/9/2020 1-39202 $41.75 FLT-VEHICLE MAINT 272799 6/30/2020 EAGLE TIRE & AUTOMOTIVE (6/8/2020 1-39183 $434 45 PD-VEHICLE MAINT' 272799 6/30/2020 EAGLE TIRE & AUTOMOTIVE (6/8/2020 1-39184 $92 78 PD-VEHICLE MAINT 272799 6/30/2020 EAGLE TIRE & AUTOMOTIVE (6/8/2020 1-39187 $42.30 FLT-VEHICLE MAINT 272799 6/30/2020 EAGLE TIRE &AUTOMOTIVE (6/8/2020 1-39190 $96 71 PD-VEHICLE MAINT 272799 6/30/2020 EAGLE TIRE &AUTOMOTIVE (6/8/2020 1-39191 $346.74 FLT-VEHICLE MAINT 272873 6/30/2020 SCARFF FORD, 6/3/2020 24522 $2,698,00 PD-VEHICLE MAINT SVC 272799 6/30/2020 EAGLE TIRE &AUTOMOTIVE (6/5/2020 1-39157 $689.00 PD-VEHICLE MAINT 272864 6/30/2020 PRO TOUCH AUTO INTERIOR 6/5/2020 48972 $456.50 PD-CAR 5891 DETAIL 272799 6/30/2020 EAGLE TIRE & AUTOMOTIVE (6/4/2020 1-39153 $42.30 PD-VEHICLE MAINT 272873 6/30/2020 SCARFF FORD, 6/15/2020 25329 $616.51 PD-VEHICLE MAINT SVC 272864 6/30/2020 PRO TOUCH AUTO INTERIOR 6/17/2020 48998 $165.00 PD-CAR 5211 DETAIL Key Bank Page 26 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272830 6/30/2020 LARSEN SIGN CO., 6/16/2020 27177 $769.30 PD-VEHICLE GRAPHICS INSTALL SV 272864 6/30/2020 PRO TOUCH AUTO INTERIOR 6/11/2020 48986 $165.00 PD-CAR 6263 DETAIL 272799 6/30/2020 EAGLE TIRE &AUTOMOTIVE (6/13/2020 1-39255 $82.45 FLT-VEHICLE MAINT 272796 6/30/2020 COPIERS NORTHWEST INC, 6/12/2020 INV2154891 $268.63 IT-06/20 NASP05214 COPIER MAIN 272796 6/30/2020 COPIERS NORTHWEST INC, 6/12/2020 INV2154891 $300.00 IT-06120 NASP05214 COPIER MAIN 272796 6/30/2020 COPIERS NORTHWEST INC, 6/12/2020 INV2154891 $1,000 00 IT-06/20 NASP05214 COPIER MAIN 272884 6/30/2020 THUNDERING OAK ENTERPRI6/17/2020 10519 $990.00 PKM-AG19-115 TREE SVC AGREEMEN 272830 6/30/2020 LARSEN SIGN CO, 6/16/2020 27178 $769,30 PD-VEHICLE GRAPHICS INSTALL SV 272777 6/30/2020 ADVANCED SAFETY & FIRE S16/16/2020 280216 $795,30 PD-ANNUAL SVC EXTINGUISHER 272864 6/30/2020 PRO TOUCH AUTO INTERIOR 6/15/2020 48994 $165 00 PD-CAR 5201 DETAIL 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/9/2020 1-39205 $42.30 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/9/2020 1-39208 $42.30 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE &AUTOMOTIVE (6/8/2020 1-39182 $888.93 PD-VEHICLE MAINT 272992 7/15/2020 PIRTEK KENT, 5/13/2020 KE-T00000424 $376.94 FLT-VEHICLE MAINT 273025 7/15/2020 THUNDERING OAK ENTERPR14/21/2020 10430 $1,650.00 PKM-AG19-115 TREE SVC AGREEMEN 273025 7/15/2020 THUNDERING OAK ENTER PRI4/21/2020 10431 $1,705 00 PKM-AG19-115 TREE SVC AGREEMEN 273025 7/15/2020 THUNDERING OAK ENTERPRI4/21/2020 10432 $1,870 00 PKM-AG19-115 TREE SVC AGREEMEN 273025 7/15/2020 THUNDERING OAK ENTERPRI4/21/2020 10433 $2,090 00 PKM-AG19-115 TREE SVC AGREEMEN 272974 7/15/2020 MACDONALD MILLER SERVIC4/1/2020 PM098534 $6,875.00 CHB/FWCC-HVAC SVC- 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/16/2020 1-39279 $359.90 PD-VEHICLE MAINT 272935 7/15/2020 EAGLETIRE &AUTOMOTIVE (6/16/2020 1-39280 $187.50 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/15/2020 1-39262 $245.20 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/15/2020 1-39264 $148 15 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/17/2020 1-39292 $408 13 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/17/2020 1-39294 $172.98 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/22/2020 1-39342 $940 37 PD-VEHICLE MAINT 65 Key Bank Page 27 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/20/2020 1-39314 $1,586.21 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE &AUTOMOTIVE (6/20/2020 1-39333 $42.30 FLT-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE &AUTOMOTIVE (6/20/2020 1-39336 $1,289 16 FLT-VEHICLE MAINT 272921 7/15/2020 CAR WASH ENTERPRISES, 6/18/2020 MAY 2020 $256.00 PD-MAY 2020 VEHICLE WASHES 272953 7/15/2020 HOME DEPOT-DEPT 32-250076/11/2020 5072908 $55.66 PWST-REPAIR & MAINT SUPPLIES 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/12/2020 1-39241 $72.60 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/12/2020 1-39247 $144.58 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE &AUTOMOTIVE (6/12/2020 1-39248 $212.51 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE &AUTOMOTIVE (6/22/2020 1-39352 $71 70 PD-VEHICLE MAINT 273002 7/15/2020 SECOMA FENCE INC, 6/22/2020 15023 $3,787.00 SWM-REPAIR FENCE ON CITY PROPE 273002 7/15/2020 SECOMA FENCE INC, 6/22/2020 15023 $378.70 Sales Tax 272916 7/15/2020 ARC DOCUMENT SOLUTIONS 6/22/2020 2329903 $109.73 IT-06/20 MPS PLOTTER WORK ORDE 272935 7/15/2020 EAGLE TIRE &AUTOMOTIVE (6/25/2020 1-39378 $536.46 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/26/2020 1-39395 $992,00 FLT-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE &AUTOMOTIVE (6/26/2020 1-39396 $344.27 PD-VEHICLE MAINT 272995 7/15/2020 PRO TOUCH AUTO INTERIOR 6/25/2020 49115 $165.00 PD-CAR 6402 DETAIL 272947 7/15/2020 GREENPOINT LANDSCAPING 6/25/2020 58454 $1.567.51 FWCC-AG19-119 LANDSCAPE MAINT 272960 7/15/2020 KING COUNTY RADIO, 6/29/2020 00451279 $370.70 IT -RADIO MAINT/REPAIR 272935 7/15/2020 EAGLE TIRE &AUTOMOTIVE (6/29/2020 1-39318 $23.10 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/29/2020 1-39425 $42.30 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE &AUTOMOTIVE (6/29/2020 1-39430 $23.10 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE &AUTOMOTIVE (6/29/2020 1-39434 $4Z30 PD-VEHICLE MAINT 272935 7/15/2020 EAGLETIRE &AUTOMOTIVE (6/23/2020 1-39355 $42.30 PD-VEHICLE MAINT 273021 7/15/2020 TERMINIX, 6/23/2020 397876572 $97.90 FWCC-PEST CONTROL 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/24/2020 1-39373 $42.30 PD-VEHICLE MAINT 272966 7/15/2020 LARSEN SIGN CO., 6/23/2020 27213 $769.30 PD-VEHICLE GRAPHICS REPLACE SV Key Bank Page 28 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/23/2020 1-39356 $369,62 PD-VEHICLE MAINT 272989 7/15/2020 PAVEMENT MAINT OF WA LLC7/2/2020 AG20-070 #1 $115,248,00 PWST-AG20-070 2020 PAVEMENT RE 273006 7/15/2020 SMS CLEANING, 7/6/2020 Fed Way-0620 $4,635 07 CHB/PKM-AG20-022 JANITORIAL SV 273006 7/15/2020 SMS CLEANING, 7/6/2020 Fed Way-0620 $3,179 93 CHB/PKM-AG20-022 JANITORIAL SV 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/10/2020 1-39218 $42,30 PD-VEHICLE MAINT 273018 7/15/2020 SYSTEMS FOR PUBLIC SAFET6/30/2020 37880 $470.89 PD-VEHICLE REPAIR SVC 273018 7/15/2020 SYSTEMS FOR PUBLIC SAFE16/30/2020 37919 $123.78 PD-VEHICLE REPAIR SVC 273026 7/15/2020 TOTAL LANDSCAPE CORPOR,6/30/2020 77857 $1,900.80 PKDBC-AG19-224 LANDSCAPE MAINT 272985 7/15/2020 NORTHWEST PLAYGROUND, 7/1/2020 46712 $4,232 00 PK/ADM/PL: 60 CUBIC YARDS OF W 272985 7/15/2020 NORTHWEST PLAYGROUND, 7/1/2020 46712 $423.20 Sales Tax 272933 7/15/2020 DMX LLC DBA MOOD MEDIA, 7/1/2020 55525611 $97.56 IT-07120 MEDIA SERVICES RETAINAGE PAYABLE $32,700.39 272944 7/15/2020 FIELDTURF USA INC, 7/7/2020 AG19-135 RETAINAGE $32,700.39 PARKS-AG19-135 RETAINAGE RELEA ROAD SVCS/PERMITS-INTGVT $140,774.45 272894 6/30/2020 WA STATE DEPT OF TRANSPC6/15/2020 RE 41 JZ0491 L007 $269 34 PW-PROJECT JZ0491 FEES 272959 7/15/2020 KING COUNTY FINANCE DIVIS4/30/2020 105157-105163 $11,654.65 PW-RSD FW PJ#105157-105163 272959 7/15/2020 KING COUNTY FINANCE DIVIS4/30/2020 105157-105163 $2,250.83 PW-RSD FW PJ#105157-105163 272959 7/15/2020 KING COUNTY FINANCE DIVIS4/30/2020 105157-105163 $2,704.37 PW-RSD FW PJ#105157-105163 272959 7/15/2020 KING COUNTY FINANCE DIVIS4/30/2020 105157-105163 $1,588.28 PW-RSD FW PJ#105157-105163 272959 7/15/2020 KING COUNTY FINANCE DIVIS4/30/2020 105177-105180 $6.293.40 PW-RSD FW PJ#105177-105180 272959 7/15/2020 KING COUNTY FINANCE DIVIS4/30/2020 105254-105285 $48,395.34 PW-RSD FW PJ#105254-105285 272959 7/15/2020 KING COUNTY FINANCE DIVIS3/31/2020 104669-104674 $5,936.87 PW-RSD FW PJ#104669-104674 272959 7/15/2020 KING COUNTY FINANCE DIVIS3/31/2020 104695-104698 $18,971.58 PW-RSD FW PJ#104695-104698 272959 7/15/2020 KING COUNTY FINANCE DIVIS3/31/2020 104771-104796 $42,709-79 PW-RSD FW PJ#104771-104796 SALES TAX PAYABLE $-1,258.41 625203485 6/25/2020 WA STATE REVENUE DEPART6/25/2020 601-223-5385 $-1,258.41 FI-05/20 REMIT SALES TAX DBC SALES TAX PAYABLE-RECREAT $74.45 625203485 6/25/2020 WA STATE REVENUE DEPART6/25/2020 601-223-5385 $74.45 FI-05/20 REMIT SALES TAX FWCC 67 Key Bank Page 29 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total SBCC SURCHARGE $388.50 272895 6/30/2020 WA STATE -STATE R EVEN U ES,6/19/2020 MAY 2020 $388.50 FI-05/20 SBCC SURCHARGE FEES SCHOOL IMPACT FEES $5,035.00 272809 6/30/2020 FEDERAL WAY SCHOOL DISTf6/19/2020 SIF-MAY 2020 $5,035.00 FI-MAY 2020 SCHL IMPACT FEE SEWER BILLINGS $1,067.83 272828 6/30/2020 LAKEHAVEN UTILITY DISTRICT6/17/2020 899802 $31 44 PKM-05/20 2410 312TH ST S BEAC 272828 6/30/2020 LAKEHAVEN UTILITY DISTRIC'6/17/2020 824102 $62 88 PKM-05/20 30000 14TH AVE S M#5 272828 6/30/2020 LAKEHAVEN UTILITY DISTRIC'6/17/2020 888103 $13672 CHB-05/20 31132 28TH AVE S M#9 272828 6/30/2020 LAKEHAVEN UTILITY DISTRICT/17/2020 888302 $47.89 PKM-05/20 31104 28TH AVE S M#1 272828 6/30/2020 LAKEHAVEN UTILITY DISTRICT6/17/2020 101 $31 44 PKM-05/20 31132 28TH AVE S #A 272828 6/30/2020 LAKEHAVEN UTILITY DISTRIC-6/17/2020 2426304 $31.44 PAEC-05/20 2141 314 ST. S. #08 272828 6/30/2020 LAKEHAVEN UTILITY DISTRICT6/11/2020 460602 $34.73 PKM-05/20 2645 312TH ST S #143 272828 6/30/2020 LAKEHAVEN UTILITY DISTRICT/11/2020 3671801 $38.02 PKM-05/20 31600 20TH AVE S. M# 272963 7/15/2020 LAKEHAVEN UTILITY DISTRICT/6/2020 3075401 $31 44 PKM-06/20 1095 324TH ST S #985 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 3405101 $34 73 CHB-06/20 600 S 333RD ST#6239 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 2926501 $31.44 PKM-06/20 33914 19TH AVE SW M# 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 3075201 $31 44 PKM-06/20 1095 324TH ST S M#97 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 3075301 $44 60 PKM-07/20 1095 324TH ST S #985 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 101002 $61 05 PKM-06/20 BROOKLAKE MAIN HALL 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 2865803 $31.44 PKM-05/01-07/06 726 356 ST S M 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 2865902 $31.44 PKM-5/1-7/6 729 356 ST S. CRE 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 2913103 $320 96 CHB-06/20 33325 8TH AVE S M#94 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 2926402 $3473 PKM-06/20 33914 19TH AVE SW #9 SMALL TOOLS - SHOP $2,428.80 273007 7/15/2020 SONSRAY MACHINERY LLC, 6/23/2020 P39794-08 $969 54 PWST-MAINT SUPPLIES 273029 7/15/2020 TRINITY ACE HARDWARE, 6/25/2020 116484 $17.59 CHB-SUPPLIES 272940 7/15/2020 ERNIE'S FUEL STOPS (DBA), 5/15/2020 459503CT $66 67 PKM-VEHICLE FUEL 272953 7/15/2020 HOME DEPOT-DEPT 32-2500716/9/2020 7072709 $221.99 SWM-REPAIR & MAINT SUPPLIES • Q Key Bank Page 30 of 33 Check No. Date Vendor Invoice Date Invoice Description AmOUntGLTotal 272910 7/15/2020 AGRISHOP INC; 6/17/2020 61228/1 $1,153.01 SWIM -EQUIPMENT PARTS & REPAIRS STATE PENSIONS - PIERS $3,634.94 272906 7/8/2020 WA STATE DEPT OF RETIREM3/1/2020 01382482 $3,634.94 SWM-EMPLOYER PORTION OF MEMB'S STONE & GRAVEL $2,081.93 272898 6/30/2020 WASHINGTON ROCK QUARRII6/8/2020 112511 $1,242.32 PKM-TRAIL MIX 273041 7/15/2020 WASHINGTON ROCK QUARRII6/20/2020 112996 $839,61 PKM-FAIRWAY TOP DRESSING SAN TAXES/ASSESSMENTS-INTERGOVT $9,513.54 625203485 6/25/2020 WA STATE REVENUE DEPART6/25/2020 601-223-5385 $236.36 FI-05/20 REMIT SALES TAX DBC 625203485 6/25/2020 WA STATE REVENUE DEPART6/25/2020 601-223-5385 $9,513.54 FI-05/20 REMIT SALES TAX SWIM 625203485 6/25/2020 WA STATE REVENUE DEPART6/25/2020 601-223-5385 $-236.36 FI-05/20 REMIT SALES TAX DBC TIRES $4,713.51 272833 6/30/2020 LES SCHWAB TIRE CTRS OF \6/5/2020 37800472390 $53,89 FLT-TIRES 272799 6/30/2020 EAGLE TIRE &AUTOMOTIVE (6/4/2020 1-39131 $714.59 PD-VEHICLE MAINT 272799 6/30/2020 EAGLE TIRE &AUTOMOTIVE (6/3/2020 1-39147 $714.60 PD-TIRES 272935 7/15/2020 EAGLE TIRE &AUTOMOTIVE (6/17/2020 1-39294 $771.45 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE &AUTOMOTIVE (6/1712020 1-39292 $470.66 PD-VEHICLE MAINT 272935 7/15/2020 EAGLE TIRE &AUTOMOTIVE (6/17/2020 1-39278 $1,197.66 PD-TIRES 272935 7/15/2020 EAGLE TIRE & AUTOMOTIVE (6/23/2020 1-39355 $369.40 PD-VEHICLE MAINT 272970 7/15/2020 LES SCHWAB TIRE CTRS OF 07/2020 37800477069 $421.26 FLT-VEHICLE MAINT TOPSOIL $1,481.47 272836 6/30/2020 LLOYD ENTERPRISES INC, 3/16/2020 3317687 $368.65 PKM-INFIELD MIX-RET 272836 6/30/2020 LLOYD ENTERPRISES INC, 3/17/2020 3317717 $1,112.82 PKM-INFIELD MIX-RET TRANSPORTATION EQUIPMENT $150,429.18 272803 6/30/2020 EXCEL SUPPLY COMPANY, IN(3/2612020 119571 $303 57 FLT-SAFETY SUPPLIES 272902 6/30/2020 WESTERN EQUIPMENT DISTR4/15/2020 8057181-00 $743,62 Sales Tax 272902 6/30/2020 WESTERN EQUIPMENT DISTR4/15/2020 8057181-00 $7,436.16 FLT-TORO ZMASTER 48" MOWER W/R 272880 6/30/2020 SYSTEMS FOR PUBLIC SAFEl6/11/2020 37380 $18,481.17 PD-VEHICLE REPAIR SVC 272880 6/30/2020 SYSTEMS FOR PUBLIC SAFE16/11/2020 37393 $16,097.44 PD-VEHICLE REPAIR SVC 272803 6/30/2020 EXCEL SUPPLY COMPANY, IN(6/16/2020 122920 $360.37 FLT-SAFETY SUPPLIES • E Key Bank Page 31 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGLTotal 272880 6/30/2020 SYSTEMS FOR PUBLIC SAFEl6/18/2020 37329 $6,246.23 PD-VEHICLE REPAIR SVC 272816 6/30/2020 HP INC., 5/29/2020 9010342123 $22,110.06 IT-PD-GETAC B300G7 INTEL 15-82 272816 6/30/2020 HP INC., 5/29/2020 9010342123 $2,211.01 Sales Tax 272946 7/15/2020 GRAINGER INC, 6/15/2020 9561589699 $91.02 FLT-FACILITY MAINT SUPPLIES 272908 7/15/2020 ADVANCE AUTO PARTS, 6/16/2020 13144-392542 $5.21 FLT-MAINT PARTS 273038 7/15/2020 WA STATE DEPT OF LICENSIN6/17/2020 L0103961420 $247 00 FLT-TURCKS TITLE 272927 7/15/2020 COLUMBIA FORD, 6/12/2020 3-1-1260 $53,112.00 FLT-Ford F-450 to repl Truck 1 272927 7/15/2020 COLUMBIA FORD, 6/12/2020 3-1-1260 $4,461.41 Sales Tax 273031 7/15/2020 TRUE NORTH EQUIPMENT IN(5/6/2020 01E00077 $18,522.91 FLT-QUICKVIEWAIR HD SYSTEM, I UREA $34,882.68 272838 6/30/2020 LTI, INC, 5/4/2020 SLT-7002033 $34,882.68 PWST-BULK SALT/SNOW MELT WASTE DISPOSAL BILLINGS $595.62 272836 6/30/2020 LLOYD ENTERPRISES INC, 3/24/2020 3317884 $143,60 PKM-CLEAN CONCRETE 272836 6/30/2020 LLOYD ENTERPRISES INC, 6/15/2020 3319347 $164.53 PKM-DUMP ASPHALT 272824 6/30/2020 KING COUNTY FINANCE DIVIS5/31/2020 105998 $90 80 PWST-05/20 ALGONA TS R#SWD-722 272975 7/15/2020 MILES RESOURCES LLC, 6/8/2020 308541 $3 96 SWM-WASTE ASPHALT 272971 7/15/2020 LLOYD ENTERPRISES INC, 6/3/2020 3319107 $30 00 SWM-DUMP ASPHALT 272971 7/15/2020 LLOYD ENTERPRISES INC, 6/18/2020 3319422 $162.73 SWM-DUMP ASPHALT WATER BILLINGS $13,310.96 272828 6/30/2020 LAKEHAVEN UTILITY DISTRIC'6/17/2020 101 $27 18 PKM-05/20 31132 28TH AVE S #A 272828 6/30/2020 LAKEHAVEN UTILITY DISTRIC'6/17/2020 2426604 $27.18 PAEC-05/20 2141 314 ST. S. IRR 272828 6/30/2020 LAKEHAVEN UTILITY DISTRIC'6/17/2020 2446104 $14.10 PAEC-05/20 2141 314 ST. S. DET 272828 6/30/2020 LAKEHAVEN UTILITY DISTRIC'6/17/2020 822402 $330.64 PKM-05/20 30009 16TH AVE S IRR 272828 6/30/2020 LAKEHAVEN UTILITY DISTRIC'6/17/2020 824102 $168 16 PKM-05/20 30000 14TH AVE S M#5 272828 6/30/2020 LAKEHAVEN UTILITY DISTRIC16/17/2020 2814401 $27.18 PKM-05/20 2645 312TH IRR/ANNEX 272828 6/30/2020 LAKEHAVEN UTILITY DISTRIC'6/11/2020 460602 $170.31 PKM-05/20 2645 312TH ST S #143 272828 6/30/2020 LAKEHAVEN UTILITY DISTRIC'6/11/2020 3586001 $27.18 PKM-05120 31531 1STAVE S M#42 70 Key Bank Page 32 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGLTotal 272828 6/30/2020 LAKEHAVEN UTILITY DISTRIC'6/11/2020 3671801 $112.04 PKM-05/20 31600 20TH AVE S. M# 272828 6/30/2020 LAKEHAVEN UTILITY DISTRICT/11/2020 1941803 $584,62 PKM-05/20 31600 20 AVE S M#152 272828 6/30/2020 LAKEHAVEN UTILITY DISTRICT/11/2020 2049903 $27.18 PKM-05/20 31531 1STAVE S M#59 272827 6/30/2020 LAKEHAVEN UTILITY DISTRICT/9/2020 6314018 $227.67 PAEC-UTILITIES 272881 6/30/2020 TACOMA PUBLIC UTILITIES, 6/5/2020 100048250 $107.39 PKDBC-04/25/20-05/26/20 PUBLIC 272881 6/30/2020 TACOMA PUBLIC UTILITIES, 6/5/2020 100048250 $1,181.28 PKDBC-04/25/20-05/26/20 PUBLIC 272828 6/30/2020 LAKEHAVEN UTILITY DISTRICT/17/2020 924602 $27.18 PKM-05/20 2301 S 292ND ST IRR 272828 6/30/2020 LAKEHAVEN UTILITY DISTRIC6/17/2020 896402 $27,18 PKM-05/20 2410 312TH ST #89640 272828 6/30/2020 LAKEHAVEN UTILITY DISTRICT/17/2020 899802 $168.16 PKM-05/20 2410 312TH ST S BEAC 272828 6/30/2020 LAKEHAVEN UTILITY DISTRICT/17/2020 888302 $37 93 PKM-05/20 31104 28TH AVE S M91 272828 6/30/2020 LAKEHAVEN UTILITY DISTRICT/17/2020 888103 $126 20 CHB-05/20 31132 28TH AVE S M#9 272828 6/30/2020 LAKEHAVEN UTILITY DISTRICT/17/2020 2426304 $168.16 PAEC-05/20 2141 314 ST. S. #08 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC6/11/2020 3278301 $27.18 PWST-05/20 32009 23 AVE S IRR 272963 7/15/2020 LAKEHAVEN UTILITY DISTRICT/11/2020 3336101 $183.21 PW-05/20 31026 PACIFIC HWY S 1 272963 7/15/2020 LAKEHAVEN UTILITY DISTRICT/11/2020 3364101 $109.89 PWST-04/20 1618 S 288TH ST IRR 272963 7/15/2020 LAKEHAVEN UTILITY DISTRICT/11/2020 3488801 $96.02 PWST-05/20 31802 21STAVE S I 272963 7/15/2020 LAKEHAVEN UTILITY DISTRICT/11/2020 3540201 $27.18 PWST-05/20 29627 PACIFIC HWY S 272963 7/15/2020 LAKEHAVEN UTILITY DISTRICT/11/2020 3545101 $27.18 PWST-05/20 29102 PACIFIC HWY S 273019 7/15/2020 TACOMA PUBLIC UTILITIES, 7!7/2020 100048250 $148,71 PKDBC-05/27/20-06/24/20 PUBLIC 273019 7/15/2020 TACOMA PUBLIC UTILITIES, 7/7/2020 100048250 $1,635.86 PKDBC-05/27/20-06/24/20 PUBLIC 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 2926402 $179.96 PKM-06/20 33914 19TH AVE SW #9 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 2922203 $14.10 CHB-06/20 33325 8TH AVE S M#93 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 2922503 $511 94 CHB-06/20 33325 8TH AVE S M#94 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 2913103 $357.36 CHB-06/20 33325 8TH AVE S M#94 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 101103 $20929 PKM-06/20 630 356TH ST M#90704 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 3075301 $176 76 PKM-07/20 1095 324TH ST S #985 71 Key Bank Page 33 of 33 Check No. Date Vendor Invoice Date Invoice Description AmountGL Total 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 2926501 $177.81 PKM-06/20 33914 19TH AVE SW M# 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 2957001 $27 18 PKM-06/20 1095 324TH ST S M#64 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 3050801 $4,053.74 PKM-06/20 1095 324TH ST S M910 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 3075201 $168 16 PKM-06/20 1095 324TH ST S M#97 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 3499201 $27 18 CHB-06/20 2220 S 333RD ST#8293 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 3552401 $27 18 PWST-06/20 35503 PACIFIC HWY S 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 3568601 $44.08 PKM-06/20 34915 4TH AVE S A 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 3753001 $185.44 PKM-06/20 550 SW CAMPUS DR M#4 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 99902 $27 18 PKM-06/20 411 348TH ST S M#995 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 3075401 $166.16 PKM-06/20 1095 324TH ST S #985 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 3266301 $27.18 PKM-06/20 1540 SW 356TH ST#568 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 3405101 $59.55 CHB-06/20 600 S 333RD ST #6239 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 2573402 $27.18 PKM-06/20 34800 14 PL SW M#890 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/6/2020 101002 $46.53 PKM-06/20 BROOKLAKE MAIN HALL 273019 7/15/2020 TACOMA PUBLIC UTILITIES, 7/2/2020 101177226 $412.69 PKM-05/01/20-06/30/20 DRINKING 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/1/2020 3481301 $118.49 PWST-05/20 SR 99 S 279TH TO S 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC7/1/2020 3540301 $109.89 PWST-05/20 28719 PACIFIC HWY S 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC'6/23/2020 3033601 $111.60 PKM-06/20 28159 24TH PL S M#97 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC'6/11/2020 482303 $27.18 PWST-05/20 28866 PACIFIC HWY S 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC'6/11/2020 482405 $27 18 PWST-05/20 28850 PACIFIC HWY S 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC'6/11/2020 3568101 $120.64 PWST-04/20 30799 PAC HWY IRRIG 272963 7/15/2020 LAKEHAVEN UTILITY DISTRIC'6/11/2020 3621801 $27.18 PWST-05/20 1401 SW 312TH STREE Total $3,246,333.43 06/19/2020 CW-PAYROLL VOUCHERS 06/01-06/15 $1,477,111.38 07/02/2020 CW-PAYROLL VOUCHERS 06/16-06/30 $2,073.560.33 $3,550,671.71 72 COUNCIL MEETING DATE: August -11, 2020 ITEM #: CITY OF FEDERAL WAY CITY COUNCIL AGENDA BILL SUBJECT: JUNE 2020 MONTHLY FINANCIAL REPORT POLICY QUESTION: Should the Council approve the June 2020 Monthly Financial Report? COMMITTEE: Finance, Economic Development and Regional Affairs Committee MEETING DATE:July 28, 2020 CATEGORY: ® Consent ❑ Ordinance ❑ Public Hearing ❑ City Council Business ❑ Resolution ❑ Other STAFF REPORT BY: A& Ariwoola, Finance Director DEPT: Finance Attachments: • June 2020 Monthly Financial Report Options Considered: 1. Approve the June 2020 Monthly Financial Report as presented 2. Deny approval of the June 2020 Monthly Financial Report and provide direction to staff. MAYOR'S RECOMMENDATION: Mayor recommends approval of Option 1. MAYOR APPROVAL: (DIRECTOR APPROVAL: ;-C- COMMITTEE RECOMMENDATION: I move to forward the June 2020 Monthly Financial Report to the August ( j 2020 consent agenda for approval. Committee Chair Committee Member Committee Member PROPOSED COUNCIL MOTION: "I move approval of the June 2020 Monthly Financial Report." (BELOW TO BE COMPLETED BY CITY CLERKS OFFICE) COUNCIL ACTION: ❑ APPROVED COUNCIL BILL # ❑ DENIED 1ST reading ❑ TABLED/DEFERRED/NO ACTION Enactment reading ❑ MOVED TO SECOND READING (ordinances only) ORDINANCE # REVISED — 08/12/2010 RESOLUTION # 73 CRY OF <- A Federal Way June 2020 Monthly Financial Report - Highlights The following are highlights of the June 2020 Monthly Financial Report. Detailed financial information can be found in the June 2020 Monthly Financial Report detail. Notable Areas 1. Sales Tax is $0.28M or 4.4% below 2020 year-to-date budget, and $0.01M or 0.2% below 2019 year-to- date collections. 2. CD Permits & Fees is $0.7M or 39.4% below 2020 year-to-date budget and $1.2M or 54.3% below 2019 year-to-date collections. 3. Utility Tax is $0.27M or 5.2% below 2020 year-to-date budget, and $0.04M or 0.9% below 2019 year-to- date collections. 4. Business License Fees are 88K or 32.6% above 2020 year-to-date budget, and $181K or 102.8% above 2019 year-to-date collections. Business licensing has increased due to the City going live with the State system. Fees received for the first year of business licenses is pro -rated to the businesses State anniversary date, and therefore the revenue will grow more evenly throughout the year. General &.Street Fund Summar Revenues are below the year-to-date budget by $1.3M or 6.3%. Property tax, Sales tax, criminal justice sales tax admissions tax, gambling tax, court and probation revenue, CD permits and fees, passport agency fees, parks and general recreation fees, and interest earnings are primarily responsible for the decrease in revenues. Leasehold tax, PW permits and fees, franchise fees, and business license fees are above the year-to-date budget. Total General & Street Fund expenditures are below the year-to-date budget by $2.1M or 9.3%. Jail is under the year-to-date budget by $838K or 49.1% primarily due to having lower average daily population (ADP) of inmates. The budgeted ADP is 70, but actual ADP is 38.6 for January, 43.6 for February, 39.8 for March, 29.5 for April, and 20.0 for May. June ADP numbers will be available in the July report. Property tax is above 2019 year-to-date actual by $18K or 0.3%, but below 2020 year-to-date budget by $155K or 2.6%. Sales tax is below 2019 year-to-date actual by $0.01M or 0.2%, and below 2020 year-to-date budget by $0.28M or 4.4%. Additionally, criminal justice sales tax collected county -wide is below 2019 year-to-date actual by $98K or 8.2%, and below 2020 year-to-date budget by $87K or 7.3%. Community Development permits and fees are below the 2019 year-to-date actual by $1.2M or 54.3%, and below 2020 year-to-date budget by $0.7M or 39.4%. This is primarily due to receiving less large project permit fees in 2020, and construction stopping due to Covid-19. In 2019, two large permit and review fees were collected in February last year for Davita and Federal Way premier storage. We do not have as many large projects scheduled in 2020 as 2019. Court revenue is below 2019 year-to-date actual by $88K or 17.3%, and below 2020 year-to-date budget by $113K or 21.0%. This is primarily due to a decrease in traffic and non -parking infraction enforcement. Probation revenue is below 2019 year-to-date actual by $38K. As of the end of June, probation revenue is $116K less than expenditures, although the probation division was intended to be self-sufficient. New state law prevents the City from aggressive collection of both court and probation fees from indigent individuals; most individuals in our courts are identified as indigents. Admissions Tax was a new source of revenue in 2017. It is being paid monthly and as of the end of June, the City has collected $61K, which is $137K below actuals last year. This is due to the AMC movie theater being purchased by Sound Transit and closing, and a decrease in tax from other businesses due to the Covid-19 pandemic. Business License Fees is above 2020 year-to-date budget by $88K or 32.6%, and above 2019 year-to-date actual by $181K or 102.8%. The City went live with the State system on October 3, 2019. Using the State system allows us to see or find businesses that are located in Federal Way with a State license but without a city license. We have professionally and aggressively gone after these businesses and it is paying off. Park & General Recreation Fees is below 2020 year-to-date budget by $262K or 60.9%, and $284K or 62.9% below 2019 year-to-date actuals. This is primarily due to parks facilities closing due to Covid-19 on March 12, 2020. 74 Expenditures are below 2020 year-to-date budget by $1.94M or 20.5% and are primarily due to timing of payments in Arterial Streets Overlay, Hotel/Motel Lodging Tax, Traffic Safety, Utility Tax Prop 1, Surface Water Management, and the closure of Federal Way Community Center, Performing Arts & Event Center due to Covid-19. Utility tax revenues received year-to-date as reported on the monthly financial report totals $5.OM and is $0.04M or 0.9% below 2019 year-to-date actual and $0.27M or 5.2% below 2020 year-to-date budget. The following is the comparison of 2020 year-to-date actual to 2019 year-to-date actual utility taxes by category: Electricity — current year-to-date decrease by $82K or 3.6% Gas — current year-to-date increase by $103K or 13.5% Solid Waste — current year-to-date increase by $11K or 2.4% Cable — current year-to-date decrease by $13K or 1.8%. Cellular — current year-to-date decrese by $58K or 15.8%. Federal Way Community Center 2020 year-to-date revenues received of $377K is below 2020 year-to-date budget by $560K or 59.8%, and below 2019 year-to-date actual by $486K or 56.3%. 2020 year-to-date expenditures of $743K is below 2020 year-to-date budget by $360K or 32.7%, and below 2019 year-to-date actual by $420K or 36.1%. The ending fund balance of $1.1M is below the required reserve fund balance policy of $1.5M by $0.4M due to lower revenues at the Federal Way Community Center. Due to the Covid-19 pandemic the Community Center closed to the public on March 12, 2020. The full annual budgeted amount of utility tax subsidy has been transferred to the Federal Way Community Center fund for operations in the amount of $312K. Real estate excise tax 2020 year-to-date revenues of $IAM is below 2019 year-to-date actual by $747K or 35.4%, and below the 2020 year-to-date budget by $230K or 14.5%. In June, there were 124 taxable residential sales (total sales $48.3M / $238K tax), and two commercial sales (total sale $8.4M / $41K tax). Lakehaven Utility District The City signed an agreement with Lakehaven in 2016 for a 3.6% franchise fee, and in exchange the City will pay for the fire hydrant maintenance and street lights that were initially paid for by Lakehaven and charged to the citizens. The franchise fees received thru June amount to $498K; billings for fire hydrants and streetlights are $389K. The billings for fire hydrants are quarterly, and streetlights are monthly. Revenue from the franchise agreement is received monthly. The City extended the 7.75% utility tax to Water and Sewer services in 2018. The Council action was challenged in court and reached the Washington State Supreme Court. The Supreme Court decided in the City's favor and we are currently working with Lakehaven on the tax payments from March 2018 through June 2020. 75 C"" Federal Way June 2020 Monthly Financial Report - Detail GENERAL & STREET FUND SUMMARY 2019 1 2020 YFD Budget vs. Actual Fawrable/(Unfawrable) Annual Budget I Annual Actual YFD Actual Annual Budget YFD Budget YFD Actual $ % Beginning Fund Balance $11,662,052 $11,662,052 $11,662,052 $10,419,235 $10,419,235 $11,604,041 n/a n/a Revenues: Property Taxes 11,143,718 10,917,428 5,783,222 11,243,718 5,956,066 5,801,424 (154,642) -2.6% Sales Tax 15,555,486 15,908,863 6,180,166 15,949,755 6,447,994 6,166,732 (281,261) -4.4% CrininalJustice Sales Tax 3,027,361 3,056,010 1,205,957 3,027,361 1,194,651 1,107,650 (87,001) -7.3% Admissions Tax 798,312 827,537 198,184 806,513 193,149 61,391 (131,758) -682% Gambling Taxes 213,724 232,942 71,258 195,000 59,651 50,168 (9,483) -15.90z6 State Shared Revenue 3,157,507 3,174,111 1,198,677 3,022,0001 1,141,234 1,138,625 (2,608) -0.2% Leasehold Tax 6,000 5,898 1,504 6,0001 1,530 4,285 2,755 180.1% CourtRevenue 1,012,742 1,015,193 511,384 11012,742 535,629 423,057 (112,571)1-21.0% Probation Revenue 188,459 160,622 90,102 188,459 94,230 52,017 (42,212) -44.8% CD Permits & Fees 3,859,114 4,546,432 2,292,091 3,395,775 1,730,416: 1,048,112 (682,304) -39.4% PW Permits & Fees 700,752 1,125,969 304,733 700,752 232,063: 332,848 100,785 43.4% Business License Fees 531,491 406,666 175,908 622,000 269,052 356,781 87,729 32.6% Franchise Fees 1,186,578 1,092,423 342,923 1,198,444 263,943 263,943 - 0.0% Lakehaven Franchise Fees 848,580 900,380 375,158 848,580 353,575 498,006 144,431 40.8% Passport Agency Fees . 68,000 89,645 50,811 68,500 38,826 19,845 (18,981) -48.9% Park & General Recreation Fees 1,112,418 1,105,288 451,851 1,050,000 429,249 167,744 (261,505) -60.9% Police Services 1,424,766 1,585,141 196,000 1,424,766 431,267 431,267 - 0.0% Admin/Cash Management Fees 375,896 375,8961 187,948 375,896 187,948 187,948 0 0.0% Interest Earnings 175,616 241,881 92,696 168,216 64,466 43,705 (20,760) -32.2% Miscellaneous/Other/Grants 1,248,537 1,273,177 381,859 1,027,175 308,076 526,107 218,0311 70.8% Total Re-,enues 46,635,058 48,041,503 20,092,431 46,331,652 19,933,013 18,681,655 (1,251,358) -63% Expenditures: City Council 493,462 422,167 255,752 503,643 305,111 287,437 17,674 5.8% Mayor's Office 1,465,673 1,497,282 748,439 1,520,881 760,441 733,814 26,627 3.5% Community Development 2,699,112 2,546,3721 1,299,552 2,796,556 1,427,235 1,223,039 204,196 14.3% Economic Development 415,973 340,503 112,102 415,973 207,987 172,139 35,848 17.2% Human Services 966,388 871,103 464,335 957,307 478,654 398,071 80,583 16.8% Finance 1,153,267 1,045,013 518,855 1,269,595 630,361 F 513,161 117,200 18.6% Hamm Resources/City Clerk 1,171,179 1,113,978 404,461 1,028,865 514,433 ' 416,875 97,557 19.0% Law 1,550,895 1,607,291 789,287 1,685,403 F 827,645 742,768 84,877 10.3% Municipal Court 1,384,797 1,403,941 682,277 1,399,681 699,841 663,962 35,879 5.1% Probation 355,508 348,498 164,811 367,468 173,782 167,936 5,846 3.4% Jail 5,964,972 5,932,095 2,953,550 3,428,950 1,707,251 869,501 837,750 49.1% Police 21,305,6931 21,225,938 10,325,838 21,592,505 10,796,253 10,664,236 132,017 1.2% Parks & Recreation 4,224,351 ' 4,231,231 1,865,885 4,096,474 1,741,001 1,714,180 26,821 1.5% Lakehaven Fire Hydrant/Street Light 955,947 871,984 448,815 955,947 477,974 389,048 88,926 18.6% Public Works 4,601,609 4,420,751 1,928,912 4,217,648 1,840,292 1,539,442 300,8501 16.3% Total Expenditures 48,708,826 47,878,147 22,962,871 46,236,896 22,588,258 20,495,609 2,092,649 93% Revenues o,.er/(under) Expenditures (2,073,768) 163,356 (2,870,440) 94,756 (2,655,244) (1,813,954) 841,291 31.7% Other Sources: Ongoing Transfers In: Traffic Safety for Operations 1,470,333 1,470,333 1,035,312 1,549,087 377,777 377,777 0.0% Utility Tax for Operations 8,058,122 5,713,801 2,922,751 8,030,881 3,327,572 3,327,572 0.0% Other Transfers In 549,199 40,000 - 508,000 43,000 43,000 - 0.0% Total Other Financing Sources 10 077 654 7,224,134 3,958,063 10,087,968 3,748,349 1 3,748,349 - 0.0% -Other Uses: Transfers Out/Other 3,349,243 5,897,461 1,963,898 5,481,602 369,570 2,904,861 5,134,249 1,640,867 F 5,940,719 2,970,360 1,640,867 2,970,360 - 0.0% 0.0% Non -Departmental Internal Service Charges Total Other Financing Uses 9,246,704 7,445,500 3,274,431 11,074,968 4,611,227 4,611,227 - 0.0% Total Fnding Fund Balance $10.419.234 $11.604.041 $ 9.475.243 $ 9526991 $ 6.901.113 $ 8,927,212 1 n/a n/a 76 DESIGNATED OPERATING FUNDS SUMMARY 2019 2020 YMBudgetvs.Actual Fawrable/Wa6wrable) Annual Budget Annual Actual YM Actual Annual Budget YID Budget YPD Actual S Beginning Fund Balance S 22.163,689 S 22.163.685 S 22,163.685 $ 20.551.068 $ 20.551.068 $ 24.959.751 n/a n/a Revenues: Utility Tax 9,108,135 8,593,469 3,880,539 9,153,135 4,070,445 3,947,627 (222,817) -5.5% Utility Tax- Prop I Voter Package 2,675,991 2,508.615 1,134,010• 2,675,891 1,172,887 1,123,712 (49,175) -4.2% Affordable Housing Sales Tax - - 39.243 39.243 n/a Hotel/Motel Lodging Tax 300,000 292.986 109,010 300.000 104,611 69,126 L (35,485) -33.9% Real Estate Excise Tax 4,647,564 5,171,643 2,111,644 3,640,000 1,594,919 1,364,448 (230,471) -145% Property Tax- King Cc Expansion Levy 160,000 196,176 91,291 160,000 74,456 119,173 44,716 60.1% State Shared Revenue 539,000 552,996 215.948 539.000 210.482 187391 (23,091) -11.0% Traffic Safety (Red Light/School Zone) 3.802,000 3,577,248 1,932,350 3,802,000 2,053,756 1,307,541 (746,215) -36 3 % Federal Way Conumnity Center 1,968,351 1 1,748,651 962,772 1,940,875 936,332 376,781 (559,551) -59.81% Dumas Bay Centre Fund 938,751 925,917 480,896 765,251 401,856 128,346 (273,510) -68 1 % Performing Arts & Event Ctr Operations 1.059,967 1,259,655 172.687 1.307.592 653,796 342,944 (310,852) 47.5% Surface Water Management Fees 4.260,392 4,339,632 2,350,358 4,260,392 2,307,442 2,338,924 31,483 1.4% Refuse Collection Fees 413,496 421,101 206,006 437,560 214,057 224,525 10,468 4.9% Automation Fees 20,000 2,991 256 20,000 5,310 5,310 - 0.0% Interest Earnings _ 196,305 508,831 219,145 161,305 69,472 99,754 _ 30,283 - 43.6% Miscellaneous/Other/Gents/Contribution from SCORE 702,534 1,641,383 100.609 298.704 49,147 49,147 0.0% Total Revenues 30,792,386 31.741.294 13,867,520 29.461.705 13,918.966 11.623.991 (2,294,975) -16.5 % Fxpenditures: AfTerial. Sir"ts O%-SFLaX Pip ram 1,625,064 1. L025.921 1,515064 944.1141 419291 524.823 55.6% Solid Waste & Recycling 595.549 515.765 238300 58L800 290.9001 251.217 39,683 13.6% Hotel/Motel Lodging Tax 394,700 167,985 22,960 224.700 30,712 9.089 21,623 70 4% Traffic Safety (Red Light/School Zone) 2,586,203 2,571,099 1,157,767 2,640,639 1,189,081 1,074,270 114,811 9.7% Utility Tax Proposition 1 3,446,374 3,170,406 1,573,417 3,475,246 1,724,704 1,512,690 212,014 12.3% Debt Service (Debt & Admin Fee) 2,152,510 1.268,564 214,636 2,894,957 679,039 679,039 0.01% Federal Way Community Center 2314,036 2,456,184 1,163,116 2,333,150 1,102,889 742.744 360,145 327% Perf rming Arts & Event Ctr Operations 2,078,407 2,599,531 364,623 21249,835 1,124,918 989,358 235,559 20.90/c Technology Fund 15,986 - - n/a Dumas Bay Centre Fund 955,872 905,194 400,096 946,472 374,178 322,053 52,125 1390% Surface Water Management 4.295.628 3,909,935 1,827.896 4,224,061 1.974,750 1.598.259 376,491 191% ToDd Ependitures 20.460.330 19.201.008 r 7,988,731 20,985,924 9,435,283 7.498,010 1,937.273 20.5 % Revenues over/(under) Fxpenditures 10,332,057 12,540,286 5,878,789 8,475,781 1 4,483,683 4,125,981 (357,702) -8.0 % Other Sources: Ongoing Transfers In: Utility Taxfor DBC Oper/Reserves 23,000 - - 23,000 23,000 23,000 0 0% Utility Tax(GF for FW CC er/Reserves 387.000 38T000 270.863 312.000 312.000 312.000 0.0% Utih Tax/Gen Fund/REEF for Debt 813.473 2A 13.473 813.473 2,328.567 2,328567 2.328.567 0.0% Utility Taxto Strategic Reserve 44,570 44.570 n/a REEF for Arterial Streets Overlay 1,417,461 L648387 944570 1.013MO n/a REEF for Parks Reserve 45.000 45.000 45.000 0.00/1 Refun din -SCORE 13,982.290 12,723.952 n/a Utility Tax/GF for PAEC/Proc. from Sale of TP/SCORE Contr. 2,297 34 2,296,494 728,778 1.607 54 879,599 879399 0 0% Total Other Sources 18,965,133 19,213,866 2,757,684 5,328,821 3,588,166 3,588,166 0.0 % Other Uses: Ongoing Transfer Out: Traffic Safety (Red Light/School Zone) 1,560.333 1,560,333 1,035,312 1 1,549,087 377,777 377,777 - 0.0% Utility Taxto FWCCOper/Reserves 387,000 387,000 270,863 312,000 312,000 312,000 0.01% Utility Taxto DBC er/Reserves 23.000 23.000 23,000 23000 0.00% Utillity Taxto General/Street er/Dbt/Str Rsv/Bldg Fnd 8.058.122 7.513.801 2.922.751 &Q30881 3,327.572 3.327.572 0.0% REEF to Arterial Streets Overlav 1.013.000 1.013.000 900.000 I013.000 n/a REEF tp Parks Reserve Fund 25,000 25,000 45.000 45,000 45,000 0 0% REEF to Debt Service/PAEC Capital 1.363.370 1363370 1,363,370 132&567 1 1328567 1.328,567 QO REEr to PAEC CIP Fund 1.000.000 1.000,000 n/a SCORE Debt Service Transfers/Other/Unalloc IS/Strategic Rsv. Property Purchase 13.000.000 12.659,667 n/a 4479,984 3,435,907 1,763.624 2,799254 322.515 322,515 0.00/0 Total Other Uses 30.909.809 28,958.078 8,255,920 15,100,789 5,736,431 5.736.431 0.0 % Fnding Fund Balance Arterial Streets Overlay 1271618 621,582 190,960 160,554 - 402,005 n/a n/a Utility Tax(non-Prop 1) 1,500,000 1,569.994 1,878,965 1,500,000 - 1,515,135 n/a n/a Utility Tax -Prop 1 Voter Package 1,012,102 1,144,640 999,998 1,020,000 1,004,463 n/a n/a Affordable & Supportive Housing Sales & Use Tax - - 39,243 n/a n/a: Solid Waste & Recycling 88,942 194,473 133,695 75,616 168,405 n/a n/a Hotel/Motel Lodging Tax 1,099.180 1,329,005 1,274,105 1,170,480 1,393.606 n/a n/a Federal Way Community Center 1,590,275 1,208,268 1,503,362 1,500,000 1,140,700 n/a n/a Traffic Safety Fund 1,578,075 1,389,467 1,663,145 1,203,849 - 1,250,007 n/a n/a Real Estate Excise TaxFund 2,667,131 3,219,0841 2,879,146 2,037,564 3,220,704 n/a n/a Performing Arts & Event Ctr Operations 96,638 (110,536) (315,518) 0 (0) n/a n/a Paths & Trails Technology Fund 1,151,997 1,191,437 1,066,634 1,320,997 1,318,147 n/a n/a 4,0141 2,991 256 24,014 8,323 n/a n/a Strategic Reserve Fund 2,998,000 1573.800 2,742,135 3,000.000 3,585,889 n/a n/a Parks Reserve Fund 1,075,796 1,080,793 1,276.488 1,125,7961 1 1,129,597 n/a n/a Debt Service Fund 2,597,201 3,933,732 3,585,837 2,060,811 j 5,597,817 n/a n/a Surface Water Management 1,386,5271 3,009.977 1 1,999,764 1 1,529,947 3,796,564 n/a n/e Dumas Bay Centre Fund 11587,5741 1,601.055 1 1.665.262 1,525,353 1,366,874 n/a n/a Total Ending Find Balance $ 20.551,070 1 S 24,959,751 1 S 22,544.233 1 S 19.254,881 S - S 26,937,484 n/a a/a 77 Sales Tax Compared to year-to-date 2019 actual, sales tax revenues are below by $13K or 0.2%. Compared to 2020 year-to-date budget, sales tax revenues are below by $281K or 4.4%. There is usually a two month lag in sales tax revenue. The sales tax collected for April 2020 is paid to the City in June 2020. LOCAL RETAIL SALES TAX REVENUES YTD J une Month 2019 Actual 2020 Fawrable/(Unfavorable) Change from 2019 YTD Actual vs Budget Budget Actual $ % I $ % Jan S - . I - Feb 1,501,715 1,600,006 1,632,752 131,037 8.7%1 32,746 2.0% Mar 1,104,726 1,132,842 1,182,535 77,809 7.0%1 49,693 4.4% Apr 997,513 1,132,558 1,066,267 68,754 &9% (66,291) -5.9% May 1,346,880 1,353,658 1,130,545 (216,335) -16.1% (223,113) -16.5% Jun 1229,332 1,228,929 1,154,633 (74,699) -61% (74,296) -6.0% Jul 1,263,066 1284,582 - - Aug 1,502252 1,458,580 - Sep 1,401,269 1,364,099 - - Oct 1,438,593 1,368,398 - - - - - Nov 1,528,439 1,434,239 - - Dec 2,595,078 2,591,863 - - YTDTotal $ 6,180,166 $ 6,447,994 $ 6,166,732 $ (13,434) -0.2% $ (281,262) 4.4% Annual Total $ 15,908,863 $ 15,949,755 n/a n/a n/a n/a n/a COMPARISON OFSALFS TAX COLLECTIONS BYSIC GROUP Fawrable/(Unfawrable) Component 2019 2020 Change from 2019 $ % Group Actual Actual Explanation Retail Trade $ 3,109,919 $ 3,071,053 $ (38,867) -1.2% Up $78K- Health & Personal Care, General Merchandise, Miscellaneous Store Retailers, Gasoline Stations, Food & Beverage, Nonstore, Building Material & Carden Down $116K- Motor Vehicle, Fumitur and Home Furnishings, Electronics & Appliances, Clothing & Accessories, Sporting Goods/Hobbies .Services 1,483,403 1,263,350 (220,053) -14 8% Up WK- Administrative & Support Services Down $265K - Accomodation, Nursing & Residental Care, Educational Services, Ambulatory Health Care Service, Professional, Scientific, & Technology, Amusement & Gambling, Personal & Laundry Services, Performing Arts, Hospitals, Food Services, Drinking Places Construct 712,283 1,018,979 306,696 43.1% General Increase Wholesaling 220,008 208,439 (11,569) -5.3% Down $12K- Wholesale Trade Durable & Nondurable goods Transp/Utility 2,318 1,460 (858) -37.0°/a General Decrease Information 268,625 265,238 (3,387) -1.3% Up $8K- Internet Services, Other Informtion Services Down $11K-Telecommunications, Publishing, Motion Picture & Sound Recording Manufacturing 83,647 72,536 (11,111) -13.3% General Decrease Government 104,977 81,848 (23,129) -220% General Decrease Fin/hrsurance 157,681 163,022 5,341 3.4% Up $13K Real Estate, Insurance Carvers & Related ./Real Estate Down $8K Credit Intermediation, Rental & Leasing Services LY:T�-W�� 37,304 20,807 (16,497) -44.2% General Decrease S 6,180,166 S 6,166,732 S (13,434) -0.2% SALES TAX COMPARISON by AREA Year -to -Date June Fawrable/(Unfawrabl e) Chg from 2019 $ 1 % Location 2019 2020 Explanation YFDSales Tax $ 6,180,166 $ 6,166,732 $ (13,434) -0.2% S 348th Retail Block 885.747 977,203 91.456 10.3% Up $143K - General Merchandise, Retail Misc. Store, Retail Bldg. Materials, Retail Electronis & Appliances Down $51K- Retail Eating/Drinking, Retail Automative/Gas The Commons 430.293 354,308 (75,985) -17.7% Down S76K Retail Electronics/Appliances, Retail General Merchandise. & Apparel and Accessories. Eating & Drinking, Misc Retail Trade S 312th to S 316th 335.775 349,488 13,713 4.1% General Increase Pavilion Center 196.987 171,160 (25,827) -13.1% General Decrease Hotels & Motels 76.994 58.820 (18,174) -23.61/a General Decrease Gateway Center 81.765.1 60.158 (21,607) -26.4% c Down $22K Food & Beverage, & Telecommunications Utility Tax (Total 7.7591o) The utility taxes year-to-date is $0.04M or 0.9% below 2019 year-to-date actual, and $0.27M or 5.2% below 2020 year-to-date budget. There is usually a two month lag in utility tax revenue. The utility tax collected by utility companies for April 2020 is paid to the City in June 2020. UFB.ITY TAXES Year -to - late thru June Month 2019 Actual 2020 Fawrahl a/(Unfawrable) Change from 2019 , YFD Actual %s Budget Budget Actual $ Var % Var $ Var % Var Jan S 521 S 645 $ 372 $ (149) -28.6% $ (273) 42.3% Feb 780,534 1,027,339 996,007 215,473 27.6% (31,332) ... -3.0% Mar 1,108,776 1,129,815 1,122,530 13,755 1.2% (7,285) -0.6% Apr 1,376,813 1,182,847 1,096,086 (280,727) -20.4% (86,761) -7.3% May 939,409 930,790 963,935 24,526 2.6% 33,145 3.6% Jun 815,993 991,572 797,507 (18,486) -2.3% (194,065) -19.6% Jul 797,684 846,570 - - Aug 785,130 563,326 - Sept 786,724 1,113,161 - - Oct 866,190 990,389 - Nov 771,503 820,544 - - Dec 2,080,305 2,252,028 - - YFD Subtotal $ 5,022,045 $ 5,263,008 $ 4,976,437 $ (45,608) -0.9% $ (286,571) -5.4% Rebate (7,497) (19,677) (5,098) 2,399 0.0% 14,578 -74.1% YFD Total $ 5,014,548 $ 5,243,331 $ 4,971,339 $ (43,210) -0.9% $ (271,993) -5.2% Annual Total $ 11,102,084 $ 11,829,026 n/a n/a n/a n/a I n/a The City of Federal Way provides a utility tax rebate for qualifying individuals that have paid for Utility bills within the City of Federal Way, who are 65 years or older, disabled/unable to work, and qualify as low income during the affected calendar year. This is an annual program that opens January P and closes April 30`b of each year. The City processed 115 rebates at a total cost of $12K in 2017. The City processed 87 rebates at a total cost of $10K annually in 2018. The City processed 74 rebates in 2019, for a total of $7,497. The City has processed 48 rebates so far in 2020, for a total of $5,098. Due to COVID-19 we accepted applications through the end of May instead of April. 79 The City was in litigation with Lakehaven and other water and sewer providers in Federal Way regarding the 7.75% excise tax ordinance extended to business activities of public and private water and sewer utilities. The City has spent $33K this year in legal costs and $302K life -to -date related to this litigation. The Supreme Court decided in the City's favor and we are currently working with Lakehaven on the tax payment from March 2018 through June 2020. UTILITY TAXES - by Type Year-to-date thru June Utility Type . 2019 Actual 2020 Actual Favorable/(Unfavorable) Change from 2019 S % Electric S 2,271,039 S 2,188,832 S (82,207) -3.6% Gas 767,195 870,677 103,482 13.5% Solid Waste 474,171 485,659 11,488 2.4% Cable 716,882 704,237 (12,645) -1.8% Phone 261,421 234,226 (27,196) -10.4% Cellular 369,062 310.643 (58,419) -15.8% Pager 26 18 (8) -30.8% S W M 162,2491 182.146 1 19,897 12.3% Tax Rebate 1 (7,497) (5,098)1 2,399 0.0% YrD Total I $ 5,014,548 1 $ 4,971,339 1 $ (43,210) -0.9% Proposition I Voter Approved Utility Tax Water/Sewer Litigation Project -to -Date Month -to -Date YTD 2020 Actual S - $ 33,245 S 301,558 *Includes cost of ordinance review prior to actual litigation *Provided by the Law Department *The City had a favorable outcome in the lawsuit and is expecting about $1.0 million a year in new revenue. 2020 Prop 1 expenditures year-to-date of $1.51M or 43.5% of the $3.5M annual budget. Current life -to -date Prop 1 Utility tax collections and transfer is $39.4M and expenditures is $38.4M. PROP 2019 2020 life To Date Budget Actual Budget Actual Beginning Balance: 1,002,101 1,002,101 1,012,101 1,144,644 n/a OPERATING REVENUES January 144 1,946 143 84 1,607,808 February 229,669 177,223 228,811 225,638 3,270,893 March 267,871 251,743 266,871 255,045 3,924,934 April 214,865 311,990 214,063 248,012 3,528,611 May 201,696 213,668 200,943 217,959 3,260,891 .June 263,038 185,966 262,056 180.329 3,430,081 July 167,123 181,745 166,499 2,527,591 August 119,523 178,649 119,076 2,374,458 September 266,981 179,080 265,984 2,621,341 October 237,812 196,974 236,924 3,057,431 November 168,592 175,409 167,962 2,501,920 December 538,577 478,067 546,559 5,333,530 Total Prop 1 Revenues: 2,675,891 2.532,461 2.675.891 1.127.067 37.439,488 Transfer in from Utility Tax Fund 780,484 780,484 807.254 245.442 2.009,737 OPERATING EXPENDITURES Public Safety Improvement Positions & Costs: Police Services (includes 1 Records Specialist, 16 Police Officers, & 2 Lieutenants) 2,756,239 2,552,946 1 2,764,419 1,207,309 29,263,489 Court Services (includes .50 Judge, 1 Court Clerk, and Pro Tent Pay. Public Defender contract_ 1 5 Prosecutors) 428,393 336221 441.159 163,244 4,662,000 Total Public Safety Improvement Costs 3,184,632 2,889,166 3.205.577 1,370.553 33.925.489 Community Safety Program Costs: 1 Code Enforcement Officer 91,119 96,088 95,218 50,465 764,094 .5 Assistant City Attorney 67 186 68,820 71,013 35,647 808,348 1 Parks Maintenance Worker I & Security 103,437 116,328 103,437 56,026 1,396,120 Total Community Safety Improvement Costs 261,742 2819235 269.667 142,138 2,968,563 Indirect Support - HR Analyst - 291,695 SafeCity M&O - 245,929 Subtotal Ongoing Expenditures - 537,624 SafeCity Startup - 189,066 Other Transfer - Prop 1 OT for Police - 824,021 Subtotal Other Expenditures - 1,013,087 Total Prop 1 Expenditures: 3,446,374 3,170,402 3,475,245 1 1,512,691 38,444,763 Total Ending Fund Balance: S 1.012.102 S 1.144.644 $ 1.020.001 1 S 1,004,462 S 1.004.462 Real Estate Excise Tax Compared to 2019 year-to-date actuals, collections are below by $747K or 35.4%. June's receipt of $238K is below June 2020's projections by $74K or 23.8%. June 2020 activities include 124 real estate transactions, of which none were tax exempt. There were 124 taxable residential sales (total sales $48.3M / $238K tax), and no commercial sales. Hotel/Motel Lodging Tax Hotel/Motel lodging tax received year-to-date in 2020 is $69K and is below 2019's year- to-date collections by $40K or 36.6%. 2020 year-to-date receipts are below year-to-date projections by $35K or 33.9%. The lodging tax collected for April 2020 is paid to the City in June 2020. Permit Activity Building, planning, and zoning permit activities are below 2019's year-to-date activity by $1.2M or 54.3%. Compared to year-to-date budget, permit activity is below by $0.7M or 39.4%. REAL ESTATEEXCISETAX REVENUES Year -to -ate thru June Month 2019 Actual 2020 a FawrableWnfawrable) Change from 2019 YID Actual vs Budget Budget Actual $ % $ % Jan $ 242.395 $ 203,482 $ 193226 $ (49,168) -20.3% $ (10.256) -5.0% Feb 58$487 272.795 273,266 315.221 -53.6% 471 0.2% Mar 253,664 327,064 164,884 88.779 -35.001. 16 ] 80 -49.6% Apr 237.306 . 230,335 185,348 51 95.8. -21.9%/a (44,987) .. -19.5% Mav 296.386 248.915 309.742 13,357 4.5% 60.827 24.4% Jun 493.407 312.327 237.980 255.426 -51.8% (74.347) -23.8% Jul 327.771 280.100 - Aug 799.244 343.289 - - - Sep 1 349.971 332,585 - - - Oct 388.533 383.030 - - - Nov 258,753 286.079 - - - Dec 935,728 419,997 - - - YTD Total 2.111.644 . 1.594.919 1,364,448 1 (747.196) -35.4% 230,471) -14.5% Annual Total $ 5.171.643 1 $ 3.640.000 n/a n/a n/a n/a I n/a HOTEUMOTEL LODGING TAX REVENUES Year-to-date thru June Month 2019 Actual 2020 Fawrable/(Unfawrable) Change from 2019 YID Actual -.s Budget Budget I Actual $ % $ % Jan $ - $ . $ - $ - $ - - Feb 22,862 18,263 20,477 (2,384) -10.4% 2,215 12.1% Mar 17,340 17,615 18,201 861 5.0016 585 3.3% Apr 21,015 21,984 12,425 (8,590) 40.9% (9,559) -43.5% May 26,343 25,283 6,289 (20,054) -76.1% (18,993) -75.1% Jun 21,450 21,466 11,734 (9,716) -45.3% (9,733) -45.3% Jul 23,485 24,875 - - - - - Aug 31,724 32,603 - - Sept 31,912 35,477 - - - - Oct 32,607 36,348 Nov 26,575 27,969 - - - Dec 37,672 38,118 - i - YrD Total S 109,010 S 104.611 $ 69,126 S (39,884)1 -36.6% S (35A85)1 -33.9% Annual Total S 292.986 S 300.000 n/a n/a I n/a I n/a n/a BUILDING & LAND USE PERMITS AND FEES (CD) Year-to-date thru June Month 2019 Actual 2020 Change from 2019 Fallorabl a/(Unfawrabl e) 1 YTD Actual vs Budget Budget I Actual $ % $ % Jan 203,996 171,645 170,936 (33,060) -16.2% (709) -0.4% Feb 371,050 321,145 164,352 (206,697) -55.7% (156,793) -48.8% Mar 217,643 251,596 198,647 (18,996) -8.7% (52,949) -21.0% Apr 510,894 328,862 208,283 (302,610) -59.2% (120,579) -36.7% May 825,324 416,781 143,034 (682,290) -82.7% (273,748) -65.7% Jun 163,185 240,387 162,861 (325) -0.2% (77,527) -32.3% Jul 238,899 298,966 - - Aug 436,819 302,991 - - Sept 181,193 251,788 - - Oct 600,317 329,693 - - Nov 359,558 253,269 - - - Dec 437,556 228,651 - - YID Total $ 2,292,091 $ 1,730,416 $1,048,112 $ (L243.978) -54.3% $ (682,304) -39.4% Annual Total $ 4.546.432 S 3.395 775 n/a n/a I n/a n/a n/a 91 Police Department The total overtime budget of $1,O1M consists of $767K for City overtime and $239K for billable time. Compared to 2020 year-to-date budget, City's portion of overtime is $96K or 25.9% above year-to-date projections. Compared to year-to-date 2019 actuals, City's portion of overtime is above by $51K or 12.2%. Including the increase in billable overtime, total overtime increased by $47K or 8.1% above the same time last year. The June overtime decrease of $25K below 2019 year-to-date actual is primarily due to a decrease in shift -call in and shift extension for special investigations. PD Overtime by Type Year-to-date thru June T. pe 2019 Actual 2020 Actual (Faw r abl e) / U n faro r a b l e Change from 2019 $ % Training s 3.796 S 6.782 S 2.986 78,7% Court 12,319 7,655 (4,664) 37.9% Field Oper 329,257 402,024 72,767 22.1 % Other 73.055 53.030 (20.025) -27.4% City Portion 418,427 469,490 51,0631 12.2% Contract/Grant 157.870 156.164 (1,706) 1-1.1 Traffic School 2,252 - (2,252) Billable 160.121 156.164 (3,957) -2.5 % YTD Total I S 578.548 S 625.654 1 S 47.106 1 104 Jail Services PD Overtime by Month Year-to-date thru June 2019 Month Actual 2020 (FawrabiO/Unfawrabl e Change from 2019 YTD Actual vs Budget Budget Actual $ % S % Jan S 58,150 S 63246 $ 127,979 S 69,829 120.1% S 64,733 1024% Feb 52,654 59,371 101,411 48,757 92.6% 42,041 70.8% Mar 56,669 55,457 64,125 7,455 13.2% 8,667 156% Apr 75.230 59,808 44.288 (30,942) 41.1% (15,520) -25.9% May 85,669 70,270 66,174 (19.495) -22.8% (4,096) -5.8% Jun 90,055 64,846 65,514 (24,540) -27.3% 669 1.0% Jul 122,545 88.019 - - Aug 64,118 54,863 - Sep 67,299 56,368 Oct 93,804 73.193 Nov W 67,610 61,761 - - - - Dec 113,705 59,954 City Portion 418,427 372,996 469,490 51,063 122% 96,494 25.9% Billable 160,121 119,250 156,164 (3,957) -2.5% 36,914 31.0% YrD Total S 578548 $ 492.246 S 625,654 S 47,106 8.1 % $ 133,408 27.1 % Billable S 223,392 S 119,250 S - $ $ Annual Total $1,331,021 S 1,005,655 1 n/a n/a n/a n/a n/a The City discontinued its relationship with SCORE as of December 31, 2019. The City now has multiple contracts with other governmental agencies for its jail services. The total jail budget is $3.43M and it is for jail services, salaries and wages for a jail coordinator, 2 jail transport officers, and equipment and vehicles needed to transport inmates. Jail and Alternatives to Confinement 2018 2019 Annual Actual Annual Actual 2020 Annual Budget I YFD Actual Other Jail & Altemative Programs $ 126,507 . $ 114,830 $ 35,000 1 $ 1,197 Salaries & Benefits - - 335,736 154,159 Supplies - - - 1,200 Inter ovemmental Jail Services/SCORE 6,290,972 5,817,265 2,920,300 687,289 Machinery & Equipment & Reserves - - 137,914 25,655 Total $ 6.417.479 $ 5.932.095 $ 3.428.950 $ 869.501 Debt Service Payments 889,718 934,390 227,103 Total Jail Costl 6.417,479 1 $ 6,821,813 1 $ 4,363,340 1 $ 1,096,604 Intergovernmental jail services in 2018 and2019 are payments to SCORE 2018 Debt Service of $934Kwas paid for by SCORE In 2019 SCORE Debt was refinanced and includes debt service refinance costs. In addition to the $3.43 million budget above, the City continues to be liable for its portion of the debt service on the SCORE building. The total remaining principal debt the City owes as of 12/31/2019 for SCORE is $10,945,000. Traffic Safety —Red Light/School Zone Traffic Safety Red light & school zone enforcement revenues are accounted for in the Traffic Safety Fund to be used for, but not limited to prevention, education, and enforcement efforts related to traffic safety and compliance with traffic control devices within the City, including maintenance and operations costs. Traffic Safety Fund pays for 1 Lieutenant, 7 Police Officers, 3 City Traffic positions, Municipal Court security services, red light photo services, Valleycomm emergency communication services, School Zone Enhancements capital improvement projects, and patrol vehicles. 2019 Gross Payments Salaries & M'ages Net Month Re -venue to ATS & Crt Sccurlty Revenue 2020 Variance Fawrabl a/(Unfawrable) Gross Resenue Payments to ATS Salaries & Wages Net & Crt Security Revenue $Variance %Variance Jan S 397,776 $ - S (147,542) $ 250,234 S 257,784 S - S (144,627) S 113,158 S (13T076) -54.8% Feb 263,413 (52,250) (154,701) 56,462 269.723 (38,934) (156,989) 73,800 17.338 30.7% Mar 216,489 (52,250) (153,618) 10,621 256.700 (52,250) (157,143) 47,307 36.685 345.4°/u Apr 355,041 - (156,119) 198,922 300,444 (26,125) (156,356) 117,963 (80,959)1 40.7% May 294,168 (52,250) (166,599) 75,319 110.173 (28,500) (157,225) (75,553) (150,872) -200.3% Jun 405,464 - (222,438) 183,026 112.718 - (156,122) (41404) (226,430) -123.7% Jul 309,469 (154,840) 154,630 - - - (154,630) -100.0% Aug 237,046 - (146,615) 90,431 - - (90,431) -100.0% Sep 249,582 (156,750) (145,876) (53,044) — 53,044 -100.0% Oct 299,469 (52,250) (156,400) 90,819 - - - (90,819) -100.0% Nov 287,654 (52,250) (168,589) 66.815 ......... -I - - - (66,815) -100.0% ._..........-_.. Dec 261.679 (209.000) (170.763) (118.084) - 1119.094 -100.0% YID Total $1.932350 $ (156.750). $ (1.001.016)1 $ 774584 $1307.541 $ (145.809) S (928.461)1 S 233.271 S (83.053) -10.7% Annual Total $3,577,248 $ (627,000). $ (1,944,097)1 $1,006,151 $1,307,541 1 S (145,809) $ (928,461)1 S 233,271 1 $ (772,880) n/a Court Court operation and probation service revenues are $126K or 21.0% below 2019 year-to-date actuals and $155K or 24.6% below 2020 year-to-date budget. COURT REVENUE Year-to-&te thru June 2019 Actual 2020 Actual avora el( njavom e) Changefrom 2019 S % Civil Penalties S 4,495 S 2.211 $ (2.283) -50.8% 'rraffic & Non -Parkin$ 319,960 261,241 (58,719) -18 4% 1Parkin Infractions 5.588 5.254 (334) -6.0% (DUI & Other M isd 38,499 36,280 (2,219) -5.8 % Criminal Traffic Misd 24 119 96 406.8% Criminal Costs 32,087 30,028 (2,059) -6.4% (Interest/Other/Mist 50,881 32,728 (18,153) -357% Criminal Conv Fees 14.738 15A79 740 5 0% Shared Court Costs 21,660 21,536 (124) -06% :iervices & Charms 23.453 18.121 (5.332) -22 7 % Subtotal S 511,384 S 422,997 S (88.387) -17.3% (Probation Fees 60 60 nl ,Probation Services 90,102 52,017 1 (38,085) -423% YTDTotal I S 601,486 S 475,075 1 S (126,411), COURTREV94UE Year-todate thru June Month 2019 Adual 2020 Fawrabiel(lbraw stile) Change from 1019 YTD Actual vs Bailed Budget Actual S % i S I % January $ 85,735 S 60,118 S 96,133 S 10,398 12.1% S 36,015 59.9°/ February 73,831 123.387 67.112 6.719) -9.1% (56-275) A5.6°A March 81.352 104A35 86.025 4.672 57% (18.410) -17.6% April 112794 95,898 65325 (47.469) A2 N/ (30.573) -31.9% May 73J42 79.271 49.511 (23.630) -323% (29.7601 -37.5% June 84,5301 72,520 58.892 (25,638) -30.3% (13.628) -18.8°/n Ju 113,3721 80.127 (113.372) Auaust 76.176 82.579 (76,176) September 71.979 81,791 71.979 October 87,545 79,598 (87,545) November 75 ' 1861 71.983 (75.186) December 79.5511 75.035 - Probation Fees 60 60 n/a 60 n/a Probation Services 90,1021 94230 52,017 (38,085) n/a (42212) - 4.8% YID Total S 601A86 S 629,858 S 475.075 S 126A11 -21.0% S (154.784] 24.6% Probation Services 70.5201 94130 1 n/a n/a n/a n/a n/a Annual Total S 1,175AI41 S 1201.201 n/a n/a n/a n/a n/a Federal Way Community Center The Federal Way Community Center Fund was established as a special revenue fund supported by user fees and utility tax transfer. Due to the Covid-19 pandemic this facility closed to the public as of March 12`h, 2020. Federal Way Community Center as of06/30/2020 2019 2020 YID Budget is Actual Fawrable/06wrable) Annual YID Budget Actual Actual Budget YfD Budget YID Actual $ % Beginning Fund Balance $1.566.460 $ 1,566,4601 $ 1.566A60 $1.590.275 $ 1.208.2751 $1,208,275 n/a n/a Operating Revenues: Dail Drop -ins $ 370.000. $ 324,802 $ 175.196 $ 370.000 $ 199,5761 $ 67.876 $ (131.700) -66.0% Passes 850,000 751,781 355.250 850.000 401,663 200,720 (200,943) -50.0% City to ee Membership Program 32.550 22.699 11.404 32.550 16,353 2.424 (13,929) -85.2% Youth Athletic Programs 47.250 31.041 15.354 47.250 23.372 10,970 (12,402) -53.1% Aquatics Programs-Lessons/Classes 146,950 156,014 80,755 146,950 76,064 23,941 (52,123) -68.5% Childcare Fees 3,000 9,635 4,460 3,000 1,389 1,352 (36) -2.6% Fitness Classes/Fitness Training 133,250 35,362 9,391 133,250 35,387 10,120 (25,267) -71.4% Towel/e ui ment Rentals 4,000 7,005 5,260 4,000 3,004 224 (2,780) -92.5% Pool Rentals/Competitive-Lap Lanes 30,000 21,971 11,297 30,000 15,425 10,416 (5,009) -32.5% Rentals 246,000 236,515 122,510 246,000 127,423 35,645 91,778) -72.0% Merchandise Sales 7,875 7,167 3,992 7,875 4,386 1,314 (3,072) -70.0% Concessions/Vendin 60,0001 54,857 25,175 60,000 27,534 10,796 (16,738) -60.8% Interest Eamin s/OtherMisc 37,4761 89.802 42.729 10.000 4.758 983 (3,776 -79.3% Total Operating Revenues 1,968,351 1.748,651 862,772 1,940,875 936,332 376,781 (5599551) -59.8% Operating Fx nditures: Personnel Costs 1.586,536 1,660,795 817,153 1,605,650 790,020 512.372 277.649 35.1% Supplies 184,000 227,150 102226 184.000 82,807 63.621 19.186 23.2% Other Services & Charges 193,000 256,423 112,086 193,000 84,363 54,571 29,792 35.3% Utility Cost 330,000 308,138 128,091 330,000 137,179 103,662 33,517 24.4% Inter ovemmental 20,500 3,679 3,559 20,500 8,519 8,519 - 0.0% Total Operating Expenditures 2314.036 2.456.184 1.163,116 2333,150 1.102.889 742.744 360.145 32.7% Revenues Over/ der)Fa nditures (345,685)I (707,533) (300,344) (392,275) (166,557) 365,963) 199,407 119.7% Recowry Ratio 85.1% 711% 741% 83.2%1 84.9% 50.7% n/a n/a Utility Tax- Opemtions 387,0001 387,000 270,863 312,000 312,000 312,000 - 0.00/0 Total Other Sources 387,0001 387,000 270,863 312,000 312,000 312,000 0.0% Other Bes: Capital/Use of Reserves/Grants 17,500 _ 37,652 33,612 10,000 10,000 13,599 (3,599) -36.0°/a Total Other Lises 17,500 37,652 33,612 10,000 10,000 13.599 (3599) -36.0% Net income 23.815 (358.185) (63.093) (90.275) 135.443 (67562) (203.006) -149.9% Fndin¢ Fund Balance $1,590.275 $ 1,208,275 $1,503,367 $1,500,000 $ 1,343,719 1 $11140,713 $ (203,006) -15.1 % Debt ServicePavments 813,473 _ 813,773 1 - 813,473 141,811 141,811 - 0.00/0 Total FWCC Cost S 3,145.009 1 S 3307.609 i S 1.196.727 $ 3.156.623 S 1.254.700 1 S 898.154 1 S 356.546 28.4% Total City Support $1,125,473 $ 453,811 The operating revenue budget includes $1.94M in user fees/program revenues, and $312K contribution from utility tax for operation. Year-to-date operating revenues total $0.4M which is $560K or 59.8% below the 2020 year-to-date budget. In comparison to 2020's year-to-date budget: • Daily Drop -in revenues are $132K or 66.0% below the projected revenue, and $107K or 61.3% below last year. Revenues are down due to Covid-19 and closing the Community Center on March 12', 2020. Pass Revenues are $201K or 50.0% below the projected revenue, and $155K below last year. The Community Center has implemented a new registration system and membership software system, and we are seeing a significant drop in pass renewals from some of our members. When customers were contacted and asked to provide updated account information, many chose to cancel for various reasons. Staff has implemented new and improved marketing and sales efforts to retain and attract new members and this has been put on hold due to Covid-19. Revenues are also down due to Covid-19 and closing the Community Center on March 12`', 2020. ■ Aquatic Programs/Lessons are $52K or 68.5% below the projected revenue, and $57K below last year. Due to the Covid- 19 pandemic the pool has been closed since March 12t1i, 2020, and swim lesson payments have been refunded. Rentals are $92K or 72.0% below the projected revenues, and 87K below last year. Loss of the rental coordinator attributed to the loss of revenue. Due to Covid-19 rentals from March 1 ltb on were cancelled. This accounted for $25K in loss of rental revenue. ■ Youth Athletic Programs are $12K or 53.1% below the projected revenues. Revenues are also down due to Covid-19 and closing the Community Center on March 121h, 2020. Year-to-date operating expenditures total $0.7M which is $360K or 32.7% below the year-to-date budget. Federal Way Community Center has recovered 50.7% of operating expenditures compared to the year-to-date budgeted recovery ratio of 84.9%. ■ Personnel Costs are $278K or 35.1% below the projected budget. The facility closed to the public as of March 121h, 2020, part-time staff hours were not paid, and 9 full-time employees were placed on inactive status. ■ Supplies are $19K or 23.2% below the projected budget. The facility closed to the public as of March 12th, 2020 and building supplies have been reduced. ■ Other Services and Charges are $30K or 35.3% below the projected budget due to the facility being closed to the public as of March 12tb, 2020 and services have been reduced. Although expenditures are down, the facility has required major repair and maintenance this year such as air filters, fire hood certification, fire alarm inspections, sand media replacement in pool filters, and pool light replacement. Community Center remaining debt service principal as of 12/31/2019 is $9.38M. Dumas Bay Centre Dumas Bay Centre Fund year-to-date revenue of $128K is $274K or 68.1% below 2020 year-to-date budget of $402K, and $353K or 73.3% below year-to-date 2019 actual. I Year-to-date operating expenses total $322K, which is $52K or 13.9% below 2020 year-to-date budget of $374K. Dumas Bay Centre has recovered 39.85% of operating expenditures compared to 120.20% last year. Due to the Covid-19 pandemic this facility closed to the public as of March 12th, 2020. Dumas Bay Centre Fund as of 06/30/2020 2019 21120 1TD Bu get is kcIunI Budget Annual Actual YID Actual Budget YrD Budget YrD Actual Favorable/(Unfavorable) s % Beginning Fund Balance S 1.585.695 S 1.585.695 S 1.585.695 $ 1.587.574 S 1.587.574 $ 1.601.055 n/a n/a Operating Revenues: In -House Food Services 375,000 388,615 196,824 275,000 139,281 51,796 (87,484) -62.8% Dumas Bav Retreat Center 537.751 502,864 269,3301 490,251 262.575 70.181 (192.394) -733% Knutzen Family Theatre 26.000 34.438 14.742 6.368 6.368 n/a Total Operating Revenues 938.751 925.917 480,896 765.251 401,856 128346 (273.510) -68.1 % Operating Expenses: In -House Food services 396,709 359,468 164,988 349,309 160,326 115,169 45.156 28.2% Dumas Bay Retreat Center 551.563 541.838 233.345 489.563 210.833 203.864 6.969 3.3% Knutzen Family Theatre 7.600 3.888 1.762 7.600 3.019 3.019 0.0% Total Operatine Expenses 955.872 905,194 400.096 846,472 374.178 322.053 52,125 13-9 % Revenues Over/(Under) Expenses (17.121) 20,723 80.801 (81.221) 27.678 (193.707) (221385) -799.9 % Recovery Ratio 98.21 % .102.29 % 120.20 % 90.40 % 107.40% 39.85 % n/a n/a Transfer In Utilitv Tax 23.000 -- 23.000 23.000 23.000 �- n/a Total Other Sources 23.000 23.000 23.000 23.000 n/a PumpStation M&0 4,000 5,362 1,234 4,000 220 220 _ 0% Repairs & Maintenance 63,254 (63.254) n/a Total Other Uses 4.000 5362 1,234 4.000 220 63.474 (63.254) -28781 % Net -Income 1.879 15361 , 79,567 (62.221) 5OA58 (234,181) (284.639) -564.1 % Ending Fund Balance $ 1.587.574.1 S 1.601.056 1 $1.665.261 1 S 1.525352 1 S 1.638.032 $1366.874 S (271.157) -16.6 % Interfund Loan Issue Date Interfund Loan Original Arnountl Balance I Responsible Fund Due Date 2/4/2020 CDBG Grant Res 16-708 $ 400,000 15 130,570 119 - CDBG Grant fund 4/13/2023 11/7/2017 'Transportation Street Light Res 17-728 S 2,500,000 1 S 1,507,972 101 - Street Fund 12/31/2022 Self -Insured Health Insurance Fund Self -Insured Health Insurance Fund year-to-date contributed revenue is $2.6M. Currently the revenue is generated from the employee paid contribution (range from $34 to $141 per employee per month) and the employer paid contribution (range from $666 to $1,973 per employee), varying depending on number of dependents. The City will maintain a reserve in the amount not less than 16 weeks of budgeted expenses ($1.29 million) as recommended by our consultant. Self -Insured Health Insurance Fund year-to-date expenditures are $2.6M for prescription services, medical services, stop loss, professional services, and wellness program. The ending fund balance for the program is $3.6M. Self Insured Health Insurance Fund - 2020 Deserlptlon 2017Annual Actual 2018 Annual Actual 2019Annual Actual 2020 Adopted Bdgt Jan Feb Mar Apr May Jun YTDAelual Beginning Fund Balancel 2,020,466 2,550,136 2,940,231 2,650,305 3.657,598 - 3,657,598 IHeakh Insurance Premum- Errployer Contribution Revenue 4.238,581 4,284,099 4.392.860 4,400,000 360,436 359,180 364,670 353,101 351.896 346,675 2.135,957 Heath Insurance Prenium- Errployee Contribution Revenue 216.562 209,633 222,779 150,000 17,416 17,897 17,889 17.347 17.337 16.864 104,750 Heath Insurance Premum- COBRA 10,026 21.805 34.319 6,000 13,894 13,264 11,140 9,546 47.845 Stop Loss Recovery Revenue 30063 482,308 281.299 400,000 24,842 117,831 11.486 102,945 257,104 IrderestEarnings 13,247 31,992 50,753 10.800 2,896 5.539 1,536 1,001 775 11.747 Total Revenue and Transfer In 4,785,379 5,029,837 4,982,011 4,966,800 402,894 393,867 505,929f277 61,373 476,805 2,557,402 Prescription Services 461,723 676,391 1,634,143 800,000 133,510 68,633 11 90,77684,345 73,118 526,786 Medical Services 2,944,877 2,747,675 1,656.869 3,300,000 36,858 586,917 322,69884,765 161,846 1,454.331 Heath Insurance - Stop Loss 464,184 642.805 567,344 730,000 59,314 58,090 59,50657,642 59,709 350,266 Professional Services 8Other 384,922 371,263 406,028 396,726 36,765 40.930 55.72650,525 47.255 282,325 Taxeslassessrrents-interogovernrrent 1,620 260 30,000 260 - 260 Total Fxpendhuresfor Self Insured Heahh 4,255,707 4,639,743 4,264,644 5,256,726 266,447 754,830 528.70677278 341,929 2,613,969 Ending Fund Balance 2550,137 2940Z31 3,657,596 2,360,379 3,793,845 (380,963) (22,777)04,085 11M.BTr 3,601,031 Performing Arts & Event Center Operations (PAEC) Performing Arts & Event Center Operations (PAEC) year-to-date revenue and beginning balance, and transfer in is $0.89M, and is $0.28M or 24.2% below year-to-date budget. Year-to-date operating expenditures total $0.89M, and are $0.24M or 20.9% below year-to-date budget of $1.1M. Year-to-date, $0.63M or 79.3% of $0.8M budgeted operating subsidy has been used and the PAEC Fund has a fund balance of $0. A new management company took over the management of PAEC in August 2018. As of 12/31/2019 the balance of debt service principal was $4,840,000. 115 Performing Arts & Event Center Operations (PAEC) Annual 2017 Annual 2018 Annual2019 2020 Adjusted Budget YTD Budget YTDJune Actual YTD Budget vs. Actual Favorable/(Unfavorable) Beginning Balance 177,413 477 (447,382) 96,638 96,638 (110,546) $ % Ticketing Sales/Adrrissions Fees 124,278 136,465 597,072 523,846 261,923 114,971 (146,952) -561% Theatre/Event Rentals 27,824 75,123 242,223 300,000 150,000 73,204 (76,796) -512% Concessions 1,291 13,230 38,614 178,000 89,000 6,022 (82,978) -93.2% Advertising 15,000 7,500 (7,500) -100.0% Grants 100,000 n/a Contributed Revenue - Private Sources 147,170 283,100 381,746 290,746 145,373 148,747 3,374 2.3% Transfer in from Utility Tax/General Fund 694,703 626,762 1,616,000 800,000 400,000 634.157 234,157 58.5 % Interfund Loan 500,000 - n/a Investment hterest/NMTC Interest 23,264 45,611 50,722 45,605 22,803 22,803 0 0.0% Total Beg Bal, Revenue & Transfer In 1,195,943 1,680,768 2,478,995 2,249,835 1,173,237 889,358 (283,879) -24.2% Personnel Services 487,179 338,233 81,628 100,000 50,000 44,676 5,324 10.6% Personnel Benefits 167,073 82,907 26,865 40,337 20,169 15,421 4,746 23.5% Supplies 23,466 24,539 - - n/a Other Services & Charges 496,326 1,080.185 2,259,567 1,944,684 972,342 767,145 205,197 21.1% Intergovernmental Services 1,221 1,221 n/a Capital Outlays 1,155 36,799 103,905 - n/a Interrund Services 19,045 64.266 117,577 164,814 82,407 62,116 20,291 24.6% Total Expenditures 1,195,466 1 1,628,150 2,589,541 2,249,835 1.124,9181 889,358 235,560 20.9% Total PAEC Operation Balance $ 477 1 $ 52,618 $ (110,546) $ (0) $ 48,319 $ (0)' $ (48,319) -100.0% Debt Service Payments 612,000 52,5771 52,577 Total PAEC Costj $ 1,195,4661 $ 1,628,1501 $ 2,589,5411 $ 2,881,8351 $ 1.177,495 $ 941,935 $ 235,560 20.0% Total City Suppart $ 1,432,000 $ 452,577 $ 686,734 $ (234,1571 -51.7% M COVID-19 Update On March 9, 2020 Mayor Ferrell issued a Proclamation of Emergency in order to prevent the spread of coronavirus disease (COVID-19). On March 12, 2020 the Federal Way Community Center, Dumas Bay Centre, and Preforming Arts & Event Center closed to the public. Then, on March 23, 2020, State Gov. Jay Inslee issued statewide two week stay home orders and closed all the businesses except essential services. On April 3, 2020 the stay home orders were extended through May 4`h. Year-to-date the city has spent $250,200 on Covid-19 related expenditures. COVID -19 Expenditures 2020 Year -to -Date June State Grant CDBG Grant Total Payroll Expenditures 136,842 9,442 146,284 Supplies/Equipment & Services 103,916 - 103,916 Total Expenditures $ 240,758 $ 9,442 $ 250,200 The City will be seeking reimbursement for some of these expenditures. FUND ACTIVITY SUMMARY Fund #/Fund Name Begin Balance 1/1/2020 YID Revenue YID Expenditures YID Net Fading Balance Income/(loss) 06/30/2020* Required Fund Balance 001/101 General/Street Fund $ 11,604,046 S 23,222,674 25,899,508 S (2,676,834) $ 8,927,212 $9,500,000-* Special Revenue Funds: 102 Arterial Street 621,584 199,713 419,290 (219,577) 402,006 $100,000 103 Utility Tax(*) 1,569,994 3,853,165 3,908,014 (54,949) 1,515,135 1,500,000 104 Affordable & Supportive Housing Sales Tax - 39,243 39,243 39,243 106 Solid Waste & Recycling 194,472 225,153 251,218 (26,065) 168,408 107 Special Contracts/Studies Fund 748,927 21,017 - 21,017 769,944 109 Hotel/Motel Lodging Tax 1,329,006 73,689 9,0881 64,601 1,393,607 200,000 1102%for the Arts - - - I I I Federal Way Community Center 1,208,267 688,781 756,346 (67,566) 1,140,702 $1,500,000* * * 112 Traffic Safety Fund 1,389,468 1,312,586 1,452,047 (139,461) 1,250,007 1,200,000 113 Real Estate Excise TaxFund 3,219,084 1,375,188 1,373,567 1,621 3,220,704 2,000,000 114 Prop 1 Utility Tax 1,144,644 1,372,509 1,512,691 (140,182) 1,004,462 1,000,000 115 Performing Arts & Event Ctr Operations (110,546) 999,904 889,358 110,546 (0) - 119 CDBG 35,284 876 179,924 (179,047) (143,763) 120 Path & Trails 1,191,437 126,710 126,710 1,318,147 121 Technology 3,013 5,310 5,310 ' 8,323 188 Strategic Reserve Fund 3,573,800 12,089 12,089 3,585,889 3,000,000 189 Parks Reserve Fund 1,080,794 48,804 48,804 1,129,597 1,125,000 Subtotal Special Revenue Funds 17,199,217 10,354,737 10,751,544 (396,807) 16,802,410 $11,625,000 m 201 Debt Service Fund 3,933,732 2,343,125 679,039 1,664,086 5,597,817 Capital Project Funds: 301 Downtown Redevelopment 2,526,754 22,819 ---�22,819 2,549,573 302 Municipal Facilities 288,595 976 976 289,571 - 303 Parks 11741,591 70,854 35,535 35,319 1,776,910 304 Surface Water Management 1,925,945 5,808 100,678 (94,870) 1,831,075 306Transportation 4,885,700 1,017,486 3,040,384 (2,022,898) 2,862,802 307 Capital Project Reserve Fund 367,936 1,245 1,245 369,181 - 308 PAEC Capital Fund - 338 (338) (338) - Subtotal Capital Project Funds 11,736,521 1,119,188 3,176,935 (29057,747) 9,678,775 ,Enterprise Funds: f 401 Surface Water Management 3,009,977 2,384,946 1,598,259 786,588 3,796,565 690,000 402 Dumas Bay Centre Fund 1,601,055 151,346 385,527 (234,181) 1,366,874 1,500,000 ,Subtotal Enterprise Funds 4,611,033 2,536,192 1,983,785 552,406 5,163,439 2,190,000 ,internal Service Funds 501 Risk Management 1,502,529 606,521 1,876,553 (1,270,032) 232,497 1,200,000**** 502 Information Systems 3,718,972 1,274,461 1,224,249 50,212 3,769,194 503 Mail & Duplication 217,369 77,001 30,948 46,052 263,421 504 Fleet & Equipment 7,808,824 1,148,858 1,574,672 (425,814) 7,383,010 505 Buildings & Furnishings 2,973,258 254,955 302,945 (47,990) 2,925,268 2,000,000 506 Health SelfInsurance Fund 3,657,598 2,557,402 2,613,969 (56,567) 3,601,031 $0***** 507Unemployment Insurance Fund 273,701 949 7,509 (6,559) 267,142 250,000 Subtotal Internal Service Funds 20,152,251 5,920,147 7,630,845 (1,710,698) 18,441,553 1 3,450,000 Total All Funds S 69,236,800 S 45,496,062 1 S 50,121,656 S (4,625,594)1 S 64,611,205 *The Fund balance prior to any adjustments or depreciation "The General and Street Fund required fund balance is $9.5Mand the current ending fund balance as of 0613012020 is $8,927,212 due to timing of revenue received such as property tax versus payments, and Covid-19 response to pandemic resulting in less revenue. *** The Federal Way Community Center Fund required fund balance is $1.5M and the current ending fund balance as of 0613012020 is $1,140,702 primarily due to the Covid-19 pandemic and the facility being closed to the public as of March 12th, 2020. Year-to-date $312K, the full annual budgeted amount of utility tax subsidy has been transferred to the Federal Way Community Center fund for operations. ****The Risk Management Fund required fund balance is $1.2M and the current ending fund balance as of 0613012020 is $232,497 due to the timing of paying insurance expenditures and claims for the year. *****The Health Selflnsurance Fund will maintain a reserve in an amount not less than 16 weeks of budgeted expenses as recommended by our consultant.