# Finding the least expensive combination

I basically have an optimization problem in hand that needs some programming, hopefully through excel but if can't be done with Excel, please provide the language you'll be using.

Let's say I have 10 stones:

Stone 1: 10kg

Stone 2: 5kg

Stone 3: 8kg

Stone 4: 11kg

Stone 5: 14kg

Stone 6: 23 kg

Stone 7: 1kg

Stone 8: 7kg

Stone 9: 9kg

Stone 10: 12kg

And I have 3 bags to choose:

Bag 1: Max # of stones in the bag is 6, weight limit is 20 and the price for the bag is \$50

Bag 2: Max # of stones in the bag is 3, weight limit is 15 and the price for the bag is \$30

Bag 3: Max # of stones in the bag is 10, weight limit is 30 and the price is \$100

etc..

so I have fixed number of bags (close to 50), and close to 200 different weighted stones. I'm trying to find a way to optimize the money I pay per bag to carry these stones. So basically I'm trying to pay the least amount to carry these stones.

The numbers are on this letter is fictional so I'd like to be able to enter my own data as far as the bags, stones and their features as far as price & weight & max nr of stones.

I hope this is clear.

I will need 2 things:

1- Full excel spreadsheet (or a basic program) that I can edit (add more data, remove data, play with variables, etc.)

2- The algorithm.

Thanks!!

Tentang Majikan:
( 1 ulasan ) NEW YORK, United States

ID Projek: #1551416

procoder898

Hi, I am expert at Data Structure and Algorithm, can surely satisfy you. Please check your inbox,

\$99 USD dalam 0 hari
(53 Ulasan)
5.7

## 15 pekerja bebas membida secara purata \$127 untuk pekerjaan ini

dobreiiita

Anyone can say anything, Please check feedbacks and decide, thanks

\$80 USD dalam 2 hari
(196 Ulasan)
6.6
usamacpp

We are a very experienced team who can tackle this task. Please check PMB for more details.

\$200 USD dalam 5 hari
(28 Ulasan)
6.0
diepbp

\$150 USD dalam 2 hari
(85 Ulasan)
5.8
kevinxiaozi

Dear sir, I am strong in programming especially in algorithm implementation. Based on your project problem, it is an extended Knapsack problem. I am strong in optimization this problem because I have finished simila Lagi

\$100 USD dalam sehari
(25 Ulasan)
5.5
ethicalboy

\$150 USD dalam 5 hari
(41 Ulasan)
4.8
rvector

I am good at algorithms please PM me

\$70 USD dalam 2 hari
(12 Ulasan)
4.6

\$250 USD dalam 3 hari
(18 Ulasan)
4.3
nguyenquoc

i will give you demo for this project.

\$80 USD dalam sehari
(6 Ulasan)
3.7
rohitpithisaria

Hi... I would like to apply for the job.

\$80 USD dalam sehari
(10 Ulasan)
3.6

Dear Sir, I have done similar project before. See PMB for more details.

\$50 USD dalam 2 hari
(0 Ulasan)
0.0
Z02oTRZ1d

Pls check PMB.

\$250 USD dalam sehari
(0 Ulasan)
0.0
sholyboy

I can write the algorithm, it's relatively easy

\$100 USD dalam 3 hari
(0 Ulasan)
0.0
samavacorp

Hi I run a market research firm STPresearch (www.stpresearch.in) focusing on SMB's i am an expert in excel and have designed many sales related excel based solutions. From my experience this is a simple task we Lagi

\$30 USD dalam 3 hari
(0 Ulasan)
0.0
jessicatechno