+ Reply to Thread
Results 1 to 3 of 3

How to create a Sensitivity Report

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    2

    How to create a Sensitivity Report

    I have this data and am having problems making a sensitivity report. I have solver and made sure to set a constraint to make my totals less than or equal to my limits. And have made it linear and non negative but don't know how to go from there. I have tried to get the correct values for about an hour but I keep making a mistake somewhere. I was hoping someone could help me understand what cells I should be referencing in each category of solver so that I could get the sensitivity report to come out correct
    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: How to create a Sensitivity Report

    I've set up your model a bit different.

    Run solver. When you get the "solver result box" click "Sensitivity" and then "Ok"

    Alf
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    10-10-2012
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: How to create a Sensitivity Report

    Thanks for the help though the solution sheet I was shown was a bit different from the report I saw the objective coefficients were 6 and 8 making them the same as the profit per unit for each. And there was no production row in constraints. The particle board total was the same though for both in every category. The others were different except for the final value and constraint rh side

+ 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