evotsi
asked on
Formula to calculate profit sharing
I need a formula to calculate a persons share of an arbitrary number, say 1000 based on two variables. The first variable will be the number of hours a person worked. The second variable will be a number between 1 and 10. This will be a number used to determine a persons weight of the profit share. For example, someone with a 4 would end up with the same share as someone else with a 4, providing they both had the same amount of hours. A person with a 4 would have twice the size share as someone with a 2.
This formula would need to work for any number of people, from 1 to 100.
This is important! The total shares for everyone would need to add up to the total amount, 1000 in this case.
This formula would need to work for any number of people, from 1 to 100.
This is important! The total shares for everyone would need to add up to the total amount, 1000 in this case.
N = number persons
Ri = random number of ith person (1..10)
Hi = hours worked of ith person
Si = shares of ith person
Wi = Ri * Hi
Si = 1000 * Wi / [ sum(Wi) for i = 1..N ]
- Must be real, not integer calculations
Ri = random number of ith person (1..10)
Hi = hours worked of ith person
Si = shares of ith person
Wi = Ri * Hi
Si = 1000 * Wi / [ sum(Wi) for i = 1..N ]
- Must be real, not integer calculations
ASKER
This does not seem to be working. For example we have three people:
Person A worked 80 hours and has a rating of 5
Person B worked 80 hours and has a rating of 5
Person C worked 80 hours and has a rating of 2
The profit available to share is $1000.00
Can you please perform the calculation with the previous figures and show the results? Thanks.
Person A worked 80 hours and has a rating of 5
Person B worked 80 hours and has a rating of 5
Person C worked 80 hours and has a rating of 2
The profit available to share is $1000.00
Can you please perform the calculation with the previous figures and show the results? Thanks.
A = 5/12 * 1000
B = 5/12 * 1000
C = 2/12 * 1000
Can you please show your steps and indicate what is not working?
B = 5/12 * 1000
C = 2/12 * 1000
Can you please show your steps and indicate what is not working?
ASKER
I put 80 hours for everyone to make it simpler. Can you please show what the calculation would be if A had 60 hours, B had 20 hours, and C had 80 hours?
Can you please show your steps, and if something is wrong, please indicate what is not working? We can then try to work with you on the problem you are having.
Is there anything about the http:#26443305 that you would like to discuss.
Please realize that the denominator: [ sum(Wi) for i = 1..N ] is the same for A, B, and C.
In http:#26457329, you say that the previous post is not working. Could you please explain what problem you had, and maybe I can figure out what is going wrong, either with the formula or a misunderstanding.
Please realize that the denominator: [ sum(Wi) for i = 1..N ] is the same for A, B, and C.
In http:#26457329, you say that the previous post is not working. Could you please explain what problem you had, and maybe I can figure out what is going wrong, either with the formula or a misunderstanding.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
(Total Profit)(Hours worked * rating)/ (Total of each persons hours worked*rating)