Need formula for Point spread

Sylviav

New Member
Joined
Sep 18, 2019
Messages
1
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%
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
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.
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top