Tabellab

Freight Claims: Claims per 100 Shipments, Amounts Paid & Recovery Rate

Lesson 16 of 20 Lab 🔒 Locked

Lessons in this course

  1. Shipment Log Cleanup: TRIM, UPPER and PROPERLabFree
  2. Freight Cost per Shipment, per kg and per PalletLab Locked
  3. Carrier Rate Card: Weight Brackets with XLOOKUPLab Locked
  4. Dimensional Weight vs Actual Weight with MAXLab Locked
  5. On-Time Delivery Rate per Carrier with COUNTIFSLab Locked
  6. Transit Days in Working Days: NETWORKDAYS and HolidaysLab Locked
  7. Pallets, Trailers and Fill Rate with ROUNDUPLab Locked
  8. Fuel Surcharge per Kilometre on Truckload InvoicesLab Locked
  9. Warehouse Pick Productivity: Lines per HourLab Locked
  10. Stock Movements: Running Balance, Reorder Flag and Cycle CountLab Locked
  11. Carrier Scorecard: OTD, Cost per kg and RankingLab Locked
  12. Logistics Dashboard: OTD Trend, Cost per Shipment and HighlightsLab Locked
  13. Dock Appointments: Late Arrivals, Unload Times & Door HoursLab Locked
  14. Freight Invoice Audit: Expected Charges, Overbilling & DisputesLab Locked
  15. Open Shipments Report: Days Since Pickup, Overdue Flags & Counts by StatusLab Locked
  16. Freight Claims: Claims per 100 Shipments, Amounts Paid & Recovery RateLab Locked
  17. LTL or Full Truckload? Comparing Two Quotes per Order & the Break-Even WeightLab Locked
  18. Shipping Volume by Weekday: Day Names, AVERAGEIFS & Dock StaffingLab Locked
  19. Customer Delivery Profiles: XLOOKUP, Not-Found Values & Special RequirementsLab Locked
  20. Final Project: Monthly Lane Report with SUMIFS, OTD Targets, Flags and a ChartLab Locked