Loading...
HomeMy WebLinkAboutFS 2011-11-22 Item 2D - Report - August 2011 Miscellaneous Revenue ReportCity of Tukwila Jim Haggerton, Mayor INFORMATIONAL MEMORANDUM TO FROM DATE Mayor Haggerton Finance and Safety Committee Peggy McCarthy, Interim City Administrator November 15, 2011 SUBJECT: Miscellaneous Revenue Report for August 2011 Schedule I Sales Tax in 1,000's Sales Receipt 2010 2011 2011 -2011 Actual Over (Under) 2011 Estimate-- Month Month Actual Estimated Actual Month YTD Month YTD Jan Mar 1,034 1,080 1,039 (41) (41) -3.80% -3.80% Feb Apr 1,006 1,033 1,043 10 (31) 0.97% -1.47% Mar May 1,157 1,179 1,453 274 243 23.24% 7.38% Apr June 1,070 1,102 1,252 150 393 13.61% 8.94% May July 1,067 1,138 1,278 140 533 12.30% 9.63% June Aug 1,249 1,243 1,386 143 676 11.50% 9.98% July Sept 1,251 1,299 1,281 (18) 658 -1.39% 8.15% Aug Oct 1,216 1,176 1,216 40 698 3.40% 7.55% Sept Nov 1,357 1,185 Oct Dec 1,082 1,036 Nov Jan12 1,202 1,101 Dec Feb12 1,889 1,628 Totals 14,580 14,200 9,948 Mitigation Received 917 10,865 106.87% of Budget Incl. Mitigation Sales tax collections for August were level as compared with the same month in the previous year and were $40K more than budget representing a 3.40% increase. Year -to -date, collections are 7.55% greater than budget and 9.92 greater than the prior year year -to -date collections. Excluding one -time money from new construction, collections are 5.87% ahead of last year's collections to date. Including mitigation payments, sales tax collections are currently at 106.87% of budget for the year. Mitigation payments are now annualized and will only be adjusted once per year in the fall, effective with the December 31 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. Electronics and Appliances had the highest increase at $326,174 or 56 and Construction of Buildings had an increase of $248,023 or 71 The largest decline of $114,154 or 13.7% occurred with the Wholesale Trade, Durable Goods category. 41 INFORMATIONAL MEMO Page 2 Schedule II Mitigated NAICS Code As illustrated above, four of the top ten merchant categories have declined versus prior year, and all but two 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. 448 Clothing and Accessories 1,258,464 1,227,421 31,043 452 General Merchandise Stores 1,231,694 1,259,921 (28,228) 443 Electronics and Appliances 907,900 581,726 326,174 722 Food Services, Drinking Places 879,705 884,514 (4,809) 423 Wholesale Trade, Durable Goods 713,809 827,963 (114,154) 236 Construction of Buildings 597,632 349,609 248,023 441 Motor Vehicle and Parts Dealer 400,251 400,001 250 451 Sporting Goods, Hobby, Books 393,075 391,607 1,469 444 Building Material and Garden 333,925 344,724 (10,799) 721 Accommodation 317,304 286,476 30,828 Mitigated NAICS Code As illustrated above, four of the top ten merchant categories have declined versus prior year, and all but two 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 Mitigated NAICS Code Attached is a Sales Tax Summary comparing year -to -date 2011 vs. 2010 by major NAICS codes. Also included is a comparison of total receipts year -to -date for the last six years. Below is Schedule IV which shows quarterly gambling tax receipts for last year, and the current year to date. W:1FIN Projects\Sales Tax Information120111Info Memo Sales Tax 10312011.docx 42 YTD YTD Dollar Group Name Current Prior Diff. 423 Wholesale Trade, Durable Goods 713,809 827,963 (114,154) 517 Telecommunications 224,878 250,889 (26,011) 336 Transportation Equipment Man 75,715 88,856 (13,141) 811 Repair and Maintenance 56,928 66,608 (9,680) 611 Educational Services 37,640 40,979 (3,339) 531 Real Estate 22,721 25,850 (3,129) 323 Printing and Related Support 28,625 31,337 (2,712) 512 Motion Picture, Sound Record 18,963 21,287 (2,324) 322 Paper Manufacturing 12,862 14,094 (1,232) 485 Transit and Ground Passengers 11,837 12,368 (531) Mitigated NAICS Code Attached is a Sales Tax Summary comparing year -to -date 2011 vs. 2010 by major NAICS codes. Also included is a comparison of total receipts year -to -date for the last six years. Below is Schedule IV which shows quarterly gambling tax receipts for last year, and the current year to date. W:1FIN Projects\Sales Tax Information120111Info Memo Sales Tax 10312011.docx 42 INFORMATIONAL MEMO Page 3 Schedule IV Gambling Tax 2010 2011 Month Actual Actuals Sales 2010 2011 2011 2011 Actual Over /(Under) 2011 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 377,513 (225,282) (385,359) 37.37% 31.35% Jul Sep 390,078 485,978 380,592 (105,386) (490,745) 21.69% 28.61% Oct Dec 549,647 684,777 31.92% -22.01% Totals $1,926,399 $2,400,000 1,224,479 Gambling receipts are currently $490,745 under budget through September 2011, or 28.61% below budget. Actual receipts for 2011 are 11 below actual receipts to date in 2010. However, this is largely due to one of the casinos being late with their second quarter tax payment. Below is Schedule V which shows monthly admission tax receipts for the prior year and current year to date. Schedule V -Admissions Tax Sales 2010 2011 Month Actual Estimated Jan 52,751 57,532 Feb 39,232 42,788 Mar 51,861 56,562 Apr 39,294 42,855 May 35,365 38,570 June 48,428 52,818 July 62,293 67,939 Aug 42,284 46,116 Sept 37,853 41,284 Oct 27,638 30,144 Nov 35,594 38,820 Dec 50,036 54,571 Totals 522,628 570,000 Actua Is 2011 2011 Actual Over /(Under) 2011 Estimate Actual Month YTD Month YTD 31,217 (26, 315) (26, 315) 45.74% 0.00% 30,403 (12,385) (38,701) 28.95% 38.58% 39,696 (16,866) (55,566) 29.82% 35.42% 28,705 (14,150) (69,717) 33.02% 34.90% 38,944 373 (69, 343) 0.97% 29.10% 57,325 4,508 (64,836) 8.53% 22.27% 50,835 (17,104) (81, 940) 25.18% 22.82% 42,963 (3,153) (85, 093) -6.84% 21.00% 28,108 (13,176) (98,270) 31.92% -22.01% 348,196 Admission tax receipts are currently 22.01% below budget for the year, and 17% below prior year actual receipts. The decline with one of the largest taxpayers is due to a decline in economic activity for that industry, a movie theater, and may also be related to the road closure related to the Southcenter Access Project. Also, it is expected that there will be an increase in admission tax payments with the recent opening of the Fly indoor skydiving facility near the mall. Please let me know if you have any comments or questions. Thank you. WAFIN Projects\Sales Tax In formation1201111nfo Memo Sales Tax 10312011.docx 43 x 1 1 SALES TAX SUMMARY August 2011 (Received in October) NAICS CONSTRUCTION 236 Construction of Buildings 237 238 10 TOTAL 588,919 Heavy & Civil Construction 37,857 Specialty Trade Contractors 290,486 TOTAL CONSTRUCTION $ 917,262 $ Overall Construction Change from Previous Year 10 YTD 349,609 14,779 171,913 536,301 $ 11 YTD 597,632 30,509 276,074 904,215 $367,915 YTD % Diff 70.9% 106.4% 60.6% NAICS AUTOMOTIVE 10 TOTAL 10 YTD 11 YTD YTD % Diff 441' Motor Vehicle & Parts Dealer 596,727 400,001 400,251 0.1% 447* Gasoline Stations 67,583 44,675 46,529 4.2% 68.6% NAICS TOTAL AUTOMOTIVE $ 664,310 $ Overall Automotive Change from Previous Year RETAIL TRADE 10 TOTAL 444,676 $ 10 YTD 446,780 $2,104 11 YTD % Diff 0.5% YTD MANUFACTURING 10 TOTAL 10 YTD 11 YTD % Diff 442* Furniture & Home Furnishings 374,775 244,443 241,325 -1.3% 443* Electronics & Appliances 1,003,415 581,726 907,900 56.1% 311 Food Manufacturng 5,995 2,165 2,735 26.4% 312 Beverage & Tobacco Products -895 -2,375 2,314 - 197.4% 313 Textile Mills 88 52 439 738.5% 314 Textile Product Mills 13,503 9,666 6,881 -28.8% 315 Apparel Manufacturing 38 15 411 2682.7% 316 Leather& Allied Products 2 1 5 288.6% 444* Building Material & Garden 499,394 344,724 333,925 -3.1% 445* Food & Beverage Stores 101,958 57,282 82,813 44.6% 446* Health & Personal Care 178,919 111,415 138,684 24.5% 448* Clothing & Accessories 2,021,704 1,227,421 1,258,464 2.5% 451" Sporting Goods, Hobby, Books 648,678 391,607 393,075 0.4% 452* General Merchandise Stores 2,068,263 1,259,921 1,231,694 -2.2% 321* Wood Product Manufacturing 1,627 1,112 1,312 18.0% 453* Miscellaneous Store Retailers 481,324 296,149 304,764 2.9% 322* Paper Manufacturing 21,585 14,094 12,862 -8.7% 454* Nonstore Retailers 111,045 64,730 77,782 20.2% 323* Printing & Related Support 54,341 31,337 28,625 -8.7% TOTAL RETAIL TRADE $ 7,489,475 $ 4,579,417 $ 4,970,426 324 Petroleum & Coal Products 325 Chemical Manufacturing 326 Plastic & Rubber Products I 327* Nonmetallic Mineral Products 3.062 7,458 3.142 2,641 4,869 2,097 1,273 6,373 2,837 -51.8% 30.9% 35.3% 3,667 761 3,646 379.3% Overall General Retail Change from Previous Year SERVICES 331 Primary Metal Manufacturing 332 Fabricated Metal Mfg Products 333 Machinery Manufacturing 334* Computer & Electronic Products 725 -Z641 10,120 219 4,463 7,492 181 2,436 1,366 -17.3% -45.4% -81.8% 5,592 3,015 11,278 274.0% 335 Electric Equipment, Appliances 336 Transportation Equipment Mfg 337* Furniture & Related Products 339* Miscellaneous Manufacturing 523 290,984 10,326 11,140 125 88,856 6,752 7,060 184,417 $ TOTAL MANUFACTURING $ 440,381 $ Overall Manufacturing Change from Previous Year TRANSPORTATION & WAREHOUSING 481 Air Transportation 482 Rai Transportation 484 Truck Transportation 485 Transit and Ground Passengers 487 Scenic and Sightseeing Tran 488 Transportation Support 491 Postal Services 492 Couriers & Messengers 493' Warehousing & Storage 10 TOTAL 126 1.0% 75,715 -14.8 % 6,237 -7.6% 7,406 4.9% 4 731 344 17,813 0 29,089 0 372 10 YTD 0 254 165 12,368 0 19,724 0 236 174,459 (69,958) 11 YTD 44 506 3,680 11,837 579 19,830 223 21 YTD % Diff 0.0% 99.6% 2126.3% -4.3% #DIV /0! 0.5% #DIV /0! -90.9% -5.4% 957 696 647 -7.0 TOTAL TRANSP & WHSING $ 49,309 $ Overall Transportation Change from Previous Year WHOLESALE TRADE 10 TOTAL 33,443 $ 10 YTD 37,369 $3,925 11 YTD YTD % Diff 11.7% 423* Whls Trade - Durable Goods 1,236,905 827,963 713,809 -13.8% 424* Whls Trade - Nondurable Goods 112,063 66,641 63,956 425" Wholesale Electronic Markets 2,781 1,662 1,152 -30.7% WHOLESALE TRADE TOTAL $ 1,351,748 $ Overall Wholesale Change from Previous Year ' Sales Tax Mitigation NAICS Codes 11/15/2011 896,266 $ 778,917 ($117,349) -13.1% 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 10 TOTAL 553,763 54,281 420,554 183,693 250 111,875 61,029 74,501 110,146 10 YTD 348,630 29,935 261,497 102,954 218 69,426 40,979 43,854 80,215 $391,009 11 YTD 354,931 49,526 285,115 120,473 106 93,264 37,640 58,010 84,427 YTD % Diff 1.8% 65.4% 9.0% 17.0% -51.5 34.3% -8.1% 32.3% 5.3% 8.5% 72X* Accommodation & Food Svcs 1,769,600 1,170,989 1,197,009 2.2% 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 313 211 -221 Mining & Utilities 14,355 999 Unclassifiable Establishments 100,745 MISCELLANEOUS TOTAL $ 115,457 $ Overall Miscellaneous Change from Previous Year Page 1 10 TOTAL 120,096 18,186 2,286,977 $ 10 YTD 1 197 11,142 76,636 87,976 $ 10 YTD 117,145 25,666 2,423,312 $136,334 11 YTD -2.5% 41.1% YTD % Diff 0 - 100.0% 5.2% -78.2% 173.9% 208 2,428 209,943 212,579 $124,603 6.0% 11 YTD YTD % Diff 141.6% GRAND TOTALS $14,579,726 $9,049,473 $9,948,057 Grand Total Change from Previous Year Grand Total Change from Previous Year - Without New Construction $898,584 $530,669 /00 Sales lox Rpl 201108.nisx 9.93% 6.23% 2011 2010 cu L. 2009 a) >- 2008 2007 2006 Six Year Comparison 12,350,940 $11,361,835 $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 Sales Taxes Collected Year to Date $12,000,000