KKobin GroupProcurement KPI
ConsolidatedPR TO PO TO GRPO (spine)PO exportLEAD TIME

Merged data

The merged procurement sheet (PR → PO → GRPO) with the realisasi status used by KPI 2/3 · 13,488 row(s)

Export CSV
How the three files are consolidated— click to expand

Three SAP exports are combined. The SPINE is PR TO PO TO GRPO — the master PR list (one row per PR-item, including PRs not yet converted to a PO). It sets the dashboard's date span and is KPI 4's denominator.

PO.csv enriches it with the PO details that only it carries: the Lokal/Impor flag (the KPI 2 vs KPI 3 split), the ETA, currency and unit price, joined on PO No.

LEAD TIME PR TO GR adds the goods-receipt detail: one row per GR with its date and quantity, plus the ordered PO quantity, last/current price and PR→PO days. This is what makes the quantity-aware completion possible.

KPI 2/3 'received' logic is quantity-aware: a PO-item counts as received only when the running sum of GR quantities reaches the ordered quantity; the completion date (the GR that crosses the ordered qty) is compared to ETA + 7 days (Local) / 14 days (Import).

On import each file is upserted by its natural key, so re-uploading an updated export updates rows in place instead of duplicating them. KPI 5 (Quality), 6 (Substitution) and 7 (New Vendor) have no source in these files yet — they are seeded with best-case defaults so the scorecard is complete; replace those entries as real data arrives.

Realisasi here uses a 7-day tolerance (local). Each KPI's own formula is on its methodology page — click any KPI title on the dashboard.

