Supplier Performance Rating (How to calculate in excel sheet) (हिन्दी में)

Welcome you on my KZbin channel " Quality Perfect India". In this video, I have fully explained-
What is Supplier Performance Rating?
What is Supplier Quality Rating?
How to Calculate supplier Rating in excel sheet.
OEE (Overall Equipment Effectiveness) video: • OEE (Overall Equipment...
Sampling Plan: Indian Standard video IS 2500 video: • Sampling Plan : Indian...
ISO 9001:2015 Clause 7 Support (Clause 7.2,7.3,7.4) video: • ISO 9001:2015 Clause 7...
ISO 9001:2015 Clause 7 Support (Clause 7.1 Resources) video: • ISO 9001:2015 Clause 7...
ISO 9001:2015 Clause 6 Planning.( Clause 6.1, 6.2 & 6.3) video: www.youtube.com/watch?v=NxY93...
ISO 9001:2015 Clause 5 Leadership. ( 5.1, 5.2 & 5.3) video: www.youtube.com/watch?v=D0EB1...
ISO 9001 2015 clause 4.3 and 4.4 video
www.youtube.com/watch?v=JPkoy...
ISO 9001 2015 clause 4.1 and 4.2 video: www.youtube.com/watch?v=l83IL...
ISO 9001 2015 all clauses video: www.youtube.com/watch?v=WiB0L...
ISO basic concept: www.youtube.com/watch?v=wdbyw...
IATF Basic concept video: www.youtube.com/watch?v=yWmM_...
MSA video: www.youtube.com/watch?v=IkaHG...
Six sigma: www.youtube.com/watch?v=_kyMq...
4M video: www.youtube.com/watch?v=jOc5n...
7 Qc tools video: www.youtube.com/watch?v=Y5s03...
5core tools of QMS-
5 Core Tools of QMS video: www.youtube.com/watch?v=XZoPu...
SPC video: www.youtube.com/watch?v=We3oq...
MSA video: www.youtube.com/watch?v=IkaHG...
PPAP video: www.youtube.com/watch?v=ZbTxX...
FMEA video: www.youtube.com/watch?v=J57RB...
APQP video: www.youtube.com/watch?v=C-6JN...
CAPA video: www.youtube.com/watch?v=QVrdH...
What is a quality video: www.youtube.com/watch?v=bxp8y...
Process audit and Product audit video: www.youtube.com/watch?v=eduZQ...
Types of Quality Audits: www.youtube.com/watch?v=nUI6k...
CAPA video: www.youtube.com/watch?v=QVrdH...
Cp & Cpk (How to calculate ) video: www.youtube.com/watch?v=uRtR4...
Cp & Cpk Difference video: www.youtube.com/watch?v=rl7kS...
5S video: www.youtube.com/watch?v=Oms8x...
POKA-YOKE Video: www.youtube.com/watch?v=LuSjb...
QA & QC video: www.youtube.com/watch?v=KoutC...
Rework Vs Repair video: www.youtube.com/watch?v=Rv1r3...
Hexavalent Vs Trivalent video: www.youtube.com/watch?v=pT9mP...

[@kashyap520]

Good knowledge provided by you

[@QualityPerfectIndia]

Thanks and welcome. Please keep watching and share to our videos to your friends also.

[@vivektyagi876]

Dear Sir 🌹 Thank you for your kind support always I have not covered this topic anywhere in my 3 year job, I have covered it with your video. With regards Vivek Tyagi

[@QualityPerfectIndia]

So nice of you, Thanks

[@Ikraransari3999]

Supplier monitoring Quality perfect India best Knowledge ❤️❤️❤️❤️ in this video dear sir

[@QualityPerfectIndia]

Thanks a lot

[@LaxmanSingh-wt6nl]

Sir Super vedio sir pls suggest we should take over all qty in numbers or overall supplies

[@Entertainment_Short_you]

Sir I want to know if one lot is rejected then no any impact to our SLR because Q4 is multiple or Zero then Note - zero is multiply with some value answer is Zero So please clear it ?? I mean to say that after lot rejected then the Quality rating is also reduce but as your formula it's not possible

[@englishnarayan7874]

Once you calculate it will reduce

[@sevendrakumarkondalkar871]

Thank you sir for understanding very simplified manner. can you pls share this excel sheet sir.

[@QualityPerfectIndia]

Thank you so much. Please join with my telegram group QUALITY PERFECT INDIA t.me/Quality_Perfect_India

[@manaschandraandia4551]

Good Video sir 👍

[@QualityPerfectIndia]

Thank you so much.

[@englishnarayan7874]

Thank you

[@QualityPerfectIndia]

Thank you so much for liking my video. Regards

[@Ikraransari3999]

Very good 👌 video Dear sir

[@QualityPerfectIndia]

Thanks and welcome

[@krishnasinghrajpootkrishna261]

It is Very good vidio sir ji

[@QualityPerfectIndia]

So nice of you

[@Ikraransari3999]

Very good 👌 video dear sir

[@QualityPerfectIndia]

thanks

[@dhingranitish]

nice explanation

[@QualityPerfectIndia]

Thanks for liking please keep watching

[@rajenderkumar7213]

Format daal diya karo link me sir..hum bhi download kar le

[@obendrayadav3099]

Nice video

[@QualityPerfectIndia]

Thanks

[@deveshsingh6970]

Very nice sir

[@QualityPerfectIndia]

Keep watching

[@yashesh8229]

Nice

[@QualityPerfectIndia]

Thanks

[@atulkumar7835]

Sir Q.R 50% me kya formula lga hai?.

[@luckysahu8845]

Sir, in SLR calculation: if we have lot reject -2 , but as per your formula lot rejection is an multiple of 0 , every time we get 0 value. Is it correct?

[@QualityPerfectIndia]

Yes, it's correct. The rejection portion value will be zero.

[@popatpandhare2039]

Dear sir, i have one question when one supplier supplies 20 part ,in that case how to findout quality rating

[@QualityPerfectIndia]

Dear Pandhare ji, Please check example Excel sheet in which XYZ Enterprises supplying Two part. Similarly You can consider 20 also. each part contribute lot status 50% max. and finally single quality rating. Regards

[@s.janakiammamusicparadise6137]

Please tell what are the points to be checked while receiving material in inward inspection area?

[@QualityPerfectIndia]

Recently I have uploaded video on Incoming inspection. Please watch, link is given below- kzbin.info/www/bejne/mZ7bZWRrptadlZo

[@3mspecialhits37]

Sir Sorry to say but one thing is missing in this video that is you should show the formula of excel sheet so that every body can easily understand that how you get values.

[@QualityPerfectIndia]

Thank you so much for asking valuable question. Actually I want to make understand in easy way so that all can understand very easy. Thats why I explained in easy.

[@11umk]

Sir agr line rejection and customer rejection aa gya to use kaise calculate karenge..??

[@radhakrishnanvs3148]

Jagdish ji powder coating process n defects ke bare main ek video bana sakoke

[@QualityPerfectIndia]

Why not Sure Regards

[@radhakrishnanvs3148]

@@QualityPerfectIndia thank you

[@hariomtripathi5464]

Sir nice video kripya Excel format sheet email kar dijiye

[@QualityPerfectIndia]

Please send email id Thanks

[@waseemgill8428]

Sir please share excel sheet

[@ajeettiwari4643]

Sir supplier performance rating kitne months bad nikalte hai

[@QualityPerfectIndia]

Supplier performance rating every month nikala jata hain.

[@WaqasAhmad-uw1xh]

Sir, ye excel sheet tu enclosed kar dethey

[@s.janakiammamusicparadise6137]

Or snap pls

[@QualityPerfectIndia]

Thanks

[@rashisharma3148]

Nice

[@QualityPerfectIndia]

Thanks