← Hub Phase 2

Design Alignment & Module Mapping

Home / Phase 2: Design Alignment
πŸ”§

Odoo 19 Module Mapping

Business requirements mapped to Odoo features across 10 configuration areas

Business Need Odoo Module / Feature Key Settings Data Required Risk Level
Multi-level BoMs (springs β†’ mattress) Manufacturing BoM Enable "Multi-Level BoM" and "By-Products" in Manufacturing Settings; Define subassemblies for springs and foam BoM import file with component hierarchy, UoM, yield Medium – Must standardize UoM and naming
Foam production as independent batch Manufacturing Inventory Separate BoM for foam block β†’ stored as finished item (MTS) Foam recipe, batch yield Low – Ensure correct stock type (Storable Product)
By-product valuation (rebond foam / offcuts) BoM β€Ί By-Products FIFO valuation; link to scrap recovery accounts By-product list + valuation rules Medium – Assign cost share % per by-product
Product variants for custom orders Product Variants MRP Attributes: size, design, material β†’ variant BoMs via "Apply on Variants" column Variant matrix file Medium – Keep variant count manageable (<200 SKUs)
Operation costing by Work Center MRP β€Ί Work Centers Define hourly machine + labor rates; enable "Track Cost Per Work Order" Work Center master data Low – Review cost rates quarterly
Related Sections
β†’ Phase 3: BoM Import Template β†’ Phase 4: Production Flow
Business Need Odoo Module / Feature Key Settings Data Required Risk Level
Sequential 10-stage process Manufacturing β€Ί Operations β€Ί Routings One routing per mattress model with 10 operations (Foamβ†’Packaging) Operation sequence, default durations Low – Add buffer times for changeovers
2 shift calendars Manufacturing β€Ί Work Centers β€Ί Working Hours Two resource calendars (Shift A, Shift B) Shift start/end, weekly pattern Low – Needed for accurate capacity + OEE
Work Center OEE tracking Manufacturing β€Ί Reporting β€Ί OEE Enable OEE tracking + downtime categories OEE targets per WC (>85%) Medium – Requires discipline in downtime logging
Manual internal transfers Inventory β€Ί Internal Transfers Manual creation per move (Foam β†’ Cutting, etc.) Transfer templates High – Possible delay if operators skip transfer; training needed
Related Sections
β†’ Phase 3: Routing Template β†’ Phase 4: 10 Work Centers
Business Need Odoo Module / Feature Key Settings Data Required Risk Level
Multi-warehouse topology Inventory β€Ί Warehouses Create: Raw Mat WH, Foam WIP, Cutting WIP, … Finished Goods, Distribution Warehouse codes, stock locations Medium – Must define clear routes between WHs
WIP visibility Inventory β€Ί Locations β€Ί Internal Locations Enable "Is a WIP Location" per department WIP location list (10 locations) Medium – Prevent duplication between MOs and transfers
Finished goods distribution Inventory β€Ί Routes Route: Manufacture β†’ FG β†’ Distribution β†’ Customer Transfer path rules Low – Review stock valuation timing (Periodic β†’ Monthly)
Related Sections
β†’ Phase 1: Warehouse Topology β†’ Phase 4: Warehouse Moves & WIP
Business Need Odoo Module / Feature Key Settings Data Required Risk Level
Hybrid MPS + Manual planning Manufacturing β€Ί Master Production Schedule (MPS) Enable MPS; time range = Weekly; # columns = 12 weeks Product list, safety stock Medium – Avoid overlap with automatic reordering
Automated MOs via Reorder Rules Inventory β€Ί Reordering Rules Set min/max quantities + lead times Safety stock levels Medium – Review monthly to avoid overproduction
Forecast + SO integration MPS Dashboard Add forecasted demand per SKU Forecast file Medium – Require planner discipline in updates
Related Sections
β†’ Phase 4: Triggers & Planning
Business Need Odoo Module / Feature Key Settings Data Required Risk Level
Quality Control Points (QCPs) Quality β€Ί Quality Control β€Ί Control Points Create QCPs for Foam Pouring, Quilting, Final Inspection QC checklist per point Low – Automate triggers on MO completion
Lot tracking for finished mattresses Inventory β€Ί Lots & Serials MRP Enable "Track by Lot" on mattress products Lot naming format Low – Lot granularity = batch per production day
NC/CAPA workflow Quality β€Ί Quality Alerts PLM β€Ί ECO Flow Link Alerts β†’ Corrective Action β†’ ECO β†’ BoM revision Alert templates Medium – Needs approval matrix setup
Related Sections
β†’ Phase 3: QCP Template β†’ Phase 4: Quality & Rework
Business Need Odoo Module / Feature Key Settings Data Required Risk Level
Manual preventive maintenance Maintenance β€Ί Equipment & Maintenance Requests Schedule by date; categorize Preventive / Corrective Equipment list, calendar (30-day cycles) Medium – Ensure maintenance calendar maintained monthly
Operator request via Shop Floor Shop Floor β€Ί Actions Menu β€Ί "Create Maintenance Request" Enable maintenance shortcut in interface Maintenance category list Medium – Training required for operators
Related Sections
β†’ Phase 3: Equipment Template β†’ Phase 4: Maintenance & Downtime
Business Need Odoo Module / Feature Key Settings Data Required Risk Level
FIFO + Periodic valuation Inventory β€Ί Settings Enable FIFO + Periodic Valuation Product category accounts Medium – Monthly revaluation required
Operation cost roll-up Manufacturing β€Ί Cost Analysis Enable "Include WC & Labor in MO Cost" Work Center rates ($15-25/hr) Medium – Must reconcile monthly to GL
Standard vs Actual variance Accounting β€Ί Analytic Accounts MRP Each WC linked to analytic account; compare standard vs actual WC cost centers Medium – Variance reports for management dashboards
Related Sections
β†’ Phase 4: Costing & Analytics β†’ Cost Variance KPI
Business Need Odoo Module / Feature Key Settings Data Required Risk Level
Tablet-friendly work order interface Manufacturing β€Ί Shop Floor module Enable "Shop Floor" in settings; assign per user group Work Center IDs, routes Medium – Network coverage & IoT device setup
Barcode scanning for WIP / Transfers Barcode module Inventory Enable barcode operations for MO and internal moves Barcode labels per lot/WC High – Need hardware readiness (printers/scanners)
IoT Triggers (optional) IoT module Work Centers Link machine sensor β†’ work center status IoT gateway config Low – Optional in phase 1
Related Sections
β†’ Phase 4: Traceability & Barcoding
Business Need Odoo Module / Feature Key Settings Data Required Risk Level
Engineering Change Orders (ECOs) PLM β€Ί Engineering Changes Stages: Draft β†’ In Review β†’ Approved β†’ Applied BoM version history Medium – Integrate with QC alerts
BoM version control PLM β€Ί BoM Versioning Enable version field on BoM; link to ECO Version naming standard Medium – Required for ISO traceability
Related Sections
β†’ Phase 4: Quality Alerts & ECO
KPI Category Data Source / Report Odoo App / Feature
OEE per Work Center Work Center β†’ Reporting β†’ OEE Manufacturing Analytics
MO Cycle Time / Lead Time MO Duration vs Schedule Manufacturing Reports
Scrap % / Defect Rate Quality Alerts + Scrap Logs Quality App Dashboards
Operation-level Cost Variance Cost Analysis by Analytic Account Accounting MRP
On-time Completion Ratio MPS / MO reporting Planning Dashboard
Maintenance Uptime % Maintenance App reports Maintenance Dashboard
Related Sections
β†’ KPI Dashboard Mockups Below β†’ Phase 4: Costing & Analytics
πŸ“Š

KPI Framework & Dashboard Mockups

7 mandatory performance indicators with formulas and target values

85%
OEE per Work Center
Target: >85%
OEE = Availability Γ— Performance Γ— Quality
6.2hrs
MO Cycle Time
Average lead time per manufacturing order
Cycle Time = Ξ£(Operation Durations) + Queue Time
1.8%
Scrap % / Defect Rate
Target: <2%
Scrap % = (Scrap Qty / Total Input) Γ— 100
-3.2%
Cost Variance
Standard vs Actual by Work Center
Variance = ((Actual - Standard) / Standard) Γ— 100
94%
On-Time Completion
Target: >95%
On-Time % = (Completed on Time / Total MOs) Γ— 100
93%
Maintenance Uptime
Equipment availability %
Uptime % = (Operating Time / Planned Time) Γ— 100
1.2kWh/unit
Energy Usage
Optional: If IoT integrated
Energy/Unit = Total kWh / Units Produced