Sheet1 PT. ALAM FOOD INDONESIA NERACA 31 Desember 20001
2000
HARTA HARTA LANCAR Kas dan Bank Piutang Usaha Piutang Lain-lain Persediaan Bahan baku Bahan pembungkus Bahan bakar Barang dalam proses Barang jadi Harta lancar lain-lain Total Harta Lancar HARTA TETAP Nilai Perolehan Tanah Bangunan Mesin-mesin dan peralatan Kendaraan Furniture & Fixture Utilities Jumlah Nilai Perolehan Akumulasi Penyusutan Harta Tetap (Net) Harta Lain-lain Biaya Praoperasi Akumulasi Amortisasi Harta Lain-lain TOTAL HARTA HUTANG DAN EKUITAS HUTANG LANCAR Hutang Usaha Hutang Bunga Hutang Pajak Hutang Bank Jangka Pendek Hutang lain-lain Total Hutang Jangka Pendek Hutang Bank Jangka Panjang Total Hutang EKUITAS Modal Disetor Laba Ditahan Laba Tahun Berjalan
5,935,860,250 31,242,181,602 7,256,637,750 3,111,528,525 2,543,924,000 9,546,680 1,101,886,745 2,188,883,130 65,325,000 53,455,773,682
6,422,243,724.00 15,331,200,733 17,528,163,831 775,917,256 2,359,943,567 2,049,152,609 44,466,621,720 (9,193,178,980) 35,273,442,740 4,223,381,850 (1,407,793,950) 2,815,587,900 91,544,804,322
14,900,375,635 2,079,013,100 5,284,160,015 2,800,500,000 275,890,000 25,339,938,750 19,700,000,000 45,039,938,750 40,000,000,000 3,915,015,053 2,589,850,519
Page 1
2001
Sheet1 Total Ekuitas TOTAL HUTANG DAN EKUITAS
46,504,865,572 91,544,804,322
Tabel 2 RENCANA PENJUALAN (UNIT) 2000 600,000,000
Kapasitas Produksi (Bungkus) Rencana Penjualan (Bungkus) Rencana Penjualan/kapasitas Warning
2001 600,000,000 560,000,000 93.33% ok
Tabel 3 RENCANA KOMPOSISI PENJUALAN JENIS PRODUK 1 Rasa Ayam Bawang 2 Rasa Soto Mie 3 Rasa Mie Special 4 Rasa Ayam Bawang 5 Rasa Mie Goreng TOTAL Tabel 4 PROYEKSI PENJUALAN (UNIT) JENIS PRODUK 1 Rasa Ayam Bawang 2 Rasa Soto Mie 3 Rasa Mie Special 4 Rasa Ayam Bawang 5 Rasa Mie Goreng TOTAL Tabel 5 RENCANA PRODUKSI PENJUALAN (bungkus) Rasa Ayam Bawang Rasa Soto Mie Rasa Mie special Rasa Ayam Bawang special Rasa Mie goreng PERSEDIAAN AWAL (BUNGKUS) Rasa Ayam Bawang Rasa soto Mie Rasa Mie Special Rasa Ayam Bawang Special Rasa Mie goreng PERSEDIAAN AKHIR (BUNGKUS) Page 2
2000 36.00% 20.00% 15.00% 15.00% 14.00% 100.00%
2001 36% 20% 15% 15% 14% 100.00%
2000
2001 201,600,000 112,000,000 84,000,000 84,000,000 78,400,000 560,000,000
2001
2002
201,600,000 112,000,000 84,000,000 84,000,000 78,400,000
207,000,000 115,000,000 86,250,000 86,250,000 80,500,000
2,221,330 1,045,550 261,400 130,670 392,000
2,240,000 1,244,444 933,333 933,333 871,111
Sheet1 Rasa Ayam Bawang Rasa Soto Mie Rasa Mie special Rasa Ayam Bawang special Rasa Mie goreng
2,240,000 1,244,444 933,333 933,333 871,111
2,300,000 1,277,778 958,333 958,333 894,444
PRODUKSI (BUNGKUS) Rasa Ayam Bawang Rasa soto mie Rasa Mie special Rasa Ayam Bawang Special Rasa Mie goreng
201,618,670 112,198,894 84,671,933 84,802,663 78,879,111
207,060,000 115,033,333 86,275,000 86,275,000 80,523,333
Tabel 6 Asumsi Persediaan Akhir Barang Jadi Jenis Produk Rasa Ayam Bawang Rasa soto mie Rasa mie special Rasa ayam Bawang special Rasa mie goreng
Persediaan (hari) 4 4 4 4 4
Tabel 7 RENCANA PENJUALAN, PERSEDIAAN DAN PRODUKSI Penjualan Persediaan awal Persediaan akhir Produksi
2001 560,000,000 4,050,950 6,222,222 562,171,272
2002 575,000,000 6,222,222 6,388,889 575,166,667
2001 600,000,000 562,171,272 93.70%
2002 600,000,000 575,166,667 95.86%
90% 90% 90% 90% 90%
2001 181440000 100800000 75600000 75600000 70560000 504000000
Tabel 8 RENCANA PRODUKSI Kapasitas Produksi (bungkus) Rencana Produksi (bungkus) Utilisasi Kapasitas (%) Tabel 9 RENCANA DISTRIBUSI PENJUALAN (UNIT) LOKAL (BUNGKUS) Rasa ayam Bawang Rasa soto mie Rasa mie special Rasa ayam Bawang special Rasa mie goreng TOTAL PENJUALAN LOKAL
ASUMSI
Page 3
Sheet1 EKSPOR (BUNGKUS) Rasa ayam bawang Rasa soto mie Rasa mie special Rasa ayam bawang special Rasa mie goreng TOTAL PENJUALAN EKSPOR TOTAL PENJUALAN
10% 10% 10% 10% 10%
Tabel 10 HARGA JUAL, KENAIKAN HARGA JUAL BARANG JADI TH 2000 Jenis Produk Harga Jual/bungkus Lokal (Rp) Rasa ayam bawang Rasa soto mie Rasa mie special Rasa ayam bawang special Rasa mie goreng
20160000 11200000 8400000 8400000 7840000 56000000 560000000
Ekspor (USD) 500 500 500 500 500
0.09 0.09 0.09 0.09 0.09
2000
2001
500 500 500 500 500
525 525 525 525 525
0.09 0.09 0.09 0.09 0.09
0.092 0.092 0.092 0.092 0.092
2000 8500
2001 9000
Tabel 11 PROYEKSI HARGA JUAL Lokal (Rp) Rasa Ayam Bawang Rasa soto mie Rasa mie special Rasa ayam bawang special Rasa mie goreng Ekspor (USD) Rasa Ayam Bawang Rasa soto mie Rasa mie special Rasa ayam bawang special Rasa mie goreng Tabel 12 PROYEKSI KURS RP/USD Tabel 13 PROYEKSI PENJUALAN (RP) Rasa Ayam Bawang Rasa soto mie Rasa mie special Rasa ayam bawang special Rasa mie goreng TOTAL PENJUALAN LOKAL
2001 95,256,000,000 52,920,000,000 39,690,000,000 39,690,000,000 37,044,000,000 264,600,000,000 Page 4
Sheet1 EKSPOR Rasa Ayam Bawang Rasa soto mie Rasa mie special Rasa ayam bawang special Rasa mie goreng TOTAL PENJUALAN EKSPOR TOTAL PENJUALAN
16765056000 9313920000 6985440000 6985440000 6519744000 46569600000 311169600000
Tabel 14 RENCANA PENJUALAN 2001 560,000,000 504,000,000 56,000,000 264,600,000,000 46,569,600,000 311,169,600,000
Penjualan (bungkus) Lokal (bungkus) Ekspor (bungkus) Nilai Penjualan - lokal (Rp) NIlai Penjualan - Ekspor (Rp) Total Nilai Penjualan (Rp) Tabel 15 Consumption Figures Bahan Baku per Unit mie instant Jenis Bahan Baku Satuan 1 Terigu gram 2 Tapioka gram 3 Minyak Goreng gram 4 Bumbu-bumbu gram
Rasa Ayam Bawang 46.5 10.3 10 12
Tabel 16 Harga Bahan baku Jenis Bahan baku 1 Terigu 2 Tapioka 3 Minyak Goreng 4 Bumbu-bumbu
Satuan KG KG KG KG
Tabel 17 Proyeksi Harga Beli Bahan Baku Lokal (Rp) Jenis Bahan Baku 1 Terigu 2 Tapioka 3 Minyak Goreng 4 Bumbu-bumbu
Satuan KG KG KG KG
2001 2835 2640 4207.5 8800
Tabel 18 Proyeksi Harga Beli Bahan baku impor (USD) Jenis Bahan Baku Satuan
2001
Page 5
Lokal Rp 2700 2400 3825 8000
Sheet1 1 Terigu 2 Tapioka 3 Minyak Goreng 4 Bumbu-bumbu
KG KG KG KG
0.32 0.30 0.47 0.91
Tabel 19 RENCANA KOMPOSISI PEMBELIAN BAHAN BAKU LOKAL & IMPOR Jenis Bahan Baku (lokal) Satuan 1 Terigu KG 2 Tapioka KG 3 Minyak Goreng KG 4 Bumbu-bumbu KG Impor 1 Terigu KG 2 Tapioka KG 3 Minyak Goreng KG 4 Bumbu-bumbu KG Tabel 20 Rencana Persediaan Bahan Baku (Asumsi) Persediaan (hari) Jenis Bahan Baku 1 Terigu 2 Tapioka 3 Minyak Goreng 4 Bumbu-bumbu Tabel 21 Proyeksi Kebutuhan Bahan Baku (unit) Terigu
2001 75% 75% 75% 75% 25% 25% 25% 25%
14 7 7 7
gram 2001 9,375,268,155 5,206,028,702 3,937,244,900 3,951,804,111 0 22,470,345,869
1 Rasa Ayam Bawang 2 Rasa soto mie 3 Rasa mie special 4 Rasa ayam bawang special 5 Rasa mie goreng Total Kebutuhan Tabel 22 Rencana Pembelian Terigu
kg 2001 1,077,190 22,470,346 873,847 22,267,003
Persediaan Awal Pemakaian Persediaan akhir Pembelian Tabel 23 Page 6
Sheet1 Rencana Pembelian Bahan Baku lokal & impor Terigu total Pembelian (Kg) Pembelian Lokal (Kg) Pembelian impor (Kg) Pembelian lokal (Rp) Pembelian impor (Rp) Total Pembelian (Rp) Harga beli rata-rata (Rp) Tabel 24 Rencana Pemakaian Terigu Persediaan awal Pembelian Persediaan akhir Pemakaian
2001 22,267,003 16,700,252 5,566,751 47,345,214,389.52 15,781,738,129.84 63,126,952,519.36 2835
2001 2,391,361,800 63,126,952,519 2,477,355,632 63,040,958,687
Page 7
Sheet1 2002
2003
Page 8
Sheet1
2002 600,000,000 575,000,000 95.83% ok
2003 Keterangan 600,000,000 Data 575,000,000 Rencana Penjualan 95.83% ok
2002 36.00% 20% 15% 15% 14% 100.00%
2002 207,000,000 115,000,000 86,250,000 86,250,000 80,500,000 575,000,000
2003 Keterangan 36% Rencana penjualan setiap jenis mie 20% (dalam % terhadap total volume penjualan pada tabel 2 15% 15% 14% 100.00%
2003 207,000,000 115,000,000 86,250,000 86,250,000 80,500,000 575,000,000
2003 207,000,000 115,000,000 86,250,000 86,250,000 80,500,000
2,300,000 1,277,778 958,333 958,333 894,444
Page 9
Sheet1 2,300,000 1,277,778 958,333 958,333 894,444
207,000,000 115,000,000 86,250,000 86,250,000 80,500,000
2003 575,000,000 6,388,889 6,388,889 575,000,000
2003 600,000,000 575,000,000 95.83%
2002 186300000 103500000 77625000 77625000 72450000 517500000
2003 186300000 103500000 77625000 77625000 72450000 517500000
Page 10
Sheet1 20700000 11500000 8625000 8625000 8050000 57500000 575000000
20700000 11500000 8625000 8625000 8050000 57500000 575000000
Kenaikan harga jual Lokal Ekspor 5.00% 5.00% 5.00% 5.00% 5.00%
5.00% 5.00% 5.00% 5.00% 5.00%
2002
2003
551 551 551 551 551
579 579 579 579 579
0.097 0.097 0.097 0.097 0.097
0.102 0.102 0.102 0.102 0.102
2002 9500
2003 10000
2002 102,697,875,000 57,054,375,000 42,790,781,250 42,790,781,250 39,938,062,500 285,271,875,000
2003 107,832,768,750 59,907,093,750 44,930,320,313 44,930,320,313 41,934,965,625 299,535,468,750 Page 11
Sheet1 19078983000 10599435000 7949576250 7949576250 7419604500 52997175000 338269050000
21087297000 11715165000 8786373750 8786373750 8200615500 58575825000 358111293750
2002 575,000,000 517,500,000 57,500,000 285,271,875,000 52,997,175,000 338,269,050,000
2003 575,000,000 517,500,000 57,500,000 299,535,468,750 58,575,825,000 358,111,293,750
Rasa soto Mie
Rasa Mie Special Rasa Ayam Bawang Special 46.4 46.5 46.6 10 10.3 10.2 10 10 10 12 12 12
Impor US$
Kenaikan harga lokal Kenaikan Harga Impor (% /tahun) (%/tahun) 0.30 5% 5% 0.27 10% 10% 0.43 10% 10% 0.83 10% 10%
Harga Bahan Baku 2002 2977 2904 4628 9680
2003 3126 3194 5091 10648
Harga Bahan Baku 2002
2003
Page 12
Sheet1 0.33 0.33 0.52 1.00
0.35 0.36 0.57 1.10
2002 75% 75% 75% 75%
2003 75% 75% 75% 75%
25% 25% 25% 25%
25% 25% 25% 25%
2002 9,628,290,000 5,337,546,667 4,011,787,500 4,020,415,000 0 22,998,039,167
2003 9,625,500,000 5,336,000,000 4,010,625,000 4,019,250,000 0 22,991,375,000
2002 873,847 22,998,039 894,368 23,018,561
2003 894,368 22,991,375 894,109 22,991,116
Page 13
Sheet1 2002 23,018,561 17,263,920 5,754,640 51,390,375,138.60 18,081,798,659.88 69,472,173,798.48 3018
2003 22,991,116 17,243,337 5,747,779 53,895,558,205.64 19,961,317,853.94 73,856,876,059.58 3212
2002 2477355632.01 69,472,173,798 2,699,287,044 69,250,242,387
2003 2,699,287,044 73,856,876,060 2,872,244,223 73,683,918,880
Page 14