You're right. At 04:39, I used -0.25R1 - 0.25R2 +0.75R3 ≤ 0 in my input instead of -0.25R1 - 0.25R2 +0.75R3 ≥ 0. Thanks, Małgorzata Petzel, for taking the time to check it out and for posting.
Hi Joshua, I have watched this video so many times and still struggling with this assignment, what am I doing wrong, Kindly assist. Thank you 2. The Mill Mountain Coffee Shop blends coffee on the premises for its customers. It sells three basic blends in 1-pound bags, Special, Mountain Dark, and Mill Regular. It uses four different types of coffee to produce the blends - Brazilian, mocha, Colombian, and mild. The shop has the following blend recipe requirements: Blend Mix requirements Selling price ($)/pound Special At least 30% Columbian, at least 40% mocha 6.20 Dark At least 50% Brazilian, no more than 10% mild 5.50 Regular No more than 70% mild, at least 30% Brazilian 4.00 The cost of Brazilian coffee is $2.00 per pound, the cost of mocha is $2.75 per pound, the cost of Colombian is $2.90 per pound, and the cost of mild is $1.70 per pound. The shop has 110 pounds of Brazilian coffee, 70 pounds of mocha, 80 pounds of Colombian, and 150 pounds of mild coffee available per week. The shop wants to know the amount of each blend it should prepare each week to maximize profit. (a) Define the decision variables (b) Write the objective function (c) (6Pts) List all the constraints.
See if this helps: www.studocu.com/en-ca/document/humber-college/statistics/final-exam-review-8-december-2016-questions-and-answers/3557972 OR mathcracker.com/solution-library/mill-mountain-coffee-shop-blends-coffee-premises-45415
Better solution (Excel Solver)
R1 = 32 000, R2 = 73 000, R3 = 99 000, P1 = 50 000, P2 = 23 000, P3 = 0
Objective function value = 0,15774 E +08
You're right. At 04:39, I used -0.25R1 - 0.25R2 +0.75R3 ≤ 0 in my input instead of -0.25R1 - 0.25R2 +0.75R3 ≥ 0.
Thanks, Małgorzata Petzel, for taking the time to check it out and for posting.
how would you input these numbers into Excel? Thank you!
See if this video helps: ua-cam.com/video/ziVlZrTmtI4/v-deo.html
Hi Joshua,
I have watched this video so many times and still struggling with this assignment, what am I doing wrong, Kindly assist. Thank you
2. The Mill Mountain Coffee Shop blends coffee on the premises for its customers. It sells three
basic blends in 1-pound bags, Special, Mountain Dark, and Mill Regular. It uses four different
types of coffee to produce the blends - Brazilian, mocha, Colombian, and mild. The shop has the
following blend recipe requirements:
Blend Mix requirements Selling price ($)/pound
Special At least 30% Columbian, at least 40% mocha 6.20
Dark At least 50% Brazilian, no more than 10% mild 5.50
Regular No more than 70% mild, at least 30% Brazilian 4.00
The cost of Brazilian coffee is $2.00 per pound, the cost of mocha is $2.75 per pound, the cost
of Colombian is $2.90 per pound, and the cost of mild is $1.70 per pound. The shop has 110
pounds of Brazilian coffee, 70 pounds of mocha, 80 pounds of Colombian, and 150 pounds of
mild coffee available per week. The shop wants to know the amount of each blend it should
prepare each week to maximize profit.
(a) Define the decision variables
(b) Write the objective function
(c) (6Pts) List all the constraints.
See if this helps: www.studocu.com/en-ca/document/humber-college/statistics/final-exam-review-8-december-2016-questions-and-answers/3557972
OR
mathcracker.com/solution-library/mill-mountain-coffee-shop-blends-coffee-premises-45415
@@joshemman Thank you so much! Let me check it out. Be blessed!