A comprehensive Excel VBA solution that automates the entire supplier pricing and inventory management process. This system processes 50+ supplier files, performs cost analysis, and provides real-time pricing comparisons while maintaining product database integrity.
Key Functionalities:
- Formats and cleans 50+ supplier files, removing unnecessary data
- Pulls all supplier data into a centralized master file
- Identifies cheapest, second cheapest, and third cheapest pricing across all suppliers
- Tracks cost fluctuations
- Incorporates internal system pricing alongside supplier data
- Tracks product quantities and stock levels across all suppliers
- Simplifies adding new products
- Maintains synchronization between internal product identifiers and supplier identifiers
- Handles special pricing calculations for composite product components