KKobin GroupProcurement KPI

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
2601002552026-01-20PERSEDIAAN UMUM6030.0507THINER B26010039823,1002601003982026-01-232026-02-04223,10032601010262026-01-2962026-02-11On time
2601002552026-01-20PERSEDIAAN UMUM6030.0846CAT AVIAN DIAMOND BLUE 73226010039857,472.972601003982026-01-232026-02-041257,472.9732601010262026-01-2962026-02-11On time
2601002572026-01-20SPAREPART5030.048SELANG POLYURETHANE SMC TUH 0604 N 20 OD 6 MM26010040913,0002601004092026-01-232026-02-058013,00032601011362026-02-02102026-02-12On time
2601002642026-01-21PERSEDIAAN UMUM6030.008PIPA GALVANIS 1 INCH MED SNI260600210320,0002601004002026-01-232026-02-0220300,450.4522601008242026-01-2412026-02-09On time
2601002642026-01-21PERSEDIAAN UMUM6030.008PIPA GALVANIS 1 INCH MED SNI260600210320,0002601004002026-01-232026-02-0220300,450.4522601008252026-01-2412026-02-09On time
2601002672026-01-22PERSEDIAAN UMUM6030.1713SENG TALANG GALVALUM 0.4 X 120 CM26010054357,0002601005432026-01-232026-01-2320057,00012601012982026-02-06142026-01-30Late
2601002692026-01-22BAHAN PEMBANTU2024.0001OPP 48*10026050005510,4952601004012026-01-232026-01-291,7287,00012601010482026-01-2962026-02-05On time
2601002692026-01-22BAHAN PEMBANTU2024.0001OPP 48*10026050005510,4952601004012026-01-232026-01-291,7287,00012601013642026-02-09172026-02-05Late
2601002702026-01-22BAHAN PEMBANTU2024.0004STRETCH FILM260500461535,0002601003952026-01-232026-02-0245355,00012601011492026-02-02102026-02-09On time
2601002802026-01-22PERSEDIAAN UMUM6050.0589LPG 12 KG260600005250,0002601004242026-01-232026-01-313210,00012601008332026-01-2412026-02-07On time
2601100112026-01-06PERSEDIAAN UMUM6030.2535NOOZLE BLENDER TIPE STRONG 8 NO.226011020318,2742601101682026-01-232026-02-031016,984172601105172026-01-2852026-02-10On time
2601100112026-01-06PERSEDIAAN UMUM6030.2498BENANG NILON D122601101671,0502601101672026-01-232026-02-03101,050172601107282026-02-09172026-02-10On time
2601100112026-01-06PERSEDIAAN UMUM6030.0638KAPUR BESI 16 A260510200881.252601101702026-01-232026-02-03201,162.3172601105132026-01-2852026-02-10On time
2601100112026-01-06PERSEDIAAN UMUM6030.0483CAT SPRAY MERAH26061011934,2352601101692026-01-232026-02-031018,032172601105122026-01-2852026-02-10On time
2601100112026-01-06PERSEDIAAN UMUM6030.2531KAWAT BWG 1826051021028,5602601101662026-01-232026-02-031024,100172601107222026-02-09172026-02-10On time
2601100112026-01-06PERSEDIAAN UMUM6030.253PENETRANT MAGNAFLUX RED26011015867,567.572601101582026-01-232026-01-23367,567.57172601108532026-02-11192026-01-30Late
2601100112026-01-06PERSEDIAAN UMUM6030.2529PENETRANT MAGNAFLUX DEVELOPER26011015867,567.572601101582026-01-232026-01-23367,567.57172601108532026-02-11192026-01-30Late
2601100112026-01-06PERSEDIAAN UMUM6030.2528PENETRANT MAGNAFLUX CLEANER26011015867,567.572601101582026-01-232026-01-23367,567.57172601108532026-02-11192026-01-30Late
2601100162026-01-08PERSEDIAAN UMUM6050.1273YELLOW FOAM U.K 10X100X200260110165160,0002601101652026-01-232026-02-032160,000152026-02-10Overdue
2601100162026-01-08PERSEDIAAN UMUM6030.0522LEM BESI 48 GR26050000615,765.772601101652026-01-232026-02-031018,000152601105042026-01-2852026-02-10On time
2601100162026-01-08PERSEDIAAN UMUM6050.1274CLEANING SOLVENT TOLVENE MERK BANDO (KEMASAN @ 1 LTR )260110174441,7502601101742026-01-232026-02-0310441,750152601106042026-02-02102026-02-10On time
2601100162026-01-08PERSEDIAAN UMUM6050.1272YELLOW FOAM U.K 5X100X20026011016580,0002601101652026-01-232026-02-03280,000152026-02-10Overdue
2601100172026-01-08PERSEDIAAN UMUM6050.1286ALAT KEBISINGAN (SOUND LEVEL METER)260110173284,8862601101732026-01-232026-02-031284,886152601107402026-02-09172026-02-10On time
2601100172026-01-08PERSEDIAAN UMUM6050.1285LUX METER260110173249,9002601101732026-01-232026-02-031249,900152601107402026-02-09172026-02-10On time
2601100192026-01-09PERSEDIAAN UMUM6050.1287KARET LAKER BEARING LAHAR 607 (VARIAN CROWN)26011016413,3002601101642026-01-232026-02-033013,300142601106102026-02-02102026-02-10On time
2601100192026-01-09PERSEDIAAN UMUM6050.103MAKITA HAND BLOWER CORDLESS 12V UB100DZ LENGKAP DENGAN BATTERY & CHARGER BATTERY2605102043,158,0002601101642026-01-232026-02-0313,515,000142601106102026-02-02102026-02-10On time
2601100262026-01-13SPAREPART5014.0031304 STAINLESS STEEL MESH 80 MESH X 1,3M WIDTH @30 MTR2606100333,752,5002601101532026-01-232026-01-3134,018,000102601105972026-02-02102026-02-07On time
2601100262026-01-13SPAREPART5014.0042304 STAINLESS STEEL SIEVE MESH 90 MESH X 1,3M WIDTH @30 MTR/ ROLL2606100325,620,0002601101532026-01-232026-01-31311,348,400102601105972026-02-02102026-02-07On time
2601100262026-01-13SPAREPART5014.0044304 STAINLESS STEEL SIEVE MESH 100 MESH X 1,3M WIDTH @30 MTR/ROLL2606100333,325,0002601101532026-01-232026-01-3134,067,000102601105972026-02-02102026-02-07On time
2601100262026-01-13SPAREPART5014.0033304 STAINLESS STEEL MESH 60 MESH X 1,3M WIDTH @30 MTR2606100333,776,2502601101532026-01-232026-01-3134,165,000102601105972026-02-02102026-02-07On time
2601100322026-01-13PERSEDIAAN UMUM6020.0762KABEL AUDIO KB-AT 2X30MM260110157300,0002601101572026-01-232026-01-234300,000102601012722026-02-06142026-01-30Late
2601100322026-01-13PERSEDIAAN UMUM6020.0761TOA HORN PAGING SPEAKER ZH-625SM (SPEAKER OUTDOOR)260110157700,0002601101572026-01-232026-01-232700,000102601012722026-02-06142026-01-30Late
2601100322026-01-13PERSEDIAAN UMUM6020.0763TOA GOOSENECK MICROPHONE ZM-380-AS (MIC MEJA)260110157500,0002601101572026-01-232026-01-231500,000102601012722026-02-06142026-01-30Late
2512001432025-12-09SPAREPART5014.0046MESH 402601008718.12601004302026-01-242026-02-05494,875462601008802026-01-2622026-02-12On time
2512003532025-12-20PERSEDIAAN UMUM6020.0733CABLE DUCTING PVC 10 X 1 MTR260100433100,0002601004332026-01-242026-01-243100,000352604007642026-04-21872026-01-31Late
2512003532025-12-20PERSEDIAAN UMUM6020.0733CABLE DUCTING PVC 10 X 1 MTR260100433100,0002601004332026-01-242026-01-243100,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0733CABLE DUCTING PVC 10 X 1 MTR260100433100,0002601004332026-01-242026-01-243100,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0732NANO DOUBLE TAPE 2CM X 10 MTR26010043330,0002601004332026-01-242026-01-24330,000352604007642026-04-21872026-01-31Late
2512003532025-12-20PERSEDIAAN UMUM6020.0732NANO DOUBLE TAPE 2CM X 10 MTR26010043330,0002601004332026-01-242026-01-24330,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0732NANO DOUBLE TAPE 2CM X 10 MTR26010043330,0002601004332026-01-242026-01-24330,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0731MODULE RELAY SONGLE, TRIGGER DC 1V-5V, DAYA 10A DC30V26010043315,0002601004332026-01-242026-01-24315,000352604007642026-04-21872026-01-31Late
2512003532025-12-20PERSEDIAAN UMUM6020.0731MODULE RELAY SONGLE, TRIGGER DC 1V-5V, DAYA 10A DC30V26010043315,0002601004332026-01-242026-01-24315,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0731MODULE RELAY SONGLE, TRIGGER DC 1V-5V, DAYA 10A DC30V26010043315,0002601004332026-01-242026-01-24315,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.073SIRINE 110J260100433100,0002601004332026-01-242026-01-243100,000352604007642026-04-21872026-01-31Late
2512003532025-12-20PERSEDIAAN UMUM6020.073SIRINE 110J260100433100,0002601004332026-01-242026-01-243100,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.073SIRINE 110J260100433100,0002601004332026-01-242026-01-243100,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0729KABEL SFTP ETHERNET 1 MTR26010043330,0002601004332026-01-242026-01-24330,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0729KABEL SFTP ETHERNET 1 MTR26010043330,0002601004332026-01-242026-01-24330,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0729KABEL SFTP ETHERNET 1 MTR26010043330,0002601004332026-01-242026-01-24330,000352604007642026-04-21872026-01-31Late
2512003532025-12-20PERSEDIAAN UMUM6020.0727KABEL USB TO MICRO USB 2 MTR26010043335,0002601004332026-01-242026-01-24335,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0727KABEL USB TO MICRO USB 2 MTR26010043335,0002601004332026-01-242026-01-24335,000352604007642026-04-21872026-01-31Late
2512003532025-12-20PERSEDIAAN UMUM6020.0727KABEL USB TO MICRO USB 2 MTR26010043335,0002601004332026-01-242026-01-24335,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0726POWER SUPPLY 5V DC 3 AMPERE OUTPUT USB 2 LUBANG USB TYPE A26010043350,0002601004332026-01-242026-01-24350,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0726POWER SUPPLY 5V DC 3 AMPERE OUTPUT USB 2 LUBANG USB TYPE A26010043350,0002601004332026-01-242026-01-24350,000352604007642026-04-21872026-01-31Late
2512003532025-12-20PERSEDIAAN UMUM6020.0726POWER SUPPLY 5V DC 3 AMPERE OUTPUT USB 2 LUBANG USB TYPE A26010043350,0002601004332026-01-242026-01-24350,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0723KABEL AUX 3.5 MM TRS26010043350,0002601004332026-01-242026-01-24350,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0723KABEL AUX 3.5 MM TRS26010043350,0002601004332026-01-242026-01-24350,000352604007642026-04-21872026-01-31Late
2512003532025-12-20PERSEDIAAN UMUM6020.0723KABEL AUX 3.5 MM TRS26010043350,0002601004332026-01-242026-01-24350,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.072SPEAKER ACTIVE 20 W260100433300,0002601004332026-01-242026-01-243300,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0719TOUCHSCREEN DISPLAY 7 INCH WITH MINI HDMI INPUT & USB TYPE C POWER260100433750,0002601004332026-01-242026-01-243750,000352604007642026-04-21872026-01-31Late
2512003532025-12-20PERSEDIAAN UMUM6020.072SPEAKER ACTIVE 20 W260100433300,0002601004332026-01-242026-01-243300,000352604007642026-04-21872026-01-31Late
2512003532025-12-20PERSEDIAAN UMUM6020.0719TOUCHSCREEN DISPLAY 7 INCH WITH MINI HDMI INPUT & USB TYPE C POWER260100433750,0002601004332026-01-242026-01-243750,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0719TOUCHSCREEN DISPLAY 7 INCH WITH MINI HDMI INPUT & USB TYPE C POWER260100433750,0002601004332026-01-242026-01-243750,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0716ORANGEPI 5 PRO RAM 8GB & EMMC 32GB2601004333,100,0002601004332026-01-242026-01-2433,100,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0718GPIO HEADER FEMALE 2X1026010043310,0002601004332026-01-242026-01-24310,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0718GPIO HEADER FEMALE 2X1026010043310,0002601004332026-01-242026-01-24310,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0718GPIO HEADER FEMALE 2X1026010043310,0002601004332026-01-242026-01-24310,000352604007642026-04-21872026-01-31Late
2512003532025-12-20PERSEDIAAN UMUM6020.0717KIPAS 4CM 5V 0.6A26010043330,0002601004332026-01-242026-01-24330,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0717KIPAS 4CM 5V 0.6A26010043330,0002601004332026-01-242026-01-24330,000352604007642026-04-21872026-01-31Late
2512003532025-12-20PERSEDIAAN UMUM6020.0717KIPAS 4CM 5V 0.6A26010043330,0002601004332026-01-242026-01-24330,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.0716ORANGEPI 5 PRO RAM 8GB & EMMC 32GB2601004333,100,0002601004332026-01-242026-01-2433,100,000352604007642026-04-21872026-01-31Late
2512003532025-12-20PERSEDIAAN UMUM6020.0716ORANGEPI 5 PRO RAM 8GB & EMMC 32GB2601004333,100,0002601004332026-01-242026-01-2433,100,000352026-01-31Overdue
2512003532025-12-20PERSEDIAAN UMUM6020.072SPEAKER ACTIVE 20 W260100433300,0002601004332026-01-242026-01-243300,000352026-01-31Overdue
2601001272026-01-10BAHAN PACKING3011.0053BOX PARIS MERAH TS SNI DIGITAL NEW 25*40 KW I2601004281,1002601004282026-01-242026-02-1030,0001,100142601011612026-02-03102026-02-17On time
2601001272026-01-10BAHAN PACKING3011.0051BOX JUPITER MERAH TS SNI DIGITAL NEW 25*40 KW I2606001201,2262601004282026-01-242026-02-1030,0001,100142601011612026-02-03102026-02-17On time
2601002852026-01-22BAHAN PEMBANTU2022.0003PET STRAPPING BAND 15.5X0.8 MM PANJANG=1400 MTR260600221350,0002601005752026-01-242026-02-05200350,00022603003422026-03-09442026-02-12Late
2601002852026-01-22BAHAN PEMBANTU2022.0003PET STRAPPING BAND 15.5X0.8 MM PANJANG=1400 MTR260600221350,0002601005752026-01-242026-02-05200350,00022601016162026-02-14212026-02-12Late
2601100262026-01-13PERSEDIAAN UMUM6050.1294SARINGAN BULAT / AYAKAN MESH 60 Ø 200MM260110177252601101772026-01-242026-04-24125112026-05-01Overdue
2601100262026-01-13PERSEDIAAN UMUM6050.1293SARINGAN BULAT / AYAKAN MESH 40 Ø 200MM260110177252601101762026-01-242026-02-041300,000112601107602026-02-09162026-02-11On time
2601100262026-01-13PERSEDIAAN UMUM6050.1294SARINGAN BULAT / AYAKAN MESH 60 Ø 200MM260110177252601101762026-01-242026-02-041300,000112601107602026-02-09162026-02-11On time
2601100262026-01-13PERSEDIAAN UMUM6050.1291SARINGAN BULAT / AYAKAN MESH 250 Ø 200MM260110177352601101762026-01-242026-02-041325,000112601107602026-02-09162026-02-11On time
2601100262026-01-13PERSEDIAAN UMUM6050.1291SARINGAN BULAT / AYAKAN MESH 250 Ø 200MM260110177352601101772026-01-242026-04-24935112026-05-01Overdue
2601100262026-01-13PERSEDIAAN UMUM6050.1292SARINGAN BULAT / AYAKAN MESH 20 Ø 200MM260110177252601101762026-01-242026-02-041300,000112601107602026-02-09162026-02-11On time
2601100262026-01-13PERSEDIAAN UMUM6050.1293SARINGAN BULAT / AYAKAN MESH 40 Ø 200MM260110177252601101772026-01-242026-04-24125112026-05-01Overdue
2601100262026-01-13PERSEDIAAN UMUM6050.1292SARINGAN BULAT / AYAKAN MESH 20 Ø 200MM260110177252601101772026-01-242026-04-24125112026-05-01Overdue
2601100262026-01-13PERSEDIAAN UMUM6050.1295SARINGAN BULAT / AYAKAN MESH 80 Ø 200MM260110177252601101772026-01-242026-04-24125112026-05-01Overdue
2601100262026-01-13PERSEDIAAN UMUM6050.1295SARINGAN BULAT / AYAKAN MESH 80 Ø 200MM260110177252601101762026-01-242026-02-041300,000112601107602026-02-09162026-02-11On time
2601100262026-01-13PERSEDIAAN UMUM6050.1296SARINGAN BULAT / AYAKAN MESH 100 Ø 200MM260110177252601101772026-01-242026-04-24125112026-05-01Overdue
2601100262026-01-13PERSEDIAAN UMUM6050.1296SARINGAN BULAT / AYAKAN MESH 100 Ø 200MM260110177252601101762026-01-242026-02-041325,000112601107602026-02-09162026-02-11On time
2512002502025-12-15SPAREPART5017.0145TELE SELECTOR XB4 BD21260600252122,9002601004522026-01-262026-01-2625125,000422603005352026-03-12452026-02-02Late
2512003512025-12-20PERSEDIAAN UMUM6030.1363MATA BOR BESI 14 MM260610157316,2002601004532026-01-262026-01-262295,675.68372601010772026-01-3042026-02-02On time
2512003512025-12-20PERSEDIAAN UMUM6030.2512BOR DUDUK MAGNET 1300 W 220 V 50 HZ2601004493,100,0002601004492026-01-262026-01-2613,100,000372601010992026-01-3042026-02-02On time
2512004632025-12-30BAHAN BAKU GLAZE1030.0056TRANSPARENT FRIT YGC 000292601011438,2082601004362026-01-262026-01-316,0008,208272601011122026-01-3152026-02-07On time
2512004862025-12-30PERSEDIAAN UMUM6050.0354TALI RAFIA26030021313,0002601005372026-01-262026-02-021013,000272601010792026-01-3042026-02-09On time
2512004922025-12-31SPAREPART5023.1513TIE ROD PHS16 (KIRI)26010045775,0002601004572026-01-262026-02-05475,000262601015782026-02-13182026-02-12Late
2512004922025-12-31SPAREPART5023.1512TIE ROD PHS16 (KANAN)26010045775,0002601004572026-01-262026-02-05475,000262601015782026-02-13182026-02-12Late
2601000022026-01-02SPAREPART5032.048PUMP (NO. 22) 32495 EX-725101052601004624,550,0002601004622026-01-262026-02-1414,550,000242601009452026-01-2822026-02-21On time
2601000822026-01-08SPAREPART5027.0447HEAVY DUTY ALUMUNIUM PROFILE 40X40260100467233,333.332601004672026-01-262026-02-106233,333.33182603007542026-03-17502026-02-17Late
2601000862026-01-08PERSEDIAAN UMUM6050.1013KARET GELANG PENTIL26010058713,0002601004472026-01-262026-02-04113,000182601009542026-01-2822026-02-11On time
2601000952026-01-08BAHAN PACKING3011.0137BOX MY HIJAU TS 40*40 KW II2605004741,2752601004602026-01-262026-02-1615,0001,150182601018302026-02-21262026-02-23On time
← PrevPage 49 of 135Next →Rows per page:1020501005001000