HomeMy WebLinkAboutFIN 2020-09-14 COMPLETE AGENDA PACKET The City of Tukwila strives to accommodate individuals with disabilities.
Please contact the City Clerk ’s Office at 206 -433-1800 (Tukwi laCityClerk@TukwilaWA.gov) for assistance.
City of Tukwila
Finance Committee
Verna Seal, Chair
Kathy Hougardy
Zak Idan
Distribution:
V. Seal
K. Hougardy
Z. Idan
D. Quinn
K. Kruller
T. McLeod
C. Delostrinos Johnson
Mayor Ekberg
D. Cline
R. Bianchi
C. O’Flaherty
A. Youn
L. Humphrey
AGENDA
MONDAY, SEPTEMBER 14, 2020 – 5:30 PM
HAZELNUT CONFERENCE ROOM
(At east entrance of City Hall)
THIS MEETING WILL NOT BE CONDUCTED AT CITY FACILITIES
BASED ON THE GOVERNOR’S PROCLAMATION 20-28.
THE PHONE NUMBER FOR THE PUBLIC TO LISTEN TO THIS
MEETING IS: 1-253-292-9750, Access Code 304205413#
Item Recommended Action Page
1. BUSINESS AGENDA
a. A resolution authorizing the cancellation of outstanding
General Fund claims and payroll checks.
Cindy Wilkins, Fiscal Specialist
b. A resolution ordering the cancellation of past due
accounts receivable.
Cindy Wilkins, Fiscal Specialist
c. A contract with Zayo for internet services.
Mike Marcum, Technical Operations Supervisor
d. 2020 2nd Quarter sales tax and miscellaneous revenue
report.
Vicky Carlsen, Finance Director
2. MISCELLANEOUS
a. Forward to 9/21 Consent
Agenda.
b. Forward to 9/21 Consent
Agenda.
c. Forward to 9/14 C.O.W. and
Special Meeting.
d. Discussion only.
Pg.1
Pg.5
Pg.11
Pg.17
Next Scheduled Meeting: Monday, September 28, 2020
City of Tukwila
Allan Ekberg, Mayor
INFORMATIONAL MEMORANDUM
TO: Finance Committee
FROM: Vicky Carlsen, Finance Director
BY: Cindy Wilkins – Fiscal Specialist
CC: Mayor Ekberg
DATE: September 8, 2020
SUBJECT: 2020 Reporting of Abandoned Property to the Washington State
Department of Revenue Unclaimed Property Section
ISSUE
Annual write-off of outstanding and unredeemed accounts payable and payroll claims.
BACKGROUND
Each year by November 1st, the City of Tukwila reports abandoned or unclaimed property that is
owed either to individuals or business vendors to the Washington State Department of Revenue
Unclaimed Property Section and removes these items from the accounting records. All local
governments are required to report unclaimed property except unclaimed restitution. Normal
restitution is then reported each year by the County Treasurer to the State Treasurer.
Current Finance Department policy dictates that all abandoned or unclaimed property be
reported annually to the Washington State Department of Revenue Unclaimed Property Section
through the Council approved resolution process.
DISCUSSION
For the 2020 unclaimed property report year, reporting of abandoned or unclaimed property
totals $16,678.88 comprised of General Fund Accounts, payable Claims checks and Payroll
checks.
To the extent possible, those individuals and businesses with unclaimed accounts payable
claims and payroll checks have been notified by the City through “good faith” effort of being
mailed due diligence letters. These individuals and businesses have either not responded to
the due diligence notifications and/or cannot be located in order to claim their property.
One of the largest contributors to Unclaimed Property are juror reimbursement checks. To help
reduce unclaimed property, a member from Finance is reimbursing jurors from a petty cash fund
in the courtroom prior to the start of the trial. Checks are no longer being issued for
reimbursement.
RECOMMENDATION
The Council is being asked to approve the Resolution declaring the cancellation of unclaimed
General Fund accounts payable claims and consider these items on the Consent Agenda at the
September 21, 2020 Regular Council Meeting.
ATTACHMENTS
Proposed Draft Resolution
2019 Unclaimed Property Summary Detail Report.
1
2
: ?:RUG3URFHVVLQJ?5HVROXWLRQV?&DQFHOODWLRQRIRXWV WDQGLQJFODLPVDQG FKHFNV
&: EMV 5HYLHZDQGDQDO\VLVE\%DUEDUD6D[WRQ 3DJHRI
$5(62/87,212)7+(&,7<&281&,/2)7+(&,7<2)78.:,/$
:$6+,1*721$87+25,=,1* 7+( &$1 &(//$7,21 2)
28767$1',1**(1(5$/)81'&/$,06$1'3$<52//&+(&.6
:+(5($6WKH6WDWHRI:DVKLQJWRQ'HSDUWPHQWRI5HYHQXH8QFODLPHG3URSHUW\
6HFWLRQ IRU WKH UHSRUWLQJ RQ \HDU UHTXLUHV DRQH\HDU GRUPDQF\ SHULRG IRU
RXWVWDQGLQJFODLPVDQGSD\UROOFKHFNVLVVXHGIURPWKH*HQHUDO*RYHUQPHQW)XQG DQG
:+(5($6WKH &LW\ RI 7XNZLOD )LQDQFH 'HSDUWPHQW KDVPDGHDOOUHDVRQDEOH
DWWHPSWVWRUHVROYHWKH RXWVWDQ GLQJXQUHGHHPHG*HQHUDO)XQGFODLPV DQG
:+(5($6WKH&LW\&RXQFLORIWKH&LW\RI7XNZLODZLVKHVWRFDQFHODOORXWVWDQGLQJ
XQFODLPHG*HQHUDO)XQGFODLPV DQGSD\UROO FKHFNVLVVXHGSULRUWR-XO\
12: 7+(5()25( 7+( &,7< &281&,/ 2) 7+( &,7< 2) 78.:,/$
:$6+,1*721+(5(%<5(62/9(6$6)2//2:6
7KH7XNZLOD&LW\&RXQFLODXWKRUL]HVWKHFDQFHOODWLRQRI*HQHUDO)XQGFKHFNVDV
GHWDLOHGRQ$WWDFKPHQW$WKH8QFODLPHG3URSHUW\6XPPDU\5HSRUW
3$66('%<7+(&,7<&281&,/2)7+(&,7<2)78.:,/$:$6+,1*721DW
D5HJXODU 0HHWLQJWKHUHRIWKLVBBBBBB BGD\RIBBBBBBBBBBBBBBBBB
$77(67$87+(17,&$7('
&KULVW\2
)ODKHUW\00&&LW\&OHUN 'H¶6HDQ4XLQQ &RXQFLO3UHVLGHQW
$33529('$672)250%<
)LOHGZLWKWKH&LW\&OHUN
3DVVHGE\WKH&L W\&RXQFLO
5HVROXWLRQ1XPEHU
2IILFHRIWKH&LW\$WWRUQH\
$WWDFKPHQW$ 8QFODLPHG3URSHUW\6XPPDU\5HSRUW ±
3
Attachment A, 2020 Unclaimed Property Summary Report Reporting Period: 01/20/2017 - 06/30-2019
Accounts Payable
Check # Date Vendor #/Name Description GL Code Invoice # Inv. Date Amount Check Amt
1 381047 06/03/19 001005 MERIAM GEBREMICHAEL Interpreter Fee 000.03.512.500.41.00 6031901 05/22/19 88.00 88.00
2 379683 12/17/18 008001 WA ECONOMIC DEVELOPMENT ASSN Professional Service 000.06.515.300.41.02 38-2018 12/05/18 13,500.00 13,500.00
3 380457 04/01/19 019550 DAVID L ALWERT Youth Basketball Officiating 000.07.571.200.41.01 4011902 03/14/19 165.00 165.00
4 379323 11/05/18 019159 JANET SWEET Piano Lessons 000.07.571.206.41.00 11051863 10/29/18 642.50 642.50
5 380840 05/06/19 007790 KEVIN LEE JOHNSON Piano Lessons 000.07.571.206.41.00 5061917 04/25/19 420.00 420.00
6 378316 07/03/18 018371 JIM TOOLE Tempered Glass 000.08.524.600.28.00 7031884 06/21/18 109.98 109.98
7 380767 04/22/19 008122 WA ST ASSN OF PERMIT TECH.Reg Fee 000.08.558.600.49.00 4221935 04/15/19 240.00 240.00
8 378684 08/20/18 012010 XAVIER MAIPI Interpreter Fee 000.09.512.500.41.03 29792 08/08/18 80.00 80.00
9 379332 11/05/18 019161 MARIA VALENCIA Interpreter Fee 000.09.512.500.41.03 11051873 09/26/18 11.86 11.86
10 380509 04/01/19 019497 TERESA JORDAN Juror Fee 000.09.512.500.49.01 4011945 03/07/19 13.02 13.02
11 378219 07/02/18 018920 JENNIFER CROSS Witness Fee 000.09.512.500.49.04 6051742 05/30/18 42.48 42.48
12 379240 11/05/18 019211 DAWN AUSTIN Witness Fee 000.09.512.500.49.04 11051870 10/24/18 11.53 11.53
13 379245 11/05/18 019209 SAMANTHA LOUISE BLEAKMORE Witness Fee 000.09.512.500.49.04 11051871 10/24/18 16.22 16.22
14 379673 12/17/18 019286 BRONWEN THOMAS Witness Fee 000.09.512.500.49.04 6051743 11/28/18 17.30 17.30
15 379761 01/07/19 019299 JERICHO BIRD Witness Fee 000.09.512.500.49.04 12301851 12/12/18 27.77 27.77
16 380148 02/19/19 019417 CHERYL GARCIA Witness Fee 000.09.512.500.49.04 2191911 01/30/19 10.93 10.93
17 380149 02/19/19 019416 JOHN GARCIA Witness Fee 000.09.512.500.49.04 2191912 01/30/19 10.93 10.93
18 380151 02/19/19 019415 ENAREZ GONZALES-BALTAZAR Witness Fee 000.09.512.500.49.04 2191913 01/30/19 10.93 10.93
19 380162 02/19/19 019418 PORSHA LESTER Witness Fee 000.09.512.500.49.04 2191914 01/30/19 14.99 14.99
20 380376 03/18/19 019471 LUIS HERNANDEZ Witness Fee 000.09.512.500.49.04 6051740 02/28/19 19.63 19.63
21 380465 04/01/19 019481 CHRIS BERTLEY Juror Fee 000.09.512.500.49.04 4011932 03/07/19 10.93 10.93
22 380504 04/01/19 019489 MERHAWI HUBTE Juror Fee 000.09.512.500.49.04 4011943 03/07/19 14.76 14.76
23 380543 04/01/19 019502 CHARLES PORTER Juror Fee 000.09.512.500.49.04 4011954 03/07/19 12.67 12.67
24 380558 04/01/19 018784 FAYE SRIPRANARATANAKUL Juror Fee 000.09.512.500.49.04 4011960 03/07/19 12.67 12.67
25 380573 04/01/19 019509 SOPHEAK VEN Juror Fee 000.09.512.500.49.04 4011964 03/07/19 14.99 14.99
26 380651 04/15/19 019556 ALEXIS PHAM Witness Fee 000.09.512.500.49.04 4051903 03/27/19 12.90 12.90
27 381140 06/17/19 019698 JAYLEN COLLINS Witness Fee 000.09.512.500.49.04 6051741 05/29/19 12.18 12.18
28 380072 02/04/19 002771 PHILIP P GLOVER Refund of FICA Withholding 000.10.521.250.21.00 2041910 02/04/18 18.61 18.61
29 380257 03/04/19 019459 BRETT HARTMAN Security Deposit Refund 000.213.100 PYMT-25833 02/22/19 200.00 200.00
30 380329 03/04/19 019458 OLA WILLIAM-OKES Security Deposit Refund 000.213.100 FA-2214 02/21/19 200.00 200.00
31 378302 07/02/18 018926 JULIE WILSON Security/Rental Refund 000.237.10 8373 05/21/18 250.00 250.00
32 378662 08/20/18 009492 TRACEY D. GRENSTEAD Security Deposit 000.237.104 FA-0845 08/02/18 10.00 10.00
33 378747 09/04/18 019108 ALAENA BLOUIN Security Deposit Refund 000.237.104 FA-1418 08/16/18 190.00 190.00
34 378818 09/04/18 019098 CHASITY WATSON Security Deposit Refund 000.237.104 INV#15732 08/23/18 100.00 100.00
35 378931 10/01/18 007469 LEATHA BAILEY Shelter Security Refund 000.237.104 FA-0968 09/06/18 100.00 100.00
36 378938 10/01/18 019153 BKM TUKWILA 117 LLC Bldg Dept Refund 000.322.100.00.00 D18-0003 09/06/18 2,967.46 3,115.84
37 """"000.322.900.04.00 ""148.36 -
38 378628 08/20/18 019070 ABU-BAKR ISLAMIC CENTER Overcharged Late fee 000.342.400.03.00 8201820 08/06/18 5.00 5.00
39 378568 08/06/18 018352 CAROLYN LAW Park Acquisition 301.98.576.800.41.00 2(18-037)07/21/18 5,550.00 5,550.00
40 380952 05/20/19 013140 WAIOKULANI KALALAU Meals/Mileage - Kalalau 412.01.538.380.43.00 5201932 03/27/19 29.12 29.12
41 378652 08/20/18 019073 ENGIE INSIGHT/ToysR Us Over payment Utility account/final billing 640.237.000 8201824 08/13/18 458.16 458.16
42 380709 04/22/19 019570 ESTATE OF HARTSELL WOOD Water O/P 640.237.000 UB 19-0760 03/29/19 2.80 2.80
16,212.78$
Payroll
532929 01/20/17 Monson, Ryan 1/1/17-1/15/17 52.50
533091 03/20/17 Miller, Kyle 3/1/17-3/15/17 26.64
533130 04/05/17 Miller, Kyle 3/16/17-3/31/17 26.64
533689 04/20/17 Miller, Kyle 4/1/17-4/15/17 90.06
534057 09/20/17 Jimenez, Armando 9/1/17-9/15/17 72.49
535075 02/05/18 Osman, Adnan 1/16/18-1/31/18 134.84
535075 12/02/18 Bassinger, Jeanninne 12/1/18-12/15/18 2.93
534824 09/20/18 Tukwila Pantry Donation 45.00
534827 09/20/18 United Way Donation 15.00
466.10$
Total:16,678.88 4
City of Tukwila
Allan Ekberg, Mayor
INFORMATIONAL MEMORANDUM
TO: Finance Committee
FROM: Vicky Carlsen, Finance Director
BY: Cindy Wilkins – Fiscal Specialist
CC: Mayor Ekberg
DATE: September 14, 2020
SUBJECT: Cancellation of Accounts Receivable
Updated after the Finance Committee Meeting on Monday, September 14,
2020
ISSUE
Each year a resolution comes before the Council for the cancellation of uncollectable accounts
receivable. For 2020, these items include: False Alarms equaling $2,650.00, Miscellaneous
Billings equals $14,635.74 for a grand total of $17,285.74.
BACKGROUND
The process for tracking accounts receivable is quite thorough. The steps below are followed
prior to preparation of the attached write-off resolution.
Invoice is sent to the recipient by the Finance Department payable in 30 days.
If payment is not received within 30 days, the receivable is forwarded to our collection
agency, Armada Corp., and placed into pre-collect status.
At this time, Armada sends a Delinquency Notice to debtor notifying them of the past-due
status of the receivable and asks them to contact the City to make payment. Payments
can still be made directly to the City while in pre-collect status.
Once 30 days has passed in pre-collect status, the receivable then rolls over to active
collections. At the onset of active collections, a letter is sent to the debtor notifying them
of status change and advising that all payments must now be made through the
collection agency.
When in active collections status, debtor is contacted both by phone and letter. A search is
made for assets with which the debt could be satisfied. Once the debt has been in active
collections for 45 days, it is then reported to the national credit bureaus.
The last process in the collections cycle is the pursuit of legal action. This includes
attaching checking accounts, garnishments and lawsuits.
The City will not issue or renew a business license until all outstanding debt owed to the
City is paid.
It should be noted that while a debt may be written off our books: it is still active in
Armada’s collection process.
DISCUSSION
The proposed amount of the 2020 Cancellation of Accounts Receivable is $17,285.74. This is
an annual housekeeping item.
FINANCIAL IMPACT
The financial impact of cancelling $17,285.74 will be to reduce our accounts receivable balance
by this amount. Please note that while we are writing off the accounts receivable for accounting 5
INFORMATIONAL MEMO
Page 2
purposes., the accounts are still being actively worked for collection purposes with the exception
of those accounts where a responsible party cannot be identified. Accounts covered by
bankruptcy law cannot be pursued.
RECOMMENDATION
The Council is being asked to approve the annual resolution authorizing the cancellation of
Accounts Receivable and to forward this item to the Regular Meeting Consent Agenda of
9/21/20.
ATTACHMENTS
Attachment A – 2020 AR Write-Offs 2018 and Prior
Attachment B – Historical Write-Offs
6
: ?:RUG3URFHVVLQJ?5HVROXWLRQV?3DVW 'XH$FF WV5HFHLYDEOHV
&: EMV 5HYLHZDQGDQDO\VLVE\%DUEDUD6D[WRQ 3DJHRI
$5(62/87,212)7+(&,7<&281&,/2)7+(
&,7< 2) 78.:,/$:$6+,1*72125'(5,1*
7+(&$1&(//$7,212)3$67'8($&&28176
5(&(,9$%/(
:+(5($6FHUWDLQUHFHLYDEOHVDQGFKHFNVKDYHEHHQGHHPHGXQFROOHFWDEOHDIWHU
HIIRUWVE\ERWKWKH&LW\DQGDFROOHFWLRQDJHQF\KDYHEHHQXQVXFFHVVIXO DQG
:+(5($6LQWKHHYHQWRIQHZLQIRUPDWLRQWKH&LW\ZLOOFRQWLQXHWRSXUVXHWKHVH
UHFHLYDEOHVZKHQ HYHU SUDFWLFDO
12: 7+(5()25( 7+( &,7< &281&,/ 2) 7+( &,7< 2)78.:,/$
:$6+,1*721+(5(%<5(62/9(6 $6)2//2:6
0LVFHOODQHRXV$FFRXQWV5HFHLYDEOH 7KH WRWDORI SHU$WWDFK PHQW$
LVGHHPHGXQFROOHFWDEOH
3$66('%<7+(&,7<&281&,/2)7+(&,7<2)78.:,/$:$6+,1*721DW
D5HJXODU0HHWLQJWKHUHRIWKLVBBBBBBBGD\RIBBBBBBBBBBBB BBBBB
$77(67$87+(17,&$7('
&KULVW\2
)ODKHUW\00&&LW\&OHUN 'H¶6HDQ4XLQQ&RXQFLO3UHVLGHQW
$33529('$672)250%<
)LOHGZLWKWKH&LW\&OHUN
3DVVHGE\WKH&LW\&RXQFLO
5HVROXWLRQ1XPEHU
2IILFHRIWKH &LW\$WWRUQH\
$WWDFKPHQW $ :ULWH2IIV
7
Attachment A - 2020 Write-Offs
Acct #Customer Name Date Invoice #Billing Description GL Account Amount Notes
000154 KRAMER KONSTRUCTION 09/11/18 RT-00076 REINSPECTION TENANT FEES R 000.342.400.02.00 100.00 To Collections 1/27/2020
100.00$
000104 BEVERLY NUAMAH 04/17/18 PF-03742 POLICE FALSE ALARM #3 R 000.342.800.00.00 150.00 To Collections 10/8/2019
SOMALI SOMGRO Inc 05/31/18 PF-03754 Police False Alarm #3 R 000.342.800.00.00 150.00 To Collections 8/10/2018
000104 BEVERLY NUAMAH 07/05/18 PF-03782 POLICE FALSE ALARM #4 R 000.342.800.00.00 200.00 To Collections 10/8/2019
000125 TOYS R US DELAWARE INC 07/05/18 PF-03775 POL FALSE ALARMS #3-7 R 000.342.800.00.00 950.00 To Collections 10/8/2019
000146 JET FUEL ESPRESSO 08/29/18 PF-03808 POL FALSE ALARM #3 R 000.342.800.00.00 150.00 To Collections 1/27/2020
000193 Seattle Char/Habit Burger 11/14/18 PD-00178 Police False Alarm #3 R 000.342.800.00.00 150.00 To Collections 10/8/2019
000180 Electronic Service Provider 11/17/18 PD-00152 Police False Alarm #3 R 000.342.800.00.00 150.00 To Collections 8/17/2020
000104 BEVERLY NUAMAH 11/19/18 PD-00205 POLICE FALSE ALARM #5 R 000.342.800.00.00 200.00 To Collections 8/17/2020
000146 JET FUEL ESPRESSO 11/19/18 PD-00201 POLICE FALSE ALARM #4 R 000.342.800.00.00 200.00 To Collections 1/27/2020
000207 Church by the Side of the Road 12/17/18 PD-00222 Police False Alarm #3 R 000.342.800.00.00 150.00 To Collections 10/8/2019
000193 Seattle Char/Habit Burger 12/29/18 PD-03843 Police False Alarm #4 R 000.342.800.00.00 200.00 To Collections 10/8/2019
2,650.00$
EZELL EDWARD EZELL 07/20/17 MB-02619 Property Damage WORK ORDER 21701601 R 000.344.100.00.00 12,378.28 To Collections 10/13/2017
000258 JASMINE LYONS 12/31/18 PM-00113 Property Damage WO 21801607 CASE 18-7205 R 000.344.100.00.00 2,157.46 To Collections 10/8/2019
14,535.74$
Total Write-Offs: 17,285.74$ 8
Attachment B - Historical Write-Offs
Resolution 1777 2012 8,777.89$
Resolution 1805 2013 30,702.97$
Resolution 1843 2014 36,240.62$
Resolution 1865 2015 27,887.91$
Resolution 1893 2016 47,680.46$
Resolution 1916 2017 9,005.25$
Resolution 1948 2018 12,832.35$
Resolution 1969 2019 53,109.56$
Resolution 2020
2019 Cancellation of Accounts Receivables - Finance Committee 092319
9
10
City of Tukwila
Allan Ekberg, Mayor
INFORMATIONAL MEMORANDUM
TO: Finance Committee
FROM: Joseph Todd, TIS Director
BY: Mike Marcum, Supervisor of Technical Operations
CC: Mayor Ekberg
DATE: 8/26/20
SUBJECT: Zayo- Contract for Internet Services
ISSUE
Technology and Innovation Services is seeking approval to renew and upgrade the Zayo
contract for fiber-optic internet services, while discontinuing the 1G Express Route connection.
BACKGROUND
Tukwila has two fiber-optic services:
1G Fiber Express Route, $1500/mo
2G DIA, Tukwila's primary internet connectivity, $3250/mo
DISCUSSION
Benefits to the City:
Immediate monthly cost-savings with reduction of 1G line
Internet service speeds will increase in speed from 2G to 5G
Increased internet speeds are a necessity as we migrate fully to a cloud-computing
environment.
FINANCIAL IMPACT
Tukwila will maintain the same monthly charge of $3,250/mo
Contract renewal is for 5 years, a total cost of $195,000
Discontinuing the Express Route service will save $1500/mo
RECOMMENDATION
TIS is seeking the consideration of the Zayo contract from the Finance Committee, and to
forward to the September 14, 2020 Committee of the Whole Meeting and subsequent Special
Meeting Consent Agenda, for final approval
ATTACHMENTS
Zayo Contract for Internet Services
11
12
Page 1 of 3
Order Form
Order Information
City Of Tukwila, WA City Of Tukwila 4760
Joseph Todd (206) 552-1280 joseph.todd@tukwilawa.gov
Richard Adair richard.adair@zayo.com
Renewal Order - 1726621
Order Details
Order Details
Order ID 1726621
Order Type Renewal
Order Term 60 months
Product DIA
Service 400747
Product Details
Product Category DIA
Bandwidth 5G
Bandwidth Type Standard
Max Burst Speed 10G
Price Per Mb for Burst Usage USD 1.50
Circuit Options Cat 5 - FE
Circuit Id UA/KGED/866725//INTG
Legacy Circuit ID UAKGED866725INTG
Protection and Feature Details
Burstable IP Service No
Core-Network Fiber Path Diversity No
Core-Network Protection No
Special Routing Required No
Order Component(s)
SOC Type Term Address Port Handoff Sp Bandwidth Lateral A Handoff Loc Fib Path Div Local Network Protection Rate Limit Rate Limit to Initials
Renewal 60
6200 Southcenter
Blvd/Fl-1/Rm-police dept.
data closet Seattle, WA
10GigE 5G
Copper
(RJ-45
Electrical)
5G \SOF1\
Order Component(s)
Address In-Building Charges Conduit Riser Cable Cross Connect Customer LOC Space & Power New Customer Loc Device CFA Provided by Initials
6200 Southcenter
Blvd/Fl-1/Rm-police dept.
data closet Seattle, WA
Customer
Responsibility
Customer
Responsibility
Customer
Responsibility
Customer
Responsibility Zayo \SOF1\
Pricing
Product Service Item Desc Component Component Address Type Status Quantity Amount Items Total
DIA Interface Port Charge - MRC SOC-0004193136 6200 Southcenter Blvd/Fl-1/Rm-police dept. data closet Seattle
WA MRC Active 1 USD
1,625.00
USD
1,625.00
DIA Interface Port Charge - MRC SOC-0004193136 6200 Southcenter Blvd/Fl-1/Rm-police dept. data closet Seattle
WA MRC Active 1 USD
1,625.00
USD
1,625.00
DIA Block of IP Addresses SOC-0004193136 6200 Southcenter Blvd/Fl-1/Rm-police dept. data closet Seattle
WA MRC Active 1 USD 0.00 USD 0.00
DIA Network Monitoring/NCC SOC-0004193136 6200 Southcenter Blvd/Fl-1/Rm-police dept. data closet Seattle
WA MRC Active 1 USD 0.00 USD 0.00
Monthly Recurring Charges
Total:
USD
3,250.00
Contract Details
Details
Contracting Entity Billing Account Account
Number
Contact Phone Email
Representative Phone Email
13
Page 2 of 3
Governing MSA City Of Tukwila - 6200 Southcenter Master Service Agreement (ELI) 2010-04-23
Order Notes
Pricing on this Order Form expires if Order is not signed prior to September 18, 2020
ETL Waiver. The Parties agree that upon Customer's execution of this Service Order, Customer may request that Zayo disconnect the Service
on Circuit ID ETYX/154833//ZYO ("Disconnected Services") without penalty to Customer by providing Zayo with 30 days' written
notice. Customer shall remain liable for payment for Services rendered through the date of termination for the Disconnected Services. The
Parties agree that any early termination penalty that would have been due to Zayo for Customer’s early termination of the Disconnected
Services will be waived upon Customer’s satisfaction of the terms and conditions under this Service Order. In the event that Customer does not
satisfy the terms and conditions under this Service Order, or if Customer fails to accept Service under this Service Order, Customer will be
liable for all applicable early termination penalties associated with Disconnected Services.
Expiration Date
Additional Terms and
Conditions
14
Page 3 of 3
Order ID(s): 1726621
Grand Total Costs
Service Item Desc Items Total
Monthly Recurring Charges Total:USD 3,250.00
Taxes and impositions As Invoiced²
Signatures
Zayo Group LLC City Of Tukwila, WA
Signature:\s2\Signature:\s1\
Printed Name:\n2\Printed Name:\n1\
Date:\d2\Date:\d1\
Title:\t2\Title:\t1\
Terms and Conditions
1. Customer acknowledges that Customer is ordering the access and service(s) described above (“Offering”) from Zayo Group, LLC, and or its applicable affiliate or subsidiary
(“Zayo”). This Customer Order shall be governed by and subject to the applicable contract documents between Customer and Zayo referenced above (collectively, the
"Agreement”). If Customer has not executed an Agreement and/or no Agreement is referenced in this Customer Order, then this Customer Order shall be governed by the
terms and conditions of Zayo’s Master Customer Agreement and applicable Customer Schedule in effect as of the date of this Customer Order, incorporated herein by this
reference and available upon request. This Customer Order is subject to availability and shall only become binding upon acceptance by an authorized Zayo representative.
Customer acknowledges that upon Zayo’s acceptance, this Customer Order shall become a non-cancellable, binding obligation for the purchase of the Offering for the Offering
Term stated above. By signing this Customer Order, Customer further acknowledges that it has read and understands the terms and conditions of this Customer Order and
Customer’s signatory represents that he/she is authorized to sign this Customer Order on Customer’s behalf.
2. All charges for the Offering in this Customer Order are exclusive of any taxes and other fees and surcharges (as defined below). Except for taxes based on Zayo’s net
income, Customer shall be responsible for payment of all applicable taxes that arise in any jurisdiction, including, without limitation, value added, consumption, sales, use, gross
receipts, excise, access, and bypass (“Taxes”). Customer shall also be responsible for any property tax surcharges, additional government fees (including without limitation
Federal and State regulatory fees), franchise fees, rights of way fees or charges, license or permit fees, and any other duties, fees, charges or surcharges imposed on incident
to, or based upon the provision, sale, or use of the Offerings.(“Other Fees and Surcharges”) If applicable to the Offerings being purchased by Customer, such Other Fees and
Surcharges will be listed on Customer’s Invoice. If Customer is entitled to an exemption from any of the Taxes or Other Fees and Surcharges, Customer is responsible for
presenting Zayo with a valid exemption certificate (in a form reasonably acceptable to Zayo). Zayo will give effect to any valid exemption certificate provided in accordance with
the foregoing sentence to the extent it applies to any Offering billed by Zayo to Customer following Zayo’s receipt of such exemption certificate. Customer shall indemnify,
defend and hold Zayo harmless from payment and reporting of all such Taxes and Other Fees and Surcharges, including costs, expenses, and penalties incurred by Zayo in
settling, defending or appealing any claims or actions brought against Zayo related to, or arising from, the non-payment of such Taxes and/or Other Fees and Surcharges.
3. In support of Zayo meeting the FOC Date, Customer specifically acknowledges that Customer is responsible for all connectivity (and related costs) to Zayo's Components
(i.e. cross-connections between (i) the Zayo demarcation point and Zayo's Components and (ii) Zayo's Components and Customer Components). In addition, Customer shall be
responsible for securing all rights and paying the related costs to connect to Zayo's Components, for securing all rights and paying the related costs to access, occupy, and
conduct typical telecommunication operations within each respective building (including any necessary rights for Zayo to enter and access each building), and for providing all
necessary cable pathways (all of the preceding may include, but not be limited to, construction permits and underlying rights, building access and/or occupancy agreements,
building access and/or occupancy fees, lateral fees, riser fees, cross-connects and cross-connect fees, coordination at any third party owned location, and, where applicable,
necessary space for Zayo’s fiber termination panel and Zayo's Components). All of the rights above, collectively, shall be referred to as “Customer Requirements” and the
related costs and fees, collectively, shall be referred to as “In-Building Charges”. Unless this Customer Order indicates that Zayo is responsible for In- Building Charges,
Customer shall reimburse Zayo in the event that a third party bills Zayo for any In-Building Charges. Customer acknowledges that any delay in Customer providing such
Customer Requirements may delay Zayo from completing work at any location. In the event that Customer has not provided the Customer Requirements in time to allow Zayo
to complete work at any location on or before the FOC Date, then Zayo may continue with the acceptance procedures to the extent possible and deem the Offering delivered
and accepted.
4. If Customer is discontinuing Offering (s) of any type for any reason, Customer must submit the disconnection request through the form located at
https://www.zayo.com/disconnectservice/.
Proprietary and Confidential
15
16
City of Tukwila
Allan Ekberg, Mayor
INFORMATIONAL MEMORANDUM
TO:
FROM:
BY:
CC:
DATE:
Finance Committee
Vicky Carlsen, Finance Director
Aaron Williams, Fiscal Coordinator
Mayor Ekberg
September 4, 2020
SUBJECT: Sales Tax & Misc. Revenues – 2nd Quarter 2020
Year Over Year Sales Tax Comparison:
The global COVID-19 pandemic began impacting businesses and city revenues late in the first quarter. By the
end of March many businesses were closed due to the stay home orders, which continued through much of the
second quarter of 2020.
Through the first half of the year, sales taxes are $2M behind the total collected for first half of the prior year.
Industries such as retail trade and services have been significantly impacted, accounting for much of the total
decline. At the same time, construction sales taxes have remained strong exceed the first half of the prior year
by $416k.
17
INFORMATIONAL MEMO
Page 2
Budget to Actual Sales Tax Comparison:
The 2020 adopted budget for sales taxes is $19.911 million, which is nearly equal to total collections for 2019.
This budget has been revised to reflect a $7.6M anticipated impact from the COVID-19 pandemic; for a total
adjusted budget of $12.3M.
18
INFORMATIONAL MEMO
Page 3
The chart above compares the prior year-to-date totals to the current year-to-date totals for the eight major
categories of sales tax. Construction sales taxes are up significantly compared to the prior year; this is helping
offset some declines in other categories.
The decline in Automotive is related to one-time revenues received in 2019.
Retail Trade and Services were the hardest hit categories from the economic shutdowns and reflect a combined
$2M decline from the prior year.
19
INFORMATIONAL MEMO
Page 4
Traditionally the top three categories have been General Merchandise, Food Services and Clothing &
Accessories. During the ongoing pandemic and the mandated economic shut-downs, many of these businesses
experienced significant declines in taxable sales. Meanwhile, the Construction sector has been performing
strong and is currently in the top position with nearly $950k of taxes collected year-to-date.
The chart above shows the ten largest declines compared to the prior year.
Many of these categories were directly impacted by the economic shutdowns and changes to consumer
shopping habits. The decline in the Motor Vehicle and Parts Dealer category is related to one-time revenues
received in 2019 from bus deliveries.
20
INFORMATIONAL MEMO
Page 5
YTD YTD
NAICS CONSTRUCTION 19 TOTAL 19 YTD 20 YTD % Diff NAICS AUTOMOTIVE 19 TOTAL 19 YTD 20 YTD % Diff
236 Construction of Buildings 1,670,033 546,031 947,616 73.5% 441 Motor Vehicle & Parts Dealer 963,914 682,519 197,854 -71.0%
237 Heavy & Civil Construction 89,166 23,337 37,162 59.2% 447 Gasoline Stations 99,694 47,419 50,032 5.5%
238 Specialty Trade Contractors 459,712 204,516 205,424 0.4%TOTAL AUTOMOTIVE 1,063,607$ 729,938$ 247,887$
TOTAL CONSTRUCTION 2,218,910$ 773,884$ 1,190,202$ ($482,051) -66.0%
416,319$ 53.8%
NAICS RETAIL TRADE 19 TOTAL 19 YTD 20 YTD % Diff
YTD 442 Furniture & Home Furnishings 565,878 264,868 193,726 -26.9%
MANUFACTURING 19 TOTAL 19 YTD 20 YTD % Diff 443 Electronics & Appliances 1,149,541 493,413 333,279 -32.5%
311 Food Manufacturing 26,862 12,903 11,649 -9.7% 444 Building Material & Garden 835,211 415,488 471,466 13.5%
312 Beverage & Tobacco Products 12,837 6,150 5,317 -13.5% 445 Food & Beverage Stores 311,945 148,533 138,579 -6.7%
313 Textile Mills 130 13 1,537 11572.0% 446 Health & Personal Care 274,638 139,187 75,833 -45.5%
314 Textile Product Mills 11,628 5,571 4,429 -20.5% 448 Clothing & Accessories 1,996,280 871,694 380,917 -56.3%
315 Apparel Manufacturing 367 261 283 8.6% 451 Sporting Goods, Hobby, Books 508,525 226,448 152,679 -32.6%
316 Leather & Allied Products 73 34 53 54.0% 452 General Merchandise Stores 2,167,481 917,603 712,051 -22.4%
321 Wood Product Manufacturing 3,105 1,121 30,558 2626.3% 453 Miscellaneous Store Retailers 857,091 405,508 346,913 -14.4%
322 Paper Manufacturing 22,299 10,828 9,556 -11.7% 454 Nonstore Retailers 137,655 60,604 91,701 51.3%
323 Printing & Related Support 25,202 7,283 13,956 91.6%TOTAL RETAIL TRADE 8,804,245$ 3,943,346$ 2,897,143$
324 Petroleum & Coal Products 103 54 27 -50.4%($1,046,203) -26.5%
325 Chemical Manufacturing 4,124 2,215 1,299 -41.3%
326 Plastic & Rubber Products 4,068 2,720 1,158 -57.4%YTD
327 Nonmetallic Mineral Products 5,827 4,175 3,374 -19.2%SERVICES 19 TOTAL 19 YTD 20 YTD % Diff
331 Primary Metal Manufacturing 872 641 164 -74.5% 51X Information 988,506 536,851 321,594 -40.1%
332 Fabricated Metal Mfg Products 6,122 2,810 3,361 19.6% 52X Finance & Insurance 65,075 26,139 49,702 90.1%
333 Machinery Manufacturing 4,188 2,129 2,388 12.2% 53X Real Estate, Rental, Leasing 707,128 348,293 314,835 -9.6%
334 Computer & Electronic Products 14,628 8,914 7,451 -16.4% 541 Professional, Scientific, Tech 704,072 292,504 371,750 27.1%
335 Electric Equipment, Appliances 18,412 7,095 14,183 99.9% 551 Company Management 53 37 0 0.0%
336 Transportation Equipment Mfg 41,256 23,928 824 -96.6% 56X Admin, Supp, Remed Svcs 325,783 157,607 154,524 -2.0%
337 Furniture & Related Products 7,015 4,323 2,399 -44.5% 611 Educational Services 5,953 2,851 2,440 -14.4%
339 Miscellaneous Manufacturing 29,576 12,157 12,721 4.6% 62X Health Care Social Assistance 85,567 36,842 33,833 -8.2%
TOTAL MANUFACTURING 238,694$ 115,326$ 126,688$ 71X Arts & Entertainment 314,765 156,286 56,363 -63.9%
$11,362 9.9%721 Accommodation 744,823 354,126 138,924 -60.8%
722 Food Services, Drinking Places 2,080,421 1,011,584 602,223 -40.5%
YTD 81X Other Services 227,568 123,070 70,313 -42.9%
TRANSPORTATION & WAREHOUSING 19 TOTAL 19 YTD 20 YTD % Diff 92X Public Administration 14,275 7,800 10,632 36.3%
481 Air Transportation 0 0 -2,482 0.0%TOTAL SERVICES 6,263,989$ 3,053,990$ 2,127,131$
482 Rail Transportation 46 25 13 -50.0%($926,859) -30.3%
483 Water Transportation 305 264 113 -57.0%
484 Truck Transportation 1,916 1,070 778 -27.3%
485 Transit and Ground Passengers 859 566 408 -28.0%YTD
487 Scenic and Sightseeing Tran 1,338 597 197 -67.0%MISCELLANEOUS 19 TOTAL 19 YTD 20 YTD % Diff
488 Transportation Support 55,956 24,797 94,983 283.0% 000 Unknown 0 0 0 0.0%
491 Postal Services 797 423 336 -20.6% 111-115 Agriculture, Forestry, Fishing 1,991 214 410 91.7%
492 Couriers & Messengers 2,494 1,341 637 -52.5% 211-221 Mining & Utilities 1,235 676 233 -65.5%
493 Warehousing & Storage 1,845 904 2,081 130.2% 999 Unclassifiable Establishments 104,627 60,124 103,055 71.4%
TOTAL TRANSP & WHSING 65,555$ 29,988$ 97,063$ MISCELLANEOUS TOTAL 107,853$ 61,014$ 103,698$
$67,076 223.7%$42,684 70.0%
YTD
WHOLESALE TRADE 19 TOTAL 19 YTD 20 YTD % Diff
423 Whls Trade-Durable Goods 987,675 481,138 402,733 -16.3%YTD
424 Whls Trade-Nondurable Goods 163,323 75,352 68,276 -9.4%19 TOTAL 19 YTD 20 YTD % Diff
425 Wholesale Electronic Markets 2,609 1,708 1,756 2.8%GRAND TOTALS $19,916,461 $9,265,684 $7,262,578
WHOLESALE TRADE TOTAL 1,153,607$ 558,198$ 472,765$ ($2,003,105) -21.62%
($85,433) -15.3%($2,419,424) -28.49%Grand Total Change from Previous Year - Without New Construction
Overall Miscellaneous Change from Previous Year
Overall Services Change from Previous Year
Overall Wholesale Change from Previous Year
Overall Construction Change from Previous Year
Overall Automotive Change from Previous Year
Overall General Retail Change from Previous Year
Overall Manufacturing Change from Previous Year
Overall Transportation Change from Previous Year
Grand Total Change from Previous Year
SALES TAX SUMMARY
JAN-JUN 2020 Sales Taxes (Received in Mar-Aug '20)
21
INFORMATIONAL MEMO
Page 6
Gambling, Admission and Telecommunications Tax revenue totals in the charts below reflect the quarter in
which the economic activity occurred (accrual basis) as opposed to when the revenue is received (cash basis).
The budgets for Gambling and Admissions Taxes were revised down based on the anticipated impacts of the
economic shutdowns related to the ongoing pandemic.
The Telecommunications Utility Tax was not anticipated to have measurable impacts related to the coronavirus
pandemic; this tax has been on a downward trend over the past few years. The trend is reflective of consumer
preferences and changes in the communications industry.
(a) Gambling tax includes card games, punch boards, pull tabs and amusement games.
(b) Telecommunications Utility tax includes cellular, pager and telephone usage.
(c) Actuals reflected in Schedules IV, V and VI are amounts earned for the quarter.
22