Dashboard Purpose
Use this dashboard if you want to:
- Monitor quantity control (opening, consumption, closing stock, and variances).
- Track cost control across branches and products.
- Review daily quantity movements (in vs out) at both branch and overall levels.
- Identify inefficiencies, overuse, or waste by monitoring variances and waste-related metrics.
Common Use Cases
| Business Question | Where to Look |
|---|
| Where can I filter different branch names? | Use the Branch Name filter to select your preferred branch. |
| Where can I filter by business day? | Use the Business Day filter (default = last month). |
| How can I filter for specific items? | Use the Item Name filter (e.g., Almond Powder, Basmati Rice). |
| How can I track daily inventory movements for a branch? | Go to the Daily Quantity Control tab and select the branch from the Branch Name filter. |
| How can I see cost-related variances? | Use the Cost Control tab to compare branch vs overall costs. |
| How can I identify waste sources? | Review Production Waste Quantity and Waste From Order Quantity metrics under relevant tabs. |
Keywords (for search functionality)
💡inventory control, stock tracking, cost control, quantity control, daily inventory, variance, waste tracking, opening quantity, closing quantity, transfers, purchasing, food cost, production waste, order consumption
Tab / Section Overview
| Tab Name | Description | Example Case |
|---|
| Quantity Control | Displays branch-level and overall quantity control (stock in/out and variances). | A manager checks if actual closing quantity matches expected stock levels. |
| Cost Control | Displays branch-level and overall cost control based on consumption and variances. | Finance compares food cost control between branches. |
| Daily Quantity Control | Shows daily-level quantity movements per branch (inflows vs outflows). | A branch operator reviews daily usage of Almond Powder. |
Available Filters
| Filter Name | Description | Notes |
|---|
| Business Day | Filters data by date. Default = Last Month. | Report is time-based; filtering is essential for accuracy. |
| Branch Name | Filters data by branch. | Example: Abha, Abu Dhabi. |
| Item Name | Filters data by product/item. | Example: Almond Powder, Basmati Rice. |
| Item SKU | Filters by specific SKU code. | Useful for tracking at SKU level when items have multiple variations. |
Metrics & Definitions
| Metric | Definition | Notes |
|---|
| Opening Quantity | Stock on hand at the start of the selected period. | Calculated per item, per branch. |
| Purchasing Quantity | Quantity received from suppliers. | Adds to Total In. |
| Transfer Received Quantity | Quantity received via transfers from other branches. | Adds to Total In. |
| Production Quantity | Quantity produced in-house (e.g., kitchen prep). | Adds to Total In. |
| Return From Order Quantity | Items returned from customer orders. | Adds to Total In. |
| Return From Transfer Quantity | Items returned from transfers. | Adds to Total In. |
| Total In | Sum of all incoming quantities. | Formula = Purchasing + Transfers In + Production + Returns In. |
| Consumption From Order Quantity | Quantity consumed through customer orders. | Subtracted in Total Out. |
| Consumption From Production Quantity | Quantity consumed in production processes. | Subtracted in Total Out. |
| Return To Supplier Quantity | Items sent back to suppliers. | Subtracted in Total Out. |
| Transfer Sending Quantity | Items transferred out to other branches. | Subtracted in Total Out. |
| Quantity Adjustment Quantity | Manual adjustments (e.g., corrections). | Can be positive or negative. |
| Production Waste Quantity | Waste generated during production. | Subtracted in Total Out. |
| Waste From Order Quantity | Waste generated from orders. | Subtracted in Total Out. |
| Total Out | Sum of all outgoing quantities. | Formula = Consumptions + Transfers Out + Returns Out + Waste. |
| Closing Quantity | Stock on hand at the end of the selected period. | Formula = Opening + Total In − Total Out. |
| Variance Quantity | Difference between expected stock and actual stock. | Highlights shrinkage, errors, or waste. |