SicherPro Security at Truckzeit

SicherPro offers global and specialized security services that, combined with the most advanced technologies, seek maximum efficiency for companies' business management. A typical problem the company faces is how to assign security officers in such a way that the customer's needs are met and, at the same time, the assignment is as efficient as possible. The case deals with the problem of assigning scarce resources (guards, in this case) in the most efficient way, given a large number of constraints. While this type of problem can be dealt with manually, automating the task can generate important savings in resources. This case comes woth two excel files.