Framework OPS — Sample Demo
13-Week Rolling Cash Flow Forecaster
Northside Roofing Co. · Trailing 12 months · $5.2M revenue · 22 employees · Residential + storm
Your cash position, 13 weeks out. Try the demo move: bump Starting cash up to $250,000 and watch the whole model flood green. That is the difference between flying blind and seeing the wall before you hit it.
Starting cash
$
Min threshold (red below)
$
Comfort target (green above)
$
Weeks below threshold
4 red · 9 yellow · 0 green
Lowest week: $57,200
13-Week Forecast
Blue cells are editable. Ending cash recolors against your threshold and target.
| Line | Wk 1 5/25 | Wk 2 6/1 | Wk 3 6/8 | Wk 4 6/15 | Wk 5 6/22 | Wk 6 6/29 | Wk 7 7/6 | Wk 8 7/13 | Wk 9 7/20 | Wk 10 7/27 | Wk 11 8/3 | Wk 12 8/10 | Wk 13 8/17 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Beginning cash | $95,000 | $76,100 | $91,800 | $70,000 | $101,700 | $80,500 | $98,300 | $66,500 | $80,100 | $57,200 | $83,900 | $74,900 | $120,800 |
| CASH IN | |||||||||||||
| AR collections — retail | |||||||||||||
| AR collections — insurance/storm | |||||||||||||
| Job deposits collected (new sales) | |||||||||||||
| Other (rebates, refunds) | |||||||||||||
| Total cash in | $74,000 | $76,000 | $81,000 | $96,500 | $88,000 | $74,000 | $62,000 | $53,000 | $71,000 | $88,000 | $103,200 | $109,000 | $100,000 |
| CASH OUT | |||||||||||||
| Payroll (gross + taxes) | |||||||||||||
| Material AP — supplier 1 | |||||||||||||
| Material AP — supplier 2 | |||||||||||||
| Subcontractor payments | |||||||||||||
| Rent + utilities | |||||||||||||
| Insurance (GL + WC) | |||||||||||||
| Marketing | |||||||||||||
| Software / SaaS | |||||||||||||
| Owner draw | |||||||||||||
| Vehicle/fuel/tools | |||||||||||||
| Other (taxes, misc) | |||||||||||||
| Total cash out | $92,900 | $60,300 | $102,800 | $64,800 | $109,200 | $56,200 | $93,800 | $39,400 | $93,900 | $61,300 | $112,200 | $63,100 | $108,100 |
| Net cash flow | $-18,900 | +$15,700 | $-21,800 | +$31,700 | $-21,200 | +$17,800 | $-31,800 | +$13,600 | $-22,900 | +$26,700 | $-9,000 | +$45,900 | $-8,100 |
| Ending cash | $76,100 | $91,800 | $70,000 | $101,700 | $80,500 | $98,300 | $66,500 | $80,100 | $57,200 | $83,900 | $74,900 | $120,800 | $112,700 |
Red = below minimum threshold — you need cash interventions this week. Yellow = between threshold and comfort target — watch the next two weeks. Green = above target. Update the blue cells weekly with actuals and the model rolls forward automatically.