HomeMy WebLinkAboutFS 2015-07-07 Item 2E - Report - 2015 1st Quarter Revenue ReportTO:
City of Tukwila
Jim Haggerton, Mayor
INFORMATIONAL MEMORANDUM
Mayor Haggerton
Finance and Safety Committee
FROM: Peggy McCarthy, Finance Director
BY: Lily Jue, Fiscal Coordinator
DATE: July 7, 2015
SUBJECT: Sales Tax and Miscellaneous Revenue Report - 1st Quarter 2015
Schedule I - Sales Tax
in $1,000's
First quarter sales tax collections through March were $546K more than the same quarter in the
previous year, resulting in a 16% increase. There was an increase in construction sales tax of
$123K over the same quarter last year, or up by 84% as well as an increase in sales tax from
other industries of $423K which resulted in a rise of 13 %.
As of March 31st, revenue that the City has received from sales tax mitigation totals $284,506,
which is 25% of the annual mitigation budget.
4 I
P �
2014 Actual
2015 Actual
YOY Change
Other
-- Month --
! Other : Total
.
Other ,
Total
Construction : Industries
! Total
Collect-
Construca I
Construct
1
1
I
ed
Rec'd
Industries �
tion 1
tion 1
Industries I
Amount
% I' Amount
% I Amount
Jan
Mar
$ 57 1 $ 1,049 1 $ 1,106
$ 85 1
$ 1,195 1
$ 1,280
$ 28
49 %1 $ 146
14 %1 $ 174
16%
Feb
Apr
34 1 1,047 1 1,081
86 1
1,227 i
1,313
52
153 %1 180
17 %i 232
21%
Mar
May
56 i 1,265 j 1,321
99 I
1,362 i
1,461
43
78 %j 97
8 %i 140
11%
Q-1 Totals
$ 147 i 3,361 i $ 3,508
$ 270 �
3,784
$ 4,054
$ 123
84 %� 423
13 %� $ 546
16%
Apr
Jun
57 i 1,135 I 1,192
I
I
1
i
May
Jul
53 : 1,201 ; 1,254
-
-
-
-
-
- -
-
Jun
Aug
75. 1,303 ! 1,378
I
I
-
-
Q -2 Totals
$ 185 ! 3,639 ! $ 3,824
$ -
- !
$ -
$ -
_I -
- I $ -
-
Jul
Sep
80 ■ 1,315 1 1,395
-
-
-
-
-1 -
- j -
-
Aug
Sep
Oct
Nov
87 1 1,301 1 1,388
91 i 1,340 i 1,431
- I
- i
-
- i
-
-
-
-
-1 -
-j
- -
-
Q-3 Totals
$ 258 i 3,956 i $ 4,214
$ i
i
$
$
i
j $
Oct
Dec
64 I 1,319 l 1,383
-
Nov
Jan
87 ; 1,396: 1,483
-
-
-
-
- -
-
Dec
Feb
78! 1,857. 1,935
-i
_i
-
-
_i _
_i _
-
Q -4 Totals
$ 229 ! 4,572 ! $ 4,801
$ -
- I
$ -
$ -
_I -
- I $ -
-
Totals
$ 819 j 15,528 i $ 16,347
$ 270 i
3,784 i
$ 4,054
$ 123
- i 423
- i $ 546
-
First quarter sales tax collections through March were $546K more than the same quarter in the
previous year, resulting in a 16% increase. There was an increase in construction sales tax of
$123K over the same quarter last year, or up by 84% as well as an increase in sales tax from
other industries of $423K which resulted in a rise of 13 %.
As of March 31st, revenue that the City has received from sales tax mitigation totals $284,506,
which is 25% of the annual mitigation budget.
4 I
P �
INFORMATIONAL MEMO
Page 2
Budget to Actual - Sales Tax in $1,000's
Schedule I - Sales Tax
Actual revenue from sales tax collections received during the first quarter experienced an
increase of $336K or 9% above the current original budget.
W: \FIN Projects \Sales Tax Information\2015 \Info Memo Sales Tax - 2015 -Q1 2015MEMO (July 2015).docx
-- Month --
2014
2015
Variance [Actual
Over (Under) Original
Budget]
Collect-
Original
ed
Rec'd
Actual
Budget
Actual
Amt
%
Jan
Mar
$ 1,106
$ 1,171
$ 1,280
$ 109
9%
Feb
Apr
1,081
1,161
1,313
152
13%
Mar
May
1,321
1,386
1,461
75
5%
Q -1 Totals
$ 3,508
$ 3,718
$ 4,054
$ 336
9%
Apr
Jun
1,192
1,252
-
-
-
May
Jul
1,254
1,287
-
-
-
Jun
Aug
1,378
1,431
-
-
-
Q-2 Totals
$ 3,824
$ 3,970
$ -
$ -
-
Jul
Sep
1,395
1,408
-
-
-
Aug
Oct
1,388
1,359
-
-
-
Sep
Nov
1,431
1,399
-
-
-
Q-3 Totals
$ 4,214
$ 4,166
$ -
$ -
-
Oct
Dec
1,383
1,286
- -
-
Nov
Jan
1,483
1,354
- -
-
Dec
Feb
1,935
1,871
- -
-
Q-4 Totals
$ 4,801
$ 4,511
$ - 1 $ -
-
Totals $ 16,347 $ 16,365
$ 4,054 $ 336
-
Actual revenue from sales tax collections received during the first quarter experienced an
increase of $336K or 9% above the current original budget.
W: \FIN Projects \Sales Tax Information\2015 \Info Memo Sales Tax - 2015 -Q1 2015MEMO (July 2015).docx
INFORMATIONAL MEMO
Page 3
Below is a graph of sales tax collections by type of industry showing overall change for 1St
quarter 2015 revenue receipts from January through March.
$300,000
$250,000
$ 200,000
$150,000
$100,000
$50,000
s-
$(50,000)
$(100,000)
% Change YTD by Category*
Services,
$245,461
Whol es a I e Tra de,
Construction 5142.767
$123,366
•
Retail Trade,
$80,950
Automotive,
$34,433
Transportation/
Manufacturing, Warehousing,
ftia ggal ($380)
Miscel I aneous,
($66,284)
The increase in the "Construction" category, specifically in the NAICS group under 236 -
Construction of Buildings was due primarily to several construction companies reporting sales
tax revenue during the current quarter that previously did not have any such activity reported in
the previous year.
The overall increase in the 'Wholesale Trade" category is attributable to the NAICS category
423, 'Wholesale Trade in durable Goods" of about $138K. Similarly, the "Retail Trade" category
experienced increases totaling $50K in the areas of Building /Material /Garden and
Clothing /Accessories. Of the $245K rise in the "Services" category, there were combined
increases totaling $222K in the areas of: Information, Real Estate /Rental /Leasing,
Professional /Scientific/Technology, Health Care /Social Assistance, and Accommodation /Food
Services.
The miscellaneous category includes activities from agriculture, forestry, fishing, mining and
utilities with unclassifiable establishments having the largest change decrease of ($24K).
W: \FIN Projects \Sales Tax Infomation\2015 \Info Memo Sales Tax-2015-Q1 2015MEMO (July 2015).docx
INFORMATIONAL MEMO
Page 4
Schedule II shows the year -to -date sales tax from the top ten industry classifications. Wholesale
Trade, Durable Goods in the NAICS 423 category continues to have the highest year over year
increase at $138,426, primarily due to an increase in reported sales by a leading manufacturer
of heavy duty commercial vehicles. This is followed by an increase of $112,472 in the category
of Construction of Buildings. This increase is partially attributable to several construction
companies reporting sales tax revenue during the current quarter that previously did not have
any activity reported in the same period from the previous year as well as an increase in sales
activity.
Schedule II
Group
Name
YTD
Current
YTD
Prior
* 452 General Merchandise Stores
* 448 Clothing and Accessories
" 722 Food Services, Drinking Places
* 423 Wholesale Trade, Durable Goods
* 443 Electronics and Appliances
236 Construction of Buildings
* 441 Motor Vehicle and Parts Dealer
* 453 Miscellaneous Store Retailers
517 Telecommunications
* 444 Building Material and Garden
* Mitigated NAICS Code
$ 470,784.24
$ 437,854.64
$ 403,293.24
$ 359,980.31
$ 227,882.28
$ 187,219.24
$ 180,562.05
$ 175,006.35
$ 160,543.77
$ 143,622.72
$ 457,216.05
$ 408,312.42
$ 368,046.80
$ 221,554.05
$ 231,481.44
$ 74,747.30
$ 150,336.43
$ 180,060.33
$ 119,501.04
$ 121,708.61
Dollar
Diff.
$ 13,568 2.97%
$ 29,542 7.24%
$ 35,246 9.58%
$ 138,426 62.48%
$ (3,599) - 1.55%
$ 112,472 150.47%
$ 30,226 20.11%
$ (5,054) -2.81%
$ 41,043 34.35%
$ 21,914 18.01%
Diff.
Schedule III shows the ten largest declines in sales tax revenue for industries with over $10,000
collected year -to -date. The NAICS 336 Transportation Equipment Manufacturing category
experienced a 39% decrease from the prior year due to significant decrease in sales activity
during this first quarter.
Schedule III
Group
Name
YTD
Current
YTD
Prior
999 Nonclassifiable Establishments
336 Transportation Equipment Man
* 453 Miscellaneous Store Retailers
* 443 Electronics and Appliances
* 442 Furniture and Home Furnishings
531 Real Estate
561 Administrative and Support Svc
488 Transportation Support
238 Specialty Trade Contractors
721 Accommodation
* Mitigated NAICS Code
$ 19,982.43
$ 19,967.88
$ 175,006.35
$ 227,882.28
$ 104,458.27
$ 10, 671.39
$ 32,998.79
$ 11,218.64
$ 63,698.09
$ 117,716.68
$ 44,223.34
$ 33,164.24
$ 180,060.33
$ 231,481.44
$ 106,807.66
$ 12,551.04
$ 34,092.10
$ 11,943.31
$ 63,849.49
$ 116,967.62
W: \FIN Projects \Sales Tax Information\2015 \Info Memo Sales Tax - 2015 -Q1 2015MEMO (July 2015).docx
Dollar
Diff.
(24,241) - 54.81%
(13,196) - 39.79%
(5,054) -2.81%
(3,599) - 1.55%
(2,349) -2.20%
(1,880) - 14.98%
(1,093) -3.21%
(725) -6.07%
(151) -0.24%
749 0.64%
Diff.
INFORMATIONAL MEMO
Page 5
The following charts show sales tax receipts the City collected from major industries between
2010 through the current year. These categories include retail, services, wholesale,
construction, and other consisting of manufacturing, transportation & warehousing, automotive,
and miscellaneous.
52,500,000
52,400,000
52,300,000
$2,200,000
52,100,000
52,000,000
51,900,000
51,800,000
51,700,000
$1,600,000
51,500,000
$700,000
5600,000
$500,000
5400,000
5300,000
5200,000
5100,000
$-
Retail
01
Q2
Q3
Wholesale
Q4
01 Q2 Q3 Q4
$450,000
5400,000
5350,000
5300,000
5250,000
5200,000
5150,000
5100,000
550,000
$-
• 2010
• 2011
• 2012
• 2013
• 2014
• 2015
• 2010
• 2011
• 2012
• 2013
• 2014
• 2015
51,400,000
51,200,000
51,000,000
5800,000
5600,000
5400,000
5200,000
5-
5450,000
5400,000
$350,000
5300,000
$250,000
5200,000
$150,000
5100,000
550,000
5-
Services
Q1
02
Q3
Construction
Q4
• 2010
• 2011
• 2012
• 2013
• 2014
• 2015
Other -Mfg. Trnsp /Wrhsng,
Automotive, & Misc.
01
Q1
02
Q3
Q4
W: \FIN Projects \Sales Tax Information \2015 \Info Memo Sales Tax - 2015 -Q1 2015MEMO (July 2015).docx
Q2
Q3
• 2010
• 2011
• 2012
• 2013
• 2014
• 2015
Q4
• 2010
• 2011
• 2012
• 2013
• 2014
• 2015
INFORMATIONAL MEMO
Page 6
Below is Schedule IV which shows quarterly gambling tax earned for the prior year compared to
the current year.
Schedule IV - Gambling Tax (a)
(c) 2015
Quarter 2014 2015 Prorated
Earned Actual Actual Budget
INCREASE (DECREASE)
YEAR OVER YEAR BUDGET VARIANCE
Amount % Amount
Q1 $ 678,358 $ 698,773 $ 615,337
Q2 666,716 - 604,777
Q3 678,302 615,286
Q4 698,517 - 633,623
$ 20,415
3% $ 83,436 14%
Totals $ 2,721,893 $ 698,773 $ 2,469,024
$ 20,415 $ 83,436
Gambling taxes for the 1st quarter ended March 31st, are $20K or 3% higher than 2014 and
$81K or 13% over 2015 budget. Casinos within the City continue to do well.
Schedule V shows monthly admissions tax receipts for the 1st quarter prior year compared to
the same quarter current year.
Schedule V - Admissions Tax (b)
(c) 2015
Quarter 2014 2015 Prorated
Earned Actual Actual Budget
INCREASE (DECREASE)
2015 to 2014 Actuals 2015 Actuals to 2015 Budget
Amount % Amount
Jan $ 47,314 $ 46,586 $ 56,057
Feb 39,544 42,492 46,851
Mar 48,187 40,167 57,091
01 Totals $ 135,045 $ 129,245 $ 160,000
$ (728) -2% $ (9,472) -17%
2,948 7% (4,360) -9%
(8,020) -17% (16,924) -30%
$ (5,800) -4% $ (30,755) -19%
Admissions tax receipts are at ($5.8K) or 4% below 2014 collections and ($30.7K) or 19% under
budget. Receipts from movie theater sales continue to be a primary component of revenue for
the admissions tax.
(a)
(b)
(c)
Gambling tax currently includes card games, punch boards, pull tabs, and amusement games.
Excludes golf course admissions tax.
Actuals reflected in Schedules IV and V are amounts earned through first quarter 2015.
W: \FIN Projects \Sales Tax Information\2015 \Info Memo Sales Tax - 2015 -01 2015MEMO (July 2015).docx
SALES TAX SUMMARY
1st Quarter 2015 (Received in March 2015 - May 2015)
O 0
H
Y
r
J
O
0
AUTOMOTIVE
0
0
0 0
0
✓
J
0
v
CONSTRUCTION
0
Flo
N G
N c1
O
N 41
69
n
co-
ID
H
au
r- d
a
. o
aa
0
O
w ¢
0 °
1-
J
1-
O
i0 O N
uoi N 4
rn CO
• 0 07
N m m
✓ rn m
m
✓ v Oa
n m CD
rn m CO
040
L6 cAAi
L • to
N • N N
0
an
0
>-
RETAIL TRADE
0)
0
- T-T- 7-1-1-- -j -f-T
11 1 1 1 1 1
Nl6lo a" L-1-5 N�omly
N1r1� °' rINImINlO
1 1 1 1 1 1 1
m1 N10) v tf)I0 o1m10
m'm N m 0) 04' CO' O'V'
Qlmlm r ml0 r:1OIu-,
v'r C1 O 0) N-'04 O,0,N
o1N1V v m '1N '-r1T1Ln
I 1 1 1 1 1 1 1
1 I 1 1 1 1 1
1 1 1 1 1 1 1
mmQ Iv - IrnN r lm lr rn INO lm lmC lol'o
0 m ("7-1 N ; 0N
O :C�) , u9 m ;� N o;m
tO m C1
rlNlr I
161-1.- 61-1,-1
(100
CO
4
1 1 1
CO
CO
CO
04
CO
0
0
N
c
CO
30
4
(0
N
m
4
0-
A
ly
GPI I 1 81 21 01
C
O .m_.
E mlv 2 0 ylm 0
Lm.10 o m cla m
m,� c U m 0 'o o 5
co 5
<0.5!'„7., 5 0 U I C' L y y
V' 0
a1 I a�i li cd I c.-0 '& 8 ¢
5 01_°c'Io r c1clm '
t1.° $ m of o 2 _8 c
5 CO O. LL W 100 Li 2101(/) 0 2 Z
1 1
0110)1 'Ln'm m1 t01n l 0) u¢i
4'4,4'4'4 4,V.4 4 a
1 1 1 1
(m01 O 0
a6 0
N co co
N 0)
EA
R
TOTAL CONSTRUCTION
0
r
MANUFACTURING
m m
oi
IN N
0
R � o
CO tc,
O tl)
▪ O
CO
0
N
O
T
J
O
U
Q
en
f -1
N N 4 t? CO o iOIaIN (+]
m m m N ,
I I
O N D) 0 0) CO r1 01 CO 0'
CO CO 0 CO O 0 co 'm m
r- C_ m 'd: co m co_ of co
m O) m N C) (ri' '-'m V'
N m NI CO r vlFltn
•
I 1
1 1
I I
• o m 0 m o CO m1611.0 to
m CO Ln r N CO CO, V m
✓ O_ r m m O N CO
m a- O m 0') , m (7I m l30
1 -at 1
O rnrn(omvr
• V 0- m (00 0) Or) m
CO
Om)
N
CCI
CO
61 N
N CO
V
M R
.4. 04
N
r c<
pQ�
r —r -1 -1 1 - - - 1 1 - - 1 1 1 1 1 1 1 1 I 1 1 11
o olo I.I- Io 0 o Io I� o eielo ei, to
o> °- Ln M' o ,n, m r ,r,'•-..2o to o m' o'
m N N of °vINIm1 v i'INID; " 01 mlNlai • 7I '1 1 1' 1'1 'I "- I 1'1'
1 1 1 1 1 1 1 1 1 1
r at o
LO CO N LO to (+ o olNlml,, r y m cllmlm (' �Irlo mlm(")lm
,m,m V �N tfN N N Idml ml ▪ �Iml� m (OIN '''''1'11"1 (f) )
N
I 1 1 1 1 1 ' I 1 'I I
1 1 1 1 1 I I I I I
I I I I I I I I I I
r r N— .- 1rn'(�'Iat m N rn r m m m CO a 6'6'3-
N N m m .- 'CO O 61. CO CO N O CO CO 6- (0 0'0'N
N
IN CO m .- 1 r 'O COI CO V- 3 CO N LO Ln m m .- I N I N
N m' LO r .- M' C)' Ln
1 °' I 1
1 I
1 I
03 010 CO 0 CO
N
N
((0
N
N
CO Ncn 01
✓ C)
✓ CD
(D
of ar
E
N
CD
N
(T
2'
N
0.
O .. U C
01 '8 O m C = .5 N
N a V .. 'E 2 O n "O
o) m -p o o a ' . m
3 m 15 (oa m 0 51-0.17... a) m W a o Q
m Q -oo c Q e6 `L Q- 0 -0 `6 0- m co 0
-.5 O m o6 E 0 t6 `- m N d W 'IS ° N Wt
(mc t `m .m o f '0 E a E n= W.«0. U
a d I m C N L m O c N m 0 2 j 5
¢ J d d 0L 0 0. z'0- LL M 0 w)- W M
N 0) V t0 (O I' I N 1 N N N r C1 m C1 1 r O)
M CJ CO m 01 C)
01.01 01 co, N CO 01 CO m l 01 CO m
0 0
; r o
(V } o
o c
N co
• v
60
co-
CD
O
to
0
J
H
O
v
TRANSPORTATION & WAREHOUSING
r
J
F
O
MISCELLANEOUS
03
CO a N N
CO
N CO 0-
a C1 10 N
c
01
co
Nto,
H
04
00
MISCELLANEOUS TOTAL
o m ((00 v m v 0) ((0
V N N
r N r O V m IN CO
CO r O m 0 N
v
Fo
a F0
N >
CO O
2 CO
N 04
IZI
co Orr
N Y
✓
m
D)
▪ pp • y
.O
LNn m
a
0
d
0
0
0.
Z
S c7/
M
(n O
Z
CC
J
O
V R K O N 31N V m
.4
J
F
WHOLESALE TRADE
LD
0
d
J
F
0
cc
O
N
Cci
40
40
CO
4f/
t-
o
ccF-
0
O
I I
1 1
v r
4') O
N chi l
0)
4
8
A
• d
m N
0 Om "O
0 Z
• d)
N 5 m
C
1- 1- m
M N O
Co 110 1:0
<1<
10
04 0
o v
V �
N
01
m
A