Attachment_B_Pricing_Spreadsheet_International_Insurance_BPA_RFQ.xlsx

XLSX spreadsheet 30 KB Posted

Attached to
Multiple Award BPA: International Vehicle and Vess
Solicitation number
140G0125Q0212
Issued by

About this file

This is a pricing spreadsheet for an International Insurance Blanket Purchase Agreement (BPA) for vehicles and vessels used by the US Geological Survey. The document details 92 total vehicles and vessels across multiple regional centers, including locations in Washington, New England, New York, Wyoming, Montana, and other midwestern states. Vehicles include various makes and models such as Ford, Chevrolet, Dodge, and Nissan trucks, SUVs, and passenger vehicles, as well as several boats from manufacturers like Seaark, Zodiac, Boston Whaler, and Hewes Marine.

The solicitation (140G0125Q0212) is for a multiple-award BPA for international vehicle and vessel insurance, prepared under simplified acquisition procedures. The pricing section shows multiple option periods with placeholder pricing (currently listed as $0.00), and the data call indicates most vehicles will be crossing into Canada, with no vehicles planned to cross into Mexico. The insurance coverage is specifically for vehicles and vessels that may cross international borders, primarily the US-Canada maritime border, with an anticipated annual total of approximately 239 trips across regional centers.

View the file

Other files

File Type Posted
Sol_140G0125Q0212.pdf PDF
Attachment_A_Instructions_to_Vendors_and_SOW.pdf PDF

On GovTribe

Work with this file

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

Text version

Sheet1

