Oct 13th, 2014
Business Finance
Price: $30 USD

Question description



 DUE DATE: October 8, 2014


You have recently inherited your grandfather’s coffee shop, The Broadway Cafe, which is conveniently located on Fulton Mall in downtown Brooklyn, NY. The location of the café is within a block from LIU Brooklyn Campus. The cafe offers many different kinds of specialized coffees, teas, a full service bakery, and homemade sandwiches, soups, and salads. Your grandfather first opened The Broadway Cafe in 1952 and it was a local hotspot for many years.

Unfortunately, business has been steadily declining over the last five years. Although your grandfather was an expert at running the coffee shop, it is outdated. There are no computers in the store and all ordering takes place manually. Your grandfather had a terrific memory and knew all of his customers by name, but unfortunately, none of this information is located anywhere in the store. The family recipes for the baked goods and soups are also stored in your grandfather’s memory. Inventory is tracked in a note pad, along with employee payroll, and marketing coupons. The Cafe does not have a Web site, uses very little marketing except word- of-mouth, and essentially still operates the same as it did in 1952.

As the owner and chief operating officer of The Broadway Café, you will take advantage of business practices discussed in BUS 110 – Foundations of Management Information Systems to increase profits, keep the business running, and bring the cafe into the 21st century.


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:

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


  • Using Excel, determine the optimal mix for a single box which maximizes your profits while adhering to Brazil Bean’s constraints
  • Briefly document, describe and support your answers for the optimal mix
  • Include snapshots of your Excel worksheets as part of your documentation (see previous bullet points)
  • Use template BrazilBeansExcelFile.xls for your optimization analysis.


All of your work must be packaged in one document. It is recommended that the snapshots of your Excel be included as images into your overall documents; loose images will not be considered. To submit your work, simply upload your document into your own BUS 110 Google Drive.

Tutor Answer

(Top Tutor) sagitahm
School: University of Maryland

Studypool has helped 1,244,100 students

Review from student
" Outstanding Job!!!! "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1823 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors