Attachment_0001_Pricing_Matrix.xlsx

XLSX spreadsheet 44 KB Posted

Attached to
Commercial Vehicles Federal contract opportunity
Solicitation number
W56HZV-17-R-0092
Issued by
Department of the Army Materiel Command Contracting Command Detroit Arsenal

About this file

Attachment 0001 Pricing Matrix

View the file

Other files for this federal contract opportunity

Show all 17

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Summary Offeror Name:

Offeror is required to fill in unit prices on the three following tabs, and spares pricing on the Spares Detail tab.
Cells that require inputs are highlighted in yellow
All cells highlighted in yellow must be completed
Do not adjust formulas or otherwise manipulate any of the non-yellow highlighted cells
Do not alter or make changes to this attachment except for inputting values in those cells highlighted in yellow
Spreadsheet will calculate the Total proposed price IAW section M of the solicitation.
SUMMARY
Ordering Year 1$ - 0
Ordering Year 2$ - 0
Ordering Year 3$ - 0

Total Proposed Price: $ - 0

Ordering Year 1 Distinct Delivery Order Numbers will be issued for each individual Letter of Acceptance (LOA)

Ordering Year 1
CLIN NumericsDefinitionCLIN AssignmentOrdering YearOrder ItemLeft/Right Hand DriveColorQTYPriceExtended Price
1st NumericOrdering YearOrdering Year1001Ordering Year 12 Door PickupLeft Hand DriveWhite13$ - 0
2nd NumericOrder ItemOrdering Year 111002Ordering Year 12 Door PickupLeft Hand DriveTan54$ - 0
3rd NumericLeft/Right Hand DriveOrdering Year 221003Ordering Year 12 Door PickupLeft Hand DriveGreen54$ - 0
4th NumericColorOrdering Year 331004Ordering Year 12 Door PickupLeft Hand DriveBlack14$ - 0
1011Ordering Year 12 Door PickupRight Hand DriveWhite1$ - 0
CLIN AlphasDefinitionOrder Item1012Ordering Year 12 Door PickupRight Hand DriveTan1$ - 0
1st AlphaAssigned Upon Order2 Door Pickup01013Ordering Year 12 Door PickupRight Hand DriveGreen2$ - 0
2nd AlphaAssigned Upon Order4 Door Pickup11014Ordering Year 12 Door PickupRight Hand DriveBlack1$ - 0
SUV21101Ordering Year 14 Door PickupLeft Hand DriveWhite10$ - 0
Ambulance31102Ordering Year 14 Door PickupLeft Hand DriveTan40$ - 0
MMT41103Ordering Year 14 Door PickupLeft Hand DriveGreen40$ - 0
Spares81104Ordering Year 14 Door PickupLeft Hand DriveBlack10$ - 0
CDRL91111Ordering Year 14 Door PickupRight Hand DriveWhite1$ - 0
1112Ordering Year 14 Door PickupRight Hand DriveTan1$ - 0
Left/Right Hand1113Ordering Year 14 Door PickupRight Hand DriveGreen2$ - 0
Left Hand Drive01114Ordering Year 14 Door PickupRight Hand DriveBlack1$ - 0
Right Hand Drive11201Ordering Year 1SUVLeft Hand DriveWhite2$ - 0
Spares81202Ordering Year 1SUVLeft Hand DriveTan10$ - 0
CDRL91203Ordering Year 1SUVLeft Hand DriveGreen10$ - 0
1204Ordering Year 1SUVLeft Hand DriveBlack3$ - 0
Color1211Ordering Year 1SUVRight Hand DriveWhite1$ - 0
White11212Ordering Year 1SUVRight Hand DriveTan1$ - 0
Tan21213Ordering Year 1SUVRight Hand DriveGreen2$ - 0
Green31214Ordering Year 1SUVRight Hand DriveBlack1$ - 0
Black41301Ordering Year 1AmbulanceLeft Hand DriveWhite5$ - 0
Spares81302Ordering Year 1AmbulanceLeft Hand DriveTan18$ - 0
CDRL91303Ordering Year 1AmbulanceLeft Hand DriveGreen18$ - 0
1304Ordering Year 1AmbulanceLeft Hand DriveBlack4$ - 0
1311Ordering Year 1AmbulanceRight Hand DriveWhite1$ - 0
1312Ordering Year 1AmbulanceRight Hand DriveTan1$ - 0
1313Ordering Year 1AmbulanceRight Hand DriveGreen2$ - 0
1314Ordering Year 1AmbulanceRight Hand DriveBlack1$ - 0
1401Ordering Year 1MMTLeft Hand DriveWhite1$ - 0
1402Ordering Year 1MMTLeft Hand DriveTan6$ - 0
1403Ordering Year 1MMTLeft Hand DriveGreen6$ - 0
1404Ordering Year 1MMTLeft Hand DriveBlack1$ - 0
1411Ordering Year 1MMTRight Hand DriveWhite1$ - 0
1412Ordering Year 1MMTRight Hand DriveTan1$ - 0
1413Ordering Year 1MMTRight Hand DriveGreen2$ - 0
1414Ordering Year 1MMTRight Hand DriveBlack1$ - 0
1888Ordering Year 1SparesSparesSpares1$0.00$ - 0
1999Ordering Year 1CDRLCDRLCDRL1NSP
Total Estimated Value (Ordering Year 1):$ - 0

