PLEASE SHOW ME STEP BH STEP IN EXCEL. i think solver add in is supposed to be used. thnk you!

2.1 Verifying Linearity: Revisit Examples 2.2, 2.3, and 2.4 and verify that the properties of proportionality, additivity, and divisibility are reasonable assumptions in modeling each problem. EXAMPLE 2.4 Keogh Coffee Roasters Keogh Coffee Roasters blends three types of coffee beans (Brazilian, Colombian, and Peruvian) into ground coffee that is sold at retail. Each kind of bean has a distinctive aroma and taste, and the company has a chief taster who can rate the fragrance of the aroma and the strength of the taste on a scale of 1100. The features of the beans are tabulated below. Keogh would like to reate a blend that has an aroma rating of at least 78 and a strength rating of at least 16 . However, its supplies of the various beans are limited. The available quantities are 1500 pounds of Brazilian, 1200 pounds of Colombian, and 2000 pounds of Peruvian beans, all delivered under a previously arranged purchase agreement. Keogh wants to make 4000 pounds of the blend at the lowest possible cost