# Pine Assembly Workshop

A two-level assembly with shared screw consumption, purchase/issue movements and reconciled stock balances.

All entities and transactions are fictional. Snapshot: 2026-09-08.

## Start with the linked model

1. Open operations.xlsx and review the Summary sheet. Source tables contain stable primary keys and declared references.
2. Change source values in the workbook to explore the calculated totals and editable chart.
3. Compare output values with expected-results.json. The JSON Schema checks types; primary-key uniqueness and joins also require the listed semantic checks.
4. Use invalid-records.json only in a local validation harness. Its three cases exercise duplicate keys, wrong types and an orphan reference.

## Included tables

| Table | Records | Primary key |
| --- | ---: | --- |
| parts | 6 | part_id |
| bom | 6 | bom_id |
| movements | 24 | movement_id |
| suppliers | 2 | supplier_id |
| procurement | 8 | purchase_order_id |
| production_orders | 4 | production_id |
| material_requirements | 12 | requirement_id |
| routes | 4 | route_id |
| shipments | 16 | shipment_id |
| vehicles | 4 | vehicle_id |
| shipment_exceptions | 3 | exception_id |

## Expected totals

- Units received: 96.00 units. Sum movements.received over the included records.
- Units issued: 72.00 units. Sum movements.issued over the included records.
- Assembly relationships: 6.00 records. Count unique bom_id values in bom.

## Platform mapping

primary-records.csv is a generic example table. It is not a native platform export. Where this kit includes a named profile, use that profile’s separate CSV and schema and review its compatibility level before uploading.

## Scope and assumptions

- Producing one DESK requires four LEG, one PANEL and twelve SCREW leaf units. Intermediate assembly counts must not be double-counted as raw parts.
- Production orders and shipment plans are future commitments. They do not silently deduct the historical stock ledger. Confirm available stock and planned material requirements before fulfillment.