Integrated Supply Chain and Manufacturing Order Forecasting

Greyscale AI is a capital equipment OEM and I am a part of their supply chain team. As a startup, our resources are limited, and due to COVID, supply chains are unpredictable and lead times are notoriously misleading. This capstone project illustrates a business problem that was solved for Greyscale AI’s supply chain team using: 

• Feature extraction from an ERP system (Odoo) 

• Database integrations (ODBC / REST API) 
• A dashboard to forecast inventory needs (aggregations and sums) 
• An automated process flow (spreadsheet integration, ERP database querying) 

The deliverable of this project was a spreadsheet that merged manufacturing, purchase and inventory tables, to generate a week to week part forecast for Greyscale AI. It features direct integration into our Odoo ERP system, which makes it highly automated, and is categorized as a descriptive analytics project, allowing the supply chain team to visualize parts on hand, and determine when to restock.