On-Demand Projection for Automating Biological Supply Chain Processes
This organization owns and operates a large cattle herd with around 400,000 head spread across multiple properties in two cities. It has several Enterprise Resource Planning (ERP) systems that help to coordinate planned supply and projected or locked-in demand over a period of time in a structured way. This data enables the organization to identify potential deficits and opportunities to sell.
Given the complexities involved in the planning stage of biological supply chains, these ERP systems were not able to offer the outcomes required to make effective business decisions. What the customer needed was a system that offered timely and accurate forecasts for future supply across multiple value-indicative dimensions and, based on business logic, a matching of products to meet this demand.
A team comprising Data Scientists, Engineers, and Business Analysts from Trabeya built a modular system that complemented the existing ERP process to provide a dynamic view of available resources and production via an enterprise business intelligence tool. The solution involved connecting directly to dedicated views and data optimization to lessen the burden on production systems.
The Trabeya team recommended replacing manual processes to record and maintain data with web applications determined by business-as-usual needs and scoping, ensuring consistency in format and synchronization in the case of multiple spreadsheets. Both initially capturing the business logic of matching supply and demand to constrain our optimization algorithm, as well as validating it, required close collaboration with business stakeholders. This was achieved through routine communication and by devising well-defined testing scenarios, including regression tests for new features.
The developed system automated the entire pipeline, completely replacing the time-consuming manual system used previously. It now generates production forecasts on demand compared with 10-12 hours (sometimes up to a day) taken to perform the same task earlier. Moreover, regular updates to the system allows sales and sales support teams around the world to have the same view of supply and demand, allowing them to lock in demand for upcoming excess supply, as well as avoid or manage expectations around oversold supply.