This report was made assuming that the manufacture already had a quality control system and quality control plans so that the data can be gathered. What it is able to do is giving users the overall view on the QC status down to each day, which assists decision-making in inventory planning and purchasing, also to monitor the quality of orders that come from different suppliers. It allows users to cross-filter the visuals and use the slicers to divide the QCs into types so the most detailed information about QC orders and their purchase ordesr, suppliers, materials, cost,… will show up and give users useful insights on QC.

The business could achieve the below goals: 

  • Track the number of QC orders, failed QC orders and purchase orders affected
  • Inventory and purchasing planning
  • Monitor material suppliers
  • Track details of QC orders, especially failed ones
GoalsQuestions to askDashboard views
Track the number of QC orders, failed QC orders and purchase orders  affected  

How many QC orders failed and what actions needed to take  with their purchase orders accordingly in the chosen time? 

No. QC orders, No.  Fail QC orders, Return POs, Replace POs,  Accept with discounts POs 
Inventory and purchasing planning 

How many percent of QC orders failed by material categories?

% Fail QC by material categories,
PO with fail QC – product name, QC level
Monitor material suppliers   

Which suppliers are having the most failed QC orders of all time and caused how many returned – replaced – accepted with discount purchase orders? 

Suppliers and number of fail QC all-time 
Track details of QC orders, especially failed ones Details of the QC orders (what was the linked purchase order? What was their quantity and order cost? Who performed the QC? If it was a failed QC, what was the solution and was it resolved?) Data table 

*Key Terms

No. QC orders: 
Number of QC orders

QC order:
QC command (code of each time QC is generated by the machine when recorded on the systems)

No. Fail QC orders:
Number of QC failed

Return POs:
Number of return orders

Replace POs:
Purchase order returned – partial replacement 

Accept with discounts POs:
Number of purchase orders accepted with discounts from suppliers

% Fail QC:
Ratio of number of failed QCs to total QC

Order cost:
The price paid for the purchase order

Number of fail QC all-time:
Number of QC failed so far

QC Plans:
QC Plans/Processes for materials

QC Levels:
QC Levels (usually divided by criteria: price of materials, reliability of suppliers, …)

QC - Raw Materials Report

  • It informs users on the QC status of each day, month or year of choice, which hints on the trend of QC on the materials through time. Together with the category breakdown and the display of material names, categories with the consistent higher % of failed QC over periods can easily urge the purchase team to track their suppliers and have actionable decisions.
  • Suppliers that have the highest number of failed QC orders are also called out on the visual, which should concern the business since they cause the most returned – replaced – accepted with discount purchase orders. Periodically reassessment on the ability of these suppliers to provide good orders would be beneficial for the business.
Search here...

Search here...


Get a fully-stacked data team within 47 hours without making a hire. Our team of data experts help build your data infrastructure, create your metrics and much more. Available from day 1, so you can get a world-class data setup in record time.

Contact Us