1._Pricing_Worksheet.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- 25-81-03 Paper Grocery Bags
- Solicitation number
- 0000032837
- Issued by
- California
About this file
This is a pricing worksheet from the Department of General Services - Procurement Division for Paper Grocery Bags (Event ID: 0000032837) with a contract end date of 1/31/2025. The solicitation seeks various sizes of paper grocery bags including #6, #8, #10, #12, #25, and #735, with some requiring special printing ("Must be Consumed within 4 Hours"). The quantities are divided into three order size tiers: 2 Bundles to 5,000 lbs, 5,001 to 10,000 lbs, and 10,001 lbs or more. Historical purchase quantities vary significantly by size and tier, ranging from 10 bundles to over 13,000 bundles.
The pricing worksheet requires bidders to input manufacturer information, part numbers, SKU numbers, list prices/MSRP, and contract unit prices per bundle. All items are classified under UNSPSC code 24111502. The worksheet automatically calculates contract discounts ((List Price - Contract Price)/List Price) and extensions (Contract Unit Price x Quantity). The file includes detailed formatting instructions and requires bidders to complete only the designated yellow input cells for pricing submission.
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_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, 1/31/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) | Quantity (per Bundle) 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 | lbs./BN | List Price/MSRP (Per BN) | Contract Discount | Contract Unit Price | ||||||||
| (Per BN) | Extension | |||||||||||
| 1 | 1,951 | Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 2 | 4,629 | Printed Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours" | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 3 | 3,583 | Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 4 | 2,588 | Printed Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours" | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 5 | 555 | Bag, Paper Grocery size #10 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 6 | 2,210 | Bag, Paper Grocery size #12 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 7 | 353 | Bag, Paper Grocery size #25 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 8 | 192 | Bag, Paper Grocery size #735 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| Order Size: 5001 to 10,000 lbs | ||||||||||||
| Contract Line Item # (CLIN) | Quantity (per Bundle) 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 | lbs./BN | List Price/MSRP (Per BN) | Contract Discount | Contract Price | ||||||||
| (Per BN) | Extension | |||||||||||
| 1A | 400 | Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 2A | 13,486 | Printed Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours" | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 3A | 309 | Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 4A | 7,754 | Printed Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours" | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 5A | 72 | Bag, Paper Grocery size #10 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 6A | 10 | Bag, Paper Grocery size #12 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 7A | 10 | Bag, Paper Grocery size #25 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| Order Size: 10,001 lbs or more | ||||||||||||
| Contract Line Item # (CLIN) | Quantity (per Bundle) 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 | lbs./BN | List Price/MSRP (Per BN) | Contract Discount | Contract Price | ||||||||
| (Per BN) | Extension | |||||||||||
| 1B | 10 | Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 2B | 1,622 | Printed Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours" | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 3B | 1,627 | Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| 4B | 7,476 | Printed Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours" | 24111502 | BN | ERROR:#DIV/0! | $ - 0 | ||||||
| Grand Total Bid Price: | $ - 0 | |||||||||||
| Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | ||||||||||||
| Note: Extension is automatically calculated (Contract Unit Price x Quantity) | ||||||||||||
| End of Sheet |
Page &P
File details come from the government source that posted it. Updated .