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)

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?

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