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 is a Pricing Workbook spreadsheet for a California state fish hatchery feed contract (Event ID: 0000033775) covering salmon, steelhead, and trout feeds. The workbook details feed requirements for multiple California fish hatcheries including Feather River Hatchery (275,000 lbs annually), Mokelumne River Hatchery (100,000 lbs annually), Nimbus Fish Hatchery (77,000 lbs annually), and Kern River Planting Base (24,000 lbs annually), along with additives and medications requirements of approximately 27,000 lbs annually. The bid response date is indicated as January 7, 2025.
The pricing workbook requires bidders to provide pricing for various fish feed products from manufacturers including Bio-Oregon, Skretting, and Rangen, with specific feed sizes ranging from 1.5mm to 7.5mm. Pricing must be submitted per pound with both List Price/MSRP and Contract Unit Price, with contract discounts calculated as a percentage off list price. The workbook includes detailed line items for each hatchery location, specifying feed types for different fish species (salmon, steelhead, and trout) and various life stages (fry, fingerling, production, and broodstock). Delivery packaging options include both bulk and sack quantities.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment_2_-_Narrative_Response.docx | DOCX document | |
| Attachment_4_-_QPL_(Revised_December_2024).xlsx | XLSX spreadsheet | |
| Addendum_Cover_Sheet.docx | DOCX document | |
| Addendum__1_-_Attachment_1_-_Pricing_Workbook.xlsx | XLSX spreadsheet | |
| 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/7/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: 0000033775, Salmon, Steelhead, and Trout Feeds | ||||||||||||
| Attachment 1 - Pricing Workbook, 1/7/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 | 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/7/2025 | ||||||||||||
| 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/7/2025 | ||||||||||||
| 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/7/2025 | ||||||||||||
| 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! | |||||
| 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 .