Selasa, 25 Mei 2010

Analisis Finansial Industri Gelatin




A. ASUMSI



NoAsumsiNilai
1Umur proyek (tahun)10
2Nilai sisa bangunan (%)50
3Nilai sisa tanah (%)0
4Nilai sisa mesin dan peralatan dari nilai awal (%) 10
5Biaya pemeliharaan mesin dan peralatan dari harga (%)5
6Biaya asuransi mesin dan peralatan dari harga (%)2
7Kapasitas produksi gelatin (kg/hari)1449
8Kebutuhan bahan baku kulit (kg/hari)4478
9Jumlah hari kerja per tahun300
10Discount factor (%)19
11Persentase produksi tahun 1 (%)80
12Persentase produksi tahun 2 (%)90
13Persentase produksi tahun 3-10 (%)100
14Persentase produk terjual tahun 1-10 (%)80
15Kenaikan harga jual per dua tahun (%)11,5
16Kenaikan biaya operasional per tahun (%)5,75


B. BIAYA INVESTASI



NamaJumlahNilaiNilai sisaBiaya Depresiasi tahun ke- (Rp.000)         
(Rp.000)(Rp.000)12345678910
Persiapan             
Perizinan-172.498-----------
AMDAL-50.000-----------
Pembelian paten-20.000-----------
Subtotal 242.49800000000000
Pekerjaan Sipil dan Struktur             
Tanah (m2)19476,56252.921.4842.921.484----------
Bangunan produksi (m2)19476,56257.790.6253.895.313708.239637.415566.591495.767424.943354.119283.295212.472141.64870.824
Areal parkir gudang (m2)956,2526.29713.1482.3912.1521.9131.6731.4341.195956717478239
Parit (m2)45012.3756.1881.1251.013900788675563450338225113
Jalan (m2)122533.68816.8443.0632.7562.4502.1441.8381.5311.225919613306
Pembuatan gambar dan spesifikasi-264.375-----------
Instalasi mesin dan peralatan-915.837-----------
Asuransi rekayasa-71.087-----------
Jasa kontraktor-686.877-----------
Akunting, telekomunikasi, supervisi-274.751-----------
Strat up dan Ujicoba produksi-915.837-----------
Subtotal 13.913.2336.852.977714.817643.335571.853500.372428.890357.408285.927214.445142.96371.482
Peralatan Umum             
Sistem perpipaan (selain evaporator dan dryer)1288.30128.83047.17742.45937.74133.02428.30623.58818.87114.1539.4354.718
Instalasi listrik11.193.653119.365195.325175.793156.260136.728117.19597.66378.13058.59839.06519.533
Perlengkapan laboratorium1281.16228.11646.00841.40736.80732.20627.60523.00418.40313.8029.2024.601
Peralatan pencegah kebakaran1411.94041.19467.40860.66753.92747.18640.44533.70426.96320.22213.4826.741
Instrumentasi dan kontrol11.144.796114.480187.330168.597149.864131.131112.39893.66574.93256.19937.46618.733
Subtotal 3.319.852331.985543.248488.924434.599380.274325.949271.624217.299162.975108.65054.325
Pencucian Kulit Split             
Paddle washer226.4722.6474.3323.8993.4653.0322.5992.1661.7331.300866433
Overhead conveyor1247.17824.71840.44736.40332.35828.31324.26820.22416.17912.1348.0894.045
Subtotal 273.65027.36544.77940.30135.82331.34526.86722.39017.91213.4348.9564.478
Pengeringan             
Rak pengering3235.2003.5205.7605.1844.6084.0323.4562.8802.3041.7281.152576
Overhead conveyor1311.03531.10350.89745.80740.71735.62830.53825.44820.35915.26910.1795.090
Bak penampungan213.2001.3202.1601.9441.7281.5121.2961.080864648432216
Konveyor sabuk228.8872.8894.7274.2543.7823.3092.8362.3631.8911.418945473
Subtotal 388.32138.83263.54357.18950.83544.48038.12631.77225.41719.06312.7096.354
Pemotongan             
Mesin pemotong 244.6214.4627.3026.5715.8415.1114.3813.6512.9212.1901.460730
Hoper243.3214.3327.0896.3805.6714.9624.2533.5442.8362.1271.418709
Konveyor sabuk228.8872.8894.7274.2543.7823.3092.8362.3631.8911.418945473
Konveyor sabuk228.8872.8894.7274.2543.7823.3092.8362.3631.8911.418945473
Subtotal 145.71514.57123.84421.46019.07516.69114.30711.9229.5387.1534.7692.384
Perendaman Asam             
Tangki perendaman496.6579.66615.81714.23512.65311.0729.4907.9086.3274.7453.1631.582
Hoper248.3294.8337.9087.1176.3275.5364.7453.9543.1632.3721.582791
Konveyor sabuk tertutup228.8872.8894.7274.2543.7823.3092.8362.3631.8911.418945473
Subtotal 173.87217.38728.45225.60722.76119.91617.07114.22611.3818.5365.6902.845
Netralisasi             
Paddle washer240.1244.0126.5665.9095.2534.5963.9393.2832.6261.9701.313657
Hoper248.3294.8337.9087.1176.3275.5364.7453.9543.1632.3721.582791
Konveyor sabuk tertutup228.8872.8894.7274.2543.7823.3092.8362.3631.8911.418945473
Konveyor sabuk228.8872.8894.7274.2543.7823.3092.8362.3631.8911.418945473
Pompa212.6051.2612.0631.8561.6501.4441.2381.031825619413206
Subtotal 158.83215.88325.99123.39220.79218.19315.59412.99510.3967.7975.1982.599
Ekstraksi             
Ekstraktor I2549.06054.90689.84680.86271.87762.89253.90844.92335.93826.95417.9698.985
Ekstraktor II2385.84538.58463.13856.82450.51144.19737.88331.56925.25518.94112.6286.314
Ekstraktor III2285.66828.56746.74642.07137.39632.72228.04723.37318.69814.0249.3494.675
Ekstraktor IV2207.93220.79334.02530.62327.22023.81820.41517.01313.61010.2086.8053.403
Tangki penampungan2122.31012.23120.01418.01316.01214.01012.00910.0078.0066.0044.0032.001
Tangki penampungan lemak25.28452886577869260551943234625917386
Pompa impeler675.6327.56312.37611.1399.9018.6637.4266.1884.9503.7132.4751.238
Subtotal 1.631.732163.173267.011240.310213.608186.907160.206133.505106.80480.10353.40226.701
Filtrasi             
Filter21.730.246173.025283.131254.818226.505198.192169.879141.566113.25284.93956.62628.313
Tangki penampungan161.1556.11610.0079.0068.0067.0056.0045.0044.0033.0022.0011.001
Subtotal 1.791.402179.140293.138263.825234.511205.197175.883146.569117.25587.94258.62829.314
Evaporasi dan Sterilisasi             
Evaporator system18.556.292855.6291.400.1201.260.1081.120.096980.084840.072700.060560.048420.036280.024140.012
(termasuk sterilisasi)             
Subtotal 8.556.292855.6291.400.1201.260.1081.120.096980.084840.072700.060560.048420.036280.024140.012
Pengeringan             
Tumble dryer system27.844.754784.4751.283.6871.155.3181.026.950898.581770.212641.844513.475385.106256.737128.369
(termasuk extruder dan cutter)             
Subtotal 7.844.754784.4751.283.6871.155.3181.026.950898.581770.212641.844513.475385.106256.737128.369
Pengemasan dan Penyimpanan             
Mesin pengemas158.2425.8249.5318.5777.6246.6715.7184.7653.8122.8591.906953
Konveyor211.5001.1501.8821.6941.5051.3171.129941753565376188
Subtotal 69.7426.97411.41210.2719.1307.9896.8475.7064.5653.4242.2821.141
Pencampuran HCl             
Tangki HCl 1%128.2842.8284.6284.1653.7033.2402.7772.3141.8511.388926463
Tangki Pencampur118.6601.8663.0542.7482.4432.1371.8321.5271.221916611305
Tangki HCl 38 %18.3758371.3701.2331.096959822685548411274137
Pompa impeler318.9081.8913.0942.7852.4752.1661.8561.5471.238928619309
Subtotal 74.2277.42312.14610.9329.7178.5027.2886.0734.8593.6442.4291.215
Pembangkit Tenaga             
Tangki bahan bakar127.7592.7764.5424.0883.6343.1802.7252.2711.8171.363908454
Pompa16.3036301.031928825722619516413309206103
Genset 375 KVA1349.50434.95057.19251.47245.75340.03434.31528.59622.87717.15711.4385.719
Subtotal 383.56638.35762.76556.48950.21243.93637.65931.38325.10618.83012.5536.277
Pengolahan Air Bersih             
Tangki air1161.61916.16226.44723.80221.15718.51315.86813.22310.5797.9345.2892.645
Pompa air16.3036301.031928825722619516413309206103
Subtotal 167.92116.79227.47824.73021.98219.23516.48713.73910.9918.2435.4962.748
              
