Originally Posted by cahlersmeyer
Just found this thread, so glad it exists.
I'm looking into comparing the cost of buying a Soda Stream machine vs buying soda from the store. I'm trying to figure out how many bottles I have to make in order for me to make the 79.99 machine and flavoring supplies worth it vs buying soda from the store. I've seen this excel sheet before, and did it my freshman year in college in my ISOM class, but don't know what its called? Any ideas?
lol It's a linear equation. Dude, you're in college?
[(Cost to purchase Soda @ store)*(# of Sodas consumed per year)] = [(Cost of Soda Stream $79.99)+((Cost to create each soda)* (# of Sodas consumed per year))]
Some of the variables could be slightly more complicated. Cost to create soda could be flavoring supplies and bottles, bottles would be another fixed cost. You will need to make sure the ounce cost is the same. I don't know if you buy cans, pints, or liter bottles, or if the soda stream can create various sizes that match your normally purchased size.
If the right side is less than the left side, buy the soda machine. If not, do not buy it.
This really doesn't need excel.Edited by Bhowie - 1/3/12 at 7:27am