Dashboard Purpose
Use this dashboard if you want to:
- Monitor inventory counts at item and category levels.
- Compare theoretical vs. actual inventory quantities to identify variances.
- Track inflows and outflows of stock (purchases, transfers, consumption, returns, waste).
- Review detailed vs. grouped views of both quantities and costs.
- Validate the latest count data fetch for reporting accuracy.
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 (e.g., Abha, Abu Dhabi). |
| Where can I filter 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 check actual vs. theoretical inventory differences? | Use Detailed Quantities or Grouped Quantities tabs and compare Inventory Count 2 Quantity (Actual) vs. Theoretical Quantity. |
| How can I review cost details of inventory by category? | Check the Detailed Costs or Grouped Costs tabs with the Category Name filter. |
| How can I verify when the latest data was updated? | Go to the Latest Fetch tab to see the most recent update date. |
Keywords (for search functionality)
💡inventory count, stock count, inventory variance, inventory quantities, grouped quantities, detailed quantities, inventory costs, grouped costs, detailed costs, actual vs theoretical, stock inflow, stock outflow, latest fetch
Tab / Section Overview
| Tab Name | Description | Example Case |
|---|
| Detailed Quantities | Shows item-level and category-level quantities (detailed and simplified views). | A store manager reviews detailed counts of Basmati Rice by unit. |
| Grouped Quantities | Shows aggregated quantities at product and category levels (detailed and simplified). | A regional manager checks total beverage stock across multiple items. |
| Detailed Costs | Displays item-level and category-level inventory costs (detailed and simplified). | Finance checks cost variance for Almond Powder. |
| Grouped Costs | Displays aggregated inventory costs at product and category levels (detailed and simplified). | Procurement reviews total cost of Dairy items. |
| Latest Fetch | Shows the latest update date of inventory counts. | Operations verifies whether today’s count has been refreshed. |
Available Filters
| Filter Name | Description | Notes |
|---|
| Business Day | Filters data by date. Default = Last Month. | Use to view counts for specific reporting periods. |
| Branch Name | Filters inventory by branch. | Example: Abha, Abu Dhabi. |
| SKU | Filters by specific stock-keeping unit. | Useful for SKU-level audits. |
| Item Name | Filters by product name. | Example: Almond Powder, Basmati Rice. |
| Category Name | Filters by category grouping. | Example: Beverages, Dairy. |
Metrics & Definitions
| Metric | Definition | Notes |
|---|
| Inventory Count 1 Quantity | Initial recorded inventory quantity. | Used as a starting point before transactions. |
| Total In | Sum of all incoming quantities (purchases, transfers in, production). | Indicates stock inflows. |
| Production Quantity | Quantity produced internally. | Example: prepared bakery goods. |
| Purchasing Quantity | Quantity purchased from suppliers. | Based on purchase transactions. |
| Return From Order Quantity | Items returned from customer orders. | Adds back to stock. |
| Return From Transfer Quantity | Items returned from transfers. | Example: branch-to-branch returns. |
| Transfer Receiving Quantity | Quantity received from another branch. | Increases receiving branch stock. |
| Total Out | Sum of all outgoing quantities (consumption, transfers out, returns). | Indicates stock outflows. |
| Consumption From Order Quantity | Quantity consumed to fulfill customer orders. | Reduces stock. |
| Consumption From Production Quantity | Ingredients consumed in internal production. | Example: flour used to bake bread. |
| Quantity Adjustment Quantity | Manual adjustments in stock counts. | Corrects errors or discrepancies. |
| Return To Supplier Quantity | Quantity returned back to suppliers. | Reduces stock. |
| Transfer Sending Quantity | Quantity sent to another branch. | Recorded as outflow for sending branch. |
| Waste From Order Quantity | Waste linked to customer orders. | Example: spillage or damaged goods. |
| Waste From Production Quantity | Waste from production process. | Example: burnt or spoiled batches. |
| Inventory Count 2 Quantity (Actual) | Actual physical count of inventory. | From most recent stock check. |
| Theoretical Quantity | System-calculated expected inventory. | Based on transactions. |
| Variance | Difference between actual and theoretical quantities. | Identifies shrinkage or discrepancies. |
| Waste % | Percentage of waste relative to total stock. | Helps track efficiency. |