HomeMy WebLinkAboutCity Council Committees - Operations Committee - 05/01/2018Unless otherwise noted, the Operations Committee meets at 4 p.m. on the first and third
Tuesday of each month in Kent City Hall, Council Chambers East, 220 Fourth Ave S, Kent, WA
98032.
For additional information please contact Jennifer Hays at 253-856-5700, or via email at
bspeterson@KentWA.gov.
Any person requiring a disability accommodation should contact the City Clerk’s
Office at 253-856-5725 in advance. For TDD relay service call Washington
Telecommunications Relay Service at 1-800-833-6388.
Operations Committee Agenda
Councilmembers: Bill Boyce – Dennis Higgins – Les Thomas, Chair
May 1, 2018
4 p.m.
Item Description Action Speaker Time
1.Call to order 1
2.Roll Call 1
3.Changes to the Agenda Yes 1
4.Excused Absence for Councilmember
Thomas – Approve
Yes 1
5.Approval of Minutes dated April 17,
2018
Yes 5
6.Approval of Check Summary Report
dated 04/01/2018 – 04/15/2018
Yes Aaron BeMiller 5
7.School Zone Traffic Safety Camera
Program Fund Expenditures -
Recommend
Yes Chief Ken Thomas 15
8.CORE Networking Routing Contract for
Technical Hardware Upgrade - Authorize
Yes James Endicott 15
9.Finance Director’s Report, Including the
March 2018 Financial Report –
Information Only
No Aaron BeMiller 10
10.Adjournment Yes 1
This page intentionally left blank.
Operations Committee
Minutes
Approval Pending
Page 1 of 2
Date: April 17, 2018
Time: 4:00 p.m.
Place: Chambers East
Attending: Les Thomas, Dennis Higgins, Bill Boyce,
Agenda:
1. Call to Order
L. Thomas called the meeting to order at 4:01
2. Roll Call.
All committee members present
3. Changes to the Agenda
No Changes
4. Approval of Check Summary Reports dated 3/16/18 thru 3/31/18
B. Boyce moved to approve the check summary report dated 3/16/18
thru 3/31/18. D. Higgins seconded the motion, which passed 3-0.
5. Approval of Meeting Minutes dated April 03, 2018
D. Higgins approved the minutes dated April 03, 2018. B. Boyce
seconded the motion, which passed 3-0.
6. 1st Quarter Procurement Report – Info only
Chief Administrative Officer Derek Matheson presented the report per the city
council adopted procurement policy. Council had no questions regarding the
report.
D. Matheson explained that when the council required the report back in 2015,
the city Council didn’t have a clear understanding of what type of contracts
were in the $25,000 - $65,000 range. Now that the committee has had time to
review those contracts, would the committee be willing to recommend to the
council to eliminate the report? D. Matheson explained that the time staff is
using to prepare the report and presentation could be better used elsewhere.
B. Boyce agreed it would be good to free up staff time for other things.
Operations Committee
Minutes
Approval Pending
Page 2 of 2
D. Higgins asked if there was a central repository for the report. D. Matheson
explained that the report is generated in the clerk’s office and easy to maintain
but it takes several hours to locate and print the back-up information.
Currently all the reports are available through a public records request and
once the Laserfiche software is available the public would be able to view it
online.
D. Matheson said he would have staff prepare an ordinance to eliminate the
report.
7. Hyas Group - Investment Consultant Services Agreement
Benefits Manager Laura Horea stated after reviewing Hyas Group’s past
performance, the Deferred Compensation Plan Committee is recommending
renewing the contract with the Hyas Group for a three-year period. This
agreement will also include work to issue a Request for Proposal and lead a
selection process to hire a third-party administrator for the City’s deferred
compensation plan.
D. Higgins wanted to know who was on the Deferred Compensation Plan
Committee and what feedback they received regarding the Hyas Group. L.
Horea responded that Derek Matheson, Aaron BeMiller, Pat Fitzpatrick and two
HR staff members were on the committee. and that when they go through the
RFP for the third party administrator that would be a good time to receive
feedback from city employees.
L. Thomas clarified that this was already an approved budget item.
D. Higgins Recommend Council authorize the Mayor to approve
renewal of the City’s agreement with the Hyas Group which will
provide Investment Consulting Services for the 457 Deferred
Compensation Plan for three years, subject to approval of final terms
and conditions with Changes by the Human Resources Director and the
City Attorney. B. Boyce seconded, which passed 3-0.
8. Adjournment.
The meeting was adjourned at 4:13 by L. Thomas.
Bonnie Peterson
Interim Operations Committee Secretary
POLICE DEPARTMENT
Ken Thomas, Police Chief
Phone: 253-856-5800
Fax: 253-856-6802
220 Fourth Avenue South
Kent, WA 98032
DATE: May 1, 2018
TO: Operations Committee
FROM: Chief Ken Thomas
SUBJECT: School Zone Traffic Safety Camera Program Fund Expenditures-Recommend
SUMMARY: The Police Department intends to implement a car-per-officer program. This
program will help with the recruitment and retention of staff. We are in a highly competitive
job market where the applicant pool for qualified police officers is incredibly small and
shrinking. Many law enforcement agencies are looking to fill vacancies. Attractive working
conditions, incentives and benefits such as car per officer programs are vital to keeping our
department competitive. The current state of police hiring is such that car per officer
programs are becoming the industry standard.
Funds from the School Zone Traffic Safety Camera program will provide the capital
investment to purchase the vehicles for this program. The department intends to complete
outfitting of the fleet over a three-year period of time. Once the vehicles are purchased, they
are expected to last considerably longer than the fleet pool program that we currently use.
A study has been conducted by the police department, city fleet services and the finance
department. Once the capital cost of the program has been made out of this fund, it is
believed that the car per officer program will be net neutral or possibly even save money for
the general fund as compared to our current pool car system.
The car per officer program will also provide for additional space in the police headquarters
building. Locker rooms will no longer be needed and can be repurposed as additional work
space area. Additional parking will also be available around city hall as a benefit.
If authorized, the department’s ability to rapidly respond to critical incidents such as active
shooters, acts of terrorism and natural disasters would be significantly improved.
Kent City Code section 9.36.140(F) requires that funds derived from the use of the traffic
safety cameras be used to first cover the costs of administering the program, with excess
funds to be used for criminal justice-related purposes. The current unbudgeted and available
balance of the fund is $876,000, and the Kent Police Department seeks approval to use
$868,000 of unbudgeted funds to cover the cost of purchasing the initial 14 take home cars.
EXHIBITS: Car Per Officer Program Cost Executive Summary
BUDGET IMPACT: Expenditure of $868,000 to come from the School Zone Traffic
Safety Camera Fund.
STRATEGIC PLAN GOAL(S):
☒ Sustainable Funding - Maximizing long-term financial success through responsible fiscal oversight, economic growth, and
community partnerships.
MOTION: Recommend Council authorize the expenditure of $868,000 from the
School Zone Traffic Safety Camera Fund, amend the budget, and authorize the
Mayor to sign all documents necessary to purchase 14 police vehicles in order to
initiate a car-per-officer program, subject to final terms acceptable to the Police
Chief and City Attorney.
This page intentionally left blank.
Car Per Officer Program Cost Executive Summary
Estimated additional cost per year for commute (less capital) $168,000
MMO per vehicle reduced to $3700/year
Reserve per vehicle reduced to $8800/year
There will be cost savings in lower maintenance required, less services required per vehicle, lower
reserve per year based on longer life cycle, less fuel consumption, less collision damage that
compensate for commute costs.
Cost Comparison:
There will be an initial cost increase with capital expense but program will have cost savings over time:
Currently we have 41 vehicles that cost $21,500 per year (operation/maintenance/replacement reserve)
Completed program (estimated at 3 years) would have 70 vehicles that cost $12,500 per year
(operation/maintenance/replacement reserve)
41 vehicles @ $21.5k= $881,500
70 vehicles @ $12.5K= $875,000
Start up:
1st Year 14 additional vehicles purchased at $62,000 each=$868,000
Reserve cost for 14 additional vehicles is $124,000
Operating cost for 14 additional vehicles is $51,800
Total Start Up Cost For First Year= $1,043,800
0
1
2
3
4
5
Year 1 Year 2 Year 3 Year 4
Current
New
This page intentionally left blank.
INFORMATION TECHNOLOGY DEPARTMENT
Mike Carrington, Director
Phone: 253-856-4607
Fax: 253-856-4700
Address: 220 Fourth Avenue S.
Kent, WA. 98032-5895
DATE: May 01, 2018
TO: Operations Committee
FROM: James Endicott, Information Technology Technical Services Manager
SUBJECT: CORE Networking Routing contract for technical hardware
upgrade - Recommendation
MOTION: Recommend the City Council authorize the Mayor to purchase
technology equipment through the cooperative purchasing agreement the
state Department of Enterprise Services has with Cisco Systems, Inc., if those
purchases are within the City’s established budgets and made during the term
of the state contract, which is current through March 31, 2019, and any later
contract extensions the state may authorize.
SUMMARY:
The City has entered into an agreement with the state Department of Enterprise Services
(“DES”), which allows the City to purchase through contracts the state publically bids and
enters into with various vendors. The state has, in turn, entered into an agreement with a
national purchasing cooperative, the NASPO Cooperative Purchasing Organization, LLC,
which is a non-profit subsidiary of the National Association of State Procurement Officials
(“NASPO”). NASPO provides states, local governments, public educational entities and
other agencies with purchasing power that allows them to leverage their spending through
a single solicitation that obtains best value pricing and superior contract terms than the
agencies could do on their own. Purchasing goods and services through a public
purchasing cooperative satisfies the competitive bid requirements established by Council
under KCC 3.70.110(F).
One contract that NASPO has entered into, and which the state DES has elected to
participate in, is a contract with Cisco Systems, Inc. (“Cisco”). This contract is currently in
effect through May 31, 2019. However, the contract allows for extensions of that term
should NASPO, and ultimately DES, consent to that extension. Should the City purchase
through Cisco under these contracts, the terms and conditions of the contract to which the
state DES has agreed will control, and a copy of that complete contract is attached.
Cisco provides intent-based networking hardware and software that include advanced
analytics, application optimization, automated provisioning, and integrated security to
deliver a complete, proven solution. On March 1, 2018, while staff was working to
prepare this matter for review and consideration by Council, core network routers
failed, which created an emergency need to order replacement core network routers.
As authorized under KCC 3.70.110(B), the Mayor issued a written finding declaring the
existence of the emergency, which authorized staff to immediately order core network
routers. This order was placed on March 8, 2018, under the state DES contract, in a
total amount of $255,211.28. This order is expected to arrive on May 8, 2018.
Although Council ratification of that order is not required due to the emergency that
occurred, staff would like Council to authorize the continued purchase of future
hardware and software through Cisco under the state DES contract throughout the
term of that contract, so long as those future purchases are within budgets previously
established by Council and made during the term of the state DES contract with Cisco.
EXHIBITS:
A. Product Matrix
B. Washington State DES Master Agreement
C. Washington NASPO Valuepoint Contract
D. Presidio Quote
E. Presidio-CISCO-Core Infrastructure Upgrade-PO144186 Signed
BUDGET IMPACT:
1. Expenditures
Item Price
Location 1 Hardware and Licensing $118,336.18
Location 2 Hardware and Licensing $87,481.18
Location 3 Hardware $26, 145.00
Subtotal $231,962.36
Shipping $47.89
Tax $23,201.03
Total $255,211.28
STRATEGIC PLAN GOAL(S):
☒ Sustainable Funding - Maximizing long-term financial success through responsible
fiscal oversight, economic growth, and community partnerships.
☒ Innovative Government - Empowering responsible citizen engagement, providing
outstanding customer service, leveraging technologies, and fostering new opportunities
and industries that benefit our community.
Product Matrix
Cisco HPE Huawei Juniper
Investment Protection with Custom
Silicon
Fully Capable:
Cisco custom silicon helps ensure
enterprise feature robustness,
platform longevity, and investment
protection.
Limited:
Multiple vendor acquisition history
makes the product lines
inconsistent, with short life spans.
A majority of switching platforms
are merchant siliconbased with
limited flexibility.
Limited:
Huawei ENP lags in terms of
capability when compared with
the Cisco UADP. Huawei is missing
high-speed stacking interface, lacks
performance and
flexibility, lacks packetprocessing
flexibility, and is short on full
visibility of data flows.
Not Available
Digital Network Architecture Fully Capable:
Cisco DNA is an open and
extensible software-based
architecture that accelerates and
optimizes enterprise network
operations.
Not Available Not Available Not Available
Multigigabit Technology Fully Capable:
Cisco Catalyst Multigigabit
Technology can prepare customers’
access networks for
future innovations by delivering
speeds of 1G, 2.5G, and 5G on
existing Category 5e/6 cables.
Limited:
HPE offers equivalent multigigabit
technology, with SmartRate limited
to a couple of product
platforms and a limited number of
ports.
Limited:
Multigigabit up to 2.5G only in
some switch models.
Not Available
Application Visibility and Control Fully Capable:
Cisco Access switches can insp
traffic and application flows to
enforce network access policy
and protect again attacks with
Cisco Flexible NetFlow, DNS-AS,
NBAR,and Cisco Prime
Infrastructure
Limited:
HPE switching platforms are limited
to simple, basic traffic
classifications and policy
enforcement with ACL. These
platforms are also limited by their
lack of memory capacity in access
switching.
Limited:
Limited SLA monitoring with
Huawei iPCA.
Not Available
Converged Infrastructure:
Consistent Automation Across
WAN, WLAN and Wired Networks
Fully Capable:
Use Cisco Prime Infrastructure to
centrally provision WAN path
selection with IWAN and security,
encryption, app visibility, and
control with APIC-EM and Cisco
TrustSec.
Limited:
HPE uses SDN controllers and
AirWave for automated
deployment of infrastructure of
Aruba switches only. For a single
pane of glass, HPE uses IMC for the
original HPE switches but does not
support AirWave.
Limited:
Huawei’s SVF does not provide true
network convergence.
Not Available
Monitoring by Endpoint Type Fully Capable:
Cisco can use analytics to monitor
behavior with Stealthwatch and
NetFlow, and classify traffic on the
edge and inside the network with
TrustSec.
Limited:
Aruba offers very limited
functionality. Tunneled Node is
offered as a catch-all solution that
cannot scale.
Limited:
iPCA is offered as an option but
provides limited platform support
and visibility.
Not Available
Support New Capabilities Without
Major Upgrades
Fully Capable:
Through the integration of custom
ASICs, UADP, and access point
modularity, Cisco offers support for
new innovations.
Limited:
No support for modular APs.
Switching platforms use a custom
ASIC with limited extensibility.
Limited:
No current support for modular
access points that support
locationbased analytics and
beacons/BLE.
Not Available
Improve Experience for Apple
Users
Fully Capable:
Cisco and Apple
have joined efforts
to provide better
user experiences for
Apple device users
connected to a Cisco
network.
Limited:
Functionality can only be
supported through manual QoS
prioritization and Wi-Fi standards.
Limited:
Functionality can be supported
only through manual QoS
prioritization.
Not Available
High Availability Fully Capable:
Cisco switches offer innovative
ISSU features and hot standby N+1
redundancy in stacks
Not Available Limited:
Huawei claims ISSU on
some of its switches.
Not Available
Product Matrix
Consistent Application
Performance Across the Network
Fully Capable:
Through bestpractices, the
EasyQoS application provides
customers with a simplified
method of delivering end-to-end
QoS.
Not Available Not Available Not Available
Detect and Set Features to New
Devices
Fully Capable:
Through Cisco Auto Smartports,
devices are dynamically
detected and ports are configured
based on the device type detected
on the port.
Limited:
HPE can detect and set
characteristics on an AP attaching
to an HPE switch, but cannot
detect other types of devices.
Not Available Not Available
Power Resiliency for IOT and Other
Devices
Fully Capable:
Cisco offers Persistent PoE and Fast
PoE and Universal PoE while
providing multiplelevel redundancy
through StackPower.
Limited:
HPE offers basic PoE/PoE+ (30W)
support, and supplies 1:1 power
redundancy via dual power
supplies supported in a limited
number of switches.
Limited:
Huawei supports PoE and PoE+
PoH (95W) on a single S5700
platform. Power redundancy is 1:1
PoH (power over HDMI) (95W) on a
single S5700 platform.
Not Available
Integrated Security Fully Capable:
Cisco switches offer advanced
security features like Cisco
Encrypted Traffic Analytics (ETA),
TrustSec, Network as a Sensor
(NaaS), Network as an Enforcer
(NaaE), mDNS Gateway, and 256-
bit MACsec.
Not Available Not Available Not Available
Threat Detection Fully Capable:
Eliminate threats across the
network with Cisco’s effective
security solutions. Products include
Encrypted Traffic
Analytics (ETA), Stealthwatch,
TrustSec, Identity Services Engine,
and Rapid Threat Containment.
Limited:
HPE offers sFlow, ClearPass, and
Tunneled Node to support security
across wired and wireless.
Not Available Not Available
Intent-Based Networking for
Availability, Agility and Policy
Segmentation
Fully Capable:
Centralize and automate network
design, policy, and provisioning of
all wired and wireless networks
with Cisco DNA Center.
Limited:
Aruba Tunneled Node is offered as
a catchall solution, but it cannot
scale.
Not Available Not Available
2003218800199-04QUOTE:
02/27/2018DATE:
PAGE:1 of 4
FROM:Presidio Networked Solutions Group, LLC
Sokha Hay
10655 NE 4th Street
Suite 212
Bellevue, WA 98004
shay@presidio.com
(p) 425.468.8920
TO:City of Kent, WA
James Endicott
220 Fourth Avenue South
KENT, WA 98032
JEndicott@kentwa.gov
(p) 253-856-4620
SHIP TO:City of Kent
James Endicott
220 4th Avenue South
Kent, WA 98032
JEndicott@kentwa.gov
(p) 253-856-4620
BILL TO:City of Kent, WA
Accounts Payable
220 4th Avenue South
KENT, WA 98032
AP@kentwa.gov
(p) .
Peter Alpiger
Sokha Hay
Title:
Inside Sales Rep:
Account Manager:
Core Replacement
Contract Vehicle:Washington NASPO ValuePoint Cisco AR233 (14-19)
WA #01114
Customer#:CITYO594
Comments:Pricing shown here is valid for 60 days from the date shown on the quote.
#Part #Description Unit Price Ext PriceQty
Location 1
C9410R
1 C9410R Cisco Catalyst 9400 Series 10 slot chassis 1 $4,080.00$4,080.00
2 C9400-NW-A Cisco Catalyst 9400 Network Advantage License 2 $0.00$0.00
3 C9400-S-BLANK Cisco Catalyst 9400 Series Slot Blank Cover 4 $0.00$0.00
4 C9400-PWR-BLANK Cisco Catalyst 9400 Series Power Supply Blank Cover 6 $0.00$0.00
5 S9400UK9-166 Cisco Catalyst 9400 XE 16.6 Universal image 1 $0.00$0.00
6 C9400-PWR-3200AC Cisco Catalyst 9400 Series 3200W AC Power Supply 2 $2,040.00$1,020.00
7 CAB-C19-CBN Cabinet Jumper Power Cord, 250 VAC 16A, C20-C19 Connectors 2 $0.00$0.00
8 CAB-CON-C9K-RJ45 Console Cable 6ft with RJ-45-to-RJ-45 1 $0.00$0.00
9 C1A1TCAT94001 Cisco ONE Advantage Term, C9400 1 $0.00$0.00
10 C1A1TCAT94001-3Y C1 Advantage Term C9400 3Y - DNA, 100 ISE PLS, 100 SWATCH 1 $8,160.00$8,160.00
11 C1-C9400-DNAA-T Cisco ONE C9400 DNA Advantage Term licenses 1 $0.00$0.00
12 C1-C9400-TRK-3Y Cisco ONE Term SKU 3Y 1 $0.00$0.00
13 C1-SWATCH-T Cisco ONE StealthWatch License Term - 1 Flow License 100 $0.00$0.00
14 C1-SWATCH-TRK-3Y Cisco ONE Subscription SWATCH SKU 3Y 100 $0.00$0.00
15 C1-ISE-PLS-T Cisco ONE ISE PLUS License Term 100 $0.00$0.00
16 C1-ISE-PLS-TRK-3Y Cisco ONE Subscription SKU ISE Plus 3Y 100 $0.00$0.00
2003218800199-04QUOTE:
02/27/2018DATE:
PAGE:2 of 4
17 C1-ISE-BASE-T Cisco ONE ISE BASE License Term 100 $0.00$0.00
18 C1-ISE-BASE-TRK-3Y Cisco ONE Subscription ISE BASE 3Y 100 $0.00$0.00
19 C9400-SUP-1XL Cisco Catalyst 9400 Series Supervisor 1XL Module 1 $9,690.00$9,690.00
20 C9400-SUP-1XL/2 Cisco Catalyst 9400 Series Redundant Supervisor 1XL Module 1 $9,690.00$9,690.00
21 C9400-LC-48T Cisco Catalyst 9400 Series 48-Port 10/100/1000 (RJ-45)1 $3,570.00$3,570.00
22 C9400-LC-48T Cisco Catalyst 9400 Series 48-Port 10/100/1000 (RJ-45)1 $3,570.00$3,570.00
23 C9400-LC-24XS Cisco Catalyst 9400 Series 24-Port 10 Gigabit Ethernet(SFP+)1 $12,240.00$12,240.00
24 C9400-LC-24XS Cisco Catalyst 9400 Series 24-Port 10 Gigabit Ethernet(SFP+)1 $12,240.00$12,240.00
25 CON-SNTP-C9410R SNTC-24X7X4 Cisco Catalyst 9400 1
for 36 mo(s)
$15,148.68$15,148.68
$80,428.68Total:
SFP-10G-LR=
26 SFP-10G-LR=10GBASE-LR SFP Module 13 $25,967.50$1,997.50
$25,967.50Total:
SFP-10G-SR=
27 SFP-10G-SR=10GBASE-SR SFP Module 24 $11,940.00$497.50
$11,940.00Total:
$118,336.18Total (Location 1):
Location 2
C9410R
28 C9410R Cisco Catalyst 9400 Series 10 slot chassis 1 $4,080.00$4,080.00
29 C9400-NW-A Cisco Catalyst 9400 Network Advantage License 2 $0.00$0.00
30 C9400-S-BLANK Cisco Catalyst 9400 Series Slot Blank Cover 3 $0.00$0.00
31 C9400-PWR-BLANK Cisco Catalyst 9400 Series Power Supply Blank Cover 6 $0.00$0.00
32 S9400UK9-166 Cisco Catalyst 9400 XE 16.6 Universal image 1 $0.00$0.00
33 C9400-PWR-3200AC Cisco Catalyst 9400 Series 3200W AC Power Supply 2 $2,040.00$1,020.00
34 CAB-C19-CBN Cabinet Jumper Power Cord, 250 VAC 16A, C20-C19 Connectors 2 $0.00$0.00
35 CAB-CON-C9K-RJ45 Console Cable 6ft with RJ-45-to-RJ-45 1 $0.00$0.00
36 C1A1TCAT94001 Cisco ONE Advantage Term, C9400 1 $0.00$0.00
37 C1A1TCAT94001-3Y C1 Advantage Term C9400 3Y - DNA, 100 ISE PLS, 100 SWATCH 1 $8,160.00$8,160.00
38 C1-C9400-DNAA-T Cisco ONE C9400 DNA Advantage Term licenses 1 $0.00$0.00
39 C1-C9400-TRK-3Y Cisco ONE Term SKU 3Y 1 $0.00$0.00
40 C1-SWATCH-T Cisco ONE StealthWatch License Term - 1 Flow License 100 $0.00$0.00
41 C1-SWATCH-TRK-3Y Cisco ONE Subscription SWATCH SKU 3Y 100 $0.00$0.00
42 C1-ISE-PLS-T Cisco ONE ISE PLUS License Term 100 $0.00$0.00
2003218800199-04QUOTE:
02/27/2018DATE:
PAGE:3 of 4
43 C1-ISE-PLS-TRK-3Y Cisco ONE Subscription SKU ISE Plus 3Y 100 $0.00$0.00
44 C1-ISE-BASE-T Cisco ONE ISE BASE License Term 100 $0.00$0.00
45 C1-ISE-BASE-TRK-3Y Cisco ONE Subscription ISE BASE 3Y 100 $0.00$0.00
46 C9400-SUP-1XL Cisco Catalyst 9400 Series Supervisor 1XL Module 1 $9,690.00$9,690.00
47 C9400-SUP-1XL/2 Cisco Catalyst 9400 Series Redundant Supervisor 1XL Module 1 $9,690.00$9,690.00
48 C9400-LC-48T Cisco Catalyst 9400 Series 48-Port 10/100/1000 (RJ-45)1 $3,570.00$3,570.00
49 C9400-LC-48T Cisco Catalyst 9400 Series 48-Port 10/100/1000 (RJ-45)1 $3,570.00$3,570.00
50 C9400-LC-24XS Cisco Catalyst 9400 Series 24-Port 10 Gigabit Ethernet(SFP+)1 $12,240.00$12,240.00
51 C9400-LC-24XS Cisco Catalyst 9400 Series 24-Port 10 Gigabit Ethernet(SFP+)1 $12,240.00$12,240.00
52 C9400-LC-48T Cisco Catalyst 9400 Series 48-Port 10/100/1000 (RJ-45)1 $3,570.00$3,570.00
53 CON-SNTP-C9410R SNTC-24X7X4 Cisco Catalyst 9400 1
for 36 mo(s)
$15,148.68$15,148.68
$83,998.68Total:
SFP-10G-SR=
54 SFP-10G-SR=10GBASE-SR SFP Module 7 $3,482.50$497.50
$3,482.50Total:
$87,481.18Total (Location 2):
Location 3
WS-X4712-SFP+E=
55 WS-X4712-SFP+E=Catalyst 4500 E-Series 12-Port 10GbE (SFP+)1 $14,172.50$14,172.50
56 SFP-10G-SR 10GBASE-SR SFP Module 7 $3,482.50$497.50
57 SFP-10G-LR 10GBASE-LR SFP Module 4 $7,990.00$1,997.50
$25,645.00Total:
GLC-SX-MMD=
58 GLC-SX-MMD=1000BASE-SX SFP transceiver module, MMF, 850nm, DOM 2 $500.00$250.00
$500.00Total:
$26,145.00Total (Location 3):
Sub Total:$231,962.36
$47.89Shipping:
Estimated Tax:$23,201.03*** Any Tax & Freight Charges will be added/amended at time of billing, as applicable. Sales tax and shipping are estimated and
subject to change.
Grand Total:$255,211.28
2003218800199-04QUOTE:
02/27/2018DATE:
PAGE:4 of 4
This quote is governed by Terms and Conditions of NAPSO ValuePoint Cisco Contract AR233 (14-19) Washington Contract #01114
Standard-Terms-for-Purchase-of-Services or Goods
Quote valid for 30 days from date shown above.
Prices may NOT include all applicable taxes and shipping charges
All prices subject to change without notice. Supply subject to availability.
Purchase Order should be issued to:
Presidio Networked Solutions Group, LLC
1955 Lakeway Drive, Suite 220
Lewisville, TX 75057
Pursuant to this contract your PO must reflect the following contract #:
NASPO ValuePoint Cisco/IronPort Contract AR233 (14-19) Washington Contract #01114
Tax ID# 58-1667655; Size Business: Large; CAGE Code: OKDO5; DUNS#15-405-0959; CEC 15-506005G
Credit: Net 30 days (all credit terms subject to prior Presidio credit department approval)
Delivery: FOB Terms Dictated by individual PO details.
Customer hereby authorizes and agrees to make timely payment for products delivered and services
rendered, including payments for partial shipments
Customer Signature Date
Gity of Kent Purchase Order
Order number must appear on all invoices, packages, etc.
This document is hereby deemed a valid purchase order and authorizes the procurement
of the materials and/or services indicated. Please let us know immediately if you are unableto ship the complete order.
Ship to: City of Kent
lnformation Technology
400 West Gowe Street
Suite 122
Kent, WA 98032
Bill to: City of Kent
Accounts Payable
220 4lh Avenue South
Kent, WA 98032
Phone: (253) 856-5230
Order #: 144186 OP
Order Date: 31812018
Ordered By: MarthaF Gonzalez
Info Tech-Tech Services
Vendor: 800752
Presidio Networked Solutions Group, LLC
PO Box 677638
Dallas, TX 75267-7638
KENT
!^,As.ttNGTa\
TotalCost
4,488.00
2,244.00
8,976.00
10,659.00
10,659.00
3,927.00
3,927.00
13,464.00
13,464.00
16,663.55
28,564.25
13,134.00
4,488.00
2,244.00
8,976.00
10,659.00
10,659.00
3,927.00
3,927.00
13,464.00
13,464.00
3,927.00
16,663.55
Sales Tax
408.00
204.00
816.00
969.00
969.00
357.00
357.00
1,224.00
1,224.00
1,514.87
2,596.75
't ,1 94.00
408.00
204.00
816.00
969.00
969.00
357.00
357.00
1,224.00
1,224.00
357.00
1,514.87
Ext. Cost
4,080.00
2,040.00
8,160.00
9,690.00
9,690.00
3,570.00
3,570.00
12,240.00
12,240.00
15,148.68
25,967.50
11,940.00
4,080.00
2,040.00
8,160.00
9,690.00
9,690.00
3,570.00
3,570.00
12,240.00
12,240.O0
3,570.00
15,148.68
Unit Gost
4,080.00
1,020.00
8,160.00
9,690.00
9,690.00
3,570.00
3,570.00
12,240.00
12,240.O0
15,148.68
1,997.50
497.50
4,080.00
1,020.00
8,160.00
9,690.00
9,690.00
3,570.00
3,570.00
12,240.O0
12,240.00
3,570.00
15,148.68
Quantity
1
2
1
1
1
1
1
1
1
1
13
24
1
2
1
1
1
1
1
1
1
1
I
Description
Cisco Cataylst 9400 | Series 10 Slot Chassis Loc 1
Cisco Cataylst 9400 Series | 3200W AC power Supply
C1 Advantage Term C9400 3Y I DNA,100 ISE pLS, 100 Swatch
Cisco Cataylst 9400 Series I Supervisor 1XL Module
Cisco Cataylst 9400 Series I Supervisor Redund 1XL Module
Cisco Cataylst 9400 Series | 48-Port 10/100/1000(RJ-45)
Cisco Cataylst 9400 Series | 4S-Port 10/100/1000(RJ-45)
Cisco Cataylst 9400 Series 124-Port 10 Gigabit Eth (SFp+)
Cisco Cataylst 9400 Series | 24-Port 1 0 Gigabit Eth (SFp+)
SNTC-24X7X4 Cisco I Catalyst 9400 for 36 mo(s)
l0GBASE-LR I SFP Module
lOGBASE-SR ISFP Module
Cisco Cataylst 9400 Series | 10 Slot Chassis- Loc 2
Cisco Cataylst 9400 Series | 3200W AC Power Supply
Cl Advantage Term C9400 3Y I DNA,100 tSE pLS, 100 Swatch
Cisco Cataylst 9400 Series I Supervisor 1XL Module
Cisco Cataylst 9400 Series I Redund Supervisor 1XL Module
Cisco Cataylst 9400 Series | 48-Port 10/100/1000(RJ-45)
Cisco Cataylst 9400 Series 148-Port 10/100/1000(RJ-45)
Cisco Cataylst 9400 Series | 24-Port 1 0 Gigabit Eth (SFp+)
Cisco Cataylst 9400 Series 124-Port 10 Gigabit Eth (SFp+)
Cisco Cataylst 9400 Series 148-Port 10/100/1000(RJ-45)
SNTC-24X7X4 Cisco I Catalyst 9400 for 36 mo(s)
Item #
c9410R
c9400-PWR-320oAC
c1A1TCAT94001-3Y
c9400-suP-1xL
c9400-suP-1xL/2
c9400-Lc-487
c9400-Lc-487
c9400-LC-24XS
c9400-Lc-24XS
CON-SNTP-C941OR
SFP-1OG-LR=
SFP-10G-LR=
c9410R
c9400-PWR-3200AC
c1A1TCAT94001-3Y
c9400-suP-1xL
c9400-suP-1xL/2
c9400-Lc-487
c9400-Lc-487
c9400-Lc-24XS
c9400-LC-24XS
c9400-Lc-487
CON-SNTP-C941OR
Line
1
2
3
4
5
6
7
8
o
10
11
12
13
14
15
16
17
18
19
20
21
22
23
KENT
Gity of Kent Purchase Order Order #: 144186 OP
Order number must appear on all invoices, packages, etc. Order Date: 3lBl2O18
Total Cost
3,830.75
15,589.75
3,830.75
8,789.00
550.00
52.68
Subtotal:232,010.25
Sales Tax:23,201.03
Total:255,211.29
Sales Tar
348.25
1,417.25
348.25
799.00
50.00
4.79
Ext. Cost
3,482.50
14,172.50
3,482.50
7,990.00
500.00
47.89
Unit Cost
497.50
14,172.50
497.50
1,997.50
250.00
47.89
Quantity
7
1
7
4
2
1
Description
l0GBASE-SR ISFP Module
Catalyst 4500 E-Series | 12-Port 10GbE(SFP+)
l0GBASE-SR ISFP Module
l0GBASE-LR I SFP Module
1 0OOBASE-SX SFP transceiver I module, MMF,850nm, DOM
SHIPPING & HANDLING
w HD#54432 | Q#200321 8800 1 99-04
Washington NASPO ValuePoint I Cisco AR233(14-19)WA#01 1 14
Item #
SFP-10G-SR=
WS-X4712-SFP1+E=
SFP-1OG-SR
SFP-1OG-LR
GLC-SX-MMD=
S/H
Line
24
25
26
27
28
29
30
31
Approved by: Carrington, Michael Charles
Mayor's Signature:
(Required for r $10,000)
FINANCE DEPARTMENT
Aaron BeMiller, Director
Phone: 253-856-5260
Fax: 253-856-6255
220 Fourth Avenue S.
Kent, WA. 98032-5895
DATE: May 3, 2018
TO: Kent City Council Operations Committee
FROM: Aaron BeMiller, Finance Director
SUBJECT: Director’s Report, Including the March 2018 Financial Report
SUMMARY: The Finance Director will report out financial or operating items,
including the March 2018 financial report.
EXHIBITS: March 2018 Monthly Financial Report
STRATEGIC PLAN GOAL(S):
☒ Sustainable Funding - Maximizing long-term financial success through responsible fiscal oversight, economic growth, and
community partnerships.
Information Only
This page intentionally left blank.
2018
Adj Budget
2018
YTD
2018
Est Actual
Variance
Favorable
(Unfavorable)
%Variance
Favorable
(Unfavorable)
Revenues 103,130,990 18,695,007 104,174,000 1,043,010 1.0%
Expenditures 103,315,657 19,798,093 103,357,873 (42,216) 0.0%
Net Revenues Less Expenditures (184,667) (1,103,086) 816,127 1,000,794
Beginning Fund Balance 21,595,175 21,595,175
Ending Fund Balance 21,410,508 22,411,302
Ending Fund Balance Detail:
General Fund Reserves 20,469,758 21,794,742
19.8% 21.1%
Restricted for Annexation 940,750 616,560
Revenue Overview
Expenditures Overview
Required Ending Fund Balance Calculation
Estimated Expenditures for 2018 (from above)103,357,873
18.0%
18% GF Ending Fund Balance 18,604,417
March 2018 Monthly Financial Report
City of Kent, Washington
General Fund Overview
Summary
Analysis through March shows an overall positive budget variance of $1 million.
The budgeted use of fund balance is offset by the positive budget variance of $1 million, creating a net surplus of
$0.8m.
General Fund Reserves are estimated to end the year at $21.8 million, or 21.1% of estimated 2018 expenditures.
Revenues are estimated to end the year approximately $1 million (1%) higher than budgeted.
Through March, all departments are remaining fairly close to budget with an overall favorable budget variance of $0
million or 0%.
Revenue Categories 2018
Adj Budget
2018
YTD
2018
Est Actual
Variance
Favorable
(Unfavorable)
%Variance
Favorable
(Unfavorable)
Taxes:
Property 29,532,710 948,899 29,322,000 (210,710) -0.7%
Sales & Use 21,100,310 5,615,332 21,362,570 262,260 1.2%
Utility 19,150,880 5,349,794 19,242,780 91,900 0.5%
Business & Occupation 8,890,480 25,207 8,441,410 (449,070) -5.1%
Other 879,260 12,204 883,000 3,740 0.4%
Licenses and Permits 5,695,870 1,766,569 6,163,570 467,700 8.2%
Intergovernmental Revenue 7,946,370 1,940,906 8,016,410 70,040 0.9%
Charges for Services 5,844,610 2,265,641 6,694,540 849,930 14.5%
Fines and Forfeitures 1,565,970 271,651 1,364,640 (201,330) -12.9%
Miscellaneous Revenue 1,574,530 498,803 1,733,080 158,550 10.1%
Transfers In 950,000 - 950,000 -
Total Revenues 103,130,990 18,695,007 104,174,000 1,043,010 1.0%
March 2018 Monthly Financial Report
City of Kent, Washington
General Fund Overview - Revenues
Variance analysis for revenues is provided for particular line items or those in which the estimated actual amount
differs from the budgeted amount by at least 10% or minimum of $500,000.
Variance Notes
Charges & Services: $850k increase over budget due to higher Planning Development Service Charges in January
($234k), February ($500k), and March ($220k) than budgeted, offset by decreases in Public Safety Charges of
(80k).
Property Taxes
28%
Sales Taxes
21%
Utility Taxes
18%
B&O Taxes
8%Other Taxes
1%
Licenses and Permits
6%
Intergovernmental
8%
Charges for Services
6%
Fines & Forfeits 2%
Misc & Transfers In
3%
Other
24%
2018 Estimated
Revenues
Prior Year
Revenues
Budgeted
Revenues
Actual
Revenues
January 5,578 6,021 5,721
February 5,024 5,516 5,542
March 7,586 8,148 7,432
April 17,008 16,729 0
May 6,492 7,431 0
June 6,175 6,633 0
July 7,351 6,916 0
August 5,581 5,633 0
September 6,738 7,301 0
October 15,494 16,964 0
November 6,875 6,659 0
December 11,017 9,180 0
Total 100,919 103,131 18,695
Prior Year
Revenues
Budgeted
Revenues
Actual
Revenues
January 0 11 0
February 197 224 213
March 711 966 736
April 9,768 11,775 0
May 1,324 2,345 0
June 109 160 0
July 26 56 0
August 85 107 0
September 561 665 0
October 8,610 11,300 0
November 1,361 1,668 0
December 249 256 0
Total 23,000 29,533 949
Prior Year
Revenues
Budgeted
Revenues
Actual
Revenues
January 1,686 1,610 1,761
February 1,986 2,056 2,045
March 1,550 1,560 1,810
April 1,547 1,553 0
May 1,836 1,781 0
June 1,587 1,456 0
July 1,739 1,724 0
August 1,964 1,918 0
September 1,693 1,771 0
October 1,783 1,765 0
November 1,841 1,916 0
December 1,898 1,992 0
Total 21,109 21,100 5,615
March 2018 Monthly Financial Report
City of Kent, Washington
General Fund Revenues ($ in Thousands)
All Revenues Sources
Property Tax
Sales Tax
$0
$20,000
$40,000
$60,000
$80,000
$100,000
$120,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
18 Bud 17 Act 18 Act
$0
$5,000
$10,000
$15,000
$20,000
$25,000
$30,000
$35,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
18 Bud 17 Act 18 Act
$0
$5,000
$10,000
$15,000
$20,000
$25,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
18 Bud 17 Act 18 Act
March 2018 Monthly Financial Report
City of Kent, Washington
General Fund Revenues ($ in Thousands)
Prior Year
Revenues
Budgeted
Revenues
Actual
Revenues
January 1,842 2,052 1,860
February 1,829 1,675 1,771
March 1,739 1,606 1,719
April 1,873 1,817 0
May 1,566 1,486 0
June 1,505 1,363 0
July 1,631 1,707 0
August 1,479 1,434 0
September 1,574 1,674 0
October 1,536 1,498 0
November 1,535 1,443 0
December 1,540 1,396 0
Total 19,648 19,151 5,350
Prior Year
Revenues
Budgeted
Revenues
Actual
Revenues
January 1 6 1
February 4 24 3
March 494 265 33
April 1,945 1,888 0
May 232 338 0
June 153 123 0
July 1,984 1,753 0
August 185 364 0
September 8 92 0
October 1,950 1,965 0
November 578 358 0
December 2,509 2,595 0
Total 10,042 9,770 37
Prior Year
Revenues
Budgeted
Revenues
Actual
Revenues
January 2,049 1,697 2,099
February 1,008 948 1,510
March 3,092 2,765 3,135
April 1,876 1,597 0
May 1,534 1,519 0
June 2,820 2,980 0
July 1,969 1,610 0
August 1,868 1,467 0
September 2,902 2,758 0
October 1,615 1,931 0
November 1,561 1,195 0
December 4,821 3,110 0
Total 27,119 23,577 6,744
Utility Tax
Other Taxes
Other Revenues
(Intergovernmental, Licenses & Permits, Charges for Service, Fines & Forfeits, and Misc Revenues)
$0
$5,000
$10,000
$15,000
$20,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov
18 Bud 17 Act 18 Act
$0
$2,000
$4,000
$6,000
$8,000
$10,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
18 Bud 17 Act 18 Act
$0
$5,000
$10,000
$15,000
$20,000
$25,000
$30,000
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
18 Bud 17 Act 18 Act
Department 2018
Adj Budget
2018
YTD
2018
Est Actual
Variance
Favorable
(Unfavorable)
%Variance
Favorable
(Unfavorable)
City Council 409,150 101,630 403,300 5,850 1.4%
Mayor's Office/City Clerk 3,052,700 701,393 2,968,100 84,600 2.8%
Economic & Community Dev 7,172,680 1,676,350 7,105,200 67,480 0.9%
Finance 2,965,590 717,355 3,014,900 (49,310) -1.7%
Fire Contracted Services 3,657,530 815,821 3,730,236 (72,706) -2.0%
Human Resources 2,108,520 479,139 2,076,100 32,420 1.5%
Information Technology 519,450 128,182 519,977 (527) -0.1%
Law 1,766,540 441,608 1,784,100 (17,560) -1.0%
Municipal Court 3,347,420 814,420 3,356,700 (9,280) -0.3%
Parks, Recreation & Comm Svcs 18,419,757 3,824,234 18,397,300 22,457 0.1%
Police 38,821,390 9,718,264 38,965,000 (143,610) -0.4%
Public Works 1,318,470 273,924 1,280,500 37,970 2.9%
Non-Departmental 19,756,460 105,774 19,756,460
Total Expenditures 103,315,657 19,798,093 103,357,873 (42,216) 0.0%
March 2018 Monthly Financial Report
City of Kent, Washington
General Fund Overview - Expenditures
Variance analysis for expenditures is provided for particular departments or those in which the estimated actual
amount differs from the budgeted amount by at least 10% or a minimum of $500,000.
Variance Notes
None.
City Council
Mayor's Office/City
Clerk
3%
Economic &
Community Dev
7%
Finance
3%
Fire Contracted
Services
4%
Human Resources
2%
Information
Technology
Law
2%
Municipal Court
3%
Parks, Recreation &
Comm Svcs
18%
Police
38%
Public Works
1%
Non-Departmental
19%
Other
8%
2018 Estimated Expenditures
2017 2018 2018 2018
Actuals Adj Budget YTD Est Actual
Beginning Fund Balance 19,987,828 21,595,175 21,595,175 21,595,175
Revenues
Taxes:
Property 22,999,864 29,532,710 948,899 29,322,000
Sales & Use 21,109,277 21,100,310 5,615,332 21,362,570
Utility 19,648,349 19,150,880 5,349,794 19,242,780
Business & Occupation 9,141,800 8,890,480 25,207 8,441,410
Other 900,663 879,260 12,204 883,000
Licenses and Permits 6,962,130 5,695,870 1,766,569 6,163,570
Intergovernmental Revenue 8,102,414 7,946,370 1,940,906 8,016,410
Charges for Services 7,328,567 5,844,610 2,265,641 6,694,540
Fines and Forfeitures 1,549,964 1,565,970 271,651 1,364,640
Miscellaneous Revenue 2,241,585 1,574,530 498,803 1,733,080
Transfers In 934,128 950,000 - 950,000
Total Revenues 100,918,740 103,130,990 18,695,007 104,174,000
Expenditures
City Council 349,577 409,150 101,630 403,300
Mayor's Office/City Clerk 2,745,792 3,052,700 701,393 2,968,100
Economic & Community Dev 5,841,098 7,172,680 1,676,350 7,105,200
Finance 2,522,554 2,965,590 717,355 3,014,900
Fire Contracted Services 3,668,180 3,657,530 815,821 3,730,236
Human Resources 1,835,276 2,108,520 479,139 2,076,100
Information Technology 521,151 519,450 128,182 519,977
Law 1,600,451 1,766,540 441,608 1,784,100
Municipal Court 3,128,652 3,347,420 814,420 3,356,700
Parks, Recreation & Comm Svcs 16,655,356 18,419,757 3,824,234 18,397,300
Police 37,167,622 38,821,390 9,718,264 38,965,000
Public Works 1,111,563 1,318,470 273,924 1,280,500
Non-Departmental 22,164,122 19,756,460 105,774 19,756,460
Total Expenditures 99,311,394 103,315,657
19,798,093 103,357,873
Net Revenues less Expenditures 1,607,347 (184,667) (1,103,086) 816,127
Ending Fund Balance 21,595,175 21,410,508 20,492,089 22,411,302
Ending Fund Balance Detail:
General Fund Reserves 20,528,605 20,469,758 21,794,742
based on same year actuals/budget 20.7% 19.8% 21.1%
Restricted for Annexation 1,066,570 940,750 616,560
March 2018 Monthly Financial Report
City of Kent, Washington
General Fund
2016 2017 2018 % of
thru March thru March thru March Budget
Revenues
Taxes:
Property 917,534 908,077 948,899 40,822 4.5% 53.1%
Sales & Use 5,005,488 5,221,835 5,615,332 393,498 7.5% 51.6%
Utility 5,407,093 5,409,478 5,349,794 (59,684) -1.1% 54.6%
Business & Occupation 158,372 487,986 25,207 (462,779) -94.8% 28.8%
Other 9,725 11,188 12,204 1,017 9.1% 30.6%
Licenses and Permits 1,274,891 1,538,614 1,766,569 227,955 14.8% 51.9%
Intergovernmental Revenue 1,889,865 1,882,038 1,940,906 58,868 3.1% 52.7%
Charges for Services 1,124,898 1,720,915 2,265,641 544,727 31.7% 67.8%
Fines and Forfeitures 349,211 535,055 271,651 (263,404) -49.2% 57.7%
Miscellaneous Revenue 376,114 473,404 498,803 25,399 5.4% 65.7%
Transfers In - - - -
Total Revenues 16,513,192 18,188,589 18,695,007 506,418 2.8% 18.1%
Expenditures
City Council 78,811 97,920 101,630 3,710 3.8% 24.8%
Mayor's Office/City Clerk 658,311 640,113 701,393 61,280 9.6% 23.0%
Economic & Community Dev 1,301,345 1,337,584 1,676,350 338,766 25.3% 23.4%
Finance 602,523 553,042 717,355 164,313 29.7% 24.2%
Fire Contracted Services 717,631 705,961 815,821 109,860 15.6% 22.3%
Human Resources 385,873 418,026 479,139 61,113 14.6% 22.7%
Information Technology 129,453 130,767 128,182 (2,585) -2.0% 24.7%
Law 353,813 375,304 441,608 66,304 17.7% 25.0%
Municipal Court 750,260 774,313 814,420 40,107 5.2% 24.3%
Parks, Recreation & Comm Svcs 3,430,270 3,520,976 3,824,234 303,257 8.6% 20.8%
Police 8,684,612 9,172,845 9,718,264 545,418 5.9% 25.0%
Public Works *470,973 295,303 273,924 (21,379) -7.2% 20.8%
Non-Departmental 350,767 77,980 105,774 27,793 35.6% 0.5%
Total Expenditures 17,914,642 18,100,135 19,798,093 1,697,959 9.4% 19.2%
Variance
March 2018 Monthly Financial Report
City of Kent, Washington
General Fund
Year-to-Year Month Comparison
2016-17
2016 2017 2018 2018 2018
Actual Actual Budget YTD Est Actual
Operating revenues and expenditures only; capital and non-capital projects are excluded.
In instances where expenditures exceed revenues, fund balance is being utilized.
Street Fund
Revenues 14,254,751 18,437,655 11,921,560 2,937,460 11,921,560
Expenditures 14,369,693 13,797,324 15,262,930 3,989,384 14,840,190
Net Revenues Less Expenditures (114,942)4,640,330 (3,341,370)(1,051,924)(2,918,630)
LEOFF 1 Retiree Benefits
Revenues 1,035,289 1,285,285 1,193,480 156,569 1,193,480
Expenditures 954,561 1,163,174 1,196,550 278,004 1,196,550
Net Revenues Less Expenditures 80,728 122,111 (3,070)(121,434)(3,070)
Lodging Tax
Revenues 294,859 316,975 286,610 54,777 286,610
Expenditures 219,989 328,804 392,750 90,218 338,750
Net Revenues Less Expenditures 74,870 (11,830)(106,140)(35,440)(52,140)
Youth/Teen Programs
Revenues 911,855 955,757 936,220 267,393 936,220
Expenditures 942,000 942,000 942,000 942,000
Net Revenues Less Expenditures (30,145)13,757 (5,780)267,393 (5,780)
Capital Resources
Revenues 20,751,646 20,248,917 17,356,830 3,738,588 17,356,830
Expenditures 15,248,984 16,103,296 23,130,430 (725,000)23,130,430
Net Revenues Less Expenditures 5,502,662 4,145,620 (5,773,600)4,463,588 (5,773,600)
2017: October Budget change of $310,000 to correct PFD bond refunding debt service
Criminal Justice
Revenues 4,873,770 5,285,261 4,200,900 1,117,446 4,200,900
Expenditures 3,157,680 4,529,548 4,306,560 1,090,912 4,306,560
Net Revenues Less Expenditures 1,716,090 755,713 (105,660)26,534 (105,660)
ShoWare Operating
Revenues 1,647,988 1,665,226 1,234,430 85,121 1,150,000
Expenditures 1,097,457 1,293,406 1,102,020 139,935 1,102,020
Net Revenues Less Expenditures 550,531 371,820 132,410 (54,814)47,980
Other Operating
Revenues 135,731 213,058 120,650 5,000 115,650
Expenditures 63,059 138,925 120,650 15,042 115,650
Net Revenues Less Expenditures 72,672 74,133 (10,042)
Councilmanic Debt Service
Revenues 86,581,322 10,781,229 10,531,820 10,531,820
Expenditures 85,720,181 10,316,403 10,066,990 10,066,990
Net Revenues Less Expenditures 861,141 464,826 464,830 464,830
Special Assessment Debt Service
Revenues 2,151,133 1,979,573 1,504,460 48,776 1,504,460
Expenditures 3,032,661 2,585,818 1,563,470 (1,354)1,563,470
Net Revenues Less Expenditures (881,528)(606,245)(59,010)50,129 (59,010)
2016: Includes street and transportation revenues and costs moved from the General Fund.
Debt Service Funds
March 2018 Monthly Financial Report
City of Kent, Washington
Other Funds Overview (Revenues and Expenditures)
Special Revenue Funds
2016 2017 2018 2018 2018
Actual Actual Budget YTD Est Actual
Operating revenues and expenditures only; capital and non-capital projects are excluded.
In instances where expenditures exceed revenues, fund balance is being utilized.
March 2018 Monthly Financial Report
City of Kent, Washington
Other Funds Overview (Revenues and Expenditures)
Water Utility
Revenues 24,526,000 24,623,103 25,718,320 5,971,049 25,718,320
Expenditures 21,654,832 27,090,960 28,964,520 3,245,322 28,964,520
Net Revenues Less Expenditures 2,871,168 (2,467,857)(3,246,200)2,725,728 (3,246,200)
Sewer/Drainage Utility
Revenues 53,289,642 52,627,075 53,455,350 14,586,334 53,455,350
Expenditures 50,599,649 53,659,952 57,600,360 10,095,656 57,600,360
Net Revenues Less Expenditures 2,689,993 (1,032,876)(4,145,010)4,490,677 (4,145,010)
Solid Waste Utility
Revenues 774,072 754,868 749,500 162,754 600,000
Expenditures 471,180 577,964 707,690 224,541 523,190
Net Revenues Less Expenditures 302,892 176,904 41,810 (61,787)76,810
Golf Complex
Revenues 2,475,682 3,027,079 2,871,410 310,880 2,871,410
Expenditures 3,188,762 3,202,674 2,931,980 514,016 2,931,980
Net Revenues Less Expenditures (713,080)(175,595)(60,570)(203,136)(60,570)
2017: Note revenues include $500k for Sale of Land
Fleet Services
Revenues 4,769,001 5,480,210 4,761,160 1,217,336 4,761,160
Expenditures 3,974,431 4,846,667 9,118,620 1,200,336 8,065,780
Net Revenues Less Expenditures 794,570 633,543 (4,357,460)17,000 (3,304,620)
Central Services
Revenues 382,444 350,602 449,310 98,459 449,310
Expenditures 399,786 290,147 421,150 89,030
Net Revenues Less Expenditures (17,342)60,455 28,160 9,429 449,310
Information Technology
Revenues 7,717,834 7,578,105 8,133,760 2,056,631 8,133,760
Expenditures 6,905,076 8,176,750 8,729,590 1,961,097 9,150,740
Net Revenues Less Expenditures 812,757 (598,645)(595,830)95,534 (1,016,980)
Facilities
Revenues 5,556,854 4,737,520 4,904,580 1,198,127 4,904,580
Expenditures 4,881,741 4,763,098 5,144,420 993,477 5,109,420
Net Revenues Less Expenditures 675,113 (25,578)(239,840)204,650 (204,840)
Unemployment
Revenues 420,226 167,215 121,700 38,207 121,700
Expenditures 126,718 75,154 171,870 46,069 171,870
Net Revenues Less Expenditures 293,508 92,061 (50,170)(7,862)(50,170)
Workers Compensation
Revenues 1,200,476 1,082,091 1,074,800 272,813 1,074,800
Expenditures 1,436,775 1,013,278 1,441,940 279,594 1,441,940
Net Revenues Less Expenditures (236,299)68,813 (367,140)(6,782)(367,140)
Enterprise Funds
Internal Service Funds
2016 2017 2018 2018 2018
Actual Actual Budget YTD Est Actual
Operating revenues and expenditures only; capital and non-capital projects are excluded.
In instances where expenditures exceed revenues, fund balance is being utilized.
March 2018 Monthly Financial Report
City of Kent, Washington
Other Funds Overview (Revenues and Expenditures)
Employee Health & Wellness
Revenues 10,688,926 11,707,967 12,995,990 3,192,436 12,995,990
Expenditures 12,130,696 13,428,552 14,629,950 3,573,881 14,629,950
Net Revenues Less Expenditures (1,441,770)(1,720,584)(1,633,960)(381,444)(1,633,960)
2017: October budget change of $2.1m to increase medical claims budget
Liability Insurance
Revenues 1,447,027 2,087,755 1,510,060 382,700 1,510,060
Expenditures 2,145,627 2,180,680 1,925,440 1,094,969 1,925,440
Net Revenues Less Expenditures (698,600)(92,925)(415,380)(712,269)(415,380)
2017: October budget change for $200,000 to ensure adequate budget to cover judgments and damages costs
Property Insurance
Revenues 628,105 556,770 565,920 143,501 565,920
Expenditures 445,135 436,283 526,370 213,397 526,370
Net Revenues Less Expenditures 182,970 120,487 39,550 (69,897)39,550
2016 2017 2018
thru March thru March thru March
Operating revenues and expenditures only; capital and non-capital projects are excluded.
Street Fund
Revenues 3,061,515 2,799,251 2,937,460 138,210 4.9%
Expenditures 2,165,644 1,925,593 3,989,384 2,063,791 107.2%
Net Revenues Less Expenditures 895,871 873,658 (1,051,924)
2016 includes street and transportation revenues and costs moved from the General Fund.
LEOFF 1 Retiree Benefits
Revenues 13,506 217,023 156,569 (60,454)-27.9%
Expenditures 195,785 288,767 278,004 (10,763)-3.7%
Net Revenues Less Expenditures (182,280)(71,744)(121,434)
2016 revenues reflect a timing difference because of revenues that were not booked until June.
Lodging Tax
Revenues 48,699 51,437 54,777 3,341 6.5%
Expenditures 49,479 20,529 90,218 69,689 339.5%
Net Revenues Less Expenditures (780)30,908 (35,440)
2016 expenditures reflect increased marketing activities.
Youth/Teen Programs
Revenues 256,323 274,352 267,393 (6,959)-2.5%
Expenditures
Net Revenues Less Expenditures 256,323 274,352 267,393
Capital Resources
Revenues 3,273,493 2,853,146 3,738,588 885,442 31.0%
Expenditures (725,000)(725,000)
Net Revenues Less Expenditures 3,273,493 2,853,146 4,463,588
Criminal Justice
Revenues 1,151,027 1,213,639 1,117,446 (96,193)-7.9%
Expenditures 698,814 925,084 1,090,912 165,828 17.9%
Net Revenues Less Expenditures 452,213 288,555 26,534
2016 increase in revenues due to strong sales tax trends and an increase in seized assets.
ShoWare Operating
Revenues 15,000 85,121 85,121
Expenditures 105,024 131,050 139,935 8,885 6.8%
Net Revenues Less Expenditures (90,024)(131,050)(54,814)
Admissions Tax revenues received quarterly (April, July, September, January)
Other Operating
Revenues 5,000 5,000
Expenditures 18,394 500 15,042 14,542 2908.5%
Net Revenues Less Expenditures (18,394)(500)(10,042)
Combines several small programs, including City Art Program and Neighborhood Matching Grants
March 2018 Monthly Financial Report
City of Kent, Washington
Other Funds Overview (Revenues and Expenditures)
Year-to-Year Month Comparison
2018-17
Special Revenue Funds
Variance
2016 2017 2018
thru March thru March thru March
Operating revenues and expenditures only; capital and non-capital projects are excluded.
March 2018 Monthly Financial Report
City of Kent, Washington
Other Funds Overview (Revenues and Expenditures)
Year-to-Year Month Comparison
2018-17
Variance
Councilmanic Debt Service
Revenues
Expenditures
Net Revenues Less Expenditures
Debt service payments are generally due in June and December.
Special Assessments Debt Service
Revenues 155,126 64,637 48,776 (15,862)-24.5%
Expenditures 425,190 156 (1,354)(1,510)-965.0%
Net Revenues Less Expenditures (270,064)64,481 50,129
Water Utility
Revenues 4,289,816 5,687,351 5,971,049 283,698 5.0%
Expenditures 2,861,511 3,271,510 3,245,322 (26,188)-0.8%
Net Revenues Less Expenditures 1,428,305 2,415,841 2,725,728
Sewer/Drainage Utility
Revenues 11,738,443 12,716,526 14,586,334 1,869,808 14.7%
Expenditures 9,067,371 9,775,786 10,095,656 319,871 3.3%
Net Revenues Less Expenditures 2,671,071 2,940,740 4,490,677
Solid Waste Utility
Revenues 158,232 150,088 162,754 12,665 8.4%
Expenditures 95,878 95,134 224,541 129,407 136.0%
Net Revenues Less Expenditures 62,354 54,954 (61,787)
Solid Waste Utility established in 2016.
Golf Complex
Revenues 303,889 260,932 310,880 49,948 19.1%
Expenditures 601,247 552,662 514,016 (38,646)-7.0%
Net Revenues Less Expenditures (297,358)(291,730)(203,136)
2016 & 2017 revenues down due to inclement weather conditions in Q1.
Fleet Services
Revenues 1,197,138 1,212,776 1,217,336 4,560 0.4%
Expenditures 739,014 847,121 1,200,336 353,214 41.7%
Net Revenues Less Expenditures 458,123 365,654 17,000
Central Services
Revenues 110,899 90,041 98,459 8,418 9.3%
Expenditures 98,641 20,843 89,030 68,187 327.1%
Net Revenues Less Expenditures 12,258 69,198 9,429
Debt Service Funds
Enterprise Funds
Internal Service Funds
2016 2017 2018
thru March thru March thru March
Operating revenues and expenditures only; capital and non-capital projects are excluded.
March 2018 Monthly Financial Report
City of Kent, Washington
Other Funds Overview (Revenues and Expenditures)
Year-to-Year Month Comparison
2018-17
Variance
Information Technology
Revenues 1,862,516 1,963,019 2,056,631 93,612 4.8%
Expenditures 1,854,810 1,934,995 1,961,097 26,102 1.3%
Net Revenues Less Expenditures 7,705 28,024 95,534
Facilities
Revenues 1,317,217 1,142,335 1,198,127 55,793 4.9%
Expenditures 1,025,827 964,892 993,477 28,586 3.0%
Net Revenues Less Expenditures 291,390 177,443 204,650
Unemployment
Revenues 103,005 57,934 38,207 (19,727)-34.1%
Expenditures 47,691 18,085 46,069 27,984 154.7%
Net Revenues Less Expenditures 55,314 39,849 (7,862)
Workers Compensation
Revenues 297,034 255,951 272,813 16,862 6.6%
Expenditures 273,977 324,088 279,594 (44,494)-13.7%
Net Revenues Less Expenditures 23,057 (68,137)(6,782)
Employee Health & Wellness
Revenues 2,627,730 2,695,012 3,192,436 497,424 18.5%
Expenditures 3,303,458 3,319,480 3,573,881 254,401 7.7%
Net Revenues Less Expenditures (675,728)(624,468)(381,444)
Liability Insurance
Revenues 285,454 326,602 382,700 56,098 17.2%
Expenditures 1,011,747 1,767,385 1,094,969 (672,416)-38.0%
Net Revenues Less Expenditures (726,293)(1,440,783)(712,269)
Property Insurance
Revenues 153,091 140,092 143,501 3,409 2.4%
Expenditures 241,693 214,870 213,397 (1,472)-0.7%
Net Revenues Less Expenditures (88,603)(74,778)(69,897)
2018 2018 2018 2018
Beginning
Fund Balance
Estimated
Revenues
Estimated
Expenditures
Ending Fund
Balance
Operating revenues and expenditures only; capital and non-capital projects are excluded.
General Fund 21,595,174 104,174,000 103,357,873 22,411,301
Street Fund 5,873,486 11,921,560 14,840,190 2,954,856
LEOFF 1 Retiree Benefits 1,296,372 1,193,480 1,196,550 1,293,302
Lodging Tax 457,557 286,610 338,750 405,417
Youth/Teen Programs 104,887 936,220 942,000 99,107
Capital Resources 15,646,334 17,356,830 23,130,430 9,872,734
Criminal Justice 6,445,993 4,200,900 4,306,560 6,340,333
ShoWare Operating 2,518,894 1,150,000 1,102,020 2,566,874
Other Operating 526,158 115,650 115,650 526,158
Councilmanic Debt Service 986,220 10,531,820 10,066,990 1,451,050
Special Assessments Debt Service 582,661 1,504,460 1,563,470 523,651
Water Utility 20,803,346 25,718,320 28,964,520 17,557,146
Sewer/Drainage Utility 24,390,396 53,455,350 57,600,360 20,245,386
Solid Waste Utility 479,431 600,000 523,190 556,241
Golf Complex (3,816,932) 2,871,410 2,931,980 (3,877,502)
Fleet Services 5,869,149 4,761,160 8,065,780 2,564,529
Central Services (3,113) 449,310 446,197
Information Technology 3,593,294 8,133,760 9,150,740 2,576,314
Facilities 2,316,961 4,904,580 5,109,420 2,112,121
Unemployment 1,424,508 121,700 171,870 1,374,338
Workers Compensation 2,374,326 1,074,800 1,441,940 2,007,186
Employee Health & Wellness 2,960,567 12,995,990 14,629,950 1,326,607
Liability Insurance 1,661,132 1,510,060 1,925,440 1,245,752
Property Insurance 652,035 565,920 526,370 691,585
Enterprise Funds
Internal Service Funds
March 2018 Monthly Financial Report
City of Kent, Washington
Fund Balances
General Fund
Special Revenue Funds
Debt Service Funds
Project Prior Years 2018 Total Balance
Budgets Actuals YTD to Date Remaining
Street Fund
Resources 11,934,405 7,192,854 (59,688) 7,133,166 4,801,239
Expenditures 11,934,405 4,384,175 142,730 4,526,904 7,407,501
Net Resources Less Expenditures 2,808,679 (202,417)2,606,262 (2,606,262)
Capital Resources
Resources 1,540,800 1,491,470 1,491,470 49,330
Expenditures 1,540,800 1,433,565 16,569 1,450,134 90,666
Net Resources Less Expenditures 57,905 (16,569)41,336 (41,336)
Criminal Justice
Resources 1,573,604 1,457,867 72,701 1,530,568 43,036
Expenditures 1,573,604 1,395,875 65,916 1,461,790 111,814
Net Resources Less Expenditures 61,992 6,785 68,777 (68,777)
Housing & Community Development
Resources 3,010,536 1,345,765 1,345,765 1,664,771
Expenditures 3,010,536 1,345,765 223,871 1,569,636 1,440,900
Net Resources Less Expenditures (223,871)(223,871)223,871
ShoWare Operating
Resources 310,000 310,000 310,000
Expenditures 310,000 225,570 84,430 310,000
Net Resources Less Expenditures 84,430 (84,430)
October budget change of $310,000 for ShoWare point of sale system
Other Operating
Resources 713,213 1,018,022 12,750 1,030,772 (317,559)
Expenditures 713,213 868,258 12,730 880,988 (167,775)
Net Resources Less Expenditures 149,763 20 149,784 (149,784)
Street Capital Projects
Resources 171,846,475 134,562,754 3,069,968 137,632,722 34,213,753
Expenditures 171,846,475 123,474,413 4,612,218 128,086,631 43,759,844
Net Resources Less Expenditures 11,088,341 (1,542,250)9,546,091 (9,546,091)
Parks Capital Projects
Resources 33,964,839 22,052,841 36,412 22,089,254 11,875,585
Expenditures 33,964,839 14,883,925 278,296 15,162,221 18,802,618
Net Resources Less Expenditures 7,168,916 (241,884)6,927,033 (6,927,033)
Technology Capital Projects
Resources 10,425,425 8,553,250 (725,000) 7,828,250 2,597,175
Expenditures 10,425,425 1,974,309 38,064 2,012,373 8,413,052
Net Resources Less Expenditures 6,578,941 (763,064)5,815,877 (5,815,877)
Facilities Capital Projects
Resources 9,102,238 9,102,239 9,102,239 (1)
Expenditures 9,102,238 9,082,605 681 9,083,286 18,952
Net Resources Less Expenditures 19,634 (681) 18,953 (18,953)
March 2018 Monthly Financial Report
City of Kent, Washington
Capital and Non-Capital Projects
Special Revenue Funds
Capital Project Funds
Project Prior Years 2018 Total Balance
Budgets Actuals YTD to Date Remaining
March 2018 Monthly Financial Report
City of Kent, Washington
Capital and Non-Capital Projects
Other Capital Projects
Resources 1,790,820 1,428,779 20,111 1,448,890 341,930
Expenditures 1,790,820 399,034 14,475 413,510 1,377,310
Net Resources Less Expenditures 1,029,745 5,635 1,035,380 (1,035,380)
Water Utility
Resources 39,943,201 33,158,669 33,158,669 6,784,532
Expenditures 39,943,201 12,157,318 327,142 12,484,460 27,458,741
Net Resources Less Expenditures 21,001,350 (327,142)20,674,209 (20,674,209)
Sewer/Drainage Utility
Resources 116,583,059 97,343,152 (10,902) 97,332,250 19,250,809
Expenditures 116,583,059 73,607,412 658,456 74,265,868 42,317,191
Net Resources Less Expenditures 23,735,740 (669,358)23,066,382 (23,066,382)
Golf Complex
Resources 650,000 550,000 550,000 100,000
Expenditures 650,000 300,000 300,000 350,000
Net Resources Less Expenditures 250,000 250,000 (250,000)
Fleet Services
Resources 1,750,000 1,750,000
Expenditures 1,750,000 162 1,288 1,450 1,748,550
Net Resources Less Expenditures (162)(1,288)(1,450)1,450
Facilities
Resources 6,151,007 5,460,007 5,460,007 691,000
Expenditures 6,151,007 3,956,750 14,907 3,971,658 2,179,349
Net Resources Less Expenditures 1,503,257 (14,907)1,488,350 (1,488,350)
Enterprise Funds
Internal Service Funds