Loading…
Every figure is traceable to time entries, rates, contracts and expenses
Retainer: monthly fee recognized for each completed month. At completion = fee × months in the measured contract term.
| Cost (direct) | ||
| Employee labor to date | Σ hours × hourly cost (salary + employer costs ÷ annual working hours × FTE) | $26,831 |
| Contractor cost to date | Σ hours × contractor hourly cost | $7,371 |
| Project expenses to date | Σ expenses tagged to this project | $0 |
| Direct cost to date | labor + contractor + expenses | $34,202 |
| Remaining labor | 130 h × $70/h blended cost of planned team | $9,054 |
| Remaining expenses | Owner's estimate | $0 |
| Forecast cost at completion | direct to date + remaining labor + remaining expenses | $43,256 |
| Revenue and margin | ||
| Earned revenue to date | monthly fee × completed months | $96,000 |
| Revenue at completion | monthly fee × months in term | $128,000 |
| Margin to date | (earned to date − direct cost to date) ÷ earned to date | 64.4% |
| Forecast margin at completion | ||
Applies to remaining work only
e.g. a contractor quote
| Measure | Current forecast | Scenario |
|---|---|---|
| Revenue at completion | $128,000 | $128,000 |
| Cost already incurred | $34,202 | $34,202 |
| Remaining cost | $9,054 | $9,054 |
| Blended remaining cost / hour | $70 | $70 |
| Forecast cost at completion | $43,256 | $43,256 |
| Profit at completion | $84,744 | $84,744 |
| Margin at completion | 66.2% | 66.2% |
| Gap to target | +21.2% | +21.2% |
| Revenue needed for target | $78,647 | $78,647 |
| Max remaining hours for target | 520 h | 520 h |
| (revenue at completion − forecast cost) ÷ revenue at completion |
| 66.2% |
| Work in progress (earned − invoiced) | earned to date − invoiced to date | −$16,000 |
Measured from Apr 1, 2026. Estimate last updated Oct 2, 2026 (3 days ago). Source: ClickUp (simulated) · estimates
| Item | Type | Hours | Value at bill rates |
|---|---|---|---|
| Hours above the 75 h/month included in the retainer | Retainer overage | 42 h | $6,054 |
| Month | Hours | Overage |
|---|---|---|
| Apr 2026 | 76 h | 1 h |
| May 2026 | 77 h | 2 h |
| Jun 2026 | 93 h | 18 h |
| Jul 2026 | 80 h | 5 h |
| Aug 2026 | 92 h | 17 h |
| Sep 2026 | 75 h | — |