Noha Stock Planner – Smart Consumption & Reorder System

Built a desktop application for pharmaceutical inventory planning.

The system:

• Imports raw Excel product data

• Automatically normalizes product names (removes price variations like “XX LE”)

• Merges duplicate SKUs with different prices

• Calculates real consumption rate based on selected period

• Computes required reorder quantity based on coverage days

• Generates a clean output sheet ready for purchasing decisions

Key Features:

✔ Smart product name normalization

✔ Consumption rate calculation

✔ Multi-branch compatible

✔ Handles 10,000+ records efficiently

✔ User-friendly desktop interface

Technologies:

Python, Pandas, OpenPyXL, CustomTkinter