1._Pricing_Worksheet_0000034481.xlsx
XLSX spreadsheet 29 KB Posted
- Attached to
- Cereal, Dry, Ready to Eat (FAU25-89-110)
- Solicitation number
- 0000034481
- Issued by
- California
About this file
The document is a Pricing Worksheet for a Department of General Services - Procurement Division contract (Event ID: 0000034481) for Ready to Eat Cereal, divided into two distinct groups. Group 1 covers individual bowl packs and Group 2 covers single bag super bulk packs in the 16-33 pound range, with multiple cereal varieties including Corn Flakes, Crisp Rice, Bran Flakes, Raisin Bran, Toasted Oat Rings, Sugar Coated Corn Flakes, Honey Nut Toasted Oat Rings, Fruit Rings, Apple Rings, and Corn Puff Balls. The estimated quantities vary by product, with Group 1 ranging from 1,401 to 2,321 cases of 96-bowl packs, and Group 2 ranging from 220 to 18,952 cases of 320-ounce super bulk packs.
The pricing worksheet is structured to allow bidders to complete yellow cells with unit pricing, with automatic calculations for extension costs. Each line item includes a UNSPSC code of 50221201, indicating a standardized product classification. The worksheet provides detailed instructions for pricing, including requirements to enter prices in dollars and cents to no more than four decimal points. While specific pricing has not been completed in this document, the worksheet is designed to capture comprehensive pricing details for each cereal variety, enabling a thorough competitive bidding process for the government procurement.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 00._APP_Front_Page.docx | DOCX document | |
| 4._Estimated_Institution_Usage.xlsx | XLSX spreadsheet | |
| 5._Food_Safety_Information_Listing.docx | DOCX document | |
| 2._8920-BS-0235699.pdf | ||
| 3._Narrative_Response_0000034481.docx | DOCX document | |
| 0._IFB_0000034481.docx | DOCX document | |
| 6._Northern-Southern_Institution_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 # (CLIN) | Estimated Quantity | Unit of Measure | Quantity in Unit of Measure | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Number of Bowls/Packs Per Case | Ounces Per Pack | Cost Per Ounce | Contract Unit Price/Bowl or Box | Contract Unit Price/Case | Extension | Cost Per Box | Contract Unit Price/CS | Extension | Cost Per Box |
| Description | Unique line item number. | Estimated quantity ordered per year based on Unit of Measure | Unit of Measure - Descriptor of the packaging unit (i.e. each, box, dozen, case, lbs, ozs etc). | The number of units (boxes/bowls/ounces) per case on which the Estimated Quantity is based | Informational text about the commodity being purchased. Description should be descriptive enough to show the item is consistent with the specifications (high-level). | 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 supplier's unique identifier for a particular line item. Identifies the manufacturer's name for each line item. Identifies supplier's unique identifier for a particular line item. This field will carry the number of packs in each case. This field will carry the number of ounces in each pack. This field identifies the calculated cost per ounce This field identifies the calculated price per bowl/box and cost per ounce Enter price in dollars and cents only to no more than 4 decimal points This field will Auto populate
| Format | Variable Character | Number | Variable Character | Variable Character | Variable Character | Variable Character | Variable Character | Number |
| Example | 625 | 43211503 | PT-674344457 | HP | 4576543245-JH/4567C | HP Compaq 8710p Notebook PC | BOX | 10 |
| END OF SHEET. |
Cereal Group 1
| Department of General Services - Procurement Division | ||||||||||||
| Event ID: 0000034481, Cereal, Ready to Eat | ||||||||||||
| Attachment 1 - Pricing Worksheet | ||||||||||||
| Bidder: | ` | Blank | ||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Cells only. | ||||||||||||
| Group 1 - Individual Bowl | ||||||||||||
| Contract Line Item # (CLIN) | Estimated Quantity | Unit of Measure | Quantity in Unit of Measure (bowls) | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Contract Unit Price/Case | Number of Bowls Per Case | Contract Unit Price/Bowl | Extension |
| 1-01 | 1,438 | Case | 96 | Corn Flakes/Plain, Bowl Pack (96/Case) | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| 1-02 | 1,710 | Case | 96 | Crisp Rice, Bowl Pack (96/Case) | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| 1-03 | 1,401 | Case | 96 | Bran Flakes Bowl Pack (96/Case) | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| 1-04 | 2,321 | Case | 96 | Raisin Bran Bowl Pack (96/Case) | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| 1-05 | 1,669 | Case | 96 | Toasted Oat Rings, Plain Bowl Pack (96/Case) | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | |||||
| GROUP 1 TOTAL: | ERROR:#DIV/0! | |||||||||||
| Note: Extension is automatically calculated (Contract Unit Price/Box x (Estimated Quantity x Quantity (bowls) in Unit of Measure)) | ||||||||||||
| End of Sheet |
Cereal Group 2
| Department of General Services - Procurement Division | |||||||||||||
| Event ID: 0000034481, Cereal, Ready to Eat | |||||||||||||
| Attachment 1 - Pricing Worksheet | |||||||||||||
| Bidder: | Blank | ||||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Cells only. | |||||||||||||
| Group 2 - Single Bag, Super Bulk Pack, 16 - 33 Pound Range | |||||||||||||
| Contract Line Item # (CLIN) | Estimated Quantity | Unit of Measure | Estimated Quantity in Unit of Measure (ounces) | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Number of Packs Per Case | Ounces Per Pack | Contract Unit Price/Case | Cost Per Ounce | Extension |
| 2-01 | 18,952 | Case | 320 | Corn Flakes Super Bulk Pack | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 2-02 | 250 | Case | 320 | Corn Flakes, Sugar Coated Super Bulk Pack | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 2-03 | 220 | Case | 320 | Toasted Oat Rings Honey Nut Super Bulk Pack | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 2-04 | 1,006 | Case | 320 | Toasted Oat Rings, Plain Super Bulk Pack | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 2-05 | 1,072 | Case | 320 | Fruit Rings Super Bulk Pack | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 2-06 | 1681 | Case | 320 | Apple Rings Super Bulk Pack | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 2-07 | 8,749 | Case | 320 | Bran Flakes Super Bulk Pack | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 2-08 | 2546 | Case | 320 | Corn Puff Balls, Cocoa Super Bulk Pack | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| 2-09 | 3,859 | Case | 320 | Crisp Rice Super Bulk Pack | 50221201 | ERROR:#DIV/0! | ERROR:#DIV/0! | ||||||
| GROUP 2 TOTAL: | ERROR:#DIV/0! | ||||||||||||
| Note: Extension is automatically calculated (Cost Per Ounce x (Estimated Quantity x Ounces in Unit of Measure)) | |||||||||||||
| End of Sheet |
File details come from the government source that posted it. Updated .