Results 1 to 2 of 2

Thread: Need formula for Point spread
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Need formula for Point spread

    Need a formula for the following:


    Sales goal 77% 300 points to spread amongst 4 employees based on results


    Emp #1 Actual - 83%
    Emp #2 Actual - 80%
    Emp #3 Actual - 78%
    Emp #4 Actual - 69%

  2. #2
    Board Regular pbornemeier's Avatar
    Join Date
    May 2005
    Location
    Virginia Beach, VA USA
    Posts
    3,659
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Need formula for Point spread

    Figuring out the split after the fact will only cause dissent among the 4 involved and any other employees. Since it was not decided prior to the results, I would give each 75 points.

    Determining point division ahead of time could be rationalized to any of a number of ways to divide the 300 points:
    Highest getting all of it
    Even spit between all
    Employees above 50% splitting 150 points equally and the balance distributed based on how far above half of goal (33/110,30/110,28/110,19/110)
    Below goal getting none and splitting the points among the others 3 based on how far over the goal they were (6/10, 3/10, 1/10)

    Each choice would put different pressures on the company/employee and the owner(s) would have to decide how they wanted their company to present to the world.
    Phil

    - Use CODE tags to keep your code formatted. See: BB Tags
    - How to attach Screenshots
    - Try searching for your answer first, see how
    - Test and validate results for all code on a copy of your worksheet!! How do you use the code you just found?
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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