Ordering Year 2 Distinct Delivery Order Numbers will be issued for each individual Letter of Acceptance (LOA)

Ordering Year 2
CLIN NumericsDefinitionCLIN AssignmentOrdering YearOrder ItemLeft/Right Hand DriveColorQTYPriceExtended Price
1st NumericOrdering YearOrdering Year2001Ordering Year 22 Door PickupLeft Hand DriveWhite13$ - 0
2nd NumericOrder ItemOrdering Year 112002Ordering Year 22 Door PickupLeft Hand DriveTan54$ - 0
3rd NumericLeft/Right Hand DriveOrdering Year 222003Ordering Year 22 Door PickupLeft Hand DriveGreen54$ - 0
4th NumericColorOrdering Year 332004Ordering Year 22 Door PickupLeft Hand DriveBlack14$ - 0
2011Ordering Year 22 Door PickupRight Hand DriveWhite1$ - 0
CLIN AlphasDefinitionOrder Item2012Ordering Year 22 Door PickupRight Hand DriveTan1$ - 0
1st AlphaAssigned Upon Order2 Door Pickup02013Ordering Year 22 Door PickupRight Hand DriveGreen2$ - 0
2nd AlphaAssigned Upon Order4 Door Pickup12014Ordering Year 22 Door PickupRight Hand DriveBlack1$ - 0
SUV22101Ordering Year 24 Door PickupLeft Hand DriveWhite10$ - 0
Ambulance32102Ordering Year 24 Door PickupLeft Hand DriveTan40$ - 0
MMT42103Ordering Year 24 Door PickupLeft Hand DriveGreen40$ - 0
Spares82104Ordering Year 24 Door PickupLeft Hand DriveBlack10$ - 0
CDRL92121Ordering Year 24 Door PickupRight Hand DriveWhite1$ - 0
2112Ordering Year 24 Door PickupRight Hand DriveTan1$ - 0
Left/Right Hand2113Ordering Year 24 Door PickupRight Hand DriveGreen2$ - 0
Left Hand Drive02114Ordering Year 24 Door PickupRight Hand DriveBlack1$ - 0
Right Hand Drive12201Ordering Year 2SUVLeft Hand DriveWhite2$ - 0
Spares82202Ordering Year 2SUVLeft Hand DriveTan10$ - 0
CDRL92203Ordering Year 2SUVLeft Hand DriveGreen10$ - 0
2204Ordering Year 2SUVLeft Hand DriveBlack3$ - 0
Color2211Ordering Year 2SUVRight Hand DriveWhite1$ - 0
White12212Ordering Year 2SUVRight Hand DriveTan1$ - 0
Tan22213Ordering Year 2SUVRight Hand DriveGreen2$ - 0
Green32214Ordering Year 2SUVRight Hand DriveBlack1$ - 0
Black42301Ordering Year 2AmbulanceLeft Hand DriveWhite5$ - 0
Spares82302Ordering Year 2AmbulanceLeft Hand DriveTan18$ - 0
CDRL92303Ordering Year 2AmbulanceLeft Hand DriveGreen18$ - 0
2304Ordering Year 2AmbulanceLeft Hand DriveBlack4$ - 0
2311Ordering Year 2AmbulanceRight Hand DriveWhite1$ - 0
2312Ordering Year 2AmbulanceRight Hand DriveTan1$ - 0
2313Ordering Year 2AmbulanceRight Hand DriveGreen2$ - 0
2314Ordering Year 2AmbulanceRight Hand DriveBlack1$ - 0
2401Ordering Year 2MMTLeft Hand DriveWhite1$ - 0
2402Ordering Year 2MMTLeft Hand DriveTan6$ - 0
2403Ordering Year 2MMTLeft Hand DriveGreen6$ - 0
2424Ordering Year 2MMTRight Hand DriveBlack1$ - 0
2411Ordering Year 2MMTRight Hand DriveWhite1$ - 0
2412Ordering Year 2MMTRight Hand DriveTan1$ - 0
2413Ordering Year 2MMTRight Hand DriveGreen2$ - 0
2414Ordering Year 2MMTRight Hand DriveBlack1$ - 0
2888Ordering Year 2SparesSparesSpares1$0.00$ - 0
2999Ordering Year 2CDRLCDRLCDRL1NSP
Total Estimated Value (Ordering Year 2):$ - 0

