MAS - Ramarc Solutions LLC - GS35F0367Y

PDF 158 KB

Attached to: Federal Supply Schedule GS35F0367Y Federal contract IDV
Contract number: GS35F0367Y
Issued by: GSA Federal Acquisition Service

About this file

Written by GovTribe AI · Jun 20, 2025

This document is a General Services Administration (GSA) Multiple Award Schedule (MAS) Price List for Ramarc Solutions LLC's Federal Supply Schedule contract GS35F0367Y, covering Information Technology (IT) Professional Services and Equipment. The contract, awarded on April 30, 2012, with an ultimate completion date of April 29, 2027, offers a comprehensive range of IT services and products including system configuration equipment, equipment maintenance, and professional IT services across multiple Special Item Numbers (SINs).

The price list details 12 distinct labor categories with specific experience and educational requirements, ranging from Project Manager to Senior Enterprise Architect, with hourly rates between $56.67 and $236.14. Service offerings include IT facility operations, systems development, systems analysis, automated information systems design, programming, backup and security services, data conversion, and network management. The contract covers domestic delivery within the 48 contiguous states, Alaska, Hawaii, Puerto Rico, Washington, DC, and U.S. Territories, with a minimum order value of $100 and maximum order value of $500,000 for equipment and maintenance services.

From the source

Ramarc Solutions, LLC Pricelist and/or Vendor Terms and Conditions for GS35F0367Y, a Federal Supply Schedule awarded to Ramarc Solutions, LLC, under Information Technology Schedule 70 (IT-70)

View the file

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

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

READ ME

Glossary:
PRODUCTS Tab
Grouping	Column	Description	Published on Advantage	Required for Catalog Action Type:

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

T: TPR	Source
	Base Product or Accessory	item_type	All 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.	No	A B C D T	Product File
	Manufacturer Information	manufacturer	Manufacturer 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!	Yes	A B C D T	Product File
	Manufacturer Information	manufacturer_part_number	Manufacturer 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.	Yes	A B C D T	Product File
	Vendor Part Number	vendor_part_number	Vendor part number, for use by the seller to track part numbers.	Yes	No	Product File
	Special Item Number	sin	SIN under which the product is being offered.	Yes	A B C	Product File
	Product Information	item_name	Product Name	Yes	A B C	Product File
	Product Information	item_description	A description of the product. The description can be up to 1,000 characters long.	Yes	A B C	Product File
	Product Information	recycled_content_percent	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)	No	No	Product File
	Unit of measure	uom	Unit of measure / issue of the product.	Yes	A B C	Product File
	Quantity Per Pack	quantity_per_pack	Quantity 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.	Yes	No	Product File
	Quantity Per Pack	quantity_unit_uom	Quantity 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".)	Yes	No	Product File
	Commercial Price /
Manufacturer's Suggested Retail Price	commercial_price	Commercial Price or Manufacturer's Suggested Retail Price	No	A B C	Product File
	Commercial Price /
Manufacturer's Suggested Retail Price	mfc_disc_off_commercial_price	mfc_disc_off_commercial_price is the percent discount relationship between the mfc_price and the commercial_price provided.	N/A	N/A	Compliance & Pricing Report
	Commercial Price /
Manufacturer's Suggested Retail Price	govt_disc_off_commercial_price	govt_disc_off_commercial_price is the percent discount relationship between the govt_price_no_fee and the commercial_price provided.	N/A	N/A	Compliance & Pricing Report
	Most Favored Customer	mfc_name	Only 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.	No	Conditional (non-TDR)	Product File
	Most Favored Customer	mfc_price	Only applies for non-TDR contracts. This is the price offered to the Most Favored Customer with the MFC discount.	No	Conditional (non-TDR)	Product File
	Price Proposal	govt_price_no_fee	This 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",P30.98,P30.9925)	No	A B C	Product File
	Price Proposal	govt_price_with_fee	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).

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.	Yes	A B C T	Product File
	Dealer Markup	dealer_cost	Dealer cost for the product.
