Hello guys!
Is there any way to make this:
I have demands (200,132,100,82,340 for example), and a box with 80 slot, and i want that my result divisible by 80, result as an integer, so only exact number is a result, so its says im gonna need ~4boxes.
Obviously i have a lot of demands, and somehow i want to optimize.
Thanks in advance.
Why do you need ~4boxes?
Well i just wrote a random number, that wasnt my point.
I just a result which is divisible by 80
And in what ways is it allowed to get a correct result?
Can you give an example of that?
So my idea is this: If i have a boxes with 80 slots, but i have (for example) 421 demands. Thats 421/80 = 5,26, so my result should be 400 or 5, and whats left it shouldnt add to it, so 21 waiting for new demands, for a new calculation.
Whatever the details are, your problem sounds like a kind of knapsack problem. Whatever the details are, I would expect to use a template like this one put together by the programmers of Excel's Solver: https://www.solver.com/partial-loading-knapsack-problem (if you look around, you should be able to find a download with many example problems).
Somehow, you will need to calculate your objective function (whatever that looks like in relation to demand and boxes and exactly what you are trying to optimize). Then you will need to incorporate somewhere in your Solver model a way to force the result to be even multiples of 80. Then tell Solver to optimize the objective function by changing your decision variables subject to the constraint that respects this multiple of 80 constraint.
In order for us to provide more specific help, it would be helpful for you to put together a basic spreadsheet model of a knapsack problem showing your best guess at objective function, decision variables, and constraint calculations. Then we will be in a better position to see how you want to set up the spreadsheet/Solver model and can make suggestions from there.
Originally Posted by shg
Thank you very much, if i can't figure it out, i'll write here again.
Formula:
Please Login or Register to view this content.
I don't understand in which way it is allowed to get a result.
I don't know what you mean with a box and a slot.
Please give some concrete samples of input and expected results which an explanation?
Last edited by HansDouwe; 12-17-2022 at 02:54 PM.
A Guess
If demand in A2:A<n>, please try in B2 and copy down:and for the number of total boxes, please tryFormula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
So basicially i have found a way to do it, i uploaded it, my only problem is that somehow i need to proritize the dates, the most upcoming dates should be used first, then the later upcoming dates.
Any ideas how should i do that?
(24000kg is the max amount i can put in a truck that i want to use)
sh_test.xlsx
Upload: I divided the demands by 80*
Sorry.
I still don't get it because I still don't see a concrete example with manually added expected results and explanation.
I also asked for a concrete example in post #4 and in post #9, but which I still have not seen.
In that excel i uploaded was made by solver, the amounts column
I can't do anything with that.
You have to show the problem that needs to be solved and you have to indicate the rules that have to be followed.
This is often easiest with a concrete example.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks