Project Background
Walsin Lihwa has invested in smart manufacturing for many years and planned to install a new fully automated wire production line in Xinzhuang, requiring large-scale standard product orders to recoup the investment. To achieve this, the company decided to implement Vendor Managed Inventory (VMI) for three major domestic distributors (Beigai, Zhongtong, Nansheng) across three commonly used construction wire products (IV, VV, CVV).
This project was developed in collaboration with Walsin Lihwa as an industry-academia partnership, creating an educational simulation game where students play the role of a VMI project manager. By setting replenishment strategies and observing simulation results, students learn the decision-making logic of supply chain management.
Game Flow
1. Login
Enter student ID and name; the system creates a dedicated game record.2. Strategy Setup
Configure “number of leased slots” and “replenishment frequency (days between restocks)” for each of the 3 distributors x 3 wire products (9 combinations total).3. Daily Simulation
Based on historical sales data, the system automatically advances one day every 5 seconds, displaying real-time sales volume, replenishment status, and emergency restocking status for each product.4. Monthly Settlement
At the end of each month, the system automatically tallies service revenue, slot rental fees, replenishment costs, and emergency shipping costs for each distributor’s products, and allows strategy adjustments for the following month.5. Annual Summary
After 12 months, the system calculates total annual revenue, total expenses, and dividend bonuses as the final performance evaluation.Core Features
9 Strategy Combinations
3 distributors (Beigai, Zhongtong, Nansheng) x 3 wire types (IV, VV, CVV), each combination independently configured with leased slots and replenishment interval.Automatic Replenishment Logic
Based on the player’s configured replenishment interval, the system automatically calculates the shortfall on restock days and fills the slot inventory.Emergency Replenishment Mechanism
When daily sales exceed current inventory, emergency replenishment is automatically triggered, incurring higher additional shipping costs.Profit/Loss Settlement System
Monthly and annual automatic settlement of service revenue, slot rental fees, replenishment costs, and emergency shipping costs, with final dividend bonus calculation.
Database Design
Uses a dual-database architecture that separates static reference data from dynamic transaction data, totaling 9 tables.
| Table | Description |
|---|---|
| comparedate | Date-to-month mapping table |
| parameter | System parameters (service revenue, rental fees, replenishment costs, emergency shipping costs, dividend rate) |
| producer | Distributor records (Beigai, Zhongtong, Nansheng) |
| product | Product records (IV, VV, CVV) |
| sellrecord | Historical sales records (daily sales per product) |