![case study](https://cdn.quantiphi.com/2024/03/27eb770a-banner.png)
Enterprise Forecasting Engine
QSRBusiness Impacts
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.
![](https://cdn.quantiphi.com/2024/03/d5862b3a-challenge-3.png)
Tools & Methods
![Amazon Aurora](https://cdn.quantiphi.com/2024/02/4cf9c3f7-amazon-aurora-1.png)
Amazon Aurora
![Amazon EMR](https://cdn.quantiphi.com/2024/02/4e190ceb-amazon-elastic-mapreduce-emr.png)
Amazon EMR
![Amazon SageMaker](https://cdn.quantiphi.com/2024/02/50f0a997-arch_amazon-sagemaker_64@5x-1.png)
Amazon SageMaker
![Amazon Athena](https://cdn.quantiphi.com/2024/02/Amazon-Athena_light-bg@4x.png)
Amazon Athena
![Amazon EC2](https://cdn.quantiphi.com/2024/02/Amazon-EC2_light-bg@4x.png)
Amazon EC2
![Amazon S3](https://cdn.quantiphi.com/2024/02/9c40e5d8-amazon-s3.png)
Amazon S3
![Amazon Lambda](https://cdn.quantiphi.com/2024/02/83e09c49-aws-lambda.png)
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.