Data note: I am relying here on the numbers reported by the Norman Transcript (thanks, Joy Hampton!) here - http://www.normantranscript.com/news/government/sales-tax-downturn-continues/article_81c22f05-03a1-5f7f-b988-7660ca80fc8d.html - and here - http://www.normantranscript.com/news/government/sales-tax-leaps-with-extra-calendar-day/article_6e085efb-7998-5a69-bf1b-13fde34f95c5.html. If you have different numbers, please let me know and we will work them into the analysis!
January, method 1
The January benchmark was $870,665.
The January NFST collection was $728,243.
The January shortfall was $142,422, 16.36% of the benchmark.
February, method 1
The February benchmark was $814,493.
The February NFST collection was $776,747.
The February shortfall was $37,746, 4.63% of the benchmark.
Year to date, method 1
The YTD benchmark was $1,685,158.
The YTD NFST collection was $1,504,990.
The YTD shortfall was $180,168, 10.69% of the benchmark.
January, method 2
The January benchmark was $779,183.
The January NFST collection was $728,243.
The January shortfall was $50,940, 6.54% of the benchmark.
February, method 2
The February benchmark was $834,692.
The February NFST collection was $776,747.
The February shortfall was $57,945, 6.94% of the benchmark.
Year to date, method 2
The YTD benchmark was $1,613,876.
The YTD NFST collection was $1,504,990.
The YTD shortfall was $108,886, 6.75% of the benchmark.
Thursday, April 14, 2016
Methodology
The City’s projected revenue for each year of Norman Forward is a matter of public record. The latest information that I have found is here - http://www.normanok.gov/sites/default/files/Features/July%2014%20CC%20Conf%20-%20Norman%20Forward.pdf - and these were the projections used in the Norman Forward election campaign. Calendar year 2016 was the first year for NFST collection and the projected revenue was $10,279,463.
I have calculated monthly ‘benchmarks’ so we can see how much progress we are making toward our revenue goals. I used two different ways of calculating the benchmarks.
The first method involves calculating the average daily NFST we would need in order to reach the goal ($10,279,463/366 days = $28,086/day) and assigning to each month a benchmark based on the number of days per month (e.g., 31 day months need to create an income of $870,665 [= $28,086/day * 31 days]). This, of course, is a pretty simplistic, linear model of revenue projection.
The second method is meant to address the simplistic assumptions of the first. Different months are better for sales tax collection than others. In order to get a handle on that, I used historical data on monthly taxable sales in Norman from 1980 to 2012 (from origins.ou.edu) to calculate an average percentage of yearly taxable sales per month. The results were about what you would expect - December accounts for 9.54% of yearly taxable sales; January for only 7.58% - with a few mild surprises - February accounts for more taxable sales (8.12%) than either March (7.99%) or October (7.86%). I used these averages to calculate the benchmarks for each month: January NFST collections should account for 7.58% of the yearly target; February NFST collections should account for 8.12% of the yearly target; etc.
The spreadsheet where all of this is worked out is here: https://docs.google.com/spreadsheets/d/1WGVk7LiaQbPyImSnmBmb8gcUMqPliP3DT_J1e1ArWDI.
I have calculated monthly ‘benchmarks’ so we can see how much progress we are making toward our revenue goals. I used two different ways of calculating the benchmarks.
The first method involves calculating the average daily NFST we would need in order to reach the goal ($10,279,463/366 days = $28,086/day) and assigning to each month a benchmark based on the number of days per month (e.g., 31 day months need to create an income of $870,665 [= $28,086/day * 31 days]). This, of course, is a pretty simplistic, linear model of revenue projection.
The second method is meant to address the simplistic assumptions of the first. Different months are better for sales tax collection than others. In order to get a handle on that, I used historical data on monthly taxable sales in Norman from 1980 to 2012 (from origins.ou.edu) to calculate an average percentage of yearly taxable sales per month. The results were about what you would expect - December accounts for 9.54% of yearly taxable sales; January for only 7.58% - with a few mild surprises - February accounts for more taxable sales (8.12%) than either March (7.99%) or October (7.86%). I used these averages to calculate the benchmarks for each month: January NFST collections should account for 7.58% of the yearly target; February NFST collections should account for 8.12% of the yearly target; etc.
The spreadsheet where all of this is worked out is here: https://docs.google.com/spreadsheets/d/1WGVk7LiaQbPyImSnmBmb8gcUMqPliP3DT_J1e1ArWDI.
Introduction
It has become increasingly clear that you can’t really trust the City of Norman to provide timely, relevant information (or to even follow its own rules, really). It is possible, however, to figure out some things we, as citizens, need to know without relying on the City. If we want to make good decisions going forward, we will need to do exactly that.
As a partial step in this direction, I am setting up this blog to track Norman Forward Sales Tax (NFST) revenues. I will be following the media reports about sales tax receipts and comparing them with our revenue goals.
I recognize that there are lots of ways to ‘slice this pie’. I am going to start with two - described in a methodology post to follow - but I invite other suggestions. I am also interested in hearing, in particular, about other sources for the latest NFST data. Ultimately, I would like to influence the City into doing something like this on its own - this is the sort of information people need to make decisions, not soothing reassurances or dire warnings.
As a partial step in this direction, I am setting up this blog to track Norman Forward Sales Tax (NFST) revenues. I will be following the media reports about sales tax receipts and comparing them with our revenue goals.
I recognize that there are lots of ways to ‘slice this pie’. I am going to start with two - described in a methodology post to follow - but I invite other suggestions. I am also interested in hearing, in particular, about other sources for the latest NFST data. Ultimately, I would like to influence the City into doing something like this on its own - this is the sort of information people need to make decisions, not soothing reassurances or dire warnings.
Subscribe to:
Posts (Atom)