1._Pricing_Worksheet.xlsx
XLSX spreadsheet 17 KB Posted
- Attached to
- FAU25-89-127, Powdered Milk
- Solicitation number
- 0000032326
- Issued by
- Alameda County, Cedar Ridge CDP, California
About this file
This document is a Pricing Worksheet for a state and local government contract opportunity for powdered milk. The contract is being issued by the Department of General Services - Procurement Division under Event ID 0000032326. The contract line item is for 206,900 pounds of Milk, Dry, Nonfat (High Heat Spray Process) with a UNSPSC code of 50131704. The pricing worksheet provides detailed requirements including the unit of measure, pounds per bag, bags per pallet, base price, and contract price. The contract price is calculated as the base price of $1.3425 per pound plus any applicable differentials, resulting in a total estimated contract value of $277,763.25.
The pricing worksheet includes instructions for bidders to complete the yellow input cells only. The contract requires that orders be placed in full pallet increments, and the unit of measure is pounds. No additional details are provided regarding set asides, incumbents, funding requirements, or other salient information.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Addendum_1.docx | DOCX document | |
| 3._Narrative_Response.docx | DOCX document | |
| 0._IFB_0000032326.docx | DOCX document | |
| 00._APP_Front_Page.docx | DOCX document | |
| 5._Food_Safety_Information_Listing.docx | DOCX document | |
| 2._8910-BS-0210699.pdf | ||
| 4._Estimated_Usage.xlsx | XLSX spreadsheet | |
| 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 Name | Contract Line Item Number (CLIN) | ||||||||
| Estimated Quantity | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | Pounds Per Bag | Bags Per | |
| Pallet | Pounds Per Pallet | Base Price | Differential | Contract Price | |||||
| (Base + Differential) | Extension | ||||||||
| Description | Unique line item number. | The estimated quantity that institutions intend to purchase. | 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 Brand 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). | Identifies supplier's Pounds Per Bag for a particular line item. | Identifies supplier's Bags Per Pallet for a particular line item. | Pounds Per Pallet is automatically calculated by (Pounds Per Bag x Bags Per Pallet) | Based on the Wall Street Journal. |
| Price given by bidder. | Contract Price is automatically calculated by (Base Price + Differential) | Extension is automatically calculated (Contract Unit Price x Estimated Quantity) | ||||||
| END OF SHEET. |
Powdered Milk
| Department of General Services - Procurement Division | |
| Event ID: 0000032326, Powdered Milk | |
| Attachment 1 - Pricing Worksheet, 9/13/2024 | |
| Bidder: | Blank |
| Instructions: Refer to IFB Pricing language for completion instructions. Bidder must complete the Yellow Input Cells only. |
| Base Price: $1.3425. Base of the daily edition of the Wall Street Journal: 9/03/2024 | |||||||||||||||
| Contract Line Item # (CLIN) | Estimated Quantity | Commodity Description | UNSPSC Code | Manufacturer | Brand | Manufacturer Product Code | Unit of Measure | Pounds Per Bag | Bags Per Pallet | Pounds Per Pallet | Base Price | Differential | Contract Price | ||
| (Base + Differential) | Extension | ||||||||||||||
| 1 | 206900 | Milk, Dry, Nonfat (High Heat Spray Process) | 50131704 | LB | 0 | $ 1.3425 | $ 1.3425 | $ 277,763.25 | |||||||
| TOTAL: | $ 277,763.25 | ||||||||||||||
| Note: Orders must be made in full pallet increments (partial pallet orders will not be allowed). | |||||||||||||||
| Note: Unit of Measure LB = Pound | |||||||||||||||
| Note: Pounds Per Pallet is automatically calculated by (Pounds Per Bag x Bags Per Pallet) | |||||||||||||||
| Note: Contract Price is automatically calculated by (Base Price + Differential) | |||||||||||||||
| 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 .