The file's text, extracted by GovTribe without its formatting.
Instructions
| Heavy Duty Vehicle Variants |
| Attachment 0005 - Pricing Spreadsheet |
| Solicitation: W56HZV-19-R-0079 |
| INSTRUCTIONS TO OFFERORS: |
| 1. Cells that require inputs are highlighted in yellow |
| 2. All cells that are highlighted in yellow must be completed, once completed, cells that read, "Error!" or a similar message, will adjust. |
| 3. Do not manipulate or alter any of the other cells, except those that are highlighted in yellow |
| 4. The "Summary" worksheet reflects the Total Proposed Price, notice that only the offerors name and date is required on that sheet |
| 5. The Government will add transportation costs to the Total Proposed Price for all CLINS in accordance with Section M to calculate the Total Evaluated Price. |
Summary
| Heavy Duty Vehicle Variants |
| Attachment 0005 - Pricing Spreadsheet |
| Solicitation: W56HZV-19-R-0079 |
| CLIN | Description | Total Proposed Price | |
| 0011 | Fuel Truck (Left Hand Drive) | ERROR! | 1 |
| 0021 | Fuel Truck (Right Hand Drive) | ERROR! | 1 |
| 0031 | Water Truck (Left Hand Drive) | ERROR! | 1 |
| 0041 | Water Truck (Right Hand Drive) | ERROR! | 1 |
| 0051 | Flatbed Truck (Left Hand Drive) | ERROR! | 1 |
| 0061 | Flatbed Truck (Right Hand Drive) | ERROR! | 1 |
| 0071 | Personel Carrier (Left Hand Drive) | ERROR! | 1 |
| 0081 | Personel Carrier (Right Hand Drive) | ERROR! | 1 |
| 0091 | Spares | ERROR! | |
| 0012 | Fuel Truck (Left Hand Drive) | ERROR! | 1 |
| 0022 | Fuel Truck (Right Hand Drive) | ERROR! | 1 |
| 0032 | Water Truck (Left Hand Drive) | ERROR! | 1 |
| 0042 | Water Truck (Right Hand Drive) | ERROR! | 1 |
| 0052 | Flatbed Truck (Left Hand Drive) | ERROR! | 1 |
| 0062 | Flatbed Truck (Right Hand Drive) | ERROR! | 1 |
| 0072 | Personel Carrier (Left Hand Drive) | ERROR! | 1 |
| 0082 | Personel Carrier (Right Hand Drive) | ERROR! | 1 |
| 0092 | Spares | ERROR! | |
| 0013 | Fuel Truck (Left Hand Drive) | ERROR! | 1 |
| 0023 | Fuel Truck (Right Hand Drive) | ERROR! | 1 |
| 0033 | Water Truck (Left Hand Drive) | ERROR! | 1 |
| 0043 | Water Truck (Right Hand Drive) | ERROR! | 1 |
| 0053 | Flatbed Truck (Left Hand Drive) | ERROR! | 1 |
| 0063 | Flatbed Truck (Right Hand Drive) | ERROR! | 1 |
| 0073 | Personel Carrier (Left Hand Drive) | ERROR! | 1 |
| 0083 | Personel Carrier (Right Hand Drive) | ERROR! | |
| 0093 | Spares | ERROR! | |
| CLIN | Description | Total Proposed Price |
| A001 | VEHICLE PHOTOGRAPHS | Not Separately Priced |
| A002 | START OF WORK MEETING | Not Separately Priced |
| A003 | START OF PRODUCTION MEETING | Not Separately Priced |
| A004 | FINAL INSPECTION REPORT (FIR) | Not Separately Priced |
| A005 | FIRST PRODUCTION VEHICLE FINAL REPORT | Not Separately Priced |
Total Proposed Price ERROR! 23
1st Ordering Year
| Heavy Duty Vehicle Variants |
| Attachment 0005 - Pricing Spreadsheet |
| Solicitation: W56HZV-19-R-0079 |
| Offeror: | ERROR! Fill-in Name on Summary Page | | |
| | | | FIRST ORDERING YEAR |
| CLIN | Description | Evaluated Quantity | Proposed |
| Unit Price | Proposed | | | |
Extended Price
| 0011 | Fuel Truck (Left Hand Drive) | 67 | | ERROR! |
| 0021 | Fuel Truck (Right Hand Drive) | 1 | | ERROR! |
| 0031 | Water Truck (Left Hand Drive) | 57 | | ERROR! |
| 0041 | Water Truck (Right Hand Drive) | 1 | | ERROR! |
| 0051 | Flatbed Truck (Left Hand Drive) | 7 | | ERROR! |
| 0061 | Flatbed Truck (Right Hand Drive) | 1 | | ERROR! |
| 0071 | Personel Carrier (Left Hand Drive) | 103 | | ERROR! |
| 0081 | Personel Carrier (Right Hand Drive) | 12 | | ERROR! |
| Ordering Year 1 | | Total Extended Vehicles Price: | $ - 0 |
2nd Ordering Year
| Heavy Duty Vehicle Variants |
| Attachment 0005 - Pricing Spreadsheet |
| Solicitation: W56HZV-19-R-0079 |
| Offeror: | ERROR! Fill-in Name on Summary Page | | |
| | | | SECOND ORDERING YEAR |
| CLIN | Description | Evaluated Quantity | Proposed |
| Unit Price | Proposed | | | |
Extended Price
| 0012 | Fuel Truck (Left Hand Drive) | 35 | | ERROR! |
| 0022 | Fuel Truck (Right Hand Drive) | 1 | | ERROR! |
| 0032 | Water Truck (Left Hand Drive) | 32 | | ERROR! |
| 0042 | Water Truck (Right Hand Drive) | 1 | | ERROR! |
| 0052 | Flatbed Truck (Left Hand Drive) | 9 | | ERROR! |
| 0062 | Flatbed Truck (Right Hand Drive) | 1 | | ERROR! |
| 0072 | Personel Carrier (Left Hand Drive) | 78 | | ERROR! |
| 0082 | Personel Carrier (Right Hand Drive) | 14 | | ERROR! |
| Ordering Year 2 | | Total Extended Vehicles Price: | $ - 0 |
3rd Ordering Year
| Heavy Duty Vehicle Variants |
| Attachment 0005 - Pricing Spreadsheet |
| Solicitation: W56HZV-19-R-0079 |
| Offeror: | ERROR! Fill-in Name on Summary Page | | |
| | | | THIRD ORDERING YEAR |
| CLIN | Description | Evaluated Quantity | Proposed |
| Unit Price | Proposed | | | |
Extended Price
| 0013 | Fuel Truck (Left Hand Drive) | 30 | | ERROR! |
| 0023 | Fuel Truck (Right Hand Drive) | 1 | | ERROR! |
| 0033 | Water Truck (Left Hand Drive) | 29 | | ERROR! |
| 0043 | Water Truck (Right Hand Drive) | 1 | | ERROR! |
| 0053 | Flatbed Truck (Left Hand Drive) | 10 | | ERROR! |
| 0063 | Flatbed Truck (Right Hand Drive) | 1 | | ERROR! |
| 0073 | Personel Carrier (Left Hand Drive) | 60 | | ERROR! |
| 0083 | Personel Carrier (Right Hand Drive) | 16 | | ERROR! |
| Ordering Year 3 | | Total Extended Vehicles Price: | $ - 0 |
Spares
| SPARE PARTS - HDVs: All parts ordered under Spares CLINs will be shipped at the same time. |
| Attachment 0005 - Pricing Spreadsheet |
| Solicitation: W56HZV-19-R-0079 |
| 0 |
| Offeror | Original Equipment Manufacturer | | FIRST ORDERING YEAR - CLIN 0091 | | | SECOND ORDERING YEAR - CLIN 0092 | | | THIRD ORDERING YEAR - CLIN 0093 | | |
| PART DESCRIPTION | Vendor Part Name | Primary Number | Replacement Number | EVALUATED QTY | PROPOSED UNIT PRICE | EXTENDED PRICE | EVALUATED QTY | PROPOSED UNIT PRICE | EXTENDED PRICE | EVALUATED QTY | PROPOSED UNIT PRICE | EXTENDED PRICE |
| EXTERIOR | | | | | | |
| WINDSHIELD ASM | 20 | $ - 0 | 14 | $ - 0 | 12 | $ - 0 |
| BLADE ASM-WIPER (RH) | 300 | $ - 0 | 200 | $ - 0 | 160 | $ - 0 |
| BLADE ASM-WIPER (LH) | 300 | $ - 0 | 200 | $ - 0 | 160 | $ - 0 |
| ELECTRICAL | | | | | | |
| BULB-HEADLAMP | 100 | $ - 0 | 70 | $ - 0 | 60 | $ - 0 |
| BULB-TAIL LAMP | 100 | $ - 0 | 70 | $ - 0 | 60 | $ - 0 |
| BULB-SI MARKER | 100 | $ - 0 | 70 | $ - 0 | 60 | $ - 0 |
| BULB-BRAKE LGT | 100 | $ - 0 | 70 | $ - 0 | 60 | $ - 0 |
| BATTERY-HEAVY DUTY | 200 | $ - 0 | 140 | $ - 0 | 120 | $ - 0 |
| ENGINE/TRANSMISSION | | | | | | |
| ALTERNATOR | 40 | $ - 0 | 28 | $ - 0 | 24 | $ - 0 |
| STARTER MOTOR | 30 | $ - 0 | 20 | $ - 0 | 18 | $ - 0 |
| WATER PUMP-ENGINE | 40 | $ - 0 | 28 | $ - 0 | 24 | $ - 0 |
| FUEL INJECTOR-ENGINE | 40 | $ - 0 | 28 | $ - 0 | 24 | $ - 0 |
| CYLINDER ASM-CLUTCH MASTER | 40 | $ - 0 | 28 | $ - 0 | 24 | $ - 0 |
| KIT-CLUTCH | 40 | $ - 0 | 28 | $ - 0 | 24 | $ - 0 |
| BEARING-CLUTCH REL | 40 | $ - 0 | 28 | $ - 0 | 24 | $ - 0 |
| GASKET-THERMOSTAT | 40 | $ - 0 | 28 | $ - 0 | 24 | $ - 0 |
| THERMOSTAT-ENGINE | 40 | $ - 0 | 28 | $ - 0 | 24 | $ - 0 |
| SEPARATOR ASM-FUEL/WATER | 40 | $ - 0 | 28 | $ - 0 | 24 | $ - 0 |
| FILTER-OIL | 800 | $ - 0 | 560 | $ - 0 | 480 | $ - 0 |
| FILTER-FUEL | 400 | $ - 0 | 380 | $ - 0 | 240 | $ - 0 |
| FILTER-AIR | 250 | $ - 0 | 175 | $ - 0 | 150 | $ - 0 |
| FILTER-AIR DRYER | 100 | $ - 0 | 70 | $ - 0 | 60 | $ - 0 |
| HVAC | | | | | | |
| BELT-V RIB (SERPENTINE) A/C, FAN, ALT | 40 | $ - 0 | 28 | $ - 0 | 24 | $ - 0 |
| FILTER-A/C | 100 | $ - 0 | 70 | $ - 0 | 60 | $ - 0 |
| HOSE-RAD UPR | 50 | $ - 0 | 35 | $ - 0 | 30 | $ - 0 |
| HOSE-RAD LWR | 50 | $ - 0 | 35 | $ - 0 | 30 | $ - 0 |
| BRAKES | | | | | | |
| DRUM-BRAKE FRT (RH or LH) | 200 | $ - 0 | 140 | $ - 0 | 120 | $ - 0 |
| DRUM-BRAKE RR (RH or LH) | 200 | $ - 0 | 140 | $ - 0 | 120 | $ - 0 |
| SHOE KIT-BRAKE FRT | 240 | $ - 0 | 170 | $ - 0 | 150 | $ - 0 |
| SHOE KIT-BRAKE RR | 240 | $ - 0 | 170 | $ - 0 | 150 | $ - 0 |
| SUSPENSION & TIRES/WHEELS | | | | | | |
| ABSORBER ASM-FRT SHK (RH or LH) | 200 | $ - 0 | 140 | $ - 0 | 120 | $ - 0 |
| ABSORBER ASM-RR SHK (RH or LH) | 200 | $ - 0 | 140 | $ - 0 | 120 | $ - 0 |
| NUT/WASHER-WHEEL HUB | 300 | $ - 0 | 200 | $ - 0 | 200 | $ - 0 |
| TIRE-OFF ROAD (*Specify size) | 1000 | $ - 0 | 700 | $ - 0 | 600 | $ - 0 |
| WHEEL ASM (RIM) | 30 | $ - 0 | 20 | $ - 0 | 18 | $ - 0 |
| 20 FT. ISO SHIPPING/STORAGE CONTAINER | 16 | $ - 0 | 12 | $ - 0 | 10 | $ - 0 |
| TOTAL EXTENDED PRICE YEAR 1 - CLIN 0091 | ERROR! | 36 |
| TOTAL EXTENDED PRICE YEAR 2 - CLIN 0092 | ERROR! | 36 |
| TOTAL EXTENDED PRICE YEAR 3 - CLIN 0093 | ERROR! | 36 |