PR NoPR DateItem GroupItem CodeItemLast POLast PricePO NoPO Date ▲ETAQtyPricePR→POGRPO NoGRPO DatePO→GRPODeadlineRealisasi
2511004542025-11-29PERSEDIAAN UMUM6030.2431GERINDA 4 INCH M0900B MAKITA251200188350,0002512001882025-12-112025-12-114350,000122603001622026-03-04832025-12-18Late
2512000352025-12-01PERSEDIAAN UMUM6030.1561BETON READYMIX MUTU K300260600062780,0002512001962025-12-112025-12-113750,000102601003752026-01-13332025-12-18Late
2512000362025-12-01PERSEDIAAN UMUM6030.0493CAT AVIAN SYNTETIC HITAM SB26040022063,219.822512002012025-12-112025-12-11563,857.65102512009172025-12-27162025-12-18Late
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512001992025-12-112025-12-27180,0007,342.5102512005862025-12-1762026-01-03On time
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512001992025-12-112025-12-27180,0007,342.5102601002402026-01-08282026-01-03Late
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512001992025-12-112025-12-27180,0007,342.5102601002412026-01-08282026-01-03Late
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512001992025-12-112025-12-27180,0007,342.5102512007522025-12-22112026-01-03On time
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512001992025-12-112025-12-27180,0007,342.510–––2026-01-03Overdue
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512001992025-12-112025-12-27180,0007,342.510–––2026-01-03Overdue
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512001992025-12-112025-12-27180,0007,342.5102601000782026-01-03232026-01-03On time
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512001992025-12-112025-12-27180,0007,342.5102512007582025-12-22112026-01-03On time
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512001992025-12-112025-12-27180,0007,342.5102512008482025-12-24132026-01-03On time
2512001192025-12-08BAHAN PACKING3011.0217NFT00 40X40 JUPITER MP1 KW-A 403X51 (BK150/125/125)2606001204092512002132025-12-112026-01-1030,00031532512009732025-12-30192026-01-17On time
2512001192025-12-08BAHAN PACKING3011.0219NFT00 40X40 JUPITER MP1 KW-B 403X51 (BK150/125/125)2604004124092512002132025-12-112026-01-1030,00031532601004942026-01-15352026-01-17On time
2512001192025-12-08BAHAN PACKING3011.0219NFT00 40X40 JUPITER MP1 KW-B 403X51 (BK150/125/125)2604004124092512002132025-12-112026-01-1030,00031532512009732025-12-30192026-01-17On time
2512001192025-12-08BAHAN PACKING3011.022NFT00 40X40 JUPITER MP2 KW-B 403X54 (BK150/125/125)2604004123572512002132025-12-112026-01-1030,00027532512009732025-12-30192026-01-17On time
2512001192025-12-08BAHAN PACKING3011.022NFT00 40X40 JUPITER MP2 KW-B 403X54 (BK150/125/125)2604004123572512002132025-12-112026-01-1030,00027532601004942026-01-15352026-01-17On time
2512001192025-12-08BAHAN PACKING3011.0218NFT00 40X40 JUPITER MP2 KW-A 403X54 (BK150/125/125)2606001203572512002132025-12-112026-01-1030,00027532512009732025-12-30192026-01-17On time
2512001222025-12-06PERSEDIAAN UMUM6030.003PAKU 2 INCH26060016715,333.332512002032025-12-112025-12-206015,00052512004092025-12-1322025-12-27On time
2512001262025-12-06PERSEDIAAN UMUM6030.2191GUNTING KAWAT BAJA (KODOK)25120021175,0002512002112025-12-112025-12-22575,00052512004102025-12-1322025-12-29On time
2512001262025-12-06PERSEDIAAN UMUM6060.0147BAUT PORSENG L M 6X102512002177452512002172025-12-112025-12-302074552512004812025-12-1542026-01-06On time
2512001262025-12-06PERSEDIAAN UMUM6030.0613METERAN 5 MTR2605101569,3632512002112025-12-112025-12-22325,00052512004102025-12-1322025-12-29On time
2512001262025-12-06PERSEDIAAN UMUM6050.0298CHAIN LUBE26060016939,1002512002172025-12-112025-12-301537,50052512004812025-12-1542026-01-06On time
2512001262025-12-06PERSEDIAAN UMUM6030.0521LEM ADHESIVE26060016455,0002512002112025-12-112025-12-22255,00052512004102025-12-1322025-12-29On time
2512001322025-12-06SPAREPART5029.0067RODA TROLY 5 INCH25120022975,0002512002292025-12-112025-12-30475,00052512008182025-12-24132026-01-06On time
2512001332025-12-06PERSEDIAAN UMUM6010.0543STIKER SIRIM 30X30 (UK 6.5 X 6.5 CM)251200191702512001912025-12-112025-12-2910,0007052512005262025-12-1652026-01-05On time
2512001342025-12-06PERSEDIAAN UMUM6030.0633SELANG SPIRAL 2 INCH26040052741,5002512002162025-12-112025-12-295041,50052512007892025-12-23122026-01-05On time
2512001372025-12-06PERSEDIAAN UMUM6030.0917THINER A BIASA @ 5 LTR26050040363,5002512002052025-12-112025-12-268132,525.2352512004972025-12-1652026-01-02On time
2512001392025-12-06SPAREPART5021.0123V. BELT B - 250260101026191,2002512001932025-12-112025-12-2710191,20052512006142025-12-1872026-01-03On time
2512001392025-12-06SPAREPART5021.0344V. BELT C - 253260100190352,1002512001932025-12-112025-12-2710352,10052512006142025-12-1872026-01-03On time
2512001392025-12-06SPAREPART5021.0344V. BELT C - 253260100190352,1002512001932025-12-112025-12-2710352,10052601009712026-01-28482026-01-03Late
2512001522025-12-09PERSEDIAAN UMUM6050.0579CAT AVIAN KUNING ROAD LINE26060017158,502.72512001922025-12-112025-12-273046,559.4622512005762025-12-1762026-01-03On time
2512001522025-12-09PERSEDIAAN UMUM6050.0579CAT AVIAN KUNING ROAD LINE26060017158,502.72512001922025-12-112025-12-273046,559.4622512004982025-12-1652026-01-03On time
2512001522025-12-09PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002512001922025-12-112025-12-273036,225.2322512004982025-12-1652026-01-03On time
2512001612025-12-10PERSEDIAAN UMUM6030.2457BESI POLOS 8 MM25120018542,9722512001852025-12-112025-12-1111342,97212512004182025-12-1322025-12-18On time
2512001612025-12-10PERSEDIAAN UMUM6030.2468BESI D13251200185108,7382512001852025-12-112025-12-1113108,73812512004182025-12-1322025-12-18On time
2512001612025-12-10PERSEDIAAN UMUM6030.2467BESI D16251200185164,9542512001852025-12-112025-12-1181164,95412512004182025-12-1322025-12-18On time
2512001632025-12-10SPAREPART5011.0411BEARING RN 307260300230175,0002512002072025-12-112025-12-202225,0001–––2025-12-27Overdue
2512001642025-12-10PERSEDIAAN UMUM6030.0448TRIPLEX 18 MM251200208250,0002512002082025-12-112025-12-177250,00012512004112025-12-1322025-12-24On time
2512001732025-12-06PERSEDIAAN UMUM6010.0351AIR MINERAL GALON26060024818,018.022512002062025-12-112025-12-273317,567.5752512009062025-12-26152026-01-03On time
2512001732025-12-06PERSEDIAAN UMUM6050.0313AIR MINERAL BOTOL KECIL 220 ML26060024819,819.822512002062025-12-112025-12-271019,369.3752512009062025-12-26152026-01-03On time
2512001742025-12-10PERSEDIAAN UMUM6030.0531LAKBAN KUNING 48MM2606001459,9002512002152025-12-112025-12-20109,90012512006932025-12-22112025-12-27On time
2512001782025-12-06BAHAN BAKAR4010.0001SOLAR26060011120,720.722512001902025-12-112025-12-138,00013,378.3852512005832025-12-1762025-12-20On time
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,0001–––2026-01-02Overdue
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,00012512004762025-12-1542026-01-02On time
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,0001–––2026-01-02Overdue
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,00012512007652025-12-23122026-01-02On time
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,00012512006712025-12-2092026-01-02On time
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,00012601004612026-01-14342026-01-02Late
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,00012601005412026-01-17372026-01-02Late
← PrevPage 31 of 270Next →Rows per page:1020501005001000