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 | ||
| 2._8945-BS-0253977_(1).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 Quantity | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | MSRP/List Price (if available) | Contract Discount | Contract Unit Price | Extension | LBS per Case | Contract price per Case |
| Unique line item number. | Estimated quantity ordered per year based on Unit of Measure | 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 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 Character | Variable Character | Number | Number |
| HP | HP Compaq 8710p Notebook PC | 10 | 10 |
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 Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | MSRP/List Price (if available) | Contract Discount | Contract Unit Price | Extension | LBs per Case | Contract price per Case |
| 1 | 246,011 | Margarine Spread (Reddies) (90 portions per LB) | 50151500 | LB | ERROR:#DIV/0! | $ - 0 | $ - 0 | ||||||
| 2 | 49,390 | Prints (1 LB) | 50151500 | LB | ERROR:#DIV/0! | $ - 0 | $ - 0 | ||||||
| 3 | 91,750 | Bulk, Cube (50 LB cubes) | 50151500 | LB | ERROR:#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 Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | MSRP/List Price (if available) | Contract Discount | Contract Unit Price | Extension | LBs per Case | Contract Price per Case |
| 1 | 1,642 | Salad Oil (35 LB / Case) | 50151500 | CS | ERROR:#DIV/0! | $ - 0 | |||||||
| 2 | 909 | Salad Oil (4/1 Gallon / Case) | 50151500 | CS | ERROR:#DIV/0! | $ - 0 | |||||||
| 3 | 190,550 | Shortening, All Purpose | 50151500 | LB | ERROR:#DIV/0! | $ - 0 | $ - 0 | ||||||
| 4 | 23,800 | Shortening, Liquid, Hi Temp | 50151500 | LB | ERROR:#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 Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | Estimated LBS per Case | LBS. per Case | Contract Price per Case | MSRP/List Price (if available) | Contract Discount | Extension | Price per LB |
| 3 | 3,811 | Shortening, All Purpose (50 LB) | 50151500 | CS | 50 | ERROR:#DIV/0! | $ - 0 | ERROR:#DIV/0! | ||||||
| 4 | 680 | Shortening, Liquid, Hi Temp (35 LB) | 50151500 | CS | 35 | ERROR:#DIV/0! | $ - 0 | ERROR:#DIV/0! | ||||||
| Contract Line Item # (CLIN) | Estimated Quantity (lb) | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | LBS. per Case | Contract Price per LB | MSRP/List Price (if available) | Contract Discount | Extension | Price per Case | |
| 3 | 190,550 | Shortening, All Purpose (50 LB) | 50151500 | CS | ERROR:#DIV/0! | $ - 0 | $ - 0 | |||||||
| 4 | 23,800 | Shortening, Liquid, Hi Temp (35 LB) | 50151500 | CS | ERROR:#DIV/0! | $ - 0 | $ - 0 | |||||||
| Contract Line Item # (CLIN) | Estimated Quantity (Cases) | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | Quantity per Case | Contract Price per Case | MSRP/List Price (if available) | Contract Discount | Extension | ||
| 1 | 1,642 | Salad Oil (35lb/cs) | 50151500 | CS | 35 LB. | ERROR:#DIV/0! | $ - 0 | |||||||
| 2 | 909 | Salad Oil (4/1 Gallon/Case) | 50151500 | CS | 4/1 Gal | ERROR:#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 Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | LBs per Case | Contract Unit Price per LB | MSRP/List Price (if available) | Contract Discount | Extension | Contract price per Case |
| 1 | 246011 | Margarine Spread (Readies) (12lbs/case, 90 portions per lb) | 50151500 | LB | ERROR:#DIV/0! | $ - 0 | $ - 0 | ||||||
| 2 | 49390 | Prints (1lb) (30lb/case) | 50151500 | LB | ERROR:#DIV/0! | $ - 0 | $ - 0 | ||||||
| 3 | 91750 | Bulk, Cube (50lb bag in carton) | 50151500 | LB | ERROR:#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 Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | Quantity per Case | Contract Unit Price per Case | MSRP/List Price (if available) | Contract Discount | Extension | |
| 1 | 1,642 | Salad Oil (35lb/cs) | 50151500 | CS | 35 LB. | ERROR:#DIV/0! | $ - 0 | ||||||
| 2 | 909 | Salad Oil (4/1 Gallon/Case) | 50151500 | CS | 4/1 Gal | ERROR:#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 Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | LBs per Case | Contract Unit Price per LB | MSRP/List Price (if available) | Contract Discount | Extension | Contract Price per Case |
| 3 | 190,550 | Shortening, All Purpose | 50151500 | LB | ERROR:#DIV/0! | $ - 0 | $ - 0 | ||||||
| 4 | 23,800 | Shortening, Liquid, Hi Temp | 50151500 | LB | ERROR:#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 .