| SIE 415 Sales Compensation Homework |
| | | | Large Widgets | | $45,000 | ea | (must sell 100) |
| | QTY | | % Comm. For Tier 1 | Projected QTY
for Tier 1 | % Comm. For Tier 2 | Projected QTY for Tier 2 | Projected QTY (total) | Comm. Large
(ea) | Comm. Large (total) |
| | 3 | Senior Sales Representatives | | | | | 0 | $0 | $0 |
| | 5 | Sales Representatives | | | | | 0 | $0 | $0 |
| | 2 | Sales Trainees | | | | | 0 | $0 | $0 |
| | | | | | | | 0 |
| | | | Medium Widgets | | $35,000 | ea | (must sell 150) |
| | QTY | | % Comm. For Tier 1 | Projected QTY
for Tier 1 | % Comm.for Tier 2 | Projected QTY for Tier 2 | Projected QTY (total) | Comm. Med.
(ea) | Comm. Med. (total) |
| | 3 | Senior Sales Representatives | | | | | 0 | $0 | $0 |
| | 5 | Sales Representatives | | | | | 0 | $0 | $0 |
| | 2 | Sales Trainees | | | | | 0 | $0 | $0 |
| | | | | | | | 0 |
| | | |
| | | | Small Widgets | | $10,000 | ea | (must sell 225) |
| | QTY | | % Comm. For Tier 1 | Projected QTY
for Tier 1 | % Comm. For Tier 2 | Projected QTY for Tier 2 | Projected QTY (total) | Comm. Small (ea) | Comm. Small (total) |
| | 3 | Senior Sales Representatives | | | | | 0 | $0 | $0 |
| | 5 | Sales Representatives | | | | | 0 | $0 | $0 |
| | 2 | Sales Trainees | | | | | 0 | $0 | $0 |
| | | | | | | | 0 |
| | QTY | | BASE salary | Large Widgets
comm. | Medium Widgets comm. | Small Widgets comm. | Total Income Per Rep | TOTAL SALES COMP. PAID |
| | 3 | Senior Sales Representatives | | $0 | $0 | $0 | $0 | $0 |
| | 5 | Sales Representatives | | $0 | $0 | $0 | $0 | $0 |
| | 2 | Sales Trainees | | $0 | $0 | $0 | $0 | $0 |
| | | | | | | | | $0 |
| | | TOTAL SALES | TOTAL SALES COMP. AVAIL. | | Blue cells = required; purple cells = optional |
| | | $0 | $0 | | Orange cells = check your quantities sold to ensure that you meet the goals |
| | |
fede
WidgetsSalesCompensation.xlsx
