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

  1. misanthrope

    misanthrope Well-Known Member

    Vehicle(s):
    Schwinn Homegrown
    Joined:
    Dec 20, 2017
    Location:
    LI, NY
    Posts:
    898
    Liked:
    1,053
    Occupation:
    Badass
    #1 Jan 25, 2018
    Last edited: Mar 10, 2019
    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
     

    Attached Files:

    RedDevil17, urbanlegend, JAY and 34 others like this.
  2. BDJeep1

    BDJeep1 Well-Known Member

    Vehicle(s):
    JL Rubicon on order
    Joined:
    Nov 7, 2016
    Location:
    NW Chicago Suburbs
    Posts:
    330
    Liked:
    346
    Thanks, does this support 2 door Rubicons?
     
  3. azjlur

    azjlur Well-Known Member

    First Name:
    Angie
    Vehicle(s):
    JKULR10A
    Joined:
    Dec 2, 2017
    Location:
    Phoenix
    Posts:
    175
    Liked:
    178
    That's awesome-thanks!
     
  4. OP
    OP
    misanthrope

    misanthrope Well-Known Member

    Vehicle(s):
    Schwinn Homegrown
    Joined:
    Dec 20, 2017
    Location:
    LI, NY
    Posts:
    898
    Liked:
    1,053
    Occupation:
    Badass
    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.
     
    ResponsibleAdult likes this.
  5. alphalife9

    alphalife9 Well-Known Member

    First Name:
    David
    Vehicle(s):
    Z51 C6
    Joined:
    Nov 6, 2017
    Location:
    Rio Rancho, NM
    Posts:
    238
    Liked:
    111
    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.
     
  6. Mud2Sno

    Mud2Sno Well-Known Member

    Vehicle(s):
    2018 JLU Rubicon (ordered) Yukon,Mustang
    Joined:
    Jan 4, 2018
    Location:
    California
    Posts:
    125
    Liked:
    144
    Excellent work, I see I not the only crazy person with spreadsheets while I wait...
     
    ResponsibleAdult and alphalife9 like this.
  7. OP
    OP
    misanthrope

    misanthrope Well-Known Member

    Vehicle(s):
    Schwinn Homegrown
    Joined:
    Dec 20, 2017
    Location:
    LI, NY
    Posts:
    898
    Liked:
    1,053
    Occupation:
    Badass
    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.
     
  8. Redneck_Jedi

    Redneck_Jedi Well-Known Member

    First Name:
    Charles
    Vehicle(s):
    2019 Jeep Wrangler Sport S 2 Dr.
    Joined:
    Jun 9, 2017
    Location:
    WPB, FL
    Posts:
    520
    Liked:
    605
    That's Awesome!!! Thank You!!! Sport and Sport S would definitely be useful.
     
  9. OP
    OP
    misanthrope

    misanthrope Well-Known Member

    Vehicle(s):
    Schwinn Homegrown
    Joined:
    Dec 20, 2017
    Location:
    LI, NY
    Posts:
    898
    Liked:
    1,053
    Occupation:
    Badass
    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...
     
    Redneck_Jedi and BDJeep1 like this.
  10. johnnyp26

    johnnyp26 Well-Known Member

    First Name:
    John
    Vehicle(s):
    2015 Rubi Hard Rock
    Joined:
    Jan 23, 2018
    Location:
    Jax, FL
    Posts:
    53
    Liked:
    46
    This is very cool, thanks!
     
  11. crik

    crik Well-Known Member

    Vehicle(s):
    2017 Renegade; 2018 JLUS
    Joined:
    Jan 1, 2018
    Location:
    Dallas
    Posts:
    74
    Liked:
    73
    This is great. Thanks for the work. Would love one for the Sahara too, if you have the time.
     
  12. JimKrrk

    JimKrrk Active Member

    First Name:
    Jim
    Vehicle(s):
    2011 JKU Rubicon
    Joined:
    Jun 13, 2017
    Location:
    Silver Lake, Michigan
    Posts:
    25
    Liked:
    21
    Can you post an unProtected sheet please for the Rubicon. Thanks
     
  13. OP
    OP
    misanthrope

    misanthrope Well-Known Member

    Vehicle(s):
    Schwinn Homegrown
    Joined:
    Dec 20, 2017
    Location:
    LI, NY
    Posts:
    898
    Liked:
    1,053
    Occupation:
    Badass
    Why?
     
  14. Redneck_Jedi

    Redneck_Jedi Well-Known Member

    First Name:
    Charles
    Vehicle(s):
    2019 Jeep Wrangler Sport S 2 Dr.
    Joined:
    Jun 9, 2017
    Location:
    WPB, FL
    Posts:
    520
    Liked:
    605
    You Rock! Thanks!
     
  15. BDJeep1

    BDJeep1 Well-Known Member

    Vehicle(s):
    JL Rubicon on order
    Joined:
    Nov 7, 2016
    Location:
    NW Chicago Suburbs
    Posts:
    330
    Liked:
    346
    Did you add the 2 door?
    :clap::clap:
     
Loading...

Share This Page