# HAV Seafood — Supplier & Sourcing Architecture

## Purpose

This workbook defines the static **Supplier & Sourcing Architecture** for HAV Seafood. It is part of **Phase 1 — Business Architecture** and establishes the procurement structure needed for later purchasing, inventory, supplier-performance and supply-chain datasets.

It describes **who HAV Seafood can buy from, what procurement categories exist, which suppliers can serve those categories, and which approved suppliers can source each existing purchasable item**. It does not contain purchasing history or supplier-performance events.

## Workbook

`hav_seafood_procurement_supplier_sourcing_architecture_v1.xlsx`

The workbook contains **13 supplier procurement records**, **25 procurement categories**, **34 supplier-category capability relationships**, **132 purchasable item classifications**, and **188 approved supplier-item sourcing relationships**.

The sourced item population consists of:

- 13 seafood raw-material items;
- 51 purchased ingredient/processing-material items;
- 68 packaging-material items.

`ING-WAT-001 Potable Process Water` is intentionally excluded because the Production ingredient master classifies it as a site utility and the Shared Enterprise item registry does not mark it as a normal purchasable item.

## Sheets

### `Supplier_Procurement_Master`

Procurement-specific extension of the Shared Enterprise external-organization master. It contains the current static procurement classification of the 11 seeded goods suppliers plus two Procurement-owned specialist service providers.

Key attributes include supplier type, primary procurement category, procurement status, supplier tier, supply criticality, sourcing geography, standard currency, normal order method and responsible Procurement role.

The workbook **does not redefine supplier legal identity, address or contact data**. Those remain authoritative in the Shared Enterprise external-party architecture.

### `Procurement_Categories`

Defines the HAV Seafood procurement taxonomy. The model contains 25 categories, including parent categories and 21 child/specialist categories covering seafood raw materials, ingredients, packaging and Procurement-owned technical services.

Category ownership references the existing roles:

- `R032` — Procurement Manager;
- `R033` — Senior Buyer.

No parallel Procurement role structure is created.

### `Supplier_Category_Map`

Defines many-to-many supplier/category capability relationships. A supplier may be structurally approved for several categories without being the primary supplier for every category.

This is a static capability/approval relationship, not a performance scorecard.

### `Category_Item_Map`

Maps each active purchasable enterprise item into the Procurement category taxonomy.

The `Item_ID` values are reused from Shared Enterprise / Production. Procurement owns only the commercial category classification. Technical definitions remain authoritative in:

- `seafood_raw_materials_v1.xlsx`;
- `seafood_ingredients_v1.xlsx`;
- `seafood_packaging_materials_v1.xlsx`.

### `Supplier_Item_Sourcing`

Defines approved static sourcing relationships using the structure:

`Item_ID -> Approved Supplier_ID -> Static sourcing conditions`

Contains source priority, sourcing model, purchase UOM, pack description, minimum order quantity, order multiple, standard planning lead time, source country, origin requirements, substitution policy, critical-source flag and normal replenishment method.

MOQ, order multiples and lead times are **synthetic planning assumptions**, not actual quotations or measured supplier performance.

All seafood raw materials preserve the Faroese-origin positioning already present in the Production raw-material architecture.

### `Sourcing_Classes`

Defines the controlled sourcing classifications used in the workbook, including source status, source priority, supplier tier, sourcing model, lead-time class and replenishment method.

### `Source_Dependency_Summary`

Formula-derived AI/human inspection view showing, for every sourced item:

- item and procurement category;
- approved-source count;
- preferred-source count;
- derived sourcing model;
- single-source indicator;
- whether a secondary source is structurally available.

The current architecture has **56 dual-sourced items** and **76 single-sourced items**. The single-source relationships are primarily specialist packaging families because the Shared Enterprise seed architecture currently contains one specialist supplier for those categories. This is an architecture characteristic, not a deliberately seeded business-story failure.

This sheet is derived and never overrides the authoritative relationship sheets.

### `Architecture_Notes`

Documents scope, ownership decisions, sourcing assumptions and explicit Phase 1 boundaries.

