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
2511004292025-11-28PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002512000542025-12-032025-12-175031,605.0552512005252025-12-16132025-12-24On time
2511004292025-11-28PERSEDIAAN UMUM6030.2426CAT AVIAN DOVER GREY 92426030027257,472.972512000542025-12-032025-12-175057,472.9752512005252025-12-16132025-12-24On time
2511004292025-11-28PERSEDIAAN UMUM6030.2426CAT AVIAN DOVER GREY 92426030027257,472.972512000542025-12-032025-12-175057,472.9752512002452025-12-0962025-12-24On time
2511004312025-11-28PERSEDIAAN UMUM6020.0112KABEL NYY 1X25 MM25120005654,8812512000562025-12-032025-12-172054,88152512002702025-12-0962025-12-24On time
2511004452025-11-28PERSEDIAAN UMUM6030.0518CAT BESI AVIAN 160 CARROT25120025857,472.972512000532025-12-032025-12-225057,472.9752512002942025-12-1072025-12-29On time
2511004452025-11-28PERSEDIAAN UMUM6030.0518CAT BESI AVIAN 160 CARROT25120025857,472.972512000532025-12-032025-12-225057,472.9752512004652025-12-13102025-12-29On time
2511004452025-11-28PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002512000532025-12-032025-12-222531,605.0552512004652025-12-13102025-12-29On time
2511004452025-11-28PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002512000532025-12-032025-12-222531,605.0552512002942025-12-1072025-12-29On time
2511004552025-11-29PERSEDIAAN UMUM6030.0803KAWAT LAS LB 52 OD 3.2 MM26060012341,531.532512000452025-12-032025-12-0320036,531.5342512002712025-12-0962025-12-10On time
2511004592025-11-29PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002512000342025-12-032025-12-202531,605.0542512002462025-12-0962025-12-27On time
2511004592025-11-29PERSEDIAAN UMUM6030.062KUAS 2 INCH2605004405,794.62512000342025-12-032025-12-2085,541.4442512002482025-12-0962025-12-27On time
2511004592025-11-29PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232512000342025-12-032025-12-20357,472.9742512002462025-12-0962025-12-27On time
2511004592025-11-29PERSEDIAAN UMUM6030.052CAT BESI / KAYU AVIAN TWILIGHT BLUE 73126010069257,472.972512000342025-12-032025-12-20457,472.9742512002462025-12-0962025-12-27On time
2511004592025-11-29PERSEDIAAN UMUM6030.2432CAT AVIAN MATT PURE WHITE PWM26010034857,472.972512000342025-12-032025-12-20557,472.9742512002462025-12-0962025-12-27On time
2511004592025-11-29PERSEDIAAN UMUM6030.1977CAT AVIAN PUMPKIN ORANGE 1792604101331,291,5812512000342025-12-032025-12-20557,472.9742512002462025-12-0962025-12-27On time
2511004592025-11-29PERSEDIAAN UMUM6030.1974CAT AVIAN ZINC CHROMATE 972226010034840,994.62512000342025-12-032025-12-20440,958.3342512002462025-12-0962025-12-27On time
2511004612025-11-29STATIONERY6010.0013KERTAS HVS KUNING26060025758,0002512000302025-12-032025-12-15166,00042512001122025-12-0522025-12-22On time
2511004622025-11-29STATIONERY6010.001POST IT KECIL2605000266,0002512000772025-12-032025-12-2238,70042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0139STABILO KUNING2606000279,3002512000772025-12-032025-12-2229,30042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0138STABILO ORANGE2606000279,3002512000772025-12-032025-12-2229,30042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0126ISI PENSIL 2B CETEKAN 2B,0.5 mm,12TUBE/BOX,60 mm 12LEADS/TUBE2605000253,0002512000772025-12-032025-12-2233,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0006CONTINUOUS FORM 1 PLY 9.5 X 11:2260600027204,5002512000772025-12-032025-12-223204,50042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0184MAP PLASTIK L TRANSPARAN, F42605004191,6002512000772025-12-032025-12-2231,70042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0004KERTAS GLOSSY A4 200 GRAM A4200 A4, 200 GRAM, GLOSSY25120007714,0002512000772025-12-032025-12-22314,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0146ACCO FASTENER 8.0 CM, 50 SETS/BOX2601005237,7002512000772025-12-032025-12-2217,70042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0275TINTA EPSON BLACK - T664126060002783,0002512000772025-12-032025-12-22183,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0156STAPLES KECIL HD-102606101519,7412512000772025-12-032025-12-22434,50042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0241ISI BOLPOIN HITAM2606000277002512000772025-12-032025-12-222470042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0186PLASTIK BANTEX 8843 CLEAR, 24 x 34 CM, 20 PCS/BAG26060025630,0002512000772025-12-032025-12-22128,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.015ISI CUTTER BESAR L-1502606100606,5002512000772025-12-032025-12-223601,00042512004542025-12-13102025-12-29On time
2511004622025-11-29PERSEDIAAN UMUM6020.0035BATERAI AA2601104505,5002512000772025-12-032025-12-22442,30042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0235CLIPBOARD26060025616,8002512000772025-12-032025-12-22711,40042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0306REFIL SPIDOL MARKER HITAM2606000279,0002512000772025-12-032025-12-2269,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0267REFIL SPIDOL BOARDMARKER MERAH RED/MERAH, OD: 3.0 CM, H: 5.5 CM26060002714,2002512000772025-12-032025-12-22614,20042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0266REFIL SPIDOL BOARDMARKER HITAM - BLACK/HITAM, OD: 3.0 CM, H: 5.5 CM26060002714,2002512000772025-12-032025-12-221214,20042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0194MOUSE PAD2512000776,0002512000772025-12-032025-12-2216,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0014KERTAS HVS HIJAU26060025758,0002512000772025-12-032025-12-22168,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0013KERTAS HVS KUNING26060025758,0002512000772025-12-032025-12-22268,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0012KERTAS HVS MERAH26060025758,0002512000772025-12-032025-12-22168,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0148CUTTER BESAR L-5002606101517,7672512000772025-12-032025-12-22812,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0153PENGGARIS BESI BESI/IRON, 30 CM2604002066,0002512000772025-12-032025-12-2226,70042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0168GUNTING SEDANG2606000276,2002512000772025-12-032025-12-2236,20042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.017PLONG KERTAS BESAR () PITCH 8 CM, 11 X 15X 13 CM25120013750,0002512000772025-12-032025-12-22150,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0175BINDER CLIP NO. 260 NO. 26026061006018,0002512000772025-12-032025-12-22213,40042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0174BINDER CLIP NO. 155 NO. 1552606100607,2002512000772025-12-032025-12-2255,20042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0173BINDER CLIP NO. 111 NO. 1112606000273,8002512000772025-12-032025-12-2263,80042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0172BINDER CLIP NO. 107 NO. 1072606100603,5002512000772025-12-032025-12-2222,50042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0171BINDER CLIP NO. 105 NO. 1052606001082,2002512000772025-12-032025-12-2222,30042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0243PAPER CLIP NO 52604002074,0002512000772025-12-032025-12-22134,00042512004542025-12-13102025-12-29On time
2511004622025-11-29STATIONERY6010.0151ISI STAPLES KECIL #10 KECIL, NO.10-1M2606101511,5922512000772025-12-032025-12-22422,70042512004542025-12-13102025-12-29On time
← PrevPage 20 of 270Next →Rows per page:1020501005001000