Pengolahan Limbah11.235.890123.589202.237182.013161.789141.566121.342101.11880.89560.67140.44720.224
Subtotal 1.235.890123.589202.237182.013161.789141.566121.342101.11880.89560.67140.44720.224
Peralatan transportasi dan             
pemindahan bahan             
Forklift2150.00015.00024.54522.09119.63617.18214.72712.2739.8187.3644.9092.455
Mobil box4240.00024.00039.27335.34531.41827.49123.56419.63615.70911.7827.8553.927
Subtotal 390.00039.00063.81857.43651.05544.67338.29131.90925.52719.14512.7646.382
Total 40.761.4998.657.9243.668.3673.301.5312.934.6942.567.8572.201.0201.834.1841.467.3471.100.510733.673366.837



C. BIAYA TENAGA KERJA




JabatanJumlahGaji/orang/bulan (Rp)Gaji/bulan (Rp)Gaji/tahun (Rp)
Tenaga Kerja Tak Langsung
Direktur115.000.00015.000.000180.000.000
Manajer 58.000.00040.000.000480.000.000
Asisten Manajer105.000.00050.000.000600.000.000
Administratif101.500.00015.000.000180.000.000
Keamanan8900.0007.200.00086.400.000
Subtotal3430.400.000127.200.0001.526.400.000
Tenaga Kerja Langsung
Supervisor92.500.00022.500.000270.000.000
Operator151.800.00027.000.000324.000.000
Pekerja39900.00035.100.000421.200.000
Supir4900.0003.600.00043.200.000
Subtotal67 84.600.0001.015.200.000
Total101 211.800.0002.541.600.000


