SupermarketSweep.xlsx

	A	B	C	D	E	F
1	DATA					DECISION VARIABLES
2		Item	Cost	Size	Category	xi = amount the of each item in the cart
3		Turkey	$15	10	Meat/Seafood	3
4		Pot Roast	$25	6	Meat/Seafood	3
5		Shrimp	$8	2	Meat/Seafood	3
6		Apples	$5	5	Produce	3
7		Potatoes	$4	6	Produce	3
8		Watermelon	$3	7	Produce	0
9		Olive Oil	$15	6	Baking	3
10		Flour	$2	2	Baking	3
11		Sugar	$2	2	Baking	3
12		Toilet Paper	$6	12	Health	2.666666667
13		Shampoo	$2	1	Health	3
14		Tyelnol	$3	1	Health	3
15		Coffee	$6	2	Other Food	3
16		Chocolates	$6	1	Other Food	3
17		Milk	$3	4	Other Food	3
18		Cereal	$2	3	Other Food	3
19		Cheddar Cheese	$3	1	Other Food	3
20		Bread	$3	3	Other Food	3
21		Peanut Butter	$3	1	Other Food	3
22		Pasta	$1	2	Other Food	0
23
24	OBJECTIVE FUNCTION
25		337
26
27	CONSTRAINT 1
28		200	200
29
30	CONSTRAINT SET 2
31			3
32
33	CONSTRAINT SET 3
34		Meat/Seafood	9	1
35		Produce	6	1
36		Baking	9	1
37		Health	8.666666667	1
38		Other Food	21	1
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