MAS - Aweigh All Boats LLC - GS07F088GA

PDF 202 KB

Attached to
Federal Supply Schedule GS07F088GA
Contract number
GS07F088GA
Issued by

About this file

This Federal Supply Schedule price list provides pricing and terms for a contractor supplying boats and related products and services. The contractor, Aweigh All Boats LLC, holds contract GS-07F-088GA awarded in March 2017 under GSA's Multiple Award Schedule with special item numbers covering boats, parts and accessories, protective apparel, and order level materials. The contractor offers boats and accessories with pricing shown on its attached GSA pricelist and provides standard commercial warranties. Delivery is within seven days of order receipt to domestic destinations. The maximum order value per schedule is $250,000.

Aweigh All Boats LLC Pricelist and/or Vendor Terms and Conditions for GS07F088GA, a Federal Supply Schedule awarded to Aweigh All Boats LLC, under Law Enforcement & Security Services (FSS-84)

View the file

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

READ ME

Glossary:
PRODUCTS Tab
GroupingColumnDescriptionPublished on AdvantageRequired for Catalog Action Type:

A: Add B: Baseline C: Change D: Delete

T: TPRSource
Base Product or Accessoryitem_typeAll products must be designated as an "Accessory" (A) or "Base" (B) product. Base products are standalone products listed to GSA Advantage! for sale. Accessories are related to a Base product and are available for purchase with the Base product from the Base product's Advantage page. Example: A vendor lists a Tractor as "B" Base Product and an extra set of tires as "A" Accessory to the tractor. (Purchasing an Accessory will always increase the price in cart on Advantage.) Vendors should indicate "A" for any products that are Accessories and "B" for any products that are Base items. Product Options can be applied to both item types.NoA B C D TProduct File
Manufacturer InformationmanufacturerManufacturer name is a required field for all products. It must be provided in every sheet referencing the same product, and must be 40 characters or fewer to publish to GSA Advantage!YesA B C D TProduct File
Manufacturer Informationmanufacturer_part_numberManufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product, and must be 40 characters or fewer to publish to GSA Advantage.YesA B C D TProduct File
Vendor Part Numbervendor_part_numberVendor part number, for use by the seller to track part numbers.YesNoProduct File
Special Item NumbersinSIN under which the product is being offered.YesA B CProduct File
Product Informationitem_nameProduct NameYesA B CProduct File
Product Informationitem_descriptionA description of the product. The description can be up to 1,000 characters long.YesA B CProduct File
Product Informationrecycled_content_percentRecycled and/or post consumer material content percentage. (Optional, but required for copy paper offering) Express this value in decimal format only. (i.e. 3%, enter 0.03; 50%, enter 0.5)NoNoProduct File
Unit of measureuomUnit of measure / issue of the product.YesA B CProduct File
Quantity Per Packquantity_per_packQuantity Per Pack, if the product is packed in quantities. This is the number of items per pack and must be a numeric value. (ex., If the product is sold in 6 to a box, enter “6”)
NOTE: If this field is populated then quantity_uom must also be populated.YesNoProduct File
Quantity Per Packquantity_unit_uomQuantity Unit Of Measurement, if the product is sold in set increments, use this section to identify the unit of measurement.
(ex. If your product is only sold in sets of 6, list the UOM as "ST", quantity_per_pack as "6" and quantity_unit_uom as "EA". It will be displayed on GSA Advantage as "ST 6 EA".)YesNoProduct File
Commercial Price /
Manufacturer's Suggested Retail Pricecommercial_priceCommercial Price or Manufacturer's Suggested Retail PriceNoA B CProduct File
Commercial Price /
Manufacturer's Suggested Retail Pricemfc_disc_off_commercial_pricemfc_disc_off_commercial_price is the percent discount relationship between the mfc_price and the commercial_price provided.N/AN/ACompliance & Pricing Report
Commercial Price /
Manufacturer's Suggested Retail Pricegovt_disc_off_commercial_pricegovt_disc_off_commercial_price is the percent discount relationship between the govt_price_no_fee and the commercial_price provided.N/AN/ACompliance & Pricing Report
Most Favored Customermfc_nameOnly applies for non-TDR contracts. Most Favored Customer refers to the customer or category of customer that receives the most favorable pricing. The name of the customer of the category of customers goes in this column.NoConditional (non-TDR)Product File
Most Favored Customermfc_priceOnly applies for non-TDR contracts. This is the price offered to the Most Favored Customer with the MFC discount.NoConditional (non-TDR)Product File
Price Proposalgovt_price_no_feeThis is the price offered to the government that does not include the 0.75% Industrial Funding Fee (IFF) and the 1.25% Contract Access Fee (CAF), if applicable.

First-time users submitting a Baseline action can use the following formula to calculate this field based off of govt_price_with_fee. Insert the formula in cell O3 in the PRODUCTS tab and drag down for all products:

=IF(E3="339940OS4",P3*0.98,P3*0.9925)NoA B CProduct File
Price Proposalgovt_price_with_feeThis is the price offered to the government that includes the 0.75% Industrial Funding Fee (IFF) and, if applicable, 1.25% Contract Access Fee (CAF).

In cell P3 of the Products Tab, paste the following formula and drag down to calculate:

=IF(E3="339940OS4",O3/.98,O3/0.9925)

Note: Proposed prices must be inclusive of all costs associated with acceptance of the Governmentwide commercial purchase card (e.g., payment processing fees). Schedule contractors may not impose a surcharge at the order level for payment by Governmentwide commercial purchase card. For additional information, see SCP-FSS-001 Instructions Applicable to All Offerors, and GSA SmartPay Smart Bulletin No. 039.YesA B C TProduct File
Dealer Markupdealer_costDealer cost for the product.
NOTE: Markup based pricing is allowed under specific SINs and should be verified.NoConditional (markup based contracts)Product File
Dealer Markupmfc_markup_percentageOnly applies if proposed pricing is markup based. When compared to the dealer cost, this is the markup (in percentage points) given to the Most Favored Customer.NoConditional (markup based contracts)Product File
Dealer Markupgovt_markup_percentageOnly applies if proposed pricing is markup based. This is the markup given to GSA from the dealer cost that does not include the 0.75% Industrial Funding Fee (IFF).NoConditional (markup based contracts)Product File
Country of Origincountry_of_originProvide the Country of Origin(COO) for each product being proposed. If a product is sourced from multiple COO, list additional country codes, separating each with a comma (,). Please note, only the first COO will be displayed on GSA Advantage.YesA B CProduct File
Delivery Informationdelivery_daysDelivery lead time-Provide a numerical value here for the number of days for product delivery.YesA B CProduct File
Delivery Informationlead_time_codeDelivery lead time codes-

