+ Reply to Thread
Results 1 to 2 of 2

Why can't you run a sensitivity report in Solver with an integer constraint?

  1. #1
    Registered User
    Join Date
    02-13-2020
    Location
    Florida
    MS-Off Ver
    Office 365
    Posts
    1

    Question Why can't you run a sensitivity report in Solver with an integer constraint?

    Hi everyone, first time on the forum.

    I have a conceptual question for you all. I am attempting minimize cost for a Help Desk operation using Solver for a project and would like to explain the Sensitivity Report, however, I only see an Answer Report when Solver finishes solving the problem. After googling the issue, I found that a Sensitivity Report is not available if you have an integer constraint. I am minimizing cost based on the number of employees working during that shift, so obviously I cannot have a fraction of a person working and need to use whole numbers.

    Could someone explain to me why a Sensitivity Report isn't available when an integer constraint is present in the problem?

    Thank you!

  2. #2
    Valued Forum Contributor Hydraulics's Avatar
    Join Date
    07-15-2018
    Location
    Udine - Italy
    MS-Off Ver
    Office 365
    Posts
    369

    Re: Why can't you run a sensitivity report in Solver with an integer constraint?

    A sensitivity analysis can be performed only for models with continuous variables since it depends on derivatives.

    Under Solver Options there is an Ignore Integer Constraints check box.
    Aim high or don't even try.
    ---------------------------------
    If your question has been answered, don't forget to mark the thread as SOLVED.
    If you find an answer helpful, click on the star icon at the bottom of the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sensitivity Report not showing in Solver
    By b1yan101 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2016, 02:11 AM
  2. solver sensitivity analysis report
    By mmcsgoncalves in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-03-2014, 03:15 PM
  3. solver and sensitivity report
    By megtoma in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-13-2009, 08:42 AM
  4. Question related to Sensitivity Report (Solver)
    By hakimov in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-25-2008, 02:29 PM
  5. Replies: 0
    Last Post: 03-29-2005, 10:06 AM
  6. [SOLVED] solver constraint
    By jojo in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-18-2005, 10:06 AM
  7. Definition of integer constraint
    By kimber in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-12-2005, 05:06 PM

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