Page 15 - Final Variable Operations
P. 15

New Car Inventory
                    PIPELINE*                           In Stock DEMO Units                   Dealer Trades
      Mdl Yr  Stock  Matched  Invoice  In Process  Total  Stock#  Color-Model  Type  Age  "Ours" "Theirs"   Total  Prev Yr
      ** 2018  1                       1          79364  19 Lunar RAV4 Ad JNT DEMO  295  Feb-19  27  21  48  35
       2019   84                      84          80891  20 Blue Tundra  JNT DEMO  148  Mar-19  33  18  51  48
       2020   300   153    23    25   501         80446  19 Aqua Camry  JNT DEMO  193  Apr-19  21  9  30  47
    Grand Total  385  153  23    25   586         80935  20 Mesq Tundra  JNT DEMO  146  May-19  33  20  53  47
    **Includes units purchased from TMNA (1 unit)  82085  20 Silver Avalon  JNT DEMO  36  Jun-19  31  22  53  46
                                                                                   Jul-19  34  19  53     51
                                                                                  Aug-19  41  24   65     61
                         % Over 90    Missing Photos                              Sep-19  27  21   48     66
      Units Over 90 Days  19.7%          80                                       Oct-19  42  21   63     80
    Series  Count of VIN                                                          Nov-19  31  8    39     65
    4Runner      7                                                                Dec-19  44  13   57     46
    Avalon       1                                                                Jan-20  10  3    13     50
    Camry        7                Top 10 AGED INVENTORY - JANUARY      Previously RDR'd
    Highlander   8        Stk#  Vehicle  Model  Year  Color  Age       Units NOT Sold      Inventory Buying Actions
    Rav4         16       78572  CAMRY  2554  19  BLU STREAK MET  386  Series  # of VIN      Inventory NEEDS
    Sienna       5        78727  TACOMA 4X2 7150  19  MAG GRY MET  375                Corolla SE Black    +14
    Tacoma 2W    3        78968  RAV4  4446  19  MIDNGT BLK/ICE  342                  Corolla LE Gray     +12
    Tacoma 4W    8        79091  RAV4  4446  19  MIDNGT BLK/ICE  322                  Highlander FWD XLE Gray  +12
    Tundra 2W    1        79157  RAV4  4446  19  MIDNGT BLK/ICE  315                  RAV4 FWD LE White   +10
    Tundra 4W    19       79317  RAV4  4446  19  MIDNGT BLK/ICE  294                  Corolla LE Black    +10
    Yaris iA     1        79318  RAV4  4446  19  RUBY FLARE PRL  294
    Grand Total  76       79364  RAV4  4446  19  LUNAR ROCK/ICE  288                       Inventory OVERSTOCKED
                          79411  RAV4  4446  19  LUNAR ROCK/ICE  285                  Highlander FWD LE   -12
                          79515  RAV4  4446  19  LUNAR ROCK/ICE  274                  RAV4 Adventure Black  -10
                            LIO LOAD AMTS         Earnings                            Camry SE Blue       -9
                         Car Avg  Trk Avg  Ttl Avg  Car  Trk  Total                   Tundra CC 4WD SR5   -6
                    ALC 20  $457.40  $886.44  $729.96  32  55  87                     4Runner SR5 4WD White  -4
                    ALC 21  $495.82  $937.03  $739.98  46  58  104
                    ALC 22  $494.07  $2,473.82 $1,819.64  38  78  116
                    ALC 23  $517.44  $924.47  $724.40  32  39  71
                    ALC 24  $702.95  $844.12  $786.14  23  30  53
















































                                                                                                                   1/20/2020
   10   11   12   13   14   15   16   17   18   19   20