Utilization rate dashboard template

Everhour tracks work hours and timecards, giving utilization dashboards cleaner inputs for billable, available, and reviewed time.

How efficiently is yourteam's time being used?

Measure billable utilization against total capacity and see exactly how many hours you're leaving on the table each period.

Working hours this period

80%

Industry average for agencies: 75–85%

Utilization rate
Non-billable hours40h
Gap to target5%
Hours to recover8h

Everhour does it all — track, budget, report & invoice

The calculator gives you the number — Everhour takes it from there.

Go ahead — start tracking!

One click and you're timing. Start a timer, add an entry, edit the details. This is exactly how it feels in Everhour.

  • One-click timer — browser, desktop & mobile
  • Works inside Asana, ClickUp, Linear, GitHub & more
  • Simple setup, no learning curve
Works with your favorite tool:
Everhour — Time Tracking
Time Entries
01:24:00
00:31:00
01:07:00

No more budget surprises

Set a budget, assign rates, and get alerted before you're over.

  • Real-time cost tracking
  • Set different rates per person or project
  • Alerts before you hit the budget limit
Everhour — Budgeting
Acme Web Project
1
50% of budget used
$2,500.00of $5,000.00
$2,500.00 remaining
75%
Actual costRemaining cost

Measurement

Track your budget through time or costs

Simple, customizable reports

Every report you need — configured your way, always up to date.

  • See who does what in real time
  • Configure any report
  • Scheduled email reports
Everhour — Reports

Your invoice is ready!

Tracked hours flow straight into a polished invoice — no copy-paste, no manual math.

  • Billable hours straight into the invoice
  • Configure invoice templates
  • Copy invoices to QuickBooks or Xero
  • Invoicing dashboard with status
Everhour — Invoices
Your Company LLChello@yourcompany.com
INVOICE
Invoice #1042
Group by:
DescriptionHoursRateAmount
Website Redesign14h$150/h$2,100.00
Brand Guidelines7h$150/h$1,050.00
Marketing Strategy3.5h$150/h$525.00
Total Due$3,675.00
Try Everhour for real yourself

Building a reliable utilization dashboard

What this calculation answers

A utilization rate dashboard answers one operational question: how much available working time turned into billable client work. The core ratio is billable hours divided by available hours. A dashboard template turns that ratio into repeatable columns by person, team, role, project, and date range, so managers can compare actual utilization with targets without rebuilding the math every week.

The dashboard also prevents a common reporting mistake: mixing denominator definitions in the same view. One chart may use gross capacity, such as 40 scheduled hours. Another may use working hours net of PTO, holidays, unpaid leave, and other absences. Both can be valid, but the dashboard must label each figure clearly because the same person can show a different utilization rate under each denominator.

Set the dashboard denominator

Start the template with one capacity policy. For U.S. teams, the FLSA does not define full-time or part-time employment, so full-time capacity is an employer policy rather than a federal legal threshold. Many firms still use 40 weekly hours as gross capacity because federal overtime rules require covered nonexempt employees to receive overtime pay for hours worked over 40 in a fixed 168-hour workweek.

A 40-hour weekly baseline equals 2,080 gross annual hours before subtracting company PTO, holidays, unpaid leave, or other nonworking time. Private-sector paid holidays and paid vacation are policy or contract items unless another law applies. OPM lists 11 federal holidays in 2026 for federal employees, but private-sector paid holidays are not automatically required by federal law.

Use the formula in context

The dashboard formula is utilization rate = billable hours ÷ available hours × 100. For example, a consultant has 40 gross capacity hours in a week, takes 8 hours of approved PTO, and records 24 billable hours. Net available hours are 32. Utilization on net available hours is 75%, while utilization on gross capacity is 60%.

Add revenue context only when the dashboard needs it. At a $140 billing rate, those 24 billable hours carry $3,360 of billable value. Spread across the 32 available hours, the effective value is $105 per available hour. That number is not realization, because realization compares billed revenue with standard billable value after write-downs, discounts, or unbilled work.

