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