The FTLsupply.xlsx Model

FTL Shipping of Multiple Products from Multiple Suppliers to Multiple Customers

View the model
Download the model

  Situation: A set of products,
       A set of customers/retailers, and
       A set of suppliers.
Products are delivered from supplier to customer by trucks of a specified capacity.
The shipping costs depend upon how many trucks must be sent
from each supplier to each customer.
  Example: A customer/retailer needs 8 pallets of paper towels and 9 pallets canned goods.
A truck can carry 18 pallets. If the retailer can get both products from one supplier,
at good prices, then only one truck need be sent to the retailer, else 2 trucks are needed.

Keywords:

Supply Chain | Transportation Model | Container Routing | FTL | Multi-commodity |