Chapter 5 Magic Number Simulation Draf transkrip automatik penuh. Pembetulan istilah berdasarkan sumber direkodkan secara berasingan; tanda semakan menunjukkan perkataan yang perlu diperiksa. [00:00:01–00:00:04] Simulation untuk Magic Number. [semak: uncertain words] [00:00:04–00:00:09] So, akhirnya guys, kita telah belajar semua sekali dan sekarang ni saya nak buat simulation. [00:00:09–00:00:12] Kita dah belajar tentang net profit. Jom kita tengok kat keyboard ni. [semak: uncertain words] [00:00:13–00:00:16] Net profit ni adalah untung bersih bulanan yang kita nak buat. [00:00:17–00:00:18] Kita dah belajar pasal benda ni. [00:00:18–00:00:22] Next pula, kita dah belajar pula tentang OPEX ni tadi. [semak: uncertain words] [00:00:23–00:00:26] OPEX kita dah belajar formula SOO, SOA. [semak: uncertain words] [00:00:26–00:00:27] Sosowa [semak: uncertain words] [00:00:27–00:00:28] Kita kena kira dulu [semak: uncertain words] [00:00:28–00:00:29] Cost operasi kita [semak: uncertain words] [00:00:29–00:00:30] Barulah kita boleh [00:00:30–00:00:31] Dapat jawapan [00:00:31–00:00:31] Kejap lagi [00:00:31–00:00:32] Next [00:00:32–00:00:33] Kita dah belajar pula [00:00:33–00:00:34] Tentang gross profit [00:00:34–00:00:36] Gross profit ni [00:00:36–00:00:37] Adalah bila awak [00:00:37–00:00:38] Tolak [00:00:38–00:00:40] Dengan COGS [00:00:41–00:00:41] COGS [00:00:41–00:00:43] COGS ni adalah apa [00:00:43–00:00:44] Cost of good soul ni [semak: uncertain words] [00:00:44–00:00:46] Nak kira nasi lemak [00:00:46–00:00:47] Punya cost per unit tadi [00:00:47–00:00:48] Kita dah belajar dah [00:00:48–00:00:50] Dan kita dah belajar pula [00:00:50–00:00:51] Tentang AOV [00:00:51–00:00:52] Haa sana tu [semak: uncertain words] [00:00:52–00:00:54] 3 whiteboard kita pakai [semak: uncertain words, number or amount] [00:00:54–00:00:56] Average order value [00:00:56–00:00:58] Maksudnya satu customer biasa beli berapa [semak: uncertain words] [00:00:58–00:01:01] Setelah awak dah faham segala ilmu [00:01:01–00:01:03] Teknikal bisnes ni, yang simple-simple ni guys [semak: uncertain words] [00:01:03–00:01:04] Saya nak buat simulation terus [00:01:04–00:01:06] So, jom kita tengok dekat sini [00:01:06–00:01:09] Kat TV ni, kita nak buat simulation [semak: uncertain words] [00:01:09–00:01:10] So, untuk buat simulation ni [00:01:10–00:01:13] Saya nak awak lukis kotak sama macam ni [semak: uncertain words] [00:01:13–00:01:15] Ambil satu kertas F4 [semak: number or amount] [00:01:16–00:01:17] Pusingkan dia macam ni [00:01:17–00:01:19] Lukis 1, 2, 3, 4 [semak: number or amount] [00:01:19–00:01:21] 5, 6, 7, 8 [semak: uncertain words, number or amount] [00:01:21–00:01:23] 9, 10 kotak [semak: uncertain words, number or amount] [00:01:23–00:01:25] Lukis atas [00:01:25–00:01:27] Ke bawah, so jom kita buat yang pertama [semak: uncertain words] [00:01:27–00:01:28] Sekali, ok, let's go [00:01:29–00:01:31] Yang pertama sekali, boleh fokus [00:01:31–00:01:32] Ke atas tu, ok [semak: uncertain words] [00:01:32–00:01:35] Kita nak tengok dulu, berapakah [00:01:35–00:01:37] Target net profit, so saya masukkan [00:01:37–00:01:39] Target net profit saya adalah 30k [semak: number or amount] [00:01:39–00:01:41] 30 ribu, macam yang saya kata tadi [semak: number or amount] [00:01:42–00:01:43] Berapakah cost opax kita [semak: uncertain words] [00:01:43–00:01:45] Tu, tengok sana, tengok sana balik tu [semak: uncertain words] [00:01:45–00:01:46] Berapa, pergi, go [00:01:47–00:01:48] Kamera zoom, 20 [semak: uncertain words, number or amount] [00:01:50–00:01:50] 28 ribu [semak: number or amount] [00:01:50–00:01:52] So, kita masukkan dekat sini [00:01:52–00:01:55] Based on kiraan yang kita dah belajar [semak: uncertain words] [00:01:55–00:01:56] RM28,000 [semak: uncertain words, number or amount] [00:01:56–00:01:58] Next pula [00:01:58–00:02:00] Macam mana nak tahu gross profit? [00:02:00–00:02:01] Senang sahaja guys [00:02:01–00:02:03] Gross profit ni adalah [00:02:03–00:02:06] Net profit campur dengan OPEX [00:02:06–00:02:07] Dapatlah gross profit [00:02:07–00:02:10] So tambah dua-dua dapat RM58,000 [semak: number or amount] [00:02:10–00:02:11] Saya pun tulis [00:02:11–00:02:13] RM58,000 [semak: number or amount] [00:02:13–00:02:15] Kenapa dapat RM58,000 pula? [semak: number or amount] [00:02:15–00:02:16] Cerita dia macam ni [00:02:16–00:02:19] Gross profit ni untung kasar [00:02:19–00:02:21] Kita cuba reverse balik [00:02:21–00:02:22] Untung kasar [00:02:22–00:02:23] Tolak dengan [00:02:23–00:02:24] Kos operasi [semak: uncertain words] [00:02:24–00:02:25] Dapat tak [00:02:25–00:02:25] RM30,000 [semak: number or amount] [00:02:25–00:02:26] Dapat lah [semak: uncertain words] [00:02:26–00:02:26] So betul lah [00:02:26–00:02:27] Ni RM58 [semak: uncertain words, number or amount] [00:02:27–00:02:28] RM58 [semak: uncertain words, number or amount] [00:02:28–00:02:29] Tolak dengan [00:02:29–00:02:31] Kos operasi kita [00:02:31–00:02:32] Kos overhead kita [00:02:32–00:02:33] RM28,000 [semak: number or amount] [00:02:33–00:02:34] Dapatlah RM30,000 [semak: number or amount] [00:02:34–00:02:35] Sebab tu lah [00:02:35–00:02:35] Tambah [00:02:35–00:02:36] Kita tengah reverse [semak: uncertain words] [00:02:36–00:02:37] Okay next pula [semak: uncertain words] [00:02:37–00:02:39] COGS percentage [00:02:39–00:02:40] Cuba tengok tadi [00:02:40–00:02:42] Kita punya nasi lemak tadi tu [00:02:42–00:02:43] Berapa persen [00:02:43–00:02:44] Cuba try [00:02:44–00:02:44] Go go go [semak: uncertain words] [00:02:44–00:02:45] Kamera [semak: uncertain words] [00:02:46–00:02:46] Yes [00:02:46–00:02:47] Berapa [00:02:47–00:02:48] Kita nak target berapa persen [00:02:48–00:02:50] 70 persen [semak: uncertain words, number or amount] [00:02:50–00:02:50] Betul tak [00:02:50–00:02:51] Sebab kita jual barang murah [00:02:51–00:02:53] Ni kalau awak jual barang murah [semak: uncertain words] [00:02:53–00:02:55] Kalau awak jual barang yang mahal sikit [00:02:55–00:02:56] Mungkin 50% [semak: number or amount] [00:02:56–00:02:56] That's why kat sini [semak: uncertain words] [00:02:56–00:02:58] Kita nak peratusan [00:02:58–00:03:01] Katalah saya masukkan 50% [semak: number or amount] [00:03:01–00:03:04] Katakanlah COGS percentage 50% [semak: number or amount] [00:03:04–00:03:05] Berapakah sale yang saya nak dapat [semak: uncertain words] [00:03:05–00:03:07] Berapakah sale yang saya nak dapat [00:03:07–00:03:08] Masa ke-send next saya kena darab 2 [semak: uncertain words, number or amount] [00:03:09–00:03:11] Jadi jom kita buka saya punya calculator [semak: uncertain words] [00:03:12–00:03:14] Sebab saya nak kena untung seganda [00:03:14–00:03:15] Untuk cover cost produk ni [semak: uncertain words] [00:03:15–00:03:17] So kita sebenarnya tengah reverse tuan-tuan [00:03:17–00:03:19] Tengok eh saya buat macam ni [semak: uncertain words] [00:03:19–00:03:22] RM58,000 darab 2 [semak: uncertain words, number or amount] [00:03:22–00:03:25] Saya kena buat RM166,000 sale [semak: uncertain words, number or amount] [00:03:25–00:03:26] Jom kita masukkan [00:03:26–00:03:31] Saya kena buat RM166,000 sale [semak: number or amount] [00:03:31–00:03:35] Tapi yang ni kalau saya punya [semak: uncertain words] [00:03:35–00:03:37] Persentis saya cantik 50% [semak: uncertain words, number or amount] [00:03:37–00:03:38] Itu senang je saya darab 2 [semak: uncertain words, number or amount] [00:03:38–00:03:40] Tapi cuba kalau persentis saya tak cantik [00:03:40–00:03:43] Ambil lah saya punya profit 30% je [semak: number or amount] [00:03:43–00:03:45] Macam mana nak kira [00:03:45–00:03:46] Jom kita duduk sini [00:03:48–00:03:49] Katakanlah [00:03:49–00:03:50] Saya punya [semak: uncertain words] [00:03:53–00:03:54] Gross profit saya [semak: uncertain words] [00:03:54–00:03:56] Persoalan dia berapa sale? [00:03:56–00:03:57] Tengok kat atas tu [00:03:57–00:03:59] Tengok kat atas tu [00:03:59–00:04:00] Saya buat tanda soal macam ni [semak: uncertain words] [00:04:00–00:04:01] Berapa sale? [00:04:02–00:04:02] Betul tak? [00:04:03–00:04:03] Kalau kita nak [00:04:03–00:04:05] Kita punya [00:04:06–00:04:07] Percentage kita 30% [semak: number or amount] [00:04:07–00:04:09] Kita nak dapat untung RM28,000 [semak: uncertain words, number or amount] [00:04:09–00:04:09] Berapa sale? [00:04:09–00:04:10] Formula dia macam ni [00:04:10–00:04:11] Tengok ya [semak: uncertain words] [00:04:11–00:04:12] RM [00:04:12–00:04:14] Gross profit [00:04:16–00:04:17] Nak dapatkan [00:04:17–00:04:18] Sale tu berapa? [00:04:19–00:04:39] So, sale equal, ni formula dia, gross profit bahagi 100% tolak COGS percentage. [semak: uncertain words, number or amount] [00:04:40–00:04:41] Dia tolak macam ni. [00:04:41–00:04:42] So, jom kita tengok kat atas tu. [00:04:43–00:04:44] Berapa COGS percentage? [00:04:44–00:04:45] Tutup kurangan. [00:04:45–00:04:48] So, maksudnya, berapa COGS percentage kat situ? [00:04:48–00:04:48] Kita tengok. [semak: uncertain words] [00:04:50–00:04:51] 30%. [semak: number or amount] [00:04:51–00:04:59] So, 100% kat sini, kita tolak dengan 30%, maka kita akan dapat 70%. [semak: number or amount] [00:04:59–00:05:01] Barulah kita bahagikan, nampak? [00:05:02–00:05:03] Barulah kita boleh bahagikan dengan gross profit. [00:05:04–00:05:06] Gross profit kita adalah RM58,000. [semak: number or amount] [00:05:07–00:05:12] So, equal RM58,000 bahagi dengan 70%. [semak: number or amount] [00:05:12–00:05:14] Sebab kita kena tolak dengan 100%. [semak: number or amount] [00:05:14–00:05:16] Sebab kita nak tahu itu. [semak: uncertain words] [00:05:16–00:05:17] Jom kita kira. [00:05:17–00:05:18] Tengok saya punya formula. [00:05:18–00:05:19] Senang je. [00:05:20–00:05:21] RM58,000 [semak: number or amount] [00:05:22–00:05:23] Bahagi [semak: uncertain words] [00:05:23–00:05:25] Dengan 70% [semak: number or amount] [00:05:25–00:05:26] Bukan 30% sebab [semak: number or amount] [00:05:26–00:05:28] 100 tolak 30 [semak: number or amount] [00:05:28–00:05:30] Bahagi dengan 70 [semak: number or amount] [00:05:30–00:05:32] Dan wajib letak peratus [semak: uncertain words] [00:05:32–00:05:34] Peratus ni kena letak, tekan peratus [00:05:34–00:05:36] Lepas tu tekan equal [00:05:36–00:05:38] Boom, nampak? Saya dapat RM82,000 [semak: number or amount] [00:05:38–00:05:40] Inilah jawapan dia, jom saya masukkan di situ [semak: uncertain words] [00:05:41–00:05:42] RM82,000 [semak: number or amount] [00:05:45–00:05:46] RM8,000 [semak: uncertain words, number or amount] [00:05:47–00:05:48] RM8,000 [semak: number or amount] [00:05:48–00:05:49] Saya bundarkan lah [semak: uncertain words] [00:05:49–00:05:49] Lepas ratus [semak: uncertain words] [00:05:49–00:05:50] Tengok [00:05:50–00:05:51] Betul ke tak betul [00:05:51–00:05:52] Saya kira sekali lagi [semak: uncertain words] [00:05:53–00:05:54] Lapan puluh [00:05:54–00:05:55] Dua ribu [semak: uncertain words] [00:05:55–00:05:56] Lepas ratus ni [00:05:56–00:05:56] Saya cuba [00:05:56–00:05:57] Darab [semak: uncertain words] [00:05:58–00:05:59] Saya cuba [00:05:59–00:06:00] Tolak dengan [00:06:00–00:06:00] Tiga puluh persen [00:06:00–00:06:01] Saya kira [00:06:01–00:06:02] Lapan ribu [00:06:02–00:06:03] Lepas puluh [00:06:03–00:06:03] Dua ribu [semak: uncertain words] [00:06:03–00:06:04] Lepas ratus [00:06:04–00:06:05] Saya tolak [00:06:05–00:06:06] Dengan [semak: uncertain words] [00:06:06–00:06:07] Tiga puluh persen [00:06:07–00:06:07] Kat sini [semak: uncertain words] [00:06:07–00:06:09] Dapat tak jawapan ni [00:06:09–00:06:09] Tolak dengan [00:06:09–00:06:10] Tiga puluh persen [00:06:10–00:06:11] Boom [00:06:11–00:06:12] Nampak dapat kan [semak: uncertain words] [00:06:12–00:06:13] Dekat-dekat dah tu [semak: uncertain words] [00:06:13–00:06:13] Sebab tadi ada [00:06:13–00:06:14] Poin-poin [semak: uncertain words] [00:06:14–00:06:15] Lima puluh lapan ribu [semak: uncertain words] [00:06:15–00:06:16] Lima puluh tujuh [00:06:16–00:06:16] Lima puluh [semak: uncertain words] [00:06:16–00:06:17] Lima puluh [semak: uncertain words] [00:06:17–00:06:17] Lima puluh [semak: uncertain words] [00:06:17–00:06:19] betul lah tu, so itulah cara kiraan dia [semak: uncertain words] [00:06:19–00:06:21] dan awak kena ingat, formula dia [00:06:21–00:06:22] kena bahagi tau [00:06:22–00:06:25] dia kena bahagi, bukan darab, dan bahagi ni [00:06:25–00:06:27] adalah 100 tolak COGS [semak: number or amount] [00:06:27–00:06:29] so macam awak punya [00:06:29–00:06:31] kat sini, kisah berapa persen pun [semak: uncertain words] [00:06:31–00:06:33] kira guna formula ni, awak dapat sale [00:06:33–00:06:34] ok next, AOV [00:06:35–00:06:37] AOV kita berapa? katalah saya ambil [00:06:37–00:06:39] anggaran kat sana, tadi kita lah kira kan [semak: uncertain words] [00:06:39–00:06:41] AOV kita, katalah AOV kita [00:06:42–00:06:43] RM127 [semak: number or amount] [00:06:43–00:06:44] jom lah, kita masukkan [semak: uncertain words] [00:06:44–00:06:47] RM127, maksudnya customer membeli [semak: number or amount] [00:06:47–00:06:47] Standard [semak: uncertain words] [00:06:48–00:06:49] RM127 [semak: number or amount] [00:06:49–00:06:51] Dia beli sekaligus [00:06:51–00:06:52] So [00:06:52–00:06:54] Kita dah masuk kat sini dah [semak: uncertain words] [00:06:54–00:06:56] Bila nak kira monthly customer [00:06:56–00:06:57] Senang sahaja guys [00:06:57–00:07:00] Sale bahagi AOV [00:07:00–00:07:01] Dapat monthly customer [00:07:01–00:07:04] Sale bahagi AOV [00:07:04–00:07:06] Dapat monthly customer [00:07:06–00:07:07] So jawapan dia macam ni [00:07:07–00:07:10] RM82,800 [semak: number or amount] [00:07:11–00:07:12] Bahagikan dengan [00:07:12–00:07:14] RM127 [semak: number or amount] [00:07:14–00:07:16] Dapat berapa? [00:07:17–00:07:19] 651 customer sebulan [semak: number or amount] [00:07:19–00:07:19] Saya kena ada [semak: uncertain words] [00:07:20–00:07:21] Itulah nak tahu [00:07:21–00:07:22] Berapa banyak customer sebulan [00:07:26–00:07:26] 651 [semak: number or amount] [00:07:27–00:07:28] Ha macam tu [semak: uncertain words] [00:07:28–00:07:31] So 651 orang [semak: number or amount] [00:07:31–00:07:32] Customer [00:07:32–00:07:33] Yang saya kena dapatkan [00:07:33–00:07:36] Sebab kalau awak try kira sekali lagi [semak: uncertain words] [00:07:36–00:07:36] Betul tak betul [00:07:38–00:07:38] 651 [semak: number or amount] [00:07:38–00:07:40] Darab dengan AOV [00:07:40–00:07:42] Darab dengan saya punya AOV [00:07:42–00:07:44] Darab dengan AOV saya 127 [semak: number or amount] [00:07:44–00:07:45] Ha dapat tau [semak: uncertain words] [00:07:45–00:07:46] Dapat? [00:07:46–00:07:47] RM82,000 [semak: number or amount] [00:07:47–00:07:48] Haa dekat-dekat lah tu [semak: uncertain words] [00:07:48–00:07:49] Sebab tu kalau awak tak percaya [00:07:49–00:07:50] Awak cuba reverse balik [semak: uncertain words] [00:07:50–00:07:52] Ok nak tahu weekly customer senang je [00:07:52–00:07:55] RM651 bahagi dengan 4 [semak: number or amount] [00:07:56–00:07:58] So saya kena buat seminggu sebanyak [00:07:58–00:07:59] RM162 [semak: number or amount] [00:07:59–00:08:00] RM163 [semak: number or amount] [00:08:00–00:08:02] So saya pun tulislah [00:08:03–00:08:04] RM163 orang [semak: number or amount] [00:08:04–00:08:06] Ok nak tahu pula [00:08:06–00:08:08] Daily customer pun sama juga [semak: uncertain words] [00:08:08–00:08:10] Daily customer ni [00:08:11–00:08:12] RM651 bahagi dengan [semak: number or amount] [00:08:12–00:08:13] RM30 [semak: number or amount] [00:08:13–00:08:14] Sebab ni 30 hari [semak: uncertain words, number or amount] [00:08:14–00:08:18] Yang ni 4 minggu, yang ni adalah 1 hari [semak: number or amount] [00:08:18–00:08:20] So bahagi dengan 30 [semak: uncertain words, number or amount] [00:08:20–00:08:23] Saya kena buat sehari 21 [semak: number or amount] [00:08:23–00:08:25] Ataupun saya kenapkan 22 orang [semak: number or amount] [00:08:25–00:08:28] Maksud sekarang ni guys, saya dah dapat satu jawapan [semak: uncertain words] [00:08:28–00:08:32] Setiap hari saya kena cari 22 orang sahaja [semak: number or amount] [00:08:32–00:08:35] Kalau saya dapat cari 22 orang [semak: number or amount] [00:08:35–00:08:38] Terkumpul selama 7 hari dapat 163 orang [semak: number or amount] [00:08:38–00:08:41] Terkumpul selama sebulan dapat 651 orang [semak: number or amount] [00:08:41–00:08:44] 651 orang membeli dengan average pembelian [semak: number or amount] [00:08:44–00:08:46] 127, saya dapat 182,800 [semak: uncertain words, number or amount] [00:08:46–00:08:47] dengan [semak: uncertain words] [00:08:47–00:08:50] saya punya cost product, hanya sebanyak [00:08:51–00:08:52] 30%, tolak [semak: number or amount] [00:08:52–00:08:54] cost product, saya dapat gross profit [00:08:54–00:08:55] 58,000, untung kasar [semak: number or amount] [00:08:55–00:08:58] untung kasar saya, saya tolak dengan [00:08:58–00:09:00] cost operasi saya, saya punya [00:09:01–00:09:02] office, apa bagaimana semua [semak: uncertain words] [00:09:02–00:09:04] saya dapatlah profit 30,000 [semak: uncertain words, number or amount] [00:09:04–00:09:06] macam, so nampak tak [semak: uncertain words] [00:09:06–00:09:08] ini adalah formula magic number [semak: uncertain words] [00:09:08–00:09:10] magic number ini [00:09:10–00:09:12] nak bagi awak satu clarity [00:09:12–00:09:15] Berapa banyak customer aku nak kena cari sehari [00:09:15–00:09:17] Berapa banyak customer aku nak kena cari seminggu [semak: uncertain words] [00:09:17–00:09:19] Berapa banyak customer aku nak kena cari sebulan [00:09:19–00:09:21] Dan kepala otak warna kena cari satu je [semak: uncertain words] [00:09:21–00:09:25] Dapat tak 22, dapat tak 22, dapat tak 22, dapat tak 22, dapat tak 22 [semak: number or amount] [00:09:25–00:09:27] Kalau tak dapat 22, maksud gagal [semak: number or amount] [00:09:27–00:09:29] So ini adalah magic number [semak: uncertain words] [00:09:29–00:09:31] Kiraan paling simple, walaupun nampak macam simple [00:09:31–00:09:33] Tapi dia tak semudah yang disangka [00:09:33–00:09:35] Sebab dia melibatkan OPEX [00:09:35–00:09:36] Cross Profit COGS [00:09:36–00:09:38] So ini adalah nombor dalam bisnes [semak: uncertain words] [00:09:38–00:09:40] Bila awak tahu segala nombor ni [00:09:40–00:09:42] Awak akan bergerak dengan halu tuju yang jelas [semak: uncertain words] [00:09:42–00:09:44] Kita jumpa dalam chapter terakhir [00:09:44–00:09:46] Seterusnya ni saya nak ajar tentang funnel [semak: uncertain words] [00:09:46–00:09:47] Lepas dah clear [00:09:47–00:09:50] Barulah awak kena pilih pula winning funnel mana yang awak nak main [semak: uncertain words] [00:09:50–00:09:52] Barulah cepat sikit kaya [00:09:52–00:09:54] Macam mana nak capai 22 customer sebulan [semak: number or amount] [00:09:54–00:09:55] Let's go