Results 1 to 4 of 4

Thread: Freight cost calculation based on weight and distance

  1. #1
    Neophyte chandrarun's Avatar
    Join Date
    Oct 2019
    Posts
    2
    Articles
    0
    Excel Version
    2016

    Red face Freight cost calculation based on weight and distance



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi All,

    Hope you are doing well!...I am trying to find the freight cost that will be incurred based on the weight that is to be carried and the miles to travel to reach the destination for ground service and also the fuel charge incurred ... Can you please help me here....I have provided the required input and output in the sheet attached....

    In my attached sheet following are the tabs:

    Carrying cost: This tab has the Miles ranges and the weight in pounds...the cost is to be multiplied based on the weight to be carried multiplied by the number got out of the table for ex: if 100 pounds are to be carried for 75miles then the cost is 1.56*100 =156$ without fuel surcharge..

    Fuel surcharge: This table represent the percentage of the cost that is to be added as fuel surcharge: ,For example if 300 pounds are to be carried for 500 miles then the cost would be 2.09*300=627 ...Adding the fuel surcharge it would be an addition of 12% cost based on the fuel surcharge table : ie: 627+0.12*627=702.24

    Input& Required Output:The order id (oid), weight in pounds to be carried and the distance in miles are the inputs ..The output is the cost without fuel surcharge and the cost with fuel surcharge....

    Thanks,
    Arun
    Attached Files Attached Files

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,616
    Articles
    0
    Excel Version
    365
    See attached.
    Attached Files Attached Files

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,616
    Articles
    0
    Excel Version
    365
    cross posted without links:
    https://www.excelforum.com/excel-for...-distance.html
    https://chandoo.org/forum/threads/fr...istance.42776/
    chandrarun/chandraarun/chandramouliarun, for your information, you should always provide links to your cross posts.
    This is a requirement, not just a request.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

  4. #4
    Neophyte chandrarun's Avatar
    Join Date
    Oct 2019
    Posts
    2
    Articles
    0
    Excel Version
    2016
    !p45cal: My apologies!..I will make sure this does not happen again!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •