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

Sistema de apoio à decisão baseado em planilha eletrônica para otimização da programação de entrega de concreto pronto

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 the authors 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.


  • English
  • Portuguese

Media Info

Subject/Index Terms

Filing Info

  • Accession Number: 01490754
  • Record Type: Publication
  • Files: TRIS
  • Created Date: Aug 30 2013 10:53AM