Results 1 to 14 of 14

Calculating Courier Costs

Threaded View

  1. #1
    Registered User
    Join Date
    02-24-2022
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    6

    Calculating Courier Costs

    Please could someone help provide a formula for me to calculate courier costs based on a consignments combined total weight?

    Courier charges are tiered in 3 levels and are calculated on the combined weight of all boxes.
    A flat fee for the first 20Kg of £6.25,
    and then a cost of £0.28 per kg up to 100Kg
    then a cost of £0.35 per Kg for anything above 100Kg

    I have attached a basic spreadsheet as an example.


    Thanks

    Dan
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate Courier Costs
    By jimbokeep in forum Excel General
    Replies: 12
    Last Post: 02-24-2022, 06:44 AM
  2. [SOLVED] calculating inflated component costs
    By Seattlites in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2020, 11:41 AM
  3. Calculating shipping costs
    By LPJR in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 10-11-2016, 11:06 AM
  4. [SOLVED] calculating accumulated rental costs
    By jimcuk in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-25-2016, 03:14 PM
  5. Calculating labour costs
    By ceght in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-21-2015, 09:01 AM
  6. Replies: 3
    Last Post: 07-28-2014, 08:57 PM
  7. [SOLVED] Simple Calculating Costs
    By Tanker350 in forum Excel General
    Replies: 1
    Last Post: 10-18-2005, 11:05 PM

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