Why a standard product record is not enough in furniture
Because what is sold is usually a configured product: the same model is sold with different dimensions, fabrics, colours, handles and mechanisms. Opening a separate record for every combination is unmanageable; the right approach is a configurator where options affect the bill of material and price through rules.
Critical processes
- Product configuration: options constraining each other, and their effect on price and bill of material.
- Made-to-measure production: turning customer dimensions into a cutting list, with responsibility recorded when a measurement is wrong.
- Panel optimisation: cutting plans and waste calculation across order combinations, plus remnant stock.
- Assembly and delivery: assembly crew planning, delivery appointments and site constraints such as floor level or lift access.
- Hardware stock: low-value but critical parts — hinges, runners, handles — blocking an order when missing.
- Service and warranty: post-delivery part replacement, warranty scope and service cost tracking.
Which solution maps to what
Bills of material, production and costing fall under ERP consulting and development; the configurator and cutting optimisation usually require custom software development. Dealer ordering uses the B2B dealer portal, own stores use retail POS, online sales use e-commerce software, and assembly crews use mobile app development. The effect of order-time bills of material on costing and planning is in the ERP guide for manufacturers, and the effect of scope on the budget in the ERP investment and TCO pre-assessment tool.
Mandatory integrations
CNC and panel saw machines, edge banding job lists, barcode and label printers, e-invoicing and e-dispatch, shipping and haulage, bank statements and accounting.
Where we start
In furniture the starting point is usually two separate worlds: series production runs on stock logic, while project work runs on quotes and measurements. When the two do not meet in one system, shared materials and capacity get planned twice.
The first exercise produces a product type separation: which items are stocked, which are made to order, and which are configurable (dimensions, fabric, colour). That separation determines whether the bill of material is fixed or generated at order entry.
What the data model must make explicit
- Configurator rules: selectable dimension ranges, fabric and colour combinations, and incompatible-choice rules.
- Bill of material at order time: the configured product's structure stored on the order line; it cannot be recalculated later.
- Module relations: separate stock records for modules in sets, with the set-to-module link.
- Installation and delivery: delivery appointment, installation crew, completion record and missing-part reports.
- Panel consumption: cutting plans and remnant panel management.
- Fabric and hardware: consumption by length and a record of batch (shade) differences.
Roll-out sequence
- Products and configurator: product types, option rules and pricing logic.
- Orders and production: bill of material generation at order entry, work orders and cutting plans.
- Dispatch and installation: delivery scheduling, crew assignment and missing-part tracking.
- Dealer and retail channels: ordering via the B2B portal, store stock and the online channel.
What we measure
- Order-to-delivery time, separately for configured and stocked items
- Rate of missing or damaged part reports after installation
- Panel cutting waste and the utilisation rate of remnant stock
- Most and least selected configurator options
- Number of missed delivery appointments
Common mistakes
- Binding configured products to a single stock card. Different structures accumulate under one code and cost collapses into an average.
- Not storing the bill of material as of the order date. When prices or option lists change, past orders cannot be recalculated.
- Treating installation as part of dispatch. Orders delivered but awaiting installation drop off the open order list too early.
- Not recording fabric batch differences. Shade variation within one product is discovered at installation and generates returns.
Frequently asked questions
Can the configurator be exposed to dealers?
Yes, and it is one of the highest-value applications because it prevents dimension and option errors at order time. The condition is that price and rules are calculated in one place with the portal only displaying the result.
How is the assembly appointment connected?
Production completion date and assembly crew capacity must be planned together. An appointment based on production date alone slips when the crew is full, and the resulting dissatisfaction is invisible on the production side.
Should remnant panel stock be tracked?
Yes, as separate records with dimensions. Remnants tracked only as total square metres cannot be found when a suitable job arrives and effectively become waste.
Can the configurator serve both dealers and end customers?
Yes, provided price and option rules are calculated in one place. Dealers and end customers see different price lists but use the same rule engine. With two engines, incompatible option combinations eventually reach production.
How is stock planned for made-to-measure production?
Finished goods cannot be stocked; planning runs on materials and capacity. That requires generating the configured product's bill of material at order entry and calculating material requirements from it.
How is the post-installation missing-part process set up?
The installation record must exist in the system, and a missing-part report should automatically raise a dispatch request. Without that link, missing parts are chased by phone and the customer's waiting time cannot be measured.
