Activity Assignment 3

Activity Date: February 10, 2016

Activity Points: 10 Points

Activity Due Date: February 17, 2016

Brazil Beans, 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 month’s options include:

BRAND

WEIGHT

COST

SALE PRICE

Gold Ground – A versatile, complex blend 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.

14 oz

$8

$13

French Vanilla – Blunt, smoky flavors are the objective in creating this, our darkest roasted coffee. The intense flavor makes it one of our most popular coffees.

13.5 oz

$7

$11

Special Dark Roast – A full bodied, complex blend. This medium roast features a sweet, nutty taste.

13 oz

$6

$9

Vanilla Hazelnut – Treat your guests with the 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.

12.5 oz

$5

$7

Organic Special Roast – In the world’s best coffee 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.

10 oz

$5

$6

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 each 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.
  • Download the following excel file: BrazilBeansExcelFile-activity3

Submit a Comment

Your email address will not be published. Required fields are marked *