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
2511004752025-11-29PERSEDIAAN UMUM6030.0638KAPUR BESI 16 A260510200881.252512000712025-12-042025-12-22121,313.8152512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.0526ISOLASI ELECTRIC2605004926,306.312512000712025-12-042025-12-22255,855.8652512004362025-12-1392025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.0522LEM BESI 48 GR26050000615,765.772512000712025-12-042025-12-221214,414.4152512004362025-12-1392025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.0529LEM SILICON RED 85 GR26050049222,522.522512000712025-12-042025-12-221220,270.2752512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.0521LEM ADHESIVE26060016455,0002512000712025-12-042025-12-222519,819.8252512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.053LEM SILICON CLEAR 300ML26050049227,027.032512000712025-12-042025-12-221526,126.1352512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6050.006KAPI 3 INCH26050000610,360.362512000712025-12-042025-12-22249,909.9152512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6050.0061KAPI 2 INCH2605000068,558.562512000712025-12-042025-12-22368,108.1152512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.0621KUAS 3 INCH2605004409,127.932512000712025-12-042025-12-221211,531.5352512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.062KUAS 2 INCH2605004405,794.62512000712025-12-042025-12-22367,702.752512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.0524LEM SUPER GLUE2605004924,954.962512000712025-12-042025-12-22124,504.5152512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6020.0076KLEM SLANG 3/4 INCH2605004902,342.342512000712025-12-042025-12-22102,252.2552512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6020.0053KLEM SLANG 1/2 INCH2605004902,342.342512000712025-12-042025-12-2252,252.2552512003042025-12-1062025-12-29On time
2511004802025-11-29BAHAN PACKING3011.002BOX PARIS COKLAT TS 50*50 KW II2605003821,4592512000702025-12-042025-12-2920,0001,16952512003292025-12-1172026-01-05On time
2511004802025-11-29BAHAN PACKING3011.0235BOX PARIS BK TS KW 1 50X502606001201,4592512000702025-12-042025-12-2980,0001,16952512006452025-12-19152026-01-05On time
2511004802025-11-29BAHAN PACKING3011.0235BOX PARIS BK TS KW 1 50X502606001201,4592512000702025-12-042025-12-2980,0001,16952512005352025-12-16122026-01-05On time
2511100862025-11-25PERSEDIAAN UMUM6030.08STANG RIVET25121001884,0002512100182025-12-042025-12-15184,00092512102582025-12-1282025-12-22On time
2511100882025-11-25SPAREPART5017.0987PRESSURE SWITCH SSNS-110 SN.C2025251210023400,0002512100232025-12-042025-12-135400,00092512102842025-12-1392025-12-20On time
2511100892025-11-25PERSEDIAAN UMUM6030.2419METERAN 30 MTR25121001734,7862512100172025-12-042025-12-15134,78692512104372025-12-19152025-12-22On time
2511100892025-11-25PERSEDIAAN UMUM6030.1595METERAN 10 MTR26050018363,7502512100162025-12-042025-12-15135,91592512104382025-12-19152025-12-22On time
2511100892025-11-25STATIONERY6010.015ISI CUTTER BESAR L-1502606100606,5002512100262025-12-042025-12-13206,00092512102432025-12-1172025-12-20On time
2511100892025-11-25STATIONERY6010.0666GUNTING BESAR2606101514,9372512100262025-12-042025-12-13212,00092512102432025-12-1172025-12-20On time
2511100892025-11-25STATIONERY6010.0151ISI STAPLES KECIL #10 KECIL, NO.10-1M2606101511,5922512100262025-12-042025-12-13102,00092512102432025-12-1172025-12-20On time
2511100892025-11-25STATIONERY6010.0172BINDER CLIP NO. 107 NO. 1072606100603,5002512100262025-12-042025-12-1333,50092512102432025-12-1172025-12-20On time
2511100892025-11-25STATIONERY6010.0218ODNER BANTEX 29X35X4,5 CM26051001918,1502512100262025-12-042025-12-131023,40092512102432025-12-1172025-12-20On time
2511100892025-11-25PERSEDIAAN UMUM6050.1041CAIRAN PEMBERSIH KACA (LENGKAP DENGAN ALAT SEMPROT)25121001922,0002512100192025-12-042025-12-15422,00092512102572025-12-1282025-12-22On time
2511100942025-11-26SPAREPART5030.1397HUIGANG INKJET PRINTER HP45 INK CARTRIDGE2512100141402512100142025-12-042025-12-0410014082601112202026-02-27852025-12-11Late
2511100942025-11-26SPAREPART5030.1711SUCTION CUP+FILTER UNTUK MESIN RAKIT KARTON260510233175,0002512100132025-12-042025-12-0478175,00082512102882025-12-1392025-12-11Late
2512000352025-12-01PERSEDIAAN UMUM6030.0004SEMEN GRESIK 40KG26050024159,5002512000522025-12-042025-12-045058,00032512002402025-12-0952025-12-11On time
2512000352025-12-01PERSEDIAAN UMUM6030.201BATAKO2605000395,0002512000522025-12-042025-12-046635,00032512002402025-12-0952025-12-11On time
2512000352025-12-01PERSEDIAAN UMUM6030.0823PASIR AYAK2605003391,150,0002512000642025-12-042025-12-0411,150,00032512002412025-12-0952025-12-11On time
2512000382025-12-01PERSEDIAAN UMUM6030.0621KUAS 3 INCH2605004409,127.932512000762025-12-042025-12-19128,733.3332512002472025-12-0952025-12-26On time
2512000382025-12-01PERSEDIAAN UMUM6030.2266CAT AVIAN KIWI 630 @0.9LITER/KALENG25120007657,472.972512000762025-12-042025-12-192457,472.9732512002442025-12-0952025-12-26On time
2512000382025-12-01PERSEDIAAN UMUM6030.1898CAT AVIAN SUPER BLACK GLOSS26051008270,725.122512000762025-12-042025-12-192457,472.9732512002442025-12-0952025-12-26On time
2512000382025-12-01PERSEDIAAN UMUM6030.052CAT BESI / KAYU AVIAN TWILIGHT BLUE 73126010069257,472.972512000762025-12-042025-12-192457,472.9732512004662025-12-1392025-12-26On time
2512000382025-12-01PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232512000762025-12-042025-12-192457,472.9732512002442025-12-0952025-12-26On time
2512000382025-12-01PERSEDIAAN UMUM6030.0513CAT BESI AVIAN SEA BLUE 75226010068257,472.972512000762025-12-042025-12-192457,472.9732512002442025-12-0952025-12-26On time
2512000492025-12-03PERSEDIAAN UMUM6030.2454PAINT REMOVER VIP25120005073,0002512000502025-12-042025-12-041073,0001–––2025-12-11Overdue
2512000492025-12-03PERSEDIAAN UMUM6030.2454PAINT REMOVER VIP25120005073,0002512000502025-12-042025-12-041073,00012601001092026-01-06332025-12-11Late
2512000492025-12-03PERSEDIAAN UMUM6030.2454PAINT REMOVER VIP25120005073,0002512000502025-12-042025-12-041073,00012512001332025-12-0512025-12-11On time
2512000542025-12-03PERSEDIAAN UMUM6030.2455BATU PECAH 1X1 CM260100673266,666.672512000642025-12-042025-12-042200,00012512002382025-12-0952025-12-11On time
2512000582025-12-03BAHAN BAKU GLAZE1070.0022INK - CIK RC 1116 SINKING260500301262,1882512000572025-12-042025-12-0572252,71612512002792025-12-0952025-12-12On time
2512000592025-12-01BAHAN BAKU GLAZE1098.0014STPP (Sodium Tripolyphospate)26060004525,7002512000832025-12-042025-12-176,00023,00032512005782025-12-17132025-12-24On time
2512000602025-12-01BAHAN BAKU GLAZE1099.0018BALLCLAY (NOODLE) OPAL KA2606000371,3112512000782025-12-042025-12-1824,0001,20032512005892025-12-17132025-12-25On time
2512000612025-12-01BAHAN BAKU GLAZE1098.0004CMC C-2026060004985,475.62512000872025-12-042025-12-161,50081,785.932512004022025-12-1392025-12-23On time
2512000622025-12-01BAHAN BAKU GLAZE1099.0024ALUMINA A-1026060004812,036.362512000872025-12-042025-12-1615,00011,516.7932512005912025-12-17132025-12-23On time
2512000622025-12-01BAHAN BAKU GLAZE1099.0024ALUMINA A-1026060004812,036.362512000872025-12-042025-12-1615,00011,516.7932512003482025-12-1172025-12-23On time
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512000802025-12-042025-12-15180,0007,342.532512002122025-12-0842025-12-22On time
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512000802025-12-042025-12-15180,0007,342.532512004042025-12-1392025-12-22On time
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512000802025-12-042025-12-15180,0007,342.532512003642025-12-1282025-12-22On time
← PrevPage 22 of 270Next →Rows per page:1020501005001000