Alert text

Executive Summary

A mid-market, make-to-order (MTO) furniture manufacturer producing custom upholstered residential and commercial furnishings faced operational inefficiencies driven by manual production planning, disconnected inventory systems, and complex custom order management across multiple sales channels. The company implemented an integrated, cloud-based Odoo ERP platform encompassing Manufacturing Resource Planning (MRP), multi-level Bill of Materials (BOM) configuration, Inventory Management, Sales Order Management, and job costing. Within six months, the manufacturer reduced production lead times by 25%, improved custom order accuracy to 94%, increased finite capacity utilization by 35%, and reduced operational costs by 22% transforming a fragmented legacy environment into a unified, demand-driven, digital manufacturing operation.

Business Challenges

  • Manual production planning, Master Production Schedule (MPS) maintenance, and work center allocation in spreadsheets created scheduling conflicts and frequent rescheduling events across three work centers, delaying order initiation by 2–3 days per job.
  • Spreadsheet-based inventory and stock control produced low inventory accuracy, poorly tuned reorder points, and inadequate safety stock, resulting in material shortages, emergency purchasing, and unstable production cycle times.
  • Lack of real-time production visibility and on-time delivery metrics prevented sales from accurately promising delivery dates; typical make-to-order jobs required 30–50 email exchanges to reconcile custom specifications, order status, and delivery expectations.
  • Complex configure-to-order (CTO) and engineer-to-order (ETO) furniture configurations covering dimensions, fabric and material variants, wood frame options, and hardware components were manually re-entered across systems, causing 13% order accuracy errors and avoidable rework cycles.
  • Disparate accounting, manufacturing, and procurement systems hindered job costing, cost center allocation, and production cost variance analysis, obscuring gross margin by product family and limiting data-driven pricing and product mix decisions.

Objective

  • Consolidate production planning, MPS, and inventory management into a unified ERP platform that supports finite capacity scheduling and real-time work center utilization tracking.
  • Automate multi-level BOM (MBOM) generation and material requirement calculation for configure-to-order furniture, reducing quote-to-order cycle time and custom order entry errors.
  • Implement demand-driven, make-to-order production planning and Advanced Planning and Scheduling (APS) capabilities to reduce production cycle time and improve on-time delivery (OTD) performance.
  • Provide real-time order-to-cash (O2C) visibility so sales can commit reliable delivery dates based on actual capacity and material availability, increasing customer satisfaction.
  • Integrate job costing, cost center allocation, and production cost variance analytics to enable accurate margin tracking by product family, work center, and order type.
  • Support scalable, low-volume high-mix manufacturing growth targeting 40% order volume increase without proportional increases in overhead or headcount.

Key Modules Implemented

  • Manufacturing (MRP): Configured for multi-level BOM (indented BOM) structures, finite capacity scheduling, work order dispatching, routing sequences, and work center capacity requirement planning (CRP). Enabled demand-driven, make-to-order production orders and real-time tracking of production cycle time and first-pass quality.
  • Inventory Management: Implemented real-time stock control for raw materials, sub-assemblies, and finished goods with reorder point (ROP) rules, safety stock optimization, inventory turnover tracking, and WIP visibility across multiple warehouses. Integrated barcode-based material issue and cycle counting to improve inventory accuracy.
  • Sales Order Management: Centralized custom order management and quote-to-order workflow, including variant configuration for upholstery fabrics, wood types, finishes, and hardware. Automated delivery date promise accuracy using available-to-promise (ATP) logic tied to finite capacity planning and material availability.
  • Purchase Management: Automated purchase order generation based on MRP-driven material requirement planning, reorder points, and vendor lead time integration. Enabled multi-supplier sourcing, procurement cycle time reduction, and supplier performance tracking (on-time delivery, quality).
  • Accounting: Implemented job costing, work order costing, and cost center allocation by work center, with standard cost vs. actual cost comparison and production cost variance analysis. Delivered gross margin visibility by product family and manufacturing method (standard, MTO, ETO).
  • Warehouse / Stock Moves: Deployed barcode/RFID-driven warehouse operations for receipts, put-away, picking, WIP moves, and finished goods staging. Tracked lots/serials for materials and ensured accurate material consumption recording against work orders.

