BOM Cost Rollup & What-If Simulator
What-if simulator for supplier price negotiations: multi-level BOM cost rollup with comparable raw-material price scenarios
BOM Cost Rollup & What-If Simulator
What-if simulator for supplier price negotiations: multi-level BOM cost rollup with comparable raw-material price scenarios
For buyers and sourcing planners who negotiate raw-material prices. The app walks the full Bill of Materials tree of any manufactured product, recursively rolling raw-material and routing/operation cost up through every nested sub-assembly into one accurate finished-good unit cost. On top of that baseline, what-if scenarios let you override one or more raw-material prices anywhere in the tree and instantly see what a supplier's new price does to the finished-good cost before you accept it, and put two supplier scenarios side by side. Every scenario is a read-only simulation: the product's own standard cost is never written to.
Different job from standard costing: if you are a cost accountant who has to freeze an official standard cost, keep a version history of it and decompose actual-versus-standard variances by cost element, use BOM Cost Roll-up & Variance (bom_cost_rollup_variance) instead. This app deliberately stops at simulation and never sets a standard.
bom_cost_rollup_variance. Both define the
bom.cost.rollup model, and Odoo replaces one definition with the other instead
of merging them. If you try, the installation is stopped with a clear error message. Choose
one of them for a given database.
Key Features
Multi-level BOM cost rollup
bom.cost.rollup walks the entire mrp.bom tree recursively, summing raw-material lines (quantity times standard cost), routing/operation cost (workcenter hourly rate times manual duration), and every nested sub-assembly's own rolled-up unit cost before it feeds the parent.
Auditable rollup snapshots with full breakdown
Every rollup is saved with material cost, operation cost, total cost and unit cost, plus a level-by-level bom.rollup.line breakdown showing which component contributed how much at which depth of the tree.
Circular BOM detection
A sub-assembly that ends up including itself is detected while walking the tree (bom_ref cycle tracking) and blocked with a clear error instead of recursing forever.
What-if raw-material price overrides
bom.whatif.scenario overrides the price of one or more raw materials anywhere in the tree, including inside a nested sub-assembly, and recomputes the finished-good unit cost with the override applied.
Instant cost delta reporting
Each scenario reports both the absolute and percent impact (delta_amount / delta_percent) on the finished-good unit cost versus the untouched baseline rollup.
Scenario-vs-scenario comparison
A scenario can be compared directly against another scenario of the same rollup (e.g. Supplier A price list vs Supplier B price list) to see which is cheaper and by how much.
Product-level cost visibility
Every product template shows its latest rolled-up unit cost, rollup count and computed date, plus average/min/max variant standard cost, directly on the product form.
One-click rollup from the product form
action_compute_bom_rollup creates and computes a fresh rollup straight from a product's current Bill of Materials in a single click.
Use Cases
Screenshots
01 Rollup Form Breakdown
02 Rollups List
03 Whatif Scenario Form
04 Whatif Scenarios List
Why Choose This Module
Standard Odoo costing gives a single number with no visibility into how it was built, and no way to test a price change before it happens. This module makes the whole BOM tree transparent, level by level, and turns raw-material price negotiation into a what-if exercise instead of a guess, with the underlying rollup and comparison maths kept in an independently unit-tested engine so the numbers can be trusted at every level of the tree.
Specifications
- Compatible: Odoo 18.0 / 19.0 / 20.0
- License: OPL-1
- Languages: English
- Author: Pokutsoft
- Dependencies: mrp
- Support: support@pokutsoft.com
- Update date: 2026-10-02
Related modules
Standard Costing & Variance Analysis
Standard cost cards with material, labour and overhead variance analysis on production orders
MRP AI: Scheduling, Forecast, OEE & IoT
Finite-capacity scheduler, statistical demand forecasting (Holt-Winters/regression), OEE/MTBF/MTTR analytics and a shop-floor IoT telemetry endpoint - multi-plant.
Bakery Production Planning & Waste Control
Daily dough batch planning from rolling sales forecast, proofing/baking scheduling, ingredient shortage alerting, allergen roll-up, unsold/return waste-cost tracking and standing wholesale orders for bakeries