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-10, 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
1	75	89
2	85	88
3	60	75

Assume that the aroma and taste attributes of the coffee blend will be 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 1000 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.

d. If additional coffee were to be produced, what would be the exoected cost per pound?

This needs to be put in an Excel spread sheet. Can you show how you got the answer.

Thanks