Keep metric families separate

A dashboard template should not treat utilization, realization, efficiency, productivity, and capacity utilization as the same metric. Utilization compares billable hours with available hours. Realization compares actual billed revenue with standard billable value. Efficiency usually compares planned time with actual time. Productivity needs a defined output, such as tickets closed, deliverables shipped, or client milestones completed.

Capacity utilization also needs context. In professional services, teams often use it to mean billable hours divided by capacity. In economics or manufacturing, it can mean actual output divided by potential output. A services dashboard should label the numerator and denominator directly, such as "Billable hours ÷ net available hours," so a reviewer knows exactly which metric the chart shows.

Move beyond one-off checks

A one-time calculator is enough when you need a quick weekly answer for one person, one project, or one staffing scenario. A dashboard becomes necessary when managers compare utilization against targets, review trends by role, account for PTO and holidays, or explain why billable capacity changed from one week to the next.

A managed workflow matters once the inputs come from multiple people. Time entries need billable and non-billable classifications, timecards need review, and absences need to reduce available hours under the chosen denominator. Everhour timecards support payroll review with daily, weekly, and monthly work-hour totals, project-vs-working-hour comparisons, Team Hours reporting, approvals, and exports for downstream review.

This content is for general information only, may not be fully up to date, and is provided without any warranty or liability.

High Performer

G2

Summer 2026

Best Ease Of Use

Capterra

Summer 2026

Loved by teams. Proven everywhere.

Rated in the top time trackers across G2, Capterra, and TrustRadius — with consistent praise for ease of use, integrations, and support.

10K+Teams worldwide
90K+Installs Everhour extension
196M+Tasks completed
4M+Projects tracked

Frequently Asked Questions

Which columns belong in a utilization dashboard?

A practical dashboard needs person, role, project, date range, billable hours, non-billable hours, available hours, PTO or absence hours, utilization target, actual utilization, and variance from target. Add billable value only when managers need a revenue lens. Keep denominator labels visible, especially when one view uses gross capacity and another uses net available hours.

Why can the same dashboard show two utilization rates?

The denominator changes the result. A person with 24 billable hours has 60% utilization against 40 gross capacity hours and 75% utilization against 32 net available hours. Neither figure is wrong if the dashboard labels the denominator. A template becomes misleading when it mixes gross capacity, logged hours, and net working hours without naming the basis.

Should a dashboard include PTO and holidays?

A net-working-hours dashboard should subtract PTO, holidays, unpaid leave, and similar absences from available hours. A gross-capacity dashboard should show those absences separately instead of hiding them. Federal law does not require private employers to provide paid vacation or paid holidays, so U.S. dashboards should follow company policy, contracts, and applicable non-federal requirements.

Is a utilization target required by U.S. law?

No statutory national target exists for utilization in the United States. Federal sources define work-hour and leave rules, including overtime for covered nonexempt employees after 40 hours in a workweek, but they do not set a professional-services utilization target. Firms set targets by role, service line, seniority, and business model.

Where do realization and productivity fit in the template?

Place realization and productivity in separate dashboard sections. Realization needs billed revenue or write-down data, while utilization only needs billable hours and available hours. Productivity needs a defined output measure. A consultant can be highly utilized and still have poor realization if billable work gets discounted, written off, or left unbilled.

How do Everhour timecards support utilization dashboard review?

Everhour timecards show daily, weekly, and monthly work-hour totals, then compare project hours with working hours in Team Hours reporting. Managers can review missing or excessive hours, approve weekly timecards, and export PDF, CSV, or XLSX files before using the data in utilization reports.

Track utilization with reviewed hours

Use reviewed timecards, project-hour comparisons, and Team Hours exports to keep dashboard inputs consistent. Everhour gives managers cleaner work-hour totals for utilization review.

14-day free trial  ·  No credit card  ·  Cancel anytime

Or