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 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 NameContract Line Item Number (CLIN)
UNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of MeasureQuantity in
Unit of Measurelbs./BEList Price/MSRPContract Unit PriceContract Discount
DescriptionUnique 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.aspIdentifies 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 bundleAn 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 %.

FormatVariable CharacterNumberVariable CharacterVariable CharacterVariable CharacterVariable CharacterVariable CharacterNumberCurrencyCurrencyPercentage
Example62543211503PT-674344457HP4576543245-JH/4567CHP Compaq 8710p Notebook PCBOX1050$2,500.00$1,650.0066%
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 DescriptionUNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of Measure (BN=Bundle)Quantity in
Unit of Measure (UOM)lbs./BNList Price/MSRP (Per BN)Contract Discount*①*Contract Unit Price
(Per BN)*Price Per Bag②*Extension*③*
1*975,500Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773.24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
22,314,500Printed Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours"24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
31,791,500Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773.24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
41,294,000Printed Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours"24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
5277,500Bag, Paper Grocery size #10 per bid specification #8105-BS-0225773.24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
61,105,000Bag, Paper Grocery size #12 per bid specification #8105-BS-0225773.24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
7176,500Bag, Paper Grocery size #25 per bid specification #8105-BS-0225773.24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
896,000*Bag, Paper Grocery size #735 per bid specification #8105-BS-0225773.24111502BNERROR:#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 DescriptionUNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of Measure (BN=Bundle)Quantity in
Unit of Measure (UOM)lbs./BNList Price/MSRP (Per BN)Contract Discount*①*Contract Unit Price
(Per BN)*Price Per Bag②*Extension*③*
1A*200,000Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773.24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
2A6,743,000Printed Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours"24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3A154,500Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773.24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
4A3,877,000Printed Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours"24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
5A36,000Bag, Paper Grocery size #10 per bid specification #8105-BS-0225773.24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
6A5,000Bag, Paper Grocery size #12 per bid specification #8105-BS-0225773.24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
7A5,000*Bag, Paper Grocery size #25 per bid specification #8105-BS-0225773.24111502BNERROR:#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 DescriptionUNSPSC CodeManufacturer Part Number (OEM #)Manufacturer (OEM)SKU # / Item #Item DescriptionUnit of Measure (BN=Bundle)Quantity in
Unit of Measure (UOM)lbs./BNList Price/MSRP (Per BN)Contract Discount*①*Contract Unit Price
(Per BN)*Price Per Bag②*Extension*③*
1B*5,000Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773.24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
2B811,000Printed Bag, Paper Grocery size #6 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours"24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
3B813,500Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773.24111502BNERROR:#DIV/0!ERROR:#DIV/0!ERROR:#DIV/0!
4B3,738,000*Printed Bag, Paper Grocery size #8 per bid specification #8105-BS-0225773. Printed: "Must be Consumed within 4 Hours"24111502BNERROR:#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 .