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
2604100082026-04-06PERSEDIAAN UMUM6050.0872REFIL KUAS ROLL 4 INCH2605101551,1372604100612026-04-112026-04-1781,79952604103342026-04-1872026-04-24On time
2604100092026-04-07PERSEDIAAN UMUM6030.0469CAT BESI BIRU TUA26041005695,0002604100562026-04-112026-04-17195,00042604102142026-04-1432026-04-24On time
2604100092026-04-07PERSEDIAAN UMUM6030.051CAT PILOK PUTIH26041005635,0002604100562026-04-112026-04-17535,00042604102142026-04-1432026-04-24On time
2604100102026-04-07PERSEDIAAN UMUM6030.2875MATA ROOFING 10MM26041006923,6642604100692026-04-112026-04-17223,66442604102242026-04-1432026-04-24On time
2604100112026-04-07PERSEDIAAN UMUM6030.1784WD POLES 4 INCHI2606100427,5002604100582026-04-112026-04-173007,50042604105622026-04-29182026-04-24Late
2604100112026-04-07PERSEDIAAN UMUM6030.1791WD CUTTING 4 INCH2606100423,3002604100582026-04-112026-04-173003,00042604104352026-04-22112026-04-24On time
2604100112026-04-07PERSEDIAAN UMUM6050.0737LPG 12KG ( REFILL )260610118230,0002604100572026-04-112026-04-172200,00042604104392026-04-22112026-04-24On time
2604100112026-04-07PERSEDIAAN UMUM6050.1102LEM RUBBER SUNPAT - S + HARDENER BANDO @ 1 KG U/ SAMBUNG CONVEYOR260410059529,5002604100592026-04-112026-04-1710529,50042026-04-24Overdue
2604100172026-04-08PERSEDIAAN UMUM6030.0622KUAS 4 INCH26050044015,405.412604100602026-04-112026-04-17157,45032604102202026-04-1432026-04-24On time
2604100172026-04-08PERSEDIAAN UMUM6050.0953SAVER 022 FUNGSI : KOAGULAN2606101264,5502604100682026-04-112026-04-172,6003,70032604103332026-04-1872026-04-24On time
2604100172026-04-08PERSEDIAAN UMUM6050.0953SAVER 022 FUNGSI : KOAGULAN2606101264,5502604100682026-04-112026-04-172,6003,70032604102252026-04-1432026-04-24On time
2604100172026-04-08PERSEDIAAN UMUM6050.0954SAVER A-22626061012665,0002604100682026-04-112026-04-174565,00032604102252026-04-1432026-04-24On time
2604100202026-04-08PERSEDIAAN UMUM6020.0659CARBON BRUSH (BOSCH) GWS 70026041006220,0002604100622026-04-112026-04-172520,00032604104362026-04-22112026-04-24On time
2603000792026-03-07SPAREPART5021.0464TIMMING BELT NO 18 100081587_100AT20-13740+2MMAPL/A022604001922,1322604001922026-04-102026-06-0622,132342026-06-13Overdue
2603000802026-03-07SPAREPART5030.1804SQUARING HEAD NO 09 2007995352604001926,3792604001922026-04-102026-06-0636,379342026-06-13Overdue
2603000802026-03-07SPAREPART5030.1805PNEUMATIC CHAMFERING HEAD NO 14 2002518942604001922,6212604001922026-04-102026-06-0612,621342026-06-13Overdue
2603000802026-03-07SPAREPART5030.1319MOTORIZED WIDTH ADJUSTER GAMBAR NO.6 KATALOG NCGBSH1000/26+226040019220,4312604001922026-04-102026-06-06120,431342026-06-13Overdue
2603000812026-03-07SPAREPART5030.1807SERVO INOVANCE INO.SV660PT021T2604001926,7242604001922026-04-102026-06-0616,724342026-06-13Overdue
2603001162026-03-09SPAREPART5030.1313TIMINGBELT 30T10 // 1000526612604001831,277.82604001832026-04-102026-06-0611,277.8322026-06-13Overdue
2603001162026-03-09SPAREPART5030.1306TIMINGBELT _100AT20-13740+2MMAPL/A02 // 1000815872605002022,061.12604001832026-04-102026-06-0652,061.1322026-06-13Overdue
2603001162026-03-09SPAREPART5030.1312TIMING BELT -75AT20-10760+6MMAPL/02 // 1000826842605002021,138.92604001832026-04-102026-06-0651,138.9322026-06-13Overdue
2603004152026-03-27SPAREPART5023.0001SCRAPER CAF17505006260400182252604001822026-04-102026-06-302025142026-07-07Outstanding
2603004452026-03-31SPAREPART5026.0014PURITY WIPES 9" X 9" 90008614 (1 PACK = 100 SHEETS)260400181280,2502604001812026-04-102026-04-3010280,250102604005462026-04-1662026-05-07On time
2603004462026-03-31PERSEDIAAN UMUM6050.1684TAGOUT LOTO (BAHASA INDONESIA)2604001959,3502604001952026-04-102026-04-1959,350102604004362026-04-1332026-04-26On time
2603004582026-03-31SPAREPART5029.0235HOSE (SELANG GAS KILN) CC211100012604001828.452604001822026-04-102026-06-30508.45102026-07-07Outstanding
2603100422026-03-16PERSEDIAAN UMUM6050.0171ACRYLIC KOBIN()26040016516,349.32604001652026-04-102026-04-125016,349.3252026-04-19Overdue
2603100532026-03-26BAHAN PEMBANTU3045.0002PALLET EKSPORT BARU 110*110*10260410098105,0002604100702026-04-102026-04-1070105,000152606102652026-06-10612026-04-17Late
2604000162026-04-01SPAREPART5017.1092AUXILIARY SC-N1260400173100,0002604001732026-04-102026-04-1010100,00092604005662026-04-1772026-04-17On time
2604000162026-04-01SPAREPART5017.0324AUTONIC TEMPERATURE CONTROL TZ4L-14C260400174875,0002604001742026-04-102026-04-1010875,00092604008232026-04-22122026-04-17Late
2604000162026-04-01SPAREPART5017.0075FUJI AUXILIARY SZ A-22260600198142,5002604001732026-04-102026-04-1010174,50092604005662026-04-1772026-04-17On time
2604000162026-04-01SPAREPART5017.1019MOTOR PROTECTION SCHNEIDER TYPE GV2ME08260500287490,0002604001742026-04-102026-04-1015545,00092604005762026-04-1772026-04-17On time
2604000162026-04-01SPAREPART5017.1093THERMAL OVERLOAD RELAY TR-N3/3 24-36A260400174509,0002604001742026-04-102026-04-105509,00092604005762026-04-1772026-04-17On time
2604000162026-04-01SPAREPART5017.0055FUJI MAGNETIC CONTACTOR SC N1/220 V260400174645,0002604001742026-04-102026-04-1010645,00092604005762026-04-1772026-04-17On time
2604000162026-04-01SPAREPART5017.0288THERMO CONTROL OMRON E5CC-RX 3A5M-0002604001741,670,0002604001742026-04-102026-04-10101,670,00092605003482026-05-11312026-04-17Late
2604000162026-04-01SPAREPART5017.0288THERMO CONTROL OMRON E5CC-RX 3A5M-0002604001741,670,0002604001742026-04-102026-04-10101,670,00092026-04-17Overdue
2604000162026-04-01SPAREPART5017.0288THERMO CONTROL OMRON E5CC-RX 3A5M-0002604001741,670,0002604001742026-04-102026-04-10101,670,00092604010342026-04-28182026-04-17Late
2604000162026-04-01SPAREPART5017.0288THERMO CONTROL OMRON E5CC-RX 3A5M-0002604001741,670,0002604001742026-04-102026-04-10101,670,00092604008232026-04-22122026-04-17Late
2604000562026-04-06SPAREPART5032.1071AIR FILTER P 548062260400193260,0002604001932026-04-102026-04-193260,00042604004482026-04-1442026-04-26On time
2604000562026-04-06SPAREPART5032.1483ACCU / BATTERAY 115E 4IR/NS120 (12V-120AH)2604001942,050,0002604001942026-04-102026-04-1722,050,00042604005272026-04-1552026-04-24On time
2604000562026-04-06SPAREPART5032.009MINYAK REM 1000 ML26050033360,0002604001932026-04-102026-04-191260,00042604004482026-04-1442026-04-26On time
2604000742026-04-07PERSEDIAAN UMUM6050.1711PASTA MINYAK SOLAR26040019657,0002604001962026-04-102026-04-17157,00032604004352026-04-1332026-04-24On time
2604000932026-04-09STATIONERY6010.0444TINTA EPSON 003 CYAN 65ML26060002783,0002604002072026-04-102026-04-17483,00012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0573TIPE X / STIPO CAIR2604002074,9002604002072026-04-102026-04-1724,90012604010262026-04-28182026-04-24Late
2604000932026-04-09STATIONERY6010.0572TIPE X / STIPO KERTAS2604002075,4002604002072026-04-102026-04-1725,40012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0139STABILO KUNING2606000279,3002604002072026-04-102026-04-1759,30012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0243PAPER CLIP NO 52604002074,0002604002072026-04-102026-04-1724,00012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.016PENGHAPUS PENSIL PENSIL, 1.5 X 3.0 CM2604002072,2002604002072026-04-102026-04-1742,20012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0445BATERAI ALKALINE GP AA 1.5V ISI 626050002525,8002604002072026-04-102026-04-171225,80012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0441TINTA EPSON 003 BLACK 65ML26060002783,0002604002072026-04-102026-04-17483,00012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0154PENGGARIS PLASTIK 30 CM2604002062,0002604002062026-04-102026-04-1752,00012604008922026-04-23132026-04-24On time
2604000932026-04-09STATIONERY6010.0173BINDER CLIP NO. 111 NO. 1112606000273,8002604002072026-04-102026-04-1753,80012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0174BINDER CLIP NO. 155 NO. 1552606100607,2002604002072026-04-102026-04-1775,20012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0442TINTA EPSON 003 YELLOW 65ML26060002783,0002604002072026-04-102026-04-17483,00012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0153PENGGARIS BESI BESI/IRON, 30 CM2604002066,0002604002062026-04-102026-04-1756,00012604008922026-04-23132026-04-24On time
2604000932026-04-09STATIONERY6010.0531DELI STICKY NOTES EA03303 4 Color 51x51mm 4x100sheets2606000276,8002604002072026-04-102026-04-1746,80012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.018TEMPAT PENSIL26060002727,7002604002072026-04-102026-04-17127,70012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0172BINDER CLIP NO. 107 NO. 1072606100603,5002604002072026-04-102026-04-1752,50012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0143TRIGONAL CLIP NO. 32605002611,5002604002062026-04-102026-04-17121,50012604008922026-04-23132026-04-24On time
2604000932026-04-09STATIONERY6010.0716ISI CUTTER A-30026051002334,1202604002072026-04-102026-04-1722,50012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.015ISI CUTTER BESAR L-1502606100606,5002604002072026-04-102026-04-1725,00012604010262026-04-28182026-04-24Late
2604000932026-04-09PERSEDIAAN UMUM6020.005KALKULATOR26060002765,0002604002072026-04-102026-04-17356,00012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0531DELI STICKY NOTES EA03303 4 Color 51x51mm 4x100sheets2606000276,8002604002072026-04-102026-04-1746,80012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0168GUNTING SEDANG2606000276,2002604002072026-04-102026-04-1746,20012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0592LAKBAN COKLAT 48MM2605002618,0002604002072026-04-102026-04-1728,50012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0552LEM KERTAS2606101512,5432604002072026-04-102026-04-17121,90012605002992026-05-09292026-04-24Late
2604000932026-04-09PERSEDIAAN UMUM6020.0037BATERAI ALKALINE AAA isi 626050002524,0002604002072026-04-102026-04-17224,00012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0449MATERAI 10,00026050026011,0002604002052026-04-102026-04-175011,00012604011542026-04-30202026-04-24Late
2604000932026-04-09STATIONERY6010.0667ISOLASI MEJA 1 INCHI2604002063,2002604002062026-04-102026-04-1743,20012604008922026-04-23132026-04-24On time
2604000932026-04-09STATIONERY6010.0443TINTA EPSON 003 MAGENTA 65ML26060002783,0002604002072026-04-102026-04-17483,00012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0016POST IT BESAR2606000278,7002604002072026-04-102026-04-1728,70012605002992026-05-09292026-04-24Late
2604000932026-04-09STATIONERY6010.0191BUKU TULIS BOXY(16*25) 18.5 X 25 CM2605004193,9002604002062026-04-102026-04-1743,90012604008922026-04-23132026-04-24On time
2604000932026-04-09STATIONERY6010.0771TRIGONAL CLIP NO. 12605002611,6002604002062026-04-102026-04-17121,60012604008922026-04-23132026-04-24On time
2604000932026-04-09STATIONERY6010.0001KERTAS A426060024443,0002604002052026-04-102026-04-172043,00012604011542026-04-30202026-04-24Late
2604000972026-04-10PERSEDIAAN UMUM6020.0833MOUSE LOGITECH B10026040043955,0002604001662026-04-102026-04-14154,0002604006102026-04-1772026-04-21On time
2604000972026-04-10PERSEDIAAN UMUM6020.0832KEYBOARD K120260400439105,0002604001662026-04-102026-04-141105,0002604006102026-04-1772026-04-21On time
2604000972026-04-10FIXED ASSETSAST02754MINI PC ASUS NUC 13 PRO i5 13TH GEN (MAGANG PURCHASING)2604001667,950,0002604001662026-04-102026-04-1417,950,0002604006102026-04-1772026-04-21On time
2604000982026-04-10FIXED ASSETSAST02442KURSI STAFF WS 496260500123605,2802604001772026-04-102026-04-172760,0002604008642026-04-23132026-04-24On time
2604000982026-04-10FIXED ASSETSAST02444MEJA STAFF 120X752604001771,404,0002604001772026-04-102026-04-1761,404,0002606002562026-06-08592026-04-24Late
2604000982026-04-10FIXED ASSETSAST02756LOWER CABINET GM2604001772,235,8002604001772026-04-102026-04-1712,235,8002604008632026-04-23132026-04-24On time
2604000982026-04-10FIXED ASSETSAST02447LACI GANTUNG BHD 7305260400177514,0002604001772026-04-102026-04-179514,0002606002562026-06-08592026-04-24Late
2604000982026-04-10FIXED ASSETSAST02755JOINING TABLE MEJA GM260400177550,0002604001772026-04-102026-04-171550,0002606002562026-06-08592026-04-24Late
2604000982026-04-10FIXED ASSETSAST02452FILLING CABINET 3 LACI2604001771,452,7002604001772026-04-102026-04-1711,452,7002026-04-24Overdue
2604100072026-04-07BAHAN PEMBANTU3045.0002PALLET EKSPORT BARU 110*110*10260410098105,0002604100702026-04-102026-04-1025105,00032026-04-17Overdue
2604100192026-04-09PERSEDIAAN UMUM6010.0439KAOS KOBIN MERAH26050033734,5002604001682026-04-102026-04-241,86038,00012605001012026-05-05252026-05-01Late
2604100192026-04-09PERSEDIAAN UMUM6010.0863KAOS KOBIN TILES (HITAM)26040022633,5002604001682026-04-102026-04-2420038,00012605001012026-05-05252026-05-01Late
2601100042026-01-05PERSEDIAAN UMUM6050.0926TRAVO LAS 200 A (DAIDEN)2605100562,600,0002604100492026-04-092026-04-0952,250,450942604102532026-04-1562026-04-16On time
2603001822026-03-11BAHAN PEMBANTU2024.0001OPP 48*10026050005510,4952604001752026-04-092026-04-242,01610,495292604009382026-04-25162026-05-01On time
2603003562026-03-26PERSEDIAAN UMUM6050.1674PARTISI (DEPAN KAMAR MANDI)260400158633,5002604001582026-04-092026-04-121633,500142026-04-19Overdue
2603004312026-03-30PERSEDIAAN UMUM6030.2849HOLLOW SS 201 10X20X1MM P=6M26050003284,684.692604001762026-04-092026-04-095088,288.29102604007602026-04-21122026-04-16Late
2603100432026-03-25PERSEDIAAN UMUM6050.1667Branding Mobil Grandmax2604001622,250,0002604001622026-04-092026-04-1622,250,000152026-04-23Overdue
2603100492026-03-27PERSEDIAAN UMUM6030.1729AVIAN THINNER ENAMEL26061013957,554.172604100802026-04-092026-04-092441,925132605100442026-05-06272026-04-16Late
2603100492026-03-27PERSEDIAAN UMUM6030.1878CAT AVIAN TWILIGHT BLUE KODE 731 @18LITER2606101391,514,692.582604100802026-04-092026-04-0921,219,581132605100442026-05-06272026-04-16Late
2603100502026-03-28PERSEDIAAN UMUM6030.2522KACA LAS HITAM NO.112605100913,2502604100552026-04-092026-04-091003,190122604103412026-04-1892026-04-16Late
2603100502026-03-28PERSEDIAAN UMUM6050.0747HELM SAFETY MSA (PUTIH)26041005381,1002604100532026-04-092026-04-09281,100122604103402026-04-1892026-04-16Late
2603100542026-03-27BAHAN BAKAR4020.0001BATU BARA ADB 6100 - 63002606101611,7002604100502026-04-092026-04-09250,0001,800132026-04-16Overdue
2604000292026-04-02SPAREPART5021.0087V. BELT B - 145260600227115,7002604001912026-04-092026-04-245115,70072604006442026-04-1892026-05-01On time
2604000292026-04-02SPAREPART5021.0087V. BELT B - 145260600227115,7002604002882026-04-092026-04-245115,70072604008162026-04-22132026-05-01On time
2604000292026-04-02SPAREPART5021.0131V. BELT B - 345260400288290,4002604002882026-04-092026-04-246290,40072606000622026-06-03552026-05-01Late
2604000292026-04-02SPAREPART5021.0131V. BELT B - 345260400288290,4002604002882026-04-092026-04-246290,40072604008162026-04-22132026-05-01On time
2604000352026-04-02PERSEDIAAN UMUM6030.0643SELANG AIR 3/4 INCH26040033111,5002604001802026-04-092026-04-195013,20072604003852026-04-1122026-04-26On time
← PrevPage 26 of 135Next →Rows per page:1020501005001000