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
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 46 of 270Next →Rows per page:1020501005001000