SAM
Well-Known Member
- First Name
- SAM
- Joined
- Dec 29, 2020
- Threads
- 3
- Messages
- 333
- Reaction score
- 362
- Vehicles
- Premium MME4X Iconic Silver
- Thread starter
- #1
I noticed a lot of threads asking about order to build time and order to delivery time. Some data on these times can be found in the "Submitted Orders # Tracking List and Stats" thread, but the problem is data are presented in an HTML table that can not be sorted or analyzed. Scrolling through the table trying to make sense of build and delivery waits is difficult.
So, I copied the data out of the tracking thread (694 records on 02-20-2021) and pasted it into an Excel sheet. I corrected some entries that had an obvious error in date entry resulting in negative # of days in the results. I also excluded data with order dates months earlier than the 06-26-2020 start of the reservation to order conversion (highlighted in red text). These are likely reservation dates, not order dates, and result in artificially high order to build/delivery times that may skew the averages higher.
Here are the calculated averages for available data as of Feb 20, 2021:
I also sorted the data by model and created separate tabs in the Excel file to see if model matters for wait times. I did some more playing around, such as sorting by order number (do newer orders have shorter waits?), but didn't create separate tabs for this.
I guess others may like to play with it, so I attached the file (in zip file). Each tab is sorted by order date. Post if you find anything interesting.
So, I copied the data out of the tracking thread (694 records on 02-20-2021) and pasted it into an Excel sheet. I corrected some entries that had an obvious error in date entry resulting in negative # of days in the results. I also excluded data with order dates months earlier than the 06-26-2020 start of the reservation to order conversion (highlighted in red text). These are likely reservation dates, not order dates, and result in artificially high order to build/delivery times that may skew the averages higher.
Here are the calculated averages for available data as of Feb 20, 2021:
Order to Build | Order to Delivery | Build to Delivery | |
Average # of days | 162 | 212 | 59 |
# of orders | n=363 | n=88 | n=78 |
Range in days | 16 - 277 | 75 - 268 | 20 - 99 |
I also sorted the data by model and created separate tabs in the Excel file to see if model matters for wait times. I did some more playing around, such as sorting by order number (do newer orders have shorter waits?), but didn't create separate tabs for this.
I guess others may like to play with it, so I attached the file (in zip file). Each tab is sorted by order date. Post if you find anything interesting.
Sponsored
Attachments
-
105.9 KB Views: 539
Last edited by a moderator: