A procurement report can display a total without explaining why it changed. If expenditure rose this month, prices may have increased, quantities may be higher or the organisation may have purchased a different mix of products. These situations call for different decisions. Useful spend analysis separates the causes rather than treating every change as a price problem.
State what the dataset represents
Quotation value, order value and actual payment are not interchangeable. A supplier may have submitted an offer that was never selected. An order may exist without being completed. Begin the report with its source, date range, currency and included statuses.
The Open Contracting Data Standard connects different public contracting stages through a common process identifier. A useful design lesson for private companies is to preserve the references connecting requisitions, sourcing events and orders. This is an analytical recommendation, not a claim that Tenflex implements OCDS. Without those references, combining exports can create duplicate or unmatched records.
Start with three business questions
- Where is money concentrated? Examine category and supplier totals, after checking whether the same business appears under several names.
- Where is competition limited? Read invitation and quotation counts together. Low participation may require a review of contacts or specifications before another sourcing event.
- Where does time accumulate? If the relevant timestamps are available, separate the intervals between requisition, approval, publication and decision.
Choose a small set of measures that the team can explain and reproduce. Adding another dashboard does not resolve an unclear definition of the underlying data.
Keep the savings baseline visible
Consider an illustrative purchase of 1,000 units. The reference unit price is TRY 120 and the selected offer is TRY 114. For the same scope, the difference is TRY 6,000, or five percent of the reference amount. If the quantity rises to 1,500 units, total expenditure still increases. A price improvement and a reduction in spending are different results.
Document how transport, exchange rates and payment conditions are treated. Do not describe a reduction from the opening quotation as savings against the previous purchase price. A reader should be able to reproduce the calculation and identify its denominator. Otherwise, two departments may report different savings for the same event without either noticing the mismatch.
Turn the finding into an action
“Spend is concentrated in three suppliers” is a finding, not an action. Identify which items require alternatives, who will investigate them and when the team will review the result. At the next meeting, examine what changed rather than simply presenting the same chart again.
Tenflex's quotation report provides prices and savings information, while usage exports can support your own analysis. Match additional sources separately when reviewing order values or actual expenditure. Start with the question the available evidence can answer instead of deriving a comprehensive performance score from incomplete records.
