4.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 $0.50 500 2 $0.70 600 3 $0.45 400 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: Aroma Rating Taste Веa n Rating 75 86 85 88 60 75 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 that will meet the quality standards and provide 1 000 pounds of the blended coffee product? b. What is the cost per pound for the coffee blend? c. Determine the aroma and taste ratings for the coffee blend.

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
100%
I need help please
4.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:
Вean
Cost per Pound Available Pounds
1
$0.50
500
2
$0.70
600
3
$0.45
400
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:
Aroma
Rating
Taste
Вea n
Rating
86
2
85
88
60
75
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 that will meet the quality standards and provide 1 000 pounds of the blended coffee product?
b. What is the cost per pound for the coffee blend?
c. Determine the aroma and taste ratings for the coffee blend.
Transcribed Image Text:4.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: Вean Cost per Pound Available Pounds 1 $0.50 500 2 $0.70 600 3 $0.45 400 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: Aroma Rating Taste Вea n Rating 86 2 85 88 60 75 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 that will meet the quality standards and provide 1 000 pounds of the blended coffee product? b. What is the cost per pound for the coffee blend? c. Determine the aroma and taste ratings for the coffee blend.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 5 images

Blurred answer
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.