Task Assignment Optimization with the Use of PESBAT Linear Programming Tool
Journal Title: Annales Universitatis Mariae Curie-Skłodowska Sectio H Oeconomia - Year 2018, Vol 0, Issue 2
Abstract
The article presents task assignment problem and the role that modern linear programming tools may play in its solving. Task assignment problem is a case of the assignment problem, which is one of the fundamental combinatorial optimization problems. Its specific formulations can be found in logistics (e.g. driver assignment problem), computer science (e.g. memory management) and other fields of science and business. Various methods and algorithms have been created or adapted to solve the assignment problem, and modern linear programming and optimization tools like Microsoft Excel Solver, which contain implementations of these algorithms, provide a possibility to solve diverse cases of the assignment problem with minimum effort and time. The article addresses widely known task assignment problem in business, its sources and ways of solving or reducing its negative impact on business processes effectiveness. The paper contains also a general overview of modern linear programming tools that can be used for task assignment and describes Microsoft Excel Solver Add-in as a tool for business process optimization. The main part of the article is a presentation of VBA based optimization tool called PESBAT developed by the authors and the case of task assignment process optimization in the enterprise that offers photoanalytical services. Pilot use of a PESBAT tool showed that it allows reducing the time needed for task assignment, gives more balanced workload for employees but also indicated the optimization possibilities of other areas of described company, like route optimization and reports preparation.
Authors and Affiliations
Uladzislau Yanch, Łukasz Wiechetek
Keywords
Related Articles
- EP ID EP392973
- DOI 10.17951/h.2018.52.2.185-198
- Views 65
- Downloads 0
Rola marketingowego zarządzania szkołą wyższą w aspekcie zmian na rynku usług edukacyjnych, The role of marketing management of the university at the aspect of changes in higher education market
Artykuł nie posiada streszczenia w języku polskim. Dynamic changes of the environmental conditions on the educational services market cause that schools of higher education begin to support their teaching and scientific...
Edukacja finansowa wobec rozwoju rynku alternatywnych usług finansowych, Financial education in view of the alternative financial services market development
Artykuł nie zawiera abstraktu w języku polskim. Continuous and dynamic changes in the functioning of the modern financial system cause an in- crease in the role of financial education. The importance of financial educati...
Foreign currency bonds. Functioning and structure of the instrument Obligacje w walucie obcej. Struktura i funkcjonowanie instrumentu
In the debt securities markets there are bonds that differ in their structure from straight bonds. They are an answer to changing economic conditions, the underlying cause of which are changes in interest rates and excha...
Znaczenie ubezpieczeń posagowych w gromadzeniu oszczędności gospodarstw domowych
Artykuł dotyczy ubezpieczeń na życie o charakterze posagowym, traktowanych przez gospodarstwa domowe jako alternatywne formy gromadzenia oszczędności. W opracowaniu wskazano oraz omówiono motywy i ekonomiczne determinant...
Cooperation between Vocational Schools and Business in Poland: Employers’ Perspective
The article identifies the barriers in cooperation between vocational schools and employers, which are connected with the economic and social environment of schools. The main source of information on employers’ perspecti...