Right on time Metrics based on a data matrix from another board

I have a board listing all the shipments I am organizing, including the dates of pick up and delivery. i would like to find a formula which calculates if a shipment was on time or late, based on a matrix which states the basic transport times needed for each transport lane (we have around 30 different lanes).