Manufacturing (MRP) — Plan Overview
Blu Coffee plans to add Odoo's native Manufacturing (MRP) capability to bc17 to support the roastery repackaging workflow: taking an existing finished good (a sellable coffee blend) and converting it into a new finished good (a different SKU at a different weight) via grinding and repackaging.
Driving example
| Source | Result | |
|---|---|---|
| Product | Blu Espresso Blend | Sugbo Blend |
| Weight | 500 g | 70 g |
| SRP | ₱675 | ₱105 |
The source product is itself a finished, sellable SKU. The repackaging adds value through grinding to a target particle size, weighing into 70 g portions, and packing into Sugbo-branded pouches.
Process Flow (from VGC field notes)
START
↓
Existing Coffee Blend
↓
Item requested & approved → Roastery Raw Materials Inventory
↓
Existing blend opened, ground to desired size, measured to desired weight
↓ [inputs: Labor, Electricity, Use of Space and Equipment]
Weighed coffee grounds repackaged to coffee pouches
↓ [inputs: Coffee Pouches, Labor]
Repackaged ground beans transferred to Main Warehouse
↓
NEW SKU for Coffee Blend
↓
END
See Process Flow for the full mapping to Odoo concepts.
Why use MRP instead of an internal transfer + manual SKU swap?
| Concern | Manual swap | MRP |
|---|---|---|
| Component traceability | Implicit | Captured per Manufacturing Order (MO) |
| Cost rollup (labor, electricity) | Not captured | Work-center cost × time per operation |
| Yield/loss reporting | Manual | Automatic (kg in vs kg out) |
| Approval workflow | Email / paper | Built into MO state machine |
| Brand attribution | Manual | Carried on MO header |
| Variance analysis | None | Standard vs actual cost on MO close |
The MRP route also gives the team a single screen (Manufacturing > Operations > Manufacturing Orders) to plan, schedule, and review every repackaging run.
Implementation Phases
- Foundation — install
mrpmodule, set up Roastery stock locations, define work centers - Products & BOMs — set up coffee pouches as raw material, configure new SKUs and their BOMs
- Custom
blu_mrpsub-package — approval workflow, brand tracking, raw-material requisition wizard - Reporting — manufacturing cost analysis, yield/loss, WIP aging (extends
blu_reports) - Costing & accounting — analytic accounts for labor / electricity / overhead, production variance account
Each phase is independently shippable. Total estimated effort is ~3 weeks of dev + 1 week UAT.
Module Dependencies (planned change)
Add mrp to bc17/__manifest__.py:
'depends': [
'base',
'l10n_ph',
'base_accounting_kit',
'tax_report_omax',
'crm',
'sale_management',
'purchase',
'stock',
'repair',
'mrp', # ← new
'muk_web_theme',
'account_parent',
'sms',
],
Next Steps
- Read Process Flow — how each step in the field notes maps to Odoo concepts
- Read BOM and Routing — concrete BOM for Sugbo Blend 70g
- Read Costing — how labor, electricity, and equipment costs roll into the new SKU
- Read Open Questions — items that need VGC team confirmation before development