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
2512002282025-12-12SPAREPART5030.178FTC TASTEGGIO 0.08M 24V O8H222 IFM 700043002512005542,017,3542512005542025-12-302026-02-2082,017,354182601017182026-02-18502026-02-27On time
2512002282025-12-12SPAREPART5030.1779FTC TASTEGGIO 30-120mm 24V P1KH009 WENGLOR 700063862512005541,641,2762512005542025-12-302026-02-2081,641,276182601017182026-02-18502026-02-27On time
2512002282025-12-12SPAREPART5030.1779FTC TASTEGGIO 30-120mm 24V P1KH009 WENGLOR 700063862512005541,641,2762512005542025-12-302026-02-2081,641,276182603010082026-03-31912026-02-27Late
2512002282025-12-12SPAREPART5030.1778GEAR 8112092900251200554645,3682512005542025-12-302026-02-206645,368182603004042026-03-10702026-02-27Late
2512002282025-12-12SPAREPART5030.1776LINEAR BEARING 900066252512005541,079,4822512005542025-12-302026-02-2041,079,482182601001622026-01-0782026-02-27On time
2512002282025-12-12SPAREPART5030.1775TIMING BELT LATERAL & FRONTAL 9994050031251200554113,7522512005542025-12-302026-02-2016113,752182603010082026-03-31912026-02-27Late
2512002282025-12-12SPAREPART5030.1774RUBBER GRIPPER DIVIDER HORIZONTAL 8010939326060023617.92512005542025-12-302026-02-208420,185182601017182026-02-18502026-02-27On time
2512002282025-12-12SPAREPART5030.1774RUBBER GRIPPER DIVIDER HORIZONTAL 8010939326060023617.92512005542025-12-302026-02-208420,185182601010142026-01-29302026-02-27On time
2512002422025-12-13SPAREPART5029.0453PRESSURE SWITCH CCT+0008346 EX-CC2508000425120055542.552512005552025-12-302026-02-28242.55172601016042026-02-14462026-03-07On time
2512002422025-12-13SPAREPART5029.0361PRESSURE SWITCH CCT+0008347 EX-CC2508000625120055542.552512005552025-12-302026-02-28242.55172601016042026-02-14462026-03-07On time
2512002422025-12-13SPAREPART5029.0364MAX PRESSURE SWITCH CCT+0008347 EX-CC2508000625120055542.552512005552025-12-302026-02-28142.55172601016042026-02-14462026-03-07On time
2512002422025-12-13SPAREPART5029.0397MIN PRESSURE SWITCH CCT+0008347 EX-CC2508000625120055542.552512005552025-12-302026-02-28142.55172601016042026-02-14462026-03-07On time
2512002422025-12-13SPAREPART5029.0396VACUUM SWITCH CCT+0008346 EX-CC2508000425120055542.552512005552025-12-302026-02-28142.55172601016042026-02-14462026-03-07On time
2512002472025-12-13FIXED ASSETSAST02546TV LCD 65" SMART TV2512005506,700,0002512005502025-12-302025-12-3016,700,000172601006022026-01-19202026-01-06Late
2512002912025-12-17SPAREPART5026.001POMPA GOTEC 96800201022604000642,586,1312512005532025-12-302026-02-20102,553,613132601001612026-01-0782026-02-27On time
2512002912025-12-17SPAREPART5026.0108FOT LASER CAT. 10MT S8PH5B51PP DATA SENSOR 76029990122512005533,296,4822512005532025-12-302026-02-2013,296,482132603004062026-03-10702026-02-27Late
2512003262025-12-19SPAREPART5017.0393LAMPU SMART BRIGHT HIGHBAY BY239P LED 180/CW PSU GM G2 150 WATT2512005341,861,8002512005342025-12-302025-12-30601,861,800112601001262026-01-0672026-01-06On time
2512003412025-12-19PERSEDIAAN UMUM6030.2507PLAT STRIP STAINLESS 10X100X6000 MM2512005432,072,072.072512005432025-12-302026-01-1412,072,072.07112601002652026-01-09102026-01-21On time
2512003462025-12-19PERSEDIAAN UMUM6060.0256RING PLAT 1MM X ID 6 MM X OD 24 MM2512005372052512005372025-12-302026-01-201,000205112601000522026-01-0232026-01-27On time
2512003462025-12-19PERSEDIAAN UMUM6060.024RING PLAT M-182605004648052512005372025-12-302026-01-201,000805112601000522026-01-0232026-01-27On time
2512003562025-12-20SPAREPART5030.179FILTER PRINT HEAD ZANASI251200552850,0002512005522025-12-302026-01-1810850,000102601003422026-01-12132026-01-25On time
2512003812025-12-22PERSEDIAAN UMUM6050.1214MEJA UK 120X70251200549420,0002512005492025-12-302025-12-302420,0008–––2026-01-06Overdue
2512003812025-12-22PERSEDIAAN UMUM6050.1213LEMARI PAKAIAN251200549920,0002512005492025-12-302025-12-304920,0008–––2026-01-06Overdue
2512004022025-12-23BAHAN PACKING3011.0044BOX JUPITER T.S KW 1 30X302605003821,1772512005412025-12-302026-01-2630,0001,0257–––2026-02-02Overdue
2512004022025-12-23BAHAN PACKING3011.0046BOX KAISAR T.S KW 1 30X302603000451,0762512005412025-12-302026-01-2630,0001,0257–––2026-02-02Overdue
2512004022025-12-23BAHAN PACKING3011.0045BOX PARIS T.S KW 1 30X302605003821,1772512005412025-12-302026-01-2615,0001,0257–––2026-02-02Overdue
2512004062025-12-26PERSEDIAAN UMUM6030.212DOUBLE FOAM TAPE 3M 24MM26050017626,0002512005382025-12-302026-01-15210,00042601000642026-01-0232026-01-22On time
2512004062025-12-26PERSEDIAAN UMUM6050.0109PLASTIK KANTONG 1/2 KG26050021315,0002512005452025-12-302026-01-10208,50042601000652026-01-0232026-01-17On time
2512004062025-12-26PERSEDIAAN UMUM6050.0108PLASTIK KANTONG 1 KG26050021315,0002512005452025-12-302026-01-1058,50042601000652026-01-0232026-01-17On time
2512004062025-12-26STATIONERY6010.0589LAKBAN HITAM 2 INCI / 48MM2604004939,9002512005382025-12-302026-01-15114,00042601000642026-01-0232026-01-22On time
2512004082025-12-26PERSEDIAAN UMUM6030.1302FLANGE 3 INCH JIS 10K26010032040,540.542512005462025-12-302025-12-305038,738.7442601006062026-01-19202026-01-06Late
2512004102025-12-26PERSEDIAAN UMUM6030.1731KAWAT LAS LB 52 Ø 2,6MM26031009344,3002512005472025-12-302025-12-3010042,20042601002612026-01-09102026-01-06Late
2512004102025-12-26PERSEDIAAN UMUM6030.0803KAWAT LAS LB 52 OD 3.2 MM26060012341,531.532512005482025-12-302025-12-3010036,531.5342601001322026-01-0672026-01-06On time
2512004102025-12-26PERSEDIAAN UMUM6030.0033KAWAT LAS RB 26 3.2 MM26050021729,729.732512005482025-12-302025-12-3020027,162.1642601001322026-01-0672026-01-06On time
2512004322025-12-24BAHAN PACKING3011.0026BOX KOBIN MERAH TS 40*40 KW I2606001201,2752512005402025-12-302026-01-20110,0001,03062601002872026-01-10112026-01-27On time
2512004322025-12-24BAHAN PACKING3011.0026BOX KOBIN MERAH TS 40*40 KW I2606001201,2752512005402025-12-302026-01-20110,0001,03062601005822026-01-19202026-01-27On time
2512004322025-12-24BAHAN PACKING3011.0029BOX JUPITER MERAH TS 40*40 KW I2606001201,2752512005402025-12-302026-01-2080,0001,03062601002872026-01-10112026-01-27On time
2512004322025-12-24BAHAN PACKING3011.0026BOX KOBIN MERAH TS 40*40 KW I2606001201,2752512005402025-12-302026-01-20110,0001,03062601003272026-01-12132026-01-27On time
2512004362025-12-23PERSEDIAAN UMUM6030.1561BETON READYMIX MUTU K300260600062780,0002512005692025-12-302025-12-304750,00072601003732026-01-13142026-01-06Late
2512004362025-12-23PERSEDIAAN UMUM6030.1561BETON READYMIX MUTU K300260600062780,0002512005232025-12-302025-12-3010880,00072601000552026-01-0232026-01-06On time
2512100312025-12-11SPAREPART5032.1361RIM ASSY PN.41C3487-LIG25121015111,714,8002512101512025-12-302025-12-31111,714,800192601107542026-02-09412026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6020.0694INSULATED RV TYPE O-TYPE TERMINAL LUG (RV1.25-4)25121016612,5002512101662025-12-302026-01-08312,500182601100912026-01-0892026-01-15On time
2512100372025-12-12PERSEDIAAN UMUM6020.0693INSULATED SV TYPE U-TYPE TERMINAL LUG (SV5.5-6)25121016538,5002512101642025-12-302026-01-08138,500182601100982026-01-0892026-01-15On time
2512100372025-12-12PERSEDIAAN UMUM6020.0693INSULATED SV TYPE U-TYPE TERMINAL LUG (SV5.5-6)25121016538,5002512101652025-12-302026-01-08238,500182601100992026-01-0892026-01-15On time
2512100372025-12-12PERSEDIAAN UMUM6020.0692INSULATED SV TYPE U-TYPE TERMINAL LUG (SV3.5-6)25121016435,0002512101642025-12-302026-01-08235,000182601100982026-01-0892026-01-15On time
2512100372025-12-12PERSEDIAAN UMUM6020.0692INSULATED SV TYPE U-TYPE TERMINAL LUG (SV3.5-6)25121016435,0002512101632025-12-302026-01-08335,000182601100962026-01-0892026-01-15On time
2512100372025-12-12PERSEDIAAN UMUM6020.0691INSULATED SV TYPE U-TYPE TERMINAL LUG (SV2-4)25121016015,0282512101602025-12-302026-01-08515,028182601100932026-01-0892026-01-15On time
2512100372025-12-12PERSEDIAAN UMUM6020.0689INSULATED SV TYPE U-TYPE TERMINAL LUG (SV1.25-3)25121016013,1612512101602025-12-302026-01-08713,161182601100932026-01-0892026-01-15On time
2512100372025-12-12PERSEDIAAN UMUM6020.069INSULATED SV TYPE U-TYPE TERMINAL LUG (SV1.25-4)25121016013,1612512101602025-12-302026-01-08713,161182601100932026-01-0892026-01-15On time
2512100372025-12-12PERSEDIAAN UMUM6030.097HOLE SAW 2225121015924,2002512101592025-12-302026-01-082024,200182601100942026-01-0892026-01-15On time
← PrevPage 54 of 270Next →Rows per page:1020501005001000