+ Reply to Thread
Results 1 to 2 of 2

Need urgent help with solver. It does not change value

  1. #1
    Registered User
    Join Date
    04-08-2013
    Location
    singapore
    MS-Off Ver
    Excel 2010
    Posts
    1

    Need urgent help with solver. It does not change value

    Hi ppl. Need some help urgently here. Appreciate any help.

    I am supposed to optimise the cost to the lowest values. As you can see, I have to fulfill the demand based on the production capabilities of the 3 factories A,B,C. I used solver but the cost doesnt change from what i already have filled in. why??

    Appreciate all help.
    Attached Files Attached Files

  2. #2
    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,758

    Re: Need urgent help with solver. It does not change value

    Because your "filled in values" are an optimal solution and solver can't improve on it. If you clear the range "I13:M15" and do a rerun of solver, the optimal solution found by solver will be $78 675 so your "guessimate" of $58 200 is a much better solution as you have set the object function to minimize costs.

    Question really is why can't solver find the same optimal value?

    Alf

+ 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