Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started