Skip to main content

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

SourceResult
ProductBlu Espresso BlendSugbo Blend
Weight500 g70 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)

See Process Flow for the full mapping to Odoo concepts.

Why use MRP instead of an internal transfer + manual SKU swap?

ConcernManual swapMRP
Component traceabilityImplicitCaptured per Manufacturing Order (MO)
Cost rollup (labor, electricity)Not capturedWork-center cost × time per operation
Yield/loss reportingManualAutomatic (kg in vs kg out)
Approval workflowEmail / paperBuilt into MO state machine
Brand attributionManualCarried on MO header
Variance analysisNoneStandard 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

  1. Foundation — install mrp module, set up Roastery stock locations, define work centers
  2. Products & BOMs — set up coffee pouches as raw material, configure new SKUs and their BOMs
  3. Custom blu_mrp sub-package — approval workflow, brand tracking, raw-material requisition wizard
  4. Reporting — manufacturing cost analysis, yield/loss, WIP aging (extends blu_reports)
  5. 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