Addendum__1_-_Attachment_1_-_Pricing_Workbook.xlsx
XLSX spreadsheet 38 KB Posted
- Attached to
- Fish Feed, Medications, and Additives
- Solicitation number
- 0000033775
- Issued by
- Butte County, California
About this file
This Excel pricing workbook is part of Addendum 1 for a California Department of Fish and Wildlife (CDFW) contract for Salmon, Steelhead, and Trout Feeds. The workbook contains detailed pricing templates for multiple CDFW fish hatchery locations including Feather River Hatchery, Mokelumne River Hatchery, Nimbus Fish Hatchery, and Kern River Planting Base, with approximate annual volumes ranging from 24,000 to 275,000 pounds of feed per facility. The contract period extends to January 13, 2025.
The pricing workbook is structured with separate worksheets for additives/medications and each hatchery location, requiring vendors to provide manufacturer information, part numbers, SKU numbers, list prices, contract discounts, and unit prices. The feed products are primarily from manufacturers including Bio-Oregon, Skretting, and Rangen, with various feed sizes ranging from 1.5mm to 7.5mm. Vendors must complete only the yellow-highlighted cells in the workbook, with contract discounts calculated as ((List Price/MSRP - Contract Unit Price) / List Price/MSRP). All pricing is requested per pound with delivery packaging specified as either bulk or sack.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment_2_-_Narrative_Response.docx | DOCX document | |
| Attachment_1_-_Pricing_Workbook.xlsx | XLSX spreadsheet | |
| Attachment_4_-_QPL_(Revised_December_2024).xlsx | XLSX spreadsheet | |
| Addendum_Cover_Sheet.docx | DOCX document | |
| Question___Answer_Set.docx | DOCX document | |
| APP_Cover_Page.docx | DOCX document | |
| Attachment_3_-_Fish_Feed_Bin_Requirements.xlsx | XLSX spreadsheet | |
| IFB.docx | DOCX document | |
| Addendum__1_-_Attachment_4_-_QPL_(Revised_January_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: 0000033775, Salmon, Steelhead, and Trout Feeds | ||||||||||||
| Attachment 1 - Pricing Workbook, 1/13/2025, Addendum #1 | ||||||||||||
| 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: 0000033775, Salmon, Steelhead, and Trout Feeds | ||||||||||||
| Attachment 1 - Pricing Workbook, 1/13/2025, Addendum #1 | ||||||||||||
| 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 | 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: 0000033775, Salmon, Steelhead, and Trout Feeds | ||||||||||||
| Attachment 1 - Pricing Workbook, 1/13/2025, Addendum #1 | ||||||||||||
| Bidder: | ||||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Supplier must complete the Yellow Cells only. | ||||||||||||
| Mokelumne River Hatchery (MOK) | ||||||||||||
| 25800 McIntire Road, Clements, CA 95227 | ||||||||||||
| 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: 0000033775, Salmon, Steelhead, and Trout Feeds | ||||||||||||
| Attachment 1 - Pricing Workbook, 1/13/2025, Addendum #1 | ||||||||||||
| Bidder: | ||||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Supplier must complete the Yellow Cells only. | ||||||||||||
| Nimbus Fish Hatchery (NIM) | ||||||||||||
| 2001 Nimbus Road, Rancho Cordova, CA 95670 | ||||||||||||
| 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 |
KRPB
| Event ID: 0000033775, Salmon, Steelhead, and Trout Feeds | ||||||||||||
| Attachment 1 - Pricing Workbook, 1/13/2025, Addendum #1 | ||||||||||||
| Bidder: | ||||||||||||
| Instructions: Refer to IFB Pricing language for completion instructions. Supplier must complete the Yellow Cells only. | ||||||||||||
| Kern River Planting Base (KRPB) | ||||||||||||
| 14415 N. Sierra Way, Kernville, CA 93238 | ||||||||||||
| Fish Size: Production, Broodstock | ||||||||||||
| Approximate Annual Volume: 24,000 lbs | ||||||||||||
| Contract Line Item Number (CLIN) | Product Name | Feed Size | Fish Type | Manufacturer | Manufacturer Part Number (OEM #) | Bulk Item # | Bag Item # | Delivery Packaging | Unit of Measure | List Price/ MSRP | Contract Discount | Contract Unit Price |
| KRPB - 100 | Extr 450 Floating | 3/32 inch | Trout | Rangen | bulk/sack | pound | ERROR:#DIV/0! | |||||
| KRPB - 101 | Extr 450 Floating | 5/32 inch | Trout | Rangen | bulk/sack | pound | ERROR:#DIV/0! | |||||
| KRPB - 102 | Extr 450 Floating | 3/16 inch | Trout | Rangen | bulk/sack | pound | ERROR:#DIV/0! | |||||
| KRPB - 103 | Extr 450 Floating | 1/4 inch | Trout | Rangen | bulk/sack | pound | ERROR:#DIV/0! | |||||
| KRPB - 104 | Extr 450 Slow Sink | 3/32 inch | Trout | Rangen | bulk/sack | pound | ERROR:#DIV/0! | |||||
| KRPB - 105 | Trout Grower | #3 | Trout | Rangen | Sack | pound | ERROR:#DIV/0! | |||||
| KRPB - 106 | Trout Grower | #4 | Trout | Rangen | bulk/sack | pound | ERROR:#DIV/0! | |||||
| *KRPB - 107 | Trout Broodstock Floating | 1/4 inch | Trout | Rangen | bulk/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 |
| KRPB - 200 | Classic Fry Floating | 1.5 mm | Trout | Skretting | sack | pound | ERROR:#DIV/0! | |||||
| KRPB - 201 | Classic Fry Floating | 2.5 mm | Trout | Skretting | bulk/sack | pound | ERROR:#DIV/0! | |||||
| KRPB - 202 | Classic Trout Floating 4.5mm | 4.5mm | Trout | Skretting | bulk/sack | pound | ERROR:#DIV/0! | |||||
| KRPB - 208 | Oncor Floating | 3.5 mm | Trout | Skretting | bulk/sack | pound | ERROR:#DIV/0! | |||||
| KRPB - 210 | Classic Brood Floating | 5.5 mm | Trout | Skretting | bulk/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:#DIV/0! | ERROR:#DIV/0! | |
| 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 .