I was wondering how you guys feel about using VIN assignment date + VIN as tracked in the
Model S tracker spreadsheet to deduce incoming Model S order rates and hence Model S demand? It seems like a very valid method. Since quite some time VIN assignment follows automatically after an order confirms, most often the same day, sometimes maybe one or two days late. Tesla also assigns VINs sequentially so the mapping with orders is one to one, with the exception of cars built for demo, testing and inventory purposes. Cars build for inventory in a certain period cancel more or less out with cars taken up from inventory by demand in that period, so it is reasonably to assume their effect on demand is more or less neutral. Pure demo cars are probably far and few between and testing certainly so : these numbers should be quite low : over the last 4 years, a little over 6000 more VINs were attributed than there were deliveries, or 125/month. Due to increasing number of stores lately, I would put the number a little over that average, let's say 150/month.
So, then, my basic procedure to estimate current demand in a certain period is to simply subtract the last assigned VIN (corresponding with the last confirmed order) with the first assigned VIN (corresponding with the first confirmed order). Finally, subtract 150 cars/month to get instant demand for that period. How valid do you think this method is for estimating demand?
Doing so over the first half of this year gives me an incoming order rate (hence demand) of 25240 or 50480 yearly. Doing the same exercise for the last month yields and incoming demand of 4450 or an half-yearly rate of 53400. Extrapolating over a single month to a full year is inherently more noisy than over 6 months.
Note : demand does not map one to one to deliveries in a given quarter and this number specifically does not try to predict deliveries but strictly customer demand.
Unfortunately, we can't yet do the same thing for the model X because VIN assignments aren't (yet) mapping one to one with orders, but this will probably happen once all options and all regions are served, at which point we should have a full picture on the incoming S and X demand.