Attachment_1_-_Pricing_Workbook.xlsx
XLSX spreadsheet 34 KB Posted
- Attached to
- Salmon, Steelhead, and Trout Feeds
- Solicitation number
- 0000034037
- Issued by
- Butte County, California
About this file
This is a pricing workbook for salmon, steelhead, and trout feeds for multiple California fish hatcheries, including Feather River Hatchery, Mokelumne River Hatchery, and Nimbus Fish Hatchery. The workbook outlines requirements for fish feed products in various sizes (1.5mm to 7.5mm) for different fish types (salmon and steelhead), with approximate annual volumes of 275,000 lbs for Feather River Hatchery, 100,000 lbs for Mokelumne River Hatchery, and 77,000 lbs for Nimbus Fish Hatchery. Additionally, there is a separate requirement for additives and medications with an approximate annual volume of 27,000 lbs. The workbook indicates a contract end date of February 6, 2025.
The pricing structure requires vendors to provide manufacturer information, part numbers, SKU numbers, and packaging details for each line item. Vendors must complete pricing information in designated yellow cells, including list price/MSRP, contract discount, and contract unit price. The primary manufacturers specified are Bio-Oregon and Skretting, with products to be delivered in both sack and bulk packaging measured by pound. The workbook includes a contract discount calculation formula: ((List Price/MSRP - Contract Unit Price) / List Price/MSRP).
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment_2_-_Narrative_Response.docx | DOCX document | |
| Addendum__1_-_Attachment_1_-_Pricing_Workbook.xlsx | XLSX spreadsheet | |
| Attachment_4_-_QPL_(Revised_January_2025).xlsx | XLSX spreadsheet | |
| Addendum__1_-_IFB.docx | DOCX document | |
| IFB.docx | DOCX document | |
| Addendum__1_-_Cover_Sheet.docx | DOCX document | |
| APP_Cover_Page.docx | DOCX document | |
| Attachment_3_-_Fish_Feed_Bin_Requirements.xlsx | XLSX spreadsheet | |
| Addendum__1_Attachment_4_-_QPL(Revised_February_2025).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 Workbook Key
| Pricing Workbook Key | ||||||||
| Column Number | Column 1 | Column 5 | Column 6 | Columns 7-8 | Column 10 | Column 11 | Column 12 | Column 11 |
| Column Name | Contract Line Item Number (CLIN) | |||||||
| Manufacturer (OEM) | Manufacturer Part Number (OEM #) | SKU # / Item # / Bagged Item # / Bulk Item # | Unit of Measure | List Price/MSRP | Contract Discount | Contract Unit Price | ||
| Description | Unique line item number. | Identifies the manufacturer's name for each line item. | Identifies manufacturer's unique identifier for a particular line item. | Identifies supplier'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. | ||
| 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 contractual price for a given line item based on the price that was bid, as relative to the unit of measure.
| Format | Variable Character | Variable Character | Variable Character | Variable Character | Variable Character | Currency | Percentage | Currency |
| 174 School Road, Mammoth Lakes, CA 93546 | 625 | HP | PT-674344457 | 4576543245-JH/4567C | BOX | $2,500.00 | 66% | $1,650.00 |
| End of Sheet |
Additives & Medications
| Event ID: 0000034037, Salmon, Steelhead, and Trout Feeds | ||||||||||||
| Attachment 1 - Pricing Workbook, 2/6/2025 | ||||||||||||
| Bidder: | ||||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Supplier must complete the Yellow Cells only. | ||||||||||||
| Additives and Medications | ||||||||||||
| Approximate Annual Volume: 27,000 lbs | ||||||||||||
| Contract Line Item Number (CLIN) | Product Name | Feed Size | Fish Type | Concentration | Manufacturer | Manufacturer Part Number (OEM #) | SKU # / Item # | Delivery Packaging | Unit of Measure | List Price/ MSRP | Contract Discount | Contract Unit Price |
| ADD-2013 | Terramycin 200 - 1.0% | 1.5 & Larger | ALL | N/A | sack | pound | ERROR:#DIV/0! | |||||
| ADD-2015 | Terramycin 200 - 2.0% | 1.5 & Larger | ALL | N/A | sack | pound | ERROR:#DIV/0! | |||||
| ADD-2020 | Aquaflor 908 grams/ton | 1.5mm & Larger | ALL | 10-mg/kg | sack | pound | ERROR:#DIV/0! | |||||
| ADD-2021 | Aquaflor 454 grams/ton | 1.5mm & Larger | ALL | 10-mg/kg | sack | pound | ERROR:#DIV/0! | |||||
| ADD-2024 | Aquaflor 1362 grams/ton | 1.5mm & Larger | ALL | 15-mg/kg | sack | pound | ERROR:#DIV/0! | |||||
| ADD-2025 | Aquaflor 631 grams/ton | 1.5mm & Larger | ALL | 15-mg/kg | sack | pound | ERROR:#DIV/0! | |||||
| Total | $0.00 | |||||||||||
| Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | ||||||||||||
| End of Sheet |
FRH
| Event ID: 0000034037, Salmon, Steelhead, and Trout Feeds | ||||||||||||
| Attachment 1 - Pricing Workbook, 2/6/2025 | ||||||||||||
| Bidder: | ||||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Supplier must complete the Yellow Cells only. | ||||||||||||
| Feather River Hatchery (FRH) | ||||||||||||
| 5 Table Mountain Road, Oroville, CA 95965 | ||||||||||||
| Fish Size: Fry, Fingerling, Production | ||||||||||||
| Approximate Annual Volume: 275,000 lbs | ||||||||||||
| Contract Line Item Number (CLIN) | Product Name | Feed Size | Fish Type | Manufacturer | Manufacturer Part Number (OEM #) | SKU # / Item # | Bulk Item # | Delivery Packaging | Unit of Measure | List Price/ MSRP | Contract Discount | Contract Unit Price |
| FRH - 100 | Bio Clarks Fry | 1.5mm | Salmon | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 101 | Bio-Pro | 1.5mm | Salmon | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 102 | Bio-Pro | 2mm | Salmon | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 103 | Bio-Pro | 2.5mm | Salmon | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 104 | Bio-Vita | 1.5mm | Salmon | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 105 | Bio-Vita | 2mm | salmon | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 106 | Bio-Vita | 2.5mm | salmon | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 107 | Bio-Vita | 3mm | salmon | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 108 | BioClark's Fry | 2.5mm | Steelhead | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 109 | BioClark's Fry | 3.0mm | Steelhead | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 110 | BioTrout | 4.0mm | Steelhead | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 111 | BioTrout | 6.0mm | Steelhead | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| Average Cost: | ERROR:#DIV/0! |
| Contract Line Item Number (CLIN) | Product Name | Feed Size | Fish Type | Manufacturer | Manufacturer Part Number (OEM #) | Bagged Item # | Bulk Item # | Delivery Packaging | Unit of Measure | List Price/ MSRP | Contract Discount | Contract Unit Price |
| FRH - 200 | Classic Fry | 1.5mm | Steelhead | Skretting | cmu | sack | pound | ERROR:#DIV/0! | ||||
| FRH - 201 | Classic Fry | 2mm | Steelhead | Skretting | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 202 | Classic Fry | 2.5mm | Steelhead | Skretting | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 203 | Oncor | 1.5mm | Steelhead | Skretting | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 204 | Oncor | 2mm | Steelhead | Skretting | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 205 | Oncor | 2.5mm | Steelhead | Skretting | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 206 | Classic Fry | 2.5mm | Steelhead | Skretting | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 207 | Classic Trout | 3.5mm | Steelhead | Skretting | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 208 | Classic Trout | 5.5mm | Steelhead | Skretting | sack | pound | ERROR:#DIV/0! | |||||
| FRH - 209 | Classic Trout | 7.5mm | Steelhead | Skretting | sack | pound | ERROR:#DIV/0! | |||||
| Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | Average Cost: | ERROR:#DIV/0! | ||||||||||
| End of Sheet |
MOK
| Event ID: 0000034037, Salmon, Steelhead, and Trout Feeds | ||||||||||||
| Attachment 1 - Pricing Workbook, 2/6/2025 | ||||||||||||
| Bidder: | ||||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Supplier must complete the Yellow Cells only. | ||||||||||||
| Mokelumne River Hatchery (MOK) | ||||||||||||
| cmu | ||||||||||||
| Fish Size: Fry/Fingerling, Production | ||||||||||||
| Approximate Annual Volume: 100,000 lbs | ||||||||||||
| Contract Line Item Number (CLIN) | Product Name | Feed Size | Fish Type | Manufacturer | Manufacturer Part Number (OEM #) | Bagged Item # | Bulk Item # | Delivery Packaging | Unit of Measure | List Price/ MSRP | Contract Discount | Contract Unit Price |
| MOK - 100 | Classic Fry | 1.5 mm | Steelhead/Salmon | Skretting | sack | pound | ERROR:#DIV/0! | |||||
| MOK - 101 | Classic Fry | 2.5 mm | Steelhead | Skretting | Bulk | pound | ERROR:#DIV/0! | |||||
| MOK - 102 | Classic Fry | 3.5 mm | Steelhead | Skretting | Bulk | pound | ERROR:#DIV/0! | |||||
| Average Cost: | ERROR:#DIV/0! |
| Contract Line Item Number (CLIN) | Product Name | Feed Size | Fish Type | Manufacturer | Manufacturer Part Number (OEM #) | SKU # / Item # | Bulk Item # | Delivery Packaging | Unit of Measure | List Price/ MSRP | Contract Discount | Contract Unit Price |
| MOK - 200 | Bio Vita Fry | 1.5 mm | Steelhead/Salmon | BioOregon | sack | pound | ERROR:#DIV/0! | |||||
| MOK - 201 | BioPro 2 | 1.5 mm | Steelhead/Salmon | BioOregon | sack | pound | ERROR:#DIV/0! | |||||
| MOK - 202 | Bio Vita Fry | 2.5 mm | Steelhead | BioOregon | sack | pound | ERROR:#DIV/0! | |||||
| MOK - 203 | BioPro 2 | 2.5 mm | Steelhead/Salmon | BioOregon | sack | pound | ERROR:#DIV/0! | |||||
| MOK - 204 | Bio Supreme | 2.0 mm | Steelhead/Salmon | BioOregon | sack | pound | ERROR:#DIV/0! | |||||
| MOK - 205 | Bio Supreme | 2.5 mm | Steelhead | BioOregon | sack | pound | ERROR:#DIV/0! | |||||
| MOK - 206 | Bio Vita Fry | 2.0 mm | Steelhead/Salmon | BioOregon | sack | pound | ERROR:#DIV/0! | |||||
| MOK - 207 | Bio Vita Fry | 3.0 mm | Steelhead | BioOregon | sack | pound | ERROR:#DIV/0! | |||||
| MOK - 208 | BioTrout | 3.0 mm | Steelhead | BioOregon | sack | pound | ERROR:#DIV/0! | |||||
| MOK - 209 | BioTrout | 4.0 mm | Steelhead | BioOregon | sack | pound | ERROR:#DIV/0! | |||||
| Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | Average Cost: | ERROR:#DIV/0! | ||||||||||
| End of Sheet |
NIM
| Event ID: 0000034037, Salmon, Steelhead, and Trout Feeds | ||||||||||||
| Attachment 1 - Pricing Workbook, 2/6/2025 | ||||||||||||
| Bidder: | ||||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Supplier must complete the Yellow Cells only. | ||||||||||||
| Nimbus Fish Hatchery (NIM) | ||||||||||||
| Contract Line Item Number (CLIN) | ||||||||||||
| Fish Size: Fry, Fingerling, Production | ||||||||||||
| Approximate Annual Volume: 77,000 lbs | ||||||||||||
| Contract Line Item Number (CLIN) | Product Name | Feed Size | Fish Type | Manufacturer | Manufacturer Part Number (OEM #) | Bagged Item # | Bulk Item # | Delivery Packaging | Unit of Measure | List Price/ MSRP | Contract Discount | Contract Unit Price |
| NIM - 100 | Classic Fry | 1.5 mm | Steelhead/Salmon | Skretting | sack | pound | ERROR:#DIV/0! | |||||
| NIM - 101 | Classic Fry | 2.5 mm | Steelhead | Skretting | bulk | pound | ERROR:#DIV/0! | |||||
| NIM - 102 | Classic Fry | 3.5 mm | Steelhead | Skretting | bulk | pound | ERROR:#DIV/0! | |||||
| Average Cost: | ERROR:#DIV/0! |
| Contract Line Item Number (CLIN) | Product Name | Feed Size | Fish Type | Manufacturer | Manufacturer Part Number (OEM #) | SKU # / Item # | Bulk Item # | Delivery Packaging | Unit of Measure | List Price/ MSRP | Contract Discount | Contract Unit Price |
| NIM - 200 | Bio Vita Fry | 1.5mm | Steelhead/Salmon | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| NIM - 201 | BioPro 2 | 1.5mm | Steelhead/Salmon | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| NIM - 202 | Bio Vita Fry | 2.0mm | Steelhead | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| NIM - 203 | Bio Vita Fry | 2.5mm | Steelhead | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| NIM - 204 | BioPro 2 | 2.5mm | Steelhead/Salmon | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| NIM - 205 | Bio Supreme | 2.5mm | Steelhead | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| NIM - 206 | Bio Vita Fry | 3.0mm | Steelhead | Bio-Oregon | sack | pound | ERROR:#DIV/0! | |||||
| Note: Contract Discount is calculated by ((List Price/MSRP - Contract Unit Price) / List Price/MSRP) | Average Cost: | ERROR:#DIV/0! | ||||||||||
| End of Sheet |
Totals
| Hatchery | First Group | Second Group | Key |
| IGH | ERROR:#REF! | ERROR:#REF! | Skretting |
| MSH | ERROR:#REF! | ERROR:#REF! | EWOS |
| MAD | ERROR:#REF! | ERROR:#REF! | Rangen |
| CLH | ERROR:#REF! | ERROR:#REF! | Bio-Oregon |
| DSH | ERROR:#REF! | ERROR:#REF! | |
| TRH | ERROR:#REF! | ERROR:#REF! | |
| ARH | ERROR:#REF! | ERROR:#REF! | |
| FRH | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| MOK | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| SFB | ERROR:#REF! | ERROR:#REF! | |
| NIM | ERROR:#DIV/0! | ERROR:#DIV/0! | |
| WSH | ERROR:#REF! | ERROR:#REF! | |
| KRPB | ERROR:#REF! | ERROR:#REF! | |
| MER | ERROR:#REF! | ERROR:#REF! | |
| MCH | ERROR:#REF! | ERROR:#REF! | |
| SJH | ERROR:#REF! | ERROR:#REF! | |
| SCARF | ERROR:#REF! | ERROR:#REF! | |
| FIL | ERROR:#REF! | ERROR:#REF! | |
| MOJ | ERROR:#REF! | ERROR:#REF! | |
| FSH | ERROR:#REF! | ERROR:#REF! | |
| BRH | ERROR:#REF! | ERROR:#REF! | |
| HCH | ERROR:#REF! | ERROR:#REF! |
Additives ERROR:#REF!
File details come from the government source that posted it. Updated .