Find the optimal way of blending

Assignment Help Operation Management

Reference no: EM132112044

Using Solver:

Starducks Coffee is a local establishment in Portland, OR that has developed a reputation for selling a dark vanilla-tinged coffee (Called “It’s to Quack for!” - or ITQF) that people travel from miles around to buy. For the next two week period, they wish to find the least cost way to mix together their 4 main types of coffee (REG, DARK1, DARK2, VAN) to meet anticipated customer demand of 475 lbs. Their optimal mix can exceed 475 lbs if necessary.

The ITQF mix has some requirements. It must consist of at least 20% of the VAN coffee as a foundation of the unique flavor. ITQF must meet or exceed an average ‘robustness’ target of 5.7 and an average ‘color’ target of at least 3.75. From years of experience, there are explicit measures of robustness (RB) and color (CR) on a 1-7 scale for each of the four foundational coffees. REG has a RB rating of 4.7, a CO rating of 3, and a per pound cost of $4. DARK1 has a RB rating of 6, a CO rating of 5, and a per pound cost of $4.5. DARK2 has a RB rating of 6.9, a CO rating of 4.6, and a per pound cost of $6. VAN has a RB rating of 3.2, a CO rating of 2.1, and a per pound cost of $4.85.

Additionally, for the next two weeks, there is an unlimited supply of REG and VAN coffee to use, but only 150 pounds of DARK1 and 200 lbs of DARK2.

Find the optimal way (least cost) of blending together the ITQF coffee for the next two week period.

Reference no: EM132112044

Questions Cloud

What is your evidence for that prediction : what is your evidence for that prediction? How should companies respond? How would you respond? Why?

Numerical quotas and management by objectives : Eliminate numerical goals, numerical quotas and management by objectives. Substitute leadership instead.

Process of developing new products depends first on company : The process of developing new products depends first on a company’s _______. The opposite of a top-down approach is usually called _______.

What one part of the agreement would you choose to modify : What one part of the agreement would you choose to modify? Why would you choose this section to modify?

Find the optimal way of blending : Find the optimal way (least cost) of blending together the ITQF coffee for the next two week period.

Breach of contract case or some other contract dispute : Using the internet, research a contract issue. This can be a breach of contract case or some other contract dispute.

Example of experience marketing : Which of the following is an example of “experience marketing”? Which is not a quality associated with the brand name under the company’s control?

The contrast between mass marketing and one-to-one marketing : The contrast between mass marketing and one-to-one marketing illustrates that segments become more _______ as they increase in size.

What you like most in strategic management and why : Which of the following is an example of work-in-process inventory for an automobile company? What you like most in strategic management and why?

User Account

All Pages