Sheet1

Penaksiran indeks harga dengan Least SquareDataTahun (x)Ann Index (y)xyxy12007525.44028049276045.161054477.822008555.64032064308691.361115644.832009585.84036081343161.641176872.242010616.14040100379579.21123836152011646.34044121417703.691299709.362012676.54048144457652.25136111872013706.34052169498859.691421781.982014736.94056196543021.611484116.6160845048.9323369243224714.6110152081.6

n=8= x/n =2010.5= Y/n =631.11

(-x) =x - (x)/n=32336924-32336882=42y =5048.9 = y/n =631.11y =3224714.61(y-y) =y - (x)/n=3224714.61-3186423.90125=38290.7087499998xy =10152081.6

(-x)(y-) =xy - y * x/n=10152081.6-10150813.45=1268.1500000004Sehingga persamaannya menjadi :a = =631.11b = (-x)(y-)=1268.1500000004=30.19 (-x)42

Jadi,y =631.11+30.19(x-)y =631.11+30.19( x - 2010.5)Jika pabrik biodiesel didirikan pada tahun 2020 :Untuk x =2015maka y =631.11+30.19*4.5y =631.11+135.8732142858y =767.0Jadi, cost index pada tahun 2020 adalah 918.0Untuk x =2014maka y =736.9Untuk x =2015maka y =767.0

Sheet2Penaksiran indeks harga dengan Least SquareNOTAHUN (x)INDEKS (y)xyxy12007525.440280492760451054477.822008555.640320643086911115644.832009585.840360813431621176872.242010616.14040100379579123836152011646.340441214177041299709.362012676.54048144457652136111872013706.340521694988601421781.982014736.940561965430221484116.6160845048.9323369243224714.6110152081.6n=8=x/n2010.5=y/n631.1125

( - x)=x - (x)/n42y=5048.9=y/n631.1125y=3224714.61 (y - y)=y-(y)/n392337.808888888xy=10152081.6( - x)-(-y)=xy-yx/n1268.1500000004

a=631.1125b=( - x)-(-y)30.1940476191 ( - x)

jadi:y=a+b(x-)=766.9857142858jadi jika pabrik didirkan tahun 2015 (x) maka indeks harganya (y) 766.9857142858

