each 5000 lb increment is 50(100 lb), which costs 50($2.81) = $140.50 to ship
a 15000 lb shipment consists of three 5000 lb increments ... 3($140.50) = $421.50 to ship
Let's imagine I have different tonnages of products I am shipping. 15000 lbs to 40000 lbs in 5000 lbs increments. On average to ship it cost $2.81 for a 100 lbs. How do I calculate how much each bracket is costing me? Is there a simple way to resolve this? I realize that there could be different combination possible but this is a real life problem for me right now. Thanks for any help.
Ok I didn't phrase this correctly. The average cost 2.81 but shipping 15000 or 40000 cost the same so the cost of shipping 100 lbs is less expensive when shipping 40000 than 15000 lbs. In other words if I ship 15000 at $X dollars for 100lbs and 40000 at $Y dollars on average I paid $2.81. So let me know if I have this right. If I calculate the total cost 40+15 @ 2.81. Then calculate the total tonnage. Then find how many times I have the 15k lbs and 40k lbs in my total tonnage. Then take those 2#s I just found and add them. Then I divide my total shipping cost by how many times I found 15k and 40k in my total tonnage and multiply by how many times I found 15k. So here is how it looks (in 100 lbs)
150+400 = 550
Cost is 2.81*55=1545.5
For 150lbs = (1545.5/5.04)*3.66=1124 or 7.49 for 100lbs. Same thing with 400 lbs result is 1.05 lbs. Average is $2.81 per cwt. Is this right?