1._Pricing_Worksheet_Addendum_1.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 from the California Department of General Services - Procurement Division for Paper Grocery Bags (Event ID: 0000032837). The document outlines pricing requirements for various sizes of paper grocery bags (#6, #8, #10, #12, #25, and #735) with some requiring special printing ("Must be Consumed within 4 Hours"). The quantities are broken down into three order size categories: 2 Bundles to 5,000 lbs, 5,001 to 10,000 lbs, and 10,001 lbs or more, with estimated quantities ranging from 5,000 to 6,743,000 bags depending on the size and category.
The pricing worksheet requires bidders to complete yellow input cells with information including manufacturer part numbers, SKU numbers, list prices/MSRP per bundle, and contract unit prices. All items are classified under UNSPSC Code 24111502, with bundle (BN) as the unit of measure. The worksheet automatically calculates the contract discount ((List Price - Contract Price)/List Price), price per bag, and total extensions. Bidders must provide pricing that aligns with specification #8105-BS-0225773 for all paper grocery bag sizes.
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 | |
| 1._Pricing_Worksheet_Addendum_3.xlsx | XLSX spreadsheet | |
| IFB_0000032837_Addendum_3_Cover_Sheet.docx | DOCX document | |
| 00._APP_Front_Page.docx | DOCX document | |
| 1._Pricing_Worksheet.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 1, 2/7/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 .