Case Study · Modular Furniture Manufacturing
How a Modular Furniture Maker Cut Project Delays by 62% with Connected Workflows
Industry
Modular Furniture Manufacturing
Revenue Band
₹20, 35 Cr annual turnover
Company Size
100, 150 employees
Tools Deployed
Zoho Creator, Inventory, Projects, Analytics
The Problem
This modular furniture manufacturer handles 40+ concurrent modular kitchen and wardrobe projects, each with unique panel sizes, hardware specs, and site constraints. Design teams, cutting operators, and dispatch coordinators worked from separate spreadsheets, WhatsApp threads, and paper BOMs, causing a cascade of rework, wrong shipments, and missed installation dates.
Design to BOM Disconnect
Designers finalized layouts in CAD software, then manually re-entered panel dimensions and hardware counts into Excel BOMs. Transcription errors caused wrong cuts in 1 out of every 8 orders, requiring re-cutting and fresh material procurement.
Blind Dispatch Scheduling
The dispatch team had no visibility into cutting floor progress. They scheduled site deliveries based on estimated dates, not actual production status. Nearly 35% of deliveries arrived with missing or incomplete components, forcing return trips.
Untracked Material Waste
Offcuts and surplus panels were not logged after cutting. The procurement team reordered full sheets for every new project instead of checking available remnants. Annual material waste exceeded ₹18 lakh with no way to trace where the loss occurred.
The Solution Stack
The implementation centred on connecting the full project lifecycle, from design sign-off to site handover, into a single data flow. Each module was configured to feed the next stage automatically.
Design Approval & BOM Generation
- Custom app for designers to upload approved layouts and auto-generate structured BOMs with panel codes, edge banding specs, and hardware quantities via Zoho Creator custom applications
- Revision control with version history, so cutting always references the latest approved design
- Approval workflow with customer sign-off captured digitally before production begins
- Remnant lookup built into BOM creation, flagging reusable offcuts before new sheet procurement
Material Tracking & Procurement
- Real-time stock levels for sheets, laminates, hardware, and edge bands synced with BOM requirements through Zoho Inventory tracking
- Auto-purchase orders triggered when project-specific material falls below threshold
- Offcut inventory register with dimensions, so remnants are consumed before new sheets are ordered
Production & Delivery Coordination
- Each order mapped to a project with milestones: BOM Ready, Cutting Complete, Edge Banding Done, QC Passed, Dispatched, Installed
- Task dependencies ensure dispatch scheduling only activates after QC sign-off
- Gantt view for operations manager to track 40+ concurrent projects against promised site dates
- Automated alerts to site installation crew 48 hours before scheduled dispatch
Waste Tracking & Delivery Performance
- Dashboard tracking material utilization rate per project, per sheet type
- Delay analysis report breaking down root causes: design revision, material shortage, cutting backlog, or transport
- Monthly waste cost trend with drill-down by product category and supplier
Before vs. After
| Process Area |
Before Zoho |
After Zoho |
| Design to BOM |
Manual Excel entry, 4-6 hours per project |
Auto-generated from Creator app in under 90 minutes |
| BOM Accuracy |
12% error rate causing re-cuts |
Under 2% error rate with version-locked BOMs |
| Dispatch Scheduling |
Based on estimated dates, no production visibility |
Triggered by QC milestone completion in Projects |
| Incomplete Deliveries |
35% of shipments missing components |
Under 5%, with packing checklist tied to BOM |
| Material Waste Tracking |
No offcut register, full sheets reordered every time |
Remnant inventory checked before every purchase order |
| Project Visibility |
WhatsApp updates, no single source of truth |
Gantt dashboard with real-time milestone status |
| Delay Root Cause |
Finger-pointing between teams, no data |
Analytics report attributing delays to specific stages |
Implementation Phases
01
Discovery & Process Mapping Weeks 1, 2
- Shadowed design, cutting, and dispatch teams across 3 live projects
- Documented the full order-to-installation lifecycle with handoff gaps
- Catalogued material types, sheet sizes, and hardware SKUs for Inventory setup
- Identified the top 5 delay causes from the last 6 months of delivery records
02
Creator App & Inventory Configuration Weeks 3, 5
- Built the design approval and BOM generation app in Zoho Creator
- Configured Zoho Inventory with item groups for sheets, laminates, edge bands, and hardware
- Created the offcut register with dimension fields and reorder rules
- Integrated Creator BOM output with Inventory for auto-stock deduction
03
Projects Setup & Team Training Weeks 6, 8
- Configured project templates with milestone stages and task dependencies
- Linked Creator approval events to auto-create Projects entries
- Trained cutting floor supervisors, dispatch coordinators, and site installation leads
- Ran 5 pilot projects in parallel with the old process to validate accuracy
04
Analytics & Full Rollout Weeks 9, 10
- Built Zoho Analytics dashboards for waste tracking, delay analysis, and project throughput
- Retired Excel BOMs and WhatsApp-based dispatch coordination
- Enabled automated weekly performance reports sent to operations and procurement heads
Results
Within 12 weeks of full adoption, the operations team reported a visible shift in how projects moved through the factory floor. Design revisions stopped causing surprise re-cuts because the cutting team always worked from the latest locked BOM. Dispatch scheduling became predictable because it was tied to actual QC completion, not guesswork.
0%
Fewer project delivery delays
0x
Faster design-to-BOM conversion
₹0L
Annual material waste cost reduced
Key Metrics: Before vs. After
What This Means for Modular Furniture Manufacturers
Most modular furniture operations do not have a production accuracy problem. They have a handoff problem. When design, cutting, and dispatch teams work from separate data sources, rework and missed deadlines become structural. Connecting the BOM to inventory to project milestones closes the gaps that spreadsheets and messaging apps cannot. A structured Zoho implementation builds that connected layer without replacing the tools teams already know.
Frequently Asked Questions
Can Zoho Creator handle complex BOMs with nested components like drawers and pull-out units?
Yes. The Creator app was configured with parent-child relationships, so a single wardrobe order can contain multiple sub-assemblies. Each sub-assembly carries its own panel list, hardware count, and edge banding spec. The BOM rolls up all components into one procurement-ready list that feeds directly into Inventory.
How does the system handle design revisions after cutting has already started?
Every BOM in Creator is version-locked at the point of cutting approval. If a customer requests changes after that stage, a new revision is created with a clear diff showing what changed. The cutting team sees only the active version, and the cost of rework is logged against that revision for accurate project costing.
What happens when an offcut in inventory does not exactly match the required panel size?
The remnant lookup checks if any available offcut can be trimmed to the required dimension with acceptable waste. If the trim loss exceeds a configured threshold (set at 15% for this factory), the system recommends ordering a fresh sheet instead. This prevents using remnants that would generate more waste than they save.
How long does it take factory floor staff to adopt the new system?
Cutting supervisors and dispatch coordinators were productive within 2 weeks. The Creator app uses a simple form-based interface, not a full ERP screen, so data entry feels familiar. The biggest shift was for designers, who needed 3 weeks to build the habit of uploading layouts to Creator instead of emailing Excel BOMs.
