HomeMy WebLinkAboutFS 2010-03-02 Item 2B - Report - December 2009 Sales Tax RevenueTO:
City of Tukwila
INFORMATIONAL MEMORANDUM
Mayor Haggerton
Finance and Safety Committee
FROM: Shawn Hunstock, Finance Director
DATE: February 23, 2010
SUBJECT: Sales Tax Revenue for December 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,597) 11.32% 23.76%
Aug Oct 1,555 1,647 1,118 (529) (3,126) 32.12% 24.86%
Sept Nov 1,426 1,685 1,110 (575) (3,701) 34.12% 25.95%
Oct Dec 1,298 1,521 1,032 (489) (4,190) 32.15% 26.55%
Nov Jan 10 1,265 1,589 1,140 (449) (4,639) 28.26% -26.71%
Dec Feb10 1,723 2,175 1,690 (485) (5,124) 22.30% 26.22%
Totals 17,753 19,546 14,422
Mitigation Received 1,589
16,011 81.91% of Budget Incl. Mitigation
Jim Haggerton, Mayor
Sales tax collections showed the sixteenth consecutive decrease in December 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 December 2009 were $485,000 less than budget,
and $33,000 less than the same period last year. We are now down 26.22% for the year
compared to budget, and 18.76% compared to the same period last year.
The chart above also includes the mitigation payment we received at the end of December for
the third quarter of 2009. Including the mitigation payment, we are currently at 81.91% of budget
for the year to date. The mitigation payment we received on December 31s was $311,528.15.
This was an increase of 42.4% 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
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 Motor Vehicle and Parts Dealer is down by 30.88 Miscellaneous Store Retailers
is down by 29.82 and Wholesale Trade and Durable Goods is down by 24.65 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 December.
Schedule III
Group Name
236 Construction of Buildings
323* Printing and Related Support
334* Computer and Electronic Produc
339* Miscellaneous Manufacturing
442* Furniture and Home Furnishings
314 Textile Product Mills
238 Specialty Trade Contractors
522 Credit Intermediation
541 Professional, Scientific, Tech
441* Motor Vehicle and Parts Dealer
Mitigated NAICS Code
YTD YTD Dollar
Current Prior Diff. Duff.
2,044,042 $2,231,745 (187,703) -8.41%
2,015,184 2,101,593 (86,409) -4.11%
1,339,565 1,777,808 (438, 243) 24.65%
1,291,855 1,309,329 (17,474) 1.33%
954,375 1,077,238 (122,864) 11.41%
686,478 993,146 (306,668) 30.88%
589,522 644,522 (55,000) -8.53%
506,177 619,645 (113,468) 18.31%
506,005 721,034 (215, 029) 29.82%
453,657 548,962 (95,305) 17.36%
YTD YTD Dollar
Current Prior Diff.
416,992 $1,302,567 (885, 576)
59,298 143,009 (83,711)
19,797 44,162 (24, 364)
10,665 22,411 (11,745)
350,625 621,785 (271,160)
12,852 22,660 (9,807)
347,910 530,490 (182,580)
41,901 63,568 (21, 667)
227,255 338,302 (111, 048)
686,478 993,146 (306,668)
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:1FIN Projects\Sales Tax Information\Sales Tax Files from Shawn1200911nfo Memo Sales Tax 022210.docx
Diff.
67.99%
58.54%
55.17%
52.41%
43.61%
43.28%
-34.42%
34.08%
32.82%
30.88%
NAICS CONSTRUCTION 08 TOTAL
236 Construction of Buildings 1,302,567
237 Heavy Civil Construction 130,624
238 Specialty Trade Contractors 530490
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 Manufactunnq
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
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
TRANSPORTATION 8 WAREHOUSING 08 TOTAL
481 Air Transportation 0
482 Rail Transportation 1,935
484 Truck Transportation 965
485 Transit and Ground Passengers 11,502
488 Transportation Support 28,728
491 Postal Services 88
492 Couriers Messengers 476
I 493' Warehousing Storage 781
TOTAL TRANSP WHSING S 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 Mitigation NAICS Codes
02/23/2010
SALES TAX SUMMARY
December 2009 (Received in February 2010)
YTD
08 YTD 09 YTD Diff
1,302,567 416,992 -68.0%
130,624 98,105 -24.9%
530,490 347,910 -34.4%
1,963,680 863,006
($1,100,674) -56.1%
YTD
08 YTD 09 YTD Diff
4,997 1,173 -76.5%
2,328 3,070 31.9%
1,050 259 -75.3%
22,660 12,852 -43.3%
215 59 -72.5%
9 7 -18.2%
9,515 2,701 -71.6% I
21,545 20,392 -5.4% I
143,009 59,298 -58.5% I
9,630 8,157 -15.3%
8,068 6,368 -21.1%
4,085 3,928 -3.8%
5,242 2,279 -56.5%
52 534 920.8%
6,310 3,789 -39.9%
-8,777 5,586 -163.6%
44,162 19,797 -55.2% I
895 137 84.7%
191,525 135.430 -29.3%
31,384 8,575 -72.7% J
22,411 10.665 -52.4% I
520,315 305,059
($215,255) -41.4%
YTD
08 YTD 09 YTD Diff
0 0 0.0%
1,935 924 -52.3%
965 3,294 241.2%
11,502 11,105 -3.4%
28,728 21,879 -23.8%
88 0 100.0%
476 149 -68.7%
781 1,051 34.5%
44,475 38,401
($6,074) -13.7%
YTD
08 YTD 09 YTD Diff
1,777,808 1,339.565 -24.7%
113,096 105.260 -6.9%
2,805 2,208 -21.3%
1,893,709 1,447,033
($446,676) -23.6%
NAICS AUTOMOTIVE 08 TOTAL
441' Motor Vehicle Parts Dealer 993,146
I 447' Gasoline Stations 73,034
TOTAL AUTOMOTIVE 1,066,181
Overall Automotive Change from Previous Year
NAICS
442*
443'
444*
445*
446'
448'
451'
452'
453*
454*
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
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
Page 1
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
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
08 TOTAL
GRAND TOTALS $17,752,678
Grand Total Change from Previous Year
YTD
08 YTD 09 YTD Diff
993,146 686,478 -30.9%
73.034 62.584 -14.3%
1,066,181 749,063
($317,118) -29.7%
08 YTD 09 YTD Diff
621,785 350,625 -43.6%
1,077,238 954,375 -11.4%
619,645 506,177 -18.3%
88,317 86,349 -2.2%
146,841 189,603 29.1%
2,101,593 2,015,184 -4.1%
644,522 589,522 -8.5%
2,231,745 2,044,042 -8.4%
721,034 506,005 -29.8%
116,347 209,564 80.1%
8,369,066 7,451,446
($917,620) -11.0%
YTD
08 YTD 09 YTD Diff
570,706 528,044 -7.5%
75,585 53,850 -28.8%
403,851 412,907 2.2%
338,302 227,255 -32.8%
1,902 985 -48.2%
167,119 123,115 -26.3%
12,727 47,324 271.8%
109,308 91,637 -16.2%
106,515 93,799 -11.9%
1,858,292 1,745,512 -6.1% I
192,450 183,887 -4.4%
843 32,268 3727.6%
3,837,599 3,540,583
($297,016) -7.7%
08 YTD
1,147
1,095
19,574
35,837
57,652
08 YT D
$17,752,678
YTD
09 YTD Diff
397 -65.4%
221 -79.8%
14,549 -25.7%
12331 -65.6%
27,499
($30,154) -52.3%
YTD
09 YTD Diff
$14,422,090
($3,330,587) 18.76%
[UK Sales Tax Rpl 200912.xisn,
2006
Four Year Comparison
$17,847,929
$5,000,000 $10,000,000 $15,000,000
Taxes Collected Year to Date
$20,000,000