Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 7 Starbright Coffee Shop serves two coffee blends: Heartland and Coastal. Heartland sells for $ 3 . 0 0 , and Coastal sells for

Question 7
Starbright Coffee Shop serves two coffee blends: Heartland and Coastal. Heartland sells for $3.00, and Coastal sells for $2.50.
Each blend is a combination of three high-quality coffees from Colombia, Kenya, and Indonesia.
The coffee shop could have 5 pounds of coffee from each country available each day. Each pound of coffee will produce 20 mugs of coffee.
The shop has enough brewing capacity to brew 30 gallons of coffee each day. Note: One gallon contains 8 mugs.
Heartland is a blend of 80% Colombian, 10% Kenyan, and 10% Indonesian.
Coastal is a blend of 50% Colombian, 20% Kenyan, and 30% Indonesian.
The shop sells 1.5 times more Coastal than Heartland each day.
The manager wants to know how many mugs of each blend to sell each day to maximize sales.
a) List the constaints in the table to the left. You may also list them
below if that's helpful for you.
c) Use Excel's Solver to find the solution.
b) Graph the constaints in
desmos.com and save as a .png file. (Hit Share, Export Image, Save.) Attach it as a
separate file in Blackbaord, or include it in this Excel file. Graph must be zoomed in so I can see all of the
details of where the constraints intersect the axes.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transport Operations

Authors: Allen Stuart

2nd Edition

978-0470115398, 0470115394

More Books

Students also viewed these General Management questions