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
2601100462026-01-23BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102232026-01-282026-01-28159,60069652601111052026-02-23262026-02-04Late
2601100462026-01-23BAHAN PACKING3011.0206CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601102232026-01-282026-01-28159,60065952601109522026-02-16192026-02-04Late
2601100462026-01-23BAHAN PACKING3011.0206CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601102232026-01-282026-01-28159,60065952603102812026-03-16472026-02-04Late
2601100462026-01-23BAHAN PACKING3011.0206CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601102232026-01-282026-01-28159,60065952601108772026-02-12152026-02-04Late
2601100462026-01-23BAHAN PACKING3011.0206CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601102232026-01-282026-01-28159,60065952601111052026-02-23262026-02-04Late
2601100462026-01-23BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102232026-01-282026-01-28159,60069652601108772026-02-12152026-02-04Late
2601100462026-01-23BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102232026-01-282026-01-28159,60069652603100742026-03-05362026-02-04Late
2601100462026-01-23BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102232026-01-282026-01-28159,60069652601109522026-02-16192026-02-04Late
2601100462026-01-23BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102232026-01-282026-01-28159,60069652603102812026-03-16472026-02-04Late
2601100512026-01-24PERSEDIAAN UMUM6050.126TOPENG LAS26051015216,6602601102152026-01-282026-02-06555,00042601106112026-02-0252026-02-13On time
2601100512026-01-24PERSEDIAAN UMUM6020.0773KABEL NYY 4X2.5 MM26011021030,8112601102102026-01-282026-01-2870030,81142601108882026-02-13162026-02-04Late
2601100512026-01-24PERSEDIAAN UMUM6020.0773KABEL NYY 4X2.5 MM26011021030,8112601102102026-01-282026-01-2870030,81142601112062026-02-27302026-02-04Late
2601100512026-01-24PERSEDIAAN UMUM6050.1164TRACK BELT 10 MTR (5 TON)260610182245,7002601102092026-01-282026-01-2820236,70042601109122026-02-16192026-02-04Late
2601100512026-01-24PERSEDIAAN UMUM6050.0757KACAMATA SAFETY2601103956,9352601102042026-01-282026-02-06206,42442601107312026-02-09122026-02-13On time
2601100512026-01-24PERSEDIAAN UMUM6030.2535NOOZLE BLENDER TIPE STRONG 8 NO.226011020318,2742601102032026-01-282026-02-061018,27442601109712026-02-19222026-02-13Late
2601100512026-01-24PERSEDIAAN UMUM6030.2259APRON LAS26040048799,099.12601102052026-01-282026-01-28575,00042601107472026-02-09122026-02-04Late
2601100512026-01-24PERSEDIAAN UMUM6030.2238KACA LAS HITAM NO.102605100913,2502601102122026-01-282026-01-28203,42542601106132026-02-0252026-02-04On time
2601100512026-01-24PERSEDIAAN UMUM6050.0042KUAS ROLL KECIL26050030014,881.082601102072026-01-282026-02-06109,58542601107292026-02-09122026-02-13On time
2601100512026-01-24PERSEDIAAN UMUM6030.2522KACA LAS HITAM NO.112605100913,2502601102162026-01-282026-01-28202,00042601107322026-02-09122026-02-04Late
2601100512026-01-24PERSEDIAAN UMUM6050.0398KUNCI RING PAS 8-24 MM260500335299,9002601102132026-01-282026-02-061305,00042601107392026-02-09122026-02-13On time
2601100512026-01-24PERSEDIAAN UMUM6030.1595METERAN 10 MTR26050018363,7502601102142026-01-282026-02-06533,91542601107302026-02-09122026-02-13On time
2512003032025-12-17BAHAN PEMBANTU20MO.0656LOWER PUNCH 30 X 30 ( 312.5 X 312.5 ) T=26MM2601005321,800,0002601005322026-01-292026-01-29251,800,000432603000022026-03-02322026-02-05Late
2512003032025-12-17BAHAN PEMBANTU20MO.0647UPPER PUNCH 30X30 (313.5 X 313.5 ) T=48MM2601005322,700,0002601005322026-01-292026-01-29252,700,000432601019182026-02-23252026-02-05Late
2512003032025-12-17BAHAN PEMBANTU20MO.0647UPPER PUNCH 30X30 (313.5 X 313.5 ) T=48MM2601005322,700,0002601005322026-01-292026-01-29252,700,000432603000022026-03-02322026-02-05Late
2512003032025-12-17BAHAN PEMBANTU20MO.0656LOWER PUNCH 30 X 30 ( 312.5 X 312.5 ) T=26MM2601005321,800,0002601005322026-01-292026-01-29251,800,000432601019182026-02-23252026-02-05Late
2512003642025-12-22PERSEDIAAN UMUM6020.0086KEYBOARD260500013105,0002601005242026-01-292026-02-105100,000382601011732026-02-0352026-02-17On time
2512003642025-12-22FIXED ASSETSAST02557MONITOR LCD260100524600,0002601005242026-01-292026-02-102600,000382601011732026-02-0352026-02-17On time
2512003722025-12-22SPAREPART5030.0385MASTER PLATE 10X400X250 MM2601005331,700,0002601005332026-01-292026-01-2911,700,000382603006612026-03-16462026-02-05Late
2512003722025-12-22SPAREPART5030.0386MASTER PLATE SIZE 400X400 MM THICKNESS 9 MM2605004223,200,0002601005332026-01-292026-01-2912,200,000382603006612026-03-16462026-02-05Late
2512003832025-12-23FIXED ASSETSAST02569LAPTOP LENOVO CORE I5 RAM 8GB SSD 512GB2601005227,700,0002601005222026-01-292026-02-0517,700,000372601015812026-02-13152026-02-12Late
2512003892025-12-24BAHAN PEMBANTU20MO.0659LOWER PUNCH 50X50 (540.26X540.26) T.332601005303,800,0002601005302026-01-292026-01-29103,800,000362603003382026-03-09392026-02-05Late
2512003892025-12-24BAHAN PEMBANTU20MO.0658UPPER ISOSTATIC PUNCH 50X50 (541.36X541.36) T.502601005305,600,0002601005302026-01-292026-01-29105,600,000362605000622026-05-04952026-02-05Late
2512003892025-12-24BAHAN PEMBANTU20MO.0659LOWER PUNCH 50X50 (540.26X540.26) T.332601005303,800,0002601005302026-01-292026-01-29103,800,000362604010412026-04-28892026-02-05Late
2512003892025-12-24BAHAN PEMBANTU20MO.0658UPPER ISOSTATIC PUNCH 50X50 (541.36X541.36) T.502601005305,600,0002601005302026-01-292026-01-29105,600,000362603003382026-03-09392026-02-05Late
2512100522025-12-17STATIONERY6010.0539LAKBAN BENING 2 INCI / 48MM2605003228,0002601102222026-01-292026-02-07726,000432601106462026-02-0462026-02-14On time
2512100682025-12-24STATIONERY6010.0307PITA PRINTER LX 31026061006016,8002601102302026-01-292026-02-07545,000362601107612026-02-09112026-02-14On time
2512100682025-12-24STATIONERY6010.0719SHEET PROTECTOR PP POCKET PLASTIK BINDER F42606101513,5012601102302026-01-292026-02-07101,400362601107612026-02-09112026-02-14On time
2512100682025-12-24STATIONERY6010.015ISI CUTTER BESAR L-1502606100606,5002601102292026-01-292026-02-07126,500362601107252026-02-09112026-02-14On time
2512100682025-12-24STATIONERY6010.0192BUKU FOLIO 21.5*30.5 21.5 X 31.5 CM26060010816,5002601102302026-01-292026-02-07517,000362601107612026-02-09112026-02-14On time
2512100682025-12-24STATIONERY6010.0025CONTINUOUS FORM 5 PLY 9,5 X 11:2260610075175,0002601102302026-01-292026-02-074220,000362601107612026-02-09112026-02-14On time
2512100682025-12-24STATIONERY6010.0008COUNTINUOS FORM 3 PLAY COUNTINUOS 3 PLAY260410006270,0002601102302026-01-292026-02-074195,000362601107612026-02-09112026-02-14On time
2512100682025-12-24STATIONERY6010.0001KERTAS A426060024443,0002601102292026-01-292026-02-071041,000362601107252026-02-09112026-02-14On time
2512100682025-12-24STATIONERY6010.0184MAP PLASTIK L TRANSPARAN, F42605004191,6002601102292026-01-292026-02-0723,000362601107252026-02-09112026-02-14On time
2512100682025-12-24STATIONERY6010.0174BINDER CLIP NO. 155 NO. 1552606100607,2002601102302026-01-292026-02-0716,500362601107612026-02-09112026-02-14On time
2512100682025-12-24STATIONERY6010.0763ISI STAPLES BESAR NO.502603003124,8002601102292026-01-292026-02-0715,000362601107252026-02-09112026-02-14On time
2512100682025-12-24STATIONERY6010.0151ISI STAPLES KECIL #10 KECIL, NO.10-1M2606101511,5922601102292026-01-292026-02-0722,000362601107252026-02-09112026-02-14On time
2512100682025-12-24STATIONERY6010.0762STAPLES HD-5026030037457,5002601102292026-01-292026-02-07228,000362601107252026-02-09112026-02-14On time
2512100682025-12-24STATIONERY6010.0448PAPAN JALAN CLIPBOARD A426041023411,7812601102292026-01-292026-02-0756,500362601107252026-02-09112026-02-14On time
2512100682025-12-24STATIONERY6010.0156STAPLES KECIL HD-102606101519,7412601102302026-01-292026-02-07212,000362601107612026-02-09112026-02-14On time
2512100712025-12-26PERSEDIAAN UMUM6010.0598LAKBAN BENING 36MM2605102585,0002601102222026-01-292026-02-073843,650342601106462026-02-0462026-02-14On time
2512100792025-12-31SPAREPART5029.0466HIGH TEMPERATURE KILN ROLLER S99-55x4250MM BRAND SCIEN260110228352601102282026-01-292026-01-2960035292604102022026-04-11722026-02-05Late
2601000742026-01-08PERSEDIAAN UMUM6020.0745TRAY KABEL 200MMX100MM260100509216,666.672601005092026-01-292026-01-2919.2216,666.67212601014902026-02-11132026-02-05Late
2601002132026-01-17FIXED ASSETSAST02591Printer Epson L11212601005241,400,0002601005242026-01-292026-02-1031,400,000122601011732026-02-0352026-02-17On time
2601002132026-01-17FIXED ASSETSAST02592Printer JANZ-XT1002605003731,891,8922601005152026-01-292026-02-0521,880,000122601014132026-02-10122026-02-12On time
2601002142026-01-17FIXED ASSETSAST02593Mini PC Core I5 Ram 8Gb SSD 256Gb2603005127,950,0002601005252026-01-292026-02-0337,950,000122601011742026-02-0352026-02-10On time
2601002172026-01-17STATIONERY6010.0336KERTAS STIKER A4 GLOSSY ( PUTIH )26050002637,5002601005232026-01-292026-02-05441,000122601015362026-02-12142026-02-12On time
2601002172026-01-17STATIONERY6010.058KERTAS STIKER KRAFT A4 COKLAT (DARK)26060018429,0002601005232026-01-292026-02-051027,000122601015362026-02-12142026-02-12On time
2601002192026-01-17FIXED ASSETSAST02598PRINTER EPSON L3210 (WRM)2601005251,960,0002601005252026-01-292026-02-0311,960,000122601011742026-02-0352026-02-10On time
2601002522026-01-20SPAREPART5029.004BULLERINGS / RING TEST 27/84 MANTEC (1 BOX = 100 PCS)2601005141,923,1452601005142026-01-292026-02-2051,923,14592601013382026-02-0792026-02-27On time
2601003152026-01-24STATIONERY6010.0139STABILO KUNING2606000279,3002601005232026-01-292026-02-0569,30052601015832026-02-13152026-02-12Late
2601003152026-01-24STATIONERY6010.0136SPIDOL MARKER PUTIH MARKER, PUTIH/WHITE26060010813,1002601005232026-01-292026-02-052512,30052601015832026-02-13152026-02-12Late
2601003152026-01-24STATIONERY6010.058KERTAS STIKER KRAFT A4 COKLAT (DARK)26060018429,0002601005232026-01-292026-02-05227,00052601015362026-02-12142026-02-12On time
2601003152026-01-24STATIONERY6010.0243PAPER CLIP NO 52604002074,0002601005232026-01-292026-02-0514,00052601015832026-02-13152026-02-12Late
2601003152026-01-24STATIONERY6010.0162TIPEX CAIR2606001083,6002601005232026-01-292026-02-0524,90052601015832026-02-13152026-02-12Late
2601003152026-01-24STATIONERY6010.0127SPIDOL BOARDMARKER HITAM - BOARDMARKER, HITAM/BLACK2606101518,9982601005232026-01-292026-02-05246,70052601015832026-02-13152026-02-12Late
2601003152026-01-24STATIONERY6010.0149ISI CUTTER KECIL A-1002601005232,5002601005232026-01-292026-02-05602,50052601015832026-02-13152026-02-12Late
2601003152026-01-24STATIONERY6010.0441TINTA EPSON 003 BLACK 65ML26060002783,0002601005232026-01-292026-02-05383,00052601015832026-02-13152026-02-12Late
2601003152026-01-24STATIONERY6010.0336KERTAS STIKER A4 GLOSSY ( PUTIH )26050002637,5002601005232026-01-292026-02-05141,00052601015362026-02-12142026-02-12On time
2601003152026-01-24STATIONERY6010.0186PLASTIK BANTEX 8843 CLEAR, 24 x 34 CM, 20 PCS/BAG26060025630,0002601005232026-01-292026-02-05528,00052601015832026-02-13152026-02-12Late
2601003152026-01-24PERSEDIAAN UMUM6020.005KALKULATOR26060002765,0002601005232026-01-292026-02-05456,00052601015832026-02-13152026-02-12Late
2601003152026-01-24STATIONERY6010.0236BOLPOIN MERAH2606000271,3002601005232026-01-292026-02-05241,30052601015832026-02-13152026-02-12Late
2601003152026-01-24STATIONERY6010.0531DELI STICKY NOTES EA03303 4 Color 51x51mm 4x100sheets2606000276,8002601005232026-01-292026-02-0526,80052601015832026-02-13152026-02-12Late
2601003202026-01-24PERSEDIAAN UMUM6050.0072SAPU DORONG 90 CM260500421113,0002601005342026-01-292026-02-0231103,00052601011442026-02-0242026-02-09On time
2601003202026-01-24PERSEDIAAN UMUM6050.0041PEL SUMBU26061008022,0002601005342026-01-292026-02-02445,00052601011442026-02-0242026-02-09On time
2601003202026-01-24PERSEDIAAN UMUM6050.0078REFILL SAPU DORONG26050042168,0002601005342026-01-292026-02-021465,00052601011442026-02-0242026-02-09On time
2601003202026-01-24PERSEDIAAN UMUM6050.0038SAPU LANTAI26050042117,0002601005342026-01-292026-02-026116,00052601011442026-02-0242026-02-09On time
2601003202026-01-24STATIONERY6010.0322KESET TEBAL26010118340,0002601005342026-01-292026-02-02320,00052601011442026-02-0242026-02-09On time
2601003202026-01-24PERSEDIAAN UMUM6050.0062KANEBO26061008012,0002601005342026-01-292026-02-02220,00052601011442026-02-0242026-02-09On time
2601003202026-01-24PERSEDIAAN UMUM6050.0873KEMOCENG26010118320,0002601005342026-01-292026-02-02520,00052601011442026-02-0242026-02-09On time
2601003202026-01-24PERSEDIAAN UMUM6050.0015PEMBERSIH LANTAI26050042116,0002601005342026-01-292026-02-022416,00052601011442026-02-0242026-02-09On time
2601003202026-01-24PERSEDIAAN UMUM6050.0067SAPU LIDI TONGKAT26050047511,0002601005342026-01-292026-02-024410,00052601011442026-02-0242026-02-09On time
2601003252026-01-22STATIONERY6010.019BUKU TULIS SIDU(16*21) 16 X 21 CM2606000274,6002601005232026-01-292026-02-05204,60072601015832026-02-13152026-02-12Late
2601003252026-01-22PERSEDIAAN UMUM6020.0039BATERAI KOTAK 9V26010052311,6002601005232026-01-292026-02-052411,60072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0027COUNTINOUS FORM 2 PLY 9 ½X11:2260410006186,0002601005232026-01-292026-02-053298,80072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.028TINTA EPSON CYAN - T664226060002783,0002601005232026-01-292026-02-05183,00072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0163LEM POVINAL KERTAS OD: 2.5 X 9 CM, 22ml2606001082,0002601005232026-01-292026-02-0531,90072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0761KERTAS BINDER A5 BERGARIS2606000273,5002601005232026-01-292026-02-0543,50072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.001POST IT KECIL2605000266,0002601005232026-01-292026-02-0538,70072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0124PENSIL MEKANIK26040010713,0002601005232026-01-292026-02-05313,00072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0177AMPLOP BESAR BESAR, 11.0 X 23.0 CM26060025618,5002601005232026-01-292026-02-05520,20072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0146ACCO FASTENER 8.0 CM, 50 SETS/BOX2601005237,7002601005232026-01-292026-02-0517,70072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0267REFIL SPIDOL BOARDMARKER MERAH RED/MERAH, OD: 3.0 CM, H: 5.5 CM26060002714,2002601005232026-01-292026-02-051214,20072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0771TRIGONAL CLIP NO. 12605002611,6002601005232026-01-292026-02-05101,70072601015832026-02-13152026-02-12Late
2601003252026-01-22PERSEDIAAN UMUM6020.0035BATERAI AA2601104505,5002601005232026-01-292026-02-05242,30072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.045KERTAS STIKER NON GLOSSY A426060002711,2002601005232026-01-292026-02-05211,20072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0175BINDER CLIP NO. 260 NO. 26026061006018,0002601005232026-01-292026-02-05213,40072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0589LAKBAN HITAM 2 INCI / 48MM2604004939,9002601005232026-01-292026-02-0529,90072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0162TIPEX CAIR2606001083,6002601005232026-01-292026-02-0554,90072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0156STAPLES KECIL HD-102606101519,7412601005232026-01-292026-02-05134,50072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0467TIPEX KERTAS2606001084,7002601005232026-01-292026-02-0565,40072601015832026-02-13152026-02-12Late
← PrevPage 53 of 135Next →Rows per page:1020501005001000