Combined inventory management and sales performance tracker with low-stock alerts and target vs actual analysis.
Excel Sheet File
Inventory sheet with Qty, Reorder Level, Stock Value & Status (LOW STOCK / OK)
Conditional formatting for low stock
Stock Movements (IN/OUT) log
Sales by Product & Month
Target vs Actual + Achievement %
Stacked bar and pie charts