A leading quick-service restaurant chain has experienced explosive growth in the last decade; to the point where the average restaurant can only keep one day of inventory on hand. Artisan was engaged to build a perpetual inventory engine that gives every restaurant in the chain an accurate estimate of on hand inventory by analyzing sales transactions.
Given that the average client restaurant can only hold one day of on hand inventory, all restaurants within the chain are placing orders every day. Typically, a restaurant counts its inventory just one time per month. The client restaurant was relying on a SaaS solution that leveraged sales data to estimate the depletion of on-hand inventory levels, but that system was old and outdated and struggled to handle the client restaurant’s current volume of sales data. Artisan was engaged to build a new perpetual inventory engine micro-service capable of processing millions of sales transactions daily to power the restaurant’s new modernized supply chain technology stack.
Artisan recognized that a key component of the solution architecture would be the ability to handle millions of sales transactions per day. With that in mind, the team leveraged DynamoDB for sales transaction processing and pushed aggregated inventory data in 5-minute increments down into Amazon RDS where relational integrity with other required data points for estimating inventory could be easily maintained.
The perpetual inventory engine runs continuously and is highly available. The transaction processing power of the architecture easily handles multiple orders of magnitude; more data than is required to support the client restaurant’s current chain-wide needs. The client intends to double its current revenue over the next 10 years, so this solution will be capable of supporting its needs for the foreseeable future.
.png)
We are excited about the revolutionary role this product will play as we transform Supply Chain. It is a major step toward simplifying the ordering experience and unlocking the omnichannel Supply Chain of the future!
.svg)
