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