Ekonomi Proses Semester Pendek 2013/2014

Kelompok 11 Muhammad Hared2 Andini Dwisurya Utami3 Adhia Rieyanasari4 Nabilah Ulfah

Pabrik Fungsi Harga ProdukHarga Produk/kg (Rp)Kapasitas (ton/th)Harga Jual Produk/kg (Rp)CE Index (Des'13)CE Index (Perpab'12)CE Index (Alat Garret )1$ (Rp)

Bahan BakuNo. Bahan

a Sukrosab Nitrogen (Urea)c Bakteri (Medium)d Limbah Cair Tahu

Total

UtilitasNo. Utilitas

a Listrik (/kWh)b Gas LPG (/kg)c Air Pencuci Alat (/L)

Total

Kebutuhan Alat (Purchase Equipment/PE)No. Nama Alat

a Tanki Bahan Baku T-01

b Tanki NaOH T-02c Tanki Acetobacter T-03d Tanki Pencampuran T-04e Filter F-01f Rotary Press Drum PS-01g Fermentor FM-01h Kolom Pencucian Pertama T-06i Kolom Pencucian Kedua T-05j Boiler Sterilisasi Bahan Baku B-01k Boiler Sterilisasi Peralatan B-02l Heat Exchanger 1 HE-01

m Heat Exchanger 2 HE-02n Heat Exchanger 3 HE-03o Pemotong S-01p Pompa P-01q Pompa P-02r Pompa P-03s Belt Conveyor CV-13t Belt Conveyor CV-17u Belt Conveyor CV-22

Total ($)

TPC, TCI dan PCMultiplier (Fluid Processing)Off Site FacilitiesPlant Start UpWorking CapitalTotal Plant Cost ($)Total Cost Invesment ($)Plant Cost ($)

Operating LaborCrew (shift)Jumlah OrangFungsi GajiGaji/jam($)Harga Gaji/jam ($)Jam (hr/w)Hari Libur / tahunNormal hours Jam kerja (crew)OverOvertime (hr/w)Overtime Cost

Total ($)

Labor Related CostTypical CostOperating Labor ($)

Labor Related Cost ($)

Capital Related CostTypical CostPlant Cost ($)

Capital Related Cost ($)

Sales Related Cost Typical Cost

Sales

Harga/ton ($)Target (ton/tahun)Sales/tahun ($)

Sales Related Cost ($)

PinjamanJumlah Pinjaman ($)

Bunga

Tahun Pinjaman123456789

10

TOR dan Cost/Ton Of ProductTurn Over RatioCost per Ton Of Product ($)

DepresiasiAsumsi Umur (th )Nilai Sisa ($)

1. Straight LineTahun ke-

0123456789

10Total ($)

2. Sum of Year Digit

Penyebut

Tahun ke-0123456789

10Total ($)

3. Double Declining Balance Versi Garret

Tahun ke-0123456789

10Total ($)

Versi TurtonTahun ke-

0123456789

10Total ($)

Fixed Manufacturing Cost

Operating Labor ($)Labor Related Cost ($)Capital Related Cost ($)

Total ($)

Variable Manufacturing CostRaw Material ($)Utilitas ($)Sales Related Cost ($)

Total ($)

Manufacturing CostFixed Man.Cost ($)Variable Man.Cost ($)Pengembalian Pinjaman ($)Fixed Man.Cost tanpa depresiasi SL ($)

Total ($)Manufacturing Cost tanpa Pinjaman ($)Manufacturing Cost dengan Pinjaman($)

Cash FlowPajak

Tahun ke-123456789

10Total ($)

Rata-rata ($)

ROI,PP dan BEPReturn On InvestmentPayback Period (th)Break Event Point sebelum depresiasiBreak Event Point setelah depresiasi

Analisis kelaikan proyek dengan memperhitungkan suku bunga

NCF & NPV% i1% i2

Tahun ke-0123456789

10Total ($)

Kurva NCF &NPV Terhadap Waktu

Tahun ke-0123456789

10

Interpolasi IRR

0 2 4 6 8 10 12

(40,000,000.00)

(20,000,000.00)

-

20,000,000.00

40,000,000.00

60,000,000.00

80,000,000.00

100,000,000.00

120,000,000.00

140,000,000.00

NCF ($)NPV 1 ($)NPV 2 ($)

Grafik

% iNPV

Manual

10%

10%

Excel

IRR

Tahun ke-01234567

