I'm trying solve the problems below but not sure where to start.
from the datasets below, I need to:
1. Select Ticket_ID's based on the total capacity of each technician.
- Can sampling be done based on variable name?
2. Assign selected tickets (in previous) step to each technician (based on capacity).
Appreciate your suggestions.
Table - 1: Tickets Received (Sorted based on value)
| Ticket_ID | Value |
| REQ019 | 400 |
| REQ018 | 300 |
| REQ017 | 200 |
| REQ002 | 150 |
| REQ003 | 150 |
| REQ001 | 100 |
| REQ007 | 100 |
| REQ008 | 100 |
| REQ015 | 100 |
| REQ016 | 100 |
| REQ004 | 80 |
| REQ005 | 70 |
| REQ010 | 70 |
| REQ011 | 70 |
| REQ012 | 70 |
| REQ013 | 70 |
| REQ014 | 70 |
| REQ006 | 50 |
| REQ009 | 50 |
| REQ020 | 10 |
Table - 2:Capacity (changes everyday)
| Technician | Capacity |
| Ann | 4 |
| Bob | 3 |
| Con | 3 |
Selection of requests and allocation:
Based on the capacity, which is 10 in the example, I need to select the tickets from table 1 and allocate to each technician
Table 3 - Expected Result
| Ticket_ID | Technician |
| REQ019 | Ann |
| REQ018 | Ann |
| REQ017 | Ann |
| REQ002 | Ann |
| REQ003 | Bob |
| REQ001 | Bob |
| REQ007 | Bob |
| REQ008 | Con |
| REQ015 | Con |
| REQ016 | Con |
