Quarantine food calculator
Build a practical multi-day grocery estimate for adults and children using a repeatable four-day meal-plan model.
Household and planning period
Children under 10 are modeled at half of the corresponding adult portion. Count children aged 10 or older as adults.
Required whole number, 0 – 50.
Required whole number, 0 – 50.
Under 10 only; required whole number, 0 – 50.
Under 10 only; required whole number, 0 – 50.
Required whole number of days, 1 – 60.
Plan summary
Quantities are scaled from a four-day menu pattern and shown in the detailed table.
Estimated shopping list
Amounts scale linearly with household portions and days. Whole-food counts can be fractional because this is a planning estimate; round package purchases sensibly.
| Category | Food | Amount | Unit |
|---|
How to use this quarantine food calculator
What this calculator does
This calculator turns a household size and a number of days into a detailed grocery list. Its underlying pattern is a repeatable four-day menu for adults with lower modeled portions for children under 10. The result is useful for planning a temporary stay-at-home period, a weather-related disruption, or another situation where you want a finite shopping list instead of buying without a plan. It does not diagnose nutrition needs, guarantee that every person will eat the same amount, or replace advice for allergies, medical diets, infant feeding, pregnancy, intensive athletics, or other special requirements. For broader preparedness, FoodSafety.gov recommends choosing foods with a long storage life and planning around family members with special dietary needs in its emergency food-supply guidance.
When to use it
Use the tool when you are preparing for several days at home, comparing a 7-day plan with a 14-day plan, checking whether pantry and freezer space will be enough, or creating a grocery checklist for a household with both adults and younger children. It also works as a starting point for meal planning: you can compare the output with what you already have and buy only the shortfall.
How to calculate
- The calculator opens with a demonstration household of one woman, one man, one girl, one boy, and 14 days. The results and the example XLSX are immediately available.
- Replace Women and Men with the number of adults or children aged 10 and older who should use adult portions.
- Enter children under 10 in Girls and Boys. Each is modeled at one-half of the matching adult menu portion, an approximation rather than an individualized nutrition calculation.
- Set Quarantine time to the number of days you want to plan, from 1 to 60. The list updates live as soon as all entries are valid.
- Read Shopping list, Household members, Adult-equivalent portions, Planning days, and Food categories, then use the Estimated shopping list table for food-by-food amounts.
- Select Download Excel to save the current valid plan as an XLSX workbook. Reset clears the demonstration values and results; after Reset, Excel export stays disabled until a complete valid state is entered again.
Input guide
Output guide
Shopping list reports how many distinct food lines are currently estimated; a valid plan produces 27 lines across four categories. Household members is the exact sum of Women, Men, Girls, and Boys. Adult-equivalent portions is the planning weight used by the model: adults count as 1 and younger children as 0.5, although male and female ingredient profiles are kept separate in the actual food math. Planning days repeats the active Quarantine time, and Food categories reports the four table groups: fruit and vegetables, perishable foods, non-perishable foods, and canned or frozen foods. In the Estimated shopping list table, Category groups similar storage types, Food names the ingredient, Amount is the scaled numeric estimate, and Unit shows pieces, grams/kilograms, or milliliters/liters. A zero food amount can occur only when its associated household portions are zero; a completely zero-person household is rejected because it would not produce a meaningful plan.
Worked example
With the startup values – 1 woman, 1 man, 1 girl, 1 boy, and 14 days – the model treats the children as half portions, so the household represents 3 adult-equivalent portions while preserving separate male and female menu profiles. Scaling the four-day pattern by 14/4 produces about 31.5 apples, 2.31 kg carrots, 56.2 eggs, 3.49 kg bread, 8.66 L milk, and 2.52 kg minced meat, along with the other table items. Those values match the first-open table and the startup workbook. Package sizes rarely match the raw estimate, so round purchases to practical packs while avoiding unnecessary excess.
Learn more
A list is only useful if food can be stored safely. FoodSafety.gov's cold food storage chart gives refrigerator and freezer time guidance for common perishables. For meal planning itself, USDA MyPlate recommends checking what you already have, writing down meals, and building the grocery list from that plan; see MyPlate's weekly meal-planning guidance.
How the food estimate works
The calculation uses two four-day ingredient profiles: one modeled adult male menu and one modeled adult female menu. Each food has a quantity for that four-day cycle. The calculator multiplies the male profile by Men plus half of Boys, multiplies the female profile by Women plus half of Girls, adds those two contributions, and then scales the result by Quarantine time divided by four. This preserves differences in the two menu profiles instead of collapsing everyone into one generic average.
The table deliberately keeps unlike units separate. Apples, eggs, bell peppers, and pickles are counts; milk is a volume; most other foods are masses. Adding those values into one “total food weight” would be misleading, so this calculator does not create a chart or grand total from incompatible dimensions.
Storage and practical adjustments
Before buying the whole list, subtract food you already have and inspect use-by dates and storage space. Perishables may need to be purchased in stages, frozen, or substituted with shelf-stable alternatives. FoodSafety.gov advises prompt chilling and notes that refrigerator and freezer temperatures matter for safety; its Clean, Separate, Cook, and Chill guidance is a useful companion to any bulk-shopping plan.
If you are planning for an emergency that might include loss of electricity, prioritize foods that need little or no refrigeration and account for cold-storage limits. FDA guidance notes that an unopened refrigerator keeps food cold for only a limited period during a power outage, so a large quantity of milk, meat, or eggs is not automatically a resilient emergency supply. Adapt the list to the actual disruption you are preparing for.