HomeMy WebLinkAboutFS 2010-10-05 Item 2D - Report - Sales Tax Revenue for July 2010 4`P.1- City of Tukwila
a Jim Haggerton, Mayor
4 INFORMATIONAL MEMORANDUM
TO: Mayor Haggerton
Finance and Safety Committee
FROM: Shawn Hunstock, Finance Director
DATE: September 28, 2010
SUBJECT: Sales Tax Revenue for July 2010
Schedule 1 in 1,000's
Sales Receipt 2009 2010 2010 Increase /(Decrease) %Increase /(Decrease)
Month Month Actual Estimated Actual Month YTD Month YTD
Jan Mar 1,172 1,483 1,036 (447) (447) 30.14% 0.00%
Feb Apr 1,051 1,462 1,006 (456) (903) 31.19% 30.66%
Mar May 1,146 1,705 1,157 (548) (1,451) 32.14% 31.20%
Apr June 1,191 1,578 1,070 (508) (1,959) 32.19% 31.45%
May July 1,082 1,603 1,067 (536) (2,495) 33.44% 31.86%
June Aug 1,217 1,812 1,247 (565) (3,060) 31.18% 31.73%
July Sept 1,473 1,793 1,251 (542) (3,602) 30.23% 31.50%
Aug Oct 1,118 1,656 (1,656) (5,258) 100.00% 40.16%
Sept Nov 1,110 1,682 (1,682) (6,940) 100.00% 46.97%
Oct Dec 1,032 1,556 (1,556) (8,496) 100.00% 52.03%
Nov Jan11 1,140 1,631 (1,631) (10,127) 100.00% 56.38%
Dec Feb11 1,690 2,270 (2,270) (12,397) 100.00% 61.28%
Totals 14,422 20,231 7,834
Mitigation Received 934
8,768 76.67% of Budget Intl Mitigation
Sales tax collections for July showed the fifth decline this year through seven months of
collections. For July, collections were less than budget and the same month in the previous
year. Actual receipts for July were $542,000 less than budget, and $222,000 less than the same
period last year. We are down 30.23% for the month compared to budget, and down by 17.75%
compared to the same month last year. We are now down in total 31.50% for the year
compared to budget, and down by 5.99% compared to the same period last year.
The chart above also includes the mitigation payment we will receive at the end of September.
Including the mitigation payments, we are currently at 76.67% of budget for the year to date.
The latest mitigation payment we will receive will be on September 30, 2010 and will be for
$310,763.48. This will be the same amount as the last mitigation payment received on March
31 because the payments are now annualized and will only be adjusted once per year in the
fall. The next mitigation payment will be received on December 31S Staff completed work on
the last mitigation detail file and submitted to the Department of Revenue a list of firms that
121
INFORMATIONAL MEMO
Page 2
should be removed from the mitigation calculation process. These firms are ones that were
offsetting other losses, thereby reducing our mitigation payment.
Schedule II shows the year -to -date sales tax from the top ten industry classifications. As this
schedule indicates, the trend is flat or down for most of the classifications.
Schedule II
YTD YTD Dollar
Group Name Current Prior Diff. Diff.
452* General Merchandise Stores 1,090,141 $1,088,903 1,238 0.11%
448* Clothing and Accessories 1,046,886 1,074,615 (27,729) 2.58%
722* Food Services, Drinking Places 772,301 750,775 21,526 2.87%
423* Wholesale Trade, Durable Goods 724,319 921,221 (196,902) -21 37%
443* Electronics and Appliances 500,894 516,126 (15,232) 2.95%
441* Motor Vehicle and Parts Dealer 351,354 430,464 (79,110) 18.38%
451* Sporting Goods, Hobby, Books 341,932 309,294 32,637 10.55%
444* Building Material and Garden 302,181 301,956 225 0.07%
236 Construction of Buildings 301,328 327,348 (26,020) 7.95%
453* Miscellaneous Store Retailers 257,328 286,370 (29,041) 10.14%
Mitigated NAICS Code
As you can see there are large variances from last year for the same time period. For instance,
sales tax for Wholesale Trade and Durable Goods is down by 21.37 and Motor Vehicle and
Parts Dealer is down by 18.38 As you can see from Schedule II, six of the top ten merchant
categories have declined versus prior year, and all but one of the ten industry classification
codes are ones for which we receive streamlined sales tax mitigation.
Schedule III shows the ten largest declines in sales tax revenue for industries with over $10,000
collected year -to -date.
Schedule III
YTD YTD Dollar
Group Name Current Prior Diff. Diff.
237 Heavy and Civil Construction 12,938 44,397 (31,459) 70.86%
454* Nonstore Retailers 56,045 157,595 (101,551) 64.44%
238 Specialty Trade Contractors 143,400 221,050 (77,650) 35.13%
621 Ambulatory Health Care Service 24,998 34,160 (9,162) 26.82%
323* Printing and Related Support 28,073 37,110 (9,037) 24.35%
423* Wholesale Trade, Durable Goods 724,319 921,221 (196,902) 21.37%
441* Motor Vehicle and Parts Dealer 351,354 430,464 (79,110) 18.38%
561 Administrative and Support Svc 59,243 72,063 (12,820) 17.79%
721* Accommodation 240,443 275,998 (35,555) 12.88%
812 Personal and Laundry Services 47,657 54,359 (6,703) 12.33%
Mitigated NAICS Code
Attached is a Sales Tax Summary comparing year -to -date 2010 vs. 2009 by major NAICS
codes. Also included is a comparison of total receipts year -to -date for the last five years.
Please let me know if you have any comments or questions. Thank you.
W:IFIN Projects\Sales Tax Information\Sales Tax Files from Shawn120101Info Memo Sales Tax 092710.docx
122
i SALES TAX SUMMARY 1
July 2010 (Received in September)
YID YTD
NAICS CONSTRUCTION 09 TOTAL 09 YTD 10 YTD %Diff NAICS AUTOMOTIVE 09 TOTAL 09 YTD 10 YTD Diff
236 Construction of Buildings 416,992 327,348 301,328 -7.9% 1 441* Motor Vehicle Parts Dealer 686,478 430,464 351,354 -18.4%
237 Heavy Civil Construction 98,105 44,397 12,938 70,954 1 447' Gasoline Stations 62,584 35,920 38,200 6.3% I
238 Specialty Trade Contractors 347,910 221,050 143,400 -35.1% TOTAL AUTOMOTIVE 749,063 466,384 389,555
TOTAL CONSTRUCTION 863,006 592,795 457,666 Overall Automotive Change from Previous Year ($76,829) -16.5%
Overall Construction Change from Previous Year ($135,128) -22.8%
NAICS RETAIL TRADE 09 TOTAL 09 YTD 10 YTD Diff
YTD 442' Furniture Home Fumishings 350,625 194,471 212,305 9,2%
MANUFACTURING 09 TOTAL 09 YTD 10 YTO Diff 443' Electronics Appliances 954,375 516,126 500,894 -3.0
311 Food Manufacturing 1,173 744 1,639 120.2% 444" Building Material Garden 506,177 301,956 302,181 0.1
312 Beverage Tobacco Products 3,070 1,705 -2,604 252.8% 445* Food Si Beverage Stores 86,349 49,432 43,894 -11.2
313 Textile Mills 259 155 24 -84.2% 446' Health Personal Care 189,603 105,664 96,788 -8.4%
314 Textile Product Mills 12,852 7,932 9,086 14.6% 448' Clothing Accessories 2,015,184 1,074,615 1,046.886 -2.6
315 Apparel Manufacturing 59 37 15 -59.6% 451* Sporting Goods, Hobby, Books 589,522 309,294 341,932 10.6%
316 Leather Allied Products 7 4 1 -64.5% 452" General Merchandise Stores 2,044,042 1,088,903 1,090,141 0.1% I
321' Wood Product Manufacturing 2.701 1,971 933 -52.6% j 453* Miscellaneous Store Retailers 506,005 286,370 257,328 -10.1
322" Paper Manufacturing 20,392 11,303 12.545 11.0% 1 454" Nonstore Retailers 209,564 157,595 56,045 -64.4% f
323* Printing Related Support 59.298 37,110 28,073 -24.4% 1 TOTAL RETAIL TRADE 7,451,446 4,084,425 3,948,392
324 Petroleum Coal Products 8,157 2,802 1,990 -29.0% Overall General Retail Change from Previous Year ($136,032) 3.3%
325 Chemical Manufacturing 6,368 3,741 4,155 11.1%
326 Plastic Rubber Products 3,928 2,110 1,745 -17.3% YTD
327" Nonmetallic Mineral Products 2.279 1,172 670 -42.9% 1 SERVICES 09 TOTAL 09 YTD 10 YTD Diff
331 Primary Metal Manufacturing 534 101 195 93.3% 51X Information 528,044 310,785 317,172 2.1
332 Fabricated Metal Mfg Products 3,789 1,844 4,065 120.4% 52X Finance Insurance 53,850 24,286 26,535 9.3%
333 Machinery Manufacturing 5,586 1,969 7.042 257.7% 53X Real Estate, Rental, Leasing 412,907 208,540 209,747 0.6%
334" Computer Electronic Products 19,797 11,216 2,436 -78.3% I 541 Professional, Scientific, Tech 227,255 98,787 92,981 -5.9%
335 Electric Equipment, Appliances 137 90 119 32.3 551 Company Management 985 727 209 -71.2%
336 Transportation Equipment Mfg 135.430 80,383 79,344 -1.3% 56X Admin, Supp, Remed Svcs 123,115 76,207 61,763 -19.0%
337" Fumiture Related Products 8,575 5,802 6,006 3.5%
611 Educational Services 47,324 22,370 35,299 57.8%
339' Miscellaneous Manufacturing 10,665 7,417 6,494 -12.5% f 62X Health Care Social Assistance 91,637 46,166 38,980 -15.6%
TOTAL MANUFACTURING 305,059 179,606 163,973 71X Arts Entertainment 93,799 54,573 66,553 22.0%
Overall Manufacturing Change from Previous Year (615,633) -8.7% 1 72X" Accommodation Food Svcs 1,745,512 1,026,773 1,012,744 -1.4%
81X Other Services 183,887 106,326 106,337 0.0%
YID 92X Public Administration 32,268 13,589 15,582 14.7
TRANSPORTATION WAREHOUSING 09 TOTAL 09 YTD 10 YTD Diff TOTAL SERVICES 3,540,583 1,989,130 1,983,903
481 Air Transportation 0 0 0 0.0% Overall Services Change from Previous Year ($5,227) -0.3%
482 Rail Transportation 924 833 246 -70.4%
484 Truck Transportation 3,294 1,412 137 -90.3%
485 Transit and Ground Passengers 11,105 6,700 11,175 66.8% YTD
488 Transportation Support 21,879 13,888 9,608 -30.8% MISCELLANEOUS 09 TOTAL 09 YTD 10 YTD Diff
491 Postal Services 0 0 0 itDIV/01 000 Unknown 397 397 1 -99.7%
492 Couriers Messengers 149 32 208 547.2% 111-115 Agriculture, Forestry, Fishing 221 80 190 138.1%
1 493' Warehousing Storage 1,051 714 583 -18.4% j 211 -221 Mining Utilities 14,549 8,922 9,068 1.6%
TOTAL TRANSP WHSING 38,401 23,580 21,958 999 Unclassifiable Establishments 12,331 2,447 76,146 3011.7
Overall Transportation Change from Previous Year ($1,622) -6.9% MISCELLANEOUS TOTAL 27,499 11,846 85,405
Overall Miscellaneous Change from Previous Year 673,559 621.0%
YTD
WHOLESALE TRADE 09 TOTAL 09 YTD 10 YTD 1 Diff
I 423" Wills Trade Durable Goods 1,339,565 921,221 724,319 -21.4% 1 YTD
I 424' Whls Trade Nondurable Goods 105,260 62.706 57,012 -9.1% 1 09 TOTAL 09 YTD 10 YTD Diff
425* Wholesale Electronic Markets 2,208 1,177 1,437 22.1% 1 GRAND TOTALS $14,422,090 $8,332,869 $7,833,621
WHOLESALE TRADE TOTAL 1,447,033 985,103 782,768 Grand Total Change from Previous Year (6499,248) -5.99%
Overall Wholesale Change from Previous Year ($202,335) -20.5%
I Sales Tax Mitigation NAICS Codes 1
IV
CA) W /28/2010 Page 1 IUK Soles lox Rp1201007.xIsre
Five Year Comparison
2010
2009 I e
fa �a .e m ®ffp i
j vi'.'� 4 7,.,,rt tit 1 e` '5, t
2008
w r i, r -7 -'1 .7 £'.tn r r
0 ,743,680 j d
2007 I $1
.y i i� a�`�', t` r" i �i' r4 11, 1
2006 6, i
0
$2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000
Taxes Collected Year to Date
124