Illustrative previewSpreadsheet-style production planning sheet and MPS workbench for Odoo
— grid planning, forecast vs actual, auto-MO, and inline shortage flags.
What is Production Planning Sheet / MPS Workbench?
Spreadsheet-style production planning sheet and MPS workbench for Odoo — grid planning, forecast vs actual, auto-MO, and inline shortage flags. Built to order by ECOSIRE for Odoo 17, 18, 19 — indicative price from $999.00 USD; request a quote for a scoped proposal.
Key Features
Built to order, done for you
No DIY setup — a working app, built, installed and supported by ECOSIRE.
- 1
You order
Start with a one-time build price. We scope it with you at kickoff.
- 2
We build & install
ECOSIRE builds, configures and installs it on your Odoo.
- 3
Go live + support
You go live in about one working week, with two weeks of go-live support. Defects in the code we deliver are fixed free of charge.
Technical Specifications
- Odoo Compatibility
- Odoo 17, Odoo 18, Odoo 19
- Editions
- Enterprise & Community
- License
- Licence confirmation required
- Python Requirement
- Python 3.10+
- Database
- PostgreSQL 12+
About this Product
Planning a factory one Manufacturing Order at a time is slow, error-prone, and impossible to see at a glance. The Production Planning Sheet / MPS Workbench replaces MO-by-MO data entry with a familiar spreadsheet-style grid: products down the rows, time periods across the columns, editable planned quantities in every cell. Your planners work the way they already think — in a matrix — while Odoo handles the manufacturing logic underneath.
This is a build-to-order Odoo module, engineered, installed, and supported by ECOSIRE for Odoo 17, 18, and 19 (Community or Enterprise). It is not an off-the-shelf apps.odoo.com download — after you order, our team scopes your BoMs, warehouses, and planning cadence, then builds and deploys the module to your database within a typical one working week lead time.
At the core is a Master Production Schedule (MPS) model built on Odoo's ORM (models.Model) with computed fields (@api.depends) that reconcile forecast demand vs. actual sales/MO consumption period by period. The editable grid is delivered as an OWL component backed by clean XML views, so inline edits write straight to planning records — no import spreadsheets, no re-keying. When a plan is ready, one action auto-generates the underlying Manufacturing Orders (mrp.production) from the sheet, respecting your Bills of Materials and routings.
Because it reads live stock and BoM data, the workbench flags material availability and shortages inline — a red cell tells the planner a component won't be there when the MO is scheduled, before the order is ever confirmed. Roll the whole view up by day, week, or month to switch between shop-floor detail and executive S&OP horizons in a click.
Security is done the Odoo-correct way: access is governed by ir.model.access.csv plus record rules so planners only touch their own warehouse/product categories, and QWeb reports give you a printable MPS. Automated actions can refresh forecasts on a schedule, and every planning record is reachable over XML-RPC / JSON-RPC for integration with external forecasting or BI tools.
You get the full source code (Odoo-native, upgrade-safe, no core patches), configuration tailored to your operation, documentation, hands-on training for your planners, and a post-launch support window. Optimized for planners who want the speed of a spreadsheet with the integrity of a single ERP source of truth.
What you get
- Complete, upgrade-safe Odoo module source code (models, OWL/XML views, security CSV + record rules, QWeb reports) with a clean __manifest__.py — no core patches
- Installation and deployment to your Odoo 17/18/19 database (staging first, then production) by an ECOSIRE Odoo engineer
- Configuration tailored to your operation — product/BoM mapping, warehouse scoping, planning cadence (daily/weekly/monthly), and forecast sources
- Access-control setup: planner and manager security groups wired through ir.model.access.csv and record rules to match your org structure
- Administrator and end-user documentation covering the grid workflow, MPS logic, auto-MO generation, and shortage flags
- Live training session for your production planners plus a recorded walkthrough for onboarding future users
- Post-launch support window with bug fixes and configuration adjustments (duration confirmed at scoping)
- Source handover to your Git/repository with deployment notes so your team retains full ownership
Who this is for
Production Planner
Prefers laying out a whole month of builds in a grid over clicking through Manufacturing Orders one at a time. Wants to type planned quantities per product per week, see shortages before confirming, and push approved cells straight into MOs.
Manufacturing / Operations Manager
Needs an S&OP-level view — roll the plan up to monthly, compare forecast vs. actual across product lines, and print an MPS report for the planning meeting without exporting to a separate spreadsheet.
Supply Chain / Materials Coordinator
Cares about component coverage. Uses the inline shortage flags and projected-inventory columns to spot which builds will stall on missing materials and trigger purchasing before the shop floor is blocked.
How Production Planning Sheet / MPS Workbench Compares
| Criterion | ECOSIRE | Custom Build | Competitor | Odoo Native |
|---|---|---|---|---|
| Spreadsheet-style multi-product, multi-period grid planning | Purpose-built editable grid inside Odoo | Possible but you fund the whole build and design | Rarely a true editable matrix; usually list forms | No — MO-by-MO entry only |
| Auto-generate Manufacturing Orders from the plan | One action generates mrp.production from cells | Depends entirely on what you commission | Sometimes, with varying BoM/routing fidelity | Manual MO creation per product |
| Inline material availability & shortage flags | Live per-cell coverage from stock and BoM | Must be specified and built from scratch | Limited or separate report, not inline | Not shown at planning time |
| Forecast vs. actual (MPS) reconciliation | Computed period-by-period with variance columns | Bespoke — you define and pay for the logic | Basic MPS in some apps; depth varies | MPS exists in Enterprise but not spreadsheet-grid style |
| Daily / weekly / monthly roll-up in one screen | Switchable period buckets built in | Additional scope to design and test | Fixed period model in many apps | Limited period flexibility |
| Built, installed & supported for your DB (17/18/19) | ECOSIRE builds, deploys, trains, supports | Your team or a freelancer carries all risk | Self-install .zip; support is generic/optional | Standard Odoo behavior, no tailoring |
| Upgrade-safe, no core patches | Clean module, no changes to Odoo core | Quality varies; core patches are a risk | Varies by vendor code quality | N/A — it is core |
| Role-scoped access via record rules | Planner/manager groups scoped to warehouse/category | Only if explicitly specified and built | Basic access; fine-grained rules uncommon | General MRP access groups only |
Frequently Asked Questions about Production Planning Sheet / MPS Workbench
Is this an instant download from the Odoo App Store?
No. This is a build-to-order module that ECOSIRE engineers, installs, and supports specifically for your database. After purchase we scope your BoMs, warehouses, and planning cadence, then build and deploy the module — there is no self-serve instant download or generic .zip.
How long until it's live, and what's the delivery process?
Typical lead time is one working week depending on catalog size and configuration complexity. The process is: scoping call → build against your Odoo version → deploy and test on staging → user acceptance → production deployment and planner training. We confirm the exact timeline at the scoping stage.
What support and updates do I get after it goes live?
Your order includes a post-launch support window (duration confirmed at scoping) covering bug fixes and configuration adjustments. We also keep the module compatible when you upgrade across Odoo 17, 18, and 19. You receive the full source code, so your own team can maintain it too, and extended support or enhancement retainers are available.
Does it work with my Odoo version and edition?
Yes — the module is built for Odoo 17, 18, and 19, on both Community and Enterprise. It builds on the standard Manufacturing (mrp) app and the ORM, and it does not modify Odoo core, so it stays upgrade-safe.
How does it turn the planning sheet into actual Manufacturing Orders?
Each editable cell is a planned quantity for a product in a period. When you approve the plan, a single action generates the corresponding mrp.production records, using each product's Bill of Materials and routing. You keep the spreadsheet workflow while Odoo owns the real MOs, stock moves, and traceability.
How is data access controlled between planners?
Access is enforced the Odoo-native way with ir.model.access.csv and record rules. We create planner and manager security groups and scope visibility to your warehouses or product categories, so a planner only sees and edits their own area of the plan.
Related Modules
Printing Press Management
A build-to-order Odoo module that turns print enquiries into costed estimates, routes approved jobs through press stages on a live job ticket, and closes the loop with material consumption, outwork tracking, delivery and billing.
Process Cost of Manufacturing Orders
A build-to-order Odoo module that captures the true cost of every manufacturing order by tracking material consumption, labor time, and overhead absorption on one MO-level cost sheet. ECOSIRE scopes, builds, installs, and supports it for your Odoo 17, 18, or 19 database.
Project Job Costing and Job Cost Sheet for Construction
A build-to-order Odoo module that gives construction teams a real job cost sheet per project — original estimate, committed, actual, and forecast cost-at-completion rolled up by cost code so you always know true margin. ECOSIRE scopes, builds, installs, and supports it on your Odoo 17, 18, or 19.
Production Planning Sheet / MPS Workbench
Spreadsheet-style production planning sheet and MPS workbench for Odoo — grid planning, forecast vs actual, auto-MO, and inline shortage flags.
- Editable spreadsheet-style grid — products as rows, time periods as columns, planned production quantity typed directly into each cell with instant recalculation
- Master Production Schedule (MPS) engine comparing forecast demand against actual sales orders and MO consumption, period by period, via computed fields (@api.depends)
- One-click auto-generation of Manufacturing Orders (mrp.production) directly from the planning sheet, respecting each product's Bill of Materials and routing
- Inline material availability and shortage flags — cells highlight when a component's projected on-hand won't cover the planned build at its scheduled date