AE: From date of PO receipt to shipment AF: From date of PO receipt to delivery AX: From Date of Award to Date of Completion (services only)

AY: From Date of Award to Date of DeliveryYesA B CProduct File
Delivery Informationfob_usFreight on Board to the 48 Contiguous US States and DC (CONUS): D-Destination or O-Origin. At minimum, delivery to CONUS locations is required.YesA B CProduct File
Delivery Informationfob_akFreight on Board-Alaska: D-Destination,O-Origin or N-No Delivery.YesA B CProduct File
Delivery Informationfob_hiFreight on Board-Hawaii: D-Destination,O-Origin or N-No Delivery.YesA B CProduct File
Delivery Informationfob_prFreight on Board-Puerto Rico: D-Destination,O-Origin or N-No Delivery.YesA B CProduct File
National Stock NumbernsnNational Stock NumberYesNoProduct File
UPCupcUniversal Product Code. If UPCs are utilized, this code must be 8-14 digits in length.YesConditionalProduct File
UNSPSCunspscUnited Nations Standard Products and Services Code. This code must be 8 digits in length and cannot begin with a zero (0).YesNoProduct File
Temporary Price Reduction (TPR)sale_price_with_feeONLY provide information in this section for a Temporary Price Reduction catalog action. Information submitted in this section will be ignored for all other types of catalog actions (i.e. Add, Change, etc) Provide the sale price with the 0.75% Industrial Funding Fee (IFF) and/or 1.25% Contract Access Fee (CAF).YesTProduct File
Temporary Price Reduction (TPR)start_dateIf providing temporary price reductions, indicate the start date for the temporary pricingYesTProduct File
Temporary Price Reduction (TPR)stop_dateIf providing temporary price reductions, indicate the stop date for the temporary pricingYesTProduct File
Photo File Referencesdefault_photoProvide the file name of the image uploaded. This photo will be the default photo on GSA Advantage. For multiple photos, identify those file names under photo_2, photo_3, and photo_4. Up to 4 photos are allowed per product. Supported photo formats: .jpeg | .jpg | .gif and the file name can only contain 1 dot (.).
Required for certain SINs. Visit the following website to determine if the SIN requires this information: https://vsc.gsa.gov/vsc/app-lookup-tables#sinMolPhotoUpcYesConditionalProduct File
Photo File Referencesphoto_2Provide the file name of the image uploadedYesConditionalProduct File
Photo File Referencesphoto_3Provide the file name of the image uploadedYesConditionalProduct File
Photo File Referencesphoto_4Provide the file name of the image uploadedYesConditionalProduct File
Photo File Referencesproduct_urlProvide the web address where additional product information can be found.YesNoProduct File
Warranty Durationwarranty_periodDuration of Warranty.YesNoProduct File
Warranty Durationwarranty_unit_of_timeUnit of time of the warranty durationYesNoProduct File
Product DimensionslengthPhysical Length ( Must be provided when another Shipping Container Dimension is provided.)YesConditionalProduct File
Product DimensionswidthPhysical Width ( Must be provided when another Shipping Container Dimension is provided.)YesConditionalProduct File
Product DimensionsheightPhysical Height ( Must be provided when another Shipping Container Dimension is provided.)YesConditionalProduct File
Product Dimensionsphysical_uomUnit of measure for shipping package (feet, inches, cm, etc.) ( Must be provided when another Shipping Container Dimension is provided.)YesConditionalProduct File
Product Dimensionsweight_lbsWeight in pounds of product's shipping weight ( Must be provided when another Shipping Container Dimension is provided.)NoConditionalProduct File
Product Information / Categorizationproduct_info_codeProduct Information Code: List the code(s) that is applicable to this product. If multiple codes apply to this product, separate each code with a comma ",".YesNoProduct File
Product Information / Categorizationurl_508URL for 508 informationYesNoProduct File
Product Information / CategorizationhazmatProduct hazmat information. This a United Nations Identification number (UNID). It will start with UN, NA or MSDS.YesNoProduct File
Summaryflag_summaryflag_summary is a list of the compliance and pricing flags at the line item level.N/AN/ACompliance & Pricing Report
Summaryhitshits are the number of offerings found on all contracts at the line item level.N/AN/ACompliance & Pricing Report
Summaryself_hitsself_hits are the number of offerings found for same vendor at the line item level.N/AN/ACompliance & Pricing Report
Summaryvendor_commentsvendor_comments are any input the vendor would like to share with their CO/CS.N/AN/ACompliance & Pricing Report
Compliance Considerationsis_authorized_vendoris_authorized_vendor provides insight into whether or not the manufacturer or wholesale distributor listed the vendor as an authorized supplier in GSA's Verified Products Portal (VPP)

- Unauthorized - The contractor is not on the list of authorized vendors supplied by the manufacturer.

- Authorized - The contractor appears on the list of authorized vendors supplied by the manufacturer.

- LoS Required - The Verified Product Portal does not have authorization data for the item; therefore, a letter of supply is required.N/AN/ACompliance & Pricing Report
Compliance Considerationsis_prohibitedis_prohibited provides insight into any regulatory compliance concerns that indicate whether an item can be sold or not.N/AN/ACompliance & Pricing Report
Compliance Considerationsprohibition_commentprohibition_comment provides information on why an item is flagged as prohibited.N/AN/ACompliance & Pricing Report
Compliance Considerationsetsets is an item that is deemed Essentially the Same as an Ability One Item.N/AN/ACompliance & Pricing Report
Country of Origininferred_country_origininferred_country_origin is the Country of Origin listed by the majority of vendors. (A Country of Origin Inference of "XX" means no consensus is found, but the item is likely foreign-made.)N/AN/ACompliance & Pricing Report
Country of Originis_mia_riskis_mia_risk is when the inferred_country_origin is not "US", while the provided country of origin was "US".N/AN/ACompliance & Pricing Report
Country of Originis_taa_riskis_taa_risk is when the inferred_country_origin is from a non-TAA compliant countryN/AN/ACompliance & Pricing Report
Pricing Market Researchmarket_thresholdmarket_threshold is the ceiling range established by the horizontal pricing model. This figure is meant to be a guide, price fairness is determined by the CO/CS.N/AN/ACompliance & Pricing Report
Pricing Market Researchmarket_threshold_statusmarket_threshold_status is the line item level status, these statuses include the following:

