Sponsored
OP
OP

Mackieallan

Well-known member
Joined
May 18, 2023
Threads
16
Messages
99
Reaction score
182
Location
Mid Atlantic
Vehicle(s)
2017 Ranger
Here's the update from the latest sheet. It was exactly a week since the last update so this gives us some rough weekly numbers. This took a lot of time, I'd appreciate if you please DO NOT copy/paste it without linking to this post here.


Everything in RED is a change from last week (1/9/24 - SEE PREVIOUS UPDATE).

TRENDS: Allocations are outpacing sold vehicles about 2:1 so far. While ADM percentage and average amount is holding steady, I've noticed more dealerships with ADMs in the upper range and ADMs on average are higher in the higher trims, as expected. Ice Cap and Underground are by far the most allocated and sold color so far. The easiest to find vehicles will be SR5 and TRD Sport but the latter is also the most marked-up.

*****************************************

JANUARY 16, 2024 UPDATE


ALLOCATION TOTALS - 2024 TACOMA (AS OF 1/16/24)
  • Current Allocations: 4,788 +610
  • Current Allocations with Dealer Mark-up (ADM): 1,005 +78 (21%)
  • Average dealer mark-up (ADM): $3,387 +$185
  • Highest dealer mark-up (ADM): $11,790 (Liberty Toyota - Burlington, NJ)
  • Highest TOTAL Price (MSRP+ADM): $77,203 ($65,413 + $11,790 ADM) (Liberty Toyota - Burlington, NJ) - 2024 Tacoma TRD Sport - Black Exterior Color, Black SofTex Interior Color, Options: 50 State Emissions, Door Edge Guards, Emblem Overlays - Black, Mud Guards, Owner's Portfolio, Perma-Safe Protection, RED Alert, Spray On Bedliner, TRD Sport Premium Package, Tailgate Insert - Black
  • Trims:
    • SR: 381 +84
    • SR5: 1,650 +193
    • TRD SPORT: 1,491 +177
    • TRD OFF-ROAD: 1107 +138
    • LIMITED: 159 +18
  • Colors:
    • Black: 693 +94
    • Blue Crush Metallic: 205 +30
    • Bronze Oxide: 89 +8
    • Celestial Silver Metallic: 774 +57
    • Ice Cap: 1,220 +167
    • Solar Octane (Extra Cost): 125 +15
    • Supersonic Red (Extra Cost): 300 +35
    • Terra: 0
    • Underground: 1,209 +145
    • Wind Chill Pearl: 173 +21

SOLD 2024 TACOMAS (EXCLUDES ABOVE ALLOCATIONS):
  • TOTAL SOLD: 1,196 +332
  • Sold with Dealer Mark-up (ADM): 246 +68
  • Average Dealer Mark-up: $3,161 -$57
  • Highest Dealer Mark-up: $11,790 (Liberty Toyota - Burlington, NJ)
  • Highest SOLD TOTAL Price (MSRP+ADM): $77,203 ($65,413 + $11,790 ADM) (Liberty Toyota - Burlington, NJ) - 2024 Tacoma TRD Sport - Black Exterior Color, Black SofTex Interior Color, Options: 50 State Emissions, Door Edge Guards, Emblem Overlays - Black, Mud Guards, Owner's Portfolio, Perma-Safe Protection, RED Alert, Spray On Bedliner, TRD Sport Premium Package<br>, Tailgate Insert - Black
  • Models/Trims:
    • 2024 Tacoma SR: 93 +22
    • 2024 Tacoma SR5: 358 +105
    • 2024 Tacoma TRD Sport: 421 +120
    • 2024 Tacoma TRD Off-Road: 285 +73
    • 2024 Tacoma Limited: 39 +12
  • Colors:
    • Black: 180 +52
    • Blue Crush Metallic: 40 +17
    • Bronze Oxide: 12 +7
    • Celestial Silver Metallic: 182 +49
    • Ice Cap: 292 +75
    • Solar Octane (Extra Cost): 38 +12
    • Supersonic Red (Extra Cost): 73 +19
    • Terra: 0
    • Underground: 317 +85
    • Wind Chill Pearl: 60 +16


ALLOCATIONS BY TRIM:


2024 Tacoma SR
  • Current Allocations: 381 +84
  • Current Allocations with Dealer Mark-up (ADM): 60 +2
  • Average dealer listed price: $38,468 -$577
  • Average dealer mark-up (ADM): $3,323 (excludes dealers with no mark-up) +$447
  • Lowest dealer mark-up (ADM): $895 (excludes dealers with no mark-up)
  • Highest dealer mark-up (ADM): $9,995 (Dublin Toyota - Dublin, CA / Stevens Creek Toyota - San Jose, CA)
  • Highest Listed Price Excluding ADM: $50,069 + $9,995 ADM (Stevens Creek Toyota - San Jose, CA)
  • Highest TOTAL Price (MSRP+ADM): $60,064 ($50,069 + $9,995 ADM) (Stevens Creek Toyota - San Jose, CA)
  • Lowest Listed Price: $34,509 (-$995 below MSRP) (Toyota of Hackensack - Hackensack, NJ)
  • Colors:
    • Black: 46 +9
    • Blue Crush Metallic: 0
    • Bronze Oxide: 0
    • Celestial Silver Metallic: 78 +15
    • Ice Cap: 138 +26
    • Solar Octane (Extra Cost): 0
    • Supersonic Red (Extra Cost): 23 +10
    • Terra: 0
    • Underground: 96 +24
    • Wind Chill Pearl: 0

