Acessibilidade / Reportar erro

A spreadsheet-based decision support system for optimizing the schedule of ready-mix concrete

This paper addresses a spreadsheet-based decision support system (DSS) for the problem of scheduling the delivery of ready mix concrete produced in concrete batch plants or centers taking into consideration the Brazilian reality. Such scheduling comprises decisions of what facility should serve each customer and what time each delivery vehicle should be loaded, so as to maximize the total marginal revenue of the system. Vehicle loading capacity constraints per center, fleet availability and ensuring that each client's orders are fulfilled by a single plant are considered. In order to solve this optimization problem efficiently we propose a mathematical programming model based on a time-space network. The spreadsheet-based DSS, novel in the literature, allows a concrete company which operates several concrete batch plants company to schedule its daily operations in an easy and straightforward manner, by users with no background in operations research, thus making it especially suitable for companies that are not ready or whose size does not allow the investment in a corporate system to aid the scheduling.

delivery scheduling; ready mix concrete; space-time network


Sociedade Brasileira de Planejamento dos Transportes Universidade Federal do Amazonas, Faculdade de Tecnologia - Pavilhão Rio Japurá - Setor Norte, Av. Gal Rodrigo Otávio, n. 3000, Coroado, CEP 69077-000, Tel.: (55 92) 3305-4613 | 3305-4607 - Manaus - AM - Brazil
E-mail: editor.jtl@gmail.com