HomeMy WebLinkAboutFS 2011-02-08 Item 2B - Report - November 2010 Sales Tax Revenue Report 1 -y City of Tukwila
Jim Haggerton, Mayor
INFORMATIONAL MEMORANDUM
TO: Mayor Haggerton
Finance and Safety Committee
FROM: Shawn Hunstock, Finance Director
DATE: January 24, 2011
SUBJECT: Sales Tax Revenue for November 2010
Schedule I in 1,000's
Sales Receipt 2009 2010 2010 Increase /(Decrease) Increase /(Decrease)
Month Month Actual. Estimated Actual Month YTD Month YTD
Jan Mar 1,172 1,483 1,036 (447) (447) 30.14% 0.00%
Feb Apr 1,051 1,462 1,006 (456) (903) 31.19% 30.66%
Mar May 1,146 1,705 1,157 (548) (1,451) 32.14% 31.20%
Apr June 1,191 1,578 1,070 (508) (1,959) 32.19% 31.45%
May July 1,082 1,603 1,067 (536) (2,495) 33.44% 31.86%
June Aug 1,217 1,812 1,247 (565) (3,060) 31.18% 31.73%
July Sept 1,473 1,793 1,251 (542) (3,602) 30.23% 31.50%
Aug Oct 1,118 1,656 1,216 (440) (4,042) 26.57% 30.87%
Sept Nov 1,110 1,682 1,357 (325) (4,367) 19.32% 29.56%
Oct Dec 1,032 1,556 1,082 (474) (4,841) 30.46% 29.64%
Nov Jan11 1,140 1,631 1,202 (429) (5,270) 26.30% 29.34%
Dec Feb11 1,690 2,270 (2,270) (7,540) 100.00% 37.27%
Totals 14,422 20,231 12,691
Mitigation Received 1,242
13,933 77.57% of Budget Incl. Mitigation
Sales tax collections for November showed the fourth consecutive increase, and sixth so far this
year, as compared to the same month in the prior year. For November, collections were less
than budget for the month, but more than actual collections in the same month in the previous
year. Actual receipts for November were $426,000 less than budget, but $62,000 more than the
same period last year. We are down 26.3% for the month compared to budget, but up by 5.44%
compared to the same month last year. We are now down in total 29.34% for the year
compared to budget, and down by 0.32% compared to the same period last year.
Including mitigation payments, we are currently at 77.57% of budget for the year to date. This
includes a mitigation payment of $308,257.11 received on December 31, 2010. The last
mitigation payment we received was on September 30, 2010 for $310,763.48. Mitigation
payments are now annualized and will only be adjusted once per year in the fall, effective with
the December 31 payment. Staff completed work on the last mitigation detail file and submitted
to the Department of Revenue a list of firms that should be removed from the mitigation
73
INFORMATIONAL MEMO
Page 2
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,789,872 $1,763,485 26,387 1.50%
448* Clothing and Accessories 1,737,169 1,733,349 3,820 0.22%
722* Food Services, Drinking Places 1,216,267 1,174,027 42,240 3.60%
423* Wholesale Trade, Durable Goods 1,099,914 1,185,088 (85,174) 7.19%
443* Electronics and Appliances 831,909 824,186 7,723 0.94%
441* Motor Vehicle and Parts Dealer 546,879. 633,512 (86,633) 13.68%
451* Sporting Goods, Hobby, Books 543,691 498,173 45,519 9.14%
236 Construction of Buildings 502,625 386,100 116,525 30.18%
444* Building Material and Garden 464,759 470,491 (5,732) 1.22%
453* Miscellaneous Store Retailers 419,502 443,886 (24,384) 5.49%
Mitigated NAICS Code
As you can see there are large variances from last year for the same time period. For instance,
sales tax for Motor Vehicle and Parts Dealer is down by 13.68 and Wholesale Trade and
Durable Goods is down by 7.19 As illustrated above, four of the top ten merchant categories
have declined versus prior year, and all but one of the ten industry classification codes are ones
for which we receive streamlined sales tax mitigation.
Schedule III shows the ten largest declines in sales tax revenue for industries with over $10,000
collected year -to -date.
Schedule III
YTD YTD Dollar
Group Name Current Prior Diff. Diff.
'454 Nonstore Retailers 95,397 188,523 (93,126) 49.40%
'441 Motor Vehicle and Parts Dealer 546,879 633,512 (86,633) 13.68%
'423 Wholesale Trade, Durable Goods 1,099,914 1,185,088 (85,174) 7.19%
'237 Heavy and Civil Construction 28,348 84,860 (56,512) 66.59%
'238 Specialty Trade Contractors 261,572 312,544 (50,972) 16.31%
'531 Real Estate 36,457 64,730 (28,273) 43.68%
x 721 Accommodation 397,682 423,389 (25,707) -6.07%
'453 Miscellaneous Store Retailers 419,502 443,886 (24,384) 5.49%
'621 Ambulatory Health Care Service 41,822 57,518 (15,696) 27.29%
'812 Personal and Laundry Services 75,129 85,546 (10,417) 12.18%
Mitigated NAICS Code
Attached is a Sales Tax Summary comparing year -to -date 2010 vs. 2009 by major NAICS
codes. Also included is a comparison of total receipts year -to -date for the last five years.
Please let me know if you have any comments or questions. Thank you.
W:1FIN Projects\Sales Tax Information\Sales Tax Files from Shawn1201011nfo Memo Sales Tax 01242011.docx
74
u S I qq
d d s s A F 7T Or d r
SALES TAX SUMMARY F g u.J t 'r i y kp Y 4 i.G9F Z`: g m X N
y No 2Qi0 (fRecenredZrn,/antra 2Q11 r
YTD 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 386,100 ;502,625 30.2% I 441' Motor Vehicle Parts Dealer 686.478 633,512 546,879 -13,7% I
237 Heavy Civil Construction 98,105 84,860. 28;348. -66.6% 1 447' Gasoline Stations 62,584 57,168 61,977 8.4% 1
238 Specialty Trade Contractors 347,910 312,544 :261,572 •16.3% TOTAL AUTOMOTIVE 149,063 690,680 608,856
TOTAL CONSTRUCTION 863,006 783,504 .;f.::'._t:::; 792,545 Overall Automotive Change from Previous Year .(581,824) -11.8%
Overall Construction Change from Previous Year '19,041:. 1,1%
NAICS RETAIL TRADE 09 TOTAL 09 YTD 10 YTD Diff
YTD 442' Fumiture Home Furnishings 350,625 311.667 337.234 8.2% 1
MANUFACTURING 09 TOTAL 09 YTD 10 YTD Diff 443' Electronics Appliances 954,375 624,186 831.909 0.9% 1
311 Food Manufacturing 1,173 1,055';': '5,199 393.0% 444' Building Material Garden 506,177 470,491 464,759' -1,2%
312 Beverage Tobacco Products 3,070 2,725 •1,351 149.6% 445' Food Beverage Stores 86,349 79,253 90,734 14.5%
313 Textile Mills 259 207 55 -58.7% 446' Health Personal Care 189,603 161,952 153,632 -5.1
314 Textile Product Mills 12,852 11,615 12,881: 10.9% 448' Clothing Accessories 2.015.164 1,733.349 1.737,169 0.2%
315 Apparel Manufacturing 59 46 -20' -56.5% 451' Sporting Goods, Hobby, Books 589.522 498.173 543.691 9.1% 1
316 Leather Allied Products 7 4 2' -52.0% 452' General Merchandise Stores 2.044,042 1,763,485 1.789,872 1.5% I
321" Wood Product Manufacturing 2,701 2,555 1,468' -42.5% 1 453' Miscellaneous Store Retailers 506,005 443,886 419,502 -5.5% J
322' Paper Manufacturing 20,392 18,239 :19,661 7.8% 1 454' Nonstore Retailers 209,564 188,523 95,397 -49.4% 1
323' Printing Related Support 59,298 53,293 48,974 -8.1% I TOTAL RETAIL TRADE 7,451,446 6,474,964 6,463,899.
324 Petroleum Coal Products 8,157 7141<:;. '2,848 -60.1% Overall General Retail Change from Previous Year (311,065) •0,1%
325 Chemical Manufacturing 6,368 5,848 '''i 6,810' 16.5%
326 Plastic Rubber Products 3,928 3,794 "'2,914: 23.2% YTD
327' Nonmetallic Mineral Products 2,279 2,119 ":",i 2:496 17.8% 1 SERVICES 09 TOTAL 09 YTD 10 YTD Diff
331 Primary Metal Manufacturing 534 529 +:'.;i::. i::: •718 35.6% 51X Information 528,044 471,858 475,844 0.8%
332 Fabricated Metal Mfg Products 3,789 3,215. 1 2,911 190.6% 52X Finance Insurance 53,850 48,228 47,305 -1.9%
333 Machinery Manufacturing 5,586 5,391 10,268 90,5% 53X Real Estate, Rental, Leasing 412,907 377,469 383,613 1.6%
334' Computer Electronic Products 19,797 17,761 :071' -73.7% f 541 Professional, Scientific, Tech 227,255 173,312 164,919 -4.8%
335 Electric Equipment, Appliances 137 130
""500. 285.3% 551 Company Management 985 875 242 -72.3%
336 Transportation Equipment Mfg 135,430 111,302 •133 :992 20.4% 56X Admin, Supp, Remed Svcs 123,115 109,076 99,792 -8.5%
337' Fumiture Related Products 8,575 7,947 8;962 12.8% i 611 Educational Services 47,324 42,615 .56,437 32.4%
339' Miscellaneous Manufacturing 10,665 9,475 :10,258: 8.3% j 62X Health Care Social Assistance 91,637 76,373 64,104 -16.1%
TOTAL MANUFACTURING 305,059 264,391 ::268,466 71X Arts Entertainment 93,799 86,550 102,700 18.7%
Overall Manufacturing Change from Previous Year :::34,075 1.5% I 72X' Accommodation Food Svcs 1,745,512 1,597,416' 1,613,949 1.0% 1
81X Other Services 183,887 165,590 167,839 1.4%
YTD 92X Public Administration 32,268 31,045 24,102 -22.4%
TRANSPORTATION WAREHOUSING 09 TOTAL 09 YTD 10 YTD• Diff TOTAL SERVICES 3,540,583 3,180,407 3,200,846
481 Air Transportation 0 0.0% Overall Services Change from Previous Year 320,439 0.6%
482 Rail Transportation 924 923`' 586 -36.5%
484 Truck Transportation 3,294 2,770..::: 'I': .7263 -90.5%
485 Transit and Ground Passengers 11,105 10,036.. '15, 54.4% YTD
487 Scenic and Sightseeing Tran 0 0.:: '_..110. #DIV/0! MISCELLANEOUS 09 TOTAL 09 YTD 10 YTD Diff
488 Transportation Support 21,879 18,428 26,487 43.7% 000 Unknown 397 397 30 -92.6%
491 Postal Services 0 0 °..0 #DIV /0! 111-115 Agriculture, Forestry, Fishing 221 144 313 117.3%
492 Couriers Messengers 149 119 295 147.0% 211 -221 Mining Utilities 14,549 13,978 13;925 -0.4%
I 493' Warehousing Storage 1,051 982 '889 -9.5% j 999 Unclassifiable Establishments 12,331 10,778 92,423 757.5%
TOTAL TRANSP WHSING 38,401 33,258 '9 44,130. MISCELLANEOUS TOTAL 27,499 25,297 106,690
Overall Transportation Change from Previous Year ;110 ,871 3Z7% Overall Miscellaneous Change from Previous Year 581,393 311.8%
YTD
WHOLESALE TRADE 09 TOTAL 09 YTD"'' 10.YTD Diff YTD
I 423' Whls Trade Durable Goods 1,339,565 1,185,088 1;099,914 -7.2% 09 TOTAL 09 YTD 10 YTD Diff
424' Whls Trade-Nondurable Goods 105,260 93,164 101,370 8.8% 1 GRAND TOTALS '914,422,090 612,732,691 $12,689,142
I 425' Wholesale Electronic Markets 2,208 1.937 2,426 25.2% 1 Grand Total Change from Previous Year (143,549) -0.34%
WHOLESALE TRADE TOTAL 1,447,033 1,280,189 .9..:,,.,...]:::::::,i. 1,203,710::
Overall Wholesale Change from Previous Year .(376,4791 -6.0%
I Sales Tax Mitigation NAICS Codes I
CPI
01/24/2011 Page 1 'UK Soles lox Rpl 201011.rlsm
Five Year Comparison
2010
2009 :'14f1247;A2,i il;
2008
.4
(41
2007 17,O3,494
2006
s- $6,000,000 $12,000,000 $18,000,000
Taxes Collected Year to Date
76