Dynamic Menu Planning with Spreadsheets

Outdoor Ed — Mon, 18 May 2009 01:24:07 GMT

Current Revision posted to Articles by Outdoor Ed on 5/17/2009 9:24:07 PM

Dynamic Menu Planning with Spreadsheets

menu planning, technologyoutdoor orientation, spreadsheet, outdoor orientationtechnology

by Rick Curtis

Just a note: In order to make it easier to understand the logic of how this spreadsheet works I have pasted a full-width copy of the spreadsheet into this page. That means you will have to scroll over in order to see what's going on.

Each year the Outdoor Action Program at Princeton University sends out about seventy 6-day backpacking trips, that's over 850 people in the field. Feeding this small army of folks is a big task. Due to the large size of our program and because leaders only return a few days before the trip goes out at the end of the summer, we do a central menu plan rather than have each group develop their own menu. Since we are only out for six days it makes more sense to work from a set menu rather than providing a range of food items and let the group develop a menu on the trail. By purchasing in bulk we save significant money.

Over the years in order to streamline the planning and ordering process I developed an Excel spreadsheet to help me lay out the menu, and, most importantly, make sure that I ordered enough food. The spreadsheet is pretty basic. Below is a sample food item. I'll walk you through how the spreadsheet works and explain the underlying formulas.

Download a Copy of the Food Planner Spreadsheet

You can see that I've created a replica of the spreadsheet complete with column headings and row numbers. I'll use the standard A1..B2 spreadsheet referencing scheme to point out the particular features of the spreadsheet. You can follow along by looking at the sample table laid out below.

The first set of important cells are highlighted in yellow. The are master values in these cells drive much of the spreadsheet. Cell G2 (Groups) is the number of actual trip groups that are going out. Cell F2 (Order) is the number of groups that I am going to order for. This is to give us a little extra food in case another trip is adding at the end of the summer and so we have some extra for some or our fall programs. Cell H2 (>10) is the number of groups that have more than 10 people. Our groups on the Appalachian Trail are 10 while groups in some other areas like the Catskills are 12. Cell I2 (Kosher) is the number of trips we have with observant Jewish Students who keep Kosher.

	F	G	H	I
1	Order	Groups	>10	Kosher
2	71	68	46	3

So take a look at Row 4. Here you see the heading labels for each column. Looking at our example, Heartland Granola in Row 5, let's just work our way across the row. I have duplicated Row 5 twice, once with the numerical values and the second time showing the formulas in each cell.

A5 - Item Name
B5 - Amount that each group gets of this item.
C5 - How the item is packaged
D5 - How many per case
E5 - The size of each item
F5 - This cell takes its value from cell F2 with the formula =$F$2
G5 - Calculated field for now many of this item is needed. The formula is =B5*F5 or (Amount/group * Number of Groups)
H5 - Simply a duplication of cell C5 showing the unit - =$C$5
I5 - How many cases you are going to order. This is a field that you play with. By changing the number of cases you change the outcome further on (watch and you'll see).
J5 - The Product ID code
K5 - The price per item. This is a calculated field =M5/D5 or (Case price/ the number of items per case)
L5 - How the item is priced. In this case E stands for each as in $2.60 for each box.
M5 - The case price from the wholesaler.
N5 - The extended price from the formula =I5*M5 or (Cases ordered * Case Price). This price will change as you change the number of cases ordered in I5.
O5 - How many left over items you will have from the formula =(I5*D5)-G5 or (Cases Ordered* Number/case) - Number Needed for all groups). This will change as you change the number of cases ordered in I5.
P5 - How the item is packaged
Q5 - With some items we give groups over 10 some extra. In this case each group over 10 gets 1 extra box of granola. As a result we need to do a second calculation on the number of boxes we will have left over.
R5 - This is the second calculation for the number of left over boxes after adding in the extra food handed out. It is calculated using the formula =O5-($H$2*Q5) or (The number left over initially - (The Number of Groups over 10 * How many extra of this item each group over 10 gets))
S5 - Simply a duplication of cell C5 showing the unit =$C$5

FROSH TRIP FOOD LIST

Unit Codes: LB=pound, E=each, C=case, B=Box

Order

Groups

>10

Kosher

ITEM

NO. OF

ORDER

PRODUCT

UNIT

CASE

EXTENDED

10+

LEFT

BREAKFAST

AMOUNT/

GROUP

PER CASE

SIZE

GROUPS

TRIPS

NEED

CASES

