Addendum__1_-_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 pricing workbook addendum is for the California Department of Fish and Wildlife's (CDFW) Salmon, Steelhead, and Trout Feeds contract, with an effective date of February 20, 2025. The workbook details feed requirements for multiple CDFW hatchery locations including Feather River, Mokelumne River, and Nimbus Fish hatcheries, with approximate annual volumes of 275,000 lbs, 100,000 lbs, and 77,000 lbs respectively. The feeds are specifically for fry, fingerling, and production fish sizes, with various feed sizes ranging from 1.5mm to 7.5mm for both salmon and steelhead.

The pricing structure requires vendors to provide manufacturer/OEM information, part numbers, SKU/item numbers, units of measure, list price/MSRP, contract discount percentages, and final contract unit prices. The primary manufacturers specified are Bio-Oregon and Skretting, with products including Bio Clarks Fry, Bio-Pro, Bio-Vita, Classic Fry, and Oncor lines. An additional section covers additives and medications with an approximate annual volume of 27,000 lbs, including specific requirements for Terramycin and Aquaflor in various concentrations. The contract discount is calculated as ((List Price/MSRP - Contract Unit Price) / List Price/MSRP).

View the file

Other files

File Type Posted
Attachment_2_-_Narrative_Response.docx DOCX document
Attachment_4_-_QPL_(Revised_January_2025).xlsx XLSX spreadsheet
Addendum__1_-_IFB.docx DOCX document
IFB.docx DOCX document
Attachment_1_-_Pricing_Workbook.xlsx XLSX spreadsheet
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 NumberColumn 1Column 5Column 6Columns 7-8Column 10Column 11Column 12Column 11
Column NameContract Line Item Number (CLIN)
Manufacturer (OEM)Manufacturer Part Number (OEM #)SKU # / Item # / Bagged Item # / Bulk Item #Unit of MeasureList Price/MSRPContract DiscountContract Unit Price
DescriptionUnique 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.

FormatVariable CharacterVariable CharacterVariable CharacterVariable CharacterVariable CharacterCurrencyPercentageCurrency
174 School Road, Mammoth Lakes, CA 93546625HPPT-6743444574576543245-JH/4567CBOX$2,500.0066%$1,650.00
End of Sheet

Additives & Medications

Event ID: 0000034037, Salmon, Steelhead, and Trout Feeds
Attachment 1 - Pricing Workbook, *2/20/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 NameFeed SizeFish TypeConcentrationManufacturerManufacturer Part Number (OEM #)SKU # / Item #Delivery PackagingUnit of MeasureList Price/ MSRPContract DiscountContract Unit Price
ADD-2013Terramycin 200 - 1.0%1.5 & LargerALLN/AsackpoundERROR:#DIV/0!
ADD-2015Terramycin 200 - 2.0%1.5 & LargerALLN/AsackpoundERROR:#DIV/0!
ADD-2020Aquaflor 908 grams/ton1.5mm & LargerALL10-mg/kgsackpoundERROR:#DIV/0!
ADD-2021Aquaflor 454 grams/ton1.5mm & LargerALL10-mg/kgsackpoundERROR:#DIV/0!
ADD-2024Aquaflor 1362 grams/ton1.5mm & LargerALL15-mg/kgsackpoundERROR:#DIV/0!
ADD-2025Aquaflor 631 grams/ton1.5mm & LargerALL15-mg/kgsackpoundERROR:#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/20/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 NameFeed SizeFish TypeManufacturerManufacturer Part Number (OEM #)SKU # / Item #Bulk Item #Delivery PackagingUnit of MeasureList Price/ MSRPContract DiscountContract Unit Price
FRH - 100Bio Clarks Fry1.5mmSalmonBio-OregonsackpoundERROR:#DIV/0!
FRH - 101Bio-Pro1.5mmSalmonBio-OregonsackpoundERROR:#DIV/0!
FRH - 102Bio-Pro2mmSalmonBio-OregonsackpoundERROR:#DIV/0!
FRH - 103Bio-Pro2.5mmSalmonBio-OregonsackpoundERROR:#DIV/0!
FRH - 104Bio-Vita1.5mmSalmonBio-OregonsackpoundERROR:#DIV/0!
FRH - 105Bio-Vita2mmsalmonBio-OregonsackpoundERROR:#DIV/0!
FRH - 106Bio-Vita2.5mmsalmonBio-OregonsackpoundERROR:#DIV/0!
FRH - 107Bio-Vita3mmsalmonBio-OregonsackpoundERROR:#DIV/0!
FRH - 108BioClark's Fry2.5mmSteelheadBio-OregonsackpoundERROR:#DIV/0!
FRH - 109BioClark's Fry3.0mmSteelheadBio-OregonsackpoundERROR:#DIV/0!
FRH - 110BioTrout4.0mmSteelheadBio-OregonsackpoundERROR:#DIV/0!
FRH - 111BioTrout6.0mmSteelheadBio-OregonsackpoundERROR:#DIV/0!
Average Cost:ERROR:#DIV/0!
Contract Line Item Number (CLIN)Product NameFeed SizeFish TypeManufacturerManufacturer Part Number (OEM #)Bagged Item #Bulk Item #Delivery PackagingUnit of MeasureList Price/ MSRPContract DiscountContract Unit Price
FRH - 200Classic Fry1.5mmSteelheadSkrettingcmusackpoundERROR:#DIV/0!
FRH - 201Classic Fry2mmSteelheadSkrettingsackpoundERROR:#DIV/0!
FRH - 202Classic Fry2.5mmSteelheadSkrettingsackpoundERROR:#DIV/0!
FRH - 203Oncor1.5mmSteelheadSkrettingsackpoundERROR:#DIV/0!
FRH - 204Oncor2mmSteelheadSkrettingsackpoundERROR:#DIV/0!
FRH - 205Oncor2.5mmSteelheadSkrettingsackpoundERROR:#DIV/0!
FRH - 206Classic Fry2.5mmSteelheadSkrettingsackpoundERROR:#DIV/0!
FRH - 207Classic Trout3.5mmSteelheadSkrettingsackpoundERROR:#DIV/0!
FRH - 208Classic Trout5.5mmSteelheadSkrettingsackpoundERROR:#DIV/0!
FRH - 209Classic Trout7.5mmSteelheadSkrettingsackpoundERROR:#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/20/2025, Addendum #1*
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 NameFeed SizeFish TypeManufacturerManufacturer Part Number (OEM #)Bagged Item #Bulk Item #Delivery PackagingUnit of MeasureList Price/ MSRPContract DiscountContract Unit Price
MOK - 100Classic Fry1.5 mmSteelhead/SalmonSkrettingsackpoundERROR:#DIV/0!
MOK - 101Classic Fry2.5 mmSteelheadSkretting*sack*poundERROR:#DIV/0!
MOK - 102Classic Fry3.5 mmSteelheadSkretting*sack*poundERROR:#DIV/0!
Average Cost:ERROR:#DIV/0!
Contract Line Item Number (CLIN)Product NameFeed SizeFish TypeManufacturerManufacturer Part Number (OEM #)SKU # / Item #Bulk Item #Delivery PackagingUnit of MeasureList Price/ MSRPContract DiscountContract Unit Price
MOK - 200Bio Vita Fry1.5 mmSteelhead/SalmonBioOregonsackpoundERROR:#DIV/0!
MOK - 201BioPro 21.5 mmSteelhead/SalmonBioOregonsackpoundERROR:#DIV/0!
MOK - 202Bio Vita Fry2.5 mmSteelheadBioOregonsackpoundERROR:#DIV/0!
MOK - 203BioPro 22.5 mmSteelhead/SalmonBioOregonsackpoundERROR:#DIV/0!
MOK - 204Bio Supreme2.0 mmSteelhead/SalmonBioOregonsackpoundERROR:#DIV/0!
MOK - 205Bio Supreme2.5 mmSteelheadBioOregonsackpoundERROR:#DIV/0!
MOK - 206Bio Vita Fry2.0 mmSteelhead/SalmonBioOregonsackpoundERROR:#DIV/0!
MOK - 207Bio Vita Fry3.0 mmSteelheadBioOregonsackpoundERROR:#DIV/0!
MOK - 208BioTrout3.0 mmSteelheadBioOregonsackpoundERROR:#DIV/0!
MOK - 209BioTrout4.0 mmSteelheadBioOregonsackpoundERROR:#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/20/2025, Addendum #1*
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 NameFeed SizeFish TypeManufacturerManufacturer Part Number (OEM #)Bagged Item #Bulk Item #Delivery PackagingUnit of MeasureList Price/ MSRPContract DiscountContract Unit Price
NIM - 100Classic Fry1.5 mmSteelhead/SalmonSkrettingsackpoundERROR:#DIV/0!
NIM - 101Classic Fry2.5 mmSteelheadSkrettingbulkpoundERROR:#DIV/0!
NIM - 102Classic Fry3.5 mmSteelheadSkrettingbulkpoundERROR:#DIV/0!
Average Cost:ERROR:#DIV/0!
Contract Line Item Number (CLIN)Product NameFeed SizeFish TypeManufacturerManufacturer Part Number (OEM #)SKU # / Item #Bulk Item #Delivery PackagingUnit of MeasureList Price/ MSRPContract DiscountContract Unit Price
NIM - 200Bio Vita Fry1.5mmSteelhead/SalmonBio-OregonsackpoundERROR:#DIV/0!
NIM - 201BioPro 21.5mmSteelhead/SalmonBio-OregonsackpoundERROR:#DIV/0!
NIM - 202Bio Vita Fry2.0mmSteelheadBio-OregonsackpoundERROR:#DIV/0!
NIM - 203Bio Vita Fry2.5mmSteelheadBio-OregonsackpoundERROR:#DIV/0!
NIM - 204BioPro 22.5mmSteelhead/SalmonBio-OregonsackpoundERROR:#DIV/0!
NIM - 205Bio Supreme2.5mmSteelheadBio-OregonsackpoundERROR:#DIV/0!
NIM - 206Bio Vita Fry3.0mmSteelheadBio-OregonsackpoundERROR:#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

HatcheryFirst GroupSecond GroupKey
IGHERROR:#REF!ERROR:#REF!Skretting
MSHERROR:#REF!ERROR:#REF!EWOS
MADERROR:#REF!ERROR:#REF!Rangen
CLHERROR:#REF!ERROR:#REF!Bio-Oregon
DSHERROR:#REF!ERROR:#REF!
TRHERROR:#REF!ERROR:#REF!
ARHERROR:#REF!ERROR:#REF!
FRHERROR:#DIV/0!ERROR:#DIV/0!
MOKERROR:#DIV/0!ERROR:#DIV/0!
SFBERROR:#REF!ERROR:#REF!
NIMERROR:#DIV/0!ERROR:#DIV/0!
WSHERROR:#REF!ERROR:#REF!
KRPBERROR:#REF!ERROR:#REF!
MERERROR:#REF!ERROR:#REF!
MCHERROR:#REF!ERROR:#REF!
SJHERROR:#REF!ERROR:#REF!
SCARFERROR:#REF!ERROR:#REF!
FILERROR:#REF!ERROR:#REF!
MOJERROR:#REF!ERROR:#REF!
FSHERROR:#REF!ERROR:#REF!
BRHERROR:#REF!ERROR:#REF!
HCHERROR:#REF!ERROR:#REF!

Additives ERROR:#REF!

File details come from the government source that posted it. Updated .