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
2512003192025-12-19BAHAN BAKU BODY1010.0007FELDSPAR (RGS-2)2605002842842512004072025-12-222026-01-203,500,00026932601012752026-02-06462026-01-27Late
2512003192025-12-19BAHAN BAKU BODY1010.0007FELDSPAR (RGS-2)2605002842842512004072025-12-222026-01-203,500,00026932601013272026-02-07472026-01-27Late
2512003192025-12-19BAHAN BAKU BODY1010.0007FELDSPAR (RGS-2)2605002842842512004072025-12-222026-01-203,500,00026932601005132026-01-15242026-01-27On time
2512003192025-12-19BAHAN BAKU BODY1010.0007FELDSPAR (RGS-2)2605002842842512004072025-12-222026-01-203,500,00026932601002212026-01-08172026-01-27On time
2512003192025-12-19BAHAN BAKU BODY1010.0007FELDSPAR (RGS-2)2605002842842512004072025-12-222026-01-203,500,00026932601003632026-01-13222026-01-27On time
2512003192025-12-19BAHAN BAKU BODY1010.0007FELDSPAR (RGS-2)2605002842842512004072025-12-222026-01-203,500,00026932601005672026-01-19282026-01-27On time
2512003212025-12-19BAHAN BAKU BODY1098.0005WATERGLASS (SODIUM SILICATE)2605004162,6502512004042025-12-222026-01-30180,0002,33032601008472026-01-26352026-02-06On time
2512003212025-12-19BAHAN BAKU BODY1098.0005WATERGLASS (SODIUM SILICATE)2605004162,6502512004042025-12-222026-01-30180,0002,33032601003652026-01-13222026-02-06On time
2512003212025-12-19BAHAN BAKU BODY1098.0005WATERGLASS (SODIUM SILICATE)2605004162,6502512004042025-12-222026-01-30180,0002,33032512010372025-12-3192026-02-06On time
2512003212025-12-19BAHAN BAKU BODY1098.0005WATERGLASS (SODIUM SILICATE)2605004162,6502512004042025-12-222026-01-30180,0002,33032601001472026-01-06152026-02-06On time
2512003212025-12-19BAHAN BAKU BODY1098.0005WATERGLASS (SODIUM SILICATE)2605004162,6502512004042025-12-222026-01-30180,0002,33032601010392026-01-29382026-02-06On time
2512003212025-12-19BAHAN BAKU BODY1098.0005WATERGLASS (SODIUM SILICATE)2605004162,6502512004042025-12-222026-01-30180,0002,33032601005712026-01-19282026-02-06On time
2512003232025-12-19PERSEDIAAN UMUM6050.0111OXYGEN26060017745,0002512005042025-12-222025-12-221090,00032512009652025-12-3082025-12-29Late
2512003342025-12-19PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232512004202025-12-222025-12-305057,472.9732512008792025-12-2642026-01-06On time
2512003342025-12-19PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232512004202025-12-222025-12-305057,472.9732512009882025-12-3082026-01-06On time
2512003492025-12-20PERSEDIAAN UMUM6050.0589LPG 12 KG260600005250,0002512004142025-12-222025-12-293210,00022512007912025-12-2312026-01-05On time
2512003522025-12-20PERSEDIAAN UMUM6060.0644BAUT M-18*402512004104,0002512004102025-12-222025-12-221504,00022512008652025-12-2642025-12-29On time
2512003522025-12-20PERSEDIAAN UMUM6060.024RING PLAT M-182605004648052512004102025-12-222025-12-2215041522512008652025-12-2642025-12-29On time
2512003552025-12-19PERSEDIAAN UMUM6030.0004SEMEN GRESIK 40KG26050024159,5002512004112025-12-222025-12-222058,00032512008192025-12-2422025-12-29On time
2512100362025-12-12PERSEDIAAN UMUM6020.07INSULATED EV TYPE TUBE-TYPE TERMINAL LUG (4 MM)25121012417,0002512101242025-12-222026-01-01517,000102512106032025-12-3082026-01-08On time
2512100362025-12-12PERSEDIAAN UMUM6020.0701INSULATED EV TYPE TUBE-TYPE TERMINAL LUG (6 MM)25121012427,0002512101242025-12-222026-01-01227,000102512106032025-12-3082026-01-08On time
2512100372025-12-12PERSEDIAAN UMUM6020.0698INSULATED EV TYPE TUBE-TYPE TERMINAL LUG (1.5 MM)2512101159,0002512101152025-12-222025-12-3159,000102512106042025-12-3082026-01-07On time
2512100372025-12-12PERSEDIAAN UMUM6050.1178CROSS HEAD SELF DRILLING SCREW ST4.8X16251210116118,7502512101162025-12-222025-12-312118,750102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6020.0699INSULATED EV TYPE TUBE-TYPE TERMINAL LUG (2.5 MM)25121011512,0002512101152025-12-222025-12-31512,000102512106042025-12-3082026-01-07On time
2512100372025-12-12PERSEDIAAN UMUM6050.1181ELECTRIC SCREWDRIVER CROSS HEAD PH3251210116123,5002512101162025-12-222025-12-3110123,500102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6020.0695INSULATED RV TYPE O-TYPE TERMINAL LUG (RV2-6.3)25121011542,0002512101152025-12-222025-12-31342,000102512106042025-12-3082026-01-07On time
2512100372025-12-12PERSEDIAAN UMUM6020.0696INSULATED RV TYPE O-TYPE TERMINAL LUG (RV5.5-8)25121011586,5002512101152025-12-222025-12-31386,500102512106042025-12-3082026-01-07On time
2512100372025-12-12PERSEDIAAN UMUM6050.1179ELECTRIC SCREWDRIVER CROSS HEAD PH125121011684,5502512101162025-12-222025-12-311084,550102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6050.118ELECTRIC SCREWDRIVER CROSS HEAD PH225121011699,7502512101162025-12-222025-12-311099,750102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6020.0697INSULATED EV TYPE TUBE-TYPE TERMINAL LUG (1 MM)2512101158,5002512101152025-12-222025-12-3158,500102512106042025-12-3082026-01-07On time
2512100372025-12-12PERSEDIAAN UMUM6020.0703DIN RAIL (T35)25121011623,7502512101162025-12-222025-12-313023,750102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6050.1182LABEL PRINTING (YELLOW) 9MM FOR PUTY PT101025121011671,2502512101162025-12-222025-12-312071,250102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6050.1183LABEL PRINTING (YELLOW) 12MM FOR PUTY PT101025121011685,5002512101162025-12-222025-12-312085,500102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6020.0688AXIAL FAN 120MMX120MM AC220 VOLT260110129114,0002512101162025-12-222025-12-3115114,000102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6020.0707TUBE MARKER 0.5MM251210116134,9002512101162025-12-222025-12-311134,900102601100802026-01-08172026-01-07Late
2512100572025-12-19BAHAN BAKU GLAZE1030.0082CERAMICS GLAZE ANTI SLIP 9152603101071.552512101122025-12-222025-12-2212,0001.5532601105562026-01-30392025-12-29Late
2511003022025-11-22BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502512004282025-12-232026-01-1550,0006,650312601003692026-01-13212026-01-22On time
2511003022025-11-22BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502512004282025-12-232026-01-1550,0006,650312601004222026-01-13212026-01-22On time
2511003382025-11-21SPAREPART5023.0862PULLY TIMMING H 100 T16260100411420,0002512004512025-12-232026-01-155425,000322601001972026-01-07152026-01-22On time
2511004402025-11-28PERSEDIAAN UMUM6030.2066BESI HOLLOW 50X50X6MX2MM260510178278,0002512004662025-12-232025-12-2330177,477.4825–––2025-12-30Overdue
2512000372025-12-01PERSEDIAAN UMUM6030.187BESI HOLLOW 40X60X2MMX6M260400315235,135.142512004662025-12-232025-12-2320177,477.4822–––2025-12-30Overdue
2512000402025-12-01SPAREPART5030.1729CUSCINETTO RADIALE A SFERE 6201 2RS (12X32X10) 921110120125120041625,0002512004162025-12-232025-12-23425,000222603000012026-03-02692025-12-30Late
2512000412025-12-01SPAREPART5030.007CUS RADIATE A SFERA ASS C 921110080025120041613,5002512004162025-12-232025-12-235013,500222603000012026-03-02692025-12-30Late
2512000552025-12-03PERSEDIAAN UMUM6030.0899PLAT BESI 20X1200X2400 MM2512004384,459,639.642512004382025-12-232025-12-2334,459,639.64202512008692025-12-2632025-12-30On time
2512000552025-12-03PERSEDIAAN UMUM6030.0433PLAT BESI 1X1200X2400 MM260410045313,6002512004382025-12-232025-12-233256,756.76202512008692025-12-2632025-12-30On time
2512000552025-12-03PERSEDIAAN UMUM6030.0167PIPA GALVANIS MEDIUM SNI 2 INCH260300096629,729.732512004662025-12-232025-12-234556,756.7620–––2025-12-30Overdue
2512001072025-12-06PERSEDIAAN UMUM6030.2463NIKKO STEEL NS STAINCLEAN @1KG251200432133,333.332512004322025-12-232025-12-2310133,333.33172601003542026-01-12202025-12-30Late
2512001072025-12-06PERSEDIAAN UMUM6030.2463NIKKO STEEL NS STAINCLEAN @1KG251200432133,333.332512004322025-12-232025-12-2310133,333.33172601004022026-01-13212025-12-30Late
2512001282025-12-06SPAREPART5031.0958SCREW, SELF TAPPING (1-J)25120046376,5002512004632025-12-232025-12-236076,500172601004542026-01-14222025-12-30Late
2512001282025-12-06SPAREPART5031.0957MUFFLER (1-F)260400293135,0002512004632025-12-232025-12-2315135,000172601004542026-01-14222025-12-30Late
2512001282025-12-06SPAREPART5031.0956CAP, MUFFLER (1-D)251200463180,0002512004632025-12-232025-12-2315180,000172601004542026-01-14222025-12-30Late
2512001902025-12-11PERSEDIAAN UMUM6030.0466CAT KAYU/ BESI HITAM26010016357,472.972512004392025-12-232025-12-30257,472.97122512009322025-12-2962026-01-06On time
2512001902025-12-11PERSEDIAAN UMUM6030.0914THINER A BIASA26040044843,350.452512004392025-12-232025-12-30530,976.58122512009322025-12-2962026-01-06On time
2512001902025-12-11PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232512004392025-12-232025-12-301257,472.97122512009892025-12-3072026-01-06On time
2512001902025-12-11PERSEDIAAN UMUM6030.052CAT BESI / KAYU AVIAN TWILIGHT BLUE 73126010069257,472.972512004392025-12-232025-12-30257,472.97122512009322025-12-2962026-01-06On time
2512001932025-12-11PERSEDIAAN UMUM6030.002PLAT BESI 10X1200X2400MM2603002782,285,585.592512004382025-12-232025-12-23102,046,621.62122512008692025-12-2632025-12-30On time
2512001942025-12-11PERSEDIAAN UMUM6050.0591PLAT CARBON STEEL 3MM X 1200MM X 2400MM260600189781,981.982512004382025-12-232025-12-2320633,783.78122512008692025-12-2632025-12-30On time
2512001952025-12-11PERSEDIAAN UMUM6030.0166KAWAT LAS RB 26 2.6 MM26060001333,333.332512004612025-12-232025-12-2320029,009.01122512008672025-12-2632025-12-30On time
2512001952025-12-11PERSEDIAAN UMUM6030.0917THINER A BIASA @ 5 LTR26050040363,5002512004362025-12-232025-12-2310132,525.23122512009922025-12-3072025-12-30On time
2512001982025-12-11PERSEDIAAN UMUM6020.0521SENTER LED RECHARGEABLE260300329145,3452512004532025-12-232025-12-301154,700122512008942025-12-2632026-01-06On time
2512002062025-12-12PERSEDIAAN UMUM6050.0006SHOWER MANDI251200433170,0002512004332025-12-232025-12-234170,000112512008612025-12-2632025-12-30On time
2512002072025-12-12SPAREPART5017.1014LAMPU LED 4 W25120043334,0002512004332025-12-232025-12-23334,000112512008612025-12-2632025-12-30On time
2512002142025-12-12PERSEDIAAN UMUM6050.0112AIR AKI 1500 ML26040000510,0002512004592025-12-232025-12-29128,000112512008952025-12-2632026-01-05On time
2512002462025-12-13PERSEDIAAN UMUM6030.0488CAT BESI TAHAN PANAS SILVER251200526200,0002512004642025-12-232026-01-102071,171102601000982026-01-05132026-01-17On time
2512002462025-12-13PERSEDIAAN UMUM6030.1609CAT BESI SILVER25120046253,689.192512004622025-12-232025-12-302053,689.19102512009862025-12-3072026-01-06On time
2512002512025-12-15PERSEDIAAN UMUM6030.2492PIPA FREON AC 1.5 PK251200467135,0002512004672025-12-232025-12-235135,00082601008382026-01-24322025-12-30Late
2512002512025-12-15PERSEDIAAN UMUM6030.1581PIPA FREON AC 1 PK (1/4,3/8)251200467125,0002512004672025-12-232025-12-235125,00082601008382026-01-24322025-12-30Late
2512002552025-12-15PERSEDIAAN UMUM6020.0048JAM DINDING26050003560,0002512004482025-12-232025-12-30188,00082512009032025-12-2632026-01-06On time
2512002992025-12-17PERSEDIAAN UMUM6050.0313AIR MINERAL BOTOL KECIL 220 ML26060024819,819.822512004572025-12-232025-12-271019,369.3762512009042025-12-2632026-01-03On time
2512002992025-12-17PERSEDIAAN UMUM6010.0351AIR MINERAL GALON26060024818,018.022512004572025-12-232025-12-273017,567.5762512009042025-12-2632026-01-03On time
2512003062025-12-18FIXED ASSETSAST02552KURSI MD251200437505,0682512004372025-12-232026-01-108505,0685–––2026-01-17Overdue
2512003062025-12-18FIXED ASSETSAST02551Meja Meeting 240x110 MD2512004371,948,0502512004372025-12-232026-01-1041,948,0505–––2026-01-17Overdue
2512003062025-12-18FIXED ASSETSAST02550Meja Kerja 120x60 MD251200437316,8752512004372025-12-232026-01-102316,8755–––2026-01-17Overdue
2512003322025-12-19STATIONERY6010.0118FORM SURAT TIMBANG KENDARAAN2605002732,7502512004602025-12-232026-01-051604,00042512009782025-12-3072026-01-12On time
2512003322025-12-19STATIONERY6010.0017COUNTUNOUS FORM 3 PLY : 2251200449460,7002512004492025-12-232025-12-306460,70042512009802025-12-3072026-01-06On time
2512003332025-12-19PROMOSI6010.0755BARCODE ANDARA BEIGE251200456252512004562025-12-232025-12-302,0002542512009942025-12-3072026-01-06On time
2512003332025-12-19PROMOSI6010.0754BARCODE ANDARA GREY251200456252512004562025-12-232025-12-302,0002542512009942025-12-3072026-01-06On time
2512003332025-12-19PROMOSI6010.0757BARCODE ANDARA GREEN251200456252512004562025-12-232025-12-302,0002542512009942025-12-3072026-01-06On time
2512003332025-12-19PROMOSI6010.0753STICKER PS MARK ANDARA SERIES ( 30X30 ) DECOARTS FILIPINA251200456852512004562025-12-232025-12-308,0008542512009942025-12-3072026-01-06On time
2512003332025-12-19PROMOSI6010.0756BARCODE ANDARA BLUE251200456252512004562025-12-232025-12-302,0002542512009942025-12-3072026-01-06On time
2512003362025-12-19SPAREPART5032.009MINYAK REM 1000 ML26050033360,0002512004552025-12-232025-12-301260,00042512009202025-12-2962026-01-06On time
2512003362025-12-19SPAREPART5032.0155DOP HALOGEN H3 24V/70 W25120043135,135.142512004312025-12-232025-12-302035,135.1442512009822025-12-3072026-01-06On time
2512003382025-12-19SPAREPART5027.0445MARTIN PULLY SPB 200 - 4 TAPER BUSH 3020 - 422601001931,600,0002512004402025-12-232026-01-17121,600,00042601001962026-01-07152026-01-24On time
2512003382025-12-19SPAREPART5027.0427MARTIN PULLY SPB 125 - 4 TAPER BUSH 2012 - 48260100193600,0002512004402025-12-232026-01-1710600,00042601001962026-01-07152026-01-24On time
2512003382025-12-19SPAREPART5027.0011MARTIN PULLY SPB 200 - 4 TAPER BUSH 3020 - 482601001931,600,0002512004402025-12-232026-01-1721,600,00042601001962026-01-07152026-01-24On time
2512003402025-12-19PERSEDIAAN UMUM6050.1204SAFETY VALVE 1/2 INCH P.MAX 10KG/CM^2251200429342,342.352512004292025-12-232025-12-302342,342.3542512008262025-12-2412026-01-06On time
2512003442025-12-19PERSEDIAAN UMUM6050.062KUNCI L SET TEKIRO260500486100,2002512004302025-12-232025-12-301155,765.7742512009812025-12-3072026-01-06On time
2512003672025-12-22SPAREPART5017.0145TELE SELECTOR XB4 BD21260600252122,9002512004342025-12-232025-12-2324113,50012512009252025-12-2962025-12-30On time
2512003672025-12-22SPAREPART5017.034MOTOR PROTECTION SCHNEIDER TYPE GV2ME10260500288545,0002512004352025-12-232025-12-239465,00012512009272025-12-2962025-12-30On time
2512003672025-12-22SPAREPART5017.1019MOTOR PROTECTION SCHNEIDER TYPE GV2ME08260500287490,0002512004352025-12-232025-12-239465,00012512009272025-12-2962025-12-30On time
2512003682025-12-22PERSEDIAAN UMUM6030.003PAKU 2 INCH26060016715,333.332512004452025-12-232025-12-309015,00012512008622025-12-2632026-01-06On time
2512003692025-12-22SPAREPART5017.0326LAMPU LED PHILIPS BN015C SET 1XTLED L1200 16 W 76526050002179,0002512004582025-12-232026-01-051079,00012601001542026-01-07152026-01-12On time
2512003732025-12-22PERSEDIAAN UMUM6050.0042KUAS ROLL KECIL26050030014,881.082512004542025-12-232025-12-30214,233.3312512009232025-12-2962026-01-06On time
2512003732025-12-22PERSEDIAAN UMUM6030.0775KUAS ROLL BESAR25120051235,0002512004542025-12-232025-12-30236,716.2212512009232025-12-2962026-01-06On time
2512003802025-12-22PERSEDIAAN UMUM6030.0613METERAN 5 MTR2605101569,3632512004442025-12-232025-12-30225,00012512008632025-12-2632026-01-06On time
2512003862025-12-22PERSEDIAAN UMUM6010.0351AIR MINERAL GALON26060024818,018.022512004472025-12-232025-12-303517,567.5712512009052025-12-2632026-01-06On time
2512003862025-12-22PERSEDIAAN UMUM6050.0313AIR MINERAL BOTOL KECIL 220 ML26060024819,819.822512004472025-12-232025-12-30519,369.3712512009052025-12-2632026-01-06On time
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512101462025-12-232025-12-3150041,000212601100032026-01-02102026-01-07On time
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512101462025-12-232025-12-3150041,000212601100042026-01-02102026-01-07On time
2512100032025-12-02BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002512101462025-12-232025-12-3150041,000212601101602026-01-10182026-01-07Late
← PrevPage 23 of 135Next →Rows per page:1020501005001000