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,00012512105262025-12-26232025-12-17Late
2512100062025-12-02BAHAN PEMBANTU3034.0003TECHNOMELT 2930 ID25KG26051021852,0002512100102025-12-032025-12-101,50034,00012512102312025-12-1182025-12-17On time
2512100072025-12-02BAHAN BAKU BODY1010.0018CLAY AB 76#2606101783902512100322025-12-032025-12-03150,0003901–––2025-12-10Overdue
2512100072025-12-02BAHAN BAKU BODY1010.0018CLAY AB 76#2606101783902512100322025-12-032025-12-03150,00039012605100382026-05-041522025-12-10Late
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
← PrevPage 21 of 270Next →Rows per page:1020501005001000