Modelo de programação matemática para a alocação otimizada de colaboradores em uma empresa de vendas de bebidas

Abstract

The allocation of employees in jobs is an important issue for companies that directly influence the costs and efficiency of the operation, as well as the satisfaction of the employees themselves. The methods involved in this operation are often archaic and based on the empiricism or experience of the managers, due to this the subject has become object of study within the academic environment, contributing to the development of tools that contribute to this process. However these tools are not commonly applied in the business environment, proving something often evidenced that often what is developed in the academic environment is not commonly applied in practice. The present work seeks to elaborate a method of allocation of employees based on the distance that they must go to the post, contributing to their satisfaction that will influence a better performance. For this, a model based on the transport problem, present in the area of operational research, was created in MS Excel and can be solved with OpenSolver software, which has a common interface with the Microsoft program. The work succeeded in its objective, reducing the time spent in the elaboration of the allocation and the total mileage of the allocation which contributed to the satisfaction of the employees. Improvements have been suggested based on the opportunities visualized so that the method continues to be worked on and can be improved.