HomeMy WebLinkAboutFS 2011-03-08 COMPLETE AGENDA PACKET ILA iv City of Tukwila Distribution:
('-.NN K. Hougardy C. O'Flaherty
4 dt,, y J. Hernandez S. Kerslake
Finance and Safety D. Robertson K. Matej
C> A. Ekberg B. Arthur
Committee Mayor Haggerton C. Parrish
S. Lancaster P. Linder
''‘11 O Kathy Hougardy, Chair
2906 O Joan Hernandez
O Dennis Robertson
AGENDA
TUESDAY, MARCH 8, 2011
CONFERENCE Room #3, 5:00 PM
Item Recommended Action Page
1. PRESENTATION(S)
2. BUSINESS AGENDA
a. Public Crime Information Sharing Website. a. Committee review and Pg.1
Don Lincoln, Assistant Police Chief, and input.
Trina Cook, Police Information Analyst
b. 2010 Investment Report for 4th Quarter. b. Information only. Pg.11
Peggy McCarthy, Deputy Finance Director
c. Sales Tax Report. c. Information only. Pg.17
Shawn Hunstock, Finance Director
3. ANNOUNCEMENTS
4. MISCELLANEOUS
Next Scheduled Meeting: Tuesday, March 22, 2011
IS. The City of Tukwila strives to accommodate individuals with disabilities.
Please contact the City Clerk's Office at 206 433 1800 or (tukclerk @ci.tukwila.wa.us) for assistance.
blank
ICA�° (-0 a o Tukwila
City Jim Haggerton, Mayor
:90 INFORMATIONAL MEMORANDUM
TO: Mayor Haggerton
Finance and Safety Committee
FROM: Trina Cook, Police Information Analyst
DATE: March 1, 2011
SUBJECT: Public Crime Information Sharing Website
ISSUE
The Tukwila Police Department would like to provide case report information to the public using
the internet.
BACKGROUND
Several years ago, we were tasked with providing police calls for service information on the
Internet. We secured funding and selected a vendor that would provide extensive crime analysis
tools to the department as well as a public facing system. However, Valley Communications
was unable to partner with us on that project, as they were working on upgrading the dispatch
system (which is not yet implemented). We need their participation in order to connect to the
calls for service data.
DISCUSSION
At this time, we are tasked with providing any sort of crime information on the Internet. The
information available to us that is most timely is case report information. The data connection
will be handled internally, with a one -time initial set -up handled by our IT Department and Police
Department staff. Three vendors that provide case report data to the public were selected for
comparison. None of these low -cost options offers analytical tools beyond what is also available
to the public.
Original funding for this project covered a one -time software purchase, however these products
are covered with an annually -paid monthly service fee.
RECOMMENDATION
The Finance and Safety Committee is being asked to review the options and provide input on
the vendors presented.
ATTACHMENTS
Vendor comparison chart
Supporting documents from Bair Software, CrimeReports, and The Omega Group.
1
Public Crime Information Sharing Website
Vendor Comparison
/endor Name 3 U1lebsite :fx r Benefrts Over Other Ve do`rs 3g
Cost
Bair Software www.bairsoftware.com cost free
CrimeRe ports www.crimere orts.com also provides data for nearby jurisdictions (Burien, Seatac, Des Moines,
p p Renton); established the longest; has most participating agencies $100 /month
The Omega Group www.crimemapping.com $100 /month 1
Bair So
4rx 4
fir'?. '„t't i 'x I
REGIONAL ANALYSIS I :FQR ATION DMA SHARING
Overview of RAIDS
Bair Software Inc.
support@bairsoftware.com
(800) 380 -1138
3
CoriFideniial RAIDS()
REGIONAL ANALYSIS 8. INFORMATION DATA SNARING
Regional Analysis Information Data Sharing
RAIDS was developed as a free community policing service for law enforcement. RAIDS helps law enforcement
provide useful, up -to -date crime information and alerts to the public.
RAIDS Online is free to any law enforcement agency
How can Bair Software offer RAIDS Online for free?
Bair Software offers RAIDS Online as a free service to any law enforcement agency who
wishes to participate. At present, most agencies spend thousands of dollars annually to
provide even the most basic crime map to their community. With RAIDS Online, law
enforcement agencies can offer this service to the public at absolutely no cost to the
department. Bair Software is offering RAIDS Online for free for two reasons. One is that
RAIDS Online helps Bair Software meet our corporate mission to improve public safety, and
the other is that RAIDS Online brings exposure to our other analytical products and services
in a way that expensive advertising does not.
RAIDS revolutionizes public crime data sharing
RAIDS Online
Crime information is displayed to the public in RAIDS Online, an easy to use online interface with three views of
crime data: map, data grid and analytics dashboard. RAIDS Online integrates the three views into a simple tabbed
interface. All three views update dynamically as the public adjusts the crime types, date range and search area of
interest to them.
Advanced analytics, like density maps and temporal topologies, are available for public viewing to guide their
interpretation of crime trends in their neighborhood. The RAIDS Blog supports these analytics with useful
information about how to interpret crime graphs and charts correctly.
Metadata, such as the data source and geocoding accuracy for crimes in view, are displayed to improve
transparency and trust between law enforcement and the public.
RAIDS Blog
RAIDS educates the public about how to interpret crime trends and how to stay safe with RAIDS Blog, a centralized
resource of useful information provided by police officers, crime analysts and other law enforcement
professionals. Individuals from participating agencies are welcome and encouraged to submit articles that
communicate directly with their community.
RAIDS Citizen on Patrol
RAIDS helps law enforcement quickly broadcast important information and alerts to the public with RAIDS Citizen
On Patrol (COP). COP allows the public to sign up for email or text message alerts that come directly from their
local law enforcement agency. Amber alerts, crime BOLOs and other important messages are easily sent by a law
enforcement representative through an online interface to participating community members.
.,:air Sofiwcjre Inc.
4
Confidential
REGIONAL ANALYSIS INFORMATION DATA SHARING
Neighborhood Watch
The public can sign up for email alerts about recent crime activity in their neighborhood. Users simply input an
address and search radius to receive updates for that specific area.
The RIDS Online Interface
Map
RAIDS Online displays limited crime data to the public in Google Maps' well known, intuitive mapping interface.
Crime type, street -level address, address name and date and time are displayed for the public. Filtering capabilities
include address search, buffer and date constraints.
Data Grid
RAIDS Online gives the user full control over how data is displayed. In "Data Grid" view users can turn on and off
columns and sort data based on any variable. Data in the grid automatically updates based on the incidents
displayed on the map.
AnaiVtics
Meaningful, visually stunning graphs help users visualize crime trends in their area. Graphs automatically update
based on the data that is displayed on the map giving user's full control over what data they would like to analyze.
Metadata
it is important for the public to feel confident in the data that they are viewing. RAIDS Online's Metadata tab
displays useful information about the data that is being displayed. The source of the data, accuracy of points on
the map and other useful information displayed in RAIDS Online help improve transparency and trust between law
enforcement and the public.
3air Sof w :re Inc.
5
A ti;,,,,,
47, t..,-- r,•,--„, h 1 ts f 6
1, .,,f 4.1:,•.;„i_i ..:,^.z.. t,
Th- F7-
t.
f,--:-, r.5.74 rec r4 Esz 1 k., rvi 1
1.,:: 'd ,3:.1 ,g ,,1 fq 1 EM a h IA .f, 141 0 .4u. 1
0 a VA 6,
...,__............:...:......„.2.=4..-
fk ..z. ''',.,,".„;i.,:;.'4:: r.,:','"•=5.,- M
r 1'..: 1 51 .z4
ro..A9,i
It,
i4
e.--A
,..21 4..- la r nim„
7 tUrli.:=
'=:';q;it4.:".,Ei.:.'Hir
1, 1 -.'w- ';:f.-'24.:., Tgl.; r...--,0" 1a iii. i-
1.[7.iir.,,7;,,-11-!„ 1 1 ,y,,,,,,,-,:i-,147.4r.,;,,-.„,d,.,...1.L.-r.-1,4, z;
i, ,...•0, `-4,:litikitOt.rif ''.,N r'.„L':'.:4-,J,,,-.12',No' k''..,,,,,','''',
;-.7,:.,Zr,.k.:i,.,..tti'''',12.:_.:4'r.:.:', 141,40?1, _W.371.1104? 4.4 I e ri rr:, 0 1 7'. ,,7,.
61 ,r' 1 6 .5*.V i 1, 14 1 i.r. rat.' 10444 `",-Y,' T '..;,:y.ci■N r J .W„?—, ,F4Wp ,r, I i .2
'41 N 'f1=r-;-,,.,,,_ t ..'x. ..,.,-,4,;;.3'.:. Yc.,.11 :.4.'.i. 7' 0 ---,.p,' e,,,, 1 tf,,7
Ti,i -.7.7.:1:.- 7.,- .1:,n4t. A,: j .1:;;v---,,L,.r., m:orqicalio ,„p) tit
4.4.01,:0,41. .'14. ,,,„,,,,r4,.; 1" i j 2 1 p. ,g.'.5"::. I. 0 1_ 4 le l ,70..k..
7.1,.,, 4. adtila G 'VII La! s, 'S i FL,I ..1 -,.,j 'F'i g;.b t_.;;;:- .,1 -'''''''t.' i';'."';'),,,,,-,1
4- 1 4 40 1 V' rc -I. 'I;" E. .1 1 r `tf-k; i'
5 torc '''ri it ''T'' i I. i i 1 ..s
www.crimereports.com
,::,...zu. i•iii
Report 1 4 Give your citizens the
4 Crime Reports
h..
Nk
Crime s ,1-,21,i4 Eat
k•Z4
LA, 1-..nrottr,T, Neno,cs. pit information they need to
orotPct themselves and
1 10
i''''''2'...7;;:i''';'."7,,, -2 .71710 L;.,,:.,..',.,:.-- ;,,,,..,'''.,.Aiv.,.'''''''r;VS.,-ti.„
prevent crime.
T ,n 3,s,,,7,44144,'„,444,-.4,,,A...f.„„v:„.,,r,,,,,,,,
P
171 :7....:. ,;t,.,...: I m.p 1 SWelabs 1 Hybrli
71 iE TT F ?Mg VE I IICTL E 1". VR. :•:•:ii iJi i',..-d "".„1.
5,•:'''
i i,„,.L .„:.4.,P,,/,'•;:f''.1:,„1,"- ;,4„.-........xj,:',4?,..',
'i-:.,:. $kig,' 2 Ithl rf 4 "'2'
i 3 7, i 1:7 '1 1' 1'j:. ,.1 ..r17:f F ■1„:::s1.:141TI4.4, :4g.,..
j.',t'di .1":•;;..1;.1-',';.,,.,' ,I ‘izi) 4: 'TrLi4..rel A l'
•.py•
lie ;';,-:-.2:Pj :.9J.J.,..:1,,;-ii-j.,i-..---:Pg'ir,',:gorrP.
r .1 r '''1 14- fle 3, 1.V e.l, _i f•••,-: i,Lie.„5::, .i. %',o,a, 1 .,1/1 ,figk 7L. pl, J Ii
V 1:1:41 f' :(13:::- ;2.:. '',Y, !C14°.-tH:A:).';O:...1'..t"C;t714...01791.7,e',:„..2,(411.4;,tH aff. Alq& ,fr.C t' ''4,1
1 .:4? 0,i1,,,,l, ,2"....1-::..,:',.....Y,*
i
c r,
1 THEFT I N ",:i ti" AMI),. i' f.", r■ 'i,' .1 iffilii ,I.,6
i '0 :'.-'1; '-i:'''i 1 ::.kli..14....z. ,,.....-i..! 1
131.
1 4.1il,-*,, L :I' 1 r,,
7 :7
4. ,.,'t'..,,,..r v 1, r. E.:1 L Ial. .,-4,1 T,..,., NT-4
;I 1 44" '13i. v 7 .4494 1 id. 'i 4
,-,14, I 11; S' s ri i';.:4: ;=;:e
,....:101 i t' r-.., ,14Y ,.:-c..::,,.:
u t
r 1 -iF ::11, 0,,?:- .,1, 4' I r!
.111:; 1,b,; 1,44.v .;:i clam
.---...1,,i.'..i-.iq.,,i--T.!.r-:,,.:i'd'r.',7'",ir4c,:j..-,-,:,',1-,,:?,..::_:„,:,i:i,,,.74,,,,....;...„...,.,-:.-_::;:iiirmg7:7,.„,,„,,,:,,„._,
,r I 4:.:-.: ir ir ei,Pi i i• m .v... 11 1,n: .11 .."1, I
fr,"; .,....,7' ,:;,;,'''::.,-,..:1:..,-,.."-,f,,,,,-,- k''^:',1
PREAKING ENTERING '7" N-1... Tr ....:..,..Zi.,,.„■; iry.4441....lyi F-j...p...g:,.......1;.,;.;
4... .f..,..-
';f 4 1
1 li.Vi,','":1'..A:V`
1. k r :.1.4 ,,r,„tt,.f.v 6. "4. •::71,...,4....?'. Lo.'...,,"... .7„..y,'..' .0
0 The largest crime-mapping network in North America, built ....,--Or44.0e,..k,p.,,,q,,,I..,-,:_,-
9 A 7 -4 .1441. 2 4,0 4, -0.f.t „„c„..-,,,,,a,..-.„.„,-
for transparency and community outreach
User-friendly, Google Maps navigation
,.,..4,...a.,yr..,,o,..,...-,,,4,,,,,,,,,,, ..i,--11;,,,L,,rtn,,,;;,„-..;.,...,-.:--•,,...,,:,,,,,
,,,,.f..„,,k f i 2v ,--4.,14.,„.,
T T. F," 4==:'..,..:!;3.-",,.'9I,,-'c'707,,:.',.%-ii.7.Y.4,
N.'-'..1.,':',:;;;11.: ,..4:,
Access data from any computer with an Internet connection
tri:i4:'';'
gi4.'4,r,..,?'Stt''-'47.14,:is):..:;•=5.7.ttlf444017t.,413,1■& VI
Up-to-date, accurate, and agency controlled
-6, i1 ',.':::;,i ';,.,1'',. T.frz fi p'44: 2 19. -:.:2,,,:... i 6.1
Ad-free, spam free
r ilim.w.trrioz4 _r:
Free access and email alerts for citizens ,,,r, F7mmwmp iv.!!i
I
0 Quick, easy installation FOR MORE NFORIVIATION
No new software, no new infrastructure, no maintenance 888.888.CRIME
costs, no expensive updates www.CrimeReports.com
6
Sort Search CrinneTypes Sex Offenders
Sort by crime, date, Search for a city, town, zip Choose which crimes Display official sex
or distance from a code, ur specific address you want to see on offender data
chosen location the map 7
Z s
List View Date Range Details Areas
A list of all crimes Specify a date range or Click an incident marker to Highlight specific
shown on the map click Calendar to set a see details for that crime neighborhoods
custom date range
EtaatiegradVa/^^~',~~
~�,„Z;'~
ma Ica
These simple analytics give nneaningtothe
~�e Thee:
raw data presented in the nnap. Each chart is
�~~=~~=�c���~��~~ �E����
printable and customizable bycrinnetypeand
date range.
These visua|iza�onsare anef�/tive tool for
Neighborhood Watch and City Council
meetings set guak�and
O�IL resources,
measure progress.
����B�=Q����
PRICING
Up03�O�([
Over
-c $199/month
For UOiVer3itie3 $49/month
1•451 Stigti 0 4 C T iE OIVI G flGRO N) ._.414. :,;,_....,1,,::,,.::_.,:,
SK.,'s" X v g �t�i
�a�r Nr r.. rz- :a'!.nrr „sex `5�^: �'�)w� §w�- .!�.m r .,,,d�: ;,r. k.�i�^r....�ii. �uS,rtF�v -Y,. f°-
RI N V
CRIME I `llf® is the leading desktop software solution for crime mapping in North America.
Hundreds of agencies have been able to reduce crime activity through the use of CrimeView which
utilizes ESRI's powerful ArcGIS platform.
CrimeView is an advanced interface to your existing CAD and RMS databases. The application
specifically addresses the integration of your data in order to effectively query and analyze
information in a mapping environment. CrimeView helps streamline data integration so analysts can
spend more time performing investigative tasks.
j tt, R peat Call M p ofAlllt rda Hot Spot "CrimeView has been the foundation of our crime analysis efforts and
7).;x1 fi
continues to he our primary tool as we complete our second successful
years, primary
�-�4,, sn CrimeView Desktop upgrade. For years CrimeView has been the p rlmar
z r ,nom "data driver” for field supervisors at the beginning of each shift, as well as
r't. t�4 the source of crime and call information for lieutenants.
Jim Bueerman, Chief of Police, Redlands, California
C RIME V E includes a number of query, reporting, analysis, and mapping features to help
expand your capabilities and simplify your current crime analysis procedures.
Queries search by any attribute, geographic boundary, or proximity to a landmark.
Density Maps create standardized density, hot spot, and repeat call maps.
Cyclical Reports combine and save queries, reports, and graphs to run anytime.
Exception Reporting produce COMPSTAT style comparison reports.
Threshold Alert —alert staff by email when activity thresholds have been reached.
Analyses utilize our crime rate generator, spatial trending tools and census data layers.
Order Labels plot specific incidents in the order they occur with directional symbols.
Statistical Profiler project where the next event is most likely to occur.
Temporal Heat Index Reporting depict the number of crimes graphically for any time period.
To learn more about how CrimeView can help your agency improve communications and reduce
crime in your community contact our sales staff toll free at (800)228 -1059 or e -mail us at
salesPtheomegagroup.com for a remote demonstration.
g4ry l
www ,th,eomegagroup. co
S g y- a �vhrcr�w a5 e.�n to 7 un,^ °9.. r .z .0 1 ...Nacx r.,,, nta.. .r.', a r su,.
s, `t r c 1 x ti 0 a a �r y c I
F t t 4 Ir r sa i 14 }I r!: lE 4 1 W F 4 r S 1
x I Y 7 k j. 0 lif t _.,f' r 4 S F IA f. r i!;:111 -f 1
a
TL-, e x z ,x 1 r n a �i y s
R
9
r.. �.z.•' Y.c, .,r f.a..n u ;:.r_.�... x. s .a r =M„ _.r a.. ,Lr kr. r.
EM POWE R YOUR PUBLIC ,_,,.,_:_.,r........._...„., ititV .GRO I u T IDE OIIEGR r
I ik�.,�+.��'+A�p..�.E�..- ;��..,t �":.�.;w• "k sW-ir� .,,Wm ;ttr�44
C RIM E: M, A. 71 1 N. G.. co m HA
CRIM AP I G, om TM helps law enforcement agencies throughout North America
provide the public with valuable information about recent crime activity within their neighborhood
through a Web browser. A well informed citizenry has been proven effective in reducing crime.
CrimeMapping.com strengthens community oriented policing efforts and increases an agency's
transparency by promoting trust. The Omega Group has been assisting law enforcement since 1992
and our goal is to improve safety through the use of technology.
Y 4 y� °C.rimema_pping.com has proven itself as a valuable tool to our new
rte e o Neighborhood Watch program. Your "Crime Alerts" a -mails have
°y 92- allowed me to get detailed, timely crime data information out to all
9 4�
of our members. Our efforts are now focused and far more effective
E 4 i r 4 than they would have been without your program. Thanks!"
0 Y a 4 -'k t 1 Resident, Lincoln, Nebraska
Z
CrimeMapping.com TM Benefits:
Analyze crime activity within a radius of any location such as place of residence, business
address or child's school of attendance.
Display the distance from any crime to any address of interest.
Generate simple interactive reports that allow for instant sorting as well as hyperlinks back to
our intuitive mapping area.
View current records as,our automated import process ensures that the crime data being shown
is always up to date.
Jump quickly to any other agency listed through our Agencies tab.
Filter by crime type as well as date reported in order to focus on specific patterns.
Connect to other local public safety resources through the use of our Agency Links.
Plot only incidents for the agency you want to view using our Agency Filters.
Receive free Crime Alerts via e mail.
Pan between areas and compare crime activity by community.
Help reduce crime by keeping citizens well informed. *`a
Reach out to your community and share valuable information!
zs. a g f; 7 .r ras ssaa we�+.,-"m t a';. s r 571 f s. t s5.k a.ua is wr. s� ear,
t F t k j5 M i F t '�,t T H' +f ur 1 m. 1 l L
fix :,t S k .t r s' RF f
e 4 i k a s -i w E h G i l\ ra n 9 r r i t i'''i i 1r 1 I S¢
z N �_�y.� "tea
v
a 4. .s U
,n
A
4!;,,v-- II City of Tukwila
a ,F y
90 INFORMATIONAL MEMORANDUM
Jim Haggerton, Mayor
TO: Mayor Haggerton
Finance and Safety Committee
FROM: Peggy McCarthy, Deputy Finance Director
DATE: February 16, 2011
SUBJECT: Fourth Quarter 2010 Cash Investment Report
ISSUE
Finance Policy and Procedure 03 -17, Investment Policy, calls for quarterly investment reports to the
Council Finance and Safety Committee. The report is to contain an inventory of investments and a
summary of performance. The December 31, 2010 Investment Report is included with this memorandum
and is discussed below.
BACKGROUND
Investment decisions are guided by the three investing objectives 1) the preserving principal 2) earning
a reasonable return and 3) ensuring sufficient liquidity to meet the City's operating needs. To achieve
these objectives, investments are diversified by type, by financial institution, and by maturities. To ensure
sufficient liquidity exists to meet the City's operating needs, cash requirements needed for special
circumstances, such as capital projects, is considered as well as the normal variations in the monthly cash
flow cycles. The City has established a minimum operating liquidity threshold that is equal to the largest
monthly decline in combined cash and investment balances over the most recent thirty -six month period,
or $7 million, then doubled this amount to $14 million to provide a cushion or safety net for unforeseen
circumstances. In addition, funding requirements for known special needs such as capital projects are
added to this threshold.
The Cash Investment Report and supplementary schedules and commentary provide information on a)
portfolio components description and characteristics of securities and deposits held, b) portfolio
performance weighted average yield of the portfolio in comparison to benchmarks, c) compliance with
investment policy in terms of investment maturities and diversification of financial institutions and
investment types, d) cash and investment balances, and changes therein, by fund and fund group and e)
the current investment environment and strategies.
DISCUSSION
Portfolio Activity. Components Characteristics. During the fourth quarter of 2010, two agency bonds
were called, six municipal bonds were purchased and two new money market accounts were opened. The
bonds called were Federal Home Loan Bank bonds in the amounts of $1 million and $2 million with
yields of 2.08% and 1% respectively. Longer term municipal bonds with a book value of $3.6 million at
December 31, 2010, were purchased to add stability to investment earnings and to increase yield. The
weighted average maturity at the time of investment for these bonds was 7.6 years and the weighted
average yield is 4.21 With this yield, the bonds will generate over $142,000 in additional annual
interest income as compared with a similar investment in the Washington State Local Investment Pool
(LGIP) at current rates. The two new money market funds were opened to take advantage of more
favorable rates while maintaining liquidity. The City receives 10 basis points (.1 above the investment
pool rate from the Columbia Bank money market fund. This fund is insured through the Public
11
INFORMATIONAL MEMO
Page 2
Depository Protection Commission (PDPC). The other money market fund currently yields 1 This
investment is limited to a $250,000 however since it is insured by the FDIC and not by the PDPC.
At December 31, 2010, the portfolio was in compliance with all parameters and limitations set forth in the
investment policy including investment mix, investment maturities and diversification of financial
institutions. Funds representing the liquidity threshold were invested in the state investment pool and the
money market accounts and totaled $28.9 million. Certificate of deposits constituted $14.4 million of the
portfolio with $10 million of this amount maturing in 2011. Funds available within one year or less
represented 84% of the portfolio; 92% of the portfolio was available within five -years or less. The
financial institution with the largest holding of City investments remains the Washington State
Treasurer's Office with $23 million invested in the local government investment pool.
Portfolio Performance. Interest income for 2010 totaled $322,000. This amount is low compared with
the portfolio's performance in past years due to the historically low interest rates existing nation -wide
during the last two years and the relatively short term nature of the portfolio that existed when rates began
to drop. As rates declined, the City was unable to sustain a more favorable level of earnings because the
investments with the higher yields all matured. However, during the fourth quarter 2010, the portfolio
earning profile improved. The weighted average portfolio yield increased from .76% at the end of the
third quarter to .96% at the end of the fourth quarter. Annual earning calculated based on the portfolio
components at December 31, 2010 totaled $448,933.
One element of investment earnings that is reported in the City's Comprehensive Annual Financial Report
and is calculated and considered only at fiscal year -end is the change in market value of the portfolio
investments. At December 31, 2010, the market value calculation on the municipal bond investments
indicated a market value decline, as compared with book value, of $127,822. This decline is due to an
increase in interest rates from the bond purchase dates to the end of the year. It is an unrealized, "paper"
loss which has no affect on the collectability and ultimate return of principal. As long as the investments
are held to maturity, which has been, and continues to be, the City's intent and practice, no actual loss
will be realized. As interest rates increase, this unrealized loss may also increase.
Fund and Fund Group Cash Investment Balances. The largest fund balances at December 31, 2010
occurred in the 104 Arterial Street fund with $9.8 million, the 401 Water Fund with $5.7 million and the
502 Self Insurance fund with $5.7 million. City -wide cash and investment balances declined from their
September 30, 2010 levels by $1.8 million due primarily to the $1.9 million debt service payments made
in December.
Investment Environment and Strate:?ies. Interest rates rose in the fourth quarter 2010 and have continued
to rise especially in the two -year to ten -year maturity range. The City will have over $5 million of
certificates of deposit maturing in both the first and second quarter of the year. Investment opportunities
and options will be considered in the two to five year maturity ranges.
RECOMMENDATION
Presentation is for Council information only.
ATTACHMENTS
Cash and Investment Report as of December 31, 2010
O Policy Compliance Liquidity Analysis as of December 31, 2010
9 Cash and Investment Balances by Fund and Fund Group at December 31, 2010
e Yield curve and Treasury Rates at 12 -30 -10
H:1InvstlInfoMemo Invstmnt Rprt 12 -31 -10 2- 16- 11a.docx
12
CITY OF TUKWILA
CASH INVESTMENT REPORT
December 31, 2010
(a)
Purchase Maturity Term Par Book Balance Yield to Annualized
Agency Issuer Rating Investment Type Date Date Mos Yrs Value Purchase Price Maturity Return
CASH CASH EQUIVALENTS
US Bank Depository Various (b) 0.03 634,183 634,183 0.00%
Washington State Treasurer LGIP Investment Pool Various (b) 0.03 23,015,948 23,015,948 0.26% 60,861
Regal Bank Money market Various (b) 0.03 250,052 250,052 1.10% 2,751
Columbia Bank Money market Various (b) 0.03 5,000,186 5,000,186 0.36% 18,222
Total Cash Cash Equivalents 1 0.03 1 28,900,369 28,900,369 0.28% 81,834
INVESTMENTS
Certificates of Deposit
First Savings Bank Certificate of Deposit 05/01/2009 05/01/2011 24 2.0 2,000,000 2,077,720 2.31% 46,200
Northwest
Sound Community Bank Certificate of Deposit 05/20/2009 04/20/2011 23 1.9 1,500,000 1,553,714. 2.22% 33,330
Charter Bank Certificate of Deposit 05/26/2009 05/26/2011 24 2.0 1,500,000 1,548,311 1.98% 29,700
US Bank Certificate of Deposit 02/15/2010 02/15/2013 36 3.0 3,450,000 3,450,000 1.44% 49,680
Sterling Bank Certificate of Deposit 02/16/2010 08/16/2011 18 1.5 250,000 252,622 1,20% 3,000
Sound Community Bank Certificate of Deposit 03/04/2010 03/04/2011 12 1.0 5,000,000 5,037,418 0.99% 49,500
Sound Community Bank Certificate of Deposit 11/15/2010 05/15/2012 18 1.5 503,414 504,046 0.75% 3,776
CERTIFICATES OF DEPOSIT TOTAL i 22 I 1.9 14,203,414 14,423,831 1.52% 215,186
Taxable Municipal Bonds (d)
City of Marysville, sinking Al LTGO Refunding 11/23/2010 12/01/2017 66 5.5 535,000 602,531 3.37% 20,305
2014 -2017, ave 5.5 years
Washington State Aa3 Lodging Tax Bonds 11/30/2010 07/01/2016 67 5.6 500,000 507,969 3.60% 18,287
Convention Center Facility A+
UW Biomedical Center AA1 Revenue Bonds 12/14/2010 07/01/2017 79 6.6 500,000 506,932 4.05% 20,531
AA+
UW Biomedical Center AA1 Revenue Bonds 12/14/2010 07/01/2019 103 8.6 500,000 506,248 4.70% 23,794
AA+
Douglas County, ESD, Aal UTGO 12/23/2010 12/01/2020 107 8.9 1,135,000 1,157,359 4.55% 52,660
sinking 2018 -2020, ave 9 yrs Aa3
Port of Anacortes Al LTGO 12/17/2010 09/01/2020 117 9.7 340,000 326,742 5.00% 16,337
TOTAL MUNICIPAL BONDS 91 i 7.6 3,510,000 3,607,781 4.21% 151,914
Total Investments 36 J 17,713,414 18,031,612 367,099
TOTAL CASH, CASH EQUIVALENTS INVESTMENTS 14 I 46,613,783 46,931,982 1 0.96% 1 $448,933
T
Weighted Average Maturity- Months Portfolio Yield
Policy Maximum 42
Policy met? Yes
Benchmarks 12/31/10
90 -day treasury rate 0.11%
6 -month treasury rate 0.19%
(a) On calleable bonds, term is calculated to final maturity even though call date may occur first; term of liquid State Pool rate 0.26%
investments is one day; on sinking fund bonds, average maturity is used to calculate term.
(b) No fixed maturity, funds are available within one day.
(c) Annualized return based on purchase price and yield to maturity.
(d) Estimated market value at 12 -31 -10 was $127,822 Iess than book value at 12 -31 -10 due to increased
interest rates from date of purchase.
13
CITY OF TUKWILA
CASH INVESTMENT REPORT Policy Compliance Liquidity Analysis
December 31, 2010
Portfolio Available Within Available
Liauiditv Analysis Maturity Diversification Amount 1 Year Within 5 Years
Funds immediately available: 28,900,369 28,900,369 28,900,369
Less restrictions designations:
Southcenter Parkway Project 4,331,034
Klickitat Project 10,000,000
Operating liquidity (h) 14,000,000
Liquidity threshold 28,331,034
Available for investing 569,335
Investments Maturing in 2011:
First quarter 5,037,418
Second quarter 5,179,745
Third quarter 252,622
Fourth quarter
Maturity of 1 year or less 10,469,785 10,469,785 10,469,785
Maturity of 1 -3 years 3,954,046 3,954,046
Maturity of 3 -5 years
Maturity of 5 -7 years 1,617,432
Maturity of 7 -10 years 1,990,349
Maturities of 1 -10 years 7,561,827
Totals 46,931,982 39,370,155 43,324,201
PORTFOLIO ACTUAL 84% 92%
POLICY MINIMUM 30% 80%
Policy Met? Yes Yes
(h) Represents largest one month decline in portfolio balance over the most recent 36 month period
doubled; or the equivalent of a 100% cushion.
Portfolio POLICY Policy
Financial Institution Diversification Amount of Total MAXIMUM Met?
US Bank 4,084,183 8.7% 50.0% Yes
Washington State Treasurer 23,015,948 49.0% 75.0% Yes
Columbia Bank 5,000,186 10.7% 50.0% Yes
Sound Community Bank 7,095,179 15.1% 50.0% Yes
Eastmont School District 1,157,359 2.5% 50.0% Yes
Other financial institutions 6,579,127 14.0% 50.0% Yes
Total 46,931,982 100.0%
Portfolio POLICY Policy
Investment Mix Amount of Total MAXIMUM Met?
Depository 634,183 1.4%
State Investment Pool 23,015,948 49.0% 75.0% Yes
Money market 5,250,239 11.2%
Certificate of Deposit 14,423,831 30.7%
US Agency 0.0% 75.0% Yes
Municipal Bonds 3,607,781 7.7%
Total 46,931,982 100.0%
14
CITY OF TUKWILA
CASH INVESTMENT REPORT
December 31, 2010
Cash Investment Balances By Fund and Fund Group
n rou o' uno 'am i; Cas f a nve- t[tiehts rand otal
General 000 GENERAL 1,651,762 1,121,115 2,772,876
General Total 1,651,762 1,121,115 2:772,878
Special Revenue 101 HOTEUMOTEL TAX 542,333 103,581 645,914
103 STREET 410,842 196,804 607,646
104 ARTERIAL STREET 4,397,155 5,457,124 9,854,278
105 CONTINGENCY 806,893 82,577 889,470
107 FIRE EQUIP. CUM. RESERVE 803,981 803,981
109 DRUG SEIZURE FUND 305,702 10,322 316,024
y Y '7 266905 `5;850,407
Special Revenue Total t_ 13117 31 j
Debt Service 207 LIMITED TAX G.O. BONDS 1999 3 3
208 LIMITED TAX G.O. BONDS 2000 70 70
209 LIMITED TAX G.O. BONDS 2003 153 153
210 LIMITED TAX G.O. REFUNDING 2003 1,457 1,457
211 LIMITED TAX G.O. REFUNDING 2008 13,345 13,345
214 LTGO 2010 Series A 37 37
215 LTGO 2010 Series B 17 17
216 VALLEY COM Refunding bonds 2010 814 814
Debt Service Total s Y 15,895 89
Capital Project 301 LAND ACQ. REC. PARK DEVLPMNT 2,728,193 2,043,433 4,771,625
302 FACILITY REPLACEMENT 2,058,699 2,058,699
303 GENERAL GOVERNMNT IMPROVEMENTS 1,470,395 1,470,395
304 FIRE IMPACT FEES 156,018 156,018
i iii ,o ..tP -:.7 rE *w c 4 oy
6 413 305 2,043 433
Capital Project Total e r r 8;456 737
Enterprise 400 UTILITY ON ACCT (overpayments) 13,700 13,700
401 WATER 1,812,849 3,967,975 5,780,823
402 SEWER 1,562,085 207,190 1,769,275
411 FOSTER GOLF COURSE 21,640 21,640
412 SURFACE WATER 1,165,045 1,111,079 2,276,123
Enterprise Total :4 575319 5,286 24 9,861;561 k
Internal Service 501 EQUIPMENT RENTAL 3,852,557 3,852,557
502 INSURANCE 2,237,187 3,523,225 5,760,412
503 INSURANCE LEOFF I 1,449,860 207,190 1,657,049
Internal Service Total y 7 539,603 3,730;415 11;270;016,
Fiduciary 611 FIREMEN'S PENSION 1,429,822 1,429,822
640 AGENCY FUND 7,744 7,744
Fiduciary Total 1 1,437,566
Grand Total 28,900,354 18,031,612 46,931,966
15
CITY OF TUKWILA
CASH INVESTMENT REPORT
December 31, 2010
C losing Daily Cur r e nt Pnce E
Yield Price Yiel
Term Change
-i :12/30/2010 T 7 Am.
3mo 0. 0.12%
6rrio �0 1 s:. a .0.19%
1 Yr 0.27% 0.27%
a 2Yr 0. 64 %o e Q 5 ,-0 83% ...z w
3Yr 1.05% -2 1.01 3.5
5Yr 2 06%d "c. •o frf 3 5 i. 2 01 °!o ,7 a 8 w
10Yr 3.36% -4 3.31 14
30Yr 1 4 4 2 '°4 4 37% 27 tg
c
4.5
4
3.5
2.5
2
1.5-
11/30/2010
1 Today
0.5
f
AZ-
nP
16
City ®f Tukwila V
o Jim Haggerton, Mayor
90 INFORMATIONAL MEMORANDUM
TO: Mayor Haggerton
Finance and Safety Committee
FROM: Shawn Hunstock, Finance Director
DATE: February 23, 2011
SUBJECT: Sales Tax Revenue for December 2010
Schedule I in 1,000's
Sales Receipt 2009 2010 2010 Increase /(Decrease) %Increase /(Decrease)
Month Month Actual Estimated Actual Month YTD Month YTD
Jan Mar 1,172 1,483 1,036 (447) (447) 30.14% 0.00%
Feb Apr 1,051 1,462 1,006 (456) (903) 31.19% 30.66%
Mar May 1,146 1,705 1,157 (548) (1,451) 32.14% 31.20%
Apr June 1,191 1,578 1,070 (508) (1,959) 32.19% 31.45%
May July 1,082 1,603 1,067 (536) (2,495) 33.44% 31.86%
June Aug 1,217 1,812 1,247 (565) (3,060) 31.18% 31.73%
July Sept 1,473 1,793 1,251 (542) (3,602) 30.23% 31.50%
Aug Oct 1,118 1,656 1,216 (440) (4,042) 26.57% 30.87%
Sept Nov 1,110 1,682 1,357 (325) (4,367) 19.32% 29.56%
Oct Dec 1,032 1,556 1,082 (474) (4,841) 30.46% 29.64%
Nov Jan11 1,140 1,631 1,202 (429) (5,270) 26.30% 29.34%
Dec Feb11 1,690 2,270 1,891 (379) (5,649) 16.70% 27.92%
Totals 14,422 20,231 14,582
Mitigation Received 1,242
15,824 78.22% of Budget Incl. Mitigation
Sales tax collections for December showed an increase versus the same month in the previous
year. December represented the fifth consecutive increase, and seventh so far this year. For
December, collections were less than budget for the month, but more than actual collections in
the same month in the previous year. Actual receipts for December were $379,000 Tess than
budget, but $201,000 more than the same period last year. We are down 16.70% for the month
compared to budget, but up by 11.89% compared to the same month last year. We are now
down in total 27.92% for the year compared to budget, but up by 1.09% compared to the same
period last year.
Including mitigation payments, we are currently at 78.22% of budget for the year to date. This
includes a mitigation payment of $308,257.11 received on December 31, 2010. The last
mitigation payment we received was on September 30, 2010 for $310,763.48. Mitigation
payments are now annualized and will only be adjusted once per year in the fall, effective with
17
INFORMATIONAL MEMO
Page 2
the December 31s payment. Staff completed work on the last mitigation detail file and submitted
to the Department of Revenue a list of firms that should be removed from the mitigation
calculation process. These firms are ones that were offsetting other losses, thereby reducing
our mitigation payment.
Schedule II shows the year -to -date sales tax from the top ten industry classifications. As this
schedule indicates, the trend is flat or down for most of the classifications.
Schedule II
YTD YTD Dollar
Group Name Current Prior Diff. Diff.
452* General Merchandise Stores 2,068,263 2,044,042 24,222 1.18%
448* Clothing and Accessories 2,021,704 2,015,184 6,519 0.32%
722* Food Services, Drinking Places 1,341,150 1,291,855 49,295 3.82%
423* Wholesale Trade, Durable Goods 1,236,905 1,339,565 (102,660) 7.66%
443* Electronics and Appliances 1,003,415 954,375 49,040 5.14%
451* Sporting Goods, Hobby, Books 648,678 589,522 59,155 10.03%
441* Motor Vehicle and Parts Dealer 596,727 686,478 (89,751) 13.07%
236 Construction of Buildings 588,919 416,992 171,927 41.23%
444* Building Material and Garden 499,394 506,177 (6,783) 1.34%
453* Miscellaneous Store Retailers 481,324 506,005 (24,681) 4.88%
Mitigated NAICS Code
As you can see there are large variances from last year for the same time period. For instance,
sales tax for Motor Vehicle and Parts Dealer is down by 13.07 and Wholesale Trade and
Durable Goods is down by 7.66 As illustrated above, four of the top ten merchant categories
have declined versus prior year, and all but one of the ten industry classification codes are ones
for which we receive streamlined sales tax mitigation.
Schedule III shows the ten largest declines in sales tax revenue for industries with over $10,000
collected year -to -date.
Schedule III
YTD YTD Dollar
Group Name Current Prior Diff. Diff.
237 Heavy and Civil Construction 37,857 98,105 (60,248) 61.41%
454* Nonstore Retailers 111,045 209,564 (98,518) 47.01%
531 Real Estate 45,108 70,561 (25,454) 36.07%
621 Ambulatory Health Care Service 50,470 71,247 (20,777) 29.16%
926 Economic Programs Admin 25,292 31,551 (6,259) 19.84%
541 Professional, Scientific, Tech 183,693 227,255 (43,562) 19.17%
238 Specialty Trade Contractors 290,486 347,910 (57,424) 16.51%
441* Motor Vehicle and Parts Dealer 596,727 686,478 (89,751) 13.07%
812 Personal and Laundry Services 83,567 93,346 (9,779) 10.48%
323 Printing and Related Support 54,341 59,298 (4,957) 8.36%
Mitigated NAICS Code
Attached is a Sales Tax Summary comparing year -to -date 2010 vs. 2009 by major NAICS
codes. Also included is a comparison of total receipts year -to -date for the last five years.
Please let me know if you have any comments or questions. Thank you.
W'1FIN Projects\Sales Tax Information\Sales Tax Files from Shawn120101Info Memo Sales Tax 02232011.docx
18
SALES TAX SUMMARY
December 2010 (Received in February 2011)
r x..,,.._.....,,.
Y
YTD YTD
NAICS CONSTRUCTION D9 TOTAL 09 YTD 10 YTD Diff NAICS AUTOMOTIVE 09 TOTAL 09 YTD 10 YTD Diff
1 t 727 .13
596,727
236 Construction of Buildings 416,992 416,992 588,919 41.2% I 441` Motor Vehicle &Pats Dealer 686,478 686,478 I
237 Heavy Civil Construction 98,105 98,105 37,857 -61.4% I 447' Gasoline Stations 62,584 62,584 67,583 8.0%
238 Specialty Trade Contractors 347,910 347,910 290,486 16.5% TOTAL AUTOMOTIVE 749,063 749,063 664,310
TOTAL CONSTRUCTION 863,006 863,006 917,262 Overall Automotive Change from Previous Year )$84,752) -11.3%
Overall Construction Change from Previous Year 654,255 6.3%
NAICS RETAIL TRADE 09 TOTAL 09 YTD 10 YTD Diff
YTD 442* Furniture Home Furnishings 350,625 350,625 374,775 6.9%
MANUFACTURING 09 TOTAL 09 YTD 10 YTD %Diff 443' Electronics Appliances 954,375 954,375 1,003,415 5.1%
311 Food Manufacturing 1,173 1,173 5,995 411.0% 444" Building Material Garden 506,177 506,177 499,394 -1.3
312 Beverage Tobacco Products 3,070 3,070 4895 129.2% 445* Food Beverage Stores 86,349 86,349 101,958 18.1%.
313 Textile Mills 259 259 88 -65.9% 446* Health Personal Care 189,603 189,603 178,919 -5.6%
314 Textile Product Mills 12,852 12,852 13,503 5.1% 448* Clothing Accessories 2,015,184 2,015,184 2,021,704 0.3%
315 Apparel Manufacturing 59 59 38 -35.1% 451' Sporting Goods, Hobby, Books 589,522 589,522 648,678 10.0%
316 Leather Allied Products 7 7 2 -68.5% 452' General Merchandise Stores 2,044,042 2,044,042 2,068,263 1.2
I 321' Wood Product Manufacturing 2,701 2,701 1,627 -39.8% 1 453' Miscellaneous Store Retailers 506,005 506,005 481,324 -4.9%.
I 322' Paper Manufacturing 20,392 20,392 21,585 5.8% 1 454* Nonstore Retailers 209,564 209,564 111,045 .47.0%
I 323* Printing Related Support 59,298 59,298 54,341 -8.4% 1 TOTAL RETAIL TRADE 9 7,451,446 7,451,446 7,489,475
324 Petroleum Coal Products 8,157 8,157 3,062 -62.5% Overall General Retail Change from Previous Year 638,029 0.5%
325 Chemical Manufacturing 6,368 6,368 7,458 17.1%
326 Plastic& Rubber Products 3,928 3,928 3,142 •20.0% YTD
1 327* Nonmetallic Mineral Products 2,279 2,279 3.667 60.9% 1 SERVICES 09 TOTAL 09 YTD 10 YTD Diff
331 Primary Metal Manufacturing 534 534 725 35.8% 51X Information 528,044 528,044 553,763 4.9%
332 Fabricated Metal Mfg Products 3,789 3,789 -2,641 -169.7% 52X Finance Insurance 53,850 53,850 54,281 0.8%
333 Machinery Manufacturing 5,586 5,586 10,120 81.2! 53X Real Estate, Rental, Leasing 412,907 412,907 420,554 1.9%
1 334' Computer Electronic Products 19,797 19,797 5,592 -71.8% 1 541 Professional, Scientific, Tech 227,255 227,255 183,693 -19.2%
335 Electric Equipment, Appliances 137 137 523 281.5% 551 Company Management 985 985 250 -74.6%
336 Transportation Equipment Mfg 135,430 135,430 290,984 114.9% 56X Admin, Supp, Remed Svcs 123,115 123,115 111,875 -9.1%
1 337' Furniture Related Products 8,575 8,575 10,326 20.4% 1 611 Educational Services 47,324 47,324 61,029 29.0%
I 339' Miscellaneous Manufacturing 10,665 10,665 11,140 4.4% I 62X Health Care Social Assistance 91,637 91,637 74,501 18.7%
TOTAL MANUFACTURING 305,059 305,059 440,381 71X Arts Entertainment 93,799 93,799 110,146 17.4%
Overall Manufacturing Change from Previous Year 9135,322 44.4% 1 72X` Accommodation Food Svcs 1,745,512 1,745,512 1,769,600 1.4% 1
81X Other Services 183,887 183,887 185,696 1,0%
YTD 92X Public Administration 32,268 32,268 26.395 -18.2%
TRANSPORTATION WAREHOUSING 09 TOTAL 09 YTD 10 YTD Diff TOTAL SERVICES 1,540,583 3,540,583 3,551,783
481 Air Transportation 0 0 4 0.0% Overall Services Change from Previous Year 611,200 0.3%
482 Rail Transportation 924 924 731 •20,8%
484 Truck Transportation 3,294 3,294 344 -89.6%
485 Transit and Ground Passengers 11,105 11,105 17,813 60.4% YTD
487 Scenic and Sightseeing Tran 0 0 224 #DIV /01 MISCELLANEOUS 09 TOTAL 09 YTD 10 YTD Diff
488 Transportation Support 21,879 21,879 29,089 33.0% 000 Unknown 397 397 43 -89.1%
491 Postal Services 0 0 0 #DIV /0! 111 -115 Agriculture, Forestry, Fishing 221 221 313 41.3%
492 Couriers Messengers 149 149 372 149.6% 211 -221 Mining Utilities 14,549 14,549 14,355 -1.3%
I 493* Warehousing Storage 1,051 1,051 957 -8.9% 1 999 Unclassifiable Establishments 12,331 12,331 100,745 717.0%
TOTAL TRANSP WHSING 38,401 38,401 49,534 MISCELLANEOUS TOTAL 27,499 27,499 115,457
Overall Transportation Change from Previous Year 910,133 29.0% Overall Miscellaneous Change from Previous Year 987,958 319.9%
YID
WHOLESALE TRADE 09 TOTAL 09 YTD 10 YTD Diff YTD
1 423" Whls Trade Durable Goods 1,339,565 1,339,565 1,236,905 -7.7% 1 09 TOTAL 09 YTD 10 YTD Diff
424" Whls Trade Nondurable Goods 105,260 105,260 112,063 6.5% 1 GRAND TOTALS $14,422,090 914,422,090 914,579,951
I 425' Wholesale Electronic Markets 2,208 2,208 2,781 25.9% 1 Grand Total Change from Previous Year $157,861 1.09%
WHOLESALE TRADE TOTAL 1,447,033 1,447,033 1,351,748
Overall Wholesale Change from Previous Year (995,285) -6.6%
I Sales Tax Mitigation NAICS Codes I
(D 02/23/2011 Page 1 IUK Soles lox Rpl 201011.05m
Five Year Comparison
0 i.A. S r :psV F s 3 .a4 r' mii k HJ i z k
2010 1 1!-,' $144,579978
a
a_ 1 .p K r' r ti "9 t- '�'�'�yi� s ,a w j std ,4 a .i #w...., w I.;5 5., r� ;v O', u 5 "r ,tx S' 7....swk I f
2009 I $114
a U"Ft ,w, i „,z,,,,-. i A .`e F o s E u '`c k IIh' x k
C
0 47 752'694§�
r k
1 f`' Y �.,..t,' —n t. -Y r -1 S bt "s, k *i S Yq
2007 1 $19,415,705
I
x L t 4 1- '4€ T "c 5 x 5,4 r r7,�
c'a
2006 I $1 (,54 1
$5,000,000 $10,000,000 $15,000,000 $20,000,000
Taxes Collected Year to Date
20