Loading...
HomeMy WebLinkAboutFS 2015-03-17 COMPLETE AGENDA PACKETCity of Tukwila Finance and Safety Committee O Kathy Hougardy, Chair O Joe Duffie O De'Sean Quinn AGENDA Distribution: Recommended Action K. Hougardy P. McCarthy J. Duffie C. C'Flaherty D. Quinn R. Turpin K. Kruller L. Humphrey D. Robertson C. Flores Mayor Haggerton M. Villa D. Cline Chris Flores, Interim Fire Chief TUESDAY, MARCH 17, 2015 — 5:30 PM HAZELNUT CONFERENCE ROOM (formerly known as CR #3) at east entrance of City Hall Item Recommended Action Page 1. PRESENTATION(S) 2. BUSINESS AGENDA a. Purchase of 12 thermal imaging cameras for the a. Forward to 3/23 Consent Pg.i Fire Department. Agenda. Chris Flores, Interim Fire Chief b. 2014 4th Quarter Investment Report. b. Information only. Pg. 15 Peggy McCarthy, Finance Director c. 2014 4th Quarter Police Department Report. c. Information only. Pg.27 Mike Vi/ /a, Po /ice Chief 3. ANNOUNCEMENTS 4. MISCELLANEOUS Next Scheduled Meeting: Tuesday, Apr#7, 2015 SThe City of Tukwila strives to accommodate individuals with disabilities. Please contact the City Clerk's Office at 206 - 433 -1800 ( TukwilaCityClerk (a)TukwilaWA.gov) for assistance. City of Tukwila Jim Haggertan, Mayor TO: Mayor Haggerton Finance and Safety Committee FROM: Chris Flores, Interim Fire Chief DATE: March 4, 2015 SUBJECT: FD Purchase of Thermal Imaging Cameras I] kyl ISSUE The department administration is asking Tukwila City Council to approve the purchase of replacement thermal imaging cameras (TIC's). BACKGROUND All department thermal imaging cameras are scheduled to be replaced in 2015. The expenditure was included in the 2015-2016 departmental biennial budget request, and approved by Tukwila City Council. Funding can be found in Account Number 000 11 522 200 35 00, on page 195 of the City 2015-2016 Biennial Budget. These units replace existing inventory, whose service lives span technological changes over three plus decades. A team was assigned to research and make recommendation regarding the unit to be purchased. The chosen unit not only tied for the highest assessment score, but is available at the most competitive pricing. DISCUSSION The City/Department can take advantage of discounted pricing and equipment bonuses by ordering and purchasing this equipment prior to the expiration of the attached existing current quote. FINANCIAL IMPACT The financial impact is $55,642.43. The amount budgeted for this expenditure is $72,000.00. The funding source is City/Department General Fund. RECOMMENDATION The Council is being asked to approve the proposal and consider this item at the March 23, 2015 Special Meeting Consent Agenda. ATTACHMENTS Current Quote Research Document Unifire, Inc. 3924 E. Trent Ave. Spokane, WA 99202 Quote To Joel Perry Tukwila Fire Dist. #54 4237 S. 144 St. Tukwila, WA 98168 206 -849 -1298 Toll -Free: 1 -800- 745 -3282 Phone: 971 -269 -4226 Fax: 509 - 535 -9064 www.unifireusa.com Quote Date Quote # 2/23/2015 10065BJS Quote By: Jerry Springer Item Description Qty MSP Your Cost Ea. Ext. Cost 63501 -0201 K -50 320X240 Thermal Camera Kit' 10 $4,995.00 $ 4,275.00 $ 42,750.00 T198322 Truck Charger 12 $795.00 $ 645.00 $ 7,740.00 63501 -0201 K -50 320X240 Thermal Camera Kit" 2 $4,995.00 N/C $ - 1st Quarter Promotion: Buy Five (5) K- 50 Thermal Imagining Camera's and get one (1) K -50 camera free. Good hr March Z015 $ `Kit Includes: Hard Case, Thermal Imaging Camera (TIC), (2) Li -Ion Batteries, Tabletop Charger w /Power Supply, USB Cable, Retractable Lanyard, Neck Strap, Tripod Adapter (LING 1/4 " -20), FUR Tools Software (scratchcard), Documents Comments Subtotal $ 50,490.00 `ALL PRICES F.O.B. SPOKANE, WA 99202, CUSTOMER RESPONSIBLE FOR ALL SHIPPING AND HANDLING CHARGES. **ALL PRICES IN UNITED STATES DOLLARS. '* *PRICES QUOTED, GOOD FOR 45 DAYS FROM 2/23/2015. Shipping $ 325.00 Sales Tax % 9% $ 4,827.43 Total $55,642.43 1- 800 - 745 -3282 www.unifireusa.com Page 1 of 1 OM (( cj ?;� 9-00 350U Fax: 509 - 535 -9064 3 THERMAL IMAGING CAMERAS Recommendation for the Tukwila Fire Department Prepared by Firefighters Joel Perry and Andy Nevens Reviewed by Capt. Randy Edwards November 19, 2014 5 Recommendation The crew of "B" 54 was tasked with researching and recommending for purchase new Thermal Imaging Cameras (TICS). We explored a total of 6 different cameras with various capabilities from the following manufacturers: FLIR, ISG, Bullard, and Argus. On October 291h, Joel Perry and Andy Nevens performed a field test with each TIC at the North Bend Fire Academy. The results of the test are outlined in the pages to follow. Best price quotations were solicited from each vendor as well as warranty and customer service information. Outside fire agencies were contacted for input on their recent TIC purchases. Based on the aforementioned factors, we recommend the department purchase the FUR K50. Our second choice would be the ISG X380. FUR K50 Pros: FUR K50 Cons: $4920 + tax / each New to the FF market Great size and shape Camera picture quality (still pictures) is poor Detailed and clear picture, good accuracy Slow start up, <25 seconds Battery has smart charger Lag/ hesitation between high to low sensitivity ranges Extended warranty - 2 yr. components, 10 yr. sensor Zoom quality poor Easy transition between modes FUR made the sensors for Bullard and MSA before going out on their own. Field Test recommended by members of Lacey Fire and Eastside Fire and Rescue Highly recommended by Portland Fire, Clackamas County Fire, Poulsbo Fire, and Cowlitz Fire 2 ISG X380 Pros: ISG X380 Cons: Been in FF market for many years $7800 + tax / each (if purchase 6 or more) Neighboring departments use ISG. Renton is purchasing the X380 model. Questionable customer service Great size and shape Small lag /hesitation when moving around room Spokane and Tualatin Valley Fire gave positive recommendation 3 color scale jumps around — would need training Great picture Hot spot finder was great feature Laser feature would be good during overhaul Extended warranty — 3 years NFPA compliant A Field Test, Thermal Imaging Cameras - October 29th 2014 Assignment: Review and recommend for purchase new Thermal Imaging Cameras (TIC) that best meets the needs of the Tukwila Fire Department. Thermal Imaging Cameras under review: ISG X380, Argus Mi -320, Eclipse LD, Bullard T4, FUR K50, Bullard T320. Members of B/54 evaluated the prospective cameras during live fire training at the North Bend Academy. The TICS were each given approximately 15 -20 minutes of fire time and graded on their overall function, picture/ display, accuracy and battery life using a scale of 1 to 5 with 5 being the best. • The function grade consisted of the camera's overall size, weight, ergonomics, and ease of use. Additional features were also considered within this grade. • The picture / display grade consisted of the camera's screen size, clarity, quality, color, ability to distinguish materials at different temperatures. • The accuracy grade consisted of the camera's ability to determine the correct temperatures, the ability to quickly change based on different materials and movement between rooms. • The battery life grade was determined based on how long the battery lasted while being used for 15 -20 minutes. Results of the field test: FLIR K50: Overall grade, 4.375 • Function, 3.5 - Pistol grip was nice, easy to use buttons with single gloved hand. Not too heavy, slim profile — good overall size. Initial start had a lag, but after device has been on its boots right up. Menu feature on screen is helpful. • Picture, 4 - Picture was very clear in each fire room. Picture is very detailed, able to see nails and studs behind walls. Screen is good size, good readings. Unit works in rooms with high heat and low to no heat. Great for a search. • Accuracy, 5 - Very accurate, able to pinpoint temperatures between materials. • Battery, 5 - Battery did not lose any life during test — very good. VA ISG X380: Overall grade, 4.375 • Function, 4 - The laser feature would be helpful, especially in overhaul situations. Pistol grip was a plus. Good weight and slim profile. Not bulky or in the way when hanging off of gear. Buttons are easy to use, especially with one hand (wearing gloves). • Picture, 3.5 - Screen size is ok, a little small but able to see everything. Good clarity between materials and different surfaces. Able to see nail patterns in plywood & studs behind walls. Bad — a little annoying when the 3 color scale jumps around- would need training. Small lag/ hesitation in picture when moving it around room. • Accuracy, 5 -Hot spot finder is a great feature. Good accuracy between materials. • Battery, 5 - No loss of power during test. Argus Mi -320: Overall grade, 4 • Function, 4 - Good size, easy to use buttons, fire/ search mode is useful. Handle not ergonomic. Easy to clip on bunkers and move around without it being in the way. • Picture, 4 - Screen is small. Temperature readings are small and hard to see. Clear and detailed picture at high temperatures. No lag between transitions. Colorization same, doesn't change between modes. • Accuracy, 5 - Good accuracy between materials. The crosshair was able to distinguish different material temperatures in close contact with each other. • Battery, 3 - Battery started full and was 1 bar down by the end of the 15 -20min test. Bullard Eclipse LID: Overall grade, 3.25 • Function, 3 - Good size. Not easy to hold and use buttons — felt awkward. • Picture, 3 - Ok picture, uses only blue to distinguish heat. Others use a few colors. Picture seemed to wash out in the blue heat — not impressive. Placement of temperature reading in bad spot. • Accuracy, 4 - Fairly accurate • Battery, 3 - Battery lost 2 bars during 15 -20min test. RI Bullard T4: Overall grade, 3 • Function, 2 - Unit is very big, bulky, and heavy. Not easy to use with gloved hands — takes both hands to operate. Pistol grip is better, but it adds more weight and bulkiness. Without pistol, awkward hand holds. • Picture, 3 - Picture is decent with good screen size. No temperature number display —just a scale. Zoom feature not needed. Picture lagged when moving around room. Recording feature may not be necessary for suppression — fire prevention feature. • Accuracy, 4 - Good accuracy, was able to read different material temperatures. Colorization was the same across rooms. • Battery, 3 - Battery lost 2 bars after 15 -20min test. Bullard T320: Overall grade, 3.5 • Function, 2 - Buttons were hard to use with gloved hands. It took both hands to operate. Hand holds are not good ergonomically. Bulky, not as bad as the Bullard T4. • Picture, 3 - Not a clear picture - compared to competitors. • Accuracy, 5 - Good Accuracy • Battery, 4 - Battery lost 1 bar during test. Other: After we had concluded our testing, a few instructors from Eastside Fire and Rescue, Lacey Fire District 3, and Bates Technical College had a chance to use each thermal camera. They all concluded the FUR was a superior unit. Eastside Fire and Rescue had just purchased the Bullard T320, but he said he would take the FUR over the Bullard they had just bought. Price Quotations FUR K50: Unifire, Inc. 3924 E Trent Ave Spokane, WA 99202 WRIM Joel Perry Tukwila Fire Dist #54 4237 S. 144 St. Tukwila, WA 98168 206-849-1298 ioeloOOOvahoo.com Toll-Free: 1-800-745-3282 Phone 971-269-4226 Fax 609-536-9064 WWW Urlifireusa com Quote Date Quote # 11/14/2014 10065AJS Quote By: Jerry Springer Item Description Qty IVISP Your Cost Ea. Ext. Cost 635,01-0201 K-50 320X240 Thermal Carnem Kits 1 $4,995.00 5 4,275.00 S 4,275.00 T198322 Truck Charger 1 $795,00 $ 645.00 $ 645.00 'Kit Includes: Hard Case, Thermal Imaging Camera (TIC), R2) Li -Ion Batteries, Tabletop Charger stir /Power Supply, USB Cable, Retractable Lanyard, Neck Strap, Tripod Adapter iUNC 1/4'-20), FUR Tools Software (scr3tCh card), Documents Comments Subtotal 6 4,920-00 *ALL PRICES F 0 B SPOKANE, VVA 99202, CUSTOMER RESPONSIBLE FOR ALL SHIPPING AND HANDLI4 ,1G CHARGES -ALL PRICES IN UNITED STATES DOLLARS. —PRICES QUOTED, GOOD FOR 45 DAYS FROM 11/14J2014 Shipping Sales Tax % % Total $4,920.00 10 ISG X380: rr at coast r Of IS UMI September 3rd, 20,14 Joel Perry Tukwila Fire Department 444 Andover Park E Tukwila, WA 98188 OERM 18322 9h St E �Lake Tap s, WA 98391 Ph 53-826-9852 Fax, 253-826,-98,50 E-Mail- thloffman@tx3.net Qty Itern Disc. Price Ext Price 1 ISG, X380 package. S 85O&GO 8,500.00 ncWdes TnC, (2p 3-hour batle6es retractable anyard, truck mount charger, 2 year warrainty, Hot spot tracker & zoom batteries for ffe program 'Trai n the trai ner class preser-teak bV II SG No Charge No Charg Subtota]1 S 8,1500. 001 9 Sh piing & Insuirance $ Subtotal 2 8,600.00 Sales Tax codle 1729 9.81% $ 817.00 GRAND TOTAL GRAND T'OTAL $ 9,417.00 Train the fraenong is a one day ciazz (!witty or w thaut We buMj on a mutuai agreed up,on date. Uasz- wN &- inafructed by fSG director of wectern zale,7 Jay White. Jay her 14 ye arc of Tf C- tiaortong evpeHence. and 35+ yearc in the Fire ce-roce. For orders of 6 or rnore new X380 TIC's, price will drop to S8,300.0101 (plius tax shipping) and a 31" year warranty will Ike added to each TIC, 11 From: "Tracy Hoffman" <thoffman @tx3.net> Date: November 16, 2014 at 16:44:46 PST To: "'Joel "' <joelp00 @yahoo.com> Subject: ISG Final Pricing Joel, After a long and heated exchange with ISG and there cost structure, I was able to match Spokane pricing ($7,800.00) for you IF you order 6 or more TIC's. Let me know if you have any questions. I will be in Idaho first of the week but should be home Tuesday evening if you need anything else. Regards, Tracy Hoffman West Coast Fire & Rescue 1- 888 - 826 -TOOL 0:253- 826 -9852 / C:253- 312 -3939 F:253- 826 -9850 www.westcoastfirerescue.com 12 ADMENDMENT 1 In late November 2014, the crew of B/54 met with Assistant Chief Soss and presented our recommendation of which thermal imaging camera (TIC) to purchase. Our findings were based on significant research. We used a rating system to score each camera, contacted references and departments currently using the products, and tested each device in a live fire scenario. Out of the six cameras tested, the FLIR K50 and the ISG X380 tied with the best results. However, the FLIR K50 was far less expensive than the ISG X380. Since cost was a factor, we suggested that the department choose FLIR. In mid - December, Chief Flores asked us to revisit the TIC research. He wanted additional input from Tukwila Firefighters. We were able to contact the vendors and place both the FLIR K50 and the ISG X380 on L54 for approximately two weeks. We requested that each firefighter use the products and give us feedback. We received approximately ten written responses. Most of the people that responded liked the ISG over the FLIR. They liked the clarity of the ISG at longer distances, the hot spot finder, and the laser pointer. The FLIR did have a couple supporters that did not want ISG because of a history of poor customer service. Many people noted that the display on the FLIR lagged or froze when moved around. To be fair, the ISG lagged during our live fire test and when used during a search scenario at zone 3 truck academy (1/15/15) the unit had a "blank screen" problem. The ISG and the FLIR are both quality products and will provide our membership with better visibility and versatility compared to what we have now. In summary, we feel these imagers will be an asset to our personnel and provide us with a valuable tool to use in any situation that may arise. 13 14 City of Tukwila Jim Haggerton, Mayor INFORMATIONAL MEMORANDUM TO: Mayor Haggerton Finance and Safety Committee FROM: Peggy McCarthy, Finance Director BY: Vicky Carlsen, Deputy Finance Director DATE: March 11, 2015 SUBJECT: Fourth Quarter 2014 Cash & Investment Report ISSUE The fourth quarter Investment Report is included with this memorandum and is discussed below. BACKGROUND City funds are invested to earn a reasonable return while preserving principal and allowing sufficient liquidity to meet the City's operating needs. To achieve these objectives investments are diversified by type, by financial institution, and by maturities in compliance with the City Investment Policy. DISCUSSION Portfolio Components At December 31, 2014, the portfolio totaled $45.4 million comprised of $35.6 million in cash and cash equivalents and $9.8 in longer term investments. The portfolio balance increased by $4.1 million from September 30, 2014 balance of $41.3 million. A major reason for the increase in funds is because the City received $3.85 million in long -term funding for the property purchased earlier in the year. Additionally, Local Improvement District #33 assessments for the first installment were received during the 4th quarter in anticipation of principal and interest payments due in January 2015. In April, the City purchased a Federal Home Loan Mortgage Corp agency investment in the amount of $2 million. It was purchased on April 10, 2014 and will mature on March 4, 2017. This investment has a .50% yield to maturity. In June, the City purchased a second agency investment of $1 million from Fannie Mae with a maturity date of August 23, 2017 and a yield to maturity of .95 %. Now that funding has been obtained to reimburse the City for the purchase of the motels in the Tukwila Redevelopment area (Urban Renewal), the City will seek out investments that will increase the total portfolio yield. Both investments mentioned above increase the percentage of the City's longer -term investments and increase portfolio yield because of the higher interest rates on both agencies. Since these are both longer -term investments, they were placed in the contingency fund where the likelihood of accessing the available cash in the next few years is remote. The purchase of agencies also increases the diversity of the portfolio. 15 INFORMATIONAL MEMO Page 2 Portfolio Performance The portfolio weighted average yield at year end was .61 %. Considering the portfolio's weighted average maturity was 1.0 years, and the yield on the cash & cash equivalent accounts was .32 %, the portfolio yield of 0.61 % is still relatively favorable. The yield has been sustained by the 3.19% average yield on the municipal bond investments, the 1.05% yield on the certificate of deposits, the .67% yield on the agencies, and the .45% earnings credit on the US Bank depository account. Investment income for the fiscal year for cash equivalents and certificates of deposits is $148,192 plus $129,063 of municipal bond and agencies interest for a total of $277,254 against a budget of $262,126. Not included in the portfolio is interest earned from the operating and capital loans to the MPD. The operating loan is being repaid on a monthly basis and will be paid in full by May 2023. Interest earned on the loan for fiscal year 2014 is $19,906. The capital loan is being repaid semi - annually and will be paid in full by December 2022. Interest earned through the end of 2014 is $15,341. Attached to the investment report are amortization schedules for both loans to the MPD. Policy Compliance and Liquidity Analysis As of the end of the 4th quarter, the portfolio profile is well within the range of all the investment policy parameters. There is currently a healthy mix of investments with a range of maturity dates. Current investments allow for adequate cash flow requirements. Fund Cash & Investment Balances The general fund balance shows an increase of $4.8 million from September 30. Property tax revenue is received during the 4th quarter, sales tax for December is higher than other months and $1 million was transferred in from the Facility Replacement fund (Fund 302). The transfer from Fund 302 accounts for the total decline in capital projects funds, from $3.3 million to $2.3 million. Debt service funds show an increase, primarily in Local Improvement District (LID) No. 33 (Fund 233). The first annual installment for the LID was due in October but the bond payment is not made until January 2015. Investment Environment Short term interest rates continue to remain low and are expected to remain low until mid -2015 when interest rates could start rising. Information from the Federal Reserve Board indicates that economic activity is expanding at a solid pace and the labor market continues to show strong job gains and lower unemployment rate. The portfolio will be managed to take advantage of investment opportunities as they arise. RECOMMENDATION Presentation is for information only ATTACHMENTS Cash and Investment Report Policy Compliance & Liquidity Analysis Cash and Investment Balances by Fund Treasury Rates and Yield Curves Amortization Schedule — MPD Operating Loan Amortization Schedule — MPD Capital Loan 16 CITY OF TUKWILA CASH & INVESTMENT REPORT December 31, 2014 Total Cash & Cash Equivalents 35,562,326 35,562,326 0.32% (a) INVESTMENTS (c) (d) Rating Purchase Maturity Term Par Book Yield to Annualized Agency/Issuer Moody s Investment Type Date Date Yrs Value Balance Maturity Return CASH & CASH EQUIVALENTS 5.6 500,000 502,176 3.60% 18,078 CERTIFICATES OF DEPOSIT -- TOTAL 2.9 3,250,000 US Bank Depository Various (b) $17,514,300 $17,514,300 (e) 81,241 4.05% 20,358 0.45% Washington State Treasurer LGIP Investment Pool Various (b) 3,934,135 3,934,135 (f) 0.11% 6,336 Columbia Bank Money market Various (b) 14,113,891 14,113,891 (f) 26,580 0.20% Total Cash & Cash Equivalents 35,562,326 35,562,326 0.32% 114,158 INVESTMENTS Taxable Municipal Bonds Certificates of Deposit City of Marysville, sinking Al LTGO Refunding 11/23/2010 12/1/2017 5.5 415,000 Sound Community Bank Certificate of Deposit 3/4/2014 3/4/2017 3.0 3,000,000 3,147,876 0.85% 30,784 Regal Bank Certificate of Deposit 12/20/2014 12/20/2015 1.0 250,000 250,000 0.50% 3,250 5.6 500,000 502,176 3.60% 18,078 CERTIFICATES OF DEPOSIT -- TOTAL 2.9 3,250,000 3,397,876 1.05% 34,034 Agencies Federal Home Loan Mtg Corp US agency 4/10/2014 5/13/2016 2.1 2,000,000 2,001,867 0.50% 10,000 (FHLMC) FNMA US agency 6/6/2014 8/23/2017 3.2 1,000,000 998,775 1.00% 10,008 TOTAL AGENCIES 2.5 3,000,000 3,000,642 0.67% 20,008 Taxable Municipal Bonds City of Marysville, sinking Al LTGO Refunding 11/23/2010 12/1/2017 5.5 415,000 430,309 3.37% 14,501 2014 -2017, ave 5.5 years Washington State Convention Aa3 Lodging Tax Bonds 11/30/2010 7/1/2016 5.6 500,000 502,176 3.60% 18,078 Center Facility UW Biomedical Center Aal Revenue Bonds 12/14/2010 7/1/2017 6.6 500,000 502,655 4.05% 20,358 UW Biomedical Center Aal Revenue Bonds 12/14/2010 7/1/2019 8.6 500,000 503,302 4.70% 23,655 Douglas County, ESD, sinking Aal UTGO 12/23/2010 12/1/2020 8.9 1,135,000 1,147,313 4.55% 52,203 2018 -2020, ave 9 yrs Port of Anacortes Al LTGO 12/17/2010 9/1/2020 9.7 340,000 332,226 5.00% 16,611 TOTAL MUNICIPAL BONDS 7.7 3,390,000 3,417,982 3.19% 109,055 Total Investments 4,4 9,640,000 9,816,500 1.66% 163,096 (a) On calleable bonds, term is calculated to final maturity even though call date may occur first; term of liquid 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. Percent of Cash & Investment Portfolio (c) Yield to Maturity represents average rate for the year for various investment vehicles. Municipal (d) Annualized Return represents actual earnings for the fiscal year for bonds. Bonds�mmniouVO�u (e) Represents earning credit from US Bank. City earns interest up to the amount of fees. (f) Represents rate in effect for period ending this report. the annualized return above the current CD rates. the annualized return above the current CD rates. Money (h) Annualized Return represents actual earnings through current reporting period Market 33% 8% 9% Cash 42% 17 IN CITY OF TUKWILA Policy Compliance & Liquidity Analysis CASH & INVESTMENT REPORT December 31, 2014 Liauiditv Reauirements and Funds Available for Investina: Funds immediately available $ 35,562,326 Restrictions & designations: Operating liquidity (a) 14,000,000 Liquidity threshold 14,000,000 Funds available for longer term investing $ 21,562,326 (a) Represents largest one month decline in portfolio balance over the most recent 36 month period doubled; or the equivalent of a 100% cushion. I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I As of Report Date I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 1.0 Portfolio Available Available Available in Financial Institution Diversification Portfolio Within 1 Year Within 5 5 - 10 Years Liquidity Analysis & Maturity Diversification Amount 38.6% Years Yes Funds immediately available $ 35,562,326 $ 35,562,326 $ 35,562,326 Yes Fixed Maturity Investments, maturing in: 14,113,891 31.1% 50.0% Yes 0 -90 days after Report Date - 6.9% 50.0% Yes 91 -180 days after Report Date - 14.7% 50.0% Yes Investments maturing in 1 year or less 250,000 250,000 250,000 Investments maturing in 1 -3 years 7,583,658 7,583,658 Investments maturing in 3 -5 years 503,302 503,302 Investments maturing in 5 -7 years 1,479,540 1,479,540 Investments maturing in 7 -10 years - - Investments maturing in more than 1 year 9,566,500 and less than 10 years. TOTALS $ 45,378,826 $ 35,812,326 $ 43,899,286 $ 1,479,540 79% 97% 4% Liauiditv Reauirements and Funds Available for Investina: Funds immediately available $ 35,562,326 Restrictions & designations: Operating liquidity (a) 14,000,000 Liquidity threshold 14,000,000 Funds available for longer term investing $ 21,562,326 (a) Represents largest one month decline in portfolio balance over the most recent 36 month period doubled; or the equivalent of a 100% cushion. I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I 1.0 Portfolio 3.5 POLICY Policy Financial Institution Diversification Amount % of Total MAXIMUM Met? US Bank $ 17,514,300 38.6% 50.0% Yes Washington State Treasurer 3,934,135 8.7% 75.0% Yes Columbia Bank 14,113,891 31.1% 50.0% Yes Sound Community Bank 3,147,876 6.9% 50.0% Yes Other financial institutions 6,668,624 14.7% 50.0% Yes Total $ 45,378,826 100.0% Investment Mix Depository State Investment Pool Money market Certificate of Deposit US Agency Municipal Bonds Total Weiahted Averaae Maturites: Certificates of deposit Portfolio Amount 17,514,300 3,934,135 14,113,891 3,397,876 3,000,642 3,417,982 45,378,826 Years 2.9 Municipal bonds 7.7 Total Investments 4.4 Total Portfolio 1.0 POLICY MAXIMUM 3.5 Policy Met? Yes Note: Cash and cash equivalents are available within one day and are factored into the Total Portfolio weighted average maturity. 6.6% i uu.v ro Performance Analysis Current portfolio yield Benchmarks: 6 month treasury 2 year treasury Local Govt Invst Pool Policy Met? Yes Yes Yes Yes Yes Yes 0.61% 0.12% 0.67% (f) 0.11% W POLICY % of Total MAXIMUM 38.6% insured by PDPC 8.7% 75.0% 31.1% insured by PDPC 7.5% insured by PDPC 6.6% 75.0% 7.5% no limit specified in policy i uu.v ro Performance Analysis Current portfolio yield Benchmarks: 6 month treasury 2 year treasury Local Govt Invst Pool Policy Met? Yes Yes Yes Yes Yes Yes 0.61% 0.12% 0.67% (f) 0.11% W 20 CITY OF TUKWILA Cash & Investment Balances By Fund and Fund Group CASH & INVESTMENT REPORT December 31, 2014 liiiiiiiiiiiiiiiiiiiiililm=� Balances BE 12/31/12 Balances ® $ 3,826,856 $ 3,554,218 $ 3,462,672 12/31/13 General 000 GENERAL 7,824,725 $ 7,737,222 GeneralTotaj ............................................................................................................................................................................................................................. 861,950 ............................... .........7,8 24.........725 7 3........ 7 7 , 222 Special Revenue 101 HOTEL /MOTEL TAX 432,607 537,454 949,888 103 STREET 1,175,916 1,359,905 4,391,371 104 ARTERIAL STREET 462,014 1,167,156 4,771,625 105 CONTINGENCY 5,766,790 5,762,932 561,688 107 FIRE EQUIP. CUM. RESERVE - - 3,686,599 109 DRUG SEIZURE FUND 92,161 75,609 Sp ecial Revenue Total 4,635,412 4,533,184 7,929,489 8,903,056 Debt Service 206 L.I. GUARANTEE 669,147 668,849 2,344,887 207 LIMITED TAX G.O. BONDS 1999 - - 9,838,504 208 LIMITED TAX G.O. BONDS 2000 - 6,390,261 6,435,672 209 LIMITED TAX G.O. BONDS 2003 1 - 12,478,683 210 LIMITED TAX G.O. REFUNDING 2003 195 497 45,505,067 211 LIMITED TAX G.O. REFUNDING 2008 416 718 212 LTGO SCORE BONDS 2 1,453 213 LTGO SCORE BLD AMER BONDS - - 214 LTGO 2010 Series A 2,710 6,561 215 LTGO 2010 Series B - - 216 VALLEY COM Refunding bonds 2010 794 74 217 LIMITED TAX GO BONDS REFUNDING 539 514 218 LTGO 2013 - - 233 LID #33 1,013,693 17,681 Debt Service Total 1,687,496 696,346 Capital Project .... ............................... 301...... ........ LAND ..Q AC....R.EC.. &.. PARK .. DEVLPMNT.............. ............................... ............1....292..321..... 1,159,366 302 FACILITY REPLACEMENT 1,103,366 2,005,539 303 GENERAL GOVERNMNT IMPROVEMENTS 430,911 516,311 ...................... ,,.ital 304 .............................................................................................................................................................................................................................. FIRE IMPACT FEES 504,500 ..........1.................... 437,222 C a p Project Total 3,33 ,098 4 11 8, 4 38 Enterprise 400 UTILITY ON ACCT (overpayments) 170 - 401 WATER 5,826,837 6,315,350 402 SEWER 4,701,199 2,755,073 404 WATER /SEWER REVENUE BONDS - - 405 BOND RESERVE - - 411 FOSTER GOLF COURSE 829,633 535,926 .......................................................................................................................................................................................................... 412 SURFACE WATER ............................... ............1.3,053..771..... 1,695,931 2,612,292 EnterpriseTotal 12,218,641 Internal Service 501 EQUIPMENT RENTAL 4,575,448 4,316,337 502 INSURANCE 4,710,763 6,087,219 ...................................................................................................................................................................................................................... 503 INSURANCE - LEOFF I 526,650 ..............9..81.2..a61..... 1,111,132 Internal„Service Total 11,514,688 Grand Total 43,639,440 45,188,392 Balances Balances Balances 12/31/12 12/31/11 12/31/10 $ 3,826,856 $ 3,554,218 $ 3,462,672 3,826,856 3,554,218 3,462,672 398,276 416,263 645,914 1,031,761 861,950 607,646 394,755 4,640,647 9,820,315 1,460,454 1,457,728 889,470 944,770 949,888 803,981 161,355 229,711 316,024 4,391,371 8,556,188 13,083,348 13,244 - 70 70 3,006,134 3,303,041 153 246 1,156 1,457 217 5,408 (12,741) 126 707 995 616 - 37 37 37 4,612 5,264 17 14 14,014 814 3,012,381 3,330,312 3,050 1,068,126 1,662,953 4,771,625 2,105,864 2,027,271 2,058,699 164,599 561,688 1,470,658 348,010 313,819 156,018 3,686,599 4,565,730 8,457,000 - - 13,700 4,635,412 4,533,184 5,767,311 1,584,458 997,382 1,726,671 309,581 32,012 57,199 2,344,887 2,097,280 2,273,623 8,874,338 7,659,857 9,838,504 4,167,390 3,515,168 3,324,596 6,390,261 6,435,672 5,678,846 1,921,032 1,822,186 1,657,049 12,478,683 11,773,025 10,660,491 36,270,227 39,439,330 45,505,067 Funds not included in the Grand Total are the fiduciary funds and the MPD. However, these balances ($1,739,386) are included in the investment balances. 21 22 CITY OF TUKWILA Treasury Rates and Yield Curves CASH & INVESTMENT REPORT December 31, 2014 Ratac at naramhar q1 gn14 Ratac at naramhar q1 gni.q Source: US Department of the Treasury Comparison of Treasury Rates 23 Rate % liiiiiiiiii�M Change Change 3mo 0.04% - 0.03% -75% 3mo 0.07% 6mo 0.12% 0.02% 17% 6mo 0.10% 1 Yr 0.25% 0.12% 48% 1 Yr 0.13% 2Yr 0.67% 0.29% 43% 2Yr 0.38% 3Yr 1.10% 0.32% 29% 3Yr 0.78% 5Yr 1.65% - 0.10% -6% 5Yr 1.75% 10Yr 2.17% - 0.87% -40% 10Yr 3.04% 30Yr 2.75% -1.21% -44% 30Yr 3.96% Source: US Department of the Treasury Comparison of Treasury Rates 23 24 MPD Operating Loan - through end of 2014 only Period Accumulated Principal Interest (Date) Beg Bal Funding Payments Interest End Bal Interest Pmt Pmt 10/1/2011 $ - $ 191,294 $ $ 319 $ 191,613 $ 319 11/1/2011 191,612.82 - 319.35 191,932.18 638.18 12/1/2011 191,932.18 319.89 192,252.07 958.07 1/1/2012 192,252.07 320.42 192,572.49 1,278.49 2/1/2012 192,572.49 320.95 192,893.44 1,599.44 3/1/2012 192,893.44 - 321.49 193,214.93 1,920.93 4/1/2012 193,214.93 225,000.00 697.02 418,911.95 2,617.95 5/1/2012 418,911.95 - 698.19 419,610.14 3,316.14 6/1/2012 419,610.14 699.35 420,309.49 4,015.49 7/1/2012 420,309.49 700.52 421,010.01 4,716.01 8/1/2012 421,010.01 701.68 421,711.69 5,417.69 9/1/2012 421,711.69 - 702.85 422,414.54 6,120.54 10/1/2012 422,414.54 433,706.00 1,426.87 857,547.41 7,547.41 Prior 11/1/2012 857,547.41 - 1,429.25 858,976.66 8,976.66 12/1/2012 858,976.66 - 1,431.63 860,408.28 10,408.28 1/1/2013 860,408.28 250,000.00 1,850.68 1,112,258.96 12,258.96 2/1/2013 1,112,258.96 - 1,853.76 1,114,112.73 14,112.73 3/1/2013 1,114,112.73 1,856.85 1,115,969.58 15,969.58 4/1/2013 1,115,969.58 1,859.95 1,117,829.53 17,829.53 5/1/2013 1,117,829.53 19,692.58 1,863.05 1,100,000.00 19,692.58 19,692.58 6/1/2013 1,100,000.00 10,121.48 1,833.33 1,091,711.85 21,525.91 8,288.15 1,833.33 7/1/2013 1,091,711.85 10,121.48 1,819.52 1,083,409.89 23,345.43 8,301.96 1,819.52 8/1/2013 1,083,409.89 10,121.48 1,805.68 1,075,094.10 25,151.12 8,315.80 1,805.68 9/1/2013 1,075,094.10 10,121.48 1,791.82 1,066,764.44 26,942.94 8,329.66 1,791.82 10/1/2013 1,066,764.44 10,121.48 1,777.94 1,058,420.90 28,720.88 8,343.54 1,777.94 11/1/2013 1,058,420.90 10,121.48 1,764.03 1,050,063.46 30,484.92 8,357.45 1,764.03 12/1/20131 _ ,050,063.4610,121.48 _ __________ _ 1,750.11 1, 041,692.0832,235.028,371.371,750.11_ _ _ ___ ___ __ 1/1/2014 1,041,692.08 10,121.48 1,736.15 1,033,306.76 33,971.18 8,385.33 1,736.15 2/1/2014 1,033,306.76 10,121.48 1,722.18 1,024,907.45 35,693.35 8,399.30 1,722.18 3/1/2014 1,024,907.45 10,121.48 1,708.18 1,016,494.15 37,401.53 8,413.30 1,708.18 4/1/2014 1,016,494.15 10,121.48 1,694.16 1,008,066.83 39,095.69 8,427.32 1,694.16 5/1/2014 1,008,066.83 10,121.48 1,680.11 999,625.46 40,775.80 8,441.37 1,680.11 Current 6/1/2014 999,625.46 10,121.48 1,666.04 991,170.02 42,441.84 8,455.44 1,666.04 7/1/2014 991,170.02 10,121.48 1,651.95 982,700.49 44,093.79 8,469.53 1,651.95 8/1/2014 982,700.49 10,121.48 1,637.83 974,216.85 45,731.63 8,483.65 1,637.83 9/1/2014 974,216.85 10,121.48 1,623.69 965,719.06 47,355.32 8,497.79 1,623.69 10/1/2014 965,719.06 10,121.48 1,609.53 957,207.11 48,964.85 8,511.95 1,609.53 11/1/2014 957,207.11 10,121.48 1,595.35 948,680.98 50,560.20 8,526.13 1,595.35 12/1/2014 948,680.98 10,121.48 1,581.13 940,140.63 52,141.33 8,540.34 1,581.14 - -- 25 Capital Loan to MPD Repayment Schedule MPD Capital Loan PAYMENT BEGINNING PRINCIPAL INTEREST INTEREST DUE DATE BALANCE PAYMENT RATE PAYMENT ENDING 2/1/2013 Amount loaned to the MPD 1,000,000.00 Prior 6/1/2013 1,000,000.00 (50,731.67) 0.02 (5,833.33) 949,268.33 _ 12/1/2013 _ _949,268.33 _ _ (48,258.90)_ _ _ _ _0.02 _ _ X8,306 10� _ _ 901,009_43 6/1/2014 901,009.43 (48,681.17) 0.02 (7,883.83) 852,328.26 Current 12/1/2014 852,328.26 (49,107.13) 0.02 (7,457.87) 803,221.13 6/1/2015 803,221.13 (49,536.82) 0.02 (7,028.18) 753,684.31 12/1/2015 753,684.31 (49,970.26) 0.02 (6,594.74) 703,714.05 6/1/2016 703,714.05 (46,537.07) 0.03 (10,027.93) 657,176.98 12/1/2016 657,176.98 (47,200.23) 0.03 (9,364.77) 609,976.75 6/1/2017 609,976.75 (47,872.83) 0.03 (8,692.17) 562,103.92 12/1/2017 562,103.92 (48,555.02) 0.03 (8,009.98) 513,548.90 6/1/2018 513,548.90 (49,246.93) 0.03 (7,318.07) 464,301.97 12/1/2018 464,301.97 (49,948.70) 0.03 (6,616.30) 414,353.27 6/1/2019 414,353.27 (48,277.93) 0.04 (8,287.07) 366,075.34 12/1/2019 366,075.34 (49,243.49) 0.04 (7,321.51) 316,831.85 6/1/2020 316,831.85 (50,228.36) 0.04 (6,336.64) 266,603.49 12/1/2020 266,603.49 (51,232.93) 0.04 (5,332.07) 215,370.56 6/1/2021 215,370.56 (52,257.59) 0.04 (4,307.41) 163,112.97 12/1/2021 163,112.97 (53,302.74) 0.04 (3,262.26) 109,810.23 6/1/2022 109,810.23 (54,368.80) 0.04 (2,196.20) 55,441.43 12/1/2022 55,441.43 (55,441.43) 0.04 (1,108.83) 0.00 (131,285.26) 26 T. 1 k :r Po 'ci Finance and Safety Committee Quarterly Information Brie.' 4th Quarter, 2014 Finance & Safe ty Quarterly nformation Brief Agenda Staffing Update y 4t" Quarter Highlights Crime Statistics Finance &Safety Quarterly Information brief Highlights Staffing New patrol sergeants promoted ■ Mike Murphy ■ Kraig Boyd Traffic sergeant position filled by Sergeant Eric Lund Three new officers in the FTO program A world -class police department delivering professional law enforcement service 3 FinarCe & safety Quarterly Information brief Highlights Significant Operations & Events Traffic Control Assistance for Vice President Biden's Visit Car Prowl /Auto Theft Emphasis Light Rail Station Emphasis Black Friday Operations Day After Christmas A world -class police department delivering professional law enforcement service 4 Finance &Safety Quarterly Information brief Highlights Other Updates Trick -or -Treat On Halloween Cascade and Showalter Care Night Christmas Caroling Shop with a Cop Citizen's Academy A world -class police department delivering professional law enforcement service 5 Finance & Safe ty Quarterly nformation Brief 4t" Quarter Crime Statistics Case Reports 3000 2500 2000 Fourth Quarter 1500 2005 -2014 cu ® Fourth Quarter U 1000 Average 500 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 A world -class police department delivering professional law enforcement service 6 Finance & Safety Quarterly nformation Brief 4t" Quarter Crime Statistics Calls for Service 10000 9000 8000 7000 6000 5000 4000 3000 2000 1000 0 Calls for Service Fourth Quarter 2005- 2014 — — Fourth Quarter Average 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 A world -class police department delivering professional law enforcement service 7 Finance & Safe ty Quarterly nformation Brief 4t" Quarter Crime Statistics 40 35 30 25 09 20 45 15 10 5 0 Robbery 2005200620072008200920102011201220132014 Fourth Quarter 2005 -2014 - Fourth Quarter Average A world -class police department delivering professional law enforcement service 8 Finance & Safe ty Quarterly nformation Brief 16 14 12 10 8 6 2014 Crime Statistics Robbery Offenses 2014 Compared to Previous Years <e� fat PQt aJ e'Q Range Since 2005 2014 A world -class police department delivering professional law enforcement service 9 Finance & Safety Quarterly nformation Brief 4t" Quarter Crime Statistics 35 30 25 Aggravated Assault 10 5 0 2005200620072008200920102011201220132014 Fourth Quarter 2005 -2014 — Fourth Quarter Average A world -class police department delivering professional law enforcement service 10 Finance & Safe ty Quarterly nformation Brief 14 12 10 8 6 4 2 2014 Crime Statistics Aggravated Assault Offenses 2014 Compared to Previous Years Range Since 2005 2014 A world -class police department delivering professional law enforcement service 11 Finance & Safe ty Quarterly nformation Brief 4t" Quarter Crime Statistics 70 60 50 a 40 t1 30 20 10 0 Burglary 1st and 2nd Degree 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 Fourth Quarter 2005 -2014 Fourth Quarter Ave rage A world -class police department delivering professional law enforcement service 12 Finance & Safe ty Quarterly nformation Brief 2014 Crime Statistics Burglary 1 -2 Offenses 2014 Compared to Previous Years <<e`° fat P�� �aA �c. \ P�4.0 Q OLD �04 OeL Range Since 2005 -2014 A world -class police department delivering professional law enforcement service 13 Finance & Safety Quarterly nformation Brief 4t" Quarter Crime Statistics 100 90 80 70 N 60 ow 50 o 40 30 20 10 0 Residential Burglary 2005200620072008200920102011201220132014 Fourth Quarter 2005 -2014 Fourth Quarter Average A world -class police department delivering professional law enforcement service 14 Finance & Safe ty Quarterly nformation Brief 35 30 25 20 15 10 2014 Crime Statistics Residential Burglary Offenses 2014 Compared to Previous Years fat QQt �A se9 O`er \-N.O Oee Range Since 2005 2014 A world -class police department delivering professional law enforcement service 15 Finance & Safety Quarterly nformation Brief 4t" Quarter Crime Statistics 250 200 a, 150 a, O 100 50 0 Auto Theft 2005200620072008200920102011201220132014 Fourth Quarter 2005 -2014 ® Fourth Quarter Average A world -class police department delivering professional law enforcement service 16 Finance & Safety Quarterly nformation Brief 70 60 50 40 30 20 10 2014 Crime Statistics Auto Theft Offenses 2014 Compared to Previous Years fat QQt �A se9 o`er \-N. (54 Oee Range Since 2005 2014 A world -class police department delivering professional law enforcement service 17 Finance & Safe ty Quarterly Information Brief 4th Quarter Crime Statistics 400 350 300 250 a 200 150 100 50 0 Theft from Vehicle 2005 2006 2007 2008 2009 2010 2011 2012 201 3 2014 Third Quarter 2005 -2014 — Third Quarter Average A world -class police department delivering professional law enforcement service 18 Finance &Safety Quarterly nformation Brief 140 120 100 80 60 40 20 2014 Crime Statistics Theft from Vehicle Offenses 2014 Compared to Previous Years qe� PJgo c, 6Q Oe` Range Since 2005 2014 A world -class police department delivering professional law enforcement service 19 Finance & Safe ty Quarterly nformation Brief Questions?