Carrier Rate Card: Weight Brackets with XLOOKUP
Lessons in this course
- Shipment Log Cleanup: TRIM, UPPER and PROPERFree
- Freight Cost per Shipment, per kg and per Pallet Locked
- Carrier Rate Card: Weight Brackets with XLOOKUP Locked
- Dimensional Weight vs Actual Weight with MAX Locked
- On-Time Delivery Rate per Carrier with COUNTIFS Locked
- Transit Days in Working Days: NETWORKDAYS and Holidays Locked
- Pallets, Trailers and Fill Rate with ROUNDUP Locked
- Fuel Surcharge per Kilometre on Truckload Invoices Locked
- Warehouse Pick Productivity: Lines per Hour Locked
- Stock Movements: Running Balance, Reorder Flag and Cycle Count Locked
- Carrier Scorecard: OTD, Cost per kg and Ranking Locked
- Logistics Dashboard: OTD Trend, Cost per Shipment and Highlights Locked
- Dock Appointments: Late Arrivals, Unload Times & Door Hours Locked
- Freight Invoice Audit: Expected Charges, Overbilling & Disputes Locked
- Open Shipments Report: Days Since Pickup, Overdue Flags & Counts by Status Locked
- Freight Claims: Claims per 100 Shipments, Amounts Paid & Recovery Rate Locked
- LTL or Full Truckload? Comparing Two Quotes per Order & the Break-Even Weight Locked
- Shipping Volume by Weekday: Day Names, AVERAGEIFS & Dock Staffing Locked
- Customer Delivery Profiles: XLOOKUP, Not-Found Values & Special Requirements Locked
- Final Project: Monthly Lane Report with SUMIFS, OTD Targets, Flags and a Chart Locked