Chapter 5 Magic Number Simulation Source: https://coachadib.com/module/6ac03b9a16378f7eac1c3981 Automatic full-length draft. Uncertain wording and figures require review. [00:00:01.140 – 00:00:04.380] Simulation untuk Magic Number. [00:00:04.860 – 00:00:09.540] So, akhirnya guys, kita telah belajar semua sekali dan sekarang ni saya nak buat simulation. [00:00:09.900 – 00:00:12.760] Kita dah belajar tentang net profit. Jom kita tengok kat keyboard ni. [00:00:13.040 – 00:00:16.980] Net profit ni adalah untung bersih bulanan yang kita nak buat. [00:00:17.460 – 00:00:18.540] Kita dah belajar pasal benda ni. [00:00:18.980 – 00:00:22.540] Next pula, kita dah belajar pula tentang OPEX ni tadi. [00:00:23.040 – 00:00:26.300] OPEX kita dah belajar formula SOO, SOA. [00:00:26.300 – 00:00:27.060] Sosowa [00:00:27.060 – 00:00:28.600] Kita kena kira dulu [00:00:28.600 – 00:00:29.620] Cost operasi kita [00:00:29.620 – 00:00:30.580] Barulah kita boleh [00:00:30.580 – 00:00:31.320] Dapat jawapan [00:00:31.320 – 00:00:31.840] Kejap lagi [00:00:31.840 – 00:00:32.640] Next [00:00:32.640 – 00:00:33.700] Kita dah belajar pula [00:00:33.700 – 00:00:34.840] Tentang gross profit [00:00:34.840 – 00:00:36.400] Gross profit ni [00:00:36.400 – 00:00:37.800] Adalah bila awak [00:00:37.800 – 00:00:38.760] Tolak [00:00:38.760 – 00:00:40.340] Dengan COGS [00:00:41.240 – 00:00:41.840] COGS [00:00:41.840 – 00:00:43.080] COGS ni adalah apa [00:00:43.080 – 00:00:44.620] Cost of good soul ni [00:00:44.620 – 00:00:46.220] Nak kira nasi lemak [00:00:46.220 – 00:00:47.200] Punya cost per unit tadi [00:00:47.200 – 00:00:48.280] Kita dah belajar dah [00:00:48.280 – 00:00:50.180] Dan kita dah belajar pula [00:00:50.180 – 00:00:51.680] Tentang AOV [00:00:51.680 – 00:00:52.680] Haa sana tu [00:00:52.680 – 00:00:54.300] 3 whiteboard kita pakai [00:00:54.300 – 00:00:56.280] Average order value [00:00:56.280 – 00:00:58.640] Maksudnya satu customer biasa beli berapa [00:00:58.640 – 00:01:01.060] Setelah awak dah faham segala ilmu [00:01:01.060 – 00:01:03.020] Teknikal bisnes ni, yang simple-simple ni guys [00:01:03.020 – 00:01:04.620] Saya nak buat simulation terus [00:01:04.620 – 00:01:06.740] So, jom kita tengok dekat sini [00:01:06.740 – 00:01:09.020] Kat TV ni, kita nak buat simulation [00:01:09.020 – 00:01:10.780] So, untuk buat simulation ni [00:01:10.780 – 00:01:13.460] Saya nak awak lukis kotak sama macam ni [00:01:13.460 – 00:01:15.100] Ambil satu kertas F4 [00:01:16.260 – 00:01:17.420] Pusingkan dia macam ni [00:01:17.420 – 00:01:19.720] Lukis 1, 2, 3, 4 [00:01:19.720 – 00:01:21.480] 5, 6, 7, 8 [00:01:21.480 – 00:01:23.180] 9, 10 kotak [00:01:23.940 – 00:01:25.060] Lukis atas [00:01:25.060 – 00:01:27.340] Ke bawah, so jom kita buat yang pertama [00:01:27.340 – 00:01:28.920] Sekali, ok, let's go [00:01:29.560 – 00:01:31.380] Yang pertama sekali, boleh fokus [00:01:31.380 – 00:01:32.440] Ke atas tu, ok [00:01:32.980 – 00:01:35.180] Kita nak tengok dulu, berapakah [00:01:35.180 – 00:01:37.240] Target net profit, so saya masukkan [00:01:37.240 – 00:01:39.180] Target net profit saya adalah 30k [00:01:39.180 – 00:01:41.520] 30 ribu, macam yang saya kata tadi [00:01:42.120 – 00:01:43.440] Berapakah cost opax kita [00:01:43.440 – 00:01:45.420] Tu, tengok sana, tengok sana balik tu [00:01:45.420 – 00:01:46.460] Berapa, pergi, go [00:01:47.100 – 00:01:48.400] Kamera zoom, 20 [00:01:50.020 – 00:01:50.980] 28 ribu [00:01:50.980 – 00:01:52.960] So, kita masukkan dekat sini [00:01:52.960 – 00:01:55.060] Based on kiraan yang kita dah belajar [00:01:55.060 – 00:01:56.960] RM28,000 [00:01:56.960 – 00:01:58.220] Next pula [00:01:58.220 – 00:02:00.180] Macam mana nak tahu gross profit? [00:02:00.300 – 00:02:01.160] Senang sahaja guys [00:02:01.160 – 00:02:03.000] Gross profit ni adalah [00:02:03.000 – 00:02:06.200] Net profit campur dengan OPEX [00:02:06.200 – 00:02:07.540] Dapatlah gross profit [00:02:07.540 – 00:02:10.640] So tambah dua-dua dapat RM58,000 [00:02:10.640 – 00:02:11.640] Saya pun tulis [00:02:11.640 – 00:02:13.080] RM58,000 [00:02:13.080 – 00:02:15.200] Kenapa dapat RM58,000 pula? [00:02:15.400 – 00:02:16.140] Cerita dia macam ni [00:02:16.140 – 00:02:19.040] Gross profit ni untung kasar [00:02:19.040 – 00:02:21.060] Kita cuba reverse balik [00:02:21.060 – 00:02:22.220] Untung kasar [00:02:22.220 – 00:02:23.360] Tolak dengan [00:02:23.360 – 00:02:24.300] Kos operasi [00:02:24.300 – 00:02:25.240] Dapat tak [00:02:25.240 – 00:02:25.820] RM30,000 [00:02:25.820 – 00:02:26.420] Dapat lah [00:02:26.420 – 00:02:26.960] So betul lah [00:02:26.960 – 00:02:27.500] Ni RM58 [00:02:27.500 – 00:02:28.560] RM58 [00:02:28.560 – 00:02:29.540] Tolak dengan [00:02:29.540 – 00:02:31.100] Kos operasi kita [00:02:31.100 – 00:02:32.400] Kos overhead kita [00:02:32.400 – 00:02:33.140] RM28,000 [00:02:33.140 – 00:02:34.440] Dapatlah RM30,000 [00:02:34.440 – 00:02:35.060] Sebab tu lah [00:02:35.060 – 00:02:35.520] Tambah [00:02:35.520 – 00:02:36.260] Kita tengah reverse [00:02:36.260 – 00:02:37.500] Okay next pula [00:02:37.500 – 00:02:39.060] COGS percentage [00:02:39.060 – 00:02:40.440] Cuba tengok tadi [00:02:40.440 – 00:02:42.140] Kita punya nasi lemak tadi tu [00:02:42.140 – 00:02:43.240] Berapa persen [00:02:43.240 – 00:02:44.260] Cuba try [00:02:44.260 – 00:02:44.840] Go go go [00:02:44.840 – 00:02:45.360] Kamera [00:02:46.220 – 00:02:46.840] Yes [00:02:46.840 – 00:02:47.400] Berapa [00:02:47.400 – 00:02:48.980] Kita nak target berapa persen [00:02:48.980 – 00:02:50.100] 70 persen [00:02:50.100 – 00:02:50.480] Betul tak [00:02:50.480 – 00:02:51.840] Sebab kita jual barang murah [00:02:51.840 – 00:02:53.360] Ni kalau awak jual barang murah [00:02:53.360 – 00:02:55.120] Kalau awak jual barang yang mahal sikit [00:02:55.120 – 00:02:56.100] Mungkin 50% [00:02:56.100 – 00:02:56.840] That's why kat sini [00:02:56.840 – 00:02:58.820] Kita nak peratusan [00:02:58.820 – 00:03:01.500] Katalah saya masukkan 50% [00:03:01.500 – 00:03:04.340] Katakanlah COGS percentage 50% [00:03:04.340 – 00:03:05.980] Berapakah sale yang saya nak dapat [00:03:05.980 – 00:03:07.500] Berapakah sale yang saya nak dapat [00:03:07.500 – 00:03:08.820] Masa ke-send next saya kena darab 2 [00:03:09.460 – 00:03:11.520] Jadi jom kita buka saya punya calculator [00:03:12.100 – 00:03:14.220] Sebab saya nak kena untung seganda [00:03:14.220 – 00:03:15.760] Untuk cover cost produk ni [00:03:15.760 – 00:03:17.780] So kita sebenarnya tengah reverse tuan-tuan [00:03:17.780 – 00:03:19.720] Tengok eh saya buat macam ni [00:03:19.720 – 00:03:22.240] RM58,000 darab 2 [00:03:22.240 – 00:03:25.800] Saya kena buat RM166,000 sale [00:03:25.800 – 00:03:26.940] Jom kita masukkan [00:03:26.940 – 00:03:31.720] Saya kena buat RM166,000 sale [00:03:31.720 – 00:03:35.040] Tapi yang ni kalau saya punya [00:03:35.940 – 00:03:37.620] Persentis saya cantik 50% [00:03:37.620 – 00:03:38.800] Itu senang je saya darab 2 [00:03:38.800 – 00:03:40.800] Tapi cuba kalau persentis saya tak cantik [00:03:40.800 – 00:03:43.300] Ambil lah saya punya profit 30% je [00:03:43.300 – 00:03:45.020] Macam mana nak kira [00:03:45.020 – 00:03:46.740] Jom kita duduk sini [00:03:48.800 – 00:03:49.460] Katakanlah [00:03:49.460 – 00:03:50.960] Saya punya [00:03:53.040 – 00:03:54.340] Gross profit saya [00:03:54.340 – 00:03:56.000] Persoalan dia berapa sale? [00:03:56.200 – 00:03:57.220] Tengok kat atas tu [00:03:57.880 – 00:03:59.180] Tengok kat atas tu [00:03:59.180 – 00:04:00.280] Saya buat tanda soal macam ni [00:04:00.820 – 00:04:01.660] Berapa sale? [00:04:02.200 – 00:04:02.540] Betul tak? [00:04:03.080 – 00:04:03.940] Kalau kita nak [00:04:03.940 – 00:04:05.260] Kita punya [00:04:06.160 – 00:04:07.480] Percentage kita 30% [00:04:07.480 – 00:04:09.020] Kita nak dapat untung RM28,000 [00:04:09.020 – 00:04:09.860] Berapa sale? [00:04:09.960 – 00:04:10.660] Formula dia macam ni [00:04:10.660 – 00:04:11.840] Tengok ya [00:04:11.840 – 00:04:12.800] RM [00:04:12.800 – 00:04:14.260] Gross profit [00:04:16.220 – 00:04:17.340] Nak dapatkan [00:04:17.340 – 00:04:18.780] Sale tu berapa? [00:04:19.460 – 00:04:39.540] So, sale equal, ni formula dia, gross profit bahagi 100% tolak COGS percentage. [00:04:40.160 – 00:04:41.060] Dia tolak macam ni. [00:04:41.720 – 00:04:42.860] So, jom kita tengok kat atas tu. [00:04:43.040 – 00:04:44.220] Berapa COGS percentage? [00:04:44.580 – 00:04:45.320] Tutup kurangan. [00:04:45.760 – 00:04:48.560] So, maksudnya, berapa COGS percentage kat situ? [00:04:48.680 – 00:04:48.980] Kita tengok. [00:04:50.500 – 00:04:51.140] 30%. [00:04:51.140 – 00:04:59.460] So, 100% kat sini, kita tolak dengan 30%, maka kita akan dapat 70%. [00:04:59.460 – 00:05:01.940] Barulah kita bahagikan, nampak? [00:05:02.080 – 00:05:03.840] Barulah kita boleh bahagikan dengan gross profit. [00:05:04.120 – 00:05:06.540] Gross profit kita adalah RM58,000. [00:05:07.420 – 00:05:12.960] So, equal RM58,000 bahagi dengan 70%. [00:05:12.960 – 00:05:14.780] Sebab kita kena tolak dengan 100%. [00:05:14.780 – 00:05:16.300] Sebab kita nak tahu itu. [00:05:16.480 – 00:05:17.180] Jom kita kira. [00:05:17.460 – 00:05:18.520] Tengok saya punya formula. [00:05:18.740 – 00:05:19.120] Senang je. [00:05:20.600 – 00:05:21.760] RM58,000 [00:05:22.820 – 00:05:23.540] Bahagi [00:05:23.540 – 00:05:25.420] Dengan 70% [00:05:25.420 – 00:05:26.660] Bukan 30% sebab [00:05:26.660 – 00:05:28.180] 100 tolak 30 [00:05:28.180 – 00:05:30.260] Bahagi dengan 70 [00:05:30.260 – 00:05:32.320] Dan wajib letak peratus [00:05:32.320 – 00:05:34.500] Peratus ni kena letak, tekan peratus [00:05:34.500 – 00:05:36.380] Lepas tu tekan equal [00:05:36.380 – 00:05:38.800] Boom, nampak? Saya dapat RM82,000 [00:05:38.800 – 00:05:40.620] Inilah jawapan dia, jom saya masukkan di situ [00:05:41.500 – 00:05:42.800] RM82,000 [00:05:45.160 – 00:05:46.240] RM8,000 [00:05:47.040 – 00:05:48.100] RM8,000 [00:05:48.100 – 00:05:49.080] Saya bundarkan lah [00:05:49.080 – 00:05:49.680] Lepas ratus [00:05:49.680 – 00:05:50.600] Tengok [00:05:50.600 – 00:05:51.820] Betul ke tak betul [00:05:51.820 – 00:05:52.620] Saya kira sekali lagi [00:05:53.720 – 00:05:54.820] Lapan puluh [00:05:54.820 – 00:05:55.260] Dua ribu [00:05:55.260 – 00:05:56.020] Lepas ratus ni [00:05:56.020 – 00:05:56.900] Saya cuba [00:05:56.900 – 00:05:57.520] Darab [00:05:58.180 – 00:05:59.180] Saya cuba [00:05:59.180 – 00:06:00.160] Tolak dengan [00:06:00.160 – 00:06:00.980] Tiga puluh persen [00:06:00.980 – 00:06:01.580] Saya kira [00:06:01.580 – 00:06:02.540] Lapan ribu [00:06:02.540 – 00:06:03.520] Lepas puluh [00:06:03.520 – 00:06:03.760] Dua ribu [00:06:03.760 – 00:06:04.440] Lepas ratus [00:06:04.440 – 00:06:05.820] Saya tolak [00:06:05.820 – 00:06:06.180] Dengan [00:06:06.180 – 00:06:07.200] Tiga puluh persen [00:06:07.200 – 00:06:07.540] Kat sini [00:06:07.540 – 00:06:09.080] Dapat tak jawapan ni [00:06:09.080 – 00:06:09.660] Tolak dengan [00:06:09.660 – 00:06:10.420] Tiga puluh persen [00:06:10.420 – 00:06:11.180] Boom [00:06:11.180 – 00:06:12.300] Nampak dapat kan [00:06:12.300 – 00:06:13.240] Dekat-dekat dah tu [00:06:13.240 – 00:06:13.720] Sebab tadi ada [00:06:13.720 – 00:06:14.180] Poin-poin [00:06:14.180 – 00:06:15.080] Lima puluh lapan ribu [00:06:15.080 – 00:06:16.140] Lima puluh tujuh [00:06:16.140 – 00:06:16.980] Lima puluh [00:06:16.980 – 00:06:17.040] Lima puluh [00:06:17.040 – 00:06:17.460] Lima puluh [00:06:17.460 – 00:06:19.200] betul lah tu, so itulah cara kiraan dia [00:06:19.200 – 00:06:21.420] dan awak kena ingat, formula dia [00:06:21.420 – 00:06:22.340] kena bahagi tau [00:06:22.940 – 00:06:25.540] dia kena bahagi, bukan darab, dan bahagi ni [00:06:25.540 – 00:06:27.380] adalah 100 tolak COGS [00:06:27.380 – 00:06:29.280] so macam awak punya [00:06:29.280 – 00:06:31.560] kat sini, kisah berapa persen pun [00:06:31.560 – 00:06:33.040] kira guna formula ni, awak dapat sale [00:06:33.040 – 00:06:34.460] ok next, AOV [00:06:35.220 – 00:06:37.400] AOV kita berapa? katalah saya ambil [00:06:37.400 – 00:06:39.680] anggaran kat sana, tadi kita lah kira kan [00:06:39.680 – 00:06:41.360] AOV kita, katalah AOV kita [00:06:42.960 – 00:06:43.480] RM127 [00:06:43.480 – 00:06:44.880] jom lah, kita masukkan [00:06:44.880 – 00:06:47.180] RM127, maksudnya customer membeli [00:06:47.180 – 00:06:47.620] Standard [00:06:48.960 – 00:06:49.840] RM127 [00:06:49.840 – 00:06:51.920] Dia beli sekaligus [00:06:51.920 – 00:06:52.840] So [00:06:52.840 – 00:06:54.300] Kita dah masuk kat sini dah [00:06:54.300 – 00:06:56.300] Bila nak kira monthly customer [00:06:56.300 – 00:06:57.600] Senang sahaja guys [00:06:57.600 – 00:07:00.340] Sale bahagi AOV [00:07:00.340 – 00:07:01.940] Dapat monthly customer [00:07:01.940 – 00:07:04.160] Sale bahagi AOV [00:07:04.160 – 00:07:06.000] Dapat monthly customer [00:07:06.000 – 00:07:07.420] So jawapan dia macam ni [00:07:07.420 – 00:07:10.080] RM82,800 [00:07:11.380 – 00:07:12.580] Bahagikan dengan [00:07:12.580 – 00:07:14.280] RM127 [00:07:14.280 – 00:07:16.000] Dapat berapa? [00:07:17.160 – 00:07:19.160] 651 customer sebulan [00:07:19.160 – 00:07:19.760] Saya kena ada [00:07:20.360 – 00:07:21.260] Itulah nak tahu [00:07:21.260 – 00:07:22.280] Berapa banyak customer sebulan [00:07:26.060 – 00:07:26.640] 651 [00:07:27.820 – 00:07:28.880] Ha macam tu [00:07:28.880 – 00:07:31.440] So 651 orang [00:07:31.440 – 00:07:32.480] Customer [00:07:32.480 – 00:07:33.800] Yang saya kena dapatkan [00:07:33.800 – 00:07:36.060] Sebab kalau awak try kira sekali lagi [00:07:36.060 – 00:07:36.780] Betul tak betul [00:07:38.120 – 00:07:38.700] 651 [00:07:38.700 – 00:07:40.360] Darab dengan AOV [00:07:40.360 – 00:07:42.220] Darab dengan saya punya AOV [00:07:42.220 – 00:07:44.500] Darab dengan AOV saya 127 [00:07:44.500 – 00:07:45.880] Ha dapat tau [00:07:45.880 – 00:07:46.280] Dapat? [00:07:46.460 – 00:07:47.460] RM82,000 [00:07:47.460 – 00:07:48.240] Haa dekat-dekat lah tu [00:07:48.240 – 00:07:49.820] Sebab tu kalau awak tak percaya [00:07:49.820 – 00:07:50.940] Awak cuba reverse balik [00:07:50.940 – 00:07:52.820] Ok nak tahu weekly customer senang je [00:07:52.820 – 00:07:55.460] RM651 bahagi dengan 4 [00:07:56.260 – 00:07:58.480] So saya kena buat seminggu sebanyak [00:07:58.480 – 00:07:59.640] RM162 [00:07:59.640 – 00:08:00.740] RM163 [00:08:00.740 – 00:08:02.420] So saya pun tulislah [00:08:03.640 – 00:08:04.920] RM163 orang [00:08:04.920 – 00:08:06.900] Ok nak tahu pula [00:08:06.900 – 00:08:08.640] Daily customer pun sama juga [00:08:08.640 – 00:08:10.080] Daily customer ni [00:08:11.340 – 00:08:12.860] RM651 bahagi dengan [00:08:12.860 – 00:08:13.380] RM30 [00:08:13.380 – 00:08:14.900] Sebab ni 30 hari [00:08:14.900 – 00:08:18.720] Yang ni 4 minggu, yang ni adalah 1 hari [00:08:18.720 – 00:08:20.800] So bahagi dengan 30 [00:08:20.800 – 00:08:23.360] Saya kena buat sehari 21 [00:08:23.360 – 00:08:25.440] Ataupun saya kenapkan 22 orang [00:08:25.440 – 00:08:28.020] Maksud sekarang ni guys, saya dah dapat satu jawapan [00:08:28.020 – 00:08:32.780] Setiap hari saya kena cari 22 orang sahaja [00:08:32.780 – 00:08:35.020] Kalau saya dapat cari 22 orang [00:08:35.020 – 00:08:38.260] Terkumpul selama 7 hari dapat 163 orang [00:08:38.260 – 00:08:41.080] Terkumpul selama sebulan dapat 651 orang [00:08:41.080 – 00:08:44.440] 651 orang membeli dengan average pembelian [00:08:44.440 – 00:08:46.800] 127, saya dapat 182,800 [00:08:46.800 – 00:08:47.960] dengan [00:08:47.960 – 00:08:50.460] saya punya cost product, hanya sebanyak [00:08:51.400 – 00:08:52.680] 30%, tolak [00:08:52.680 – 00:08:54.360] cost product, saya dapat gross profit [00:08:54.360 – 00:08:55.640] 58,000, untung kasar [00:08:55.640 – 00:08:58.280] untung kasar saya, saya tolak dengan [00:08:58.280 – 00:09:00.380] cost operasi saya, saya punya [00:09:01.200 – 00:09:02.600] office, apa bagaimana semua [00:09:02.600 – 00:09:04.200] saya dapatlah profit 30,000 [00:09:04.200 – 00:09:06.700] macam, so nampak tak [00:09:06.700 – 00:09:08.880] ini adalah formula magic number [00:09:08.880 – 00:09:10.240] magic number ini [00:09:10.240 – 00:09:12.100] nak bagi awak satu clarity [00:09:12.100 – 00:09:15.000] Berapa banyak customer aku nak kena cari sehari [00:09:15.000 – 00:09:17.240] Berapa banyak customer aku nak kena cari seminggu [00:09:17.240 – 00:09:19.160] Berapa banyak customer aku nak kena cari sebulan [00:09:19.160 – 00:09:21.500] Dan kepala otak warna kena cari satu je [00:09:21.500 – 00:09:25.120] Dapat tak 22, dapat tak 22, dapat tak 22, dapat tak 22, dapat tak 22 [00:09:25.120 – 00:09:27.040] Kalau tak dapat 22, maksud gagal [00:09:27.040 – 00:09:29.340] So ini adalah magic number [00:09:29.340 – 00:09:31.840] Kiraan paling simple, walaupun nampak macam simple [00:09:31.840 – 00:09:33.680] Tapi dia tak semudah yang disangka [00:09:33.680 – 00:09:35.140] Sebab dia melibatkan OPEX [00:09:35.140 – 00:09:36.720] Cross Profit COGS [00:09:36.720 – 00:09:38.380] So ini adalah nombor dalam bisnes [00:09:38.380 – 00:09:40.340] Bila awak tahu segala nombor ni [00:09:40.340 – 00:09:42.700] Awak akan bergerak dengan halu tuju yang jelas [00:09:42.700 – 00:09:44.660] Kita jumpa dalam chapter terakhir [00:09:44.660 – 00:09:46.580] Seterusnya ni saya nak ajar tentang funnel [00:09:46.580 – 00:09:47.840] Lepas dah clear [00:09:47.840 – 00:09:50.920] Barulah awak kena pilih pula winning funnel mana yang awak nak main [00:09:50.920 – 00:09:52.340] Barulah cepat sikit kaya [00:09:52.340 – 00:09:54.560] Macam mana nak capai 22 customer sebulan [00:09:54.560 – 00:09:55.420] Let's go