You count the full cases first,multiply by case price, then add the
value associated with the remainder.
Sent from my iPhone
On Oct 17, 2008, at 8:17, "WebDude" <[EMAIL PROTECTED]> wrote:
Having a hard time wrapping my head around this one. Any help would
be appreciated.
Let's say we have bottles of perfume for sale. For shipping, we can
fit 12 bottles into a box. Each box is sent separately via a
courrier. The courrier charges x amount for each box plus weight. To
make a long story shorter, in this scenario, we have different
charges for quantities of bottles within a box. So, for a specific
zone, we charge like so...
Quantity Price
1 $14.50
2 $15.50
3 $16.50
4 $18.50
5 $18.75
6 $19.00
7 $20.00
8 $21.00
9 $22.00
10 $23.00
11 $25.00
12 $26.00
Now the problem is the thirteenth bottle. We need to charge 26.00 +
14.50.
14th bottle would be 26.00 + 15.50.
15th bottle would be 26.00 + 16.50, etc.
And to continue following this format...
24 bottles would be 26.00 + 26.00
25 bottles would be 26.00 + 26.00 + 14.50
26 bottles would be 26.00 + 26.00 + 15.50
27 bottles would be 26.00 + 26.00 + 16.50, etc.
There is a formula in there somehow, but I am having a devil of a
time trying to figure it out. Any help would be appreciated.
Thanks!
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
