Attachment_A_-_Contract_Pricing_1-20-97-36_Supplement_1.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- Statewide Contract CA|1-20-97-36|0000013047
- Contract number
- 1-20-97-36
- Issued by
- California
About this file
This document is a Pricing Worksheet Template and Supplement 1 for Statewide Contract 1-20-97-36, issued by the Department of General Services - Procurement Division. The contract is with Apex Universal, Inc. and specifically relates to Pavement Markers, providing a detailed pricing and specifications worksheet for various types of road markers.
The contract covers 12 line items of pavement markers with different specifications, including 4" x 4" and 3.18" x 4.55" sizes in various colors and reflectivity types (yellow, red, clear, amber). Pricing ranges from $0.38 to $1.12 per unit, depending on the marker type and size. Each line item includes detailed information such as UNSPSC Code, manufacturer part number, unit of measure, and specific product characteristics like abrasion resistance and packaging quantities (ranging from 50 to 500 per carton). The markers are categorized by type (D, H, G, C, AR, RA) and are designed for different road marking applications, including chip and seal surfaces.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 1-20-68-01B_-User_Instructions_-_Supp_9.docx | DOCX document | |
| Attachment_B_PCRC_Apex.pdf |
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 6/26/2019)
NOTE TO CAs:
This template is to be used as a guide for CAs developing pricing worksheets for statewide contract solicitations (IFBs or RFPs). CAs are required to review the following information before developing pricing worksheets.
● The columns below represent the MINIMUM data fields that are required in all pricing worksheets.
○ Columns #17 and #22 are only mandatory for solicitations that use a Core / Non-Core Pricing Structure
● The column numbers refer to the column numbers from the Usage Report Template.
● CAs should coordinate with Intake and Analysis Unit to include additional information as required.
● Each Pricing Worksheet should have a worksheet for field definitions or clear completion instructions within the solicitation.
● Refer to the Example tabs #1, #2, and #3 in this workbook for samples of Pricing Worksheet formats.
● For ADA Purposes: Provide a data validation input message for every cell (be as descriptive as possible) in the table and every input cell; lock/unlock cells where appropriate; do not merge or split cells within a table; delete or hide all unused rows and columns; rename workbook tabs (be as descriptive as possible); write "End of Sheet" or "End of Worksheet" in the last row for each sheet; set print area; prior to posting, protect sheet allowing "select locked cells" and "select unlocked cells" only.
***Delete these instructions before release***
| Column Number | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | Column 16 | Column 18 | Column 19 | Column 22 | |
| 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) | List Price/MSRP | Contract Unit Price | Contract Discount | Segment ID /Product Category/Group ID |
| 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). | 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). | ||||||||||||
| Format | Variable Character | Number | Variable Character | Variable Character | Variable Character | Variable Character | Variable Character | Number | Currency | Currency | Percentage | Variable Character | |
| Example | 625 | 43211503 | PT-674344457 | HP | 4576543245-JH/4567C | HP Compaq 8710p Notebook PC | BOX | 10 | $2,500.00 | $1,650.00 | 66% | A | |
| CORE - Often refers to a Fixed Price. | |||||||||||||
| NON-CORE - Often refers to a Discount off List Price (i.e. MSRP, Index, etc.). | |||||||||||||
| END OF SHEET. |
Example #1 (Core only)
| Department of General Services - Procurement Division | *Supplement 1* | |||||
| Statewide Contract 1-20-97-36 Pavement Markers | ||||||
| Attachment A - Contract Pricing, *9/10/2021* | ||||||
| Contractor: Apex Universal, Inc. | ||||||
| Contact Line Item # (CLIN) | Item Description | UNSPSC Code | ||||
| (Version 11) | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Unit of Measure | Quantity in | |
| Unit of Measure | Contract Price | |||||
| 1 | Pavement Marker, Type D, 4" x |
4" Reflectorized 2-Way Yellow, Abrasion Resistant Surface -
| Packaged 100 Per Carton. | 13111064 | MODEL 921AR | Apex Universal, Inc. | 921AR D | EA | 1 | $ 1.12 |
| 2 | Pavement Marker, Type H, 4" x |
4" Reflectorized 1-Way Yellow, Abrasion Resistant Surface -
| Packaged 100 Per Carton | 13111064 | MODEL 921AR | Apex Universal, Inc. | 921AR H | EA | 1 | $ 1.07 |
| 3 | Pavement Marker, Type G, 4" x |
4" Reflectorized 1-Way Clear, Abrasion Resistant Surface -
| Packaged 100 Per Carton | 13111064 | MODEL 921AR | Apex Universal, Inc. | 921AR G | EA | 1 | $ 1.07 |
| 4 | Pavement Marker, Type C, 4" x |
4" Reflectorized 2-Way Red and
| Clear, Abrasion Resistant Surface - Packaged 100 Per Carton | 13111064 | MODEL 921AR | Apex Universal, Inc. | 921AR C | EA | 1 | $ 1.12 | ||
| 5 | Pavement Marker, Type AR, 4" x 4" Reflectorized 2-Way, Amber & Red, Abrasion Resistant Surface - Packaged 50 Per Carton | 13111064 | MODEL 921AR | Apex Universal, Inc. | 921AR AR | EA | 1 | $ 1.12 | |
| 6 | Pavement Marker, Type D, 3.18" x 4.55" Reflectorized 2-Way Yellow, Abrasion Resistant Surface - Packaged 100 Per Carton | 13111064 | MODEL 899AR | Apex Universal, Inc. | 899AR D | EA | 1 | $ 0.77 | |
| 7 | Pavement Marker, Type H, 3.18" x 4.55" Reflectorized 1-Way Yellow, Abrasion Resistant Surface - Packaged 100 Per Carton | 13111064 | MODEL 899AR | Apex Universal, Inc. | 899AR H | EA | 1 | $ 0.72 | |
| 8 | Pavement Marker, Type G, 3.18" x 4.55" Reflectorized 1-Way Clear, Abrasion Resistant Surface - Packaged 100 Per Carton | 13111064 | MODEL 899AR | Apex Universal, Inc. | 899AR G | EA | 1 | $ 0.72 | |
| 9 | Pavement Marker, Type C, 3.18" x 4.55" Reflectorized 2-Way Red and Clear, Abrasion Resistant Surface - Packaged 100 Per Carton | 13111064 | MODEL 899AR | Apex Universal, Inc. | 899AR C | EA | 1 | $ 0.77 | |
| 10 | Pavement Marker, Type RA, 3.18" x 4.55" Reflectorized 2- Way, Amber & Red, Abrasion Resistant Surface - Packaged 100 Per Carton | 13111064 | MODEL 899AR | Apex Universal, Inc. | 899AR RA | EA | 1 | $ 0.77 | |
| 11 | Pavement Marker, Chip and Seal Type - 2-Way Yellow, Flex Self Adhesive, Packaged 500 Per Carton. | 13111064 | MODEL 932 | Apex Universal, Inc. | 932 2-YELLOW | EA | 1 | $ 0.40 | |
| 12 | Pavement Marker, Chip and Seal Type - 1-Way White, Flex Self Adhesive, Packaged 500 Per Carton | 13111064 | MODEL 932 | Apex Universal, Inc. | 932 1-WHITE | EA | 1 | $ 0.38 | |
| End of Sheet |
File details come from the government source that posted it. Updated .