Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Star Coffee sells three coffee blends (in 1-lb packages): PremiumCream, DeliSoft, and ValleyTaste. These blends are obtained by carefully mixing coffee beans imported from various

Star Coffee sells three coffee blends (in 1-lb packages): PremiumCream, DeliSoft, and ValleyTaste. These blends are obtained by carefully mixing coffee beans imported from various countries, as presented below. For example, 1 lb of PremiumCream is the result of blending 70% Ethiopian and the remaining 30% Indonesian beans (no Colombian or Brazilian beans). Due to contracts with suppliers, minimum monthly bean consumptions must be satisfied. Due to logistics/capacity, monthly bean consumptions cannot exceed maximum monthly amounts as given below. For example, monthlly consumption of Ethipian beans must be at least 200 lb but no more than 1000 lb.
PremiumCream DeliSoft ValleyTaste Minumum Consumption Maximum Consumption
1 lb 1 lb 1 lb lb lb
Ethiopian beans 0.7 0.3 200 1000
Indonesian beans 0.3 0.2 100 2000
Colombian beans 0.3 0.8 400 1000
Brazilian beans 0.2 0.2 100 3000
Profit contributions are given below. For example, 1 lb of PremiumCream generates a profit of $3.50
PremiumCream DeliSoft ValleyTaste
($/lb) ($/lb) ($/lb)
Profit contribution 3.5 2.8 2.5
The marketing department estimates demand for these blends should not exceed the quantities provided below.
PremiumCream DeliSoft ValleyTaste
(lb/month) (lb/month) (lb/month)
Demand 1500 2500 2000
How many pounds of PremiumCream, DeliSoft, and ValleyTaste should Star Coffee produce every month in order to maximize total profit? Assume the variables are continuous. Formulate the problem below (obtain the mathematematical model) USEING EXEL

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

Step: 3

blur-text-image

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

Corporate Finance

Authors: David Hillier, Stephen A. Ross, Randolph W. Westerfield, Bradford D. Jordan, Jeffrey F. Jaffe

3rd Edition

0077173635, 9780077173630

Students also viewed these Economics questions

Question

What are the overall trends in hardware?

Answered: 1 week ago

Question

1. Walk slowly; then be as still as possible.

Answered: 1 week ago