Long Term Food Storage Calculator

We’re so excited to be giving you, your very own Long Term Food Storage Calculator. By simply inputting the number of adults (including children over 7) and children under 7 into the spreadsheet, you will automatically have a printout that tells you the quantities of Long Term Food Storage you will need to store. From there you can also put in prices and use it as an inventory tracker of what you have versus and what you still need … all in one place!

This is a very simple yet handy food storage calculator to help you easily determine how much food you need to store, and keep track of how your Long Term Food Storage is coming along. Download it today and enjoy! Remember to read our post from last week on Long Term Food Storage Lies Debunked to help you avoid getting overwhelmed as you start on your Long Term Food Storage!

So here it is (the food storage calculator is based on a ONE YEAR supply):

Food Storage Calculator

Please note for the Cost/Unit column (column H) you need to put the cost/unit, meaning cost per pound, or cost per qt whatever that may be – in that cell. Everyone will have different prices so that is a user entered cell. If you want to do the math right in excel, the special formula is =cost/unit. So if you paid $11 for 50 lbs of wheat, you put =11/50.

If you don’t have excel you can print out our pdf worksheet (instructions included) and fill it out by hand.

Hope you enjoy

Jodi and Julie March 9, 2009 80 Comments

http://inventoryspreadsheet.net/ Chris

Cool. I’ve used spreadsheets business tracking but never considered using one for food. Very clever.
Pingback: Our World » Food Storage Dos and Don’ts
Pingback: The Case For Food Storage | Car Storage
Pingback: Preparedness: 3-Ways to Stock Up On Wheat | Planned Resilience
Pingback: Survival Web Links | Survive2, Home of The Guide To Living
Raeeldri

At times as these this information will prove to be valuable.
http://www.bestfoodstorages.com/good-food-container/ risa hamfry

hai… this is very important information. thank you..:-)
Pingback: Food Storage Dos and Don’ts » buildyourfoodstorage.com
LindaGF

This is fantastic!!! Do you have any resources or links to “other” items to store in case of an incident? Wondering if there is the same sort of calculator for household necessities such as toilet paper, toothpaste, soap, laundry soap, first aid items, dog food, etc…..
BTW…. I LOVE THIS SITE! I have arranged for a local woman to instruct our 9.12 group on food storage. Your site and info within will be part of the presentation…. THANK YOU, Linda
- http://foodstoragemadeeasy.net Jodi – Food Storage Made Easy
  
  On our three month supply spreadsheet found under BabyStep 3, we have a bonus sheet for non-food items. Hopefully that helps a bit!
Pingback: Food Storage Dos and Don’ts | 2010 Black Friday Specials at the lowest price any.
Pingback: Food Storage – Explained
Pingback: » How to Get Started With Your Food Storage Kylie Neeld
http://www.heloccalculatorpayment.com/ Td Heloc Interest Rate

HELOC interest rate/balance?
It looks like I am going to be out of work on minimal disability paymeents for awhile-

if I get a $20,000 HELOC–can I use it as I need it–and only pay interest on the amount I have actually used?
Timber

Thank you for this worksheet!!!! It is SO helpful!!! I really appreciate it!
Timber

Thank you for this worksheet!!!! It is SO helpful!!! I really appreciate it!
Timber

Thank you for this worksheet!!!! It is SO helpful!!! I really appreciate it!
http://foodstoragemadeeasy.net Jodi – Food Storage Made Easy

If you want to send us the file to info@foodstoragemadeeasy.net we can make the converted file available on our site. Thanks for doing that!
Anonymous

Hi! I just love the worksheet!. I live in Argentina and here we use the metric system, so I’ve changed it into kilograms and litres… if anyone needs it, just let me know!
- http://foodstoragemadeeasy.net Jodi – Food Storage Made Easy
  
  If you want to send us the file to info@foodstoragemadeeasy.net we can make the converted file available on our site. Thanks for doing that!
  - Craig
    
    Is a metric copy available?
    - http://foodstoragemadeeasy.net Jodi – Food Storage Made Easy
      
      Unfortunately, we don’t have one yet. We have it on our list of things to work on.
- Lisa-maree Nakon
  
  yes please email to lisa-maree.nakon@ferndale.school.nz
ceciliahaedo

Hi! I just love the worksheet!. I live in Argentina and here we use the metric system, so I've changed it into kilograms and litres… if anyone needs it, just let me know!
Anonymous

