Sponsored

JLU and JL Interactive Pricing Worksheets Updated for 2019! 1-8% below invoice pricing added.

misanthrope

Well-Known Member
Joined
Dec 20, 2017
Threads
17
Messages
1,525
Reaction score
2,161
Location
LI, NY
Vehicle(s)
Schwinn Homegrown
Occupation
Badass
All-New Pricing for 2019! 6, 7 and 8% below invoice pricing added!
I created an Excel worksheet for JL pricing with options and variable discounts below invoice.

New Update: Sahara added. Sport added, too! (The Sport worksheet doesn't list all options included with S package, but that doesn't change pricing (allowance was made for Deep Tint Sunscreen only).

New Update: I updated new Jeep pricing (+$500 MSRP, increased Destination charge), added 2.0 BSG Turbo and Sky One Touch Roof.

Also, all models now on one spreadsheet, just click on tab at the bottom to select model.

New Update: New price increases and MOAB added.
Newest Update: errors my cat made while typing this (incompetent cat) have been fixed
'Nuther update: Mopar Leathers and Gate reinforcement added
Sponsored

 

Attachments

Last edited:
OP
OP
misanthrope

misanthrope

Well-Known Member
Joined
Dec 20, 2017
Threads
17
Messages
1,525
Reaction score
2,161
Location
LI, NY
Vehicle(s)
Schwinn Homegrown
Occupation
Badass
Thanks, does this support 2 door Rubicons?
Just the Unlimited, as that's what I'm interested in and I am the most important person on the face of the earth. I could do a 2 dr if there was enough interest. Would just need to change a few prices/options.
 

alphalife9

Well-Known Member
First Name
David
Joined
Nov 6, 2017
Threads
17
Messages
377
Reaction score
189
Location
Rio Rancho, NM
Vehicle(s)
Z51 C6, Sting Gray JLUR
Thanks for this. I think the tax rate field is not working correctly. 0.03 (3%) in field B42 yields 35.85 in field C42. It should be 1192.23. Unless I'm doing something wrong?

Nevermind, I had not entered the discounted price. I thought it was calculating off of invoice price.
 

Sponsored

Mud2Sno

Well-Known Member
First Name
Mickey
Joined
Jan 4, 2018
Threads
6
Messages
177
Reaction score
288
Location
California
Vehicle(s)
2018 JLUR Rubicon
Excellent work, I see I not the only crazy person with spreadsheets while I wait...
 
OP
OP
misanthrope

misanthrope

Well-Known Member
Joined
Dec 20, 2017
Threads
17
Messages
1,525
Reaction score
2,161
Location
LI, NY
Vehicle(s)
Schwinn Homegrown
Occupation
Badass
Excellent work, I see I not the only crazy person with spreadsheets while I wait...
Just thought for those who wanted to have math in hand to bring to the dealer. The 5% below invoice is slightly off from Koon's price, as they include destination before discount, but it's only like $60.
 

Redneck_Jedi

Well-Known Member
Joined
Jun 9, 2017
Threads
26
Messages
928
Reaction score
1,132
Location
Currently Roaming
Vehicle(s)
2019 Jeep Wrangler Sport S 2 Dr.
Vehicle Showcase
1
That's Awesome!!! Thank You!!! Sport and Sport S would definitely be useful.
 
OP
OP
misanthrope

misanthrope

Well-Known Member
Joined
Dec 20, 2017
Threads
17
Messages
1,525
Reaction score
2,161
Location
LI, NY
Vehicle(s)
Schwinn Homegrown
Occupation
Badass
That's Awesome!!! Thank You!!! Sport and Sport S would definitely be useful.
I figured they would, I just didn't know if anyone would even find this page, let alone want the spreadsheets. I'll get on a few more (maybe even for the 2 door) as it keeps me from doing any real work...
 

Sponsored

crik

Well-Known Member
Joined
Jan 1, 2018
Threads
2
Messages
75
Reaction score
82
Location
Dallas
Vehicle(s)
2017 Renegade; 2018 JLUS
This is great. Thanks for the work. Would love one for the Sahara too, if you have the time.
 

Redneck_Jedi

Well-Known Member
Joined
Jun 9, 2017
Threads
26
Messages
928
Reaction score
1,132
Location
Currently Roaming
Vehicle(s)
2019 Jeep Wrangler Sport S 2 Dr.
Vehicle Showcase
1
....New Update: Sahara added. Sport added, too! (The Sport worksheet doesn't list all options included with S package, but that doesn't change pricing (allowance was made for Deep Tint Sunscreen only).
You Rock! Thanks!
 

BDJeep1

Well-Known Member
Joined
Nov 7, 2016
Threads
7
Messages
350
Reaction score
378
Location
NW Chicago Suburbs
Vehicle(s)
JL Rubicon on order
I figured they would, I just didn't know if anyone would even find this page, let alone want the spreadsheets. I'll get on a few more (maybe even for the 2 door) as it keeps me from doing any real work...
Did you add the 2 door?
:clap::clap:
Sponsored

 
 



Top