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
2512100372025-12-12PERSEDIAAN UMUM6050.1184RIBBON (FOR PUTY PT1010)26011024576,0002512101582025-12-302026-01-08580,000182601100922026-01-0892026-01-15On time
2512100392025-12-13PERSEDIAAN UMUM6060.0208MUR M 102605004644502512101572025-12-302026-01-08500380172601101012026-01-0892026-01-15On time
2512100392025-12-13PERSEDIAAN UMUM6060.0236RING PLAT M-102605004641452512101532025-12-302026-01-08500200172601103132026-01-17182026-01-15Late
2512100392025-12-13PERSEDIAAN UMUM6060.0015BAUT M-10*302604005258852512101532025-12-302026-01-085001,000172601103132026-01-17182026-01-15Late
2512100392025-12-13PERSEDIAAN UMUM6030.2489KANCING KUNCI SPRING J1052512101703,8412512101702025-12-302026-01-08203,841172601100972026-01-0892026-01-15On time
2512100412025-12-15PERSEDIAAN UMUM6030.2491BOR TANGAN MAKITA 12V 380RPM - 1300RPM2512101671,525,0002512101672025-12-302026-01-0811,525,000152601102412026-01-13142026-01-15On time
2512100472025-12-15PERSEDIAAN UMUM6020.045EXHAUST FAN 16 INCH251210154826,0002512101542025-12-302026-01-082826,000152601103122026-01-17182026-01-15Late
2512100482025-12-16PERSEDIAAN UMUM6020.0035BATERAI AA2601104505,5002512101552025-12-302026-01-08125,500142601102432026-01-13142026-01-15On time
2512100492025-12-16PERSEDIAAN UMUM6030.0532LEM GASKET25121015627,5002512101562025-12-302026-01-081027,500142601102362026-01-13142026-01-15On time
2512100522025-12-17PERSEDIAAN UMUM6050.1192JOLY BOX 40025121016840,8502512101682025-12-302026-01-082540,850132601101022026-01-0892026-01-15On time
2512100522025-12-17PERSEDIAAN UMUM6050.0551JOLY BOX 30025121016931,3502512101692025-12-302026-01-083531,350132601101032026-01-0892026-01-15On time
2512100522025-12-17PERSEDIAAN UMUM6050.1193YELLOW FLOOR MARKING TAPES25121016165,0002512101612025-12-302026-01-08565,000132601103102026-01-17182026-01-15Late
2512100722025-12-26BAHAN PACKING3011.0239CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWB 605X38 (BK150/125/125)2512101524942512101522025-12-302025-12-3067,20049442601102782026-01-15162026-01-06Late
2512100722025-12-26BAHAN PACKING3011.024CARTON BOX SIDEWRAPS PARIS 60X60 GP MP1 KWB 605X40 (BK150/125/125)260110083645.122512101522025-12-302025-12-3037,80055742601102792026-01-15162026-01-06Late
2512100722025-12-26BAHAN PACKING3011.0239CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWB 605X38 (BK150/125/125)2512101524942512101522025-12-302025-12-3067,20049442601102762026-01-15162026-01-06Late
2512100722025-12-26BAHAN PACKING3011.0238CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWB 605X40 (BK150/125/125)2512101525572512101522025-12-302025-12-3067,20055742601102772026-01-15162026-01-06Late
2512100722025-12-26BAHAN PACKING3011.0238CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWB 605X40 (BK150/125/125)2512101525572512101522025-12-302025-12-3067,20055742601102782026-01-15162026-01-06Late
2512100722025-12-26BAHAN PACKING3011.0238CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWB 605X40 (BK150/125/125)2512101525572512101522025-12-302025-12-3067,20055742601102762026-01-15162026-01-06Late
2512100722025-12-26BAHAN PACKING3011.0239CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWB 605X38 (BK150/125/125)2512101524942512101522025-12-302025-12-3067,20049442601102772026-01-15162026-01-06Late
2512100722025-12-26BAHAN PACKING3011.0214CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWB 605X38 (WK150/125/125)260110083609.62512101522025-12-302025-12-3012,60049442601102762026-01-15162026-01-06Late
2512100722025-12-26BAHAN PACKING3011.0241CARTON BOX SIDEWRAPS PARIS 60X60 GP MP2 KWB 605X38 (BK150/125/125)260110083609.62512101522025-12-302025-12-3037,80049442601102792026-01-15162026-01-06Late
2512100722025-12-26BAHAN PACKING3011.0213CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWB 605X40 (WK150/125/125)260110083645.122512101522025-12-302025-12-3012,60055742601102762026-01-15162026-01-06Late
2512100722025-12-26BAHAN PACKING3011.0242CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP1 KWB 605X40 (BK150/125/125)260110083645.122512101522025-12-302025-12-3021,00055742601102762026-01-15162026-01-06Late
2512100722025-12-26BAHAN PACKING3011.0243CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP2 KWB 605X38 (BK150/125/125)260110083609.62512101522025-12-302025-12-3021,00049442601102762026-01-15162026-01-06Late
2512100742025-12-29PERSEDIAAN UMUM6030.0033KAWAT LAS RB 26 3.2 MM26050021729,729.732512101502025-12-302025-12-302030,85012601102442026-01-13142026-01-06Late
2512100742025-12-29PERSEDIAAN UMUM6030.0036KAWAT LAS LB 26 3.2260500347297.32512101502025-12-302025-12-302042,25012601102442026-01-13142026-01-06Late
2512100762025-12-30PERSEDIAAN UMUM6020.0742GALVANIS POLE 2'' 6METER BASE PLATE2512101711,900,0002512101712025-12-302026-01-3011,900,000–2603101372026-03-07672026-02-06Late
2512100762025-12-30PERSEDIAAN UMUM6020.0743BRIDGE CABLE GALVANIS 2" 6 X 4 BASE PLATE2512101712,850,0002512101712025-12-302026-01-3012,850,000–2603101372026-03-07672026-02-06Late
2512100762025-12-30PERSEDIAAN UMUM6020.0741CABLE POWER 2 X 1,525121017114,2502512101712025-12-302026-01-301014,250–2603101372026-03-07672026-02-06Late
2512100762025-12-30PERSEDIAAN UMUM6020.074BOX PANEL 40X60 INCLUDE STOP CONTACT 4 HOLE251210171878,7502512101712025-12-302026-01-301878,750–2603101372026-03-07672026-02-06Late
2512100762025-12-30PERSEDIAAN UMUM6020.0738PACTHCORD FO25121017171,2502512101712025-12-302026-01-30471,250–2603101372026-03-07672026-02-06Late
2512100762025-12-30PERSEDIAAN UMUM6020.0514GIGABIT MEDIA CONVERTER251210171475,0002512101712025-12-302026-01-302475,000–2603101372026-03-07672026-02-06Late
2512100762025-12-30PERSEDIAAN UMUM6030.1886PIPA CONDUIT 20MM25121017114,2502512101712025-12-302026-01-3045014,250–2603101372026-03-07672026-02-06Late
2512100762025-12-30PERSEDIAAN UMUM6020.0739JOINTING CONDUIT 20MM25121017180,7502512101712025-12-302026-01-30580,750–2603101372026-03-07672026-02-06Late
2512100762025-12-30PERSEDIAAN UMUM6020.0346KABEL UTP CAT 62512101712,090,0002512101712025-12-302026-01-3052,090,000–2603101372026-03-07672026-02-06Late
2512100762025-12-30PERSEDIAAN UMUM6020.0529KONEKTOR RJ452601005922,5002512101712025-12-302026-01-301142,500–2603101372026-03-07672026-02-06Late
2512100762025-12-30PERSEDIAAN UMUM6020.042IP CAMERA HIKVISION + POE251210171570,0002512101712025-12-302026-01-3020570,000–2603101372026-03-07672026-02-06Late
2512100762025-12-30PERSEDIAAN UMUM6020.0736SWICTH POE 16 PORT2512101711,994,0502512101712025-12-302026-01-3011,994,050–2603101372026-03-07672026-02-06Late
2512100762025-12-30PERSEDIAAN UMUM6020.0737SWICTH POE 4 PORT251210171507,746.52512101712025-12-302026-01-302507,746.5–2603101372026-03-07672026-02-06Late
2512100772025-12-30SPAREPART5026.0249TESTINA 600DPI (SG600-SC-MF)2100309653 DIMATIX251210162116,537,5932512101622025-12-302025-12-301116,537,593–2601104482026-01-27282026-01-06Late
2512100772025-12-30SPAREPART5026.02VACUM PUMP MODEL/TYPE : 966300010725121016213,975,2252512101622025-12-302025-12-30113,975,225–2601104482026-01-27282026-01-06Late
2512100772025-12-30SPAREPART5026.021CONNECTOR MODEL/TYPE : 960047033425121016237,1432512101622025-12-302025-12-30237,143–2601104482026-01-27282026-01-06Late
2512100772025-12-30SPAREPART5017.1055MODULO ACCOPPIATORE ETHERCAT (ID) EK1101 BECKHOFF2512101624,139,9482512101622025-12-302025-12-3014,139,948–2601104482026-01-27282026-01-06Late
2512100772025-12-30SPAREPART5026.0201THERMAL MAGNETIC PUMP MODEL/TYPE : 96800201022512101622,553,6132512101622025-12-302025-12-3042,553,613–2601104482026-01-27282026-01-06Late
2511100992025-11-29PERSEDIAAN UMUM6030.2397ELBOW LAS 3 INCH26011011783,571.52512101772025-12-312026-01-093083,214322601101082026-01-0882026-01-16On time
2512001182025-12-08BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502512005642025-12-312026-01-15900,0001,530232601002112026-01-0882026-01-22On time
2512001182025-12-08BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502512005642025-12-312026-01-15900,0001,530232601002122026-01-0882026-01-22On time
2512001182025-12-08BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502512005642025-12-312026-01-15900,0001,530232601002132026-01-0882026-01-22On time
2512001182025-12-08BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502512005642025-12-312026-01-15900,0001,530232601002672026-01-0992026-01-22On time
2512001182025-12-08BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502512005642025-12-312026-01-15900,0001,530232601004442026-01-14142026-01-22On time
← PrevPage 55 of 270Next →Rows per page:1020501005001000