To Be Completed Using Microsoft Excel/Solver Add-In Group Work Permissible. No more than 2 students per group. Hilltop Coffee manufactures a coffee product by blending three types of coffee beans. The cost per pound and the available pounds of each bean are as follows Available Pounds 500 600 400 Bean Cost per Pound S0.50 S0.70 S0.45 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 75 and a consumer rating for taste to be at least 80. The individual ratings of the aroma and taste for coffee made from 100% of each bean are as follows Bean Aroma Rating Taste Ratin 86 75 85 60 75 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. Hilltop would like to make 1000 pounds of coffee Required: A formulation of the problem with decision variables clearly defined; A copy of your spreadsheet with formulas exposed; The answer report (generated by Solver); The sensitivit sensitivity report (generated by Solver); Clear and concise answers to the following questions (type-written). A. What is the minimum-cost blend that will meet the quality standards and provide 1000 pounds of the blended coffee product? B. What is the cost per pound for the coffee blend? C. Determine the aroma and taste ratings for the coffee blend D. If additional coffee were to be produced, what would be the expected cost per pound? Due Date: Monday, May 21, 2018 at beginning of class