SKU-01 Rate (Target 100, Act 80)80%Correct (80% achieved)
Total Target vs Actual441 / 700Overall: 63%
Calculated Total Revenue₹203,600Formula: SUM(E2:E7)
Lookup IntegrityExact Match (SKU)XLOOKUP Primary Key
Distributor Monthly MIS Worksheet (20 × 15 Grid)
Read-Only Formulas Display| Row | SKU Key | Item Name | Target | Actual | Achievement % | Total Value |
|---|---|---|---|---|---|---|
| 2 | SKU-01 | Hydraulic Seals | 100 | 80 | 80% | ₹36,000 |
| 3 | SKU-02 | Pneumatic Valves | 150 | 150 | 100% | ₹48,000 |
| 4 | SKU-03 | Lubricant 5L | 80 | 60 | 75% | ₹51,000 |
| 5 | SKU-04 | Coupling Joints | 200 | 0 | 0% | ₹0 |
| 6 | SKU-05 | O-Ring Assortment | 50 | 55 | 110% | ₹11,000 |
| 7 | SKU-06 | Gasket Sheets | 120 | 96 | 80% | ₹57,600 |
| TOTAL | - | All SKUs Aggregate | 700 | 441 | 63% | ₹203,600 |