NOTE: Markup based pricing is allowed under specific SINs and should be verified.	No	Conditional (markup based contracts)	Product File
	Dealer Markup	mfc_markup_percentage	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.	No	Conditional (markup based contracts)	Product File
	Dealer Markup	govt_markup_percentage	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).	No	Conditional (markup based contracts)	Product File
	Country of Origin	country_of_origin	Provide 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.	Yes	A B C	Product File
	Delivery Information	delivery_days	Delivery lead time-Provide a numerical value here for the number of days for product delivery.	Yes	A B C	Product File
	Delivery Information	lead_time_code	Delivery 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 Delivery	Yes	A B C	Product File
	Delivery Information	fob_us	Freight on Board to the 48 Contiguous US States and DC (CONUS): D-Destination or O-Origin. At minimum, delivery to CONUS locations is required.	Yes	A B C	Product File
	Delivery Information	fob_ak	Freight on Board-Alaska: D-Destination,O-Origin or N-No Delivery.	Yes	A B C	Product File
	Delivery Information	fob_hi	Freight on Board-Hawaii: D-Destination,O-Origin or N-No Delivery.	Yes	A B C	Product File
	Delivery Information	fob_pr	Freight on Board-Puerto Rico: D-Destination,O-Origin or N-No Delivery.	Yes	A B C	Product File
	National Stock Number	nsn	National Stock Number	Yes	No	Product File
	UPC	upc	Universal Product Code. If UPCs are utilized, this code must be 8-14 digits in length.	Yes	Conditional	Product File
	UNSPSC	unspsc	United Nations Standard Products and Services Code. This code must be 8 digits in length and cannot begin with a zero (0).	Yes	No	Product File
	Temporary Price Reduction (TPR)	sale_price_with_fee	ONLY 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).	Yes	T	Product File
	Temporary Price Reduction (TPR)	start_date	If providing temporary price reductions, indicate the start date for the temporary pricing	Yes	T	Product File
	Temporary Price Reduction (TPR)	stop_date	If providing temporary price reductions, indicate the stop date for the temporary pricing	Yes	T	Product File
	Photo File References	default_photo	Provide 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#sinMolPhotoUpc	Yes	Conditional	Product File
	Photo File References	photo_2	Provide the file name of the image uploaded	Yes	Conditional	Product File
	Photo File References	photo_3	Provide the file name of the image uploaded	Yes	Conditional	Product File
	Photo File References	photo_4	Provide the file name of the image uploaded	Yes	Conditional	Product File
	Photo File References	product_url	Provide the web address where additional product information can be found.	Yes	No	Product File
	Warranty Duration	warranty_period	Duration of Warranty.	Yes	No	Product File
	Warranty Duration	warranty_unit_of_time	Unit of time of the warranty duration	Yes	No	Product File
	Product Dimensions	length	Physical Length ( Must be provided when another Shipping Container Dimension is provided.)	Yes	Conditional	Product File
	Product Dimensions	width	Physical Width ( Must be provided when another Shipping Container Dimension is provided.)	Yes	Conditional	Product File
	Product Dimensions	height	Physical Height ( Must be provided when another Shipping Container Dimension is provided.)	Yes	Conditional	Product File
	Product Dimensions	physical_uom	Unit of measure for shipping package (feet, inches, cm, etc.) ( Must be provided when another Shipping Container Dimension is provided.)	Yes	Conditional	Product File
	Product Dimensions	weight_lbs	Weight in pounds of product's shipping weight ( Must be provided when another Shipping Container Dimension is provided.)	No	Conditional	Product File
	Product Information / Categorization	product_info_code	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 ",".	Yes	No	Product File
	Product Information / Categorization	url_508	URL for 508 information	Yes	No	Product File
	Product Information / Categorization	hazmat	Product hazmat information. This a United Nations Identification number (UNID). It will start with UN, NA or MSDS.	Yes	No	Product File
	Summary	flag_summary	flag_summary is a list of the compliance and pricing flags at the line item level.	N/A	N/A	Compliance & Pricing Report
	Summary	hits	hits are the number of offerings found on all contracts at the line item level.	N/A	N/A	Compliance & Pricing Report
	Summary	self_hits	self_hits are the number of offerings found for same vendor at the line item level.	N/A	N/A	Compliance & Pricing Report
	Summary	vendor_comments	vendor_comments are any input the vendor would like to share with their CO/CS.	N/A	N/A	Compliance & Pricing Report
	Compliance Considerations	is_authorized_vendor	is_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.

