Restaurant Group Uses RPA
for Inventory Auditing

In this case study, we’ll look at how Smartbridge used robotic process automation to help a restaurant group with inventory auditing and record classification.

The Client

Our client is a company that owns, operates, and franchises two well-known restaurant brands. The brands specialize in the operation of fast casual/quick service restaurants that offer distinct and unique flavors with broad appeal at a compelling value. The brands specialize in fresh-made cooking, drive-thru service, and catering.

The Primary Objective/Problem

Like many restaurant organizations, our client relied on a physical inventory count method to regularly manage large amounts of stock. This resulted in mulitple organizational pain points:

  • Intensive manual labor involved a weekly reconciliation that required 1 dedicated resource per brand. This resulted in at least 3-hours spent reconciling the quantities for each store in their reporting platforms

  • Impossibility to validate all critical and high-price tag items per store due to the high volume of records generated

  • Lack of effectiveness in communicating quantities to each store on time, before the upcoming weekly inventory cycle count needed to be completed

The business wanted to reduce the time and manual labor spent on the weekly inventory reconciliation process. They required a solution that would verify the inventory count for each store (from the prior week to the current week) automatically, reconcile discrepancies between inventory quantities and absolute cost deviation from an indicated metric calue, and send an email outlining the details of items that needed to be recounted.

Key Challenges

The volume of records and logic behind the inventory metrics needed to classify and filter data presented the biggest challenge to Smartbridge. However, there were various other milestones to overcome in implementing a solution:

  • Business logic definition from the client side – they needed a proper way to classify and segment data that needed to be validated during each inventory cycle

  • Statistics and metrics definition

  • The volume of data being processed and alternatives to manage this inside of the automation

Smartbridge Methodology

Smartbridge implemented an agile development approach, with short sprints to present POC results in less than 3 days. Support from UiPath was also critical. Regularly reaching out to platform experts enhanced our deliverable skills.

An attended bot was required in the solution implemented. Through the interaction of key users, we input parameters to manipulate the execution according to the metrics needed, as well as cross check the data on each stage of the automation to ensure accuracy. Automatic email notifications ensured communication to each store that needed to recount inventory was done immediately after the validations were completed.

UiPath logo

Smartbridge is a UiPath Partner

Results

As expected, the POC was a success. The bot was able to read the input data from the inventory audit report and classify the records that needed validation using the metrics defined by the business (weekly cost, deviation of inventory, and standard cost deviation).

The data being filtered was easy to read and properly categorized by item and store. Once the planner completed or adjusted the output report, the bot was able to process that output, and send individual emails to each store detailing items in need or recount.

Looking for more on Automation?

Explore more insights and expertise at smartbridge.com/automation

There’s more to explore at Smartbridge.com!

Sign up to be notified when we publish articles, news, videos and more!