KKobin GroupProcurement KPI

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
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601103352026-01-20492025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601101522026-01-10392025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601102082026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601102192026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601105402026-01-29582025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601102172026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601102802026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.002CLAY AYO 52#2606101794852512100072025-12-022025-12-026,000,0004352512101642025-12-0972025-12-09On time
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601102812026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601105942026-02-02622025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601101302026-01-09382025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601100902026-01-08372025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601100892026-01-08372025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682025-12-09Overdue
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601103402026-01-20492025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682512102012025-12-1082025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601100362026-01-06352025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601101322026-01-09382025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601100872026-01-08372025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601102202026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.002CLAY AYO 52#2606101794852512100072025-12-022025-12-026,000,0004352025-12-09Overdue
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,0004082512102052025-12-1082025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601104772026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,0004082512102252025-12-1192025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,0004082512102272025-12-1192025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,0004082512104752025-12-23212025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601104892026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601102852026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601105492026-01-30592025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601104832026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601102122026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,0004082512103212025-12-16142025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,0004082512102062025-12-1082025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,0004082512102072025-12-1082025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601104862026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,0004082512102172025-12-1192025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601102152026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,0004082512102192025-12-1192025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,0004682601102952026-01-17462025-12-09Late
2511003472025-11-21PERSEDIAAN UMUM6020.0052STOPWATCH260600222200,2502512000322025-12-032025-12-153168,833.33122512001142025-12-0522025-12-22On time
2511003592025-11-22PERSEDIAAN UMUM6050.042KUNCI RING PAS 27 MM26040001887,567.572512000402025-12-032025-12-15187,567.57112512002492025-12-0962025-12-22On time
2511003592025-11-22PERSEDIAAN UMUM6050.0375OBENG(+)() 6 INCH(+)25120004030,765.772512000402025-12-032025-12-15130,765.77112512002492025-12-0962025-12-22On time
2511003732025-11-25SPAREPART5021.0412V. BELT B - 154260500209122,9002512000352025-12-032025-12-2212111,90082512001352025-12-0522025-12-29On time
2511003732025-11-25SPAREPART5021.0412V. BELT B - 154260500209122,9002512000352025-12-032025-12-2212111,90082512006152025-12-18152025-12-29On time
2511003742025-11-25SPAREPART5026.0014PURITY WIPES 9" X 9" 90008614 (1 PACK = 100 SHEETS)260400181280,2502512000442025-12-032025-12-103280,25082512004312025-12-13102025-12-17On time
2511003952025-11-25PERSEDIAAN UMUM6030.2421PVC STRIP CURTAIN BLUE CLEAR 2MM X 200MM X 50M2606002641,450,0002512000482025-12-032025-12-03101,450,00082512005052025-12-16132025-12-10Late
2511003992025-11-25PERSEDIAAN UMUM6050.011PLASTIK KANTONG 1/4 KG2512000299,0002512000292025-12-032025-12-1569,00082512001132025-12-0522025-12-22On time
2511004282025-11-28SPAREPART5019.0268GEAR REDUCER MNRV 050 RATIO 1:15 0.75 KW FLANGE B52512000423,062,5002512000422025-12-032025-12-1823,062,50052512004422025-12-13102025-12-25On time
2511004282025-11-28SPAREPART5011.0279BEARING UCP 206260400546120,3002512000412025-12-032025-12-176127,00052512001362025-12-0522025-12-24On time
2511004292025-11-28PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002512000542025-12-032025-12-175031,605.0552512002452025-12-0962025-12-24On time
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 10 of 135Next →Rows per page:1020501005001000