Data Call for International Insurance BPA for Vehicles/Vessels
CenterPOCPOC Email# of Vehicles/Vessels to be InsuredAnticipated # of Trips to be Insured (Annually)Crossing into Canada? (Y/N)Crossing into Mexico (Y/N)?Going into any other international territory (e.g. Caribbean)? Please list country/territory.Comments
WAWSC612YNNo
WAWSC
New England WSC (GGENLG)610YNN
NYWSC1 Boat (Boston Whaler Guardian 19)10YNNoOnly the boat crosses the Maritime border. Vehicle stays in the USA.
NYWSC1 Boat (Boston Whaler Guardian 19)12YNNoOnly the boat crosses the Maritime border. Vehicle stays in the USA.
MCR00NNNoRegional POC
MCR00NNNoRegional POC
WY-MT WSC725YNNo
NOROCK54YNNo
GLSC40150YNNo
DWSC48YNNo
NPWRC107YNNo
UMid912YNNo
UMESC31YNNo
TOTAL92
Pricing: Cost Breakdown
Vehicle/Vessel/TrailerYearMakeModelVinCustodianCENTER NAMECOST CENTERLOCATIONBase Period PricingOption Period One (1) PricingOption Period Two (2) PricingOption Period Three (3) PricingOption Period Four (4) Pricing
G62-2213X2020FordExplorer Hybrid1FM5K8FW4LGC68647TBAWAWSC
I-4350042021FordEscape Hybrid1FMCU9BZ8MUA81468TBAWAWSC
62-3991W2019DodgeDodge Ram 15001C6RR7FT9KS651469TBAWAWSC
G63-1119X2020ChevyK2500HD1GB2YLE75LF337844TBAWAWSC
G63-0770Z2023ChevyK35001GB5YSEY7PF221387TBAWAWSC
I-4313142008Ford4x4 GW Mobile Lab1FDWF37568EB26076TBAWAWSC
I4337902012Dodge2500 Diesel Pickup3C6UD5CL3CG315276TBANPWRCGGEMNN00008711 37th St SE, Jamestown, ND
I4337912012Dodge2500 Diesel Pickup3C6UD5CLXCG315274TBANPWRCGGEMNN00008711 37th St SE, Jamestown, ND
I4342042017FordExpedition EL SUV1FMJK1GT0HEA37757TBANPWRCGGEMNN00008711 37th St SE, Jamestown, ND
I4354632024ChevroletBlazer SUV3GNKBJRS1RS168885TBANPWRCGGEMNN00008711 37th St SE, Jamestown, ND
I4343432018JeepGrand Cherokee SUV1C4RJFAG8JC161926TBANPWRCGGEMNN00008711 37th St SE, Jamestown, ND
I4345092019FordF150 Pickup1FTEW1E44KFA44167TBANPWRCGGEMNN00008711 37th St SE, Jamestown, ND
I4346812020Chevrolet1500 Pickup1GCUYAEF6LZ169632TBANPWRCGGEMNN00008711 37th St SE, Jamestown, ND
G90280382014SEAARK Boat 18'RST 180CCSOM40115D616TBANPWRCGGEMNN00008711 37th St SE, Jamestown, ND
G90252692012ZODIAC BOATPRO 500US-XDCP5018J314TBANPWRCGGEMNN00008711 37th St SE, Jamestown, ND
G10043482006BOSTON WHALER17 UTILITY BASEHIN-WCG00273D707TBANPWRCGGEMNN00008711 37th St SE, Jamestown, ND
Vehicle2023FordF2501FT7W2BA2PEC79396TBAUMidGGEMNKGrand Rapids, 55744
Vehicle2024FordF2501FT7W2BT9RED58603TBAUMidGGEMNKGrand Rapids, 55744
Vehicle2023FordF2501FTBR2Y8XPKA08299TBAUMidGGEMNKLansing, MI 48911
Vehicle2023NissanTitan1N6AA1EC5PN115715TBAUMidGGEMNKMounds View, MN 55112
Vehicle2019FordF2501FD7X2B67KEC15867TBAUMidGGEMNKMounds View, MN 55112
Vehicle2021ChevroletEquinox2GNAXSEV1M6162661TBAUMidGGEMNKLansing, MI 48911
Vehicle2019FordF3501FT8X3BT1KED55868TBAUMidGGEMNKMounds View, MN 55112
Vehicle2023FordFord Explorer (green)1FMSK8BB9PGB39962TBAUMidGGEMNKMadison, WI 53726
Vehicle2023FordFord Escape (blue)1FMCU0GN2PUA32790TBAUMidGGEMNKMadison, WI 53726
Vehicle2023FordF-1501FTEW1EP3PKE67346TBAUMidGGEMNKMadison, WI 53726
Vehicle2016FordF-1501GDP7D1E3JV508541TBAUMidGGEMNKMounds View, MN 55112
Vehicle2018Chevrolet35001GB4KYCG2JF286679TBAUMidGGEMNKGrand Rapids, 55744
Vehicle2018ChevroletSilverado 2500HD1GC1KUEG0JF265396TBAUMidGGEMNKGrand Rapids, 55744
Vehicle2020ChevroletSilverado1GCRYAEF7MZ202905TBAUMidGGEMNKMounds View, MN 55112
Vehicle2021ChevroletEquinox2GNAXSEV4M6162704TBAUMidGGEMNKMounds View, MN 55112
Vehicle2012FordF3501FT8W3BT6CEA42934TBAUMidGGEMNKMounds View, MN 55112
Vehicle2021FordTransit 1501FTYE1CG5MKA81204TBAUMidGGEMNKMounds View, MN 55112
Vessel2009Hewes Marine200 PROV SportsmanHEW 568081910TBAUMidGGEMNKLansing, MI
Vessel2012CrestlinerFishawkCRC52259E212TBAUMidGGEMNKGrand Rapids, MN
Vessel2015Kann Marine22X72 V8 Kann BoatKMQ2256F015TBAUMidGGEMNKMounds View, MN
Vessel2006Polar KraftPolar KraftPLR4536D606TBAUMidGGEMNKGrayling, MI
Vessel2015TrackerJon BoatBUJ109751415TBAUMidGGEMNKGrand Rapids,55744
Vessel2012Hewes Marine200 PRO VHEW63937E212TBAUMidGGEMNKMadison, WI
Vessel1998Kann MarineRunaboutKMQ018225A898TBAUMidGGEMNKMounds View, MN
Vessel2005SpiritSwift River BoatSMX00368C101TBAUMidGGEMNKMounds View, MN
G63-0649Y2021DodgeRam 35003C7WR3GJ3MG687754TBAWYMTGGEMRSHelena, MT
G63-2563X2020FordF3501FD8W3B63LEE23212TBAWYMTGGEMRSBillings, MT
G63-2565X2020FordF3501FD8X3B60LEE23262TBAWYMTGGEMRSBillings, MT
G63-A11362023FordF3501FD8W3B63NEE51014TBAWYMTGGEMRSBillings, MT
I-4307382005FordF3501FTWX33Y65EB87554TBAWYMTGGEMRSHelena, MT
I-4354412024Chevrolet15001GCRDAEDXRZ206125TBAWYMTGGEMRSBillings, MT
I-4356022024ChryslerPacifica2C4RC1BG2RR200864TBAUMESCGGEMNB0000La Crosse, WI
I-4356012024Ram3500 ST 4x43C63R3GJ2RG344707TBAUMESCGGEMNB0000La Crosse, WI
I-4346622020DodgeDurango1C4RDJAGXLC192365TBAUMESCGGEMNB0000La Crosse, WI
Vehicle2019DodgeDurango1C4RDJAG0KC827284TBANE WSCGGENLGAugusta, ME 04330
Vehicle2019FordF-2501FT7W2B64KEF8476TBANE WSCGGENLGAugusta, ME 04330
Vehicle2015ChevySilverado1G2KUEG2FZ106664TBANE WSCGGENLGAugusta, ME 04330
Vehicle2011FordF-3501FD8W3B68BEC97895TBANE WSCGGENLGAugusta, ME 04330
TrailerTBATBATBATBATBATBATBATBA
TrailerTBATBATBATBATBATBATBATBA
TrailerTBATBATBATBATBATBATBATBA
TrailerTBATBATBATBATBATBATBATBA
BoatTBATBATBATBATBATBATBATBA
BoatTBATBATBATBATBATBATBATBA
BoatTBATBATBATBATBATBATBATBA
BoatTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
VehicleTBATBATBATBATBATBATBATBA
Total Price Per Period$0.00$0.00$0.00$0.00$0.00
Total Overall Price$0.00

File details come from the government source that posted it. Updated .