Know exactly how your fleet is performing
The Equipment Utilization Report is the most comprehensive equipment analytics dashboard in the DataXcel suite. It pulls directly from your Sage 100 Contractor data and delivers 10 purpose-built views covering utilization rates, depreciation schedules, cost analysis, and asset tracking — replacing the manual Excel report your team spends hours compiling each month.
What’s included
- Equipment Utilization Report — master table showing every piece of equipment with allocated units, costs, maintenance, depreciation, and utilization % calculated against configurable work days
- Equipment Type Summary — aggregated view by equipment type with total costs, revenue, and unit counts
- Equipment KPI Summary — fleet-wide scorecards: total allocated costs, maintenance spend, depreciation, and average utilization rate
- Rate Review by Equipment Type — compare internal billing rates against actual costs to identify over- and under-priced equipment types
- Equipment Depreciation — detailed depreciation schedule by unit: purchase date, annual rate, period depreciation, and accumulated totals
- Asset Location by Day — daily job-site assignment history showing where each piece of equipment was deployed
- Cost Breakdown by Type (Top 15) — bar chart ranking equipment types by total cost (allocated + maintenance + depreciation)
- Total Cost by Department — pie chart showing equipment cost distribution across departments
- Revenue vs. Ownership Cost (Top 15) — side-by-side comparison of what each equipment type earns vs. what it costs to own
- Allocated Units by Department — horizontal bar chart showing equipment allocation across departments
Available filters
Period Start • Period End • Posting Year • Work Days
Who it’s for
- Equipment managers — track utilization rates and identify underused assets
- Controllers and CFOs — monitor depreciation, review internal rates, and validate equipment profitability
- Operations managers — see daily asset deployment and department-level cost allocation
- Owners — understand fleet ROI at a glance with revenue vs. ownership cost comparisons
⚠️ Requires a DataXcel Core Subscription — $799/mo. You must be an active DataXcel subscriber to add this dashboard to your plan. View Core Subscription →
📊 Try it live — no login required
Explore a live demo of this dashboard using real sample data. Filters, charts, and drilldowns all work — no account needed.
🔗 Open Live Demo →