apply_5-1_annual_commission_totals.xlsx
Annual Commission Totals
| | Annual Commission Totals |
| | Employee | Total Sales | Total
Commission |
| | DK52 |
| | LM33 |
| | MR54 |
| | TZ98 |
| | Total | $0.00 | $0.00 |
Qtr 1
| | Quarter 1 Totals |
| | Employee | Commission
Rate | Total Sales | Commission
Paid |
| | DK52 | 30% | 47,000.00 | 14,100.00 |
| | LM33 | 30% | 34,000.00 | 10,200.00 |
| | MR54 | 22% | 61,750.00 | 13,585.00 |
| | TZ98 | 15% | 15,000.00 | 2,250.00 |
| | Total | | 157,750.00 | 40,135.00 |
Qtr 2
| | Quarter 2 Totals |
| | Employee | Commission
Rate | Total Sales | Commission
Paid |
| | DK52 | 30% | 52,000.00 | 15,600.00 |
| | LM33 | 30% | 41,000.00 | 12,300.00 |
| | MR54 | 22% | 62,500.00 | 13,750.00 |
| | TZ98 | 15% | 24,050.00 | 3,607.50 |
| | Total | | 179,550.00 | 45,257.50 |
Qtr 3
| | Quarter 3 Totals |
| | Employee | Commission
Rate | Total Sales | Commission
Paid |
| | DK52 | 30% | 75,000.00 | 22,500.00 |
| | LM33 | 30% | 34,000.00 | 10,200.00 |
| | MR54 | 22% | 54,000.00 | 11,880.00 |
| | TZ98 | 15% | 20,100.00 | 3,015.00 |
| | Total | | 183,100.00 | 47,595.00 |
Qtr 4
| | Quarter 4 Totals |
| | Employee | Commission
Rate | Total Sales | Commission
Paid |
| | DK52 | 30% | 47,500.00 | 14,250.00 |
| | LM33 | 30% | 37,250.00 | 11,175.00 |
| | MR54 | 22% | 60,100.00 | 13,222.00 |
| | TZ98 | 15% | 32,000.00 | 4,800.00 |
| | Total | | 176,850.00 | 43,447.00 |
aghazzaw