D. BIAYA BAHAN BAKU DAN BAHAN PEMBANTU



NoKomponenKebutuhan/bulanBiaya/unit (Rp.)Biaya/bulan (Rp.)Biaya/tahun (Rp.)
ABahan Mentah    
1Kulit Split (kg)4.4783.00013.434.000161.208.000
2HCl 38 % (liter)17525.0004.375.00052.500.000
 Subtotal   213.708.000
BBahan Kemasan    
1Plastik polypropylene (case)5953.5324.407.70252.892.420
 Subtotal   52.892.420
CBahan Bakar    
1Steam (kg)2.228153341.6364.099.631
1Listrik (kWh)24.03556013.459.600161.515.200
2Bensin (liter)6.0001.81010.860.000130.320.000
 Subtotal   291.835.200
 Total   558.435.620


E. BIAYA OPERASIONAL



NoKomponenTahun Ke- (Rp)
  12345678910
 Biaya Tetap          
1Tenaga kerja tak langsung1.526.400.0001.614.168.0001.706.982.6601.805.134.1631.908.929.3772.018.692.8172.134.767.6532.257.516.7942.387.324.0092.524.595.140
2Administrasi 508.320.000537.548.400568.457.433601.143.735635.709.500672.262.796710.917.907751.795.687795.023.939840.737.815
3Pemasaran158.132.966167.225.612176.841.084187.009.447197.762.490209.133.833221.159.028233.875.672247.323.524261.544.626
4Depresiasi3.668.367.4003.301.530.6602.934.693.9202.567.857.1802.201.020.4401.834.183.7001.467.346.9601.100.510.220733.673.480366.836.740
5Asuransi619.496.848619.496.848619.496.848619.496.848619.496.848619.496.848619.496.848619.496.848619.496.848619.496.848
6Riset dan Pengembangan (R&D)158.132.966167.225.612176.841.084187.009.447197.762.490209.133.833221.159.028233.875.672247.323.524261.544.626
7Biaya pemeliharaan1.121.707.0931.121.707.0931.121.707.0931.121.707.0931.121.707.0931.121.707.0931.121.707.0931.121.707.0931.121.707.0931.121.707.093
 Subtotal7.760.557.2737.528.902.2247.305.020.1227.089.357.9126.882.388.2386.684.610.9196.496.554.5186.318.777.9866.151.872.4165.996.462.888
