LP to maximize profit for a brewery
Not what you're looking for?
The production manager for Beer etc. produces 2 kinds of beer: light (L) and dark (D). Two resources used to produce beer are malt and wheat. He can obtain at most 4800 oz of malt per week and at most 3200 oz of wheat per week respectively. Each bottle of light beer requires 16 oz of malt and 4 oz of wheat, while a bottle of dark beer uses 8 oz of malt and 8 oz of wheat. Profits for light beer are $2 per bottle, and profits for dark beer are $1 per bottle.
Formulate a linear programming model for this problem.
What is the optimal weekly profit?
100
200
400
600
800
How many bottles of light beer should the company produce in order to maximize weekly profit?
100
200
300
400
500
How many bottles of dark beer should the company produce in order to maximize weekly profit?
0
100
200
300
400
What is the shadow price for Malt?
0
0.125
0.250
0.375
0.5
Purchase this Solution
Solution Summary
Attached Excel has the LP model in the Solver tab and the answers highlighted, found using Excel Solver with appropriate options dialog selections. The shadow price is extracted from the Sensitivity Report tab)
Solution Preview
Student, see attached Excel which has the LP model in the Solver tab and these answers highlighted, found using Excel Solver with "Linear Model" and "Assume Nonnegative" checked on ...
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.