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
2512004162025-12-26SPAREPART5020.0002ADAPTER H-2309260100191124,40000No ETA
2512004162025-12-26SPAREPART5011.0423BEARING N 312 SKF000No ETA
2512004332025-12-26PERSEDIAAN UMUM6030.1561BETON READYMIX MUTU K300260600062780,00000No ETA
2512004412025-12-27BAHAN PACKING3011.0138BOX JUPITER HIJAU TS 30*30 KW 22605003821,17700No ETA
2512004412025-12-27BAHAN PACKING3011.0044BOX JUPITER T.S KW 1 30X302605003821,17700No ETA
2512004532025-12-30BAHAN BAKU GLAZE1030.0026POTASSIUM FELDSPAR POWDER KN-2002605003162,720.5600No ETA
2512004762025-12-29SPAREPART5020.0002ADAPTER H-2309260100191124,4008105,000No ETA
2512004932025-12-31FIXED ASSETSAST02580BALLMILL 8 TON000No ETA
2512004942025-12-31PERSEDIAAN UMUM6050.0034LPG 50 KG2606001661,300,00000No ETA
2512005042025-12-31STATIONERY6010.0247AMPLOP COKLAT KOP KOBIN KOP KOBIN 35X24 CM260100526191,50000No ETA
2512005102025-12-31BAHAN PEMBANTU20AB.0003MEDIUM ALUMINA BALL SIZE: 50MM2603003100.3100No ETA
2512005102025-12-31BAHAN PEMBANTU20AB.0004MEDIUM ALUMINA BALL SIZE: 60MM2603003100.3100No ETA
2512005142025-12-26PERSEDIAAN UMUM6030.0033KAWAT LAS RB 26 3.2 MM26050021729,729.7300No ETA
2512005142025-12-26PERSEDIAAN UMUM6030.0004SEMEN GRESIK 40KG26050024159,50000No ETA
2512005142025-12-26PERSEDIAAN UMUM6030.1731KAWAT LAS LB 52 Ø 2,6MM26031009344,30000No ETA
2512005142025-12-26PERSEDIAAN UMUM6030.0803KAWAT LAS LB 52 OD 3.2 MM26060012341,531.5300No ETA
2512005152025-12-15SPAREPART5011.0411BEARING RN 307 NTN260300230175,00000No ETA
2512100132025-12-04BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.600No ETA
2512100292025-12-10BAHAN BAKAR4040.0035TRANSMISSION OIL SAE 85W-90 IDEMITSU000No ETA
2512100292025-12-10BAHAN BAKAR4040.0036DIFFERENTIAL / GARDAN SAE 85W-90 IDEMITSU2512100689,373,40000No ETA
2512100292025-12-10BAHAN BAKAR4030.0022HYDRAULIC OIL ISO-VG46 IDEMITSU26031002834,00000No ETA
2512100292025-12-10BAHAN BAKAR4040.0034ENGINE OIL SAE 15 W - 40 API CH4 IDEMITSU26031002837,50000No ETA
2512100342025-12-10BAHAN BAKAR4040.0035TRANSMISSION OIL SAE 15W-40 IDEMITSU000No ETA
2512100342025-12-10FIXED ASSETSAST02543SEPEDA LISTRIK PK022512100613,180,00000No ETA
2512100372025-12-12SPAREPART5017.1024TOGGLE SWITCH + DUST CAP ( 6-PIN 2-POSITION SELF-RESETTING TYPE)000No ETA
2512100372025-12-12SPAREPART5017.1021AC CONTACTOR AUXILIARY CONTAC (FOR USE WITH 3RT6026-1AN20)000No ETA
2512100382025-12-13SPAREPART5017.1046CAMERA MXDA5054968000No ETA
2512100382025-12-13SPAREPART5017.1047DISPLACEMENT SENSOR CD33-50N000No ETA
2512100382025-12-13SPAREPART5017.1041SCANNING & ACQUISITION MODULE GWAD-C10/MX (MAIXUN)000No ETA
2512100382025-12-13SPAREPART5030.1785SLIDER TM2000No ETA
2512100382025-12-13SPAREPART5017.1042SERVO MOTOR DB80-02430A6-A 750W 220V000No ETA
2512100382025-12-13SPAREPART5030.1786FLAT BELT 840*4750*5000No ETA
2512100382025-12-13SPAREPART5030.1784OPEN-END SYNCHRONOUS BELT 20T10000No ETA
2512100382025-12-13SPAREPART5030.1787CENTERING GUIDE SHAFT 20*150000No ETA
2512100382025-12-13SPAREPART5030.1783LINEAR BEARING LM-20UU000No ETA
2512100382025-12-13SPAREPART5030.1781SYNCHRONOUS BELT 75AT20-4500+6APL000No ETA
2512100382025-12-13SPAREPART5019.034MOTOR NCJT03Y2-XGY80N4-0.75-17-M1-0000No ETA
2512100382025-12-13SPAREPART5017.1043SERVO DRIVER SV100S-75 AC 220V/50-60HE 100W-75W000No ETA
2512100382025-12-13SPAREPART5030.1782CYLINDER SC50X50000No ETA
2512100382025-12-13SPAREPART5018.00666-PITCH SINGLE STRAND CHAIN 6-PITCH000No ETA
2512100502025-12-16SPAREPART5031.0014BALLVALVE STAINLESS 1.5 INCH25050406450,00000No ETA
2512100552025-12-18PERSEDIAAN UMUM6050.1199PEMBUATAN PETUNJUK JALAN000No ETA
2512100552025-12-18FIXED ASSETSAST02626SEPEDA (OPERASIONAL)000No ETA
2512100602025-12-20PERSEDIAAN UMUM6050.1207DEBONDER AD-1 (GLUE REMOVER) 500 ML000No ETA
2512100672025-12-24SPAREPART5023.1506CYLINDER PNEUMATIC EASUN ESU 40X75-S000No ETA
2512100682025-12-24PERSEDIAAN UMUM6010.046MAP TULANG / MAP PLASTIK BUSINESS FILE DATAPLUS F42508102274,50000No ETA
2512100732025-12-27PERSEDIAAN UMUM6050.1227FITTING PNEUMATIC PSA 14000No ETA
2512100742025-12-29SPAREPART5014.0047MESH 602601008718.100No ETA
2601000252026-01-06SPAREPART5021.0319V. BELT C 9140299917 20X12.5X161602603000524,827,29400No ETA
2601000292026-01-06SPAREPART5031.0187AS 50X6000MM2605000932,008,108.1100No ETA
2601000532026-01-06BAHAN PEMBANTU2034.0001LEM LP 5840N26060024741,218.300No ETA
2601000672026-01-07PERSEDIAAN UMUM6030.2011SEMEN TIGA RODA 50 KG25120018058,00000No ETA
2601000672026-01-07PERSEDIAAN UMUM6030.0049BESI COR 6 MM26010025530,00000No ETA
2601000672026-01-07PERSEDIAAN UMUM6030.0001BATU CORAL260500241400,00000No ETA
2601000672026-01-07PERSEDIAAN UMUM6030.0422BESI COR 12 MM26010025599,00000No ETA
2601000682026-01-07FIXED ASSETSAST02586XRF EPSILON 4 MALFERN PANALYTICAL000No ETA
2601000702026-01-07BAHAN BAKU GLAZE1070.0008INK - CIK VE 1183 GREEN260600119224,22800No ETA
2601000702026-01-07BAHAN BAKU GLAZE1070.0001INK - CIK RO 4118 PINK260600030231,19600No ETA
2601000702026-01-07BAHAN BAKU GLAZE1070.0015INK - CIK GL 1219 GLOSSY260600139256,20200No ETA
2601000712026-01-08PERSEDIAAN UMUM6030.1574PIPA GALVANIS 10" X 6 MTR000No ETA
2601000712026-01-08PERSEDIAAN UMUM6030.2552SOCK DRAT DALAM 4 INCH KE 2 INCH000No ETA
2601000712026-01-08PERSEDIAAN UMUM6030.1185PIPA GALVANIS 1 INCH T=3 MM260100314278,108.1100No ETA
2601000812026-01-08STATIONERY6010.0213AMPLOP COKLAT KOP KOBIN KOP KOBIN, 18X28 CM260500027133,00000No ETA
2601000852026-01-08SPAREPART5011.0557BEARING 6004-LLU-NR000No ETA
2601000852026-01-08SPAREPART5031.0563TRANSFORMER TF301NA024241102172,448,00000No ETA
2601000912026-01-07PERSEDIAAN UMUM6030.0422BESI COR 12 MM26010025599,00000No ETA
2601000912026-01-07PERSEDIAAN UMUM6030.0004SEMEN GRESIK 40KG26050024159,50000No ETA
2601000912026-01-07PERSEDIAAN UMUM6030.0049BESI COR 6 MM26010025530,00000No ETA
2601000912026-01-07PERSEDIAAN UMUM6030.0001BATU CORAL260500241400,00000No ETA
2601000932026-01-08SPAREPART5030.0873TIMING BELT 1700H200+T62601007123,925,00000No ETA
2601000992026-01-07BAHAN PEMBANTU20MO.0663LOWER PUNCH EMBOSSED K-252530 (259.4X259.4) 26MM2603000101,800,00000No ETA
2601000992026-01-07BAHAN PEMBANTU20MO.0662LOWER PUNCH EMBOSSED K-303004 (312.5X312.5) 26MM2603000102,100,00000No ETA
2601001002026-01-07PERSEDIAAN UMUM6030.0049BESI COR 6 MM26010025530,00000No ETA
2601001002026-01-07PERSEDIAAN UMUM6030.2011SEMEN TIGA RODA 50 KG25120018058,00000No ETA
2601001002026-01-07PERSEDIAAN UMUM6030.0422BESI COR 12 MM26010025599,00000No ETA
2601001002026-01-07PERSEDIAAN UMUM6030.0001BATU CORAL260500241400,00000No ETA
2601001072026-01-09PERSEDIAAN UMUM6060.0481MUR M 302601008234,37500No ETA
2601001142026-01-09PERSEDIAAN UMUM6020.0203KIPAS ANGIN CKE 26 INCH2604000131,181,081.0800No ETA
2601001172026-01-10PERSEDIAAN UMUM6030.256CAT KUNING AVIAN PLATINUM BRIGHT SPIRIT 1605074,249.54No ETA
2601001172026-01-10PERSEDIAAN UMUM6030.2561CAT KUNING AVIAN PLATINUM MUSTARD 1505074,249.54No ETA
2601001172026-01-10PERSEDIAAN UMUM6030.2562CAT HITAM AVIAN PLATINUM JET BLACK 0205074,249.54No ETA
2601001172026-01-10PERSEDIAAN UMUM6030.2563CAT PUTIH AVIAN PLATINUM ABSOLUTE WHITE 0105074,249.54No ETA
2601001332026-01-10BAHAN BAKU BODY1010.0037PHIROPILIT (GUNUNG BALE - EX)000No ETA
2601001372026-01-03STATIONERY6010.0083FORM COUNTER FR-PROD-0626040015710,00000No ETA
2601001372026-01-03STATIONERY6010.0039FORM GLAZING LINE CONTROL REPORT FR-PROD-04 A4, FR-PROD-0426050039412,00000No ETA
2601001382026-01-02SPAREPART5023.0712SAFETY SWITCH 04072141000No ETA
2601001622026-01-13PERSEDIAAN UMUM6050.0017KAPUR BARUS TOILET26050042128,00000No ETA
2601001622026-01-13PERSEDIAAN UMUM6050.0038SAPU LANTAI26050042117,00000No ETA
2601001622026-01-13PERSEDIAAN UMUM6050.0015PEMBERSIH LANTAI26050042116,00000No ETA
2601001622026-01-13PERSEDIAAN UMUM6050.0151KANTONG KRESEK JUMBO26050042140,00000No ETA
2601001622026-01-13PERSEDIAAN UMUM6050.1225SABUN COLEK2601003455,50000No ETA
2601001622026-01-13PERSEDIAAN UMUM6050.0062KANEBO26061008012,00000No ETA
2601001622026-01-13PERSEDIAAN UMUM6050.0082REFILL PENGHARUM RUANGAN26030016956,30000No ETA
2601001622026-01-13PERSEDIAAN UMUM6050.1299PENDORONG AIR26040031640,00000No ETA
2601001622026-01-13PERSEDIAAN UMUM6050.1298KIT PEMBERSIH MOTOR26040031620,00000No ETA
2601001812026-01-19BAHAN BAKU GLAZE1030.0083TRANSPARENT FRIT K 02042606000446,052.7500No ETA
2601001822026-01-19BAHAN PACKING3011.02NFT00 40X40 KOBIN MP1 KW-A 403X51 (BK150/125/125)26060012040900No ETA
2601001822026-01-19BAHAN PACKING3011.0201NFT00 40X40 KOBIN MP2 KW-A 403X54 (BK150/125/125)26060012035700No ETA
2601002032026-01-15PERSEDIAAN UMUM6030.1186PIPA GALVANIS 2 INCH T=3.5 MM25040280755,00000No ETA
2601002122026-01-17FIXED ASSETSAST02595FORKLIFT TAILIFT FD35 NO. SERI TM 01908000No ETA
← PrevPage 2 of 135Next →Rows per page:1020501005001000