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
2601005842026-02-11PERSEDIAAN UMUM6050.0243ACCU / BATTERAY N-1202603000482,230,00000No ETA
2601005862026-02-11PERSEDIAAN UMUM6060.0434BAUT DYNABOLT 12X100 MM250201225,000752,191.89No ETA
2601006042026-02-12SPAREPART5031.042KARET TUTUP BALLMILL 40T OD 655X570X535X240X20MM JARAK LUBANG BAUT 20X40MM26010057311300No ETA
2601006042026-02-12SPAREPART5031.0379KARET TUTUP BALLMILL 40T OD 355X295X220X20 MM2601005734800No ETA
2601006042026-02-12SPAREPART5031.0378KARET TUTUP BALLMILL () 40T OD 605MMxOD 540MMx220MMx20MM 40T (BESAR)26010057311000No ETA
2601006092026-02-13PERSEDIAAN UMUM6060.0679KEPALA GREASE GUN RUNCING000No ETA
2601006272026-02-13PERSEDIAAN UMUM6030.272NEPEL SELANG DRAT LUAR 8 MM X 3/4 INCH000No ETA
2601006382026-02-14SPAREPART5019.0359MOTOR + GEARBOX 2.2KW 3.7A 380VOLT NMRV 075 RATIO 1:60000No ETA
2601006412026-02-14SPAREPART5031.0995GEARBOX NMRV 040 RATIO 1:75MM + MOTOR 2.2KW 3.7A 380VOLT000No ETA
2601006422026-02-13SPAREPART5021.0138V. BELT C - 122260101095164,4008164,400No ETA
2601006422026-02-13SPAREPART5021.0332V. BELT C - 236260101176328,5006328,500No ETA
2601006422026-02-13SPAREPART5021.0041V. BELT B - 6026010117643,600643,600No ETA
2601006422026-02-13SPAREPART5021.0037V. BELT B - 5326010117638,500438,500No ETA
2601006422026-02-13SPAREPART5021.0041V. BELT B - 6026010117643,600643,600No ETA
2601006422026-02-13SPAREPART5021.0036V. BELT B - 5026050020939,900636,300No ETA
2601006422026-02-13SPAREPART5021.0036V. BELT B - 5026050020939,900436,300No ETA
2601006422026-02-13SPAREPART5021.0044V. BELT B - 6426050046851,050446,500No ETA
2601006422026-02-13SPAREPART5021.0037V. BELT B - 5326010117638,500638,500No ETA
2601006422026-02-13SPAREPART5021.0125V. BELT B - 260260101095198,80012198,800No ETA
2601006422026-02-13SPAREPART5021.0044V. BELT B - 6426050046851,050646,500No ETA
2601006422026-02-13SPAREPART5021.0104V. BELT B - 196260101095142,30010142,300No ETA
2601006422026-02-13SPAREPART5021.0143V. BELT C - 150260101176202,2003202,200No ETA
2601006422026-02-13SPAREPART5021.0145V. BELT C - 177260101176238,6004238,600No ETA
2601006422026-02-13SPAREPART5021.0127V. BELT B - 270260300499206,50016206,500No ETA
2601006422026-02-13SPAREPART5021.0145V. BELT C - 177260101176238,6004238,600No ETA
2601006422026-02-13SPAREPART5021.0143V. BELT C - 150260101176202,2008202,200No ETA
2601006432026-02-13SPAREPART5029.0473ROLL DRYER OD 34 X ID 29.2 X L 3250 MM000No ETA
2601006432026-02-13SPAREPART5029.0479PIN ROLL ( ORANGE )000No ETA
2601006432026-02-13SPAREPART5029.048PIN ROLL (EXSENTRIX ROLL)000No ETA
2601006432026-02-13SPAREPART5029.0485ROLL DRIVE SHAFT ID15XL117MM000No ETA
2601006432026-02-13SPAREPART5029.0484ROLL DRIVER GEARS ID12X15TOOTH000No ETA
2601006432026-02-13SPAREPART5029.0478GEAR AS SHAFT PINION000No ETA
2601006432026-02-13SPAREPART5029.0475ROLL OUTPUT PEMBALIK OD 38 ( +RUBBER ) X L 1675 MM000No ETA
2601006432026-02-13SPAREPART5029.0474ROLL INPUT DRYER OD 38 ( +RUBBER ) X L 2990 MM000No ETA
2601006432026-02-13SPAREPART5029.0482GEAR SPROKET RANTAI (KECIL)000No ETA
2601006432026-02-13SPAREPART5029.0477MONOBLOCK PINION000No ETA
2601006432026-02-13SPAREPART5029.0486ROLL DRIVE SHAFT ID12XL129MM000No ETA
2601006432026-02-13SPAREPART5029.0483ROLL DRIVER GEARS ID15X15TOOTH000No ETA
2601006432026-02-13SPAREPART5029.0472ROLL DRYER OD 34 X ID 29.2 X L 3400 MM000No ETA
2601006432026-02-13SPAREPART5029.0476ROLL INPUT PEMBALIK OD 35 ( +RUBBER ) X L 1640 MM000No ETA
2601006432026-02-13SPAREPART5029.0481GEAR SPROKET RANTAI (BESAR)000No ETA
2601006442026-02-13SPAREPART5019.0358BLOWER MOTOR000No ETA
2601006452026-02-16FIXED ASSETSAST02663ADD 1BAR WITH 11 PH TYPE MC FOR INFINITY SN DZ25000032601104601,245,756,27611,245,756,276No ETA
2601006742026-02-16FIXED ASSETSAST02664LAPTOP LENOVO I3 (HO)000No ETA
2601006822026-02-18PERSEDIAAN UMUM6010.0833Kartu SIM Prabayar Corporate000No ETA
2601006822026-02-18FIXED ASSETSAST02665HP ANDROID OPPO A60 (HO)000No ETA
2601006882026-02-18PERSEDIAAN UMUM6060.0505MUR M16 (BAJA HITAM)2507100472,88000No ETA
2601006972026-02-18BAHAN BAKU GLAZE1070.0008INK - CIK VE 1183 GREEN260600119224,22800No ETA
2601007052026-02-18BAHAN PEMBANTU2034.0006HOTMELT GLUE GM811E26060001683,00000No ETA
2601007112026-02-18BAHAN PEMBANTU2022.0004PET STRAPPING BAND 9X0.8 MM251000468174,00000No ETA
2601007132026-02-18FIXED ASSETSAST02649260100938128,474,468.4700No ETA
2601007132026-02-18FIXED ASSETSAST02650GRANMAX BLINDVAN 1.3 AC (Mobil Operational MD Tengah)260100938143,818,278.38119,211,711No ETA
2601007132026-02-18FIXED ASSETSAST02651GRANMAX BLINDVAN 1.3 AC (Mobil Operational MD Timur)260100938143,818,278.381143,818,278.38No ETA
2601007132026-02-18FIXED ASSETSAST02651GRANMAX BLINDVAN 1.3 AC (Mobil Operational MD Timur)260100938143,818,278.38119,211,711No ETA
2601007132026-02-18FIXED ASSETSAST02650GRANMAX BLINDVAN 1.3 AC (Mobil Operational MD Tengah)260100938143,818,278.381143,818,278.38No ETA
2601007132026-02-18FIXED ASSETSAST02649GRANMAX BLINDVAN 1.3 AC (Mobil Operational MD Barat)260100938128,474,468.47119,993,340No ETA
2601007232026-02-19FIXED ASSETSAST02666ULTRA HIGH PRESSURE 950-75 HUAYAN PUMP000No ETA
2601007372026-02-20BAHAN PEMBANTU20AB.0004MEDIUM ALUMINA BALL SIZE: 60MM 68%2603003100.3100No ETA
2601007372026-02-20BAHAN PEMBANTU20AB.0003MEDIUM ALUMINA BALL SIZE: 50MM 68%2603003100.3100No ETA
2601007372026-02-20BAHAN PEMBANTU20BK.0016MEDIUM ALUMINA LINING BRICK 140X40X37X972603002030.4500No ETA
2601007372026-02-20BAHAN PEMBANTU20BK.0015MEDIUM ALUMINA LINING BRICK 140X40X972605004180.3600No ETA
2601007382026-02-20SPAREPART5019.036GEARBOX NMRV 050 RATIO 1:15 INPUT SHAFT 19 OUTPUT SHAFT 252601011663,062,50000No ETA
2601007522026-02-20PERSEDIAAN UMUM6030.2153ATAP UPVC DR SHIELD TWIN WALL RF 1065MM X 5M - WARNA PUTIH260400479872,747.7500No ETA
2601007552026-02-20PERSEDIAAN UMUM6030.2739EMERGENCY ROPE000No ETA
2601007582026-02-20PERSEDIAAN UMUM6050.0098MASKER26050043837000No ETA
2601007652026-02-21SPAREPART5032.0318SELANG HYDROLIC 1/2 INCH @4 MTR + NEPLE251200150400,00000No ETA
2601007952026-02-20BAHAN PACKING3011.0137BOX MY HIJAU TS 40*40 KW II2605004741,27500No ETA
2601008202026-02-24SPAREPART5030.1799SERVO DRIVE INOVANCE SV605NS5R5I26030039315500No ETA
2601008202026-02-24SPAREPART5019.035MOTOR INNOVANCE SERVO MOTOR MSAH4 - 7530CB TYPE T231R26030039311000No ETA
2601008302026-02-24FIXED ASSETSAST02673LISENSI RDS 50 USER WINDOWS SERVER 2012 R2000No ETA
2601008322026-02-24PERSEDIAAN UMUM6050.1322GAS BATU BARA000No ETA
2601008322026-02-24PERSEDIAAN UMUM6020.0369KABEL NYYHY 4X1.5 MM2605001012,300,00000No ETA
2601008322026-02-24PERSEDIAAN UMUM6030.2636KUAS 10 INCH000No ETA
2601008342026-02-24PERSEDIAAN UMUM6010.0833Kartu SIM Prabayar Corporate000No ETA
2601008612026-02-25PERSEDIAAN UMUM6060.0036BAUT L M 5*602601007491,972.9700No ETA
2601008792026-02-25PERSEDIAAN UMUM6030.2756DR. SHIELD SHEET SINGLE WALL RF1050 WHITE LE=1050MM P=4.7 M000No ETA
2601008792026-02-25PERSEDIAAN UMUM6030.0895ROSTER JALUSI 200 X 400 MM25110041717,50000No ETA
2601008902026-02-27STATIONERY6010.0001KERTAS A426060024443,00000No ETA
2601009032026-02-27FIXED ASSETSAST02653MITSUBISHI FE 84 G N (armada gudang Semarang)260300257369,369,369.3700No ETA
2601009032026-02-27FIXED ASSETSAST02652MITSUBISHI FE 84 G N (armada gudang Sukodono)260300257369,369,369.3700No ETA
2601009032026-02-27FIXED ASSETSAST02652MITSUBISHI FE 84 G N (armada gudang Sukodono)260300257369,369,369.3700No ETA
2601009032026-02-27FIXED ASSETSAST02653MITSUBISHI FE 84 G N (armada gudang Semarang)260300257369,369,369.3700No ETA
2601009182026-02-28FIXED ASSETSAST02676FORKLIFT DIESEL 7 TON MAST STD 5 METER000No ETA
2601009202026-02-28PERSEDIAAN UMUM6020.0797TRAVO LAS 1 PASS DAIDEN 900 WATT000No ETA
2601009232026-02-28PERSEDIAAN UMUM6050.0589LPG 12 KG260600005250,00021,350,000No ETA
2601009242026-02-28SPAREPART5026.0241PRINT HEAD TESTER COMPATIBLE WITH DIMATIX 102426010105412,68800No ETA
2601009242026-02-28SPAREPART5026.0242PRINT HEAD CLEANER2601010545,00000No ETA
2601100042026-01-05PERSEDIAAN UMUM6030.252BOR LISTRIK 13MM BOSCH000No ETA
2601100042026-01-05PERSEDIAAN UMUM6050.1249ADAPTER IMPACT WRENCH 1/2 KE MESIN BOR DRILL CHUCK 13 MM000No ETA
2601100042026-01-05PERSEDIAAN UMUM6050.1247BARTON TOOLS SKATE TANK MACHINE ROLLER CRA-15 15TON000No ETA
2601100112026-01-06PERSEDIAAN UMUM6030.248BATU GERINDA POLES BETON 4 INCH000No ETA
2601100122026-01-06PERSEDIAAN UMUM6050.1265ENDING BESAR DLT KY-20000000No ETA
2601100122026-01-06PERSEDIAAN UMUM6050.1264BENDING KECIL DLT 2K-DPK000No ETA
2601100122026-01-06PERSEDIAAN UMUM6050.1266MESIN ABRASI DLT LM-8000No ETA
2601100122026-01-06PERSEDIAAN UMUM6050.1268IMBANGAN 100KG (DLT) - PRESS TCS-30L000No ETA
2601100122026-01-06PERSEDIAAN UMUM6050.1269KALIFER 100CM SHIN-QC000No ETA
2601100122026-01-06PERSEDIAAN UMUM6050.1267MESIN AYAK DLT 8411-200000No ETA
2601100122026-01-06PERSEDIAAN UMUM6050.127TARA/PICNOMETER000No ETA
2601100142026-01-07PERSEDIAAN UMUM6030.248BATU GERINDA POLES BETON 4 INCH000No ETA
2601100142026-01-07PERSEDIAAN UMUM6030.0729REFILL BULU ROLL KECIL () 4 INCH260310126975503,440No ETA
← PrevPage 4 of 135Next →Rows per page:1020501005001000