PLEASE USE EXCEL TO SOLVE THIS

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. 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) natarminn 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)? $