Food Storage Calculator

	A	B	C	D	E	F
1
2	How Many People: Answer in B2	3
3	Food	Total Needed	Unit	On Hand	Still need (3 month)	Still need (12 month)
4	Grains
5	Wheat	450	lbs		112.5	450
6	Flour	75	lbs		18.75	75
7	Cornmeal	75	lbs		18.75	75
8	Oats	75	lbs		18.75	75
9	Rice	150	lbs		37.5	150
10	Pasta	75	lbs		18.75	75
11	Sugars
12	Honey	9	lbs		2.25	9
13	Sugar	120	lbs		30	120
14	Brown Sugar	9	lbs		2.25	9
15	Corn Syrup	9	lbs		2.25	9
16	Jams	9	lbs		2.25	9
17	Fruit Drink Mix	18	lbs		4.5	18
18	Flavored Gelatin	3	lbs		0.75	3
19	Fats and Oils
20	Shortening	12	lbs		3	12
21	Vegetable Oils	6	gal		1.5	6
22	Mayonnaise	6	qts		1.5	6
23	Salad Dressing	3	qts		0.75	3
24	Peanut Butter	12	lbs		3	12
25	Legumes
26	Dry Beans	165	lbs		41.25	165
27	Dry Soup Mix	15	lbs		3.75	15
28	Milk
29	Dry Milk	180	lbs		45	180
30	Evaporated Milk	36	can		9	36
31	Other	39	lbs		9.75	39
32	Cooking Essentials
33	Baking Powder	3	lbs		0.75	3
34	Baking Soda	3	lbs		0.75	3
35	Yeast	1.5	lbs		0.375	1.5
36	Salt	15	lbs		3.75	15
37	Vinegar	1.5	lbs		0.375	1.5
38	Fruits				0	0
39	Apple Sauce	120	lbs		30	120
40	Apple/ Banana Chips	120	lbs		30	120
41	Vegetables				0	0
42	Dehydrated Onion	15	lbs		3.75	15
43	Carrots	90	lbs		22.5	90
44	Potatoes	120	lbs		30	120
45	Tomato	60	lbs		15	60
46	Other	180			45	180
47	Water				0	0
48	Water (Minimum)	42	gal		10.5	42
49	Bleach	3	gal		0.75	3
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100