Quản Lý Kho Vải Toàn Diện – Tồn Kho, Xuất Nhập & Báo Cáo | Excel Template

• DASHBOARD — Warehouse overview: KPIs, stock age, capacity forecast, Top 5 largest lots — 100% automated.
• WAREHOUSE_MAP — Visual warehouse map — auto-colors by shelf fill level.
• FABRICS — Main data entry — manage each fabric lot in detail, dispatch history up to 10 times.
• SHELVES — Shelf directory: capacity, type, location — auto-calculates fill %.
• FORECAST — Forecast warehouse capacity for the next 8 weeks based on actual consumption rate.
• STOCK_AGE — Stock age analysis: 12 months.
• SETTINGS — Alert thresholds, dropdown lists — change once, update entire system.
• GUIDE — Detailed guide: color conventions, data flow, step-by-step workflow.
• COVER — Cover page, table of contents, system overview.

Design: 100+ automated formulas (SUMIF, XLOOKUP, INDEX/MATCH, COUNTIF, FORECAST), real-time linked data across sheets, zero VBA, zero macros.

• Fabric warehouse management — At garment factories, production workshops, material warehouses
• Logistics / supply chain staff — Ngành textile, dệt may
• Small business owners — Kinh doanh vải sỉ, vải lẻ
• Sinh viên — Ngành quản trị chuỗi cung ứng / logistics muốn học cách xây hệ thống trên Excel

Scale: Fabric warehouses from dozens to hundreds of lots, multiple shelves / multiple fabric types.

• 1 Excel file (.xlsx), no password lock
• 9 sheets chuyên nghiệp, liên kết hoàn chỉnh
• 100+ pre-configured automated formulas
• Sample data (14 fabric lots) for reference
• 4-level color-coded stock age alerts (green → yellow → orange → red)
• Automatic FIFO system — prioritize dispatching oldest lots first
• Smart shelf suggestions when adding new fabric lots

1. One-time setup: Open SETTINGS → set alert thresholds. Open SHELVES → enter shelf list.
2. Daily data entry: Open FABRICS → enter new lot info. Update quantities when dispatching.
3. Theo dõi & ra quyết định: View DASHBOARD + WAREHOUSE_MAP + STOCK_AGE — everything updates automatically.

• Minimum: Microsoft Excel 2016+ (Windows or Mac), 50MB free space
• Recommended: Excel 2021 or Microsoft 365, Full HD display
• Support: Excel for Web, Excel for Mac
• Not supported: Google Sheets, LibreOffice Calc

Are formulas locked?
Sheets are protected but you can remove protection (no password needed) to view and edit.

How many warehouses can this be used for?
Unlimited. Copy the file and rename for each warehouse.

Is there an English version?
Yes. Product includes both EN and VI versions, select when ordering.

Can I customize colors and logos?
Yes. The file is yours, customize freely.

Technical support?
Free email support for the first 30 days.