Running functions in Excel is nice for making numbers match a desired reality. By his description, that's what A-1 has been doing.
Actually solving the problem would take talking to and listening to folks who are bonus-eligible and finding out what it would take to get them to stay. (Hint: it's gonna take more than money)