+ Reply to Thread
Results 1 to 3 of 3

formula which picks the best sales person using hours worked, calls answered & sales

  1. #1
    Forum Contributor
    Join Date
    01-06-2015
    Location
    london,uk
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2307) 64-bit....Windows 10 Enterprise
    Posts
    118

    formula which picks the best sales person using hours worked, calls answered & sales

    Hi Guys

    I am trying to create a ratio or formula which calculates the most effective sales person based on hours worked, calls answered, successful sales for those calls, revenue and margin.The formula would have to take the following into consideration:

    - sales transactions can vary with regards to their value. Therefore a sales person can be lucky and convert a high value sale. Therefore revenue and margin can be high despite having fewer calls and a successful call rate than another person.
    - Sales person commit different working hours. So for example one could work 10 while another 4 hours per day.

    Can you help create an ideal formula to find the most effective sales person?

    Kind regards
    Chris
    Last edited by chris1089; 09-11-2015 at 04:19 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: sales related query

    title updated
    Last edited by protonLeah; 09-11-2015 at 03:18 PM.
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    01-06-2015
    Location
    london,uk
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2307) 64-bit....Windows 10 Enterprise
    Posts
    118

    Re: formula which picks the best sales person using hours worked, calls answered & sales

    I have corrected the issue please remove the ban

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Another "World Cup" related query
    By yhtak in forum Excel General
    Replies: 5
    Last Post: 05-10-2014, 11:57 AM
  2. Replies: 1
    Last Post: 11-19-2013, 12:52 PM
  3. Replies: 6
    Last Post: 10-19-2013, 04:53 PM
  4. Excel query related to Bold function in formatting
    By vjharry in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-18-2013, 08:22 AM
  5. Can query results be moved to one row for related fields?
    By jgomez in forum Access Tables & Databases
    Replies: 1
    Last Post: 11-01-2012, 10:28 AM
  6. return related cell values from "search Query"
    By simpo067 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-13-2010, 08:56 AM
  7. Query related to SUM IF function
    By prsahu in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-23-2008, 02:39 AM
  8. Replies: 0
    Last Post: 11-29-2005, 09:40 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