How to Forecast Restaurant Revenue and Expenses

The Importance of Forecasting in Restaurants

Running a restaurant without a forecast is like cooking a large banquet without a recipe or headcount - you might pull it off, but you're leaving the outcome to chance instead of planning for it. Forecasting means estimating sales, costs, and profits for an upcoming period, so decisions are based on where the business is headed, not just where it's been. Many owners rely on gut feeling - ordering by instinct, scheduling based on last week's rush, or assuming next month mirrors this one. That works until it doesn't. A forecast replaces guesswork with a structured estimate built from historical trends, seasonality, and known upcoming costs, giving you a baseline to plan against and adjust as new information arrives. Forecasts also drive real decisions. Revenue projections shape staffing and purchasing - underestimate demand and you risk running short-staffed or out of key ingredients; overestimate it and you're stuck with excess labor and spoiled inventory. Forecasting expenses alongside revenue also helps you anticipate cash flow gaps, like a slow month where rent and supplier invoices come due before revenue catches up. Without forecasting, restaurants tend to overspend, get blindsided by cash shortfalls, miss seasonal opportunities, and struggle to tell early whether the business is on track - making growth and financing harder to plan for.

Gathering the Right Historical Data

Before you can forecast anything with confidence, you need a solid base of historical data to build on. Here's what to collect and why it matters. Start with your POS reports Your point-of-sale system holds the most valuable forecasting data you have access to. Pull it apart by - - Total sales by day, so you can spot your strong and weak days of the week - Sales by daypart (breakfast, lunch, dinner, late night), since demand patterns often differ sharply between them - Seasonal trends tied to weather, holidays, tourism, or local events The point isn't to stare at totals - it's to find repeatable patterns you can plan around, instead of assuming every day performs like an "average" day. Dig into your prime cost history Prime cost - food, beverage, and labor combined - is usually the biggest lever you can control in the business. Pull at least 6-12 months of data and track - - Food cost as a percentage of sales - Beverage cost as a percentage of sales - Labor cost as a percentage of sales Watch for direction, not just numbers. Is food cost drifting upward because of supplier pricing changes? Is labor cost spiking on specific days because of overscheduling? These trends are exactly what feeds into your cost forecasts later. Separate fixed costs from variable costs Not all expenses behave the same way, so don't treat them the same way in your records - - Fixed costs - rent, insurance, loan payments, salaried management pay - stay roughly constant no matter how busy you are - Variable and semi-variable costs - hourly labor, food and beverage costs, utilities, card processing fees - rise and fall with sales volume Clean, separated records (ideally straight from your accounting software or P&L) let you forecast each category the right way instead of lumping everything into one messy number. How much history is enough? A good target is 12 months of historical data. That's enough to capture a full seasonal cycle - slow months, holiday spikes, everything in between - without missing anything important. If you're newer and don't have a full year yet - - Use whatever months of data you do have - Fill the gaps with industry benchmarks for your restaurant type and region - Plan to revise your forecast more often until your own track record builds up The more complete and consistent your historical data, the more weight you can put on the forecast you build from it.

Forecasting Revenue Methods

Once your historical data is in order, the next step is turning it into an actual sales projection. There's no single "correct" method - most owners get the most reliable results by combining a few approaches and cross-checking them against each other. Covers x average check method This is the most straightforward starting point - - Estimate the number of covers (guests served) you expect per day or per shift, based on historical patterns - Multiply by your average check size (total sales / number of covers) - Adjust the average check for any planned menu price changes or shifts in menu mix This method works well when your covers and check averages are fairly stable and predictable. Seat turnover and capacity-based projections This approach starts from your physical capacity rather than past sales alone - - Number of seats x table turns per shift x average check size - Useful for modeling a new location, a new shift (like adding brunch), or the upper ceiling of what your space can realistically produce - Helps you sanity-check whether a revenue target is even physically achievable given your footprint and staffing Trend-based forecasting This method leans on the direction your numbers have already been moving - - Month-over-month growth rate - useful for short-term projections and catching momentum shifts early - Year-over-year growth rate - better for smoothing out seasonal noise and comparing like periods (e.g., this July vs. last July) - Best used when your business has at least a year or two of consistent sales history to draw a trend line from Adjusting for seasonality, local events, and day-of-week variance No forecasting method is complete without layering in the "known unknowns" that shift demand - - Seasonal patterns (patio season, holiday weeks, slow post-holiday months) - Local events (festivals, sports schedules, conventions, construction disruptions nearby) - Day-of-week variance (weekday lunch rush vs. weekend dinner surge) The core method gives you a baseline number; these adjustments are what make that number realistic rather than generic. In practice, most owners run the covers x average check or trend-based method first, then apply a seasonality and event adjustment on top before finalizing a monthly or weekly revenue projection.

Forecasting Variable Costs

