Dear Food safety and quality professionals,
Hope all are fine.
to better control the raw materials quality and non conformance, please share me if you have any excel template where I am looking below points.
To be honest, our supply chain team is not so bother about the suppliers non conformance as they are looking always to bring cheap materials. This is very big challenge to our quality team where we have to control the raw material defect in the line. More than that our process line is completely manual sorting, we are not able to ensure that finished product is 100 % free from defects.or our standard.
hence I am looking for a single excel sheet or KPI graphs or charts template at least I can submit my management monthly or yearly to acknowledge them somewhat easy.
1) I need to show all the materials received quantity per month by supplier by supplier vs Non conformance
2) but above cases one challenge. some time our non conformity will be qualitative or some time quantitative. So will be very helpful if I can present both issues in same chart. For eg: some time I receiving big quanitity ( X) with (Y percentage ) defect in whole lot. whereas in other case Same big quantity (may be X) but the defect will be only some bags from whole lot.
Looking forward your kind comments.