Sunday, 23 March 2008

Kraljic matrix and Kraljic diagram in Excel


here we would like to present a solution in Excel that implements a Kraljic matrix and builds a Kraljic diagram. Profound information about Kraljic matrix can be found in wikipedia, but speaking generally it is a tool for the evaluation of strategic importance of some entities for the company. Usually, they are company's suppliers.

The system actually represents a questionnaire by means of which strategic importance of car components is evaluated. It is semi-automatized, provides intuitive interface and allows easy answering the questionnaire questions.

The developed system was a part of a university project for the evaluation of the strategic importance of Alfa Romeo suppliers by means of a questionnaire applied to the components of a chosen car model. Since it was a one-time project, it was created within one night in order not to spend much time on the development phase but to concentrate on the implementation one. That is why the system is semi-automatized: it does not allow you to "easily" create the questionnaire which is its only problem. Therefore, the usability can still be improved.

The file Excel consists of 3 sheets: one containing component names, another containing the questionnaire with questions, answers, answer weights, and the last one the actual Kraljic matrix and the Kraljic diagram.

From the managerial point of view the biggest difficulty of the system is a good balance of the questionnaire. It is highly recommended to think thoroughly every single question, its answers and (which is of key importance) their weights (numeric values). It is also required that highly competent persons or better groups of persons answer the questionnaire that can contain questions related to both specific technical and marketing areas.

Below you can see a video presentation of the Kraljic matix in Excel:

You can freely download the solution from our web-site
which is actually located in the category OUR PROJECTS
where you will find other projects, solutions, ideas and concepts. )


Anonymous said...

Hi, may I ask you the VBA project password to be able to adapt the scheme for my project? many thanks.

Anonymous said...

I was also interested to see what code you would need in this excel file. It would seem that all of it could be accomplished with just formulas. Could you please post the vba password or at least post an e-mail address where I can contact you about this?