1._Pricing_Worksheet.xlsx

XLSX spreadsheet 38 KB Posted

Attached to
Pudding Mix, Pudding Ready to Serve, Gelatin
Solicitation number
0000038924
Issued by
California

About this file

This is a Pricing Worksheet for a state and local contract opportunity issued by the Department of General Services - Procurement Division (Event ID: 0000038924) for the procurement of food service commodities across three distinct groups. Group 1 consists of instant pudding mix available in minimum flavors of chocolate, vanilla, lemon, and butterscotch, with an estimated quantity of 4,484 cases and 768 servings per case. Group 2 includes gelatin dessert powder in two categories: standard gelatin with 1,140 cases estimated (621 servings per case) and sugar-free gelatin with 1,260 cases estimated (3,072 servings per case), both available in cherry, lemon, lime, orange, raspberry, and strawberry flavors. Group 3 encompasses ready-to-serve pudding products in canned (#10 can) and cup formats, including banana, butterscotch, chocolate, lemon, tapioca, and vanilla flavors, with estimated quantities ranging from 28 to 3,452 cases depending on the specific product variant. All commodities are classified under UNSPSC Code 50193102 or 50192301 and are measured in cases as the unit of measure.

Bidders are required to complete the yellow input cells on the pricing worksheet, providing contract unit prices, MSRP/list prices where applicable, and calculated contract discounts. The contract discount is derived using the formula ((List Price/MSRP - Contract Unit Price) / List Price/MSRP), with extension prices calculated based on quantity multiplied by contract price adjusted for servings per case. The worksheet includes manufacturer brand, product code, and flavor requirements, with the note that additional flavors beyond the minimum required may be added to the contract if available. The document specifies that for pudding cups, products must contain the indicated ounce amounts with a maximum allowance of 2 ounces in excess of net contents specified, and awards will be made per each unit rather than per ounce.

View the file

Other files

File Type Posted
2._8950-TS-0308052.pdf PDF
8._Northern-Southern_Institution_Listing.docx DOCX document
3._8940-TS-0311998.pdf PDF
0._FAU_IFB_0000038924.docx DOCX document
00._APP_Front_Page.docx DOCX document
4._8940-TS-0312001.pdf PDF
5._Narrative_Response.xlsx XLSX spreadsheet
6._Estimated_Institution_Usage.xlsx XLSX spreadsheet
7._Food_Safety_Information_Listing.docx DOCX document

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 Product CodeFlavorsManufacturerSKU # / Item #Item DescriptionUnit of MeasureQuantity in

Unit of Measure

(If Applicable)List Price/MSRP (if applicable)Contract 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 minimum flavors required.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).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 %.

FormatVariable CharacterNumberVariable CharacterVariable CharacterVariable CharacterVariable CharacterVariable CharacterNumberCurrencyCurrencyPercentage
Example62543211503PT-674344457HP4576543245-JH/4567CHP Compaq 8710p Notebook PCBOX10$2,500.00$1,650.0066%
CORE - Often refers to a Fixed Price.
NON-CORE - Often refers to a Discount off List Price (i.e. MSRP, Index, etc.).
END OF SHEET.

Group 1, Pudding Mix

Department of General Services - Procurement Division
Event ID: 0000038924, Group 1, Pudding Mix
Attachment 1 - Pricing Worksheet, 4/29/2026
Bidder:
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
Contract Line Item # (CLIN)Estimated Quantity (Case)Commodity DescriptionUNSPSC CodeManufacturerBrandFlavorsManufacturer Product CodeUnit of MeasureEstimated Servings Per CaseServings Per CaseContract PriceMSRP/List Price (If Applicable)Contract DiscountExtension
14484Pudding, Instant (Estimated quantities based on 768/4oz servings per case). Shall be available in a minimum of chocolate, vanilla, lemon, and butterscotch flavors.50193102ChocolateCS768ERROR:#DIV/0!ERROR:#DIV/0!
Vanilla
Lemon
Butterscotch
TOTAL:ERROR:#DIV/0!
Note: Extension Price is calculated by (Quantity x Contract Price x (Estimated Servings per Case / Servings Per Case))
Note: Unit of Measure CS = Case
Note: Extension is automatically calculated (Contract Unit Price x Quantity)
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Flavors listed are the minimum required. Additional flavors may be added to the contract if available.
End of Sheet