Excellent worksheet. Just what I was looking for. You ROCK!
greggandshandy

Excellent worksheet. Just what I was looking for. You ROCK!
http://foodstoragemadeeasy.net Jodi – Food Storage Made Easy

The recommendation is 1 gallon per person per day. Getting a full year supply is not very feasible. We recommend 2 week supply at a minimum.
http://foodstoragemadeeasy.net Jodi – Food Storage Made Easy

The recommendation is 1 gallon per person per day. Getting a full year supply is not very feasible. We recommend 2 week supply at a minimum.
Anonymous

How much water should you have stored for a year for a family of 4
- http://foodstoragemadeeasy.net Jodi – Food Storage Made Easy
  
  The recommendation is 1 gallon per person per day. Getting a full year supply is not very feasible. We recommend 2 week supply at a minimum.
- http://foodstoragemadeeasy.net Jodi – Food Storage Made Easy
  
  The recommendation is 1 gallon per person per day. Getting a full year supply is not very feasible. We recommend 2 week supply at a minimum.
  - Drivy19
    
    In addition to “stored water”, we have a 15,000 gallon cistern that is fed from rainfall on the roof of our home. A rain gutter system from both sides of the roof is connected at a single junction, filtered, and then is directed into the cistern. A normal rainy season is more than adequate to re-supply whatever is to be used….
Toolip12

How much water should you have stored for a year for a family of 4
Garry Stutz

Love your site. Next month I am launching a site called Preparedness Network which will feature the best prepardness resources and products. You have such good content that I would like to include your site. Do you pay an affiliate commission for the sale of your binder and other products? Would like to discuss this with you if interested.

Garry Stutz
Garry Stutz

Love your site. Next month I am launching a site called Preparedness Network which will feature the best prepardness resources and products. You have such good content that I would like to include your site. Do you pay an affiliate commission for the sale of your binder and other products? Would like to discuss this with you if interested.

Garry Stutz
http://southernutahfoodstorage.com/ Emma

Good luck with your business ventures. You are great. Love to chat with you sometime, about food storage, rotation and meal preparation. I am starting a website to share my idea. Not read for prime time.
http://southernutahfoodstorage.com/ Emma

Good luck with your business ventures. You are great. Love to chat with you sometime, about food storage, rotation and meal preparation. I am starting a website to share my idea. Not read for prime time.
Anonymous

I suggest that you also include information (or links to ) seed saving. If there is a “incident” in the future that interupts food supply, the people to survive will be the ones with Horticultural knowledge, not food knowledge (LDS notwithstanding).
Saving seeds has been an important tradition (and survival necessity) until the Post WWII generation. The under 30 crowd is very ignorant about saving and maintaining a strong seed base of grains, vegetables, fruits.
Additionaly, very few people know how to keep Bees, or alternative insects, to pollinate crops.
I am literate in both areas, and will never fear going hungry because of an incident.
curataetindustria

I suggest that you also include information (or links to ) seed saving. If there is a “incident” in the future that interupts food supply, the people to survive will be the ones with Horticultural knowledge, not food knowledge (LDS notwithstanding).
Saving seeds has been an important tradition (and survival necessity) until the Post WWII generation. The under 30 crowd is very ignorant about saving and maintaining a strong seed base of grains, vegetables, fruits.
Additionaly, very few people know how to keep Bees, or alternative insects, to pollinate crops.
I am literate in both areas, and will never fear going hungry because of an incident.
Kathy D

Alissa, does your family eat cheese and yogurt, or do you use evaporated milk and condensed milk for cooking or baking? The extra dry milk powder can be used to make any of these. We aren't big milk drinkers but we do eat a lot of other dairy products.
http://foodstoragemadeeasy.net Melissa

I have the same question as Leigh. Do you have a 3 month supply and a 12 month supply (which is really a 15 month supply)? Also, can you just substitute lb for lb items on the worksheet that you don’t use? For example, we don’t use evaporated milk so can I just add the recommended amt (lbs) to the nonfat milk that I do use? I love the site and feel FANTASTIC because I am finally tackling my food storage!
http://foodstoragemadeeasy.net Melissa

I have the same question as Leigh. Do you have a 3 month supply and a 12 month supply (which is really a 15 month supply)? Also, can you just substitute lb for lb items on the worksheet that you don’t use? For example, we don’t use evaporated milk so can I just add the recommended amt (lbs) to the nonfat milk that I do use? I love the site and feel FANTASTIC because I am finally tackling my food storage!
Chris

