T
TYE
Hi need need a foulmles for the following,
Total Sales Total Hrs Man Hours Prod
Bonus SPH
Paul Smith 4 7.25 8
91% £16 0.55
Total Sales Total Hrs Man Hours Prod
Bonus SPH
Paul Smith 4 7 8
88% £8 0.55
THIS IS A TABLE WHERE IT GET IN INFORT
Ratio Productivity Bonus
0.35 - 0.4 90% 2.00
0.41 - 0.5 90% 3.00
..51 – 0.6 90% 4.00
..61 – plus 90% 5.00
BELOW 90%
RATIO Bonus
0.35 - 0.4 1.00
0.41 - 0.5 1.50
..51 – 0.6 2.00
..61 – plus 2.50
CAN YOU HELP ON THIS I NEED A FORMULES TO WORK OUT THE BONUS
Total Sales Total Hrs Man Hours Prod
Bonus SPH
Paul Smith 4 7.25 8
91% £16 0.55
Total Sales Total Hrs Man Hours Prod
Bonus SPH
Paul Smith 4 7 8
88% £8 0.55
THIS IS A TABLE WHERE IT GET IN INFORT
Ratio Productivity Bonus
0.35 - 0.4 90% 2.00
0.41 - 0.5 90% 3.00
..51 – 0.6 90% 4.00
..61 – plus 90% 5.00
BELOW 90%
RATIO Bonus
0.35 - 0.4 1.00
0.41 - 0.5 1.50
..51 – 0.6 2.00
..61 – plus 2.50
CAN YOU HELP ON THIS I NEED A FORMULES TO WORK OUT THE BONUS