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
-
Select Customer: Sandy Copper: Remy Select Invoice Date: 02/13/2023 Enter Tags: Pet Tag: Remy > Marketing Channel Tag: Friends & Family Select Item Details Line 1: Product/Service: Dog Treat Training...
-
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,...
-
A girl has a large, docile dog she wishes to weigh on a small bathroom scale. She reasons that she can determine her dogs weight with the following method: First she puts the dogs two front feet on...
-
Journalizing materials requisitions Ozark Manufacturing Inc. records the following use of materials during the month of June: Date Req. No. Use Direct Materials Materials Requisitions Indirect...
-
Gayles Glassworks makes glass flanges for scientific use. Materials cost $1 per flange, and the glass blowers are paid a wage rate of $28 per hour. A glass blower blows 10 flanges per hour. Fixed...
-
Landen Corporation uses job - order costing. At the beginning of the year, it made the following estimates: Direct labor - hours required to support estimated production 1 4 5 , 0 0 0 Machine - hours...
-
The graph of y(x) is given. Graph the function y-f(x+4)+2, 9-1(x) A IU
-
A widget factory has the following parameters: Factory Construction Cost: $150,000 / 1,000 widgets of annual production capacity Annual Production Capacity: 45,000 widgets/year Widget Contracted Sale...
-
Drawing from the case of BlackBerry, critically discuss the application and limitations of the Systems theory in determining the interdependent relationship which exists between the organisation and...
-
Sara is considering whether to open a gadgets shop. She provided you, as a consultant, the following information on June 30, 2021: Sales of $60,000 and $72,000 are expected for July and August,...
-
We consider an example that applies to individuals and ourselves and companies. We assume that we are the owners of the property. This can be our main residence, a rental property we buy, or a...
-
1. What is time-driven activity based management (TDABC)?How does it differfrom activity based costing (ABC)and why would TDABC be used in place of ABC? 2. According to a Wall Street Journal article...
-
Consolidation spreadsheet for continuous sale of inventory - Equity method Assume that a parent company acquired a subsidiary on January 1, 2010. The purchase price was $500,000 million in excess of...
-
Eleni Cabinet Company sold 2,200 cabinets during 2011 at $160 per cabinet. Its beginning inventory on January 1 was 130 cabinets at $56. Purchases made during the year were as follows: February . 225...
-
Investment recommendation (Learning Objective 4) Take the role of an investment analyst at A. G. Edwards. It is your job to recommend investments for your client. The only data you have are the ratio...
-
Comparison of common-size financials (Learning Objective 3) Select a company and obtain its financial statements. Convert the income statement and the balance sheet to common size and compare the...
-
Identify affected ratios (Learning Objective 4) Lance Berkman is the controller of Saturn, a dance club whose year-end is December 31. Berkman prepares checks for suppliers in December and posts them...
Study smarter with the SolutionInn App