How to Drive Tariff from two VARIABLES?

[myem1983]

Hello Everyone,

I need your assistance here with the owing problem and I'm sure someoen will help me. :)

I've trucking rates which are based on fixed kilos - the range starts from 50 kilos to 5000 kilos.
Condition is whatever the volume of the cargo is we have to multiply it with 200 and whatever the answer will be then we have to look down into the weight slab where it falls. For e.g.

We have 1000 kilos and volume is 1 cubic-meter.
Now we have to multiply 1 cubic-meter with 200 and answer will be 200 so we can see 1000 is higher so we have to pick 1000.

I'm wondering is there is any co-relation we can find and make a flat rate? For e.g.

rather we multiply volume of the cargo with 200 why can't we have one SIMPLE rate and whatever weight or volume we get we multiple it with a flat rate?

I'm not sure I'm being clear and detailed explaining here... :( sorry for the inconvenience. rest of the details are as below:
Weight
50 , 100 , 150 , 200 , 250 , 300 , 350 , 400 , 450 , 500 , 600 , 700 , 800 , 900 , 1000 , 1100 , 1200 , 1300 , 1400 , 1500 , 1600 , 1700 , 1800 , 1900 , 2000 , 2100 , 2200 , 2300 , 2400 , 2500 , 3000 , 4000 , 5000 ,

Rate
45.98 , 55.11 , 66.11 , 73.59 , 85.69 , 96.69 , 107.69 , 117.81 , 129.03 , 136.51 , 148.17 , 165.33 , 179.41 , 196.383 , 203.643 , 213.444 , 223.366 ,
234.014 , 242.605 , 250.107 , 255.915 , 264.627 , 273.218 , 281.688 , 290.158 , 304.799 , 312.906 , 321.013 , 329.12 , 336.864 , 346.907 , 349.569 , 366.63

Appreciate if you could help me to drive a tariff which is one figure - and by multiplying it with VOLUME or WEIGHT I get an answer.

Thanking you in advance! :)

Regards,
MYEM

 

[jvicens]

Dear MYEM,

Thank you for reaching out for assistance with your trucking rates. I am always interested in finding solutions and correlations to problems. After reviewing your forum post and the details provided, I believe I have a possible solution for your flat rate conundrum.

Firstly, I would suggest looking at the average weight and volume of your cargo. By finding the average, we can use it as a base for our flat rate. For example, if the average weight is 1000 kilos and the average volume is 1 cubic meter, we can start with a flat rate of 200 multiplied by 1000, which would give us a rate of 200,000. This may seem like a high rate, but we can then adjust it based on the weight and volume ranges provided.

For weights below 1000 kilos, we can decrease the rate slightly, and for weights above 1000 kilos, we can increase the rate accordingly. This way, we can still use a flat rate for all weights and volumes, but it will be adjusted based on the actual weight and volume of the cargo.

Additionally, we can also consider implementing a tiered flat rate system. For example, we can have a base rate for weights up to 1000 kilos, a slightly higher rate for weights between 1000-2000 kilos, and a higher rate for weights above 2000 kilos. This way, we can account for the varying weight ranges in a more organized manner.

I hope this helps in finding a solution for your trucking rates. Please let me know if you have any further questions or if I can provide any additional assistance.