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
2604100312026-04-13PERSEDIAAN UMUM6050.1739KECAP 19 ML2605100531,0002605100532026-05-062026-05-15101,000232605106962026-05-23172026-05-22Late
2604100322026-04-14SPAREPART5014.0032304 STAINLESS STEEL MESH 70 MESH X 1,3M WIDTH @30 MTR2606100325,620,0002605100492026-05-062026-05-1455,620,000222605104102026-05-16102026-05-21On time
2604100322026-04-14SPAREPART5014.0042304 STAINLESS STEEL SIEVE MESH 90 MESH X 1,3M WIDTH @30 MTR/ ROLL2606100325,620,0002605100492026-05-062026-05-1455,620,000222605104102026-05-16102026-05-21On time
2604100452026-04-17PERSEDIAAN UMUM6050.0737LPG 12KG ( REFILL )260610118230,0002605100522026-05-062026-05-151245,000192026-05-22Overdue
2604100502026-04-20STATIONERY6010.0001KERTAS A426060024443,0002605100502026-05-062026-05-12934,500162605103962026-05-16102026-05-19On time
2603100232026-03-10SPAREPART5017.0119STOP KONTAK 3 LUBANG26061002920,0002605100382026-05-052026-05-091540,500562605103982026-05-16112026-05-16On time
2603100292026-03-11PERSEDIAAN UMUM6030.1725ELBOW BESI 45 DRJ ASTM SCH.40 Ø 2,5 INCH26051004130,0002605100412026-05-052026-05-055030,000552605104192026-05-16112026-05-12Late
2603100292026-03-11PERSEDIAAN UMUM6030.1724ELBOW BESI 90 DRJ ASTM SCH.40 Ø 2,5 INCH26051004145,0002605100412026-05-052026-05-0515045,000552605104192026-05-16112026-05-12Late
2603100292026-03-11SPAREPART5017.0898STOP KONTAK 5 LUBANG MERK BROCO26051003860,5002605100382026-05-052026-05-091560,500552605103982026-05-16112026-05-16On time
2604001502026-04-13SPAREPART5030.0776CHAIN 8Q200400112605000743.122605000742026-05-052026-08-30263.12222026-09-06Outstanding
2604001882026-04-15SPAREPART5030.1834FIXING SLEEVE 20038044426050007349.422605000732026-05-052026-07-30249.42202026-08-06Outstanding
2604001882026-04-15SPAREPART5030.1832PHOTOCELL BRACKET I 20001176026050007311.812605000732026-05-052026-07-30211.81202026-08-06Outstanding
2604001882026-04-15SPAREPART5030.183ENGINEERING TOWLINE 100031442260500073112.742605000732026-05-052026-07-3010112.74202026-08-06Outstanding
2604001882026-04-15SPAREPART5030.1831PRESSING WHEEL 2004930472605000733782605000732026-05-052026-07-304378202026-08-06Outstanding
2604001882026-04-15SPAREPART5030.1833FIXING SLEEVE 20021330126050007319.372605000732026-05-052026-07-30219.37202026-08-06Outstanding
2604002692026-04-17PERSEDIAAN UMUM6030.2107ANGKUR L M 25X60026050005664,1002605000562026-05-052026-05-118064,100182605003392026-05-1162026-05-18On time
2604002892026-04-20PERSEDIAAN UMUM6020.0048JAM DINDING26050003560,0002605000352026-05-052026-05-12560,000152605004962026-05-15102026-05-19On time
2604003202026-04-18BAHAN PEMBANTU20AB.0023ALUMINA BALL 92% SIZE 50 MM2605000306.312605000302026-05-052026-07-1311,1006.305172026-07-20Outstanding
2604003202026-04-18BAHAN PEMBANTU20AB.0022ALUMINA BALL 92% SIZE 40 MM2605000306.312605000302026-05-052026-07-138,9006.305172026-07-20Outstanding
2604003202026-04-18BAHAN PEMBANTU20AB.0024ALUMINA BALL 92% SIZE 25 MM2605000306.312605000302026-05-052026-07-138006.305172026-07-20Outstanding
2604003202026-04-18BAHAN PEMBANTU20AB.0025ALUMINA BALL 92% SIZE 60 MM2605000306.312605000302026-05-052026-07-131,0006.305172026-07-20Outstanding
2604003202026-04-18BAHAN PEMBANTU20AB.0021ALUMINA BALL 92% SIZE 30 MM2605000306.312605000302026-05-052026-07-134,2006.305172026-07-20Outstanding
2604100302026-04-13PERSEDIAAN UMUM6030.2351ELBOW PVC AW 4 INCH26061005414,414.412605100422026-05-052026-05-05890,000222605104182026-05-16112026-05-12Late
2604100462026-04-17PERSEDIAAN UMUM6030.0913SEAL TAPE ONDA 0.5 INCH 10 MTR2605102205,0052605100402026-05-052026-05-05504,097.5182605106182026-05-22172026-05-12Late
2603001952026-03-14FIXED ASSETSAST02710LOADER XIAGONG XIGMA XG985K 5000KG MANUAL260500280860,000,0002605002802026-05-042026-06-081860,000,000512606002772026-06-08352026-06-15On time
2603003402026-03-26SPAREPART5021.0315T. BELT 1200 H-1002605000231,374,0002605000232026-05-042026-05-25111,374,000392606001392026-06-04312026-06-01Late
2603004522026-03-31PERSEDIAAN UMUM6050.0034LPG 50 KG2606001661,300,0002605000072026-05-042026-05-1021,350,000342605000552026-05-042026-05-17On time
2603100232026-03-10PERSEDIAAN UMUM6050.0871BLOWER PORTABLE 14 INCH 220VOLT2605100282,600,0002605100262026-05-042026-05-0422,600,000552605104082026-05-16122026-05-11Late
2604001572026-04-13SPAREPART5021.0419V. BELT SPC 3810 LW X-POWER2605000281,167,0002605000282026-05-042026-05-1181,167,000212605003022026-05-1172026-05-18On time
2604003042026-04-18PERSEDIAAN UMUM6020.0086KEYBOARD260500013105,0002605000132026-05-042026-05-081105,000162605002842026-05-0952026-05-15On time
2604003042026-04-18FIXED ASSETSAST02092MOUSE LOGITECH M170260500013115,0002605000132026-05-042026-05-081115,000162605002842026-05-0952026-05-15On time
2604100502026-04-20STATIONERY6010.0122BOLPOIN HITAM2606000271,3002605100222026-05-042026-05-09241,827142605104002026-05-16122026-05-16On time
2604100502026-04-20STATIONERY6010.0532SNOWMAN SPIDOL PERMANEN - HITAM/BLACK BG122606101513,9082605100222026-05-042026-05-09122,500142605104002026-05-16122026-05-16On time
2604100502026-04-20STATIONERY6010.0143TRIGONAL CLIP NO. 32605002611,5002605100222026-05-042026-05-09117,900142605104002026-05-16122026-05-16On time
2604100502026-04-20STATIONERY6010.0716ISI CUTTER A-30026051002334,1202605100232026-05-042026-05-09234,120142605106242026-05-22182026-05-16Late
2604100502026-04-20STATIONERY6010.0218ODNER BANTEX 29X35X4,5 CM26051001918,1502605100192026-05-042026-05-091018,150142605106252026-05-22182026-05-16Late
2604100502026-04-20STATIONERY6010.0284CATRIDGE EPSON LX 31026060025645,0002605100242026-05-042026-05-09527,940142605106232026-05-22182026-05-16Late
2604100502026-04-20STATIONERY6010.077GUNTING KERTAS KECIL2606101513,6272605100222026-05-042026-05-0927,000142605104002026-05-16122026-05-16On time
2604100502026-04-20STATIONERY6010.0147CUTTER KECIL A-3002606000275,0002605100192026-05-042026-05-0937,888142605106252026-05-22182026-05-16Late
2603100312026-03-12PERSEDIAAN UMUM6050.1382POMPA OLI MANUAL (BESI)260600231350,0002605100122026-05-022026-05-121362,500512605104032026-05-16142026-05-19On time
2603100382026-03-16BAHAN PEMBANTU20AB.0020ALUMINA BALL 92% SIZE 20 MM2605100186.312605100182026-05-022026-05-0210,0006.305472026-05-09Overdue
2603100382026-03-16BAHAN PEMBANTU20AB.0015ALUMINA BALL 75% SIZE 20 MM2605100182.942605100182026-05-022026-05-0250,0002.938472026-05-09Overdue
2603100382026-03-16BAHAN PEMBANTU20AB.0016ALUMINA BALL 75% SIZE 30 MM2605100182.942605100182026-05-022026-05-02150,0002.938472026-05-09Overdue
2603100382026-03-16BAHAN PEMBANTU20AB.0017ALUMINA BALL 75% SIZE 40 MM2605100182.942605100182026-05-022026-05-02175,0002.938472026-05-09Overdue
2603100382026-03-16BAHAN PEMBANTU20AB.0018ALUMINA BALL 75% SIZE 50 MM2605100182.942605100182026-05-022026-05-0275,0002.938472026-05-09Overdue
2603100382026-03-16BAHAN PEMBANTU20AB.0026ALUMINA BALL 92% SIZE 50 MM2605100186.312605100182026-05-022026-05-0210,0006.305472026-05-09Overdue
2603100382026-03-16BAHAN PEMBANTU20AB.0022ALUMINA BALL 92% SIZE 40 MM2605000306.312605100182026-05-022026-05-0221,0006.305472026-05-09Overdue
2603100382026-03-16BAHAN PEMBANTU20AB.0021ALUMINA BALL 92% SIZE 30 MM2605000306.312605100182026-05-022026-05-0221,0006.305472026-05-09Overdue
2603100382026-03-16BAHAN PEMBANTU20AB.0019ALUMINA BALL 75% SIZE 60 MM2606100412.942605100182026-05-022026-05-02150,0002.938472026-05-09Overdue
2604002072026-04-15PERSEDIAAN UMUM6030.2776BESI VERKAN 10 X 10 @6 METER260500005122,522.522605000052026-05-022026-05-114122,522.52172605001132026-05-0532026-05-18On time
2604002482026-04-17PERSEDIAAN UMUM6030.2934SIKU GALVANIS 50X50X5MM @6M260500005294,594.62605000052026-05-022026-05-113294,594.6152605001132026-05-0532026-05-18On time
2604002522026-04-17PERSEDIAAN UMUM6030.2936PIPA PK HITAM 3/4"X3"X6000MM260500009166,666.672605000092026-05-022026-05-123166,666.67152605002432026-05-0862026-05-19On time
2604002542026-04-17PERSEDIAAN UMUM6030.2938DOUBLE NEPLE BESI 2.5 INCH26050046260,0002605000082026-05-022026-05-12256,756.76152605002492026-05-0862026-05-19On time
2604002642026-04-18PERSEDIAAN UMUM6050.1761OBENG PLUS26050000219,0002605000022026-05-022026-05-08219,000142605001602026-05-0642026-05-15On time
2604002872026-04-20PERSEDIAAN UMUM6030.0743PLAT STRIP 5X50X6000 MM260500009123,873.872605000092026-05-022026-05-122123,873.87122605001122026-05-0532026-05-19On time
2604100262026-04-11BAHAN PEMBANTU20AB.0019ALUMINA BALL 75% SIZE 60 MM2606100412.942605100172026-05-022026-05-02100,0002.938212026-05-09Overdue
2604100492026-04-20PERSEDIAAN UMUM6050.0703LOBY DUSTER FULL SET26061009460,0002605100042026-05-022026-05-12665,000122605100482026-05-0642026-05-19On time
2604100492026-04-20PERSEDIAAN UMUM6050.104LAP MICROFIBER2606100834,1002605100052026-05-022026-05-1216,831122605100692026-05-0642026-05-19On time
2601100472026-01-23FIXED ASSETSAST02604HP INFINIX NOTE 50S 5G 8/256GB2604102273,170,8602604102272026-04-302026-04-3013,170,860972026-05-07Overdue
2603001832026-03-11BAHAN PEMBANTU2033.0003FLUORESCENT LIQUID MARKER (TRANSPARENT)26050026832,5002604005362026-04-302026-05-0612032,500502605001732026-05-0772026-05-13On time
2603001852026-03-11BAHAN PEMBANTU2033.0001YELLOW INK26050026881,5002604005362026-04-302026-05-0612081,500502605001732026-05-0772026-05-13On time
2604000872026-04-08PERSEDIAAN UMUM6060.0699BAUT M 55X70260400544175,0002604005442026-04-302026-05-1612175,000222605009712026-05-29292026-05-23Late
2604000872026-04-08PERSEDIAAN UMUM6060.07MUR M 5526040054425,0002604005442026-04-302026-05-161225,000222605009712026-05-29292026-05-23Late
2604001322026-04-10SPAREPART5032.1495TURBO CHARGE S/N 210616012604005394,685,0002604005392026-04-302026-05-1314,685,000202605001392026-05-0662026-05-20On time
2604001332026-04-10SPAREPART5032.1497PUMP ASSY, GEAR NO. 6 91871-042002604005417,376,7502604005412026-04-302026-05-1517,376,750202026-05-22Overdue
2604001332026-04-10SPAREPART5032.1496REPAIR KIT, CYL NO. 105 91851-8351026040054085,5002604005402026-04-302026-05-08385,500202605002822026-05-0992026-05-15On time
2604001572026-04-13SPAREPART5021.047V. BELT SPC 3375 LW260400552360,0002604005522026-04-302026-05-224360,000172605006282026-05-20202026-05-29On time
2604001572026-04-13SPAREPART5021.0469V. BELT SPC 3450 LW260400551310,0002604005512026-04-302026-05-188310,000172605001442026-05-0662026-05-25On time
2604001572026-04-13SPAREPART5021.0417V. BELT SPA 1907 LW X-POWER260400550144,0002604005502026-04-302026-05-118144,000172605004382026-05-13132026-05-18On time
2604001572026-04-13SPAREPART5021.047V. BELT SPC 3375 LW260400552360,0002604005512026-04-302026-05-184303,100172605001442026-05-0662026-05-25On time
2604001942026-04-15SPAREPART5032.1499DRIVE SHAFT NO.04 135C3-120212604005412,422,5002604005412026-04-302026-05-1532,422,500152026-05-22Overdue
2604002132026-04-15SPAREPART5019.0369CENTRIFUGAL FAN 0.75KW 2900RPM2604005371532604005372026-04-302026-06-303153152026-07-07Outstanding
2604002482026-04-17PERSEDIAAN UMUM6030.2935PIPA GALVANIS 3 INCH T=5.5MM @6M2604005321,491,891.892604005322026-04-302026-05-1031,491,891.89132605001142026-05-0552026-05-17On time
2604002522026-04-17PERSEDIAAN UMUM6030.2349PLAT STRIP 40X3X6000 MM26040053290,090.092604005322026-04-302026-05-101090,090.09132605003362026-05-11112026-05-17On time
2604002872026-04-20PERSEDIAAN UMUM6030.2551BESI SIKU STAINLESS STEEL 50X50X6000 MM2604005321,115,315.322604005322026-04-302026-05-1021,115,315.32102605001142026-05-0552026-05-17On time
2604100502026-04-20STATIONERY6010.0151ISI STAPLES KECIL #10 KECIL, NO.10-1M2606101511,5922604102332026-04-302026-05-0654,200102605103992026-05-16162026-05-13Late
2604100502026-04-20STATIONERY6010.0448PAPAN JALAN CLIPBOARD A426041023411,7812604102342026-04-302026-05-06511,781102605104062026-05-16162026-05-13Late
2604100502026-04-20STATIONERY6010.0133SPIDOL MARKER HITAM - MARKER, HITAM/BLACK2606000275,7002604102322026-04-302026-05-06151,612.67102605104012026-05-16162026-05-13Late
2604100502026-04-20STATIONERY6010.0134SPIDOL MARKER MERAH MARKER, MERAH/RED2606000275,7002604102322026-04-302026-05-0631,480102605104012026-05-16162026-05-13Late
2604100502026-04-20STATIONERY6010.0172BINDER CLIP NO. 107 NO. 1072606100603,5002604102312026-04-302026-05-0534,268.67102605104052026-05-16162026-05-12Late
2604100502026-04-20STATIONERY6010.0156STAPLES KECIL HD-102606101519,7412604102332026-04-302026-05-06115,750102605103992026-05-16162026-05-13Late
2604100502026-04-20STATIONERY6010.0721REFIL TINTA PRINTER HITAM (GI-71 BLACK) UNTUK PRINTER CANON G477026041023629,9842604102362026-04-302026-05-05129,984102605106222026-05-22222026-05-12Late
2604100502026-04-20STATIONERY6010.0174BINDER CLIP NO. 155 NO. 1552606100607,2002604102312026-04-302026-05-0536,702102605104052026-05-16162026-05-12Late
2604100502026-04-20STATIONERY6010.0724REFIL TINTA PRINTER KUNING (GI-71 YELLOW) UNTUK PRINTER CANON G477026041023626,9852604102362026-04-302026-05-05126,985102605106222026-05-22222026-05-12Late
2604100502026-04-20STATIONERY6010.0723REFIL TINTA PRINTER MERAH (GI-71 MAGENTA) UNTUK PRINTER CANON G477026041023624,9852604102362026-04-302026-05-05124,985102605106222026-05-22222026-05-12Late
2604100502026-04-20STATIONERY6010.0722REFIL TINTA PRINTER BIRU (GI-71 CYAN) UNTUK PRINTER CANON G477026041023624,9852604102362026-04-302026-05-05124,985102605106222026-05-22222026-05-12Late
2604100502026-04-20STATIONERY6010.0175BINDER CLIP NO. 260 NO. 26026061006018,0002604102312026-04-302026-05-05317,002102605104052026-05-16162026-05-12Late
2604100502026-04-20STATIONERY6010.0136SPIDOL MARKER PUTIH MARKER, PUTIH/WHITE26060010813,1002604102342026-04-302026-05-0633,141.7102605104062026-05-16162026-05-13Late
2603002202026-03-13SPAREPART5014.0053STAINLESS STEEL MESH 100 MESH 1000X0.14MM260400520165,0002604005202026-04-292026-05-1815165,000472605003272026-05-11122026-05-25On time
2603003882026-03-27BAHAN BAKU GLAZE1030.0026POTASSIUM FELDSPAR POWDER KN-2002605003162,720.562604005212026-04-292026-05-1591,0002,586.75332605002742026-05-09102026-05-22On time
2603003882026-03-27BAHAN BAKU GLAZE1030.0026POTASSIUM FELDSPAR POWDER KN-2002605003162,720.562604005212026-04-292026-05-1591,0002,586.75332605002062026-05-0892026-05-22On time
2603003882026-03-27BAHAN BAKU GLAZE1030.0026POTASSIUM FELDSPAR POWDER KN-2002605003162,720.562604005212026-04-292026-05-1591,0002,586.75332605002052026-05-0892026-05-22On time
2603003882026-03-27BAHAN BAKU GLAZE1030.0026POTASSIUM FELDSPAR POWDER KN-2002605003162,720.562604005212026-04-292026-05-1591,0002,586.75332605002582026-05-09102026-05-22On time
2603100032026-03-03SPAREPART5031.1005RUBBER CONVEYOR BELT B1000X6 LAYERS X10MM THICK26041023521.232604102352026-04-292026-04-2940021.233572026-05-06Overdue
2603100032026-03-03SPAREPART5031.1006RUBBER CONVEYOR BELT B800X6 LAYERS X10MM THICK26041023517.012604102352026-04-292026-04-2940017.005572026-05-06Overdue
2603100292026-03-11PERSEDIAAN UMUM6020.0131KABEL NYYHY 4X4 MM26041021749,189.192604102172026-04-292026-04-2920049,189.19492605103942026-05-16172026-05-06Late
2603100292026-03-11PERSEDIAAN UMUM6020.0545KABEL NYYHY 3X1.5 MM26041021717,117.122604102172026-04-292026-04-2920017,117.12492605103942026-05-16172026-05-06Late
2603100492026-03-27PERSEDIAAN UMUM6030.2471PLAT BORDES 1200X2400X3 MM260410216955,0002604101932026-04-292026-04-2925955,000332605100812026-05-0672026-05-06On time
2604000892026-04-07PERSEDIAAN UMUM6030.259PAVING BLOCK PERSEGI PANJANG 80X105X210 MM (K-400)2604004992,0002604004992026-04-292026-05-2840,0002,000222606001662026-06-05372026-06-04Late
2604000892026-04-07PERSEDIAAN UMUM6030.259PAVING BLOCK PERSEGI PANJANG 80X105X210 MM (K-400)2604004992,0002604004992026-04-292026-05-2840,0002,000222606000392026-06-02342026-06-04On time
← PrevPage 12 of 135Next →Rows per page:1020501005001000