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

Process Automation

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

Scroll to Case Study

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:

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.

Challenges.

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:

Solution.

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:

Approach.

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

Contact us.

Share your challenges. We will get back to you within 24 hrs.Talk to us for free consultation up to 1 hour.