This problem requires Excel and the solver function, thank you for your help.

3.- Read problem 2.6 of Becker's Optimization book (image attached below.) You don't have to solve this problem, just answer the following questions What is the criterion for this problem? What are the choice variables and the constraints? (1pt) What functions would you need to calculate to solve this problem? (1pt) . What are the parameters of this problem? (1pt) 2.6 Coffee Blending and Sales: Hill-O-Beans Coffee Company blends four com- ponent beans into three final blends of coffee: one is sold to luxury hotels, another to restaurants, and the third to supermarkets for store-label brands. The company has four reliable bean supplies: Argentine Abundo, Peruvian Colmado, Brazilian Maximo, and Chilean Saboro. The table below summarizes the very precise recipes for the final coffee blends, the cost and weekly availability information for the four components, and the wholesale price per pound of the final blends. The percentages indicate the fraction of each component to be used in each blend.final blends. The percentages indicate the fraction of each component to be used in each blend. Cost per Pounds Component Hotel Restaurant Market Pound ($) Available Abundo 20% 35% 10% 0.60 40.000 Colmado 40% 15% 35% 0.80 25,000 Maximo 15% 20% 40% 0.55 20,000 Saboro 25% 30% 15% 0.70 45,000 Wholesale price $1.25 $1.50 $1.40 per pound The processor's plant can handle no more than 100,000 pounds per week, and Hill-O-Beans would like to operate at capacity, if possible. Selling the final blends is not a problem, although the marketing department requires minimum production levels of 10,000, 25,000, and 30,000 pounds, respectively, for the hotel, restaurant, and market blends