MIS GridFormula Bar & Range Editor
F5
fx
Quick Formula Templates:
| # | SKU (A) | Item Name (B) | Category (C) | Target Qty (D) | Actual Qty (E) | Achieve % (F) | Total Val (G) |
|---|---|---|---|---|---|---|---|
| 2 | SKU-01 | Hydraulic Seals | Seals & Fittings | 100 | 80 | 80 | 36000 |
| 3 | SKU-02 | Pneumatic Valves | Valves & Actuators | 150 | 150 | 100 | 48000 |
| 4 | SKU-03 | Lubricant 5L | Lubricants | 80 | 0 | 0 | 0 |
| 5 | SKU-04 | Coupling Joints | Fasteners | 0 | 40 | #DIV/0! | 4800 |
| 6 | SKU-05 | O-Ring Assortment | Seals & Fittings | 50 | 55 | 110.00 | 11000 |
| 7 | SKU-06 | Gasket Sheets | Valves & Actuators | 120 | 96 | 80 | 57600 |
| 8 | SKU-07 | Grease Cartridge | Lubricants | 90 | 70 | 77.78 | 12600 |
| 9 | SKU-08 | M8 Bolt Pack | Fasteners | 60 | 48 | 80 | 4320 |
| 10 | TOTAL | 8 | - | 650 | 539 | #DIV/0! | 174320 |
Total Errors:2 Defects
Total Valuation (G10):₹174,320
Average Achievement (F10):--
1. Validity
Inputs Supported
All configuration parameters are valid.
2. Correctness
Objective: Demonstrated
Ready for verification run
3. Constraints
Within Limits
Budget, SLA, and capacity limits respected.
4. Trade-offs
Analysis
Inspect scenario parameters to evaluate trade-offs.