1._Pricing_Worksheet_0000035493.xlsx

XLSX spreadsheet 19 KB Posted

Attached to
Condiments, Individual Serving Packets (FAU25-89-13)
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 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 NameContract Line Item Number (CLIN)
Estimated QuantityCommodity DescriptionUNSPSC CodeManufacturer Product CodeManufacturerBrandManufacturer Product CodeUnit of MeasureEstimated Packets per CasePackets per caseList Price/MSRPContract DiscountContract Price per caseExtension
DescriptionUnique line item number.Estimated quantity ordered per year based on Unit of MeasureInformational 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 itemIdentifies 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 QuantityThe number of packets per case offeredAn 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
FormatVariable CharacterNumberVariable CharacterNumberVariable CharacterVariable CharacterVariable CharacterVariable CharacterVariable CharacterNumberNumberCurrencyCurrency
Example20345Pita Bread12345678PT-674344457BellPureSweetTPD-610DZ100120$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 DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeUnit of MeasureEstimated Packets per CasePackets per caseList Price/MSRPContract DiscountContract Price per caseExtension
15011Dressing, French (500/cs)50171832CS500ERROR:#DIV/0!ERROR:#DIV/0!
214124Dressing, Italian (500/cs)50171832CS500ERROR:#DIV/0!ERROR:#DIV/0!
310100Dressing, 1000 Island (500/cs)50171832CS500ERROR:#DIV/0!ERROR:#DIV/0!
45872Dressing, Ranch (500/cs)50171832CS500ERROR:#DIV/0!ERROR:#DIV/0!
59800Catsup (1000/cs)50171830CS1000ERROR:#DIV/0!ERROR:#DIV/0!
66455Mustard (1000/cs)50171830CS1000ERROR:#DIV/0!ERROR:#DIV/0!
72586Mayonnaise (500/cs)50171830CS500ERROR:#DIV/0!ERROR:#DIV/0!
83972Relish, Pickle (500/cs)50171830CS500ERROR:#DIV/0!ERROR:#DIV/0!
913600Taco Sauce (500/cs)50171830CS500ERROR:#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 .