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 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 NameContract Line Item # (CLIN)Estimated QuantityUnit of MeasureQuantity in Unit of MeasureCommodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeNumber of Bowls/Packs Per CaseOunces Per PackCost Per OunceContract Unit Price/Bowl or BoxContract Unit Price/CaseExtensionCost Per BoxContract Unit Price/CSExtensionCost Per Box
DescriptionUnique line item number.Estimated quantity ordered per year based on Unit of MeasureUnit 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 basedInformational 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

FormatVariable CharacterNumberVariable CharacterVariable CharacterVariable CharacterVariable CharacterVariable CharacterNumber
Example62543211503PT-674344457HP4576543245-JH/4567CHP Compaq 8710p Notebook PCBOX10
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 QuantityUnit of MeasureQuantity in Unit of Measure (bowls)Commodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeContract Unit Price/CaseNumber of Bowls Per CaseContract Unit Price/BowlExtension
1-011,438Case96Corn Flakes/Plain, Bowl Pack (96/Case)50221201ERROR:#DIV/0!ERROR:#DIV/0!
1-021,710Case96Crisp Rice, Bowl Pack (96/Case)50221201ERROR:#DIV/0!ERROR:#DIV/0!
1-031,401Case96Bran Flakes Bowl Pack (96/Case)50221201ERROR:#DIV/0!ERROR:#DIV/0!
1-042,321Case96Raisin Bran Bowl Pack (96/Case)50221201ERROR:#DIV/0!ERROR:#DIV/0!
1-051,669Case96Toasted Oat Rings, Plain Bowl Pack (96/Case)50221201ERROR:#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 QuantityUnit of MeasureEstimated Quantity in Unit of Measure (ounces)Commodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeNumber of Packs Per CaseOunces Per PackContract Unit Price/CaseCost Per OunceExtension
2-0118,952Case320Corn Flakes Super Bulk Pack50221201ERROR:#DIV/0!ERROR:#DIV/0!
2-02250Case320Corn Flakes, Sugar Coated Super Bulk Pack50221201ERROR:#DIV/0!ERROR:#DIV/0!
2-03220Case320Toasted Oat Rings Honey Nut Super Bulk Pack50221201ERROR:#DIV/0!ERROR:#DIV/0!
2-041,006Case320Toasted Oat Rings, Plain Super Bulk Pack50221201ERROR:#DIV/0!ERROR:#DIV/0!
2-051,072Case320Fruit Rings Super Bulk Pack50221201ERROR:#DIV/0!ERROR:#DIV/0!
2-061681Case320Apple Rings Super Bulk Pack50221201ERROR:#DIV/0!ERROR:#DIV/0!
2-078,749Case320Bran Flakes Super Bulk Pack50221201ERROR:#DIV/0!ERROR:#DIV/0!
2-082546Case320Corn Puff Balls, Cocoa Super Bulk Pack50221201ERROR:#DIV/0!ERROR:#DIV/0!
2-093,859Case320Crisp Rice Super Bulk Pack50221201ERROR:#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 .