Dashboard Purpose
Use this dashboard if you want to:
- Monitor supplier performance and purchasing activity.
- Track supplier details per branch and per item.
- Identify supplier costs, quantities, and transactions over time.
- Analyze returns to suppliers to highlight inefficiencies or issues.
- Compare supplier performance across branches for better procurement decisions.
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 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 see which supplier provides which products? | Use the Details tab with the Supplier Name filter. |
| How can I track supplier performance by branch? | Use the Branch tab to review branch-level supplier details. |
| How can I review supplier returns? | Check metrics Return to Supplier Quantity and Return to Supplier Cost in the Details tab. |
Keywords (for search functionality)
💡suppliers, procurement, supplier transactions, supplier details, branch suppliers, purchasing supplier, supplier returns, supplier costs, purchasing trends, supplier quantity
Tab / Section Overview
| Tab Name | Description | Example Case |
|---|
| Details | Displays overall supplier details, including purchasing cost, quantity, and returns. | A purchasing manager checks total spend with Berain Water supplier this month. |
| Branch | Shows supplier details per branch per item. | Operations reviews which items Shovel supplied to Abu Dhabi branch. |
Available Filters
| Filter Name | Description | Notes |
|---|
| Business Day | Filters data by date. Default = Last Month. | Use to align supplier activity to reporting period. |
| Branch Name | Filters suppliers by branch. | Example: Abha, Abu Dhabi. |
| Supplier Name | Filters by supplier/vendor. | Example: Berain Water, Shovel. |
| Item Name | Filters data by product supplied. | Example: Almond Powder, Basmati Rice. |
| Item SKU | Filters data by SKU code. | Helps track items with multiple variations. |
Metrics & Definitions
| Metric | Definition | Notes |
|---|
| Purchasing Cost | Total cost of items purchased from suppliers. | Includes all supplier invoices. |
| Purchasing Quantity | Total quantity of items purchased. | Measured in units relevant to the item (kg, liters, pieces, etc.). |
| Number of Purchasing Transactions | Count of all purchase transactions with suppliers. | Useful for supplier activity tracking. |
| Return to Supplier Quantity | Total quantity of items returned to suppliers. | Indicates rejected or faulty goods. |
| Return to Supplier Cost | Value of returned items. | Helps monitor cost of supplier issues. |
| Number of Returns to Supplier | Count of return transactions to suppliers. | Useful for supplier reliability analysis. |