PT SERELIA PRIMA NUTRISIA — 100% Sinkron dengan Sheet MASTER Data Excel (November 2026)
Perbandingan: ■ November 2026 (Hijau) vs ■ Oktober 2026 (Biru Putus-Putus)
Perbandingan kanal: ■ Target | ■ Realisasi Berjalan | ■ Realisasi Bulan Lalu
| Channel | Target | Realisasi (MTD) | % Capaian | Realisasi Okt (MoM) | Deviasi |
|---|---|---|---|---|---|
| Kemitraan Eksklusif | Rp 135.000.000 | Rp 75.439.826 | 55.9% | Rp 116.825.728 | Rp 59.560.174 (Kurang) |
| Kemitraan Reguler | Rp 5.000.000 | Rp 52.914 | 1.1% | Rp 13.772.855 | Rp 4.947.086 (Kurang) |
| Repeat Order CRM | Rp 7.000.000 | Rp 5.989.000 | 85.6% | Rp 3.902.000 | Rp 1.011.000 (Kurang) |
| Akuisisi Ads (Leads) | Rp 1.500.000 | Rp 0 | 0.0% | Rp 95.000 | Rp 1.500.000 (Kurang) |
| TikTok & Tokopedia | Rp 440.000.000 | Rp 193.492.517 | 44.0% | Rp 341.952.277 | Rp 246.507.483 (Kurang) |
| Shopee | Rp 40.000.000 | Rp 13.505.635 | 33.8% | Rp 28.830.290 | Rp 26.494.365 (Kurang) |
| Nama / Sub-Channel | Target | Realisasi | % Capaian |
|---|---|---|---|
| Randy (Eksklusif) | Rp 105.000.000 | Rp 47.502.533 | 45.2% |
| Rohmad Isa (Eksklusif) | Rp 10.000.000 | Rp 516.900 | 5.2% |
| Rianita (Eksklusif) | Rp 10.000.000 | Rp 24.097.656 | 241.0% |
| Vero (Eksklusif) | Rp 5.000.000 | Rp 3.322.737 | 66.5% |
| Oriflakes Gaztro (RO CRM) | Rp 5.000.000 | Rp 5.989.000 | 119.8% |
| Oriflakes Slimmy (RO CRM) | Rp 2.000.000 | Rp 0 | 0.0% |
| Sahabat Lambung (TikTok) | Rp 15.000.000 | Rp 2.987.257 | 19.9% |
| Sereal Lambung (TikTok) | Rp 22.000.000 | Rp 7.371.360 | 33.5% |
| Oriflakes ID Official (TikTok) | Rp 3.000.000 | Rp 0 | 0.0% |
| Origoat (TikTok) | Rp 200.000.000 | Rp 84.196.044 | 42.1% |
| Origoat Kids (TikTok) | Rp 200.000.000 | Rp 98.759.856 | 49.4% |
| Oriflakes 150gr (Shopee) | Rp 5.000.000 | Rp 2.068.000 | 41.4% |
| Oriflakes 350gr (Shopee) | Rp 3.000.000 | Rp 290.597 | 9.7% |
| Origoat (Shopee) | Rp 10.000.000 | Rp 2.305.800 | 23.1% |
| Origoat Kids Serelia (Shopee) | Rp 20.000.000 | Rp 8.841.238 | 44.2% |
Kurva perbandingan: ■ Bulan Acuan/Berjalan vs ■ Bulan Sebelumnya (Garis Putus-Putus)
Perbandingan total 21 produk per minggu: ■ Bulan Berjalan vs ■ Bulan Sebelumnya
| No | Nama Produk & Varian | W1 | W2 | W3 | W4 | W5 | Total Qty | Rata2/Hari |
|---|---|---|---|---|---|---|---|---|
| 1 | Origoat - vanila 125g | 101 | 184 | 135 | 33 | 0 | 453 | 26,6 |
| 2 | Origoat - Jahe 125g | 262 | 409 | 484 | 116 | 0 | 1.271 | 74,8 |
| 3 | Origoat - Coklat 125g | 67 | 118 | 139 | 54 | 0 | 378 | 22,2 |
| 4 | Origoat - Plain 100g | 45 | 62 | 70 | 19 | 0 | 196 | 11,5 |
| 5 | Origoat Kids - Vanila Kids 125g | 26 | 309 | 274 | 79 | 0 | 688 | 40,5 |
| 6 | Origoat Kids - Coklat Kids 125g | 339 | 831 | 832 | 206 | 0 | 2.208 | 129,9 |
| 7 | Oriflakes Gaztro 150gr - Vanilla 150g | 26 | 62 | 36 | 15 | 0 | 139 | 8,2 |
| 8 | Oriflakes Gaztro 150gr - Jahe 150g | 11 | 33 | 14 | 0 | 0 | 58 | 3,4 |
| 9 | Oriflakes Gaztro 150gr - Coklat 150g | 17 | 48 | 24 | 2 | 0 | 91 | 5,4 |
| 10 | Oriflakes Original 150gr - Plain 150g | 12 | 11 | 27 | 1 | 0 | 51 | 3,0 |
| 11 | Oriflakes Original - WPS 350g | 32 | 44 | 73 | 29 | 0 | 178 | 10,5 |
| 12 | Oriflakes Original - WPS 900g | 38 | 48 | 75 | 8 | 0 | 169 | 9,9 |
| 13 | Oriflakes Original - Plain 350g | 17 | 49 | 99 | 30 | 0 | 195 | 11,5 |
| 14 | Oriflakes Slimy - Coklat 350g (NF) | 0 | 1 | 5 | 0 | 0 | 6 | 0,4 |
| 15 | Oriflakes Slimy - Green Tea 350g (NF) | 0 | 5 | 11 | 0 | 0 | 16 | 0,9 |
| 16 | Oriflakes Slimy - Vanilla 350g (NF) | 7 | 24 | 68 | 0 | 0 | 99 | 5,8 |
| 17 | Oriflakes Gaztro - Vanilla 350g | 75 | 117 | 134 | 48 | 0 | 374 | 22,0 |
| 18 | Oriflakes Gaztro - Vanilla 900g | 62 | 50 | 111 | 0 | 0 | 223 | 13,1 |
| 19 | Oriflakes Gaztro - Jahe 350g | 35 | 106 | 112 | 0 | 0 | 253 | 14,9 |
| 20 | Oriflakes Gaztro - Jahe 900g | 2 | 0 | 0 | 0 | 0 | 2 | 0,1 |
| 21 | Oriflakes Gaztro - Coklat 900g | 0 | 1 | 0 | 1 | 0 | 2 | 0,1 |
Warna batang menunjukkan kuadran: ■ Stars | ■ Cash Cows | ■ Question Marks | ■ Dogs. Garis putus-putus abu-abu adalah kurva persentase kumulatif volume (Sumbu Kanan).
| No | Nama Produk & Varian | Kategori Pareto | Bulan Sebelumnya (Qty) | Bulan Berjalan (Master Qty) | Selisih (MoM) | Forecast (Des) |
|---|---|---|---|---|---|---|
| 1 | Origoat Kids - Coklat Kids 125g | Stars | 3.693 | 2.208 | -1.485 (MTD) | 197 pcs (+60) |
| 2 | Origoat - Jahe 125g | Stars | 1.773 | 1.271 | -502 (MTD) | 126 pcs (+60) |
| 3 | Origoat Kids - Vanila Kids 125g | Cash Cows | 1.552 | 688 | -864 (MTD) | 87 pcs (+30) |
| 4 | Origoat - vanila 125g | Cash Cows | 622 | 453 | -169 (MTD) | 53 pcs (+30) |
| 5 | Origoat - Coklat 125g | Cash Cows | 589 | 378 | -211 (MTD) | 52 pcs (+30) |
| 6 | Oriflakes Gaztro - Jahe 350g | Cash Cows | 427 | 253 | -174 (MTD) | 46 pcs (+30) |
| 7 | Oriflakes Gaztro - Vanilla 350g | Question Marks | 424 | 374 | -50 (MTD) | 36 pcs (+20) |
| 8 | Oriflakes Original - Plain 350g | Question Marks | 325 | 195 | -130 (MTD) | 32 pcs (+20) |
| 9 | Origoat - Plain 100g | Question Marks | 304 | 196 | -108 (MTD) | 31 pcs (+20) |
| 10 | Oriflakes Gaztro - Vanilla 900g | Question Marks | 287 | 223 | -64 (MTD) | 31 pcs (+20) |
| 11 | Oriflakes Gaztro 150gr - Vanilla 150g | Question Marks | 270 | 139 | -131 (MTD) | 30 pcs (+20) |
| 12 | Oriflakes Original - WPS 350g | Question Marks | 248 | 178 | -70 (MTD) | 29 pcs (+20) |
| 13 | Oriflakes Gaztro 150gr - Coklat 150g | Question Marks | 174 | 91 | -83 (MTD) | 26 pcs (+20) |
| 14 | Oriflakes Original - WPS 900g | Dogs | 133 | 169 | +36 (Naik) | 10 pcs (+5) |
| 15 | Oriflakes Original 150gr - Plain 150g | Dogs | 104 | 51 | -53 (MTD) | 0 pcs (Stok Cukup) |
| 16 | Oriflakes Gaztro 150gr - Jahe 150g | Dogs | 92 | 58 | -34 (MTD) | 0 pcs (Stok Cukup) |
| 17 | Oriflakes Slimy - Vanilla 350g (NF) | Dogs | 77 | 99 | +22 (Naik) | 8 pcs (+5) |
| 18 | Oriflakes Gaztro - Jahe 900g | Dogs | 62 | 2 | -60 (MTD) | 0 pcs (Stok Cukup) |
| 19 | Oriflakes Slimy - Coklat 350g (NF) | Dogs | 55 | 6 | -49 (MTD) | 0 pcs (Stok Cukup) |
| 20 | Sampel Origoat - Jahe | Sampel | 34 | 0 | -34 (MTD) | 0 pcs |
| 21 | Oriflakes Gaztro - Coklat 900g | Dogs | 28 | 2 | -26 (MTD) | 0 pcs (Stok Cukup) |
| 22 | Sampel Origoat Kids - Cokelat | Sampel | 28 | 0 | -28 (MTD) | 0 pcs |
| 23 | Oriflakes Slimy - Green Tea 350g (NF) | Dogs | 24 | 16 | -8 (MTD) | 0 pcs (Stok Cukup) |
| 24 | Sampel Origoat - Vanila | Sampel | 17 | 0 | -17 (MTD) | 0 pcs |
| 25 | Sampel Oriflakes - Plain | Sampel | 10 | 2 | -8 (MTD) | 0 pcs |
| 26 | Sampel Oriflakes - Vanila | Sampel | 7 | 16 | +9 (Naik) | 0 pcs |
| 27 | Diameal - Diameal 20gr | Sampel | 5 | 0 | -5 (MTD) | 0 pcs |
| 28 | Sampel Oriflakes - Cokelat | Sampel | 5 | 0 | -5 (MTD) | 0 pcs |
| 29 | Sampel Oriflakes - Jahe | Sampel | 2 | 0 | -2 (MTD) | 0 pcs |
| 30 | Produk Kemasan Oriflakes 900gr - Plain | Sampel | 0 | 3 | +3 (Naik) | 0 pcs |