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
2512002052025-12-12PERSEDIAAN UMUM6030.2479DR SHIELD TOP RIDGE SHEET - TW RF 1065 WHITE (NOK)260100950104,504.512512002962025-12-162025-12-16272104,504.5142512008282025-12-2482025-12-23Late
2512002052025-12-12PERSEDIAAN UMUM6030.2477DR SONNE ST MILKY CLEAR 375X6400 MM251200296376,619.822512002962025-12-162025-12-1680376,619.8242601012372026-02-05512025-12-23Late
2512002542025-12-15STATIONERY6010.0029FORM PERMINTAAN BARANG26060002810,0002512003122025-12-162025-12-278010,00012512007142025-12-2262026-01-03On time
2512002562025-12-15PERSEDIAAN UMUM6030.0506CAT BESI / KAYU COKLAT TUA25120031157,472.972512003112025-12-162025-12-29157,472.9712512007012025-12-2262026-01-05On time
2512002562025-12-15PERSEDIAAN UMUM6030.0914THINER A BIASA @1 LTR26040044843,350.452512003112025-12-162025-12-29130,974.7812512007012025-12-2262026-01-05On time
2512002752025-12-16PERSEDIAAN UMUM6050.0111OXYGEN26060017745,0002512003342025-12-162025-12-161090,000–2512006652025-12-2042025-12-23On time
2512100022025-12-01STATIONERY6010.0136SPIDOL MARKER PUTIH MARKER, PUTIH/WHITE26060010813,1002512100802025-12-162025-12-241213,000152512104432025-12-1932025-12-31On time
2512100022025-12-01STATIONERY6010.0127SPIDOL BOARDMARKER HITAM - BOARDMARKER, HITAM/BLACK2606101518,9982512100802025-12-162025-12-24367,300152512104432025-12-1932025-12-31On time
2512100022025-12-01STATIONERY6010.0168GUNTING SEDANG2606000276,2002512100802025-12-162025-12-2438,000152512104432025-12-1932025-12-31On time
2512100102025-12-03STATIONERY6010.0723REFIL TINTA PRINTER MERAH (GI-71 MAGENTA) UNTUK PRINTER CANON G477026041023624,9852512100812025-12-162025-12-24181,000132512104962025-12-2482025-12-31On time
2512100302025-12-10STATIONERY6010.074CONTINUOUS FORM 2 PLY 9,5 X 11:1260100718193,0002512100812025-12-162025-12-242156,00062512104962025-12-2482025-12-31On time
2512100342025-12-10BAHAN BAKAR4030.0022HYDRAULIC OIL ISO-VG68 IDEMITSU26031002834,0002512100682025-12-162025-12-1827,104,00062512105132025-12-2482025-12-25On time
2512100342025-12-10BAHAN BAKAR4040.0036DIFFERENTIAL / GARDAN SAE 85W-90 IDEMITSU2512100689,373,4002512100682025-12-162025-12-1829,373,40062512104262025-12-1932025-12-25On time
2512100342025-12-10BAHAN BAKAR4040.0034ENGINE OIL SAE 15 W - 40 API CH4 IDEMITSU26031002837,5002512100682025-12-162025-12-1827,601,80062512104262025-12-1932025-12-25On time
2512100392025-12-13PERSEDIAAN UMUM6030.2485PLAT BAJA TEBAL 2MM251210071470,4002512100712025-12-162025-12-1635470,40032512104312025-12-1932025-12-23On time
2512100392025-12-13PERSEDIAAN UMUM6030.2486PLAT STRIP BAJA TEBAL 3MM L=40MM PANJANG 6 METER25121007163,0002512100712025-12-162025-12-162063,00032512104312025-12-1932025-12-23On time
2512100392025-12-13PERSEDIAAN UMUM6030.2487SIKU 40MM TEBAL 3MM PANJANG 6METER260110154140,0002512100752025-12-162025-12-1625150,00032512104402025-12-1932025-12-23On time
2512100402025-12-15BAHAN BAKU GLAZE1020.002683 MATERIAL CERAMIC ENGOBE2512100741.192512100742025-12-162025-12-1628,0001.1912512104322025-12-1932025-12-23On time
2512100462025-12-15PERSEDIAAN UMUM6050.0954SAVER A-22626061012665,0002512100922025-12-162025-12-251565,00012512104422025-12-1932026-01-01On time
2511004212025-11-28PERSEDIAAN UMUM6030.2425PLAT KUNINGAN TEBAL 0.1MM X 365 X 1200MM251200399117,117.122512003992025-12-172025-12-172117,117.12192601005032026-01-15292025-12-24Late
2511004212025-11-28PERSEDIAAN UMUM6030.2424PLAT KUNINGAN TEBAL 0.06MM X 365 X 1200MM25120039972,072.072512003992025-12-172025-12-17272,072.07192601005032026-01-15292025-12-24Late
2511100822025-11-24PERSEDIAAN UMUM6020.0656ROTOR GBH220 3611 BAG MERK:BOSCH260110387240,0002512100842025-12-172025-12-262240,000232512104892025-12-2472026-01-02On time
2511100822025-11-24PERSEDIAAN UMUM6030.1951EMBER COR 18"26031007616,0002512100842025-12-172025-12-261016,000232512104892025-12-2472026-01-02On time
2511100822025-11-24PERSEDIAAN UMUM6030.2418TEKIRO TAP AND DIES GT-TD1726 1SET(40PCS)251210084390,0002512100842025-12-172025-12-261390,000232512104892025-12-2472026-01-02On time
2511100942025-11-26PERSEDIAAN UMUM6050.1164TRACK BELT 10 MTR (5 TON)260610182245,7002512100942025-12-172025-12-1710122,000212512105312025-12-27102025-12-24Late
2511100972025-11-28PERSEDIAAN UMUM6030.0197ELBOW GALVANIS 1 INCH26010020614,054.052512100882025-12-172025-12-261215,000192512104852025-12-2472026-01-02On time
2511100972025-11-28PERSEDIAAN UMUM6030.1712ELBOW GALVANIS 3/4 INCH25121008810,5002512100882025-12-172025-12-261210,500192512104852025-12-2472026-01-02On time
2511100972025-11-28PERSEDIAAN UMUM6030.2427WATER MUR GALVANIS 3/4 INCH25121008930,0002512100892025-12-172025-12-26430,000192512104862025-12-2472026-01-02On time
2511100972025-11-28PERSEDIAAN UMUM6020.0659CARBON BRUSH (BOSCH) GWS 70026041006220,0002512100852025-12-172025-12-261020,000192512104842025-12-2472026-01-02On time
2511100972025-11-28PERSEDIAAN UMUM6020.0658SAKLAR GERINDA MERK : BOSCH GWS-70026011006918,5002512100852025-12-172025-12-26518,500192512104842025-12-2472026-01-02On time
2511100992025-11-29PERSEDIAAN UMUM6030.2433BAUT M14 X 100MM2512100835,0002512100832025-12-172025-12-262005,000182512104532025-12-2252026-01-02On time
2511100992025-11-29PERSEDIAAN UMUM6030.2322FLANGE BESI 3 INCH251210083120,0002512100832025-12-172025-12-2640120,000182512104532025-12-2252026-01-02On time
2512000072025-12-01SPAREPART5023.1501FLOATING GRID HONEY COMB FOR PH 302025120031921,000,0002512003192025-12-172026-01-20121,000,000162601008152026-01-23372026-01-27On time
2512000072025-12-01SPAREPART5023.15FLOATING GRID HONEY COMB FOR PH 200025120031914,000,0002512003192025-12-172026-01-20114,000,000162601008152026-01-23372026-01-27On time
2512000712025-12-01BAHAN BAKU GLAZE1020.0023HIGH COE TITANIUM FRIT K-086326060004210,028.752512003532025-12-172025-12-27110,0009,322.5162512010182025-12-31142026-01-03On time
2512000712025-12-01BAHAN BAKU GLAZE1020.0023HIGH COE TITANIUM FRIT K-086326060004210,028.752512003532025-12-172025-12-27110,0009,322.5162512010402025-12-31142026-01-03On time
2512000712025-12-01BAHAN BAKU GLAZE1020.0023HIGH COE TITANIUM FRIT K-086326060004210,028.752512003532025-12-172025-12-27110,0009,322.5162512007972025-12-2362026-01-03On time
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512100782025-12-172025-12-251,00041,000152601101182026-01-08222026-01-01Late
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512100782025-12-172025-12-251,00041,000152512106222025-12-31142026-01-01On time
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512100782025-12-172025-12-251,00041,000152601102612026-01-14282026-01-01Late
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512100782025-12-172025-12-251,00041,000152601100542026-01-06202026-01-01Late
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512100782025-12-172025-12-251,00041,000152512103932025-12-1922026-01-01On time
2512100102025-12-03PERSEDIAAN UMUM6050.0732FIXED CASTER Ø 4 INCHI NYLON25121008675,0002512100862025-12-172025-12-26475,000142512104902025-12-2472026-01-02On time
2512100102025-12-03PERSEDIAAN UMUM6050.1169STAMPING PUNCH (ALAT KETOK HURUF & ANGKA) 6MM251210086185,0002512100862025-12-172025-12-261185,000142512104902025-12-2472026-01-02On time
2512100102025-12-03PERSEDIAAN UMUM6050.0405GERINDA TANGAN 4 INCH MAKITA M0900B260410119337,837.842512100862025-12-172025-12-261347,000142512104902025-12-2472026-01-02On time
2512100102025-12-03PERSEDIAAN UMUM6050.073SWEVEL CASTER Ø 6 INCHI NYLON25121008690,0002512100862025-12-172025-12-26490,000142512104902025-12-2472026-01-02On time
2512100222025-12-08PERSEDIAAN UMUM6050.0298CHAIN LUBE26060016939,1002512100902025-12-172025-12-26545,00092512104872025-12-2472026-01-02On time
2512100222025-12-08PERSEDIAAN UMUM6030.1843GERINDA AMPLAS 4 INCH2604102057,5002512100872025-12-172025-12-26507,50092512104882025-12-2472026-01-02On time
2512100302025-12-10PERSEDIAAN UMUM6050.0737LPG 12Kg ( Refill )260610118230,0002512100912025-12-172025-12-261190,00072601109162026-02-16612026-01-02Late
2512100382025-12-13SPAREPART5011.0281BEARING UCP 208260400010180,5002512100792025-12-172025-12-25558,31042601101162026-01-08222026-01-01Late
2512100382025-12-13SPAREPART5011.0282BEARING UCP 209260500470194,0002512100792025-12-172025-12-25580,20042601101162026-01-08222026-01-01Late
2512100492025-12-16SPAREPART5011.0279BEARING UCP 206260400546120,3002512100792025-12-172025-12-251036,68512601101162026-01-08222026-01-01Late
2511100802025-11-24SPAREPART5027.0438HYDRAULIC HOSE 400MM, WITH FEMALE THREADED FITTING, OUTER DIAMETER Ø25251210100210,0002512101002025-12-182025-12-2612210,000242512104542025-12-2242026-01-02On time
2511100822025-11-24PERSEDIAAN UMUM6030.195SENDOK TEMBOK MODEL LANCIP 7 INCH26041021011,5922512100972025-12-182025-12-261016,880242512104982025-12-2462026-01-02On time
2511100992025-11-29PERSEDIAAN UMUM6060.021MUR M 142605004641,0502512100962025-12-182025-12-26200900192512104932025-12-2462026-01-02On time
2512000742025-12-03PERSEDIAAN UMUM6020.0103KABEL NYAF 1X0.75 MM260600150303,603.62512003322025-12-182025-12-182220,720.72152512008252025-12-2462025-12-25On time
2512000742025-12-03PERSEDIAAN UMUM6020.0666KABEL NYYHY 10X1.5 MM25120033260,7442512003322025-12-182025-12-1820060,744152512008252025-12-2462025-12-25On time
2512000742025-12-03PERSEDIAAN UMUM6020.0665KABEL NYAF 4X2.5 MM26010023834,1002512003322025-12-182025-12-181,50027,699152601003412026-01-12252025-12-25Late
2512000742025-12-03PERSEDIAAN UMUM6020.0665KABEL NYAF 4X2.5 MM26010023834,1002512003322025-12-182025-12-181,50027,699152512008252025-12-2462025-12-25On time
2512001172025-12-08BAHAN PACKING3011.0235BOX PARIS BK TS KW 1 50X502606001201,4592512003242025-12-182026-01-2050,0001,227102512010302025-12-31132026-01-27On time
2512001172025-12-08BAHAN PACKING3011.002BOX PARIS COKLAT TS 50*50 KW II2605003821,4592512003242025-12-182026-01-2015,0001,227102512010302025-12-31132026-01-27On time
2512001272025-12-06STATIONERY6010.0041FORM CATATAN PENYEBAB LINE STOP FR-PROD-18 A4, FR-PROD-1826060025512,0002512003442025-12-182025-12-301012,500122512007752025-12-2352026-01-06On time
2512001272025-12-06STATIONERY6010.0042FORM DAFTAR PEMERIKSAAN UKURAN BARANG JADI DAFTAR PEMERIKSAAN UKURAN BARANG JADI,A426060025512,0002512003442025-12-182025-12-301012,500122512007752025-12-2352026-01-06On time
2512001272025-12-06STATIONERY6010.0039FORM GLAZING LINE CONTROL REPORT FR-PROD-04 A4, FR-PROD-0426050039412,0002512003442025-12-182025-12-301012,500122512007752025-12-2352026-01-06On time
2512001272025-12-06STATIONERY6010.0052FORM DAFTAR PEMERIKSAAN MUTU HASIL PRESS26040015712,5002512003442025-12-182025-12-301012,500122512007752025-12-2352026-01-06On time
2512001272025-12-06STATIONERY6010.0053FORM PEMAKAIAN GLAZE DAN ENGOBE26040015710,0002512003442025-12-182025-12-302010,000122512007752025-12-2352026-01-06On time
2512001272025-12-06STATIONERY6010.0094DAFTAR LAPORAN HARIAN KELOMPOK SORTIR FR-PROD-12 REV 0026050039412,0002512003442025-12-182025-12-301012,500122512007752025-12-2352026-01-06On time
2512001272025-12-06STATIONERY6010.0109FORM TEST BODY / SIZE (KILN-PRESS) FR-PRO-03 REV 0226040015712,5002512003442025-12-182025-12-301012,500122512007752025-12-2352026-01-06On time
2512001312025-12-06PERSEDIAAN UMUM6020.0521SENTER LED RECHARGEABLE260300329145,3452512003452025-12-182025-12-241201,323122512007402025-12-2242025-12-31On time
2512001542025-12-09FIXED ASSETSAST02521SCAFFOLDING251200340427,927.932512003402025-12-182025-12-1810427,927.939–––2025-12-25Overdue
2512001682025-12-10PERSEDIAAN UMUM6020.068FLASHDISK 128 GB (SANDISK)260100361170,5002512003492025-12-182025-12-261189,20082512007392025-12-2242026-01-02On time
2512001722025-12-10PERSEDIAAN UMUM6020.0371SAKLAR SERI SCHNEIDER VIVACE260101158125,0002512003312025-12-182025-12-187125,00082512007192025-12-2242025-12-25On time
2512001722025-12-10PERSEDIAAN UMUM6020.0372SAKLAR TUNGGAL SCHNEIDER VIVACE26030031724,5002512003312025-12-182025-12-18490,00082512007192025-12-2242025-12-25On time
2512002092025-12-12SPAREPART5017.0209PILOT LAMP SCHNEIDER HIJAU 220 VAC26010036950,0002512003302025-12-182025-12-183050,00062512007742025-12-2352025-12-25On time
2512002092025-12-12SPAREPART5017.0208PILOT LAMP SCHNEIDER MERAH 220 VAC26010044048,0002512003302025-12-182025-12-183050,00062512007742025-12-2352025-12-25On time
2512002092025-12-12SPAREPART5017.0145TELE SELECTOR XB4 BD21260600252122,9002512003302025-12-182025-12-181113,50062512007742025-12-2352025-12-25On time
2512002092025-12-12SPAREPART5017.1019MOTOR PROTECTION SCHNEIDER TYPE GV2ME08260500287490,0002512003312025-12-182025-12-181465,00062512007192025-12-2242025-12-25On time
2512002092025-12-12PERSEDIAAN UMUM6020.0103KABEL NYAF 1X0.75 MM260600150303,603.62512003322025-12-182025-12-182220,720.7262512008252025-12-2462025-12-25On time
2512002092025-12-12SPAREPART5017.0054FUJI CONTACTOR SC 0/220 V260500161220,0002512003302025-12-182025-12-1820215,00062512007742025-12-2352025-12-25On time
2512002092025-12-12SPAREPART5017.034MOTOR PROTECTION SCHNEIDER TYPE GV2ME10260500288545,0002512003312025-12-182025-12-181465,00062512007192025-12-2242025-12-25On time
2512002362025-12-13BAHAN PACKING3011.0233BOX KOBIN BK TS KW 1 50X502606001201,4592512003232025-12-182026-01-2070,0001,22752601002552026-01-09222026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0235BOX PARIS BK TS KW 1 50X502606001201,4592512003232025-12-182026-01-2070,0001,22752601016992026-02-18622026-01-27Late
2512002362025-12-13BAHAN PACKING3011.0234BOX JUPITER BK TS KW 1 50X502605004741,4592512003232025-12-182026-01-2070,0001,22752601002522026-01-09222026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0235BOX PARIS BK TS KW 1 50X502606001201,4592512003232025-12-182026-01-2070,0001,22752601005452026-01-17302026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0233BOX KOBIN BK TS KW 1 50X502606001201,4592512003232025-12-182026-01-2070,0001,22752601003262026-01-12252026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0234BOX JUPITER BK TS KW 1 50X502605004741,4592512003232025-12-182026-01-2070,0001,22752601002552026-01-09222026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0235BOX PARIS BK TS KW 1 50X502606001201,4592512003232025-12-182026-01-2070,0001,22752601009652026-01-28412026-01-27Late
2512002362025-12-13BAHAN PACKING3011.0236BOX MY BK TS KW 1 50X502605004741,4592512003232025-12-182026-01-2070,0001,22752601009652026-01-28412026-01-27Late
2512002362025-12-13BAHAN PACKING3011.0014BOX KOBIN COKLAT TS 50*50 KW II2606001201,4592512003232025-12-182026-01-2020,0001,22752601006882026-01-21342026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0236BOX MY BK TS KW 1 50X502605004741,4592512003232025-12-182026-01-2070,0001,22752601010532026-01-29422026-01-27Late
2512002362025-12-13BAHAN PACKING3011.0018BOX JUPITER COKLAT TS 50*50 KW II2605003821,4592512003232025-12-182026-01-2020,0001,2275–––2026-01-27Overdue
2512002362025-12-13BAHAN PACKING3011.0236BOX MY BK TS KW 1 50X502605004741,4592512003232025-12-182026-01-2070,0001,22752601002552026-01-09222026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0236BOX MY BK TS KW 1 50X502605004741,4592512003232025-12-182026-01-2070,0001,22752601004922026-01-15282026-01-27On time
2512002362025-12-13BAHAN PACKING3011.002BOX PARIS COKLAT TS 50*50 KW II2605003821,4592512003232025-12-182026-01-2040,0001,2275–––2026-01-27Overdue
2512002362025-12-13BAHAN PACKING3011.014BOX MY COKLAT TS 50*50 KW II2603004441,3192512003232025-12-182026-01-2020,0001,2275–––2026-01-27Overdue
2512002362025-12-13BAHAN PACKING3011.0025BOX KOBIN HITAM TS 50*50 KW III2606001201,4592512003232025-12-182026-01-2030,0001,2275–––2026-01-27Overdue
2512002362025-12-13BAHAN PACKING3011.0237BOX KAISAR BK TS KW 1 50X502512003231,2272512003232025-12-182026-01-2040,0001,2275–––2026-01-27Overdue
2512002372025-12-13BAHAN PACKING3011.0043BOX KOBIN T.S KW 1 30X302604004001,1772512003222025-12-182026-01-10120,00095152512010312025-12-31132026-01-17On time
2512002372025-12-13BAHAN PACKING3011.0047BOX KOBIN HIJAU T.S KW 2 30X302512003229512512003222025-12-182026-01-1036,00095152512009742025-12-30122026-01-17On time
2512002372025-12-13BAHAN PACKING3011.0048BOX KOBIN HITAM T.S KW 3 30X302605003821,1772512003222025-12-182026-01-1036,00095152512009742025-12-30122026-01-17On time
← PrevPage 19 of 135Next →Rows per page:1020501005001000