+ Reply to Thread
Results 1 to 14 of 14

Excel Solver Problem - I've never used it

  1. #1
    Forum Contributor
    Join Date
    05-09-2012
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    136

    Excel Solver Problem - I've never used it

    hi All - I have a problem and think I would like to experience using solver to help me solve this:

    given 1000 acres of land, and that 75% of its is pasturable - I want to maximize the numbers of cows that can be on it.

    There can be a max of 1 cow per 2 acres

    And we need 1 bull per 3 acres

    The ratio of bulls to cows is 1 bull per 30 cows

    how many cows and how many bulls can we have in total for the 750 acres?

    Thank you!

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Excel Solver Problem - I've never used it

    If you tell me how you will count it manualy, then i will tranform your answer in an excel formula.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    05-09-2012
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    136

    Re: Excel Solver Problem - I've never used it

    What do you mean?

    I have 750 acres

    I want to maximize the number of cows for the 750 acres

    For every 30 cows I need 1 bull

    Each cow neeeds 2 acres to graze and each bull needs 3 acres to graze

    Does this help?

  4. #4
    Forum Contributor
    Join Date
    05-09-2012
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    136

    Re: Excel Solver Problem - I've never used it

    I would like to know how to maximize the number of cows on my land, given that I have 750 acres - give the constraints above

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Excel Solver Problem - I've never used it

    Without solver.

    See the green cell in the attached file.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    05-09-2012
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    136

    Re: Excel Solver Problem - I've never used it

    Oeldere - I was looking for maximum number of cows and bulls

  7. #7
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Excel Solver Problem - I've never used it

    330 cows and 11 bulls.

    The formula in f3 should refer to B3 instead of D3.

  8. #8
    Forum Contributor
    Join Date
    05-09-2012
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    136

    Re: Excel Solver Problem - I've never used it

    Thanks Oeldere - If I understand this correctly - If I was to assume 1 bull per 2 acres, instead of 3 - I'd get 360 cows and 12 bulls correct?

  9. #9
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Excel Solver Problem - I've never used it

    I suppose so, and you get 6 acres remaining.

    See the update file.
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    05-09-2012
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    136

    Re: Excel Solver Problem - I've never used it

    Oeldere - thank you kindly, that was great help!

  11. #11
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Excel Solver Problem - I've never used it

    Thanks for the reply.

    Glad i could help.

    If your problem is solved, will you mark it as solved?

    If you have other questions or comments on this topic, just ask or commend.

    You can add an * to the rep(utation) of the helper by clicking the star on the left side.

  12. #12
    Forum Contributor
    Join Date
    05-09-2012
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    136

    Re: Excel Solver Problem - I've never used it

    already taken care of Oeldere - thank you again!

  13. #13
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: Excel Solver Problem - I've never used it

    Even if you got a solution from oeldere you asked for a solver setup so here it is.

    Alf
    Attached Files Attached Files

  14. #14
    Forum Contributor
    Join Date
    05-09-2012
    Location
    Florida
    MS-Off Ver
    Excel 2013
    Posts
    136

    Re: Excel Solver Problem - I've never used it

    THanks a lot Alf - really appreciate that too

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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