HomeMy WebLinkAboutEx 14 Email J Hawn to TRS Aug 10 2017.pdf1
Nate Malone
From:Jan Hawn <jhawn@rentonwa.gov>
Sent:Thursday, August 10, 2017 8:09 AM
To:'TRS'; Nate Malone
Subject:RE: TracFone Schedules
Thanks, Tamara. I realize there’s a fair amount of estimation involved and I’m fine with your approach.
Jan
From: TRS [mailto:crisp@trs‐integrity.com]
Sent: Tuesday, August 8, 2017 2:36 PM
To: Jan Hawn <JHawn@Rentonwa.gov>; Nate Malone <NMalone@Rentonwa.gov>
Subject: Re: TracFone Schedules
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
000677
11.17.2020
T Crisp
17
Buell Realtime Reporting
2
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
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.
000678