BOM Cost Rollup & What-If Simulator
Multi-level BOM cost rollup with raw-material price what-if scenarios
BOM Cost Rollup & What-If Simulator 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 planners override one or more raw-material prices anywhere in the tree and instantly see the resulting cost delta, without ever touching the product's real standard cost.
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
- License: OPL-1
- Languages: 35+
- Author: Pokutsoft
- Dependencies: mrp
- Support: odoo@gencbaris.com
- Update date: 2026-07-13
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Manufacturing (mrp)
• Inventory (stock) • Discuss (mail) |
| Lines of code | 900 |
| Technical Name |
bom_cost_rollup_whatif_simulator |
| License | OPL-1 |
| Website | https://pokutsoft.com/ |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module