This is a rolling 13-month operational and financial dashboard for a Front Load waste collection business. Data rolls off monthly with the most recent period on the left, giving management a continuous trailing-year view at all times.
What It Tracks
Revenue & Financials
- Revenue is split between Permanent (recurring contracts) and Temporary (one-time/project) customers
- Disposal Cost is a significant expense line, typically running 16–22% of gross revenue (Disposal %) — notably lower than Roll-Off due to the nature of Front Load service
- Net Revenue reflects gross revenue after disposal costs are removed
Operational Volume
- Route Days & Routes — total days and truck routes operated
- Hours, Miles, Loads, and Tons — core activity metrics reflecting actual field productivity
- The most recent (current) month will typically show lower values as it represents a partial period
Efficiency Ratios — The bottom section normalizes performance for month-to-month comparison:
- Hours/Route Day & Loads/Route Day — crew productivity (Front Load runs significantly higher Loads/Route Day than Roll-Off, reflecting the high-frequency, multi-stop nature of the service)
- Miles/Load & Hours/Load — haul and time efficiency per pickup
- Tons/Load — container utilization per service
- Disposal Cost/Ton — cost efficiency of disposal
- Gross & Net Revenue per Route, per Hour, per Load — profitability benchmarks