HomeMy WebLinkAboutFS 2010-12-07 Item 2G - Report - September 2010 Sales Tax Revenue Report r 4 A City of Tukwila
a o Jim Haggerton, Mayor
290B. INFORMATIONAL MEMORANDUM
TO: Mayor Haggerton
Finance and Safety Committee
FROM: Shawn Hunstock, Finance Director
DATE. November 22, 2010
SUBJECT: Sales Tax Revenue for September 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,556) (5,923) -100 00% -36 27%
Nov Jan11 1,140 1,631 (1,631) (7,554) -100 00% 42.06%
Dec Feb11 1,690 2,270 (2,270) (9,824) 100.00% 48.56%
Totals 14,422 20,231 10,407
Mitigation Received 934
11,341 76.76% of Budget Intl Mitigation
Sales tax collections for September showed the second consecutive increase, and fourth so far
this year, as compared to the same month in the prior year. For September, collections were
less than budget for the month, but more than actual collections in the same month in the
previous year. Actual receipts for September were $325,000 less than budget, but $247,000
more than the same period last year. This is the largest monthly increase that we have had all
year. We are down 19.32% for the month compared to budget, and up by 22.25% compared to
the same month last year. We are now down in total 29.56% for the year compared to budget,
and down by 1.45% compared to the same period last year.
Including mitigation payments, we are currently at 76.76% of budget for the year to date. The
latest mitigation payment we received was on September 30, 2010 for $310,763 48. This was
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, effective with the
December 31 payment. The next mitigation payment will be received on December 31 Staff
59
INFORMATIONAL MEMO
Page 2
completed work on the last mitigation detail file and submitted to the Department of Revenue a
list of firms that should be removed from the mitigation calculation process. These firms are
ones that were offsetting other losses, thereby reducing our mitigation payment.
Schedule II shows the year -to -date sales tax from the top ten industry classifications. As this
schedule indicates, the trend is flat or down for most of the classifications.
Schedule II
YTD YTD Dollar
Group Name Current Prior Diff. Diff.
452* General Merchandise Stores 1,439,361 $1,424,218 15,144 1.06%
448* Clothing and Accessories 1,412,724 1,423,519 (10,794) -0.76%
722* Food Services, Drinking Places 1,007,646 970,522 37,124 3.83%
423* Wholesale Trade, Durable Goods 948,301 1,033,295 (84,994) -8 23%
443* Electronics and Appliances 669,342 673,026 (3,684) -0.55%
451* Sporting Goods, Hobby, Books 448,556 407,360 41,196 10.11%
441* Motor Vehicle and Parts Dealer 447,358 543,211 (95,853) -17 65%
236 Construction of Buildings 431,616 362,589 69,028 19.04%
444* Building Material and Garden 386,918 392,214 (5,296) 1.35%
453* Miscellaneous Store Retailers 339,150 368,846 (29,696) 8.05%
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 17.65 and Wholesale Trade and
Durable Goods is down by 8.23% As illustrated above, five 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 17,374 55,330 (37,956) -68 60%
454* Nonstore Retailers 75,846 171,379 (95,533) 55.74%
238 Specialty Trade Contractors 201,175 266,594 (65,418) -24 54%
621 Ambulatory Health Care Service 34,708 43,595 (8,887) 20.39%
441* Motor Vehicle and Parts Dealer 447,358 543,211 (95,853) 17.65%
323* Printing and Related Support 39,261 45,648 (6,386) 13.99%
812 Personal and Laundry Services 62,094 71,024 (8,930) 12.57%
561 Administrative and Support Svc 76,687 87,144 (10,457) 12.00%
518 Internet Service Providers 44,118 48,831 (4,712) 9.65%
721* Accommodation 327,713 360,373 (32,660) -9 06%
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.
60 W 1FIN Projects\Sales Tax Information\Sales Tax Ales from Shawn120101Info Memo Sales Tax 112210.docx
SALES TAX SUMMARY
September 2010 (Received in November)
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 362,589 431,616 19.0% I 441' Motor Vehicle Parts Dealer 686,478 543,211 447,358 -17.6% I
237 Heavy Civil Construction 98,105 55,330 17,374 -68.6% I 447' Gasoline Stations 62,584 47,389 50,522 6.6% I
238 Specialty Trade Contractors 347,910 266,594 201,175 -24.5% TOTAL AUTOMOTIVE 749,063 590,600 497,879
TOTAL CONSTRUCTION 863,006 684,513 650,166 Overall Automotive Change from Previous Year ($92,721) -15.7%
Overall Construction Change from Previous Year ($34,347) -5.0%
NAICS RETAIL TRADE 09 TOTAL 09 YTD 10 YTD Diff
YTD 442' Furniture Home Furnishings 350,625 251,289 277,092 10.3%
MANUFACTURING 09 TOTAL 09 YTD 10 YTD %Diff 443' Electronics Appliances 954,375 673,026 669,342 -0.5%
311 Food Manufacturing 1,173 912 3,530 286.8% 444' Building Material Garden 506,177 392,214 386,918 -1.4%
312 Beverage Tobacco Products 3,070 2,308 -2,034 -188.2% 445" Food Beverage Stores 86,349 64,273 68,803 7.0%
313 Textile Mills 259 131 72 -44.9% 446' Health Personal Care 189,603 134,176 125,346 -6.6%
314 Textile Product Mills 12,852 9,956 10,745 7.9% 448" Clothing Accessories 2,015,184 1,423,519 1,412,724 -0.8%
315 Apparel Manufacturing 59 37 17 -52.3% 451' Sporting Goods, Hobby, Books 589,522 407,360 448,556 10.1%
316 Leather Allied Products 7 4 2 -52.0% 452* General Merchandise Stores 2,044,042 1,424,218 1,439,361 1.1%
321' Wood Product Manufacturing 2,701 2,306 1,296 -43.8% I 453" Miscellaneous Store Retailers 506,005 368,846 339,150 -8.1%
322' Paper Manufacturing 20,392 14,821 16,174 9.1% I 454" Nonstore Retailers 209,564 171,379 75,846 -55.7%
323' Printing Related Support 59,298 45,648 39,261 -14.0% I TOTAL RETAIL TRADE 7,451,446 5,310,299 5,243,138
324 Petroleum Coal Products 8,157 5,619 2,659 -52.7% Overall General Retail Change from Previous Year ($67,161) -1.3%
325 Chemical Manufacturing 6,368 4,906 5,570 13.5%
326 Plastic Rubber Products 3,928 3,560 2,439 -31.5% YTD
327' Nonmetallic Mineral Products 2,279 1,431 857 -40.1% I SERVICES 09 TOTAL 09 YTD 10 YTD Diff
331 Pnmary Metal Manufacturing 534 279 388 39.1% 51X Information 528,044 395,380 388,884 46%
332 Fabricated Metal Mfg Products 3,789 2,730 -3,666 -234.3% 52X Finance Insurance 53,850 36,925 39,849 7.9%
333 Machinery Manufacturing 5,586 5,155 8,167 58.4% 53X Real Estate, Rental, Leasing 412,907 280,796 311,764 11.0%
334' Computer& Electronic Products 19,797 12,787 3,262 -74.5% I 541 Professional, Scientific, Tech 227,255 130,035 125,117 -3.8%
335 Electric Equipment, Appliances 137 110 372 237.2% 551 Company Management 985 755 225 -70.2%
336 Transportation Equipment Mfg 135,430 95,882 118,162 23.2% 56X Admin, Supp, Remed Svcs 123,115 93,439 79,977 -14.4%
337' Furniture Related Products 8,575 7,206 7,373 2.3 I 611 Educational Services 47,324 32,708 46,835 43.2%
339" Miscellaneous Manufacturing 10,665 8,626 8,427 -2.3% I 62X Health Care Social Assistance 91,637 58,712 52,663 -10.3%
TOTAL MANUFACTURING 305,059 224,414 223,073 71X Arts Entertainment 93,799 74,148 88,608 19.5%
Overall Manufacturing Change from Previous Year (81,341) -0.6% I 72X" Accommodation Food Svcs 1,745,512 1,330,895 1,335,359 0.3 I
81X Other Services 183,887 138,637 141,026 1.7%
YTD 92X Public Administration 32,268 17,474 20,326 16.3%
TRANSPORTATION WAREHOUSING 09 TOTAL 09 YTD 10 YTD Diff TOTAL SERVICES 3,540,583 2,589,902 2,630,634
481 Air Transportation 0 0 0 0.0% Overall Services Change from Previous Year 040,732 1.6%
482 Rail Transportation 924 854 280 -67.3%
484 Truck Transportation 3,294 2,742 172 -93.7%
485 Transit and Ground Passengers 11,105 8,429 13,456 59.6% YTD
488 Transportation Support 21,879 15,786 22,005 39.4% MISCELLANEOUS 09 TOTAL 09 YTD 10 YTD Diff
491 Postal Services 0 0 0 #DIV /0! 000 Unknown 397 397 1 -99.7%
492 Couriers Messengers 149 62 265 325.7% 111 -115 Agriculture, Forestry, Fishing 221 143 204 43.2%
I 493' Warehousing Storage 1,051 872 753 -13.7% I 211 -221 Mining Utilities 14,549 12,572 12,582 0.1%
TOTAL TRANSP WHSING 38,401 28,746 36,930 999 Unclassifiable Establishments 12,331 5,692 78,965 1287.2%
Overall Transportation Change from Previous Year $8,184 28.5% MISCELLANEOUS TOTAL 27,499 18,604 91,752
Overall Miscellaneous Change from Previous Year 072,948 387.9%
YTD
WHOLESALE TRADE 09 TOTAL 09 YTD 10 YTD Diff
I 423" Whls Trade Durable Goods 1,339,565 1,033,295 948,301 -8.2% I YTD
I 424' Whls Trade Nondurable Goods 105,260 78,407 81,969 4.5%. 1 09 TOTAL 09 YTD 10 YTD Diff
425' Wholesale Electronic Markets 2,208 1,667 2,027 21.6% 1 GRAND TOTALS $14,422,090 $10,560,647 $10,405,869
WHOLESALE TRADE TOTAL 1,447,033 1,113,370 1,032,296 Grand Total Change from Previous Year ($154,778) -1.47%
Overall Wholesale Change from Previous Year (081,074) -7.3%
I Sales Tax Mitigation NAICS Codes I
Cr)
11/22/2010 Page 1 TUK 501es Tax Rpl 201009 ,ism
Five Year Comparison
l; s. t C..°if. r' .';µir,�ss t t` %r
2010 jr,,
1 n 1 1 O 4. 5 8 85 i
rT-p- i i ce pi
J ':e:
x k •�i: in {:,�r,�.v v:�-,c- �t,;a.�x»gx., -a �,lS1�'z�,>3'"�`=^``
:c., �.s; ray v r
YRg=: .±ate" f� ;::'ss °.3..
2009 I h, w. *..1.
fL a ter r 4 J Y h 5,. O
A' 2008 k i xv xx m 6 g �f�b� n �4,:-
�Y�s{ 3” !t- �'y' t,�, "A i `y�3g� g 3 '"'o A 45 =�P� §�,k 3K3 p,�a�.
2007 1 5 T s`T4 054,711 i i!
�,�,t: ;�?4'7gf' �;,r'r: "''�i`�'',; s�' ?q r �'.3°"` :�"'4� s k i,:
jo'���.�'�' 3�.f9'. <�`,iiv �.4 i 'Q "i .T�b�,r' �$y'-' y
y f�v{; y 'f. a ���,y.,.- �1' °".J[ Yh ;.,;��,s-�;�,e 'F�€+
I' 3` t1), h Al S. 0,14.?-:TWA, Y"4 5:-d ar•,, C is`
r' 'u e' V i +'r'.��..�sS ='�.h+�rtw.:4 Rm�.,�:?'� °P s:_: "Ii. :c:r•,� ai:!u- >x:. .y" >'y>;r
2006
$2,500,000 $5,000,000 $7,500,000 $10,000,000 $12,500,000 $15,000,000
Taxes Collected Year to Date
62