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
2601003252026-01-22STATIONERY6010.0278TINTA EPSON MAGENTA T664326060002783,0002601005232026-01-292026-02-05183,00072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0184MAP PLASTIK L TRANSPARAN, F42605004191,6002601005232026-01-292026-02-05311,70072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0275TINTA EPSON BLACK - T664126060002783,0002601005232026-01-292026-02-05283,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.0173BINDER CLIP NO. 111 NO. 1112606000273,8002601005232026-01-292026-02-0543,80072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0151ISI STAPLES KECIL #10 KECIL, NO.10-1M2606101511,5922601005232026-01-292026-02-05422,70072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0122BOLPOIN HITAM2606000271,3002601005232026-01-292026-02-05601,30072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0192BUKU FOLIO 21.5*30.5 21.5 X 31.5 CM26060010816,5002601005232026-01-292026-02-051016,30072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.019BUKU TULIS SIDU(16*21) 16 X 21 CM2606000274,6002601005232026-01-292026-02-05204,60072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0241ISI BOLPOIN HITAM2606000277002601005232026-01-292026-02-0510870072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0761KERTAS BINDER A5 BERGARIS2606000273,5002601005232026-01-292026-02-0543,50072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0124PENSIL MEKANIK26040010713,0002601005232026-01-292026-02-05313,00072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.001POST IT KECIL2605000266,0002601005232026-01-292026-02-0538,70072601015832026-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.0162TIPEX CAIR2606001083,6002601005232026-01-292026-02-0554,90072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0467TIPEX KERTAS2606001084,7002601005232026-01-292026-02-0565,40072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.015ISI CUTTER BESAR L-1502606100606,5002601005232026-01-292026-02-053005,00072601015832026-02-13152026-02-12Late
2601003252026-01-22STATIONERY6010.0156STAPLES KECIL HD-102606101519,7412601005232026-01-292026-02-05134,50072601015832026-02-13152026-02-12Late
2601003452026-01-26STATIONERY6010.058KERTAS STIKER KRAFT A4 COKLAT (DARK)26060018429,0002601005232026-01-292026-02-05227,00032601015362026-02-12142026-02-12On time
2601100012026-01-02SPAREPART5019.0345MOTOR ABB RPM 1457 DAYA 7,5 KW 50 HZ, 380 VOLT UNTUK POMPA EBARA 80 X 65 FS4KA26011022112,122,0002601102212026-01-292026-02-07212,122,000272601108912026-02-13152026-02-14On time
2601100142026-01-07PERSEDIAAN UMUM6030.224ERGENE CAT TAHAN PANAS 600° WARNA SILVER @5LITER/KALENG2604100971,635,0002601102182026-01-292026-02-09301,635,000222601107582026-02-09112026-02-16On time
2601100322026-01-13PERSEDIAAN UMUM6050.1297TILE CUTTER 120CM2601102251,081,0812601102252026-01-292026-01-2911,081,081162601108292026-02-10122026-02-05Late
2601100462026-01-23BAHAN PACKING3011.021CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP2 KWA 605X38 (WK150/125/150)2604100186592601102192026-01-292026-01-2942,00065962601109502026-02-16182026-02-05Late
2601100462026-01-23BAHAN PACKING3011.0211CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102192026-01-292026-01-2988,20069662601111092026-02-23252026-02-05Late
2601100462026-01-23BAHAN PACKING3011.0209CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP1 KWA 605X40 (WK150/125/150)2604100186962601102192026-01-292026-01-2942,00069662601109502026-02-16182026-02-05Late
2601100462026-01-23BAHAN PACKING3011.0212CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601102192026-01-292026-01-2988,20065962601108362026-02-10122026-02-05Late
2601100462026-01-23BAHAN PACKING3011.0211CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102192026-01-292026-01-2988,20069662601108362026-02-10122026-02-05Late
2601100462026-01-23BAHAN PACKING3011.0212CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601102192026-01-292026-01-2988,20065962601111092026-02-23252026-02-05Late
2601100462026-01-23BAHAN PACKING3011.0212CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601102192026-01-292026-01-2988,2006596–––2026-02-05Overdue
2601100462026-01-23BAHAN PACKING3011.0208CARTON BOX SIDEWRAPS PARIS 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601102192026-01-292026-01-2942,00065962601108762026-02-12142026-02-05Late
2601100462026-01-23BAHAN PACKING3011.0211CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102192026-01-292026-01-2988,2006966–––2026-02-05Overdue
2601100462026-01-23BAHAN PACKING3011.0207CARTON BOX SIDEWRAPS PARIS 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102192026-01-292026-01-2942,00069662601108762026-02-12142026-02-05Late
2601100462026-01-23BAHAN PACKING3011.0211CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102192026-01-292026-01-2988,20069662601107102026-02-0792026-02-05Late
2601100462026-01-23BAHAN PACKING3011.0212CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601102192026-01-292026-01-2988,20065962601107102026-02-0792026-02-05Late
2601100512026-01-24PERSEDIAAN UMUM6050.1251WEBBING SLING BELT 5 TON X 10 METER DOUBLE PLY260110385865,1002601102242026-01-292026-01-292892,50052601107382026-02-09112026-02-05Late
2601100612026-01-29BAHAN BAKU GLAZE1070.0025INK DP BLUE K 3586 BETO INK260110365211,895.922601102532026-01-292026-01-2960210,008.32––––2026-02-05Overdue
2601100612026-01-29BAHAN BAKU GLAZE1070.0028INK DP GREEN K 3801 BETO260110365111,835.982601102532026-01-292026-01-291,000110,903.27––––2026-02-05Overdue
2601100612026-01-29BAHAN BAKU GLAZE1070.003INK DP BLACK GSY 99023 GUOSE260310056952601102202026-01-292026-01-2910079–2603103752026-03-26562026-02-05Late
2601100612026-01-29BAHAN BAKU GLAZE1070.0026INK DP BROWN K 3287 BETO26051007692,550.392601102532026-01-292026-01-292,00087,306.83––––2026-02-05Overdue
2512002322025-12-12SPAREPART5017.1033SIEMENS 3RH2911-2HA0226010055483,6002601005542026-01-302026-02-23683,600492601014922026-02-11122026-03-02On time
2512002322025-12-12SPAREPART5017.104SIEMENS 3RT2016-2BB42 24V DC260100554352,0002601005542026-01-302026-02-2313352,000492601014922026-02-11122026-03-02On time
2512002322025-12-12SPAREPART5017.1033SIEMENS 3RH2911-2HA0226010055483,6002601005542026-01-302026-02-23683,600492605007402026-05-221122026-03-02Late
2512002322025-12-12SPAREPART5017.1071KONTAKTOR 3RT5036-1AF00 + 3RH5921-1FA222601005541,022,5602601005542026-01-302026-02-2331,022,560492601014922026-02-11122026-03-02On time
2512002322025-12-12SPAREPART5017.1032KONTAKTOR 3RT2016-1BB42 + 3RH2911-1FA22260100554488,4002601005542026-01-302026-02-235488,400492601014922026-02-11122026-03-02On time
2512002322025-12-12SPAREPART5017.1028KONTAKTOR 3RH2122-1AF00 110V260100554356,4002601005542026-01-302026-02-231356,400492601014922026-02-11122026-03-02On time
2512002322025-12-12SPAREPART5017.1031KONTAKTOR 3RT2026-1BB40 + 3RH2911-1FA222601005541,241,6802601005542026-01-302026-02-2361,241,680492601014922026-02-11122026-03-02On time
2512002322025-12-12SPAREPART5017.1029KONTAKTOR 3RH2140-1AP00 230V260100554356,4002601005542026-01-302026-02-231356,400492601014922026-02-11122026-03-02On time
2512002322025-12-12SPAREPART5017.1027KONTAKTOR 3RH2140-1AF00 110 V260100554356,4002601005542026-01-302026-02-231356,400492601014922026-02-11122026-03-02On time
2512100682025-12-24STATIONERY6010.0128SPIDOL BOARD MARKER MERAH BOARDMARKER, MERAH/RED2606000276,7002601102402026-01-302026-02-07122,486372601107532026-02-09102026-02-14On time
2512100682025-12-24STATIONERY6010.0127SPIDOL BOARDMARKER HITAM - BOARDMARKER, HITAM/BLACK2606101518,9982601102402026-01-302026-02-07122,486372601107532026-02-09102026-02-14On time
2512100682025-12-24STATIONERY6010.0172BINDER CLIP NO. 107 NO. 1072606100603,5002601102402026-01-302026-02-0724,785372601107532026-02-09102026-02-14On time
2512100682025-12-24STATIONERY6010.077GUNTING KERTAS KECIL2606101513,6272601102402026-01-302026-02-0733,935.8372601107532026-02-09102026-02-14On time
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601005782026-01-302026-02-1368858,000252601014402026-02-11122026-02-20On time
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601005782026-01-302026-02-1368858,000252601018802026-02-23242026-02-20Late
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601005782026-01-302026-02-1368858,000252601017342026-02-19202026-02-20On time
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601005782026-01-302026-02-1368858,000252601020752026-02-28292026-02-20Late
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601005782026-01-302026-02-1368858,000252601013142026-02-0782026-02-20On time
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601005782026-01-302026-02-1368858,000252601012312026-02-0562026-02-20On time
2601001362026-01-09BAHAN BAKAR4040.0003OIL SIGMA LUBRICANT 9.5409.000202605003926,887,5002601005582026-01-302026-02-1937,372,050212601013752026-02-09102026-02-26On time
2601001362026-01-09SPAREPART5010.0021OIL SEPARATOR 6.3571.02605003933,510,9002601005582026-01-302026-02-19110,495,800212601013752026-02-09102026-02-26On time
2601001362026-01-09SPAREPART5010.0009AIR FILTER 4E0301.0 EX 64149.12605003921,092,5002601005582026-01-302026-02-1933,516,450212601013752026-02-09102026-02-26On time
2601001362026-01-09SPAREPART5010.0008OIL FILTER 64493.02605003931,050,0002601005582026-01-302026-02-1922,374,050212601013752026-02-09102026-02-26On time
2601001452026-01-12PERSEDIAAN UMUM6020.0603TIMBANGAN DIGITAL 15 KG SONIC - TAIWAN2603004291,650,0002601005352026-01-302026-02-0641,650,000182601012362026-02-0562026-02-13On time
2601001942026-01-15PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002601005572026-01-302026-02-132036,225.23152601011412026-02-0232026-02-20On time
2601001942026-01-15PERSEDIAAN UMUM6050.0579CAT AVIAN KUNING ROAD LINE26060017158,502.72601005572026-01-302026-02-131046,559.46152601011412026-02-0232026-02-20On time
2601002082026-01-15PERSEDIAAN UMUM6050.1306LOCKER BESI 24 PINTU 900 X 400 x 1800 MM2601005413,500,0002601005412026-01-302026-01-3023,500,00015–––2026-02-06Overdue
2601002412026-01-20PERSEDIAAN UMUM6030.2588BESI VERKAN 16 X 16 MM @6 METER260500424162,162.162601005442026-01-302026-02-1435200,000102601017492026-02-19202026-02-21On time
2601002412026-01-20PERSEDIAAN UMUM6030.2588BESI VERKAN 16 X 16 MM @6 METER260500424162,162.162601005442026-01-302026-02-1435200,000102601014742026-02-11122026-02-21On time
2601002592026-01-21PERSEDIAAN UMUM6050.1246KUNCI L SET ISKU26010054890,0002601005482026-01-302026-02-18190,00092601012922026-02-0672026-02-25On time
2601002592026-01-21PERSEDIAAN UMUM6050.0417KUNCI RING PAS 8-32 MM260500052516,0002601005482026-01-302026-02-181585,00092601012922026-02-0672026-02-25On time
2601002652026-01-22PERSEDIAAN UMUM6030.2592BESI VERKAN 22 X 22 MM @6 METER260100540265,765.772601005402026-01-302026-01-305265,765.7782601014122026-02-10112026-02-06Late
2601002742026-01-22SPAREPART5018.0034RS 08 B2 C/L2601009427,5002601005532026-01-302026-02-14105,4408–––2026-02-21Overdue
2601002742026-01-22SPAREPART5018.0028RS 50 I C/L2601009427,5002601005532026-01-302026-02-14105,00082604005282026-04-15752026-02-21Late
2601002742026-01-22SPAREPART5018.0036RS 80 I C/L26060017215,0002601005532026-01-302026-02-141015,00082604005282026-04-15752026-02-21Late
2601002742026-01-22SPAREPART5018.0035RS 60 II C/L26010094210,0002601005532026-01-302026-02-141010,00082604005282026-04-15752026-02-21Late
2601002742026-01-22SPAREPART5018.0047RS 60 I O/L26010094210,0002601005532026-01-302026-02-14107,50082604005282026-04-15752026-02-21Late
2601003152026-01-24STATIONERY6010.0666GUNTING BESAR2606101514,9372601005622026-01-302026-02-0619,00062601015332026-02-12132026-02-13On time
2601003152026-01-24STATIONERY6010.0541MAP CLEAR HOLDER (MAP SNELL)26010056030,0002601005602026-01-302026-02-12130,00062601015142026-02-12132026-02-19On time
2601003182026-01-24PERSEDIAAN UMUM6030.0847NO DROP TAPE260100536100,0002601005362026-01-302026-01-3020100,00062601012052026-02-0452026-02-06On time
2601003252026-01-22STATIONERY6010.0247AMPLOP COKLAT KOP KOBIN KOP KOBIN 35X24 CM260100526191,5002601005262026-01-302026-02-062191,50082601012652026-02-0562026-02-13On time
2601003332026-01-26PERSEDIAAN UMUM6030.2601U BOLT GALVANISH 3 INCH2606100966,036.032601005462026-01-302026-01-302547,50042601011712026-02-0342026-02-06On time
2601003332026-01-26PERSEDIAAN UMUM6030.26T BOW STAINLESS 3 INCH260100528437,837.842601005282026-01-302026-01-305437,837.8442601012222026-02-0452026-02-06On time
2601003332026-01-26PERSEDIAAN UMUM6030.2599ELBOW STAINLESS 3 INCH260100528248,648.652601005282026-01-302026-01-3025248,648.6542601012222026-02-0452026-02-06On time
2601003332026-01-26PERSEDIAAN UMUM6030.2599ELBOW STAINLESS 3 INCH260100528248,648.652601005282026-01-302026-01-3025248,648.6542601011392026-02-0232026-02-06On time
2601003342026-01-26PERSEDIAAN UMUM6050.0175GEMBOK 40MM26050023720,0002601005422026-01-302026-01-30520,00042601010872026-01-30–2026-02-06On time
2601003492026-01-26BAHAN BAKAR4040.0002MEDITRAN S40 SAE 4026060022037,070.562601005552026-01-302026-02-1320927,655.542601011402026-02-0232026-02-20On time
2601003492026-01-26SPAREPART5032.0215AIR FILTER P828889 DONALDSON260100556237,5002601005562026-01-302026-02-144237,50042601012472026-02-0562026-02-21On time
2601003622026-01-27PERSEDIAAN UMUM6050.0208KERTAS TERMAL (ROLL KASIR)2601005627,4002601005622026-01-302026-02-06107,40032601015332026-02-12132026-02-13On time
2601003622026-01-27STATIONERY6010.002COUNTINOUS FORM 3 PLAY 9 1/2 X 11260100562446,0002601005622026-01-302026-02-062446,00032601015332026-02-12132026-02-13On time
2601003662026-01-27SPAREPART5031.0604CAMLOCK TYPE A 2 INCH260100550180,0002601005502026-01-302026-01-3010180,00032601014592026-02-11122026-02-06Late
2601003662026-01-27SPAREPART5031.0437CAMLOCK TYPE E 2 INCH260100550300,0002601005502026-01-302026-01-3010300,00032601014592026-02-11122026-02-06Late
2601003742026-01-28PERSEDIAAN UMUM6030.2617PLAT BESI 20X600X600 MM2601005451,300,0002601005452026-01-302026-01-3061,300,00022601011212026-01-3112026-02-06On time
2601003742026-01-28PERSEDIAAN UMUM6030.2618PLAT BESI 20X500X1500 MM2601005452,850,0002601005452026-01-302026-01-3022,850,00022601011212026-01-3112026-02-06On time
2601003762026-01-28PERSEDIAAN UMUM6030.2616DR SONNE SOLID SHEET FLAT ST 3 MM, L = 1220 MM P = 6000 MM2601005492,405,405.42601005492026-01-302026-01-3012,405,405.422601011352026-02-0232026-02-06On time
2601003802026-01-29PERSEDIAAN UMUM6030.0479AQUA PROOF26030019958,7502601005272026-01-302026-01-302458,75012601020282026-02-27282026-02-06Late
2601003802026-01-29PERSEDIAAN UMUM6030.0479AQUA PROOF26030019958,7502601005272026-01-302026-01-302458,75012601010852026-01-30–2026-02-06On time
2601004052026-01-29FIXED ASSETSAST02630ELECTRIC BLANK BENDING TESTER, MODEL: SL101-4A2601005478452601005472026-01-302026-01-30184512604011182026-04-29892026-02-06Late
2601004052026-01-29FIXED ASSETSAST02629ELECTRIC BLANK BENDING TESTER, TYPE: SLKY HMI2601005471,0202601005472026-01-302026-01-3011,02012604011182026-04-29892026-02-06Late
2601100162026-01-08PERSEDIAAN UMUM6050.1276PLAT STRIP LATERAL BLADE GALVANIS 40 X 2MM X 1000 MM26011023647,0002601102362026-01-302026-01-302047,000222601107522026-02-09102026-02-06Late
2601100192026-01-09PERSEDIAAN UMUM6030.2558BOR IMPACT TEMBOK 21V2601102321,160,0002601102322026-01-302026-02-1011,160,00021–––2026-02-17Overdue
← PrevPage 54 of 135Next →Rows per page:1020501005001000