Gazelle
Well-Known Member
- Thread starter
- #1
First post here for me. I have been actively working on pricing and configuring a JLUR, and found the order guide very helpful to determine the "as optioned" price. I spent some time this evening converting the pdf into an interactive spreadsheet only for the JLUR at this point. Select the options you want and the total $FWP and $MSRP updates. Hope this may help others.
<Edits - Updated spreadsheet using Jul 06, 2021 price list.>
See second post from fczabala for the latest Unlimited (4 Door) interactive worksheets.
Instructions for spreadsheets:
The spreadsheets do NOT verify option selection compatibility, for example the spreadsheet allows you to select both 3.0L and 3.6L engines. The user must interpret the subscripts and/or be familiar with the option compatibility to properly select options.
If you have a trade in, you may want to reduce the taxable amount by the amount of your trade in.
The spreadsheets are saved in an old Excel version which allows you to open and use the file with many different spreadsheet tools. MS Excel is great, but you can download other applications for free (I use OpenOffice).
2022 model spreadsheet is here.
<Edits - Updated spreadsheet using Jul 06, 2021 price list.>
See second post from fczabala for the latest Unlimited (4 Door) interactive worksheets.
Instructions for spreadsheets:
- Choose and open the appropriate spreadsheet - 1st post for the 2 door, 2nd post for the 4 door.
- Choose the appropriate tab along the bottom of your spreadsheet application.
- Select the desired engine/transmission combination by placing an x (or any character) in the grey, column A (the furthest left column).
- Select additional options by placing an x in column A in front of the options' description.
- Once all desired options are selected, select the desired "% Below Invoice". TOTAL at the very bottom only updates after you select the % Below Invoice.
- Enter your local automotive sales tax (default is shown as 8.625%).
the total $MSRP and $FWP (invoice)
the discounted total below $FWP
the discounted total plus sales tax.
The spreadsheets do NOT verify option selection compatibility, for example the spreadsheet allows you to select both 3.0L and 3.6L engines. The user must interpret the subscripts and/or be familiar with the option compatibility to properly select options.
If you have a trade in, you may want to reduce the taxable amount by the amount of your trade in.
The spreadsheets are saved in an old Excel version which allows you to open and use the file with many different spreadsheet tools. MS Excel is great, but you can download other applications for free (I use OpenOffice).
2022 model spreadsheet is here.
Sponsored
Attachments
-
70.5 KB Views: 417
Last edited: