Financial Projection Restoran
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Financial Projection Restoran as PDF for free.
More details
- Words: 2,514
- Pages: 4
RESTORAN MASAKAN KAMPUNG UNJURAN ALIRAN TUNAI BAGI TEMPOH OGOS 2007 - JULAI 2008 Ogo. 2009 Sep. 2009 Okt. 2009 Nov. 2009 Dis. 2009 Jan. 2010 Feb. 2010 Mac. 2010 Apr. 2010 Mei 2010 Jun. 2010 Jul. 2010 (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) TUNAI MASUK Jualan Tunai Penerimaan Dari Penghutang Modal Pemilik Pinjaman JUMLAH TUNAI MASUK TUNAI KELUAR Belian Stok Bayaran Kepada Pembekal Kos Langsung - Pekerja - Gaji Pekerja Langsung - KWSP - PERKESO Jumlah
40,000 -
45,000 -
40,000
45,000 -
45,000
50,000 -
45,000
50,000 -
50,000
50,000 -
50,000
55,000 -
50,000
55,000 -
55,000
60,000 -
55,000
60,000 -
60,000
70,000 -
60,000
70,000 -
70,000
Jumlah (RM) 650,000 -
70,000
650,000
12,000 -
13,500 -
13,500 -
15,000 -
15,000 -
15,000 -
16,500 -
16,500 -
18,000 -
18,000 -
21,000 -
21,000 -
195,000 -
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
112,800 14,664 624 128,088
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
1,200 1,200 2,400
Aktiviti Operasi & Pentadbiran - Elektrik & Air - Percetakan & Alatulis - Sewa Premis - Gaji Pengurus - KWSP - SOCSO - Caj Telefon - Keraian Pekerja - Pengangkutan - Penyelenggaraan Premis - Yuran Perakaunan - Kontinjensi Jumlah
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,000 2,500 325 15 200 100 300 100 100 500 6,490
300 50 2,000 2,500 325 15 200 100 300 100 100 500 6,490
300 50 2,000 2,500 325 15 200 100 300 100 100 500 6,490
300 50 2,000 2,500 325 15 200 100 300 100 100 500 6,490
3,600 600 28,000 30,000 3,900 177 2,400 1,200 3,600 1,200 1,200 6,000 81,877
Aktiviti Kewangan - Caj PROSPER - Bayaran Pokok PROSPER Jumlah
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
3,600 12,857 16,457
-
-
-
-
-
-
-
-
-
-
-
14,111 3,618
14,111 3,618
31,235 8,765 87,995 96,760
32,735 12,265 96,760 109,025
32,735 12,265 109,025 121,290
34,235 15,765 121,290 137,054
34,235 15,765 137,054 152,819
34,235 15,765 152,819 168,584
35,735 19,265 168,584 187,849
35,735 19,265 187,849 207,114
36,735 23,265 207,114 230,379
36,735 23,265 230,379 253,643
39,735 30,265 253,643 283,908
57,464 12,536 283,908 296,444
441,551 208,449 87,995 296,444
Aktiviti Pemasaran - Pengiklanan - Promosi Jumlah
Pembayaran Cukai Pembayaran Zakat JUMLAH TUNAI KELUAR LEBIHAN/(KURANGAN) TUNAI TUNAI BAWA KE HADAPAN TUNAI HANTAR KE HADAPAN
-
RESTORAN MASAKAN KAMPUNG UNJURAN UNTUNG RUGI BAGI TEMPOH BERAKHIR OGOS 2009 - JULAI 2010 Ogo. 2009 Sep. 2009 Okt. 2009 Nov. 2009 Dis. 2009 Jan. 2010 Feb. 2010 Mac. 2010 Apr. 2010 Mei 2010 Jun. 2010 Jul. 2010 (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) 40,000 45,000 45,000 50,000 50,000 50,000 55,000 55,000 60,000 60,000 70,000 70,000
JUALAN TOLAK
KOS JUALAN Kos Bahan Mentah Stok Awal (+) Belian (-) Stok Akhir Kos Langsung - Pekerja - Gaji Pekerja Langsung - KWSP - PERKESO
JUMLAH KOS JUALAN UNTUNG KASAR Marjin Untung Kasar TOLAK
PERBELANJAAN Belanja Pemasaran - Pengiklanan - Promosi Jumlah Belanja Pemasaran Belanja Operasi & Pentadbiran - Elektrik & Air - Percetakan & Alatulis - Sewa Premis - Gaji Pengurus - KWSP - SOSCO - Caj Telefon - Keraian Pekerja - Pengangkutan - Penyelenggaraan Premis - Susutnilai Harta Tetap - Yuran Perakaunan - Kontinjensi Jumlah Belanja Operasi & Pentadbiran Belanja Kewangan - Caj PROSPER Jumlah Belanja Kewangan
JUMLAH PERBELANJAAN UNTUNG BERSIH SEBELUM CUKAI & ZAKAT TOLAK CUKAI ZAKAT UNTUNG BERSIH SELEPAS CUKAI & ZAKAT KEUNTUNGAN TERKUMPUL BAWA BAWAH KEUNTUNGAN TERKUMPUL BAWA HADAPAN
Jumlah (RM) 650,000
1,000 12,000 1,000 12,000
1,000 13,500 1,000 13,500
1,000 13,500 1,000 13,500
1,000 15,000 1,000 15,000
1,000 15,000 1,000 15,000
1,000 15,000 1,000 15,000
1,000 16,500 1,000 16,500
1,000 16,500 1,000 16,500
1,000 18,000 1,000 18,000
1,000 18,000 1,000 18,000
1,000 21,000 1,000 21,000
1,000 21,000 1,000 21,000
1,000 195,000 1,000 195,000
9,400 1,222 52 10,674 22,674 17,326 43%
9,400 1,222 52 10,674 24,174 20,826 46%
9,400 1,222 52 10,674 24,174 20,826 46%
9,400 1,222 52 10,674 25,674 24,326 49%
9,400 1,222 52 10,674 25,674 24,326 49%
9,400 1,222 52 10,674 25,674 24,326 49%
9,400 1,222 52 10,674 27,174 27,826 51%
9,400 1,222 52 10,674 27,174 27,826 51%
9,400 1,222 52 10,674 28,674 31,326 52%
9,400 1,222 52 10,674 28,674 31,326 52%
9,400 1,222 52 10,674 31,674 38,326 55%
9,400 1,222 52 10,674 31,674 38,326 55%
112,800 14,664 624 128,088 323,088 326,912 50%
100 200
200
200
200
200
200
200
200
200
200
200
200
1,200 1,200 2,400
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,000 2,500 325 15 200 100 300 100 7,860 100 500 14,350
300 50 2,000 2,500 325 15 200 100 300 100 7,860 100 500 14,350
300 50 2,000 2,500 325 15 200 100 300 100 7,860 100 500 14,350
300 50 2,000 2,500 325 15 200 100 300 100 7,860 100 500 14,350
3,600 600 28,000 30,000 3,900 177 2,400 1,200 3,600 1,200 94,320 1,200 6,000 176,197
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
3,600 3,600
15,350
15,350
15,350
15,350
15,350
15,350
15,350
15,350
14,850
14,850
14,850
14,850
182,197
1,976 1,976 (46,682) (44,706)
5,476 5,476 (44,706) (39,230)
5,476 5,476 (39,230) (33,753)
8,976 8,976 (33,753) (24,777)
8,976 8,976 (24,777) (15,801)
8,976 8,976 (15,801) (6,825)
12,476 12,476 (6,825) 5,652
12,476 12,476 5,652 18,128
16,476 16,476 18,128 34,604
16,476 16,476 34,604 51,081
23,476 23,476 51,081 74,557
23,476 14,111 3,618 5,748 74,557 80,305
144,715 14,111 3,618 126,987 (46,682) 80,305
100
100 100
100 100
100 100
100 100
100 100
100 100
100 100
100 100
100 100
100 100
100 100
Page 2
RESTORAN MASAKAN KAMPUNG UNJURAN UNTUNG RUGI BAGI TEMPOH OGOS 2008 - JULAI 2009 Ogo. 2008 Sep. 2008 Okt. 2008 Nov. 2008 Dis. 2008 Jan. 2009 Feb. 2009 Mac. 2009 Apr. 2009 Mei 2009 Jun. 2009 (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) 20,000 25,000 25,000 30,000 30,000 30,000 35,000 35,000 35,000 38,000 38,000
JUALAN TOLAK
KOS JUALAN Kos Bahan Mentah Stok Awal (+) Belian (-) Stok Akhir Kos Langsung - Pekerja - Gaji Pekerja Langsung - KWSP - PERKESO
JUMLAH KOS JUALAN UNTUNG KASAR Marjin Untung Kasar TOLAK
PERBELANJAAN Belanja Pemasaran - Pengiklanan - Promosi Jumlah Belanja Pemasaran Belanja Operasi & Pentadbiran - Elektrik & Air - Percetakan & Alatulis - Sewa Premis - Gaji Pengurus - KWSP - SOCSO - Caj Telefon - Keraian Pekerja - Pengangkutan - Penyelenggaraan Premis - Susutnilai Harta Tetap - Yuran Perakaunan - Kontinjensi Jumlah Belanja Operasi & Pentadbiran Belanjaan Kewangan - Caj PROSPER Jumlah Belanja Kewangan
JUMLAH PERBELANJAAN UNTUNG BERSIH SEBELUM CUKAI & ZAKAT TOLAK CUKAI ZAKAT UNTUNG BERSIH SELEPAS CUKAI & ZAKAT KEUNTUNGAN TERKUMPUL BAWA BAWAH KEUNTUNGAN TERKUMPUL BAWA HADAPAN
Jul. 2009 (RM) 40,000
Jumlah (RM) 381,000
1,000 6,000 1,000 6,000
1,000 7,500 1,000 7,500
1,000 7,500 1,000 7,500
1,000 9,000 1,000 9,000
1,000 9,000 1,000 9,000
1,000 9,000 1,000 9,000
1,000 10,500 1,000 10,500
1,000 10,500 1,000 10,500
1,000 10,500 1,000 10,500
1,000 11,400 1,000 11,400
1,000 11,400 1,000 11,400
1,000 12,000 1,000 12,000
1,000 114,300 1,000 114,300
9,400 1,222 52 10,674 16,674 3,326 17%
9,400 1,222 52 10,674 18,174 6,826 27%
9,400 1,222 52 10,674 18,174 6,826 27%
9,400 1,222 52 10,674 19,674 10,326 34%
9,400 1,222 52 10,674 19,674 10,326 34%
9,400 1,222 52 10,674 19,674 10,326 34%
9,400 1,222 52 10,674 21,174 13,826 40%
9,400 1,222 52 10,674 21,174 13,826 40%
9,400 1,222 52 10,674 21,174 13,826 40%
9,400 1,222 52 10,674 22,074 15,926 42%
9,400 1,222 52 10,674 22,074 15,926 42%
9,400 1,222 52 10,674 22,674 17,326 43%
112,800 14,664 621 128,085 242,385 138,615 36%
500 1,000
1,000
200
600
200
200
200
200
200
200
200
200
2,000 2,400 4,400
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
3,600 600 30,000 30,000 3,900 177 2,400 1,200 3,600 1,200 94,320 1,200 6,000 178,197
-
-
-
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
2,700 2,700
15,850
15,850
15,050
15,750
15,350
15,350
15,350
15,350
15,350
15,350
15,350
15,350
185,297
(12,524) (12,524) (12,524)
(9,024) (9,024) (12,524) (21,547)
(8,224) (8,224) (21,547) (29,771)
(5,424) (5,424) (29,771) (35,194)
(5,024) (5,024) (35,194) (40,218)
(5,024) (5,024) (40,218) (45,241)
(1,524) (1,524) (45,241) (46,765)
(1,524) (1,524) (46,765) (48,288)
(1,524) (1,524) (48,288) (49,812)
577 577 (49,812) (49,235)
577 577 (49,235) (48,659)
1,977 1,977 (48,659) (46,682)
(46,682) (46,682) (46,682)
500
500 500
100 100
100 500
100 100
100 100
100 100
100 100
100 100
100 100
100 100
100 100
Page 1
RESTORAN MASAKAN KAMPUNG UNJURAN ALIRAN TUNAI BAGI TEMPOH OGOS 2006 - JULAI 2007 Ogo. 2008 Sep. 2008 Okt. 2008 Nov. 2008 Dis. 2008 Jan. 2009 Feb. 2009 Mac. 2009 Apr. 2009 Mei 2009 Jun. 2009 (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM)
Pra (RM) TUNAI MASUK Jualan Tunai Penerimaan Dari Penghutang Modal Pemilik Pinjaman JUMLAH TUNAI MASUK TUNAI KELUAR Belian Stok Bayaran Kepada Pembekal Kos Langsung - Pekerja - Gaji Pekerja Langsung - KWSP - PERKESO Jumlah
19,900 90,000 109,900
20,000 -
25,000 -
20,000
25,000 -
25,000
30,000 -
25,000
30,000 -
30,000
30,000 -
30,000
35,000 -
30,000
35,000 -
35,000
35,000 -
35,000
38,000 -
35,000
38,000 -
38,000
Jul. 2009 (RM) 40,000 -
38,000
Jumlah (RM) 381,000 -
-
19,900 90,000 490,900
40,000
-
6,000 -
7,500 -
7,500 -
9,000 -
9,000 -
9,000 -
10,500 -
10,500 -
10,500 -
11,400 -
11,400 -
12,000 -
114,300 -
-
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
112,800 14,664 621 128,085
Aktiviti Pemasaran - Pengiklanan - Promosi Jumlah
-
500 500 1,000
500 500 1,000
100 100 200
100 500 600
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
2,000 2,400 4,400
Aktiviti Operasi & Pentadbiran - Elektrik & Air - Percetakan & Alatulis - Sewa Premis - Gaji Pengurus - KWSP - SOCSO - Caj Telefon - Keraian Pekerja - Pengangkutan - Penyelenggaraan Premis - Yuran Perakaunan - Kontinjensi Jumlah
-
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
3,600 600 30,000 30,000 3,900 177 2,400 1,200 3,600 1,200 1,200 6,000 83,877
Aktiviti Kewangan - Caj PROSPER - Bayaran Pokok PROSPER Jumlah
-
-
-
-
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
2,700 9,643 12,343
10,000 15,000 25,400 9,500 59,900
-
-
-
-
-
-
-
-
-
-
-
-
10,000 15,000 25,400 9,500 59,900
-
-
-
-
-
-
-
-
-
-
-
-
-
-
28,635 1,365 43,810 45,175
28,235 1,765 45,175 46,940
28,235 1,765 46,940 48,705
29,735 5,265 48,705 53,970
29,735 5,265 53,970 59,235
29,735 5,265 59,235 64,500
30,635 7,365 64,500 71,865
30,635 7,365 71,865 79,230
31,235 8,765 79,230 87,995
402,905 87,995 87,995
Kos Perlaksanaan Projek Stok Permulaan Ubahsuaian Perabut & Kelengkapan Restoran Deposit Sewa & Utiliti Jumlah Pembayaran Cukai Pembayaran Zakat JUMLAH TUNAI KELUAR LEBIHAN/(KURANGAN) TUNAI TUNAI BAWA KE HADAPAN TUNAI HANTAR KE HADAPAN
59,900 50,000 50,000
24,664 (4,664) 50,000 45,337
26,164 (1,164) 45,337 44,173
25,364 (364) 44,173 43,810
40,000 -
45,000 -
40,000
45,000 -
45,000
50,000 -
45,000
50,000 -
50,000
50,000 -
50,000
55,000 -
50,000
55,000 -
55,000
60,000 -
55,000
60,000 -
60,000
70,000 -
60,000
70,000 -
70,000
Jumlah (RM) 650,000 -
70,000
650,000
12,000 -
13,500 -
13,500 -
15,000 -
15,000 -
15,000 -
16,500 -
16,500 -
18,000 -
18,000 -
21,000 -
21,000 -
195,000 -
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
112,800 14,664 624 128,088
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
1,200 1,200 2,400
Aktiviti Operasi & Pentadbiran - Elektrik & Air - Percetakan & Alatulis - Sewa Premis - Gaji Pengurus - KWSP - SOCSO - Caj Telefon - Keraian Pekerja - Pengangkutan - Penyelenggaraan Premis - Yuran Perakaunan - Kontinjensi Jumlah
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,000 2,500 325 15 200 100 300 100 100 500 6,490
300 50 2,000 2,500 325 15 200 100 300 100 100 500 6,490
300 50 2,000 2,500 325 15 200 100 300 100 100 500 6,490
300 50 2,000 2,500 325 15 200 100 300 100 100 500 6,490
3,600 600 28,000 30,000 3,900 177 2,400 1,200 3,600 1,200 1,200 6,000 81,877
Aktiviti Kewangan - Caj PROSPER - Bayaran Pokok PROSPER Jumlah
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
3,600 12,857 16,457
-
-
-
-
-
-
-
-
-
-
-
14,111 3,618
14,111 3,618
31,235 8,765 87,995 96,760
32,735 12,265 96,760 109,025
32,735 12,265 109,025 121,290
34,235 15,765 121,290 137,054
34,235 15,765 137,054 152,819
34,235 15,765 152,819 168,584
35,735 19,265 168,584 187,849
35,735 19,265 187,849 207,114
36,735 23,265 207,114 230,379
36,735 23,265 230,379 253,643
39,735 30,265 253,643 283,908
57,464 12,536 283,908 296,444
441,551 208,449 87,995 296,444
Aktiviti Pemasaran - Pengiklanan - Promosi Jumlah
Pembayaran Cukai Pembayaran Zakat JUMLAH TUNAI KELUAR LEBIHAN/(KURANGAN) TUNAI TUNAI BAWA KE HADAPAN TUNAI HANTAR KE HADAPAN
-
RESTORAN MASAKAN KAMPUNG UNJURAN UNTUNG RUGI BAGI TEMPOH BERAKHIR OGOS 2009 - JULAI 2010 Ogo. 2009 Sep. 2009 Okt. 2009 Nov. 2009 Dis. 2009 Jan. 2010 Feb. 2010 Mac. 2010 Apr. 2010 Mei 2010 Jun. 2010 Jul. 2010 (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) 40,000 45,000 45,000 50,000 50,000 50,000 55,000 55,000 60,000 60,000 70,000 70,000
JUALAN TOLAK
KOS JUALAN Kos Bahan Mentah Stok Awal (+) Belian (-) Stok Akhir Kos Langsung - Pekerja - Gaji Pekerja Langsung - KWSP - PERKESO
JUMLAH KOS JUALAN UNTUNG KASAR Marjin Untung Kasar TOLAK
PERBELANJAAN Belanja Pemasaran - Pengiklanan - Promosi Jumlah Belanja Pemasaran Belanja Operasi & Pentadbiran - Elektrik & Air - Percetakan & Alatulis - Sewa Premis - Gaji Pengurus - KWSP - SOSCO - Caj Telefon - Keraian Pekerja - Pengangkutan - Penyelenggaraan Premis - Susutnilai Harta Tetap - Yuran Perakaunan - Kontinjensi Jumlah Belanja Operasi & Pentadbiran Belanja Kewangan - Caj PROSPER Jumlah Belanja Kewangan
JUMLAH PERBELANJAAN UNTUNG BERSIH SEBELUM CUKAI & ZAKAT TOLAK CUKAI ZAKAT UNTUNG BERSIH SELEPAS CUKAI & ZAKAT KEUNTUNGAN TERKUMPUL BAWA BAWAH KEUNTUNGAN TERKUMPUL BAWA HADAPAN
Jumlah (RM) 650,000
1,000 12,000 1,000 12,000
1,000 13,500 1,000 13,500
1,000 13,500 1,000 13,500
1,000 15,000 1,000 15,000
1,000 15,000 1,000 15,000
1,000 15,000 1,000 15,000
1,000 16,500 1,000 16,500
1,000 16,500 1,000 16,500
1,000 18,000 1,000 18,000
1,000 18,000 1,000 18,000
1,000 21,000 1,000 21,000
1,000 21,000 1,000 21,000
1,000 195,000 1,000 195,000
9,400 1,222 52 10,674 22,674 17,326 43%
9,400 1,222 52 10,674 24,174 20,826 46%
9,400 1,222 52 10,674 24,174 20,826 46%
9,400 1,222 52 10,674 25,674 24,326 49%
9,400 1,222 52 10,674 25,674 24,326 49%
9,400 1,222 52 10,674 25,674 24,326 49%
9,400 1,222 52 10,674 27,174 27,826 51%
9,400 1,222 52 10,674 27,174 27,826 51%
9,400 1,222 52 10,674 28,674 31,326 52%
9,400 1,222 52 10,674 28,674 31,326 52%
9,400 1,222 52 10,674 31,674 38,326 55%
9,400 1,222 52 10,674 31,674 38,326 55%
112,800 14,664 624 128,088 323,088 326,912 50%
100 200
200
200
200
200
200
200
200
200
200
200
200
1,200 1,200 2,400
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,000 2,500 325 15 200 100 300 100 7,860 100 500 14,350
300 50 2,000 2,500 325 15 200 100 300 100 7,860 100 500 14,350
300 50 2,000 2,500 325 15 200 100 300 100 7,860 100 500 14,350
300 50 2,000 2,500 325 15 200 100 300 100 7,860 100 500 14,350
3,600 600 28,000 30,000 3,900 177 2,400 1,200 3,600 1,200 94,320 1,200 6,000 176,197
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
3,600 3,600
15,350
15,350
15,350
15,350
15,350
15,350
15,350
15,350
14,850
14,850
14,850
14,850
182,197
1,976 1,976 (46,682) (44,706)
5,476 5,476 (44,706) (39,230)
5,476 5,476 (39,230) (33,753)
8,976 8,976 (33,753) (24,777)
8,976 8,976 (24,777) (15,801)
8,976 8,976 (15,801) (6,825)
12,476 12,476 (6,825) 5,652
12,476 12,476 5,652 18,128
16,476 16,476 18,128 34,604
16,476 16,476 34,604 51,081
23,476 23,476 51,081 74,557
23,476 14,111 3,618 5,748 74,557 80,305
144,715 14,111 3,618 126,987 (46,682) 80,305
100
100 100
100 100
100 100
100 100
100 100
100 100
100 100
100 100
100 100
100 100
100 100
Page 2
RESTORAN MASAKAN KAMPUNG UNJURAN UNTUNG RUGI BAGI TEMPOH OGOS 2008 - JULAI 2009 Ogo. 2008 Sep. 2008 Okt. 2008 Nov. 2008 Dis. 2008 Jan. 2009 Feb. 2009 Mac. 2009 Apr. 2009 Mei 2009 Jun. 2009 (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) 20,000 25,000 25,000 30,000 30,000 30,000 35,000 35,000 35,000 38,000 38,000
JUALAN TOLAK
KOS JUALAN Kos Bahan Mentah Stok Awal (+) Belian (-) Stok Akhir Kos Langsung - Pekerja - Gaji Pekerja Langsung - KWSP - PERKESO
JUMLAH KOS JUALAN UNTUNG KASAR Marjin Untung Kasar TOLAK
PERBELANJAAN Belanja Pemasaran - Pengiklanan - Promosi Jumlah Belanja Pemasaran Belanja Operasi & Pentadbiran - Elektrik & Air - Percetakan & Alatulis - Sewa Premis - Gaji Pengurus - KWSP - SOCSO - Caj Telefon - Keraian Pekerja - Pengangkutan - Penyelenggaraan Premis - Susutnilai Harta Tetap - Yuran Perakaunan - Kontinjensi Jumlah Belanja Operasi & Pentadbiran Belanjaan Kewangan - Caj PROSPER Jumlah Belanja Kewangan
JUMLAH PERBELANJAAN UNTUNG BERSIH SEBELUM CUKAI & ZAKAT TOLAK CUKAI ZAKAT UNTUNG BERSIH SELEPAS CUKAI & ZAKAT KEUNTUNGAN TERKUMPUL BAWA BAWAH KEUNTUNGAN TERKUMPUL BAWA HADAPAN
Jul. 2009 (RM) 40,000
Jumlah (RM) 381,000
1,000 6,000 1,000 6,000
1,000 7,500 1,000 7,500
1,000 7,500 1,000 7,500
1,000 9,000 1,000 9,000
1,000 9,000 1,000 9,000
1,000 9,000 1,000 9,000
1,000 10,500 1,000 10,500
1,000 10,500 1,000 10,500
1,000 10,500 1,000 10,500
1,000 11,400 1,000 11,400
1,000 11,400 1,000 11,400
1,000 12,000 1,000 12,000
1,000 114,300 1,000 114,300
9,400 1,222 52 10,674 16,674 3,326 17%
9,400 1,222 52 10,674 18,174 6,826 27%
9,400 1,222 52 10,674 18,174 6,826 27%
9,400 1,222 52 10,674 19,674 10,326 34%
9,400 1,222 52 10,674 19,674 10,326 34%
9,400 1,222 52 10,674 19,674 10,326 34%
9,400 1,222 52 10,674 21,174 13,826 40%
9,400 1,222 52 10,674 21,174 13,826 40%
9,400 1,222 52 10,674 21,174 13,826 40%
9,400 1,222 52 10,674 22,074 15,926 42%
9,400 1,222 52 10,674 22,074 15,926 42%
9,400 1,222 52 10,674 22,674 17,326 43%
112,800 14,664 621 128,085 242,385 138,615 36%
500 1,000
1,000
200
600
200
200
200
200
200
200
200
200
2,000 2,400 4,400
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
300 50 2,500 2,500 325 15 200 100 300 100 7,860 100 500 14,850
3,600 600 30,000 30,000 3,900 177 2,400 1,200 3,600 1,200 94,320 1,200 6,000 178,197
-
-
-
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
300 300
2,700 2,700
15,850
15,850
15,050
15,750
15,350
15,350
15,350
15,350
15,350
15,350
15,350
15,350
185,297
(12,524) (12,524) (12,524)
(9,024) (9,024) (12,524) (21,547)
(8,224) (8,224) (21,547) (29,771)
(5,424) (5,424) (29,771) (35,194)
(5,024) (5,024) (35,194) (40,218)
(5,024) (5,024) (40,218) (45,241)
(1,524) (1,524) (45,241) (46,765)
(1,524) (1,524) (46,765) (48,288)
(1,524) (1,524) (48,288) (49,812)
577 577 (49,812) (49,235)
577 577 (49,235) (48,659)
1,977 1,977 (48,659) (46,682)
(46,682) (46,682) (46,682)
500
500 500
100 100
100 500
100 100
100 100
100 100
100 100
100 100
100 100
100 100
100 100
Page 1
RESTORAN MASAKAN KAMPUNG UNJURAN ALIRAN TUNAI BAGI TEMPOH OGOS 2006 - JULAI 2007 Ogo. 2008 Sep. 2008 Okt. 2008 Nov. 2008 Dis. 2008 Jan. 2009 Feb. 2009 Mac. 2009 Apr. 2009 Mei 2009 Jun. 2009 (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM) (RM)
Pra (RM) TUNAI MASUK Jualan Tunai Penerimaan Dari Penghutang Modal Pemilik Pinjaman JUMLAH TUNAI MASUK TUNAI KELUAR Belian Stok Bayaran Kepada Pembekal Kos Langsung - Pekerja - Gaji Pekerja Langsung - KWSP - PERKESO Jumlah
19,900 90,000 109,900
20,000 -
25,000 -
20,000
25,000 -
25,000
30,000 -
25,000
30,000 -
30,000
30,000 -
30,000
35,000 -
30,000
35,000 -
35,000
35,000 -
35,000
38,000 -
35,000
38,000 -
38,000
Jul. 2009 (RM) 40,000 -
38,000
Jumlah (RM) 381,000 -
-
19,900 90,000 490,900
40,000
-
6,000 -
7,500 -
7,500 -
9,000 -
9,000 -
9,000 -
10,500 -
10,500 -
10,500 -
11,400 -
11,400 -
12,000 -
114,300 -
-
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
9,400 1,222 52 10,674
112,800 14,664 621 128,085
Aktiviti Pemasaran - Pengiklanan - Promosi Jumlah
-
500 500 1,000
500 500 1,000
100 100 200
100 500 600
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
100 100 200
2,000 2,400 4,400
Aktiviti Operasi & Pentadbiran - Elektrik & Air - Percetakan & Alatulis - Sewa Premis - Gaji Pengurus - KWSP - SOCSO - Caj Telefon - Keraian Pekerja - Pengangkutan - Penyelenggaraan Premis - Yuran Perakaunan - Kontinjensi Jumlah
-
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
300 50 2,500 2,500 325 15 200 100 300 100 100 500 6,990
3,600 600 30,000 30,000 3,900 177 2,400 1,200 3,600 1,200 1,200 6,000 83,877
Aktiviti Kewangan - Caj PROSPER - Bayaran Pokok PROSPER Jumlah
-
-
-
-
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
300 1,071 1,371
2,700 9,643 12,343
10,000 15,000 25,400 9,500 59,900
-
-
-
-
-
-
-
-
-
-
-
-
10,000 15,000 25,400 9,500 59,900
-
-
-
-
-
-
-
-
-
-
-
-
-
-
28,635 1,365 43,810 45,175
28,235 1,765 45,175 46,940
28,235 1,765 46,940 48,705
29,735 5,265 48,705 53,970
29,735 5,265 53,970 59,235
29,735 5,265 59,235 64,500
30,635 7,365 64,500 71,865
30,635 7,365 71,865 79,230
31,235 8,765 79,230 87,995
402,905 87,995 87,995
Kos Perlaksanaan Projek Stok Permulaan Ubahsuaian Perabut & Kelengkapan Restoran Deposit Sewa & Utiliti Jumlah Pembayaran Cukai Pembayaran Zakat JUMLAH TUNAI KELUAR LEBIHAN/(KURANGAN) TUNAI TUNAI BAWA KE HADAPAN TUNAI HANTAR KE HADAPAN
59,900 50,000 50,000
24,664 (4,664) 50,000 45,337
26,164 (1,164) 45,337 44,173
25,364 (364) 44,173 43,810
Related Documents
Financial Projection Restoran
April 2020 15
Restoran
October 2019 27
May Financial Projection Phyathai 123
November 2019 1
Projection
December 2019 51
Klasifikasi Restoran
May 2020 4