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
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,00040815–––2026-01-14Overdue
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601104372026-01-23162026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605107772026-05-251382026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605100292026-05-041172026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605100302026-05-041172026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601112092026-02-27512026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604100082026-04-02852026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604100092026-04-02852026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604100452026-04-04872026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605100312026-05-041172026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604105352026-04-281112026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604100112026-04-02852026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601106632026-02-05292026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604100462026-04-04872026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601103652026-01-20132026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601103642026-01-20132026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601103632026-01-20132026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605101632026-05-091222026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604101042026-04-07902026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601107892026-02-10342026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601112552026-02-28522026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601107882026-02-10342026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604101052026-04-07902026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605103582026-05-161292026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601107902026-02-10342026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605103592026-05-161292026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601110592026-02-20442026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604105182026-04-281112026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601107922026-02-10342026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605104562026-05-181312026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152603100502026-03-03552026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152603100512026-03-03552026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601103622026-01-20132026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152603101672026-03-09612026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152603100642026-03-04562026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152603100482026-03-03552026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152603104102026-03-31832026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605102732026-05-131262026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601112102026-02-27512026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601103612026-01-20132026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152603100492026-03-03552026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605103602026-05-161292026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601107072026-02-07312026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601107862026-02-10342026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152603103542026-03-26782026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605102342026-05-121252026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605103612026-05-161292026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601108752026-02-12362026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605102352026-05-121252026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601107942026-02-10342026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604104892026-04-271102026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605104572026-05-181312026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605101652026-05-091222026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,00040815–––2026-01-14Overdue
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604105862026-04-301132026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601108732026-02-12362026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605101642026-05-091222026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601103862026-01-21142026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601103662026-01-20132026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601112082026-02-27512026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152603101432026-03-07592026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605102722026-05-131262026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604105002026-04-271102026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601107912026-02-10342026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152603100472026-03-03552026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604101012026-04-07902026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604104882026-04-271102026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604104542026-04-241072026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605102492026-05-121252026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604100072026-04-02852026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604104182026-04-211042026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604105872026-04-301132026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601107932026-02-10342026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604100102026-04-02852026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601107872026-02-10342026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152603100202026-03-02542026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601112112026-02-27512026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152603102332026-03-12642026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601112282026-02-27512026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605102362026-05-121252026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604104172026-04-211042026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605102472026-05-121252026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152605102482026-05-121252026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152604105882026-04-301132026-01-14Late
2512100642025-12-23BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402601100262026-01-072026-01-075,000,000408152601104362026-01-23162026-01-14Late
2601000022026-01-02PERSEDIAAN UMUM6050.0156BATERAY 65D 26R NS702604003671,224,0002601000772026-01-072026-01-1921,350,00052601002602026-01-0922026-01-26On time
2601000122026-01-02SPAREPART5030.0402MALE CONNECTOR KQ2H04-M5 (SMC)26010007532,3002601000752026-01-072026-01-263032,30052601002492026-01-0922026-02-02On time
2601000122026-01-02SPAREPART5030.0402MALE CONNECTOR KQ2H04-M5 (SMC)26010007532,3002601000752026-01-072026-01-263032,30052601005052026-01-1582026-02-02On time
2601000162026-01-03PERSEDIAAN UMUM6050.0313AIR MINERAL BOTOL KECIL 220 ML26060024819,819.822601000892026-01-072026-01-101019,369.3742601002382026-01-0812026-01-17On time
2601000162026-01-03PERSEDIAAN UMUM6010.0351AIR MINERAL GALON26060024818,018.022601000892026-01-072026-01-102517,567.5742601002382026-01-0812026-01-17On time
2601000182026-01-03STATIONERY6010.0775TINTA EPSON 001 MAGENTA260100088123,3002601000882026-01-072026-01-191123,30042601003452026-01-1252026-01-26On time
2601000182026-01-03STATIONERY6010.0774TINTA EPSON 001 CYAN260100088123,3002601000882026-01-072026-01-191123,30042601003452026-01-1252026-01-26On time
2601000182026-01-03STATIONERY6010.0776TINTA EPSON 001 YELLOW260100088123,3002601000882026-01-072026-01-191123,30042601003452026-01-1252026-01-26On time
2601000182026-01-03STATIONERY6010.0773TINTA EPSON 001 BLACK260100088184,4002601000882026-01-072026-01-191184,40042601003452026-01-1252026-01-26On time
2601000512026-01-06BAHAN PEMBANTU2024.0001OPP 48*10026050005510,4952601000732026-01-072026-01-145767,00012601004322026-01-1362026-01-21On time
2601000522026-01-06BAHAN PEMBANTU2024.0004STRETCH FILM260500461535,0002601000722026-01-072026-01-1240355,00012601003782026-01-1362026-01-19On time
2601000572026-01-06PERSEDIAAN UMUM6050.1263SARUNG TANGAN KULIT260100091144,5002601000912026-01-072026-01-263144,50012601006032026-01-19122026-02-02On time
2601100052026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601100512026-01-072026-01-192,00041,0002–––2026-01-26Overdue
2601100052026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601100512026-01-072026-01-192,00041,00022601102652026-01-1472026-01-26On time
2601100052026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601100512026-01-072026-01-192,00041,00022601104442026-01-23162026-01-26On time
← PrevPage 33 of 135Next →Rows per page:1020501005001000