Integration of a Food Distribution Routing Optimization Software with an Enterprise Resource Planner

Pedro J. S. Cardoso, Gabriela Schütz, Jorge Semião, Jânio Monteiro, João Rodrigues, Andriy Mazayev, Emanuel Ey Vieira, Micael Viegas, Carlos Neves, Sérgio Anastácio

2015

Abstract

i3FR is a system for optimizing the distribution of fresh goods, using a fleet of vehicles, which must be integrated with an existing Enterprise Resource Planning (ERP) software, while avoiding disruption of established schedules and procedures. In terms of delivery optimization, the most similar problem in literature is the wellestablished and experimented Vehicle Routing Problem with Time Windows (VRPTW), which is, by nature, a multiple objective problem where the number of vehicles and the total traveled distance must be minimized. In this paper, the overall architecture of the i3FR system is presented, which includes several modules and services (such as ERP, routing optimization and data acquisition modules), and the communication between them. The novelty in the proposed architecture comprises: (i) the application to a fresh goods distribution network, with multiple restrictions on goods’ acclimatization; (ii) a data acquisition system which includes vehicle data and environmental data from the vehicles’ refrigerated volumes, such as temperature; and (iii) the integration of the VRPTW optimization system with an existing ERP. A case-study is described and validates the overall implementation. The main contribution of paper is the proposal of a multi-layered architecture to integrate existing ERP software with a route optimization and a temperature data acquisition module.

References

  1. Abousaeidi, M., Fauzi, R., and Muhamad, R. (2011). Application of geographic information system (gis) in routing for delivery of fresh vegetables. In Humanities, Science and Engineering (CHUSER), 2011 IEEE Colloquium on, pages 551-555. IEEE.
  2. Ambrosino, D. and Sciomachen, A. (2007). A food distribution network problem: a case study. IMA Journal of Management Mathematics, 18(1):33-53.
  3. Cardoso, P. J. S., Schütz, G., Mazayev, A., and Ey, E. (2015). Solutions in under 10 seconds for vehicle routing problems with time windows using commodity computers. In Proc. of the 8th International Conference on Evolutionary Multi-Criterion Optimization, EMO'15, page (Accepted for publication).
  4. Chen, H.-K., Hsueh, C.-F., and Chang, M.-S. (2009). Production scheduling and vehicle routing with time windows for perishable food products. Computers & Operations Research, 36(7):2311 - 2319.
  5. Faulin, J. (2003). Applying MIXALG procedure in a routing problem to optimize food product delivery. Omega, 31(5):387 - 395.
  6. Glover, F. and Laguna, M. (1999). Tabu search. Springer.
  7. Hsu, C.-I., Hung, S.-F., and Li, H.-C. (2007). Vehicle routing problem with time-windows for perishable food delivery. Journal of Food Engineering, 80(2):465- 475.
  8. JSON (2014). Javascript object notation. http:// www.json.org/. Accessed september 28, 2014.
  9. Logvrp.com (2014). Logvrp.com. http://logvrp.com. Retrived on Nov. 27, 2014.
  10. Microchip (2014). The mcp9700 temperature sensor, datasheet. http://www.microchip.com/wwwproducts/ Devices.aspx?dDocName=en022289. Accessed December 1, 2014.
  11. MongoDB, I. (2014). Mongodb. http:// www.mongodb.com/. Accessed 28/10/2014.
  12. Newronia.com (2014). Newronia.com. http://en. newronia.com. Retrived on Nov. 27, 2014.
  13. Optimoroute.com (2014). Optimoroute.com. http:// optimoroute.com. Retrived on Nov. 27, 2014.
  14. optrak.com (2014). Optrak.com. http://optrak.com/. Retrived on Nov. 27, 2014.
  15. OSRM (2014). OSRM - Open Source Routing Machine. http://project-osrm.org/. Accessed september 28, 2014.
  16. Osvald, A. and Stirn, L. Z. (2008). A vehicle routing algorithm for the distribution of fresh vegetables and similar perishable food. Journal of Food Engineering, 85(2):285 - 295.
  17. Redmond, E. and Wilson, J. R. (2012). Seven databases in seven weeks: a guide to modern databases and the NoSQL movement. Pragmatic Bookshelf.
  18. Richardson, L. and Ruby, S. (2008). RESTful web services. ” O'Reilly Media, Inc.”.
  19. Routyn (2014). Routyn. http://www.routyn.com/. Retrived on Nov. 27, 2014.
  20. SAGE, E. X. (2014). Sage erp x3. Accessed september 28, 2014.
  21. Solomon, M. M. (1987). Algorithms for the vehicle routing and scheduling problems with time window constraints. Operations research, 35(2):254-265.
  22. Tarantilis, C. and Kiranoudis, C. (2002). Distribution of fresh meat. Journal of Food Engineering, 51(1):85 - 91.
Download


Paper Citation


in Harvard Style

S. Cardoso P., Schütz G., Semião J., Monteiro J., Rodrigues J., Mazayev A., Ey Vieira E., Viegas M., Neves C. and Anastácio S. (2015). Integration of a Food Distribution Routing Optimization Software with an Enterprise Resource Planner . In Proceedings of the 1st International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM, ISBN 978-989-758-099-4, pages 153-161. DOI: 10.5220/0005385901530161


in Bibtex Style

@conference{gistam15,
author={Pedro J. S. Cardoso and Gabriela Schütz and Jorge Semião and Jânio Monteiro and João Rodrigues and Andriy Mazayev and Emanuel Ey Vieira and Micael Viegas and Carlos Neves and Sérgio Anastácio},
title={Integration of a Food Distribution Routing Optimization Software with an Enterprise Resource Planner},
booktitle={Proceedings of the 1st International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM,},
year={2015},
pages={153-161},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0005385901530161},
isbn={978-989-758-099-4},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 1st International Conference on Geographical Information Systems Theory, Applications and Management - Volume 1: GISTAM,
TI - Integration of a Food Distribution Routing Optimization Software with an Enterprise Resource Planner
SN - 978-989-758-099-4
AU - S. Cardoso P.
AU - Schütz G.
AU - Semião J.
AU - Monteiro J.
AU - Rodrigues J.
AU - Mazayev A.
AU - Ey Vieira E.
AU - Viegas M.
AU - Neves C.
AU - Anastácio S.
PY - 2015
SP - 153
EP - 161
DO - 10.5220/0005385901530161