Posted to microsoft.public.excel.worksheet.functions
|
|
Basic question...sorry
Yes it is and I have a worksheet to show I have been attempting this and not
looking for a free ride!
"Peo Sjoblom" wrote:
Is this school work?
--
Regards,
Peo Sjoblom
"jen the runner" wrote in message
...
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!
|