- Within Market Threshold: the price falls below the market threshold price

- Exceeds Market Threshold: the price exceeds the market threshold price

- No Market Research Found: XSB was unable to find the product at the time of the previous refresh, or there were not at least 3 sources of supply to generate statistically valid results

- Self Hits Only: Perform Manual Market Research: the only instances of the product found within the government marketplace are the vendor’s own product. Manual market research is requiredN/AN/ACompliance & Pricing Report
Pricing Market Researchgovernment_min_pricegovernment_min_price is the lowest price found across the government catalogs.N/AN/ACompliance & Pricing Report
Pricing Market Researchproposed_price_relative_to_government_minproposed_price_relative_to_government_min is the govt_price_with_fee as a percentage of government_minimum_price (+/-).N/AN/ACompliance & Pricing Report
Pricing Market Researchgovernment_min_price_suppliergovernment_min_price_supplier is the vendor offering the product at the government_minimum_price.N/AN/ACompliance & Pricing Report
Pricing Market Researchgovernment_median_pricegovernment_median_price is the median price found across government contracts, excluding low outliers.N/AN/ACompliance & Pricing Report
Pricing Market Researchgovernment_median_price_suppliergovernment_median_price_supplier is the vendor offering the product at the government_median_price.N/AN/ACompliance & Pricing Report
Pricing Market Researchgovernment_average_pricegovernment_average_price is the average price found across the government catalogs.N/AN/ACompliance & Pricing Report
Pricing Market Researchgovernment_average_price_standard_deviationgovernment_average_price_standard_deviation is the pricing standard deviation of the government catalogs.N/AN/ACompliance & Pricing Report
Pricing Market Researchgovernment_max_pricegovernment_max_price is the maximum price found across the government catalogs.N/AN/ACompliance & Pricing Report
Pricing Market Researchcommercial_min_pricecommercial_min_price is the lowest price found across the commercial catalogs.N/AN/ACompliance & Pricing Report
Pricing Market Researchproposed_price_relative_to_commercial_minproposed_price_relative_to_commercial_min is the govt_price_with_fee as a percentage of commercial_minimum_price (+/-).N/AN/ACompliance & Pricing Report
Pricing Market Researchcommercial_min_price_suppliercommercial_min_price_supplier is the commercial supplier offering the product at the commercial_minimum_price.N/AN/ACompliance & Pricing Report
Pricing Market Researchcommercial_median_pricecommercial_median_price is the median price found across the commercial catalogs.N/AN/ACompliance & Pricing Report
Pricing Market Researchcommercial_median_price_suppliercommercial_median_price_supplier is the commercial supplier offering the product at the commercial_median_price.N/AN/ACompliance & Pricing Report
Pricing Market Researchgovernment_transaction_min_pricegovernment_transaction_min_price is the minimum transaction price found across the GSAAdvantage! and FedMall catalogs.N/AN/ACompliance & Pricing Report
Pricing Market Researchgovernment_transaction_average_pricegovernment_transaction_average_price is the average transaction price found across the GSAAdvantage! and FedMall catalogs.N/AN/ACompliance & Pricing Report
Pricing Market Researchgovernment_transaction_median_pricegovernment_transaction_median_price is the median transaction price found across the GSAAdvantage! and FedMall catalogs.N/AN/ACompliance & Pricing Report
Pricing Market Researchgovernment_transaction_max_pricegovernment_transaction_max_price is the maximum transaction price found across the GSAAdvantage! and FedMall catalogs.N/AN/ACompliance & Pricing Report
Pricing Market Researchtdr_min_pricetdr_min_price is the lowest price found across Transactional Data Reporting (TDR) catalogs.N/AN/ACompliance & Pricing Report
Pricing Market Researchtdr_median_pricetdr_median_price is the median price across Transactional Data Reporting (TDR) catalogs.N/AN/ACompliance & Pricing Report
Pricing Market Researchtdr_max_pricetdr_max_price is the maximum price across Transactional Data Reporting (TDR) catalogs.N/AN/ACompliance & Pricing Report
Pricing Market Researchsales_likelihoodsales_likelihood: based on GSAAdvantage! transaction price points, how likely is the product to sell at the proposed price.N/AN/ACompliance & Pricing Report
Pricing Market Researchannual_demand_quantityannual_demand_quantity is the sum of order quantities from the following sources on a rolling year frequency. The sources include GSAAdvantage transactions, FedMall transactions, DLA NSN procurement history, and TDR data.N/AN/ACompliance & Pricing Report
Pricing Market Researchdemand_weighted_index_scoredemand_weighted_index_score incorporates the total GSAAdvantage! sales for the given product. The sum of this index represents how much a buyer would spend to purchase the proposed products, relative to purchasing each product the Market Baseline Supplier, for a $100 order.N/AN/ACompliance & Pricing Report
Pricing Market Researchis_low_outlieris_low_outlier are any products where the govt_price_with_fee is at least 50% less than the goverment_median_price.N/AN/ACompliance & Pricing Report
Product Informationunique_item_identifierunique_item_identifier is XSB's unique identifier at the line item level.N/AN/ACompliance & Pricing Report
OPTIONS Tab
GroupingColumnDescriptionPublished on AdvantageRequiredSource
Manufacturer InformationmanufacturerProduct Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the PRODUCTS tab.YesNoProduct File
Manufacturer Informationmanufacturer_part_numberProduct Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the products sheet.YesNoProduct File
Options Informationoption_manufacturerOption Manufacturer name is a required field for all options..YesNoProduct File
Options Informationoption_part_numberOptions part number is a required field for all options. The option part number is provided to vendors on the Purchase Order.NoNoProduct File
Options InformationcategoryCategory of options. Options of the same kind should have the same Category Name. Options with the same Category Name will be in the same drop down list on Advantage, with the ability to select 1 option from that category. Provide the category name that will appear on Advantage. “Options” may be used as a generic name.YesNoProduct File
Options InformationnameOption nameYesNoProduct File
Options Informationbase_item_relationshipBase Item Relationship. Identify how the selection of this option will impact the order.

