breakfast inventory/shopping list (example)

This is how my inventory/shopping sheets look. I save a word file with this exact list. Then, each time I do inventory, I delete the old inventory, recount and edit what I have and what I need.

Three-Month Supply:

Breakfast Menu:
1 - Oatmeal and juice (155 servings)
2 - Cold Cereal and milk (155 servings)
3 - Pancakes and milk (155 servings)

Breakfast Item List:
A - Oatmeal (5 - 3lb cans of quick oats)
B - Powdered milk - used for all three meals (6 - #10 cans of powdered milk)
C - Salt (1 container of salt)
D - Sugar (2 - 2lb bags of brown sugar)
E - Cinnamon (1 large container of cinnamon)
F - Cold cereal (16 boxes)
G - Pancake mix (2 - 10lb packages of pancake mix)
H - Syrup (4 - 2qt jugs)
I - Juice (31 jars)
J - Fruit (freeze dried, dehydrated, canned to add to oatmeal/pancakes as desired)
K - Water

Inventory
A - Oatmeal (5 - 3lb cans of quick oats)
3 – 3lb cans of quick oats (93 servings)
120 Oatmeal packets (85 servings)
DONE!
B - Powdered milk - used for all three meals (6 - #10 cans of powdered milk)
6+ #10 cans of dry milk
DONE!
C - Salt (1 container of salt)
1+ containers of salt
DONE!
D - Sugar (2 - 2lb bags of brown sugar)
2+ bags of brown sugar
DONE!
E - Cinnamon (1 large container of cinnamon)
DONE!
F - Cold cereal (16 boxes)
3 boxes of cold cereal (all currently opened)
NEED – 16 boxes of cereal
G - Pancake mix (2 - 10lb packages of pancake mix)
2 – 10 & 8 lb packages of pancake mix
Flour and all ingredients to make from scratch
DONE!
H - Syrup (4 - 2qt jugs)
2 – 2qt jugs
NEED – 2 -2qt jugs (would like to also store maple flavoring)
I - Juice (31 jars)
17 jars
NEED – 14 jars/cans of juice
J - Fruit (freeze dried, dehydrated, canned to add to oatmeal/pancakes as desired)
3 packages of raisins
1 #10 can of freeze-dried strawberries
6 #10 packages of dehydrated apples
DONE!

Shopping List
16 boxes of cereal
2 - 2 quart jugs of maple syrup (Costco)
Maple flavoring
14 cans/jar of juice (6 or 9 to be bottled this weekend)