Tera Calculation processes over 100,000 records of shipping data using EIQ methods. By utilizing SQL for database processing, it achieves high-speed performance even with data volumes that would be difficult to handle in Excel.
Procedures & Features
- 1. Data Import: Import shipping data from Excel into the database.
- 2. Pre-processing: Automate data preparation to reduce manual effort.
- Distinction between case and piece shipping
- Unit conversion: pieces to cases, pallets, volume, or weight
- Ranking and ABC classification based on keys
- 3. Matrix Creation: Estimate inventory/incoming volume and generate EIQ Matrix tables.
- 4. Scale Calculation: Allocate logistics equipment and calculate total distribution center size.
Program Flowchart