- Review LoS Requirement - The Verified Product Portal does not have authorization data for the item, review the Letter of Supply requirements to see if the product is required to have an LoS on file (Consult the MAS Solicitation for the most current LoS Requirements.)	N/A	N/A	Compliance & Pricing Report
	Compliance Considerations	is_prohibited	is_prohibited provides insight into any regulatory compliance concerns that indicate whether an item can be sold or not.	N/A	N/A	Compliance & Pricing Report
	Compliance Considerations	prohibition_comment	prohibition_comment provides information on why an item is flagged as prohibited.	N/A	N/A	Compliance & Pricing Report
	Compliance Considerations	ets	ets is an item that is deemed Essentially the Same as an Ability One Item.	N/A	N/A	Compliance & Pricing Report
	Country of Origin	inferred_country_origin	inferred_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/A	N/A	Compliance & Pricing Report
	Country of Origin	is_mia_risk	is_mia_risk is when the inferred_country_origin is not "US", while the provided country of origin was "US".	N/A	N/A	Compliance & Pricing Report
	Country of Origin	is_taa_risk	is_taa_risk is when the inferred_country_origin is from a non-TAA compliant country	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	market_threshold	market_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/A	N/A	Compliance & Pricing Report
	Pricing Market Research	market_threshold_status	market_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 required	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_min_price	government_min_price is the lowest price found across the government catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	proposed_price_relative_to_government_min	proposed_price_relative_to_government_min is the govt_price_with_fee as a percentage of government_minimum_price (+/-).	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_min_price_supplier	government_min_price_supplier is the vendor offering the product at the government_minimum_price.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_median_price	government_median_price is the median price found across government contracts, excluding low outliers.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_median_price_supplier	government_median_price_supplier is the vendor offering the product at the government_median_price.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_average_price	government_average_price is the average price found across the government catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_average_price_standard_deviation	government_average_price_standard_deviation is the pricing standard deviation of the government catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_max_price	government_max_price is the maximum price found across the government catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	commercial_min_price	commercial_min_price is the lowest price found across the commercial catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	proposed_price_relative_to_commercial_min	proposed_price_relative_to_commercial_min is the govt_price_with_fee as a percentage of commercial_minimum_price (+/-).	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	commercial_min_price_supplier	commercial_min_price_supplier is the commercial supplier offering the product at the commercial_minimum_price.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	commercial_median_price	commercial_median_price is the median price found across the commercial catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	commercial_median_price_supplier	commercial_median_price_supplier is the commercial supplier offering the product at the commercial_median_price.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_transaction_min_price	government_transaction_min_price is the minimum transaction price found across the GSAAdvantage! and FedMall catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_transaction_average_price	government_transaction_average_price is the average transaction price found across the GSAAdvantage! and FedMall catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_transaction_median_price	government_transaction_median_price is the median transaction price found across the GSAAdvantage! and FedMall catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	government_transaction_max_price	government_transaction_max_price is the maximum transaction price found across the GSAAdvantage! and FedMall catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	tdr_min_price	tdr_min_price is the lowest price found across Transactional Data Reporting (TDR) catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	tdr_median_price	tdr_median_price is the median price across Transactional Data Reporting (TDR) catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	tdr_max_price	tdr_max_price is the maximum price across Transactional Data Reporting (TDR) catalogs.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	sales_likelihood	sales_likelihood: based on GSAAdvantage! transaction price points, how likely is the product to sell at the proposed price.	N/A	N/A	Compliance & Pricing Report
	Pricing Market Research	annual_demand_quantity	annual_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/A	N/A	Compliance & Pricing Report
	Pricing Market Research	demand_weighted_index_score	demand_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/A	N/A	Compliance & Pricing Report
	Pricing Market Research	is_low_outlier	is_low_outlier are any products where the govt_price_with_fee is at least 50% less than the goverment_median_price.	N/A	N/A	Compliance & Pricing Report
	Product Information	unique_item_identifier	unique_item_identifier is XSB's unique identifier at the line item level.	N/A	N/A	Compliance & Pricing Report
	OPTIONS Tab
	Grouping	Column	Description	Published on Advantage	Required	Source
	Manufacturer Information	manufacturer	Product 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.	Yes	No	Product File
	Manufacturer Information	manufacturer_part_number	Product 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.	Yes	No	Product File
	Options Information	option_manufacturer	Option Manufacturer name is a required field for all options..	Yes	No	Product File
	Options Information	option_part_number	Options part number is a required field for all options. The option part number is provided to vendors on the Purchase Order.	No	No	Product File
	Options Information	category	Category 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.	Yes	No	Product File
	Options Information	name	Option name	Yes	No	Product File
	Options Information	base_item_relationship	Base 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.	Yes	No	Product File
	Options Information	quantity	Quantity of the option (i.e. 6 EA)	Yes	No	Product File
	Options Information	unit_of_measure	Unit of measure / issue of the product's option.	Yes	No	Product File
	Options Price	price_with_fee	This 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).	Yes	No	Product File
	PRODXACC Tab
	Grouping	Column	Description	Published on Advantage	Required	Source
	Product Manufacturer Information	manufacturer	Product 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.	Yes	No	Product File
	Product Manufacturer Information	manufacturer_part_number	Product 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.	Yes	No	Product File
	Accessory Manufacturer Information	accessory_manufacturer	Accessory 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.	Yes	No	Product File
	Accessory Manufacturer Information	accessory_manufacturer_part_number	Accessory 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.	Yes	No	Product File
	QTYVOL Tab
	Grouping	Column	Description	Published on Advantage	Required	Source
	Manufacturer Information	manufacturer	Product 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.	Yes	No	Product File
	Manufacturer Information	manufacturer_part_number	Product 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.	Yes	No	Product File
	Volume or Quantity	discount _type	Quantity 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.	Yes	No	Product File
	Price Buckets	bucket_number	Price 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.)	Yes	No	Product File
	Discount Range	start_of_range	Start 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.	Yes	No	Product File
	Discount Range	end_of_range	End of Range for Bucket. Must be a whole number. The end of range of the last discount bucket must be 99999999.	Yes	No	Product File
	Discount Range	discounted_price	Discounted 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.	Yes	No	Product File
	Discount Range	percent_discount	Percent 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.	Yes	No	Product 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-20250626)

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.

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).

