Skip to main content
Book a free call
Menu
MPS Demand Forecasting icon

Odoo App · Manufacturing

MPS Demand Forecasting

A Forecast Assistant for the Odoo Enterprise Master Production Schedule: preview statistical forecasts, check conflicts, then write them into Forecasted Demand.

$49.00 Odoo 16.0 Odoo 17.0 Odoo 18.0 Odoo 19.0 Odoo 20.0 OPL-1

Overview

The native Odoo Master Production Schedule (MPS) expects planners to type Forecasted Demand by hand. This module adds a Forecast Assistant that calculates that demand from history, shows it next to the current MPS figures, and writes only the periods you accept.

Reusable Forecast Profiles hold the method and its settings: demand history periods, growth percentage, trend limits, WMA weights, seasonal cycles and Blend weights. A profile can sit on an MPS schedule, on a product category (with warehouse-specific matches first) or act as the company default. An assistant profile overrides all of them for a single run.

Applying is guarded. If a planner edits an MPS value after the preview, or the period falls inside the forecast lock horizon, the row is skipped and the reason is saved. Every run keeps its parameters, users, timestamps and period snapshots. Once periods close, a daily job compares applied forecasts with actual demand. Odoo still handles stock projection and replenishment through its own MPS workflow.

Key features

  • Six forecasting methods

    Native Odoo, Simple Moving Average (SMA), Weighted Moving Average (WMA), Linear Trend, Seasonal or Blend. Native profiles can use Actual Demand, Previous Year, Last 30 Days, Last 3 Months or Last 12 Months.

  • Forecast Profiles with fallback order

    Profiles resolve by assistant override, then schedule, then matching product category (warehouse-specific first), then company default.

  • Multi-product preview

    Select several MPS schedules in one run and preview them by yearly, monthly, weekly or daily periods, side by side with current MPS, system, committed and recommended quantities.

  • Conflict-aware apply

    Apply Selected writes checked rows. Apply Non-Conflicting picks every eligible unapplied row. Values changed after the preview are skipped with a recorded reason.

  • Forecast lock horizon

    Protect a set number of near-term MPS periods from forecast apply actions. Locked periods are skipped and the snapshot records why.

  • Growth overrides and actual demand floor

    Change the growth percentage for one run, and use the actual demand floor to keep recommendations at least as high as committed demand.

  • Accuracy analytics

    A daily scheduled action measures Bias, MAE, RMSE and WAPE on closed periods for forecasts previewed and applied before the period began. Pivot and graph views show the results.

  • Dynamic safety stock recommendation

    Optionally calculate safety stock from demand variability, lead time and service level. It is saved for review and never written to the MPS Safety Stock Target automatically.

  • Planner and Manager roles

    Forecast Planners preview and apply; Forecast Managers also maintain profiles and WMA weights. Company rules scope profiles, runs and snapshots.

Watch MPS Demand Forecasting in use

Odoo MPS Demand Forecasting video cover showing the Forecast Assistant form, a forecast preview chart and the forecast methods

A three-minute walkthrough of MPS Demand Forecasting on Odoo Enterprise's Master Production Schedule: choosing a forecast method (Native Odoo, SMA, WMA, Linear Trend, Seasonal or Blend), previewing proposed quantities against current demand, applying them to the schedule, and reading forecast accuracy on closed periods.

Watch “Odoo MPS Demand Forecasting | Advanced Forecast Assistant | Demand Planning & Accuracy Analytics” on YouTube

MPS Demand Forecasting in Odoo

Every screen, in the order you meet it — configuration first, then the module in use.

Forecast Profile in Odoo Manufacturing using the Native Odoo method with a Last 3 Months basis, history periods and SMA fallback
MPS schedule form with an Advanced Forecast section showing the profile, forecast mode, lock horizon of 2 and last forecast run
Forecast Assistant dialog over the Master Production Schedule with company, warehouse, monthly period scale and selected MPS schedules
Native Odoo forecast preview proposing 126.67 per month against current MPS and committed quantities, with Apply Selected and Apply Non-Conflicting buttons
Batch forecast preview for two products, one using Trend with a no-history note and one using SMA, across 24 monthly rows
Applied forecast snapshot with recommended and applied quantity of 33.33 and a dynamic safety stock recommendation of 155.09
Odoo Master Production Schedule grid with Forecasted Demand of 126.67 written into each month from October 2026 to September 2027
Forecast apply result showing 0 lines applied and 1 conflict skipped, with the changed March period highlighted in red
Applied forecast run with closed-period accuracy metrics: Bias -4, MAE 4, RMSE 4 and WAPE 66.67%
Forecast Accuracy pivot comparing recommended, applied and actual demand quantities with absolute and signed error for October 2026

