1._Pricing_Worksheet_0000035493.xlsx
XLSX spreadsheet 19 KB Posted
- Solicitation number
- 0000035493
- Issued by
- California
About this file
This is a Pricing Worksheet for the Department of General Services Procurement Division, Event ID 0000035493, soliciting bids for condiment individual serving packets. The worksheet details nine line items of condiment products, including French, Italian, and 1000 Island dressings, Ranch dressing, catsup, mustard, mayonnaise, pickle relish, and taco sauce. Each product is specified in case quantities ranging from 500 to 1000 packets per case, with estimated annual quantities for each item. The procurement appears to be for individual serving packets, likely for institutional food service settings such as cafeterias, schools, or other large-scale dining facilities.
The pricing worksheet is structured to capture detailed pricing information, including UNSPSC codes, manufacturer brands, product codes, and unit of measure. The document includes calculation fields for contract discounts and extension pricing, though the current worksheet shows "ERROR:#DIV/0!" placeholders, indicating that bidders must complete the yellow input cells with their specific pricing details. The unit of measure is consistently set as "CS" (case), and the worksheet provides a framework for vendors to submit competitive pricing for the condiment product line, with calculations to determine the most cost-effective proposal based on list price, contract discount, and total extension pricing.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 00._FAU_APP_Front_Page.docx | DOCX document | |
| 4._Estimated_Institution_Usage.xlsx | XLSX spreadsheet | |
| 3._Narrative_Response_0000035493.docx | DOCX document | |
| 0._IFB_0000035493.docx | DOCX document | |
| 5._Food_Safety_Information_Listing.docx | DOCX document | |
| 6._Northern-Southern_Institution_Listing.docx | DOCX document | |
| 2._8950-BS-0252793.pdf |
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) | |||||||||||||||
| Estimated Quantity | Commodity Description | UNSPSC Code | Manufacturer Product Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | Estimated Packets per Case | Packets per case | List Price/MSRP | Contract Discount | Contract Price per case | Extension | |||
| Description | Unique line item number. | Estimated quantity ordered per year based on Unit of Measure | Informational text about the commodity being purchased. | The United Nations Standard Products and Services Code. A global multi-sector standard for efficient, accurate classification of products and services. | Identifies manufacturer's unique identifier for a particular line item. | Identifies the manufacturer's name for each line item. | Identifies brand name for each line item | Identifies manufacturer's unique identifier for a particular line item. | Descriptor of the unit used for Quantity and Contract Unit Price (i.e. each, box, dozen, case, lbs, pallet etc). | The number of packets per case used for purposes of determing the Estimated Quantity | The number of packets per case offered | An independently verifiable public price available to the general public. (If available) | For commodities with a fixed price structure, discount is derived based on the following calculation: ((List Price - Contract Price)/List Price) = Contract Discount %. | This is the contractual price for a given line item based on the price that was bid, as relative to the | ||
| unit of measure. | Calculated extended price for evaluatiion | |||||||||||||||
| Format | Variable Character | Number | Variable Character | Number | Variable Character | Variable Character | Variable Character | Variable Character | Variable Character | Number | Number | Currency | Currency | |||
| Example | 20 | 345 | Pita Bread | 12345678 | PT-674344457 | Bell | PureSweet | TPD-610 | DZ | 100 | 120 | $1,650.00 | $ 474,375.00 | |||
| END OF SHEET. |
Pricing Worksheet
| Department of General Services - Procurement Division | |||||||||||||
| Event ID: 0000035493, Condiments, Individual Serving Packets | |||||||||||||
| Attachment 1 - Pricing Worksheet | |||||||||||||
| Bidder: | Blank | ||||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only. | |||||||||||||
| Contract Line Item # (CLIN) | 1 Year Estimated Quantity (per case) | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | Estimated Packets per Case | Packets per case | List Price/MSRP | Contract Discount | Contract Price per case | Extension |
| 1 | 5011 | Dressing, French (500/cs) | 50171832 | CS | 500 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 2 | 14124 | Dressing, Italian (500/cs) | 50171832 | CS | 500 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 3 | 10100 | Dressing, 1000 Island (500/cs) | 50171832 | CS | 500 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 4 | 5872 | Dressing, Ranch (500/cs) | 50171832 | CS | 500 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 5 | 9800 | Catsup (1000/cs) | 50171830 | CS | 1000 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 6 | 6455 | Mustard (1000/cs) | 50171830 | CS | 1000 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 7 | 2586 | Mayonnaise (500/cs) | 50171830 | CS | 500 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 8 | 3972 | Relish, Pickle (500/cs) | 50171830 | CS | 500 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 9 | 13600 | Taco Sauce (500/cs) | 50171830 | CS | 500 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| TOTAL: | ERROR:#DIV/0! | ||||||||||||
| Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | |||||||||||||
| Note: Extension Price is calculated by (Estimated Quantity x Contract Price per case x (Estimated Cans per Case / Cans Per Case)) | |||||||||||||
| Note: Unit of Measure CS = Case | |||||||||||||
| Note: Extension is automatically calculated (Contract Unit Price x Quantity) | |||||||||||||
| End of Sheet |
Page &P
File details come from the government source that posted it. Updated .