CA_AYKOriginal.xls

CA_AYK

Cohesion Case
CA_AYK
Input boxes in tan
Output boxes in yellow
Given data in blue
Answers in red

Brazil Beans

BRAZIL BEANS
Brand Weight (oz) Cost Sale Price Number of Bags per Box Profit per Bag Total Profit Total Weight
Gold Ground 14 8 13
French Vanilla 13.5 7 11
Special Dark Roast 13 6 9
Vanilla Hazelnut 12.5 5 7
Organic Special Roast 10 5 6
Total
Constraints:
Each box ordered must contain 20 bags of coffee or less
Each box ordered must contain 3 different types of beans
Each box ordered must contain between 4 and 8 bags of each different bean type
Each box ordered must weigh equal to or less than 150 ounces