HomeMy WebLinkAboutFS 2011-03-08 Item 2C - Report - December 2010 Sales Tax Revenue Report City ®f Tukwila V
o Jim Haggerton, Mayor
90 INFORMATIONAL MEMORANDUM
TO: Mayor Haggerton
Finance and Safety Committee
FROM: Shawn Hunstock, Finance Director
DATE: February 23, 2011
SUBJECT: Sales Tax Revenue for December 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 1,891 (379) (5,649) 16.70% 27.92%
Totals 14,422 20,231 14,582
Mitigation Received 1,242
15,824 78.22% of Budget Incl. Mitigation
Sales tax collections for December showed an increase versus the same month in the previous
year. December represented the fifth consecutive increase, and seventh so far this year. For
December, collections were less than budget for the month, but more than actual collections in
the same month in the previous year. Actual receipts for December were $379,000 Tess than
budget, but $201,000 more than the same period last year. We are down 16.70% for the month
compared to budget, but up by 11.89% compared to the same month last year. We are now
down in total 27.92% for the year compared to budget, but up by 1.09% compared to the same
period last year.
Including mitigation payments, we are currently at 78.22% 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
17
INFORMATIONAL MEMO
Page 2
the December 31s 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
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 2,068,263 2,044,042 24,222 1.18%
448* Clothing and Accessories 2,021,704 2,015,184 6,519 0.32%
722* Food Services, Drinking Places 1,341,150 1,291,855 49,295 3.82%
423* Wholesale Trade, Durable Goods 1,236,905 1,339,565 (102,660) 7.66%
443* Electronics and Appliances 1,003,415 954,375 49,040 5.14%
451* Sporting Goods, Hobby, Books 648,678 589,522 59,155 10.03%
441* Motor Vehicle and Parts Dealer 596,727 686,478 (89,751) 13.07%
236 Construction of Buildings 588,919 416,992 171,927 41.23%
444* Building Material and Garden 499,394 506,177 (6,783) 1.34%
453* Miscellaneous Store Retailers 481,324 506,005 (24,681) 4.88%
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.07 and Wholesale Trade and
Durable Goods is down by 7.66 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.
237 Heavy and Civil Construction 37,857 98,105 (60,248) 61.41%
454* Nonstore Retailers 111,045 209,564 (98,518) 47.01%
531 Real Estate 45,108 70,561 (25,454) 36.07%
621 Ambulatory Health Care Service 50,470 71,247 (20,777) 29.16%
926 Economic Programs Admin 25,292 31,551 (6,259) 19.84%
541 Professional, Scientific, Tech 183,693 227,255 (43,562) 19.17%
238 Specialty Trade Contractors 290,486 347,910 (57,424) 16.51%
441* Motor Vehicle and Parts Dealer 596,727 686,478 (89,751) 13.07%
812 Personal and Laundry Services 83,567 93,346 (9,779) 10.48%
323 Printing and Related Support 54,341 59,298 (4,957) 8.36%
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 Shawn120101Info Memo Sales Tax 02232011.docx
18
SALES TAX SUMMARY
December 2010 (Received in February 2011)
r x..,,.._.....,,.
Y
YTD YTD
NAICS CONSTRUCTION D9 TOTAL 09 YTD 10 YTD Diff NAICS AUTOMOTIVE 09 TOTAL 09 YTD 10 YTD Diff
1 t 727 .13
596,727
236 Construction of Buildings 416,992 416,992 588,919 41.2% I 441` Motor Vehicle &Pats Dealer 686,478 686,478 I
237 Heavy Civil Construction 98,105 98,105 37,857 -61.4% I 447' Gasoline Stations 62,584 62,584 67,583 8.0%
238 Specialty Trade Contractors 347,910 347,910 290,486 16.5% TOTAL AUTOMOTIVE 749,063 749,063 664,310
TOTAL CONSTRUCTION 863,006 863,006 917,262 Overall Automotive Change from Previous Year )$84,752) -11.3%
Overall Construction Change from Previous Year 654,255 6.3%
NAICS RETAIL TRADE 09 TOTAL 09 YTD 10 YTD Diff
YTD 442* Furniture Home Furnishings 350,625 350,625 374,775 6.9%
MANUFACTURING 09 TOTAL 09 YTD 10 YTD %Diff 443' Electronics Appliances 954,375 954,375 1,003,415 5.1%
311 Food Manufacturing 1,173 1,173 5,995 411.0% 444" Building Material Garden 506,177 506,177 499,394 -1.3
312 Beverage Tobacco Products 3,070 3,070 4895 129.2% 445* Food Beverage Stores 86,349 86,349 101,958 18.1%.
313 Textile Mills 259 259 88 -65.9% 446* Health Personal Care 189,603 189,603 178,919 -5.6%
314 Textile Product Mills 12,852 12,852 13,503 5.1% 448* Clothing Accessories 2,015,184 2,015,184 2,021,704 0.3%
315 Apparel Manufacturing 59 59 38 -35.1% 451' Sporting Goods, Hobby, Books 589,522 589,522 648,678 10.0%
316 Leather Allied Products 7 7 2 -68.5% 452' General Merchandise Stores 2,044,042 2,044,042 2,068,263 1.2
I 321' Wood Product Manufacturing 2,701 2,701 1,627 -39.8% 1 453' Miscellaneous Store Retailers 506,005 506,005 481,324 -4.9%.
I 322' Paper Manufacturing 20,392 20,392 21,585 5.8% 1 454* Nonstore Retailers 209,564 209,564 111,045 .47.0%
I 323* Printing Related Support 59,298 59,298 54,341 -8.4% 1 TOTAL RETAIL TRADE 9 7,451,446 7,451,446 7,489,475
324 Petroleum Coal Products 8,157 8,157 3,062 -62.5% Overall General Retail Change from Previous Year 638,029 0.5%
325 Chemical Manufacturing 6,368 6,368 7,458 17.1%
326 Plastic& Rubber Products 3,928 3,928 3,142 •20.0% YTD
1 327* Nonmetallic Mineral Products 2,279 2,279 3.667 60.9% 1 SERVICES 09 TOTAL 09 YTD 10 YTD Diff
331 Primary Metal Manufacturing 534 534 725 35.8% 51X Information 528,044 528,044 553,763 4.9%
332 Fabricated Metal Mfg Products 3,789 3,789 -2,641 -169.7% 52X Finance Insurance 53,850 53,850 54,281 0.8%
333 Machinery Manufacturing 5,586 5,586 10,120 81.2! 53X Real Estate, Rental, Leasing 412,907 412,907 420,554 1.9%
1 334' Computer Electronic Products 19,797 19,797 5,592 -71.8% 1 541 Professional, Scientific, Tech 227,255 227,255 183,693 -19.2%
335 Electric Equipment, Appliances 137 137 523 281.5% 551 Company Management 985 985 250 -74.6%
336 Transportation Equipment Mfg 135,430 135,430 290,984 114.9% 56X Admin, Supp, Remed Svcs 123,115 123,115 111,875 -9.1%
1 337' Furniture Related Products 8,575 8,575 10,326 20.4% 1 611 Educational Services 47,324 47,324 61,029 29.0%
I 339' Miscellaneous Manufacturing 10,665 10,665 11,140 4.4% I 62X Health Care Social Assistance 91,637 91,637 74,501 18.7%
TOTAL MANUFACTURING 305,059 305,059 440,381 71X Arts Entertainment 93,799 93,799 110,146 17.4%
Overall Manufacturing Change from Previous Year 9135,322 44.4% 1 72X` Accommodation Food Svcs 1,745,512 1,745,512 1,769,600 1.4% 1
81X Other Services 183,887 183,887 185,696 1,0%
YTD 92X Public Administration 32,268 32,268 26.395 -18.2%
TRANSPORTATION WAREHOUSING 09 TOTAL 09 YTD 10 YTD Diff TOTAL SERVICES 1,540,583 3,540,583 3,551,783
481 Air Transportation 0 0 4 0.0% Overall Services Change from Previous Year 611,200 0.3%
482 Rail Transportation 924 924 731 •20,8%
484 Truck Transportation 3,294 3,294 344 -89.6%
485 Transit and Ground Passengers 11,105 11,105 17,813 60.4% YTD
487 Scenic and Sightseeing Tran 0 0 224 #DIV /01 MISCELLANEOUS 09 TOTAL 09 YTD 10 YTD Diff
488 Transportation Support 21,879 21,879 29,089 33.0% 000 Unknown 397 397 43 -89.1%
491 Postal Services 0 0 0 #DIV /0! 111 -115 Agriculture, Forestry, Fishing 221 221 313 41.3%
492 Couriers Messengers 149 149 372 149.6% 211 -221 Mining Utilities 14,549 14,549 14,355 -1.3%
I 493* Warehousing Storage 1,051 1,051 957 -8.9% 1 999 Unclassifiable Establishments 12,331 12,331 100,745 717.0%
TOTAL TRANSP WHSING 38,401 38,401 49,534 MISCELLANEOUS TOTAL 27,499 27,499 115,457
Overall Transportation Change from Previous Year 910,133 29.0% Overall Miscellaneous Change from Previous Year 987,958 319.9%
YID
WHOLESALE TRADE 09 TOTAL 09 YTD 10 YTD Diff YTD
1 423" Whls Trade Durable Goods 1,339,565 1,339,565 1,236,905 -7.7% 1 09 TOTAL 09 YTD 10 YTD Diff
424" Whls Trade Nondurable Goods 105,260 105,260 112,063 6.5% 1 GRAND TOTALS $14,422,090 914,422,090 914,579,951
I 425' Wholesale Electronic Markets 2,208 2,208 2,781 25.9% 1 Grand Total Change from Previous Year $157,861 1.09%
WHOLESALE TRADE TOTAL 1,447,033 1,447,033 1,351,748
Overall Wholesale Change from Previous Year (995,285) -6.6%
I Sales Tax Mitigation NAICS Codes I
(D 02/23/2011 Page 1 IUK Soles lox Rpl 201011.05m
Five Year Comparison
0 i.A. S r :psV F s 3 .a4 r' mii k HJ i z k
2010 1 1!-,' $144,579978
a
a_ 1 .p K r' r ti "9 t- '�'�'�yi� s ,a w j std ,4 a .i #w...., w I.;5 5., r� ;v O', u 5 "r ,tx S' 7....swk I f
2009 I $114
a U"Ft ,w, i „,z,,,,-. i A .`e F o s E u '`c k IIh' x k
C
0 47 752'694§�
r k
1 f`' Y �.,..t,' —n t. -Y r -1 S bt "s, k *i S Yq
2007 1 $19,415,705
I
x L t 4 1- '4€ T "c 5 x 5,4 r r7,�
c'a
2006 I $1 (,54 1
$5,000,000 $10,000,000 $15,000,000 $20,000,000
Taxes Collected Year to Date
20