1._Pricing_Worksheet_0000035398.xlsx

XLSX spreadsheet 38 KB Posted

Attached to
Cooking Fats and Oil
Solicitation number
0000035398
Issued by
California

About this file

This is a pricing worksheet for an Invitation For Bid (IFB) issued by the California Department of General Services, Procurement Division, for the establishment of a statewide contract to supply cooking fats and oils. The solicitation seeks qualified firms to provide margarine, shortening, and salad oil products to all State of California departments on a statewide basis. The contract is structured in two groups: Group 1 covers margarine and buttery spreads with estimated annual quantities of 246,011 pounds of margarine spread (90 portions per pound), 49,390 pounds of prints (1 pound units), and 91,750 pounds of bulk cube margarine (50-pound cubes); Group 2 covers shortening and salad oil with estimated annual quantities of 1,642 cases of salad oil (35 pounds per case), 909 cases of salad oil (4 one-gallon containers per case), 190,550 pounds of all-purpose shortening, and 23,800 pounds of liquid high-temperature shortening. The contract term is two years with two optional one-year extensions available.

The pricing worksheet requires bidders to complete pricing information in designated yellow cells, including manufacturer brand, product code, list prices, contract discounts, unit prices, and case prices. All line items are assigned UNSPSC Code 50151500 and pricing is calculated on a per-pound or per-case basis depending on the product category. The worksheet contains automatic calculation formulas for extension totals (contract unit price multiplied by estimated quantity) and case prices (contract unit price per pound multiplied by pounds per case). Bidders must reference the IFB pricing language for completion instructions. The unit of measure is indicated as either LB (pound) or CS (case) depending on the product category and packaging configuration.

View the file

Other files

File Type Posted
7._Northern-Southern_Institution_Listing.docx DOCX document
4._IFB_Narrative_Response_0000035398.xlsx XLSX spreadsheet
6._Food_Safety_Information_Listing.docx DOCX document
0.__IFB_0000035398.docx DOCX document
00._FAU_APP_Front_Page.docx DOCX document
3._8945-BS-0253977_(2).pdf PDF
2._8945-BS-0253977_(1).pdf PDF
5._Estimated_Institution_Usage.xlsx XLSX spreadsheet

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

