I'd say that half of the load of the Lydden at the end of Q3 probably remained undelivered as well - so I'd say Q3 was 30.5 loading days, and Q4 gets +0.5 loading days...
There are
always undelivered cars at EOQ. Otherwise deliveries would drop to zero until the first ship of the new quarter arrives.
The last ship left on the 29th, so it's 60 days,...
First ship docked at Pier 80 on 9/29, so back to 61 days.
That's almost 34k international deliveries distributed among 30.5 loading days - so 1,107 cars per loading day.
If you're going to try for that level of precision you need to look at multiple quarters and try to adjust for inventory. Here's a rough cut using 1150 Model 3s per loading day for Europe and TMC delivery #s:
Q1 - 26,450 arrived, 19,800 delivered. EOQ inventory 6,650
Q2 - 17,700 arrived, 18,400 delivered. EOQ inventory 5,950
Q3 - 23,400 arrived, 26,600 delivered. EOQ inventory 2,750
Q4 - 30,500 expected to arrive, 30,500 expected deliveries
These EOQ inventories line up very well with deliveries before the first ship arrives in the following quarter. Now using 800/day for China and quarterly #s from EV-Sales (their monthly estimates don't always sum properly):
Q1 - 13,600 arrived, 5300 delivered. EOQ inventory 8300
Q2 - 5600 arrived, 8100 delivered. EOQ inventory 5800
Q3 - 8600 arrived, 6000 delivered. EOQ inventory 8400
Q4 - 12,800 expected to arrive, ??? deliveries
Note: this excludes Glovis Sonic which went to Japan in April. So 43,300 shipped from Pier 80 so far in Q4 plus 2.47 loading days for the two ships to Korea. Let's say those are 1000/day for 45,800 total ship loadings over 61 days. That's 5250/week. Still below Q3 production rate of 6000+/week, leaving room for limited US/Canada deliveries in October/November.
I can't explain why ships to China only get 800 Model 3s per day, but that's what the data suggests. In fact, China inventory looks too high so it probably should be even less than 800/day. Your 1100+ per day works for Europe, but gives goofball numbers for China.
That notion seems to be contradicted by the Troy's survey cited by
@ReflexFunds, which suggests at least same levels of U.S. deliveries in the first two months of Q4 as in Q3:
I don't know what to make of Troy's data. Sometimes it's predictive, sometimes way off. He predicts 104k deliveries in Q4, FWIW. I say 106k.
The Panasonic report is this one:
I did the same Panasonic math. I just think most of those extra cells go to China and Energy Storage. The latter is laughably short of Musk's 3 GWh goal for 2019 and needs 879 MWh just to hit official guidance of 2 GWh. Carsonight says half of the 2nd floor is now dedicated to storage. The 20% gain is ~1200 MWh, lacking hard data I'd split it 400/400/400 between Storage, China and Fremont as a first approximation. Even it's 200/200/800 that's still only ~91k Model 3s from Fremont, a 7k/week average.
No matter how I work the numbers I can't get Fremont at 8-9k Model 3s per week. My best Q4 estimate is 18k S/X and 88k Model 3s. Maybe add a 1-2k Made in China Model 3s, but that seems iffy for Q4.