Restaurant Revenue Forecasting: Turn Reservations into Profit

Restaurant Revenue Forecasting: Turn Reservations into Profit

It is 10:00 AM on a Tuesday. Your Head Chef is currently at the market, deciding how many kilos of Sea Bass to buy for the weekend. Your Floor Manager is finalizing the roster, deciding if she needs 4 servers or 6 for Friday night.

What is the reason behind these decisions? Most would probably say “Gut Feeling.”

They remember that last Friday was busy, so they buy extra fish and prepare more staff for this weekend. But they totally forget that last Friday was a payday weekend, and this Friday is a long weekend that people tend to leave town.

That results in over-ordering that leads to food waste, or over-staffing that leads to wasted wages.

In 2026, where margins are thinner than ever, keep guessing might cost you a fortune. By accurately forecasting, you will likely increase your chances of survival. The secret is sitting right in your reservation book.


The "Rollercoaster" Cycle

The Thai market is uniquely volatile. Unlike Western markets where demand is relatively flat, Thai restaurants face extreme fluctuations based on:

  1. The "Payday Effect": Revenue can double between the start and end of the month.
  2. Weather: A heavy rain can kill traffic instantly.
  3. Festivals: Songkran, Jay Festival, and Loy Krathong drastically shift what people tend to eat and when.

The Financial Impact

If you forecast incorrectly, you lose money in two ways:

  • The Cost of "Too Much": You prepped for 100 covers, but only did 60. You throw away perishable ingredients and pay 3 staff members to stand around playing on their phones.
  • The Cost of "Too Little": You predicted a quiet night, but a group of 20 walked in. You ran out of your signature dish very quickly and service was slow because you were understaffed. You saved 500 THB on labor but lost 5,000 THB in total sales and damaged your reputation.

Data-driven forecasting bridges this gap. It allows you to align your Variable Costs with your Expected Revenue.


The Forecasting Formula

You don’t need to hire a fortune teller to forecast. You only need to understand core metrics that you get from your reservation system.

1. The Core Metrics

  • ROH (Reservations on Hand): How many bookings do you effectively have for a specific future date?
  • Average Ticket Size (ATS): What is the average spend per head? (e.g., 800 THB for dinner).
  • Walk-in Ratio: What percentage of your revenue usually comes from walk-ins vs. bookings? (e.g., 40% bookings / 60% walk-ins).

2. The Calculation

Let’s forecast revenue for next Saturday.

  • Step A: You currently have 40 guests booked.
  • Step B: Your historical data shows that by Saturday, you usually pick up another 20% in late bookings. Projected Bookings = 48 guests.
  • Step C: Your Average Ticket is 1,000 THB.
  • Step D: Your Forecasted Booking Revenue = 48,000 THB.
  • Step E: Apply the Walk-in Ratio (if you are usually 50/50).
  • Total Forecast: 96,000 THB.

3. Understanding Pace

Pace is the speed at which bookings fill up.

  • Healthy Pace: You are 40% booked 7 days out.
  • Alarming Pace: You are 10% booked 7 days out.

If you track Pace 7 days before, you can react before the slow night happens. If Pace is slow for next Tuesday, you don't just accept it—you should launch a promotion to fill those seats immediately.


From Data to Action

Knowing the data alone is not enough if you don’t know how to act on it. Here is how to implement forecasting in your weekly routine.

The "Tuesday Review"

Every Tuesday, sit down with your Chef and Manager. Look at the "Reservations on Hand" for the upcoming weekend.

  • High Forecast? Hire more staff for that specific shift or ask your part-time staff to come on that day. Order extra ingredients.
  • Low Forecast? Cut 1 kitchen staff and 1 floor staff from the roster. Run a "Free Dessert" promo for bookings made within 24 hours.

Segment Your Customers

Not all bookings are the same.

  • Tourists: Might order drinks + appetizers + mains (High ATS).
  • Office Workers (Lunch): Quick single dish + water (Low ATS).
  • VIPs: Wine drinkers (Very High ATS).

Tag guests in your system. If you see next Friday is fully booked, but it's mostly "Office Lunch" profiles, your revenue will be lower than if it were "Tourists" or “VIPS.”  Adjust your forecast according to this data.

Late Arrivals & No-Shows

You will face late arrivals and no-shows in Thailand. So you must have a plan for them.

  • The No-Show Allowance: Always subtract 10% from your booking forecast to account for cancellations unless you take a deposit.
  • The Overbook: If you know you have a 10% no-show rate, it is safe to overbook your floor by 5-10% to maximize revenue as airlines do.


Forecasting in the Real World

The "Rainy Season" Rooftop Bar

  • Context: A rooftop bar relies on outdoor seating.
  • Data: The manager sees 80 bookings for Friday. The forecast looks great.
  • Insight: The weather forecast predicts a 90% chance of rain.
  • Action: She recalculates the forecast down. She cancels 2 part-time staff shifts on Wednesday to save costs and reduces the fresh fruit order for cocktails to reduce waste.
  • Result: The rain comes as predicted. Revenue is low, but profit margin is protected because costs were cut in advance.

The "Payday" Illusion

  • Context: An Izakaya.
  • Data: It is the 25th of the month. Bookings are light.
  • Insight: Thai office workers often decide to go out on the day of payday. Historical data shows a 300% spike in walk-ins on Payday Fridays.
  • Action: Using historical trends, the owner ignores the low booking count and staffs up fully.
  • Result: The restaurant is slammed with walk-ins. Service is smooth because the team was ready for it.


Advanced Metrics for Growth

  • RevPASH (Revenue Per Available Seat Hour):

Don't just look at "Total Revenue." If you made 10,000 THB between 6 PM and 7 PM, but you have 100 seats, your RevPASH is only 100 THB. If you can use forecasting to turn tables faster during peak hours, you increase this number without adding more seats.

  • Tagging is Everything:

You cannot forecast accurately if your data isn’t clean. Train your staff to tag every reservation: Birthday, Anniversary, Corporate, Regular. A "Corporate" group of 10 pax spends very differently from a "Student" group of 10 pax.

  • Automated Reporting:

If you are using Excel to do this, you will eventually burn out because it's too hard. You need a system that visualizes this for you.

How Aroi Enhances Forecasting

This is where the Aroi Dashboard becomes your analytic partner. Aroi centralizes the metrics that actually matter for planning, allowing you to see:

  • Actionable Metrics: Instead of just counting heads, Aroi helps you track No-Show Percentages and Revenue Per Cover. This lets you adjust your "No-Show Allowance" based on real data, not your gut feeling.
  • Guest Insights (CRM): The system automatically builds guest profiles with spending history. You can see if Friday’s bookings are high-spending VIPs or first-timers, helping you to forecast revenue more accurately.
  • Exportable Data: Need to plan purchasing? One-click export allows you to share data with your team instantly, ensuring your stock levels match your reservations.


Stop Reacting, Start Predicting

Great food helps fill the seats, but in the low-margin world of Thai F&B, only owners who can manage their costs wisely survive.

Revenue forecasting is the difference between a chaotic, wasteful night and a smooth and profitable one. Just by using the data you already have, you can stop relying on your gut feeling and start making decisions the way you should.

Look at your reservation book for 7 days from now. Calculate your estimated revenue. Then, ask your Chef if his order list matches that number. If not, you have work to do.