Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2016
    Posts
    1

    Unanswered: Filling a budget with to achieve max overall benefit

    Hi,
    I keep thinking knapsack with this but I can't find anything which really fits like a glove.

    I have a list of assets. They have a treatment selected for each. The Benefit of performing the treatment is also available, along with the size of the asset and cost to perform the treatment.

    I have a set budget which I want to fill up with the best combination of assets to achieve the maximum increase in benefit across the whole network.

    Can someone please help me with a sql server script? I'm starting to go a little insane.

  2. #2
    Join Date
    Oct 2007
    Posts
    154
    Provided Answers: 9
    Sounds like a good homework assignment. How about supplying your table layouts and we will give you some tips on how best to achieve.

Tags for this Thread

Posting Permissions

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