Attachment J - Dealer Layout Template.xlsx
XLSX spreadsheet 103 KB Posted
- Attached to
- 2027 GSA Fleet Vehicle Solutions Program (GFVSP)
- Solicitation number
- 47QMCA26R0038
- Issued by
-
GSA Federal Acquisition Service
About this file
This is a dealer layout template and instruction document for the GSA Fleet Vehicle Solutions Program (GFVSP). The document provides guidance for offerors to submit a list of participating courtesy dealerships that will be used for customer vehicle deliveries under this GSA indefinite-delivery/indefinite-quantity (IDIQ) contract vehicle. Offerors must deliver vehicles to dealerships located within the vicinity of the ordering agency, with the courtesy dealership list subsequently provided to ordering agencies for their reference. If an ordering agency does not select a specific dealership, the vendor will select one based on the zip code of the customer's delivery address.
The template specifies required data fields for the dealer spreadsheet submission, including dealer code, dealer name, street address, city, state, country, zip code, telephone, fax number (optional), and zone designation. Additional fields in the expanded template include location type, street line 2, country code, email, brand make, and indicators for EV acceptance and government delivery capability. All entries must be formatted in an Excel spreadsheet according to the prescribed column layout, with mandatory fields including dealer name, location type, street address, city, state, country, and zip code. The document includes example entries demonstrating proper formatting for dealerships in Alaska and Alabama, and notes that the ESRI_MAPINFO_SHEET section is for Esri use only and should not be edited by offerors.
View the file
Other files
Show all 45
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
Dealer Layout Instructions Under the GSA Fleet Vehicle Solutions Program, standard delivery is to a dealership located within the vicinity of the ordering agency. Offerors should provide a list of participating courtesy dealerships that will be used for customer deliveries. The courtesy dealership list will be provided to the ordering agencies. If the ordering agency does not select a specific dealership for courtesy delivery, the vendor will select a dealership based on the zip code in the customer's delivery address. The courtesy dealership listing must be provided in an excel spreadsheet using the following layout.
| DEALER FILE | |||
| COLUMN | DESCRIPTION | LENGTH | Notes |
| A | Group_DUNS | 10 | Leave Blank |
| B | Dealer_Code | 12 | Dealer code or dealer number |
| C | Dealer_Name | 60 | Name of Dealership |
| D | Street | 60 | |
| E | City | 80 | |
| F | State | 2 | |
| G | Country | 30 | |
| H | ZipCode | 5 | |
| I | Telephone | 10 | |
| J | FaxNo | 10 | Optional |
| K | Zone | 5 | Optional |
| Example | ||||||||||
| Group_DUNS | Dealer_Code | Dealer_Name | Street | City | State | Country | ZipCode | Telephone | FaxNo | Zone |
| 57467 | ABC Dealership | 123 FIFTH AVE | ANCHORAGE | AK | USA | 99501 | 9075551212 | 9075551234 | 12 | |
| 12114 | CDF Dealership | 8602 MAIN ST | JUNEAU | AK | USA | 99801 | 9075551213 | 9075552345 | 13 | |
| 38412 | John Doe Dealership | 1857 ELM RD | BIRMINGHAM | AL | USA | 35235 | 2055551214 | 2055553456 | 47 | |
| 18435 | Jane Doe Dealership | 1234 HWY US 31 S | DECATUR | AL | USA | 35603 | 2055551215 | 2055554567 | 8 |
Dealer Layout Template
| Dealer Code | Dealer Name | Location Type | Street | Street Line 2 | City | State | Country | Zip Code | Country Code | Telephone | Brand Make | Accept EV | Accept Government Delivery | |
| Dealer's make code (required) | Name of the associated location (required) | Delivery Point (required) | Street address (required) | Street address line 2 | City name (required) | State code (e.g. VA, required) | Country code (e.g. USA, required) | Zip code (required) | Country code for the phone number | Phone number for the associatde lcoation | Email for the associatde lcoation | Make (required) | Y/N (required) | Y/N (required) |
ESRI_MAPINFO_SHEET
DO NOT EDIT
For Esri use only
File details come from the government source that posted it. Updated .