HomeMy WebLinkAbout8-8-2017 TRS TRACFONE SCHEDULES EMAILThanks, 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 <https://edocs.rentonwa.gov/Documents/0/edoc/956723/2016%20CAF
R%20-%20City%20of%20Renton,%20WA.pdf> . 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.
䘀䘀