+ Reply to Thread
Results 1 to 3 of 3

help need a formula to figure how much more an employee can sell with more productivity

  1. #1
    Registered User
    Join Date
    06-08-2013
    Location
    Brooklyn
    MS-Off Ver
    Excel 2007
    Posts
    4

    Lightbulb help need a formula to figure how much more an employee can sell with more productivity

    If sarah sells $10 per hr and makes $400 how much could she be making if she were to increase her productivity to selling $25 per hr. I need to make a spreadsheet listing each emplys productivity.Then showing how much they could be making if they sold more per hr.
    I have no clue how to formulate this.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: help need a formula to figure how much more an employee can sell with more productivi

    Maybe something like this:

    Employee Name Average Total Sold What If Average Could have Sold
    Sarah 10 400 25 =C2/B2*D2
    Last edited by xladept; 06-08-2013 at 03:12 PM.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,101

    Re: help need a formula to figure how much more an employee can sell with more productivi

    if you have a cell with with the amount per hour $10 say A2
    and the total $400 say B2
    then you can work out the hours

    In a cell you have the new figure required ie $25 C2

    then in D2
    so the formula would be 25* (400/10) - 400 would give the result
    = (C2*(B2/A2)) -B2
    should work

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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