Fast, Easy Way To Inventory Stored Food

We’re in a critical time for food now. It is necessary to track food inventories in and out of your pantry. How will you know the quantity of food to buy or preserve if you don’t know what you already have? And how will you track your food inventory once you start using it? With this handy spreadsheet.

Here is what it does:

1) It lets you enter dry staples, wet staples and meat quantities in the appropriate sheets.

2) It provides the total quantities of each category.

3)It calculates the number of servings for each food item and the number of TOTAL servings for all food items in your inventory.

4) It calculates how long you can expect your inventory to last by allowing you to put in the number of people who will be using the food supply and determining how many ingredients you are likely to use in each serving of food.

Here is a sample report that would be based upon the inventory in the spreadsheet:

The above fictional report is an example of the output of the spreadsheet. You always want to know how many servings you have, but more importantly, you want to know how your usage will affect your food supply. There is a difference between servings and meals that can be served because meals require more than one ingredient. In this example, there are 100 total servings of food available. If 2 people eat 3 servings of food per day, the food will last 17 days. But if the 2 people eat 3 meals that consists of 3 servings in each meal, the food will last 6 days.

Track your inventory as you use it so that you will always know how much food you actually have and how long it will last.

I hope this spreadsheet helps you at this critical stage.

Shalom.