Can I ask you for the download for the font you used on this page. I LOVE it, but don’t have it installed on my computer. Mine is coming up in Ariel and I can’t stand it. Silly I know, but that’s my request. Thanks for all your hard work!!!
Chris

Can I ask you for the download for the font you used on this page. I LOVE it, but don’t have it installed on my computer. Mine is coming up in Ariel and I can’t stand it. Silly I know, but that’s my request. Thanks for all your hard work!!!
jweiss08

Alissa and Sarah
We’re going to do a post shortly on this question – along with a way for you to customize the calculator to store foods to better fit the way your family uses and eats it.
jweiss08

Alissa and Sarah
We’re going to do a post shortly on this question – along with a way for you to customize the calculator to store foods to better fit the way your family uses and eats it.
Alissa

This is really cool. I tried making my own and it didn’t turn out quite as awesome as yours. I am curious how you came up with some of the yearly amounts. For example your milk is 60 lbs per adult…the LDS church says 16 lbs per adult for one glass a day. Do you really need 44 more lbs for cooking? Just curious where you got your numbers from so I can compare and decide what my family should store/do from that and what the church says.
Alissa

This is really cool. I tried making my own and it didn’t turn out quite as awesome as yours. I am curious how you came up with some of the yearly amounts. For example your milk is 60 lbs per adult…the LDS church says 16 lbs per adult for one glass a day. Do you really need 44 more lbs for cooking? Just curious where you got your numbers from so I can compare and decide what my family should store/do from that and what the church says.
- Kathy D
  
  Alissa, does your family eat cheese and yogurt, or do you use evaporated milk and condensed milk for cooking or baking? The extra dry milk powder can be used to make any of these. We aren’t big milk drinkers but we do eat a lot of other dairy products.
http://dsweiss.blogspot.com Sarah

I’m curious where these numbers came from, because the milk seems really high compared to other calculators I’ve seen. They usually say 16 lbs. per person as opposed to 60! Quite a difference.
http://dsweiss.blogspot.com Sarah

I’m curious where these numbers came from, because the milk seems really high compared to other calculators I’ve seen. They usually say 16 lbs. per person as opposed to 60! Quite a difference.
Tammy

Aah! I see that you have a couple of recipes here for using corn meal! Yay! Thanks!!
Tammy

Aah! I see that you have a couple of recipes here for using corn meal! Yay! Thanks!!
Tammy

Thanks!! I input all my stuff and can see how far behind I am! Julie, for your next challenge for Crystal please ask her to figure out what to do with all that corn meal!! I only have 2 pounds in storage and it will expire years before I even open it. Thanks again ladies! Also, I just watched Crystal’s videos about bread and wondered if you can store wheat gluten long term…?
Tammy

Thanks!! I input all my stuff and can see how far behind I am! Julie, for your next challenge for Crystal please ask her to figure out what to do with all that corn meal!! I only have 2 pounds in storage and it will expire years before I even open it. Thanks again ladies! Also, I just watched Crystal’s videos about bread and wondered if you can store wheat gluten long term…?
http://www.histakes-spelt.com Jamie A.

Awesome job! Thanks for putting that together for all to use.
http://www.histakes-spelt.com Jamie A.

Awesome job! Thanks for putting that together for all to use.
Rachel Johnson

3 month food supply- Does this include freezer goods like meat? We only eat fresh produce and meat. I have a challenge in that my husband won’t eated canned food or casserole dishes. I feel that if I do buy all this ‘stuff’, it will go to waste. Help, I’m already overwhelmed!
Rachel Johnson

3 month food supply- Does this include freezer goods like meat? We only eat fresh produce and meat. I have a challenge in that my husband won’t eated canned food or casserole dishes. I feel that if I do buy all this ‘stuff’, it will go to waste. Help, I’m already overwhelmed!
http://www.publishourstories.com Tara B.

This is incredible!! wow! wow! wow!!
http://www.publishourstories.com Tara B.

This is incredible!! wow! wow! wow!!
Mary

This is amazing! I love it, thanks!
Mary

This is amazing! I love it, thanks!
Andrea

