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 www.yRiver.it
(Alfa_Romeo_Kraljic_matrix.zip)
which is actually located in the category OUR PROJECTS
where you will find other projects, solutions, ideas and concepts.

31 thoughts on “Kraljic matrix and Kraljic diagram in Excel”

Fantastic tool – great work.

I have downloaded the example and would like to re-work it to fit my situation, but the problem is that I can not unhide the coloumns beyond AR in the “Rates” sheet.

I like your Excel file for support the Kraljic matrix very much, it is really very useful tool. Hovewer unfortunately there are some problems when changing the original data in Questions sheet to my customized situation, the final graph in Rates sheet shows then almost nothing, all the results in this graph are then somewhere in its bottom left corner. I cannot find out why. When trying to solve this problem by myself I have found that there is also a password required..
Please, could you help me? I am a student, so I need it only for academic purposes.

Great work,
I used your example to develop my kraljic matrix with the objective of situated the supplier on the matrix, if you want, i can send you my work

i can’t download the file (Alfa_Romeo_Kraljic_matrix.zip). May you send me the file to my Email: gorby58@gmail.com.
Thank you so much!
Best regards
Sergio

Hi, I found really interesting you video. It could be nice if you can share again this excel sheet. Id like to apply a similar in a biology concept. Anybody has got a copy? my email: marcopolifrone@gmail.com.

I like your Excel file for support the Kraljic matrix very much, it is really very useful tool. Unfortunately I can’t download it, can everyone send this file to micaela.valent@gmail.com?

i can’t download the file (Alfa_Romeo_Kraljic_matrix.zip). Could you send me the file (also the password please) to my Email: francesco.valpiani@virgilio.it.
Thank you so much!
Best regards
Francesco

Hello,
I cannot download the file and I really would like to see the example.
Could someone send it to me to beatrizlafeliz@gmail.com?
Thank you in advance!!
Regards

Fantastic tool – great work.

I have downloaded the example and would like to re-work it to fit my situation, but the problem is that I can not unhide the coloumns beyond AR in the “Rates” sheet.

Any help on that would be highly appreciated.

Thanks,

Morten

Dear author,

I like your Excel file for support the Kraljic matrix very much, it is really very useful tool. Hovewer unfortunately there are some problems when changing the original data in Questions sheet to my customized situation, the final graph in Rates sheet shows then almost nothing, all the results in this graph are then somewhere in its bottom left corner. I cannot find out why. When trying to solve this problem by myself I have found that there is also a password required..

Please, could you help me? I am a student, so I need it only for academic purposes.

Thanks a lot

Daniel

the file can’t found . would anyone share it again?

thanks

yi

Great work,

I used your example to develop my kraljic matrix with the objective of situated the supplier on the matrix, if you want, i can send you my work

Dear Luca,

I would be very interested to your work. My mail is gorby58@gmail.com.

Waiting for your file I remain. Thanks.

Best regards.

Sergio

whats the macro passowrd?

could someone please share the password?

i can’t down (Alfa_Romeo_Kraljic_matrix.zip)

Please send me to emal: huonggiang12186@gmail.com

thanks so much

i can’t download the file (Alfa_Romeo_Kraljic_matrix.zip). May you send me the file to my Email: gorby58@gmail.com.

Thank you so much!

Best regards

Sergio

Could somebody send me the file as well?

Email: judithvleersum@gmail.com.

Thank you very much!

Kind regards,

Judith

Would really appreciate the download too!

ryantdouglas@hotmail.com

Many thanks

Ryan

Tool looks good. unfortunately I am not able to open it.

I will appreciate if sombody send me the fille as well.

thanks and regards,

Marcel

Hello,

I can’t dowlonad the file either, can you send it to my mail : ele.menard@gmail.com

Thank you

please send it to me as well (gulomjon@gmail.com), can not open,

thx

Hi,

Please send me the file as well as can not open the page and download it.

Thx.

Hi, I found really interesting you video. It could be nice if you can share again this excel sheet. Id like to apply a similar in a biology concept. Anybody has got a copy? my email: marcopolifrone@gmail.com.

the file can’t found . would anyone share it again?

Hi, you can get in touch with me on valera.sh@gmail.com. I’ll send you the solution. 🙂

I also cannot download it, please, send it to my email: mirzabek@iuj.ac.jp

I could really use this at work! Please send it to my e-mail: jonas.persson@gmail.com

Hi

Someone please send this file to atul89@gmail.com

I really need this for my MBA Internship.

Will be really very helpful.

Thankyou so much in advance.

Hi,

I like your Excel file for support the Kraljic matrix very much, it is really very useful tool. Unfortunately I can’t download it, can everyone send this file to micaela.valent@gmail.com?

Will be really very helpful.

Thank you

Please send the file to ali.786.kapadia@gmail.com

Would be really helpful ..

Hello,

I can’t dowlonad the file, can you send it to my mail (also the password please) :

lucasvirgile90@gmail.com

Thank you

i can’t download the file (Alfa_Romeo_Kraljic_matrix.zip). Could you send me the file (also the password please) to my Email: francesco.valpiani@virgilio.it.

Thank you so much!

Best regards

Francesco

Hello, cant download the file, please email to em.beijing@yahoo.ca

Thanks!

Hi,

I can’t seem to download the file Alfa_Romeo_Kraljic_matrix.zip. Could you please send this through as well?

Ta,

Nick

Hello,

I cannot download the file and I really would like to see the example.

Could someone send it to me to beatrizlafeliz@gmail.com?

Thank you in advance!!

Regards

I would like to test your file.

betsunin@gmail.com

regards

Hi, your video is awesome. Could you please send the escel file to my email ID…amrinder78@gmail.com