The paper presents the problem of material requirements planning with optimization of load distribution between work centers and workers’ groups. Moreover, it discusses the computational example for shop orders optimization. The data for this example were taken from the relational database. The method of Constraint Logic Programming (CLP) for shop orders optimization has been suggested. Using Constraint Logic Programming, the constraints may be directly introduced to the problem declaration, which is equivalent to the source code of the program. The ECLiPSe-CLP software system has been presented. It allows for solving optimization problems concerning dimensions greater than in the case of the professional mathematical programming solver “LINGO”. The application of ECLiPSe-CLP in accessing data from relational databases has been presented.
References
Landvater, D. V., & Gray, C. D. (1989). MRP II Standard System. Oliver Wight Publications.
Niederliński, A. (2011). A Quick and Gentle Guide to Constraint Logic Programming via ECLiPSe. Gliwice.
Rossi, F., Van Beek, P., & Walsh, T. (2006). Handbook of Constraint Programming (Foundations of Artificial Intelligence). New York, NY, USA: Elsevier Science Inc.
Sitek, P., & Wikarek, J. (2019). Capacitated vehicle routing problem with pick-up and alternative delivery (CVRPPAD): model and implementation using hybrid approach. Annals of Operations Research, 273, 257. https://doi.org/10.1007/s10479-017-2722-x
Sitek, P., & Wikarek, J. (2018). A multi-level approach to ubiquitous modeling and solving constraints in combinatorial optimization problems in production and distribution. J. Appl. Intell, 48, 1344. https://doi.org/10.1007/s10489-017-1107-9
Sitek, P., Wikarek, J., & Zaborowski, M. (2002). Application of Constraint Logic Programming (CLP) to Shop Orders Optimization in MRP II Systems. In Conference: 4th Workshop on Constrained Programming for Decision and Control (pp. 59-66). Gliwice. www.eclipse.org (n.d.) Retrieved October 19, 2018, from The Eclipse Foundation open source community website www.eclipse.org.
www.lindo.com (n.d.) Retrieved October 19, 2018, from www.lindo.com