QC Defect Tracker.

Build a QC defect tracker for Sunfield Foods, a frozen meals plant in Fresno where nonconformance reports currently vanish into email threads. Layout: the primary view is a five column board: Open, Containment, Root Cause, Corrective Action, Closed. Each card shows the NCR number (NCR-1041 style), product, lot number, defect type chip, a severity badge, disposition, owner initials, and days in current stage; any card sitting longer than 14 days shows a small red aging marker. Cards order oldest first within each column, and Closed shows the most recent 10 with close dates. Above the board, a compact stat strip: Open NCRs (28), Critical Open (4), Average Days to Close (9), Aging Past 14 Days (5), beside filters for product, defect type, severity, and line. A second tab, Pareto, holds two bar charts, NCR count by defect type and NCR count by line, plus a stacked bar of new versus closed reports per week over the last 10 weeks. A New NCR button opens a dialog capturing product, lot, line, defect type, severity, disposition, owner, and description, and each card has a menu to advance its stage; the seeded board must look complete to read-only visitors who cannot touch either. Data: seed 45 nonconformance reports from the last 10 weeks across 8 products such as Chicken Alfredo Bowl, Beef Chili Bowl, Veggie Stir Fry, and Mac and Cheese Cup, produced on Lines 1 through 3. Defect types: foreign material, underweight pack, seal failure, label misprint, temperature deviation. Severities: Minor, Major, Critical. Dispositions: Use As Is, Rework, Scrap, On Hold. Lots follow an L-4471 pattern. Spread the cards roughly 10 Open, 6 Containment, 8 Root Cause, 4 Corrective Action, and 17 Closed. Plant the story: seal failures on Line 3 dominate, about 40 percent of all reports and concentrated in the last four weeks, and five of them are stuck in Root Cause past the 14 day mark, so the Pareto tab and the aging markers both point at the same problem. Behavior: days in stage, averages, and all chart counts are computed, never entered. Severity colors: Critical red, Major amber, Minor gray. Each defect type keeps one consistent chip color across the board and every chart. Filters combine and persist across both tabs. Visual identity: use a muted crimson accent for primary actions, chart emphasis, and active states on a clean light neutral base, restrained enough that severity reds still stand out.