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
2601100402026-01-20BAHAN PACKING3011.0211CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601101202026-01-212026-01-2168,000698.8812601106642026-02-05152026-01-28Late
2601100402026-01-20BAHAN PACKING3011.0212CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601101202026-01-212026-01-2168,000659.5212601107092026-02-07172026-01-28Late
2601100402026-01-20BAHAN PACKING3011.0212CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601101192026-01-212026-01-21100,00062512603102622026-03-13512026-01-28Late
2601100402026-01-20BAHAN PACKING3011.0212CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601101202026-01-212026-01-2168,000659.5212601106642026-02-05152026-01-28Late
2601100402026-01-20BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601101202026-01-212026-01-2150,400698.8812601108772026-02-12222026-01-28Late
2601100402026-01-20BAHAN PACKING3011.0211CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601101192026-01-212026-01-21100,00070512603102622026-03-13512026-01-28Late
2601100402026-01-20BAHAN PACKING3011.0211CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601101202026-01-212026-01-2168,000698.8812601110062026-02-19292026-01-28Late
2601100402026-01-20BAHAN PACKING3011.0206CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601101202026-01-212026-01-2150,400659.5212601106642026-02-05152026-01-28Late
2601100402026-01-20BAHAN PACKING3011.0207CARTON BOX SIDEWRAPS PARIS 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601101202026-01-212026-01-2146,200698.8812601111052026-02-23332026-01-28Late
2601100402026-01-20BAHAN PACKING3011.0211CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601101192026-01-212026-01-21100,00070512601104952026-01-2872026-01-28On time
2601100402026-01-20BAHAN PACKING3011.0206CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601101202026-01-212026-01-2150,400659.5212601108772026-02-12222026-01-28Late
2511004552025-11-29PERSEDIAAN UMUM6020.0109KABEL NYYHY 4 X 2.5 MM26051005533,6942601003672026-01-222026-01-2220035,155.86542601010192026-01-2972026-01-29On time
2512002502025-12-15SPAREPART5017.0209PILOT LAMP SCHNEIDER HIJAU 220 VAC26010036950,0002601003692026-01-222026-01-222050,000382601009112026-01-2752026-01-29On time
2512002502025-12-15PERSEDIAAN UMUM6020.0103KABEL NYAF 1X0.75 MM260600150303,603.62601003652026-01-222026-01-221266,666.67382601010212026-01-2972026-01-29On time
2512002502025-12-15SPAREPART5017.0054FUJI CONTACTOR SC 0/220 V260500161220,0002601003702026-01-222026-01-2220220,000382601012212026-02-04132026-01-29Late
2512002502025-12-15SPAREPART5017.0208PILOT LAMP SCHNEIDER MERAH 220 VAC26010044048,0002601003692026-01-222026-01-222050,000382601009112026-01-2752026-01-29On time
2512003842025-12-23SPAREPART5027.0386WATERPASS 300 MM MAGNETIC26051017165,0002601003682026-01-222026-01-222182,599.5302601008952026-01-2752026-01-29On time
2512004872025-12-31FIXED ASSETSAST02575JANZ THERMAL PRINTER TRANSFER LABEL JZ-XT 1002601003661,880,0002601003662026-01-222026-01-2221,880,000222601011382026-02-02112026-01-29Late
2512005092025-12-31BAHAN PEMBANTU20RO.0062JUVE B H12KEP 15 D26010037611,990,0002601003762026-01-222026-01-31111,990,000222606005732026-06-151442026-02-07Late
2512005092025-12-31BAHAN PEMBANTU20RO.0061JUVE A H12GS333726010037611,990,0002601003762026-01-222026-01-31111,990,000222606005732026-06-151442026-02-07Late
2512100372025-12-12PERSEDIAAN UMUM6050.1311HEX HEAD SELF DRILLING SCREW M10X16260110171205,0002601101712026-01-222026-02-031205,000412601104552026-01-2752026-02-10On time
2512100372025-12-12PERSEDIAAN UMUM6050.1177HEX HEAD SELF DRILLING SCREW M5X20260110171205,0002601101712026-01-222026-02-031205,000412601104552026-01-2752026-02-10On time
2601000092026-01-02SPAREPART5027.0222BRUSH WHEEL / FLAP DISC 150X40X50 TMC-SVF26050045389,0002601003892026-01-222026-02-28720420–––2026-03-07Overdue
2601000092026-01-02SPAREPART5019.0344DISC DISCO OD 147 MM//ID 45 MM26010038929.92601003892026-01-222026-02-28229.920–––2026-03-07Overdue
2601000092026-01-02SPAREPART5019.0343MOTOR DISCO "SAMITE" TYPE : BPM90S - 2 // 1000-5000 RPM2601003891,0752601003892026-01-222026-02-2821,07520–––2026-03-07Overdue
2601000452026-01-06PERSEDIAAN UMUM6030.2523KLEM SELANG SUPERIOR HEAVY DUTY 136-144 MM26010037530,405.412601003752026-01-222026-01-311030,405.41162601009312026-01-2752026-02-07On time
2601001212026-01-10PERSEDIAAN UMUM6030.2564PLAT BAJA STRIP 9.8X5.8X5400 MM260101168252,252.252601003742026-01-222026-01-221252,252.25122601011342026-02-02112026-01-29Late
2601001612026-01-13BAHAN BAKAR4060.0017HEAVY DUTY GREASE TRIPTECH 7841260100377191,823.92601003772026-01-222026-02-05127.2191,823.992601008782026-01-2642026-02-12On time
2601001722026-01-14PERSEDIAAN UMUM6020.068FLASHDISK 128 GB (SANDISK)260100361170,5002601003612026-01-222026-01-313170,50082601012492026-02-05142026-02-07On time
2601001962026-01-15PERSEDIAAN UMUM6050.0082REFILL PENGHARUM RUANGAN26030016956,3002601003722026-01-222026-01-31429,50072601008032026-01-2312026-02-07On time
2601002272026-01-19SPAREPART5014.0017WIRE MESH #38 60*1 60X1000 MM2601003634.62601003632026-01-222026-01-31604.632601007662026-01-22–2026-02-07On time
2601002272026-01-19SPAREPART5014.0006WIRE MESH #40 80*1 80X1000 MM2605002054.752601003632026-01-222026-01-31604.7532601007662026-01-22–2026-02-07On time
2601002272026-01-19SPAREPART5014.0007WIRE MESH #40 80*12 80X1200 MM2603003915.62601003632026-01-222026-01-31605.632601007662026-01-22–2026-02-07On time
2601002312026-01-20PERSEDIAAN UMUM6030.122KABEL NYYHY 4X16 MM (SUPREME)260500194198,5002601003592026-01-222026-01-3170187,50022601008012026-01-2312026-02-07On time
2601002392026-01-20PERSEDIAAN UMUM6030.0634NITROGEN 150 BAR260100371180,0002601003712026-01-222026-01-313180,00022601009152026-01-2752026-02-07On time
2601002472026-01-20PERSEDIAAN UMUM6020.0652NA2XSY 1X50SQMM260100379103,0002601003792026-01-222026-01-2260103,00022601008712026-01-2642026-01-29On time
2601002472026-01-20PERSEDIAAN UMUM6020.0653NA2XSY 1X150SQMM260100379505,0002601003792026-01-222026-01-2260505,00022601008712026-01-2642026-01-29On time
2601002602026-01-21BAHAN BAKAR4060.0032SHELL GADUS S3 V220C 22601004861,818,0002601003732026-01-222026-02-0511,818,00012601010242026-01-2972026-02-12On time
2601002622026-01-22PERSEDIAAN UMUM6030.2593GAS CNG 24 JAN - 1 FEB 2026 28.620M³/HARI2601004438,4512601003782026-01-222026-01-22251,8608,451––––2026-01-29Overdue
2601002622026-01-22PERSEDIAAN UMUM6030.2593GAS CNG 24 JAN - 1 FEB 2026 28.620M³/HARI2601004438,4512601004432026-01-222026-01-22251,8608,451––––2026-01-29Overdue
2601100042026-01-05PERSEDIAAN UMUM6050.0237KABEL LAS 70MM26061002085,585.582601101442026-01-222026-01-22200112,000172601107622026-02-09182026-01-29Late
2601100112026-01-06PERSEDIAAN UMUM6030.0642KACA LAS BENING2606100226752601101552026-01-222026-01-2250805162601105252026-01-2862026-01-29On time
2601100112026-01-06PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002601101482026-01-222026-02-0250017,575162601107172026-02-09182026-02-09On time
2601100112026-01-06PERSEDIAAN UMUM6030.2538TURNBUCKLE SPAN SKRUP M2026011029958,9002601101482026-01-222026-02-02558,900162601107172026-02-09182026-02-09On time
2601100112026-01-06PERSEDIAAN UMUM6030.2537PLAT BAJA 10MM2601101462,368,0002601101462026-01-222026-01-2222,368,000162601104592026-01-2752026-01-29On time
2601100112026-01-06PERSEDIAAN UMUM6030.2536PLAT BAJA 20MM2601101464,728,0002601101462026-01-222026-01-2224,728,000162601104592026-01-2752026-01-29On time
2601100112026-01-06PERSEDIAAN UMUM6030.2532BALL VALVE BRASS 1/2" KITZ260110148156,7502601101482026-01-222026-02-0210156,750162601107172026-02-09182026-02-09On time
2601100112026-01-06PERSEDIAAN UMUM6030.2259APRON LAS26040048799,099.12601101602026-01-222026-02-021075,000162601107462026-02-09182026-02-09On time
2601100112026-01-06SPAREPART5017.012STOP KONTAK 4 LUBANG26061002925,0002601101592026-01-222026-01-222056,228162601107642026-02-09182026-01-29Late
2601100112026-01-06PERSEDIAAN UMUM6030.2522KACA LAS HITAM NO.112605100913,2502601101752026-01-222026-01-22502,244162601105282026-01-2862026-01-29On time
2601100112026-01-06PERSEDIAAN UMUM6030.2238KACA LAS HITAM NO.102605100913,2502601101562026-01-222026-01-22503,254162601105242026-01-2862026-01-29On time
2601100142026-01-07PERSEDIAAN UMUM6030.2549DYNABOLT M16-20026011014916,2442601101492026-01-222026-02-0210016,244152601107492026-02-09182026-02-09On time
2601100142026-01-07PERSEDIAAN UMUM6030.0776TANG POTONG26050033553,2502601101612026-01-222026-02-02352,500152601107442026-02-09182026-02-09On time
2601100142026-01-07PERSEDIAAN UMUM6030.2546BOLT NUT + RING PLATE M12X120MM FULL DRAT2601101496,2482601101492026-01-222026-02-021506,248152601107632026-02-09182026-02-09On time
2601100142026-01-07PERSEDIAAN UMUM6030.2545BOLT NUT + RING PLATE M10X70MM FULL DRAT2601101492,4992601101492026-01-222026-02-021502,499152601107492026-02-09182026-02-09On time
2601100142026-01-07PERSEDIAAN UMUM6030.2544CAT ZINCROMATE AVIAN 97202605100351,260,842.382601101472026-01-222026-01-2221,034,141.44152601111762026-02-27362026-01-29Late
2601100142026-01-07PERSEDIAAN UMUM6050.1271GUNTING ALUMUNIUM26011015066,5002601101502026-01-222026-02-02366,500152601106012026-02-02112026-02-09On time
2601100252026-01-13PERSEDIAAN UMUM6020.0151KABEL NYYHY 4X2.5 MM2606001493,839,5952601101452026-01-222026-01-2233,398,40092601107212026-02-09182026-01-29Late
2601100352026-01-19PERSEDIAAN UMUM6030.2487SIKU 40MM TEBAL 3MM PANJANG 6METER260110154140,0002601101542026-01-222026-01-22245140,00032601105982026-02-02112026-01-29Late
2601100412026-01-21PERSEDIAAN UMUM6050.0938LEM AICA AIBON (KEMASAN 300GRAM)26051017956,0002601101722026-01-222026-02-021049,00012601104542026-01-2752026-02-09On time
2601100412026-01-21PERSEDIAAN UMUM6020.0146WD 4026060016991,5002601101622026-01-222026-02-021575,00012601107432026-02-09182026-02-09On time
2601100412026-01-21PERSEDIAAN UMUM6050.0687OXYGEN /O2 (Refill, Capacity 6 m3/ 40L/ Pressure 150 bar industrial Grade Purity 99,6%)26061011063,0002601101632026-01-222026-02-021563,00012601105112026-01-2862026-02-09On time
2601100422026-01-21BAHAN BAKU GLAZE1030.007ZIRCONIUM SILICATE MC11426051020737,855.882601101512026-01-222026-01-2245,00036,131.1912601109482026-02-16252026-01-29Late
2601100422026-01-21BAHAN BAKU GLAZE1030.007ZIRCONIUM SILICATE MC11426051020737,855.882601101512026-01-222026-01-2245,00036,131.1912601111712026-02-25342026-01-29Late
2601100422026-01-21BAHAN BAKU GLAZE1030.007ZIRCONIUM SILICATE MC11426051020737,855.882601101512026-01-222026-01-2245,00036,131.1912601112522026-02-28372026-01-29Late
2601100422026-01-21BAHAN BAKU GLAZE1030.007ZIRCONIUM SILICATE MC11426051020737,855.882601101512026-01-222026-01-2245,00036,131.1912603100662026-03-04412026-01-29Late
2601100422026-01-21BAHAN BAKU GLAZE1030.007ZIRCONIUM SILICATE MC11426051020737,855.882601101512026-01-222026-01-2245,00036,131.1912603100732026-03-05422026-01-29Late
2512000562025-12-03PERSEDIAAN UMUM6050.0072SAPU DORONG 90 CM260500421113,0002601004272026-01-232026-01-235103,000512601010912026-01-3072026-01-30On time
2512001242025-12-06SPAREPART5030.1716CARD CPU 186 BUS _9995 / 96 25 MHZ 330351162126050040225,237,3212601003902026-01-232026-02-20120,696,478482601010152026-01-2962026-02-27On time
2512001242025-12-06SPAREPART5030.1762MOTHER SIZE BOARD FOR 9995 6 SLOT ALL 3 FILES 330351022626010039039,142,8292601003902026-01-232026-02-20139,142,829482601010152026-01-2962026-02-27On time
2512001532025-12-09PERSEDIAAN UMUM6020.0678HDD WD RED 8TB2601003854,100,0002601003852026-01-232026-01-2324,100,000452601013712026-02-09172026-01-30Late
2512002432025-12-13SPAREPART5032.1423REPAIR KIT, BRAKE PUMP NO. 59 H2MD5-40902XLB26050029282601003942026-01-232026-01-314185,000412601008812026-01-2632026-02-07On time
2512003262025-12-19SPAREPART5017.105LAMPU JALAN PJU SOLAR CELL CMOS 200 WATT260100383755,0002601003832026-01-232026-01-236755,000352601011452026-02-02102026-01-30Late
2512003512025-12-20PERSEDIAAN UMUM6050.0405GERINDA TANGAN 4 INCH MAKITA M0900B260410119337,837.842601003822026-01-232026-01-232350,000342601010972026-01-3072026-01-30On time
2512003512025-12-20PERSEDIAAN UMUM6030.2511MESIN CUTTING LW 1400 (14 INCH)2601003804,238,288.292601003802026-01-232026-01-2314,238,288.29342601009412026-01-2742026-01-30On time
2512003532025-12-20PERSEDIAAN UMUM6020.0086KEYBOARD260500013105,0002601003852026-01-232026-01-233112,000342601013712026-02-09172026-01-30Late
2512003532025-12-20PERSEDIAAN UMUM6020.0059MOUSE KOMPUTER26030051154,054.052601003852026-01-232026-01-23360,000342601013712026-02-09172026-01-30Late
2512003532025-12-20PERSEDIAAN UMUM6020.0728GIGABIT PASSIVE POE NYK26010038560,0002601003852026-01-232026-01-23360,000342601013712026-02-09172026-01-30Late
2512003532025-12-20PERSEDIAAN UMUM6020.0724WEBCAM260100385260,0002601003852026-01-232026-01-233260,000342601013712026-02-09172026-01-30Late
2512003532025-12-20PERSEDIAAN UMUM6020.0725USB HUB WITH POWER INPUT260100385195,0002601003852026-01-232026-01-233195,000342601013712026-02-09172026-01-30Late
2512003532025-12-20PERSEDIAAN UMUM6020.0721POWER SUPPLY 12V DC 5 AMPERE OUTPUT JACK DC 5.5 MM26010038555,0002601003852026-01-232026-01-23355,000342601013712026-02-09172026-01-30Late
2512003652025-12-22FIXED ASSETSAST02558PRINT ZANASI MODEL Z303 100-120/200-240V 50-60 HZ 2.43 A 290 VA 1 PH26010039135,000,0002601003912026-01-232026-02-10135,000,000322603008692026-03-26622026-02-17Late
2512004092025-12-26PERSEDIAAN UMUM6030.2514GLASS BLOCK 140X80 MM26030034822,522.522601003812026-01-232026-01-2311222,522.52282601011372026-02-02102026-01-30Late
2601000402026-01-06SPAREPART5026.0178FLOJET DIAPHRAGM PUMP KAPASITAS 19 L/ MIN, 6.9 BAR2605002532,995,0002601004292026-01-232026-02-0522,500,000172601010732026-01-3072026-02-12On time
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601004032026-01-232026-02-051,00047,000182601013152026-02-07152026-02-12On time
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601004032026-01-232026-02-051,00047,000182601014422026-02-11192026-02-12On time
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601004032026-01-232026-02-051,00047,000182601015032026-02-12202026-02-12On time
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601004032026-01-232026-02-051,00047,000182604003342026-04-10772026-02-12Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601004032026-01-232026-02-051,00047,000182601012852026-02-06142026-02-12On time
2601000622026-01-07PERSEDIAAN UMUM6030.2539RESIBON POTONG 14X1/8X1 INCH26030010254,009.012601003802026-01-232026-01-231054,009.01162601009412026-01-2742026-01-30On time
2601000722026-01-08PERSEDIAAN UMUM6030.2555DOUBLE NEPEL 3/4 INCH26040033719,0002601003842026-01-232026-01-235017,500152601010012026-01-2962026-01-30On time
2601000722026-01-08PERSEDIAAN UMUM6030.2553T BOW 1 INCH KE 3/4 INCH26010038420,0002601003842026-01-232026-01-232020,000152601010012026-01-2962026-01-30On time
2601000722026-01-08PERSEDIAAN UMUM6030.2555DOUBLE NEPEL 3/4 INCH26040033719,0002601003842026-01-232026-01-235017,500152601010312026-01-2962026-01-30On time
2601000722026-01-08PERSEDIAAN UMUM6030.2554ELBOW 3/4 INCH2601008204,0002601003842026-01-232026-01-235017,500152601010012026-01-2962026-01-30On time
2601000732026-01-08SPAREPART5031.0662BALLVALVE 3/4 INCH ONDA260400283114,864.872601003802026-01-232026-01-2350114,864.86152601009412026-01-2742026-01-30On time
2601000922026-01-08PERSEDIAAN UMUM6050.0371HYGRO-THERMOMETER26010040245,0002601004022026-01-232026-02-05145,000152601008742026-01-2632026-02-12On time
2601001052026-01-09SPAREPART5025.0041PANGKON SUPPORT KOTAK ORANGE260100408110,0002601004082026-01-232026-02-1025110,000142601019102026-02-23312026-02-17Late
2601001072026-01-09PERSEDIAAN UMUM6060.065RING PLAT M 302601004262,9002601004262026-01-232026-01-2382,900142601008432026-01-2412026-01-30On time
2601001072026-01-09PERSEDIAAN UMUM6060.0661BAUT M 30X10026010042631,2002601004262026-01-232026-01-232031,200142601008432026-01-2412026-01-30On time
2601001072026-01-09PERSEDIAAN UMUM6060.0651RING PIR M 302601004263,8502601004262026-01-232026-01-2383,850142601008432026-01-2412026-01-30On time
← PrevPage 47 of 135Next →Rows per page:1020501005001000