rdincer
12-01-2011, 11:09 AM
Basically for work I need to come up with a software or an excel program to make a calculation.
Let's say I have cubicle stones that have the same volume but different weight. I'm trying to put these stones into bags which differ in the number of stones they can fit, and the max weight then can carry.
To give you an example:
I have 50 cubic stones, all different weight but same volume.
I have unlimited number of different types of bags, such as:
-First type of bag can fit 3 stones in the total weight of 50kg for $10 per bag
-Second type of bag can fit 10 stones in the total weight of 100kg for $20 per bag
-Third type of bag can fit 30 stones in the total weight of 250kg for $50 per bag
I want to have an application or an excel spreadsheet which would let me put in the parameters of the bags and the stones, and then calculate the least expensive way of buying bags.
If somebody could show me a way to do this, I'll be glad.
Thanks!
Let's say I have cubicle stones that have the same volume but different weight. I'm trying to put these stones into bags which differ in the number of stones they can fit, and the max weight then can carry.
To give you an example:
I have 50 cubic stones, all different weight but same volume.
I have unlimited number of different types of bags, such as:
-First type of bag can fit 3 stones in the total weight of 50kg for $10 per bag
-Second type of bag can fit 10 stones in the total weight of 100kg for $20 per bag
-Third type of bag can fit 30 stones in the total weight of 250kg for $50 per bag
I want to have an application or an excel spreadsheet which would let me put in the parameters of the bags and the stones, and then calculate the least expensive way of buying bags.
If somebody could show me a way to do this, I'll be glad.
Thanks!