The Prior Relationship(s) Sample Bonus Table appears (Figures 8 and. 9). Some suggestions for filling out the Sample Bonus Table.I'm trying to create a spreadsheet that can calculate a bonus based on three different tiers. Each tier has two objectives that must be met to reach that bonus. I'm here to help you streamline and save time when it comes to using excel spreadsheets in your business in your profession in hr. What is a Bonus Plan? A bonus plan is an agreement between the employer and employee to pay out a predetermined amount of money based on performance. A Valid Credential form with the Credentials Unit of the Santa Clara County Office of Education. Contact your local court to determine which temporary spousal support formula has been adopted for your county. In this video, I'll show you how to use Excel formulas to summarize employee bonus payouts.