Optimization of the assignment of request into collective service system

Many different approaches for assignment of request into collective service system have already been presented. In this thesis new approach using mathematical programming and optimalisation software is presented. This thesis is mainly focus on system of collective service using queue in PRI, for which mathematical model with Binary variables is used. Main objective is to create simple method for request assignment onto processors to be served, that considers request profitability (generally attributes) and implement the method into application. Further objective is to implement developer method and enrich it with own simulation interface and the operation of method on case studies. Presented approach is implemented into VBA application with the use of MS Excel. Optimalisation is performed using MPL and CPLEX solver. Subsequently an option to perform not forecasting, but also simulation of system behavior is created.In theoretical part of this thesis, theoretical basics of this approach are presented, including its inclusion into the context of already published publications. In the next part, not only the presented approach is analyzed in detail, but also the created application implementing presented approach is introduced. Subsequently there are two case studies that have been carried out to demonstrate utilization of presented approach. For both case studies solutions have been found and analyzes performed. Finally, the presented approach is evaluated not only from point of view of advantages, but also disadvantages.