The Clarkson Coffee Company produces two grades of coffee, the Superb blend and the Run-of-the-Mill blend....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Clarkson Coffee Company produces two grades of coffee, the Superb blend and the Run-of-the-Mill blend. Three types of coffee beans are combined to produce these blends. The availability and cost of these beans for the upcoming month are shown in the table below: Typeof Coffee Bean Cost($ per thousand pounds) Availability(thousands of pounds) A B C $2,500 $2,000 $1,400 700 900 800 In addition to the limitations of raw material availability, the company must satisfy a set of quality control restrictions. The Superb blend, which sells for $3,000 per thousand pounds, must contain at least fifty percent Type A beans and no more than twenty percent Type C beans. The Run-of-the-Mill blend, which sells for $1,800 per thousand pounds, must contain at least thirty percent Type A beans and no more than sixty percent Type C beans. Also, to have a more balanced production, they want to make sure Superb blend production does not exceed Run-of-the-Mill production by more than 500 pounds. The Clarkson Coffee Company would like to determine how many thousands of pounds of each type of bean to purchase so as to maximize profit from the resulting mixes of the two blends. a. Formulate an LP model for this problem. b. Make a spreadsheet model for this problem and solve it using Solver. Report the optimal solution (i.e. values for all the decision variables) The Clarkson Coffee Company produces two grades of coffee, the Superb blend and the Run-of-the-Mill blend. Three types of coffee beans are combined to produce these blends. The availability and cost of these beans for the upcoming month are shown in the table below: Typeof Coffee Bean Cost($ per thousand pounds) Availability(thousands of pounds) A B C $2,500 $2,000 $1,400 700 900 800 In addition to the limitations of raw material availability, the company must satisfy a set of quality control restrictions. The Superb blend, which sells for $3,000 per thousand pounds, must contain at least fifty percent Type A beans and no more than twenty percent Type C beans. The Run-of-the-Mill blend, which sells for $1,800 per thousand pounds, must contain at least thirty percent Type A beans and no more than sixty percent Type C beans. Also, to have a more balanced production, they want to make sure Superb blend production does not exceed Run-of-the-Mill production by more than 500 pounds. The Clarkson Coffee Company would like to determine how many thousands of pounds of each type of bean to purchase so as to maximize profit from the resulting mixes of the two blends. a. Formulate an LP model for this problem. b. Make a spreadsheet model for this problem and solve it using Solver. Report the optimal solution (i.e. values for all the decision variables)
Expert Answer:
Answer rating: 100% (QA)
To formulate an LP model for this problem we need to define the decision variables objective functio... View the full answer
Related Book For
Quantitative Methods for Business
ISBN: 978-0324651751
11th Edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam
Posted Date:
Students also viewed these mathematics questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
respond to the instruction using the following criteria: Individual Written Case Exercise Respond to the specific questions provide in the case document it will be seven documents. Please make sure...
-
Your restaurant has five menu choices for lunch. How many ways can you order them on your menu? A 0.0749 B 0.0747 120
-
Assume that the readings on the thermometers are normally distributed with a mean of 0C and a standard deviation of l.00C. A thermometer is randomly selected and tested. In each case, draw a sketch,...
-
In Exercises test for convergence or divergence, using each test at least once. Identify which test was used. (a) n th-Term Test (b) Geometric Series Test (c) p -Series Test (d) Telescoping Series...
-
Evaluate machine XYZ on the basis of the PW method when the MARR is $12 \%$ per year. Pertinent cost data are as follows: Investment cost Useful life Market value Annual operating cost Overhaul cost...
-
Frankel Inc. experienced the following transactions for 2013, its first year of operations: 1. Issued common stock for $60,000 cash. 2. Purchased $210,000 of merchandise on account. 3. Sold...
-
Benchmark has an optimal target capital structure consisting of a debt-to-assets ratio of 60 percent. Benchmark can raise up to $5 million in new debt at a before-tax cost of 8 percent. If more debt...
-
During 2023, the city of East Brunswick awards a $100,000 grant to a not-for-profit organization to be used for the acquisition of equipment. The grant is to be paid by East Brunswick as the...
-
Two balls approach each other as shown in the figure. The mass m = 2.0 kg with a velocity of 3.0 m/s while mass M = 4.0 kg with a velocity of 5.0 m/s. If the balls collide and stick together at the...
-
When you are pushed to the side of a car while making a sharp turn, it may feel like the side of the car has developed a gravitational attraction for you. How fast would you have to drive around a...
-
There are two horizontal rows of four students each facing each other. The rows are called Row-1 and Row-2. Eight students are named from A to H. The following conditions apply: 1. A stands opposite...
-
How much force is being experienced by each of the lifter's hands if the bar has a mass of 164 kg and she has a mass of 85 kg. You may use 10 m/s2 for gravity, leave the answer to zero decimal places...
-
Emotional intelligence, known as (qngshng) in Chinese, refers to the ability to understand, use, and manage one's own emotions, as well as the emotions of others. It is essential for individuals to...
-
What will the Internet will look like in 20 years? Explain.
-
Do animals have rights? If so, what are they? What duties do human beings have toward animals? Does KFC protect animal welfare at an acceptable level?
-
A golf ball is hit from the tee and travels above level ground. Accounting for air resistance, where is the horizontal location of the peak of the flight: at a position that is less than half the...
-
The velocity of an object is given in SI units by \(\vec{v}=\left(a t-b t^{2} ight) \hat{\imath}+c \hat{\jmath}\), with \(a=14 \mathrm{~m} / \mathrm{s}^{2}, b=10 \mathrm{~m} / \mathrm{s}^{3}\), and...
-
A cannon fires a shell at an angle such that the shell's initial velocity has a horizontal component of \(20 \mathrm{~m} / \mathrm{s}\) and a vertical component of \(35 \mathrm{~m} / \mathrm{s}\)....
Study smarter with the SolutionInn App