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
2512005042025-12-31STATIONERY6010.0251BOX FILE26010014232,0002601001422026-01-082026-01-231432,00082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0192BUKU FOLIO 21.5*30.5 21.5 X 31.5 CM26060010816,5002601001422026-01-082026-01-231016,30082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.019BUKU TULIS SIDU(16*21) 16 X 21 CM2606000274,6002601001422026-01-082026-01-23204,60082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0241ISI BOLPOIN HITAM2606000277002601001422026-01-082026-01-234870082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0133SPIDOL MARKER HITAM - MARKER, HITAM/BLACK2606000275,7002601001422026-01-082026-01-23185,70082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0589LAKBAN HITAM 2 INCI / 48MM2604004939,9002601001422026-01-082026-01-2329,90082601005072026-01-1572026-01-30On time
2512005062025-12-31PERSEDIAAN UMUM6060.0208MUR M 102605004644502601001022026-01-082026-01-2615042582601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0209MUR M 122605004647002601001022026-01-082026-01-2615066082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.022MUR M 5260400531452601001022026-01-082026-01-261004582601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0597RING PLAT M-222605004641,2652601001022026-01-082026-01-261001,30082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0499RING PLAT M242601001021,6102601001022026-01-082026-01-261001,61082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0206MUR M 6260500464952601001022026-01-082026-01-261509582601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0207MUR M 82605004641502601001022026-01-082026-01-2615014582601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0236RING PLAT M-102605004641452601001022026-01-082026-01-2615014582601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0237RING PLAT M 122605004642602601001022026-01-082026-01-2615026082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0238RING PLAT M 142605004645502601001022026-01-082026-01-2615055082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0307AS DRAT M-102605004668,8502601001022026-01-082026-01-2687,30082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0308AS DRAT M-1226050046612,9002601001022026-01-082026-01-26810,50082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0234RING PLAT M-6260500464902601001022026-01-082026-01-261509082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0235RING PLAT M-8260500464902601001022026-01-082026-01-261509082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0013BAUT M-8*302604005254052601001022026-01-082026-01-2610036582601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0429BAUT M 8*352601001024002601001022026-01-082026-01-2610040082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.024RING PLAT M-182605004648052601001022026-01-082026-01-2610080582601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0212MUR M 182606001792,1152601001022026-01-082026-01-261002,05082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0041BAUT L M 6*302601001025002601001022026-01-082026-01-2610050082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0166BAUT M 6X102605004651802601001022026-01-082026-01-2610015082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0132BAUT M 6X152606001692002601001022026-01-082026-01-2610016582601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.004BAUT L M 6*202604005253852601001022026-01-082026-01-2610038582601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0071BAUT L M 10X502601001022,4002601001022026-01-082026-01-261002,40082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0014BAUT M-8*502604005255352601001022026-01-082026-01-2610048082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0648BAUT L M 14*502604000154,8502601001022026-01-082026-01-261004,85082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0205MUR M 4260400531352601001022026-01-082026-01-261003582601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0245RING PER M-122604003001502601001022026-01-082026-01-2610015082601004352026-01-1462026-02-02On time
2512005062025-12-31PERSEDIAAN UMUM6060.0265BORG M-8*52601001025502601001022026-01-082026-01-2610055082601004352026-01-1462026-02-02On time
2512005072025-12-31PERSEDIAAN UMUM6050.0067SAPU LIDI TONGKAT26050047511,0002601001402026-01-082026-01-224510,00082601005482026-01-1792026-01-29On time
2512005072025-12-31PERSEDIAAN UMUM6050.0044SIKAT KAMAR MANDI26040031640,0002601001402026-01-082026-01-22140,00082601005482026-01-1792026-01-29On time
2512005072025-12-31PERSEDIAAN UMUM6050.1231CIKRAK SENG26050042110,0002601001402026-01-082026-01-22210,00082601005482026-01-1792026-01-29On time
2512005072025-12-31PERSEDIAAN UMUM6050.0041PEL SUMBU26061008022,0002601001402026-01-082026-01-22745,00082601005482026-01-1792026-01-29On time
2512005072025-12-31PERSEDIAAN UMUM6050.0072SAPU DORONG 90 CM260500421113,0002601001402026-01-082026-01-2238103,00082601005482026-01-1792026-01-29On time
2512005072025-12-31PERSEDIAAN UMUM6050.0078REFILL SAPU DORONG26050042168,0002601001402026-01-082026-01-221465,00082601005482026-01-1792026-01-29On time
2512005072025-12-31PERSEDIAAN UMUM6030.0801SAPU PEMBERSIH SARANG LABA-LABA26010014020,0002601001402026-01-082026-01-22120,00082601005482026-01-1792026-01-29On time
2512005072025-12-31PERSEDIAAN UMUM6050.0039SAPU LIDI26061008012,0002601001402026-01-082026-01-22135,00082601005482026-01-1792026-01-29On time
2512005072025-12-31PERSEDIAAN UMUM6050.0038SAPU LANTAI26050042117,0002601001402026-01-082026-01-225516,00082601005482026-01-1792026-01-29On time
2512005072025-12-31PERSEDIAAN UMUM6030.0542TIMBA26010014020,0002601001402026-01-082026-01-22120,00082601005482026-01-1792026-01-29On time
2512005072025-12-31PERSEDIAAN UMUM6030.0576WIPER WATER26041016623,0002601001402026-01-082026-01-22240,00082601005482026-01-1792026-01-29On time
2512005072025-12-31PERSEDIAAN UMUM6050.0151KANTONG KRESEK JUMBO26050042140,0002601001402026-01-082026-01-22238,00082601005482026-01-1792026-01-29On time
2512005072025-12-31PERSEDIAAN UMUM6050.0162SEKROP26060008750,0002601001032026-01-082026-01-171250,00082601002952026-01-1242026-01-24On time
2512100392025-12-13PERSEDIAAN UMUM6030.2488ENGSEL PINTU LAS MODEL KUPU-KUPU26011004450,0002601100442026-01-082026-01-194050,000262601103782026-01-20122026-01-26On time
2512100422025-12-15STATIONERY6010.0528CETAKAN FORM SPRAY TOWER PRODUCTION & PROCESS PARAMETER INSPECTION RECORD ( FORM PRP04 )26011005480,0002601100542026-01-082026-01-19580,000242601103832026-01-20122026-01-26On time
2512100482025-12-16PERSEDIAAN UMUM6050.0859FEELER GAUGE SET 150MM BLADE LENGTH, 17 PIECES (0.02-1MM)26011004579,9002601100452026-01-082026-01-191279,900232601103242026-01-1792026-01-26On time
2512100562025-12-18PERSEDIAAN UMUM6030.159MESIN GERINDA GWS-700 4 INCH260610056355,855.862601100372026-01-082026-01-191413,000212601103112026-01-1792026-01-26On time
2512100582025-12-19STATIONERY6010.0752CETAKAN BUKU KECIL PB KOBIN KARAWANG26011005418,0002601100542026-01-082026-01-1910018,000202601103832026-01-20122026-01-26On time
2512100592025-12-19PERSEDIAAN UMUM6030.2504BAUT ROOFING M8X70MM2601100416652601100382026-01-082026-01-19300665202601103202026-01-1792026-01-26On time
2512100592025-12-19PERSEDIAAN UMUM6030.2503CNP 120x2.6x6000mm260110055300,0002601100552026-01-082026-01-0860300,000202601103162026-01-1792026-01-15Late
2512100592025-12-19PERSEDIAAN UMUM6030.1858PLAT BORDES TEBAL 10 mm2601100563,170,0002601100562026-01-082026-01-08203,170,000202601103142026-01-1792026-01-15Late
2512100592025-12-19PERSEDIAAN UMUM6030.1943BESI SIKU 50 X 50 X 5MM 6M260510069223,2002601100552026-01-082026-01-0850270,000202601103162026-01-1792026-01-15Late
2512100602025-12-20PERSEDIAAN UMUM6050.1208MESIN LAS 1200 WATT2601100393,040,0002601100392026-01-082026-01-1913,040,000192601102422026-01-1352026-01-26On time
2512100602025-12-20PERSEDIAAN UMUM6050.0515MESIN BOR TANGAN260110042443,0002601100422026-01-082026-01-191443,000192601103302026-01-1792026-01-26On time
2512100612025-12-19PERSEDIAAN UMUM6030.2504BAUT ROOFING M8X70MM2601100416652601100412026-01-082026-01-19300665202601103192026-01-1792026-01-26On time
2512100652025-12-23PERSEDIAAN UMUM6050.0996SEPATU BOOTS SIZE 43260100683125,0002601100362026-01-082026-01-19271,250162601102472026-01-1352026-01-26On time
2512100652025-12-23PERSEDIAAN UMUM6050.0995SEPATU BOOTS SIZE 42260400358160,0002601100362026-01-082026-01-19471,250162601102472026-01-1352026-01-26On time
2512100652025-12-23PERSEDIAAN UMUM6050.0993SEPATU BOOTS SIZE 40260100668160,0002601100362026-01-082026-01-191271,250162601102472026-01-1352026-01-26On time
2512100652025-12-23PERSEDIAAN UMUM6050.0994SEPATU BOOTS SIZE 41260400358160,0002601100362026-01-082026-01-191371,250162601102472026-01-1352026-01-26On time
2512100672025-12-24PERSEDIAAN UMUM6030.0528LEM PVC2605003869,909.912601100432026-01-082026-01-191039,599152601102392026-01-1352026-01-26On time
2512100682025-12-24STATIONERY6010.0523CETAKAN FORM GRADING QUALITY DEFECT DAILY REPORT ( FORM SRT03 )26011004936,0002601100492026-01-082026-01-1910036,000152601104052026-01-22142026-01-26On time
2512100682025-12-24STATIONERY6010.0578CETAKAN FORM NOTA HASIL PRODUSK (NHP)-REG, 3 PLY UKURAN 14,5X10 CM (FORM SRT08)26061007410,0002601100492026-01-082026-01-1930010,000152601104052026-01-22142026-01-26On time
2512100682025-12-24STATIONERY6010.0491RED WA CRAYON26051017757,8002601100542026-01-082026-01-19357,800152601103832026-01-20122026-01-26On time
2601000022026-01-02SPAREPART5032.058SELANG NEPLE GREASE GUN (TEKIRO)26010097340,540.542601001492026-01-082026-01-141127,702.762601005562026-01-1792026-01-21On time
2601000022026-01-02SPAREPART5032.0456FUSE GEPENG 10 A26010010112,5002601001012026-01-082026-01-191012,50062601005162026-01-1572026-01-26On time
2601000022026-01-02SPAREPART5032.0457FUSE GEPENG 15 A26010010112,5002601001012026-01-082026-01-191012,50062601005162026-01-1572026-01-26On time
2601000022026-01-02SPAREPART5032.0458FUSE GEPENG 20 A26010010112,5002601001012026-01-082026-01-191012,50062601005162026-01-1572026-01-26On time
2601000022026-01-02SPAREPART5032.0317FUSE GEPENG 25 A26010010112,5002601001012026-01-082026-01-191012,50062601005162026-01-1572026-01-26On time
2601000072026-01-02PERSEDIAAN UMUM6060.0317AS DRAT SS M 16260100941136,0002601000992026-01-082026-01-195136,00062601004342026-01-1462026-01-26On time
2601000232026-01-05STATIONERY6010.0079FORM LAPORAN DENSITAS/KADAR AIR26010014812,5002601001482026-01-082026-01-271012,50032601003392026-01-1242026-02-03On time
2601000232026-01-05STATIONERY6010.0086FORM LAPORAN SILO ATM 1000026050039412,0002601001482026-01-082026-01-271012,50032601003392026-01-1242026-02-03On time
2601000232026-01-05STATIONERY6010.0066FORM LAPORAN KADAR AIR SILO26010014812,5002601001482026-01-082026-01-271012,50032601003392026-01-1242026-02-03On time
2601000232026-01-05STATIONERY6010.0063FORM LAPORAN BAGIAN SPRAY DRYER ATM26010014812,5002601001482026-01-082026-01-271012,50032601003392026-01-1242026-02-03On time
2601000232026-01-05STATIONERY6010.0093FORM LAPORAN PEMAKAIAN NOZEL ATM 10.00026010014812,5002601001482026-01-082026-01-271012,50032601003392026-01-1242026-02-03On time
2601000242026-01-05PERSEDIAAN UMUM6050.0202CORONG BESAR26010013925,0002601001392026-01-082026-01-15125,00032601005502026-01-1792026-01-22On time
2601000282026-01-06SPAREPART5017.1059FUSE 1.25A 5X20MM26010013310,0002601001332026-01-082026-01-153010,00022606003692026-06-101532026-01-22Late
2601000382026-01-06PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232601001092026-01-082026-01-19557,472.9722601003802026-01-1352026-01-26On time
2601000382026-01-06PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002601001092026-01-082026-01-19531,605.0522601003802026-01-1352026-01-26On time
2601000392026-01-06PERSEDIAAN UMUM6050.039CONSTANT HT 100260100145550,0002601001452026-01-082026-01-262550,00022601008852026-01-26182026-02-02On time
2601000412026-01-06PERSEDIAAN UMUM6050.0995SEPATU BOOTS SIZE 42260400358160,0002601001372026-01-082026-01-152125,00022601005522026-01-1792026-01-22On time
2601000412026-01-06PERSEDIAAN UMUM6050.0992SEPATU BOOTS SIZE 39260100137125,0002601001372026-01-082026-01-152125,00022601005522026-01-1792026-01-22On time
2601000432026-01-06PERSEDIAAN UMUM6050.0046KEMOCENG26061009410,0002601001002026-01-082026-01-12120,00022601005512026-01-1792026-01-19On time
2601000432026-01-06PERSEDIAAN UMUM6050.0041PEL SUMBU26061008022,0002601001002026-01-082026-01-12145,00022601005512026-01-1792026-01-19On time
2601000542026-01-06BAHAN PEMBANTU2033.0003FLUORESCENT LIQUID MARKER (TRANSPARENT)26050026832,5002601001102026-01-082026-01-144031,00022601006872026-01-21132026-01-21On time
2601000552026-01-06BAHAN PEMBANTU2033.0002BLACK INK26060003375,024.62601001112026-01-082026-01-148070,49722601003442026-01-1242026-01-21On time
2601000562026-01-06BAHAN PEMBANTU2054.0001KLEM GALVANIS2605004672502601001432026-01-082026-01-214,00027522601006862026-01-21132026-01-28On time
2601000582026-01-05BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002601000952026-01-082026-01-151,35274,00032601019362026-02-24472026-01-22Late
2601000582026-01-05BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002601000952026-01-082026-01-151,35274,00032601005792026-01-19112026-01-22On time
2601000582026-01-05BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002601000952026-01-082026-01-151,35274,00032601016922026-02-18412026-01-22Late
2601000582026-01-05BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002601000952026-01-082026-01-151,35274,00032601005432026-01-1792026-01-22On time
2601000582026-01-05BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002601000952026-01-082026-01-151,35274,00032603000062026-03-02532026-01-22Late
2601000582026-01-05BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002601000952026-01-082026-01-151,35274,00032601020122026-02-26492026-01-22Late
2601000582026-01-05BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002601000952026-01-082026-01-151,35274,00032601013662026-02-09322026-01-22Late
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601002122026-01-082026-01-1970050,00032601011322026-02-02252026-01-26Late
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601002112026-01-082026-01-221,00058,00032601009042026-01-27192026-01-29On time
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601002122026-01-082026-01-1970050,00032601009482026-01-28202026-01-26Late
← PrevPage 35 of 135Next →Rows per page:1020501005001000