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
2512004042025-12-23SPAREPART5012.0075SEAL TC 30.42.72604005306,0002512005292025-12-292026-01-15205,00062601001852026-01-0792026-01-22On time
2512004082025-12-26PERSEDIAAN UMUM6050.0034LPG 50 KG2606001661,300,0002512005162025-12-292025-12-2911,000,00032601000602026-01-0242026-01-05On time
2512004132025-12-26SPAREPART5019.0111GEAR REDUCER MNRV 063 R 1:30 (FLANGE 0.75 KW B14)2605001934,500,0002512005302025-12-292026-01-1524,500,00032601001832026-01-0792026-01-22On time
2512004132025-12-26SPAREPART5019.0045MOTOR 3 PHASE B5 0.75 KW 1HP 1460 RPM 220/380 V FLANGE MOUNTING2601010471,187,5002512005302025-12-292026-01-1511,187,50032601001832026-01-0792026-01-22On time
2512004132025-12-26SPAREPART5019.0006MOTOR 0.37KW 0.5HP 1460 RPM 380V FLANGE B5260500136875,0002512005302025-12-292026-01-152875,00032601001832026-01-0792026-01-22On time
2512004132025-12-26SPAREPART5030.067MOTOR 0.75 KW 1 HP 1460 RPM 380 V B142605001361,187,5002512005302025-12-292026-01-1521,187,50032601001832026-01-0792026-01-22On time
2512004182025-12-26PERSEDIAAN UMUM6030.0499CAT BESI TAHAN PANAS HITAM260100681220,0002512005262025-12-292026-01-155220,00032601001012026-01-0572026-01-22On time
2512004182025-12-26PERSEDIAAN UMUM6030.0488CAT BESI TAHAN PANAS SILVER251200526200,0002512005262025-12-292026-01-155200,00032601001012026-01-0572026-01-22On time
2512004342025-12-26PERSEDIAAN UMUM6030.2014DR SHIELD SINGLE WALL OD 880 GRECA WHITE TEBAL=1.2MM LE=880MM P=4M251200519161,441.442512005192025-12-292025-12-2914161,441.4432601000922026-01-0572026-01-05On time
2512004352025-12-29SPAREPART5017.1056HANNOCHS NEW SIGNBOARD HFH LED 100W CDL260110359178,180.092512005022025-12-292026-01-053179,180.09––––2026-01-12Overdue
2512004352025-12-29SPAREPART5017.1058HANNOCHS SATELLITE LED 100W CDL260110359359,291.712512005022025-12-292026-01-0518359,291.71––––2026-01-12Overdue
2512100052025-12-01BAHAN BAKU GLAZE1020.0024CERAMICS ENGOBE HIGH TRANSLUCENT 1# POWDER2601100280.752512101492025-12-292025-12-2956,0000.754282601103022026-01-17192026-01-05Late
2512100172025-12-04SPAREPART5032.136DONG AH FLAP 23.5-25260410188960,0002512101432025-12-292025-12-311960,000252512106252025-12-3122026-01-07On time
2512100172025-12-04SPAREPART5032.1358TECHKING TYRE 23.5-25 20PR T/L26041018915,500,0002512101472025-12-292025-12-31115,500,000252601107192026-02-09422026-01-07Late
2512100172025-12-04SPAREPART5032.1359DONG AH TUBE 23.5-252604101881,440,0002512101432025-12-292025-12-3121,440,000252512106252025-12-3122026-01-07On time
2512100612025-12-19PERSEDIAAN UMUM6030.2503CNP 125x2.6x6000mm260110055300,0002512101452025-12-292025-12-2960300,000102601101042026-01-08102026-01-05Late
2512100612025-12-19PERSEDIAAN UMUM6030.1943BESI SIKU 50 X 50 X 5MM 6M260510069223,2002512101452025-12-292025-12-2950270,000102601101122026-01-08102026-01-05Late
2511004012025-11-26FIXED ASSETSAST02490ALAT UKUR KADAR AIR (MOISTURE ANALYZER FD-660)25120052558,500,0002512005252025-12-302025-12-30158,500,00034–––2026-01-06Overdue
2511004012025-11-26FIXED ASSETSAST02490ALAT UKUR KADAR AIR (MOISTURE ANALYZER FD-660)25120052558,500,0002512005252025-12-302025-12-30158,500,000342603001702026-03-04642026-01-06Late
2511004242025-11-28SPAREPART5031.0527OIL PUMP HYDROULIC SHIMADZU GPY-11.5R 00032512005422,850,0002512005422025-12-302026-02-0512,850,000322601008842026-01-26272026-02-12On time
2511004262025-11-28SPAREPART5030.1725CARD MODUL 4 RELAY CONTACT 55275703042512005545,780,4502512005542025-12-302026-02-2015,780,450322603004042026-03-10702026-02-27Late
2512000872025-12-04SPAREPART5023.1505REGULATOR POWER SUPPLY TYPE 2716, 0-30 VDC25120054459,0002512005442025-12-302026-01-10159,000262601000662026-01-0232026-01-17On time
2512000942025-12-04SPAREPART5027.0174REL VANBELT B (BESI) 20X20X3000 MM260101041500,0002512005362025-12-302026-02-0520500,000262601016512026-02-16482026-02-12Late
2512001112025-12-06SPAREPART5030.0232PIN 13.32.828.01251200556222512005562025-12-302026-02-2842224–––2026-03-07Overdue
2512001112025-12-06SPAREPART5030.1763JOINT 2.013.004225120055610.52512005562025-12-302026-02-28410.5242605000722026-05-041252026-03-07Late
2512001112025-12-06SPAREPART5030.0229PULLEY 18.05.00.026.0126040042636.382512005562025-12-302026-02-28237.524–––2026-03-07Overdue
2512001112025-12-06SPAREPART5030.0577REDUCTION GEAR 8QC15312.0004260400426135.82512005562025-12-302026-02-28214024–––2026-03-07Overdue
2512001462025-12-09SPAREPART5030.0768PIN 8Q12230014625120055822.112512005582025-12-302026-05-30422.11212605009272026-05-281492026-06-06On time
2512001462025-12-09SPAREPART5030.0728BUSHING 8Q200300212512005570.42512005572025-12-302026-02-28100.4212605000742026-05-041252026-03-07Late
2512001462025-12-09SPAREPART5030.0275GUIDE 180500313251200558193.052512005582025-12-302026-05-304193.05212605009272026-05-281492026-06-06On time
2512001462025-12-09SPAREPART5030.0586FORK 8Q2012000525120055722512005572025-12-302026-02-2842212605000742026-05-041252026-03-07Late
2512001462025-12-09SPAREPART5030.0552MAGNETIC SENSOR 8QC20443.0034 EX-8QC20443.000825120055823.492512005582025-12-302026-05-30423.49212605009272026-05-281492026-06-06On time
2512001462025-12-09SPAREPART5030.0635VACUM SWITCH 2055001625120055766.62512005572025-12-302026-02-28466.6212605000742026-05-041252026-03-07Late
2512001462025-12-09SPAREPART5030.0294STAINLESS STEEL PLATE FOR PRINTER 8QC55001.5014 EX-28500007RIC2512005571112512005572025-12-302026-02-28211121–––2026-03-07Overdue
2512001462025-12-09SPAREPART5030.0291SPRING 8Q28500016RIC2512005581.312512005582025-12-302026-05-30101.31212605009272026-05-281492026-06-06On time
2512001462025-12-09SPAREPART5030.0512WASHER 8Q28490006RIC2512005576.82512005572025-12-302026-02-28106.821–––2026-03-07Overdue
2512001462025-12-09SPAREPART5030.0287PRINT HEAD 8Q8000135251200558884.522512005582025-12-302026-05-301884.52212605009272026-05-281492026-06-06On time
2512001472025-12-09SPAREPART5030.0714CONNECTION 8Q1332018S226040042615.042512005572025-12-302026-02-28415.5212605000742026-05-041252026-03-07Late
2512001472025-12-09SPAREPART5030.1335READER 8QE04340.0002260400426552.92512005582025-12-302026-05-301565.11212605009272026-05-281492026-06-06On time
2512001472025-12-09SPAREPART5030.0431LEFT SUPPORT 8Q1332016S22512005572.642512005572025-12-302026-02-28402.64212605000742026-05-041252026-03-07Late
2512001472025-12-09SPAREPART5030.0253CHAIN 13320480026040042672.752512005572025-12-302026-02-28871212605000742026-05-041252026-03-07Late
2512001472025-12-09SPAREPART5030.0713CONNECTION 8Q1332018D226040042615.042512005572025-12-302026-02-28415.5212605000742026-05-041252026-03-07Late
2512001472025-12-09SPAREPART5030.1768PIN 8QC00116.00012512005581.232512005582025-12-302026-05-30201.23212605009272026-05-281492026-06-06On time
2512001472025-12-09SPAREPART5030.0716ROLLER 8Q1332207012512005572.522512005572025-12-302026-02-28102.52212605000742026-05-041252026-03-07Late
2512001512025-12-09SPAREPART5029.0098SPRING (ELASTIC JOINT) RK-200-13-10272512005580.522512005582025-12-302026-05-301,0000.52212604002092026-04-08992026-06-06On time
2512001512025-12-09SPAREPART5029.0452BEARING D.58X10 RK-240-13-003025120055722512005572025-12-302026-02-28200221–––2026-03-07Overdue
2512002032025-12-12PERSEDIAAN UMUM6050.1175BRACKET TV STANDING 65 INCH251200550800,0002512005502025-12-302025-12-301800,000182601006022026-01-19202026-01-06Late
2512002222025-12-12SPAREPART5030.1772SWITCHING POWER SUPPLY 785205030125120055423,408,1162512005542025-12-302026-02-20123,408,116182603004042026-03-10702026-02-27Late
2512002282025-12-12SPAREPART5030.1777LINEAR BEARING 90000749251200554821,7992512005542025-12-302026-02-204821,799182601010142026-01-29302026-02-27On time
2512002282025-12-12SPAREPART5030.178FTC TASTEGGIO 0.08M 24V O8H222 IFM 700043002512005542,017,3542512005542025-12-302026-02-2082,017,354182603010092026-03-31912026-02-27Late
← PrevPage 53 of 270Next →Rows per page:1020501005001000