The 3 Report Test That Reveals Whether You Actually Understand Your Supplier Spend
Purchase analytics across 60 suppliers tells you who gives you the best price, best terms, and best delivery reliability. Without it, you buy from whoever your purchasing guy has a relationship with. Here's a 3 report test that scores whether your procurement runs on data or on habit.
Report 1: Spend Concentration by Supplier
Can you produce a report showing what percentage of your total annual spend goes to each supplier, ranked from highest to lowest? Score 3 if your system generates this report in one click and you review it quarterly. You know that Supplier A receives 22% of your AED 4M annual spend, Supplier B gets 15%, and the remaining 58 suppliers share the rest. Concentration risk is visible. Score 1 if you can calculate it manually from purchase records but nobody does. The information exists in your transaction data. Extracting it requires exporting to Excel and building a pivot table. The analysis happens once per year during budgeting, if at all. Score 0 if you don't know your spend concentration and have no way to calculate it without significant effort. Your purchasing decisions distribute across suppliers based on individual orders rather than strategic allocation. You might be giving 40% of your business to a supplier who's 15% more expensive than the alternative simply because they were the first to answer the phone.
Report 2: Price Trend by Item Across Suppliers
For your top 20 purchased items, can you compare the price paid to each supplier over the last 12 months? Score 3 if your system tracks purchase price history per item per supplier and you can overlay the trends visually. You see that Supplier C increased prices 8% in March while Supplier D held steady. Negotiation power is built into the data. Score 1 if price history exists in individual purchase orders but comparing across suppliers requires manual extraction. The data exists. The comparison doesn't. Your purchasing team negotiates each order individually without seeing the 12 month pattern. Score 0 if you don't track prices across suppliers systematically. Your purchasing person knows from memory that "Supplier A is usually cheaper for pipes." Memory is not analytics. Memory doesn't show you that Supplier A was cheaper in Q1 but is now 6% above Supplier B after two price increases you didn't notice because each increase was small.
Report 3: Supplier Performance Composite
Can you rank your suppliers by a composite score combining price competitiveness, on time delivery, and quality acceptance? Score 3 if your system calculates this automatically from transaction data and you use the scores in vendor selection. Top performing suppliers get priority. Poor performers get improvement plans or replacement. Score 1 if you track some of these metrics informally but don't combine them into a composite assessment. Your delivery tracking is in one spreadsheet, quality records are with the warehouse, and pricing data is with purchasing. The full picture requires assembling 3 sources. Score 0 if supplier evaluation is subjective. "They're good" is the assessment. Good at what? Compared to whom? Based on what evidence? Subjective evaluation protects underperforming suppliers and overlooks better alternatives.
What Your Score Means
**7 to 9 points:** Your procurement is data driven. Supplier decisions are based on evidence. An enterprise ERPNext implementation would automate the dashboards, but your analytical discipline is strong. **3 to 6 points:** You have procurement data but don't use it strategically. The gap between data and decision means you're likely overpaying 5% to 10% on at least 20% of your spend. On a AED 4M annual procurement budget, that's AED 40K to AED 80K in excess cost hidden in habit based purchasing. **0 to 2 points:** Your procurement runs on relationships, not intelligence. This works when suppliers are few and stable. It fails when markets shift, new suppliers emerge, or existing suppliers quietly raise prices. A professional setup at AED 9,999 to start plus AED 800 per month gives you all 3 reports automatically from your daily purchase transactions. The first quarterly review will surface at least AED 20K in negotiation opportunities. If your total score is below 5, your purchasing team is making AED 4M in annual decisions without the analytics to inform them. That's not their fault. It's a systems gap with a known solution.
Ready to run on a real system?
Book a 15 minute call. We will show you exactly how OSForBiz replaces the spreadsheet chaos.