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 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: 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 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: 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 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.5mmSteelheadSkrettingsackpoundERROR:#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: 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 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: 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 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

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 NameFeed SizeFish TypeManufacturerManufacturer Part Number (OEM #)Bulk Item #Bag Item #Delivery PackagingUnit of MeasureList Price/ MSRPContract DiscountContract Unit Price
KRPB - 100Extr 450 Floating3/32 inchTroutRangenbulk/sackpoundERROR:#DIV/0!
KRPB - 101Extr 450 Floating5/32 inchTroutRangenbulk/sackpoundERROR:#DIV/0!
KRPB - 102Extr 450 Floating3/16 inchTroutRangenbulk/sackpoundERROR:#DIV/0!
KRPB - 103Extr 450 Floating1/4 inchTroutRangenbulk/sackpoundERROR:#DIV/0!
KRPB - 104Extr 450 Slow Sink3/32 inchTroutRangenbulk/sackpoundERROR:#DIV/0!
KRPB - 105Trout Grower#3TroutRangenSackpoundERROR:#DIV/0!
KRPB - 106Trout Grower#4TroutRangenbulk/sackpoundERROR:#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
KRPB - 200Classic Fry Floating1.5 mmTroutSkrettingsackpoundERROR:#DIV/0!
KRPB - 201Classic Fry Floating2.5 mmTroutSkrettingbulk/sackpoundERROR:#DIV/0!
KRPB - 202Classic Trout Floating 4.5mm4.5mmTroutSkrettingbulk/sackpoundERROR:#DIV/0!
KRPB - 208Oncor Floating3.5 mmTroutSkrettingbulk/sackpoundERROR:#DIV/0!
KRPB - 210Classic Brood Floating5.5 mmTroutSkrettingbulk/sackpoundERROR:#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:#DIV/0!ERROR:#DIV/0!
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 .