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 cant 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	Rate
50	45.98​
100	55.11​
150	66.11​
200	73.59​
250	85.69​
300	96.69​
350	107.69​
400	117.81​
450	129.03​
500	136.51​
600	148.17​
700	165.33​
800	179.41​
900	196.383​
1000	203.643​
1100	213.444​
1200	223.366​
1300	234.014​
1400	242.605​
1500	250.107​
1600	255.915​
1700	264.627​
1800	273.218​
1900	281.688​
2000	290.158​
2100	304.799​
2200	312.906​
2300	321.013​
2400	329.12​
2500	336.864​
3000	346.907​
4000	349.569​
5000	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

 

[HallsofIvy]

Frankly this doesn't make much sense at all. You say "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."
What is a "weight slab"?

You give the example "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."

What would we have done if the 200 times the volume had been higher than the weight? Use that instead? If so you should have said that.

Your table lists only "weight" and says nothing about volume. If 200 times the volume were greater than the weight would we interpret that as a higher "weight"? Again, you need to say that.

If all my assumptions are correct, in order to get a single equation you will need to use the "Heaviside step function", H(200v- w), which will be 1 if 200v is greater than w, 0 otherwise.

 

[Deleted member 4993]

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 cant 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	Rate
50	45.98​
100	55.11​
150	66.11​
200	73.59​
250	85.69​
300	96.69​
350	107.69​
400	117.81​
450	129.03​
500	136.51​
600	148.17​
700	165.33​
800	179.41​
900	196.383​
1000	203.643​
1100	213.444​
1200	223.366​
1300	234.014​
1400	242.605​
1500	250.107​
1600	255.915​
1700	264.627​
1800	273.218​
1900	281.688​
2000	290.158​
2100	304.799​
2200	312.906​
2300	321.013​
2400	329.12​
2500	336.864​
3000	346.907​
4000	349.569​
5000	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

If you transport bunch of steel-bars, you want to charge by weight.

If you transport bunch of foam-boards, you want to charge by volume.