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
2511101002025-11-29PERSEDIAAN UMUM6020.0353DUCTING 25X25 PUTIH POLOS25121006099,7502512100602025-12-102025-12-19299,750112512102872025-12-1332025-12-26On time
2511101002025-11-29PERSEDIAAN UMUM6020.0663KABEL SPIRAL2512101221,3102512100602025-12-102025-12-19102,090112512102872025-12-1332025-12-26On time
2511101002025-11-29PERSEDIAAN UMUM6020.0475BUSBAR TERMINAL GROUNDING 5 LUBANG251210060209,0002512100602025-12-102025-12-192209,000112512102872025-12-1332025-12-26On time
2511101002025-11-29PERSEDIAAN UMUM6020.0664TERMINAL BLOCK ACRILIC 20A, 12 POLE25121006015,2002512100602025-12-102025-12-19215,200112512102872025-12-1332025-12-26On time
2512000222025-12-01PERSEDIAAN UMUM6030.008PIPA GALVANIS 1 INCH MED SNI260600210320,0002512001732025-12-102025-12-106365,00092512004452025-12-1332025-12-17On time
2512000222025-12-01PERSEDIAAN UMUM6030.0527SEAL TAPE2606001484,504.512512001732025-12-102025-12-10105,00092512004452025-12-1332025-12-17On time
2512000222025-12-01PERSEDIAAN UMUM6030.0114WATER MUR GALVANIS 1 INCH25120017345,0002512001732025-12-102025-12-10345,00092512004452025-12-1332025-12-17On time
2512000222025-12-01PERSEDIAAN UMUM6030.0569SOCK DRAT DALAM 1 INCH26040028311,441.442512001732025-12-102025-12-10520,00092512004452025-12-1332025-12-17On time
2512000222025-12-01PERSEDIAAN UMUM6030.1495ELBOW DRAT DALAM 1 INCH26030000920,0002512001732025-12-102025-12-10522,00092512004452025-12-1332025-12-17On time
2512000432025-12-03SPAREPART5019.0269MOTOR 0.75 KW 1 HP 1460 RPM 380 V B52605001361,187,5002512001812025-12-102025-12-2912,400,00072512007292025-12-22122026-01-05On time
2512000432025-12-03SPAREPART5030.067MOTOR 0.75 KW 1 HP 1460 RPM 380 V B142605001361,187,5002512001812025-12-102025-12-2912,400,00072512007292025-12-22122026-01-05On time
2512000762025-12-03PERSEDIAAN UMUM6050.0111OXYGEN26060017745,0002512002492025-12-102025-12-101090,00072512004682025-12-1552025-12-17On time
2512000922025-12-04FIXED ASSETSAST02510PRINTER EPSON L14150 A3+2512001726,750,0002512001722025-12-102025-12-1016,750,00062512005012025-12-1662025-12-17On time
2512001202025-12-08BAHAN BAKU GLAZE1099.0007ENGOBE UNDER TILE WE-802606000823,4002512001712025-12-102025-12-1510,0003,40022512005882025-12-1772025-12-22On time
2512001222025-12-06PERSEDIAAN UMUM6030.003PAKU 2 INCH26060016715,333.332512002042025-12-102025-12-203015,00042512005282025-12-1662025-12-27On time
2512001412025-12-09PERSEDIAAN UMUM6030.0009ADITON / PENGERAS COR25120017945,0002512001792025-12-102025-12-10345,00012512004692025-12-1552025-12-17On time
2512001502025-12-09PERSEDIAAN UMUM6030.2011SEMEN TIGA RODA 50 KG25120018058,0002512001802025-12-102025-12-201058,00012512004462025-12-1332025-12-27On time
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512100652025-12-102025-12-192,00042,00082601105542026-01-30512025-12-26Late
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512100652025-12-102025-12-192,00042,00082601100022026-01-02232025-12-26Late
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512100652025-12-102025-12-192,00042,00082605101982026-05-111522025-12-26Late
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512100652025-12-102025-12-192,00042,00082512105672025-12-29192025-12-26Late
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512100652025-12-102025-12-192,00042,00082601109592026-02-16682025-12-26Late
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512100652025-12-102025-12-192,00042,00082601103072026-01-17382025-12-26Late
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512100652025-12-102025-12-192,00042,00082512102772025-12-1222025-12-26On time
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512100652025-12-102025-12-192,00042,00082605106352026-05-221632025-12-26Late
2512100092025-12-02PERSEDIAAN UMUM6020.0052STOPWATCH260600222200,2502512100552025-12-102025-12-10124,90082512104362025-12-1992025-12-17Late
2512100092025-12-02PERSEDIAAN UMUM6030.0613METERAN 5 MTR2605101569,3632512100552025-12-102025-12-10120,5508–––2025-12-17Overdue
2512100212025-12-08PERSEDIAAN UMUM6050.0938LEM AICA AIBON (KEMASAN 300GRAM)26051017956,0002512100592025-12-102025-12-192549,00022512102552025-12-1222025-12-26On time
2512100222025-12-08PERSEDIAAN UMUM6030.0642KACA LAS BENING2606100226752512100582025-12-102025-12-193050022512102902025-12-1332025-12-26On time
2512100222025-12-08PERSEDIAAN UMUM6020.039ISOLASI KABEL HITAM2605101398,1092512100582025-12-102025-12-191010,00022512102902025-12-1332025-12-26On time
2512100232025-12-06BAHAN BAKU GLAZE1070.0031INK DP RED GSB 10023 GUOSE2603100561202512100622025-12-102025-12-1020012042603103292026-03-18982025-12-17Late
2512100252025-12-08PERSEDIAAN UMUM6030.1729AVIAN THINNER ENAMEL26061013957,554.172512100572025-12-102025-12-192429,925.2322601104232026-01-23442025-12-26Late
2512100282025-12-10PROMOSI6010.0701SEPEDA LISTRIK2512100543,180,0002512100542025-12-102025-12-1053,180,000–2512104272025-12-1992025-12-17Late
2512100292025-12-10FIXED ASSETSAST02543SEPEDA LISTRIK PK022512100613,180,0002512100612025-12-102025-12-1053,180,000––––2025-12-17Overdue
2511003702025-11-25SPAREPART5017.0985AUTONICS MP5W 2N251200566910,0002512005662025-12-112025-12-301910,000162601002632026-01-09292026-01-06Late
2511003802025-11-25PERSEDIAAN UMUM6020.0103KABEL NYAF 1X0.75 MM260600150303,603.62512002302025-12-112025-12-261245,000162512006962025-12-22112026-01-02On time
2511003802025-11-25PERSEDIAAN UMUM6020.0443SKUN KABEL U 0.75MM25120023019,0002512002302025-12-112025-12-26219,000162512006962025-12-22112026-01-02On time
2511003842025-11-25SPAREPART5017.099MOMENTARY SELECTOR SWITCH (TYPE 3 POSISI NO+NO)25120022497,2002512002242025-12-112025-12-301097,200162512006952025-12-22112026-01-06On time
2511003872025-11-25SPAREPART5017.0989FUSE HOLDER 10X3825120022619,0002512002262025-12-112025-12-30519,000162601008272026-01-24442026-01-06Late
2511003872025-11-25SPAREPART5017.0988SIBA LEGRAND FUSE 20 A (10X38)25120022648,0002512002262025-12-112025-12-30548,000162601008272026-01-24442026-01-06Late
2511003872025-11-25SPAREPART5017.0306SIBA LEGRAND FUSE 10 A (10X38)25120022638,0002512002262025-12-112025-12-30538,000162601008272026-01-24442026-01-06Late
2511004272025-11-28SPAREPART5017.0991DOUBLE LEVEL TERMINAL BLOCK26010051017,5002512002232025-12-112025-12-272512,500132512006982025-12-22112026-01-03On time
2511004302025-11-28SPAREPART5017.0151OMRON TIMER H3CRF-F8251200225543,8002512002252025-12-112025-12-302543,800132512006992025-12-22112026-01-06On time
2511004332025-11-28SPAREPART5017.0166INVERTER MITSUBISHI FR-D740-0.75 K2605000242,550,0002512002222025-12-112025-12-3042,550,000132512006282025-12-1872026-01-06On time
2511004362025-11-28SPAREPART5017.0993FAN PANEL 8X8 CM 220 VAC25120022885,0002512002282025-12-112026-01-06285,000132601001892026-01-07272026-01-13On time
2511004542025-11-29PERSEDIAAN UMUM6030.1731KAWAT LAS LB 52 Ø 2,6MM26031009344,3002512001882025-12-112025-12-112042,200122603001622026-03-04832025-12-18Late
2511004542025-11-29PERSEDIAAN UMUM6030.1731KAWAT LAS LB 52 Ø 2,6MM26031009344,3002512001882025-12-112025-12-112042,20012–––2025-12-18Overdue
2511004542025-11-29PERSEDIAAN UMUM6030.1957BOR BETON MAKITA HR 24702512001882,535,0002512001882025-12-112025-12-1122,535,00012–––2025-12-18Overdue
2511004542025-11-29PERSEDIAAN UMUM6030.1957BOR BETON MAKITA HR 24702512001882,535,0002512001882025-12-112025-12-1122,535,000122603001622026-03-04832025-12-18Late
2511004542025-11-29PERSEDIAAN UMUM6030.2431GERINDA 4 INCH M0900B MAKITA251200188350,0002512001882025-12-112025-12-114350,00012–––2025-12-18Overdue
← PrevPage 30 of 270Next →Rows per page:1020501005001000