Unregistered Carriers on 6/30/2009 - 3252
Unregistered Carriers on 7/1/2009 - 3204
Yesterday's Registrations (IL system) - 18 / $1,548 (avg $76)
Notice that I titled this post the "art" of reconciliation and not the "science" of reconciliation. Trying to figure out all the ways that carriers get on and off the list is still more of an art for us, but since we're going to attempt a reconciliation today, I'm going to share some of our findings with you.
First, notice that 48 carriers (net) came off our list (see above). We went from 3252 carriers on our unregistered list to 3204.
In actuality, 49 carriers were removed from the list and one carrier came onto the list in "sideways" fashion - through an MCS-150 update - for a net removal of 48 carriers.
Next, we registered 18 carriers in the IL system yesterday (see above). However, only 9 of those carriers were on our unregistered list, so that only accounted for 9 carriers removed from the list. In case you're wondering, 5 carriers had brand-new USDOT numbers and weren't even in SAFER yet. More on that later. That leaves 4 guys who registered, but who weren't on our unregistered list because they didn't fit the filter criteria for the list. Whew!
Next, two more of our previously-unregistered IL carriers registered in the Indiana system.
Things get sticky after this, so I'm going to stop for now and pick up in tomorrow's post. My hat's off to you if you've followed me this far!
Tuesday, June 30, 2009
Monday, June 29, 2009
OK - We're Baselined! I think!
Unregistered Carriers on 6/29/2009 - 3350
Unregistered Carriers on 6/30/2009 - 3252
Yesterday's Registrations (IL system) - 43 / $3,828 (avg $90)
After all the dust settled, we wound up with another 100 carriers off of our list. We're checking to see who they were and how they got off the list, but, with any luck, we're finished with the baselining. And we're 100 carriers closer to our goal!
We are perfecting our UCR reconciliation process, although we have a long way to go before it's perfect. In other words, we are trying to figure out more specifically how people get on and off our list by reconciling them like we do our bank deposits. Again, while we have a general idea, we have a long way to go before we'll be confident. But the reconciliation process is what pointed us toward the aforementioned glitch a few days ago, which may have saved some people some needless aggravation related to unwarranted UCR tickets at the roadside.
Tomorrow, I'll talk more about the reconciliation process.
Unregistered Carriers on 6/30/2009 - 3252
Yesterday's Registrations (IL system) - 43 / $3,828 (avg $90)
After all the dust settled, we wound up with another 100 carriers off of our list. We're checking to see who they were and how they got off the list, but, with any luck, we're finished with the baselining. And we're 100 carriers closer to our goal!
We are perfecting our UCR reconciliation process, although we have a long way to go before it's perfect. In other words, we are trying to figure out more specifically how people get on and off our list by reconciling them like we do our bank deposits. Again, while we have a general idea, we have a long way to go before we'll be confident. But the reconciliation process is what pointed us toward the aforementioned glitch a few days ago, which may have saved some people some needless aggravation related to unwarranted UCR tickets at the roadside.
Tomorrow, I'll talk more about the reconciliation process.
Friday, June 26, 2009
I'm A Little Hesitant To Blog Today
Unregistered Carriers on 6/26/2009 - 3363
Unregistered Carriers on 6/29/2009 - 3350
Yesterday's Registrations (IL system) - 14 / $1,084 (avg $77)
In my last post, I mentioned a glitch we found and the baseline that we ran to get things up to date. Well, seems as though our baseline update threw the Feds for a loop - so we still don't know the results of the update. With any luck, we should have some new numbers tomorrow. I'll keep you posted.
Unregistered Carriers on 6/29/2009 - 3350
Yesterday's Registrations (IL system) - 14 / $1,084 (avg $77)
In my last post, I mentioned a glitch we found and the baseline that we ran to get things up to date. Well, seems as though our baseline update threw the Feds for a loop - so we still don't know the results of the update. With any luck, we should have some new numbers tomorrow. I'll keep you posted.
Thursday, June 25, 2009
A Funny Thing Happened On The Way To Yesterday's Blog!
Unregistered Carriers on 6/25/2009 - 3370
Unregistered Carriers on 6/26/2009 - 3363
Yesterday's Registrations (IL system) - 20 / $1,932 (avg $96)
As I was analyzing reports in preparation for yesterday's blog, I noticed that we had registered 32 carriers the day before ..... but Iteris only showed an increase of 15 registrations. One thing led to another, and we discovered a glitch in the update process (on our end) between us to Iteris. Had I not done the blog, we may not have discovered the glitch for quite some time, if ever! We ran a new baseline - all the 2009 registrations since 9/1/08 - and sent it to Iteris. We won't know anything until this weekend.
Unregistered Carriers on 6/26/2009 - 3363
Yesterday's Registrations (IL system) - 20 / $1,932 (avg $96)
As I was analyzing reports in preparation for yesterday's blog, I noticed that we had registered 32 carriers the day before ..... but Iteris only showed an increase of 15 registrations. One thing led to another, and we discovered a glitch in the update process (on our end) between us to Iteris. Had I not done the blog, we may not have discovered the glitch for quite some time, if ever! We ran a new baseline - all the 2009 registrations since 9/1/08 - and sent it to Iteris. We won't know anything until this weekend.
Wednesday, June 24, 2009
UCR - Comparison of Big States
Unregistered Carriers on 6/24/2009 - 3385
Unregistered Carriers on 6/25/2009 - 3370
Yesterday's Registrations (IL system) - 32 / $2,363 (avg $74)
I did some research this morning on the number of carriers we are registering vis-a-vis other states with a lot of carriers. I'm not talking about percentages here, but rather the total number of registrations we have processed.
In order, the top 5 states in terms of 2009 registrations to date (with # of unregistered carriers in parenthesis) are:
California - 17,666 (10,416)
Illinois - 15,536 (3,370)
Texas - 14,148 (6,485)
New York - 12,249 (4,041)
Pennsylvania - 11,886 (6,161)
I then looked at the number of 2009 registrations each of us has done since June 1. Lacking any better hypothesis, I figured that if there was nothing exceptional about what we're doing here, the registrations in June would be roughly proportional to the number of unregistered carriers each of us has left. Here are the actual registrations in June:
Illinois - 684
Texas - 450
California - 432
New York - 236
Pennsylvania - 131
So much for my hypothesis! What do these numbers mean? Beats me! But here's what I think it means:
We registered 50% more carriers than the next nearest state because we are actively soliciting our carriers using UCR-Link, our spreadsheet comparer and email. It's no extra work - just different work at less expense! Now that's a fine example of "Dave-math"!!!
Unregistered Carriers on 6/25/2009 - 3370
Yesterday's Registrations (IL system) - 32 / $2,363 (avg $74)
I did some research this morning on the number of carriers we are registering vis-a-vis other states with a lot of carriers. I'm not talking about percentages here, but rather the total number of registrations we have processed.
In order, the top 5 states in terms of 2009 registrations to date (with # of unregistered carriers in parenthesis) are:
California - 17,666 (10,416)
Illinois - 15,536 (3,370)
Texas - 14,148 (6,485)
New York - 12,249 (4,041)
Pennsylvania - 11,886 (6,161)
I then looked at the number of 2009 registrations each of us has done since June 1. Lacking any better hypothesis, I figured that if there was nothing exceptional about what we're doing here, the registrations in June would be roughly proportional to the number of unregistered carriers each of us has left. Here are the actual registrations in June:
Illinois - 684
Texas - 450
California - 432
New York - 236
Pennsylvania - 131
So much for my hypothesis! What do these numbers mean? Beats me! But here's what I think it means:
We registered 50% more carriers than the next nearest state because we are actively soliciting our carriers using UCR-Link, our spreadsheet comparer and email. It's no extra work - just different work at less expense! Now that's a fine example of "Dave-math"!!!
Farmers and UCR
Unregistered Carriers on 6/23/2009 - 3394
Unregistered Carriers on 6/24/2009 - 3385
Yesterday's Registrations (IL system) - 18 / $1,202 (avg $67)
Deactivations Requested - 2
Last week, our police conducted a several-day detail in a remote part of the state near the state line. We wondered how our farmers - who have not been subject to SSRS and have apparently never been challenged to have USDOT numbers - would fare in this kind of situation.
To our surprise and pleasure, the police wrote only one UCR warning to one farmer - even though they checked the status of several hundred of them.
What does this tell us? Apparently, the UCR message is getting across.
We have worked very hard through our state and county farm bureaus to get the word out to farmers about USDOT numbers and UCR. We have registered literally thousands of farmers under UCR.
These results make us wonder what other groups we should be focusing on. Interstate towers got a lot of citations. Maybe it's time to put our attention there.
Unregistered Carriers on 6/24/2009 - 3385
Yesterday's Registrations (IL system) - 18 / $1,202 (avg $67)
Deactivations Requested - 2
Last week, our police conducted a several-day detail in a remote part of the state near the state line. We wondered how our farmers - who have not been subject to SSRS and have apparently never been challenged to have USDOT numbers - would fare in this kind of situation.
To our surprise and pleasure, the police wrote only one UCR warning to one farmer - even though they checked the status of several hundred of them.
What does this tell us? Apparently, the UCR message is getting across.
We have worked very hard through our state and county farm bureaus to get the word out to farmers about USDOT numbers and UCR. We have registered literally thousands of farmers under UCR.
These results make us wonder what other groups we should be focusing on. Interstate towers got a lot of citations. Maybe it's time to put our attention there.
Tuesday, June 23, 2009
The New Carriers Just Keep Coming!
Unregistered Carriers on 6/22/2009 - 3427
Unregistered Carriers on 6/23/2009 - 3394
Yesterday's Registrations (IL system) - 56 / $5,758 (avg $102)
Deactivations Requested - 5
Notice that we registered 56 carriers yesterday and we requested 5 deactivations - but we only reduced our unregistered list by 33! The difference is attributable to new additions - at least 28 of them. Of that amount, about half were new USDOT numbers and about half were "sideways" additions. And they all represent "hot leads" for UCR registration.
As I've said before, I'm becoming a believer in the reality of the UCR "universe" - although I believe there are less carriers in the higher brackets and more carriers in the lower brackets.
One other item: we are now officially past the one-third mark in our "quest for zero". It has taken us about 100 calendar days to remove the first 1700 carriers from our unregistered list. At that rate, we are going to get very close to reaching zero by the end of the calendar year.
Unregistered Carriers on 6/23/2009 - 3394
Yesterday's Registrations (IL system) - 56 / $5,758 (avg $102)
Deactivations Requested - 5
Notice that we registered 56 carriers yesterday and we requested 5 deactivations - but we only reduced our unregistered list by 33! The difference is attributable to new additions - at least 28 of them. Of that amount, about half were new USDOT numbers and about half were "sideways" additions. And they all represent "hot leads" for UCR registration.
As I've said before, I'm becoming a believer in the reality of the UCR "universe" - although I believe there are less carriers in the higher brackets and more carriers in the lower brackets.
One other item: we are now officially past the one-third mark in our "quest for zero". It has taken us about 100 calendar days to remove the first 1700 carriers from our unregistered list. At that rate, we are going to get very close to reaching zero by the end of the calendar year.
Subscribe to:
Posts (Atom)