In today’s industrial world, where deadlines are increasingly tight and quality requirements are higher than ever, it becomes crucial for companies to streamline their internal processes.
Streamline Supplier Selection with Automation
Project Evaluation
- Storage of Technical Constraints
-
- Information Acquisition and Complexity Assessment Using a VBA script, information stored in the XML file is automatically acquired. This script conducts a thorough data analysis to calculate the project’s complexity level. Calculation tables in Excel format play a crucial role in this stage, providing accurate references and standardized formulas to evaluate the various dimensions of technical complexity.
Supplier Score Calculation (Scoring)
Once the project complexity level is determined, the next step involves evaluating potential suppliers based on their ability to meet technical requirements. A dedicated VBA script is used to assign scores to each supplier.
These scores reflect their ability to successfully execute the project, taking into account various factors such as their experience, equipment, and specific technical skills.
Capable Suppliers List: Generating Ordered List
Based on the assigned scores, the tool generates an ordered list of suppliers capable of successfully completing the project. This list is sorted by rank and capability score, providing a clear and hierarchical view of available options. This prioritization enables the client to confidently select the best suppliers, relying on objective and quantifiable criteria.