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 :)

  • Pingback: Food Storage Calculator | Extreme Survival Guide

  • mlongley

    thanks that’s a big help! I have seen the calculators from LDS but not in excel format.

    • http://foodstoragemadeeasy.net Jodi and Julie

      Glad we could help!

  • Pingback: Famines and Food Storage « ScratchinAlong

  • Tom

    Glad I found this – identical to one I made for my Ward back east about 10 years ago. My computer crashed and I lost it. Was not looking forward to making it again.

    • http://foodstoragemadeeasy.net Jodi and Julie

      We based it off of the church recommendations when we first created it. Glad it could help!

  • 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! :D

  • Timber

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

  • Timber

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

  • 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
  • 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