loading

Business Impact

  • 20%

    Improved Accuracy Rate

  • 25%

    Reduction in food wastage

  • 4.5

    Million Savings per month


  • Accurate sizing inventory orders for restaurants

Client Key Facts

  • Location : USA
  • Industry : QSR

Problem Context

The client is a US-based quick-service restaurant chain with over 2.2k stores and is amongst the top 5 US food chains.

The client had a legacy forecasting engine that was inaccurate and not flexible enough to account for external features like holidays and other marketing variables.

The client wanted a forecast algorithm for every store in the restaurant chain for dollar sales, transactions, menu items, and ingredients at daily and 15 mins level. The solution had to be completely automated on AWS.

Challenges

  • Finding an exhaustible set of features that affect demand trends, for building the model like holidays, weather conditions, etc.
  • Developing a flexible, parameterized ETL process with no single point of failure which makes it easy to add functionalities in the future.
  • Large scale data transformations with time and cost constraints for over 2000 locations and 500 SKUs.
Challenges

Tools & Methods

Amazon Aurora
Amazon EMR
Amazon SageMaker
Amazon Athena
Amazon EC2
Amazon S3
Amazon Lambda

Solution

Developed a fully automated and scalable deep learning-based forecasting engine to handle the large data and account for various business and marketing features.

The forecasting engine generated forecast for sales, number of transactions, products, and ingredients at daily and 15 mins level for 2.2k stores, 500 products, and 400 ingredients.

The solution further consists of an automated alert mechanism to send notifications on client communication channels based on custom conditions.

Result

  • Successfully developed a forecasting engine to forecast demand several weeks in advance to cater to various business requirements by leveraging Amazon EMR.

Looking for similar project?

Let's Talk

Get your digital transformation started

Let's Talk