A B C D E
1 Great Big Company Commssion Rate Percentage: 14%
2 Bonus Eligible Cutoff Value: $ 50,000.00
3 (enter system date/time) Bonus Amount: $ 1,200.00
4 (enter your name)
5
6 Sales Commission Bonus Total Pay
7 John Smith $ 55,000.00
8 Judy Jones $ 42,000.00
9 Sam Wilson $ 50,000.00
10 Paul Brown $ 60,000.00
11 Jill Williams $ 36,000.00
12
13 Totals
14
15 Assumptions:
16 Commission is Sales times the Commission Rate Percentage.
17 If Sales are the Bonus Eligible Cutoff Value or higher, the Bonus is the Bonus Amount,
18 otherwise the Bonus is zero.
19 Total Pay is Commission plus Bonus.
20 Total all columns.
D:\Docstoc\Working\pdf\ff75b9a8-b976-4a73-b498-8a1661a13134.xlsx