In Mind Cloud Blog

Modelling In CPQ Made Easy With Excel [Updated]

Posted by Sabine Kempe on Nov 10, 2020 11:51:00 AM
Sabine Kempe
Find me on:

By the words of Vincent Van Gogh: “Great things are done by a series of small things brought together.” In the manufacturing world, these series of small things translate into large BOMs (Bill of Materials) and the "bringing together" can be called complex configuration. Consequently, for manufacturing companies, product modelling and maintenance are a crucial part of their sales process.

This is especially true if they have an extensive product catalogue or if they operate in made-to-order (MTO) or engineering-to-order (ETO) scenarios. In these cases, the product quoted by the sales representative has not been manufactured yet. The configuration must be done very carefully in order to avoid mistakes.

The need for such precision makes product modelling one of the most important features in your Configure, Price, Quote (CPQ) software. When implementing a CPQ, companies need to consider what can be done through the software or where they will need to pay for additional services. In Mind Cloud’s Manufacturing X CPQ, for example, supports all manufacturing business scenarios and the modelling can be done through reusing LO-VC, directly in the system, and even via Excel. This possibility is a real competitive advantage for our customers. Indeed, using “good old” Excel can be a great fit, let’s see how.

Excel Modelling in CPQ - The ease of use is crucial for users

To perform product modelling in Excel you don’t need programming knowledge, or a technical background. If you have a sales (engineering) team with good product knowledge, they can do their own modelling in an easy, straightforward way. No technical training required, no additional expertise needed.

Excel Modelling in CPQ - Why flexibility counts double for manufacturers

Every important parameter to be taken into account when configuring a product can be factored via Excel–even in the most complicated manufacturing configuration scenarios. Once the overall configuration logic is clear, it can be accurately defined in the Excel file. For example, value restriction, characteristic restriction, domain restriction, BOM explosion, etc. All of which can be configured using Excel and then uploaded to the CPQ.

Another option is to extract predefined attributes from your ERP, reuse them in your model in Excel, and upload it to your CPQ. 

Your most up-to-date product models - this is real business agility

Since using Excel is easy, models can be created or updated in a timely manner. So if models require updates or rule changes you can download the Excel file, perform your mass changes conveniently in Excel and then upload the file again. Built-in validation checks will make sure that your models are correct, and the system tells the user how to fix it without the need to consult IT specialists.

The amount of time saved is significant for manufacturing and engineering businesses. 

Customer-centric sales through Excel

Businesses with a customer-centric approach experience much higher win-rates in the context of today's increased customer demands. Manufacturers that are looking to provide the most relevant information to their customers and close deals faster, should be able to do this quickly and efficiently. A CPQ system that supports enriching data models with rich text information in Excel, will help you deliver just the right information to your customers through your preferred channels. A detailed characteristics visualization in 2D, 3D, video or through text is key for complex products. This could happen through your commerce portal or a guided selling questionnaire that your sales reps are going through together with your customer. 

Summary:

In short, Excel modelling is an excellent solution for manufacturing companies that value speed and simplicity. Even complex configuration logics can be transferred into Excel. Mass changes are also much easier in Excel. Since the file is uploaded to the CPQ, the changes are instantly available. This flexibility can be a real game-changer in the Age of the Customer, who is demanding speed and agility every step of the way. 


If you would like to learn more about our CPQ for manufacturing industries, book a demo and we will show you how we can tackle your specific sales challenges.

BOOK A DEMO

Sign Up For Our Newsletter

Sabine Kempe

Written by Sabine Kempe

Sabine - a manufacturing sales expert and cloud enthusiast at heart, she is dedicated to matching the challenges of manufacturing businesses with the opportunities of a digitalized world.

Leave a Comment