-
QC - Raw Materials
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
Goals | Questions to ask | Dashboard 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.