The URL can be used to link to this page

Home My WebLink AboutFS 2012-03-20 Item 2A - Report - Sales Tax and Miscellaneous Revenue ReportCity of Tukwila FROM: DATE: INFORMATIONAL MEMORANDUM Mayor Haggerton Finance and Safety Committee Jennifer Ferrer -Santa Ines, Senior Fiscal Coordinator March 15, 2012 SUBJECT: Sales Tax and Miscellaneous Revenue Report Year to Date 2011 TO Jim Haggerton, W yor Schedule I -Sales Tax Sales Receipt 2010 2011 in 1,000's 2011 2011 Actual Over (Under) Estimate Constructior Month YTD Month YTD 54 (41) (41) -3.80% -3.80% 76 10 (31) 0.97% -1.47% 118 274 243 23.24% 7.38% 134 150 393 13.61% 8.94% 149 70 463 6.15% 8.37% 125 143 606 11.50% 8.94% 135 (18) 588 -1.39% 7.28% 108 40 628 3.40% 6.79% 125 142 811 11.98% 7.38% 145 186 987 17.95% 8.33% 108 100 813 9.08% 8.40% 114 90 753 5.53% 8.07% 1,391 Mitigation Received 1,217 Schedule I -Sales Tax Sales Receipt 2010 2011 2011 Month Month Actual Estimated Actual Jan Mar 1,034 1,080 1,039 Feb Apr 1,006 1,033 1,043 Mar May 1,157 1,179 1,453 Apr June 1,070 1,102 1,252 May July 1,067 1,138 1,208 June Aug 1,249 1,243 1,386 July Sept 1,251 1,299 1,281 Aug Oct 1,216 1,176 1,216 Sept Nov 1,357 1,185 1,327 Oct Dec 1,082 1,036 1,222 Nov Jan12 1,202 1,101 1,201 Dec Feb 12 1,889 1,628 1,718 Totals 14,580 14,200 15,346 Mitigation Received 1,217 16,563 116.64% of Budget Incl. Mitigation Sales tax collections for December were $171 K below the same month in the previous year and were $90K more than budget representing a 5.5% positive variance. Year -to -date, collections are 8.07% greater than budget and 5.3% greater than the prior year year -to -date collections. Excluding one -time money from new construction, collections are 4.3% behind of last year's collections to date. Including mitigation payments, sales tax collections are currently at 116.64% of budget for the year. Schedule II shows the year -to -date sales tax from the top ten industry classifications. Electronics and Appliances had the highest year over year increase at $396,456 or 40 and Construction of Buildings had an increase of $260,403 or 44 1 INFORMATIONAL MEMO Page 2 Schedule II Of the top ten industry classification codes, there is only one category 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 423 YTD 336 YTD 452 Dollar Group Name Internet Service Providers Current Printing and Related Support Prior Repair and Maintenance Diff. Diff. 448 Clothing and Accessories 2,037,643 2,021,704 15,939 0.79% 452 General Merchandise Stores 2,003,947 2,068,263 (64,317) -3.11% 443 Electronics and Appliances 1,399,871 1,003,415 396,456 39.51% 722 Food Services, Drinking Places 1,337,067 1,341,150 (4,083) -0.30% 423 Wholesale Trade, Durable Goods 1,008,366 1,236,905 (228,538) 18.48% 236 Construction of Buildings 849,322 588,919 260,403 44.22% 451 Sporting Goods, Hobby, Books 642,610 648,678 (6,067) -0.94% 441 Motor Vehicle and Parts Dealer 603,009 596,727 6,282 1.05% 453 Miscellaneous Store Retailers 507,191 481,324 25,866 5.37% 444 Building Material and Garden 487,836 499,394 (11,558) -2.31% Mitigated NAICS Code Of the top ten industry classification codes, there is only one category 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 423 Wholesale Trade, Durable Goods 336 Transportation Equipment Man 452 General Merchandise Stores 517 Telecommunications 518 Internet Service Providers 323 Printing and Related Support 811 Repair and Maintenance 444 Building Material and Garden 451 Sporting Goods, Hobby, Books 531 Real Estate Mitigated NAICS Code YTD YTD Dollar Current Prior Diff. Diff. 1,008,366 1,236,905 (228,538) 18.48% 112,148 290,984 (178,836) 61.46% 2,003,947 2,068,263 (64,317) 3.11% 341,705 373,123 (31,418) -8.42% 85,639 110,122 (24,484) 22.23% 39,915 54,341 (14,427) 26.55% 87,664 101,871 (14,207) 13.95% 487,836 499,394 (11,558) -2.31% 642,610 648,678 (6,067) -0.94% 39,806 45,108 (5,302) 11.75% Attached is a Sales Tax Summary comparing year -to -date 2011 vs. 2010 by major NAICS codes. Below is Schedule IV which shows quarterly gambling tax receipts for last year, and the current year to date. 2 C: 1TemplContent .OutlooklCBK0060Ullnfo Memo Sales Tax 03202012.docx INFORMATIONAL MEMO Page 3 Schedule IV Gambling Tax Actuals Sales 2010 2011 2011 2011 Actual Over (Under) Estimate Quarter Actual Estimated Actual Month YTD Month YTD Jan Mar 502,831 626,451 466,375 (160,076) (160,076) 25.55% 25.55 Apr Jun 483,843 602,795 375,118 (227,677) (387,753) 37.77% 31.54% Jul Sep 390,078 485,978 380,592 (105,386) (493,138) 21.69% 28.75% Oct Dec 549,647 684,777 212,251 (472, 526) (805, 588) 69.00% -40.24% Totals $1,926,399 $2,400,000 1,434,336 373 (69, 343) 0.97% 29.10% includes gambling taxf omcard games only. Gambling receipts for the year is 25.54% lower compared to gambling revenue in the previous year. One casino remains delinquent and still owes $97K on their second quarter taxes. We have contacted the casino to continue to work with them in attempt to collect this amount. Below is Schedule V which shows monthly admission tax receipts for the prior year and current year to date. Schedule V -Admissions Tax Actuals Sales 2010 2011 2011 2011 Actual Over (Under) Estimate Month Actual Estimated Actual Month YTD Month YTD Jan 52,751 57,532 31,217 (26, 315) (26, 315) 45.74% 0.00% Feb 39,232 42,788 30,403 (12,385) (38,701) 28.95% 38.58% Mar 51,861 56,562 39,696 (16,866) (55,566) 29.82% 35.42% Apr 39,294 42,855 28,705 (14,150) (69,717) 33.02% 34.90% May 35,365 38,570 38,944 373 (69, 343) 0.97% 29.10% June 48,428 52,818 57,325 4,508 (64,836) 8.53% 22.27% July 62,293 67,939 50,835 (17,104) (81,940) 25.18% 22.82% Aug 42,284 46,116 42,963 (3,153) (85,093) -6.84% 21.00% Sept 37,853 41,284 28,108 (13,176) (98,270) 31.92% 22.01% Oct 27,638 30,144 27,628 (2,516) (74,470) -8.35% 21.15% Nov 35,594 38,820 39,736 916 (61,169) 2.36% 19.38% Dec 50,036 54,571 43,668 (10,903) (55,206) 19.98% 19.43% Totals 522,628 570,000 459,227 excludes golf course admissions tax Admission tax receipts are currently 19.43% below budget for the year, and 12.13% below prior year actual receipts. Please let me know if you have any comments or questions. Thank you. C:1 Temp \Content.Outlook\CBK0060Ullnfo Memo Sales Tax 03202012.docx 3 El NAICS CONSTRUCTION 10 TOTAL 236 Construction of Buildings 588,919 237 Heavy & Civil Construction 37,857 238 Specialty Trade Contractors 290,486 TOTAL CONSTRUCTION $ 917,262 $ Overall Construction Change from Previous Year 10YTD 588,919 37,857 290,486 917,262 $ SALES TAX SUMMARY December 2011 (Received in February 2012) ,. 11 YTD 849,322 92,837 449,303 1,391,462 $474,200 YTD % Diff 44.2% 145.2% 54.7% NAICS AUTOMOTIVE 10 TOTAL 10 YTD 11 YTD YTD % Diff 51.7% 441' Motor Vehicle & Parts Dealer 596,727 596,727 603,009 1.1% 447" Gasoline Stations 67,583 67,583 68,068 0.7% NAICS TOTAL AUTOMOTIVE $ 664,310 $ Overall Automotive Change from Previous Year RETAIL TRADE 10 TOTAL 664,310 $ 10 YTD 671,077 $6,766 11 YTD 1.0% % Diff YTD MANUFACTURING 10 TOTAL 10 YTD 11 YTD % Diff 442' Furniture & Home Fumishings 374,775 374,775 371,512 -0.9% 443' Electronics & Appliances 1,003,415 1,003,415 1,399,871 39.5% 311 Food Manufacturing 5,995 5,995 3,913 -34.7% 312 Beverage & Tobacco Products -895 -895 3,638 - 506.3% 313 Textile Mills 88 88 661 649.5% 314 Textile Product Mills 13,503 13,503 11,723 -13.2% 315 Apparel Manufacturing 38 38 .544: 1316.0% 316 Leather & Allied Products 2 2 12: 442.1% 444' Building Material & Garden 499,394 499,394 487,836 -2.3% 445' Food & Beverage Stores 101,958 101,958 122,949 20.6% 446' Health & Personal Care 178,919 178,919 214,626 20.0% 448' Clothing & Accessories 2,021,704 2,021,704 2,037,643 0.8% 451' Sporting Goods, Hobby, Books 648,678 648,678 642,610 -0.9% 452' General Merchandise Stores 2,068,263 2,068,263 2,003,947 -3.1% 321' Wood Product Manufacturing 1,627 1,627 : 1,777: 9.2% 453' Miscellaneous Store Retailers 481,324 481,324 • 507,191 5.4% 322* Paper Manufacturing 21,585 21,585 21,239 -1.6% 454' Nonstore Retailers 111,045 111,045 141,173 27.1% 323' Printing 8. Related Support 54,341 54,341 39,915 -26.5% TOTAL RETAIL TRADE $ 7,489,475 $ 7,489,475 $ 7,929,358 324 Petroleum & Coal Products 325 Chemical Manufacturing 326 Plastic & Rubber Products 3,062 7,458 3,142 3,062 7,458 3,142 1,066. 8,549 3,288 -65.2% 14.6% 4.6% 327' Nonmetallic Mineral Products 3,667 3,667 5,843 59.4% 331 Primary Metal Manufacturing 332 Fabricated Metal Mfg Products 333 Machinery Manufacturing 725 -2,641 10,120 725 -2,641 10,120 197 14,421 3,318. -72.8% -646.1% -67.2% 334' Computer & Electronic Products 5,592 5,592 18,739 235.1% 335 Electric Equipment, Appliances 336 Transportation Equipment Mfg 337' Furniture & Related Products 339' Miscellaneous Manufacturing 523 290,984 10,326 11,140 523 290,984 10,326 11,140 440,381 $ TOTAL MANUFACTURING $ 440,381 $ Overall Manufacturing Change from Previous Year TRANSPORTATION & WAREHOUSING 481 Air Transportation 482 Rail Transportation 484 Truck Transportation 485 Transit and Ground Passengers 487 Scenic and Sightseeing Tran 488 Transportation Support 491 Postal Services 492 Couriers & Messengers 10 TOTAL 4 731 344 17,813 224 29,089 0 372 198 112,148 -62.2% -61.5% 10,936 5.9% 11,577 3.9% 10YTD 4 731 344 17,813 224 29,089 0 372 273,702 ($166,679) 11 YTD 73 1,892 6,937 17,288 844 31,327 223 38 -37.8% YTD % Diff 0.0% 158.6% 1915.4% -2.9% 0.0% 7.7% 0.0% -89.8% Overall General Retail Change from Previous Year SERVICES 1 493' Warehousing & Storage 957 957 926 -3.2% TOTAL TRANSP & WHSING $ 49,534 $ Overall Transportation Change from Previous Year WHOLESALE TRADE 10 TOTAL 49,534 $ 10 YTD 59,547 $10,013: 20.2% 11 YTD YTD % Diff 423' Whls Trade - Durable Goods 1,236,905 1,236,905 1,008,366: -18.5% 424' Whls Trade - Nondurable Goods 112,063 112,063 108,078 -3.6% 425' Wholesale Electronic Markets 2,781 2,781 2,199 -20.9% WHOLESALE TRADE TOTAL $ 1,351,748 $ Overall Wholesale Change from Previous Year - Saies Tax Mitigation NAGS Codes 03na/2012 01 51X Information 52X Finance & Insurance 53X Real Estate, Rental, Leasing 541 Professional, Scientific, Tech 551 Company Management 56X Admin, Supp, Reared Svcs 611 Educational Services 62X Health Care Social Assistance 71X Arts & Entertainment 10 TOTAL 553,763 54,281 420,554 183,693 250 111,875 61,029 74,501 110,146 10YTD 553,763 54,281 420,554 183,693 250 111,875 61,029 74,501 110,146 $439,883 11YTD 503,025 74,831 434,933 216,619 109 140,347 66,745 102,103 120,156 5.9% YTD % Diff -9.2% 37.9% 3.4% 17.9% -56.5% 25.4% 9.4% 37.0% 9.1% 1 72X' Accommodation & Food Svcs 1,769,600 1,769,600 1,796,673 1.5% 81X Other Services 92X Public Administration TOTAL SERVICES 185,696 26,395 $ 3,551,783 $ Overall Services Change from Previous Year MISCELLANEOUS 10 TOTAL 000 Unknown 43 111 -115 Agriculture, Forestry, Fishing 339 211 -221 Mining & Utilities 14,355 999 Unclassifiable Establishments 100,745 MISCELLANEOUS TOTAL $ 115,484 $ Overall Miscellaneous Change from Previous Year 10 TOTAL 185,696 26,395 3,551,783 $ GRAND TOTALS - '514,579,978 10 YTD 43 339 14,355 100,745 115,484 $ 10 YTD': 514,579,978 177,493 41,251 56.3% 3,674,285 $122,502 3.4% -0.4% 11 YTD 41 411 2,934 224,338 227,724 $112,241 97.2% YTD % Diff -6.1% 21.2% -79.6% 122.7% 11 YTD YTD % Diff 615,345,798 Grand Total Change from Previous Year 1,351,748 $ 1,118,644 Grand Total Change from Previous Year - Without New Construction ($233,104) -17.2% Page 1 $765,821 $291,620 TUK Sales Tax Rpt 2011 I2.dsx 5.25% 2.13%