**How the WALS Fee is Calculated (with examples from the 2017 budget)**

WALS fees are based on the library's file size (patrons and items) and on the circulation for the prior year. There is also a base fee amount. It is $7,775 for 2017. It was $7,545 in 2016.

The current formula for calculating fees has been used since 2009 but basing library fees on file size, circulation, and a base fee goes back at least to the late 1990s and has been accepted as a fair way of allocating the cost of this service to each library. Many other library systems also base fee calculations on these factors.

We begin the budget process by calculating the next year’s expenditures. Revenues from all other sources (Winnefox, LSTA, Interest, etc) are subtracted from the expenditures. The amount remaining gets shared among the libraries according to the formula. In 2017, WALS expenditures will be $850,068. Of this, $192,320 will come from Winnefox, LSTA, and other sources, leaving $657,477 to be divided among the 29 libraries.

The Formula is calculated based on a library’s “file size” and circulation. “File size” is calculated by the total number of items and cardholders in the database as of the end of the previous year. Circulation is the total number of items checked out in the previous year. Each library’s percent of the total file size, and percent of the total circulation is averaged and that average percentage is used to calculate the library’s initial cost.

The initial cost per library places some libraries below the base cost. We have a base cost because there are other benefits each library receives and related expenses that each library incurs (telecom, internet, website hosting, etc) which are not directly tied to the database size or circulation. Thus the base cost represents a minimum “cost of doing business” regardless of size. So, we bring all the libraries below the base cost up to this amount ($7,775).

There are 14 libraries that will pay the base fee in 2017. (14 x $7,775 = $108,850).

This means that the remaining 15 libraries need to pay $548,627 ($657,477 - $108,850 = $548,627).

However, there is added money ($38,064) that the below-base libraries are paying to bring them up to the baseline. ($108,850 minus the total of the below-base libraries' actual calculation equals $38,064) Therefore, what needs to happen is that the initial cost figure to be paid by the above-base libraries needs to be decreased proportionally by $38,064.

In order to distribute that $38,064 amount proportionally, we need to re-calculate the percentages to be used for adjusting the original calculation figure.

In order to calculate the new percentage, we take the original formula percentages of the total that above-base libraries need to pay ($548,627). These percentages won't total 100% because the small libraries aren't figured in that percentage, but they can be used to get an amount per library. A new percentage is then calculated based on each of the above-base library’s share of the summed total. The new percentages do equal 100%. Each library’s new percentage is then used to divvy up the $38,064.

So, to use Neenah as an example:

1. As of the end of 2015, Neenah has a file size of 257,057 records. This is the total of their items in the database and their cardholders. This is 18% of the total file size of 1,410,776 records

2. Neenah checked out 895,341 items in 2015. This is 28% of the 3,194,524 items checked out by all 29 libraries.

3. Those two percentages are averaged to get 23%.

4. According to the original formula, Neenah should owe $152,099, which is 23% of $657,749.

5. But Neenah should also get a percentage "discount" from bringing the sub-base libraries up to base.

6. So, we take 23% of $548,092 in order to get Neenah's "share" of that total above-base cost ($126,928)

7. Then we use the sum of all the above-base "shares" ($489,829) to calculate what percentage of the $38,064 Neenah should be "discounted" ($126,928 divided by $489,829 = 0.2591 or 26%)

8. Then take the percentage from Step 7 and multiply it by $38,064 to get $9,863

9. Then subtract $9,863 from the original $152,099 to get $142,236, which is the Neenah Public Library’s 2017 fee.

Note that because Excel calculates to many more decimal places than shown here these calculations will be slightly different if done on a calculator.

When this process is repeated for all the above-base libraries, the total new fee for libraries above base equals $548,902 and the sum of the individual "discounts" equals the $38,064 and the above-base libraries have picked up 100% of the $548,902.

When the sum of all the libraries (above and below base) is totaled it equals the required $657,751