/ Case Studies / Industry Solution / Material Resource Planning (MRP) Optimization Solution

Material Resource Planning (MRP) Optimization Solution

Prediction Based Raw Material Procurement Lifecycle

[Industry Solution] Manufacturing

The MRP optimization solution harmonizes a range of procurement data sources driven by a customized ML model for comprehensive “What-If” analysis on Inventory
Management and Demand Forecasting. It utilizes Snowpark for Python and Streamlit for data processing and visualization.

Additionally, it leverages the Snowflake Marketplace to access valuable insights, enabling well-informed decision-making based on precise predictions and forecasts. This approach empowers organizations to optimize their procurement strategies, streamline operations, and boost overall efficiency.

  • Accurate demand forecasting
  • Identifying Supply Chain delays
  • Inventory management
  • Real time updates into the SCM system
  • ML Powered SQL functions for Forecasting
  • Custom ML model on Snowpark
  • Streamlit app for “What-If” analysis
  • Exploratory Data Analysis on Snowsight
  • 3rd Party Data through Marketplace

Fill the Data Gap

The current process witnesses data silos and an absence of a centralized repository with native integrations. created a plan so the data sources interact efficiently but also provide a customized forecasting model.

Streamlined GTM

Ground-up Data Application built on Streamlit to remove dependency on a BI tool and reduce communication silos between various parties.

Upgraded ML’s accelerators are executed on Snowpark for better decision making based on predictions and forecasts. The custom ML models reduce the manual effort needed and time to market.

Kipi’s transformative solution helps organizations make data driven decisions around when & how much (raw materials) to procure. The analytics and
ML models will improve the profit margins by providing information to procure the right amount of raw material at the right time.


Data Sources/Formats

  • Oracle ERP
  • SAP Ariba
  • Order Management Systems
  • Snowflake Data Marketplace


  • Kafka
  • Snowpipe
  • Accelerator
  • Snowflake Secure Data shares


  • Streamlit Based Data Application
  • Inbound Share from Data Marketplace
  • Built on Snowpark
  • Leveraging’s Accelerators

Innovative Industry Solutions


About helps businesses overcome data gaps and deliver rapid insights at scale.
With Snowflake at our core, we believe good data has the power to enable innovation without limits, helping you say goodbye to complex data solutions and hello to the modern world of cloud elasticity.

Kipi earned Snowflake’s Americas System Integrator Growth Partner of the Year Award at the 2023 Snowflake Summit and holds 7 industry competency badges.

Kipi is committed to pioneering world-class data solutions for Snowflake customers including 50+ Accelerators, Enablers, Solutions, and Native Apps to boost performance within Snowflake.

Let become your trusted partner for data and analytics and we’ll empower your teams to access data-driven insights and unlock new revenue streams at scale.

January 22, 2024