Once you have a revenue projection, the next step is estimating the costs that move alongside it. Variable costs scale with volume, so they should be forecasted as a function of projected sales, not as flat dollar amounts. Food and beverage cost as a percentage of sales This is the standard way to project food and beverage expense - - Take your historical food cost percentage (food cost / food sales) and beverage cost percentage separately, since they usually behave differently - Apply that percentage to your projected sales for the period - Adjust the percentage up or down based on known changes - a new menu item with different margins, a shift toward higher-cost dishes, or negotiated pricing with suppliers Keep food and beverage cost percentages separate rather than blended. A shift in your sales mix (more entrees, fewer high-margin drinks, for example) can move your blended cost percentage even if nothing else changes. Labor cost scaling with projected volume Labor is trickier than food cost because it isn't purely variable - some of it is fixed (salaried managers) and some scales with volume (hourly staff). To forecast it - - Project hourly labor based on expected covers or sales volume per shift, using historical labor-to-sales ratios as a guide - Keep salaried and fixed labor costs separate, since they don't move with volume - Build in scheduling efficiency assumptions - a slow Tuesday shouldn't be staffed like a Saturday, and your forecast should reflect that The goal is a labor forecast that flexes with the sales forecast, not a static number carried over from last month. Accounting for supply price fluctuations and menu mix shifts Two factors can throw off even a well-built cost forecast if you don't account for them - - Supply price fluctuations - commodity costs (proteins, produce, dairy) can swing significantly throughout the year, so build in a buffer or check supplier pricing trends before locking in your food cost assumption - Menu mix shifts - if guests order more of your higher-cost items than usual (or you run a promotion that shifts ordering patterns), your blended cost percentage will move even if unit costs stay the same A good practice is to revisit your variable cost assumptions monthly, rather than setting them once a year and assuming they'll hold. Food and labor costs are usually the most volatile parts of a restaurant's P&L, so this is the category most worth double-checking as actuals come in.

Fixed and Semi-Fixed Costs

Variable costs get most of the attention because they're tied to daily decisions, but fixed and semi-fixed costs make up a large share of your total expense base - and they need their own forecasting approach since they don't move the same way sales-driven costs do. Rent, insurance, licenses, and loan payments These are typically the most predictable line items in your entire forecast - - Rent is usually contractually fixed, though watch for scheduled increases, percentage rent clauses tied to sales, or lease renewal dates coming up in your forecast period - Insurance premiums often renew annually and can be pulled directly from your policy documents - Licenses and permits are generally known well in advance, including renewal dates and fees - Loan payments follow a fixed amortization schedule, so these numbers should be exact, not estimated Because these costs are so predictable, they're a good place to build accuracy into your forecast with minimal effort - there's little excuse for guessing here. Utilities and maintenance (semi-variable behavior) These costs sit in a middle ground - not fully fixed, but not tightly tied to sales volume either - - Utilities (electricity, gas, water) tend to fluctuate with season (higher AC costs in summer, heating in winter) more than with sales volume directly - Maintenance and repairs are lumpy rather than steady - a walk-in cooler breaking down doesn't follow a predictable schedule For these, use a rolling average of past costs as your baseline, and add a contingency buffer for maintenance rather than assuming a flat monthly number. Equipment age and usage intensity are better predictors than sales trends here. Marketing and administrative overhead These costs are more within your control than the categories above, which makes them easier to plan but easier to overlook - - Marketing spend should be forecasted based on your actual planned activity (campaigns, promotions, agency retainers) rather than a vague percentage of sales - Administrative overhead accounting fees, software subscriptions, office supplies - is usually stable month to month and simple to project from recent actuals Building a realistic fixed-cost baseline Once each category is estimated, add them together to create your fixed-cost baseline for the forecast period. This baseline matters for a specific reason - it's the amount of revenue you need to cover before variable costs and profit even enter the picture. Many owners underestimate how quickly fixed costs accumulate, so it's worth stress-testing this baseline against a slow-sales scenario.

Building a Simple Profit & Loss Forecast