### `Data_Dictionary`

Defines the meaning, datatype and ownership/origin of fields used across the workbook.

## Ownership boundaries

### Shared Enterprise remains authoritative for

- external organization identity;
- organization IDs;
- country and currency reference codes;
- enterprise item identity;
- departments and enterprise roles.

### Production remains authoritative for

- raw-material technical definitions and origin requirements;
- ingredient technical definitions;
- packaging technical definitions;
- units and production/storage specifications associated with those items.

### Procurement owns in this workbook

- supplier procurement classification;
- procurement category taxonomy;
- supplier-category capability;
- procurement classification of purchasable items;
- approved supplier-item source relationships;
- static sourcing parameters such as MOQ, order multiple, planning lead time and source priority.

## Important architecture relationships

`Shared Enterprise External Organization -> Supplier Procurement Master`

`Shared Enterprise / Production Item -> Procurement Category`

`Supplier -> Approved Procurement Categories`

`Item -> Approved Supplier Source(s)`

`Item + Supplier -> Static Sourcing Conditions`

## Sourcing design assumptions

The existing four synthetic Faroese seafood suppliers are used across the seafood raw-material categories. Seafood raw materials are structurally dual-sourced while preserving the Faroe Islands origin requirements already established by Production.

Purchased ingredients are also generally dual-sourced using the four existing synthetic ingredient suppliers according to their seeded business scope.

Packaging uses the three existing specialist suppliers:

- `ORG-EXT-009` — flexible/plastic, corrugated and tertiary packaging;
- `ORG-EXT-010` — printed labels and sleeves;
- `ORG-EXT-011` — metal food packaging.

The architecture does not invent additional packaging suppliers merely to remove single-source relationships. Additional external organizations can be introduced later through the Shared Enterprise identity layer if future architecture requirements justify them.

## Operational data intentionally excluded

This architecture contains no:

- purchase requisitions;
- RFQs;
- supplier quotations;
- negotiated price history;
- purchase orders;
- purchase-order amendments;
- supplier confirmations;
- shipments;
- goods receipts;
- delivery discrepancies;
- inventory balances or movements;
- supplier invoices;
- payment activity;
- actual lead-time measurements;
- on-time-delivery metrics;
- supplier quality incidents;
- supplier audits;
- supplier scorecards;
- supplier correspondence;
- shortages or disruption events.

These belong to Phase 3 after the business stories have been selected.

## Commercial and quality boundaries

Commercial terms such as prices, payment terms, Incoterms, discounts and agreements belong to the later **Supplier Governance & Commercial Framework**.

Detailed supplier qualification and technical food-safety approval criteria are also outside this workbook. Production/Quality technical specifications remain authoritative; this workbook only identifies structurally approved sources for existing items.

## Identifier conventions

Existing identifiers are preserved:

- `ORG-EXT-*` — Shared Enterprise external organizations;
- `RM-*` — raw materials;
- `ING-*` — ingredients/processing inputs;
- `PKG-*` / `LBL-*` — packaging materials;
- `R*` — enterprise job roles;
- `DEPT-*` — enterprise departments.

New Procurement-local identifiers introduced here are:

- `PCAT-*` — procurement categories;
- `SCM-*` — supplier-category capability relationships;
- `SRC-*` — supplier-item sourcing relationships.

These prefixes should be registered in the Shared Enterprise identifier standards if that architecture is refreshed.

## Story neutrality

The workbook deliberately does not seed supplier failure, quality deterioration, delivery delays, abnormal price behavior, procurement fraud, supply shortages or other business-story outcomes.

It provides the stable supplier and sourcing structure against which such events can later be generated deliberately in Phase 3.

## Recommended AI use

For fast context, read this Markdown file first. Then use:

1. `Source_Dependency_Summary` for a compact item-level sourcing overview;
2. `Supplier_Item_Sourcing` for detailed supplier-item relationships and static sourcing conditions;
3. `Supplier_Procurement_Master` and `Procurement_Categories` for supplier/category context;
4. authoritative Shared Enterprise or Production workbooks whenever legal identity or technical item detail is required.