CODE

PRICE

UNIT

PRICE

EXTRA

GROUPS

OVER

Heartland Granola

boxes

16 oz.

142

boxes

9242975

$2.60

$31.20

$561.60

boxes

Heartland Granola

Enter this Number

boxes

Enter number /case

Enter size/unit

=$F$2

=B5*F6

=$C$5

Enter Cases Ordered

=M5/D5

Enter Case Price

=I5*M5

=(I5*D5)-G5

=$C$5

Enter how many extra each group gets

=O5-($H$2*Q5)

=$C$5

By now you must be dizzy looking back and forth between the list and scrolling across the spreadsheet. You have the basic idea. There are a few extra modifications I've made to the spreadsheet that take into account some other factors. You might be wondering since I am using Cell F2 to set the number of groups I am ordering for why I bother with Cell G2, the number of groups. Well that's because for all nonperishable items I use the F2 number, but for perishables like cheese, pita's, etc. I don't want things to go to waste and we don't have the refrigeration facilities to keep the stuff. So with perishable items I use the value of G2 in what would be cell F5 in this example. I do the same thing with Cell I3 for the kosher items I order. You can see how the numbers in column F change when you look at the whole spreadsheet.

There are also a few cells that have some special formulas in them. Mostly this happens with Fresh Produce. Produce is often sold by the pound but I am handing out a specific number of apples, green peppers, etc. per group so I have to calculate the number ordered based on the actual count. Talking to my supplier I find out that a 28 pound box of green peppers is about 75 peppers (75 count). So I alter the formula for the number of extra needed in Cell O to be =(I64*75)-G64 or (Cases Ordered* Count) - Number Needed. The other thing to keep in mind with produce there is a 2%-%5 spoilage rate. That is in a box of 75 count of green peppers there are going to be 2-5% that are so skanky-looking that you wouldn't dare give them out to anyone. The same is true for oranges and to a lesser extent with apples. It doesn't happen much with onions and garlic cloves. The bottom line is know your produce!

So that's the concept. Once I have planned the menu and know the items needed for each group I enter the information into the spreadsheet. What's great about this is if suddenly I increase to 70 real trips up from 68 all I need to do is change Cell G2 to 70 and up Cell F2 to 74 and the entire spreadsheet recalculates. Now I haven't yet changed the number of cases ordered in column I so chances are if I look over at column O for the number of extra items I'll probably see some negative numbers, meaning that I am going to be short. I can simply up the number of cases ordered in column O until I have an overage that I am comfortable with. When I am all set I send the spreadsheet to my supplier for them to process my order. Of course like any spreadsheet this one also calculates the total food cost for budget planning purposes.

This spreadsheet has saved me countless hours of hand figuring over the years and every year we are right on the money with the amount of food we need and our little extra to tide us over for fall trips. I hope that this is helpful for your menu planning.

Below is the full spreadsheet. Hope you don't get too dizzy.

	A	B	C	D		E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1						Order	Groups	>10	Kosher
