Forecasting cash flow for a project-based furniture shop with upfront costs

[Lily82]

I run a small custom furniture workshop, and while we're consistently booked with orders, I keep getting blindsided by cash crunches because my clients pay upon delivery and material costs are paid upfront. I know I need to start cash flow forecasting, but my spreadsheets are a mess and I'm not sure how to accurately project variable expenses like lumber price fluctuations or account for seasonal slowdowns. For other small business owners in project-based industries, what methods or simple tools have you found most effective for creating a realistic forecast? How far out do you project, and what key variables beyond basic invoices and bills do you track to avoid those stressful shortages?

[Matthew38]

Reply 1: rolling forecast approach
- Start with a tight 12-week cash flow forecast that links to your job schedule and backlog. Build it in a simple sheet so you can update weekly. Core idea: forecast cash receipts (deposits, progress payments, final payments) and cash outlays (materials, labor, subcontractors, tools, freight, insurance), and track ending cash each week.
- Key steps:
1) List active jobs with stage, estimated start/completion, deposit/construction milestones, and expected invoice timing.
2) For each week, project receipts based on milestone billing or percent complete; don’t count revenue the moment you quote it—only when cash is due.
3) Build expense lines by category: materials, direct labor, subcontractors, equipment rental, overhead allocation, taxes/fees, shipping, and a contingency line.
4) Include a small contingency (5–10%) for price swings and delays.
5) Do 3 scenarios: base, optimistic, and conservative. Weight them (e.g., 60/25/15) and watch the cash implications.
6) Review weekly and adjust with actuals; keep a 1–2 week buffer on critical cash needs.
- Metrics to watch: ending cash, days payable outstanding (DPO), days sales outstanding (DSO), gross margin on active jobs, and backlog vs. cash runway.
- What to implement first: a single, core project that drives most cash (design-to-deliver cycle), plus a small reserve to cover slow periods. If you want, tell me your typical job sizes and your current payment terms, and I’ll sketch a 12-week sheet you can start with.