# Production Architecture

This folder contains the static production architecture for the fictional Faroese seafood manufacturer used in the synthetic business dataset.

The files describe **what exists and how the production system is designed**: people, factory areas, production capabilities, equipment, products, materials, recipes, routings, process standards, yields, capacity, shifts, storage, quality controls, cleaning, maintenance, and cross-domain reference relationships.

They intentionally do **not** contain operational history such as production orders, batches, inventory movements, downtime events, maintenance work orders, QC results, attendance records, or other dated transactions.

## Workforce and facility structure

### `seafood_production_people_dataset_v1.xlsx`
Defines the production and operations workforce. Contains 65 employees, standardized job roles, employee skills, cross-training, proficiency levels, shift-group assignments, supervisors, and a data dictionary.

### `seafood_factory_areas_zones_v1.xlsx`
Defines the physical factory structure. Contains factory areas and sections, permitted movements between areas, and hygiene-zone classifications.

### `seafood_production_lines_work_centers_v1.xlsx`
Defines the operational production structure. Contains the main production systems, individual work centers, and relationships showing which work centers belong to or support each production line.

### `seafood_machinery_equipment_v1.xlsx`
Defines the factory asset base. Contains production machinery, handling equipment, utilities, equipment categories, work-center mappings, and static utility requirements.

## Products and material masters

### `seafood_products_skus_v1.xlsx`
Defines the finished-product portfolio. Contains product families, product variants, and 24 active retail SKUs with pack formats, storage requirements, shelf life, and product identifiers.

### `seafood_raw_materials_v1.xlsx`
Defines purchased seafood raw materials. Contains material grades and forms, acceptance specifications, storage requirements, and standard inbound handling paths.

### `seafood_ingredients_v1.xlsx`
Defines stocked ingredients and processing materials. Contains ingredient specifications, allergen relationships, handling rules, and the declared composition of purchased compound ingredients.

### `seafood_packaging_materials_v1.xlsx`
Defines stock-controlled packaging. Contains primary, secondary, and tertiary packaging materials, technical specifications, SKU packaging requirements, and packaging handling rules.

## Product formulation and production flow

### `seafood_recipes_bom_v1.xlsx`
Defines recipes and bills of materials. Contains intermediate products, intermediate and finished-product recipes, recipe components, and SKU-level BOMs combining food content and packaging.

### `seafood_production_routings_v1.xlsx`
Defines the standard production sequence for materials and products. Contains routing masters, ordered routing steps, routing applicability, and work-center transitions.

### `seafood_process_steps_v1.xlsx`
Defines reusable production operations and their normal operating parameters. Connects each routing step to a standardized process-step definition.

### `seafood_standard_yields_byproducts_v1.xlsx`
Defines expected production mass balances. Contains standard yields, recoverable by-products, losses, and output distributions for seafood preparation and major downstream processes.

## Capacity, labor, and time structure

### `seafood_line_capacity_staffing_v1.xlsx`
Defines standard work-center and line capacity. Contains planning capacities, staffing requirements, product-specific capacity profiles, and line-level bottleneck summaries.

### `seafood_shift_patterns_v1.xlsx`
Defines the normal working-time structure. Contains standard shifts, crew groups, work-center shift coverage, and default shift assignments for all production and operations employees.

### `seafood_storage_locations_v1.xlsx`
Defines detailed storage structure below the factory-area level. Contains storage locations, compatibility rules, capacity profiles, and standard storage-to-work-center material flows.

## Control and support requirements

### `seafood_quality_food_safety_requirements_v1.xlsx`
Defines the static quality and food-safety framework. Contains quality requirements, HACCP/control points, finished-product release criteria, sampling plans, and environmental-monitoring points.

### `seafood_cleaning_changeover_requirements_v1.xlsx`
Defines cleaning, sanitation, and production changeover requirements. Contains cleaning rules, reusable cleaning methods, changeover requirements, and cleaning-verification standards.

### `seafood_maintenance_requirements_v1.xlsx`
Defines the preventive-maintenance and calibration program. Contains reusable maintenance tasks, maintenance plans for all equipment assets, equipment criticality, redundancy, and calibration requirements.

## Cross-domain reference layer

### `seafood_production_reference_tables_v1.xlsx`
Provides simplified cross-domain relationships derived from the authoritative workbooks above. Includes role-to-work-center, skill-to-work-center, line-to-SKU, material-to-work-center, product-to-raw-material, product-allergen, and entity-ID reference tables.

## How the architecture fits together

At a high level, the data model follows this chain:

`People + Factory Areas -> Production Lines / Work Centers -> Equipment`

`Raw Materials + Ingredients + Packaging -> Recipes / BOMs -> Products / SKUs`

`Products + Work Centers -> Routings -> Process Steps -> Yields`

`Work Centers + Equipment + People -> Capacity + Staffing + Shifts`

`Materials + Products -> Storage`

`Processes + Products + Areas -> Quality / Food Safety + Cleaning`

`Equipment -> Maintenance`

`All domains -> Production Reference Tables`

Together, these files form the **static master-data layer** for the production side of the synthetic company. Later transactional datasets can use these IDs and rules to generate realistic production orders, batches, inventory movements, QC records, downtime, maintenance activity, staffing events, waste, traceability, and other operational history without redefining the underlying factory structure.
