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 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/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 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/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 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/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 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 mmSteelheadSkrettingBulkpoundERROR:#DIV/0!
MOK - 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
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/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 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 .