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.1607ROOF SEAL 10 CM2601007081,914.412512002962025-12-162025-12-1619,8801,914.4142601012372026-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.0914THINER A BIASA @1 LTR26040044843,350.452512003112025-12-162025-12-29130,974.7812512007012025-12-2262026-01-05On time
2512002562025-12-15PERSEDIAAN UMUM6030.0506CAT BESI / KAYU COKLAT TUA25120031157,472.972512003112025-12-162025-12-29157,472.9712512007012025-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.0034ENGINE OIL SAE 15 W - 40 API CH4 IDEMITSU26031002837,5002512100682025-12-162025-12-1827,601,80062512104262025-12-1932025-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
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
2512100392025-12-13PERSEDIAAN UMUM6030.2485PLAT BAJA TEBAL 2MM251210071470,4002512100712025-12-162025-12-1635470,40032512104312025-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 UMUM6030.1843GERINDA AMPLAS 4 INCH2604102057,5002512100872025-12-172025-12-26507,50092512104882025-12-2472026-01-02On time
2512100222025-12-08PERSEDIAAN UMUM6050.0298CHAIN LUBE26060016939,1002512100902025-12-172025-12-26545,00092512104872025-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
← PrevPage 37 of 270Next →Rows per page:1020501005001000