Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

How does fixed pricing differ from dynamic pricing?

Answered: 1 week ago