Ordering Year 3 Distinct Delivery Order Numbers will be issued for each individual Letter of Acceptance (LOA)

Ordering Year 3
CLIN NumericsDefinitionCLIN AssignmentOrdering YearOrder ItemLeft/Right Hand DriveColorQTYPriceExtended Price
1st NumericOrdering YearOrdering Year3001Ordering Year 32 Door PickupLeft Hand DriveWhite13$ - 0
2nd NumericOrder ItemOrdering Year 113002Ordering Year 32 Door PickupLeft Hand DriveTan54$ - 0
3rd NumericLeft/Right Hand DriveOrdering Year 223003Ordering Year 32 Door PickupLeft Hand DriveGreen54$ - 0
4th NumericColorOrdering Year 333004Ordering Year 32 Door PickupLeft Hand DriveBlack14$ - 0
3011Ordering Year 32 Door PickupRight Hand DriveWhite1$ - 0
CLIN AlphasDefinitionOrder Item3012Ordering Year 32 Door PickupRight Hand DriveTan1$ - 0
1st AlphaAssigned Upon Order2 Door Pickup03013Ordering Year 32 Door PickupRight Hand DriveGreen2$ - 0
2nd AlphaAssigned Upon Order4 Door Pickup13014Ordering Year 32 Door PickupRight Hand DriveBlack1$ - 0
SUV23101Ordering Year 34 Door PickupLeft Hand DriveWhite10$ - 0
Ambulance33102Ordering Year 34 Door PickupLeft Hand DriveTan40$ - 0
MMT43103Ordering Year 34 Door PickupLeft Hand DriveGreen40$ - 0
Spares83104Ordering Year 34 Door PickupLeft Hand DriveBlack10$ - 0
CDRL93131Ordering Year 34 Door PickupRight Hand DriveWhite1$ - 0
3112Ordering Year 34 Door PickupRight Hand DriveTan1$ - 0
Left/Right Hand3113Ordering Year 34 Door PickupRight Hand DriveGreen2$ - 0
Left Hand Drive03114Ordering Year 34 Door PickupRight Hand DriveBlack1$ - 0
Right Hand Drive13201Ordering Year 3SUVLeft Hand DriveWhite2$ - 0
Spares83202Ordering Year 3SUVLeft Hand DriveTan10$ - 0
CDRL93203Ordering Year 3SUVLeft Hand DriveGreen10$ - 0
3204Ordering Year 3SUVLeft Hand DriveBlack3$ - 0
Color3211Ordering Year 3SUVRight Hand DriveWhite1$ - 0
White13212Ordering Year 3SUVRight Hand DriveTan1$ - 0
Tan23213Ordering Year 3SUVRight Hand DriveGreen2$ - 0
Green33214Ordering Year 3SUVRight Hand DriveBlack1$ - 0
Black43301Ordering Year 3AmbulanceLeft Hand DriveWhite5$ - 0
Spares83302Ordering Year 3AmbulanceLeft Hand DriveTan18$ - 0
CDRL93303Ordering Year 3AmbulanceLeft Hand DriveGreen18$ - 0
3304Ordering Year 3AmbulanceLeft Hand DriveBlack4$ - 0
3311Ordering Year 3AmbulanceRight Hand DriveWhite1$ - 0
3312Ordering Year 3AmbulanceRight Hand DriveTan1$ - 0
3313Ordering Year 3AmbulanceRight Hand DriveGreen2$ - 0
3314Ordering Year 3AmbulanceRight Hand DriveBlack1$ - 0
3401Ordering Year 3MMTLeft Hand DriveWhite1$ - 0
3402Ordering Year 3MMTLeft Hand DriveTan6$ - 0
3403Ordering Year 3MMTLeft Hand DriveGreen6$ - 0
3404Ordering Year 3MMTLeft Hand DriveBlack1$ - 0
3411Ordering Year 3MMTRight Hand DriveWhite1$ - 0
3412Ordering Year 3MMTRight Hand DriveTan1$ - 0
3413Ordering Year 3MMTRight Hand DriveGreen2$ - 0
3414Ordering Year 3MMTRight Hand DriveBlack1$ - 0
3888Ordering Year 3SparesSparesSpares1$0.00$ - 0
3999Ordering Year 3CDRLCDRLCDRL1NSP
Total Estimated Value (Ordering Year 3):$ - 0

