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 | ||
| 8._Northern-Southern_Institution_Listing.docx | DOCX document | |
| 3._8940-TS-0311998.pdf | ||
| 0._FAU_IFB_0000038924.docx | DOCX document | |
| 00._APP_Front_Page.docx | DOCX document | |
| 4._8940-TS-0312001.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 Name | Contract Line Item Number (CLIN) | ||||||
| UNSPSC Code | Manufacturer Product Code | Flavors | Manufacturer | SKU # / Item # | Item Description | Unit of Measure | Quantity in |
Unit of Measure
| (If Applicable) | List Price/MSRP (if applicable) | 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 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 %.
| 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 | $2,500.00 | $1,650.00 | 66% |
| 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 Description | UNSPSC Code | Manufacturer | Brand | Flavors | Manufacturer Product Code | Unit of Measure | Estimated Servings Per Case | Servings Per Case | Contract Price | MSRP/List Price (If Applicable) | Contract Discount | Extension |
| 1 | 4484 | Pudding, Instant (Estimated quantities based on 768/4oz servings per case). Shall be available in a minimum of chocolate, vanilla, lemon, and butterscotch flavors. | 50193102 | Chocolate | CS | 768 | ERROR:#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 Description | UNSPSC Code | Manufacturer | Brand | Flavors | Manufacturer Product Code | Unit of Measure | Estimated Servings Per Case | Servings Per Case | Contract Price | MSRP/List Price (if applicable) | Contract Discount | Extension |
| 1 | 1140 | Gelatin Dessert Powder (Estimated quantities based on 621/4oz servings per case) | 50193102 | Cherry | CS | 621 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| Lemon | ||||||||||||||
| Lime | ||||||||||||||
| Orange | ||||||||||||||
| Raspberry | ||||||||||||||
| Strawberry | ||||||||||||||
| 2 | 1260 | Gelatin Dessert Powder, Sugar Free (Estimated quantities based on 3072/4oz servings per case) | 50193102 | Cherry | CS | 3072 | ERROR:#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 Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | Estimated Items Per Case | Ounces Per Cup | Items per case | Contract Price | MRSP/List Price (if applicable) | Contract Discount | Extension | |
| 1 | 2084 | Pudding, Banana, Canned (#10 can) | 50192301 | CS | 6 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||
| 2 | 2530 | Pudding, Butterscotch, Canned (#10 can) | 50192301 | CS | 6 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||
| 3 | 3230 | Pudding, Chocolate, Canned (#10 can) | 50192301 | CS | 6 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||
| 4 | 28 | Pudding, Lemon, Canned (#10 can) | 50192301 | CS | 6 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||
| 5 | 48 | Pudding, Tapioca, Canned (#10 can) | 50192301 | CS | 6 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||
| 6 | 1456 | Pudding, Vanilla, Canned (#10 can) | 50192301 | CS | 6 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||
| 7 | 3452 | Pudding, Chocolate | |||||||||||||
| Quantities based on 48/3.5 oz. cups | 50192301 | CS | 48 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||||||
| 8 | 2939 | Pudding, Vanilla | |||||||||||||
| Quantites based on 48/3.5 oz. cups | 50192301 | CS | 48 | ERROR:#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 .