Ask Ratbert

[Powelligator]

Been seeing a lot of people getting their new Jeep. They all seem to be Snazzberry. Do you think they are doing chunks by color?

If so, I wonder when Sarge Green (my JLU Willys order) will start up.

Snazzberry was discontinued in January, but available to order in October, November and December. There are still orders from those months yet to be built so I'm thinking they are finally realizing that in order to fully support new colors (the paint shop can only handle 10 different colors at a time) they are going to have to get those last Snazzberry's out the door.

Sponsored

 

[Ratbert]

I've written a lot of code that extracts details like this directly (via Java's JPA infrastructure) instead of through SQL. The results are a bit different than what SQL was giving me. That's disturbing, but I've verified that this all seems to match reality. I no longer have to try to copy / paste / merge / format these details since the code does all of that for me now.

I also discovered that my 2020 database had a handful of out of range VINs in it. That resulted in me erroneously thinking that 14.7% of builds didn't eventually get window stickers. That's actually in the ballpark of 1%.

sequence number ranges	% w/build sheets	% w/window stickers
100000-110000	90.7​	83.2​
110000-120000	85.2​	79.6​
120000-130000	83.4​	74.1​
130000-140000	90.3​	52.8​
140000-150000	82.9​	52.0​
150000-160000	73.8​	65.5​
160000-170000	77.3​	52.6​
170000-180000	68.5​	58.8​
180000-190000	65.6​	43.3​
190000-200000	45.4​	38.7​
200000-210000	28.2​	21.3​
210000-220000	9.7​	5.1​
220000-230000	0.7​	0.5​

 

[TriumphJeepster]

I've written a lot of code that extracts details like this directly (via Java's JPA infrastructure) instead of through SQL. The results are a bit different than what SQL was giving me. That's disturbing, but I've verified that this all seems to match reality. I no longer have to try to copy / paste / merge / format these details since the code does all of that for me now.

I also discovered that my 2020 database had a handful of out of range VINs in it. That resulted in me erroneously thinking that 14.7% of builds didn't eventually get window stickers. That's actually in the ballpark of 1%.

sequence number ranges	% w/build sheets	% w/window stickers
100000-110000	90.7​	83.2​
110000-120000	85.2​	79.6​
120000-130000	83.4​	74.1​
130000-140000	90.3​	52.8​
140000-150000	82.9​	52.0​
150000-160000	73.8​	65.5​
160000-170000	77.3​	52.6​
170000-180000	68.5​	58.8​
180000-190000	65.6​	43.3​
190000-200000	45.4​	38.7​
200000-210000	28.2​	21.3​
210000-220000	9.7​	5.1​
220000-230000	0.7​	0.5​

Question, could you make note of roughly where the start of a month falls?

Example, 14473 is a feb 4th order, so 140000 is feb start.

Would be interesting to see if its a steady rate of jeeps going on order, or if there are trends (like say spring, or whatever month the new model year drops) where more people pull the trigger more.

If that doesn't align with what you're doing disregard, just some random thoughts. Love the work you do!

 

[Ratbert]

Question, could you make note of roughly where the start of a month falls?

Example, 14473 is a feb 4th order, so 140000 is feb start.

Would be interesting to see if its a steady rate of jeeps going on order, or if there are trends (like say spring, or whatever month the new model year drops) where more people pull the trigger more.

If that doesn't align with what you're doing disregard, just some random thoughts. Love the work you do!

I have that query written in (really ugly) SQL and have posted it a few times, but it's extremely manual to translate that into a usable forum table format. I'll see if I can implement it in Java tomorrow.

 

[Ratbert]

Question, could you make note of roughly where the start of a month falls?

Example, 14473 is a feb 4th order, so 140000 is feb start.

Would be interesting to see if its a steady rate of jeeps going on order, or if there are trends (like say spring, or whatever month the new model year drops) where more people pull the trigger more.

If that doesn't align with what you're doing disregard, just some random thoughts. Love the work you do!

I've rewritten the query in Java. It's now significantly easier to maintain and (for me at least) understand. This is using the months defined here.

month	% w/build sheets	% w/window stickers
Oct '21	91.1​	85.2​
Nov '21	83.4​	78.3​
Dec '21	84.1​	60.2​
Jan '22	71.5​	54.5​
Feb '22	38.6​	30.4​
Mar '22	3.5​	2.0​

 

[TriumphJeepster]

I've rewritten the query in Java. It's now significantly easier to maintain and (for me at least) understand. This is using the months defined here.

month	% w/build sheets	% w/window stickers
Oct '21	91.1​	85.2​
Nov '21	83.4​	78.3​
Dec '21	84.1​	60.2​
Jan '22	71.5​	54.5​
Feb '22	38.6​	30.4​
Mar '22	3.5​	2.0​

Incredible!!! Thank you so much for all you do.

 

[CJ SCION]

Ordered 2022-03-31 1:42 PM eastern, 235874

 

[BrokenDana35]

Have you have seen any built with the 4.88 gear option (sales code DMS)?

I ordered within the first couple weeks the option became in January and expect to be in it for the looooong haul

 

[Stumeat]

Have you have seen any built with the 4.88 gear option (sales code DMS)?

I ordered within the first couple weeks the option became in January and expect to be in it for the looooong haul

I ordered 01/31
VIN: 1C4HJXCG8NW188563
VON: 53742349
Currently built, in status KZS, awaiting train.

 

[Ratbert]

Have you have seen any built with the 4.88 gear option (sales code DMS)?

I ordered within the first couple weeks the option became in January and expect to be in it for the looooong haul

Pretty rare. The bump at the start is due to that being the first day that I ran my extract.

2022-03-19 46
2022-03-21 1
2022-03-27 1
2022-03-28 4
2022-03-29 3
2022-03-30 2
2022-04-03 2
2022-04-05 2
2022-04-06 1
2022-04-08 1
2022-04-09 1
2022-04-11 4
2022-04-13 1

 

[Ratbert]

I ordered 01/31
VIN: 1C4HJXCG8NW188563
VON: 53742349
Currently built, in status KZS, awaiting train.

Thanks, but we already have one from slightly later in that day.

 

[Powelligator]

 

[TriumphJeepster]

How awesome is that! What was your full build?

 

[Stumeat]

My build sheet updated on 03/24 but I do not see it here?

https://www.jeep.com/webselfservice/BuildSheetServlet?vin=1C4HJXCG8NW188563

 

[ogo]

My build sheet updated on 03/24 but I do not see it here?

https://www.jeep.com/webselfservice/BuildSheetServlet?vin=1C4HJXCG8NW188563

Your Window Sticker shows the 4.88 gears
https://www.jeep.com/hostd/windowsticker/getWindowStickerPdf.do?vin=1C4HJXCG8NW188563

Sponsored