Results 1 to 1 of 1

Thread: Efficiency Delivery Rating

  1. #1
    May 2011

    Efficiency Delivery Rating

    As Topic line says I do not pretend to be in on you guys mathematical level but I have a problem at my business that you may be able to help with.
    We have a company that requires Deliveries that contains the following variables
    C-Total Number of Boxed Delivered
    D-Total Number of Deliveries
    E-Total Kilometres Travelled
    F-Total Time Taken

    What I am trying to create is an “efficiency Delivery Rating” (my title for it) to establish how quickly or slowly the delivery run is taking using the above variables. It followes that if for example a Delivery Run is the same distance with the same number of deliveries but with more boxes per delivery it is going to take more time etc. I would like to then use that numeric value to apply to another Driver again bringing all those variables into account to give me a Time that the Delivery Run should have taken if that same rating was applied. I would then just input values into an XL spreadsheet to give me the Times the Delivery Runs are taking/should be taking. Spreadsheet Attached BELOW.

    I am not a Mathematician so a simple formula like (F multiplied by D divided by C) would be great if that is possible with this type of calculation but if not ok I will give it my best.

    Thanks in advance I hope you can help me with my dilemma. I could not believe my luck when I saw that a Forum like this existed. I have been racking my brain trying to come up with a solution but just succeeded in giving myself a headache

    Thanks Stephen
    Attached Files Attached Files
    Last edited by Animal; May 14th 2011 at 12:14 PM. Reason: incorrect
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Delivery Price of a Forward Contract
    Posted in the Business Math Forum
    Replies: 4
    Last Post: Mar 23rd 2011, 11:52 PM
  2. Decibels Rating
    Posted in the Pre-Calculus Forum
    Replies: 2
    Last Post: Mar 3rd 2010, 04:49 PM
  3. Help with finding an Average Rating Winner
    Posted in the Math Software Forum
    Replies: 1
    Last Post: Oct 7th 2008, 01:58 PM
  4. Delivery
    Posted in the Algebra Forum
    Replies: 2
    Last Post: Jul 20th 2005, 02:15 AM

Search Tags

/mathhelpforum @mathhelpforum