Attachment_B_Pricing_Spreadsheet_International_Insurance_BPA_RFQ.xlsx
XLSX spreadsheet 30 KB Posted
- Solicitation number
- 140G0125Q0212
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 | ||
| Attachment_A_Instructions_to_Vendors_and_SOW.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 | ||||||||
| Center | POC | POC Email | # of Vehicles/Vessels to be Insured | Anticipated # 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 |
| WAWSC | 6 | 12 | Y | N | No | |||
| WAWSC | ||||||||
| New England WSC (GGENLG) | 6 | 10 | Y | N | N | |||
| NYWSC | 1 Boat (Boston Whaler Guardian 19) | 10 | Y | N | No | Only the boat crosses the Maritime border. Vehicle stays in the USA. | ||
| NYWSC | 1 Boat (Boston Whaler Guardian 19) | 12 | Y | N | No | Only the boat crosses the Maritime border. Vehicle stays in the USA. | ||
| MCR | 0 | 0 | N | N | No | Regional POC | ||
| MCR | 0 | 0 | N | N | No | Regional POC | ||
| WY-MT WSC | 7 | 25 | Y | N | No | |||
| NOROCK | 5 | 4 | Y | N | No | |||
| GLSC | 40 | 150 | Y | N | No | |||
| DWSC | 4 | 8 | Y | N | No | |||
| NPWRC | 10 | 7 | Y | N | No | |||
| UMid | 9 | 12 | Y | N | No | |||
| UMESC | 3 | 1 | Y | N | No | |||
| TOTAL | 92 |
| Pricing: Cost Breakdown | |||||||||||||
| Vehicle/Vessel/Trailer | Year | Make | Model | Vin | Custodian | CENTER NAME | COST CENTER | LOCATION | Base Period Pricing | Option Period One (1) Pricing | Option Period Two (2) Pricing | Option Period Three (3) Pricing | Option Period Four (4) Pricing |
| G62-2213X | 2020 | Ford | Explorer Hybrid | 1FM5K8FW4LGC68647 | TBA | WAWSC | |||||||
| I-435004 | 2021 | Ford | Escape Hybrid | 1FMCU9BZ8MUA81468 | TBA | WAWSC | |||||||
| 62-3991W | 2019 | Dodge | Dodge Ram 1500 | 1C6RR7FT9KS651469 | TBA | WAWSC | |||||||
| G63-1119X | 2020 | Chevy | K2500HD | 1GB2YLE75LF337844 | TBA | WAWSC | |||||||
| G63-0770Z | 2023 | Chevy | K3500 | 1GB5YSEY7PF221387 | TBA | WAWSC | |||||||
| I-431314 | 2008 | Ford | 4x4 GW Mobile Lab | 1FDWF37568EB26076 | TBA | WAWSC | |||||||
| I433790 | 2012 | Dodge | 2500 Diesel Pickup | 3C6UD5CL3CG315276 | TBA | NPWRC | GGEMNN0000 | 8711 37th St SE, Jamestown, ND | |||||
| I433791 | 2012 | Dodge | 2500 Diesel Pickup | 3C6UD5CLXCG315274 | TBA | NPWRC | GGEMNN0000 | 8711 37th St SE, Jamestown, ND | |||||
| I434204 | 2017 | Ford | Expedition EL SUV | 1FMJK1GT0HEA37757 | TBA | NPWRC | GGEMNN0000 | 8711 37th St SE, Jamestown, ND | |||||
| I435463 | 2024 | Chevrolet | Blazer SUV | 3GNKBJRS1RS168885 | TBA | NPWRC | GGEMNN0000 | 8711 37th St SE, Jamestown, ND | |||||
| I434343 | 2018 | Jeep | Grand Cherokee SUV | 1C4RJFAG8JC161926 | TBA | NPWRC | GGEMNN0000 | 8711 37th St SE, Jamestown, ND | |||||
| I434509 | 2019 | Ford | F150 Pickup | 1FTEW1E44KFA44167 | TBA | NPWRC | GGEMNN0000 | 8711 37th St SE, Jamestown, ND | |||||
| I434681 | 2020 | Chevrolet | 1500 Pickup | 1GCUYAEF6LZ169632 | TBA | NPWRC | GGEMNN0000 | 8711 37th St SE, Jamestown, ND | |||||
| G9028038 | 2014 | SEAARK Boat 18' | RST 180CC | SOM40115D616 | TBA | NPWRC | GGEMNN0000 | 8711 37th St SE, Jamestown, ND | |||||
| G9025269 | 2012 | ZODIAC BOAT | PRO 500 | US-XDCP5018J314 | TBA | NPWRC | GGEMNN0000 | 8711 37th St SE, Jamestown, ND | |||||
| G1004348 | 2006 | BOSTON WHALER | 17 UTILITY BASE | HIN-WCG00273D707 | TBA | NPWRC | GGEMNN0000 | 8711 37th St SE, Jamestown, ND | |||||
| Vehicle | 2023 | Ford | F250 | 1FT7W2BA2PEC79396 | TBA | UMid | GGEMNK | Grand Rapids, 55744 | |||||
| Vehicle | 2024 | Ford | F250 | 1FT7W2BT9RED58603 | TBA | UMid | GGEMNK | Grand Rapids, 55744 | |||||
| Vehicle | 2023 | Ford | F250 | 1FTBR2Y8XPKA08299 | TBA | UMid | GGEMNK | Lansing, MI 48911 | |||||
| Vehicle | 2023 | Nissan | Titan | 1N6AA1EC5PN115715 | TBA | UMid | GGEMNK | Mounds View, MN 55112 | |||||
| Vehicle | 2019 | Ford | F250 | 1FD7X2B67KEC15867 | TBA | UMid | GGEMNK | Mounds View, MN 55112 | |||||
| Vehicle | 2021 | Chevrolet | Equinox | 2GNAXSEV1M6162661 | TBA | UMid | GGEMNK | Lansing, MI 48911 | |||||
| Vehicle | 2019 | Ford | F350 | 1FT8X3BT1KED55868 | TBA | UMid | GGEMNK | Mounds View, MN 55112 | |||||
| Vehicle | 2023 | Ford | Ford Explorer (green) | 1FMSK8BB9PGB39962 | TBA | UMid | GGEMNK | Madison, WI 53726 | |||||
| Vehicle | 2023 | Ford | Ford Escape (blue) | 1FMCU0GN2PUA32790 | TBA | UMid | GGEMNK | Madison, WI 53726 | |||||
| Vehicle | 2023 | Ford | F-150 | 1FTEW1EP3PKE67346 | TBA | UMid | GGEMNK | Madison, WI 53726 | |||||
| Vehicle | 2016 | Ford | F-150 | 1GDP7D1E3JV508541 | TBA | UMid | GGEMNK | Mounds View, MN 55112 | |||||
| Vehicle | 2018 | Chevrolet | 3500 | 1GB4KYCG2JF286679 | TBA | UMid | GGEMNK | Grand Rapids, 55744 | |||||
| Vehicle | 2018 | Chevrolet | Silverado 2500HD | 1GC1KUEG0JF265396 | TBA | UMid | GGEMNK | Grand Rapids, 55744 | |||||
| Vehicle | 2020 | Chevrolet | Silverado | 1GCRYAEF7MZ202905 | TBA | UMid | GGEMNK | Mounds View, MN 55112 | |||||
| Vehicle | 2021 | Chevrolet | Equinox | 2GNAXSEV4M6162704 | TBA | UMid | GGEMNK | Mounds View, MN 55112 | |||||
| Vehicle | 2012 | Ford | F350 | 1FT8W3BT6CEA42934 | TBA | UMid | GGEMNK | Mounds View, MN 55112 | |||||
| Vehicle | 2021 | Ford | Transit 150 | 1FTYE1CG5MKA81204 | TBA | UMid | GGEMNK | Mounds View, MN 55112 | |||||
| Vessel | 2009 | Hewes Marine | 200 PROV Sportsman | HEW 568081910 | TBA | UMid | GGEMNK | Lansing, MI | |||||
| Vessel | 2012 | Crestliner | Fishawk | CRC52259E212 | TBA | UMid | GGEMNK | Grand Rapids, MN | |||||
| Vessel | 2015 | Kann Marine | 22X72 V8 Kann Boat | KMQ2256F015 | TBA | UMid | GGEMNK | Mounds View, MN | |||||
| Vessel | 2006 | Polar Kraft | Polar Kraft | PLR4536D606 | TBA | UMid | GGEMNK | Grayling, MI | |||||
| Vessel | 2015 | Tracker | Jon Boat | BUJ109751415 | TBA | UMid | GGEMNK | Grand Rapids,55744 | |||||
| Vessel | 2012 | Hewes Marine | 200 PRO V | HEW63937E212 | TBA | UMid | GGEMNK | Madison, WI | |||||
| Vessel | 1998 | Kann Marine | Runabout | KMQ018225A898 | TBA | UMid | GGEMNK | Mounds View, MN | |||||
| Vessel | 2005 | Spirit | Swift River Boat | SMX00368C101 | TBA | UMid | GGEMNK | Mounds View, MN | |||||
| G63-0649Y | 2021 | Dodge | Ram 3500 | 3C7WR3GJ3MG687754 | TBA | WYMT | GGEMRS | Helena, MT | |||||
| G63-2563X | 2020 | Ford | F350 | 1FD8W3B63LEE23212 | TBA | WYMT | GGEMRS | Billings, MT | |||||
| G63-2565X | 2020 | Ford | F350 | 1FD8X3B60LEE23262 | TBA | WYMT | GGEMRS | Billings, MT | |||||
| G63-A1136 | 2023 | Ford | F350 | 1FD8W3B63NEE51014 | TBA | WYMT | GGEMRS | Billings, MT | |||||
| I-430738 | 2005 | Ford | F350 | 1FTWX33Y65EB87554 | TBA | WYMT | GGEMRS | Helena, MT | |||||
| I-435441 | 2024 | Chevrolet | 1500 | 1GCRDAEDXRZ206125 | TBA | WYMT | GGEMRS | Billings, MT | |||||
| I-435602 | 2024 | Chrysler | Pacifica | 2C4RC1BG2RR200864 | TBA | UMESC | GGEMNB0000 | La Crosse, WI | |||||
| I-435601 | 2024 | Ram | 3500 ST 4x4 | 3C63R3GJ2RG344707 | TBA | UMESC | GGEMNB0000 | La Crosse, WI | |||||
| I-434662 | 2020 | Dodge | Durango | 1C4RDJAGXLC192365 | TBA | UMESC | GGEMNB0000 | La Crosse, WI | |||||
| Vehicle | 2019 | Dodge | Durango | 1C4RDJAG0KC827284 | TBA | NE WSC | GGENLG | Augusta, ME 04330 | |||||
| Vehicle | 2019 | Ford | F-250 | 1FT7W2B64KEF8476 | TBA | NE WSC | GGENLG | Augusta, ME 04330 | |||||
| Vehicle | 2015 | Chevy | Silverado | 1G2KUEG2FZ106664 | TBA | NE WSC | GGENLG | Augusta, ME 04330 | |||||
| Vehicle | 2011 | Ford | F-350 | 1FD8W3B68BEC97895 | TBA | NE WSC | GGENLG | Augusta, ME 04330 | |||||
| Trailer | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Trailer | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Trailer | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Trailer | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Boat | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Boat | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Boat | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Boat | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| Vehicle | TBA | TBA | TBA | TBA | TBA | TBA | TBA | TBA | |||||
| 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 .