Antonios kitchen solution

The goal of this challenge was to find out how reservation data can be used to do guest predictions for restaurants.

Restaurants face a big problem, that they don't know how many guests are coming the next day or next week. This leads to different problems like:

  • Foodwaste
  • high personnel costs
  • unhappy customers

Our team tried to solve this problem by forecasting the amount of people for noon and evening for a restaurant located in Z├╝rich. This forecasts are afterwards displayed in an App for the kichen chef and the chef de service.

We took data from a reservation system as our brain how the demand was in the past. Together with influencing factors like holidays, weekdays, seasonality we calculated our forecasts. The output of those forecasts is being written in the API of Prognolite. The App, that we developed with an experienced designer connects to the Prognolite API calls the forecasts, weather icons and holidays and visualizes it. We found out that the predictions for the evening are much better than for noon and found the reason in employees who don't register all the walk-ins.

In addition we developed an ExcellPrediction prototype. The Prototype uses turnover data from the past year(s) to make a forecast for future sales, with respect to any relevant parameters such as weather or holidays. Based on the fact that turnover (daily revenue) is correlated (0.95) with table reservations and number of dishes sold, it can be used to make a prediction on how much food restaurant owner needs to buy for the next day, week or month. The model also uses rolling window to adapt the forecast to any new unexpected circumstances.

Team members:

Our App:


Edited content

19.02.2018 07:53 ~ oleg

Event finished

17.02.2018 15:30

Joined the team

17.02.2018 10:50 ~ Prognolite

Challenge posted

17.02.2018 10:50 ~ Prognolite

Event started

16.02.2018 08:30

Connect to our community on Mattermost | Twitter | Facebook

All attendees, sponsors, partners, volunteers and staff at our hackathon are required to agree with the Hack Code of Conduct. Organisers will enforce this code throughout the event. We expect cooperation from all participants to ensure a safe environment for everybody.

Creative Commons LicenceThe contents of this website, unless otherwise stated, are licensed under a Creative Commons Attribution 4.0 International License.

Open Food Hackdays Basel