2024 Tacoma SR5
  • Current Allocations: 1,650 +193
  • Current Allocations with Dealer Mark-up (ADM): 335 +25
  • Average dealer listed price: $46,102
  • Average dealer mark-up (ADM): $3,320 (excludes dealers with no mark-up) +$89
  • Lowest dealer mark-up (ADM): $1 (excludes dealers with no mark-up)
  • Highest dealer mark-up (ADM): $10,000 (Queensboro Toyota - Woodside, NY)
  • Highest Listed Price Excluding ADM: $57,192 + $10,000 ADM (Queensboro Toyota - Woodside, NY)
  • Highest TOTAL Price (MSRP+ADM): $67,192 ($57,192 + $10,000 ADM) (Queensboro Toyota - Woodside, NY)
  • Lowest Listed Price: $38,265 (-$500 below MSRP) - Florence Toyota - Florence, SC)
  • Colors:
    • Black: 252 +37
    • Blue Crush Metallic: 75 +10
    • Bronze Oxide: 0
    • Celestial Silver Metallic: 293 +28
    • Ice Cap: 527 +75
    • Solar Octane (Extra Cost): 0
    • Supersonic Red (Extra Cost): 115 +8
    • Terra: 0
    • Underground: 388 +35
    • Wind Chill Pearl: 0

2024 Tacoma TRD SPORT
  • Current Allocations: 1,491 +177
  • Current Allocations with Dealer Mark-up (ADM): 316 +33
  • Average dealer listed price: $51,815 -$167
  • Average dealer mark-up (ADM): $3,458 (excludes dealers with no mark-up) -$355
  • Lowest dealer mark-up (ADM): $1 (excludes dealers with no mark-up)
  • Highest dealer mark-up (ADM): $11,790 (Liberty Toyota - Burlington, NJ)
  • Highest Listed Price Excluding ADM: $66,218 + $9,995 ADM (Roseville Toyota - Roseville, CA)
  • Highest TOTAL Price (MSRP+ADM): $77,203 ($65,413 + $11,790 ADM) (Liberty Toyota - Burlington, NJ)
  • Lowest Listed Price: $41,254 = MSRP (Autonation Toyota - Cerritos, CA)
  • Colors:
    • Black: 202 +24
    • Blue Crush Metallic: 67 +10
    • Bronze Oxide: 47 +9
    • Celestial Silver Metallic: 198 +24
    • Ice Cap: 272 +28
    • Solar Octane (Extra Cost): 77 +8
    • Supersonic Red (Extra Cost): 82 +8
    • Terra: 0
    • Underground: 412 +55
    • Wind Chill Pearl: 134 +11

2024 Tacoma TRD OFF-ROAD
  • Current Allocations: 1107 +138
  • Current Allocations with Dealer Mark-up (ADM): 277 +21
  • Average dealer listed price: $52,041
  • Average dealer mark-up (ADM): $3,404 (excludes dealers with no mark-up) -$68
  • Lowest dealer mark-up (ADM): $265 (excludes dealers with no mark-up)
  • Highest dealer mark-up (ADM): $10,000 (Queensboro Toyota - Woodside, NY)
  • Highest Listed Price Excluding ADM: $65,139 + $9,995 ADM (Dublin Toyota - Dublin, CA)
  • Highest Total Price (Listed + ADM): $75,134 (Dublin Toyota - Dublin, CA)
  • Lowest Listed Price: $44,619 (Peppers Toyota - Paris, TN)
  • Colors:
    • Black: 163 +20
    • Blue Crush Metallic: 60 +10
    • Bronze Oxide: 41 +0
    • Celestial Silver Metallic: 175 +28
    • Ice Cap: 283 +38
    • Solar Octane (Extra Cost): 48 +7
    • Supersonic Red (Extra Cost): 66 +8
    • Terra: 0
    • Underground: 271 +27
    • Wind Chill Pearl: 0

2024 Tacoma TRD LIMITED
  • Current Allocations: 159 +18
  • Current Allocations with Dealer Mark-up (ADM): 17 -3
  • Average dealer listed price: $55,863 +$8
  • Average dealer mark-up (ADM): $3,432 (excludes dealers with no mark-up) +$511
  • Lowest dealer mark-up (ADM): $199 (excludes dealers with no mark-up)
  • Highest dealer mark-up (ADM): $9,995 (Stevens Creek Toyota - San Jose, CA)
  • Highest Listed Price Excluding ADM: $65,120 + $9,995 ADM (Stevens Creek Toyota - San Jose, CA)
  • Highest TOTAL Price (MSRP+ADM): $75,115 (Stevens Creek Toyota - San Jose, CA)
  • Lowest Listed Price: $53,990 = MSRP (Newbold Toyota - O’Fallon, IL)
  • Colors:
    • Black: 30 +4
    • Blue Crush Metallic: 3 +0
    • Bronze Oxide: 1 -1
    • Celestial Silver Metallic: 30 +0
    • Ice Cap: 0
    • Solar Octane (Extra Cost): 0
    • Supersonic Red (Extra Cost): 14 +1
    • Terra: 0
    • Underground: 42 +4
    • Wind Chill Pearl: 39 +10
