Margin by Associate
[Associate] — [engagement]
| Bill rate | Pay rate | Margin |
|---|---|---|
| — | — | — |
Computed per associate, not folded into one blended average, before the assignment is confirmed.
Three documents and three sheets that compute margin by associate, not just one blended average, before you staff the next engagement.
Free download · No account needed
What you get
Pack of 6 files: 3 documents, 3 spreadsheets
Margin by Associate
| Bill rate | Pay rate | Margin |
|---|---|---|
| — | — | — |
Computed per associate, not folded into one blended average, before the assignment is confirmed.
Page one for this query is thorough on the contract and silent on the arithmetic. Genie AI's consulting subcontractor agreement covers scope, IP, confidentiality and risk allocation between a prime consultant and a subcontractor; other guides add client-consent-to-subcontract clauses, flow-down obligations, and mutual indemnification. All of it protects the relationship and the liability. None of it asks whether staffing a specific associate onto a specific engagement actually left a margin worth the coordination and the risk.
Run three associates through Marlwood Consulting's fictional roster and the gap shows up immediately. Priya Ostrander, paid $120 an hour and billed at $195, nets a $75 margin, 38.5%. Renata Solberg, paid $185 and billed at $215, the highest bill rate of the three, nets only $30, 14.0%, the thinnest margin in the roster. Bill rate alone would rank Renata as the most valuable associate to staff; margin ranks her last, because her pay rate sits closest behind what the client is charged.
Margin by Associate is the sheet that makes the ranking visible: hours, revenue billed, cost paid, and what is left, per associate, not folded into one blended number. Across 180 hours that quarter, Marlwood billed $36,800 and paid out $26,000, a 29.3% blended margin that hides the 24.5-point spread underneath it. The subcontract agreement-style protections still matter, and this pack includes them; what it adds is the number that says whether the arrangement was worth signing at all.
The signed contract with the associate: flow-down of the client's own terms, confidentiality, indemnification, and the rate recorded on the Associate Register.
The client-relationship protection stated plainly: what it restricts, why it exists, and what Prime actually grants when it releases an associate from it.
The four-part bar every deliverable is measured against before it reaches the client, so a gap traces to an agreed standard rather than a feeling.
Every associate's specialism, pay rate, and bill rate in one place, with the margin computed the moment the second rate is entered.
Who is staffed where, at what bill rate, cross-referenced to the fee a proposal already quoted the client.
Revenue billed minus cost paid, per associate, not folded into the one blended figure a pricing model might average across a whole roster.
Open the pack and describe a real associate's specialism and rates, or download the Word documents and CSV sheets and run the register yourself.
Add the associate's pay rate and bill rate to the Associate Register, and let the margin per hour and percentage compute automatically.
Staff the associate onto a named engagement, and compare their margin against everyone else on the roster before the assignment locks in.
Once hours are logged, total revenue billed and cost paid per associate, and flag whichever margin sits well below the others.
Yes. The zip is Word documents and CSV sheets, no account and no card. Edit with AI is the optional half: describe an associate's rates and the margin gets computed and compared against the rest of the roster. The rest sit in the template library.
Three Word documents and three CSV sheets in one zip. The Associate Register, Engagement Assignment and Margin by Associate sheets open in Excel, Numbers or Google Sheets with every column intact, no conversion needed before you enter the first rate.
Most subcontractor templates state the same protections this one does: flow-down of the client's own terms, indemnification, a non-solicit clause. None of them compute margin by associate, revenue billed minus cost paid, per person, which is what actually says whether staffing an associate was worth it.
You don't have to. The Subcontract Agreement's payment clause states what the practice pays the associate; what gets billed to the client is a separate commercial arrangement, disclosed only if the practice chooses to. The Associate Register and Margin by Associate sheets stay internal.
There is no universal number; the point is comparing associates against each other on the same roster, the way Renata Solberg's 14.0% looked thin next to Priya Ostrander's 38.5% despite Renata's higher bill rate. On an ongoing engagement, the same check runs against a retainer's included hours instead of one project's fee.
The Subcontract Agreement's indemnification clause makes the associate responsible for the loss, rather than the practice simply absorbing a lost client as a cost of using associates. The Non-solicit Note states what counts as a breach and what written consent actually releases.
Take the Word documents and CSV sheets blank, or send River an associate's rates and get their margin computed against the rest of the roster.
Edit with AI