FOR REFERENCE:

PRODUCTS

Base Product or Accessory

Manufacturer Information

Vendor Part Number

Special Item Number

Product Information

Unit of Measure

Quantity Per Pack

Commercial Price /

Manufacturer's Suggested Retail Price

Most Favored Customer

Price Proposal

Country of Origin

Delivery Information

National Stock Number

UPC

United Nations Standard Products and Services Code

Temporary Price Reduction (TPR)

Photo File References

Warranty Duration

Product Dimensions

Product Information / Categorization

Dealer 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.66	country_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 Delivery	fob_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.	nsn	upc
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: Weeks	length
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 applicable	hazmat
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)

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

OPTIONS

	Manufacturer Information	Options Information	Options Price
	manufacturer
MankwongYau: Product 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.	manufacturer_part_number
MankwongYau: Product 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.	option_manufacturer
MankwongYau: Option Manufacturer name is a required field for all options. It must be provided and reference a product in the PRODUCTS tab.	option_part_number
MankwongYau: Options part number is a required field for all options. The option part number is provided to vendors on the Purchase Order.	category
MankwongYau: Category 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 product from that category. You will create your own category names that appear on Advantage. Enter “Options” as a generic name.	name
MankwongYau: Option name	base_item_relationship

MankwongYau: Base 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.	quantity
MankwongYau: Quantity of the option (i.e. 6 EA)	unit_of_measure
MankwongYau: Unit of measure / issue of the product's option.	price_with_fee

MankwongYau: This 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).

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

PRODXACC

	Product Manufacturer Information	Accessory Manufacturer Information
	manufacturer
MankwongYau: Product 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.	manufacturer_part_number
MankwongYau: Product 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.	accessory_manufacturer
MankwongYau: Accessory 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.	accessory_manufacturer_part_number

MankwongYau: Accessory 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.

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

QTYVOL

	Manufacturer Information	Volume or Quantity	Price Bucket: Provide buckets from 1 up to 7	Discount Range
	manufacturer
MankwongYau: Product 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.	manufacturer_part_number
MankwongYau: Product 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.	discount_type
MankwongYau: Quantity 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.	bucket_number
MankwongYau: Price 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.)	start_of_range
MankwongYau: Start of Range for Bucket. Must be a whole number. This must follow the end_of_range from the prior price bucket.	end_of_range
MankwongYau: End of Range for Bucket. Must be a whole number. The end of range of the last discount bucket must be 99999999.	discounted_price
MankwongYau: Discounted 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). You can propose a Discounted Price or Percentage Discount, but not both for the same product.	percent_discount

