EXPEDITES
TABLEAU
OTM
SHIPMENTS OVER THE BORDER
CLAIMS AND FREIGHT PAY
100
  • For AMCO, who needs to be on copy for all expedite requests?
    Joana, Kara, Joelle
100
  • As of 10/01, what week did we as a team have the highest OTP this year? What was that OTP?
  • Week 38, 89%
100
  • How do you pull multiple BOLs from OTM at once and as a RTF file?
  • Select multiple SIDs and go to Actions --> Business Process Automation --> Reports --> Custom Reports. Select Bill_Of_Lading_1, enter your email address, and select the report format as RTF
100
  • Who is our customs broker for Domestic shipments?
  • DHL Global Forwarding
100
  • What is the inbox associated with freight claims?
  • RavagoCarrierClaims@ravago.com
200
  • Name 2 options other than our standard LTL expedite carriers (PEI, Panther, Luhu Fedex Custom Critical) that we can use in order to potentially find a better rate for higher service
    LTL Guarantees and TL Dedicated Trucks/Partials
200
  • How many orders did we have in August of this year across the whole team? How did this compare to August last year?
  • 12,763 in 2022, 13,706 in 2021
200
  • How often do we negotiate LTL rates?
  • Once a year
200
  • Where in OHM can you find the customs value and country of manufacture for material?
  • Product ID section
200
  • What does all/short mean?
  • Freight cannot be located by the carrier
300
  • If you have an expedite that’s delivering afterhours to our customer, what information do you need to get from the sales team, and at what time should afterhours be copied in with the sales team and the carrier?
    We need an afterhours receiving contact from sales, and the afterhours email should be copied in just before leaving for the day to minimize excess emails.
300
  • What is city to city lane has the most volume in all of West (packaged & bulk)?

Baytown, TX to Houston, TX

300
  • How would you pull a report for 7 pallet or less TL shipments that need to be checked to verify if we are expediting? How about a report for 20k or less shipments that can be split into 2 SOs?
  • All Shipments, Ship Date yesterday and after, mode TL, transportation coordinator. Sort by pallet count. If searching for 20k shipments with multiple SOs, sort by weight and open up the orders to see if more than one has been planned
300
  • What are the 2 emails we use for DHL?
  • Sarnia.Pars@dhl.com and nbrimports@dhl.com
300
  • When a charge needs to be disputed, is it the freight pay coordinator or the TC that needs to dispute with the carrier?
  • The TC
400
  • What field do we mark in OTM when sales approves a dedicated option?

Expedite marker

400
  • What was the total freight spend for 2021?
  • $119,317,136
400
  • What season should we really focus on negotiation, especially into the south?
    Produce Season
400
  • What's the clearance code associated with shipments coming from the US into Canada?

PARS

400
  • What date should an all short order be closed out for?
  • The date that the claim is filed
500
  • Name one situation you would offer an expedite for

LTL missed pick ups

Customer shut down

Weekend deliveries

Transit time

500
  • In the Southeast, who is the highest OTP TL carrier with more than 200 loads in volume?
  • Mila’s Trucking
500
  • What is the process for planning a packaged multi-stop shipment, and pulling the BOL for that multi-stop?
  • Select the orders that need to be combined from the order screen and go to Actions -->Operational Planning-->Create Buy Shipment-->Multi-Stop. Once planned, you can pull the BOL for the multi-stop with Bill_of_Lading_2
500
  • What's the clearance code associated with shipments coming from the Canada into the US?

PAPS

500
  • When the freight pay coordinator reaches out about a short pay, what are the next steps for the TC?
  • Reach out to the carrier on the PRO number for an invoice, match the invoice with what makes sense through emails that we have