question :

• Using Excel, determine the optimal mix for a single box which maximizes your profits while adhering to Brazil Bean's constraints.

Competitive Advantage ss 57 59 56 55 Apply Your Knowledge Brazil Bcans, a wholesale distributor of coffee beans, buys overstocked beans and sells them for a discount of over 50 percent to small and privately owned coffee shops. Each month Brazil Beans has a variety of beans available for sale and you need to determine which beans to buy to make the most profit possible. You can order as much coffee as you require, and this months options include: BRAND WEIGHT COST SALE PRICE Gold Ground - A versatile complex blend 14 S13 combining great Latin American and Asia Pacific coffees with a touch of Italian Roast. Great in a coffee press drip brewer or even as espresso French Vanilla - Blunt, smoky flavors are the 13.5 2 SHI objective in creating this, our darkest roasted coffee The intense flavor makes it one of our most popular coffees Special Dark Roast - A full bodied, complex 13 blend. This medium toast features a sweet, nutty taste Vanilla Hazelnut Treat your guests with the 12.5 $7 delicious aroma and robust flavor our most intense roast and the most pronounced in terms of dark. deep roasted flavor and hazelnut. Lots of character Organic Special Roast - In the world's best coffee 55 producing regions, there remain a select number of farmers who have grown coffee the same way for generations. They plant and nurture each coffee tree using only environmentally friendly techniques They harvest each crop by hand. The coffee from these farms is 100% organic and the flavor is pure...the way nature intended it to be Brazil Beans has a few constraints when placing orders including 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 cach different bean type Each box ordered must weigh equal to or less than 150 ounces PROJECT FOCUS: Using Excel, determine the optimal mix for a single box which maximizes your profits while adhering to Brazil Bean's constraints. File:CA AYK 10 56 Am Maling to Decim Dilem Dec le