Show Me The Money! On the Road to 98%

Illinois - 97.44%
Maine - 96.41%
Indiana - 92.68%
Alabama - 91.99%
Kentucky - 89.83%
Oklahoma - 89.69%

As of this morning, we have 556 carriers left on our Unregistered List. If they all pay in accordance with the MCMIS numbers, we'll generate another $59,564. Not exactly the stuff of financial dreams, but ... very consistent with the "average of $80-100 per registration theory".

You may find this surprising, but I like to develop little spreadsheets that tell me different things about UCR stats. One of my favorites is a report I call the UCR Daily Activity report, where I monitor all of today's different UCR activities like registration, deactivations, buffer additions, carrier additions, etc. and attempt to decipher where our percentage is likely to wind up tomorrow morning. It's trickier than it sounds, because we don't know how many carriers the Feds are going to add overnight. Also, as you know, not every registered carrier comes off the Unregistered List.

I have an extra little section on that worksheet that contains the data about the other leading registration states and where we stand compared to them. Since we're almost half-way to 98%, I decided to calculate what the other states would have to do to get to 98%. It goes something like this:

We will have to take approximately 116 of carriers off our remaining 556 unregistered carriers (about 21%) to get to 98%.

Maine would have to take approximately 48 carriers off their remaining 110 unregistered carriers (about 44%) to get to 98%.

Indiana would have to take approximately 725 carriers off their remaining 993 unregistered carriers (about 73%) to get to 98%.

Alabama would have to take approximately 475 carriers off their remaining 636 unregistered carriers (about 75%) to get to 98%.

Hey, it ain't easy!