Automated sales order management for bespoke furniture manufacturing company generates efficient and accurate BoMs

Automated sales order management for bespoke furniture manufacturing company generates efficient and accurate BoMs Banner

Client Profile.

The client is a bespoke furniture manufacturing company based in California, USA, specializing in store fixture and display furniture. Their client base includes hundreds of retail stores across the world.

Business Need.

The company offers a range of products made of different types of wood such as MDF, particle board, laminates etc. as well as metal millwork furniture. With a high product-mix and no single utility application:

  • It was increasingly becoming difficult to manage orders and generate custom quotations using manual log book systems using Excel spreadsheets to generate sales orders
  • Lengthy and tedious documentation processes
  • Difficulties in choosing the appropriate wood type from 29 standard types offered

Thus, they were looking to reinvent their order management processes by automating quote generation. This would help them increasing productivity and adhere to the industry recognized quality standards.


An assessment of as-is process highlighted that the client used 31 different Excel spreadsheets for every customized order to manually enter and save specifications and calculate the total price. This threw up the following challenges for the project team:


We designed MS Access database using VB scripts to manage order documentation and processing and automate BoM calculation. A single intuitive interface offered suggestive inputs and streamlined internal flow requests between sales, design, manufacturing, installation and customer service divisions. It offered:


Understanding and analyzing the ‘as-is’ process to define the scope of automation

Developing automation interface using VB Scripts and MS Access Database

Two level quality checks to ensure zero errors

Deployment and integration with the client’s business system

Business Impact.

Reduced TAT for quotation by 80%
Better control over price margin with changing costs of raw material
Enhanced process efficiency with zero human intervention
Decreased material wastage and operational risks
Share your Challenges Email us!

Call us now!


Connect with us

Facebook Icon linkedin icon twitter icon