Who is rich?

My wife and I decided to start keeping a well stocked pantry for convenience, savings by buying in bulk and in case of emergency like a hurricane. That evolved into something a little more because once I started researching the subject of being prepared for emergencies, I discovered some reasons other than weather for storing food. Some are tin foil conspiracy theories and some are reality based. A look at today’s economy with some people being unemployed for over two years should be reality enough. Here’s a spreadsheet I made up for food storage.

FoodPlan. Something I made up a while back.  The items in white are entered by you and the shaded gray are automatically calculated. This xls saves a whole lot of math as all you’re really doing is entering price paid, info from the label and estimating servings per day for each person. If you don’t have excel you can get OpenOffice which is open source and free. It will work with any MS Office files like Excel, Word, etc. BTW, do not remove the zeros. You’ll confuse excel. Hey, it’s an MS program so it’s easily confused.

Right now it’s mostly filled with data but you can simply overwrite that stuff. I’m going to some more work on it. I’m thinking of adding Cal from Fat and maybe cost per calorie for each item.
The best parts of it are the fact that it gives you cal/day for each person, you adjust the quantity to get you the desired 365 days, (it’s based on 365 but changing a formula or two will change that) total cost for one years worth is also divided by 365 and given as daily cost just below the years cost.

I don’t actually have everything on this list and I have some items not on the list. My items have changed but for kicks I adjusted all the quantities to get close to 365 days worth. You’ll notice that only meat on it is DAK ham. I have other meat now that I home can it. When I did this thing I was just using stuff that I consider cheap and long lasting (poorboy style) with the exception of easy mac. (Kraft mac & cheese packaged in single servings) There convenient.  It works out to $8.90 per day cost or $3247.75 for my family of 4 for a year. This is based on or works out to be 2400 cal/day for the adults and 2100 for the kids. 6 and 8 yrs old so probably more than they need. Some stuff is LTS and some is canned goods.

If someone needs it mildly reconfigured, like for more than 4 people let me know and I’ll do one up for you. It may seem a bit overkill but I wanted to know the calorie count for each person hence the servings per day column for each. Here’s an image of it. I tried to save it as an interactive html file from excel but the blog didn’t like it and just showed the code.

And here’s the XLS file foodplan.xls

One Response to “Food Plan Spreadsheet”