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
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512000802025-12-042025-12-15180,0007,342.532512005852025-12-17132025-12-22On time
2512000632025-12-01BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512000802025-12-042025-12-15180,0007,342.532512003152025-12-1062025-12-22On time
2512000642025-12-01BAHAN BAKU GLAZE1030.0027SILICA 200 ID2606000381,3162512000892025-12-042025-12-2996,0001,22532512008472025-12-24202026-01-05On time
2512000642025-12-01BAHAN BAKU GLAZE1030.0027SILICA 200 ID2606000381,3162512000892025-12-042025-12-2996,0001,22532512003142025-12-1062026-01-05On time
2512000642025-12-01BAHAN BAKU GLAZE1030.0027SILICA 200 ID2606000381,3162512000892025-12-042025-12-2996,0001,22532512007492025-12-22182026-01-05On time
2512000642025-12-01BAHAN BAKU GLAZE1030.0027SILICA 200 ID2606000381,3162512000892025-12-042025-12-2996,0001,22532512005792025-12-17132026-01-05On time
2512000652025-12-01BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42512000862025-12-042025-12-24180,00010,014.632512007562025-12-22182025-12-31On time
2512000652025-12-01BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42512000862025-12-042025-12-24180,00010,014.632512007602025-12-22182025-12-31On time
2512000652025-12-01BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42512000862025-12-042025-12-24180,00010,014.632512003162025-12-1062025-12-31On time
2512000652025-12-01BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42512000862025-12-042025-12-24180,00010,014.632512003992025-12-1392025-12-31On time
2512000652025-12-01BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42512000862025-12-042025-12-24180,00010,014.632512005812025-12-17132025-12-31On time
2512000652025-12-01BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42512000862025-12-042025-12-24180,00010,014.632512005802025-12-17132025-12-31On time
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-20175,0002,50032025-12-27Overdue
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-20175,0002,50032601002422026-01-08352025-12-27Late
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-20175,0002,50032601002462026-01-08352025-12-27Late
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-20175,0002,50032601016062026-02-14722025-12-27Late
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-20175,0002,50032601002062026-01-08352025-12-27Late
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-20175,0002,50032601001462026-01-06332025-12-27Late
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-20175,0002,50032601016072026-02-14722025-12-27Late
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-20175,0002,50032601002432026-01-08352025-12-27Late
2512000662025-12-01BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402512000852025-12-042025-12-20175,0002,50032601016092026-02-14722025-12-27Late
2512000672025-12-01BAHAN BAKU GLAZE1030.0057TRANSPARENT FRIT 16152606000508,285.92512000882025-12-042025-12-2290,0007,928.2332512003472025-12-1172025-12-29On time
2512000672025-12-01BAHAN BAKU GLAZE1030.0057TRANSPARENT FRIT 16152606000508,285.92512000882025-12-042025-12-2290,0007,928.2332512010172025-12-31272025-12-29Late
2512000672025-12-01BAHAN BAKU GLAZE1030.0057TRANSPARENT FRIT 16152606000508,285.92512000882025-12-042025-12-2290,0007,928.2332512008882025-12-26222025-12-29On time
2512000672025-12-01BAHAN BAKU GLAZE1030.0057TRANSPARENT FRIT 16152606000508,285.92512000882025-12-042025-12-2290,0007,928.2332512005902025-12-17132025-12-29On time
2512000682025-12-01BAHAN BAKU GLAZE1030.0059TITANIUM DIOXIDE ANASTASE DHA-10026060004642,692.572512000842025-12-042025-12-205,00034,261.9232601005252026-01-15422025-12-27Late
2512000692025-12-01BAHAN BAKU GLAZE1030.0056TRANSPARENT FRIT YGC 000292601011438,2082512000752025-12-042025-12-1020,0008,20832512003512025-12-1172025-12-17On time
2512000712025-12-01BAHAN BAKU GLAZE1020.0023HIGH COE TITANIUM FRIT K-086326060004210,028.752512000812025-12-042025-12-15120,0009,322.532512005932025-12-17132025-12-22On time
2512000712025-12-01BAHAN BAKU GLAZE1020.0023HIGH COE TITANIUM FRIT K-086326060004210,028.752512000812025-12-042025-12-15120,0009,322.532512007532025-12-22182025-12-22On time
2512000712025-12-01BAHAN BAKU GLAZE1020.0023HIGH COE TITANIUM FRIT K-086326060004210,028.752512000812025-12-042025-12-15120,0009,322.532512002732025-12-0952025-12-22On time
2512000722025-12-01BAHAN BAKU GLAZE1030.0062TRANSPARENT FRIT K 02482606000438,786.252512000822025-12-042025-12-1120,0008,167.532512003632025-12-1282025-12-18On time
2511003442025-11-21SPAREPART5022.0109GEAR RS 80/18 ID 40 SPY 10X5 BORG M8251200093387,0002512000932025-12-052025-12-274387,000142512007792025-12-23182026-01-03On time
2511003442025-11-21SPAREPART5022.0087GEAR RS 60/30 ID 40 SPY 10X5251200093260,0002512000932025-12-052025-12-274260,000142512007792025-12-23182026-01-03On time
2511004622025-11-29STATIONERY6010.0213AMPLOP COKLAT KOP KOBIN KOP KOBIN, 18X28 CM260500027133,0002512000912025-12-052025-12-22580,00062512005532025-12-17122025-12-29On time
2511004632025-11-29PERSEDIAAN UMUM6060.0281SNAPRING S 202512000946502512000942025-12-052025-12-222065062512002632025-12-0942025-12-29On time
2511004632025-11-29PERSEDIAAN UMUM6060.0284SNAPRING H 222512000946502512000942025-12-052025-12-222065062512002632025-12-0942025-12-29On time
2511004632025-11-29PERSEDIAAN UMUM6060.0276SNAPRING S 252512000949002512000942025-12-052025-12-222090062512002632025-12-0942025-12-29On time
2511004652025-11-29SPAREPART5012.017SEAL TC 32.52.122512000988,0002512000982025-12-052025-12-23208,00062512002592025-12-0942025-12-30On time
2511004652025-11-29SPAREPART5012.0107SEAL TC 40.62.1125120009810,0002512000982025-12-052025-12-232010,00062512002592025-12-0942025-12-30On time
2511004652025-11-29SPAREPART5012.0207SEAL TC 35.62.102512000989,0002512000982025-12-052025-12-23209,00062512002592025-12-0942025-12-30On time
2511004652025-11-29SPAREPART5012.0187SEAL TC 30.55.72512000988,0002512000982025-12-052025-12-23208,00062512002592025-12-0942025-12-30On time
2511004672025-11-29PERSEDIAAN UMUM6050.0355RAK SUSUN25120013795,0002512001662025-12-052025-12-20185,00062512004522025-12-1382025-12-27On time
2511004672025-11-29PERSEDIAAN UMUM6050.0355RAK SUSUN25120013795,0002512001662025-12-052025-12-20568,00062512004522025-12-1382025-12-27On time
2511004672025-11-29STATIONERY6010.018TEMPAT PENSIL26060002727,7002512001662025-12-052025-12-20527,70062512006922025-12-22172025-12-27On time
2511004712025-11-29PERSEDIAAN UMUM6060.0338SPEI 1026040053012,0002512000972025-12-052025-12-22911,50062512006212025-12-18132025-12-29On time
2511004712025-11-29PERSEDIAAN UMUM6060.034SPEI 82604005309,0002512000972025-12-052025-12-2279,00062512006212025-12-18132025-12-29On time
2511004712025-11-29PERSEDIAAN UMUM6060.0339SPEI 62604005307,0002512000972025-12-052025-12-2276,00062512006212025-12-18132025-12-29On time
2511004712025-11-29PERSEDIAAN UMUM6060.0342SPEI 42512000973,0002512000972025-12-052025-12-2283,00062512006212025-12-18132025-12-29On time
2511100972025-11-28SPAREPART5013.0007SELANG ANGIN PU D.12MM26061002910,5002512100252025-12-052025-12-151008,75072512102852025-12-1382025-12-22On time
2511101002025-11-29SPAREPART5017.0208PILOT LAMP SCHNEIDER MERAH 220 VAC26010044048,0002512100242025-12-052025-12-15228,75062512102892025-12-1382025-12-22On time
2511101002025-11-29SPAREPART5017.1002PILOT LAMP SCHNEIDER ORANGE25121002428,7502512100242025-12-052025-12-15228,75062512102892025-12-1382025-12-22On time
2511101002025-11-29SPAREPART5017.0209PILOT LAMP SCHNEIDER HIJAU 220 VAC26010036950,0002512100242025-12-052025-12-15228,75062512102892025-12-1382025-12-22On time
2511101002025-11-29SPAREPART5017.0155RELL MCB ALUMUNIUM25121002422,5002512100242025-12-052025-12-15122,50062512102892025-12-1382025-12-22On time
2511101002025-11-29SPAREPART5017.1001MCB 1 PHASE 20A25121002489,0002512100242025-12-052025-12-15689,00062512102892025-12-1382025-12-22On time
2511101002025-11-29SPAREPART5017.1MCB 220V 6A25121002489,0002512100242025-12-052025-12-15289,00062512102892025-12-1382025-12-22On time
2511101002025-11-29SPAREPART5017.0999MCB 3 PHASE 20A260110081362,1242512100252025-12-052025-12-152290,00062512102852025-12-1382025-12-22On time
2511101002025-11-29SPAREPART5017.0998MCB 3 PHASA 32A260110081415,2962512100252025-12-052025-12-152345,00062512102852025-12-1382025-12-22On time
2511101002025-11-29SPAREPART5017.0221MCB SNEIDER 3P 10A260100415230,0002512100252025-12-052025-12-158290,00062512102852025-12-1382025-12-22On time
2511101002025-11-29SPAREPART5017.0481MCCB125 3P 125A260110432706,1502512100252025-12-052025-12-152790,00062512102852025-12-1382025-12-22On time
2512000082025-12-01PERSEDIAAN UMUM6030.0367BESI SIKU 50 X 50 X 5MM X 6M SNI260500103270,270.272512001072025-12-052025-12-202243,243.2442512004412025-12-1382025-12-27On time
2512000082025-12-01PERSEDIAAN UMUM6030.2448PLAT STRIP 10X10X6000 MM251200104295,0002512001042025-12-052025-12-202295,00042512006262025-12-18132025-12-27On time
2512000202025-12-01PERSEDIAAN UMUM6050.0455TANG BUAYA26050038976,4002512001092025-12-052025-12-24198,963.9642512004352025-12-1382025-12-31On time
2512000202025-12-01PERSEDIAAN UMUM6050.0372TANG CATUT25120010935,135.142512001092025-12-052025-12-24135,135.1442512004352025-12-1382025-12-31On time
2512000452025-12-03SPAREPART5021.0123V. BELT B - 250260101026191,2002512001132025-12-052025-12-185191,20022512003062025-12-1052025-12-25On time
2512000452025-12-03SPAREPART5021.0123V. BELT B - 250260101026191,2002512001022025-12-052025-12-185191,20022512006182025-12-18132025-12-25On time
2512000452025-12-03SPAREPART5021.0129V. BELT B - 285260100234217,9002512001132025-12-052025-12-1810217,90022512003062025-12-1052025-12-25On time
2512000452025-12-03SPAREPART5021.0101V. BELT B - 186251200113135,1002512001132025-12-052025-12-1810135,10022512003062025-12-1052025-12-25On time
2512000452025-12-03SPAREPART5021.0101V. BELT B - 186251200113135,1002512001132025-12-052025-12-1810135,10022512006162025-12-18132025-12-25On time
2512000452025-12-03SPAREPART5021.0082V. BELT B - 13425120011397,3002512001132025-12-052025-12-181097,30022512003062025-12-1052025-12-25On time
2512000452025-12-03SPAREPART5021.0091V. BELT B - 158260500140126,0502512001022025-12-052025-12-1810114,75022512006182025-12-18132025-12-25On time
2512000462025-12-03SPAREPART5017.0908INSTRUMENT CABLE WIRED 6C/22AWG25120009525,0002512000952025-12-052025-12-203025,00022512003772025-12-1272025-12-27On time
2512000472025-12-03PERSEDIAAN UMUM6020.047BOX PANEL 60X50 CM260100586620,0002512000962025-12-052025-12-221580,00022512003702025-12-1272025-12-29On time
2512000482025-12-03SPAREPART5011.027BEARING UCFL 20526050014890,0002512000992025-12-052025-12-23290,00022512003082025-12-1052025-12-30On time
2512000482025-12-03SPAREPART5011.0279BEARING UCP 206260400546120,3002512000992025-12-052025-12-234127,00022512003082025-12-1052025-12-30On time
2512000482025-12-03SPAREPART5011.0277BEARING UCP 20426050047184,0002512000992025-12-052025-12-23284,00022512003082025-12-1052025-12-30On time
2512000782025-12-03PERSEDIAAN UMUM6050.0296LEM LOCTITE 242251200106240,0002512001062025-12-052025-12-191240,00022512002692025-12-0942025-12-26On time
2512000822025-12-03PERSEDIAAN UMUM6050.0948TUSEN KLEP 3 INCH251200101427,364.872512001012025-12-052025-12-162427,364.8722512002252025-12-0942025-12-23On time
2512000902025-12-04PERSEDIAAN UMUM6060.0273BORG M 8X82605002146102512001032025-12-052025-12-1910061012512002652025-12-0942025-12-26On time
2512000912025-12-04PERSEDIAAN UMUM6010.0351AIR MINERAL GALON26060024818,018.022512001002025-12-052025-12-233517,567.5712512002662025-12-0942025-12-30On time
2512000912025-12-04PERSEDIAAN UMUM6050.0313AIR MINERAL BOTOL KECIL 220 ML26060024819,819.822512001002025-12-052025-12-231019,369.3712512002662025-12-0942025-12-30On time
2512000932025-12-04SPAREPART5019.0125GEAR REDUCER MNRV 050 RATIO 1:15 0.75 KW FLANGE B14 + MOTOR 0.75 KW 380 V 1500 RPM2512001084,250,0002512001082025-12-052025-12-2324,250,00012512004612025-12-1382025-12-30On time
2512100082025-12-02BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412512100282025-12-052025-12-05154,0000.40532512101032025-12-0612025-12-12On time
2512100082025-12-02BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412512100282025-12-052025-12-05154,0000.40532512101022025-12-0612025-12-12On time
2512100082025-12-02BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412512100282025-12-052025-12-05154,0000.40532512101042025-12-0612025-12-12On time
2512100152025-12-04BAHAN PACKING3011.0243CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP2 KWB 605X38 (BK150/125/125)260110083609.62512100212025-12-052025-12-058,40047012512102632025-12-1272025-12-12On time
2512100152025-12-04BAHAN PACKING3011.0213CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWB 605X40 (WK150/125/125)260110083645.122512100212025-12-052025-12-0547,25053012512102652025-12-1272025-12-12On time
2512100152025-12-04BAHAN PACKING3011.0213CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP1 KWB 605X40 (WK150/125/125)260110083645.122512100212025-12-052025-12-0547,25053012512102632025-12-1272025-12-12On time
2512100152025-12-04BAHAN PACKING3011.0241CARTON BOX SIDEWRAPS PARIS 60X60 GP MP2 KWB 605X38 (BK150/125/125)260110083609.62512100212025-12-052025-12-058,40047012512102632025-12-1272025-12-12On time
2512100152025-12-04BAHAN PACKING3011.0242CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP1 KWB 605X40 (BK150/125/125)260110083645.122512100212025-12-052025-12-058,40053012512102632025-12-1272025-12-12On time
2512100152025-12-04BAHAN PACKING3011.0239CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWB 605X38 (BK150/125/125)2512101524942512100212025-12-052025-12-058,40047012512102632025-12-1272025-12-12On time
2512100152025-12-04BAHAN PACKING3011.0214CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWB 605X38 (WK150/125/125)260110083609.62512100212025-12-052025-12-0547,25047012512102632025-12-1272025-12-12On time
2512100152025-12-04BAHAN PACKING3011.0214CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWB 605X38 (WK150/125/125)260110083609.62512100212025-12-052025-12-0547,25047012512102652025-12-1272025-12-12On time
2512100152025-12-04BAHAN PACKING3011.0238CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWB 605X40 (BK150/125/125)2512101525572512100212025-12-052025-12-058,40053012512102632025-12-1272025-12-12On time
2512100152025-12-04BAHAN PACKING3011.024CARTON BOX SIDEWRAPS PARIS 60X60 GP MP1 KWB 605X40 (BK150/125/125)260110083645.122512100212025-12-052025-12-058,40053012512102632025-12-1272025-12-12On time
2511004252025-11-28SPAREPART5032.1417OIL FILTER DONALDSON J86 10495251200114198,4002512001142025-12-062025-12-191198,40082512008592025-12-26202025-12-26On time
2511004252025-11-28SPAREPART5032.1418FUEL FILTER DONALDSON J86 20068251200114141,2002512001142025-12-062025-12-192141,20082512008592025-12-26202025-12-26On time
2511004252025-11-28SPAREPART5032.1402FUEL FILTER DONALDSON J86 23486251200114302,4002512001142025-12-062025-12-191302,40082512008592025-12-26202025-12-26On time
2511004422025-11-28SPAREPART5031.0955O-RING 5.7MM X 238.6MM X 250MM25120011815,0002512001182025-12-062025-12-272015,00082512008662025-12-26202026-01-03On time
2511004422025-11-28SPAREPART5012.0155SEAL TC 150.180.1425120011885,0002512001182025-12-062025-12-271585,00082512008662025-12-26202026-01-03On time
2512000212025-12-01PERSEDIAAN UMUM6050.1168POLYURETHANE SHEET TEBAL=16MM251200110990,0002512001102025-12-062025-12-231990,00052512002242025-12-0932025-12-30On time
← PrevPage 12 of 135Next →Rows per page:1020501005001000