HomeMy WebLinkAboutFS 2010-11-16 Item 2E - Report - August 2010 Sales Tax Revenue Report (r-
L4
Ci ty of Tukwila
1. J im Haggerton, Mayor
240 INFORMATIONAL MEMORANDUM
TO: Mayor Haggerton
Finance and Safety Committee
FROM: Shawn Hunstock, Finance Director
DATE. October 25, 2010
SUBJECT: Sales Tax Revenue for August 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,682) (5,724) 100.00% 38.74%
Oct Dec 1,032 1,556 (1, 556) (7,280) 100.00% 44.58%
Nov Jan11 1,140 1,631 (1,631) (8,911) 100.00% 49.61%
Dec Feb11 1,690 2,270 (2,270) (11,181) 100.00% 55.27%
Totals 14,422 20,231 9,050
Mitigation Received 934
9,984 76 26% of Budget Incl. Mitigation
Sales tax collections for August showed the third increase this year, as compared to the same
month in the prior year, through eight months of collections. For August, collections were less
than budget for the month, but more than actual collections in the same month in the previous
year. Actual receipts for August were $440,000 less than budget, but $98,000 more than the
same period last year. This is the largest monthly increase that we have had all year. We are
down 26.57% for the month compared to budget, and up by 8.06% compared to the same
month last year. We are now down in total 30.87% for the year compared to budget, and down
by 4.23% compared to the same period last year.
Including mitigation payments, we are currently at'76.26% of budget for the year to date. The
latest mitigation payment we received was on September 30, 2010 and was 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 31s payment. The next mitigation payment will be received on December 31s
51
INFORMATIONAL MEMO
Page 2
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 1,259,921 $1,254,724 5,198 0.41%
448* Clothing and Accessories 1,227,421 1,253,823 (26,402) -2.11%
722* Food Services, Drinking Places 884,514 864,005 20,509 2.37%
423* Wholesale Trade, Durable Goods 827,963 988,595 (160,631) 16.25%
443* Electronics and Appliances 581,726 590,102 (8,376) -1 42%
441* Motor Vehicle and Parts Dealer 400,001 493,593 (93,592) 18.96%
451* Sporting Goods, Hobby, Books 391,607 353,100 38,507 10.91%
236 Construction of Buildings 349,609 343,608 6,001 1.75%
444* Building Material and Garden 344,724 343,448 1,276 0.37%
453* Miscellaneous Store Retailers 296,149 324,505 (28,356) 8.74%
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 18.96 and Wholesale Trade and
Durable Goods is down by 16.25 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 14,779 47,311 (32,533) 68.76%
454* Nonstore Retailers 64,730 164,250 (99,521) 60.59%
238 Specialty Trade Contractors 171,913 244,689 (72,776) -29 74%
621 Ambulatory Health Care Service 28,046 37,938 (9,891) 26.07%
323* Printing and Related Support 31,337 40,714 (9,377) 23.03%
441* Motor Vehicle and Parts Dealer 400,001 493,593 (93,592) 18.96%
423* Wholesale Trade, Durable Goods 827,963 988,595 (160,631) -16 25%
561 Administrative and Support Svc 66,534 78,683 (12,150) 15.44%
812 Personal and Laundry Services 53,286 62,204 (8,918) 14.34%
721* Accommodation 286,476 320,146 (33,671) 10.52%
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 \FIN Projects\Sales Tax Information\Sales Tax Files from Shawn120101Info Memo Sales Tax 102510.docx
52
SALES TAX SUMMARY
August 2010 (Received in October)
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 343,608 349,609 1.7% 1 441' Motor Vehicle &Parts Dealer 686,478 493,593 400,001 -19.0% I
237 Heavy& Civil Construction 98,105 47,311 14,779 -68.8% I 447' Gasoline Stations 62,584 41,647 44,675 7.3% I
238 Specialty Trade Contractors 347,910 244,689 171,913 -29.7% TOTAL AUTOMOTIVE 749,063 535,240 444,676
TOTAL CONSTRUCTION 863,006 635,608 536,301 Overall Automotive Change from Previous Year ($90,564) -16.9%
Overall Construction Change from Previous Year ($99,308) -15.6%
NAICS RETAIL TRADE 09 TOTAL 09 YTD 10 YTD 0iff
YTD 442' Furniture Home Fumishings 350,625 222,203 244,443 10.0%
MANUFACTURING 09 TOTAL 09 YTD 10 YTD %Diff 443' Electronics Appliances 954,375 590,102 581,726 -1.4%
311 Food Manufacturing 1,173 846 2,165 155.8% 444' Building Material Garden 506,177 343,448 344,724 0.4%
312 Beverage Tobacco Products 3,070 1,988 -2,375 219.5% 445' Food Beverage Stores 86,349 56,790 57,282 0.9%
313 Textile Mills 259 158 52 -66.8% 446* Health Personal Care 189,603 119,483 111,415 -6.8%
314 Textile Product Mills 12,852 8,536 9,666 13.2% 448' Clothing Accessories 2,015,184 1,253,823 1,227,421 -2.1%
315 Apparel Manufacturing 59 37 15 -59.6% 451' Sporting Goods, Hobby, Books 589,522 353,100 391,607 10.9%
316 Leather Allied Products 7 4 1 -6451/4 452' General Merchandise Stores 2,044,042 1,254,724 1,259,921 0.4%
321' Wood Product Manufacturing 2,701 2,148 1,112 -48.3% 1 453' Miscellaneous Store Retailers 506,005 324,505 296,149 -8.7%
322* Paper Manufacturing 20,392 12.871 14,094 9.5% 1 454' Nonstore Retailers 209,564 164,250 64,730 -60.6%
323' Printing Related Support 59,298 40,714 31,337 -23.0% I TOTAL RETAIL TRADE 7,451,446 4,682,428 4,579,417
324 Petroleum Coal Products 8,157 3,347 2,641 -21.1% Overall General Retail Change from Previous Year ($103,011) -2.2%
325 Chemical Manufacturing 6,368 4,295 4,869 13.4%
326 Plastic Rubber Products 3.928 3.108 2,097 -32.5% YTD
327' Nonmetallic Mineral Products 2,279 1,251 761 -39.2% 1 SERVICES 09 TOTAL 09 YTD 10 YTD Diff
331 Primary Metal Manufacturing 534 126 219 743% 51X Information 528,044 349,905 348,630 -0.4%
332 Fabricated Metal Mfg Products 3,789 2,255 4,463 97.9% 52X Finance Insurance 53,850 28,482 29,935 5.1%
333 Machinery Manufacturing 5,586 5,000 7,492 49.8% 53X Real Estate, Rental, Leasing 412,907 248,641 261,497 5.2%
334' Computer Electronic Products 19.797 12,625 3,015 -76.1% 1 541 Professional, Scientific, Tech 227,255 111,760 102,954 -7.9%
335 Electric Equipment, Appliances 137 90 125 38.8% 551 Company Management 985 737 218 -70.5%
336 Transportation Equipment Mfq 135.430 93,095 88,856 -4.6% 56X Admin, Supp, Remed Svcs 123,115 83,307 69,426 -16.7%
337" Fumiture Related Products 8,575 6,532 6,752 3.4% 1 611 Educational Services 47,324 27,176 40,979 50.8%
339" Miscellaneous Manufactudnq 10,665 7,787 7,060 -9.3% 1 62X Health Care Social Assistance 91,637 51,498 43,854 -14.8%
TOTAL MANUFACTURING 305,059 206,811 184,417 71X Arts Entertainment 93,799 66,210 80,215 21.2%
Overall Manufacturing Change from Previous Year ($22,394) -i0.8% 1 72X' Accommodation Food Svcs 1,745,512 1,184,151 1,170,989 -1.1% 1
81X Other Services 183,887 120,814 120,096 -0.6%
YTD 92X Public Administration 32,268 15,190 18,186 19.7%
TRANSPORTATION WAREHOUSING 09 TOTAL 09 YTD 10 YTD Diff TOTAL SERVICES 3,540,583 2,287,871 2,286,977
481 Air Transportation 0 0 0 0.0% Overall Services Change from Previous Year ($893) 0.0%
482 Rail Transportation 924 843 254 -69.9%
484 Truck Transportation 3,294 1,898 165 -91.3%
485 Transit and Ground Passengers 11,105 7,505 12,368 64.8% YTD
488 Transportation Support 21,879 15,753 19,724 25.2% MISCELLANEOUS 09 TOTAL 09 YTD 10 YTD Diff
491 Postal Services 0 0 0 #DIV /0! 000 Unknown 397 397 1 -9931/4
492 Couriers Messengers 149 33 236 607.5% 111 -115 Agriculture, Forestry, Fishing 221 87 197 126.1%
I 493' Warehousing Storage 1,051 788 696 -11.7% 1 211 -221 Mining Utilities 14,549 11,038 11,142 0.9%
TOTAL TRANSP WHSING 38,401 26,820 33,443 999 Unclassifiable Establishments 12,331 3,256 76,636 2253.5%
Overall Transportation Change from Previous Year $6,623 24.7% MISCELLANEOUS TOTAL 27,499 14,779 87,976
Overall Miscellaneous Change from Previous Year 673,197 495.3%
YTD
WHOLESALE TRADE 09 TOTAL 09 YTD 10 YTD Diff
1 423' Whls Trade Durable Goods 1,339,565 988,595 827,963 -16.2% 1 YTD
1 424" Whls Trade Nondurable Goods 105.260 71.462 66.641 -6.7% 1 09 TOTAL 09 YTD 10 YTD Diff
425' Wholesale Electronic Markets 2,208 1,344 1,662 23.6% 1 GRAND TOTALS 514,422,090 59,450,958 59,049,473
WHOLESALE TRADE TOTAL 1,447,033 1,061,401 896,266 Grand Tota Change from Previous Year (6401,485) -4.25%
Overall Wholesale Change from Previous Year ($165,135) -15.6%
1 Sales Tax Mitigation NAICS Codes I
Cal
W 10/25/2010 Page 1 TUK Soles no Rpt 201000.xlsm
Five Year Comparison
.r-- ,h�.:d> uz Y: f.:o;1' i i;..C'�` y� ;n.5, yl +h° ;=•iae 'F.:''�t` i „f`- y j k F Ct,
I•� y l. '..e 1 rix,;: �:iY.• a,c.%�v"�:t'[,- I
k?: .�:IKV .6 ._1 ..rsx ::f
2010 I ri}
u
2009 I I
L.
o
2008 i 1 wi, -4 ti:.
l a too 5 e ,4 2 »y t a, 5.. f 3 :3;
1::::::::,.- Se '�e` 5 e ?nM rte ��h;�;- 2007 I 12 19
2006 I may[ �y s& 11,;�i'L, 54:i I
"::;'.T;3 7Jf: K5 i^ �3,', :k a 'SF' aF `•3'sr`.$ .a �1:� i N s §35 1
$2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000
Taxes Collected Year to Date
5