What's new
Ram Heavy Duty Forum

Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

2022 HD Crowdsourced VIN/Order Tracking

It must be a huge effort to maintain this spreadsheet but to what end? The tracker has all the most up to date individual information available to users while the spreadsheet is a historical perspective/tabulation only. What I would like to know is how the dealers access the most specific and up to date information. The secret code and site only available to 007 agents of RAM.

Overall it was a time to make sense of the lack of transparency and communication from the manufacturer. I have done this at the request of another forum member couple of posts to calculate the average time of the different stages of the build, with models and cab styles.

The tracker now has some details and better visibility but not everything.

I do think there is still some usefulness in the power of numbers and metrics as a way to peek into the machine/behind the curtain, lastly applying the applicable averages

What the forum and spreadsheet did for me, was make it a little easier to play the waiting game for my truck.
I never expected any perfect answer, just a group of expectant truck owners being able to communicate and pass the time with some sort of knowledge as to how this process is convoluted.
I found this forum about a month after ordering my truck and I greatly appreciate that it was set up (BrutalHO,/OfficerDirtySanchez), and have continued updates (QuatroCS).
 
What the forum and spreadsheet did for me, was make it a little easier to play the waiting game for my truck.
I never expected any perfect answer, just a group of expectant truck owners being able to communicate and pass the time with some sort of knowledge as to how this process is convoluted.
I found this forum about a month after ordering my truck and I greatly appreciate that it was set up (BrutalHO,/OfficerDirtySanchez), and have continued updates (QuatroCS).
About the same situation with me, i noticed this thread about a month after as well. And it sure has been helpful. As its difficult to acquire regular updates without also looking hopelessly desperate to your dealer. So i definatly second the thanks to quattro, BV, sanchez for all the work. Before covid it was a much easier process as it only took 3 months from order to delivery, or less. I am at 92 days now since order, if i remember right quattro said i had a aug 27th build day last time he checked. But i dont think its built yet... i could be wrong though. I am sure dates change regularily
 
Alright Folks, here we go on weekly update ;-), Apologies for the delay
Happy to see some movement on the Build of last year is almost all caught up (7 out of 960 pending, 99.3% complete) 5 Pending Delivery and 2 Pending build (55 canceled orders also play a part in the overall situation)
(942 (924 already delivered + 14 pending delivery + 4 Pending build) is a more realistic number for 2021)


Overall numbers from last week (Pretty good week) with overall completion rates
5 more orders added
13 Built - Overall 97.8% complete total (currently sitting at 34 units left to build) - Rome wasn't built in a day ;-) - Less than 50 units left to build overall, potentially less because of discrepancies from other quarters - Actual sheet analysis shows only 26 orders left to build.
6 Delivered - Overall 78.3% complete total (currently sitting at 330 units left to deliver) -71 total canceled orders - this week it was mostly organic movement overall. @brv10 did his thing as usual. - - Actual sheet analysis shows only 297 orders left to deliver.

More metrics/analysis for the data freaks (completion rates with qtys pending)
2021 - (7 out of 961 pending Build, 99.3% complete), delivery is at 97.3% (26 out of 961 waiting for shipping) - 26 is an amazing number, even more amazing, is 55 orders are canceled overall, some show delivered others don't.
Q2-May and June of 2021 are 100% built, delivery is at 98.0% (4 out of 198 waiting for shipping) - the 4 that are not shipped are canceled ordered - 15 total canceled orders- we can now count Q2 2021 100% completed
Q3-July, Aug, and Sep of 2021 are almost 100% FULLY Built, and delivery is at 98.7% (5 out of 375 waiting for shipping) - 15 orders are canceled so the Build and delivery are much closer than shown - we can now count Q3 2021 100% completed - there are only 2 units left to deliver 1 fleet and 1 Canadian
Q4-Oct, Nov, and Dec of 2021 Build is at 98.2% (7 out of 388 pending), Delivery started to rear its ugly head (but its almost there), is at 95.6% (17 out of 388 waiting for shipping) - 25 orders are canceled so the Build and delivery is much closer than shown - should put build at 100% as well and delivery even more complete - Deeper analysis shows 2 orders left to build and 5 left to deliver out of 387 this is very close to completion

