Attachment_1_-_Pricing_Worksheet.xlsx

XLSX spreadsheet 26 KB Posted

Attached to
Frozen Vegetables
Solicitation number
0000038871
Issued by
California

About this file

This is a Pricing Worksheet prepared by the California Department of General Services, Procurement Division for a statewide Invitation for Bid (IFB) to establish a multi-year contract for frozen vegetables. The solicitation encompasses fourteen line items of frozen vegetable products with a two-year initial contract term and two one-year extension options. The frozen vegetables requested include beans, broccoli, carrots, corn, mixed vegetables, peas, cauliflower, onions, peppers, spinach, turnip greens, and zucchini. The estimated two-year quantities range from 33,428 pounds for turnip greens to 2,644,468 pounds for broccoli, with total estimated purchases of approximately 12.5 million pounds across all commodities. All State of California departments are mandated to use the awarded contract. The method of award is "All or None," meaning bidders must provide pricing for all fourteen line items to be considered.

The pricing worksheet requires bidders to complete yellow input cells for manufacturer information, package size, list price or MSRP, contract discount, and contract unit price for each commodity. The contract unit price and extension calculations are automatically derived from the list price and discount percentages submitted. Each line item is assigned a United Nations Standard Products and Services Code (UNSPSC) for standardized commodity classification. The worksheet indicates that bidders should refer to the IFB pricing language for specific completion instructions. Currently, the pricing fields display errors and zero values, indicating that this is a blank template awaiting bidder submissions. All commodities are measured in pounds as the unit of measure.

View the file

Other files

File Type Posted
Attachment_7_-_Northern-Southern_Institution_Listing.docx DOCX document
Attachment_5_-_Estimated_Institution_Usage.xlsx XLSX spreadsheet
Attachment_2_-_8915-TS-0305809.pdf PDF
Attachment_6_-_Food_Safety_Information_Listing.docx DOCX document
Attachment_3_-_Narrative_Response.xlsx XLSX spreadsheet
0_IFB_Event_ID_0000038871.docx DOCX document
00_APP_Front_Page.docx DOCX document
Attachment_4_-_Food_Special_Provisions.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 QuantityCommodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodePackage sizeList Price/MSRPContract DiscountContract Unit PriceExtension
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 the manufacturer's name for each line item.Identifies brand name for each line itemIdentifies manufacturer's unique identifier for a particular line item.Pounds per Case, Pounds per subunit and number of subunits if case is dividedAn independently verifiable price available to the general public.
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 %.This is the proposed contractual price for a given line item, as relative to the
unit of measure.Calculated extended price for evaluatiion
FormatVariable CharacterNumberVariable CharacterVariable CharacterVariable CharacterVariable CharacterVariable CharacterVariable CharacterCurrencyPercentageCurrencyCurrency
Example1345Pita Bread43211503BellPureSweetTPD-6106/5 LB$2.5040%$1.50$517.50
END OF SHEET.

Pricing Worksheet

Department of General Services - Procurement Division
Event ID: 0000038871, Frozen Vegetables
Attachment 1 - Pricing Worksheet, 8/14/2026
Bidder:Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only.
Contract Line Item # (CLIN)2 Year Estimated Quantity
(LBS)Commodity DescriptionUNSPSCManufacturerBrandManufacturer Product CodePackage sizeUnit of Measure (UOM)List Price/MSRPContract DiscountContract Unit PriceExtension
11,183,172Beans, Green, Cut, Min. 1", (lb.)50441800LBERROR:#DIV/0!$ - 0
22,644,468Broccoli, Cuts, (lb.)50442000LBERROR:#DIV/0!$ - 0
32,456,412Carrots, Diced, (lb.)50442500LBERROR:#DIV/0!$ - 0
449,500Carrots, Sliced, (lb.)50442500LBERROR:#DIV/0!$ - 0
52,058,464Corn, Cut, (lb.)50443200LBERROR:#DIV/0!$ - 0
6643,306Mixed Vegetables, Standard Assortment, (lb.)50440000LBERROR:#DIV/0!$ - 0
7266,456Peas, Green, (lb.)50445400LBERROR:#DIV/0!$ - 0
8980,122Peas & Carrots, (lb.)50440000LBERROR:#DIV/0!$ - 0
9266,200Cauliflower, (lb.)50442600LBERROR:#DIV/0!$ - 0
10718,436Onions, Chopped, Frozen, (lb.)50445200LBERROR:#DIV/0!$ - 0
11560,042Peppers, Bell, Green, Diced or Sliced, (lb.)50445515LBERROR:#DIV/0!$ - 0
1252,072Spinach, Chopped, (lb.)50446100LBERROR:#DIV/0!$ - 0
1333,428Turnip Greens, (lb.)50446500LBERROR:#DIV/0!$ - 0
14495,280Zucchini, (lb.)50446229LBERROR:#DIV/0!$ - 0
TOTAL:$ - 0
Note: Unit of Measure LB = Pound
Note: Extension is automatically calculated (Contract Unit Price x Estimated Quantity)
End of Sheet

Page &P

File details come from the government source that posted it. Updated .