Food Storage Calculator

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Instructions:	Insert the number of people in your family in the yellow box. The spreadsheet will then calculate how many lbs/cans/cases are required for your family. Next, go through your inventory and enter the number of lbs, cans, or cases of the product you already have in the corresponding column in the green boxes. For example, if you have 2 large bags of beans that weigh 20 lbs each, plus 2 cases and 3 cans of beans, enter "40" in the LBS column, "2" in the CASES column, and 3 in the CANS column. The spreadsheet will automatically calculate what you still need and will calculate the number of cans or cases still needed in the pink boxes. The purple boxes will show the cost remaining to fulfill your requirements based on purchasing cans of product from the LDS Home Storage center.
2	Instructions:
3		Requirement per person			Lbs per	x	8	people	Have			Still need			Approx cost per can using home storage prices	Total Cost Remaining
4	Product:	lbs or	cans or	cases	can/pouch	lbs	cans	cases	lbs	cans	cases	lbs or	cans or	cases	Approx cost per can using home storage prices	Total Cost Remaining
5	Wheat, Hard White	132	24	4	5.5	1056	192	32				1056	192.0	32.0	3.00	576.00
6	Rice, White	65	12	2	5.4	520	96	8				520	96.3	16.0	4.25	409.26
7	Oats, Regular	29	12	2	2.4	232	96	8				232	96.7	16.1	3.25	314.17
8	Pasta*	21	6	1	3	168	48	4				168	56.0	9.3	3.75	210.00
9	Beans**	62	12	2	5.25	496	96	8				496	94.5	15.7	5.50	519.62
10	Milk***	49	12	2	1.8	392	96	8				392	217.8	18.1	6.25	1361.11
11	Sugar, Granulate	70	12	2	5.8	560	96	8				560	96.6	16.1	4.25	410.34
12	Apple Slices	6	6	1	1	48	48	4				48	48.0	8.0	9.75	468.00
13	Potato Flakes	22	12	2	1.8	176	96	8				176	97.8	16.3	4.50	440.00
14	Carrots	8	3	0.5	2.8	64	24	2				64	22.9	3.8	10.25	234.29
15	Onions, Dry	2	1	0.15	2.4	96	8	0.6				96	40.0	6.7	6.50	260.00
16	Total price for Home Storage Items:														Total:	5202.79
17	Non-Home Storage Items: When purchasing these items at the grocery store, enter the price per lb or other unit in the orange boxes, the spreadsheet will calculate the total cost to fulfill your remaining requirments														Price per lb	Total Cost Remaining
18	Salt	8			varies	64	0	0				64				0.00
19	Baking Soda	1			varies	8	0	0				8				0.00
20	Baking Powder	4			varies	32	0	0				32				0.00
21	Vitamin C Tablets	1	bottle of 365 tablets		varies	8	bottle of 365 tablets					8				0.00
22	Short Term Food Items-Rotate these more regularly due to their short shelf life.														Price per unit
23	Cooking/Salad Oils	2	gallons			8	gallons					8				0.00
24	Shortening/Frying Oils	3	cans @ 3 lbs ea			12	cans @ 3 lbs ea					12				0.00
25	Butter	6	lbs			48	lbs					48				0.00
26	Mayonnaise	3	qts			24	qts					24				0.00
27	Peanut Butter	6	lbs			48	lbs					48				0.00
28	Fruit Drink Mix	3	cans	8		24	cans or					24				0.00
29	Eggs, Dried	2	cans			16	cans					16				0.00
30	Yeast	2	lbs			16	lbs					16				0.00
31
32	Other items needed: Can opener, grain grinder, recipes that only use stored ingredients, fuel and cooking utensils to cook food. Other sweeteners, i.e.: honey, molasses, brown sugar, powdered sugar, jams, jellies, syrups, etc.; other canned or dried fruits, vegetables, meats, etc. will increase nutritional value.
33
34	*price & weight caclulated using home storage spaghetti bites
35	**price & weight calculated using combined average price/weight of black, pinto & white beans from home storage
36	***milk sold in 28 oz pouches, 12 per case
37
38
39
40
41
42
43
44
45
46
47
48
49
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