Manufacturing Ops Strategic Project Control
SOURCE_1Google Spreadsheet (dibagikan lewat tautan)Tersambung
Spreadsheet Project Control (CI Lead), dibagikan lewat tautan sejak 18 Nov 2026 dan diunduh sebagai xlsx. Sheet: Project_List, Task_Detail, Issue_Log, Setting, dll.
Dataset
Project_List
Menampilkan 1–45 dari 45 baris
| Baris sheet | No | Status | Dept PIC | End Plan | Jml Task | Variance | Planned % | Prioritas | Project ID | Start Plan | Nama Project | Durasi (hari) | Pilar Strategis | Progress Aktual | Status Override | PIC - Project Team | Target Improvement | Scope / Deliverable | Catatan / Next Action | Helper (jangan dihapus) | Progress Manual % (dipakai jika tidak ada task) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | 1 | Delayed | QAQC | 09/11/2026 | 5 | -70% | 100% | High | MOP-01 | 21/09/2026 | 5R Implementation | 50 | P1 People & Culture | 30% | Skor audit 5R ≥ 80% di semua area | Ringkas, Rapi, Resik, Rawat, Rajin di area produksi & gudang; audit 5R bulanan | -70% | 0% | |||
| 7 | 2 | Delayed | COO + CI | 06/11/2026 | 5 | -49% | 100% | High | MOP-02 | 05/10/2026 | Bentuk CI + OBEYA | 33 | P1 People & Culture | 52% | OBEYA meeting mingguan 100% terlaksana; ≥ 2 kaizen/bulan | Tim continuous improvement lintas departemen & ruang OBEYA untuk visual management | -48% | 0% | |||
| 8 | 3 | At Risk | QAQC | 31/12/2026 | 5 | -21% | 50% | Medium | MOP-03 | 05/10/2026 | SOP Project (collab HC) | 88 | P1 People & Culture | 29% | 100% proses kritis memiliki SOP terbaru & ter-training | Penyusunan & revisi SOP semua departemen bersama HC, sosialisasi dan training | -21% | 0% | |||
| 9 | 4 | Delayed | Operations (COO) | 23/11/2026 | 5 | -28% | 88% | High | MOP-04 | 05/10/2026 | COGM Project | 50 | P2 Cost & Productivity | 60% | COGM per SKU terbit bulanan; selisih vs aktual ≤ 3% | Perhitungan Cost of Goods Manufactured per SKU (material, labor, overhead) | -28% | 0% | |||
| 10 | 5 | Delayed | R&D | 30/11/2026 | 5 | -77% | 77% | High | MOP-05 | 05/10/2026 | Kurasi Pareto C by Manuf | 57 | P2 Cost & Productivity | 0% | Kurasi pareto C agar bisa menghemat inventory dan WH occupancy | Kurasi SKU kelas C berdasarkan SLOB dan trend BB/PM yang slow moving | -77% | 0% | |||
| 11 | 6 | Delayed | Engineering | 26/02/2027 | 5 | -25% | 30% | High | MOP-06 | 05/10/2026 | MC Development & Balancing | 145 | P2 Cost & Productivity | 5% | Line efficiency ≥ 85%; OEE meningkat | Pengembangan/modifikasi mesin dan line balancing untuk menaikkan output & utilisasi | -25% | 0% | |||
| 12 | 7 | Completed | PPIC | 31/12/2026 | 4 | 50% | 50% | High | MOP-07 | 05/10/2026 | ERP v.1 – SPK Fully Operate | 88 | P3 Digital & Data | 100% | 100% SPK terbit & ditutup via ERP | Modul SPK produksi berjalan penuh di ERP (BOM, routing, realisasi) | 0% | ||||
| 13 | 8 | Not Started | Operations (COO) | 28/05/2027 | 4 | 0% | 0% | Medium | MOP-08 | 04/01/2027 | Automate ERP B2B – COGM | 145 | P3 Digital & Data | 0% | COGM otomatis dari ERP; input manual berkurang | Otomasi order B2B dan perhitungan COGM langsung dari ERP | 0% | ||||
| 14 | 9 | Completed | PPIC | 31/12/2026 | 4 | 54% | 46% | High | MOP-09 | 12/10/2026 | Dashboard Balancing RMPMFG | 81 | P3 Digital & Data | 100% | Akurasi stok ≥ 98%; stockout menurun | Dashboard stok bahan baku, kemasan & barang jadi dengan safety stock dan reorder point | 0% | ||||
| 15 | 10 | Delayed | All Dept. | 11/12/2026 | 4 | -41% | 56% | Medium | MOP-10 | 19/10/2026 | Dashboard Monitoring Report | 54 | P3 Digital & Data | 15% | Laporan harian terbit setiap pagi | Dashboard daily monitoring report | -41% | 0% | |||
| 16 | 11 | Completed | Operations (COO) | 15/01/2027 | 4 | 79% | 21% | Medium | MOP-11 | 02/11/2026 | Management Report | 75 | P3 Digital & Data | 100% | Management report terbit tiap bulan tepat waktu | Laporan bulanan manajemen operasi (KPI, biaya, kualitas, delivery) | 0% | ||||
| 17 | 12 | On Track | QAQC | 30/09/2027 | 5 | 12% | 12% | High | MOP-12 | 05/10/2026 | Compliance (CPPOB, HACCP, ISO) | 361 | P4 Quality & Compliance | 24% | Sertifikat CPPOB, HACCP, ISO, SNI diperoleh | Pemenuhan regulasi & sertifikasi sistem mutu dan keamanan pangan | 0% | ||||
| 18 | 13 | Delayed | QAQC | 31/12/2026 | 5 | -28% | 50% | High | MOP-13 | 05/10/2026 | Create CCP Setiap Proses Produksi | 88 | P4 Quality & Compliance | 22% | CCP terdefinisi & dimonitor di 100% proses | Hazard analysis dan penetapan CCP per proses produksi | -28% | 0% | |||
| 19 | 14 | On Track | QAQC | 26/02/2027 | 4 | 8% | 2% | Medium | MOP-14 | 16/11/2026 | Visual Standar Quality incl. FS | 103 | P4 Quality & Compliance | 10% | Visual standard terpasang di semua line; temuan audit FS turun | Visual standard kualitas (OK/NG board) dan signage food safety di line | 0% | ||||
| 20 | 15 | On Track | PPIC | 31/03/2027 | 5 | 63% | 22% | High | MOP-15 | 12/10/2026 | Demand Supply Planning (S&OP) | 171 | P5 Supply Chain & Planning | 85% | Forecast accuracy ≥ 80%; S&OP rutin bulanan | Siklus S&OP bulanan: demand review, supply review, executive S&OP | 0% | ||||
| 21 | 16 | At Risk | Procurement | 29/01/2027 | 4 | -12% | 29% | Medium | MOP-16 | 19/10/2026 | Vendor Scorecard Procurement | 103 | P5 Supply Chain & Planning | 18% | 100% vendor utama dinilai per kuartal | Penilaian vendor berbasis Quality, Cost, Delivery, Service | Melakukan penilaian, form sudah tersedia | -12% | 0% | ||
| 22 | 17 | At Risk | Warehouse & Logistics | 31/03/2027 | 5 | -11% | 11% | Medium | MOP-17 | 02/11/2026 | Optimizing WH Occupancy & Racking | 150 | P5 Supply Chain & Planning | 0% | Occupancy optimal; akurasi lokasi stok ≥ 98% | Layout gudang, racking, dan slotting untuk menaikkan kapasitas | -11% | 0% | |||
| 23 | 18 | At Risk | Operations (COO) | 19/03/2027 | 5 | -13% | 13% | High | MOP-18 | 30/10/2026 | Ramadhan Strategy | 141 | P5 Supply Chain & Planning | 0% | Fill rate ≥ 95% selama periode Ramadhan | Forecast, build-up stok & kapasitas untuk peak Ramadhan 2027 | -13% | 0% | |||
| 24 | 19 | On Track | Engineering | 30/06/2027 | 5 | -9% | 16% | High | MOP-19 | 05/10/2026 | Sangiang (Layout, LT, Renov, Move) | 269 | P6 Infrastructure & NPD | 7% | Fasilitas Sangiang beroperasi sesuai jadwal | Desain layout, timeline, renovasi dan relokasi dari Cp ke Sangiang | 0% | ||||
| 25 | 20 | On Track | R&D | 31/03/2027 | 4 | 32% | 18% | Medium | MOP-20 | 19/10/2026 | Speed Up NPD–EPD + Dashboard (I&O) | 164 | P6 Infrastructure & NPD | 51% | Lead time NPD turun; pipeline R&D termonitor | Percepatan new/existing product development dan dashboard pipeline R&D | 0% | ||||
| 26 | 21 | On Track | R&D | 30/11/2026 | 5 | -5% | 77% | High | MOP-21 | 05/10/2026 | Cost Reduction HPP Produk >45% | 57 | P2 Cost & Productivity | 72% | HPP lebih sehat dan margin lebih besar, sehingga bisa digunakan untuk pengembangan | Identifikasi produk dengan HPP >40-45% bahkan lebih ini menjadi prioritas dalam reducing/reformulasi | 0% | ||||
| 27 | 22 | Delayed | Production | 31/12/2026 | 4 | -64% | 64% | High | MOP-22 | 02/09/2026 | Efisiensi Gas | 121 | P2 Cost & Productivity | 0% | Yusuf Hamdani / Fajar | Konsumsi gas per batch turun; sisa gas tidak terpakai minimal | Mengurangi pemborosan & sisa gas tidak terpakai; kaji opsi PGN vs CNG dan pengaturan main valve | -64% | 0% | ||
| 28 | 23 | Delayed | Production | 29/01/2027 | 3 | -52% | 52% | High | MOP-23 | 31/08/2026 | AHU Ruang Produksi | 152 | P6 Infrastructure & NPD | 0% | Agung / Yusuf Hamdani | Suhu ruang produksi sesuai standar; waste akibat suhu turun | Pengadaan AHU agar suhu ruang produksi standar (shelf life, waktu filling, waste) | -52% | 0% | ||
| 29 | 24 | Delayed | Production | 30/09/2026 | 4 | -100% | 100% | MOP-24 | 01/09/2026 | Coding Machine | 30 | P2 Cost & Productivity | 0% | Dewa / Yusuf Hamdani | Manpower proses coding berkurang | Otomasi proses coding untuk mengurangi tenaga manual | -100% | 0% | |||
| 30 | 25 | Delayed | Production | 29/01/2027 | 6 | -40% | 40% | High | MOP-25 | 01/10/2026 | Machine Guidance & Part Management | 121 | P2 Cost & Productivity | 0% | Yusuf Hamdani / Heri | Waktu setting mesin turun; tidak ada kehabisan sparepart kritis | Standar setting mesin & manajemen sparepart agar setting tidak gonta-ganti dan sparepart tidak habis saat perbaikan | -40% | 0% | ||
| 31 | 26 | Delayed | QAQC | 31/12/2026 | 5 | -50% | 50% | Medium | MOP-26 | 05/10/2026 | Reject Kemasan/Packaging | 88 | P2 Cost & Productivity | 0% | Shafry / Rama | % reject kemasan turun | Menurunkan reject kemasan/packaging melalui cek berkala dan perbaikan penyebab | -50% | 0% | ||
| 32 | 27 | Delayed | Production | 31/12/2026 | 5 | -50% | 50% | Medium | MOP-27 | 05/10/2026 | Water Heater untuk Cleaning | 88 | P2 Cost & Productivity | 0% | Yusuf Hamdani / Dimekk | Kebutuhan air panas terpenuhi dengan biaya lebih efisien | Penyediaan water heater produksi (pakai unit Joglo/Hokala atau beli baru) | -50% | 0% | ||
| 33 | 28 | At Risk | R&D | 29/01/2027 | 5 | -18% | 18% | Medium | MOP-28 | 02/11/2026 | Baking Mate Evaluation | 89 | P2 Cost & Productivity | 0% | Shafry / Tri | Saving biaya proses baking | Inisiatif baking mate untuk penghematan biaya (detail scope menunggu PIC) | -18% | 0% | ||
| 34 | 29 | Delayed | R&D | 29/01/2027 | 5 | -38% | 38% | Medium | MOP-29 | 05/10/2026 | Climate Chamber - Uji stability NPD | 117 | P6 Infrastructure & NPD | 0% | Nia / Adi | Biaya uji shelf life eksternal turun; uji internal berjalan | Pengadaan climate chamber untuk uji umur simpan (NPD) internal; 8x uji lab eksternal setara harga 1 alat | -38% | 0% | ||
| 35 | 30 | At Risk | Production | 29/01/2027 | 5 | -18% | 18% | MOP-30 | 02/11/2026 | Efisiensi Listrik | 89 | P2 Cost & Productivity | 0% | Dewa / Yusuf Hamdani | Biaya listrik per bulan turun | Atur jadwal start mesin bertahap agar tidak ada lonjakan beban; pantau biaya listrik | -18% | 0% | |||
| 36 | 31 | At Risk | Fulfillment | 29/01/2027 | 5 | -18% | 18% | MOP-31 | 02/11/2026 | Optimalisasi Akurasi Pengiriman | 89 | P5 Supply Chain & Planning | 0% | Sofi / Randa | Kasus salah/kurang kirim turun | Mengurangi kasus salah kirim/kurang kirim produk ke customer | -18% | 0% | |||
| 37 | 32 | At Risk | Fulfillment | 29/01/2027 | 5 | -18% | 18% | Medium | MOP-32 | 02/11/2026 | Optimalisasi Produktivitas Packing | 89 | P2 Cost & Productivity | 0% | Sofi / Randa | Output packing per orang naik | Meningkatkan output packing per orang | -18% | 0% | ||
| 38 | 33 | Delayed | Fulfillment | 31/12/2026 | 5 | -27% | 27% | MOP-33 | 02/11/2026 | K3 - APAR | 60 | P4 Quality & Compliance | 0% | Sofi / Dimekk | 100% APAR sesuai standar & terinspeksi rutin | Pemenuhan jumlah, penempatan, dan masa berlaku APAR di area kerja | -27% | 0% | |||
| 39 | 34 | Delayed | Fulfillment | 31/12/2026 | 5 | -50% | 50% | Medium | MOP-34 | 05/10/2026 | Perbaikan Area Picking | 88 | P5 Supply Chain & Planning | 0% | Sofi | Area picking tertata; waktu picking turun | Penataan area picking: geser hingga pindah ke Joglo | -50% | 0% | ||
| 40 | 35 | Delayed | Production | 31/12/2026 | 5 | -50% | 50% | MOP-35 | 05/10/2026 | Evaluasi Penggunaan Oven | 88 | P2 Cost & Productivity | 0% | Tarwipin / Dewa | Utilisasi oven optimal; biaya energi per batch turun | Evaluasi data pemakaian oven dan hasilnya untuk efisiensi | -50% | 0% | |||
| 41 | 36 | Delayed | Production | 30/11/2026 | 5 | -77% | 77% | Medium | MOP-36 | 05/10/2026 | Kapasitas Meja Resting | 57 | P2 Cost & Productivity | 0% | Yusuf Hamdani / Dewa | Kapasitas meja resting sesuai kebutuhan output | Perhitungan kapasitas & layout meja resting | -77% | 0% | ||
| 42 | 37 | Delayed | Production | 30/11/2026 | 5 | -77% | 77% | Medium | MOP-37 | 05/10/2026 | Pengkodean Secara Batch | 57 | P3 Digital & Data | 0% | Bintang / Shafry | 100% hasil produksi berkode batch per shift | Kode batch 1 shift 1 batch (bisa tampil jam), terhubung input hasil produksi di ERP | -77% | 0% | ||
| 43 | 38 | Delayed | Fulfillment | 30/11/2026 | 5 | -79% | 79% | Medium | MOP-38 | 01/10/2026 | Perubahan Metode Packing #1 | 61 | P2 Cost & Productivity | 0% | Sofi / Eva | Saving ±Rp61,7 jt/bulan (±Rp2 jt/hari) | Ganti dus ke polymailer untuk rolled oat, kismis, Krachy, kacang arab (non-brand), Moricle & moringa (Kurma Alif grup) | -79% | 0% | ||
| 44 | 39 | Not Started | QAQC | 4 | 0% | 0% | High | MOP-39 | Pest Control & Hygiene Revamp | P4 Quality & Compliance | 0% | Zero pest finding, 100% area bersih | Penutupan akses tikus (lubang dinding), deep cleaning sarang laba-laba, dan evaluasi vendor Pest Control. | 0% | |||||||
| 45 | 40 | Not Started | Production | 4 | 0% | 0% | High | MOP-40 | Facility & Working Env. Improvement | P6 Infrastructure & NPD | 0% | Fasilitas 100% berfungsi baik | Pemasangan peredam panas atap gudang, perbaikan loker/ruang ganti, kran air, dan instalasi pipa air mixing. | 0% | |||||||
| 46 | 41 | Not Started | Engineering | 3 | 0% | 0% | Medium | MOP-41 | Traffic & Safety (K3) Marking | P1 People & Culture | 0% | Area kerja 100% terstandarisasi garis K3 | Pembuatan jalur pejalan kaki (pedestrian route) dan batas line area produksi - gudang. | 0% | |||||||
| 47 | 42 | Not Started | Production | 3 | 0% | 0% | Medium | MOP-42 | Time & Motion Study (SKU Repack) | P2 Cost & Productivity | 0% | Standar cycle time & output tercapai | Evaluasi cycle time khusus produk repack, standarisasi target output, dan eliminasi waste waktu. | 0% | |||||||
| 48 | 43 | Not Started | Engineering | 3 | 0% | 0% | Medium | MOP-43 | Maintenance System Std. | P3 Digital & Data | 0% | 100% sinkronisasi data mesin | Standarisasi form laporan maintenance harian & kalibrasi sinkronisasi data mesin aktual vs sistem. | 0% | |||||||
| 49 | 44 | Not Started | R&D | 4 | 0% | 0% | Medium | MOP-44 | Sensory Expert & Lexicon Dev | P1 People & Culture | 0% | Lexicon terbentuk, 3 panelis tersertifikasi | Pelatihan expert panelist dan penyusunan sensory value lexicon / flavor language. | 0% | |||||||
| 50 | 45 | On Track | Production | 07/12/2026 | 5 | 0% | 0% | High | MOP-45 | 19/10/2026 | Container Box Plastic Management | 50 | P5 Supply Chain & Planning | 89% | Ardiansah Setiawan | Zero loss container box; 100% teridentifikasi, higienis & terdata | Standarisasi, pelabelan, alur sirkulasi (in/out antar plant & gudang), pencatatan stok, serta jadwal pencucian rutin container box plastik untuk mencegah kehilangan & kerusakan. | Persiapan Go-Live 87% (27/31 langkah selesai); Go-Live 2 Nov; sisa ±143 pcs belum tercatat & 293 temuan terbuka diselesaikan per kelompok | 87% |
Data mentah asli tersimpan apa adanya per pengambilan yang isinya berbeda (1 versi).