Creating a Real-Time Inventory Management System & Automating financial Reporting

The Challenge

Company: Seaworld Seafood

Time consuming operations preventing the most important work

The owner was getting bogged down by operations, specifically any type of reporting and inventory management, preventing him to focus on the most important task at hand: getting ready to sell the restaurant.

Our Solution

We creating a realtime inventory management system & automated all reporting

After completing or introduction audit, we realized the biggest source of leverage would be to implement a custom real time inventory management system that notified the team and vendors when ingredients were low and would automatically bill and order from the vendor. This replaced a tedious 14 hour a week process to be fully automated. We also completely automated reporting from square POS and all third party ordering systems like Uber eats, grubhub, doordash etc.

Tools Used:

• Python + Pipedream: we coded python scripts to connect to different APIs.

• Make.com: to automatically reorder (send an email) based off automations set up in Airtable

• Airtable: to create the backbone of the inventory management system

Key Benefits

• Reduced Mistakes: building bases on airtable to measure inventory reduced overall tracking mistakes

• Ability to focus on higher ROI activites: Owner gained back more than 40 hours per month and was able to focus on selling the business

  
  

Results

Owner was able to remove himself completely from reporting & inventory management & was able to sell his business with the time he saved

• 40+hrs saved per month: By leveraging data-driven strategies, the retailer achieved a significant boost in sales revenue.

• Business Sold: after two months of implementing our systems, owner was able to spend the time he saved from not having to do inventory management and reporting and focus on selling the business!