Realisasi PR to PO

Strategy — what this KPI measures

Measures purchasing responsiveness: every purchase request (PR) line should be converted into a PO within 7 days of the request, provided the specification is clear.

Data sources & how they are merged

• Source: the spine (PR TO PO TO GRPO) — the master PR list, including PRs not yet converted to a PO. PR→PO days come from LEAD TIME; for spine-only PRs we fall back to PO.csv's PO date minus the PR date.

The full merged dataset is browsable on the Data page, including the merge explanation.

Monthly calculation — step by step

1. Take every spine PR-item whose PR date falls in the month.
2. A line is on time when it has a PO and 0 ≤ 'PR to PO Days' ≤ 7.
3. Lines with no PO yet count against the score (they are unconverted requests).
4. REAL = on-time lines ÷ all PR lines in the month × 100.

Formula

REAL = PR lines converted to PO within 7 days ÷ all PR lines in the month × 100
%    = REAL ÷ 95% (standard "95%") × 100, clamped to 0–100%
CAPAI = % × 15% (weight) → max 15 points
Monthly total score = Σ CAPAI of all 7 KPIs (max 100 points)

Month attribution

A line belongs to the month of its PR date.

Edge cases & caveats

• Negative 'PR to PO Days' values (data-entry errors, flagged as warnings at upload) are never counted as on time.
• Very recent PR lines that legitimately haven't been processed yet still count against the month — same as the manual report.

See the numbers

On the dashboard, click any REALvalue of this KPI to open the month's drill-down with every underlying row used in the calculation.