I'm working on this myself. I've got a little over a month's supply of water for my family that is kept in Aqua Tainer (7 gallon) jugs. We drink a lot of water anyway, so I just keep rotating the jugs so the supply stays fresh. I'm working on some sort of numbering system so I don't have to lug those 56 pound jugs any more than I have to, and still keep the rotation.

I also have cases of bottled water for bugging out and rotate these as well. Each case is a three day supply for one person.

Still building up the food reserves, although I have a nice start. I've built up a supply of canned food that we eat on a regular basis and have been rotating that too. I don't buy things that my family doesn't eat regularly for a "just in case" situation, because it will go to waste. I don't have to think about hauling it to the local food bank before it expires either. I'm still working out how much food to have. To match the water reserves, I want to have at least one month of food. This takes a bit more calculation. I plan to figure out a month's worth of meal plans, like "how many meals will I really eat green beans in one month?" and then figure out the numbers of each type of canned food I need. I keep this list seperate from the "working pantry" in the kitchen. My reserve items are kept in the basement. I haven't finished analyzing the types of canned food, for example, how many cans of condensed soup I have versus ready to eat soup, but I'm working on it.

I don't have any MREs yet, but I'm thinking that I'll reserve those for the cars mostly, along with energy bars and some other choices.

I also plan to keep a list of what I have where and in what quantities, so I always know what I have and what I need to restock. I need to write down my way of thinking too, as to rationing so that in case my family needs to use the reserves and I'm not around, they'll know what I had in mind.

I'd be interested in what other people are doing too.

And if you get that spread sheet worked out, maybe send a copy my way. I'm not too handy with setting those up <img src="/images/graemlins/smile.gif" alt="" />

I've been writing expiration dates on the top lid of the can with a permenant marker. If a date is not on the can, I just date it for one year from the month I purchased it. Do a search for "expiration dates" because Sue made an interesting post recently. Even though I rotate frequently, I put the dates on there, because I've found too much funky stuff in my in-laws' fridge and cupboards to NOT pay attention to them! <img src="/images/graemlins/grin.gif" alt="" />
_________________________
Ors, MAE, MT-BC
Memento mori
Vulnerant omnes, ultima necat (They all wound, the last kills)