Featured projects » Inventory Management
An Inventory and Warehouse Management Model for a Wholesaler of Consumer Goods
With lead times exceeding 100 days for many items, limited warehouse space, and seasonality of sales, the Client needed to integrate data from their order processing, warehouse, and sales management systems in order to optimize the inventory-management process.
Our Solution
-
Design and implementation of the custom ETL process for each of the three systems
-
Analysis of sales, order, and warehouse data
-
Identification of the reorder point and suggested quantity for each item
-
Transformation of reorder points to suggested reorder dates
-
Visualization (color-coded report) of output for easy decision support
Deliverables
-
A fully automated decision-support solution (Visual Basic, SQL Server, Microsoft Office) which integrates order, sales, and warehouse management system data
-
Results compiled based on real-time data and exported to an editable color-coded spreadsheet (Excel)
| Business Problems & Questions |
|
|
Other Featured Projects: |