Question: If you could please answer the questions I got wrong, please. I created an excel and used solver to answer this linear question, but I
If you could please answer the questions I got wrong, please. I created an excel and used solver to answer this linear question, but I guess I might have plugged in the wrong things in excel. So, if someone could please help me out, thanks.


A linear programming computer package is needed. Hilltop Coffee manufactures a coffee product by blending three types of coffee beans. The cost per pound and the available pounds of each bean are as follov Consumer tests with coffee products were used to provide ratings on a scale of 0100, with higher ratings indicating higher quality. Product quality standards the blended coffee require a consumer rating for aroma to be at least 75 and a consumer rating for taste to be at least 80 . The individual ratings of the arom taste for coffee made from 100% of each bean are as follows: Assume that the aroma and taste attributes of the coffee blend will be a weighted average of the attributes of the beans used in the blend. (a) What is the minimum-cost blend (in pounds) that will meet the quality standards and provide 1,000 pounds of the blended coffee product? Bean 1 Ib Bean 2 $ (c) Determine the aroma rating for the coffee blend. Determine the taste rating for the coffee blend. (d) If additional coffee were to be produced, what would be the expected cost per pound (in dollars)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
