1. Coffee Bucks manufactures a coffee product by blending three types of coffee beans. The cost per pound the available pounds of each bean are as follows: 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 72 and a consumer rating for the taste to be at least 79. The individual ratings of the aroma and taste for coffee made from 100% 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. Based on CoffeeBucks' past experience, 5% of each type of coffee bean gets bad, and CoffeeBucks cannot use bad coffee beans to make the blended coffee product. Exactly 1270 pounds of the blended coffee product is required. a) Formulate a linear programming model that will meet the quality standards while minimizing cost. b) Solve the problem by using Excel Solver (Hand-in the value and formulas printouts for the problem). Show the optimal solution and optimal value in your printouts. 1. Coffee Bucks manufactures a coffee product by blending three types of coffee beans. The cost per pound the available pounds of each bean are as follows: 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 72 and a consumer rating for the taste to be at least 79. The individual ratings of the aroma and taste for coffee made from 100% 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. Based on CoffeeBucks' past experience, 5% of each type of coffee bean gets bad, and CoffeeBucks cannot use bad coffee beans to make the blended coffee product. Exactly 1270 pounds of the blended coffee product is required. a) Formulate a linear programming model that will meet the quality standards while minimizing cost. b) Solve the problem by using Excel Solver (Hand-in the value and formulas printouts for the problem). Show the optimal solution and optimal value in your printouts