I HAVE ALREADY ASKED THIS QUESTION BEFORE BUT THE ANSWER WAS UNCLEAR. PLEASE SHOW HOW TO INPUT THIS QUESTION INTO EXCEL AND USE SOLVER TO GET THE ANSWER REPORT AND SENSITIVITY ANALYSIS. PLEASE SHOW THE CONSTRAINTS INPUTED, OBJECTIVE FUNCTION, AND OTHER DATA CLEARLY. THANKS.

(Direction for Hw: You need to solve the LP's in excel also and attach the "Answer Report" and Sensitivity Report" for each question.) Please show the formulas inserted in excel and how you got the answers. \# 4. 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 bean 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: The company would like to create a blend that has an aroma rating of at least 78/lb and a strength rating of at least 16/lb. Its supplies of the beans are limited, however. The available quantities are specified above. All beans are delivered under a previously arranged purchase agreement. Diaz wants to make at least 4,000 pounds of the blend at the lowest possible cost. (Direction for Hw: You need to solve the LP's in excel also and attach the "Answer Report" and Sensitivity Report" for each question.) Please show the formulas inserted in excel and how you got the answers. \# 4. 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 bean 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: The company would like to create a blend that has an aroma rating of at least 78/lb and a strength rating of at least 16/lb. Its supplies of the beans are limited, however. The available quantities are specified above. All beans are delivered under a previously arranged purchase agreement. Diaz wants to make at least 4,000 pounds of the blend at the lowest possible cost