Production employees
Revenue-generating staff. Annual production hours auto-calculates from payroll hours × % production role. Bill rate × billable hours determines billable amount; write-ups/downs adjust to billed amount.
| Name | Position | Annual Payroll Hours | % Production Role | Annual Production Hours | Bill Rate | Billable Hours | Write-up/down | Salary | Tax & Benefits % |
|---|
Leadership team
Partners, directors, and leadership. Enter total annual revenue and total expense.
| Label | Annual Revenue | Annual Expense |
|---|
Other staff
Admin, operations, support. Enter total revenue and total expense for the group.
| Label | Annual Revenue | Annual Expense |
|---|
Company overhead
Expenses not tied to any individual. Allocated to the three groups proportional to revenue, then within production proportional to each employee's annual production hours.
| Line item | Annual amount |
|---|
Default collection rate
What percent of billed revenue typically collects.
Target margin
Used to back into target billing rates per employee.
Adjust by role
Set an absolute value that applies to everyone with this position. Leave blank to keep each employee's own value.
| Position | Bill Rate ($/hr) | Utilization (%) | Realization (%) |
|---|
Per-employee levers
Enter absolute values for each employee. The small number below shows % change vs baseline. Annual hours adjustments scale salary and benefits proportionally.
| Employee | Annual Hours | Bill Rate | Utilization % | Realization % | Realized Util % |
|---|
Scenario results
Baseline is your unadjusted model. Projected applies all adjustments above.
Contribution — baseline vs projected
Overview
Baseline snapshot.
Weekly hours breakdown
Contribution per employee
Revenue & overhead allocation by group
Full detail
Every computed field, per employee. Historic (baseline) and Projected (with current Scenarios adjustments applied).
Compare scenarios
Pick scenarios to stack side-by-side. High-level P&L first, then per-employee detail.
Company P&L
Per-employee comparison
Profitability, collected revenue, and net cost for each employee across selected scenarios.