Solution Overview

  • Unified Order-to-Manufacture Workflow: Connected sales orders, custom configuration management, multi-level BOM expansion, MRP-driven material planning, and finite capacity scheduling into a single, end-to-end ERP workflow.
  • Advanced Planning and Scheduling (APS): Leveraged finite capacity scheduling, work center load leveling, and back scheduling capabilities to align the Master Production Schedule with real-world constraints and improve production cycle time.
  • Demand-Driven Make-to-Order Execution: Implemented a job-based production model where each confirmed custom order generates linked production orders, purchase requirements, and job costing records, eliminating decoupled forecast-only planning.
  • Real-Time Order and Inventory Visibility: Provided dashboards for OTD rate, work center utilization, WIP status, inventory days outstanding (IDO), and material shortage risks, improving decision-making across sales, planning, and operations.
  • Integrated Job Costing and Profitability Analytics: Connected material consumption, labor time capture, and overhead allocation directly to work orders and cost centers, allowing granular margin analysis by product family and customer segment.

Architecture & Implementation

#1: Discovery and System Design

  • Process Analysis and Value Stream Mapping (VSM): Conducted end-to-end mapping of the make-to-order, order-to-cash process—from configuration and quotation through production and delivery. Identified bottlenecks in Master Production Schedule creation, capacity planning, and material shortage handling that increased production cycle time and rework.
  • Current-State and Data Model Definition: Documented the existing low-volume high-mix production environment: three primary work centers (cutting/machining, assembly, finishing), multiple material categories (wood, foam, fabrics, hardware), and complex multi-level BOM hierarchies (average 10–12 sub-assemblies per custom item).
  • System Architecture and Module Scoping: Designed an integrated architecture centered on Odoo ERP Manufacturing, Inventory, Sales, Purchase, and Accounting modules. Defined data integration strategy for legacy systems, established product structure (base products, variants, attributes), and aligned work center capacities and calendars with finite capacity planning requirements.
  • BOM and Routing Design: Established standardized MBOM templates for core product families (e.g., custom sofas, armchairs, tables), including sub-assemblies, component variants, and routing sequences. Differentiated engineering BOM (EBOM) from manufacturing BOM (MBOM) where necessary to support design-to-production alignment.

#2: System Configuration and Data Migration

  • MRP and Finite Capacity Scheduling Configuration: Configured finite capacity planning for work centers, including shift calendars, machine capacity, setup and run times, and queue times. Enabled Advanced Planning and Scheduling (APS) rules to prevent infinite capacity assumptions and improve load leveling across cutting, assembly, and finishing stations.
  • Inventory and Replenishment Setup: Defined reorder point (ROP) and safety stock policies per material, integrated vendor lead times, and implemented just-in-time (JIT)-aligned parameters where feasible. Established WIP locations and configured real-time WIP tracking for better visibility into production cycle time and throughput.
  • Sales and Custom Order Management Configuration: Built a configure-to-order product configurator leveraging variant attributes (dimensions, fabrics, finishes, hardware). Automated expansion from customer specifications into multi-level BOMs and routing, directly feeding demand-driven MRP and material requirement calculation.
  • Job Costing and Cost Center Structure: Set up job costing rules to capture material, labor, and overhead per work order. Created cost centers by work center and product family, enabling standard cost vs. actual cost comparisons and production cost variance measurement.
  • Data Migration and Cleansing: Migrated product master, BOMs, open sales orders, supplier data, and historical inventory balances from legacy systems. Standardized product codes, material categories, and unit of measure, ensuring alignment with BOM and routing structures.

