The Diaz coffee Company blends three types of coffee beans (Brazilian, Columbian, and Peruvian) into ground coffee to be sold at retail. Suppose that each kind of beans has a distinctive aroma and strength, and the company has a chief taster who can rate these features on a scale of 1 to 100. The features of the beans are tabulated as follows: Bean Aroma Rating Strength Rating Cost/Ib. Pounds Available Brazilian 78 15 $0.50 1,500,000 Colombian 60 20 $0.60 1,200,000 Peruvian 85 18 $0.70 2,000,000 The company would like to create blend that has an aroma rating of least 78 and strength rating of at least 16. Its supplies of the various beans are limited, however. The available quantities are specified above. All beans are delivered under a previously arranged purchased agreement. Diaz wants to make four millions pounds of blend at the lowest possible cost.

(a) Use Excel to formulate and solve this problem. (label the tab in Excel spreadsheet as Q3) [20]. (Extra marks for details of algebraic equation of objective function and constraints)