Conduct procurement spend analysis, raw material price variance audits, and purchase BI reporting
What this does
Delivers executive business intelligence into total procurement spend, raw material commodity trends, vendor cost variances, and purchase budget compliance across graphical and pivot views.
Before you start
- Purchase Manager or Finance Director access.
Steps


Important
Comparing average unit purchase prices over time highlights inflation risks and informs strategic raw material hedging.
-
01
Open Purchase › Reporting › Purchase.
-
02
Toggle between Graph and Pivot views.
-
03
Select Measures: evaluate Untaxed Total, Quantity Billed, Average Price, and Lead Time to Purchase.
-
04
Group by Vendor and Product Category to audit major spend categories (e.g. Aluminium Extrusions, Glass, Hardware, Consumables).
Common mistakes
- Evaluating spend totals without separating capital equipment tooling from consumable project materials.
- Not auditing invoice price variances against initial purchase order agreed rates.
Was this article helpful?
Thanks — your feedback helps.
Running a window or door factory?
Ask for a demo