BBiaya Variabel          
1Bahan mentah213.708.000225.996.210238.990.992252.732.974267.265.120282.632.865298.884.254316.070.099334.244.130353.463.167
2Bahan kemasan52.892.42055.933.73459.149.92462.551.04566.147.73069.951.22473.973.41978.226.89182.724.93787.481.621
3Bahan bakar291.835.200308.615.724326.361.128345.126.893364.971.689385.957.561408.150.121431.618.753456.436.832482.681.949
4Tenaga kerja langsung1.015.200.0001.073.574.0001.135.304.5051.200.584.5141.269.618.1241.342.621.1661.419.821.8831.501.461.6411.587.795.6851.679.093.937
 Subtotal1.573.635.6201.664.119.6681.759.806.5491.860.995.4261.968.002.6632.081.162.8162.200.829.6782.327.377.3842.461.201.5842.602.720.675
 Total9.334.192.8939.193.021.8929.064.826.6718.950.353.3388.850.390.9008.765.773.7358.697.384.1958.646.155.3708.613.073.9998.599.183.563


F. ANGSURAN KREDIT



Modal Investasi Tetap (Waktu pengembalian 5 Tahun)
Tahun Jumlah Kredit (Rp)Angsuran Pokok (Rp)Bunga (Rp)Total (Rp)Sisa Kredit (Rp)
028.533.049.37800028.533.049.378
128.533.049.3785.706.609.8765.421.279.38211.127.889.25822.826.439.503
222.826.439.5035.706.609.8764.337.023.50610.043.633.38117.119.829.627
317.119.829.6275.706.609.8763.252.767.6298.959.377.50511.413.219.751
411.413.219.7515.706.609.8762.168.511.7537.875.121.6285.706.609.876
55.706.609.8765.706.609.8761.084.255.8766.790.865.7520
Modal Investasi Tetap (Waktu pengembalian 10 Tahun)
Tahun Jumlah Kredit (Rp)Angsuran Pokok (Rp)Bunga (Rp)Total (Rp)Sisa Kredit (Rp)
028.533.049.37800028.533.049.378
128.533.049.3782.853.304.9385.421.279.3828.274.584.32025.679.744.441
225.679.744.4412.853.304.9384.879.151.4447.732.456.38222.826.439.503
322.826.439.5032.853.304.9384.337.023.5067.190.328.44319.973.134.565
419.973.134.5652.853.304.9383.794.895.5676.648.200.50517.119.829.627
517.119.829.6272.853.304.9383.252.767.6296.106.072.56714.266.524.689
614.266.524.6892.853.304.9382.710.639.6915.563.944.62911.413.219.751
711.413.219.7512.853.304.9382.168.511.7535.021.816.6918.559.914.814
88.559.914.8142.853.304.9381.626.383.8154.479.688.7525.706.609.876
95.706.609.8762.853.304.9381.084.255.8763.937.560.8142.853.304.938
102.853.304.9382.853.304.938542.127.9383.395.432.8760
Modal Kerja (Waktu pengembalian 5 tahun
Tahun Jumlah Kredit (Rp)Angsuran Pokok (Rp)Bunga (Rp)Total (Rp)Sisa Kredit (Rp)
06.533.935.0250006.533.935.025
16.533.935.0251.306.787.0051.241.447.6552.548.234.6605.227.148.020
25.227.148.0201.306.787.005993.158.1242.299.945.1293.920.361.015
33.920.361.0151.306.787.005744.868.5932.051.655.5982.613.574.010
42.613.574.0101.306.787.005496.579.0621.803.366.0671.306.787.005
51.306.787.0051.306.787.005248.289.5311.555.076.5360
Modal Kerja (Waktu pengembalian 10 Tahun)
Tahun Jumlah Kredit (Rp)Angsuran Pokok (Rp)Bunga (Rp)Total (Rp)Sisa Kredit (Rp)
06.533.935.0250006.533.935.025
16.533.935.025653.393.5021.241.447.6551.894.841.1575.880.541.522
25.880.541.522653.393.5021.117.302.8891.770.696.3925.227.148.020
35.227.148.020653.393.502993.158.1241.646.551.6264.573.754.517
44.573.754.517653.393.502869.013.3581.522.406.8613.920.361.015
53.920.361.015653.393.502744.868.5931.398.262.0953.266.967.512
63.266.967.512653.393.502620.723.8271.274.117.3302.613.574.010
72.613.574.010653.393.502496.579.0621.149.972.5641.960.180.507
81.960.180.507653.393.502372.434.2961.025.827.7991.306.787.005
91.306.787.005653.393.502248.289.531901.683.033653.393.502
10653.393.502653.393.502124.144.765777.538.2680


G. PROYEKSI LABA RUGI



Uraian  Tahun ke-(Rp)
  12345678910
APenerimaan          
1Penjualan produk18.030.291.32620.284.077.74225.129.718.53625.129.718.53628.019.636.16728.019.636.16731.241.894.32731.241.894.32734.834.712.17434.834.712.174
 Total A18.030.291.32620.284.077.74225.129.718.53625.129.718.53628.019.636.16728.019.636.16731.241.894.32731.241.894.32734.834.712.17434.834.712.174
BPengeluaran          
1Biaya tetap7.760.557.2737.528.902.2247.305.020.1227.089.357.9126.882.388.2386.684.610.9196.496.554.5186.318.777.9866.151.872.4165.996.462.888
2Biaya variabel1.573.635.6201.664.119.6681.759.806.5491.860.995.4261.968.002.6632.081.162.8162.200.829.6782.327.377.3842.461.201.5842.602.720.675
 Total B9.334.192.8939.193.021.8929.064.826.6718.950.353.3388.850.390.9008.765.773.7358.697.384.1958.646.155.3708.613.073.9998.599.183.563
 Laba kotor (A - B)8.696.098.43311.091.055.85016.064.891.86516.179.365.19819.169.245.26719.253.862.43222.544.510.13122.595.738.95726.221.638.17526.235.528.612
CPembayaran bunga          
1Bunga modal investasi5.421.279.3824.879.151.4444.337.023.5063.794.895.5673.252.767.6292.710.639.6912.168.511.7531.626.383.8151.084.255.876542.127.938
2Bunga modal kerja1.241.447.6551.117.302.889993.158.124869.013.358744.868.593620.723.827496.579.062372.434.296248.289.531124.144.765
 Total C6.662.727.0375.996.454.3335.330.181.6294.663.908.9263.997.636.2223.331.363.5182.665.090.8151.998.818.1111.332.545.407666.272.704
 Laba sebelum pajak ((A -B) -C)2.033.371.3975.094.601.51710.734.710.23511.515.456.27215.171.609.04515.922.498.91419.879.419.31720.596.920.84624.889.092.76825.569.255.908
 Pajak penghasilan592.511.4191.510.880.4553.202.913.0713.437.136.8824.533.982.7144.759.249.6745.946.325.7956.161.576.2547.449.227.8307.653.276.772
 Laba Bersih1.440.859.9783.583.721.0627.531.797.1658.078.319.39110.637.626.33211.163.249.24013.933.093.52214.435.344.59217.439.864.93717.915.979.136


H. PROYEKSI ARUS KAS



Uraian Tahun (Rp)
  012345678910
AKas Masuk           
1Laba Bersih01.440.859.9783.583.721.0627.531.797.1658.078.319.39110.637.626.33211.163.249.24013.933.093.52214.435.344.59217.439.864.93717.915.979.136
2Depresiasi03.668.367.4003.301.530.6602.934.693.9202.567.857.1802.201.020.4401.834.183.7001.467.346.9601.100.510.220733.673.480366.836.740
3Nilai Sisa00000000008.657.924.175
4Nilai Barang Tidak Terjual04.507.572.8325.071.019.4356.282.429.6346.282.429.6347.004.909.0427.004.909.0427.810.473.5827.810.473.5828.708.678.0448.708.678.044
5Pengembalian Modal Kerja00000000009.334.192.893
6Modal Sendiri15.028.707.6010000000000
7Modal Pinjaman35.066.984.4030000000000
 Total A50.095.692.0059.616.800.21011.956.271.15816.748.920.71916.928.606.20519.843.555.81420.002.341.98223.210.914.06423.346.328.39426.882.216.46144.983.610.987
BKas Keluar           
1Investasi Tetap40.761.499.1120000000000
2Modal Kerja9.334.192.8930000000000
3Angsuran Pinjaman03.506.698.4403.506.698.4403.506.698.4403.506.698.4403.506.698.4403.506.698.4403.506.698.4403.506.698.4403.506.698.4403.506.698.440
 Total B50.095.692.0053.506.698.4403.506.698.4403.506.698.4403.506.698.4403.506.698.4403.506.698.4403.506.698.4403.506.698.4403.506.698.4403.506.698.440
 Kas Bersih06.110.101.7698.449.572.71713.242.222.27913.421.907.76516.336.857.37316.495.643.54219.704.215.62319.839.629.95423.375.518.02141.476.912.547
 Kas Awal Tahun006.110.101.76914.559.674.48727.801.896.76641.223.804.53057.560.661.90474.056.305.44593.760.521.068113.600.151.022136.975.669.043
 Kas Akhir Tahun06.110.101.76914.559.674.48727.801.896.76641.223.804.53057.560.661.90474.056.305.44593.760.521.068113.600.151.022136.975.669.043178.452.581.590


I. KRITERIA KELAYAKAN INVESTASI



TahunBt-Ct (Rp)Akumulasi (Rp)
0(50.095.692.005)(50.095.692.005)
16.110.101.769(43.985.590.235)
28.449.572.717(35.536.017.518)
313.242.222.279(22.293.795.239)
413.421.907.765(8.871.887.475)
516.336.857.3737.464.969.899
616.495.643.54223.960.613.440
719.704.215.62343.664.829.064
819.839.629.95463.504.459.017
923.375.518.02186.879.977.038
1041.476.912.547128.356.889.585
   
 KriteriaNilai
 NPV (Rp)11.144.140.916
 IRR (%)23,16666191
 Net B/C1,2225
 PBP (Tahun)4,55


Tidak ada komentar:

Posting Komentar

Berita Agroindustri

Kemasan Cerdas dengan Sensor Kebusukan Fillet Ikan. Mahasiswa bernama lengkap Yogi Waldingga Hasnedi berhasil membuat kemasan cerdas pendeteksi kebusukan fillet ikan. Ia memulai penelitiannya karena melihat bahwa penilaian kesegaran ikan yang dilakukan masyarakat sampai saat ini masih menggunakan indra dengan faktor yang diamati berupa penampakan (diamati pada mata, kulit, dan insang), tekstur, bau, dan warna. Sejalan dengan kemajuan teknik kemasan, berbagai penilaian tingkat kesegaran ikan saat ini telah mengarah pada produk kemasan yang terintegrasi antara nilai kemasan tersebut dengan tingkat kesegaran ikan itu sendiri...Selengkapnya

Tips Trik Menulis Skripsi