I: Included - Option is included; No cost is associated with this option. (Price must be 0.) Only one (1) included 'I' option is allowed per category.

A: Added - Option can be added for an additional cost. (Price must be zero or greater.)

S: Substituted - If another option is already included (I) for the category, this option can substitute it. The price of a substituted option can be negative, zero, or positive. Enter a negative price where the substituted option is less than the included option, and a positive price if the substituted option costs more than the included option. A price of zero (0) indicates that the substituted item has the same cost as the included item. A price of zero coupled with an option name of 'None' can be used to allow a buyer to refuse the included item.YesNoProduct File
Options InformationquantityQuantity of the option (i.e. 6 EA)YesNoProduct File
Options Informationunit_of_measureUnit of measure / issue of the product's option.YesNoProduct File
Options Priceprice_with_feeThis is the cost associated with this option. Must be zero (0) if the option is included (I). Must be zero or greater if the option is added (A). Can be negative, zero, or positive if the option is a substitute (S).YesNoProduct File
PRODXACC Tab
GroupingColumnDescriptionPublished on AdvantageRequiredSource
Product Manufacturer InformationmanufacturerProduct Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product. This must reference a product already in the PRODUCTS tab with an item_type of “B” - Base.YesNoProduct File
Product Manufacturer Informationmanufacturer_part_numberProduct Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. This must reference a product already in the PRODUCTS tab with an item_type of “B” - Base.YesNoProduct File
Accessory Manufacturer Informationaccessory_manufacturerAccessory manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product. This must reference a product listed as item_type “A” - accessory in the PRODUCTS tab.YesNoProduct File
Accessory Manufacturer Informationaccessory_manufacturer_part_numberAccessory Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. This must reference a product listed as item_type “A” - accessory in the PRODUCTS tab.YesNoProduct File
QTYVOL Tab
GroupingColumnDescriptionPublished on AdvantageRequiredSource
Manufacturer InformationmanufacturerProduct Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the PRODUCTS tab.YesNoProduct File
Manufacturer Informationmanufacturer_part_numberProduct Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product. This should reference a product already in the PRODUCTS tab.YesNoProduct File
Volume or Quantitydiscount _typeQuantity or Volume Discount: Choose "Quantity" when the discount is based on the number of units required to be purchased to receive this discount or "Volume" when the discount is based on the price range of the purchase to receive the discount.YesNoProduct File
Price Bucketsbucket_numberPrice Buckets must be numbered for quantity or volume price breaks. Up to 7 buckets can be proposed and must be sequential for each bucket. (i.e. A product with 3 price buckets will have bucket_number 1, 2, 3. It cannot be 1,2,4.)YesNoProduct File
Discount Rangestart_of_rangeStart of Range for Bucket. Must be a whole number. This must follow the end_of_range from the prior price bucket. For Quantity discounts, bucket_number of 1 must also begin with 1.YesNoProduct File
Discount Rangeend_of_rangeEnd of Range for Bucket. Must be a whole number. The end of range of the last discount bucket must be 99999999.YesNoProduct File
Discount Rangediscounted_priceDiscounted price provided for Bucket. This is the tier-discounted price offered to the government that includes the Industrial Funding Fee (IFF) and, if applicable, Contract Access Fee (CAF). Either a discounted_price or percentage_discount may be provided, but not both for the same product. For Quantity discounts, the discount_price for bucket_number 1 must be equal to the govt_price_with_fee of the base item on the PRODUCTS tab.YesNoProduct File
Discount Rangepercent_discountPercent Discount provided for bucket. Express this value in decimal format only. (i.e. 3%, enter 0.03; 50%, enter 0.5) Either a Discounted Price or Percentage Discount may be provided, but not both for the same product.YesNoProduct File

&"Calibri"&10&K000000 Sensitivity Label: CGIF Internal&1#_x000D_

Overview (Product File - Version 1.3-20240712)

The Product File collects catalog information for products intended for sale on GSA Advantage! See the glossary below for full details on the information collected and which fields will be published on GSA Advantage!

This file contains sample catalog data on every tab. Remove this data before uploading the file.

REQUIRED:

•PRODUCTS: This tab is required for every action containing products published to GSA Advantage! Includes product information such as name, part number, price, unit of measure, UPC, and images.

AS APPLICABLE: The below tabs should be used as applicable to your product configurations.

•OPTIONS: Product options can be applied to a base item or an accessory. Options have their own part numbers, but cannot be sold independently of a base item or accessory. Options must be applied at the time of purchase, and may or may not have an associated price. An Option can reduce, increase, or have no impact on cost. Example: A desk chair is listed with a standard mid grade fabric as part of the base item; there may be options to substitute leather which would increase the overall price, or a lower grade fabric which would reduce the overall price of the chair.

•PRODXACC: This tab is required if any product on the PRODUCTS tab is coded as “item_type: A” (Accessory). An accessory is a standalone item, also referred to as a Related Product, that can be sold with a base item and will have an associated price. ** Example: Listing a monitor arm (as an accessory) with a desk chair (as a base item).

•QTYVOL: A quantity discount is based on the number of units being ordered, and a volume discount is based on the total price of the product being ordered. This tab facilitates the defining of the "price buckets'' for each product. Each bucket has a manufacturer name and part number, start/end range, and a price.

FOR REFERENCE:

Reference: This tab contains allowable codes for certain fields such as Country of Origin or Unit of Measure Help Text: Column titles have additional help text anywhere there is a red triangle. Hover the pointer over the cell to see this additional information.

Overview (Product File - Version 1.3-20250128)

The Product File collects catalog information for products intended for sale on GSA Advantage! See the glossary below for full details on the information collected and which fields will be published on GSA Advantage!

