1._Pricing_Worksheet_0000034575.xlsx
XLSX spreadsheet 27 KB Posted
- Attached to
- Mexican Entrees; Tortillas FAU25-89
- Solicitation number
- 0000034575
- Issued by
- California
About this file
This is a Pricing Worksheet for the Department of General Services - Procurement Division, associated with Event ID 0000034575, covering a solicitation for Mexican Entrees and Tortillas. The procurement is structured across two product groups: Group 1 includes Frozen Burritos (Bean & Cheese) and Frozen Chicken and Cheese Enchiladas, with a total estimated annual quantity of 18,012 dozen Burritos, 8,288 dozen Chicken Enchiladas, and 18,644 dozen Cheese Enchiladas. Group 2 covers Tortillas, including Fresh and Frozen Corn and Flour Tortillas, with estimated quantities across four line items, each with 288 tortillas per case.
The pricing worksheet indicates a one-year contract term with a total estimated value of $443,104.00 for the Mexican Entrees group, though the Tortillas group's total value calculation shows an error. The document requires bidders to complete yellow input cells, providing details on manufacturer brands, product codes, unit of measure, and pricing. The worksheet uses standard procurement formatting, including UNSPSC codes for product categorization, and allows for contract unit pricing and discounts. The solicitation appears to be for institutional food service procurement, likely for schools, hospitals, or other government facilities, with a focus on frozen Mexican cuisine and tortilla products.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 0._FAU_IFB_0000034575.docx | DOCX document | |
| 6._Food_Safety_Information_Listing.docx | DOCX document | |
| 3._8920-BS-0250176.pdf | ||
| 5._Estimated_Institution_Usage.xlsx | XLSX spreadsheet | |
| 00._FAU_APP_Front_Page.docx | DOCX document | |
| 7._Northern-Southern_Institution_Listing.docx | DOCX document | |
| 4._Narrative_Response_0000034575.docx | DOCX document | |
| 2._8940-BS-0243653.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 | Manufacture | Brand | Manufacturer Product Code | Unit of Measure | Quantity in |
Unit of Measure
| (If Applicable) | Units Per Case | List Price/MSRP | Contract Unit Price | Contract Discount | Extension |
| Description | Unique line item number. | Number of estimated units of the commodity for evaluation purposes. | Description of the commodity being purchased. | 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 the manufacturer's name for each line item. | Identifies the brand name of the line item. | Identifies manufacturer's unique identifier for a particular line item. | 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). | Describes how many units of the commodity are packaged in a case. | An independently verifiable public price available to the general public. | |||
| (if available) | 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 %. | Calculated extended price for evaluation purposes. | ||||||||||
| Format | Variable Character | Number | Variable Character | Variable Character | Variable Character | Number | Currency | Currency | Percentage | Variable Character | |
| Example | 625 | 43211503 | PT-674344457 | HP | BOX | 10 | $2,500.00 | $1,650.00 | 66% | A | |
| 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. |
0000034575 Pricing Worksheet
| Department of General Services - Procurement Division | |||||||||||||
| Event ID: 0000034575, Mexican Entrees; Tortillas | |||||||||||||
| Attachment 1 - Pricing Worksheet, 8/19/2025 | |||||||||||||
| Bidder: | Blank | ||||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only. | |||||||||||||
| Group 1: Mexican Entrees | |||||||||||||
| Contract Line Item # (CLIN) | 1 year Estimated Quantity (per UOM) | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure (UOM) | Quantity in Unit of Measure | Units per Case | MSRP/List Price (if available) | Contract Discount | Contract Unit Price | Extension |
| 1 | 18012 | Burrito, Bean & Cheese, Red or Green Chile, Frozen, 5 oz. | 50192702 | DZ | 12 | ERROR:#DIV/0! | $ 20.0000 | $ 360,240.0000 | |||||
| 2 | 8288 | Enchilada, Chicken, Frozen, 2 oz. | 50192702 | DZ | 12 | ERROR:#DIV/0! | $ 1.0000 | $ 8,288.00 | |||||
| 3 | 18644 | Enchilada, Cheese, Frozen, 2 oz. | 50192702 | DZ | 12 | ERROR:#DIV/0! | $ 4.0000 | $ 74,576.00 | |||||
| TOTAL: | $ 443,104.00 | ||||||||||||
| Note: Extension is automatically calculated (Contract Unit Price x Quantity) | |||||||||||||
| Note: Unit of Measure DZ = Dozen |
| Group 2: Tortillas | |||||||||||||
| Contract Line Item # (CLIN) | 1 year Estimated Quantity (per UOM) | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure (UOM) | Estimated Tortillas per Case | Tortillas per case | MSRP/List Price (if available) | Contract Discount | Contract Price Per Case | Extension |
| 1 | 3734 | Tortilla, Corn, Fresh | 50193301 | CS | 288 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 2 | 18595 | Tortilla, Corn, Frozen | 50193301 | CS | 288 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 3 | 3765 | Tortilla, Flour, Fresh | 50193300 | CS | 288 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 4 | 27542 | Tortilla, Flour, Frozen | 50193300 | CS | 288 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| TOTAL: | ERROR:#DIV/0! | ||||||||||||
| Note: Extension Price is calculated by (Quantity x Contract Price x (Estimated Tortillas per Case / Tortillas Per Case)) | |||||||||||||
| Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | |||||||||||||
| Note: Unit of Measure CS = Case | |||||||||||||
| End of Sheet |
Page &P
File details come from the government source that posted it. Updated .