Spares Detail

Toyota Land Cruiser common SPARE PARTS List
FOB-Origin - Years 1-2-3

6/28/17

PART DESCRIPTION (COMMON PARTS TO ALL VARIANTS)Year 1Year 2Year 3VENDOR PART NAMEOEM PART NUMBERUnit Price in US$Total Cost 1st YearUnit Price in US$Total Cost 2nd YearUnit Price in US$Total Cost 3rd Year
Vehicle QTYVehicle QTYVehicle QTYNew/Replacment Part Number
344344344Primary #1st Year2nd Year3rd Year
EXTERIOR
WINDSHIELD ASM404040WINDSHIELD GLASS56111-60220$0.00$0.00$0.00
BLADE ASM-WIPER (RH)300300300BLADE, FR WIPER, RH85212-60032/60022 (RHD)$0.00$0.00$0.00
BLADE ASM-WIPER (LH)300300300BLADE FR WIPER, LH85222-60062/60052 (RHD)$0.00$0.00$0.00
ELECTRICAL
BULB-HEADLAMP400400400HB2 BULB 12V 60W55W90981-13058$0.00$0.00$0.00
BULB-TAIL LAMP200200200BULB 12V 21W5W99132-21210-75$0.00$0.00$0.00
BULB-TURN SIG/CLEAR100100100BULB 12V 21W99132-11210$0.00$0.00$0.00
BULB-FOG LP200200200BULB 12V 5W99132-12050$0.00$0.00$0.00
TERMINAL-BATTERY505050TERMINAL, JUNCTION82675-60030$0.00$0.00$0.00
BATTERY100100100BATTERY-TGB 80D26R-DRY28800-YZZKE$0.00$0.00$0.00
ENGINE/TRANSMISSION
STARTER-MOTOR505050STARTER ASSY28100-17091$0.00$0.00$0.00
ALTERNATOR (120 AMP)505050ALTERNATOR ASSY 120A27060-17230$0.00$0.00$0.00
INJECTOR-FUEL NOZZLE ASM300300300HOLDER & NOZZLE SET23600-19075$0.00$0.00$0.00
PLATE ASM-CLUTCH DISC757575DISC ASSY, CLUTCH31250-60431$0.00$0.00$0.00
COVER ASM-CLUTCH757575COVER ASSY, CLUTCH31210-36330$0.00$0.00$0.00
BEARING ASM-CLUTCH757575BEARING ASSY, CLUTCH31230-60201$0.00$0.00$0.00
GASKET KIT-ENGINE757575ENG GASKET KIT-1HZ04111-17110$0.00$0.00$0.00
THERMOSTAT-ENGINE COOL757575THERMOSTAT90916-03089$0.00$0.00$0.00
FILTER-OIL700700700OIL FILTER90915-30002-8T$0.00$0.00$0.00
FILTER-FUEL100100100ELEMENT ASSY, FUEL F23390-64480$0.00$0.00$0.00
FILTER-FUEL (SUV & AMBULANCE only)505050ELEMENT ASSY, FUEL23390-51070$0.00$0.00$0.00
FILTER-AIR CLEANER350350350AIR FILTER17801-61030$0.00$0.00$0.00
PUMP ASM-FUEL FEED100100100FUEL PUMP FEED22505-54010$0.00$0.00$0.00
HVAC
BELT-FAN & ALTERNATOR757575FAN BELT90916-02452$0.00$0.00$0.00
BELT-A/C V757575BELT99332-11260-8T$0.00$0.00$0.00
BELT-TIMING757575TIMING BELT13568-19195$0.00$0.00$0.00
RADIATOR ASM757575RADIATOR ASSY16400-17400$0.00$0.00$0.00
HOSE-RAD INLET757575RADIATOR HOSE16571-17020$0.00$0.00$0.00
HOSE-RAD OUTLET757575HOSE, RADIATOR, NO.216572-17150$0.00$0.00$0.00
EXHAUST SYSTEM
MUFFLER ASM-EXHAUST505050PIPE17405-17073$0.00$0.00$0.00
MUFFLER ASM-EXHAUST (SUV only)252525PIPE SUB-ASSY,17405-17280$0.00$0.00$0.00
PIPE ASM-EXHAUST505050EXHAUST PIPE17403-17190$0.00$0.00$0.00
PIPE ASM-EXHAUST (SUV only)252525PIPE SUB-ASSY,17403-17220$0.00$0.00$0.00
PIPE ASM-EXHAUST (AMBULANCE only)252525EXHAUST PIPE17403-17070$0.00$0.00$0.00
HANGER-EXHAUST BRKT505050EXHAUST PIPE BRACKE17581-17010$0.00$0.00$0.00
BRACKET-EXHAUST CTR/RR505050EXHAUST PIPE BRACKE17581-17020$0.00$0.00$0.00
GASKET-EXHAUST505050EXHAUST PIPE GASKET90917-06049$0.00$0.00$0.00
GASKET-EXHAUST505050EXHAUST PIPE GASKET90917-06076$0.00$0.00$0.00
BRAKES
CALIPER ASM-BRAKE FRT (RH or LH)303030BRAKE CALIPER ASSY47730-60120$0.00$0.00$0.00
CYLINDER ASM-DISC BRK FRT (RH or LH)303030CYLINDER ASSY, DISC47750-60120$0.00$0.00$0.00
DISC-BRAKE FRT (RH or LH)175175175DISC, FR43512-60141$0.00$0.00$0.00
PAD KIT-DISC BRAKE FRT175175175PAD KIT, DISC BRAKE04465-60340$0.00$0.00$0.00
CYLINDER-BRAKE WHEEL RR (RH or LH)100100100BRAKE WHEEL CYLINDER47550-60120$0.00$0.00$0.00
DRUM-BRAKE RR (RH or LH)100100100BRAKE DRUM42431-60250$0.00$0.00$0.00
DISC-BRAKE RR (RH or LH) (4-DR P/U only)303030DISC, RR42431-60262$0.00$0.00$0.00
CUP KIT-BRAKE RR505050CUP KIT-2 PCS04906-35130$0.00$0.00$0.00
SHOE KIT-BRAKE RR505050BRAKE SHOE KIT RR04495-60070$0.00$0.00$0.00
PAD KIT-DISC BRAKE RR (4-DR P/U only)505050PAD KIT, DISC BRAKE RR04466-60080$0.00$0.00$0.00
CYLINDER KIT-BRAKE MASTER303030BRAKE MASTER CYL KIT04493-60300$0.00$0.00$0.00
CYLINDER KIT-BRAKE MASTER (4-DR P/U only)101010BRAKE MASTER CYL KIT04493-60380$0.00$0.00$0.00
SUSPENSION & TIRES/WHEELS
ABSORBER ASM-FRT SHK757575SHOCK ABSORBER FRONT48511-69645$0.00$0.00$0.00
ABSORBER ASM-FRT SHK (SUV only)252525SHOCK ABSORBER FRONT48511-69665$0.00$0.00$0.00
ABSORBER ASM-FRT (use base part ELIN B047)555SHOCK (use ELIN B047)48511-69675$0.00$0.00$0.00
ABSORBER ASM-RR SHK303030SHOCK ABSORBER REAR48531-69645$0.00$0.00$0.00
ABSORBER ASM-RR SHK (SUV & AMB. only)202020SHOCK ABSORBER REAR48531-69855$0.00$0.00$0.00
NUT-WHEEL HUB300300300NUT, HUB90942-01101$0.00$0.00$0.00
TIRE-SAND (7.50R16) Yokohama Y402B300300300Yokohama Y402BTY750R16YO1$0.00$0.00$0.00
RADIO FREQUENCY IDENTIFICATION TAG111RFID Tag$0.00$0.00$0.00
Total Evaluated Yearly Price in US$ for Origin Spares$0.00$0.00$0.00
*NOTES (PART DESCRIPTION):
1) If RH or LH is noted, then order qty. should be in multiples of 2
2) Indented parts are unique to 4-Door Pickup (P/U), SUV and/or Ambulance variants
3) Only one RFID Tag is required, for any complete package lot of "Spare Parts" being ordered, per country destination shipment
4) Quantities are all estimates only for quotation purposes
5) If the OEM Part Number is no longer available, Offeror shall provide the New/Replacement Part Number in Column G. Blank response in Column G is accetable only if OEM Part Number is available.

File details come from the government source that posted it.