This file contains sample catalog data on every tab. Remove this data before uploading the file.

REQUIRED:

•PRODUCTS: This tab is required for every action containing products published to GSA Advantage! Includes product information such as name, part number, price, unit of measure, UPC, and images.

AS APPLICABLE: The below tabs should be used as applicable to your product configurations.

•OPTIONS: Product options can be applied to a base item or an accessory. Options have their own part numbers, but cannot be sold independently of a base item or accessory. Options must be applied at the time of purchase, and may or may not have an associated price. An Option can reduce, increase, or have no impact on cost. Example: A desk chair is listed with a standard mid grade fabric as part of the base item; there may be options to substitute leather which would increase the overall price, or a lower grade fabric which would reduce the overall price of the chair.

NOTE: For highly configurable products with a large number of options (i.e. 2,500+) and/or option categories (i.e. 50+), it is recommended to publish the most popular configurations in the Product File for publishing to GSA Advantage and maintain the pricing for other product options in the Products Price Proposal Template and publish those items to the text file. Base items or Accessories included in the PRODUCTS tab are prohibited from being duplicated and published to the text file posted on GSA eLibrary.

•PRODXACC: This tab is required if any product on the PRODUCTS tab is coded as “item_type: A” (Accessory). An accessory is a standalone product, and can be purchased alone or with a base product. Accessories have their own unique product information, and the base/accessory relationship is established by the offeror linking an accessory with its associated base item(s). Example: Listing a monitor arm (as an accessory) with a desk (as a base item).

•QTYVOL: A quantity discount is based on the number of units being ordered, and a volume discount is based on the total price of the product being ordered. This tab facilitates the defining of the "price buckets'' for each product. Each bucket has a manufacturer name and part number, start/end range, and a price.

FOR REFERENCE:

Reference: This tab contains allowable codes for certain fields such as Country of Origin or Unit of Measure Help Text: Column titles have additional help text anywhere there is a red triangle. Hover the pointer over the cell to see this additional information.

PRODUCTS

Base Product or AccessoryManufacturer InformationVendor Part NumberSpecial Item NumberProduct InformationUnit of MeasureQuantity Per PackCommercial Price /
Manufacturer's Suggested Retail PriceMost Favored CustomerPrice ProposalCountry of OriginDelivery InformationNational Stock NumberUPCUnited Nations Standard Products and Services CodeTemporary Price Reduction (TPR)Photo File ReferencesWarranty DurationProduct DimensionsProduct Information / CategorizationDealer Markup
item_type
MankwongYau: (REQUIRED) Identify the product as an accessory (A) or base product (B). An accessory is a standalone product that can be purchased alone or with the base product. Accessories will be associated with their base product on GSA Advantage! If any product is coded as an accessory, the PRODXACC tab is required. Example: an extra set of tires (accessory) can be purchased with a tractor (base).If your catalog contains a combination of products with and without accessories, enter "B" for all products that are standalone.manufacturer

MankwongYau: (REQUIRED) Manufacturer name is a required field for all products. It must be provided in every sheet referencing the same product.

manufacturer_part_number
MankwongYau: (REQUIRED) Manufacturer part number is a required field for all products. It must be provided in every sheet referencing the same product.vendor_part_number
MankwongYau: Vendor part number, for use by the seller to track part numbers. (Optional)sin
MankwongYau: (REQUIRED)item_name

MankwongYau: (REQUIRED)

item_description
MankwongYau: (REQUIRED) A description of the product. The description can be up to 1,000 characters long.recycled_content_percent
MankwongYau: Recycled and/or post consumer material content percentage. (Optional, but required for copy paper offering) Express this value in decimal format only. (i.e 3%, enter 0.03; 50%, enter 0.5)uom
MankwongYau: (REQUIRED)quantity_per_pack
MankwongYau: Quantity Per Pack, if the product is packed in quantities. Enter numeric value here. If your productis sold in set increments, use this section to identfiy how many are included. (ex. If your product is only sold in box of 4, list the UOM as "BX", quantity_per_pack as "4" and quantity_unit_uom as "EA". It will be displayed on GSA Advantage as "BX 4 EA"). The quantity_unit_uom must also be provided when an entry is made here.quantity_unit_uom
MankwongYau: Quantity Per UOM is the unit of measure of the product that is packed in quantities. If your product is sold in box increments, use this section to identify how many are included. (ex. If your product is only sold in box of 4, list the UOM as "BX", quantity_per_pack as "4" and quantity_unit_uom as "EA". It will be displayed on GSA Advantage as "BX 4 EA".) The quantity_per_pack must also be provided when an entry is made here.commercial_price
MankwongYau: (REQUIRED) Commercial Price / Manufacturer's Suggested Retail Price. This information is not published on GSA Advantage.mfc_name
MankwongYau: Must be provided for non-TDR contracts. Most Favored Customer refers to the customer or category of customer that receives the most favorable pricing. The name of the customer of the category of customers goes in this column.mfc_price
MankwongYau: Must be provided for non-TDR contracts. This is the price offered to the Most Favored Customer with the MFC discount.govt_price_no_fee

MankwongYau: (REQUIRED) This is the price offered to the government that does not include the 0.75% Industrial Funding Fee (IFF) and, if applicable, 1.25% Contract Access Fee (CAF).

First-time users submitting a Baseline action can use the following formula to calculated this figure off of the govt_price_with_fee. Inserted the formula in cell O3 in the PRODUCTS tab and dragged down for all products:

=IF(E3="339940OS4",P3*0.98,P3*0.9925) govt_price_with_fee MankwongYau: (REQUIRED) This is the price offered to the government that includes the 0.75% Industrial Funding Fee (IFF) and, if applicable, 1.25% Contract Access Fee (CAF).

Example of Discount Based (IFF only):

MSRP = $100.00

GSA Discount (govt_price_no_fee): 10% Discount Price Offered to GSA (govt_price_no_fee): $100*(1-.10) = $90.00 Discount Price Offered to GSA (govt_price_with_fee): $90.00/0.9925 = $90.68

Example of Discount Based (IFF & CAF):

MSRP = $100.00

