What I did is keep track of what my family eats for a month, then multiplied that. I added in some extra of the staples, like flour, sugar, coffee, etc. You need to keep your supply fresh so you have to rotate. This way I buy what we eat and eat what we buy. Keep a list along with the meals you ate and the snacks. Don't forget beverages too. This is going to take longer then plugging in numbers in a spread sheet but it will be more personalized for you.
After I did that, I figured out what we eat that involves fresh meats/poultry. I then purchased some canned meats, chicken, turkey..etc. I use these less often but they are there when you need them and you know how to make a meal out of them.
It can be hard to find a system that works for you. It took me a while. I tried alot of complicated spread sheets and plans, but this is what works for me and my family.
Oh don't forget to add some powdered eggs and margarine (or canned butter). You won't use these until you really need them, and that's ok because they have a long shelf life.
Hope I've help some!
Kimber