Billable dashboard for Foldline
Cash runway, next 13 weeks
Sent invoices, retainers and milestones against payroll, rent and freelancers. At the pace clients really pay, the 13 Nov payroll is $44,250 short. On time, the lowest point would be $43,750.
On paper
$166,838
Profit on live projects: $718,436 in fees earned less $551,598 of loaded cost.
In the bank
$71,850
Operating account, 9:00 today. Clients owe $434,600, and $167,400 of that is more than 30 days late.
Signed work only, no pipeline. Unsent drafts aren't counted until they go out. At the usual pace, $297,400 lands after 17 Jan.
Utilisation, October so far
76% of 2,246 capacity hours billed, 1–19 Oct (13 working days). Motion and development is under target. Omar 102%, Theo 98%: over 95%.
Brand design
82% · target 75%–85%
Theo 98% · Chloe 63%
Product design
82% · target 75%–85%
Omar 102%
Strategy and writing
79% · target 65%–80%
Motion and development
57% · target 75%–85%
Sophie 52% · Caleb 41%
Partners
63% · target 45%–60%
Hannah 76%
| Furthest from target | Role | Billable | Utilisation |
|---|---|---|---|
| Caleb Ward | Front-end developer | 43 of 104 h | 41% |
| Sophie Laurent | Motion designer | 54 of 104 h | 52% |
| Omar Haddad | Lead product designer | 106 of 104 h | 102% |
| Hannah Okafor | Partner, creative director | 79 of 104 h | 76% |
| Theo Nakamura | Senior brand designer | 102 of 104 h | 98% |
| Hannah Okafor | 76% |
| Marcus Lindqvist | 50% |
| Julia Moreno | 81% |
| Theo Nakamura | 98% |
| Ava Castellanos | 85% |
| Ben Adeyemi | 84% |
| Chloe Whitfield | 63% |
| Luis Ortega | 87% |
| Maya Goldberg | 78% |
| Grace Kim | 77% |
| Omar Haddad | 102% |
| Nora Feld | 83% |
| Ethan Walsh | 80% |
| Isabel Duarte | 74% |
| Kofi Mensah | 87% |
| Lily Chen | 69% |
| Rachel Stein | 83% |
| Jonah Price | 75% |
| Tessa Morgan | 79% |
| Diego Alvarez | 79% |
| Sophie Laurent | 52% |
| Caleb Ward | 41% |
Receivables by age
$434,600 owed across 9 clients. $167,400 is more than 30 days late, and Halden Outdoor alone owes $111,600.
- Current
- $126,800
- 1–30 days
- $140,400
- 31–60 days
- $37,200
- 61–90 days
- $97,200
- 90+ days
- $33,000
Ready to send
Drafts aren't in the cash forecast until they go out.
- Wellfield Health · Beta design handoff$42,000
- Oakum Coffee Co. · Final artwork$19,200
How late each client pays
Average days past the due date, last 12 months. The pink cash line uses these.
- The Marlowe Institute
- 55 days
- Halden Outdoor
- 41 days
- Wellfield Health
- 27 days
- Tern Money
- 24 days
- Quarry Labs
- 12 days
Project profitability
Cost is hours × each person's loaded rate; studio target is a 35% margin. Oakum Coffee Co. loses money at this rate. 3 more fixed-fee projects are over budget: Halden Outdoor (2%), Wellfield Health (28%), Tern Money (26%).
| Project | Fee | Cost so far | Done | Cost against fee (forecast pale) | Margin at finish | Status |
|---|---|---|---|---|---|---|
| Halden OutdoorBrand refresh · fixed fee | $186,000 | $142,080 | 78% | 2.1%$3,846 | Over budget | |
| Wellfield HealthPatient app redesign · fixed fee | $264,000 | $118,106 | 62% | 27.8%$73,506 | Over budget | |
| The Marlowe InstituteWayfinding and identity · fixed fee | $132,000 | $71,032 | 85% | 36.7%$48,433 | On budget | |
| Quarry LabsMarketing site · fixed fee | $96,000 | $30,964 | 55% | 41.4%$39,702 | On budget | |
| Oakum Coffee Co.Packaging system · fixed fee | $48,000 | $46,692 | 90% | −8.1%−$3,880 | Losing money | |
| Tern MoneyBudgeting app sprint · fixed fee | $64,000 | $19,018 | 40% | 25.7%$16,455 | Over budget | |
| Alder & Vine Wine Co.Label system and online shop · fixed fee | $156,000 | $3,756 | 4% | 39.8%$62,100 | On budget | |
| Tallow & FinchBrand retainer · retainer, $22,000 a month | $123,000 to date | $77,920 | month 6 | 36.7%$45,080 | On budget | |
| Kestrel BikesProduct retainer · retainer, $18,000 a month | $46,636 to date | $42,030 | month 3 | 9.9%$4,606 | Below target | |
| Live projects, to date | $718,436 earned | $551,598 | Profit on paper so far | $166,838 |
Pipeline and capacity, next 8 weeks
Signed work fills 75% of planned billable hours next week and 26% by 14 Dec. Even if every deal closes at its odds, about 184 hours a week sit unsold from 16 Nov.
| Likely work | Value | Odds | Starts |
|---|---|---|---|
| Quarry Labs, product app phase 270 h a week for 8 weeks | $72,000 | 75% | 9 Nov |
| Sable & Stone Hospitality, identity110 h a week for 12 weeks | $140,000 | 50% | 16 Nov |
| Greyhaven Books, rebrand65 h a week for 8 weeks | $58,000 | 60% | 7 Dec |
| Harbor Pediatrics, patient app140 h a week for 16 weeks | $210,000 | 30% | 30 Nov |
| Weighted value | $221,800 |