HomeMy WebLinkAboutEx 10 TRS email to J Hawn N Malone Aug 8 2017.pdf1
Nate Malone
From:TRS <crisp@trs-integrity.com>
Sent:Tuesday, August 8, 2017 2:36 PM
To:Jan Hawn; Nate Malone
Subject:Re: TracFone Schedules
Attachments:ExcelPrelim3Renton Tracfone.xls; Renton TracFone3Methodology.doc
Thanks, Jan. This was very helpful.
I found a source online that gives estimates for zip codes for all the years of the audit, and using the
population numbers on your chart, I calculated a population ratio specific for each year. This seems to
be the most straight forward way, especially since there is a missing 2000 census value for 98057 (no
one has it) and the 2000 census value for 98055 is so large (compared to 2010) it might be a
combination of the 98055 and the 98057 zips. This new method is straight forward, as each number
comes directly from a reference-able source.
Hopefully this new method will work for TracFone. The estimates that this zip code site gives are a bit
lower for census years than the census numbers, so the advantage is on the city's side. If TracFone
is unhappy with this, we can feel good about giving a little to make them happy. It is, after all, an
estimate, the best we can come up with. The new total due is $298,228.55.
Thanks again, and let us know if you have any questions, and if this approach looks good to you. If
you are good with it, I will send it on to TracFone. And let me know if it is okay if I reference your
Comprehensive Annual Report. I would assume that it is a public document.
Hope you have been having a great day.
Tamara
This email and any files attached to it are the property of Tax Recovery Services, LLC. The contents may be confidential and
proprietary, and any use or distribution of the information contained herein may be prohibited by law. If you are not a named
recipient, or if you have received this email in error, please notify the person who sent it, and immediately delete it.
From: Jan Hawn <JHawn@Rentonwa.gov>
To: 'TRS' <crisp@trs-integrity.com>; Nate Malone <NMalone@Rentonwa.gov>
Sent: Monday, August 7, 2017 4:26 PM
Subject: RE: TracFone Schedules
Hi Tamara,
The population growth over the years can be found in Table 5 of our Comprehensive Annual Financial Report on p. 7-7 of
the linked report. The current population is 102,700. I hope that helps.
Jan
000665
11.17.2020
T Crisp
16
Buell Realtime Reporting
2
From: TRS [mailto:crisp@trs-integrity.com]
Sent: Monday, August 7, 2017 4:17 PM
To: Jan Hawn <JHawn@Rentonwa.gov>; Nate Malone <NMalone@Rentonwa.gov>
Subject: TracFone Schedules
Hi Jan and Nate,
We have been looking harder at the population proportion calculations for Renton, and something has come up
with how they were calculated.
It turns out that the population sizes for various years for Renton that are found between census years online are
not very correct at all. These online population figures show a very smooth, slight upward climb and then a
bounce in 2010. But it turns out that the significant population bump for Renton occurred in 2008, when two
large annexations were added. According to our records, the Benson Hill annexation added 16,272 residents,
and the Aqua Barn annexation added another 2,200 new residents that same year. This means that the bump
finally showing up during the census occurred two years earlier, but was not included in the more informal
population counts used previous to the census.
Because the population counts between censuses have proven so faulty, if it is alright with you, we would prefer
to use only census years in our calculations. We have redone the schedules using the 2010 census's population
proportion for 2008 onward, and the 2000 census population proportion for 2007. We believe that this would be
a much more accurate approach to the estimation.
But before we send this on to TracFone, we would like you to check to see if any of the other annexations were
large population-wise. The 2010 jump online is more like 30,000, of which the Benson Hill/Aqua Barn
annexations account for about 2/3, and the remainder may be due to regular population growth and small
annexations, but it also may be due to a large one or two we are not aware of.
We know that there have been a lot of annexations over the course of the audit (2007 to 2013), but we want to
include the really big ones in our choice of methodology. So if there is any light you could shed on this
situation, we would appreciate the additional information.
We have attached the adjusted schedules so that you can see the effect of the new procedure.
Thanks Jan and Nate.
Hope you have been enjoying the sunshine.
Tamara
This email and any files attached to it are the property of Tax Recovery Services, LLC. The contents may be confidential and
proprietary, and any use or distribution of the information contained herein may be prohibited by law. If you are not a named
recipient, or if you have received this email in error, please notify the person who sent it, and immediately delete it.
000666
TracFone Audit Methodology
Renton
Methodology
(Note: For definitions of terms used, see Definition section below)
Usual data is not collected by TracFone:
We have found that typically, for prepaid telephone UUT taxes, a company collects usage
information for the entire state, and applies a percentage ratio found by comparing the number of
customers from a specific city to Washington State usage in order to calculate the total owed to the
specific city. But TracFone only collects information on sales, not on usage, and they don't track
the number of customers they have in each municipality.
Why sales and not usage is used in the estimate:
While it is true that taxation of this prepaid phone activity is properly owed on usage, not sales,
usage figures are not available from TracFone, so an estimate must be made via sales, which
approximates usage. We would like to stress here that taxes are not being levied on sales, but rather
sales are being used as a method to estimate usage.
How the taxable usage was estimated for direct sales (Billing Platform Sales and APP Sales):
TracFone doesn't collect sales information for particular cities, either. What they do collect is sales
information for zip codes. So our first step was to collect and sum up the direct-sales information
for the city's zip codes, then we reduced the zip code sales sum by a percentage ratio found by
comparing population of the city to the sum of the zip codes populations. Direct sales were further
reduced by percentages that removed data sales and interstate and international calls from the total,
resulting in amounts that would represent a good estimate of direct-sales-related taxable utility
usage.
However, this only gave us an idea of city taxable revenues for direct sales to TracFone, and the
larger proportion of TracFone customers buy indirectly from TracFone, via outside carriers such as
Walmart.
Estimation of non-direct sales (sold through outside carriers):
In order to estimate the amount of non-direct sales (and thus usage) that the company collects from
city customers, it was necessary for us to turn to information from TracFone company-wide sales
figures (more localized data was unavailable). We checked that the data for company-wide direct
and non-direct sales included basically the same types of items, and came up with a ratio to
estimate how much direct vs. non-direct sales were occurring (and thereby estimate usage from the
non-direct sales).
Summing direct sales (these numbers were figured using the direct-sales amounts, which were
already reduced by percentages that removed data, interstate and international usage), the non-
direct/direct revenues ratio was then applied to produce the taxable non-direct sales usage estimate.
Finding total taxable revenue:
Total taxable revenue was found 1) by summing up direct sales from internet sales and billing
platform sales (reduced by percentages that removed data, interstate and international usage), and
000667
2) by adding in non-direct sales found by summing taxable direct usage estimates and applying the
percentage of company-wide non-direct vs. direct sales.
Finding population proportion:
Population percentage is the percentage which compares city population and zip code
populations, which is used to reduce the sales figures for the zip codes down to approximate
city-only sales.
Unlike other cities, Renton experienced a myriad of annexations, many small and some quite
large, during the audit period, making it hard to guess what their city population would be at
each year compared to the normal population growth for the zip codes. But clearly, one
proportion factor would not be accurate from year to year.
TRS found a solution for this difficulty at a website that estimated the size of the Renton area
zip code populations for each of the years of the audit, and, using the City of Renton's own
yearly population figures to compare with these, calculated unique population proportions for
each year.
Note: For the years previous to given information, estimates were used as follows:
-For data, percent values were increasing drastically every year, increasing nearly 36% in four
years, starting low in 2010 at 3.96%. Because of this, data percentage was presumed to be zero
previous to 2010.
-For intrastate percentage, the percentages were rather constant throughout the audit, showing a
slight downward trend, dropping only 4 percentage points in 4 years, so the earliest year value
available of 84.07% was used previous to 2009.
Available information
Zip code specific sales data for direct sales only:
APP sales by zip code for each month
Billing Platform sales by zip code for each month
Accessory sales by zip code for each month
Company-wide data showing non-direct and direct sales amounts and proportions
Percent of sales representing data for years 2010 to 2014
Percent of sales representing intra-state calling from years 2009 to 2014
Missing information
Usage data at any level
Local data showing non-direct sales or usage
City-specific sales or usage figures
Definitions
Direct sales:
000668
The Billing Platform, Internet Sales, and Telephone Sales shown on the excel format reports
submitted to TRS, also called by TracFone “retail sales” amounts. These amounts are from
customer purchases made via the internet (i.e., the TracFone’s website) and over the phone. Refills
of airtime that a customer can purchase via the internet (i.e., the TracFone’s website), and over the
phone are included in the Billing Platform and Internet Sales retail reports.
Non-Direct sales:
TracFone refers to these sales as “wholesale,” as they are sales made through outside carriers such
as Walmart. On the company-wide data chart TRS received from TracFone, these were referred to
as “net airtime sales.”
Internet sales, APP sales:
The Alternative Payment Plan (“APP”) is TracFone’s credit card transaction interface for retail
sales. Under the APP, customers engage in one-time credit card based transactions via the internet
or phone. APP ba sed customer transactions are consummated predominantly via the internet.
Furthermore, any TracFone plan program which is not available to be set up for an automated-
recurring charge gets processed through APP. Note: Although internet sales are not taxable, for
this audit, internet sales are simply used to estimate usage, which is taxable.
Billing Platform:
The Billing Platform (“BP”) is a supplement to the Alternative Payment Plan (“APP”) to provide a
system for automated-recurring charges. Customers can make a one-time purchase or enroll into
programs available for automated or recurring charges, most of which include airtime on a
monthly (30 day) basis.
Accessories:
Mobile phone accessories include any hardware or software that is not integral to the operation of a
mobile phone as designed by the manufacturer. Note: Accessories are not taxable under the city
utility tax laws, and were not included in taxable amounts for this audit.
Data usage:
The transmission of data via cellphone. Also called "mobile data" and a separate service from
voice calling, cellular data is used for e-mail, Web pages, media and app downloads and software
updates. Text messaging (SMS) is also a different service. Note: Data usage is not taxable under
the city utility tax laws, and was removed from taxable amounts for this audit.
Example of estimating Non-direct Sales from Direct Sales using percent data from TracFone 2010:
Proportion from TracFone: Non-direct Sales = .83 x all sales ; Direct Sales = .17 x all sales
Thus: Non-direct Sales = .83 x all sales ; Non-direct Sales = .83 ;
Direct Sales .17 x all sales Direct Sales .17
Therefore: Non-direct Sales = Direct Sales x .83/.17
000669
City of Renton, WashingtonRegistrationDepartment of FinanceField Auditor's ReportSUMMARY SHEETPeriod of Adjustments:January 01, 2007 through May 31, 2013Firm Name:Tracfone WirelessBusiness Address:Tax Department9700 NW 112th AvenueMiami, FL 33178Nicholas Ford, Sr. Tax ManagerClasses 2007 2008 2009 2010 2011 2012 2013 2014 2015 T O T A LUTILITY TAX0RoundingCorrected Tax0Reported Tax0DEBIT/(CRE00000000000 Date:Audit submitted by: Michael J. Crisp REMARKS:YEARLYYEARINTEREST DR/(CR)TOTALS20072008200920102011201220130Total Interest Dr(Cr):0Total Tax (Shown Above) DR/(CR)0Total Penalty (Per Calc Sheet) Dr./(Cr.)Total Due 0Extensions Dr. Noted DateReviewerCr. Noted DateCodeClassif. Hours0\C {GOTO}GG282~ Copy Recap. from Database.wk1 to this Combined.wk1/FCCNQ27..AG87~DATA1.WK1~{BRANCH \P}~\P {GETNUMBER "Enter Code fr.1 to 17 for Int.computed to last day shown on Table:-> ",CODE}{IF CODE=1}{BRANCH \A}{IF CODE=2}{BRANCH \B}{IF CODE=3}{BRANCH \T}{IF CODE=4}{BRANCH \D}{IF CODE=5}{BRANCH \E}{IF CODE=6}{BRANCH \F}{IF CODE=7}{BRANCH \S}{IF CODE=8}{BRANCH \G}{IF CODE=9}{BRANCH \H}{IF CODE=10}{BRANCH \I}{IF CODE=11}{BRANCH \K}{IF CODE=12}{BRANCH \L}{IF CODE=13}{BRANCH \M}{IF CODE=14}{BRANCH \N}{IF CODE=15}{BRANCH \Q}{IF CODE=16}{BRANCH \R}{IF CODE=17}{BRANCH \U}\A {LET DN203,.5645}Jan. 1/14{LET DP203,.5185}Jan. 1/14{LET DR203,.4739}Jan. 1/14{LET DT203,.4306}Jan. 1/14{LET DX203,.3885}Jan. 1/14{LET DZ203,.3477}Jan. 1/14{LET EB203,.3081}Jan. 1/14{LET ED203,.2696}Jan. 1/14{LET EH203,.2323}Jan. 1/14{LET EJ203,.1960}Jan. 1/14{LET EL203,.1609}Jan. 1/14{LET EN203,.1267}Jan. 1/14{LET ER203,.0936}Jan. 1/14{LET ET203,.0615}Jan. 1/14{LET EV203,.0303}Jan. 1/14{GOTO}FT248~\B {LET DN203,.5801}Jan.15/31{LET DP203,.5337}Jan.15/31{LET DR203,.4886}Jan.15/31{LET DT203,.4449}Jan.15/31{LET DX203,.4024}Jan.15/31{LET DZ203,.3612}Jan.15/31{LET EB203,.3212}Jan.15/31{LET ED203,.2823}Jan.15/31{LET EH203,.2446}Jan.15/31{LET EJ203,.2080}Jan.15/31{LET EL203,.1725}Jan.15/31{LET EN203,.1380}Jan.15/31{LET ER203,.1045}Jan.15/31{LET ET203,.0721}Jan.15/31{LET EV203,.0406}Jan.15/31000670
{GOTO}FT248~\D {LET DN203,.5959} Feb.15/Mar.14{LET DP203,.5490} Feb.15/Mar.14{LET DR203,.5035} Feb.15/Mar.14{LET DT203,.4593} Feb.15/Mar.14{LET DX203,.4164} Feb.15/Mar.14{LET DZ203,.3748} Feb.15/Mar.14{LET EB203,.3344} Feb.15/Mar.14{LET ED203,.2951} Feb.15/Mar.14{LET EH203,.2570} Feb.15/Mar.14{LET EJ203,.2201} Feb.15/Mar.14{LET EL203,.1842} Feb.15/Mar.14{LET EN203,.1494} Feb.15/Mar.14{LET ER203,.1155} Feb.15/Mar.14{LET ET203,.0828} Feb.15/Mar.14{LET EV203,.0510} Feb.15/Mar.14{LET EX203,.0201} Feb.15/Mar.14{GOTO}FT248~\E {LET DN203,.6119} Mar.15/Apr.14{LET DP203,.5645} Mar.15/Apr.14{LET DR203,.5185} Mar.15/Apr.14{LET DT203,.4739} Mar.15/Apr.14{LET DX203,.4306} Mar.15/Apr.14{LET DZ203,.3885} Mar.15/Apr.14{LET EB203,.3477} Mar.15/Apr.14{LET ED203,.3081} Mar.15/Apr.14{LET EH203,.2696} Mar.15/Apr.14{LET EJ203,.2323} Mar.15/Apr.14{LET EL203,.1960} Mar.15/Apr.14{LET EN203,.1609} Mar.15/Apr.14{LET ER203,.1267} Mar.15/Apr.14{LET ET203,.0936} Mar.15/Apr.14{LET EV203,.0615} Mar.15/Apr.14{LET EX203,.0303} Mar.15/Apr.14{GOTO}FT248~\F {LET DN203,.6280} Apr.15/30{LET DP203,.5801} Apr.15/30{LET DR203,.5337} Apr.15/30{LET DT203,.4886} Apr.15/30{LET DX203,.4449} Apr.15/30{LET DZ203,.4024} Apr.15/30{LET EB203,.3612} Apr.15/30{LET ED203,.3212} Apr.15/30{LET EH203,.2823} Apr.15/30{LET EJ203,.2446} Apr.15/30{LET EL203,.2080} Apr.15/30{LET EN203,.1725} Apr.15/30{LET ER203,.1380} Apr.15/30{LET ET203,.1045} Apr.15/30{LET EV203,.0721} Apr.15/30{LET EX203,.0406} Apr.15/30{GOTO}FT248~\G {LET DN203,.6443} May 15/June 14{LET DP203,.5959} May 15/June 14{LET DR203,.5490} May 15/June 14{LET DT203,.5035} May 15/June 14{LET DX203,.4593} May 15/June 14{LET DZ203,.4164} May 15/June 14{LET EB203,.3748} May 15/June 14{LET ED203,.3344} May 15/June 14{LET EH203,.2951} May 15/June 14{LET EJ203,.2570} May 15/June 14{LET EL203,.2201} May 15/June 14{LET EN203,.1842} May 15/June 14{LET ER203,.1494} May 15/June 14{LET ET203,.1155} May 15/June 14{LET EV203,.0828} May 15/June 14{LET EX203,.0510} May 15/June 14{LET FB203,.0201} May 15/June 14{GOTO}FT248~\H {LET DN203,.6607} June 15/July 14{LET DP203,.6119} June 15/July 14{LET DR203,.5645} June 15/July 14{LET DT203,.5185} June 15/July 14{LET DX203,.4739} June 15/July 14{LET DZ203,.4306} June 15/July 14{LET EB203,.3885} June 15/July 14{LET ED203,.3477} June 15/July 14{LET EH203,.3081} June 15/July 14{LET EJ203,.2696} June 15/July 14{LET EL203,.2323} June 15/July 14{LET EN203,.1960} June 15/July 14{LET ER203,.1609} June 15/July 14{LET ET203,.1267} June 15/July 14{LET EV203,.0936} June 15/July 14{LET EX203,.0615} June 15/July 14{LET FB203,.0303} June 15/July 14{GOTO}FT248~\I {LET DN203,.6773}July 15/31{LET DP203,.6280}July 15/31\V {LET L54,D1}{LET DR203,.5801}July 15/31{LET V54,D1}{LET DT203,.5337}July 15/31{LET AF54,D1}{LET DX203,.4886}July 15/31{LET AP54,D1}{LET DZ203,.4449}July 15/31{LET BB54,D1}{LET EB203,.4024}July 15/31{LET DV175,D1}{LET ED203,.3612}July 15/31{LET EF175,D1}{LET EH203,.3212}July 15/31{LET EP175,D1}{LET EJ203,.2823}July 15/31{LET EZ175,D1}{LET EL203,.2446}July 15/31{LET FL175,D1}{LET EN203,.2080}July 15/31{LET BQ113,D1}{LET ER203,.1725}July 15/31{LET CA113,D1}{LET ET203,.1380}July 15/31{LET CK113,D1}{LET EV203,.1045}July 15/31{LET CU113,D1}{LET EX203,.0721}July 15/31{LET DG113,D1}{LET FB203,.0406}July 15/31{LET GC220,D1}{GOTO}FT248~{LET B54,F1}\K {LET DN203,.6773}Aug.1/14{LET D54,F2}{LET DP203,.6280}Aug.1/14{LET BG113,F1}{LET DR203,.5801}Aug.1/14{LET BI113,F2}{LET DT203,.5337}Aug.1/14{LET DL175,F1}{LET DX203,.4886}Aug.1/14{LET DN175,F2}{LET DZ203,.4449}Aug.1/14{LET FU225,F1}{LET EB203,.4024}Aug.1/14{LET N54,F2}{LET ED203,.3612}Aug.1/14{LET X54,F2}{LET EH203,.3212}Aug.1/14{LET AH54,F2}{LET EJ203,.2823}Aug.1/14{LET AR54,F2}{LET EL203,.2446}Aug.1/14{LET BS113,F2}{LET EN203,.2080}Aug.1/14{LET CC113,F2}{LET ER203,.1725}Aug.1/14{LET CM113,F2}{LET ET203,.1380}Aug.1/14{LET CW113,F2}{LET EV203,.1045}Aug.1/14{LET DX175,F2}{LET EX203,.0721}Aug.1/14{LET EH175,F2}{LET FB203,.0406}Aug.1/14{LET ER175,F2}{LET FD203,.01}Aug.1/14{LET FB175,F2}~{GOTO}FT248~\T {LET DN203,.5801}Feb.1/14{LET DP203,.5337}Feb.1/14{LET DR203,.4886}Feb.1/14{LET DT203,.4449}Feb.1/14{LET DX203,.4024}Feb.1/14{LET DZ203,.3612}Feb.1/14{LET EB203,.3212}Feb.1/14{LET ED203,.2823}Feb.1/14{LET EH203,.2446}Feb.1/14{LET EJ203,.2080}Feb.1/14{LET EL203,.1725}Feb.1/14{LET EN203,.1380}Feb.1/14{LET ER203,.1045}Feb.1/14{LET ET203,.0721}Feb.1/14{LET EV203,.0406}Feb.1/14{LET EX203,.01}Feb.1/14{GOTO}FT248~\S {LET DN203,.6280}May 1/14{LET DP203,.5801}May 1/14{LET DR203,.5337}May 1/14{LET DT203,.4886}May 1/14{LET DX203,.4449}May 1/14{LET DZ203,.4024}May 1/14{LET EB203,.3612}May 1/14{LET ED203,.3212}May 1/14{LET EH203,.2823}May 1/14{LET EJ203,.2446}May 1/14{LET EL203,.2080}May 1/14{LET EN203,.1725}May 1/14{LET ER203,.1380}May 1/14{LET ET203,.1045}May 1/14{LET EV203,.0721}May 1/14{LET EX203,.0406}May 1/14{LET FB203,.01}May 1/14{GOTO}FT248~\L {LET DN203,.6941}Aug.15/Sept.14{LET DP203,.6443}Aug.15/Sept.14{LET DR203,.5959}Aug.15/Sept.14{LET DT203,.5490}Aug.15/Sept.14{LET DX203,.5035}Aug.15/Sept.14{LET DZ203,.4593}Aug.15/Sept.14{LET EB203,.4164}Aug.15/Sept.14{LET ED203,.3748}Aug.15/Sept.14{LET EH203,.3344}Aug.15/Sept.14{LET EJ203,.2951}Aug.15/Sept.14{LET EL203,.2570}Aug.15/Sept.14{LET EN203,.2201}Aug.15/Sept.14{LET ER203,.1842}Aug.15/Sept.14{LET ET203,.1494}Aug.15/Sept.14000671
{LET EV203,.1155}Aug.15/Sept.14{LET EX203,.0828}Aug.15/Sept.14{LET FB203,.0510}Aug.15/Sept.14{LET FD203,.0201}Aug.15/Sept.14{GOTO}FT248~\MSept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14Sept.15/Oct.14\NOct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31Oct.15/31\QNov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14Nov.1/14last1\o {goto}panel1~{getlabel "Enter the appropriate printing code, and press Enter:->",YRS}~{if YRS="ALL5"}{branch PRINT5}~{if YRS="FIRST4"}{branch PRINT4}~{if YRS="LAST4"}{branch PRINTL4}~{if YRS="FIRST3"}{branch PRINT3}~{if YRS="LAST3"}{branch PRINTL3}~{if YRS="FIRST2"}{branch PRINT2}~{if YRS="LAST2"}{branch PRINTL2}~{if YRS="FIRST1"}{branch PRINT1}~{if YRS="LAST1"}{branch PRINTL1}~PRINT5 /ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN1~agrTRN2~agrTRN3~agrTRN4~agoml0~{esc}rTRN5~agoml5~bcBSCH2~{esc}rSCH21~agrSCH22~agrSCH23~agrSCH24~agoml0~{esc}rSCH25~agoml5~bcBSCH1~{esc}rSCH11~agrSCH12~agrSCH13~agrSCH14~agoml0~{esc}rSCH15~agos{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~agPRINT4 {let l56,Page 1 of 4}{let v56,Page 2 of 4}{let af56,Page 3 of 4}{let bb56,Page 4 of 4}~{let bq115,Page 1 of 4}{let ca115,Page 2 of 4}{let ck115,Page 3 of 4}{let dg115,Page 4 of 4}~{let dv177,Page 1 of 4}{let ef177,Page 2 of 4}{let ep177,Page 3 of 4}{let fl177,Page 4 of 4}~/reEZ175..EZ177~/reAP54..AP56~/reCU113..CU115~/ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN1~agrTRN2~agrTRN3~agoml0~{esc}rTRNS4~agoml5~bcBSCH2~{esc}rSCH21~agrSCH22~agrSCH23~agoml0~{esc}rSCHE24~agoml5~bcBSCH1~{esc}rSCH11~agrSCH12~agrSCH13~agoml0~{esc}rSCHE14~agos{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~ag000672
PRINTL4 {let V56,Page 1 of 4}{let AF56,Page 2 of 4}{let AP56,Page 3 of 4}{let BB56,Page 4 of 4}~{let CA115,Page 1 of 4}{let CK115,Page 2 of 4}{let CU115,Page 3 of 4}{let DG115,Page 4 of 4}~{let EF177,Page 1 of 4}{let EP177,Page 2 of 4}{let EZ177,Page 3 of 4}{let FL177,Page 4 of 4}~/ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN2~agrTRN3~agrTRN4~agoml0~{esc}rTRN5~agoml5~bcBSCH2~{esc}rSCH22~agrSCH23~agrSCH24~agoml0~{esc}rSCH25~agoml5~bcBSCH1~{esc}rSCH12~agrSCH13~agrSCH14~agoml0~{esc}rSCH15~agos{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~agPRINT3 {let V56,Page 1 of 3}{let AF56,Page 2 of 3}{let BB56,Page 3 of 3}~{let CA115,Page 1 of 3}{let CK115,Page 2 of 3}{let DG115,Page 3 of 3}~{let EF177,Page 1 of 3}{let EP177,Page 2 of 3}{let FL177,Page 3 of 3}~/reAP54..AP56~/reCU113..CU115~/reEZ175..EZ177~/ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN2~agrTRN3~agoml0~{esc}rTRNS4~agoml5~bcBSCH2~{esc}rSCH22~agrSCH23~agoml0~{esc}rSCHE24~agoml5~bcBSCH1~{esc}rSCH12~agrSCH13~agoml0~{esc}rSCHE14~agos{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~agPRINTL3 {let AF56,Page 1 of 3}{let AP56,Page 2 of 3}{let BB56,Page 3 of 3}~{let CK115,Page 1 of 3}{let CU115,Page 2 of 3}{let DG115,Page 3 of 3}~{let EP177,Page 1 of 3}{let EZ177,Page 2 of 3}{let FL177,Page 3 of 3}~/ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN3~agrTRN4~agoml0~{esc}rTRN5~agoml5~bcBSCH2~{esc}rSCH23~agrSCH24~agoml0~{esc}rSCH25~agoml5~bcBSCH1~{esc}rSCH13~agrSCH14~agoml0~{esc}rSCH15~agos{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~agPRINT2 {let AF56,Page 1 of 2}{let BB56,Page 2 of 2}~{let CK115,Page 1 of 2}{let DG115,Page 2 of 2}~{let EP177,Page 1 of 2}{let FL177,Page 2 of 2}~/reAP54..AP56~/reCU113..CU115~/reEZ175..EZ177~/ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN3~agoml0~{esc}rTRNS3~agoml5~bcBSCH2~{esc}rSCH23~agoml0~{esc}rSCHE23~agoml5~bcBSCH1~{esc}rSCH13~agoml0~{esc}rSCHE13~agos{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~agPRINTL2 {let AP56,Page 1 of 2}{let BB56,Page 2 of 2}~{let CU115,Page 1 of 2}{let DG115,Page 2 of 2}~{let EZ177,Page 1 of 2}{let FL177,Page 2 of 2}~/ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN4~agoml0~{esc}rTRN5~agoml5~bcBSCH2~{esc}rSCH24~agoml0~{esc}rSCH25~agoml5~bcBSCH1~{esc}rSCH14~agoml0~{esc}rSCH15~agos{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~agPRINT1 {let Ap56,Page 1 of 1}~{let Cu115,Page 1 of 1}~{let Ez177,Page 1 of 1}~/ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRN4~agoml5~bcBSCH2~{esc}rSCH24~agoml5~bcBSCH1~{esc}rSCH14~agoml0~{esc}os{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~agPRINTL1 {let AZ56,Page 1 of 1}~{let DE115,Page 1 of 1}~{let FJ177,Page 1 of 1}~/ppos{esc}\027(s0p12H\027&l1H~ml5~bcBTRN~{esc}rTRNl5~agoml5~bcBSCH2~{esc}rSCHL25~agoml5~bcBSCH1~{esc}rSCHL15~agoml0~{esc}os{esc}\027&l7.27C\027(s0p12H\027&l4H~{esc}cbrAS~agVERY IMPORTANT: BE SURE TO ENTER THE CORRECT PRINTING CODE= =====PRINTING CODE:= ====CodeExplanations----ALL5Printing all five pagesFIRST4Printing 4 yrs.(Yrs. 1, 2, 3 & 4)FIRST3Printing 3 yrs.(yrs.2, 3 & 4)FIRST2Printing 2 yrs.(yrs.3 & 4)FIRST1Printing yr.4LAST4Printing 4 yrs.(Yrs.2,3,4, & 5)LAST3Printing 3 yrs.(yrs.3,4, & 5)LAST2Printing 2 yrs.(yrs.4 & 5)LAST1Printing yr.5Year 5 = most recent year000673
ORIGINAL REVENUE AND TAX REPORTEDPage 1 of 7ORIGINAL REVENUE AND TAX REPORTEDPage 2 of 7ORIGINAL REVENUE AND TAX REPORTEDPage 3 of 7ORIGINAL REVENUE AND TAX REPORTEDPage 4 of 7ORIGINAL REVENUE AND TAX REPORTEDPage 5 of 7ORIGINAL REVENUE AND TAX REPORTEDPage 6 of 7ORIGINAL REVENUE AND TAX REPORTEDPage 7 of 7ORIGINAL REVENUE AND TAX REPORTEDPage 8 of 10ORIGINAL REVENUE AND TAX REPORTEDPage 9 of 10ORIGINAL REVENUE AND TAX REPORTEDPage 10 of 10GrandJanuary February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal Grand TotFebruary March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal TotalREPORTED UTILITY:Gross revenue reported:000000Reported deductions:Reported revenues:00000000000TAX PAID00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000674
Tracfone Wireless, IncData SheetBillingInternet Platform Revenue Non-DirecBilling PlatPage Plus Page Plus APP DirectTotal TaxableSales SalesMO/YR CATEGORYReported Intra-stateIntra-stateIntra-stateIntra-stateIntra-stateRevenue39083Utility TaxNone 8940.808 01962.616 10903.425169.093908939114Utility TaxNone 8197.276 01799.402 9996.6784739.223912039142Utility TaxNone 9381.735 02059.405 11441.14Note: Sales amounts are reduced by three factors. 5424.013914839173Utility TaxNone 8127.899 01784.173 9912.0721)Data is removed.4699.113917939203Utility TaxNone 6926.022 01520.346 8446.3682)Interstate and international is removed.4004.253920939234Utility TaxNone 8871.397 9.4692981937.91 10818.783)A factor to proportion sum of zip population down to city population.5104.02 24.94 3924039264Utility TaxNone 8612.067 9.4692981880.985 10502.524954.09 24.94 3927039295Utility TaxNone 8196.895 15.145561784.173 9996.214DATA:4699.11 39.89 3930139326Utility TaxNone 10324.2 55.016092211.271 12590.48Year 2007 2008 2009 2010 2011 2012 2013 20145823.99 144.9 3933239356Utility TaxNone 9052.977 62.598361924.64 11040.22Data Percentage00.0396 0.1865 0.2508 0.3842 0.41775069.07 164.87 3936239387Utility TaxNone 12433.77 58.771162670.593 15163.130 07033.74 154.79 3939339417Utility TaxNone 11847.41 70.518552530.133 14448.066663.8 185.73 3942339448Utility TaxNone 11360.34 93.510292233.306 13687.15INTRA-STATE:4509.11 188.8 3945439479Utility TaxNone 14968.1 77.160852988.595 18033.866034.06 155.79 3948539508Utility TaxNone 15335.08 137.50673003.414 18476 Year 2007 2008 2009 2010 2011 2012 2013 20146063.98 277.63 3951439539Utility TaxNone 13826.46 117.22962714.696 16658.38 Intrastate 0.8407 0.8407 0.8407 0.8573 0.8397 0.8338 0.8109 0.79335481.05 236.69 3954539569Utility TaxNone 14882.38 181.44362866.754 17930.57 Interstate 0.1539 0.1539 0.1539 0.1411 0.1558 0.1568 0.1717 0.19335788.06 366.34 3957539600Utility TaxNone 13710.31 139.01242669.124 16518.45 Internatio 0.0054 0.0054 0.0054 0.0016 0.0045 0.0094 0.0174 0.01345389.04 280.67 3960639630Utility TaxNone 14029.32 248.91172624.563 16902.79 Total:1 1 1 1 1 1 1 15299.07 502.56 3963639661Utility TaxNone 13671.33 242.48782557.665 16471.495164 489.59 3966739692Utility TaxNone 14747.59 232.5922787.998 17768.185629.05 469.61 3969839722Utility TaxNone 14849.27 216.22272825.194 17890.695704.15 436.56 3972839753Utility TaxNone 15132.05 259.32762840.009 18231.39POPULATION RATIO:5734.06 523.59 3975939783Utility TaxNone 17339.14 325.14143226.249 20890.536513.89 656.47 3978939814Utility TaxNone 16946.67 429.6113290.39 20666.67 Zip populahttps://www.unitedstateszipcodes.org/98057/6429.04 839.41 3982039845Utility TaxNone 13300.54 463.3492456.282 16220.172007 2008 2009 2010 2011 2012 2013 4799.29 905.33 3985139873Utility TaxNone 18442.84 494.55353553.876 22491.276943.86 966.3 3987939904Utility TaxNone 18328.93 597.38973426.033 22352.3598055 20151 19888 20228 20603 19863 19890 20190 6694.07 1167.23 3991039934Utility TaxNone 21610.99 504.24194239.633 26354.8698056 30295 30562 31751 31912 32733 33200 32960 8283.75 985.23 3994039965Utility TaxNone 20571.33 595.8853919.773 25086.9998057 9813 9768 10621 11305 11631 11680 11760 7658.78 1164.29 3997139995Utility TaxNone 20932.51 741.69723853.244 25527.4598058 41080 40762 41061 41326 40371 40450 40800 7528.79 1449.19 4000140026Utility TaxNone 20345.57 640.94913825.151 24811.6798059 32156 32741 33745 34618 35108 35770 36470 7473.9 1252.34 4003240057Utility TaxNone 21559.88 574.91144157.745 26292.54Sum: 133495 133721 137406 139764 139706 140990 142180 8123.75 1123.31 4006340087Utility TaxNone 19578.33 697.71813599.964 23876.017033.91 1363.26 4009340118Utility TaxNone 19461.63 810.29393461.772 23733.7 Renton Pohttps://edocs.rentonwa.gov/Documents/0/edoc/956723/2016%20CAFR%(Page 7-7)6763.9 1583.22 4012440148Utility TaxNone 23058.17 957.64154103.909 28119.728018.56 1871.12 4015440179Utility TaxNone 25916.62 1425.5093882.714 31224.842007 2008 2009 2010 2011 2012 2013 7248.58 2661.26 4018540210Utility TaxNone 25002.17 1388.053732.877 30123.1Renton Po60290 78780 83650 90927 92590 93910 95540 6968.85 2591.33 4021640238Utility TaxNone 29515.79 1956.3824089.021 35561.197633.73 3652.34 4024440269Utility TaxNone 28889.68 1927.2753989.888 34806.847448.66 3598 4027540299Utility TaxNone 29311.31 2128.7873874.733 35314.832007 2008 2009 2010 2011 2012 2013 7233.68 3974.2 4030540330Utility TaxNone 30372.83 2445.2663775.675 36593.77Population0.451627 0.589137 0.60878 0.650575 0.662749 0.666076 0.671965 7048.75 4565.03 4033640360Utility TaxNone 38402.85 2828.7025036.942 46268.499403.39 5280.86 4036640391Utility TaxNone 37172.09 3007.7814605.78 44785.658598.46 5615.18 4039740422Utility TaxNone 36842.89 3374.1564171.977 44389.027788.6 6299.16 4042840452Utility TaxNone 38918.86 3836.8844134.449 46890.27718.54 7163.02 4045840483Utility TaxNone 40788.68 3885.0934469.216 49142.998343.51 7253.02 4048940513Utility TaxNone 48338.65 4628.0045272.682 58239.339843.49 8639.95 4051940544Utility TaxNone 32784.67 4048.2644666.649 41499.5910308 8942.07 4055040575Utility TaxNone 30383.77 4134.1813942.517 38460.478708.49 9131.85 4058140603Utility TaxNone 33118.85 4485.5744318.172 41922.69538.26 9908.03 4060940634Utility TaxNone 33050.8 4637.2044148.451 41836.459163.37 10242.96 4064040664Utility TaxNone 36233.16 4950.8584680.742 45864.7710339.13 10935.78 4067040695Utility TaxNone 32994.03 4871.6413898.925 41764.68612.2 10760.8 4070140725Utility TaxNone 34147.32 4592.384484.755 43224.459906.22 10143.95 4073140756Utility TaxNone 37527.58 4766.7235208.964 47503.2711505.9 10529.05 4076240787Utility TaxNone 37521.11 4446.5995527.367 47495.0812209.21 9821.94 4079340817Utility TaxNone 34178.79 3822.6465262.856 43264.2911624.94 8443.71 4082340848Utility TaxNone 35912.74 3548.7545997.672 45459.1713248.05 7838.72 4085440878Utility TaxNone 36242.77 3504.8996129.255 45876.9213538.7 7741.85 4088440909Utility TaxNone 29608.81 3146.0396204.11 38958.9514910.64 7561.03 4091540940Utility TaxNone 30622.22 3425.6166244.558 40292.3915007.85 8232.95 4094640969Utility TaxNone 32202.46 3589.5546579.644 42371.6615813.18 8626.95 4097541000Utility TaxNone 32780.36 3693.5756658.118 43132.06 016001.78 8876.95 4100641030Utility TaxNone 31633.57 3802.646186.909 41623.1214869.3 9139.07 4103641061Utility TaxNone 34744.37 3977.8126994.095 45716.2816809.25 9560.07 4106741091Utility TaxNone 37745.75 4213.2967706.414 49665.4618521.2 10126.02 4109741122Utility TaxNone 37002.92 4309.847375.292 48688.0517725.4 10358.05 4112841153Utility TaxNone 38343.68 4285.2717823.259 50452.2118802.02 10299 4115941183Utility TaxNone 41082.91 5241.1957732.357 54056.4618583.55 12596.42 4118941214Utility TaxNone 40777.18 5460.1897416.813 53654.1817825.19 13122.74 4122041244Utility TaxNone 43383.7 5687.7518012.366 57083.82 019256.51 13669.65 4125041275Utility TaxNone 31350.87 5057.2546538.273 42946.419485.4 15071.66 4128141306Utility TaxNone 31404.87 4893.5586721.941 43020.3720032.77 14583.81 4131241334Utility TaxNone 33764.86 5978.046510.332 46253.2319402.13 17815.79 4134041365Utility TaxNone 32870.67 6136.5726021.074 45028.3217944.04 18288.25 4137141395Utility TaxNone 44607.07 6601.2799897.225 61105.5729495.77 19673.17 41401#N/A41426Utility TaxDID NOT REPORT0#N/A #N/A #N/A #N/A #N/A#N/A41456Utility TaxDID NOT REPORT041487Utility TaxDID NOT REPORT041518Utility TaxDID NOT REPORT041548Utility TaxDID NOT REPORT041579Utility TaxDID NOT R0041609Utility TaxDID NOT R00 Total Colu 1946395 116783.741640Utility TaxDID NOT R00 Column E: 174200.9 10452.0541671Utility TaxDID NOT R00 Column F: 0 041699Utility TaxDID NOT R00 Column G 0 041730Utility TaxDID NOT R00 Column H 331216 19872.9641760Utility TaxDID NOT R00 Column I: 2451812 147108.741791Utility TaxDID NOT R0041821Utility TaxDID NOT R0041852Utility TaxDID NOT R00Due check:41883Utility TaxDID NOT R00Sum check147108.741913Utility TaxDID NOT R00Horizontal041944Utility TaxDID NOT R0041974Utility TaxDID NOT R0042005Utility TaxDID NOT R0042036Utility TaxDID NOT R0042064Utility TaxDID NOT R0042095Utility TaxDID NOT R0042125Utility TaxDID NOT R0042156Utility TaxDID NOT R0042186Utility TaxDID NOT R0042217Utility TaxDID NOT R0042248Utility TaxDID NOT R0042278Utility TaxDID NOT R0042309Utility TaxDID NOT R0042339Utility TaxDID NOT R0042370Utility TaxDID NOT R0042401Utility TaxDID NOT R0042430Utility TaxDID NOT R0042461Utility TaxDID NOT R0042491Utility TaxDID NOT R0042522Utility TaxDID NOT R0042552Utility TaxDID NOT R0042583Utility TaxDID NOT R0042614Utility TaxDID NOT R00TAXABLE REVENUE PER AUDIT:(Horizontal Tabulation)GrandJanuary February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal Total0000000000000000000000000675
TAX, PENALTY & INTEREST SCHEDULETAX, PENALTY & INTEREST SCHEDULETAX, PENALTY & INTEREST SCHEDULETAX, PENALTY & INTEREST SCHEDULETAX, PENALTY & INTEREST SCHEDULE 0 TAX, PENALTY & INTEREST SCHEDULE0TAX, PENALTY & INTEREST SCHEDULE0TAX, PENALTY & INTEREST SCHEDULE0TAX, PENALTY & INTEREST SCHEDULE0TAX, PENALTY & INTEREST SCHEDULECOMPUTATIONS Page 1 of 7COMPUTATIONSPage 2 of 7COMPUTATIONSPage 3 of 7COMPUTATIONSPage 4 of 7COMPUTATIONSPage 5 of 7COMPUTATIONSPage 6 of 7COMPUTATIONSPage 7 of 7COMPUTATIONSPage 8 of 10COMPUTATIONSPage 9 of 10COMPUTATIONSGrandJanuary February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal Total February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May June July August SeptembeOctober NovemberDecemberTotal January February March April May Jun Jul August SeptembeOctober NovemberDecemberTotalUTILITY: Revenue Per Data Sheet:0 Deductions: Total Ta000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 Tax Due000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 Tax Paid:0000000000 DIFFERE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 Rounding:-0.01TOTAL TAX0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000-0.01 0 000000000000000000000000000000000INTEREST:Note: Renton does not charge interest previous to May 2008.Note: Renton does not charge interest previous to May 2008. Interest 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.1 1.11.1 1.1 1.1 1.1 1.1 1.09 1.08 1.07 1.06 1.05 1.04 1.031.02 1.01 1 0.99 0.98 0.97 0.96 0.95 0.94 0.93 0.92 0.910.9 0.89 0.88 0.87 0.86 0.85 0.84 0.83 0.82 0.81 0.8 0.790.78 0.77 0.76 0.75 0.74 0.73 0.72 0.71 0.7 0.69 0.68 0.670.66 0.65 0.64 0.63 0.62 0.61 0.6 0.59 0.58 0.57 0.56 0.550.54 0.53 0.52 0.51 0.5 Interest0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000PENALTY: Penalty0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.250.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.250.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.250.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.250.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.250.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.25 0.250.25 0.25 0.25 0.25 0.25 Penalty0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 Penalty Paid: DIFFERE0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000TOTAL TAX, INTEREST ANDPENALTY D0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000-0.01 0 0000000000-0.0100000000000000000000000000000#N/ATax Rate: 0.06Tax Rate: 0.06Tax Rate: 0.06Tax Rate: 0.06Tax Rate: 0.06Tax Rate: 0Tax Rate: 0.06Interest St41455Interest En42886-0.002Penalty 000000#N/ADifference0.470466#N/ATax000000#N/A#N/AInt000000#N/A#N/A00#N/A000000000#N/A#N/A00428610414550140600.4622470000000000000000000000000000000000676