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
2604002642026-04-18PERSEDIAAN UMUM6030.0964SHOK BET 8 MM26040044540,540.542604004452026-04-242026-04-24140,540.5462026-05-01Overdue
2604002642026-04-18PERSEDIAAN UMUM6050.13TANG KOMBINASI26050038953,2502604004452026-04-242026-04-24348,00062026-05-01Overdue
2604002642026-04-18PERSEDIAAN UMUM6030.0776TANG POTONG26050033553,2502604004452026-04-242026-04-24342,50062026-05-01Overdue
2604002642026-04-18PERSEDIAAN UMUM6050.0406KUNCI L BINTANG26061014155,1002604004452026-04-242026-04-241170,00062026-05-01Overdue
2604002952026-04-18SPAREPART5017.0305INVERTER MITSUBISHI FR-D740-1.5K2604005453,150,0002604004402026-04-242026-04-2463,150,00062604011512026-04-3062026-05-01On time
2604003012026-04-18PERSEDIAAN UMUM6050.1762BAUT L SS M 5X102604004536802604004532026-04-242026-05-0410068062605001552026-05-06122026-05-11On time
2604100452026-04-17PERSEDIAAN UMUM6030.0486MATA GERINDA POLISH 4 INCH2605100307,5002604101742026-04-242026-05-053007,50072605104132026-05-16222026-05-12Late
2604100492026-04-20PERSEDIAAN UMUM6050.1759KAMPER BULAT26041016717,3002604101672026-04-242026-05-051017,30042604105472026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.0917SAPU LANTAI (PLASTIK)26061008020,0002604101662026-04-242026-05-052120,00042604105482026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6030.0576WIPER WATER LANTAI26041016623,0002604101662026-04-242026-05-052223,00042604105482026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.1755SUNLIGHT 435ML2604101676,6002604101672026-04-242026-05-0556,60042604105472026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.1754SPON PIRING KAWAT2604101676,0002604101672026-04-242026-05-0556,00042604105472026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.0062KANEBO26061008012,0002604101662026-04-242026-05-05612,00042604105482026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.129KESET LANTAI26041016733,0002604101672026-04-242026-05-05833,00042604105472026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.0066SIKAT WC26041016612,0002604101662026-04-242026-05-05112,00042604105482026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.1751SIKAT WC BULAT26041016612,0002604101662026-04-242026-05-05212,00042604105482026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.0052TEMPAT SAMPAH26061009428,0002604101662026-04-242026-05-05135,00042604105482026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.1736SOKLIN LANTAI 800 ML26041016710,2892604101672026-04-242026-05-051810,28942604105472026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.1758WIPOL 750ML2604101679,6002604101672026-04-242026-05-0589,60042604105472026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.1753SPON PIRING2604101676,8002604101672026-04-242026-05-05106,80042604105472026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.092PENGKI26061008012,0002604101662026-04-242026-05-05138,00042604105482026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.0785SAPU INJUK26061008025,0002604101662026-04-242026-05-05325,00042604105482026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.0041PEL SUMBU26061008022,0002604101662026-04-242026-05-05614,00042604105482026-04-2952026-05-12On time
2604100492026-04-20PERSEDIAAN UMUM6050.0039SAPU LIDI26061008012,0002604101662026-04-242026-05-0567,00042604105482026-04-2952026-05-12On time
2603003692026-03-25BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502604004372026-04-232026-05-1060,0001,645292026-05-17Overdue
2603004562026-03-31SPAREPART5027.0216PULLY B1-10" KONDE 30 MM 254MM26040043562604004352026-04-232026-06-251506232606003882026-06-10482026-07-02On time
2603004562026-03-31SPAREPART5027.0331MOTOR + GEAR REDUCER 1/4 HP (NO. 9)2604004353002604004352026-04-232026-06-254300232606003882026-06-10482026-07-02On time
2603004562026-03-31SPAREPART5027.0243AS TONG AGITATOR (300 LTR) 980 MM X OD 30 MM2604004352502604004352026-04-232026-06-254250232606003882026-06-10482026-07-02On time
2604000232026-04-02SPAREPART5014.0018WIRE MESH 60 SS304 WIDTH:1200 MM260500158143,833.332604004282026-04-232026-04-302160,000212605000252026-05-0292026-05-07On time
2604000252026-04-02PERSEDIAAN UMUM6050.1687WATER CHILLER2604004291,621.252604004292026-04-232026-05-1827,0001,621.25212605006882026-05-21282026-05-25On time
2604000262026-04-02PERSEDIAAN UMUM6050.1687WATER CHILLER2604004291,621.252604004292026-04-232026-05-1845,0001,255.25212605006882026-05-21282026-05-25On time
2604002382026-04-17FIXED ASSETSAST02757KURSI LIPAT HITAM (5 PCS)260400424250,0002604004242026-04-232026-04-2350250,00062605001422026-05-06132026-04-30Late
2604002422026-04-17PERSEDIAAN UMUM6030.2912DOUBLE NEPLE 1/2 X 3/82604004317,207.212604004312026-04-232026-04-23107,207.2162026-04-30Overdue
2604002932026-04-20BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002604004342026-04-232026-05-0650074,00032605001852026-05-07142026-05-13On time
2604002932026-04-20BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002604004342026-04-232026-05-0650074,00032606001742026-06-05432026-05-13Late
2604002932026-04-20BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002604004342026-04-232026-05-0650074,00032604009722026-04-2742026-05-13On time
2604100452026-04-17PERSEDIAAN UMUM6050.0687OXYGEN /O2 (Refill, Capacity 6 m3/ 40L/ Pressure 150 bar industrial Grade Purity 99,6%)26061011063,0002604101562026-04-232026-05-041063,00062604105072026-04-2742026-05-11On time
2604100492026-04-20PERSEDIAAN UMUM6050.1092PLASTIK WRAPPING 50CM @200M/ROLL26041014882,5002604101482026-04-232026-04-3024082,50032604104652026-04-2412026-05-07On time
2604100502026-04-20STATIONERY6010.0539LAKBAN BENING 2 INCI / 48MM2605003228,0002604101552026-04-232026-04-302007,80032604105342026-04-2852026-05-07On time
2601101192026-02-20SPAREPART5029.0491DUMPER VALVE+FLANGE+BOLT,RING,NUT M14X70MM DUCTING DIAMETER 8002604102268,897,3102604102262026-04-222026-04-3018,897,310612026-05-07Overdue
2603003042026-03-23PERSEDIAAN UMUM6050.1666AUTOSOL / PEMOLES LOGAM26040043322,0002604004332026-04-222026-05-02222,000302604009572026-04-2532026-05-09On time
2603003862026-03-27BAHAN BAKU GLAZE1099.0027SODIUM FELDSPAR 325 MESH2604004052,468.452604004052026-04-222026-05-2081,0002,468.45262605000122026-05-02102026-05-27On time
2603100142026-03-05SPAREPART5012.0243OIL SEAL 65X85X1026041014245,0002604101422026-04-222026-04-303045,000482604105082026-04-2752026-05-07On time
2603100292026-03-11PERSEDIAAN UMUM6030.2458CAT AVIAN SYNTHETIC 1942604101321,219,5812604101322026-04-222026-04-2261,219,581422605104322026-05-18262026-04-29Late
2603100492026-03-27PERSEDIAAN UMUM6030.0803KAWAT LAS LB 52 OD 3.2 MM26060012341,531.532604101352026-04-222026-04-222043,300262604105602026-04-2972026-04-29On time
2603100542026-03-27BAHAN BAKAR4020.0001BATU BARA ADB 6100 - 63002606101611,7002604101412026-04-222026-04-22100,0001,750262604105022026-04-2752026-04-29On time
2603100542026-03-27BAHAN BAKAR4020.0001BATU BARA ADB 6100 - 63002606101611,7002604101412026-04-222026-04-22100,0001,750262604105162026-04-2862026-04-29On time
2604000312026-04-02SPAREPART5023.1568SERVO TRANSFORMER MODEL SET-5500 50/60HZ INPUT 360-240V OUTPUT 200-222604004164,750,0002604004162026-04-222026-05-1824,750,000202606003322026-06-09482026-05-25Late
2604000362026-04-02PERSEDIAAN UMUM6050.1689SLINGBAG CLEANING SERVIS26040041773,905.672604004172026-04-222026-04-29373,905.67202604011452026-04-3082026-05-06On time
2604000362026-04-02PERSEDIAAN UMUM6050.0778ALAT DETEKSI LOGAM260400417261,271.52604004172026-04-222026-04-292261,271.5202604011452026-04-3082026-05-06On time
2604000512026-04-02SPAREPART5010.0026AIR FILTER 6.2185.02604003983,197,7002604003982026-04-222026-06-2233,197,700202604009202026-04-2422026-06-29On time
2604000512026-04-02BAHAN BAKAR4040.0031OIL FILTER 6.1979.02604003985,649,1002604003982026-04-222026-06-2225,649,100202604009202026-04-2422026-06-29On time
2604000512026-04-02BAHAN BAKAR4040.0032OIL SEPARATOR FILTER 6.2132.026040039824,551,4002604003982026-04-222026-06-22124,551,400202604009202026-04-2422026-06-29On time
2604000512026-04-02BAHAN BAKAR4040.0003OIL SIGMA LUBRICANT 9.5409.000202605003926,887,5002604003982026-04-222026-06-2248,070,750202604009202026-04-2422026-06-29On time
2604000512026-04-02SPAREPART5010.0071SUCTION HOSE KAESER 9.3486.100102604003986,728,0002604003982026-04-222026-06-2216,728,000202606000882026-06-03422026-06-29On time
2604000572026-04-06SPAREPART5032.1485TIMMING BELT C16BB-16BB010-Z0A196526040040954.12604004092026-04-222026-07-22254.1162606004772026-06-12512026-07-29On time
2604000572026-04-06SPAREPART5032.1486ALTERNATOR 24V C11BB-11BB003+A260400409264.232604004092026-04-222026-07-221264.23162606004772026-06-12512026-07-29On time
2604000592026-04-06SPAREPART5032.1489NUT NO. 03 B4223-000122604004090.142604004092026-04-222026-07-22160.14162606004772026-06-12512026-07-29On time
2604000592026-04-06SPAREPART5032.149BOLT NO. 04 H24N4-320212604004090.142604004092026-04-222026-07-22160.14162606004772026-06-12512026-07-29On time
2604000592026-04-06SPAREPART5032.1488WASHER LOCK NO. 02 B5050-000122604004090.142604004092026-04-222026-07-22160.14162606004772026-06-12512026-07-29On time
2604000592026-04-06SPAREPART5032.1491RIM INSIDE NO. 05 H24N4-3200126040040921.82604004092026-04-222026-07-22221.8162606004772026-06-12512026-07-29On time
2604000592026-04-06SPAREPART5032.1487RIM OUTSIDE NO. 01 H24N4-3201126040040921.82604004092026-04-222026-07-22221.8162606004772026-06-12512026-07-29On time
2604000602026-04-06SPAREPART5032.1494BRAKE SHOE NO. 112604004094.92604004092026-04-222026-07-22164.9162606004772026-06-12512026-07-29On time
2604000602026-04-06SPAREPART5032.1492HOSE NO. 10 05C1489260400409182604004092026-04-222026-07-22218162606004772026-06-12512026-07-29On time
2604000602026-04-06SPAREPART5032.1493HOSE NO. 10 05C170726040040918.52604004092026-04-222026-07-22218.5162606004772026-06-12512026-07-29On time
2604000612026-04-07SPAREPART5030.1826DUST HOPPER I 200647120260400408323.952604004082026-04-222026-07-224323.95152026-07-29Outstanding
2604000612026-04-07SPAREPART5030.1827DUST HOPPER II 200647125260400408397.12604004082026-04-222026-07-222397.1152026-07-29Outstanding
2604000612026-04-07SPAREPART5030.1825SUPPORT CHANNEL 20001183926040040844.652604004082026-04-222026-07-221644.65152026-07-29Outstanding
2604000672026-04-07PERSEDIAAN UMUM6050.1703TIMBANGAN MINI DIGITAL26040041785,3402604004172026-04-222026-04-29185,340152604011452026-04-3082026-05-06On time
2604000852026-04-08SPAREPART5023.1569HEAVY DUTY CONNECTOR MALE FEMALE 16 PIN + SOCKET2604004098.852604004092026-04-222026-07-2258.85142606004772026-06-12512026-07-29On time
2604001232026-04-10SPAREPART5017.0341KOTAK BLOCK SCHNEIDER TYPE GVAE11260400421125,0002604004212026-04-222026-05-0510125,000122026-05-12Overdue
2604001482026-04-13SPAREPART5030.0763PINION 8Q1223004730126040042616.52604004262026-04-222026-10-30216.592026-11-06Outstanding
2604001482026-04-13SPAREPART5030.1178PINION 8Q1223004740126040042552.512604004252026-04-222026-10-30252.5192026-11-06Outstanding
2604001482026-04-13SPAREPART5030.0274CYLINDER 8QC20401.0062260400425105.072604004252026-04-222026-10-302105.0792026-11-06Outstanding
2604001482026-04-13SPAREPART5030.0299CONNECTION 202501712604004250.592604004252026-04-222026-10-3020.5992026-11-06Outstanding
2604001482026-04-13SPAREPART5030.0271CYLINDER C20401.0086260400425862604004252026-04-222026-10-3028692026-11-06Outstanding
2604001482026-04-13SPAREPART5030.0786CYLINDER 8QC20401.0088260400425108.732604004252026-04-222026-10-304108.7392026-11-06Outstanding
2604001492026-04-13SPAREPART5030.0577REDUCTION GEAR 8QC15312.0004260400426135.82604004262026-04-222026-10-302135.892026-11-06Outstanding
2604001492026-04-13SPAREPART5030.0229PULLEY 18.05.00.026.0126040042636.382604004262026-04-222026-10-30336.37792026-11-06Outstanding
2604001492026-04-13SPAREPART5030.0576MOTOR KIT INCL. FAN / FAN COVER 8QP07008.1064 EX-C15003.0016260400426232.82604004262026-04-222026-10-303232.892026-11-06Outstanding
2604001492026-04-13SPAREPART5030.1361SENSOR 8QE04401.0007 EX-8QE04401.0006260400426484.92604004262026-04-222026-10-303484.992026-11-06Outstanding
2604001502026-04-13SPAREPART5030.0256PINION 8Q1315000350126040042612.132604004262026-04-222026-10-301012.12592026-11-06Outstanding
2604001502026-04-13SPAREPART5030.0714CONNECTION 8Q1332018S226040042615.042604004262026-04-222026-10-30815.03592026-11-06Outstanding
2604001502026-04-13SPAREPART5030.1331ROLLER 8Q1332037002604004261.412604004262026-04-222026-10-30401.40792026-11-06Outstanding
2604001502026-04-13SPAREPART5030.0124DRIVER REPLACING KIT 8QQ00509.0108 EX-8QE10402.0004260400425907.922604004252026-04-222026-10-301907.9292026-11-06Outstanding
2604001502026-04-13SPAREPART5030.0258PINION 13328140026040042610.382604004262026-04-222026-10-301010.37992026-11-06Outstanding
2604001502026-04-13SPAREPART5030.0527SENSOR 8QE04322.000726040042613.162604004262026-04-222026-10-30513.16292026-11-06Outstanding
2604001502026-04-13SPAREPART5030.0713CONNECTION 8Q1332018D226040042615.042604004262026-04-222026-10-30815.03592026-11-06Outstanding
2604001502026-04-13SPAREPART5030.1335READER 8QE04340.0002260400426552.92604004262026-04-222026-10-301552.992026-11-06Outstanding
2604001502026-04-13SPAREPART5030.0528PHOTOCELL 8QE04332.0006 EX-E04332.000726040042664.512604004262026-04-222026-10-301064.50592026-11-06Outstanding
2604001502026-04-13SPAREPART5030.0253CHAIN 13320480026040042672.752604004262026-04-222026-10-30472.7592026-11-06Outstanding
2604001552026-04-13SPAREPART5026.0169680090436 TUBO FIMO UNILASTIC RPN 0084 DI=63 DE=66260400407400,0002604004072026-04-222026-06-22100400,00092606001412026-06-04432026-06-29On time
2604001562026-04-13SPAREPART5026.0136SOLENOID VALVE SMC 9640100139 || VT307E-5DZ1-01F-Q260500203896,5262604004062026-04-222026-06-222876,93392605007012026-05-21292026-06-29On time
2604001582026-04-13SPAREPART5029.0467PULLEGIA RIBASS FISSA 8112111431260400407250,0002604004072026-04-222026-06-2220250,00092606001412026-06-04432026-06-29On time
2604001582026-04-13SPAREPART5029.0467PULLEGIA RIBASS FISSA 8112111431260400407250,0002604004072026-04-222026-06-2220250,00092604010532026-04-2862026-06-29On time
2604001592026-04-13SPAREPART5029.0506THERMOCOUPLE CCT+0004537260400426354.052604004262026-04-222026-10-3010354.0592026-11-06Outstanding
2604001592026-04-13SPAREPART5029.0505THERMOCOUPLE CCT+000453626040042644.142604004262026-04-222026-10-301044.13592026-11-06Outstanding
2604001602026-04-13SPAREPART5017.0117STEKER BROCO26060019911,7122604004202026-04-222026-05-04311,711.7192604010282026-04-2862026-05-11On time
2604001602026-04-13SPAREPART5017.012STOP KONTAK 4 LUBANG26061002925,0002604004202026-04-222026-05-04220,720.7292604010282026-04-2862026-05-11On time
2604001632026-04-13SPAREPART5012.0148SEAL TC 35.52.72604004228,7002604004222026-04-222026-05-05158,70092605002142026-05-08162026-05-12On time
← PrevPage 15 of 135Next →Rows per page:1020501005001000