Procurement Data Cost-Saving Analysis

I have a full year of raw purchase data and need a sharp pair of eyes to uncover where we’re overspending on materials. You’ll dive into twelve months of line-item transactions, cleanse and structure the file, then surface the price variances, volume breakpoints, and any patterns that indicate immediate savings with our current suppliers or through consolidation.

Once the data is clean, I expect clear metrics—average unit cost per SKU, month-to-month trends, and benchmark comparisons—presented in a concise report. Please translate those insights into actionable recommendations I can take straight to our procurement team (for example, renegotiation targets or alternative sourcing options). A short slide deck or dashboard to visualise the main savings hotspots would be a bonus.

Deliverables:
• Clean, well-documented dataset (Excel or CSV)
• Analytical summary highlighting material cost drivers and quick-win opportunities
• Action-oriented recommendations ranked by potential savings
• Optional visual dashboard or slides for leadership review

You’re free to use Excel, Power BI, Python (pandas), Tableau—whatever helps you get to the truth fastest.