MankwongYau: Percent Discount provided for bucket. Express this value in decimal format only with a maximum of 4 decimal points. (i.e 3.25%, enter 0.0325; 50%, enter 0.5) You can propose a Discounted Price or Percentage Discount, but not both for the same product.

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

REFERENCE

Special Item Number (SIN)

Unit of Measure (UOM)

Country of Origin - ISO-2 Codes

Delivery Information - Lead Time Code

Freight On Board (FOB)

Warranty Period

Product or Accessory - Item Type

Quantity/Volume Discounts

Options Code - Base Item Relationship

Product Information / Categorization

Physical UOM

Code

Description

Code

Description

Code

Territory Name

Code

Description

Code

Location Qualifier Description

Code

Description

Code

Description

Values

Code

Description

Code

Description

Code

Description

334310

Professional Audio/Video Products

Each

(Waiver Required) Andorra

From date of PO receipt to shipment

Destination

Calendar Days

ACCESSORY

Quantity

Option is not included, but can be added for an additional cost.

FEMP Energy Efficiency item

Centimeter

334511T

Telecommunications Equipment

Package

(Waiver Required) United Arab Emirates (the)

From date of PO receipt to delivery

Origin

Work Days

BASE

Volume

No cost is associated with this option. One of multiple options that can be chosen. (i.e. shirt sizes S, M, L) This can also be used for informational purposes.

Low VOC

Decimeter

541990AV

Professional Audio/Video Services

Carton

Afghanistan

From Date of Award to Date of Completion (services only)

No Delivery

Lifetime

If another option is already included (I), this option can substitute it

Ability One item

Foot

518210DC

Document Conversion Services

Box

Antigua and Barbuda

From Date of Award to Date of Delivery

Months

UNICOR item

Inch

541611LIT

Litigation Support Solutions

Case

(Waiver Required) Anguilla

Weeks

Comprehensive Procurement Guidelines (CPG) compliant

Meter

561439

Document Production On-site and Off-site Services

Pair

(Waiver Required) Albania

EPA Significant New Alternatives Program approved

Yard

561990

Document Destruction Services

Pounds Gross

Armenia

Ergonomic item

561499M

Mail Management, Systems, Processing Equipment and Related Solutions

Cassette

Angola

Section 508 item

811212R

Repair of Government-Owned Equipment (for equipment NOT under Maintenance Service Agreement)

Roll

(Waiver Required) Antarctica

Pre-purchased stock

811212SA

Maintenance Service Agreement For Office Equipment

Set

(Waiver Required) Argentina

Shipboard Use Approved item

511120

Periodicals, Subscriptions, Online Book Selling and Lending Library Services

Dozen

Austria

Hazmat item

561410

Editorial, Publishing, and Library Media Services

Kilogram

Australia

BioPreferred item

541611O

Office Management Needs Assessment and Analysis Services

Kit

Aruba

This product requires custom text when ordered

541614OR

Office Relocation and Reconfiguration

Bundle

(Waiver Required) Azerbaijan

EPA Recommended

561110

Office Administrative Services

Bag

(Waiver Required) Bosnia and Herzegovina

FIPS 201 approved item

333318

Dictating and Transcribing Machines and Systems

Piece

Barbados

Safer Choice

339940

Office Products

Foot

Bangladesh

Single Use Plastic

339940OS4

OS4 Office Products and Supplies

Pack (PAK)

Belgium

339940SVC

Office Supply Support Services

Round

Burkina Faso

325992

Micro-photographic Film, Paper, Chemical Preparation and Equipment

Ream

Bulgaria

333244

Post Copying/Finishing Equipment and Supplies

Actual Pounds

Bahrain

333249

3D Printing Solutions and Additive Manufacturing Solutions

Statute Mile

Burundi

333316C

Copiers and Digital Duplicating Equipment

Seconds

Benin

333316F

Flat Rate Monthly Fee for Copiers (to include Analog, Digital, Multifunctional and Engineer Copiers)

Small Spray

(Waiver Required) Saint Barthélemy

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 Jun 6, 2019.