Spreadsheet: 6ecbcd5f-3629-404e-ad9a-d0c2c32ffac6
Sheet: Sheet1

Units | ITEM | Agency | Description | Dealer | Make | Model | Body Code | Trim | Trim Code | Engine | Trans | USA | Bid Price Delivered | Total Bid Price | [NAME] | MPG | LLC [NAME] | NPV year 5 see formula tab | PV of Fuel Expenditures | FFV Required | FFV Vehicle | Notes
1 | A 1.1 | Base | Mid Size 6 Passenger Sedan | [NAME] | Chevy | Impala | 1WF19 | LS | LS | LFX | MSO | Yes | 17810.46 | 17810.46 | 7900 | 30 | 18268.83213333333 | 0.747258 | 190851.31 | No | Yes
1 | A 1.1 | Base | Mid Size 6 Passenger Sedan | [NAME] | Chevy | Impala | 1WF19 | LS | 1FL | LFX | MXO | Yes | 17920.65 | 17920.65 | 7900 | 30 | 18379.02213333333 | 0.747258 | 190851.31 | No | Yes
1 | A 1.1 | Base | Mid Size 6 Passenger Sedan | [NAME] | Chevy | Impala | 1WG19 | LT | LT | LFX | MSO | Yes | 18879 | 18879 | 8500 | 30 | 18889.01733333333 | 0.747258 | 190851.31 | No | Yes
1 | A 1.1 | Base | Mid Size 6 Passenger Sedan | [NAME] | Chevy | Impala | 1WG19 | LT | 2FL | LFX | MXO | Yes | 18993.48 | 18993.48 | 8500 | 30 | 19003.49733333333 | 0.747258 | 190851.31 | No | Yes
1 | A 1.1 | Base | Mid Size 6 Passenger Sedan | Deery Bros | Chevy | Impala | 1WF19 | LS | 1FL | LFX | MXO | Yes | 18548.21 | 18548.21 | 7900 | 30 | 19006.58213333333 | 0.747258 | 190851.31 | No | Yes
38 | A 1.4 | DAS | Mid Size 6 Passenger Sedan | [NAME] | Chevy | Impala | 1WF19 | LS | 1FL | LFX | MXO | Yes | 17984.4 | 683407.2000000001 | 7900 | 30 | 18442.77213333333 | 0.747258 | 190851.31 | Yes | Yes
38 | A 1.4 | DAS | Mid Size 6 Passenger Sedan | [NAME] | Chevy | Impala | 1WF19 | LS | LS | LFX | MSO | Yes | 18041.46 | 685575.48 | 7900 | 30 | 18499.83213333333 | 0.747258 | 190851.31 | Yes | Yes
38 | A 1.4 | DAS | Mid Size 6 Passenger Sedan | [NAME] | Chevy | Impala | 1WG19 | LT | 2FL | LFX | MXO | Yes | 19057.23 | 724174.74 | 8500 | 30 | 19067.24733333333 | 0.747258 | 190851.31 | Yes | Yes
38 | A 1.4 | DAS | Mid Size 6 Passenger Sedan | [NAME] | Chevy | Impala | 1WG19 | LT | LT | LFX | MSO | Yes | 19110 | 726180 | 8500 | 30 | 19120.01733333333 | 0.747258 | 190851.31 | Yes | Yes
38 | A 1.4 | DAS | Mid Size 6 Passenger Sedan | Deery Bros | Chevy | Impala | 1WF19 | LS | 1FL | LFX | MXO | Yes | 18777.71 | 713552.98 | 7900 | 30 | 19236.08213333333 | 0.747258 | 190851.31 | Yes | Yes
1 | B 2.1 | Base | Mid Size 5 Passenger Sedan | [NAME] | Ford | Fusion | POG | S | 100A | 99A | 44W | No | 15420 | 15420 | 7350 | 33 | 15711.02673030303 | 0.747258 | 190851.31 | No | No | Non American Made
1 | B 2.1 | Base | Mid Size 5 Passenger Sedan | [NAME] | Chevy | Malibu | 1ZH69 | LT | 1LT | LE9 | MH8 | Yes | 17073.25 | 17073.25 | 8150 | 33 | 16766.47033030303 | 0.747258 | 190851.31 | No | Yes
1 | B 2.1 | Base | Mid Size 5 Passenger Sedan | [NAME] | Chevy | Malibu | 1ZG69 | LS | 1FL | LE9 | MH8 | Yes | 16713.04 | 16713.04 | 7550 | 33 | 16854.61513030303 | 0.747258 | 190851.31 | No | Yes
1 | B 2.1 | Base | Mid Size 5 Passenger Sedan | [NAME] | Chevy | Malibu | 1ZG69 | LS | 1FL | LE9 | MH8 | Yes | 16785.36 | 16785.36 | 7550 | 33 | 16926.93513030303 | 0.747258 | 190851.31 | No | Yes
1 | B 2.1 | Base | Mid Size 5 Passenger Sedan | Stivers Ford | Ford | Fusion | POH | SE | 200A | 99A | 44W | No | 17413 | 17413 | 8200 | 33 | 17068.85743030303 | 0.747258 | 190851.31 | No | No | Non American Made
1 | B 2.1 | Base | Mid Size 5 Passenger Sedan | LuJack | Honda | Accord | CP2F3CEW | LX |  |  |  | No | 20443 | 20443 | 9375 | 34 | 19050.73007352941 | 0.747258 | 190851.31 | No | No
1 | B 2.1 | Base | Mid Size 5 Passenger Sedan | [NAME] | Dodge | Avenger | JSDH41 | SE | 27Z | ERB | DG2 | yes | 17995 | 17995 | 6150 | 29 | 19980.44295517241 | 0.747258 | 190851.31 | No | Yes
1 | B 2.1 | Base | Mid Size 5 Passenger Sedan | [NAME] | Toyota | Camry | 2532 | L5 (LE) |  |  |  | Yes | 22099 | 22099 | 9000 | 35 | 20826.57257142857 | 0.747258 | 190851.31 | No | No
1 | B 2.1 | Base | Mid Size 5 Passenger Sedan | Deery Bros | Chevy | Malibu | 1ZG69 | LS | 1FL | LE9 | MH8 | Yes | 21406 | 21406 | 7550 | 33 | 21547.57513030303 | 0.747258 | 190851.31 | No | Yes
4 | B 2.3 | DAS | Mid Size 5 Passenger Sedan | [NAME] | Chevy | Malibu | 1ZG69 | LS | 1FL | LE9 | MH8 | Yes | 17074.29 | 68297.16 | 7550 | 33 | 17215.86513030303 | 0.747258 | 190851.31 | Yes | Yes
4 | B 2.3 | DAS | Mid Size 5 Passenger Sedan | [NAME] | Chevy | Malibu | 1ZG69 | LS | 1FL | LE9 | MH8 | Yes | 17150.38 | 68601.52 | 7550 | 33 | 17291.95513030303 | 0.747258 | 190851.31 | Yes | Yes
4 | B 2.3 | DAS | Mid Size 5 Passenger Sedan | [NAME] | Chevy | Malibu | 1ZH69 | LT | 1LT | LE9 | MH8 | Yes | 17795.75 | 71183 | 8150 | 33 | 17488.97033030303 | 0.747258 | 190851.31 | Yes | Yes
4 | B 2.3 | DAS | Mid Size 5 Passenger Sedan | [NAME] | Ford | Fusion | POH | SE | 200A | 99G | 44W | No | 18234 | 72936 | 8600 | 33 | 17590.95423030303 | 0.747258 | 190851.31 | Yes | No | Requested Flex Fuel Vehicle but [NAME] was bid.
4 | B 2.3 | DAS | Mid Size 5 Passenger Sedan | Stivers Ford | Ford | Fusion | POH | SE | 200A | 99G | 44W | No | 18479 | 73916 | 8600 | 28 | 18868.69941428571 | 0.747258 | 190851.31 | Yes | No | Requested Flex Fuel Vehicle but [NAME] was bid.
4 | B 2.3 | DAS | Mid Size 5 Passenger Sedan | LuJack | Honda | Accord | CP2F3CEW | LX |  |  |  | No | 21048 | 84192 | 9375 | 34 | 19655.73007352941 | 0.747258 | 190851.31 | Yes | No | Requested Flex Fuel Vehicle but [NAME] was bid.
4 | B 2.3 | DAS | Mid Size 5 Passenger Sedan | [NAME] | Dodge | Avenger | JSDH41 | SE | 27Z | ERB | DG2 | yes | 18147 | 72588 | 6150 | 29 | 20132.44295517241 | 0.747258 | 190851.31 | Yes | Yes
4 | B 2.3 | DAS | Mid Size 5 Passenger Sedan | [NAME] | Toyota | Camry | 2532 | L5 |  |  |  | Yes | 22917 | 91668 | 9000 | 35 | 21644.57257142857 | 0.747258 | 190851.31 | Yes | No | Requested Flex Fuel Vehicle but [NAME] was bid.
4 | B 2.3 | DAS | Mid Size 5 Passenger Sedan | Deery Bros | Chevy | Malibu | 1ZG69 | LS | 1FL | LE9 | MH8 | Yes | 21767.25 | 87069 | 7550 | 33 | 21908.82513030303 | 0.747258 | 190851.31 | Yes | Yes
1 | C 3.1 | Base | Compact Four Door Sedan | [NAME] | Ford | Focus | P3FSE | SE | 201A | 992 | 44W | Yes | 15560 | 15560 | 7150 | 37 | 15375.24881351351 | 0.747258 | 190851.31 | No | No
1 | C 3.1 | Base | Compact Four Door Sedan | Stivers Ford | Ford | Focus | P3F | SE | 201A | 992 | 44W | Yes | 16405 | 16405 | 7150 | 40 | 15833.38805 | 0.747258 | 190851.31 | No | No
1 | C 3.1 | Base | Compact Four Door Sedan | [NAME] | Chevy | Cruze | 1PX69 | LT | 1FL | LUJ | MH8 | Yes | 17031.83 | 17031.83 | 7700 | 38 | 16300.34629473684 | 0.747258 | 190851.31 | No | No
1 | C 3.1 | Base | Compact Four Door Sedan | [NAME] | Chevy | Cruze | 1PX69 | LT | 1FL | LUJ | MH8 | Yes | 17070.05 | 17070.05 | 7700 | 38 | 16338.56629473684 | 0.747258 | 190851.31 | No | No
1 | C 3.1 | Base | Compact Four Door Sedan | LuJack | Honda | Civic | FB2F5CEW | LX |  |  |  | Yes | 18203 | 18203 | 8300 | 39 | 16894.38193333333 | 0.747258 | 190851.31 | No | No
1 | C 3.1 | Base | Compact Four Door Sedan | [NAME] | Chevy | Cruze | 1PX69 | LT | 1LT | LUJ | MH8 | Yes | 17720.84 | 17720.84 | 7700 | 38 | 16989.35629473684 | 0.747258 | 190851.31 | No | No
1 | C 3.1 | Base | Compact Four Door Sedan | Deery Bros | Chevy | Cruze | 1PL69 | LS | 2LS | LUW | MH8 | yes | 16684.45 | 16684.45 | 6800 | 35 | 17055.99017142857 | 0.747258 | 190851.31 | No | No
1 | C 3.1 | Base | Compact Four Door Sedan | [NAME] | Chevy | Cruze | 1PB69 | ECO | 1XF | LUJ | MH8 | Yes | 18523.05 | 18523.05 | 8050 | 39 | 17401.24643333333 | 0.747258 | 190851.31 | No | No
1 | C 3.1 | Base | Compact Four Door Sedan | [NAME] | Toyota | Corolla | 1838 | LE |  |  |  | Yes | 17999 | 17999 |  | 34 |  | 0.747258 | 190851.31 | No | No
1 | C 3.1 | Base | Compact Four Door Sedan | [NAME] | Jeep | Compass |  |  |  |  |  |  | Not Accepted |  |  |  |  | 0.747258 | 190851.31 | No | No | Jeep Compas was not approved
7 | C 3.2 | DAS | Compact Four Door Sedan | Stivers Ford | Ford | Focus | P3F | SE | 201A | 992 | 44W | Yes | 16155 | 113085 | 7150 | 40 | 15583.38805 | 0.747258 | 190851.31 | No | No |  | Non Compliant: Proposed vehicle did not include power seats
7 | C 3.2 | DAS | Compact Four Door Sedan | [NAME] | Chevy | Cruze | 1PX69 | LT | 1FL | LUJ | MH8 | Yes | 17201.83 | 120412.81 | 7700 | 38 | 16470.34629473685 | 0.747258 | 190851.31 | No | No
7 | C 3.2 | DAS | Compact Four Door Sedan | [NAME] | Chevy | Cruze | 1PX69 | LT | 1FL | LUJ | MH8 | Yes | 17330.05 | 121310.35 | 7700 | 38 | 16598.56629473684 | 0.747258 | 190851.31 | No | No
7 | C 3.2 | DAS | Compact Four Door Sedan | [NAME] | Ford | Focus | P3H | SEL | 302A | 992 | 44W | Yes | 17976 | 125832 | 8400 | 37 | 16857.17631351352 | 0.747258 | 190851.31 | No | No
7 | C 3.2 | DAS | Compact Four Door Sedan | Deery Bros | Chevy | Cruze | 1PL69 | LS | 2LS | LUW | MH8 | yes | 16784.45 | 117491.15 | 6800 | 35 | 17155.99017142857 | 0.747258 | 190851.31 | No | No
7 | C 3.2 | DAS | Compact Four Door Sedan | [NAME] | Chevy | Cruze | 1PX69 | LT | 1LT | LUJ | MH8 | Yes | 18231.59 | 127621.13 | 7700 | 38 | 17500.10629473684 | 0.747258 | 190851.31 | No | No
7 | C 3.2 | DAS | Compact Four Door Sedan | LuJack | Honda | Civic | FB2F5CEW | LX |  |  |  | Yes | 18882 | 132174 | 8300 | 39 | 17573.38193333333 | 0.747258 | 190851.31 | No | No
7 | C 3.2 | DAS | Compact Four Door Sedan | [NAME] | Chevy | Cruze | 1PB69 | ECO | 1XF | LUJ | MH8 | Yes | 19033.8 | 133236.6 | 8050 | 39 | 17911.99643333333 | 0.747258 | 190851.31 | No | No
7 | C 3.2 | DAS | Compact Four Door Sedan | [NAME] | Toyota | Corolla | 1838 | LE |  |  |  | Yes | 18377 | 128639 |  | 34 |  | 0.747258 | 190851.31 | No | No
7 | C 3.2 | DAS | Compact Four Door Sedan | [NAME] | Jeep | Compass |  |  |  |  |  |  | Not Accepted |  |  | X |  | 0.747258 | 190851.31 | No | No | Jeep Compas was not approved
1 | E 5 | DAS | Comp 2 Door (specialty) | [NAME] | Ford | Mustang | P8C | GT | 300A | 99F | 443 | Yes | 25841 | 25841 | 13700 | 25 | 23237.6178 | 0.747258 | 190851.31 | No | No
1 | E 5 | DAS | Comp 2 Door (specialty) | [NAME] | Chevy | Camaro | 1EF37 | LT | 1LT | LFX | MX0 | yes | 25039.21 | 25039.21 | 10400 | 29 | 23848.80645517241 | 0.747258 | 190851.31 | No | No
1 | E 5 | DAS | Comp 2 Door (specialty) | [NAME] | Chevy | Camaro | 1EF37 | 1LT | 1LT | LFX | MX0 | yes | 25414 | 25414 | 10400 | 29 | 24223.59645517241 | 0.747258 | 190851.31 | No | No
1 | E 5 | DAS | Comp 2 Door (specialty) | Deery Bros | Chevy | Camaro | 1EF37 | LT | 1LT | LFX | MX0 | yes | 25722 | 25722 | 10400 | 29 | 24531.59645517241 | 0.747258 | 190851.31 | No | No
1 | E 5 | DAS | Comp 2 Door (specialty) | [NAME] | Dodge | Challenger | LCDP22 | RT | 28F | EZH | DGJ | Yes | 27454 | 27454 | 14200 | 25 | 24476.9888 | 0.747258 | 190851.31 | No | No
1 | E 5 | DAS | Comp 2 Door (specialty) | Stivers | Ford | Mustang | P8C | GT | P8C | 99F | 443 | Yes | 27285 | 27285 | 13700 | 26 | 24388.0004 | 0.747258 | 190851.31 | No | No
1 | F 6 | DAS | Mid Size Specialty | [NAME] | Toyota | Camry | 2SE0 | SE V6 | SF11G |  |  | Yes | 26064 | 26064 | 10200 | 30 | 24803.67873333333 | 0.747258 | 190851.31 | No | No
1 | F 6 | DAS | Mid Size Specialty | Stivers | Ford | Fusion | P0K | Sport | 400A | 99C | 44B | Yes | 20969 | 20969 | 10100 | 27 | 20490.26123703703 | 0.747258 | 190851.31 | No | No
1 | F 6 | DAS | Mid Size Specialty | [NAME] | Dodge | Avenger | [NAME] | RT | 27L | ERB | DG2 | Yes | 21725 | 21725 | 8350 | 29 | 22066.47535517241 | 0.747258 | 190851.31 | No | No
1 | F 6 | DAS | Mid Size Specialty | [NAME] | Chevy | Malibu | 1ZJ69 | LT | 3LT | LY7 | MH2 | yes | 21669.65 | 21669.65 | 8150 | 26 | 22919.9323 | 0.747258 | 190851.31 | No | No
1 | F 6 | DAS | Mid Size Specialty | [NAME] | Ford | Fusion | P0K | 400A | Sport | 99C | 44B | No | 20746 | 20746 | 10100 | 27 | 20267.26123703703 | 0.747258 | 190851.31 | No | No
1 | F 6 | DAS | Mid Size Specialty | Deery Bros | Chevy | Malibu | 1ZK69 | LTZ | 2LZ | LYZ | MH2 | Yes | 23997.53 | 23997.53 | 9200 | 26 | 24463.1914 | 0.747258 | 190851.31 | No | No
1 | F 6 | DAS | Mid Size Specialty | LuJack | Honda | Accord | CS2B8CJNW | EXL-v6 |  |  |  | Yes | 27551 | 27551 | 13075 | 29 | 24361.68130517241 | 0.747258 | 190851.31 | No | No
1 | G 7 | DAS | [NAME] | [NAME] | Chevy | Impala | 1WF19 | LS | 1FL | LFX | MXO | Yes | 17758.25 | 17758.25 | 7900 | 30 | 18216.62213333333 | 0.747258 | 190851.31 | No | No
1 | G 7 | DAS | [NAME] | [NAME] | Chevy | Impala | 1WF19 | LS | 1FL | LFX | MXO | Yes | 17805.46 | 17805.46 | 7900 | 30 | 18263.83213333333 | 0.747258 | 190851.31 | No | No
1 | G 7 | DAS | [NAME] | [NAME] | Chevy | Impala | 1WF19 | LT | 2FL | LFX | MXO | Yes | 18275.75 | 18275.75 | 8500 | 30 | 18285.76733333333 | 0.747258 | 190851.31 | No | No
1 | G 7 | DAS | [NAME] | [NAME] | Ford | Taurus | P2D | SE | 100A | 99W | 44J | Yes | 19666 | 19666 | 10300 | 28 | 18785.36081428572 | 0.747258 | 190851.31 | No | No
1 | G 7 | DAS | [NAME] | Deery Bros | Chevy | Impala | 1WF14 | LS | 1FL | LFX | MXO | Yes | 18548.21 | 18548.21 | 7900 | 30 | 19006.58213333333 | 0.747258 | 190851.31 | No | No
1 | G 7 | DAS | [NAME] | Stivers | Ford | Taurus | P2D | Se | 100A | 99W | 44J | Yes | 19641 | 19641 | 10300 | 27 | 19012.80963703704 | 0.747258 | 190851.31 | No | No
1 | G 7 | DAS | [NAME] | [NAME] | Dodge | Charger | LDDP48 | RT | 28N | EZH | DGJ | No | 25198 | 25198 | 12700 | 25 | 23341.8758 | 0.747258 | 190851.31 | No | No
1 | G 7 | DAS | [NAME] | [NAME] | Toyota | Avalon | 3544 |  |  |  |  | Yes | 33057 | 33057 | Not Available | 29 |  | 0.747258 | 190851.31 | No | No | No Resale Available
1 | H 8 | Base | Hybrid (Civic or Insight) | LuJack | Honda | Civic | FB4F2CEW |  |  |  |  | No | 23461 | 23461 | 10200 | 44 | 20176.49817272728 | 0.747258 | 190851.31 | No | No
1 | H 8 | Base | Hybrid (Civic or Insight) | LuJack | Honda | Insight | ZE2H5CEW | LX |  |  |  | No | 20250 | 20250 | Not Available | 43 |  | 0.747258 | 190851.31 | No | No | No Resale Available
1 | I 9.1 | Base | Mid size hatchback Hybrid | [NAME] | Toyota | Prius | 1223 | Prius 2 |  |  |  | No | 23936 | 23936 | Not Available | 48 |  | 0.747258 | 190851.31 | No | No | No Resale Available
1 | J 10.1 | Base | Mid Size Hybrid | [NAME] | Ford | Fusion | P0L | Hybrid | 500A | 993 | 44H | No | 25844 | 25844 | 10600 | 36 | 23224.49047777778 | 0.747258 | 190851.31 | No | No | Answered yes to American made but actually s/be no
1 | J 10.1 | Base | Mid Size Hybrid | Stivers | Ford | Fusion | POL | [NAME] | 500A | 993 | 44H | No | 26195 | 26195 | 10600 | 36 | 23575.49047777778 | 0.747258 | 190851.31 | No | No | Answered yes to American made but actually s/be no
1 | J 10.1 | Base | Mid Size Hybrid | [NAME] | Toyota | Camry | [NAME] | 2560 | xle |  |  | No | 27499 | 27499 | 11400 | 39 | 23873.88213333333 | 0.747258 | 190851.31 | No | No | Answered yes to American made but actually s/be no
1 | K 11 | Base | Volt | [NAME]'s | Chevy | Volt | 1RC68 | [NAME] | std | LUU | MKA | Yes | 37964.86 | 37964.86 | Not Available | 40 |  | 0.747258 | 190851.31 | No | No | No Resale Available
1 | K 11 | Base | Volt | Deery Bros | Chevy | Volt | 1RC68 | Volt | Volt | LUU | MKA | Yes | 38487.61 | 38487.61 | Not Available | 40 |  | 0.747258 | 190851.31 | No | No | No Resale Available
1 | K 11 | Base | Volt | [NAME] | Chevy | Volt | 1RC68 | 5DR HB |  | LUU | MKA | Yes | 39420 | 39420 | Not Available | 40 |  | 0.747258 | 190851.31 | No | No | No Resale Available