- Joined
- Jun 18, 2005
- Messages
- 2
- Reaction score
- 0
FOB Value <500 500-1000 1000-2000 >2000
A 5 10 15 20
B 6 11 16 21
C 7 12 17 22
D 8 13 18 23
FOB 775
CHARGES A 10
Looking at the above chart based on each customer A,B,C & D PRICES HAVE BEEN DEFINED ACCORDING TO THE FOB VALUE RANGE. NOW I WANT TO MAKE A FORMULA WHAT WOULD BE THE CHARGES ON CHANGING THE FOB VALUE AGAINST EACH CUSTOMER.
A 5 10 15 20
B 6 11 16 21
C 7 12 17 22
D 8 13 18 23
FOB 775
CHARGES A 10
Looking at the above chart based on each customer A,B,C & D PRICES HAVE BEEN DEFINED ACCORDING TO THE FOB VALUE RANGE. NOW I WANT TO MAKE A FORMULA WHAT WOULD BE THE CHARGES ON CHANGING THE FOB VALUE AGAINST EACH CUSTOMER.