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 follows. Bean Cost per Pound Available Pounds $0.50 $0.70 $0.45 1 2 3 2 Consumer tests with coffee products were used to provide ratings on a scale of 0-100, with higher ratings indicating higher quality. Product quality standards for the blended coffee require a consumer rating for aroma to be at least consumer rating for taste to be at least 80. The individual ratings of the aroma and taste for coffee made from 100% of each bean are as follows: 3 Bean Aroma Rating Taste Rating 1 75 85 60 lb 85 lb lb 450 87 650 74 450 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 Bean 2 Bean 3

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
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 follows.
Bean Cost per Pound Available Pounds
1
2
3
1
$0.50
2
$0.70
3
$0.45
Consumer tests with coffee products were used to provide ratings on a scale of 0-100, 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 individual ratings of the aroma and taste for coffee made from 100% of each bean are as follows:
Bean Aroma Rating Taste Rating
75
85
60
85
lb
lb
lb
450
87
650
74
450
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
Bean 2
Bean 3
(b) What is the cost per pound for the coffee blend (in dollars)?
$
(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)?
$
Transcribed Image Text: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 follows. Bean Cost per Pound Available Pounds 1 2 3 1 $0.50 2 $0.70 3 $0.45 Consumer tests with coffee products were used to provide ratings on a scale of 0-100, 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 individual ratings of the aroma and taste for coffee made from 100% of each bean are as follows: Bean Aroma Rating Taste Rating 75 85 60 85 lb lb lb 450 87 650 74 450 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 Bean 2 Bean 3 (b) What is the cost per pound for the coffee blend (in dollars)? $ (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)? $
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 10 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.