Tuesday, January 26, 2010

Year Supply

There is a great food storage calculator HERE from providentliving.org.
(I divided the wheat and rice in half and added other grains to the total just because I have such big eaters at my house.)

I found if I use some simple functions in excel, I can easily inventory and keep track of what I have and what I need. I have the totals broken down into 3 month amounts. I started off by gathering a 3 month supply of each item. Once I had this, I started working up to a 6 month supply. Next I will work to 9 month etc. until I reach the year supply goal.

Here is part of my spreadsheet...


On Hand

3 mo. 6 mo. 9 mo. 12 mo.

Total





Wheat 570 lbs.
187.5 375 562.5 750
Rice 418.8 lbs.
187.5 375 562.5 750
Rolled Oats 27.9 lbs.
7 15 22 30
Pasta 34.6 lbs.
10 20 30 40
Beans 89.12 lbs.
75 150 225 300
Popcorn 8 lbs.