Subtitusi material for backup

Strategy — what this KPI measures

Measures specification discipline: material substitutions (backup materials) should be rare — at most one item per year.

Data sources & how they are merged

• Source: not present in the PO or PR TO GR exports. Values come from the kpi_manual_entries table, ready for a future export or manual entry.

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

Monthly calculation — step by step

1. Sum substitution entries from January 1 through the end of the month (cumulative for the year).
2. Score is all-or-nothing against the yearly maximum.

Formula

REAL = cumulative substitutions from Jan 1 to month end
%    = 100% if REAL ≤ 1 (standard "Max 1 items / year"), otherwise 0%  — all-or-nothing
CAPAI = % × 10% (weight) → max 10 points

Month attribution

Cumulative year-to-date: each month shows the running total for the year.

Edge cases & caveats

• No substitution export exists yet, so each year is seeded with a best-case default of 1 substitution (the allowed maximum → full score). The single entry is recorded in the year's first active month. Replace it once real data is available.

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.