Rft Formula In Excel |link|
Insight: By fixing the top 20% of defect reasons (Scratch + Wrong Color), you increase RFT by ~75%.
| Row | A (Batch) | B (Process) | C (Input) | D (Scrap) | E (Rework) | | :-- | :--- | :--- | :--- | :--- | :--- | | 2 | Batch 001 | Assembly | 1000 | 15 | 25 | | 3 | Batch 002 | Painting | 500 | 5 | 10 | | 4 | Batch 003 | Assembly | 1200 | 40 | 10 | rft formula in excel
Now, any new row added to the bottom of the table is automatically included in the RFT calculation. Insight: By fixing the top 20% of defect
Insight: By fixing the top 20% of defect reasons (Scratch + Wrong Color), you increase RFT by ~75%.
| Row | A (Batch) | B (Process) | C (Input) | D (Scrap) | E (Rework) | | :-- | :--- | :--- | :--- | :--- | :--- | | 2 | Batch 001 | Assembly | 1000 | 15 | 25 | | 3 | Batch 002 | Painting | 500 | 5 | 10 | | 4 | Batch 003 | Assembly | 1200 | 40 | 10 |
Now, any new row added to the bottom of the table is automatically included in the RFT calculation.