The TruckAssign.xlsx Model

Time Aggregated Truck Assignment to Customer

View the model
Download the model

We have a set of sources (Concrete Redi-mix plants) available
to supply a set of customers who need a specified number of truck loads.
Serving a customer from a specific source takes a specific amount of truck time.
Each source has a limited number of trucks and hours.
How many truck loads should each source send to each customer?

Keywords:

Transportation Model | Trucking | Concrete example | Dispatching |