Restaurant Management System

Project Overview

Description: 
The solution is a cloud-based Restaurant Management System that provides restaurant owners and managers with real-time insights into their business. Through data-driven dashboards and reports, RMS integrates seamlessly with POS, labor management, and reservation systems to deliver a comprehensive view of daily operations and performance metrics.

Project goal: 

The goal of RMS is to streamline restaurant management by consolidating crucial data into easy-to-read dashboards, enabling better decision-making and improved financial oversight. It offers detailed analytics and forecasting to optimize costs, improve revenue, and enhance overall efficiency.

How it works: 

RMS connects with third-party systems to aggregate data on sales, labor, and customer feedback. This data is processed and displayed through various dashboards and widgets, covering metrics like sales trends, labor costs, check averages, and COGS. Users can also generate reports, track labor costs hourly, and manage categories for sales and purchases within the app.

Who can use: 

RMS is designed for restaurant, café, and bar owners, as well as managers who need to monitor performance and make data-driven decisions. It’s ideal for businesses looking to integrate cryptocurrency payments, and also benefit from labor and sales forecasting.

Use case: 

A restaurant manager logs into RMS to view real-time sales and labor costs throughout the day. With rising lunch-hour demand, they use the labor tracking module to adjust staffing levels, ensuring efficient service and cost control. At the end of the month, they generate a sales report, comparing actual sales against budget projections to plan more accurately for the following month.

Technical challenges and solutions:

Report module: 

The process of generating a report includes gathering and aggregating sales and Labour information by a select date range. The report also has a Sales vs. Budget bar chart and sales mix pie charts, which improve the readability and perception of information. We have implemented an interface for generating sales reports for the chosen period with the opportunity to preview and save them as pdf.

Dashboard values calculation:

The dashboard consists of information about the current situation of certain aspects of the restaurant. All dashboards have a manual entry field which influences the dashboard calculating data. We used the daily data about sales and Labour to update month-to-date restaurant stats. And we computed dashboards values using unique formulas with month-to-date restaurant stats.

Labour Tracking:

Labour tracking is an app module that allows you to discover labor costs for every hour. The restaurant manager uses this information to better distribute the required labor at the current moment for proper budget management of the present day. We implemented a module where users can observe the latest update of the Labour in the restaurant. After the restaurant opening, we update data about the restaurant situation every hour until the restaurant is closed.

Sales/Purchases categories: 

Sales/Purchases dashboard stores data about specific sales/purchase categories. The user has the opportunity to re-order categories and choose what categories to display in the dashboard. We implemented a manage category module for each restaurant, where users can rearrange category options(ordering, displaying in the widget, update, create, delete).

Copy & Paste module:

The Copy & Paste module allows users to add daily sales and labor stats to the app. We implemented the form for manual entry daily stats and also a feature that allows copy data from excel/google spreadsheet and separately pasting in every field in our form.

Technologies

Python, Django, Docker, Celery, Digital Ocean, PostgreSQL.