0% 10% 20% 30% 40% 50% 60% 70% 80% 90% (10,000,000.00)

-

10,000,000.00

20,000,000.00

30,000,000.00

40,000,000.00

50,000,000.00

60,000,000.00

70,000,000.00

NPV

NPV

89

10Total ($)

Analisis Sensitivitas

10%20%30%40%50%

Base Case 0%-10%-20%-30%-40%-50%

-60% -40% -20% 0% 20% 40% 60%0.00%

20.00%

40.00%

60.00%

80.00%

100.00%

120.00%

Spider Curve Sales

Spider Curve Sales

14-2012-01814-2012-03414-2012-03914-2012-059

Nata de Soya dari limbah cair industri tahu1

200002100020000567.6537320

12000

Harga (Rp/kg) 8,000.00 3,000.00 100,000.00 -

Harga (Rp/kg) 700.00 3,000.00 950.00

JenisClarifier

Tanki silinder vertikal dengan tutup atas elipsoidal dan bawah kerucut Tanki silinder vertikal dengan tutup atas dan bawal elipsoidalTanki silinder vertikal dengan tutup atas dan bawal elipsoidalVacuum filterDouble rotary drum dengan jarak drum yang dapat diatur

Kolom terbuka persegi panjangKolom terbuka persegi panjangKetel vertikal pipa apiKetel vertikal pipa apiShell and Tube 1-2 HE

Rotating Biological Contactor (RBC)

Double Pipe HEDouble Pipe HE Double Rotary scalpel drumPompa centrifugal conventionalPompa centrifugal conventionalPompa centrifugal conventionalClosed Compartement Belt ConveyorClosed Compartement Belt ConveyorClosed Compartement Belt Conveyor

5.20.1%

5%10%

17,794,524.91 20,481,498.17 18,702,045.68

46

1.50.000480.00072

4030

35.94 4.590.59

5.9 7.95 43.89

60% 43.89 26.34

26% 18,702,045.68 4,862,531.88

20%

1,666.67 21,000.00 35,000,000.00 7,000,000.00

65% 13,312,973.81

27%

Pinjaman ($) 13,312,973.81 11,981,676.43 10,650,379.05 9,319,081.67 7,987,784.29 6,656,486.91 5,325,189.52 3,993,892.14 2,662,594.76 1,331,297.38

Total ($)Rata-rata ($)

1.87890.57

10 1,000,000

Depresiasi Tahun ke- ($) 0

1,770,204.57 1,770,204.57 1,770,204.57 1,770,204.57 1,770,204.57 1,770,204.57 1,770,204.57 1,770,204.57 1,770,204.57 1,770,204.57 17,702,045.68

55

Depresiasi Tahun ke- ($)0

3,218,553.76 2,896,698.38 2,574,843.01 2,252,987.63 1,931,132.26 1,609,276.88 1,287,421.50 965,566.13 643,710.75 321,855.38 17,702,045.68

Depresiasi Tahun ke- ($) - 3,540,409.14 2,832,327.31 2,265,861.85 1,812,689.48 1,450,151.58 1,160,121.27 928,097.01 742,477.61 593,982.09 2,375,928.35 17,702,045.68

Depresiasi Tahun ke- ($)0

3,740,409.14 2,992,327.31 2,393,861.85 1,915,089.48 1,532,071.58 1,225,657.27 980,525.81 784,420.65 627,536.52 1,510,146.08 17,702,045.68

43.89 26.34 4,862,531.88 4,862,602.11

1,260,360.87 137,172.90 7,000,000.00 8,397,533.76

4,862,602.11 8,397,533.76 33,082,739.92 3,092,397.54

13,260,135.87 46,342,875.79

35%

Kapasitas100%100%100%100%100%100%100%100%100%100%

106.4%0.7524%31%

Analisis kelaikan proyek dengan memperhitungkan suku bunga

10%80%

Cash Flow ($) (20,481,498.17) 12,699,346.05 12,932,988.74 13,166,631.43 13,400,274.12 13,633,916.81 13,867,559.50 14,101,202.19 14,334,844.88 14,568,487.57 14,802,130.26 117,025,883.41

NCF ($) (20,481,498.17) (7,782,152.12) 5,150,836.62 18,317,468.06 31,717,742.18 45,351,658.99 59,219,218.49 73,320,420.69 87,655,265.57 102,223,753.15 117,025,883.41

0 2 4 6 8 10 12

