9 Replies - 924 Views - Last Post: 19 January 2018 - 11:23 AM

#1 moralle   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 18-January 18

kit Combination Calculator

Posted 18 January 2018 - 01:48 PM

I am trying to come up with a solution to the following to assist our sales guys with product selections;

We have various kits available, each kit has 4 numeric variables.
Different kits have different component quantities that cannot be changed,

ie. kit 1 might have 6A, 6B, 10C, 10D components, whilst kit 2 might have 2A, 2B, 5C, 5D there are many kits but the values of each of the 4 components cannot be changed, therefore the optimum selection of kits needs to be chosen.

If a customer requires 12A, 8B, 10C, 8D, it is clear from this example that we would need 1 x kit 1 and 1 x kit 2, it is acceptable to have too many of any components but not less than, we want to find the optimal combinations to find the most competitive solution.

I have been looking at knapsack code examples but these don't seem to fit my problem as they are looking at a single requirement result, i.e max size not 4 results in my case where each of the 4 requirements must be met.

I would appreciate if any one can give me a nudge in the right direction. Perhaps a code example to get me going.

Many thanks.

Is This A Good Question/Topic? 0
  • +

Replies To: kit Combination Calculator

#2 modi123_1   User is offline

  • Suitor #2
  • member icon



Reputation: 15106
  • View blog
  • Posts: 60,409
  • Joined: 12-June 08

Re: kit Combination Calculator

Posted 18 January 2018 - 01:52 PM

Wouldn't it be a fairly straight forward search? Which kit has X, which has Y, which has W, then pull some snazzy SQL distinct to make that list the kits needed.
Was This Post Helpful? 0
  • +
  • -

#3 moralle   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 18-January 18

Re: kit Combination Calculator

Posted 18 January 2018 - 01:54 PM

I am trying to come up with a solution to the following to assist our sales guys with product selections;

We have various kits available, each kit has 4 numeric variables.
Different kits have different component quantities that cannot be changed,

ie. kit 1 might have 6A, 6B, 10C, 10D components, whilst kit 2 might have 2A, 2B, 5C, 5D there are many kits but the values of each of the 4 components cannot be changed, therefore the optimum selection of kits needs to be chosen.

If a customer requires 8A, 6B, 11C, 8D, it is clear from this example that we would need 1 x kit 1 and 1 x kit 2, it is acceptable to have too many of any components but not less than, we want to find the optimal combinations to find the most competitive solution.

I have been looking at knapsack code examples but these don't seem to fit my problem as they are looking at a single requirement result, i.e max size not 4 results in my case where each of the 4 requirements must be met.

I would appreciate if any one can give me a nudge in the right direction. Perhaps a code example to get me going.

Many thanks.
Was This Post Helpful? 0
  • +
  • -

#4 moralle   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 18-January 18

Re: kit Combination Calculator

Posted 18 January 2018 - 02:02 PM

Thanks for your reply, but I don't think so although I have limited SQL knowledge, the requirement is likely to always require multiple kits and its about finding the best combinations;

Even if I just looked at the first component if the requirement was 50 and I have kits which comprise 10,5 or 2 then its clear I would need 5 x 10 kit or 20 x 5 kit or 25 x 2 kit, clearly the best selection would be 5 x 10, but the result may be different for the other 3 components which will then alter the first selection. and so the 20 x 5 might work better for the other components within the kit.
Was This Post Helpful? 0
  • +
  • -

#5 Skydiver   User is online

  • Code herder
  • member icon

Reputation: 6963
  • View blog
  • Posts: 23,674
  • Joined: 05-May 12

Re: kit Combination Calculator

Posted 18 January 2018 - 02:55 PM

Sounds more like a bin packing problem. Anyway, knapsack is a special case of bin packing.

There is nothing that says that the weights of the items in the knapsack are restricted to a single dimension. You could just as easily have a one dimensional weight or value, or have a 4 dimensional vector.
Was This Post Helpful? 0
  • +
  • -

