Loading...
HomeMy WebLinkAboutFIN 2023-01-23 COMPLETE AGENDA PACKETCity of Tukwila Finance and Governance Committee O Kate Kruller, Chair O Kathy Hougardy O De'Sean Quinn AGENDA MONDAY, JANUARY 23, 2023 — 5:30 PM Distribution: K. Kruller K. Hougardy D. Quinn C. Delostrinos Johnson T. McLeod M. Abdi T. Sharp Mayor Ekberg D. Cline R. Bianchi C. O'Flaherty A. Youn L. Humphrey THIS MEETING WILL BE CONDUCTED BOTH ON-SITE AT TUKWILA CITY HALL AND ALSO VIRTUALLY. ON-SITE PRESENCE WILL BE IN THE DUWAMISH CONFERENCE ROOM (2ND FLOOR, 6300 SOUTHCENTER BOULEVARD) THE PHONE NUMBER FOR THE PUBLIC TO LISTEN TO THIS MEETING IS: 1-253-292-9750, Access Code 313004383# Click here to: Join Microsoft Teams Meeting For Technical Support during the meeting call: 1-206-433-7155. Item Recommended Action 1. BUSINESS AGENDA a. A contract with CrowdStrike for security monitoring a. Forward to 1/23 C.O.W. Pg.1 services. Meeting and 1/23 Special Joel Bush, Chief Technology Officer Meeting Consent Agenda. b. Monthly General Fund update (October 2022). b. Discussion only. Pg.11 Tony Cullerton, Deputy Finance Director c. 2023 Committee Work Plan. c. Discussion only. Pg.15 Laurel Humphrey, Legislative Analyst 2. MISCELLANEOUS Next Scheduled Meeting: February 13, 2023 SThe City of Tukwila strives to accommodate individuals with disabilities. Please contact the City Clerk's Office at 206-433-1800 (TukwilaCityClerk@TukwilaWA.gov) for assistance. City of Tukwila Allan Ekberg, Mayor INFORMATIONAL MEMORANDUM TO: Finance & Governance Committee FROM: Technology and Innovation Services BY: Joel Bush, Chief Technical Officer CC: Mayor Ekberg DATE: January 10, 2023 SUBJECT: CrowdStrike Contract ISSUE TIS is seeking Council authorization to enter a 3 -year subscription service for Crowd Strike. BACKGROUND The TIS roadmap for the next biennium is focused on improving the City's security posture by reducing risk. Crowd Strike is an approved/funded tool used for Security Monitoring, and real- time Incident Detection Response. DISCUSSION Quote# NDTH833 is included for Council discussion and spans a period of 3 years, from the date of signing. FINANCIAL IMPACT Not to exceed $119,622.90 over three years and is a TIS budgeted expense. RECOMMENDATION The Council is being asked to discuss the contract at the 1/23/23 Committee of the Whole meeting, then forward to the 1/23/23 Special Meeting Consent Agenda, for approval. ATTACHMENTS Quote for Crowd Strike subscription services 1 2 +moi PEOPLE WHO GET IT JOEL BUSH, Thank you for choosing CDW. We have received your quote. Hardware Software Services IT Solutions Brands Research Hub Review and Complete Purchase Thank you for considering CDW•G for your technology needs. The details of your quote are below. If you are an eProcurement or single sign on customer, please log into your system to access the CDW site. You can search for your quote to retrieve and transfer back into your system for processing. For all other customers, click below to convert your quote to an order. Convert Quote to Order QUOTE # QUOTE DATE QUOTE REFERENCE CUSTOMER # GRAND TOTAL NDTH833 1/11/2023 FALCON COMPLETE 3 YR 0745164 $119,622.90 IMPORTANT - PLEASE READ Special Instructions: 3 -year contract, paid in 3 separate annual payments of $36,216.43 w/o tax, first payment due upon signing QUOTE DETAILS ITEM QTY CDW# UNIT PRICE EXT. PRICE Falcon Complete with Threat Graph Standard - subscription 300 license (1 year) Mfg. Part#: CS.FCSD.SOLN.T1.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) 6040952 $13.65 $4,095.00 Falcon Insight Endpoint Detection & Response - subscription 300 5441170 $0.00 $0.00 license (1 year Mfg. Part#: CS.INSIGHTB.SOLN.T5.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Prevent - subscription license (1 year) - 1 endpoint 300 5441174 $0.00 $0.00 Mfg. Part#: CS.PREVENTB.SOLN.T5.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Discover - subscription license (1 year) - 1 endpoint 300 5441177 $0.00 $0.00 Mfg. Part#: CS.DISCB.SOLN.T5.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Complete - subscription license (1 year) - 1 license 300 5400119 $0.00 $0.00 Mfg. Part#: CS.FALCOMPS.SVC.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA 3 4 QUOTE DETAILS (CONT.) Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Overwatch - subscription license (1 year) - 1 endpoint 300 Mfg. Part#: CS.OWB.SVC.T5.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) 5441182 $0.00 $0.00 CrowdStrike Threat Graph Standard - subscription license (1 300 5400122 $0.00 $0.00 year) - 1 licen Mfg. Part#: CS.TGB.STD.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) University LMS Subscription New Customer Access Pass - 2 5513533 $0.00 $0.00 web -based training Mfg. Part#: RR.PSO.ENT.NCAP.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Complete with HPS Threat Graph Standard - 10 6175347 $21.32 $213.20 subscription license (1 ye Mfg. Part#: CS.FCSD.HPS.SOLN.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Insight Endpoint Detection & Response - subscription 10 5441170 $0.00 $0.00 license (1 year Mfg. Part#: CS.INSIGHTB.SOLN.T5.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Prevent - subscription license (1 year) - 1 endpoint 10 5441174 $0.00 $0.00 Mfg. Part#: CS.PREVENTB.SOLN.T5.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Discover - subscription license (1 year) - 1 endpoint 10 5441177 $0.00 $0.00 Mfg. Part#: CS.DISCB.SOLN.T5.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Complete - subscription license (1 year) - 1 license 10 5400119 $0.00 $0.00 Mfg. Part#: CS.FALCOMPS.SVC.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Overwatch - subscription license (1 year) - 1 endpoint 10 5441182 $0.00 $0.00 Mfg. Part#: CS.OWB.SVC.T5.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) CrowdStrike Threat Graph Standard HPS - subscription license 10 5757208 $0.00 $0.00 (1 year) - 1 I Page 2 of 8 QUOTE DETAILS (CONT.) Mfg. Part#: CS.TGB.STD.HPS.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Complete Complimentary Customer Identification 10 6284569 subscription licen Mfg. Part#: CS.FALCOMPONBC.SOLN.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) $0.00 $0.00 CrowdStrike Express Support - technical support - for 1 4915958 $8,713.23 $8,713.23 CrowdStrike Falcon Ho Mfg. Part#: RR.HOS.ENT.EXPS.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Identity Threat Protection Complete - subscription 500 6893652 $46.39 $23,195.00 license (1 year) Mfg. Part#: CS.ITPC.SOLN.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Identity Threat Protection - subscription license (1 500 6893653 $0.00 $0.00 year) - 1 accou Mfg. Part#: CS.ITP.SOLN.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Identity Threat Protection Complete - subscription 500 6893655 $0.00 $0.00 upgrade license ( Mfg. Part#: CS.ITPCU.SOLN.12M Year 1 (Jan 27, 2023 - Jan 26, 2024) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Complete with Threat Graph Standard - subscription 300 6040952 $13.65 $4,095.00 license (1 year) Mfg. Part#: CS.FCSD.SOLN.T1.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Insight Endpoint Detection & Response - subscription 300 5441170 $0.00 $0.00 license (1 year Mfg. Part#: CS.INSIGHTB.SOLN.T5.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Prevent - subscription license (1 year) - 1 endpoint 300 5441174 $0.00 $0.00 Mfg. Part#: CS.PREVENTB.SOLN.T5.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Discover - subscription license (1 year) - 1 endpoint 300 5441177 $0.00 $0.00 Mfg. Part#: CS.DISCB.SOLN.T5.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Page 3 of 8 5 6 QUOTE DETAILS (CONT.) Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Complete - subscription license (1 year) - 1 license Mfg. Part#: CS.FALCOMPS.SVC.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) 300 5400119 $0.00 $0.00 Falcon Overwatch - subscription license (1 year) - 1 endpoint 300 5441182 $0.00 $0.00 Mfg. Part#: CS.OWB.SVC.T5.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) CrowdStrike Threat Graph Standard - subscription license (1 300 5400122 $0.00 $0.00 year) - 1 licen Mfg. Part#: CS.TGB.STD.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) University LMS Subscription New Customer Access Pass - 2 5513533 $0.00 $0.00 web -based training Mfg. Part#: RR.PSO.ENT.NCAP.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Complete with HPS Threat Graph Standard - 10 6175347 $21.32 $213.20 subscription license (1 ye Mfg. Part#: CS.FCSD.HPS.SOLN.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Insight Endpoint Detection & Response - subscription 10 5441170 $0.00 $0.00 license (1 year Mfg. Part#: CS.INSIGHTB.SOLN.T5.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Prevent - subscription license (1 year) - 1 endpoint 10 5441174 $0.00 $0.00 Mfg. Part#: CS.PREVENTB.SOLN.T5.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Discover - subscription license (1 year) - 1 endpoint 10 5441177 $0.00 $0.00 Mfg. Part#: CS.DISCB.SOLN.T5.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Complete - subscription license (1 year) - 1 license 10 5400119 $0.00 $0.00 Mfg. Part#: CS.FALCOMPS.SVC.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Overwatch - subscription license (1 year) - 1 endpoint 10 5441182 $0.00 $0.00 Mfg. Part#: CS.OWB.SVC.T5.12M Page 4 of 8 QUOTE DETAILS (CONT.) Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) CrowdStrike Threat Graph Standard HPS - subscription license 10 5757208 (1 year) - 1 1 Mfg. Part#: CS.TGB.STD.HPS.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) $0.00 $0.00 CrowdStrike Express Support - technical support - for 1 4915958 $8,713.23 $8,713.23 CrowdStrike Falcon Ho Mfg. Part#: RR.HOS.ENT.EXPS.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Identity Threat Protection Complete - subscription 500 6893652 $46.39 $23,195.00 license (1 year) Mfg. Part#: CS.ITPC.SOLN.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Identity Threat Protection - subscription license (1 500 6893653 $0.00 $0.00 year) - 1 accou Mfg. Part#: CS.ITP.SOLN.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Identity Threat Protection Complete - subscription 500 6893655 $0.00 $0.00 upgrade license ( Mfg. Part#: CS.ITPCU.SOLN.12M Year 2 (Jan 27, 2024 - Jan 26, 2025) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Complete with Threat Graph Standard - subscription 300 6040952 $13.65 $4,095.00 license (1 year) Mfg. Part#: CS.FCSD.SOLN.T1.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Insight Endpoint Detection & Response - subscription 300 5441170 $0.00 $0.00 license (1 year Mfg. Part#: CS.INSIGHTB.SOLN.T5.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Prevent - subscription license (1 year) - 1 endpoint 300 5441174 $0.00 $0.00 Mfg. Part#: CS.PREVENTB.SOLN.T5.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Discover - subscription license (1 year) - 1 endpoint 300 5441177 $0.00 $0.00 Mfg. Part#: CS.DISCB.SOLN.T5.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Page 5 of 8 7 8 QUOTE DETAILS (CONT.) Falcon Complete - subscription license (1 year) - 1 license Mfg. Part#: CS.FALCOMPS.SVC.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) 300 5400119 Falcon Overwatch - subscription license (1 year) - 1 endpoint 300 5441182 Mfg. Part#: CS.OWB.SVC.T5.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) $0.00 $0.00 $0.00 $0.00 CrowdStrike Threat Graph Standard - subscription license (1 300 5400122 $0.00 $0.00 year) - 1 licen Mfg. Part#: CS.TGB.STD.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) University LMS Subscription New Customer Access Pass - 2 5513533 $0.00 $0.00 web -based training Mfg. Part#: RR.PSO.ENT.NCAP.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Complete with HPS Threat Graph Standard - 10 6175347 $21.32 $213.20 subscription license (1 ye Mfg. Part#: CS.FCSD.HPS.SOLN.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Insight Endpoint Detection & Response - subscription 10 5441170 $0.00 $0.00 license (1 year Mfg. Part#: CS.INSIGHTB.SOLN.T5.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Prevent - subscription license (1 year) - 1 endpoint 10 5441174 $0.00 $0.00 Mfg. Part#: CS.PREVENTB.SOLN.T5.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Discover - subscription license (1 year) - 1 endpoint 10 5441177 $0.00 $0.00 Mfg. Part#: CS.DISCB.SOLN.T5.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Complete - subscription license (1 year) - 1 license 10 5400119 $0.00 $0.00 Mfg. Part#: CS.FALCOMPS.SVC.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Falcon Overwatch - subscription license (1 year) - 1 endpoint 10 5441182 $0.00 $0.00 Mfg. Part#: CS.OWB.SVC.T5.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSPO16-130652 06016) Page 6 of 8 QUOTE DETAILS (CONT.) CrowdStrike Threat Graph Standard HPS - subscription license (1 year) - 1 I Mfg. Part#: CS.TGB.STD.HPS.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSP016-130652 06016) CrowdStrike Express Support - technical support - for CrowdStrike Falcon Ho Mfg. Part#: RR.HOS.ENT.EXPS.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSP016-130652 06016) Falcon Identity Threat Protection Complete - subscription license (1 year) Mfg. Part#: CS.ITPC.SOLN.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSP016-130652 06016) Falcon Identity Threat Protection - subscription license (1 year) - 1 accou Mfg. Part#: CS.ITP.SOLN.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSP016-130652 06016) Falcon Identity Threat Protection Complete - subscription upgrade license ( Mfg. Part#: CS.ITPCU.SOLN.12M Year 3 (Jan 27, 2025 - Jan 26, 2026) Electronic distribution - NO MEDIA Contract: Washington NVP Software (ADSP016-130652 06016) 10 1 5757208 $0.00 4915958 $8,713.23 500 6893652 $46.39 500 6893653 $0.00 500 6893655 $0.00 $0.00 $8,713.23 $23,195.00 $0.00 $0.00 SUBTOTAL SHIPPING SALES TAX GRAND TOTAL $108,649.29 $0.00 $10,973.61 $119,622.90 PURCHASER BILLING INFO Billing Address: CITY OF TUKWILA ACCTS PAYABLE 6200 SOUTHCENTER BLVD TUKWILA, WA 98188-2599 Phone: (206) 433-1800 Payment Terms: Net 30 Days -Govt State/Local DELIVER TO Shipping Address: CITY OF TUKWILA JOEL BUSH 6200 SOUTHCENTER BLVD TUKWILA, WA 98188-2599 Phone: (206) 433-1800 Shipping Method: ELECTRONIC DISTRIBUTION Please remit payments to: n CDW Government 75 Remittance Drive Suite 1515 Chicago, IL 60675-1515 Sales Contact Info Mitchell Funk 1 (877) 800-3219 1 mitcfun©cdw.com LEASE OPTIONS Page 7 of 8 9 FMV TOTAL FMV LEASE OPTION BO TOTAL BO LEASE OPTION $108,649.29 $2,883.55/Month $108,649.29 $3,338.79/Month Monthly payment based on 36 month lease. Other terms and options are available. Contact your Account Manager for details. Payment quoted is subject to change. Why finance? • Lower Upfront Costs. Get the products you need without impacting cash flow. Preserve your working capital and existing credit line. • Flexible Payment Terms. 100% financing with no money down, payment deferrals and payment schedules that match your company's business cycles. • Predictable, Low Monthly Payments. Pay over time. Lease payments are fixed and can be tailored to your budget levels or revenue streams. • Technology Refresh. Keep current technology with minimal financial impact or risk. Add-on or upgrade during the lease term and choose to return or purchase the equipment at end of lease. • Bundle Costs. You can combine hardware, software, and services into a single transaction and pay for your software licenses over time! We know your challenges and understand the need for flexibility. General Terms and Conditions: This quote is not legally binding and is for discussion purposes only. The rates are estimate only and are based on a collection of industry data from numerous sources. All rates and financial quotes are subject to final review, approval, and documentation by our leasing partners. Payments above exclude all applicable taxes. Financing is subject to credit approval and review of final equipment and services configuration. Fair Market Value leases are structured with the assumption that the equipment has a residual value at the end of the lease term. Need Help? ■ My Account Support Call 800.800.4239 About Us 1 Privacy Policy 1 Terms and Conditions This order is subject to CDW's Terms and Conditions of Sales and Service Projects at http://www.cdwq.com/content/terms-conditions/product-sales.aspx For more information, contact a CDW account manager © 2023 CDW•G LLC, 200 N. Milwaukee Avenue, Vernon Hills, IL 60061 1 800.808.4239 10 Page 8 of 8 City of Tukwila Allan Ekberg, Mayor INFORMATIONAL MEMORANDUM TO: Finance & Governance Committee FROM: Tony Cullerton, Deputy Finance Director CC: Mayor Ekberg DATE: January 23, 2023 SUBJECT: October 2022 General Fund Departmental Budget -to -Actuals Report Summary The purpose of the October 2022 General Fund Financial Report is to summarize for the City Council the general state of departmental expenditures and to highlight significant items. The following provides a high-level summary of the departmental financial performance. The October 2022 report is based on financial data available as of January 12, 2022, for the period ending October 31, 2022. Additional details can be found within the included financial report. Expenditures General Fund departmental expenditures totaled $50.2 million through October, which is $1,172,628 less than the allocated budget of $51.4 million. Department 20, which is transfers to other funds, totaled $7.6 million, which is $439,641 greater than the allocated budget. This overbudgeted amount is reflective of two large transfers. One transfer for debt service and a second transfer for the budgeted Environmental Impact Statement funding in the Arterial Street Fund. The allocated budget is calculated to reflect year-to-date spending patterns of the previous year. Transfers to capital project funds are transferred to capital project funds as needed for cash flow purposes. Debt service transfers are done quarterly. In total, the General Fund reported expenditures of $57.8 million, which is equivalent to 75.6% of the annual budget at the completion of 83% of the year. At the completion of October, all General Fund departments are currently tracking expenditures below the YTD annual budget. 1 11 INFORMATIONAL MEMO Page 2 Departmental Variances Year to Date Department Expenditures Compared to Allocated Budget Through October 2022: 001 1 City Council 0031 Mayor's Office 0041 Administrative Services 005 1 Finance Department 007 1 Recreation Department 008 !Community Development (DCD) 009 1 Municipal Court 010 1 Police Department 011 1 Fire Department 0131 Public Works Dept 0151 Park Maintenance Dept 0161 Street Maintenance Dept 0201 Non Departmental 099 1 Gen Fd General Revenues Measures •Actuals ("Allocated 12 • $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 014,000 016.000 Thousands BUDGET ACTUAL Allocated Budget % 2022 2022 2020 2021 2022 vs Actual Expended EXPENDITURES BY DEPARTMENT Annual Allocated OVER/(UNDER) City Council 385,826 295,017 286,385 278,036 292,257 (2,759) 75.7% Mayor's Office 2,565,927 1,932,365 1,751,441 1,640,318 1,716,460 (215,906) 66.9% Administrative Services 5,869,141 4,431,530 3,523,481 3,895,061 3,778,683 (652,847) 64.4% Finance Department 3,347,587 2,415,148 2,032,155 2,158,329 2,661,348 246,200 79.5% Recreation Department/ Parks Maintenance 5,083,108 3,870,028 3,383,820 3,478,186 4,047,054 177,026 79.6% Community Development (DCD) 4,732,212 3,436,414 2,560,772 3,177,659 3,435,794 (620) 72.6% Municipal Court 1,597,482 1,192,126 1,038,626 1,006,290 1,290,271 98,145 80.8% Police Department 19,844,123 15,707,846 14,395,172 14,653,857 15,193,212 (514,634) 76.6% Fire Department 14,772,033 12,166,639 10,329,354 11,314,043 12,015,966 (150,673) 81.3% Public Works Dept / Street Maintenance 7,434,770 5,954,823 5,356,721 5,462,206 5,798,263 (156,560) 78.0% Subtotal 65,632,209 51,401,936 44,657,928 47,063,983 50,229,309 (1,172,628) 76.5% Non Departmental 10,885,754 7,148,504 2,929,357 3,793,874 7,588,145 439,641 69.7% Total Expenditures 76,517,963 58,550,440 47,587,285 50,857,857 57,817,454 (732,986) 75.6% % of Year 83.3% 001 1 City Council 0031 Mayor's Office 0041 Administrative Services 005 1 Finance Department 007 1 Recreation Department 008 !Community Development (DCD) 009 1 Municipal Court 010 1 Police Department 011 1 Fire Department 0131 Public Works Dept 0151 Park Maintenance Dept 0161 Street Maintenance Dept 0201 Non Departmental 099 1 Gen Fd General Revenues Measures •Actuals ("Allocated 12 • $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 014,000 016.000 Thousands INFORMATIONAL MEMO Page 3 General Fund City of Tukwila General Fund Expenditures Year -to -Date as of October 31 2022 13 BUDGET ACTUAL COMPARISON OF RESULTS 2022 Annual 2022 Allocated 2020 2021 2022 Allocated Budget vs Actuals OVER/(UNDER) % % Change Expended 2021/2022 Salaries 32,902,451 26,193,008 23,307,113 23,283,171 24,884,032 (1,308,976) 75.6% 6.9% Extra Labor 584,220 180,413 129,262 160,032 363,712 183,299 62.3% 127.3% Overtime 2,200,115 1,878,582 1,037,202 1,860,224 2,118,316 239,734 96.3% 13.9% Holiday Pay 515,500 82,875 74,739 82,875 90,234 7,360 17.5% 8.9% FICA 2,276,955 1,748,845 1,442,516 1,476,901 1,597,671 (151,174) 70.2% 8.2% Pension-LEOFF 920,517 812,080 861,511 793,828 842,652 30,573 91.5% 6.2% Pension-PERS/PSERS 1,494,905 1,178,320 1,365,742 1,285,890 1,217,009 38,689 81.4% (5.4%) Industrial Insurance 876,892 756,808 730,893 755,882 625,513 (131,295) 71.3% (17.2%) Medical & Dental 7,551,216 6,229,985 5,158,855 5,696,110 6,096,436 (133,549) 80.7% 7.0% Unemployment 0 0 63,114 36,827 37,205 37,205 - 1.0% Uniform/Clothing 8,525 2,573 1,334 2,573 2,422 (151) 28.4% (5.9%) 49,331,296 39,063,489 34,172,281 35,434,313 37,875,203 (1,188,285) 76.8% 6.9% Supplies 950,636 512,286 398,314 471,923 343,104 (169,182) 36.1% (27.3%) Repairs & Maint Supplies 299,025 207,428 249,106 181,415 269,686 62,259 90.2% 48.7% Resale Supplies 10,000 0 235 0 141 141 1.4% Null Small Tools 41,250 40,440 89,997 42,400 61,325 20,885 148.7% 44.6% Technology Supplies 13,000 13,000 41,271 63,746 39,820 26,820 306.3% (37.5%) Fleet Supplies 3,000 2,534 11,495 2,534 5,668 3,134 188.9% 123.7% 1,316,911 775,687 790,418 762,017 719,744 (55,943) 54.7% (5.5%) Professional Services 7,575,918 5,709,249 5,014,332 5,393,783 5,315,631 (393,618) 70.2% (1.4%) Communications 458,739 368,383 416,754 368,383 374,957 6,574 81.7% 1.8% Professional Development 252,921 252,921 224,103 303,367 297,279 44,358 117.5% (2.0%) Advertising 40,250 8,460 11,669 8,986 19,023 10,563 47.3% 111.7% Rentals 478,484 342,225 354,129 372,433 292,264 (49,961) 61.1% (21.5%) Technology Services 348,291 348,291 625,858 504,891 499,604 151,313 143.4% (1.0%) Utilities 2,034,285 2,034,285 1,673,448 2,011,543 2,099,398 65,113 103.2% 4.4% Repairs & Maint Services 2,185,367 1,756,613 1,033,614 1,679,061 1,864,775 108,162 85.3% 11.1% Miscellaneous 879,747 152,593 335,828 124,147 569,995 417,402 64.8% 359.1% 14,254,002 10,973,021 9,689,735 10,766,595 11,332,926 359,905 79.5% 5.3% Ca pita I Outlay -La nd 0 0 0 0 893 893 - - Machinery & Equipment 730,000 137,465 5,495 101,058 300,544 163,080 41.2% 197.4% 730,000 137,465 5,495 101,058 301,437 163,973 41.3% 198.3% Transfers Out 10,885,754 7,600,780 2,929,357 3,793,874 7,588,145 (12,634) 69.7% 100.0% 10,885,754 7,600,780 2,929,357 3,793,874 7,588,145 (12,634) 69.7% 100.0% 76,517,963 58,550,440 47,587,285 50,857,857 57,817,456 (732,985) 75.6% 13.7% 13 14 Tukwila City Council Finance & Governance Committee - 2022 Work Plan Kate Kruller, Chair; Kathy Hougardy, De'Sean Quinn Description Qtr Dept Action or Briefing Status/Notes 1. Crowd Strike Contract 1 AS A 2. Board & Commission Appointment Process 1 MO A 3. Non -rep Compensation Study Contract 1 AS A 4. PW Shops Financing and D20 Update 1 MO A 5. Honorary Naming Resolution 1 CNCL A 6. 2022 ARPA Report 1-2 FIN B 7. B&O Tax Implementation 1-4 Multiple A 8. Minimum Wage Initiative Implementation Update 2 Multiple B 9. Financial Sustainability Plan 2-4 FIN 10. Technology & Infrastructure Services Annual Report 3 AS B 11. Debt Policy 3 FIN A 12. City Council Rules of Procedure 3 CNCL A 13. Purchasing Policy Update 3 Multiple A 14. Resolution cancelling unclaimed property 3 FIN A 15. Resolution cancelling accounts receivable 3 FIN A 16. Tax Levy Legislation 4 FIN A 17. Resolution adopting 2024 Legislative Agenda 4 AS A 18. Budget Amendment Ordinance 4 FIN A 19. City-wide Fee Schedule TBD FIN A 20. Facility Plan TBD MO A 21. Land Sales TBD ED A Standard Reports/Briefings Frequency Dept. Revenue and Investment Reports Quarterly FIN Department Budget to Actual Reports Monthly FIN Committee work plan 2-4 x Council 1 City of Tukwila Updated January 17, 2023 16