Sheet1

No. Deskripsi Unit Volume Unit Price (Rp) Total Cost (Rp/Tahun) 1. Bahan Baku: Telur kg 3,00017,00051,000,000Kacang hijau kg 30018,0005,400,000Terigu kg 7507,0005,250,000Tepung jagung kg1506,000900,000Kacang Otok kg30026,0007,800,000Baking powder kg37.515,000562,500Ovalet sachet3,7502,5009,375,000Pewarna makanan botol3002,000600,000Susu bubuk kg 19570,00013,650,000Margarin kg60016,0009,600,000Kertas roti lembar2,5001,0002,500,000Gula kg1,05010,00010,500,000Plastik corong pak3005,0001,500,000Pisang buah 30,00080024,000,000Vanili sachet 7,5002001,500,000Buah naga kg 15015,0002,250,000Jumlah 146,387,500

No. Deskripsi Unit Volume Unit Price (Rp) Total Cost (Rp/Tahun) 2. Bahan Bakar 130075,000225000003. Kemasan : 0a. Mika pcs 15,0002,50037500000b. Sticker lembar 15,0005007500000c. Pisau plastik pcs 15,00050075000004. Operating labour (3 orang) Rp 90040,00036000000Jumlah 111000000257,387,500No. Deskripsi Unit Volume Unit Price (Rp) Total Cost (Rp/Tahun) 1. Air M3 1501,1001650002. Listrik : Kwh 1,2001,49617952003. Penyusutan Rp 11,171,90011719003132100

Sheet2

No. Jenis alat Jumlah (Unit) Harga (Rp/Unit) Jumlah Investasi (Rp) Umur Ekonomis (tahun) Penyusutan (Rp) 1. Oven 16,000,0006,000,00015400,0002. Tabung LPG 2450,000900,0001560,0003. Regulator 250,000100,000520,0004. Selang 225,00050,000510,0005. Planetary Mixer 15,150,0005,150,00010515,0006. Loyang 515,00075,000175,0007. Timbangan kue digital 1179,000179,0001017,9008. Solet 32,0006,0000.512,0009. Sendok 122,00024,000212,00010. Teflon 175,00075,000515,00011. Kuas 25,00010,000110,00012. Baskom 102,50025,000125,000Jumlah 12,594,0001,171,900

Sheet3No. Deskripsi Unit Volume Unit Price (Rp) Total Cost (Rp/Tahun) 1. Bahan Baku: Telur kg 5,62517,00095,625,000Kacang hijau kg 30018,0005,400,000Terigu kg 7507,0005,250,000Tepung jagung kg1506,000900,000Kacang Otok kg30026,0007,800,000Baking powder kg37.515,000562,500Ovalet sachet3,7502,5009,375,000Pewarna makanan botol3002,000600,000Susu bubuk kg 19570,00013,650,000Margarin kg60016,0009,600,000Kertas roti lembar2,5001,0002,500,000Gula kg1,05010,00010,500,000Plastik corong pak3005,0001,500,000Pisang buah 30,00080024,000,000Vanili sachet 7,5002001,500,000Buah naga kg 15015,0002,250,000191,012,500No. Deskripsi Unit Volume Unit Price (Rp) Total Cost (Rp/Tahun) 2. Bahan Bakar 130075,000225000003. Kemasan : a. Mika pcs 15,0002,5003750000052500000b. Sticker lembar 15,0005007500000c. Pisau plastik pcs 15,00050075000004. Operating labour (3 orang) Rp 90040,00036000000Jumlah 302,012,500

Sheet4

Tahun Revenue Cost Net Benevit DF 16% NPV 0026,594,000-26,594,0001-265940001450,000,000305,144,600144,855,4000.862124865354.82450,000,000305,144,600144,855,4000.743107627562.23450,000,000305,144,600144,855,4000.64192852311.44450,000,000305,144,600144,855,4000.55279960180.85450,000,000305,144,600144,855,4000.47668951170.415,000,00045,744,0003,703,767165,000447662579.62,000,0001,795,20023,744,0001,743,5675,000,000(Rp0.06)

Tahun Net Benevit DF 16% NPV DF 85% NPV 85 800,0001,743,56712,000,00023,744,0000-26,594,0001-26,594,0001-2659400060,000900,0001144,855,4000.862124865354.80.5417836677120,000100,0002144,855,4000.743107627562.20.2924229777710,00050,0003144,855,4000.64192852311.40.15822887153686,66710,300,0004144,855,4000.55279960180.80.0851231270975,00075,0005144,855,4000.47668951170.40.046666334817,900179,00044766258012,0006,00012,00024,00015,00075,00010,00010,00025,00025,000