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
2511003762025-11-25SPAREPART5017.0341KOTAK BLOCK SCHNEIDER TYPE GVAE11260400421125,0002512002852025-12-152025-12-294110,000202601003002026-01-12282026-01-05Late
2511004642025-11-29PERSEDIAAN UMUM6060.0315AS DRAT SS M 1226050046677,5002512002922025-12-152025-12-27674,800162512007272025-12-2272026-01-03On time
2511004642025-11-29PERSEDIAAN UMUM6060.0311AS DRAT M-1826050046635,4002512002922025-12-152025-12-27629,500162512007272025-12-2272026-01-03On time
2511004642025-11-29PERSEDIAAN UMUM6060.031AS DRAT M-1626050046624,2002512002922025-12-152025-12-27619,600162512007272025-12-2272026-01-03On time
2511004642025-11-29PERSEDIAAN UMUM6060.0309AS DRAT M-1426050046618,3002512002922025-12-152025-12-27815,100162512007272025-12-2272026-01-03On time
2511004642025-11-29PERSEDIAAN UMUM6060.0308AS DRAT M-1226050046612,9002512002882025-12-152025-12-30610,440162601018722026-02-23702026-01-06Late
2511004642025-11-29PERSEDIAAN UMUM6060.0307AS DRAT M-102605004668,8502512002882025-12-152025-12-3077,260162601018722026-02-23702026-01-06Late
2511100892025-11-25SPAREPART5027.0374STRIP KARET PENAHAN26041008168,0002512100722025-12-152025-12-2410068,000202512104952025-12-2492025-12-31On time
2511100892025-11-25SPAREPART5027.0374STRIP KARET PENAHAN26041008168,0002512100722025-12-152025-12-2410068,000202512104942025-12-2492025-12-31On time
2512000702025-12-01BAHAN BAKU GLAZE1020.0019OPACIFIER U-1026060004028,580.82512002572025-12-152025-12-2020,00026,643.2142512007992025-12-2382025-12-27On time
2512000962025-12-05PERSEDIAAN UMUM6010.0726Shopsign Adi Putra Banteng, Ponorogo (4m x 1m - 1 sisi)2512002832,000,0002512002832025-12-152025-12-1512,000,000102601004552026-01-14302025-12-22Late
2512000962025-12-05PERSEDIAAN UMUM6010.0725Shopsign Adi Putra Pule, Ponorogo (3m x 1m - 1 sisi)2512002831,500,0002512002832025-12-152025-12-1511,500,000102601004552026-01-14302025-12-22Late
2512000962025-12-05PERSEDIAAN UMUM6010.0727Shopsign Adi Putra Gunting, Madiun (4m x 1,1m - 1 sisi)2512002832,200,0002512002832025-12-152025-12-1512,200,000102601004552026-01-14302025-12-22Late
2512001192025-12-08BAHAN PACKING3011.0223NFT00 40X40 PARIS MP1 KW-B 403X51 (BK150/125/125)2604004124092512002632025-12-152026-01-1020,0003307–––2026-01-17Overdue
2512001192025-12-08BAHAN PACKING3011.0224NFT00 40X40 PARIS MP2 KW-B 403X54 (BK150/125/125)2604004123572512002632025-12-152026-01-1020,0002907–––2026-01-17Overdue
2512001262025-12-06PERSEDIAAN UMUM6050.0376TANG SNAPRING TUTUP 7 INCH26050038953,8502512002932025-12-152025-12-26249,00092512006942025-12-2272026-01-02On time
2512001262025-12-06PERSEDIAAN UMUM6050.0455TANG BUAYA26050038976,4002512002932025-12-152025-12-26298,963.9692512006942025-12-2272026-01-02On time
2512001262025-12-06PERSEDIAAN UMUM6050.0377TANG SNAPRING BUKA 7 INCH26050038953,8502512002932025-12-152025-12-26249,00092512006942025-12-2272026-01-02On time
2512001262025-12-06PERSEDIAAN UMUM6030.0531ISOLASI LAKBAN2606001459,9002512003012025-12-152025-12-2454,90092512006912025-12-2272025-12-31On time
2512001762025-12-10SPAREPART5017.0138OMRON SOCKET PYF 14 AN26050016125,0002512002912025-12-152025-12-261022,00052601002992026-01-12282026-01-02Late
2512001762025-12-10SPAREPART5017.0376OMRON RELAY MY2-N220 VAC26040018941,8002512002912025-12-152025-12-261040,00052601002992026-01-12282026-01-02Late
2512001762025-12-10SPAREPART5017.014PUSH BOTTON TELE XB2 BA3126050015054,9402512002912025-12-152025-12-26582,00052601002992026-01-12282026-01-02Late
2512001762025-12-10SPAREPART5017.0143TELE AUX BLOCK ZBE 10126050015024,5002512002912025-12-152025-12-26524,50052601002992026-01-12282026-01-02Late
2512001762025-12-10SPAREPART5017.0147TELE SELECTOR XB4 BD33260300481142,8002512002912025-12-152025-12-2610130,00052601002992026-01-12282026-01-02Late
2512001762025-12-10SPAREPART5017.0141PUSH BOTTON TELE XB2 BA4226010100851,9402512003032025-12-152025-12-30551,94052605001952026-05-071432026-01-06Late
2512001762025-12-10SPAREPART5017.0145TELE SELECTOR XB4 BD21260600252122,9002512002912025-12-152025-12-2610113,50052601002992026-01-12282026-01-02Late
2512001772025-12-10SPAREPART5011.0362BEARING 6406260400546221,5002512002902025-12-152025-12-275145,85052512007722025-12-2382026-01-03On time
2512001772025-12-10SPAREPART5011.0177BEARING 6405 ZZ251200290130,0502512002902025-12-152025-12-275130,05052512007722025-12-2382026-01-03On time
2512001772025-12-10SPAREPART5011.0141BEARING 6304 2RS26050012033,5002512002902025-12-152025-12-271033,85052512007722025-12-2382026-01-03On time
2512001772025-12-10SPAREPART5011.0138BEARING 6303 2RS C326010017926,3002512002892025-12-152025-12-261026,30052512006112025-12-1832026-01-02On time
2512001772025-12-10SPAREPART5011.0101BEARING 6205 2RS2604101407,1102512002892025-12-152025-12-261028,10052512006112025-12-1832026-01-02On time
2512001772025-12-10SPAREPART5011.0102BEARING 6206 2RS C326060022735,3002512002892025-12-152025-12-261035,30052512006112025-12-1832026-01-02On time
2512001772025-12-10SPAREPART5011.0091BEARING 6200 2RS26010094323,9002512002902025-12-152025-12-275022,40052603002642026-03-06812026-01-03Late
2512001772025-12-10SPAREPART5011.0061BEARING 6000 2RS26050014923,8002512002892025-12-152025-12-261526,00052512006112025-12-1832026-01-02On time
2512001772025-12-10SPAREPART5011.0065BEARING 6002 2RS26050046920,0002512002902025-12-152025-12-275019,90052512007722025-12-2382026-01-03On time
2512001772025-12-10SPAREPART5011.0075BEARING 6009 2RS.C325120028958,8002512002892025-12-152025-12-261058,80052512006112025-12-1832026-01-02On time
2512001772025-12-10SPAREPART5011.0071BEARING 6006 2RS C326040001234,9002512002902025-12-152025-12-271034,15052512007722025-12-2382026-01-03On time
2512001772025-12-10SPAREPART5011.0144BEARING 6305 2RS26050014943,6002512002902025-12-152025-12-271043,30052512007722025-12-2382026-01-03On time
2512001962025-12-11PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252512003002025-12-152025-12-24553,689.1942512007002025-12-2272025-12-31On time
2512001962025-12-11PERSEDIAAN UMUM6030.0917THINER A BIASA @ 5 LTR26050040363,5002512003002025-12-152025-12-241132,525.2342512007002025-12-2272025-12-31On time
2512002042025-12-12PERSEDIAAN UMUM6030.1561BETON READYMIX MUTU K300260600062780,0002512002942025-12-152025-12-157750,00032512009242025-12-29142025-12-22Late
2512002042025-12-12PERSEDIAAN UMUM6030.1561BETON READYMIX MUTU K300260600062780,0002512002942025-12-152025-12-157750,00032601003742026-01-13292025-12-22Late
2512002232025-12-12SPAREPART5028.0197MARTIN PULLY SPA 180 - 2 TAPER BUSH 2012 - 45251200286800,0002512002862025-12-152025-12-301800,00032512008352025-12-2492026-01-06On time
2512002232025-12-12SPAREPART5028.0188MARTIN PULLY SPA 160 - 2 TAPER BUSH 2012 - 40251200286680,0002512002862025-12-152025-12-301680,00032512008352025-12-2492026-01-06On time
2512002262025-12-12PERSEDIAAN UMUM6020.0369KABEL NYYHY 4X1.5 MM2605001012,300,0002512002872025-12-152025-12-3081,850,00032601003012026-01-12282026-01-06Late
2512002262025-12-12PERSEDIAAN UMUM6020.0103KABEL NYAF 1X0.75 MM260600150303,603.62512002872025-12-152025-12-303225,00032601003012026-01-12282026-01-06Late
2512002342025-12-15SPAREPART5011.0411BEARING RN 307 NTN260300230175,0002512003022025-12-152025-12-242225,000–2512007322025-12-2272025-12-31On time
2512100322025-12-11PERSEDIAAN UMUM6010.0612SERAGAM HO KEMEJA PUTIH UKURAN M26060027892,0002512100702025-12-152026-01-131880,00042601108922026-02-13602026-01-20Late
2512100322025-12-11PERSEDIAAN UMUM6010.0641SERAGAM HO KEMEJA PUTIH UKURAN 3XL25121007080,0002512100702025-12-152026-01-13380,00042601108922026-02-13602026-01-20Late
2512100322025-12-11PERSEDIAAN UMUM6010.0741SERAGAM HO KEMEJA PUTIH UKURAN S26060027892,0002512100702025-12-152026-01-13980,00042601108922026-02-13602026-01-20Late
← PrevPage 35 of 270Next →Rows per page:1020501005001000