PRICE LIST SPREADSHEET.xls

XLS spreadsheet 2 MB Posted Nov 1, 2018

Attached to: 1130-19-R-NBID-00012
Solicitation number: 3130000920
Issued by: Harrison County, Mississippi

About this file

Written by GovTribe AI · Aug 23, 2024

This document is a price list spreadsheet for a state and local government contract opportunity. The spreadsheet includes instructions for suppliers on how to complete the required fields, which include supplier information, product details, pricing, delivery timelines, and website links. Suppliers are required to provide a variety of information about their products, such as short and long descriptions, NIGP codes, discounted prices, MSRP, search terms, delivery timelines, and manufacturer details. The spreadsheet also notes that duplicate information is not allowed within certain fields. No specific details are provided about the actual contract opportunity, such as the agencies or jurisdictions involved, response deadlines, award dates, or contract term.

The pricing terms, set-asides, incumbent suppliers, funding requirements, and other salient contract details are not included in this price list spreadsheet. The document appears to be a standardized template for suppliers to provide product information, rather than a comprehensive solicitation document. Without additional context about the specific contract opportunity, no further details can be summarized.

View the file

Other files

File	Type	Posted
DEALERS LIST EXCEL SPREADSHEET.xlsx	XLSX spreadsheet	Nov 1, 2018
JC-MS134-030(1)B-2.pdf	PDF	Nov 1, 2018
INSTRUCTIONS FOR COMPLETING THE PRICE LIST SPREADSHEET.pdf	PDF	Nov 1, 2018
5480-20190130152428.docx	DOCX document	Nov 1, 2018
155-20190201150830.pdf	PDF	Nov 1, 2018
MS BASED RECYCLED_PFG.pdf	PDF	Nov 1, 2018
MRO_SAMPLE CONTRACT.pdf	PDF	Nov 1, 2018
PURCHASE SUMMARY EXCEL SPREADSHEET.xlsx	XLSX spreadsheet	Nov 1, 2018
GENERAL CONDITIONS NEGOTIATED_122017.pdf	PDF	Nov 1, 2018
9415-20200303112016.docx	DOCX document	Nov 1, 2018
MS BASED RECYCLED MATERIALS SAMPLE CONTRACT_2018.pdf	PDF	Nov 1, 2018

Show all 11

On GovTribe

Work with this file

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.

Instructions

	Sort	Field	Usage	Required/
Optional	Field Type	Explanation/ Values	Examples
	1	Supplier	Supplier Name	Required	CHAR(50)	Name of Company	ABC MS Based Manufacturer
	2	Supplier ID	Supplier ID	Required	CHAR(10)	See Proposal, Format & Guidelines	3000000121
	3	Supplier Part Number	Supplier Part Number	Required	CHAR(20)	Supplier Part Number	ABC20131500
	4	Short Description	Short Description	Required	CHAR(99)	Short Description; Line Item Details; Include any special information such as packaging	Widget ABC
	5	Long Description	Long Description	Required	CHAR(2000)	Full long description	Special Widget For MS Based Maufacturers
	6	Product Group	NIGP 5 digit code	Required	CHAR(5)	5 Digit NIGP Classification code; Must use from list provided in NIGP Choices Tab	02066
	7	Price	Discounted Price	Required	Real	Amount with 2 decimal places	$87.50
	8	MSRP	MSRP Price	Required	Real	MSRP Amount with 2 decimal places	$102.00
	9	Special Search Terms	Search terms, tags	Required	CHAR(100)	Searchable term to identify your items	MS Based, Recycled
	10	Delivery In Days	Delivery days	Required	Integer	Delivery Days	60
	11	UOM	Unit of Measure	Required	CHAR(3)	Base unit of measure (refer to tab UOM)	EA
	12	Hyperlink URL	Hyperlink URL	Required		Value = Manufacturer website	www.msbasedproducts.com
	13	Manufacturer	Manufacturer Name	Required		Name of the Manufacturer	ABC MS Based Manufacturer
	14	Manufacturer PN	Manufacturer Part Number	Required	CHAR(20)	Manufacturer Part Number	10369
		Field	Further Explanation
		Supplier	This field is for the Supplier. If you are a business dealing on behalf of a Manufacturer, the MANUFACTURER name goes in this field.
		Supplier ID	This number comes from OPTFM. If you are unsure of your Supplier ID, Please Call OPTFM at 601-359-3409. If you are authorized to deal on behalf of a Manufacturer, the MANUFACTURER'S supplier ID goes in this field. This is an unique field. This means that no duplicate information is allowed in the ENTIRE column.
		Supplier Part Number	The part numbers in this column can match the part numbers in the Manufacturer Part Number column; however, in the Supplier Part Number Column all values have to be unique. This means that no duplicate information is allowed.
		Short Description	This field provides a short description for the product being offered. Only 99 Characters will be allowed in this field. This is an unique field. This means that no duplicate information is allowed in the Entire Column. Please also include packaging information.
		Product Group	Use the NIGP Choices tab to populate the product group column sheet 1.
		Delivery in Days	This column should contain the MAX number of days that it will take for the line item to get to the purchaser. DO NOT INPUT A RANGE OF DAYS.
		Hyperlink URL	This is the preferred method is to send us the link to your website where the image of the line item can be viewed.
		Notes
		1.) The above spreadsheet is an example of how Sheet 1 should look once completed.
		2.) Populate Tab "Sheet1" with your data.
		3.) Do NOT change the name of the Tabs - other than Sheet 1 to reflect the Manufacturer Name.
		4.) See Examples column for ideas.
		5.) CHAR(#) - the allotted amount of characters for that field. This is strictly enforced.
		6.) If a cell appears to have this formatting (Red Highlighted Cell with Data in cell in Red font color), that cell contains duplicate information. Please change this information so that each cell in the column is unique. THIS IS STRICTLY ENFORCED.

www.msbasedproducts.com

Sheet1

Supplier

Supplier ID

Supplier Part Number

Short Description

Long Description

Product Group

Service Item

Contract Price

MSRP

Price Base Qty

Currency

Contract Number

Contract Item ID

SAP Contract Item Category

Special Search Terms

Delivery In Days

UOM

Price Base Qty UOM

Image

Item Status

Hyperlink Type

Hyperlink MIME Type

Hyperlink URL

Hyperlink URL Description

Manufacturer

Manufacturer PN

Supplier Catalog Name