Inventory Recommendations from Spreadsheet to Easy Street

One of our first clients in the Automotive Aftermarket was a manufacturer of replacement parts. They had developed their own in-house methodology for generating inventory stocking recommendations for their customers. They didn’t need us to reinvent the wheel. But, they had problems applying their methodology efficiently.

They had built their system in Microsoft Excel and it was a fairly complicated process to generate SKU-level recommendations. It required a lot of copy-paste to get the right data in the right spreadsheet cells. And the manual data input process led to frequent mistakes and frustrations. Because of this, they had 2 full-time analysts who spent almost all their time waist-deep in the spreadsheet trying to keep up with requests for data-driven recommendations.

We suggested that we take their approach and spreadsheet and convert it into a web application. This had several benefits and a rapid ROI:

How Many Honda Accords are there in New York?

This simple question is at the core of what VIO data are all about.

Imagine the entrepreneur who has invented an innovative aftermarket replacement part. The part might fit dozens of different models but, for the sake of a simple illustration, let’s say it only fits the Honda Accord. So, finding out the vehicle population is the same as finding out the size of the market for this new part. And this is the denominator in the equation to calculate market share. Pretty important number, explaining why companies are willing to spend money on VIO.

According to data we downloaded and processed from, the answer to the question is there are approximately 300,000 Honda Accords in New York state.

Hey, why not give the exact number? Because all VIO data are estimates.

Even if we retrieve the data today, this minute, it would be just a static snapshot of registration records. New vehicle sales in the past month won’t show up. Recently purchased vehicles registered in a neighboring state won’t show up. Recently scrapped vehicles will still be counted. Occasionally people drive to another state and need a repair. Heck, some people register their vehicle in another state…for tax reasons or whatever. Sometimes vehicle registrations are clustered in a corporate or government office location even though the vehicles themselves are spread around the state or the country. It doesn’t matter how hard you try, the best count you can get is an estimate. If you’re thinking you’ll gain significant advantage from obtaining higher levels of precision you may be missing the mathematical forest for the trees.