Procurement Spend and Supplier Cost Efficiency Dashboard
Monitor supplier spend concentration, pricing trends, and purchase efficiency to support vendor negotiations and cost reduction initiatives.
YoY Spend Change (%)
Computed from purchase_registers invoice-date spend totals for 2026-01-01 to 2026-03-31 versus 2025-01-01 to 2025-03-31 using SUM(linetotal_aed) on AED-converted line totals.
Unit Cost YoY Change (%)
Computed from purchase_registers line totals and quantities for Q1 2026 (invoice_date 2026-01-01 to 2026-03-31) compared against Q1 2025 using the same invoice-date basis.
Price Variance Across Suppliers (%)
Computed across the top 10 items by AED spend between 2026-01-01 and 2026-03-31, averaging percentage variance for items sourced from more than one supplier.
Active Suppliers (Count)
Based on distinct supplier_id values across purchase_registers invoices dated between 2026-01-01 and 2026-03-31.
Average PO Cycle Time (Days)
Computed from all purchase orders with non-null po_date and final_delivery_date delivered between 2026-01-01 and 2026-03-31.
On-Time Delivery Rate
Computed from 1 purchase order line delivered between 2026-01-01 and 2026-03-31 with both expected and actual delivery dates recorded.
Spend by Buyer Department (PO Value)
Fujairah Rock & Aggregate has the highest PO value at AED 357,202.41, indicating the strongest procurement intensity in Q1 2026.
The top five departments each exceed AED 284,000 in PO value, showing a relatively concentrated upper tier of procurement spend.
There is a steep drop from the top department (AED 357k) to the lower end (e.g., Dubai Medical Supplies at AED 26,462.56), suggesting uneven departmental purchasing distribution.
Spend by Purchasing Group
The top three groups—Other (1,997,839.90 AED), Service (1,991,247.11 AED), and Consumable (1,950,923.72 AED)—have very similar spend levels, each contributing close to 2.0M AED.
Capex accounts for 1,499,471.16 AED in Q1 spend, forming a significant but clearly smaller share than the top three groups.
Material has the lowest spend among the listed groups at 1,214,556.68 AED, roughly 39% lower than the highest-spend group (Other).
Monthly Weighted Average Unit Cost (AED)
Weighted average unit cost decreased from AED 484.55 in January to AED 449.78 in February (−7.2%), before rising sharply to AED 568.72 in March (+26.4% month-over-month).
March shows the highest unit cost at AED 568.72, significantly above the Q1 low in February (AED 449.78), indicating potential supplier price increases or mix shifts.
Compared to January, March unit costs are higher by AED 84.17 per unit (+17.4%), suggesting upward cost pressure toward the end of the quarter.