I am trying to create a fairly simple input screen whereby someone could easily calculate an estimated quarterly bonus payout based on the quarterly net profit of the company.

Basic criteria that will be entered:

Total salary pool - fixed number of $X,XXX,XXX
Annual Gross Wages = $XX,XXX
Employee Type = Salary Supervisor, Salary Non-Supervisor, Hourly

Q1 NET PROFIT = $XXX,XXX
Q2 NET PROFIT = $XXX,XXX
Q3 NET PROFIT = $XXX,XXX
Q4 NET PROFIT = $XXX,XXX

RESULTS FROM THE ABOVE ENTRY and FROM THE TABLES OF DATA ATTACHED, we would like to display the estimated bonus payout for each quarter.

Using this data in maybe VLOOKUP or INDEX/MATCH, the level of bonus payout would be determined. The Bonus Payout levels would be calculated from this information:

Capture.JPG

Capture.JPG

Thank you for your assistance.