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

misanthrope

Well-Known Member
Joined
Dec 20, 2017
Messages
1,490
Reaction score
1,981
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





Advertisement

 

Attachments

Last edited:

azjlur

Well-Known Member
First Name
Angie
Joined
Dec 2, 2017
Messages
184
Reaction score
182
Location
Phoenix
Vehicle(s)
JKULR10A
That's awesome-thanks!
 
OP
misanthrope

misanthrope

Well-Known Member
Joined
Dec 20, 2017
Messages
1,490
Reaction score
1,981
Location
LI, NY
Vehicle(s)
Schwinn Homegrown
Occupation
Badass
  • Thread starter
  • Thread Starter
  • #4
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
Messages
367
Reaction score
179
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.
 

Mud2Sno

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

misanthrope

Well-Known Member
Joined
Dec 20, 2017
Messages
1,490
Reaction score
1,981
Location
LI, NY
Vehicle(s)
Schwinn Homegrown
Occupation
Badass
  • Thread starter
  • Thread Starter
  • #7
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
Messages
929
Reaction score
1,101
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
misanthrope

misanthrope

Well-Known Member
Joined
Dec 20, 2017
Messages
1,490
Reaction score
1,981
Location
LI, NY
Vehicle(s)
Schwinn Homegrown
Occupation
Badass
  • Thread starter
  • Thread Starter
  • #9
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...
 

crik

Well-Known Member
Joined
Jan 1, 2018
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
Messages
929
Reaction score
1,101
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
Messages
353
Reaction score
372
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:
 

Advertisement




TopLift Pros
 



Advertisement
Top