Smart Inventory Control with XLOOKUP and Conditional Formatting

Build a complete inventory control spreadsheet for [COMPANY NAME] with [NUMBER] SKUs organized into [NUMBER] categories.\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Tab 1 — Product Registry:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Columns: SKU, Name, Category, Supplier, Unit Cost, Selling Price, Minimum Stock, Lead Time (days)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- XLOOKUP to pull supplier data automatically\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Data validation with dropdown lists\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Tab 2 — Stock Movements:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Record of inbound and outbound entries with date and responsible party\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Running balance formula: SUMIFS by SKU (inbound − outbound)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Automatic weighted average cost\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Tab 3 — ABC Analysis:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Automatic ABC classification by revenue (80/15/5)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- PERCENTILE + nested IF formula for classification\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Pareto chart with cumulative line\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Stock policy recommendation by class\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Tab 4 — Alerts and Replenishment:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Reorder point = Minimum Stock + (Average Daily Demand × Lead Time)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Conditional formatting:\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n  - Red: below minimum (imminent stockout)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n  - Yellow: between minimum and reorder point\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n  - Green: healthy stock level\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n  - Blue: excess (above [DAYS] days of coverage)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Demand forecast formula (3-month moving average)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n**Tab 5 — Dashboard:**\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Total inventory value (cost and selling price)\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Inventory turnover by category\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Top 10 fastest and slowest moving products\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n- Products with no movement in the last [DAYS] days\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\n\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\nAll formulas must work in both English Excel and Google Sheets.