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
2511100952025-11-28BAHAN PACKING3011.0206CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592511101842025-11-292025-11-2984,00071512512105642025-12-29302025-12-06Late
2511100952025-11-28BAHAN PACKING3011.0206CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592511101842025-11-292025-11-2984,00071512512103032025-12-16172025-12-06Late
2511100952025-11-28BAHAN PACKING3011.0206CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592511101832025-11-292025-11-29105,00059512512102642025-12-12132025-12-06Late
2511100952025-11-28BAHAN PACKING3011.0206CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592511101852025-11-292025-11-2974,25670812601102552026-01-14462025-12-06Late
2511100952025-11-28BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962511101842025-11-292025-11-2984,00078012512103032025-12-16172025-12-06Late
2511100952025-11-28BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962511101842025-11-292025-11-2984,00078012512105642025-12-29302025-12-06Late
2511100952025-11-28BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962511101842025-11-292025-11-2984,00078012512105652025-12-29302025-12-06Late
2511100952025-11-28BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962511101852025-11-292025-11-2974,25675112512101902025-12-10112025-12-06Late
2511100952025-11-28BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962511101852025-11-292025-11-2974,25675112512102942025-12-13142025-12-06Late
2511100952025-11-28BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962511101852025-11-292025-11-2974,25675112512103892025-12-19202025-12-06Late
2511100952025-11-28BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962511101832025-11-292025-11-29105,00067112512102642025-12-12132025-12-06Late
2511100952025-11-28BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962511101832025-11-292025-11-29105,00067112512102712025-12-12132025-12-06Late
2511100952025-11-28BAHAN PACKING3011.0208CARTON BOX SIDEWRAPS PARIS 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592511101832025-11-292025-11-2963,00059512512102712025-12-12132025-12-06Late
2511100952025-11-28BAHAN PACKING3011.0212CARTON BOX SIDEWRAPS OCEANIA 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592511101842025-11-292025-11-2942,00071512512105292025-12-27282025-12-06Late
2511003002025-11-21BAHAN BAKU GLAZE1098.0006PS-800026060027620,060.62512000042025-12-012025-12-0517,00018,360.1102512001722025-12-0542025-12-12On time
2511004472025-11-29BAHAN PEMBANTU2033.0003FLUORESCENT LIQUID MARKER (TRANSPARENT)26050026832,5002512000022025-12-012025-12-0818031,00022512001892025-12-0652025-12-15On time
2511004482025-11-29BAHAN PEMBANTU2033.0002BLACK INK26060003375,024.62512000032025-12-012025-12-2018069,976.222512007862025-12-23222025-12-27On time
2511004482025-11-29BAHAN PEMBANTU2033.0002BLACK INK26060003375,024.62512000032025-12-012025-12-2018069,976.222512001732025-12-0542025-12-27On time
2511100892025-11-25PERSEDIAAN UMUM6050.0052TEMPAT SAMPAH26061009428,0002512100022025-12-012025-12-10448,75062601109132026-02-16772025-12-17Late
2511100922025-11-26BAHAN PACKING3011.021CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP2 KWA 605X38 (WK150/125/150)2604100186592512100042025-12-012025-12-0184,00059552512103292025-12-16152025-12-08Late
2511100922025-11-26BAHAN PACKING3011.0209CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP1 KWA 605X40 (WK150/125/150)2604100186962512100042025-12-012025-12-0184,00067152512103292025-12-16152025-12-08Late
2511101012025-11-29PERSEDIAAN UMUM6030.2435WF 350 12M2604101789,696,351.352512100062025-12-012025-12-01119,724,063.0622025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.229WF 2002604100193,280,0002512100062025-12-012025-12-01463,595,405.4122025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2291WF 2502512100065,188,648.652512100062025-12-012025-12-0145,188,648.6522025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.1774WF 300 12M2604101787,194,594.62512100062025-12-012025-12-01767,214,414.4122025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2299PLAT HITAM 12 MM2604101783,077,477.482512100062025-12-012025-12-01132,547,383.7822025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2443PLAT HITAM 30 MM2512100067,062,054.052512100062025-12-012025-12-0157,062,054.0522025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2287H BEAM 25025121000615,220,900.92512100062025-12-012025-12-014615,220,900.922025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2289WF 1502512100062,209,729.732512100062025-12-012025-12-01562,209,729.7322025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2297PLAT HITAM 8 MM2604101782,055,315.322512100062025-12-012025-12-0151,664,627.0322025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.23PLAT HITAM 16 MM2604101784,200,450.452512100062025-12-012025-12-01193,547,841.4422025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.244PLAT HITAM 14 MM2512100063,133,786.482512100062025-12-012025-12-01113,133,786.4822025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2441PLAT HITAM 15 MM2512100063,184,229.722512100062025-12-012025-12-01133,184,229.7222025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2301PLAT HITAM 20 MM2512100064,644,981.982512100062025-12-012025-12-0114,644,981.9822025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2298PLAT HITAM 10 MM2604101782,560,900.92512100062025-12-012025-12-01102,101,801.822025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2442PLAT HITAM 22 MM2512100064,924,521.622512100062025-12-012025-12-0134,924,521.6222025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2278BESI BETON ULIR U40 - D 22 SNI251210006306,301.362512100062025-12-012025-12-01140306,301.3622025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2436CNP 200.75. 2,3 MM (JIS)260410178522,522.522512100062025-12-012025-12-011,395388,288.2822025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2277BESI BETON ULIR U40 - D 19 SNI251210006228,460.312512100062025-12-012025-12-012,329228,460.3122025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2444PLAT HITAM 36 MM (38MM)2512100069,128,144.142512100062025-12-012025-12-0119,128,144.1422025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2302PLAT HITAM 25 MM2604101786,722,882.882512100062025-12-012025-12-01115,858,772.5222025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2295CNP 150.50. 2,3 MM (SII)260410178360,360.362512100062025-12-012025-12-0115279,279.2822025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2445BESI SIKU 40X40X4 MM SNI260310052145,0002512100062025-12-012025-12-01673143,693.6922025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.0985BESI CNP 125 X 50 X 2.3 X 6000 MM260410178328,828.832512100062025-12-012025-12-01651253,153.1522025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2438PLAT HITAM 6 MM2604101781,576,576.582512100062025-12-012025-12-01181,311,524.3222025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2276BESI BETON ULIR U40 - D 16 SNI251210006161,157.952512100062025-12-012025-12-01224161,157.9522025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2275BESI BETON ULIR U40 - D 13 SNI251210006106,389.432512100062025-12-012025-12-01346106,389.4322025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2279BESI BETON ULIR U40 - D 25 SNI251210006395,533.782512100062025-12-012025-12-01110395,533.7822025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.228BESI BETON ULIR U40 - D 28 SNI251210006496,157.582512100062025-12-012025-12-0114496,157.5822025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2281BESI BETON U24 8 MM SNI25120012840,540.542512100062025-12-012025-12-011,11439,649.9722025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2437WIREMESH M8 (7.7) LS251210006531,531.532512100062025-12-012025-12-011,555531,531.5322025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2439PLAT HITAM 9 MM2512100062,005,181.912512100062025-12-012025-12-0152,005,181.9122025-12-08Overdue
2511101012025-11-29PERSEDIAAN UMUM6030.2283BESI BETON POLOS U24 10MM SNI26061009592,0002512100062025-12-012025-12-0113862,286.1622025-12-08Overdue
2512001142025-12-01PERSEDIAAN UMUM6030.0985BESI CNP 125 X 50 X 2.3 X 6000 MM260410178328,828.832512001282025-12-012025-12-0190311,711.712025-12-08Overdue
2512001142025-12-01PERSEDIAAN UMUM6030.0412BESI BETON ULIR 19 MM251200128230,990.992512001282025-12-012025-12-0180230,990.992512005272025-12-16152025-12-08Late
2512001142025-12-01PERSEDIAAN UMUM6030.0413BESI BETON ULIR 13 MM260400477119,932.432512001282025-12-012025-12-0120107,207.212512005272025-12-16152025-12-08Late
2512001142025-12-01PERSEDIAAN UMUM6030.2281BESI BETON U24 8 MM SNI25120012840,540.542512001282025-12-012025-12-014240,540.542512005272025-12-16152025-12-08Late
2512001142025-12-01PERSEDIAAN UMUM6030.1553BESI BETON ULIR 10 MM26040047771,0002512001282025-12-012025-12-0111062,5002512005272025-12-16152025-12-08Late
2512001142025-12-01PERSEDIAAN UMUM6030.2102BESI BETON ULIR 16 MM260410106185,0002512001282025-12-012025-12-01110162,837.842512005272025-12-16152025-12-08Late
2512001142025-12-01PERSEDIAAN UMUM6030.0051KAWAT BENDRAT26061001717,6402512001282025-12-012025-12-014010,540.542512005272025-12-16152025-12-08Late
2512001152025-12-01PERSEDIAAN UMUM6050.028BESI PLAT 10X1200X2400 MM2605102062,695,0002512001312025-12-012025-12-0182,036,126.132512006332025-12-18172025-12-08Late
2512001152025-12-01PERSEDIAAN UMUM6030.1225BESI PLAT 6MM X 1200MM X 2400MM2512001311,267,567.572512001312025-12-012025-12-01101,267,567.572512006332025-12-18172025-12-08Late
2512001152025-12-01PERSEDIAAN UMUM6030.0166KAWAT LAS RB 26 2.6 MM26060001333,333.332512001312025-12-012025-12-014028,963.962512006332025-12-18172025-12-08Late
2512001162025-12-01PERSEDIAAN UMUM6030.0507THINER B26010039823,1002512001452025-12-012025-12-126023,1002512004672025-12-13122025-12-19On time
2512001162025-12-01PERSEDIAAN UMUM6030.2466AVIAN BELMAS ZINCHROMATE 724 GREY @20 KG260610139885,0772512001452025-12-012025-12-123654,0002512004672025-12-13122025-12-19On time
2511003062025-11-22BAHAN PEMBANTU20OT.0001PAC POWDER2604005079,0002512000082025-12-022025-12-064,7009,000102512001752025-12-0532025-12-13On time
2511003542025-11-21PERSEDIAAN UMUM6020.0375FLEXIBLE TAPE TZE 9 MM (WARNA HIJAU)260600184195,5002512000252025-12-022025-12-202265,000112512008302025-12-24222025-12-27On time
2511003542025-11-21PERSEDIAAN UMUM6020.0377FLEXIBLE TAPE TZE 24 MM (WARNA HIJAU)260600185370,0002512000252025-12-022025-12-202399,000112512008302025-12-24222025-12-27On time
2511003652025-11-25STATIONERY6010.0717MAP PLASTIK / MAP SCHOOL BAG26040025711,7002512000212025-12-022025-12-20211,00072512002972025-12-1082025-12-27On time
2511003652025-11-25STATIONERY6010.0143CLIP TRIGONAL2605002611,5002512000212025-12-022025-12-2041,60072512002972025-12-1082025-12-27On time
2511003652025-11-25STATIONERY6010.019BUKU TULIS SIDU(16*21) 16 X 21 CM2606000274,6002512000212025-12-022025-12-2024,50072512002972025-12-1082025-12-27On time
2511003652025-11-25STATIONERY6010.0122BOLPOIN HITAM2606000271,3002512000202025-12-022025-12-20122,00072512006892025-12-22202025-12-27On time
2511003652025-11-25STATIONERY6010.0184MAP PLASTIK L TRANSPARAN, F42605004191,6002512000212025-12-022025-12-20361,54272512002972025-12-1082025-12-27On time
2511003652025-11-25STATIONERY6010.0541MAP CLEAR HOLDER (MAP SNELL)26010056030,0002512000212025-12-022025-12-20130,00072512002972025-12-1082025-12-27On time
2511003652025-11-25STATIONERY6010.0001KERTAS A426060024443,0002512000212025-12-022025-12-20543,00072512002972025-12-1082025-12-27On time
2511003652025-11-25PERSEDIAAN UMUM6010.0575MOUSE LAPTOP WIRELESS260500321119,0002512000202025-12-022025-12-205115,00072512006892025-12-22202025-12-27On time
2511003652025-11-25STATIONERY6010.0714KERTAS A326060014577,0002512000202025-12-022025-12-20176,70072512006892025-12-22202025-12-27On time
2511003652025-11-25STATIONERY6010.0251BOX FILE26010014232,0002512000202025-12-022025-12-20332,00072512006892025-12-22202025-12-27On time
2511003652025-11-25STATIONERY6010.0127SPIDOL BOARDMARKER HITAM - BOARDMARKER, HITAM/BLACK2606101518,9982512000202025-12-022025-12-2016,70072512006892025-12-22202025-12-27On time
2511003652025-11-25STATIONERY6010.0444TINTA EPSON 003 CYAN 65ML26060002783,0002512000202025-12-022025-12-20283,00072512006892025-12-22202025-12-27On time
2511003652025-11-25STATIONERY6010.0442TINTA EPSON 003 YELLOW 65ML26060002783,0002512000202025-12-022025-12-20283,00072512006892025-12-22202025-12-27On time
2511003652025-11-25STATIONERY6010.0441TINTA EPSON 003 BLACK 65ML26060002783,0002512000202025-12-022025-12-20283,00072512006892025-12-22202025-12-27On time
2511003652025-11-25STATIONERY6010.0443TINTA EPSON 003 MAGENTA 65ML26060002783,0002512000202025-12-022025-12-20283,00072512006892025-12-22202025-12-27On time
2511003652025-11-25PERSEDIAAN UMUM6020.005KALKULATOR26060002765,0002512000212025-12-022025-12-20255,00072512002972025-12-1082025-12-27On time
2511003652025-11-25STATIONERY6010.0539LAKBAN BENING 2 INCI / 48MM2605003228,0002512000202025-12-022025-12-20208,50072512006892025-12-22202025-12-27On time
2511003652025-11-25STATIONERY6010.015ISI CUTTER BESAR L-1502606100606,5002512000212025-12-022025-12-2021,20072512002972025-12-1082025-12-27On time
2511003652025-11-25STATIONERY6010.0172BINDER CLIP NO. 107 NO. 1072606100603,5002512000202025-12-022025-12-2062,50072512006892025-12-22202025-12-27On time
2511003652025-11-25STATIONERY6010.0667ISOLASI MEJA 1 INCHI2604002063,2002512000212025-12-022025-12-2064,30072512002972025-12-1082025-12-27On time
2511003652025-11-25STATIONERY6010.0716ISI CUTTER A-30026051002334,1202512000212025-12-022025-12-2022,50072512002972025-12-1082025-12-27On time
2511003652025-11-25STATIONERY6010.0243PAPER CLIP NO 52604002074,0002512000212025-12-022025-12-2054,00072512002972025-12-1082025-12-27On time
2511003652025-11-25STATIONERY6010.0168GUNTING2606000276,2002512000212025-12-022025-12-2018,90072512002972025-12-1082025-12-27On time
2511003652025-11-25STATIONERY6010.0173BINDER CLIP NO. 111 NO. 1112606000273,8002512000202025-12-022025-12-2073,80072512006892025-12-22202025-12-27On time
2511004032025-11-26PERSEDIAAN UMUM6050.012BAN LUAR 7.50X162512000241,390,0002512000242025-12-022025-12-2021,390,00062512002502025-12-0972025-12-27On time
2511004032025-11-26PERSEDIAAN UMUM6050.0153BAN DALAM 7.50X16251200024185,0002512000242025-12-022025-12-202185,00062512002502025-12-0972025-12-27On time
2511004082025-11-25BAHAN BAKAR4010.0001SOLAR26060011120,720.722512000132025-12-022025-12-168,00013,378.3872512001742025-12-0532025-12-23On time
2511004132025-11-28STATIONERY6010.012COUNTINOUS FORM 2 PLY251200028305,0002512000282025-12-022025-12-101305,00042512001152025-12-0532025-12-17On time
2511004152025-11-28SPAREPART5032.1411SOLID TYRE25120001017,000,0002512000102025-12-022025-12-02417,000,00042606002312026-06-061862025-12-09Late
2511004152025-11-28SPAREPART5032.1411SOLID TYRE25120001017,000,0002512000102025-12-022025-12-02417,000,00042605000282026-05-021512025-12-09Late
2511004152025-11-28SPAREPART5032.141SIDE SHIFTER25120001031,000,0002512000102025-12-022025-12-02431,000,00042605000282026-05-021512025-12-09Late
2511004152025-11-28SPAREPART5032.141SIDE SHIFTER25120001031,000,0002512000102025-12-022025-12-02431,000,00042606002312026-06-061862025-12-09Late
← PrevPage 6 of 135Next →Rows per page:1020501005001000