Another Formula for you..

[loopfish]

Hi, Sorry to be a bother but I have another formula that needs solving..

Total = (U * CPK * UW) + (U * UC)

Again I need to solve this for U so that we can calculate the largest number of units that can be ordered for a product given we have transaction limits in place

U = ???

Where,
U = Number of units ordered
CPK = Delivery Cost Per Kg
UW = Unit Weight
UC = Unit Cost


Thanks again,

Dave C

[HarryW]

Total = U * CPK * UW + U * UC

Factorise:

Total = U * (CPK * UW + UC)

Divide by (CPK * UW + UC):

U = Total / (CPK * UW + UC)