•  HVAC company manufacturers have  to maintain a minimum stock to supply to their client whenever spare parts are requested.
•  The existing  required more manual intervention which involves generating reports from excel and additionally manual work is done on top it and reports are generated to make  decisions which consumes 4 days.
•  No inventory visibility
• Customer wanted to streamline the track of supplies and managing inventory.

Introduction

HVAC company manufacturers have to maintain a minimum stock to supply to their client whenever spare parts are requested.

Solution

•  Provided Power-BI visualization for better decision making.
•  KPI’s are provided -Starting on Hand inventory Forecast/Demand Firm supply Planned supply Safety stock % to SS inventory level Leadtime

Key Benefits

• Time saving(From 3 hours to 20 min)
•  Enhanced supply chain efficiency by considering delivery time scenarios and presenting a clear visual overview for improved inventory management and tracking.