Attachment_1_-_Pricing_Worksheet.xlsx

This is a Pricing Worksheet for a State of California Department of General Services, Procurement Division (DGS-PD) Invitation for Bid (IFB) to establish a multi-year statewide contract for canned and pouched tuna products. The solicitation seeks bids from qualified firms to supply three line items: Tuna, Canned, Water pack (66.5 oz) with an estimated annual quantity of 2,064 cases; Tuna, Pouch Pack (43 oz) with an estimated annual quantity of 3,176 cases; and Tuna, Pouch Pack (2 oz) with an estimated annual quantity of 8,638 cases. All items are classified under UNSPSC code 50121538. The contract term is two years with two one-year extension options available. The award method is All or None, and the established contract is mandatory for use by all State of California departments statewide. The pricing worksheet is designed for bidders to complete only the yellow input cells, providing the List Price/MSRP, Contract Price per case, and resulting Contract Discount percentages for each line item.

The pricing worksheet contains formulas to calculate contract discounts using the formula ((List Price/MSRP – Contract Unit Price) / List Price/MSRP) and extension prices calculated as (Quantity × Contract Price × (Estimated Cans per Case / Cans Per Case)). The Unit of Measure for all line items is cases (CS), with the first two items containing 6 cans or pouches per case and the third item containing 100 pouches per case. The worksheet indicates that List Price/MSRP information must be independently verifiable and available to the general public. The document was prepared as of November 9, 2026, and bidders are instructed to refer to the IFB Pricing language for detailed completion instructions. The pricing worksheet currently displays calculation errors due to incomplete data entry in the input cells, which will be resolved once bidders submit their pricing information.