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.0043BOX KOBIN T.S KW 1 30X302604004001,1772512003222025-12-182026-01-10120,00095152512009082025-12-2792026-01-17On 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
2512002572025-12-15PERSEDIAAN UMUM6030.1898CAT AVIAN SUPER BLACK GLOSS26051008270,725.122512003282025-12-182025-12-302457,472.9732512007682025-12-2352026-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,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
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,00022601010682026-01-30432026-01-27Late
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,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,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,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
2512002802025-12-16BAHAN PACKING3011.0045BOX PARIS T.S KW 1 30X302605003821,1772512003262025-12-182026-01-2030,0001,02522601003332026-01-12252026-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,02522601002572026-01-09222026-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 UMUM6030.0033KAWAT LAS RB 26 3.2 MM26050021729,729.732512101012025-12-182025-12-1810030,85010–––2025-12-25Overdue
2512100222025-12-08PERSEDIAAN UMUM6050.0692CUTTING DISC 14 INCH260110458896,6752512100982025-12-182025-12-261835,000102512104992025-12-2462026-01-02On time
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
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
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.1297AIR FILTER P158671251200364237,0002512003642025-12-192026-01-103237,00072601005992026-01-19312026-01-17Late
2512002292025-12-12SPAREPART5032.1296AIR FILTER P522449251200362318,7502512003622025-12-192026-01-105318,75072601000582026-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.031OIL FILTER C 160525120036257,0002512003622025-12-192026-01-10557,00072601000582026-01-02142026-01-17On time
2512002432025-12-13SPAREPART5032.1422RETURN SPRING, BRAKE SHOE NO. 22/ 24433-70060G25120037655,0002512003762025-12-192026-01-05455,00062512009212025-12-29102026-01-12On time
← PrevPage 39 of 270Next →Rows per page:1020501005001000