Page &P

Group 2, Gelatin

Department of General Services - Procurement Division
Event ID: 0000038924, Group 2, Gelatin, Non-chill, Vegetarian
Attachment 1 - Pricing Worksheet, 04/29/2026
Bidder:Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
Contract Line Item # (CLIN)Estimated Quantity (Case)Commodity DescriptionUNSPSC CodeManufacturerBrandFlavorsManufacturer Product CodeUnit of MeasureEstimated Servings Per CaseServings Per CaseContract PriceMSRP/List Price (if applicable)Contract DiscountExtension
11140Gelatin Dessert Powder (Estimated quantities based on 621/4oz servings per case)50193102CherryCS621ERROR:#DIV/0!ERROR:#DIV/0!
Lemon
Lime
Orange
Raspberry
Strawberry
21260Gelatin Dessert Powder, Sugar Free (Estimated quantities based on 3072/4oz servings per case)50193102CherryCS3072ERROR:#DIV/0!ERROR:#DIV/0!
Lemon
Lime
Orange
Raspberry
Strawberry
TOTAL:ERROR:#DIV/0!
Note: Extension Price is calculated by (Quantity x Contract Price x (Estimated Servings per Case / Servings Per Case))
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: Quantities shown on CLIN 1 are based on 621/4 oz. servings per case
Note: Quantities shown on CLIN 2 are based on 3072/4 oz. servings per case
Note: Unit of Measure CS = Case
End of Sheet
End of Sheet

Page &P

Group 3, Pudding RTS

Department of General Services - Procurement Division
Event ID: 0000038924, Group 3, Pudding, Ready to Serve
Attachment 1 - Pricing Worksheet, 4/29/2026
Bidder:Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
Contract Line Item # (CLIN)Estimated Quantity (Case)Commodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeUnit of MeasureEstimated Items Per CaseOunces Per CupItems per caseContract PriceMRSP/List Price (if applicable)Contract DiscountExtension
12084Pudding, Banana, Canned (#10 can)50192301CS6ERROR:#DIV/0!ERROR:#DIV/0!
22530Pudding, Butterscotch, Canned (#10 can)50192301CS6ERROR:#DIV/0!ERROR:#DIV/0!
33230Pudding, Chocolate, Canned (#10 can)50192301CS6ERROR:#DIV/0!ERROR:#DIV/0!
428Pudding, Lemon, Canned (#10 can)50192301CS6ERROR:#DIV/0!ERROR:#DIV/0!
548Pudding, Tapioca, Canned (#10 can)50192301CS6ERROR:#DIV/0!ERROR:#DIV/0!
61456Pudding, Vanilla, Canned (#10 can)50192301CS6ERROR:#DIV/0!ERROR:#DIV/0!
73452Pudding, Chocolate
Quantities based on 48/3.5 oz. cups50192301CS48ERROR:#DIV/0!ERROR:#DIV/0!
82939Pudding, Vanilla
Quantites based on 48/3.5 oz. cups50192301CS48ERROR:#DIV/0!ERROR:#DIV/0!
TOTAL:ERROR:#DIV/0!
Note: Extension Price is calculated by (Quantity x Contract Price x (Estimated Items per Case / Items Per Case))
Note: Unit of Measure CS = Case
Note: Extension is automatically calculated (Contract Unit Price x Quantity)
Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP)
Note: The number of ounces indicated for each product is the minimum that is acceptable. Products will be considered if they are no greater than 2 oz. in excess of the net contents indicated.

However, award will be made per each, not per ounce. Please indicate number of ounces if different.

End of Sheet

Page &P

File details come from the government source that posted it. Updated .