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
2511004622025-11-29STATIONERY6010.0151ISI STAPLES KECIL #10 KECIL, NO.10-1M2606101511,5922512000772025-12-032025-12-22422,70042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.029TINTA TRODAT BIRU25120007746,8002512000772025-12-032025-12-22546,80042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0242BOLPOINT BIRU2606000271,3002512000772025-12-032025-12-22121,30042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0236BOLPOIN MERAH2606000271,3002512000772025-12-032025-12-22121,30042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0122BOLPOIN HITAM2606000271,3002512000772025-12-032025-12-22961,30042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0192BUKU FOLIO 21.5*30.5 21.5 X 31.5 CM26060010816,5002512000772025-12-032025-12-221516,30042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.019BUKU TULIS SIDU(16*21) 16 X 21 CM2606000274,6002512000772025-12-032025-12-22244,60042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0256PITA PRINTER LQ2180 EPSON S015086, 12 X 51 X 2 CM26060002770,5002512000772025-12-032025-12-223174,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0307PITA PRINTER LX 31026061006016,8002512000772025-12-032025-12-22346,70042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0718SPIDOL JUMBO BOARDMARKER HITAM25120007715,5002512000772025-12-032025-12-22615,50042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0136SPIDOL MARKER PUTIH MARKER, PUTIH/WHITE26060010813,1002512000772025-12-032025-12-221212,30042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0127SPIDOL BOARDMARKER HITAM - BOARDMARKER, HITAM/BLACK2606101518,9982512000772025-12-032025-12-22486,70042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0133SPIDOL MARKER HITAM - MARKER, HITAM/BLACK2606000275,7002512000772025-12-032025-12-22365,70042512004542025-12-13102025-12-29On time
2511004622025-11-29PERSEDIAAN UMUM6020.0291TINTA HITAM EPSON 00326010014283,0002512000772025-12-032025-12-221683,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0319TINTA WARNA EPSON 00326010052383,0002512000772025-12-032025-12-22483,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0319TINTA WARNA EPSON 00326010052383,0002512000772025-12-032025-12-22483,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0319TINTA WARNA EPSON 00326010052383,0002512000772025-12-032025-12-22383,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0162TIPE EX CAIR2606001083,6002512000772025-12-032025-12-22104,90042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0467TIPE EX KERTAS2606001084,7002512000772025-12-032025-12-2275,40042512004542025-12-13102025-12-29On time
2511004672025-11-29PERSEDIAAN UMUM6050.1165PIGORA25120003120,0002512000312025-12-032025-12-15220,00042512001112025-12-0522025-12-22On time
2511101042025-11-29BAHAN PACKING3011.0209CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP1 KWA 605X40 (WK150/125/150)2604100186962512100092025-12-032025-12-0320,32867142512101692025-12-0962025-12-10On time
2511101042025-11-29BAHAN PACKING3011.021CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP2 KWA 605X38 (WK150/125/150)2604100186592512100092025-12-032025-12-0320,32859542512101692025-12-0962025-12-10On time
2512000092025-12-01PERSEDIAAN UMUM6030.0448TRIPLEX 18 MM251200208250,0002512000362025-12-032025-12-155250,00022512000502025-12-03–2025-12-22On time
2512000092025-12-01PERSEDIAAN UMUM6030.0613METERAN 5 MTR2605101569,3632512000362025-12-032025-12-15225,00022512000502025-12-03–2025-12-22On time
2512000142025-12-01PERSEDIAAN UMUM6050.0568ACCU KERING 105 D 31 R/L2605003332,350,0002512000552025-12-032025-12-1522,350,00022512001272025-12-0522025-12-22On time
2512000152025-12-01BAHAN BAKAR4030.001DAPHNE SUPER HYDRO 46 (IDEMITSU)26060022462,2502512000392025-12-032025-12-1540041,50022512001312025-12-0522025-12-22On time
2512000182025-12-01PERSEDIAAN UMUM6050.106COVER STRIP LEBAR 10 CM2512000383,513,513.512512000382025-12-032025-12-2223,513,513.5122512004372025-12-13102025-12-29On time
2512000192025-12-01PERSEDIAAN UMUM6020.0369KABEL NYYHY 4X1.5 MM2605001012,300,0002512000492025-12-032025-12-2211,840,00022512003762025-12-1292025-12-29On time
2512000272025-12-01PERSEDIAAN UMUM6010.0351AIR MINERAL GALON26060024818,018.022512000372025-12-032025-12-103517,567.5722512001092025-12-0522025-12-17On time
2512000272025-12-01PERSEDIAAN UMUM6050.0313AIR MINERAL BOTOL KECIL 220 ML26060024819,819.822512000372025-12-032025-12-10519,369.3722512001092025-12-0522025-12-17On time
2512000312025-12-01PERSEDIAAN UMUM6030.2347KLEM SLANG COMBUSTION 2.5 INCH251200043323,0002512000432025-12-032025-12-0330323,00022603006242026-03-141012025-12-10Late
2512100062025-12-02BAHAN PEMBANTU2022.0003PET STRAPPING BAND 15.5X0.8 MM PANJANG=1400 MTR260600221350,0002512100112025-12-032025-12-11160320,00012512102102025-12-1072025-12-18On time
2512100062025-12-02BAHAN PEMBANTU3034.0003TECHNOMELT 2930 ID25KG26051021852,0002512100102025-12-032025-12-101,50034,00012512102312025-12-1182025-12-17On time
2512100062025-12-02BAHAN PEMBANTU3034.0003TECHNOMELT 2930 ID25KG26051021852,0002512100102025-12-032025-12-101,50034,00012512105262025-12-26232025-12-17Late
2512100072025-12-02BAHAN BAKU BODY1010.0018CLAY AB 76#2606101783902512100322025-12-032025-12-03150,00039012605100382026-05-041522025-12-10Late
2512100072025-12-02BAHAN BAKU BODY1010.0018CLAY AB 76#2606101783902512100322025-12-032025-12-03150,0003901–––2025-12-10Overdue
2511003582025-11-21SPAREPART5021.0124V. BELT B - 255251200072195,0002512000722025-12-042025-12-196195,000132601013022026-02-06642025-12-26Late
2511003582025-11-21SPAREPART5021.0124V. BELT B - 255251200072195,0002512000722025-12-042025-12-196195,000132512003072025-12-1062025-12-26On time
2511003932025-11-25PERSEDIAAN UMUM6050.0243ACCU / BATTERAY N-1202603000482,230,0002512000622025-12-042025-12-0411,659,45992512004722025-12-15112025-12-11Late
2511004502025-11-29BAHAN PEMBANTU2054.0001KLEM GALVANIS2605004672502512000692025-12-042025-12-222,00026052512004402025-12-1392025-12-29On time
2511004612025-11-29STATIONERY6010.0013KERTAS HVS KUNING26060025758,0002512000732025-12-042025-12-15162,00052512002362025-12-0952025-12-22On time
2511004722025-11-29PERSEDIAAN UMUM6020.0056PENETRATING OIL ER 571126050045554,5002512000742025-12-042025-12-193649,50052512004392025-12-1392025-12-26On time
2511004752025-11-29PERSEDIAAN UMUM6030.0614KERTAS GOSOK NO 02605004922,837.842512000712025-12-042025-12-22152,702.752512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.0733RESIBON POTONG 105X1.2X162605004922,702.72512000712025-12-042025-12-22602,702.752512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6050.005SIKAT BAJA26050049211,351.352512000712025-12-042025-12-221210,810.8152512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.0616KERTAS GOSOK NO 22605004923,378.382512000712025-12-042025-12-22153,243.2452512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.0615KERTAS GOSOK NO 12605004923,018.022512000712025-12-042025-12-22152,882.8852512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.0627RESIBON POTONG 4 INCH 100X6X1626050049210,810.812512000712025-12-042025-12-222010,360.3652512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.0527SEAL TAPE2606001484,504.512512000712025-12-042025-12-22254,504.5152512003042025-12-1062025-12-29On time
2511004752025-11-29PERSEDIAAN UMUM6030.0632KACA LAS HITAM2605004902,702.72512000712025-12-042025-12-2252,702.752512003042025-12-1062025-12-29On time
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 11 of 135Next →Rows per page:1020501005001000