Process Flow — Field Notes to Odoo Mapping
This page translates VGC's hand-drawn process flow ("Existing Finished Good → New Finished Good (Coffee)") into the Odoo MRP concepts that will implement it.
Side-by-side mapping
| Hand-drawn step | Odoo concept | Notes |
|---|---|---|
| Start | — | Trigger: planning team confirms a Sugbo production run |
| Existing Coffee Blend (e.g. Blu Espresso Blend 500g) | BOM Component | Same product is also a sellable SKU. type=product, purchase_ok=True, sale_ok=True |
| Item requested & approved → Roastery Raw Materials Inventory | Internal Transfer (Main WH → Roastery RM) gated by blu_mrp approval wizard | New custom step — see Open Questions re: who approves |
| Existing blend opened, ground to desired size, measured to desired weight | Work Order 1: Grinding at Roastery — Grinding work center | Cost = labor + electricity + equipment depreciation per hour |
| Weighed coffee grounds repackaged to coffee pouches | Work Order 2: Repackaging at Roastery — Packaging work center | Consumes Coffee Pouches BOM line; cost = labor per hour |
| Repackaged ground beans transferred to Main Warehouse | MO Finished Move: Roastery WIP → Main WH | Automatic on MO completion |
| New SKU for Coffee Blend (e.g. Sugbo Blend 70g) | Finished Product of the BOM/MO | manufacture route enabled |
| End | MO state = Done; Sugbo Blend 70g now sellable | — |
Stock movement diagram
┌────────────────┐ Internal Transfer ┌──────────────────────┐
│ Main Warehouse │ ──────────────────────► │ Roastery / Raw Mat. │
│ Blu Espresso │ (approval gated) │ Blu Espresso 500g │
│ Blend 500g │ │ Coffee Pouches │
└────────────────┘ └──────────┬───────────┘
│
│ Manufacturing Order
▼
┌──────────────────────┐
│ Roastery / WIP │
│ (production loc.) │
│ │
│ Op 1: Grinding │
│ Op 2: Packaging │
└──────────┬───────────┘
│
│ MO finished move
▼
┌──────────────────────┐
│ Main Warehouse │
│ Sugbo Blend 70g │
└──────────────────────┘
Inputs captured at each step
The hand-drawn flow annotates two work-station inputs:
Grinding station inputs
- Labor — operators feeding the grinder and weighing portions
- Electricity — grinder power draw
- Use of space and equipment — depreciation / overhead allocation for the roastery floor and grinder
These three are bundled into the Roastery — Grinding work center's cost_per_hour. See Costing for the breakdown formula.
Packaging station inputs
- Coffee Pouches — physical material consumed; modeled as a BOM component
- Labor — operators sealing and labeling pouches
Coffee Pouches is a BOM line. Labor is the Roastery — Packaging work center's cost_per_hour.
Approval gate
The "Item requested & approved" callout in the field notes maps to a custom raw-material requisition wizard in blu_mrp:
- Roastery operator (or production planner) opens the wizard, selects target SKU + quantity
- Wizard previews the BOM expansion (how much Blu Espresso 500g, how many pouches)
- Wizard creates the Internal Transfer in
draftstate - An approver (group
blu_roastery_approver_group) confirms — transfer moves toassigned - Stock is moved to Roastery RM, MO is created and ready to start
See Open Questions for what remains undecided about the approval flow.