excel
cloud342
excel-assn-data.xlsxSheet1
| First Choice Travel | ||||||
| Sales Agent Commission Report | Commission Parameters | |||||
| Sales agent | Total value of travel bookings | Number of cruises booked | Commission | Number of cruises booked | Commission | |
| Lopez, D. | 72185 | 1 | 0 to 4 | 0.0175 | ||
| El-Kerdi, S. | 61475 | 5 | 5 and over | 0.0225 | ||
| Fournier, W. | 31485 | 0 | ||||
| Bhayana, M. | 52684 | 3 | ||||
| Mennill, S. | 23685 | 1 | ||||
| Doxtator, V. | 34875 | 7 | ||||
| Redick, L. | 22145 | 0 | ||||
| Ashby, W. | 63895 | 5 | ||||
| De Papp, Q. | 57642 | 3 | ||||
| O'Donovan, R. | 37478 | 2 | ||||
| Karamek, F. | 61485 | 8 | ||||
| Postovic, W. | 72665 | 10 | ||||
| Bistany, W. | 52396 | 5 | ||||
| Total | ||||||
| Average commission | ||||||
| Maximum commission | ||||||
| Minimum commission |
