prorate formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

what is the formula commonly use to prorate numbers? i have an assignment
where i have to prorate the bonus and spread it out among five employees.
 
Hi,

Not enough information to give a precise answer but generally you will need
to establish the percentage of the workload/output achieved by each employee
and allocate them that proportion of the bonus that matches their output.

For example employee A has done 10% of the work he is allocated

bonus/100 * 10

or as an excel formula =1000*10%

Mike
 
Well, how would you do it on paper? Presumably, you would take the
salaries of the five employees and add them up, and then for each
employee you would take their salary and divide it by the total to get
the fraction that they would be entitled to. Multiply this by the
bonus to get the figure to be awarded to them.

Knowing the method, can you translate that into Excel-speak?

Hope this helps.

Pete
 
Back
Top