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