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
2512002372025-12-13BAHAN PACKING3011.0048BOX KOBIN HITAM T.S KW 3 30X302605003821,1772512003222025-12-182026-01-1036,00095152512009742025-12-30122026-01-17On time
2512002572025-12-15PERSEDIAAN UMUM6030.1898CAT AVIAN SUPER BLACK GLOSS26051008270,725.122512003282025-12-182025-12-302457,472.9732512007682025-12-2352026-01-06On time
2512002572025-12-15PERSEDIAAN UMUM6030.0914THINER A BIASA26040044843,350.452512003282025-12-182025-12-304026,505.0532512007682025-12-2352026-01-06On time
2512002572025-12-15PERSEDIAAN UMUM6030.052CAT BESI / KAYU AVIAN TWILIGHT BLUE 73126010069257,472.972512003282025-12-182025-12-3024057,472.9732512009902025-12-30122026-01-06On time
2512002652025-12-16SPAREPART5017.0214MCCB SNEIDER 250 A2601010591,150,0002512003482025-12-182025-12-2711,150,00022512007182025-12-2242026-01-03On time
2512002662025-12-16PERSEDIAAN UMUM6030.2253OVERLOOP 3/4" - 1/2"25120034635,0002512003462025-12-182025-12-26435,00022512007222025-12-2242026-01-02On time
2512002662025-12-16PERSEDIAAN UMUM6030.2254OVERLOOP 1/2" - 3/8"25120034620,0002512003462025-12-182025-12-26420,00022512007222025-12-2242026-01-02On time
2512002702025-12-16PERSEDIAAN UMUM6050.1024SPRAY GUN PC472B TEKIRO251200347174,054.052512003472025-12-182025-12-302174,054.0522512008242025-12-2462026-01-06On time
2512002702025-12-16PERSEDIAAN UMUM6030.0693GERINDA KERTAS GOSOK 4 INCH2605004926,756.762512003472025-12-182025-12-30406,306.3122512008242025-12-2462026-01-06On time
2512002702025-12-16PERSEDIAAN UMUM6030.0621KUAS 3 INCH2605004409,127.932512003472025-12-182025-12-301211,531.5322512008242025-12-2462026-01-06On time
2512002752025-12-16PERSEDIAAN UMUM6050.0111OXYGEN26060017745,0002512003852025-12-182025-12-181090,0002–––2025-12-25Overdue
2512002792025-12-16BAHAN PEMBANTU2022.0003PET STRAPPING BAND 15.5X0.8 MM PANJANG=1400 MTR260600221350,0002512003272025-12-182026-01-20700350,00022601010682026-01-30432026-01-27Late
2512002792025-12-16BAHAN PEMBANTU2022.0003PET STRAPPING BAND 15.5X0.8 MM PANJANG=1400 MTR260600221350,0002512003272025-12-182026-01-20700350,00022601010712026-01-30432026-01-27Late
2512002792025-12-16BAHAN PEMBANTU2022.0003PET STRAPPING BAND 15.5X0.8 MM PANJANG=1400 MTR260600221350,0002512003272025-12-182026-01-20700350,00022601005442026-01-17302026-01-27On time
2512002792025-12-16BAHAN PEMBANTU2022.0003PET STRAPPING BAND 15.5X0.8 MM PANJANG=1400 MTR260600221350,0002512003272025-12-182026-01-20700350,00022601003462026-01-12252026-01-27On time
2512002792025-12-16BAHAN PEMBANTU2022.0003PET STRAPPING BAND 15.5X0.8 MM PANJANG=1400 MTR260600221350,0002512003272025-12-182026-01-20700350,00022601007672026-01-22352026-01-27On time
2512002792025-12-16BAHAN PEMBANTU2022.0003PET STRAPPING BAND 15.5X0.8 MM PANJANG=1400 MTR260600221350,0002512003272025-12-182026-01-20700350,00022601001132026-01-06192026-01-27On time
2512002792025-12-16BAHAN PEMBANTU2022.0003PET STRAPPING BAND 15.5X0.8 MM PANJANG=1400 MTR260600221350,0002512003272025-12-182026-01-20700350,00022601006852026-01-21342026-01-27On time
2512002792025-12-16BAHAN PEMBANTU2022.0003PET STRAPPING BAND 15.5X0.8 MM PANJANG=1400 MTR260600221350,0002512003272025-12-182026-01-20700350,00022601016152026-02-14582026-01-27Late
2512002792025-12-16BAHAN PEMBANTU2022.0003PET STRAPPING BAND 15.5X0.8 MM PANJANG=1400 MTR260600221350,0002512003272025-12-182026-01-20700350,00022601016112026-02-14582026-01-27Late
2512002792025-12-16BAHAN PEMBANTU2022.0003PET STRAPPING BAND 15.5X0.8 MM PANJANG=1400 MTR260600221350,0002512003272025-12-182026-01-20700350,00022601013632026-02-09532026-01-27Late
2512002802025-12-16BAHAN PACKING3011.0045BOX PARIS T.S KW 1 30X302605003821,1772512003262025-12-182026-01-2030,0001,02522601002572026-01-09222026-01-27On time
2512002802025-12-16BAHAN PACKING3011.0139BOX PARIS HIJAU TS 30*30 KW 22605000989052512003262025-12-182026-01-2015,0001,0252–––2026-01-27Overdue
2512002802025-12-16BAHAN PACKING3011.0045BOX PARIS T.S KW 1 30X302605003821,1772512003262025-12-182026-01-2030,0001,02522601003332026-01-12252026-01-27On time
2512002812025-12-15BAHAN BAKAR4010.0001SOLAR26060011120,720.722512003212025-12-182025-12-248,00012,882.8832512007592025-12-2242025-12-31On time
2512002822025-12-17PERSEDIAAN UMUM6030.201BATAKO2605000395,0002512003332025-12-182025-12-184005,00012512007112025-12-2242025-12-25On time
2512100222025-12-08PERSEDIAAN UMUM6050.0692CUTTING DISC 14 INCH260110458896,6752512100982025-12-182025-12-261835,000102512104992025-12-2462026-01-02On time
2512100222025-12-08PERSEDIAAN UMUM6030.0033KAWAT LAS RB 26 3.2 MM26050021729,729.732512101012025-12-182025-12-1810030,85010–––2025-12-25Overdue
2512100262025-12-09STATIONERY6010.0729FORM BAST - BARANG JADI (3PLY) UKURAN 16 x 21 NO.DOC : FR-WFG-02/REV0026061017518,0002512101032025-12-182025-12-266018,00092601102462026-01-13262026-01-02Late
2512100262025-12-09STATIONERY6010.073FORM PENGECEKAN PENERIMAAN BARANG JADI GRANIT NO.DOC : FR-WFG-03/REV0026061017580,0002512101032025-12-182025-12-26380,00092601102462026-01-13262026-01-02Late
2512100262025-12-09STATIONERY6010.0728FORM BAST (3PLY) UKURAN 16 x 21 NO. DOC: FR-WFG-01/REV0026061017518,0002512101032025-12-182025-12-266018,00092601102462026-01-13262026-01-02Late
2512100472025-12-15PERSEDIAAN UMUM6050.0737LPG 12Kg ( Refill )260610118230,0002512100992025-12-182025-12-261190,00032601109152026-02-16602026-01-02Late
2512100502025-12-16PERSEDIAAN UMUM6030.0613METERAN 5 MTR2605101569,3632512101112025-12-182025-12-18218,622.522512104972025-12-2462025-12-25On time
2512100502025-12-16PERSEDIAAN UMUM6020.0052STOPWATCH260600222200,2502512101112025-12-182025-12-18426,48522512104972025-12-2462025-12-25On time
2512100512025-12-16BAHAN BAKU GLAZE1030.0081ORGANIC COMPOSITE SOLVENTS26041001272512101062025-12-182025-12-1830,000722512104522025-12-2022025-12-25On time
2512100522025-12-17PERSEDIAAN UMUM6050.1194LEMARI ARSIP KANTOR METAL SLIDE2512101021,350,4502512101022025-12-182025-12-1811,350,45012601111842026-02-27712025-12-25Late
2512100522025-12-17PERSEDIAAN UMUM6050.1195LEMARI ARSIP KANTOR METAL SLIDE HALF2512101021,260,3602512101022025-12-182025-12-1811,260,36012601111842026-02-27712025-12-25Late
2511004282025-11-28SPAREPART5028.0187PULLY B1 4 INCH BEARING 6301251200358280,0002512003582025-12-192026-01-106280,000212601003952026-01-13252026-01-17On time
2511004452025-11-28PERSEDIAAN UMUM6030.05CAT BESI TAHAN PANAS BIRU MUDA26010022281,0812512003752025-12-192025-12-29581,081212512008872025-12-2672026-01-05On time
2511004452025-11-28PERSEDIAAN UMUM6030.0499CAT BESI TAHAN PANAS HITAM260100681220,0002512003752025-12-192025-12-295082,883212512008872025-12-2672026-01-05On time
2511100972025-11-28PERSEDIAAN UMUM6060.064KONEKTOR SELANG 3/4 INCH25121010812,4952512101082025-12-192025-12-291212,495212512105302025-12-2782026-01-05On time
2511100972025-11-28PERSEDIAAN UMUM6030.2428DOUBLE NEPLE 1 INCH DRAT LUAR25121010813,7452512101082025-12-192025-12-29713,745212512105302025-12-2782026-01-05On time
2512001972025-12-11PERSEDIAAN UMUM6050.0109PLASTIK KANTONG 1/2 KG26050021315,0002512003792025-12-192025-12-2429,00082512007362025-12-2232025-12-31On time
2512002182025-12-12PERSEDIAAN UMUM6030.2484BESI AS VCN OD 20 MM251200378750,0002512003782025-12-192025-12-292750,00072512009222025-12-29102026-01-05On time
2512002292025-12-12SPAREPART5032.031OIL FILTER C 160525120036257,0002512003622025-12-192026-01-10557,00072601000582026-01-02142026-01-17On time
2512002292025-12-12SPAREPART5032.0245FUEL FILTER FC 1001260500325170,0002512003622025-12-192026-01-10595,00072601000582026-01-02142026-01-17On time
2512002292025-12-12SPAREPART5032.1022FILTER FC 170726040034888,3002512003632025-12-192026-01-10583,00072512008902025-12-2672026-01-17On time
2512002292025-12-12SPAREPART5032.1296AIR FILTER P522449251200362318,7502512003622025-12-192026-01-105318,75072601000582026-01-02142026-01-17On time
2512002292025-12-12SPAREPART5032.1297AIR FILTER P158671251200364237,0002512003642025-12-192026-01-103237,00072601005992026-01-19312026-01-17Late
2512002432025-12-13SPAREPART5032.0997WHEEL CYLINDER ASSY NO.1 / 24433-76000G251200376165,0002512003762025-12-192026-01-054165,00062512009212025-12-29102026-01-12On time
2512002432025-12-13SPAREPART5032.0999PIN, SHOE & LINING ASSY NO.11 / 24433-71000G251200377229,0002512003772025-12-192026-01-054229,00062601000492026-01-02142026-01-12On time
2512002432025-12-13SPAREPART5032.1PIN, SHOE & LINING ASSY NO.12 / 24433-75000G251200377235,0002512003772025-12-192026-01-054235,00062601000492026-01-02142026-01-12On time
2512002432025-12-13SPAREPART5032.1421SPRING & FITTING ASSY NO. 15/ 24433-73000G251200376100,0002512003762025-12-192026-01-052100,00062512009212025-12-29102026-01-12On time
2512002432025-12-13SPAREPART5032.1422RETURN SPRING, BRAKE SHOE NO. 22/ 24433-70060G25120037655,0002512003762025-12-192026-01-05455,00062512009212025-12-29102026-01-12On time
2512002452025-12-13SPAREPART5017.0059FUJI MAGNETIC CONTACTOR SC N10/220 V2601004143,822,0002512003702025-12-192026-01-0543,822,00062601001362026-01-06182026-01-12On time
2512002612025-12-16STATIONERY6010.0405STEMPEL25120037170,0002512003712025-12-192025-12-27570,00032512008972025-12-2672026-01-03On time
2512002702025-12-16PERSEDIAAN UMUM6050.0109PLASTIK KANTONG 1/2 KG26050021315,0002512003802025-12-192025-12-2659,00032512007372025-12-2232026-01-02On time
2512002762025-12-16STATIONERY6010.0012KERTAS HVS MERAH26060025758,0002512003592025-12-192025-12-30362,00032512007412025-12-2232026-01-06On time
2512002862025-12-17STATIONERY6010.0001KERTAS A426060024443,0002512003572025-12-192025-12-305043,50022512008832025-12-2672026-01-06On time
2512002882025-12-17PERSEDIAAN UMUM6030.25SIKA CERAMIC251200365105,0002512003652025-12-192025-12-195105,00022512007132025-12-2232025-12-26On time
2512002882025-12-17PERSEDIAAN UMUM6030.0004SEMEN GRESIK 40KG26050024159,5002512003652025-12-192025-12-192058,00022512007132025-12-2232025-12-26On time
2512002932025-12-17PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252512003722025-12-192026-01-05553,689.1922512007692025-12-2342026-01-12On time
2512002962025-12-17PERSEDIAAN UMUM6030.0474CAT TEMBOK PUTIH25120037320,902.522512003732025-12-192025-12-295020,902.5222512007672025-12-2342026-01-05On time
2512003002025-12-17PERSEDIAAN UMUM6030.0917THINER A BIASA @ 5 LTR26050040363,5002512003742025-12-192025-12-273132,525.2322512008342025-12-2452026-01-03On time
2512003002025-12-17PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002512003742025-12-192025-12-27236,225.2322512008342025-12-2452026-01-03On time
2512003002025-12-17PERSEDIAAN UMUM6030.0914THINER A BIASA @1 LTR26040044843,350.452512003742025-12-192025-12-27230,976.5822512008342025-12-2452026-01-03On time
2512003002025-12-17PERSEDIAAN UMUM6030.0846CAT AVIAN DIAMOND BLUE 73226010039857,472.972512003742025-12-192025-12-27657,472.9722512008342025-12-2452026-01-03On time
2512003002025-12-17PERSEDIAAN UMUM6050.0579CAT AVIAN KUNING ROAD LINE26060017158,502.72512003742025-12-192025-12-27646,559.4622512008342025-12-2452026-01-03On time
2512003002025-12-17PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232512003742025-12-192025-12-271057,472.9722512008342025-12-2452026-01-03On time
2512003002025-12-17PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252512003742025-12-192025-12-272853,689.1922512008342025-12-2452026-01-03On time
2512003002025-12-17PERSEDIAAN UMUM6030.1898CAT AVIAN SUPER BLACK GLOSS26051008270,725.122512003742025-12-192025-12-27557,472.9722512008342025-12-2452026-01-03On time
2512003012025-12-17PERSEDIAAN UMUM6030.0493CAT AVIAN SYNTETIC HITAM SB26040022063,219.822512003552025-12-192025-12-1943.262,868.1222512009012025-12-2672025-12-26On time
2512003012025-12-17PERSEDIAAN UMUM6030.0493CAT AVIAN SYNTETIC HITAM SB26040022063,219.822512003552025-12-192025-12-1943.262,868.1222601003482026-01-12242025-12-26Late
2512003012025-12-17PERSEDIAAN UMUM6030.0493CAT AVIAN SYNTETIC HITAM SB26040022063,219.822512003552025-12-192025-12-1943.262,868.1222601000932026-01-05172025-12-26Late
2512100532025-12-18BAHAN BAKU GLAZE1030.007ZIRCONIUM SILICATE MC11426051020737,855.882512101092025-12-192025-12-1935,00035,61712601102522026-01-14262025-12-26Late
2512100532025-12-18BAHAN BAKU GLAZE1030.0071CMC FOOD GRADE 30F26011024279,5002512101052025-12-192025-12-191,00079,50012512105252025-12-2672025-12-26On time
2512100532025-12-18BAHAN BAKU GLAZE1030.007ZIRCONIUM SILICATE MC11426051020737,855.882512101092025-12-192025-12-1935,00035,61712601105762026-01-31432025-12-26Late
2512100532025-12-18BAHAN BAKU GLAZE1030.007ZIRCONIUM SILICATE MC11426051020737,855.882512101092025-12-192025-12-1935,00035,61712601102532026-01-14262025-12-26Late
2512100532025-12-18BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412512101042025-12-192025-12-1984,0000.40512512105212025-12-2672025-12-26On time
2512100532025-12-18BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412512101042025-12-192025-12-1984,0000.40512601106622026-02-05482025-12-26Late
2512100532025-12-18BAHAN BAKU GLAZE1030.007ZIRCONIUM SILICATE MC11426051020737,855.882512101092025-12-192025-12-1935,00035,61712601109482026-02-16592025-12-26Late
2512100532025-12-18BAHAN BAKU GLAZE1030.007ZIRCONIUM SILICATE MC11426051020737,855.882512101092025-12-192025-12-1935,00035,61712601103922026-01-22342025-12-26Late
2512100532025-12-18BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412512101042025-12-192025-12-1984,0000.4051–––2025-12-26Overdue
2512100532025-12-18BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412512101042025-12-192025-12-1984,0000.4051–––2025-12-26Overdue
2512100532025-12-18BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.62512101042025-12-192025-12-19140,0000.59712601111482026-02-24672025-12-26Late
2512100532025-12-18BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.62512101042025-12-192025-12-19140,0000.5971–––2025-12-26Overdue
2512100532025-12-18BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.62512101042025-12-192025-12-19140,0000.5971–––2025-12-26Overdue
2512100532025-12-18BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.62512101042025-12-192025-12-19140,0000.5971–––2025-12-26Overdue
2512100552025-12-18PERSEDIAAN UMUM6050.1198BANNER 3S251210107330,0002512101072025-12-192025-12-297330,00012601109112026-02-16592026-01-05Late
2512000742025-12-03PERSEDIAAN UMUM6030.2449KABEL TRAY 100X50X2400MM251200369155,0002512003692025-12-202025-12-2075155,000172512009292025-12-2992025-12-27Late
2512000752025-12-03SPAREPART5017.1003PLC CP2E 24 VDC2512003683,517,5002512003682025-12-202025-12-2013,517,500172512008292025-12-2442025-12-27On time
2512001262025-12-06PERSEDIAAN UMUM6030.2464AKRILIK 3X1000X1000 MM251200388250,0002512003882025-12-202025-12-292250,000142512006822025-12-2222026-01-05On time
2512001922025-12-11PERSEDIAAN UMUM6030.0733RESIBON POTONG 105X1.2X162605004922,702.72512003672025-12-202025-12-202002,702.792512007732025-12-2332025-12-27On time
2512002092025-12-12PERSEDIAAN UMUM6020.0042TERMINAL KABEL 6 MM26050038658,558.562512003692025-12-202025-12-201005,00082512009292025-12-2992025-12-27Late
2512002112025-12-12PERSEDIAAN UMUM6030.0733RESIBON POTONG 105X1.2X162605004922,702.72512003672025-12-202025-12-201,0002,702.782512007812025-12-2332025-12-27On time
2512002142025-12-12PERSEDIAAN UMUM6050.0112AIR AKI 1500 ML26040000510,0002512003892025-12-202025-12-29128,00082512007122025-12-2222026-01-05On time
2512002752025-12-16PERSEDIAAN UMUM6050.0111OXYGEN26060017745,0002512004462025-12-202025-12-201090,00042512009182025-12-2772025-12-27On time
2512002782025-12-12STATIONERY6010.0743KERTAS STICKER ROLL 10X10 CM (GREEN LINE)25120038771,171.172512003872025-12-202026-01-1010071,171.1782601012642026-02-05472026-01-17Late
2512002852025-12-17PERSEDIAAN UMUM6030.2DR HOUZ CEILING PANEL FLAT 200MM CPLFI-302251200366491,891.892512003662025-12-202025-12-203491,891.8932512008272025-12-2442025-12-27On time
2512003082025-12-19BAHAN PEMBANTU2033.0001YELLOW INK26050026881,5002512003912025-12-202025-12-306080,00012512009092025-12-2772026-01-06On time
← PrevPage 20 of 135Next →Rows per page:1020501005001000