#6 Skydiver   User is online

  • Code herder
  • member icon

Reputation: 6963
  • View blog
  • Posts: 23,674
  • Joined: 05-May 12

Re: kit Combination Calculator

Posted 18 January 2018 - 03:50 PM

Moving over into Computer Science this looks to be language agnostic...
Was This Post Helpful? 0
  • +
  • -

#7 macosxnerd101   User is offline

  • Games, Graphs, and Auctions
  • member icon




Reputation: 12616
  • View blog
  • Posts: 45,770
  • Joined: 27-December 08

Re: kit Combination Calculator

Posted 18 January 2018 - 11:40 PM

Skydiver is correct- this is a generalization of the bin-packing or knapsack problems. Your problem is certainly NP-Hard. However, you can formulate this problem as an Integer Programming problem. Granted, IP is NP-Hard, there are sophisticated IP solvers that are pretty good in practice. They aren't always optimal, but it's good enough. Excel has one such solver.

First, denote [n] = { 1, 2, ..., n }. I will use this notation as shorthand. For each i \in [n], denote xi as the number of kits of type i you are giving the customer. Now I imagine you want to minimize the number of kits you give to a customer. So our objective function is:
min \sum_{i=1}^{n} x_{i}



Now to discuss the constraints. For i \in [n] and j \in { A, B, C, D }, denote yij as the number of part j's in kit i. (So y1A denotes the number of part A in kit 1). Denote qj as the quantity of part j that the customer wants. This gives rise to the constraints:

\sum_{i=1}^{n} y_{i_{j}} * x_{i} >= q_{j} (for all j)



Note that x_{i} * y_{i_{j}} is the number of part j that the customer gets through kit i. We add this quantity up over all such kits.

We also have the constraints that each x_{i} >= 0 and each x_{i} is an integer. You will need to spell these out for an IP solver.
Was This Post Helpful? 2
  • +
  • -

#8 moralle   User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 18-January 18

Re: kit Combination Calculator

Posted 19 January 2018 - 02:10 AM

Thankyou all for your guidance, i am struggling to find some code examples, all the bin packing and knapsack examples seem to result in less than, we need to meet or exceed the customers requirement for each component.

I appreciate the excel function but i want to write something in c# to add into our sales tool.
Was This Post Helpful? 0
  • +
  • -

#9 macosxnerd101   User is offline

  • Games, Graphs, and Auctions
  • member icon




Reputation: 12616
  • View blog
  • Posts: 45,770
  • Joined: 27-December 08

Re: kit Combination Calculator

Posted 19 January 2018 - 10:50 AM

I would suggest searching for an LP/IP silver or library that you can use with C#. That is probably the easiest way.

Again, your problem is NP-Hard. You arenít going to find easy, efficient, and plug-and-chug solutions. If you choose not to go the IP solver route, you will likely have to design an algorithm yourself. Dynamic programming will probably be the most effective technique to minimize the number of kits you have to provide, but a greedy approach will likely take the least amount of time for your computer to execute.
Was This Post Helpful? 1
  • +
  • -

#10 Skydiver   User is online

  • Code herder
  • member icon

Reputation: 6963
  • View blog
  • Posts: 23,674
  • Joined: 05-May 12

Re: kit Combination Calculator

Posted 19 January 2018 - 11:23 AM

... And if you are expecting to have your sales people run the kit solver on their phones, the greedy approach will likely work best for a quickie recommendation.

If you host the solver on your company website, then you can likely go with solutions that require more computing power. Perhaps, I'm geeky, but if I were your customer, I'd like to be able to plug my own values into your company web site and see what values come out. On the other hand, I know that my wife would rather just be presented with 2 or 3 options and she doesn't particularly care how the numbers were produced.
Was This Post Helpful? 1
  • +
  • -

Page 1 of 1