i need to do this using the solver:
I cannot get the constraints right i tried various ways but nope. please help?
On the Data tab, click on Solver to get the Solver Parameters box. Set the target cell to H8, the Total Profit cell. To maximize total profit, click on the Max button. Enter Barrels for By Changing Cells. This allows Solver to maximize total profit by changing the entries in the barrels cells.
The entrepreneur cannot use more resources than are available. In the Subject to Constraints box, constraints need to be added. Click on the Add button and use the above cell names to add a constraint that ensures that the amount of resources used is less than or equal to the amount of resources that are available.
Another constraint needs to be added, namely that the entries in the cells named barrels must be greater than or equal to zero. Add this constraint.
Finally, click on the Solve button. What are the number of barrels of Light, Dark, Ale and Premium that should be made to maximize total profit for the month? i cannot get this right, please help? thanks!
here a screenshot of the data:
Excersize 7.JPG
Bookmarks