Attachment_1_Pricing_Worksheet.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- PAINT, EXTERIOR, RECYCLED REPROCESSED
- Solicitation number
- 0000000353
- Issued by
- California
About this file
This is a pricing worksheet template for a State of California contract opportunity for recycled reprocessed exterior paint. The worksheet outlines requirements for various types of exterior latex paint including flat finish, eggshell finish, semi-gloss finish, graffiti cover-up paint, and primer, all available in both 1-gallon and 5-gallon quantities. The quantities requested range from 50 gallons for various 1-gallon containers to 6,000 gallons for graffiti cover-up paint in 5-gallon containers. All paint products must meet State of California Specifications #8010-3174 dated 05/15/2015.
The pricing worksheet requires bidders to complete information including UNSPSC codes, manufacturer part numbers, manufacturer names, SKU numbers, item descriptions, and units of measure. Pricing must include list price/MSRP, contract discount percentage, and final contract price. The template calculates contract discounts using the formula ((List Price - Contract Price)/List Price) and automatically calculates extensions based on quantity times contract unit price. The worksheet distinguishes between core items (typically fixed price) and non-core items (typically discount off list price).
View the file
Other files
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
Text version
MINIMUM DATA
| PRICING WORKSHEET TEMPLATE |
| Minimum Data Elements |
PRICING WORKSHEET TEMPLATE
(Rev 4/6/2011)
| Column Number | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | |
| Column Name | Contract Line Item Number (CLIN) | ||||||||
| UNSPSC Code | |||||||||
| (Version 11) | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | Unit of Measure | Quantity in |
Unit of Measure
| (If Applicable) | Column 16 | Column 18 | Column 19 | Column 22 |
| Description | Unique line item number. | The United Nations Standard Products and Services Code. It’s a global multi-sector standard for efficient, accurate classification of products and services. |
This field should document the appropriate UNSPSC Commodity Code for each line item.
| Website for codes: http://www.unspsc.org/Search.asp | Identifies manufacturer's unique identifier for a particular line item. | Identifies the manufacturer's name for each line item. | Identifies supplier's unique identifier for a particular line item. | Informational text about the commodity being purchased. Description should be descriptive enough to show the item is consistent with the specifications (high-level). | Unit of Measure - Descriptor of the packaging unit (i.e. each, box, dozen, case, lbs, pallet etc). | This field will carry the number of base units in the packaging of the products | ||||
| (i.e. # of pencils in a box). | List Price/MSRP | Contract Unit Price | Contract Discount | Segment ID /Product Category/Group ID | ||||||
| Format | Variable Character | Number | Variable Character | Variable Character | Variable Character | Variable Character | Variable Character | Number | An independently verifiable public price available to the general public. | |
| This is the contractual price for a given line item based on the price that was bid, as relative to the | ||||||||||
| unit of measure. | For commodities with a discount structure - this value represents the contractual discount off the List Price. |
| For commodities with a fixed price structure, discount is derived based on the following calculation: ((List Price - Contract Price)/List Price) = Contract Discount %. | This non-core identifier will uniquely categorize each commodity grouping to its respective contractual discount(s). | ||||||||||||
| Example | 625 | 43211503 | PT-674344457 | HP | 4576543245-JH/4567C | HP Compaq 8710p Notebook PC | BOX | 10 | Currency | Currency | Percentage | Variable Character | |
| CORE - Often refers to a Fixed Price. | $2,500.00 | $1,650.00 | 66% | A | |||||||||
| NON-CORE - Often refers to a Discount off List Price (i.e. MSRP, Index, etc.). |
PD 80-10
| PRICING WORKSHEET TEMPLATE | ||||||||||||
| Paint, Latex, Exterior Recycled Reprocessed | ||||||||||||
| Event ID: 0000000353 | ||||||||||||
| ATTACHMENT 1 | ||||||||||||
| Pricing Worksheet | ||||||||||||
| PRICING WORKSHEET | ||||||||||||
| Bidder: | ||||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Supplier must complete the Yellow Cells only. | ||||||||||||
| Contact Line Item # (CLIN) | Quantity | Commodity Description | UNSPSC Code | |||||||||
| (Version 11) | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | Unit of Measure | Quantity in | ||||||
| Unit of Measure | List Price/MSRP | Contract Discount | Contract Price | Extension | ||||||||
| 100 | 50 | Paint, Latex, Exterior Recycled Reprocessed, Flat Finish (1 gallon) | Recycled Reprocessed Exterior Paint, Flat Finish, as per State of California Specifications # 8010-3174 dated 05/15/2015 | Gallon | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 200 | 400 | Paint, Latex, Exterior Recycled Reprocessed, Flat Finish (5 gallon) | Recycled Reprocessed Exterior Paint, Flat Finish, as per State of California Specifications # 8010-3174 dated 05/15/2015 | Gallon | 5 | ERROR:#DIV/0! | $ - 0 | |||||
| 300 | 50 | Paint, Latex, Exterior Recycled Reprocessed, Eggshell Finish (1 gallon) | Recycled Reprocessed Exterior Paint, Eggshell Finish, as per State of California Specifications # 8010-3174 dated 05/15/2015 | Gallon | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 400 | 300 | Paint, Latex, Exterior Recycled Reprocessed, Eggshell Finish (5 gallon) | Recycled Reprocessed Exterior Paint, Eggshell Finish, as per State of California Specifications # 8010-3174 dated 05/15/2015 | Gallon | 5 | ERROR:#DIV/0! | $ - 0 | |||||
| 500 | 100 | Paint, Latex, Exterior Recycled Reprocessed, Semi-Gloss Finish (1 gallon) | Recycled Reprocessed Exterior Paint, Semi-Gloss Finish, as per State of California Specifications # 8010-3174 dated 05/15/2015 | Gallon | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 600 | 500 | Paint, Latex, Exterior Recycled Reprocessed, Semi-Gloss Finish (5 gallon) | Recycled Reprocessed Exterior Paint, Semi-Gloss Finish, as per State of California Specifications # 8010-3174 dated 05/15/2015 | Gallon | 5 | ERROR:#DIV/0! | $ - 0 | |||||
| 700 | 50 | Paint, Latex, Exterior Recycled Reprocessed, Graffiti Cover Up (1 gallon) | Recycled Reprocessed Exterior Paint, Exterior Graffiti Cover Up Recycled Paint, as per State of California Specifications # 8010-3174 dated 05/15/2015 | Gallon | 1 | ERROR:#DIV/0! | $ - 0 | |||||
| 800 | 6000 | Paint, Latex, Exterior Recycled Reprocessed, Graffiti Cover Up (5 gallon) | Recycled Reprocessed Exterior Paint, Exterior Graffiti Cover Up Recycled Paint, as per State of California Specifications # 8010-3174 dated 05/15/2015 | Gallon | 5 | ERROR:#DIV/0! | $ - 0 | |||||
| 900 | 50 | Paint, Latex, Exterior Recycled Reprocessed, Primer (1 gallon) | Recycled Reprocessed Exterior Paint, Exterior Primer Latex Paint, as per State of California Specifications # 8010-3174 dated 05/15/2015 | |||||||||
| Gallon | 1 | ERROR:#DIV/0! | $ - 0 | |||||||||
| 1000 | 300 | Paint, Latex, Exterior Recycled Reprocessed, Primer (5 gallon) | Recycled Reprocessed Exterior Paint, Exterior Primer Latex Paint, as per State of California Specifications # 8010-3174 dated 05/15/2015 | |||||||||
| Gallon | 5 | ERROR:#DIV/0! | $ - 0 | |||||||||
| TOTAL: | $ - 0 | |||||||||||
| Note: | Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | |||||||||||
| Extension is automatically calculate by (Contract Unit Price x Quantity) |
Page &P
File details come from the government source that posted it. Updated .