# Recipes and Bills of Materials Dataset

This Excel workbook defines the formulation and material structure used to produce the finished seafood products of the fictional Faroese manufacturer.

It contains four worksheets:

* **Intermediate_Products** – 18 internally produced intermediates, including sauces, marinades, brines, batters, coatings, dressings, and prepared seafood handoff states.
* **Recipe_Master** – 24 active recipes covering both intermediate formulations and finished-product formulations.
* **Recipe_Components** – 117 component records defining the ingredients, processed seafood, and intermediate products required by each recipe.
* **SKU_BOM** – 205 bill-of-material records connecting all 24 finished-product SKUs to their food formulation and required packaging materials.

Recipes are generally structured on a 100 kg output basis. Raw-fish trimming losses and processing yields are intentionally excluded so they can be modeled separately in the Standard Yields and By-products dataset.

The workbook serves as the core link between raw materials, ingredients, packaging, finished products, production routings, yields, inventory, planning, and product costing.
