Answered step by step
Verified Expert Solution
Question
1 Approved Answer
4. DO THIS PROBLEM USING EXCEL and solver The Coffee Company (CC) sells three blended coffees: Special, Dark, and Regular. It uses four different
4. DO THIS PROBLEM USING EXCEL and solver The Coffee Company (CC) sells three blended coffees: Special, Dark, and Regular. It uses four different coffees, Brazilian, Mocha, Columbian, and Mild to produce the blends as follows: - Special must have at least 40% Columbian and at least 30% Mocha Dark must have at least 60% Brazilian, and at most 10% Mild Regular must have at most 60% Mild, and at least 30% Brazilian The selling prices, costs and availabilities are given below. lbs Coffees Cost per lb Available Brazilian $2.00 110,000 Blends Special Selling Price per lb 6.5 Columbian $2.90 80,000 Dark 5.25 Mild $1.70 150,000 Regular 3.75 Mocha $2.75 70,000 Assume that CC can sell all of the blended coffee that it produces. What should CCC do to maximize profit?
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