2						71	68	46	3
3	ITEM		AMOUNT/			NO. OF			ORDER	PRODUCT	UNIT		CASE	EXTENDED			10+	LEFT
4	BREAKFAST		GROUP	PER CASE	SIZE	GROUPS	TRIPS	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
5	Heartland Granola	2	boxes	12	16 oz.	71	142	boxes	18	9242975	$2.60	E	$31.20	$561.60	74	boxes	1	28	boxes
6	Cracklin' Oat Bran	2	boxes	14	17 oz.	71	142	boxes	12	7524259	$5.22	E	$73.13	$877.56	26	boxes
7	Mueslix - Kelloggs Crunchy	2	boxes	12	15.9 oz.	71	142	boxes	14	9242652	$4.97	E	$59.68	$835.52	26	boxes
8	Quaker Oatmeal Fruit Variety Flavor Packets	3	box	12	10 envelopes/ box	71	213	boxes	20	9242678	$3.63	E	$43.55	$871.00	27	boxes
9	Quaker Oatmeal Regular Variety Flavor Packets	4	box	12	10 envelopes/ box	71	284	boxes	26	9129289	$2.51	E	$30.08	$782.08	28	boxes
10	LUNCH		GROUP	PER CASE	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
11	Peanut Butter, Jiffy Chunky - plastic bottles	2	bottle	6	40 oz. plastic bottle	71	142	bottles	28		$4.28	E	$25.70	$719.60	26	bottles
12	Peanut Butter, Jiffy Creamy - plastic bottles	1	bottle	8	40 oz. plastic bottle	71	71	bottles	12	9242710	$5.34	E	$42.68	$512.16	25	bottles
13	Strawberry Jelly - Welch's squeezable plastic bottles (HDPE)	2	bottle	12	22 oz. plastic bottle	71	142	bottles	14		$1.52	E	$18.25	$255.50	26	bottles
14	Honey - plastic bottles	2	bear	12	12 oz. plastic bear	71	142	bears	14	8826893	$1.97	E	$23.64	$330.96	26	bears
15	Hummus - Fantastic Foods	2	boxes	10	7 oz.	71	142	boxes	17		$2.40	C	$24.00	$15.00	28	boxes
16	Tuna - chunk light	5	cans	24	12.5 oz/can	71	355	cans	19			C			101	cans	1	55	cans
17	Crackers - Stoned Wheat Thins	6	boxes	12	10 oz./box	68	408	boxes	46	Valley Brook	$1.84	B	$22.12	$1,017.52	144	boxes	2	52	boxes
18	Dried Apples - Packer	1.2	pounds	44	44 Ib. box	65	78	pounds	2	1967363	$2.87	LB	$126.28	$252.56	10	pounds
19	Dried Apricots - Packer	0.8	pounds	28	28 Ib. box	65	52	pounds	2	8115032	$2.49	LB	$69.59	$139.18	4	pounds
20	Dried Peaches	1	pounds	25	25 Ib. Box	65	65	pounds	3	3886421	$2.60	LB	$65.07	$195.21	10	pounds
21	Peanuts,Rstd.,Shelled, unsalted	7	pounds	50	50 pounds	68	476	pounds	12	5760970	$1.98	LB	$99.00	$1,188.00	124	pounds	1.25	66.5	pounds
22	Raisins Golden - seedless (1# for breakfast)	7	pounds	30	30 pound box	68	476	pounds	19	6126718	$1.77	LB	$53.11	$1,009.09	94	pounds	1.25	36.5	pounds
23	Harmony Snackums (M&M's)	7	pounds	19	19 pound box	68	476	pounds	29	5252390	$3.18	LB	$60.50	$1,754.50	75	pounds	1	29	pounds
24	Sunflower Seeds - roasted, unsalted	1	bags	3	2 pound bags	68	68	bags	37	4645453	$4.46	C	$13.37	$494.69	43	bags	0.5	20	bags
25	Fig Newtons	4	tubes	24	8 oz	71	284	boxes	14	4482162	$1.78	E	$42.60	$596.40	52	tubes
26	Granola bar - Nature Valley Peanut Butter	10	bar	144	0.8 oz	71	710	bars	6	4069704	$0.20	E	$27.09	$162.54	154	bars
27	Granola bar - Nature Valley Cinnamon	10	bar	144	0.8 oz	71	700	bars	6	4069712	$0.20	E	$27.39	$164.34	164	bars
28	Granola bar - Nature Valley Oats & Honey	10	bar	144	0.8 oz	71	700	bars	6	4069720	$0.20	E	$27.70	$166.20	164	bars
29	DINNER		GROUP	PER CASE	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
30	Canned Chicken	8	cans	12	10 oz.	71	568	cans	59	9242595	$3.79	E	$45.46	$2,682.14	140	cans	2	48	cans
31	Sysco Classic Angel Hair Noodles	3	pounds	12	1 pound	71	213	pounds		5016464	$15.00	E		$0.00	-213	pounds
32	Couscous - Near East Roasted Garlic and Olive Oil	3	boxes	12	5.8 oz.	71	213	boxes	24	5076765	$1.55		$18.56	$445.44	75	boxes	1	29
33	Canned Corn - Best Yet	1	can	24	15.25 oz.	68	68	cans	5		$0.52		$12.37	$61.85	52	cans
34	Canned Black Beans - Goya	1	can	24	15.5 oz.	68	68	cans	5		$0.63		$15.10	$75.50	52	cans
35	Contadina Pizza Sauce in Squeeze Bottle	2	bottle	12	15 oz. Squeeze bottle	71	142	bottles	13	Valley Brook	$1.36		$16.30	$211.90	14	bottles
36	Jello No-bake Peanut Butter Cup Pie	2	boxes	12	11.2 oz box	71	142	boxes	13		$2.76		$33.06	$429.78	14	0
37	Jello No-bake cheesecake	2	boxes	12	11.2 oz box	71	142	boxes	13		$2.63	C	$31.50	$409.50	14	0
38	Refried Beans - dried mix by Fantastic Foods	2	boxes	12	7 oz/box	71	142	boxes	13		$2.00	C	$24.00	$312.00	14	boxes
39	Pesto Pasta Blend Sauce Mix	4	envelopes	12	0.5 oz./envelope	70	280	envelopes	32		$1.31		$15.68	$501.76	104	envelopes	1	58	envelopes
40	Egg Noodles	1	bags		16 oz. bag	71								$0.00	0			0
41	Tomato Paste	2	cans		6 oz. can	71								$0.00	0			0
42	Fantastic Foods Dried Black Beans	1	box		7 oz. box	71		boxes						$0.00	0			0
43	Textured Vegetable Protein	1.5	cups			71								$0.00	0			0
45	Chili Powder - McCormick?	1	envelope			71								$0.00	0			0
45	MISCELLANEOUS		GROUP	PER CASE	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
46	Powdered Milk - nonfat	2	pounds	12	1 pounds	71	142	pounds	13	9242934	$4.92	LB	$59.05	$767.65	14	pounds
47	Brown Sugar	1	pounds	24	1 pounds	71	71	pounds	4	4281440	$0.61	LB	$14.68	$58.72	25	pounds
48	Lemonade Mix	1	bags	12	24 oz.	71	71	bags	7	4138632	$1.88	E	$22.54	$157.78	13	bags
49	Gatorade Powder Drink mix - Lemon Lime	1	bags	12	18 oz.	71	71	bags	7	9129453	$4.86	E	$58.27	$407.89	13	bags	1	-33	bags
50	Tang	1	bags	12	21 oz.	71	71	bags	7	9242785	$3.78	E	$45.31	$317.17	13	bags
51	Variety Pack of Herbal Tea Bags - Bigelow	1	box	6	28 bags	71	71	boxes	13	4041935	$3.02	E	$18.13	$235.69	7	boxes
52	Hot Chocolate - Nestles Cocoa Mix	2	bags	12	1.75 pounds	71	142	bags	14	4060760	$4.23	E	$50.70	$709.80	26	bags
53	FRESH - F = arrive Friday		GROUP	PER CASE	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
54	Cheddar Cheese - New York Mild waxed brick	4	bricks	6	2# waxed bricks	68	272	bricks	47	3162245	$8.50	LB	$50.98	$2,396.06	10	bricks
55	Flour Tortillas - 10"	4	pkg.	12	12 per package	68	272	pkg.	25	2386159	$1.90	Pkg.	$22.75	$568.75	28	pkg.
56	Squeeze Parkay	2	bottle	24	16 oz./plastic bottle	68	136	bottle	7		$1.78	E	$42.80	$299.60	32	bottle
57	Kronos Pita Bread 7 " - bulk pack	8	package	12	10 per package	68	544	count	55	1309863	$2.10	Pkg.	$25.17	$1,384.35	116	count	2	24	count
58	Apples - Red Delicious 88 count	18	count	88	count	68	1224	count	17		$0.41	E	$35.82	$608.94	272	count	3	134	count
59	Parmesan Cheese - cardboard container	1	can	12	3 oz./can	71	71	cans	7		$4.02	E	$48.25	$337.75	13	cans
60	Pepperoni	1	stick	10	1 lb.Sticks	68	68	sticks	7	1253699	$3.82	E	$38.20	$267.40	2	sticks
61	Oranges - Valencia 72 count	18	count	72	count	68	1224	count	21		$0.28	E	$20.00	$420.00	288	count	4	104	count
62	Onions - #1	5	count	50	50 lb. = 150 count	68	340	count	3		$0.28	LB	$14.00	$42.00	110	count	1	64	count
63	Green Peppers - medium	5	count	28	28 lb. = 75 count	68	340	count	6		$0.61	LB	$17.00	$102.00	110	count	1	64	count
64	Garlic cloves	1	clove	40	5 pound = 40 cloves	68	68	cloves	2		$0.21	E	$8.25	$16.50	12	cloves
65	STORAGE & MISCELLANEOUS		GROUP	PER CASE	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
66	Ziplock Bags - gallon	0.25	boxes	9	boxes/40 count	71	17.75	boxes	3		$3.06	E	$27.56	$82.68	9.25	boxes
67	Ziplock Bags - quart	0.25	boxes	12	boxes/32 count	71	17.75	boxes	3		$2.53	E	$30.40	$91.20	18.25	boxes
68					right number per box?
69	SPICES		GROUP	PER CASE	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
70	Tostitos Mild Salsa	1	bottles	9	28 oz. plastic bottle	71	71	bottles	10	9242645	$2.97	E	$26.75	$267.50	19	bottles
71	Cinnamon - ground	1	bottles
72	Salt & Pepper - rotate lids	1	set bottles	12	2 oz. containers	71	71	bottles	8		$1.38	E	$16.50	$132.00	25	container
73	Oregano	1	bottle	12	0.75 oz. plastic bottle	71	71	bottles	7	9242868	$0.00	E		$0.00	13	bottles
74	Cumin	1	bottle	12		71	71	bottles	7			E		$0.00	13	bottles
75	Tabasco Pepper Sauce	1	bottle	24	2 oz.	68	68	bottles	3	5914619	$1.23	E	$29.61	$88.83	4	bottles
76	Basil	1	bottle	12	0.25 oz. plastic bottle	68	68	bottles	7	9242819	$0.00	E		$0.00	16	bottles
77	KOSHER		GROUP	PACK	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
78	Trail Mix - Tropical Treasures Snack Mix	24	lbs.	3	2 lb. bag	3	72	pounds	12	5730833	$5.25	E	$15.75	$189.00	0	pounds
79	Uneeda Biscuits	5	lbs.			3	12	pounds							-12	boxes
80	Dried Fruit	3	lbs.	10	10 lb. bag	3	9	pounds	1		$4.90	C	$49.00	$49.00	1	pounds
81	Pasta Mix (we've never found

Download a good one)

envelopes

-12

envelopes

FRESH KOSHER

GROUP

PACK

SIZE

GROUPS

NEEDS

CASES

CODE

PRICE

UNIT

PRICE

EXTRA

GROUPS

OVER

Tortillas - 10"

package

12 per package

packages

$2.49

Pkg.

$29.90

packages

Pita - 6"

package

12 oz - 12/package

packages

2404481

$1.83

$10.97

$43.88

packages

TOTAL =

$28,103Copy of the Food Planner Spreadsheet

Dynamic Menu Planning with Spreadsheets

Outdoor Ed — Mon, 18 May 2009 01:21:55 GMT

Revision 1 posted to Articles by Outdoor Ed on 5/17/2009 9:21:55 PM

by Rick Curtis

Download a Copy of the Food Planner Spreadsheet

	F	G	H	I
1	Order	Groups	>10	Kosher
2	71	68	46	3

A5 - Item Name
B5 - Amount that each group gets of this item.
C5 - How the item is packaged
D5 - How many per case
E5 - The size of each item
F5 - This cell takes its value from cell F2 with the formula =$F$2
G5 - Calculated field for now many of this item is needed. The formula is =B5*F5 or (Amount/group * Number of Groups)
H5 - Simply a duplication of cell C5 showing the unit - =$C$5
I5 - How many cases you are going to order. This is a field that you play with. By changing the number of cases you change the outcome further on (watch and you'll see).
J5 - The Product ID code
K5 - The price per item. This is a calculated field =M5/D5 or (Case price/ the number of items per case)
L5 - How the item is priced. In this case E stands for each as in $2.60 for each box.
M5 - The case price from the wholesaler.
N5 - The extended price from the formula =I5*M5 or (Cases ordered * Case Price). This price will change as you change the number of cases ordered in I5.
O5 - How many left over items you will have from the formula =(I5*D5)-G5 or (Cases Ordered* Number/case) - Number Needed for all groups). This will change as you change the number of cases ordered in I5.
P5 - How the item is packaged
Q5 - With some items we give groups over 10 some extra. In this case each group over 10 gets 1 extra box of granola. As a result we need to do a second calculation on the number of boxes we will have left over.
R5 - This is the second calculation for the number of left over boxes after adding in the extra food handed out. It is calculated using the formula =O5-($H$2*Q5) or (The number left over initially - (The Number of Groups over 10 * How many extra of this item each group over 10 gets))
S5 - Simply a duplication of cell C5 showing the unit =$C$5

FROSH TRIP FOOD LIST

Unit Codes: LB=pound, E=each, C=case, B=Box

Order

Groups

>10

Kosher

ITEM

NO. OF

ORDER

PRODUCT

UNIT

CASE

EXTENDED

10+

LEFT

BREAKFAST

AMOUNT/

GROUP

PER CASE

SIZE

GROUPS

TRIPS

NEED

CASES

CODE

PRICE

UNIT

PRICE

EXTRA

GROUPS

OVER

Heartland Granola

boxes

16 oz.

142

boxes

9242975

$2.60

$31.20

$561.60

boxes

Heartland Granola

Enter this Number

boxes

Enter number /case

Enter size/unit

=$F$2

=B5*F6

=$C$5

Enter Cases Ordered

=M5/D5

Enter Case Price

=I5*M5

=(I5*D5)-G5

=$C$5

Enter how many extra each group gets

=O5-($H$2*Q5)

=$C$5

Below is the full spreadsheet. Hope you don't get too dizzy.

	A	B	C	D		E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1						Order	Groups	>10	Kosher
2						71	68	46	3
3	ITEM		AMOUNT/			NO. OF			ORDER	PRODUCT	UNIT		CASE	EXTENDED			10+	LEFT
4	BREAKFAST		GROUP	PER CASE	SIZE	GROUPS	TRIPS	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
5	Heartland Granola	2	boxes	12	16 oz.	71	142	boxes	18	9242975	$2.60	E	$31.20	$561.60	74	boxes	1	28	boxes
6	Cracklin' Oat Bran	2	boxes	14	17 oz.	71	142	boxes	12	7524259	$5.22	E	$73.13	$877.56	26	boxes
7	Mueslix - Kelloggs Crunchy	2	boxes	12	15.9 oz.	71	142	boxes	14	9242652	$4.97	E	$59.68	$835.52	26	boxes
8	Quaker Oatmeal Fruit Variety Flavor Packets	3	box	12	10 envelopes/ box	71	213	boxes	20	9242678	$3.63	E	$43.55	$871.00	27	boxes
9	Quaker Oatmeal Regular Variety Flavor Packets	4	box	12	10 envelopes/ box	71	284	boxes	26	9129289	$2.51	E	$30.08	$782.08	28	boxes
10	LUNCH		GROUP	PER CASE	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
11	Peanut Butter, Jiffy Chunky - plastic bottles	2	bottle	6	40 oz. plastic bottle	71	142	bottles	28		$4.28	E	$25.70	$719.60	26	bottles
12	Peanut Butter, Jiffy Creamy - plastic bottles	1	bottle	8	40 oz. plastic bottle	71	71	bottles	12	9242710	$5.34	E	$42.68	$512.16	25	bottles
13	Strawberry Jelly - Welch's squeezable plastic bottles (HDPE)	2	bottle	12	22 oz. plastic bottle	71	142	bottles	14		$1.52	E	$18.25	$255.50	26	bottles
14	Honey - plastic bottles	2	bear	12	12 oz. plastic bear	71	142	bears	14	8826893	$1.97	E	$23.64	$330.96	26	bears
15	Hummus - Fantastic Foods	2	boxes	10	7 oz.	71	142	boxes	17		$2.40	C	$24.00	$15.00	28	boxes
16	Tuna - chunk light	5	cans	24	12.5 oz/can	71	355	cans	19			C			101	cans	1	55	cans
17	Crackers - Stoned Wheat Thins	6	boxes	12	10 oz./box	68	408	boxes	46	Valley Brook	$1.84	B	$22.12	$1,017.52	144	boxes	2	52	boxes
18	Dried Apples - Packer	1.2	pounds	44	44 Ib. box	65	78	pounds	2	1967363	$2.87	LB	$126.28	$252.56	10	pounds
19	Dried Apricots - Packer	0.8	pounds	28	28 Ib. box	65	52	pounds	2	8115032	$2.49	LB	$69.59	$139.18	4	pounds
20	Dried Peaches	1	pounds	25	25 Ib. Box	65	65	pounds	3	3886421	$2.60	LB	$65.07	$195.21	10	pounds
21	Peanuts,Rstd.,Shelled, unsalted	7	pounds	50	50 pounds	68	476	pounds	12	5760970	$1.98	LB	$99.00	$1,188.00	124	pounds	1.25	66.5	pounds
22	Raisins Golden - seedless (1# for breakfast)	7	pounds	30	30 pound box	68	476	pounds	19	6126718	$1.77	LB	$53.11	$1,009.09	94	pounds	1.25	36.5	pounds
23	Harmony Snackums (M&M's)	7	pounds	19	19 pound box	68	476	pounds	29	5252390	$3.18	LB	$60.50	$1,754.50	75	pounds	1	29	pounds
24	Sunflower Seeds - roasted, unsalted	1	bags	3	2 pound bags	68	68	bags	37	4645453	$4.46	C	$13.37	$494.69	43	bags	0.5	20	bags
25	Fig Newtons	4	tubes	24	8 oz	71	284	boxes	14	4482162	$1.78	E	$42.60	$596.40	52	tubes
26	Granola bar - Nature Valley Peanut Butter	10	bar	144	0.8 oz	71	710	bars	6	4069704	$0.20	E	$27.09	$162.54	154	bars
27	Granola bar - Nature Valley Cinnamon	10	bar	144	0.8 oz	71	700	bars	6	4069712	$0.20	E	$27.39	$164.34	164	bars
28	Granola bar - Nature Valley Oats & Honey	10	bar	144	0.8 oz	71	700	bars	6	4069720	$0.20	E	$27.70	$166.20	164	bars
29	DINNER		GROUP	PER CASE	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
30	Canned Chicken	8	cans	12	10 oz.	71	568	cans	59	9242595	$3.79	E	$45.46	$2,682.14	140	cans	2	48	cans
31	Sysco Classic Angel Hair Noodles	3	pounds	12	1 pound	71	213	pounds		5016464	$15.00	E		$0.00	-213	pounds
32	Couscous - Near East Roasted Garlic and Olive Oil	3	boxes	12	5.8 oz.	71	213	boxes	24	5076765	$1.55		$18.56	$445.44	75	boxes	1	29
33	Canned Corn - Best Yet	1	can	24	15.25 oz.	68	68	cans	5		$0.52		$12.37	$61.85	52	cans
34	Canned Black Beans - Goya	1	can	24	15.5 oz.	68	68	cans	5		$0.63		$15.10	$75.50	52	cans
35	Contadina Pizza Sauce in Squeeze Bottle	2	bottle	12	15 oz. Squeeze bottle	71	142	bottles	13	Valley Brook	$1.36		$16.30	$211.90	14	bottles
36	Jello No-bake Peanut Butter Cup Pie	2	boxes	12	11.2 oz box	71	142	boxes	13		$2.76		$33.06	$429.78	14	0
37	Jello No-bake cheesecake	2	boxes	12	11.2 oz box	71	142	boxes	13		$2.63	C	$31.50	$409.50	14	0
38	Refried Beans - dried mix by Fantastic Foods	2	boxes	12	7 oz/box	71	142	boxes	13		$2.00	C	$24.00	$312.00	14	boxes
39	Pesto Pasta Blend Sauce Mix	4	envelopes	12	0.5 oz./envelope	70	280	envelopes	32		$1.31		$15.68	$501.76	104	envelopes	1	58	envelopes
40	Egg Noodles	1	bags		16 oz. bag	71								$0.00	0			0
41	Tomato Paste	2	cans		6 oz. can	71								$0.00	0			0
42	Fantastic Foods Dried Black Beans	1	box		7 oz. box	71		boxes						$0.00	0			0
43	Textured Vegetable Protein	1.5	cups			71								$0.00	0			0
45	Chili Powder - McCormick?	1	envelope			71								$0.00	0			0
45	MISCELLANEOUS		GROUP	PER CASE	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
46	Powdered Milk - nonfat	2	pounds	12	1 pounds	71	142	pounds	13	9242934	$4.92	LB	$59.05	$767.65	14	pounds
47	Brown Sugar	1	pounds	24	1 pounds	71	71	pounds	4	4281440	$0.61	LB	$14.68	$58.72	25	pounds
48	Lemonade Mix	1	bags	12	24 oz.	71	71	bags	7	4138632	$1.88	E	$22.54	$157.78	13	bags
49	Gatorade Powder Drink mix - Lemon Lime	1	bags	12	18 oz.	71	71	bags	7	9129453	$4.86	E	$58.27	$407.89	13	bags	1	-33	bags
50	Tang	1	bags	12	21 oz.	71	71	bags	7	9242785	$3.78	E	$45.31	$317.17	13	bags
51	Variety Pack of Herbal Tea Bags - Bigelow	1	box	6	28 bags	71	71	boxes	13	4041935	$3.02	E	$18.13	$235.69	7	boxes
52	Hot Chocolate - Nestles Cocoa Mix	2	bags	12	1.75 pounds	71	142	bags	14	4060760	$4.23	E	$50.70	$709.80	26	bags
53	FRESH - F = arrive Friday		GROUP	PER CASE	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
54	Cheddar Cheese - New York Mild waxed brick	4	bricks	6	2# waxed bricks	68	272	bricks	47	3162245	$8.50	LB	$50.98	$2,396.06	10	bricks
55	Flour Tortillas - 10"	4	pkg.	12	12 per package	68	272	pkg.	25	2386159	$1.90	Pkg.	$22.75	$568.75	28	pkg.
56	Squeeze Parkay	2	bottle	24	16 oz./plastic bottle	68	136	bottle	7		$1.78	E	$42.80	$299.60	32	bottle
57	Kronos Pita Bread 7 " - bulk pack	8	package	12	10 per package	68	544	count	55	1309863	$2.10	Pkg.	$25.17	$1,384.35	116	count	2	24	count
58	Apples - Red Delicious 88 count	18	count	88	count	68	1224	count	17		$0.41	E	$35.82	$608.94	272	count	3	134	count
59	Parmesan Cheese - cardboard container	1	can	12	3 oz./can	71	71	cans	7		$4.02	E	$48.25	$337.75	13	cans
60	Pepperoni	1	stick	10	1 lb. Sticks	68	68	sticks	7	1253699	$3.82	E	$38.20	$267.40	2	sticks
61	Oranges - Valencia 72 count	18	count	72	count	68	1224	count	21		$0.28	E	$20.00	$420.00	288	count	4	104	count
62	Onions - #1	5	count	50	50 lb. = 150 count	68	340	count	3		$0.28	LB	$14.00	$42.00	110	count	1	64	count
63	Green Peppers - medium	5	count	28	28 lb. = 75 count	68	340	count	6		$0.61	LB	$17.00	$102.00	110	count	1	64	count
64	Garlic cloves	1	clove	40	5 pound = 40 cloves	68	68	cloves	2		$0.21	E	$8.25	$16.50	12	cloves
65	STORAGE & MISCELLANEOUS		GROUP	PER CASE	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
66	Ziplock Bags - gallon	0.25	boxes	9	boxes/40 count	71	17.75	boxes	3		$3.06	E	$27.56	$82.68	9.25	boxes
67	Ziplock Bags - quart	0.25	boxes	12	boxes/32 count	71	17.75	boxes	3		$2.53	E	$30.40	$91.20	18.25	boxes
68					right number per box?
69	SPICES		GROUP	PER CASE	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
70	Tostitos Mild Salsa	1	bottles	9	28 oz. plastic bottle	71	71	bottles	10	9242645	$2.97	E	$26.75	$267.50	19	bottles
71	Cinnamon - ground	1	bottles
72	Salt & Pepper - rotate lids	1	set bottles	12	2 oz. containers	71	71	bottles	8		$1.38	E	$16.50	$132.00	25	container
73	Oregano	1	bottle	12	0.75 oz. plastic bottle	71	71	bottles	7	9242868	$0.00	E		$0.00	13	bottles
74	Cumin	1	bottle	12		71	71	bottles	7			E		$0.00	13	bottles
75	Tabasco Pepper Sauce	1	bottle	24	2 oz.	68	68	bottles	3	5914619	$1.23	E	$29.61	$88.83	4	bottles
76	Basil	1	bottle	12	0.25 oz. plastic bottle	68	68	bottles	7	9242819	$0.00	E		$0.00	16	bottles
77	KOSHER		GROUP	PACK	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
78	Trail Mix - Tropical Treasures Snack Mix	24	lbs.	3	2 lb. bag	3	72	pounds	12	5730833	$5.25	E	$15.75	$189.00	0	pounds
79	Uneeda Biscuits	5	lbs.			3	12	pounds							-12	boxes
80	Dried Fruit	3	lbs.	10	10 lb. bag	3	9	pounds	1		$4.90	C	$49.00	$49.00	1	pounds
81	Pasta Mix (we've never found a good one)	4	envelopes			3	12	envelopes							-12	envelopes
82	FRESH KOSHER		GROUP	PACK	SIZE	GROUPS	FT	NEEDS	CASES	CODE	PRICE	UNIT	PRICE	PRICE	EXTRA		GROUPS	OVER
83	Tortillas - 10"	4	package	12	12 per package	3	12	packages	1		$2.49	Pkg.	$29.90	$29.90	0	packages
84	Pita - 6"	8	package	6	12 oz - 12/package	3	24	packages	4	2404481	$1.83	E	$10.97	$43.88	0	packages
85													TOTAL =	$28,103