Coffee Shop Sales Forecast Template

Once your assumptions are in, the Monthly Forecast and Annual Summary populate automatically. Review the numbers month by month — they should look roughly like your recent actuals, with seasonal variation. Fall and winter months should show stronger espresso and hot drink revenue; summer should show a higher share of cold brew and iced drinks, plus potentially lower overall transaction volume depending on your location and foot traffic patterns. Adjust your mix percentages and seasonal traffic multipliers until the model reflects how your shop actually behaves.

A coffee shop sales forecast works differently from a generic revenue model because of how granular the revenue drivers are. Beverage cost runs 25–35% of drink revenue, so the mix between a $3.50 drip coffee and a $6.50 oat milk latte matters enormously to profitability — and your forecast should reflect that. Similarly, food attachment rate (the percentage of transactions that include a pastry or sandwich) can swing total revenue by 10–15% without changing customer count at all. Modeling these drivers separately gives you levers to pull, not just a number to stare at.