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
2601001952026-01-15STATIONERY6010.0151ISI STAPLES KECIL #10 KECIL, NO.10-1M2606101511,5922601003462026-01-212026-01-31102,70062601009992026-01-2982026-02-07On time
2601001952026-01-15PERSEDIAAN UMUM6050.1013KARET GELANG PENTIL26010058713,0002601003462026-01-212026-01-31137,00062601009992026-01-2982026-02-07On time
2601001952026-01-15STATIONERY6010.0307PITA PRINTER LX 31026061006016,8002601003462026-01-212026-01-31646,70062601009992026-01-2982026-02-07On time
2601001952026-01-15STATIONERY6010.0241ISI BOLPOIN HITAM2606000277002601003462026-01-212026-01-312470062601009992026-01-2982026-02-07On time
2601001962026-01-15PERSEDIAAN UMUM6050.0038SAPU LANTAI26050042117,0002601003452026-01-212026-01-31216,00062601010922026-01-3092026-02-07On time
2601001962026-01-15PERSEDIAAN UMUM6050.1299PENDORONG AIR26040031640,0002601003452026-01-212026-01-31140,00062601010922026-01-3092026-02-07On time
2601001962026-01-15PERSEDIAAN UMUM6050.1225SABUN COLEK2601003455,5002601003452026-01-212026-01-3115,50062601010922026-01-3092026-02-07On time
2601001962026-01-15PERSEDIAAN UMUM6050.0015PEMBERSIH LANTAI26050042116,0002601003452026-01-212026-01-31116,00062601010922026-01-3092026-02-07On time
2601001962026-01-15PERSEDIAAN UMUM6050.0062KANEBO26061008012,0002601003452026-01-212026-01-31220,00062601010922026-01-3092026-02-07On time
2601001962026-01-15PERSEDIAAN UMUM6050.1298KIT PEMBERSIH MOTOR26040031620,0002601003452026-01-212026-01-31220,00062601010922026-01-3092026-02-07On time
2601001962026-01-15PERSEDIAAN UMUM6050.0017KAPUR BARUS TOILET26050042128,0002601003452026-01-212026-01-31127,00062601010922026-01-3092026-02-07On time
2601001962026-01-15PERSEDIAAN UMUM6050.0151KANTONG KRESEK JUMBO26050042140,0002601003452026-01-212026-01-31338,00062601010922026-01-3092026-02-07On time
2601001972026-01-15SPAREPART5017.0138OMRON SOCKET PYF 14 AN26050016125,0002601003582026-01-212026-02-02822,00062601007982026-01-2322026-02-09On time
2601001972026-01-15SPAREPART5017.029SOCKET TIMER PF 0826010035525,0002601003552026-01-212026-02-02725,00062604003572026-04-10792026-02-09Late
2601001972026-01-15SPAREPART5017.0458PROXIMITY SENSOR SICK IME12-04BNSZCOS260500010397,8002601003532026-01-212026-02-0210397,80062601014162026-02-10202026-02-09Late
2601001972026-01-15SPAREPART5017.0002AUTONICS CONNECTOR JUNCTION CLD3-226050014364,0002601003562026-01-212026-01-31564,00062601009562026-01-2872026-02-07On time
2601001972026-01-15SPAREPART5017.0457PROXIMITY SENSOR SICK IME12-04BPSZCOS260500010397,8002601003532026-01-212026-02-025397,80062601014162026-02-10202026-02-09Late
2601001972026-01-15SPAREPART5017.0054FUJI CONTACTOR SC 0/220 V260500161220,0002601003542026-01-212026-02-025164,00062601008752026-01-2652026-02-09On time
2601001972026-01-15SPAREPART5017.0375OMRON RELAY MY4-N220 VAC26040018452,0002601003552026-01-212026-02-021048,00062604003572026-04-10792026-02-09Late
2601001972026-01-15SPAREPART5017.0376OMRON RELAY MY2-N220 VAC26040018941,8002601003582026-01-212026-02-02336,50062601007982026-01-2322026-02-09On time
2601001972026-01-15SPAREPART5017.0063OMRON TIMER H3CR-A8260500150185,0002601003582026-01-212026-02-022185,00062601007982026-01-2322026-02-09On time
2601001972026-01-15SPAREPART5017.0056FUJI MAGNETIC CONTACTOR SC N3/220 V2601010081,085,0002601003552026-01-212026-02-0231,085,00062604003572026-04-10792026-02-09Late
2601002012026-01-15SPAREPART5030.067MOTOR 0.75 KW 1 HP 1460 RPM 380 V B142605001361,187,5002601003472026-01-212026-01-3121,187,50062601009572026-01-2872026-02-07On time
2601002012026-01-15SPAREPART5019.0006MOTOR 0.37KW 0.5HP 1460 RPM 380V FLANGE B5260500136875,0002601003472026-01-212026-01-312875,00062601009572026-01-2872026-02-07On time
2601002012026-01-15SPAREPART5019.0014MOTOR 0.37 KW 220 V/380V FLANGE MOUNTING B14260500136875,0002601003472026-01-212026-01-312875,00062601009572026-01-2872026-02-07On time
2601002012026-01-15SPAREPART5019.0045MOTOR 3 PHASE B5 0.75 KW 1HP 1460 RPM 220/380 V FLANGE MOUNTING2601010471,187,5002601003472026-01-212026-01-3121,187,50062601009572026-01-2872026-02-07On time
2601002022026-01-15BAHAN BAKAR4060.0032SHELL GADUS S3 V220C 22601004861,818,0002601003422026-01-212026-01-3121,818,00062601010232026-01-2982026-02-07On time
2601002022026-01-15BAHAN BAKAR4060.0024SHELL GADUS S3 T100 22605003344,590,0002601003422026-01-212026-01-3113,492,00062601010232026-01-2982026-02-07On time
2601002022026-01-15BAHAN BAKAR4060.0031SHELL GADUS S3 V460D 22601003412,117,1172601003412026-01-212026-01-3122,117,11762601008602026-01-2652026-02-07On time
2601002072026-01-15SPAREPART5027.0457MARTIN PULLY SPZ 100 - 2 TAPER BUSH 1610 - 28260100350400,0002601003502026-01-212026-01-312400,00062601010062026-01-2982026-02-07On time
2601002182026-01-17PERSEDIAAN UMUM6030.1974CAT AVIAN ZINC CHROMATE 972226010034840,994.62601003482026-01-212026-01-312040,994.642601010272026-01-2982026-02-07On time
2601002182026-01-17PERSEDIAAN UMUM6030.2432CAT AVIAN MATT PURE WHITE PWM26010034857,472.972601003482026-01-212026-01-31557,472.9742601010272026-01-2982026-02-07On time
2601002282026-01-19PERSEDIAAN UMUM6050.015SPRAY PEMBASMI SERANGGA26060016540,0002601003442026-01-212026-01-26232,90022601008052026-01-2322026-02-02On time
2601002292026-01-19PERSEDIAAN UMUM6050.0053CIKRAK PLASTIK26050042117,0002601003432026-01-212026-02-02115,00022601010952026-01-3092026-02-09On time
2601002292026-01-19PERSEDIAAN UMUM6050.0038SAPU LANTAI26050042117,0002601003432026-01-212026-02-02216,00022601010952026-01-3092026-02-09On time
2601002292026-01-19PERSEDIAAN UMUM6050.0067SAPU LIDI TONGKAT26050047511,0002601003432026-01-212026-02-02410,00022601010952026-01-3092026-02-09On time
2601002292026-01-19PERSEDIAAN UMUM6050.0072SAPU DORONG 90 CM260500421113,0002601003432026-01-212026-02-021103,00022601010952026-01-3092026-02-09On time
2601002292026-01-19PERSEDIAAN UMUM6050.1231CIKRAK SENG26050042110,0002601003432026-01-212026-02-02410,00022601010952026-01-3092026-02-09On time
2601002292026-01-19PERSEDIAAN UMUM6050.0016PEMBERSIH KACA2605004218,0002601003432026-01-212026-02-02120,00022601010952026-01-3092026-02-09On time
2601002292026-01-19PERSEDIAAN UMUM6050.0041PEL SUMBU26061008022,0002601003432026-01-212026-02-02245,00022601010952026-01-3092026-02-09On time
2601002292026-01-19PERSEDIAAN UMUM6050.0044SIKAT KAMAR MANDI ( GAGANG PANJANG )26040031640,0002601003432026-01-212026-02-02140,00022601010952026-01-3092026-02-09On time
2601100112026-01-06PERSEDIAAN UMUM6030.0729REFILL BULU ROLL KECIL () 4 INCH2603101269752601101372026-01-212026-01-301503,440152601107482026-02-09192026-02-06Late
2601100142026-01-07PERSEDIAAN UMUM6030.0166KAWAT LAS RB 26 2.6 MM26060001333,333.332601101222026-01-212026-01-2120033,150142601107372026-02-09192026-01-28Late
2601100142026-01-07PERSEDIAAN UMUM6030.0033KAWAT LAS RB 26 3.2 MM26050021729,729.732601101222026-01-212026-01-2120030,850142601107372026-02-09192026-01-28Late
2601100172026-01-08PERSEDIAAN UMUM6050.1278RAMBU K3 "GUNAKAN PELINDUNG PENDENGARAN" (PLANG = 30 X 40 CM TINGGI=180CM)260110127650,0002601101272026-01-212026-02-104650,000132601106122026-02-02122026-02-17On time
2601100172026-01-08PERSEDIAAN UMUM6050.1277RAMBU K3 RISIKO KEBISINGAN ( PLANG = 30 X 40 CM TINGGI=180CM)260110127650,0002601101272026-01-212026-02-104650,000132601106122026-02-02122026-02-17On time
2601100172026-01-08PERSEDIAAN UMUM6050.128RAMBU K3 "BAHAYA MESIN BERPUTAR" (PLANG = 30 X 40 CM TINGGI=180CM)260110127650,0002601101272026-01-212026-02-104650,000132601106122026-02-02122026-02-17On time
2601100172026-01-08PERSEDIAAN UMUM6050.1279RAMBU K3 "AWAS TEGANGAN LISTRIK TINGGI" (STIKER 30X30 CM)26011012735,0002601101272026-01-212026-02-101035,000132601106122026-02-02122026-02-17On time
2601100172026-01-08PERSEDIAAN UMUM6050.1284RAMBU K3 "HATI-HATI LALU LINTAS FORKLIFT" (PLANG = 30 X 40 CM TINGGI = 180 CM)260110127650,0002601101272026-01-212026-02-106650,000132601106122026-02-02122026-02-17On time
2601100172026-01-08PERSEDIAAN UMUM6050.1282RAMBU K3 "AWAS LANTAI LICIN" (PLANG = 30 X 40 CM TINGGI = 180 CM)260110127650,0002601101272026-01-212026-02-102650,000132601106122026-02-02122026-02-17On time
2601100172026-01-08PERSEDIAAN UMUM6050.1281RAMBU K3 "DILARANG MEROKOK" (STIKER 30X30 CM)26011012735,0002601101272026-01-212026-02-101035,000132601106122026-02-02122026-02-17On time
2601100172026-01-08PERSEDIAAN UMUM6050.1283RAMBU K3 "AWAS TERJATUH" (PLANG = 30 X 40 CM TINGGI = 180 CM)260110127650,0002601101272026-01-212026-02-104650,000132601106122026-02-02122026-02-17On time
2601100202026-01-09PERSEDIAAN UMUM6020.0755LEGRAN CONDUIT 20MM2601101339,6752601101332026-01-212026-01-3059,675122601105182026-01-2872026-02-06On time
2601100202026-01-09PERSEDIAAN UMUM6020.0756CONNECTING LEGRAN CONDUIT 20MM2601101311,4852601101312026-01-212026-01-30101,485122601107272026-02-09192026-02-06Late
2601100202026-01-09PERSEDIAAN UMUM6020.0757FLEXIBLE CONDUIT 20MM26011014214,5002601101422026-01-212026-01-3010014,500122601106022026-02-02122026-02-06On time
2601100202026-01-09PERSEDIAAN UMUM6020.0754DUCTING PANEL LOBANG26011013230,0002601101322026-01-212026-01-30230,000122601105192026-01-2872026-02-06On time
2601100252026-01-13SPAREPART5032.1359DONG AH TUBE 23.5-252604101881,440,0002601101182026-01-212026-01-3021,440,0008–––2026-02-06Overdue
2601100252026-01-13SPAREPART5032.136DONG AH FLAP 23.5-25260410188960,0002601101182026-01-212026-01-301960,0008–––2026-02-06Overdue
2601100252026-01-13SPAREPART5032.1358TECHKING TYRE 23.5-25 20PR T/L26041018915,500,0002601101262026-01-212026-01-30115,500,00082601107552026-02-09192026-02-06Late
2601100272026-01-13PERSEDIAAN UMUM6030.2397ELBOW LAS 3 INCH26011011783,571.52601101152026-01-212026-01-30190,00082601105232026-01-2872026-02-06On time
2601100272026-01-13PERSEDIAAN UMUM6030.2397ELBOW LAS 3 INCH26011011783,571.52601101162026-01-212026-01-30278,20082601105222026-01-2872026-02-06On time
2601100272026-01-13PERSEDIAAN UMUM6030.2397ELBOW LAS 3 INCH26011011783,571.52601101172026-01-212026-01-302783,571.582601105212026-01-2872026-02-06On time
2601100352026-01-19PERSEDIAAN UMUM6030.1595METERAN 10 MTR26050018363,7502601101412026-01-212026-01-30533,70022601105142026-01-2872026-02-06On time
2601100352026-01-19PERSEDIAAN UMUM6030.0729REFILL BULU ROLL KECIL () 4 INCH2603101269752601101362026-01-212026-01-301003,44022601105162026-01-2872026-02-06On time
2601100352026-01-19PERSEDIAAN UMUM6030.1729AVIAN THINNER ENAMEL26061013957,554.172601101242026-01-212026-01-212029,92522601111772026-02-27372026-01-28Late
2601100352026-01-19PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232601101242026-01-212026-01-215057,472.522601111742026-02-27372026-01-28Late
2601100352026-01-19PERSEDIAAN UMUM6050.0042KUAS ROLL KECIL26050030014,881.082601101352026-01-212026-01-30109,64822601105152026-01-2872026-02-06On time
2601100352026-01-19PERSEDIAAN UMUM6050.0086SARUNG TANGAN LAS26051009322,5232601101402026-01-212026-01-301080,00022601106082026-02-02122026-02-06On time
2601100352026-01-19PERSEDIAAN UMUM6030.2544CAT ZINCROMATE AVIAN 97202605100351,260,842.382601101242026-01-212026-01-21121,034,141.2522601111772026-02-27372026-01-28Late
2601100352026-01-19PERSEDIAAN UMUM6030.1791WD CUTTING 4 INCH2606100423,3002601101302026-01-212026-01-305003,00022601104982026-01-2872026-02-06On time
2601100352026-01-19PERSEDIAAN UMUM6050.0245REGULATOR OXYGEN260610001135,135.142601101282026-01-212026-01-305200,00022601104462026-01-2322026-02-06On time
2601100352026-01-19PERSEDIAAN UMUM6030.1783MATA BOR BETON 20260110139175,0002601101392026-01-212026-01-305175,00022601107452026-02-09192026-02-06Late
2601100352026-01-19PERSEDIAAN UMUM6030.1791WD CUTTING 4 INCH2606100423,3002601101302026-01-212026-01-305003,00022601104502026-01-2762026-02-06On time
2601100352026-01-19PERSEDIAAN UMUM6030.0613METERAN 5 MTR2605101569,3632601101212026-01-212026-01-21518,022.422601105262026-01-2872026-01-28On time
2601100352026-01-19PERSEDIAAN UMUM6030.0166KAWAT LAS RB 26 2.6 MM26060001333,333.332601101232026-01-212026-01-2130033,15022601107362026-02-09192026-01-28Late
2601100352026-01-19PERSEDIAAN UMUM6030.19KAWAT LAS RB 3.226011012330,8502601101232026-01-212026-01-2125030,85022601107362026-02-09192026-01-28Late
2601100352026-01-19PERSEDIAAN UMUM6050.0244REGULATOR LPG260110128100,0002601101282026-01-212026-01-305100,00022601104462026-01-2322026-02-06On time
2601100352026-01-19PERSEDIAAN UMUM6020.0688AXIAL FAN 120MMX120MM AC220 VOLT260110129114,0002601101292026-01-212026-01-305114,00022601104562026-01-2762026-02-06On time
2601100352026-01-19SPAREPART5019.0336ROTOR GERINDA MERK:BOSCH TYPE:GWS 700260110386237,5002601101252026-01-212026-01-216237,50022601104572026-01-2762026-01-28On time
2601100352026-01-19PERSEDIAAN UMUM6060.051DYNA BOLT M20260110129280,2502601101292026-01-212026-01-3070280,25022601104562026-01-2762026-02-06On time
2601100382026-01-20FIXED ASSETSAST02599EPSON EXPRESSION 13000XL SCANNER FOTO FLATBET A326011011457,300,0002601101142026-01-212026-01-21157,300,00012601105832026-01-31102026-01-28Late
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.0206CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601101202026-01-212026-01-2150,400659.5212601108772026-02-12222026-01-28Late
2601100402026-01-20BAHAN PACKING3011.0206CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601101202026-01-212026-01-2150,400659.5212601107092026-02-07172026-01-28Late
2601100402026-01-20BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601101202026-01-212026-01-2150,400698.8812601107092026-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,00062512601104962026-01-2872026-01-28On time
2601100402026-01-20BAHAN PACKING3011.0212CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601101192026-01-212026-01-21100,00062512604104462026-04-22912026-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.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.0211CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601101192026-01-212026-01-21100,0007051–––2026-01-28Overdue
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.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)2606101056962601101192026-01-212026-01-21100,00070512604104462026-04-22912026-01-28Late
2601100402026-01-20BAHAN PACKING3011.0211CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601101192026-01-212026-01-21100,00070512601104962026-01-2872026-01-28On time
2601100402026-01-20BAHAN PACKING3011.0211CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601101202026-01-212026-01-2168,000698.8812601106272026-02-03132026-01-28Late
2601100402026-01-20BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601101202026-01-212026-01-2150,400698.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.5212601106272026-02-03132026-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.0212CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601101192026-01-212026-01-21100,00062512601104952026-01-2872026-01-28On time
2601100402026-01-20BAHAN PACKING3011.0212CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601101192026-01-212026-01-21100,0006251–––2026-01-28Overdue
← PrevPage 46 of 135Next →Rows per page:1020501005001000