GSA Discount (govt_price_no_fee): 10% Discount Price Offered to GSA (govt_price_no_fee): $100*(1-.10) = $90.00 Discount Price Offered to GSA (govt_price_with_fee): $90.00/0.98 = $91.84

Example of Markup Based:

Dealer Cost: $80.00 Government Markup Percentage (govt_markup_percentage): 10% Markup Price Offered to GSA (govt_price_no_fee): $80*(1+.10) = $88.00

Markup Price Offered to GSA (govt_price_with_fee): $88.00/0.9925 = $88.66country_of_origin
MankwongYau: (REQUIRED) Provide the Country of Origin(COO) for each product being proposed. If your product are sourced from multiple COO, you list additional country codes, separating each with a comma (,). Please note, only the first COO will be displayed on GSA Advantage.delivery_days

MankwongYau: (REQUIRED) Delivery lead time-Provide a numerical value here for the number of days for product delivery.

lead_time_code MankwongYau: (REQUIRED) Lead Time Codes- AE: From date of PO receipt to shipment AF: From date of PO receipt to delivery AX: From Date of Award to Date of Completion (services only)

AY: From Date of Award to Date of Deliveryfob_us
MankwongYau: (REQUIRED) Freight on Board-48 Contiguous US States and DC (CONUS): D-Destination or O-Origin. At minimum, delivery to CONUS locations is required.fob_ak
MankwongYau: (REQUIRED) Freight on Board-Alaska: D-Destination, O-Origin, or N-No Delivery.fob_hi
MankwongYau: (REQUIRED) Freight on Board-Hawaii D-Destination, O-Origin, or N-No Delivery.fob_pr
MankwongYau: (REQUIRED) Freight on Board-Puerto Rico: D-Destination, O-Origin, or N-No Delivery.nsnupc
MankwongYau: Universal Product Code. This code must be 8-14 digits in length.unspsc
MankwongYau: UNSPSC must be 8 digits in length and cannot begin with a zero (0).sale_price_with_fee
MankwongYau: ONLY provide information in this section if you are performing a Temporary Price Reduction (TPR) catalog action. Information submitted in this section will be ignored for all other types of catalog actions (i.e. Add, Change, etc) Provide the sale price with the 0.75% Industrial Funding Fee (IFF) and/or 1.25% Contract Access Fee (CAF). This price must be less than the govt_price_with_fee. If you want to end an active TPR, only provide the item_type, manufacturer, and manfacturer_part_number, and leave the sale_price_with_fee, start_date and stop_date empty.start_date
MankwongYau: If providing temporary price reductions, indicate the start date for the temporary pricing.stop_date
MankwongYau: If providing temporary price reductions, indicate the stop date for the temporary pricing. This must be a date in the future and must be later than the start_date.default_photo

MankwongYau: Provide the file name of the image uploaded. This photo will be the default photo on GSA Advantage. If you have more than 1 photo, identify those file names under photo_2, photo_3, and photo_4. Up to 4 photos are allowed per product. Supported photo formats: .jpeg | .jpg | .gif and file names can only contain 1 dot (.).

Required for certain SINs. Visit the following website to determine if the SIN on your contract requires this information: https://vsc.gsa.gov/vsc/app-lookup-tables#sinMolPhotoUpc photo_2 photo_3 photo_4 product_url MankwongYau: Provide the web address where additional product information can be found.

warranty_period MankwongYau: Duration of Warranty. Must be included when warranty_unit_of_time is provided. Provide a numeric value in this column.

warranty_unit_of_time MankwongYau: Warranty unit of time:

DA: Calendar Days DW: Work Days MO: Months

WK: Weekslength
MankwongYau: Physical Length. Must be provided when another Shipping Container Dimension is provided.width
MankwongYau: Physical Width. Must be provided when another Shipping Container Dimension is provided.height
MankwongYau: Physical Height. Must be provided when another Shipping Container Dimension is provided.physical_uom
MankwongYau: Unit of measure for shipping package (feet, inches, cm, etc.) Must be provided when another Shipping Container Dimension is provided.weight_lbs
MankwongYau: Weight in pounds of product. Must be provided when another Shipping Container Dimension is provided.product_info_code
MankwongYau: Product Information Code: List the code(s) that is applicable to this product. If multiple codes apply to this product, separate each code with a comma ",".url_508
MankwongYau: URL for 508 information, as applicablehazmat
MankwongYau: Product hazmat information. This a United Nations Identification number (UNID). It will start with UN, NA or MSDS.dealer_cost
MankwongYau: Only applies if proposed pricing is markup based. This is allowed under specific SINs. Verify this is allowed for your offering. This is the dealer cost for the product.mfc_markup_percentage
MankwongYau: Only applies if proposed pricing is markup based. When compared to the dealer cost, this is the markup (in percentage points) given to the Most Favored Customer. Express this value in decimal format only with a maximum of 4 decimal points. (i.e 3.25%, enter 0.0325; 150%, enter 1.5)govt_markup_percentage

MankwongYau: Only applies if proposed pricing is markup based. This is the markup given to GSA from the dealer cost that does not include the 0.75% Industrial Funding Fee (IFF). Express this value in decimal format only with a maximum of 4 decimal points. (i.e 3.25%, enter 0.0325; 150%, enter 1.5)

