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
2604100202026-04-08PERSEDIAAN UMUM6010.0598LAKBAN BENING 36MM2605102585,00000No ETA
2604100232026-04-08BAHAN BAKU BODY1010.0043FELDSPAR FLNH CRUSHER KA MAX 10%26051021256800No ETA
2604100302026-04-13PERSEDIAAN UMUM6050.1729MATA SKUN HYDRAULIC UK 35000No ETA
2604100302026-04-13PERSEDIAAN UMUM6050.1724ROTARY LAMPU LED 7 (TANPA BUZZER) 220 VOLD VAC000No ETA
2604100302026-04-13PERSEDIAAN UMUM6050.1726CONNECTOR SAMBUNGAN000No ETA
2604100302026-04-13PERSEDIAAN UMUM6050.173MATA SKUN HYDRAULIC UK 75000No ETA
2604100302026-04-13PERSEDIAAN UMUM6050.1732MATA SKUN HYDRAULIC UK 16000No ETA
2604100302026-04-13PERSEDIAAN UMUM6050.1731MATA SKUN HYDRAULIC UK 95000No ETA
2604100302026-04-13PERSEDIAAN UMUM6050.1725HEAT SHRINK000No ETA
2604100302026-04-13PERSEDIAAN UMUM6050.1728MATA SKUN HYDRAULIC UK 25000No ETA
2604100322026-04-14SPAREPART5011.0303BEARING UCT 213251100039567,50000No ETA
2604100322026-04-14SPAREPART5011.0288BEARING UCP 31325050340935,00000No ETA
2604100322026-04-14SPAREPART5011.0497BEARING WITH VERTICAL SEAT (OUTER SPHERICAL BALL) UCP216 203601000072508102172200No ETA
2604100322026-04-14PERSEDIAAN UMUM6030.2913SELANG PVC TEBAL ID:25 OD:32000No ETA
2604100352026-04-14PERSEDIAAN UMUM6050.1742SELANG PVC 1"000No ETA
2604100422026-04-16PERSEDIAAN UMUM6030.2915SPANDEK RINGAN000No ETA
2604100442026-04-16BAHAN BAKAR4030.0024OIL ROTO-XTEND DUTY FLUID (RXD)- ATLAS COPCO000No ETA
2604100452026-04-17PERSEDIAAN UMUM6030.2926AS DRAT M 10X100 CM000No ETA
2604100452026-04-17PERSEDIAAN UMUM6060.0218MUR SS M 102510005631,40000No ETA
2604100452026-04-17PERSEDIAAN UMUM6030.293WATERPASS 16 INC MAGNET000No ETA
2604100452026-04-17PERSEDIAAN UMUM6060.0703BAUT DYNA BOLT M14X100000No ETA
2604100452026-04-17PERSEDIAAN UMUM6060.0236RING PLAT M-1026050046414500No ETA
2604100452026-04-17PERSEDIAAN UMUM6030.2606RING PLAT STAINLESS M 122601007011,15000No ETA
2604100462026-04-17PERSEDIAAN UMUM6030.2016BALL VALVE 2 INCH KITZ2512100761,010,00000No ETA
2604100462026-04-17PERSEDIAAN UMUM6030.181ELBOW LAS GALVANIS 90 DERAJAT 2 INCH25081002046,837.5500No ETA
2604100462026-04-17PERSEDIAAN UMUM6060.0103BAUT DYNA BOLT 12X60 MM2603002982,191.8900No ETA
2604100462026-04-17PERSEDIAAN UMUM6030.2942PIPA GALVANIS 3/4 INCH DRAT LUAR000No ETA
2604100462026-04-17PERSEDIAAN UMUM6030.2941PIPA 1 INCH X 6000 MM ( GALVANISH ) DRAT LUAR000No ETA
2604100462026-04-17PERSEDIAAN UMUM6030.2771PIPA GALVANIS 2 INCH260300259629,729.7300No ETA
2604100462026-04-17PERSEDIAAN UMUM6050.1749HOSE HYDRAULIC 3/4 INC R2 PANJANG 100 CM 3/4 NPT X 3/4 NPT000No ETA
2604100462026-04-17PERSEDIAAN UMUM6030.2937TEE REDUCER LAS SCH 40 2 INC x 3/4 inc000No ETA
2604100462026-04-17PERSEDIAAN UMUM6030.1712ELBOW 90 DRAJAT GALVANIS WELDED 3/4 INCH25121008810,50000No ETA
2604100462026-04-17PERSEDIAAN UMUM6030.1684KLEM U BOLT 3/4 INCH2507002773,00000No ETA
2604100462026-04-17PERSEDIAAN UMUM6030.294BALL VALVE 3/4 INCH KITZ000No ETA
2604100462026-04-17PERSEDIAAN UMUM6030.2939TEE GALVANIS 2 INCH WELDED000No ETA
2604100482026-04-17SPAREPART5017.1099KAPASITOR BULAT 30 UF, 450 VOLT SAN000No ETA
2604100502026-04-20STATIONERY6010.015ISI CUTTER BESAR L-1502606100606,50000No ETA
2604100502026-04-20STATIONERY6010.0689STANDING WHITEBOARD 90X1200251210026885,00000No ETA
2604100452026-04-17PERSEDIAAN UMUM6030.2931BESI UNP 160x65x7,5 (@6METER)2606101801,480,0002606101802026-06-172026-06-17501,480,000612026-06-24Outstanding
2601100242026-01-12SPAREPART5029.0374FAN:9-26-7.1D,55KW PRIMARY COMBUSTION FAN – SHOCK-ABSORBING HEXAGONAL RUBBER COUPLING260610174385,0002606101742026-06-162026-06-1620385,0001552026-06-23Outstanding
2512100782025-12-31PERSEDIAAN UMUM6050.1232HD EXIT & ENTER LIFTING SYNCHRONOUS BELT MODEL 1440H150260610170132606101702026-06-152026-06-154131662026-06-22Outstanding
2604000082026-04-01PERSEDIAAN UMUM6030.2862PAM26060023458,0002606002342026-06-132026-06-1930058,000732026-06-26Outstanding
2604000832026-04-08SPAREPART5028.0175PULLEY C1 V. BELT D-YX-PD-09-01 10 INCH DIA. 45MM26060023752606002372026-06-122026-09-30805652026-10-07Outstanding
2604000832026-04-08SPAREPART5028.0177PULLEY C1 BEARING V. BELT D-YX-DB-ZP-01-01 DIA. 6,5 INCH26060023752606002372026-06-122026-09-30125652026-10-07Outstanding
2604000832026-04-08SPAREPART5028.018PULLEY CURVA D-ZW-ZP-01-03 DIA. 2,75 INCH26060023732606002372026-06-122026-09-301443652026-10-07Outstanding
2604000832026-04-08SPAREPART5028.0179PULLEY CURVA D-ZW-ZP-01-02 DIA. 1,5 INCH2606002372.52606002372026-06-122026-09-30402.5652026-10-07Outstanding
2604000832026-04-08SPAREPART5028.0178PULLEY C1 BERING ROUND BELT D-ZW-ZP-02-12 9,5 INCH DIA 45MM260600237122606002372026-06-122026-09-301212652026-10-07Outstanding
2604000832026-04-08SPAREPART5028.0183PULLEY TIMING BELT D-YX-KL-ZP-09-09 DIA. 45MM260600237272606002372026-06-122026-09-30827652026-10-07Outstanding
2604000832026-04-08SPAREPART5028.0182PULLEY TIMING BELT BERGIGI D-YX-KL-ZP-09-01 DIA. 45MM260600237272606002372026-06-122026-09-30827652026-10-07Outstanding
2604000832026-04-08SPAREPART5028.0176PULLEY C1 ROUND BELT D-ZW-ZP-02-01 9,5 INCH DIA. 45MM260600237122606002372026-06-122026-09-301212652026-10-07Outstanding
2604000832026-04-08SPAREPART5028.0181PULLEY CURVA D-ZW-ZP-01-04 DIA. 2,25 INCH26060023732606002372026-06-122026-09-30403652026-10-07Outstanding
2604000842026-04-08SPAREPART5021.0386ROUND BELT HIJAU D-ZW-ZP-0926060023722606002372026-06-122026-09-301002652026-10-07Outstanding
2604000842026-04-08SPAREPART5021.039ROUND BELT MERAH2606002371.52606002372026-06-122026-09-302001.5652026-10-07Outstanding
2512100782025-12-31PERSEDIAAN UMUM6050.1233HD EXIT TILE TURNING SYNCHRONOUS BELT MODEL 820H150260610136535,0002606101362026-06-112026-06-112535,0001622026-06-18Outstanding
2603100202026-03-09PERSEDIAAN UMUM6020.0765WIFI USB ADAPTOR26061015276,0002606101522026-06-112026-06-22376,000942026-06-29Outstanding
2604100452026-04-17PERSEDIAAN UMUM6030.0415MATA BOR BESI 13 MM260610157172,5002606101572026-06-112026-06-225172,500552026-06-29Outstanding
2604100452026-04-17PERSEDIAAN UMUM6030.013MATA BOR BESI M1026061015799,0002606101572026-06-112026-06-22599,000552026-06-29Outstanding
2604100452026-04-17PERSEDIAAN UMUM6030.1363MATA BOR BESI M 14260610157316,2002606101572026-06-112026-06-225316,200552026-06-29Outstanding
2601100852026-02-05PERSEDIAAN UMUM6050.1335STRONG ADHESIVE (DEXTONE)26061011713,6922606101172026-06-102026-06-192013,6921252026-06-26Outstanding
2603100292026-03-11PERSEDIAAN UMUM6060.0501PIPA CARBON STEEL BLACKSTEEL Ø 2,5 INCH ASTM SCH.40 SEAMLESS2606101231,030,0002606101232026-06-102026-06-101601,030,000912606104662026-06-1772026-06-17On time
2603100292026-03-11PERSEDIAAN UMUM6060.0501PIPA CARBON STEEL BLACKSTEEL Ø 2,5 INCH ASTM SCH.40 SEAMLESS2606101231,030,0002606101232026-06-102026-06-101601,030,000912606104672026-06-1772026-06-17On time
2603100292026-03-11PERSEDIAAN UMUM6030.28TEE BESI LAS CARBON BLACKSTEEL ASTM SCH 40 SEAMLESS DIAMETER 2,5 INC260610122113,0002606101222026-06-102026-06-1025113,000912606103432026-06-1222026-06-17On time
2604100452026-04-17PERSEDIAAN UMUM6030.2353U-BOLT 4 INCH2606101247,207.212606101242026-06-102026-06-10507,207.21542026-06-17Overdue
2604100452026-04-17PERSEDIAAN UMUM6030.2267U-BOLT 5 INCHI2606101247,657.662606101242026-06-102026-06-10107,657.66542026-06-17Overdue
2604100452026-04-17PERSEDIAAN UMUM6030.2933U BOLT 8 INC GALVANIS26061012412,612.612606101242026-06-102026-06-101012,612.61542026-06-17Overdue
2604100452026-04-17PERSEDIAAN UMUM6030.1831U-BOLT 1 INCH2606101241,801.82606101242026-06-102026-06-101001,801.8542026-06-17Overdue
2604100452026-04-17PERSEDIAAN UMUM6030.1829U-BOLT 2 INCH2606101243,153.152606101242026-06-102026-06-101003,153.15542026-06-17Overdue
2604100462026-04-17PERSEDIAAN UMUM6030.1829U-BOLT 2 INCH2606101243,153.152606101242026-06-102026-06-10103,153.15542026-06-17Overdue
2603004522026-03-31PERSEDIAAN UMUM6050.0034LPG 50 KG2606001661,300,0002606001662026-06-092026-06-1511,300,000702606003722026-06-1012026-06-22On time
2603100182026-03-07PERSEDIAAN UMUM6050.1633ATS HYDRAULIC BOTTLE JACK (DONGKRAK BOTOL) 3TON260610113225,2262606101132026-06-092026-06-182225,226942606103382026-06-1232026-06-25On time
2604100322026-04-14SPAREPART5023.157POMPA FEEDING FILTER PRESS TYPE 50SyA DAN MOTOR 22KW TYPE YVF2_180L_42606101022,8002606101022026-06-092026-06-0922,800562026-06-16Overdue
2604100452026-04-17PERSEDIAAN UMUM6030.2932U BOLT 6 INC GALVANIS26061005710,810.812606100572026-06-062026-06-061010,810.81502026-06-13Overdue
2604100452026-04-17PERSEDIAAN UMUM6030.2601U BOLT GALVANISH 3 INCH2606100966,036.032606100572026-06-062026-06-06506,036.04502606102522026-06-0932026-06-13On time
2601101192026-02-20SPAREPART5029.0492DUMPER VALVE+FLANGE+BOLT,RING,NUT M14X70MM DUCTING DIAMETER 110026061009312,683,0612606100932026-06-052026-06-17212,683,0611052026-06-24Outstanding
2604000722026-04-07FIXED ASSETSAST02741AC PANASONIC 2 PK (INDOOR + OUTDOOR) R.PANEL PN12606000846,830,0002606000842026-06-052026-06-0536,830,000592606004892026-06-1272026-06-12On time
2603000752026-03-07SPAREPART5032.1476WIRE ASSY, ACCELERATOR FLEXIBLE 26620-N3170-71260600109750,0002606001092026-06-042026-06-222750,000892026-06-29Outstanding
2603002172026-03-12SPAREPART5029.0371HELICAL GEAR Z25 (MAT=SCM-415 HARDEN)260600091363,0002606000912026-06-042026-07-044363,000842026-07-11Outstanding
2603002172026-03-12SPAREPART5022.041PINION GEAR Z9 (MAT=SCM-415 HARDEN)260600091354,0002606000912026-06-042026-07-044354,000842026-07-11Outstanding
2603002172026-03-12SPAREPART5022.0364HELICAL GEAR Z63 (MAT=SCM-415 HARDEN)260600091827,0002606000912026-06-042026-07-044827,000842026-07-11Outstanding
2603002172026-03-12SPAREPART5022.0363HELICAL GEAR Z73(MAT=SCM-415 HARDEN)260600091800,0002606000912026-06-042026-07-044800,000842026-07-11Outstanding
2603100032026-03-03SPAREPART5031.0999IMPACT CRUSHER WEAR PLATE, MODEL VSI9526_3_1022606100373,000,0002606100372026-06-042026-06-04253,000,000932026-06-11Overdue
2603100142026-03-05SPAREPART5014.0044304 STAINLESS STEEL SIEVE MESH 100 MESH X 1,3M WIDTH @30 MTR/ROLL2606100333,325,0002606100332026-06-042026-06-1353,325,000912026-06-20Outstanding
2603100142026-03-05SPAREPART5014.0033304 STAINLESS STEEL MESH 60 MESH X 1,3M WIDTH @30 MTR2606100333,776,2502606100332026-06-042026-06-1353,776,250912026-06-20Outstanding
2603100142026-03-05SPAREPART5014.0031304 STAINLESS STEEL MESH 80 MESH X 1,3M WIDTH @30 MTR2606100333,752,5002606100332026-06-042026-06-1353,752,500912026-06-20Outstanding
2604100102026-04-07PERSEDIAAN UMUM6050.1709RIGHT LIFTING CYLINDER REPAIR KIT A2A35N450-4-000-KIT2606100351,700,0002606100352026-06-042026-06-1111,700,000582026-06-18Outstanding
2604100322026-04-14SPAREPART5014.0042304 STAINLESS STEEL SIEVE MESH 90 MESH X 1,3M WIDTH @30 MTR/ ROLL2606100325,620,0002606100322026-06-042026-06-1355,620,000512606102232026-06-0952026-06-20On time
2604100322026-04-14SPAREPART5014.0032304 STAINLESS STEEL MESH 70 MESH X 1,3M WIDTH @30 MTR2606100325,620,0002606100322026-06-042026-06-1355,620,000512606102232026-06-0952026-06-20On time
2601000632026-01-07PERSEDIAAN UMUM6030.1561BETON READYMIX MUTU K300260600062780,0002606000622026-06-032026-06-0923.2780,0001472606002542026-06-0852026-06-16On time
2604100452026-04-17PERSEDIAAN UMUM6030.0898BESI UNP 100X50X5MM (@ 6000MM) SNI260610067576,0002606100192026-06-032026-06-03200475,000472026-06-10Overdue
2603004522026-03-31PERSEDIAAN UMUM6050.0034LPG 50 KG2606001661,300,0002606000742026-06-022026-06-1331,300,000632606001302026-06-0422026-06-20On time
2603100292026-03-11PERSEDIAAN UMUM6050.0245REGULATOR OXYGEN260610001135,135.142606100012026-06-012026-06-011135,135.14822606102472026-06-0982026-06-08Late
2604100302026-04-13PERSEDIAAN UMUM6030.29TEE PVC AW 10 INCH260610003831,6002606100032026-06-012026-06-016831,600492606103502026-06-12112026-06-08Late
2604100302026-04-13PERSEDIAAN UMUM6030.2345FLEXIBLE CONDUIT 2 INCH260610003756,0002606100032026-06-012026-06-011756,000492606103502026-06-12112026-06-08Late
2604100302026-04-13PERSEDIAAN UMUM6030.2899PIPA PVC RUCIKA AW 10 INCH2606100022,700,0002606100022026-06-012026-06-01102,700,000492026-06-08Overdue
2604100302026-04-13PERSEDIAAN UMUM6030.2904FLEXIBLE CONDUIT 3/4 INCH260610003567,0002606100032026-06-012026-06-011567,000492606103502026-06-12112026-06-08Late
2604100302026-04-13PERSEDIAAN UMUM6030.2905FLEXIBLE CONDUIT 1/2 INCH260610003441,0002606100032026-06-012026-06-011441,000492606103502026-06-12112026-06-08Late
2604100302026-04-13PERSEDIAAN UMUM6030.2903FLEXIBLE CONDUIT 1 INCH260610003693,0002606100032026-06-012026-06-011693,000492606103502026-06-12112026-06-08Late
2601100112026-01-06PERSEDIAAN UMUM6030.2534NIKKO STEEL KAWAT LAS BAJA TAHAN KARAT NSN-308 (STAINLESS STEEL) 2.6MM 1PACK(4KG)260610070128,8002605102862026-05-302026-05-30200128,8001442606101042026-06-0452026-06-06On time
2601100112026-01-06PERSEDIAAN UMUM6030.2533NSN-309 KAWAT LAS STAINLESS STELL 309 3,2MM 3,2 MM NIKKO STEEL260510286166,4002605102862026-05-302026-05-30200166,4001442606101042026-06-0452026-06-06On time
2603100032026-03-03SPAREPART5021.0375BELT C-3500 2YZS1860 VIBRATING SIEVE260510294122605102942026-05-302026-05-305012882026-06-06Overdue
← PrevPage 8 of 135Next →Rows per page:1020501005001000