Attachment_1_-_Pricing_Worksheet.xlsx

This pricing worksheet is a completed attachment for a California Department of General Services, Procurement Division Invitation for Bid to establish a statewide contract for plastic trash bags with a three-year term and two one-year extension options. The solicitation seeks to procure two types of bags: Type I bags manufactured from LDPE/LLDPE materials and Type II bags manufactured from HDPE materials, available in various capacities ranging from 7 gallons to 60 gallons. The worksheet contains 45 Contract Line Items (CLINs) across both bag types, with 30 CLINs for Type I bags and 15 CLINs for Type II bags, specifying estimated three-year quantities per unit of measure, detailed product specifications including dimensions, thickness, load ratings, colors, and seal types, and quantities per case for each line item. All line items are quoted in cases as the unit of measure, with estimated quantities ranging from 215 to 49,754 units over the three-year contract period.

The pricing worksheet is designed for bidders to complete only the yellow-highlighted input cells, specifically the List Price/MSRP, Contract Discount percentage, and Contract Unit Price for each line item, with the extension amount automatically calculated by multiplying the contract unit price by the quantity. The document indicates that contract discounts are derived from the formula ((List Price/MSRP – Contract Unit Price) / List Price/MSRP), and extensions represent the total cost for each line item. The pricing worksheet shows error messages in all discount and extension columns, indicating that pricing data has not yet been entered by the bidder. As a statewide contract, use is mandatory for all State of California departments and available for local governmental agencies, with an "All or None" award methodology requiring bidders to submit pricing for all line items.