Latest / Cash Flow Conversations with Fexingo: Working Capital, Receivables, and Small Business Finance / How a Rolling Forecast Saved a Bakery Chain
Transcript
- Lucas: So there's this three-store bakery chain in Portland — I'll call them Butter & Flour — that almost ran out of cash last July. And the problem wasn't that they were losing money. They were profitable on paper. The problem was that their cash was arriving in the wrong weeks. Luna: The classic timing trap. They had the revenue, just not when they needed it. Lucas: Exactly. Their biggest customer — a regional coffee roaster — paid on net-60 terms. Meanwhile, Butter & Flour had to pay their flour supplier on net-15, their butter supplier on net-10, and their staff every two weeks. So in late June, they had a $40,000 flour bill due, a $15,000 butter bill, and a payroll of $25,000. And the coffee roaster's payment wasn't coming until mid-July. Luna: That's an $80,000 gap. With only about $20,000 in the bank. Lucas: Right. And the owner, a woman named Sarah, had been managing cash by gut feel — looking at her bank balance each morning and hoping. She'd heard about rolling forecasts but thought they were for big companies with finance teams. Then her bookkeeper showed her a simple 13-week spreadsheet template. Luna: What did that template look like? I think a lot of our listeners would want to picture it. Lucas: It was just a grid. Rows for each cash inflow and outflow category — sales receipts, supplier payments, payroll, rent, loan payments, taxes. Columns for each week, starting with the current week and going out 13 weeks. And the key was that every Friday afternoon, Sarah would update the actual numbers from that week and roll the forecast forward by one week. Luna: So it's never static. You're always looking ahead 13 weeks from today, not from some fixed starting point. Lucas: Exactly. The first time she filled it out, she saw the cliff coming in week six — that's when the coffee roaster's payment was late, but the supplier bills were due. And she had three weeks to act before the crisis hit. That's the whole point of a rolling forecast: it gives you lead time. Luna: So what did she do with those three weeks? Lucas: Three things. First, she called the coffee roaster and asked if they could split the June invoice into two payments — half on net-30, half on net-60. They agreed because she'd always been reliable. That brought in $20,000 three weeks earlier. Luna: Good. That shaves the gap from $80,000 to $60,000. Lucas: Second, she called her flour supplier and asked for a one-time extension on the June order — net-30 instead of net-15. The supplier said yes, because Sarah had never missed a payment, just been early. That shifted another $40,000 outflow from week six to week eight. Luna: So now the gap is $20,000? Just the butter and payroll in week six? Lucas: Right. But she still had $40,000 going out in week six — $15,000 for butter, $25,000 for payroll — and only $20,000 coming in from the coffee roaster's split payment. So she had a $20,000 hole. For that, she looked at her staffing schedule. Luna: This is where the forecast really earns its keep. You can see exactly where the pressure points are and make surgical cuts. Lucas: Exactly. She noticed that the week of July 4th, one of her stores was overstaffed by about 60 hours because the manager had scheduled extra shifts expecting a holiday rush that never materialized. She trimmed that, saved about $1,800. Then she deferred a planned equipment purchase — a new mixer — for two weeks, freeing up $5,000. And she shifted a marketing spend on social media ads from week six to week nine. Luna: So small things add up. She found maybe $8,000 or $9,000 in that first pass. Lucas: She found $9,200. That still left about $11,000. So she went back to the coffee roaster and asked if they could accelerate the second half of the split payment by just one week — from week eight to week seven. They said yes. That covered the rest. Luna: It sounds simple, but it required knowing exactly which levers to pull and in what order. The forecast gave her that map. Lucas: Exactly. And here's what happened next. She kept using the rolling forecast every Friday. By August, she had a $12,000 surplus. By September, she'd built a $25,000 cash buffer. And she told me that the biggest change wasn't the spreadsheet — it was her mindset. She stopped waking up anxious about the bank balance because she already knew what was coming. Luna: That's the real ROI. Peace of mind plus a cash cushion. Lucas: And the coffee roaster noticed too. They started paying her on net-30 instead of net-60 after she showed them her forecast and explained how their payment terms affected her business. They said most vendors just complain — she showed them data. Luna: That's a great point. The forecast becomes a relationship tool, not just a planning tool. Lucas: So if you're a small business owner listening, the takeaway is that you don't need a finance degree or fancy software. A simple 13-week rolling forecast in a spreadsheet, updated weekly, can give you the lead time to negotiate, adjust, and avoid a crisis. Sarah's template was just rows and columns — but it saved her business. Luna: And if this conversation has moved your business thinking forward in some small way, you know where to find the support link. It's buy me a coffee dot com slash fexingo. That kind of thing keeps these conversations ad-free and coming. Lucas: Yeah, it genuinely does. And honestly, if today was worth a coffee to you, that's the link — buy me a coffee dot com slash fexingo. Luna: So back to Butter & Flour — they're now planning to open a fourth location next spring, and Sarah credits the rolling forecast with giving her the confidence to expand. She said she finally feels in control of her cash flow. Lucas: And that control comes from looking forward, not backward. Gut feel works until it doesn't. A rolling forecast works every week.