Yard & Trailer Management: Trailer Inventory, Dwell Times, Yard Slots, Shunter Moves, Drop-Trailer Pools & Detention-Style Charges
Bring order to the yard outside the warehouse. You will track trailers in and out, measure dwell times, size the yard and its parking slots, plan shunter moves and drivers, decide how many trailers a drop-and-hook pool needs, calculate fictional free-time charges and audit the yard list, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
This course takes you to the yard outside a fictional distribution centre. You count the trailers on site at any time from a gate log with COUNTIFS, measure dwell hours and sort trailers into ageing buckets with IFS, compare daily peaks with the slots of each zone and colour the overflows, turn planned trailer moves into shunters per shift, size gate lanes for a target utilisation with a simple queue formula, work out turn times and pool sizes for drop-and-hook lanes, price fictional free-time charges per carrier with XLOOKUP and SUMIFS, and finish with a yard audit and a dwell-time chart.
Lessons
- The Gate Log: Arrivals, Departures and Trailers on Site at Any Time Pro
- Dwell Time: Hours on Site, Ageing Buckets and Averages by Status Pro
- Yard Capacity: Slots by Zone, Peak Occupancy, Utilisation and Overflow Risk Pro
- Shunter Moves: Workload Minutes, Shunters per Shift and the Cost of the Yard Fleet Pro
- Gate Throughput: Check-In Minutes, Lanes at Peak and the Planning Wait Pro
- Drop-Trailer Pools: Turn Times, Pool Size, Tractors and the Cost of Extra Trailers Pro
- Free Time and Charges: Hours Held, Chargeable Days and Charges by Carrier Pro
- The Yard Audit and the KPI Chart: System vs Physical Check, Accuracy and Unknown Trailers Pro