Sponsored

 

Snkrjeff020

Well-known member
First Name
Jeff
Joined
Apr 25, 2023
Threads
1
Messages
70
Reaction score
83
Location
San Diego
Vehicle(s)
2018 Audi RS3
Sad there is no additional bronze oxide allocations for TRDOR this week. What is this a limited color or something? There's only like 10 in California and of course all with crazy ADMs.
 

tswift

Active member
First Name
Jeremy
Joined
Oct 3, 2023
Threads
0
Messages
28
Reaction score
59
Location
Florida
Vehicle(s)
Miata
Sad there is no additional bronze oxide allocations for TRDOR this week. What is this a limited color or something? There's only like 10 in California and of course all with crazy ADMs.
Fr. I had thought based on polls that this would be one of the most popular colors.
 

Sponsored

Lando

Well-known member
Joined
Oct 6, 2023
Threads
3
Messages
194
Reaction score
149
Location
Canada
Vehicle(s)
K1500 Silverado, Honda Accord, VW Gti
So if I get this right, SuperSonic Red is available across all trims in US?
Here in Canada on top trim Sport Premium only!
 
OP
OP

Mackieallan

Well-known member
Joined
May 18, 2023
Threads
16
Messages
99
Reaction score
182
Location
Mid Atlantic
Vehicle(s)
2017 Ranger
A member here asked for a comparison of the 1/16/24 versus 1/9/24 allocations sheet so I ran a compare function in Excel.

This is useful for seeing all the changes made to the allocations and SOLD vehicles. You can see changes to Dealer Price, Markup/ADM, Expected Delivery ETA, Last Update, etc.

DOWNLOAD EXCEL FILE (or view below)

Remember this is a COMPARISON of TWO Excel files so it shows:

GREEN HIGHLIGHTED CELLS = ADDED TO THE SHEET
GREEN TEXT = ADDED TEXT TO THE SHEET

RED HIGHLIGHTED CELLS = REMOVED FROM THE SHEET
RED TEXT = DELETED TEXT FROM SHEET


 

Attachments

FUBRWI

Active member
First Name
Frankie
Joined
Feb 2, 2023
Threads
2
Messages
34
Reaction score
29
Location
Silverton CO
Vehicle(s)
Santa Cruz
Good work @Mackieallan. Just what I was lookng for. As suspected from the other thread, it looks like a bunch of the January deliveries have been pushed to end of month or into February. Timeframes windows have sharpened.
 

AnnDay

New member
Joined
Jan 5, 2024
Threads
0
Messages
2
Reaction score
0
Location
Utah
Vehicle(s)
No
So what does it mean if my allocation is now gone from the spreadsheet? It was there earlier this week and showed it was pending sale and had a dealer hold. I have a deposit on it but it’s not showing up anymore….i emailed my guy but haven’t heard back yet. Am I screwed?
 

Sponsored

JBSwine

Well-known member
Joined
Feb 2, 2023
Threads
0
Messages
479
Reaction score
484
Location
Texas
Vehicle(s)
2022 Kia Sorento
So what does it mean if my allocation is now gone from the spreadsheet? It was there earlier this week and showed it was pending sale and had a dealer hold. I have a deposit on it but it’s not showing up anymore….i emailed my guy but haven’t heard back yet. Am I screwed?

Might want to see if it is on the sold tab or call your dealer. Another poster said his allocation was pulled from the dealer by toyota.
 
OP
OP

Mackieallan

Well-known member
Joined
May 18, 2023
Threads
16
Messages
99
Reaction score
182
Location
Mid Atlantic
Vehicle(s)
2017 Ranger
The allocations list has been updated again (1/18/24). Two more days worth of allocations.

Quick numbers

SR - 23 NEW allocations (401 Total)
SR5 - 91 NEW allocations (1,733 Total)
TRD Sport - 101 NEW allocations (1,514 Total)
TRD Off-Road - 66 NEW allocations (1,119 Total)
Limited - 11 NEW allocations (168 Total)

SOLD - 12 NEW (1,436 Total)

I've attached a spreadsheet sorted by 2024MY and highlighted all of the NEW allocations for each trim including the SOLD sheet.
 

Attachments

Snkrjeff020

Well-known member
First Name
Jeff
Joined
Apr 25, 2023
Threads
1
Messages
70
Reaction score
83
Location
San Diego
Vehicle(s)
2018 Audi RS3
It was updated again today.... big one.

SR - 37 NEW (433 Total)
SR5 - 194 NEW (1901 Total)
TRD Sport - 156 NEW (1652 Total)
TRD Off-Road - 100 NEW (1200 Total)
Limited - 31 NEW (198 Total)
No new TRDOR in Bronze Oxide in California. Cool beans.
 
Top