#3: User Training and Pilot Production

  • Role-Based Training for MTO Environment: Delivered training tailored for production planners (finite capacity scheduling, MPS adjustments, CRP), sales (quote-to-order, ATP, custom configuration), warehouse staff (barcode scanning, stock moves, cycle counting), finance (job costing reports, margin analysis), and executives (KPI dashboards, OTD monitoring).
  • Pilot Run and Parallel Operations: Executed a pilot with representative make-to-order jobs covering different complexity levels (standard, high-customization, upholstery-heavy, hardware-heavy). Compared ERP-generated material requirement planning, capacity plans, and lead time estimates against legacy methods to validate accuracy.
  • Feedback Loop and Configuration Refinement: Gathered planner and supervisor feedback on scheduling, work center loading, and job sequence logic. Tuned MRP parameters, buffer times, and scheduling heuristics to reflect actual production constraints and improve schedule adherence.

#4: Go-Live, Stabilization, and Optimization

  • Cutover to Unified ERP: Transitioned all new sales orders, production orders, and purchase orders to Odoo ERP. Legacy tools were retained only for reference reporting during a defined transition window.
  • Monitoring Key Manufacturing Metrics: Tracked key metrics during the first 8–10 weeks post-go-live: lead time, OTD rate, work center utilization, production cycle time by product family, material shortage incidents, and inventory days outstanding.
  • Continuous Improvement and Lean Adjustments: Leveraged VSM and production data to identify layout improvements and workstation rebalancing opportunities. Integrated Lean practices (e.g., reduced material movement, standardized work instructions) alongside ERP capabilities to further improve throughput and reduce non-value-added activities.
  • Knowledge Transfer and SOPs: Documented standard operating procedures (SOPs) for MTO scheduling, BOM maintenance, job costing, and inventory management. Ensured that operational teams could maintain and evolve the system configuration without constant external support.

Workflow

1

Sales Order & Custom Configuration (Quote-to-Order)

Sales captures customer requirements for custom residential or commercial furniture (dimensions, fabric/material variants, wood frame type, finish, hardware) in the ERP. The configure-to-order engine applies variant rules, expands a multi-level BOM, and runs ATP and finite capacity checks to generate a reliable delivery date. Quote generation time is reduced from 24-48 hours to minutes.

2

Material Requirement Planning & Procurement

MRP translates confirmed sales orders into material requirement calculations, considering on-hand stock, open POs, safety stock, and supplier lead times. The system auto-generates purchase orders for materials below ROP, optimizing procurement cycle time and minimizing stockouts and expedited purchasing.

3

Production Order Creation & Finite Capacity Scheduling

For each job, Odoo creates work orders tied to specific work centers with routing sequences. The finite capacity scheduling engine back schedules from the promised ship date, considering capacity, setup times, and existing load. Production planners review the Master Production Schedule and adjust in response to real-time constraints.

4

Shop Floor Execution & WIP Tracking

Operators execute work orders using barcode/RFID scanning for material issues, time tracking, and operation completion. WIP is tracked in real time, with dashboards showing job status (e.g., in cutting, in assembly, in finishing, in quality) and work center utilization across the plant.

5

Quality Checks & First-Pass Quality

Configured quality checkpoints at critical steps (e.g., frame integrity, upholstery fit, finish quality) ensure high first-pass quality. Non-conformances and rework cycles are logged against work orders, feeding continuous improvement and cost variance analysis.

6

Shipping, Order-to-Cash & Customer Visibility

Completed orders move to shipping with automated packing lists and shipping labels. Customers receive automated notifications and can access order status via a web portal. Once delivery is confirmed, invoices are issued, and revenue, costs, and margins are recorded at the job level.

7

Monthly Profitability & Performance Review

Finance and operations review job costing reports, production cost variances, OTD rate, capacity utilization, and inventory turns. Insights guide adjustments in pricing, product family focus, and continuous improvement priority areas.