Technical details

Specification

Publisher
TechUltra Solutions Private Limited
Technical name
tus_mps_advanced_forecast
Odoo versions
16.0, 17.0, 18.0, 19.0, 20.0
Lines of code
1,980
Edition
Odoo Enterprise (needs the native Master Production Schedule, mrp_mps)
Forecast methods
Native Odoo, SMA, WMA, Linear Trend, Seasonal, Blend
Period scales
Yearly, monthly, weekly, daily
Accuracy metrics
Bias, MAE, RMSE, WAPE
License
Odoo Proprietary License v1.0 (OPL-1)
Price
$49.00 (one-time)

Deployment

  • Odoo Online (Enterprise)
  • Odoo.sh (Enterprise)
  • On-premise (Enterprise)

Odoo dependencies

  • Manufacturing
  • Master Production Schedule (Enterprise)
  • Inventory
  • Purchase
  • Invoicing
  • Discuss

Support

90 days of bug-fix support plus 5 hours of free configuration help (additional hours billable), Monday to Friday (10:00–19:00 IST). Raise a ticket at support@techultra.in.

Setup & configuration

From install to first call — here is the path.

  1. 1

    Assign forecast roles

    In Settings → Users & Companies → Users, open Access Rights and set MPS Advanced Forecast (under Supply Chain) to Forecast Planner or Forecast Manager. Users also need the native MPS permissions.

  2. 2

    Create a Forecast Profile

    With Forecast Manager access, open Manufacturing → Configuration → Forecast Profiles. Pick a method and set demand history, growth and optional safety stock settings.

  3. 3

    Link profiles to MPS schedules

    Assign a profile on each MPS schedule, or rely on category and company defaults. Set the Forecast Lock Horizon to protect near-term periods.

  4. 4

    Generate a preview

    Open Manufacturing → Planning → Advanced Forecast → Forecast Assistant, or use the button on an MPS schedule. Select schedules and a period scale, then click Generate Preview.

  5. 5

    Apply and review

    Use Apply Selected or Apply Non-Conflicting, then check the updated Forecasted Demand in the MPS grid and any conflicts recorded on the run.

Frequently asked questions

  • Which Odoo edition does MPS Demand Forecasting need?

    Odoo Enterprise with the native Master Production Schedule (mrp_mps). The module writes reviewed quantities into native Forecasted Demand; Odoo manages Forecasted Stock and replenishment. It does not create purchase or manufacturing orders itself.

  • Which forecasting methods are included?

    Native Odoo, Simple Moving Average (SMA), Weighted Moving Average (WMA), Linear Trend, Seasonal and Blend. Native forecasts can be based on Actual Demand, Previous Year, Last 30 Days, Last 3 Months or Last 12 Months. Seasonal forecasts fall back to SMA when fewer than two seasonal cycles are available.

  • What happens if a planner edits the MPS after a preview?

    That period is skipped and a conflict reason is saved. Periods inside the forecast lock horizon are protected the same way. Rows that were applied successfully are not applied again.

  • How is forecast accuracy measured?

    A daily scheduled action refreshes completed outgoing demand after a period closes. It evaluates the latest forecast that was previewed and applied before the period began, and reports Bias, MAE, RMSE and WAPE. Future periods, never-applied previews and late-applied forecasts are excluded.

  • How is the forecast profile chosen?

    An assistant profile overrides everything for that run. Otherwise the module uses the schedule profile, then a matching product-category profile (warehouse-specific matches first), then the company default.

  • Does dynamic safety stock update the MPS target?

    No. It calculates a recommendation from demand variability, lead time and service level and saves it in the period snapshot. Planners decide whether to update the native Safety Stock Target.

  • How does this differ from TechUltra's AI Inventory Forecast?

    This module works inside the Enterprise MPS and writes to its Forecasted Demand. AI Inventory Forecast predicts demand per product and location with NeuralProphet and suggests reorder quantities, without needing the MPS. See its page for the versions it supports.

Listing verified against the Odoo App Store:

Related solutions

Whole-platform solutions that complement MPS Demand Forecasting.

Related services

Get the most out of this module with senior TechUltra consultants.