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
2512001922025-12-11PERSEDIAAN UMUM6030.0526ISOLASI ELECTRIC2605004926,306.312512004802025-12-262025-12-26205,855.85152512009852025-12-3042026-01-02On time
2512002642025-12-16PERSEDIAAN UMUM6020.0152KABEL NYY 1X95 MM (SUPREME)260100246217,7062512004912025-12-262026-01-10240206,216.22102601000572026-01-0272026-01-17On time
2512002642025-12-16PERSEDIAAN UMUM6020.0121KABEL NYY 1X50 MM251200491104,684.692512004912025-12-262026-01-1080104,684.69102601000572026-01-0272026-01-17On time
2512002642025-12-16PERSEDIAAN UMUM6020.0488KABEL SCUN 95 MM26030026616,5002512004942025-12-262026-01-101515,00010–––2026-01-17Overdue
2512002642025-12-16PERSEDIAAN UMUM6020.0491KABEL SCUN 50 MM2604002706,0002512004942025-12-262026-01-1058,00010–––2026-01-17Overdue
2512002922025-12-17SPAREPART5029.03PIN SUPPORT ROLL OUT KILN DIA 12MM X 33MM25120049075,0002512004902025-12-262026-01-203075,00092601003962026-01-13182026-01-27On time
2512002922025-12-17SPAREPART5019.0332GEAR REDUCER MNRV 050 RATIO 1:20 FLANGE 0.37KW B52512005083,062,5002512005082025-12-262026-01-1023,062,50092601001282026-01-06112026-01-17On time
2512002922025-12-17SPAREPART5019.006GEARBOX NMRV 050 RATIO 1:15 FLANGE 0.37 KW B142512005083,062,5002512005082025-12-262026-01-1033,062,50092601001282026-01-06112026-01-17On time
2512003392025-12-19SPAREPART5019.0341GEAR REDUCER MNRV 040 RATIO 1:30 0.37 KW FLANGE B142512004922,312,5002512004922025-12-262026-01-1022,312,50072601001292026-01-06112026-01-17On time
2512003392025-12-19SPAREPART5019.0111GEAR REDUCER MNRV 063 R 1:30 (FLANGE 0.75 KW B14)2605001934,500,0002512004932025-12-262026-01-1014,500,00072601001842026-01-07122026-01-17On time
2512003752025-12-22PERSEDIAAN UMUM6050.1211LOYANG KOTAK PERSEGI UK 10X10X4 CM2512004899,0002512004892025-12-262026-01-0529,00042512009382025-12-2932026-01-12On time
2512003752025-12-22PERSEDIAAN UMUM6050.1212LOYANG KOTAK PERSEGI UK 20X10X4 CM2512004898,0002512004892025-12-262026-01-0528,00042512009382025-12-2932026-01-12On time
2512003762025-12-22PERSEDIAAN UMUM6050.0682RAK PLASTIK SUSUN26010016656,9002512004882025-12-262026-01-03160,79842512009372025-12-2932026-01-10On time
2512003992025-12-23PERSEDIAAN UMUM6030.1561BETON READYMIX MUTU K300260600062780,0002512004792025-12-262025-12-266750,00032601003722026-01-13182026-01-02Late
2512004032025-12-23BAHAN BAKAR4030.001DAPHNE SUPER HYDRO 46 (IDEMITSU)26060022462,2502512005332025-12-262025-12-2612,00041,5003–––2026-01-02Overdue
2512004032025-12-23BAHAN BAKAR4030.001DAPHNE SUPER HYDRO 46 (IDEMITSU)26060022462,2502512005332025-12-262025-12-2612,00041,50032601000532026-01-0272026-01-02On time
2512004032025-12-23BAHAN BAKAR4030.001DAPHNE SUPER HYDRO 46 (IDEMITSU)26060022462,2502512005332025-12-262025-12-2612,00041,50032601012452026-02-05412026-01-02Late
2512004032025-12-23BAHAN BAKAR4030.001DAPHNE SUPER HYDRO 46 (IDEMITSU)26060022462,2502512005332025-12-262025-12-2612,00041,50032601009172026-01-27322026-01-02Late
2512100362025-12-12PERSEDIAAN UMUM6030.2482HOLE SAW 1825121013623,4002512101362025-12-262026-01-03523,400142512106052025-12-3042026-01-10On time
2512100362025-12-12PERSEDIAAN UMUM6030.2481HOLE SAW 1525121013619,5002512101362025-12-262026-01-03519,500142512106052025-12-3042026-01-10On time
2512100372025-12-12PERSEDIAAN UMUM6030.0974HOLE SAW 35/3225121013741,6002512101372025-12-262026-01-03341,600142512106062025-12-3042026-01-10On time
2512100372025-12-12PERSEDIAAN UMUM6030.0973HOLE SAW 5025121013765,0002512101372025-12-262026-01-03365,000142512106062025-12-3042026-01-10On time
2512100552025-12-18PERSEDIAAN UMUM6050.12TENSIONER260510141354,2502512101392025-12-262026-01-036275,00082512105352025-12-2712026-01-10On time
2512100622025-12-23BAHAN BAKU BODY1010.0018CLAY AB 76#2606101783902512101322025-12-262025-12-261,333,52039032512105282025-12-2712026-01-02On time
2512100622025-12-23BAHAN BAKU BODY1010.0018CLAY AB 76#2606101783902512101322025-12-262025-12-261,333,52039032512105272025-12-26–2026-01-02On time
2512100662025-12-23PERSEDIAAN UMUM6050.1123SEPATU SAFETY LOW (PENDEK) NO.41251210135320,0002512101352025-12-262026-01-034320,00032601103152026-01-17222026-01-10Late
2512100662025-12-23PERSEDIAAN UMUM6050.1127SEPATU SAFETY LOW (PENDEK) NO.45251210135320,0002512101352025-12-262026-01-031320,00032601103152026-01-17222026-01-10Late
2512100672025-12-24PERSEDIAAN UMUM6020.0146WD 4026060016991,5002512101342025-12-262026-01-03770,00022601102352026-01-13182026-01-10Late
2511003782025-11-25PERSEDIAAN UMUM6050.1163EXTENSION NIPPLE GREASE M10 TO M12 P=150 MM251200513170,0002512005132025-12-272026-01-308170,000322601006602026-01-20242026-02-06On time
2511003782025-11-25PERSEDIAAN UMUM6050.1162EXTENSION NIPPLE GREASE M6 TO M6 P=20 MM251200513120,0002512005132025-12-272026-01-3020120,000322601006602026-01-20242026-02-06On time
2511004352025-11-28SPAREPART5022.0365PINION GEAR Z10 (MAT=SCM-415 HARDEN)260100873380,0002512005652025-12-272026-01-301675,000292601017522026-02-19542026-02-06Late
2511004352025-11-28SPAREPART5022.0364HELICAL GEAR Z63 (MAT=SCM-415 HARDEN)260600091827,0002512005652025-12-272026-01-3011,665,000292601017522026-02-19542026-02-06Late
2511004352025-11-28SPAREPART5029.0371HELICAL GEAR Z25 (MAT=SCM-415 HARDEN)260600091363,0002512005652025-12-272026-01-301945,000292601017522026-02-19542026-02-06Late
2511004352025-11-28SPAREPART5022.0363HELICAL GEAR Z73(MAT=SCM-415 HARDEN)260600091800,0002512005652025-12-272026-01-3011,440,000292601017522026-02-19542026-02-06Late
2512000402025-12-01SPAREPART5030.17389663000037 POMPA 1X3/8 M10A6-BN (V.NOTE) ART.32.22.038 PIAB2512005064,085,7802512005062025-12-272025-12-2754,085,780262601006542026-01-20242026-01-03Late
2512000992025-12-05BAHAN PACKING3011.026NFT00 60X60 MY MP1 KW-A 606X45 (WK150/150/150)2603005067232512005012025-12-272026-01-305,000635222601008232026-01-24282026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0263NFT00 60X60 MY MP2 KW-B 606X48 (WK150/150/150)2601010216292512005012025-12-272026-01-305,000580222601008232026-01-24282026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0262NFT00 60X60 MY MP1 KW-B 606X45 (BK150/150/150)2601010215912512005012025-12-272026-01-305,000545222601008232026-01-24282026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0261NFT00 60X60 MY MP2 KW-A 606X48 (WK150/150/150)2603005066612512005012025-12-272026-01-305,000580222601008232026-01-24282026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0259NFT00 60X60 PARIS MP2 KW-B 606X48 (WK150/150/150)2604003306822512005012025-12-272026-01-305,000580222601008232026-01-24282026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0258NFT00 60X60 PARIS MP1 KW-B 606X45 (BK150/150/150)2604003306412512005012025-12-272026-01-305,000545222601008232026-01-24282026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0257NFT00 60X60 PARIS MP2 KW-A 606X48 (WK150/150/150)2604003306822512005012025-12-272026-01-3010,000580222601006902026-01-21252026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0256NFT00 60X60 PARIS MP1 KW-A 606X45 (WK150/150/150)2604003307482512005012025-12-272026-01-3010,000635222601006902026-01-21252026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0255NFT00 60X60 JUPITER MP2 KW-B 606X48 (WK150/150/150)2603005066612512005012025-12-272026-01-305,000580222601008232026-01-24282026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0254NFT00 60X60 JUPITER MP1 KW-B 606X45 (BK150/150/150)2603005066212512005012025-12-272026-01-305,000545222601008232026-01-24282026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0253NFT00 60X60 JUPITER MP2 KW-A 606X48 (WK150/150/150)2603005066612512005012025-12-272026-01-3010,000580222601004962026-01-15192026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0253NFT00 60X60 JUPITER MP2 KW-A 606X48 (WK150/150/150)2603005066612512005012025-12-272026-01-3010,000580222601004282026-01-13172026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0252NFT00 60X60 JUPITER MP1 KW-A 606X45 (WK150/150/150)2603005067232512005012025-12-272026-01-3010,000635222601004962026-01-15192026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0252NFT00 60X60 JUPITER MP1 KW-A 606X45 (WK150/150/150)2603005067232512005012025-12-272026-01-3010,000635222601004282026-01-13172026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0251NFT00 60X60 KOBIN MP2 KW-B 606X48 (WK150/150/150)2604003306822512005012025-12-272026-01-3010,000580222601003282026-01-12162026-02-06On time
← PrevPage 50 of 270Next →Rows per page:1020501005001000