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

"prorate formula" wrote:

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.