Sheet1noumur pakaiinflasisuku bungatahunIIC (Rp)(1+I)^t(1+r)AFC1150.10.0911000000001.11.097993333.333333332150.10.091200000001.11.091598666.666666673150.10.091100000001.11.09799333.3333333334150.10.091300000001.11.0923980005100.10.091100000001.11.0911990006100.10.09150000001.11.095995007100.10.091120000001.11.0914388008100.10.091150000001.11.0917985009100.10.091200000001.11.09239800010100.10.091200000001.11.09239800011100.10.091400000001.11.0947960001250.10.091120000001.11.0928776001350.10.091120000001.11.0928776001450.10.091100000001.11.0923980001550.10.0911000000001.11.0923980000jumlah biaya tetap59550333.333333316200000002000000012000000120000004000000400000060000006000000600000060000004000000400000080000008000000jumlah biaya variabel60000000biaya overhead119550333.333333taksiran jumlah satuan produk makanan109500biaya overhead per konsumen per hari1091.7838660578

Sheet2noaspek biayajumlah (rp)keterangan1biaya bahan makanan (food cost)19745.592biaya tenaga10207.13biaya overhead1091.783866biaya makanan per menu per hari (unit cost)31044.473866profit/margin 20%6208.8947732tarif/harga jual37253.3686392

Sheet3