Sheet1AVOCADO JUICESTAR FRUIT JUICESATUAN : CUP/GELAS ( 300 ML )SATUAN : CUP/GELAS ( 300 ML )BASIC COST$4,090COGS$4,295BASIC COST$2,210COGS$2,321OTHER ( 5 % )$205HARGA JUAL$15,000OTHER ( 5 % )$111HARGA JUAL$8,000COGS/HARGA29%COGS/HARGA29%NONAMA BAHANQTYHARGA SATQTTTOTALNONAMA BAHANQTYHARGA SATQTTTOTAL1Alpukad15020gr$3,0001Buah Belimbing12011gr$1,3202Gula pasir4011gr$4402Gula pasir4011gr$4403ice cube1503gr$4503ice cube1503gr$4504Susu coklat1020ml$2000.0total$4,090total$2,210APPLE JUICEMANGO JUICESATUAN : CUP/GELAS ( 300 ML )SATUAN : CUP/GELAS ( 300 ML )BASIC COST$4,790COGS$5,030BASIC COST$1,730COGS$1,817OTHER ( 5 % )$240HARGA JUAL$15,000OTHER ( 5 % )$87HARGA JUAL$8,000COGS/HARGA34%COGS/HARGA23%NONAMA BAHANQTYHARGA SATQTTTOTALNONAMA BAHANQTYHARGA SATQTTTOTAL1Apel fuji13030gr$3,9001Buah Mangga1207gr$8402Gula pasir4011gr$4402Gula pasir4011gr$4403ice cube1503gr$4503ice cube1503gr$4500.00.0total$4,790total$1,730STRAWBERY JUICEKIWI JUICESATUAN : CUP/GELAS ( 300 ML )SATUAN : CUP/GELAS ( 300 ML )BASIC COST$4,090COGS$4,295BASIC COST$4,890COGS$5,135OTHER ( 5 % )$205HARGA JUAL$15,000OTHER ( 5 % )$245HARGA JUAL$15,000COGS/HARGA29%COGS/HARGA34%NONAMA BAHANQTYHARGA SATQTTTOTALNONAMA BAHANQTYHARGA SATQTTTOTAL1Buah Strawbery8040gr$3,2001Buah Kiwi5080gr$4,0002Gula pasir4011gr$4402Gula pasir4011gr$4403ice cube1503gr$4503ice cube1503gr$4500.00.0total$4,090total$4,890RED GUAVA JUICEDRAGON FRUIT JUICESATUAN : CUP/GELAS ( 300 ML )SATUAN : CUP/GELAS ( 300 ML )BASIC COST$2,090COGS$2,195BASIC COST$3,650COGS$3,833OTHER ( 5 % )$105HARGA JUAL$8,000OTHER ( 5 % )$183HARGA JUAL$13,000COGS/HARGA27%COGS/HARGA29%NONAMA BAHANQTYHARGA SATQTTTOTALNONAMA BAHANQTYHARGA SATQTTTOTAL1Buah Jambu Merah1508gr$1,2001Buah Naga12023gr$2,7602Gula pasir4011gr$4402Gula pasir4011gr$4403ice cube1503gr$4503ice cube1503gr$4500.00.0total$2,090total$3,650MELON JUICEWATERMELON JUICESATUAN : CUP/GELAS ( 300 ML )SATUAN : CUP/GELAS ( 300 ML )BASIC COST$2,090COGS$2,195BASIC COST$2,690COGS$2,825OTHER ( 5 % )$105HARGA JUAL$10,000OTHER ( 5 % )$135HARGA JUAL$10,000COGS/HARGA22%COGS/HARGA28%NONAMA BAHANQTYHARGA SATQTTTOTALNONAMA BAHANQTYHARGA SATQTTTOTAL1Buah Melon1508gr$1,2001Buah Semangka3006gr$1,8002Gula pasir4011gr$4402Gula pasir4011gr$4403ice cube1503gr$4503ice cube1503gr$4500.00.0total$2,090total$2,690WORTEL JUICERED GRAPE JUICESATUAN : CUP/GELAS ( 300 ML )SATUAN : CUP/GELAS ( 300 ML )BASIC COST$1,890COGS$1,985BASIC COST$8,090COGS$8,495OTHER ( 5 % )$95HARGA JUAL$10,000OTHER ( 5 % )$405HARGA JUAL$18,000COGS/HARGA20%COGS/HARGA47%NONAMA BAHANQTYHARGA SATQTTTOTALNONAMA BAHANQTYHARGA SATQTTTOTAL1Buah Wortel10010gr$1,0001Buah Anggur Merah12060gr$7,2002Gula pasir4011gr$4402Gula pasir4011gr$4403ice cube1503gr$4503ice cube1503gr$4500.00.0total$1,890total$8,090ORANGE JUICESATUAN : CUP/GELAS ( 300 ML )BASIC COST$3,490COGS$3,665OTHER ( 5 % )$175HARGA JUAL$15,000COGS/HARGA24%NONAMA BAHANQTYHARGA SATQTTTOTAL1Jeruk sunkis10026gr$2,6002Gula pasir4011gr$4403ice cube1503gr$4500.0total$3,490

Sheet2

Sheet3