nielsvanautenboer
New Member
- Joined
- Aug 27, 2013
- Messages
- 10
Hello members of this great forum.
First time post but longtime viewer
As you could get; I have a problem..
I have 300 lines of products, i'll take MILK as an example.
I need 13,3 liters of milk, and they sell them in 2 quantities; 5 liters and 1 liters.
As you could guess i should buy < 2 x 5 liters > and < 3 x 1 liters >.
As there sometimes isn't a perfect solution, i prefer buying as much of the bigger packs as possible. (They are cheaper)
I CAN calculate it using Solver or Goal Seek but it's never quit perfect. I opted using a RATIO line, where I state that if excel chooses a package, it doesn't need to be perfect. A ratio like 0,9 means that I am willing to throw away 0,1 liter.
Anyone an idea of a Formula?
First time post but longtime viewer
As you could get; I have a problem..
I have 300 lines of products, i'll take MILK as an example.
I need 13,3 liters of milk, and they sell them in 2 quantities; 5 liters and 1 liters.
As you could guess i should buy < 2 x 5 liters > and < 3 x 1 liters >.
As there sometimes isn't a perfect solution, i prefer buying as much of the bigger packs as possible. (They are cheaper)
I CAN calculate it using Solver or Goal Seek but it's never quit perfect. I opted using a RATIO line, where I state that if excel chooses a package, it doesn't need to be perfect. A ratio like 0,9 means that I am willing to throw away 0,1 liter.
Anyone an idea of a Formula?