I LOVE this! It is so easy to use and everything is right there. Thanks for doing all the hard work so I don’t have to. The best thing is that it is free!! I have come across tools like this but you always have to pay. You are awesome!
Andrea

I LOVE this! It is so easy to use and everything is right there. Thanks for doing all the hard work so I don’t have to. The best thing is that it is free!! I have come across tools like this but you always have to pay. You are awesome!
Leigh

Thank you so much for putting this together — I am a big fan of excel but never would have come up with something this great on my own. One question…if you have a 3-month supply of foods that you regularly eat, do you still recommend to have a full year of long term food storage? I had been calculating my food storage based on 3 months short term plus 9 months long term. I’m curious about your opinion on this. Thanks!
Leigh

Thank you so much for putting this together — I am a big fan of excel but never would have come up with something this great on my own. One question…if you have a 3-month supply of foods that you regularly eat, do you still recommend to have a full year of long term food storage? I had been calculating my food storage based on 3 months short term plus 9 months long term. I’m curious about your opinion on this. Thanks!
Shreela

Woo, thanks for the K column. And also for telling me how to work the H column with Cost/Unit — it took me a few to figure out I had to include the EQUAL sign in the cell.

The last time I worked with spreadsheets a lot was when I took it at college, back when it was in DOS, if that tells you anything LOL
Shreela

Woo, thanks for the K column. And also for telling me how to work the H column with Cost/Unit — it took me a few to figure out I had to include the EQUAL sign in the cell.

The last time I worked with spreadsheets a lot was when I took it at college, back when it was in DOS, if that tells you anything LOL
jweiss08

That’s great that you tweaked it. I didn’t lock this one so people could alter it based on their own needs (hopefully people don’t play around too much that the important formulas disappear . That’s the whole point, its a reference that helps you with what your family needs.
jweiss08

That’s great that you tweaked it. I didn’t lock this one so people could alter it based on their own needs (hopefully people don’t play around too much that the important formulas disappear . That’s the whole point, its a reference that helps you with what your family needs.
Joyce

Thanks girls! I love that I don’t have to have Excel to get a copy of the form.:)

Joyce
Joyce

Thanks girls! I love that I don’t have to have Excel to get a copy of the form.:)

Joyce
Shauna

I love this. I tweaked it a little to serve my needs better but I really appreciated the big job of preparing it done by someone else. Thank you so much for sharing this with us…
Shauna

I love this. I tweaked it a little to serve my needs better but I really appreciated the big job of preparing it done by someone else. Thank you so much for sharing this with us…
jweiss08

Shreela – I did this too late last night. I forgot I had deleted the formula in the K column. It’s fixed on there now.
FOR COLUMN H
MY BAD! I accidentally took that formula out… it’s in there now. It’s fixed on the site now.

For this one you do 11/50, to get the cost for 50 pounds and put that number in there- We did this because everyone will probably be purchasing things for different prices. You can do these costs/unit numbers on a calculator OR simply enter =11/50 in the cell.
jweiss08

Shreela – I did this too late last night. I forgot I had deleted the formula in the K column. It’s fixed on there now.
FOR COLUMN H
MY BAD! I accidentally took that formula out… it’s in there now. It’s fixed on the site now.

For this one you do 11/50, to get the cost for 50 pounds and put that number in there- We did this because everyone will probably be purchasing things for different prices. You can do these costs/unit numbers on a calculator OR simply enter =11/50 in the cell.
Shreela

I entered what I had stored into J column, but nothing automatically happened in the K column, like I was hoping it might autofill/calculate. I guess we’re to do our own math, then enter it into column ourselves.

Also, I don’t understand column H — cost/unit. I paid $11 for 50lbs of wheat, so I entered in 11.00 into h5, which then returned 3300 for total cost in i5. Yea, I’m new at doing this, sorry. What am I supposed to enter there?

Thanks!
Shreela

I entered what I had stored into J column, but nothing automatically happened in the K column, like I was hoping it might autofill/calculate. I guess we’re to do our own math, then enter it into column ourselves.

Also, I don’t understand column H — cost/unit. I paid $11 for 50lbs of wheat, so I entered in 11.00 into h5, which then returned 3300 for total cost in i5. Yea, I’m new at doing this, sorry. What am I supposed to enter there?

Thanks!
Pingback: Long Term Food Storage Calculator | Fun With Food Storage

Long Term Food Storage Calculator

Visit Our Sponsors

Recent Posts

Archives