HomeMy WebLinkAboutFS 2010-01-20 Item 2D - Report - October 2009 Sales Tax RevenueTO:
City of Tukwila
INFORMATIONAL MEMORANDUM
Mayor Haggerton
Finance and Safety Committee
FROM: Shawn Hunstock, Finance Director
DATE: December 23, 2009
SUBJECT: Sales Tax Revenue for October 2009
Schedule I
in 1,000's
Sales Receipt 2008 2009 2009 Increase /(Decrease) %Increase /(Decrease)
Month Month Actual Estimated Actual Month YTD Month YTD
Jan Mar 1,347 1,403 1,172 (231) (231) 16.46% 0.00%
Feb Apr 1,357 1,397 1,051 (346) (577) 24.77% 20.61%
Mar May 1,601 1,654 1,146 (508) (1,085) 30.71% 24.36%
Apr June 1,365 1,497 1,191 (306) (1,391) 20.44% 23.37%
May July 1,635 1,560 1,082 (478) (1,869) 30.64% 24.88%
June Aug 1,646 1,757 1,217 (540) (2,409) 30.73% 25.99%
July Sept 1,535 1,661 1,473 (188) (2,366) 11.32% 23.76%
Aug Oct 1,555 1,647 1,118 (529) (2,549) 32.12% 24.86%
Sept Nov 1,426 1,685 1,110 (575) (2,616) 34.12% 25.95%
Oct Dec 1,298 1,521 1,032 (489) (2,799) 32.15% 26.55%
Nov Jan10 1,265 1,589
Dec Feb10 1,723 2,175
Totals 17,753 19,546 11,592
Mitigation Received 1,589
13,181 92.43% of Budget Incl. Mitigation
Jim Haggerton, Mayor
Sales tax collections showed the fourteenth consecutive decrease in October 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 October 2009 were $489,000 less than budget, and
$266,000 less than the same period last year. We are now down 26.55% for the year compared
to budget, and 21.49% 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 92% 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 II
YTD YTD Dollar
Group Name Current Prior Diff. Diff.
452* General Merchandise Stores 1,575,898 1,780,309 (204,411) 11.48%
448* Clothing and Accessories 1,566,219 1,676,733 (110,515) -6.59%
423* Wholesale Trade, Durable Goods 1,102,686 1,614,533 (511,847) 31.70%
722* Food Services, Drinking Places 1,075,617 1,104,125 (28,508) -2.58%
443* Electronics and Appliances 741,483 842,119 (100,636) 11.95%
441* Motor Vehicle and Parts Dealer 592,371 831,557 (239,186) 28.76%
451* Sporting Goods, Hobby, Books 450,295 511,454 (61,159) 11.96%
444* Building Material and Garden 434,657 547,726 (113,069) 20.64%
453* Miscellaneous Store Retailers 408,981 601,964 (192,983) 32.06%
721* Accommodation 392,514 474,016 (81,501) 17.19%
Mitigated NAICS Code
As you can see there are large variances from last year for the same time period. For instance,
sales tax for Building Material and Garden is down by 32.06 Wholesale Trade and Durable
Goods is down by 31.70 and Motor Vehicle and Parts Dealer is down by 28.76 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 October.
Schedule Ill
YTD YTD Dollar
Group Name Current Prior Diff. Diff.
236 Construction of Buildings 377,918 1,154,646 (776,728) 67.27%
334* Computer and Electronic Produc 13,901 38,313 (24,412) 63.72%
323* Printing and Related Support 49,498 131,137 (81,639) 62.25%
442* Furniture and Home Furnishings 278,400 549,729 (271,328) 49.36%
314 Textile Product Mills 10,862 20,813 (9,951) 47.81%
237 Heavy and Civil Construction 60,984 114,436 (53,452) -46.71%
512 Motion Picture, Sound Record 25,213 37,836 (12,623) 33.36%
541 Professional, Scientific, Tech 145,551 217,205 (71,654) 32.99%
621 Ambulatory Health Care Service 48,918 72,931 (24,012) 32.92%
453* Miscellaneous Store Retailers 408,981 601,964 (192,983) 32.06%
Mitigated NAICS Code
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.
W:\FIN Projects\Sales Tax Information\Sales Tax Files from Shawn12009 \Info Memo Sales Tax 122409.doc
NAICS CONSTRUCTION 08 TOTAL
236 Construction of Buildings 1,302,567
237 Heavy Civil Construction 130,624
238 Specialty Trade Contractors 530,490
TOTAL CONSTRUCTION 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' Furniture Related Products
339' Miscellaneous Manufacturing
TOTAL MANUFACTURING
TRANSPORTATION WAREHOUSING
481 Air Transportation
482 Rail Transportation
484 Truck Transportation
485 Transit and Ground Passengers
488 Transportation Support
491 Postal Services
492 Couriers Messengers
493' Warehousing Storage
TOTAL TRANSP WHSING
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 Mitigation NAICS Codes
12/23/2009
08 TOTAL
4,997
2,328
1,050
22,660
215
9
9,515
21,545
143,009
9,630
8,068
4,085
5,242
52
6,310
-8,777
44,162
895
191,525
31,384
22,411
520,315
Overall Manufacturing Change from Previous Year
SALES TAX SUMMARY
October 2009 (Received in December)
YTD
08 YTD 09 YTD Diff
1,154,646 377,918 -67.3%
114,436 60,984 -46.7%
424,581 288,836 -32.0%
1,693,663 727,739
($965,925) -510%
YTD
08 YTD 09 YTD Diff
4,150 1,021 -75.4%
1,706 2,552 49.6%
59 205 247.1%
20,813 10,862 -47.8%
214 37 -82.9%
5 4 -25.7%
7,137 2.404 -66.3%
18,010 16,482 -8.5%
131,137 49,498 -62.3%
7,982 6,898 -13.6%
7,019 5,428 -22.7%
3,921 3.694 -5.8%
4,505 1,986 -55.9%
52 477 812.1%
5,498 3,096 -43.7%
-9,366 5,304 156.6%
38,313 13,901 -63.7%
661 128 -80.6%
138,671 105.241 -24.1%
30,133 7,423 -75.4%
17,266 9,037 -47.7%
427,886 245,677
($182,210)
-42.6% 1
YTD
08 TOTAL 08 YTD 09 YTD Diff
0 0 0 0.0%
1,935 1,623 891 -45.1%
965 401 2,758 588.2%
11,502 9,778 9,225 -5.7%
28,728 22,965 17,212 -25.0%
88 88 0 -100.0%
476 469 91 -80.5%
781 662 926 39.9%
44,475 35,985 31,104
($4,880) -13.6%
YTD
08 YTD 09 YTD Diff
1,614,533 1,102,686 -31.7%
91,976 86,589 -5.9% t
2,498 1,759 -29.6%
1,709,006 1,191,034
($51Z972) -30.3%
NAICS
1 441'
1 447*
NAICS
442'
443*
444'
445'
446'
448'
451'
452'
453*
454*
AUTOMOTIVE
Motor Vehicle Parts Dealer
Gasoline Stations
TOTAL AUTOMOTIVE
RETAIL TRADE
Furniture Home Furnishings
Electronics Appliances
Building Material Garden
Food Beverage Stores
Health Personal Care
Clothing Accessories
Sporting Goods, Hobby, Books
General Merchandise Stores
Miscellaneous Store Retailers
Nonstore Retailers
TOTAL RETAIL TRADE
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
Page 1
08 TOTAL
993,146
73,034
1,066,181
Overall Automotive Change from Previous Year
08 TOTAL
621.785
1,077.238
619,645
88,317
146.841
2.101,593
644.522
2,231,745
721,034
116,347
8,369,066
Overall General Retail 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
MISCELLANEOUS TOTAL 57,652
Overall Miscellaneous Change from Previous Year
08 TOTAL
GRAND TOTALS 517,752,678
Grand Total Change from Previous Year
08 YTD
878
1,062
18,777
29,048
49,765
08 YTD
614,766,418
TUK Soles rox Rpt 200910.x1s
YTD
08 YTD 09 YTD Diff
831,557 592,371 -28.8%
63,274 52,748 -16.6%
894,831 645,119
($249,712) -27.9%
08 YTD 09 YTD Diff
549,729 278,400 -49.4%
842,119 741,483 -12.0%
547,726 434,657 -20.6%
74,218 71,257 -4.0%
115,140 147,812 28.4%
1,676.733 1,566,219 -6.6%
511,454 450,295 -12.0%
1,780,309 1,575,898 -11.5%
601,964 408,981 -32.1%
91,785 177,929 93.9%
6,791,177 5,852,930
($938,247) -13.8%
YTD
08 YTD 09 YTD Diff
473,322 434,637 -8.2%
51,671 43,994 -14.9%
347,495 315,113 -9.3%
217,205 145,551 -33.0%
1,384 862 -37.7%
140,511 101,896 -27.5%
9,164 38,010 314.8%
91,788 66,072 -28.0%
94,651 80,558 -14.9%
1.578,140 1,468,131 -7.0%
158,375 152,180 -3.9%
397 28,776 7155.3%
3,164,104 2,875,781
($288,323) -9.1%
YTD
09 YTD Diff
397 -54.8%
143 -86.5%
13,503 -28.1%
9,501 -67.3%
23,545
($26,220) -52.7%
YTD
09 YTD Diff
$11,592,930
($3,173,488) 21.49%
2009
2008
L
co
0
2007
2006
Four Year Comparison
s-
$4,000,000
$8,000,000 $12,000,000
Taxes Collected Year to Date
$16,000,000