The URL can be used to link to this page

Home My WebLink AboutFS 2011-12-06 Item 2D - Report - September 2011 Miscellaneous Revenue ReportCity of Tukwila Jim Haggerton, Mayor INFORMATIONAL MEMORANDUM TO: FROM: DATE: SUBJECT Mayor Haggerton Finance and Safety Committee Peggy McCarthy, Interim City Administrator November 30, 2011 Miscellaneous Revenue Report for September 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 1,327 142 881 11.98% 8.05% Oct Dec 1,082 1,036 Nov Jan12 1,202 1,101 Dec Feb12 1,889 1,628 Totals 14,580 14,200 11,275 Mitigation Received 917 12,192 119.92% of Budget Incl. Mitigation September sales tax collected from construction NAICS codes 236, 237 and 238 totaled $1 -028 (thousand). Sales tax collections for September were $30K below the same month in the previous year. The decline is due to an $70K adjustment made by the Department of Revenue reducing the November remittance. This resulted from a DOR processing error made in June and reflected in that remittance. Without the adjustment, the September sales tax collections would have been $40K more than the same month in the prior year. Even with the adjustment, the September sales tax collections were $142K more than budget representing a 11.98% positive variance. Year -to -date, collections are 8.05% greater than budget and 8.34 greater than the prior year year -to -date collections. Excluding one -time money from new construction, collections are 4.71 ahead of last year's collections to date. Including mitigation payments, sales tax collections are currently at 119.92% of budget for the year. 75 INFORMATIONAL MEMO Page 2 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 $384,040 or 56 and Construction of Buildings had an increase of $224,718 or 71 The largest decline of $151,600 or 13.8% occurred with the Wholesale Trade, Durable Goods category. Schedule 11 Name 423 Wholesale Trade, Durable Goods '452 General Merchandise Stores YTD YTD Dollar Group Name Current Prior Diff. 448 Clothing and Accessories 1,435,788 1,412,724 23,064 452 General Merchandise Stores 1,396,684 1,439,361 (42,677) 443 Electronics and Appliances 1,053,382 669,342 384,040 722 Food Services, Drinking Places 991,603 1,007,646 (16,043) X 423 Wholesale Trade, Durable Goods 796,701 948,301 (151,600) '236 Construction of Buildings 656,334 431,616 224,718 X 441 Motor Vehicle and Parts Dealer 449,160 447,358 1,802 P 451 Sporting Goods, Hobby, Books 448,770 448,556 214 444 Building Material and Garden 377,643 386,918 (9,275) 721 Accommodation 359,007 327,713 31,294 Mitigated NAICS Code As illustrated above, three of the top ten merchant categories have declined versus prior year. Of the top ten industry classification codes, all but two 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 423 Wholesale Trade, Durable Goods '452 General Merchandise Stores 1 517 Telecommunications "336 Transportation Equipment Man 722 Food Services, Drinking Places 1 811 Repair and Maintenance X 444 Building Material and Garden `323 Printing and Related Support 442 Furniture and Home Furnishings P 424 Wholesale Trade, Nondurable Mitigated NAICS Code YTD YTD Dollar Current Prior Diff. 796,701 948,301 (151,600) 1,396,684 1,439,361 (42, 677) 251,846 284,343 (32,496) 88,583 118,162 (29, 579) 991,603 1,007,646 (16,043) 63,293 78,714 (15,420) 377,643 386,918 (9,275) 32,831 39,261 (6,431) 271,656 277,092 (5,435) 76,654 81,969 (5,315) 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. WAFIN ProjectslSales Tax In formation120111Info Memo Sales Tax 11282011.docx 76 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 57,325 4,508 (64,836) Totals $1,926,399 $2,400,000 1,224,479 50,835 (17,104) (81, 940) 25.18% includes gamblingtaxfromcard games only. Gambling receipts for the third quarter were reported with the August Sales Tax report. The fourth quarter tax receipts are due January 31, 2011. One casino still owes $97K on their second quarter taxes. We have contacted the casino and continue to 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 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 excludes golf course admissions tax 373,978 Admission tax receipts are currently 21.53% below budget for the year, and 14.42% below prior year actual receipts. The decline in comparison to the same month in the prior year improved from the September results. No payments have yet been received the Fly indoor skydiving facility near the mall. Please let me know if you have any comments or questions. Thank you. WAFIN ProjectslSales Tax Information12011\Info Memo Sales Tax 11282011.docx 77 Actuals 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% 25,782 (4,362) (76,316) 14.47% 21.53% 373,978 Admission tax receipts are currently 21.53% below budget for the year, and 14.42% below prior year actual receipts. The decline in comparison to the same month in the prior year improved from the September results. No payments have yet been received the Fly indoor skydiving facility near the mall. Please let me know if you have any comments or questions. Thank you. WAFIN ProjectslSales Tax Information12011\Info Memo Sales Tax 11282011.docx 77 OR 1 1 SALES TAX SUMMARY September 2011 (Received in November) 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 10 YTD 431,616 17,374 201,175 650,166 $ 11 YTD 656,334 51,357 321,142 1,028,833 0378,667 YTD Diff 52.1% 195.6% 59.6% 58.2% NAICS AUTOMOTIVE 10 TOTAL 441 * Motor Vehicle & Parts Dealer 596,727 447' Gasoline Stations 67,583 TOTAL AUTOMOTIVE $ 664,310 $ Overall Automotive Change from Previous Year NAICS RETAIL TRADE 10 TOTAL 10 YTD 447,358 50,522 497,879 $ 10 YTD 11 YTD 449,160 52,826 501,986 $4,107 YTD % Diff 0.4% 4.6% 11 YTD 0.8% % Diff YTD MANUFACTURING 10 TOTAL 10YTD 11 YTD % Diff 442* Furniture & Home Furnishings 374,775 277,092 271,656 -2.0% 443' Electronics & Appliances 1,003,415 669,342 1,053,382 57.4% 311 Food Manufacturing 5,995 3,530 3,008 -14.8% 312 Beverage & Tobacco Products -895 -2,034 2,612 -228A% 313 Textile Mills 88 72 623 760.2% 314 Textile Product Mills 13,503 10,745 8,371 -22.1% 315 Apparel Manufacturing 38 17 446 2457.0% 316 Leather & Allied Products 2 2 7 261.9% 444* Building Material & Garden 499,394 386,918 377,643 -2.4% 445* Food & Beverage Stores 101,958 68,803 93,269 35.6% 446* Health & Personal Care 178,919 125,346 153,058 22.1 % 448' Clothing & Accessories 2,021,704 1,412,724 1,435,788 1.6% 451* Sporting Goods, Hobby, Books 648,678 448,556 448,770 0.0% 452* General Merchandise Stores 2,068,263 1,439,361 1,396,684 -3.0% 321* Wood Product Manufacturing 1,627 1,296 1,414 9.1% 453* Miscellaneous Store Retailers 481,324 339,150 345,090 1.8% 322* Paper Manufacturing 21,585 16,174 14,992 -7.3% 454' Nonstore Retailers 111,045 75,846 95,478 25.9% 323* Printing & Related Support 54,341 39,261 32,831 -16.4% TOTAL RETAIL TRADE $ 7,489,475 $ 5,243,138 $ 5,670,819 324 Petroleum & Coal Products 325 Chemical Manufacturing 326 Plastic & Rubber Products 3,062 7,458 3,142 2,659 5,570 2,439 1,273 7,359 3,007 -52.1% 32.1% 23.3% 327* Nonmetallic Mineral Products 331 Primary Metal Manufacturing 332 Fabricated Metal Mfg Products 333 Machinery Manufacturing 3,667 857 5,337 523.1% Overall General Retail Change from Previous Year SERVICES 725 -2,641 10.120 388 -3,666 8,167 187 2,557 1,820 -51.8% -169.8% -77.7% 334' Computer & Electronic Products 5,592 3,262 15,529 376.1% 335 Electric Equipment, Appliances 336 Transportation Equipment Mfg 337' Furniture & Related Products 339' Miscellaneous Manufacturing 523 290,984 10,326 11,140 372 118,162 7,373 8,427 223,073 $ TOTAL MANUFACTURING $ 440,381 $ Overall Manufacturing Change from Previous Year TRANSPORTATION 8 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 8 Messengers 493' Warehousing & Storage TOTAL TRANSP & WHSING $ 10 TOTAL 4 731 344 17,813 0 29,089 0 372 957 49,309 $ 145 88,583 6,724 8,159 204,984 (818,089) Overall Transportation Change from Previous Year WHOLESALE TRADE 10 TOTAL 10 YTD 0 280 172 13,456 0 22,005 0 265 753 36,930 $ 10 YTD -61.1% -25.0% -8.8% -3.2% 11 YTD 44 515 3,920 13,137 659 22,621 223 22 725 41,866 $4,936 11 YTD -8.1% YTD % Diff 0.0% 84.1% 2185.7% -2.4% #DIV /0! 2.8% #DIV /0! -91.6% -3.7% 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 388,884 $427,681 39,849 311,764 125,117 225 79,977 46,835 52,663 88,608 11 YTD 388,659 55,975 322,888 143,789 106 107,976 43,045 72,443 94,192 8.2% YTD % Diff -0.1% 40.5% 3.6% 14.9% -52.8% 35.0% -8.1% 37.6% 6.3% 72X' Accommodation & Food Svcs 1,769,600 1,335,359 1,350,610 1.1% 81X Other Services 92X Public Administration TOTAL SERVICES 185,696 26,395 $ 3,551,783 $ Overall Services Change from Previous Year MISCELLANEOUS 13.4% YTD % Diff 423' WhlsTrade- Durable Goods 1,236,905 948,301 796,701 -16.0% 424' Whls Trade - Nondurable Goods 112,063 81,969 76,654 -6.5% 425* Wholesale Electronic Markets 2,781 2,027 1,481 -26.9% WHOLESALE TRADE TOTAL $ 1,351,748 $ Overall Wholesale Change from Previous Year Sales Tax Mitigation NAICS Codes 11/30/2011 1,032,296 $ 874,836 ($157,461) -15.3% 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 141,026 20,326 2,630,634 $ 10 YTD 1 204 12,582 78,965 91,752 $ 10 YTD 130,049 27,819 2,737,552 $106,919 -7.8% 36.9% 11 YTD 4.1% YTD % Diff 0 - 100.0% 4.4% -80.3% 168.1% 213 2,484 211,720 214,417 $122,665 11 YTD 133.7% YTD % Diff GRAND TOTALS 614,579,726 $10,405,869 611,275,293 Grand Total Change from Previous Year Grand Total Change from Previous Year - Without New Construction $869,425 $490,758 IUK Sales la. Rpt 201109As, 8.36% 5.03%