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
2603001662026-03-11SPAREPART5012.0244OIL SEAL TC 100.140.1201031,000No ETA
2603001712026-03-11PERSEDIAAN UMUM6050.0323CARBON BRUSH/ BROSTEL MAKITA CB-45925100000940,540.5400No ETA
2603002082026-03-12SPAREPART5011.0411BEARING RN 307 NTN260300230175,00000No ETA
2603002082026-03-12SPAREPART5011.0176BEARING 6403 2RS26040038683,35000No ETA
2603002162026-03-12PERSEDIAAN UMUM6030.1505BESI ST40 D 25MM X 6000MM25060155385,0002850,000No ETA
2603002182026-03-12FIXED ASSETSAST02701FORKLIFT HANGCHA CPD35-XEY2HA-SI (3.5T XE SERIES ELECTRIC LITHIUM BATTERY)000No ETA
2603002492026-03-12BAHAN PEMBANTU20MO.0307LOWER PUNCH EMBOSSED K-404010 40X402604001302,700,00000No ETA
2603002492026-03-12BAHAN PEMBANTU20MO.0305LOWER PUNCH EMBOSSED K-404011 40X402604001302,700,00000No ETA
2603002492026-03-12BAHAN PEMBANTU20MO.0517LOWER PUNCH EMBOSSED K-404019 40X402604001302,700,00000No ETA
2603002492026-03-12BAHAN PEMBANTU20MO.0333LOWER PUNCH EMBOSSED STONE 05 40X402604001302,700,00000No ETA
2603002492026-03-12BAHAN PEMBANTU20MO.0356LOWER PUNCH EMBOSSED K-404013 40X402604001302,700,00000No ETA
2603002492026-03-12BAHAN PEMBANTU20MO.0520LOWER PUNCH EMBOSSED K-404020 40X402604001302,700,00000No ETA
2603002492026-03-12BAHAN PEMBANTU20MO.0201LOWER PUNCH EMBOSSED K-404007 40X402604001302,700,00000No ETA
2603002492026-03-12BAHAN PEMBANTU20MO.0282LOWER PUNCH K-404009 40X402604001302,700,00000No ETA
2603002492026-03-12BAHAN PEMBANTU20MO.0396LOWER PUNCH EMBOSSED K-404017 40X402604001302,700,00000No ETA
2603002492026-03-12BAHAN PEMBANTU20MO.0560LOWER PUNCH EMBOSSED K-404021 40X402604001302,700,00000No ETA
2603002852026-03-18BAHAN PEMBANTU2054.0001KLEM GALVANIS26050046725000No ETA
2603002922026-03-23SPAREPART5021.0468V. BELT A - 1676 LI000No ETA
2603003022026-03-25PERSEDIAAN UMUM6060.0578AS 20MM X 6000MM ST 42250900123195,00000No ETA
2603003032026-03-23PERSEDIAAN UMUM6050.0022GAYUNG25101006512,35000No ETA
2603003112026-03-25PERSEDIAAN UMUM6050.167Ribbon Cartridge Epson LX-310000No ETA
2603003242026-03-26SPAREPART5023.155HELICAL GEAR TRANSMAX TR77 YDA100M4 RATIO 20 2.2 KW + MOTOR 2.2KW RPM 1460 380VOLT FLANGE B52601009796,200,00000No ETA
2603003422026-03-26SPAREPART5011.0025BEARING 3020826040001198,90000No ETA
2603003432026-03-26PERSEDIAAN UMUM6020.0056PENETRATING OIL ER 571126050045554,50000No ETA
2603003472026-03-26SPAREPART5011.0176BEARING 6403 2RS26040038683,35000No ETA
2603003652026-03-25BAHAN BAKU BODY1010.004PHIROPILIT CB (CALCIUM BUMI MAKMUR)26040052222000No ETA
2603003672026-03-25BAHAN PEMBANTU2045.0004PALLET LOKAL SETENGAH BARU 95*110*1126040033425,00000No ETA
2603003912026-03-27BAHAN BAKU GLAZE1099.0023BENTONITE LGI2603001416,75000No ETA
2603003942026-03-27BAHAN BAKU GLAZE1030.0059TITANIUM DIOXIDE ANASTASE DHA-10026060004642,692.5700No ETA
2603004082026-03-24PERSEDIAAN UMUM6030.2828ORANGE PI 5 PRO + COVER + KIPAS + ADAPTOR000No ETA
2603004122026-03-27PERSEDIAAN UMUM6050.1677TUTUP OLI DONGKRAK BOTOL 10MM AS 7MM000No ETA
2603004122026-03-27PERSEDIAAN UMUM6050.1704O-RING ID 7MM OD 12MM000No ETA
2603004202026-03-27PERSEDIAAN UMUM6050.1647MAL-MALAN ANGKA UKURAN 30X3026030039755,00000No ETA
2603004202026-03-27PERSEDIAAN UMUM6050.1647MAL-MALAN ANGKA UKURAN 30X3026030039755,00000No ETA
2603004202026-03-27PERSEDIAAN UMUM6050.1647MAL-MALAN ANGKA UKURAN 30X3026030039755,00000No ETA
2603004202026-03-27PERSEDIAAN UMUM6050.1647MAL-MALAN ANGKA UKURAN 30X3026030039755,00000No ETA
2603004202026-03-27PERSEDIAAN UMUM6050.1647MAL-MALAN ANGKA UKURAN 30X3026030039755,00000No ETA
2603004202026-03-27PERSEDIAAN UMUM6050.1647MAL-MALAN ANGKA UKURAN 30X3026030039755,00000No ETA
2603004202026-03-27PERSEDIAAN UMUM6050.1647MAL-MALAN ANGKA UKURAN 30X3026030039755,00000No ETA
2603004202026-03-27PERSEDIAAN UMUM6050.1647MAL-MALAN ANGKA UKURAN 30X3026030039755,00000No ETA
2603004202026-03-27PERSEDIAAN UMUM6050.1647MAL-MALAN ANGKA UKURAN 30X3026030039755,00000No ETA
2603004202026-03-27PERSEDIAAN UMUM6050.1647MAL-MALAN ANGKA UKURAN 30X3026030039755,00000No ETA
2603004222026-03-27SPAREPART5017.0416LAMPU LED 16 W (PHILIPS)26010078880,00000No ETA
2603004292026-03-28PERSEDIAAN UMUM6020.0833MOUSE LOGITECH B10026040043955,00000No ETA
2603004292026-03-28FIXED ASSETSAST02736MONITOR 19 INCH ( PAK ISKANDAR )000No ETA
2603004292026-03-28PERSEDIAAN UMUM6020.0832KEYBOARD K120260400439105,00000No ETA
2603004292026-03-28FIXED ASSETSAST02735MINI PC ASUS NUC 13 PRO i5 13TH GEN ( PAK ISKANDAR )000No ETA
2603004482026-03-30FIXED ASSETSAST02737MacBook M4 Pro 2024, 14inch, 14 Core/20GPU, RAM 48GB, SSD 2TB (tim IT)000No ETA
2603004642026-03-31STATIONERY6010.0041FORM CATATAN PENYEBAB LINE STOP FR-PROD-18 A4, FR-PROD-1826060025512,00000No ETA
2603004642026-03-31STATIONERY6010.0583FORM COUNTER UNTUK SAP26040015712,50000No ETA
2603004642026-03-31STATIONERY6010.0083FORM COUNTER FR-PROD-0626040015710,00000No ETA
2603004642026-03-31STATIONERY6010.0042FORM DAFTAR PEMERIKSAAN UKURAN BARANG JADI DAFTAR PEMERIKSAAN UKURAN BARANG JADI,A426060025512,00000No ETA
2603004642026-03-31STATIONERY6010.004FORM LAPORAN KONDISI PRODUKSI FR-PROD-11 A4, FR-PROD-1126060025512,00000No ETA
2603004642026-03-31STATIONERY6010.0053FORM PEMAKAIAN GLAZE DAN ENGOBE26040015710,00000No ETA
2603004642026-03-31STATIONERY6010.0052FORM DAFTAR PEMERIKSAAN MUTU HASIL PRESS26040015712,50000No ETA
2603004642026-03-31STATIONERY6010.0109FORM TEST BODY / SIZE (KILN-PRESS) FR-PRO-03 REV 0226040015712,50000No ETA
2603100032026-03-03SPAREPART5031.1003SQUARE-HEAD BOLTS 24X180MM000No ETA
2603100032026-03-03SPAREPART5023.1563TIE ROD SPRINGS 75X125X305000No ETA
2603100032026-03-03SPAREPART5023.1562TIE ROD BOLTS M36X1350, (EACH SET INCLUDES DOUBLE NUTS).000No ETA
2603100032026-03-03SPAREPART5031.1004SPRAY TOWER EXHAUST FAN BLADE, MODEL Y6-51-18D R135, RIGHT ROTATION000No ETA
2603100032026-03-03SPAREPART5031.1007HOOK HEAD BOLTS M16X150, (EACH SET INCLUDES NUT, FLAT WASHER, SPRING000No ETA
2603100142026-03-05SPAREPART5013.0023SLURRY HIGH-PRESSURE HOSE 3/4”, 10.5MPA, 1000MM LENGTH, BOTH ENDS WITH C-TYPE000No ETA
2603100142026-03-05FIXED ASSETSAST02691200-TON VERTICAL HYDRAULIC JACK000No ETA
2603100142026-03-05SPAREPART5031.102HEAVY-DUTY CONVEYOR TOP ROLLER, 89X260X315000No ETA
2603100142026-03-05FIXED ASSETSAST0269250-TON VERTICAL HYDRAULIC JACK000No ETA
2603100142026-03-05FIXED ASSETSAST0269320-TON VERTICAL HYDRAULIC JACK000No ETA
2603100142026-03-05SPAREPART5031.1017HANDLE-OPERATED WAFER BUTTERFLY VALVE 2-INCH000No ETA
2603100142026-03-05PERSEDIAAN UMUM6050.1629CRUSHER VIBRATING SCREEN MESH 5.5X5.5X2.5/1500X1800000No ETA
2603100142026-03-05SPAREPART5031.1013HANDLE-OPERATED WAFER BUTTERFLY VALVE 8 INCHES000No ETA
2603100142026-03-05SPAREPART5031.1019HEAVY-DUTY CONVEYOR TOP ROLLER, 89X330X390000No ETA
2603100142026-03-05SPAREPART5031.1021POLYMER NYLON TOP ROLLER: 89X310X370000No ETA
2603100142026-03-05PERSEDIAAN UMUM6050.163HIGH-PRESSURE EXTERNAL THREADED CONNECTOR, 3/4”, ONE END WITH D-TYPE000No ETA
2603100142026-03-05PERSEDIAAN UMUM6050.1627WOLF TOOTH BUCKLE SIZE 65 WITH STEEL STRIP, 1 METER000No ETA
2603100142026-03-05SPAREPART5031.1012HANDLE-OPERATED WAFER BUTTERFLY VALVE 6 INCHES000No ETA
2603100142026-03-05PERSEDIAAN UMUM6030.278418X120 SCREWS, FULLY THREADED000No ETA
2603100142026-03-05SPAREPART5014.0019WIRE MESH 120 SS304 WIDTH:1200 MM241001195.500No ETA
2603100142026-03-05PERSEDIAAN UMUM6050.16215MM HEX KEY WRENCH000No ETA
2603100142026-03-05PERSEDIAAN UMUM6050.16261010J U-TYPE STAPLES, BUY 1 BOX/30 PACKS000No ETA
2603100142026-03-05SPAREPART5031.09648.8 GRADE SCREW M24X170, (INCLUDES NUT, FLAT WASHER, SPRING WASHER)26051006145,00000No ETA
2603100142026-03-05PERSEDIAAN UMUM6030.278214X60 SCREWS, FULLY THREADED000No ETA
2603100142026-03-05PERSEDIAAN UMUM6030.278316X100 SCREWS, FULLY THREADED000No ETA
2603100142026-03-05PERSEDIAAN UMUM6030.2785ADJUSTABLE WRENCH 375MM000No ETA
2603100142026-03-05PERSEDIAAN UMUM6050.1624HIGH-POWER HANDHELD LED FLASHLIGHT, 15W000No ETA
2603100142026-03-05PERSEDIAAN UMUM6030.278112X40 SCREWS, FULLY THREADED000No ETA
2603100142026-03-05PERSEDIAAN UMUM6050.1625DONGCHENG FF-1013J PNEUMATIC STAPLE GUN000No ETA
2603100142026-03-05SPAREPART5031.1018PVC HONEYCOMB SNAKE PATTERN CONVEYOR BELT, 5 LAYERS X 9.0MM THICK X 1000MM WIDE000No ETA
2603100142026-03-05PERSEDIAAN UMUM6050.1628FEED CHAIN PLATE WL40C_4.2.1000No ETA
2603100222026-03-10PERSEDIAAN UMUM6010.055SERAGAM AGEN (L)260600268120,00000No ETA
2603100222026-03-10PERSEDIAAN UMUM6010.0551SERAGAM AGEN (XL)260600268120,00000No ETA
2603100232026-03-10SPAREPART5017.1011LAMPU LED SPOTLIGHT 400 WATT2512101791,014,279.2800No ETA
2603100232026-03-10PERSEDIAAN UMUM6030.0913SEAL TAPE ONDA 0.5 INCH 10 MTR2605102205,00500No ETA
2603100242026-03-10PERSEDIAAN UMUM6050.1393STIKER NAMA MOTIF GRANIT JUPITERC(UK 14X8CM)2606100127005,500600No ETA
2603100242026-03-10PERSEDIAAN UMUM6050.1394STIKER NAMA MOTIF GRANIT PARIS (UK 14X8CM)2606100127005,500600No ETA
2603100242026-03-10PERSEDIAAN UMUM6050.1395STIKER NAMA MOTIF GRANIT OCEANIA (UK 14X8CM)2606100127005,500600No ETA
2603100242026-03-10PERSEDIAAN UMUM6050.1392STIKER NAMA MOTIF GRANIT KOBIN (UK 14X8CM)2606100127005,500600No ETA
2603100242026-03-10PERSEDIAAN UMUM6050.1387STIKER NAMA MOTIF KERAMIK KAISAR (UK 9X5,5CM)2604000292401,500240No ETA
2603100242026-03-10PERSEDIAAN UMUM6050.1386STIKER NAMA MOTIF KERAMIK JUPITER (UK 9X5,5CM)2604000292408,500240No ETA
2603100242026-03-10PERSEDIAAN UMUM6050.1385STIKER NAMA MOTIF KERAMIK PARIS (UK 9X5,5CM)2604000292408,500240No ETA
2603100242026-03-10PERSEDIAAN UMUM6050.1383STIKER NAMA MOTIF KERAMIK MY PREMIER (UK 9X5,5CM)2604000292402,500240No ETA
2603100242026-03-10PERSEDIAAN UMUM6010.0715STIKER GRANITE: No Noda, No Gores, No Kusam2604000292,4005,0002,400No ETA
← PrevPage 6 of 135Next →Rows per page:1020501005001000