Thanks for your response, I have to order 3 different products with
combination of 4-8 products with a max of 20 units?

"JE McGimpsey" wrote:

Since your largest weight is 5 and the package can contain a maximum of
8 pieces, any combination of eight pieces will weigh less than 50 lbs,
so it really doesn't matter how you ship, given the information you've
posted. You can maximize profit by shipping 8 pieces of the 1st product.

That assumes, of course, that shipping costs don't vary with weight,
that any 8 pieces will fit in your shipping package, and that your
customers are indifferent to which products they receive.


In article ,
jen the runner <jen the wrote:

I'm new and trying to maximize a shipment with certain parameters. I have 6
products differing in weights (5,4,3.5,3,2,1) each with different costs
(9,8,7,6,5,4) and sale price(17,13,11,9,7,5). I can only send a combination
of 3 products lines with 4-8 pieces of product and cannot weigh more than 50
pounds. I am trying to maximize profit.

I reviewed solver but am lost, can anyone forward me to some help?

Thanks in advance!