Who is the Company

A food and beverage company with an extensive chain of stores worldwide.

The Challenge

The company has many brick-and-mortar outlets across multiple time zones throughout North America. The company had difficulty tracking the publication status of store orders within North America, which led to problems with inventory management. These problems resulted in out-of-stock items, poor decision-making, and lost profits due to excess inventory.

Each store ideally posted daily inventory orders before they opened for business. Once the orders are posted, store partners need to review and approve the published orders. This review and approval process is important because it ensures that the orders are accurate and complete.

The company has set a cut-off time, which is the last time stores can make any changes or adjustments to their orders before they are sent to the distributors for processing. This cut-off time is critical for the company's operations, as it ensures that the store orders are accurate and inventory will be delivered on time. It also allows the company to avoid overstocking or stock-outs.

The lack of visibility into the store order status led to inventory management problems. Sales suffered because out-of-stock items led to customer dissatisfaction and lost conversion opportunities. The company also lost potential profits because the excess inventory generated higher carrying costs.

In brief, the company was looking for the following:

  • Increased publication status frequency: On the current business date, various stakeholders need to be alerted about order publication status hourly. Lack of timely data led to poor decision-making. The company was looking for a way to increase the frequency of order publication status without sacrificing overall system speed or data quality.
  • Greater control over inventory management: Order discrepancies were not spotted and corrected promptly in the existing system. This resulted in misaligned inventory levels, inefficiencies in the supply chain, and confusion in order and fulfillment processing. The company’s production support team needed to know if discrepancies were observed between forecasted and published orders. 
  • Complete order visibility: The existing ordering system lacked transparency. The company wanted a solution to provide them with near-continuous monitoring of stores’ order status. The lack of order visibility resulted in delays and errors, costing the company tangible losses in terms of money and intangible losses in terms of customer dissatisfaction.

The Solution

Business Impact

Key benefits the company enjoyed after project completion included:

  • Effective ordering management: Automation of order publication count minimizes errors. This, in turn, allows stores to make accurate orders, increasing profitability.
  • Reliability and flexibility: The new system provides accurate results without any loss of information. Company members can now expect a reliable order count on an hourly basis and have the flexibility to take action to ensure there is time to 
  • Increases reaction time window: The new system reduces the manual effort required to monitor order creation. This allows company resources to focus on more important tasks. 
  • Improved inventory management: Inaccurate product demand forecasting led to over or understocking. The new system allows stakeholders to manage orders efficiently, leading to better inventory management. Having items in stock resulted in increased sales and lower carrying costs.

Technologies Used

Slack: A business-oriented messaging app
Db2: A database management system from IBM
Micronaut: A framework to build lightweight, modular applications
Kotlin: A modern, statically typed programming language
Apache Cassandra: A high-volume distributed database management system
ScyllaDB: A fast, distributed, scalable NoSQL database

Do you have a similar project in mind?

Enter your email address to start the conversation