Kho Vải Lite – Sức Chứa & Hàng Tồn Theo Tuổi | Excel Template

• COVER — Title page: system overview, table of contents, key features.
• User Guide — Operating procedures, color conventions, fabric import/export workflow, FAQ.
• Import/Export Data — Main data table with 43 columns: item code, season, PO, supplier, location, yards in/out/balance. Dropdown validation included.
• Visual Warehouse (Warehouse Map) — Color-coded warehouse layout showing capacity status of each rack. Instant visibility of warehouse status.
• Capacity Alert — 8-week capacity forecast. Automatic alerts before warehouse overload.
• Dropdown data — Fabric catalog, suppliers, rack locations, max capacity — centralized management, ensuring consistency.

Design: Automated formulas, visual color coding, standardized dropdowns. Zero VBA, zero macros.

• Raw Material Warehouse Staff — Garment & textile industry
• Fabric Warehouse Manager — At manufacturing plants, raw material warehouses
• Merchandiser / Planning — Need to track fabric inventory
• Small & Medium Businesses — Want to digitize fabric warehouse management with Excel
• Students — Supply Chain Management major

• 1 Excel file (.xlsx), Lite version
• 6 professional sheets, fully linked
• 43 columns of import/export warehouse data
• Standardized dropdown system to prevent entry errors
• Visual warehouse map with color-coded status
• 8-week capacity forecast
• Detailed Vietnamese user guide

1. Setup: Open Dropdown data → enter fabric categories, suppliers, shelf locations, max capacity.
2. Data Entry: Open Data Entry → record each in/out transaction. Dropdowns auto-suggest.
3. Monitor: View Warehouse Map + Capacity Alert — everything auto-updates, no additional action needed.

• Format: Microsoft Excel (.xlsx)
• Version: 1.0 Lite
• Units: Yards / Rolls
• Number of sheets: 6
• Color conventions: Blue = manual / Purple = dropdown / Gray = formula / Red = alert
• Compatible with: Excel 2019+, Microsoft 365. Limited Google Sheets support.