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?
How many bottles of light beer should the company produce in order to maximize weekly profit?
How many bottles of dark beer should the company produce in order to maximize weekly profit?
What is the shadow price for Malt?
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 ...
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)