Case study · Manufacturing

From 3-day planning cycles to same-day scheduling — one Odoo MRP implementation

A custom parts manufacturer was planning production in spreadsheets and WhatsApp. In 14 weeks we moved its BOMs, capacity, and replenishment into Odoo MRP.

Published Updated

Results at 90 days

68%fewer production stockouts in the first 90 days

Production stockouts first 90 days

Beforebaseline
After−68%

Emergency PO cost Q1, year over year

Beforebaseline
After−22%
Client
Custom parts manufacturer, midwest US
Industry
Manufacturing
Size
85 employees · 1 facility
Modules
Manufacturing, Inventory, Purchase, Quality, Accounting, Barcode
Timeline
14 weeks
Previous system
QuickBooks + spreadsheets
Engagement
Implementation, on site for go-live week

Before · 85 employees, one facility

The situation

Production planning ran entirely on spreadsheets and WhatsApp messages. The week's schedule was usually ready by Wednesday.

Mondays went to planning

The production manager spent the first half of every Monday collating open orders, stock, and machine capacity by hand.

The floor ran blind until Wednesday

With the schedule landing midweek, the shop worked without a plan three days out of every five.

Emergency buying at a premium

Materials bought outside normal procurement cycles cost the company 15–22% more.

Stockouts reached customers

Shortages caused partial shipments and customer penalties.

Discovery

What we found

Discovery documented three root causes, and one earlier attempt to fix them that had failed.

BOMs lived in a separate Access database

There was no automated chain from customer demand through the BOM to components.

No work-center capacity model

Scheduling ran on the planner's experience, not on data about machines and shifts.

No replenishment rules

Reorders happened after a shortage showed up, not before it.

A bolt-on MRP had already failed

QuickBooks had no manufacturing modules. An add-on MRP tried two years earlier was dropped after three months because it needed every inventory transaction entered twice.

14 weeks · five phases

What we did

Master data first, then capacity, then the planning logic, then a parallel run before cutover.

  1. Weeks 1–3

    BOM migration and master data

    We exported 340 BOMs from the Access database, checked them against actual shop-floor usage, and imported them into Odoo Manufacturing with correct component quantities and yield factors.

  2. Weeks 4–6

    Work-center configuration

    All 12 work centers modeled with real capacity, shift patterns, and downtime allowances. Routings for each product family, plus a shop-floor tablet view for operators to start and finish work orders.

  3. Weeks 7–9

    MRP and replenishment rules

    Make-to-order and make-to-stock set by product category. Reorder rules with safety stock based on 12 months of usage history, feeding automated purchase orders.

  4. Weeks 10–12

    Quality checkpoints and reporting

    Quality control points at three key work-center stages, and a production dashboard showing WIP, work-order backlog, and daily output against target.

  5. Weeks 13–14

    Parallel run, training, and go-live

    Two weeks of parallel running with production orders entered in both systems, and training by role. Go-live was the Monday of week 14, with our team on site through that week's production cycle.

Project at a glance

  • 14 weeks from kickoff to go-live
  • 340 BOMs cleansed, validated, and migrated
  • 12 work centers modeled with shifts and downtime
  • Two-week parallel run before cutover

Have a similar challenge?

Tell us how your shop plans today. We will scope the MRP project in a 30-minute call.

Book a discovery call

Measured after go-live

Results at 90 days

68%Fewer production stockoutsMeasured over the first 90 days after go-live
3d→<1hPlanning cycleMonday planning now takes under an hour; the first same-day schedule ran in week 2 after go-live
22%Lower emergency PO costFirst quarter after go-live against the same quarter a year earlier
AreaBeforeWith Odoo, configured by us
Weekly scheduleBuilt by hand, ready by WednesdayMRP runs overnight; exceptions approved each morning
Bills of materialsA separate Access database340 BOMs in Odoo, checked against usage
CapacityScheduled from experience12 work centers with shifts and downtime
Low stockFound after the shortageCaught 6 days before a halt, on average
Shop floorUpdates by WhatsAppWork orders started and finished on tablets

Odoo apps

Modules deployed

Six Odoo apps on one database, in place of QuickBooks and spreadsheets.

  • Manufacturing (MRP)
  • Inventory
  • Purchase
  • Quality
  • Accounting
  • Barcode

Ready to see your shop floor in real time?

The first call takes 30 minutes.

Or email sales@octagotech.com