Contract Line Item Number (CLIN)
Estimated QuantityCommodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeUnit of MeasureMSRP/List Price (if available)Contract DiscountContract Unit PriceExtensionLBS per CaseContract price per Case
Unique line item number.Estimated quantity ordered per year based on Unit of MeasureInformational 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.aspIdentifies the manufacturer's name for each line item.Identifies the manufacturer's name for each 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).An 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.This field will Auto populate
This field will carry the number of base units in the packaging of the products
(i.e. # of pencils in a box).This field will Auto populate
Variable CharacterVariable CharacterNumberNumber
HPHP Compaq 8710p Notebook PC1010

Group 1

Department of General Services - Procurement Division
Event ID: 0000035398, Cooking Fats and Oils
Attachment 1 - Pricing Worksheet
Bidder:Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Cells only.
Group 1: Margarine & Buttery Spread
Contract Line Item # (CLIN)Estimated Quantity (Pounds)Commodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeUnit of MeasureMSRP/List Price (if available)Contract DiscountContract Unit PriceExtensionLBs per CaseContract price per Case
1246,011Margarine Spread (Reddies) (90 portions per LB)50151500LBERROR:#DIV/0!$ - 0$ - 0
249,390Prints (1 LB)50151500LBERROR:#DIV/0!$ - 0$ - 0
391,750Bulk, Cube (50 LB cubes)50151500LBERROR:#DIV/0!$ - 0$ - 0
GROUP 1 TOTAL:$ - 0
Note: Extension is automatically calculated (Contract Unit Price per LB x Estimated Quantity)
Note: Contract price per Case is calculated by (Contact Unit price per LB x LB per Case)
Note: Unit of Measure LB = Pound

Page &P

Group 2

Department of General Services - Procurement Division
Event ID: 0000035398, Cooking Fats and Oils
Attachment 1 - Pricing Worksheet
Bidder:Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Cells only.
Group 2: Shortening and Salad Oil, Vegetable
Contract Line Item # (CLIN)Estimated Quantity (Cases)Commodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeUnit of MeasureMSRP/List Price (if available)Contract DiscountContract Unit PriceExtensionLBs per CaseContract Price per Case
11,642Salad Oil (35 LB / Case)50151500CSERROR:#DIV/0!$ - 0
2909Salad Oil (4/1 Gallon / Case)50151500CSERROR:#DIV/0!$ - 0
3190,550Shortening, All Purpose50151500LBERROR:#DIV/0!$ - 0$ - 0
423,800Shortening, Liquid, Hi Temp50151500LBERROR:#DIV/0!$ - 0$ - 0
GROUP 2 TOTAL:$ - 0
Note: Extension is automatically calculated (Contract Unit Price per Case x Estimated Quantity)
Price per Case = Contract Price per LB. x LBS. per Case
Note: Unit of Measure CS= Case
Note: Unit of Measure LB = Pound
End of Sheet

Page &P

Sheet3-to delete

Contract Line Item # (CLIN)Estimated Quantity (Cases)Commodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeUnit of MeasureEstimated LBS per CaseLBS. per CaseContract Price per CaseMSRP/List Price (if available)Contract DiscountExtensionPrice per LB
33,811Shortening, All Purpose (50 LB)50151500CS50ERROR:#DIV/0!$ - 0ERROR:#DIV/0!
4680Shortening, Liquid, Hi Temp (35 LB)50151500CS35ERROR:#DIV/0!$ - 0ERROR:#DIV/0!
Contract Line Item # (CLIN)Estimated Quantity (lb)Commodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeUnit of MeasureLBS. per CaseContract Price per LBMSRP/List Price (if available)Contract DiscountExtensionPrice per Case
3190,550Shortening, All Purpose (50 LB)50151500CSERROR:#DIV/0!$ - 0$ - 0
423,800Shortening, Liquid, Hi Temp (35 LB)50151500CSERROR:#DIV/0!$ - 0$ - 0
Contract Line Item # (CLIN)Estimated Quantity (Cases)Commodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeUnit of MeasureQuantity per CaseContract Price per CaseMSRP/List Price (if available)Contract DiscountExtension
11,642Salad Oil (35lb/cs)50151500CS35 LB.ERROR:#DIV/0!$ - 0
2909Salad Oil (4/1 Gallon/Case)50151500CS4/1 GalERROR:#DIV/0!$ - 0

Pricing Worksheet (og)

Department of General Services - Procurement Division
Event ID: 0000035398, Cooking Fats and Oils
Attachment 1 - Pricing Worksheet
Bidder:Blank
Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Cells only.
Group 1: Margarine & Buttery Spread
Contract Line Item # (CLIN)Estimated Quantity (Pounds)Commodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeUnit of MeasureLBs per CaseContract Unit Price per LBMSRP/List Price (if available)Contract DiscountExtensionContract price per Case
1246011Margarine Spread (Readies) (12lbs/case, 90 portions per lb)50151500LBERROR:#DIV/0!$ - 0$ - 0
249390Prints (1lb) (30lb/case)50151500LBERROR:#DIV/0!$ - 0$ - 0
391750Bulk, Cube (50lb bag in carton)50151500LBERROR:#DIV/0!$ - 0$ - 0
GROUP 1 TOTAL:$ - 0
Note: Extension is automatically calculated (Contract Unit Price per LB x Estimated Quantity)
Note: Contract price per Case is calculated by (Contact Unit price per LB x LB per Case)
Note: Unit of Measure LB = Pound
Group 2: Shortening and Salad Oil, Vegetable
Contract Line Item # (CLIN)Estimated Quantity (Cases)Commodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeUnit of MeasureQuantity per CaseContract Unit Price per CaseMSRP/List Price (if available)Contract DiscountExtension
11,642Salad Oil (35lb/cs)50151500CS35 LB.ERROR:#DIV/0!$ - 0
2909Salad Oil (4/1 Gallon/Case)50151500CS4/1 GalERROR:#DIV/0!$ - 0
Note: Extension is automatically calculated (Contract Unit Price per Case x Estimated Quantity)
Note: Unit of Measure CS= Case
Contract Line Item # (CLIN)Estimated Quantity (LB)Commodity DescriptionUNSPSC CodeManufacturerBrandManufacturer Product CodeUnit of MeasureLBs per CaseContract Unit Price per LBMSRP/List Price (if available)Contract DiscountExtensionContract Price per Case
3190,550Shortening, All Purpose50151500LBERROR:#DIV/0!$ - 0$ - 0
423,800Shortening, Liquid, Hi Temp50151500LBERROR:#DIV/0!$ - 0$ - 0
GROUP 2 TOTAL:$ - 0
Note: Extension is automatically calculated (Contract Unit Price per Case x Estimated Quantity)
Price per Case = Contract Price per LB. x LBS. per Case
Note: Unit of Measure LB = Pound
End of Sheet

Page &P

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