(40,000,000.00)

(20,000,000.00)

-

20,000,000.00

40,000,000.00

60,000,000.00

80,000,000.00

100,000,000.00

120,000,000.00

140,000,000.00

NCF ($)NPV 1 ($)NPV 2 ($)

110%

62,898,880.60

NPV - 0i1 - IRR

62,898,880.60 (-) IRR

62,898,880.60 (-) IRR

IRR

63.25%

Cash Flow ($) (20,481,498.17) 12,699,346.05 12,932,988.74 13,166,631.43 13,400,274.12 13,633,916.81 13,867,559.50 14,101,202.19

0% 10% 20% 30% 40% 50% 60% 70% 80% 90% (10,000,000.00)

-

10,000,000.00

20,000,000.00

30,000,000.00

40,000,000.00

50,000,000.00

60,000,000.00

70,000,000.00

NPV

NPV

14,334,844.88 14,568,487.57 14,802,130.26 117,025,883.41

IRRSales

72.10%80.94%89.77%98.59%

107.42%63.25%54.35%45.37%36.23%26.80%16.79%

-60% -40% -20% 0% 20% 40% 60%0.00%

20.00%

40.00%

60.00%

80.00%

100.00%

120.00%

Spider Curve Sales

Spider Curve Sales

Kebutuhan (kg/th) 1,782,495.84 15,930.92 12.00 36,306,483.30

Kebutuhan (kg/th) 1,281,362.96 217,618.27 7,920.00

Spesifikasidaya = 0.02 HP; d = 15.27 ft; material : SS

size = 473.3824 gal; material faktor : 1.7 (SS); se=0.53spaerical 30 psi; capacity : 118.9234 gal; material faktor = 2 (SS)size capacity = 1649.868 gal; se = 0.53; material factor = 1.7 (SS); open tank

capacity = 2.4054 t/h; material factor = 1.5 (SS); P=6 HPvolume = 619.1532 gal ; material factor (SS 316)= 1.2capacity = 1321 gal; se = 0.93; material factor = 1.39 (SS); panjang bucket = 16.4 ft; se bucket = 0.5capacity = 1321 gal; se = 0.93; material factor = 1.39 (SS); panjang bucket = 16.4 ft; se bucket = 0.6small package 150 psi; capacity = 24.08 HP; small package 150 psi; capacity = 14.5082 HP; A=77.5538ft2; materialfactor=2.341 (CS&SS); size exp=68;

filter area = 10.5767 ft²; se = 0.5

A=42.2758 ft2 ; size exp= 42.2758 ft2;A=42.2758 ft2 ; size exp= 42.2758 ft2;capacity = 1.2027 ton/h daya = 6.44 HP ; material factor=2 daya = 0.64 HP; material factor = 316 (S) =2daya= 2.13 HP ; material factor = 316 (S) = 2se:0,76 . Sf:2.1892 ; panjang = 16 ft ; size exp = 0.76 ; lebar = 59.0551 in ;size factor = 2.1892 ; daya = 18.24 HPse:0,76 . Sf:2.1892 ; panjang = 16 ft ; size exp = 0.76 ; lebar = 59.0551 in ;size factor = 2.1892 ; daya = 18.24 HPse:0,76 . Sf:2.1892 ; panjang = 16 ft ; size exp = 0.76 ; lebar = 59.0551 in ;size factor = 2.1892 ; daya = 18.24 HP

Asumsi : Gaji overtime 1.5 gaji pokok

TCI

Sisa Pinjaman

Cicilan ($) 1,331,297.38 1,331,297.38 1,331,297.38 1,331,297.38 1,331,297.38 1,331,297.38 1,331,297.38 1,331,297.38 1,331,297.38 1,331,297.38

Book Value ($) 17,702,045.68 14,161,636.54 11,329,309.23 9,063,447.39 7,250,757.91 5,800,606.33 4,640,485.06 3,712,388.05 2,969,910.44 2,375,928.35 -

Book Value ($) 18,702,045.68 14,961,636.54 11,969,309.23 9,575,447.39 7,660,357.91 6,128,286.33 4,902,629.06 3,922,103.25 3,137,682.60 2,510,146.08 1,000,000.00

Sales ($) 35,000,000.00 35,000,000.00 35,000,000.00 35,000,000.00 35,000,000.00 35,000,000.00 35,000,000.00 35,000,000.00 35,000,000.00 35,000,000.00

