Inventory Optimization:Restock Threshold Logic

• The Problem:  In manual inventory management,its easy to miss when items are running low,leading to stocks-out and lost sales.

• The Solution: I developed an automated logic systems using Google Sheets that calculates a 'Safety Stock's and Restock Point' for every item.

       This ensures we order exactly when needed,not too early,not too late.

Description

• Automated Notifications: Wrote a script to check stock levels daily and automatically send email alerts to the procurement team when items hit 'Critical' status.

• Automated Forecasting: Utilized historical sales data to calculate 'Days Until Reorder', which powers the automated restock alerts.

• Data Cleaning: Processed raw product data to ensure accurate fields for Unit Cost,Selling Price,and Supplier information.

• Conditional Formatting: Applied heat-mapping to the stock levels to immediately draw eye to items requiring urgent attention.

• Current Stock(Pie Chart): Visualizes the distribution of inventory across categories,helping to which sectors hold the most capital.

• Restock Trend Analysis(Area Chart): Tracks stock levels over time against the 'Last Restocked Date' to visualize consumption patterns and peak demand periods.

• Immediate Products for Restock(Bar Chart): A specialized 'Days Until Restock' visualization that highlights items already in negative territory,indicating immediate action required.

• Individual Stock Rates(Column Chart): Provides a granular view of 'Current Stock's counts for every SKU in the inventory,ensuring no single product is overlooked.

• Key Performance Indicators(KPIs): Integrated a real-time counter for the 'Number of Low Stock Items',to provide an instant status update.

Tools:

• Google Apps Script

• Google Sheets

• Pivot Table

• Dashboard & Chart