2022 - (27 out of 559 pending Build, 95.2% complete), delivery is at 45.8% (303 out of 559 waiting for shipping) - 16 Canceled Orders -
Q1-Jan, Feb, and March of 2022, Build is at 99.3% (3 out of 419 pending), Delivery continues with challenges, 54.4% (191 out of 419 waiting for shipping) - 12 orders are canceled so the Build and delivery is much closer than shown - There is only 1 order left to build
Q2-April, May, and June of 2022, Build is at 89% (14 out of 127 pending), Delivery is at 22% (99 out of 127 waiting for shipping) - 4 orders are canceled so the Build and delivery is much closer than shown
Q3-July, Aug of 2022, Build is at 23% (10 out of 13 pending), Delivery is at 0% (13 out of 13 waiting for shipping)

Let me know if any other metrics should/could be evaluated., Red comments are changes in numbers/counts, Green comments are general comments. Yellow comments are unedited/updated and passed on from the last post. White and no change from last week.

Some positive movement this week and little by little getting closer to the finish line. If the production line does get reset in October we have a date no 10/29/22 is the drop-dead date. There are 55 total days of production left. so overall I think the timing is still in play and that MY22 completion is still feasible. We are at 34 on the sheet left to build even at 10 units a week, it's feasible to be complete at this rate.

Thank you for the lift again @brv10 and @OfficerDirtySanchez

View attachment 43835
Am I reading this correctly, 2022 Q3 Aug. only four trucks ordered. Is mine one of the four, hope so! Order # 1523 on the tracking.
 
Am I reading this correctly, 2022 Q3 Aug. only four trucks ordered. Is mine one of the four, hope so! Order # 1523 on the tracking.
Q3-July, Aug of 2022, Build is at 23% (10 out of 13 pending), Delivery is at 0% (13 out of 13 waiting for shipping)
this means 13 trucks ordered 3 have been built and none have shipped yet.

is your comment from the text or from the spreadsheet picture?

let me know any other questions or clarities i could help you with
 
nice happy for you

do you mean 1473, the one with your username?
Yes, the line number must have changed again. Started at 1470 which I later misquoted then went to 1471. Oh well, it’s done now. Thank you all for the education. So many great ideas to consider and accessories to add.
 
Line 1420 is in KZLD Status. Dealer says it's at the Saltillo plant.

Based on forum searches, It seems this status means a) at a rail mixing yard or b) delayed in transit.

Makes me wonder if it's at the plant like the dealer says. I guess it could be at the plant and waiting to get to the rail?
 
Mine has been ready since August 12th and is still sitting at the yard/ plant. It is getting really frustrating due to lots of people on the spreadsheet seam to have theres shipping with in a couple days once completed. Call me impatient I guess.


Sent from my iPhone using Tapatalk
 
Mine has been ready since August 12th and is still sitting at the yard/ plant. It is getting really frustrating due to lots of people on the spreadsheet seam to have theres shipping with in a couple days once completed. Call me impatient I guess.


Sent from my iPhone using Tapatalk
 
Mine has been ready since August 12th and is still sitting at the yard/ plant. It is getting really frustrating due to lots of people on the spreadsheet seam to have theres shipping with in a couple days once completed. Call me impatient I guess.


Sent from my iPhone using Tapatalk
not sure if you have noticed the chatter about Cummins ECU, you may be within the impact window.
 
Mine was built 8/17. Dealer said there were no recalls on it but not sure the recall has even been dispersed yet. I am sure they have to fill a train car with enough vehicles going to the same place to ship. The logistics have not been predictable.
 
Mine was built 8/17. Dealer said there were no recalls on it but not sure the recall has even been dispersed yet. I am sure they have to fill a train car with enough vehicles going to the same place to ship. The logistics have not been predictable.
Highly probable, without enough trucks filled up the train, the train company may lose money for that transportation. I'm glad my truck shipped only a few days after built, maybe not impacted by the recall, just an unexpected positive effect of long waiting for schedule :)
 
Mine was built 8/17. Dealer said there were no recalls on it but not sure the recall has even been dispersed yet. I am sure they have to fill a train car with enough vehicles going to the same place to ship. The logistics have not been predictable.
I think FCA will announce it beginning in October. At least I believe that's what I read on their recall website.
I also believe they tried to replace as many of the bad ECMs before shipment.
That could have been the time when we didn't see a lot of diesels being shipped.
 
I think FCA will announce it beginning in October. At least I believe that's what I read on their recall website.
I also believe they tried to replace as many of the bad ECMs before shipment.
That could have been the time when we didn't see a lot of diesels being shipped.
I hope that is the case. Have to check the Part number on mine when I pick it up today.
 
Back
Top