Sheet3No.KodeNama AlatJumlahHarga (US $)Total 4BC-01Belt Conveyor 01111289.6513397.80Ey = harga alat pada tahun 20155BC-02Belt Conveyor 02 113372.2115869.25Ex = harga alat pada tahun referensi6BC-03Belt Conveyor 03 116986.1520158.03Ny = indek harga pada tahun 20157PC-01Pneumatic Conveyor 01 1226001.84268203.90Nx = indek harga pada tahun referensi 8PC-02Pneumatic Conveyor - 02 1257589.9305690.519SC-01Screw Conveyor 01 120042.6620042.6623785.2923785.29indeks tahun 2015767.010SC-02Screw Conveyor 02118330.6818330.6821753.6321753.63indeks tahun 2011646.311SC-03Screw Conveyor 03 117328.5517328.5520564.3720564.3712SC-04Screw Conveyor 04119332.8119332.8122942.8922942.8913SC-05Screw Conveyor 05117725.2217725.2221035.1121035.1114SC-06Screw Conveyor 06117328.5517328.5520564.3720564.3715CY-01Cyclone 01 124948.9324948.9329607.7329607.7316CY-02Cyclone 02133769.7933769.7940075.7340075.7317BF-01Bag Filter 01 13152.543152.543741.223741.2218BF-02Bag Filter 02 13152.543152.543741.223741.2219BF-03Bag Filter 0313152.543152.543741.223741.2220BF-04Bag Filter 0413152.543152.543741.223741.2221BF-05Bag Filter 05 13152.543152.543741.223741.2222BM-01Ball Mill 01 186538.3586538.35102697.94102697.9423BM-02Ball Mill 02 187060.2987060.29103317.34103317.3424BM-03Ball Mill 03 190223.2790223.27107070.96107070.9625BM-04Ball Mill 04186538.3586538.35102697.94102697.9426SC-01Screen 01 137661.4137661.4144694.0544694.0527SC-02Screen 02 135012.0235012.0241549.9341549.9328SC-03Screen 03 140262.7840262.7847781.1847781.1829SC-04Screen 04 137661.4137661.4144694.0544694.0530BinBin 114457.8514457.8517157.6117157.6131SiloSilo 1146360.46146360.46173690.83173690.8332GC-01Grate Cooler 01 138509.0438509.0445699.9645699.9633GC-02Grate Cooler 02 251119.21102238.4260664.87121329.7334P-01Pompa 01 18225.848225.849761.889761.8835P-02Pompa 02 18977.448977.4410653.8310653.8336P-03Pompa 0316868.796868.798151.428151.4237P-04Pompa 0418977.448977.4410653.8310653.8338P-05Pompa 0519353.249353.2411099.8011099.8039F-01Fan - 0118069.268069.269576.069576.0640F-02Fan 0218069.268069.269576.069576.0641F-03Fan 0318069.268069.269576.069576.0642F-04Fan 0418069.268069.269576.069576.0643F-05Fan 0518069.268069.269576.069576.0644F-06Fan 0618069.268069.269576.069576.0645F-07Fan 0718069.268069.269576.069576.0646F-08Fan 0818069.268069.269576.069576.0647F-09Fan 09 18069.268069.269576.069576.0648F -10Fan 10 18069.268069.269576.069576.0647RReaktor 191235.8591235.85108272.62108272.6248RDFRotary Drum Filter1117750.61117750.61139738.57139738.5750RK-01Rotary Kiln 01 12739267.532739267.533250779.923250779.9251RK-02Rotary Kiln 02 13266274.593266274.593876196.733876196.7352HEHeat exchanger145826.745826.754384.0754384.0753T H2OTangki H2O1450751.01450751.01534921.22534921.2254BE-01Bucket Elevator 01 120251.4320251.4324033.0524033.0555BE-02Bucket Elevator 02 123330.9123330.9127687.5727687.57Total8.622.133,989956831.33

Sheet4HARGA ALAT TAHUN 2015No.KodeNama AlatJumlahHarga (US $)Total 1BC-01Belt Conveyor 01113397.802BC-02Belt Conveyor 02 115869.253BC-03Belt Conveyor 03 120158.034PC-01Pneumatic Conveyor 01 1268203.905PC-02Pneumatic Conveyor - 02 1305690.516SC-01Screw Conveyor 01 123785.2923785.297SC-02Screw Conveyor 02121753.6321753.638SC-03Screw Conveyor 03 120564.3720564.379SC-04Screw Conveyor 04122942.8922942.8910SC-05Screw Conveyor 05121035.1121035.1111SC-06Screw Conveyor 06120564.3720564.3712CY-01Cyclone 01 129607.7329607.7313CY-02Cyclone 02140075.7340075.7314BF-01Bag Filter 01 13741.223741.2215BF-02Bag Filter 02 13741.223741.2216BF-03Bag Filter 0313741.223741.2217BF-04Bag Filter 0413741.223741.2218BF-05Bag Filter 05 13741.223741.2219BM-01Ball Mill 01 1102697.94102697.9420BM-02Ball Mill 02 1103317.34103317.3421BM-03Ball Mill 03 1107070.96107070.9622BM-04Ball Mill 041102697.94102697.9423SC-01Screen 01 144694.0544694.0524SC-02Screen 02 141549.9341549.9325SC-03Screen 03 147781.1847781.1826SC-04Screen 04 144694.0544694.0527BinBin 117157.6117157.6128SiloSilo 1173690.83173690.8329GC-01Grate Cooler 01 145699.9645699.9630GC-02Grate Cooler 02 260664.87121329.7331P-01Pompa 01 19761.889761.8832P-02Pompa 02 110653.8310653.8333P-03Pompa 0318151.428151.4234P-04Pompa 04110653.8310653.8335P-05Pompa 05111099.8011099.8036F-01Fan - 0119576.069576.0637F-02Fan 0219576.069576.0638F-03Fan 0319576.069576.0639F-04Fan 0419576.069576.0640F-05Fan 0519576.069576.0641F-06Fan 0619576.069576.0642F-07Fan 0719576.069576.0643F-08Fan 0819576.069576.0644F-09Fan 09 19576.069576.0645F -10Fan 10 19576.069576.0646RReaktor 1108272.62108272.6247RDFRotary Drum Filter1139738.57139738.5748RK-01Rotary Kiln 01 13250779.923250779.9249RK-02Rotary Kiln 02 13876196.733876196.7350HEHeat exchanger154384.0754384.0751T H2OTangki H2O1534921.22534921.2252BE-01Bucket Elevator 01 124033.0524033.0553BE-02Bucket Elevator 02 127687.5727687.57Total9956831.33

