PLEASE ANSWER CORRECTLY IN EXCEL FOR UPVOTE

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 lb Bean 2 lb Bean 3 lb (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)