Spreadsheet: 765752d1643566751-how-to-average-sales-data-based-on-a-matching-date-bh-performance-tracker-january-copy-22
Sheet: New INV Tracking

 | STATUS
 | Landed
 | 2019 |  |  |  |  |  |  |  |  |  |  | 45 | Oldest New Vehicle Inventory
 | SANTA FE |  | TUCSON |  | ACCENT |  | ELANTRA SEDAN |  | KONA |  |  | Rank | STOCK # | Year | Model | Drivetrain | Engine | Trans | Trim Level | Total Days In Stock
 | FWD ESSENTIAL |  | FWD 2.0L ESSENTIAL |  | ESSENTIAL (4) |  | ESSENTIAL |  | FWD 2.0L ESSENTIAL
 | AWD ESSENTIAL |  | AWD 2.0L ESSENTIAL |  | ESSENTIAL (4) - MT |  | ESSENTIAL - MT |  | AWD 2.0L ESSENTIAL
 | FWD ESSENTIAL SAFETY |  | FWD ESSENTIAL SAFETY |  | ESSENTIAL (5) |  | PREFERRED |  | FWD 2.0L PREFERRED
 | AWD ESSENTIAL SAFETY |  | AWD ESSENTIAL SAFETY |  | ESSENTIAL (5) - MT |  | SUN/SAFETY |  | FWD 2.0L PREFERRED TWO-TONE
 | AWD 2.4L PREFERRED |  | FWD PREFERRED |  | PREFERRED (4) |  | LUXURY |  | AWD 2.0L PREFERRED TWO-TONE
 | AWD 2.0T PREFERRED |  | AWD PREFERRED |  | PREFERRED (4) - MT |  | ULTIMATE |  | AWD 2.0L PREFERRED
 | AWD 2.0T  PREFFERED PANO |  | AWD TREND |  | PREFERRED (5) |  | SPORT |  | AWD 1.6T PREFERRED TREND
 | AWD 2.4L PREFERRED DARK CH |  | AWD 2.4L LUXURY |  | PREFERRED (5) - MT |  | SPORT - MT |  | AWD 1.6T TREND TWO-TONE
 | AWD 2.OT LUXURY |  | AWD 2.4L ULTIMATE |  | ULTIMATE (4) |  |  |  | AWD 1.6T TREND
 | AWD ULTIMATE |  |  |  | ULTIMATE (4) - MT |  |  |  | AWD 1.6T LUXURY
 |  |  |  |  | ULTIMATE (5) |  |  |  | AWD 1.6T ULTIMATE
 |  |  |  |  | ULTIMATE (5) - MT
 | TOTALS
 | 2019
 | SANTE FE XL |  | SONATA |  | ELANTRA GT |  | VELOSTER |  | IONIQ
 | FWD 3.3L ESSENTAIL |  | ESSENTIAL |  | PREFERRED - MT |  | 2.0L |  | ESSENTIAL
 | AWD 3.3L ESSENTIAL |  | PREFERRED |  | PREFERRED - AT |  | 2.0L - MT |  | ESSENTIAL PHEV
 | AWD 3.3L PREFERRED |  | LUXURY |  | LUXURY |  | 1.6T |  | ESSENTIAL EV
 | AWD 3.3L LUXURY |  | ULTIMATE |  | ULTIMATE |  | 1.6T - MT |  | PREFERRED
 | AWD 3.3L ULTIMATE |  |  |  | N-LINE |  | 1.6T TECH |  | PREFERRED PHEV
 |  |  |  |  |  |  | 1.6T TECH - MT |  | PREFERRED EV
 |  |  |  |  |  |  | N-LINE |  | LUXURY
 |  |  |  |  |  |  | N-LINE - MT |  | LUXURY PHEV
 |  |  |  |  |  |  |  |  | LUXURY EV
 |  |  |  |  |  |  |  |  | ULTIMATE
 |  |  |  |  |  |  |  |  | ULTIMATE PHEV
 |  |  |  |  |  |  |  |  | ULTIMATE EV
 | TOTALS
 | 2020
 | SANTA FE |  | TUCSON |  | ACCENT |  | ELANTRA SEDAN |  | KONA
 | FWD ESSENTIAL |  | FWD 2.0L ESSENTIAL |  | ESSENTAIL (4) |  | ESSENTIAL |  | FWD 2.0L ESSENTIAL
 | AWD ESSENTIAL |  | AWD 2.0L ESSENTIAL |  | ESSENTIAL (4) - MT |  | ESSENTIAL - MT |  | AWD 2.0L ESSENTIAL
 | FWD ESSENTIAL SAFETY |  | FWD ESSENTAIL SAFETY |  | ESSENTAIL (5) |  | PREFERRED |  | FWD 2.0L PREFERRED
 | AWD ESSENTIAL SAFETY |  | AWD ESSENTIAL SAFETY |  | ESSENTIAL (5) - MT |  | SUN/SAFETY |  | FWD 2.0L PREFERRED TWO-TONE
 | AWD 2.4L PREFERRED |  | FWD PREFERRED |  | PREFERRED (4) |  | LUXURY |  | AWD 2.0L PREFERRED TWO-TONE
 | AWD 2.0T PREFERRED |  | AWD PREFERRED |  | PREFERRED (4) - MT |  | ULTIMATE |  | AWD 2.0L PREFERRED
 | AWD 2.0T  PREFFERED PANO |  | AWD TREND |  | PREFERRED (5) |  | SPORT |  | AWD 1.6T PREFERRED TREND
 | AWD 2.4L PREFERRED DARK CH |  | AWD 2.4L LUXURY |  | PREFERRED (5) - MT |  | SPORT - MT |  | AWD 1.6T TREND TWO-TONE
 | AWD 2.OT LUXURY |  | AWD 2.4L ULTIMATE |  | ULTIMATE (4) |  |  |  | AWD 1.6T TREND
 | AWD ULTIMATE |  |  |  | ULTIMATE (4) - MT |  |  |  | AWD 1.6T LUXURY
 |  |  |  |  | ULTIMATE (5) |  |  |  | AWD 1.6T ULTIMATE
 |  |  |  |  | ULTIMATE (5) - MT
 |  |  |  |  |  |  |  |  |  |  |  |  | SALES LOANERS
 | TOTALS |  |  |  |  |  |  |  |  |  |  |  | STOCK # | YEAR | MODEL | AWD/FWD | COLOUR | K'S
 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 2
 | 2020 |  |  |  |  |  |  |  |  |  |  | 3
 | SANTE FE XL |  | SONATA |  | ELANTRA GT |  | VELOSTER |  | IONIQ |  |  | 4
 | FWD 3.3L ESSENTAIL |  | ESSENTAIL |  | PREFERRED - MT |  | 2.0L |  | ESSENTIAL |  |  | 5
 | AWD 3.3L ESSENTIAL |  | PREFERRED |  | PREFERRED - AT |  | 2.0L - MT |  | ESSENTIAL PHEV |  |  | 6
 | AWD 3.3L PREFERRED |  | LUXURY |  | LUXURY |  | 1.6T |  | ESSENTIAL EV |  |  | 7
 | AWD 3.3L LUXURY |  | ULTIMATE |  | ULTIMATE |  | 1.6T - MT |  | PREFERRED |  |  | 8
 | AWD 3.3L ULTIMATE |  |  |  | N-LINE |  | 1.6T TECH |  | PREFERRED PHEV |  |  | 9
 |  |  |  |  |  |  | 1.6T TECH - MT |  | PREFERRED EV |  |  | 10
 |  |  |  |  |  |  | N-LINE |  | LUXURY |  |  | 11
 |  |  |  |  |  |  | N-LINE - MT |  | LUXURY PHEV |  |  | 12
 |  |  |  |  |  |  |  |  | LUXURY EV |  |  | 13
 |  |  |  |  |  |  |  |  | ULTIMATE |  |  | 14
 |  |  |  |  |  |  |  |  | ULTIMATE PHEV |  |  | 15
 |  |  |  |  |  |  |  |  | ULTIMATE EV |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18
 | TOTALS |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  | Total Units In-Stock |  | AVG Cost Per Unit | Total Inventory Value |  | RDR'D VEHICLES
 |  |  |  |  |  |  |  |  |  |  |  |  | SERVICE LOANERS
 | PALISADE |  |  |  |  |  |  |  |  |  |  |  | STOCK # | YEAR | MODEL | AWD/FWD | COLOUR | K'S
 | FWD ESSENTIAL 8 PASS |  |  | OVER 90 DAYS PER MODEL |  |  | Units > 90 -119 Days |  |  |  |  | 1
 | AWD ESSENTIAL 8 PASS |  |  | ACCENT |  |  |  |  |  |  |  | 2
 | AWD PREFERRED 8 PASS |  |  | ELANTRA |  |  |  |  |  |  |  | 3
 | AWD LUXURY 8 PASS |  |  | ELANTRA GT |  |  | Units > 120 - 179 Days |  |  |  |  | 4
 | AWD LUXURY 7 PASS |  |  | SONATA |  |  |  |  |  |  |  | 5
 | AWD ULTIMATE 7 PASS |  |  | KONA |  |  |  |  |  |  |  | 6
 |  |  |  | TUCSON |  |  | Units > 180 Days |  |  |  |  | 7
 |  |  |  | SANTA FE |  |  |  |  |  |  |  | 8
 |  |  |  | SANTA FE XL |  |  |  |  |  |  |  | 9
 | TOTALS |  |  | IONIQ |  |  | Average Days In Stock |  |  |  |  | 10
 |  |  |  | VELOSTER |  |  |  |  |  |  |  | 11
 |  |  |  | PALISADE |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  |  |  |  | 20