With revenue, variable costs, and fixed costs all forecasted separately, the next step is pulling them together into a single view - a projected profit & loss (P&L) statement. This is where the forecast becomes something you can actually use to make decisions. Structuring a monthly forecast template A simple forecast P&L should follow the same structure as your actual financial statements, so the two can be compared side by side later. At minimum, include - - Revenue (total projected sales for the month) - Cost of goods sold (food and beverage cost) - Labor cost (hourly and salaried) - Operating overhead (rent, insurance, utilities, marketing, admin) - Net profit (what's left after all costs are subtracted from revenue) Keeping the categories consistent with how you already track actuals means you won't have to reformat anything when it's time to compare forecast to reality. Calculating projected prime cost and profit margin Two numbers are worth calculating explicitly rather than leaving buried in the template - 1. Prime cost = COGS + total labor cost, expressed as a percentage of revenue. This is the single most important efficiency metric in the forecast, since it's usually the largest controllable cost category 2. Net profit margin = net profit / revenue. This tells you, in percentage terms, how much of every sales dollar is expected to fall to the bottom line Calculating these as percentages rather than just dollar figures makes it much easier to compare performance across months of different sales volume, and to compare against industry benchmarks for your restaurant type. Rolling forecasts vs. static annual budgets There are two common approaches to structuring the forecast over time, and they serve different purposes - - A static annual budget is built once a year and used as a fixed reference point - useful for setting overall targets and for lenders or investors who want a stable benchmark - A rolling forecast is updated monthly (or quarterly), always projecting a set number of months ahead based on the latest actuals - useful for staying responsive to real conditions rather than an assumption made a year in advance Many restaurant owners benefit from using both - a static budget as the annual target, and a rolling forecast layered on top to reflect what's actually happening as the year unfolds. The rolling version is what you'll lean on most for near-term decisions like staffing and purchasing.

Stress-Testing Your Forecast

A forecast built on a single set of assumptions tells you what might happen if everything goes roughly as expected. But restaurants rarely operate under "as expected" conditions for long - supply costs spike, a slow month arrives without warning, a nearby road closure kills foot traffic. Stress-testing means building alternate versions of your forecast so you're not caught off guard when reality diverges from the plan. Best-case, worst-case, and most-likely scenarios Rather than relying on one forecast, build three - 1. Most-likely scenario - your baseline forecast, built on realistic assumptions 2. Best-case scenario what the numbers look like if sales trend above expectations and costs stay controlled - useful for understanding your upside and planning for growth 3. Worst-case scenario - what happens if sales come in below projection and costs run higher than expected - this is the version that matters most for risk planning Running all three gives you a range rather than a single point estimate, which is a more honest reflection of how uncertain any forecast really is. Sensitivity analysis - what happens if sales drop 10%, or food costs rise 5% Beyond the three broad scenarios, it's worth testing specific variables individually to see how sensitive your profitability is to each one - - What happens to net profit if sales drop 10% but fixed costs stay the same? - What happens if food cost rises 5 percentage points due to supplier price increases? - What happens if labor cost creeps up 2 percentage points due to overscheduling or a minimum wage increase? This exercise often reveals which variable has the biggest impact on your bottom line. For many restaurants, a modest swing in labor or food cost percentage affects profitability more than a similar swing in sales volume, simply because those costs are harder to cut quickly once they've crept up. Building a cash buffer based on forecast volatility Once you understand your worst-case scenario and your most sensitive variables, you can size a cash buffer accordingly rather than picking an arbitrary number - - Look at how much your worst-case monthly net profit differs from your most-likely scenario - that gap is a reasonable estimate of the cash cushion you'd need to absorb a bad month without missing payroll or rent - Restaurants with more volatile sales (heavily seasonal, weather-dependent, or event-driven) generally need a larger buffer than those with steady, predictable demand - Revisit this buffer periodically, since it should grow or shrink as your forecast volatility changes over time Stress-testing doesn't make your forecast more accurate, but it does make it more useful - it shifts the conversation from "will this happen?" to "what do we do if it does?"

Turning Forecasts into Ongoing Decisions

A forecast that sits untouched after it's built isn't doing its job. The real value comes from treating it as a living reference point - something you check against reality regularly and use to actually steer decisions, not just a document you created once and filed away. Reviewing forecast vs. actual results monthly At the end of each month, pull your actual P&L and place it side by side with your forecast for that same period - - Compare revenue, COGS, labor, overhead, and net profit line by line - Calculate the variance for each - both in dollars and as a percentage - so you can see where the forecast held up and where it didn't - Look for patterns across multiple months rather than reacting to a single month's variance, since one-off events (a slow week from bad weather, a one-time repair) can distort a single month without reflecting a real trend This monthly discipline is what keeps your forecast grounded in reality instead of drifting further from it over time. Adjusting staffing, purchasing, and pricing based on variance Once you know where the forecast missed, use that information to make concrete operational adjustments - - If labor cost consistently runs higher than forecasted, revisit your scheduling assumptions or turnover-based staffing model. - If food cost is trending above projection, check whether it's a supplier pricing issue, portioning issue, or a shift in menu mix, and adjust your cost percentage assumption accordingly - If sales are consistently beating or missing your revenue forecast, update your baseline assumptions rather than continuing to measure against a number you now know is off The goal isn't to hit the forecast exactly every month - it's to use the gap between forecast and actual as a signal for what needs attention. Using forecasts to guide menu changes, expansion, or capital investment decisions Beyond month-to-month operations, your forecast is also a tool for bigger decisions - 1. Menu changes - model how a price increase or a new menu item is likely to affect your average check and cost percentages before rolling it out 2. Expansion - use your capacity-based revenue method to estimate what a new location or additional seating might realistically produce, rather than assuming it will simply replicate your current numbers 3. Capital investment - before taking on debt for new equipment or a renovation, forecast how the added cost (loan payment, depreciation, potential efficiency gains) affects your P&L and cash buffer Forecasting isn't a one-time exercise you complete and move past - it's an ongoing habit that gets more accurate and more useful the longer you keep at it. Owners who revisit and refine their forecast regularly tend to catch problems earlier and make more confident decisions, simply because they're comparing new information against a plan rather than starting from scratch every time.