Results 1 to 8 of 8

Solver contraint problem Urgent help needed please

Threaded View

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    SA
    MS-Off Ver
    Excel 2010
    Posts
    9

    Solver contraint problem Urgent help needed please

    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
    Attached Files Attached Files
    Last edited by catgirl; 04-11-2013 at 05:32 AM. Reason: edited

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1