Closed Thread
Results 1 to 4 of 4

Calculation of trucking cost

  1. #1
    Registered User
    Join Date
    12-09-2017
    Location
    VIet nam
    MS-Off Ver
    2016
    Posts
    11

    Calculation of trucking cost

    Dear all,

    Good evening,

    I am strugling in calculation of trucking cost as below:
    I have many shipments delivering to various destinations by trucks as table A. Cost for each truck to every destination as table B.
    The formulas for trucking cost is that : from the second truck of each destinations, the cost will be discounted (manual formulas was stated for shipment1 for example) . Could you please help me to find a solution for this.
    Thank so much

    image463c50931e0e57ac.png
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Calculation of trucking cost

    This appears to be a duplicate post to the one you started at
    https://www.excelforum.com/excel-gen...ml#post4875825

    to which you received a response.

    Unless you can convince me it's not a duplicate, or not essentialy the same it will be closed.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    12-09-2017
    Location
    VIet nam
    MS-Off Ver
    2016
    Posts
    11

    Re: Calculation of trucking cost

    Sorry for making confused for the similar subject thread, It's not duplicated, your mentioned thread has been solved thanks to your help, and this thread is realated to another issue- amount of discount when calculate the trucking cost. kindly help to help me solve it.
    Thanks in advance and sorry again.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Calculation of trucking cost

    Hi,

    This is essentially the same data set with an extended requirement, the solution to which will build on the original solution. In this case therefore it would be better if you added the additional requirement to the original thread since those who have already helped you are likely to be able to suggest the solution.

    I'll therefore close this and mark the original as Unsolved for the moment.

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculating cost of trucking
    By minhtien1900 in forum Excel General
    Replies: 5
    Last Post: 04-07-2018, 12:50 AM
  2. Food cost calculation
    By Rob8222 in forum Excel General
    Replies: 8
    Last Post: 06-06-2016, 07:30 PM
  3. Need Help With Cost Calculation
    By mohdm in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-24-2015, 11:29 AM
  4. Replies: 1
    Last Post: 04-24-2015, 09:46 AM
  5. calculation of cost on excel
    By itzmemike in forum Excel General
    Replies: 3
    Last Post: 06-15-2012, 12:46 AM
  6. Cost Optimisation Calculation
    By yokong in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-02-2012, 08:12 AM
  7. Cost Driver calculation - Looking for formula/macro to calculate manpower cost alloca
    By Swastik Banerje in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-30-2009, 11:18 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1