PRICE LIST SPREADSHEET.xls

XLS spreadsheet 2 MB Posted Jan 2, 2018

Attached to: 1130-18-R-NBID-00015
Solicitation number: 3130000721
Issued by: Hinds County, Jackson City, Mississippi

About this file

Written by GovTribe AI · Jan 6, 2025

This is a price list spreadsheet template from the Mississippi Office of Purchasing, Travel and Fleet Management (OPTFM) for a copier negotiated contract bid. The spreadsheet provides detailed instructions for suppliers to submit product information including supplier name, ID numbers, part numbers, descriptions, NIGP codes, pricing, delivery timeframes, and manufacturer details. The template requires specific formatting with character limits and unique values for certain fields.

The spreadsheet requires suppliers to include both discounted contract pricing and MSRP with amounts in USD. Other required fields include URLs to manufacturer websites, searchable product terms, delivery timeframes in days, and units of measure. The template emphasizes strict enforcement of formatting requirements, particularly for unique values in supplier part numbers and descriptions, with red highlighting used to indicate duplicate entries that must be corrected before submission.

View the file

Other files

File	Type	Posted
GENERICRENTALAGREEMENT-FEBRUARY-2017.pdf.crdownload	CRDOWNLOAD file	Jan 2, 2018
PURCHASE SUMMARY EXCEL SPREADSHEET (1).xlsx	XLSX spreadsheet	Jan 2, 2018
GENERICRENTALAGREEMENT-FEBRUARY-2017.pdf	PDF	Jan 2, 2018
DEALERS LIST EXCEL SPREADSHEET.xlsx	XLSX spreadsheet	Jan 2, 2018
COPIERPFG_2018.pdf	PDF	Jan 2, 2018
SAMPLE CONTRACT_2018.pdf	PDF	Jan 2, 2018
COPIERPFG_2018.pdf.crdownload	CRDOWNLOAD file	Jan 2, 2018
GENERAL CONDITIONS NEGOTIATED_122017.pdf	PDF	Jan 2, 2018
PURCHASE SUMMARY EXCEL SPREADSHEET (2).xlsx	XLSX spreadsheet	Jan 2, 2018
PURCHASE SUMMARY EXCEL SPREADSHEET.xlsx	XLSX spreadsheet	Jan 2, 2018

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