BACR3970.33970.3334511FIREFLY PRO SOLAS STROBE LIGHTfirefly pro solas strobe lightEA71.28All Commercial Customers71.2866.3766.87US7AFDDDD3970.jpg
BACR3971.33971.3334511FIREFLY PRO SOLAS WATERBUG STROBEfirefly pro solas waterbug strobeEA80.58All Commercial Customers80.5866.0066.50US7AFDDDD3970.jpg
BICOMIC-M324G 21IC-M324G 21334511VHF INTEGRATED GPS BLACKVHF Integrated GPS BlackEA876.01All Commercial Customers876.01389.99392.94US7AFDDDD324.jpg
BICOMIC-M324G 22IC-M324G 22334511VHF INTEGRATED GPS WHITEVHF Integrated GPS WhiteEA392.70All Commercial Customers392.70365.61368.38US7AFDDDD324g.jpg
BMUSTANGMD3183/T2MD3183/T2339113PAORANGE/BLACK W/AUTO HYDROSTATIC INFLATIOOrange/Black w/auto Hydrostatic inflationEA457.66All Commercial Customers457.66426.10429.32US7AFDDDD3183t2.jpg
BMUSTANGMIS240HRMIS240HR339113PAUSCG APPROVED W/SOLAS CHAPTER LLL SOLASUSCG approved w/solas chapter lll solas refective tape OVERSIZEEA603.96All Commercial Customers603.96562.31566.56US7AFDDDD230hr.gif
BMUSTANGMRD190MRD190339113PA90FT RING BUOY BAG W ROPE90ft Ring Buoy Bag w RopeEA48.09All Commercial Customers48.0944.7845.12US7AFDDDD00062533984325
BMUSTANGMV3192MV3192339113PATYPE LLL/V MV3192 SOLAS REFLECTIVE USCGtype lll/V MV3192 solas reflective USCG approvedEA92.19All Commercial Customers92.1985.8386.48US7AFDDDD
BMUSTANGMV3128MV3128339113PA4 POCKET USCG TYPE LLL SOLAS TAPE SM-XXL4 Pocket USCG Type lll solas tape Sm-XXLEA67.87All Commercial Customers67.8763.1963.67US7AFDDDD
BMUSTANGMRD075MRD075339113PA75' RESCUE THROW BAG WITH ROPE75' rescue throw bag with ropeEA58.62All Commercial Customers58.6254.5754.99US7AFDDDDd075.gif
BPOLYFORMHTM-3-BLACKHTM-3-BLACK33661210"X26" BLACK, HOLE THRU MIDDLE10"X26" Black, hole thru middleEA111.35All Commercial Customers111.35103.67104.45US7AFDDDD00743952003285htm3blk.jpg
BPOLYFORMHTM-3-BLUEHTM-3-BLUE33661210"X26" WHITE, HOLE THRU MIDDLE10"X26" White, Hole thru middleEA111.35All Commercial Customers111.35103.67104.45US7AFDDDDhtm3blue.gif
BPOLYFORMHTM-3-WHITEHTM-3-WHITE33661210"X26" WHITE, HOLE THRU MIDDLE10"X26" White, Hole thru middleEA111.35All Commercial Customers111.35103.67104.45US7AFDDDDhtm3white.jpg
BPOLYFORMHTM-4-BLACKHTM-4-BLACK33661212"X34" BLACK, HOLE THRU MIDDLE12"X34" Black, hole thru middleEA163.17All Commercial Customers163.17151.92153.07US7AFDDDDhtm3blk.jpg
BTECHOSEALR5R53366125" DIA ZINC5" Dia zincEA46.41All Commercial Customers46.4143.2143.54US7AFDDDDr5.gif
BPOLYFORMHTM-4-BLUEHTM-4-BLUE33661212"X34" BLUE, HOLE THRU MIDDLE12"X34" Blue, hole thru middleEA163.17All Commercial Customers163.17151.92153.07US7AFDDDDhtm3blue.gif
BPOLYFORMHTM-4-WHITEHTM-4-WHITE33661212"X34" WHITE, HOLE THRU MIDDLE12"X34" White, hole thru middleEA163.17All Commercial Customers163.17151.92153.07US7AFDDDDhtm3white.jpg
BPOLYFORMA--3-REDA--3-RED33661217"DIA X23"L A SERIES ROUND RED17"dia X23"L A series Round RedEA83.67All Commercial Customers83.6777.9078.49US7AFDDDDa3red.jpg
BPOLYFORMA-4-REDA-4-RED33661220.5"DIA X 27"L A SERIES ROUND RED20.5"dia X 27"l A series round redEA95.10All Commercial Customers95.1088.5489.21US7AFDDDDa3red.jpg
BPOLYFORMA-5-REDA-5-RED33661227"DIA X 36"L A SERIES ROUND RED27"dia X 36"l A series round redEA230.74All Commercial Customers230.74214.82216.45US7AFDDDDa3red.jpg
BRULEGOLD SERIES 4GOLD SERIES 43366121500GPH 1 1/8" HOSE 5YEAR WARR1500GPH 1 1/8" hose 5year warrEA152.03All Commercial Customers152.03141.55142.62US7AFDDDDrule1500.jpg
BRULEGOLD SERIES 9GOLD SERIES 93366122000GPH 1 1/8" HOSE 5 YEAR WARR2000GPH 1 1/8" hose 5 year warrEA202.16All Commercial Customers202.16188.22189.64US7AFDDDDrule2k.jpg
BRULEGOLD SERIES 13AGOLD SERIES 13A3366123700GPH 1 1/2" HOSE 5 YEAR WARR3700GPH 1 1/2" hose 5 year warrEA341.03All Commercial Customers341.03317.51319.91US7AFDDDDrule3700.jpg
BTECHOSEALR3R33366123 3/4" DIA ZINC3 3/4" Dia ZincEA15.44All Commercial Customers15.4414.3714.48US7AFDDDDr3.gif
BTECHOSEALR4R43366124" DIA ZINC4" Dia ZincEA26.89All Commercial Customers26.8925.0425.23US7AFDDDDr4.gif
BTECHOSEALR7R73366126.5" DIA ZINC6.5" Dia ZincEA76.10All Commercial Customers76.1070.8571.39US7AFDDDDr7.gif
BTECHOSEALX9X93366122" SHAFT DIA2" shaft DiaEA27.85All Commercial Customers27.8525.9326.13US7AFDDDDtecnoseal.gif
BTECHOSEALX10X103366122 1/4: SHAFT DIA2 1/4: shaft DiaEA55.67All Commercial Customers55.6751.8352.22US7AFDDDDtecnoseal.gif
BTECHOSEALX11X113366122 1/2" SHAFT DIA2 1/2" shaft DiaEA55.67All Commercial Customers55.6751.8352.22US7AFDDDDtecnoseal.gif
BTECHOSEALX12X123366122 3/4" SHAFT DIA2 3/4" shaft DiaEA71.47All Commercial Customers71.4766.5467.04US7AFDDDDtecnoseal.gif
BTECHOSEALX13X133366123" SHAFT DIA3" shaft DiaEA65.10All Commercial Customers65.1060.6161.07US7AFDDDDtecnoseal.gif
BVIKINGL008US0241AM4L008US0241AM43366128 PERSON VALISE SELF RIGHTS 60 SEC, 3-YE8 Person Valise Self rights 60 sec, 3-year service intervalEA5483.84All Commercial Customers5483.845105.645144.23US7AFDDDDvikingbag.gif
BVIKINGL004U00741AMEL004U00741AME3366124 PERSON CONTAINER SELF RIGHTS 60 SEC, 34 Person Container Self rights 60 sec, 3-year service intervalEA4208.31All Commercial Customers4208.313918.083947.69US7AFDDDDvikingcont.gif
BVIKINGL004US0241AMEL004US0241AME3366124 PERSON CONTAINER SELF RIGHTS 60 SEC, 34 Person Container Self rights 60 sec, 3-year service intervalEA5082.51All Commercial Customers5082.514731.994767.75US7AFDDDDvikingcont.gif
BVIKINGL004US0241AM3L004US0241AM33366124 PERSON VALISE SELF RIGHTS 60 SEC, 3-YE4 Person Valise Self rights 60 sec, 3-year service intervalEA4845.39All Commercial Customers4845.394511.224545.31US7AFDDDDvikingbag.gif
BVIKINGL006US0241AMDL006US0241AMD3366126 PERSON CONTAINER SELF RIGHTS 60 SEC, 36 Person Container Self rights 60 sec, 3-year service intervalEA5407.63All Commercial Customers5407.635034.695072.73US7AFDDDDvikingcont.gif
BVIKINGL006US0241AM5L006US0241AM53366126 PERSON VALISE SELF RIGHTS 60 SEC, 3-YE6 Person Valise Self rights 60 sec, 3-year service intervalEA5165.07All Commercial Customers5165.074808.864845.20US7AFDDDDvikingbag.gif
BVIKINGL008US0241AMEL008US0241AME3366128 PERSON CONTAINER SELF RIGHTS 60 SEC, 38 Person Container Self rights 60 sec, 3-year service intervalEA5719.74All Commercial Customers5719.745325.285365.52US7AFDDDDvikingcont.gif
BTYTAN ROPECMB 134600BTCMB 134600BT3366121 3/4" X 600FT TWISTED 3 STRAND NYLON1 3/4" X 600ft twisted 3 strand nylonEA1476.90All Commercial Customers1476.901375.041385.43US7AFDDDDcomborope.jpg
BTYTAN ROPECMB 158600BTCMB 158600BT3366121 5/8" X 600FT TWISTED 3 STRAND NYLON1 5/8" X 600ft twisted 3 strand nylonEA1339.62All Commercial Customers1339.621247.231256.66US7AFDDDDcomborope.jpg
BVIKINGL008U00741AMDL008U00741AMD3366128 PERSON CONTAINER SELF RIGHTS 60 SEC, 38 Person Container Self rights 60 sec, 3-year service intervalEA5097.35All Commercial Customers5097.354745.814781.67US7AFDDDDvikingcont.gif
BVIKINGL008U00741AM5L008U00741AM53366128 PERSON VALISE SELF RIGHTS 60 SEC, 3-YE8 Person Valise Self rights 60 sec, 3-year service intervalEA4860.04All Commercial Customers4860.044524.874559.06US7AFDDDDvikingbag.gif
BTYTAN ROPENY2600NY26003366122" X 600FT2" X 600ftEA2826.76All Commercial Customers2826.762631.812651.70US7AFDDDDnylonrope.jpg
BTYTAN ROPENY 134600NY 1346003366121 3/4" X 600FT TWISTED 3 STRAND NYLON1 3/4" X 600ft twisted 3 strand nylonEA2478.66All Commercial Customers2478.662307.722325.16US7AFDDDDnylonrope.jpg
BTYTAN ROPENY 112600NY 1126003366121 1/2" X 600FT TWISTED 3 STRAND NYLON1 1/2" X 600ft twisted 3 strand nylonEA1636.84All Commercial Customers1636.841523.951535.47US7AFDDDDnylonrope.jpg
BTYTAN ROPENY 114600NY 1146003366121 1/4" X 600FT TWISTED 3 STRAND NYLON1 1/4" X 600ft twisted 3 strand nylonEA1197.13All Commercial Customers1197.131114.571123.00US7AFDDDDnylonrope.jpg
BDOR-MOR200LB200LB336612200LB PYRAMID ANCHOR200lb pyramid anchorEA773.94All Commercial Customers773.94720.56726.01US7AFDDDDanchor.gif
BTYTAN ROPENY 1600NY 16003366121" X 600FT TWISTED 3 STRAND NYLON1" X 600ft twisted 3 strand nylonEA776.72All Commercial Customers776.72723.16728.62US7AFDDDDnylonrope.jpg
BTYTAN ROPESBN 16500SBN 165003366121/2" X 500FT SOLID BRAIDED NYLON1/2" X 500ft solid braided NylonEA241.11All Commercial Customers241.11224.48226.18US7AFDDDDbraidrope.jpg
BTYTAN ROPESBN 12500SBN 125003366123/8" X 500FT SOLID BRAIDED NYLON3/8" X 500ft solid braided nylonEA131.84All Commercial Customers131.84122.74123.67US7AFDDDDbraidrope.jpg
BTYTAN ROPESBN 101000SBN 1010003366125/16" X 1000FT SOLID BRAIDED NYLON5/16" X 1000ft solid braided nylonEA167.03All Commercial Customers167.03155.51156.68US7AFDDDDbraidrope.jpg
BACR28302830334511GLOBALFIX V4 406MHZ EPIRB CAT 1GlobalFix V4 406MHz Epirb Cat 1EA726.00All Commercial Customers726.00659.94664.93US7AFDDDD
BVIKINGL004U00741AM3L004U00741AM33366124 PERSON VALISE SELF RIGHTS 60 SEC, 3-YE4 Person Valise Self rights 60 sec, 3-year service intervalEA3966.55All Commercial Customers3966.553692.993720.90US7AFDDDDvikingbag.gif

This is the start of the file's text. The full file is on GovTribe.

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