HomeMy WebLinkAboutFS 2010-02-02 Item 2D - Report - November 2009 Sales Tax RevenueTO:
FROM:
DATE:
SUBJECT:
Schedule I
Mitigation Received
City of Tukwila
INFORMATIONAL MEMORANDUM
Mayor Haggerton
Finance and Safety Committee
Shawn Hunstock, Finance Director
January 27, 2010
Sales Tax Revenue for November 2009
Sales Receipt 2008 2009 2009
Month Month Actual Estimated Actual
Jan Mar 1,347 1,403 1,172
Feb Apr 1,357 1,397 1,051
Mar May 1,601 1,654 1,146
Apr June 1,365 1,497 1,191
May July 1,635 1,560 1,082
June Aug 1,646 1,757 1,217
July Sept 1,535 1,661 1,473
Aug Oct 1,555 1,647 1,118
Sept Nov 1,426 1,685 1,110
Oct Dec 1,298 1,521 1,032
Nov Jan10 1,265 1,589 1,140
Dec Feb10 1,723 2,175
Totals 17,753 19,546 12,732
1,589
14,321
Increase /(Decrease)
Month YTD
(231)
(346)
(508)
(306)
(478)
(540)
(188)
(529)
(575)
(489)
(449)
(231)
(577)
(1,085)
(1,391)
(1,869)
(2,409)
(2,597)
(3,126)
(3,701)
(4,190)
(4,639)
in 1,000's
%Increase /(Decrease)
Month YTD
16.46%
24.77%
-30.71
20.44%
30.64%
30.73%
11.32%
32.12%
34.12%
32.15%
28.26%
0.00%
-20.61
24.36%
23.37%
24.88%
25.99%
23.76%
24.86%
25.95%
26.55%
-26.71%
82.44% of Budget Incl. Mitigation
Jim Haggerton, Mayor
Sales tax collections showed the fifteenth consecutive decrease in November compared to the
same period in the prior year. For 2009, collections were less than both budget and the same
month in the prior year. Actual receipts for November 2009 were $449,000 less than budget,
and $125,000 less than the same period last year. We are now down 26.71% for the year
compared to budget, and 20.57% compared to the same period last year.
The chart above also includes the mitigation payment we will receive at the end of December for
the third quarter of 2009. Including the mitigation payment, we are currently at 82.44% of budget
for the year to date. The mitigation payment we will receive on December 31 is $311,528.15.
This is a 42.4% increase from the $218,797.89 we received for the same quarter last year.
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 all of the classifications.
INFORMATIONAL MEMO
Page 2
Schedule 11
Group Name
452* General Merchandise Stores
448* Clothing and Accessories
423* Wholesale Trade, Durable Goods
722* Food Services, Drinking Places
443* Electronics and Appliances
441* Motor Vehicle and Parts Dealer
451* Sporting Goods, Hobby, Books
444* Building Material and Garden
453* Miscellaneous Store Retailers
721* Accommodation
Mitigated NAICS Code
As you can see there are large variances from last year for the same time period. For instance,
sales tax for Miscellaneous Store Retailers is down by 31.90 Motor Vehicle and Parts Dealer
is down by 30.59 and Wholesale Trade and Durable Goods is down by 30.29 As you can
see from Schedule II, all of the top ten merchant categories have declined versus prior year,
and all 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 through November.
Schedule III
Group Name
236 Construction of Buildings
323* Printing and Related Support
334* Computer and Electronic Produc
442* Furniture and Home Furnishings
314 Textile Product Mills
238 Specialty Trade Contractors
512 Motion Picture, Sound Record
453* Miscellaneous Store Retailers
441 Motor Vehicle and Parts Dealer
561 Administrative and Support Svc
Mitigated NAICS Code
W: \FIN Projects \Sales Tax Information \Sales Tax Files from Shawn120091Info Memo Sales Tax 012610.docx
YTD YTD Dollar
Current Prior Diff. Diff.
1,763,485 1,968,140 (204,655) 10.40%
1,733,349 1,848,767 (115,418) -6.24%
1,185,088 1,700,092 (515,004) 30.29%
1,174,027 1,205,944 (31,917) -2.65%
824,186 931,153 (106,967) 11.49%
633,512 912,703 (279,191) 30.59%
498,173 558,829 (60,656) 10.85%
470,491 585,617 (115,126) 19.66%
443,886 651,777 (207,892) 31.90%
423,389 510,510 (87,121) 17.07%
YTD
Current
386,100
53,293
17,761
311,667
11,615
312,544
27,773
443,886
633,512
102,197
YTD Dollar
Prior Diff.
1,238,064 (851,964)
137,909 (84,616)
41,114 (23, 353)
587,159 (275,492)
21,522 (9,906)
469,315 (156,771)
40,818 (13,045)
651,777 (207,892)
912,703 (279,191)
147,092 (44,895)
0 /0
Diff.
-68.81
61.36%
56.80%
46.92%
46.03%
33.40%
31.96%
31.90%
30.59%
-30.52%
Attached is a Sales Tax Summary comparing year -to -date 2009 vs. 2008 by major NAICS
codes. Also included is a comparison of total receipts year -to -date for the last four years.
Please let me know if you have any comments or questions. Thank you.
NAICS
236
237
238
CONSTRUCTION
Construction of Buildings
Heavy Civil Construction
Specialty Trade Contractors
TOTAL CONSTRUCTION
TRANSPORTATION 8. WAREHOUSING
481 Air Transportation
482 Rail Transportation
484 Truck Transportation
485 Transit and Ground Passengers
488 Transportation Support
491 Postal Services
492 Couriers Messengers
I 493* Warehousing Storage
TOTAL TRANSP WHSING
Sales Tax Mitigation NAICS Codes 1
01/27/2010
08 TOTAL
1,302,567
130,624
530,490
1,963,680
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 520,315
Overall Manufacturing Change from Previous Year
08 TOTAL
0
1,935
965
11,502
28,728
88
476
781
44,475
Overall Transportation Change from Previous Year
WHOLESALE TRADE 08 TOTAL
423* Whls Trade Durable Goods 1,777,808
424* Whls Trade Nondurable Goods 113,096
425' Wholesale Electronic Markets 2,805
WHOLESALE TRADE TOTAL 1,893,709
Overall Wholesale Change from Previous Year
SALES TAX SUMMARY
November 2009 (Received in January 2010)
YID
08 YTD 09 YTD %Diff
1,238,064 386,100 -68.8%
115,675 84,860 -26.6%
469,315 312,544 33.4%
1,823,054 783,504
($1,039,549)
YTD
08 TOTAL 08 YTD 09 YTD Diff
4,997 4,621 1,055 -77.2%
2,328 1,952 2,725 39.6%
1,050 59 207 250.4%
22,660 21,522 11,615 -46.0%
215 215 46 -78.5%
9 5 4 25.7%
9,515 7,487 2.555 -65.9%
21,545 19,916 18,239 -8.4%
143.009 137,909 53,293 -61.4%
9,630 8,918 7,141 -19.9%
8,068 7,593 5,848 -23.0%
4,085 4,006 3,794 -5.3%
5,242 4,863 2,119 -56.4%
52 52 529 913.0%
6,310 5,918 3,215 .45.7%
-8,777 -9,072 5,391 159.4%
44,162 41,114 17.761 -56.8%
895 664 130 -80.4%
191.525 147,590 111,302 -24.6%
31,384 31,093 7,947 -74.4%
22,411 19,135 9,475 -50.5%
455,560 264,391
(5191,168)
YTD
08 YTD 09 YTD Diff
0 0 0.0%
1,801 923 -48.8%
450 2,770 515.2%
10,559 10,036 -5.0%
25,846 18,428 -28.7%
88 0 -100.0%
469 119 -74.6%
742 982 32.4%
39,955 33,258
(56,697)
YTD
08 YTD 09 YTD Diff
1,700,092 1,185,088 -30.3%
102,397 93,164 -9.0%
2,610 1,937 -25.8%
1,805,098 1,280,189
($524,909)
-57.0%
-42.0%
-29.1%
NAICS
I 441'
I 447*
AUTOMOTIVE
Motor Vehicle Parts Dealer
Gasoline Stations
TOTAL AUTOMOTIVE
NAICS RETAIL TRADE 08 TOTAL
442' Furniture Home Furnishings 621,785
443' Electronics Appliances 1,077,238
444' Building Material Garden 619,645
445' Food Beverage Stores 88,317
446' Health Personal Care 146,841
448* Clothing Accessories 2,101,593
451' Sporting Goods, Hobby, Books 644,522
452' General Merchandise Stores 2,231,745
453' Miscellaneous Store Retailers 721,034
454' Nonstore Retailers 116,347
TOTAL RETAIL TRADE 8,369,066
Overall General Retail Change from Previous Year
Page 1
SERVICES
51X Information
52X Finance Insurance
53X Real Estate, Rental, Leasing
541 Professional, Scientific, Tech
551 Company Management
56X Admin, Supp, Remed Svcs
611 Educational Services
62X Health Care Social Assistance
71X Arts Entertainment
72X' Accommodation Food Svcs
81X Other Services
92X Public Administration
TOTAL SERVICES
08 TOTAL
993,146
73,034
1,066,181
Overall Automotive Change from Previous Year
08 TOTAL
570,706
75,585
403,851
338,302
1,902
167,119
12,727
109,308
106,515
1,858,292
192,450
843
3,837,599
Overall Services Change from Previous Year
MISCELLANEOUS 08 TOTAL
000 Unknown 1,147
111 -115 Agriculture, Forestry, Fishing 1,095
211 -221 Mining Utilities 19,574
999 Unclassifiable Establishments 35,837
-16.8% MISCELLANEOUS TOTAL 57,652
Overall Miscellaneous Change from Previous Year
08 TOTAL
GRAND TOTALS $17,752,678
Grand Total Change from Previous Year
YTD
OB YTD 09 YTD Diff
912,703 633,512 -30.6%
68,072 57,168 -16.0%
980,775 690,680
0290,095) -29.6%
08 YTD 09 YTD Diff
587,159 311,667 -46.9%
931,153 824,186 -11.5%
585.617 470,491 -19.7%
81,103 79,253 -2.3%
125,479 161,952 29.1%
1,848,767 1,733,349 -6.2%
558,829 498,173 -10.9%
1,968,140 1,763,485 -10.4%
651,777 443,886 -31.9%
100,605 188,523 87.4%
7,438,629 6,474,964
(5963,665) -13.0%
YTD
08 YTD 09 YTD Diff
514,835 471,858 -8.3%
55,791 48,228 -13.6%
374,187 377,469 0.9%
232,862 173,312 -25.6%
1,882 875 -53.5%
153,158 109,076 -28.8%
10,642 42,615 300.5%
98,236 76,373 -22.3%
98,768 86,550 -12.4%
1,716,454 1,597.416 -6.9% I
173,559 165,590 -4.6%
397 31,045 7727.3%
3,430,772 3,180,407
(5250,365) 7.3%
08 YTD
878
1,063
19,299
34,966
56,206
08 YTD
816,030,049
YID
09 YTD Diff
397 -54.8%
144 -86.5%
13,978 -27.6%
10,778 -69.2
25,297
(530,910) -55.0%
YTD
09 YTD Diff
812,732,691
(03,297,358) 20.57%
TUK Sales Tax Rpl 20091 I .Ism
2009
2008
L
al
a)
2007
2006
Four Year Comparison
$6,000,000
$12,000,000
Taxes Collected Year to Date
$15,691,931
$18,000,000