Answered step by step
Verified Expert Solution
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
Starbright Coffee Shop serves two coffee blends: Heartland and Coastal. Heartland sells for $ and Coastal sells for $
Each blend is a combination of three highquality coffees from Colombia, Kenya, and Indonesia.
The coffee shop could have pounds of coffee from each country available each day. Each pound of coffee will produce mugs of coffee.
The shop has enough brewing capacity to brew gallons of coffee each day. Note: One gallon contains mugs.
Heartland is a blend of Colombian, Kenyan, and Indonesian.
Coastal is a blend of Colombian, Kenyan, and Indonesian.
The shop sells 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started