35,000,000.00

df 11

0.9090909090909090.8264462809917350.7513148009015780.6830134553650710.6209213230591550.5644739300537770.5131581182307070.4665073802097330.4240976183724850.385543289429531

NPV 1 ($) (20,481,498.17) (8,936,638.12) 1,751,782.32 11,644,067.40 20,796,634.93 29,262,224.59 37,090,100.41 44,326,246.79 51,013,557.72 57,192,018.61 62,898,880.60

280%

(4,295,910.74)

=

=

=

=

df IRR1

0.6125646662708810.3752354703635560.2298559906762480.140801658218959

0.08625012077728310.05283377644975960.0323641046387773

0.01982510695720850.0121441600270269

0.00743908333409592

Gaji Karyawan

Harga total (Rp/th) 14,259,966,744.00 47,792,765.43 1,200,000.00 -

Harga total (Rp/th) 896,954,073.40 652,854,804.60 7,524,000.00

LiteraturDonald E. Garret

Donald E. GarretDonald E. GarretDonald E. GarretDonald E. GarretDonald E. GarretDonald E. GarretDonald E. GarretDonald E. GarretDonald E. GarretDonald E. GarretDonald E. Garret

Donald E. GarretDonald E. GarretDonald E. GarretDonald E. GarretDonald E. GarretDonald E. GarretDonald E. GarretDonald E. GarretDonald E. Garret

Bunga ($) 3,594,502.93 3,235,052.64 2,875,602.34 2,516,152.05 2,156,701.76 1,797,251.46 1,437,801.17 1,078,350.88 718,900.59 359,450.29

BP(tanpa depresiasi) ($) 16,415,731.61 16,056,281.32 15,696,831.03 15,337,380.73 14,977,930.44 14,618,480.15 14,259,029.85 13,899,579.56 13,540,129.27 13,180,678.98

Present Value 1 ($) (20,481,498.17) 11,544,860.05 10,688,420.45 9,892,285.07 9,152,567.53 8,465,589.67 7,827,875.81 7,236,146.38 6,687,310.93 6,178,460.88 5,706,861.99 62,898,880.60

NPV 2 ($) (20,481,498.17) (13,426,305.92) (9,434,642.73) (7,176,989.88) (5,900,481.52) (5,178,945.34) (4,771,222.53) (4,540,893.54) (4,410,812.81) (4,337,367.86) (4,295,910.74)

NPV 1 - NPV 2i1 - i2

67,194,791.34 -70%

(95,992,559.05)

75.52%

Present Value 1 ($) (20,481,498.17) 7,779,170.68 4,852,916.11 3,026,429.11 1,886,780.82 1,175,926.97 732,675.54 456,372.78

284,189.83 176,922.04 110,114.28 0.00

Harga Sekarang (Rp) 15,072,545,854.55 50,516,152.06 1,268,379.89 - 15,124,330,386.50

Harga Sekarang (Rp) 948,065,422.83 690,056,586.76 7,952,741.90 1,646,074,751.49

Data

T=30°C; tek. Desin=1.31; capacity = 0.54 m³T=30°C; tek. Desin=1.44; capacity = 6.23 m³T=30°C; tek. Desin=1.31; capacity = 4.58 m³laju umpan = 24 lembar/jampanjang = 2.5m; tinggi = 1.25m; lebar = 0.75mpanjang = 5m; lebar = 1m; kedalaman = 1m; ukuran bucket = 6x4 inpanjang = 5m; lebar = 1m; kedalaman = 1m; ukuran bucket = 6x4 in

A = 145.08 ft²; panjang tube = 12 ft; jumlah tube = 15panjang tube = 12 ft; BWG = 12 ;Do tube =0.75 in; Di tube = 0.532 in; n=52; Di shell = 10 in ; tebal = 0.125 in

T=29°C; P=1.88 atm; capacity = 4.58 m³

T=30°C; tek. Desin=1.36; capacity = 1.49 m³

A = 240.88 ft²; panjang tube = 12 ft; jumlah tube = 26

