Kibani Retail Intelligence —Department Control Tower

A 22-sheet Excel system that turns daily sales entries into a full retail operations command center — no dashboards to build, no formulas to write.

Most retail teams either fly blind on daily performance or spend hours every week rebuilding the same reports in Excel. This workbook replaces that entirely: enter your numbers once in Master Input and Settings, and every dashboard, KPI, and alert updates automatically.

What's inside:

Executive Dashboard — today's sales, MTD achievement, gross and net profit, margin, shrinkage, and risk zone, all on one screen

Morning Brief — yesterday's result and the exact daily pace needed to hit target, plus a 7-day trend

Master Input — one place to log daily sales by brand, footfall, staffing, and staff sales

Daily Ops Calc — day-by-day conversion rate, UPT, APT, and sales-per-hour for the whole month

Brand Matrix & Category Performance — sales, targets, sell-through, and risk per brand and category

ABC Segmentation — automatic Pareto classification of your brands by sales value

Staff Control & Coaching Engine — individual performance tracking with a built-in coaching log

Inventory Intelligence & Expiry Radar — stock variance, count accuracy, and SKUs approaching expiry

Shrinkage Center — monthly shrinkage log and shrinkage %

Discount Margin Lab & Sales vs Discount — model how a discount affects margin before you apply it

Forecast Simulator — run-rate projection for month-end vs. target

CEO Score — a single composite health score (0–100) for the department

Clienteling CRM — client list with tiers and follow-up tracking

Traffic Intelligence — hourly footfall and conversion

Action Plan — open issues, owners, and deadlines in one tracker

KPI Glossary — plain-language definition of every metric in the workbook, so nothing is a mystery to a new team member

Built for real use, not just presentation:

1,746 live formulas, fully verified with zero calculation errors

Color-coded input system (gold = enter your data, white = automatic formulas — never overwritten by mistake)

Editable brand list, staff roster, categories, and targets — built around a perfume department but easily adapted to any retail category

Works in Excel, Google Sheets, and LibreOffice

Who it's for: Retail department supervisors, store managers, and small retail operators who want daily visibility into sales, staff performance, inventory, and shrinkage — without hiring a BI analyst or building a reporting system from scratch.

Instant digital download. One-time payment, lifetime use.

This Best Practice includes

A 22-sheet Excel control tower for retail departments — daily sales, staff performance, inventory, shrinkage, and foreca