Sheet5 Perhitungan Production Cost (Biaya Produksi)1US122151.Biaya Pembelian Alat (Purchased Equipment Cost (PEC))PECPersen (%) TetapanUSHarga alat (EC)9956831.33a) Biaya pengangkutan sampai ke pelabuhan201991366.2655956b) Asuransi Pengangkutan199568.3132797802c) Provisi bank0.549784.1566398901d) EMKL199568.3132797802e) Pajak bea masuk barang201991366.2655956Total Purcharsed Equipment Cost (PEC)14188484.64

2.Biaya Instalasi Alat (Equipment Installation Cost)EICPersen (%) TetapanUSManhourMaterial111560733.31066055Labor32227015.754277899Tenaga asing 511350.7877138949Tenaga Indonesia95215664.966564004Total biaya instalasi1787749.06493845

3.Biaya Pemipaan (Piping cost)PCPersen (%) TetapanUSManhourMaterial81135078.77138949Labor642565.453927106Tenaga asing 542565.453927106Tenaga Indonesia95198627.169369222Total biaya pemipaan1376271.39468582

4.Biaya Instrumentasi (Instrumentation Cost)Instrumentation CostPersen (%) TetapanUSManhourMaterial121702618.15708424Labor321282.726963553Tenaga asing 521282.726963553Tenaga Indonesia9599313.5846846109Total biaya 1823214.4687324

5.Biaya Isolasi (Insulation Cost)Insulation CostPersen (%) TetapanUSManhourMaterial3425654.53927106Labor535471.2116059217Tenaga Indonesia10058078.1196986028Total biaya 483732.658969663

6.Biaya Instalasi Listrik (Electrical Installation Cost)Electrical Instalation CostPersen (%) TetapanUSManhourMaterial7993193.924965807Labor321282.726963553Tenaga Indonesia10058078.1196986028Total biaya 1051272.04466441

7.Biaya Bangunan (Buildings Cost)9510869.57

8.Tanah dan PerbaikanPersen (%) TetapanUS101418848.464236879.Biaya Utilitas (Utilities Cost)Persen (%) TetapanUS405675393.8569474710.Environmental CostPersen (%) TetapanUS101418848.46423687

No.Physical Plant CostUS $1Purchased Equipment Cost14188484.642Instalasi Alat1787749.064938453Pemipaan1376271.394685824Instrumentasi1823214.46873245Insulasi483732.6589696636Listrik1051272.044664417Bangunan9510869.578Tanah 5675393.856947479Utilitas5675393.8569474710Environment1418848.46423687Total1418848.4642368711.Engineering and CostructionPersen (%) TetapanUS20283769.692847373

DPC1702618.1570842412.Contractors FeePersen (%) TetapanUS468104.726283369613.ContingencyPersen (%) TetapanUS10170261.81570842414.Plant Star Up CostPersen (%) TetapanUS799319.3924965807

Fixed Capital Investment (FCI)2040304.09157262

Sheet6