The URL can be used to link to this page

Home My WebLink AboutFS 2010-09-08 Item 2E - Report - June 2010 Sales Tax Revenue ReportTO: City of Tukwila INFORMATIONAL MEMORANDUM Mayor Haggerton Finance and Safety Committee FROM: Shawn Hunstock, Finance Director DATE: August 23, 2010 SUBJECT: Sales Tax Revenue for June 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,793) (4,853) 100.00% 42.44% Aug Oct 1,118 1,656 (1,656) (6,509) 100.00% -49 72% Sept Nov 1,110 1,682 (1,682) (8,191) 100.00% -5544% Oct Dec 1,032 1,556 (1,556) (9,747) 100.00% -59 69% Nov Jan11 1,140 1,631 (1,631) (11,378) 10000% 63.35% Dec Feb11 1,690 2,270 (2,270) (13,648) -100 00% 67.46% Totals 14,422 20,231 6,583 Mitigation Received 623 7,206 74 73% of Budget Incl. Mitigation Jim Haggerton, Mayor Sales tax collections for June showed the second increase this year through six months of collections. For June, collections were less than budget but more than the same month in the previous year. Actual receipts for June were $564,000 less than budget, but $30,000 more than the same period last year. We are down 31.18% for the month compared to budget, and up by 2.47% compared to the same month last year. We are now down in total 31.73% for the year compared to budget, and down by 4.02% compared to the same period last year. The chart above also includes the mitigation payment we received at the end of June. Including the mitigation payments, we are currently at 74.74% of budget for the year to date. The latest mitigation payment we received was on June 30, 2010 and was for $311,098.16. 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. The next mitigation payment will be received on September 30 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. 33 34 INFORMATIONAL MEMO Page 2 Schedule 11 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 Group Name 452* General Merchandise Stores 448* Clothing and Accessories 722* Food Services, Drinking Places 423* Wholesale Trade, Durable Goods 443* Electronics and Appliances 441 Motor Vehicle and Parts Dealer 451* Sporting Goods, Hobby, Books 444* Building Material and Garden 236 Construction of Buildings 453* Miscellaneous Store Retailers Mitigated NAICS Code As you can see there are large variances from last year for the same time period. For instance, sales tax for Construction of Buildings is down by 22.54 and Motor Vehicle and Parts Dealer is down by 19.07 As you can see from Schedule II, eight 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 Group Name 238 Specialty Trade Contractors 621 Ambulatory Health Care Service 323* Printing and Related Support 445* Food and Beverage Stores 236 Construction of Buildings 561 Administrative and Support Svc 441* Motor Vehicle and Parts Dealer 336 Transportation Equipment Man 453* Miscellaneous Store Retailers 812 Personal and Laundry Services Mitigated NAICS Code YTD YTD Dollar Current Prior Diff. Diff. 888,669 890,946 (2,277) 0.26% 870,515 882,220 (11,705) 1.33% 660,216 631,684 28,533 4.52% 596,545 631,515 (34,971) 5.54% 433,662 451,136 (17,473) -3.87% 302,191 373,376 (71,185) 19.07% 286,712 262,385 24,327 9.27% 249,590 251,019 (1,429) 0.57% 243,147 313,907 (70, 760) 22.54% 221,936 253,911 (31,975) 12.59% YTD Current 113,854 20,725 24,105 31,984 243,147 52,335 302,191 66,091 221,936 40,957 WARN Projects\Sales Tax Information\Sales Tax Files from Shawn120101Info Memo Sales Tax 082310.docx YTD Dollar Prior Diff. Diff. 200,019 (86,165) -43 08% 30,299 (9,574) 31.60% 32,116 (8,011) 24.94% 42,023 (10,039) 23.89% 313,907 (70,760) 22.54% 64,705 (12,370) -19 12% 373,376 (71,185) 19.07% 78,502 (12,411) 15.81% 253,911 (31,975) 12.59% 46,462 (5,505) 11.85% 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. NAICS CONSTRUCTION 09 TOTAL 236 Construction of Buildings 416,992 237 Heavy Civil Construction 98,105 238 SpecialtyTradeContractors 347,910 TOTAL CONSTRUCTION 861006 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 W 333 Machinery Manufacturing 5,586 334" Computer Electronic Products 19,797 335 Electric Equipment, Appliances 137 336 Transportation Equipment Mfg 135,430 337' Furniture Related Products 8,575 339" Miscellaneous Manufacturing 10,665 TOTAL MANUFACTURING 305,059 Overall Manufacturing Change from Previous Year 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 Sales Tax Mitigation NAICS Codes 1 WHOLESALE TRADE 09 TOTAL 423' WhIs Trade Durable Goods 1,339,565 424' WhIs Trade Nondurable Goods 105,260 425' Wholesale Electronic Markets 2,208 WHOLESALE TRADE TOTAL 1,447,033 Overall Wholesale Change from Previous Year 08/23/2010 09 TOTAL 1,173 3,070 259 12,852 59 7 2,701 20,392 59,298 8,157 6,368 3,928 2,279 534 3,789 09 TOTAL 0 924 3,294 11,105 21,879 149 1,051 38,401 Overall Transportation Change from Previous Year 09YTD 313,907 37,267 200,019 551,192 6 09 YTD 680 1,441 155 6,196 37 4 1.778 9,902 32,116 2,795 3,179 1,780 1,109 60 1,702 2,084 9,952 90 78,502 5,096 6,358 165,015 09 YTD 800 1,366 5,660 11,930 0 30 579 20,365 09 YTD 631,515 54,197 1,034 686,746 10YTD 243,147 10,570 113,854 367,571 (5183,622) 10YTD 1,349 -2,810 24 8,497 1 1 716 11,088 24,105 1,294 3,525 1,476 512 251 3,414 6,860 2,277 109 66,091 5,212 5,457 139,448 (525,567) SALES TAX SUMMARY June 2010 (Received in August) 10 YTD 225 114 9,822 8,432 180 519 19,291 ($1,074) 10 YTD 596,545 49,799 1,242 647,586 x$39,160) YTD Diff -22.5% -71.6% -43.1% YTD Diff 98.4% -295.0% -842% 371% -95.9% -645% 59.7°/ 12.0% 24.9% -517% 10.9% -17 1 -519% 320.1% 100.6% 229.1% -77 1% 21.0% -15.8% /3% -14.2% YTD Diff 0 0.0 -71.8% -91.7% 73.5% -29.3% ItDIV10! 495.6% -10.4% YTD Diff -5.5% -8.1% 20.1% -33.3% NAICS 442' 443' 444' 445* 446' 448" 451' I 452' 1 1 453' 1 1 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 -75.5% 1 72X' Accommodation Food Svcs 81X Other Services 92X Public Administration TOTAL SERVICES MISCELLANEOUS 09 TOTAL 000 Unknown 397 111 -115 Agriculture, Forestry, Fishing 221 I 211 -221 Mining Utilities 14,549 999 Unclassifiable Establishments 12,331 -5.3% MISCELLANEOUS TOTAL 27,499 Overall Miscellaneous Change from Previous Year -5.7% NAICS 441' 447* Page 1 AUTOMOTIVE Motor Vehicle Parts Dealer Gasoline Stations TOTAL AUTOMOTIVE RETAIL TRADE Furniture Horne Fumishings 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 09 TOTAL 686,478 62,584 749,063 Overall Automotive Change from Previous Year 09 TOTAL 350,625 954,375 506,177 86,349 189,603 2,015,184 589,522 2,044,042 506,005 209,564 7,451,446 Overall General Retail Change from Previous Year 09 TOTAL 528,044 53,850 412,907 227,255 985 123,115 47,324 91,637 93,799 1,745,512 183,887 32,268 3,540,583 Overall Services Change from Previous Year 09 TOTAL GRAND TOTALS 514,422,090 Grand Total Change from Previous Year 09 YTD 373,376 29,918 403,294 09 YTD 169,446 451,136 251,019 42,023 88,208 882,220 262,385 890,946 253,911 43,677 3,334,971 09 YTD 273,505 21,179 169,114 89,344 540 68,124 17,596 40,434 44,383 861,680 90,867 11,809 1,688,574 09 YTD 397 80 6,845 2,130 9,451 09 YTD $6,859,608 10 YTD 302,191 31.738 333,929 ($69,364) 10 YTD 181,493 433,662 249,590 31,984 83,137 870,515 286,712 888,669 221,936 48,247 3,295,946 (339,025) 10YTD 279,545 23,717 172,602 83,749 201 54,417 30,253 32,484 53,772 874,460 91,721 11,577 1,708,496 $19,922 10 YTD 1 151 7,007 63,503 70,661 361,210 TUK Soles Tax Rpl 201006.xIsm YTD Diff 19.1° 6.1% Diff 7.1% -3.9% -0.6% -219% -5.7% -1.3% 9.3% -0.3% -12.6% 10.5% YTD Diff 2.2°% 12.0% /1% -6.3% -62.9% -20.1% 71.9% -19.7% 21.2% 1.5% 0.9 -2,0 YTD Diff -99.7% 88.6% 2.4% 2881.4% YTD Diff -172% -1.2% 1.2% 647.6% 10 YTD $6,582,928 (3276,680) -403% 36 2010 1 2009 2008 2007 2006 Five Year Comparison $2,000,000 $4,000,000 $6,000,000 Taxes Collected Year to Date $8,000,000 $10,000,000