Explanation
The foremen assign trucks and operators to beats. An ideal set of assignments is the one that leads to the highest quality and lowest the cost of the collection service.
There are a large number of possible assignments. They vary in their costs and qualities. Moreover, those assignments may vary by season, weather condition and the amount of waste.
Therefore, there are a number of criteria that have to be considered to achieve the aforementioned goals for the cost and quality. In this module, we aim to take these criteria into account and recommend a set of assignments for the beats.

Solution offered:





Operators Info

Operator Sheet file

Index
Employee Id
Name
Hire Date
Background Info
Truck Type
Working Days
Relationship
1
245632
Ben
1-Jan-1970
2
243632
Alex
1-Jan-1970
3
12342
Joe
2-Jan-1970
Background Info
Truck Type
Working Days
Relationship