Statistical Analysis: Linear Optimization
Not what you're looking for?
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 given in the following table.
Bean Cost Available Pounds
1 0.5 500
2 0.7 600
3 0.45 400
Consumer tests with coffee products were used to provide quality ratings on a 0-to-100 scale, with higher ratings indicating higher quality. Product-quality standards for 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 aroma and taste ratings for coffee made from 100 percent of each bean are given in the following table.
Bean Aroma Taste
1 75 86
2 85 88
3 60 75
It is assumed 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 of the three beans that will meet the quality standards and provide 1,000 pounds of the blended coffee product?
b. What is the bean cost per pound of the coffee blend?
Purchase this Solution
Solution Summary
Solution develops a linear programming model for the given problem. It uses "Solver" in MS Excel to get the solution. Screen shots are attached for better understanding.
Education
- BEng (Hons) , Birla Institute of Technology and Science, India
- MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
- "Thank you"
- "Really great step by step solution"
- "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
- "Thanks Again! This is totally a great service!"
- "Thank you so much for your help!"
Purchase this Solution
Free BrainMass Quizzes
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts
Probability Quiz
Some questions on probability