Warehouse Optimizer

The Warehouse Optimizer was a project developed within the Curriculum Units for Operational Research and Systems Laboratories 3 in the academic year 2017/2018.

Group

André Oliveira João Ribeiro Jorge Gabriel Azevedo Maria Inês Almeida Mariana Guedes

Academic year

2nd Year, 1st Semester

Scope of the Project

Build an application that calculates the optimal way for an AGV to collect products from a warehouse aisle.

Main Technologies

Excel / VBA Java AMPL

Repository

Github

Project phases

This project was divided into two phases. A first, carried out during the period of Operational Research where the problem was presented and requested a solution that consisted of developing a mathematical model to solve the problem and implement it in Microsoft Excel with VBA and Solver. In Systems Laboratories 3 the challenge was to implement this same mathematical model, but this time in AMPL and build an application in JAVA with the responsibility of maintaining the warehouse information, sending an optimization request to the AMPL op and modifying the registered information using the result obtained.