panjang tube = 12 ft; BWG = 12 ;Do tube =0.75 in; Di tube = 0.532 in; n=52; Di shell = 10 in ; tebal = 0.125 inpanjang tube = 12 ft; BWG = 12 ;Do tube =0.75 in; Di tube = 0.532 in; n=52; Di shell = 10 in ; tebal = 0.125 inlaju umpan = 212 lembar/minlaju alir massa = 4501.25 kg/h ; v = 1.92 ft/s; efisiensi = 75%laju alir massa= 450.13 kg/h ; v =1.23 ft/s ; efisiensi=75%laju alir massa = 1488.62 kg/h ; v = 1.04 ft/s ; efisiesi = 75%tinggi =3 ft ; v = 100 ft/min; laju alir massa =2405.434 kg/htinggi =3 ft ; v = 100 ft/min; laju alir massa =2405.434 kg/htinggi =3 ft ; v = 100 ft/min; laju alir massa =2405.434 kg/h

Total ($) 4,925,800.31 4,566,350.02 4,206,899.72 3,847,449.43 3,487,999.14 3,128,548.85 2,769,098.55 2,409,648.26 2,050,197.97 1,690,747.67 33,082,739.92 3,308,273.99

Keuntungan Kotor ($) 18,584,268.39 18,943,718.68 19,303,168.97 19,662,619.27 20,022,069.56 20,381,519.85 20,740,970.15 21,100,420.44 21,459,870.73 21,819,321.02 202,017,947.06 20,201,794.71

df 21

0.5555555555555560.3086419753086420.171467764060357

0.09525986892242040.05292214940134460.02940119411185810.0163339967288101

0.009074442627116710.005041357015064840.00280075389725824

Harga Sekarang ($) 1,256,045.49 4,209.68 105.70 - 1,260,360.87

Harga Sekarang ($) 79,005.45 57,504.72 662.73 137,172.90

Harga Perkiraan ($)/unit Jumlah Harga Sekarang ($) 32,000.00 1 56,760.00

11,050.00 1 33,319.89 5,769.25 37 20,466.42 12,250.00 1 36,938.34 58,000.00 1 102,877.50 12,700.00 1 33,789.94 16,000.00 62 34,056.00 6,400.00 1 15,098.16 6,400.00 1 15,098.16 7,725.00 1 13,702.22 5,723.00 1 10,151.17 3,994.50 1 16,586.56

34,000.00 1 60,307.50 34,000.00 1 60,307.50 9,202.70 1 16,323.29 2,400.00 1 8,514.00 1,292.00 1 4,583.37 1,700.00 1 6,030.75 5,400.00 1 20,968.70 5,400.00 1 20,968.70 5,400.00 1 20,968.70

Depresiasi SL ($) Keuntungan Kena Pajak ($) Pajak ($) 1,770,204.57 16,814,063.82 5,884,922.34 1,770,204.57 17,173,514.11 6,010,729.94 1,770,204.57 17,532,964.41 6,136,537.54 1,770,204.57 17,892,414.70 6,262,345.14 1,770,204.57 18,251,864.99 6,388,152.75 1,770,204.57 18,611,315.29 6,513,960.35 1,770,204.57 18,970,765.58 6,639,767.95 1,770,204.57 19,330,215.87 6,765,575.55 1,770,204.57 19,689,666.16 6,891,383.16 1,770,204.57 20,049,116.46 7,017,190.76

184,315,901.39 64,510,565.48 18,431,590.14

Present Value 2 ($) (20,481,498.17) 7,055,192.25 3,991,663.19 2,257,652.85 1,276,508.36 721,536.18 407,722.81 230,328.99 130,080.73 73,444.95 41,457.12 (4,295,910.74)

I

Harga Total ($) Keterangan (asumsi) 56,760.00

33,319.89 757,257.56 36,938.34 102,877.50 33,789.94 2,111,472.00 Reaktor 15,098.16 Tangki flat top and bottom tipe stainless steel (gal US) 15,098.16 T-05=T-06 13,702.22 10,151.17 16,586.56 Double Pipe

60,307.50 60,307.50 16,323.29 8,514.00 4,583.37 Ekstrapolasi 6,030.75 20,968.70 20,968.70 20,968.70 3,422,024.02

Keuntungan Bersih ($) Cash Flow ($) 10,929,141.48 12,699,346.05 11,162,784.17 12,932,988.74 11,396,426.86 13,166,631.43 11,630,069.55 13,400,274.12 11,863,712.24 13,633,916.81 12,097,354.94 13,867,559.50 12,330,997.63 14,101,202.19 12,564,640.32 14,334,844.88 12,798,283.01 14,568,487.57 13,031,925.70 14,802,130.26 119,805,335.90 137,507,381.58 21,782,788.35 25,001,342.11