Sales forecasting for restaurants: how Tenzo is shaping the future

2020 has certainly been unprecedented, but the Tenzo team has been hard at work perfecting the tools that make running restaurants more efficient in these trying times. The pandemic has accelerated corporate digital transformation and enhanced the importance of analytics tools in the hospitality sector. More than ever, restaurants need to be able to access their data and insights, as sales become more volatile.

On the flipside, in a recent report, Bain & Company listed technologies that work towards zero food waste as one of the key trends for 2021. “Using technology to reduce waste could put a significant dent in the food discarded by retailers and businesses, increase food security, and alleviate the suffering of the hundreds of millions of people who go to bed on an empty stomach”.

In the UK alone, food waste contributes to £3.2 billion in lost revenue for restaurants and 4.5 million tonnes of CO2 emitted. Our new project is set to change that.

We’re very excited at the prospect of partnering with Innovate UK to help the hospitality industry save over £100m in food waste by 2025. As a business, Tenzo is committed to helping restaurateurs survive this challenging period with the help of accessible data and accurate forecasts. In this post, we will share some of our initial findings and also invite you to become part in our food waste reduction journey.

The project

Through effective food waste reduction, restaurants can boost their profitability, while drastically reducing the environmental impact of their operations.

The key to reducing food waste lies in accurate sales forecasting. Restaurants order their perishable inventory days and weeks before selling dishes to their customers. Given that most restaurants rely on rigid 4-week demand averages and gut instinct to make their procurement decisions, food orders are routinely in excess of real demand - creating food waste.

Our project will focus on finding the most accurate forecasting algorithms and combining them with a user-friendly software interface to ensure frontline workers are empowered to reduce food waste in their day-to-day operations.

Variables for demand forecasting

With the understanding of how critical demand forecasting is for efficient restaurant operations, we started to investigate the different variables that can be used as predictors for forecasts.

Customer demand can vary by time of the year, weekday, weather conditions, promotions, etc. In our research, we identified 12 different categories that are useful in predicting that demand.

Different data types influence restaurant demand

A time series is a sequence of numerical data points in a successive order associated with a time mark. Forecasting, at its core, is a time series problem where given a set of data in time we want to predict the dynamics of the same dataset in the future. For example, if we consider the revenues of a restaurant, we need historical observed revenues to "train" the forecasting algorithm.

Today, businesses try different processes to predict demand: from simple spreadsheets to complex forecasting software and models. But an accurate output could still be out of reach for two reasons.

A major challenge is incorporating large volumes of historical data. Missing relevant data from the past can lead to significant mistakes. An extensive historical dataset is particularly important to prepare for the new normal due to the COVID-19 pandemic. Understanding how the pandemic is affecting your sales and comparing it to the pre-COVID-19 period to predict the new normal will be essential.

The second challenge in forecasting is incorporating other contextual factors and relating it to the patterns observed in the time series datasets. When the forecasting output is too high, it may lead to over-staffing, excessive inventory purchasing and food waste. On the other hand, if the forecasting is too low, restaurants lose sales opportunities and customers are left unsatisfied.

The other inputs included in the figure above are external factors that could be beneficial for the forecasting process:

  • Weather conditions: Temperature, rainfall level, snowfall level, hours of sunshine. Extreme weather can have huge effects on restaurant forecasts and longer days of sunshine might increase demand;

  • Events and holidays: Public, school and religious holidays. They can also have a positive or a negative impact on your demand. If your restaurant is in a business area, you might see your demand drop on a bank holiday;

  • Reservations and bookings: checking the influence of bookings can help you align your inventory and staff with the number of reservations;

  • Traffic data: traffic congestions and public transportation data (e.g. TfL in London). A planned road closure could drive less footfall for that period of time, particularly in bakeries/restaurants on motorways;

  • Demographics: customers’ age for example, can be useful for predictions by time of the day;

  • Promotions: it is expected that footfall will rise when you run promotions in your restaurants;

  • Footfall data: these can be collected by WiFi, bluetooth or computer vision and be used as a proxy for real time customer demand along with sales;

  • Location type: restaurants located on streets and on shopping malls might have different demand profiles;

  • Social Media: can impact positively or negatively the demand, given the restaurant star rating and recent reviews;

  • Competition: competitive promotions or the number of restaurants in the surrounding area affect your demand;

  • Macroeconomic indicators: unemployment rate, inflation and other factors from the local population can also influence the forecasted outcome.

In this blog post, we have discussed how some of these factors play a role in forecasting and some tips for improving your sales forecasting process.

What's next?

With the disruption caused by COVID-19, restaurants need to rethink their internal processes. “Data-obsession” allows restaurants to become more efficient in resource allocation and brings in more automation to their operations.

Want to get involved?

We’re looking to put together a Customer Research Panel in 2021 to bring together Tenzo customers who use our existing planning module, along with restaurants who don’t use it, to help us better understand first hand the challenges customers face when forecasting sales. If you are interested in joining, send an email to forecasting@gotenzo.com by January 22nd 2021 so we can include you in the next exploratory session.

Cover photo by Jakub Kapusnak on Unsplash

Posted in Forecasting, Tenzo

Maury Ueta

Written by Maury Ueta