KKobin GroupProcurement KPI

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
2511003052025-11-22BAHAN BAKU BODY1010.0006PHIROPILIT (GUNUNG BALE)2606000072202511004032025-11-272025-12-202,450,00020552512006612025-12-19222025-12-27On time
2511003052025-11-22BAHAN BAKU BODY1010.0006PHIROPILIT (GUNUNG BALE)2606000072202511004032025-11-272025-12-202,450,00020552601005172026-01-15492025-12-27Late
2511003052025-11-22BAHAN BAKU BODY1010.0006PHIROPILIT (GUNUNG BALE)2606000072202511004032025-11-272025-12-202,450,00020552512010092025-12-30332025-12-27Late
2511003052025-11-22BAHAN BAKU BODY1010.0006PHIROPILIT (GUNUNG BALE)2606000072202511004032025-11-272025-12-202,450,00020552601004862026-01-15492025-12-27Late
2511003052025-11-22BAHAN BAKU BODY1010.0006PHIROPILIT (GUNUNG BALE)2606000072202511004032025-11-272025-12-202,450,00020552512008932025-12-26292025-12-27On time
2511003052025-11-22BAHAN BAKU BODY1010.0006PHIROPILIT (GUNUNG BALE)2606000072202511004032025-11-272025-12-202,450,00020552512007952025-12-23262025-12-27On time
2511003052025-11-22BAHAN BAKU BODY1010.0006PHIROPILIT (GUNUNG BALE)2606000072202511004032025-11-272025-12-202,450,00020552512007462025-12-22252025-12-27On time
2511003052025-11-22BAHAN BAKU BODY1010.0006PHIROPILIT (GUNUNG BALE)2606000072202511004032025-11-272025-12-202,450,00020552512006692025-12-20232025-12-27On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512002172025-12-08112025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052025-12-22Overdue
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512003242025-12-10132025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052025-12-22Overdue
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512001882025-12-0692025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512001622025-12-0582025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512001612025-12-0582025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512000852025-12-0582025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512004862025-12-15182025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512004872025-12-15182025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512002812025-12-09122025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512003942025-12-13162025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512003562025-12-11142025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512005412025-12-16192025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512007502025-12-22252025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052025-12-22Overdue
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052512003462025-12-11142025-12-22On time
2511003082025-11-22BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472511004052025-11-272025-12-151,900,00014052604006282026-04-171412025-12-22Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652025-12-27Overdue
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512007422025-12-22252025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512006522025-12-19222025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652601002002026-01-08422025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652601001422026-01-06402025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652601002232026-01-08422025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652601001062026-01-05392025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512010352025-12-31342025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512008982025-12-26292025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512005402025-12-16192025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512000842025-12-0582025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512000812025-12-0582025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512001652025-12-0582025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512001822025-12-0692025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512004842025-12-15182025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512003252025-12-10132025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512002802025-12-09122025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512003932025-12-13162025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512003402025-12-11142025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512004852025-12-15182025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652601004112026-01-13472025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512006532025-12-19222025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512000802025-12-0582025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512009522025-12-29322025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512002212025-12-08112025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512010162025-12-31342025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512003522025-12-11142025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652601005692026-01-19532025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652601005142026-01-15492025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652601004852026-01-15492025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652601003622026-01-13472025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512010082025-12-30332025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512008452025-12-24272025-12-27On time
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652512009592025-12-29322025-12-27Late
2511003092025-11-22BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442511004042025-11-272025-12-203,300,00013652601015632026-02-13782025-12-27Late
2511003422025-11-21SPAREPART5017.0375OMRON RELAY MY4-N220 VAC26040018452,0002511003932025-11-272025-12-151048,00062512003752025-12-12152025-12-22On time
2511003422025-11-21SPAREPART5017.0053SELENOID VALVE SPC 4V210-08/220 VAC260500011100,0002511003922025-11-272025-12-20564,00062512000332025-12-0142025-12-27On time
2511003422025-11-21SPAREPART5017.0052SELENOID VALVE SPC 4V210-08/24 VDC260500011140,0002511003922025-11-272025-12-20564,00062512000332025-12-0142025-12-27On time
2511003422025-11-21SPAREPART5017.0054FUJI CONTACTOR SC 0/220 V260500161220,0002511003912025-11-272025-12-1010202,00062512000542025-12-0362025-12-17On time
2511003452025-11-21SPAREPART5011.0091BEARING 6200 2RS26010094323,9002511003982025-11-272025-12-205022,40062512002602025-12-09122025-12-27On time
2511003452025-11-21SPAREPART5011.0075BEARING 6009 2RS.C325120028958,8002511003992025-11-272025-12-20558,70062512001382025-12-0582025-12-27On time
2511003452025-11-21SPAREPART5011.0065BEARING 6002 2RS26050046920,0002511003972025-11-272025-12-205019,30062512000642025-12-0582025-12-27On time
2511003452025-11-21SPAREPART5011.0092BEARING 6201 2RS.C326050027817,8002511003992025-11-272025-12-203017,80062512001382025-12-0582025-12-27On time
2511003452025-11-21SPAREPART5011.0103BEARING 6207 2RS C326041014053,9402511003972025-11-272025-12-201047,80062512000642025-12-0582025-12-27On time
2511003452025-11-21SPAREPART5011.0109BEARING 6210 2RS C325110039989,6002511003992025-11-272025-12-201089,60062512001382025-12-0582025-12-27On time
2511003452025-11-21SPAREPART5011.0279BEARING UCP 206260400546120,3002511003982025-11-272025-12-2010126,05062512001012025-12-0582025-12-27On time
2511003452025-11-21SPAREPART5011.0393BEARING 6206 ZZ26050047035,1002511003972025-11-272025-12-201034,50062512000642025-12-0582025-12-27On time
2511003452025-11-21SPAREPART5011.0144BEARING 6305 2RS26050014943,6002511003972025-11-272025-12-201042,80062512000642025-12-0582025-12-27On time
2511003452025-11-21SPAREPART5011.0149BEARING 6308 2RS C325110039789,8002511003972025-11-272025-12-20589,80062512000642025-12-0582025-12-27On time
2511003452025-11-21SPAREPART5011.0118BEARING 6215 2RS251100399340,5002511003992025-11-272025-12-205340,50062512001382025-12-0582025-12-27On time
2511003452025-11-21SPAREPART5011.0137BEARING 6302 2RS26050014825,0002511003992025-11-272025-12-20525,00062512001382025-12-0582025-12-27On time
2511003452025-11-21SPAREPART5011.0061BEARING 6000 2RS26050014923,8002511003982025-11-272025-12-201022,60062512001012025-12-0582025-12-27On time
2511003512025-11-21FIXED ASSETSAST02483Laptop Core i7 Ram 16GB SSD 1TB25110037711,600,0002511003772025-11-272025-11-27111,600,00062512000512025-12-0362025-12-04On time
2511003542025-11-21PERSEDIAAN UMUM6050.0175GEMBOK 40MM26050023720,0002511003902025-11-272025-12-05420,00062511008972025-11-2922025-12-12On time
2511003592025-11-22PERSEDIAAN UMUM6030.0625SELANG SPIRAL 2.5 INCH25110039664,0002511003962025-11-272025-12-205064,00052512004432025-12-13162025-12-27On time
2511003662025-11-24PERSEDIAAN UMUM6050.1106ROCKWOOL 3000X900X100 MM260300133870,0002511003832025-11-272025-11-27386850,00032512004262025-12-13162025-12-04Late
2511003672025-11-26SPAREPART5032.1409PUMP FUEL FEED (ROTAK) KHH 118822603004222,100,0002511003872025-11-272025-12-1012,100,00012601010742026-01-30642025-12-17Late
2511003902025-11-25BAHAN BAKAR4050.0001OIL DELO GEAR EP-4/GL4 SAE 9025110041140,2502511004112025-11-272025-12-1020040,25022512000322025-12-0362025-12-17On time
2511004002025-11-25PERSEDIAAN UMUM6010.0543STIKER SIRIM 30X30 (UK 6.5 X 6.5 CM)251200191702511004092025-11-272025-12-052,0007022512002532025-12-09122025-12-12On time
2511004042025-11-27PERSEDIAAN UMUM6030.0377PLAT STRIP 40X2X6000 MM25110041246,846.852511004122025-11-272025-12-10346,846.852511008962025-11-2922025-12-17On time
2511004052025-11-27BAHAN PACKING3011.0043BOX KOBIN T.S KW 1 30X302604004001,1772511004022025-11-272025-12-2030,0009802512000172025-12-0362025-12-27On time
2511004052025-11-27BAHAN PACKING3011.0043BOX KOBIN T.S KW 1 30X302604004001,1772511004012025-11-272025-12-2030,0009302025-12-27Overdue
2511004052025-11-27BAHAN PACKING3011.0043BOX KOBIN T.S KW 1 30X302604004001,1772511004022025-11-272025-12-2030,0009802512000742025-12-0582025-12-27On time
2511004052025-11-27BAHAN PACKING3011.0047BOX KOBIN HIJAU T.S KW 2 30X302512003229512511004022025-11-272025-12-2015,0009802512000762025-12-0582025-12-27On time
2511004052025-11-27BAHAN PACKING3011.0047BOX KOBIN HIJAU T.S KW 2 30X302512003229512511004102025-11-272025-12-2015,0009062512001972025-12-0692025-12-27On time
2511100792025-11-24BAHAN BAKU BODY1098.0017SODIUM POLYACRYLATE 230#2601101130.932511101792025-11-272025-11-2748,0000.9332601100392026-01-06402025-12-04Late
2511100822025-11-24PERSEDIAAN UMUM6030.1668Silicon clear 300 gr25111018130,0002511101812025-11-272025-12-081230,00032601100782026-01-08422025-12-15Late
2511100852025-11-25PERSEDIAAN UMUM6030.1729AVIAN THINNER ENAMEL26061013957,554.172511101702025-11-272025-11-2741529,925.2322605101152026-05-081622025-12-04Late
2511100852025-11-25PERSEDIAAN UMUM6030.2309CAT AVITIEX SUPER WHITE @25KG/PAIL251110170496,574.82511101702025-11-272025-11-2710496,574.822605101152026-05-081622025-12-04Late
2511100862025-11-25PERSEDIAAN UMUM6050.0502VERNIER CALIPER DIGITAL MITUTOYO (536/211) 150 MM260300409665,0002511101742025-11-272025-12-0852,992,50022512101272025-12-0692025-12-15On time
2511100862025-11-25PERSEDIAAN UMUM6020.0555METERAN LASER DIGITAL260100680440,0002511101742025-11-272025-12-081926,25022512101272025-12-0692025-12-15On time
2511100892025-11-25PERSEDIAAN UMUM6050.069Scrapper untuk air26061008020,0002511101772025-11-272025-12-08428,50022512101282025-12-0692025-12-15On time
2511100892025-11-25PERSEDIAAN UMUM6050.0062KANEBO26061008012,0002511101772025-11-272025-12-08219,95022512101282025-12-0692025-12-15On time
2511100892025-11-25PERSEDIAAN UMUM6050.0497ALAT PEMBERSIH KACA26061008013,0002511101772025-11-272025-12-08416,62522512101282025-12-0692025-12-15On time
← PrevPage 4 of 135Next →Rows per page:1020501005001000