HomeMy WebLinkAboutFS 2011-12-06 Item 2C - Discussion - Revenue Generating Regulatory License (RGRL) AuditCity of Tukwila
Jim Haggerton, Mayor
INFORMATIONAL MEMORANDUM
TO: Mayor Haggerton
Finance and Safety Committee
FROM: Jennifer Ferrer -Santa Ines, Senior Fiscal Coordinator
DATE: November 29, 2011
SUBJECT: Revenue Generating Regulatory License (RGRL) Audit
ISSUE
The City implemented the Revenue Generating Regulatory License (RGRL) fee effective with its
2011 business license applications and renewals. An annual audit of the number of employees
and or annual hours worked in Tukwila reported by businesses determines the accuracy of
revenue received through RGRL fees.
BACKGROUND
On July 19, 2010 Council adopted Ordinance No. 2297 which implemented an RGRL fee of
$55.00 per full -time equivalent employee. The RGRL was a fee in addition to any license fee
paid to the City. Every person engaged in business within Tukwila is to pay a Revenue
Generating Regulatory License fee based upon the current number of employees or number of
employee hours worked in the City in the previous year.
The amount of RGRL due can be determined using the standard method of taking the current
number of employees and multiplying that by $55.00. A business can also use an alternative
method of taking all annual hours worked in Tukwila the previous year and multiplying those
hours by the RGRL multiplier of .028646. This multiplier is equivalent to one full -time employee
working 1,920 hours or more.
DISCUSSION
Staff contacted the largest businesses in Tukwila employing greater than 200 employees to
conduct routine fee verification to determine whether or not hours and or employees were being
reported accurately for RGRL purposes. The process used to conduct the verification is as
follows:
1) A list of selected Tukwila businesses with number of employees greater than 200 were
contacted either by telephone, email, or both in order to conduct routine fee verification
as mandated by Ordinance No. 2297.
2) It was explained to each business contacted that the City is conducting a routine
verification of the RGRL business licensing fee calculation method. As a part of this
verification process, the City asked the business entity to submit copies of its prior year
quarterly Labor and Industries (L &I) reports.
71
INFORMATIONAL MEMO
Page 2
3) For larger business entities with multiple locations throughout Washington State, the
quarterly L &I reports are usually filed on a consolidated basis (i.e., the L &I reports are
inclusive of all the entity's business locations and filed as an aggregate in which
information is not readily available). Should this be the case, the City has been
requesting that the business provide internally generated worksheets or documentation
in support or in lieu of the L &I filing that would only be specific to the City of Tukwila.
4) Total number of worker hours divided by 1,920 hours per year for one full -time employee
(FTE) equivalent results in the total number of RGRL FTEs multiplied by $55.00 per
employee. An employee working 1,920 or more hours per year is counted as one full
time employee for RGRL purposes.
5) Under reporting of employees by an error factor of more than 15% will be billed including
a 20% penalty on the amount due.
From the list of businesses verified, there was one organization that under reported total actual
hours worked in Tukwila. This resulted in over $12,000 in RGRL fees that were not paid at the
time of license renewal. This business has fully paid all outstanding RGRL fees as of
October 24, 2011.
RECOMMENDATION
For information only.
ATTACHMENTS
2011 RGRL Routine Verification Business Listing
72
CUST_NO
` - BUS_NAME
ACCT_NO
#`off,Employees
FEE_AMT
Notes /Comments /Findings as of 10/30/2011:
American Medical
Left voice msg to Mr. Gostelli to provide 4 of worker hours for RGRL business license fee portion. EDEN shows 68,459 hrs. Further investigation
00032708
Response
00001818
442
1,961
showed that AMR had reported additional hours above what they reported to the City causing an underpayment of 512,009. This was paid on 10-24-11
00034112
Boeing Co.
00001668
3797
208,835
00034109
Boeing Co.
00001665
1804
99,220
On 09/02/11, Ryan faxed their internal reports showing total worker hours of 12,366,708.50/1,920 = 6,441 FTE x $55.00 = $354,255 adj RGRL fee. EDEN shows
00034108
Boeing Co.
00001664
552
30,360
$352,935; diff = (0.37%).
00054576
BOEING COMPANY
00003194
264
14,520
00034115
BOEING EMPLOYEES
CREDIT UNION
00000358
466
25,338
Based on BECU's actual 2010 L &I reports for Tukwila, only, the highest month with emp 4 shows 440 and for RGRL purposes, they reported 460.68876 emps
under alt method with RGRL fee paid of $25,337.88; so, they have actually remitted in excess of actual L &I.
00034187
Carlisle Interconnect
00001677
600
27,885
Per L &I reports, total 2010 worker hrs = 1,055,466, or 549.722 FTEs x $55 = $30,234.71. EDEN RGRL shows 507 emps with fee paid of $27,885; diff of <7.7 %> or
Techn.
<52,350 >.
00034234
Cheesecake Factory
00002102
252
6,620
Spoke with Kevin Mounce on 09/19/11: For Tukwila location 2010 total 4 of L &I worker hrs reported = 270,243/1,920 = 140.7515625 FTEs x $55 = $7,741.34;
EDEN shows 231,088.11 hrs /1,920 = 120.3583906 x $55 = $6,619.75; diff = (14.49%).
This is COSTCO Optical Lab which is a separate bldg that manufactures the lenses for Optical Sales. Per telecon with Jackie Bacon, as of 12/29/10, there were 415
00034335
Costco Optical
00001883
401
16,694
emps at this location vs 401 they provided for the base lic fee. Have left a message on 8/30/11 for Michael Lynch to call me back with RGRL hrs info. Mr. Lynch is
out of office until 09/07/11. As of 9/15/11: Contact is now Ben Kaiser, 425- 313 -6386; he is working with me on this. Optical division had 319 emps reported to L &I for
2010, they actually reported 303.53 FTEs to City; RGRL diff = (4.85 %)
This is COSTCO Wholesale & Optical Sales. Per telecon with Ann Loonam, as of 12/29/10, there were 320 emps for this division vs 274 they provided for the base
00034337
Costco Wholesale
00002580
274
14,745
tic fee. Have left a message on 8/30/11 for Michael Lynch to call me back with RGRL hrs info. Mr. Lynch is out of office until 09/07/11. As of 9/15/11: Contact is now
Ben Kaiser, 425 - 313 -6386; he is working with me on this. Wholesale division had 301 emps reported to L &I for 2010, they actually reported 268.08 FTEs to City;
RGRL diff = (10.94 %)
00034790
Hartung Glass Industries
00000989
252
13,860
Per 2010 L &I reports for Tukwila, total worker hrs = 516,136/1,920 = 268.821 FTEs x $55 = $14,785.16; Per EDEN RGRL: 252 FTEs x $55 = $13,860; dill of
Inc
<6.25 %>
00034819
Highline Med Ctr Spec
Campus
00001829
200
9,910
Rec'd HMC's faxed info of total 212 employees EDEN shows 200 = (5.66 %) diff and total worker hours of 340,014; EDEN shows 345,955 diff = 1.75%
00032572
J.C. Penney Co.
00001268
350
11,583
Rec'd faxed info from Christy on 9/15/11. This was just copy of email dated 01/17/2011 she had recd from her HR Team with 404,354.10 productive emp hours
worked which agrees to EDEN RGRL.
00032812
Macy's ( 408)
00001270
327
17,985
Rec'd fax info from Lisa Price on 9/19/11. The highest # of emps for 12 -month period was 370 (some might have been PTs), lowest was 291. Macy's used all
method in calculating their RGRL fee at 327 FTEs: 327/370 = 88.3783783 %; diff = (11.62 %)
00032978
Nordstrom, Inc. ( 45)
00001266
268
14,740
Rec'd info from Komny on 9/01/11: Total 2010 hours worked shows 533,219/1,920 = 277.72 FTEs x $55 = $15,274.50; EDEN shows 268 FTEs and $14,740.00;
diff = (3.50 %).
Spoke with Mr. Boman on 09/19/11 as follow up to request 2010 L &I reports for their Tukwila location. He asked for City's requirements in order to do so. Emailed
00033277
Red Dot Corp.
00001598
286
15,774
copy of Ord. No. 2297 to him and requested that the 2010 L &I reports be faxed to my attention on or before Friday, 09/23/11. Recd L &I info from Mr. Boman: Total
2010 Worker Hours as reported to L &I for Tukwila business location = 640,759/1,920 = 333.7286458 FTEs x $55 = $18,355.08; EDEN = 286.8 FTEs x $55 =
$15,774; diff = (14.062 %)
00056402
Things Remembered
( #840)
00001749
217
174
Pass on contacting this business. New cust #00056402 and new activity #00003992. This business only has 3 emps with # of RGRL FTE of 3.16. As per EDEN
system, this is still in "pending" status as of 08/31/11. Previously had incorrect # of employees. N/A
00033864
Unified Grocers
00001435
200
4,992
Recd from Steve Johnson on 09/12/11 via email: For 2010 they showed total worker hours of 145,658.25/1,920 = 75.86367187 FTEs x $55 = $4,172.50; Per
EDEN RGRL hours = 174,276/1,920 = 90.76875 FTEs x $55 = $4,992.28; Percentage diff: 16.42% over
00033870
United Parcel Service
00001937
294
4,568
Per UPS' 2010 internal reports for Tukwila rec'd 9/01/11, total worker hrs = 159,448.78/1,920 = 83.05 FTEs x $55 = $4,567.54 (This agrees to EDEN); Additionally,
UPS' 2010 internal reports show correct 4 emps of 294 for base business license fee.
00033878
University of Phoenix
00001331
204
4,036
Rec'd info from both Joanne Hollera.n & Emily Gonzalez. Per EDEN: 2010 RGRL worker hrs = 140,888/1,920.= 73.37916666 FTEs x $55 = $4,035.85; Per
Licensee actual worker hrs = 140,150.70/1,920 = 72.99515625 FTEs x $55 = $,4,014.73; Diff = +0.53 %.