Outcome

  • Lead Time Reduction: 8 Weeks → 6 Weeks (25% Improvement), Finite capacity scheduling, integrated MRP, and better alignment between MPS and actual capacity removed 2–3 days of planning lag, reduced rescheduling, and shortened production cycle time for make-to-order jobs.
  • On-Time Delivery Rate: 76% → 94%, Improved delivery date promise accuracy and real-time visibility across the order-to-delivery workflow increased OTD. Customers experienced fewer unexpected delays and more consistent delivery performance.
  • Custom Order Accuracy: 87% → 94%, Integrated custom order management and multi-level BOM expansion from standardized configuration rules reduced specification errors and rework cycles. First-pass quality improved significantly, reducing cost per unit on complex custom jobs.
  • Production Capacity Utilization: 68% → 91%, Finite capacity planning, work center load leveling, and improved routing reduced idle time and bottlenecks. The plant achieved 35% higher throughput without adding new lines or significant headcount.
  • Operational Cost Reduction: Eliminating manual spreadsheet coordination, reducing expedited purchasing and scrap, and automating key workflows lowered operational costs. Labor hours spent on administration and reconciliation decreased substantially.
  • Inventory Turns and Working Capital Optimization: Better inventory planning, optimized ROP and safety stock, and fewer material shortages improved inventory turnover and reduced inventory days outstanding. Freed working capital supported strategic investments in growth and modernization.
  • Profitability and Margin Insight: Job costing and cost center analysis delivered clear visibility into gross margin by product family, custom complexity level, and work center. The client identified underperforming product lines and adjusted pricing and production strategies accordingly.

Tech Stack

ERP Platform

  • Odoo v16 Enterprise Edition

Database

  • PostgreSQL

Cloud Hosting

  • Odoo.sh

Mobile App

  • Odoo Mobile app details (iOS/Android) with offline-sync
  • barcode scanning

Odoo Modules

  • Comprehensive list including Studio
  • Manufacturing, Inventory
  • Purchase
  • Accounting, Projects with specific use cases

REST APIs

  • Email/SMS
  • carrier APIs
  • Google Maps
  • cloud storage integration

Security & Compliance

  • SSL/TLS
  • RBAC
  • 2FA
  • GDPR
  • MDM

Team

  • Project Manager: 1
  • Solutions Architect: 1
  • Odoo Functional Consultants: 2
  • Technical Developer: 3
  • Data Migration Analyst: 1
  • QA/Trainer: 1

Our Clients

Client Testimonials

Rhonda Dibachi

CEO - HeyScottie

United States

Working with Aglowid was a game changer for us. We needed a partner who could understand the complexity of our AI automation goals and move quickly from concept to execution. They delivered a robust solution that not only met our requirements but opened doors to new possibilities. Truly professional and highly capable.

Daniel Gonell

Digital Strategy Consultant - New Minds Group

United States

I brought Aglowid's team in to support a major digital transformation project for one of our clients. Their depth in data architecture and front-end engineering helped us accelerate delivery and exceed expectations. They don’t just execute — they think critically and offer valuable insights every step of the way.

Katelyn Gleason

CEO and Founder - Eligible

United States

What impressed me most was their ability to adapt quickly to the unique demands of the healthcare space. Aglowid helped us refine our platform with performance upgrades and backend improvements — all without disrupting our users. Reliable, detail-oriented, and refreshingly easy to work with.

Robert Sirianni

CEO - Weapon Depot

United States

We needed a development team that could handle both the scale and complexity of a large eCommerce platform. Aglowid built a secure, fast, and user-friendly experience — both for web and mobile. Their communication was clear, and delivery was consistently on point.

Will Ferrer

Founder/CEO - Tempest House

United States

Aglowid stepped in as a true development partner. From initial product scoping to post-launch support, they handled full-stack development with precision and care. Whether it was mobile, backend, or AI-based features — they always brought smart solutions to the table.

Antoine de Bausset

CEO - BEESPOKE

France

They are great at what they do. Very easy to communicate with and they came through faster than I hoped. They delivered everything I wanted and more! I will certainly use them again!

Neil Lockwood

CO-FOUNDER - ESR

Australia

Their team of experts jotted down every need of mine and turned them into a high performing web application within no time. Just superb!

Craig Zappa

DIRECTOR - ENA PARAMUS

United States

"I would like to recommend their name to one and all. No doubt" their web app development services cater to all needs.

Let’s Get In Touch

    Accrediations

    Aglowid IT Solutions INC.

    Five Greentree Center, 525 RT 73 NT STE 104,
    Marlton, NJ 08053, USA

    Aglowid IT Solutions Pvt. Ltd.

    501, City Center, Science City Rd,
    Ahmedabad - 380060, India