The URL can be used to link to this page

Home My WebLink AboutFIN 2017-06-20 COMPLETE AGENDA PACKETCity of Tukwila Finance Committee O Verna Seal, Chair O Kathy Hougardy O Thomas McLeod AGENDA TUESDAY, .TUNE 20, 2017 — 5:30 PM HAZELNUT CONFERENCE ROOM (At east entrance of City Hall) Distribution: Recommended Action V. Seal Mayor Ekberg K. Hougardy D. Cline T. McLeod C. O'Flaherty D. Robertson L. Humphrey Item Recommended Action Page 1. PRESENTATION(S) 2. BUSINESS AGENDA a. A resolution repealing Resolution No. 1894 and a. Forward to 6/26 Special Pg.i re- adopting the consolidated permit fee schedule to Meeting Consent Agenda. revise the credit card surcharge requirements. Nora Gienof,, Deputy Community Development Director b. April 2017 year -to -date financial update. b. Information only. Pg. 15 Vicky Carlsen, Deputy Finance Director c. 2017 1st Quarter cash and investment report. c. Information only. Pg.19 Vicky Carlsen, Deputy Finance Director d. 2017 1st Quarter miscellaneous revenue report. d. Information only. Pg.29 Vicky Carlsen, Deputy Finance Director 3. ANNOUNCEMENTS 4. MISCELLANEOUS Next Scheduled Meeting: Wednesdag, Ju /y5, 2017 SThe City of Tukwila strives to accommodate individuals with disabilities. Please contact the City Clerk's Office at 206 - 433 -1800 ( TukwilaCityClerk (a)TukwilaWA.aov) for assistance. C"ty of Tukwila %01 . . . . ....... . . . . ..................................... . ..... Allan Ekberg, Mayor TO: Finance Committee FROM: Jack Pace, DCD Director BY: Nora Gierloff, Deputy DCD Director CC: Mayor Ekberg DATE: June 7, 2017 SUBJECT: Modification to Credit Card Surcharge ISSUE Waiving the credit card surcharge for online permit applications in 2017 has created practical difficulties with launching eTrakit online payments, BACKGROUND The City's costs for processing credit card payment for permit applications have been increasing steadily over the years. This trend is expected to sharply, increase over the next few years as wc begin to allow online permit applications. In 2017 to offset this cost the City began charging a 3% surcharge on permit fees paid by credit card, The current fee resolution includes a waiver • this fee for online permit applications in 2017 to provide an incentive for the public to use the online system, DISCUSSION Configuring the waiver for payments received online has proved to be difficult and wouId require a 'work-aroiund' • staff to associate the waiver with each permit processed online. While it is possible to configure the system this way, it would require significant staff time and delay implementation of online permit payments. It would then require additional time at the end of the year • remove the waiver from the system. Staff recommends removing the fee waiver from the resolution to allow the launch of eTrakit *nline permitting within the next month. No other changes to the resolution are proposed in the attac4,,ecl draft. FINANCIAL IMPACT Removing the fee waiver will slightly increase City revenues and allow us to offset credit card fees, RECOMMENDATION The Council is being asked to approve the revised resolution and consider this item at the June 26 pecial Meeting Consent Agenda. ATTACHMENT Draft Building /Electrical /Plumbing /Mechanical Permit Fee Resolution 2 0 rr�� IJ13 11 1 WHEREAS, the City Council adopted Resolution No. 1894 In 2016�, establishing the City's current consolidated construction fee schedule; and WHEREAS, the fee schedule included a waiver of the 3% credit card surcharge for online permitting transactions in 2017 to incentivize use of the online application process; and WHEREAS, staff has determined that programming this waiver into the TRAK-iT permit processing program and then removing it at the end of the year would require excessive staff time and delay implementation of online permitting; and WHEREAS, staff time would be better spent preparing eTRAK-iT for use by the public; NOW, THEREFORE, THE CITY COUNCIL OF THE CITY OF TUKWILA, WASHINGTON, HEREBY RESOLVES AS FOLLOWS: Section 2. For 2017 and 2018, the Technology Fee shall be set at 5% of the applicable permiit fee. MWord ProcessinglResolutions\Consolidated permit fee schedule-credit card surcharge 6-9-17 NG:bis Page 1 of 11 Section 3. Public Works fees will be charged according to the following schedule: PUBLIC WORKS FEE SCHEDULE PERMIT DESCRIPTION . . ....... ...... Type A (Short-Term Non-profit) Type B (Short-Term Profit) FEE $ 5,0.00 + Technology Fee $100,00 + Technology Fee Type C $250.00 application base fee, Technology Fee, plus (infrastructure and Grading on Private Property four components based on construction value* and City Right-of-Way and Disturbance of City 1) Plan Review Right-of-Way) 2) Construction Inspection Hearing 3) Pavement Mitigation Decision Type 4) Grading Plan Review Fee See Public Works Bulletin Al for fee schedule. Type D (Long-Term) $100.00 + Technology Fee Type E (Potential Disturbance of $100.00 + Technology Fee Cit y Right-oLV2 y)_______ Type F (Blanket Permits) $250.00 processing fee, plus $5,000,00 cash deposit, ......... withdraw $100,00 per instance for ins action Franchise — Telecommunications® $5,,000.00 administrative fee Franchise — Cable $5,000.00 plus 5% of total revenue . . .............. Street Vacation $1,2�00.00 . ................. . ..................... Latecomer's Agreements $500.00 processing fee, plus 17% administrative fee, lus $500.00 segreg ition fee LFlood Zone Control Permit $50.00 + Technology Fee Section 4. Land use permit and processing fees will be charged according to the following schedule: LAND USE FEE SCHEDULE All peer review fees will be passed through to the applicant per TMC Section 18.50,200. WAVVord Processing\ResolutionslConsolidated permit fee schedule-credit card surcharge 6-9-17 NG,bjs Page 2 of 11 El Plus 2017 2018 Hearing Plus Decision Type Fee Fee Examiner Technology Fees Fee TF Appeal Type 1, 2 and 4 Decisions $614 $626 .... . . ..... SEPA MDNS Appeal $614 $626 Appeal of Sign Code Decision $614 $626 Impact Fee Appeals: Fire $614 $626 Parks $614 $626 Transportation $614 $626 _j WAVVord Processing\ResolutionslConsolidated permit fee schedule-credit card surcharge 6-9-17 NG,bjs Page 2 of 11 El WkWord Processing\Resolutions\Consolidated permit fee schedule-credit card surcharge 6-9-17 NG:bjs Page 3 of 11 Pius Hearing Plus Decision Type Examiner Technolog�t_ Fees Ft2 _EF Sign Permit (TMC Chapter 19) Permanent Pole/Banner In itia I Ap plication Special Event MEN Pole/Banner Annual Renewal New Billboard Master Sign Program—Admin Master Sign Program—BAR TUC Zone Modifications Modification to TUC Corridor Standards (TMC Section 18. 2& 130 ific ation to TUC Open Space Regulations Section 18. 2& 250 D uctin to Parking Requirements Transit Red o mmmma (TMC Section 18. 2& 260, 8 5 Design Review (TMC Section Administrative Public Hearing I . ...... . ....... . Major Modification Minor Modification Parking Variances and Special.Perthissions Administrative Parking Variance �'lll��; (Type 2—TMC Section 18.56 .140 Parking Variance (Type 3--Tlt� .14J0 q,Section 18.5q__ Parking Standard for use not specified (TMC 1& 28.250 D. 4. d. I and TMC 1& 56. qo . . ....... . Residential Parking Reduction (TMC Section 18.56.06�) WkWord Processing\Resolutions\Consolidated permit fee schedule-credit card surcharge 6-9-17 NG:bjs Page 3 of 11 WAWord Prooessing\Resolutions\Consolidated permit fee schedule-credit card surcharge 6-9-17 NG:bjs Page 4 of 11 Plus 2017 2018 Hearing Plus Decision Type Fee Fee Examiner Technology Fees Fee TF Variances, Special Permissions and Site Plan, Review Variances $2,940 $2,998 +HE TF CSection . . . . . .............................................. Environmentally Sensitive Areas Deviation, $1,556 $1,587 + TF Buffer Reduction (TMC Chapter 18.45) Reduced fee for LDR homeowners, no $614 $626 associated short plat Reasonable Use Exception $,3,111 $3,173 + HE + TF (TMC Section 18.45.184 Exception from Single Family Design Standard $614 $626 + TF _,LEIqq Section 18. 50, O�q,) ... . ..... ............ . . . . .......... . ..... .. — -------- mm mm Special Permission Cargo Container $614 $626 + TF (TMC Section 18. 50. 060 Landscape Perimeter Averaging $614 $626 + TF (TMC Section 18. 5Z 060) Tree and Landscape Modification Permit and $109 $111 + TF Exceptions (TMC Cha pter 18.51) Lot Creation and Consolidation Boundary Line Adjustment $1,744 $1,779 + TF (TMC Chapter 17.08) .. . Lot Consolidation ...................... $648 $661 + TF (TMC Chapter 17.08 . . ........ . . . .. . ...... Short Plat (2-4 lots) $3,971 $4,050 + TF TMC Chapter 17.12) . ......... .............. hort Plat (5-9 lots) $4,520 $4,610 + TF rmc Chapter 1 T 12) . .._.....w___ Subdivision: Preliminary Plat (10+ lots) $5,187 $5,290 + HE + TF (TMC Section 17, 1 4. Q?O J ................ . . Final Plat (10+ lots) $3,111 $3,173 + TF Section 17,12.039) ,,,---(TMC Binding Site Improvement Plan $3 971 + TF , (TMC Chapter 17. . . . . . . . . . ....................... . .......... . ........ Planned Residential Development: Administrative (TMC Section 18.46. 110) $2,260 $2,306 + TF Public Hearing (TMC Section 18. 46 110) $5,187 $5,290 + TF Minor Modification (TMC Section 18.46x.1,30) $614 $626 + TF Major Modification (TMC Section 18. 46 130) $2,522 $2,573 + TF WAWord Prooessing\Resolutions\Consolidated permit fee schedule-credit card surcharge 6-9-17 NG:bjs Page 4 of 11 ._.__.m.......... . ....... Plus 2017 2018 Hearing Plus Decision Type Fee Fee x Examiner Technology - Fees Fee (TF) Wireless Communication Facility (TMC Chapter 18,58,050), Minor (Type 1) $614 $626 + TF Administrative (Type 2) $1,744 $1,779 + TF Major or Height Waiver (Type 3) $3,487 $3,557 + HE + TF SEPA and EnvironmenW Checklist $1,1778 $1,813 + TF SEPA EIS $3,111 $3,173 + TF SEPA Planned Action $614 $626 + TF SEPA Addendum $614 $626 + TF SEPA Exemption Letter $362 $369 + TF I Sensitive Area Master Plan Overlay $5,187 $5,290 + TF (TMC 18-45.160) Shoreline Permits Substantial Development Permit (TMC Chapter 18.44) Project value. $5,000-$10,000 $1,229 $1,254 + TF ITIT $10,001 - $50,000 $2,874 $2,932 'IT� + TF $50,001 - $500,000 . . .... . .... $4,585 $4,677 + TF More than $500,000 $5,813 $5,929 + TF Permit Exemption Letter, Shoreline $253 $258 + TF . ... . ...... . .. Shoreline Permit Revision $636 $649 + TF Conditional Use Permit, Shoreline $4,036 $4,117 + HE + TF (TMC 18,44.050 ) WmITITmmmm Shoreline Tree Permit 'TMC $111 + TF Cho ter 18.41) Shoreline Environment Redesignation $3,111 $3,173 + TF Noise Variance (TMC Section 8.22.,120) Type 1 $504 $5 + TF Type 11 . . . . . . . ......... $680 $694 + TF Type 111 $1,513 $1,543 +HE + TF Use Permits Conditional Use Permit $4,036 $4,117 + HE + TF (TMC Section 18.64.029�_ Unclassified Use Permit $5,187 $5,290 + TF (TMC Chapter 18.66 TSO Special Permission Use 11,008 $1,028 +HE + TF (TMC Section 18.41.060) WkWord Processing\Resolutions\Consofiidated permit fee schedule-credit card surcharge 6-9-17 NG:bjs Page 5 of 11 A. Non-Structural Plan Review F A non-st�ructural plan review fee shall be paid at the time of submitting plans and specifications for review. The non-structural M lan review fee shall be 65% of the calculated permit fee as set forth in the permit fee i Qchedule. The non-structural plan review fee specified herein is a separate fee from the permit fee and is in addition to the permit fee. B. Structural Plan Review Fee. Where a structural plan review is deemed necessary, a structural plan review fee shall be charged. The structural plan review fee Q-hall be 35% of the calculated non-structural plan review fee. Section 6. Mechanical permit fees, will be charged according to the following schedule: MECHANICAL PERMIT FEE SCHEDULE Valuation o f Work (Total Mechanical Permit Fee Contract Amount) - — ---- - . .......... — - ----- .... ......... $33.15 for issuance of each permit (base fee) + Technology Fee — - -------- ------------ . ........... . .... . ..... $250 or less $66.30 + Technology Fee L— - -------------- - ---- --------------- $251 to $500 - --- - . ...... . . .. ....... . ...... ___" ........... - --------- $66.30 for first $250, plus $7.99 for each $100 or fraction thereof, to and including $500, + Technology Fee ------- - ------- $501 to $1,000 $86.29 for the first $500, plus $8.87 for each $100 or fraction thereof, to and including $1,000, + Technology Fee . . ...... .. ................................................ $1,001 to $5,000 $130.66 for the first $1,000, plus $9.84 for each $1,000 or fraction . .......... . . ..... . . . . thereof, to and including $5,000, + Technology Fee . . ............ . . ............. . . .......... . .. $5,001 to $50,000 $170.03 for the first $5 „.000,. plus $10.25 for each $1,000 or fraction thereof, to and including $50,000, + Technology Fee $50,001 to $250,000 $651.98 for the first $50,000, plus $8,57 for each $1,000 or fraction . . .... ........... thereof, to and including $250�,000, + Technology Fee ...... $250,001 to $1,000,000 $2,365.58 for the first $250,,0,00, plus $7,55 for each $1,000 or fraction . . . . ..... ......... .. . ............. .................. ....... thereof, to and including $1,000,000, + Technology Fee $1,000,001 and up $8,026.58 for the first $1,000,000, plus $6,83 for each $1,000 or fraction thereof, + Technology Fee . . . ..... . ..................... . 11-1-- ........................... . . ............... W.Word Processing\Resolutions\Consolidated permit fee schedule-credit card surcharge 6-9-17 NG:bjs Page 7 of 11 Section 7. Plumbing permit fees will be charged according to the following schedule: PLUMBING PERMIT FEE SCHEDULE -- - - - -- ----- ----------- Permit Issuance issuance of each permit (base fee) ... ....... . . ..................... .... ........ . $33.15 + -T—ec h n. o log-- y Fee - - - --------- Unit Fee Schedule (in addition to base fee above: . ............. . . ..... . . ... . . ............. . ... For one plumbing fixture (a fixture is a sink, toilet, bathtub, etc.) .. . .... . ..... . ............. ------ -1-1-- . .... ........... — - - - ---- ---- ...... ..... . — - - — - — - - ----------- $66.30 + Technology Fee . . . . .......... For each additional fixture --------------- . ...... ------- $14.28 + Technology Fee .. ..............._1111. For each building sewer and each trailer park sewer .... ....... $25.30 + Technology Fee . . ..... - . .... ..... Rain waters - per drain (inside building) ........ ..... ................... . .......... . . ..... . $1418 + Technology Fee . ... . ... For each water heater and/or vent $1418 + Technology Fee For k-' - —"- "- '"'- ---- ,- ,- - . - eachin dustri alwaiie p re t rea t m e n t interceptor„ terceptor, including its, ....... .. . . ..... .. . ................. . .... . ....... . . $28.56 + Technology Fee Ifqr ki h i ter rs trap and vent, except kitchen typ trap -91--'Tcep� . .............. . . . . . ......... . .............. For each grease interceptor for commercial kitchens $29.68 + Technology Fee .. ........ . . r6___.w --1--'r1...- ............ For each repair or alteration of water piping and/or water treating ------- $14.28 + Technology Fee tl each occurrence e� . ... . ......... - --------- For each repair or alteration of drainage or vent piping, each $14,28 + Technology Fee fixture For each medical gas piping system serving one to five . ................. . ..... . . . . . . . . ... ....... .. ..... ------ -- $8164 + Technology Fee inlets/outlets for a sp For each additional medical gas inlets/outlets $16.52 + Technology Fee "s--p-r-in---k-l"e-"r-",-s"-y,"s-,t-e-m""o-n--a""n",y-"-o""n,-e ---- (1-)`m —ete'r i-n-c-I 6-d i $29.68 + Technology Fee backflow pro!ec!ion devices therefor, ......._r ... , - 'ow - -... - .. - ".111-1-11'' I'll 11 I'll - 1 111111111111111111-11", - " . . . . . ...... . . . . ................................ . . - or atmospheric-type vacuum breakers not included in lawn sprinkler backflow protection, 1 to 5 ........$14.00 + Technology Fee Over 5,......$14.00 for first 5 plus $3.25 for each additional ... ......... .......... . . Technology _...g _ .... -- --- - ... . .. ........... . ... - ..................................................... ......... . or each backfl o" w p r 6 t e c'tive device other than atmospheric type vacuum breakers, 2-inch diameter and smaller.....,,$29.10 + Technology Fee Over 2-inch diameter. .., � ... ... .... $32.25 + Technology . ............ .. . . .... . . ..... ... .......... ----------------- ..................... .......... .......... . . . . .. WAVVord Prooessing\ResolutionskConsolidated permit fee schedule- credit card surcharge 6-9-17 NG:bjs Page 8 of 11 10 Section 9. Electrical permit fees will be charged according to the following lit"dule: 1. NEW SINGLE-FAMILY DWELLINGS ------ . . . .... --------------------------- New single-family dwellings (including a garage) $155.91 + Technology Fee .111"'"" ............ .................. - Garages, pools, spas and outbuildings $83.54 + Technology Fee ..... ...... .A....._...... .... ................... . ... . .......... . . .. .... . . .................. . . . . ....... . Low voltage systems $61.05 + Technology Fee .... . ............... . ...... . - ............... - - . . . . . ................ . 2. SINGLE-FAMILY REMODEL AND SERVICE CHANGES ..... .. ......... ......... ........ Service change or alteration-no added/altered circuits $83�54 + Technology Fee .L ---------------- ....... . Sei .. - change $83.54 with added/altered circuits, plus $1'2.00 for $83.54 + Technology Fee each added circuit (maximum perrnLit fee . �I�§,qq) ircuits added/altered without service change (includes up to $55.69 + Technology Fee . .... ------ - --------- .............................. . .. Circuits 55.69 added/altered without service change (more than $55.69 + Technology Fee 5 circuits); $7.65 for each added circuit (maximum permit fee $100,00 + Technolo y Fee) - - ----------- - - ----- -------- ------------------------------ ----- - - . ......... ' ----------- - — -- - --- - ------ - -- --- Meter/mast repair $69,62 + Technology Fee ............... Low voltage systems + Technology Fee - -------------- . ............................................. ........ . .... . . . ............ . . ............. ...... . . . ................. .......... . . .... . ------ 3, MULTI-FAMILY AND COMMERCIAL (including low voltage) Valuation of Work (Total Permit Fee . ........ . Contract Amount $250 or less $66.30 + Technology Fee $251 - $1,000 $66.30 for the first $250 plus $,4.39 for each $100 or fraction thereof, to and jqcluq!q $1,000,, + Technology Fee $1,001 - $5,000 $98.94 for the first $,1,000 plus $22,03 for each $1,000 or fraction thereof, to and including,$5,000, + Technology Fee $5,001 - $50,000 $186.97 for the first $5,000 plus $18.05 for each $1,000 or fraction thereof, to and including $50,000, + Tech nqIo9.y_ft(L_ $50,001 - $250,000 $998.73 for the first $50,000 plus- $13.16 for each $1,000 or fraction thereof, to and including $250,000, + Technology Fee $250,001 - $ f,666 0-60— $3,638,54 for the first $2501,000 plu-s- $9.33 for each $1,000 or fraction thereof, to and including $1,000,000, + TechDp!qgy Fee..... Over $1,000,000 $10,649.51 plus 0.5% of cost over $1,000,000, + Technology Fee WAWord Processing\Resolutions\Consolidated permit fee schedule-credit card surcharge 6-9-17 NG:bjs Page 9 of 11 11 Section 10. Other inspections and fees will be charged according to the following schedule: OTHER INSPECTIONS AND FEES Inspections outside of normal business hours (three hour minimum charge) -- - - --------------------------- ---- - ----- ----------- -- - -- $102.00/hour Re-inspection fee ---- - . ........... .... . ... ... $67,83/hour Inspection for which no fee is specifically indicated—investigations or safety .............. $67,83/hour ins•ec tions I Additional plan review required by changes, additions, or revisions to approved $67. 83/hour nimum �i;h _pLans_(rr� Work commencing before permit issuance shall be subject to an investigation fee 100% of the permit fee _ip _g Plan review fee—Mechanical, P6"r biin" g F u 6_1 G a i r a n-di for review shall be 25% of the total calculated permit fee. The plan review fee is a separate fee from the permit fee and is required when plans are required in order to document com liance with the code, ................ _ .......... _ ...... . ...... .. . ...... ... ..... ... ... . . .......................... .... ..... . ... . . .. . . ............................ ork covered without inspection or work not ready at the time of inspection may _'be ch.a.rg.e.d...a fe._.ins�pection fee of $66.50. ------- ... Expired permit final - includes two inspections $133.00 . . . .. .. ...... .......................................... . .. p add pe o Exired permit final - each itional insctin . ...... . ....... . . . . . ......... . . ............. I 6 8 Minor residential remodel plan review and permit (projects up to $20,000) .......... . . .. $20.00 Section 11. Credit Card Surcharge. If payment is made by credit card, a processing fee of 3% will be added to the total ord�er. N 1__,_fee-w4-be-*�9ed WAWord Processing\Resolutions\Consolidated permit fee schedule-credit card surcharge 6-9-17 NG bjs Page 10 of 11 12 PASSED BY THE CITY COUNCIL OF THE CITY OF TUKWILA, WASHINGTON, at 2 Regular Meeting thereof this day of 1201T, - a A Christy O'Flaherty, MMC, City Clerk mm volm M-0 M-1 Filled with the City Clerk� Passed by the City Council: Resolution Number, WAWord Processing Res olutionslCo n sofidated permit fee schedule- credit card surcharge 6-9-17 NG:bjs Page 11 of 11 13 14 City of Tukwila Allan Ekberg, Mayor INFORMATIONAL MEMORANDUM TO: Councilmembers CC: Mayor Ekberg FROM: Peggy McCarthy, Finance Director BY: Craig Zellerhoff, Fiscal Coordinator DATE: June 9, 2017 SUBJECT: 2017 April Year to Date Financial Update Summary The purpose of the 2017 Financial report is to summarize for the City Council the general state of Departmental expenditures and to highlight significant items or trends. The following provides a high -level summary of the Departmental financial performance. The 2017 April YTD report is based on financial data available as of June 9th, 2017, for the reporting period ending April 30th, 2017. Additional details can be found within the attached financial report. Allocated budgets through the reporting period are calculated by analyzing spend patterns in the previous year and allocating the current year budget using the same spend pattern. If a line item had no expenditures in the prior year but a budget in the current year, the allocated budget for the current year would be zero. Departmental Expenditures General fund expenditures totaled $18.9 million as compared to the allocated budget of $20.0 million, which is $1.1 million below budget. Notable variances are as follows: • Recreation department is above budget by $29 thousand, although overall spending to date is 28% of budget through April. Administration salaries and benefits are greater than 2016 due to being fully staffed in 2017. Supplies are higher than normal due to costs associated with the 20 -year Gala celebration. The department also incurred expenses related to the Teen visit to Olympia, these costs were funded through a grant /donation from World Vision. • Fire department is above budget by $51 thousand. This is attributed to the staffing of the unbudgeted pipeline positions (5 vs 3 in 2016) to maintain minimum staffing levels. Overtime is now in line with budget with a overspend four thousand year -to -date. • Park department exceeded budget by $67 thousand. This is a result of the department being fully staffed in 2017 compared to 2016. They also incurred a higher level of spending on supplies as they are being more proactive and intentional in the planning and preparation for busier summer months. • Transfers from the general fund into capital projects funds for first quarter have not been recorded. Rather than transferring funds automatically, we will be transferring funds into the capital projects funds as needed. 15 INFORMATIONAL MEMO Page 2 Year 'to I'. )a-te I'. )epairtment I::.::.::xpendi-tuires Compared toAIHocated IBudget ("T hiro ug h Ap id 12 0,17) 16 INFORMATIONAL MEMO Page 3 GENERAL FUND CITY OF TUKW ILA GENERAL FUND EXPENDITURES YTD AS OFAPRIL 30, 2017 6/9/2017 13:00 Percent of year completed 33.33% 17 BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY OF EXPENDITURES BY ACTUAL DEPARTMENT 2017 OVER/(UNDER) %CHANGE ALLOCATED 2017 ANNUAL ALLOCATED 2015 2016 2017 l3DGT %SPENT 2015/2016 2016/2017 01 City Council 366,016 137,884 111,497 116,218 116,922 (20,963) 32% 4% 1% 03 Mayor 4,079,582 1,149,262 1,022,287 1,153,323 1,113,051 (36,212) 27% 13% (3)% 04 Human Resources 706,208 241,092 202,982 211,721 208,538 (32,553) 30% 4% (2)% 05 Finance 2,638,813 1,131,334 1,020,293 966,270 1,017,800 (113,534) 39% (5)% 5% 06 Attorney 716,955 185,794 146,890 137,289 164,735 (21,059) 23% (7)% 20% 07 Recreation 3,384,688 927,470 870,881 886,675 956,772 29,301 28% 2% 8% 08 Community Development 3,693,338 1,162,940 941,146 1,005,206 1,052,322 (110,618) 28% 7% 5% 09 Municipal Court 1,307,808 420,783 363,795 374,825 383,482 (37,302) 29% 3% 2% 10 Police 18,288,092 6,246,815 5,744,324 6,115,290 5,767,899 (478,915) 32% 6% (6)% 11 Fire 11,862,568 3,992,757 4,000,375 3,804,038 4,044,198 51,441 34% (5)% 6% 12 Technology& Innovation Svcs 2,026,820 624,850 330,336 421,895 513,492 (111,357) 25% 28% 22% 13 Public Works 3,802,639 1,273,908 1,240,927 1,244,460 1,231,296 (42,612) 32% 0% (1)% 15 Park Maintenance 1,418,760 400,722 409,027 375,106 467,914 67,192 33% (8)% 25% 16 Street Maintenance & Operations 3,109,592 1,122,868 928,858 1,053,281 1,094,175 (28,692) 35% 13% 4% 20 Dept 20 5,237,691 956,203 789,962 868,906 771,501 (184,702) 15% 10% (11)% Total Expenditures 62,639,570 19,974,682 1 18,123,579 18,734,504 18,904,097 1 (1,070,585) 30% Percent of year completed 33.33% 17 INFORMATIONAL MEMO Page 4 GENERAL FUND CITY OF TUKW ILA GENERAL FUND EXPENDITURES YTD AS OFAPRIL 30, 2017 6/912017 13:00 Percent of year completed 33.33% BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY OF SALARIES AND ACTUAL BENEFITS 2017 OVER/(UNDER) %CHANGE ALLOCATED 2017 2017 ANNUAL ALLOCATED 2015 ALLOCATED 2017 BDGT %SPENT 2015/2016 2016/2017 Transfers 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT %SPENT 2015/2016 2016/2017 (11)% 11 Salaries 27,560,991 9,229,759 8,513,026 8,810,769 8,893,204 (336,555) 32% 3% 1% 12 Extra Labor 777,897 179,696 132,434 175,205 162,882 (16,814) 21% 32% (7)% 13 Overtime 1,632,035 456,256 600,721 413,697 533,904 77,647 33% (31)% 29% 15 Holiday Pay 525,583 5,252 2,518 4,751 4,726 (526) 1% 89% (1)% 21 FICA 1,809,260 597,877 547,557 563,518 575,302 (22,575) 32% 3% 2% 22 Pension- LEOFF2 849,253 266,328 256,853 261,450 264,742 (1,586) 31% 2% 1% 23 Pension - PERS /PSERS 1,580,986 518,381 368,805 453,149 478,303 (40,078) 30% 23% 6% 24 Industrial Insurance 864,098 258,782 183,180 207,415 197,679 (61,102) 23% 13% (5)% 25 Medical & Dental 5,903,094 1,980,171 1,756,490 1,877,454 1,874,680 (105,492) 32% 7% (0)% 26 Unemployment 13,000 - 1,285 19,276 471 471 4% 1400% (98)% 28 Uniform /Clothing 10,460 1,769 1,459 1,002 965 (805) 9% (31)% (4)% Total Salaries and Benefits 41,526,657 13,494,271 12,364,328 12,787,685 12,986,857 (507,415) 31% 3% 2% Percent of year completed 33.33% Percent of year completed 33.33% i BUDGET ACTUAL COMPARISON OF RESULTS SUMMARY OF SUPPLIES, ACTUAL SERVICES, AND CAPITAL 2017 OVER/(UNDER) %CHANGE ALLOCATED 2017 ANNUAL ALLOCATED 2015 2016 2017 BDGT %SPENT 2015/2016 2016/2017 Transfers 5,237,691 956,203 789,962 868,906 771,501 (184,702) 15% 10% (11)% 31 Supplies 1,164,823 366,666 365,160 362,180 413,645 46,978 36% (1)% 14% 34 Items Purchased for resale 22,000 283 1,307 (673) 3,822 3,539 17% (151)% (668)% 35 Small Tools 99,818 22,974 182,682 15,930 32,258 9,284 32% (91)% 102% 41 Professional Services 3,266,711 615,535 576,841 512,085 598,760 (16,775) 18% (11)% 17% 42 Communication 449,970 111,273 111,759 100,413 111,307 34 25% (10)% 11% 43 Travel 192,380 76,619 47,838 56,076 65,171 (11,448) 34% 17% 16% 44 Advertising 51,500 13,025 6,405 9,131 7,139 (5,885) 14% 43% (22)% 45 Rentals and Leases 2,314,372 997,454 869,444 871,893 717,979 (279,475) 31% 0% (18)% 46 Insurance 886,895 886,758 779,175 810,866 881,033 (5,725) 99% 4% 9% 47 Public Utilities 1,893,570 720,383 577,552 699,173 750,450 30,066 40% 21% 7% 48 Repairs and Maintenance 732,613 217,186 265,354 210,148 183,011 (34,175) 25% (21)% (13)% 49 Miscellaneous 1,562,773 537,373 418,691 347,382 435,539 (101,834) 28% (17)% 25% 51 Inter - Governmental 3,003,792 942,915 767,065 840,524 922,921 (19,994) 31% 10% 10% 53 EATaxes, Oper. Assess 5 - 18 6 52 52 1042% (65)% 737% 64 Machinery &Equipment 234,000 15,763 - 242,978 22,653 6,890 10% - (91)% Total Supplies, Services, and Capital 21,112,913 6,480,411 5,759,251 5,947,018 5,917,241 (563,170) 28% 3% (1)% Percent of year completed 33.33% i City of Tukwila Allan Ekberg, Mayor INFORMATIONAL MEMORANDUM TO: Mayor Ekberg Finance and Safety Committee FROM: Peggy McCarthy, Finance Director BY: Vicky Carlsen, Deputy Finance Director DATE: June 14, 2017 SUBJECT: First Quarter 2017 Cash & Investment Report ISSUE The first 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 As of March 31, 2017, the portfolio totaled $93.266 million comprised of $78.660 million in cash and cash equivalents and $14.606 million in longer term investments. The portfolio balance decreased by $66 thousand from a December 31, 2016 balance of $93.332 million. Details on individual fund activity is provided below in the Fund Cash & Investment Balances section. In January, the City purchased two agencies of $1 million each. One agency was placed in the general fund and the other was placed in the public safety plan fund. Additionally, in March an agency of $2 million was purchased and placed in the contingency fund. No investments matured or were called during the first quarter of the year. We continue to look for investments where the interest rate exceeds the rate the City receives with US Bank. Portfolio Performance The portfolio weighted average yield on March 31, 2017, was 0.87 %. Considering the portfolio's weighted average maturity was 0.5 years, and the yields on the cash & cash equivalent accounts was 0.69 %, the portfolio yield of 0.87% is still favorable. The total yield has been sustained by the 3.98% average yield on the municipal bond investments, the 1.3% average yield on the agencies, the 1.35% yield on the certificate of deposits, and the 0.45% earnings credit on the US Bank depository account. Investment income received through the end of March 2017 for all investments is $31,002 against an annual budget of $270,809. It should be noted that a significant portion of investment interest is received from agencies and municipal bonds, which is received twice a year rather than monthly. 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 W INFORMATIONAL MEMO Page 2 earned on the operating loan through March 2017 is $3,610. The capital loan is being repaid semi - annually and will be paid in full by December 2022. Interest accrued through March 2017 is $5,215. 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 1St 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 Year over Year Comparison Total fund cash and investments balances are $91.499 million, which is $40.495 million higher than first quarter 2016. The general fund total cash and investment balance is $6.712 million, which is $1.048 million higher than March of 2016. Transfers of $546 thousand from the general fund into capital projects funds for first quarter have not been recorded yet. Rather than transferring funds automatically, we will be transferring funds into the capital projects funds as needed. Special revenue funds all show a year- over -year increase. Over $460 thousand was transferred to the contingency fund from the general fund per the City's minimum fund balance policy. Additionally, the drug seizure fund received almost $539 thousand in seizure funds from the federal government related to the motel seizure that occurred in 2013. In November, voters approved a $77 million bond measure to fund public safety facilities and equipment. The first debt issue occurred in December, increasing fund balance in the capital projects funds group by $36.5 million. Fund 306, city facilities, currently shows a negative balance of $40 thousand. Allocation of the project manager fees, SOJ, for the upcoming Public Works Shops facility have been incurred. A funding source for these costs will be identified and included in the budget amendment process later in the year. Utility funds all have increases in fund balances from the prior year. Investment Environment The Federal Reserve raised interest rates in December 2016 and again in March 2017, signaling rising confidence that the economy is poised for more robust growth. The overnight funds rate is now at 1 % and sets the Feds on a likely path of regular hikes in the future. We have seen interest rates increase in all our short -term investment vehicles. Locally, the economy in King County remains positive. Employment grew by 3.4% in the fourth quarter of 2016 relative to 2015, with continued growth in information jobs. Unemployment rate for King County declined again, down to 3.4% in December 2016. Home prices continue to rise, with a 10.4% increase since fourth quarter 2015. The portfolio will continue to 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 20 INFORMATIONAL MEMO Page 3 Cash and Investment Balances by Fund Treasury Rates and Yield Curves Amortization Schedule — MPD Operating Loan Amortization Schedule — MPD Capital Loan 21 22 CITY OF TUKWILA CASH & INVESTMENT REPORT March 31, 2017 (a) Rating Purchase Maturity Term Agency / Issuer Moodys Investment Type Date Date Yrs CASH & CASH EQUIVALENTS $21,346,654 (e) US Bank Depository Various Washington State Treasurer LGIP Investment Pool Various Opus Bank Public Interest Various (e) 25,002,569 Checking 0.88% Columbia Bank Money market Various Par Value (c) (d) Book Yield to Annualized Balance Maturity Return (e) $21,346,654 $21,346,654 (e) $ 16,949 (e) 1.8 0.45 7,996,812 (e) 18,066,946 18,066,946 (f)&51% 65,188 (b) (e) 25,002,569 25,002,569 0.88% 2,569 (f) te) 14,243,379 14,243,379 0.92% 24,070 (f) Total Cash & Cash Equivalents 78,659,547 78,659,547 0.69% 108,776 INVESTMENTS 1.8 8,000,000 7,996,812 1.30% Certificates of Deposit Taxable Municipal Bonds Bank of Washington Certificate of Deposit 5/2/2016 6/2/2017 1.1 250,000 250,000 0.70% 432 (g) Sound Community Bank Certificate of Deposit 3/4/2017 3/4/2019 2.0 3,000,000 3,208,618 1.40% 6,716 (g) CERTIFICATES OF DEPOSIT - - TOTAL 1.9 3,250,000 3,458,618 1.35% 7,147 Agencies 365,000 370,490 2.85% 10,403 UW Biomedical Center Aal Revenue Bonds 12/14/2010 Farmer Mac US agency 1/23/2017 7/23/2019 2.5 1,000,000 1,000,000 1.40% 14,000 3132XONK3 7/1/2019 8.6 500,000 537,765 4.70% 29,000 Douglas County, ESD, sinking Aal FHLB US agency 1/30/2017 1/30/2019 2.0 1,000,000 1,000,000 1.29% 12,900 3130AAM54 Federal Farm Credit Bank US agency 3/20/2017 9/20/2017 0.5 2,000,000 2,000,000 1.45% 29,000 3133EHCX9 TOTAL MUNICIPAL BONDS 7.4 2,990,000 3,150,530 Federal Home Loan Mtg Corp US agency 1/12/2016 5/26/2017 1.4 1,000,000 1,000,508 0.75% 7,500 3134G6R70 1.88% 236,713 Infcroef an—A from mnfnrorl /rallcrl in— cfmcnte Federal Home Loan Mtg Corp US agency 5/25/2016 5/25/2018 2.0 1,000,000 996,086 0.82% 10,000 3134G9HC4 FHLB US agency 12/27/2016 12/27/2019 10 1,000,000 1,000,203 1.70% 0) 17,000 3133EG2M6 Federal Farm Credit Bank US agency 1/19/2016 12/21/2018 2.9 1,000,000 1,000,015 1.38% 0) 13,750 3133EFSW8 TOTALAGENCIES 1.8 8,000,000 7,996,812 1.30% 104,150 Taxable Municipal Bonds City of Marysville, sinking Aa3 LTGO Refunding 11/23/2010 12/1/2017 5.5 150,000 155,138 3.37% 4,076 2014 -2017, ave 5.5 years Skagit County BAB Aa3 1/12/2016 12/1/2017 0.4 365,000 370,490 2.85% 10,403 UW Biomedical Center Aal Revenue Bonds 12/14/2010 7/1/2017 6.6 500,000 507,915 4.05% 12,203 UW Biomedical Center Aal Revenue Bonds 12/14/2010 7/1/2019 8.6 500,000 537,765 4.70% 29,000 Douglas County, ESD, sinking Aal UTGO 12/23/2010 12/1/2020 8.9 1,135,000 1,221,237 4.55% 54,480 2018 -2020, ave 9 yrs Port of Anacortes Al LTGO 12/17/2010 9/1/2020 9.7 340,000 357,986 5.00% 15,256 TOTAL MUNICIPAL BONDS 7.4 2,990,000 3,150,530 3.98% 125,416 Total Investments 3.1 14,240,000 14,605,961 1.88% 236,713 Infcroef an—A from mnfnrorl /rallcrl in— cfmcnte _ TOTAL CASH, CASH EQUIVALENTS & INVESTMENTS 0.5 $ 92,899,547 $ 93,265,508 1 0.87 % I $ 345,489 Current Portfolio (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. LGIP 19% 23 CITY OF TUKWILA Policy Compliance & Liquidity Analysis CASH & INVESTMENT REPORT March 31, 2017 Liauiditv Reauirements and Funds Available for Investina: Funds immediately available $ 78,659,547 Restrictions & designations: Operating liquidity (a) 14,000,000 Liquidity threshold 14,000,000 Funds available for longer term investing $ 64,659,547 (a) Represents largest one month decline in portfolio balance over the most recent 36 month period doubled; or the equivalent of a 100% cushion. IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII As of Report Date IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII Available Available Available in Portfolio Portfolio Within 1 Year Within 5 5 - 10 Years Liquidity Analysis & Maturity Diversification Amount % of Total Years Funds immediately available $ 78,659,547 $ 78,659,547 $ 78,659,547 Fixed Maturity Investments, maturing in: Yes Washington State Treasurer 18,066,946 0 -90 days after Report Date 1,250,508 Yes Opus Bank 91 -180 days after Report Date 2,507,915 50.0% Yes 181 -270 days after Report Date 525,627 15.3% 50.0% 271 -360 days after Report Date - 3,208,618 3.4% Investments maturing in 1 year or less 4,284,050 4,284,050 4,284,050 Investments maturing in 1 -3 years 8,742,687 Yes 8,742,687 Investments maturing in 3 -5 years 1,579,223 1,579,223 Investments maturing in 5 -7 years - POLICY Investments maturing in 7 -10 years - Amount % of Total Investments maturing in more than 1 year 10,321,911 Depository 21,346,654 and less than 10 years. insured by PDPC Yes State Investment Pool TOTALS $ 93,265,508 $ 82,943,597 $ 93,265,508 $ Money market 39,245,947 89% 100% 0% Investment Policy Parameters POLICY LIMIT PORTFOLIO Policy Met? Funds available within 1 year 30.0% min 89% Yes Funds available within 5 years 80.0% min 100% Yes Funds available in 5- 10 years 20.0% max 0% Yes Liauiditv Reauirements and Funds Available for Investina: Funds immediately available $ 78,659,547 Restrictions & designations: Operating liquidity (a) 14,000,000 Liquidity threshold 14,000,000 Funds available for longer term investing $ 64,659,547 (a) Represents largest one month decline in portfolio balance over the most recent 36 month period doubled; or the equivalent of a 100% cushion. IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII IIIIIIIIIIIII Portfolio POLICY Policy Financial Institution Diversification Amount % of Total MAXIMUM Met? US Bank $ 21,346,654 22.9% 50.0% Yes Washington State Treasurer 18,066,946 19.4% 75.0% Yes Opus Bank 25,002,569 26.8% 50.0% Yes Columbia Bank 14,243,379 15.3% 50.0% Yes Sound Community Bank 3,208,618 3.4% 50.0% Yes Other financial institutions 11,397,342 12.2% 50.0% Yes Total $ 93,265,508 100.0% Portfolio POLICY Policy Investment Mix Amount % of Total MAXIMUM Met? Depository 21,346,654 22.9% insured by PDPC Yes State Investment Pool 18,066,946 19.4% 75.0% Yes Money market 39,245,947 42.1% insured by PDPC Yes Certificate of Deposit 3,458,618 3.7% insured by PDPC Yes US Agency 7,996,812 8.6% 75.0% Yes Municipal Bonds 3,150,530 3.4% no limit specified in policy Yes Total 93,265,508 100.0% Weighted Average Maturites: Years Performance Analysis Certificates of deposit 1.9 Current portfolio yield 0.87% Benchmarks: Municipal bonds 7.4 6 month treasury 0.91% Total Investments 3.1 2 year treasury 1.27% Total Portfolio F 0.5 Local Govt Invst Pool (f) 0.51% 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. 24 INIWKS]a ill :Ah91Ae1 Cash & Investment Balances By Fund and Fund Group CASH & INVESTMENT REPORT March 31, 2017 MOORE Balances Balances Balances Balances 3/31/16 3/31/15 3/31/14 3/31/13 General 000 GENERAL 6,711,536 $ 5,663,247 $ 5,941,116 $ 6,545,525 $ 944,197 General Total 6,711,536 5,663,247 5,941,116 6,545,525 944,197 Special Revenue 101 HOTEUMOTEL TAX 925,984 658,235 452,750 433,781 440,090 105 CONTINGENCY 6,051,878 5,587,107 5,772,086 5,764,212 1,461,267 107 FIRE EQUIP. CUM. RESERVE - - - - 945,312 109 DRUG SEIZURE FUND 544,762 10,257 49,977 68,308 147,083 Special Revenue Total 7,522,624 6,255,599 6,274,813 6,266,301 2,993,751 Debt Service 200 DEBT SERVICE 521,849 378,884 400 - - 206 L.I. GUARANTEE 669,151 669,148 669,147 668,997 208 LIMITED TAX G.O. BONDS 2000 - - - - - 209 LIMITED TAX G.O. BONDS 2003 - 1 1 1 3,012,901 210 LIMITED TAX G.O. REFUNDING 2003 195 195 195 195 (55) 211 LIMITED TAX G.O. REFUNDING 2008 202,891 203,191 416 416 (84) 212 LTGO SCORE BONDS 2 2 2 1,453 126 213 LTGO SCORE BLD AMER BONDS 95,681 - - - 995 214 LTGO 2010 SERIES A 163,821 164,603 2,710 5,910 (614) 215 LTGO 2010 SERIES B - - - - 4,612 216 VALLEY COM REFUNDING BONDS 2010 794 794 794 74 14 217 LIMITED TAX GO BONDS REFUNDING 138,614 137,708 539 214 (299) 218 LTGO 2013 28,283 28,283 - - - 233 LID #33 36,831 108,515 121,290 42,591 - DebtServiceTotal 1,858,112 1,691,324 795,493 719,850 3,017,595 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Capital Project . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . STREET . . . . . . . . . . . . . . . . . . . . . . . .9.1.. . . . 5 9 4 4 815,696 1,119,402 1,365,235 1,045,854 104 ARTERIAL STREET 4,015,837 4,484,245 (56,259) 875,506 588,392 301 LAND ACQ, REC & PARK DEVLPMNT 3,107,439 2,347,596 1,336,048 1,159,087 1,088,513 302 FACILITY REPLACEMENT 419,759 1,174,351 1,037,559 1,967,648 2,103,024 303 GENERAL GOVERNMNT IMPROVEMENTS 363,712 378,675 399,945 404,809 804,988 304 FIRE IMPACT FEES 753,683 560,927 516,235 438,317 359,809 305 PUBLIC SAFETY PLAN -VOTED DEBT 36,467,274 - - - - 306 CITY FACILITIES (39,555) - - - Capital Project Total " .............. ............................... ..............400.............. ............................... 45,683,062 ....................22.,425.... 9,761,490 4,352,930 6,210,602 5,990,581 Enterprise P UTILITY ON ACCT..( overp ay ments.................... (overpayments) Y ) 25,257 16,614 18,491 22,585 401 WATER 7,068,713 6,237,109 5,391,569 5,698,414 5,306,169 402 SEWER 7,700,700 6,862,764 4,937,844 3,431,464 1,917,966 404 WATER /SEWER REVENUE BONDS - - - - - 405 BOND RESERVE - - - - - 411 FOSTER GOLF COURSE 529,214 634,362 671,946 371,314 218,979 412 SURFACE WATER 5,112,620 3,924,594 3,096,696 3,066,715 3,433,716 °,, ,,,,,,,,,,,,,,,,,,,,,,,,,,,,, Enterprise Total 20,433,672 17,684,086 14,114,669 12,586,398 10,899,416 InternalService 501 EQUIPMENT RENTAL 4 883.996 5,175,880 5 036 571 4,482,904 4 398 645 502 INSURANCE 3,366,760 3,799,298 4,764,528 5,491,187 6,559,638 503 INSURANCE - LEOFF 1 1,039,195 973,476 813,557 910,664 1,839,349 Internal Service Total 9,289,951 9,948,653 10, 614, 656 10, 884, 755 12, 797,632 Grand Total 91,498,956 51,004,398 42,093,676 43,213,432 36,643,172 Funds not included in the Grand Total are the fiduciary funds. However, these balances ($1,766,552) are included in the investment balances 25 CITY OF TUKWILA Treasury Rates and Yield Curves CASH & INVESTMENT REPORT March 31, 2017 Ratac at Marr.h '11 gn17 3mo 0.76% 6mo 0.91% 1 Yr 1.03% 2Yr 1.27% 3Yr 1.50% 5Yr 1.93% 10Yr 2.40% 30Yr 3.02% Source: US Department of the Treasury Ratac at Marr.h '11 gn1R Rate Change Change 0.55% 72% 3mo 0.21% 0.52% 57% 6mo 0.39% 0.44% 43% 1Yr 0.59% 0.54% 42% 2Yr 0.73% 0.63% 42% 3Yr 0.87% 0.72% 37% 5Yr 1.21% 0.62% 26% 10Yr 1.78% 0.41% 14% 30Yr 2.61% Comparison of Treasury Rates 26 MPD Operating Loan - through end of 2016 only Period Accumulated Interest (Date) Beg Bal Funding Payments Interest End Bal Interest Principal 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 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/11/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 Prior 12/1/2013 1,050,063.46 10,121.48 1,750.11 1,041,692.08 32,235.02 8,371.37 1,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 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 1/1/2015 940,140.63 10,121.48 1,566.90 931,586.06 53,708.24 8,554.58 1,566.90 2/1/2015 931,586.06 10,121.48 1,552.64 923,017.22 55,260.88 8,568.84 1,552.64 3/1/2015 923,017.22 10,121.48 1,538.36 914,434.10 56,799.24 8,583.12 1,538.36 4/1/2015 914,434.10 10,121.48 1,524.06 905,836.68 58,323.30 8,597.42 1,524.06 5/1/2015 905,836.68 10,121.48 1,509.73 897,224.93 59,833.03 8,611.75 1,509.73 6/1/2015 897,224.93 10,121.48 1,495.37 888,598.82 61,328.40 8,626.11 1,495.37 7/1/2015 888,598.82 10,121.48 1,481.00 879,958.34 62,809.40 8,640.48 1,481.00 8/1/2015 879,958.34 10,121.48 1,466.60 871,303.46 64,276.00 8,654.88 1,466.60 9/1/2015 871,303.46 10,121.48 1,452.17 862,634.15 65,728.17 8,669.31 1,452.17 10/1/2015 862,634.15 10,121.48 1,437.72 853,950.39 67,165.89 8,683.76 1,437.72 11/1/2015 853,950.39 10,121.48 1,423.25 845,252.16 68,589.14 8,698.23 1,423.25 12/1/2015 845,252.16 10,121.48 1,408.75 836,539.44 69,997.90 8,712.73 1,408.75 1/1/2016 836,539.44 10,121.48 1,394.23 827,812.19 71,392.13 8,727.25 1,394.23 2/1/2016 827,812.19 10,121.48 1,379.69 819,070.40 72,771.82 8,741.79 1,379.69 3/1/2016 819,070.40 10,121.48 1,365.12 810,314.03 74,136.93 8,756.36 1,365.12 4/1/2016 810,314.03 10,121.48 1,350.52 801,543.08 75,487.46 8,770.96 1,350.52 5/1/2016 801,543.08 10,121.48 1,335.91 792,757.50 76,823.36 8,785.57 1,335.91 6/1/2016 792,757.50 10,121.48 1,321.26 783,957.28 78,144.62 8,800.22 1,321.26 7/1/2016 783,957.28 10,121.48 1,306.60 775,142.40 79,451.22 8,814.88 1,306.60 8/1/2016 775,142.40 10,121.48 1,291.90 766,312.82 80,743.12 8,829.58 1,291.90 9/1/2016 766,312.82 10,121.48 1,277.19 757,468.53 82,020.31 8,844.29 1,277.19 10/1/2016 757,468.53 10,121.48 1,262.45 748,609.50 83,282.76 8,859.03 1,262.45 11/1/2016 748,609.50 10,121.48 1,247.68 739,735.70 84,530.44 8,873.80 1,247.68 12/1 /2016_ _739,73_5.70 ______- ___10,121.48_ 1,23_2.89 _ 7_30, 847.11_ _85, 763.33_ _ 8 ,888.59_ _1,2_32.89 - -- 1/1/2017 730,847.11 10,121.48 1,218.08 721,943.71 86,981.41 8,903.40 1,218.08 2/1/2017 721,943.71 10,121.48 1,203.24 713,025.47 88,184.65 8,918.24 1,203.24 3/1/2017 713,025.47 10,121.48 1,188.38 704,092.37 89,373.03 8,933.10 1,188.38 4/1/2017 704,092.37 10,121.48 1,173.49 695,144.38 90,546.52 8,947.99 1,173.49 5/1/2017 695,144.38 10,121.48 1,158.57 686,181.47 91,705.09 8,962.91 1,158.57 6/1/2017 686,181.47 10,121.48 1,143.64 677,203.63 92,848.73 8,977.84 1,143.64 current 7/1/2017 677,203.63 10,121.48 1,128.67 668,210.82 93,977.40 8,992.81 1,128.67 8/1/2017 668,210.82 10,121.48 1,113.68 659,203.02 95,091.08 9,007.80 1,113.68 9/1/2017 659,203.02 10,121.48 1,098.67 650,180.21 96,189.75 9,022.81 1,098.67 10/1/2017 650,180.21 10,121.48 1,083.63 641,142.37 97,273.39 9,037.85 1,083.63 11/1/2017 641,142.37 10,121.48 1,068.57 632,089.46 98,341.96 9,052.91 1,068.57 12/1/2017 632,089.46 10,121.48 1,053.48 623,021.46 99,395.44 9,068.00 1,053.48 27 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 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 (8,306.10) 901,009.43 6/1/2014 901,009.43 (48,681.17) 0.02 (7,883.83) 852,328.26 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 _ 1_2/1/2016_ _ 657,176.98 _ (47,200.23) _ _ _ —6. 0.03_ _ _ (9,36_4_.77)_ _ 60_9,976.7_5 6/1/2017 609,976.75 (47,872 0.03 (8,69217) 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) W. Prior Current City of Tukwila Allan Ekberg, Mayor INFORMATIONAL MEMORANDUM TO: Mayor Ekberg Finance Committee FROM: Peggy McCarthy, Finance Director BY: Lily Jue, Fiscal Coordinator DATE: June 20, 2017 SUBJECT: Sales Tax and Miscellaneous Revenue Report - 1St Quarter 2017 Schedule I - Sales Tax in $1,000's First quarter sales tax collections increased by approximately $127K, or 3% when compared with the same period in 2016. There was an increase in construction sales tax of $25K over the same quarter last year, or up by 8% as well as an increase in sales tax from other industries of $102K which resulted in a rise of 3 %. W 2016 Actual 2017 Actual YOY Change Other -- Month Other Total Other Total Construction Industries ! Total Collect- Construc -! ! Construc -i ed Rec'd i Industries i tion tion i Industries i Amount % i Amount % i Amount % Jan Mar $ 99 i $ 1,190 i $ 1,289 $ 123 $ 1,149 i $ 1,272 $ 24 24 %i $ (41) -3 %i $ (17) -1% Feb Apr 97 i 1,231 i 1,328 83 1,123 i 1,206 (14) -14 %i (108) -9 %i (122) -9% Mar May 105 i 1,413 i 1,518 120 1,664 i 1,784 15 14 %i 251 18 %i 266 18% 0 -1 Totals $ 301 i 3,834 i $ 4,135 $ 326 3,936 i $ 4,262 $ 25 8 %i 102 3 %i $ 127 3% Apr Jun 105 i 1,336 i 1,440 i - - May Jul 119 i 1,361 i 1,480 Jun Aug 139 i 1,553 i 1,692 0 -2 Totals $ 362 ! 4,250 ! $ 4,612 $ i $ $ i i $ Jul Sep 109 ! 1,428 ! 1,537 Aug Oct 111 1,438 1,549 Sep Nov 115 1,444 1,559 0 -3 Totals $ 335 ; 4,310 ; $ 4,645 $ $ - $ ; $ - Oct Dec 143 i 1,263 i 1,406 Nov Jan 126 i 1,368 i 1,494 Dec Feb 118 1,852 1,970 0 -4 Totals $ 386 i 4,484 i $ 4,870 $ i $ $ i i $ - Totals $ 1,385 i 16,878 i $ 18,262 $ 326 3,936 i $ 4,262 $ 25 i 102 i $ 127 First quarter sales tax collections increased by approximately $127K, or 3% when compared with the same period in 2016. There was an increase in construction sales tax of $25K over the same quarter last year, or up by 8% as well as an increase in sales tax from other industries of $102K which resulted in a rise of 3 %. W INFORMATIONAL MEMO Page 2 Budget to Actual - Sales Tax in $1,000's Schedule I - Sales Tax Actual revenue from sales tax collections received through the first quarter is less than anticipated by $120K, or (3 %) from budgeted estimates. C:\ Users\ Vicky- C\AppData \Local \Microsoft \Windows \Temporary Internet Files \Content.0utlook \QM7lZ624 \Info Memo Sales Tax - 2017 -Q1 2017MEMO (June 30 2017).docx 2016 2017 Allocated [Actual over (Under) -- Month -- Actual Budget Actual original Collect- ed Rec'd Amt % Jan Mar $ 1,289 $ 1,366 $ 1,272 (94) -7% Feb Apr 1,328 $ 1,407 1,206 (201) -14% Mar May 1,518 $ 1,609 1,784 175 11% Q-1 Totals $ 4,135 $ 4,382 $ 4,262 $ (120) -3% Apr Jun 1,440 $ 1,526 - - May Jul 1,480 $ 1,568 - - - Jun Aug 1,692 $ 1,793 - - - Q-2 Totals $ 4,612 $ 4,887 $ - $ - - Jul Sep 1,537 $ 1,629 - - - Aug Oct 1,549 $ 1,642 - - - Sep Nov 1,559 $ 1,652 - - - Q-3 Totals $ 4,645 $ 4,923 $ - $ - - Oct Dec 1,406 $ 1,490 - - - Nov Jan 1,494 $ 1,583 - - - Dec Feb 1,970 $ 2,089 - - - Q-4 Totals $ 4,870 $ 5,162 $ - $ - - Totals $ 18,262 $ 19,352 $ 4,262 $ (120) Actual revenue from sales tax collections received through the first quarter is less than anticipated by $120K, or (3 %) from budgeted estimates. C:\ Users\ Vicky- C\AppData \Local \Microsoft \Windows \Temporary Internet Files \Content.0utlook \QM7lZ624 \Info Memo Sales Tax - 2017 -Q1 2017MEMO (June 30 2017).docx INFORMATIONAL MEMO Page 3 Below is a graph of sales tax collections by type of industry showing annual change in revenue receipts from 2016 to 2017. Total Construction was up nearly $25K, or 8.3% for first quarter. All three categories of Construction which includes Construction of Buildings, Heavy & Civil Construction, and Specialty Trade Contractors experienced increased sales activity of $13K, $3K, and $81K. Overall Manufacturing is down by $16K, or (24 %) due to a decrease in sales activity for transportation equipment manufacturing compared to 2016. Total Transportation & Warehousing remained fairly stable with a slight increase of 2 %. The overall decline of $53K, or (17 %) in the Wholesale Trade category is mostly attributable to Wholesale Trade in Durable Goods which is down 19% from 2016 to 2017. The Automotive industry had a change of nearly $18K, or up by 10% due primarily to an increase in sales activity in the category for Motor Vehicle & Parts Dealers. The slight decrease of $24K (1 %) in the Retail Trade category is due primarily to lower than normal sales activity being reported in the categories of Furniture & Home Furnishings by $11 K, or (10 %) and in Sporting Goods /Hobby /Books by $15K, or (12 %). The Services industry remains relatively stable with just a slight decrease of $9K, or down by (1 %). The categories for Arts & Entertainment, Other Services and Public Administration show positive changes while categories such as Finance & Insurance and Health Care Social Assistance are down. C:\ Users\ Vicky- C\AppData \Local \Microsoft \Windows \Temporary Internet Files \Content.0utlook \QM7lZ624 \Info Memo Sales Tax - 2017 -Q1 2017MEMO (June 2017).docx 31 INFORMATIONAL MEMO Page 4 The miscellaneous category increased during first quarter due primarily to the annual use tax filings in the Nonclassifiable Establishments related to artwork of $268K, or up by 226 %. Schedule II shows the year -to -date sales tax from the top ten industry classifications. Nonclassifiable Establishments in the NAICS 999 category has the highest year over year increase at $185,886 due to the annual use tax filings for related artwork. This is followed by an increase of $17,959 in the category of Motor Vehicle & Parts Dealer, then Food Services /Drinking Places with an increase of $15,273 and Construction of Buildings with an increase of $13,377 during the first quarter due to overall increases in reported sales activity. Schedule II Schedule III shows the ten largest declines in sales tax revenue for industries collected year -to- date. While the NAICS category for Wholesale Trade & Durable Goods experienced a current quarter decrease in sales tax collections of $53K, the NAICS category 336 Transportation Equipment Manufacturing experienced a 64.5% decrease in sales activity over the previous year. Schedule III YTD YTD Dollar % Group Name Current Prior Diff. Diff. 452 General Merchandise Stores $ 453,426.13 $ 471,695.31 $ (18,269) -3.87% 722 Food Services, Drinking Places $ 436,557.46 $ 421,284.20 $ 15,273 3.63% 448 Clothing and Accessories $ 420,320.93 $ 431,108.89 $ (10,788) -2.50% 443 Electronics and Appliances $ 270,983.92 $ 262,019.04 $ 8,965 3.42% 999 Nonclassifiable Establishments $ 268,239.78 $ 82,353.47 $ 185,886 225.72% 423 Wholesale Trade, Durable Goods $ 218,915.59 $ 271,608.40 $ (52,693) - 19.40% 236 Construction of Buildings $ 184,265.70 $ 170,888.91 $ 13,377 7.83% 441 Motor Vehicle and Parts Dealer $ 171,775.13 $ 153,815.64 $ 17,959 11.68% 453 Miscellaneous Store Retailers $ 167,656.65 $ 165,225.23 $ 2,431 1.47% 444 Building Material and Garden $ 160,412.38 $ 152,805.31 $ 7,607 4.98% Schedule III shows the ten largest declines in sales tax revenue for industries collected year -to- date. While the NAICS category for Wholesale Trade & Durable Goods experienced a current quarter decrease in sales tax collections of $53K, the NAICS category 336 Transportation Equipment Manufacturing experienced a 64.5% decrease in sales activity over the previous year. Schedule III C:\ Users\ Vicky- C\AppData \Local \Microsoft \Windows \Temporary Internet Files \Content.0utlook \QM7lZ624 \Info Memo Sales Tax - 2017 -Q1 2017MEMO (June 32 2017).docx YTD YTD Dollar % Group Name Current Prior Diff. Diff. 423 Wholesale Trade, Durable Goods $ 218,915.59 $ 271,608.40 $ (52,693) - 19.40% 621 Ambulatory Health Care Service $ 35,450.86 $ 70,597.62 $ (35,147) - 49.78% 452 General Merchandise Stores $ 453,426.13 $ 471,695.31 $ (18,269) -3.87% 522 Credit Intermediation $ 20,037.95 $ 36,967.36 $ (16,929) - 45.80% 336 Transportation Equipment Man $ 8,895.44 $ 25,058.17 $ (16,163) - 64.50% 451 Sporting Goods, Hobby, Books $ 109,224.59 $ 124,272.18 $ (15,048) - 12.11% 442 Furniture and Home Furnishings $ 106,162.58 $ 117,530.31 $ (11,368) -9.67% 448 Clothing and Accessories $ 420,320.93 $ 431,108.89 $ (10,788) -2.50% 721 Accommodation $ 135,146.78 $ 141, 387.59 $ (6,241) -4.41% 531 Real Estate $ 8,762.37 $ 11,702.53 $ (2,940) - 25.12% C:\ Users\ Vicky- C\AppData \Local \Microsoft \Windows \Temporary Internet Files \Content.0utlook \QM7lZ624 \Info Memo Sales Tax - 2017 -Q1 2017MEMO (June 32 2017).docx INFORMATIONAL MEMO Page 5 The following charts show sales tax receipts the City collected from major industries from 2010 through first quarter of the current year. These categories include retail, services, wholesale, construction, and other consisting of manufacturing, transportation & warehousing, automotive, and miscellaneous. C:\ Users\ Vicky- C\AppData \Local \Microsoft \Windows \Temporary Internet Files \Content.0utlook \QM7lZ624 \Info Memo Sales Tax - 2017 -Q1 2017MEMO (June 2017).docx 33 INFORMATIONAL MEMO Page 7 Retail Services Construction Other -Mfg. Trnsp /Wrhsng, Automotive, & Misc. C:\ Users\ Vicky- C\AppData \Local \Microsoft \Windows \Temporary Internet Files \Content.0utlook \QM7lZ624 \Info Memo Sales Tax - 2017 -Q1 2017MEMO (June 34 2017).docx INFORMATIONAL MEMO Page 6 Below is Schedule IV which shows quarterly gambling tax earned in 2017 compared to 2016. Schedule IV - Gambling Tax (a) (d) 2017 INCREASE (DECREASE) Quarter 2016 2017 Allocated YEAR OVER YEAR BUDGET VARIANCE Earned Actual Actual Budget Amount % Amount % Q1 $ 950,379 $ 977,003 $ 989,745 $ 26,624 3% $ (12, 742) -1% Q2 867,047 - 902,961 - - - - Q3 927,316 - 965,727 - - - - Q4 934,269 - 972,968 - - - - Totals $ 3,679,011 $ 977,003 $ 3,831,400 $ 26,624 - $ (12,742) - Gambling tax revenue during first quarter 2017 came in below the allocated budget estimate by $12.7K, or down 1 %. However, gambling tax revenue was also nearly $27K, or 3% higher than 2016. Casinos within the City continue to do well. Schedule V shows monthly admissions tax receipts for the prior year and current year to date. Schedule V - Admissions Tax (b) (d) 2017 INCREASE (DECREASE) Quarter 2016 2017 Allocated YEAR OVER YEAR BUDGET VARIANCE Earned Actual Actual Budget Amount % Amount % Q1 $ 161,269 $ 166,003 $ 178,187 $ 4,734 3% $ (12,183) -7% Q2 156,588 - 173,014 - - - - Q3 157,862 - 174,422 - - - - Q4 157,821 - 174,377 - - - - Totals $ 633,640 $ 166,003 $ 700,000 $ 4,734 - $ (12,183) - While first quarter 2017 admissions tax revenue received was $12K, or 7% less than budgeted projections, revenue was nearly $5K, or 3% higher than 2016. Schedule VI shows monthly telecommunications utility tax receipts for 2017 compared to 2016. Schedule VI - Telecommunications Utility Tax (°) (d) 2017 INCREASE (DECREASE) Quarter 2016 2017 Allocated YEAR OVER YEAR BUDGET VARIANCE Earned Actual Actual Budget Amount % Amount Q1 $ 348,156 $ 323,708 $ 339,620 $ (24,448) -7% $ (15, 912) -5% Q2 321,852 - 313,961 - - - - Q3 317,156 - 309,380 - - - - Q4 343,515 - 335,093 - - - - Totals $ 1,330,679 $ 323,708 $1,298,063 $ (24,448) - $ (16,912) - Current first quarter 2017 telecommunications utility tax is down by $15K, or 5% under budget and is $24K, or 7% less than 2016 actual for the same period last year. (a) Gambling tax currently includes card games, punch boards, pull tabs, and amusement games. (b) Excludes golf course admissions tax. (0) Telecommunications Utility tax currently includes cellular, pager and telephone usage. (d) Actuals reflected in Schedules IV, V and VI are amounts earned for the quarter. C:\ Users\ Vicky- C\AppData \Local \Microsoft \Windows \Temporary Internet Files \Content.0utlook \QM7lZ624 \Info Memo Sales Tax - 2017 -Q1 2017MEMO (June 2017).docx 35 36 NAICS CONSTRUCTION 16 TOTAL 236 Construction of Buildings 760,913 237 Heavy & Civil Construction 81,491 238 Specialty Trade Contractors 541,481 TOTAL CONSTRUCTION $ 1,383,885 $ Overall Construction Change from Previous Year MANUFACTURING 311 Food Manufacturing 312 Beverage & Tobacco Products 313 Textile Mills 314 Textile Product Mills 315 Apparel Manufacturing 316 Leather & Allied Products 321 Wood Product Manufacturing 322 Paper Manufacturing 323 Printing & Related Support 324 Petroleum & Coal Products 325 Chemical Manufacturing 326 Plastic & Rubber Products 327 Nonmetallic Mineral Products 331 Primary Metal Manufacturing 332 Fabricated Metal Mfg Products 333 Machinery Manufacturing 334 Computer & Electronic Products 335 Electric Equipment, Appliances 336 Transportation Equipment Mfg 337 Fumiture & Related Products 339 Miscellaneous Manufacturing TOTAL MANUFACTURING 16 TOTAL 9,420 5,216 222 11,406 1,024 54 3,305 27,243 28,714 19 -22 6,454 3,615 2,008 10,978 10,914 5,490 2,588 115,102 5,357 19,806 $ 268,912 $ 16 YTD 170,889 12,590 117,654 `. 301,132 $ Overall Manufacturing Change from Previous Year TRANSPORTATION & WAREHOUSING 16 TOTAL 481 Air Transportation 482 Rail Transportation 484 Truck Transportation 485 Transit and Ground Passengers 487 Scenic and Sightseeing Tran 488 Transportation Support 491 Postal Services 492 Couriers & Messengers 493 Warehousing & Storage TOTAL TRANSP & WHSING $ 0 44 2,679 664 2,058 48,851 811 2,139 1,430 58,677 $ Overall Transportation Change from Previous Year WHOLESALE TRADE 16 TOTAL 423 Whls Trade - Durable Goods 1,133,269 424 Whis Trade - Nondurable Goods 157,297 425 Wh€tiesale Electronic Markets 2,988 WHOLESALE TRADE TOTAL $ 1,293,553 $ Overall Wholesale Change from Previous Year (✓19/7017 16 YTD 1,753 1,838 4 2,695;' 344 7 513 8,250 7,547 5 2,522 668, 473 547 1,943 8,679 666 505 25,058 1,098 3,610 68,725 17 YTD 184,266 15,774 126,043 326,082 $24,950 17 YTD 1,932 4,477, 130 3.579 242 8 478 6,276' 6.539. 4 1.494 $" .093 726 266 3,840 1,491 2,955 2,796 8,895 1,315 3,802 52,338 ($16,387) 16 YTD 0 5 475 102 50 13,180 204 697 310 15,024 r��v.1 sv% ��our ■r+I a ■ \ \\ \ 7 Received Sn March`20 7 - r YTD % DIff 7.8% 25.3% 7.1% 8.3% YTD % Diff 10.2% 143.5% 3312.1% 32.8% -29.7% 16.2% -6.8% - 23.9% - 13.4% -21.3% -40.8% 63.7% 53.5% -51.5% 97.6% - 82.8% 343.8% 453.3% -64.5% 19.8% 5.3% -23.8% YTD 17 YTD % DIff 1 0.0% 94 1762.3% 379 -20.3% 53 - 48.3% 15 - 70.3% 13,822 4.9% 226. 10.8% 361 - 48.2% 396 27.7% 15,356 5333 ' 2.2% YTD 16 YTD 17 YTD' % Dlff 271,608 218,916 -19.4% 36,961 36,756° -0.6% 528 624 18.0% 309,098 $ 256,295 (552,802) •17.1% NAICS AUTOMOTIVE 16 TOTAL 4.41 Motor Vehicle & Parts Dealer 654,979 447 Gasoline Stations 88,489 TOTAL AUTOMOTIVE $ 743,468 $ Overall Automotive Change from Previous Year NAICS RETAIL TRADE 16 TOTAL 442 Fumiture & Home Fumishings 475,117 443 Electronics & Appliances 1,180,563 444 Building Material & Garden 734,035 445 Food & Beverage Stores 236,578 446 Health & Personal Care 306,528 448 Clothing & Accessories 2,089,128 451 Sporting Goods, Hobby, Books 573,709 452 General Merchandise Stores 2,202,158 453 Miscellaneous Store Retailers 728,706 454 Nonstore Retailers 156,153 TOTAL RETAIL TRADE $ 8,682,675 $ Overall General Retail Change from Previous Year SERVICES 16 TOTAL 51X Information 857,972 52X Finance & Insurance 117,680 53X Real Estate, Rental, Leasing 656,465 541 Professional, Scientific, Tech 586,578 551 Company Management 5 56X Admin, Supp, Remed Svcs 153,702 611 Educational Services 11,320 62X Health Care Social Assistance 325,504 71X Arts & Entertainment 245,035 72X Accommodation & Food Svcs 2,401,994 81X Other Services 212,841 92X Public Administration 68,626 TOTAL SERVICES $ 5,637,723 $ Overall Services Change from Previous Year 16 YTD 153,816 20,693 174,509 -$ 16 YTD 117,530 262,019 152,805 45,822 69,317 431,109 124,272 471,695 165,225 33,044 17 YTD' 171,775 20,418 192,193 517,684 17 YTD 106,163 270,984 160,412 54,826 68,845 420,321 109,225 453,426 167,657 37,196' YTD % Dtff 11.7% -1.3% 10.1% % Diff -9.7% 3.4% 5.0% 19.6% -0.7% -2.5% -12.1% -3.9% 1.5% 12.6% 1,872,840 -$ 1,849,054 (523,786) 16YTD 17YTD 193,289 198,161 2.5% 38,893 21,670 -44.3% 169,617 166,026 -2.1% 111,142 ! 114,071 2.6% 3 0 0.0% 32,569 36,930 13.4% 1,750 1,508 -13.9% 77,609 43,895 -43.4% 53,646 64,720 20.6% 562,672 571,704 1.6% 52,455 62,636 19.4% 17,984 20,925! 16.4% 1,311,628 $ 1,302,246 (59,382) -0.7% -1.3% YTD % Diff MISCELLANEOUS 16 TOTAL 16 YTD 000 Unknown 0 111 -115 Agriculture, Forestry, Fishing 514 211 -221 Mining & Utilities 68 999 Unclassifiable Establishments 193,069 MISCELLANEOUS TOTAL $ 193,651 $ Overall Miscellaneous Change from Previous Year 125 104 82,353 82,582 $ 16 TOTAL 16 YTD 17 YTD 0 80 86 268,240 268,406 5185,824 17 YTD YTD % DlH 0.0% -35.9% -17.0% 225.7% 225.0% YTD % Dtff GRAND TOTALS $184: 135 Grand Total Change from Previous Year 5126,433 3.06% Grand Total Change from Previous Year • Without New Construction 5101,483 2.65% 1 W.*