Decisions

Everything that needs a decision

25 awaiting approval

How this is calculated

Cases awaiting approval

Formula

count(decision_case where status = 'awaiting_approval'), reconciled against the cases whose LATEST case_transition.to_status is 'awaiting_approval'

Inputs

decision_case.status · case_transition.to_status · case_transition.at — read per row from the source tables, not re-stated here

Value on this screen

Sources

decision_case
case_transition

Annual carrying cost on dead stock

PKR 159.00m

5,860 products affected

How this is calculated

Annual carrying cost on dead stock

Formula

Σ over store × style where cover > 120d of round(on_hand × unit_cost_paisa × 0.25), where unit_cost_paisa = observed selling price × 0.55

Inputs

days_cover · on_hand · unit_cost_paisa — read per row from the source tables, not re-stated here

Value on this screen

PKR 159.00m

Sources

signal_stock
bottleneck

How this is calculated

Annual carrying cost on dead stock (Decisions KPI tile)

Formula

round(Σ bottleneck.impact_paisa where kind = 'dead_stock'), compared against the per-row integer sum of the same rows

Inputs

bottleneck.impact_paisa · bottleneck.kind — read per row from the source tables, not re-stated here

Value on this screen

PKR 159.00m

Sources

bottleneck
signal_stock

Stockout risk

PKR 2,10,970

56 products affected

How this is calculated

Margin at risk from projected stockouts

Formula

Σ over store × style where cover < 28d and units_per_day × 21 > on_hand + qty_inbound of round((units_per_day × 21 − on_hand − qty_inbound) × margin_per_unit_paisa)

Inputs

units_per_day · on_hand · qty_inbound · margin_per_unit_paisa · days_cover — read per row from the source tables, not re-stated here

Value on this screen

PKR 2,10,970

Sources

signal_stock
bottleneck

How this is calculated

Margin at risk (Decisions KPI tile)

Formula

round(Σ bottleneck.impact_paisa where kind = 'stockout_risk'), compared against the per-row integer sum of the same rows

Inputs

bottleneck.impact_paisa · bottleneck.kind — read per row from the source tables, not re-stated here

Value on this screen

PKR 2,10,970

Sources

bottleneck
signal_stock

Supply failure

PKR 23,492

3 products affected

How this is calculated

Margin at risk from late supplier deliveries

Formula

Σ over store × style with at least one overdue PO of round(units_per_day × 30 × margin_per_unit_paisa)

Inputs

overdue_pos · units_per_day · margin_per_unit_paisa — read per row from the source tables, not re-stated here

Value on this screen

PKR 23,492

Sources

signal_stock
bottleneck
bronze_po

Decisions awaiting you

25 open · showing the top 8

How this is calculated

Decision cases on record, each with an audit trail

Formula

count(decision_case), reconciled against count(distinct case_id) in the append-only case_transition log — every persisted case must carry a transition trail. Counts all cases, including closed and rejected ones, not the open queue.

Inputs

decision_case.id · case_transition.case_id — read per row from the source tables, not re-stated here

Sources