Latest / Cash Flow Conversations with Fexingo: Working Capital, Receivables, and Small Business Finance / How a Restaurant Cash Flow Dashboard Cut Food Waste 15 Percent
Transcript
- Lucas: So Luna, I was talking to a restaurant owner in Portland last week. She runs a 60-seat Italian place, and she told me something wild: she was literally throwing away fifty thousand dollars a year in unused ingredients. Not because the food was bad — because she had no idea what her cash flow was telling her about her inventory. Luna: Fifty thousand dollars. That's like... a full-time employee's salary, just in the trash. How do you not notice that? Lucas: That's exactly what I asked her. And she said, 'I was so focused on revenue — covers per night, average ticket — I never looked at the cost side week to week. I knew food cost in the abstract, but I wasn't tracking it against what we actually used.' So she built a simple cash flow dashboard. I want to walk through how it changed everything. Luna: Okay, I'm all ears. What was on this dashboard? Lucas: She started with three metrics: weekly cost of goods sold, or COGS, as a percentage of revenue; inventory turnover rate; and a line item for 'waste' — meaning anything that got thrown out or composted. She plotted them on a single chart every Friday afternoon. It took her maybe fifteen minutes. Luna: And that was enough to find the fifty thousand dollars? Lucas: Not immediately. The first month, the dashboard showed that her COGS was running at 38 percent of revenue. Industry standard for Italian is closer to 30. That's a red flag. Then she looked at inventory turnover — her pasta ingredients were sitting in the walk-in for twelve days on average before being used. For fresh ingredients, that's basically a guarantee of spoilage. Luna: So the dashboard forced her to ask: what menu items are driving this? Lucas: Exactly. She ran a profitability analysis on each dish. Found three items — a stuffed chicken special, a seafood pasta, and a certain dessert — that had waste rates over 20 percent. Those three dishes accounted for about forty percent of her total food waste. She didn't need to cut them entirely, but she needed to adjust. Luna: What did she do? Change the recipes? Lucas: Partly. For the chicken special, she switched to a different cut that was cheaper and didn't spoil as fast. For the seafood pasta, she started using frozen shrimp instead of fresh — the flavor was fine, but the shelf life went from two days to six months. That alone cut waste on that dish by sixty percent. Luna: And the dessert? Lucas: That one was interesting. It was a tiramisu that used mascarpone cheese. She was buying it in bulk because it was cheaper per ounce, but she couldn't use it all before the expiration date. She switched to buying smaller quantities more frequently, even though the unit cost was slightly higher. The net effect? She cut waste on that ingredient by forty percent, and the total cost actually went down because she wasn't throwing half of it away. Luna: So the dashboard helped her see the hidden cost of bulk buying. That's the kind of insight you don't get from a P&L statement at the end of the year. Lucas: Right. And then she took it a step further. She started negotiating with her suppliers based on the dashboard data. She showed her produce vendor that she was wasting thirty percent of the arugula she bought because it was wilting in three days. She asked for smaller, more frequent deliveries — and the vendor agreed because he didn't want to lose a steady account. That cut the arugula waste to under ten percent. Luna: That's a great example of using cash flow data to improve operational decisions. And the total savings? Lucas: She tracked it for a full year after implementing the dashboard and the changes. Food waste dropped by fifteen percent year-over-year. That fifty thousand dollar loss became about seven thousand five hundred dollars. She saved forty-two thousand five hundred dollars annually. And the dashboard now takes her ten minutes a week. Luna: It's amazing how a simple tool can make such a difference. And honestly, that kind of story is exactly why we do this show — to share these practical tools. Lucas: Yeah, if you're getting value from these conversations, consider supporting the show at buy me a coffee dot com slash fexingo. It helps us keep it ad-free for entrepreneurs who are bootstrapping and need this kind of data-driven advice. Luna: Absolutely. Even a small contribution goes a long way to keep these episodes coming. Lucas: Anyway, back to the dashboard — the key feature was a real-time view of the cost of goods sold versus revenue. She also added a column for 'expected waste' based on her portion sizes, so she could see the variance. Luna: That's brilliant. It turns waste from a vague problem into a measurable metric. What about the other side of cash flow — like receivables? Did she have any issues there? Lucas: She did. She had a small catering side, and some corporate clients were paying in 60 days. That stretched her cash flow, especially during the slow winter months. So she used the same dashboard approach — she added a line for 'days sales outstanding' by customer. Once she saw that one client was consistently paying 75 days, she offered them a 2 percent discount for paying within 15 days. They took it, and her receivables cycle shortened by 18 days. Luna: All from a simple dashboard. I love that she didn't need expensive software. A spreadsheet and a weekly habit. Lucas: Exactly. And that's the takeaway for any small business owner. You don't need a complex ERP system. You need to pick three to five numbers that drive your cash flow, track them consistently, and act on what they tell you. For this owner, it was COGS percentage, inventory turnover, and waste rate. For others, it might be receivables aging, cash conversion cycle, or gross margin by product. Luna: So if someone listening wants to start, what's the first step? Lucas: Identify your biggest cash flow drain. It could be inventory, slow-paying customers, or overhead. Then pick one metric that measures that drain. Track it weekly for a month. You'll almost certainly find an opportunity. The restaurant owner found a forty-two thousand dollar opportunity in just one metric. Luna: And if you're not sure what to track, I'd recommend starting with your cash conversion cycle: how long from paying for inventory to collecting cash from customers. That single number reveals a ton about your working capital efficiency. Lucas: Great point. For the restaurant, her cash conversion cycle was about 35 days before the dashboard. After reducing waste and tightening receivables, it dropped to 22 days. That means she freed up more than two weeks' worth of operating cash. Luna: So the dashboard didn't just save money; it improved liquidity. That's the real win. Lucas: Exactly. And the owner told me she sleeps better now. She used to worry about making payroll during the slow season. Now she has a rolling 13-week cash flow forecast built from the dashboard data. She knows three months ahead if she'll need a line of credit. Luna: That's the kind of control that transforms a business. Great episode, Lucas. Lucas: Thanks, Luna. Next week we'll look at how a bookstore used cash flow to decide when to expand.