1 · THE REVENUE
(A) TOTAL GROSS REVENUE—
2 · THE HOUSE TAKE (OFF THE TOP)
House fee—
3 · THE HARD COSTS (COGS)
(B) TOTAL HARD COSTS—
Labor as a share of hard costs
4 · THE PROFIT CHECK
Total net profit (A − fee − B)—
ACTUAL GROSS MARGIN %—
Points above / below the floor—
Which band this job landed in—
5 · THE COMMISSION CALCULATION
Commission tier earned—
Commission base—
Gross commission (base × tier)—
LESS: Milestone 1 booking draw—
LESS: back-charges—
(C) FINAL COMMISSION PAYOUT—
THE REALITY CHECK
Price this job needed to clear the floor—
Revenue short of the floor—
What the floor penalty cost the rep—
What the company keeps after commission—
REVIEWED BY BOTH SIDES—
Settled Jobs
One row per settled job. Type date, job number, type, revenue and hard costs — the rest computes.
| Date settled | Job # | Job type | (A) Gross revenue | House fee | (B) Hard costs | Net profit | Actual margin | Tier earned | Gross commission | What moved the margin | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | — | — | — | — | — | ||||||
| 2 | — | — | — | — | — | ||||||
| 3 | — | — | — | — | — | ||||||
| 4 | — | — | — | — | — | ||||||
| 5 | — | — | — | — | — | ||||||
| 6 | — | — | — | — | — | ||||||
| 7 | — | — | — | — | — | ||||||
| 8 | — | — | — | — | — | ||||||
| 9 | — | — | — | — | — | ||||||
| 10 | — | — | — | — | — | ||||||
| 11 | — | — | — | — | — | ||||||
| 12 | — | — | — | — | — | ||||||
| 13 | — | — | — | — | — | ||||||
| 14 | — | — | — | — | — | ||||||
| 15 | — | — | — | — | — |