MTO / MTS Analysis
How much to make this month, with the order and the average side by side
Crosses what the customer already ordered with what they usually buy each month, subtracts stock, and drills through the bills of materials to say what to make and what to buy. It changes nothing in your system.
How you get it
Every development works in all three Odoo environments. The only thing that changes is how we deliver it.
Odoo Online (SaaS)
You do not need the ability to install modules. A Millora consultant comes in with temporary access that you authorize and implements it with Odoo Studio. When they are done, you revoke the access.
Odoo.sh or your own server
You receive the module and the installation guide by email as soon as payment clears. Install it yourself, or we install it with you.
Installation · shell
# 1 · copia el módulo a tu addons_path
cp -r millora_analisis_mto_mts /mnt/extra-addons/
# 2 · reinicia y actualiza la lista de apps
odoo-bin -u all -d tu_base --stop-after-init
# 3 · instala desde Apps
# busca "MTO / MTS Analysis"What it solves
The problem
There are two ways to get production planning wrong, and both cost money.
Build only against orders and a product you sell every month runs out exactly when the order lands — that's where the firefighting starts. Build only against the historical average and a large order the average never saw coming leaves you with nothing to ship.
Odoo holds both numbers, but on different screens. Crossing them ends up being a spreadsheet somebody rebuilds every month.
How it works
You pick the month you're planning, the customers, and how many months back to average. The analysis computes two figures per product: MTO, what those customers ordered and haven't received, and MTS, what they buy per month on average.
It doesn't add them — that would count an order placed months ago twice — it takes the larger one and subtracts on-hand stock. A column tells you which of the two drove the number, and filtering for the ones driven by the average surfaces the steady sellers nobody was scheduling.
No number has to be taken on faith: every figure opens into a breakdown of the orders behind it, one by one, with customer and committed date. Only orders due within the month are pre-selected; an annual order due in December stays visible without inflating the plan, and one from a year ago is flagged separately because it usually should have been cancelled. You can deselect orders, enter partial quantities or type the number by hand, and what you enter survives re-reading sales.
Once the plan is set, the analysis explodes the bills of materials through every level and consolidates components shared across products. Whatever has a bill of materials goes to production; whatever doesn't is your purchasing list. A component's stock is shared across the products that use it instead of assuming there's enough for all of them.
What changes
The monthly plan stops being a spreadsheet only its author understands. Every quantity is backed by concrete orders, and if someone questions the plan three months later, the breakdown is still there.
And one deliberate guarantee: the analysis moves nothing. It creates no manufacturing orders, reserves no stock and touches no sales orders. The decision stays with the planner.
What's included
- Computes the requirement as the greater of pending orders and the monthly sales average
- Opens a breakdown of every figure with the orders, customers and dates behind it
- Pre-selects only orders due within the month and leaves the rest visible without adding them
- Flags orders older than the period, which are usually cancellation candidates
- Lets you enter partial quantities per order or override the product quantity by hand
- Keeps what you entered when sales are re-read, as long as the order still exists
- Explodes bills of materials through every level and consolidates shared components
- Shares each component's stock across the products that use it, never counting it twice
- Separates what is manufactured from what is purchased by whether the component has a bill of materials
- Spans two companies: one holding the sales orders, another holding the bills of materials and stock
Requirements
- Sales, Manufacturing and Inventory modules active
- Bills of materials loaded in the manufacturing company: without them there is no component explosion
- Confirmed sales orders. Quotations are not included in the calculation
- A user with Manufacturing permissions: access to the analysis is granted through that group
You might also need
Bill of Materials Explosion
What you need to build the whole plan
Manufacturing
Company Color Bar
Know which company you're in at a glance
Administration
AutoAzur Global Invoice Reconciler
One global CFDI, hundreds of orders, one run
Accounting & tax