1._Pricing_Worksheet_Addendum_3.xlsx
XLSX spreadsheet 27 KB Posted
- Attached to
- 25-81-03 Paper Grocery Bags
- Solicitation number
- 0000032837
- Issued by
- California
About this file
This is a pricing worksheet addendum (Addendum 3) related to a State of California Department of General Services, Procurement Division (DGS-PD) contract opportunity for Paper Grocery Bags. The resulting contract will be mandatory for all State of California Departments and available for use by participating local agencies. The contract term is set for three years with two one-year extension options, which can be exercised upon mutual agreement between parties.
The file appears to be an Excel spreadsheet for pricing submissions, though the actual contents of the worksheet are not provided in the source material. The contract is structured as an Invitation for Bid (IFB), suggesting this is a price-driven procurement where awards will likely be made to the lowest responsive and responsible bidder(s).
View the file
Other files
| File | Type | Posted |
|---|---|---|
| IFB_0000032837_Question___Answer_Set__3.docx | DOCX document | |
| 3._IFB_Narrative_Response.docx | DOCX document | |
| IFB_0000032837_Addendum_Cover_Sheet.docx | DOCX document | |
| IFB_0000032837_Question__Answer_Set.docx | DOCX document | |
| IFB_0000032837_Addendum_3_Cover_Sheet.docx | DOCX document | |
| 00._APP_Front_Page.docx | DOCX document | |
| 1._Pricing_Worksheet.xlsx | XLSX spreadsheet | |
| 1._Pricing_Worksheet_Addendum_1.xlsx | XLSX spreadsheet | |
| 0._IFB_0000032837_Paper_Grocery_Bags.docx | DOCX document | |
| IFB_0000032837_Addendum_2_Cover_Sheet.docx | DOCX document | |
| IFB_0000032837_Question___Answer_Set__2.docx | DOCX document | |
| 0._IFB_0000032837_Paper_Grocery_Bags_Addendum_3.docx | DOCX document | |
| 2._Bid_Specification_8105-BS-0225773.pdf |
Show all 13
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
Pricing Worksheet Key
| PRICING WORKSHEET KEY | |||||||
| Column Name | Contract Line Item Number (CLIN) | ||||||
| UNSPSC Code | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | Unit of Measure | Quantity in | |
| Unit of Measure | lbs./BE | List Price/MSRP | Contract Unit Price | Contract Discount | |||
| 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). | Number of pounds per bundle | 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 %.
| Format | Variable Character | Number | Variable Character | Variable Character | Variable Character | Variable Character | Variable Character | Number | Currency | Currency | Percentage | |
| Example | 625 | 43211503 | PT-674344457 | HP | 4576543245-JH/4567C | HP Compaq 8710p Notebook PC | BOX | 10 | 50 | $2,500.00 | $1,650.00 | 66% |
| END OF SHEET. |
Paper Grocery Bags
| Department of General Services - Procurement Division | |||||||||||||
| Event ID: 0000032837, Paper Grocery Bags | |||||||||||||
| *Attachment 1 - Pricing Worksheet - Addendum 3, 2/13/2025* | |||||||||||||
| Bidder: | Blank | ||||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only. | |||||||||||||
| Order Size: 2 Bundles to 5,000 lbs | |||||||||||||
| Contract Line Item # (CLIN) | Estimated Quantity (Per Bag) Based on Historical Purchases | Commodity Description | UNSPSC Code | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | Unit of Measure (BN=Bundle) | Quantity in | ||||
| Unit of Measure (UOM) | lbs./BN | List Price/MSRP (Per BN) | Contract Discount① | Contract Unit Price | |||||||||
| (Per BN) | Price Per Bag② | Extension③ | |||||||||||
| 1 | 975,500 | Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 2 | 2,314,500 | Printed Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours" | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 3 | 1,791,500 | Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 4 | 1,294,000 | Printed Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours" | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 5 | 277,500 | Bag, Paper Grocery size #10 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 6 | 1,105,000 | Bag, Paper Grocery size #12 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 7 | 176,500 | Bag, Paper Grocery size #25 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 8 | 96,000 | Bag, Paper Grocery size #735 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Order Size: 5001 to 10,000 lbs | |||||||||||||
| Contract Line Item # (CLIN) | Estimated Quantity (Per Bag) Based on Historical Purchases | Commodity Description | UNSPSC Code | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | Unit of Measure (BN=Bundle) | Quantity in | ||||
| Unit of Measure (UOM) | lbs./BN | List Price/MSRP (Per BN) | Contract Discount① | Contract Unit Price | |||||||||
| (Per BN) | Price Per Bag② | Extension③ | |||||||||||
| 1A | 200,000 | Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 2A | 6,743,000 | Printed Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours" | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 3A | 154,500 | Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 4A | 3,877,000 | Printed Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours" | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 5A | 36,000 | Bag, Paper Grocery size #10 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 6A | 5,000 | Bag, Paper Grocery size #12 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 7A | 5,000 | Bag, Paper Grocery size #25 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Order Size: 10,001 lbs or more | |||||||||||||
| Contract Line Item # (CLIN) | Estimated Quantity (Per Bag) Based on Historical Purchases | Commodity Description | UNSPSC Code | Manufacturer Part Number (OEM #) | Manufacturer (OEM) | SKU # / Item # | Item Description | Unit of Measure (BN=Bundle) | Quantity in | ||||
| Unit of Measure (UOM) | lbs./BN | List Price/MSRP (Per BN) | Contract Discount① | Contract Unit Price | |||||||||
| (Per BN) | Price Per Bag② | Extension③ | |||||||||||
| 1B | 5,000 | Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 2B | 811,000 | Printed Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours" | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 3B | 813,500 | Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 4B | 3,738,000 | Printed Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours" | 24111502 | BN | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Grand Total Bid Price: | ERROR:#DIV/0! | ||||||||||||
| ①Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | |||||||||||||
| ②Price Per Bag is automatically calculated (Contract Unit Price / Quantity in UOM) | |||||||||||||
| ③Extension is automatically calculated (Price Per Bag x Estimated Quantity) | |||||||||||||
| End of Sheet |
Page &P
File details come from the government source that posted it. Updated .