By choosing 'Product Performance' in the menu bar under 'Reports', the organisation's
'Product Performance' will appear.
Choose a 'Date Range' and the desired currency to gain insight into the purchasing
performance during a period.
To obtain the desired product performance report, you need to make a selection. The
selection can be made using some filters.
- Unfinished Product; when 'Include' is selected for this option, products that are
considered incomplete are also displayed. Selecting 'Exclude' will omit these
products. - Suppliers; by filtering on one or more suppliers, the values of the chosen supplier(s) are displayed. This allows you to see a weighted average cost price calculation and purchase price per supplier within your chosen period.
- Tags; it is also possible to filter by 'Tags' (labels). By selecting one or more 'Tags', a product performance report will be built based on these criteria.
- Products; it is possible to select from all products created in the WTP application.
Thus, you can still create a product performance report for a specific selection of
various products.
The moment you have selected your desired filter(s), simply click 'Go' to generate the
desired product performance report.
There is also the option to save or print the report in Pdf. To do so, click the ´PDF´ button.
Next, you can choose from the drop-down menu whether you want to print or save the
report.
Procurement Performance: Average price/unit paid vs average WTP price
The screen below displays, for the selected filters and time period, in blue the weighted
average (historical) purchase price and in red the weighted average (theoretical) WTP cost
price.
In this example, we can clearly see that over the past few years, the average cost price of
the selected supplier has decreased. However, we see that the supplier has not reduced
their selling prices to the same extent. The difference between the red and blue line has
been increasing over time. This is a good indication of a possible margin improvement on
the side of this supplier.
Should the two lines manage to grow closer to each other, it could be fairly objectively
established that, with regard to the price aspect, they have managed to buy increasingly
well and thus achieve good negotiation results.
